How to use .mode with groupby

Question

i can use mean and median with groupby with this line:

newdf.groupby('dropoff_site')['load_weight'].mean()
newdf.groupby('dropoff_site')['load_weight'].median()

But when i use it for mode like this:

newdf.groupby('dropoff_site')['load_weight'].mode()

An error popped up, saying: 'SeriesGroupBy' object has no attribute 'mode'

What should i do?

source2.groupby(['Country','City'])['Short name'].agg(pd.Series.mode)

as

newdf.groupby(['dropoff_site'])['load_weight'].agg(pd.Series.mode)

because this has multimodal, but now the error goes: Must produce aggregated value

This is because `mode` does not necessarily produce a unique value (there can be several modes) — mozway, Oct 13 '22 at 12:07

score 1 · Answer 1 · answered Oct 13 '22 at 12:09

1

Try this...

newdf.groupby('dropoff_site')['load_weight'].agg(pd.Series.mode)

answered Oct 13 '22 at 12:09

Sachin Kohli

2

i tried it, the error: "Must produce aggregated value" popped up – Huesca Rashad Oct 13 '22 at 12:48

1 Answers1