This question already has an answer here:
I'm new in the GIS world.
I have a bunch of points (around 40,000), which are split in categories (1 to 9) and have a field which specifies their membership to a polygon (~50) (e.g, 30, which would mean that the point is located in polygon 30).
Some zones do not contain points of all categories.
I wish to know the frequency of each category per zone, in such a way that in the end I would have a table with the first column for the categories, and the zones listed in the first row.
Did somebody have the same challenge? How did you solve it?