Writing 2 Lists of Floats to a CSV File in Separate Columns

Question

I have a program that creates two very large lists of float numbers.

We can call them list_x and list_y. They look like this:

list_x = [0.555, 0.5552, 0.55553]
list_y = [0.152, 0.155, 0.160]

I want it two be stored into a csv like this:

Column 1  Column 2
0.555      0.152
0.5552     0.155
0.55553    0.160

Here is my code:

with open('data.csv','w', newline = '') as out:
        csv.writer(out, delimiter=' ', quoting=csv.QUOTE_MINIMAL).writerows(zip(list_x, list_y))

However, it prints it like this instead:

Column 1
0.555   0.152
0.5552  0.155
0.55553 0.160

And no column 2.

Thanks.

Thorsten Kranz · Accepted Answer · 2013-06-05 04:58:56Z

1

When I try your code, I do not get any header line.

One solution would be to explicitly add headers to the list of items to be written, e.g.,

headers = [("Column 1", "Column 2")]
with open('data.csv','w', newline = '') as out:
    csv.writer(out, delimiter=' ', quoting=csv.QUOTE_MINIMAL).writerows(headers + zip(list_x, list_y))

answered Jun 5, 2013 at 4:58

Thorsten Kranz

12.8k2 gold badges45 silver badges57 bronze badges

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

1 Comment

ratman2050 Over a year ago

Sorry there are no headers in the file I just wanted to show that I wanted them in 2 columns

Chubby Boy · Accepted Answer · 2013-06-05 04:52:12Z

0

Because you are using delimiter as ' ' [delimiter=' ']. so it splits 'Column 1' itself as 'Column' and '1', two separate headers.

answered Jun 5, 2013 at 4:52

Chubby Boy

31.1k19 gold badges49 silver badges47 bronze badges

2 Comments

Burhan Khalid Over a year ago

Or, change the delimiter to \t

ratman2050 Over a year ago

Thanks, I just removed the delimiter and it made 2 columns, thanks! \t does not work by the way

Collectives™ on Stack Overflow

Writing 2 Lists of Floats to a CSV File in Separate Columns

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related