Find the percentage of null values in each field with name of field

Question

Dear All,

I have a more then 100 feature classes in 12 feature datasets I want to create a table for each feature class which have the following information in ArcGIS pro

1.Name of field.

2.Percentage of null records or having no records.

if there is nay python code that can help me

Thanks and regards

HanushrieG_ess · Answer

Hi, @Bmohammad I've worked on this using Python, and it seems to work for me on my end. Do give it a try and let me know.

GeoNet_Missing_Values.txt

Bmohammad · Answer

Dear Joshua

I didnt have code so for I wan to use Python directly but if we can do in model builder I can go with this also

Thanks and regards

Bmohammad · Answer

Thanks David,

These are in enterprise geodatabase,

I want every feature class with a list of all field in it  along with %null records for those fields

e.g Road feature class I want to list all fields with %null records in each field.

Thanks and regards