I would like to get the average value of specific attributes. I have a table with columns like:
ID, P1, E1, Age1, P2, E2, Age2, P3, E3, AverageAgeP, AverageAgeE
Sometimes there is a value for P, sometimes there is value for E - otherwise it's NULL. I would like to calculate the average value for all cells of P using the value of the Age-field defined in this group. The same I would like to do with E.
The difficulties I see, is to select all P which are not NULL, summarize the age belonging to it and divide by the number of values used - of course excluding the NULL-values.
As I have more then 3000 records I need to do it automatically using ArcGIS 10.3 . Maybe using Python and loops...