Pandas dataframe reorienting

Question

        TA    Sector GP     OPR
ID              
AAPL    0.03   NaN   0.20   0.10
MSFT    0.04   NaN   0.30   0.05
AAPL    NaN    IT    NaN     NaN
MSFT    NaN    IT    NaN     NaN

I would like to convert the above frame into

Ticker Sector TA GO OPR
AAPL   IT      0.03 0.20 0.10
MSFT   IT      0.04 0.30 0.05

Is there a straight forward way to accomplish this?

Did you concatenate two DataFrames to get this? If so, add an axis=1 parameter to pd.concat. — cs95
– cs95, Commented Feb 25, 2019 at 23:11
Maybe, I am directly pulling this using an API where I specify the different fields needed . I believe what happens is, fields having similar frequency are returned in a single dataframe, the sector column is data at different frequency , and the API function just concatenates them together as you suggested — Thedudeabides
– Thedudeabides, Commented Feb 25, 2019 at 23:15
Do you have control over the API? Because this should be changed there... — cs95
– cs95, Commented Feb 25, 2019 at 23:22
Unfortunately cant control the API,but what you suggested does work. Thanks a lot for your help. — Thedudeabides
– Thedudeabides, Commented Feb 25, 2019 at 23:27

cs95 · Accepted Answer · 2019-02-25 23:28:27Z

2

This should be handled upstream if possible, but in the meantime the bandaid is using groupby on the index with first:

df.groupby(level=0).first()

        TA Sector   GP   OPR
ID                          
AAPL  0.03     IT  0.2  0.10
MSFT  0.04     IT  0.3  0.05

answered Feb 25, 2019 at 23:28

cs95

406k106 gold badges744 silver badges797 bronze badges

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

Collectives™ on Stack Overflow

Pandas dataframe reorienting

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