Writing data from a Python List to CSV row-wise
Comma Separated Values (CSV) files a type of a plain text document in which tabular information is structured using a particular format. A CSV file is a bounded text format which uses a comma to separate values. The most common method to write data from a list to CSV file is the writerow() method of writer and DictWriter class. Example 1: Creating a CSV file and writing data row-wise into it using writer class.
Python3
import csv
data = [[ 'Geeks' ], [ 4 ], [ 'geeks !' ]]
file = open ( 'g4g.csv' , 'w+' , newline = '')
with file :
write = csv.writer( file )
write.writerows(data)
|
Output: Example 2: Writing data row-wise into an existing CSV file using DictWriter class.
Python3
import csv
file = open ( 'g4g.csv' , 'w' , newline = '')
with file :
header = [ 'Organization' , 'Established' , 'CEO' ]
writer = csv.DictWriter( file , fieldnames = header)
writer.writeheader()
writer.writerow({ 'Organization' : 'Google' ,
'Established' : '1998' ,
'CEO' : 'Sundar Pichai' })
writer.writerow({ 'Organization' : 'Microsoft' ,
'Established' : '1975' ,
'CEO' : 'Satya Nadella' })
writer.writerow({ 'Organization' : 'Nokia' ,
'Established' : '1865' ,
'CEO' : 'Rajeev Suri' })
|
Output: Example 3: Appending data row-wise into an existing CSV file using writer class.
Python3
import csv
data = [[ 'Geeks for Geeks' , '2008' , 'Sandeep Jain' ],
[ 'HackerRank' , '2009' , 'Vivek Ravisankar' ]]
file = open ( 'g4g.csv' , 'a+' , newline = '')
with file :
write = csv.writer( file )
write.writerows(data)
|
Output:
Last Updated :
04 May, 2022
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...