partie_1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# PARTIE 1 : Données météorologiques"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Import librairies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import numpy as np \n",
    "import json"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Liste des villes\n",
    "\n",
    "Nous travaillons avec les 35 meilleures villes françaises à visiter."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "cities = [\n",
    "    \"Mont Saint Michel\",\n",
    "    \"St Malo\",\n",
    "    \"Bayeux\",\n",
    "    \"Le Havre\",\n",
    "    \"Rouen\",\n",
    "    \"Paris\",\n",
    "    \"Amiens\",\n",
    "    \"Lille\",\n",
    "    \"Strasbourg\",\n",
    "    \"Chateau du Haut Koenigsbourg\",\n",
    "    \"Colmar\",\n",
    "    \"Eguisheim\",\n",
    "    \"Besancon\",\n",
    "    \"Dijon\",\n",
    "    \"Annecy\",\n",
    "    \"Grenoble\",\n",
    "    \"Lyon\",\n",
    "    \"Gorges du Verdon\",\n",
    "    \"Bormes les Mimosas\",\n",
    "    \"Cassis\",\n",
    "    \"Marseille\",\n",
    "    \"Aix en Provence\",\n",
    "    \"Avignon\",\n",
    "    \"Uzes\",\n",
    "    \"Nimes\",\n",
    "    \"Aigues Mortes\",\n",
    "    \"Saintes Maries de la mer\",\n",
    "    \"Collioure\",\n",
    "    \"Carcassonne\",\n",
    "    \"Ariege\",\n",
    "    \"Toulouse\",\n",
    "    \"Montauban\",\n",
    "    \"Biarritz\",\n",
    "    \"Bayonne\",\n",
    "    \"La Rochelle\"\n",
    "]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## API Nominatim\n",
    "\n",
    "Nous utilisons l'API Nominatim pour récuperer les données GPS (latitude et longitude) des 35 villes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "b'[{\"place_id\":115350921,\"licence\":\"Data \\xc2\\xa9 OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright\",\"osm_type\":\"relation\",\"osm_id\":7444,\"lat\":\"48.8588897\",\"lon\":\"2.3200410217200766\",\"class\":\"boundary\",\"type\":\"administrative\",\"place_rank\":15,\"importance\":0.8317101715588673,\"addresstype\":\"suburb\",\"name\":\"Paris\",\"display_name\":\"Paris, \\xc3\\x8ele-de-France, France m\\xc3\\xa9tropolitaine, France\",\"boundingbox\":[\"48.8155755\",\"48.9021560\",\"2.2241220\",\"2.4697602\"]},{\"place_id\":114827617,\"licence\":\"Data \\xc2\\xa9 OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright\",\"osm_type\":\"relation\",\"osm_id\":71525,\"lat\":\"48.8534951\",\"lon\":\"2.3483915\",\"class\":\"boundary\",\"type\":\"administrative\",\"place_rank\":12,\"importance\":0.8317101715588673,\"addresstype\":\"city\",\"name\":\"Paris\",\"display_name\":\"Paris, \\xc3\\x8ele-de-France, France m\\xc3\\xa9tropolitaine, France\",\"boundingbox\":[\"48.8155755\",\"48.9021560\",\"2.2241220\",\"2.4697602\"]},{\"place_id\":114994164,\"licence\":\"Data \\xc2\\xa9 OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright\",\"osm_type\":\"relation\",\"osm_id\":1641193,\"lat\":\"48.8588897\",\"lon\":\"2.3200410217200766\",\"class\":\"boundary\",\"type\":\"administrative\",\"place_rank\":14,\"importance\":0.4283953917728152,\"addresstype\":\"city_district\",\"name\":\"Paris\",\"display_name\":\"Paris, \\xc3\\x8ele-de-France, France m\\xc3\\xa9tropolitaine, France\",\"boundingbox\":[\"48.8155755\",\"48.9021560\",\"2.2241220\",\"2.4697602\"]}]'"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r = requests.get('https://nominatim.openstreetmap.org/search?city=Paris&country=France&format=json')\n",
    "r.content"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'place_id': 115350921,\n",
       "  'licence': 'Data © OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright',\n",
       "  'osm_type': 'relation',\n",
       "  'osm_id': 7444,\n",
       "  'lat': '48.8588897',\n",
       "  'lon': '2.3200410217200766',\n",
       "  'class': 'boundary',\n",
       "  'type': 'administrative',\n",
       "  'place_rank': 15,\n",
       "  'importance': 0.8317101715588673,\n",
       "  'addresstype': 'suburb',\n",
       "  'name': 'Paris',\n",
       "  'display_name': 'Paris, Île-de-France, France métropolitaine, France',\n",
       "  'boundingbox': ['48.8155755', '48.9021560', '2.2241220', '2.4697602']},\n",
       " {'place_id': 114827617,\n",
       "  'licence': 'Data © OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright',\n",
       "  'osm_type': 'relation',\n",
       "  'osm_id': 71525,\n",
       "  'lat': '48.8534951',\n",
       "  'lon': '2.3483915',\n",
       "  'class': 'boundary',\n",
       "  'type': 'administrative',\n",
       "  'place_rank': 12,\n",
       "  'importance': 0.8317101715588673,\n",
       "  'addresstype': 'city',\n",
       "  'name': 'Paris',\n",
       "  'display_name': 'Paris, Île-de-France, France métropolitaine, France',\n",
       "  'boundingbox': ['48.8155755', '48.9021560', '2.2241220', '2.4697602']},\n",
       " {'place_id': 114994164,\n",
       "  'licence': 'Data © OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright',\n",
       "  'osm_type': 'relation',\n",
       "  'osm_id': 1641193,\n",
       "  'lat': '48.8588897',\n",
       "  'lon': '2.3200410217200766',\n",
       "  'class': 'boundary',\n",
       "  'type': 'administrative',\n",
       "  'place_rank': 14,\n",
       "  'importance': 0.4283953917728152,\n",
       "  'addresstype': 'city_district',\n",
       "  'name': 'Paris',\n",
       "  'display_name': 'Paris, Île-de-France, France métropolitaine, France',\n",
       "  'boundingbox': ['48.8155755', '48.9021560', '2.2241220', '2.4697602']}]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Notre liste de villes contient des espaces. Nous remplaçons les espaces par le caractère '+' pour les futures requêtes API."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Mont+Saint+Michel',\n",
       " 'St+Malo',\n",
       " 'Bayeux',\n",
       " 'Le+Havre',\n",
       " 'Rouen',\n",
       " 'Paris',\n",
       " 'Amiens',\n",
       " 'Lille',\n",
       " 'Strasbourg',\n",
       " 'Chateau+du+Haut+Koenigsbourg',\n",
       " 'Colmar',\n",
       " 'Eguisheim',\n",
       " 'Besancon',\n",
       " 'Dijon',\n",
       " 'Annecy',\n",
       " 'Grenoble',\n",
       " 'Lyon',\n",
       " 'Gorges+du+Verdon',\n",
       " 'Bormes+les+Mimosas',\n",
       " 'Cassis',\n",
       " 'Marseille',\n",
       " 'Aix+en+Provence',\n",
       " 'Avignon',\n",
       " 'Uzes',\n",
       " 'Nimes',\n",
       " 'Aigues+Mortes',\n",
       " 'Saintes+Maries+de+la+mer',\n",
       " 'Collioure',\n",
       " 'Carcassonne',\n",
       " 'Ariege',\n",
       " 'Toulouse',\n",
       " 'Montauban',\n",
       " 'Biarritz',\n",
       " 'Bayonne',\n",
       " 'La+Rochelle']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cities_for_api = []\n",
    "for i, city in enumerate(cities): \n",
    "    cities_for_api.append(city.replace(' ','+'))\n",
    "cities_for_api"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Nous récupérons les données GPS et les stockons dans deux listes distinctes\n",
    "lat_list, lon_list = [], []\n",
    "for city in cities_for_api: \n",
    "    r = requests.get(f'https://nominatim.openstreetmap.org/search?city={city}&country=France&format=json')\n",
    "    lat_list.append(float(r.json()[0]['lat']))\n",
    "    lon_list.append(float(r.json()[0]['lon']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[48.6359541, 48.649518, 49.2764624, 49.4938975, 49.4404591, 48.8588897, 49.8941708, 50.6365654, 48.584614, 48.2495226, 48.0777517, 48.0447968, 47.2380222, 47.3215806, 45.8992348, 45.1875602, 45.7578137, 43.7496562, 43.1506968, 43.2140359, 43.2961743, 43.5298424, 43.9492493, 44.0121279, 43.8374249, 43.5661521, 43.4515922, 42.52505, 43.2130358, 42.9927428, 43.6044622, 44.0175835, 43.4832523, 43.4945144, 46.1591126]\n",
      "[-1.511459954959514, -2.0260409, -0.7024738, 0.1079732, 1.0939658, 2.3200410217200766, 2.2956951, 3.0635282, 7.7507127, 7.3454923, 7.3579641, 7.3079618, 6.0243622, 5.0414701, 6.1288847, 5.7357819, 4.8320114, 6.3285616, 6.3419285, 5.5396318, 5.3699525, 5.4474738, 4.8059012, 4.4196718, 4.3600687, 4.19154, 4.4277202, 3.0831554, 2.3491069, 1.6124975, 1.4442469, 1.3549991, -1.5592776, -1.4736657, -1.1520434]\n"
     ]
    }
   ],
   "source": [
    "print(lat_list)\n",
    "print(lon_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "float"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(lat_list[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## API Openweather\n",
    "\n",
    "Nous utilisons l'API Openweather pour récupérer les données météorologiques des 35 villes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# L'utilisation de cette API requiert une clé API\n",
    "# (renseignez votre clé API ci-dessous :)\n",
    "API_KEY = '' "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Météo actuelle"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "b'{\"coord\":{\"lon\":2.32,\"lat\":48.8589},\"weather\":[{\"id\":501,\"main\":\"Rain\",\"description\":\"pluie mod\\xc3\\xa9r\\xc3\\xa9e\",\"icon\":\"10n\"},{\"id\":701,\"main\":\"Mist\",\"description\":\"brume\",\"icon\":\"50n\"}],\"base\":\"stations\",\"main\":{\"temp\":10.84,\"feels_like\":10.49,\"temp_min\":10.19,\"temp_max\":11.32,\"pressure\":1005,\"humidity\":96},\"visibility\":5000,\"wind\":{\"speed\":7.2,\"deg\":210},\"rain\":{\"1h\":1.33},\"clouds\":{\"all\":100},\"dt\":1708556337,\"sys\":{\"type\":2,\"id\":2012208,\"country\":\"FR\",\"sunrise\":1708498176,\"sunset\":1708535974},\"timezone\":3600,\"id\":6545270,\"name\":\"Quartier du Palais-Royal\",\"cod\":200}'\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'coord': {'lon': 2.32, 'lat': 48.8589},\n",
       " 'weather': [{'id': 501,\n",
       "   'main': 'Rain',\n",
       "   'description': 'pluie modérée',\n",
       "   'icon': '10n'},\n",
       "  {'id': 701, 'main': 'Mist', 'description': 'brume', 'icon': '50n'}],\n",
       " 'base': 'stations',\n",
       " 'main': {'temp': 10.84,\n",
       "  'feels_like': 10.49,\n",
       "  'temp_min': 10.19,\n",
       "  'temp_max': 11.32,\n",
       "  'pressure': 1005,\n",
       "  'humidity': 96},\n",
       " 'visibility': 5000,\n",
       " 'wind': {'speed': 7.2, 'deg': 210},\n",
       " 'rain': {'1h': 1.33},\n",
       " 'clouds': {'all': 100},\n",
       " 'dt': 1708556337,\n",
       " 'sys': {'type': 2,\n",
       "  'id': 2012208,\n",
       "  'country': 'FR',\n",
       "  'sunrise': 1708498176,\n",
       "  'sunset': 1708535974},\n",
       " 'timezone': 3600,\n",
       " 'id': 6545270,\n",
       " 'name': 'Quartier du Palais-Royal',\n",
       " 'cod': 200}"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Nous effectuons un test pour Paris (qui se trouve à l'index 5)\n",
    "lat_paris = lat_list[5]\n",
    "lon_paris = lon_list[5]\n",
    "\n",
    "# Météo actuelle pour Paris\n",
    "r = requests.get(\n",
    "    f'https://api.openweathermap.org/data/2.5/weather?lat={lat_paris}&lon={lon_paris}&appid={API_KEY}&units=metric&lang=fr'\n",
    ")\n",
    "print(r.content)\n",
    "r.json()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Prévisions\n",
    "\n",
    "Openweather donne gratuitement les prévisions météorologiques pour les 5 prochains jours, et par tranche de 3 heures."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "b'{\"cod\":\"200\",\"message\":0,\"cnt\":40,\"list\":[{\"dt\":1708560000,\"main\":{\"temp\":10.84,\"feels_like\":10.49,\"temp_min\":10.84,\"temp_max\":11.33,\"pressure\":1005,\"sea_level\":1005,\"grnd_level\":1000,\"humidity\":96,\"temp_kf\":-0.49},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":5.47,\"deg\":218,\"gust\":13.5},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":2.75},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-22 00:00:00\"},{\"dt\":1708570800,\"main\":{\"temp\":11.16,\"feels_like\":10.81,\"temp_min\":11.16,\"temp_max\":11.8,\"pressure\":1004,\"sea_level\":1004,\"grnd_level\":997,\"humidity\":95,\"temp_kf\":-0.64},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":4.36,\"deg\":226,\"gust\":11.49},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":1.7},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-22 03:00:00\"},{\"dt\":1708581600,\"main\":{\"temp\":11.79,\"feels_like\":11.45,\"temp_min\":11.79,\"temp_max\":12.26,\"pressure\":1000,\"sea_level\":1000,\"grnd_level\":993,\"humidity\":93,\"temp_kf\":-0.47},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":6.05,\"deg\":210,\"gust\":13.3},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":1.14},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-22 06:00:00\"},{\"dt\":1708592400,\"main\":{\"temp\":12.27,\"feels_like\":11.82,\"temp_min\":12.27,\"temp_max\":12.27,\"pressure\":995,\"sea_level\":995,\"grnd_level\":990,\"humidity\":87,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10d\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":8.79,\"deg\":207,\"gust\":17.85},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":1.67},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-22 09:00:00\"},{\"dt\":1708603200,\"main\":{\"temp\":12.09,\"feels_like\":11.55,\"temp_min\":12.09,\"temp_max\":12.09,\"pressure\":989,\"sea_level\":989,\"grnd_level\":984,\"humidity\":84,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10d\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":9.76,\"deg\":202,\"gust\":20.47},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":0.94},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-22 12:00:00\"},{\"dt\":1708614000,\"main\":{\"temp\":10.89,\"feels_like\":9.89,\"temp_min\":10.89,\"temp_max\":10.89,\"pressure\":988,\"sea_level\":988,\"grnd_level\":983,\"humidity\":71,\"temp_kf\":0},\"weather\":[{\"id\":501,\"main\":\"Rain\",\"description\":\"pluie mod\\xc3\\xa9r\\xc3\\xa9e\",\"icon\":\"10d\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":9.86,\"deg\":235,\"gust\":20.26},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":4.58},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-22 15:00:00\"},{\"dt\":1708624800,\"main\":{\"temp\":7.53,\"feels_like\":3.63,\"temp_min\":7.53,\"temp_max\":7.53,\"pressure\":995,\"sea_level\":995,\"grnd_level\":990,\"humidity\":68,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":91},\"wind\":{\"speed\":7.42,\"deg\":264,\"gust\":15.3},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":0.44},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-22 18:00:00\"},{\"dt\":1708635600,\"main\":{\"temp\":6.48,\"feels_like\":2.34,\"temp_min\":6.48,\"temp_max\":6.48,\"pressure\":998,\"sea_level\":998,\"grnd_level\":993,\"humidity\":70,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":7.24,\"deg\":247,\"gust\":14.18},\"visibility\":10000,\"pop\":0.92,\"rain\":{\"3h\":0.5},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-22 21:00:00\"},{\"dt\":1708646400,\"main\":{\"temp\":5.18,\"feels_like\":0.95,\"temp_min\":5.18,\"temp_max\":5.18,\"pressure\":999,\"sea_level\":999,\"grnd_level\":994,\"humidity\":74,\"temp_kf\":0},\"weather\":[{\"id\":803,\"main\":\"Clouds\",\"description\":\"nuageux\",\"icon\":\"04n\"}],\"clouds\":{\"all\":55},\"wind\":{\"speed\":6.45,\"deg\":226,\"gust\":13.45},\"visibility\":10000,\"pop\":0.66,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-23 00:00:00\"},{\"dt\":1708657200,\"main\":{\"temp\":4.86,\"feels_like\":0.59,\"temp_min\":4.86,\"temp_max\":4.86,\"pressure\":998,\"sea_level\":998,\"grnd_level\":993,\"humidity\":79,\"temp_kf\":0},\"weather\":[{\"id\":802,\"main\":\"Clouds\",\"description\":\"partiellement nuageux\",\"icon\":\"03n\"}],\"clouds\":{\"all\":48},\"wind\":{\"speed\":6.33,\"deg\":215,\"gust\":12.58},\"visibility\":10000,\"pop\":0.05,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-23 03:00:00\"},{\"dt\":1708668000,\"main\":{\"temp\":4.63,\"feels_like\":0.39,\"temp_min\":4.63,\"temp_max\":4.63,\"pressure\":997,\"sea_level\":997,\"grnd_level\":992,\"humidity\":80,\"temp_kf\":0},\"weather\":[{\"id\":802,\"main\":\"Clouds\",\"description\":\"partiellement nuageux\",\"icon\":\"03n\"}],\"clouds\":{\"all\":27},\"wind\":{\"speed\":6.09,\"deg\":210,\"gust\":12.66},\"visibility\":10000,\"pop\":0.02,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-23 06:00:00\"},{\"dt\":1708678800,\"main\":{\"temp\":5.8,\"feels_like\":1.95,\"temp_min\":5.8,\"temp_max\":5.8,\"pressure\":997,\"sea_level\":997,\"grnd_level\":992,\"humidity\":78,\"temp_kf\":0},\"weather\":[{\"id\":802,\"main\":\"Clouds\",\"description\":\"partiellement nuageux\",\"icon\":\"03d\"}],\"clouds\":{\"all\":47},\"wind\":{\"speed\":5.9,\"deg\":208,\"gust\":11.74},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-23 09:00:00\"},{\"dt\":1708689600,\"main\":{\"temp\":8.81,\"feels_like\":5.54,\"temp_min\":8.81,\"temp_max\":8.81,\"pressure\":996,\"sea_level\":996,\"grnd_level\":991,\"humidity\":57,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10d\"}],\"clouds\":{\"all\":59},\"wind\":{\"speed\":6.59,\"deg\":224,\"gust\":10.24},\"visibility\":10000,\"pop\":0.2,\"rain\":{\"3h\":0.37},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-23 12:00:00\"},{\"dt\":1708700400,\"main\":{\"temp\":6.49,\"feels_like\":3.01,\"temp_min\":6.49,\"temp_max\":6.49,\"pressure\":995,\"sea_level\":995,\"grnd_level\":990,\"humidity\":74,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10d\"}],\"clouds\":{\"all\":94},\"wind\":{\"speed\":5.44,\"deg\":220,\"gust\":9.43},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":1},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-23 15:00:00\"},{\"dt\":1708711200,\"main\":{\"temp\":5.99,\"feels_like\":2.76,\"temp_min\":5.99,\"temp_max\":5.99,\"pressure\":996,\"sea_level\":996,\"grnd_level\":990,\"humidity\":65,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":85},\"wind\":{\"speed\":4.61,\"deg\":226,\"gust\":9.17},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":0.53},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-23 18:00:00\"},{\"dt\":1708722000,\"main\":{\"temp\":5.09,\"feels_like\":1.9,\"temp_min\":5.09,\"temp_max\":5.09,\"pressure\":996,\"sea_level\":996,\"grnd_level\":991,\"humidity\":72,\"temp_kf\":0},\"weather\":[{\"id\":804,\"main\":\"Clouds\",\"description\":\"couvert\",\"icon\":\"04n\"}],\"clouds\":{\"all\":91},\"wind\":{\"speed\":4.13,\"deg\":215,\"gust\":9.27},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-23 21:00:00\"},{\"dt\":1708732800,\"main\":{\"temp\":3.95,\"feels_like\":0.56,\"temp_min\":3.95,\"temp_max\":3.95,\"pressure\":997,\"sea_level\":997,\"grnd_level\":992,\"humidity\":80,\"temp_kf\":0},\"weather\":[{\"id\":804,\"main\":\"Clouds\",\"description\":\"couvert\",\"icon\":\"04n\"}],\"clouds\":{\"all\":87},\"wind\":{\"speed\":4.02,\"deg\":214,\"gust\":8.48},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-24 00:00:00\"},{\"dt\":1708743600,\"main\":{\"temp\":2.9,\"feels_like\":-1.11,\"temp_min\":2.9,\"temp_max\":2.9,\"pressure\":998,\"sea_level\":998,\"grnd_level\":993,\"humidity\":85,\"temp_kf\":0},\"weather\":[{\"id\":803,\"main\":\"Clouds\",\"description\":\"nuageux\",\"icon\":\"04n\"}],\"clouds\":{\"all\":53},\"wind\":{\"speed\":4.67,\"deg\":213,\"gust\":10.65},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-24 03:00:00\"},{\"dt\":1708754400,\"main\":{\"temp\":2.4,\"feels_like\":-1.74,\"temp_min\":2.4,\"temp_max\":2.4,\"pressure\":999,\"sea_level\":999,\"grnd_level\":994,\"humidity\":85,\"temp_kf\":0},\"weather\":[{\"id\":802,\"main\":\"Clouds\",\"description\":\"partiellement nuageux\",\"icon\":\"03n\"}],\"clouds\":{\"all\":47},\"wind\":{\"speed\":4.67,\"deg\":201,\"gust\":11.61},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-24 06:00:00\"},{\"dt\":1708765200,\"main\":{\"temp\":4.02,\"feels_like\":-0.04,\"temp_min\":4.02,\"temp_max\":4.02,\"pressure\":1000,\"sea_level\":1000,\"grnd_level\":995,\"humidity\":78,\"temp_kf\":0},\"weather\":[{\"id\":802,\"main\":\"Clouds\",\"description\":\"partiellement nuageux\",\"icon\":\"03d\"}],\"clouds\":{\"all\":50},\"wind\":{\"speed\":5.32,\"deg\":195,\"gust\":11.34},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-24 09:00:00\"},{\"dt\":1708776000,\"main\":{\"temp\":8.51,\"feels_like\":5.21,\"temp_min\":8.51,\"temp_max\":8.51,\"pressure\":1000,\"sea_level\":1000,\"grnd_level\":995,\"humidity\":55,\"temp_kf\":0},\"weather\":[{\"id\":802,\"main\":\"Clouds\",\"description\":\"partiellement nuageux\",\"icon\":\"03d\"}],\"clouds\":{\"all\":32},\"wind\":{\"speed\":6.43,\"deg\":202,\"gust\":10.04},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-24 12:00:00\"},{\"dt\":1708786800,\"main\":{\"temp\":9.29,\"feels_like\":6.26,\"temp_min\":9.29,\"temp_max\":9.29,\"pressure\":999,\"sea_level\":999,\"grnd_level\":994,\"humidity\":57,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10d\"}],\"clouds\":{\"all\":76},\"wind\":{\"speed\":6.23,\"deg\":199,\"gust\":10.63},\"visibility\":10000,\"pop\":0.84,\"rain\":{\"3h\":0.35},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-24 15:00:00\"},{\"dt\":1708797600,\"main\":{\"temp\":7.01,\"feels_like\":3.67,\"temp_min\":7.01,\"temp_max\":7.01,\"pressure\":1000,\"sea_level\":1000,\"grnd_level\":995,\"humidity\":77,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":88},\"wind\":{\"speed\":5.44,\"deg\":211,\"gust\":9.8},\"visibility\":10000,\"pop\":0.97,\"rain\":{\"3h\":1.59},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-24 18:00:00\"},{\"dt\":1708808400,\"main\":{\"temp\":5.95,\"feels_like\":2.56,\"temp_min\":5.95,\"temp_max\":5.95,\"pressure\":1001,\"sea_level\":1001,\"grnd_level\":996,\"humidity\":81,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":78},\"wind\":{\"speed\":4.92,\"deg\":221,\"gust\":10.9},\"visibility\":10000,\"pop\":0.55,\"rain\":{\"3h\":0.25},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-24 21:00:00\"},{\"dt\":1708819200,\"main\":{\"temp\":5.1,\"feels_like\":1.76,\"temp_min\":5.1,\"temp_max\":5.1,\"pressure\":1002,\"sea_level\":1002,\"grnd_level\":997,\"humidity\":85,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":60},\"wind\":{\"speed\":4.41,\"deg\":229,\"gust\":10.63},\"visibility\":10000,\"pop\":0.36,\"rain\":{\"3h\":0.11},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-25 00:00:00\"},{\"dt\":1708830000,\"main\":{\"temp\":4.15,\"feels_like\":0.94,\"temp_min\":4.15,\"temp_max\":4.15,\"pressure\":1002,\"sea_level\":1002,\"grnd_level\":996,\"humidity\":89,\"temp_kf\":0},\"weather\":[{\"id\":803,\"main\":\"Clouds\",\"description\":\"nuageux\",\"icon\":\"04n\"}],\"clouds\":{\"all\":67},\"wind\":{\"speed\":3.8,\"deg\":204,\"gust\":9.7},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-25 03:00:00\"},{\"dt\":1708840800,\"main\":{\"temp\":3.76,\"feels_like\":0.51,\"temp_min\":3.76,\"temp_max\":3.76,\"pressure\":1001,\"sea_level\":1001,\"grnd_level\":995,\"humidity\":90,\"temp_kf\":0},\"weather\":[{\"id\":803,\"main\":\"Clouds\",\"description\":\"nuageux\",\"icon\":\"04n\"}],\"clouds\":{\"all\":81},\"wind\":{\"speed\":3.72,\"deg\":180,\"gust\":10.86},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-25 06:00:00\"},{\"dt\":1708851600,\"main\":{\"temp\":5.25,\"feels_like\":1.69,\"temp_min\":5.25,\"temp_max\":5.25,\"pressure\":998,\"sea_level\":998,\"grnd_level\":993,\"humidity\":86,\"temp_kf\":0},\"weather\":[{\"id\":804,\"main\":\"Clouds\",\"description\":\"couvert\",\"icon\":\"04d\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":4.92,\"deg\":155,\"gust\":11.89},\"visibility\":10000,\"pop\":0,\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-25 09:00:00\"},{\"dt\":1708862400,\"main\":{\"temp\":7.4,\"feels_like\":3.58,\"temp_min\":7.4,\"temp_max\":7.4,\"pressure\":993,\"sea_level\":993,\"grnd_level\":988,\"humidity\":75,\"temp_kf\":0},\"weather\":[{\"id\":804,\"main\":\"Clouds\",\"description\":\"couvert\",\"icon\":\"04d\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":7.04,\"deg\":149,\"gust\":13.8},\"visibility\":10000,\"pop\":0.14,\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-25 12:00:00\"},{\"dt\":1708873200,\"main\":{\"temp\":5.8,\"feels_like\":1.15,\"temp_min\":5.8,\"temp_max\":5.8,\"pressure\":987,\"sea_level\":987,\"grnd_level\":982,\"humidity\":90,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10d\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":8.22,\"deg\":144,\"gust\":16.03},\"visibility\":9236,\"pop\":0.95,\"rain\":{\"3h\":2.23},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-25 15:00:00\"},{\"dt\":1708884000,\"main\":{\"temp\":7.61,\"feels_like\":4.07,\"temp_min\":7.61,\"temp_max\":7.61,\"pressure\":981,\"sea_level\":981,\"grnd_level\":976,\"humidity\":93,\"temp_kf\":0},\"weather\":[{\"id\":501,\"main\":\"Rain\",\"description\":\"pluie mod\\xc3\\xa9r\\xc3\\xa9e\",\"icon\":\"10n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":6.4,\"deg\":159,\"gust\":15.63},\"visibility\":7549,\"pop\":1,\"rain\":{\"3h\":6.77},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-25 18:00:00\"},{\"dt\":1708894800,\"main\":{\"temp\":9.97,\"feels_like\":6.61,\"temp_min\":9.97,\"temp_max\":9.97,\"pressure\":982,\"sea_level\":982,\"grnd_level\":977,\"humidity\":79,\"temp_kf\":0},\"weather\":[{\"id\":501,\"main\":\"Rain\",\"description\":\"pluie mod\\xc3\\xa9r\\xc3\\xa9e\",\"icon\":\"10n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":8.1,\"deg\":209,\"gust\":15.75},\"visibility\":10000,\"pop\":0.94,\"rain\":{\"3h\":4.93},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-25 21:00:00\"},{\"dt\":1708905600,\"main\":{\"temp\":8.96,\"feels_like\":5.64,\"temp_min\":8.96,\"temp_max\":8.96,\"pressure\":985,\"sea_level\":985,\"grnd_level\":980,\"humidity\":69,\"temp_kf\":0},\"weather\":[{\"id\":804,\"main\":\"Clouds\",\"description\":\"couvert\",\"icon\":\"04n\"}],\"clouds\":{\"all\":99},\"wind\":{\"speed\":6.88,\"deg\":193,\"gust\":14.01},\"visibility\":10000,\"pop\":0.74,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-26 00:00:00\"},{\"dt\":1708916400,\"main\":{\"temp\":8.18,\"feels_like\":4.57,\"temp_min\":8.18,\"temp_max\":8.18,\"pressure\":984,\"sea_level\":984,\"grnd_level\":979,\"humidity\":69,\"temp_kf\":0},\"weather\":[{\"id\":804,\"main\":\"Clouds\",\"description\":\"couvert\",\"icon\":\"04n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":7.1,\"deg\":161,\"gust\":16.19},\"visibility\":10000,\"pop\":0.03,\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-26 03:00:00\"},{\"dt\":1708927200,\"main\":{\"temp\":7.85,\"feels_like\":3.89,\"temp_min\":7.85,\"temp_max\":7.85,\"pressure\":981,\"sea_level\":981,\"grnd_level\":976,\"humidity\":75,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":7.94,\"deg\":152,\"gust\":18.13},\"visibility\":10000,\"pop\":0.6,\"rain\":{\"3h\":0.88},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-26 06:00:00\"},{\"dt\":1708938000,\"main\":{\"temp\":6.94,\"feels_like\":3.02,\"temp_min\":6.94,\"temp_max\":6.94,\"pressure\":983,\"sea_level\":983,\"grnd_level\":978,\"humidity\":87,\"temp_kf\":0},\"weather\":[{\"id\":501,\"main\":\"Rain\",\"description\":\"pluie mod\\xc3\\xa9r\\xc3\\xa9e\",\"icon\":\"10d\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":6.96,\"deg\":143,\"gust\":13.41},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":5.84},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-26 09:00:00\"},{\"dt\":1708948800,\"main\":{\"temp\":7.02,\"feels_like\":3.65,\"temp_min\":7.02,\"temp_max\":7.02,\"pressure\":985,\"sea_level\":985,\"grnd_level\":980,\"humidity\":85,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10d\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":5.51,\"deg\":137,\"gust\":10.53},\"visibility\":10000,\"pop\":1,\"rain\":{\"3h\":0.85},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-26 12:00:00\"},{\"dt\":1708959600,\"main\":{\"temp\":7.17,\"feels_like\":4.14,\"temp_min\":7.17,\"temp_max\":7.17,\"pressure\":987,\"sea_level\":987,\"grnd_level\":982,\"humidity\":86,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10d\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":4.79,\"deg\":124,\"gust\":8.42},\"visibility\":10000,\"pop\":0.97,\"rain\":{\"3h\":1.87},\"sys\":{\"pod\":\"d\"},\"dt_txt\":\"2024-02-26 15:00:00\"},{\"dt\":1708970400,\"main\":{\"temp\":7.27,\"feels_like\":4.65,\"temp_min\":7.27,\"temp_max\":7.27,\"pressure\":990,\"sea_level\":990,\"grnd_level\":985,\"humidity\":85,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":4,\"deg\":103,\"gust\":6.79},\"visibility\":10000,\"pop\":0.99,\"rain\":{\"3h\":0.54},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-26 18:00:00\"},{\"dt\":1708981200,\"main\":{\"temp\":6.88,\"feels_like\":3.87,\"temp_min\":6.88,\"temp_max\":6.88,\"pressure\":994,\"sea_level\":994,\"grnd_level\":989,\"humidity\":86,\"temp_kf\":0},\"weather\":[{\"id\":500,\"main\":\"Rain\",\"description\":\"l\\xc3\\xa9g\\xc3\\xa8re pluie\",\"icon\":\"10n\"}],\"clouds\":{\"all\":100},\"wind\":{\"speed\":4.6,\"deg\":77,\"gust\":7.92},\"visibility\":10000,\"pop\":0.91,\"rain\":{\"3h\":0.66},\"sys\":{\"pod\":\"n\"},\"dt_txt\":\"2024-02-26 21:00:00\"}],\"city\":{\"id\":6545270,\"name\":\"Quartier du Palais-Royal\",\"coord\":{\"lat\":48.8589,\"lon\":2.32},\"country\":\"FR\",\"population\":0,\"timezone\":3600,\"sunrise\":1708498176,\"sunset\":1708535974}}'\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'cod': '200',\n",
       " 'message': 0,\n",
       " 'cnt': 40,\n",
       " 'list': [{'dt': 1708560000,\n",
       "   'main': {'temp': 10.84,\n",
       "    'feels_like': 10.49,\n",
       "    'temp_min': 10.84,\n",
       "    'temp_max': 11.33,\n",
       "    'pressure': 1005,\n",
       "    'sea_level': 1005,\n",
       "    'grnd_level': 1000,\n",
       "    'humidity': 96,\n",
       "    'temp_kf': -0.49},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 5.47, 'deg': 218, 'gust': 13.5},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 2.75},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-22 00:00:00'},\n",
       "  {'dt': 1708570800,\n",
       "   'main': {'temp': 11.16,\n",
       "    'feels_like': 10.81,\n",
       "    'temp_min': 11.16,\n",
       "    'temp_max': 11.8,\n",
       "    'pressure': 1004,\n",
       "    'sea_level': 1004,\n",
       "    'grnd_level': 997,\n",
       "    'humidity': 95,\n",
       "    'temp_kf': -0.64},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 4.36, 'deg': 226, 'gust': 11.49},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 1.7},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-22 03:00:00'},\n",
       "  {'dt': 1708581600,\n",
       "   'main': {'temp': 11.79,\n",
       "    'feels_like': 11.45,\n",
       "    'temp_min': 11.79,\n",
       "    'temp_max': 12.26,\n",
       "    'pressure': 1000,\n",
       "    'sea_level': 1000,\n",
       "    'grnd_level': 993,\n",
       "    'humidity': 93,\n",
       "    'temp_kf': -0.47},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 6.05, 'deg': 210, 'gust': 13.3},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 1.14},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-22 06:00:00'},\n",
       "  {'dt': 1708592400,\n",
       "   'main': {'temp': 12.27,\n",
       "    'feels_like': 11.82,\n",
       "    'temp_min': 12.27,\n",
       "    'temp_max': 12.27,\n",
       "    'pressure': 995,\n",
       "    'sea_level': 995,\n",
       "    'grnd_level': 990,\n",
       "    'humidity': 87,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 8.79, 'deg': 207, 'gust': 17.85},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 1.67},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-22 09:00:00'},\n",
       "  {'dt': 1708603200,\n",
       "   'main': {'temp': 12.09,\n",
       "    'feels_like': 11.55,\n",
       "    'temp_min': 12.09,\n",
       "    'temp_max': 12.09,\n",
       "    'pressure': 989,\n",
       "    'sea_level': 989,\n",
       "    'grnd_level': 984,\n",
       "    'humidity': 84,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 9.76, 'deg': 202, 'gust': 20.47},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 0.94},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-22 12:00:00'},\n",
       "  {'dt': 1708614000,\n",
       "   'main': {'temp': 10.89,\n",
       "    'feels_like': 9.89,\n",
       "    'temp_min': 10.89,\n",
       "    'temp_max': 10.89,\n",
       "    'pressure': 988,\n",
       "    'sea_level': 988,\n",
       "    'grnd_level': 983,\n",
       "    'humidity': 71,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 501,\n",
       "     'main': 'Rain',\n",
       "     'description': 'pluie modérée',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 9.86, 'deg': 235, 'gust': 20.26},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 4.58},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-22 15:00:00'},\n",
       "  {'dt': 1708624800,\n",
       "   'main': {'temp': 7.53,\n",
       "    'feels_like': 3.63,\n",
       "    'temp_min': 7.53,\n",
       "    'temp_max': 7.53,\n",
       "    'pressure': 995,\n",
       "    'sea_level': 995,\n",
       "    'grnd_level': 990,\n",
       "    'humidity': 68,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 91},\n",
       "   'wind': {'speed': 7.42, 'deg': 264, 'gust': 15.3},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 0.44},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-22 18:00:00'},\n",
       "  {'dt': 1708635600,\n",
       "   'main': {'temp': 6.48,\n",
       "    'feels_like': 2.34,\n",
       "    'temp_min': 6.48,\n",
       "    'temp_max': 6.48,\n",
       "    'pressure': 998,\n",
       "    'sea_level': 998,\n",
       "    'grnd_level': 993,\n",
       "    'humidity': 70,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 7.24, 'deg': 247, 'gust': 14.18},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.92,\n",
       "   'rain': {'3h': 0.5},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-22 21:00:00'},\n",
       "  {'dt': 1708646400,\n",
       "   'main': {'temp': 5.18,\n",
       "    'feels_like': 0.95,\n",
       "    'temp_min': 5.18,\n",
       "    'temp_max': 5.18,\n",
       "    'pressure': 999,\n",
       "    'sea_level': 999,\n",
       "    'grnd_level': 994,\n",
       "    'humidity': 74,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 803,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'nuageux',\n",
       "     'icon': '04n'}],\n",
       "   'clouds': {'all': 55},\n",
       "   'wind': {'speed': 6.45, 'deg': 226, 'gust': 13.45},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.66,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-23 00:00:00'},\n",
       "  {'dt': 1708657200,\n",
       "   'main': {'temp': 4.86,\n",
       "    'feels_like': 0.59,\n",
       "    'temp_min': 4.86,\n",
       "    'temp_max': 4.86,\n",
       "    'pressure': 998,\n",
       "    'sea_level': 998,\n",
       "    'grnd_level': 993,\n",
       "    'humidity': 79,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 802,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'partiellement nuageux',\n",
       "     'icon': '03n'}],\n",
       "   'clouds': {'all': 48},\n",
       "   'wind': {'speed': 6.33, 'deg': 215, 'gust': 12.58},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.05,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-23 03:00:00'},\n",
       "  {'dt': 1708668000,\n",
       "   'main': {'temp': 4.63,\n",
       "    'feels_like': 0.39,\n",
       "    'temp_min': 4.63,\n",
       "    'temp_max': 4.63,\n",
       "    'pressure': 997,\n",
       "    'sea_level': 997,\n",
       "    'grnd_level': 992,\n",
       "    'humidity': 80,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 802,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'partiellement nuageux',\n",
       "     'icon': '03n'}],\n",
       "   'clouds': {'all': 27},\n",
       "   'wind': {'speed': 6.09, 'deg': 210, 'gust': 12.66},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.02,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-23 06:00:00'},\n",
       "  {'dt': 1708678800,\n",
       "   'main': {'temp': 5.8,\n",
       "    'feels_like': 1.95,\n",
       "    'temp_min': 5.8,\n",
       "    'temp_max': 5.8,\n",
       "    'pressure': 997,\n",
       "    'sea_level': 997,\n",
       "    'grnd_level': 992,\n",
       "    'humidity': 78,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 802,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'partiellement nuageux',\n",
       "     'icon': '03d'}],\n",
       "   'clouds': {'all': 47},\n",
       "   'wind': {'speed': 5.9, 'deg': 208, 'gust': 11.74},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-23 09:00:00'},\n",
       "  {'dt': 1708689600,\n",
       "   'main': {'temp': 8.81,\n",
       "    'feels_like': 5.54,\n",
       "    'temp_min': 8.81,\n",
       "    'temp_max': 8.81,\n",
       "    'pressure': 996,\n",
       "    'sea_level': 996,\n",
       "    'grnd_level': 991,\n",
       "    'humidity': 57,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 59},\n",
       "   'wind': {'speed': 6.59, 'deg': 224, 'gust': 10.24},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.2,\n",
       "   'rain': {'3h': 0.37},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-23 12:00:00'},\n",
       "  {'dt': 1708700400,\n",
       "   'main': {'temp': 6.49,\n",
       "    'feels_like': 3.01,\n",
       "    'temp_min': 6.49,\n",
       "    'temp_max': 6.49,\n",
       "    'pressure': 995,\n",
       "    'sea_level': 995,\n",
       "    'grnd_level': 990,\n",
       "    'humidity': 74,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 94},\n",
       "   'wind': {'speed': 5.44, 'deg': 220, 'gust': 9.43},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 1},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-23 15:00:00'},\n",
       "  {'dt': 1708711200,\n",
       "   'main': {'temp': 5.99,\n",
       "    'feels_like': 2.76,\n",
       "    'temp_min': 5.99,\n",
       "    'temp_max': 5.99,\n",
       "    'pressure': 996,\n",
       "    'sea_level': 996,\n",
       "    'grnd_level': 990,\n",
       "    'humidity': 65,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 85},\n",
       "   'wind': {'speed': 4.61, 'deg': 226, 'gust': 9.17},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 0.53},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-23 18:00:00'},\n",
       "  {'dt': 1708722000,\n",
       "   'main': {'temp': 5.09,\n",
       "    'feels_like': 1.9,\n",
       "    'temp_min': 5.09,\n",
       "    'temp_max': 5.09,\n",
       "    'pressure': 996,\n",
       "    'sea_level': 996,\n",
       "    'grnd_level': 991,\n",
       "    'humidity': 72,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 804,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'couvert',\n",
       "     'icon': '04n'}],\n",
       "   'clouds': {'all': 91},\n",
       "   'wind': {'speed': 4.13, 'deg': 215, 'gust': 9.27},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-23 21:00:00'},\n",
       "  {'dt': 1708732800,\n",
       "   'main': {'temp': 3.95,\n",
       "    'feels_like': 0.56,\n",
       "    'temp_min': 3.95,\n",
       "    'temp_max': 3.95,\n",
       "    'pressure': 997,\n",
       "    'sea_level': 997,\n",
       "    'grnd_level': 992,\n",
       "    'humidity': 80,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 804,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'couvert',\n",
       "     'icon': '04n'}],\n",
       "   'clouds': {'all': 87},\n",
       "   'wind': {'speed': 4.02, 'deg': 214, 'gust': 8.48},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-24 00:00:00'},\n",
       "  {'dt': 1708743600,\n",
       "   'main': {'temp': 2.9,\n",
       "    'feels_like': -1.11,\n",
       "    'temp_min': 2.9,\n",
       "    'temp_max': 2.9,\n",
       "    'pressure': 998,\n",
       "    'sea_level': 998,\n",
       "    'grnd_level': 993,\n",
       "    'humidity': 85,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 803,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'nuageux',\n",
       "     'icon': '04n'}],\n",
       "   'clouds': {'all': 53},\n",
       "   'wind': {'speed': 4.67, 'deg': 213, 'gust': 10.65},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-24 03:00:00'},\n",
       "  {'dt': 1708754400,\n",
       "   'main': {'temp': 2.4,\n",
       "    'feels_like': -1.74,\n",
       "    'temp_min': 2.4,\n",
       "    'temp_max': 2.4,\n",
       "    'pressure': 999,\n",
       "    'sea_level': 999,\n",
       "    'grnd_level': 994,\n",
       "    'humidity': 85,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 802,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'partiellement nuageux',\n",
       "     'icon': '03n'}],\n",
       "   'clouds': {'all': 47},\n",
       "   'wind': {'speed': 4.67, 'deg': 201, 'gust': 11.61},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-24 06:00:00'},\n",
       "  {'dt': 1708765200,\n",
       "   'main': {'temp': 4.02,\n",
       "    'feels_like': -0.04,\n",
       "    'temp_min': 4.02,\n",
       "    'temp_max': 4.02,\n",
       "    'pressure': 1000,\n",
       "    'sea_level': 1000,\n",
       "    'grnd_level': 995,\n",
       "    'humidity': 78,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 802,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'partiellement nuageux',\n",
       "     'icon': '03d'}],\n",
       "   'clouds': {'all': 50},\n",
       "   'wind': {'speed': 5.32, 'deg': 195, 'gust': 11.34},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-24 09:00:00'},\n",
       "  {'dt': 1708776000,\n",
       "   'main': {'temp': 8.51,\n",
       "    'feels_like': 5.21,\n",
       "    'temp_min': 8.51,\n",
       "    'temp_max': 8.51,\n",
       "    'pressure': 1000,\n",
       "    'sea_level': 1000,\n",
       "    'grnd_level': 995,\n",
       "    'humidity': 55,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 802,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'partiellement nuageux',\n",
       "     'icon': '03d'}],\n",
       "   'clouds': {'all': 32},\n",
       "   'wind': {'speed': 6.43, 'deg': 202, 'gust': 10.04},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-24 12:00:00'},\n",
       "  {'dt': 1708786800,\n",
       "   'main': {'temp': 9.29,\n",
       "    'feels_like': 6.26,\n",
       "    'temp_min': 9.29,\n",
       "    'temp_max': 9.29,\n",
       "    'pressure': 999,\n",
       "    'sea_level': 999,\n",
       "    'grnd_level': 994,\n",
       "    'humidity': 57,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 76},\n",
       "   'wind': {'speed': 6.23, 'deg': 199, 'gust': 10.63},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.84,\n",
       "   'rain': {'3h': 0.35},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-24 15:00:00'},\n",
       "  {'dt': 1708797600,\n",
       "   'main': {'temp': 7.01,\n",
       "    'feels_like': 3.67,\n",
       "    'temp_min': 7.01,\n",
       "    'temp_max': 7.01,\n",
       "    'pressure': 1000,\n",
       "    'sea_level': 1000,\n",
       "    'grnd_level': 995,\n",
       "    'humidity': 77,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 88},\n",
       "   'wind': {'speed': 5.44, 'deg': 211, 'gust': 9.8},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.97,\n",
       "   'rain': {'3h': 1.59},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-24 18:00:00'},\n",
       "  {'dt': 1708808400,\n",
       "   'main': {'temp': 5.95,\n",
       "    'feels_like': 2.56,\n",
       "    'temp_min': 5.95,\n",
       "    'temp_max': 5.95,\n",
       "    'pressure': 1001,\n",
       "    'sea_level': 1001,\n",
       "    'grnd_level': 996,\n",
       "    'humidity': 81,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 78},\n",
       "   'wind': {'speed': 4.92, 'deg': 221, 'gust': 10.9},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.55,\n",
       "   'rain': {'3h': 0.25},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-24 21:00:00'},\n",
       "  {'dt': 1708819200,\n",
       "   'main': {'temp': 5.1,\n",
       "    'feels_like': 1.76,\n",
       "    'temp_min': 5.1,\n",
       "    'temp_max': 5.1,\n",
       "    'pressure': 1002,\n",
       "    'sea_level': 1002,\n",
       "    'grnd_level': 997,\n",
       "    'humidity': 85,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 60},\n",
       "   'wind': {'speed': 4.41, 'deg': 229, 'gust': 10.63},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.36,\n",
       "   'rain': {'3h': 0.11},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-25 00:00:00'},\n",
       "  {'dt': 1708830000,\n",
       "   'main': {'temp': 4.15,\n",
       "    'feels_like': 0.94,\n",
       "    'temp_min': 4.15,\n",
       "    'temp_max': 4.15,\n",
       "    'pressure': 1002,\n",
       "    'sea_level': 1002,\n",
       "    'grnd_level': 996,\n",
       "    'humidity': 89,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 803,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'nuageux',\n",
       "     'icon': '04n'}],\n",
       "   'clouds': {'all': 67},\n",
       "   'wind': {'speed': 3.8, 'deg': 204, 'gust': 9.7},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-25 03:00:00'},\n",
       "  {'dt': 1708840800,\n",
       "   'main': {'temp': 3.76,\n",
       "    'feels_like': 0.51,\n",
       "    'temp_min': 3.76,\n",
       "    'temp_max': 3.76,\n",
       "    'pressure': 1001,\n",
       "    'sea_level': 1001,\n",
       "    'grnd_level': 995,\n",
       "    'humidity': 90,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 803,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'nuageux',\n",
       "     'icon': '04n'}],\n",
       "   'clouds': {'all': 81},\n",
       "   'wind': {'speed': 3.72, 'deg': 180, 'gust': 10.86},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-25 06:00:00'},\n",
       "  {'dt': 1708851600,\n",
       "   'main': {'temp': 5.25,\n",
       "    'feels_like': 1.69,\n",
       "    'temp_min': 5.25,\n",
       "    'temp_max': 5.25,\n",
       "    'pressure': 998,\n",
       "    'sea_level': 998,\n",
       "    'grnd_level': 993,\n",
       "    'humidity': 86,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 804,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'couvert',\n",
       "     'icon': '04d'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 4.92, 'deg': 155, 'gust': 11.89},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0,\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-25 09:00:00'},\n",
       "  {'dt': 1708862400,\n",
       "   'main': {'temp': 7.4,\n",
       "    'feels_like': 3.58,\n",
       "    'temp_min': 7.4,\n",
       "    'temp_max': 7.4,\n",
       "    'pressure': 993,\n",
       "    'sea_level': 993,\n",
       "    'grnd_level': 988,\n",
       "    'humidity': 75,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 804,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'couvert',\n",
       "     'icon': '04d'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 7.04, 'deg': 149, 'gust': 13.8},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.14,\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-25 12:00:00'},\n",
       "  {'dt': 1708873200,\n",
       "   'main': {'temp': 5.8,\n",
       "    'feels_like': 1.15,\n",
       "    'temp_min': 5.8,\n",
       "    'temp_max': 5.8,\n",
       "    'pressure': 987,\n",
       "    'sea_level': 987,\n",
       "    'grnd_level': 982,\n",
       "    'humidity': 90,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 8.22, 'deg': 144, 'gust': 16.03},\n",
       "   'visibility': 9236,\n",
       "   'pop': 0.95,\n",
       "   'rain': {'3h': 2.23},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-25 15:00:00'},\n",
       "  {'dt': 1708884000,\n",
       "   'main': {'temp': 7.61,\n",
       "    'feels_like': 4.07,\n",
       "    'temp_min': 7.61,\n",
       "    'temp_max': 7.61,\n",
       "    'pressure': 981,\n",
       "    'sea_level': 981,\n",
       "    'grnd_level': 976,\n",
       "    'humidity': 93,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 501,\n",
       "     'main': 'Rain',\n",
       "     'description': 'pluie modérée',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 6.4, 'deg': 159, 'gust': 15.63},\n",
       "   'visibility': 7549,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 6.77},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-25 18:00:00'},\n",
       "  {'dt': 1708894800,\n",
       "   'main': {'temp': 9.97,\n",
       "    'feels_like': 6.61,\n",
       "    'temp_min': 9.97,\n",
       "    'temp_max': 9.97,\n",
       "    'pressure': 982,\n",
       "    'sea_level': 982,\n",
       "    'grnd_level': 977,\n",
       "    'humidity': 79,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 501,\n",
       "     'main': 'Rain',\n",
       "     'description': 'pluie modérée',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 8.1, 'deg': 209, 'gust': 15.75},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.94,\n",
       "   'rain': {'3h': 4.93},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-25 21:00:00'},\n",
       "  {'dt': 1708905600,\n",
       "   'main': {'temp': 8.96,\n",
       "    'feels_like': 5.64,\n",
       "    'temp_min': 8.96,\n",
       "    'temp_max': 8.96,\n",
       "    'pressure': 985,\n",
       "    'sea_level': 985,\n",
       "    'grnd_level': 980,\n",
       "    'humidity': 69,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 804,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'couvert',\n",
       "     'icon': '04n'}],\n",
       "   'clouds': {'all': 99},\n",
       "   'wind': {'speed': 6.88, 'deg': 193, 'gust': 14.01},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.74,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-26 00:00:00'},\n",
       "  {'dt': 1708916400,\n",
       "   'main': {'temp': 8.18,\n",
       "    'feels_like': 4.57,\n",
       "    'temp_min': 8.18,\n",
       "    'temp_max': 8.18,\n",
       "    'pressure': 984,\n",
       "    'sea_level': 984,\n",
       "    'grnd_level': 979,\n",
       "    'humidity': 69,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 804,\n",
       "     'main': 'Clouds',\n",
       "     'description': 'couvert',\n",
       "     'icon': '04n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 7.1, 'deg': 161, 'gust': 16.19},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.03,\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-26 03:00:00'},\n",
       "  {'dt': 1708927200,\n",
       "   'main': {'temp': 7.85,\n",
       "    'feels_like': 3.89,\n",
       "    'temp_min': 7.85,\n",
       "    'temp_max': 7.85,\n",
       "    'pressure': 981,\n",
       "    'sea_level': 981,\n",
       "    'grnd_level': 976,\n",
       "    'humidity': 75,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 7.94, 'deg': 152, 'gust': 18.13},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.6,\n",
       "   'rain': {'3h': 0.88},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-26 06:00:00'},\n",
       "  {'dt': 1708938000,\n",
       "   'main': {'temp': 6.94,\n",
       "    'feels_like': 3.02,\n",
       "    'temp_min': 6.94,\n",
       "    'temp_max': 6.94,\n",
       "    'pressure': 983,\n",
       "    'sea_level': 983,\n",
       "    'grnd_level': 978,\n",
       "    'humidity': 87,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 501,\n",
       "     'main': 'Rain',\n",
       "     'description': 'pluie modérée',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 6.96, 'deg': 143, 'gust': 13.41},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 5.84},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-26 09:00:00'},\n",
       "  {'dt': 1708948800,\n",
       "   'main': {'temp': 7.02,\n",
       "    'feels_like': 3.65,\n",
       "    'temp_min': 7.02,\n",
       "    'temp_max': 7.02,\n",
       "    'pressure': 985,\n",
       "    'sea_level': 985,\n",
       "    'grnd_level': 980,\n",
       "    'humidity': 85,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 5.51, 'deg': 137, 'gust': 10.53},\n",
       "   'visibility': 10000,\n",
       "   'pop': 1,\n",
       "   'rain': {'3h': 0.85},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-26 12:00:00'},\n",
       "  {'dt': 1708959600,\n",
       "   'main': {'temp': 7.17,\n",
       "    'feels_like': 4.14,\n",
       "    'temp_min': 7.17,\n",
       "    'temp_max': 7.17,\n",
       "    'pressure': 987,\n",
       "    'sea_level': 987,\n",
       "    'grnd_level': 982,\n",
       "    'humidity': 86,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10d'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 4.79, 'deg': 124, 'gust': 8.42},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.97,\n",
       "   'rain': {'3h': 1.87},\n",
       "   'sys': {'pod': 'd'},\n",
       "   'dt_txt': '2024-02-26 15:00:00'},\n",
       "  {'dt': 1708970400,\n",
       "   'main': {'temp': 7.27,\n",
       "    'feels_like': 4.65,\n",
       "    'temp_min': 7.27,\n",
       "    'temp_max': 7.27,\n",
       "    'pressure': 990,\n",
       "    'sea_level': 990,\n",
       "    'grnd_level': 985,\n",
       "    'humidity': 85,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 4, 'deg': 103, 'gust': 6.79},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.99,\n",
       "   'rain': {'3h': 0.54},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-26 18:00:00'},\n",
       "  {'dt': 1708981200,\n",
       "   'main': {'temp': 6.88,\n",
       "    'feels_like': 3.87,\n",
       "    'temp_min': 6.88,\n",
       "    'temp_max': 6.88,\n",
       "    'pressure': 994,\n",
       "    'sea_level': 994,\n",
       "    'grnd_level': 989,\n",
       "    'humidity': 86,\n",
       "    'temp_kf': 0},\n",
       "   'weather': [{'id': 500,\n",
       "     'main': 'Rain',\n",
       "     'description': 'légère pluie',\n",
       "     'icon': '10n'}],\n",
       "   'clouds': {'all': 100},\n",
       "   'wind': {'speed': 4.6, 'deg': 77, 'gust': 7.92},\n",
       "   'visibility': 10000,\n",
       "   'pop': 0.91,\n",
       "   'rain': {'3h': 0.66},\n",
       "   'sys': {'pod': 'n'},\n",
       "   'dt_txt': '2024-02-26 21:00:00'}],\n",
       " 'city': {'id': 6545270,\n",
       "  'name': 'Quartier du Palais-Royal',\n",
       "  'coord': {'lat': 48.8589, 'lon': 2.32},\n",
       "  'country': 'FR',\n",
       "  'population': 0,\n",
       "  'timezone': 3600,\n",
       "  'sunrise': 1708498176,\n",
       "  'sunset': 1708535974}}"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Prévisions météo pour les 5 prochains jours par tranche de 3 heures\n",
    "r = requests.get(\n",
    "    f'https://api.openweathermap.org/data/2.5/forecast?lat={lat_paris}&lon={lon_paris}&appid={API_KEY}&units=metric&lang=fr'\n",
    ")\n",
    "print(r.content)\n",
    "r.json()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Le résultat de la requête contient 40 éléments et non 5 parce que les prévisions sont données par tranche de 3 heures.\n",
    "\n",
    "Afin de récupérer la prévision de demain (soit dans 24 heures) nous devons sélectionner l'élément à l'index 7 :   \n",
    "--> 24 heures = 3 heures x 8 (auquel nous retirons 1 car l'index commence à 0)\n",
    "\n",
    "Voici les index qui permettent de récupérer les prévisions pour les 5 prochains jours :\n",
    "\n",
    "- Prévision dans 1 jour :  7 \n",
    "\n",
    "- Prévisions dans 2 jours : 15\n",
    "\n",
    "- Prévisions dans 3 jours : 23\n",
    "\n",
    "- Prévisions dans 4 jours : 31\n",
    "\n",
    "- Prévisions dans 5 jours : 39"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'dt': 1708981200,\n",
       " 'main': {'temp': 6.88,\n",
       "  'feels_like': 3.87,\n",
       "  'temp_min': 6.88,\n",
       "  'temp_max': 6.88,\n",
       "  'pressure': 994,\n",
       "  'sea_level': 994,\n",
       "  'grnd_level': 989,\n",
       "  'humidity': 86,\n",
       "  'temp_kf': 0},\n",
       " 'weather': [{'id': 500,\n",
       "   'main': 'Rain',\n",
       "   'description': 'légère pluie',\n",
       "   'icon': '10n'}],\n",
       " 'clouds': {'all': 100},\n",
       " 'wind': {'speed': 4.6, 'deg': 77, 'gust': 7.92},\n",
       " 'visibility': 10000,\n",
       " 'pop': 0.91,\n",
       " 'rain': {'3h': 0.66},\n",
       " 'sys': {'pod': 'n'},\n",
       " 'dt_txt': '2024-02-26 21:00:00'}"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Nous vérifions que la prévision à l'index 39 nous retourne bien la prévision dans 5 jours\n",
    "r.json()['list'][39]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Sélection et récupération des données"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Nous identifions 8 données météorologiques intéressantes pour notre projet : \n",
    "\n",
    "1. *list.main.temp* : la température\n",
    "\n",
    "2. *list.weather.main* : la description générale (nuageux, pluie, etc.)\n",
    "\n",
    "3. *list.clouds.all* : le taux de nuages\n",
    "\n",
    "4. *list.wind.speed* : la vitesse du vent\n",
    "\n",
    "5. *list.pop* : la probabilité de pleuvoir\n",
    "\n",
    "6. *list.rain.3h* : le volume de précipitations cumulées pendant les 3 dernières heures\n",
    "\n",
    "7. *list.main.humidity* : le taux d'humidité"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp = r.json()['list'][7]['main']['temp']\n",
    "weather = r.json()['list'][7]['weather'][0]['main']\n",
    "description = r.json()['list'][7]['weather'][0]['description']\n",
    "clouds = r.json()['list'][7]['clouds']['all']\n",
    "wind = r.json()['list'][7]['wind']['speed']\n",
    "pop = r.json()['list'][7]['pop']\n",
    "try:\n",
    "    rain = r.json()['list'][7]['rain']['3h']\n",
    "except: \n",
    "    print('No rain data for selected time')\n",
    "humidity = r.json()['list'][7]['main']['humidity']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Nous préparons des listes pour stocker les données récupérées\n",
    "\n",
    "temp_d1, weather_d1, clouds_d1, pop_d1, rain_d1, wind_d1, humidity_d1 = [], [], [], [], [], [], []\n",
    "temp_d2, weather_d2, clouds_d2, pop_d2, rain_d2, wind_d2, humidity_d2 = [], [], [], [], [], [], []\n",
    "temp_d3, weather_d3, clouds_d3, pop_d3, rain_d3, wind_d3, humidity_d3 = [], [], [], [], [], [], []\n",
    "temp_d4, weather_d4, clouds_d4, pop_d4, rain_d4, wind_d4, humidity_d4 = [], [], [], [], [], [], []\n",
    "temp_d5, weather_d5, clouds_d5, pop_d5, rain_d5, wind_d5, humidity_d5 = [], [], [], [], [], [], []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Nous construisons une fonction qui permet de récupérer ces données depuis l'API Openweather\n",
    "\n",
    "def extractWeatherForecast(temp, weather, clouds, wind, humidity, pop, rain, fi): # fi : forecast index\n",
    "    ''' This function collects the data from Openweather API '''\n",
    "    for lat, lon in zip(lat_list, lon_list):\n",
    "        r = requests.get(\n",
    "            f'https://api.openweathermap.org/data/2.5/forecast?lat={lat}&lon={lon}&appid={API_KEY}&units=metric&lang=fr'\n",
    "        )\n",
    "        temp.append(r.json()['list'][fi]['main']['temp'])\n",
    "        weather.append(r.json()['list'][fi]['weather'][0]['main'])\n",
    "        clouds.append(r.json()['list'][fi]['clouds']['all'])\n",
    "        wind.append(r.json()['list'][fi]['wind']['speed'])\n",
    "        humidity.append(r.json()['list'][fi]['main']['humidity'])\n",
    "        pop.append(r.json()['list'][fi]['pop'])\n",
    "        try:\n",
    "            rain.append(r.json()['list'][fi]['rain']['3h'])\n",
    "        except: \n",
    "            rain.append(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Application de la fonction\n",
    "\n",
    "extractWeatherForecast(temp_d1, weather_d1, clouds_d1, wind_d1, humidity_d1, pop_d1, rain_d1, fi=7)\n",
    "extractWeatherForecast(temp_d2, weather_d2, clouds_d2, wind_d2, humidity_d2, pop_d2, rain_d2, fi=15)\n",
    "extractWeatherForecast(temp_d3, weather_d3, clouds_d3, wind_d3, humidity_d3, pop_d3, rain_d3, fi=23)\n",
    "extractWeatherForecast(temp_d4, weather_d4, clouds_d4, wind_d4, humidity_d4, pop_d4, rain_d4, fi=31)\n",
    "extractWeatherForecast(temp_d5, weather_d5, clouds_d5, wind_d5, humidity_d5, pop_d5, rain_d5, fi=39)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[5.38, 5.78, 4.95, 6.73, 4.92, 6.48, 6.04, 6.05, 8.56, 4.53, 7.9, 7.75, 6.35, 5.88, 7.46, 9.01, 8.67, 7.28, 13.11, 13.84, 13.96, 12.02, 12.02, 10.21, 10.96, 12.29, 12.68, 10.36, 7.63, 6.21, 7.28, 7.48, 9.47, 9.23, 8.87]\n",
      "[2.99, 4.28, 2.65, 4.76, 2.52, 5.09, 2.92, 3.84, 5.18, 1.77, 5.18, 5.22, 3.96, 2.82, 3.39, 4.77, 5.3, 0.05, 9.16, 10.15, 10.31, 6.9, 6.78, 5.91, 6.84, 8.62, 9.11, 7.67, 6.18, 4.27, 5.45, 4.58, 7.5, 7.01, 5.97]\n",
      "[5.53, 6.57, 4.61, 7.54, 4.39, 5.95, 4.36, 5.09, 3.25, -0.91, 2.34, 2.3, 3.36, 3.82, 0.94, 2.86, 6.2, -0.15, 8.34, 9.17, 9.32, 5.86, 5.99, 5.64, 6.98, 8.73, 8.79, 7.13, 7.01, 4.97, 5.84, 5.44, 8.46, 8.18, 8.88]\n",
      "[7.67, 7.79, 7.9, 9.25, 8.97, 9.97, 9.06, 4.44, 6.36, 2.09, 5.07, 4.81, 9.14, 6.88, 4.19, 6.64, 7.36, 2.88, 11.09, 12.11, 12.35, 8.04, 9.35, 8.34, 9.39, 11.42, 12.67, 8.63, 6.33, 8.87, 7.58, 8.6, 11.43, 11.25, 9.5]\n",
      "[6.77, 7.2, 7.48, 7.98, 6.79, 6.88, 7.32, 7.82, 6.06, 2.69, 6.32, 6.49, 5.96, 6.02, 3.79, 5.9, 7.02, 2.05, 9.7, 10.09, 10.26, 7.38, 8.01, 7.17, 8.08, 9.73, 10.01, 8, 7.2, 4.85, 6.02, 5.74, 9.61, 9.25, 7.85]\n"
     ]
    }
   ],
   "source": [
    "# Vérification des données de température des 5 prochains jours\n",
    "\n",
    "print(temp_d1)\n",
    "print(temp_d2)\n",
    "print(temp_d3)\n",
    "print(temp_d4)\n",
    "print(temp_d5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Création dataframe Pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Nous créons un dictionnaire qui permettra de créer le dataframe\n",
    "\n",
    "city_dict = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Ajout des listes ville_id, ville, latitude et longitude à notre dictionnaire\n",
    "\n",
    "city_dict['city_id'] = [i for i in range(1,36)]\n",
    "city_dict['city'] = cities\n",
    "city_dict['lat_city'] = lat_list\n",
    "city_dict['lon_city'] = lon_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Ajout des données météorologiques dans notre dictionnaire\n",
    "\n",
    "city_dict['temp_d1'] = temp_d1\n",
    "city_dict['temp_d2'] = temp_d2\n",
    "city_dict['temp_d3'] = temp_d3\n",
    "city_dict['temp_d4'] = temp_d4\n",
    "city_dict['temp_d5'] = temp_d5\n",
    "\n",
    "city_dict['weather_d1'] = weather_d1\n",
    "city_dict['weather_d2'] = weather_d2\n",
    "city_dict['weather_d3'] = weather_d3\n",
    "city_dict['weather_d4'] = weather_d4\n",
    "city_dict['weather_d5'] = weather_d5\n",
    "\n",
    "city_dict['clouds_d1'] = clouds_d1\n",
    "city_dict['clouds_d2'] = clouds_d2\n",
    "city_dict['clouds_d3'] = clouds_d3\n",
    "city_dict['clouds_d4'] = clouds_d4\n",
    "city_dict['clouds_d5'] = clouds_d5\n",
    "\n",
    "city_dict['wind_d1'] = wind_d1\n",
    "city_dict['wind_d2'] = wind_d2\n",
    "city_dict['wind_d3'] = wind_d3\n",
    "city_dict['wind_d4'] = wind_d4\n",
    "city_dict['wind_d5'] = wind_d5\n",
    "\n",
    "city_dict['humidity_d1'] = humidity_d1\n",
    "city_dict['humidity_d2'] = humidity_d2\n",
    "city_dict['humidity_d3'] = humidity_d3\n",
    "city_dict['humidity_d4'] = humidity_d4\n",
    "city_dict['humidity_d5'] = humidity_d5\n",
    "\n",
    "city_dict['pop_d1'] = pop_d1\n",
    "city_dict['pop_d2'] = pop_d2\n",
    "city_dict['pop_d3'] = pop_d3\n",
    "city_dict['pop_d4'] = pop_d4\n",
    "city_dict['pop_d5'] = pop_d5\n",
    "\n",
    "city_dict['rain_d1'] = rain_d1\n",
    "city_dict['rain_d2'] = rain_d2\n",
    "city_dict['rain_d3'] = rain_d3\n",
    "city_dict['rain_d4'] = rain_d4\n",
    "city_dict['rain_d5'] = rain_d5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataset = pd.DataFrame().from_dict(city_dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(35, 39)"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Résultats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>city_id</th>\n",
       "      <th>city</th>\n",
       "      <th>lat_city</th>\n",
       "      <th>lon_city</th>\n",
       "      <th>temp_d1</th>\n",
       "      <th>temp_d2</th>\n",
       "      <th>temp_d3</th>\n",
       "      <th>temp_d4</th>\n",
       "      <th>temp_d5</th>\n",
       "      <th>weather_d1</th>\n",
       "      <th>weather_d2</th>\n",
       "      <th>weather_d3</th>\n",
       "      <th>weather_d4</th>\n",
       "      <th>weather_d5</th>\n",
       "      <th>clouds_d1</th>\n",
       "      <th>clouds_d2</th>\n",
       "      <th>clouds_d3</th>\n",
       "      <th>clouds_d4</th>\n",
       "      <th>clouds_d5</th>\n",
       "      <th>wind_d1</th>\n",
       "      <th>wind_d2</th>\n",
       "      <th>wind_d3</th>\n",
       "      <th>wind_d4</th>\n",
       "      <th>wind_d5</th>\n",
       "      <th>humidity_d1</th>\n",
       "      <th>humidity_d2</th>\n",
       "      <th>humidity_d3</th>\n",
       "      <th>humidity_d4</th>\n",
       "      <th>humidity_d5</th>\n",
       "      <th>pop_d1</th>\n",
       "      <th>pop_d2</th>\n",
       "      <th>pop_d3</th>\n",
       "      <th>pop_d4</th>\n",
       "      <th>pop_d5</th>\n",
       "      <th>rain_d1</th>\n",
       "      <th>rain_d2</th>\n",
       "      <th>rain_d3</th>\n",
       "      <th>rain_d4</th>\n",
       "      <th>rain_d5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Mont Saint Michel</td>\n",
       "      <td>48.635954</td>\n",
       "      <td>-1.511460</td>\n",
       "      <td>5.38</td>\n",
       "      <td>2.99</td>\n",
       "      <td>5.53</td>\n",
       "      <td>7.67</td>\n",
       "      <td>6.77</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>47</td>\n",
       "      <td>83</td>\n",
       "      <td>99</td>\n",
       "      <td>84</td>\n",
       "      <td>100</td>\n",
       "      <td>10.57</td>\n",
       "      <td>5.66</td>\n",
       "      <td>5.03</td>\n",
       "      <td>8.37</td>\n",
       "      <td>8.91</td>\n",
       "      <td>83</td>\n",
       "      <td>87</td>\n",
       "      <td>88</td>\n",
       "      <td>84</td>\n",
       "      <td>93</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.47</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.32</td>\n",
       "      <td>0.12</td>\n",
       "      <td>0.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>St Malo</td>\n",
       "      <td>48.649518</td>\n",
       "      <td>-2.026041</td>\n",
       "      <td>5.78</td>\n",
       "      <td>4.28</td>\n",
       "      <td>6.57</td>\n",
       "      <td>7.79</td>\n",
       "      <td>7.20</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>63</td>\n",
       "      <td>75</td>\n",
       "      <td>100</td>\n",
       "      <td>82</td>\n",
       "      <td>100</td>\n",
       "      <td>10.80</td>\n",
       "      <td>6.68</td>\n",
       "      <td>6.31</td>\n",
       "      <td>8.65</td>\n",
       "      <td>11.82</td>\n",
       "      <td>84</td>\n",
       "      <td>80</td>\n",
       "      <td>83</td>\n",
       "      <td>83</td>\n",
       "      <td>90</td>\n",
       "      <td>0.68</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.23</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Bayeux</td>\n",
       "      <td>49.276462</td>\n",
       "      <td>-0.702474</td>\n",
       "      <td>4.95</td>\n",
       "      <td>2.65</td>\n",
       "      <td>4.61</td>\n",
       "      <td>7.90</td>\n",
       "      <td>7.48</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>53</td>\n",
       "      <td>64</td>\n",
       "      <td>40</td>\n",
       "      <td>99</td>\n",
       "      <td>100</td>\n",
       "      <td>8.77</td>\n",
       "      <td>5.51</td>\n",
       "      <td>5.41</td>\n",
       "      <td>7.70</td>\n",
       "      <td>7.57</td>\n",
       "      <td>87</td>\n",
       "      <td>90</td>\n",
       "      <td>91</td>\n",
       "      <td>84</td>\n",
       "      <td>92</td>\n",
       "      <td>0.72</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.95</td>\n",
       "      <td>0.71</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.12</td>\n",
       "      <td>0.26</td>\n",
       "      <td>2.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Le Havre</td>\n",
       "      <td>49.493898</td>\n",
       "      <td>0.107973</td>\n",
       "      <td>6.73</td>\n",
       "      <td>4.76</td>\n",
       "      <td>7.54</td>\n",
       "      <td>9.25</td>\n",
       "      <td>7.98</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>47</td>\n",
       "      <td>82</td>\n",
       "      <td>42</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>11.59</td>\n",
       "      <td>7.87</td>\n",
       "      <td>7.39</td>\n",
       "      <td>9.38</td>\n",
       "      <td>8.88</td>\n",
       "      <td>77</td>\n",
       "      <td>80</td>\n",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>89</td>\n",
       "      <td>0.77</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.61</td>\n",
       "      <td>0.74</td>\n",
       "      <td>1.12</td>\n",
       "      <td>0.61</td>\n",
       "      <td>0.98</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Rouen</td>\n",
       "      <td>49.440459</td>\n",
       "      <td>1.093966</td>\n",
       "      <td>4.92</td>\n",
       "      <td>2.52</td>\n",
       "      <td>4.39</td>\n",
       "      <td>8.97</td>\n",
       "      <td>6.79</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>70</td>\n",
       "      <td>49</td>\n",
       "      <td>82</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>8.45</td>\n",
       "      <td>4.77</td>\n",
       "      <td>5.38</td>\n",
       "      <td>8.20</td>\n",
       "      <td>4.84</td>\n",
       "      <td>80</td>\n",
       "      <td>86</td>\n",
       "      <td>93</td>\n",
       "      <td>87</td>\n",
       "      <td>92</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.76</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.82</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.22</td>\n",
       "      <td>1.70</td>\n",
       "      <td>0.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Paris</td>\n",
       "      <td>48.858890</td>\n",
       "      <td>2.320041</td>\n",
       "      <td>6.48</td>\n",
       "      <td>5.09</td>\n",
       "      <td>5.95</td>\n",
       "      <td>9.97</td>\n",
       "      <td>6.88</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>91</td>\n",
       "      <td>78</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>7.24</td>\n",
       "      <td>4.13</td>\n",
       "      <td>4.92</td>\n",
       "      <td>8.10</td>\n",
       "      <td>4.60</td>\n",
       "      <td>70</td>\n",
       "      <td>72</td>\n",
       "      <td>81</td>\n",
       "      <td>79</td>\n",
       "      <td>86</td>\n",
       "      <td>0.92</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.94</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.25</td>\n",
       "      <td>4.93</td>\n",
       "      <td>0.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Amiens</td>\n",
       "      <td>49.894171</td>\n",
       "      <td>2.295695</td>\n",
       "      <td>6.04</td>\n",
       "      <td>2.92</td>\n",
       "      <td>4.36</td>\n",
       "      <td>9.06</td>\n",
       "      <td>7.32</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>96</td>\n",
       "      <td>50</td>\n",
       "      <td>93</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>8.57</td>\n",
       "      <td>5.67</td>\n",
       "      <td>5.25</td>\n",
       "      <td>6.58</td>\n",
       "      <td>5.03</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>92</td>\n",
       "      <td>88</td>\n",
       "      <td>92</td>\n",
       "      <td>0.92</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.72</td>\n",
       "      <td>1.07</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.29</td>\n",
       "      <td>2.04</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Lille</td>\n",
       "      <td>50.636565</td>\n",
       "      <td>3.063528</td>\n",
       "      <td>6.05</td>\n",
       "      <td>3.84</td>\n",
       "      <td>5.09</td>\n",
       "      <td>4.44</td>\n",
       "      <td>7.82</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>96</td>\n",
       "      <td>73</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>8.12</td>\n",
       "      <td>5.92</td>\n",
       "      <td>6.35</td>\n",
       "      <td>7.96</td>\n",
       "      <td>6.31</td>\n",
       "      <td>71</td>\n",
       "      <td>78</td>\n",
       "      <td>85</td>\n",
       "      <td>92</td>\n",
       "      <td>89</td>\n",
       "      <td>0.46</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.51</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.32</td>\n",
       "      <td>6.68</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Strasbourg</td>\n",
       "      <td>48.584614</td>\n",
       "      <td>7.750713</td>\n",
       "      <td>8.56</td>\n",
       "      <td>5.18</td>\n",
       "      <td>3.25</td>\n",
       "      <td>6.36</td>\n",
       "      <td>6.06</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clear</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>84</td>\n",
       "      <td>3</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>7.51</td>\n",
       "      <td>5.39</td>\n",
       "      <td>2.86</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.74</td>\n",
       "      <td>71</td>\n",
       "      <td>79</td>\n",
       "      <td>82</td>\n",
       "      <td>81</td>\n",
       "      <td>91</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.81</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1.54</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Chateau du Haut Koenigsbourg</td>\n",
       "      <td>48.249523</td>\n",
       "      <td>7.345492</td>\n",
       "      <td>4.53</td>\n",
       "      <td>1.77</td>\n",
       "      <td>-0.91</td>\n",
       "      <td>2.09</td>\n",
       "      <td>2.69</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clear</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>88</td>\n",
       "      <td>7</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>7.08</td>\n",
       "      <td>2.90</td>\n",
       "      <td>1.85</td>\n",
       "      <td>3.72</td>\n",
       "      <td>1.05</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>88</td>\n",
       "      <td>91</td>\n",
       "      <td>91</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.98</td>\n",
       "      <td>0.19</td>\n",
       "      <td>2.98</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Colmar</td>\n",
       "      <td>48.077752</td>\n",
       "      <td>7.357964</td>\n",
       "      <td>7.90</td>\n",
       "      <td>5.18</td>\n",
       "      <td>2.34</td>\n",
       "      <td>5.07</td>\n",
       "      <td>6.32</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clear</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>94</td>\n",
       "      <td>10</td>\n",
       "      <td>100</td>\n",
       "      <td>89</td>\n",
       "      <td>7.35</td>\n",
       "      <td>4.13</td>\n",
       "      <td>2.12</td>\n",
       "      <td>3.85</td>\n",
       "      <td>1.79</td>\n",
       "      <td>76</td>\n",
       "      <td>81</td>\n",
       "      <td>88</td>\n",
       "      <td>92</td>\n",
       "      <td>88</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.98</td>\n",
       "      <td>0.39</td>\n",
       "      <td>3.19</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.44</td>\n",
       "      <td>0.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Eguisheim</td>\n",
       "      <td>48.044797</td>\n",
       "      <td>7.307962</td>\n",
       "      <td>7.75</td>\n",
       "      <td>5.22</td>\n",
       "      <td>2.30</td>\n",
       "      <td>4.81</td>\n",
       "      <td>6.49</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>97</td>\n",
       "      <td>11</td>\n",
       "      <td>100</td>\n",
       "      <td>89</td>\n",
       "      <td>7.39</td>\n",
       "      <td>3.58</td>\n",
       "      <td>2.05</td>\n",
       "      <td>3.50</td>\n",
       "      <td>1.86</td>\n",
       "      <td>77</td>\n",
       "      <td>81</td>\n",
       "      <td>89</td>\n",
       "      <td>94</td>\n",
       "      <td>88</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.21</td>\n",
       "      <td>3.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.06</td>\n",
       "      <td>0.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Besancon</td>\n",
       "      <td>47.238022</td>\n",
       "      <td>6.024362</td>\n",
       "      <td>6.35</td>\n",
       "      <td>3.96</td>\n",
       "      <td>3.36</td>\n",
       "      <td>9.14</td>\n",
       "      <td>5.96</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>72</td>\n",
       "      <td>64</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>6.71</td>\n",
       "      <td>4.76</td>\n",
       "      <td>3.00</td>\n",
       "      <td>8.72</td>\n",
       "      <td>5.37</td>\n",
       "      <td>85</td>\n",
       "      <td>87</td>\n",
       "      <td>83</td>\n",
       "      <td>76</td>\n",
       "      <td>88</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.63</td>\n",
       "      <td>5.07</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.68</td>\n",
       "      <td>0.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Dijon</td>\n",
       "      <td>47.321581</td>\n",
       "      <td>5.041470</td>\n",
       "      <td>5.88</td>\n",
       "      <td>2.82</td>\n",
       "      <td>3.82</td>\n",
       "      <td>6.88</td>\n",
       "      <td>6.02</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>98</td>\n",
       "      <td>96</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>7.09</td>\n",
       "      <td>4.10</td>\n",
       "      <td>4.72</td>\n",
       "      <td>11.91</td>\n",
       "      <td>7.44</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>86</td>\n",
       "      <td>90</td>\n",
       "      <td>93</td>\n",
       "      <td>0.69</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.86</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.75</td>\n",
       "      <td>1.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Annecy</td>\n",
       "      <td>45.899235</td>\n",
       "      <td>6.128885</td>\n",
       "      <td>7.46</td>\n",
       "      <td>3.39</td>\n",
       "      <td>0.94</td>\n",
       "      <td>4.19</td>\n",
       "      <td>3.79</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>67</td>\n",
       "      <td>100</td>\n",
       "      <td>98</td>\n",
       "      <td>3.34</td>\n",
       "      <td>2.44</td>\n",
       "      <td>1.84</td>\n",
       "      <td>2.89</td>\n",
       "      <td>2.02</td>\n",
       "      <td>98</td>\n",
       "      <td>97</td>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>96</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.85</td>\n",
       "      <td>7.89</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.69</td>\n",
       "      <td>1.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Grenoble</td>\n",
       "      <td>45.187560</td>\n",
       "      <td>5.735782</td>\n",
       "      <td>9.01</td>\n",
       "      <td>4.77</td>\n",
       "      <td>2.86</td>\n",
       "      <td>6.64</td>\n",
       "      <td>5.90</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Snow</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>97</td>\n",
       "      <td>26</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>2.47</td>\n",
       "      <td>1.99</td>\n",
       "      <td>1.83</td>\n",
       "      <td>2.86</td>\n",
       "      <td>2.16</td>\n",
       "      <td>96</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>93</td>\n",
       "      <td>97</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.71</td>\n",
       "      <td>1.98</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.25</td>\n",
       "      <td>0.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Lyon</td>\n",
       "      <td>45.757814</td>\n",
       "      <td>4.832011</td>\n",
       "      <td>8.67</td>\n",
       "      <td>5.30</td>\n",
       "      <td>6.20</td>\n",
       "      <td>7.36</td>\n",
       "      <td>7.02</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>4.47</td>\n",
       "      <td>3.42</td>\n",
       "      <td>3.13</td>\n",
       "      <td>6.78</td>\n",
       "      <td>5.68</td>\n",
       "      <td>69</td>\n",
       "      <td>74</td>\n",
       "      <td>62</td>\n",
       "      <td>84</td>\n",
       "      <td>79</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.56</td>\n",
       "      <td>7.37</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Gorges du Verdon</td>\n",
       "      <td>43.749656</td>\n",
       "      <td>6.328562</td>\n",
       "      <td>7.28</td>\n",
       "      <td>0.05</td>\n",
       "      <td>-0.15</td>\n",
       "      <td>2.88</td>\n",
       "      <td>2.05</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clear</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>48</td>\n",
       "      <td>6</td>\n",
       "      <td>100</td>\n",
       "      <td>99</td>\n",
       "      <td>2.17</td>\n",
       "      <td>2.13</td>\n",
       "      <td>2.15</td>\n",
       "      <td>2.67</td>\n",
       "      <td>1.52</td>\n",
       "      <td>97</td>\n",
       "      <td>94</td>\n",
       "      <td>84</td>\n",
       "      <td>96</td>\n",
       "      <td>95</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.31</td>\n",
       "      <td>0.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>Bormes les Mimosas</td>\n",
       "      <td>43.150697</td>\n",
       "      <td>6.341928</td>\n",
       "      <td>13.11</td>\n",
       "      <td>9.16</td>\n",
       "      <td>8.34</td>\n",
       "      <td>11.09</td>\n",
       "      <td>9.70</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clear</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>100</td>\n",
       "      <td>76</td>\n",
       "      <td>5.36</td>\n",
       "      <td>7.73</td>\n",
       "      <td>6.30</td>\n",
       "      <td>3.72</td>\n",
       "      <td>3.74</td>\n",
       "      <td>92</td>\n",
       "      <td>63</td>\n",
       "      <td>58</td>\n",
       "      <td>91</td>\n",
       "      <td>75</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.98</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.69</td>\n",
       "      <td>0.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Cassis</td>\n",
       "      <td>43.214036</td>\n",
       "      <td>5.539632</td>\n",
       "      <td>13.84</td>\n",
       "      <td>10.15</td>\n",
       "      <td>9.17</td>\n",
       "      <td>12.11</td>\n",
       "      <td>10.09</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clear</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>2.17</td>\n",
       "      <td>7.75</td>\n",
       "      <td>6.91</td>\n",
       "      <td>5.21</td>\n",
       "      <td>5.60</td>\n",
       "      <td>88</td>\n",
       "      <td>62</td>\n",
       "      <td>65</td>\n",
       "      <td>90</td>\n",
       "      <td>71</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.92</td>\n",
       "      <td>0.32</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Marseille</td>\n",
       "      <td>43.296174</td>\n",
       "      <td>5.369953</td>\n",
       "      <td>13.96</td>\n",
       "      <td>10.31</td>\n",
       "      <td>9.32</td>\n",
       "      <td>12.35</td>\n",
       "      <td>10.26</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clear</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>100</td>\n",
       "      <td>99</td>\n",
       "      <td>2.05</td>\n",
       "      <td>7.60</td>\n",
       "      <td>6.89</td>\n",
       "      <td>6.32</td>\n",
       "      <td>5.35</td>\n",
       "      <td>87</td>\n",
       "      <td>60</td>\n",
       "      <td>64</td>\n",
       "      <td>87</td>\n",
       "      <td>68</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.83</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Aix en Provence</td>\n",
       "      <td>43.529842</td>\n",
       "      <td>5.447474</td>\n",
       "      <td>12.02</td>\n",
       "      <td>6.90</td>\n",
       "      <td>5.86</td>\n",
       "      <td>8.04</td>\n",
       "      <td>7.38</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clear</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>20</td>\n",
       "      <td>4</td>\n",
       "      <td>100</td>\n",
       "      <td>97</td>\n",
       "      <td>0.62</td>\n",
       "      <td>4.28</td>\n",
       "      <td>3.35</td>\n",
       "      <td>4.78</td>\n",
       "      <td>3.09</td>\n",
       "      <td>90</td>\n",
       "      <td>67</td>\n",
       "      <td>69</td>\n",
       "      <td>92</td>\n",
       "      <td>77</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Avignon</td>\n",
       "      <td>43.949249</td>\n",
       "      <td>4.805901</td>\n",
       "      <td>12.02</td>\n",
       "      <td>6.78</td>\n",
       "      <td>5.99</td>\n",
       "      <td>9.35</td>\n",
       "      <td>8.01</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>93</td>\n",
       "      <td>56</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>6.18</td>\n",
       "      <td>3.92</td>\n",
       "      <td>1.55</td>\n",
       "      <td>6.55</td>\n",
       "      <td>3.60</td>\n",
       "      <td>84</td>\n",
       "      <td>69</td>\n",
       "      <td>70</td>\n",
       "      <td>83</td>\n",
       "      <td>73</td>\n",
       "      <td>0.89</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.68</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1.59</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>Uzes</td>\n",
       "      <td>44.012128</td>\n",
       "      <td>4.419672</td>\n",
       "      <td>10.21</td>\n",
       "      <td>5.91</td>\n",
       "      <td>5.64</td>\n",
       "      <td>8.34</td>\n",
       "      <td>7.17</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>71</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>6.78</td>\n",
       "      <td>4.10</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.68</td>\n",
       "      <td>4.54</td>\n",
       "      <td>65</td>\n",
       "      <td>71</td>\n",
       "      <td>71</td>\n",
       "      <td>89</td>\n",
       "      <td>74</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1.79</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Nimes</td>\n",
       "      <td>43.837425</td>\n",
       "      <td>4.360069</td>\n",
       "      <td>10.96</td>\n",
       "      <td>6.84</td>\n",
       "      <td>6.98</td>\n",
       "      <td>9.39</td>\n",
       "      <td>8.08</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>99</td>\n",
       "      <td>79</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>7.62</td>\n",
       "      <td>4.78</td>\n",
       "      <td>3.32</td>\n",
       "      <td>4.65</td>\n",
       "      <td>5.30</td>\n",
       "      <td>62</td>\n",
       "      <td>67</td>\n",
       "      <td>65</td>\n",
       "      <td>91</td>\n",
       "      <td>70</td>\n",
       "      <td>0.95</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.48</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Aigues Mortes</td>\n",
       "      <td>43.566152</td>\n",
       "      <td>4.191540</td>\n",
       "      <td>12.29</td>\n",
       "      <td>8.62</td>\n",
       "      <td>8.73</td>\n",
       "      <td>11.42</td>\n",
       "      <td>9.73</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>78</td>\n",
       "      <td>78</td>\n",
       "      <td>100</td>\n",
       "      <td>99</td>\n",
       "      <td>9.48</td>\n",
       "      <td>5.41</td>\n",
       "      <td>4.75</td>\n",
       "      <td>4.92</td>\n",
       "      <td>5.22</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>64</td>\n",
       "      <td>87</td>\n",
       "      <td>63</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Saintes Maries de la mer</td>\n",
       "      <td>43.451592</td>\n",
       "      <td>4.427720</td>\n",
       "      <td>12.68</td>\n",
       "      <td>9.11</td>\n",
       "      <td>8.79</td>\n",
       "      <td>12.67</td>\n",
       "      <td>10.01</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>42</td>\n",
       "      <td>66</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>11.18</td>\n",
       "      <td>6.40</td>\n",
       "      <td>4.91</td>\n",
       "      <td>6.79</td>\n",
       "      <td>5.82</td>\n",
       "      <td>81</td>\n",
       "      <td>63</td>\n",
       "      <td>64</td>\n",
       "      <td>84</td>\n",
       "      <td>63</td>\n",
       "      <td>0.83</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>Collioure</td>\n",
       "      <td>42.525050</td>\n",
       "      <td>3.083155</td>\n",
       "      <td>10.36</td>\n",
       "      <td>7.67</td>\n",
       "      <td>7.13</td>\n",
       "      <td>8.63</td>\n",
       "      <td>8.00</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>75</td>\n",
       "      <td>89</td>\n",
       "      <td>29</td>\n",
       "      <td>56</td>\n",
       "      <td>100</td>\n",
       "      <td>10.02</td>\n",
       "      <td>2.20</td>\n",
       "      <td>2.57</td>\n",
       "      <td>1.76</td>\n",
       "      <td>2.68</td>\n",
       "      <td>71</td>\n",
       "      <td>79</td>\n",
       "      <td>76</td>\n",
       "      <td>83</td>\n",
       "      <td>78</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.44</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.26</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Carcassonne</td>\n",
       "      <td>43.213036</td>\n",
       "      <td>2.349107</td>\n",
       "      <td>7.63</td>\n",
       "      <td>6.18</td>\n",
       "      <td>7.01</td>\n",
       "      <td>6.33</td>\n",
       "      <td>7.20</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>99</td>\n",
       "      <td>88</td>\n",
       "      <td>97</td>\n",
       "      <td>82</td>\n",
       "      <td>92</td>\n",
       "      <td>9.31</td>\n",
       "      <td>5.15</td>\n",
       "      <td>6.04</td>\n",
       "      <td>3.88</td>\n",
       "      <td>8.38</td>\n",
       "      <td>88</td>\n",
       "      <td>81</td>\n",
       "      <td>82</td>\n",
       "      <td>92</td>\n",
       "      <td>69</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.58</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.26</td>\n",
       "      <td>2.78</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>Ariege</td>\n",
       "      <td>42.992743</td>\n",
       "      <td>1.612497</td>\n",
       "      <td>6.21</td>\n",
       "      <td>4.27</td>\n",
       "      <td>4.97</td>\n",
       "      <td>8.87</td>\n",
       "      <td>4.85</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>97</td>\n",
       "      <td>100</td>\n",
       "      <td>87</td>\n",
       "      <td>99</td>\n",
       "      <td>3.15</td>\n",
       "      <td>2.11</td>\n",
       "      <td>2.34</td>\n",
       "      <td>2.12</td>\n",
       "      <td>3.99</td>\n",
       "      <td>96</td>\n",
       "      <td>88</td>\n",
       "      <td>90</td>\n",
       "      <td>82</td>\n",
       "      <td>74</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.58</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.34</td>\n",
       "      <td>4.19</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>Toulouse</td>\n",
       "      <td>43.604462</td>\n",
       "      <td>1.444247</td>\n",
       "      <td>7.28</td>\n",
       "      <td>5.45</td>\n",
       "      <td>5.84</td>\n",
       "      <td>7.58</td>\n",
       "      <td>6.02</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>97</td>\n",
       "      <td>100</td>\n",
       "      <td>6.11</td>\n",
       "      <td>6.69</td>\n",
       "      <td>5.96</td>\n",
       "      <td>2.20</td>\n",
       "      <td>7.27</td>\n",
       "      <td>82</td>\n",
       "      <td>85</td>\n",
       "      <td>88</td>\n",
       "      <td>91</td>\n",
       "      <td>80</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.76</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.82</td>\n",
       "      <td>0.38</td>\n",
       "      <td>2.99</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>Montauban</td>\n",
       "      <td>44.017584</td>\n",
       "      <td>1.354999</td>\n",
       "      <td>7.48</td>\n",
       "      <td>4.58</td>\n",
       "      <td>5.44</td>\n",
       "      <td>8.60</td>\n",
       "      <td>5.74</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>98</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>6.43</td>\n",
       "      <td>5.76</td>\n",
       "      <td>5.32</td>\n",
       "      <td>4.45</td>\n",
       "      <td>6.74</td>\n",
       "      <td>81</td>\n",
       "      <td>90</td>\n",
       "      <td>93</td>\n",
       "      <td>93</td>\n",
       "      <td>90</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.78</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.61</td>\n",
       "      <td>0.31</td>\n",
       "      <td>2.08</td>\n",
       "      <td>0.67</td>\n",
       "      <td>3.70</td>\n",
       "      <td>1.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>Biarritz</td>\n",
       "      <td>43.483252</td>\n",
       "      <td>-1.559278</td>\n",
       "      <td>9.47</td>\n",
       "      <td>7.50</td>\n",
       "      <td>8.46</td>\n",
       "      <td>11.43</td>\n",
       "      <td>9.61</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>99</td>\n",
       "      <td>7.17</td>\n",
       "      <td>6.91</td>\n",
       "      <td>5.59</td>\n",
       "      <td>12.26</td>\n",
       "      <td>7.93</td>\n",
       "      <td>70</td>\n",
       "      <td>84</td>\n",
       "      <td>86</td>\n",
       "      <td>75</td>\n",
       "      <td>67</td>\n",
       "      <td>0.95</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.82</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.62</td>\n",
       "      <td>1.01</td>\n",
       "      <td>7.06</td>\n",
       "      <td>2.14</td>\n",
       "      <td>2.10</td>\n",
       "      <td>1.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>Bayonne</td>\n",
       "      <td>43.494514</td>\n",
       "      <td>-1.473666</td>\n",
       "      <td>9.23</td>\n",
       "      <td>7.01</td>\n",
       "      <td>8.18</td>\n",
       "      <td>11.25</td>\n",
       "      <td>9.25</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>98</td>\n",
       "      <td>6.25</td>\n",
       "      <td>5.61</td>\n",
       "      <td>4.95</td>\n",
       "      <td>11.21</td>\n",
       "      <td>6.79</td>\n",
       "      <td>72</td>\n",
       "      <td>87</td>\n",
       "      <td>88</td>\n",
       "      <td>75</td>\n",
       "      <td>68</td>\n",
       "      <td>0.96</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.77</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.03</td>\n",
       "      <td>7.58</td>\n",
       "      <td>2.37</td>\n",
       "      <td>2.28</td>\n",
       "      <td>1.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>La Rochelle</td>\n",
       "      <td>46.159113</td>\n",
       "      <td>-1.152043</td>\n",
       "      <td>8.87</td>\n",
       "      <td>5.97</td>\n",
       "      <td>8.88</td>\n",
       "      <td>9.50</td>\n",
       "      <td>7.85</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>17</td>\n",
       "      <td>99</td>\n",
       "      <td>100</td>\n",
       "      <td>64</td>\n",
       "      <td>96</td>\n",
       "      <td>11.11</td>\n",
       "      <td>6.96</td>\n",
       "      <td>5.28</td>\n",
       "      <td>17.61</td>\n",
       "      <td>11.15</td>\n",
       "      <td>70</td>\n",
       "      <td>81</td>\n",
       "      <td>76</td>\n",
       "      <td>80</td>\n",
       "      <td>71</td>\n",
       "      <td>0.86</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.70</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.99</td>\n",
       "      <td>1.99</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    city_id                          city   lat_city  lon_city  temp_d1  \\\n",
       "0         1             Mont Saint Michel  48.635954 -1.511460     5.38   \n",
       "1         2                       St Malo  48.649518 -2.026041     5.78   \n",
       "2         3                        Bayeux  49.276462 -0.702474     4.95   \n",
       "3         4                      Le Havre  49.493898  0.107973     6.73   \n",
       "4         5                         Rouen  49.440459  1.093966     4.92   \n",
       "5         6                         Paris  48.858890  2.320041     6.48   \n",
       "6         7                        Amiens  49.894171  2.295695     6.04   \n",
       "7         8                         Lille  50.636565  3.063528     6.05   \n",
       "8         9                    Strasbourg  48.584614  7.750713     8.56   \n",
       "9        10  Chateau du Haut Koenigsbourg  48.249523  7.345492     4.53   \n",
       "10       11                        Colmar  48.077752  7.357964     7.90   \n",
       "11       12                     Eguisheim  48.044797  7.307962     7.75   \n",
       "12       13                      Besancon  47.238022  6.024362     6.35   \n",
       "13       14                         Dijon  47.321581  5.041470     5.88   \n",
       "14       15                        Annecy  45.899235  6.128885     7.46   \n",
       "15       16                      Grenoble  45.187560  5.735782     9.01   \n",
       "16       17                          Lyon  45.757814  4.832011     8.67   \n",
       "17       18              Gorges du Verdon  43.749656  6.328562     7.28   \n",
       "18       19            Bormes les Mimosas  43.150697  6.341928    13.11   \n",
       "19       20                        Cassis  43.214036  5.539632    13.84   \n",
       "20       21                     Marseille  43.296174  5.369953    13.96   \n",
       "21       22               Aix en Provence  43.529842  5.447474    12.02   \n",
       "22       23                       Avignon  43.949249  4.805901    12.02   \n",
       "23       24                          Uzes  44.012128  4.419672    10.21   \n",
       "24       25                         Nimes  43.837425  4.360069    10.96   \n",
       "25       26                 Aigues Mortes  43.566152  4.191540    12.29   \n",
       "26       27      Saintes Maries de la mer  43.451592  4.427720    12.68   \n",
       "27       28                     Collioure  42.525050  3.083155    10.36   \n",
       "28       29                   Carcassonne  43.213036  2.349107     7.63   \n",
       "29       30                        Ariege  42.992743  1.612497     6.21   \n",
       "30       31                      Toulouse  43.604462  1.444247     7.28   \n",
       "31       32                     Montauban  44.017584  1.354999     7.48   \n",
       "32       33                      Biarritz  43.483252 -1.559278     9.47   \n",
       "33       34                       Bayonne  43.494514 -1.473666     9.23   \n",
       "34       35                   La Rochelle  46.159113 -1.152043     8.87   \n",
       "\n",
       "    temp_d2  temp_d3  temp_d4  temp_d5 weather_d1 weather_d2 weather_d3  \\\n",
       "0      2.99     5.53     7.67     6.77       Rain       Rain       Rain   \n",
       "1      4.28     6.57     7.79     7.20       Rain       Rain       Rain   \n",
       "2      2.65     4.61     7.90     7.48       Rain       Rain       Rain   \n",
       "3      4.76     7.54     9.25     7.98       Rain       Rain       Rain   \n",
       "4      2.52     4.39     8.97     6.79       Rain     Clouds       Rain   \n",
       "5      5.09     5.95     9.97     6.88       Rain     Clouds       Rain   \n",
       "6      2.92     4.36     9.06     7.32       Rain     Clouds       Rain   \n",
       "7      3.84     5.09     4.44     7.82       Rain       Rain       Rain   \n",
       "8      5.18     3.25     6.36     6.06       Rain     Clouds      Clear   \n",
       "9      1.77    -0.91     2.09     2.69       Rain     Clouds      Clear   \n",
       "10     5.18     2.34     5.07     6.32       Rain     Clouds      Clear   \n",
       "11     5.22     2.30     4.81     6.49       Rain     Clouds     Clouds   \n",
       "12     3.96     3.36     9.14     5.96       Rain       Rain     Clouds   \n",
       "13     2.82     3.82     6.88     6.02       Rain     Clouds     Clouds   \n",
       "14     3.39     0.94     4.19     3.79       Rain       Snow     Clouds   \n",
       "15     4.77     2.86     6.64     5.90       Rain       Snow     Clouds   \n",
       "16     5.30     6.20     7.36     7.02       Rain     Clouds     Clouds   \n",
       "17     0.05    -0.15     2.88     2.05       Rain     Clouds      Clear   \n",
       "18     9.16     8.34    11.09     9.70       Rain     Clouds      Clear   \n",
       "19    10.15     9.17    12.11    10.09       Rain     Clouds      Clear   \n",
       "20    10.31     9.32    12.35    10.26       Rain     Clouds      Clear   \n",
       "21     6.90     5.86     8.04     7.38       Rain     Clouds      Clear   \n",
       "22     6.78     5.99     9.35     8.01       Rain     Clouds     Clouds   \n",
       "23     5.91     5.64     8.34     7.17       Rain     Clouds     Clouds   \n",
       "24     6.84     6.98     9.39     8.08       Rain     Clouds     Clouds   \n",
       "25     8.62     8.73    11.42     9.73       Rain     Clouds     Clouds   \n",
       "26     9.11     8.79    12.67    10.01       Rain     Clouds     Clouds   \n",
       "27     7.67     7.13     8.63     8.00     Clouds       Rain     Clouds   \n",
       "28     6.18     7.01     6.33     7.20       Rain       Rain       Rain   \n",
       "29     4.27     4.97     8.87     4.85       Rain       Rain       Rain   \n",
       "30     5.45     5.84     7.58     6.02       Rain       Rain       Rain   \n",
       "31     4.58     5.44     8.60     5.74       Rain       Rain       Rain   \n",
       "32     7.50     8.46    11.43     9.61       Rain       Rain       Rain   \n",
       "33     7.01     8.18    11.25     9.25       Rain       Rain       Rain   \n",
       "34     5.97     8.88     9.50     7.85       Rain       Rain       Rain   \n",
       "\n",
       "   weather_d4 weather_d5  clouds_d1  clouds_d2  clouds_d3  clouds_d4  \\\n",
       "0        Rain       Rain         47         83         99         84   \n",
       "1      Clouds       Rain         63         75        100         82   \n",
       "2        Rain       Rain         53         64         40         99   \n",
       "3        Rain       Rain         47         82         42        100   \n",
       "4        Rain       Rain         70         49         82        100   \n",
       "5        Rain       Rain        100         91         78        100   \n",
       "6        Rain       Rain         96         50         93        100   \n",
       "7        Rain       Rain         96         73        100        100   \n",
       "8        Rain     Clouds        100         84          3        100   \n",
       "9        Rain     Clouds        100         88          7        100   \n",
       "10       Rain       Rain        100         94         10        100   \n",
       "11       Rain       Rain        100         97         11        100   \n",
       "12       Rain       Rain        100         72         64        100   \n",
       "13       Rain       Rain        100         98         96        100   \n",
       "14       Rain       Rain        100        100         67        100   \n",
       "15       Rain       Rain        100         97         26        100   \n",
       "16       Rain       Rain        100        100        100        100   \n",
       "17       Rain       Rain        100         48          6        100   \n",
       "18       Rain       Rain        100         40          2        100   \n",
       "19       Rain       Rain        100         23          1        100   \n",
       "20       Rain     Clouds        100         15          1        100   \n",
       "21       Rain     Clouds        100         20          4        100   \n",
       "22       Rain     Clouds        100         93         56        100   \n",
       "23       Rain     Clouds        100        100         71        100   \n",
       "24     Clouds     Clouds        100         99         79        100   \n",
       "25     Clouds     Clouds        100         78         78        100   \n",
       "26     Clouds     Clouds        100         42         66        100   \n",
       "27     Clouds       Rain         75         89         29         56   \n",
       "28     Clouds     Clouds         99         88         97         82   \n",
       "29       Rain     Clouds        100         97        100         87   \n",
       "30       Rain     Clouds        100        100        100         97   \n",
       "31       Rain       Rain        100        100         98        100   \n",
       "32       Rain       Rain        100        100        100        100   \n",
       "33       Rain       Rain        100        100        100        100   \n",
       "34       Rain       Rain         17         99        100         64   \n",
       "\n",
       "    clouds_d5  wind_d1  wind_d2  wind_d3  wind_d4  wind_d5  humidity_d1  \\\n",
       "0         100    10.57     5.66     5.03     8.37     8.91           83   \n",
       "1         100    10.80     6.68     6.31     8.65    11.82           84   \n",
       "2         100     8.77     5.51     5.41     7.70     7.57           87   \n",
       "3         100    11.59     7.87     7.39     9.38     8.88           77   \n",
       "4         100     8.45     4.77     5.38     8.20     4.84           80   \n",
       "5         100     7.24     4.13     4.92     8.10     4.60           70   \n",
       "6         100     8.57     5.67     5.25     6.58     5.03           78   \n",
       "7         100     8.12     5.92     6.35     7.96     6.31           71   \n",
       "8         100     7.51     5.39     2.86     4.22     0.74           71   \n",
       "9         100     7.08     2.90     1.85     3.72     1.05           78   \n",
       "10         89     7.35     4.13     2.12     3.85     1.79           76   \n",
       "11         89     7.39     3.58     2.05     3.50     1.86           77   \n",
       "12        100     6.71     4.76     3.00     8.72     5.37           85   \n",
       "13        100     7.09     4.10     4.72    11.91     7.44           84   \n",
       "14         98     3.34     2.44     1.84     2.89     2.02           98   \n",
       "15        100     2.47     1.99     1.83     2.86     2.16           96   \n",
       "16        100     4.47     3.42     3.13     6.78     5.68           69   \n",
       "17         99     2.17     2.13     2.15     2.67     1.52           97   \n",
       "18         76     5.36     7.73     6.30     3.72     3.74           92   \n",
       "19        100     2.17     7.75     6.91     5.21     5.60           88   \n",
       "20         99     2.05     7.60     6.89     6.32     5.35           87   \n",
       "21         97     0.62     4.28     3.35     4.78     3.09           90   \n",
       "22        100     6.18     3.92     1.55     6.55     3.60           84   \n",
       "23        100     6.78     4.10     3.00     4.68     4.54           65   \n",
       "24        100     7.62     4.78     3.32     4.65     5.30           62   \n",
       "25         99     9.48     5.41     4.75     4.92     5.22           63   \n",
       "26        100    11.18     6.40     4.91     6.79     5.82           81   \n",
       "27        100    10.02     2.20     2.57     1.76     2.68           71   \n",
       "28         92     9.31     5.15     6.04     3.88     8.38           88   \n",
       "29         99     3.15     2.11     2.34     2.12     3.99           96   \n",
       "30        100     6.11     6.69     5.96     2.20     7.27           82   \n",
       "31        100     6.43     5.76     5.32     4.45     6.74           81   \n",
       "32         99     7.17     6.91     5.59    12.26     7.93           70   \n",
       "33         98     6.25     5.61     4.95    11.21     6.79           72   \n",
       "34         96    11.11     6.96     5.28    17.61    11.15           70   \n",
       "\n",
       "    humidity_d2  humidity_d3  humidity_d4  humidity_d5  pop_d1  pop_d2  \\\n",
       "0            87           88           84           93    0.59    0.47   \n",
       "1            80           83           83           90    0.68    0.48   \n",
       "2            90           91           84           92    0.72    0.63   \n",
       "3            80           82           82           89    0.77    0.54   \n",
       "4            86           93           87           92    0.93    0.18   \n",
       "5            72           81           79           86    0.92    0.00   \n",
       "6            84           92           88           92    0.92    0.07   \n",
       "7            78           85           92           89    0.46    0.29   \n",
       "8            79           82           81           91    1.00    0.21   \n",
       "9            84           88           91           91    1.00    0.37   \n",
       "10           81           88           92           88    1.00    0.42   \n",
       "11           81           89           94           88    1.00    0.43   \n",
       "12           87           83           76           88    1.00    0.38   \n",
       "13           85           86           90           93    0.69    0.02   \n",
       "14           97           92           95           96    1.00    0.99   \n",
       "15           88           88           93           97    1.00    0.96   \n",
       "16           74           62           84           79    1.00    0.34   \n",
       "17           94           84           96           95    0.85    0.00   \n",
       "18           63           58           91           75    0.51    0.00   \n",
       "19           62           65           90           71    0.36    0.00   \n",
       "20           60           64           87           68    0.41    0.00   \n",
       "21           67           69           92           77    0.56    0.00   \n",
       "22           69           70           83           73    0.89    0.00   \n",
       "23           71           71           89           74    1.00    0.00   \n",
       "24           67           65           91           70    0.95    0.00   \n",
       "25           63           64           87           63    0.90    0.00   \n",
       "26           63           64           84           63    0.83    0.00   \n",
       "27           79           76           83           78    0.30    0.34   \n",
       "28           81           82           92           69    0.93    0.45   \n",
       "29           88           90           82           74    1.00    0.60   \n",
       "30           85           88           91           80    0.91    0.76   \n",
       "31           90           93           93           90    0.87    0.91   \n",
       "32           84           86           75           67    0.95    1.00   \n",
       "33           87           88           75           68    0.96    1.00   \n",
       "34           81           76           80           71    0.86    0.99   \n",
       "\n",
       "    pop_d3  pop_d4  pop_d5  rain_d1  rain_d2  rain_d3  rain_d4  rain_d5  \n",
       "0     0.28    0.39    0.91     0.39     0.57     0.32     0.12     0.83  \n",
       "1     0.23    0.35    0.99     0.37     0.29     0.18     0.00     1.78  \n",
       "2     0.33    0.45    0.95     0.71     0.34     0.12     0.26     2.73  \n",
       "3     0.57    0.61    0.74     1.12     0.61     0.98     0.53     0.79  \n",
       "4     0.40    0.76    0.37     0.82     0.00     0.22     1.70     0.21  \n",
       "5     0.55    0.94    0.91     0.50     0.00     0.25     4.93     0.66  \n",
       "6     0.41    0.99    0.72     1.07     0.00     0.29     2.04     0.36  \n",
       "7     0.51    1.00    0.75     0.15     0.13     0.32     6.68     0.40  \n",
       "8     0.00    0.81    0.03     1.54     0.00     0.00     0.85     0.00  \n",
       "9     0.00    0.98    0.19     2.98     0.00     0.00     1.32     0.00  \n",
       "10    0.00    0.98    0.39     3.19     0.00     0.00     2.44     0.16  \n",
       "11    0.00    0.99    0.21     3.63     0.00     0.00     3.06     0.24  \n",
       "12    0.00    1.00    0.63     5.07     0.16     0.00     2.68     0.18  \n",
       "13    0.00    1.00    0.86     0.24     0.00     0.00     1.75     1.08  \n",
       "14    0.00    1.00    0.85     7.89     0.00     0.00     1.69     1.18  \n",
       "15    0.00    1.00    0.71     1.98     0.00     0.00     2.25     0.14  \n",
       "16    0.00    0.84    0.56     7.37     0.00     0.00     0.49     0.46  \n",
       "17    0.00    1.00    0.36     0.69     0.00     0.00     1.31     0.21  \n",
       "18    0.00    0.98    0.45     0.49     0.00     0.00     1.69     0.25  \n",
       "19    0.00    0.92    0.32     0.34     0.00     0.00     1.15     0.25  \n",
       "20    0.00    0.83    0.22     0.34     0.00     0.00     0.91     0.00  \n",
       "21    0.00    0.93    0.17     0.38     0.00     0.00     0.50     0.00  \n",
       "22    0.00    0.68    0.04     1.59     0.00     0.00     0.37     0.00  \n",
       "23    0.00    0.52    0.06     1.79     0.00     0.00     0.14     0.00  \n",
       "24    0.00    0.35    0.02     1.48     0.00     0.00     0.00     0.00  \n",
       "25    0.00    0.07    0.00     0.59     0.00     0.00     0.00     0.00  \n",
       "26    0.00    0.14    0.00     0.65     0.00     0.00     0.00     0.00  \n",
       "27    0.04    0.00    0.44     0.00     0.26     0.00     0.00     0.95  \n",
       "28    0.58    0.21    0.26     2.78     0.21     0.54     0.00     0.00  \n",
       "29    0.58    0.63    0.34     4.19     0.65     0.50     0.10     0.00  \n",
       "30    0.64    0.90    0.28     0.99     0.82     0.38     2.99     0.00  \n",
       "31    0.78    1.00    0.61     0.31     2.08     0.67     3.70     1.71  \n",
       "32    0.82    0.75    0.62     1.01     7.06     2.14     2.10     1.46  \n",
       "33    0.84    0.77    0.60     1.03     7.58     2.37     2.28     1.26  \n",
       "34    0.48    0.70    0.34     0.99     1.99     0.37     0.45     0.10  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('display.max_columns', None)\n",
    "dataset = pd.DataFrame().from_dict(city_dict)\n",
    "dataset.head(35)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>city_id</th>\n",
       "      <th>city</th>\n",
       "      <th>lat_city</th>\n",
       "      <th>lon_city</th>\n",
       "      <th>temp_d1</th>\n",
       "      <th>temp_d2</th>\n",
       "      <th>temp_d3</th>\n",
       "      <th>temp_d4</th>\n",
       "      <th>temp_d5</th>\n",
       "      <th>weather_d1</th>\n",
       "      <th>weather_d2</th>\n",
       "      <th>weather_d3</th>\n",
       "      <th>weather_d4</th>\n",
       "      <th>weather_d5</th>\n",
       "      <th>clouds_d1</th>\n",
       "      <th>clouds_d2</th>\n",
       "      <th>clouds_d3</th>\n",
       "      <th>clouds_d4</th>\n",
       "      <th>clouds_d5</th>\n",
       "      <th>wind_d1</th>\n",
       "      <th>wind_d2</th>\n",
       "      <th>wind_d3</th>\n",
       "      <th>wind_d4</th>\n",
       "      <th>wind_d5</th>\n",
       "      <th>humidity_d1</th>\n",
       "      <th>humidity_d2</th>\n",
       "      <th>humidity_d3</th>\n",
       "      <th>humidity_d4</th>\n",
       "      <th>humidity_d5</th>\n",
       "      <th>pop_d1</th>\n",
       "      <th>pop_d2</th>\n",
       "      <th>pop_d3</th>\n",
       "      <th>pop_d4</th>\n",
       "      <th>pop_d5</th>\n",
       "      <th>rain_d1</th>\n",
       "      <th>rain_d2</th>\n",
       "      <th>rain_d3</th>\n",
       "      <th>rain_d4</th>\n",
       "      <th>rain_d5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>35.000000</td>\n",
       "      <td>35</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>NaN</td>\n",
       "      <td>35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Mont Saint Michel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "      <td>19</td>\n",
       "      <td>15</td>\n",
       "      <td>29</td>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>18.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.842672</td>\n",
       "      <td>3.401638</td>\n",
       "      <td>8.495429</td>\n",
       "      <td>5.402857</td>\n",
       "      <td>5.508000</td>\n",
       "      <td>8.212000</td>\n",
       "      <td>7.128286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.371429</td>\n",
       "      <td>77.942857</td>\n",
       "      <td>60.171429</td>\n",
       "      <td>95.742857</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>6.876571</td>\n",
       "      <td>4.983143</td>\n",
       "      <td>4.303429</td>\n",
       "      <td>6.262000</td>\n",
       "      <td>5.279429</td>\n",
       "      <td>80.085714</td>\n",
       "      <td>79.057143</td>\n",
       "      <td>80.171429</td>\n",
       "      <td>86.742857</td>\n",
       "      <td>81.714286</td>\n",
       "      <td>0.820571</td>\n",
       "      <td>0.366571</td>\n",
       "      <td>0.229714</td>\n",
       "      <td>0.727714</td>\n",
       "      <td>0.454286</td>\n",
       "      <td>1.676000</td>\n",
       "      <td>0.650000</td>\n",
       "      <td>0.275714</td>\n",
       "      <td>1.442286</td>\n",
       "      <td>0.496857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>10.246951</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.588229</td>\n",
       "      <td>2.950550</td>\n",
       "      <td>2.720422</td>\n",
       "      <td>2.386132</td>\n",
       "      <td>2.632504</td>\n",
       "      <td>2.614947</td>\n",
       "      <td>1.932145</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.578524</td>\n",
       "      <td>25.833110</td>\n",
       "      <td>38.891618</td>\n",
       "      <td>10.404589</td>\n",
       "      <td>4.789695</td>\n",
       "      <td>2.894440</td>\n",
       "      <td>1.735079</td>\n",
       "      <td>1.764229</td>\n",
       "      <td>3.427132</td>\n",
       "      <td>2.746507</td>\n",
       "      <td>9.838016</td>\n",
       "      <td>9.857642</td>\n",
       "      <td>10.592688</td>\n",
       "      <td>5.797276</td>\n",
       "      <td>10.637258</td>\n",
       "      <td>0.209438</td>\n",
       "      <td>0.356717</td>\n",
       "      <td>0.292539</td>\n",
       "      <td>0.304622</td>\n",
       "      <td>0.306578</td>\n",
       "      <td>1.924202</td>\n",
       "      <td>1.740054</td>\n",
       "      <td>0.548116</td>\n",
       "      <td>1.527216</td>\n",
       "      <td>0.657396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.525050</td>\n",
       "      <td>-2.026041</td>\n",
       "      <td>4.530000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>-0.910000</td>\n",
       "      <td>2.090000</td>\n",
       "      <td>2.050000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>76.000000</td>\n",
       "      <td>0.620000</td>\n",
       "      <td>1.990000</td>\n",
       "      <td>1.550000</td>\n",
       "      <td>1.760000</td>\n",
       "      <td>0.740000</td>\n",
       "      <td>62.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>58.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>63.000000</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>9.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.512178</td>\n",
       "      <td>1.399623</td>\n",
       "      <td>6.280000</td>\n",
       "      <td>3.900000</td>\n",
       "      <td>4.090000</td>\n",
       "      <td>6.760000</td>\n",
       "      <td>6.040000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>97.500000</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>18.500000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>99.000000</td>\n",
       "      <td>5.735000</td>\n",
       "      <td>4.010000</td>\n",
       "      <td>2.715000</td>\n",
       "      <td>3.785000</td>\n",
       "      <td>3.345000</td>\n",
       "      <td>71.000000</td>\n",
       "      <td>71.500000</td>\n",
       "      <td>70.500000</td>\n",
       "      <td>83.000000</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>0.705000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.565000</td>\n",
       "      <td>0.215000</td>\n",
       "      <td>0.440000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>18.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.187560</td>\n",
       "      <td>4.360069</td>\n",
       "      <td>7.750000</td>\n",
       "      <td>5.180000</td>\n",
       "      <td>5.840000</td>\n",
       "      <td>8.600000</td>\n",
       "      <td>7.200000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>71.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>7.170000</td>\n",
       "      <td>5.150000</td>\n",
       "      <td>4.910000</td>\n",
       "      <td>5.210000</td>\n",
       "      <td>5.300000</td>\n",
       "      <td>81.000000</td>\n",
       "      <td>81.000000</td>\n",
       "      <td>83.000000</td>\n",
       "      <td>87.000000</td>\n",
       "      <td>86.000000</td>\n",
       "      <td>0.910000</td>\n",
       "      <td>0.340000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.830000</td>\n",
       "      <td>0.390000</td>\n",
       "      <td>0.990000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.150000</td>\n",
       "      <td>0.210000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>26.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.417068</td>\n",
       "      <td>5.637707</td>\n",
       "      <td>10.285000</td>\n",
       "      <td>6.870000</td>\n",
       "      <td>7.335000</td>\n",
       "      <td>9.445000</td>\n",
       "      <td>8.005000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>98.500000</td>\n",
       "      <td>98.500000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>8.670000</td>\n",
       "      <td>6.160000</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>8.150000</td>\n",
       "      <td>7.030000</td>\n",
       "      <td>87.000000</td>\n",
       "      <td>86.500000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>91.500000</td>\n",
       "      <td>91.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.570000</td>\n",
       "      <td>0.495000</td>\n",
       "      <td>0.985000</td>\n",
       "      <td>0.715000</td>\n",
       "      <td>1.885000</td>\n",
       "      <td>0.315000</td>\n",
       "      <td>0.320000</td>\n",
       "      <td>2.175000</td>\n",
       "      <td>0.810000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>35.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.636565</td>\n",
       "      <td>7.750713</td>\n",
       "      <td>13.960000</td>\n",
       "      <td>10.310000</td>\n",
       "      <td>9.320000</td>\n",
       "      <td>12.670000</td>\n",
       "      <td>10.260000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>11.590000</td>\n",
       "      <td>7.870000</td>\n",
       "      <td>7.390000</td>\n",
       "      <td>17.610000</td>\n",
       "      <td>11.820000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>97.000000</td>\n",
       "      <td>93.000000</td>\n",
       "      <td>96.000000</td>\n",
       "      <td>97.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.840000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.990000</td>\n",
       "      <td>7.890000</td>\n",
       "      <td>7.580000</td>\n",
       "      <td>2.370000</td>\n",
       "      <td>6.680000</td>\n",
       "      <td>2.730000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          city_id               city   lat_city   lon_city    temp_d1  \\\n",
       "count   35.000000                 35  35.000000  35.000000  35.000000   \n",
       "unique        NaN                 35        NaN        NaN        NaN   \n",
       "top           NaN  Mont Saint Michel        NaN        NaN        NaN   \n",
       "freq          NaN                  1        NaN        NaN        NaN   \n",
       "mean    18.000000                NaN  45.842672   3.401638   8.495429   \n",
       "std     10.246951                NaN   2.588229   2.950550   2.720422   \n",
       "min      1.000000                NaN  42.525050  -2.026041   4.530000   \n",
       "25%      9.500000                NaN  43.512178   1.399623   6.280000   \n",
       "50%     18.000000                NaN  45.187560   4.360069   7.750000   \n",
       "75%     26.500000                NaN  48.417068   5.637707  10.285000   \n",
       "max     35.000000                NaN  50.636565   7.750713  13.960000   \n",
       "\n",
       "          temp_d2    temp_d3    temp_d4    temp_d5 weather_d1 weather_d2  \\\n",
       "count   35.000000  35.000000  35.000000  35.000000         35         35   \n",
       "unique        NaN        NaN        NaN        NaN          2          3   \n",
       "top           NaN        NaN        NaN        NaN       Rain     Clouds   \n",
       "freq          NaN        NaN        NaN        NaN         34         19   \n",
       "mean     5.402857   5.508000   8.212000   7.128286        NaN        NaN   \n",
       "std      2.386132   2.632504   2.614947   1.932145        NaN        NaN   \n",
       "min      0.050000  -0.910000   2.090000   2.050000        NaN        NaN   \n",
       "25%      3.900000   4.090000   6.760000   6.040000        NaN        NaN   \n",
       "50%      5.180000   5.840000   8.600000   7.200000        NaN        NaN   \n",
       "75%      6.870000   7.335000   9.445000   8.005000        NaN        NaN   \n",
       "max     10.310000   9.320000  12.670000  10.260000        NaN        NaN   \n",
       "\n",
       "       weather_d3 weather_d4 weather_d5   clouds_d1   clouds_d2   clouds_d3  \\\n",
       "count          35         35         35   35.000000   35.000000   35.000000   \n",
       "unique          3          2          2         NaN         NaN         NaN   \n",
       "top          Rain       Rain       Rain         NaN         NaN         NaN   \n",
       "freq           15         29         23         NaN         NaN         NaN   \n",
       "mean          NaN        NaN        NaN   90.371429   77.942857   60.171429   \n",
       "std           NaN        NaN        NaN   20.578524   25.833110   38.891618   \n",
       "min           NaN        NaN        NaN   17.000000   15.000000    1.000000   \n",
       "25%           NaN        NaN        NaN   97.500000   68.000000   18.500000   \n",
       "50%           NaN        NaN        NaN  100.000000   88.000000   71.000000   \n",
       "75%           NaN        NaN        NaN  100.000000   98.500000   98.500000   \n",
       "max           NaN        NaN        NaN  100.000000  100.000000  100.000000   \n",
       "\n",
       "         clouds_d4   clouds_d5    wind_d1    wind_d2    wind_d3    wind_d4  \\\n",
       "count    35.000000   35.000000  35.000000  35.000000  35.000000  35.000000   \n",
       "unique         NaN         NaN        NaN        NaN        NaN        NaN   \n",
       "top            NaN         NaN        NaN        NaN        NaN        NaN   \n",
       "freq           NaN         NaN        NaN        NaN        NaN        NaN   \n",
       "mean     95.742857   98.000000   6.876571   4.983143   4.303429   6.262000   \n",
       "std      10.404589    4.789695   2.894440   1.735079   1.764229   3.427132   \n",
       "min      56.000000   76.000000   0.620000   1.990000   1.550000   1.760000   \n",
       "25%     100.000000   99.000000   5.735000   4.010000   2.715000   3.785000   \n",
       "50%     100.000000  100.000000   7.170000   5.150000   4.910000   5.210000   \n",
       "75%     100.000000  100.000000   8.670000   6.160000   5.500000   8.150000   \n",
       "max     100.000000  100.000000  11.590000   7.870000   7.390000  17.610000   \n",
       "\n",
       "          wind_d5  humidity_d1  humidity_d2  humidity_d3  humidity_d4  \\\n",
       "count   35.000000    35.000000    35.000000    35.000000    35.000000   \n",
       "unique        NaN          NaN          NaN          NaN          NaN   \n",
       "top           NaN          NaN          NaN          NaN          NaN   \n",
       "freq          NaN          NaN          NaN          NaN          NaN   \n",
       "mean     5.279429    80.085714    79.057143    80.171429    86.742857   \n",
       "std      2.746507     9.838016     9.857642    10.592688     5.797276   \n",
       "min      0.740000    62.000000    60.000000    58.000000    75.000000   \n",
       "25%      3.345000    71.000000    71.500000    70.500000    83.000000   \n",
       "50%      5.300000    81.000000    81.000000    83.000000    87.000000   \n",
       "75%      7.030000    87.000000    86.500000    88.000000    91.500000   \n",
       "max     11.820000    98.000000    97.000000    93.000000    96.000000   \n",
       "\n",
       "        humidity_d5     pop_d1     pop_d2     pop_d3     pop_d4     pop_d5  \\\n",
       "count     35.000000  35.000000  35.000000  35.000000  35.000000  35.000000   \n",
       "unique          NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "top             NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "freq            NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "mean      81.714286   0.820571   0.366571   0.229714   0.727714   0.454286   \n",
       "std       10.637258   0.209438   0.356717   0.292539   0.304622   0.306578   \n",
       "min       63.000000   0.300000   0.000000   0.000000   0.000000   0.000000   \n",
       "25%       72.000000   0.705000   0.000000   0.000000   0.565000   0.215000   \n",
       "50%       86.000000   0.910000   0.340000   0.000000   0.830000   0.390000   \n",
       "75%       91.000000   1.000000   0.570000   0.495000   0.985000   0.715000   \n",
       "max       97.000000   1.000000   1.000000   0.840000   1.000000   0.990000   \n",
       "\n",
       "          rain_d1    rain_d2    rain_d3    rain_d4    rain_d5  \n",
       "count   35.000000  35.000000  35.000000  35.000000  35.000000  \n",
       "unique        NaN        NaN        NaN        NaN        NaN  \n",
       "top           NaN        NaN        NaN        NaN        NaN  \n",
       "freq          NaN        NaN        NaN        NaN        NaN  \n",
       "mean     1.676000   0.650000   0.275714   1.442286   0.496857  \n",
       "std      1.924202   1.740054   0.548116   1.527216   0.657396  \n",
       "min      0.000000   0.000000   0.000000   0.000000   0.000000  \n",
       "25%      0.440000   0.000000   0.000000   0.200000   0.000000  \n",
       "50%      0.990000   0.000000   0.000000   1.150000   0.210000  \n",
       "75%      1.885000   0.315000   0.320000   2.175000   0.810000  \n",
       "max      7.890000   7.580000   2.370000   6.680000   2.730000  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset.describe(include='all')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Enregistrement fichier csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Enregistrement fichier csv\n",
    "# Top 35 villes françaises avec données gps et météo\n",
    "dataset.to_csv('./src/top_35_cities.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataset = pd.read_csv('./src/top_35_cities.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Simplification du dataframe"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Nous simplifions le dataframe obtenu en calculant les valeurs moyennes pour les 5 prochains jours."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calcul des valeurs moyennes pour les 5 prochains jours \n",
    "\n",
    "dataset['avg_temp'] = dataset.filter(like='temp_d').mean(axis=1)\n",
    "dataset['avg_clouds'] = dataset.filter(like='clouds_d').mean(axis=1)\n",
    "dataset['avg_wind'] = dataset.filter(like='wind_d').mean(axis=1)\n",
    "dataset['avg_humidity'] = dataset.filter(like='humidity_d').mean(axis=1)\n",
    "dataset['avg_pop'] = dataset.filter(like='pop_d').mean(axis=1)\n",
    "dataset['avg_rain'] = dataset.filter(like='rain_d').mean(axis=1)\n",
    "dataset['avg_weather'] = dataset.filter(like='weather_d').mode(axis=1).iloc[:,0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>city_id</th>\n",
       "      <th>city</th>\n",
       "      <th>lat_city</th>\n",
       "      <th>lon_city</th>\n",
       "      <th>avg_weather</th>\n",
       "      <th>avg_temp</th>\n",
       "      <th>avg_clouds</th>\n",
       "      <th>avg_wind</th>\n",
       "      <th>avg_humidity</th>\n",
       "      <th>avg_rain</th>\n",
       "      <th>avg_pop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Mont Saint Michel</td>\n",
       "      <td>48.635954</td>\n",
       "      <td>-1.511460</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.668</td>\n",
       "      <td>82.6</td>\n",
       "      <td>7.708</td>\n",
       "      <td>87.0</td>\n",
       "      <td>0.446</td>\n",
       "      <td>0.528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>St Malo</td>\n",
       "      <td>48.649518</td>\n",
       "      <td>-2.026041</td>\n",
       "      <td>Rain</td>\n",
       "      <td>6.324</td>\n",
       "      <td>84.0</td>\n",
       "      <td>8.852</td>\n",
       "      <td>84.0</td>\n",
       "      <td>0.524</td>\n",
       "      <td>0.546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Bayeux</td>\n",
       "      <td>49.276462</td>\n",
       "      <td>-0.702474</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.518</td>\n",
       "      <td>71.2</td>\n",
       "      <td>6.992</td>\n",
       "      <td>88.8</td>\n",
       "      <td>0.832</td>\n",
       "      <td>0.616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Le Havre</td>\n",
       "      <td>49.493898</td>\n",
       "      <td>0.107973</td>\n",
       "      <td>Rain</td>\n",
       "      <td>7.252</td>\n",
       "      <td>74.2</td>\n",
       "      <td>9.022</td>\n",
       "      <td>82.0</td>\n",
       "      <td>0.806</td>\n",
       "      <td>0.646</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Rouen</td>\n",
       "      <td>49.440459</td>\n",
       "      <td>1.093966</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.518</td>\n",
       "      <td>80.2</td>\n",
       "      <td>6.328</td>\n",
       "      <td>87.6</td>\n",
       "      <td>0.590</td>\n",
       "      <td>0.528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Paris</td>\n",
       "      <td>48.858890</td>\n",
       "      <td>2.320041</td>\n",
       "      <td>Rain</td>\n",
       "      <td>6.874</td>\n",
       "      <td>93.8</td>\n",
       "      <td>5.798</td>\n",
       "      <td>77.6</td>\n",
       "      <td>1.268</td>\n",
       "      <td>0.664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Amiens</td>\n",
       "      <td>49.894171</td>\n",
       "      <td>2.295695</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.940</td>\n",
       "      <td>87.8</td>\n",
       "      <td>6.220</td>\n",
       "      <td>86.8</td>\n",
       "      <td>0.752</td>\n",
       "      <td>0.622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Lille</td>\n",
       "      <td>50.636565</td>\n",
       "      <td>3.063528</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.448</td>\n",
       "      <td>93.8</td>\n",
       "      <td>6.932</td>\n",
       "      <td>83.0</td>\n",
       "      <td>1.536</td>\n",
       "      <td>0.602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Strasbourg</td>\n",
       "      <td>48.584614</td>\n",
       "      <td>7.750713</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>5.882</td>\n",
       "      <td>77.4</td>\n",
       "      <td>4.144</td>\n",
       "      <td>80.8</td>\n",
       "      <td>0.478</td>\n",
       "      <td>0.410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Chateau du Haut Koenigsbourg</td>\n",
       "      <td>48.249523</td>\n",
       "      <td>7.345492</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>2.034</td>\n",
       "      <td>79.0</td>\n",
       "      <td>3.320</td>\n",
       "      <td>86.4</td>\n",
       "      <td>0.860</td>\n",
       "      <td>0.508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Colmar</td>\n",
       "      <td>48.077752</td>\n",
       "      <td>7.357964</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.362</td>\n",
       "      <td>78.6</td>\n",
       "      <td>3.848</td>\n",
       "      <td>85.0</td>\n",
       "      <td>1.158</td>\n",
       "      <td>0.558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Eguisheim</td>\n",
       "      <td>48.044797</td>\n",
       "      <td>7.307962</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.314</td>\n",
       "      <td>79.4</td>\n",
       "      <td>3.676</td>\n",
       "      <td>85.8</td>\n",
       "      <td>1.386</td>\n",
       "      <td>0.526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Besancon</td>\n",
       "      <td>47.238022</td>\n",
       "      <td>6.024362</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.754</td>\n",
       "      <td>87.2</td>\n",
       "      <td>5.712</td>\n",
       "      <td>83.8</td>\n",
       "      <td>1.618</td>\n",
       "      <td>0.602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Dijon</td>\n",
       "      <td>47.321581</td>\n",
       "      <td>5.041470</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.084</td>\n",
       "      <td>98.8</td>\n",
       "      <td>7.052</td>\n",
       "      <td>87.6</td>\n",
       "      <td>0.614</td>\n",
       "      <td>0.514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Annecy</td>\n",
       "      <td>45.899235</td>\n",
       "      <td>6.128885</td>\n",
       "      <td>Rain</td>\n",
       "      <td>3.954</td>\n",
       "      <td>93.0</td>\n",
       "      <td>2.506</td>\n",
       "      <td>95.6</td>\n",
       "      <td>2.152</td>\n",
       "      <td>0.768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Grenoble</td>\n",
       "      <td>45.187560</td>\n",
       "      <td>5.735782</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.836</td>\n",
       "      <td>84.6</td>\n",
       "      <td>2.262</td>\n",
       "      <td>92.4</td>\n",
       "      <td>0.874</td>\n",
       "      <td>0.734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>Lyon</td>\n",
       "      <td>45.757814</td>\n",
       "      <td>4.832011</td>\n",
       "      <td>Rain</td>\n",
       "      <td>6.910</td>\n",
       "      <td>100.0</td>\n",
       "      <td>4.696</td>\n",
       "      <td>73.6</td>\n",
       "      <td>1.664</td>\n",
       "      <td>0.548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Gorges du Verdon</td>\n",
       "      <td>43.749656</td>\n",
       "      <td>6.328562</td>\n",
       "      <td>Rain</td>\n",
       "      <td>2.422</td>\n",
       "      <td>70.6</td>\n",
       "      <td>2.128</td>\n",
       "      <td>93.2</td>\n",
       "      <td>0.442</td>\n",
       "      <td>0.442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>Bormes les Mimosas</td>\n",
       "      <td>43.150697</td>\n",
       "      <td>6.341928</td>\n",
       "      <td>Rain</td>\n",
       "      <td>10.280</td>\n",
       "      <td>63.6</td>\n",
       "      <td>5.370</td>\n",
       "      <td>75.8</td>\n",
       "      <td>0.486</td>\n",
       "      <td>0.388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Cassis</td>\n",
       "      <td>43.214036</td>\n",
       "      <td>5.539632</td>\n",
       "      <td>Rain</td>\n",
       "      <td>11.072</td>\n",
       "      <td>64.8</td>\n",
       "      <td>5.528</td>\n",
       "      <td>75.2</td>\n",
       "      <td>0.348</td>\n",
       "      <td>0.320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Marseille</td>\n",
       "      <td>43.296174</td>\n",
       "      <td>5.369953</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>11.240</td>\n",
       "      <td>63.0</td>\n",
       "      <td>5.642</td>\n",
       "      <td>73.2</td>\n",
       "      <td>0.250</td>\n",
       "      <td>0.292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Aix en Provence</td>\n",
       "      <td>43.529842</td>\n",
       "      <td>5.447474</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>8.040</td>\n",
       "      <td>64.2</td>\n",
       "      <td>3.224</td>\n",
       "      <td>79.0</td>\n",
       "      <td>0.176</td>\n",
       "      <td>0.332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Avignon</td>\n",
       "      <td>43.949249</td>\n",
       "      <td>4.805901</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>8.430</td>\n",
       "      <td>89.8</td>\n",
       "      <td>4.360</td>\n",
       "      <td>75.8</td>\n",
       "      <td>0.392</td>\n",
       "      <td>0.322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>Uzes</td>\n",
       "      <td>44.012128</td>\n",
       "      <td>4.419672</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>7.454</td>\n",
       "      <td>94.2</td>\n",
       "      <td>4.620</td>\n",
       "      <td>74.0</td>\n",
       "      <td>0.386</td>\n",
       "      <td>0.316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Nimes</td>\n",
       "      <td>43.837425</td>\n",
       "      <td>4.360069</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>8.450</td>\n",
       "      <td>95.6</td>\n",
       "      <td>5.134</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0.296</td>\n",
       "      <td>0.264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Aigues Mortes</td>\n",
       "      <td>43.566152</td>\n",
       "      <td>4.191540</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>10.158</td>\n",
       "      <td>91.0</td>\n",
       "      <td>5.956</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.118</td>\n",
       "      <td>0.194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Saintes Maries de la mer</td>\n",
       "      <td>43.451592</td>\n",
       "      <td>4.427720</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>10.652</td>\n",
       "      <td>81.6</td>\n",
       "      <td>7.020</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0.130</td>\n",
       "      <td>0.194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>Collioure</td>\n",
       "      <td>42.525050</td>\n",
       "      <td>3.083155</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>8.358</td>\n",
       "      <td>69.8</td>\n",
       "      <td>3.846</td>\n",
       "      <td>77.4</td>\n",
       "      <td>0.242</td>\n",
       "      <td>0.224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Carcassonne</td>\n",
       "      <td>43.213036</td>\n",
       "      <td>2.349107</td>\n",
       "      <td>Rain</td>\n",
       "      <td>6.870</td>\n",
       "      <td>91.6</td>\n",
       "      <td>6.552</td>\n",
       "      <td>82.4</td>\n",
       "      <td>0.706</td>\n",
       "      <td>0.486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>Ariege</td>\n",
       "      <td>42.992743</td>\n",
       "      <td>1.612497</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.834</td>\n",
       "      <td>96.6</td>\n",
       "      <td>2.742</td>\n",
       "      <td>86.0</td>\n",
       "      <td>1.088</td>\n",
       "      <td>0.630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>Toulouse</td>\n",
       "      <td>43.604462</td>\n",
       "      <td>1.444247</td>\n",
       "      <td>Rain</td>\n",
       "      <td>6.434</td>\n",
       "      <td>99.4</td>\n",
       "      <td>5.646</td>\n",
       "      <td>85.2</td>\n",
       "      <td>1.036</td>\n",
       "      <td>0.698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>Montauban</td>\n",
       "      <td>44.017584</td>\n",
       "      <td>1.354999</td>\n",
       "      <td>Rain</td>\n",
       "      <td>6.368</td>\n",
       "      <td>99.6</td>\n",
       "      <td>5.740</td>\n",
       "      <td>89.4</td>\n",
       "      <td>1.694</td>\n",
       "      <td>0.834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>Biarritz</td>\n",
       "      <td>43.483252</td>\n",
       "      <td>-1.559278</td>\n",
       "      <td>Rain</td>\n",
       "      <td>9.294</td>\n",
       "      <td>99.8</td>\n",
       "      <td>7.972</td>\n",
       "      <td>76.4</td>\n",
       "      <td>2.754</td>\n",
       "      <td>0.828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>Bayonne</td>\n",
       "      <td>43.494514</td>\n",
       "      <td>-1.473666</td>\n",
       "      <td>Rain</td>\n",
       "      <td>8.984</td>\n",
       "      <td>99.6</td>\n",
       "      <td>6.962</td>\n",
       "      <td>78.0</td>\n",
       "      <td>2.904</td>\n",
       "      <td>0.834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>La Rochelle</td>\n",
       "      <td>46.159113</td>\n",
       "      <td>-1.152043</td>\n",
       "      <td>Rain</td>\n",
       "      <td>8.214</td>\n",
       "      <td>75.2</td>\n",
       "      <td>10.422</td>\n",
       "      <td>75.6</td>\n",
       "      <td>0.780</td>\n",
       "      <td>0.674</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    city_id                          city   lat_city  lon_city avg_weather  \\\n",
       "0         1             Mont Saint Michel  48.635954 -1.511460        Rain   \n",
       "1         2                       St Malo  48.649518 -2.026041        Rain   \n",
       "2         3                        Bayeux  49.276462 -0.702474        Rain   \n",
       "3         4                      Le Havre  49.493898  0.107973        Rain   \n",
       "4         5                         Rouen  49.440459  1.093966        Rain   \n",
       "5         6                         Paris  48.858890  2.320041        Rain   \n",
       "6         7                        Amiens  49.894171  2.295695        Rain   \n",
       "7         8                         Lille  50.636565  3.063528        Rain   \n",
       "8         9                    Strasbourg  48.584614  7.750713      Clouds   \n",
       "9        10  Chateau du Haut Koenigsbourg  48.249523  7.345492      Clouds   \n",
       "10       11                        Colmar  48.077752  7.357964        Rain   \n",
       "11       12                     Eguisheim  48.044797  7.307962        Rain   \n",
       "12       13                      Besancon  47.238022  6.024362        Rain   \n",
       "13       14                         Dijon  47.321581  5.041470        Rain   \n",
       "14       15                        Annecy  45.899235  6.128885        Rain   \n",
       "15       16                      Grenoble  45.187560  5.735782        Rain   \n",
       "16       17                          Lyon  45.757814  4.832011        Rain   \n",
       "17       18              Gorges du Verdon  43.749656  6.328562        Rain   \n",
       "18       19            Bormes les Mimosas  43.150697  6.341928        Rain   \n",
       "19       20                        Cassis  43.214036  5.539632        Rain   \n",
       "20       21                     Marseille  43.296174  5.369953      Clouds   \n",
       "21       22               Aix en Provence  43.529842  5.447474      Clouds   \n",
       "22       23                       Avignon  43.949249  4.805901      Clouds   \n",
       "23       24                          Uzes  44.012128  4.419672      Clouds   \n",
       "24       25                         Nimes  43.837425  4.360069      Clouds   \n",
       "25       26                 Aigues Mortes  43.566152  4.191540      Clouds   \n",
       "26       27      Saintes Maries de la mer  43.451592  4.427720      Clouds   \n",
       "27       28                     Collioure  42.525050  3.083155      Clouds   \n",
       "28       29                   Carcassonne  43.213036  2.349107        Rain   \n",
       "29       30                        Ariege  42.992743  1.612497        Rain   \n",
       "30       31                      Toulouse  43.604462  1.444247        Rain   \n",
       "31       32                     Montauban  44.017584  1.354999        Rain   \n",
       "32       33                      Biarritz  43.483252 -1.559278        Rain   \n",
       "33       34                       Bayonne  43.494514 -1.473666        Rain   \n",
       "34       35                   La Rochelle  46.159113 -1.152043        Rain   \n",
       "\n",
       "    avg_temp  avg_clouds  avg_wind  avg_humidity  avg_rain  avg_pop  \n",
       "0      5.668        82.6     7.708          87.0     0.446    0.528  \n",
       "1      6.324        84.0     8.852          84.0     0.524    0.546  \n",
       "2      5.518        71.2     6.992          88.8     0.832    0.616  \n",
       "3      7.252        74.2     9.022          82.0     0.806    0.646  \n",
       "4      5.518        80.2     6.328          87.6     0.590    0.528  \n",
       "5      6.874        93.8     5.798          77.6     1.268    0.664  \n",
       "6      5.940        87.8     6.220          86.8     0.752    0.622  \n",
       "7      5.448        93.8     6.932          83.0     1.536    0.602  \n",
       "8      5.882        77.4     4.144          80.8     0.478    0.410  \n",
       "9      2.034        79.0     3.320          86.4     0.860    0.508  \n",
       "10     5.362        78.6     3.848          85.0     1.158    0.558  \n",
       "11     5.314        79.4     3.676          85.8     1.386    0.526  \n",
       "12     5.754        87.2     5.712          83.8     1.618    0.602  \n",
       "13     5.084        98.8     7.052          87.6     0.614    0.514  \n",
       "14     3.954        93.0     2.506          95.6     2.152    0.768  \n",
       "15     5.836        84.6     2.262          92.4     0.874    0.734  \n",
       "16     6.910       100.0     4.696          73.6     1.664    0.548  \n",
       "17     2.422        70.6     2.128          93.2     0.442    0.442  \n",
       "18    10.280        63.6     5.370          75.8     0.486    0.388  \n",
       "19    11.072        64.8     5.528          75.2     0.348    0.320  \n",
       "20    11.240        63.0     5.642          73.2     0.250    0.292  \n",
       "21     8.040        64.2     3.224          79.0     0.176    0.332  \n",
       "22     8.430        89.8     4.360          75.8     0.392    0.322  \n",
       "23     7.454        94.2     4.620          74.0     0.386    0.316  \n",
       "24     8.450        95.6     5.134          71.0     0.296    0.264  \n",
       "25    10.158        91.0     5.956          68.0     0.118    0.194  \n",
       "26    10.652        81.6     7.020          71.0     0.130    0.194  \n",
       "27     8.358        69.8     3.846          77.4     0.242    0.224  \n",
       "28     6.870        91.6     6.552          82.4     0.706    0.486  \n",
       "29     5.834        96.6     2.742          86.0     1.088    0.630  \n",
       "30     6.434        99.4     5.646          85.2     1.036    0.698  \n",
       "31     6.368        99.6     5.740          89.4     1.694    0.834  \n",
       "32     9.294        99.8     7.972          76.4     2.754    0.828  \n",
       "33     8.984        99.6     6.962          78.0     2.904    0.834  \n",
       "34     8.214        75.2    10.422          75.6     0.780    0.674  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset_lite = dataset[['city_id', 'city', 'lat_city', 'lon_city', \n",
    "                      'avg_weather', 'avg_temp', 'avg_clouds', 'avg_wind',\n",
    "                      'avg_humidity', 'avg_rain', 'avg_pop',]].copy()\n",
    "dataset_lite.head(35)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>city_id</th>\n",
       "      <th>city</th>\n",
       "      <th>lat_city</th>\n",
       "      <th>lon_city</th>\n",
       "      <th>avg_weather</th>\n",
       "      <th>avg_temp</th>\n",
       "      <th>avg_clouds</th>\n",
       "      <th>avg_wind</th>\n",
       "      <th>avg_humidity</th>\n",
       "      <th>avg_rain</th>\n",
       "      <th>avg_pop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>35.000000</td>\n",
       "      <td>35</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "      <td>35.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>NaN</td>\n",
       "      <td>35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Mont Saint Michel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>18.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.842672</td>\n",
       "      <td>3.401638</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.949314</td>\n",
       "      <td>84.445714</td>\n",
       "      <td>5.540914</td>\n",
       "      <td>81.554286</td>\n",
       "      <td>0.908171</td>\n",
       "      <td>0.519771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>10.246951</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.588229</td>\n",
       "      <td>2.950550</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.216783</td>\n",
       "      <td>11.825803</td>\n",
       "      <td>1.989231</td>\n",
       "      <td>6.888197</td>\n",
       "      <td>0.698629</td>\n",
       "      <td>0.183944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.525050</td>\n",
       "      <td>-2.026041</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.034000</td>\n",
       "      <td>63.000000</td>\n",
       "      <td>2.128000</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>0.118000</td>\n",
       "      <td>0.194000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>9.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.512178</td>\n",
       "      <td>1.399623</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.593000</td>\n",
       "      <td>76.300000</td>\n",
       "      <td>3.996000</td>\n",
       "      <td>75.800000</td>\n",
       "      <td>0.417000</td>\n",
       "      <td>0.360000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>18.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.187560</td>\n",
       "      <td>4.360069</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.434000</td>\n",
       "      <td>84.600000</td>\n",
       "      <td>5.646000</td>\n",
       "      <td>82.400000</td>\n",
       "      <td>0.752000</td>\n",
       "      <td>0.528000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>26.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.417068</td>\n",
       "      <td>5.637707</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.394000</td>\n",
       "      <td>94.000000</td>\n",
       "      <td>6.947000</td>\n",
       "      <td>86.600000</td>\n",
       "      <td>1.213000</td>\n",
       "      <td>0.638000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>35.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.636565</td>\n",
       "      <td>7.750713</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.240000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>10.422000</td>\n",
       "      <td>95.600000</td>\n",
       "      <td>2.904000</td>\n",
       "      <td>0.834000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          city_id               city   lat_city   lon_city avg_weather  \\\n",
       "count   35.000000                 35  35.000000  35.000000          35   \n",
       "unique        NaN                 35        NaN        NaN           2   \n",
       "top           NaN  Mont Saint Michel        NaN        NaN        Rain   \n",
       "freq          NaN                  1        NaN        NaN          25   \n",
       "mean    18.000000                NaN  45.842672   3.401638         NaN   \n",
       "std     10.246951                NaN   2.588229   2.950550         NaN   \n",
       "min      1.000000                NaN  42.525050  -2.026041         NaN   \n",
       "25%      9.500000                NaN  43.512178   1.399623         NaN   \n",
       "50%     18.000000                NaN  45.187560   4.360069         NaN   \n",
       "75%     26.500000                NaN  48.417068   5.637707         NaN   \n",
       "max     35.000000                NaN  50.636565   7.750713         NaN   \n",
       "\n",
       "         avg_temp  avg_clouds   avg_wind  avg_humidity   avg_rain    avg_pop  \n",
       "count   35.000000   35.000000  35.000000     35.000000  35.000000  35.000000  \n",
       "unique        NaN         NaN        NaN           NaN        NaN        NaN  \n",
       "top           NaN         NaN        NaN           NaN        NaN        NaN  \n",
       "freq          NaN         NaN        NaN           NaN        NaN        NaN  \n",
       "mean     6.949314   84.445714   5.540914     81.554286   0.908171   0.519771  \n",
       "std      2.216783   11.825803   1.989231      6.888197   0.698629   0.183944  \n",
       "min      2.034000   63.000000   2.128000     68.000000   0.118000   0.194000  \n",
       "25%      5.593000   76.300000   3.996000     75.800000   0.417000   0.360000  \n",
       "50%      6.434000   84.600000   5.646000     82.400000   0.752000   0.528000  \n",
       "75%      8.394000   94.000000   6.947000     86.600000   1.213000   0.638000  \n",
       "max     11.240000  100.000000  10.422000     95.600000   2.904000   0.834000  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset_lite.describe(include='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Enregistrement fichier csv \n",
    "# Top 35 villes françaises avec données gps et météo en version lite\n",
    "dataset_lite.to_csv('./src/top_35_cities_lite.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataset_lite = pd.read_csv('./src/top_35_cities_lite.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Les 5 meilleures destinations"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Villes supérieures à la moyenne\n",
    "\n",
    "Nous nous intéressons aux villes dont les données météorologiques sont meilleures que la moyenne."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Création de masques basés sur la moyenne\n",
    "\n",
    "min_temp = dataset_lite['avg_temp'] >= dataset_lite['avg_temp'].mean()\n",
    "max_wind = dataset_lite['avg_wind'] <= dataset_lite['avg_wind'].mean()\n",
    "max_clouds = dataset_lite['avg_clouds'] <= dataset_lite['avg_clouds'].mean()\n",
    "max_rain = dataset_lite['avg_rain'] <= dataset_lite['avg_rain'].mean()\n",
    "max_pop = dataset_lite['avg_pop'] <= dataset_lite['avg_pop'].mean()\n",
    "max_humidity = dataset_lite['avg_humidity'] <= dataset_lite['avg_humidity'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "4\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>city_id</th>\n",
       "      <th>city</th>\n",
       "      <th>lat_city</th>\n",
       "      <th>lon_city</th>\n",
       "      <th>avg_weather</th>\n",
       "      <th>avg_temp</th>\n",
       "      <th>avg_clouds</th>\n",
       "      <th>avg_wind</th>\n",
       "      <th>avg_humidity</th>\n",
       "      <th>avg_rain</th>\n",
       "      <th>avg_pop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19</td>\n",
       "      <td>Bormes les Mimosas</td>\n",
       "      <td>43.150697</td>\n",
       "      <td>6.341928</td>\n",
       "      <td>Rain</td>\n",
       "      <td>10.280</td>\n",
       "      <td>63.6</td>\n",
       "      <td>5.370</td>\n",
       "      <td>75.8</td>\n",
       "      <td>0.486</td>\n",
       "      <td>0.388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>Cassis</td>\n",
       "      <td>43.214036</td>\n",
       "      <td>5.539632</td>\n",
       "      <td>Rain</td>\n",
       "      <td>11.072</td>\n",
       "      <td>64.8</td>\n",
       "      <td>5.528</td>\n",
       "      <td>75.2</td>\n",
       "      <td>0.348</td>\n",
       "      <td>0.320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>22</td>\n",
       "      <td>Aix en Provence</td>\n",
       "      <td>43.529842</td>\n",
       "      <td>5.447474</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>8.040</td>\n",
       "      <td>64.2</td>\n",
       "      <td>3.224</td>\n",
       "      <td>79.0</td>\n",
       "      <td>0.176</td>\n",
       "      <td>0.332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28</td>\n",
       "      <td>Collioure</td>\n",
       "      <td>42.525050</td>\n",
       "      <td>3.083155</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>8.358</td>\n",
       "      <td>69.8</td>\n",
       "      <td>3.846</td>\n",
       "      <td>77.4</td>\n",
       "      <td>0.242</td>\n",
       "      <td>0.224</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   city_id                city   lat_city  lon_city avg_weather  avg_temp  \\\n",
       "0       19  Bormes les Mimosas  43.150697  6.341928        Rain    10.280   \n",
       "1       20              Cassis  43.214036  5.539632        Rain    11.072   \n",
       "2       22     Aix en Provence  43.529842  5.447474      Clouds     8.040   \n",
       "3       28           Collioure  42.525050  3.083155      Clouds     8.358   \n",
       "\n",
       "   avg_clouds  avg_wind  avg_humidity  avg_rain  avg_pop  \n",
       "0        63.6     5.370          75.8     0.486    0.388  \n",
       "1        64.8     5.528          75.2     0.348    0.320  \n",
       "2        64.2     3.224          79.0     0.176    0.332  \n",
       "3        69.8     3.846          77.4     0.242    0.224  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "best_destinations_lite = dataset_lite[min_temp & max_clouds & max_rain & max_pop & max_humidity & max_wind]\n",
    "best_destinations_lite = best_destinations_lite.reset_index(drop=True)\n",
    "print(len(best_destinations_lite))\n",
    "best_destinations_lite"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Cette méthode est trop restrictive : nous n'obtenons que 4 villes au moment où ce notebook est édité (novembre).\n",
    "\n",
    "Par conséquent nous tentons une méthode différente."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Ordonner les villes\n",
    "\n",
    "Nous choisissons d'ordonner les villes par rapport à ces critères et dans cet ordre : \n",
    "\n",
    "1. la vitesse du vent\n",
    "\n",
    "2. la probabilité de pleuvoir\n",
    "\n",
    "3. le taux de nuages\n",
    "\n",
    "4. le taux d'humidité\n",
    "\n",
    "5. la température"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>city_id</th>\n",
       "      <th>city</th>\n",
       "      <th>lat_city</th>\n",
       "      <th>lon_city</th>\n",
       "      <th>avg_weather</th>\n",
       "      <th>avg_temp</th>\n",
       "      <th>avg_clouds</th>\n",
       "      <th>avg_wind</th>\n",
       "      <th>avg_humidity</th>\n",
       "      <th>avg_rain</th>\n",
       "      <th>avg_pop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>Gorges du Verdon</td>\n",
       "      <td>43.749656</td>\n",
       "      <td>6.328562</td>\n",
       "      <td>Rain</td>\n",
       "      <td>2.422</td>\n",
       "      <td>70.6</td>\n",
       "      <td>2.128</td>\n",
       "      <td>93.2</td>\n",
       "      <td>0.442</td>\n",
       "      <td>0.442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>Grenoble</td>\n",
       "      <td>45.187560</td>\n",
       "      <td>5.735782</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.836</td>\n",
       "      <td>84.6</td>\n",
       "      <td>2.262</td>\n",
       "      <td>92.4</td>\n",
       "      <td>0.874</td>\n",
       "      <td>0.734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>Annecy</td>\n",
       "      <td>45.899235</td>\n",
       "      <td>6.128885</td>\n",
       "      <td>Rain</td>\n",
       "      <td>3.954</td>\n",
       "      <td>93.0</td>\n",
       "      <td>2.506</td>\n",
       "      <td>95.6</td>\n",
       "      <td>2.152</td>\n",
       "      <td>0.768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>Ariege</td>\n",
       "      <td>42.992743</td>\n",
       "      <td>1.612497</td>\n",
       "      <td>Rain</td>\n",
       "      <td>5.834</td>\n",
       "      <td>96.6</td>\n",
       "      <td>2.742</td>\n",
       "      <td>86.0</td>\n",
       "      <td>1.088</td>\n",
       "      <td>0.630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Aix en Provence</td>\n",
       "      <td>43.529842</td>\n",
       "      <td>5.447474</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>8.040</td>\n",
       "      <td>64.2</td>\n",
       "      <td>3.224</td>\n",
       "      <td>79.0</td>\n",
       "      <td>0.176</td>\n",
       "      <td>0.332</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    city_id              city   lat_city  lon_city avg_weather  avg_temp  \\\n",
       "17       18  Gorges du Verdon  43.749656  6.328562        Rain     2.422   \n",
       "15       16          Grenoble  45.187560  5.735782        Rain     5.836   \n",
       "14       15            Annecy  45.899235  6.128885        Rain     3.954   \n",
       "29       30            Ariege  42.992743  1.612497        Rain     5.834   \n",
       "21       22   Aix en Provence  43.529842  5.447474      Clouds     8.040   \n",
       "\n",
       "    avg_clouds  avg_wind  avg_humidity  avg_rain  avg_pop  \n",
       "17        70.6     2.128          93.2     0.442    0.442  \n",
       "15        84.6     2.262          92.4     0.874    0.734  \n",
       "14        93.0     2.506          95.6     2.152    0.768  \n",
       "29        96.6     2.742          86.0     1.088    0.630  \n",
       "21        64.2     3.224          79.0     0.176    0.332  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset_sorted = dataset_lite.sort_values(['avg_wind', 'avg_pop', 'avg_clouds', 'avg_humidity', 'avg_temp'], \n",
    "                                        ascending=[True, True, True, True, False])\n",
    "dataset_sorted.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Les 5 premières villes qui ressortent sont concentrées géographiquement. \n",
    "\n",
    "Cela semble logique puisque les villes partageant des données météorologiques proches sont susceptibles d'être géographiquement proches."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Varier les régions représentées\n",
    "\n",
    "Pour apporter de la variété dans les villes sélectionnées, nous ajoutons le critère de latitude.  \n",
    "\n",
    "--> Nous construisons 5 intervalles de latitudes et choisissons la meilleure ville de chaque intervalle."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[42.52505,\n",
       " 43.476920279999995,\n",
       " 43.90451954,\n",
       " 46.59067644,\n",
       " 48.63866688,\n",
       " 50.6365654]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lat_interval = []\n",
    "for i in [x / 10.0 for x in range(0, 11, 2)]:\n",
    "    lat_interval.append(np.quantile(dataset_sorted['lat_city'], i))\n",
    "lat_interval"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Ariege',\n",
       " 'Gorges du Verdon',\n",
       " 'Grenoble',\n",
       " 'Chateau du Haut Koenigsbourg',\n",
       " 'Paris']"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "best = []\n",
    "for i in range(len(lat_interval)-1):\n",
    "    city = dataset_sorted[(dataset_sorted['lat_city'] > lat_interval[i]) & (dataset_sorted['lat_city'] < lat_interval[i+1])].iloc[0]['city']\n",
    "    best.append(city)\n",
    "best"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "best_destinations_lite = dataset_lite[(dataset_lite['city'] == best[0]) | \n",
    "                                 (dataset_lite['city'] == best[1]) | \n",
    "                                 (dataset_lite['city'] == best[2]) |\n",
    "                                 (dataset_lite['city'] == best[3]) |\n",
    "                                 (dataset_lite['city'] == best[4])]\n",
    "best_destinations_lite.sort_values(['avg_wind', 'avg_pop', 'avg_clouds', 'avg_humidity', 'avg_temp'], \n",
    "                                        ascending=[True, True, True, True, False])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Enregistrement fichiers csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Enregistrement fichier csv\n",
    "# Top 5 destinations françaises\n",
    "best_destinations_lite.to_csv('./src/top_5_destinations.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "best_destinations_lite = pd.read_csv('./src/top_5_destinations.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Visualisation sur carte"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.plotly.v1+json": {
       "config": {
        "plotlyServerURL": "https://plot.ly"
       },
       "data": [
        {
         "customdata": [
          [
           48.8588897,
           2.3200410217200766,
           6.8740000000000006
          ],
          [
           48.2495226,
           7.3454923,
           2.034
          ],
          [
           45.1875602,
           5.7357819,
           5.836
          ],
          [
           43.7496562,
           6.3285616,
           2.422
          ],
          [
           42.9927428,
           1.6124975,
           5.8340000000000005
          ]
         ],
         "hovertemplate": "<b>%{hovertext}</b><br><br>avg_temp=%{marker.color:.0f}<br>lat_city=%{customdata[0]:.2f}<br>lon_city=%{customdata[1]:.2f}<extra></extra>",
         "hovertext": [
          "Paris",
          "Chateau du Haut Koenigsbourg",
          "Grenoble",
          "Gorges du Verdon",
          "Ariege"
         ],
         "lat": [
          48.8588897,
          48.2495226,
          45.1875602,
          43.7496562,
          42.9927428
         ],
         "legendgroup": "",
         "lon": [
          2.3200410217200766,
          7.3454923,
          5.7357819,
          6.3285616,
          1.6124975
         ],
         "marker": {
          "color": [
           6.8740000000000006,
           2.034,
           5.836,
           2.422,
           5.8340000000000005
          ],
          "coloraxis": "coloraxis",
          "size": [
           6.8740000000000006,
           2.034,
           5.836,
           2.422,
           5.8340000000000005
          ],
          "sizemode": "area",
          "sizeref": 0.017185000000000002
         },
         "mode": "markers",
         "name": "",
         "showlegend": false,
         "subplot": "mapbox",
         "type": "scattermapbox"
        }
       ],
       "layout": {
        "coloraxis": {
         "colorbar": {
          "title": {
           "text": "avg_temp"
          }
         },
         "colorscale": [
          [
           0,
           "rgb(0,0,255)"
          ],
          [
           1,
           "rgb(255,0,0)"
          ]
         ]
        },
        "legend": {
         "itemsizing": "constant",
         "tracegroupgap": 0
        },
        "mapbox": {
         "center": {
          "lat": 46.232192999999995,
          "lon": 2.209666999999996
         },
         "domain": {
          "x": [
           0,
           1
          ],
          "y": [
           0,
           1
          ]
         },
         "style": "carto-positron",
         "zoom": 4
        },
        "margin": {
         "t": 60
        },
        "template": {
         "data": {
          "bar": [
           {
            "error_x": {
             "color": "#2a3f5f"
            },
            "error_y": {
             "color": "#2a3f5f"
            },
            "marker": {
             "line": {
              "color": "#E5ECF6",
              "width": 0.5
             },
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "bar"
           }
          ],
          "barpolar": [
           {
            "marker": {
             "line": {
              "color": "#E5ECF6",
              "width": 0.5
             },
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "barpolar"
           }
          ],
          "carpet": [
           {
            "aaxis": {
             "endlinecolor": "#2a3f5f",
             "gridcolor": "white",
             "linecolor": "white",
             "minorgridcolor": "white",
             "startlinecolor": "#2a3f5f"
            },
            "baxis": {
             "endlinecolor": "#2a3f5f",
             "gridcolor": "white",
             "linecolor": "white",
             "minorgridcolor": "white",
             "startlinecolor": "#2a3f5f"
            },
            "type": "carpet"
           }
          ],
          "choropleth": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "choropleth"
           }
          ],
          "contour": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "contour"
           }
          ],
          "contourcarpet": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "contourcarpet"
           }
          ],
          "heatmap": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "heatmap"
           }
          ],
          "heatmapgl": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "heatmapgl"
           }
          ],
          "histogram": [
           {
            "marker": {
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "histogram"
           }
          ],
          "histogram2d": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "histogram2d"
           }
          ],
          "histogram2dcontour": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "histogram2dcontour"
           }
          ],
          "mesh3d": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "mesh3d"
           }
          ],
          "parcoords": [
           {
            "line": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "parcoords"
           }
          ],
          "pie": [
           {
            "automargin": true,
            "type": "pie"
           }
          ],
          "scatter": [
           {
            "fillpattern": {
             "fillmode": "overlay",
             "size": 10,
             "solidity": 0.2
            },
            "type": "scatter"
           }
          ],
          "scatter3d": [
           {
            "line": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatter3d"
           }
          ],
          "scattercarpet": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattercarpet"
           }
          ],
          "scattergeo": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattergeo"
           }
          ],
          "scattergl": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattergl"
           }
          ],
          "scattermapbox": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattermapbox"
           }
          ],
          "scatterpolar": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterpolar"
           }
          ],
          "scatterpolargl": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterpolargl"
           }
          ],
          "scatterternary": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterternary"
           }
          ],
          "surface": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "surface"
           }
          ],
          "table": [
           {
            "cells": {
             "fill": {
              "color": "#EBF0F8"
             },
             "line": {
              "color": "white"
             }
            },
            "header": {
             "fill": {
              "color": "#C8D4E3"
             },
             "line": {
              "color": "white"
             }
            },
            "type": "table"
           }
          ]
         },
         "layout": {
          "annotationdefaults": {
           "arrowcolor": "#2a3f5f",
           "arrowhead": 0,
           "arrowwidth": 1
          },
          "autotypenumbers": "strict",
          "coloraxis": {
           "colorbar": {
            "outlinewidth": 0,
            "ticks": ""
           }
          },
          "colorscale": {
           "diverging": [
            [
             0,
             "#8e0152"
            ],
            [
             0.1,
             "#c51b7d"
            ],
            [
             0.2,
             "#de77ae"
            ],
            [
             0.3,
             "#f1b6da"
            ],
            [
             0.4,
             "#fde0ef"
            ],
            [
             0.5,
             "#f7f7f7"
            ],
            [
             0.6,
             "#e6f5d0"
            ],
            [
             0.7,
             "#b8e186"
            ],
            [
             0.8,
             "#7fbc41"
            ],
            [
             0.9,
             "#4d9221"
            ],
            [
             1,
             "#276419"
            ]
           ],
           "sequential": [
            [
             0,
             "#0d0887"
            ],
            [
             0.1111111111111111,
             "#46039f"
            ],
            [
             0.2222222222222222,
             "#7201a8"
            ],
            [
             0.3333333333333333,
             "#9c179e"
            ],
            [
             0.4444444444444444,
             "#bd3786"
            ],
            [
             0.5555555555555556,
             "#d8576b"
            ],
            [
             0.6666666666666666,
             "#ed7953"
            ],
            [
             0.7777777777777778,
             "#fb9f3a"
            ],
            [
             0.8888888888888888,
             "#fdca26"
            ],
            [
             1,
             "#f0f921"
            ]
           ],
           "sequentialminus": [
            [
             0,
             "#0d0887"
            ],
            [
             0.1111111111111111,
             "#46039f"
            ],
            [
             0.2222222222222222,
             "#7201a8"
            ],
            [
             0.3333333333333333,
             "#9c179e"
            ],
            [
             0.4444444444444444,
             "#bd3786"
            ],
            [
             0.5555555555555556,
             "#d8576b"
            ],
            [
             0.6666666666666666,
             "#ed7953"
            ],
            [
             0.7777777777777778,
             "#fb9f3a"
            ],
            [
             0.8888888888888888,
             "#fdca26"
            ],
            [
             1,
             "#f0f921"
            ]
           ]
          },
          "colorway": [
           "#636efa",
           "#EF553B",
           "#00cc96",
           "#ab63fa",
           "#FFA15A",
           "#19d3f3",
           "#FF6692",
           "#B6E880",
           "#FF97FF",
           "#FECB52"
          ],
          "font": {
           "color": "#2a3f5f"
          },
          "geo": {
           "bgcolor": "white",
           "lakecolor": "white",
           "landcolor": "#E5ECF6",
           "showlakes": true,
           "showland": true,
           "subunitcolor": "white"
          },
          "hoverlabel": {
           "align": "left"
          },
          "hovermode": "closest",
          "mapbox": {
           "style": "light"
          },
          "paper_bgcolor": "white",
          "plot_bgcolor": "#E5ECF6",
          "polar": {
           "angularaxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           },
           "bgcolor": "#E5ECF6",
           "radialaxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           }
          },
          "scene": {
           "xaxis": {
            "backgroundcolor": "#E5ECF6",
            "gridcolor": "white",
            "gridwidth": 2,
            "linecolor": "white",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "white"
           },
           "yaxis": {
            "backgroundcolor": "#E5ECF6",
            "gridcolor": "white",
            "gridwidth": 2,
            "linecolor": "white",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "white"
           },
           "zaxis": {
            "backgroundcolor": "#E5ECF6",
            "gridcolor": "white",
            "gridwidth": 2,
            "linecolor": "white",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "white"
           }
          },
          "shapedefaults": {
           "line": {
            "color": "#2a3f5f"
           }
          },
          "ternary": {
           "aaxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           },
           "baxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           },
           "bgcolor": "#E5ECF6",
           "caxis": {
            "gridcolor": "white",
            "linecolor": "white",
            "ticks": ""
           }
          },
          "title": {
           "x": 0.05
          },
          "xaxis": {
           "automargin": true,
           "gridcolor": "white",
           "linecolor": "white",
           "ticks": "",
           "title": {
            "standoff": 15
           },
           "zerolinecolor": "white",
           "zerolinewidth": 2
          },
          "yaxis": {
           "automargin": true,
           "gridcolor": "white",
           "linecolor": "white",
           "ticks": "",
           "title": {
            "standoff": 15
           },
           "zerolinecolor": "white",
           "zerolinewidth": 2
          }
         }
        },
        "title": {
         "text": "Top 5 destinations in France",
         "x": 0.5
        }
       }
      }
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import plotly.express as px\n",
    "fig = px.scatter_mapbox(best_destinations_lite, \n",
    "                        lat = \"lat_city\", lon = \"lon_city\", \n",
    "                        color = \"avg_temp\",\n",
    "                        size = \"avg_temp\",\n",
    "                        hover_name = \"city\",\n",
    "                        hover_data = {\"lat_city\": \":.2f\", \"lon_city\": \":.2f\", \"avg_temp\": \":.0f\"},\n",
    "                        mapbox_style = \"carto-positron\",\n",
    "                        zoom = 4,\n",
    "                        center = {'lat':46.232192999999995,'lon':2.209666999999996},\n",
    "                        color_continuous_scale=px.colors.sequential.Bluered)\n",
    "fig.update_layout(title_text = \"Top 5 destinations in France\", title_x = 0.5)\n",
    "fig.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}