How do i rename a column in pandas created from a multirow header?
I've attempted
df = pd.read_excel(filepath,header=[0,1])
df.rename(
columns={"col name, line 2":"New_Column_name"}
,inplace=True)
# Also attempted
df.rename(columns={df.columns[0]: 'New_Column_name'},inplace=True)
Neither of those result in a renamed column, old name persists