Change pandas dataframe format

Question

I am new to python and can't seem to find a solution. Currently, my pandas dataframe is of format:

     841  818  813  800  788
399  3.0  4.0  3.0  NaN  NaN
400  NaN  NaN  NaN  3.0  3.0

Where 399 and 400 are unique ids. I am trying to make it so that unique ids will repeat until all columns are separated as rows. Like this:

399  841  3.0
399  818  4.0
...
400  841  NaN
400  818  NaN
...

Any help would be appreciated, thanks!

It's just how it looks. Maybe df.stack(dropna=False).reset_index(). — Quang Hoang
– Quang Hoang, Commented Nov 10, 2020 at 16:31
Thanks, .stack is what I was looking for. However, since I need this exact format, I will search more on .stack, but this should be enough to figure it out! — Adil Zhakypbek
– Adil Zhakypbek, Commented Nov 10, 2020 at 16:39

Adil Zhakypbek · Accepted Answer · 2020-11-10 17:16:03Z

1

Thanks, Quang Hoang, this solution does work! Here is a straight-forward answer for those who might search for this in the future if your pandas dataframe is named "data_df" then just do this:

data_df = data_df.stack(dropna=False).reset_index()

P.S.: when you print it to see the result, enumeration in the first column is not a part of the dataframe so don't worry. Also, "level_0", "level_1", "0" in the first row are just column names

Good luck!

answered Nov 10, 2020 at 17:16

Adil Zhakypbek

113 bronze badges

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

Collectives™ on Stack Overflow

Change pandas dataframe format

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