Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

Writing data from a Python List to CSV row-wise

  • Difficulty Level : Expert
  • Last Updated : 26 Mar, 2020

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.

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course




# Importing library
import csv
  
# data to be written row-wise in csv fil
data = [['Geeks'], [4], ['geeks !']]
  
# opening the csv file in 'w+' mode
file = open('g4g.csv', 'w+', newline ='')
  
# writing the data into the file
with file:    
    write = csv.writer(file)
    write.writerows(data)

Output:

Example 2:
Writing data row-wise into an existing CSV file using DictWriter class.






# importing library
import csv
  
# opening the csv file in 'w' mode
file = open('g4g.csv', 'w', newline ='')
  
with file:
    # identifying header  
    header = ['Organization', 'Established', 'CEO']
    writer = csv.DictWriter(file, fieldnames = header)
      
    # writing data row-wise into the csv file
    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.




# Importing library
import csv
  
# data to be written row-wise in csv fil
data = [['Geeks for Geeks', '2008', 'Sandeep Jain'],
        ['HackerRank', '2009', 'Vivek Ravisankar']]
  
# opening the csv file in 'a+' mode
file = open('g4g.csv', 'a+', newline ='')
  
# writing the data into the file
with file:    
    write = csv.writer(file)
    write.writerows(data)

Output:




My Personal Notes arrow_drop_up
Recommended Articles
Page :