Python write list to csv

View Discussion

Improve Article

Save Article

  • Read
  • Discuss
  • View Discussion

    Improve Article

    Save Article

    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:

    Python write list to csv
    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:

    Python write list to csv
    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:

    Python write list to csv


    How do I convert a list to a CSV file in Python?

    To convert a list of lists to csv in python, we can use the csv. writer() method along with the csv. writerow() method.

    How do I make a list into a csv file?

    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.

    Can you write directly to a csv file in Python?

    In Python, you can use the CSV writer's writerows() function to write multiple rows into a CSV file on the same go.

    How do I write to column wise in a csv file in Python?

    How to write a CSV file by column in Python.
    list_1 = ["Hello", "World", "Monty", "Python"].
    list_2 = [1, 2, 3, 4].
    file = open("columns.txt", "w").
    writer = csv. writer(file).
    for w in range(4): iterate through integers 0-3..
    writer. writerow([list_1[w], list_2[w]]).
    file. close().