{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import matplotlib\n", "import urllib.request\n", "import zipfile\n", "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "archive_name = \"indic-struct-distrib-revenu-2015-SUPRA.zip\"\n", "subarchive_name = \"indic-struct-distrib-revenu-2015-METROPOLE.zip\"\n", "file_name = \"FILO_DISP_METROPOLE.xls\"" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "downloading file ...\n", "fully ownloaded !\n" ] } ], "source": [ "print(\"downloading file ...\")\n", "urllib.request.urlretrieve(\n", " \"https://www.insee.fr/fr/statistiques/fichier/3560118/indic-struct-distrib-revenu-2015-SUPRA.zip\", \n", " archive_name\n", ")\n", "print(\"fully ownloaded !\")" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "extracting all from indic-struct-distrib-revenu-2015-SUPRA.zip ...\n", "done extracting !\n", "extracting all from indic-struct-distrib-revenu-2015-METROPOLE.zip ...\n", "done extracting !\n" ] } ], "source": [ "def extract(path, member):\n", " print(\"extracting all from %s ...\" % path)\n", " with zipfile.ZipFile(path, 'r') as zip_ref:\n", " zip_ref.extract(member, \"./\")\n", " print(\"done extracting !\")\n", "\n", " \n", "extract(archive_name, subarchive_name)\n", "extract(subarchive_name, file_name)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Code géographique | \n", "Nbre de ménages fiscaux | \n", "Nbre de personnes dans les ménages fiscaux | \n", "Nbre d'unités de consommation dans les ménages fiscaux | \n", "1er quartile (€) | \n", "Médiane (€) | \n", "3e quartile (€) | \n", "Écart interquartile (€) | \n", "1er décile (€) | \n", "2e décile (€) | \n", "... | \n", "dont part des indemnités chômage (%) | \n", "dont part des salaires, traitements hors chômage (%) | \n", "dont part des revenus des activités non salariées (%) | \n", "Part des pensions, retraites et rentes (%) | \n", "Part des revenus du patrimoine et autres revenus (%) | \n", "Part de l'ensemble des prestations sociales (%) | \n", "dont part des prestations familiales (%) | \n", "dont part des minima sociaux (%) | \n", "dont part des prestations logement (%) | \n", "Part des impôts (%) | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Libellé géographique | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
France métropolitaine | \n", "1 | \n", "27071573 | \n", "62770585.5 | \n", "4.274229e+07 | \n", "14976.666667 | \n", "20565.555556 | \n", "27670 | \n", "12693.333333 | \n", "10739 | \n", "13743 | \n", "... | \n", "3.2 | \n", "64.3 | \n", "5.6 | \n", "28.3 | \n", "10.6 | \n", "5.3 | \n", "2.1 | \n", "1.7 | \n", "1.4 | \n", "-17.4 | \n", "
1 rows × 30 columns
\n", "\n", " | France Métropolitaine - 2015 | \n", "label | \n", "
---|---|---|
0.10 | \n", "10739.000000 | \n", "1er décile - 10% | \n", "
0.20 | \n", "13743.000000 | \n", "2e décile - 20% | \n", "
0.25 | \n", "14976.666667 | \n", "1er quartile - 25% | \n", "
0.30 | \n", "16153.448276 | \n", "3e décile - 30% | \n", "
0.40 | \n", "18391.000000 | \n", "4e décile - 40% | \n", "
0.50 | \n", "20565.555556 | \n", "Médiane - 50% | \n", "
0.60 | \n", "22917.500000 | \n", "6e décile - 60% | \n", "
0.70 | \n", "25806.923077 | \n", "7e décile - 70% | \n", "
0.75 | \n", "27670.000000 | \n", "3e quartile - 80% | \n", "
0.80 | \n", "29978.000000 | \n", "8e décile - 80% | \n", "
0.90 | \n", "37620.952381 | \n", "9e décile - 90% | \n", "