{
"cells": [
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"b'Skipping line 1916: expected 17 fields, saw 18\\n'\n"
]
},
{
"data": {
"text/plain": [
"(200332, 17)"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# loader le fichier csv\n",
"import pandas as pd \n",
"\n",
"df = pd.read_csv('../../data/les-arbres.csv', sep = ';', error_bad_lines = False)\n",
"\n",
"\n",
"df.shape"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" IDBASE | \n",
" TYPEEMPLACEMENT | \n",
" DOMANIALITE | \n",
" ARRONDISSEMENT | \n",
" COMPLEMENTADRESSE | \n",
" NUMERO | \n",
" LIEU / ADRESSE | \n",
" IDEMPLACEMENT | \n",
" LIBELLEFRANCAIS | \n",
" GENRE | \n",
" ESPECE | \n",
" VARIETEOUCULTIVAR | \n",
" CIRCONFERENCEENCM | \n",
" HAUTEUR (m) | \n",
" STADEDEVELOPPEMENT | \n",
" REMARQUABLE | \n",
" geo_point_2d | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 232702.0 | \n",
" Arbre | \n",
" Alignement | \n",
" PARIS 11E ARRDT | \n",
" NaN | \n",
" NaN | \n",
" BOULEVARD DE MENILMONTANT | \n",
" 000602002 | \n",
" Sophora | \n",
" Sophora | \n",
" japonica | \n",
" NaN | \n",
" 55.0 | \n",
" 5.0 | \n",
" JA | \n",
" 0.0 | \n",
" 48.8652353853, 2.38481800435 | \n",
"
\n",
" \n",
" 1 | \n",
" 235862.0 | \n",
" Arbre | \n",
" Alignement | \n",
" PARIS 18E ARRDT | \n",
" NaN | \n",
" NaN | \n",
" AVENUE DE LA PORTE DE CLIGNANCOURT | \n",
" 000303007 | \n",
" Tilleul | \n",
" Tilia | \n",
" tomentosa | \n",
" NaN | \n",
" 60.0 | \n",
" 10.0 | \n",
" JA | \n",
" NaN | \n",
" 48.8999949231, 2.34379810146 | \n",
"
\n",
" \n",
" 2 | \n",
" 236391.0 | \n",
" Arbre | \n",
" Alignement | \n",
" PARIS 15E ARRDT | \n",
" 27 | \n",
" NaN | \n",
" BOULEVARD GARIBALDI | \n",
" 000101024 | \n",
" Noisetier de Byzance | \n",
" Corylus | \n",
" colurna | \n",
" NaN | \n",
" 60.0 | \n",
" 10.0 | \n",
" JA | \n",
" NaN | \n",
" 48.8470727044, 2.30470921442 | \n",
"
\n",
" \n",
" 3 | \n",
" 241122.0 | \n",
" Arbre | \n",
" Alignement | \n",
" PARIS 14E ARRDT | \n",
" NaN | \n",
" NaN | \n",
" RUE SARRETTE | \n",
" 000501003 | \n",
" Tilleul | \n",
" Tilia | \n",
" tomentosa | \n",
" NaN | \n",
" 155.0 | \n",
" 12.0 | \n",
" A | \n",
" 0.0 | \n",
" 48.8259993388, 2.32878574525 | \n",
"
\n",
" \n",
" 4 | \n",
" 99927.0 | \n",
" Arbre | \n",
" Jardin | \n",
" PARIS 16E ARRDT | \n",
" NaN | \n",
" NaN | \n",
" JARDIN DU RANELAGH | \n",
" 00030007 | \n",
" Erable | \n",
" Acer | \n",
" platanoides | \n",
" 'Schwedleri' | \n",
" 125.0 | \n",
" 0.0 | \n",
" NaN | \n",
" NaN | \n",
" 48.858836461, 2.26870442691 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" IDBASE TYPEEMPLACEMENT DOMANIALITE ARRONDISSEMENT COMPLEMENTADRESSE \\\n",
"0 232702.0 Arbre Alignement PARIS 11E ARRDT NaN \n",
"1 235862.0 Arbre Alignement PARIS 18E ARRDT NaN \n",
"2 236391.0 Arbre Alignement PARIS 15E ARRDT 27 \n",
"3 241122.0 Arbre Alignement PARIS 14E ARRDT NaN \n",
"4 99927.0 Arbre Jardin PARIS 16E ARRDT NaN \n",
"\n",
" NUMERO LIEU / ADRESSE IDEMPLACEMENT \\\n",
"0 NaN BOULEVARD DE MENILMONTANT 000602002 \n",
"1 NaN AVENUE DE LA PORTE DE CLIGNANCOURT 000303007 \n",
"2 NaN BOULEVARD GARIBALDI 000101024 \n",
"3 NaN RUE SARRETTE 000501003 \n",
"4 NaN JARDIN DU RANELAGH 00030007 \n",
"\n",
" LIBELLEFRANCAIS GENRE ESPECE VARIETEOUCULTIVAR \\\n",
"0 Sophora Sophora japonica NaN \n",
"1 Tilleul Tilia tomentosa NaN \n",
"2 Noisetier de Byzance Corylus colurna NaN \n",
"3 Tilleul Tilia tomentosa NaN \n",
"4 Erable Acer platanoides 'Schwedleri' \n",
"\n",
" CIRCONFERENCEENCM HAUTEUR (m) STADEDEVELOPPEMENT REMARQUABLE \\\n",
"0 55.0 5.0 JA 0.0 \n",
"1 60.0 10.0 JA NaN \n",
"2 60.0 10.0 JA NaN \n",
"3 155.0 12.0 A 0.0 \n",
"4 125.0 0.0 NaN NaN \n",
"\n",
" geo_point_2d \n",
"0 48.8652353853, 2.38481800435 \n",
"1 48.8999949231, 2.34379810146 \n",
"2 48.8470727044, 2.30470921442 \n",
"3 48.8259993388, 2.32878574525 \n",
"4 48.858836461, 2.26870442691 "
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" IDBASE | \n",
" NUMERO | \n",
" CIRCONFERENCEENCM | \n",
" HAUTEUR (m) | \n",
" REMARQUABLE | \n",
"
\n",
" \n",
" \n",
" \n",
" count | \n",
" 2.003320e+05 | \n",
" 0.0 | \n",
" 200332.000000 | \n",
" 200332.000000 | \n",
" 137203.000000 | \n",
"
\n",
" \n",
" mean | \n",
" 3.871040e+05 | \n",
" NaN | \n",
" 83.377988 | \n",
" 13.108235 | \n",
" 0.001341 | \n",
"
\n",
" \n",
" std | \n",
" 5.454652e+05 | \n",
" NaN | \n",
" 672.864029 | \n",
" 1970.258098 | \n",
" 0.036596 | \n",
"
\n",
" \n",
" min | \n",
" 9.987400e+04 | \n",
" NaN | \n",
" 0.000000 | \n",
" 0.000000 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 25% | \n",
" 1.558788e+05 | \n",
" NaN | \n",
" 30.000000 | \n",
" 5.000000 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 50% | \n",
" 2.210865e+05 | \n",
" NaN | \n",
" 70.000000 | \n",
" 8.000000 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 75% | \n",
" 2.741462e+05 | \n",
" NaN | \n",
" 115.000000 | \n",
" 12.000000 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" max | \n",
" 2.024745e+06 | \n",
" NaN | \n",
" 250255.000000 | \n",
" 881818.000000 | \n",
" 1.000000 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" IDBASE NUMERO CIRCONFERENCEENCM HAUTEUR (m) REMARQUABLE\n",
"count 2.003320e+05 0.0 200332.000000 200332.000000 137203.000000\n",
"mean 3.871040e+05 NaN 83.377988 13.108235 0.001341\n",
"std 5.454652e+05 NaN 672.864029 1970.258098 0.036596\n",
"min 9.987400e+04 NaN 0.000000 0.000000 0.000000\n",
"25% 1.558788e+05 NaN 30.000000 5.000000 0.000000\n",
"50% 2.210865e+05 NaN 70.000000 8.000000 0.000000\n",
"75% 2.741462e+05 NaN 115.000000 12.000000 0.000000\n",
"max 2.024745e+06 NaN 250255.000000 881818.000000 1.000000"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# les stats sur les variable numeriques\n",
"\n",
"df.describe()"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Index(['IDBASE', 'TYPEEMPLACEMENT', 'DOMANIALITE', 'ARRONDISSEMENT',\n",
" 'COMPLEMENTADRESSE', 'LIEU / ADRESSE', 'IDEMPLACEMENT',\n",
" 'LIBELLEFRANCAIS', 'GENRE', 'ESPECE', 'VARIETEOUCULTIVAR',\n",
" 'CIRCONFERENCEENCM', 'HAUTEUR (m)', 'STADEDEVELOPPEMENT', 'REMARQUABLE',\n",
" 'geo_point_2d'],\n",
" dtype='object')"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# enlever la colonne NUMERO\n",
"\n",
"df.drop(columns = ['NUMERO'], inplace=True)\n",
"\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"False"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"'NUMERO' in df.columns"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"----------------------------------------\n",
" TYPEEMPLACEMENT\n",
"Arbre 200332\n",
"Name: TYPEEMPLACEMENT, dtype: int64\n",
"----------------------------------------\n",
" DOMANIALITE\n",
"Alignement 105061\n",
"Jardin 46329\n",
"CIMETIERE 31933\n",
"Name: DOMANIALITE, dtype: int64\n",
"----------------------------------------\n",
" ARRONDISSEMENT\n",
"PARIS 15E ARRDT 17156\n",
"PARIS 13E ARRDT 16714\n",
"PARIS 16E ARRDT 16405\n",
"Name: ARRONDISSEMENT, dtype: int64\n",
"----------------------------------------\n",
" COMPLEMENTADRESSE\n",
"NaN 169318\n",
"SN° 557\n",
"1 552\n",
"Name: COMPLEMENTADRESSE, dtype: int64\n",
"----------------------------------------\n",
" LIEU / ADRESSE\n",
"PARC FLORAL DE PARIS / ROUTE DE LA PYRAMIDE 2995\n",
"PARC DES BUTTES CHAUMONT 2331\n",
"PARC ANDRE CITROEN 2095\n",
"Name: LIEU / ADRESSE, dtype: int64\n",
"----------------------------------------\n",
" IDEMPLACEMENT\n",
"000101001 1290\n",
"000101002 1210\n",
"000101003 1098\n",
"Name: IDEMPLACEMENT, dtype: int64\n",
"----------------------------------------\n",
" LIBELLEFRANCAIS\n",
"Platane 42565\n",
"Marronnier 25231\n",
"Tilleul 21335\n",
"Name: LIBELLEFRANCAIS, dtype: int64\n",
"----------------------------------------\n",
" GENRE\n",
"Platanus 42648\n",
"Aesculus 25366\n",
"Tilia 21580\n",
"Name: GENRE, dtype: int64\n",
"----------------------------------------\n",
" ESPECE\n",
"x hispanica 36464\n",
"hippocastanum 20063\n",
"japonica 11823\n",
"Name: ESPECE, dtype: int64\n",
"----------------------------------------\n",
" VARIETEOUCULTIVAR\n",
"NaN 163529\n",
"'Baumannii' 4558\n",
"'Briotii' 2827\n",
"Name: VARIETEOUCULTIVAR, dtype: int64\n",
"----------------------------------------\n",
" STADEDEVELOPPEMENT\n",
"NaN 67247\n",
"A 64526\n",
"JA 35486\n",
"Name: STADEDEVELOPPEMENT, dtype: int64\n",
"----------------------------------------\n",
" geo_point_2d\n",
"48.8383178014, 2.40660990318 2\n",
"48.8385499225, 2.43926756645 2\n",
"48.9002534452, 2.38644429503 2\n",
"Name: geo_point_2d, dtype: int64\n"
]
}
],
"source": [
"for col in df.columns:\n",
" if df[col].dtype == 'O':\n",
" print(\"--\" * 20)\n",
" print(\" {}\".format(col))\n",
" print(df[col].value_counts( dropna= False )[:3] )\n",
" "
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import matplotlib.pyplot as plt\n",
"%matplotlib inline"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAY0AAAD8CAYAAACLrvgBAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAGlhJREFUeJzt3X+MVeed3/H3pxC8rLMOEMdXFNiC\n1dlosd0SM3JI06ymZoMBrYKzsrcgFGZtV5N4sZS0SA1s/nAax1K8LUllmpCQNTWsWGPXdgKycFnE\n+m60kk2MY5YfsQljzJoJFNbGIZ5465T02z/OM+Qw987Mw71T3/Gdz0s6uud8z/M855wvx/nm/Lhz\nFRGYmZnl+Cet3gEzM3vvcNEwM7NsLhpmZpbNRcPMzLK5aJiZWTYXDTMzy+aiYWZm2Vw0zMwsm4uG\nmZllm9jqHRhtV199dcyePbuhvr/4xS+48sorR3eH3uOck1rOSS3npNZ7LScvvPDC6xHxoZHatV3R\nmD17Nvv372+ob7Vapaura3R36D3OOanlnNRyTmq913Ii6e9z2vn2lJmZZXPRMDOzbC4aZmaWzUXD\nzMyyuWiYmVm2EYuGpFmSnpH0kqQjkj6f4tMk7ZF0LH1OTXFJelBSr6SDkm4sjdWd2h+T1F2Kz5d0\nKPV5UJKG24aZmbVGzpXGBWBNRPwusABYLWkusBbYGxEdwN60DLAE6EhTD7ARigIA3At8FLgJuLdU\nBDamtgP9Fqf4UNswM7MWGLFoRMTpiPhRmn8LeAmYASwDtqRmW4Bb0/wyYGsUngOmSJoO3ALsiYhz\nEfEmsAdYnNZdFRHPRvHbs1sHjVVvG2Zm1gKX9UxD0mzgI8A+oBIRp6EoLMA1qdkM4GSpW1+KDRfv\nqxNnmG2YmVkLZH8jXNL7gSeAL0TEz9Njh7pN68SigXg2ST0Ut7eoVCpUq9XL6X7R2XPn2bBtBwA3\nzPhAQ2O0m/7+/obz2a6ck1rOSa12zUlW0ZD0PoqCsS0inkzhM5KmR8TpdIvpbIr3AbNK3WcCp1K8\na1C8muIz67QfbhuXiIhNwCaAzs7OaPSr+xu27WD9oSIlJ1Y2Nka7ea/9KYR3g3NSyzmp1a45yXl7\nSsBDwEsR8fXSqp3AwBtQ3cCOUnxVeotqAXA+3VraDSySNDU9AF8E7E7r3pK0IG1r1aCx6m3DzMxa\nIOdK4+PAZ4BDkg6k2J8CXwMek3QX8Bpwe1q3C1gK9AJvA3cARMQ5SfcBz6d2X4mIc2n+buBhYDLw\ndJoYZhtmZtYCIxaNiPhb6j93AFhYp30Aq4cYazOwuU58P3B9nfgb9bZhZmat4W+Em5lZNhcNMzPL\n5qJhZmbZXDTMzCybi4aZmWVz0TAzs2wuGmZmls1Fw8zMsrlomJlZNhcNMzPL5qJhZmbZXDTMzCyb\ni4aZmWVz0TAzs2wuGmZmls1Fw8zMsrlomJlZtpzfCN8s6aykw6XYo5IOpOnEwM/ASpot6R9L675d\n6jNf0iFJvZIeTL8HjqRpkvZIOpY+p6a4UrteSQcl3Tj6h29mZpcj50rjYWBxORAR/zYi5kXEPOAJ\n4MnS6lcG1kXE50rxjUAP0JGmgTHXAnsjogPYm5YBlpTa9qT+ZmbWQiMWjYj4AXCu3rp0tfBHwCPD\njSFpOnBVRDybfkN8K3BrWr0M2JLmtwyKb43Cc8CUNI6ZmbVIs880PgGciYhjpdgcSS9K+htJn0ix\nGUBfqU1figFUIuI0QPq8ptTn5BB9zMysBSY22X8Fl15lnAZ+OyLekDQf+L6k6wDV6RsjjJ3dR1IP\nxS0sKpUK1Wp1pP2uqzIZ1txwAaDhMdpNf3+/czGIc1LLOanVrjlpuGhImgj8ITB/IBYR7wDvpPkX\nJL0C/A7FVcLMUveZwKk0f0bS9Ig4nW4/nU3xPmDWEH0uERGbgE0AnZ2d0dXV1dAxbdi2g/WHipSc\nWNnYGO2mWq3SaD7blXNSyzmp1a45aeb21O8DL0fExdtOkj4kaUKav5biIfbxdNvpLUkL0nOQVcCO\n1G0n0J3muwfFV6W3qBYA5wduY5mZWWvkvHL7CPAs8GFJfZLuSquWU/sA/PeAg5L+Dngc+FxEDDxE\nvxv4c6AXeAV4OsW/BnxS0jHgk2kZYBdwPLX/LvAnl394ZmY2mka8PRURK4aI/3Gd2BMUr+DWa78f\nuL5O/A1gYZ14AKtH2j8zM3v3+BvhZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZ\nZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOzbC4aZmaW\nLefnXjdLOivpcCn2ZUk/lXQgTUtL69ZJ6pV0VNItpfjiFOuVtLYUnyNpn6Rjkh6VNCnFr0jLvWn9\n7NE6aDMza0zOlcbDwOI68W9ExLw07QKQNJfit8OvS32+JWmCpAnAN4ElwFxgRWoL8EAaqwN4Exj4\nDfK7gDcj4p8D30jtzMyshUYsGhHxA+Bc5njLgO0R8U5EvAr0AjelqTcijkfEL4HtwDJJAm4GHk/9\ntwC3lsbakuYfBxam9mZm1iLNPNO4R9LBdPtqaorNAE6W2vSl2FDxDwI/i4gLg+KXjJXWn0/tzcys\nRSY22G8jcB8Q6XM9cCdQ70ogqF+cYpj2jLDuEpJ6gB6ASqVCtVodZteHVpkMa24o6lejY7Sb/v5+\n52IQ56SWc1KrXXPSUNGIiDMD85K+CzyVFvuAWaWmM4FTab5e/HVgiqSJ6Wqi3H5grD5JE4EPMMRt\nsojYBGwC6OzsjK6urkYOiw3bdrD+UJGSEysbG6PdVKtVGs1nu3JOajkntdo1Jw3dnpI0vbT4aWDg\nzaqdwPL05tMcoAP4IfA80JHelJpE8bB8Z0QE8AxwW+rfDewojdWd5m8D/jq1NzOzFhnxSkPSI0AX\ncLWkPuBeoEvSPIrbRSeAzwJExBFJjwE/Bi4AqyPiV2mce4DdwARgc0QcSZv4IrBd0leBF4GHUvwh\n4C8k9VJcYSxv+mjNzKwpIxaNiFhRJ/xQndhA+/uB++vEdwG76sSPU7xdNTj+v4HbR9o/MzN79/gb\n4WZmls1Fw8zMsrlomJlZNhcNMzPL5qJhZmbZXDTMzCybi4aZmWVz0TAzs2wuGmZmls1Fw8zMsrlo\nmJlZNhcNMzPL5qJhZmbZXDTMzCybi4aZmWVz0TAzs2wuGmZmlm3EoiFps6Szkg6XYv9Z0suSDkr6\nnqQpKT5b0j9KOpCmb5f6zJd0SFKvpAclKcWnSdoj6Vj6nJriSu1603ZuHP3DNzOzy5FzpfEwsHhQ\nbA9wfUT8C+AnwLrSulciYl6aPleKbwR6gI40DYy5FtgbER3A3rQMsKTUtif1NzOzFhqxaETED4Bz\ng2J/FREX0uJzwMzhxpA0HbgqIp6NiAC2Arem1cuALWl+y6D41ig8B0xJ45iZWYuMxjONO4GnS8tz\nJL0o6W8kfSLFZgB9pTZ9KQZQiYjTAOnzmlKfk0P0MTOzFpjYTGdJXwIuANtS6DTw2xHxhqT5wPcl\nXQeoTvcYafjcPpJ6KG5hUalUqFarGXtfqzIZ1txQXEA1Oka76e/vdy4GcU5qOSe12jUnDRcNSd3A\nHwAL0y0nIuId4J00/4KkV4DfobhKKN/CmgmcSvNnJE2PiNPp9tPZFO8DZg3R5xIRsQnYBNDZ2Rld\nXV0NHdOGbTtYf6hIyYmVjY3RbqrVKo3ms105J7Wck1rtmpOGbk9JWgx8EfhURLxdin9I0oQ0fy3F\nQ+zj6bbTW5IWpLemVgE7UredQHea7x4UX5XeoloAnB+4jWVmZq0x4pWGpEeALuBqSX3AvRRvS10B\n7Elvzj6X3pT6PeArki4AvwI+FxEDD9HvpngTazLFM5CB5yBfAx6TdBfwGnB7iu8ClgK9wNvAHc0c\nqJmZNW/EohERK+qEHxqi7RPAE0Os2w9cXyf+BrCwTjyA1SPtn5mZvXv8jXAzM8vmomFmZtlcNMzM\nLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOz\nbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8uWVTQkbZZ0VtLhUmyapD2SjqXPqSkuSQ9K6pV0UNKNpT7d\nqf0xSd2l+HxJh1KfB9PviA+5DTMza43cK42HgcWDYmuBvRHRAexNywBLgI409QAboSgAFL8v/lHg\nJuDeUhHYmNoO9Fs8wjbMzKwFsopGRPwAODcovAzYkua3ALeW4luj8BwwRdJ04BZgT0Sci4g3gT3A\n4rTuqoh4Nv0u+NZBY9XbhpmZtcDEJvpWIuI0QESclnRNis8ATpba9aXYcPG+OvHhtnEJST0UVypU\nKhWq1WpjBzQZ1txwAaDhMdpNf3+/czGIc1LLOanVrjlppmgMRXVi0UA8W0RsAjYBdHZ2RldX1+V0\nv2jDth2sP1Sk5MTKxsZoN9VqlUbz2a6ck1rOSa12zUkzb0+dSbeWSJ9nU7wPmFVqNxM4NUJ8Zp34\ncNswM7MWaKZo7AQG3oDqBnaU4qvSW1QLgPPpFtNuYJGkqekB+CJgd1r3lqQF6a2pVYPGqrcNMzNr\ngazbU5IeAbqAqyX1UbwF9TXgMUl3Aa8Bt6fmu4ClQC/wNnAHQESck3Qf8Hxq95WIGHi4fjfFG1qT\ngafTxDDbMDOzFsgqGhGxYohVC+u0DWD1EONsBjbXie8Hrq8Tf6PeNszMrDX8jXAzM8vmomFmZtlc\nNMzMLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZZXPR\nMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vWcNGQ9GFJB0rTzyV9QdKXJf20FF9a6rNOUq+ko5Ju\nKcUXp1ivpLWl+BxJ+yQdk/SopEmNH6qZmTWr4aIREUcjYl5EzAPmU/we+PfS6m8MrIuIXQCS5gLL\ngeuAxcC3JE2QNAH4JrAEmAusSG0BHkhjdQBvAnc1ur9mZta80bo9tRB4JSL+fpg2y4DtEfFORLwK\n9AI3pak3Io5HxC+B7cAySQJuBh5P/bcAt47S/pqZWQMmjtI4y4FHSsv3SFoF7AfWRMSbwAzguVKb\nvhQDODko/lHgg8DPIuJCnfaXkNQD9ABUKhWq1WpDB1GZDGtuKDbX6Bjtpr+/37kYxDmp5ZzUatec\nNF000nOGTwHrUmgjcB8Q6XM9cCegOt2D+lc7MUz72mDEJmATQGdnZ3R1deUfQMmGbTtYf6hIyYmV\njY3RbqrVKo3ms105J7Wck1rtmpPRuNJYAvwoIs4ADHwCSPou8FRa7ANmlfrNBE6l+Xrx14Epkiam\nq41yezMza4HReKaxgtKtKUnTS+s+DRxO8zuB5ZKukDQH6AB+CDwPdKQ3pSZR3OraGREBPAPclvp3\nAztGYX/NzKxBTV1pSPpN4JPAZ0vhP5M0j+JW0omBdRFxRNJjwI+BC8DqiPhVGuceYDcwAdgcEUfS\nWF8Etkv6KvAi8FAz+2tmZs1pqmhExNsUD6zLsc8M0/5+4P468V3Arjrx4xRvV5mZ2Rjgb4SbmVk2\nFw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlc\nNMzMLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyNV00JJ2QdEjSAUn7U2yapD2SjqXPqSkuSQ9K6pV0\nUNKNpXG6U/tjkrpL8flp/N7UV83us5mZNWa0rjT+TUTMi4jOtLwW2BsRHcDetAywhOK3wTuAHmAj\nFEUGuBf4KMUv9d07UGhSm55Sv8WjtM9mZnaZ/n/dnloGbEnzW4BbS/GtUXgOmCJpOnALsCcizkXE\nm8AeYHFad1VEPBsRAWwtjWVmZu+y0SgaAfyVpBck9aRYJSJOA6TPa1J8BnCy1LcvxYaL99WJm5lZ\nC0wchTE+HhGnJF0D7JH08jBt6z2PiAbilw5aFKsegEqlQrVaHXGn66lMhjU3XABoeIx209/f71wM\n4pzUck5qtWtOmi4aEXEqfZ6V9D2KZxJnJE2PiNPpFtPZ1LwPmFXqPhM4leJdg+LVFJ9Zp/3gfdgE\nbALo7OyMrq6uwU2ybNi2g/WHipScWNnYGO2mWq3SaD7blXNSyzmp1a45aer2lKQrJf3WwDywCDgM\n7AQG3oDqBnak+Z3AqvQW1QLgfLp9tRtYJGlqegC+CNid1r0laUF6a2pVaSwzM3uXNXulUQG+l96C\nnQj8ZUT8T0nPA49Jugt4Dbg9td8FLAV6gbeBOwAi4pyk+4DnU7uvRMS5NH838DAwGXg6TWZm1gJN\nFY2IOA78yzrxN4CFdeIBrB5irM3A5jrx/cD1zeynmZmNDn8j3MzMsrlomJlZNhcNMzPL5qJhZmbZ\nXDTMzCybi4aZmWVz0TAzs2wuGmZmls1Fw8zMsrlomJlZNhcNMzPL5qJhZmbZXDTMzCybi4aZmWVz\n0TAzs2wuGmZmls1Fw8zMsjVcNCTNkvSMpJckHZH0+RT/sqSfSjqQpqWlPusk9Uo6KumWUnxxivVK\nWluKz5G0T9IxSY9KmtTo/pqZWfOaudK4AKyJiN8FFgCrJc1N674REfPStAsgrVsOXAcsBr4laYKk\nCcA3gSXAXGBFaZwH0lgdwJvAXU3sr5mZNanhohERpyPiR2n+LeAlYMYwXZYB2yPinYh4FegFbkpT\nb0Qcj4hfAtuBZZIE3Aw8nvpvAW5tdH/NzKx5o/JMQ9Js4CPAvhS6R9JBSZslTU2xGcDJUre+FBsq\n/kHgZxFxYVDczMxaZGKzA0h6P/AE8IWI+LmkjcB9QKTP9cCdgOp0D+oXrhimfb196AF6ACqVCtVq\n9TKPolCZDGtuKGpUo2O0m/7+fudiEOeklnNSq11z0lTRkPQ+ioKxLSKeBIiIM6X13wWeSot9wKxS\n95nAqTRfL/46MEXSxHS1UW5/iYjYBGwC6OzsjK6uroaOZ8O2Haw/VKTkxMrGxmg31WqVRvPZrpyT\nWs5JrXbNSTNvTwl4CHgpIr5eik8vNfs0cDjN7wSWS7pC0hygA/gh8DzQkd6UmkTxsHxnRATwDHBb\n6t8N7Gh0f83MrHnNXGl8HPgMcEjSgRT7U4q3n+ZR3Eo6AXwWICKOSHoM+DHFm1erI+JXAJLuAXYD\nE4DNEXEkjfdFYLukrwIvUhQpMzNrkYaLRkT8LfWfO+waps/9wP114rvq9YuI4xRvV5mZ2Rjgb4Sb\nmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFm\nZtlcNMzMLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVm2MV80JC2WdFRSr6S1rd4fM7PxbEwX\nDUkTgG8CS4C5FL8/Pre1e2VmNn6N6aJB8fvgvRFxPCJ+CWwHlrV4n8zMxq2xXjRmACdLy30pZmZm\nLTCx1TswAtWJRU0jqQfoSYv9ko42uL2rgdcB9ECDI7Sfizmxi5yTWs5JrfdaTv5ZTqOxXjT6gFml\n5ZnAqcGNImITsKnZjUnaHxGdzY7TTpyTWs5JLeekVrvmZKzfnnoe6JA0R9IkYDmws8X7ZGY2bo3p\nK42IuCDpHmA3MAHYHBFHWrxbZmbj1pguGgARsQvY9S5trulbXG3IOanlnNRyTmq1ZU4UUfNc2czM\nrK6x/kzDzMzGEBeNpN3+XImkWZKekfSSpCOSPp/i0yTtkXQsfU5NcUl6MB3/QUk3lsbqTu2PSeou\nxedLOpT6PChJw21jrJA0QdKLkp5Ky3Mk7Uv7+2h66QJJV6Tl3rR+dmmMdSl+VNItpXjd82iobYwF\nkqZIelzSy+l8+dh4P08k/fv0381hSY9I+o3xfp5cFBHjfqJ4yP4KcC0wCfg7YG6r96vJY5oO3Jjm\nfwv4CcWfYvkzYG2KrwUeSPNLgacpvhuzANiX4tOA4+lzapqfmtb9EPhY6vM0sCTF625jrEzAfwD+\nEngqLT8GLE/z3wbuTvN/Anw7zS8HHk3zc9M5cgUwJ507E4Y7j4baxliYgC3Av0vzk4Ap4/k8ofgC\n8avA5NK/3R+P9/PkYn5avQNjYUon9O7S8jpgXav3a5SPcQfwSeAoMD3FpgNH0/x3gBWl9kfT+hXA\nd0rx76TYdODlUvxiu6G2MRYmiu/67AVuBp5K/0P2OjBx8LlA8dbex9L8xNROg8+PgXZDnUfDbaPV\nE3BV+h9IDYqP2/OEX/8limnp3/0p4JbxfJ6UJ9+eKrT1nytJl8sfAfYBlYg4DZA+r0nNhsrBcPG+\nOnGG2cZY8F+B/wj837T8QeBnEXEhLZeP4+Kxp/XnU/vLzdVw22i1a4F/AP57umX355KuZByfJxHx\nU+C/AK8Bpyn+3V9gfJ8nF7loFLL+XMl7kaT3A08AX4iInw/XtE4sGoiPWZL+ADgbES+Uw3Waxgjr\n2ilXE4EbgY0R8RHgFxS3iobSTsdeV3q2soziltI/Ba6k+Evbg42n8+QiF41C1p8rea+R9D6KgrEt\nIp5M4TOSpqf104GzKT5UDoaLz6wTH24brfZx4FOSTlD8xeSbKa48pkga+M5S+TguHnta/wHgHJef\nq9eH2Uar9QF9EbEvLT9OUUTG83ny+8CrEfEPEfF/gCeBf8X4Pk8uctEotN2fK0lvqDwEvBQRXy+t\n2gkMvNnSTfGsYyC+Kr0dswA4n24Z7AYWSZqa/h/YIor7rKeBtyQtSNtaNWisettoqYhYFxEzI2I2\nxb/xX0fESuAZ4LbUbHBOBo7jttQ+Unx5emtmDtBB8bC37nmU+gy1jZaKiP8FnJT04RRaCPyYcXye\nUNyWWiDpN9M+D+Rk3J4nl2j1Q5WxMlG8FfITircavtTq/RmF4/nXFJe2B4EDaVpKcd90L3AsfU5L\n7UXxg1evAIeAztJYdwK9abqjFO8EDqc+/41ff1m07jbG0gR08eu3p66l+I+5F/gfwBUp/htpuTet\nv7bU/0vpuI+S3gYa7jwaahtjYQLmAfvTufJ9irefxvV5Avwn4OW0339B8QbUuD5PBiZ/I9zMzLL5\n9pSZmWVz0TAzs2wuGmZmls1Fw8zMsrlomJlZNhcNMzPL5qJhZmbZXDTMzCzb/wNL27Qjtiej5AAA\nAABJRU5ErkJggg==\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"fig, ax = plt.subplots(1,1)\n",
"df['HAUTEUR (m)'].hist(bins = 100)\n",
"plt.show()"
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {},
"outputs": [
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAY0AAAD8CAYAAACLrvgBAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAGg5JREFUeJzt3W+MVNeZ5/Hvb+nYwzpxwHFcagGz\n4N2e0WB7l0DLYZRN1BtvMKDV4KzsHZAVem2kTjxYSiRGCp68sBXHUjwrEsnehASPkWHEGnvteBpF\neAliXBON5H84JvyJQ2gIEzogkI1D3PGMs3iffXFPWZd2dfehqt3VTf0+0lXdeu45596nqszje+6t\nLkUEZmZmOf5Vqw/AzMymDhcNMzPL5qJhZmbZXDTMzCybi4aZmWVz0TAzs2wuGmZmls1Fw8zMsrlo\nmJlZto5WH8B4u/rqq2Pu3LkN9f3d737HFVdcMb4HNMk55/bgnC99zeb7yiuvvB4RHx+r3SVXNObO\nncvevXsb6lutVunp6RnfA5rknHN7cM6XvmbzlfRPOe08PWVmZtlcNMzMLJuLhpmZZXPRMDOzbC4a\nZmaWbcyiIWmOpOckvSbpkKQvp/hVknZLOpIeZ6a4JD0kaUDSfkkLS2P1pvZHJPWW4oskHUh9HpKk\n0fZhZmatkXOmcR5YFxF/AiwG1kqaD6wH9kREF7AnPQdYBnSlpQ/YCEUBAO4FPgncCNxbKgIbU9ta\nv6UpPtI+zMysBcYsGhFxKiJ+ktbfAl4DZgErgC2p2RbglrS+AtgahReAGZI6gZuB3RFxNiLeBHYD\nS9O2KyPi+Sh+e3brsLHq7cPMzFrgoq5pSJoLfAJ4EahExCkoCgtwTWo2CzhR6jaYYqPFB+vEGWUf\nZmbWAtnfCJf0YeBp4CsR8dt02aFu0zqxaCCeTVIfxfQWlUqFarV6Md3fc+bsOR7e1g/ADbM+2tAY\nU83Q0FDDr9dU5ZzbQ7vlPFH5ZhUNSR+iKBjbIuIHKXxaUmdEnEpTTGdSfBCYU+o+GziZ4j3D4tUU\nn12n/Wj7uEBEbAI2AXR3d0ejX6V/eFs/Gw4UL8nx2xsbY6pptz+1AM65XbRbzhOVb87dUwIeBV6L\niG+VNu0AandA9QL9pfjqdBfVYuBcmlraBSyRNDNdAF8C7Erb3pK0OO1r9bCx6u3DzMxaIOdM41PA\nF4ADkval2F8B3wSelLQG+BVwW9q2E1gODABvA3cARMRZSfcDL6d2X4+Is2n9LuAxYDrwbFoYZR9m\nZtYCYxaNiPhH6l93ALipTvsA1o4w1mZgc534XuD6OvE36u3DzMxaw98INzOzbC4aZmaWzUXDzMyy\nuWiYmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vm\nomFmZtlcNMzMLJuLhpmZZXPRMDOzbDm/Eb5Z0hlJB0uxJyTtS8vx2s/ASpor6Z9L275X6rNI0gFJ\nA5IeSr8HjqSrJO2WdCQ9zkxxpXYDkvZLWjj+6ZuZ2cXIOdN4DFhaDkTEn0fEgohYADwN/KC0+Wht\nW0R8qRTfCPQBXWmpjbke2BMRXcCe9BxgWaltX+pvZmYtNGbRiIgfA2frbUtnC/8NeHy0MSR1AldG\nxPPpN8S3ArekzSuALWl9y7D41ii8AMxI45iZWYs0e03j08DpiDhSis2T9Kqkf5D06RSbBQyW2gym\nGEAlIk4BpMdrSn1OjNDHzMxaoKPJ/qu48CzjFPCHEfGGpEXA30m6DlCdvjHG2Nl9JPVRTGFRqVSo\nVqtjHXddlemw7obzAA2PMdUMDQ21Ta41zrk9tFvOE5Vvw0VDUgfwX4FFtVhEvAO8k9ZfkXQU+COK\ns4TZpe6zgZNp/bSkzog4laafzqT4IDBnhD4XiIhNwCaA7u7u6OnpaSinh7f1s+FA8ZIcv72xMaaa\narVKo6/XVOWc20O75TxR+TYzPfWfgZ9HxHvTTpI+LmlaWr+W4iL2sTTt9Jakxek6yGqgP3XbAfSm\n9d5h8dXpLqrFwLnaNJaZmbVGzi23jwPPA38saVDSmrRpJe+/AP4ZYL+knwJPAV+KiNpF9LuAvwEG\ngKPAsyn+TeBzko4An0vPAXYCx1L7R4C/uPj0zMxsPI05PRURq0aI//c6sacpbsGt134vcH2d+BvA\nTXXiAawd6/jMzGzi+BvhZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOz\nbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOzbC4aZmaWLefnXjdL\nOiPpYCl2n6RfS9qXluWlbfdIGpB0WNLNpfjSFBuQtL4UnyfpRUlHJD0h6bIUvzw9H0jb545X0mZm\n1picM43HgKV14t+OiAVp2QkgaT7Fb4dfl/p8V9I0SdOA7wDLgPnAqtQW4ME0VhfwJlD7DfI1wJsR\n8e+Ab6d2ZmbWQmMWjYj4MXA2c7wVwPaIeCcifgkMADemZSAijkXE74HtwApJAj4LPJX6bwFuKY21\nJa0/BdyU2puZWYs0c03jbkn70/TVzBSbBZwotRlMsZHiHwN+ExHnh8UvGCttP5fam5lZi3Q02G8j\ncD8Q6XEDcCdQ70wgqF+cYpT2jLHtApL6gD6ASqVCtVod5dBHVpkO624o6lejY0w1Q0NDbZNrjXNu\nD+2W80Tl21DRiIjTtXVJjwA/TE8HgTmlprOBk2m9Xvx1YIakjnQ2UW5fG2tQUgfwUUaYJouITcAm\ngO7u7ujp6WkkLR7e1s+GA8VLcvz2xsaYaqrVKo2+XlOVc24P7ZbzROXb0PSUpM7S088DtTurdgAr\n051P84Au4CXgZaAr3Sl1GcXF8h0REcBzwK2pfy/QXxqrN63fCvx9am9mZi0y5pmGpMeBHuBqSYPA\nvUCPpAUU00XHgS8CRMQhSU8CPwPOA2sj4t00zt3ALmAasDkiDqVdfBXYLukbwKvAoyn+KPC3kgYo\nzjBWNp2tmZk1ZcyiERGr6oQfrROrtX8AeKBOfCews078GMXdVcPj/wLcNtbxmZnZxPE3ws3MLJuL\nhpmZZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOzbC4a\nZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzMLNuYRUPSZklnJB0sxf6HpJ9L2i/pGUkzUnyu\npH+WtC8t3yv1WSTpgKQBSQ9JUopfJWm3pCPpcWaKK7UbSPtZOP7pm5nZxcg503gMWDosthu4PiL+\nPfAL4J7StqMRsSAtXyrFNwJ9QFdaamOuB/ZERBewJz0HWFZq25f6m5lZC41ZNCLix8DZYbEfRcT5\n9PQFYPZoY0jqBK6MiOcjIoCtwC1p8wpgS1rfMiy+NQovADPSOGZm1iLjcU3jTuDZ0vN5kl6V9A+S\nPp1is4DBUpvBFAOoRMQpgPR4TanPiRH6mJlZC3Q001nS14DzwLYUOgX8YUS8IWkR8HeSrgNUp3uM\nNXxuH0l9FFNYVCoVqtVqxtG/X2U6rLuhOIFqdIypZmhoqG1yrXHO7aHdcp6ofBsuGpJ6gf8C3JSm\nnIiId4B30vorko4Cf0RxllCewpoNnEzrpyV1RsSpNP10JsUHgTkj9LlARGwCNgF0d3dHT09PQzk9\nvK2fDQeKl+T47Y2NMdVUq1Uafb2mKufcHtot54nKt6HpKUlLga8CfxYRb5fiH5c0La1fS3ER+1ia\ndnpL0uJ019RqoD912wH0pvXeYfHV6S6qxcC52jSWmZm1xphnGpIeB3qAqyUNAvdS3C11ObA73Tn7\nQrpT6jPA1yWdB94FvhQRtYvod1HciTWd4hpI7TrIN4EnJa0BfgXcluI7geXAAPA2cEcziZqZWfPG\nLBoRsapO+NER2j4NPD3Ctr3A9XXibwA31YkHsHas4zMzs4njb4SbmVk2Fw0zM8vmomFmZtlcNMzM\nLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOz\nbC4aZmaWzUXDzMyyuWiYmVm2rKIhabOkM5IOlmJXSdot6Uh6nJnikvSQpAFJ+yUtLPXpTe2PSOot\nxRdJOpD6PJR+R3zEfZiZWWvknmk8BiwdFlsP7ImILmBPeg6wDOhKSx+wEYoCQPH74p8EbgTuLRWB\njaltrd/SMfZhZmYtkFU0IuLHwNlh4RXAlrS+BbilFN8ahReAGZI6gZuB3RFxNiLeBHYDS9O2KyPi\n+fS74FuHjVVvH2Zm1gIdTfStRMQpgIg4JemaFJ8FnCi1G0yx0eKDdeKj7eMCkvoozlSoVCpUq9XG\nEpoO6244D9DwGFPN0NBQ2+Ra45zbQ7vlPFH5NlM0RqI6sWggni0iNgGbALq7u6Onp+diur/n4W39\nbDhQvCTHb29sjKmmWq3S6Os1VTnn9tBuOU9Uvs3cPXU6TS2RHs+k+CAwp9RuNnByjPjsOvHR9mFm\nZi3QTNHYAdTugOoF+kvx1ekuqsXAuTTFtAtYImlmugC+BNiVtr0laXG6a2r1sLHq7cPMzFoga3pK\n0uNAD3C1pEGKu6C+CTwpaQ3wK+C21HwnsBwYAN4G7gCIiLOS7gdeTu2+HhG1i+t3UdyhNR14Ni2M\nsg8zM2uBrKIREatG2HRTnbYBrB1hnM3A5jrxvcD1deJv1NuHmZm1hr8RbmZm2Vw0zMwsm4uGmZll\nc9EwM7NsLhpmZpbNRcPMzLK5aJiZWTYXDTMzy+aiYWZm2Vw0zMwsm4uGmZllc9EwM7NsLhpmZpbN\nRcPMzLK5aJiZWTYXDTMzy+aiYWZm2RouGpL+WNK+0vJbSV+RdJ+kX5fiy0t97pE0IOmwpJtL8aUp\nNiBpfSk+T9KLko5IekLSZY2namZmzWq4aETE4YhYEBELgEUUvwf+TNr87dq2iNgJIGk+sBK4DlgK\nfFfSNEnTgO8Ay4D5wKrUFuDBNFYX8CawptHjNTOz5o3X9NRNwNGI+KdR2qwAtkfEOxHxS2AAuDEt\nAxFxLCJ+D2wHVkgS8FngqdR/C3DLOB2vmZk1oGOcxlkJPF56frek1cBeYF1EvAnMAl4otRlMMYAT\nw+KfBD4G/CYiztdpfwFJfUAfQKVSoVqtNpREZTqsu6HYXaNjTDVDQ0Ntk2uNc24P7ZbzROXbdNFI\n1xn+DLgnhTYC9wORHjcAdwKq0z2of7YTo7R/fzBiE7AJoLu7O3p6evITKHl4Wz8bDhQvyfHbGxtj\nqqlWqzT6ek1Vzrk9tFvOE5XveJxpLAN+EhGnAWqPAJIeAX6Yng4Cc0r9ZgMn03q9+OvADEkd6Wyj\n3N7MzFpgPK5prKI0NSWps7Tt88DBtL4DWCnpcknzgC7gJeBloCvdKXUZxVTXjogI4Dng1tS/F+gf\nh+M1M7MGNXWmIelfA58DvlgK/7WkBRRTScdr2yLikKQngZ8B54G1EfFuGuduYBcwDdgcEYfSWF8F\ntkv6BvAq8Ggzx2tmZs1pqmhExNsUF6zLsS+M0v4B4IE68Z3AzjrxYxR3V5mZ2STgb4SbmVk2Fw0z\nM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyuWiYmVk2Fw0zM8vmomFmZtlcNMzM\nLJuLhpmZZXPRMDOzbC4aZmaWzUXDzMyyNV00JB2XdEDSPkl7U+wqSbslHUmPM1Nckh6SNCBpv6SF\npXF6U/sjknpL8UVp/IHUV80es5mZNWa8zjT+U0QsiIju9Hw9sCciuoA96TnAMorfBu8C+oCNUBQZ\n4F7gkxS/1HdvrdCkNn2lfkvH6ZjNzOwifVDTUyuALWl9C3BLKb41Ci8AMyR1AjcDuyPibES8CewG\nlqZtV0bE8xERwNbSWGZmNsHGo2gE8CNJr0jqS7FKRJwCSI/XpPgs4ESp72CKjRYfrBM3M7MW6BiH\nMT4VESclXQPslvTzUdrWux4RDcQvHLQoVn0AlUqFarU65kHXU5kO6244D9DwGFPN0NBQ2+Ra45zb\nQ7vlPFH5Nl00IuJkejwj6RmKaxKnJXVGxKk0xXQmNR8E5pS6zwZOpnjPsHg1xWfXaT/8GDYBmwC6\nu7ujp6dneJMsD2/rZ8OB4iU5fntjY0w11WqVRl+vqco5t4d2y3mi8m1qekrSFZI+UlsHlgAHgR1A\n7Q6oXqA/re8AVqe7qBYD59L01S5giaSZ6QL4EmBX2vaWpMXprqnVpbHMzGyCNXumUQGeSXfBdgD/\nKyL+j6SXgSclrQF+BdyW2u8ElgMDwNvAHQARcVbS/cDLqd3XI+JsWr8LeAyYDjybFjMza4GmikZE\nHAP+Q534G8BNdeIBrB1hrM3A5jrxvcD1zRynmZmND38j3MzMsrlomJlZNhcNMzPL5qJhZmbZXDTM\nzCybi4aZmWVz0TAzs2wuGmZmls1Fw8zMsrlomJlZNhcNMzPL5qJhZmbZXDTMzCybi4aZmWVz0TAz\ns2wuGmZmls1Fw8zMsjVcNCTNkfScpNckHZL05RS/T9KvJe1Ly/JSn3skDUg6LOnmUnxpig1IWl+K\nz5P0oqQjkp6QdFmjx2tmZs1r5kzjPLAuIv4EWAyslTQ/bft2RCxIy06AtG0lcB2wFPiupGmSpgHf\nAZYB84FVpXEeTGN1AW8Ca5o4XjMza1LDRSMiTkXET9L6W8BrwKxRuqwAtkfEOxHxS2AAuDEtAxFx\nLCJ+D2wHVkgS8FngqdR/C3BLo8drZmbNG5drGpLmAp8AXkyhuyXtl7RZ0swUmwWcKHUbTLGR4h8D\nfhMR54fFzcysRTqaHUDSh4Gnga9ExG8lbQTuByI9bgDuBFSne1C/cMUo7esdQx/QB1CpVKhWqxeZ\nRaEyHdbdUNSoRseYaoaGhtom1xrn3B7aLeeJyrepoiHpQxQFY1tE/AAgIk6Xtj8C/DA9HQTmlLrP\nBk6m9Xrx14EZkjrS2Ua5/QUiYhOwCaC7uzt6enoayufhbf1sOFC8JMdvb2yMqaZardLo6zVVOef2\n0G45T1S+zdw9JeBR4LWI+FYp3llq9nngYFrfAayUdLmkeUAX8BLwMtCV7pS6jOJi+Y6ICOA54NbU\nvxfob/R4zcysec2caXwK+AJwQNK+FPsrirufFlBMJR0HvggQEYckPQn8jOLOq7UR8S6ApLuBXcA0\nYHNEHErjfRXYLukbwKsURcrMzFqk4aIREf9I/esOO0fp8wDwQJ34znr9IuIYxd1VZmY2Cfgb4WZm\nls1Fw8zMsrlomJlZNhcNMzPL5qJhZmbZXDTMzCybi4aZmWVz0TAzs2wuGmZmls1Fw8zMsrlomJlZ\nNhcNMzPL5qJhZmbZXDTMzCybi4aZmWVz0TAzs2wuGmZmlm3SFw1JSyUdljQgaX2rj8fMrJ1N6qIh\naRrwHWAZMJ/i98fnt/aozMza16QuGhS/Dz4QEcci4vfAdmBFi4/JzKxtTfaiMQs4UXo+mGJmZtYC\nHa0+gDGoTize10jqA/rS0yFJhxvc39XA6wB6sMERpp73cm4jzrk9tFvOzeb7b3IaTfaiMQjMKT2f\nDZwc3igiNgGbmt2ZpL0R0d3sOFOJc24PzvnSN1H5TvbpqZeBLknzJF0GrAR2tPiYzMza1qQ+04iI\n85LuBnYB04DNEXGoxYdlZta2JnXRAIiIncDOCdpd01NcU5Bzbg/O+dI3Ifkq4n3Xlc3MzOqa7Nc0\nzMxsEnHRSKb6nyuRdFzSAUn7JO1Nsask7ZZ0JD3OTHFJeijlul/SwtI4van9EUm9pfiiNP5A6lvv\ndugPOsfNks5IOliKfeA5jrSPFuZ8n6Rfp/d6n6TlpW33pOM/LOnmUrzu5zvdZPJiyu2JdMMJki5P\nzwfS9rkTlO8cSc9Jek3SIUlfTvFL9n0eJefJ+T5HRNsvFBfZjwLXApcBPwXmt/q4LjKH48DVw2J/\nDaxP6+uBB9P6cuBZiu/BLAZeTPGrgGPpcWZan5m2vQT8aerzLLCsBTl+BlgIHJzIHEfaRwtzvg/4\nyzpt56fP7uXAvPSZnjba5xt4EliZ1r8H3JXW/wL4XlpfCTwxQfl2AgvT+keAX6S8Ltn3eZScJ+X7\nPKH/0U/WJX2AdpWe3wPc0+rjusgcjvP+onEY6EzrncDhtP59YNXwdsAq4Pul+PdTrBP4eSl+QbsJ\nznMuF/4D+oHnONI+WpjzSP+YXPC5pbjr8E9H+nynfzRfBzpS/L12tb5pvSO1Uwve737gc+3wPtfJ\neVK+z56eKlwKf64kgB9JekXFN+QBKhFxCiA9XpPiI+U7WnywTnwymIgcR9pHK92dpmM2l6ZRLjbn\njwG/iYjzw+IXjJW2n0vtJ0yaKvkE8CJt8j4Pyxkm4fvsolHI+nMlk9ynImIhxV8EXivpM6O0HSnf\ni41PZpdyjhuBfwssAE4BG1J8PHNu6esh6cPA08BXIuK3ozWtE5uS73OdnCfl++yiUcj6cyWTWUSc\nTI9ngGco/kLwaUmdAOnxTGo+Ur6jxWfXiU8GE5HjSPtoiYg4HRHvRsT/Ax6heK/h4nN+HZghqWNY\n/IKx0vaPAmfHP5v3k/Qhin88t0XED1L4kn6f6+U8Wd9nF43ClP5zJZKukPSR2jqwBDhIkUPtrpFe\nirlSUnx1uvNkMXAunY7vApZImplOhZdQzH2eAt6StDjdabK6NFarTUSOI+2jJWr/sCWfp3ivoTjO\nlemOmHlAF8VF37qf7ygmsp8Dbk39h79+tZxvBf4+tf9Apdf+UeC1iPhWadMl+z6PlPOkfZ9bcaFn\nMi4Ud2H8guLug6+1+ngu8tivpbhT4qfAodrxU8xN7gGOpMerUlwUP251FDgAdJfGuhMYSMsdpXh3\n+tAeBf4nrbko+jjFafr/pfg/pDUTkeNI+2hhzn+bctqf/qPvLLX/Wjr+w5TucBvp850+Oy+l1+J/\nA5en+B+k5wNp+7UTlO9/pJge2Q/sS8vyS/l9HiXnSfk++xvhZmaWzdNTZmaWzUXDzMyyuWiYmVk2\nFw0zM8vmomFmZtlcNMzMLJuLhpmZZXPRMDOzbP8fSg2vEyTNLAYAAAAASUVORK5CYII=\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"fig, ax = plt.subplots(1,1)\n",
"df['CIRCONFERENCEENCM'].hist(bins = 100)\n",
"plt.show()"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'boxes': [],\n",
" 'caps': [,\n",
" ],\n",
" 'fliers': [],\n",
" 'means': [],\n",
" 'medians': [],\n",
" 'whiskers': [,\n",
" ]}"
]
},
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAY0AAAD8CAYAAACLrvgBAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAEuRJREFUeJzt3WGMXPV57/Hvw+DUEVyCU5yIYnLN\nba1q6MqiyYog1S+yrQSGN6ZSIrFXLaswkqsoWRGpEqWdF0TJXalFalKwUiRXa2FX7dAobQQvSLkW\nHSl3JZKytBE23Uas0jRsQODIlBIik7V57ov9G82aZffvWQ+za74faTQzz/mfc555AT+f8z/nbGQm\nkiTVuGTYDUiSNg9DQ5JUzdCQJFUzNCRJ1QwNSVI1Q0OSVM3QkCRVMzQkSdUMDUlStUuH3cCFdtVV\nV+XOnTuH3YYkbSrPPPPMTzNz+1rjLrrQ2LlzJ7Ozs8NuQ5I2lYj4z5pxnp6SJFUzNCRJ1QwNSVI1\nQ0OSVM3QkCRVWzM0IuLaiOhGxFxEPBcRd5f6lyLiJxHx/fK6rWedP46I+Yj4QUTc0lPfW2rzEXFv\nT/26iPheRDwfEX8XER8o9V8q3+fL8p0X8sdL74VOp8PIyAiNRoORkRE6nc6wW5L6VnOkcRr4w8xs\nAjcBn4+I68uyr2XmDeX1OEBZdgfwG8Be4C8johERDeDrwK3A9cB4z3b+rGxrF/Aq0Cr1FvBqZv4a\n8LUyTto0Op0O7XabAwcOcOrUKQ4cOEC73TY4tGmtGRqZ+VJm/kv5/DowB1yzyir7gEcy883M/A9g\nHrixvOYz84eZ+QvgEWBfRATw28A3y/qHgdt7tnW4fP4m8DtlvLQpTE1NMT09zdjYGFu2bGFsbIzp\n6WmmpqaG3ZrUl/Oa0yinh34T+F4pfSEino2IQxGxrdSuAV7oWW2h1N6t/svAf2Xm6XPqy7ZVlr9W\nxp/b1/6ImI2I2RMnTpzPT5IGam5ujj179iyr7dmzh7m5uSF1JK1PdWhExOXA3wNfzMz/Bh4CfhW4\nAXgJ+POzQ1dYPfuor7at5YXMg5k5mpmj27eveRe89J5pNpvMzMwsq83MzNBsNofUkbQ+VaEREVtY\nCoy/ycx/AMjMlzPzTGa+BfwVS6efYOlI4dqe1XcAL65S/ylwZURcek592bbK8g8BJ8/nB0rD1G63\nabVadLtdFhcX6Xa7tFot2u32sFuT+rLms6fKHMI0MJeZX+2pX52ZL5WvvwscL58fA/42Ir4K/Aqw\nC/hnlo4adkXEdcBPWJos/9+ZmRHRBT7N0jzHBPBoz7YmgKfK8n/KzHccaUgb1fj4OACTk5PMzc3R\nbDaZmpp6uy5tNrHW/4MjYg/w/4BjwFul/CfAOEunphL4EfAHZ0MkItrAXSxdefXFzPx2qd8G/AXQ\nAA5l5lSp/y+WAuPDwL8Cv5eZb0bEVuCvWZpHOQnckZk/XK3f0dHR9IGFknR+IuKZzBxdc9zF9g93\nQ0OSzl9taHhHuCSpmqEhSapmaEiSqhkakqRqhoYkqZqhIUmqZmhIkqoZGpKkaoaGJKmaoSFJqmZo\nSJKqGRqSpGqGhiSpmqEhSapmaEiSqhkakqRqhoYkqZqhIUmqZmhIkqoZGpKkaoaGJKmaoSFJqmZo\nSJKqGRqSpGqGhiSpmqEhSapmaEiSqhkakqRqhoYkqZqhIUmqtmZoRMS1EdGNiLmIeC4i7i71D0fE\n0Yh4vrxvK/WIiAcjYj4ino2Ij/dsa6KMfz4iJnrqn4iIY2WdByMiVtuHJGk4ao40TgN/mJlN4Cbg\n8xFxPXAv8GRm7gKeLN8BbgV2ldd+4CFYCgDgPuCTwI3AfT0h8FAZe3a9vaX+bvuQJA3BmqGRmS9l\n5r+Uz68Dc8A1wD7gcBl2GLi9fN4HHMkl3wWujIirgVuAo5l5MjNfBY4Ce8uyKzLzqcxM4Mg521pp\nH5KkITivOY2I2An8JvA94KOZ+RIsBQvwkTLsGuCFntUWSm21+sIKdVbZhyRpCKpDIyIuB/4e+GJm\n/vdqQ1eoZR/1ahGxPyJmI2L2xIkT57OqJOk8VIVGRGxhKTD+JjP/oZRfLqeWKO+vlPoCcG3P6juA\nF9eo71ihvto+lsnMg5k5mpmj27dvr/lJkqQ+1Fw9FcA0MJeZX+1Z9Bhw9gqoCeDRnvqd5Sqqm4DX\nyqmlJ4CbI2JbmQC/GXiiLHs9Im4q+7rznG2ttA9J0hBcWjHmt4DfB45FxPdL7U+APwW+EREt4MfA\nZ8qyx4HbgHng58BnATLzZER8BXi6jPtyZp4snz8HPAx8EPh2ebHKPiRJQxBLFyxdPEZHR3N2dnbY\nbUjSphIRz2Tm6FrjvCNcklTN0JAkVTM0JEnVDA1JUjVDQ5JUzdCQJFUzNCRJ1QwNSVI1Q0OSVM3Q\nkCRVMzQkSdUMDUlSNUNDklTN0JAkVTM0JEnVDA1JUjVDQ5JUzdCQJFUzNCRJ1QwNSVI1Q0OSVM3Q\nkCRVMzQkSdUMDUlSNUNDklTN0JAkVTM0JEnVDA1JUjVDQ5JUzdCQJFUzNCRJ1dYMjYg4FBGvRMTx\nntqXIuInEfH98rqtZ9kfR8R8RPwgIm7pqe8ttfmIuLenfl1EfC8ino+Iv4uID5T6L5Xv82X5zgv1\noyVJ/ak50ngY2LtC/WuZeUN5PQ4QEdcDdwC/Udb5y4hoREQD+DpwK3A9MF7GAvxZ2dYu4FWgVeot\n4NXM/DXga2WcJGmI1gyNzPwOcLJye/uARzLzzcz8D2AeuLG85jPzh5n5C+ARYF9EBPDbwDfL+oeB\n23u2dbh8/ibwO2W8JGlI1jOn8YWIeLacvtpWatcAL/SMWSi1d6v/MvBfmXn6nPqybZXlr5Xx7xAR\n+yNiNiJmT5w4sY6fJElaTb+h8RDwq8ANwEvAn5f6SkcC2Ud9tW29s5h5MDNHM3N0+/btq/UtSVqH\nvkIjM1/OzDOZ+RbwVyydfoKlI4Vre4buAF5cpf5T4MqIuPSc+rJtleUfov40mSRpAPoKjYi4uufr\n7wJnr6x6DLijXPl0HbAL+GfgaWBXuVLqAyxNlj+WmQl0gU+X9SeAR3u2NVE+fxr4pzJekjQkl641\nICI6wKeAqyJiAbgP+FRE3MDS6aIfAX8AkJnPRcQ3gH8DTgOfz8wzZTtfAJ4AGsChzHyu7OKPgEci\n4v8A/wpMl/o08NcRMc/SEcYd6/61kqR1iYvtH++jo6M5Ozs77DYkaVOJiGcyc3Stcd4RLkmqZmhI\nkqoZGpKkaoaGJKmaoSFJqmZoSJKqGRqSpGqGhiSpmqEhSapmaEiSqhkakqRqhoYkqZqhIUmqZmhI\nkqoZGpKkaoaGNGCdToeRkREajQYjIyN0Op1htyT1bc2/3Cepf51Oh3a7zfT0NHv27GFmZoZWqwXA\n+Pj4kLuTzp9/uU8aoJGREQ4cOMDY2NjbtW63y+TkJMePHx9iZ9JytX+5z9CQBqjRaHDq1Cm2bNny\ndm1xcZGtW7dy5syZIXYmLeefe5U2gGazyczMzLLazMwMzWZzSB1J62NoSAPUbrdptVp0u10WFxfp\ndru0Wi3a7fawW5P64kS4NEBnJ7snJyeZm5uj2WwyNTXlJLg2Lec0JEnOaUiSLjxDQ5JUzdCQJFUz\nNCRJ1QwNSVI1Q0OSVM3QkCRVWzM0IuJQRLwSEcd7ah+OiKMR8Xx531bqEREPRsR8RDwbER/vWWei\njH8+IiZ66p+IiGNlnQcjIlbbhyRpeGqONB4G9p5Tuxd4MjN3AU+W7wC3ArvKaz/wECwFAHAf8Eng\nRuC+nhB4qIw9u97eNfYhSRqSNUMjM78DnDynvA84XD4fBm7vqR/JJd8FroyIq4FbgKOZeTIzXwWO\nAnvLsisy86lcujX9yDnbWmkfkqQh6XdO46OZ+RJAef9IqV8DvNAzbqHUVqsvrFBfbR+SpCG50BPh\nsUIt+6if304j9kfEbETMnjhx4nxXlyRV6jc0Xi6nlijvr5T6AnBtz7gdwItr1HesUF9tH++QmQcz\nczQzR7dv397nT5IkraXf0HgMOHsF1ATwaE/9znIV1U3Aa+XU0hPAzRGxrUyA3ww8UZa9HhE3laum\n7jxnWyvtQ5I0JGv+PY2I6ACfAq6KiAWWroL6U+AbEdECfgx8pgx/HLgNmAd+DnwWIDNPRsRXgKfL\nuC9n5tnJ9c+xdIXWB4Fvlxer7EOSNCT+PQ1Jkn9PQ5J04RkakqRqhoYkqZqhIUmqZmhIkqoZGpKk\naoaGJKmaoSFJqmZoSAPW6XQYGRmh0WgwMjJCp9MZdktS39Z8jIik/nU6HdrtNtPT0+zZs4eZmRla\nrRYA4+PjQ+5OOn8+RkQaoJGREQ4cOMDY2NjbtW63y+TkJMePH19lTem9VfsYEUNDGqBGo8GpU6fY\nsmXL27XFxUW2bt3KmTNnhtiZtJzPnpI2gGazyczMzLLazMwMzWZzSB1J62NoSAPUbrdptVp0u10W\nFxfpdru0Wi3a7fawW5P64kS4NEBnJ7snJyeZm5uj2WwyNTXlJLg2Lec0JEnOaUiSLjxDQ5JUzdCQ\nJFUzNKQB8zEiuph49ZQ0QD5GRBcbr56SBsjHiGiz8DEi0gbgY0S0WXjJrbQB+BgRXWwMDWmAfIyI\nLjZOhEsD5GNEdLFxTkOS5JyGJOnCMzQkSdUMDUlSNUNDklRtXaERET+KiGMR8f2ImC21D0fE0Yh4\nvrxvK/WIiAcjYj4ino2Ij/dsZ6KMfz4iJnrqnyjbny/rxnr6lSStz4U40hjLzBt6Zt3vBZ7MzF3A\nk+U7wK3ArvLaDzwESyED3Ad8ErgRuO9s0JQx+3vW23sB+pUk9WkQp6f2AYfL58PA7T31I7nku8CV\nEXE1cAtwNDNPZuarwFFgb1l2RWY+lUvXBR/p2ZYkaQjWGxoJ/N+IeCYi9pfaRzPzJYDy/pFSvwZ4\noWfdhVJbrb6wQv0dImJ/RMxGxOyJEyfW+ZMkSe9mvXeE/1ZmvhgRHwGORsS/rzJ2pfmI7KP+zmLm\nQeAgLN3ct3rLkqR+retIIzNfLO+vAN9iaU7i5XJqifL+Shm+AFzbs/oO4MU16jtWqEuShqTv0IiI\nyyLif5z9DNwMHAceA85eATUBPFo+PwbcWa6iugl4rZy+egK4OSK2lQnwm4EnyrLXI+KmctXUnT3b\nkiQNwXpOT30U+Fa5CvZS4G8z8x8j4mngGxHRAn4MfKaMfxy4DZgHfg58FiAzT0bEV4Cny7gvZ+bJ\n8vlzwMPAB4Fvl5ckaUh8YKEkyQcWSpIuPENDklTN0JAkVTM0JEnVDA1JUjVDQ5JUzdCQJFUzNKQB\n63Q6jIyM0Gg0GBkZodPpDLslqW/rfWChpFV0Oh3a7TbT09Ps2bOHmZkZWq0WAOPj40PuTjp/3hEu\nDdDIyAgHDhxgbGzs7Vq322VycpLjx48PsTNpudo7wg0NaYAajQanTp1iy5Ytb9cWFxfZunUrZ86c\nGWJn0nI+RkTaAJrNJjMzM8tqMzMzNJvNIXUkrY+hIQ1Qu92m1WrR7XZZXFyk2+3SarVot9vDbk3q\nixPh0gCdneyenJxkbm6OZrPJ1NSUk+DatJzTkCQ5pyFtFN6noYuJoSENUKfT4e677+aNN94gM3nj\njTe4++67DQ5tWoaGNED33HMPjUaDQ4cO8eabb3Lo0CEajQb33HPPsFuT+mJoSAO0sLDAkSNHGBsb\nY8uWLYyNjXHkyBEWFhaG3ZrUF0NDklTN0JAGaMeOHUxMTCy7T2NiYoIdO3YMuzWpL4aGNED3338/\np0+f5q677mLr1q3cddddnD59mvvvv3/YrUl9MTSkARofH+eBBx7gsssuA+Cyyy7jgQce8OY+bVre\n3CdJ8uY+aaPYvXs3EfH2a/fu3cNuSeqboSEN0O7duzl27BiXXLL0n9oll1zCsWPHDA5tWoaGNEDH\njh0D4K233lr2frYubTaGhvQeuPzyy4kILr/88mG3Iq2Lj0aX3gM/+9nPlr1Lm5VHGpKkahs+NCJi\nb0T8ICLmI+LeYfcjSe9nGzo0IqIBfB24FbgeGI+I64fblSS9f23o0ABuBOYz84eZ+QvgEWDfkHuS\npPetjR4a1wAv9HxfKDVpU9m2bduyd2mz2uhXT8UKtXc89yQi9gP7AT72sY8NuiddjL70oYFsNu+7\nonw6A1zR8z64ffKl1wazXYmNHxoLwLU933cAL547KDMPAgdh6dlT701ruqgM6H+0ESv9u2fJxfbc\nN70/bPTTU08DuyLiuoj4AHAH8NiQe5Kk960NfaSRmacj4gvAE0ADOJSZzw25LalaZq54tOFRhjar\nDR0aAJn5OPD4sPuQ+mVA6GKy0U9PSZI2EENDklTN0JAkVTM0JEnVDA1JUrW42K7siIgTwH8Ouw9p\nBVcBPx12E9K7+J+ZuX2tQRddaEgbVUTMZubosPuQ1sPTU5KkaoaGJKmaoSG9dw4OuwFpvZzTkCRV\n80hDklTN0JAGLCIORcQrEXF82L1I62VoSIP3MLB32E1IF4KhIQ1YZn4HODnsPqQLwdCQJFUzNCRJ\n1QwNSVI1Q0OSVM3QkAYsIjrAU8CvR8RCRLSG3ZPUL+8IlyRV80hDklTN0JAkVTM0JEnVDA1JUjVD\nQ5JUzdCQJFUzNCRJ1QwNSVK1/w+CUkS5aYfYzAAAAABJRU5ErkJggg==\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"\n",
"plt.boxplot(df['CIRCONFERENCEENCM'])"
]
},
{
"cell_type": "code",
"execution_count": 33,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import numpy as np\n",
"\n",
"\n",
"df['diametre'] = df['CIRCONFERENCEENCM'].apply( lambda c : c /np.pi )\n",
"\n",
"df['diametre'] = df['CIRCONFERENCEENCM'] / np.pi"
]
},
{
"cell_type": "code",
"execution_count": 37,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"136.4518087697526"
]
},
"execution_count": 37,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.diametre.describe()\n",
"\n",
"np.percentile(df.diametre, 99.9)"
]
},
{
"cell_type": "code",
"execution_count": 40,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"condition = (df['HAUTEUR (m)'] > 0 ) & (df['HAUTEUR (m)'] < 100 ) & (df['diametre'] < 150 )\n",
"\n",
"df[condition].shape\n",
"\n",
"df = df[condition]"
]
},
{
"cell_type": "code",
"execution_count": 41,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
""
]
},
"execution_count": 41,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYcAAAD8CAYAAACcjGjIAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAFfZJREFUeJzt3X+w3XWd3/HnyyDqktGgrHfYJG3Y\nMdOKMoLegbS2nRu0EMBp2BmdwrAaXHayswNVO3TW6MwOrkqLM/5omVVmsktqaK2RQS0ZjEsZljvW\nmQUBsYRIHW6RSoDC2gQkutXGvvvH+UTP5ntu7rm/uMm5z8fMmfP9vs/n+/1+Pvne3Nf9/jjnpKqQ\nJKnfy5a6A5Kk44/hIEnqMBwkSR2GgySpw3CQJHUYDpKkjhnDIckrk3wnyX9Lsi/Jn7T6GUnuS/JY\nkq8kObnVX9Hmp9rr6/rW9ZFW/0GSC/vqm1ptKsm2hR+mJGk2hjly+DlwflW9BTgb2JRkA/Ap4HNV\ntR44CFzV2l8FHKyqNwCfa+1IciZwGfAmYBPwhSQrkqwAPg9cBJwJXN7aSpKWyIzhUD2H2uzL26OA\n84HbWn0ncGmb3tzmaa+/I0lafVdV/byqfghMAee2x1RVPV5VvwB2tbaSpCVy0jCN2l/3DwJvoPdX\n/v8Anq+qw63JfmB1m14NPAlQVYeTvAC8rtXv7Vtt/zJPHlU/b6Y+nXbaabVu3bphug/AT3/6U045\n5ZSh248Kx728OO7lZS7jfvDBB39cVb85U7uhwqGqfgmcnWQV8HXgjYOatedM89p09UFHLwM/0yPJ\nVmArwNjYGJ/+9Kdn6PmvHTp0iJUrVw7dflQ47uXFcS8vcxn3xo0b/+cw7YYKhyOq6vkkk8AGYFWS\nk9rRwxrg6dZsP7AW2J/kJOA1wIG++hH9y0xXP3r724HtAOPj4zUxMTF03ycnJ5lN+1HhuJcXx728\nLOa4h7lb6TfbEQNJXgW8E3gUuAd4d2u2Bbi9Te9u87TX/7J6n+63G7is3c10BrAe+A5wP7C+3f10\nMr2L1rsXYnCSpLkZ5sjhdGBnu+7wMuDWqrojyfeBXUk+CTwE3Nza3wz8hyRT9I4YLgOoqn1JbgW+\nDxwGrm6nq0hyDXAnsALYUVX7FmyEkqRZmzEcquph4JwB9cfp3Wl0dP3/AO+ZZl3XA9cPqO8B9gzR\nX0nSS8B3SEuSOgwHSVKH4SBJ6jAcJEkdhoMkqWNWb4LT7K3b9o1fTT9xwyVL2BNJGp5HDpKkDsNB\nktRhOEiSOgwHSVKH4SBJ6jAcJEkdhoMkqcNwkCR1GA6SpA7DQZLUYThIkjoMB0lSh+EgSeowHCRJ\nHYaDJKnD73MYgt/JIGm58chBktRhOEiSOgwHSVKH4SBJ6jAcJEkdM4ZDkrVJ7knyaJJ9ST7Y6h9L\n8lSS77XHxX3LfCTJVJIfJLmwr76p1aaSbOurn5HkviSPJflKkpMXeqCSpOENc+RwGLi2qt4IbACu\nTnJme+1zVXV2e+wBaK9dBrwJ2AR8IcmKJCuAzwMXAWcCl/et51NtXeuBg8BVCzQ+SdIczBgOVfVM\nVX23Tb8IPAqsPsYim4FdVfXzqvohMAWc2x5TVfV4Vf0C2AVsThLgfOC2tvxO4NK5DkiSNH+zuuaQ\nZB1wDnBfK12T5OEkO5Kc2mqrgSf7FtvfatPVXwc8X1WHj6pLkpbI0O+QTrIS+Crwoar6SZKbgE8A\n1Z4/A/wekAGLF4ODqI7RflAftgJbAcbGxpicnBy2+xw6dGhW7ftde9bhX03Pdh3zWXYhzGfcJzLH\nvbw47oU3VDgkeTm9YPhSVX0NoKqe7Xv9z4A72ux+YG3f4muAp9v0oPqPgVVJTmpHD/3t/5aq2g5s\nBxgfH6+JiYlhug/0fjHPpn2/K/s/PuOK2a1jPssuhPmM+0TmuJcXx73whrlbKcDNwKNV9dm++ul9\nzX4HeKRN7wYuS/KKJGcA64HvAPcD69udSSfTu2i9u6oKuAd4d1t+C3D7/IYlSZqPYY4c3g68F9ib\n5Hut9lF6dxudTe8U0BPAHwBU1b4ktwLfp3en09VV9UuAJNcAdwIrgB1Vta+t78PAriSfBB6iF0aS\npCUyYzhU1bcZfF1gzzGWuR64fkB9z6DlqupxenczSZKOA75DWpLUYThIkjoMB0lSh+EgSeowHCRJ\nHYaDJKnDcJAkdRgOkqQOw0GS1GE4SJI6DAdJUofhIEnqMBwkSR2GgySpw3CQJHUYDpKkDsNBktRh\nOEiSOgwHSVKH4SBJ6jAcJEkdhoMkqcNwkCR1GA6SpA7DQZLUYThIkjoMB0lSh+EgSeqYMRySrE1y\nT5JHk+xL8sFWf22Su5I81p5PbfUkuTHJVJKHk7y1b11bWvvHkmzpq78tyd62zI1JshiDlSQNZ5gj\nh8PAtVX1RmADcHWSM4FtwN1VtR64u80DXASsb4+twE3QCxPgOuA84FzguiOB0tps7Vtu0/yHJkma\nqxnDoaqeqarvtukXgUeB1cBmYGdrthO4tE1vBm6pnnuBVUlOBy4E7qqqA1V1ELgL2NRee3VV/VVV\nFXBL37okSUvgpNk0TrIOOAe4DxirqmegFyBJXt+arQae7Ftsf6sdq75/QH3Q9rfSO8JgbGyMycnJ\noft+6NChWbXvd+1Zh381Pdt1zGfZhTCfcZ/IHPfy4rgX3tDhkGQl8FXgQ1X1k2NcFhj0Qs2h3i1W\nbQe2A4yPj9fExMQMvf61yclJZtO+35XbvvGr6SeumN065rPsQpjPuE9kjnt5cdwLb6i7lZK8nF4w\nfKmqvtbKz7ZTQrTn51p9P7C2b/E1wNMz1NcMqEuSlsgwdysFuBl4tKo+2/fSbuDIHUdbgNv76u9r\ndy1tAF5op5/uBC5Icmq7EH0BcGd77cUkG9q23te3LknSEhjmtNLbgfcCe5N8r9U+CtwA3JrkKuBH\nwHvaa3uAi4Ep4GfA+wGq6kCSTwD3t3Yfr6oDbfoPgS8CrwK+2R6SpCUyYzhU1bcZfF0A4B0D2hdw\n9TTr2gHsGFB/AHjzTH2RJL00fIe0JKnDcJAkdRgOkqQOw0GS1GE4SJI6DAdJUofhIEnqMBwkSR2G\ngySpw3CQJHUYDpKkDsNBktRhOEiSOgwHSVLHrL5DWi+9df1fM3rDJUvYE0nLiUcOkqQOw0GS1GE4\nSJI6DAdJUofhIEnqMBwkSR2GgySpw3CQJHUYDpKkDsNBktRhOEiSOgwHSVLHjOGQZEeS55I80lf7\nWJKnknyvPS7ue+0jSaaS/CDJhX31Ta02lWRbX/2MJPcleSzJV5KcvJADlCTN3jBHDl8ENg2of66q\nzm6PPQBJzgQuA97UlvlCkhVJVgCfBy4CzgQub20BPtXWtR44CFw1nwFJkuZvxnCoqm8BB4Zc32Zg\nV1X9vKp+CEwB57bHVFU9XlW/AHYBm5MEOB+4rS2/E7h0lmOQJC2wVNXMjZJ1wB1V9eY2/zHgSuAn\nwAPAtVV1MMmfAvdW1X9s7W4GvtlWs6mqfr/V3wucB3ystX9Dq68FvnlkOwP6sRXYCjA2Nva2Xbt2\nDT3QQ4cOsXLlyqHb99v71Au/mj5r9WtesmUXYvn5jPtE5riXF8c9vI0bNz5YVeMztZvrl/3cBHwC\nqPb8GeD3gAxoWww+QqljtB+oqrYD2wHGx8drYmJi6A5PTk4ym/b9ruz/wp0rZreO+Sy7EMvPZ9wn\nMse9vDjuhTencKiqZ49MJ/kz4I42ux9Y29d0DfB0mx5U/zGwKslJVXX4qPaSpCUyp1tZk5zeN/s7\nwJE7mXYDlyV5RZIzgPXAd4D7gfXtzqST6V203l29c1r3AO9uy28Bbp9LnyRJC2fGI4ckXwYmgNOS\n7AeuAyaSnE3vFNATwB8AVNW+JLcC3wcOA1dX1S/beq4B7gRWADuqal/bxIeBXUk+CTwE3Lxgo5Mk\nzcmM4VBVlw8oT/sLvKquB64fUN8D7BlQf5ze3UySpOOE75CWJHUYDpKkDsNBktRhOEiSOub6Jjgd\nZV3/m9VuuGQJeyJJ8+eRgySpw3CQJHUYDpKkDsNBktRhOEiSOgwHSVKH4SBJ6jAcJEkdhoMkqcNw\nkCR1GA6SpA7DQZLUYThIkjoMB0lSh+EgSeowHCRJHYaDJKnDcJAkdfg1oUvErxWVdDzzyEGS1GE4\nSJI6PK00S54OkrQczHjkkGRHkueSPNJXe22Su5I81p5PbfUkuTHJVJKHk7y1b5ktrf1jSbb01d+W\nZG9b5sYkWehBSpJmZ5jTSl8ENh1V2wbcXVXrgbvbPMBFwPr22ArcBL0wAa4DzgPOBa47Eiitzda+\n5Y7eliTpJTZjOFTVt4ADR5U3Azvb9E7g0r76LdVzL7AqyenAhcBdVXWgqg4CdwGb2muvrqq/qqoC\nbulblyRpiaT3O3mGRsk64I6qenObf76qVvW9frCqTk1yB3BDVX271e8GPgxMAK+sqk+2+h8DfwNM\ntvbvbPV/DHy4qt41TT+20jvKYGxs7G27du0aeqCHDh1i5cqVQ7fvt/epFwbWz1r9moFt5lM/1raP\n1W468xn3icxxLy+Oe3gbN258sKrGZ2q30BekB10vqDnUB6qq7cB2gPHx8ZqYmBi6Y5OTk8ymfb8r\n+y5C93viiomBbeZTP9a2j9VuOvMZ94nMcS8vjnvhzfVW1mfbKSHa83Otvh9Y29duDfD0DPU1A+qS\npCU013DYDRy542gLcHtf/X3trqUNwAtV9QxwJ3BBklPbhegLgDvbay8m2dDuUnpf37okSUtkxtNK\nSb5M75rBaUn207vr6Abg1iRXAT8C3tOa7wEuBqaAnwHvB6iqA0k+Adzf2n28qo5c5P5DendEvQr4\nZntIkpbQjOFQVZdP89I7BrQt4Opp1rMD2DGg/gDw5pn6IUl66fjxGZKkDsNBktRhOEiSOgwHSVKH\n4SBJ6jAcJEkdhoMkqcNwkCR1GA6SpA7DQZLUYThIkjoMB0lSh+EgSeowHEbYum3fYO9TL7Bumm+y\nk6TpGA6SpA7DQZLUYThIkjoMB0lSx4xfE6rpeaFX0qjyyEGS1GE4SJI6DAdJUofhIEnqMBwkSR2G\ngySpw3CQJHUYDpKkjnmFQ5InkuxN8r0kD7Taa5PcleSx9nxqqyfJjUmmkjyc5K1969nS2j+WZMv8\nhiRJmq+FOHLYWFVnV9V4m98G3F1V64G72zzARcD69tgK3AS9MAGuA84DzgWuOxIokqSlsRinlTYD\nO9v0TuDSvvot1XMvsCrJ6cCFwF1VdaCqDgJ3AZsWoV+SpCHNNxwK+C9JHkyytdXGquoZgPb8+lZf\nDTzZt+z+VpuuLklaIqmquS+c/FZVPZ3k9fT+4v8XwO6qWtXX5mBVnZrkG8C/qapvt/rdwB8B5wOv\nqKpPtvofAz+rqs8M2N5WeqekGBsbe9uuXbuG7uuhQ4dYuXLlnMa596kXZtX+rNWvGbjsMPVjbftY\n7aZbduxV8OzfzH7ZE9189veJzHEvL3MZ98aNGx/suwwwrXl9KmtVPd2en0vydXrXDJ5NcnpVPdNO\nGz3Xmu8H1vYtvgZ4utUnjqpPTrO97cB2gPHx8ZqYmBjUbKDJyUlm0/5vf+Lq7P6Znrji19u5sm89\nw9SPNmy76Za99qzDfGbvSbNe9kQ32/09Khz38rKY455zOCQ5BXhZVb3Ypi8APg7sBrYAN7Tn29si\nu4Frkuyid/H5hRYgdwL/uu8i9AXAR+bar+OBH+Ut6UQ3nyOHMeDrSY6s5z9V1V8kuR+4NclVwI+A\n97T2e4CLgSngZ8D7AarqQJJPAPe3dh+vqgPz6JckaZ7mHA5V9TjwlgH1/w28Y0C9gKunWdcOYMdc\n+yJJWli+Q1qS1OHXhI6A/mscT9xwyRL2RNKoMByOM17MlnQ88LSSJKnDcJAkdRgOkqQOw0GS1OEF\n6ROIdyVJeql45CBJ6vDIoc9i30Y63fq9fVXS8cYjB0lSh+EgSeowHCRJHYaDJKnDcJAkdRgOkqQO\nb2XVQL7hTlrePHKQJHV45HCC8o1zkhaTRw6SpI5lf+TgX+CS1OWRgySpw3CQJHUs+9NKy5G3qUqa\niUcOkqQOw0GS1GE4SJI6jptwSLIpyQ+STCXZttT9kaTl7Li4IJ1kBfB54J8C+4H7k+yuqu8vxvZG\n+b0Nozw2SS+d4yIcgHOBqap6HCDJLmAzsCjhoF+bT5hMd9eTd0NJJ77jJRxWA0/2ze8Hzluivoyk\nhQqBxVi/NFdHfu6uPeswE0vblZFzvIRDBtSq0yjZCmxts4eS/GAW2zgN+PEc+nZC+8ASjzufWqot\nL8/9zTId9wfgtA/87vIbN3Pb3393mEbHSzjsB9b2za8Bnj66UVVtB7bPZQNJHqiq8bl178TluJcX\nx728LOa4j5e7le4H1ic5I8nJwGXA7iXukyQtW8fFkUNVHU5yDXAnsALYUVX7lrhbkrRsHRfhAFBV\ne4A9i7iJOZ2OGgGOe3lx3MvLoo07VZ3rvpKkZe54ueYgSTqOjHw4LJeP5UiyNsk9SR5Nsi/JB1v9\ntUnuSvJYez51qfu6GJKsSPJQkjva/BlJ7mvj/kq70WHkJFmV5LYk/73t+3+wHPZ5kn/Zfs4fSfLl\nJK8cxX2eZEeS55I80lcbuH/Tc2P7XfdwkrfOZ9sjHQ59H8txEXAmcHmSM5e2V4vmMHBtVb0R2ABc\n3ca6Dbi7qtYDd7f5UfRB4NG++U8Bn2vjPghctSS9Wnz/DviLqvr7wFvo/RuM9D5Pshr4ADBeVW+m\ndxPLZYzmPv8isOmo2nT79yJgfXtsBW6az4ZHOhzo+1iOqvoFcORjOUZOVT1TVd9t0y/S+yWxmt54\nd7ZmO4FLl6aHiyfJGuAS4M/bfIDzgdtak1Ed96uBfwLcDFBVv6iq51kG+5zezTSvSnIS8BvAM4zg\nPq+qbwEHjipPt383A7dUz73AqiSnz3Xbox4Ogz6WY/US9eUlk2QdcA5wHzBWVc9AL0CA1y9dzxbN\nvwX+CPh/bf51wPNVdbjNj+p+/23gr4F/306p/XmSUxjxfV5VTwGfBn5ELxReAB5keexzmH7/Lujv\nu1EPh6E+lmOUJFkJfBX4UFX9ZKn7s9iSvAt4rqoe7C8PaDqK+/0k4K3ATVV1DvBTRuwU0iDtHPtm\n4Azgt4BT6J1SOdoo7vNjWdCf+1EPh6E+lmNUJHk5vWD4UlV9rZWfPXJo2Z6fW6r+LZK3A/8syRP0\nThueT+9IYlU75QCju9/3A/ur6r42fxu9sBj1ff5O4IdV9ddV9X+BrwH/kOWxz2H6/bugv+9GPRyW\nzcdytPPsNwOPVtVn+17aDWxp01uA21/qvi2mqvpIVa2pqnX09u9fVtUVwD3Au1uzkRs3QFX9L+DJ\nJH+vld5B72PuR3qf0zudtCHJb7Sf+yPjHvl93ky3f3cD72t3LW0AXjhy+mkuRv5NcEkupveX5JGP\n5bh+ibu0KJL8I+C/Anv59bn3j9K77nAr8Hfo/ad6T1UdfYFrJCSZAP5VVb0ryW/TO5J4LfAQ8LtV\n9fOl7N9iSHI2vQvxJwOPA++n90ffSO/zJH8C/HN6d+k9BPw+vfPrI7XPk3wZmKD36avPAtcB/5kB\n+7cF5Z/Su7vpZ8D7q+qBOW971MNBkjR7o35aSZI0B4aDJKnDcJAkdRgOkqQOw0GS1GE4SJI6DAdJ\nUofhIEnq+P94qqJykbTtgQAAAABJRU5ErkJggg==\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"df['HAUTEUR (m)'].hist(bins = 100)"
]
},
{
"cell_type": "code",
"execution_count": 42,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
""
]
},
"execution_count": 42,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYAAAAD8CAYAAAB+UHOxAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAE7hJREFUeJzt3X+s3XV9x/Hne1RA6KRFtOvaZq2z\nURGmwg0/dFluwfFLQ1kiSQ3R4lj6D1NmWLSMODaFDDMVMZlsjbChI1asbDSAMlK4S/yDihWlQGVU\nINCCoKF0K6iz7r0/zufWw/Vczrn3nnvOt/fzfCQ3Pd/P9/M95/393p6+zufz/Z5vIzORJNXnt4Zd\ngCRpOAwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqXmDbuAV3LMMcfk8uXLp739\niy++yJFHHtm/gvqs6fWBNfZD0+sDa+yHJtW3bdu2n2bm67p2zMzG/px44ok5E/fcc8+Mtp9tTa8v\n0xr7oen1ZVpjPzSpPuC72cO/sU4BSVKlDABJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkipl\nAEhSpRp9K4hBW77+9gOPn7j6PUOsRJJmnyMASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIq\nZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVIG\ngCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJleopACLioxHxUEQ8GBFfjYjDI2JFRGyNiEcj\n4msRcWjpe1hZ3lnWL297nstK+yMRcebs7JIkqRddAyAilgAfAUYy8zjgEGAN8GngmsxcCewBLiqb\nXATsycw3AteUfkTEsWW7twJnAV+MiEP6uzuSpF71OgU0D3h1RMwDjgCeAU4DNpX1NwLnlceryzJl\n/ekREaV9Y2b+IjMfB3YCJ818FyRJ0xGZ2b1TxCXAVcDPgP8ALgHuLZ/yiYhlwDcz87iIeBA4KzN3\nlXU/Ak4G/qZs86+l/fqyzaYJr7UOWAewaNGiEzdu3Djtndu3bx/z58/vuf/23XsPPD5+yVHTft1e\nTbW+YbDGmWt6fWCN/dCk+latWrUtM0e69ZvXrUNELKT16X0F8ALwdeDsDl3HkyQmWTdZ+8sbMjcA\nGwBGRkZydHS0W4mTGhsbYyrbX7j+9gOPn7hg+q/bq6nWNwzWOHNNrw+ssR+aXl8nvUwBvRt4PDN/\nkpm/BG4B3gksKFNCAEuBp8vjXcAygLL+KOD59vYO20iSBqyXAHgSOCUijihz+acDDwP3AO8rfdYC\nt5bHm8syZf3d2Zpn2gysKVcJrQBWAt/pz25Ikqaq6xRQZm6NiE3A94D9wP20pmhuBzZGxJWl7fqy\nyfXAVyJiJ61P/mvK8zwUETfTCo/9wMWZ+as+748kqUddAwAgM68ArpjQ/BgdruLJzJ8D50/yPFfR\nOpksSRoyvwksSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVI93QpC\ns2t5+22or37PECuRVBNHAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkD\nQJIqZQBIUqUMAEmqlDeDGyBv+iapSRwBSFKlDABJqpRTQAcJp48k9ZsjAEmqlAEgSZUyACSpUp4D\nmAXO10s6GDgCkKRKOQKYAT/pSzqYOQKQpEoZAJJUqZ4CICIWRMSmiPhhROyIiFMj4uiIuCsiHi1/\nLix9IyK+EBE7I+KBiDih7XnWlv6PRsTa2dopSVJ3vY4ArgW+lZlvBt4G7ADWA1sycyWwpSwDnA2s\nLD/rgOsAIuJo4ArgZOAk4Irx0JAkDV7XAIiI1wB/BFwPkJn/m5kvAKuBG0u3G4HzyuPVwJez5V5g\nQUQsBs4E7srM5zNzD3AXcFZf90aS1LPIzFfuEPF2YAPwMK1P/9uAS4Ddmbmgrd+ezFwYEbcBV2fm\nt0v7FuDjwChweGZeWdo/AfwsMz8z4fXW0Ro5sGjRohM3btw47Z3bt28f8+fP77n/9t17Dzw+fslR\n0+7fa/t4fb287lRr65epHsNhaHqNTa8PrLEfmlTfqlWrtmXmSLd+vVwGOg84AfhwZm6NiGv59XRP\nJ9GhLV+h/eUNmRtoBQ4jIyM5OjraQ4mdjY2NMZXtL2y/rPOC7ttN1r/X9vH6enndqdbWL1M9hsPQ\n9BqbXh9YYz80vb5OegmAXcCuzNxaljfRCoBnI2JxZj5Tpniea+u/rG37pcDTpX10QvvY9EsX+F0E\nSdPX9RxAZv4YeCoi3lSaTqc1HbQZGL+SZy1wa3m8GfhguRroFGBvZj4D3AmcERELy8nfM0qbJGkI\nev0m8IeBmyLiUOAx4EO0wuPmiLgIeBI4v/S9AzgH2Am8VPqSmc9HxKeA+0q/T2bm833ZC0nSlPUU\nAJn5faDTCYXTO/RN4OJJnucG4IapFChJmh1+E1iSKmUASFKlDABJqpS3g56El1dKmuscAUhSpRwB\nNEy/Rh7tzzPT55I0NxkAPXA6SNJc5BSQJFXKAJCkShkAklQpA0CSKmUADMny9bezfffe37haR5IG\nxQCQpEoZAJJUKb8H0CeTTeU4xSOpqRwBSFKlDABJqpQBIEmV8hzAFDmnL2mucAQgSZUyACSpUgaA\nJFXKcwAHoZmeh/D/N5AEjgAkqVoGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlS\nBoAkVcpbQcwh3qpa0lQYADrAewRJdel5CigiDomI+yPitrK8IiK2RsSjEfG1iDi0tB9WlneW9cvb\nnuOy0v5IRJzZ752RJPVuKucALgF2tC1/GrgmM1cCe4CLSvtFwJ7MfCNwTelHRBwLrAHeCpwFfDEi\nDplZ+ZKk6eopACJiKfAe4EtlOYDTgE2ly43AeeXx6rJMWX966b8a2JiZv8jMx4GdwEn92AlJ0tT1\neg7g88DHgN8uy68FXsjM/WV5F7CkPF4CPAWQmfsjYm/pvwS4t+0527fRLPMEsaSJugZARLwXeC4z\nt0XE6Hhzh67ZZd0rbdP+euuAdQCLFi1ibGysW4mT2rdv35S2v/T4/d079dGiV7/ya7bXPlu1TfYa\n4+1TPYbD0PQam14fWGM/NL2+TnoZAbwLODcizgEOB15Da0SwICLmlVHAUuDp0n8XsAzYFRHzgKOA\n59vax7Vvc0BmbgA2AIyMjOTo6Og0dqtlbGyMqWx/4YA/JV96/H4+u33yX8ETF4weeDxbtU32GuPt\nUz2Gw9D0GpteH1hjPzS9vk66ngPIzMsyc2lmLqd1EvfuzLwAuAd4X+m2Fri1PN5clinr787MLO1r\nylVCK4CVwHf6tieSpCmZyfcAPg5sjIgrgfuB60v79cBXImInrU/+awAy86GIuBl4GNgPXJyZv5rB\n60uSZmBKAZCZY8BYefwYHa7iycyfA+dPsv1VwFVTLVKS1H9+E1hd+Q1haW7yZnCSVCkDQJIqZQBI\nUqUMAEmqlAEgSZUyACSpUgaAJFXK7wFUzruESvVyBCBJlTIAJKlSBoAkVcoAkKRKGQCSVCmvAtK0\neZdQ6eDmCECSKmUASFKlDABJqpQBIEmVMgAkqVJeBaSOxq/wufT4/fjXRJqbHAFIUqUMAEmqlGN7\n9Z1fEJMODo4AJKlSjgA0Jf4HMtLc4QhAkiplAEhSpQwASaqU5wA0FF4pJA2fIwBJqpQBIEmVMgAk\nqVIGgCRVypPA6gu/ICYdfLqOACJiWUTcExE7IuKhiLiktB8dEXdFxKPlz4WlPSLiCxGxMyIeiIgT\n2p5rben/aESsnb3dkiR108sU0H7g0sx8C3AKcHFEHAusB7Zk5kpgS1kGOBtYWX7WAddBKzCAK4CT\ngZOAK8ZDQ5I0eF0DIDOfyczvlcf/A+wAlgCrgRtLtxuB88rj1cCXs+VeYEFELAbOBO7KzOczcw9w\nF3BWX/dGktSzKZ0EjojlwDuArcCizHwGWiEBvL50WwI81bbZrtI2WbskaQgiM3vrGDEf+E/gqsy8\nJSJeyMwFbev3ZObCiLgd+LvM/HZp3wJ8DDgNOCwzryztnwBeyszPTniddbSmjli0aNGJGzdunPbO\n7du3j/nz5/fcf/vuvdN+relY9Gp49meTrz9+yVEHHg+6tnHdauymfR/ate/PZPs52bYTTfX3PGhN\nrw+ssR+aVN+qVau2ZeZIt349XQUUEa8CvgHclJm3lOZnI2JxZj5TpnieK+27gGVtmy8Fni7toxPa\nxya+VmZuADYAjIyM5Ojo6MQuPRsbG2Mq21844CtZLj1+P5/dPvmv4IkLRg88HnRt47rV2E37PrRr\n35/J9nOybSea6u950JpeH1hjPzS9vk56uQoogOuBHZn5ubZVm4HxK3nWAre2tX+wXA10CrC3TBHd\nCZwREQvLyd8zSpskaQh6+Wj3LuADwPaI+H5p+yvgauDmiLgIeBI4v6y7AzgH2Am8BHwIIDOfj4hP\nAfeVfp/MzOf7sheSpCnrGgBlLj8mWX16h/4JXDzJc90A3DCVAnVw866fUnN5KwhJqpQBIEmV8l5A\nOig4lST1nyMASaqUASBJlXIKSEPnraSl4XAEIEmVMgAkqVIGgA5qy9ffzvbde51GkqbBAJCkSnkS\nWI3lp3ppdjkCkKRKGQCSVKnqp4CcZpibvHWE1F2VAeA/+pLkFJAkVcsAkKRKVTkFpIObU3hSfzgC\nkKRKOQLQnNHLyGBiH68QUs0cAUhSpRwBSIXfHVBtDIAG82SnpNnkFJAkVcoRgOY8R1JSZwaA1IXn\nBjRXGQCqmqMD1cwAkPrAUYIORp4ElqRKOQKQOnBqSDWY0yOA7bv3snz97b6ZJakDRwDSNPV676FL\nj9/Phetv99yAGscAkPpsqjelMxg0LAaA1CAGgwbJANDA1H4upvb9V/MMPAAi4izgWuAQ4EuZefWg\na5AONo4MNBsGGgARcQjwD8AfA7uA+yJic2Y+PNuv7acvNdVkfzdnci7BwFAvBj0COAnYmZmPAUTE\nRmA1MOsBIPVDEz5IzEZgTLefDm6DDoAlwFNty7uAkwdcg1SVXoJh++69XDiDYJmJXkYuk11OO5Og\nMuQgMnNwLxZxPnBmZv5ZWf4AcFJmfritzzpgXVl8E/DIDF7yGOCnM9h+tjW9PrDGfmh6fWCN/dCk\n+n4vM1/XrdOgRwC7gGVty0uBp9s7ZOYGYEM/XiwivpuZI/14rtnQ9PrAGvuh6fWBNfZD0+vrZNC3\ngrgPWBkRKyLiUGANsHnANUiSGPAIIDP3R8SfA3fSugz0hsx8aJA1SJJaBv49gMy8A7hjQC/Xl6mk\nWdT0+sAa+6Hp9YE19kPT6/sNAz0JLElqjjl9O2hJ0uTmZABExFkR8UhE7IyI9cOuByAilkXEPRGx\nIyIeiohLSvvREXFXRDxa/lw45DoPiYj7I+K2srwiIraW+r5WTt4Ps74FEbEpIn5YjuWpDTyGHy2/\n4wcj4qsRcfiwj2NE3BARz0XEg21tHY9btHyhvH8eiIgThlTf35ff8wMR8W8RsaBt3WWlvkci4szZ\nrm+yGtvW/WVEZEQcU5YHfgynY84FQNvtJs4GjgXeHxHHDrcqAPYDl2bmW4BTgItLXeuBLZm5EthS\nlofpEmBH2/KngWtKfXuAi4ZS1a9dC3wrM98MvI1WrY05hhGxBPgIMJKZx9G62GENwz+O/wKcNaFt\nsuN2NrCy/KwDrhtSfXcBx2XmHwD/BVwGUN43a4C3lm2+WN73w6iRiFhG6/Y2T7Y1D+MYTl1mzqkf\n4FTgzrbly4DLhl1XhzpvpfWX5hFgcWlbDDwyxJqW0vqH4DTgNiBofbFlXqdjO4T6XgM8Tjl31dbe\npGM4/m33o2ldZHEbcGYTjiOwHHiw23ED/gl4f6d+g6xvwro/AW4qj1/2nqZ1VeGpwziGpW0TrQ8j\nTwDHDPMYTvVnzo0A6Hy7iSVDqqWjiFgOvAPYCizKzGcAyp+vH15lfB74GPB/Zfm1wAuZub8sD/tY\nvgH4CfDPZZrqSxFxJA06hpm5G/gMrU+DzwB7gW006ziOm+y4NfE99KfAN8vjxtQXEecCuzPzBxNW\nNabGVzIXAyA6tDXmUqeImA98A/iLzPzvYdczLiLeCzyXmdvamzt0HeaxnAecAFyXme8AXmT4U2Yv\nU+bRVwMrgN8FjqQ1HTBRY/5OdtCo33tEXE5rCvWm8aYO3QZeX0QcAVwO/HWn1R3aGvc7n4sB0PV2\nE8MSEa+i9Y//TZl5S2l+NiIWl/WLgeeGVN67gHMj4glgI61poM8DCyJi/Psiwz6Wu4Bdmbm1LG+i\nFQhNOYYA7wYez8yfZOYvgVuAd9Ks4zhusuPWmPdQRKwF3gtckGUuhebU9/u0gv4H5X2zFPheRPwO\nzanxFc3FAGjk7SYiIoDrgR2Z+bm2VZuBteXxWlrnBgYuMy/LzKWZuZzWMbs7My8A7gHeN+z6ADLz\nx8BTEfGm0nQ6rVuJN+IYFk8Cp0TEEeV3Pl5jY45jm8mO22bgg+VKllOAveNTRYMUrf886uPAuZn5\nUtuqzcCaiDgsIlbQOtH6nUHXl5nbM/P1mbm8vG92ASeUv6eNOIZdDfskxGz8AOfQumrgR8Dlw66n\n1PSHtIaADwDfLz/n0Jpn3wI8Wv48ugG1jgK3lcdvoPXm2gl8HThsyLW9HfhuOY7/Dixs2jEE/hb4\nIfAg8BXgsGEfR+CrtM5J/JLWP1QXTXbcaE1f/EN5/2yndUXTMOrbSWseffz98o9t/S8v9T0CnD2s\nYzhh/RP8+iTwwI/hdH78JrAkVWouTgFJknpgAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCS\nVKn/B4tze011+p/kAAAAAElFTkSuQmCC\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"df['diametre'].hist(bins = 100)"
]
},
{
"cell_type": "code",
"execution_count": 43,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"0 PARIS 11E ARRDT\n",
"1 PARIS 18E ARRDT\n",
"2 PARIS 15E ARRDT\n",
"3 PARIS 14E ARRDT\n",
"5 PARIS 7E ARRDT\n",
"8 PARIS 4E ARRDT\n",
"11 PARIS 18E ARRDT\n",
"14 SEINE-SAINT-DENIS\n",
"16 SEINE-SAINT-DENIS\n",
"17 PARIS 15E ARRDT\n",
"18 PARIS 12E ARRDT\n",
"19 PARIS 12E ARRDT\n",
"20 PARIS 16E ARRDT\n",
"21 PARIS 17E ARRDT\n",
"22 PARIS 15E ARRDT\n",
"23 PARIS 16E ARRDT\n",
"24 PARIS 16E ARRDT\n",
"25 PARIS 16E ARRDT\n",
"26 PARIS 15E ARRDT\n",
"27 PARIS 11E ARRDT\n",
"28 PARIS 8E ARRDT\n",
"29 PARIS 18E ARRDT\n",
"30 PARIS 20E ARRDT\n",
"31 PARIS 12E ARRDT\n",
"32 PARIS 13E ARRDT\n",
"34 PARIS 15E ARRDT\n",
"35 BOIS DE VINCENNES\n",
"36 BOIS DE VINCENNES\n",
"37 PARIS 19E ARRDT\n",
"38 BOIS DE VINCENNES\n",
" ... \n",
"200300 PARIS 15E ARRDT\n",
"200301 PARIS 15E ARRDT\n",
"200302 PARIS 16E ARRDT\n",
"200303 PARIS 15E ARRDT\n",
"200304 PARIS 16E ARRDT\n",
"200305 PARIS 10E ARRDT\n",
"200306 PARIS 11E ARRDT\n",
"200307 PARIS 12E ARRDT\n",
"200308 PARIS 12E ARRDT\n",
"200309 PARIS 12E ARRDT\n",
"200310 PARIS 5E ARRDT\n",
"200311 PARIS 8E ARRDT\n",
"200312 PARIS 8E ARRDT\n",
"200313 BOIS DE BOULOGNE\n",
"200314 PARIS 15E ARRDT\n",
"200315 PARIS 15E ARRDT\n",
"200316 PARIS 16E ARRDT\n",
"200317 PARIS 7E ARRDT\n",
"200318 PARIS 8E ARRDT\n",
"200319 PARIS 8E ARRDT\n",
"200320 PARIS 10E ARRDT\n",
"200321 BOIS DE VINCENNES\n",
"200322 BOIS DE VINCENNES\n",
"200323 HAUTS-DE-SEINE\n",
"200324 PARIS 19E ARRDT\n",
"200326 PARIS 13E ARRDT\n",
"200327 PARIS 12E ARRDT\n",
"200328 BOIS DE BOULOGNE\n",
"200329 PARIS 14E ARRDT\n",
"200330 PARIS 12E ARRDT\n",
"Name: ARRONDISSEMENT, Length: 160779, dtype: object"
]
},
"execution_count": 43,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.ARRONDISSEMENT"
]
},
{
"cell_type": "code",
"execution_count": 44,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"PARIS 16E ARRDT 15012\n",
"PARIS 13E ARRDT 13824\n",
"PARIS 20E ARRDT 12934\n",
"PARIS 12E ARRDT 12159\n",
"PARIS 15E ARRDT 11442\n",
"PARIS 14E ARRDT 11358\n",
"PARIS 19E ARRDT 10298\n",
"PARIS 17E ARRDT 8678\n",
"PARIS 7E ARRDT 8507\n",
"PARIS 18E ARRDT 8454\n",
"PARIS 8E ARRDT 7062\n",
"PARIS 11E ARRDT 5529\n",
"PARIS 10E ARRDT 3106\n",
"PARIS 4E ARRDT 2690\n",
"PARIS 5E ARRDT 2341\n",
"PARIS 6E ARRDT 1754\n",
"PARIS 1ER ARRDT 1335\n",
"PARIS 3E ARRDT 1200\n",
"PARIS 9E ARRDT 1098\n",
"PARIS 2E ARRDT 537\n",
"Name: ARRONDISSEMENT, dtype: int64"
]
},
"execution_count": 44,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# les arbres dans paris\n",
"# ARRONDISSEMENT contient \"PARIS\"\n",
"\n",
"condition = df.ARRONDISSEMENT.str.contains('PARIS')\n",
"\n",
"df[condition].ARRONDISSEMENT.value_counts()\n",
"\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 45,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"(139318, 17)"
]
},
"execution_count": 45,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = df[condition]\n",
"df.shape"
]
},
{
"cell_type": "code",
"execution_count": 61,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" ARRONDISSEMENT | \n",
" LIBELLEFRANCAIS | \n",
" IDBASE | \n",
" CIRCONFERENCEENCM | \n",
" HAUTEUR (m) | \n",
" REMARQUABLE | \n",
" diametre | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" PARIS 10E ARRDT | \n",
" Ailante | \n",
" 3.216584e+05 | \n",
" 103.741935 | \n",
" 9.967742 | \n",
" 0.000000 | \n",
" 33.022084 | \n",
"
\n",
" \n",
" 1 | \n",
" PARIS 10E ARRDT | \n",
" Alisier | \n",
" 2.930440e+05 | \n",
" 20.000000 | \n",
" 5.000000 | \n",
" 0.000000 | \n",
" 6.366198 | \n",
"
\n",
" \n",
" 2 | \n",
" PARIS 10E ARRDT | \n",
" Amandier | \n",
" 1.842330e+05 | \n",
" 25.000000 | \n",
" 3.000000 | \n",
" 0.000000 | \n",
" 7.957747 | \n",
"
\n",
" \n",
" 3 | \n",
" PARIS 10E ARRDT | \n",
" Arbre aux quarante écus | \n",
" 2.750314e+05 | \n",
" 69.461538 | \n",
" 9.307692 | \n",
" 0.000000 | \n",
" 22.110294 | \n",
"
\n",
" \n",
" 4 | \n",
" PARIS 10E ARRDT | \n",
" Arbre de Judée | \n",
" 4.904134e+05 | \n",
" 93.444444 | \n",
" 7.000000 | \n",
" 0.000000 | \n",
" 29.744290 | \n",
"
\n",
" \n",
" 5 | \n",
" PARIS 10E ARRDT | \n",
" Arbre à soie | \n",
" 1.871217e+05 | \n",
" 18.666667 | \n",
" 3.333333 | \n",
" 0.000000 | \n",
" 5.941785 | \n",
"
\n",
" \n",
" 6 | \n",
" PARIS 10E ARRDT | \n",
" Bouleau | \n",
" 1.977930e+05 | \n",
" 63.588235 | \n",
" 11.509804 | \n",
" 0.000000 | \n",
" 20.240764 | \n",
"
\n",
" \n",
" 7 | \n",
" PARIS 10E ARRDT | \n",
" Catalpa | \n",
" 2.301977e+05 | \n",
" 80.000000 | \n",
" 10.000000 | \n",
" 0.000000 | \n",
" 25.464791 | \n",
"
\n",
" \n",
" 8 | \n",
" PARIS 10E ARRDT | \n",
" Cerisier à fleurs | \n",
" 7.036113e+05 | \n",
" 53.000000 | \n",
" 5.246154 | \n",
" 0.000000 | \n",
" 16.870424 | \n",
"
\n",
" \n",
" 9 | \n",
" PARIS 10E ARRDT | \n",
" Cerisier à fruits | \n",
" 1.842370e+05 | \n",
" 25.000000 | \n",
" 4.000000 | \n",
" 0.000000 | \n",
" 7.957747 | \n",
"
\n",
" \n",
" 10 | \n",
" PARIS 10E ARRDT | \n",
" Cerisier à grappes | \n",
" 2.029080e+05 | \n",
" 20.000000 | \n",
" 5.000000 | \n",
" 0.000000 | \n",
" 6.366198 | \n",
"
\n",
" \n",
" 11 | \n",
" PARIS 10E ARRDT | \n",
" Charme | \n",
" 3.382866e+05 | \n",
" 39.768362 | \n",
" 7.220339 | \n",
" 0.000000 | \n",
" 12.658663 | \n",
"
\n",
" \n",
" 12 | \n",
" PARIS 10E ARRDT | \n",
" Charme-Houblon | \n",
" 2.744478e+05 | \n",
" 52.826087 | \n",
" 8.869565 | \n",
" 0.000000 | \n",
" 16.815066 | \n",
"
\n",
" \n",
" 13 | \n",
" PARIS 10E ARRDT | \n",
" Chêne | \n",
" 4.524939e+05 | \n",
" 42.562500 | \n",
" 7.187500 | \n",
" 0.062500 | \n",
" 13.548065 | \n",
"
\n",
" \n",
" 14 | \n",
" PARIS 10E ARRDT | \n",
" Cognassier | \n",
" 2.017356e+06 | \n",
" 10.000000 | \n",
" 2.000000 | \n",
" 0.000000 | \n",
" 3.183099 | \n",
"
\n",
" \n",
" 15 | \n",
" PARIS 10E ARRDT | \n",
" Copalme | \n",
" 2.861000e+05 | \n",
" 43.666667 | \n",
" 7.666667 | \n",
" 0.000000 | \n",
" 13.899532 | \n",
"
\n",
" \n",
" 16 | \n",
" PARIS 10E ARRDT | \n",
" Cornouiller | \n",
" 1.294451e+06 | \n",
" 20.000000 | \n",
" 5.000000 | \n",
" 0.000000 | \n",
" 6.366198 | \n",
"
\n",
" \n",
" 17 | \n",
" PARIS 10E ARRDT | \n",
" Cyprès | \n",
" 1.842030e+05 | \n",
" 105.000000 | \n",
" 15.000000 | \n",
" 0.000000 | \n",
" 33.422538 | \n",
"
\n",
" \n",
" 18 | \n",
" PARIS 10E ARRDT | \n",
" Cèdre | \n",
" 1.997125e+05 | \n",
" 137.500000 | \n",
" 15.000000 | \n",
" NaN | \n",
" 43.767609 | \n",
"
\n",
" \n",
" 19 | \n",
" PARIS 10E ARRDT | \n",
" Erable | \n",
" 3.323489e+05 | \n",
" 88.072165 | \n",
" 11.036082 | \n",
" 0.000000 | \n",
" 28.034241 | \n",
"
\n",
" \n",
" 20 | \n",
" PARIS 10E ARRDT | \n",
" Fevier | \n",
" 2.487587e+05 | \n",
" 43.900000 | \n",
" 7.200000 | \n",
" 0.000000 | \n",
" 13.973804 | \n",
"
\n",
" \n",
" 21 | \n",
" PARIS 10E ARRDT | \n",
" Frêne | \n",
" 2.853585e+05 | \n",
" 74.040000 | \n",
" 9.946667 | \n",
" 0.000000 | \n",
" 23.567664 | \n",
"
\n",
" \n",
" 22 | \n",
" PARIS 10E ARRDT | \n",
" Frêne à fleurs | \n",
" 2.145790e+05 | \n",
" 31.666667 | \n",
" 5.333333 | \n",
" 0.000000 | \n",
" 10.079813 | \n",
"
\n",
" \n",
" 23 | \n",
" PARIS 10E ARRDT | \n",
" Laurier du Portugal | \n",
" 2.018288e+06 | \n",
" 20.000000 | \n",
" 5.000000 | \n",
" 0.000000 | \n",
" 6.366198 | \n",
"
\n",
" \n",
" 24 | \n",
" PARIS 10E ARRDT | \n",
" Lilas des indes | \n",
" 2.154770e+05 | \n",
" 25.000000 | \n",
" 3.000000 | \n",
" 0.000000 | \n",
" 7.957747 | \n",
"
\n",
" \n",
" 25 | \n",
" PARIS 10E ARRDT | \n",
" Magnolia | \n",
" 3.282096e+05 | \n",
" 75.627451 | \n",
" 7.352941 | \n",
" 0.000000 | \n",
" 24.072965 | \n",
"
\n",
" \n",
" 26 | \n",
" PARIS 10E ARRDT | \n",
" Marronnier | \n",
" 2.442603e+05 | \n",
" 135.910714 | \n",
" 12.598214 | \n",
" 0.000000 | \n",
" 43.261724 | \n",
"
\n",
" \n",
" 27 | \n",
" PARIS 10E ARRDT | \n",
" Merisier | \n",
" 1.915550e+05 | \n",
" 52.000000 | \n",
" 8.000000 | \n",
" 0.000000 | \n",
" 16.552114 | \n",
"
\n",
" \n",
" 28 | \n",
" PARIS 10E ARRDT | \n",
" Micocoulier | \n",
" 2.855874e+05 | \n",
" 120.375000 | \n",
" 13.500000 | \n",
" 0.000000 | \n",
" 38.316553 | \n",
"
\n",
" \n",
" 29 | \n",
" PARIS 10E ARRDT | \n",
" Mûrier | \n",
" 2.986600e+05 | \n",
" 91.605505 | \n",
" 10.678899 | \n",
" 0.000000 | \n",
" 29.158938 | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 1672 | \n",
" PARIS 9E ARRDT | \n",
" Charme | \n",
" 2.643521e+05 | \n",
" 51.636364 | \n",
" 8.727273 | \n",
" 0.000000 | \n",
" 16.436365 | \n",
"
\n",
" \n",
" 1673 | \n",
" PARIS 9E ARRDT | \n",
" Chêne | \n",
" 2.378429e+05 | \n",
" 46.404762 | \n",
" 6.595238 | \n",
" 0.000000 | \n",
" 14.771094 | \n",
"
\n",
" \n",
" 1674 | \n",
" PARIS 9E ARRDT | \n",
" Erable | \n",
" 8.110159e+05 | \n",
" 51.035714 | \n",
" 7.857143 | \n",
" 0.000000 | \n",
" 16.245172 | \n",
"
\n",
" \n",
" 1675 | \n",
" PARIS 9E ARRDT | \n",
" Fevier | \n",
" 2.832462e+05 | \n",
" 80.807692 | \n",
" 11.884615 | \n",
" 0.000000 | \n",
" 25.721887 | \n",
"
\n",
" \n",
" 1676 | \n",
" PARIS 9E ARRDT | \n",
" Lilas des indes | \n",
" 2.551370e+05 | \n",
" 20.000000 | \n",
" 3.000000 | \n",
" 0.000000 | \n",
" 6.366198 | \n",
"
\n",
" \n",
" 1677 | \n",
" PARIS 9E ARRDT | \n",
" Magnolia | \n",
" 2.017711e+06 | \n",
" 10.000000 | \n",
" 2.000000 | \n",
" 0.000000 | \n",
" 3.183099 | \n",
"
\n",
" \n",
" 1678 | \n",
" PARIS 9E ARRDT | \n",
" Marronnier | \n",
" 3.166961e+05 | \n",
" 104.023810 | \n",
" 11.547619 | \n",
" 0.000000 | \n",
" 33.111807 | \n",
"
\n",
" \n",
" 1679 | \n",
" PARIS 9E ARRDT | \n",
" Micocoulier | \n",
" 3.930880e+05 | \n",
" 58.852113 | \n",
" 6.866197 | \n",
" 0.000000 | \n",
" 18.733209 | \n",
"
\n",
" \n",
" 1680 | \n",
" PARIS 9E ARRDT | \n",
" Mûrier | \n",
" 2.861630e+05 | \n",
" 57.000000 | \n",
" 5.750000 | \n",
" 0.000000 | \n",
" 18.143664 | \n",
"
\n",
" \n",
" 1681 | \n",
" PARIS 9E ARRDT | \n",
" Noyer | \n",
" 2.152310e+05 | \n",
" 216.000000 | \n",
" 15.000000 | \n",
" 0.000000 | \n",
" 68.754935 | \n",
"
\n",
" \n",
" 1682 | \n",
" PARIS 9E ARRDT | \n",
" Néflier | \n",
" 1.866290e+05 | \n",
" 64.000000 | \n",
" 8.000000 | \n",
" 0.000000 | \n",
" 20.371833 | \n",
"
\n",
" \n",
" 1683 | \n",
" PARIS 9E ARRDT | \n",
" Orme de Sibérie | \n",
" 3.193080e+05 | \n",
" 50.000000 | \n",
" 5.333333 | \n",
" 0.000000 | \n",
" 15.915494 | \n",
"
\n",
" \n",
" 1684 | \n",
" PARIS 9E ARRDT | \n",
" Paulownia | \n",
" 2.520590e+05 | \n",
" 162.500000 | \n",
" 10.000000 | \n",
" 0.000000 | \n",
" 51.725357 | \n",
"
\n",
" \n",
" 1685 | \n",
" PARIS 9E ARRDT | \n",
" Peuplier | \n",
" 3.192760e+05 | \n",
" 207.000000 | \n",
" 20.000000 | \n",
" 0.000000 | \n",
" 65.890146 | \n",
"
\n",
" \n",
" 1686 | \n",
" PARIS 9E ARRDT | \n",
" Photinia | \n",
" 2.170440e+05 | \n",
" 33.333333 | \n",
" 3.000000 | \n",
" 0.000000 | \n",
" 10.610330 | \n",
"
\n",
" \n",
" 1687 | \n",
" PARIS 9E ARRDT | \n",
" Platane | \n",
" 2.657069e+05 | \n",
" 104.069565 | \n",
" 13.973913 | \n",
" 0.002174 | \n",
" 33.126371 | \n",
"
\n",
" \n",
" 1688 | \n",
" PARIS 9E ARRDT | \n",
" Poirier | \n",
" 1.864840e+05 | \n",
" 27.000000 | \n",
" 6.000000 | \n",
" 0.000000 | \n",
" 8.594367 | \n",
"
\n",
" \n",
" 1689 | \n",
" PARIS 9E ARRDT | \n",
" Poirier à fleurs | \n",
" 2.442628e+05 | \n",
" 52.764706 | \n",
" 9.411765 | \n",
" 0.000000 | \n",
" 16.795528 | \n",
"
\n",
" \n",
" 1690 | \n",
" PARIS 9E ARRDT | \n",
" Poirier à fruits | \n",
" 2.020886e+06 | \n",
" 24.285714 | \n",
" 2.000000 | \n",
" 0.000000 | \n",
" 7.730383 | \n",
"
\n",
" \n",
" 1691 | \n",
" PARIS 9E ARRDT | \n",
" Pommier | \n",
" 1.854420e+05 | \n",
" 18.000000 | \n",
" 3.000000 | \n",
" 0.000000 | \n",
" 5.729578 | \n",
"
\n",
" \n",
" 1692 | \n",
" PARIS 9E ARRDT | \n",
" Pommier à fleurs | \n",
" 4.115462e+05 | \n",
" 58.000000 | \n",
" 8.416667 | \n",
" 0.000000 | \n",
" 18.461973 | \n",
"
\n",
" \n",
" 1693 | \n",
" PARIS 9E ARRDT | \n",
" Pommier à fruits | \n",
" 2.020848e+06 | \n",
" 10.000000 | \n",
" 2.000000 | \n",
" 0.000000 | \n",
" 3.183099 | \n",
"
\n",
" \n",
" 1694 | \n",
" PARIS 9E ARRDT | \n",
" Prunier à fleurs | \n",
" 1.262483e+06 | \n",
" 36.571429 | \n",
" 4.857143 | \n",
" 0.000000 | \n",
" 11.641047 | \n",
"
\n",
" \n",
" 1695 | \n",
" PARIS 9E ARRDT | \n",
" Pterocarya | \n",
" 2.971995e+05 | \n",
" 91.977778 | \n",
" 9.222222 | \n",
" 0.022222 | \n",
" 29.277436 | \n",
"
\n",
" \n",
" 1696 | \n",
" PARIS 9E ARRDT | \n",
" Robinier | \n",
" 3.075820e+05 | \n",
" 89.166667 | \n",
" 10.166667 | \n",
" 0.000000 | \n",
" 28.382632 | \n",
"
\n",
" \n",
" 1697 | \n",
" PARIS 9E ARRDT | \n",
" Savonnier | \n",
" 3.169560e+05 | \n",
" 80.000000 | \n",
" 10.000000 | \n",
" 0.000000 | \n",
" 25.464791 | \n",
"
\n",
" \n",
" 1698 | \n",
" PARIS 9E ARRDT | \n",
" Sophora | \n",
" 2.941020e+05 | \n",
" 84.126761 | \n",
" 10.140845 | \n",
" 0.000000 | \n",
" 26.778380 | \n",
"
\n",
" \n",
" 1699 | \n",
" PARIS 9E ARRDT | \n",
" Tilleul | \n",
" 2.760113e+05 | \n",
" 77.750000 | \n",
" 9.000000 | \n",
" 0.000000 | \n",
" 24.748594 | \n",
"
\n",
" \n",
" 1700 | \n",
" PARIS 9E ARRDT | \n",
" Troene | \n",
" 3.193050e+05 | \n",
" 30.000000 | \n",
" 5.000000 | \n",
" 0.000000 | \n",
" 9.549297 | \n",
"
\n",
" \n",
" 1701 | \n",
" PARIS 9E ARRDT | \n",
" Tulipier | \n",
" 2.157222e+05 | \n",
" 45.000000 | \n",
" 9.500000 | \n",
" 0.000000 | \n",
" 14.323945 | \n",
"
\n",
" \n",
"
\n",
"
1702 rows × 7 columns
\n",
"
"
],
"text/plain": [
" ARRONDISSEMENT LIBELLEFRANCAIS IDBASE \\\n",
"0 PARIS 10E ARRDT Ailante 3.216584e+05 \n",
"1 PARIS 10E ARRDT Alisier 2.930440e+05 \n",
"2 PARIS 10E ARRDT Amandier 1.842330e+05 \n",
"3 PARIS 10E ARRDT Arbre aux quarante écus 2.750314e+05 \n",
"4 PARIS 10E ARRDT Arbre de Judée 4.904134e+05 \n",
"5 PARIS 10E ARRDT Arbre à soie 1.871217e+05 \n",
"6 PARIS 10E ARRDT Bouleau 1.977930e+05 \n",
"7 PARIS 10E ARRDT Catalpa 2.301977e+05 \n",
"8 PARIS 10E ARRDT Cerisier à fleurs 7.036113e+05 \n",
"9 PARIS 10E ARRDT Cerisier à fruits 1.842370e+05 \n",
"10 PARIS 10E ARRDT Cerisier à grappes 2.029080e+05 \n",
"11 PARIS 10E ARRDT Charme 3.382866e+05 \n",
"12 PARIS 10E ARRDT Charme-Houblon 2.744478e+05 \n",
"13 PARIS 10E ARRDT Chêne 4.524939e+05 \n",
"14 PARIS 10E ARRDT Cognassier 2.017356e+06 \n",
"15 PARIS 10E ARRDT Copalme 2.861000e+05 \n",
"16 PARIS 10E ARRDT Cornouiller 1.294451e+06 \n",
"17 PARIS 10E ARRDT Cyprès 1.842030e+05 \n",
"18 PARIS 10E ARRDT Cèdre 1.997125e+05 \n",
"19 PARIS 10E ARRDT Erable 3.323489e+05 \n",
"20 PARIS 10E ARRDT Fevier 2.487587e+05 \n",
"21 PARIS 10E ARRDT Frêne 2.853585e+05 \n",
"22 PARIS 10E ARRDT Frêne à fleurs 2.145790e+05 \n",
"23 PARIS 10E ARRDT Laurier du Portugal 2.018288e+06 \n",
"24 PARIS 10E ARRDT Lilas des indes 2.154770e+05 \n",
"25 PARIS 10E ARRDT Magnolia 3.282096e+05 \n",
"26 PARIS 10E ARRDT Marronnier 2.442603e+05 \n",
"27 PARIS 10E ARRDT Merisier 1.915550e+05 \n",
"28 PARIS 10E ARRDT Micocoulier 2.855874e+05 \n",
"29 PARIS 10E ARRDT Mûrier 2.986600e+05 \n",
"... ... ... ... \n",
"1672 PARIS 9E ARRDT Charme 2.643521e+05 \n",
"1673 PARIS 9E ARRDT Chêne 2.378429e+05 \n",
"1674 PARIS 9E ARRDT Erable 8.110159e+05 \n",
"1675 PARIS 9E ARRDT Fevier 2.832462e+05 \n",
"1676 PARIS 9E ARRDT Lilas des indes 2.551370e+05 \n",
"1677 PARIS 9E ARRDT Magnolia 2.017711e+06 \n",
"1678 PARIS 9E ARRDT Marronnier 3.166961e+05 \n",
"1679 PARIS 9E ARRDT Micocoulier 3.930880e+05 \n",
"1680 PARIS 9E ARRDT Mûrier 2.861630e+05 \n",
"1681 PARIS 9E ARRDT Noyer 2.152310e+05 \n",
"1682 PARIS 9E ARRDT Néflier 1.866290e+05 \n",
"1683 PARIS 9E ARRDT Orme de Sibérie 3.193080e+05 \n",
"1684 PARIS 9E ARRDT Paulownia 2.520590e+05 \n",
"1685 PARIS 9E ARRDT Peuplier 3.192760e+05 \n",
"1686 PARIS 9E ARRDT Photinia 2.170440e+05 \n",
"1687 PARIS 9E ARRDT Platane 2.657069e+05 \n",
"1688 PARIS 9E ARRDT Poirier 1.864840e+05 \n",
"1689 PARIS 9E ARRDT Poirier à fleurs 2.442628e+05 \n",
"1690 PARIS 9E ARRDT Poirier à fruits 2.020886e+06 \n",
"1691 PARIS 9E ARRDT Pommier 1.854420e+05 \n",
"1692 PARIS 9E ARRDT Pommier à fleurs 4.115462e+05 \n",
"1693 PARIS 9E ARRDT Pommier à fruits 2.020848e+06 \n",
"1694 PARIS 9E ARRDT Prunier à fleurs 1.262483e+06 \n",
"1695 PARIS 9E ARRDT Pterocarya 2.971995e+05 \n",
"1696 PARIS 9E ARRDT Robinier 3.075820e+05 \n",
"1697 PARIS 9E ARRDT Savonnier 3.169560e+05 \n",
"1698 PARIS 9E ARRDT Sophora 2.941020e+05 \n",
"1699 PARIS 9E ARRDT Tilleul 2.760113e+05 \n",
"1700 PARIS 9E ARRDT Troene 3.193050e+05 \n",
"1701 PARIS 9E ARRDT Tulipier 2.157222e+05 \n",
"\n",
" CIRCONFERENCEENCM HAUTEUR (m) REMARQUABLE diametre \n",
"0 103.741935 9.967742 0.000000 33.022084 \n",
"1 20.000000 5.000000 0.000000 6.366198 \n",
"2 25.000000 3.000000 0.000000 7.957747 \n",
"3 69.461538 9.307692 0.000000 22.110294 \n",
"4 93.444444 7.000000 0.000000 29.744290 \n",
"5 18.666667 3.333333 0.000000 5.941785 \n",
"6 63.588235 11.509804 0.000000 20.240764 \n",
"7 80.000000 10.000000 0.000000 25.464791 \n",
"8 53.000000 5.246154 0.000000 16.870424 \n",
"9 25.000000 4.000000 0.000000 7.957747 \n",
"10 20.000000 5.000000 0.000000 6.366198 \n",
"11 39.768362 7.220339 0.000000 12.658663 \n",
"12 52.826087 8.869565 0.000000 16.815066 \n",
"13 42.562500 7.187500 0.062500 13.548065 \n",
"14 10.000000 2.000000 0.000000 3.183099 \n",
"15 43.666667 7.666667 0.000000 13.899532 \n",
"16 20.000000 5.000000 0.000000 6.366198 \n",
"17 105.000000 15.000000 0.000000 33.422538 \n",
"18 137.500000 15.000000 NaN 43.767609 \n",
"19 88.072165 11.036082 0.000000 28.034241 \n",
"20 43.900000 7.200000 0.000000 13.973804 \n",
"21 74.040000 9.946667 0.000000 23.567664 \n",
"22 31.666667 5.333333 0.000000 10.079813 \n",
"23 20.000000 5.000000 0.000000 6.366198 \n",
"24 25.000000 3.000000 0.000000 7.957747 \n",
"25 75.627451 7.352941 0.000000 24.072965 \n",
"26 135.910714 12.598214 0.000000 43.261724 \n",
"27 52.000000 8.000000 0.000000 16.552114 \n",
"28 120.375000 13.500000 0.000000 38.316553 \n",
"29 91.605505 10.678899 0.000000 29.158938 \n",
"... ... ... ... ... \n",
"1672 51.636364 8.727273 0.000000 16.436365 \n",
"1673 46.404762 6.595238 0.000000 14.771094 \n",
"1674 51.035714 7.857143 0.000000 16.245172 \n",
"1675 80.807692 11.884615 0.000000 25.721887 \n",
"1676 20.000000 3.000000 0.000000 6.366198 \n",
"1677 10.000000 2.000000 0.000000 3.183099 \n",
"1678 104.023810 11.547619 0.000000 33.111807 \n",
"1679 58.852113 6.866197 0.000000 18.733209 \n",
"1680 57.000000 5.750000 0.000000 18.143664 \n",
"1681 216.000000 15.000000 0.000000 68.754935 \n",
"1682 64.000000 8.000000 0.000000 20.371833 \n",
"1683 50.000000 5.333333 0.000000 15.915494 \n",
"1684 162.500000 10.000000 0.000000 51.725357 \n",
"1685 207.000000 20.000000 0.000000 65.890146 \n",
"1686 33.333333 3.000000 0.000000 10.610330 \n",
"1687 104.069565 13.973913 0.002174 33.126371 \n",
"1688 27.000000 6.000000 0.000000 8.594367 \n",
"1689 52.764706 9.411765 0.000000 16.795528 \n",
"1690 24.285714 2.000000 0.000000 7.730383 \n",
"1691 18.000000 3.000000 0.000000 5.729578 \n",
"1692 58.000000 8.416667 0.000000 18.461973 \n",
"1693 10.000000 2.000000 0.000000 3.183099 \n",
"1694 36.571429 4.857143 0.000000 11.641047 \n",
"1695 91.977778 9.222222 0.022222 29.277436 \n",
"1696 89.166667 10.166667 0.000000 28.382632 \n",
"1697 80.000000 10.000000 0.000000 25.464791 \n",
"1698 84.126761 10.140845 0.000000 26.778380 \n",
"1699 77.750000 9.000000 0.000000 24.748594 \n",
"1700 30.000000 5.000000 0.000000 9.549297 \n",
"1701 45.000000 9.500000 0.000000 14.323945 \n",
"\n",
"[1702 rows x 7 columns]"
]
},
"execution_count": 61,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"gb = df.groupby( by = ['ARRONDISSEMENT', 'LIBELLEFRANCAIS'] ).mean()\n",
"gb.reset_index(inplace = True)\n",
"gb"
]
},
{
"cell_type": "code",
"execution_count": 76,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" ARRONDISSEMENT | \n",
" IDBASE | \n",
" TYPEEMPLACEMENT | \n",
" DOMANIALITE | \n",
" COMPLEMENTADRESSE | \n",
" LIEU / ADRESSE | \n",
" IDEMPLACEMENT | \n",
" LIBELLEFRANCAIS | \n",
" GENRE | \n",
" ESPECE | \n",
" VARIETEOUCULTIVAR | \n",
" CIRCONFERENCEENCM | \n",
" HAUTEUR (m) | \n",
" STADEDEVELOPPEMENT | \n",
" REMARQUABLE | \n",
" geo_point_2d | \n",
" diametre | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" PARIS 10E ARRDT | \n",
" 3106 | \n",
" 3106 | \n",
" 3106 | \n",
" 1252 | \n",
" 3106 | \n",
" 3106 | \n",
" 3079 | \n",
" 3106 | \n",
" 2786 | \n",
" 1050 | \n",
" 3106 | \n",
" 3106 | \n",
" 2770 | \n",
" 2834 | \n",
" 3106 | \n",
" 3106 | \n",
"
\n",
" \n",
" 1 | \n",
" PARIS 11E ARRDT | \n",
" 5529 | \n",
" 5529 | \n",
" 5529 | \n",
" 431 | \n",
" 5529 | \n",
" 5529 | \n",
" 5514 | \n",
" 5529 | \n",
" 5504 | \n",
" 601 | \n",
" 5529 | \n",
" 5529 | \n",
" 4474 | \n",
" 4625 | \n",
" 5529 | \n",
" 5529 | \n",
"
\n",
" \n",
" 2 | \n",
" PARIS 12E ARRDT | \n",
" 12159 | \n",
" 12159 | \n",
" 12159 | \n",
" 1404 | \n",
" 12159 | \n",
" 12159 | \n",
" 12033 | \n",
" 12159 | \n",
" 12023 | \n",
" 2121 | \n",
" 12159 | \n",
" 12159 | \n",
" 8741 | \n",
" 8387 | \n",
" 12159 | \n",
" 12159 | \n",
"
\n",
" \n",
" 3 | \n",
" PARIS 13E ARRDT | \n",
" 13824 | \n",
" 13824 | \n",
" 13824 | \n",
" 1302 | \n",
" 13824 | \n",
" 13824 | \n",
" 13735 | \n",
" 13824 | \n",
" 13756 | \n",
" 3005 | \n",
" 13824 | \n",
" 13824 | \n",
" 10219 | \n",
" 10328 | \n",
" 13824 | \n",
" 13824 | \n",
"
\n",
" \n",
" 4 | \n",
" PARIS 14E ARRDT | \n",
" 11358 | \n",
" 11358 | \n",
" 11358 | \n",
" 702 | \n",
" 11358 | \n",
" 11358 | \n",
" 11194 | \n",
" 11358 | \n",
" 11217 | \n",
" 2203 | \n",
" 11358 | \n",
" 11358 | \n",
" 10164 | \n",
" 9964 | \n",
" 11358 | \n",
" 11358 | \n",
"
\n",
" \n",
" 5 | \n",
" PARIS 15E ARRDT | \n",
" 11442 | \n",
" 11442 | \n",
" 11442 | \n",
" 7746 | \n",
" 11442 | \n",
" 11442 | \n",
" 11281 | \n",
" 11442 | \n",
" 11398 | \n",
" 3047 | \n",
" 11442 | \n",
" 11442 | \n",
" 9710 | \n",
" 9142 | \n",
" 11442 | \n",
" 11442 | \n",
"
\n",
" \n",
" 6 | \n",
" PARIS 16E ARRDT | \n",
" 15012 | \n",
" 15012 | \n",
" 15012 | \n",
" 1595 | \n",
" 15012 | \n",
" 15012 | \n",
" 14915 | \n",
" 15012 | \n",
" 14949 | \n",
" 1652 | \n",
" 15012 | \n",
" 15012 | \n",
" 11475 | \n",
" 10545 | \n",
" 15012 | \n",
" 15012 | \n",
"
\n",
" \n",
" 7 | \n",
" PARIS 17E ARRDT | \n",
" 8678 | \n",
" 8678 | \n",
" 8678 | \n",
" 941 | \n",
" 8678 | \n",
" 8678 | \n",
" 8629 | \n",
" 8678 | \n",
" 8643 | \n",
" 1479 | \n",
" 8678 | \n",
" 8678 | \n",
" 7374 | \n",
" 6926 | \n",
" 8678 | \n",
" 8678 | \n",
"
\n",
" \n",
" 8 | \n",
" PARIS 18E ARRDT | \n",
" 8454 | \n",
" 8454 | \n",
" 8454 | \n",
" 1055 | \n",
" 8454 | \n",
" 8454 | \n",
" 8372 | \n",
" 8454 | \n",
" 8388 | \n",
" 2286 | \n",
" 8454 | \n",
" 8454 | \n",
" 6914 | \n",
" 6581 | \n",
" 8454 | \n",
" 8454 | \n",
"
\n",
" \n",
" 9 | \n",
" PARIS 19E ARRDT | \n",
" 10298 | \n",
" 10298 | \n",
" 10298 | \n",
" 770 | \n",
" 10298 | \n",
" 10298 | \n",
" 10201 | \n",
" 10298 | \n",
" 10230 | \n",
" 1793 | \n",
" 10298 | \n",
" 10298 | \n",
" 7391 | \n",
" 8099 | \n",
" 10298 | \n",
" 10298 | \n",
"
\n",
" \n",
" 10 | \n",
" PARIS 1ER ARRDT | \n",
" 1335 | \n",
" 1335 | \n",
" 1335 | \n",
" 200 | \n",
" 1335 | \n",
" 1335 | \n",
" 1305 | \n",
" 1335 | \n",
" 1318 | \n",
" 338 | \n",
" 1335 | \n",
" 1335 | \n",
" 995 | \n",
" 1153 | \n",
" 1335 | \n",
" 1335 | \n",
"
\n",
" \n",
" 11 | \n",
" PARIS 20E ARRDT | \n",
" 12934 | \n",
" 12934 | \n",
" 12933 | \n",
" 4483 | \n",
" 12934 | \n",
" 12934 | \n",
" 12854 | \n",
" 12934 | \n",
" 12840 | \n",
" 2058 | \n",
" 12934 | \n",
" 12934 | \n",
" 10597 | \n",
" 10518 | \n",
" 12934 | \n",
" 12934 | \n",
"
\n",
" \n",
" 12 | \n",
" PARIS 2E ARRDT | \n",
" 537 | \n",
" 537 | \n",
" 537 | \n",
" 400 | \n",
" 537 | \n",
" 537 | \n",
" 534 | \n",
" 537 | \n",
" 534 | \n",
" 64 | \n",
" 537 | \n",
" 537 | \n",
" 468 | \n",
" 520 | \n",
" 537 | \n",
" 537 | \n",
"
\n",
" \n",
" 13 | \n",
" PARIS 3E ARRDT | \n",
" 1200 | \n",
" 1200 | \n",
" 1200 | \n",
" 654 | \n",
" 1200 | \n",
" 1200 | \n",
" 1192 | \n",
" 1200 | \n",
" 1200 | \n",
" 132 | \n",
" 1200 | \n",
" 1200 | \n",
" 950 | \n",
" 960 | \n",
" 1200 | \n",
" 1200 | \n",
"
\n",
" \n",
" 14 | \n",
" PARIS 4E ARRDT | \n",
" 2690 | \n",
" 2690 | \n",
" 2690 | \n",
" 196 | \n",
" 2690 | \n",
" 2690 | \n",
" 2682 | \n",
" 2690 | \n",
" 2665 | \n",
" 510 | \n",
" 2690 | \n",
" 2690 | \n",
" 2007 | \n",
" 2200 | \n",
" 2690 | \n",
" 2690 | \n",
"
\n",
" \n",
" 15 | \n",
" PARIS 5E ARRDT | \n",
" 2341 | \n",
" 2341 | \n",
" 2341 | \n",
" 913 | \n",
" 2341 | \n",
" 2341 | \n",
" 2302 | \n",
" 2341 | \n",
" 2331 | \n",
" 277 | \n",
" 2341 | \n",
" 2341 | \n",
" 1756 | \n",
" 1750 | \n",
" 2341 | \n",
" 2341 | \n",
"
\n",
" \n",
" 16 | \n",
" PARIS 6E ARRDT | \n",
" 1754 | \n",
" 1754 | \n",
" 1754 | \n",
" 625 | \n",
" 1754 | \n",
" 1754 | \n",
" 1741 | \n",
" 1754 | \n",
" 1742 | \n",
" 289 | \n",
" 1754 | \n",
" 1754 | \n",
" 1416 | \n",
" 1258 | \n",
" 1754 | \n",
" 1754 | \n",
"
\n",
" \n",
" 17 | \n",
" PARIS 7E ARRDT | \n",
" 8507 | \n",
" 8507 | \n",
" 8507 | \n",
" 3190 | \n",
" 8507 | \n",
" 8507 | \n",
" 8444 | \n",
" 8507 | \n",
" 8489 | \n",
" 936 | \n",
" 8507 | \n",
" 8507 | \n",
" 7851 | \n",
" 7696 | \n",
" 8507 | \n",
" 8507 | \n",
"
\n",
" \n",
" 18 | \n",
" PARIS 8E ARRDT | \n",
" 7062 | \n",
" 7062 | \n",
" 7062 | \n",
" 836 | \n",
" 7062 | \n",
" 7062 | \n",
" 7046 | \n",
" 7062 | \n",
" 7055 | \n",
" 846 | \n",
" 7062 | \n",
" 7062 | \n",
" 6290 | \n",
" 5101 | \n",
" 7062 | \n",
" 7062 | \n",
"
\n",
" \n",
" 19 | \n",
" PARIS 9E ARRDT | \n",
" 1098 | \n",
" 1098 | \n",
" 1098 | \n",
" 701 | \n",
" 1098 | \n",
" 1098 | \n",
" 1092 | \n",
" 1098 | \n",
" 1098 | \n",
" 139 | \n",
" 1098 | \n",
" 1098 | \n",
" 998 | \n",
" 1097 | \n",
" 1098 | \n",
" 1098 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" ARRONDISSEMENT IDBASE TYPEEMPLACEMENT DOMANIALITE COMPLEMENTADRESSE \\\n",
"0 PARIS 10E ARRDT 3106 3106 3106 1252 \n",
"1 PARIS 11E ARRDT 5529 5529 5529 431 \n",
"2 PARIS 12E ARRDT 12159 12159 12159 1404 \n",
"3 PARIS 13E ARRDT 13824 13824 13824 1302 \n",
"4 PARIS 14E ARRDT 11358 11358 11358 702 \n",
"5 PARIS 15E ARRDT 11442 11442 11442 7746 \n",
"6 PARIS 16E ARRDT 15012 15012 15012 1595 \n",
"7 PARIS 17E ARRDT 8678 8678 8678 941 \n",
"8 PARIS 18E ARRDT 8454 8454 8454 1055 \n",
"9 PARIS 19E ARRDT 10298 10298 10298 770 \n",
"10 PARIS 1ER ARRDT 1335 1335 1335 200 \n",
"11 PARIS 20E ARRDT 12934 12934 12933 4483 \n",
"12 PARIS 2E ARRDT 537 537 537 400 \n",
"13 PARIS 3E ARRDT 1200 1200 1200 654 \n",
"14 PARIS 4E ARRDT 2690 2690 2690 196 \n",
"15 PARIS 5E ARRDT 2341 2341 2341 913 \n",
"16 PARIS 6E ARRDT 1754 1754 1754 625 \n",
"17 PARIS 7E ARRDT 8507 8507 8507 3190 \n",
"18 PARIS 8E ARRDT 7062 7062 7062 836 \n",
"19 PARIS 9E ARRDT 1098 1098 1098 701 \n",
"\n",
" LIEU / ADRESSE IDEMPLACEMENT LIBELLEFRANCAIS GENRE ESPECE \\\n",
"0 3106 3106 3079 3106 2786 \n",
"1 5529 5529 5514 5529 5504 \n",
"2 12159 12159 12033 12159 12023 \n",
"3 13824 13824 13735 13824 13756 \n",
"4 11358 11358 11194 11358 11217 \n",
"5 11442 11442 11281 11442 11398 \n",
"6 15012 15012 14915 15012 14949 \n",
"7 8678 8678 8629 8678 8643 \n",
"8 8454 8454 8372 8454 8388 \n",
"9 10298 10298 10201 10298 10230 \n",
"10 1335 1335 1305 1335 1318 \n",
"11 12934 12934 12854 12934 12840 \n",
"12 537 537 534 537 534 \n",
"13 1200 1200 1192 1200 1200 \n",
"14 2690 2690 2682 2690 2665 \n",
"15 2341 2341 2302 2341 2331 \n",
"16 1754 1754 1741 1754 1742 \n",
"17 8507 8507 8444 8507 8489 \n",
"18 7062 7062 7046 7062 7055 \n",
"19 1098 1098 1092 1098 1098 \n",
"\n",
" VARIETEOUCULTIVAR CIRCONFERENCEENCM HAUTEUR (m) STADEDEVELOPPEMENT \\\n",
"0 1050 3106 3106 2770 \n",
"1 601 5529 5529 4474 \n",
"2 2121 12159 12159 8741 \n",
"3 3005 13824 13824 10219 \n",
"4 2203 11358 11358 10164 \n",
"5 3047 11442 11442 9710 \n",
"6 1652 15012 15012 11475 \n",
"7 1479 8678 8678 7374 \n",
"8 2286 8454 8454 6914 \n",
"9 1793 10298 10298 7391 \n",
"10 338 1335 1335 995 \n",
"11 2058 12934 12934 10597 \n",
"12 64 537 537 468 \n",
"13 132 1200 1200 950 \n",
"14 510 2690 2690 2007 \n",
"15 277 2341 2341 1756 \n",
"16 289 1754 1754 1416 \n",
"17 936 8507 8507 7851 \n",
"18 846 7062 7062 6290 \n",
"19 139 1098 1098 998 \n",
"\n",
" REMARQUABLE geo_point_2d diametre \n",
"0 2834 3106 3106 \n",
"1 4625 5529 5529 \n",
"2 8387 12159 12159 \n",
"3 10328 13824 13824 \n",
"4 9964 11358 11358 \n",
"5 9142 11442 11442 \n",
"6 10545 15012 15012 \n",
"7 6926 8678 8678 \n",
"8 6581 8454 8454 \n",
"9 8099 10298 10298 \n",
"10 1153 1335 1335 \n",
"11 10518 12934 12934 \n",
"12 520 537 537 \n",
"13 960 1200 1200 \n",
"14 2200 2690 2690 \n",
"15 1750 2341 2341 \n",
"16 1258 1754 1754 \n",
"17 7696 8507 8507 \n",
"18 5101 7062 7062 \n",
"19 1097 1098 1098 "
]
},
"execution_count": 76,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"gb = df.groupby( by = 'ARRONDISSEMENT' ).count()\n",
"gb.reset_index(inplace = True)\n",
"gb"
]
},
{
"cell_type": "code",
"execution_count": 77,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"gb.rename(columns={'DOMANIALITE': 'nbre_abres'}, inplace = True)\n",
"\n",
"gb = gb[['ARRONDISSEMENT', 'nbre_abres']]\n"
]
},
{
"cell_type": "code",
"execution_count": 78,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" ARRONDISSEMENT | \n",
" nbre_abres | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" PARIS 10E ARRDT | \n",
" 3106 | \n",
"
\n",
" \n",
" 1 | \n",
" PARIS 11E ARRDT | \n",
" 5529 | \n",
"
\n",
" \n",
" 2 | \n",
" PARIS 12E ARRDT | \n",
" 12159 | \n",
"
\n",
" \n",
" 3 | \n",
" PARIS 13E ARRDT | \n",
" 13824 | \n",
"
\n",
" \n",
" 4 | \n",
" PARIS 14E ARRDT | \n",
" 11358 | \n",
"
\n",
" \n",
" 5 | \n",
" PARIS 15E ARRDT | \n",
" 11442 | \n",
"
\n",
" \n",
" 6 | \n",
" PARIS 16E ARRDT | \n",
" 15012 | \n",
"
\n",
" \n",
" 7 | \n",
" PARIS 17E ARRDT | \n",
" 8678 | \n",
"
\n",
" \n",
" 8 | \n",
" PARIS 18E ARRDT | \n",
" 8454 | \n",
"
\n",
" \n",
" 9 | \n",
" PARIS 19E ARRDT | \n",
" 10298 | \n",
"
\n",
" \n",
" 10 | \n",
" PARIS 1ER ARRDT | \n",
" 1335 | \n",
"
\n",
" \n",
" 11 | \n",
" PARIS 20E ARRDT | \n",
" 12933 | \n",
"
\n",
" \n",
" 12 | \n",
" PARIS 2E ARRDT | \n",
" 537 | \n",
"
\n",
" \n",
" 13 | \n",
" PARIS 3E ARRDT | \n",
" 1200 | \n",
"
\n",
" \n",
" 14 | \n",
" PARIS 4E ARRDT | \n",
" 2690 | \n",
"
\n",
" \n",
" 15 | \n",
" PARIS 5E ARRDT | \n",
" 2341 | \n",
"
\n",
" \n",
" 16 | \n",
" PARIS 6E ARRDT | \n",
" 1754 | \n",
"
\n",
" \n",
" 17 | \n",
" PARIS 7E ARRDT | \n",
" 8507 | \n",
"
\n",
" \n",
" 18 | \n",
" PARIS 8E ARRDT | \n",
" 7062 | \n",
"
\n",
" \n",
" 19 | \n",
" PARIS 9E ARRDT | \n",
" 1098 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" ARRONDISSEMENT nbre_abres\n",
"0 PARIS 10E ARRDT 3106\n",
"1 PARIS 11E ARRDT 5529\n",
"2 PARIS 12E ARRDT 12159\n",
"3 PARIS 13E ARRDT 13824\n",
"4 PARIS 14E ARRDT 11358\n",
"5 PARIS 15E ARRDT 11442\n",
"6 PARIS 16E ARRDT 15012\n",
"7 PARIS 17E ARRDT 8678\n",
"8 PARIS 18E ARRDT 8454\n",
"9 PARIS 19E ARRDT 10298\n",
"10 PARIS 1ER ARRDT 1335\n",
"11 PARIS 20E ARRDT 12933\n",
"12 PARIS 2E ARRDT 537\n",
"13 PARIS 3E ARRDT 1200\n",
"14 PARIS 4E ARRDT 2690\n",
"15 PARIS 5E ARRDT 2341\n",
"16 PARIS 6E ARRDT 1754\n",
"17 PARIS 7E ARRDT 8507\n",
"18 PARIS 8E ARRDT 7062\n",
"19 PARIS 9E ARRDT 1098"
]
},
"execution_count": 78,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"gb"
]
},
{
"cell_type": "code",
"execution_count": 69,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"PARIS 16E ARRDT 15012\n",
"PARIS 13E ARRDT 13824\n",
"PARIS 20E ARRDT 12934\n",
"PARIS 12E ARRDT 12159\n",
"PARIS 15E ARRDT 11442\n",
"PARIS 14E ARRDT 11358\n",
"PARIS 19E ARRDT 10298\n",
"PARIS 17E ARRDT 8678\n",
"PARIS 7E ARRDT 8507\n",
"PARIS 18E ARRDT 8454\n",
"PARIS 8E ARRDT 7062\n",
"PARIS 11E ARRDT 5529\n",
"PARIS 10E ARRDT 3106\n",
"PARIS 4E ARRDT 2690\n",
"PARIS 5E ARRDT 2341\n",
"PARIS 6E ARRDT 1754\n",
"PARIS 1ER ARRDT 1335\n",
"PARIS 3E ARRDT 1200\n",
"PARIS 9E ARRDT 1098\n",
"PARIS 2E ARRDT 537\n",
"Name: ARRONDISSEMENT, dtype: int64"
]
},
"execution_count": 69,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['ARRONDISSEMENT'].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 79,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/Users/alexis/anaconda3/lib/python3.6/site-packages/ipykernel/__main__.py:11: SettingWithCopyWarning: \n",
"A value is trying to be set on a copy of a slice from a DataFrame.\n",
"Try using .loc[row_indexer,col_indexer] = value instead\n",
"\n",
"See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
]
},
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" ARRONDISSEMENT | \n",
" nbre_abres | \n",
" code_postal | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" PARIS 10E ARRDT | \n",
" 3106 | \n",
" 75110 | \n",
"
\n",
" \n",
" 1 | \n",
" PARIS 11E ARRDT | \n",
" 5529 | \n",
" 75111 | \n",
"
\n",
" \n",
" 2 | \n",
" PARIS 12E ARRDT | \n",
" 12159 | \n",
" 75112 | \n",
"
\n",
" \n",
" 3 | \n",
" PARIS 13E ARRDT | \n",
" 13824 | \n",
" 75113 | \n",
"
\n",
" \n",
" 4 | \n",
" PARIS 14E ARRDT | \n",
" 11358 | \n",
" 75114 | \n",
"
\n",
" \n",
" 5 | \n",
" PARIS 15E ARRDT | \n",
" 11442 | \n",
" 75115 | \n",
"
\n",
" \n",
" 6 | \n",
" PARIS 16E ARRDT | \n",
" 15012 | \n",
" 75116 | \n",
"
\n",
" \n",
" 7 | \n",
" PARIS 17E ARRDT | \n",
" 8678 | \n",
" 75117 | \n",
"
\n",
" \n",
" 8 | \n",
" PARIS 18E ARRDT | \n",
" 8454 | \n",
" 75118 | \n",
"
\n",
" \n",
" 9 | \n",
" PARIS 19E ARRDT | \n",
" 10298 | \n",
" 75119 | \n",
"
\n",
" \n",
" 10 | \n",
" PARIS 1ER ARRDT | \n",
" 1335 | \n",
" 75101 | \n",
"
\n",
" \n",
" 11 | \n",
" PARIS 20E ARRDT | \n",
" 12933 | \n",
" 75120 | \n",
"
\n",
" \n",
" 12 | \n",
" PARIS 2E ARRDT | \n",
" 537 | \n",
" 75102 | \n",
"
\n",
" \n",
" 13 | \n",
" PARIS 3E ARRDT | \n",
" 1200 | \n",
" 75103 | \n",
"
\n",
" \n",
" 14 | \n",
" PARIS 4E ARRDT | \n",
" 2690 | \n",
" 75104 | \n",
"
\n",
" \n",
" 15 | \n",
" PARIS 5E ARRDT | \n",
" 2341 | \n",
" 75105 | \n",
"
\n",
" \n",
" 16 | \n",
" PARIS 6E ARRDT | \n",
" 1754 | \n",
" 75106 | \n",
"
\n",
" \n",
" 17 | \n",
" PARIS 7E ARRDT | \n",
" 8507 | \n",
" 75107 | \n",
"
\n",
" \n",
" 18 | \n",
" PARIS 8E ARRDT | \n",
" 7062 | \n",
" 75108 | \n",
"
\n",
" \n",
" 19 | \n",
" PARIS 9E ARRDT | \n",
" 1098 | \n",
" 75109 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" ARRONDISSEMENT nbre_abres code_postal\n",
"0 PARIS 10E ARRDT 3106 75110\n",
"1 PARIS 11E ARRDT 5529 75111\n",
"2 PARIS 12E ARRDT 12159 75112\n",
"3 PARIS 13E ARRDT 13824 75113\n",
"4 PARIS 14E ARRDT 11358 75114\n",
"5 PARIS 15E ARRDT 11442 75115\n",
"6 PARIS 16E ARRDT 15012 75116\n",
"7 PARIS 17E ARRDT 8678 75117\n",
"8 PARIS 18E ARRDT 8454 75118\n",
"9 PARIS 19E ARRDT 10298 75119\n",
"10 PARIS 1ER ARRDT 1335 75101\n",
"11 PARIS 20E ARRDT 12933 75120\n",
"12 PARIS 2E ARRDT 537 75102\n",
"13 PARIS 3E ARRDT 1200 75103\n",
"14 PARIS 4E ARRDT 2690 75104\n",
"15 PARIS 5E ARRDT 2341 75105\n",
"16 PARIS 6E ARRDT 1754 75106\n",
"17 PARIS 7E ARRDT 8507 75107\n",
"18 PARIS 8E ARRDT 7062 75108\n",
"19 PARIS 9E ARRDT 1098 75109"
]
},
"execution_count": 79,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"\n",
"\n",
"def format_arrdt(texte):\n",
" '''\n",
" PARIS 3E ARRDT => 75103\n",
" '''\n",
" texte = '751' + texte.split(' ')[1].replace('E','').replace('R','').zfill(2) \n",
" return int(texte)\n",
" \n",
"\n",
"gb['code_postal'] = gb['ARRONDISSEMENT'].apply(lambda ardt : format_arrdt(ardt) )\n",
"gb "
]
},
{
"cell_type": "code",
"execution_count": 84,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" C_ARINSEE | \n",
" L_AR | \n",
" SURFACE | \n",
" PERIMETRE | \n",
" OBJECTID | \n",
" LONGUEUR | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 75102 | \n",
" 2ème Ardt | \n",
" 9.911537e+05 | \n",
" 4554.104360 | \n",
" 2 | \n",
" 4553.938764 | \n",
"
\n",
" \n",
" 1 | \n",
" 75103 | \n",
" 3ème Ardt | \n",
" 1.170883e+06 | \n",
" 4519.263648 | \n",
" 3 | \n",
" 4519.071982 | \n",
"
\n",
" \n",
" 2 | \n",
" 75112 | \n",
" 12ème Ardt | \n",
" 1.631478e+07 | \n",
" 24089.666298 | \n",
" 12 | \n",
" 24088.038922 | \n",
"
\n",
" \n",
" 3 | \n",
" 75101 | \n",
" 1er Ardt | \n",
" 1.824613e+06 | \n",
" 6054.936862 | \n",
" 1 | \n",
" 6054.680862 | \n",
"
\n",
" \n",
" 4 | \n",
" 75104 | \n",
" 4ème Ardt | \n",
" 1.600586e+06 | \n",
" 5420.908434 | \n",
" 4 | \n",
" 5420.636779 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" C_ARINSEE L_AR SURFACE PERIMETRE OBJECTID LONGUEUR\n",
"0 75102 2ème Ardt 9.911537e+05 4554.104360 2 4553.938764\n",
"1 75103 3ème Ardt 1.170883e+06 4519.263648 3 4519.071982\n",
"2 75112 12ème Ardt 1.631478e+07 24089.666298 12 24088.038922\n",
"3 75101 1er Ardt 1.824613e+06 6054.936862 1 6054.680862\n",
"4 75104 4ème Ardt 1.600586e+06 5420.908434 4 5420.636779"
]
},
"execution_count": 84,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"arrdt = pd.read_csv('../../data/arrondissements.csv', sep = ';')\n",
"arrdt.head()"
]
},
{
"cell_type": "code",
"execution_count": 85,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" code_postal | \n",
" L_AR | \n",
" SURFACE | \n",
" PERIMETRE | \n",
" OBJECTID | \n",
" LONGUEUR | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 75102 | \n",
" 2ème Ardt | \n",
" 9.911537e+05 | \n",
" 4554.104360 | \n",
" 2 | \n",
" 4553.938764 | \n",
"
\n",
" \n",
" 1 | \n",
" 75103 | \n",
" 3ème Ardt | \n",
" 1.170883e+06 | \n",
" 4519.263648 | \n",
" 3 | \n",
" 4519.071982 | \n",
"
\n",
" \n",
" 2 | \n",
" 75112 | \n",
" 12ème Ardt | \n",
" 1.631478e+07 | \n",
" 24089.666298 | \n",
" 12 | \n",
" 24088.038922 | \n",
"
\n",
" \n",
" 3 | \n",
" 75101 | \n",
" 1er Ardt | \n",
" 1.824613e+06 | \n",
" 6054.936862 | \n",
" 1 | \n",
" 6054.680862 | \n",
"
\n",
" \n",
" 4 | \n",
" 75104 | \n",
" 4ème Ardt | \n",
" 1.600586e+06 | \n",
" 5420.908434 | \n",
" 4 | \n",
" 5420.636779 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" code_postal L_AR SURFACE PERIMETRE OBJECTID LONGUEUR\n",
"0 75102 2ème Ardt 9.911537e+05 4554.104360 2 4553.938764\n",
"1 75103 3ème Ardt 1.170883e+06 4519.263648 3 4519.071982\n",
"2 75112 12ème Ardt 1.631478e+07 24089.666298 12 24088.038922\n",
"3 75101 1er Ardt 1.824613e+06 6054.936862 1 6054.680862\n",
"4 75104 4ème Ardt 1.600586e+06 5420.908434 4 5420.636779"
]
},
"execution_count": 85,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"arrdt.rename(columns = {'C_ARINSEE': 'code_postal'}, inplace = True)\n",
"arrdt.head()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"# join\n",
"\n",
"gb = gb.merge(arrdt, on = 'code_postal')\n",
"\n",
"gb"
]
},
{
"cell_type": "code",
"execution_count": 93,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" ARRONDISSEMENT | \n",
" nbre_abres | \n",
" SURFACE | \n",
" ratio | \n",
"
\n",
" \n",
" \n",
" \n",
" 11 | \n",
" PARIS 20E ARRDT | \n",
" 12933 | \n",
" 5.983446e+06 | \n",
" 0.002161 | \n",
"
\n",
" \n",
" 17 | \n",
" PARIS 7E ARRDT | \n",
" 8507 | \n",
" 4.090057e+06 | \n",
" 0.002080 | \n",
"
\n",
" \n",
" 4 | \n",
" PARIS 14E ARRDT | \n",
" 11358 | \n",
" 5.614877e+06 | \n",
" 0.002023 | \n",
"
\n",
" \n",
" 3 | \n",
" PARIS 13E ARRDT | \n",
" 13824 | \n",
" 7.149311e+06 | \n",
" 0.001934 | \n",
"
\n",
" \n",
" 18 | \n",
" PARIS 8E ARRDT | \n",
" 7062 | \n",
" 3.880036e+06 | \n",
" 0.001820 | \n",
"
\n",
" \n",
" 14 | \n",
" PARIS 4E ARRDT | \n",
" 2690 | \n",
" 1.600586e+06 | \n",
" 0.001681 | \n",
"
\n",
" \n",
" 7 | \n",
" PARIS 17E ARRDT | \n",
" 8678 | \n",
" 5.668835e+06 | \n",
" 0.001531 | \n",
"
\n",
" \n",
" 9 | \n",
" PARIS 19E ARRDT | \n",
" 10298 | \n",
" 6.792651e+06 | \n",
" 0.001516 | \n",
"
\n",
" \n",
" 1 | \n",
" PARIS 11E ARRDT | \n",
" 5529 | \n",
" 3.665442e+06 | \n",
" 0.001508 | \n",
"
\n",
" \n",
" 8 | \n",
" PARIS 18E ARRDT | \n",
" 8454 | \n",
" 5.996051e+06 | \n",
" 0.001410 | \n",
"
\n",
" \n",
" 5 | \n",
" PARIS 15E ARRDT | \n",
" 11442 | \n",
" 8.494994e+06 | \n",
" 0.001347 | \n",
"
\n",
" \n",
" 0 | \n",
" PARIS 10E ARRDT | \n",
" 3106 | \n",
" 2.891739e+06 | \n",
" 0.001074 | \n",
"
\n",
" \n",
" 13 | \n",
" PARIS 3E ARRDT | \n",
" 1200 | \n",
" 1.170883e+06 | \n",
" 0.001025 | \n",
"
\n",
" \n",
" 15 | \n",
" PARIS 5E ARRDT | \n",
" 2341 | \n",
" 2.539375e+06 | \n",
" 0.000922 | \n",
"
\n",
" \n",
" 6 | \n",
" PARIS 16E ARRDT | \n",
" 15012 | \n",
" 1.637254e+07 | \n",
" 0.000917 | \n",
"
\n",
" \n",
" 16 | \n",
" PARIS 6E ARRDT | \n",
" 1754 | \n",
" 2.153096e+06 | \n",
" 0.000815 | \n",
"
\n",
" \n",
" 2 | \n",
" PARIS 12E ARRDT | \n",
" 12159 | \n",
" 1.631478e+07 | \n",
" 0.000745 | \n",
"
\n",
" \n",
" 10 | \n",
" PARIS 1ER ARRDT | \n",
" 1335 | \n",
" 1.824613e+06 | \n",
" 0.000732 | \n",
"
\n",
" \n",
" 12 | \n",
" PARIS 2E ARRDT | \n",
" 537 | \n",
" 9.911537e+05 | \n",
" 0.000542 | \n",
"
\n",
" \n",
" 19 | \n",
" PARIS 9E ARRDT | \n",
" 1098 | \n",
" 2.178303e+06 | \n",
" 0.000504 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" ARRONDISSEMENT nbre_abres SURFACE ratio\n",
"11 PARIS 20E ARRDT 12933 5.983446e+06 0.002161\n",
"17 PARIS 7E ARRDT 8507 4.090057e+06 0.002080\n",
"4 PARIS 14E ARRDT 11358 5.614877e+06 0.002023\n",
"3 PARIS 13E ARRDT 13824 7.149311e+06 0.001934\n",
"18 PARIS 8E ARRDT 7062 3.880036e+06 0.001820\n",
"14 PARIS 4E ARRDT 2690 1.600586e+06 0.001681\n",
"7 PARIS 17E ARRDT 8678 5.668835e+06 0.001531\n",
"9 PARIS 19E ARRDT 10298 6.792651e+06 0.001516\n",
"1 PARIS 11E ARRDT 5529 3.665442e+06 0.001508\n",
"8 PARIS 18E ARRDT 8454 5.996051e+06 0.001410\n",
"5 PARIS 15E ARRDT 11442 8.494994e+06 0.001347\n",
"0 PARIS 10E ARRDT 3106 2.891739e+06 0.001074\n",
"13 PARIS 3E ARRDT 1200 1.170883e+06 0.001025\n",
"15 PARIS 5E ARRDT 2341 2.539375e+06 0.000922\n",
"6 PARIS 16E ARRDT 15012 1.637254e+07 0.000917\n",
"16 PARIS 6E ARRDT 1754 2.153096e+06 0.000815\n",
"2 PARIS 12E ARRDT 12159 1.631478e+07 0.000745\n",
"10 PARIS 1ER ARRDT 1335 1.824613e+06 0.000732\n",
"12 PARIS 2E ARRDT 537 9.911537e+05 0.000542\n",
"19 PARIS 9E ARRDT 1098 2.178303e+06 0.000504"
]
},
"execution_count": 93,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"gb['ratio'] = gb['nbre_abres'] / gb['SURFACE']\n",
"\n",
"gb.sort_values(by = 'ratio' , ascending = False, inplace= True)\n",
"\n",
"gb[['ARRONDISSEMENT', 'nbre_abres', 'SURFACE', 'ratio']]\n"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"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.6.2"
}
},
"nbformat": 4,
"nbformat_minor": 2
}