import numpy as np
import pandas as pd
import requests

url= 'https://raw.githubusercontent.com/chrisc617/Data-Bootcamp-Final-
Project/master/DOITT_SUBWAY_STATION_01_13SEPT2010.csv'
sales= pd.read_csv(url)
train = sales.drop(['URL','OBJECTID'],axis=1)
from geopy.geocoders import Nominatim
geolocator = Nominatim()
train= train.head()
train

def reverse_geocode(latlng):
result = {}
url = 'https://maps.googleapis.com/maps/api/geocode/json?latlng={}'
request = url.format(latlng)
data = requests.get(request).json()
if len(data['results']) > 0:
    result = data['results'][0]
return result

train['latitude'] = train['the_geom'].apply(lambda x: pd.Series(x.split('
')))[1]
train['longitude'] = train['the_geom'].apply(lambda x: pd.Series(x.split('
')))[2]
train['latitude']=train['latitude'].apply(lambda x: pd.Series(x.split('(')))
[1]
train['longitude']=train['longitude'].apply(lambda x:
pd.Series(x.split(')')))[0]
train.drop(['the_geom'],axis=1)
train['latitude'] = train['latitude'].apply(lambda x: pd.Series(str(x)))
train['longitude'] = train['longitude'].apply(lambda x: pd.Series(str(x)))
train=train.head()
train

train['latlng'] = train.apply(lambda row: '{},{}'.format(row['latitude'],
row['longitude']), axis=1)
train['geocode_data'] = train['latlng'].map(reverse_geocode)
train['Zip'] =train['latlng'].apply(geolocator.reverse)
train['Zip'].apply(lambda x: pd.Series(x.split(',')))
foo = lambda x: pd.Series([i for i in reversed(x.split(','))])
train['Zip']=train['Zip'].apply(lambda x: str(x))
train['Zip']=train['Zip'].apply(foo)[1]

train