{ "cells": [ { "cell_type": "code", "execution_count": 1, "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
02022467294111004782417FRFrance
12022457389517626028639FRFrance
22022447427122316311639FRFrance
320224375863330284249513FRFrance
42022427377019505590639FRFrance
52022417417722196135639FRFrance
620224074883147282947212FRFrance
7202239720413313751306FRFrance
8202238717714193123315FRFrance
9202237717254992951315FRFrance
10202236710691781960213FRFrance
11202235715814002762204FRFrance
12202234722667883744315FRFrance
132022337734001739911026FRFrance
142022327780140861151612618FRFrance
15202231768964170962210614FRFrance
162022307903957701230814919FRFrance
172022297148511006019642221529FRFrance
182022287154711102819914231630FRFrance
192022277211911619826184322440FRFrance
202022267168541280620902251931FRFrance
212022257222461801126481342840FRFrance
222022247224581810526811342741FRFrance
232022237187721487522669282234FRFrance
242022227189161494122891292335FRFrance
252022217203101630724313312537FRFrance
262022207235851900428166362943FRFrance
272022197185931418123005282135FRFrance
282022187178511396321739272133FRFrance
292022177203141600124627312438FRFrance
.................................
16381991267176081130423912312042FRFrance
16391991257161691070021638281838FRFrance
16401991247161711007122271281739FRFrance
1641199123711947767116223211329FRFrance
1642199122715452995320951271737FRFrance
1643199121714903897520831261636FRFrance
16441991207190531274225364342345FRFrance
16451991197167391124622232291939FRFrance
16461991187213851388228888382551FRFrance
1647199117713462887718047241632FRFrance
16481991167148571006819646261834FRFrance
1649199115713975978118169251832FRFrance
1650199114712265768416846221430FRFrance
165119911379567604113093171123FRFrance
1652199112710864733114397191325FRFrance
16531991117155741118419964271935FRFrance
16541991107166431137221914292038FRFrance
1655199109713741878018702241533FRFrance
1656199108713289881317765231531FRFrance
1657199107712337807716597221529FRFrance
1658199106710877701314741191226FRFrance
1659199105710442654414340181125FRFrance
16601991047791345631126314820FRFrance
16611991037153871048420290271836FRFrance
16621991027162771104621508292038FRFrance
16631991017155651027120859271836FRFrance
16641990527193751329525455342345FRFrance
16651990517190801380724353342543FRFrance
1666199050711079666015498201228FRFrance
16671990497114302610205FRFrance
\n", "

1668 rows × 10 columns

\n", "
" ], "text/plain": [ " week indicator inc inc_low inc_up inc100 inc100_low \\\n", "0 202246 7 2941 1100 4782 4 1 \n", "1 202245 7 3895 1762 6028 6 3 \n", "2 202244 7 4271 2231 6311 6 3 \n", "3 202243 7 5863 3302 8424 9 5 \n", "4 202242 7 3770 1950 5590 6 3 \n", "5 202241 7 4177 2219 6135 6 3 \n", "6 202240 7 4883 1472 8294 7 2 \n", "7 202239 7 2041 331 3751 3 0 \n", "8 202238 7 1771 419 3123 3 1 \n", "9 202237 7 1725 499 2951 3 1 \n", "10 202236 7 1069 178 1960 2 1 \n", "11 202235 7 1581 400 2762 2 0 \n", "12 202234 7 2266 788 3744 3 1 \n", "13 202233 7 7340 0 17399 11 0 \n", "14 202232 7 7801 4086 11516 12 6 \n", "15 202231 7 6896 4170 9622 10 6 \n", "16 202230 7 9039 5770 12308 14 9 \n", "17 202229 7 14851 10060 19642 22 15 \n", "18 202228 7 15471 11028 19914 23 16 \n", "19 202227 7 21191 16198 26184 32 24 \n", "20 202226 7 16854 12806 20902 25 19 \n", "21 202225 7 22246 18011 26481 34 28 \n", "22 202224 7 22458 18105 26811 34 27 \n", "23 202223 7 18772 14875 22669 28 22 \n", "24 202222 7 18916 14941 22891 29 23 \n", "25 202221 7 20310 16307 24313 31 25 \n", "26 202220 7 23585 19004 28166 36 29 \n", "27 202219 7 18593 14181 23005 28 21 \n", "28 202218 7 17851 13963 21739 27 21 \n", "29 202217 7 20314 16001 24627 31 24 \n", "... ... ... ... ... ... ... ... \n", "1638 199126 7 17608 11304 23912 31 20 \n", "1639 199125 7 16169 10700 21638 28 18 \n", "1640 199124 7 16171 10071 22271 28 17 \n", "1641 199123 7 11947 7671 16223 21 13 \n", "1642 199122 7 15452 9953 20951 27 17 \n", "1643 199121 7 14903 8975 20831 26 16 \n", "1644 199120 7 19053 12742 25364 34 23 \n", "1645 199119 7 16739 11246 22232 29 19 \n", "1646 199118 7 21385 13882 28888 38 25 \n", "1647 199117 7 13462 8877 18047 24 16 \n", "1648 199116 7 14857 10068 19646 26 18 \n", "1649 199115 7 13975 9781 18169 25 18 \n", "1650 199114 7 12265 7684 16846 22 14 \n", "1651 199113 7 9567 6041 13093 17 11 \n", "1652 199112 7 10864 7331 14397 19 13 \n", "1653 199111 7 15574 11184 19964 27 19 \n", "1654 199110 7 16643 11372 21914 29 20 \n", "1655 199109 7 13741 8780 18702 24 15 \n", "1656 199108 7 13289 8813 17765 23 15 \n", "1657 199107 7 12337 8077 16597 22 15 \n", "1658 199106 7 10877 7013 14741 19 12 \n", "1659 199105 7 10442 6544 14340 18 11 \n", "1660 199104 7 7913 4563 11263 14 8 \n", "1661 199103 7 15387 10484 20290 27 18 \n", "1662 199102 7 16277 11046 21508 29 20 \n", "1663 199101 7 15565 10271 20859 27 18 \n", "1664 199052 7 19375 13295 25455 34 23 \n", "1665 199051 7 19080 13807 24353 34 25 \n", "1666 199050 7 11079 6660 15498 20 12 \n", "1667 199049 7 1143 0 2610 2 0 \n", "\n", " inc100_up geo_insee geo_name \n", "0 7 FR France \n", "1 9 FR France \n", "2 9 FR France \n", "3 13 FR France \n", "4 9 FR France \n", "5 9 FR France \n", "6 12 FR France \n", "7 6 FR France \n", "8 5 FR France \n", "9 5 FR France \n", "10 3 FR France \n", "11 4 FR France \n", "12 5 FR France \n", "13 26 FR France \n", "14 18 FR France \n", "15 14 FR France \n", "16 19 FR France \n", "17 29 FR France \n", "18 30 FR France \n", "19 40 FR France \n", "20 31 FR France \n", "21 40 FR France \n", "22 41 FR France \n", "23 34 FR France \n", "24 35 FR France \n", "25 37 FR France \n", "26 43 FR France \n", "27 35 FR France \n", "28 33 FR France \n", "29 38 FR France \n", "... ... ... ... \n", "1638 42 FR France \n", "1639 38 FR France \n", "1640 39 FR France \n", "1641 29 FR France \n", "1642 37 FR France \n", "1643 36 FR France \n", "1644 45 FR France \n", "1645 39 FR France \n", "1646 51 FR France \n", "1647 32 FR France \n", "1648 34 FR France \n", "1649 32 FR France \n", "1650 30 FR France \n", "1651 23 FR France \n", "1652 25 FR France \n", "1653 35 FR France \n", "1654 38 FR France \n", "1655 33 FR France \n", "1656 31 FR France \n", "1657 29 FR France \n", "1658 26 FR France \n", "1659 25 FR France \n", "1660 20 FR France \n", "1661 36 FR France \n", "1662 38 FR France \n", "1663 36 FR France \n", "1664 45 FR France \n", "1665 43 FR France \n", "1666 28 FR France \n", "1667 5 FR France \n", "\n", "[1668 rows x 10 columns]" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%matplotlib inline\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import isoweek\n", "import requests\n", "import os\n", "\n", "data_file_name = \"incidence-PAY-7.csv\"\n", "if not(os.path.isfile(data_file_name)):\n", " url = 'https://www.sentiweb.fr/datasets/' + data_file_name\n", " r = requests.get(url, allow_redirects=True)\n", "\n", " open(data_file_name, 'wb').write(r.content)\n", " \n", "raw_data = pd.read_csv(data_file_name, skiprows=1)\n", "raw_data" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "raw_data = raw_data.values.tolist()" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{2022: 535430,\n", " 2021: 429793,\n", " 2020: 229985,\n", " 2019: 540874,\n", " 2018: 561400,\n", " 2017: 556580,\n", " 2016: 730003,\n", " 2015: 649742,\n", " 2014: 648607,\n", " 2013: 658318,\n", " 2012: 676971,\n", " 2011: 642034,\n", " 2010: 766478,\n", " 2009: 875937,\n", " 2008: 738993,\n", " 2007: 778119,\n", " 2006: 557905,\n", " 2005: 654446,\n", " 2004: 850765,\n", " 2003: 678928,\n", " 2002: 589547,\n", " 2001: 563415,\n", " 2000: 646617,\n", " 1999: 646022,\n", " 1998: 785055,\n", " 1997: 624302,\n", " 1996: 632212,\n", " 1995: 654598,\n", " 1994: 660418,\n", " 1993: 593435,\n", " 1992: 843500,\n", " 1991: 656000,\n", " 1990: 50677}" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "year = int(str(raw_data[0][0])[:4])\n", "year_inc = {year: 0}\n", "\n", "for i in range(0, len(raw_data)):\n", " if year != int(str(raw_data[i][0])[:4]):\n", " year = int(str(raw_data[i][0])[:4])\n", " year_inc[year] = 0\n", " year_inc[year] += raw_data[i][2]\n", " \n", "year_inc" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "def dico_min(dico):\n", " min_year = list(dico.keys())[0]\n", " for year in dico:\n", " if dico[year] <= dico[min_year]:\n", " min_year = year\n", " return min_year" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "def dico_max(dico):\n", " max_year = list(dico.keys())[0]\n", " for year in dico:\n", " if dico[year] >= dico[max_year]:\n", " max_year = year\n", " return max_year" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1990" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dico_min(year_inc)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "2009" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dico_max(year_inc)" ] }, { "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 }