Removing a column permanently from a data frame in Python

Question

In a given data frame mydf, I removed a column from the data frame through:

mydf.drop('Z', axis=1)

However, in the following parts, the removed column Z is still there, e.g., when I write print(mydf.sum()) after the previous cell, it gives me the sum of column Z with the sum of other columns. How can I delete the column Z permanently?

.drop by default returns a new dataframe. specify inplace=True if you don't want to re-assign mydf — Asish M.
– Asish M., Commented Dec 25, 2020 at 21:14

MarianD · Accepted Answer · 2020-12-25 21:16:11Z

4

You have to assign it back to mydf, if you want to reach a permanent change, i.e. do

mydf = mydf.drop('Z', axis=1)

instead.

answered Dec 25, 2020 at 21:16

MarianD

14.4k12 gold badges50 silver badges61 bronze badges

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

1 Comment

alperyildirim Over a year ago

It makes sense. Thank you so much.

Collectives™ on Stack Overflow

Removing a column permanently from a data frame in Python

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