Hello Tyson, sorry for the delay - more than 1 way to do this but I flung this together in IDLE, based on the last shapefile - see the attached for an 'updated' copy of the last so if you haven't changed yours, may as well overwrite it with this one.Here's the code I used - again, since this is a 'one-off', I was just winging it with this below, so better check the shp results, the fields you designated for counts--
>>> import arcpy
>>> shp = r'E:\schoolTestData\schoolJoinToPolys4.shp'
>>> query = arcpy.AddFieldDelimiters(shp, 'outGrades') + ' NOT IN (\' \')'
>>> print query
"outGrades" NOT IN (' ')
>>> rows = arcpy.UpdateCursor(shp, query)
>>> for row in rows:
outGrades = row.outGrades.split(',')
outGrades.sort()
count = 0
compareVal = outGrades[0]
for each in outGrades:
if each == compareVal:
count += 1
else:
if not compareVal in ['KA', 'KP', 'PA', 'PP']:
fieldName = 'Grade_' + str(int(compareVal))
else:
fieldName = 'Grade_K'
count += row.getValue(fieldName)
row.setValue(fieldName, count)
rows.updateRow(row)
count = 1
compareVal = each
# load the last unique val
if not compareVal in ['KA', 'KP', 'PA', 'PP']:
fieldName = 'Grade_' + str(int(compareVal))
else:
fieldName = 'Grade_K'
count += row.getValue(fieldName)
row.setValue(fieldName, count)
rows.updateRow(row)
>>> del row, rows
>>>
I wasn't sure about the codes in the list ['KA', 'KP', 'PA', 'PP'], so I flung a cumulative count into K1 or whatever you called the 1st field. Sorry if that's not quite what you intended, but easily modified.Seriously though, the biggest hangup I had was remembering to only treat the records with values - kept getting this error:
Traceback (most recent call last):
File "<pyshell#81>", line 21, in <module>
fieldName = 'Grade_' + str(int(compareVal))
ValueError: invalid literal for int() with base 10: ''
And all that means is that I encountered an 'untreated' blank value, typical of shapefiles, just I was trying to filter it out using IS NOT NULL. I ended up forming the query finally, and avoided the error with NOT IN (\' \')' which is translated as NOT IN ' '. Details!Enjoy,WayneEDIT- think I forgot the attachment...it's there now.
