Looking for QGIS equivalent of ArcGIS "Summarize"

Question

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

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

score 14 · Answer 1 · answered Dec 25 '17 at 01:32

14

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 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:

answered Dec 25 '17 at 01:32

ahmadhanb

40,826
5
51
105

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. – June Skeeter Jun 06 '19 at 21:12
2

No; although useful this appears to be the counterpart to ArcGIS "Statistics" function, not ArcGIS "Summarize" which is what the OP is looking for. – Sideshow Bob Oct 22 '20 at 13:52

score 7 · Answer 2 · edited Mar 23 '22 at 11:51

7

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

edited Mar 23 '22 at 11:51

Taras

32,823
4
66
137

answered Oct 22 '20 at 13:51

Sideshow Bob

2,333
14
20

This should be the actual answer. As Sideshow Bob said, the QGIS "Statistics Panel" apparently does the same as right clicking on a field in ArcGIS and clicking "Statistics". What we're looking for is the equivalent of ArcGIS "Summarize". For example, I wanted to find the frequency of each value in a field. In ArcGIS to do this I would right click on a field header and then choose "Summarize". I accomplished this in QGIS using the "Statistics by categories" tool shown here. Maybe "Dissolve with Stats" is also a solution, but this is better because it uses a built in tool, not a plugin. – Matt Leonard Jun 24 '23 at 16:27

score 3 · Accepted Answer · edited Mar 23 '22 at 11:52

3

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.

edited Mar 23 '22 at 11:52

Taras

32,823
4
66
137

answered Dec 25 '17 at 08:33

Micha

15,555
23
29

2

Can you expand more on your answer and provide more content? – artwork21 Dec 25 '17 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? – Hani Draidi Jan 04 '18 at 15:06
Just save the shapefile attribute table to a CSV. – Micha Jan 05 '18 at 07:27
IS the "Dissolve with Stats" plugin still available in QGIS 3.0? – Mary Johnson Apr 10 '18 at 01:05

score 3 · Answer 4 · edited Mar 23 '22 at 11:51

3

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

edited Mar 23 '22 at 11:51

Taras

32,823
4
66
137

answered Dec 29 '17 at 07:19

Carlos López Quintanilla

1,519
10
15

Looking for QGIS equivalent of ArcGIS "Summarize"

4 Answers4

Linked

Related