convert df to csv 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 write csv from a dataframe pythin

df.to_csv('file_name.csv')

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

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

Example 4: save dataframe to csv

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

Example 5: df to csv

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

Example 6: saving a pandas dataframe as a csv

df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv', index = False)