Turn multi-index of pandas series into dataframe columns

Question

I have the following Series with a multi-index:

import pandas as pd
index = pd.MultiIndex(labels = [[0,1,1],[2,2,3]], levels = [[1,2],[1,2,3,4]], names = ['a','b'])
s = pd.Series(index=index, data=[100,200,300])

a  b
1  3    100
2  3    200
   4    300

I want to transform it into a DataFrame where the rows are the labels of the first index (e.g. a), the columns are the labels of the second index (e.g. b), and the values the values at index (a,b) (or None if there is none):

desired_df = pd.DataFrame(index=pd.Index(data=[1,2],name='a'), 
                          data = [[100,None],[200,300]],
                         columns = [3,4])


    3   4
a       
1   100 NaN
2   200 300.0

jezrael · Accepted Answer · 2019-09-11 07:31:11Z

2

Use Series.unstack function:

print (s.unstack())
b      3      4
a              
1  100.0    NaN
2  200.0  300.0

answered Sep 11, 2019 at 7:31

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

Turn multi-index of pandas series into dataframe columns

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