Python filter dataframe with condition and column

Question

i'm curious if it's possible to filter a pandas DataFrame by column and a condition. Or do i have to do it with two steps.

So my basic idea is to do:

 df['cluster' & (df['Type'] == 't')]

Or is there no overhead achieving this by two steps like:

tmp = df[df['Type'] == 't']
tmp = tmp[df['Type']]

Oriol Mirosa · Accepted Answer · 2018-04-08 14:38:55Z

2

You can do:

df.loc[df['Type'] == 't', 'cluster']

answered Apr 8, 2018 at 14:38

Oriol Mirosa

2,8361 gold badge16 silver badges15 bronze badges

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

3 Comments

Yes, this is exactly what OP need :)

If add some data sample solution will be better :)

Ah thank you very much. I somehow couldn't find this way to filter the data.