numpy savetxt formatted as integer is not saving zeroes

Question

I am trying to save numpy.array to .csv in the following way.

with open("resultTR.csv", "wb") as f:
    f.write(b'ImageId,Label\n')
    numpy.savetxt(f, result, fmt='%i', delimiter=",")

result is numpy.array that consists of two columns, first column are indices (numbers 1 through n) and second column values from (0,9).

Unfortunately I have problem that whenever there is 0 in the second column then nothing is written to the resulting .csv file in the second column.

In other words first five rows of array looks like this:

[[  1.00000000e+00   2.00000000e+00]
 [  2.00000000e+00   0.00000000e+00]
 [  3.00000000e+00   9.00000000e+00]
 [  4.00000000e+00   9.00000000e+00]
 [  5.00000000e+00   3.00000000e+00]

And first five rows of .csv file like this:

ImageId,Label
1,2
2
3,9
4,9
5,3

It looks to me like my code should work and thus not saving zeroes seems to me very weird. Does anyone have some idea what can possibly be wrong with my code for writing to .csv file?

EDIT:

Just for compleetnes my python version is 2.7.2 and it's running on Mac OS X 10.9.2

Well, on my machine your code works fine. Could you try using `%d` instead of `%i`? There are some subtle differences inherited from C, and that could explain the different behaviour on my machine. See [this](http://stackoverflow.com/questions/1893490/difference-between-format-specifiers-i-and-d-in-printf) — gg349, Mar 21 '14 at 11:34
I've tried it out, but unfortunately it's not working for me. I've tried also %u, but the result is still the same. — ziky90, Mar 21 '14 at 14:23

score 55 · Accepted Answer · answered Mar 22 '14 at 20:13

55

I would try saving the array as an int array, as in result.astype(int), or in full:

with open("resultTR.csv", "wb") as f:
    f.write(b'ImageId,Label\n')
    numpy.savetxt(f, result.astype(int), fmt='%i', delimiter=",")

answered Mar 22 '14 at 20:13

askewchan

45,161
17
118
134

score 5 · Answer 2 · answered Jun 25 '21 at 21:33

5

A cleaner solution is using the argument fmt='%s'.

with open("resultTR.csv", "wb") as f:
   f.write(b'ImageId,Label\n')
   numpy.savetxt(f, result, fmt='%s', delimiter=",")

answered Jun 25 '21 at 21:33

Florian Dubost

51
1
3

score 0 · Answer 3 · answered Jun 29 '17 at 12:50

0

Also had the same problem in a script using numpy.savetxt, but i could not use result.astype(int) as I had floats in another column.

Solved it using %5.0f for the format of the output of the zeros.

answered Jun 29 '17 at 12:50

Guto

541
5
14

numpy savetxt formatted as integer is not saving zeroes

3 Answers3

Linked