nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Attribute table statistics using arcpy (for polyline)

MohamadAchour

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?

Vind meer berichten getagd met

Analysis

Desktop

Feature Services

Accepted answers

danretired

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)

All comments

danretired

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)

MohamadAchour

I will try this one.

Thanks a lot.

danretired

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

danretired

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

or is it something different you are looking for?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.