Finding Null value form shape file attribute fields using python

Question

I have 100 shape files from different sub folders. I want to check "Population" field in each shape file. If the "Population" field in any of the shape file is ["", " ", None] then print me the name of those particular shape files.

import os  
import fnmatch  
import arcpy  
rootPath = r"C:\Project\layers"   
pattern = 'mig*.shp'   
for root, dirs, files in os.walk(rootPath):   
    for filename in fnmatch.filter(files, pattern):   
        shp = os.path.join(root, filename)  
        if arcpy.ListFields(shp, "Population"):  
            print("{} has Population field".format(shp))   
            with arcpy.da.SearchCursor(shp, ["Population"]) as rows:  
                for row in rows:  
                    if row[0] == ["", " ", None]:  
                        print("{} has a empty value".format(shp))
                    else:
                            print "OK"

the script working fine to find shape files name those are having population field. But its not working to find shape name which are having empty population field.

I am getting "runtime error". TypeError: String indices must be integers, not str.

Please provide the entire error message, as well as a [mcve]. — AMC, Apr 17 '20 at 22:05

score 1 · Accepted Answer · answered Apr 17 '20 at 16:38

I'd rather add it as a comment to your question, but I cannot. First of all, if you want to check if field is empty please change the line:

if row[0] == ["", " ", None]:

to:

if row[0] in ["", " ", None]:

But this is logical error that shouldn't result in runtime error. Please make also sure that indent of print "OK" in last line is correct.

Run the code below and let us know if runtime error is still there. If yes, please provide more information (including line of the error):

import os  
import fnmatch  
import arcpy  
rootPath = r"C:\Project\layers"   
pattern = 'mig*.shp'   
for root, dirs, files in os.walk(rootPath):   
    for filename in fnmatch.filter(files, pattern):   
        shp = os.path.join(root, filename)  
        if arcpy.ListFields(shp, "Population"):  
            print("{} has Population field".format(shp))   
            with arcpy.da.SearchCursor(shp, ["Population"]) as rows:  
                for row in rows:  
                    if row[0] in ["", " ", None]:  
                        print("{} has a empty value".format(shp))
                    else:
                        print "OK"

score -1 · Answer 2 · answered Apr 05 '20 at 07:33

I can’t answer exactly your question, but perhaps this approach will help you:

import arcgisscripting
gp = arcgisscripting.create(9.3)
...
rows = gp.SearchCursor(shp)
row = rows.Next()
while row:
    population = row.GetValue("Population")
    # ... perform check ...
    row = rows.next()

Finding Null value form shape file attribute fields using python

2 Answers2