csv to df 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: save dataframe to csv

df.to_csv(file_name, sep='\t')

Example 4: to_csv drop index

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

Example 5: how to set up dataframe from csv

import pandas as pd

column_names = ['sepel lengh', 'sepel width', 'petal lengh', 'petal width', 'class']
iris = pd.read_csv('iris.csv', names=column_names)

print(iris)

Example 6: df to csv

>>> df = pd.DataFrame({'name': ['Raphael', 'Donatello'],
...                    'mask': ['red', 'purple'],
...                    'weapon': ['sai', 'bo staff']})
>>> df.to_csv(index=False)