Python group by and aggregate

[ThomasL]

Hi Alex,
what i sometimes do if i would like to know what methods can be used on an object is this:

[func for func in dir(test.groupby('ID')) if func[0] != '_']

This gives you a long list of methods and/or properties.

In your case test.groupby('ID').sum() might be interesting.
Look also into .count() .groups .nunique()