I have a dataframe df
:
NonUniqueKey Date
1111 01-01-2020 12:00
4444 22-09-2020 14:00
1111 23-07-2020 04:00
2222 08-03-2020 08:15
2222 08-03-2020 08:16
2222 08-03-2020 08:17
3333 11-11-2019 00:00
Expected output :
NonUniqueKey Date
4444 22-09-2020 14:00
1111 23-07-2020 04:00
2222 08-03-2020 08:17
3333 11-11-2019 00:00
I want to get unique NonUniqueKey
value of the latest Date
only. I'm using drop_duplicates(subset ='NonUniqueKey')
, removed the duplicate but wrong value taken..