pandas.dataframe.pop for all names in a array

Question

I'm trying to remove a list of columns from a pandas.DataFrame. I've created a list through

diff = df1.difference(df2)

I would like to do something like:

for name in diff:
    dataframe.pop(name)

Is there a way to apply the pop function in a vectorized way with all names in the diff index array?

Thanks all for the help!

Regards, Jan

`dataframe.drop(diff, axis=1)` - will drop all columns belonging to `diff` list — MaxU - stand with Ukraine, Oct 23 '16 at 16:34

score 1 · Answer 1 · edited May 23 '17 at 10:29

1

as MaxU said, cleanest way to do it is

dataframe.drop(diff, axis=1)

the .pop() method returns the series you are poping, which is not time effective if you only want to delete the column

also, you coulduse the del method which maps to the python magic method df.__delitem__('column'). I would not recommend that.

edited May 23 '17 at 10:29

Community

answered Oct 23 '16 at 16:36

Steven G

oh yes! that is exactly what i wanted. Had the wrong function all along. – Jan Jansen Oct 23 '16 at 16:42

1 Answers1