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

Last update on March 31 2025 12:51:38 (UTC/GMT +8 hours)

10. List to CSV and Read

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

For more Practice: Solve these Related Problems:

• Write a Python program to write a list of lists to a CSV file, then read the file back into a list and print the content.
• Write a Python script to export a list of lists to a CSV file, append a header row, and then verify the file by reading its contents.
• Write a Python program to write a multi-dimensional list to a CSV file, and afterwards, read and display only the first 5 rows.
• Write a Python function to save a list of lists to a CSV file and then load the file to check if the written data matches the original list.

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.