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?

Find more posts tagged with

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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