Reshaping DataFrame in Pandas Python

Question

I have a python pandas data frame like this

col1 col2 col3  
s1   a    2  
s1   b    1  
s1   c    3  
s2   d    2  
s2   e    5  
s2   f    1  
s3   a    2

I want to reshape it like this

col1  col2_appended col3_sum  
s1    a,b,c         6  
s2    d,e,f         8     
s3    a             2

First column has distinct values from col1, the second column has values of col2 concatenated with commas and the 3rd column has sum of col3.

rafaelc · Accepted Answer · 2018-07-06 12:32:59Z

4

Use

df.groupby('col1', as_index=False).agg({'col2': ','.join, 'col3': sum})

    col1    col2    col3
0   s1      a,b,c   6
1   s2      d,e,f   8
2   s3      a       2

answered Jul 6, 2018 at 12:32

rafaelc

59.4k15 gold badges64 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

Reshaping DataFrame in Pandas Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related