random_variables.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "c4016278-a6f7-4b7e-94b7-3dddd75fa4cc",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import slugify\n",
    "import datetime as dt\n",
    "import json\n",
    "from IPython.display import Markdown as md\n",
    "%load_ext watermark\n",
    "\n",
    "def save_json(filename, data):\n",
    "    with open(f\"resources/{filename}\", \"w\") as afile:\n",
    "        json.dump(data, afile)\n",
    "\n",
    "def open_json(filename):\n",
    "    with open(f\"resources/{filename}\", \"r\") as afile:\n",
    "        data = json.load(afile)\n",
    "        return data\n",
    "\n",
    "# this defines the css rules for the note-book table displays\n",
    "header_row = {'selector': 'th:nth-child(1)', 'props': f'background-color: #FFF; text-align:right'}\n",
    "even_rows = {\"selector\": 'tr:nth-child(even)', 'props': f'background-color: rgba(139, 69, 19, 0.08);'}\n",
    "odd_rows = {'selector': 'tr:nth-child(odd)', 'props': 'background: #FFF;'}\n",
    "table_font = {'selector': 'tr', 'props': 'font-size: 10px;'}\n",
    "table_data = {'selector': 'td', 'props': 'padding: 6px;'}\n",
    "table_caption = {'selector': 'caption', 'props': 'font-size: 14px; font-style: italic; caption-side: bottom; text-align: left; margin-top: 10px'}\n",
    "table_large_data = {'selector': 'tr', 'props': 'font-size: 14px;'}\n",
    "\n",
    "\n",
    "table_css_styles = [even_rows, odd_rows, table_font, header_row, table_caption]\n",
    "table_large_font = [even_rows, odd_rows, table_large_data, header_row, table_caption]\n",
    "\n",
    "# this picks up the correct display names for the different languages\n",
    "display_names = open_json(\"french_display_names.json\")\n",
    "\n",
    "land_use_names = open_json(\"french_land_use_names.json\")\n",
    "\n",
    "material_names = open_json(\"french_material_names.json\")\n",
    "\n",
    "group_names = open_json(\"french_group_names.json\")\n",
    "\n",
    "french_names = open_json(\"french_code_translations.json\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3309912d-e4fe-41e5-ae28-439161fce5ae",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "# Les variables aléatoires\n",
    "\n",
    "Il s'agit de l'ensemble de données de base que vous pouvez obtenir une fois que vous avez supprimé les colonnes indésirables et appliqué un regroupement catégoriel. Ici, nous utilisons les groupes limités par la géographie, le temps, l'objet et l'ampleur.\n",
    "\n",
    "Les données ont été collectées par les organisations suivantes:\n",
    "\n",
    "1. hammerdirt\n",
    "2. Association Pour la Sauvegarde du Léman\n",
    "3. Precious Plastic Léman\n",
    "4. WWF Suisse\n",
    "5. Hackuarium\n",
    "6. Etudiants de Solid Waste Engineering, EPFL\n",
    "7. Summit foundation\n",
    "\n",
    "La source de ces données: https://github.com/hammerdirt-analyst/IQAASL-End-0f-Sampling-2021\n",
    "\n",
    "## Le contexte de l'observation\n",
    "\n",
    "Une fois les données collectées et agrégées, d'autres informations sont nécessaires pour les placer dans leur contexte par rapport aux autres observations.\n",
    "\n",
    "Dans ce modèle, les étiquettes sont largement utilisées. Les objets, les lieux et les attributs des objets et des lieux ont tous des étiquettes. Les étiquettes relatives à l'utilisation des sols correspondent au rapport entre l'attribut et l'espace disponible.\n",
    "\n",
    "\n",
    "\n",
    "```{attention}\n",
    "\n",
    "_À l'origine, cette méthode était destinée à la surveillance des déchets sur le littoral. L'application de cette méthode aux rivières et aux sentiers de montagne fait l'objet de la présente discussion._\n",
    "\n",
    "Avoir un consensus sur les descriptions d'objets et être discipliné dans les données enregistrées : c'est la meilleure façon de capturer les informations de l'observateur.\n",
    "\n",
    "* Une fois le consensus atteint, les ingénieurs peuvent se mettre au travail.\n",
    "\n",
    "* Il est plus facile de chercher quelque chose si vous savez ce que vous cherchez ou si vous savez ce qui est important.\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0e00533c-5fe9-4144-bdbb-8009412b60e6",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [],
   "source": [
    "# start variables\n",
    "# this is the observations from the begining of monitoring\n",
    "# to the end of the federal report from 2021. \n",
    "start_date, end_date = \"2015-11-15\", \"2022-12-31\"\n",
    "lake = 'lac-leman'\n",
    "catchment = 'rhone'\n",
    "some_quants = [.03, .25, .48, .5, .52, .75, .97]\n",
    "cantons = [\"Vaud\", \"Valais\", \"Genève\"]\n",
    "columns = ['loc_date', 'slug', 'city', 'water_name_slug', 'date', 'doy', 'Project',\n",
    "       'code', 'pcs/m', 'quantity', 'canton', 'zone',]\n",
    "\n",
    "wt_data = pd.read_csv(\"resources/survey_work_data.csv\", low_memory=False)\n",
    "cant_lib = wt_data[[\"slug\", \"canton\"]].drop_duplicates().set_index(\"slug\", drop=True)\n",
    "zone_lib =  wt_data[[\"slug\", \"zone\"]].drop_duplicates().set_index(\"slug\", drop=True)\n",
    "wt_data = wt_data[columns][wt_data.canton.isin(cantons)].copy()\n",
    "\n",
    "# codes and beaches\n",
    "dfCodes = pd.read_csv(\"resources/codes.csv\")\n",
    "dfBeaches = pd.read_csv(\"resources/beaches.csv\")\n",
    "# dfBeaches[\"zone\"] = dfBeaches.slug.apply(lambda x: zone_lib.loc[x, \"zone\"])\n",
    "# dfBeaches.to_csv(\"resources/beaches.csv\", index=False)\n",
    "dfBeaches.set_index(\"slug\", inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "72b32eb8-6d5a-412b-8c62-91f46b5238e9",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Résultats d'inventaire\n",
    "\n",
    "```{important}\n",
    "C'est ce qui est compté. La manière dont ces objets sont classés est un élément essentiel des données. C'est aussi la façon la plus simple de faire mesurer une valeur. Il est plus facile et plus rapide de le faire au moment de l'enquête.\n",
    "```\n",
    "#### Début: nov 2015, fin: décembre 2022"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a70fa0be-5a69-44e8-a1fe-836df8512186",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_806c3 tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_806c3 tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_806c3 tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_806c3 th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_806c3 caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_806c3\">\n",
       "  <caption>L'inventaire de base, jdl = jour de l'année. Échantillons est l'identifiant de l'inventaire, il connecte les objets au même inventaire. La quantité et les pcs/m sont les variables numériques pour chaque ligne. Le reste des colonnes sont des étiquettes.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_806c3_level0_col0\" class=\"col_heading level0 col0\" >échantillons</th>\n",
       "      <th id=\"T_806c3_level0_col1\" class=\"col_heading level0 col1\" >site</th>\n",
       "      <th id=\"T_806c3_level0_col2\" class=\"col_heading level0 col2\" >municipalités</th>\n",
       "      <th id=\"T_806c3_level0_col3\" class=\"col_heading level0 col3\" >zone d'intérêt</th>\n",
       "      <th id=\"T_806c3_level0_col4\" class=\"col_heading level0 col4\" >date</th>\n",
       "      <th id=\"T_806c3_level0_col5\" class=\"col_heading level0 col5\" >jdl</th>\n",
       "      <th id=\"T_806c3_level0_col6\" class=\"col_heading level0 col6\" >Projet</th>\n",
       "      <th id=\"T_806c3_level0_col7\" class=\"col_heading level0 col7\" >code</th>\n",
       "      <th id=\"T_806c3_level0_col8\" class=\"col_heading level0 col8\" >pcs/m</th>\n",
       "      <th id=\"T_806c3_level0_col9\" class=\"col_heading level0 col9\" >quantité</th>\n",
       "      <th id=\"T_806c3_level0_col10\" class=\"col_heading level0 col10\" >canton</th>\n",
       "      <th id=\"T_806c3_level0_col11\" class=\"col_heading level0 col11\" >zone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_806c3_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_806c3_row0_col0\" class=\"data row0 col0\" >('aubonne', '2022-02-06')</td>\n",
       "      <td id=\"T_806c3_row0_col1\" class=\"data row0 col1\" >aubonne</td>\n",
       "      <td id=\"T_806c3_row0_col2\" class=\"data row0 col2\" >Aubonne</td>\n",
       "      <td id=\"T_806c3_row0_col3\" class=\"data row0 col3\" >lac-leman</td>\n",
       "      <td id=\"T_806c3_row0_col4\" class=\"data row0 col4\" >2022-02-06</td>\n",
       "      <td id=\"T_806c3_row0_col5\" class=\"data row0 col5\" >37.000</td>\n",
       "      <td id=\"T_806c3_row0_col6\" class=\"data row0 col6\" >testing</td>\n",
       "      <td id=\"T_806c3_row0_col7\" class=\"data row0 col7\" >G10</td>\n",
       "      <td id=\"T_806c3_row0_col8\" class=\"data row0 col8\" >0.000</td>\n",
       "      <td id=\"T_806c3_row0_col9\" class=\"data row0 col9\" >0.000</td>\n",
       "      <td id=\"T_806c3_row0_col10\" class=\"data row0 col10\" >Vaud</td>\n",
       "      <td id=\"T_806c3_row0_col11\" class=\"data row0 col11\" >lac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_806c3_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_806c3_row1_col0\" class=\"data row1 col0\" >('aubonne', '2022-02-06')</td>\n",
       "      <td id=\"T_806c3_row1_col1\" class=\"data row1 col1\" >aubonne</td>\n",
       "      <td id=\"T_806c3_row1_col2\" class=\"data row1 col2\" >Aubonne</td>\n",
       "      <td id=\"T_806c3_row1_col3\" class=\"data row1 col3\" >lac-leman</td>\n",
       "      <td id=\"T_806c3_row1_col4\" class=\"data row1 col4\" >2022-02-06</td>\n",
       "      <td id=\"T_806c3_row1_col5\" class=\"data row1 col5\" >37.000</td>\n",
       "      <td id=\"T_806c3_row1_col6\" class=\"data row1 col6\" >testing</td>\n",
       "      <td id=\"T_806c3_row1_col7\" class=\"data row1 col7\" >G100</td>\n",
       "      <td id=\"T_806c3_row1_col8\" class=\"data row1 col8\" >0.000</td>\n",
       "      <td id=\"T_806c3_row1_col9\" class=\"data row1 col9\" >0.000</td>\n",
       "      <td id=\"T_806c3_row1_col10\" class=\"data row1 col10\" >Vaud</td>\n",
       "      <td id=\"T_806c3_row1_col11\" class=\"data row1 col11\" >lac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_806c3_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_806c3_row2_col0\" class=\"data row2 col0\" >('aubonne', '2022-02-06')</td>\n",
       "      <td id=\"T_806c3_row2_col1\" class=\"data row2 col1\" >aubonne</td>\n",
       "      <td id=\"T_806c3_row2_col2\" class=\"data row2 col2\" >Aubonne</td>\n",
       "      <td id=\"T_806c3_row2_col3\" class=\"data row2 col3\" >lac-leman</td>\n",
       "      <td id=\"T_806c3_row2_col4\" class=\"data row2 col4\" >2022-02-06</td>\n",
       "      <td id=\"T_806c3_row2_col5\" class=\"data row2 col5\" >37.000</td>\n",
       "      <td id=\"T_806c3_row2_col6\" class=\"data row2 col6\" >testing</td>\n",
       "      <td id=\"T_806c3_row2_col7\" class=\"data row2 col7\" >G101</td>\n",
       "      <td id=\"T_806c3_row2_col8\" class=\"data row2 col8\" >0.000</td>\n",
       "      <td id=\"T_806c3_row2_col9\" class=\"data row2 col9\" >0.000</td>\n",
       "      <td id=\"T_806c3_row2_col10\" class=\"data row2 col10\" >Vaud</td>\n",
       "      <td id=\"T_806c3_row2_col11\" class=\"data row2 col11\" >lac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_806c3_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_806c3_row3_col0\" class=\"data row3 col0\" >('aubonne', '2022-02-06')</td>\n",
       "      <td id=\"T_806c3_row3_col1\" class=\"data row3 col1\" >aubonne</td>\n",
       "      <td id=\"T_806c3_row3_col2\" class=\"data row3 col2\" >Aubonne</td>\n",
       "      <td id=\"T_806c3_row3_col3\" class=\"data row3 col3\" >lac-leman</td>\n",
       "      <td id=\"T_806c3_row3_col4\" class=\"data row3 col4\" >2022-02-06</td>\n",
       "      <td id=\"T_806c3_row3_col5\" class=\"data row3 col5\" >37.000</td>\n",
       "      <td id=\"T_806c3_row3_col6\" class=\"data row3 col6\" >testing</td>\n",
       "      <td id=\"T_806c3_row3_col7\" class=\"data row3 col7\" >G103</td>\n",
       "      <td id=\"T_806c3_row3_col8\" class=\"data row3 col8\" >0.020</td>\n",
       "      <td id=\"T_806c3_row3_col9\" class=\"data row3 col9\" >1.000</td>\n",
       "      <td id=\"T_806c3_row3_col10\" class=\"data row3 col10\" >Vaud</td>\n",
       "      <td id=\"T_806c3_row3_col11\" class=\"data row3 col11\" >lac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_806c3_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_806c3_row4_col0\" class=\"data row4 col0\" >('aubonne', '2022-02-06')</td>\n",
       "      <td id=\"T_806c3_row4_col1\" class=\"data row4 col1\" >aubonne</td>\n",
       "      <td id=\"T_806c3_row4_col2\" class=\"data row4 col2\" >Aubonne</td>\n",
       "      <td id=\"T_806c3_row4_col3\" class=\"data row4 col3\" >lac-leman</td>\n",
       "      <td id=\"T_806c3_row4_col4\" class=\"data row4 col4\" >2022-02-06</td>\n",
       "      <td id=\"T_806c3_row4_col5\" class=\"data row4 col5\" >37.000</td>\n",
       "      <td id=\"T_806c3_row4_col6\" class=\"data row4 col6\" >testing</td>\n",
       "      <td id=\"T_806c3_row4_col7\" class=\"data row4 col7\" >G106</td>\n",
       "      <td id=\"T_806c3_row4_col8\" class=\"data row4 col8\" >0.100</td>\n",
       "      <td id=\"T_806c3_row4_col9\" class=\"data row4 col9\" >5.000</td>\n",
       "      <td id=\"T_806c3_row4_col10\" class=\"data row4 col10\" >Vaud</td>\n",
       "      <td id=\"T_806c3_row4_col11\" class=\"data row4 col11\" >lac</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c97ba74c0>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "caption = \"L'inventaire de base, jdl = jour de l'année. Échantillons est l'identifiant de \\\n",
    "l'inventaire, il connecte les objets au même inventaire. La quantité \\\n",
    "et les pcs/m sont les variables numériques pour chaque ligne. Le \\\n",
    "reste des colonnes sont des étiquettes.\"\n",
    "\n",
    "combined_d = wt_data.rename(columns=display_names)\n",
    "\n",
    "combined_d[combined_d.zone == \"lac\"].head().style.set_table_styles(table_large_font).set_caption(caption).format(precision=3)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f8619e61-24ec-4453-bbf5-49faf9ac3fd0",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Détails du site d'inventaire\n",
    "\n",
    "Celui-ci contient les détails de localisation tels que le GPS, le bassin fluvial de la ville, etc. Une grande partie a déjà été ajoutée aux données pour le travail. Cependant, les noms propres peuvent être extraits et des attributs peuvent être ajoutés à cet ensemble, puis appliqués.\n",
    "\n",
    "La localisation GPS constitue le centre d'un hexagone de 3 000 mètres. La configuration de l'utilisation du sol pour chaque emplacement est configurée à partir de ce point.\n",
    "\n",
    "```{note}\n",
    "Les données utilisées pour identifier un emplacement sont définies sur la manière dont les informations vont être utilisées. C’est également un moyen simple d’améliorer le flux de données une fois les exigences comprises.\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "1f7a41a4-2bcb-4d23-9576-780f9aed0638",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_6f200 tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_6f200 tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_6f200 tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_6f200 th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_6f200 caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_6f200\">\n",
       "  <caption>Détails de localisation des plages du Léman. Des attributs peuvent être ajoutés à cet ensemble de données et transmis ultérieurement si nécessaire. Pour l'instant, les caractéristiques topographiques sont stockées sur un autre ensemble de données partageant le même index.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_6f200_level0_col0\" class=\"col_heading level0 col0\" >site</th>\n",
       "      <th id=\"T_6f200_level0_col1\" class=\"col_heading level0 col1\" >latitude</th>\n",
       "      <th id=\"T_6f200_level0_col2\" class=\"col_heading level0 col2\" >longitude</th>\n",
       "      <th id=\"T_6f200_level0_col3\" class=\"col_heading level0 col3\" >zone d'interêt</th>\n",
       "      <th id=\"T_6f200_level0_col4\" class=\"col_heading level0 col4\" >municipalités</th>\n",
       "      <th id=\"T_6f200_level0_col5\" class=\"col_heading level0 col5\" >bassin versant</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_6f200_level0_row0\" class=\"row_heading level0 row0\" >aubonne</th>\n",
       "      <td id=\"T_6f200_row0_col0\" class=\"data row0 col0\" >Aubonne</td>\n",
       "      <td id=\"T_6f200_row0_col1\" class=\"data row0 col1\" >46.460</td>\n",
       "      <td id=\"T_6f200_row0_col2\" class=\"data row0 col2\" >6.391</td>\n",
       "      <td id=\"T_6f200_row0_col3\" class=\"data row0 col3\" >Lac Léman</td>\n",
       "      <td id=\"T_6f200_row0_col4\" class=\"data row0 col4\" >Aubonne</td>\n",
       "      <td id=\"T_6f200_row0_col5\" class=\"data row0 col5\" >rhone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6f200_level0_row1\" class=\"row_heading level0 row1\" >baby-plage</th>\n",
       "      <td id=\"T_6f200_row1_col0\" class=\"data row1 col0\" >Baby Plage</td>\n",
       "      <td id=\"T_6f200_row1_col1\" class=\"data row1 col1\" >46.209</td>\n",
       "      <td id=\"T_6f200_row1_col2\" class=\"data row1 col2\" >6.163</td>\n",
       "      <td id=\"T_6f200_row1_col3\" class=\"data row1 col3\" >Lac Léman</td>\n",
       "      <td id=\"T_6f200_row1_col4\" class=\"data row1 col4\" >Genève</td>\n",
       "      <td id=\"T_6f200_row1_col5\" class=\"data row1 col5\" >rhone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6f200_level0_row2\" class=\"row_heading level0 row2\" >bouveret</th>\n",
       "      <td id=\"T_6f200_row2_col0\" class=\"data row2 col0\" >Bouveret</td>\n",
       "      <td id=\"T_6f200_row2_col1\" class=\"data row2 col1\" >46.389</td>\n",
       "      <td id=\"T_6f200_row2_col2\" class=\"data row2 col2\" >6.860</td>\n",
       "      <td id=\"T_6f200_row2_col3\" class=\"data row2 col3\" >Lac Léman</td>\n",
       "      <td id=\"T_6f200_row2_col4\" class=\"data row2 col4\" >Bouveret</td>\n",
       "      <td id=\"T_6f200_row2_col5\" class=\"data row2 col5\" >rhone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6f200_level0_row3\" class=\"row_heading level0 row3\" >clarens</th>\n",
       "      <td id=\"T_6f200_row3_col0\" class=\"data row3 col0\" >Clarens</td>\n",
       "      <td id=\"T_6f200_row3_col1\" class=\"data row3 col1\" >46.439</td>\n",
       "      <td id=\"T_6f200_row3_col2\" class=\"data row3 col2\" >6.890</td>\n",
       "      <td id=\"T_6f200_row3_col3\" class=\"data row3 col3\" >Lac Léman</td>\n",
       "      <td id=\"T_6f200_row3_col4\" class=\"data row3 col4\" >Clarens</td>\n",
       "      <td id=\"T_6f200_row3_col5\" class=\"data row3 col5\" >rhone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6f200_level0_row4\" class=\"row_heading level0 row4\" >crans</th>\n",
       "      <td id=\"T_6f200_row4_col0\" class=\"data row4 col0\" >Crans</td>\n",
       "      <td id=\"T_6f200_row4_col1\" class=\"data row4 col1\" >46.355</td>\n",
       "      <td id=\"T_6f200_row4_col2\" class=\"data row4 col2\" >6.214</td>\n",
       "      <td id=\"T_6f200_row4_col3\" class=\"data row4 col3\" >Lac Léman</td>\n",
       "      <td id=\"T_6f200_row4_col4\" class=\"data row4 col4\" >Crans</td>\n",
       "      <td id=\"T_6f200_row4_col5\" class=\"data row4 col5\" >rhone</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c97b99670>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "beach_columns = ['location', 'latitude', 'longitude',\n",
    "       'water_name', 'city',\n",
    "       'river_bassin']\n",
    "\n",
    "caption = \"Détails de localisation des plages du Léman. Des attributs \\\n",
    "peuvent être ajoutés à cet ensemble de données et transmis ultérieurement \\\n",
    "si nécessaire. Pour l'instant, les caractéristiques topographiques sont \\\n",
    "stockées sur un autre ensemble de données partageant le même index.\"\n",
    "dfBeaches.index.name = None\n",
    "\n",
    "    \n",
    "dfBeaches[beach_columns].rename(columns=display_names).head().style.set_table_styles(table_large_font).set_caption(caption).format(precision=3)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3100ca68-669f-43b8-9969-c89017de2a58",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Catégories d'objets\n",
    "\n",
    "Les catégories d'objets correspondent à la manière dont la personne transmet l'observation à l'appareil. La description et le nom du groupe permettent aux administrations régionales d'obtenir davantage d'informations à partir des données.\n",
    "\n",
    "```{note}\n",
    "En créant des groupes d'objets qui représentent des cas d'utilisation, il peut être plus facile pour les acteurs régionaux d'identifier les priorités. Il s'agit peut-être de la meilleure voie de discussion entre les acteurs régionaux. Si les catégories d'objets ou les groupes correspondent à des priorités communes, les communications peuvent être simplifiées.\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e7782708-95a7-4df9-9c3b-58f4a92a84ea",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_00fc8 tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_00fc8 tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_00fc8 tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_00fc8 th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_00fc8 caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_00fc8\">\n",
       "  <caption>Tableau d'informations sur les objets. Nous pouvons ajouter des codes spécifiques à une région. Par exemple nous ajoutons le code G708 pour les bâtons de ski. Ils ne sont pas communs au bord des lacs mais on les trouve en montagne. Un autre exemple est celui des contenants d’appâts aux phéromones. Ils sont utilisés dans les vignobles et on les retrouve là où se concentrent les vignobles.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_00fc8_level0_col0\" class=\"col_heading level0 col0\" >matériel</th>\n",
       "      <th id=\"T_00fc8_level0_col1\" class=\"col_heading level0 col1\" >description</th>\n",
       "      <th id=\"T_00fc8_level0_col2\" class=\"col_heading level0 col2\" >code de base</th>\n",
       "      <th id=\"T_00fc8_level0_col3\" class=\"col_heading level0 col3\" >groupe</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_00fc8_level0_row0\" class=\"row_heading level0 row0\" >G708</th>\n",
       "      <td id=\"T_00fc8_row0_col0\" class=\"data row0 col0\" >Métal</td>\n",
       "      <td id=\"T_00fc8_row0_col1\" class=\"data row0 col1\" >Batons de ski</td>\n",
       "      <td id=\"T_00fc8_row0_col2\" class=\"data row0 col2\" >G199</td>\n",
       "      <td id=\"T_00fc8_row0_col3\" class=\"data row0 col3\" >loisirs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_00fc8_level0_row1\" class=\"row_heading level0 row1\" >G212</th>\n",
       "      <td id=\"T_00fc8_row1_col0\" class=\"data row1 col0\" >Produit chimiques</td>\n",
       "      <td id=\"T_00fc8_row1_col1\" class=\"data row1 col1\" >Nodules de petrol</td>\n",
       "      <td id=\"T_00fc8_row1_col2\" class=\"data row1 col2\" >Parent code</td>\n",
       "      <td id=\"T_00fc8_row1_col3\" class=\"data row1 col3\" >non définie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_00fc8_level0_row2\" class=\"row_heading level0 row2\" >G213</th>\n",
       "      <td id=\"T_00fc8_row2_col0\" class=\"data row2 col0\" >Produit chimiques</td>\n",
       "      <td id=\"T_00fc8_row2_col1\" class=\"data row2 col1\" >Paraffine</td>\n",
       "      <td id=\"T_00fc8_row2_col2\" class=\"data row2 col2\" >Parent code</td>\n",
       "      <td id=\"T_00fc8_row2_col3\" class=\"data row2 col3\" >loisirs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_00fc8_level0_row3\" class=\"row_heading level0 row3\" >G214</th>\n",
       "      <td id=\"T_00fc8_row3_col0\" class=\"data row3 col0\" >Produit chimiques</td>\n",
       "      <td id=\"T_00fc8_row3_col1\" class=\"data row3 col1\" >Goudron</td>\n",
       "      <td id=\"T_00fc8_row3_col2\" class=\"data row3 col2\" >Parent code</td>\n",
       "      <td id=\"T_00fc8_row3_col3\" class=\"data row3 col3\" >infrastructures</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_00fc8_level0_row4\" class=\"row_heading level0 row4\" >G135</th>\n",
       "      <td id=\"T_00fc8_row4_col0\" class=\"data row4 col0\" >Textiles</td>\n",
       "      <td id=\"T_00fc8_row4_col1\" class=\"data row4 col1\" >Vêtements, chaussures, chapeaux et gants</td>\n",
       "      <td id=\"T_00fc8_row4_col2\" class=\"data row4 col2\" >Parent code</td>\n",
       "      <td id=\"T_00fc8_row4_col3\" class=\"data row4 col3\" >articles personnels</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c97b1e3a0>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "caption = \"Tableau d'informations sur les objets. Nous pouvons ajouter des codes spécifiques à \\\n",
    "une région. Par exemple nous ajoutons le code G708 pour les bâtons de ski. \\\n",
    "Ils ne sont pas communs au bord des lacs mais on les trouve en montagne. \\\n",
    "Un autre exemple est celui des contenants d’appâts aux phéromones. \\\n",
    "Ils sont utilisés dans les vignobles et on les retrouve là où se concentrent les vignobles.\"\n",
    "\n",
    "# translate code data to language of choice\n",
    "dfCodes[\"material\"] = dfCodes.material.map(lambda x: material_names[x])\n",
    "dfCodes[\"description\"] = dfCodes.code.apply(lambda x: french_names[x])\n",
    "dfCodes[\"groupname\"] = dfCodes.groupname.apply(lambda x: group_names[x])\n",
    "\n",
    "dfCodes.set_index(\"code\", inplace=True)\n",
    "dfCodes.index.name = None\n",
    "\n",
    "dfCodes.rename(columns=display_names).head().style.set_table_styles(table_large_font).set_caption(caption)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b8d4da79-6777-4af8-aab0-2dc6834af6b1",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Utilisation du sol\n",
    "\n",
    "Il s’agit de l’ampleur des caractéristiques topographiques trouvées dans un rayon de 1 500 du lieu d’enquête. La source est la collection de cartes swissTLMRegio. Une superposition hexagonale est appliquée aux couches de couverture terrestre et d’utilisation des terres. Ensuite, le contenu de chaque hex est enregistré en mètres² ou en mètres linéaires.\n",
    "\n",
    "Ce processus a montré des corrélations entre l'ampleur des résultats de l'enquête pour certains objets et l'ampleur de l'élément topographique. Ce processus a été expliqué dans [Near of Far](https://hammerdirt-analyst.github.io/landuse/probability.html) et  [Land use profile](https://hammerdirt-analyst.github.io/IQAASL-End-0f-Sampling-2021/land_use_correlation.html).\n",
    "\n",
    "L'ampleur de l'élément topographique et sa valeur mise à l'échelle sont disponibles. Les données ont été séparées en groupes percentiles. Il existe 21 groupes, un groupe étant destiné au cas où la caractéristique d'utilisation des terres n'est pas présente, puis un groupe pour chaque cinquième percentile.\n",
    "\n",
    "```{note}\n",
    "\n",
    "Pour cette phase initiale, seules les couches cartographiques de base ont été utilisées. Pour les partenaires intéressés, l’une des couches cartographiques de[TLMRegio](https://www.swisstopo.admin.ch/de/geodata/landscape/tlmregio.html) fonctionnera sur ces données. Cela permet aux équipes indépendantes d’utiliser plus facilement les résultats pour des besoins spécifiques.\n",
    "\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "01793466-f425-4b34-ad3e-533d173a0417",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_50b97 tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_50b97 tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_50b97 tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_50b97 th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_50b97 caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_50b97\">\n",
       "  <caption>Le profil d'occupation du sol de la tiger-duck-beach à Saint Sulpice. Rappelez-vous que la grandeur des rues est en mètres, tout le reste est en mètres carrés. La quantité de terre sèche est donnée en mètres², normalisée étant le résultat de la magnitude/terre sèche. Rang est le classement de cette caractéristique d'utilisation des sols (0 - 20).</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_50b97_level0_col0\" class=\"col_heading level0 col0\" >normalisée</th>\n",
       "      <th id=\"T_50b97_level0_col1\" class=\"col_heading level0 col1\" >terre sèche</th>\n",
       "      <th id=\"T_50b97_level0_col2\" class=\"col_heading level0 col2\" >magnitude</th>\n",
       "      <th id=\"T_50b97_level0_col3\" class=\"col_heading level0 col3\" >rang</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_50b97_level0_row0\" class=\"row_heading level0 row0\" >rues</th>\n",
       "      <td id=\"T_50b97_row0_col0\" class=\"data row0 col0\" >0.142</td>\n",
       "      <td id=\"T_50b97_row0_col1\" class=\"data row0 col1\" >0</td>\n",
       "      <td id=\"T_50b97_row0_col2\" class=\"data row0 col2\" >35,120</td>\n",
       "      <td id=\"T_50b97_row0_col3\" class=\"data row0 col3\" >3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_50b97_level0_row1\" class=\"row_heading level0 row1\" >bâtiments</th>\n",
       "      <td id=\"T_50b97_row1_col0\" class=\"data row1 col0\" >0.272</td>\n",
       "      <td id=\"T_50b97_row1_col1\" class=\"data row1 col1\" >2,866,568</td>\n",
       "      <td id=\"T_50b97_row1_col2\" class=\"data row1 col2\" >781,085</td>\n",
       "      <td id=\"T_50b97_row1_col3\" class=\"data row1 col3\" >6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_50b97_level0_row2\" class=\"row_heading level0 row2\" >centre ville</th>\n",
       "      <td id=\"T_50b97_row2_col0\" class=\"data row2 col0\" >0.0</td>\n",
       "      <td id=\"T_50b97_row2_col1\" class=\"data row2 col1\" >0</td>\n",
       "      <td id=\"T_50b97_row2_col2\" class=\"data row2 col2\" >0</td>\n",
       "      <td id=\"T_50b97_row2_col3\" class=\"data row2 col3\" >0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_50b97_level0_row3\" class=\"row_heading level0 row3\" >forêt</th>\n",
       "      <td id=\"T_50b97_row3_col0\" class=\"data row3 col0\" >0.48</td>\n",
       "      <td id=\"T_50b97_row3_col1\" class=\"data row3 col1\" >2,866,568</td>\n",
       "      <td id=\"T_50b97_row3_col2\" class=\"data row3 col2\" >1,377,375</td>\n",
       "      <td id=\"T_50b97_row3_col3\" class=\"data row3 col3\" >10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_50b97_level0_row4\" class=\"row_heading level0 row4\" >vergers</th>\n",
       "      <td id=\"T_50b97_row4_col0\" class=\"data row4 col0\" >0.0</td>\n",
       "      <td id=\"T_50b97_row4_col1\" class=\"data row4 col1\" >0</td>\n",
       "      <td id=\"T_50b97_row4_col2\" class=\"data row4 col2\" >0</td>\n",
       "      <td id=\"T_50b97_row4_col3\" class=\"data row4 col3\" >0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_50b97_level0_row5\" class=\"row_heading level0 row5\" >vignobles</th>\n",
       "      <td id=\"T_50b97_row5_col0\" class=\"data row5 col0\" >0.0</td>\n",
       "      <td id=\"T_50b97_row5_col1\" class=\"data row5 col1\" >0</td>\n",
       "      <td id=\"T_50b97_row5_col2\" class=\"data row5 col2\" >0</td>\n",
       "      <td id=\"T_50b97_row5_col3\" class=\"data row5 col3\" >0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_50b97_level0_row6\" class=\"row_heading level0 row6\" >infrastructure</th>\n",
       "      <td id=\"T_50b97_row6_col0\" class=\"data row6 col0\" >0.015</td>\n",
       "      <td id=\"T_50b97_row6_col1\" class=\"data row6 col1\" >2,866,568</td>\n",
       "      <td id=\"T_50b97_row6_col2\" class=\"data row6 col2\" >42,872</td>\n",
       "      <td id=\"T_50b97_row6_col3\" class=\"data row6 col3\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_50b97_level0_row7\" class=\"row_heading level0 row7\" >récréation</th>\n",
       "      <td id=\"T_50b97_row7_col0\" class=\"data row7 col0\" >0.033</td>\n",
       "      <td id=\"T_50b97_row7_col1\" class=\"data row7 col1\" >2,866,568</td>\n",
       "      <td id=\"T_50b97_row7_col2\" class=\"data row7 col2\" >95,027</td>\n",
       "      <td id=\"T_50b97_row7_col3\" class=\"data row7 col3\" >1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_50b97_level0_row8\" class=\"row_heading level0 row8\" >non définie</th>\n",
       "      <td id=\"T_50b97_row8_col0\" class=\"data row8 col0\" >0.247</td>\n",
       "      <td id=\"T_50b97_row8_col1\" class=\"data row8 col1\" >2,866,568</td>\n",
       "      <td id=\"T_50b97_row8_col2\" class=\"data row8 col2\" >708,108</td>\n",
       "      <td id=\"T_50b97_row8_col3\" class=\"data row8 col3\" >5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c97b33e20>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "land_use = pd.read_csv(\"resources/work_land_use.csv\")\n",
    "\n",
    "caption = \"Le profil d'occupation du sol de la tiger-duck-beach à \\\n",
    "Saint Sulpice. Rappelez-vous que la grandeur des rues est en mètres, \\\n",
    "tout le reste est en mètres carrés. La quantité de terre sèche est \\\n",
    "donnée en mètres², normalisée étant le résultat de la magnitude/terre sèche. \\\n",
    "Rang est le classement de cette caractéristique d'utilisation des sols (0 - 20).\"\n",
    "\n",
    "index_order = [\n",
    "    'rues',\n",
    "    'bâtiments',\n",
    "    'centre ville',\n",
    "    'forêt', \n",
    "    'vergers',\n",
    "    'vignobles',\n",
    "    'infrastructure', \n",
    "    'récréation',\n",
    "    'non définie',  \n",
    "   \n",
    "]\n",
    "\n",
    "\n",
    "# display land use for one location\n",
    "lud = land_use[land_use.slug == \"grand-clos\"].rename(columns=display_names)\n",
    "lud = lud[~lud.utilisation.isin([\"See\", \"dist\", \"length\"])].copy()\n",
    "lud[\"rang\"] = lud.rang.astype(int)\n",
    "lud[\"magnitude\"] = lud.magnitude.astype(int)\n",
    "lud[\"utilisation\"] = lud[\"utilisation\"].apply(lambda x: land_use_names[x])\n",
    "lud[\"normalisée\"] = lud[\"normalisée\"].round(3)\n",
    "lud.set_index(\"utilisation\", inplace=True)\n",
    "lud = lud.reindex(index_order)\n",
    "lud.drop(\"site\", axis=1, inplace=True)\n",
    "lud.index.name = None\n",
    "lud.style.set_table_styles(table_large_font).set_caption(caption).format('{:,}')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cde78e60-4703-4fd4-b59e-0a164cfb5313",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Cantonal\n",
    "\n",
    "La situation géographique ciblée. Cependant, les échantillons du Rhône et du Léman partagent des origines communes. Pour le Léman les échantillons du Valais représentent 5% de tous les échantillons et 12% en quantité.\n",
    "\n",
    "```{note}\n",
    "Cela devrait affecter les décisions d’échantillonnage au niveau régional. Pour le Valais le bilan n'est pas correct compte tenu des kilomètres du Rhône.\n",
    "\n",
    "Il existe cependant un consensus entre 2021 et 2022 en référence aux valeurs élevées à l'embouchure du Rhône.\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "8a68b612-ee59-472e-96c0-15c92429112a",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_b760b tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_b760b tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_b760b tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_b760b th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_b760b caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_b760b\">\n",
       "  <caption>Nous comptons 96 320 objets pour la période indiquée. De 25 villes. Il y avait 319 échantillons provenant de 56 sites.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_b760b_level0_col0\" class=\"col_heading level0 col0\" >quantité</th>\n",
       "      <th id=\"T_b760b_level0_col1\" class=\"col_heading level0 col1\" >municipalités</th>\n",
       "      <th id=\"T_b760b_level0_col2\" class=\"col_heading level0 col2\" >échantillons</th>\n",
       "      <th id=\"T_b760b_level0_col3\" class=\"col_heading level0 col3\" >site</th>\n",
       "      <th id=\"T_b760b_level0_col4\" class=\"col_heading level0 col4\" >% de totale</th>\n",
       "      <th id=\"T_b760b_level0_col5\" class=\"col_heading level0 col5\" >% des échantillons</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_b760b_level0_row0\" class=\"row_heading level0 row0\" >Genève</th>\n",
       "      <td id=\"T_b760b_row0_col0\" class=\"data row0 col0\" >12,479</td>\n",
       "      <td id=\"T_b760b_row0_col1\" class=\"data row0 col1\" >4</td>\n",
       "      <td id=\"T_b760b_row0_col2\" class=\"data row0 col2\" >50</td>\n",
       "      <td id=\"T_b760b_row0_col3\" class=\"data row0 col3\" >11</td>\n",
       "      <td id=\"T_b760b_row0_col4\" class=\"data row0 col4\" >0.13</td>\n",
       "      <td id=\"T_b760b_row0_col5\" class=\"data row0 col5\" >0.157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_b760b_level0_row1\" class=\"row_heading level0 row1\" >Valais</th>\n",
       "      <td id=\"T_b760b_row1_col0\" class=\"data row1 col0\" >12,193</td>\n",
       "      <td id=\"T_b760b_row1_col1\" class=\"data row1 col1\" >2</td>\n",
       "      <td id=\"T_b760b_row1_col2\" class=\"data row1 col2\" >17</td>\n",
       "      <td id=\"T_b760b_row1_col3\" class=\"data row1 col3\" >2</td>\n",
       "      <td id=\"T_b760b_row1_col4\" class=\"data row1 col4\" >0.127</td>\n",
       "      <td id=\"T_b760b_row1_col5\" class=\"data row1 col5\" >0.053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_b760b_level0_row2\" class=\"row_heading level0 row2\" >Vaud</th>\n",
       "      <td id=\"T_b760b_row2_col0\" class=\"data row2 col0\" >71,645</td>\n",
       "      <td id=\"T_b760b_row2_col1\" class=\"data row2 col1\" >19</td>\n",
       "      <td id=\"T_b760b_row2_col2\" class=\"data row2 col2\" >252</td>\n",
       "      <td id=\"T_b760b_row2_col3\" class=\"data row2 col3\" >43</td>\n",
       "      <td id=\"T_b760b_row2_col4\" class=\"data row2 col4\" >0.744</td>\n",
       "      <td id=\"T_b760b_row2_col5\" class=\"data row2 col5\" >0.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_b760b_level0_row3\" class=\"row_heading level0 row3\" >Total</th>\n",
       "      <td id=\"T_b760b_row3_col0\" class=\"data row3 col0\" >96,317</td>\n",
       "      <td id=\"T_b760b_row3_col1\" class=\"data row3 col1\" >25</td>\n",
       "      <td id=\"T_b760b_row3_col2\" class=\"data row3 col2\" >319</td>\n",
       "      <td id=\"T_b760b_row3_col3\" class=\"data row3 col3\" >56</td>\n",
       "      <td id=\"T_b760b_row3_col4\" class=\"data row3 col4\" >1.001</td>\n",
       "      <td id=\"T_b760b_row3_col5\" class=\"data row3 col5\" >1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c97ba7340>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# the values to be compared\n",
    "operation = {\"quantity\":\"sum\", \"city\":\"nunique\", \"loc_date\":\"nunique\", \"slug\":\"nunique\"}\n",
    "\n",
    "# lac leman only:\n",
    "combined = wt_data[(wt_data.canton.isin(cantons))&(wt_data.zone == \"lac\")].copy()\n",
    "\n",
    "# the totals for all the data\n",
    "totals = combined.agg(operation)\n",
    "\n",
    "# the totals for each canton\n",
    "canton = combined.groupby(\"canton\").agg(operation)\n",
    "\n",
    "# the contribution of each canton to the total\n",
    "canton[\"q_weight\"] = (canton.quantity/totals.quantity).round(3)\n",
    "\n",
    "# the number of samples contributed to the project by canton\n",
    "canton[\"s_weight\"] = (canton.loc_date/totals.loc_date).round(3)\n",
    "\n",
    "# sum accross the bottom\n",
    "canton.loc[\"Total\"] = canton.sum()\n",
    "canton[list(operation.keys())] = canton[operation.keys()].astype(\"int\")\n",
    "canton.index.name = None\n",
    "\n",
    "caption = \"Nous comptons 96 320 objets pour la période indiquée. \\\n",
    "De 25 villes. Il y avait 319 échantillons provenant de 56 sites.\"\n",
    "\n",
    "canton.rename(columns=display_names).style.set_table_styles(table_large_font).format('{:,}').set_caption(caption)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f5734c48-4d57-4efa-a0c2-222c33818681",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Régional\n",
    "\n",
    "Ces étiquettes sont une façon de diviser le lac. Le transport et le dépôt d'objets dans ces zones peuvent avoir une importance régionale. Si tel est le cas, le Valais est un contributeur important."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "09f18b4f-e78a-4db4-8655-73e8c9b118f5",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_f5f73 tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_f5f73 tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_f5f73 tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_f5f73 th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_f5f73 caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_f5f73\">\n",
       "  <caption>Les noms régionaux représentent différentes caractéristiques hydrologiques ainsi que des différences géographiques.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_f5f73_level0_col0\" class=\"col_heading level0 col0\" >quantité</th>\n",
       "      <th id=\"T_f5f73_level0_col1\" class=\"col_heading level0 col1\" >municipalités</th>\n",
       "      <th id=\"T_f5f73_level0_col2\" class=\"col_heading level0 col2\" >échantillons</th>\n",
       "      <th id=\"T_f5f73_level0_col3\" class=\"col_heading level0 col3\" >site</th>\n",
       "      <th id=\"T_f5f73_level0_col4\" class=\"col_heading level0 col4\" >% de totale</th>\n",
       "      <th id=\"T_f5f73_level0_col5\" class=\"col_heading level0 col5\" >% des échantillons</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_f5f73_level0_row0\" class=\"row_heading level0 row0\" >Grand lac</th>\n",
       "      <td id=\"T_f5f73_row0_col0\" class=\"data row0 col0\" >24,385</td>\n",
       "      <td id=\"T_f5f73_row0_col1\" class=\"data row0 col1\" >10</td>\n",
       "      <td id=\"T_f5f73_row0_col2\" class=\"data row0 col2\" >83</td>\n",
       "      <td id=\"T_f5f73_row0_col3\" class=\"data row0 col3\" >21</td>\n",
       "      <td id=\"T_f5f73_row0_col4\" class=\"data row0 col4\" >0.253</td>\n",
       "      <td id=\"T_f5f73_row0_col5\" class=\"data row0 col5\" >0.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5f73_level0_row1\" class=\"row_heading level0 row1\" >Haut lac</th>\n",
       "      <td id=\"T_f5f73_row1_col0\" class=\"data row1 col0\" >57,742</td>\n",
       "      <td id=\"T_f5f73_row1_col1\" class=\"data row1 col1\" >9</td>\n",
       "      <td id=\"T_f5f73_row1_col2\" class=\"data row1 col2\" >157</td>\n",
       "      <td id=\"T_f5f73_row1_col3\" class=\"data row1 col3\" >20</td>\n",
       "      <td id=\"T_f5f73_row1_col4\" class=\"data row1 col4\" >0.599</td>\n",
       "      <td id=\"T_f5f73_row1_col5\" class=\"data row1 col5\" >0.492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5f73_level0_row2\" class=\"row_heading level0 row2\" >Petit lac</th>\n",
       "      <td id=\"T_f5f73_row2_col0\" class=\"data row2 col0\" >14,190</td>\n",
       "      <td id=\"T_f5f73_row2_col1\" class=\"data row2 col1\" >6</td>\n",
       "      <td id=\"T_f5f73_row2_col2\" class=\"data row2 col2\" >79</td>\n",
       "      <td id=\"T_f5f73_row2_col3\" class=\"data row2 col3\" >15</td>\n",
       "      <td id=\"T_f5f73_row2_col4\" class=\"data row2 col4\" >0.147</td>\n",
       "      <td id=\"T_f5f73_row2_col5\" class=\"data row2 col5\" >0.248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f5f73_level0_row3\" class=\"row_heading level0 row3\" >Total</th>\n",
       "      <td id=\"T_f5f73_row3_col0\" class=\"data row3 col0\" >96,317</td>\n",
       "      <td id=\"T_f5f73_row3_col1\" class=\"data row3 col1\" >25</td>\n",
       "      <td id=\"T_f5f73_row3_col2\" class=\"data row3 col2\" >319</td>\n",
       "      <td id=\"T_f5f73_row3_col3\" class=\"data row3 col3\" >56</td>\n",
       "      <td id=\"T_f5f73_row3_col4\" class=\"data row3 col4\" >0.999</td>\n",
       "      <td id=\"T_f5f73_row3_col5\" class=\"data row3 col5\" >1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c965e6f70>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# the way the data is separated is analysis dependent\n",
    "# this splits the lake up into three regions\n",
    "regions = pd.read_csv(\"resources/lac_leman_regions.csv\")\n",
    "regions.drop_duplicates(inplace=True)\n",
    "rg_map = regions.set_index(\"slug\")\n",
    "\n",
    "combined[\"region\"] = combined.slug.apply(lambda x: rg_map.loc[x, \"alabel\"])\n",
    "combined[\"zone\"] = \"lac\"\n",
    "\n",
    "# group by region \n",
    "regional = combined.groupby(\"region\").agg(operation)\n",
    "\n",
    "# get the weight of each region to the total\n",
    "regional[\"q_weight\"] = (regional.quantity/totals.quantity).round(3)\n",
    "regional[\"s_weight\"] = (regional.loc_date/totals.loc_date).round(3)\n",
    "regional.loc[\"Total\"] = regional.sum()\n",
    "\n",
    "# display results\n",
    "regional[list(operation.keys())] = regional[operation.keys()].astype(\"int\")\n",
    "regional.index.name = None\n",
    "\n",
    "caption_regional_fr = \"Les noms régionaux représentent différentes caractéristiques \\\n",
    "hydrologiques ainsi que des différences géographiques.\"\n",
    "\n",
    "regional.rename(columns=display_names).style.format(precision=3).set_table_styles(table_large_font).format('{:,}').set_caption(caption_regional_fr)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6eb5197e-fe05-46c9-8ea6-0975f9d4c7a7",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Municipal\n",
    "\n",
    "L'unité de base. Les communes non inscrites sur la liste n'ont pas été échantillonnées."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "ac9ee7df-e38a-4c01-afc9-359b300b4a71",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_6001a tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_6001a tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_6001a tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_6001a th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_6001a caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_6001a\">\n",
       "  <caption>Montreux et Vevey représentent 31% des échantillons depuis 2015.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_6001a_level0_col0\" class=\"col_heading level0 col0\" >quantité</th>\n",
       "      <th id=\"T_6001a_level0_col1\" class=\"col_heading level0 col1\" >échantillons</th>\n",
       "      <th id=\"T_6001a_level0_col2\" class=\"col_heading level0 col2\" >site</th>\n",
       "      <th id=\"T_6001a_level0_col3\" class=\"col_heading level0 col3\" >% de totale</th>\n",
       "      <th id=\"T_6001a_level0_col4\" class=\"col_heading level0 col4\" >% des échantillons</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row0\" class=\"row_heading level0 row0\" >Allaman</th>\n",
       "      <td id=\"T_6001a_row0_col0\" class=\"data row0 col0\" >631</td>\n",
       "      <td id=\"T_6001a_row0_col1\" class=\"data row0 col1\" >3</td>\n",
       "      <td id=\"T_6001a_row0_col2\" class=\"data row0 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row0_col3\" class=\"data row0 col3\" >0.007</td>\n",
       "      <td id=\"T_6001a_row0_col4\" class=\"data row0 col4\" >0.009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row1\" class=\"row_heading level0 row1\" >Aubonne</th>\n",
       "      <td id=\"T_6001a_row1_col0\" class=\"data row1 col0\" >193</td>\n",
       "      <td id=\"T_6001a_row1_col1\" class=\"data row1 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row1_col2\" class=\"data row1 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row1_col3\" class=\"data row1 col3\" >0.002</td>\n",
       "      <td id=\"T_6001a_row1_col4\" class=\"data row1 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row2\" class=\"row_heading level0 row2\" >Bourg-en-Lavaux</th>\n",
       "      <td id=\"T_6001a_row2_col0\" class=\"data row2 col0\" >121</td>\n",
       "      <td id=\"T_6001a_row2_col1\" class=\"data row2 col1\" >2</td>\n",
       "      <td id=\"T_6001a_row2_col2\" class=\"data row2 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row2_col3\" class=\"data row2 col3\" >0.001</td>\n",
       "      <td id=\"T_6001a_row2_col4\" class=\"data row2 col4\" >0.006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row3\" class=\"row_heading level0 row3\" >Bouveret</th>\n",
       "      <td id=\"T_6001a_row3_col0\" class=\"data row3 col0\" >3,286</td>\n",
       "      <td id=\"T_6001a_row3_col1\" class=\"data row3 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row3_col2\" class=\"data row3 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row3_col3\" class=\"data row3 col3\" >0.034</td>\n",
       "      <td id=\"T_6001a_row3_col4\" class=\"data row3 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row4\" class=\"row_heading level0 row4\" >Clarens</th>\n",
       "      <td id=\"T_6001a_row4_col0\" class=\"data row4 col0\" >1,127</td>\n",
       "      <td id=\"T_6001a_row4_col1\" class=\"data row4 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row4_col2\" class=\"data row4 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row4_col3\" class=\"data row4 col3\" >0.012</td>\n",
       "      <td id=\"T_6001a_row4_col4\" class=\"data row4 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row5\" class=\"row_heading level0 row5\" >Crans</th>\n",
       "      <td id=\"T_6001a_row5_col0\" class=\"data row5 col0\" >21</td>\n",
       "      <td id=\"T_6001a_row5_col1\" class=\"data row5 col1\" >3</td>\n",
       "      <td id=\"T_6001a_row5_col2\" class=\"data row5 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row5_col3\" class=\"data row5 col3\" >0.0</td>\n",
       "      <td id=\"T_6001a_row5_col4\" class=\"data row5 col4\" >0.009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row6\" class=\"row_heading level0 row6\" >Cully</th>\n",
       "      <td id=\"T_6001a_row6_col0\" class=\"data row6 col0\" >48</td>\n",
       "      <td id=\"T_6001a_row6_col1\" class=\"data row6 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row6_col2\" class=\"data row6 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row6_col3\" class=\"data row6 col3\" >0.0</td>\n",
       "      <td id=\"T_6001a_row6_col4\" class=\"data row6 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row7\" class=\"row_heading level0 row7\" >Genève</th>\n",
       "      <td id=\"T_6001a_row7_col0\" class=\"data row7 col0\" >8,128</td>\n",
       "      <td id=\"T_6001a_row7_col1\" class=\"data row7 col1\" >33</td>\n",
       "      <td id=\"T_6001a_row7_col2\" class=\"data row7 col2\" >6</td>\n",
       "      <td id=\"T_6001a_row7_col3\" class=\"data row7 col3\" >0.084</td>\n",
       "      <td id=\"T_6001a_row7_col4\" class=\"data row7 col4\" >0.103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row8\" class=\"row_heading level0 row8\" >Gland</th>\n",
       "      <td id=\"T_6001a_row8_col0\" class=\"data row8 col0\" >1,690</td>\n",
       "      <td id=\"T_6001a_row8_col1\" class=\"data row8 col1\" >26</td>\n",
       "      <td id=\"T_6001a_row8_col2\" class=\"data row8 col2\" >3</td>\n",
       "      <td id=\"T_6001a_row8_col3\" class=\"data row8 col3\" >0.018</td>\n",
       "      <td id=\"T_6001a_row8_col4\" class=\"data row8 col4\" >0.082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row9\" class=\"row_heading level0 row9\" >Grangettes</th>\n",
       "      <td id=\"T_6001a_row9_col0\" class=\"data row9 col0\" >3,677</td>\n",
       "      <td id=\"T_6001a_row9_col1\" class=\"data row9 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row9_col2\" class=\"data row9 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row9_col3\" class=\"data row9 col3\" >0.038</td>\n",
       "      <td id=\"T_6001a_row9_col4\" class=\"data row9 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row10\" class=\"row_heading level0 row10\" >Hermance</th>\n",
       "      <td id=\"T_6001a_row10_col0\" class=\"data row10 col0\" >200</td>\n",
       "      <td id=\"T_6001a_row10_col1\" class=\"data row10 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row10_col2\" class=\"data row10 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row10_col3\" class=\"data row10 col3\" >0.002</td>\n",
       "      <td id=\"T_6001a_row10_col4\" class=\"data row10 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row11\" class=\"row_heading level0 row11\" >La Tour-de-Peilz</th>\n",
       "      <td id=\"T_6001a_row11_col0\" class=\"data row11 col0\" >8,748</td>\n",
       "      <td id=\"T_6001a_row11_col1\" class=\"data row11 col1\" >25</td>\n",
       "      <td id=\"T_6001a_row11_col2\" class=\"data row11 col2\" >5</td>\n",
       "      <td id=\"T_6001a_row11_col3\" class=\"data row11 col3\" >0.091</td>\n",
       "      <td id=\"T_6001a_row11_col4\" class=\"data row11 col4\" >0.078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row12\" class=\"row_heading level0 row12\" >Lausanne</th>\n",
       "      <td id=\"T_6001a_row12_col0\" class=\"data row12 col0\" >3,822</td>\n",
       "      <td id=\"T_6001a_row12_col1\" class=\"data row12 col1\" >20</td>\n",
       "      <td id=\"T_6001a_row12_col2\" class=\"data row12 col2\" >3</td>\n",
       "      <td id=\"T_6001a_row12_col3\" class=\"data row12 col3\" >0.04</td>\n",
       "      <td id=\"T_6001a_row12_col4\" class=\"data row12 col4\" >0.063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row13\" class=\"row_heading level0 row13\" >Lutry</th>\n",
       "      <td id=\"T_6001a_row13_col0\" class=\"data row13 col0\" >686</td>\n",
       "      <td id=\"T_6001a_row13_col1\" class=\"data row13 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row13_col2\" class=\"data row13 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row13_col3\" class=\"data row13 col3\" >0.007</td>\n",
       "      <td id=\"T_6001a_row13_col4\" class=\"data row13 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row14\" class=\"row_heading level0 row14\" >Montreux</th>\n",
       "      <td id=\"T_6001a_row14_col0\" class=\"data row14 col0\" >16,715</td>\n",
       "      <td id=\"T_6001a_row14_col1\" class=\"data row14 col1\" >53</td>\n",
       "      <td id=\"T_6001a_row14_col2\" class=\"data row14 col2\" >5</td>\n",
       "      <td id=\"T_6001a_row14_col3\" class=\"data row14 col3\" >0.174</td>\n",
       "      <td id=\"T_6001a_row14_col4\" class=\"data row14 col4\" >0.166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row15\" class=\"row_heading level0 row15\" >Morges</th>\n",
       "      <td id=\"T_6001a_row15_col0\" class=\"data row15 col0\" >170</td>\n",
       "      <td id=\"T_6001a_row15_col1\" class=\"data row15 col1\" >1</td>\n",
       "      <td id=\"T_6001a_row15_col2\" class=\"data row15 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row15_col3\" class=\"data row15 col3\" >0.002</td>\n",
       "      <td id=\"T_6001a_row15_col4\" class=\"data row15 col4\" >0.003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row16\" class=\"row_heading level0 row16\" >Préverenges</th>\n",
       "      <td id=\"T_6001a_row16_col0\" class=\"data row16 col0\" >7,009</td>\n",
       "      <td id=\"T_6001a_row16_col1\" class=\"data row16 col1\" >19</td>\n",
       "      <td id=\"T_6001a_row16_col2\" class=\"data row16 col2\" >3</td>\n",
       "      <td id=\"T_6001a_row16_col3\" class=\"data row16 col3\" >0.073</td>\n",
       "      <td id=\"T_6001a_row16_col4\" class=\"data row16 col4\" >0.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row17\" class=\"row_heading level0 row17\" >Rolle</th>\n",
       "      <td id=\"T_6001a_row17_col0\" class=\"data row17 col0\" >1,236</td>\n",
       "      <td id=\"T_6001a_row17_col1\" class=\"data row17 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row17_col2\" class=\"data row17 col2\" >2</td>\n",
       "      <td id=\"T_6001a_row17_col3\" class=\"data row17 col3\" >0.013</td>\n",
       "      <td id=\"T_6001a_row17_col4\" class=\"data row17 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row18\" class=\"row_heading level0 row18\" >Saint-Gingolph</th>\n",
       "      <td id=\"T_6001a_row18_col0\" class=\"data row18 col0\" >8,907</td>\n",
       "      <td id=\"T_6001a_row18_col1\" class=\"data row18 col1\" >13</td>\n",
       "      <td id=\"T_6001a_row18_col2\" class=\"data row18 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row18_col3\" class=\"data row18 col3\" >0.092</td>\n",
       "      <td id=\"T_6001a_row18_col4\" class=\"data row18 col4\" >0.041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row19\" class=\"row_heading level0 row19\" >Saint-Sulpice (VD)</th>\n",
       "      <td id=\"T_6001a_row19_col0\" class=\"data row19 col0\" >8,313</td>\n",
       "      <td id=\"T_6001a_row19_col1\" class=\"data row19 col1\" >17</td>\n",
       "      <td id=\"T_6001a_row19_col2\" class=\"data row19 col2\" >5</td>\n",
       "      <td id=\"T_6001a_row19_col3\" class=\"data row19 col3\" >0.086</td>\n",
       "      <td id=\"T_6001a_row19_col4\" class=\"data row19 col4\" >0.053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row20\" class=\"row_heading level0 row20\" >Savonière</th>\n",
       "      <td id=\"T_6001a_row20_col0\" class=\"data row20 col0\" >592</td>\n",
       "      <td id=\"T_6001a_row20_col1\" class=\"data row20 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row20_col2\" class=\"data row20 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row20_col3\" class=\"data row20 col3\" >0.006</td>\n",
       "      <td id=\"T_6001a_row20_col4\" class=\"data row20 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row21\" class=\"row_heading level0 row21\" >Tolochenaz</th>\n",
       "      <td id=\"T_6001a_row21_col0\" class=\"data row21 col0\" >754</td>\n",
       "      <td id=\"T_6001a_row21_col1\" class=\"data row21 col1\" >7</td>\n",
       "      <td id=\"T_6001a_row21_col2\" class=\"data row21 col2\" >3</td>\n",
       "      <td id=\"T_6001a_row21_col3\" class=\"data row21 col3\" >0.008</td>\n",
       "      <td id=\"T_6001a_row21_col4\" class=\"data row21 col4\" >0.022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row22\" class=\"row_heading level0 row22\" >Versoix</th>\n",
       "      <td id=\"T_6001a_row22_col0\" class=\"data row22 col0\" >3,559</td>\n",
       "      <td id=\"T_6001a_row22_col1\" class=\"data row22 col1\" >9</td>\n",
       "      <td id=\"T_6001a_row22_col2\" class=\"data row22 col2\" >3</td>\n",
       "      <td id=\"T_6001a_row22_col3\" class=\"data row22 col3\" >0.037</td>\n",
       "      <td id=\"T_6001a_row22_col4\" class=\"data row22 col4\" >0.028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row23\" class=\"row_heading level0 row23\" >Vevey</th>\n",
       "      <td id=\"T_6001a_row23_col0\" class=\"data row23 col0\" >15,113</td>\n",
       "      <td id=\"T_6001a_row23_col1\" class=\"data row23 col1\" >48</td>\n",
       "      <td id=\"T_6001a_row23_col2\" class=\"data row23 col2\" >4</td>\n",
       "      <td id=\"T_6001a_row23_col3\" class=\"data row23 col3\" >0.157</td>\n",
       "      <td id=\"T_6001a_row23_col4\" class=\"data row23 col4\" >0.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row24\" class=\"row_heading level0 row24\" >Vidy</th>\n",
       "      <td id=\"T_6001a_row24_col0\" class=\"data row24 col0\" >1,571</td>\n",
       "      <td id=\"T_6001a_row24_col1\" class=\"data row24 col1\" >4</td>\n",
       "      <td id=\"T_6001a_row24_col2\" class=\"data row24 col2\" >1</td>\n",
       "      <td id=\"T_6001a_row24_col3\" class=\"data row24 col3\" >0.016</td>\n",
       "      <td id=\"T_6001a_row24_col4\" class=\"data row24 col4\" >0.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_6001a_level0_row25\" class=\"row_heading level0 row25\" >Total</th>\n",
       "      <td id=\"T_6001a_row25_col0\" class=\"data row25 col0\" >96,317</td>\n",
       "      <td id=\"T_6001a_row25_col1\" class=\"data row25 col1\" >319</td>\n",
       "      <td id=\"T_6001a_row25_col2\" class=\"data row25 col2\" >56</td>\n",
       "      <td id=\"T_6001a_row25_col3\" class=\"data row25 col3\" >1.0</td>\n",
       "      <td id=\"T_6001a_row25_col4\" class=\"data row25 col4\" >1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c97b99dc0>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "municipal = combined.groupby(\"city\").agg({\"quantity\":\"sum\", \"loc_date\":\"nunique\", \"slug\":\"nunique\"})\n",
    "municipal[\"q_weight\"] = (municipal.quantity/totals.quantity).round(3)\n",
    "municipal[\"s_weight\"] = (municipal.loc_date/totals.loc_date).round(3)\n",
    "municipal.loc[\"Total\"] = municipal.sum().round(2)\n",
    "municipal[[\"quantity\", \"loc_date\", \"slug\"]] = municipal[[\"quantity\", \"loc_date\", \"slug\"]].astype(\"int\")\n",
    "municipal.index.name = None\n",
    "caption_municipal_fr = \"Montreux et Vevey représentent 31% des échantillons depuis 2015.\"\n",
    "municipal.rename(columns=display_names).style.set_table_styles(table_large_font).format('{:,}').set_caption(caption_municipal_fr)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "041d93ef-2a98-4db3-9bf5-9acbeb949a96",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Échantillons de bord des rivières\n",
    "\n",
    "\n",
    "Les rivières représentent un environnement d'échantillonnage différent de celui des lacs. La marque des hautes eaux change plus fréquemment et avec plus d'ampleur sur les rivières. Ces changements sont si importants que les relevés effectués sur les berges impliquent souvent de retirer les sacs des arbres.\n",
    "\n",
    "```{attention}\n",
    "\n",
    "Les acteurs régionaux doivent se mettre d'accord sur les lieux d'échantillonnage optimaux le long de la voie navigable. Cela implique l'apport d'hydrologues et d'autres disciplines qui pourraient indiquer des lieux d'accumulation.\n",
    "\n",
    "Il s'agit notamment d'examiner attentivement les limites de la zone d'enquête et la manière de définir ces limites sur le terrain.\n",
    "``` "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "e4652291-cebc-4544-a2c7-ff2fb59c602c",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_b26ff tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_b26ff tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_b26ff tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_b26ff th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_b26ff caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_b26ff\">\n",
       "  <caption>Les échantillons de rivière ont la même structure que les échantillons de lac. La plupart des échantillons de rivière ont été prélevés en 2018.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_b26ff_level0_col0\" class=\"col_heading level0 col0\" >site</th>\n",
       "      <th id=\"T_b26ff_level0_col1\" class=\"col_heading level0 col1\" >municipalités</th>\n",
       "      <th id=\"T_b26ff_level0_col2\" class=\"col_heading level0 col2\" >zone d'intérêt</th>\n",
       "      <th id=\"T_b26ff_level0_col3\" class=\"col_heading level0 col3\" >date</th>\n",
       "      <th id=\"T_b26ff_level0_col4\" class=\"col_heading level0 col4\" >jdl</th>\n",
       "      <th id=\"T_b26ff_level0_col5\" class=\"col_heading level0 col5\" >Projet</th>\n",
       "      <th id=\"T_b26ff_level0_col6\" class=\"col_heading level0 col6\" >code</th>\n",
       "      <th id=\"T_b26ff_level0_col7\" class=\"col_heading level0 col7\" >pcs/m</th>\n",
       "      <th id=\"T_b26ff_level0_col8\" class=\"col_heading level0 col8\" >quantité</th>\n",
       "      <th id=\"T_b26ff_level0_col9\" class=\"col_heading level0 col9\" >canton</th>\n",
       "      <th id=\"T_b26ff_level0_col10\" class=\"col_heading level0 col10\" >zone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_b26ff_level0_row0\" class=\"row_heading level0 row0\" >10320</th>\n",
       "      <td id=\"T_b26ff_row0_col0\" class=\"data row0 col0\" >arve_carouge_battistellak</td>\n",
       "      <td id=\"T_b26ff_row0_col1\" class=\"data row0 col1\" >Veyrier</td>\n",
       "      <td id=\"T_b26ff_row0_col2\" class=\"data row0 col2\" >arve</td>\n",
       "      <td id=\"T_b26ff_row0_col3\" class=\"data row0 col3\" >2017-04-17</td>\n",
       "      <td id=\"T_b26ff_row0_col4\" class=\"data row0 col4\" >107.000</td>\n",
       "      <td id=\"T_b26ff_row0_col5\" class=\"data row0 col5\" >training</td>\n",
       "      <td id=\"T_b26ff_row0_col6\" class=\"data row0 col6\" >Gcaps</td>\n",
       "      <td id=\"T_b26ff_row0_col7\" class=\"data row0 col7\" >0.080</td>\n",
       "      <td id=\"T_b26ff_row0_col8\" class=\"data row0 col8\" >4.000</td>\n",
       "      <td id=\"T_b26ff_row0_col9\" class=\"data row0 col9\" >Genève</td>\n",
       "      <td id=\"T_b26ff_row0_col10\" class=\"data row0 col10\" >rivière</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_b26ff_level0_row1\" class=\"row_heading level0 row1\" >10321</th>\n",
       "      <td id=\"T_b26ff_row1_col0\" class=\"data row1 col0\" >arve_carouge_battistellak</td>\n",
       "      <td id=\"T_b26ff_row1_col1\" class=\"data row1 col1\" >Veyrier</td>\n",
       "      <td id=\"T_b26ff_row1_col2\" class=\"data row1 col2\" >arve</td>\n",
       "      <td id=\"T_b26ff_row1_col3\" class=\"data row1 col3\" >2017-05-25</td>\n",
       "      <td id=\"T_b26ff_row1_col4\" class=\"data row1 col4\" >145.000</td>\n",
       "      <td id=\"T_b26ff_row1_col5\" class=\"data row1 col5\" >training</td>\n",
       "      <td id=\"T_b26ff_row1_col6\" class=\"data row1 col6\" >Gcaps</td>\n",
       "      <td id=\"T_b26ff_row1_col7\" class=\"data row1 col7\" >0.090</td>\n",
       "      <td id=\"T_b26ff_row1_col8\" class=\"data row1 col8\" >5.000</td>\n",
       "      <td id=\"T_b26ff_row1_col9\" class=\"data row1 col9\" >Genève</td>\n",
       "      <td id=\"T_b26ff_row1_col10\" class=\"data row1 col10\" >rivière</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_b26ff_level0_row2\" class=\"row_heading level0 row2\" >10322</th>\n",
       "      <td id=\"T_b26ff_row2_col0\" class=\"data row2 col0\" >arve_carouge_battistellak</td>\n",
       "      <td id=\"T_b26ff_row2_col1\" class=\"data row2 col1\" >Veyrier</td>\n",
       "      <td id=\"T_b26ff_row2_col2\" class=\"data row2 col2\" >arve</td>\n",
       "      <td id=\"T_b26ff_row2_col3\" class=\"data row2 col3\" >2017-06-27</td>\n",
       "      <td id=\"T_b26ff_row2_col4\" class=\"data row2 col4\" >178.000</td>\n",
       "      <td id=\"T_b26ff_row2_col5\" class=\"data row2 col5\" >training</td>\n",
       "      <td id=\"T_b26ff_row2_col6\" class=\"data row2 col6\" >Gcaps</td>\n",
       "      <td id=\"T_b26ff_row2_col7\" class=\"data row2 col7\" >0.050</td>\n",
       "      <td id=\"T_b26ff_row2_col8\" class=\"data row2 col8\" >3.000</td>\n",
       "      <td id=\"T_b26ff_row2_col9\" class=\"data row2 col9\" >Genève</td>\n",
       "      <td id=\"T_b26ff_row2_col10\" class=\"data row2 col10\" >rivière</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_b26ff_level0_row3\" class=\"row_heading level0 row3\" >10323</th>\n",
       "      <td id=\"T_b26ff_row3_col0\" class=\"data row3 col0\" >arve_carouge_battistellak</td>\n",
       "      <td id=\"T_b26ff_row3_col1\" class=\"data row3 col1\" >Veyrier</td>\n",
       "      <td id=\"T_b26ff_row3_col2\" class=\"data row3 col2\" >arve</td>\n",
       "      <td id=\"T_b26ff_row3_col3\" class=\"data row3 col3\" >2017-07-31</td>\n",
       "      <td id=\"T_b26ff_row3_col4\" class=\"data row3 col4\" >212.000</td>\n",
       "      <td id=\"T_b26ff_row3_col5\" class=\"data row3 col5\" >training</td>\n",
       "      <td id=\"T_b26ff_row3_col6\" class=\"data row3 col6\" >Gcaps</td>\n",
       "      <td id=\"T_b26ff_row3_col7\" class=\"data row3 col7\" >0.070</td>\n",
       "      <td id=\"T_b26ff_row3_col8\" class=\"data row3 col8\" >4.000</td>\n",
       "      <td id=\"T_b26ff_row3_col9\" class=\"data row3 col9\" >Genève</td>\n",
       "      <td id=\"T_b26ff_row3_col10\" class=\"data row3 col10\" >rivière</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_b26ff_level0_row4\" class=\"row_heading level0 row4\" >10324</th>\n",
       "      <td id=\"T_b26ff_row4_col0\" class=\"data row4 col0\" >arve_carouge_battistellak</td>\n",
       "      <td id=\"T_b26ff_row4_col1\" class=\"data row4 col1\" >Veyrier</td>\n",
       "      <td id=\"T_b26ff_row4_col2\" class=\"data row4 col2\" >arve</td>\n",
       "      <td id=\"T_b26ff_row4_col3\" class=\"data row4 col3\" >2017-08-28</td>\n",
       "      <td id=\"T_b26ff_row4_col4\" class=\"data row4 col4\" >240.000</td>\n",
       "      <td id=\"T_b26ff_row4_col5\" class=\"data row4 col5\" >training</td>\n",
       "      <td id=\"T_b26ff_row4_col6\" class=\"data row4 col6\" >Gcaps</td>\n",
       "      <td id=\"T_b26ff_row4_col7\" class=\"data row4 col7\" >0.110</td>\n",
       "      <td id=\"T_b26ff_row4_col8\" class=\"data row4 col8\" >6.000</td>\n",
       "      <td id=\"T_b26ff_row4_col9\" class=\"data row4 col9\" >Genève</td>\n",
       "      <td id=\"T_b26ff_row4_col10\" class=\"data row4 col10\" >rivière</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c96588670>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "display_columns = [\n",
    "    'loc_date', 'slug', 'city', 'water_name_slug', 'date', 'doy', 'Project', 'code', 'pcs/m', 'quantity', 'canton','zone'\n",
    "]\n",
    "\n",
    "caption_rivers_fr = \"Les échantillons de rivière ont la même structure que \\\n",
    "les échantillons de lac. La plupart des échantillons de rivière ont été prélevés en 2018.\"\n",
    "\n",
    "wt_data[wt_data.zone == \"rivière\"][display_columns[1:]].rename(columns=display_names).head().style.set_table_styles(table_large_font).set_caption(caption).format(precision=3).set_caption(caption_rivers_fr)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9ccfa033-4fb6-4a8d-ac2d-fdba784c4724",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Échantillons sentiers pédèstre\n",
    "\n",
    "Le lien entre les résultats de ces sites et le lac n'est pas clair. Nous ne disposons pas de données antérieures à 2020 pour les Alpes et les associations n'ont pas manifesté d'intérêt soutenu pour continuer ce projet.\n",
    "\n",
    "```{important}\n",
    "Ces résultats sont intéressants car ils représentent des zones où l'on ne s'attend pas à trouver des déchets. Dans ce contexte, les échantillons prélevés sur les sentiers de randonnée sont équivalents à ceux prélevés sur les plages. Des efforts considérables sont également déployés à tous les niveaux pour entretenir ces ressources.\n",
    "\n",
    "L'élaboration d'un calendrier d'échantillonnage et la définition d'objectifs régionaux à cet égard peuvent inciter d'autres acteurs à agir.\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "c8b175a9-4ab6-482b-83a1-21d99cf0dee4",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_9b025 tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_9b025 tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_9b025 tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_9b025 th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_9b025 caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_9b025\">\n",
       "  <caption>Les données relatives aux sentiers de randonnée proviennent du rapport fédéral. Elles ont été réalisées par deux personnes au cours d'une saison estivale.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_9b025_level0_col0\" class=\"col_heading level0 col0\" >site</th>\n",
       "      <th id=\"T_9b025_level0_col1\" class=\"col_heading level0 col1\" >municipalités</th>\n",
       "      <th id=\"T_9b025_level0_col2\" class=\"col_heading level0 col2\" >zone d'intérêt</th>\n",
       "      <th id=\"T_9b025_level0_col3\" class=\"col_heading level0 col3\" >date</th>\n",
       "      <th id=\"T_9b025_level0_col4\" class=\"col_heading level0 col4\" >jdl</th>\n",
       "      <th id=\"T_9b025_level0_col5\" class=\"col_heading level0 col5\" >Projet</th>\n",
       "      <th id=\"T_9b025_level0_col6\" class=\"col_heading level0 col6\" >code</th>\n",
       "      <th id=\"T_9b025_level0_col7\" class=\"col_heading level0 col7\" >pcs/m</th>\n",
       "      <th id=\"T_9b025_level0_col8\" class=\"col_heading level0 col8\" >quantité</th>\n",
       "      <th id=\"T_9b025_level0_col9\" class=\"col_heading level0 col9\" >canton</th>\n",
       "      <th id=\"T_9b025_level0_col10\" class=\"col_heading level0 col10\" >zone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_9b025_level0_row0\" class=\"row_heading level0 row0\" >5990</th>\n",
       "      <td id=\"T_9b025_row0_col0\" class=\"data row0 col0\" >cabanes-des-diablerets</td>\n",
       "      <td id=\"T_9b025_row0_col1\" class=\"data row0 col1\" >Ormont-Dessus</td>\n",
       "      <td id=\"T_9b025_row0_col2\" class=\"data row0 col2\" >alpes-vaudoises</td>\n",
       "      <td id=\"T_9b025_row0_col3\" class=\"data row0 col3\" >2021-08-28</td>\n",
       "      <td id=\"T_9b025_row0_col4\" class=\"data row0 col4\" >240.000</td>\n",
       "      <td id=\"T_9b025_row0_col5\" class=\"data row0 col5\" >testing</td>\n",
       "      <td id=\"T_9b025_row0_col6\" class=\"data row0 col6\" >Gcaps</td>\n",
       "      <td id=\"T_9b025_row0_col7\" class=\"data row0 col7\" >0.000</td>\n",
       "      <td id=\"T_9b025_row0_col8\" class=\"data row0 col8\" >0.000</td>\n",
       "      <td id=\"T_9b025_row0_col9\" class=\"data row0 col9\" >Vaud</td>\n",
       "      <td id=\"T_9b025_row0_col10\" class=\"data row0 col10\" >montagne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_9b025_level0_row1\" class=\"row_heading level0 row1\" >5992</th>\n",
       "      <td id=\"T_9b025_row1_col0\" class=\"data row1 col0\" >crans-montana</td>\n",
       "      <td id=\"T_9b025_row1_col1\" class=\"data row1 col1\" >Crans-Montana</td>\n",
       "      <td id=\"T_9b025_row1_col2\" class=\"data row1 col2\" >alpes-valaisannes</td>\n",
       "      <td id=\"T_9b025_row1_col3\" class=\"data row1 col3\" >2021-06-12</td>\n",
       "      <td id=\"T_9b025_row1_col4\" class=\"data row1 col4\" >163.000</td>\n",
       "      <td id=\"T_9b025_row1_col5\" class=\"data row1 col5\" >testing</td>\n",
       "      <td id=\"T_9b025_row1_col6\" class=\"data row1 col6\" >Gcaps</td>\n",
       "      <td id=\"T_9b025_row1_col7\" class=\"data row1 col7\" >0.000</td>\n",
       "      <td id=\"T_9b025_row1_col8\" class=\"data row1 col8\" >0.000</td>\n",
       "      <td id=\"T_9b025_row1_col9\" class=\"data row1 col9\" >Valais</td>\n",
       "      <td id=\"T_9b025_row1_col10\" class=\"data row1 col10\" >montagne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_9b025_level0_row2\" class=\"row_heading level0 row2\" >5996</th>\n",
       "      <td id=\"T_9b025_row2_col0\" class=\"data row2 col0\" >la-tzoumaz</td>\n",
       "      <td id=\"T_9b025_row2_col1\" class=\"data row2 col1\" >Riddes</td>\n",
       "      <td id=\"T_9b025_row2_col2\" class=\"data row2 col2\" >alpes-valaisannes</td>\n",
       "      <td id=\"T_9b025_row2_col3\" class=\"data row2 col3\" >2021-05-22</td>\n",
       "      <td id=\"T_9b025_row2_col4\" class=\"data row2 col4\" >142.000</td>\n",
       "      <td id=\"T_9b025_row2_col5\" class=\"data row2 col5\" >testing</td>\n",
       "      <td id=\"T_9b025_row2_col6\" class=\"data row2 col6\" >Gcaps</td>\n",
       "      <td id=\"T_9b025_row2_col7\" class=\"data row2 col7\" >0.000</td>\n",
       "      <td id=\"T_9b025_row2_col8\" class=\"data row2 col8\" >0.000</td>\n",
       "      <td id=\"T_9b025_row2_col9\" class=\"data row2 col9\" >Valais</td>\n",
       "      <td id=\"T_9b025_row2_col10\" class=\"data row2 col10\" >montagne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_9b025_level0_row3\" class=\"row_heading level0 row3\" >5997</th>\n",
       "      <td id=\"T_9b025_row3_col0\" class=\"data row3 col0\" >les-crosets</td>\n",
       "      <td id=\"T_9b025_row3_col1\" class=\"data row3 col1\" >Val-d'Illiez</td>\n",
       "      <td id=\"T_9b025_row3_col2\" class=\"data row3 col2\" >alpes-valaisannes</td>\n",
       "      <td id=\"T_9b025_row3_col3\" class=\"data row3 col3\" >2021-06-06</td>\n",
       "      <td id=\"T_9b025_row3_col4\" class=\"data row3 col4\" >157.000</td>\n",
       "      <td id=\"T_9b025_row3_col5\" class=\"data row3 col5\" >testing</td>\n",
       "      <td id=\"T_9b025_row3_col6\" class=\"data row3 col6\" >Gcaps</td>\n",
       "      <td id=\"T_9b025_row3_col7\" class=\"data row3 col7\" >0.000</td>\n",
       "      <td id=\"T_9b025_row3_col8\" class=\"data row3 col8\" >0.000</td>\n",
       "      <td id=\"T_9b025_row3_col9\" class=\"data row3 col9\" >Valais</td>\n",
       "      <td id=\"T_9b025_row3_col10\" class=\"data row3 col10\" >montagne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_9b025_level0_row4\" class=\"row_heading level0 row4\" >5998</th>\n",
       "      <td id=\"T_9b025_row4_col0\" class=\"data row4 col0\" >les-diablerets</td>\n",
       "      <td id=\"T_9b025_row4_col1\" class=\"data row4 col1\" >Ormont-Dessus</td>\n",
       "      <td id=\"T_9b025_row4_col2\" class=\"data row4 col2\" >alpes-vaudoises</td>\n",
       "      <td id=\"T_9b025_row4_col3\" class=\"data row4 col3\" >2021-05-15</td>\n",
       "      <td id=\"T_9b025_row4_col4\" class=\"data row4 col4\" >135.000</td>\n",
       "      <td id=\"T_9b025_row4_col5\" class=\"data row4 col5\" >testing</td>\n",
       "      <td id=\"T_9b025_row4_col6\" class=\"data row4 col6\" >Gcaps</td>\n",
       "      <td id=\"T_9b025_row4_col7\" class=\"data row4 col7\" >0.010</td>\n",
       "      <td id=\"T_9b025_row4_col8\" class=\"data row4 col8\" >1.000</td>\n",
       "      <td id=\"T_9b025_row4_col9\" class=\"data row4 col9\" >Vaud</td>\n",
       "      <td id=\"T_9b025_row4_col10\" class=\"data row4 col10\" >montagne</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c965c2520>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alpes_locs =  {\n",
    "    'airolo': \"Ticino\" ,\n",
    "    'andermatt': \"Uri\" ,\n",
    "    'cabanes-des-diablerets': \"Vaud\",\n",
    "    'charmey': \"Valais\",\n",
    "    'crans-montana': \"Valais\",\n",
    "    'grindelwald': \"Bern\",\n",
    "    'la-berra': \"Fribourg\",\n",
    "    'la-robella':\"Neuchâtel\",\n",
    "    'la-tzoumaz':  \"Valais\",\n",
    "    'les-crosets': \"Valais\",\n",
    "    'les-diablerets': \"Vaud\",\n",
    "    'les-paccots': \"Fribourg\",\n",
    "    'morgins':\"Valais\",\n",
    "    'nendaz': \"Valais\",\n",
    "    'san-bernardino': \"Grisons\" ,\n",
    "    'val-calanca': \"Ticino\",\n",
    "    'verbier':\"Valais\",\n",
    "    'veysonnaz': \"Valais\",\n",
    "    'villars': \"Vaud\",\n",
    "    'monte-generoso': \"Ticino\"\n",
    "}\n",
    "\n",
    "\n",
    "\n",
    "caption_trails_fr = \"Les données relatives aux sentiers de randonnée proviennent du rapport fédéral. \\\n",
    "Elles ont été réalisées par deux personnes au cours d'une saison estivale.\"\n",
    "\n",
    "wt_data[wt_data.zone == \"montagne\"][display_columns[1:]].rename(columns=display_names).head().style.set_table_styles(table_large_font).set_caption(caption).format(precision=3).set_caption(caption_trails_fr)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e71ca431-1993-49b5-bd70-3759ac4cbfb9",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Données dimensionnelles\n",
    "\n",
    "Nous ne listons pas les poids ici. Les méthodes utilisées pour enregistrer les poids diffèrent d'un groupe à l'autre. Cependant nous disposons de la longueur du rivage ou du sentier, de la superficie et du temps en minutes.\n",
    "\n",
    "```{note}\n",
    "Le temps nécessaire à la réalisation d'un inventaire est souvent sous-estimé. Des inventaires de plusieurs milliers d'unités peuvent nécessiter 8 à 12 heures de comptage, mais seulement une heure de collecte.\n",
    "\n",
    "En fin de compte, la précision de vos données dépend des ressources allouées à cet effet. D'après notre expérience, les gens participent à la collecte mais pas au comptage.\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "e320b5f2-1141-4d98-ad8b-ea32bf3548d9",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_e1307 tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_e1307 tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_e1307 tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_e1307 th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_e1307 caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_e1307\">\n",
       "  <caption>l'ampleur de l'effort en termes de surface, de distance et de temps.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_e1307_level0_col0\" class=\"col_heading level0 col0\" >m²</th>\n",
       "      <th id=\"T_e1307_level0_col1\" class=\"col_heading level0 col1\" >mètres</th>\n",
       "      <th id=\"T_e1307_level0_col2\" class=\"col_heading level0 col2\" >minutes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_e1307_level0_row0\" class=\"row_heading level0 row0\" >airolo</th>\n",
       "      <td id=\"T_e1307_row0_col0\" class=\"data row0 col0\" >57.000</td>\n",
       "      <td id=\"T_e1307_row0_col1\" class=\"data row0 col1\" >38</td>\n",
       "      <td id=\"T_e1307_row0_col2\" class=\"data row0 col2\" >99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1307_level0_row1\" class=\"row_heading level0 row1\" >andermatt</th>\n",
       "      <td id=\"T_e1307_row1_col0\" class=\"data row1 col0\" >800.000</td>\n",
       "      <td id=\"T_e1307_row1_col1\" class=\"data row1 col1\" >100</td>\n",
       "      <td id=\"T_e1307_row1_col2\" class=\"data row1 col2\" >220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1307_level0_row2\" class=\"row_heading level0 row2\" >cabanes-des-diablerets</th>\n",
       "      <td id=\"T_e1307_row2_col0\" class=\"data row2 col0\" >18.000</td>\n",
       "      <td id=\"T_e1307_row2_col1\" class=\"data row2 col1\" >12</td>\n",
       "      <td id=\"T_e1307_row2_col2\" class=\"data row2 col2\" >199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1307_level0_row3\" class=\"row_heading level0 row3\" >charmey</th>\n",
       "      <td id=\"T_e1307_row3_col0\" class=\"data row3 col0\" >150.000</td>\n",
       "      <td id=\"T_e1307_row3_col1\" class=\"data row3 col1\" >30</td>\n",
       "      <td id=\"T_e1307_row3_col2\" class=\"data row3 col2\" >220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_e1307_level0_row4\" class=\"row_heading level0 row4\" >crans-montana</th>\n",
       "      <td id=\"T_e1307_row4_col0\" class=\"data row4 col0\" >64.000</td>\n",
       "      <td id=\"T_e1307_row4_col1\" class=\"data row4 col1\" >43</td>\n",
       "      <td id=\"T_e1307_row4_col2\" class=\"data row4 col2\" >149</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c965be9a0>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "working_dimensions = pd.read_csv('resources/work_dimensions.csv')\n",
    "working_dimensions.set_index(\"slug\", inplace=True)\n",
    "working_dimensions.index.name = None\n",
    "\n",
    "caption_dims_fr = \"l'ampleur de l'effort en termes de surface, de distance et de temps.\"\n",
    "working_dimensions.rename(columns=display_names).head().style.set_table_styles(table_large_font).format(precision=3).set_caption(caption_dims_fr)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d52d3461-15fc-4edc-8cf0-507fa64e8d8f",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "### Test\n",
    "\n",
    "Avant de passer à l'étape suivante. Nous vérifions les données par rapport au rapport fédéral. Nos résultats ici doivent correspondre à la page ici [Le Léman 2021](https://hammerdirt-analyst.github.io/IQAASL-End-0f-Sampling-2021/lac-leman.html)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "c9b0bf40-e133-489f-a1ca-d9c73a480ce3",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_9164c tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_9164c tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_9164c tr {\n",
       "  font-size: 14px;\n",
       "}\n",
       "#T_9164c th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_9164c caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_9164c\">\n",
       "  <caption>Ces valeurs doivent correspondre à la médiane déclarée pour le même objet dans le rapport fédéral. </caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_9164c_level0_col0\" class=\"col_heading level0 col0\" >G112</th>\n",
       "      <th id=\"T_9164c_level0_col1\" class=\"col_heading level0 col1\" >G27</th>\n",
       "      <th id=\"T_9164c_level0_col2\" class=\"col_heading level0 col2\" >G30</th>\n",
       "      <th id=\"T_9164c_level0_col3\" class=\"col_heading level0 col3\" >G67</th>\n",
       "      <th id=\"T_9164c_level0_col4\" class=\"col_heading level0 col4\" >G70</th>\n",
       "      <th id=\"T_9164c_level0_col5\" class=\"col_heading level0 col5\" >G89</th>\n",
       "      <th id=\"T_9164c_level0_col6\" class=\"col_heading level0 col6\" >G95</th>\n",
       "      <th id=\"T_9164c_level0_col7\" class=\"col_heading level0 col7\" >Gfrags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_9164c_level0_row0\" class=\"row_heading level0 row0\" >pcs/m</th>\n",
       "      <td id=\"T_9164c_row0_col0\" class=\"data row0 col0\" >0.000</td>\n",
       "      <td id=\"T_9164c_row0_col1\" class=\"data row0 col1\" >0.470</td>\n",
       "      <td id=\"T_9164c_row0_col2\" class=\"data row0 col2\" >0.215</td>\n",
       "      <td id=\"T_9164c_row0_col3\" class=\"data row0 col3\" >0.090</td>\n",
       "      <td id=\"T_9164c_row0_col4\" class=\"data row0 col4\" >0.010</td>\n",
       "      <td id=\"T_9164c_row0_col5\" class=\"data row0 col5\" >0.055</td>\n",
       "      <td id=\"T_9164c_row0_col6\" class=\"data row0 col6\" >0.120</td>\n",
       "      <td id=\"T_9164c_row0_col7\" class=\"data row0 col7\" >0.615</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c96528f10>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# check the 2021 results against the pubished federal report\n",
    "start_date, end_date = pd.to_datetime(\"2020-04-01\"), \"2021-05-31\" \n",
    "combined[\"date\"] = pd.to_datetime(combined[\"date\"])\n",
    "mask = (combined[\"date\"] >= start_date) & (combined[\"date\"] <= end_date) & (combined.zone == 'lac')\n",
    "iqaasl = combined[mask]\n",
    "codes = [\"Gfrags\", \"G27\", \"G67\", \"G95\", \"G112\", \"G30\", \"G70\", \"G89\"]\n",
    "\n",
    "t_c_v = iqaasl[iqaasl.code.isin(codes)]\n",
    "tcv = t_c_v.groupby([\"loc_date\", \"code\"], as_index=False).agg({\"pcs/m\":\"sum\", \"quantity\":\"sum\"})\n",
    "tfg = tcv.groupby(\"code\", as_index=False)[\"pcs/m\"].median().T\n",
    "tfg.columns = tfg.loc[\"code\"].values\n",
    "tfg.drop(\"code\", inplace=True)\n",
    "caption_test_fr = \"Ces valeurs doivent correspondre à la médiane déclarée pour le même objet dans le rapport fédéral. \"\n",
    "tfg.style.set_table_styles(table_large_font).format(precision=3).set_caption(caption_test_fr)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "63ac9fde-c60b-4848-a6cd-3098bdf76629",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "## L'ensemble de données pour le lac\n",
    "\n",
    "Les résultats de l'enquête contiennent désormais toutes les informations décrites ici ou permettent d'accéder à d'autres informations sur l'événement."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "a25d283e-b680-4cd9-bca4-c7a9d45a20ee",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_ba6e9 tr:nth-child(even) {\n",
       "  background-color: rgba(139, 69, 19, 0.08);\n",
       "}\n",
       "#T_ba6e9 tr:nth-child(odd) {\n",
       "  background: #FFF;\n",
       "}\n",
       "#T_ba6e9 tr {\n",
       "  font-size: 10px;\n",
       "}\n",
       "#T_ba6e9 th:nth-child(1) {\n",
       "  background-color: #FFF;\n",
       "  text-align: right;\n",
       "}\n",
       "#T_ba6e9 caption {\n",
       "  font-size: 14px;\n",
       "  font-style: italic;\n",
       "  caption-side: bottom;\n",
       "  text-align: left;\n",
       "  margin-top: 10px;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_ba6e9\">\n",
       "  <caption>Résultats pour les emballages de bonbons. Les données de l'enquête comportent des étiquettes pour les relations inter et intra cantonales. C'est essentiel pour les replacer dans leur contexte.</caption>\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_ba6e9_level0_col0\" class=\"col_heading level0 col0\" >échantillons</th>\n",
       "      <th id=\"T_ba6e9_level0_col1\" class=\"col_heading level0 col1\" >site</th>\n",
       "      <th id=\"T_ba6e9_level0_col2\" class=\"col_heading level0 col2\" >municipalités</th>\n",
       "      <th id=\"T_ba6e9_level0_col3\" class=\"col_heading level0 col3\" >zone d'intérêt</th>\n",
       "      <th id=\"T_ba6e9_level0_col4\" class=\"col_heading level0 col4\" >date</th>\n",
       "      <th id=\"T_ba6e9_level0_col5\" class=\"col_heading level0 col5\" >jdl</th>\n",
       "      <th id=\"T_ba6e9_level0_col6\" class=\"col_heading level0 col6\" >Projet</th>\n",
       "      <th id=\"T_ba6e9_level0_col7\" class=\"col_heading level0 col7\" >code</th>\n",
       "      <th id=\"T_ba6e9_level0_col8\" class=\"col_heading level0 col8\" >pcs/m</th>\n",
       "      <th id=\"T_ba6e9_level0_col9\" class=\"col_heading level0 col9\" >quantité</th>\n",
       "      <th id=\"T_ba6e9_level0_col10\" class=\"col_heading level0 col10\" >canton</th>\n",
       "      <th id=\"T_ba6e9_level0_col11\" class=\"col_heading level0 col11\" >zone</th>\n",
       "      <th id=\"T_ba6e9_level0_col12\" class=\"col_heading level0 col12\" >region</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_ba6e9_level0_row0\" class=\"row_heading level0 row0\" >35</th>\n",
       "      <td id=\"T_ba6e9_row0_col0\" class=\"data row0 col0\" >('aubonne', '2022-02-06')</td>\n",
       "      <td id=\"T_ba6e9_row0_col1\" class=\"data row0 col1\" >aubonne</td>\n",
       "      <td id=\"T_ba6e9_row0_col2\" class=\"data row0 col2\" >Aubonne</td>\n",
       "      <td id=\"T_ba6e9_row0_col3\" class=\"data row0 col3\" >lac-leman</td>\n",
       "      <td id=\"T_ba6e9_row0_col4\" class=\"data row0 col4\" >2022-02-06</td>\n",
       "      <td id=\"T_ba6e9_row0_col5\" class=\"data row0 col5\" >37.000</td>\n",
       "      <td id=\"T_ba6e9_row0_col6\" class=\"data row0 col6\" >testing</td>\n",
       "      <td id=\"T_ba6e9_row0_col7\" class=\"data row0 col7\" >G30</td>\n",
       "      <td id=\"T_ba6e9_row0_col8\" class=\"data row0 col8\" >0.100</td>\n",
       "      <td id=\"T_ba6e9_row0_col9\" class=\"data row0 col9\" >5.000</td>\n",
       "      <td id=\"T_ba6e9_row0_col10\" class=\"data row0 col10\" >Vaud</td>\n",
       "      <td id=\"T_ba6e9_row0_col11\" class=\"data row0 col11\" >lac</td>\n",
       "      <td id=\"T_ba6e9_row0_col12\" class=\"data row0 col12\" >Grand lac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_ba6e9_level0_row1\" class=\"row_heading level0 row1\" >108</th>\n",
       "      <td id=\"T_ba6e9_row1_col0\" class=\"data row1 col0\" >('aubonne', '2022-05-14')</td>\n",
       "      <td id=\"T_ba6e9_row1_col1\" class=\"data row1 col1\" >aubonne</td>\n",
       "      <td id=\"T_ba6e9_row1_col2\" class=\"data row1 col2\" >Aubonne</td>\n",
       "      <td id=\"T_ba6e9_row1_col3\" class=\"data row1 col3\" >lac-leman</td>\n",
       "      <td id=\"T_ba6e9_row1_col4\" class=\"data row1 col4\" >2022-05-14</td>\n",
       "      <td id=\"T_ba6e9_row1_col5\" class=\"data row1 col5\" >134.000</td>\n",
       "      <td id=\"T_ba6e9_row1_col6\" class=\"data row1 col6\" >testing</td>\n",
       "      <td id=\"T_ba6e9_row1_col7\" class=\"data row1 col7\" >G30</td>\n",
       "      <td id=\"T_ba6e9_row1_col8\" class=\"data row1 col8\" >0.220</td>\n",
       "      <td id=\"T_ba6e9_row1_col9\" class=\"data row1 col9\" >11.000</td>\n",
       "      <td id=\"T_ba6e9_row1_col10\" class=\"data row1 col10\" >Vaud</td>\n",
       "      <td id=\"T_ba6e9_row1_col11\" class=\"data row1 col11\" >lac</td>\n",
       "      <td id=\"T_ba6e9_row1_col12\" class=\"data row1 col12\" >Grand lac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_ba6e9_level0_row2\" class=\"row_heading level0 row2\" >181</th>\n",
       "      <td id=\"T_ba6e9_row2_col0\" class=\"data row2 col0\" >('aubonne', '2022-09-10')</td>\n",
       "      <td id=\"T_ba6e9_row2_col1\" class=\"data row2 col1\" >aubonne</td>\n",
       "      <td id=\"T_ba6e9_row2_col2\" class=\"data row2 col2\" >Aubonne</td>\n",
       "      <td id=\"T_ba6e9_row2_col3\" class=\"data row2 col3\" >lac-leman</td>\n",
       "      <td id=\"T_ba6e9_row2_col4\" class=\"data row2 col4\" >2022-09-10</td>\n",
       "      <td id=\"T_ba6e9_row2_col5\" class=\"data row2 col5\" >253.000</td>\n",
       "      <td id=\"T_ba6e9_row2_col6\" class=\"data row2 col6\" >testing</td>\n",
       "      <td id=\"T_ba6e9_row2_col7\" class=\"data row2 col7\" >G30</td>\n",
       "      <td id=\"T_ba6e9_row2_col8\" class=\"data row2 col8\" >0.060</td>\n",
       "      <td id=\"T_ba6e9_row2_col9\" class=\"data row2 col9\" >3.000</td>\n",
       "      <td id=\"T_ba6e9_row2_col10\" class=\"data row2 col10\" >Vaud</td>\n",
       "      <td id=\"T_ba6e9_row2_col11\" class=\"data row2 col11\" >lac</td>\n",
       "      <td id=\"T_ba6e9_row2_col12\" class=\"data row2 col12\" >Grand lac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_ba6e9_level0_row3\" class=\"row_heading level0 row3\" >254</th>\n",
       "      <td id=\"T_ba6e9_row3_col0\" class=\"data row3 col0\" >('aubonne', '2022-11-05')</td>\n",
       "      <td id=\"T_ba6e9_row3_col1\" class=\"data row3 col1\" >aubonne</td>\n",
       "      <td id=\"T_ba6e9_row3_col2\" class=\"data row3 col2\" >Aubonne</td>\n",
       "      <td id=\"T_ba6e9_row3_col3\" class=\"data row3 col3\" >lac-leman</td>\n",
       "      <td id=\"T_ba6e9_row3_col4\" class=\"data row3 col4\" >2022-11-05</td>\n",
       "      <td id=\"T_ba6e9_row3_col5\" class=\"data row3 col5\" >309.000</td>\n",
       "      <td id=\"T_ba6e9_row3_col6\" class=\"data row3 col6\" >testing</td>\n",
       "      <td id=\"T_ba6e9_row3_col7\" class=\"data row3 col7\" >G30</td>\n",
       "      <td id=\"T_ba6e9_row3_col8\" class=\"data row3 col8\" >0.060</td>\n",
       "      <td id=\"T_ba6e9_row3_col9\" class=\"data row3 col9\" >3.000</td>\n",
       "      <td id=\"T_ba6e9_row3_col10\" class=\"data row3 col10\" >Vaud</td>\n",
       "      <td id=\"T_ba6e9_row3_col11\" class=\"data row3 col11\" >lac</td>\n",
       "      <td id=\"T_ba6e9_row3_col12\" class=\"data row3 col12\" >Grand lac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_ba6e9_level0_row4\" class=\"row_heading level0 row4\" >327</th>\n",
       "      <td id=\"T_ba6e9_row4_col0\" class=\"data row4 col0\" >('baby-plage', '2022-01-22')</td>\n",
       "      <td id=\"T_ba6e9_row4_col1\" class=\"data row4 col1\" >baby-plage</td>\n",
       "      <td id=\"T_ba6e9_row4_col2\" class=\"data row4 col2\" >Genève</td>\n",
       "      <td id=\"T_ba6e9_row4_col3\" class=\"data row4 col3\" >lac-leman</td>\n",
       "      <td id=\"T_ba6e9_row4_col4\" class=\"data row4 col4\" >2022-01-22</td>\n",
       "      <td id=\"T_ba6e9_row4_col5\" class=\"data row4 col5\" >22.000</td>\n",
       "      <td id=\"T_ba6e9_row4_col6\" class=\"data row4 col6\" >testing</td>\n",
       "      <td id=\"T_ba6e9_row4_col7\" class=\"data row4 col7\" >G30</td>\n",
       "      <td id=\"T_ba6e9_row4_col8\" class=\"data row4 col8\" >0.111</td>\n",
       "      <td id=\"T_ba6e9_row4_col9\" class=\"data row4 col9\" >9.000</td>\n",
       "      <td id=\"T_ba6e9_row4_col10\" class=\"data row4 col10\" >Genève</td>\n",
       "      <td id=\"T_ba6e9_row4_col11\" class=\"data row4 col11\" >lac</td>\n",
       "      <td id=\"T_ba6e9_row4_col12\" class=\"data row4 col12\" >Petit lac</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7f8c9659ae50>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined[\"date\"] = combined[\"date\"].dt.date\n",
    "\n",
    "caption_last_fr = \"Résultats pour les emballages de bonbons. Les données de l'enquête comportent \\\n",
    "des étiquettes pour les relations inter et intra cantonales. \\\n",
    "C'est essentiel pour les replacer dans leur contexte.\"\n",
    "\n",
    "combined[combined.code == \"G30\"].rename(columns=display_names).head().style.set_table_styles(table_css_styles).format(precision=3).set_caption(caption_last_fr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "74b4b99d-237e-4776-a9e8-6e6df6725fb4",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/markdown": [
       "\n",
       "<br />\n",
       "<br />\n",
       "Ceci est un ébauche : le script a été mis à jour le 22/09/2023 in Biel, CH\n",
       "\n",
       "Contactez analyst@ pour plus d'informations\n"
      ],
      "text/plain": [
       "<IPython.core.display.Markdown object>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "today = dt.datetime.now().date().strftime(\"%d/%m/%Y\")\n",
    "where = \"Biel, CH\"\n",
    "\n",
    "my_block = f\"\"\"\n",
    "<br />\n",
    "<br />\n",
    "Ceci est un ébauche : le script a été mis à jour le {today} in {where}\n",
    "\n",
    "Contactez analyst@ pour plus d'informations\n",
    "\"\"\"\n",
    "\n",
    "md(my_block)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "a7728b90-312f-438d-836c-3b0606cdb915",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Git repo: https://github.com/hammerdirt-analyst/cantonal_reports.git\n",
      "\n",
      "Git branch: main\n",
      "\n",
      "json   : 2.0.9\n",
      "pandas : 2.0.3\n",
      "numpy  : 1.25.2\n",
      "slugify: 8.0.1\n",
      "\n"
     ]
    }
   ],
   "source": [
    "%watermark --iversions -b -r"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4979fc8a-01d3-4e23-aee4-bfed77cd0c62",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "_analyst at hammerdirt_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "73de1590-b163-46ad-8090-525b04ae55f8",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.17"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}