Save list values in csv file with Python

Question

I have a Python simple list like this one:

a = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16]

I want to save it in a csv file that looks like this:

1,2,3,4,5,6,7,8
9,10,11,12,13,14,15,16

How can I do that? I tried:

np.savetxt('fname.csv', bbox_form, fmt='%d')

But I don't know how to write a new line only after 8 values.

What does a = np.reshape(a, (-1, 8)) do? If it doesn't throw errors, save that. — cs95
– cs95, Commented May 1, 2018 at 18:55

Achu · Accepted Answer · 2018-05-01 19:10:11Z

1

col_num=8
row_num=len(a)/col_num
b=np.reshape(a, [row_num,col_num])
d=[','.join(map(str,c)) for c in b]
np.savetxt('fname.csv', d, fmt='%s')

This should work

answered May 1, 2018 at 19:10

Achu

2722 silver badges10 bronze badges

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

Comments

James Smith · Accepted Answer · 2018-05-01 19:02:13Z

0

Numpy will save each "row" in your array to a line. If you want to save it to multiple lines, then you'll need to reshape your array.

answered May 1, 2018 at 19:02

James Smith

313 bronze badges