How to Create CSV File in Python?
This detailed guide will cover how to create csv file in python. I am going to show you about python create csv file example. I would like to share with you python writing csv file example. This article will give you a simple example of python output to csv file example. Alright, let us dive into the details.
In this example, we will create demo.csv file with ID, Name and Email fields. we will use open(), writer(), writerow(), writerows() and close() functions to create csv file. we will use functions for the following reasons.
open(): it will create csv file if not exist.
writer(): it will create csv file object for write new rows.
writerow(): it will write single row with heading.
writerows(): it will write multiple rows with list.
close(): it will close created new csv file object.
Now, you can see below simple code and output:
You can use these examples with python3 (Python 3) version.
import csv # open the file in the write mode f = open('demo.csv', 'w') # create the csv writer writer = csv.writer(f) header = ['ID', 'Name', 'Email'] data = [ [1, 'Hardik Savani', 'firstname.lastname@example.org'], [2, 'Vimal Kashiyani', 'email@example.com'], [3, 'Harshad Pathak', 'firstname.lastname@example.org'], ] # write the header writer.writerow(header) # write a row to the csv file writer.writerows(data) # close the file f.close()
You can see csv file layout:
I hope it can help you...
We are Recommending you
- How to Read Text File Line by Line in Python?
- How to Append Text or Lines to a Text File in Python?
- Python Create Text File If Not Exists Example
- How to Reverse List Elements in Python?
- Python Create an Empty Text File Example
- Python List Add Element at Beginning Example
- Python List Print All Elements Except First Example
- How to Get Max Value from Python List?
- Python Get First Date of Last Month Example
- How to Add Minutes to DateTime in Python?
- Python POST Request with Parameters Example
- Python GET Request with Parameters Example
- Python Get Day Name from Number Example