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.
Solved! Go to Solution.
If you're comfortable with python, read your feature class into a DataFrame in, then:
pandas.DataFrame(df.isna().sum())
If you're comfortable with python, read your feature class into a DataFrame in, then:
pandas.DataFrame(df.isna().sum())
Oh my gosh, that is so helpful! I think that will work for us Thank you!