I am trying to rename a header in excel file using Python.
import pandas as pd
file1='emp_list.xlsx'
df1=pd.read_excel(file1)
df_rename=df1.rename(columns={'Employee':'Emp_Name'},inplace=True)
print(df_rename)
Above code is returning none. Can anyone help me?