w3resource

Python: Write dictionaries and a list of dictionaries to a given CSV file

Python module: Exercise-7 with Solution

Write a Python program to write dictionaries and a list of dictionaries to a given CSV file. Use csv.reader

Sample Solution:

Python Code:

import csv
print("Write dictionaries to a CSV file:")
fw = open("test.csv", "w", newline='')
writer = csv.DictWriter(fw, fieldnames=["Name", "Class"])
writer.writeheader()
writer.writerow({"Name": "Jasmine Barrett", "Class": "V"})
writer.writerow({"Name": "Garry Watson", "Class": "V"})
writer.writerow({"Name": "Courtney Caldwell", "Class": "VI"})
fw.close()
fr = open("test.csv", "r")
csv = csv.reader(fr, delimiter = ",")
for row in csv:
  print(row) 
fr.close()

Sample Output:

Write dictionaries to a CSV file:
['Name', 'Class']
['Jasmine Barrett', 'V']
['Garry Watson', 'V']
['Courtney Caldwell', 'VI']

Flowchart:

Flowchart: Write dictionaries and a list of dictionaries to a given CSV file.
import csv
print("\nWrite a list of dictionaries to a CSV file:")
fw = open("test1.csv", "w", newline='')
writer = csv.DictWriter(fw, fieldnames=["Name", "Class"])
writer.writeheader()
writer.writerows(
    [{"Name": "Jasmine Barrett", "Class": "V"},
    {"Name": "Garry Watson", "Class": "V"},
    {"Name": "Courtney Caldwell", "Class": "VI"}])
fw.close()
fr = open("test1.csv", "r")
csv = csv.reader(fr, delimiter = ",")
for row in csv:
  print(row) 
fr.close()

Sample Output:

Write a list of dictionaries to a CSV file:
['Name', 'Class']
['Jasmine Barrett', 'V']
['Garry Watson', 'V']
['Courtney Caldwell', 'VI']

Flowchart:

Flowchart: Write dictionaries and a list of dictionaries to a given CSV file.

Python Code Editor:


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Python program to write (without writing separate lines between rows) and read a CSV file with specified delimiter.
Next: Python built-in Modules Exercise Home.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://w3resource.com/python-exercises/modules/python-module-csv-exercise-7.php