Delete all but one column of pandas dataframe?

Question

I have a pandas dataframe and would like to drop all columns save the index and a column named 'bob'

How would I do this?

Andy Hayden · Accepted Answer · 2013-09-28 02:40:53Z

57

You can simply write:

df = df[['bob']]

and the other columns will be garbage collected.

answered Sep 28, 2013 at 2:40

Andy Hayden

378k110110 gold badges640640 silver badges546546 bronze badges

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

Comments

Alan A. Gulle · Accepted Answer · 2018-11-01 12:02:12Z

6

you can use df.loc accessor

df=df.loc[:,['bob']]

answered Nov 1, 2018 at 12:02

Alan A. Gulle

7111 silver badge33 bronze badges