Drop duplicates, keep most recent date in a Pandas dataframe July 31, 2023 by Tarik Try: df.sort_values('DATE_CHANGED').drop_duplicates('STATION_ID',keep='last')