optimize-holiday-load-kml.py

places = []

with open(kml_filename, "r") as file:
    content = file.readlines()
    content = "".join(content)
    bs_content = BeautifulSoup(content, "xml")

    placemarks = bs_content.findAll('Placemark')
    for placemark in placemarks:

        coordinates = placemark.find('coordinates').text.strip()
        long = coordinates.split(',')[0]
        lat = coordinates.split(',')[1]

        places.append({
            'name': placemark.find('name').text.strip(),
            'lat': lat,
            'long': long
        })

places = pd.DataFrame(places)
places['lat'] = places['lat'].astype(float)
places['long'] = places['long'].astype(float)

mean_lat = places['lat'].mean()
mean_long = places['long'].mean()

places