how to make csv file in python

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 directory

Posted by: Guest on February-24-2020

Source

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

header = [re.sub(' +',' ',i[0][:-1].replace('n', ' ')) for i in optionsTable[0]] with open('test.csv', 'w') as fp: writer = csv.writer(fp, delimiter=',') writer.writerow(header) for row in optionsTable: writer.writerow([i[1] for i in row]) #Credit to https://stackoverflow.com/users/790387/burhan-khalid Burhan Khalid #On StackOverflow.

import csv with open('employee_file.csv', mode='w') as employee_file: employee_writer = csv.writer(employee_file, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL) employee_writer.writerow(['John Smith', 'Accounting', 'November']) employee_writer.writerow(['Erica Meyers', 'IT', 'March'])

Code answers related to "how to make csv file in python"

Code answers related to "Python"

Browse Popular Code Answers by Language

Answers for "how to make csv file in python"

Code answers related to "how to make csv file in python"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us