CLN/TYP: Groupby agg methods
Same as #34178. I had some trouble rebasing that PR, so just made a new PR instead.

This takes care of the comment in #34178 about staticmethod.
thanks @topper-123 
very nice.