Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About DavidPike
DavidPike
MVP Notable Contributor
since
01-21-2020
Wednesday
2724
Posts created
1006
Kudos given
392
Solutions
1284
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by DavidPike
|
POST
|
import arcpy
input_table = r'put the path to your table here'
#lcb is the lower class boundary
width_age_range_1 = 14.5
lcb_age_range_1 = 0.0
width_age_range_2 = 50.0
lcb_age_range_2 = 14.5
width_age_range_3 = 35.5
lcb_age_range_3 = 64.5
median_list = [ ]
with arcpy.da.SearchCursor(input_table, ["TOT", "TOT_0_14", "TOT_15_64", "TOT_65"]) as cursor :
for row in cursor :
#if all numeric fields hopefully
n_over2 = (row[0]/2.0)
if row[0] == 0 :
median_list.append(-9999)
continue
if row[1] >= n_over2 :
#cumulative freq of groups before median group
cumu_freq = 0.0
if row[1] != 0.0 :
median = lcb_age_range_1 + ( ((n_over2 - cumu_freq)/row[1]) * width_age_range_1)
median_list.append(median)
continue
continue
if (row[1] + row[2]) >= n_over2 :
#cumulative freq of groups before median group
cumu_freq = row[1]
if row[2] != 0.0 :
median = lcb_age_range_2 + ( ((n_over2 - cumu_freq)/row[2]) * width_age_range_2)
median_list.append(median)
continue
continue
if (row[1] + row[2] + row[3]) >= n_over2 :
#cumulative freq of groups before median group
cumu_freq = row[1] + row[2]
if row[3] != 0.0 :
median = lcb_age_range_3 + ( ((n_over2 - cumu_freq)/row[3]) * width_age_range_3)
median_list.append(median)
continue
continue
else:
median_list.append(-999)
#for median in median_list:
#print(median)
counter = 0
with arcpy.da.UpdateCursor(input_table, ["median"]) as cursor :
for row in cursor :
if counter < len(median_list):
row[0] = median_list[counter]
try :
cursor.updateRow(row)
counter += 1
except :
print("error at count - " + str(counter))
else:
break
print("complete")
... View more
02-01-2020
04:57 AM
|
2
|
13
|
9032
|
|
POST
|
You could pretty easily populate the column by copying and pasting the printed values into your blank column whilst editing the table. Are they correct?
... View more
01-31-2020
04:47 PM
|
2
|
1
|
1899
|
|
POST
|
Wow, I'd test the results against your website, bear in mind it may have calculated lower class boundaries different from what you expected. Basically test quite a few features to see if correct result
... View more
01-31-2020
04:40 PM
|
2
|
1
|
1899
|
|
POST
|
What's the names of your columns? Are those aliases? I was guessing the spaces were underscores. Replace the names in the 'with arcpy.searchcursor ' line with their proper names
... View more
01-31-2020
04:06 PM
|
2
|
1
|
1899
|
|
POST
|
Haha, I've edited the original to count it as a list rather than new parameters. My bad.
... View more
01-31-2020
03:56 PM
|
2
|
9
|
2278
|
|
POST
|
Can you export your shapefile to a feature class? Not sure what's wrong.
... View more
01-31-2020
03:34 PM
|
2
|
11
|
2278
|
|
POST
|
Hi, I've edited the original code to account for my stupidity. Also you need to specify you path with 'r' then in quotes as per the code. E.g. r'c:/users/david/project.gdb'
... View more
01-31-2020
03:04 PM
|
2
|
15
|
2278
|
|
POST
|
Sorry change all those double equal signs to one equals sign up to and including line13
... View more
01-31-2020
02:39 PM
|
2
|
18
|
5433
|
|
POST
|
Rafael, Unfortunately I dont have a home license for arcmap to test this. Do you have an IDE? If not I cant talk you through making it as a tool
... View more
01-31-2020
02:13 PM
|
2
|
22
|
5433
|
|
POST
|
import arcpy
input_table = r'put the path to your table here'
#lcb is the lower class boundary
width_age_range_1 = 14.5
lcb_age_range_1 = 0.0
width_age_range_2 = 50.0
lcb_age_range_2 = 14.5
width_age_range_3 = 35.5
lcb_age_range_3 = 64.5
median_list = [ ]
with arcpy.da.SearchCursor(input_table, ["TOT", "TOT_0_14", "TOT_15_64", "TOT_65"]) as cursor :
for row in cursor :
#if all numeric fields hopefully
n_over2 = (row[0]/2.0)
if row[1] >= n_over2 :
#cumulative freq of groups before median group
cumu_freq = 0.0
if row[1] != 0.0 :
median = lcb_age_range_1 + ( ((n_over2 - cumu_freq)/row[1]) * width_age_range_1)
median_list.append(median)
continue
continue
if (row[1] + row[2]) >= n_over2 :
#cumulative freq of groups before median group
cumu_freq = row[1]
if row[2] != 0.0 :
median = lcb_age_range_2 + ( ((n_over2 - cumu_freq)/row[2]) * width_age_range_2)
median_list.append(median)
continue
continue
if (row[1] + row[2] + row[3]) >= n_over2 :
#cumulative freq of groups before median group
cumu_freq = row[1] + row[2]
if row[3] != 0.0 :
median = lcb_age_range_3 + ( ((n_over2 - cumu_freq)/row[3]) * width_age_range_3)
median_list.append(median)
continue
continue
else:
median_list.append("error")
for median in median_list :
print(median)
#obviously can add a field and append these values in rather than printing them. look at arcpy.da.UpdateCursors
... View more
01-31-2020
12:04 PM
|
3
|
24
|
5433
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 06-13-2025 01:08 PM | |
| 1 | 09-25-2025 03:19 PM | |
| 1 | 09-24-2025 02:35 PM | |
| 1 | 09-17-2025 02:42 PM | |
| 1 | 09-10-2025 02:35 PM |
Activity Feed
- Posted Re: ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings on ArcGIS Pro Questions. Wednesday
- Kudoed Re: ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings for RichardDaniels. Wednesday
- Kudoed Re: ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings for RichardDaniels. Wednesday
- Posted Re: ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings on ArcGIS Pro Questions. a week ago
- Posted ArcGIS Pro in Azure Virtual Desktop AVD - lock licensing settings on ArcGIS Pro Questions. a week ago
- Posted Re: Regedit values to start up ArcGIS Pro as named user on ArcGIS Pro Questions. 2 weeks ago
- Got a Kudo for Survey123 _form hosted feature layer view. 04-16-2026 02:54 PM
- Got a Kudo for Survey123 _form hosted feature layer view. 04-16-2026 02:51 PM
- Got a Kudo for Survey123 _form hosted feature layer view. 02-05-2026 10:43 AM
- Posted Re: ArcGIS Concurrent (desktop) License Server - 'ACT' extension name meaning on ArcGIS Enterprise Questions. 01-14-2026 12:11 PM
- Kudoed Re: ArcGIS Concurrent (desktop) License Server - 'ACT' extension name meaning for JoshuaBixby. 01-14-2026 12:10 PM
- Posted ArcGIS Concurrent (desktop) License Server - 'ACT' extension name meaning on ArcGIS Enterprise Questions. 01-07-2026 01:22 PM
- Got a Kudo for Re: Broken bookmarks in Arc Pro. 12-19-2025 08:08 AM
- Got a Kudo for Re: Define Projection crack-down. 12-11-2025 06:02 AM
- Posted ArcMap 10.8.2 virtualisation - Azure Virtual Desktop (AVD) on ArcMap Questions. 12-03-2025 11:07 AM
- Kudoed Re: S123 web not honoring bind::type entered in connect for Neal_t_k. 11-14-2025 12:57 PM
- Kudoed Re: Way to convert indicator values to whole numbers for KenBuja. 11-14-2025 09:55 AM
- Kudoed Re: Way to convert indicator values to whole numbers for Neal_t_k. 11-14-2025 09:55 AM
- Kudoed Re: How to paste in a long list of data to existing polygon features? for Bud. 11-10-2025 03:51 AM
- Kudoed Re: Identify missing lines between two datasets for VinceAngelo. 10-07-2025 01:02 PM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Wednesday
|