topic The row contains a bad value in Python Questions

The row contains a bad value

2Quiker — Wed, 21 Apr 2021 22:07:57 GMT

I have the following and I having a hard time by passing some blank attributes. I know what the problem is, the problem is that row Pin has blanks and when the codes tries to populate the Permits row it throws the 'The row contains a bad value' Error. It's trying to bunch all of 'P_num' that have a blank into the Permits row. How can I get passed this?

dict1 = dict() with arcpy.da.SearchCursor(fc,['Pin','Perm_COUNT','P_Num']) as cursor: for row in cursor: if row not in (None, "", " "): dict1.setdefault(row[0],[]).append(str(row[2])) #print (dict1) with arcpy.da.UpdateCursor(fc,['Pin','Perm_COUNT','Permits']) as cursor: for row in cursor: row[2] = ",".join(dict1[row[0]]) #print (",".join(dict1[row[0]])) cursor.updateRow(row)

Re: The row contains a bad value

RandyBurton — Thu, 22 Apr 2021 06:58:36 GMT

The search cursor is returning a tuple of 3 elements matching the three fields requested. The check for None is being done on the tuple when it should be the first element which matches the 'Pin' field. Try:

with arcpy.da.SearchCursor(fc,['Pin','Perm_COUNT','P_Num']) as cursor: for row in cursor: if row[0] not in (None, "", " "): # row[0] checks 'Pin'

Re: The row contains a bad value

2Quiker — Thu, 22 Apr 2021 14:42:51 GMT

Duh, I feel dumb. Got it working with the following with your help, thanks!

dict1 = dict() with arcpy.da.SearchCursor(fc,['Pin','Perm_COUNT','P_Num']) as cursor: for row in cursor: if row[0] not in (None, "", " "): # forgot the [0] dict1.setdefault(row[0],[]).append(str(row[2])) #print (dict1) with arcpy.da.UpdateCursor(fc,['Pin','Perm_COUNT','Permits']) as cursor: for row in cursor: if row[0] in dict1: #added to pass only attributes in dict row[2] = ",".join(dict1[row[0]]) #print (",".join(dict1[row[0]])) cursor.updateRow(row