topic Populate empty/black rows from an existing field in Python Questions

Populate empty/black rows from an existing field

CCWeedcontrol — Wed, 05 Jan 2022 20:09:01 GMT

I have the following but It's only works to populate for Field1, I would like to populate Field1 blanks or Nulls with Field2 attributes and Field2 blanks or nulls with Field1. I have the the following but it only works to populate Field1..

Maybe I am going about this the wrong way?

flds = ['FID', 'Field1','Field2'] # FID shapefile, OID geodatabase search_feats = {f[0]:(f[1:]) for f in arcpy.da.SearchCursor(fc1,flds)} with arcpy.da.UpdateCursor(fc1,flds) as upd_cur: for upd_row in upd_cur: if upd_row[0] in search_feats.keys(): if upd_row[1] == None: upd_row[1] = search_feats[upd_row[0]][1] upd_cur.updateRow(upd_row) else: pass del upd_cur

Re: Populate empty/black rows from an existing field

GKmieliauskas — Thu, 06 Jan 2022 06:36:36 GMT

Hi,

Try this code:

with arcpy.da.UpdateCursor(fc1,flds) as upd_cur: for upd_row in upd_cur: updated = False if upd_row[1] == None: upd_row[1] = upd_row[0] updated = True if upd_row[0] == None: upd_row[0] = upd_row[1] updated = True if updated == True: upd_cur.updateRow(upd_row)

To speed up process you can add whereclause parameter to your UpdateCursor to check is one of fields is None or empty

Re: Populate empty/black rows from an existing field

CCWeedcontrol — Thu, 06 Jan 2022 20:30:51 GMT

Thank you I appreciate the replay. I do have something similar with a arcpy.da.UpdateCurosr. I was trying to see how it would be done with a dictionary key.

I was think of adding another "if" but I am not 100% sure if I am understand the dictionary keys right.

with arcpy.da.UpdateCursor(fc1,flds) as upd_cur: for upd_row in upd_cur: if upd_row[0] in search_feats.keys(): if upd_row[1] == None: upd_row[1] = search_feats[upd_row[0]][1] if upd_row[2] == None: upd_row[2] = search_feats[upd_row[0]][0] upd_cur.updateRow(upd_row)

Re: Populate empty/black rows from an existing field

CCWeedcontrol — Thu, 06 Jan 2022 20:39:07 GMT

my indentation on line 8 was incorrect.

with arcpy.da.UpdateCursor(fc, flds) as upd_cur: for upd_row in upd_cur: if upd_row[0] in search_feats.keys(): if upd_row[1] in ("", ' ', None): upd_row[1] = search_feats[upd_row[0]][1] if upd_row[2] in ("", ' ', None): upd_row[2] = search_feats[upd_row[0]][0] upd_cur.updateRow(upd_row)