Write a list of lists into csv in Python [duplicat

Question

This question already has an answer here:

• Writing a Python list of lists to a csv file 9 answers

I have a list of lists of pure data like this

a=[[1,2,3],
   [4,5,6],
   [7,8,9]]

How can I write a into a CSV file with each list in a column like this?

1 4 7 
2 5 8
3 6 9

Answer 1

Use:

import csv
with open('output.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerows(list(zip(*l)))

Answer 2

Try this:

import csv
with open('output.csv', 'w', newline='') as f:
    writer = csv.writer(f, delimiter=' ')
    writer.writerows(a)