Python: Create an object for writing and iterate over the rows to print the values

Last update on December 21 2024 07:25:34 (UTC/GMT +8 hours)

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.