Make column from pandas dataframe index

Question

I have a dataframe where I would like to turn the data in the (first level of the) index into a column. Practically my df looks like this:

         col1
CoI     
 AK   0     1
      1    31
      2   NaN 
 BB   0     5
      1    31
      2   NaN

And I would like to turn it into this:

      col1  CoI

   0     1   AK
   1    31   AK
   2   NaN   AK
   0     5   BB
   1    31   BB
   2   NaN   BB

How can I best do this? I think this is a rather basic functionality, but as with many other "basic" pandas things I cannot find info on this anywhere.

Many Thanks,

bdiamante · Accepted Answer · 2013-11-26 22:26:28Z

6

df.reset_index(level=0, inplace=True) should do it. See the docs here.

answered Nov 26, 2013 at 22:26

bdiamante

17.8k6 gold badges43 silver badges48 bronze badges

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

1 Comment

Tim D Over a year ago

This link is a little more useful: pandas-docs.github.io/pandas-docs-travis/reference/api/…

Collectives™ on Stack Overflow

Make column from pandas dataframe index

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