Pandas (Python) MultiIndex from Single Index pd.DataFrame

Question

I have a df which looks like:

Let the group name of the individual columns be 'Symbol', so that a list of column names 'Symbol' = ['AAPL US Equity', 'ABT US Equity', 'BDX US Equity', 'BRO US Equity'] Let 'Returns' be the floats. Let 'Dates' be a datetime index.

Question: I need the df to have MultiIndex of ['Ticker', 'Dates'] with the hierarchy of it being the order i.e. 'Ticker' --> 'Dates' --> 'Returns'

Something like:

It is first grouped by 'Symbol', then by 'Date'

jezrael · Accepted Answer · 2022-02-02 12:32:50Z

1

Use DataFrame.unstack :

df = df.set_index('Dates').unstack().rename_axis(['Symbol','Date']).to_frame('Close')

Or DataFrame.melt:

df = (df.melt('Dates', var_name='Symbol', value_name='Close')
        .set_index(['Symbol','Dates'])
        .sort_index())

edited Feb 2, 2022 at 12:32

answered Feb 2, 2022 at 12:18

jezrael

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

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

1 Comment

Keegan Clarke Over a year ago

Both work! The DataFrame.melt method keeps it as a DataFrame which I need later. Thank you!

Collectives™ on Stack Overflow

Pandas (Python) MultiIndex from Single Index pd.DataFrame

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related