Cannot delete the column in DataFrame Pandas by del function

Question

I'm using the function del df['column name'] to delete the column in Pandas but there is the error as the attached picture. I have no idea why it does not work. Much appreciated for any help to solve the problem.

It says your baby_names DataFrame has no column 'Year'.

mechanical_meat
– mechanical_meat

2020-02-06 17:41:01 +00:00
Commented Feb 6, 2020 at 17:41 — mechanical_meat
– mechanical_meat, Commented Feb 6, 2020 at 17:41

Raul de Queiroz · Accepted Answer · 2020-02-06 17:57:48Z

2

You should use the drop method instead.

df.drop(columns='column_name')

And if you want to chage the original Dataframe you should add the inplace=True as an argument to the method.

Also, avoid posting pictures if possible. Posting the written code is often more usufel and makes it easier for someone to help you!

answered Feb 6, 2020 at 17:57

Raul de Queiroz

791 silver badge8 bronze badges

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

1 Comment

G. Anderson Over a year ago

While this is useful information and definitely the right way to delete a column, have you verified that this works when the del method throws a KeyError in pandas to be sure it actually answers the question? If not, this would be better as a comment. See also: Why do I need 50 reputation to comment

Collectives™ on Stack Overflow

Cannot delete the column in DataFrame Pandas by del function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related