I was wondering if I was on the right track with this. I have a table with fields that contain addresses like this: 515 S WEBER RD APT 108 LOCKPORT, IL 60441 I'm interested in finding three types of values if they exist, and I'd like to update the value to a new field called 'UnitType'. Right now, this is printing empty brackets. I'm not too sure why. fc = r 'C:\Users\jpilbeam\Downloads\AddPts_AptUnitSte.gdb\Default.gdb\AddPts_AptUnitSte' field = 'USPS_ADDRE' values = [ 'Apt' , 'Unit' , 'Ste' ] # Use SearchCursor with list comprehension to return a # unique set of values in the specified field v = [ row [ 0 ] for row in arcpy . da . SearchCursor ( fc , field ) ] types = [ i for i in v if i in values ] print ( types ) >> > [ ]

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find Values in Field With List Comprehension

JaredPilbeam2

I was wondering if I was on the right track with this. I have a table with fields that contain addresses like this:

515 S WEBER RD APT 108 LOCKPORT, IL 60441‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I'm interested in finding three types of values if they exist, and I'd like to update the value to a new field called 'UnitType'. Right now, this is printing empty brackets. I'm not too sure why.

fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\jpilbeam\Downloads\AddPts_AptUnitSte.gdb\Default.gdb\AddPts_AptUnitSte'</SPAN>
field <SPAN class="operator token">=</SPAN> <SPAN class="string token">'USPS_ADDRE'</SPAN>
values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Apt'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Unit'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Ste'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Use SearchCursor with list comprehension to return a</SPAN>
<SPAN class="comment token"># unique set of values in the specified field</SPAN>
v <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
types <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> v <SPAN class="keyword token">if</SPAN> i <SPAN class="keyword token">in</SPAN> values<SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>types<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍


<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

RandyBurton

You might try this, and note case sensitivity:

fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\jpilbeam\Downloads\AddPts_AptUnitSte.gdb\Default.gdb\AddPts_AptUnitSte'</SPAN>
field <SPAN class="operator token">=</SPAN> <SPAN class="string token">'USPS_ADDRE'</SPAN>
values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'APT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'UNIT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'STE'</SPAN><SPAN class="punctuation token">]</SPAN>

addresses <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

types <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>v <SPAN class="keyword token">for</SPAN> v <SPAN class="keyword token">in</SPAN> values <SPAN class="keyword token">for</SPAN> address <SPAN class="keyword token">in</SPAN> addresses <SPAN class="keyword token">if</SPAN> v <SPAN class="keyword token">in</SPAN> address<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>types<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I'd like to update the value to a new filed called 'UnitType'.

I'm not sure if list comprehension, at least in this form, will get you closer to your goal. I would use either the field calculator or an update cursor.

fc = r'C:\Users\jpilbeam\Downloads\AddPts_AptUnitSte.gdb\Default.gdb\AddPts_AptUnitSte'
fields = ['USPS_ADDRE','UnitType']
values = ['APT', 'UNIT', 'STE']

with arcpy.da.UpdateCursor(fc, fields) as cursor:
    for row in cursor:
        for v in values:
            if v in row[0].upper():
                row[1] = v
                cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

RandyBurton

The "CHECK" is causing some of the problem. I also noticed on GitHub there is an unanswered question about updating the module for Python 3. I haven't done any testing with that version. However, I have some code that might give you some ideas for the "RepeatedLabelError" and how to deal with it.

<SPAN class="keyword token">import</SPAN> usaddress

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">address_exception</SPAN><SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    d <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Bad address: {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>b<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> a<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            d<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
    <SPAN class="keyword token">for</SPAN> k<SPAN class="punctuation token">,</SPAN> v <SPAN class="keyword token">in</SPAN> d<SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> v <SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"  {} (repeated {} times)"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>k<SPAN class="punctuation token">,</SPAN>v<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

cursor <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN> 
    <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CHECK S ST LOUIS ST  LOT 34 ELWOOD, IL 60421"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"addrNum"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"stNm"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"zip"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"S ST LOUIS ST  LOT 34 ELWOOD, IL 60421"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"addrNum"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"stNm"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"zip"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"5318 S 86 CT APT 3 APT 412, OMAHA, NE 68137"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"addrNum"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"stNm"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"zip"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"2765 HAZEL ST, OMAHA, NE 68105"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"addrNum"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"stNm"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"zip"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> addr<SPAN class="punctuation token">,</SPAN> addrNum<SPAN class="punctuation token">,</SPAN> stNm<SPAN class="punctuation token">,</SPAN> zip<SPAN class="punctuation token">,</SPAN> oid <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># simulate an UpdateCursor</SPAN>
    <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
        parse <SPAN class="operator token">=</SPAN> usaddress<SPAN class="punctuation token">.</SPAN>tag<SPAN class="punctuation token">(</SPAN>addr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
        addrNum <SPAN class="operator token">=</SPAN> parse<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"AddressNumber"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
        stNm <SPAN class="operator token">=</SPAN> parse<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"StreetName"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
        zip <SPAN class="operator token">=</SPAN> parse<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"ZipCode"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ok'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>addr<SPAN class="punctuation token">,</SPAN> addrNum<SPAN class="punctuation token">,</SPAN> stNm<SPAN class="punctuation token">,</SPAN> zip<SPAN class="punctuation token">,</SPAN> oid<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

    <SPAN class="keyword token">except</SPAN> usaddress<SPAN class="punctuation token">.</SPAN>RepeatedLabelError <SPAN class="keyword token">as</SPAN> e <SPAN class="punctuation token">:</SPAN>        
        address_exception<SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">.</SPAN>parsed_string<SPAN class="punctuation token">,</SPAN> e<SPAN class="punctuation token">.</SPAN>original_string<SPAN class="punctuation token">)</SPAN>

    <SPAN class="keyword token">except</SPAN> Exception <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
        <SPAN class="comment token"># print('ERROR: {}'.format(type(e))) # may provide some additional info</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Unknown Error: oid={}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>oid<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ERROR'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>addr<SPAN class="punctuation token">,</SPAN> addrNum<SPAN class="punctuation token">,</SPAN> stNm<SPAN class="punctuation token">,</SPAN> zip<SPAN class="punctuation token">,</SPAN> oid<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="string token">''' output:
Bad address: CHECK S ST LOUIS ST  LOT 34 ELWOOD, IL 60421
[(u'CHECK', 'StreetName'), (u'S', 'StreetNamePostDirectional'), (u'ST', 'PlaceName'), (u'LOUIS', 'StreetName'), (u'ST', 'StreetNamePostType'), (u'LOT', 'OccupancyType'), (u'34', 'OccupancyIdentifier'), (u'ELWOOD,', 'PlaceName'), (u'IL', 'StateName'), (u'60421', 'ZipCode')]
  PlaceName (repeated 2 times)
  StreetName (repeated 2 times)
('ok', ['S ST LOUIS ST  LOT 34 ELWOOD, IL 60421', '', u'ST LOUIS', u'60421', 2])
Bad address: 5318 S 86 CT APT 3 APT 412, OMAHA, NE 68137
[(u'5318', 'AddressNumber'), (u'S', 'StreetNamePreDirectional'), (u'86', 'StreetName'), (u'CT', 'StreetNamePostType'), (u'APT', 'OccupancyType'), (u'3', 'OccupancyIdentifier'), (u'APT', 'OccupancyType'), (u'412,', 'OccupancyIdentifier'), (u'OMAHA,', 'PlaceName'), (u'NE', 'StateName'), (u'68137', 'ZipCode')]
  OccupancyIdentifier (repeated 2 times)
  OccupancyType (repeated 2 times)
('ok', ['2765 HAZEL ST, OMAHA, NE 68105', u'2765', u'HAZEL', u'68105', 4])
'''</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I have also used the regular expressions module along with dictionaries to do some pre-cleanup before passing the address to the usaddress module. These are mostly things like substituting 'STE' for 'Suite' or 'N' for 'North'. This basically helps standardize the address to USPS guidelines.

The usaddress module isn't perfect, but it can be very helpful.

JaredPilbeam2

Randy Burton‌

I was trying out the usaddress module. It seems ideal. But, it threw an error that I reported to the author on GitHub. UPDATE: I think the "CHECK" in the string is a note by the editor put in to remind him/her to come back to this particular address for whatever reason.

usaddress.RepeatedLabelError: Unable to tag this string because more than one area of the string has the same label

ORIGINAL STRING:  CHECK S ST LOUIS ST  LOT 34 ELWOOD, IL 60421
PARSED TOKENS:    [('CHECK', 'StreetName'), ('S', 'StreetNamePostDirectional'), ('ST', 'PlaceName'), ('LOUIS', 'StreetName'), ('ST', 'StreetNamePostType'), ('LOT', 'OccupancyType'), ('34', 'OccupancyIdentifier'), ('ELWOOD,', 'PlaceName'), ('IL', 'StateName'), ('60421', 'ZipCode')]
UNCERTAIN LABEL:  StreetName‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I put this in a try/except block before I realized you can't continue the code once the try block is interrupted. I'm wondering if you've ever ran into this?

RandyBurton

Try using split:

fc = 'feature'
fields = ['USPS_ADDRE','Unit']
values = ['APT', 'UNIT', 'STE']

with arcpy.da.UpdateCursor(fc, fields) as cursor:
    for row in cursor:
        for v in values:
            if v in row[0].upper():
                # row[1] = v
                row[1] = "{} {}".format(v,row[0].split(v)[1].split(' ')[1])
                cursor.updateRow(row)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

If you are doing some serious address parsing, look into the usaddress module.

import usaddress

adr = usaddress.parse("515 S WEBER RD APT 108 LOCKPORT, IL 60441")

print(adr)

# [(u'515', 'AddressNumber'), (u'S', 'StreetNamePreDirectional'), (u'WEBER', 'StreetName'), (u'RD', 'StreetNamePostType'), (u'APT', 'OccupancyType'), (u'108', 'OccupancyIdentifier'), (u'LOCKPORT,', 'PlaceName'), (u'IL', 'StateName'), (u'60441', 'ZipCode')]

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JaredPilbeam2

Thanks to both of you. I thought I'd try list comprehension on this, but I guess I don't grasp it enough. So, I used Randy's second answer. It worked great.

Bonus question: Now I have to get the number that follows the value and put it in a new field called 'UnitName'. So, for example the 108 in this field:

515 S WEBER RD APT 108 LOCKPORT, IL 60441<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

RandyBurton

You might try this, and note case sensitivity:

fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\jpilbeam\Downloads\AddPts_AptUnitSte.gdb\Default.gdb\AddPts_AptUnitSte'</SPAN>
field <SPAN class="operator token">=</SPAN> <SPAN class="string token">'USPS_ADDRE'</SPAN>
values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'APT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'UNIT'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'STE'</SPAN><SPAN class="punctuation token">]</SPAN>

addresses <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

types <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>v <SPAN class="keyword token">for</SPAN> v <SPAN class="keyword token">in</SPAN> values <SPAN class="keyword token">for</SPAN> address <SPAN class="keyword token">in</SPAN> addresses <SPAN class="keyword token">if</SPAN> v <SPAN class="keyword token">in</SPAN> address<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>types<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I'd like to update the value to a new filed called 'UnitType'.

I'm not sure if list comprehension, at least in this form, will get you closer to your goal. I would use either the field calculator or an update cursor.

fc = r'C:\Users\jpilbeam\Downloads\AddPts_AptUnitSte.gdb\Default.gdb\AddPts_AptUnitSte'
fields = ['USPS_ADDRE','UnitType']
values = ['APT', 'UNIT', 'STE']

with arcpy.da.UpdateCursor(fc, fields) as cursor:
    for row in cursor:
        for v in values:
            if v in row[0].upper():
                row[1] = v
                cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

danretired

You need to reset your cursor after running it, otherwise you get [].

Using a two step/while look is safest

check_for <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc2<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PNT_COUNT"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
    v <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">]</SPAN>
    is_in <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> v <SPAN class="keyword token">if</SPAN> i <SPAN class="keyword token">in</SPAN> check_for<SPAN class="punctuation token">]</SPAN>
    

is_in
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">16</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">8.0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">5.0</SPAN><SPAN class="punctuation token">]</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

<SPAN class="comment token"># ---- same as but more obtuse</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc2<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PNT_COUNT"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
    v <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> cur <SPAN class="keyword token">if</SPAN> r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">in</SPAN> check_for<SPAN class="punctuation token">]</SPAN>

v
<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8.0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">5.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.