I have the following layers :
- Sectors (polygons limited by the black lines)
- Houses (polygons in light blue)
I have created the area attribute in the Houses table. I have also created an attribute that represents the centroid of the geometry.
I would like to calculate the mean area of Houses located in each sector and add it as an attribute of the Sectors table. A house is considered "in the sector" if its centroid is in the sector (to avoid problems with houses over 2 different sectors).
I don't know how to do this "group by" operation and haven't found answers searching this stack.