Add a name to pandas dataframe index

Question

As the picture shows , how can I add a name to index in pandas dataframe?And when added it should be like this:

jezrael · Accepted Answer · 2017-04-15 11:58:31Z

10

You need set index name:

df.index.name = 'code'

Or rename_axis:

df = df.rename_axis('code')

Sample:

np.random.seed(100)
df = pd.DataFrame(np.random.randint(10,size=(5,5)),columns=list('ABCDE'),index=list('abcde'))
print (df)
   A  B  C  D  E
a  8  8  3  7  7
b  0  4  2  5  2
c  2  2  1  0  8
d  4  0  9  6  2
e  4  1  5  3  4

df.index.name = 'code'
print (df)
      A  B  C  D  E
code               
a     8  8  3  7  7
b     0  4  2  5  2
c     2  2  1  0  8
d     4  0  9  6  2
e     4  1  5  3  4

df = df.rename_axis('code')
print (df)

      A  B  C  D  E
code               
a     8  8  3  7  7
b     0  4  2  5  2
c     2  2  1  0  8
d     4  0  9  6  2
e     4  1  5  3  4

edited Apr 15, 2017 at 11:58

answered Apr 15, 2017 at 11:55

jezrael

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

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

3 Comments

user6007834 Over a year ago

Thank you very much! It's helpful!

jezrael Over a year ago

Small advice to future - don't post images of code (or links to them). Good luck!

user6007834 Over a year ago

Thank you! I got it

Collectives™ on Stack Overflow

Add a name to pandas dataframe index

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related