In ArcMap, the right-click Summarize option very quickly creates a frequency listing of the chosen field:


enter image description here

Note that the count field shows the count of duplicate values. How can I access this using ArcPy?

Is it possible to access ArcGIS's table operations "Summarize..." and "Statistics..." in python? suggests using Summary Statistics, but I can't get any meaningful output from this tool. Instead, it always just lists the total count of features, rather than the frequency of each individual value:

enter image description here

How can I achieve the result from the second screenshot above, using ArcPy in ArcMap 10.0 with an ArcEditor license (whereby I can't run the FREQUENCY command)?

Dan Patterson's script applies to ArcGIS 9.3 so (probably) isn't useful?


1 Answer 1


I think you need to include a Case Field. If you do not see this on the tool dialog, be sure to increase its size or use the slider bar on the right hand side to see it.

From Summary Statistics help:

"If a Case field is specified, statistics will be calculated separately for each unique attribute value. The Output Table will contain only one record if no Case field is specified. If one is specified, there will be one record for each Case field value."


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.