python save df to csv
df.to_csv(r'/directory/path/file_name.csv', index = False, header = True)python save df to csv
df.to_csv(r'/directory/path/file_name.csv', index = False, header = True)create csv file python
# This action requires the 'csv' module
import csv
# The basic usage is to first define the rows of the csv file:
row_list = [["SN", "Name", "Contribution"],
[1, "Linus Torvalds", "Linux Kernel"],
[2, "Tim Berners-Lee", "World Wide Web"],
[3, "Guido van Rossum", "Python Programming"]]
# And then use the following to create the csv file:
with open('protagonist.csv', 'w', newline='') as file:
writer = csv.writer(file)
writer.writerows(row_list)
# This will create a csv file in the current directoryhow to write csv from a dataframe pythin
df.to_csv('file_name.csv')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'})download dataframe as csv
df.to_csv(r'Path where you want to store the exported CSV file\File Name.csv')Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
