pandas - combine strings of row

Question

I have a dataframe like this:

    id        text
    1         DM,HTN,Enlarged prostate
    2         hypertensive and on regular treatment
    2         LBP
    3         DM,HTN,Enlarged prostate

I want to combine the text of same id like this:

   id        text
   1         DM,HTN,Enlarged prostate
   2         hypertensive and on regular treatment LBP
   3         DM,HTN,Enlarged prostate

the texts of id 2 are combined. how can i acchieve this? Any help would be appreciated.

open source guy · Accepted Answer · 2016-05-25 04:46:34Z

3

You can use group by function to do this

grouped_df = df.groupby("id").apply(lambda x: "%s" % ' '.join(x['text']))

answered May 25, 2016 at 4:46

open source guy

2,78710 gold badges40 silver badges62 bronze badges

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

Comments

jezrael · Accepted Answer · 2016-05-25 05:33:03Z

2

You can use groupby and apply function join. Last reset_index:

grouped_df = df.groupby("id")['text'].apply(' '.join).reset_index()
print (grouped_df)
   id                                       text
0   1                   DM,HTN,Enlarged prostate
1   2  hypertensive and on regular treatment LBP
2   3                   DM,HTN,Enlarged prostate

answered May 25, 2016 at 5:33

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

3 Comments

Huge Min Over a year ago

Thanks for the details! Checking on the functions

Huge Min Over a year ago

It worked perfectly. might be even better than the other answer because I got a dataframe instead of series with this code. Saved me some work, appreciate it.

Huge Min Over a year ago

ah sorry, first time posting a question

Collectives™ on Stack Overflow

pandas - combine strings of row

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related