how to set empty value to zero

Question

I have a table "address_layer" set in the code. There I am trying to sum the column "Anzahl". The problem is that where the value is Empty (nothing in it) the code breaks.

polygon_layer = arcpy.GetParameterAsText(0)
address_layer = arcpy.GetParameterAsText(1)

selected_oids = []
with arcpy.da.SearchCursor(polygon_layer, "OID@") as cursor:
    for row in  cursor:
        selected_oids.append(row[0])

workspace = arcpy.Describe(polygon_layer).path

anzahl_total = 0
try:
    edit = arcpy.da.Editor(workspace)
    edit.startEditing(False, True)
    for oid in selected_oids:
        arcpy.SelectLayerByAttribute_management(polygon_layer, "NEW_SELECTION", "OBJECTID = {0}".format(oid))
        arcpy.SelectLayerByLocation_management(address_layer, "WITHIN", polygon_layer)
        #address_count_within = int(arcpy.GetCount_management(address_layer).getOutput(0))
        #arcpy.AddMessage('Number of address points within Polygon (OBJECTID={0}): {1}'.format(oid, address_count_within))
        with arcpy.da.SearchCursor(address_layer, "Anzahl") as cursor:
            for row in cursor:
                anzahl_total = anzahl_total + row[0]
        #print anzahl_total
            #edit.startOperation()  
            with arcpy.da.UpdateCursor(polygon_layer, ["anzahl"]) as cursor:
                for row in cursor:
                    row[0] = anzahl_total
                    cursor.updateRow(row)
            #edit.stopOperation()
    edit.stopEditing(True)  


finally:
    pass

How can I set the empty value to "0" so that I can sum this? It breaks at This part

with arcpy.da.SearchCursor(address_layer, "Anzahl") as cursor:
                for row in cursor:
                    anzahl_total = anzahl_total + row[0]

This error comes:

 line 29, in <module>
        anzahl_total = anzahl_total + row[0]
    TypeError: unsupported operand type(s) for +: 'int' and 'NoneType'

See https://stackoverflow.com/questions/394809/does-python-have-a-ternary-conditional-operator. That should help. — Markus, Sep 16 '18 at 20:12
What is in `row` when it gives the error? `print(row)`? also show the complete stack trace for the error. — Stephen Rauch, Sep 16 '18 at 21:13
Updated the error, the problem only comes if there are Empty / nothing in "Anzahl". If all have a value (0,1 or more) no problems — Bjorn ten Broeke, Sep 16 '18 at 21:27

Stephen Rauch · Accepted Answer · 2018-09-16T21:58:40.143

2

To check if row is empty you can test for it like:

with arcpy.da.SearchCursor(address_layer, "Anzahl") as cursor:
    for row in cursor:
        if row[0] is not None:
            anzahl_total += row[0]

You can also use a generator expression with sum() like:

with arcpy.da.SearchCursor(address_layer, "Anzahl") as cursor:
    anzahl_total += sum(row[0] for row in cursor if row[0] is not None)

edited Sep 16 '18 at 21:58

answered Sep 16 '18 at 20:13

Stephen Rauch

47,830
31
106
135

I have tried both, keep giving the error. I have update the complete script. To see what’s in there – Bjorn ten Broeke Sep 16 '18 at 21:12
@BjorntenBroeke, I updated the test to `is not None` – Stephen Rauch Sep 16 '18 at 21:59

how to set empty value to zero

1 Answers1