pandas multiindex reindex by rows

Question

I thought it is simple, but I didn't find the solution. I have a data frame like this

df = pd.DataFrame({'month': [1, 4, 7, 10],
                'year': [2012, 2012, 2013, 2013],
                'sale': [55, 40, 84, 31]})
df.set_index('month')

I try to get a Multiindex with level 0 with 'year', and level 1 with 'month'. 'sale' will stay as column.

for example like this:

year  month sale 
2012  1     55
      4     40 
2013  7     84
      10    31

BENY · Accepted Answer · 2019-12-19 21:54:07Z

2

You can pass a list

df=df.set_index(['year','month'])
df
            sale
year month      
2012 1        55
     4        40
2013 7        84
     10       31

answered Dec 19, 2019 at 21:54

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

Alex Over a year ago

this solution is correct! Thank you! in my original code i get 'NotImplementedError: > 1 ndim Categorical are not supported at this time'. month is 'int 64'. may I have to change the example...

Collectives™ on Stack Overflow

pandas multiindex reindex by rows

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related