How to write list of lists to CSV file Python?

Question

I have a list of lists like [('a', 'b', 'c'), ('d', 'e', 'f'),....]. I want to write it to a CSV file like this-

a,   b,   c
d,   e,   f

How do I do that?

I've tried using csv.writerows but the output file had each character in different cells and all together in same row. In the sense, the cells in row one had ' a ' ' b ' etc.

Thanks.

If I understand your last part right, do you want a b c, d e f,? — thegrinner
– thegrinner, Commented May 9, 2014 at 20:58
could you write for lst in wholeList: csv.writerow(lst)? This yould write every row in another line of the file (or at least i think so). — Sirac
– Sirac, Commented May 9, 2014 at 20:58

Martijn Pieters · Accepted Answer · 2014-05-09 21:00:50Z

7

Use writer.writerows() (plural, with s) to write a list of rows in one go:

>>> import csv
>>> import sys
>>> data = [('a', 'b', 'c'), ('d', 'e', 'f')]
>>> writer = csv.writer(sys.stdout)
>>> writer.writerows(data)
a,b,c
d,e,f

answered May 9, 2014 at 21:00

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

Comments

marillion · Accepted Answer · 2014-05-09 21:21:00Z

3

If you have Pandas, it's pretty easy and fast. I assume you have a list of tuples called "data".

import pandas as pd
data = [('a', 'b', 'c'), ('d', 'e', 'f')]
df = pd.DataFrame(data)
df.to_csv('test.csv', index=False, header=False)

done!

EDIT: "list of lists" -> "list of tuples"

edited May 9, 2014 at 21:21

answered May 9, 2014 at 21:04

marillion

11.3k21 gold badges51 silver badges64 bronze badges

1 Comment

user3614557 Over a year ago

Perfect! Thank you and everyone very much for responding.

Collectives™ on Stack Overflow

How to write list of lists to CSV file Python?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related