how to generate a 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

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.

Code answers related to "how to generate a csv file in python"

Code answers related to "Python"

Browse Popular Code Answers by Language

Answers for "how to generate a csv file in python"

Code answers related to "how to generate a 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