Skip to content
Snippets Groups Projects
3_nettoyage_1.ipynb 97.8 KiB
Newer Older
  • Learn to ignore specific revisions
  • Alessandro Cerioni's avatar
    Alessandro Cerioni committed
    {
     "cells": [
      {
       "cell_type": "markdown",
       "metadata": {},
       "source": [
        "# 3 - Nettoyage des données - 1ère partie"
       ]
      },
      {
       "cell_type": "code",
    
       "execution_count": 1,
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "metadata": {},
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "outputs": [],
       "source": [
        "import pandas as pd\n",
        "pd.set_option('display.max_columns', None) # <- cela permet d'afficher toutes les colonnes d'un DataFrame"
       ]
      },
      {
       "cell_type": "markdown",
       "metadata": {},
       "source": [
        "La commande suivante nous permet de reprendre le travail qu'on a fait dans le cahier précedent :"
       ]
      },
      {
       "cell_type": "code",
    
       "execution_count": 2,
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "metadata": {},
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "outputs": [],
       "source": [
        "filename = 'data/df1.pkl'\n",
        "df1 = pd.read_pickle(filename)"
       ]
      },
      {
       "cell_type": "code",
    
       "execution_count": 3,
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "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",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>essencefrancais</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>circonference_cm</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>hauteurtotale_m</th>\n",
           "      <th>hauteurfut_m</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>diametrecouronne_m</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>rayoncouronne_m</th>\n",
           "      <th>dateplantation</th>\n",
           "      <th>genre</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>espece</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>variete</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>essence</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>architecture</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>localisation</th>\n",
           "      <th>naturerevetement</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>mobilierurbain</th>\n",
           "      <th>anneeplantation</th>\n",
           "      <th>commune</th>\n",
           "      <th>codeinsee</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>nomvoie</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>codefuv</th>\n",
           "      <th>identifiant</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>numero</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>codegenre</th>\n",
           "      <th>gid</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>surfacecadre_m2</th>\n",
           "      <th>lat</th>\n",
           "      <th>lon</th>\n",
           "    </tr>\n",
           "  </thead>\n",
           "  <tbody>\n",
           "    <tr>\n",
           "      <th>0</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Erable champêtre 'Elsrijk'</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>30.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>7</td>\n",
           "      <td>2.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>5</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2.5</td>\n",
           "      <td>2005-03-15T00:00:00Z</td>\n",
           "      <td>Acer</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>campestre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Acer campestre Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Terre plein latéral</td>\n",
           "      <td>Terre végétale + végétation</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2005.0</td>\n",
           "      <td>LIMONEST</td>\n",
           "      <td>69116</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>CHEMIN DE PAISY</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>9560.0</td>\n",
           "      <td>116912</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>15</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
           "      <td>1</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.804503</td>\n",
           "      <td>4.772993</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>1</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Erable champêtre 'Elsrijk'</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>45.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>6</td>\n",
           "      <td>2.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>4</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2.0</td>\n",
           "      <td>2005-03-15T00:00:00Z</td>\n",
           "      <td>Acer</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>campestre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Acer campestre Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Trottoir ou domaine piétonnier</td>\n",
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2005.0</td>\n",
           "      <td>LIMONEST</td>\n",
           "      <td>69116</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>CHEMIN DE PAISY</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>9560.0</td>\n",
           "      <td>118231</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>3</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
           "      <td>2</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.803322</td>\n",
           "      <td>4.775080</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>2</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Erable champêtre 'Elsrijk'</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>50.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>7</td>\n",
           "      <td>2.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>5</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2.5</td>\n",
           "      <td>2005-03-15T00:00:00Z</td>\n",
           "      <td>Acer</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>campestre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Acer campestre Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Trottoir ou domaine piétonnier</td>\n",
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2005.0</td>\n",
           "      <td>LIMONEST</td>\n",
           "      <td>69116</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>CHEMIN DE PAISY</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>9560.0</td>\n",
           "      <td>117966</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
           "      <td>3</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.803241</td>\n",
           "      <td>4.775227</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>3</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Erable champêtre 'Elsrijk'</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>40.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>7</td>\n",
           "      <td>2.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>5</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2.5</td>\n",
           "      <td>2005-03-15T00:00:00Z</td>\n",
           "      <td>Acer</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>campestre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Acer campestre Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Terre plein latéral</td>\n",
           "      <td>Terre végétale + végétation</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2005.0</td>\n",
           "      <td>LIMONEST</td>\n",
           "      <td>69116</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>CHEMIN DE PAISY</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>9560.0</td>\n",
           "      <td>118204</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>16</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
           "      <td>4</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.804540</td>\n",
           "      <td>4.772921</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>4</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Erable champêtre 'Elsrijk'</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>30.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>7</td>\n",
           "      <td>2.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>5</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2.5</td>\n",
           "      <td>2005-03-15T00:00:00Z</td>\n",
           "      <td>Acer</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>campestre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Acer campestre Elsrijk</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Terre plein latéral</td>\n",
           "      <td>Terre végétale + végétation</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2005.0</td>\n",
           "      <td>LIMONEST</td>\n",
           "      <td>69116</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>CHEMIN DE PAISY</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>9560.0</td>\n",
           "      <td>117938</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>14</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
           "      <td>5</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.804468</td>\n",
           "      <td>4.773058</td>\n",
           "    </tr>\n",
           "  </tbody>\n",
           "</table>\n",
           "</div>"
          ],
          "text/plain": [
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "              essencefrancais  circonference_cm  hauteurtotale_m  \\\n",
           "0  Erable champêtre 'Elsrijk'              30.0                7   \n",
           "1  Erable champêtre 'Elsrijk'              45.0                6   \n",
           "2  Erable champêtre 'Elsrijk'              50.0                7   \n",
           "3  Erable champêtre 'Elsrijk'              40.0                7   \n",
           "4  Erable champêtre 'Elsrijk'              30.0                7   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "   hauteurfut_m  diametrecouronne_m  rayoncouronne_m        dateplantation  \\\n",
           "0           2.0                   5              2.5  2005-03-15T00:00:00Z   \n",
           "1           2.0                   4              2.0  2005-03-15T00:00:00Z   \n",
           "2           2.0                   5              2.5  2005-03-15T00:00:00Z   \n",
           "3           2.0                   5              2.5  2005-03-15T00:00:00Z   \n",
           "4           2.0                   5              2.5  2005-03-15T00:00:00Z   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "  genre     espece  variete                 essence architecture  \\\n",
           "0  Acer  campestre  Elsrijk  Acer campestre Elsrijk        Libre   \n",
           "1  Acer  campestre  Elsrijk  Acer campestre Elsrijk        Libre   \n",
           "2  Acer  campestre  Elsrijk  Acer campestre Elsrijk        Libre   \n",
           "3  Acer  campestre  Elsrijk  Acer campestre Elsrijk        Libre   \n",
           "4  Acer  campestre  Elsrijk  Acer campestre Elsrijk        Libre   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "                     localisation             naturerevetement mobilierurbain  \\\n",
           "0             Terre plein latéral  Terre végétale + végétation           Rien   \n",
           "1  Trottoir ou domaine piétonnier           Autres revêtements           Rien   \n",
           "2  Trottoir ou domaine piétonnier           Autres revêtements           Rien   \n",
           "3             Terre plein latéral  Terre végétale + végétation           Rien   \n",
           "4             Terre plein latéral  Terre végétale + végétation           Rien   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "   anneeplantation   commune  codeinsee          nomvoie  codefuv  \\\n",
           "0           2005.0  LIMONEST      69116  CHEMIN DE PAISY   9560.0   \n",
           "1           2005.0  LIMONEST      69116  CHEMIN DE PAISY   9560.0   \n",
           "2           2005.0  LIMONEST      69116  CHEMIN DE PAISY   9560.0   \n",
           "3           2005.0  LIMONEST      69116  CHEMIN DE PAISY   9560.0   \n",
           "4           2005.0  LIMONEST      69116  CHEMIN DE PAISY   9560.0   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "   identifiant  numero  codegenre  gid  surfacecadre_m2        lat       lon  \n",
           "0       116912      15          2    1              NaN  45.804503  4.772993  \n",
           "1       118231       3          2    2              NaN  45.803322  4.775080  \n",
           "2       117966       2          2    3              NaN  45.803241  4.775227  \n",
           "3       118204      16          2    4              NaN  45.804540  4.772921  \n",
           "4       117938      14          2    5              NaN  45.804468  4.773058  "
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
          ]
         },
    
         "execution_count": 3,
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
        "df1.head()"
       ]
      },
      {
       "cell_type": "markdown",
       "metadata": {},
       "source": [
    
        "## Suppression des lignes ayant genre = \"Emplacement libre\" / \"Non défini\" / \"Souche\""
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       ]
      },
      {
       "cell_type": "markdown",
       "metadata": {},
       "source": [
        "On s'est déjà aperçu que certaines lignes ont genre = \"Emplacement libre\" ou bien \"Non défini\". Les commandes suivantes permettent de le confirmer :"
       ]
      },
      {
       "cell_type": "code",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "execution_count": 4,
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "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",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>essencefrancais</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>circonference_cm</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>hauteurtotale_m</th>\n",
           "      <th>hauteurfut_m</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>diametrecouronne_m</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>rayoncouronne_m</th>\n",
           "      <th>dateplantation</th>\n",
           "      <th>genre</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>espece</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>variete</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>essence</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>architecture</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>localisation</th>\n",
           "      <th>naturerevetement</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>mobilierurbain</th>\n",
           "      <th>anneeplantation</th>\n",
           "      <th>commune</th>\n",
           "      <th>codeinsee</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>nomvoie</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>codefuv</th>\n",
           "      <th>identifiant</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>numero</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>codegenre</th>\n",
           "      <th>gid</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>surfacecadre_m2</th>\n",
           "      <th>lat</th>\n",
           "      <th>lon</th>\n",
           "    </tr>\n",
           "  </thead>\n",
           "  <tbody>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>79</th>\n",
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>NaN</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Sans arbre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Lieu de stationnement</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>NaN</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>VENISSIEUX</td>\n",
           "      <td>69259</td>\n",
           "      <td>BOULEVARD DU DOCTEUR COBLOD</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>20248.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>112929</td>\n",
           "      <td>169</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>79</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>45.696758</td>\n",
           "      <td>4.896404</td>\n",
           "    </tr>\n",
           "    <tr>\n",
           "      <th>94</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Emplacement libre</td>\n",
           "      <td>0.0</td>\n",
           "      <td>0</td>\n",
           "      <td>0.0</td>\n",
           "      <td>0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Sans arbre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Trottoir ou domaine piétonnier</td>\n",
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>NaN</td>\n",
           "      <td>LYON 7EME</td>\n",
           "      <td>69387</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>PLACE JEAN JAURES</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>28529.0</td>\n",
           "      <td>70080</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>58</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0</td>\n",
           "      <td>93</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>45.739567</td>\n",
           "      <td>4.839188</td>\n",
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>107</th>\n",
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>NaN</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Sans arbre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Trottoir ou domaine piétonnier</td>\n",
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>NaN</td>\n",
           "      <td>LYON 6EME</td>\n",
           "      <td>69386</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>QUAI GENERAL SARRAIL</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>28400.0</td>\n",
           "      <td>107924</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>26</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0</td>\n",
           "      <td>106</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.766555</td>\n",
           "      <td>4.841278</td>\n",
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>115</th>\n",
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>NaN</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Emplacement libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Sans arbre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Terre plein latéral</td>\n",
           "      <td>Terre végétale + végétation</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>NaN</td>\n",
           "      <td>LYON 7EME</td>\n",
           "      <td>69387</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>AVENUE TONY GARNIER</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>28489.0</td>\n",
           "      <td>98846</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>302</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0</td>\n",
           "      <td>113</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.729193</td>\n",
           "      <td>4.824097</td>\n",
           "    </tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    <tr>\n",
           "      <th>116</th>\n",
           "      <td>Emplacement libre</td>\n",
           "      <td>0.0</td>\n",
           "      <td>0</td>\n",
           "      <td>0.0</td>\n",
           "      <td>0</td>\n",
           "      <td>0.0</td>\n",
           "      <td>NaN</td>\n",
           "      <td>Emplacement libre</td>\n",
           "      <td></td>\n",
           "      <td></td>\n",
           "      <td>Emplacement libre</td>\n",
           "      <td>Sans arbre</td>\n",
           "      <td>Lieu de stationnement</td>\n",
           "      <td>Terre végétale + végétation</td>\n",
           "      <td>Rien</td>\n",
           "      <td>NaN</td>\n",
           "      <td>LYON 7EME</td>\n",
           "      <td>69387</td>\n",
           "      <td>COURS GAMBETTA</td>\n",
           "      <td>28498.0</td>\n",
           "      <td>109152</td>\n",
           "      <td>80</td>\n",
           "      <td>0</td>\n",
           "      <td>114</td>\n",
           "      <td>3.0</td>\n",
           "      <td>45.750534</td>\n",
           "      <td>4.856545</td>\n",
           "    </tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "  </tbody>\n",
           "</table>\n",
           "</div>"
          ],
          "text/plain": [
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "       essencefrancais  circonference_cm  hauteurtotale_m  hauteurfut_m  \\\n",
           "79   Emplacement libre               0.0                0           0.0   \n",
           "94   Emplacement libre               0.0                0           0.0   \n",
           "107  Emplacement libre               0.0                0           0.0   \n",
           "115  Emplacement libre               0.0                0           0.0   \n",
           "116  Emplacement libre               0.0                0           0.0   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "     diametrecouronne_m  rayoncouronne_m dateplantation              genre  \\\n",
           "79                    0              0.0            NaN  Emplacement libre   \n",
           "94                    0              0.0            NaN  Emplacement libre   \n",
           "107                   0              0.0            NaN  Emplacement libre   \n",
           "115                   0              0.0            NaN  Emplacement libre   \n",
           "116                   0              0.0            NaN  Emplacement libre   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    espece variete            essence architecture  \\\n",
           "79                  Emplacement libre   Sans arbre   \n",
           "94                  Emplacement libre   Sans arbre   \n",
           "107                 Emplacement libre   Sans arbre   \n",
           "115                 Emplacement libre   Sans arbre   \n",
           "116                 Emplacement libre   Sans arbre   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "                       localisation             naturerevetement  \\\n",
           "79            Lieu de stationnement           Autres revêtements   \n",
           "94   Trottoir ou domaine piétonnier           Autres revêtements   \n",
           "107  Trottoir ou domaine piétonnier           Autres revêtements   \n",
           "115             Terre plein latéral  Terre végétale + végétation   \n",
           "116           Lieu de stationnement  Terre végétale + végétation   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    mobilierurbain  anneeplantation     commune  codeinsee  \\\n",
           "79            Rien              NaN  VENISSIEUX      69259   \n",
           "94            Rien              NaN   LYON 7EME      69387   \n",
           "107           Rien              NaN   LYON 6EME      69386   \n",
           "115           Rien              NaN   LYON 7EME      69387   \n",
           "116           Rien              NaN   LYON 7EME      69387   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "                         nomvoie  codefuv  identifiant  numero  codegenre  \\\n",
           "79   BOULEVARD DU DOCTEUR COBLOD  20248.0       112929     169          0   \n",
           "94             PLACE JEAN JAURES  28529.0        70080      58          0   \n",
           "107         QUAI GENERAL SARRAIL  28400.0       107924      26          0   \n",
           "115          AVENUE TONY GARNIER  28489.0        98846     302          0   \n",
           "116               COURS GAMBETTA  28498.0       109152      80          0   \n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "     gid  surfacecadre_m2        lat       lon  \n",
           "79    79              NaN  45.696758  4.896404  \n",
           "94    93              0.0  45.739567  4.839188  \n",
           "107  106              NaN  45.766555  4.841278  \n",
           "115  113              NaN  45.729193  4.824097  \n",
           "116  114              3.0  45.750534  4.856545  "
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
          ]
         },
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
         "execution_count": 4,
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
        "df1[ df1.genre == 'Emplacement libre' ].head()"
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       ]
      },
      {
       "cell_type": "code",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "execution_count": 5,
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "metadata": {},
       "outputs": [
        {
         "data": {
          "text/plain": [
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "3273"
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
          ]
         },
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
         "execution_count": 5,
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
         "metadata": {},
         "output_type": "execute_result"
        }
       ],
       "source": [
        "len(df1[ (df1.genre == 'Emplacement libre') ])"
       ]
      },
      {
       "cell_type": "code",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "execution_count": 6,
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
       "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",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>essencefrancais</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>circonference_cm</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>hauteurtotale_m</th>\n",
           "      <th>hauteurfut_m</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>diametrecouronne_m</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>rayoncouronne_m</th>\n",
           "      <th>dateplantation</th>\n",
           "      <th>genre</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>espece</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>variete</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>essence</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>architecture</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>localisation</th>\n",
           "      <th>naturerevetement</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>mobilierurbain</th>\n",
           "      <th>anneeplantation</th>\n",
           "      <th>commune</th>\n",
           "      <th>codeinsee</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>nomvoie</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>codefuv</th>\n",
           "      <th>identifiant</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>numero</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>codegenre</th>\n",
           "      <th>gid</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>surfacecadre_m2</th>\n",
           "      <th>lat</th>\n",
           "      <th>lon</th>\n",
           "    </tr>\n",
           "  </thead>\n",
           "  <tbody>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>14739</th>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>52.0</td>\n",
           "      <td>5</td>\n",
           "      <td>2.0</td>\n",
           "      <td>5</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2.5</td>\n",
           "      <td>2004-06-01T00:00:00Z</td>\n",
           "      <td>Non défini</td>\n",
           "      <td></td>\n",
           "      <td></td>\n",
           "      <td>Non défini</td>\n",
           "      <td>Pseudo-libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Trottoir ou domaine piétonnier</td>\n",
           "      <td>Terre végétale nue</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2004.0</td>\n",
           "      <td>LYON 2EME</td>\n",
           "      <td>69382</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>QUAI TILSITT</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>27541.0</td>\n",
           "      <td>72701</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>38</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
           "      <td>14722</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.756531</td>\n",
           "      <td>4.826460</td>\n",
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>18222</th>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>52.0</td>\n",
           "      <td>5</td>\n",
           "      <td>2.0</td>\n",
           "      <td>5</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2.5</td>\n",
           "      <td>2004-06-01T00:00:00Z</td>\n",
           "      <td>Non défini</td>\n",
           "      <td></td>\n",
           "      <td></td>\n",
           "      <td>Non défini</td>\n",
           "      <td>Pseudo-libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Trottoir ou domaine piétonnier</td>\n",
           "      <td>Terre végétale nue</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2004.0</td>\n",
           "      <td>LYON 2EME</td>\n",
           "      <td>69382</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>QUAI TILSITT</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>27541.0</td>\n",
           "      <td>108925</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>39</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
           "      <td>18206</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.756707</td>\n",
           "      <td>4.826645</td>\n",
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>41749</th>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>26.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>5</td>\n",
           "      <td>0.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>6</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>3.0</td>\n",
           "      <td>2006-11-15T00:00:00Z</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Espace vert</td>\n",
           "      <td>Terre végétale nue</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2006.0</td>\n",
           "      <td>BRON</td>\n",
           "      <td>69029</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>AVENUE DOYEN JEAN LÉPINE</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2225.0</td>\n",
           "      <td>153732</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>20</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
           "      <td>41733</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.747652</td>\n",
           "      <td>4.905272</td>\n",
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>58531</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>36.0</td>\n",
           "      <td>6</td>\n",
           "      <td>2.0</td>\n",
           "      <td>2</td>\n",
           "      <td>1.0</td>\n",
           "      <td>2006-11-15T00:00:00Z</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Espace vert</td>\n",
           "      <td>Terre végétale nue</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2006.0</td>\n",
           "      <td>BRON</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>69029</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>AVENUE DOYEN JEAN LÉPINE</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2225.0</td>\n",
           "      <td>153733</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>21</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
           "      <td>58518</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
           "      <td>45.747645</td>\n",
           "      <td>4.905221</td>\n",
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>58532</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>31.0</td>\n",
           "      <td>5</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>4</td>\n",
           "      <td>2.0</td>\n",
           "      <td>2006-11-15T00:00:00Z</td>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
           "      <td>Espace vert</td>\n",
           "      <td>Terre végétale nue</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2006.0</td>\n",
           "      <td>BRON</td>\n",
           "      <td>69029</td>\n",
           "      <td>AVENUE DOYEN JEAN LÉPINE</td>\n",
           "      <td>2225.0</td>\n",
           "      <td>153734</td>\n",
           "      <td>22</td>\n",
           "      <td>2</td>\n",
           "      <td>58519</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>NaN</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>45.747626</td>\n",
           "      <td>4.905296</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <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",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
           "      <td>...</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>94984</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>1</td>\n",
           "      <td>0.0</td>\n",
           "      <td>1</td>\n",
           "      <td>0.5</td>\n",
           "      <td>2019-12-02T00:00:00Z</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
           "      <td></td>\n",
           "      <td></td>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
           "      <td>Terre plein latéral</td>\n",
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2019.0</td>\n",
           "      <td>FEYZIN</td>\n",
           "      <td>69276</td>\n",
           "      <td>RUE LEON BLUM</td>\n",
           "      <td>31426.0</td>\n",
           "      <td>511175</td>\n",
           "      <td>118</td>\n",
           "      <td>2</td>\n",
           "      <td>94985</td>\n",
           "      <td>50.0</td>\n",
           "      <td>45.671984</td>\n",
           "      <td>4.855331</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>94985</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
           "      <td>0.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>1</td>\n",
           "      <td>0.0</td>\n",
           "      <td>1</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.5</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2019-12-02T00:00:00Z</td>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
           "      <td>Terre plein latéral</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2019.0</td>\n",
           "      <td>FEYZIN</td>\n",
           "      <td>69276</td>\n",
           "      <td>RUE LEON BLUM</td>\n",
           "      <td>31426.0</td>\n",
           "      <td>511180</td>\n",
           "      <td>123</td>\n",
           "      <td>2</td>\n",
           "      <td>94986</td>\n",
           "      <td>50.0</td>\n",
           "      <td>45.671683</td>\n",
           "      <td>4.855245</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>94986</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>1</td>\n",
           "      <td>0.0</td>\n",
           "      <td>1</td>\n",
           "      <td>0.5</td>\n",
           "      <td>2019-12-02T00:00:00Z</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
           "      <td>Terre plein latéral</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
           "      <td>2019.0</td>\n",
           "      <td>FEYZIN</td>\n",
           "      <td>69276</td>\n",
           "      <td>RUE LEON BLUM</td>\n",
           "      <td>31426.0</td>\n",
           "      <td>511186</td>\n",
           "      <td>129</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>94987</td>\n",
           "      <td>50.0</td>\n",
           "      <td>45.671323</td>\n",
           "      <td>4.855142</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>94996</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>1</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>1</td>\n",
           "      <td>0.5</td>\n",
           "      <td>2019-12-02T00:00:00Z</td>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td></td>\n",
           "      <td></td>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
           "      <td>Terre plein latéral</td>\n",
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2019.0</td>\n",
           "      <td>FEYZIN</td>\n",
           "      <td>69276</td>\n",
           "      <td>RUE LEON BLUM</td>\n",
           "      <td>31426.0</td>\n",
           "      <td>511192</td>\n",
           "      <td>135</td>\n",
           "      <td>2</td>\n",
           "      <td>94997</td>\n",
           "      <td>50.0</td>\n",
           "      <td>45.670963</td>\n",
           "      <td>4.855040</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    </tr>\n",
           "    <tr>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <th>94997</th>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>0.0</td>\n",
           "      <td>1</td>\n",
           "      <td>0.0</td>\n",
           "      <td>1</td>\n",
           "      <td>0.5</td>\n",
           "      <td>2019-12-02T00:00:00Z</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Non défini</td>\n",
           "      <td></td>\n",
           "      <td></td>\n",
           "      <td>Non défini</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Libre</td>\n",
           "      <td>Terre plein latéral</td>\n",
           "      <td>Autres revêtements</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>Rien</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      <td>2019.0</td>\n",
           "      <td>FEYZIN</td>\n",
           "      <td>69276</td>\n",
           "      <td>RUE LEON BLUM</td>\n",
           "      <td>31426.0</td>\n",
           "      <td>511195</td>\n",
           "      <td>138</td>\n",
           "      <td>2</td>\n",
           "      <td>94998</td>\n",
           "      <td>50.0</td>\n",
           "      <td>45.670783</td>\n",
           "      <td>4.854988</td>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "    </tr>\n",
           "  </tbody>\n",
           "</table>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "<p>107 rows × 27 columns</p>\n",
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "</div>"
          ],
          "text/plain": [
    
    Alessandro Cerioni's avatar
    Alessandro Cerioni committed
           "      essencefrancais  circonference_cm  hauteurtotale_m  hauteurfut_m  \\\n",
           "14739      Non défini              52.0                5           2.0   \n",
           "18222      Non défini              52.0                5           2.0   \n",
           "41749      Non défini              26.0                5           0.0   \n",
           "58531      Non défini              36.0                6           2.0   \n",