How can I consolidate a dataframe like below on the User while retaining values from other columns?
unconsolidated: 
df_consolidated: 
Any advice welcomed, even around better practice for consolidating in situations like this. The date column can be consolidated or keep the latest date, that shouldn't matter too much.