{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Analyse de l'indice de la varicelle" ] }, { "cell_type": "code", "execution_count": 30, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline \n", "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as plt \n", "import isoweek\n" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [], "source": [ "data_url = \"https://www.sentiweb.fr/datasets/all/inc-7-PAY.csv\"" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [], "source": [ "data_file = \"inc-7-PAY.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": 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
020251875795271488769414FRFrance
120251776323343692109513FRFrance
220251676151319391099513FRFrance
320251575557326278528511FRFrance
420251474984285871107410FRFrance
520251375964360883209513FRFrance
62025127385519955715639FRFrance
720251175878274790099414FRFrance
82025107292114214421426FRFrance
92025097338114685294528FRFrance
102025087283512864384426FRFrance
1120250774502238266227410FRFrance
122025067345519584952537FRFrance
132025057208710563118315FRFrance
14202504768954466932410614FRFrance
152025037246211613763426FRFrance
1620250275966275791759414FRFrance
1720250176059245196679414FRFrance
1820245274356177669367311FRFrance
1920245174670223971017311FRFrance
202024507736344381028811715FRFrance
2120244976077363185239513FRFrance
2220244874189145469246210FRFrance
23202447719317263136315FRFrance
24202446722608633657315FRFrance
252024457271312164210426FRFrance
26202444721356763594315FRFrance
27202443721246413607315FRFrance
282024427262112463996426FRFrance
29202441720353813689315FRFrance
.................................
17661991267176081130423912312042FRFrance
17671991257161691070021638281838FRFrance
17681991247161711007122271281739FRFrance
1769199123711947767116223211329FRFrance
1770199122715452995320951271737FRFrance
1771199121714903897520831261636FRFrance
17721991207190531274225364342345FRFrance
17731991197167391124622232291939FRFrance
17741991187213851388228888382551FRFrance
1775199117713462887718047241632FRFrance
17761991167148571006819646261834FRFrance
1777199115713975978118169251832FRFrance
1778199114712265768416846221430FRFrance
177919911379567604113093171123FRFrance
1780199112710864733114397191325FRFrance
17811991117155741118419964271935FRFrance
17821991107166431137221914292038FRFrance
1783199109713741878018702241533FRFrance
1784199108713289881317765231531FRFrance
1785199107712337807716597221529FRFrance
1786199106710877701314741191226FRFrance
1787199105710442654414340181125FRFrance
17881991047791345631126314820FRFrance
17891991037153871048420290271836FRFrance
17901991027162771104621508292038FRFrance
17911991017155651027120859271836FRFrance
17921990527193751329525455342345FRFrance
17931990517190801380724353342543FRFrance
1794199050711079666015498201228FRFrance
17951990497114302610205FRFrance
\n", "

1796 rows × 10 columns

\n", "
" ], "text/plain": [ " week indicator inc inc_low inc_up inc100 inc100_low \\\n", "0 202518 7 5795 2714 8876 9 4 \n", "1 202517 7 6323 3436 9210 9 5 \n", "2 202516 7 6151 3193 9109 9 5 \n", "3 202515 7 5557 3262 7852 8 5 \n", "4 202514 7 4984 2858 7110 7 4 \n", "5 202513 7 5964 3608 8320 9 5 \n", "6 202512 7 3855 1995 5715 6 3 \n", "7 202511 7 5878 2747 9009 9 4 \n", "8 202510 7 2921 1421 4421 4 2 \n", "9 202509 7 3381 1468 5294 5 2 \n", "10 202508 7 2835 1286 4384 4 2 \n", "11 202507 7 4502 2382 6622 7 4 \n", "12 202506 7 3455 1958 4952 5 3 \n", "13 202505 7 2087 1056 3118 3 1 \n", "14 202504 7 6895 4466 9324 10 6 \n", "15 202503 7 2462 1161 3763 4 2 \n", "16 202502 7 5966 2757 9175 9 4 \n", "17 202501 7 6059 2451 9667 9 4 \n", "18 202452 7 4356 1776 6936 7 3 \n", "19 202451 7 4670 2239 7101 7 3 \n", "20 202450 7 7363 4438 10288 11 7 \n", "21 202449 7 6077 3631 8523 9 5 \n", "22 202448 7 4189 1454 6924 6 2 \n", "23 202447 7 1931 726 3136 3 1 \n", "24 202446 7 2260 863 3657 3 1 \n", "25 202445 7 2713 1216 4210 4 2 \n", "26 202444 7 2135 676 3594 3 1 \n", "27 202443 7 2124 641 3607 3 1 \n", "28 202442 7 2621 1246 3996 4 2 \n", "29 202441 7 2035 381 3689 3 1 \n", "... ... ... ... ... ... ... ... \n", "1766 199126 7 17608 11304 23912 31 20 \n", "1767 199125 7 16169 10700 21638 28 18 \n", "1768 199124 7 16171 10071 22271 28 17 \n", "1769 199123 7 11947 7671 16223 21 13 \n", "1770 199122 7 15452 9953 20951 27 17 \n", "1771 199121 7 14903 8975 20831 26 16 \n", "1772 199120 7 19053 12742 25364 34 23 \n", "1773 199119 7 16739 11246 22232 29 19 \n", "1774 199118 7 21385 13882 28888 38 25 \n", "1775 199117 7 13462 8877 18047 24 16 \n", "1776 199116 7 14857 10068 19646 26 18 \n", "1777 199115 7 13975 9781 18169 25 18 \n", "1778 199114 7 12265 7684 16846 22 14 \n", "1779 199113 7 9567 6041 13093 17 11 \n", "1780 199112 7 10864 7331 14397 19 13 \n", "1781 199111 7 15574 11184 19964 27 19 \n", "1782 199110 7 16643 11372 21914 29 20 \n", "1783 199109 7 13741 8780 18702 24 15 \n", "1784 199108 7 13289 8813 17765 23 15 \n", "1785 199107 7 12337 8077 16597 22 15 \n", "1786 199106 7 10877 7013 14741 19 12 \n", "1787 199105 7 10442 6544 14340 18 11 \n", "1788 199104 7 7913 4563 11263 14 8 \n", "1789 199103 7 15387 10484 20290 27 18 \n", "1790 199102 7 16277 11046 21508 29 20 \n", "1791 199101 7 15565 10271 20859 27 18 \n", "1792 199052 7 19375 13295 25455 34 23 \n", "1793 199051 7 19080 13807 24353 34 25 \n", "1794 199050 7 11079 6660 15498 20 12 \n", "1795 199049 7 1143 0 2610 2 0 \n", "\n", " inc100_up geo_insee geo_name \n", "0 14 FR France \n", "1 13 FR France \n", "2 13 FR France \n", "3 11 FR France \n", "4 10 FR France \n", "5 13 FR France \n", "6 9 FR France \n", "7 14 FR France \n", "8 6 FR France \n", "9 8 FR France \n", "10 6 FR France \n", "11 10 FR France \n", "12 7 FR France \n", "13 5 FR France \n", "14 14 FR France \n", "15 6 FR France \n", "16 14 FR France \n", "17 14 FR France \n", "18 11 FR France \n", "19 11 FR France \n", "20 15 FR France \n", "21 13 FR France \n", "22 10 FR France \n", "23 5 FR France \n", "24 5 FR France \n", "25 6 FR France \n", "26 5 FR France \n", "27 5 FR France \n", "28 6 FR France \n", "29 5 FR France \n", "... ... ... ... \n", "1766 42 FR France \n", "1767 38 FR France \n", "1768 39 FR France \n", "1769 29 FR France \n", "1770 37 FR France \n", "1771 36 FR France \n", "1772 45 FR France \n", "1773 39 FR France \n", "1774 51 FR France \n", "1775 32 FR France \n", "1776 34 FR France \n", "1777 32 FR France \n", "1778 30 FR France \n", "1779 23 FR France \n", "1780 25 FR France \n", "1781 35 FR France \n", "1782 38 FR France \n", "1783 33 FR France \n", "1784 31 FR France \n", "1785 29 FR France \n", "1786 26 FR France \n", "1787 25 FR France \n", "1788 20 FR France \n", "1789 36 FR France \n", "1790 38 FR France \n", "1791 36 FR France \n", "1792 45 FR France \n", "1793 43 FR France \n", "1794 28 FR France \n", "1795 5 FR France \n", "\n", "[1796 rows x 10 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "raw_data = pd.read_csv(data_file, skiprows=1)\n", "raw_data" ] }, { "cell_type": "code", "execution_count": 15, "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", "
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": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "raw_data[raw_data.isnull().any(axis=1)]" ] }, { "cell_type": "code", "execution_count": 17, "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", "raw_data['period'] = [convert_week(yw) for yw in raw_data['week']]" ] }, { "cell_type": "code", "execution_count": 18, "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
020251875795271488769414FRFrance2025-04-28/2025-05-04
120251776323343692109513FRFrance2025-04-21/2025-04-27
220251676151319391099513FRFrance2025-04-14/2025-04-20
320251575557326278528511FRFrance2025-04-07/2025-04-13
420251474984285871107410FRFrance2025-03-31/2025-04-06
520251375964360883209513FRFrance2025-03-24/2025-03-30
62025127385519955715639FRFrance2025-03-17/2025-03-23
720251175878274790099414FRFrance2025-03-10/2025-03-16
82025107292114214421426FRFrance2025-03-03/2025-03-09
92025097338114685294528FRFrance2025-02-24/2025-03-02
102025087283512864384426FRFrance2025-02-17/2025-02-23
1120250774502238266227410FRFrance2025-02-10/2025-02-16
122025067345519584952537FRFrance2025-02-03/2025-02-09
132025057208710563118315FRFrance2025-01-27/2025-02-02
14202504768954466932410614FRFrance2025-01-20/2025-01-26
152025037246211613763426FRFrance2025-01-13/2025-01-19
1620250275966275791759414FRFrance2025-01-06/2025-01-12
1720250176059245196679414FRFrance2024-12-30/2025-01-05
1820245274356177669367311FRFrance2024-12-23/2024-12-29
1920245174670223971017311FRFrance2024-12-16/2024-12-22
202024507736344381028811715FRFrance2024-12-09/2024-12-15
2120244976077363185239513FRFrance2024-12-02/2024-12-08
2220244874189145469246210FRFrance2024-11-25/2024-12-01
23202447719317263136315FRFrance2024-11-18/2024-11-24
24202446722608633657315FRFrance2024-11-11/2024-11-17
252024457271312164210426FRFrance2024-11-04/2024-11-10
26202444721356763594315FRFrance2024-10-28/2024-11-03
27202443721246413607315FRFrance2024-10-21/2024-10-27
282024427262112463996426FRFrance2024-10-14/2024-10-20
29202441720353813689315FRFrance2024-10-07/2024-10-13
....................................
17661991267176081130423912312042FRFrance1991-06-24/1991-06-30
17671991257161691070021638281838FRFrance1991-06-17/1991-06-23
17681991247161711007122271281739FRFrance1991-06-10/1991-06-16
1769199123711947767116223211329FRFrance1991-06-03/1991-06-09
1770199122715452995320951271737FRFrance1991-05-27/1991-06-02
1771199121714903897520831261636FRFrance1991-05-20/1991-05-26
17721991207190531274225364342345FRFrance1991-05-13/1991-05-19
17731991197167391124622232291939FRFrance1991-05-06/1991-05-12
17741991187213851388228888382551FRFrance1991-04-29/1991-05-05
1775199117713462887718047241632FRFrance1991-04-22/1991-04-28
17761991167148571006819646261834FRFrance1991-04-15/1991-04-21
1777199115713975978118169251832FRFrance1991-04-08/1991-04-14
1778199114712265768416846221430FRFrance1991-04-01/1991-04-07
177919911379567604113093171123FRFrance1991-03-25/1991-03-31
1780199112710864733114397191325FRFrance1991-03-18/1991-03-24
17811991117155741118419964271935FRFrance1991-03-11/1991-03-17
17821991107166431137221914292038FRFrance1991-03-04/1991-03-10
1783199109713741878018702241533FRFrance1991-02-25/1991-03-03
1784199108713289881317765231531FRFrance1991-02-18/1991-02-24
1785199107712337807716597221529FRFrance1991-02-11/1991-02-17
1786199106710877701314741191226FRFrance1991-02-04/1991-02-10
1787199105710442654414340181125FRFrance1991-01-28/1991-02-03
17881991047791345631126314820FRFrance1991-01-21/1991-01-27
17891991037153871048420290271836FRFrance1991-01-14/1991-01-20
17901991027162771104621508292038FRFrance1991-01-07/1991-01-13
17911991017155651027120859271836FRFrance1990-12-31/1991-01-06
17921990527193751329525455342345FRFrance1990-12-24/1990-12-30
17931990517190801380724353342543FRFrance1990-12-17/1990-12-23
1794199050711079666015498201228FRFrance1990-12-10/1990-12-16
17951990497114302610205FRFrance1990-12-03/1990-12-09
\n", "

1796 rows × 11 columns

\n", "
" ], "text/plain": [ " week indicator inc inc_low inc_up inc100 inc100_low \\\n", "0 202518 7 5795 2714 8876 9 4 \n", "1 202517 7 6323 3436 9210 9 5 \n", "2 202516 7 6151 3193 9109 9 5 \n", "3 202515 7 5557 3262 7852 8 5 \n", "4 202514 7 4984 2858 7110 7 4 \n", "5 202513 7 5964 3608 8320 9 5 \n", "6 202512 7 3855 1995 5715 6 3 \n", "7 202511 7 5878 2747 9009 9 4 \n", "8 202510 7 2921 1421 4421 4 2 \n", "9 202509 7 3381 1468 5294 5 2 \n", "10 202508 7 2835 1286 4384 4 2 \n", "11 202507 7 4502 2382 6622 7 4 \n", "12 202506 7 3455 1958 4952 5 3 \n", "13 202505 7 2087 1056 3118 3 1 \n", "14 202504 7 6895 4466 9324 10 6 \n", "15 202503 7 2462 1161 3763 4 2 \n", "16 202502 7 5966 2757 9175 9 4 \n", "17 202501 7 6059 2451 9667 9 4 \n", "18 202452 7 4356 1776 6936 7 3 \n", "19 202451 7 4670 2239 7101 7 3 \n", "20 202450 7 7363 4438 10288 11 7 \n", "21 202449 7 6077 3631 8523 9 5 \n", "22 202448 7 4189 1454 6924 6 2 \n", "23 202447 7 1931 726 3136 3 1 \n", "24 202446 7 2260 863 3657 3 1 \n", "25 202445 7 2713 1216 4210 4 2 \n", "26 202444 7 2135 676 3594 3 1 \n", "27 202443 7 2124 641 3607 3 1 \n", "28 202442 7 2621 1246 3996 4 2 \n", "29 202441 7 2035 381 3689 3 1 \n", "... ... ... ... ... ... ... ... \n", "1766 199126 7 17608 11304 23912 31 20 \n", "1767 199125 7 16169 10700 21638 28 18 \n", "1768 199124 7 16171 10071 22271 28 17 \n", "1769 199123 7 11947 7671 16223 21 13 \n", "1770 199122 7 15452 9953 20951 27 17 \n", "1771 199121 7 14903 8975 20831 26 16 \n", "1772 199120 7 19053 12742 25364 34 23 \n", "1773 199119 7 16739 11246 22232 29 19 \n", "1774 199118 7 21385 13882 28888 38 25 \n", "1775 199117 7 13462 8877 18047 24 16 \n", "1776 199116 7 14857 10068 19646 26 18 \n", "1777 199115 7 13975 9781 18169 25 18 \n", "1778 199114 7 12265 7684 16846 22 14 \n", "1779 199113 7 9567 6041 13093 17 11 \n", "1780 199112 7 10864 7331 14397 19 13 \n", "1781 199111 7 15574 11184 19964 27 19 \n", "1782 199110 7 16643 11372 21914 29 20 \n", "1783 199109 7 13741 8780 18702 24 15 \n", "1784 199108 7 13289 8813 17765 23 15 \n", "1785 199107 7 12337 8077 16597 22 15 \n", "1786 199106 7 10877 7013 14741 19 12 \n", "1787 199105 7 10442 6544 14340 18 11 \n", "1788 199104 7 7913 4563 11263 14 8 \n", "1789 199103 7 15387 10484 20290 27 18 \n", "1790 199102 7 16277 11046 21508 29 20 \n", "1791 199101 7 15565 10271 20859 27 18 \n", "1792 199052 7 19375 13295 25455 34 23 \n", "1793 199051 7 19080 13807 24353 34 25 \n", "1794 199050 7 11079 6660 15498 20 12 \n", "1795 199049 7 1143 0 2610 2 0 \n", "\n", " inc100_up geo_insee geo_name period \n", "0 14 FR France 2025-04-28/2025-05-04 \n", "1 13 FR France 2025-04-21/2025-04-27 \n", "2 13 FR France 2025-04-14/2025-04-20 \n", "3 11 FR France 2025-04-07/2025-04-13 \n", "4 10 FR France 2025-03-31/2025-04-06 \n", "5 13 FR France 2025-03-24/2025-03-30 \n", "6 9 FR France 2025-03-17/2025-03-23 \n", "7 14 FR France 2025-03-10/2025-03-16 \n", "8 6 FR France 2025-03-03/2025-03-09 \n", "9 8 FR France 2025-02-24/2025-03-02 \n", "10 6 FR France 2025-02-17/2025-02-23 \n", "11 10 FR France 2025-02-10/2025-02-16 \n", "12 7 FR France 2025-02-03/2025-02-09 \n", "13 5 FR France 2025-01-27/2025-02-02 \n", "14 14 FR France 2025-01-20/2025-01-26 \n", "15 6 FR France 2025-01-13/2025-01-19 \n", "16 14 FR France 2025-01-06/2025-01-12 \n", "17 14 FR France 2024-12-30/2025-01-05 \n", "18 11 FR France 2024-12-23/2024-12-29 \n", "19 11 FR France 2024-12-16/2024-12-22 \n", "20 15 FR France 2024-12-09/2024-12-15 \n", "21 13 FR France 2024-12-02/2024-12-08 \n", "22 10 FR France 2024-11-25/2024-12-01 \n", "23 5 FR France 2024-11-18/2024-11-24 \n", "24 5 FR France 2024-11-11/2024-11-17 \n", "25 6 FR France 2024-11-04/2024-11-10 \n", "26 5 FR France 2024-10-28/2024-11-03 \n", "27 5 FR France 2024-10-21/2024-10-27 \n", "28 6 FR France 2024-10-14/2024-10-20 \n", "29 5 FR France 2024-10-07/2024-10-13 \n", "... ... ... ... ... \n", "1766 42 FR France 1991-06-24/1991-06-30 \n", "1767 38 FR France 1991-06-17/1991-06-23 \n", "1768 39 FR France 1991-06-10/1991-06-16 \n", "1769 29 FR France 1991-06-03/1991-06-09 \n", "1770 37 FR France 1991-05-27/1991-06-02 \n", "1771 36 FR France 1991-05-20/1991-05-26 \n", "1772 45 FR France 1991-05-13/1991-05-19 \n", "1773 39 FR France 1991-05-06/1991-05-12 \n", "1774 51 FR France 1991-04-29/1991-05-05 \n", "1775 32 FR France 1991-04-22/1991-04-28 \n", "1776 34 FR France 1991-04-15/1991-04-21 \n", "1777 32 FR France 1991-04-08/1991-04-14 \n", "1778 30 FR France 1991-04-01/1991-04-07 \n", "1779 23 FR France 1991-03-25/1991-03-31 \n", "1780 25 FR France 1991-03-18/1991-03-24 \n", "1781 35 FR France 1991-03-11/1991-03-17 \n", "1782 38 FR France 1991-03-04/1991-03-10 \n", "1783 33 FR France 1991-02-25/1991-03-03 \n", "1784 31 FR France 1991-02-18/1991-02-24 \n", "1785 29 FR France 1991-02-11/1991-02-17 \n", "1786 26 FR France 1991-02-04/1991-02-10 \n", "1787 25 FR France 1991-01-28/1991-02-03 \n", "1788 20 FR France 1991-01-21/1991-01-27 \n", "1789 36 FR France 1991-01-14/1991-01-20 \n", "1790 38 FR France 1991-01-07/1991-01-13 \n", "1791 36 FR France 1990-12-31/1991-01-06 \n", "1792 45 FR France 1990-12-24/1990-12-30 \n", "1793 43 FR France 1990-12-17/1990-12-23 \n", "1794 28 FR France 1990-12-10/1990-12-16 \n", "1795 5 FR France 1990-12-03/1990-12-09 \n", "\n", "[1796 rows x 11 columns]" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "raw_data" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [], "source": [ "sorted_data = raw_data.set_index('period').sort_index()" ] }, { "cell_type": "code", "execution_count": 20, "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", "
weekindicatorincinc_lowinc_upinc100inc100_lowinc100_upgeo_inseegeo_name
period
1990-12-03/1990-12-091990497114302610205FRFrance
1990-12-10/1990-12-16199050711079666015498201228FRFrance
1990-12-17/1990-12-231990517190801380724353342543FRFrance
1990-12-24/1990-12-301990527193751329525455342345FRFrance
1990-12-31/1991-01-061991017155651027120859271836FRFrance
1991-01-07/1991-01-131991027162771104621508292038FRFrance
1991-01-14/1991-01-201991037153871048420290271836FRFrance
1991-01-21/1991-01-271991047791345631126314820FRFrance
1991-01-28/1991-02-03199105710442654414340181125FRFrance
1991-02-04/1991-02-10199106710877701314741191226FRFrance
1991-02-11/1991-02-17199107712337807716597221529FRFrance
1991-02-18/1991-02-24199108713289881317765231531FRFrance
1991-02-25/1991-03-03199109713741878018702241533FRFrance
1991-03-04/1991-03-101991107166431137221914292038FRFrance
1991-03-11/1991-03-171991117155741118419964271935FRFrance
1991-03-18/1991-03-24199112710864733114397191325FRFrance
1991-03-25/1991-03-3119911379567604113093171123FRFrance
1991-04-01/1991-04-07199114712265768416846221430FRFrance
1991-04-08/1991-04-14199115713975978118169251832FRFrance
1991-04-15/1991-04-211991167148571006819646261834FRFrance
1991-04-22/1991-04-28199117713462887718047241632FRFrance
1991-04-29/1991-05-051991187213851388228888382551FRFrance
1991-05-06/1991-05-121991197167391124622232291939FRFrance
1991-05-13/1991-05-191991207190531274225364342345FRFrance
1991-05-20/1991-05-26199121714903897520831261636FRFrance
1991-05-27/1991-06-02199122715452995320951271737FRFrance
1991-06-03/1991-06-09199123711947767116223211329FRFrance
1991-06-10/1991-06-161991247161711007122271281739FRFrance
1991-06-17/1991-06-231991257161691070021638281838FRFrance
1991-06-24/1991-06-301991267176081130423912312042FRFrance
.................................
2024-10-07/2024-10-13202441720353813689315FRFrance
2024-10-14/2024-10-202024427262112463996426FRFrance
2024-10-21/2024-10-27202443721246413607315FRFrance
2024-10-28/2024-11-03202444721356763594315FRFrance
2024-11-04/2024-11-102024457271312164210426FRFrance
2024-11-11/2024-11-17202446722608633657315FRFrance
2024-11-18/2024-11-24202447719317263136315FRFrance
2024-11-25/2024-12-0120244874189145469246210FRFrance
2024-12-02/2024-12-0820244976077363185239513FRFrance
2024-12-09/2024-12-152024507736344381028811715FRFrance
2024-12-16/2024-12-2220245174670223971017311FRFrance
2024-12-23/2024-12-2920245274356177669367311FRFrance
2024-12-30/2025-01-0520250176059245196679414FRFrance
2025-01-06/2025-01-1220250275966275791759414FRFrance
2025-01-13/2025-01-192025037246211613763426FRFrance
2025-01-20/2025-01-26202504768954466932410614FRFrance
2025-01-27/2025-02-022025057208710563118315FRFrance
2025-02-03/2025-02-092025067345519584952537FRFrance
2025-02-10/2025-02-1620250774502238266227410FRFrance
2025-02-17/2025-02-232025087283512864384426FRFrance
2025-02-24/2025-03-022025097338114685294528FRFrance
2025-03-03/2025-03-092025107292114214421426FRFrance
2025-03-10/2025-03-1620251175878274790099414FRFrance
2025-03-17/2025-03-232025127385519955715639FRFrance
2025-03-24/2025-03-3020251375964360883209513FRFrance
2025-03-31/2025-04-0620251474984285871107410FRFrance
2025-04-07/2025-04-1320251575557326278528511FRFrance
2025-04-14/2025-04-2020251676151319391099513FRFrance
2025-04-21/2025-04-2720251776323343692109513FRFrance
2025-04-28/2025-05-0420251875795271488769414FRFrance
\n", "

1796 rows × 10 columns

\n", "
" ], "text/plain": [ " week indicator inc inc_low inc_up inc100 \\\n", "period \n", "1990-12-03/1990-12-09 199049 7 1143 0 2610 2 \n", "1990-12-10/1990-12-16 199050 7 11079 6660 15498 20 \n", "1990-12-17/1990-12-23 199051 7 19080 13807 24353 34 \n", "1990-12-24/1990-12-30 199052 7 19375 13295 25455 34 \n", "1990-12-31/1991-01-06 199101 7 15565 10271 20859 27 \n", "1991-01-07/1991-01-13 199102 7 16277 11046 21508 29 \n", "1991-01-14/1991-01-20 199103 7 15387 10484 20290 27 \n", "1991-01-21/1991-01-27 199104 7 7913 4563 11263 14 \n", "1991-01-28/1991-02-03 199105 7 10442 6544 14340 18 \n", "1991-02-04/1991-02-10 199106 7 10877 7013 14741 19 \n", "1991-02-11/1991-02-17 199107 7 12337 8077 16597 22 \n", "1991-02-18/1991-02-24 199108 7 13289 8813 17765 23 \n", "1991-02-25/1991-03-03 199109 7 13741 8780 18702 24 \n", "1991-03-04/1991-03-10 199110 7 16643 11372 21914 29 \n", "1991-03-11/1991-03-17 199111 7 15574 11184 19964 27 \n", "1991-03-18/1991-03-24 199112 7 10864 7331 14397 19 \n", "1991-03-25/1991-03-31 199113 7 9567 6041 13093 17 \n", "1991-04-01/1991-04-07 199114 7 12265 7684 16846 22 \n", "1991-04-08/1991-04-14 199115 7 13975 9781 18169 25 \n", "1991-04-15/1991-04-21 199116 7 14857 10068 19646 26 \n", "1991-04-22/1991-04-28 199117 7 13462 8877 18047 24 \n", "1991-04-29/1991-05-05 199118 7 21385 13882 28888 38 \n", "1991-05-06/1991-05-12 199119 7 16739 11246 22232 29 \n", "1991-05-13/1991-05-19 199120 7 19053 12742 25364 34 \n", "1991-05-20/1991-05-26 199121 7 14903 8975 20831 26 \n", "1991-05-27/1991-06-02 199122 7 15452 9953 20951 27 \n", "1991-06-03/1991-06-09 199123 7 11947 7671 16223 21 \n", "1991-06-10/1991-06-16 199124 7 16171 10071 22271 28 \n", "1991-06-17/1991-06-23 199125 7 16169 10700 21638 28 \n", "1991-06-24/1991-06-30 199126 7 17608 11304 23912 31 \n", "... ... ... ... ... ... ... \n", "2024-10-07/2024-10-13 202441 7 2035 381 3689 3 \n", "2024-10-14/2024-10-20 202442 7 2621 1246 3996 4 \n", "2024-10-21/2024-10-27 202443 7 2124 641 3607 3 \n", "2024-10-28/2024-11-03 202444 7 2135 676 3594 3 \n", "2024-11-04/2024-11-10 202445 7 2713 1216 4210 4 \n", "2024-11-11/2024-11-17 202446 7 2260 863 3657 3 \n", "2024-11-18/2024-11-24 202447 7 1931 726 3136 3 \n", "2024-11-25/2024-12-01 202448 7 4189 1454 6924 6 \n", "2024-12-02/2024-12-08 202449 7 6077 3631 8523 9 \n", "2024-12-09/2024-12-15 202450 7 7363 4438 10288 11 \n", "2024-12-16/2024-12-22 202451 7 4670 2239 7101 7 \n", "2024-12-23/2024-12-29 202452 7 4356 1776 6936 7 \n", "2024-12-30/2025-01-05 202501 7 6059 2451 9667 9 \n", "2025-01-06/2025-01-12 202502 7 5966 2757 9175 9 \n", "2025-01-13/2025-01-19 202503 7 2462 1161 3763 4 \n", "2025-01-20/2025-01-26 202504 7 6895 4466 9324 10 \n", "2025-01-27/2025-02-02 202505 7 2087 1056 3118 3 \n", "2025-02-03/2025-02-09 202506 7 3455 1958 4952 5 \n", "2025-02-10/2025-02-16 202507 7 4502 2382 6622 7 \n", "2025-02-17/2025-02-23 202508 7 2835 1286 4384 4 \n", "2025-02-24/2025-03-02 202509 7 3381 1468 5294 5 \n", "2025-03-03/2025-03-09 202510 7 2921 1421 4421 4 \n", "2025-03-10/2025-03-16 202511 7 5878 2747 9009 9 \n", "2025-03-17/2025-03-23 202512 7 3855 1995 5715 6 \n", "2025-03-24/2025-03-30 202513 7 5964 3608 8320 9 \n", "2025-03-31/2025-04-06 202514 7 4984 2858 7110 7 \n", "2025-04-07/2025-04-13 202515 7 5557 3262 7852 8 \n", "2025-04-14/2025-04-20 202516 7 6151 3193 9109 9 \n", "2025-04-21/2025-04-27 202517 7 6323 3436 9210 9 \n", "2025-04-28/2025-05-04 202518 7 5795 2714 8876 9 \n", "\n", " inc100_low inc100_up geo_insee geo_name \n", "period \n", "1990-12-03/1990-12-09 0 5 FR France \n", "1990-12-10/1990-12-16 12 28 FR France \n", "1990-12-17/1990-12-23 25 43 FR France \n", "1990-12-24/1990-12-30 23 45 FR France \n", "1990-12-31/1991-01-06 18 36 FR France \n", "1991-01-07/1991-01-13 20 38 FR France \n", "1991-01-14/1991-01-20 18 36 FR France \n", "1991-01-21/1991-01-27 8 20 FR France \n", "1991-01-28/1991-02-03 11 25 FR France \n", "1991-02-04/1991-02-10 12 26 FR France \n", "1991-02-11/1991-02-17 15 29 FR France \n", "1991-02-18/1991-02-24 15 31 FR France \n", "1991-02-25/1991-03-03 15 33 FR France \n", "1991-03-04/1991-03-10 20 38 FR France \n", "1991-03-11/1991-03-17 19 35 FR France \n", "1991-03-18/1991-03-24 13 25 FR France \n", "1991-03-25/1991-03-31 11 23 FR France \n", "1991-04-01/1991-04-07 14 30 FR France \n", "1991-04-08/1991-04-14 18 32 FR France \n", "1991-04-15/1991-04-21 18 34 FR France \n", "1991-04-22/1991-04-28 16 32 FR France \n", "1991-04-29/1991-05-05 25 51 FR France \n", "1991-05-06/1991-05-12 19 39 FR France \n", "1991-05-13/1991-05-19 23 45 FR France \n", "1991-05-20/1991-05-26 16 36 FR France \n", "1991-05-27/1991-06-02 17 37 FR France \n", "1991-06-03/1991-06-09 13 29 FR France \n", "1991-06-10/1991-06-16 17 39 FR France \n", "1991-06-17/1991-06-23 18 38 FR France \n", "1991-06-24/1991-06-30 20 42 FR France \n", "... ... ... ... ... \n", "2024-10-07/2024-10-13 1 5 FR France \n", "2024-10-14/2024-10-20 2 6 FR France \n", "2024-10-21/2024-10-27 1 5 FR France \n", "2024-10-28/2024-11-03 1 5 FR France \n", "2024-11-04/2024-11-10 2 6 FR France \n", "2024-11-11/2024-11-17 1 5 FR France \n", "2024-11-18/2024-11-24 1 5 FR France \n", "2024-11-25/2024-12-01 2 10 FR France \n", "2024-12-02/2024-12-08 5 13 FR France \n", "2024-12-09/2024-12-15 7 15 FR France \n", "2024-12-16/2024-12-22 3 11 FR France \n", "2024-12-23/2024-12-29 3 11 FR France \n", "2024-12-30/2025-01-05 4 14 FR France \n", "2025-01-06/2025-01-12 4 14 FR France \n", "2025-01-13/2025-01-19 2 6 FR France \n", "2025-01-20/2025-01-26 6 14 FR France \n", "2025-01-27/2025-02-02 1 5 FR France \n", "2025-02-03/2025-02-09 3 7 FR France \n", "2025-02-10/2025-02-16 4 10 FR France \n", "2025-02-17/2025-02-23 2 6 FR France \n", "2025-02-24/2025-03-02 2 8 FR France \n", "2025-03-03/2025-03-09 2 6 FR France \n", "2025-03-10/2025-03-16 4 14 FR France \n", "2025-03-17/2025-03-23 3 9 FR France \n", "2025-03-24/2025-03-30 5 13 FR France \n", "2025-03-31/2025-04-06 4 10 FR France \n", "2025-04-07/2025-04-13 5 11 FR France \n", "2025-04-14/2025-04-20 5 13 FR France \n", "2025-04-21/2025-04-27 5 13 FR France \n", "2025-04-28/2025-05-04 4 14 FR France \n", "\n", "[1796 rows x 10 columns]" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sorted_data" ] }, { "cell_type": "code", "execution_count": 37, "metadata": {}, "outputs": [], "source": [ "first_sept_week = [pd.Period(pd.Timestamp(y, 9, 1), 'W')\n", " for y in range(1991,\n", " 2025)]" ] }, { "cell_type": "code", "execution_count": 38, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[Period('1991-08-26/1991-09-01', 'W-SUN'),\n", " Period('1992-08-31/1992-09-06', 'W-SUN'),\n", " Period('1993-08-30/1993-09-05', 'W-SUN'),\n", " Period('1994-08-29/1994-09-04', 'W-SUN'),\n", " Period('1995-08-28/1995-09-03', 'W-SUN'),\n", " Period('1996-08-26/1996-09-01', 'W-SUN'),\n", " Period('1997-09-01/1997-09-07', 'W-SUN'),\n", " Period('1998-08-31/1998-09-06', 'W-SUN'),\n", " Period('1999-08-30/1999-09-05', 'W-SUN'),\n", " Period('2000-08-28/2000-09-03', 'W-SUN'),\n", " Period('2001-08-27/2001-09-02', 'W-SUN'),\n", " Period('2002-08-26/2002-09-01', 'W-SUN'),\n", " Period('2003-09-01/2003-09-07', 'W-SUN'),\n", " Period('2004-08-30/2004-09-05', 'W-SUN'),\n", " Period('2005-08-29/2005-09-04', 'W-SUN'),\n", " Period('2006-08-28/2006-09-03', 'W-SUN'),\n", " Period('2007-08-27/2007-09-02', 'W-SUN'),\n", " Period('2008-09-01/2008-09-07', 'W-SUN'),\n", " Period('2009-08-31/2009-09-06', 'W-SUN'),\n", " Period('2010-08-30/2010-09-05', 'W-SUN'),\n", " Period('2011-08-29/2011-09-04', 'W-SUN'),\n", " Period('2012-08-27/2012-09-02', 'W-SUN'),\n", " Period('2013-08-26/2013-09-01', 'W-SUN'),\n", " Period('2014-09-01/2014-09-07', 'W-SUN'),\n", " Period('2015-08-31/2015-09-06', 'W-SUN'),\n", " Period('2016-08-29/2016-09-04', 'W-SUN'),\n", " Period('2017-08-28/2017-09-03', 'W-SUN'),\n", " Period('2018-08-27/2018-09-02', 'W-SUN'),\n", " Period('2019-08-26/2019-09-01', 'W-SUN'),\n", " Period('2020-08-31/2020-09-06', 'W-SUN'),\n", " Period('2021-08-30/2021-09-05', 'W-SUN'),\n", " Period('2022-08-29/2022-09-04', 'W-SUN'),\n", " Period('2023-08-28/2023-09-03', 'W-SUN'),\n", " Period('2024-08-26/2024-09-01', 'W-SUN')]" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ "first_sept_week" ] }, { "cell_type": "code", "execution_count": 39, "metadata": {}, "outputs": [], "source": [ "year = []\n", "yearly_incidence = []\n", "for week1, week2 in zip(first_sept_week[:-1],\n", " first_sept_week[1:]):\n", " one_year = sorted_data['inc'][week1:week2-1]\n", " assert abs(len(one_year)-52) < 2\n", " yearly_incidence.append(one_year.sum())\n", " year.append(week2.year)\n", "yearly_incidence = pd.Series(data=yearly_incidence, index=year)" ] }, { "cell_type": "code", "execution_count": 40, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1992 832939\n", "1993 643387\n", "1994 661409\n", "1995 652478\n", "1996 564901\n", "1997 683434\n", "1998 677775\n", "1999 756456\n", "2000 617597\n", "2001 619041\n", "2002 516689\n", "2003 758363\n", "2004 777388\n", "2005 628464\n", "2006 632833\n", "2007 717352\n", "2008 749478\n", "2009 842373\n", "2010 829911\n", "2011 642368\n", "2012 624573\n", "2013 698332\n", "2014 685769\n", "2015 604382\n", "2016 782114\n", "2017 551041\n", "2018 542312\n", "2019 584066\n", "2020 221186\n", "2021 376290\n", "2022 641397\n", "2023 366227\n", "2024 479258\n", "dtype: int64" ] }, "execution_count": 40, "metadata": {}, "output_type": "execute_result" } ], "source": [ "yearly_incidence" ] }, { "cell_type": "code", "execution_count": 41, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 41, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZEAAAD8CAYAAAC2PJlnAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAHGxJREFUeJzt3X+Q1PWd5/HnC4fMqAsGdDD8UHErxAqarIYpYC+5vTXsAl62BGs1mdONUydVbNTNmq2rUoheWadslW5dXXYpK65UXEWNPzhuLbk9OR3xUsvdEWCIZhUNO5NokEic8YYIpopZB973R39GeibQ0/2dnun+Nq9HVVd/5z3fz2c+/WWYd39+fD+tiMDMzCyLSbVugJmZ5ZeTiJmZZeYkYmZmmTmJmJlZZk4iZmaWmZOImZll5iRiZmaZOYmYmVlmTiJmZpZZU60bUG3nnXdezJ07t9bNMDPLlT179rwfEa2Vlmu4JDJ37ly6urpq3Qwzs1yR9PMs5TycZWZmmTmJmJlZZk4iZmaWmZOImZll5iRiZmaZOYmY1ZHew0f56kM76D1ytNZNMSuLk4hZHVm/rZvdb/ez/qXuWjfFrCwNd5+IWR5dctdWBgaPf/z1Ezv388TO/TQ3TWLfuqtq2DKz0twTKeKhBKuV7bdfydWXz6JlcuG/ZMvkSay4fBbb77iyxi0zK81JpIiHEqxWZkxtYUpzEwODx2lumsTA4HGmNDcxY0rLSc/3Gx6rFx7OwkMJVh/e/3CAGxZdxPULL+TJXfvpK5Egit/wrLvmcxPYSrPhFBG1bkNVtbW1RaV7Z/UePsq659/kxb2/5OhHx2mZPIlll36KO7/y2VO+EzSrhZFveIb4DY+NlaQ9EdFWaTkPZ1H5UIJZrXjuxOqNh7OSSoYSzGrFb3is3jiJJA99/UQvbt3Ky2rYErPS/IbH6onnRMzMzHMiZmY28ZxEzMwss7KSiKS/kLRX0uuSnpLUImm6pE5J3el5WtH5ayX1SNonaVlRfIGk19L31ktSijdLeibFd0qaW1SmI/2Mbkkd1XvpZmY2VqMmEUmzgT8H2iLiMuAMoB1YA2yLiHnAtvQ1kuan718KLAe+K+mMVN2DwGpgXnosT/FVwKGI+DTwHeD+VNd04G5gEbAQuLs4WZmZWW2VO5zVBJwpqQk4C3gXWAFsTN/fCKxMxyuApyNiICLeAnqAhZJmAlMjYkcUZvMfG1FmqK7NwJLUS1kGdEZEf0QcAjo5kXjMzKzGRk0iEfEL4D8D+4GDwAcR8SJwfkQcTOccBGakIrOBd4qqOJBis9PxyPiwMhExCHwAnFuiLjMzqwPlDGdNo9BTuBiYBZwt6U9KFTlJLErEs5YpbuNqSV2Suvr6+ko0zczMqqmc4aw/AN6KiL6I+Aj4e+BfAe+lISrSc286/wBwQVH5ORSGvw6k45HxYWXSkNk5QH+JuoaJiA0R0RYRba2trWW8JDMzq4Zyksh+YLGks9I8xRLgTWALMLRaqgN4Lh1vAdrTiquLKUyg70pDXkckLU713DiizFBd1wIvp3mTF4ClkqalHtHSFDOzBuft7vNh1G1PImKnpM3Aj4BB4BVgA/BbwCZJqygkmuvS+XslbQLeSOffGhHHUnU3A48CZwJb0wPgYeBxST0UeiDtqa5+SfcCu9N590RE/5hesZnlgre7zwdve2INp/fwUf7sqVd44PorvDFhDnm7+9rwtidmiT+hMt+83X2+eBdfaxj+hMrG4O3u88U9EWsYfgfbOIa2u3/2li9yw6KL6PtwoNZNslNwT8Qaht/BNg5/vk9+OIlYQ/EHNplNLK/Ostzwqiuz8ePVWVY19XqTl1ddmdUfD2fZb6i3m7y86sqsfnk4yz5Wrzd59R4+yrrn3+TFvb/k6EfHaZk8iWWXfoo7v/LZXA1reTjO6pmHs2zM6nWJbKOsuvJwnDUiD2fZx+r5j3WeV115OM4amZOIDVOvf6zzfN/A9tuvPOVwnFneOYnYMHn+Y12v6rmHZzZWTiJmE6Bee3hmY+XVWWZm5tVZZmY28ZxEzMwsMycRMzPLzEnEbIzqda8xs4ngJGI2Rr4T3U5nXuJrlpHvRDdzT8Qss3rda8xsIjmJmGXkO9HNykgiki6R9GrR47Ckb0maLqlTUnd6nlZUZq2kHkn7JC0rii+Q9Fr63npJSvFmSc+k+E5Jc4vKdKSf0S2po7ov32xshu5Ef/aWL3LDoovo+3Cg1k0ym1AV3bEu6QzgF8Ai4FagPyLuk7QGmBYRd0iaDzwFLARmAS8Bn4mIY5J2AbcBPwSeB9ZHxFZJtwCfj4hvSGoHromIr0maDnQBbUAAe4AFEXHoVG30Hetm1efPQml8E3XH+hLgpxHxc2AFsDHFNwIr0/EK4OmIGIiIt4AeYKGkmcDUiNgRhcz12IgyQ3VtBpakXsoyoDMi+lPi6ASWV/oizWxsvALNTqXS1VntFHoZAOdHxEGAiDgoaUaKz6bQ0xhyIMU+Sscj40Nl3kl1DUr6ADi3OH6SMmY2zrwCzUZTdk9E0ieAq4H/OtqpJ4lFiXjWMsVtWy2pS1JXX1/fKM0zs3J5BZqNppLhrKuAH0XEe+nr99IQFem5N8UPABcUlZsDvJvic04SH1ZGUhNwDtBfoq5hImJDRLRFRFtra2sFL8nMSql0BZrv3j/9VJJE/h0nhrIAtgBDq6U6gOeK4u1pxdXFwDxgVxr6OiJpcZrvuHFEmaG6rgVeTvMmLwBLJU1Lq7+WppiN4P+8Nl4qWYHmuZPTT1mrsySdRWFu4rcj4oMUOxfYBFwI7Aeui4j+9L07gZuAQeBbEbE1xduAR4Ezga3ANyMiJLUAjwNXUOiBtEfEz1KZm4Bvp6b8ZUQ8Uqqtp+vqrLuefY3v79rPDQsvZN01n6t1c+w0M3LuZIjnTvIj6+osfyhVzlX6n9dLNW089B4+esrPkffvWT74Q6lOU5VOfHq4wcaD794/fXkDxpwr9z+vl2raePPnyJ+enEQaQDn/ebfffuUphxvMquGhr58YCVm38rIatsQmkpNIAyjnP6+HG8xsPHhOZJzU45JbbxZoZtXm1VnjxEtuzSxPsq7O8nBWlXkC28xOJx7OqrJKltzW45CXmVklnESqrJIJbN+zYWZ55+GscTDaklsPeZlZo3BPpELlDEE99PU21q28jPmzprJu5WXDluCCt9e2ieHh0vrXCP9GTiIVqsYQlO/ZsIng4dL61wj/Rl7iW6Zq71L6p4930TqlZdiQ18gei1kW3lG3/tXjv5F38U3GK4l4l9LTUx53Pfbvav2rx38j7+I7zjwE1VjKHYvO43CDf1frXyP9G3l1VgW8S2njKE4OJ9tRIO8r6Py7Wv8a5d/Iw1l2Wil3LLoehxvGSx6H7Kz6PJxldaneljCWu7y6kYYbRpPHITurHx7OsszKeQc72rDRRKskOTTKcMOp5H3IzuqDh7Mss1I7FdfjEsYhXl5dcDoN2dnovIuvTZhy3sHW8ycp+hP4Ck6nITsbP54TsYqVM6/gP1D54A8qs7FyT8QqVm6CaPQ5hUZQi16ZV4M1lrJ6IpI+KWmzpJ9IelPS70qaLqlTUnd6nlZ0/lpJPZL2SVpWFF8g6bX0vfWSlOLNkp5J8Z2S5haV6Ug/o1tSR/Veuo1FOe9gR9uI0k5PXg3WWMqaWJe0EdgeEd+T9AngLODbQH9E3CdpDTAtIu6QNB94ClgIzAJeAj4TEcck7QJuA34IPA+sj4itkm4BPh8R35DUDlwTEV+TNB3oAtqAAPYACyLi0Kna6ol1s/pUz4stbBzvE5E0Ffg94GGAiPiXiPgVsALYmE7bCKxMxyuApyNiICLeAnqAhZJmAlMjYkcUMtdjI8oM1bUZWJJ6KcuAzojoT4mjE1he6Ys0s9rzRyA0pnKGs34b6AMekfSKpO9JOhs4PyIOAqTnGen82cA7ReUPpNjsdDwyPqxMRAwCHwDnlqhrGEmrJXVJ6urr6yvjJZnZRPNii8ZUThJpAr4APBgRVwC/BtaUOF8niUWJeNYyJwIRGyKiLSLaWltbSzTNzGrJq8EaTzmrsw4AByJiZ/p6M4Uk8p6kmRFxMA1V9Radf0FR+TnAuyk+5yTx4jIHJDUB5wD9Kf77I8r8oKxXZmZ1p57v0fGqsWxG7YlExC+BdyRdkkJLgDeALcDQaqkO4Ll0vAVoTyuuLgbmAbvSkNcRSYvTfMeNI8oM1XUt8HKaN3kBWCppWlr9tTTFzMyqyqvGsin3PpFvAt9PK7N+Bvx7Cglok6RVwH7gOoCI2CtpE4VEMwjcGhHHUj03A48CZwJb0wMKk/aPS+qh0ANpT3X1S7oX2J3Ouyci+jO+VjOz3+A9xMbGe2eZ2WnNe4gVeCt4M7MMvGpsbLztiZmd9rxFT3YezjIzMw9nNbJ6+3RAM7MhTiI54KWHZlavPCdSx7z00MzqnXsidcwb1plZvXMSqWNeemhWmucLa89JpM55wzqzU/N8Ye15ia+Z5Y4/4Kr6vMTXzE4blc4Xethr/DiJmFnuVDpf6GGv8eMlvmaWS+VsVeJl8uPPcyJm1rC8Q2/5PCdiZjaCl8mPPw9nmVlD8w6948vDWWZm5uEsMzObeE4iVhe8jt8sn5xErC54Hb9ZPnli3WrK6/jN8s09Easpb3dvlm9OIlZTXsdvlm9lJRFJb0t6TdKrkrpSbLqkTknd6Xla0flrJfVI2idpWVF8QaqnR9J6SUrxZknPpPhOSXOLynSkn9EtqaNaL9zqh7e7N8uvsu4TkfQ20BYR7xfF/groj4j7JK0BpkXEHZLmA08BC4FZwEvAZyLimKRdwG3AD4HngfURsVXSLcDnI+IbktqBayLia5KmA11AGxDAHmBBRBw6VVt9n4iZWeVqcZ/ICmBjOt4IrCyKPx0RAxHxFtADLJQ0E5gaETuikLkeG1FmqK7NwJLUS1kGdEZEf0ocncDyMbTZzMyqqNwkEsCLkvZIWp1i50fEQYD0PCPFZwPvFJU9kGKz0/HI+LAyETEIfACcW6KuYSStltQlqauvr6/Ml2RmZmNV7hLfL0bEu5JmAJ2SflLiXJ0kFiXiWcucCERsADZAYTirRNvMzKyKyuqJRMS76bkXeJbCfMd7aYiK9NybTj8AXFBUfA7wborPOUl8WBlJTcA5QH+JuszMrA6MmkQknS1pytAxsBR4HdgCDK2W6gCeS8dbgPa04upiYB6wKw15HZG0OM133DiizFBd1wIvp3mTF4Clkqal1V9LU8zMzOpAOcNZ5wPPptW4TcCTEfE/Je0GNklaBewHrgOIiL2SNgFvAIPArRFxLNV1M/AocCawNT0AHgYel9RDoQfSnurql3QvsDudd09E9I/h9ZqZNaTew0f5s6de4YHrr5jQ+6y8FbyZWQO469nX+P6u/dyw8ELWXfO5istnXeLrvbPMzHKs1vvPedsTM7Mcq/X+c04iZmY5Vuv95zycZWaWc7X8HHlPrJuZmT9j3czMJp6TiJmZZeYkYmZmmTmJmJlZZk4iZmaWmZOImZll5iRiZmaZOYmYmVlmTiJmZpaZk4iZmWXmJGJmZpk5iZiZWWZOImZmlpmTiJmZZeYkYmZmmTmJmJlZZk4iZmaWWdlJRNIZkl6R9A/p6+mSOiV1p+dpReeuldQjaZ+kZUXxBZJeS99bL0kp3izpmRTfKWluUZmO9DO6JXVU40WbmVl1VNITuQ14s+jrNcC2iJgHbEtfI2k+0A5cCiwHvivpjFTmQWA1MC89lqf4KuBQRHwa+A5wf6prOnA3sAhYCNxdnKzMzKy2ykoikuYAXwG+VxReAWxMxxuBlUXxpyNiICLeAnqAhZJmAlMjYkcUPtj9sRFlhuraDCxJvZRlQGdE9EfEIaCTE4nHzMxqrNyeyF8DtwPHi2LnR8RBgPQ8I8VnA+8UnXcgxWan45HxYWUiYhD4ADi3RF1mZlYHRk0ikv4I6I2IPWXWqZPEokQ8a5niNq6W1CWpq6+vr8xmmpnZWJXTE/kicLWkt4GngS9LegJ4Lw1RkZ570/kHgAuKys8B3k3xOSeJDysjqQk4B+gvUdcwEbEhItoioq21tbWMl2RmZtUwahKJiLURMSci5lKYMH85Iv4E2AIMrZbqAJ5Lx1uA9rTi6mIKE+i70pDXEUmL03zHjSPKDNV1bfoZAbwALJU0LU2oL00xMzOrA01jKHsfsEnSKmA/cB1AROyVtAl4AxgEbo2IY6nMzcCjwJnA1vQAeBh4XFIPhR5Ie6qrX9K9wO503j0R0T+GNpuZWRWp8Ia/cbS1tUVXV1etm2FmliuS9kREW6XlfMe6mVmV9R4+ylcf2kHvkaO1bsq4cxIxM6uy9du62f12P+tf6q51U8bdWOZEzMysyCV3bWVg8MTtdE/s3M8TO/fT3DSJfeuuqmHLxo97ImZmVbL99iu5+vJZtEwu/GltmTyJFZfPYvsdV46p3noeHnMSMTOrkhlTW5jS3MTA4HGamyYxMHicKc1NzJjSMqZ663l4zMNZZmZV9P6HA9yw6CKuX3ghT+7aT98Yeg95GB7zEl8zszrVe/go655/kxf3/pKjHx2nZfIkll36Ke78ymfH3LsZyUt8zcwazHgNj1WTh7PMzOpYNYfHxoOHs8zMzMNZZmY28ZxEzMwsMycRMzPLzEnEzMwycxIxM7PMnETMzCwzJxEzM8vMScTMzDJzEjEzs8ycRMzMLDMnETMzy8xJxMzMMnMSMTOzzEZNIpJaJO2S9GNJeyX9pxSfLqlTUnd6nlZUZq2kHkn7JC0rii+Q9Fr63npJSvFmSc+k+E5Jc4vKdKSf0S2po5ov3szMxqacnsgA8OWI+B3gcmC5pMXAGmBbRMwDtqWvkTQfaAcuBZYD35V0RqrrQWA1MC89lqf4KuBQRHwa+A5wf6prOnA3sAhYCNxdnKzMzKy2Rk0iUfBh+nJyegSwAtiY4huBlel4BfB0RAxExFtAD7BQ0kxgakTsiMKHmDw2osxQXZuBJamXsgzojIj+iDgEdHIi8ZiZWY2VNSci6QxJrwK9FP6o7wTOj4iDAOl5Rjp9NvBOUfEDKTY7HY+MDysTEYPAB8C5JeoyM7M6UFYSiYhjEXE5MIdCr+KyEqfrZFWUiGctc+IHSqsldUnq6uvrK9E0MzOrpopWZ0XEr4AfUBhSei8NUZGee9NpB4ALiorNAd5N8TkniQ8rI6kJOAfoL1HXyHZtiIi2iGhrbW2t5CWZmdkYlLM6q1XSJ9PxmcAfAD8BtgBDq6U6gOfS8RagPa24upjCBPquNOR1RNLiNN9x44gyQ3VdC7yc5k1eAJZKmpYm1JemmJmZ1YGmMs6ZCWxMK6wmAZsi4h8k7QA2SVoF7AeuA4iIvZI2AW8Ag8CtEXEs1XUz8ChwJrA1PQAeBh6X1EOhB9Ke6uqXdC+wO513T0T0j+UFm5lZ9ajwhr9xtLW1RVdXV62bYWaWK5L2RERbpeV8x7qZmWXmJGJmZpk5iZiZWWZOImZmlpmTiJmZZeYkYmZmmTmJmJlZZk4iZmaWmZOImZll5iRiZmaZOYmYmVlmTiJmZpaZk4iZmWXmJGJmZpk5iZiZWWZOImZmlpmTiJmZZeYkYmZWgd7DR/nqQzvoPXK01k2pC04iZmYVWL+tm91v97P+pe5aN6UuNNW6AWZmeXDJXVsZGDz+8ddP7NzPEzv309w0iX3rrqphy2rLPREzszJsv/1Krr58Fi2TC382WyZPYsXls9h+x5U1blltOYmYmZVhxtQWpjQ3MTB4nOamSQwMHmdKcxMzprTUumk15eEsM7Myvf/hADcsuojrF17Ik7v20+fJdRQRpU+QLgAeAz4FHAc2RMTfSJoOPAPMBd4GvhoRh1KZtcAq4Bjw5xHxQoovAB4FzgSeB26LiJDUnH7GAuD/AV+LiLdTmQ7grtScdRGxsVR729raoqurq/wrYGZmSNoTEW2VlitnOGsQ+A8R8VlgMXCrpPnAGmBbRMwDtqWvSd9rBy4FlgPflXRGqutBYDUwLz2Wp/gq4FBEfBr4DnB/qms6cDewCFgI3C1pWqUv0szMxseoSSQiDkbEj9LxEeBNYDawAhjqFWwEVqbjFcDTETEQEW8BPcBCSTOBqRGxIwrdn8dGlBmqazOwRJKAZUBnRPSnXk4nJxKPmZnVWEUT65LmAlcAO4HzI+IgFBINMCOdNht4p6jYgRSbnY5HxoeViYhB4APg3BJ1mZlZHSg7iUj6LeC/Ad+KiMOlTj1JLErEs5YpbttqSV2Suvr6+ko0zczMqqmsJCJpMoUE8v2I+PsUfi8NUZGee1P8AHBBUfE5wLspPuck8WFlJDUB5wD9JeoaJiI2RERbRLS1traW85LMzKwKRk0iaW7iYeDNiPgvRd/aAnSk4w7guaJ4u6RmSRdTmEDflYa8jkhanOq8cUSZobquBV5O8yYvAEslTUsT6ktTzMzM6kA5S3y/BGwHXqOwxBfg2xTmRTYBFwL7gesioj+VuRO4icLKrm9FxNYUb+PEEt+twDfTEt8W4HEK8y39QHtE/CyVuSn9PIC/jIhHRmlvH/DzMl9/PTgPeL/WjRiDPLc/z22HfLc/z22Hxmz/RRFR8VDOqEnExpekrixrs+tFntuf57ZDvtuf57aD21/M256YmVlmTiJmZpaZk0jtbah1A8Yoz+3Pc9sh3+3Pc9vB7f+Y50TMzCwz90TMzCwzJ5FxIOnvJPVKer0o9juSdkh6TdJ/lzQ1xT8h6ZEU/7Gk3y8q8wNJ+yS9mh4zTvLjqt32CyT9L0lvStor6bYUny6pU1J3ep5WVGatpJ7U1mVF8QXpdfVIWp/uD8pL2+v+2ks6N53/oaQHRtRV19d+lLbn4dr/oaQ96RrvkfTlorom9NqPQ/sru/4R4UeVH8DvAV8AXi+K7Qb+TTq+Cbg3Hd8KPJKOZwB7gEnp6x8AbRPc9pnAF9LxFOCfgfnAXwFrUnwNcH86ng/8GGgGLgZ+CpyRvrcL+F0K29dsBa7KUdvzcO3PBr4EfAN4YERd9X7tS7U9D9f+CmBWOr4M+EWtrv04tL+i6++eyDiIiH+kcNNksUuAf0zHncAfp+P5FLbSJyJ6gV8BNVt/HhOza3Ndt30821hKpe2PiF9HxP8Ghn0yUh6u/anaXisZ2v9KRAxtwbQXaFFhl44Jv/bVbH+Wn+0kMnFeB65Ox9dxYk+wHwMrJDWpsE3MAobvF/ZI6lL+x4noFhfT+O3aPO7G2PYh9X7tTyUP1340ebr2fwy8EhED1Pjaw5jbP6Ts6+8kMnFuovCBXnsodDf/JcX/jsIvWhfw18D/pbBdDMANEfE54F+nx9cnqrEa312bx1UV2g75uPanrOIksXq79qXk5tpLupTCh+j96VDoJKdN2BLYKrQfKrz+TiITJCJ+EhFLI2IB8BSF8XciYjAi/iIiLo+IFcAnge70vV+k5yPAk0zQUIvGf9fmcVOltufl2p9KHq79KeXl2kuaAzwL3BgRP03hmlz71J5qtL/i6+8kMkGGVjhImkThM+P/Nn19lqSz0/EfAoMR8UYa3jovxScDf0RhSGy82zkRuzbXddtzdO1PKifX/lT15OLaS/ok8D+AtRHxf4ZOrsW1r2b7M13/SlcB+FHWSomngIPARxTemawCbqOwYuKfgfs4caPnXGAfhYmwlyjspAmF1St7gH+iMPH1N6SVQ+Pc9i9R6H7/E/BqevxbCp80uY1CL2kbML2ozJ0Uelb7KFqJQmGBwOvpew8MveZ6b3vOrv3bFBZxfJh+1+bn6Nr/Rtvzcu0pvBH8ddG5rwIzanHtq9n+LNffd6ybmVlmHs4yM7PMnETMzCwzJxEzM8vMScTMzDJzEjEzs8ycRMzMLDMnETMzy8xJxMzMMvv/r4lGV8I8mfkAAAAASUVORK5CYII=\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "yearly_incidence.plot(style='*')" ] }, { "cell_type": "code", "execution_count": 48, "metadata": {}, "outputs": [], "source": [ "minimum = np.min(yearly_incidence)" ] }, { "cell_type": "code", "execution_count": 50, "metadata": {}, "outputs": [], "source": [ "minimum = yearly_incidence[yearly_incidence.eq(minimum)]" ] }, { "cell_type": "code", "execution_count": 51, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "2020 221186\n", "dtype: int64" ] }, "execution_count": 51, "metadata": {}, "output_type": "execute_result" } ], "source": [ "minimum " ] }, { "cell_type": "code", "execution_count": 52, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "2009 842373\n", "dtype: int64" ] }, "execution_count": 52, "metadata": {}, "output_type": "execute_result" } ], "source": [ "maximum = yearly_incidence[yearly_incidence.eq(np.max(yearly_incidence))]\n", "maximum" ] }, { "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 }