Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment