Python: DataFrame restructure

Question

I have one DataFrame generated from below code

import pandas as pd
import pandas_datareader.data as web
from datetime import datetime

start=datetime(2018, 3, 1)
end=datetime(2018,3,12)
symbol = ['AAPL' , 'IBM' , 'MSFT' , 'GOOG']

Morningstar=web.DataReader(symbol, data_source='morningstar',start=start, end=end)
dfResetMorningstar=Morningstar.reset_index()
pricemine=dfResetMorningstar[['Symbol','Date','Close']]
pricemine.set_index(['Symbol','Date'], inplace=True)

Result: enter image description here

I would like to transform the dataframe into format similar as below (the data would be the ['Close'] data

enter image description here

I'm not sure how this can be achieved using "groupby" comment. Any feedback would be much appreciated. Also open to other ways not using "groupby".

Thank you!

jezrael · Accepted Answer · 2018-03-12 11:38:31Z

1

Use unstack by first level:

pricemine = pricemine['Close'].unstack(0)

answered Mar 12, 2018 at 11:38

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Python: DataFrame restructure

I have one DataFrame generated from below code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

I have one DataFrame generated from below code

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related