CONTEXT

I have relevant information in multiple different rows and would like to group them together.

DATA

ID    Criteria1    Criteria2    Criteria3
100   Yes                       Yes
100                No
101   No                        
101                Yes          Yes

EXPECTED RESULT

ID    Criteria1    Criteria2    Criteria3
100   Yes          No           Yes
101   No           Yes          Yes            

CURRENT CODE

I’ve tried using group by but every example I’ve found requires aggregating with a sum or number and these are just strings. I’ve tried:

df = df.groupby('ID')

But then it is a dataframegrouped object and I can’t output it to a CSV.