Pandas. Selecting specific columns [duplicate]

Question

Suppose we have a Dataframe with many columns Name,Sex, Age, Education, Race. I want to create a DF only with the following columns Age,Sex,Educaion.
I know that I can do it with the following method.

df2 = pd.DataFrame(df[['Age','Sex','Education']]

Is there a way to do something like this. i.e Select all columns excepth x, y, z.

df2 = pd.DataFrame(df(select all columns except the following columns = 'Race', 'Name'))

Maku · Accepted Answer · 2020-04-19 04:40:40Z

2

You can use drop from pandas

Example: df.drop(columns=[list_of_columns_to_drop])

answered Apr 19, 2020 at 4:40

Maku

1,61014 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Pandas. Selecting specific columns [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related