Pandas data frame index setting Key value error

Question

I have a data frame as shown below.

I need to set the 'xvalues' column as the index of this data frame.Below is my code.

df_thd_StepVF_funct_T.set_index('xvalues',inplace=True)

But this is giving me an error as shown below.May I know where I went wrong.

KeyError: "None of ['xvalues'] are in the columns"

There is no column named 'xvalues'. Should be pretty obvious from your screenshot or by doing print(df.columns) — It_is_Chris
– It_is_Chris, Commented Jul 18, 2022 at 13:56
I think the error is quite clear... xvalues is not a column. Can you show the output of df_thd_StepVF_funct_T.columns? — Tomerikoo
– Tomerikoo, Commented Jul 18, 2022 at 13:57
Does this answer your question? Python Pandas Replacing Header with Top Row — Tomerikoo
– Tomerikoo, Commented Jul 18, 2022 at 14:02

Barry the Platipus · Accepted Answer · 2022-07-18 13:59:33Z

1

new_header = df_thd_StepVF_funct_T.iloc[0]
df_thd_StepVF_funct_T = df_thd_StepVF_funct_T[1:]
df_thd_StepVF_funct_T.columns = new_header

Then try again on df_thd_StepVF_funct_T.

answered Jul 18, 2022 at 13:59

10.5k2 gold badges9 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1