How to concat strings in rows groupby column and index in dataframe?

Question

I have a dataframe that looks like this:

    text
0   dog went to the store.    
0   cat is tall.
0   blue is red.
1   red is blue
1   blue is red

How do I concat the strings by row and group by index, so that the new df looks like this?:

    text
0   dog went to the store. cat is tall. blue is red.  
1   red is blue.blue is red

I've tried, but this is doing nothing and returns back the same number of rows, not sure where to go from here:

 df[['text']].groupby(df.index)['text'].transform(lambda x: ','.join(x))

PaulS · Accepted Answer · 2022-12-07 00:38:29Z

1

A possible solution (just replace transform by agg):

df[['text']].groupby(df.index)['text'].agg(lambda x: ','.join(x))

Output:

0    dog went to the store.,cat is tall.,blue is red.
1                             red is blue,blue is red
Name: text, dtype: object

answered Dec 7, 2022 at 0:38

PaulS

27.1k3 gold badges19 silver badges40 bronze badges

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

2 Comments

you got it first. but same answer as above.

@RustyShackleford the other user is using a bot to generate the answers