import pandas as pd
import numpy as np

pd.set_option('display.max_columns', None)

# Let's load the cardiologist file again
given_cardiologists = pd.read_csv("data/given_cardiologists_plus_agg_util.csv")

from pygeocoder import Geocoder

# get coordinates for each of our 8 cardiologists 
coords = []
for i, provider in given_cardiologists.iterrows():
    geo = Geocoder.geocode("{0}, {1} {2}".format(provider['Line 1 Street Address'], provider['City'], provider['State']))
    coords.append(geo.coordinates)
    
# store those cardiologists in the dataframe
given_cardiologists['coords'] = coords

# given_cardiologists

## initialize map with the help of folium
import folium
map = folium.Map(location=[34.0522, -118.2437], zoom_start=8, tiles='OpenStreetMap')

# add markers to map
for i, provider in given_cardiologists.iterrows():
    map.circle_marker(location=list(provider['coords']), popup=provider.to_frame().to_html(), radius=10000, line_color='#3186cc', fill_color='#3186cc')

map