Hi, one of my tasks is failing with this error:

"['\\ufeffID'] not found in axis"

The original code is:

df.drop([r"\ufeffID"], axis=1, inplace=True)

So it looks like another escape character is added during execution?

try

df.drop("\ufeffID", axis=1, inplace=True)

r”" is used to denote rawstring, which will recognize “\u” as two separate character.

Sorry that’s what I tried the first time actually:

df.drop(["\ufeffID"], axis=1, inplace=True)

- it changes it errors out with an extra escape char:

"['\\ufeffID'] not found in axis"

can you try remove the list notation

["\ufeffID"]

just use

"\ufeffID"

instead

OK will try that thanks

another approach is selecting only valid column instead of dropping ( I suspect pandas may have problem with UTF-8 column).

cols = df.columns.drop("\ufeffID")
df = df[cols]