Change index of a pandas data frame [duplicate]

Question

I have the following DF

	a	b
Test1	2	1
Test2	3	2

What I currently do is the following :

DF.reset_index().set_index('b')

which give the following output :

b	a	index
1	2	Test1
2	3	Test2

But what if I don't want the column to be named as "index" ?

For example I wish to have the following output : (Replace "index" by "TestName")

b	a	TestName
1	2	Test1
2	3	Test2

DF.reset_index().set_index('b').rename(columns={'index':'TestName'}). There's also rename_axis function as well. — Quang Hoang
– Quang Hoang, Commented Aug 11, 2022 at 16:08
Y i currently use DF.rename(columns={'index':'TestName'}, inplace=True) — TourEiffel
– TourEiffel, Commented Aug 11, 2022 at 16:09

mozway · Accepted Answer · 2022-08-11 16:32:12Z

1

You can use rename_axis:

DF.rename_axis('TestName').reset_index().set_index('b')

answered Aug 11, 2022 at 16:32

mozway

267k13 gold badges56 silver badges106 bronze badges

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

Comments

imxitiz · Accepted Answer · 2022-08-11 19:25:18Z

0

You can just set the columns manually by doing this

df.columns = ['b', 'a', 'TestName']

edited Aug 11, 2022 at 19:25

imxitiz

4,0253 gold badges14 silver badges36 bronze badges

answered Aug 11, 2022 at 16:10

Moro Wenka

413 bronze badges

Comments

imxitiz · Accepted Answer · 2022-08-11 19:32:04Z

0

Use index.rename()

DF.set_index('b', inplace=True)
DF.index.rename('TestName', inplace=True)
DF

edited Aug 11, 2022 at 19:32

imxitiz

4,0253 gold badges14 silver badges36 bronze badges

answered Aug 11, 2022 at 16:20

Naveed

11.7k2 gold badges16 silver badges21 bronze badges

1 Comment

imxitiz Over a year ago

Is there dataframe.index.rename() function?

Collectives™ on Stack Overflow

Change index of a pandas data frame [duplicate]

3 Answers 3

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Linked

Related