{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ <<<<<<< HEAD "# Incidence de la varicelle" ======= "# Incidence du syndrome grippal" >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae ] }, { "cell_type": "code", "execution_count": 1, <<<<<<< HEAD "metadata": { "hideCode": false, "hidePrompt": false }, ======= "metadata": {}, >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "outputs": [], "source": [ "%matplotlib inline\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import isoweek\n", "import os" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ <<<<<<< HEAD "Les données de l'incidence de la varicelle 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. Nous téléchargeons toujours le jeu de données complet, qui commence en 1991 et se termine avec une semaine récente." ======= "Les données de l'incidence du syndrome grippal 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. Nous téléchargeons toujours le jeu de données complet, qui commence en 1984 et se termine avec une semaine récente." >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ <<<<<<< HEAD "data_url = \"http://www.sentiweb.fr/datasets/incidence-PAY-7.csv\"" ======= "data_url = \"http://www.sentiweb.fr/datasets/incidence-PAY-3.csv\"" >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Voici l'explication des colonnes données [sur le site d'origine](https://ns.sentiweb.fr/incidence/csv-schema-v1.json):\n", "\n", "| Nom de colonne | Libellé de colonne |\n", "|----------------|-----------------------------------------------------------------------------------------------------------------------------------|\n", "| week | Semaine calendaire (ISO 8601) |\n", "| indicator | Code de l'indicateur de surveillance |\n", "| inc | Estimation de l'incidence de consultations en nombre de cas |\n", "| inc_low | Estimation de la borne inférieure de l'IC95% du nombre de cas de consultation |\n", "| inc_up | Estimation de la borne supérieure de l'IC95% du nombre de cas de consultation |\n", "| inc100 | Estimation du taux d'incidence du nombre de cas de consultation (en cas pour 100,000 habitants) |\n", "| inc100_low | Estimation de la borne inférieure de l'IC95% du taux d'incidence du nombre de cas de consultation (en cas pour 100,000 habitants) |\n", "| inc100_up | Estimation de la borne supérieure de l'IC95% du taux d'incidence du nombre de cas de consultation (en cas pour 100,000 habitants) |\n", "| geo_insee | Code de la zone géographique concernée (Code INSEE) http://www.insee.fr/fr/methodes/nomenclatures/cog/ |\n", "| geo_name | Libellé de la zone géographique (ce libellé peut être modifié sans préavis) |\n", "\n", <<<<<<< HEAD "La première ligne du fichier CSV est potentiellement un commentaire, que nous ignorons en précisant `comment=1`. Si le fichier existe déjà en version locale, nous l'utilisons sinon nous téléchargeons l'url précisée et la sauvegardons en local pour pouvoir la réutiliser plus tard." ======= "La première ligne du fichier CSV est un commentaire, que nous ignorons en précisant `skiprows=1`. Si le fichier existe déjà en version locale, nous l'utilisons sinon nous téléchargeons l'url précisée et la sauvegardons en local pour pouvoir la réutiliser plus tard." >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Reading local version\n" ] }, { "data": { "text/html": [ "
\n", " | Unnamed: 0 | \n", "week | \n", "indicator | \n", "inc | \n", "inc_low | \n", "inc_up | \n", "inc100 | \n", "inc100_low | \n", "inc100_up | \n", "geo_insee | \n", "geo_name | \n", "||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", <<<<<<< HEAD "202018 | \n", "7 | \n", "861 | \n", "88 | \n", "1634 | \n", "1 | \n", "0 | \n", "2 | \n", ======= "202011 | \n", "3 | \n", "101704 | \n", "93652.0 | \n", "109756.0 | \n", "154 | \n", "142.0 | \n", "166.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
1 | \n", "1 | \n", <<<<<<< HEAD "202017 | \n", "7 | \n", "272 | \n", "0 | \n", "658 | \n", "0 | \n", "0 | \n", "1 | \n", ======= "202010 | \n", "3 | \n", "104977 | \n", "96650.0 | \n", "113304.0 | \n", "159 | \n", "146.0 | \n", "172.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
2 | \n", "2 | \n", <<<<<<< HEAD "202016 | \n", "7 | \n", "758 | \n", "78 | \n", "1438 | \n", "1 | \n", "0 | \n", "2 | \n", ======= "202009 | \n", "3 | \n", "110696 | \n", "102066.0 | \n", "119326.0 | \n", "168 | \n", "155.0 | \n", "181.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
3 | \n", "3 | \n", <<<<<<< HEAD "202015 | \n", "7 | \n", "1918 | \n", "675 | \n", "3161 | \n", "3 | \n", "1 | \n", "5 | \n", ======= "202008 | \n", "3 | \n", "143753 | \n", "133984.0 | \n", "153522.0 | \n", "218 | \n", "203.0 | \n", "233.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
4 | \n", "4 | \n", <<<<<<< HEAD "202014 | \n", "7 | \n", "3879 | \n", "2227 | \n", "5531 | \n", "6 | \n", "3 | \n", "9 | \n", ======= "202007 | \n", "3 | \n", "183610 | \n", "172812.0 | \n", "194408.0 | \n", "279 | \n", "263.0 | \n", "295.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
5 | \n", "5 | \n", <<<<<<< HEAD "202013 | \n", "7 | \n", "7326 | \n", "5236 | \n", "9416 | \n", "11 | \n", "8 | \n", "14 | \n", ======= "202006 | \n", "3 | \n", "206669 | \n", "195481.0 | \n", "217857.0 | \n", "314 | \n", "297.0 | \n", "331.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
6 | \n", "6 | \n", <<<<<<< HEAD "202012 | \n", "7 | \n", "8123 | \n", "5790 | \n", "10456 | \n", "12 | \n", "8 | \n", "16 | \n", ======= "202005 | \n", "3 | \n", "187957 | \n", "177445.0 | \n", "198469.0 | \n", "285 | \n", "269.0 | \n", "301.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
7 | \n", "7 | \n", <<<<<<< HEAD "202011 | \n", "7 | \n", "10198 | \n", "7568 | \n", "12828 | \n", "15 | \n", "11 | \n", "19 | \n", ======= "202004 | \n", "3 | \n", "122331 | \n", "113492.0 | \n", "131170.0 | \n", "186 | \n", "173.0 | \n", "199.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
8 | \n", "8 | \n", <<<<<<< HEAD "202010 | \n", "7 | \n", "9011 | \n", "6691 | \n", "11331 | \n", "14 | \n", "10 | \n", "18 | \n", ======= "202003 | \n", "3 | \n", "78413 | \n", "71330.0 | \n", "85496.0 | \n", "119 | \n", "108.0 | \n", "130.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
9 | \n", "9 | \n", <<<<<<< HEAD "202009 | \n", "7 | \n", "13631 | \n", "10544 | \n", "16718 | \n", "21 | \n", "16 | \n", "26 | \n", ======= "202002 | \n", "3 | \n", "53614 | \n", "47654.0 | \n", "59574.0 | \n", "81 | \n", "72.0 | \n", "90.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
10 | \n", "10 | \n", <<<<<<< HEAD "202008 | \n", "7 | \n", "10424 | \n", "7708 | \n", "13140 | \n", "16 | \n", "12 | \n", "20 | \n", ======= "202001 | \n", "3 | \n", "36850 | \n", "31608.0 | \n", "42092.0 | \n", "56 | \n", "48.0 | \n", "64.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
11 | \n", "11 | \n", <<<<<<< HEAD "202007 | \n", "7 | \n", "8959 | \n", "6574 | \n", "11344 | \n", "14 | \n", "10 | \n", "18 | \n", ======= "201952 | \n", "3 | \n", "28135 | \n", "23220.0 | \n", "33050.0 | \n", "43 | \n", "36.0 | \n", "50.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
12 | \n", "12 | \n", <<<<<<< HEAD "202006 | \n", "7 | \n", "9264 | \n", "6925 | \n", "11603 | \n", "14 | \n", "10 | \n", "18 | \n", ======= "201951 | \n", "3 | \n", "29786 | \n", "25042.0 | \n", "34530.0 | \n", "45 | \n", "38.0 | \n", "52.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
13 | \n", "13 | \n", <<<<<<< HEAD "202005 | \n", "7 | \n", "8505 | \n", "6314 | \n", "10696 | \n", "13 | \n", "10 | \n", "16 | \n", ======= "201950 | \n", "3 | \n", "34223 | \n", "29156.0 | \n", "39290.0 | \n", "52 | \n", "44.0 | \n", "60.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
14 | \n", "14 | \n", <<<<<<< HEAD "202004 | \n", "7 | \n", "7991 | \n", "5831 | \n", "10151 | \n", "12 | \n", "9 | \n", "15 | \n", ======= "201949 | \n", "3 | \n", "25662 | \n", "21414.0 | \n", "29910.0 | \n", "39 | \n", "33.0 | \n", "45.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
15 | \n", "15 | \n", <<<<<<< HEAD "202003 | \n", "7 | \n", "5968 | \n", "4100 | \n", "7836 | \n", "9 | \n", "6 | \n", "12 | \n", ======= "201948 | \n", "3 | \n", "22367 | \n", "18055.0 | \n", "26679.0 | \n", "34 | \n", "27.0 | \n", "41.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
16 | \n", "16 | \n", <<<<<<< HEAD "202002 | \n", "7 | \n", "6534 | \n", "4530 | \n", "8538 | \n", "10 | \n", "7 | \n", "13 | \n", ======= "201947 | \n", "3 | \n", "18669 | \n", "14759.0 | \n", "22579.0 | \n", "28 | \n", "22.0 | \n", "34.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
17 | \n", "17 | \n", <<<<<<< HEAD "202001 | \n", "7 | \n", "9835 | \n", "7019 | \n", "12651 | \n", "15 | \n", "11 | \n", "19 | \n", ======= "201946 | \n", "3 | \n", "16030 | \n", "12567.0 | \n", "19493.0 | \n", "24 | \n", "19.0 | \n", "29.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
18 | \n", "18 | \n", <<<<<<< HEAD "201952 | \n", "7 | \n", "7941 | \n", "5246 | \n", "10636 | \n", "12 | \n", "8 | \n", "16 | \n", ======= "201945 | \n", "3 | \n", "10138 | \n", "7160.0 | \n", "13116.0 | \n", "15 | \n", "10.0 | \n", "20.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
19 | \n", "19 | \n", <<<<<<< HEAD "201951 | \n", "7 | \n", "5823 | \n", "3675 | \n", "7971 | \n", "9 | \n", "6 | \n", "12 | \n", ======= "201944 | \n", "3 | \n", "7822 | \n", "5010.0 | \n", "10634.0 | \n", "12 | \n", "8.0 | \n", "16.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
20 | \n", "20 | \n", <<<<<<< HEAD "201950 | \n", "7 | \n", "6424 | \n", "4276 | \n", "8572 | \n", "10 | \n", "7 | \n", "13 | \n", ======= "201943 | \n", "3 | \n", "9487 | \n", "6448.0 | \n", "12526.0 | \n", "14 | \n", "9.0 | \n", "19.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
21 | \n", "21 | \n", <<<<<<< HEAD "201949 | \n", "7 | \n", "6621 | \n", "4540 | \n", "8702 | \n", "10 | \n", "7 | \n", "13 | \n", ======= "201942 | \n", "3 | \n", "7747 | \n", "5243.0 | \n", "10251.0 | \n", "12 | \n", "8.0 | \n", "16.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
22 | \n", "22 | \n", <<<<<<< HEAD "201948 | \n", "7 | \n", "5542 | \n", "3383 | \n", "7701 | \n", "8 | \n", "5 | \n", "11 | \n", ======= "201941 | \n", "3 | \n", "7122 | \n", "4720.0 | \n", "9524.0 | \n", "11 | \n", "7.0 | \n", "15.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
23 | \n", "23 | \n", <<<<<<< HEAD "201947 | \n", "7 | \n", "7536 | \n", "5058 | \n", "10014 | \n", "11 | \n", "7 | \n", "15 | \n", ======= "201940 | \n", "3 | \n", "8505 | \n", "5784.0 | \n", "11226.0 | \n", "13 | \n", "9.0 | \n", "17.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
24 | \n", "24 | \n", <<<<<<< HEAD "201946 | \n", "7 | \n", "2638 | \n", "1316 | \n", "3960 | \n", "4 | \n", "2 | \n", "6 | \n", ======= "201939 | \n", "3 | \n", "7091 | \n", "4462.0 | \n", "9720.0 | \n", "11 | \n", "7.0 | \n", "15.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
25 | \n", "25 | \n", <<<<<<< HEAD "201945 | \n", "7 | \n", "4492 | \n", "2615 | \n", "6369 | \n", "7 | \n", "4 | \n", "10 | \n", ======= "201938 | \n", "3 | \n", "4897 | \n", "2891.0 | \n", "6903.0 | \n", "7 | \n", "4.0 | \n", "10.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
26 | \n", "26 | \n", <<<<<<< HEAD "201944 | \n", "7 | \n", "5728 | \n", "3627 | \n", "7829 | \n", "9 | \n", "6 | \n", "12 | \n", ======= "201937 | \n", "3 | \n", "3172 | \n", "1367.0 | \n", "4977.0 | \n", "5 | \n", "2.0 | \n", "8.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
27 | \n", "27 | \n", <<<<<<< HEAD "201943 | \n", "7 | \n", "4834 | \n", "2751 | \n", "6917 | \n", "7 | \n", "4 | \n", "10 | \n", ======= "201936 | \n", "3 | \n", "2295 | \n", "728.0 | \n", "3862.0 | \n", "3 | \n", "1.0 | \n", "5.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
28 | \n", "28 | \n", <<<<<<< HEAD "201942 | \n", "7 | \n", "6279 | \n", "3989 | \n", "8569 | \n", "10 | \n", "7 | \n", "13 | \n", ======= "201935 | \n", "3 | \n", "1010 | \n", "2.0 | \n", "2018.0 | \n", "2 | \n", "0.0 | \n", "4.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
29 | \n", "29 | \n", <<<<<<< HEAD "201941 | \n", "7 | \n", "4130 | \n", "2030 | \n", "6230 | \n", "6 | \n", "3 | \n", "9 | \n", ======= "201934 | \n", "3 | \n", "1672 | \n", "279.0 | \n", "3065.0 | \n", "3 | \n", "1.0 | \n", "5.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "||||||||||
1505 | \n", "1505 | \n", "199126 | \n", "7 | \n", "17608 | \n", "11304 | \n", "23912 | \n", "31 | \n", "20 | \n", "42 | \n", ======= "1816 | \n", "1816 | \n", "198521 | \n", "3 | \n", "26096 | \n", "19621.0 | \n", "32571.0 | \n", "47 | \n", "35.0 | \n", "59.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1506 | \n", "1506 | \n", "199125 | \n", "7 | \n", "16169 | \n", "10700 | \n", "21638 | \n", "28 | \n", "18 | \n", "38 | \n", ======= "1817 | \n", "1817 | \n", "198520 | \n", "3 | \n", "27896 | \n", "20885.0 | \n", "34907.0 | \n", "51 | \n", "38.0 | \n", "64.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1507 | \n", "1507 | \n", "199124 | \n", "7 | \n", "16171 | \n", "10071 | \n", "22271 | \n", "28 | \n", "17 | \n", "39 | \n", ======= "1818 | \n", "1818 | \n", "198519 | \n", "3 | \n", "43154 | \n", "32821.0 | \n", "53487.0 | \n", "78 | \n", "59.0 | \n", "97.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1508 | \n", "1508 | \n", "199123 | \n", "7 | \n", "11947 | \n", "7671 | \n", "16223 | \n", "21 | \n", "13 | \n", "29 | \n", ======= "1819 | \n", "1819 | \n", "198518 | \n", "3 | \n", "40555 | \n", "29935.0 | \n", "51175.0 | \n", "74 | \n", "55.0 | \n", "93.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1509 | \n", "1509 | \n", "199122 | \n", "7 | \n", "15452 | \n", "9953 | \n", "20951 | \n", "27 | \n", "17 | \n", "37 | \n", ======= "1820 | \n", "1820 | \n", "198517 | \n", "3 | \n", "34053 | \n", "24366.0 | \n", "43740.0 | \n", "62 | \n", "44.0 | \n", "80.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1510 | \n", "1510 | \n", "199121 | \n", "7 | \n", "14903 | \n", "8975 | \n", "20831 | \n", "26 | \n", "16 | \n", "36 | \n", ======= "1821 | \n", "1821 | \n", "198516 | \n", "3 | \n", "50362 | \n", "36451.0 | \n", "64273.0 | \n", "91 | \n", "66.0 | \n", "116.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1511 | \n", "1511 | \n", "199120 | \n", "7 | \n", "19053 | \n", "12742 | \n", "25364 | \n", "34 | \n", "23 | \n", "45 | \n", ======= "1822 | \n", "1822 | \n", "198515 | \n", "3 | \n", "63881 | \n", "45538.0 | \n", "82224.0 | \n", "116 | \n", "83.0 | \n", "149.0 | \n", "FR | \n", "France | \n", "
1823 | \n", "1823 | \n", "198514 | \n", "3 | \n", "134545 | \n", "114400.0 | \n", "154690.0 | \n", "244 | \n", "207.0 | \n", "281.0 | \n", "FR | \n", "France | \n", "||||||||||
1824 | \n", "1824 | \n", "198513 | \n", "3 | \n", "197206 | \n", "176080.0 | \n", "218332.0 | \n", "357 | \n", "319.0 | \n", "395.0 | \n", "FR | \n", "France | \n", "||||||||||
1825 | \n", "1825 | \n", "198512 | \n", "3 | \n", "245240 | \n", "223304.0 | \n", "267176.0 | \n", "445 | \n", "405.0 | \n", "485.0 | \n", "FR | \n", "France | \n", "||||||||||
1826 | \n", "1826 | \n", "198511 | \n", "3 | \n", "276205 | \n", "252399.0 | \n", "300011.0 | \n", "501 | \n", "458.0 | \n", "544.0 | \n", "FR | \n", "France | \n", "||||||||||
1827 | \n", "1827 | \n", "198510 | \n", "3 | \n", "353231 | \n", "326279.0 | \n", "380183.0 | \n", "640 | \n", "591.0 | \n", "689.0 | \n", "FR | \n", "France | \n", "||||||||||
1828 | \n", "1828 | \n", "198509 | \n", "3 | \n", "369895 | \n", "341109.0 | \n", "398681.0 | \n", "670 | \n", "618.0 | \n", "722.0 | \n", "FR | \n", "France | \n", "||||||||||
1829 | \n", "1829 | \n", "198508 | \n", "3 | \n", "389886 | \n", "359529.0 | \n", "420243.0 | \n", "707 | \n", "652.0 | \n", "762.0 | \n", "FR | \n", "France | \n", "||||||||||
1830 | \n", "1830 | \n", "198507 | \n", "3 | \n", "471852 | \n", "432599.0 | \n", "511105.0 | \n", "855 | \n", "784.0 | \n", "926.0 | \n", "FR | \n", "France | \n", "||||||||||
1831 | \n", "1831 | \n", "198506 | \n", "3 | \n", "565825 | \n", "518011.0 | \n", "613639.0 | \n", "1026 | \n", "939.0 | \n", "1113.0 | \n", "FR | \n", "France | \n", "||||||||||
1832 | \n", "1832 | \n", "198505 | \n", "3 | \n", "637302 | \n", "592795.0 | \n", "681809.0 | \n", "1155 | \n", "1074.0 | \n", "1236.0 | \n", "FR | \n", "France | \n", "||||||||||
1833 | \n", "1833 | \n", "198504 | \n", "3 | \n", "424937 | \n", "390794.0 | \n", "459080.0 | \n", "770 | \n", "708.0 | \n", "832.0 | \n", "FR | \n", "France | \n", "||||||||||
1834 | \n", "1834 | \n", "198503 | \n", "3 | \n", "213901 | \n", "174689.0 | \n", "253113.0 | \n", "388 | \n", "317.0 | \n", "459.0 | \n", "FR | \n", "France | \n", "||||||||||
1835 | \n", "1835 | \n", "198502 | \n", "3 | \n", "97586 | \n", "80949.0 | \n", "114223.0 | \n", "177 | \n", "147.0 | \n", "207.0 | \n", "FR | \n", "France | \n", "||||||||||
1836 | \n", "1836 | \n", "198501 | \n", "3 | \n", "85489 | \n", "65918.0 | \n", "105060.0 | \n", "155 | \n", "120.0 | \n", "190.0 | \n", "FR | \n", "France | \n", "||||||||||
1837 | \n", "1837 | \n", "198452 | \n", "3 | \n", "84830 | \n", "60602.0 | \n", "109058.0 | \n", "154 | \n", "110.0 | \n", "198.0 | \n", "FR | \n", "France | \n", "||||||||||
1838 | \n", "1838 | \n", "198451 | \n", "3 | \n", "101726 | \n", "80242.0 | \n", "123210.0 | \n", "185 | \n", "146.0 | \n", "224.0 | \n", "FR | \n", "France | \n", "||||||||||
1839 | \n", "1839 | \n", "198450 | \n", "3 | \n", "123680 | \n", "101401.0 | \n", "145959.0 | \n", "225 | \n", "184.0 | \n", "266.0 | \n", "FR | \n", "France | \n", "||||||||||
1840 | \n", "1840 | \n", "198449 | \n", "3 | \n", "101073 | \n", "81684.0 | \n", "120462.0 | \n", "184 | \n", "149.0 | \n", "219.0 | \n", "FR | \n", "France | \n", "||||||||||
1841 | \n", "1841 | \n", "198448 | \n", "3 | \n", "78620 | \n", "60634.0 | \n", "96606.0 | \n", "143 | \n", "110.0 | \n", "176.0 | \n", "FR | \n", "France | \n", "||||||||||
1842 | \n", "1842 | \n", "198447 | \n", "3 | \n", "72029 | \n", "54274.0 | \n", "89784.0 | \n", "131 | \n", "99.0 | \n", "163.0 | \n", "FR | \n", "France | \n", "||||||||||
1843 | \n", "1843 | \n", "198446 | \n", "3 | \n", "87330 | \n", "67686.0 | \n", "106974.0 | \n", "159 | \n", "123.0 | \n", "195.0 | \n", "FR | \n", "France | \n", "||||||||||
1844 | \n", "1844 | \n", "198445 | \n", "3 | \n", "135223 | \n", "101414.0 | \n", "169032.0 | \n", "246 | \n", "184.0 | \n", "308.0 | \n", "FR | \n", "France | \n", "||||||||||
1845 | \n", "1845 | \n", "198444 | \n", "3 | \n", "68422 | \n", "20056.0 | \n", "116788.0 | \n", "125 | \n", "37.0 | \n", "213.0 | \n", "FR | \n", "France | \n", "
1846 rows × 11 columns
\n", "\n", " | Unnamed: 0 | \n", "week | \n", "indicator | \n", "inc | \n", "inc_low | \n", "inc_up | \n", "inc100 | \n", "inc100_low | \n", "inc100_up | \n", "geo_insee | \n", "geo_name | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
1609 | \n", "1609 | \n", "198919 | \n", "3 | \n", "0 | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "FR | \n", "France | \n", "
\n", " | Unnamed: 0 | \n", "week | \n", "indicator | \n", "inc | \n", "inc_low | \n", "inc_up | \n", "inc100 | \n", "inc100_low | \n", "inc100_up | \n", "geo_insee | \n", "geo_name | \n", "||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "202011 | \n", "3 | \n", "101704 | \n", "93652.0 | \n", "109756.0 | \n", "154 | \n", "142.0 | \n", "166.0 | \n", "FR | \n", "France | \n", "||||||||||
1 | \n", "1 | \n", "202010 | \n", "3 | \n", "104977 | \n", "96650.0 | \n", "113304.0 | \n", "159 | \n", "146.0 | \n", "172.0 | \n", "FR | \n", "France | \n", "||||||||||
2 | \n", "2 | \n", "202009 | \n", "3 | \n", "110696 | \n", "102066.0 | \n", "119326.0 | \n", "168 | \n", "155.0 | \n", "181.0 | \n", "FR | \n", "France | \n", "||||||||||
3 | \n", "3 | \n", "202008 | \n", "3 | \n", "143753 | \n", "133984.0 | \n", "153522.0 | \n", "218 | \n", "203.0 | \n", "233.0 | \n", "FR | \n", "France | \n", "||||||||||
4 | \n", "4 | \n", "202007 | \n", "3 | \n", "183610 | \n", "172812.0 | \n", "194408.0 | \n", "279 | \n", "263.0 | \n", "295.0 | \n", "FR | \n", "France | \n", "||||||||||
5 | \n", "5 | \n", "202006 | \n", "3 | \n", "206669 | \n", "195481.0 | \n", "217857.0 | \n", "314 | \n", "297.0 | \n", "331.0 | \n", "FR | \n", "France | \n", "||||||||||
6 | \n", "6 | \n", "202005 | \n", "3 | \n", "187957 | \n", "177445.0 | \n", "198469.0 | \n", "285 | \n", "269.0 | \n", "301.0 | \n", "FR | \n", "France | \n", "||||||||||
7 | \n", "7 | \n", "202004 | \n", "3 | \n", "122331 | \n", "113492.0 | \n", "131170.0 | \n", "186 | \n", "173.0 | \n", "199.0 | \n", "FR | \n", "France | \n", "||||||||||
8 | \n", "8 | \n", "202003 | \n", "3 | \n", "78413 | \n", "71330.0 | \n", "85496.0 | \n", "119 | \n", "108.0 | \n", "130.0 | \n", "FR | \n", "France | \n", "||||||||||
9 | \n", "9 | \n", "202002 | \n", "3 | \n", "53614 | \n", "47654.0 | \n", "59574.0 | \n", "81 | \n", "72.0 | \n", "90.0 | \n", "FR | \n", "France | \n", "||||||||||
10 | \n", "10 | \n", "202001 | \n", "3 | \n", "36850 | \n", "31608.0 | \n", "42092.0 | \n", "56 | \n", "48.0 | \n", "64.0 | \n", "FR | \n", "France | \n", "||||||||||
11 | \n", "11 | \n", "201952 | \n", "3 | \n", "28135 | \n", "23220.0 | \n", "33050.0 | \n", "43 | \n", "36.0 | \n", "50.0 | \n", "FR | \n", "France | \n", "||||||||||
12 | \n", "12 | \n", "201951 | \n", "3 | \n", "29786 | \n", "25042.0 | \n", "34530.0 | \n", "45 | \n", "38.0 | \n", "52.0 | \n", "FR | \n", "France | \n", "||||||||||
13 | \n", "13 | \n", "201950 | \n", "3 | \n", "34223 | \n", "29156.0 | \n", "39290.0 | \n", "52 | \n", "44.0 | \n", "60.0 | \n", "FR | \n", "France | \n", "||||||||||
14 | \n", "14 | \n", "201949 | \n", "3 | \n", "25662 | \n", "21414.0 | \n", "29910.0 | \n", "39 | \n", "33.0 | \n", "45.0 | \n", "FR | \n", "France | \n", "||||||||||
15 | \n", "15 | \n", "201948 | \n", "3 | \n", "22367 | \n", "18055.0 | \n", "26679.0 | \n", "34 | \n", "27.0 | \n", "41.0 | \n", "FR | \n", "France | \n", "||||||||||
16 | \n", "16 | \n", "201947 | \n", "3 | \n", "18669 | \n", "14759.0 | \n", "22579.0 | \n", "28 | \n", "22.0 | \n", "34.0 | \n", "FR | \n", "France | \n", "||||||||||
17 | \n", "17 | \n", "201946 | \n", "3 | \n", "16030 | \n", "12567.0 | \n", "19493.0 | \n", "24 | \n", "19.0 | \n", "29.0 | \n", "FR | \n", "France | \n", "||||||||||
18 | \n", "18 | \n", "201945 | \n", "3 | \n", "10138 | \n", "7160.0 | \n", "13116.0 | \n", "15 | \n", "10.0 | \n", "20.0 | \n", "FR | \n", "France | \n", "||||||||||
19 | \n", "19 | \n", "201944 | \n", "3 | \n", "7822 | \n", "5010.0 | \n", "10634.0 | \n", "12 | \n", "8.0 | \n", "16.0 | \n", "FR | \n", "France | \n", "||||||||||
20 | \n", "20 | \n", "201943 | \n", "3 | \n", "9487 | \n", "6448.0 | \n", "12526.0 | \n", "14 | \n", "9.0 | \n", "19.0 | \n", "FR | \n", "France | \n", "||||||||||
21 | \n", "21 | \n", "201942 | \n", "3 | \n", "7747 | \n", "5243.0 | \n", "10251.0 | \n", "12 | \n", "8.0 | \n", "16.0 | \n", "FR | \n", "France | \n", "||||||||||
22 | \n", "22 | \n", "201941 | \n", "3 | \n", "7122 | \n", "4720.0 | \n", "9524.0 | \n", "11 | \n", "7.0 | \n", "15.0 | \n", "FR | \n", "France | \n", "||||||||||
23 | \n", "23 | \n", "201940 | \n", "3 | \n", "8505 | \n", "5784.0 | \n", "11226.0 | \n", "13 | \n", "9.0 | \n", "17.0 | \n", "FR | \n", "France | \n", "||||||||||
24 | \n", "24 | \n", "201939 | \n", "3 | \n", "7091 | \n", "4462.0 | \n", "9720.0 | \n", "11 | \n", "7.0 | \n", "15.0 | \n", "FR | \n", "France | \n", "||||||||||
25 | \n", "25 | \n", "201938 | \n", "3 | \n", "4897 | \n", "2891.0 | \n", "6903.0 | \n", "7 | \n", "4.0 | \n", "10.0 | \n", "FR | \n", "France | \n", "||||||||||
26 | \n", "26 | \n", "201937 | \n", "3 | \n", "3172 | \n", "1367.0 | \n", "4977.0 | \n", "5 | \n", "2.0 | \n", "8.0 | \n", "FR | \n", "France | \n", "||||||||||
27 | \n", "27 | \n", "201936 | \n", "3 | \n", "2295 | \n", "728.0 | \n", "3862.0 | \n", "3 | \n", "1.0 | \n", "5.0 | \n", "FR | \n", "France | \n", "||||||||||
28 | \n", "28 | \n", "201935 | \n", "3 | \n", "1010 | \n", "2.0 | \n", "2018.0 | \n", "2 | \n", "0.0 | \n", "4.0 | \n", "FR | \n", "France | \n", "||||||||||
29 | \n", "29 | \n", "201934 | \n", "3 | \n", "1672 | \n", "279.0 | \n", "3065.0 | \n", "3 | \n", "1.0 | \n", "5.0 | \n", "FR | \n", "France | \n", "||||||||||
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "||||||||||
1816 | \n", "1816 | \n", "198521 | \n", "3 | \n", "26096 | \n", "19621.0 | \n", "32571.0 | \n", "47 | \n", "35.0 | \n", "59.0 | \n", "FR | \n", "France | \n", "||||||||||
1817 | \n", "1817 | \n", "198520 | \n", "3 | \n", "27896 | \n", "20885.0 | \n", "34907.0 | \n", "51 | \n", "38.0 | \n", "64.0 | \n", "FR | \n", "France | \n", "||||||||||
1818 | \n", "1818 | \n", "198519 | \n", "3 | \n", "43154 | \n", "32821.0 | \n", "53487.0 | \n", "78 | \n", "59.0 | \n", "97.0 | \n", "FR | \n", "France | \n", "||||||||||
1819 | \n", "1819 | \n", "198518 | \n", "3 | \n", "40555 | \n", "29935.0 | \n", "51175.0 | \n", "74 | \n", "55.0 | \n", "93.0 | \n", "FR | \n", "France | \n", "||||||||||
1820 | \n", "1820 | \n", "198517 | \n", "3 | \n", "34053 | \n", "24366.0 | \n", "43740.0 | \n", "62 | \n", "44.0 | \n", "80.0 | \n", "FR | \n", "France | \n", "||||||||||
1821 | \n", "1821 | \n", "198516 | \n", "3 | \n", "50362 | \n", "36451.0 | \n", "64273.0 | \n", "91 | \n", "66.0 | \n", "116.0 | \n", "FR | \n", "France | \n", "||||||||||
1822 | \n", "1822 | \n", "198515 | \n", "3 | \n", "63881 | \n", "45538.0 | \n", "82224.0 | \n", "116 | \n", "83.0 | \n", "149.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "||||||||||
1512 | \n", "1512 | \n", "199119 | \n", "7 | \n", "16739 | \n", "11246 | \n", "22232 | \n", "29 | \n", "19 | \n", "39 | \n", ======= "1823 | \n", "1823 | \n", "198514 | \n", "3 | \n", "134545 | \n", "114400.0 | \n", "154690.0 | \n", "244 | \n", "207.0 | \n", "281.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1513 | \n", "1513 | \n", "199118 | \n", "7 | \n", "21385 | \n", "13882 | \n", "28888 | \n", "38 | \n", "25 | \n", "51 | \n", ======= "1824 | \n", "1824 | \n", "198513 | \n", "3 | \n", "197206 | \n", "176080.0 | \n", "218332.0 | \n", "357 | \n", "319.0 | \n", "395.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1514 | \n", "1514 | \n", "199117 | \n", "7 | \n", "13462 | \n", "8877 | \n", "18047 | \n", "24 | \n", "16 | \n", "32 | \n", ======= "1825 | \n", "1825 | \n", "198512 | \n", "3 | \n", "245240 | \n", "223304.0 | \n", "267176.0 | \n", "445 | \n", "405.0 | \n", "485.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1515 | \n", "1515 | \n", "199116 | \n", "7 | \n", "14857 | \n", "10068 | \n", "19646 | \n", "26 | \n", "18 | \n", "34 | \n", ======= "1826 | \n", "1826 | \n", "198511 | \n", "3 | \n", "276205 | \n", "252399.0 | \n", "300011.0 | \n", "501 | \n", "458.0 | \n", "544.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1516 | \n", "1516 | \n", "199115 | \n", "7 | \n", "13975 | \n", "9781 | \n", "18169 | \n", "25 | \n", "18 | \n", "32 | \n", ======= "1827 | \n", "1827 | \n", "198510 | \n", "3 | \n", "353231 | \n", "326279.0 | \n", "380183.0 | \n", "640 | \n", "591.0 | \n", "689.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1517 | \n", "1517 | \n", "199114 | \n", "7 | \n", "12265 | \n", "7684 | \n", "16846 | \n", "22 | \n", "14 | \n", "30 | \n", ======= "1828 | \n", "1828 | \n", "198509 | \n", "3 | \n", "369895 | \n", "341109.0 | \n", "398681.0 | \n", "670 | \n", "618.0 | \n", "722.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1518 | \n", "1518 | \n", "199113 | \n", "7 | \n", "9567 | \n", "6041 | \n", "13093 | \n", "17 | \n", "11 | \n", "23 | \n", ======= "1829 | \n", "1829 | \n", "198508 | \n", "3 | \n", "389886 | \n", "359529.0 | \n", "420243.0 | \n", "707 | \n", "652.0 | \n", "762.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1519 | \n", "1519 | \n", "199112 | \n", "7 | \n", "10864 | \n", "7331 | \n", "14397 | \n", "19 | \n", "13 | \n", "25 | \n", ======= "1830 | \n", "1830 | \n", "198507 | \n", "3 | \n", "471852 | \n", "432599.0 | \n", "511105.0 | \n", "855 | \n", "784.0 | \n", "926.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1520 | \n", "1520 | \n", "199111 | \n", "7 | \n", "15574 | \n", "11184 | \n", "19964 | \n", "27 | \n", "19 | \n", "35 | \n", ======= "1831 | \n", "1831 | \n", "198506 | \n", "3 | \n", "565825 | \n", "518011.0 | \n", "613639.0 | \n", "1026 | \n", "939.0 | \n", "1113.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1521 | \n", "1521 | \n", "199110 | \n", "7 | \n", "16643 | \n", "11372 | \n", "21914 | \n", "29 | \n", "20 | \n", "38 | \n", ======= "1832 | \n", "1832 | \n", "198505 | \n", "3 | \n", "637302 | \n", "592795.0 | \n", "681809.0 | \n", "1155 | \n", "1074.0 | \n", "1236.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1522 | \n", "1522 | \n", "199109 | \n", "7 | \n", "13741 | \n", "8780 | \n", "18702 | \n", "24 | \n", "15 | \n", "33 | \n", ======= "1833 | \n", "1833 | \n", "198504 | \n", "3 | \n", "424937 | \n", "390794.0 | \n", "459080.0 | \n", "770 | \n", "708.0 | \n", "832.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1523 | \n", "1523 | \n", "199108 | \n", "7 | \n", "13289 | \n", "8813 | \n", "17765 | \n", "23 | \n", "15 | \n", "31 | \n", ======= "1834 | \n", "1834 | \n", "198503 | \n", "3 | \n", "213901 | \n", "174689.0 | \n", "253113.0 | \n", "388 | \n", "317.0 | \n", "459.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1524 | \n", "1524 | \n", "199107 | \n", "7 | \n", "12337 | \n", "8077 | \n", "16597 | \n", "22 | \n", "15 | \n", "29 | \n", ======= "1835 | \n", "1835 | \n", "198502 | \n", "3 | \n", "97586 | \n", "80949.0 | \n", "114223.0 | \n", "177 | \n", "147.0 | \n", "207.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1525 | \n", "1525 | \n", "199106 | \n", "7 | \n", "10877 | \n", "7013 | \n", "14741 | \n", "19 | \n", "12 | \n", "26 | \n", ======= "1836 | \n", "1836 | \n", "198501 | \n", "3 | \n", "85489 | \n", "65918.0 | \n", "105060.0 | \n", "155 | \n", "120.0 | \n", "190.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1526 | \n", "1526 | \n", "199105 | \n", "7 | \n", "10442 | \n", "6544 | \n", "14340 | \n", "18 | \n", "11 | \n", "25 | \n", ======= "1837 | \n", "1837 | \n", "198452 | \n", "3 | \n", "84830 | \n", "60602.0 | \n", "109058.0 | \n", "154 | \n", "110.0 | \n", "198.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1527 | \n", "1527 | \n", "199104 | \n", "7 | \n", "7913 | \n", "4563 | \n", "11263 | \n", "14 | \n", "8 | \n", "20 | \n", ======= "1838 | \n", "1838 | \n", "198451 | \n", "3 | \n", "101726 | \n", "80242.0 | \n", "123210.0 | \n", "185 | \n", "146.0 | \n", "224.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1528 | \n", "1528 | \n", "199103 | \n", "7 | \n", "15387 | \n", "10484 | \n", "20290 | \n", "27 | \n", "18 | \n", "36 | \n", ======= "1839 | \n", "1839 | \n", "198450 | \n", "3 | \n", "123680 | \n", "101401.0 | \n", "145959.0 | \n", "225 | \n", "184.0 | \n", "266.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1529 | \n", "1529 | \n", "199102 | \n", "7 | \n", "16277 | \n", "11046 | \n", "21508 | \n", "29 | \n", "20 | \n", "38 | \n", ======= "1840 | \n", "1840 | \n", "198449 | \n", "3 | \n", "101073 | \n", "81684.0 | \n", "120462.0 | \n", "184 | \n", "149.0 | \n", "219.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1530 | \n", "1530 | \n", "199101 | \n", "7 | \n", "15565 | \n", "10271 | \n", "20859 | \n", "27 | \n", "18 | \n", "36 | \n", ======= "1841 | \n", "1841 | \n", "198448 | \n", "3 | \n", "78620 | \n", "60634.0 | \n", "96606.0 | \n", "143 | \n", "110.0 | \n", "176.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1531 | \n", "1531 | \n", "199052 | \n", "7 | \n", "19375 | \n", "13295 | \n", "25455 | \n", "34 | \n", "23 | \n", "45 | \n", ======= "1842 | \n", "1842 | \n", "198447 | \n", "3 | \n", "72029 | \n", "54274.0 | \n", "89784.0 | \n", "131 | \n", "99.0 | \n", "163.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1532 | \n", "1532 | \n", "199051 | \n", "7 | \n", "19080 | \n", "13807 | \n", "24353 | \n", "34 | \n", "25 | \n", "43 | \n", ======= "1843 | \n", "1843 | \n", "198446 | \n", "3 | \n", "87330 | \n", "67686.0 | \n", "106974.0 | \n", "159 | \n", "123.0 | \n", "195.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1533 | \n", "1533 | \n", "199050 | \n", "7 | \n", "11079 | \n", "6660 | \n", "15498 | \n", "20 | \n", "12 | \n", "28 | \n", ======= "1844 | \n", "1844 | \n", "198445 | \n", "3 | \n", "135223 | \n", "101414.0 | \n", "169032.0 | \n", "246 | \n", "184.0 | \n", "308.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1534 | \n", "1534 | \n", "199049 | \n", "7 | \n", "1143 | \n", "0 | \n", "2610 | \n", "2 | \n", "0 | \n", "5 | \n", ======= "1845 | \n", "1845 | \n", "198444 | \n", "3 | \n", "68422 | \n", "20056.0 | \n", "116788.0 | \n", "125 | \n", "37.0 | \n", "213.0 | \n", >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "FR | \n", "France | \n", "
1535 rows × 11 columns
\n", "\n", " | Unnamed: 0 | \n", "week | \n", "indicator | \n", "inc | \n", "inc_low | \n", "inc_up | \n", "inc100 | \n", "inc100_low | \n", "inc100_up | \n", "geo_insee | \n", "geo_name | \n", "
---|
1845 rows × 11 columns
\n", "" ], "text/plain": [ " Unnamed: 0 week indicator inc inc_low inc_up inc100 \\\n", "0 0 202011 3 101704 93652.0 109756.0 154 \n", "1 1 202010 3 104977 96650.0 113304.0 159 \n", "2 2 202009 3 110696 102066.0 119326.0 168 \n", "3 3 202008 3 143753 133984.0 153522.0 218 \n", "4 4 202007 3 183610 172812.0 194408.0 279 \n", "5 5 202006 3 206669 195481.0 217857.0 314 \n", "6 6 202005 3 187957 177445.0 198469.0 285 \n", "7 7 202004 3 122331 113492.0 131170.0 186 \n", "8 8 202003 3 78413 71330.0 85496.0 119 \n", "9 9 202002 3 53614 47654.0 59574.0 81 \n", "10 10 202001 3 36850 31608.0 42092.0 56 \n", "11 11 201952 3 28135 23220.0 33050.0 43 \n", "12 12 201951 3 29786 25042.0 34530.0 45 \n", "13 13 201950 3 34223 29156.0 39290.0 52 \n", "14 14 201949 3 25662 21414.0 29910.0 39 \n", "15 15 201948 3 22367 18055.0 26679.0 34 \n", "16 16 201947 3 18669 14759.0 22579.0 28 \n", "17 17 201946 3 16030 12567.0 19493.0 24 \n", "18 18 201945 3 10138 7160.0 13116.0 15 \n", "19 19 201944 3 7822 5010.0 10634.0 12 \n", "20 20 201943 3 9487 6448.0 12526.0 14 \n", "21 21 201942 3 7747 5243.0 10251.0 12 \n", "22 22 201941 3 7122 4720.0 9524.0 11 \n", "23 23 201940 3 8505 5784.0 11226.0 13 \n", "24 24 201939 3 7091 4462.0 9720.0 11 \n", "25 25 201938 3 4897 2891.0 6903.0 7 \n", "26 26 201937 3 3172 1367.0 4977.0 5 \n", "27 27 201936 3 2295 728.0 3862.0 3 \n", "28 28 201935 3 1010 2.0 2018.0 2 \n", "29 29 201934 3 1672 279.0 3065.0 3 \n", "... ... ... ... ... ... ... ... \n", "1816 1816 198521 3 26096 19621.0 32571.0 47 \n", "1817 1817 198520 3 27896 20885.0 34907.0 51 \n", "1818 1818 198519 3 43154 32821.0 53487.0 78 \n", "1819 1819 198518 3 40555 29935.0 51175.0 74 \n", "1820 1820 198517 3 34053 24366.0 43740.0 62 \n", "1821 1821 198516 3 50362 36451.0 64273.0 91 \n", "1822 1822 198515 3 63881 45538.0 82224.0 116 \n", "1823 1823 198514 3 134545 114400.0 154690.0 244 \n", "1824 1824 198513 3 197206 176080.0 218332.0 357 \n", "1825 1825 198512 3 245240 223304.0 267176.0 445 \n", "1826 1826 198511 3 276205 252399.0 300011.0 501 \n", "1827 1827 198510 3 353231 326279.0 380183.0 640 \n", "1828 1828 198509 3 369895 341109.0 398681.0 670 \n", "1829 1829 198508 3 389886 359529.0 420243.0 707 \n", "1830 1830 198507 3 471852 432599.0 511105.0 855 \n", "1831 1831 198506 3 565825 518011.0 613639.0 1026 \n", "1832 1832 198505 3 637302 592795.0 681809.0 1155 \n", "1833 1833 198504 3 424937 390794.0 459080.0 770 \n", "1834 1834 198503 3 213901 174689.0 253113.0 388 \n", "1835 1835 198502 3 97586 80949.0 114223.0 177 \n", "1836 1836 198501 3 85489 65918.0 105060.0 155 \n", "1837 1837 198452 3 84830 60602.0 109058.0 154 \n", "1838 1838 198451 3 101726 80242.0 123210.0 185 \n", "1839 1839 198450 3 123680 101401.0 145959.0 225 \n", "1840 1840 198449 3 101073 81684.0 120462.0 184 \n", "1841 1841 198448 3 78620 60634.0 96606.0 143 \n", "1842 1842 198447 3 72029 54274.0 89784.0 131 \n", "1843 1843 198446 3 87330 67686.0 106974.0 159 \n", "1844 1844 198445 3 135223 101414.0 169032.0 246 \n", "1845 1845 198444 3 68422 20056.0 116788.0 125 \n", "\n", " inc100_low inc100_up geo_insee geo_name \n", "0 142.0 166.0 FR France \n", "1 146.0 172.0 FR France \n", "2 155.0 181.0 FR France \n", "3 203.0 233.0 FR France \n", "4 263.0 295.0 FR France \n", "5 297.0 331.0 FR France \n", "6 269.0 301.0 FR France \n", "7 173.0 199.0 FR France \n", "8 108.0 130.0 FR France \n", "9 72.0 90.0 FR France \n", "10 48.0 64.0 FR France \n", "11 36.0 50.0 FR France \n", "12 38.0 52.0 FR France \n", "13 44.0 60.0 FR France \n", "14 33.0 45.0 FR France \n", "15 27.0 41.0 FR France \n", "16 22.0 34.0 FR France \n", "17 19.0 29.0 FR France \n", "18 10.0 20.0 FR France \n", "19 8.0 16.0 FR France \n", "20 9.0 19.0 FR France \n", "21 8.0 16.0 FR France \n", "22 7.0 15.0 FR France \n", "23 9.0 17.0 FR France \n", "24 7.0 15.0 FR France \n", "25 4.0 10.0 FR France \n", "26 2.0 8.0 FR France \n", "27 1.0 5.0 FR France \n", "28 0.0 4.0 FR France \n", "29 1.0 5.0 FR France \n", "... ... ... ... ... \n", "1816 35.0 59.0 FR France \n", "1817 38.0 64.0 FR France \n", "1818 59.0 97.0 FR France \n", "1819 55.0 93.0 FR France \n", "1820 44.0 80.0 FR France \n", "1821 66.0 116.0 FR France \n", "1822 83.0 149.0 FR France \n", "1823 207.0 281.0 FR France \n", "1824 319.0 395.0 FR France \n", "1825 405.0 485.0 FR France \n", "1826 458.0 544.0 FR France \n", "1827 591.0 689.0 FR France \n", "1828 618.0 722.0 FR France \n", "1829 652.0 762.0 FR France \n", "1830 784.0 926.0 FR France \n", "1831 939.0 1113.0 FR France \n", "1832 1074.0 1236.0 FR France \n", "1833 708.0 832.0 FR France \n", "1834 317.0 459.0 FR France \n", "1835 147.0 207.0 FR France \n", "1836 120.0 190.0 FR France \n", "1837 110.0 198.0 FR France \n", "1838 146.0 224.0 FR France \n", "1839 184.0 266.0 FR France \n", "1840 149.0 219.0 FR France \n", "1841 110.0 176.0 FR France \n", "1842 99.0 163.0 FR France \n", "1843 123.0 195.0 FR France \n", "1844 184.0 308.0 FR France \n", "1845 37.0 213.0 FR France \n", "\n", "[1845 rows x 11 columns]" ] }, "execution_count": 5, >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "metadata": {}, "output_type": "execute_result" } ], "source": [ <<<<<<< HEAD "raw_data[raw_data.isnull().any(axis=1)]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Nous copions les données en éliminant les éventuelles lignes sans données." ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "data = raw_data.dropna().copy()" ======= "data = raw_data.dropna().copy()\n", "data" >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae ] }, { "cell_type": "markdown", "metadata": {}, "source": [ <<<<<<< HEAD "Nos données utilisent une convention inhabituelle: le numéro de semaine est collé à l'année, donnant l'impression qu'il s'agit de nombre entier. C'est comme ça que Pandas les interprète.\n", " \n", "Un deuxième problème est que Pandas ne comprend pas les numéros de semaine. Il faut lui fournir les dates de début et de fin de semaine. Nous utilisons pour cela la bibliothèque isoweek.\n", "\n", "Comme la conversion des semaines est devenu assez complexe, nous écrivons une petite fonction Python pour cela. Ensuite, nous l'appliquons à tous les points de nos donnés. Les résultats vont dans une nouvelle colonne 'period'.\n" ======= "Nos données utilisent une convention inhabituelle: le numéro de\n", "semaine est collé à l'année, donnant l'impression qu'il s'agit\n", "de nombre entier. C'est comme ça que Pandas les interprète.\n", " \n", "Un deuxième problème est que Pandas ne comprend pas les numéros de\n", "semaine. Il faut lui fournir les dates de début et de fin de\n", "semaine. Nous utilisons pour cela la bibliothèque `isoweek`.\n", "\n", "Comme la conversion des semaines est devenu assez complexe, nous\n", "écrivons une petite fonction Python pour cela. Ensuite, nous\n", "l'appliquons à tous les points de nos donnés. Les résultats vont\n", "dans une nouvelle colonne 'period'." >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [], "source": [ "def convert_week(year_and_week_int):\n", " year_and_week_str = str(year_and_week_int)\n", " year = int(year_and_week_str[:4])\n", " week = int(year_and_week_str[4:])\n", " w = isoweek.Week(year, week)\n", " return pd.Period(w.day(0), 'W')\n", "\n", <<<<<<< HEAD "data['period'] = [convert_week(yw) for yw in raw_data['week']]" ======= "data['period'] = [convert_week(yw) for yw in data['week']]" >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Il restent deux petites modifications à faire.\n", "\n", "Premièrement, nous définissons les périodes d'observation\n", "comme nouvel index de notre jeux de données. Ceci en fait\n", "une suite chronologique, ce qui sera pratique par la suite.\n", "\n", "Deuxièmement, nous trions les points par période, dans\n", "le sens chronologique." ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [], "source": [ "sorted_data = data.set_index('period').sort_index()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ <<<<<<< HEAD "Nous vérifions la cohérence des données. Entre la fin d'une période et le début de la période qui suit, la différence temporelle doit être zéro, ou au moins très faible. Nous laissons une \"marge d'erreur\" d'une seconde.\n", "\n", "Ceci s'avère tout à fait juste sauf pour deux périodes consécutives entre lesquelles il manque une semaine." ======= "Nous vérifions la cohérence des données. Entre la fin d'une période et\n", "le début de la période qui suit, la différence temporelle doit être\n", "zéro, ou au moins très faible. Nous laissons une \"marge d'erreur\"\n", "d'une seconde.\n", "\n", "Ceci s'avère tout à fait juste sauf pour deux périodes consécutives\n", "entre lesquelles il manque une semaine.\n", "\n", "Nous reconnaissons ces dates: c'est la semaine sans observations\n", "que nous avions supprimées !" >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, <<<<<<< HEAD "outputs": [], ======= "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "1989-05-01/1989-05-07 1989-05-15/1989-05-21\n" ] } ], >>>>>>> 434003e5783670228a3cd8cc42f0374cc0d5d7ae "source": [ "periods = sorted_data.index\n", "for p1, p2 in zip(periods[:-1], periods[1:]):\n", " delta = p2.to_timestamp() - p1.end_time\n", " if delta > pd.Timedelta('1s'):\n", " print(p1, p2)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Un premier regard sur les données !" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/plain": [ <<<<<<< HEAD "