csv to df python code example

Example 1: python save df to csv

df.to_csv(r'/directory/path/file_name.csv', index = False, header = True)

Example 2: how to save a dataframe into an csv file

df.to_csv('file_name.csv', index=False)

Example 3: pandas to_csv delimiter

df.to_csv('modified.txt', index=False, sep='\t')

Example 4: pandas read csv

import pandas as pd
cereal_df = pd.read_csv("/tmp/tmp07wuam09/data/cereal.csv")
cereal_df2 = pd.read_csv("data/cereal.csv")

# Are they the same?
print(pd.DataFrame.equals(cereal_df, cereal_df2))

Example 5: convert csv to pandas dataframe

import pandas as pd
df = pd.read_csv("sample_data.csv")

# .csv file format
column1,column2
1,2
3,4
5,6

# pandas dataframe
   column1  column2
0        1        2
1        3        4
2        5        6

Example 6: readv csv pandas

>>> pd.read_csv('data.csv')