Python: Python list of lists to a csv file and display the content

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

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.

Sample Solution:

Python Code :

import csv
data = [[10,'a1', 1], [12,'a2', 3], [14, 'a3', 5], [16, 'a4', 7], [18, 'a5', 9]]
with open("temp.csv", "w", newline="") as f:
   writer = csv.writer(f)
   writer.writerows(data)
with open('temp.csv', newline='') as csvfile:
 data = csv.reader(csvfile, delimiter=' ')
 for row in data:
   print(', '.join(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:

10,a1,1
12,a2,3
14,a3,5
16,a4,7
18,a5,9

Python Code Editor:

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

Previous: Write a Python program to create an object for writing and iterate over the rows to print the values.
Next: 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.