df['DATE'] = pd.to_datetime(df['DATE'])
latest_date = df['DATE'].max()
latest_rows = df[df['DATE'] == latest_date]
print(latest_rows)
Python: store a value in a variable so that you can recognize each reoccurence