write csv file in python pandas 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: how to write csv from a dataframe pythin
df.to_csv('file_name.csv')
Example 4: how to save a dataframe into an csv file
df.to_csv('file_name.csv', index=False)
Example 5: csv python write
import csv
with open('names.csv', 'w') as csvfile:
fieldnames = ['first_name', 'last_name']
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
writer.writeheader()
writer.writerow({'first_name': 'Baked', 'last_name': 'Beans'})
writer.writerow({'first_name': 'Lovely', 'last_name': 'Spam'})
writer.writerow({'first_name': 'Wonderful', 'last_name': 'Spam'})
Example 6: pandas to_csv delimiter
df.to_csv('modified.txt', index=False, sep='\t')