panda dataframe to csv code example
Example 1: code how pandas save csv file
df.to_csv('out.csv')
Example 2: save pandas into csv
df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv', index = False)
Example 3: save dataframe to csv
df.to_csv(file_name, sep='\t')
Example 4: df to csv
>>> df = pd.DataFrame({'name': ['Raphael', 'Donatello'],
... 'mask': ['red', 'purple'],
... 'weapon': ['sai', 'bo staff']})
>>> df.to_csv(index=False)
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: write to csv pandas
df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv', index = False)
Source:datatofish.com