I have the following and i get 'NoneType' object has no attribute 'strip' on line 10. There are some records that have NULL or Blanks in the ACCOUNT field. How do i bypass or skill the ones that are null or blank? try: #build a dictionary of ACCOUNT : Address pairs addDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(fc1,['ACCOUNT','SiteAddress'])} #search through fc2 to see if addresses match based on ACCOUNT value with arcpy.da.UpdateCursor(fc2, ['Account','SiteAddres','Verifi2']) as cursor: for row in cursor: if row[1] != None: if row[0] in addDict: if row[1].strip().lower()!= addDict[row[0]].strip().lower(): #if the value associated with those ids do not match row[2] = 'No' else: row[2] = 'Match' cursor.updateRow(row) del cursor

Sorry to bring this back up but i am still having issues. also the issue with if fc1 doesn't have anything in the "ACCOUNT" field how do you just keep the update cursor going on to the next one? try: #build a dictionary of ACCOUNT : Address pairs addDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(fc1,['ACCOUNT','SiteAddress'])} #search through fc2 to see if addresses match based on ACCOUNT value with arcpy.da.UpdateCursor(fc2, ['Account','SiteAddres','Verifi2']) as cursor: for row in cursor: if row[1] != None: if row[0] in addDict: if row[0] != None: if row[1].strip().lower()!= addDict[row[0]].strip().lower(): #if the value associated with those ids do not match row[2] = 'No' else: row[2] = 'Match' cursor.updateRow(row) del cursor

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bypass Nulls or blanks

CCWeedcontrol

I have the following and i get 'NoneType' object has no attribute 'strip' on line 10. There are some records that have NULL or Blanks in the ACCOUNT field. How do i bypass or skill the ones that are null or blank?

try:
&nbsp;&nbsp;&nbsp; #build a dictionary of ACCOUNT : Address pairs
&nbsp;&nbsp;&nbsp; addDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(fc1,['ACCOUNT','SiteAddress'])}

&nbsp;&nbsp;&nbsp; #search through fc2 to see if addresses match based on ACCOUNT value
&nbsp;&nbsp;&nbsp; with arcpy.da.UpdateCursor(fc2, ['Account','SiteAddres','Verifi2']) as cursor:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for row in cursor:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if row[1] != None:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if row[0] in addDict:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if row[1].strip().lower()!= addDict[row[0]].strip().lower(): #if the value associated with those ids do not match
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[2] = 'No'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[2] = 'Match'
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor.updateRow(row)
&nbsp;&nbsp;&nbsp; del cursor<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Najděte více příspěvků označených jako

Accepted answers

All comments

DanPatterson_Retired

if row[whatever] != None:

change to,

if row[whatever] is not None:

generally safer.

Now if line 3 doesn't have anything? you want to continue on to where?

because on line 9 checks to see if fc2 has 'Account' in the previously created dictionary... if it doesn't, it just goes on to the next row, which is what is coded, hence there is no update.

Perhaps you can throw in some print statements to illustrate what is being printed at each stage and where you want it to go.

Also, try-except blocks are pretty useless you have some code to handle the 'fail' conditions. What is beyond line 16?

CCWeedcontrol

Sorry to bring this back up but i am still having issues.

also the issue with if fc1 doesn't have anything in the "ACCOUNT" field how do you just keep the update cursor going on to the next one?

try:
&nbsp;&nbsp;&nbsp; #build a dictionary of ACCOUNT : Address pairs
&nbsp;&nbsp;&nbsp; addDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(fc1,['ACCOUNT','SiteAddress'])}

&nbsp;&nbsp;&nbsp; #search through fc2 to see if addresses match based on ACCOUNT value
&nbsp;&nbsp;&nbsp; with arcpy.da.UpdateCursor(fc2, ['Account','SiteAddres','Verifi2']) as cursor:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for row in cursor:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if row[1] != None:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if row[0] in addDict:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if row[0] != None:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if row[1].strip().lower()!= addDict[row[0]].strip().lower(): #if the value associated with those ids do not match
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[2] = 'No'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[2] = 'Match'
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor.updateRow(row)
&nbsp;&nbsp;&nbsp; del cursor<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

CCWeedcontrol

What if fc1 has blanks? i guess i didn't think about that till now.

CCWeedcontrol

I would like to just bypass them and continue to check for matches.

DanPatterson_Retired

NONE.... not again

another option in case you have multiple conditions.

<SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'None'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NoneType'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">" "</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'nOnE'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># carry on because there is no None-nonsense</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoeBorgione

When is a blank a blank?

'' or ' ' or ' ' or ' '

For those of you old enough to have listened to real vinyl, my blank and <null> rants must sound like a broken record.

Image result for broken record gif

JoshuaBixby

Stylistically, my_var is None is more Pythonic than my_var == None. Style aside, you are making sure that row[1] is not None, but you haven't done the same with row[0]. Instead of suggesting you just add another conditional check, what do you want to do when either Account, SiteAddres, or both are NULL in the table?

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Přihlásit se
Registrovat

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.