pandas combine rows of strings

Question

I have a pandas DataFrame like this:

Index   User    Message
1       User1   This is
2       User1   a test.
3       User2   The test
4       User2   is received.
5       User1   This is a complete sentence.
6       User2   This is another complete sentence.
7       User1   Finished.

I need a way to combine the messages when a user sends more than one message before the other while keeping the original order.

Desired output:

Index   User    Message
1       User1   This is a test.
2       User2   The test is received
3       User1   This is a complete sentence.
4       User2   This is another complete sentence.
5       User1   Finished.

Is this possible with pandas?

Space Impact · Accepted Answer · 2020-08-18 00:43:51Z

2

Try:

df = (df.groupby([df['User'].ne(df['User'].shift(1)).cumsum().values, 'User'])['Message']
        .agg(' '.join).reset_index(level=1))

answered Aug 18, 2020 at 0:43

Space Impact

13.3k26 silver badges51 bronze badges

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

1 Comment

Brian Dearing Over a year ago

This is exactly what I needed. Thank you.

Collectives™ on Stack Overflow

pandas combine rows of strings

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related