Iloc
Jump to navigation
Jump to search
Find the latest value per ID for a dataframe like this:
Index | ID | date | value |
---|---|---|---|
0 | 1 | 2019-06-14 23:00:03 | 7550.00 |
0 | 2 | 2019-06-15 00:00:03 | 7690.00 |
23560 | 17 | 2019-12-15 18:10:43 | 25.50 |
23561 | 17 | 2019-12-16 18:10:45 | 25.52 |
df2.groupby('ID').apply(lambda d: d.iloc[-1])