Gera kml.ipynb

Kernel: Python 3 (Ubuntu Linux)

# pip3 install simplekml

import simplekml as kml
import pandas as pd

df = pd.read_excel('res5.xlsx', sheet_name='dados')

df[:5]

mapa = kml.Kml()

str(round(df['efetivo'].loc[0],1))

'2.0'

def InsereKML(i):
    aux = str(df['GRUPOS'].loc[i]) + ' (' +str(round(df['efetivo'].loc[i],1)) + ')'
    mapa.newpoint(name=aux, coords=[(df['longitude'].loc[i],df['latitude'].loc[i])])

def InsereKML(i):
    aux = str(df['GRUPOS'].loc[i]) + ' (' +str(round(df['efetivo'].loc[i],1)) + ')'

    pnt = mapa.newpoint(name=aux, coords=[(df['longitude'].loc[i],df['latitude'].loc[i])])

    pnt.style.labelstyle.scale = 0.75

    if str(round(df['efetivo'].loc[i],1)) == '2.0':
       pnt.style.iconstyle.icon.href = 'http://maps.google.com/mapfiles/kml/shapes/police.png'
       pnt.style.labelstyle.color = kml.Color.red
    else:
       pnt.style.iconstyle.icon.href = 'http://maps.google.com/mapfiles/kml/shapes/track.png'

for i in range(len(df.index)):
    InsereKML(i)

mapa.save("Mapa 5.kml")