How to load data series saved in an excel cell into a numpy array

Question

I have a time series saved in an excel cell, which I want to load for future calculations. I have tried to load them using pandas, but get something like this

KE = '[ 0.  0.  0. ... nan nan nan]'

KE.type is giving this response -

'numpy.str_' object has no attribute 'type'

I want KE to be a time series as I saved the array to the cell, which should be like this

KE = [0,0,0,.......nan,nan,nan]

Could you guys please help me here, thank you.

qaiser · Accepted Answer · 2020-03-12 11:36:41Z

1

if it is string, following should help you ...

KE = '[0. 0. 0. nan nan]'.replace('[','').replace(']','').split(' ')
print(np.array(list(map(float,KE))))

#op
array([ 0.,  0.,  0., nan, nan])

edited Mar 12, 2020 at 11:36

answered Mar 12, 2020 at 11:01

qaiser

2,9083 gold badges21 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

How to load data series saved in an excel cell into a numpy array

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