Drop multiple columns in pandas

Question

I am trying to drop multiple columns (column 2 and 70 in my data set, indexed as 1 and 69 respectively) by index number in a pandas data frame with the following code:

df.drop([df.columns[[1, 69]]], axis=1, inplace=True)

I get the following error:

TypeError: unhashable type: 'Index'

And in my code the [1, 69] is highlighted and says:

Expected type 'Integral', got 'list[int]' instead

The following code does what I want in two lines of repetitive code (first dropping col index 69, then 1, and order does matter because dropping earlier columns changes the index of later columns).

df.drop([df.columns[69]], axis=1, inplace=True)
df.drop([df.columns[1]], axis=1, inplace=True)

Is there a way to do this in one line similar to the first code snippet above?

joris · Accepted Answer · 2014-10-13 19:27:43Z

109

You don't need to wrap it in a list with [..], just provide the subselection of the columns index:

df.drop(df.columns[[1, 69]], axis=1, inplace=True)

as the index object is already regarded as list-like.

answered Oct 13, 2014 at 19:27

joris

140k37 gold badges258 silver badges207 bronze badges

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

1 Comment

Lothilius Over a year ago

Note df.columns[1:69] can be used for columns 2-70.

Okroshiashvili · Accepted Answer · 2018-02-13 06:30:22Z

23

Try this

df.drop(df.iloc[:, 1:69], inplace=True, axis=1)

This works for me

answered Feb 13, 2018 at 6:30

Okroshiashvili

4,1892 gold badges31 silver badges45 bronze badges

1 Comment

blue_chip Over a year ago

For newer users, I recommend this answer as it will force you to work with positional indexing df.iloc which you will see appear in a lot of other questions looking to do something on a column or row in a given position (first, last, nth, between ith and jth, etc.).

cottontail · Accepted Answer · 2023-02-15 07:31:58Z

1

A readable version is to pass the columns= argument.

df = df.drop(columns=df.columns[[1, 69]])

Putting df.columns[[1, 69]] inside a list (as in OP) becomes useful if we want to drop columns both by integer position and name(s) (simply need to unpack the array with *). For example, the following code drops the 2nd and the 70th columns along with another column named Some_Col.

df = df.drop(columns=[*df.columns[[1, 69]], 'Some_Col'])

Another way to drop columns is via the iloc indexer. For example, to drop the 2nd and 70th columns:

df = df.iloc[:, np.r_[:1, 2:69, 70:df.shape[1]]]
# or
df = df.iloc[:, ~np.isin(np.arange(df.shape[1]), [1,69])]

answered Feb 15, 2023 at 7:31

cottontail

25.6k25 gold badges184 silver badges176 bronze badges

Collectives™ on Stack Overflow

Drop multiple columns in pandas

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related