Python grouping by and aggregating multiple columns with Pandas

Question

I'm trying to group by multiple column and aggregate on multiple as well. In sql it would give that:

SELECT A, B, C, COUNT(1), SUM(E), SUM(F) GROUP BY A, B, C

So far i came up with this but it only aggregate on one column:

df.groupby(['A','B','C')['E'].sum()

jezrael · Accepted Answer · 2017-03-22 08:21:02Z

2

It seems you need aggregate:

print (df.groupby(['A','B','C']).agg({'A':'size', 'E':'sum','F':'sum'}))

answered Mar 22, 2017 at 8:21

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Answer 1