import os, csv, sys, geopy
import pandas
from geopy.geocoders import Nominatim, GoogleV3
# geopy 1.10.0, pandas 0.16.2
def main():
io = pandas.read_csv('onerow3.csv', index_col=False, header=0, sep=",")
name = io['Area_Name']
geolocator = Nominatim()
# geolocator = GoogleV3()
io['latitude'] = io['Area_Name'].apply(geolocator.geocode).apply(lambda x: (x.latitude))
io['longitude'] = io['Area_Name'].apply(geolocator.geocode).apply(lambda x: (x.longitude))
io.to_csv('geocoding-output.csv')
if __name__ == '__main__':
main()
def main():
if __name__ == '__main__':
main()
import os, csv, sys, geopy
import pandas
from geopy.geocoders import Nominatim, GoogleV3
io = pandas.read_csv('onerow3.csv', index_col=False, header=0, sep=",")
geolocator = Nominatim()
# geolocator = GoogleV3()
io['latitude'] = io['Area_Name'].apply(geolocator.geocode).apply(lambda x: (x.latitude))
io['longitude'] = io['Area_Name'].apply(geolocator.geocode).apply(lambda x: (x.longitude))
io.to_csv('geocoding-output.csv')
io['helper'] = io['Area_Name'].map(str) + " " + io['Country']
io['latitude'] = io['helper'].apply(geolocator.geocode).apply(lambda x: (x.latitude))
io['longitude'] = io['helper'].apply(geolocator.geocode).apply(lambda x: (x.longitude))
[0.0,-10.0], 2