Python: Create an object for writing and iterate over the rows to print the values
Python CSV File Reading and Writing: Exercise-9 with Solution
Write a Python program to create an object for writing and iterate over the rows to print the values.
Sample Solution:
Python Code :
import csv
import sys
with open('temp.csv', 'wt') as f:
writer = csv.writer(f)
writer.writerow(('id1', 'id2', 'date'))
for i in range(3):
row = (
i + 1,
chr(ord('a') + i),
'01/{:02d}/2019'.format(i + 1),)
writer.writerow(row)
print(open('temp.csv', 'rt').read())
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:
id1,id2,date 1,a,01/01/2019 2,b,01/02/2019 3,c,01/03/2019
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Python program that reads each row of a given csv file and skip the header of the file. Also print the number of rows and the field names.
Next: 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.
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/csv/python-csv-exercise-9.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics