Pandas Add Column Index Level to Data Frame

Question

Given the following data frame:

d2=pd.DataFrame({'Item':['y','y','z','x'],
                'other':['aa','bb','cc','dd']})
d2

    Item    other
0   y       aa
1   y       bb
2   z       cc
3   x       dd

I'd like to add a column index level 1 under the existing one (I think) because I want to join this data frame to another that is a multi-index. I don't want to alter the other data frame because I have already written a lot of code assuming its current structure.

Thanks in advance!

jezrael · Accepted Answer · 2016-05-20 05:46:25Z

3

IIUC you can add parameter append=True to set_index:

print (d2.set_index('Item', append=True))
       other
  Item      
0 y       aa
1 y       bb
2 z       cc
3 x       dd

answered May 20, 2016 at 5:46

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

Pandas Add Column Index Level to Data Frame

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