{"cells": [{"cell_type": "markdown", "metadata": {}, "source": ["# Donn\u00e9es INSEE\n", "\n", "Pr\u00e9traitement des donn\u00e9es IRIS."]}, {"cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [{"data": {"text/html": ["
\n", ""], "text/plain": ["\n", " | WKT | \n", "idINSPIRE | \n", "id | \n", "idk | \n", "ind_c | \n", "nbcar | \n", "men | \n", "men_surf | \n", "men_occ5 | \n", "men_coll | \n", "... | \n", "ind_age2 | \n", "ind_age3 | \n", "ind_age4 | \n", "ind_age5 | \n", "ind_age6 | \n", "ind_age7 | \n", "i_age7 | \n", "ind_age8 | \n", "i_age8 | \n", "ind_srf | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "POLYGON((2.6529953850426 46.440123156379,2.655... | \n", "CRS3035RES200mN2619600E3756800 | \n", "LAEA200M_N13098E18784 | \n", "N13090E18781-N13103E18788 | \n", "4.0 | \n", "13 | \n", "24 | \n", "2353 | \n", "19 | \n", "0 | \n", "... | \n", "3.0 | \n", "2.0 | \n", "1.0 | \n", "2.5 | \n", "45.0 | \n", "11.0 | \n", "0 | \n", "9.0 | \n", "0 | \n", "1083644 | \n", "
1 | \n", "POLYGON((6.679135345427 46.191522591301,6.6817... | \n", "CRS3035RES200mN2569800E4064400 | \n", "LAEA200M_N12849E20322 | \n", "N12849E20321-N12849E20324 | \n", "1.0 | \n", "4 | \n", "15 | \n", "1162 | \n", "5 | \n", "7 | \n", "... | \n", "0.0 | \n", "2.0 | \n", "1.0 | \n", "2.5 | \n", "28.0 | \n", "3.0 | \n", "0 | \n", "3.0 | \n", "0 | \n", "725512 | \n", "
2 | \n", "POLYGON((-1.9122518974954 48.142412902797,-1.9... | \n", "CRS3035RES200mN2852200E3438400 | \n", "LAEA200M_N14261E17192 | \n", "N14258E17191-N14261E17194 | \n", "8.0 | \n", "5 | \n", "26 | \n", "2866 | \n", "19 | \n", "0 | \n", "... | \n", "2.0 | \n", "2.0 | \n", "3.0 | \n", "4.5 | \n", "47.0 | \n", "13.0 | \n", "0 | \n", "5.0 | \n", "0 | \n", "1384589 | \n", "
3 | \n", "POLYGON((3.2312378220814 46.926350456766,3.233... | \n", "CRS3035RES200mN2669200E3805800 | \n", "LAEA200M_N13346E19029 | \n", "N13345E19029-N13347E19031 | \n", "6.0 | \n", "5 | \n", "28 | \n", "2427 | \n", "15 | \n", "4 | \n", "... | \n", "1.0 | \n", "2.0 | \n", "3.0 | \n", "8.5 | \n", "49.0 | \n", "12.0 | \n", "0 | \n", "7.0 | \n", "0 | \n", "1308697 | \n", "
4 | \n", "POLYGON((6.6327096470269 47.992073373622,6.635... | \n", "CRS3035RES200mN2769800E4069600 | \n", "LAEA200M_N13849E20348 | \n", "N13845E20348-N13849E20351 | \n", "32.5 | \n", "8 | \n", "28 | \n", "3244 | \n", "17 | \n", "5 | \n", "... | \n", "1.0 | \n", "3.0 | \n", "2.0 | \n", "1.5 | \n", "46.0 | \n", "13.0 | \n", "0 | \n", "5.0 | \n", "0 | \n", "1517997 | \n", "
5 rows \u00d7 29 columns
\n", "\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "
---|---|---|---|---|---|
idINSPIRE | \n", "CRS3035RES200mN2619600E3756800 | \n", "CRS3035RES200mN2569800E4064400 | \n", "CRS3035RES200mN2852200E3438400 | \n", "CRS3035RES200mN2669200E3805800 | \n", "CRS3035RES200mN2769800E4069600 | \n", "
id | \n", "LAEA200M_N13098E18784 | \n", "LAEA200M_N12849E20322 | \n", "LAEA200M_N14261E17192 | \n", "LAEA200M_N13346E19029 | \n", "LAEA200M_N13849E20348 | \n", "
idk | \n", "N13090E18781-N13103E18788 | \n", "N12849E20321-N12849E20324 | \n", "N14258E17191-N14261E17194 | \n", "N13345E19029-N13347E19031 | \n", "N13845E20348-N13849E20351 | \n", "
ind_c | \n", "4 | \n", "1 | \n", "8 | \n", "6 | \n", "32.5 | \n", "
nbcar | \n", "13 | \n", "4 | \n", "5 | \n", "5 | \n", "8 | \n", "
men | \n", "24 | \n", "15 | \n", "26 | \n", "28 | \n", "28 | \n", "
men_surf | \n", "2353 | \n", "1162 | \n", "2866 | \n", "2427 | \n", "3244 | \n", "
men_occ5 | \n", "19 | \n", "5 | \n", "19 | \n", "15 | \n", "17 | \n", "
men_coll | \n", "0 | \n", "7 | \n", "0 | \n", "4 | \n", "5 | \n", "
men_5ind | \n", "0 | \n", "1 | \n", "1 | \n", "2 | \n", "1 | \n", "
men_1ind | \n", "4 | \n", "3 | \n", "5 | \n", "6 | \n", "6 | \n", "
i_1ind | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
men_prop | \n", "19 | \n", "8 | \n", "20 | \n", "22 | \n", "21 | \n", "
i_prop | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "
men_basr | \n", "5 | \n", "4 | \n", "2 | \n", "2 | \n", "1 | \n", "
i_basr | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
ind_r | \n", "62.5 | \n", "39.5 | \n", "66.5 | \n", "72.5 | \n", "67.5 | \n", "
ind_age1 | \n", "3 | \n", "3 | \n", "2 | \n", "3 | \n", "4 | \n", "
ind_age2 | \n", "3 | \n", "0 | \n", "2 | \n", "1 | \n", "1 | \n", "
ind_age3 | \n", "2 | \n", "2 | \n", "2 | \n", "2 | \n", "3 | \n", "
ind_age4 | \n", "1 | \n", "1 | \n", "3 | \n", "3 | \n", "2 | \n", "
ind_age5 | \n", "2.5 | \n", "2.5 | \n", "4.5 | \n", "8.5 | \n", "1.5 | \n", "
ind_age6 | \n", "45 | \n", "28 | \n", "47 | \n", "49 | \n", "46 | \n", "
ind_age7 | \n", "11 | \n", "3 | \n", "13 | \n", "12 | \n", "13 | \n", "
i_age7 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
ind_age8 | \n", "9 | \n", "3 | \n", "5 | \n", "7 | \n", "5 | \n", "
i_age8 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
ind_srf | \n", "1083644 | \n", "725512 | \n", "1384589 | \n", "1308697 | \n", "1517997 | \n", "
geometry | \n", "POLYGON ((2.6529953850426 46.440123156379, 2.6... | \n", "POLYGON ((6.679135345427 46.191522591301, 6.68... | \n", "POLYGON ((-1.9122518974954 48.142412902797, -1... | \n", "POLYGON ((3.2312378220814 46.926350456766, 3.2... | \n", "POLYGON ((6.6327096470269 47.992073373622, 6.6... | \n", "
\n", " | DEPCOM | \n", "NOM_COM | \n", "IRIS | \n", "DCOMIRIS | \n", "NOM_IRIS | \n", "TYP_IRIS | \n", "ORIGINE | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "97201 | \n", "L' AJOUPA-BOUILLON | \n", "0000 | \n", "972010000 | \n", "L'AJOUPA-BOUILLON | \n", "Z | \n", "\n", " | POLYGON ((-61.09797143533286 14.83121003588694... | \n", "
1 | \n", "97202 | \n", "LES ANSES-D'ARLET | \n", "0000 | \n", "972020000 | \n", "LES ANSES-D'ARLET | \n", "Z | \n", "\n", " | POLYGON ((-61.07379117657102 14.54040539807739... | \n", "
2 | \n", "97203 | \n", "BASSE-POINTE | \n", "0000 | \n", "972030000 | \n", "BASSE-POINTE | \n", "Z | \n", "\n", " | POLYGON ((-61.08307142985399 14.85248314985411... | \n", "
3 | \n", "97204 | \n", "LE CARBET | \n", "0000 | \n", "972040000 | \n", "LE CARBET | \n", "Z | \n", "\n", " | POLYGON ((-61.15649300614872 14.73308036750109... | \n", "
4 | \n", "97205 | \n", "CASE-PILOTE | \n", "0000 | \n", "972050000 | \n", "CASE-PILOTE | \n", "Z | \n", "\n", " | POLYGON ((-61.12423374731185 14.69020654340677... | \n", "
\n", " | VAR_ID | \n", "VAR_LIB | \n", "VAR_LIB_LONG | \n", "
---|---|---|---|
0 | \n", "CODGEO | \n", "Code g\u00e9ographique | \n", "Code du quartier prioritaire, de l'Iris, de la... | \n", "
1 | \n", "LIBGEO | \n", "Libell\u00e9 g\u00e9ographique | \n", "Nom du quartier prioritaire, de l'Iris, de la ... | \n", "
2 | \n", "EPCI1 | \n", "Code EPCI au 1er janvier 2015 | \n", "Code EPCI au 1er janvier 2015 | \n", "
3 | \n", "EPCI2 | \n", "Code EPCI au 1er janvier 2015 | \n", "Code EPCI au 1er janvier 2015 pour les QPV loc... | \n", "
4 | \n", "EPCI | \n", "Code EPCI au 1er janvier 2015 | \n", "Code EPCI au 1er janvier 2015 pour les commune... | \n", "
5 | \n", "UU | \n", "Code de l'unit\u00e9 urbaine | \n", "Code de l'unit\u00e9 urbaine | \n", "
6 | \n", "REG | \n", "Code r\u00e9gion | \n", "Code r\u00e9gion (nouvelles r\u00e9gions au 1er janvier ... | \n", "
7 | \n", "REG2 | \n", "Code r\u00e9gion | \n", "Code r\u00e9gion (nouvelles r\u00e9gions au 1er janvier ... | \n", "
8 | \n", "DEPCOM | \n", "Code commune | \n", "Code la commune (pour la table Iris) | \n", "
9 | \n", "LIBCOM | \n", "Libell\u00e9 de la commune | \n", "Libell\u00e9 de la commune (pour la table Iris) | \n", "
10 | \n", "NOTE | \n", "Note de diffusion | \n", "Note de diffusion (voir documentation) | \n", "
11 | \n", "A | \n", "Nombre total d'allocataires | \n", "Nombre total de foyers allocataires percevant ... | \n", "
12 | \n", "PERCOU | \n", "Personnes couvertes | \n", "Nombre de personnes couvertes par au moins une... | \n", "
13 | \n", "AI | \n", "Allocataires isol\u00e9s sans enfant | \n", "Nombre d'allocataires isol\u00e9s sans enfant | \n", "
14 | \n", "AM | \n", "Allocataires mono-parent | \n", "Nombre de familles monoparentales (allocataire... | \n", "
\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "
---|---|---|---|---|---|
CODGEO | \n", "010040101 | \n", "010040102 | \n", "010040201 | \n", "010040202 | \n", "010330101 | \n", "
LIBGEO | \n", "Les Perouses-Triangle d'Activite | \n", "Longeray-Gare | \n", "Centre-St Germain-Vareilles | \n", "Tiret-Les Allymes | \n", "Coupy-Vanchy | \n", "
DEPCOM | \n", "01004 | \n", "01004 | \n", "01004 | \n", "01004 | \n", "01033 | \n", "
LIBCOM | \n", "Amb\u00e9rieu-en-Bugey | \n", "Amb\u00e9rieu-en-Bugey | \n", "Amb\u00e9rieu-en-Bugey | \n", "Amb\u00e9rieu-en-Bugey | \n", "Bellegarde-sur-Valserine | \n", "
EPCI | \n", "2.40101e+08 | \n", "2.40101e+08 | \n", "2.40101e+08 | \n", "2.40101e+08 | \n", "2.40101e+08 | \n", "
REG | \n", "84 | \n", "84 | \n", "84 | \n", "84 | \n", "84 | \n", "
NOTE | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
A | \n", "397 | \n", "929 | \n", "883 | \n", "740 | \n", "221 | \n", "
PERCOU | \n", "983 | \n", "2256 | \n", "2252 | \n", "2358 | \n", "584 | \n", "
AI | \n", "174 | \n", "371 | \n", "317 | \n", "146 | \n", "77 | \n", "
AM | \n", "52 | \n", "174 | \n", "187 | \n", "107 | \n", "22 | \n", "
ACSSENF | \n", "26 | \n", "71 | \n", "55 | \n", "25 | \n", "28 | \n", "
ACAVENF | \n", "145 | \n", "313 | \n", "324 | \n", "462 | \n", "94 | \n", "
AC3ENF | \n", "55 | \n", "97 | \n", "92 | \n", "115 | \n", "25 | \n", "
ENF | \n", "419 | \n", "950 | \n", "1005 | \n", "1143 | \n", "242 | \n", "
\n", " | Lat | \n", "Lon | \n", "lieu | \n", "
---|---|---|---|
0 | \n", "48.866667 | \n", "2.333333 | \n", "Paris | \n", "
1 | \n", "49.762085 | \n", "4.726096 | \n", "Charleville | \n", "
\n", " | lieu | \n", "geometry | \n", "
---|---|---|
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "
\n", " | lieu | \n", "geometry | \n", "index_right | \n", "DEPCOM | \n", "NOM_COM | \n", "IRIS | \n", "DCOMIRIS | \n", "NOM_IRIS | \n", "TYP_IRIS | \n", "ORIGINE | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "400244 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "451142 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "145754 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "349346 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "502040 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "196652 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "298448 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "94856 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "43958 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "247550 | \n", "75101 | \n", "PARIS 1ER ARRONDISSEMENT | \n", "0301 | \n", "751010301 | \n", "PALAIS ROYAL 1 | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "419050 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "368152 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "317254 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "469948 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "164560 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "113662 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "266356 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "62764 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "215458 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "11866 | \n", "08105 | \n", "CHARLEVILLE-MEZIERES | \n", "0502 | \n", "081050502 | \n", "LES FAUBOURGS-SUD | \n", "H | \n", "\n", " |
\n", " | lieu | \n", "geometry | \n", "index_right | \n", "idINSPIRE | \n", "id | \n", "idk | \n", "ind_c | \n", "nbcar | \n", "men | \n", "men_surf | \n", "... | \n", "ind_age2 | \n", "ind_age3 | \n", "ind_age4 | \n", "ind_age5 | \n", "ind_age6 | \n", "ind_age7 | \n", "i_age7 | \n", "ind_age8 | \n", "i_age8 | \n", "ind_srf | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Paris | \n", "POINT (2.333333 48.866667) | \n", "2139268 | \n", "CRS3035RES200mN2890600E3759400 | \n", "LAEA200M_N14453E18797 | \n", "N14453E18797-N14453E18797 | \n", "543.0 | \n", "1 | \n", "285 | \n", "16016 | \n", "... | \n", "6.0 | \n", "18.0 | \n", "17.0 | \n", "21.0 | \n", "420.0 | \n", "99.0 | \n", "0 | \n", "55.0 | \n", "0 | \n", "13526488 | \n", "
1 | \n", "Charleville | \n", "POINT (4.726095999999984 49.76208500000001) | \n", "1355467 | \n", "CRS3035RES200mN2974600E3941200 | \n", "LAEA200M_N14873E19706 | \n", "N14873E19705-N14873E19706 | \n", "1.0 | \n", "2 | \n", "167 | \n", "12657 | \n", "... | \n", "4.0 | \n", "14.5 | \n", "12.5 | \n", "6.0 | \n", "216.0 | \n", "65.0 | \n", "0 | \n", "36.0 | \n", "0 | \n", "4826513 | \n", "
2 rows \u00d7 31 columns
\n", "