{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline\n", "import matplotlib.pyplot as plt\n", "import os\n", "import pandas as pd\n", "import isoweek\n", "import urllib.request" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Le but de cette analyse est de s'intéresser à l'incidence de la varicelle en France Métropolitaine depuis 1991, à l'aide des données disponibles sur le site du [Réseau Sentinelles](https://www.sentiweb.fr/france/fr/?).\n", "\n", "On ne télécharge les données que si le fichier n'est pas déjà présent en local." ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "data_url = \"https://www.sentiweb.fr/datasets/incidence-PAY-7.csv\"\n", "data_file = \"varicelle.csv\"\n", "\n", "if not os.path.isfile(data_file):\n", " urllib.request.urlretrieve(data_url, data_file)" ] }, { "cell_type": "code", "execution_count": 4, "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
020201474624260266467410FRFrance
1202013773715268947411814FRFrance
22020127812357901045612816FRFrance
3202011710198756812828151119FRFrance
420201079011669111331141018FRFrance
52020097136311054416718211626FRFrance
6202008710424770813140161220FRFrance
720200778959657411344141018FRFrance
820200679264692511603141018FRFrance
920200578505631410696131016FRFrance
102020047799158311015112915FRFrance
1120200375968410078369612FRFrance
12202002765344530853810713FRFrance
1320200179835701912651151119FRFrance
142019527794152461063612816FRFrance
1520195175823367579719612FRFrance
16201950764244276857210713FRFrance
17201949766214540870210713FRFrance
1820194875542338377018511FRFrance
192019477753650581001411715FRFrance
202019467263813163960426FRFrance
2120194574492261563697410FRFrance
2220194475728362778299612FRFrance
2320194374834275169177410FRFrance
24201942762793989856910713FRFrance
252019417413020306230639FRFrance
262019407421122186204639FRFrance
272019397313713104964528FRFrance
282019387307814164740528FRFrance
2920193779701621778102FRFrance
.................................
15011991267176081130423912312042FRFrance
15021991257161691070021638281838FRFrance
15031991247161711007122271281739FRFrance
1504199123711947767116223211329FRFrance
1505199122715452995320951271737FRFrance
1506199121714903897520831261636FRFrance
15071991207190531274225364342345FRFrance
15081991197167391124622232291939FRFrance
15091991187213851388228888382551FRFrance
1510199117713462887718047241632FRFrance
15111991167148571006819646261834FRFrance
1512199115713975978118169251832FRFrance
1513199114712265768416846221430FRFrance
151419911379567604113093171123FRFrance
1515199112710864733114397191325FRFrance
15161991117155741118419964271935FRFrance
15171991107166431137221914292038FRFrance
1518199109713741878018702241533FRFrance
1519199108713289881317765231531FRFrance
1520199107712337807716597221529FRFrance
1521199106710877701314741191226FRFrance
1522199105710442654414340181125FRFrance
15231991047791345631126314820FRFrance
15241991037153871048420290271836FRFrance
15251991027162771104621508292038FRFrance
15261991017155651027120859271836FRFrance
15271990527193751329525455342345FRFrance
15281990517190801380724353342543FRFrance
1529199050711079666015498201228FRFrance
15301990497114302610205FRFrance
\n", "

1531 rows × 10 columns

\n", "
" ], "text/plain": [ " week indicator inc inc_low inc_up inc100 inc100_low \\\n", "0 202014 7 4624 2602 6646 7 4 \n", "1 202013 7 7371 5268 9474 11 8 \n", "2 202012 7 8123 5790 10456 12 8 \n", "3 202011 7 10198 7568 12828 15 11 \n", "4 202010 7 9011 6691 11331 14 10 \n", "5 202009 7 13631 10544 16718 21 16 \n", "6 202008 7 10424 7708 13140 16 12 \n", "7 202007 7 8959 6574 11344 14 10 \n", "8 202006 7 9264 6925 11603 14 10 \n", "9 202005 7 8505 6314 10696 13 10 \n", "10 202004 7 7991 5831 10151 12 9 \n", "11 202003 7 5968 4100 7836 9 6 \n", "12 202002 7 6534 4530 8538 10 7 \n", "13 202001 7 9835 7019 12651 15 11 \n", "14 201952 7 7941 5246 10636 12 8 \n", "15 201951 7 5823 3675 7971 9 6 \n", "16 201950 7 6424 4276 8572 10 7 \n", "17 201949 7 6621 4540 8702 10 7 \n", "18 201948 7 5542 3383 7701 8 5 \n", "19 201947 7 7536 5058 10014 11 7 \n", "20 201946 7 2638 1316 3960 4 2 \n", "21 201945 7 4492 2615 6369 7 4 \n", "22 201944 7 5728 3627 7829 9 6 \n", "23 201943 7 4834 2751 6917 7 4 \n", "24 201942 7 6279 3989 8569 10 7 \n", "25 201941 7 4130 2030 6230 6 3 \n", "26 201940 7 4211 2218 6204 6 3 \n", "27 201939 7 3137 1310 4964 5 2 \n", "28 201938 7 3078 1416 4740 5 2 \n", "29 201937 7 970 162 1778 1 0 \n", "... ... ... ... ... ... ... ... \n", "1501 199126 7 17608 11304 23912 31 20 \n", "1502 199125 7 16169 10700 21638 28 18 \n", "1503 199124 7 16171 10071 22271 28 17 \n", "1504 199123 7 11947 7671 16223 21 13 \n", "1505 199122 7 15452 9953 20951 27 17 \n", "1506 199121 7 14903 8975 20831 26 16 \n", "1507 199120 7 19053 12742 25364 34 23 \n", "1508 199119 7 16739 11246 22232 29 19 \n", "1509 199118 7 21385 13882 28888 38 25 \n", "1510 199117 7 13462 8877 18047 24 16 \n", "1511 199116 7 14857 10068 19646 26 18 \n", "1512 199115 7 13975 9781 18169 25 18 \n", "1513 199114 7 12265 7684 16846 22 14 \n", "1514 199113 7 9567 6041 13093 17 11 \n", "1515 199112 7 10864 7331 14397 19 13 \n", "1516 199111 7 15574 11184 19964 27 19 \n", "1517 199110 7 16643 11372 21914 29 20 \n", "1518 199109 7 13741 8780 18702 24 15 \n", "1519 199108 7 13289 8813 17765 23 15 \n", "1520 199107 7 12337 8077 16597 22 15 \n", "1521 199106 7 10877 7013 14741 19 12 \n", "1522 199105 7 10442 6544 14340 18 11 \n", "1523 199104 7 7913 4563 11263 14 8 \n", "1524 199103 7 15387 10484 20290 27 18 \n", "1525 199102 7 16277 11046 21508 29 20 \n", "1526 199101 7 15565 10271 20859 27 18 \n", "1527 199052 7 19375 13295 25455 34 23 \n", "1528 199051 7 19080 13807 24353 34 25 \n", "1529 199050 7 11079 6660 15498 20 12 \n", "1530 199049 7 1143 0 2610 2 0 \n", "\n", " inc100_up geo_insee geo_name \n", "0 10 FR France \n", "1 14 FR France \n", "2 16 FR France \n", "3 19 FR France \n", "4 18 FR France \n", "5 26 FR France \n", "6 20 FR France \n", "7 18 FR France \n", "8 18 FR France \n", "9 16 FR France \n", "10 15 FR France \n", "11 12 FR France \n", "12 13 FR France \n", "13 19 FR France \n", "14 16 FR France \n", "15 12 FR France \n", "16 13 FR France \n", "17 13 FR France \n", "18 11 FR France \n", "19 15 FR France \n", "20 6 FR France \n", "21 10 FR France \n", "22 12 FR France \n", "23 10 FR France \n", "24 13 FR France \n", "25 9 FR France \n", "26 9 FR France \n", "27 8 FR France \n", "28 8 FR France \n", "29 2 FR France \n", "... ... ... ... \n", "1501 42 FR France \n", "1502 38 FR France \n", "1503 39 FR France \n", "1504 29 FR France \n", "1505 37 FR France \n", "1506 36 FR France \n", "1507 45 FR France \n", "1508 39 FR France \n", "1509 51 FR France \n", "1510 32 FR France \n", "1511 34 FR France \n", "1512 32 FR France \n", "1513 30 FR France \n", "1514 23 FR France \n", "1515 25 FR France \n", "1516 35 FR France \n", "1517 38 FR France \n", "1518 33 FR France \n", "1519 31 FR France \n", "1520 29 FR France \n", "1521 26 FR France \n", "1522 25 FR France \n", "1523 20 FR France \n", "1524 36 FR France \n", "1525 38 FR France \n", "1526 36 FR France \n", "1527 45 FR France \n", "1528 43 FR France \n", "1529 28 FR France \n", "1530 5 FR France \n", "\n", "[1531 rows x 10 columns]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "raw_data = pd.read_csv(data_file, skiprows=1)\n", "raw_data" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Contrairement aux données sur les syndrômes grippaux, celles-ci ne contiennent aucune ligne vide :" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "hideCode": false, "hideOutput": true }, "outputs": [ { "data": { "text/html": [ "
\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
\n", "
" ], "text/plain": [ "Empty DataFrame\n", "Columns: [week, indicator, inc, inc_low, inc_up, inc100, inc100_low, inc100_up, geo_insee, geo_name]\n", "Index: []" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "raw_data[raw_data.isnull().any(axis=1)]" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [], "source": [ "data = raw_data" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "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'." ] }, { "cell_type": "code", "execution_count": 13, "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", "data['period'] = [convert_week(yw) for yw in data['week']]" ] }, { "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \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_nameperiod
020201474624260266467410FRFrance2020-03-30/2020-04-05
1202013773715268947411814FRFrance2020-03-23/2020-03-29
22020127812357901045612816FRFrance2020-03-16/2020-03-22
3202011710198756812828151119FRFrance2020-03-09/2020-03-15
420201079011669111331141018FRFrance2020-03-02/2020-03-08
52020097136311054416718211626FRFrance2020-02-24/2020-03-01
6202008710424770813140161220FRFrance2020-02-17/2020-02-23
720200778959657411344141018FRFrance2020-02-10/2020-02-16
820200679264692511603141018FRFrance2020-02-03/2020-02-09
920200578505631410696131016FRFrance2020-01-27/2020-02-02
102020047799158311015112915FRFrance2020-01-20/2020-01-26
1120200375968410078369612FRFrance2020-01-13/2020-01-19
12202002765344530853810713FRFrance2020-01-06/2020-01-12
1320200179835701912651151119FRFrance2019-12-30/2020-01-05
142019527794152461063612816FRFrance2019-12-23/2019-12-29
1520195175823367579719612FRFrance2019-12-16/2019-12-22
16201950764244276857210713FRFrance2019-12-09/2019-12-15
17201949766214540870210713FRFrance2019-12-02/2019-12-08
1820194875542338377018511FRFrance2019-11-25/2019-12-01
192019477753650581001411715FRFrance2019-11-18/2019-11-24
202019467263813163960426FRFrance2019-11-11/2019-11-17
2120194574492261563697410FRFrance2019-11-04/2019-11-10
2220194475728362778299612FRFrance2019-10-28/2019-11-03
2320194374834275169177410FRFrance2019-10-21/2019-10-27
24201942762793989856910713FRFrance2019-10-14/2019-10-20
252019417413020306230639FRFrance2019-10-07/2019-10-13
262019407421122186204639FRFrance2019-09-30/2019-10-06
272019397313713104964528FRFrance2019-09-23/2019-09-29
282019387307814164740528FRFrance2019-09-16/2019-09-22
2920193779701621778102FRFrance2019-09-09/2019-09-15
....................................
15011991267176081130423912312042FRFrance1991-06-24/1991-06-30
15021991257161691070021638281838FRFrance1991-06-17/1991-06-23
15031991247161711007122271281739FRFrance1991-06-10/1991-06-16
1504199123711947767116223211329FRFrance1991-06-03/1991-06-09
1505199122715452995320951271737FRFrance1991-05-27/1991-06-02
1506199121714903897520831261636FRFrance1991-05-20/1991-05-26
15071991207190531274225364342345FRFrance1991-05-13/1991-05-19
15081991197167391124622232291939FRFrance1991-05-06/1991-05-12
15091991187213851388228888382551FRFrance1991-04-29/1991-05-05
1510199117713462887718047241632FRFrance1991-04-22/1991-04-28
15111991167148571006819646261834FRFrance1991-04-15/1991-04-21
1512199115713975978118169251832FRFrance1991-04-08/1991-04-14
1513199114712265768416846221430FRFrance1991-04-01/1991-04-07
151419911379567604113093171123FRFrance1991-03-25/1991-03-31
1515199112710864733114397191325FRFrance1991-03-18/1991-03-24
15161991117155741118419964271935FRFrance1991-03-11/1991-03-17
15171991107166431137221914292038FRFrance1991-03-04/1991-03-10
1518199109713741878018702241533FRFrance1991-02-25/1991-03-03
1519199108713289881317765231531FRFrance1991-02-18/1991-02-24
1520199107712337807716597221529FRFrance1991-02-11/1991-02-17
1521199106710877701314741191226FRFrance1991-02-04/1991-02-10
1522199105710442654414340181125FRFrance1991-01-28/1991-02-03
15231991047791345631126314820FRFrance1991-01-21/1991-01-27
15241991037153871048420290271836FRFrance1991-01-14/1991-01-20
15251991027162771104621508292038FRFrance1991-01-07/1991-01-13
15261991017155651027120859271836FRFrance1990-12-31/1991-01-06
15271990527193751329525455342345FRFrance1990-12-24/1990-12-30
15281990517190801380724353342543FRFrance1990-12-17/1990-12-23
1529199050711079666015498201228FRFrance1990-12-10/1990-12-16
15301990497114302610205FRFrance1990-12-03/1990-12-09
\n", "

1531 rows × 11 columns

\n", "
" ], "text/plain": [ " week indicator inc inc_low inc_up inc100 inc100_low \\\n", "0 202014 7 4624 2602 6646 7 4 \n", "1 202013 7 7371 5268 9474 11 8 \n", "2 202012 7 8123 5790 10456 12 8 \n", "3 202011 7 10198 7568 12828 15 11 \n", "4 202010 7 9011 6691 11331 14 10 \n", "5 202009 7 13631 10544 16718 21 16 \n", "6 202008 7 10424 7708 13140 16 12 \n", "7 202007 7 8959 6574 11344 14 10 \n", "8 202006 7 9264 6925 11603 14 10 \n", "9 202005 7 8505 6314 10696 13 10 \n", "10 202004 7 7991 5831 10151 12 9 \n", "11 202003 7 5968 4100 7836 9 6 \n", "12 202002 7 6534 4530 8538 10 7 \n", "13 202001 7 9835 7019 12651 15 11 \n", "14 201952 7 7941 5246 10636 12 8 \n", "15 201951 7 5823 3675 7971 9 6 \n", "16 201950 7 6424 4276 8572 10 7 \n", "17 201949 7 6621 4540 8702 10 7 \n", "18 201948 7 5542 3383 7701 8 5 \n", "19 201947 7 7536 5058 10014 11 7 \n", "20 201946 7 2638 1316 3960 4 2 \n", "21 201945 7 4492 2615 6369 7 4 \n", "22 201944 7 5728 3627 7829 9 6 \n", "23 201943 7 4834 2751 6917 7 4 \n", "24 201942 7 6279 3989 8569 10 7 \n", "25 201941 7 4130 2030 6230 6 3 \n", "26 201940 7 4211 2218 6204 6 3 \n", "27 201939 7 3137 1310 4964 5 2 \n", "28 201938 7 3078 1416 4740 5 2 \n", "29 201937 7 970 162 1778 1 0 \n", "... ... ... ... ... ... ... ... \n", "1501 199126 7 17608 11304 23912 31 20 \n", "1502 199125 7 16169 10700 21638 28 18 \n", "1503 199124 7 16171 10071 22271 28 17 \n", "1504 199123 7 11947 7671 16223 21 13 \n", "1505 199122 7 15452 9953 20951 27 17 \n", "1506 199121 7 14903 8975 20831 26 16 \n", "1507 199120 7 19053 12742 25364 34 23 \n", "1508 199119 7 16739 11246 22232 29 19 \n", "1509 199118 7 21385 13882 28888 38 25 \n", "1510 199117 7 13462 8877 18047 24 16 \n", "1511 199116 7 14857 10068 19646 26 18 \n", "1512 199115 7 13975 9781 18169 25 18 \n", "1513 199114 7 12265 7684 16846 22 14 \n", "1514 199113 7 9567 6041 13093 17 11 \n", "1515 199112 7 10864 7331 14397 19 13 \n", "1516 199111 7 15574 11184 19964 27 19 \n", "1517 199110 7 16643 11372 21914 29 20 \n", "1518 199109 7 13741 8780 18702 24 15 \n", "1519 199108 7 13289 8813 17765 23 15 \n", "1520 199107 7 12337 8077 16597 22 15 \n", "1521 199106 7 10877 7013 14741 19 12 \n", "1522 199105 7 10442 6544 14340 18 11 \n", "1523 199104 7 7913 4563 11263 14 8 \n", "1524 199103 7 15387 10484 20290 27 18 \n", "1525 199102 7 16277 11046 21508 29 20 \n", "1526 199101 7 15565 10271 20859 27 18 \n", "1527 199052 7 19375 13295 25455 34 23 \n", "1528 199051 7 19080 13807 24353 34 25 \n", "1529 199050 7 11079 6660 15498 20 12 \n", "1530 199049 7 1143 0 2610 2 0 \n", "\n", " inc100_up geo_insee geo_name period \n", "0 10 FR France 2020-03-30/2020-04-05 \n", "1 14 FR France 2020-03-23/2020-03-29 \n", "2 16 FR France 2020-03-16/2020-03-22 \n", "3 19 FR France 2020-03-09/2020-03-15 \n", "4 18 FR France 2020-03-02/2020-03-08 \n", "5 26 FR France 2020-02-24/2020-03-01 \n", "6 20 FR France 2020-02-17/2020-02-23 \n", "7 18 FR France 2020-02-10/2020-02-16 \n", "8 18 FR France 2020-02-03/2020-02-09 \n", "9 16 FR France 2020-01-27/2020-02-02 \n", "10 15 FR France 2020-01-20/2020-01-26 \n", "11 12 FR France 2020-01-13/2020-01-19 \n", "12 13 FR France 2020-01-06/2020-01-12 \n", "13 19 FR France 2019-12-30/2020-01-05 \n", "14 16 FR France 2019-12-23/2019-12-29 \n", "15 12 FR France 2019-12-16/2019-12-22 \n", "16 13 FR France 2019-12-09/2019-12-15 \n", "17 13 FR France 2019-12-02/2019-12-08 \n", "18 11 FR France 2019-11-25/2019-12-01 \n", "19 15 FR France 2019-11-18/2019-11-24 \n", "20 6 FR France 2019-11-11/2019-11-17 \n", "21 10 FR France 2019-11-04/2019-11-10 \n", "22 12 FR France 2019-10-28/2019-11-03 \n", "23 10 FR France 2019-10-21/2019-10-27 \n", "24 13 FR France 2019-10-14/2019-10-20 \n", "25 9 FR France 2019-10-07/2019-10-13 \n", "26 9 FR France 2019-09-30/2019-10-06 \n", "27 8 FR France 2019-09-23/2019-09-29 \n", "28 8 FR France 2019-09-16/2019-09-22 \n", "29 2 FR France 2019-09-09/2019-09-15 \n", "... ... ... ... ... \n", "1501 42 FR France 1991-06-24/1991-06-30 \n", "1502 38 FR France 1991-06-17/1991-06-23 \n", "1503 39 FR France 1991-06-10/1991-06-16 \n", "1504 29 FR France 1991-06-03/1991-06-09 \n", "1505 37 FR France 1991-05-27/1991-06-02 \n", "1506 36 FR France 1991-05-20/1991-05-26 \n", "1507 45 FR France 1991-05-13/1991-05-19 \n", "1508 39 FR France 1991-05-06/1991-05-12 \n", "1509 51 FR France 1991-04-29/1991-05-05 \n", "1510 32 FR France 1991-04-22/1991-04-28 \n", "1511 34 FR France 1991-04-15/1991-04-21 \n", "1512 32 FR France 1991-04-08/1991-04-14 \n", "1513 30 FR France 1991-04-01/1991-04-07 \n", "1514 23 FR France 1991-03-25/1991-03-31 \n", "1515 25 FR France 1991-03-18/1991-03-24 \n", "1516 35 FR France 1991-03-11/1991-03-17 \n", "1517 38 FR France 1991-03-04/1991-03-10 \n", "1518 33 FR France 1991-02-25/1991-03-03 \n", "1519 31 FR France 1991-02-18/1991-02-24 \n", "1520 29 FR France 1991-02-11/1991-02-17 \n", "1521 26 FR France 1991-02-04/1991-02-10 \n", "1522 25 FR France 1991-01-28/1991-02-03 \n", "1523 20 FR France 1991-01-21/1991-01-27 \n", "1524 36 FR France 1991-01-14/1991-01-20 \n", "1525 38 FR France 1991-01-07/1991-01-13 \n", "1526 36 FR France 1990-12-31/1991-01-06 \n", "1527 45 FR France 1990-12-24/1990-12-30 \n", "1528 43 FR France 1990-12-17/1990-12-23 \n", "1529 28 FR France 1990-12-10/1990-12-16 \n", "1530 5 FR France 1990-12-03/1990-12-09 \n", "\n", "[1531 rows x 11 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data" ] } ], "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 }