w3resource

Python: Python dictionary to a csv file and display the content

Python CSV File Reading and Writing: Exercise-11 with Solution

Write a Python program to write a Python dictionary to a csv file. After writing the CSV file read the CSV file and display the content.

Sample Solution:

Python Code :

import csv
csv_columns = ['id','Column1', 'Column2', 'Column3', 'Column4', 'Column5']
dict_data = {'id':['1', '2', '3'],
    'Column1':[33, 25, 56],
    'Column2':[35, 30, 30],
    'Column3':[21, 40, 55],
    'Column4':[71, 25, 55],
    'Column5':[10, 10, 40], }
csv_file = "temp.csv"
try:
   with open(csv_file, 'w') as csvfile:
       writer = csv.DictWriter(csvfile, fieldnames=csv_columns)
       writer.writeheader()
       for data in dict_data:
           writer.writerow(dict_data)
except IOError:
   print("I/O error")
data = csv.DictReader(open(csv_file))
print("CSV file as a dictionary:\n")
for row in data:
   print(row)

temp.csv

"country_id"|"country_name"|"region_id"
"AR"|"Argentina"| 2
"AU"|"Australia"| 3
"BE"|"Belgium"| 1
"BR"|"Brazil"| 2
"CA"|"Canada"| 2

Sample Output:

CSV file as a dictionary:

OrderedDict([('id', "['1', '2', '3']"), ('Column1', '[33, 25, 56]'), ('Column2', '[35, 30, 30]'), ('Column3', '[21, 40, 55]'), ('Column4', '[71, 25, 55]'), ('Column5', '[10, 10, 40]')])
OrderedDict([('id', "['1', '2', '3']"), ('Column1', '[33, 25, 56]'), ('Column2', '[35, 30, 30]'), ('Column3', '[21, 40, 55]'), ('Column4', '[71, 25, 55]'), ('Column5', '[10, 10, 40]')])
OrderedDict([('id', "['1', '2', '3']"), ('Column1', '[33, 25, 56]'), ('Column2', '[35, 30, 30]'), ('Column3', '[21, 40, 55]'), ('Column4', '[71, 25, 55]'), ('Column5', '[10, 10, 40]')])
OrderedDict([('id', "['1', '2', '3']"), ('Column1', '[33, 25, 56]'), ('Column2', '[35, 30, 30]'), ('Column3', '[21, 40, 55]'), ('Column4', '[71, 25, 55]'), ('Column5', '[10, 10, 40]')])
OrderedDict([('id', "['1', '2', '3']"), ('Column1', '[33, 25, 56]'), ('Column2', '[35, 30, 30]'), ('Column3', '[21, 40, 55]'), ('Column4', '[71, 25, 55]'), ('Column5', '[10, 10, 40]')])
OrderedDict([('id', "['1', '2', '3']"), ('Column1', '[33, 25, 56]'), ('Column2', '[35, 30, 30]'), ('Column3', '[21, 40, 55]'), ('Column4', '[71, 25, 55]'), ('Column5', '[10, 10, 40]')])

Python Code Editor:


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

Previous: Write a Python program to write a Python list of lists to a csv file. After writing the CSV file read the CSV file and display the content.

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://198.211.115.131/python-exercises/csv/python-csv-exercise-11.php