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

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!
More Posts related to Python,
- Python: Convert Date to DateTime
- How to sort a List using Lambda in Python
- Python matplotlib segmentation fault: 11 macOS Big Sur
- What is Terminal Velocity and its Formula? How to calculate it programmatically?
- How to install Python 3.11 on Mac
- How to flatten a nested list in Python
- Python: Pandas Merge DataFrames on Index Example
- How to Run all Cells at Once Jupyter Notebook
- Python - Convert float to String
- How to add borders to tkinter label text
- How to Exit a Loop in Python Code
- [Python] Fix: ValueError: All arrays must be of the same length
- Sorting an array using Bubble Sort in Python Programming
- How to Unzip a file using Python
- Python: Merge DataFrames Pandas Outer Join Example
- Change label (text) color in tkinter
- Convert Float to String in Python
- Fix: fatal error: No such file or directory compilation terminated
- Python: Access index/counter of a for loop iteration
- Import Other Python Files Examples
- How to install Anaconda on Mac (M1/M2 Mac)
- Python Regular Expression to Find All Matches in List
- How to Read a binary File with Python
- How to disable warnings while Python file execution
- Know current Python Version
More Posts:
- Eclipse : The type java.lang.CharSequence cannot be resolved. Indirectly referenced from required .class files - Java
- Mac: macOS Sonoma 14 Compatibility List - MacOS
- How to locate Python Installation on Windows (10/11) - Windows
- Change Mouse Scrolling in Mac OS X - Mac-OS-X
- Java location in Mac OS X - Mac-OS-X
- Spring Boot: JdbcTemplate Update Query With Parameters Example - Java
- Encode or Decode Base64 String using Mac Terminal Command - MacOS
- Install Microsoft Remote Desktop (RDP) Client on Mac - Microsoft