[GIS] Searching for NULL values in feature class table

arcmaparcpynullselect-by-attribute

I am looking for a way which I can search whole my feature class in ArcMap to find if has any NULL values on it.
I know how can I do this with "Select By Attribute", but I am looking for a faster way to do this, like with a Python script.

Best Answer

If you're after a raw count of null values in any field:

sum(sum(v is None for v in values) for values in arcpy.da.SearchCursor('some_layer', '*'))

If you want to know specifically which rows/fields contain them:

count_nulls = 0
with arcpy.da.SearchCursor('some_layer', '*') as cursor:
    for i, row in enumerate(cursor):
        null_fields = [name for name, value in
                       zip(cursor.fields, row) if value is None]
        if null_fields:
            print 'found nulls in row {}: {}'.format(
                i + 1, ', '.join(null_fields))
            count_nulls += len(null_fields)

print '{} total null values'.format(count_nulls)
Related Question