Consolidating Pandas Dataframe on 1 column while retaining data from multiple rows in other columns

Asked Sep 05 '22 at 20:00

Active Sep 05 '22 at 20:00

Viewed 17 times

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.

asked Sep 05 '22 at 20:00

Andrew

4

instead of the photo, please add text of your dataframe – I'mahdi Sep 05 '22 at 20:01
1

What did you try so far? – Luis Alejandro Vargas Ramos Sep 05 '22 at 20:02
@LuisAlejandroVargasRamos groupby and been searching since for a similar problem/solution. Trying things in jupyter. – Andrew Sep 05 '22 at 20:12

Consolidating Pandas Dataframe on 1 column while retaining data from multiple rows in other columns

0 Answers0