Answers for "dataframe tocsv"

df to csv

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

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