{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import isoweek\n", "import requests\n", "import os" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1619869" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data_file_name = \"time_series_covid19_confirmed_global.csv\"\n", "if not(os.path.isfile(data_file_name)):\n", " url = 'https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/' + data_file_name\n", " r = requests.get(url, allow_redirects=True)\n", " open(data_file_name, 'wb').write(r.content)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Nous commençons par télécharger les données pour créer un graphe montrant l’évolution du nombre de cas cumulé au cours du temps pour les pays suivants : la Belgique (Belgium), la Chine - toutes les provinces sauf Hong-Kong (China), Hong Kong (China, Hong-Kong), la France métropolitaine (France), l’Allemagne (Germany), l’Iran (Iran), l’Italie (Italy), le Japon (Japan), la Corée du Sud (Korea, South), la Hollande sans les colonies (Netherlands), le Portugal (Portugal), l’Espagne (Spain), le Royaume-Unis sans les colonies (United Kingdom), les États-Unis (US)." ] }, { "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Province/StateCountry/RegionLatLong1/22/201/23/201/24/201/25/201/26/201/27/20...11/14/2211/15/2211/16/2211/17/2211/18/2211/19/2211/20/2211/21/2211/22/2211/23/22
0NaNAfghanistan33.93911067.709953000000...204610204724204820204982205009205039205146205229205324205391
1NaNAlbania41.15330020.168300000000...333161333197333215333233333233333246333256333257333282333293
2NaNAlgeria28.0339001.659600000000...270952270969270981270996270996271011271023271028271035271041
3NaNAndorra42.5063001.521800000000...46664466644682446824468244682446824468244682446824
4NaNAngola-11.20270017.873900000000...103131103131103131103131103131103131103131103131103131104491
5NaNAntarctica-71.94990023.347000000000...11111111111111111111
6NaNAntigua and Barbuda17.060800-61.796400000000...9106910691069106910691069106910691069106
7NaNArgentina-38.416100-63.616700000000...9721718972171897217189721718972171897217189723924972392497239249723924
8NaNArmenia40.06910045.038200000000...445513445513445513445513445513445513445513445631445631445631
9Australian Capital TerritoryAustralia-35.473500149.012400000000...210609210609210609212092212092212092212092212092212092212092
10New South WalesAustralia-33.868800151.209300000034...3581110358111035811103608974360897436089743608974360897436089743608974
11Northern TerritoryAustralia-12.463400130.845600000000...99128991289912899410994109941099410994109941099410
12QueenslandAustralia-27.469800153.025100000000...1673798167379816737981683096168309616830961683096168309616830961683096
13South AustraliaAustralia-34.928500138.600700000000...791713791713791713800347800347800347800347800347800347800347
14TasmaniaAustralia-42.882100147.327200000000...256075256075256075256075258301258301258301258301258301258301
15VictoriaAustralia-37.813600144.963100000011...2685116268856826918182694518269436726967742699335270314227070032710843
16Western AustraliaAustralia-31.950500115.860500000000...1189668118966811896681198725119872511987251198725119872511987251198725
17NaNAustria47.51620014.550100000000...5493469549714555021865506697551091955147015517893552030055246835530456
18NaNAzerbaijan40.14310047.576900000000...823725823761823805823849823889823923823954823975824033824082
19NaNBahamas25.025885-78.035889000000...37436374363743937439374533745337453374533746137461
20NaNBahrain26.02750050.550000000000...693725694021694223694464694602694740694955695133695279695448
21NaNBangladesh23.68500090.356300000000...2036204203623320362682036306203632520363432036367203639320364162036449
22NaNBarbados13.193900-59.543200000000...103424103545103545103545103545103545103545103545103545103955
23NaNBelarus53.70980027.953400000000...994037994037994037994037994037994037994037994037994037994037
24NaNBelgium50.8333004.469936000000...4624251462425146242514627186462718646271864627186462718646295524629552
25NaNBelize17.189900-88.497600000000...68988689886898868988689886898868988689886901269012
26NaNBenin9.3077002.315800000000...27922279222792227922279222792227922279222792227922
27NaNBhutan27.51420090.433600000000...62460624606246062460624606246062460624886248862488
28NaNBolivia-16.290200-63.588700000000...1109838110988911100141110014111006411100641110190111019011102561110413
29NaNBosnia and Herzegovina43.91590017.679100000000...400261400279400301400322400336400336400336400340400412400430
..................................................................
259NaNTuvalu-7.109500177.649300000000...1259125915321555201920192019238728052828
260NaNUS40.000000-100.000000112255...98054070981134639819774398251350983069709831157398314841983573989839207698503462
261NaNUganda1.37333332.290275000000...169581169663169663169663169663169663169663169663169663169663
262NaNUkraine48.37940031.165600000000...5627788562781956351825635218563527656353345635398563543956354875642284
263NaNUnited Arab Emirates23.42407653.847818000000...1041227104142110418741041874104209910423401042573104277910429661043166
264AnguillaUnited Kingdom18.220600-63.068600000000...3904390439043904390439043904390439043904
265BermudaUnited Kingdom32.307800-64.750500000000...18428184281846318463184631846318463184631846318463
266British Virgin IslandsUnited Kingdom18.420700-64.640000000000...7305730573057305730573057305730573057305
267Cayman IslandsUnited Kingdom19.313300-81.254600000000...31194311943119431194311943119431194311943119431194
268Channel IslandsUnited Kingdom49.372300-2.364400000000...0000000000
269Falkland Islands (Malvinas)United Kingdom-51.796300-59.523600000000...1930193019301930193019301930193019301930
270GibraltarUnited Kingdom36.140800-5.353600000000...20166201662016620166201842018420184201842018420184
271GuernseyUnited Kingdom49.448196-2.589490000000...32562325623266632666326663266632666326663266632766
272Isle of ManUnited Kingdom54.236100-4.548100000000...38008380083800838008380083800838008380083800838008
273JerseyUnited Kingdom49.213800-2.135800000000...62317623176231762317625896258962589625896258962589
274MontserratUnited Kingdom16.742498-62.187366000000...1403140314031403140314031403140314031403
275Pitcairn IslandsUnited Kingdom-24.376800-128.324200000000...4444444444
276Saint Helena, Ascension and Tristan da CunhaUnited Kingdom-7.946700-14.355900000000...2115215921592159215921592159215921592159
277Turks and Caicos IslandsUnited Kingdom21.694000-71.797900000000...6431643164316431643164316431643164466446
278NaNUnited Kingdom55.378100-3.436000000000...23954192239541922395419223977633239776332397763323977633239776332397763323977633
279NaNUruguay-32.522800-55.765800000000...992035992035992035992035992035992035992035992887992887992887
280NaNUzbekistan41.37749164.585262000000...245047245068245116245177245246245246245246245508245569245665
281NaNVanuatu-15.376700166.959200000000...11981119811198111981119811198111981119811198111981
282NaNVenezuela6.423800-66.589700000000...546461546489546534546534546733546733546839546839560800547049
283NaNVietnam14.058324108.277199022222...11508893115094731150997511510484115109191151117811511452115118221151213811512684
284NaNWest Bank and Gaza31.95220035.233200000000...703036703036703036703036703036703036703036703036703036703036
285NaNWinter Olympics 202239.904200116.407400000000...535535535535535535535535535535
286NaNYemen15.55272748.516388000000...11945119451194511945119451194511945119451194511945
287NaNZambia-13.13389727.849332000000...333685333685333685333685333685333685333685333685333721333721
288NaNZimbabwe-19.01543829.154857000000...257893257893257893257893257893257893257893257893257893257893
\n", "

289 rows × 1041 columns

\n", "
" ], "text/plain": [ " Province/State Country/Region \\\n", "0 NaN Afghanistan \n", "1 NaN Albania \n", "2 NaN Algeria \n", "3 NaN Andorra \n", "4 NaN Angola \n", "5 NaN Antarctica \n", "6 NaN Antigua and Barbuda \n", "7 NaN Argentina \n", "8 NaN Armenia \n", "9 Australian Capital Territory Australia \n", "10 New South Wales Australia \n", "11 Northern Territory Australia \n", "12 Queensland Australia \n", "13 South Australia Australia \n", "14 Tasmania Australia \n", "15 Victoria Australia \n", "16 Western Australia Australia \n", "17 NaN Austria \n", "18 NaN Azerbaijan \n", "19 NaN Bahamas \n", "20 NaN Bahrain \n", "21 NaN Bangladesh \n", "22 NaN Barbados \n", "23 NaN Belarus \n", "24 NaN Belgium \n", "25 NaN Belize \n", "26 NaN Benin \n", "27 NaN Bhutan \n", "28 NaN Bolivia \n", "29 NaN Bosnia and Herzegovina \n", ".. ... ... \n", "259 NaN Tuvalu \n", "260 NaN US \n", "261 NaN Uganda \n", "262 NaN Ukraine \n", "263 NaN United Arab Emirates \n", "264 Anguilla United Kingdom \n", "265 Bermuda United Kingdom \n", "266 British Virgin Islands United Kingdom \n", "267 Cayman Islands United Kingdom \n", "268 Channel Islands United Kingdom \n", "269 Falkland Islands (Malvinas) United Kingdom \n", "270 Gibraltar United Kingdom \n", "271 Guernsey United Kingdom \n", "272 Isle of Man United Kingdom \n", "273 Jersey United Kingdom \n", "274 Montserrat United Kingdom \n", "275 Pitcairn Islands United Kingdom \n", "276 Saint Helena, Ascension and Tristan da Cunha United Kingdom \n", "277 Turks and Caicos Islands United Kingdom \n", "278 NaN United Kingdom \n", "279 NaN Uruguay \n", "280 NaN Uzbekistan \n", "281 NaN Vanuatu \n", "282 NaN Venezuela \n", "283 NaN Vietnam \n", "284 NaN West Bank and Gaza \n", "285 NaN Winter Olympics 2022 \n", "286 NaN Yemen \n", "287 NaN Zambia \n", "288 NaN Zimbabwe \n", "\n", " Lat Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 \\\n", "0 33.939110 67.709953 0 0 0 0 0 \n", "1 41.153300 20.168300 0 0 0 0 0 \n", "2 28.033900 1.659600 0 0 0 0 0 \n", "3 42.506300 1.521800 0 0 0 0 0 \n", "4 -11.202700 17.873900 0 0 0 0 0 \n", "5 -71.949900 23.347000 0 0 0 0 0 \n", "6 17.060800 -61.796400 0 0 0 0 0 \n", "7 -38.416100 -63.616700 0 0 0 0 0 \n", "8 40.069100 45.038200 0 0 0 0 0 \n", "9 -35.473500 149.012400 0 0 0 0 0 \n", "10 -33.868800 151.209300 0 0 0 0 3 \n", "11 -12.463400 130.845600 0 0 0 0 0 \n", "12 -27.469800 153.025100 0 0 0 0 0 \n", "13 -34.928500 138.600700 0 0 0 0 0 \n", "14 -42.882100 147.327200 0 0 0 0 0 \n", "15 -37.813600 144.963100 0 0 0 0 1 \n", "16 -31.950500 115.860500 0 0 0 0 0 \n", "17 47.516200 14.550100 0 0 0 0 0 \n", "18 40.143100 47.576900 0 0 0 0 0 \n", "19 25.025885 -78.035889 0 0 0 0 0 \n", "20 26.027500 50.550000 0 0 0 0 0 \n", "21 23.685000 90.356300 0 0 0 0 0 \n", "22 13.193900 -59.543200 0 0 0 0 0 \n", "23 53.709800 27.953400 0 0 0 0 0 \n", "24 50.833300 4.469936 0 0 0 0 0 \n", "25 17.189900 -88.497600 0 0 0 0 0 \n", "26 9.307700 2.315800 0 0 0 0 0 \n", "27 27.514200 90.433600 0 0 0 0 0 \n", "28 -16.290200 -63.588700 0 0 0 0 0 \n", "29 43.915900 17.679100 0 0 0 0 0 \n", ".. ... ... ... ... ... ... ... \n", "259 -7.109500 177.649300 0 0 0 0 0 \n", "260 40.000000 -100.000000 1 1 2 2 5 \n", "261 1.373333 32.290275 0 0 0 0 0 \n", "262 48.379400 31.165600 0 0 0 0 0 \n", "263 23.424076 53.847818 0 0 0 0 0 \n", "264 18.220600 -63.068600 0 0 0 0 0 \n", "265 32.307800 -64.750500 0 0 0 0 0 \n", "266 18.420700 -64.640000 0 0 0 0 0 \n", "267 19.313300 -81.254600 0 0 0 0 0 \n", "268 49.372300 -2.364400 0 0 0 0 0 \n", "269 -51.796300 -59.523600 0 0 0 0 0 \n", "270 36.140800 -5.353600 0 0 0 0 0 \n", "271 49.448196 -2.589490 0 0 0 0 0 \n", "272 54.236100 -4.548100 0 0 0 0 0 \n", "273 49.213800 -2.135800 0 0 0 0 0 \n", "274 16.742498 -62.187366 0 0 0 0 0 \n", "275 -24.376800 -128.324200 0 0 0 0 0 \n", "276 -7.946700 -14.355900 0 0 0 0 0 \n", "277 21.694000 -71.797900 0 0 0 0 0 \n", "278 55.378100 -3.436000 0 0 0 0 0 \n", "279 -32.522800 -55.765800 0 0 0 0 0 \n", "280 41.377491 64.585262 0 0 0 0 0 \n", "281 -15.376700 166.959200 0 0 0 0 0 \n", "282 6.423800 -66.589700 0 0 0 0 0 \n", "283 14.058324 108.277199 0 2 2 2 2 \n", "284 31.952200 35.233200 0 0 0 0 0 \n", "285 39.904200 116.407400 0 0 0 0 0 \n", "286 15.552727 48.516388 0 0 0 0 0 \n", "287 -13.133897 27.849332 0 0 0 0 0 \n", "288 -19.015438 29.154857 0 0 0 0 0 \n", "\n", " 1/27/20 ... 11/14/22 11/15/22 11/16/22 11/17/22 11/18/22 \\\n", "0 0 ... 204610 204724 204820 204982 205009 \n", "1 0 ... 333161 333197 333215 333233 333233 \n", "2 0 ... 270952 270969 270981 270996 270996 \n", "3 0 ... 46664 46664 46824 46824 46824 \n", "4 0 ... 103131 103131 103131 103131 103131 \n", "5 0 ... 11 11 11 11 11 \n", "6 0 ... 9106 9106 9106 9106 9106 \n", "7 0 ... 9721718 9721718 9721718 9721718 9721718 \n", "8 0 ... 445513 445513 445513 445513 445513 \n", "9 0 ... 210609 210609 210609 212092 212092 \n", "10 4 ... 3581110 3581110 3581110 3608974 3608974 \n", "11 0 ... 99128 99128 99128 99410 99410 \n", "12 0 ... 1673798 1673798 1673798 1683096 1683096 \n", "13 0 ... 791713 791713 791713 800347 800347 \n", "14 0 ... 256075 256075 256075 256075 258301 \n", "15 1 ... 2685116 2688568 2691818 2694518 2694367 \n", "16 0 ... 1189668 1189668 1189668 1198725 1198725 \n", "17 0 ... 5493469 5497145 5502186 5506697 5510919 \n", "18 0 ... 823725 823761 823805 823849 823889 \n", "19 0 ... 37436 37436 37439 37439 37453 \n", "20 0 ... 693725 694021 694223 694464 694602 \n", "21 0 ... 2036204 2036233 2036268 2036306 2036325 \n", "22 0 ... 103424 103545 103545 103545 103545 \n", "23 0 ... 994037 994037 994037 994037 994037 \n", "24 0 ... 4624251 4624251 4624251 4627186 4627186 \n", "25 0 ... 68988 68988 68988 68988 68988 \n", "26 0 ... 27922 27922 27922 27922 27922 \n", "27 0 ... 62460 62460 62460 62460 62460 \n", "28 0 ... 1109838 1109889 1110014 1110014 1110064 \n", "29 0 ... 400261 400279 400301 400322 400336 \n", ".. ... ... ... ... ... ... ... \n", "259 0 ... 1259 1259 1532 1555 2019 \n", "260 5 ... 98054070 98113463 98197743 98251350 98306970 \n", "261 0 ... 169581 169663 169663 169663 169663 \n", "262 0 ... 5627788 5627819 5635182 5635218 5635276 \n", "263 0 ... 1041227 1041421 1041874 1041874 1042099 \n", "264 0 ... 3904 3904 3904 3904 3904 \n", "265 0 ... 18428 18428 18463 18463 18463 \n", "266 0 ... 7305 7305 7305 7305 7305 \n", "267 0 ... 31194 31194 31194 31194 31194 \n", "268 0 ... 0 0 0 0 0 \n", "269 0 ... 1930 1930 1930 1930 1930 \n", "270 0 ... 20166 20166 20166 20166 20184 \n", "271 0 ... 32562 32562 32666 32666 32666 \n", "272 0 ... 38008 38008 38008 38008 38008 \n", "273 0 ... 62317 62317 62317 62317 62589 \n", "274 0 ... 1403 1403 1403 1403 1403 \n", "275 0 ... 4 4 4 4 4 \n", "276 0 ... 2115 2159 2159 2159 2159 \n", "277 0 ... 6431 6431 6431 6431 6431 \n", "278 0 ... 23954192 23954192 23954192 23977633 23977633 \n", "279 0 ... 992035 992035 992035 992035 992035 \n", "280 0 ... 245047 245068 245116 245177 245246 \n", "281 0 ... 11981 11981 11981 11981 11981 \n", "282 0 ... 546461 546489 546534 546534 546733 \n", "283 2 ... 11508893 11509473 11509975 11510484 11510919 \n", "284 0 ... 703036 703036 703036 703036 703036 \n", "285 0 ... 535 535 535 535 535 \n", "286 0 ... 11945 11945 11945 11945 11945 \n", "287 0 ... 333685 333685 333685 333685 333685 \n", "288 0 ... 257893 257893 257893 257893 257893 \n", "\n", " 11/19/22 11/20/22 11/21/22 11/22/22 11/23/22 \n", "0 205039 205146 205229 205324 205391 \n", "1 333246 333256 333257 333282 333293 \n", "2 271011 271023 271028 271035 271041 \n", "3 46824 46824 46824 46824 46824 \n", "4 103131 103131 103131 103131 104491 \n", "5 11 11 11 11 11 \n", "6 9106 9106 9106 9106 9106 \n", "7 9721718 9723924 9723924 9723924 9723924 \n", "8 445513 445513 445631 445631 445631 \n", "9 212092 212092 212092 212092 212092 \n", "10 3608974 3608974 3608974 3608974 3608974 \n", "11 99410 99410 99410 99410 99410 \n", "12 1683096 1683096 1683096 1683096 1683096 \n", "13 800347 800347 800347 800347 800347 \n", "14 258301 258301 258301 258301 258301 \n", "15 2696774 2699335 2703142 2707003 2710843 \n", "16 1198725 1198725 1198725 1198725 1198725 \n", "17 5514701 5517893 5520300 5524683 5530456 \n", "18 823923 823954 823975 824033 824082 \n", "19 37453 37453 37453 37461 37461 \n", "20 694740 694955 695133 695279 695448 \n", "21 2036343 2036367 2036393 2036416 2036449 \n", "22 103545 103545 103545 103545 103955 \n", "23 994037 994037 994037 994037 994037 \n", "24 4627186 4627186 4627186 4629552 4629552 \n", "25 68988 68988 68988 69012 69012 \n", "26 27922 27922 27922 27922 27922 \n", "27 62460 62460 62488 62488 62488 \n", "28 1110064 1110190 1110190 1110256 1110413 \n", "29 400336 400336 400340 400412 400430 \n", ".. ... ... ... ... ... \n", "259 2019 2019 2387 2805 2828 \n", "260 98311573 98314841 98357398 98392076 98503462 \n", "261 169663 169663 169663 169663 169663 \n", "262 5635334 5635398 5635439 5635487 5642284 \n", "263 1042340 1042573 1042779 1042966 1043166 \n", "264 3904 3904 3904 3904 3904 \n", "265 18463 18463 18463 18463 18463 \n", "266 7305 7305 7305 7305 7305 \n", "267 31194 31194 31194 31194 31194 \n", "268 0 0 0 0 0 \n", "269 1930 1930 1930 1930 1930 \n", "270 20184 20184 20184 20184 20184 \n", "271 32666 32666 32666 32666 32766 \n", "272 38008 38008 38008 38008 38008 \n", "273 62589 62589 62589 62589 62589 \n", "274 1403 1403 1403 1403 1403 \n", "275 4 4 4 4 4 \n", "276 2159 2159 2159 2159 2159 \n", "277 6431 6431 6431 6446 6446 \n", "278 23977633 23977633 23977633 23977633 23977633 \n", "279 992035 992035 992887 992887 992887 \n", "280 245246 245246 245508 245569 245665 \n", "281 11981 11981 11981 11981 11981 \n", "282 546733 546839 546839 560800 547049 \n", "283 11511178 11511452 11511822 11512138 11512684 \n", "284 703036 703036 703036 703036 703036 \n", "285 535 535 535 535 535 \n", "286 11945 11945 11945 11945 11945 \n", "287 333685 333685 333685 333721 333721 \n", "288 257893 257893 257893 257893 257893 \n", "\n", "[289 rows x 1041 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "raw_data = pd.read_csv(data_file_name)\n", "raw_data" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "def convert_to_week(date):\n", " split_date = date.split('/')\n", " year = int(\"20\" + split_date[2])\n", " week = int()\n", " w = isoweek.Week(year, week)\n", " return pd.Period(w.day(0), 'W')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Désormais on peut trier la liste et sélectionner uniquement les régions et pays qui nous intéressent :" ] }, { "cell_type": "code", "execution_count": 53, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Province/StateCountry/RegionLatLong1/22/201/23/201/24/201/25/201/26/201/27/20...11/14/2211/15/2211/16/2211/17/2211/18/2211/19/2211/20/2211/21/2211/22/2211/23/22
24NaNBelgium50.8333004.469936000000...4624251462425146242514627186462718646271864627186462718646295524629552
59AnhuiChina31.825700117.2264001915396070...1559156415641565156615661566156615681570
60BeijingChina40.182400116.414200142236416880...5945614763196420650465786735700974057922
61ChongqingChina30.057200107.87400069275775110...2512279829703165331334983498373841384138
62FujianChina26.078900117.9874001510183559...5448547955005500556256175652567456745736
63GansuChina35.751800104.2861000224714...1455146814681475148014831483150115151516
64GuangdongChina23.341700113.42440026325378111151...18190187782003421392225072368524707255232640628216
65GuangxiChina23.829800108.7881002523233646...2350235023502350235123572357235723602361
66GuizhouChina26.815400106.874800133457...1001101110111042104810591069108210821102
67HainanChina19.195900109.745300458192233...8984899289928999900390039010901590159025
68HebeiChina39.549000116.13060011281318...2054205520552055205720662068207320732182
69HeilongjiangChina47.862000127.76150002491521...3620365536553666367636973697371437423806
70HenanChina37.895700114.9042005593283128...4995519551955332544058185979605460546169
71Hong KongChina22.300000114.200000022588...1992218199816920048252012877202088520289452036681204396720511062059091
72HubeiChina30.975600112.27070044444454976110581423...68448684546845468460684636847068478684846849368502
73HunanChina27.610400111.70880049244369100...1850185618561858186118691879188318961909
74Inner MongoliaChina44.093500113.9448000017711...6055613862466358647565746666674468686956
75JiangsuChina32.971100119.455000159183347...2832285928592890291329873052310431043226
76JiangxiChina27.614000115.7221002718183672...1506150615061506150615061511151115111512
77JilinChina43.666100126.192300013446...40329403294032940330403304033040330403364033640349
78LiaoningChina41.295600122.608500234172127...2080208420862087208721182133215521552219
79MacauChina22.166700113.550000122256...795795795795795795796796796796
80NingxiaChina37.269200106.165500112347...225225225225225225225226226227
81QinghaiChina35.74520095.995600000116...328330330349354356365368368375
82ShaanxiChina35.191700108.870100035152235...4315437844854560458046164646467247094749
83ShandongChina36.342700118.1498002615274675...3286329932993315332533693369341834183450
84ShanghaiChina31.202000121.44910091620334053...64341643456435364360643736438264393644026442264435
85ShanxiChina37.577700112.2922001116913...1923198919892060212322602380246924692626
86SichuanChina30.617100102.7103005815284469...6825688970147014712674267645788878888363
87TianjinChina39.305400117.323000448101423...2530253925432543254725552560256725702577
..................................................................
130Wallis and FutunaFrance-14.293800-178.116500000000...3415341534153415341534153415341534153415
131NaNFrance46.2276002.213700002333...36145223361935593622734136260475362970773629707736297077363651353642959936478787
135NaNGermany51.16569110.451526000001...36080574361191843615249036180077362054053620540536205405362470813628037136318461
150NaNIran32.42790853.688046000000...7559001755905575590557559164755921175592587559296755936875594167559446
154NaNItaly41.87194012.567380000000...23823192238231922382319223823192240315382403153824031538240315382403153824031538
156NaNJapan36.204824138.252924222244...23241410233412362344893823540544236263182371620523793927238363512395758724090948
162NaNKorea, South35.907757127.766922112234...26290877263574642641290126462319265127542655876526581856266547292672505326784142
196ArubaNetherlands12.521100-69.968300000000...43423434234349443494434944349443494434944349443568
197Bonaire, Sint Eustatius and SabaNetherlands12.178400-68.238500000000...11490114901151611516115161151611516115161151611544
198CuracaoNetherlands12.169600-68.990000000000...45507455074553645536455364553645536455364553645559
199Sint MaartenNetherlands18.042500-63.054800000000...10931109311094310943109431094310943109431094310949
200NaNNetherlands52.1326005.291300000000...8528384853131685313168531316853401385340138534013853401385367188536718
218NaNPortugal39.399900-8.224500000000...5532964553296455329645532964553710855371085537108553710855371085537108
241NaNSpain40.463667-3.749220000000...13551539135515391355153913551539135737211357372113573721135737211357372113573721
260NaNUS40.000000-100.000000112255...98054070981134639819774398251350983069709831157398314841983573989839207698503462
264AnguillaUnited Kingdom18.220600-63.068600000000...3904390439043904390439043904390439043904
265BermudaUnited Kingdom32.307800-64.750500000000...18428184281846318463184631846318463184631846318463
266British Virgin IslandsUnited Kingdom18.420700-64.640000000000...7305730573057305730573057305730573057305
267Cayman IslandsUnited Kingdom19.313300-81.254600000000...31194311943119431194311943119431194311943119431194
268Channel IslandsUnited Kingdom49.372300-2.364400000000...0000000000
269Falkland Islands (Malvinas)United Kingdom-51.796300-59.523600000000...1930193019301930193019301930193019301930
270GibraltarUnited Kingdom36.140800-5.353600000000...20166201662016620166201842018420184201842018420184
271GuernseyUnited Kingdom49.448196-2.589490000000...32562325623266632666326663266632666326663266632766
272Isle of ManUnited Kingdom54.236100-4.548100000000...38008380083800838008380083800838008380083800838008
273JerseyUnited Kingdom49.213800-2.135800000000...62317623176231762317625896258962589625896258962589
274MontserratUnited Kingdom16.742498-62.187366000000...1403140314031403140314031403140314031403
275Pitcairn IslandsUnited Kingdom-24.376800-128.324200000000...4444444444
276Saint Helena, Ascension and Tristan da CunhaUnited Kingdom-7.946700-14.355900000000...2115215921592159215921592159215921592159
277Turks and Caicos IslandsUnited Kingdom21.694000-71.797900000000...6431643164316431643164316431643164466446
278NaNUnited Kingdom55.378100-3.436000000000...23954192239541922395419223977633239776332397763323977633239776332397763323977633
\n", "

75 rows × 1041 columns

\n", "
" ], "text/plain": [ " Province/State Country/Region Lat \\\n", "24 NaN Belgium 50.833300 \n", "59 Anhui China 31.825700 \n", "60 Beijing China 40.182400 \n", "61 Chongqing China 30.057200 \n", "62 Fujian China 26.078900 \n", "63 Gansu China 35.751800 \n", "64 Guangdong China 23.341700 \n", "65 Guangxi China 23.829800 \n", "66 Guizhou China 26.815400 \n", "67 Hainan China 19.195900 \n", "68 Hebei China 39.549000 \n", "69 Heilongjiang China 47.862000 \n", "70 Henan China 37.895700 \n", "71 Hong Kong China 22.300000 \n", "72 Hubei China 30.975600 \n", "73 Hunan China 27.610400 \n", "74 Inner Mongolia China 44.093500 \n", "75 Jiangsu China 32.971100 \n", "76 Jiangxi China 27.614000 \n", "77 Jilin China 43.666100 \n", "78 Liaoning China 41.295600 \n", "79 Macau China 22.166700 \n", "80 Ningxia China 37.269200 \n", "81 Qinghai China 35.745200 \n", "82 Shaanxi China 35.191700 \n", "83 Shandong China 36.342700 \n", "84 Shanghai China 31.202000 \n", "85 Shanxi China 37.577700 \n", "86 Sichuan China 30.617100 \n", "87 Tianjin China 39.305400 \n", ".. ... ... ... \n", "130 Wallis and Futuna France -14.293800 \n", "131 NaN France 46.227600 \n", "135 NaN Germany 51.165691 \n", "150 NaN Iran 32.427908 \n", "154 NaN Italy 41.871940 \n", "156 NaN Japan 36.204824 \n", "162 NaN Korea, South 35.907757 \n", "196 Aruba Netherlands 12.521100 \n", "197 Bonaire, Sint Eustatius and Saba Netherlands 12.178400 \n", "198 Curacao Netherlands 12.169600 \n", "199 Sint Maarten Netherlands 18.042500 \n", "200 NaN Netherlands 52.132600 \n", "218 NaN Portugal 39.399900 \n", "241 NaN Spain 40.463667 \n", "260 NaN US 40.000000 \n", "264 Anguilla United Kingdom 18.220600 \n", "265 Bermuda United Kingdom 32.307800 \n", "266 British Virgin Islands United Kingdom 18.420700 \n", "267 Cayman Islands United Kingdom 19.313300 \n", "268 Channel Islands United Kingdom 49.372300 \n", "269 Falkland Islands (Malvinas) United Kingdom -51.796300 \n", "270 Gibraltar United Kingdom 36.140800 \n", "271 Guernsey United Kingdom 49.448196 \n", "272 Isle of Man United Kingdom 54.236100 \n", "273 Jersey United Kingdom 49.213800 \n", "274 Montserrat United Kingdom 16.742498 \n", "275 Pitcairn Islands United Kingdom -24.376800 \n", "276 Saint Helena, Ascension and Tristan da Cunha United Kingdom -7.946700 \n", "277 Turks and Caicos Islands United Kingdom 21.694000 \n", "278 NaN United Kingdom 55.378100 \n", "\n", " Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 \\\n", "24 4.469936 0 0 0 0 0 0 \n", "59 117.226400 1 9 15 39 60 70 \n", "60 116.414200 14 22 36 41 68 80 \n", "61 107.874000 6 9 27 57 75 110 \n", "62 117.987400 1 5 10 18 35 59 \n", "63 104.286100 0 2 2 4 7 14 \n", "64 113.424400 26 32 53 78 111 151 \n", "65 108.788100 2 5 23 23 36 46 \n", "66 106.874800 1 3 3 4 5 7 \n", "67 109.745300 4 5 8 19 22 33 \n", "68 116.130600 1 1 2 8 13 18 \n", "69 127.761500 0 2 4 9 15 21 \n", "70 114.904200 5 5 9 32 83 128 \n", "71 114.200000 0 2 2 5 8 8 \n", "72 112.270700 444 444 549 761 1058 1423 \n", "73 111.708800 4 9 24 43 69 100 \n", "74 113.944800 0 0 1 7 7 11 \n", "75 119.455000 1 5 9 18 33 47 \n", "76 115.722100 2 7 18 18 36 72 \n", "77 126.192300 0 1 3 4 4 6 \n", "78 122.608500 2 3 4 17 21 27 \n", "79 113.550000 1 2 2 2 5 6 \n", "80 106.165500 1 1 2 3 4 7 \n", "81 95.995600 0 0 0 1 1 6 \n", "82 108.870100 0 3 5 15 22 35 \n", "83 118.149800 2 6 15 27 46 75 \n", "84 121.449100 9 16 20 33 40 53 \n", "85 112.292200 1 1 1 6 9 13 \n", "86 102.710300 5 8 15 28 44 69 \n", "87 117.323000 4 4 8 10 14 23 \n", ".. ... ... ... ... ... ... ... \n", "130 -178.116500 0 0 0 0 0 0 \n", "131 2.213700 0 0 2 3 3 3 \n", "135 10.451526 0 0 0 0 0 1 \n", "150 53.688046 0 0 0 0 0 0 \n", "154 12.567380 0 0 0 0 0 0 \n", "156 138.252924 2 2 2 2 4 4 \n", "162 127.766922 1 1 2 2 3 4 \n", "196 -69.968300 0 0 0 0 0 0 \n", "197 -68.238500 0 0 0 0 0 0 \n", "198 -68.990000 0 0 0 0 0 0 \n", "199 -63.054800 0 0 0 0 0 0 \n", "200 5.291300 0 0 0 0 0 0 \n", "218 -8.224500 0 0 0 0 0 0 \n", "241 -3.749220 0 0 0 0 0 0 \n", "260 -100.000000 1 1 2 2 5 5 \n", "264 -63.068600 0 0 0 0 0 0 \n", "265 -64.750500 0 0 0 0 0 0 \n", "266 -64.640000 0 0 0 0 0 0 \n", "267 -81.254600 0 0 0 0 0 0 \n", "268 -2.364400 0 0 0 0 0 0 \n", "269 -59.523600 0 0 0 0 0 0 \n", "270 -5.353600 0 0 0 0 0 0 \n", "271 -2.589490 0 0 0 0 0 0 \n", "272 -4.548100 0 0 0 0 0 0 \n", "273 -2.135800 0 0 0 0 0 0 \n", "274 -62.187366 0 0 0 0 0 0 \n", "275 -128.324200 0 0 0 0 0 0 \n", "276 -14.355900 0 0 0 0 0 0 \n", "277 -71.797900 0 0 0 0 0 0 \n", "278 -3.436000 0 0 0 0 0 0 \n", "\n", " ... 11/14/22 11/15/22 11/16/22 11/17/22 11/18/22 11/19/22 \\\n", "24 ... 4624251 4624251 4624251 4627186 4627186 4627186 \n", "59 ... 1559 1564 1564 1565 1566 1566 \n", "60 ... 5945 6147 6319 6420 6504 6578 \n", "61 ... 2512 2798 2970 3165 3313 3498 \n", "62 ... 5448 5479 5500 5500 5562 5617 \n", "63 ... 1455 1468 1468 1475 1480 1483 \n", "64 ... 18190 18778 20034 21392 22507 23685 \n", "65 ... 2350 2350 2350 2350 2351 2357 \n", "66 ... 1001 1011 1011 1042 1048 1059 \n", "67 ... 8984 8992 8992 8999 9003 9003 \n", "68 ... 2054 2055 2055 2055 2057 2066 \n", "69 ... 3620 3655 3655 3666 3676 3697 \n", "70 ... 4995 5195 5195 5332 5440 5818 \n", "71 ... 1992218 1998169 2004825 2012877 2020885 2028945 \n", "72 ... 68448 68454 68454 68460 68463 68470 \n", "73 ... 1850 1856 1856 1858 1861 1869 \n", "74 ... 6055 6138 6246 6358 6475 6574 \n", "75 ... 2832 2859 2859 2890 2913 2987 \n", "76 ... 1506 1506 1506 1506 1506 1506 \n", "77 ... 40329 40329 40329 40330 40330 40330 \n", "78 ... 2080 2084 2086 2087 2087 2118 \n", "79 ... 795 795 795 795 795 795 \n", "80 ... 225 225 225 225 225 225 \n", "81 ... 328 330 330 349 354 356 \n", "82 ... 4315 4378 4485 4560 4580 4616 \n", "83 ... 3286 3299 3299 3315 3325 3369 \n", "84 ... 64341 64345 64353 64360 64373 64382 \n", "85 ... 1923 1989 1989 2060 2123 2260 \n", "86 ... 6825 6889 7014 7014 7126 7426 \n", "87 ... 2530 2539 2543 2543 2547 2555 \n", ".. ... ... ... ... ... ... ... \n", "130 ... 3415 3415 3415 3415 3415 3415 \n", "131 ... 36145223 36193559 36227341 36260475 36297077 36297077 \n", "135 ... 36080574 36119184 36152490 36180077 36205405 36205405 \n", "150 ... 7559001 7559055 7559055 7559164 7559211 7559258 \n", "154 ... 23823192 23823192 23823192 23823192 24031538 24031538 \n", "156 ... 23241410 23341236 23448938 23540544 23626318 23716205 \n", "162 ... 26290877 26357464 26412901 26462319 26512754 26558765 \n", "196 ... 43423 43423 43494 43494 43494 43494 \n", "197 ... 11490 11490 11516 11516 11516 11516 \n", "198 ... 45507 45507 45536 45536 45536 45536 \n", "199 ... 10931 10931 10943 10943 10943 10943 \n", "200 ... 8528384 8531316 8531316 8531316 8534013 8534013 \n", "218 ... 5532964 5532964 5532964 5532964 5537108 5537108 \n", "241 ... 13551539 13551539 13551539 13551539 13573721 13573721 \n", "260 ... 98054070 98113463 98197743 98251350 98306970 98311573 \n", "264 ... 3904 3904 3904 3904 3904 3904 \n", "265 ... 18428 18428 18463 18463 18463 18463 \n", "266 ... 7305 7305 7305 7305 7305 7305 \n", "267 ... 31194 31194 31194 31194 31194 31194 \n", "268 ... 0 0 0 0 0 0 \n", "269 ... 1930 1930 1930 1930 1930 1930 \n", "270 ... 20166 20166 20166 20166 20184 20184 \n", "271 ... 32562 32562 32666 32666 32666 32666 \n", "272 ... 38008 38008 38008 38008 38008 38008 \n", "273 ... 62317 62317 62317 62317 62589 62589 \n", "274 ... 1403 1403 1403 1403 1403 1403 \n", "275 ... 4 4 4 4 4 4 \n", "276 ... 2115 2159 2159 2159 2159 2159 \n", "277 ... 6431 6431 6431 6431 6431 6431 \n", "278 ... 23954192 23954192 23954192 23977633 23977633 23977633 \n", "\n", " 11/20/22 11/21/22 11/22/22 11/23/22 \n", "24 4627186 4627186 4629552 4629552 \n", "59 1566 1566 1568 1570 \n", "60 6735 7009 7405 7922 \n", "61 3498 3738 4138 4138 \n", "62 5652 5674 5674 5736 \n", "63 1483 1501 1515 1516 \n", "64 24707 25523 26406 28216 \n", "65 2357 2357 2360 2361 \n", "66 1069 1082 1082 1102 \n", "67 9010 9015 9015 9025 \n", "68 2068 2073 2073 2182 \n", "69 3697 3714 3742 3806 \n", "70 5979 6054 6054 6169 \n", "71 2036681 2043967 2051106 2059091 \n", "72 68478 68484 68493 68502 \n", "73 1879 1883 1896 1909 \n", "74 6666 6744 6868 6956 \n", "75 3052 3104 3104 3226 \n", "76 1511 1511 1511 1512 \n", "77 40330 40336 40336 40349 \n", "78 2133 2155 2155 2219 \n", "79 796 796 796 796 \n", "80 225 226 226 227 \n", "81 365 368 368 375 \n", "82 4646 4672 4709 4749 \n", "83 3369 3418 3418 3450 \n", "84 64393 64402 64422 64435 \n", "85 2380 2469 2469 2626 \n", "86 7645 7888 7888 8363 \n", "87 2560 2567 2570 2577 \n", ".. ... ... ... ... \n", "130 3415 3415 3415 3415 \n", "131 36297077 36365135 36429599 36478787 \n", "135 36205405 36247081 36280371 36318461 \n", "150 7559296 7559368 7559416 7559446 \n", "154 24031538 24031538 24031538 24031538 \n", "156 23793927 23836351 23957587 24090948 \n", "162 26581856 26654729 26725053 26784142 \n", "196 43494 43494 43494 43568 \n", "197 11516 11516 11516 11544 \n", "198 45536 45536 45536 45559 \n", "199 10943 10943 10943 10949 \n", "200 8534013 8534013 8536718 8536718 \n", "218 5537108 5537108 5537108 5537108 \n", "241 13573721 13573721 13573721 13573721 \n", "260 98314841 98357398 98392076 98503462 \n", "264 3904 3904 3904 3904 \n", "265 18463 18463 18463 18463 \n", "266 7305 7305 7305 7305 \n", "267 31194 31194 31194 31194 \n", "268 0 0 0 0 \n", "269 1930 1930 1930 1930 \n", "270 20184 20184 20184 20184 \n", "271 32666 32666 32666 32766 \n", "272 38008 38008 38008 38008 \n", "273 62589 62589 62589 62589 \n", "274 1403 1403 1403 1403 \n", "275 4 4 4 4 \n", "276 2159 2159 2159 2159 \n", "277 6431 6431 6446 6446 \n", "278 23977633 23977633 23977633 23977633 \n", "\n", "[75 rows x 1041 columns]" ] }, "execution_count": 53, "metadata": {}, "output_type": "execute_result" } ], "source": [ "wanted_regions_names = [\"Belgium\", \"China\", \"France\", \"Germany\", \"Iran\", \"Italy\", \"Japan\", \"Korea, South\", \"Netherlands\", \"Portugal\", \"Spain\", \"United Kingdom\", \"US\"]\n", "regions_tab = pd.DataFrame(df.loc[[(countries in wanted_regions_names) for countries in df['Country/Region']]])\n", "regions_tab" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "On supprime maintenant les lignes inutiles (où on a 0 cas de virus au total) :" ] }, { "cell_type": "code", "execution_count": 57, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Province/StateCountry/RegionLatLong1/22/201/23/201/24/201/25/201/26/201/27/20...11/14/2211/15/2211/16/2211/17/2211/18/2211/19/2211/20/2211/21/2211/22/2211/23/22
24NaNBelgium50.8333004.469936000000...4624251462425146242514627186462718646271864627186462718646295524629552
59AnhuiChina31.825700117.2264001915396070...1559156415641565156615661566156615681570
60BeijingChina40.182400116.414200142236416880...5945614763196420650465786735700974057922
61ChongqingChina30.057200107.87400069275775110...2512279829703165331334983498373841384138
62FujianChina26.078900117.9874001510183559...5448547955005500556256175652567456745736
63GansuChina35.751800104.2861000224714...1455146814681475148014831483150115151516
64GuangdongChina23.341700113.42440026325378111151...18190187782003421392225072368524707255232640628216
65GuangxiChina23.829800108.7881002523233646...2350235023502350235123572357235723602361
66GuizhouChina26.815400106.874800133457...1001101110111042104810591069108210821102
67HainanChina19.195900109.745300458192233...8984899289928999900390039010901590159025
68HebeiChina39.549000116.13060011281318...2054205520552055205720662068207320732182
69HeilongjiangChina47.862000127.76150002491521...3620365536553666367636973697371437423806
70HenanChina37.895700114.9042005593283128...4995519551955332544058185979605460546169
71Hong KongChina22.300000114.200000022588...1992218199816920048252012877202088520289452036681204396720511062059091
72HubeiChina30.975600112.27070044444454976110581423...68448684546845468460684636847068478684846849368502
73HunanChina27.610400111.70880049244369100...1850185618561858186118691879188318961909
74Inner MongoliaChina44.093500113.9448000017711...6055613862466358647565746666674468686956
75JiangsuChina32.971100119.455000159183347...2832285928592890291329873052310431043226
76JiangxiChina27.614000115.7221002718183672...1506150615061506150615061511151115111512
77JilinChina43.666100126.192300013446...40329403294032940330403304033040330403364033640349
78LiaoningChina41.295600122.608500234172127...2080208420862087208721182133215521552219
79MacauChina22.166700113.550000122256...795795795795795795796796796796
80NingxiaChina37.269200106.165500112347...225225225225225225225226226227
81QinghaiChina35.74520095.995600000116...328330330349354356365368368375
82ShaanxiChina35.191700108.870100035152235...4315437844854560458046164646467247094749
83ShandongChina36.342700118.1498002615274675...3286329932993315332533693369341834183450
84ShanghaiChina31.202000121.44910091620334053...64341643456435364360643736438264393644026442264435
85ShanxiChina37.577700112.2922001116913...1923198919892060212322602380246924692626
86SichuanChina30.617100102.7103005815284469...6825688970147014712674267645788878888363
87TianjinChina39.305400117.323000448101423...2530253925432543254725552560256725702577
..................................................................
129St MartinFrance18.070800-63.050100000000...12026120341203412034120341203412034120341203412034
130Wallis and FutunaFrance-14.293800-178.116500000000...3415341534153415341534153415341534153415
131NaNFrance46.2276002.213700002333...36145223361935593622734136260475362970773629707736297077363651353642959936478787
135NaNGermany51.16569110.451526000001...36080574361191843615249036180077362054053620540536205405362470813628037136318461
150NaNIran32.42790853.688046000000...7559001755905575590557559164755921175592587559296755936875594167559446
154NaNItaly41.87194012.567380000000...23823192238231922382319223823192240315382403153824031538240315382403153824031538
156NaNJapan36.204824138.252924222244...23241410233412362344893823540544236263182371620523793927238363512395758724090948
162NaNKorea, South35.907757127.766922112234...26290877263574642641290126462319265127542655876526581856266547292672505326784142
196ArubaNetherlands12.521100-69.968300000000...43423434234349443494434944349443494434944349443568
197Bonaire, Sint Eustatius and SabaNetherlands12.178400-68.238500000000...11490114901151611516115161151611516115161151611544
198CuracaoNetherlands12.169600-68.990000000000...45507455074553645536455364553645536455364553645559
199Sint MaartenNetherlands18.042500-63.054800000000...10931109311094310943109431094310943109431094310949
200NaNNetherlands52.1326005.291300000000...8528384853131685313168531316853401385340138534013853401385367188536718
218NaNPortugal39.399900-8.224500000000...5532964553296455329645532964553710855371085537108553710855371085537108
241NaNSpain40.463667-3.749220000000...13551539135515391355153913551539135737211357372113573721135737211357372113573721
260NaNUS40.000000-100.000000112255...98054070981134639819774398251350983069709831157398314841983573989839207698503462
264AnguillaUnited Kingdom18.220600-63.068600000000...3904390439043904390439043904390439043904
265BermudaUnited Kingdom32.307800-64.750500000000...18428184281846318463184631846318463184631846318463
266British Virgin IslandsUnited Kingdom18.420700-64.640000000000...7305730573057305730573057305730573057305
267Cayman IslandsUnited Kingdom19.313300-81.254600000000...31194311943119431194311943119431194311943119431194
269Falkland Islands (Malvinas)United Kingdom-51.796300-59.523600000000...1930193019301930193019301930193019301930
270GibraltarUnited Kingdom36.140800-5.353600000000...20166201662016620166201842018420184201842018420184
271GuernseyUnited Kingdom49.448196-2.589490000000...32562325623266632666326663266632666326663266632766
272Isle of ManUnited Kingdom54.236100-4.548100000000...38008380083800838008380083800838008380083800838008
273JerseyUnited Kingdom49.213800-2.135800000000...62317623176231762317625896258962589625896258962589
274MontserratUnited Kingdom16.742498-62.187366000000...1403140314031403140314031403140314031403
275Pitcairn IslandsUnited Kingdom-24.376800-128.324200000000...4444444444
276Saint Helena, Ascension and Tristan da CunhaUnited Kingdom-7.946700-14.355900000000...2115215921592159215921592159215921592159
277Turks and Caicos IslandsUnited Kingdom21.694000-71.797900000000...6431643164316431643164316431643164466446
278NaNUnited Kingdom55.378100-3.436000000000...23954192239541922395419223977633239776332397763323977633239776332397763323977633
\n", "

74 rows × 1041 columns

\n", "
" ], "text/plain": [ " Province/State Country/Region Lat \\\n", "24 NaN Belgium 50.833300 \n", "59 Anhui China 31.825700 \n", "60 Beijing China 40.182400 \n", "61 Chongqing China 30.057200 \n", "62 Fujian China 26.078900 \n", "63 Gansu China 35.751800 \n", "64 Guangdong China 23.341700 \n", "65 Guangxi China 23.829800 \n", "66 Guizhou China 26.815400 \n", "67 Hainan China 19.195900 \n", "68 Hebei China 39.549000 \n", "69 Heilongjiang China 47.862000 \n", "70 Henan China 37.895700 \n", "71 Hong Kong China 22.300000 \n", "72 Hubei China 30.975600 \n", "73 Hunan China 27.610400 \n", "74 Inner Mongolia China 44.093500 \n", "75 Jiangsu China 32.971100 \n", "76 Jiangxi China 27.614000 \n", "77 Jilin China 43.666100 \n", "78 Liaoning China 41.295600 \n", "79 Macau China 22.166700 \n", "80 Ningxia China 37.269200 \n", "81 Qinghai China 35.745200 \n", "82 Shaanxi China 35.191700 \n", "83 Shandong China 36.342700 \n", "84 Shanghai China 31.202000 \n", "85 Shanxi China 37.577700 \n", "86 Sichuan China 30.617100 \n", "87 Tianjin China 39.305400 \n", ".. ... ... ... \n", "129 St Martin France 18.070800 \n", "130 Wallis and Futuna France -14.293800 \n", "131 NaN France 46.227600 \n", "135 NaN Germany 51.165691 \n", "150 NaN Iran 32.427908 \n", "154 NaN Italy 41.871940 \n", "156 NaN Japan 36.204824 \n", "162 NaN Korea, South 35.907757 \n", "196 Aruba Netherlands 12.521100 \n", "197 Bonaire, Sint Eustatius and Saba Netherlands 12.178400 \n", "198 Curacao Netherlands 12.169600 \n", "199 Sint Maarten Netherlands 18.042500 \n", "200 NaN Netherlands 52.132600 \n", "218 NaN Portugal 39.399900 \n", "241 NaN Spain 40.463667 \n", "260 NaN US 40.000000 \n", "264 Anguilla United Kingdom 18.220600 \n", "265 Bermuda United Kingdom 32.307800 \n", "266 British Virgin Islands United Kingdom 18.420700 \n", "267 Cayman Islands United Kingdom 19.313300 \n", "269 Falkland Islands (Malvinas) United Kingdom -51.796300 \n", "270 Gibraltar United Kingdom 36.140800 \n", "271 Guernsey United Kingdom 49.448196 \n", "272 Isle of Man United Kingdom 54.236100 \n", "273 Jersey United Kingdom 49.213800 \n", "274 Montserrat United Kingdom 16.742498 \n", "275 Pitcairn Islands United Kingdom -24.376800 \n", "276 Saint Helena, Ascension and Tristan da Cunha United Kingdom -7.946700 \n", "277 Turks and Caicos Islands United Kingdom 21.694000 \n", "278 NaN United Kingdom 55.378100 \n", "\n", " Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 \\\n", "24 4.469936 0 0 0 0 0 0 \n", "59 117.226400 1 9 15 39 60 70 \n", "60 116.414200 14 22 36 41 68 80 \n", "61 107.874000 6 9 27 57 75 110 \n", "62 117.987400 1 5 10 18 35 59 \n", "63 104.286100 0 2 2 4 7 14 \n", "64 113.424400 26 32 53 78 111 151 \n", "65 108.788100 2 5 23 23 36 46 \n", "66 106.874800 1 3 3 4 5 7 \n", "67 109.745300 4 5 8 19 22 33 \n", "68 116.130600 1 1 2 8 13 18 \n", "69 127.761500 0 2 4 9 15 21 \n", "70 114.904200 5 5 9 32 83 128 \n", "71 114.200000 0 2 2 5 8 8 \n", "72 112.270700 444 444 549 761 1058 1423 \n", "73 111.708800 4 9 24 43 69 100 \n", "74 113.944800 0 0 1 7 7 11 \n", "75 119.455000 1 5 9 18 33 47 \n", "76 115.722100 2 7 18 18 36 72 \n", "77 126.192300 0 1 3 4 4 6 \n", "78 122.608500 2 3 4 17 21 27 \n", "79 113.550000 1 2 2 2 5 6 \n", "80 106.165500 1 1 2 3 4 7 \n", "81 95.995600 0 0 0 1 1 6 \n", "82 108.870100 0 3 5 15 22 35 \n", "83 118.149800 2 6 15 27 46 75 \n", "84 121.449100 9 16 20 33 40 53 \n", "85 112.292200 1 1 1 6 9 13 \n", "86 102.710300 5 8 15 28 44 69 \n", "87 117.323000 4 4 8 10 14 23 \n", ".. ... ... ... ... ... ... ... \n", "129 -63.050100 0 0 0 0 0 0 \n", "130 -178.116500 0 0 0 0 0 0 \n", "131 2.213700 0 0 2 3 3 3 \n", "135 10.451526 0 0 0 0 0 1 \n", "150 53.688046 0 0 0 0 0 0 \n", "154 12.567380 0 0 0 0 0 0 \n", "156 138.252924 2 2 2 2 4 4 \n", "162 127.766922 1 1 2 2 3 4 \n", "196 -69.968300 0 0 0 0 0 0 \n", "197 -68.238500 0 0 0 0 0 0 \n", "198 -68.990000 0 0 0 0 0 0 \n", "199 -63.054800 0 0 0 0 0 0 \n", "200 5.291300 0 0 0 0 0 0 \n", "218 -8.224500 0 0 0 0 0 0 \n", "241 -3.749220 0 0 0 0 0 0 \n", "260 -100.000000 1 1 2 2 5 5 \n", "264 -63.068600 0 0 0 0 0 0 \n", "265 -64.750500 0 0 0 0 0 0 \n", "266 -64.640000 0 0 0 0 0 0 \n", "267 -81.254600 0 0 0 0 0 0 \n", "269 -59.523600 0 0 0 0 0 0 \n", "270 -5.353600 0 0 0 0 0 0 \n", "271 -2.589490 0 0 0 0 0 0 \n", "272 -4.548100 0 0 0 0 0 0 \n", "273 -2.135800 0 0 0 0 0 0 \n", "274 -62.187366 0 0 0 0 0 0 \n", "275 -128.324200 0 0 0 0 0 0 \n", "276 -14.355900 0 0 0 0 0 0 \n", "277 -71.797900 0 0 0 0 0 0 \n", "278 -3.436000 0 0 0 0 0 0 \n", "\n", " ... 11/14/22 11/15/22 11/16/22 11/17/22 11/18/22 11/19/22 \\\n", "24 ... 4624251 4624251 4624251 4627186 4627186 4627186 \n", "59 ... 1559 1564 1564 1565 1566 1566 \n", "60 ... 5945 6147 6319 6420 6504 6578 \n", "61 ... 2512 2798 2970 3165 3313 3498 \n", "62 ... 5448 5479 5500 5500 5562 5617 \n", "63 ... 1455 1468 1468 1475 1480 1483 \n", "64 ... 18190 18778 20034 21392 22507 23685 \n", "65 ... 2350 2350 2350 2350 2351 2357 \n", "66 ... 1001 1011 1011 1042 1048 1059 \n", "67 ... 8984 8992 8992 8999 9003 9003 \n", "68 ... 2054 2055 2055 2055 2057 2066 \n", "69 ... 3620 3655 3655 3666 3676 3697 \n", "70 ... 4995 5195 5195 5332 5440 5818 \n", "71 ... 1992218 1998169 2004825 2012877 2020885 2028945 \n", "72 ... 68448 68454 68454 68460 68463 68470 \n", "73 ... 1850 1856 1856 1858 1861 1869 \n", "74 ... 6055 6138 6246 6358 6475 6574 \n", "75 ... 2832 2859 2859 2890 2913 2987 \n", "76 ... 1506 1506 1506 1506 1506 1506 \n", "77 ... 40329 40329 40329 40330 40330 40330 \n", "78 ... 2080 2084 2086 2087 2087 2118 \n", "79 ... 795 795 795 795 795 795 \n", "80 ... 225 225 225 225 225 225 \n", "81 ... 328 330 330 349 354 356 \n", "82 ... 4315 4378 4485 4560 4580 4616 \n", "83 ... 3286 3299 3299 3315 3325 3369 \n", "84 ... 64341 64345 64353 64360 64373 64382 \n", "85 ... 1923 1989 1989 2060 2123 2260 \n", "86 ... 6825 6889 7014 7014 7126 7426 \n", "87 ... 2530 2539 2543 2543 2547 2555 \n", ".. ... ... ... ... ... ... ... \n", "129 ... 12026 12034 12034 12034 12034 12034 \n", "130 ... 3415 3415 3415 3415 3415 3415 \n", "131 ... 36145223 36193559 36227341 36260475 36297077 36297077 \n", "135 ... 36080574 36119184 36152490 36180077 36205405 36205405 \n", "150 ... 7559001 7559055 7559055 7559164 7559211 7559258 \n", "154 ... 23823192 23823192 23823192 23823192 24031538 24031538 \n", "156 ... 23241410 23341236 23448938 23540544 23626318 23716205 \n", "162 ... 26290877 26357464 26412901 26462319 26512754 26558765 \n", "196 ... 43423 43423 43494 43494 43494 43494 \n", "197 ... 11490 11490 11516 11516 11516 11516 \n", "198 ... 45507 45507 45536 45536 45536 45536 \n", "199 ... 10931 10931 10943 10943 10943 10943 \n", "200 ... 8528384 8531316 8531316 8531316 8534013 8534013 \n", "218 ... 5532964 5532964 5532964 5532964 5537108 5537108 \n", "241 ... 13551539 13551539 13551539 13551539 13573721 13573721 \n", "260 ... 98054070 98113463 98197743 98251350 98306970 98311573 \n", "264 ... 3904 3904 3904 3904 3904 3904 \n", "265 ... 18428 18428 18463 18463 18463 18463 \n", "266 ... 7305 7305 7305 7305 7305 7305 \n", "267 ... 31194 31194 31194 31194 31194 31194 \n", "269 ... 1930 1930 1930 1930 1930 1930 \n", "270 ... 20166 20166 20166 20166 20184 20184 \n", "271 ... 32562 32562 32666 32666 32666 32666 \n", "272 ... 38008 38008 38008 38008 38008 38008 \n", "273 ... 62317 62317 62317 62317 62589 62589 \n", "274 ... 1403 1403 1403 1403 1403 1403 \n", "275 ... 4 4 4 4 4 4 \n", "276 ... 2115 2159 2159 2159 2159 2159 \n", "277 ... 6431 6431 6431 6431 6431 6431 \n", "278 ... 23954192 23954192 23954192 23977633 23977633 23977633 \n", "\n", " 11/20/22 11/21/22 11/22/22 11/23/22 \n", "24 4627186 4627186 4629552 4629552 \n", "59 1566 1566 1568 1570 \n", "60 6735 7009 7405 7922 \n", "61 3498 3738 4138 4138 \n", "62 5652 5674 5674 5736 \n", "63 1483 1501 1515 1516 \n", "64 24707 25523 26406 28216 \n", "65 2357 2357 2360 2361 \n", "66 1069 1082 1082 1102 \n", "67 9010 9015 9015 9025 \n", "68 2068 2073 2073 2182 \n", "69 3697 3714 3742 3806 \n", "70 5979 6054 6054 6169 \n", "71 2036681 2043967 2051106 2059091 \n", "72 68478 68484 68493 68502 \n", "73 1879 1883 1896 1909 \n", "74 6666 6744 6868 6956 \n", "75 3052 3104 3104 3226 \n", "76 1511 1511 1511 1512 \n", "77 40330 40336 40336 40349 \n", "78 2133 2155 2155 2219 \n", "79 796 796 796 796 \n", "80 225 226 226 227 \n", "81 365 368 368 375 \n", "82 4646 4672 4709 4749 \n", "83 3369 3418 3418 3450 \n", "84 64393 64402 64422 64435 \n", "85 2380 2469 2469 2626 \n", "86 7645 7888 7888 8363 \n", "87 2560 2567 2570 2577 \n", ".. ... ... ... ... \n", "129 12034 12034 12034 12034 \n", "130 3415 3415 3415 3415 \n", "131 36297077 36365135 36429599 36478787 \n", "135 36205405 36247081 36280371 36318461 \n", "150 7559296 7559368 7559416 7559446 \n", "154 24031538 24031538 24031538 24031538 \n", "156 23793927 23836351 23957587 24090948 \n", "162 26581856 26654729 26725053 26784142 \n", "196 43494 43494 43494 43568 \n", "197 11516 11516 11516 11544 \n", "198 45536 45536 45536 45559 \n", "199 10943 10943 10943 10949 \n", "200 8534013 8534013 8536718 8536718 \n", "218 5537108 5537108 5537108 5537108 \n", "241 13573721 13573721 13573721 13573721 \n", "260 98314841 98357398 98392076 98503462 \n", "264 3904 3904 3904 3904 \n", "265 18463 18463 18463 18463 \n", "266 7305 7305 7305 7305 \n", "267 31194 31194 31194 31194 \n", "269 1930 1930 1930 1930 \n", "270 20184 20184 20184 20184 \n", "271 32666 32666 32666 32766 \n", "272 38008 38008 38008 38008 \n", "273 62589 62589 62589 62589 \n", "274 1403 1403 1403 1403 \n", "275 4 4 4 4 \n", "276 2159 2159 2159 2159 \n", "277 6431 6431 6446 6446 \n", "278 23977633 23977633 23977633 23977633 \n", "\n", "[74 rows x 1041 columns]" ] }, "execution_count": 57, "metadata": {}, "output_type": "execute_result" } ], "source": [ "regions_tab = pd.DataFrame(regions_tab.loc[regions_tab.iloc[:,-1] != 0])\n", "regions_tab" ] }, { "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 }