Output Count of NULL values for Each Field

HaydenHarrison1

Hello, 

For every field within every feature class in my dataset, I would like to produce a list with the following data:

1. Field Name

2. Field Data Type

3. Field Length

4. Field Domain

5. Count of NULL values in field

I have a script that produces 1-4 but can't seem to figure out how to produce number 5. 

My current script:

arcpy.env.workspace = r"C:\gdblocation"

fcList = arcpy.ListFeatureClasses("*")

for fc in fcList:
print(fc)
fields = arcpy.ListFields(fc)

for field in fields:
print("{0},{1},{2}"
.format(field.name, field.type, field.length, field.domain))

Example of current output for each field in each feature class:

• NAME, DATA TYPE, LENGTH, DOMAIN 

What I'm trying to produce:

• NAME, DATA TYPE, LENGTH, DOMAIN, # of NULL VALUES

Any advice?

Thanks!

CurrentPythonOutput.png

abureaux_1-1721859120651.png

JohannesLindner

arcpy.env.workspace = r"C:\gdblocation"

fcList = arcpy.ListFeatureClasses("*")

for fc in fcList:
    print(fc)
    fields = arcpy.ListFields(fc)

    field_names = [f.name for f in fields]
    null_counts = {fn: 0 for fn in field_names}
    with arcpy.da.SearchCursor(fc, field_names) as cursor:
        for row in cursor:
            for i, v in enumerate(row):
                if v is None:
                    null_counts[field_names[i]] += 1

    for field in fields:
        print("{0},{1},{2},{3}".format(field.name, field.type, field.length, field.domain, null_counts[field.name]))