Python / Pandas: Dataframe subset by filter criteria

Question

I have the following dataframe which is list of races and results.

      Date       R   #   Fin  Win
0     11182017   1   1   2     0 
1     11182017   1   2   1     5   
2     11182017   1   3   3     0   
3     11182017   2   1   2     0   
4     11182017   2   2   1     10   
5     11182017   3   1   1     6    
6     11182017   3   2   2     0

I want to only return the races (all entrants not just the row with 10) where the Win column is greater than or equal to 10. Example below

      Date       R   #   Fin  Win
3     11182017   2   1   2     0   
4     11182017   2   2   1     10

BENY · Accepted Answer · 2018-01-23 19:49:28Z

2

You can use groupby + filter

df.groupby(['Date','R']).filter(lambda x : (x['Win']>=10).any())
Out[568]: 
       Date  R  #  Fin  Win
3  11182017  2  1    2    0
4  11182017  2  2    1   10

Another solution by using transform

df[df.groupby(['Date','R']).Win.transform(lambda x : (x>=10).any())]
Out[573]: 
       Date  R  #  Fin  Win
3  11182017  2  1    2    0
4  11182017  2  2    1   10

answered Jan 23, 2018 at 19:49

BENY

324k22 gold badges176 silver badges250 bronze badges

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

3 Comments

Derek Over a year ago

Wen, TY for the quick response...can you possibly explain the mechanics of the code? df.groupby(['Date','R']).filter(lambda x : (x['Win']>=10).any())

BENY Over a year ago

@Derek it group by Date and R , find any value no less that 10 for all Win within the group, if any of them match , keep all , else drop it

BENY Over a year ago

@Derek if this is what you need , can you consider accept it ?

Collectives™ on Stack Overflow

Python / Pandas: Dataframe subset by filter criteria

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related