{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import isoweek" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Les données sont disponibles du site Web du [Réseau Sentinelles](http://www.sentiweb.fr/). Nous les récupérons sous forme d'un fichier en format CSV dont chaque ligne correspond à une semaine de la période demandée." ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "data_url = \"https://www.sentiweb.fr/datasets/all/inc-7-RDD.csv\"" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [], "source": [ "data_file = \"varicelle.csv\"\n", "\n", "import os\n", "import urllib.request\n", "if not os.path.exists(data_file):\n", " urllib.request.urlretrieve(data_url, data_file)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
weekindicatorincinc_lowinc_upinc100inc100_lowinc100_upgeo_inseegeo_name
0202535700.00.000.00.044GRAND EST
1202535700.00.000.00.075NOUVELLE-AQUITAINE
2202535700.00.000.00.084AUVERGNE-RHONE-ALPES
3202535700.00.000.00.027BOURGOGNE-FRANCHE-COMTE
420253576660.01689.0190.048.053BRETAGNE
5202535700.00.000.00.024CENTRE-VAL-DE-LOIRE
6202535700.00.000.00.094CORSE
720253572620.0772.020.06.011ILE-DE-FRANCE
820253574040.01196.070.020.076OCCITANIE
920253572500.0897.040.015.032HAUTS-DE-FRANCE
10202535700.00.000.00.028NORMANDIE
11202535700.00.000.00.052PAYS-DE-LA-LOIRE
12202535700.00.000.00.093PROVENCE-ALPES-COTE-D-AZUR
13202534700.00.000.00.044GRAND EST
1420253473380.0844.050.013.075NOUVELLE-AQUITAINE
152025347310.0124.000.01.084AUVERGNE-RHONE-ALPES
162025347450.0181.020.07.027BOURGOGNE-FRANCHE-COMTE
17202534700.00.000.00.053BRETAGNE
182025347670.0388.030.015.024CENTRE-VAL-DE-LOIRE
192025347470.0138.0130.039.094CORSE
2020253472730.0689.020.05.011ILE-DE-FRANCE
21202534700.00.000.00.076OCCITANIE
222025347710.0285.010.05.032HAUTS-DE-FRANCE
232025347950.0710.030.021.028NORMANDIE
24202534700.00.000.00.052PAYS-DE-LA-LOIRE
25202534700.00.000.00.093PROVENCE-ALPES-COTE-D-AZUR
26202533700.00.000.00.044GRAND EST
2720253372600.0774.040.012.075NOUVELLE-AQUITAINE
2820253371160.0415.010.05.084AUVERGNE-RHONE-ALPES
2920253371250.0446.040.015.027BOURGOGNE-FRANCHE-COMTE
.................................
23539199051729140.06580.0500.0114.032HAUTS-DE-FRANCE
23540199051700.00.000.00.028NORMANDIE
23541199051759583668.08248.0195120.0270.052PAYS-DE-LA-LOIRE
2354219905179210.01962.0220.046.093PROVENCE-ALPES-COTE-D-AZUR
2354319905075430.01330.0100.025.044GRAND EST
235441990507134226.02658.0260.052.075NOUVELLE-AQUITAINE
2354519905079140.01920.0140.029.084AUVERGNE-RHONE-ALPES
2354619905073740.0953.0140.035.027BOURGOGNE-FRANCHE-COMTE
2354719905071391124.02658.0505.095.053BRETAGNE
2354819905073830.01186.0160.050.024CENTRE-VAL-DE-LOIRE
23549199050700.00.000.00.094CORSE
2355019905074310.0974.040.09.011ILE-DE-FRANCE
235511990507590.0248.010.05.076OCCITANIE
23552199050728810.05941.0500.0103.032HAUTS-DE-FRANCE
23553199050700.00.000.00.028NORMANDIE
2355419905072860.0809.090.026.052PAYS-DE-LA-LOIRE
2355519905071020.0348.020.08.093PROVENCE-ALPES-COTE-D-AZUR
23556199049700.00.000.00.044GRAND EST
23557199049700.00.000.00.075NOUVELLE-AQUITAINE
2355819904972840.0774.040.011.084AUVERGNE-RHONE-ALPES
235591990497280.0163.010.06.027BOURGOGNE-FRANCHE-COMTE
2356019904971610.0673.060.024.053BRETAGNE
235611990497550.0359.020.015.024CENTRE-VAL-DE-LOIRE
23562199049700.00.000.00.094CORSE
23563199049700.00.000.00.011ILE-DE-FRANCE
23564199049700.00.000.00.076OCCITANIE
2356519904971910.0892.030.015.032HAUTS-DE-FRANCE
23566199049700.00.000.00.028NORMANDIE
23567199049700.00.000.00.052PAYS-DE-LA-LOIRE
235681990497540.0236.010.05.093PROVENCE-ALPES-COTE-D-AZUR
\n", "

23569 rows × 10 columns

\n", "
" ], "text/plain": [ " week indicator inc inc_low inc_up inc100 inc100_low inc100_up \\\n", "0 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "1 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "2 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "3 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "4 202535 7 666 0.0 1689.0 19 0.0 48.0 \n", "5 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "6 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "7 202535 7 262 0.0 772.0 2 0.0 6.0 \n", "8 202535 7 404 0.0 1196.0 7 0.0 20.0 \n", "9 202535 7 250 0.0 897.0 4 0.0 15.0 \n", "10 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "11 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "12 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "13 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "14 202534 7 338 0.0 844.0 5 0.0 13.0 \n", "15 202534 7 31 0.0 124.0 0 0.0 1.0 \n", "16 202534 7 45 0.0 181.0 2 0.0 7.0 \n", "17 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "18 202534 7 67 0.0 388.0 3 0.0 15.0 \n", "19 202534 7 47 0.0 138.0 13 0.0 39.0 \n", "20 202534 7 273 0.0 689.0 2 0.0 5.0 \n", "21 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "22 202534 7 71 0.0 285.0 1 0.0 5.0 \n", "23 202534 7 95 0.0 710.0 3 0.0 21.0 \n", "24 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "25 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "26 202533 7 0 0.0 0.0 0 0.0 0.0 \n", "27 202533 7 260 0.0 774.0 4 0.0 12.0 \n", "28 202533 7 116 0.0 415.0 1 0.0 5.0 \n", "29 202533 7 125 0.0 446.0 4 0.0 15.0 \n", "... ... ... ... ... ... ... ... ... \n", "23539 199051 7 2914 0.0 6580.0 50 0.0 114.0 \n", "23540 199051 7 0 0.0 0.0 0 0.0 0.0 \n", "23541 199051 7 5958 3668.0 8248.0 195 120.0 270.0 \n", "23542 199051 7 921 0.0 1962.0 22 0.0 46.0 \n", "23543 199050 7 543 0.0 1330.0 10 0.0 25.0 \n", "23544 199050 7 1342 26.0 2658.0 26 0.0 52.0 \n", "23545 199050 7 914 0.0 1920.0 14 0.0 29.0 \n", "23546 199050 7 374 0.0 953.0 14 0.0 35.0 \n", "23547 199050 7 1391 124.0 2658.0 50 5.0 95.0 \n", "23548 199050 7 383 0.0 1186.0 16 0.0 50.0 \n", "23549 199050 7 0 0.0 0.0 0 0.0 0.0 \n", "23550 199050 7 431 0.0 974.0 4 0.0 9.0 \n", "23551 199050 7 59 0.0 248.0 1 0.0 5.0 \n", "23552 199050 7 2881 0.0 5941.0 50 0.0 103.0 \n", "23553 199050 7 0 0.0 0.0 0 0.0 0.0 \n", "23554 199050 7 286 0.0 809.0 9 0.0 26.0 \n", "23555 199050 7 102 0.0 348.0 2 0.0 8.0 \n", "23556 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23557 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23558 199049 7 284 0.0 774.0 4 0.0 11.0 \n", "23559 199049 7 28 0.0 163.0 1 0.0 6.0 \n", "23560 199049 7 161 0.0 673.0 6 0.0 24.0 \n", "23561 199049 7 55 0.0 359.0 2 0.0 15.0 \n", "23562 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23563 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23564 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23565 199049 7 191 0.0 892.0 3 0.0 15.0 \n", "23566 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23567 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23568 199049 7 54 0.0 236.0 1 0.0 5.0 \n", "\n", " geo_insee geo_name \n", "0 44 GRAND EST \n", "1 75 NOUVELLE-AQUITAINE \n", "2 84 AUVERGNE-RHONE-ALPES \n", "3 27 BOURGOGNE-FRANCHE-COMTE \n", "4 53 BRETAGNE \n", "5 24 CENTRE-VAL-DE-LOIRE \n", "6 94 CORSE \n", "7 11 ILE-DE-FRANCE \n", "8 76 OCCITANIE \n", "9 32 HAUTS-DE-FRANCE \n", "10 28 NORMANDIE \n", "11 52 PAYS-DE-LA-LOIRE \n", "12 93 PROVENCE-ALPES-COTE-D-AZUR \n", "13 44 GRAND EST \n", "14 75 NOUVELLE-AQUITAINE \n", "15 84 AUVERGNE-RHONE-ALPES \n", "16 27 BOURGOGNE-FRANCHE-COMTE \n", "17 53 BRETAGNE \n", "18 24 CENTRE-VAL-DE-LOIRE \n", "19 94 CORSE \n", "20 11 ILE-DE-FRANCE \n", "21 76 OCCITANIE \n", "22 32 HAUTS-DE-FRANCE \n", "23 28 NORMANDIE \n", "24 52 PAYS-DE-LA-LOIRE \n", "25 93 PROVENCE-ALPES-COTE-D-AZUR \n", "26 44 GRAND EST \n", "27 75 NOUVELLE-AQUITAINE \n", "28 84 AUVERGNE-RHONE-ALPES \n", "29 27 BOURGOGNE-FRANCHE-COMTE \n", "... ... ... \n", "23539 32 HAUTS-DE-FRANCE \n", "23540 28 NORMANDIE \n", "23541 52 PAYS-DE-LA-LOIRE \n", "23542 93 PROVENCE-ALPES-COTE-D-AZUR \n", "23543 44 GRAND EST \n", "23544 75 NOUVELLE-AQUITAINE \n", "23545 84 AUVERGNE-RHONE-ALPES \n", "23546 27 BOURGOGNE-FRANCHE-COMTE \n", "23547 53 BRETAGNE \n", "23548 24 CENTRE-VAL-DE-LOIRE \n", "23549 94 CORSE \n", "23550 11 ILE-DE-FRANCE \n", "23551 76 OCCITANIE \n", "23552 32 HAUTS-DE-FRANCE \n", "23553 28 NORMANDIE \n", "23554 52 PAYS-DE-LA-LOIRE \n", "23555 93 PROVENCE-ALPES-COTE-D-AZUR \n", "23556 44 GRAND EST \n", "23557 75 NOUVELLE-AQUITAINE \n", "23558 84 AUVERGNE-RHONE-ALPES \n", "23559 27 BOURGOGNE-FRANCHE-COMTE \n", "23560 53 BRETAGNE \n", "23561 24 CENTRE-VAL-DE-LOIRE \n", "23562 94 CORSE \n", "23563 11 ILE-DE-FRANCE \n", "23564 76 OCCITANIE \n", "23565 32 HAUTS-DE-FRANCE \n", "23566 28 NORMANDIE \n", "23567 52 PAYS-DE-LA-LOIRE \n", "23568 93 PROVENCE-ALPES-COTE-D-AZUR \n", "\n", "[23569 rows x 10 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "raw_data = pd.read_csv(data_file, skiprows=1)\n", "raw_data" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
weekindicatorincinc_lowinc_upinc100inc100_lowinc100_upgeo_inseegeo_name
0202535700.00.000.00.044GRAND EST
1202535700.00.000.00.075NOUVELLE-AQUITAINE
2202535700.00.000.00.084AUVERGNE-RHONE-ALPES
3202535700.00.000.00.027BOURGOGNE-FRANCHE-COMTE
420253576660.01689.0190.048.053BRETAGNE
5202535700.00.000.00.024CENTRE-VAL-DE-LOIRE
6202535700.00.000.00.094CORSE
720253572620.0772.020.06.011ILE-DE-FRANCE
820253574040.01196.070.020.076OCCITANIE
920253572500.0897.040.015.032HAUTS-DE-FRANCE
10202535700.00.000.00.028NORMANDIE
11202535700.00.000.00.052PAYS-DE-LA-LOIRE
12202535700.00.000.00.093PROVENCE-ALPES-COTE-D-AZUR
13202534700.00.000.00.044GRAND EST
1420253473380.0844.050.013.075NOUVELLE-AQUITAINE
152025347310.0124.000.01.084AUVERGNE-RHONE-ALPES
162025347450.0181.020.07.027BOURGOGNE-FRANCHE-COMTE
17202534700.00.000.00.053BRETAGNE
182025347670.0388.030.015.024CENTRE-VAL-DE-LOIRE
192025347470.0138.0130.039.094CORSE
2020253472730.0689.020.05.011ILE-DE-FRANCE
21202534700.00.000.00.076OCCITANIE
222025347710.0285.010.05.032HAUTS-DE-FRANCE
232025347950.0710.030.021.028NORMANDIE
24202534700.00.000.00.052PAYS-DE-LA-LOIRE
25202534700.00.000.00.093PROVENCE-ALPES-COTE-D-AZUR
26202533700.00.000.00.044GRAND EST
2720253372600.0774.040.012.075NOUVELLE-AQUITAINE
2820253371160.0415.010.05.084AUVERGNE-RHONE-ALPES
2920253371250.0446.040.015.027BOURGOGNE-FRANCHE-COMTE
.................................
23539199051729140.06580.0500.0114.032HAUTS-DE-FRANCE
23540199051700.00.000.00.028NORMANDIE
23541199051759583668.08248.0195120.0270.052PAYS-DE-LA-LOIRE
2354219905179210.01962.0220.046.093PROVENCE-ALPES-COTE-D-AZUR
2354319905075430.01330.0100.025.044GRAND EST
235441990507134226.02658.0260.052.075NOUVELLE-AQUITAINE
2354519905079140.01920.0140.029.084AUVERGNE-RHONE-ALPES
2354619905073740.0953.0140.035.027BOURGOGNE-FRANCHE-COMTE
2354719905071391124.02658.0505.095.053BRETAGNE
2354819905073830.01186.0160.050.024CENTRE-VAL-DE-LOIRE
23549199050700.00.000.00.094CORSE
2355019905074310.0974.040.09.011ILE-DE-FRANCE
235511990507590.0248.010.05.076OCCITANIE
23552199050728810.05941.0500.0103.032HAUTS-DE-FRANCE
23553199050700.00.000.00.028NORMANDIE
2355419905072860.0809.090.026.052PAYS-DE-LA-LOIRE
2355519905071020.0348.020.08.093PROVENCE-ALPES-COTE-D-AZUR
23556199049700.00.000.00.044GRAND EST
23557199049700.00.000.00.075NOUVELLE-AQUITAINE
2355819904972840.0774.040.011.084AUVERGNE-RHONE-ALPES
235591990497280.0163.010.06.027BOURGOGNE-FRANCHE-COMTE
2356019904971610.0673.060.024.053BRETAGNE
235611990497550.0359.020.015.024CENTRE-VAL-DE-LOIRE
23562199049700.00.000.00.094CORSE
23563199049700.00.000.00.011ILE-DE-FRANCE
23564199049700.00.000.00.076OCCITANIE
2356519904971910.0892.030.015.032HAUTS-DE-FRANCE
23566199049700.00.000.00.028NORMANDIE
23567199049700.00.000.00.052PAYS-DE-LA-LOIRE
235681990497540.0236.010.05.093PROVENCE-ALPES-COTE-D-AZUR
\n", "

23010 rows × 10 columns

\n", "
" ], "text/plain": [ " week indicator inc inc_low inc_up inc100 inc100_low inc100_up \\\n", "0 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "1 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "2 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "3 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "4 202535 7 666 0.0 1689.0 19 0.0 48.0 \n", "5 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "6 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "7 202535 7 262 0.0 772.0 2 0.0 6.0 \n", "8 202535 7 404 0.0 1196.0 7 0.0 20.0 \n", "9 202535 7 250 0.0 897.0 4 0.0 15.0 \n", "10 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "11 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "12 202535 7 0 0.0 0.0 0 0.0 0.0 \n", "13 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "14 202534 7 338 0.0 844.0 5 0.0 13.0 \n", "15 202534 7 31 0.0 124.0 0 0.0 1.0 \n", "16 202534 7 45 0.0 181.0 2 0.0 7.0 \n", "17 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "18 202534 7 67 0.0 388.0 3 0.0 15.0 \n", "19 202534 7 47 0.0 138.0 13 0.0 39.0 \n", "20 202534 7 273 0.0 689.0 2 0.0 5.0 \n", "21 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "22 202534 7 71 0.0 285.0 1 0.0 5.0 \n", "23 202534 7 95 0.0 710.0 3 0.0 21.0 \n", "24 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "25 202534 7 0 0.0 0.0 0 0.0 0.0 \n", "26 202533 7 0 0.0 0.0 0 0.0 0.0 \n", "27 202533 7 260 0.0 774.0 4 0.0 12.0 \n", "28 202533 7 116 0.0 415.0 1 0.0 5.0 \n", "29 202533 7 125 0.0 446.0 4 0.0 15.0 \n", "... ... ... ... ... ... ... ... ... \n", "23539 199051 7 2914 0.0 6580.0 50 0.0 114.0 \n", "23540 199051 7 0 0.0 0.0 0 0.0 0.0 \n", "23541 199051 7 5958 3668.0 8248.0 195 120.0 270.0 \n", "23542 199051 7 921 0.0 1962.0 22 0.0 46.0 \n", "23543 199050 7 543 0.0 1330.0 10 0.0 25.0 \n", "23544 199050 7 1342 26.0 2658.0 26 0.0 52.0 \n", "23545 199050 7 914 0.0 1920.0 14 0.0 29.0 \n", "23546 199050 7 374 0.0 953.0 14 0.0 35.0 \n", "23547 199050 7 1391 124.0 2658.0 50 5.0 95.0 \n", "23548 199050 7 383 0.0 1186.0 16 0.0 50.0 \n", "23549 199050 7 0 0.0 0.0 0 0.0 0.0 \n", "23550 199050 7 431 0.0 974.0 4 0.0 9.0 \n", "23551 199050 7 59 0.0 248.0 1 0.0 5.0 \n", "23552 199050 7 2881 0.0 5941.0 50 0.0 103.0 \n", "23553 199050 7 0 0.0 0.0 0 0.0 0.0 \n", "23554 199050 7 286 0.0 809.0 9 0.0 26.0 \n", "23555 199050 7 102 0.0 348.0 2 0.0 8.0 \n", "23556 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23557 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23558 199049 7 284 0.0 774.0 4 0.0 11.0 \n", "23559 199049 7 28 0.0 163.0 1 0.0 6.0 \n", "23560 199049 7 161 0.0 673.0 6 0.0 24.0 \n", "23561 199049 7 55 0.0 359.0 2 0.0 15.0 \n", "23562 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23563 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23564 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23565 199049 7 191 0.0 892.0 3 0.0 15.0 \n", "23566 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23567 199049 7 0 0.0 0.0 0 0.0 0.0 \n", "23568 199049 7 54 0.0 236.0 1 0.0 5.0 \n", "\n", " geo_insee geo_name \n", "0 44 GRAND EST \n", "1 75 NOUVELLE-AQUITAINE \n", "2 84 AUVERGNE-RHONE-ALPES \n", "3 27 BOURGOGNE-FRANCHE-COMTE \n", "4 53 BRETAGNE \n", "5 24 CENTRE-VAL-DE-LOIRE \n", "6 94 CORSE \n", "7 11 ILE-DE-FRANCE \n", "8 76 OCCITANIE \n", "9 32 HAUTS-DE-FRANCE \n", "10 28 NORMANDIE \n", "11 52 PAYS-DE-LA-LOIRE \n", "12 93 PROVENCE-ALPES-COTE-D-AZUR \n", "13 44 GRAND EST \n", "14 75 NOUVELLE-AQUITAINE \n", "15 84 AUVERGNE-RHONE-ALPES \n", "16 27 BOURGOGNE-FRANCHE-COMTE \n", "17 53 BRETAGNE \n", "18 24 CENTRE-VAL-DE-LOIRE \n", "19 94 CORSE \n", "20 11 ILE-DE-FRANCE \n", "21 76 OCCITANIE \n", "22 32 HAUTS-DE-FRANCE \n", "23 28 NORMANDIE \n", "24 52 PAYS-DE-LA-LOIRE \n", "25 93 PROVENCE-ALPES-COTE-D-AZUR \n", "26 44 GRAND EST \n", "27 75 NOUVELLE-AQUITAINE \n", "28 84 AUVERGNE-RHONE-ALPES \n", "29 27 BOURGOGNE-FRANCHE-COMTE \n", "... ... ... \n", "23539 32 HAUTS-DE-FRANCE \n", "23540 28 NORMANDIE \n", "23541 52 PAYS-DE-LA-LOIRE \n", "23542 93 PROVENCE-ALPES-COTE-D-AZUR \n", "23543 44 GRAND EST \n", "23544 75 NOUVELLE-AQUITAINE \n", "23545 84 AUVERGNE-RHONE-ALPES \n", "23546 27 BOURGOGNE-FRANCHE-COMTE \n", "23547 53 BRETAGNE \n", "23548 24 CENTRE-VAL-DE-LOIRE \n", "23549 94 CORSE \n", "23550 11 ILE-DE-FRANCE \n", "23551 76 OCCITANIE \n", "23552 32 HAUTS-DE-FRANCE \n", "23553 28 NORMANDIE \n", "23554 52 PAYS-DE-LA-LOIRE \n", "23555 93 PROVENCE-ALPES-COTE-D-AZUR \n", "23556 44 GRAND EST \n", "23557 75 NOUVELLE-AQUITAINE \n", "23558 84 AUVERGNE-RHONE-ALPES \n", "23559 27 BOURGOGNE-FRANCHE-COMTE \n", "23560 53 BRETAGNE \n", "23561 24 CENTRE-VAL-DE-LOIRE \n", "23562 94 CORSE \n", "23563 11 ILE-DE-FRANCE \n", "23564 76 OCCITANIE \n", "23565 32 HAUTS-DE-FRANCE \n", "23566 28 NORMANDIE \n", "23567 52 PAYS-DE-LA-LOIRE \n", "23568 93 PROVENCE-ALPES-COTE-D-AZUR \n", "\n", "[23010 rows x 10 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data = raw_data.dropna().copy()\n", "data" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "200619" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data[\"week\"][data[\"inc\"].astype(int).idxmax()]" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "202535" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data[\"week\"][data[\"inc\"].astype(int).idxmin()]" ] }, { "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.6.4" } }, "nbformat": 4, "nbformat_minor": 2 }