topic Re: Attribute table statistics using arcpy (for polyline) in ArcGIS Pro Questions

Attribute table statistics using arcpy (for polyline)

MohamadAchour — Tue, 30 Mar 2021 10:22:29 GMT

hello, I have a polyline shapefile, and I need to calculate the mean value of one column of its attribute table using arcpy.

Any suggestion?

Re: Attribute table statistics using arcpy (for polyline)

DanPatterson — Tue, 30 Mar 2021 11:59:58 GMT

As in Summary Statistics (Analysis)—ArcGIS Pro | Documentation

or is it something different you are looking for?

Re: Attribute table statistics using arcpy (for polyline)

DanPatterson — Tue, 30 Mar 2021 12:10:20 GMT

or perhaps

import numpy as np from arcpy.da import TableToNumPyArray fc = r"C:\Git_Dan\npgeom_bak\Project_npg\npgeom.gdb\Ontario_singlepart" arr = TableToNumPyArray(fc, "Shape_Length", skip_nulls=True) np.mean(arr["Shape_Length"]) 84684.37997765756

Re: Attribute table statistics using arcpy (for polyline)

MohamadAchour — Tue, 30 Mar 2021 12:30:46 GMT

I will try this one.

Thanks a lot.

Re: Attribute table statistics using arcpy (for polyline)

DanPatterson — Tue, 30 Mar 2021 12:33:24 GMT

import numpy as np from arcpy.da import SearchCursor values = np.mean([row[0] for row in SearchCursor(fc, "Shape_Length")])

An equivalent but slower method, if there are no nulls (an extra hoop to jump through is necessary if there are nulls)