Write a Python code to rename the given axis in a dataframe

In Pandas, you can rename the axis (row index or column names) of a DataFrame using the rename_axis() method. This is useful when you want to give a meaningful name to your DataFrame's index or columns axis.

Syntax

DataFrame.rename_axis(mapper, axis=None, copy=None, inplace=False)

Parameters

• mapper ? The new name for the axis

• axis ? 0 or 'index' for row axis, 1 or 'columns' for column axis

• inplace ? If True, modify the DataFrame in place

Renaming the Column Axis

Let's create a DataFrame and rename its column axis ?

import pandas as pd

df = pd.DataFrame({"Id": [1, 2, 3, None, 5],
                   "Age": [12, 12, 14, 13, None],
                   "Mark": [80, 90, None, 95, 85]})

print("Original DataFrame:")
print(df)
print("\nAfter renaming column axis:")
df_renamed = df.rename_axis('Students', axis=1)
print(df_renamed)

Original DataFrame:
    Id   Age  Mark
0  1.0  12.0  80.0
1  2.0  12.0  90.0
2  3.0  14.0   NaN
3  NaN  13.0  95.0
4  5.0   NaN  85.0

After renaming column axis:
Students   Id   Age  Mark
0         1.0  12.0  80.0
1         2.0  12.0  90.0
2         3.0  14.0   NaN
3         NaN  13.0  95.0
4         5.0   NaN  85.0

Renaming the Row Index Axis

You can also rename the row index axis by setting axis=0 ?

import pandas as pd

df = pd.DataFrame({"Id": [1, 2, 3, None, 5],
                   "Age": [12, 12, 14, 13, None],
                   "Mark": [80, 90, None, 95, 85]})

print("Original DataFrame:")
print(df)
print("\nAfter renaming row index axis:")
df_renamed = df.rename_axis('Row_Number', axis=0)
print(df_renamed)

Original DataFrame:
    Id   Age  Mark
0  1.0  12.0  80.0
1  2.0  12.0  90.0
2  3.0  14.0   NaN
3  NaN  13.0  95.0
4  5.0   NaN  85.0

After renaming row index axis:
             Id   Age  Mark
Row_Number            
0           1.0  12.0  80.0
1           2.0  12.0  90.0
2           3.0  14.0   NaN
3           NaN  13.0  95.0
4           5.0   NaN  85.0

Renaming Both Axes

You can rename both row and column axes by passing a list ?

import pandas as pd

df = pd.DataFrame({"Id": [1, 2, 3, None, 5],
                   "Age": [12, 12, 14, 13, None],
                   "Mark": [80, 90, None, 95, 85]})

print("Original DataFrame:")
print(df)
print("\nAfter renaming both axes:")
df_renamed = df.rename_axis(['Row_Number'], axis=0).rename_axis(['Student_Info'], axis=1)
print(df_renamed)

Original DataFrame:
    Id   Age  Mark
0  1.0  12.0  80.0
1  2.0  12.0  90.0
2  3.0  14.0   NaN
3  NaN  13.0  95.0
4  5.0   NaN  85.0

After renaming both axes:
Student_Info   Id   Age  Mark
Row_Number              
0             1.0  12.0  80.0
1             2.0  12.0  90.0
2             3.0  14.0   NaN
3             NaN  13.0  95.0
4             5.0   NaN  85.0

Conclusion

Use rename_axis() to give meaningful names to your DataFrame's row or column axes. Set axis=0 for row index and axis=1 for column axis naming.