Quickly reverse geocode coordinates in a spreadsheet

reverseGeocodeXLScoords.py

import geocoder
import pandas as pd

xls = r'C:\Some\Arb\Folder\coords.xls'
out_xls = r'C:\Some\Arb\Folder\geocoded.xls'
df = pd.read_excel(xls)

for index, row in df.iterrows():
    g = geocoder.google([row[3], row[2]], method='reverse')
    df.set_value(index, 'Street Address', g.address)

df.to_excel(out_xls, 'Geocoded')