Python: How to rename Index Names Pandas DataFrame


How to rename Columns in DataFrame in pandas: https://code2care.org/python/rename-pandas-dataframe-column-names


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)
Output:
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
Renaming Index names of DataFrame Python Pandas

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

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail: rakesh@code2care.org

Copyright ยฉ Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap