How to write a pandas DataFrame to CSV file

You can simply export your Pandas DataFrame to a CSV file using:

df.to_csv(file_name)

Delimit by a tab you can use the sep argument .

df.to_csv('D:\panda.csv',sep='\t')

Avoid index column use index argument .

df.to_csv('D:\panda.csv',sep='\t',index=False)

Use a specific encoding (e.g. 'utf-8' ) use the encoding argument .

df.to_csv('D:\panda.csv',sep='\t',encoding='utf-8')

Avoid Header row use header argument .

df.to_csv('D:\panda.csv',sep='\t',header=False)

Append a DataFrame content to already existing .csv file , use mode argument .

df.to_csv('D:\panda.csv',sep='\t',header=False, mode='a')

Related Topics