I'm trying to reduce the size of my dataset, which is composed of 200,000 projects. Each project is defined by its size and a binary value that is 1 if the project has active users, 0 otherwise. Most of the project sizes are < 1000 (80% of the dataset).
I would like to group the projects, and for each group I would count the number of projects with active users.
I'm not sure how to group these projects. In particular, is it better to group the projects into categories with equal intervals (0-500, 501-1000, 1001-1500, ...) or into categories with the same number of projects (as a consequence, I would have unequal intervals like 0-10, 11-15, 16-40, 41-100, 101-120, ...)?