Report on number of null records for every attribute

371
2
Jump to solution
10-03-2022 04:30 PM
Labels (2)
MichaelJenkins
Occasional Contributor III

I have a FC with 60+ attribute columns.  I want to find out how many (and which) of those columns have never been used - i.e. all rows for that attribute are <null> or empty.  Is there a tool that will do that for the whole FC without me having to input each column name?  

Ideally it would output a report or a table that shows how many records are not populated for each attribute.

GISP
0 Kudos
1 Solution

Accepted Solutions
jcarlson
MVP Esteemed Contributor

If you're comfortable with python, read your feature class into a DataFrame in, then:

pandas.DataFrame(df.isna().sum())

jcarlson_1-1664841339999.png

 

 

- Josh Carlson
Kendall County GIS

View solution in original post

2 Replies
jcarlson
MVP Esteemed Contributor

If you're comfortable with python, read your feature class into a DataFrame in, then:

pandas.DataFrame(df.isna().sum())

jcarlson_1-1664841339999.png

 

 

- Josh Carlson
Kendall County GIS
MichaelJenkins
Occasional Contributor III

Oh my gosh, that is so helpful!    I think that will work for us  Thank you!  

GISP
0 Kudos