arcpy.analysis.Frequency(in_table, out_table, frequency_fields, {summary_fields})
|
Name
|
Explanation
|
Data type
|
|
in_table
|
The table containing the fields that will be used to calculate frequency statistics.
|
Table View; Raster Layer
|
|
out_table
|
The output table that will store the frequency statistics.
|
Table
|
|
frequency_fields
[frequency_fields,...]
|
The fields that will be used to calculate frequency statistics. Each unique combination of field values will be included as a new row in the output table.
|
Field
|
|
summary_fields
[summary_fields,...]
(Optional)
|
The numeric attribute fields that will be summed and added to the output table. Values will be summed for each unique combination of frequency fields. Null values will be excluded from this calculation.
|
Field
|
Code sample
Frequency example 1 (Python window)
The following Python window script demonstrates how to use the Frequency function in immediate mode.
import arcpy
arcpy.env.workspace = "C:/data/Portland.gdb/Taxlots"
arcpy.analysis.Frequency("taxlots",
"C:/output/output.gdb/tax_frequency",
["YEARBUILT", "COUNTY"],
["LANDVAL", "BLDGVAL", "TOTALVAL"])
Frequency example 2 (stand-alone script)
The following stand-alone script demonstrates how to use the Frequency function.
# Description: Run Frequency on a table
# Import system modules
import arcpy
# Set environment settings
arcpy.env.workspace = "C:/data/Portland.gdb/Taxlots"
# Set local variables
inTable = "taxlots"
outTable = "C:/output/output.gdb/tax_frequency"
frequencyFields = ["YEARBUILT", "COUNTY"]
summaryFields = ["LANDVAL", "BLDGVAL", "TOTALVAL"]
# Run Frequency
arcpy.analysis.Frequency(inTable, outTable, frequencyFields, summaryFields)
Frequency example 3 (stand-alone script)
The following stand-alone script demonstrates how to use many geoprocessing scripting functions, including the Frequency function.
# Description: Break all multipart features into single part features,
# and generate a report of which features were separated.
# Import system modules
import arcpy
# Create variables for the input and output feature classes
inFeatureClass = "c:/data/gdb.gdb/vegetation"
outFeatureClass = "c:/data/gdb.gdb/vegetation_singlepart"
try:
# Create list of all fields in inFeatureClass
fieldNameList = [field.name for field in arcpy.ListFields(inFeatureClass)]
# Add a field to the input this will be used as a unique identifier
arcpy.management.AddField(inFeatureClass, "tmpUID", "double")
# Determine what the name of the Object ID is
OIDFieldName = arcpy.Describe(inFeatureClass).OIDFieldName
# Calculate the tmpUID to the OID
arcpy.management.CalculateField(inFeatureClass, "tmpUID",
"[" + OIDFieldName + "]")
# Run the tool to create a new fc with only singlepart features
arcpy.management.MultipartToSinglepart(inFeatureClass, outFeatureClass)
# Check if there is a different number of features in the output
# than there was in the input
inCount = int(arcpy.management.GetCount(inFeatureClass)[0])
outCount = int(arcpy.management.GetCount(outFeatureClass)[0])
if inCount != outCount:
# If there is a difference, print out the FID of the input
# features which were multipart
arcpy.analysis.Frequency(outFeatureClass,
outFeatureClass + "_freq", "tmpUID")
# Use a search cursor to go through the table, and print the tmpUID
print("Multipart features from {0}".format(inFeatureClass))
for row in arcpy.da.SearchCursor(outFeatureClass + "_freq",
["tmpUID"], "FREQUENCY > 1"):
print(int(row[0]))
else:
print("No multipart features were found")
except arcpy.ExecuteError:
print(arcpy.GetMessages())
except Exception as err:
print(err)