How do I get zipcodes from longitude and latitude on python?

Question

I have a data frame of latitude and longitude coordinates on this CSV file:Longlat.

I used this code to try to get the zipcodes:

import copy

def get_zipcode(df, geolocator, lat_field, lon_field):
    location = geolocator.reverse((df[lat_field], df[lon_field]))
    return location.raw['address']['postcode']


geolocator = geopy.Nominatim(user_agent='myusername') #My OpenMap username

zipcodes = longlat.apply(get_zipcode, axis=1, geolocator=geolocator, lat_field=longlat['LATITUDE_X'], lon_field=longlat['LONGITUDE_X'])

I got the error:

KeyError
"None of [Float64Index([39.0962320000896, 39.1462010000896, 39.1347670000896,\n 39.1076250000897, 39.0928490000897, 39.1648900000896,\n 39.1846440000895, 39.0970790000897, 39.1491220000896,\n 39.1145560000896,\n ...\n 39.1039560000896,

How do I fix it?

Answer 1

You are passing in the latitude and longitude Series instead of the latitude and longitude column names.

import geopy
import pandas as pd

def get_zipcode(df, geolocator, lat_field, lon_field):
    try:
        location = geolocator.reverse((df[lat_field], df[lon_field]))
        return location.raw['address']['postcode']
    except (AttributeError, KeyError, ValueError):
        print(repr(e), df[lat_field], df[lon_field])
        return None



longlat = pd.read_csv('longlat.csv', sep='\t')
geolocator = geopy.Nominatim(user_agent='myusername') #My OpenMap username

# Change this
# zipcodes = longlat.apply(
#     get_zipcode, axis=1,geolocator=geolocator, 
#     lat_field=longlat['LATITUDE_X'], lon_field=longlat['LONGITUDE_X'])

# To this
zipcodes = longlat.apply(
    get_zipcode, axis=1, geolocator=geolocator, 
    lat_field='LATITUDE_X', lon_field='LONGITUDE_X')


print(zipcodes)

Output:

0    45233-4555
1    45212-2609
2    45229-3018
3         45202
4         45230
...
dtype: object