Answers for "csv to df pd"

write dataframe to csv

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

from csv to pandas dataframe

df = pd.read_csv('data.csv')

save dataframe to csv

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

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