def osm_nominatim(DataLocation):
# DataLocation = r'C:\Users\Wuga\Documents\DATASETS\SFREHPDATA\HousingSales2012.csv'
geolocator=Nominatim()
df=DO.readfile(DataLocation)
print df
df['Location'][:]=[x[0:x.find('#')] if x.find('#')!=-1 else x for x in df['Location']]
print df
complete=df['Location'][3]+" San Francisco"
print complete
longlat=geolocator.geocode(complete)
print((longlat.latitude,longlat.longitude))
transed=[]
#transed=[geolocator.geocode(x+" San Francisco", timeout=None) for x in df['Location'][:5]]#need to sleep for a sec
for x in df['Location'][:5]:
transed.append(geolocator.geocode(x+" San Francisco", timeout=10))
time.sleep(2)
transed_la=[x.latitude if x is not None else 0 for x in transed]
transed_lo=[x.longitude if x is not None else 0 for x in transed]
cood_price=zip(df['Price'],transed_la,transed_lo)
df_cood_price=pd.DataFrame(data=cood_price, columns=['Price','Latitude','Longitude'])
df_cood_price.to_csv(Constants.filelocations.OSM_NOMINATIM_HOUSEPRICE, header= True, index=False)
print df_cood_price
return
def google_nominatim(DataLocation):
df=DO.readfile(DataLocation)
print df
geolocator=geocoder.google('110 OTTER COVE TERRACE San Francisco')
geolocator.latlng
print geolocator.latlng
transed=[]
for x in df['Location']:
transed.append(geocoder.google(x+" San Francisco", timeout=10).latlng)
time.sleep(2)
print transed
nptransed=np.array(transed)
transed_la = nptransed[:,0]
transed_lo = nptransed[:,1]
cood_price=zip(df['Price'],transed_la,transed_lo)
df_cood_price=pd.DataFrame(data=cood_price, columns=['Price','Latitude','Longitude'])
df_cood_price.to_csv(Constants.filelocations.GOOGLE_NOMINATIM_HOUSEPRICE, header= True, index=False)
return
