Merge multiple rows in one column on an index value

Question

After using str.extractall(), I have a multi-level dataframe that looks like this:

id  match  Names
1   0      Rob Corddry
    1      Craig Robinson
    2      Clark Duke
...
1   23     Kisha Sierra
2   0      Anne Hathaway
    1      Julie Andrews
...

I want a series or dictionary that looks like this with all the names in a single row that share the same "id":

id  Names
1   Rob Corddry, Craig Robinson, Clark Duke ... Kisha Sierra     
2   Anne Hathaway, Julie Andrews ...

I want to merge this series/dict back into the dataframe I extracted it from on the index id.

BENY · Accepted Answer · 2019-04-25 01:21:30Z

2

You can using groupby agg + join

df.groupby(level=0).agg(','.join)

answered Apr 25, 2019 at 1:21

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

Stephen Over a year ago

Perfect. Thank you @Wen-Ben

Collectives™ on Stack Overflow

Merge multiple rows in one column on an index value

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