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')