Multiple aggregate functions on a dataframe

Question

Trying to run the below line

df = df.groupby(['Name', 'ID']).agg(Average_Revenue=('Amount', np.mean), Sum_Revenue=('Amount', np.sum))

but I recieve the error:

TypeError: func is expected but received tuple in **kwargs.

According to all the documentation I have looked at not sure why this is giving an error, can anyone help please

what's your pd.__version__? named aggregation requires at least v0.25.0 — tdy
– tdy, Commented Oct 13, 2022 at 20:37
you should post a small sample dataframe that can reproduce the error — tdy
– tdy, Commented Oct 13, 2022 at 20:43
sorry guys I just found my error, I was trying to use this line of code on a dataframe that was already grouped. I Apologize for wasting everyones time — Samir112
– Samir112, Commented Oct 13, 2022 at 20:48

misterhuge · Accepted Answer · 2022-10-13 20:42:34Z

1

can you post some data, versions, etc? this seems to work for me on Python 3.7.6, pandas 1.2.1, numpy 1.20.0:

import pandas as pd
import numpy as np
df = pd.DataFrame([
    ['joe', 111, 25.0],
    ['joe', 111, 30.0]
], columns=['Name', 'ID', 'Amount'])
df.groupby(['Name', 'ID']).agg(Average_Revenue=('Amount', np.mean), Sum_Revenue=('Amount', np.sum))

        Average_Revenue Sum_Revenue
Name    ID      
joe 111 27.5    55.0

answered Oct 13, 2022 at 20:42

misterhuge

4143 silver badges8 bronze badges

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

1 Comment

user7711283 Over a year ago

Same here (it works): Python 3.9.13, pandas 1.4.2, numpy 1.23.2

Collectives™ on Stack Overflow

Multiple aggregate functions on a dataframe

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