topic Re: Skip over or exclude empty variable in field calculator expression in Python Questions

Skip over or exclude empty variable in field calculator expression

ARCADMIN — Mon, 07 May 2018 18:36:07 GMT

Hello, I am trying to parse street addresses using the field calculator and return just the street name. My expression works except for addresses where there is only a house number with no street name after it; the calculation throws an error when it gets to these bad records where the street name doesn't exist. I would like to be able to skip over these bad addresses and just return the input string for them. I have tried adding a second condition to my if statement, but cannot seem to get the syntax correct. Essentially what I want to say is "if the house number is a digit and the street name is not blank, return the street name otherwise return the full input string"

def addressParser(inString):
    splitString = inString.split(' ',1)
    houseNumber = splitString[0]
    streetName = splitString[1]
    if houseNumber.isdigit() and if streetName != "":
        return streetName
    else:
        return inString

addressParser( !FULLADDRESS! )

Thanks in advance for any help

Re: Skip over or exclude empty variable in field calculator expression

XanderBakker — Fri, 10 Dec 2021 22:08:07 GMT

You could change your function to and check if length of the list is 1:

def addressParser(inString):
    splitString = inString.split(' ',1)
    if len(splitString) == 1:
        return inString
    else:
        houseNumber = splitString[0]
        streetName = splitString[1]
        if houseNumber.isdigit() and streetName != "":
            return streetName
        else:
            return inString‍‍‍‍‍‍‍‍‍‍‍

However, you might run into other "exceptions". Does your field only contain number and street?

Re: Skip over or exclude empty variable in field calculator expression

JoeBorgione — Fri, 10 Dec 2021 22:08:10 GMT

def addressParser(inString):
    splitString = inString.split(' ',1)
    houseNumber = splitString[0]
    streetName = splitString[1]
    if houseNumber.isdigit() and if streetName != "":
        return streetName
    else:
        return inString‍‍‍‍‍‍‍‍

If I'm reading this right, in line 2 you are giving it a 'maxsplit' value of 1, but I'm not sure why: I guess just to separate house number and the rest of the street? Take a look at an older post of mine: A better way to parse an address? it has worked for me for tons of address parsing.

In your case, you might check the len() of splitString so if it's longer than 1, you have a street with your house number:

instring = 1234 S MMAIN ST'
splitstring = instring.split(' ',1)
print splitstring
>>>['1234', 'S MAIN ST']
len(splitstring)
>>> 2

if len(splitstring) > 1:
   do what you need to do with a good address
elif len(splitstring)== 1:
    do what you need to do with just a house number‍‍‍‍‍‍‍‍‍‍‍

Re: Skip over or exclude empty variable in field calculator expression

ARCADMIN — Mon, 07 May 2018 19:26:13 GMT

Thank you very much, that works! Yes my addresses only contain house number and street name + type

Re: Skip over or exclude empty variable in field calculator expression

ARCADMIN — Mon, 07 May 2018 19:28:27 GMT

Thank you very much that works! Yes I only need to parse the house number and the rest of the street name not each individual component of the street name.

Re: Skip over or exclude empty variable in field calculator expression

JoshuaBixby — Mon, 07 May 2018 19:33:25 GMT

I highly encourage you to read through the thread referenced by Joe Borgione‌ (https://community.esri.com/thread/163731 ) . If you are going to be working with addresses a lot, I recommend you look into one of the several Python address parsing packages. No need to reinvent a perfectly good wheel.

Re: Skip over or exclude empty variable in field calculator expression

ARCADMIN — Mon, 07 May 2018 19:47:00 GMT

Thank you I will...for this particular project I just need house number and street name including prefix, name, type and suffix. Most address parsers I've seen are designed to split all those street name elements out which is usually what you would want but not in this particular case...

Re: Skip over or exclude empty variable in field calculator expression

JoeBorgione — Mon, 07 May 2018 20:10:02 GMT

Joshua- how does one go about installing usaddress? I'm out in left field with the whole pip thing....

Joshua Bixby‌

Re: Skip over or exclude empty variable in field calculator expression

JoshuaBixby — Mon, 07 May 2018 20:25:30 GMT

Assuming you have permissions to modify/update the Python environment folders, it is as straightforward as:

C:\>Python27\ArcGIS10.6\Scripts\pip.exe install usaddress‍

Re: Skip over or exclude empty variable in field calculator expression

JoeBorgione — Mon, 07 May 2018 20:32:24 GMT

That's cool.... Really cool.....

Re: Skip over or exclude empty variable in field calculator expression

DanPatterson_Retired — Mon, 07 May 2018 20:35:17 GMT

Joe... FIF ...(For the Future) You can pip install in the anaconda distribution for work in PRO if it supports python 3.6....