Skip to content

Instantly share code, notes, and snippets.

@timtroendle

timtroendle/geolocating-epc.py

Created February 15, 2017 16:34
Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save timtroendle/6f61dc38a0aad58c2261524d7d8594c3 to your computer and use it in GitHub Desktop.
Save timtroendle/6f61dc38a0aad58c2261524d7d8594c3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
geolocating-epc.py
import geopandas as gpd
import pandas as pd
import fiona
fiona.drvsupport.supported_drivers['kml'] = 'rw' # enable KML support which is disabled by default
fiona.drvsupport.supported_drivers['KML'] = 'rw' # enable KML support which is disabled by default
epc_data = pd.read_excel('./data/macromerge3.xlsm', sheetname='DomesticBulkDataAB')
geocodes = gpd.tools.geocode(["{}, {}".format(row.ADDRESS1, row.POSTCODE) for index, row in epc_data[:20].iterrows()],
provider='googlev3')
geocodes.to_file('./build/geocodes.kml, driver='kml')
@fahimalamabir
Copy link

Thanks a ton.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment