Write a list of lists into csv in Python [duplicate]

Question

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

make a Transpose of your DataFrame a=[[1,2,3],[4,5,6],[7,8,9]]; df = pd.DataFrame(a).T; df.to_csv("output.csv",index=False,header=False) — patelnisheet
– patelnisheet, Commented Jan 29, 2019 at 8:32

U13-Forward · Accepted Answer · 2019-01-29 07:53:18Z

2

Use:

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

answered Jan 29, 2019 at 7:39

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mehrdad Pedramfar · Accepted Answer · 2019-01-29 07:49:40Z

1

Try this:

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

answered Jan 29, 2019 at 7:49

Mehrdad Pedramfar

11.1k4 gold badges43 silver badges61 bronze badges