Newer
Older
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# 3 - Nettoyage des données - 1ère partie"
]
},
{
"cell_type": "code",
"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",
"outputs": [],
"source": [
"filename = 'data/df1.pkl'\n",
"df1 = pd.read_pickle(filename)"
]
},
{
"cell_type": "code",
"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>hauteurtotale_m</th>\n",
" <th>hauteurfut_m</th>\n",
" <th>rayoncouronne_m</th>\n",
" <th>dateplantation</th>\n",
" <th>genre</th>\n",
" <th>localisation</th>\n",
" <th>naturerevetement</th>\n",
" <th>mobilierurbain</th>\n",
" <th>anneeplantation</th>\n",
" <th>commune</th>\n",
" <th>codeinsee</th>\n",
" <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",
" <td>2.5</td>\n",
" <td>2005-03-15T00:00:00Z</td>\n",
" <td>Acer</td>\n",
" <td>Terre plein latéral</td>\n",
" <td>Terre végétale + végétation</td>\n",
" <td>Rien</td>\n",
" <td>2005.0</td>\n",
" <td>LIMONEST</td>\n",
" <td>69116</td>\n",
" <td>NaN</td>\n",
" <td>45.804503</td>\n",
" <td>4.772993</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2.0</td>\n",
" <td>2005-03-15T00:00:00Z</td>\n",
" <td>Acer</td>\n",
" <td>Trottoir ou domaine piétonnier</td>\n",
" <td>Autres revêtements</td>\n",
" <td>Rien</td>\n",
" <td>2005.0</td>\n",
" <td>LIMONEST</td>\n",
" <td>69116</td>\n",
" <td>NaN</td>\n",
" <td>45.803322</td>\n",
" <td>4.775080</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2.5</td>\n",
" <td>2005-03-15T00:00:00Z</td>\n",
" <td>Acer</td>\n",
" <td>Trottoir ou domaine piétonnier</td>\n",
" <td>Autres revêtements</td>\n",
" <td>Rien</td>\n",
" <td>2005.0</td>\n",
" <td>LIMONEST</td>\n",
" <td>69116</td>\n",
" <td>NaN</td>\n",
" <td>45.803241</td>\n",
" <td>4.775227</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>2.5</td>\n",
" <td>2005-03-15T00:00:00Z</td>\n",
" <td>Acer</td>\n",
" <td>Terre plein latéral</td>\n",
" <td>Terre végétale + végétation</td>\n",
" <td>Rien</td>\n",
" <td>2005.0</td>\n",
" <td>LIMONEST</td>\n",
" <td>69116</td>\n",
" <td>NaN</td>\n",
" <td>45.804540</td>\n",
" <td>4.772921</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>2.5</td>\n",
" <td>2005-03-15T00:00:00Z</td>\n",
" <td>Acer</td>\n",
" <td>Terre plein latéral</td>\n",
" <td>Terre végétale + végétation</td>\n",
" <td>Rien</td>\n",
" <td>2005.0</td>\n",
" <td>LIMONEST</td>\n",
" <td>69116</td>\n",
" <td>NaN</td>\n",
" <td>45.804468</td>\n",
" <td>4.773058</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 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",
" 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",
" 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",
" 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",
" 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",
" 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 "
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df1.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Suppression des lignes ayant genre = \"Emplacement libre\" / \"Non défini\" / \"Souche\""
]
},
{
"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",
"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>hauteurtotale_m</th>\n",
" <th>hauteurfut_m</th>\n",
" <th>rayoncouronne_m</th>\n",
" <th>dateplantation</th>\n",
" <th>genre</th>\n",
" <th>localisation</th>\n",
" <th>naturerevetement</th>\n",
" <th>mobilierurbain</th>\n",
" <th>anneeplantation</th>\n",
" <th>commune</th>\n",
" <th>codeinsee</th>\n",
" <th>codefuv</th>\n",
" <th>identifiant</th>\n",
" <th>surfacecadre_m2</th>\n",
" <th>lat</th>\n",
" <th>lon</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>79</th>\n",
" <td>Emplacement libre</td>\n",
" <td>VENISSIEUX</td>\n",
" <td>69259</td>\n",
" <td>BOULEVARD DU DOCTEUR COBLOD</td>\n",
" <td>45.696758</td>\n",
" <td>4.896404</td>\n",
" </tr>\n",
" <tr>\n",
" <th>94</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>NaN</td>\n",
" <td>Emplacement libre</td>\n",
" <td>Trottoir ou domaine piétonnier</td>\n",
" <td>Autres revêtements</td>\n",
" <td>Rien</td>\n",
" <td>NaN</td>\n",
" <td>LYON 7EME</td>\n",
" <td>69387</td>\n",
" <td>0.0</td>\n",
" <td>45.739567</td>\n",
" <td>4.839188</td>\n",
" </tr>\n",
" <tr>\n",
" <th>107</th>\n",
" <td>Emplacement libre</td>\n",
" <td>Trottoir ou domaine piétonnier</td>\n",
" <td>Autres revêtements</td>\n",
" <td>Rien</td>\n",
" <td>NaN</td>\n",
" <td>LYON 6EME</td>\n",
" <td>69386</td>\n",
" <td>NaN</td>\n",
" <td>45.766555</td>\n",
" <td>4.841278</td>\n",
" </tr>\n",
" <tr>\n",
" <th>115</th>\n",
" <td>Emplacement libre</td>\n",
" <td>Terre plein latéral</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>NaN</td>\n",
" <td>45.729193</td>\n",
" <td>4.824097</td>\n",
" </tr>\n",
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
" <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",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 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",
" 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",
" 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",
" 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",
" 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",
" 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",
" 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 "
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(df1[ (df1.genre == 'Emplacement libre') ])"
]
},
{
"cell_type": "code",
"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>hauteurtotale_m</th>\n",
" <th>hauteurfut_m</th>\n",
" <th>rayoncouronne_m</th>\n",
" <th>dateplantation</th>\n",
" <th>genre</th>\n",
" <th>localisation</th>\n",
" <th>naturerevetement</th>\n",
" <th>mobilierurbain</th>\n",
" <th>anneeplantation</th>\n",
" <th>commune</th>\n",
" <th>codeinsee</th>\n",
" <th>codefuv</th>\n",
" <th>identifiant</th>\n",
" <th>surfacecadre_m2</th>\n",
" <th>lat</th>\n",
" <th>lon</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>52.0</td>\n",
" <td>5</td>\n",
" <td>2.0</td>\n",
" <td>5</td>\n",
" <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",
" <td>Trottoir ou domaine piétonnier</td>\n",
" <td>Terre végétale nue</td>\n",
" <td>Rien</td>\n",
" <td>2004.0</td>\n",
" <td>LYON 2EME</td>\n",
" <td>69382</td>\n",
" <td>NaN</td>\n",
" <td>45.756531</td>\n",
" <td>4.826460</td>\n",
" </tr>\n",
" <tr>\n",
" <td>52.0</td>\n",
" <td>5</td>\n",
" <td>2.0</td>\n",
" <td>5</td>\n",
" <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",
" <td>Trottoir ou domaine piétonnier</td>\n",
" <td>Terre végétale nue</td>\n",
" <td>Rien</td>\n",
" <td>2004.0</td>\n",
" <td>LYON 2EME</td>\n",
" <td>69382</td>\n",
" <td>NaN</td>\n",
" <td>45.756707</td>\n",
" <td>4.826645</td>\n",
" </tr>\n",
" <tr>\n",
" <td>3.0</td>\n",
" <td>2006-11-15T00:00:00Z</td>\n",
" <td>Espace vert</td>\n",
" <td>Terre végétale nue</td>\n",
" <td>Rien</td>\n",
" <td>2006.0</td>\n",
" <td>BRON</td>\n",
" <td>69029</td>\n",
" <td>NaN</td>\n",
" <td>45.747652</td>\n",
" <td>4.905272</td>\n",
" </tr>\n",
" <tr>\n",
" <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",
" <td>Espace vert</td>\n",
" <td>Terre végétale nue</td>\n",
" <td>NaN</td>\n",
" <td>45.747645</td>\n",
" <td>4.905221</td>\n",
" </tr>\n",
" <tr>\n",
" <td>4</td>\n",
" <td>2.0</td>\n",
" <td>2006-11-15T00:00:00Z</td>\n",
" <td>Non défini</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>Non défini</td>\n",
" <td>Libre</td>\n",
" <td>Espace vert</td>\n",
" <td>Terre végétale nue</td>\n",
" <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",
" <td>45.747626</td>\n",
" <td>4.905296</td>\n",
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
" <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",
" <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",
" <td>Non défini</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>Non défini</td>\n",
" <td>Libre</td>\n",
" <td>Terre plein latéral</td>\n",
" <td>Autres revêtements</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>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",
" <td>1</td>\n",
" <td>0.0</td>\n",
" <td>1</td>\n",
" <td>2019-12-02T00:00:00Z</td>\n",
" <td>Non défini</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>Non défini</td>\n",
" <td>Libre</td>\n",
" <td>Terre plein latéral</td>\n",
" <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",
" <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",
" <td>Libre</td>\n",
" <td>Terre plein latéral</td>\n",
" <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",
" <td>94987</td>\n",
" <td>50.0</td>\n",
" <td>45.671323</td>\n",
" <td>4.855142</td>\n",
" <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",
" <td></td>\n",
" <td></td>\n",
" <td>Non défini</td>\n",
" <td>Libre</td>\n",
" <td>Terre plein latéral</td>\n",
" <td>Autres revêtements</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>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",
" <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",
" <td>Non défini</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>Non défini</td>\n",
" <td>Libre</td>\n",
" <td>Terre plein latéral</td>\n",
" <td>Autres revêtements</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>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",
" 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",