Changing index name in pandas dataframe

Question

I have a dataframe that looks like this:

How can I change the Unnamed: 0 and the blank header of columns so it would look like this:

Rabinzel · Accepted Answer · 2022-09-06 15:34:37Z

1

You want to change both the names of index and columns axis.

You can do it like this:

df.index.name = 'BBID'
df.columns.name = 'VALUE_DATE'

or with a chained method like this:

df = df.rename_axis('VALUE_DATE').rename_axis('BBID', axis=1)

answered Sep 6, 2022 at 15:34

Rabinzel

7,9533 gold badges12 silver badges31 bronze badges

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

Comments

gtomer · Accepted Answer · 2022-09-06 15:17:36Z

1

Try this:

df.reset_index(inplace=True)
df.rename(columns={df.columns[0]: 'BBID VALUE_DATE'}, inplace=True)
df.set_index('BBID VALUE_DATE' , inplace = True)

edited Sep 6, 2022 at 15:17

answered Sep 6, 2022 at 15:06

gtomer

6,6041 gold badge14 silver badges29 bronze badges

3 Comments

glitch_123 Over a year ago

you forgot to make the column as index again. One can do it like this df.set_index('BBID VALUE_DATE' , inplace = True)

statwoman Over a year ago

Hmm so the BBID is the header for the column names and VALUE_DATE is the header for the row names. They are separate, sorry for being vague in the sc.

gtomer Over a year ago

There is no such thing as "header for columns"

Collectives™ on Stack Overflow

Changing index name in pandas dataframe

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related