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:
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:
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.
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
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics