Save lists to csv as columns in python

Question

I have three list that I'd like to write to .csv file, where each list is written as a column. Example:

x = [0,1,2,3,4]
y = [0,1,4,9,16]
z = [1,1,1,1,1]

The file would then have the structure:

I don't mind if what the delimiter is. Tabs, commas etc is fine.

I've tried something like:

numpy.savetxt('file.csv',zip(x,y,z))

But this just creates a 1D list with alternating values of x, y and z, I thought it would work?

Thanks

ettanany · Accepted Answer · 2017-07-28 08:40:59Z

1

You can do it like below:

import csv

with open('file.csv', 'wb') as csvfile:
    writer = csv.writer(csvfile, delimiter=',')
    for i, j, k in zip(x, y, z):
        writer.writerow((i, j, k))

Result:

>>> with open('file.csv', 'r') as csvfile:
...     print(csvfile.read())
...
0,0,1
1,1,1
2,4,1
3,9,1
4,16,1

answered Jul 28, 2017 at 8:40

ettanany

20k9 gold badges49 silver badges64 bronze badges

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

3 Comments

rh1990 Over a year ago

This is great! Thanks

ettanany Over a year ago

@RichardHall You're welcome, don't forget to accept it as answer to your question :)

rh1990 Over a year ago

Just did, was waiting for the 10min timer :)

Collectives™ on Stack Overflow

Save lists to csv as columns in python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related