{ "cells": [ { "cell_type": "markdown", "id": "4cce1403-673c-47be-b411-d065afdab43b", "metadata": {}, "source": [ "# Upper and middle class workers in Ile de France" ] }, { "cell_type": "code", "execution_count": 1, "id": "33e5897a-b527-4518-b9e8-a97b60203982", "metadata": {}, "outputs": [], "source": [ "from pynsee import *\n", "\n", "import pandas as pd\n", "import geopandas as gpd\n", "from pathlib import Path\n", "from contextlib import closing\n", "# import urllib.request as request\n", "from urllib.request import Request, urlopen\n", "import os\n", "import py7zr\n", "import re\n", "import shutil\n", "\n", "import matplotlib.cm as cm\n", "import matplotlib.pyplot as plt\n", "import descartes" ] }, { "cell_type": "code", "execution_count": 2, "id": "653a6502-ed13-4821-b23f-5b7f1a8b0c46", "metadata": {}, "outputs": [], "source": [ "import logging\n", "import sys\n", "logging.basicConfig(stream=sys.stdout,\n", " level=logging.INFO, \n", " format=\"%(message)s\")" ] }, { "cell_type": "code", "execution_count": 3, "id": "85a9df02-942d-4cb5-994c-4f3ae846c080", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "pynsee.download's metadata rely on volunteering contributors and their manual updates. get_file_list does not provide data from official Insee's metadata API\n", "Consequently, please report any issue\n" ] }, { "data": { "text/html": [ "
| \n", " | 1332 | \n", "
|---|---|
| id | \n", "RP_ACTRES_IRIS | \n", "
| name | \n", "RP_ACTRES_IRIS | \n", "
| label | \n", "Données du Recensement de Population, données ... | \n", "
| collection | \n", "RP | \n", "
| link | \n", "https://www.insee.fr/fr/statistiques/fichier/4... | \n", "
| type | \n", "xlsx | \n", "
| zip | \n", "True | \n", "
| big_zip | \n", "False | \n", "
| data_file | \n", "base-ic-activite-residents-2017.xlsx | \n", "
| tab | \n", "IRIS | \n", "
| first_row | \n", "6 | \n", "
| api_rest | \n", "False | \n", "
| md5 | \n", "2df77900dcd6544a454d39abee9070a9 | \n", "
| size | \n", "60768390 | \n", "
| date_ref | \n", "2017-01-01 | \n", "
| \n", " | IRIS | \n", "COM | \n", "REG | \n", "DEP | \n", "LIBCOM | \n", "C17_ACT1564 | \n", "C17_ACT1564_CS2 | \n", "C17_ACT1564_CS3 | \n", "pct | \n", "
|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "751010101 | \n", "75101 | \n", "11 | \n", "75 | \n", "Paris 1er Arrondissement | \n", "520.643927 | \n", "29.702144 | \n", "190.009987 | \n", "42.200076 | \n", "
| 1 | \n", "751010102 | \n", "75101 | \n", "11 | \n", "75 | \n", "Paris 1er Arrondissement | \n", "71.145629 | \n", "9.899243 | \n", "36.903044 | \n", "65.783784 | \n", "
| 2 | \n", "751010103 | \n", "75101 | \n", "11 | \n", "75 | \n", "Paris 1er Arrondissement | \n", "107.952527 | \n", "18.057574 | \n", "55.539455 | \n", "68.175365 | \n", "
| 3 | \n", "751010104 | \n", "75101 | \n", "11 | \n", "75 | \n", "Paris 1er Arrondissement | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
| 4 | \n", "751010105 | \n", "75101 | \n", "11 | \n", "75 | \n", "Paris 1er Arrondissement | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 5257 | \n", "956800112 | \n", "95680 | \n", "11 | \n", "95 | \n", "Villiers-le-Bel | \n", "831.396737 | \n", "54.511641 | \n", "35.417896 | \n", "10.816681 | \n", "
| 5258 | \n", "956800113 | \n", "95680 | \n", "11 | \n", "95 | \n", "Villiers-le-Bel | \n", "885.164069 | \n", "26.592849 | \n", "32.183605 | \n", "6.640176 | \n", "
| 5259 | \n", "956800114 | \n", "95680 | \n", "11 | \n", "95 | \n", "Villiers-le-Bel | \n", "664.336730 | \n", "24.113011 | \n", "11.521560 | \n", "5.363932 | \n", "
| 5260 | \n", "956820000 | \n", "95682 | \n", "11 | \n", "95 | \n", "Villiers-le-Sec | \n", "117.460317 | \n", "4.894180 | \n", "24.470899 | \n", "25.000000 | \n", "
| 5261 | \n", "956900000 | \n", "95690 | \n", "11 | \n", "95 | \n", "Wy-dit-Joli-Village | \n", "193.914518 | \n", "20.062030 | \n", "49.941941 | \n", "36.100428 | \n", "
5262 rows × 9 columns
\n", "