
        
        
            
                
                
                    import pandas as pd

df = pd.DataFrame({"Name":["Mary","Sky","James"],"Hobbies":["Cooking","Travel","Cooking"]})
df
                
            
                Name  Hobbies
0   Mary  Cooking
1    Sky   Travel
2  James  Cooking

To group by 'Hobbies' and merge names of all people with each hobby into a single row:


        
        
            
                
                
                    df.groupby('Hobbies', as_index=False).agg({'Hobbies' : 'first', 'Name' : ' '.join})
                
            
               Hobbies        Name
0  Cooking  Mary James
1   Travel         Sky

Notice how the names of people sharing the same hobby appear in a single line separated by ' '.

Specifying delimiter

We can specify the delimiter to use by placing it before the join(~) method like so:


        
        
            
                
                
                    df.groupby('Hobbies', as_index=False).agg({'Hobbies' : 'first', 'Name' : ', '.join})
                
            
              Hobbies         Name
0  Cooking  Mary, James
1   Travel          Sky

Here we specify the delimiter as a comma followed by a space.

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!