Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- df = pd.DataFrame({'id': [1,1,1,1,1,1,2,2,2,2,2,2],
- 'val': [1,10,1,10,20,30,1,1,1,12,17,28]})
- id val
- 1 1
- 1 10
- 1 1
- 1 10
- 1 20
- 1 30
- 2 1
- 2 1
- 2 1
- 2 12
- 2 17
- 2 28
- id val
- 1 10
- 1 20
- 1 30
- 2 12
- 2 17
- 2 28
- df = pd.DataFrame({'id': [1,1,1,1,1,1],
- 'val': [1,10,1,10,20,30]})
- # create groups at breakpoints where condition is no longer met
- g = df.groupby((df['val'] > 5).cumsum())
- # find last group
- label = max(list(g.groups.keys()))
- result = df.loc[g.groups[label]._data].tail(-1)
Add Comment
Please, Sign In to add comment