How to write a tuple of tuples to a CSV file using Python

Question

I have a tuple of tuples

import csv
A = (('Max', 3 ,' M'),('bob',5,'M'),('jane',6,'F'))
result = open("newfile.csv",'wb')
writer = csv.writer(result, dialect = 'excel')
writer.writerow(A)
result.close

This writes a CSV file with rows with A[0], A[1] and A[2] . What i want is a row with name, age and gender , which has the corresponding values .

you want one row with 3 columns, each for name, age and gender, and you're getting one column with all three inside? — milan
– milan, Commented Dec 31, 2011 at 10:31

eumiro · Accepted Answer · 2011-12-31 10:47:49Z

11

Write all rows at once:

writer.writerows(A)

instead of

writer.writerow(A)

File newfile.csv looks now like this:

Max,3, M
bob,5,M
jane,6,F

Also, add () to your last line, it is a function call: result.close().

If you are on Python 2.6 or newer, you can use this form:

import csv
A = (('Max', 3, 'M'),('bob', 5, 'M'),('jane', 6, 'F'))
with open('newfile.csv', 'wb') as result:
    writer = csv.writer(result, dialect='excel')
    writer.writerows(A)

edited Dec 31, 2011 at 10:47

answered Dec 31, 2011 at 10:32

eumiro

214k36 gold badges307 silver badges264 bronze badges

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

2 Comments

Katriel Over a year ago

Equivalently, for row in A: writer.writerow(A). But since you're constructing A upfront you might as well use writerows.

T I Over a year ago

+1 I was doing it like csv.writer(f).writerows([x for x in a]) I'm off to rtfm :-)

prongs · Accepted Answer · 2011-12-31 10:33:09Z

0

Not sure if I understand you fully but I think this will help :

    print >>f, "\n".join([",".join(x) for x in A]);

answered Dec 31, 2011 at 10:33

prongs

9,62622 gold badges72 silver badges105 bronze badges

4 Comments

eumiro Over a year ago

Profit from the csv, don't reinvent the wheel with this construct (imagine one field being "Max,Happy" would break your CSV file)

prongs Over a year ago

Is csv pre-installed with python?

eumiro Over a year ago

it belongs to the Python Standard Library docs.python.org/library/fileformats.html

Viv_bio Over a year ago

CSV is inbuilt in Python 2.3 onwards

Collectives™ on Stack Overflow

How to write a tuple of tuples to a CSV file using Python

2 Answers 2

2 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related