hey,
i want to calculate the average value of these 5 rows and ther result will be wrriten in the Group_AVerage
can someone help with this calculation ?
image :
thanks..
I would love to help, but this makes no sense.
Amanda, they are looking to calculate a "moving block mean", which is like a running mean but you increment the sliding/moving window by a value > 1
from numpy.lib.stride_tricks import sliding_window_view as sw
a = np.arange(1, 11)
a
array([ 1, 2, 3, 4, 5, 6, 7, 8, 9, 10])
a0 = sw(a, 5)
a1 = sw(a, 5)[::5, :]
a0.mean(axis=-1)
array([3., 4., 5., 6., 7., 8.])
a1.mean(axis=-1)
array([3., 8.])
so you would have to create the array outside Pro using TableToNumPyArray
There is little point bringing back the results into an existing table, but you could generate a results array and bring it back using NumPyArrayToTable.
An interesting but pointless venture at this stage
If you would like to interactively select the rows, and define their mean value, then
After selecting rows, right-click on the "numeric" field whose mean value you want to calculate > Statistics.
Copy the desired value, and define it to the Group_Average field using Calculate Field.
__________________________________________________________________________________________________
In case you have a field based on which you can categorize the groups,
1. Dissolve the table based on the category field. For Statistics Field parameters, define the numeric field . Statistics Type=Mean.
2. Then use Join Field to join the Mean_<Value> field to your original Attribute Table based on the Category Field.