Concatenate string per group but keep all data

Asked Mar 06 '23 at 18:30

Active Mar 06 '23 at 20:40

Viewed 15 times

This post was edited.

I am a R user that is trying to transition to python. I need the concatenate the inout variable by ID but I want to keep all records (not collapse my data). In R there is an ungroup option you can add after aggregating your data.

    ID  inout       desire_var
0  120     IN          IN-IN-OUT
1  120     IN          IN-IN-OUT
2  120     OUT         IN-IN-OUT

import pandas 
df = pandas.DataFrame({'ID': [120, 120, 120], 
                   'inout': ['IN', 'IN', 'OUT'],
                   'desire_var' : ['IN-IN-OUT', 'IN-IN-OUT', 'IN-IN-OUT']})

edited Mar 06 '23 at 20:40

asked Mar 06 '23 at 18:30

mar355

`df.groupby('ID')['score'].transform('max')` – mozway Mar 06 '23 at 18:34
Thank you this work! Note: that I have to change the post to be able to post it. Thanks. – mar355 Mar 06 '23 at 20:41

Concatenate string per group but keep all data

0 Answers0