collapse values of same date in dataframe and create sets

Asked May 12 '23 at 12:20

Active May 12 '23 at 12:29

Viewed 14 times

I have the dataframe on top and I want to combine the values of the same date to end up with a dataframe on the bottom. Specifically, parsing the dates, if we have the same date I want to create a set of EVENT_TYPE strings and aggregate their durations for that specific day.

The goal is to create an encoding to the EVENT_TYPE occurring each specific day. I have tried groupby(), and sum(), and also to create a new dataframe and feed it with the merged rows but I fail in comparing succesfully the EVENT_TYPE so as to create the set. Could you please help me ?

edited May 12 '23 at 12:29

asked May 12 '23 at 12:20

irene noLaz

If the duplicated link doesn't help, please provide a fully reproducible example. – mozway May 12 '23 at 12:23
CALIFORNIA_event_type = CALIFORNIA_all_s3.groupby(['date'], as_index =True).agg({'EVENT_TYPE':''.join}) CALIFORNIA_duration = CALIFORNIA_all_s3.groupby(['date'], as_index =True).agg({'DURATION':'sum'}) – irene noLaz May 31 '23 at 13:46
I solved it with this – irene noLaz May 31 '23 at 13:46

collapse values of same date in dataframe and create sets

0 Answers0