numpy large array to string gets

Question

I have a numpy array of date objects from datetime, which I have to convert into a string so I can use it as part of a SQL statement (for mysql). Generally, this works just fine:

dats = str(dates_list)
dats = string.replace(dats[1:-1],' ',"','")

except for when it's long enough that print dates_list shows the ... (ex: print numpy.arange(4000)).

I tried to directly use the repr special method (yeah, I know I shouldn't), which is supposed to provide a string representation that can be used to rebuild the object. Clearly, I can't build this array using [ 0 1 2 ..., 4997 4998 4999].

How can I get a string representation of the entire aarray?

tiago · Accepted Answer · 2012-11-26 10:17:49Z

4

Converting to a list seems to work:

dats = str(list(dates_list))

But the more correct option is to change numpy's printoptions. There is a threshold option that sets the limit to print a summary instead of the full repr. Default is 1000. You can change it to infinity:

import numpy as np
np.set_printoptions(threshold=np.inf)

dats = str(dates_list)

answered Nov 26, 2012 at 10:17

tiago

23.7k13 gold badges75 silver badges89 bronze badges

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

Collectives™ on Stack Overflow

numpy large array to string gets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related