Numpy array to csv

Question

I have a np array with 1000 rows, and 4608 columns each rows

I try to save a csv file with:

myfile = open('dataset.csv', 'wb')
wr = csv.writer(myfile,delimiter='\n')
wr.writerow(Prueba[0])

But if I open the csv file with LibreOffice this:

[153 147 147 ..., 142 147 146]  
[183 247 147 ..., 126 123 104]
...

No apears the 4608 columns!!

Some idea?

Thank you!

Regards, Andres.

Jeremy Barnes · Accepted Answer · 2016-08-03 15:25:29Z

8

Try this.

numpy.savetxt("FILENAME.csv", a, delimiter=",")

Where filename is your filename and a is your array.

answered Aug 3, 2016 at 15:25

Jeremy Barnes

6622 gold badges9 silver badges25 bronze badges

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

3 Comments

Andrés Fernández Over a year ago

Thanks Jeremy, but This return the next error: TypeError: Mismatch between array dtype ('object') and format specifier ('%.18e')

Julien Spronck Over a year ago

If all numbers are int, you can add the option fmt='%d'

Andrés Fernández Over a year ago

Thanks Julien. All numbers are type <type 'numpy.uint8'>, I try its in then: TypeError: Mismatch between array dtype ('object') and format specifier ('%d')

Francesco Nazzaro · Accepted Answer · 2016-08-03 15:41:42Z

1

The type of the array and the fmt option must match. Try:

import numpy as np

np.savetxt('dataset.csv', array.astype(np.int), fmt='%d', delimiter=',')

where array is your numpy array.

answered Aug 3, 2016 at 15:41

Francesco Nazzaro

2,93614 silver badges21 bronze badges

Collectives™ on Stack Overflow

Numpy array to csv

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related