python - pandas: rename axis in df

Question

I have a df which looks like this:

                Column 1
Channel          
Apples            1.0
Oranges           2.0
Puppies           3.0
Ducks             4.0

I would like to rename the axis so it looks like this:

Channel         Column 1          
Apples            1.0
Oranges           2.0
Puppies           3.0
Ducks             4.0

I tried these but got the same error msg:

merged_df.rename_axis("Channel")
merged_df.rename_axis("Channel", axis='columns')

TypeError: 'str' object is not callable

Answer 1

This is kind of a hack to get you what you eventually wanted it to look like.

df = pd.read_csv(data, sep='s{2,}', index_col='Channel', engine='python')
df

df_excel_format = df.rename_axis('Channel', axis=1)
del(df_excel_format.index.name)
df_excel_format