2019-02 pandas 05.py

import geocoder
import os
mapbox_token = os.environ['MAPBOX_TOKEN']
assert mapbox_token
from pandas import Series

def georeverse(point):
 return geocoder.mapbox(point, method='reverse',key=mapbox_token)

def get_city_and_postal(point):
 g = georeverse(point)
 return (g.city, g.postal)

def add_geo_point(df):
 res = df.copy()
 for index, row in df.iterrows():
  if(index%10==0):
    print(index,"/", df.shape[0])
  point = row["point"]
  data = get_city_and_postal(point)
  res.loc[index, "ville"] = data[0]
  res.loc[index, "postal"] = data[1]
 return res