retrieving data from a numpy array and storing in a dataframe

Question

I currently have a .npy file and I would like to store the data it contains in a variable in order to convert it to a dataframe.

I tried using the following:

data_array=np.load('Jason1Data_Full_East_West.npy')
df = pd.DataFrame(data_array)

However my dataframe came out as a single column. How do I save the data in a format where the columns are clearly separated with now square brackets around the rows?

Below is the result I am currently getting.

You must provide a minimal reproducible example for us to diagnose the problem. — Arya McCarthy
– Arya McCarthy, Commented Aug 20, 2017 at 17:36
It looks like your data was never structured properly in the first place. — user2357112
– user2357112, Commented Oct 5, 2017 at 17:32
It was sent to me. Is there a way to get it in the format I want? — renardo
– renardo, Commented Oct 5, 2017 at 17:34

Samir Alhejaj · Accepted Answer · 2017-08-20 18:23:58Z

1

Even your question is not clear. You can try the following:

path = .../Jason1Data_Full_East_West.npy
data = np.load(path)

And then you need to convert it to dataframe as the following:

pd.DataFrame({'Data':data.tolist()})

edited Aug 20, 2017 at 18:23

answered Aug 20, 2017 at 17:31

Samir Alhejaj

1572 silver badges16 bronze badges

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

4 Comments

Arya McCarthy Over a year ago

Jason != JSON. Jason is also a common male name.

Samir Alhejaj Over a year ago

Sorry Arya, I didn't fully understand the question. Now I corrected the answer. please comment :)

Arya McCarthy Over a year ago

Don't forget quotes for the path. Is tolist necessary? What about pd.DataFrame(data)?

renardo Over a year ago

I have edited the question a bit because I have encountered this situation again. Could you guys provide me with some assistance please?

Collectives™ on Stack Overflow

retrieving data from a numpy array and storing in a dataframe

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related