I have a land use shapefile, which has a column:

  • labelled "LU_1", categorising different areas quite broadly (9 categories total, they are numbered 1-7, U and V).
  • There's also a field with the area for each part ("area_ha").

I am trying to find the average area for the entirety of each category: 1: xha 2: xha etc.

How do I do this in the least technically advanced way?

  • What have you tried so far and where are you stuck? It's easier to give you suggestions if we see what you've attempted. In all honesty, a "can you do my assignment for me" question is not likely to be well-received here.
    – lambertj
    Commented Jun 8, 2023 at 15:03
  • Oh no! Definitely not trying to get an assignment done - this is only a very small part of the whole thing to be completely honest :')
    – OFLO
    Commented Jun 8, 2023 at 15:13
  • I have tried using 'zonal statistics', but that didn't seem to work, and I tried to use the field calculator in the attribute table but I'm really struggling with what functions to actually put
    – OFLO
    Commented Jun 8, 2023 at 15:15
  • Please, do not forget about "What should I do when someone answers my question?"
    – Taras
    Commented Jul 28, 2023 at 8:46

2 Answers 2


If you prefer a Processing Tool (Ctrl+Alt+T), you can use the "Statistics by categories" tool:

enter image description here

It does create a new layer with no geometries and unique categories per row and different fields with the results. For example:

enter image description here


You can easily do this using the Field Calculator. If you do not know the function or how to use it, you can type a search keyword and read the help to the function on the right. This also includes examples and a description of the arguments.

enter image description here

For your case this would be:

 mean("area_ha", group_by:="LU_1")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.