Selecting Columns from Dataframe

Question

I have a dataframe with many many columns. I want to reduce this dataframe to one with only the columns I require.

Instead of using

del df['column_name']

for all the columns that I don't need, is there a way to select the ones I do and create a new dataframe? I have tried:

df1['column_name'] = df['column_name']

Andy Hayden · Accepted Answer · 2013-03-29 14:17:14Z

4

You can select the columns in a list:

cols = ['col1', 'col2']
df[cols]

answered Mar 29, 2013 at 14:17

Andy Hayden

378k110 gold badges640 silver badges546 bronze badges

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

1 Comment

I don't understand why this works and this does not: 'df = df[['col1', 'col2']]'