Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Are there QGIS tools that will allow users to get tabular statistics from their table? I kind of expected I would be able to just open the table, select the field I was interested in, right-click on the field header and get something similar to this (screenshot taken from ArcGIS):

frequency report

More specifically, I am looking for a QGIS alternative to the ArcGIS Frequency and Summary Statistics tools, that offer a host of other stats you can retrieve about the tabular data.

UPDATE: So, just after asking, I finally found this QGIS Tutorial (see section 4.2 ) that describes how to find this functionality... Vector > Analysis Tools > Basic statistics. I also found Vector > Analysis Tools > List Unique Values right next to it. This gets me the list of unique values, but I would also like to see an additional column of frequency (count) of each unique item. Is this similar tool available "out-of-the-box"?

share|improve this question

1 Answer 1

up vote 12 down vote accepted

Statist plugin is going to be your friend here:

enter image description here

IMHO - it beats ESRI approach hands down with both functionality and aesthetics.


For looking at groupings of your data I'd also recommend Group Stats plugin:

enter image description here

Although (afaik) it doesn't work with single variables, it comes really handy for getting quick summaries of most important parameters of distribution of certain variable across groups of other variable. And yet again - ESRI is far beyond here.


I've also seen Spqr out there, but haven't had chance to give it a proper spin. It works with R and looks really promising, but seems to be still in early days, and as author suggests it is:

For experts and crazy people only. Bits of this aren't implemented and other bits don't work and most of it will break if you push it.

share|improve this answer
1  
Group Stats is a great little utility. Its a shame that the field sorting for numeric values like count, sum, etc uses alphanumeric sorting (ie- 1,10,100,2,21,3,350) instead of numeric sorting. But the fact that you can at least copy/paste the results into a spreadsheet and re-sort that way makes it pretty useful. –  RyanDalton Dec 5 '12 at 5:34
1  
I have submitted a bug report for Group Stats sorting. –  RyanDalton Dec 5 '12 at 5:52
    
@RyanDalton I agree - from my perspective it would be much more desirable to have numeric sorting in 90% of the cases. Let's hope your report will get noticed :] –  radek Dec 5 '12 at 10:59
1  
It looks like the bug report for sorting numerically will be fixed in an upcoming release (updated 1/16/2013). That's great sounding news! –  RyanDalton Jan 17 '13 at 4:04
    
@RyanDalton It is indeed - thanks for an update! –  radek Jan 17 '13 at 9:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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