How can I group by data based on specific value ranges using pandas/numpy?

Question

I'm trying to aggregate data in a pandas series based on its numeric 3 digit ID (101, 234, 531, 232) and I want to find a way that I can create a series with the count of all of the values in the range of hundreds (100 : 1, 200: 2, 500 : 1). Is there any way to do this using numpy/pandas functions instead of just iterating through the series and counting each value individually?

Joe Patten · Accepted Answer · 2019-01-22 21:10:50Z

1

The following code should give you the correct output:

df.groupby(df['id']//100*100).count()

Output:

answered Jan 22, 2019 at 21:10

Joe Patten

1,7041 gold badge11 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

How can I group by data based on specific value ranges using pandas/numpy?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related