{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic = pd.read_csv('https://data.orleans-metropole.fr/explore/dataset/donnees-calcul-indicateur-fragilite-numerique-orleans-metropole/download/?format=csv&timezone=Europe/Berlin&lang=fr&use_labels_for_header=true&csv_separator=%3B', delimiter = ';')\n",
    "pd.set_option('display.max_columns', None)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cantville</th>\n",
       "      <th>depcom</th>\n",
       "      <th>LIBCOM</th>\n",
       "      <th>iris</th>\n",
       "      <th>LIB_IRIS</th>\n",
       "      <th>geom</th>\n",
       "      <th>centroid</th>\n",
       "      <th>POPLEG</th>\n",
       "      <th>NB15_29</th>\n",
       "      <th>NB65+</th>\n",
       "      <th>NBMONOFAM</th>\n",
       "      <th>NBMEN1P</th>\n",
       "      <th>NBCHOM15_64</th>\n",
       "      <th>NB15NSCONDIPL</th>\n",
       "      <th>NBIMMI</th>\n",
       "      <th>NBMENTOT</th>\n",
       "      <th>PartNBMONOFAM</th>\n",
       "      <th>PartNB15_29</th>\n",
       "      <th>PartNB65+</th>\n",
       "      <th>PartNBIMMI</th>\n",
       "      <th>PartNBMEN1P</th>\n",
       "      <th>PartNBCHOM15_64</th>\n",
       "      <th>PartNB15NSCONDIPL</th>\n",
       "      <th>PERCOU</th>\n",
       "      <th>NBequip</th>\n",
       "      <th>Medrev</th>\n",
       "      <th>Tx_pauvre</th>\n",
       "      <th>couverture_mobile</th>\n",
       "      <th>Taux logements raccordables</th>\n",
       "      <th>couverture_mobilebis</th>\n",
       "      <th>Taux logements raccordablesbis</th>\n",
       "      <th>NBequipbis</th>\n",
       "      <th>PERCOUbis</th>\n",
       "      <th>POPCOM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4506</td>\n",
       "      <td>45147</td>\n",
       "      <td>Fleury-les-Aubrais</td>\n",
       "      <td>451470201</td>\n",
       "      <td>Ormes du Mail-Andrillons</td>\n",
       "      <td>{\"type\": \"Polygon\", \"coordinates\": [[[1.910813...</td>\n",
       "      <td>47.936786715,1.913287154</td>\n",
       "      <td>1159</td>\n",
       "      <td>189</td>\n",
       "      <td>105</td>\n",
       "      <td>293.0</td>\n",
       "      <td>164</td>\n",
       "      <td>169</td>\n",
       "      <td>259</td>\n",
       "      <td>360</td>\n",
       "      <td>480</td>\n",
       "      <td>0.252804</td>\n",
       "      <td>0.163072</td>\n",
       "      <td>0.090595</td>\n",
       "      <td>0.310613</td>\n",
       "      <td>0.141501</td>\n",
       "      <td>0.145815</td>\n",
       "      <td>0.223469</td>\n",
       "      <td>1753.000000</td>\n",
       "      <td>2.184615</td>\n",
       "      <td>19570.0</td>\n",
       "      <td>20.00000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1753.0</td>\n",
       "      <td>8275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4506</td>\n",
       "      <td>45147</td>\n",
       "      <td>Fleury-les-Aubrais</td>\n",
       "      <td>451470401</td>\n",
       "      <td>Gare</td>\n",
       "      <td>{\"type\": \"Polygon\", \"coordinates\": [[[1.910813...</td>\n",
       "      <td>47.930713007,1.903882118</td>\n",
       "      <td>1964</td>\n",
       "      <td>321</td>\n",
       "      <td>347</td>\n",
       "      <td>147.0</td>\n",
       "      <td>407</td>\n",
       "      <td>128</td>\n",
       "      <td>343</td>\n",
       "      <td>183</td>\n",
       "      <td>959</td>\n",
       "      <td>0.074847</td>\n",
       "      <td>0.163442</td>\n",
       "      <td>0.176680</td>\n",
       "      <td>0.093177</td>\n",
       "      <td>0.207230</td>\n",
       "      <td>0.065173</td>\n",
       "      <td>0.174644</td>\n",
       "      <td>2222.000000</td>\n",
       "      <td>2.184615</td>\n",
       "      <td>19570.0</td>\n",
       "      <td>20.00000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2222.0</td>\n",
       "      <td>8275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4506</td>\n",
       "      <td>45147</td>\n",
       "      <td>Fleury-les-Aubrais</td>\n",
       "      <td>451470301</td>\n",
       "      <td>Mairie</td>\n",
       "      <td>{\"type\": \"Polygon\", \"coordinates\": [[[1.916218...</td>\n",
       "      <td>47.932491481,1.922177216</td>\n",
       "      <td>700</td>\n",
       "      <td>104</td>\n",
       "      <td>196</td>\n",
       "      <td>71.0</td>\n",
       "      <td>153</td>\n",
       "      <td>42</td>\n",
       "      <td>135</td>\n",
       "      <td>88</td>\n",
       "      <td>350</td>\n",
       "      <td>0.101429</td>\n",
       "      <td>0.148571</td>\n",
       "      <td>0.280000</td>\n",
       "      <td>0.125714</td>\n",
       "      <td>0.218571</td>\n",
       "      <td>0.060000</td>\n",
       "      <td>0.192857</td>\n",
       "      <td>781.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>19570.0</td>\n",
       "      <td>20.00000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>781.0</td>\n",
       "      <td>8275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4506</td>\n",
       "      <td>45147</td>\n",
       "      <td>Fleury-les-Aubrais</td>\n",
       "      <td>451470402</td>\n",
       "      <td>Clos De La Grande Salle</td>\n",
       "      <td>{\"type\": \"Polygon\", \"coordinates\": [[[1.909067...</td>\n",
       "      <td>47.931948996,1.909870169</td>\n",
       "      <td>1041</td>\n",
       "      <td>219</td>\n",
       "      <td>107</td>\n",
       "      <td>209.0</td>\n",
       "      <td>148</td>\n",
       "      <td>122</td>\n",
       "      <td>234</td>\n",
       "      <td>242</td>\n",
       "      <td>427</td>\n",
       "      <td>0.200768</td>\n",
       "      <td>0.210375</td>\n",
       "      <td>0.102786</td>\n",
       "      <td>0.232469</td>\n",
       "      <td>0.142171</td>\n",
       "      <td>0.117195</td>\n",
       "      <td>0.224784</td>\n",
       "      <td>1700.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>19570.0</td>\n",
       "      <td>20.00000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>8275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4506</td>\n",
       "      <td>45147</td>\n",
       "      <td>Fleury-les-Aubrais</td>\n",
       "      <td>451470101</td>\n",
       "      <td>Escures</td>\n",
       "      <td>{\"type\": \"Polygon\", \"coordinates\": [[[1.951294...</td>\n",
       "      <td>47.950798126,1.927870312</td>\n",
       "      <td>70</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>0.042857</td>\n",
       "      <td>0.214286</td>\n",
       "      <td>0.157143</td>\n",
       "      <td>0.028571</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.028571</td>\n",
       "      <td>0.385714</td>\n",
       "      <td>173.000000</td>\n",
       "      <td>2.184615</td>\n",
       "      <td>19570.0</td>\n",
       "      <td>20.00000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>8275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>4518</td>\n",
       "      <td>45089</td>\n",
       "      <td>Chécy</td>\n",
       "      <td>450890103</td>\n",
       "      <td>Ouest</td>\n",
       "      <td>{\"type\": \"Polygon\", \"coordinates\": [[[2.006123...</td>\n",
       "      <td>47.901178887,2.010764271</td>\n",
       "      <td>853</td>\n",
       "      <td>116</td>\n",
       "      <td>132</td>\n",
       "      <td>94.0</td>\n",
       "      <td>66</td>\n",
       "      <td>51</td>\n",
       "      <td>100</td>\n",
       "      <td>58</td>\n",
       "      <td>325</td>\n",
       "      <td>0.110199</td>\n",
       "      <td>0.135991</td>\n",
       "      <td>0.154748</td>\n",
       "      <td>0.067995</td>\n",
       "      <td>0.077374</td>\n",
       "      <td>0.059789</td>\n",
       "      <td>0.117233</td>\n",
       "      <td>1390.192771</td>\n",
       "      <td>2.184615</td>\n",
       "      <td>24190.0</td>\n",
       "      <td>6.00000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>4505</td>\n",
       "      <td>45272</td>\n",
       "      <td>Saint-Cyr-en-Val</td>\n",
       "      <td>452720000</td>\n",
       "      <td>Saint-Cyr-en-Val (commune non irisée)</td>\n",
       "      <td>{\"type\": \"MultiPolygon\", \"coordinates\": [[[[1....</td>\n",
       "      <td>47.814310536,1.959794793</td>\n",
       "      <td>3458</td>\n",
       "      <td>458</td>\n",
       "      <td>691</td>\n",
       "      <td>262.0</td>\n",
       "      <td>396</td>\n",
       "      <td>141</td>\n",
       "      <td>626</td>\n",
       "      <td>139</td>\n",
       "      <td>1456</td>\n",
       "      <td>0.075766</td>\n",
       "      <td>0.132447</td>\n",
       "      <td>0.199826</td>\n",
       "      <td>0.040197</td>\n",
       "      <td>0.114517</td>\n",
       "      <td>0.040775</td>\n",
       "      <td>0.181029</td>\n",
       "      <td>1390.192771</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>26440.0</td>\n",
       "      <td>16.37037</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>0.957474</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.957474</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>4506</td>\n",
       "      <td>45197</td>\n",
       "      <td>Marigny-les-Usages</td>\n",
       "      <td>451970000</td>\n",
       "      <td>Marigny-les-Usages (commune non irisée)</td>\n",
       "      <td>{\"type\": \"Polygon\", \"coordinates\": [[[2.041819...</td>\n",
       "      <td>47.958746605,2.013526751</td>\n",
       "      <td>2431</td>\n",
       "      <td>345</td>\n",
       "      <td>322</td>\n",
       "      <td>177.0</td>\n",
       "      <td>171</td>\n",
       "      <td>93</td>\n",
       "      <td>323</td>\n",
       "      <td>79</td>\n",
       "      <td>925</td>\n",
       "      <td>0.072810</td>\n",
       "      <td>0.141917</td>\n",
       "      <td>0.132456</td>\n",
       "      <td>0.032497</td>\n",
       "      <td>0.070341</td>\n",
       "      <td>0.038256</td>\n",
       "      <td>0.132867</td>\n",
       "      <td>1390.192771</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>25150.0</td>\n",
       "      <td>16.37037</td>\n",
       "      <td>42.834862</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>4512</td>\n",
       "      <td>45282</td>\n",
       "      <td>Saint-Hilaire-Saint-Mesmin</td>\n",
       "      <td>452820000</td>\n",
       "      <td>Saint-Hilaire-Saint-Mesmin (commune non irisée)</td>\n",
       "      <td>{\"type\": \"Polygon\", \"coordinates\": [[[1.860935...</td>\n",
       "      <td>47.849857494,1.833923695</td>\n",
       "      <td>615</td>\n",
       "      <td>65</td>\n",
       "      <td>112</td>\n",
       "      <td>49.0</td>\n",
       "      <td>68</td>\n",
       "      <td>18</td>\n",
       "      <td>91</td>\n",
       "      <td>32</td>\n",
       "      <td>259</td>\n",
       "      <td>0.079675</td>\n",
       "      <td>0.105691</td>\n",
       "      <td>0.182114</td>\n",
       "      <td>0.052033</td>\n",
       "      <td>0.110569</td>\n",
       "      <td>0.029268</td>\n",
       "      <td>0.147967</td>\n",
       "      <td>1390.192771</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>26360.0</td>\n",
       "      <td>16.37037</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.664460</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.664460</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>4518</td>\n",
       "      <td>45308</td>\n",
       "      <td>Semoy</td>\n",
       "      <td>453080000</td>\n",
       "      <td>Semoy (commune non irisée)</td>\n",
       "      <td>{\"type\": \"Polygon\", \"coordinates\": [[[1.943500...</td>\n",
       "      <td>47.93787436,1.963016093</td>\n",
       "      <td>1910</td>\n",
       "      <td>272</td>\n",
       "      <td>300</td>\n",
       "      <td>178.0</td>\n",
       "      <td>161</td>\n",
       "      <td>71</td>\n",
       "      <td>298</td>\n",
       "      <td>128</td>\n",
       "      <td>764</td>\n",
       "      <td>0.093194</td>\n",
       "      <td>0.142408</td>\n",
       "      <td>0.157068</td>\n",
       "      <td>0.067016</td>\n",
       "      <td>0.084293</td>\n",
       "      <td>0.037173</td>\n",
       "      <td>0.156021</td>\n",
       "      <td>1390.192771</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>24940.0</td>\n",
       "      <td>6.00000</td>\n",
       "      <td>42.834862</td>\n",
       "      <td>0.847573</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.847573</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1910</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>111 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     cantville  depcom                      LIBCOM       iris  \\\n",
       "0         4506   45147          Fleury-les-Aubrais  451470201   \n",
       "1         4506   45147          Fleury-les-Aubrais  451470401   \n",
       "2         4506   45147          Fleury-les-Aubrais  451470301   \n",
       "3         4506   45147          Fleury-les-Aubrais  451470402   \n",
       "4         4506   45147          Fleury-les-Aubrais  451470101   \n",
       "..         ...     ...                         ...        ...   \n",
       "106       4518   45089                       Chécy  450890103   \n",
       "107       4505   45272            Saint-Cyr-en-Val  452720000   \n",
       "108       4506   45197          Marigny-les-Usages  451970000   \n",
       "109       4512   45282  Saint-Hilaire-Saint-Mesmin  452820000   \n",
       "110       4518   45308                       Semoy  453080000   \n",
       "\n",
       "                                            LIB_IRIS  \\\n",
       "0                           Ormes du Mail-Andrillons   \n",
       "1                                               Gare   \n",
       "2                                             Mairie   \n",
       "3                            Clos De La Grande Salle   \n",
       "4                                            Escures   \n",
       "..                                               ...   \n",
       "106                                            Ouest   \n",
       "107            Saint-Cyr-en-Val (commune non irisée)   \n",
       "108          Marigny-les-Usages (commune non irisée)   \n",
       "109  Saint-Hilaire-Saint-Mesmin (commune non irisée)   \n",
       "110                       Semoy (commune non irisée)   \n",
       "\n",
       "                                                  geom  \\\n",
       "0    {\"type\": \"Polygon\", \"coordinates\": [[[1.910813...   \n",
       "1    {\"type\": \"Polygon\", \"coordinates\": [[[1.910813...   \n",
       "2    {\"type\": \"Polygon\", \"coordinates\": [[[1.916218...   \n",
       "3    {\"type\": \"Polygon\", \"coordinates\": [[[1.909067...   \n",
       "4    {\"type\": \"Polygon\", \"coordinates\": [[[1.951294...   \n",
       "..                                                 ...   \n",
       "106  {\"type\": \"Polygon\", \"coordinates\": [[[2.006123...   \n",
       "107  {\"type\": \"MultiPolygon\", \"coordinates\": [[[[1....   \n",
       "108  {\"type\": \"Polygon\", \"coordinates\": [[[2.041819...   \n",
       "109  {\"type\": \"Polygon\", \"coordinates\": [[[1.860935...   \n",
       "110  {\"type\": \"Polygon\", \"coordinates\": [[[1.943500...   \n",
       "\n",
       "                     centroid  POPLEG  NB15_29  NB65+  NBMONOFAM  NBMEN1P  \\\n",
       "0    47.936786715,1.913287154    1159      189    105      293.0      164   \n",
       "1    47.930713007,1.903882118    1964      321    347      147.0      407   \n",
       "2    47.932491481,1.922177216     700      104    196       71.0      153   \n",
       "3    47.931948996,1.909870169    1041      219    107      209.0      148   \n",
       "4    47.950798126,1.927870312      70       15     11        3.0        7   \n",
       "..                        ...     ...      ...    ...        ...      ...   \n",
       "106  47.901178887,2.010764271     853      116    132       94.0       66   \n",
       "107  47.814310536,1.959794793    3458      458    691      262.0      396   \n",
       "108  47.958746605,2.013526751    2431      345    322      177.0      171   \n",
       "109  47.849857494,1.833923695     615       65    112       49.0       68   \n",
       "110   47.93787436,1.963016093    1910      272    300      178.0      161   \n",
       "\n",
       "     NBCHOM15_64  NB15NSCONDIPL  NBIMMI  NBMENTOT  PartNBMONOFAM  PartNB15_29  \\\n",
       "0            169            259     360       480       0.252804     0.163072   \n",
       "1            128            343     183       959       0.074847     0.163442   \n",
       "2             42            135      88       350       0.101429     0.148571   \n",
       "3            122            234     242       427       0.200768     0.210375   \n",
       "4              2             27       2        13       0.042857     0.214286   \n",
       "..           ...            ...     ...       ...            ...          ...   \n",
       "106           51            100      58       325       0.110199     0.135991   \n",
       "107          141            626     139      1456       0.075766     0.132447   \n",
       "108           93            323      79       925       0.072810     0.141917   \n",
       "109           18             91      32       259       0.079675     0.105691   \n",
       "110           71            298     128       764       0.093194     0.142408   \n",
       "\n",
       "     PartNB65+  PartNBIMMI  PartNBMEN1P  PartNBCHOM15_64  PartNB15NSCONDIPL  \\\n",
       "0     0.090595    0.310613     0.141501         0.145815           0.223469   \n",
       "1     0.176680    0.093177     0.207230         0.065173           0.174644   \n",
       "2     0.280000    0.125714     0.218571         0.060000           0.192857   \n",
       "3     0.102786    0.232469     0.142171         0.117195           0.224784   \n",
       "4     0.157143    0.028571     0.100000         0.028571           0.385714   \n",
       "..         ...         ...          ...              ...                ...   \n",
       "106   0.154748    0.067995     0.077374         0.059789           0.117233   \n",
       "107   0.199826    0.040197     0.114517         0.040775           0.181029   \n",
       "108   0.132456    0.032497     0.070341         0.038256           0.132867   \n",
       "109   0.182114    0.052033     0.110569         0.029268           0.147967   \n",
       "110   0.157068    0.067016     0.084293         0.037173           0.156021   \n",
       "\n",
       "          PERCOU   NBequip   Medrev  Tx_pauvre  couverture_mobile  \\\n",
       "0    1753.000000  2.184615  19570.0   20.00000          23.000000   \n",
       "1    2222.000000  2.184615  19570.0   20.00000          23.000000   \n",
       "2     781.000000  1.000000  19570.0   20.00000          23.000000   \n",
       "3    1700.000000  1.000000  19570.0   20.00000          23.000000   \n",
       "4     173.000000  2.184615  19570.0   20.00000          23.000000   \n",
       "..           ...       ...      ...        ...                ...   \n",
       "106  1390.192771  2.184615  24190.0    6.00000           8.000000   \n",
       "107  1390.192771  5.000000  26440.0   16.37037           8.000000   \n",
       "108  1390.192771  2.000000  25150.0   16.37037          42.834862   \n",
       "109  1390.192771  2.000000  26360.0   16.37037           1.000000   \n",
       "110  1390.192771  3.000000  24940.0    6.00000          42.834862   \n",
       "\n",
       "     Taux logements raccordables  couverture_mobilebis  \\\n",
       "0                       1.000000                  23.0   \n",
       "1                       1.000000                  23.0   \n",
       "2                       1.000000                  23.0   \n",
       "3                       1.000000                  23.0   \n",
       "4                       1.000000                  23.0   \n",
       "..                           ...                   ...   \n",
       "106                     1.000000                   8.0   \n",
       "107                     0.957474                   8.0   \n",
       "108                     1.000000                   0.0   \n",
       "109                     0.664460                   1.0   \n",
       "110                     0.847573                   0.0   \n",
       "\n",
       "     Taux logements raccordablesbis  NBequipbis  PERCOUbis  POPCOM  \n",
       "0                          1.000000         0.0     1753.0    8275  \n",
       "1                          1.000000         0.0     2222.0    8275  \n",
       "2                          1.000000         1.0      781.0    8275  \n",
       "3                          1.000000         1.0     1700.0    8275  \n",
       "4                          1.000000         0.0      173.0    8275  \n",
       "..                              ...         ...        ...     ...  \n",
       "106                        1.000000         0.0        0.0    1726  \n",
       "107                        0.957474         5.0        0.0    3458  \n",
       "108                        1.000000         2.0        0.0    2431  \n",
       "109                        0.664460         2.0        0.0     615  \n",
       "110                        0.847573         3.0        0.0    1910  \n",
       "\n",
       "[111 rows x 34 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic = indic.rename(columns={\"Nombre d'antennes\":\"couverture_mobile\", 'Tx pauvreté':'Tx_pauvre','Logements raccordables / commune':'Taux logements raccordables'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['cantville', 'depcom', 'LIBCOM', 'iris', 'LIB_IRIS', 'geom', 'centroid',\n",
       "       'POPLEG', 'NB15_29', 'NB65+', 'NBMONOFAM', 'NBMEN1P', 'NBCHOM15_64',\n",
       "       'NB15NSCONDIPL', 'NBIMMI', 'NBMENTOT', 'PartNBMONOFAM', 'PartNB15_29',\n",
       "       'PartNB65+', 'PartNBIMMI', 'PartNBMEN1P', 'PartNBCHOM15_64',\n",
       "       'PartNB15NSCONDIPL', 'PERCOU', 'NBequip', 'Medrev', 'Tx_pauvre',\n",
       "       'couverture_mobile', 'Taux logements raccordables'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indic.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Pour les équipements (antennes, services publics, fibres), les NaN sont remplacés par 0 car on estime que si la valeur est manquante, c'est qu'il n'y a pas d'équipement à cet endroit\n",
    "indic_na_zero = indic[[\"couverture_mobile\",'Taux logements raccordables','NBequip', 'PERCOU']]\n",
    "for l in indic_na_zero:\n",
    "    newcol = l + 'bis'\n",
    "    indic[newcol] = indic[l].fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Pour les autres variables (ex: taux de pauvreté), les valeurs manquantes sont remplacés par la moyenne des 22 communes\n",
    "# cf. MEDNUM qui avait remplacé par les moyennes régionales \n",
    "for i in indic.columns[indic.isnull().any(axis=0)]:\n",
    "    indic[i].fillna(indic[i].mean(),inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-11-0daf5eb15459>:1: FutureWarning: Indexing with multiple keys (implicitly converted to a tuple of keys) will be deprecated, use a list instead.\n",
      "  popcom = indic.groupby(['depcom'])['POPLEG', 'iris'].sum()\n"
     ]
    }
   ],
   "source": [
    "popcom = indic.groupby(['depcom'])['POPLEG', 'iris'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "popcom = popcom.drop(columns = ['iris'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "popcom = popcom.rename(columns={'POPLEG':'POPCOM'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>POPCOM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>depcom</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>45075</th>\n",
       "      <td>2032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45089</th>\n",
       "      <td>1726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45147</th>\n",
       "      <td>8275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45169</th>\n",
       "      <td>1888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45197</th>\n",
       "      <td>2431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45232</th>\n",
       "      <td>7965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45234</th>\n",
       "      <td>44183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45235</th>\n",
       "      <td>828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45272</th>\n",
       "      <td>3458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45274</th>\n",
       "      <td>1497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45282</th>\n",
       "      <td>615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45284</th>\n",
       "      <td>7813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45285</th>\n",
       "      <td>6188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45286</th>\n",
       "      <td>1724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45298</th>\n",
       "      <td>1212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45302</th>\n",
       "      <td>6297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45308</th>\n",
       "      <td>1910</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        POPCOM\n",
       "depcom        \n",
       "45075     2032\n",
       "45089     1726\n",
       "45147     8275\n",
       "45169     1888\n",
       "45197     2431\n",
       "45232     7965\n",
       "45234    44183\n",
       "45235      828\n",
       "45272     3458\n",
       "45274     1497\n",
       "45282      615\n",
       "45284     7813\n",
       "45285     6188\n",
       "45286     1724\n",
       "45298     1212\n",
       "45302     6297\n",
       "45308     1910"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "popcom"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic = indic.merge(popcom, how='inner', on='depcom')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic = indic.rename(columns={'POPCOM_y':'POPCOM'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic['equip_ind']= indic['NBequipbis']/indic['POPLEG']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic['taux_percou'] = indic['PERCOUbis']/indic['POPCOM']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic.loc[(indic.couverture_mobilebis > 0), 'couverture_mobilebis']=100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic['non_couv_mobile']= 100-indic['couverture_mobilebis']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic['tx_logement_non_raccordable']= 100-(indic['Taux logements raccordablesbis'])*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "group = indic[['depcom','Tx_pauvre','non_couv_mobile','tx_logement_non_raccordable','Medrev','taux_percou']]\n",
    "com = group.groupby(['depcom']).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "com = group.groupby(['depcom']).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Tx_pauvre</th>\n",
       "      <th>non_couv_mobile</th>\n",
       "      <th>tx_logement_non_raccordable</th>\n",
       "      <th>Medrev</th>\n",
       "      <th>taux_percou</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>depcom</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>45075</th>\n",
       "      <td>10.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>22000.0</td>\n",
       "      <td>0.615527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45089</th>\n",
       "      <td>6.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>24190.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45147</th>\n",
       "      <td>20.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>19570.0</td>\n",
       "      <td>0.155636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45169</th>\n",
       "      <td>9.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.008115</td>\n",
       "      <td>22930.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45197</th>\n",
       "      <td>16.37037</td>\n",
       "      <td>100.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>25150.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45232</th>\n",
       "      <td>7.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>25630.0</td>\n",
       "      <td>0.137811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45234</th>\n",
       "      <td>21.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71.004468</td>\n",
       "      <td>19480.0</td>\n",
       "      <td>0.030674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45235</th>\n",
       "      <td>5.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.754839</td>\n",
       "      <td>24070.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45272</th>\n",
       "      <td>16.37037</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.252577</td>\n",
       "      <td>26440.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45274</th>\n",
       "      <td>6.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.670046</td>\n",
       "      <td>25810.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45282</th>\n",
       "      <td>16.37037</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.553952</td>\n",
       "      <td>26360.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45284</th>\n",
       "      <td>15.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56.617369</td>\n",
       "      <td>20870.0</td>\n",
       "      <td>0.151485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45285</th>\n",
       "      <td>23.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.531110</td>\n",
       "      <td>18200.0</td>\n",
       "      <td>0.190550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45286</th>\n",
       "      <td>9.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.105673</td>\n",
       "      <td>24350.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45298</th>\n",
       "      <td>9.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.080676</td>\n",
       "      <td>23880.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45302</th>\n",
       "      <td>14.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.187971</td>\n",
       "      <td>21180.0</td>\n",
       "      <td>0.207506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45308</th>\n",
       "      <td>6.00000</td>\n",
       "      <td>100.0</td>\n",
       "      <td>15.242668</td>\n",
       "      <td>24940.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Tx_pauvre  non_couv_mobile  tx_logement_non_raccordable   Medrev  \\\n",
       "depcom                                                                     \n",
       "45075    10.00000              0.0                     0.000000  22000.0   \n",
       "45089     6.00000              0.0                     0.000000  24190.0   \n",
       "45147    20.00000              0.0                     0.000000  19570.0   \n",
       "45169     9.00000              0.0                    12.008115  22930.0   \n",
       "45197    16.37037            100.0                     0.000000  25150.0   \n",
       "45232     7.00000              0.0                     0.000000  25630.0   \n",
       "45234    21.00000              0.0                    71.004468  19480.0   \n",
       "45235     5.00000              0.0                    10.754839  24070.0   \n",
       "45272    16.37037              0.0                     4.252577  26440.0   \n",
       "45274     6.00000              0.0                     3.670046  25810.0   \n",
       "45282    16.37037              0.0                    33.553952  26360.0   \n",
       "45284    15.00000              0.0                    56.617369  20870.0   \n",
       "45285    23.00000              0.0                    18.531110  18200.0   \n",
       "45286     9.00000              0.0                    19.105673  24350.0   \n",
       "45298     9.00000              0.0                    15.080676  23880.0   \n",
       "45302    14.00000              0.0                    12.187971  21180.0   \n",
       "45308     6.00000            100.0                    15.242668  24940.0   \n",
       "\n",
       "        taux_percou  \n",
       "depcom               \n",
       "45075      0.615527  \n",
       "45089      0.000000  \n",
       "45147      0.155636  \n",
       "45169      0.000000  \n",
       "45197      0.000000  \n",
       "45232      0.137811  \n",
       "45234      0.030674  \n",
       "45235      0.000000  \n",
       "45272      0.000000  \n",
       "45274      0.000000  \n",
       "45282      0.000000  \n",
       "45284      0.151485  \n",
       "45285      0.190550  \n",
       "45286      0.000000  \n",
       "45298      0.000000  \n",
       "45302      0.207506  \n",
       "45308      0.000000  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "com"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "listcol1 = ['PartNBMONOFAM', 'PartNB15_29',\n",
    "       'PartNB65+', 'PartNBIMMI', 'PartNBMEN1P', 'PartNBCHOM15_64',\n",
    "       'PartNB15NSCONDIPL','equip_ind']\n",
    "for l in listcol1:\n",
    "    newcol = \"pt_\" + l \n",
    "    indic[newcol] = ((indic[l]-indic[l].mean())/indic[l].mean()+1)*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "listcol2 = ['Tx_pauvre', 'non_couv_mobile',\n",
    "       'tx_logement_non_raccordable','taux_percou']\n",
    "for l in listcol2:\n",
    "    newcol = \"pt_\" + l \n",
    "    indic[newcol] = ((indic[l]-com[l].mean())/com[l].mean()+1)*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "16.000556696888367"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "com['tx_logement_non_raccordable'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Revenu médian sur Orléans métropole: 21420 euros\n",
    "m = 21420\n",
    "indic['pt_Medrev'] = ((m-indic['Medrev'])/m+1)*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['cantville', 'depcom', 'LIBCOM', 'iris', 'LIB_IRIS', 'geom', 'centroid',\n",
       "       'POPLEG', 'NB15_29', 'NB65+', 'NBMONOFAM', 'NBMEN1P', 'NBCHOM15_64',\n",
       "       'NB15NSCONDIPL', 'NBIMMI', 'NBMENTOT', 'PartNBMONOFAM', 'PartNB15_29',\n",
       "       'PartNB65+', 'PartNBIMMI', 'PartNBMEN1P', 'PartNBCHOM15_64',\n",
       "       'PartNB15NSCONDIPL', 'PERCOU', 'NBequip', 'Medrev', 'Tx_pauvre',\n",
       "       'couverture_mobile', 'Taux logements raccordables',\n",
       "       'couverture_mobilebis', 'Taux logements raccordablesbis', 'NBequipbis',\n",
       "       'PERCOUbis', 'POPCOM', 'equip_ind', 'taux_percou', 'non_couv_mobile',\n",
       "       'tx_logement_non_raccordable', 'pt_PartNBMONOFAM', 'pt_PartNB15_29',\n",
       "       'pt_PartNB65+', 'pt_PartNBIMMI', 'pt_PartNBMEN1P', 'pt_PartNBCHOM15_64',\n",
       "       'pt_PartNB15NSCONDIPL', 'pt_equip_ind', 'pt_Tx_pauvre',\n",
       "       'pt_non_couv_mobile', 'pt_tx_logement_non_raccordable',\n",
       "       'pt_taux_percou', 'pt_Medrev'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indic.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic['acces_numerique']= (indic['pt_Medrev']+indic['pt_Tx_pauvre']+indic['pt_non_couv_mobile']+indic['pt_tx_logement_non_raccordable'])*100/400\n",
    "indic['acces_info']= (indic['pt_PartNBMONOFAM']+ indic['pt_PartNBMEN1P']+indic['pt_equip_ind']+indic['pt_PartNBIMMI'])*100/400\n",
    "indic['competence_administrative'] = (indic['pt_PartNB15_29']+indic['pt_PartNBCHOM15_64']+indic['pt_taux_percou'])*100/300\n",
    "indic['competence_numerique'] = (indic['pt_PartNB65+']+indic['pt_PartNB15NSCONDIPL'])*100/200"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic['acces_global'] = (indic['acces_numerique']+indic['acces_info'])*100/200\n",
    "indic['competence_global'] = (indic['competence_administrative']+indic['competence_numerique'])*100/200\n",
    "indic['score_global'] = (indic['acces_global']+indic['competence_global'])*100/200"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic_fragi = indic[['cantville','depcom','LIBCOM','iris','LIB_IRIS','geom', 'centroid','POPLEG','POPCOM','acces_numerique','acces_info','competence_administrative','acces_global','competence_global','score_global']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic_fragi.to_csv(r\"C:\\Users\\neury\\Documents\\Python\\fragilite_numerique\\sorties\\indic_fragi_scores.csv\", index = True, header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "indic.to_csv (r\"C:\\Users\\neury\\Documents\\Python\\fragilite_numerique\\sorties\\indic_fragi_all_data.csv\", index = True, header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}