Filter data frame by choosing most recent one in pandas

Asked Apr 08 '20 at 06:59

Active Apr 08 '20 at 07:04

Viewed 9 times

I have a data frame as shown below

ID              Date                   Total_Runs 
Sachin       2010-01-06 09:00:00       6000
Sachin       2016-01-06 09:00:00       15000
Kohli        2019-01-06 09:00:00       11000
Kohli        2019-01-06 11:00:00       11060
Devillers    2015-01-06 09:00:00       10000
Devillers    2014-01-06 09:00:00       8000
Devillers    2012-01-06 09:00:00       8000
Devillers    2016-01-06 09:00:00       9000

I would like to filter above data frame by selecting most recent runs for each ID (in pandas).

Expected Output:

ID              Date                   Total_Runs 
Sachin       2016-01-06 09:00:00       15000
Kohli        2019-01-06 11:00:00       11060
Devillers    2016-01-06 09:00:00       9000

edited Apr 08 '20 at 07:04

asked Apr 08 '20 at 06:59

Danish

2,719
17
32

Use `df = df.loc[df.groupby(''ID)['Date'].idxmax()]` – jezrael Apr 08 '20 at 07:01
@jezrael not the max value.. recent value – Danish Apr 08 '20 at 07:02
Yes, max date is most recent valiue – jezrael Apr 08 '20 at 07:03
@jezrael oh Agreed. Just changed the examples – Danish Apr 08 '20 at 07:05

Filter data frame by choosing most recent one in pandas

0 Answers0