Delete Multiple Columns

Question

How can I delete column on index 2 onwards for a dataframe that contains 10 columns. The dataframe looks like this:

column1    column2    column3    column4 ...

The task is to delete column3-column10

jezrael · Accepted Answer · 2020-05-27T13:56:23.983

2

Invert logic - select first 2 columns by positions by DataFrame.iloc:

df = df.iloc[:, :2]

If need DataFrame.drop select columns names with indexing:

df = df.drop(df.columns[2:], axis=1)

edited May 27 '20 at 13:56

answered May 27 '20 at 13:52

jezrael

1

maybe an `inplace=True` ? – Jon Clements May 27 '20 at 13:56
@JonClements - I prefer assign, [link](https://github.com/pandas-dev/pandas/issues/16529) ;) – jezrael May 27 '20 at 13:57
Interesting - thanks for the link - will have to read through that properly later - not entirely convinced at a first glance I agree with the suggestion there - but thanks for the heads up – Jon Clements May 27 '20 at 14:01
@JonClements - yes, interesting reading. ;) – jezrael May 27 '20 at 14:02

score 0 · Answer 2 · answered May 27 '20 at 13:53

0

This should work for you

df.drop(columns=df.columns[2:])

df.drop(columns=[...]) will drop the provided columns

df.columns[2:] will return the list of columns, [2:] selects all columns, starting from the third column, all the way to the end.

answered May 27 '20 at 13:53

Bobs Burgers

score 0 · Answer 3 · answered May 27 '20 at 13:55

0

try this

df.iloc[::,0:3]

result should be the part you want

answered May 27 '20 at 13:55

Yang

3 Answers3