Summarising all fields in attribute table using ArcPy? [closed]

Question

I was hoping to run a script that will iterate through all fields in an attribute table, SUM each field and produce the result in a table.

The script below will essentially do what I want with one field but is there a way for it to iterate through all fields?

import arcpy

from arcpy import env  

env.workspace = "C:/data/Habitat_Analysis.gdb"  

arcpy.Statistics_analysis("FIELD_NAME", "C:/output/output.gdb/TABLE_OUTPUT", [["SUM"]])

(the above sample was sourced here: http://resources.arcgis.com/en/help/main/10.1/index.html#//00080000001z000000)

Answer 1

Doesn't the third example script in the link you mentioned do exactly what you want in a single table?

# Import system modules
import arcpy

# Set environment settings
arcpy.env.workspace = r"C:/data/Habitat_Analysis.gdb"

# Set local variables
intable = "FIELD_NAME"
outtable = "C:/output/output.gdb/TABLE_OUTPUT"
# casefield = "Name" Not used
stats = []

# Loop through all fields in the Input Table
for field in arcpy.ListFields(intable):
    # Just find the fields that have a numeric type
    if field.type in ("Double", "Integer", "Single", "SmallInteger"):
        # Add the field name and Sum statistic type
        #    to the list of fields to summarize
        stats.append([field.name, "Sum"])
# Correct formatting of stats [["Field1", "Sum"], ["Field2", "Sum"], ...]

# Run the Summary Statistics tool with the stats list
arcpy.Statistics_analysis(intable, outtable, stats)

Answer 2

I would use a SearchCursor wrapped in a generator to get the summed fields. This is the full workflow:

1. List all of the fields
2. Create a function with a SearchCursor wrapped in a generator
3. Loop through the fields
4. Limit the fields to only those that are necessary with logic and implement the function

---

import arcpy, os

fc = r'C:\Users\OWNER\Documents\ArcGIS\Default.gdb\utm15\mypolys'

fields = arcpy.ListFields(fc)

def sumFields(x, y):
    field = sum([row[0] for row in arcpy.da.SearchCursor(x, y)])
    print "The sum of Field: %s = %s" % (y, field)

for f in fields:
    if f.type != "OID" and f.type != "Geometry":
        sumFields(fc, f.name)

---

Answer 3

Before you can complete your script I think you should write a short test script that simply takes a feature class and prints out the name of each field using ListFields.

From there modify your script so that only the names of numeric fields are printed - because you want to SUM them.

The final step is to incorporate a for loop to iterate your Summary Statistics.

Answer 4

Have a look at the ListFields function. Note, you'll want to limit your results to numeric only fields, otherwise, you might get an error. So, you may want to use something like the following:

int_fields = arcpy.ListFields("C:/data/Habitat_Analysis.gdb", , "Integer")

to get a list of all integer fields.

then

small_int_fields = arcpy.ListFields("C:/data/Habitat_Analysis.gdb", , "SmallInteger")

to get a list of all small integer fields. Repeat again for doubles.

double_fields = arcpy.ListFields("C:/data/Habitat_Analysis.gdb", , "Double")

Finally, you can merge the lists together:

fields = int_fields + small_int_fields + double_fields

Then, you can iterate through all fields with a for loop.