Aggregating string and number columns at the same time using pandas GroupBy

Asked Jun 09 '22 at 10:32

Active Jun 09 '22 at 10:32

Viewed 13 times

My question is a step further from this question(Aggregating string columns using pandas GroupBy).

From

df =

id  type      name        value
1     aa        kk          11
2     bb        mm          22
3     bb        ll          33
4     aa        ll          44
5     bb        kk          55
6     aa        oo          66
7     aa        mm          77
8     bb        ll          88
9     aa        ll          99

id  type    name(list)    value(sum)
1     aa    kk,ll,mm,oo    297
2     bb    kk,ll,mm       198

Is this possible? How to achieve this?

asked Jun 09 '22 at 10:32

David H. J.

you can aggregate `','.join` and `sum`, for you not working? – jezrael Jun 09 '22 at 10:33
My syntax is ```df.groupby(['type'], as_index=False).agg({'name':','.join, 'value':'sum'})```. But it doesn't work. – David H. J. Jun 09 '22 at 10:39
It is good, what menas not working? there is error? – jezrael Jun 09 '22 at 10:40
1

I see the problem. when I used ```display(df)``` to show the result, the original ```df``` was presented, because I didn't write ```df =``` at the beginning of that sentence. – David H. J. Jun 09 '22 at 11:35

Aggregating string and number columns at the same time using pandas GroupBy

0 Answers0