3.3_Remediation_pandas.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Itération 3: Pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from pathlib import Path"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importer les données"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 215,
   "metadata": {},
   "outputs": [],
   "source": [
    "datapath=Path.cwd().parent.parent / \"Cours_Python_it3\"\n",
    "datafile = datapath / \"ESP_PUBLIC.IDENTITE_ARBRE.csv\"\n",
    "df_arbres = pd.read_csv(datafile)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Iteration 1: Questions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 216,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ELEM_POINT_ID</th>\n",
       "      <th>CODE</th>\n",
       "      <th>NOM</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>GENRE_DESC</th>\n",
       "      <th>CATEGORIE</th>\n",
       "      <th>CATEGORIE_DESC</th>\n",
       "      <th>SOUS_CATEGORIE</th>\n",
       "      <th>SOUS_CATEGORIE_DESC</th>\n",
       "      <th>CODE_PARENT</th>\n",
       "      <th>...</th>\n",
       "      <th>COURRIER</th>\n",
       "      <th>IDENTIFIANTPLU</th>\n",
       "      <th>TYPEIMPLANTATIONPLU</th>\n",
       "      <th>INTITULEPROTECTIONPLU</th>\n",
       "      <th>ANNEEABATTAGE</th>\n",
       "      <th>ESSOUCHEMENT</th>\n",
       "      <th>DIAMETREARBRE</th>\n",
       "      <th>CAUSEABATTAGE</th>\n",
       "      <th>COLLECTIVITE</th>\n",
       "      <th>GeoJSON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>31890</th>\n",
       "      <td>24296</td>\n",
       "      <td>ESP14848</td>\n",
       "      <td>ESP14848</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7262050374391...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31891</th>\n",
       "      <td>24289</td>\n",
       "      <td>ESP14846</td>\n",
       "      <td>ESP14846</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7251368334990...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ELEM_POINT_ID      CODE       NOM GENRE  GENRE_DESC CATEGORIE  \\\n",
       "31890          24296  ESP14848  ESP14848   VEG  VEGETATION     ESP01   \n",
       "31891          24289  ESP14846  ESP14846   VEG  VEGETATION     ESP01   \n",
       "\n",
       "      CATEGORIE_DESC SOUS_CATEGORIE      SOUS_CATEGORIE_DESC CODE_PARENT  ...  \\\n",
       "31890          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "31891          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "\n",
       "      COURRIER  IDENTIFIANTPLU TYPEIMPLANTATIONPLU INTITULEPROTECTIONPLU  \\\n",
       "31890      NaN             NaN                 NaN                   NaN   \n",
       "31891      NaN             NaN                 NaN                   NaN   \n",
       "\n",
       "      ANNEEABATTAGE ESSOUCHEMENT DIAMETREARBRE  CAUSEABATTAGE  \\\n",
       "31890           NaN          NaN           NaN            NaN   \n",
       "31891           NaN          NaN           NaN            NaN   \n",
       "\n",
       "            COLLECTIVITE                                            GeoJSON  \n",
       "31890  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7262050374391...  \n",
       "31891  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7251368334990...  \n",
       "\n",
       "[2 rows x 32 columns]"
      ]
     },
     "execution_count": 216,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# La 'fin' des données\n",
    "df_arbres.tail(2) #bottom_values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 219,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ELEM_POINT_ID</th>\n",
       "      <th>CODE</th>\n",
       "      <th>NOM</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>GENRE_DESC</th>\n",
       "      <th>CATEGORIE</th>\n",
       "      <th>CATEGORIE_DESC</th>\n",
       "      <th>SOUS_CATEGORIE</th>\n",
       "      <th>SOUS_CATEGORIE_DESC</th>\n",
       "      <th>CODE_PARENT</th>\n",
       "      <th>...</th>\n",
       "      <th>COURRIER</th>\n",
       "      <th>IDENTIFIANTPLU</th>\n",
       "      <th>TYPEIMPLANTATIONPLU</th>\n",
       "      <th>INTITULEPROTECTIONPLU</th>\n",
       "      <th>ANNEEABATTAGE</th>\n",
       "      <th>ESSOUCHEMENT</th>\n",
       "      <th>DIAMETREARBRE</th>\n",
       "      <th>CAUSEABATTAGE</th>\n",
       "      <th>COLLECTIVITE</th>\n",
       "      <th>GeoJSON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16750</td>\n",
       "      <td>ESP19318</td>\n",
       "      <td>ESP19318</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7394161255246...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20142</td>\n",
       "      <td>ESP18095</td>\n",
       "      <td>ESP18095</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7397428849165...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   ELEM_POINT_ID      CODE       NOM GENRE  GENRE_DESC CATEGORIE  \\\n",
       "0          16750  ESP19318  ESP19318   VEG  VEGETATION     ESP01   \n",
       "1          20142  ESP18095  ESP18095   VEG  VEGETATION     ESP01   \n",
       "\n",
       "  CATEGORIE_DESC SOUS_CATEGORIE      SOUS_CATEGORIE_DESC CODE_PARENT  ...  \\\n",
       "0          Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "1          Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "\n",
       "  COURRIER  IDENTIFIANTPLU TYPEIMPLANTATIONPLU INTITULEPROTECTIONPLU  \\\n",
       "0      NaN             NaN                 NaN                   NaN   \n",
       "1      NaN             NaN                 NaN                   NaN   \n",
       "\n",
       "  ANNEEABATTAGE ESSOUCHEMENT DIAMETREARBRE  CAUSEABATTAGE       COLLECTIVITE  \\\n",
       "0           NaN          NaN           NaN            NaN  Ville de Grenoble   \n",
       "1           NaN          NaN           NaN            NaN  Ville de Grenoble   \n",
       "\n",
       "                                             GeoJSON  \n",
       "0  {\"type\":\"Point\",\"coordinates\":[5.7394161255246...  \n",
       "1  {\"type\":\"Point\",\"coordinates\":[5.7397428849165...  \n",
       "\n",
       "[2 rows x 32 columns]"
      ]
     },
     "execution_count": 219,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Le 'début' des données\n",
    "df_arbres.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 220,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1975., 1975., 2001., ..., 1980., 1980., 2005.])"
      ]
     },
     "execution_count": 220,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Recuperer une colonne de mon dataframe\n",
    "df_annee = df_arbres['ANNEEDEPLANTATION']\n",
    "df_annee.dropna().to_numpy()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 221,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['ELEM_POINT_ID',\n",
       " 'CODE',\n",
       " 'NOM',\n",
       " 'GENRE',\n",
       " 'GENRE_DESC',\n",
       " 'CATEGORIE',\n",
       " 'CATEGORIE_DESC',\n",
       " 'SOUS_CATEGORIE',\n",
       " 'SOUS_CATEGORIE_DESC',\n",
       " 'CODE_PARENT',\n",
       " 'CODE_PARENT_DESC',\n",
       " 'ADR_SECTEUR',\n",
       " 'BIEN_REFERENCE',\n",
       " 'GENRE_BOTA',\n",
       " 'ESPECE',\n",
       " 'VARIETE',\n",
       " 'STADEDEDEVELOPPEMENT',\n",
       " 'EQUIPE',\n",
       " 'REMARQUES',\n",
       " 'ANNEEDEPLANTATION',\n",
       " 'RAISONDEPLANTATION',\n",
       " 'TRAITEMENTCHENILLES',\n",
       " 'COURRIER',\n",
       " 'IDENTIFIANTPLU',\n",
       " 'TYPEIMPLANTATIONPLU',\n",
       " 'INTITULEPROTECTIONPLU',\n",
       " 'ANNEEABATTAGE',\n",
       " 'ESSOUCHEMENT',\n",
       " 'DIAMETREARBRE',\n",
       " 'CAUSEABATTAGE',\n",
       " 'COLLECTIVITE',\n",
       " 'GeoJSON']"
      ]
     },
     "execution_count": 221,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Quelles colonnes dans mon dataframe ?\n",
    "df_arbres.columns.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 222,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "31892"
      ]
     },
     "execution_count": 222,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Nombre de lignes dans mon dataframe\n",
    "nbre_lignes = df_arbres.shape[0]\n",
    "nbre_lignes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 223,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 31892 entries, 0 to 31891\n",
      "Data columns (total 32 columns):\n",
      " #   Column                 Non-Null Count  Dtype  \n",
      "---  ------                 --------------  -----  \n",
      " 0   ELEM_POINT_ID          31892 non-null  int64  \n",
      " 1   CODE                   31892 non-null  object \n",
      " 2   NOM                    31892 non-null  object \n",
      " 3   GENRE                  31892 non-null  object \n",
      " 4   GENRE_DESC             31892 non-null  object \n",
      " 5   CATEGORIE              31892 non-null  object \n",
      " 6   CATEGORIE_DESC         31892 non-null  object \n",
      " 7   SOUS_CATEGORIE         31892 non-null  object \n",
      " 8   SOUS_CATEGORIE_DESC    31892 non-null  object \n",
      " 9   CODE_PARENT            31892 non-null  object \n",
      " 10  CODE_PARENT_DESC       31892 non-null  object \n",
      " 11  ADR_SECTEUR            31892 non-null  int64  \n",
      " 12  BIEN_REFERENCE         31892 non-null  object \n",
      " 13  GENRE_BOTA             31454 non-null  object \n",
      " 14  ESPECE                 29710 non-null  object \n",
      " 15  VARIETE                4195 non-null   object \n",
      " 16  STADEDEDEVELOPPEMENT   29511 non-null  object \n",
      " 17  EQUIPE                 0 non-null      float64\n",
      " 18  REMARQUES              1512 non-null   object \n",
      " 19  ANNEEDEPLANTATION      31129 non-null  float64\n",
      " 20  RAISONDEPLANTATION     2744 non-null   object \n",
      " 21  TRAITEMENTCHENILLES    2265 non-null   object \n",
      " 22  COURRIER               0 non-null      float64\n",
      " 23  IDENTIFIANTPLU         604 non-null    float64\n",
      " 24  TYPEIMPLANTATIONPLU    604 non-null    object \n",
      " 25  INTITULEPROTECTIONPLU  604 non-null    object \n",
      " 26  ANNEEABATTAGE          0 non-null      float64\n",
      " 27  ESSOUCHEMENT           0 non-null      float64\n",
      " 28  DIAMETREARBRE          0 non-null      float64\n",
      " 29  CAUSEABATTAGE          0 non-null      float64\n",
      " 30  COLLECTIVITE           31498 non-null  object \n",
      " 31  GeoJSON                31892 non-null  object \n",
      "dtypes: float64(8), int64(2), object(22)\n",
      "memory usage: 7.8+ MB\n"
     ]
    }
   ],
   "source": [
    "df_arbres.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 224,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ELEM_POINT_ID</th>\n",
       "      <th>CODE</th>\n",
       "      <th>NOM</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>GENRE_DESC</th>\n",
       "      <th>CATEGORIE</th>\n",
       "      <th>CATEGORIE_DESC</th>\n",
       "      <th>SOUS_CATEGORIE</th>\n",
       "      <th>SOUS_CATEGORIE_DESC</th>\n",
       "      <th>CODE_PARENT</th>\n",
       "      <th>...</th>\n",
       "      <th>COURRIER</th>\n",
       "      <th>IDENTIFIANTPLU</th>\n",
       "      <th>TYPEIMPLANTATIONPLU</th>\n",
       "      <th>INTITULEPROTECTIONPLU</th>\n",
       "      <th>ANNEEABATTAGE</th>\n",
       "      <th>ESSOUCHEMENT</th>\n",
       "      <th>DIAMETREARBRE</th>\n",
       "      <th>CAUSEABATTAGE</th>\n",
       "      <th>COLLECTIVITE</th>\n",
       "      <th>GeoJSON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16750</td>\n",
       "      <td>ESP19318</td>\n",
       "      <td>ESP19318</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7394161255246...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20142</td>\n",
       "      <td>ESP18095</td>\n",
       "      <td>ESP18095</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7397428849165...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>23843</td>\n",
       "      <td>ESP17861</td>\n",
       "      <td>ESP17861</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7393229609447...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>23841</td>\n",
       "      <td>ESP17860</td>\n",
       "      <td>ESP17860</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7410808202830...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1778</td>\n",
       "      <td>ESP16403</td>\n",
       "      <td>ESP16403</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7408124079286...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31887</th>\n",
       "      <td>16922</td>\n",
       "      <td>ESP19587</td>\n",
       "      <td>ESP19587</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7251768715205...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31888</th>\n",
       "      <td>12659</td>\n",
       "      <td>ESP19291</td>\n",
       "      <td>ESP19291</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7260735681418...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31889</th>\n",
       "      <td>1869</td>\n",
       "      <td>ESP16427</td>\n",
       "      <td>ESP16427</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7253254570262...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31890</th>\n",
       "      <td>24296</td>\n",
       "      <td>ESP14848</td>\n",
       "      <td>ESP14848</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7262050374391...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31891</th>\n",
       "      <td>24289</td>\n",
       "      <td>ESP14846</td>\n",
       "      <td>ESP14846</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7251368334990...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>31892 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ELEM_POINT_ID      CODE       NOM GENRE  GENRE_DESC CATEGORIE  \\\n",
       "0              16750  ESP19318  ESP19318   VEG  VEGETATION     ESP01   \n",
       "1              20142  ESP18095  ESP18095   VEG  VEGETATION     ESP01   \n",
       "2              23843  ESP17861  ESP17861   VEG  VEGETATION     ESP01   \n",
       "3              23841  ESP17860  ESP17860   VEG  VEGETATION     ESP01   \n",
       "4               1778  ESP16403  ESP16403   VEG  VEGETATION     ESP01   \n",
       "...              ...       ...       ...   ...         ...       ...   \n",
       "31887          16922  ESP19587  ESP19587   VEG  VEGETATION     ESP01   \n",
       "31888          12659  ESP19291  ESP19291   VEG  VEGETATION     ESP01   \n",
       "31889           1869  ESP16427  ESP16427   VEG  VEGETATION     ESP01   \n",
       "31890          24296  ESP14848  ESP14848   VEG  VEGETATION     ESP01   \n",
       "31891          24289  ESP14846  ESP14846   VEG  VEGETATION     ESP01   \n",
       "\n",
       "      CATEGORIE_DESC SOUS_CATEGORIE      SOUS_CATEGORIE_DESC CODE_PARENT  ...  \\\n",
       "0              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "1              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "2              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "3              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "4              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "...              ...            ...                      ...         ...  ...   \n",
       "31887          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "31888          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "31889          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "31890          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "31891          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "\n",
       "      COURRIER  IDENTIFIANTPLU TYPEIMPLANTATIONPLU INTITULEPROTECTIONPLU  \\\n",
       "0          NaN             NaN                 NaN                   NaN   \n",
       "1          NaN             NaN                 NaN                   NaN   \n",
       "2          NaN             NaN                 NaN                   NaN   \n",
       "3          NaN             NaN                 NaN                   NaN   \n",
       "4          NaN             NaN                 NaN                   NaN   \n",
       "...        ...             ...                 ...                   ...   \n",
       "31887      NaN             NaN                 NaN                   NaN   \n",
       "31888      NaN             NaN                 NaN                   NaN   \n",
       "31889      NaN             NaN                 NaN                   NaN   \n",
       "31890      NaN             NaN                 NaN                   NaN   \n",
       "31891      NaN             NaN                 NaN                   NaN   \n",
       "\n",
       "      ANNEEABATTAGE ESSOUCHEMENT DIAMETREARBRE  CAUSEABATTAGE  \\\n",
       "0               NaN          NaN           NaN            NaN   \n",
       "1               NaN          NaN           NaN            NaN   \n",
       "2               NaN          NaN           NaN            NaN   \n",
       "3               NaN          NaN           NaN            NaN   \n",
       "4               NaN          NaN           NaN            NaN   \n",
       "...             ...          ...           ...            ...   \n",
       "31887           NaN          NaN           NaN            NaN   \n",
       "31888           NaN          NaN           NaN            NaN   \n",
       "31889           NaN          NaN           NaN            NaN   \n",
       "31890           NaN          NaN           NaN            NaN   \n",
       "31891           NaN          NaN           NaN            NaN   \n",
       "\n",
       "            COLLECTIVITE                                            GeoJSON  \n",
       "0      Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7394161255246...  \n",
       "1      Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7397428849165...  \n",
       "2      Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7393229609447...  \n",
       "3      Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7410808202830...  \n",
       "4      Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7408124079286...  \n",
       "...                  ...                                                ...  \n",
       "31887  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7251768715205...  \n",
       "31888  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7260735681418...  \n",
       "31889  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7253254570262...  \n",
       "31890  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7262050374391...  \n",
       "31891  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7251368334990...  \n",
       "\n",
       "[31892 rows x 32 columns]"
      ]
     },
     "execution_count": 224,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "❏\tExtraire l’information concernant l’année de plantation pour l’ensemble des lignes (rows) et stocker ces informations dans une variable de type List"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 225,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        1975.0\n",
       "1        1975.0\n",
       "2        2001.0\n",
       "3        1975.0\n",
       "4        2006.0\n",
       "          ...  \n",
       "31887    2005.0\n",
       "31888    1980.0\n",
       "31889    1980.0\n",
       "31890    1980.0\n",
       "31891    2005.0\n",
       "Name: ANNEEDEPLANTATION, Length: 31892, dtype: float64"
      ]
     },
     "execution_count": 225,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres['ANNEEDEPLANTATION']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Pour combien d’arbres manque-t-il l’information concernant la date de plantation ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 226,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "763"
      ]
     },
     "execution_count": 226,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres['ANNEEDEPLANTATION'].isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 227,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        False\n",
       "1        False\n",
       "2        False\n",
       "3        False\n",
       "4        False\n",
       "         ...  \n",
       "31887    False\n",
       "31888    False\n",
       "31889    False\n",
       "31890    False\n",
       "31891    False\n",
       "Name: ANNEEDEPLANTATION, Length: 31892, dtype: bool"
      ]
     },
     "execution_count": 227,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres['ANNEEDEPLANTATION'].isna()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Combien d’arbres sont recensés dans ce jeu de données ? "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 228,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "31892"
      ]
     },
     "execution_count": 228,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Nombre de lignes dans mon dataframe\n",
    "nbre_lignes = df_arbres.shape[0]\n",
    "nbre_lignes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ELEM_POINT_ID            31892\n",
       "CODE                     31892\n",
       "NOM                      31892\n",
       "GENRE                        1\n",
       "GENRE_DESC                   1\n",
       "CATEGORIE                    1\n",
       "CATEGORIE_DESC               1\n",
       "SOUS_CATEGORIE               4\n",
       "SOUS_CATEGORIE_DESC          4\n",
       "CODE_PARENT               1462\n",
       "CODE_PARENT_DESC          1462\n",
       "ADR_SECTEUR                  6\n",
       "BIEN_REFERENCE           31892\n",
       "GENRE_BOTA                 119\n",
       "ESPECE                     274\n",
       "VARIETE                    182\n",
       "STADEDEDEVELOPPEMENT         3\n",
       "EQUIPE                       0\n",
       "REMARQUES                   10\n",
       "ANNEEDEPLANTATION           62\n",
       "RAISONDEPLANTATION           3\n",
       "TRAITEMENTCHENILLES          3\n",
       "COURRIER                     0\n",
       "IDENTIFIANTPLU              46\n",
       "TYPEIMPLANTATIONPLU          4\n",
       "INTITULEPROTECTIONPLU        3\n",
       "ANNEEABATTAGE                0\n",
       "ESSOUCHEMENT                 0\n",
       "DIAMETREARBRE                0\n",
       "CAUSEABATTAGE                0\n",
       "COLLECTIVITE                 2\n",
       "GeoJSON                  31891\n",
       "dtype: int64"
      ]
     },
     "execution_count": 229,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Nombre de valeurs différentes dans mon dataframe (par colonne)\n",
    "df_arbres.nunique(axis='rows', dropna=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Combien d’arbres ont été plantés en moyenne chaque année "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "502.0806451612903"
      ]
     },
     "execution_count": 230,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres['ANNEEDEPLANTATION'].dropna().value_counts().mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ANNEEDEPLANTATION\n",
       "1924.0      12\n",
       "1944.0      27\n",
       "1950.0     409\n",
       "1955.0     118\n",
       "1959.0      16\n",
       "          ... \n",
       "2015.0    1028\n",
       "2016.0     518\n",
       "2017.0     638\n",
       "2018.0     778\n",
       "2019.0       7\n",
       "Length: 62, dtype: int64"
      ]
     },
     "execution_count": 231,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres.groupby(['ANNEEDEPLANTATION']).size()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Combien d’arbres ont été plantés en moyenne chaque année ?   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 232,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "502.0806451612903"
      ]
     },
     "execution_count": 232,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres['ANNEEDEPLANTATION'].value_counts().mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Afficher tous les arbres ayant été plantés l’année de votre naissance.\n",
    "Combien d’arbres ont été plantés depuis votre naissance ?\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "755"
      ]
     },
     "execution_count": 233,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres['ANNEEDEPLANTATION'].value_counts()[1987]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        1975.0\n",
       "1        1975.0\n",
       "2        2001.0\n",
       "3        1975.0\n",
       "4        2006.0\n",
       "          ...  \n",
       "31887    2005.0\n",
       "31888    1980.0\n",
       "31889    1980.0\n",
       "31890    1980.0\n",
       "31891    2005.0\n",
       "Name: ANNEEDEPLANTATION, Length: 31892, dtype: float64"
      ]
     },
     "execution_count": 234,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres['ANNEEDEPLANTATION']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ELEM_POINT_ID</th>\n",
       "      <th>CODE</th>\n",
       "      <th>NOM</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>GENRE_DESC</th>\n",
       "      <th>CATEGORIE</th>\n",
       "      <th>CATEGORIE_DESC</th>\n",
       "      <th>SOUS_CATEGORIE</th>\n",
       "      <th>SOUS_CATEGORIE_DESC</th>\n",
       "      <th>CODE_PARENT</th>\n",
       "      <th>...</th>\n",
       "      <th>COURRIER</th>\n",
       "      <th>IDENTIFIANTPLU</th>\n",
       "      <th>TYPEIMPLANTATIONPLU</th>\n",
       "      <th>INTITULEPROTECTIONPLU</th>\n",
       "      <th>ANNEEABATTAGE</th>\n",
       "      <th>ESSOUCHEMENT</th>\n",
       "      <th>DIAMETREARBRE</th>\n",
       "      <th>CAUSEABATTAGE</th>\n",
       "      <th>COLLECTIVITE</th>\n",
       "      <th>GeoJSON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>23843</td>\n",
       "      <td>ESP17861</td>\n",
       "      <td>ESP17861</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7393229609447...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1778</td>\n",
       "      <td>ESP16403</td>\n",
       "      <td>ESP16403</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7408124079286...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1771</td>\n",
       "      <td>ESP16397</td>\n",
       "      <td>ESP16397</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7414276752629...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1770</td>\n",
       "      <td>ESP16396</td>\n",
       "      <td>ESP16396</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7402998860285...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1737</td>\n",
       "      <td>ESP16378</td>\n",
       "      <td>ESP16378</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7406793578916...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31873</th>\n",
       "      <td>13287</td>\n",
       "      <td>ESP20843</td>\n",
       "      <td>ESP20843</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7249614557455...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31874</th>\n",
       "      <td>24291</td>\n",
       "      <td>ESP20754</td>\n",
       "      <td>ESP20754</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7248757297925...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31885</th>\n",
       "      <td>9482</td>\n",
       "      <td>ESP19797</td>\n",
       "      <td>ESP19797</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7246973133776...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31887</th>\n",
       "      <td>16922</td>\n",
       "      <td>ESP19587</td>\n",
       "      <td>ESP19587</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7251768715205...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31891</th>\n",
       "      <td>24289</td>\n",
       "      <td>ESP14846</td>\n",
       "      <td>ESP14846</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP989</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7251368334990...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14504 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ELEM_POINT_ID      CODE       NOM GENRE  GENRE_DESC CATEGORIE  \\\n",
       "2              23843  ESP17861  ESP17861   VEG  VEGETATION     ESP01   \n",
       "4               1778  ESP16403  ESP16403   VEG  VEGETATION     ESP01   \n",
       "9               1771  ESP16397  ESP16397   VEG  VEGETATION     ESP01   \n",
       "10              1770  ESP16396  ESP16396   VEG  VEGETATION     ESP01   \n",
       "13              1737  ESP16378  ESP16378   VEG  VEGETATION     ESP01   \n",
       "...              ...       ...       ...   ...         ...       ...   \n",
       "31873          13287  ESP20843  ESP20843   VEG  VEGETATION     ESP01   \n",
       "31874          24291  ESP20754  ESP20754   VEG  VEGETATION     ESP01   \n",
       "31885           9482  ESP19797  ESP19797   VEG  VEGETATION     ESP01   \n",
       "31887          16922  ESP19587  ESP19587   VEG  VEGETATION     ESP01   \n",
       "31891          24289  ESP14846  ESP14846   VEG  VEGETATION     ESP01   \n",
       "\n",
       "      CATEGORIE_DESC SOUS_CATEGORIE      SOUS_CATEGORIE_DESC CODE_PARENT  ...  \\\n",
       "2              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "4              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "9              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "10             Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "13             Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "...              ...            ...                      ...         ...  ...   \n",
       "31873          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "31874          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "31885          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "31887          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "31891          Arbre         ESP174  Arbre d'espaces ouverts      ESP989  ...   \n",
       "\n",
       "      COURRIER  IDENTIFIANTPLU TYPEIMPLANTATIONPLU INTITULEPROTECTIONPLU  \\\n",
       "2          NaN             NaN                 NaN                   NaN   \n",
       "4          NaN             NaN                 NaN                   NaN   \n",
       "9          NaN             NaN                 NaN                   NaN   \n",
       "10         NaN             NaN                 NaN                   NaN   \n",
       "13         NaN             NaN                 NaN                   NaN   \n",
       "...        ...             ...                 ...                   ...   \n",
       "31873      NaN             NaN                 NaN                   NaN   \n",
       "31874      NaN             NaN                 NaN                   NaN   \n",
       "31885      NaN             NaN                 NaN                   NaN   \n",
       "31887      NaN             NaN                 NaN                   NaN   \n",
       "31891      NaN             NaN                 NaN                   NaN   \n",
       "\n",
       "      ANNEEABATTAGE ESSOUCHEMENT DIAMETREARBRE  CAUSEABATTAGE  \\\n",
       "2               NaN          NaN           NaN            NaN   \n",
       "4               NaN          NaN           NaN            NaN   \n",
       "9               NaN          NaN           NaN            NaN   \n",
       "10              NaN          NaN           NaN            NaN   \n",
       "13              NaN          NaN           NaN            NaN   \n",
       "...             ...          ...           ...            ...   \n",
       "31873           NaN          NaN           NaN            NaN   \n",
       "31874           NaN          NaN           NaN            NaN   \n",
       "31885           NaN          NaN           NaN            NaN   \n",
       "31887           NaN          NaN           NaN            NaN   \n",
       "31891           NaN          NaN           NaN            NaN   \n",
       "\n",
       "            COLLECTIVITE                                            GeoJSON  \n",
       "2      Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7393229609447...  \n",
       "4      Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7408124079286...  \n",
       "9      Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7414276752629...  \n",
       "10     Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7402998860285...  \n",
       "13     Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7406793578916...  \n",
       "...                  ...                                                ...  \n",
       "31873  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7249614557455...  \n",
       "31874  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7248757297925...  \n",
       "31885  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7246973133776...  \n",
       "31887  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7251768715205...  \n",
       "31891  Ville de Grenoble  {\"type\":\"Point\",\"coordinates\":[5.7251368334990...  \n",
       "\n",
       "[14504 rows x 32 columns]"
      ]
     },
     "execution_count": 235,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres[df_arbres['ANNEEDEPLANTATION']>1987]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 236,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14504"
      ]
     },
     "execution_count": 236,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres[df_arbres['ANNEEDEPLANTATION']>1987]['ANNEEDEPLANTATION'].value_counts().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "❏\tPour combien d'arbres manque-t-il l’information concernant le genre botanique ?  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GENRE_BOTA           438\n",
       "ANNEEDEPLANTATION    763\n",
       "dtype: int64"
      ]
     },
     "execution_count": 237,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres[['GENRE_BOTA','ANNEEDEPLANTATION']].isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 271,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GENRE_BOTA  ANNEEDEPLANTATION\n",
       "Acer        1975.0               1086\n",
       "Platanus    1975.0                615\n",
       "Acer        1970.0                422\n",
       "Platanus    1950.0                370\n",
       "            1976.0                364\n",
       "                                 ... \n",
       "Ilex        1967.0                  1\n",
       "Sophora     2016.0                  1\n",
       "Ilex        1924.0                  1\n",
       "Hovenia     2014.0                  1\n",
       "Poncinos    1960.0                  1\n",
       "Length: 1815, dtype: int64"
      ]
     },
     "execution_count": 271,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres[[\"GENRE_BOTA\",\"ANNEEDEPLANTATION\"]].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Tracer l’histogramme représentant le nombre d’arbres plantés par année.   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 238,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 238,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAD4CAYAAADrRI2NAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/d3fzzAAAACXBIWXMAAAsTAAALEwEAmpwYAAAXrElEQVR4nO3df4wcZ33H8fcnThqMj/zC5OTYrs5VTVXHgYBPxhVNWZNAjoDqRCWVQ4ptJZVRZCRQQxubIhEauTKUH20UknLUkZ0GOLlAFJPERMFiS0EOxqYBx05MDLGCfygWNCQ+pLrYfPvHPDYTZ+9u93a9e3vP5yWtdvaZeWbnO7f3ublnZncVEZiZWT7O6vQGmJlZezn4zcwy4+A3M8uMg9/MLDMOfjOzzJzd6Q0Yy/Tp06Ovr49f//rXTJs2rdOb0zGu3/W7ftdfr+nTp/Poo48+GhEDteZP+ODv6+tjx44dVKtVKpVKpzenY1y/63f9lU5vRseMp35J00ea56EeM7PMOPjNzDLj4Dczy4yD38wsMw5+M7PMOPjNzDLj4Dczy4yD38wsMw5+M7PMTPh37pp1s77VD5+a3r/u3R3cErPf8RG/mVlmHPxmZplx8JuZZcbBb2aWGQe/mVlmHPxmZplx8JuZZcbBb2aWGQe/mVlmHPxmZplx8JuZZWbM4Jf0KknbJf1I0m5Jn0jtt0s6KOmJdLum1GeNpH2S9kq6utS+QNKuNO9OSTozZZmZ2Ujq+ZC2Y8DbI2JY0jnAdyVtSfM+FxGfLi8saR6wFLgUuAT4lqTXR8QJ4B5gJfA48AgwAGzBzMzaZswj/igMp4fnpFuM0mUJMBQRxyLiWWAfsFDSDOC8iNgWEQHcB1zb1NabmVnD6vpYZklTgJ3AHwKfj4jvS3oX8EFJy4AdwK0R8QIwk+KI/qQDqe03afr09lrPt5LiPwN6e3upVqsMDw9TrVYbqW1Scf3dWf+tlx0/Nd3M9ndr/a3i+ltbf13Bn4ZpLpd0AfCApPkUwzZ3UBz93wF8BrgJqDVuH6O013q+QWAQoL+/PyqVCtVqlUqlUs/mTkquvzvrX1H+PP4bK+NeT7fW3yquv7X1N3RVT0T8CqgCAxHxfESciIjfAl8EFqbFDgCzS91mAYdS+6wa7WZm1kb1XNXzunSkj6SpwFXA02nM/qTrgCfT9GZgqaRzJc0B5gLbI+IwcFTSonQ1zzLgwdaVYmZm9ahnqGcGsDGN858FbIqIhyT9u6TLKYZr9gMfAIiI3ZI2AXuA48CqNFQEcAuwAZhKcTWPr+gxM2uzMYM/In4MvKlG+/tH6bMWWFujfQcwv8FtNDOzFvI7d83MMuPgNzPLjIPfzCwzDn4zs8w4+M3MMuPgNzPLjIPfzCwzDn4zs8w4+M3MMuPgNzPLjIPfzCwzDn4zs8w4+M3MMuPgNzPLjIPfzCwzDn4zs8w4+M3MMuPgNzPLTD1ftv4qSdsl/UjSbkmfSO0XSXpM0jPp/sJSnzWS9knaK+nqUvsCSbvSvDvTl66bmVkb1XPEfwx4e0S8EbgcGJC0CFgNbI2IucDW9BhJ84ClwKXAAHB3+qJ2gHuAlcDcdBtoXSlmZlaPMYM/CsPp4TnpFsASYGNq3whcm6aXAEMRcSwingX2AQslzQDOi4htERHAfaU+ZmbWJnWN8UuaIukJ4AjwWER8H+iNiMMA6f7itPhM4Oel7gdS28w0fXq7mZm10dn1LBQRJ4DLJV0APCBp/iiL1xq3j1HaX7kCaSXFkBC9vb1Uq1WGh4epVqv1bO6k5Pq7s/5bLzt+arqZ7e/W+lvF9be2/rqC/6SI+JWkKsXY/POSZkTE4TSMcyQtdgCYXeo2CziU2mfVaK/1PIPAIEB/f39UKhWq1SqVSqWRzZ1UXH931r9i9cOnpvffWBn3erq1/lZx/a2tv56rel6XjvSRNBW4Cnga2AwsT4stBx5M05uBpZLOlTSH4iTu9jQcdFTSonQ1z7JSHzMza5N6jvhnABvTlTlnAZsi4iFJ24BNkm4GngOuB4iI3ZI2AXuA48CqNFQEcAuwAZgKbEk3MzNrozGDPyJ+DLypRvsvgStH6LMWWFujfQcw2vkBMzM7w/zOXTOzzDj4zcwy4+A3M8uMg9/MLDMOfjOzzDj4zcwy4+A3M8uMg9/MLDMOfjOzzDj4zcwy4+A3M8uMg9/MLDMOfjOzzDj4zcwy4+A3M8uMg9/MLDMOfjOzzDj4zcwy4+A3M8vMmMEvabakb0t6StJuSR9K7bdLOijpiXS7ptRnjaR9kvZKurrUvkDSrjTvTkk6M2WZmdlIxvyydeA4cGtE/FDSa4Cdkh5L8z4XEZ8uLyxpHrAUuBS4BPiWpNdHxAngHmAl8DjwCDAAbGlNKWZmVo8xj/gj4nBE/DBNHwWeAmaO0mUJMBQRxyLiWWAfsFDSDOC8iNgWEQHcB1zbbAFmZtYYFRlc58JSH/AdYD7wN8AK4CVgB8V/BS9Iugt4PCLuT33WUxzV7wfWRcRVqf0K4LaIeE+N51lJ8Z8Bvb29C4aGhhgeHqanp2ecZXY/19+d9e86+OKp6ctmnj/u9XRr/a3i+huvf/HixTsjor/WvHqGegCQ1AN8DfhwRLwk6R7gDiDS/WeAm4Ba4/YxSvsrGyMGgUGA/v7+qFQqVKtVKpVKvZs76bj+7qx/xeqHT03vv7Ey7vV0a/2t4vpbW39dV/VIOoci9L8UEV8HiIjnI+JERPwW+CKwMC1+AJhd6j4LOJTaZ9VoNzOzNqrnqh4B64GnIuKzpfYZpcWuA55M05uBpZLOlTQHmAtsj4jDwFFJi9I6lwEPtqgOMzOrUz1DPW8F3g/skvREavsocIOkyymGa/YDHwCIiN2SNgF7KK4IWpWu6AG4BdgATKUY9/cVPWZmbTZm8EfEd6k9Pv/IKH3WAmtrtO+gODFsZmYd4nfumpllxsFvZpYZB7+ZWWYc/GZmmXHwm5llxsFvZpYZB7+ZWWYc/GZmmXHwm5llxsFvZpYZB7+ZWWYc/GZmmXHwm5llxsFvZpYZB7+ZWWYc/GZmmXHwm5llxsFvZpaZer5sfbakb0t6StJuSR9K7RdJekzSM+n+wlKfNZL2Sdor6epS+wJJu9K8O9OXrpuZWRvVc8R/HLg1Iv4YWASskjQPWA1sjYi5wNb0mDRvKXApMADcLWlKWtc9wEpgbroNtLAWMzOrw5jBHxGHI+KHafoo8BQwE1gCbEyLbQSuTdNLgKGIOBYRzwL7gIWSZgDnRcS2iAjgvlIfMzNrExUZXOfCUh/wHWA+8FxEXFCa90JEXCjpLuDxiLg/ta8HtgD7gXURcVVqvwK4LSLeU+N5VlL8Z0Bvb++CoaEhhoeH6enpGVeRk4Hr7876dx188dT0ZTPPH/d6urX+VnH9jde/ePHinRHRX2ve2fWuRFIP8DXgwxHx0ijD87VmxCjtr2yMGAQGAfr7+6NSqVCtVqlUKvVu7qTj+ruz/hWrHz41vf/GyrjX0631t4rrb239dV3VI+kcitD/UkR8PTU/n4ZvSPdHUvsBYHap+yzgUGqfVaPdzMzaqJ6regSsB56KiM+WZm0Glqfp5cCDpfalks6VNIfiJO72iDgMHJW0KK1zWamPmZm1ST1DPW8F3g/skvREavsosA7YJOlm4DngeoCI2C1pE7CH4oqgVRFxIvW7BdgATKUY99/SmjLMzKxeYwZ/RHyX2uPzAFeO0GctsLZG+w6KE8NmZtYhfueumVlmHPxmZplx8JuZZcbBb2aWGQe/mVlmHPxmZplx8JuZZcbBb2aWGQe/mVlmHPxmZplx8JuZZcbBb2aWGQe/mVlmHPxmZplx8JuZZcbBb2aWmbq/bN3MbCLoK3+B/bp3d3BLupeP+M3MMuPgNzPLzJjBL+leSUckPVlqu13SQUlPpNs1pXlrJO2TtFfS1aX2BZJ2pXl3Shrpe3zNzOwMqueIfwMwUKP9cxFxebo9AiBpHrAUuDT1uVvSlLT8PcBKYG661VqnmZmdYWOe3I2I70jqq3N9S4ChiDgGPCtpH7BQ0n7gvIjYBiDpPuBaYMt4NtosB+WTmBsGpnVwS2yyUUSMvVAR/A9FxPz0+HZgBfASsAO4NSJekHQX8HhE3J+WW08R7vuBdRFxVWq/ArgtIt4zwvOtpPjvgN7e3gVDQ0MMDw/T09Mz/kq7nOvvzvp3HXzx1PRlM88fd98550/pyvpbpfzzb2afdqvxvP4XL168MyL6a80b7+Wc9wB3AJHuPwPcBNQat49R2muKiEFgEKC/vz8qlQrVapVKpTLOze1+rr87619RvvTwxsq4+24YmNaV9bdK+effzD7tVq1+/Y/rqp6IeD4iTkTEb4EvAgvTrAPA7NKis4BDqX1WjXYzM2uzcQW/pBmlh9cBJ6/42QwslXSupDkUJ3G3R8Rh4KikRelqnmXAg01st5mZjdOYQz2SvgJUgOmSDgAfByqSLqcYrtkPfAAgInZL2gTsAY4DqyLiRFrVLRRXCE2lGPf3iV0zsw6o56qeG2o0rx9l+bXA2hrtO4D5DW2dmZm1nD+rx2wM/mwYm2z8kQ1mZplx8JuZZcbBb2aWGQe/mVlmHPxmZplx8JuZZcbBb2aWGQe/mVlmHPxmZplx8JuZZcbBb2aWGQe/mVlmHPxmZplx8JuZZcbBb2aWGQe/mVlmHPxmZpkZM/gl3SvpiKQnS20XSXpM0jPp/sLSvDWS9knaK+nqUvsCSbvSvDvTl66bmVmb1XPEvwEYOK1tNbA1IuYCW9NjJM0DlgKXpj53S5qS+twDrATmptvp6zQzszao58vWvyOp77TmJUAlTW8EqsBtqX0oIo4Bz0raByyUtB84LyK2AUi6D7gW2NJ0BWZmE9RE/b5mRcTYCxXB/1BEzE+PfxURF5TmvxARF0q6C3g8Iu5P7espwn0/sC4irkrtVwC3RcR7Rni+lRT/HdDb27tgaGiI4eFhenp6xl1ot3P9nat/18EXT01fNvP8jvSdc/4U//xT/c3s03Zr1baO5/W/ePHinRHRX2vemEf8Dao1bh+jtNcUEYPAIEB/f39UKhWq1SqVSqUlG9mNXH/n6l9RPmq7sbFtaFXfDQPT/PNP9TezT9utVdva6tf/eK/qeV7SDIB0fyS1HwBml5abBRxK7bNqtJuZWZuNN/g3A8vT9HLgwVL7UknnSppDcRJ3e0QcBo5KWpSu5llW6mNmZm005lCPpK9QnMidLukA8HFgHbBJ0s3Ac8D1ABGxW9ImYA9wHFgVESfSqm6huEJoKsW4v0/sWlY6eaJvop5ktM6o56qeG0aYdeUIy68F1tZo3wHMb2jrzMy6TPmP7ETld+6amWXGwW9mlplWX85pZg3y+Lu1m4/4zcwy4+A3M8uMg9/MLDMe4zcz66BOnONx8JtlzCeW8+Tgtyw44DrD+31i8hi/mVlmfMRvE9rJI8ZbLzt+6pt/zKw5PuI3M8uMj/jNzE4z2c9NOPjNJqlu+JRI6wwHv5lZm3X6j7KD36wDmv3Fn+xDEXZmOfjNLCv+o+ngN7MJxKHcHk1dzilpv6Rdkp6QtCO1XSTpMUnPpPsLS8uvkbRP0l5JVze78WZm1rhWXMe/OCIuj4j+9Hg1sDUi5gJb02MkzQOWApcCA8Ddkqa04PnNzKwBZ2KoZwmcepPlRqAK3JbahyLiGPCspH3AQmDbGdgGM7OWa2YoqtNX8pQpIsbfWXoWeAEI4AsRMSjpVxFxQWmZFyLiQkl3AY9HxP2pfT2wJSK+WmO9K4GVAL29vQuGhoYYHh6mp6dn3Nva7XKtf9fBFwHonQoXX3R+0+sBuGxmY+tpVd96lNdf7jvn/Ckv+/nXs00jPfdIz9FobfVodP0jLV9+/Te7zY3uu0b3V6M/87KR1jme3//FixfvLI3EvEyzR/xvjYhDki4GHpP09CjLqkZbzb86ETEIDAL09/dHpVKhWq1SqVSa3NzulWv9K0qf1fOXTdS/onykdmNj62lV33qU11/uu2Fg2st+/vVs00jPPdJzNFpbPRpd/0jLl1//zW5zo/uu0f3V6M+8bKR1tvr3v6kx/og4lO6PAA9QDN08L2kGQLo/khY/AMwudZ8FHGrm+c3MrHHjPuKXNA04KyKOpul3Av8AbAaWA+vS/YOpy2bgy5I+C1wCzAW2N7HtZpaJXQdfbOpIuhkTaWy+VZoZ6ukFHpB0cj1fjohvSvoBsEnSzcBzwPUAEbFb0iZgD3AcWBURJ5raejMza9i4gz8ifga8sUb7L4ErR+izFlg73ue0zvCbavLmn//k43fumtmkNxmHa5rh4Dfrct1yRN4t25kDfwOXmVlmfMRvNk5n4gjWQxLN8f6rj4PfzLpWJ4O+m//IOPjNaujWX+pWbXe31m/1cfCbtZhD0yY6B7+ZtZT/8E18Dn4zAxzYOXHwm2VmIgS8r+nvLAe/mY1Lq8J7IvwhgomzHe3gN3CZmWXGwW9mlhkHv5lZZjzGb2Z1G2kcvFvHx7t1u5vl4LczyldvmE08Dn6zJNejP8uPg9+y4/9CLHcOfrMG+L8CmwzaHvySBoB/AaYA/xYR69q9DWYnOcgtR20NfklTgM8D7wAOAD+QtDki9rRzO3LhIY328R8Q6ybtPuJfCOyLiJ8BSBoClgBnJPgdfN2nlQHqMLZu067MUkScsZW/4smk9wIDEfHX6fH7gbdExAdPW24lsDI9/CNgLzAd+EXbNnbicf2u3/Xnq9H6fwEQEQO1Zrb7iF812l7xlyciBoHBl3WUdkRE/5nasInO9bt+1+/6W7W+dn9kwwFgdunxLOBQm7fBzCxr7Q7+HwBzJc2R9HvAUmBzm7fBzCxrbR3qiYjjkj4IPEpxOee9EbG7zu6DYy8yqbn+vLn+vLW0/rae3DUzs87zxzKbmWXGwW9mlpmOBb+keyUdkfRkqe2NkrZJ2iXpG5LOS+3vkLQzte+U9PZSnwWpfZ+kOyXVumR0QmpkH5Tm/76kYUkfKbV15T5otH5Jb0jzdqf5r0rtk75+SedI2pjan5K0ptSn6+qXNFvSt1MtuyV9KLVfJOkxSc+k+wtLfdakGvdKurrUPunrb3kGRkRHbsCfAW8Gniy1/QB4W5q+CbgjTb8JuCRNzwcOlvpsB/6E4j0CW4B3daqmM7kPSvO/BvwH8JFu3wcNvgbOBn4MvDE9fi0wJaP63wcMpelXA/uBvm6tH5gBvDlNvwb4CTAP+BSwOrWvBj6ZpucBPwLOBeYAP+3mn/846m9pBna6+L7TXvQv8bsTzrOBPTX6CPhlegHMAJ4uzbsB+EKnf6hnah8A1wL/BNxOCv5u3wf11g9cA9xfo38u9d8AfIPiD+BrU1Bc1O31l7b7QYrP8NoLzCj9bPem6TXAmtLyj6awy6L+05ZtOgMn2hj/k8Cfp+nrefmbvU76C+C/I+IYMJPiTWEnHUht3azmPpA0DbgN+MRpy0+2fTDSa+D1QEh6VNIPJf1das+l/q8CvwYOA88Bn46I/2ES1C+pj+KI9vtAb0QcBkj3F6fFZgI/L3U7WWcu9Zc1nYETLfhvAlZJ2knx78//lWdKuhT4JPCBk0011tHt16eOtA8+AXwuIoZPW36y7YOR6j8b+FPgxnR/naQryaf+hcAJ4BKKoY5bJf0BXV6/pB6K4csPR8RLoy1aoy1Gae8KDdR/cvmWZOCE+iKWiHgaeCeApNcDpz6eTtIs4AFgWUT8NDUfoPjYh5O6/iMgRtkHbwHeK+lTwAXAbyX9L8WLZtLsg1HqPwD8Z0T8Is17hGJ8/H7yqP99wDcj4jfAEUnfA/qB/6JL65d0DsXr90sR8fXU/LykGRFxWNIM4EhqH+njXro2Axqsv6UZOKGO+CVdnO7PAj4G/Gt6fAHwMMUY3/dOLp/+FToqaVE6k72MYqysa420DyLiiojoi4g+4J+Bf4yIuybbPhipfoox3TdIerWks4G3UYx/51L/c8DbVZgGLKIY2+3K+tO2rgeeiojPlmZtBpan6eX8rpbNwFJJ50qaA8wFtudSf8szsIMnM75CMV75G4q/WjcDH6I4afUTYB2/O8n1MYrxzSdKt4vTvH6KcdGfAned7NMNt0b2wWn9buflV/V05T5otH7gr4DdqdZP5VQ/0ENxNdduiu+v+Nturp9iuC4ortQ6+Tt9DcWJ663AM+n+olKfv0817qV05UoO9bc6A/2RDWZmmZlQQz1mZnbmOfjNzDLj4Dczy4yD38wsMw5+M7PMOPjNzDLj4Dczy8z/A6huor7pymwpAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_arbres['ANNEEDEPLANTATION'].hist(bins=100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_copy = df_arbres.dropna(subset=['ANNEEDEPLANTATION']).copy()\n",
    "df_copy.set_index('ANNEEDEPLANTATION', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 240,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ELEM_POINT_ID</th>\n",
       "      <th>CODE</th>\n",
       "      <th>NOM</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>GENRE_DESC</th>\n",
       "      <th>CATEGORIE</th>\n",
       "      <th>CATEGORIE_DESC</th>\n",
       "      <th>SOUS_CATEGORIE</th>\n",
       "      <th>SOUS_CATEGORIE_DESC</th>\n",
       "      <th>CODE_PARENT</th>\n",
       "      <th>...</th>\n",
       "      <th>COURRIER</th>\n",
       "      <th>IDENTIFIANTPLU</th>\n",
       "      <th>TYPEIMPLANTATIONPLU</th>\n",
       "      <th>INTITULEPROTECTIONPLU</th>\n",
       "      <th>ANNEEABATTAGE</th>\n",
       "      <th>ESSOUCHEMENT</th>\n",
       "      <th>DIAMETREARBRE</th>\n",
       "      <th>CAUSEABATTAGE</th>\n",
       "      <th>COLLECTIVITE</th>\n",
       "      <th>GeoJSON</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANNEEDEPLANTATION</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1924.0</th>\n",
       "      <td>16012</td>\n",
       "      <td>ESP18024</td>\n",
       "      <td>ESP18024</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP981</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7350162044851...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1924.0</th>\n",
       "      <td>12373</td>\n",
       "      <td>ESP20153</td>\n",
       "      <td>ESP20153</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP981</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7350233621128...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1924.0</th>\n",
       "      <td>12370</td>\n",
       "      <td>ESP20152</td>\n",
       "      <td>ESP20152</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP981</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7353026591257...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1924.0</th>\n",
       "      <td>931</td>\n",
       "      <td>ESP15016</td>\n",
       "      <td>ESP15016</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP981</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7352181245933...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1924.0</th>\n",
       "      <td>19650</td>\n",
       "      <td>ESP7574</td>\n",
       "      <td>ESP7574</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP981</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7350190879045...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019.0</th>\n",
       "      <td>41383</td>\n",
       "      <td>ESP39336</td>\n",
       "      <td>ESP39336</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP1106</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7349610995669...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019.0</th>\n",
       "      <td>41386</td>\n",
       "      <td>ESP39339</td>\n",
       "      <td>ESP39339</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP1106</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7352918876162...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019.0</th>\n",
       "      <td>41382</td>\n",
       "      <td>ESP39335</td>\n",
       "      <td>ESP39335</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP587</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grenoble Alpes Métropole</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.729852719671,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019.0</th>\n",
       "      <td>41381</td>\n",
       "      <td>ESP39334</td>\n",
       "      <td>ESP39334</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP587</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grenoble Alpes Métropole</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7296272854763...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019.0</th>\n",
       "      <td>36551</td>\n",
       "      <td>ESP37123</td>\n",
       "      <td>ESP37123</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP151</td>\n",
       "      <td>Arbre de voirie</td>\n",
       "      <td>ESP482</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grenoble Alpes Métropole</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7183438320247...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>31129 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   ELEM_POINT_ID      CODE       NOM GENRE  GENRE_DESC  \\\n",
       "ANNEEDEPLANTATION                                                        \n",
       "1924.0                     16012  ESP18024  ESP18024   VEG  VEGETATION   \n",
       "1924.0                     12373  ESP20153  ESP20153   VEG  VEGETATION   \n",
       "1924.0                     12370  ESP20152  ESP20152   VEG  VEGETATION   \n",
       "1924.0                       931  ESP15016  ESP15016   VEG  VEGETATION   \n",
       "1924.0                     19650   ESP7574   ESP7574   VEG  VEGETATION   \n",
       "...                          ...       ...       ...   ...         ...   \n",
       "2019.0                     41383  ESP39336  ESP39336   VEG  VEGETATION   \n",
       "2019.0                     41386  ESP39339  ESP39339   VEG  VEGETATION   \n",
       "2019.0                     41382  ESP39335  ESP39335   VEG  VEGETATION   \n",
       "2019.0                     41381  ESP39334  ESP39334   VEG  VEGETATION   \n",
       "2019.0                     36551  ESP37123  ESP37123   VEG  VEGETATION   \n",
       "\n",
       "                  CATEGORIE CATEGORIE_DESC SOUS_CATEGORIE  \\\n",
       "ANNEEDEPLANTATION                                           \n",
       "1924.0                ESP01          Arbre         ESP174   \n",
       "1924.0                ESP01          Arbre         ESP174   \n",
       "1924.0                ESP01          Arbre         ESP174   \n",
       "1924.0                ESP01          Arbre         ESP174   \n",
       "1924.0                ESP01          Arbre         ESP174   \n",
       "...                     ...            ...            ...   \n",
       "2019.0                ESP01          Arbre         ESP174   \n",
       "2019.0                ESP01          Arbre         ESP174   \n",
       "2019.0                ESP01          Arbre         ESP174   \n",
       "2019.0                ESP01          Arbre         ESP174   \n",
       "2019.0                ESP01          Arbre         ESP151   \n",
       "\n",
       "                       SOUS_CATEGORIE_DESC CODE_PARENT  ... COURRIER  \\\n",
       "ANNEEDEPLANTATION                                       ...            \n",
       "1924.0             Arbre d'espaces ouverts      ESP981  ...      NaN   \n",
       "1924.0             Arbre d'espaces ouverts      ESP981  ...      NaN   \n",
       "1924.0             Arbre d'espaces ouverts      ESP981  ...      NaN   \n",
       "1924.0             Arbre d'espaces ouverts      ESP981  ...      NaN   \n",
       "1924.0             Arbre d'espaces ouverts      ESP981  ...      NaN   \n",
       "...                                    ...         ...  ...      ...   \n",
       "2019.0             Arbre d'espaces ouverts     ESP1106  ...      NaN   \n",
       "2019.0             Arbre d'espaces ouverts     ESP1106  ...      NaN   \n",
       "2019.0             Arbre d'espaces ouverts      ESP587  ...      NaN   \n",
       "2019.0             Arbre d'espaces ouverts      ESP587  ...      NaN   \n",
       "2019.0                     Arbre de voirie      ESP482  ...      NaN   \n",
       "\n",
       "                   IDENTIFIANTPLU TYPEIMPLANTATIONPLU INTITULEPROTECTIONPLU  \\\n",
       "ANNEEDEPLANTATION                                                             \n",
       "1924.0                        NaN                 NaN                   NaN   \n",
       "1924.0                        NaN                 NaN                   NaN   \n",
       "1924.0                        NaN                 NaN                   NaN   \n",
       "1924.0                        NaN                 NaN                   NaN   \n",
       "1924.0                        NaN                 NaN                   NaN   \n",
       "...                           ...                 ...                   ...   \n",
       "2019.0                        NaN                 NaN                   NaN   \n",
       "2019.0                        NaN                 NaN                   NaN   \n",
       "2019.0                        NaN                 NaN                   NaN   \n",
       "2019.0                        NaN                 NaN                   NaN   \n",
       "2019.0                        NaN                 NaN                   NaN   \n",
       "\n",
       "                  ANNEEABATTAGE ESSOUCHEMENT DIAMETREARBRE  CAUSEABATTAGE  \\\n",
       "ANNEEDEPLANTATION                                                           \n",
       "1924.0                      NaN          NaN           NaN            NaN   \n",
       "1924.0                      NaN          NaN           NaN            NaN   \n",
       "1924.0                      NaN          NaN           NaN            NaN   \n",
       "1924.0                      NaN          NaN           NaN            NaN   \n",
       "1924.0                      NaN          NaN           NaN            NaN   \n",
       "...                         ...          ...           ...            ...   \n",
       "2019.0                      NaN          NaN           NaN            NaN   \n",
       "2019.0                      NaN          NaN           NaN            NaN   \n",
       "2019.0                      NaN          NaN           NaN            NaN   \n",
       "2019.0                      NaN          NaN           NaN            NaN   \n",
       "2019.0                      NaN          NaN           NaN            NaN   \n",
       "\n",
       "                               COLLECTIVITE  \\\n",
       "ANNEEDEPLANTATION                             \n",
       "1924.0                    Ville de Grenoble   \n",
       "1924.0                    Ville de Grenoble   \n",
       "1924.0                    Ville de Grenoble   \n",
       "1924.0                    Ville de Grenoble   \n",
       "1924.0                    Ville de Grenoble   \n",
       "...                                     ...   \n",
       "2019.0                    Ville de Grenoble   \n",
       "2019.0                    Ville de Grenoble   \n",
       "2019.0             Grenoble Alpes Métropole   \n",
       "2019.0             Grenoble Alpes Métropole   \n",
       "2019.0             Grenoble Alpes Métropole   \n",
       "\n",
       "                                                             GeoJSON  \n",
       "ANNEEDEPLANTATION                                                     \n",
       "1924.0             {\"type\":\"Point\",\"coordinates\":[5.7350162044851...  \n",
       "1924.0             {\"type\":\"Point\",\"coordinates\":[5.7350233621128...  \n",
       "1924.0             {\"type\":\"Point\",\"coordinates\":[5.7353026591257...  \n",
       "1924.0             {\"type\":\"Point\",\"coordinates\":[5.7352181245933...  \n",
       "1924.0             {\"type\":\"Point\",\"coordinates\":[5.7350190879045...  \n",
       "...                                                              ...  \n",
       "2019.0             {\"type\":\"Point\",\"coordinates\":[5.7349610995669...  \n",
       "2019.0             {\"type\":\"Point\",\"coordinates\":[5.7352918876162...  \n",
       "2019.0             {\"type\":\"Point\",\"coordinates\":[5.729852719671,...  \n",
       "2019.0             {\"type\":\"Point\",\"coordinates\":[5.7296272854763...  \n",
       "2019.0             {\"type\":\"Point\",\"coordinates\":[5.7183438320247...  \n",
       "\n",
       "[31129 rows x 31 columns]"
      ]
     },
     "execution_count": 240,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_copy.sort_index()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Fichier corrompu"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 255,
   "metadata": {},
   "outputs": [],
   "source": [
    "datafile_corr = datapath / \"ESP_PUBLIC.IDENTITE_ARBRE_CORRPUTED.csv\"\n",
    "df_arbres_corr = pd.read_csv(datafile_corr,dtype=np.dtype(\"O\"))\n",
    "df_arbres_init = pd.read_csv(datafile,dtype=np.dtype(\"O\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([df_arbres_init, df_arbres_corr])\n",
    "df = df.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new = df.drop_duplicates(keep=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ELEM_POINT_ID</th>\n",
       "      <th>CODE</th>\n",
       "      <th>NOM</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>GENRE_DESC</th>\n",
       "      <th>CATEGORIE</th>\n",
       "      <th>CATEGORIE_DESC</th>\n",
       "      <th>SOUS_CATEGORIE</th>\n",
       "      <th>SOUS_CATEGORIE_DESC</th>\n",
       "      <th>CODE_PARENT</th>\n",
       "      <th>...</th>\n",
       "      <th>COURRIER</th>\n",
       "      <th>IDENTIFIANTPLU</th>\n",
       "      <th>TYPEIMPLANTATIONPLU</th>\n",
       "      <th>INTITULEPROTECTIONPLU</th>\n",
       "      <th>ANNEEABATTAGE</th>\n",
       "      <th>ESSOUCHEMENT</th>\n",
       "      <th>DIAMETREARBRE</th>\n",
       "      <th>CAUSEABATTAGE</th>\n",
       "      <th>COLLECTIVITE</th>\n",
       "      <th>GeoJSON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>31975</td>\n",
       "      <td>ESP32701</td>\n",
       "      <td>ESP32701</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7404981502196...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>31913</td>\n",
       "      <td>ESP32639</td>\n",
       "      <td>ESP32639</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7407896214219...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17124</th>\n",
       "      <td>3504</td>\n",
       "      <td>ESP2897</td>\n",
       "      <td>ESP2897</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP470</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grenoble Alpes Métropole</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7255672764694...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24808</th>\n",
       "      <td>510</td>\n",
       "      <td>ESP14156</td>\n",
       "      <td>ESP14156</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP151</td>\n",
       "      <td>Arbre de voirie</td>\n",
       "      <td>ESP346</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7167636965311...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29552</th>\n",
       "      <td>13591</td>\n",
       "      <td>ESP21177</td>\n",
       "      <td>ESP21177</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP887</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7392320939366...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29559</th>\n",
       "      <td>17226</td>\n",
       "      <td>ESP25351</td>\n",
       "      <td>ESP25351</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP151</td>\n",
       "      <td>Arbre de voirie</td>\n",
       "      <td>ESP888</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grenoble Alpes Métropole</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7212258196560...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32050</th>\n",
       "      <td>31975</td>\n",
       "      <td>ESP32701</td>\n",
       "      <td>ESP32701</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7404981502196...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32112</th>\n",
       "      <td>31913</td>\n",
       "      <td>ESP32639</td>\n",
       "      <td>ESP32639</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7407896214219...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49016</th>\n",
       "      <td>3504</td>\n",
       "      <td>ESP2897</td>\n",
       "      <td>ESP2897</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP470</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grenoble Alpes Métropole</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7255672764694...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56700</th>\n",
       "      <td>510</td>\n",
       "      <td>ESP14156</td>\n",
       "      <td>ESP14156</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP151</td>\n",
       "      <td>Arbre de voirie</td>\n",
       "      <td>ESP346</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7167636965311...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61444</th>\n",
       "      <td>13591</td>\n",
       "      <td>ESP21177</td>\n",
       "      <td>ESP21177</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP887</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7392320939366...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61451</th>\n",
       "      <td>17226</td>\n",
       "      <td>ESP25351</td>\n",
       "      <td>ESP25351</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP151</td>\n",
       "      <td>Arbre de voirie</td>\n",
       "      <td>ESP888</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grenoble Alpes Métropole</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7212258196560...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ELEM_POINT_ID      CODE       NOM GENRE  GENRE_DESC CATEGORIE  \\\n",
       "158           31975  ESP32701  ESP32701   VEG  VEGETATION     ESP01   \n",
       "220           31913  ESP32639  ESP32639   VEG  VEGETATION     ESP01   \n",
       "17124          3504   ESP2897   ESP2897   VEG  VEGETATION     ESP01   \n",
       "24808           510  ESP14156  ESP14156   VEG  VEGETATION     ESP01   \n",
       "29552         13591  ESP21177  ESP21177   VEG  VEGETATION     ESP01   \n",
       "29559         17226  ESP25351  ESP25351   VEG  VEGETATION     ESP01   \n",
       "32050         31975  ESP32701  ESP32701   VEG  VEGETATION     ESP01   \n",
       "32112         31913  ESP32639  ESP32639   VEG  VEGETATION     ESP01   \n",
       "49016          3504   ESP2897   ESP2897   VEG  VEGETATION     ESP01   \n",
       "56700           510  ESP14156  ESP14156   VEG  VEGETATION     ESP01   \n",
       "61444         13591  ESP21177  ESP21177   VEG  VEGETATION     ESP01   \n",
       "61451         17226  ESP25351  ESP25351   VEG  VEGETATION     ESP01   \n",
       "\n",
       "      CATEGORIE_DESC SOUS_CATEGORIE      SOUS_CATEGORIE_DESC CODE_PARENT  ...  \\\n",
       "158            Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "220            Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "17124          Arbre         ESP174  Arbre d'espaces ouverts      ESP470  ...   \n",
       "24808          Arbre         ESP151          Arbre de voirie      ESP346  ...   \n",
       "29552          Arbre         ESP174  Arbre d'espaces ouverts      ESP887  ...   \n",
       "29559          Arbre         ESP151          Arbre de voirie      ESP888  ...   \n",
       "32050          Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "32112          Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "49016          Arbre         ESP174  Arbre d'espaces ouverts      ESP470  ...   \n",
       "56700          Arbre         ESP151          Arbre de voirie      ESP346  ...   \n",
       "61444          Arbre         ESP174  Arbre d'espaces ouverts      ESP887  ...   \n",
       "61451          Arbre         ESP151          Arbre de voirie      ESP888  ...   \n",
       "\n",
       "      COURRIER IDENTIFIANTPLU TYPEIMPLANTATIONPLU INTITULEPROTECTIONPLU  \\\n",
       "158        NaN            NaN                 NaN                   NaN   \n",
       "220        NaN            NaN                 NaN                   NaN   \n",
       "17124      NaN            NaN                 NaN                   NaN   \n",
       "24808      NaN            NaN                 NaN                   NaN   \n",
       "29552      NaN            NaN                 NaN                   NaN   \n",
       "29559      NaN            NaN                 NaN                   NaN   \n",
       "32050      NaN            NaN                 NaN                   NaN   \n",
       "32112      NaN            NaN                 NaN                   NaN   \n",
       "49016      NaN            NaN                 NaN                   NaN   \n",
       "56700      NaN            NaN                 NaN                   NaN   \n",
       "61444      NaN            NaN                 NaN                   NaN   \n",
       "61451      NaN            NaN                 NaN                   NaN   \n",
       "\n",
       "      ANNEEABATTAGE ESSOUCHEMENT DIAMETREARBRE CAUSEABATTAGE  \\\n",
       "158             NaN          NaN           NaN           NaN   \n",
       "220             NaN          NaN           NaN           NaN   \n",
       "17124           NaN          NaN           NaN           NaN   \n",
       "24808           NaN          NaN           NaN           NaN   \n",
       "29552           NaN          NaN           NaN           NaN   \n",
       "29559           NaN          NaN           NaN           NaN   \n",
       "32050           NaN          NaN           NaN           NaN   \n",
       "32112           NaN          NaN           NaN           NaN   \n",
       "49016           NaN          NaN           NaN           NaN   \n",
       "56700           NaN          NaN           NaN           NaN   \n",
       "61444           NaN          NaN           NaN           NaN   \n",
       "61451           NaN          NaN           NaN           NaN   \n",
       "\n",
       "                   COLLECTIVITE  \\\n",
       "158           Ville de Grenoble   \n",
       "220           Ville de Grenoble   \n",
       "17124  Grenoble Alpes Métropole   \n",
       "24808         Ville de Grenoble   \n",
       "29552         Ville de Grenoble   \n",
       "29559  Grenoble Alpes Métropole   \n",
       "32050         Ville de Grenoble   \n",
       "32112         Ville de Grenoble   \n",
       "49016  Grenoble Alpes Métropole   \n",
       "56700         Ville de Grenoble   \n",
       "61444         Ville de Grenoble   \n",
       "61451  Grenoble Alpes Métropole   \n",
       "\n",
       "                                                 GeoJSON  \n",
       "158    {\"type\":\"Point\",\"coordinates\":[5.7404981502196...  \n",
       "220    {\"type\":\"Point\",\"coordinates\":[5.7407896214219...  \n",
       "17124  {\"type\":\"Point\",\"coordinates\":[5.7255672764694...  \n",
       "24808  {\"type\":\"Point\",\"coordinates\":[5.7167636965311...  \n",
       "29552  {\"type\":\"Point\",\"coordinates\":[5.7392320939366...  \n",
       "29559  {\"type\":\"Point\",\"coordinates\":[5.7212258196560...  \n",
       "32050  {\"type\":\"Point\",\"coordinates\":[5.7404981502196...  \n",
       "32112  {\"type\":\"Point\",\"coordinates\":[5.7407896214219...  \n",
       "49016  {\"type\":\"Point\",\"coordinates\":[5.7255672764694...  \n",
       "56700  {\"type\":\"Point\",\"coordinates\":[5.7167636965311...  \n",
       "61444  {\"type\":\"Point\",\"coordinates\":[5.7392320939366...  \n",
       "61451  {\"type\":\"Point\",\"coordinates\":[5.7212258196560...  \n",
       "\n",
       "[12 rows x 32 columns]"
      ]
     },
     "execution_count": 174,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ELEM_POINT_ID', 'CODE', 'NOM', 'GENRE', 'GENRE_DESC', 'CATEGORIE',\n",
       "       'CATEGORIE_DESC', 'SOUS_CATEGORIE', 'SOUS_CATEGORIE_DESC',\n",
       "       'CODE_PARENT', 'CODE_PARENT_DESC', 'ADR_SECTEUR', 'BIEN_REFERENCE',\n",
       "       'GENRE_BOTA', 'ESPECE', 'VARIETE', 'STADEDEDEVELOPPEMENT', 'EQUIPE',\n",
       "       'REMARQUES', 'ANNEEDEPLANTATION', 'RAISONDEPLANTATION',\n",
       "       'TRAITEMENTCHENILLES', 'COURRIER', 'IDENTIFIANTPLU',\n",
       "       'TYPEIMPLANTATIONPLU', 'INTITULEPROTECTIONPLU', 'ANNEEABATTAGE',\n",
       "       'ESSOUCHEMENT', 'DIAMETREARBRE', 'CAUSEABATTAGE', 'COLLECTIVITE',\n",
       "       'GeoJSON'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 164,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres.columns.intersection(df_arbres_corr.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([], dtype='object')"
      ]
     },
     "execution_count": 165,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres.columns.difference(df_arbres_corr.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ELEM_POINT_ID</th>\n",
       "      <th>CODE</th>\n",
       "      <th>NOM</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>GENRE_DESC</th>\n",
       "      <th>CATEGORIE</th>\n",
       "      <th>CATEGORIE_DESC</th>\n",
       "      <th>SOUS_CATEGORIE</th>\n",
       "      <th>SOUS_CATEGORIE_DESC</th>\n",
       "      <th>CODE_PARENT</th>\n",
       "      <th>...</th>\n",
       "      <th>COURRIER</th>\n",
       "      <th>IDENTIFIANTPLU</th>\n",
       "      <th>TYPEIMPLANTATIONPLU</th>\n",
       "      <th>INTITULEPROTECTIONPLU</th>\n",
       "      <th>ANNEEABATTAGE</th>\n",
       "      <th>ESSOUCHEMENT</th>\n",
       "      <th>DIAMETREARBRE</th>\n",
       "      <th>CAUSEABATTAGE</th>\n",
       "      <th>COLLECTIVITE</th>\n",
       "      <th>GeoJSON</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16750</td>\n",
       "      <td>ESP19318</td>\n",
       "      <td>ESP19318</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7394161255246...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20142</td>\n",
       "      <td>ESP18095</td>\n",
       "      <td>ESP18095</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7397428849165...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>23843</td>\n",
       "      <td>ESP17861</td>\n",
       "      <td>ESP17861</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7393229609447...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>23841</td>\n",
       "      <td>ESP17860</td>\n",
       "      <td>ESP17860</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7410808202830...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1778</td>\n",
       "      <td>ESP16403</td>\n",
       "      <td>ESP16403</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7408124079286...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31893</th>\n",
       "      <td>31913</td>\n",
       "      <td>ESP32639</td>\n",
       "      <td>ESP32639</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP995</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7407896214219...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31894</th>\n",
       "      <td>3504</td>\n",
       "      <td>ESP2897</td>\n",
       "      <td>ESP2897</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP470</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grenoble Alpes Métropole</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7255672764694...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31895</th>\n",
       "      <td>510</td>\n",
       "      <td>ESP14156</td>\n",
       "      <td>ESP14156</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP151</td>\n",
       "      <td>Arbre de voirie</td>\n",
       "      <td>ESP346</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7167636965311...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31896</th>\n",
       "      <td>13591</td>\n",
       "      <td>ESP21177</td>\n",
       "      <td>ESP21177</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP174</td>\n",
       "      <td>Arbre d'espaces ouverts</td>\n",
       "      <td>ESP887</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ville de Grenoble</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7392320939366...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31897</th>\n",
       "      <td>17226</td>\n",
       "      <td>ESP25351</td>\n",
       "      <td>ESP25351</td>\n",
       "      <td>VEG</td>\n",
       "      <td>VEGETATION</td>\n",
       "      <td>ESP01</td>\n",
       "      <td>Arbre</td>\n",
       "      <td>ESP151</td>\n",
       "      <td>Arbre de voirie</td>\n",
       "      <td>ESP888</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Grenoble Alpes Métropole</td>\n",
       "      <td>{\"type\":\"Point\",\"coordinates\":[5.7212258196560...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>31898 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ELEM_POINT_ID      CODE       NOM GENRE  GENRE_DESC CATEGORIE  \\\n",
       "0             16750  ESP19318  ESP19318   VEG  VEGETATION     ESP01   \n",
       "1             20142  ESP18095  ESP18095   VEG  VEGETATION     ESP01   \n",
       "2             23843  ESP17861  ESP17861   VEG  VEGETATION     ESP01   \n",
       "3             23841  ESP17860  ESP17860   VEG  VEGETATION     ESP01   \n",
       "4              1778  ESP16403  ESP16403   VEG  VEGETATION     ESP01   \n",
       "...             ...       ...       ...   ...         ...       ...   \n",
       "31893         31913  ESP32639  ESP32639   VEG  VEGETATION     ESP01   \n",
       "31894          3504   ESP2897   ESP2897   VEG  VEGETATION     ESP01   \n",
       "31895           510  ESP14156  ESP14156   VEG  VEGETATION     ESP01   \n",
       "31896         13591  ESP21177  ESP21177   VEG  VEGETATION     ESP01   \n",
       "31897         17226  ESP25351  ESP25351   VEG  VEGETATION     ESP01   \n",
       "\n",
       "      CATEGORIE_DESC SOUS_CATEGORIE      SOUS_CATEGORIE_DESC CODE_PARENT  ...  \\\n",
       "0              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "1              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "2              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "3              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "4              Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "...              ...            ...                      ...         ...  ...   \n",
       "31893          Arbre         ESP174  Arbre d'espaces ouverts      ESP995  ...   \n",
       "31894          Arbre         ESP174  Arbre d'espaces ouverts      ESP470  ...   \n",
       "31895          Arbre         ESP151          Arbre de voirie      ESP346  ...   \n",
       "31896          Arbre         ESP174  Arbre d'espaces ouverts      ESP887  ...   \n",
       "31897          Arbre         ESP151          Arbre de voirie      ESP888  ...   \n",
       "\n",
       "      COURRIER IDENTIFIANTPLU TYPEIMPLANTATIONPLU INTITULEPROTECTIONPLU  \\\n",
       "0          NaN            NaN                 NaN                   NaN   \n",
       "1          NaN            NaN                 NaN                   NaN   \n",
       "2          NaN            NaN                 NaN                   NaN   \n",
       "3          NaN            NaN                 NaN                   NaN   \n",
       "4          NaN            NaN                 NaN                   NaN   \n",
       "...        ...            ...                 ...                   ...   \n",
       "31893      NaN            NaN                 NaN                   NaN   \n",
       "31894      NaN            NaN                 NaN                   NaN   \n",
       "31895      NaN            NaN                 NaN                   NaN   \n",
       "31896      NaN            NaN                 NaN                   NaN   \n",
       "31897      NaN            NaN                 NaN                   NaN   \n",
       "\n",
       "      ANNEEABATTAGE ESSOUCHEMENT DIAMETREARBRE  CAUSEABATTAGE  \\\n",
       "0               NaN          NaN           NaN            NaN   \n",
       "1               NaN          NaN           NaN            NaN   \n",
       "2               NaN          NaN           NaN            NaN   \n",
       "3               NaN          NaN           NaN            NaN   \n",
       "4               NaN          NaN           NaN            NaN   \n",
       "...             ...          ...           ...            ...   \n",
       "31893           NaN          NaN           NaN            NaN   \n",
       "31894           NaN          NaN           NaN            NaN   \n",
       "31895           NaN          NaN           NaN            NaN   \n",
       "31896           NaN          NaN           NaN            NaN   \n",
       "31897           NaN          NaN           NaN            NaN   \n",
       "\n",
       "                   COLLECTIVITE  \\\n",
       "0             Ville de Grenoble   \n",
       "1             Ville de Grenoble   \n",
       "2             Ville de Grenoble   \n",
       "3             Ville de Grenoble   \n",
       "4             Ville de Grenoble   \n",
       "...                         ...   \n",
       "31893         Ville de Grenoble   \n",
       "31894  Grenoble Alpes Métropole   \n",
       "31895         Ville de Grenoble   \n",
       "31896         Ville de Grenoble   \n",
       "31897  Grenoble Alpes Métropole   \n",
       "\n",
       "                                                 GeoJSON  \n",
       "0      {\"type\":\"Point\",\"coordinates\":[5.7394161255246...  \n",
       "1      {\"type\":\"Point\",\"coordinates\":[5.7397428849165...  \n",
       "2      {\"type\":\"Point\",\"coordinates\":[5.7393229609447...  \n",
       "3      {\"type\":\"Point\",\"coordinates\":[5.7410808202830...  \n",
       "4      {\"type\":\"Point\",\"coordinates\":[5.7408124079286...  \n",
       "...                                                  ...  \n",
       "31893  {\"type\":\"Point\",\"coordinates\":[5.7407896214219...  \n",
       "31894  {\"type\":\"Point\",\"coordinates\":[5.7255672764694...  \n",
       "31895  {\"type\":\"Point\",\"coordinates\":[5.7167636965311...  \n",
       "31896  {\"type\":\"Point\",\"coordinates\":[5.7392320939366...  \n",
       "31897  {\"type\":\"Point\",\"coordinates\":[5.7212258196560...  \n",
       "\n",
       "[31898 rows x 32 columns]"
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comparison_df = pd.merge(df_arbres_init, df_arbres_corr, how='inner', on=list(df_arbres_corr.columns))\n",
    "comparison_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_arbres_corr[df_arbres_init!=df_arbres_corr] = df_arbres_init[df_arbres_init!=df_arbres_corr]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 257,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "500    2001\n",
       "501    2001\n",
       "502    2001\n",
       "503    2001\n",
       "504    2001\n",
       "505    2001\n",
       "506    1984\n",
       "507    1984\n",
       "508    1984\n",
       "509    1984\n",
       "510    1984\n",
       "511    1984\n",
       "512    1984\n",
       "513    1984\n",
       "514    1984\n",
       "515    1984\n",
       "Name: ANNEEDEPLANTATION, dtype: object"
      ]
     },
     "execution_count": 257,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres_init.loc[500:515,'ANNEEDEPLANTATION']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Iteration 2: Questions"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Pour commencer identifiez tous les genres botaniques représentés à Grenoble.\n",
    "Combien y en a-t-il ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ELEM_POINT_ID            31892\n",
       "CODE                     31892\n",
       "NOM                      31892\n",
       "GENRE                        1\n",
       "GENRE_DESC                   1\n",
       "CATEGORIE                    1\n",
       "CATEGORIE_DESC               1\n",
       "SOUS_CATEGORIE               4\n",
       "SOUS_CATEGORIE_DESC          4\n",
       "CODE_PARENT               1462\n",
       "CODE_PARENT_DESC          1462\n",
       "ADR_SECTEUR                  6\n",
       "BIEN_REFERENCE           31892\n",
       "GENRE_BOTA                 119\n",
       "ESPECE                     274\n",
       "VARIETE                    182\n",
       "STADEDEDEVELOPPEMENT         3\n",
       "EQUIPE                       0\n",
       "REMARQUES                   10\n",
       "ANNEEDEPLANTATION           62\n",
       "RAISONDEPLANTATION           3\n",
       "TRAITEMENTCHENILLES          3\n",
       "COURRIER                     0\n",
       "IDENTIFIANTPLU              46\n",
       "TYPEIMPLANTATIONPLU          4\n",
       "INTITULEPROTECTIONPLU        3\n",
       "ANNEEABATTAGE                0\n",
       "ESSOUCHEMENT                 0\n",
       "DIAMETREARBRE                0\n",
       "CAUSEABATTAGE                0\n",
       "COLLECTIVITE                 2\n",
       "GeoJSON                  31891\n",
       "dtype: int64"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Nombre de valeurs différentes dans mon dataframe (par colonne)\n",
    "df_arbres.nunique(axis='rows', dropna=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Identifiez maintenant toutes les espèces différentes présentes à Grenoble"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GENRE_BOTA  ESPECE      \n",
       "Abies       concolor          5\n",
       "            koreana           1\n",
       "            nordmaniana      20\n",
       "            pinsapo           2\n",
       "Acer        buergerianum     20\n",
       "                           ... \n",
       "Ulmus       parvifolia        1\n",
       "            pumila            1\n",
       "            resista          24\n",
       "Zelkova     crenata           2\n",
       "            serrata         231\n",
       "Length: 312, dtype: int64"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_arbres.groupby([ 'GENRE_BOTA', 'ESPECE']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_genre = df_arbres.groupby([ 'GENRE_BOTA']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GENRE_BOTA\n",
       "Abies            0.082660\n",
       "Acacia           0.003179\n",
       "Acer            16.722833\n",
       "Aesculus         1.468812\n",
       "Ailanthus        0.251160\n",
       "                  ...    \n",
       "Thuja            0.149425\n",
       "Tilia            5.646341\n",
       "Trachycarpus     0.073123\n",
       "Ulmus            0.686717\n",
       "Zelkova          0.887010\n",
       "Length: 119, dtype: float64"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(df_genre*100)/df_genre.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_esp = df_arbres.groupby([ 'GENRE_BOTA', 'ESPECE']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "GENRE_BOTA  ESPECE      \n",
       "Abies       alba            0.003366\n",
       "            concolor        0.016829\n",
       "            koreana         0.003366\n",
       "            nordmanniana    0.057220\n",
       "            pinsapo         0.006732\n",
       "                              ...   \n",
       "Ulmus       minor           0.457758\n",
       "            parvifolia      0.016829\n",
       "            resista         0.080781\n",
       "Zelkova     crenata         0.006732\n",
       "            serrata         0.932346\n",
       "Length: 339, dtype: float64"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(df_esp*100)/df_esp.sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Iteration 3: Questions"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Plusieurs sources évoquent une espérance de vie moyenne des arbres en ville de 30 à 80 ans. Les données de terrain disponibles pour Grenoble corroborent-elles ces sources ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_simple = df_arbres.loc[:, ['ANNEEDEPLANTATION','ANNEEABATTAGE']].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Création d'une nouvelle colonne\n",
    "df_simple['DUREEVIE'] =  df_simple.ANNEEABATTAGE - df_simple.ANNEEDEPLANTATION"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ANNEEDEPLANTATION</th>\n",
       "      <th>ANNEEABATTAGE</th>\n",
       "      <th>DUREEVIE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31238</th>\n",
       "      <td>2001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31239</th>\n",
       "      <td>2001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31240</th>\n",
       "      <td>2001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31241</th>\n",
       "      <td>2001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31242</th>\n",
       "      <td>2001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>31243 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ANNEEDEPLANTATION  ANNEEABATTAGE  DUREEVIE\n",
       "0                    NaN            NaN       NaN\n",
       "1                    NaN            NaN       NaN\n",
       "2                    NaN            NaN       NaN\n",
       "3                    NaN            NaN       NaN\n",
       "4                    NaN            NaN       NaN\n",
       "...                  ...            ...       ...\n",
       "31238             2001.0            NaN       NaN\n",
       "31239             2001.0            NaN       NaN\n",
       "31240             2001.0            NaN       NaN\n",
       "31241             2001.0            NaN       NaN\n",
       "31242             2001.0            NaN       NaN\n",
       "\n",
       "[31243 rows x 3 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_simple"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.8.5"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {
    "height": "calc(100% - 180px)",
    "left": "10px",
    "top": "150px",
    "width": "307.2px"
   },
   "toc_section_display": true,
   "toc_window_display": true
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "position": {
    "height": "393.4px",
    "left": "488px",
    "right": "20px",
    "top": "110px",
    "width": "798.4px"
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}