Merge rows of pandas data frame by grouping a column

Question

A beginner in panda and trying to achieve this in a pandas data frame-

Input- Input

I want an output like-

Output

It is groupby on name columns, the merge all the rows in Address and in same row store the total count of address.

Any help is appreciated.

thanks

groupby + agg , search the key words like this

BENY
– BENY

2018-03-22 20:41:38 +00:00
Commented Mar 22, 2018 at 20:41 — BENY
– BENY, Commented Mar 22, 2018 at 20:41

Scott Boston · Accepted Answer · 2018-03-22 20:46:07Z

2

Use:

(df.groupby('Name', as_index=False)
   .agg({'Count':'sum','Address':lambda x: ' \n '.join(x)}))

Output:

   Name                              Address  Count
0  Jake  XXXXXXXXX \n YYYYYYYYY \n ZZZZZZZZZ      3
1   Jon                  AAAAAAA \n BBBBBBBB      2

answered Mar 22, 2018 at 20:46

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

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

2 Comments

Machine_leaning_9 Over a year ago

Thanks, it works for me. Any suggestions to practice, so I can be as good as you :)

Scott Boston Over a year ago

@Ayum Check out the book listed in my profile by Ted Petrou and look at Stack Overflow. If I helped you would you care to accept this answer.

Collectives™ on Stack Overflow

Merge rows of pandas data frame by grouping a column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related