7

In ArcMap, the user can create a table that groups the field values using summarize field tool (as shown below)

enter image description here

How can I create a table that summarizes field values in QGIS?

0

4 Answers 4

12

QGIS has a Statistics Panel that allows you to view a long list of descriptive statistics for whichever vector layer you choose. To open the statistical summary tool, either click View -> Statistical Summary OR View -> Panels -> Statistics Panel, Or you can use this icon on the toolbar enter image description here and you will get statistical description for any vector layer but only for fields with numerical types like real, integer, and long integer types. It will not work for fields of type text (string).

This an example of land use vector data:

enter image description here

2
  • I think this one should be marked as the correct answer? Its the most straightforward approach and most similar to the summarize function in Arc. Jun 6, 2019 at 21:12
  • No; although useful this appears to be the counterpart to ArcGIS "Statistics" function, not ArcGIS "Summarize" which is what the OP is looking for. Oct 22, 2020 at 13:52
4

QGIS 3.14 does this with the "Statistics by Categories" tool under Vector Analysis in the QGIS's Processing Toolbox (Ctrl+Alt+T).

screenshot

3

The more similar tool is the "Group Stats" plugin.

2

Try the plugin: "Dissolve with Stats", which can be installed from the plugin manager.

After starting the plugin from the Vector menu, you chose which layer to dissolve, which field in the attribute table to dissolve by, then which other attributes to aggregate: either count for any type of field or summarize, min, max etc for numeric fields.

The result gets saved to a new shapefile.

4
  • 2
    Can you expand more on your answer and provide more content?
    – artwork21
    Dec 25, 2017 at 14:19
  • Many Thanks Micha, I tried it and it worked fine. Is there any tool/plugin that extracts the summary to table instead of SHP? Jan 4, 2018 at 15:06
  • Just save the shapefile attribute table to a CSV.
    – Micha
    Jan 5, 2018 at 7:27
  • IS the "Dissolve with Stats" plugin still available in QGIS 3.0? Apr 10, 2018 at 1:05

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