Using HAVING after a pandas group by

Asked Oct 02 '19 at 00:17

Active Oct 02 '19 at 00:17

Viewed 34 times

I was looking at the answers here: Group by, having in pandas

The problem is, the second answer doesn't work if you do something like

homeruns = df(data['hr'].groupby([data['year'], data['team_id']]).mean())

because homeruns will be a series.

So what should the best workaround be for this situation?

asked Oct 02 '19 at 00:17

I think the following might be of relevance: https://stackoverflow.com/questions/10373660/converting-a-pandas-groupby-output-from-series-to-dataframe – ex-punctis Oct 02 '19 at 00:51
Can you give `data.head()` to recreate what are you working on? – Plajerity Oct 02 '19 at 00:58
https://stackoverflow.com/help/minimal-reproducible-example – Michael Gardner Oct 02 '19 at 01:09

0 Answers0