Pandas catch error using when using 'apply'

Question

I am geocoding a dataset using the column 'Address'. I would like to either add the string 'N/A' to the row 'lat' when an attribute exception is thrown or simply remove that row if the error is thrown.

Here is what I have tried to make the row with the exception say 'N/A':

try:
    addresses['lat'] = addresses['Address'].apply(addLat)
    addresses['long'] = addresses['Address'].apply(addLong)
except AttributeError:
  addresses['lat'] = 'N/A' # this makes every column say N/A

I have also tried:

try:
    addresses['lat'] = addresses['Address'].apply(addLat)
    addresses['long'] = addresses['Address'].apply(addLong)
except AttributeError:
  addresses['lat'] = 'N/A' # this makes every column say N/A
  pass # this makes the lat column not exists

but the result of this is having no lat/long columns at all.

My question is, how can I access the specific index of the exception and either ignore or insert 'N/A' during an exception?

I have confirmed that the geocode function works on multiple individual rows of the dataset & am certain that my geocoding function is not the issue.

Zach Flanders · Accepted Answer · 2022-07-01 20:42:55Z

2

You want to include your exception handling inside of the apply method. This uses a wrapper function exception_handler to handle exceptions for the inner function:

def exception_handler(func, x):
    try:
        return func(x)
    except AttributeError:
        return 'N/A'
    
addresses['lat'] = addresses['Address'].apply(lambda x: exception_handler(addLat, x))
addresses['long'] = addresses['Address'].apply(lambda x: exception_handler(addLong, x))

Alternatively, you could add the try except block to your addLat and addLong functions.

edited Jul 1, 2022 at 20:42

answered Jul 1, 2022 at 20:35

Zach Flanders

1,3141 gold badge7 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas catch error using when using 'apply'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related