w3resource

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


9. CSV Write Object Iterate

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

For more Practice: Solve these Related Problems:

  • Write a Python program to create a CSV writer object, iterate over a list of lists, and print each row before writing them to a file.
  • Write a Python script to open a CSV file for writing, iterate through a data list, and print each row's values to the console as they are written.
  • Write a Python program to create an object for writing to a CSV file and then iterate over rows of data, applying a transformation before printing.
  • Write a Python script to initialize a CSV writer, loop through a series of rows, print the row data, and then write the data to a new CSV file.

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.



Follow us on Facebook and Twitter for latest update.