Is there a way to groupby concatenating multiple strings?

Question

I have the following df:

Name  Role     Company     [other columns]
John  Admin    GM
John  Director Kodak
John  Partner  McDonalds
Mark  Director Gerdau
Mark  Partner  Kibon

I want to turn it into:

Name    Companies                                              [other columns]
John    GM (Admin), Kodak (Director), McDonalds (Partner)
Mark    Gerdau (Director), Kibon (Partner

I think the answer is somewhere in the groupby field, this question is almost there, however I need to find a way to do that iterating two columns and putting the parenthesis in place.

score 1 · Accepted Answer · answered May 21 '20 at 15:26

1

IIUC assign and groupby

df1 = df.assign(companies=df['Company'] + ' (' + df['Role'] + ')')\
                                            .groupby('Name')['companies'].agg(','.join)

print(df1)

Name
John    GM (Admin),Kodak (Director),McDonalds (Partner)
Mark                  Gerdau (Director),Kibon (Partner)
Name: companies, dtype: object

answered May 21 '20 at 15:26

Umar.H

22,559
7
39
74

It is not aggregating here. Are you sure you didn't miss something? I'm using python 3.6.4 – aabujamra May 21 '20 at 16:00
@abutremutante what output are you getting? – Umar.H May 21 '20 at 16:02
Just the company names, without aggregation – aabujamra May 21 '20 at 16:05

Is there a way to groupby concatenating multiple strings?

1 Answers1