6.6 C
London
Tuesday, March 11, 2025
HomePandas in PythonGeneral Functions in PythonHow to Rename Index in Pandas DataFrame

How to Rename Index in Pandas DataFrame

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

You can use the following syntax to rename the index column of a pandas DataFrame:

df.index.rename('new_index_name', inplace=True)

The following example shows how to use this syntax in practice.

Example: Rename Index in Pandas DataFrame

Suppose we have the following pandas DataFrame:

import pandas as pd

#create DataFrame
df = pd.DataFrame({'points': [25, 12, 15, 14, 19, 23, 25, 29],
                   'assists': [5, 7, 7, 9, 12, 9, 9, 4],
                   'rebounds': [11, 8, 10, 6, 6, 5, 9, 12]})

#view DataFrame
df

   points  assists  rebounds
0      25        5        11
1      12        7         8
2      15        7        10
3      14        9         6
4      19       12         6
5      23        9         5
6      25        9         9
7      29        4        12

Currently the DataFrame has no index name:

#display index name
print(df.index.name)

None

We can use df.index.rename() to rename the index:

#rename index
df.index.rename('new_index', inplace=True)

#view updated DataFrame
df

	   points assists rebounds
new_index			
0	   25	  5	  11
1	   12	  7	  8
2	   15	  7	  10
3	   14	  9	  6
4	   19	  12	  6
5	   23	  9	  5
6	   25	  9	  9
7	   29	  4	  12

Note that inplace=True tells pandas to retain all of the original DataFrame properties.

We can verify that the DataFrame now has an index name:

#display index name
print(df.index.name)

new_index

Additional Resources

The following tutorials explain how to perform other common operations in pandas:

How to Add a Column to a Pandas DataFrame
How to Get First Column of Pandas DataFrame

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories