Python adding integer lists as columns to CSV

Question

I have 3 lists of integers in format:

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

I am trying to enter these into a CSV file in the following format, with each item in each list taking a row and each list taking a new column:

1  4  7
2  5  8
3  6  9

Currently my code(below) is able to add the first list into the CSV, although i am having trouble adding the second and third lists in the way i wish.

with open('Test.csv', 'wb') as f:
    for item in a:
        csv.writer(f).writerow([item])

Gives CSV Output:

1
2
3

If i simply use the following code the b list is added to the same column, i require it to be inserted into the second column:

for itemB in b:
        csv.writer(f).writerow([itemB])

Gives CSV Output:

How can i achieve this?

Eric · Accepted Answer · 2013-02-09 22:21:08Z

3

zip(a, b, c) gives you a list of rows: [(1, 4, 7), (2, 5, 8), (3, 6, 9)]

with open('Test.csv', 'wb') as f:
    w = csv.writer(f)
    for row in zip(a, b, c):
        w.writerow(row)

answered Feb 9, 2013 at 22:21

Eric

98.1k54 gold badges257 silver badges389 bronze badges

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

1 Comment

DSM Over a year ago

To get closer to the OP's output I think you might have to specify the delimiter.

dawg · Accepted Answer · 2013-02-10 01:02:03Z

0

This works:

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

with open('/tmp/test.csv','wb') as out:
    for row in zip(a,b,c):
        csv.writer(out, delimiter=' ').writerow(row)

or even:

with open('/tmp/test.csv','wb') as out:
    csv.writer(out, delimiter=' ').writerows(zip(a,b,c))

Output:

$ cat /tmp/test.csv
1 4 7
2 5 8
3 6 9

edited Feb 10, 2013 at 1:02

answered Feb 9, 2013 at 22:47

dawg

105k24 gold badges142 silver badges217 bronze badges

1 Comment

sotapme Over a year ago

For brevity you could replace your last two lines with csv.writer(out, delimiter=' ').writerows(zip(a,b,c))

Collectives™ on Stack Overflow

Python adding integer lists as columns to CSV

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related