Convert Time
column to datetimes and then to custom format MM/DD/
and then aggregate:
df['Time'] = pd.to_datetime(df['Time']).dt.strftime('%m/%d/')
df1 = df.groupby('Time').first()
If need aggregate sum
, mean
if duplicates use:
df2 = df.groupby('Time').sum(min_count=1)
df3 = df.groupby('Time').mean()