Rename Multi - Index Column name Python

Question

I have a MultiIndex Dataframe df like Below

                 Office
 Office    
 x         True   2
 y         False  3
 z         True   5

If i reset df.reset_index() it will Error as

"cannot insert Office, already exists"

How its posible to rename the the higher(which comes in very first line) index name "Office" to "Office1"

jezrael · Accepted Answer · 2017-09-22 05:56:18Z

4

You can use rename_axis or set index.names for rename index names in MultiIndex and rename for change column name:

#if only rename get Unnamed column
df1 = df.rename(columns={'Office':'another col'}).reset_index()
print (df1)
  Office  Unnamed: 1  another col
0      x        True            2
1      y       False            3
2      z        True            5

df2 = df.rename_axis(('Office', 'bool')).rename(columns={'Office':'Office2'}).reset_index()
print (df2)
  Office   bool  Office2
0      x   True        2
1      y  False        3
2      z   True        5

df.index.names = ('Office1','bool')
df3 = df.rename(columns={'Office':'Office2'}).reset_index()
print (df3)
  Office1   bool  Office2
0       x   True        2
1       y  False        3
2       z   True        5

edited Sep 22, 2017 at 5:56

answered Sep 22, 2017 at 5:42

jezrael

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

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

4 Comments

Shivpe_R Over a year ago

reset_index() got an unexpected keyword argument 'name'

jezrael Over a year ago

Sorry, I miss MultiIndex first.

Shivpe_R Over a year ago

How to change the Name of column name office having values 2,3,5 to office1 not the other one

jezrael Over a year ago

Do you think rename? I add it to answer.

Collectives™ on Stack Overflow

Rename Multi - Index Column name Python

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related