Update cursor stops

Question

I am trying the following but I only get 25 in the progress field on features that have something in "Field5". It seems to stop if it encounters a blank record in Field5. What am i doing wrong?

valDict{}

with arcpy.da.UpdateCursor(table2, ["OBJECTID","Field1","Field2","Field3","Field4","Field5","Field6", "Field7", "Field8","Progress"],
                           where) as cursor:
    for row in cursor:
            try:
                if row[5] is None: #if row[5] not in (None, "", " "):
                    continue
                if row[5] in list1:
                    print ("{} is in list".format(row[0]))
                    row[9] = valDict.get(row[5]) if row[6] == "Pass" else valDict.get(row[5], 25) - 25 
                cursor.updateRow(row)
            except:
                continue

Anonymous User · Answer

valDict.get(row[5], 25)

will try to get the key (row[5]) from the dictionary valDict. If there is no key in the dictionary, it returns the default value of 25.

I take it this question is is part of your other question you posted a couple weeks ago and if that is the case, you should continue in that thread because what you are trying to do with the 'decision tree' to assign percent complete is a lot more complex than this code example can handle.

rzufelt · Answer

At a quick glance, it appears you have indentation issues, and some missing colons.

the if row[5] line has another if statement in it, without colon or what to do if true.  else statement also wrong indentation and no colon.

Don't know if this is the issue, but would expect it to be throwing syntax errors.

valDict{}

with arcpy.da.UpdateCursor(table2, ["OBJECTID","Field1","Field2","Field3","Field4","Field5","Field6", "Field7", "Field8","Progress"],
                           where) as cursor:
    for row in cursor:
            try:
                if row[5] is None: #if row[5] not in (None, "", " "):
                    continue
                if row[5] in list1:
                    print ("{} is in list".format(row[0]))
                    row[9] = valDict.get(row[5]) 
                if row[6] == "Pass":
                     missing what to do if true
                else:
                     valDict.get(row[5], 25) - 25 
                cursor.updateRow(row)
            except:
                continue

R_

CCWeedcontrol · Answer

Both row[5] and row[6] have blanks in the fields.