Python: How to rename Index Names Pandas DataFrame

In the above example, we had taken a look at how to rename column(s) of a DataFrame in pandas, and now in this example, we see how to rename the index names.

Again, we will make use of the DataFrame.rename function.

Example:

import pandas as pd

code2care_data = {
    'Year': [2020, 2021, 2022, 2023],
    'Country': ['United States', 'India', 'United Kingdom', 'Germany'],
    'City': ['New York', 'Mumbai', 'London', 'Berlin'],
    'Mobile': [312125, 2234010, 150125, 413822],
    'Desktop': [353871, 427896, 374675, 258976],
    'Search Engine': ['Google', 'Bing', 'Google', 'Yahoo']
}

df = pd.DataFrame(code2care_data)

print("\nDataFrame before renaming Column Names:")
print(df)

# Renaming the indexes
new_index_names = {
    0: 'Row 1',
    1: 'Row 2',
    2: 'Row 3',
    3: 'Row 4'
}

df = df.rename(index=new_index_names)

print("\nDataFrame after renaming Index:")
print(df)

DataFrame before renaming Index Names:

   Year         Country      City   Mobile  Desktop Search Engine
0  2020   United States  New York   312125   353871        Google
1  2021           India    Mumbai  2234010   427896          Bing
2  2022  United Kingdom    London   150125   374675        Google
3  2023         Germany    Berlin   413822   258976         Yahoo



DataFrame after renaming Indexes:

       Year         Country      City   Mobile  Desktop Search Engine
Row 1  2020   United States  New York   312125   353871        Google
Row 2  2021           India    Mumbai  2234010   427896          Bing
Row 3  2022  United Kingdom    London   150125   374675        Google
Row 4  2023         Germany    Berlin   413822   258976         Yahoo

Read More: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.rename.html