Change index of a pandas data frame

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, Aug 11 '22 at 16:08
Y i currently use `DF.rename(columns={'index':'TestName'}, inplace=True)` — TourEiffel, Aug 11 '22 at 16:09

score 1 · Accepted Answer · answered Aug 11 '22 at 16:32

1

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

answered Aug 11 '22 at 16:32

mozway

score 0 · Answer 2 · edited Aug 11 '22 at 19:25

0

You can just set the columns manually by doing this

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

edited Aug 11 '22 at 19:25

imxitiz

answered Aug 11 '22 at 16:10

Moro Wenka

score 0 · Answer 3 · edited Aug 11 '22 at 19:32

0

Use index.rename()

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

edited Aug 11 '22 at 19:32

imxitiz

answered Aug 11 '22 at 16:20

Naveed

3 Answers3