rename index pandas code example

Example 1: pandas rename index values

df.rename(index={'alpha': 'mu'})

Example 2: how to change column name in pandas

print(df.rename(columns={'A': 'a', 'C': 'c'}))
#         a   B   c
# ONE    11  12  13
# TWO    21  22  23
# THREE  31  32  33

Example 3: rename dataframe index column pandas

df.index.names = ['new_name']

Example 4: how to give column names in pandas when creating dataframe

df_new = df.rename(columns={'A': 'a'}, index={'ONE': 'one'})
print(df_new)
#         a   B   C
# one    11  12  13
# TWO    21  22  23
# THREE  31  32  33

print(df)
#         A   B   C
# ONE    11  12  13
# TWO    21  22  23
# THREE  31  32  33

Example 5: python - give a name to index column

df.index.name                      # Show me the current name
df.index.name = 'my_column_name'   # Change the index name to my_column_name

Example 6: pandas rename column by index?

import pandas as pd 
  
# Sample DataFrame 
df = pd.DataFrame({'a': [1, 2], 'b': [3, 4]}) 
  
# Changing columns name with index number 
df.columns.values[0] = "b"
df.columns.values[1] = "a"
  
# Display 
display(df)