Concat rows in pandas DataFrame with another text

Question

I need help with realisation of the following logic: While grouping a DataFrame I want certain columns to be concatenated with another text. For example:

Input:

id | col1 | col2
---|------|------
1  |  A   | 12
1  |  B   | 43
---|------|-----

After applying something like df.groupby(id).concatrows("text_"+col1+":"+col2.astype(str)), the desired output should be:

id | new col
---|-----------------------
1  | text_A:12;text_B:43   
---|-----------------------

So it should be kind of ";".join(), but with more flexibility.

fuglede · Accepted Answer · 2019-08-31 19:54:21Z

2

One option could be the following:

df.groupby('id').apply(lambda g: ';'.join('text_' + g.col1 + ':' + g.col2.astype(str)))

Output:

id
1    text_A:12;text_B:43

answered Aug 31, 2019 at 19:54

fuglede

18.3k3 gold badges62 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mark Wang · Accepted Answer · 2019-08-31 19:55:46Z

0

Another option is to concatenate col1 and col2 first before concatenating groups,

("text_" + df['col1'] + ":" + df['col2'].astype(str)).groupby(df['id']).apply(';'.join)

answered Aug 31, 2019 at 19:55

Mark Wang

2,7579 silver badges18 bronze badges

Collectives™ on Stack Overflow

Concat rows in pandas DataFrame with another text

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related