{ "cells": [ { "cell_type": "markdown", "metadata": { "hideCode": false, "hidePrompt": false }, "source": [ "# Exercice sur l'épidemiologie du SARS-COV2" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "hideCode": false, "hidePrompt": false }, "outputs": [], "source": [ "%matplotlib inline\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import isoweek\n", "import numpy as np" ] }, { "cell_type": "markdown", "metadata": { "hideCode": false, "hidePrompt": false }, "source": [ "extraction basique" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "hideCode": false, "hideOutput": true, "hidePrompt": false }, "outputs": [], "source": [ "x = pd.read_csv(\"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv\")\n" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "hideCode": false, "hidePrompt": false }, "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...5/31/206/1/206/2/206/3/206/4/206/5/206/6/206/7/206/8/206/9/20
0NaNAfghanistan33.00000065.000000000000...15205157501650917267180541896919551203422091721459
1NaNAlbania41.15330020.168300000000...1137114311641184119712121232124612631299
2NaNAlgeria28.0339001.659600000000...93949513962697339831993510050101541026510382
3NaNAndorra42.5063001.521800000000...764765844851852852852852852852
4NaNAngola-11.20270017.873900000000...86868686868688919296
5NaNAntigua and Barbuda17.060800-61.796400000000...26262626262626262626
6NaNArgentina-38.416100-63.616700000000...16851174151831919268201972103722020227942362024761
7NaNArmenia40.06910045.038200000000...928294921000910524112211181712364131301332513675
8Australian Capital TerritoryAustralia-35.473500149.012400000000...107107107107107107108108108108
9New South WalesAustralia-33.868800151.209300000034...3098310431043106311031103109311231143117
10Northern TerritoryAustralia-12.463400130.845600000000...29292929292929292929
11QueenslandAustralia-28.016700153.400000000000...1058105910591060106010611061106210621062
12South AustraliaAustralia-34.928500138.600700000000...440440440440440440440440440440
13TasmaniaAustralia-41.454500145.970700000000...228228228228228228228228228228
14VictoriaAustralia-37.813600144.963100000011...1653166316701678168116811685168716871691
15Western AustraliaAustralia-31.950500115.860500000000...589591592592592596599599599599
16NaNAustria47.51620014.550100000000...16731167331675916771168051684316898169021696816979
17NaNAzerbaijan40.14310047.576900000000...5494566259356260652268607239755378768191
18NaNBahamas25.034300-77.396300000000...102102102102102102103103103103
19NaNBahrain26.02750050.550000000000...11398118711231112815132961383514383147631541715731
20NaNBangladesh23.68500090.356300000000...47153495345244555140575636039163026657696850471675
21NaNBarbados13.193900-59.543200000000...92929292929292929292
22NaNBelarus53.70980027.953400000000...42556434034425545116459814686847751486304945350265
23NaNBelgium50.8333004.000000000000...58381585175861558685587675890759072592265934859437
24NaNBenin9.3077002.315800000000...232243244244261261261261288305
25NaNBhutan27.51420090.433600000000...43434747474848595959
26NaNBolivia-16.290200-63.588700000000...9982105311099111638122451272813358136431394914644
27NaNBosnia and Herzegovina43.91590017.679100000000...2510252425352551259426062606260627042728
28NaNBrazil-14.235000-51.925300000000...514849526447555383584016614941645771672846691758707412739503
29NaNBrunei4.535300114.727700000000...141141141141141141141141141141
..................................................................
236NaNTimor-Leste-8.874217125.727539000000...24242424242424242424
237NaNBelize13.193900-59.543200000000...18181818181919191920
238NaNLaos19.856270102.495496000000...19191919191919191919
239NaNLibya26.33510017.228331000000...156168182196209239256256332359
240NaNWest Bank and Gaza31.95220035.233200000000...448449451457464464464472473481
241NaNGuinea-Bissau11.803700-15.180400000000...1256133913391339133913681368136813891389
242NaNMali17.570692-3.996166000000...1265131513511386146114851523153315471586
243NaNSaint Kitts and Nevis17.357822-62.782998000000...15151515151515151515
244Northwest TerritoriesCanada64.825500-124.845700000000...5555555555
245YukonCanada64.282300-135.000000000000...11111111111111111111
246NaNKosovo42.60263620.902977000000...1064106410641142114211421142114212631263
247NaNBurma21.91620095.956000000000...224228232233236236240242244246
248AnguillaUnited Kingdom18.220600-63.068600000000...3333333333
249British Virgin IslandsUnited Kingdom18.420700-64.640000000000...8888888888
250Turks and Caicos IslandsUnited Kingdom21.694000-71.797900000000...12121212121212121212
251NaNMS Zaandam0.0000000.000000000000...9999999999
252NaNBotswana-22.32850024.684900000000...35384040404040404242
253NaNBurundi-3.37310029.918900000000...63636363636383838383
254NaNSierra Leone8.460555-11.779889000000...86186589690991492994696910011025
255Bonaire, Sint Eustatius and SabaNetherlands12.178400-68.238500000000...6777777777
256NaNMalawi-13.25430834.301525000000...284336358369393409409438443455
257Falkland Islands (Malvinas)United Kingdom-51.796300-59.523600000000...13131313131313131313
258Saint Pierre and MiquelonFrance46.885200-56.315900000000...1111111111
259NaNSouth Sudan6.87700031.307000000000...994994994994994994994131716041604
260NaNWestern Sahara24.215500-12.885800000000...9999999999
261NaNSao Tome and Principe0.1863606.613081000000...483484484484485499499513513514
262NaNYemen15.55272748.516388000000...323354399419453469482484496524
263NaNComoros-11.64550043.333300000000...106106132132132132141141141141
264NaNTajikistan38.86103471.276093000000...3930401341004191428943704453452946094690
265NaNLesotho-29.60998828.233608000000...2224444444
\n", "

266 rows × 144 columns

\n", "
" ], "text/plain": [ " Province/State Country/Region Lat \\\n", "0 NaN Afghanistan 33.000000 \n", "1 NaN Albania 41.153300 \n", "2 NaN Algeria 28.033900 \n", "3 NaN Andorra 42.506300 \n", "4 NaN Angola -11.202700 \n", "5 NaN Antigua and Barbuda 17.060800 \n", "6 NaN Argentina -38.416100 \n", "7 NaN Armenia 40.069100 \n", "8 Australian Capital Territory Australia -35.473500 \n", "9 New South Wales Australia -33.868800 \n", "10 Northern Territory Australia -12.463400 \n", "11 Queensland Australia -28.016700 \n", "12 South Australia Australia -34.928500 \n", "13 Tasmania Australia -41.454500 \n", "14 Victoria Australia -37.813600 \n", "15 Western Australia Australia -31.950500 \n", "16 NaN Austria 47.516200 \n", "17 NaN Azerbaijan 40.143100 \n", "18 NaN Bahamas 25.034300 \n", "19 NaN Bahrain 26.027500 \n", "20 NaN Bangladesh 23.685000 \n", "21 NaN Barbados 13.193900 \n", "22 NaN Belarus 53.709800 \n", "23 NaN Belgium 50.833300 \n", "24 NaN Benin 9.307700 \n", "25 NaN Bhutan 27.514200 \n", "26 NaN Bolivia -16.290200 \n", "27 NaN Bosnia and Herzegovina 43.915900 \n", "28 NaN Brazil -14.235000 \n", "29 NaN Brunei 4.535300 \n", ".. ... ... ... \n", "236 NaN Timor-Leste -8.874217 \n", "237 NaN Belize 13.193900 \n", "238 NaN Laos 19.856270 \n", "239 NaN Libya 26.335100 \n", "240 NaN West Bank and Gaza 31.952200 \n", "241 NaN Guinea-Bissau 11.803700 \n", "242 NaN Mali 17.570692 \n", "243 NaN Saint Kitts and Nevis 17.357822 \n", "244 Northwest Territories Canada 64.825500 \n", "245 Yukon Canada 64.282300 \n", "246 NaN Kosovo 42.602636 \n", "247 NaN Burma 21.916200 \n", "248 Anguilla United Kingdom 18.220600 \n", "249 British Virgin Islands United Kingdom 18.420700 \n", "250 Turks and Caicos Islands United Kingdom 21.694000 \n", "251 NaN MS Zaandam 0.000000 \n", "252 NaN Botswana -22.328500 \n", "253 NaN Burundi -3.373100 \n", "254 NaN Sierra Leone 8.460555 \n", "255 Bonaire, Sint Eustatius and Saba Netherlands 12.178400 \n", "256 NaN Malawi -13.254308 \n", "257 Falkland Islands (Malvinas) United Kingdom -51.796300 \n", "258 Saint Pierre and Miquelon France 46.885200 \n", "259 NaN South Sudan 6.877000 \n", "260 NaN Western Sahara 24.215500 \n", "261 NaN Sao Tome and Principe 0.186360 \n", "262 NaN Yemen 15.552727 \n", "263 NaN Comoros -11.645500 \n", "264 NaN Tajikistan 38.861034 \n", "265 NaN Lesotho -29.609988 \n", "\n", " Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 ... \\\n", "0 65.000000 0 0 0 0 0 0 ... \n", "1 20.168300 0 0 0 0 0 0 ... \n", "2 1.659600 0 0 0 0 0 0 ... \n", "3 1.521800 0 0 0 0 0 0 ... \n", "4 17.873900 0 0 0 0 0 0 ... \n", "5 -61.796400 0 0 0 0 0 0 ... \n", "6 -63.616700 0 0 0 0 0 0 ... \n", "7 45.038200 0 0 0 0 0 0 ... \n", "8 149.012400 0 0 0 0 0 0 ... \n", "9 151.209300 0 0 0 0 3 4 ... \n", "10 130.845600 0 0 0 0 0 0 ... \n", "11 153.400000 0 0 0 0 0 0 ... \n", "12 138.600700 0 0 0 0 0 0 ... \n", "13 145.970700 0 0 0 0 0 0 ... \n", "14 144.963100 0 0 0 0 1 1 ... \n", "15 115.860500 0 0 0 0 0 0 ... \n", "16 14.550100 0 0 0 0 0 0 ... \n", "17 47.576900 0 0 0 0 0 0 ... \n", "18 -77.396300 0 0 0 0 0 0 ... \n", "19 50.550000 0 0 0 0 0 0 ... \n", "20 90.356300 0 0 0 0 0 0 ... \n", "21 -59.543200 0 0 0 0 0 0 ... \n", "22 27.953400 0 0 0 0 0 0 ... \n", "23 4.000000 0 0 0 0 0 0 ... \n", "24 2.315800 0 0 0 0 0 0 ... \n", "25 90.433600 0 0 0 0 0 0 ... \n", "26 -63.588700 0 0 0 0 0 0 ... \n", "27 17.679100 0 0 0 0 0 0 ... \n", "28 -51.925300 0 0 0 0 0 0 ... \n", "29 114.727700 0 0 0 0 0 0 ... \n", ".. ... ... ... ... ... ... ... ... \n", "236 125.727539 0 0 0 0 0 0 ... \n", "237 -59.543200 0 0 0 0 0 0 ... \n", "238 102.495496 0 0 0 0 0 0 ... \n", "239 17.228331 0 0 0 0 0 0 ... \n", "240 35.233200 0 0 0 0 0 0 ... \n", "241 -15.180400 0 0 0 0 0 0 ... \n", "242 -3.996166 0 0 0 0 0 0 ... \n", "243 -62.782998 0 0 0 0 0 0 ... \n", "244 -124.845700 0 0 0 0 0 0 ... \n", "245 -135.000000 0 0 0 0 0 0 ... \n", "246 20.902977 0 0 0 0 0 0 ... \n", "247 95.956000 0 0 0 0 0 0 ... \n", "248 -63.068600 0 0 0 0 0 0 ... \n", "249 -64.640000 0 0 0 0 0 0 ... \n", "250 -71.797900 0 0 0 0 0 0 ... \n", "251 0.000000 0 0 0 0 0 0 ... \n", "252 24.684900 0 0 0 0 0 0 ... \n", "253 29.918900 0 0 0 0 0 0 ... \n", "254 -11.779889 0 0 0 0 0 0 ... \n", "255 -68.238500 0 0 0 0 0 0 ... \n", "256 34.301525 0 0 0 0 0 0 ... \n", "257 -59.523600 0 0 0 0 0 0 ... \n", "258 -56.315900 0 0 0 0 0 0 ... \n", "259 31.307000 0 0 0 0 0 0 ... \n", "260 -12.885800 0 0 0 0 0 0 ... \n", "261 6.613081 0 0 0 0 0 0 ... \n", "262 48.516388 0 0 0 0 0 0 ... \n", "263 43.333300 0 0 0 0 0 0 ... \n", "264 71.276093 0 0 0 0 0 0 ... \n", "265 28.233608 0 0 0 0 0 0 ... \n", "\n", " 5/31/20 6/1/20 6/2/20 6/3/20 6/4/20 6/5/20 6/6/20 6/7/20 6/8/20 \\\n", "0 15205 15750 16509 17267 18054 18969 19551 20342 20917 \n", "1 1137 1143 1164 1184 1197 1212 1232 1246 1263 \n", "2 9394 9513 9626 9733 9831 9935 10050 10154 10265 \n", "3 764 765 844 851 852 852 852 852 852 \n", "4 86 86 86 86 86 86 88 91 92 \n", "5 26 26 26 26 26 26 26 26 26 \n", "6 16851 17415 18319 19268 20197 21037 22020 22794 23620 \n", "7 9282 9492 10009 10524 11221 11817 12364 13130 13325 \n", "8 107 107 107 107 107 107 108 108 108 \n", "9 3098 3104 3104 3106 3110 3110 3109 3112 3114 \n", "10 29 29 29 29 29 29 29 29 29 \n", "11 1058 1059 1059 1060 1060 1061 1061 1062 1062 \n", "12 440 440 440 440 440 440 440 440 440 \n", "13 228 228 228 228 228 228 228 228 228 \n", "14 1653 1663 1670 1678 1681 1681 1685 1687 1687 \n", "15 589 591 592 592 592 596 599 599 599 \n", "16 16731 16733 16759 16771 16805 16843 16898 16902 16968 \n", "17 5494 5662 5935 6260 6522 6860 7239 7553 7876 \n", "18 102 102 102 102 102 102 103 103 103 \n", "19 11398 11871 12311 12815 13296 13835 14383 14763 15417 \n", "20 47153 49534 52445 55140 57563 60391 63026 65769 68504 \n", "21 92 92 92 92 92 92 92 92 92 \n", "22 42556 43403 44255 45116 45981 46868 47751 48630 49453 \n", "23 58381 58517 58615 58685 58767 58907 59072 59226 59348 \n", "24 232 243 244 244 261 261 261 261 288 \n", "25 43 43 47 47 47 48 48 59 59 \n", "26 9982 10531 10991 11638 12245 12728 13358 13643 13949 \n", "27 2510 2524 2535 2551 2594 2606 2606 2606 2704 \n", "28 514849 526447 555383 584016 614941 645771 672846 691758 707412 \n", "29 141 141 141 141 141 141 141 141 141 \n", ".. ... ... ... ... ... ... ... ... ... \n", "236 24 24 24 24 24 24 24 24 24 \n", "237 18 18 18 18 18 19 19 19 19 \n", "238 19 19 19 19 19 19 19 19 19 \n", "239 156 168 182 196 209 239 256 256 332 \n", "240 448 449 451 457 464 464 464 472 473 \n", "241 1256 1339 1339 1339 1339 1368 1368 1368 1389 \n", "242 1265 1315 1351 1386 1461 1485 1523 1533 1547 \n", "243 15 15 15 15 15 15 15 15 15 \n", "244 5 5 5 5 5 5 5 5 5 \n", "245 11 11 11 11 11 11 11 11 11 \n", "246 1064 1064 1064 1142 1142 1142 1142 1142 1263 \n", "247 224 228 232 233 236 236 240 242 244 \n", "248 3 3 3 3 3 3 3 3 3 \n", "249 8 8 8 8 8 8 8 8 8 \n", "250 12 12 12 12 12 12 12 12 12 \n", "251 9 9 9 9 9 9 9 9 9 \n", "252 35 38 40 40 40 40 40 40 42 \n", "253 63 63 63 63 63 63 83 83 83 \n", "254 861 865 896 909 914 929 946 969 1001 \n", "255 6 7 7 7 7 7 7 7 7 \n", "256 284 336 358 369 393 409 409 438 443 \n", "257 13 13 13 13 13 13 13 13 13 \n", "258 1 1 1 1 1 1 1 1 1 \n", "259 994 994 994 994 994 994 994 1317 1604 \n", "260 9 9 9 9 9 9 9 9 9 \n", "261 483 484 484 484 485 499 499 513 513 \n", "262 323 354 399 419 453 469 482 484 496 \n", "263 106 106 132 132 132 132 141 141 141 \n", "264 3930 4013 4100 4191 4289 4370 4453 4529 4609 \n", "265 2 2 2 4 4 4 4 4 4 \n", "\n", " 6/9/20 \n", "0 21459 \n", "1 1299 \n", "2 10382 \n", "3 852 \n", "4 96 \n", "5 26 \n", "6 24761 \n", "7 13675 \n", "8 108 \n", "9 3117 \n", "10 29 \n", "11 1062 \n", "12 440 \n", "13 228 \n", "14 1691 \n", "15 599 \n", "16 16979 \n", "17 8191 \n", "18 103 \n", "19 15731 \n", "20 71675 \n", "21 92 \n", "22 50265 \n", "23 59437 \n", "24 305 \n", "25 59 \n", "26 14644 \n", "27 2728 \n", "28 739503 \n", "29 141 \n", ".. ... \n", "236 24 \n", "237 20 \n", "238 19 \n", "239 359 \n", "240 481 \n", "241 1389 \n", "242 1586 \n", "243 15 \n", "244 5 \n", "245 11 \n", "246 1263 \n", "247 246 \n", "248 3 \n", "249 8 \n", "250 12 \n", "251 9 \n", "252 42 \n", "253 83 \n", "254 1025 \n", "255 7 \n", "256 455 \n", "257 13 \n", "258 1 \n", "259 1604 \n", "260 9 \n", "261 514 \n", "262 524 \n", "263 141 \n", "264 4690 \n", "265 4 \n", "\n", "[266 rows x 144 columns]" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "x" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "extraction en indexant la 2e colonne" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "hideCode": false, "hidePrompt": false }, "outputs": [], "source": [ "y = pd.read_csv(\"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv\",index_col=1)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "hideCode": false, "hidePrompt": false, "scrolled": false }, "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", " \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/StateLatLong1/22/201/23/201/24/201/25/201/26/201/27/201/28/20...5/31/206/1/206/2/206/3/206/4/206/5/206/6/206/7/206/8/206/9/20
Country/Region
AfghanistanNaN33.00000065.0000000000000...15205157501650917267180541896919551203422091721459
AlbaniaNaN41.15330020.1683000000000...1137114311641184119712121232124612631299
AlgeriaNaN28.0339001.6596000000000...93949513962697339831993510050101541026510382
AndorraNaN42.5063001.5218000000000...764765844851852852852852852852
AngolaNaN-11.20270017.8739000000000...86868686868688919296
Antigua and BarbudaNaN17.060800-61.7964000000000...26262626262626262626
ArgentinaNaN-38.416100-63.6167000000000...16851174151831919268201972103722020227942362024761
ArmeniaNaN40.06910045.0382000000000...928294921000910524112211181712364131301332513675
AustraliaAustralian Capital Territory-35.473500149.0124000000000...107107107107107107108108108108
AustraliaNew South Wales-33.868800151.2093000000344...3098310431043106311031103109311231143117
AustraliaNorthern Territory-12.463400130.8456000000000...29292929292929292929
AustraliaQueensland-28.016700153.4000000000000...1058105910591060106010611061106210621062
AustraliaSouth Australia-34.928500138.6007000000000...440440440440440440440440440440
AustraliaTasmania-41.454500145.9707000000000...228228228228228228228228228228
AustraliaVictoria-37.813600144.9631000000111...1653166316701678168116811685168716871691
AustraliaWestern Australia-31.950500115.8605000000000...589591592592592596599599599599
AustriaNaN47.51620014.5501000000000...16731167331675916771168051684316898169021696816979
AzerbaijanNaN40.14310047.5769000000000...5494566259356260652268607239755378768191
BahamasNaN25.034300-77.3963000000000...102102102102102102103103103103
BahrainNaN26.02750050.5500000000000...11398118711231112815132961383514383147631541715731
BangladeshNaN23.68500090.3563000000000...47153495345244555140575636039163026657696850471675
BarbadosNaN13.193900-59.5432000000000...92929292929292929292
BelarusNaN53.70980027.9534000000000...42556434034425545116459814686847751486304945350265
BelgiumNaN50.8333004.0000000000000...58381585175861558685587675890759072592265934859437
BeninNaN9.3077002.3158000000000...232243244244261261261261288305
BhutanNaN27.51420090.4336000000000...43434747474848595959
BoliviaNaN-16.290200-63.5887000000000...9982105311099111638122451272813358136431394914644
Bosnia and HerzegovinaNaN43.91590017.6791000000000...2510252425352551259426062606260627042728
BrazilNaN-14.235000-51.9253000000000...514849526447555383584016614941645771672846691758707412739503
BruneiNaN4.535300114.7277000000000...141141141141141141141141141141
..................................................................
Timor-LesteNaN-8.874217125.7275390000000...24242424242424242424
BelizeNaN13.193900-59.5432000000000...18181818181919191920
LaosNaN19.856270102.4954960000000...19191919191919191919
LibyaNaN26.33510017.2283310000000...156168182196209239256256332359
West Bank and GazaNaN31.95220035.2332000000000...448449451457464464464472473481
Guinea-BissauNaN11.803700-15.1804000000000...1256133913391339133913681368136813891389
MaliNaN17.570692-3.9961660000000...1265131513511386146114851523153315471586
Saint Kitts and NevisNaN17.357822-62.7829980000000...15151515151515151515
CanadaNorthwest Territories64.825500-124.8457000000000...5555555555
CanadaYukon64.282300-135.0000000000000...11111111111111111111
KosovoNaN42.60263620.9029770000000...1064106410641142114211421142114212631263
BurmaNaN21.91620095.9560000000000...224228232233236236240242244246
United KingdomAnguilla18.220600-63.0686000000000...3333333333
United KingdomBritish Virgin Islands18.420700-64.6400000000000...8888888888
United KingdomTurks and Caicos Islands21.694000-71.7979000000000...12121212121212121212
MS ZaandamNaN0.0000000.0000000000000...9999999999
BotswanaNaN-22.32850024.6849000000000...35384040404040404242
BurundiNaN-3.37310029.9189000000000...63636363636383838383
Sierra LeoneNaN8.460555-11.7798890000000...86186589690991492994696910011025
NetherlandsBonaire, Sint Eustatius and Saba12.178400-68.2385000000000...6777777777
MalawiNaN-13.25430834.3015250000000...284336358369393409409438443455
United KingdomFalkland Islands (Malvinas)-51.796300-59.5236000000000...13131313131313131313
FranceSaint Pierre and Miquelon46.885200-56.3159000000000...1111111111
South SudanNaN6.87700031.3070000000000...994994994994994994994131716041604
Western SaharaNaN24.215500-12.8858000000000...9999999999
Sao Tome and PrincipeNaN0.1863606.6130810000000...483484484484485499499513513514
YemenNaN15.55272748.5163880000000...323354399419453469482484496524
ComorosNaN-11.64550043.3333000000000...106106132132132132141141141141
TajikistanNaN38.86103471.2760930000000...3930401341004191428943704453452946094690
LesothoNaN-29.60998828.2336080000000...2224444444
\n", "

266 rows × 143 columns

\n", "
" ], "text/plain": [ " Province/State Lat \\\n", "Country/Region \n", "Afghanistan NaN 33.000000 \n", "Albania NaN 41.153300 \n", "Algeria NaN 28.033900 \n", "Andorra NaN 42.506300 \n", "Angola NaN -11.202700 \n", "Antigua and Barbuda NaN 17.060800 \n", "Argentina NaN -38.416100 \n", "Armenia NaN 40.069100 \n", "Australia Australian Capital Territory -35.473500 \n", "Australia New South Wales -33.868800 \n", "Australia Northern Territory -12.463400 \n", "Australia Queensland -28.016700 \n", "Australia South Australia -34.928500 \n", "Australia Tasmania -41.454500 \n", "Australia Victoria -37.813600 \n", "Australia Western Australia -31.950500 \n", "Austria NaN 47.516200 \n", "Azerbaijan NaN 40.143100 \n", "Bahamas NaN 25.034300 \n", "Bahrain NaN 26.027500 \n", "Bangladesh NaN 23.685000 \n", "Barbados NaN 13.193900 \n", "Belarus NaN 53.709800 \n", "Belgium NaN 50.833300 \n", "Benin NaN 9.307700 \n", "Bhutan NaN 27.514200 \n", "Bolivia NaN -16.290200 \n", "Bosnia and Herzegovina NaN 43.915900 \n", "Brazil NaN -14.235000 \n", "Brunei NaN 4.535300 \n", "... ... ... \n", "Timor-Leste NaN -8.874217 \n", "Belize NaN 13.193900 \n", "Laos NaN 19.856270 \n", "Libya NaN 26.335100 \n", "West Bank and Gaza NaN 31.952200 \n", "Guinea-Bissau NaN 11.803700 \n", "Mali NaN 17.570692 \n", "Saint Kitts and Nevis NaN 17.357822 \n", "Canada Northwest Territories 64.825500 \n", "Canada Yukon 64.282300 \n", "Kosovo NaN 42.602636 \n", "Burma NaN 21.916200 \n", "United Kingdom Anguilla 18.220600 \n", "United Kingdom British Virgin Islands 18.420700 \n", "United Kingdom Turks and Caicos Islands 21.694000 \n", "MS Zaandam NaN 0.000000 \n", "Botswana NaN -22.328500 \n", "Burundi NaN -3.373100 \n", "Sierra Leone NaN 8.460555 \n", "Netherlands Bonaire, Sint Eustatius and Saba 12.178400 \n", "Malawi NaN -13.254308 \n", "United Kingdom Falkland Islands (Malvinas) -51.796300 \n", "France Saint Pierre and Miquelon 46.885200 \n", "South Sudan NaN 6.877000 \n", "Western Sahara NaN 24.215500 \n", "Sao Tome and Principe NaN 0.186360 \n", "Yemen NaN 15.552727 \n", "Comoros NaN -11.645500 \n", "Tajikistan NaN 38.861034 \n", "Lesotho NaN -29.609988 \n", "\n", " Long 1/22/20 1/23/20 1/24/20 1/25/20 \\\n", "Country/Region \n", "Afghanistan 65.000000 0 0 0 0 \n", "Albania 20.168300 0 0 0 0 \n", "Algeria 1.659600 0 0 0 0 \n", "Andorra 1.521800 0 0 0 0 \n", "Angola 17.873900 0 0 0 0 \n", "Antigua and Barbuda -61.796400 0 0 0 0 \n", "Argentina -63.616700 0 0 0 0 \n", "Armenia 45.038200 0 0 0 0 \n", "Australia 149.012400 0 0 0 0 \n", "Australia 151.209300 0 0 0 0 \n", "Australia 130.845600 0 0 0 0 \n", "Australia 153.400000 0 0 0 0 \n", "Australia 138.600700 0 0 0 0 \n", "Australia 145.970700 0 0 0 0 \n", "Australia 144.963100 0 0 0 0 \n", "Australia 115.860500 0 0 0 0 \n", "Austria 14.550100 0 0 0 0 \n", "Azerbaijan 47.576900 0 0 0 0 \n", "Bahamas -77.396300 0 0 0 0 \n", "Bahrain 50.550000 0 0 0 0 \n", "Bangladesh 90.356300 0 0 0 0 \n", "Barbados -59.543200 0 0 0 0 \n", "Belarus 27.953400 0 0 0 0 \n", "Belgium 4.000000 0 0 0 0 \n", "Benin 2.315800 0 0 0 0 \n", "Bhutan 90.433600 0 0 0 0 \n", "Bolivia -63.588700 0 0 0 0 \n", "Bosnia and Herzegovina 17.679100 0 0 0 0 \n", "Brazil -51.925300 0 0 0 0 \n", "Brunei 114.727700 0 0 0 0 \n", "... ... ... ... ... ... \n", "Timor-Leste 125.727539 0 0 0 0 \n", "Belize -59.543200 0 0 0 0 \n", "Laos 102.495496 0 0 0 0 \n", "Libya 17.228331 0 0 0 0 \n", "West Bank and Gaza 35.233200 0 0 0 0 \n", "Guinea-Bissau -15.180400 0 0 0 0 \n", "Mali -3.996166 0 0 0 0 \n", "Saint Kitts and Nevis -62.782998 0 0 0 0 \n", "Canada -124.845700 0 0 0 0 \n", "Canada -135.000000 0 0 0 0 \n", "Kosovo 20.902977 0 0 0 0 \n", "Burma 95.956000 0 0 0 0 \n", "United Kingdom -63.068600 0 0 0 0 \n", "United Kingdom -64.640000 0 0 0 0 \n", "United Kingdom -71.797900 0 0 0 0 \n", "MS Zaandam 0.000000 0 0 0 0 \n", "Botswana 24.684900 0 0 0 0 \n", "Burundi 29.918900 0 0 0 0 \n", "Sierra Leone -11.779889 0 0 0 0 \n", "Netherlands -68.238500 0 0 0 0 \n", "Malawi 34.301525 0 0 0 0 \n", "United Kingdom -59.523600 0 0 0 0 \n", "France -56.315900 0 0 0 0 \n", "South Sudan 31.307000 0 0 0 0 \n", "Western Sahara -12.885800 0 0 0 0 \n", "Sao Tome and Principe 6.613081 0 0 0 0 \n", "Yemen 48.516388 0 0 0 0 \n", "Comoros 43.333300 0 0 0 0 \n", "Tajikistan 71.276093 0 0 0 0 \n", "Lesotho 28.233608 0 0 0 0 \n", "\n", " 1/26/20 1/27/20 1/28/20 ... 5/31/20 6/1/20 \\\n", "Country/Region ... \n", "Afghanistan 0 0 0 ... 15205 15750 \n", "Albania 0 0 0 ... 1137 1143 \n", "Algeria 0 0 0 ... 9394 9513 \n", "Andorra 0 0 0 ... 764 765 \n", "Angola 0 0 0 ... 86 86 \n", "Antigua and Barbuda 0 0 0 ... 26 26 \n", "Argentina 0 0 0 ... 16851 17415 \n", "Armenia 0 0 0 ... 9282 9492 \n", "Australia 0 0 0 ... 107 107 \n", "Australia 3 4 4 ... 3098 3104 \n", "Australia 0 0 0 ... 29 29 \n", "Australia 0 0 0 ... 1058 1059 \n", "Australia 0 0 0 ... 440 440 \n", "Australia 0 0 0 ... 228 228 \n", "Australia 1 1 1 ... 1653 1663 \n", "Australia 0 0 0 ... 589 591 \n", "Austria 0 0 0 ... 16731 16733 \n", "Azerbaijan 0 0 0 ... 5494 5662 \n", "Bahamas 0 0 0 ... 102 102 \n", "Bahrain 0 0 0 ... 11398 11871 \n", "Bangladesh 0 0 0 ... 47153 49534 \n", "Barbados 0 0 0 ... 92 92 \n", "Belarus 0 0 0 ... 42556 43403 \n", "Belgium 0 0 0 ... 58381 58517 \n", "Benin 0 0 0 ... 232 243 \n", "Bhutan 0 0 0 ... 43 43 \n", "Bolivia 0 0 0 ... 9982 10531 \n", "Bosnia and Herzegovina 0 0 0 ... 2510 2524 \n", "Brazil 0 0 0 ... 514849 526447 \n", "Brunei 0 0 0 ... 141 141 \n", "... ... ... ... ... ... ... \n", "Timor-Leste 0 0 0 ... 24 24 \n", "Belize 0 0 0 ... 18 18 \n", "Laos 0 0 0 ... 19 19 \n", "Libya 0 0 0 ... 156 168 \n", "West Bank and Gaza 0 0 0 ... 448 449 \n", "Guinea-Bissau 0 0 0 ... 1256 1339 \n", "Mali 0 0 0 ... 1265 1315 \n", "Saint Kitts and Nevis 0 0 0 ... 15 15 \n", "Canada 0 0 0 ... 5 5 \n", "Canada 0 0 0 ... 11 11 \n", "Kosovo 0 0 0 ... 1064 1064 \n", "Burma 0 0 0 ... 224 228 \n", "United Kingdom 0 0 0 ... 3 3 \n", "United Kingdom 0 0 0 ... 8 8 \n", "United Kingdom 0 0 0 ... 12 12 \n", "MS Zaandam 0 0 0 ... 9 9 \n", "Botswana 0 0 0 ... 35 38 \n", "Burundi 0 0 0 ... 63 63 \n", "Sierra Leone 0 0 0 ... 861 865 \n", "Netherlands 0 0 0 ... 6 7 \n", "Malawi 0 0 0 ... 284 336 \n", "United Kingdom 0 0 0 ... 13 13 \n", "France 0 0 0 ... 1 1 \n", "South Sudan 0 0 0 ... 994 994 \n", "Western Sahara 0 0 0 ... 9 9 \n", "Sao Tome and Principe 0 0 0 ... 483 484 \n", "Yemen 0 0 0 ... 323 354 \n", "Comoros 0 0 0 ... 106 106 \n", "Tajikistan 0 0 0 ... 3930 4013 \n", "Lesotho 0 0 0 ... 2 2 \n", "\n", " 6/2/20 6/3/20 6/4/20 6/5/20 6/6/20 6/7/20 \\\n", "Country/Region \n", "Afghanistan 16509 17267 18054 18969 19551 20342 \n", "Albania 1164 1184 1197 1212 1232 1246 \n", "Algeria 9626 9733 9831 9935 10050 10154 \n", "Andorra 844 851 852 852 852 852 \n", "Angola 86 86 86 86 88 91 \n", "Antigua and Barbuda 26 26 26 26 26 26 \n", "Argentina 18319 19268 20197 21037 22020 22794 \n", "Armenia 10009 10524 11221 11817 12364 13130 \n", "Australia 107 107 107 107 108 108 \n", "Australia 3104 3106 3110 3110 3109 3112 \n", "Australia 29 29 29 29 29 29 \n", "Australia 1059 1060 1060 1061 1061 1062 \n", "Australia 440 440 440 440 440 440 \n", "Australia 228 228 228 228 228 228 \n", "Australia 1670 1678 1681 1681 1685 1687 \n", "Australia 592 592 592 596 599 599 \n", "Austria 16759 16771 16805 16843 16898 16902 \n", "Azerbaijan 5935 6260 6522 6860 7239 7553 \n", "Bahamas 102 102 102 102 103 103 \n", "Bahrain 12311 12815 13296 13835 14383 14763 \n", "Bangladesh 52445 55140 57563 60391 63026 65769 \n", "Barbados 92 92 92 92 92 92 \n", "Belarus 44255 45116 45981 46868 47751 48630 \n", "Belgium 58615 58685 58767 58907 59072 59226 \n", "Benin 244 244 261 261 261 261 \n", "Bhutan 47 47 47 48 48 59 \n", "Bolivia 10991 11638 12245 12728 13358 13643 \n", "Bosnia and Herzegovina 2535 2551 2594 2606 2606 2606 \n", "Brazil 555383 584016 614941 645771 672846 691758 \n", "Brunei 141 141 141 141 141 141 \n", "... ... ... ... ... ... ... \n", "Timor-Leste 24 24 24 24 24 24 \n", "Belize 18 18 18 19 19 19 \n", "Laos 19 19 19 19 19 19 \n", "Libya 182 196 209 239 256 256 \n", "West Bank and Gaza 451 457 464 464 464 472 \n", "Guinea-Bissau 1339 1339 1339 1368 1368 1368 \n", "Mali 1351 1386 1461 1485 1523 1533 \n", "Saint Kitts and Nevis 15 15 15 15 15 15 \n", "Canada 5 5 5 5 5 5 \n", "Canada 11 11 11 11 11 11 \n", "Kosovo 1064 1142 1142 1142 1142 1142 \n", "Burma 232 233 236 236 240 242 \n", "United Kingdom 3 3 3 3 3 3 \n", "United Kingdom 8 8 8 8 8 8 \n", "United Kingdom 12 12 12 12 12 12 \n", "MS Zaandam 9 9 9 9 9 9 \n", "Botswana 40 40 40 40 40 40 \n", "Burundi 63 63 63 63 83 83 \n", "Sierra Leone 896 909 914 929 946 969 \n", "Netherlands 7 7 7 7 7 7 \n", "Malawi 358 369 393 409 409 438 \n", "United Kingdom 13 13 13 13 13 13 \n", "France 1 1 1 1 1 1 \n", "South Sudan 994 994 994 994 994 1317 \n", "Western Sahara 9 9 9 9 9 9 \n", "Sao Tome and Principe 484 484 485 499 499 513 \n", "Yemen 399 419 453 469 482 484 \n", "Comoros 132 132 132 132 141 141 \n", "Tajikistan 4100 4191 4289 4370 4453 4529 \n", "Lesotho 2 4 4 4 4 4 \n", "\n", " 6/8/20 6/9/20 \n", "Country/Region \n", "Afghanistan 20917 21459 \n", "Albania 1263 1299 \n", "Algeria 10265 10382 \n", "Andorra 852 852 \n", "Angola 92 96 \n", "Antigua and Barbuda 26 26 \n", "Argentina 23620 24761 \n", "Armenia 13325 13675 \n", "Australia 108 108 \n", "Australia 3114 3117 \n", "Australia 29 29 \n", "Australia 1062 1062 \n", "Australia 440 440 \n", "Australia 228 228 \n", "Australia 1687 1691 \n", "Australia 599 599 \n", "Austria 16968 16979 \n", "Azerbaijan 7876 8191 \n", "Bahamas 103 103 \n", "Bahrain 15417 15731 \n", "Bangladesh 68504 71675 \n", "Barbados 92 92 \n", "Belarus 49453 50265 \n", "Belgium 59348 59437 \n", "Benin 288 305 \n", "Bhutan 59 59 \n", "Bolivia 13949 14644 \n", "Bosnia and Herzegovina 2704 2728 \n", "Brazil 707412 739503 \n", "Brunei 141 141 \n", "... ... ... \n", "Timor-Leste 24 24 \n", "Belize 19 20 \n", "Laos 19 19 \n", "Libya 332 359 \n", "West Bank and Gaza 473 481 \n", "Guinea-Bissau 1389 1389 \n", "Mali 1547 1586 \n", "Saint Kitts and Nevis 15 15 \n", "Canada 5 5 \n", "Canada 11 11 \n", "Kosovo 1263 1263 \n", "Burma 244 246 \n", "United Kingdom 3 3 \n", "United Kingdom 8 8 \n", "United Kingdom 12 12 \n", "MS Zaandam 9 9 \n", "Botswana 42 42 \n", "Burundi 83 83 \n", "Sierra Leone 1001 1025 \n", "Netherlands 7 7 \n", "Malawi 443 455 \n", "United Kingdom 13 13 \n", "France 1 1 \n", "South Sudan 1604 1604 \n", "Western Sahara 9 9 \n", "Sao Tome and Principe 513 514 \n", "Yemen 496 524 \n", "Comoros 141 141 \n", "Tajikistan 4609 4690 \n", "Lesotho 4 4 \n", "\n", "[266 rows x 143 columns]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "y" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "y.plot" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 Afghanistan\n", "1 Albania\n", "2 Algeria\n", "3 Andorra\n", "4 Angola\n", "5 Antigua and Barbuda\n", "6 Argentina\n", "7 Armenia\n", "8 Australia\n", "9 Australia\n", "10 Australia\n", "11 Australia\n", "12 Australia\n", "13 Australia\n", "14 Australia\n", "15 Australia\n", "16 Austria\n", "17 Azerbaijan\n", "18 Bahamas\n", "19 Bahrain\n", "20 Bangladesh\n", "21 Barbados\n", "22 Belarus\n", "23 Belgium\n", "24 Benin\n", "25 Bhutan\n", "26 Bolivia\n", "27 Bosnia and Herzegovina\n", "28 Brazil\n", "29 Brunei\n", " ... \n", "236 Timor-Leste\n", "237 Belize\n", "238 Laos\n", "239 Libya\n", "240 West Bank and Gaza\n", "241 Guinea-Bissau\n", "242 Mali\n", "243 Saint Kitts and Nevis\n", "244 Canada\n", "245 Canada\n", "246 Kosovo\n", "247 Burma\n", "248 United Kingdom\n", "249 United Kingdom\n", "250 United Kingdom\n", "251 MS Zaandam\n", "252 Botswana\n", "253 Burundi\n", "254 Sierra Leone\n", "255 Netherlands\n", "256 Malawi\n", "257 United Kingdom\n", "258 France\n", "259 South Sudan\n", "260 Western Sahara\n", "261 Sao Tome and Principe\n", "262 Yemen\n", "263 Comoros\n", "264 Tajikistan\n", "265 Lesotho\n", "Name: Country/Region, Length: 266, dtype: object" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "x['Country/Region']" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0 Afghanistan\n", "1 Albania\n", "2 Algeria\n", "3 Andorra\n", "4 Angola\n", "5 Antigua and Barbuda\n", "6 Argentina\n", "7 Armenia\n", "8 Australia\n", "9 Australia\n", "10 Australia\n", "11 Australia\n", "12 Australia\n", "13 Australia\n", "14 Australia\n", "15 Australia\n", "16 Austria\n", "17 Azerbaijan\n", "18 Bahamas\n", "19 Bahrain\n", "20 Bangladesh\n", "21 Barbados\n", "22 Belarus\n", "23 Belgium\n", "24 Benin\n", "25 Bhutan\n", "26 Bolivia\n", "27 Bosnia and Herzegovina\n", "28 Brazil\n", "29 Brunei\n", " ... \n", "236 Timor-Leste\n", "237 Belize\n", "238 Laos\n", "239 Libya\n", "240 West Bank and Gaza\n", "241 Guinea-Bissau\n", "242 Mali\n", "243 Saint Kitts and Nevis\n", "244 Canada\n", "245 Canada\n", "246 Kosovo\n", "247 Burma\n", "248 United Kingdom\n", "249 United Kingdom\n", "250 United Kingdom\n", "251 MS Zaandam\n", "252 Botswana\n", "253 Burundi\n", "254 Sierra Leone\n", "255 Netherlands\n", "256 Malawi\n", "257 United Kingdom\n", "258 France\n", "259 South Sudan\n", "260 Western Sahara\n", "261 Sao Tome and Principe\n", "262 Yemen\n", "263 Comoros\n", "264 Tajikistan\n", "265 Lesotho\n", "Name: Country/Region, Length: 266, dtype: object" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "m=x['Country/Region']\n", "m" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "print(x.Lat)" ] }, { "cell_type": "code", "execution_count": 10, "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", "
Country/RegionLat
0Afghanistan33.000000
1Albania41.153300
2Algeria28.033900
3Andorra42.506300
4Angola-11.202700
5Antigua and Barbuda17.060800
6Argentina-38.416100
7Armenia40.069100
8Australia-35.473500
9Australia-33.868800
10Australia-12.463400
11Australia-28.016700
12Australia-34.928500
13Australia-41.454500
14Australia-37.813600
15Australia-31.950500
16Austria47.516200
17Azerbaijan40.143100
18Bahamas25.034300
19Bahrain26.027500
20Bangladesh23.685000
21Barbados13.193900
22Belarus53.709800
23Belgium50.833300
24Benin9.307700
25Bhutan27.514200
26Bolivia-16.290200
27Bosnia and Herzegovina43.915900
28Brazil-14.235000
29Brunei4.535300
.........
236Timor-Leste-8.874217
237Belize13.193900
238Laos19.856270
239Libya26.335100
240West Bank and Gaza31.952200
241Guinea-Bissau11.803700
242Mali17.570692
243Saint Kitts and Nevis17.357822
244Canada64.825500
245Canada64.282300
246Kosovo42.602636
247Burma21.916200
248United Kingdom18.220600
249United Kingdom18.420700
250United Kingdom21.694000
251MS Zaandam0.000000
252Botswana-22.328500
253Burundi-3.373100
254Sierra Leone8.460555
255Netherlands12.178400
256Malawi-13.254308
257United Kingdom-51.796300
258France46.885200
259South Sudan6.877000
260Western Sahara24.215500
261Sao Tome and Principe0.186360
262Yemen15.552727
263Comoros-11.645500
264Tajikistan38.861034
265Lesotho-29.609988
\n", "

266 rows × 2 columns

\n", "
" ], "text/plain": [ " Country/Region Lat\n", "0 Afghanistan 33.000000\n", "1 Albania 41.153300\n", "2 Algeria 28.033900\n", "3 Andorra 42.506300\n", "4 Angola -11.202700\n", "5 Antigua and Barbuda 17.060800\n", "6 Argentina -38.416100\n", "7 Armenia 40.069100\n", "8 Australia -35.473500\n", "9 Australia -33.868800\n", "10 Australia -12.463400\n", "11 Australia -28.016700\n", "12 Australia -34.928500\n", "13 Australia -41.454500\n", "14 Australia -37.813600\n", "15 Australia -31.950500\n", "16 Austria 47.516200\n", "17 Azerbaijan 40.143100\n", "18 Bahamas 25.034300\n", "19 Bahrain 26.027500\n", "20 Bangladesh 23.685000\n", "21 Barbados 13.193900\n", "22 Belarus 53.709800\n", "23 Belgium 50.833300\n", "24 Benin 9.307700\n", "25 Bhutan 27.514200\n", "26 Bolivia -16.290200\n", "27 Bosnia and Herzegovina 43.915900\n", "28 Brazil -14.235000\n", "29 Brunei 4.535300\n", ".. ... ...\n", "236 Timor-Leste -8.874217\n", "237 Belize 13.193900\n", "238 Laos 19.856270\n", "239 Libya 26.335100\n", "240 West Bank and Gaza 31.952200\n", "241 Guinea-Bissau 11.803700\n", "242 Mali 17.570692\n", "243 Saint Kitts and Nevis 17.357822\n", "244 Canada 64.825500\n", "245 Canada 64.282300\n", "246 Kosovo 42.602636\n", "247 Burma 21.916200\n", "248 United Kingdom 18.220600\n", "249 United Kingdom 18.420700\n", "250 United Kingdom 21.694000\n", "251 MS Zaandam 0.000000\n", "252 Botswana -22.328500\n", "253 Burundi -3.373100\n", "254 Sierra Leone 8.460555\n", "255 Netherlands 12.178400\n", "256 Malawi -13.254308\n", "257 United Kingdom -51.796300\n", "258 France 46.885200\n", "259 South Sudan 6.877000\n", "260 Western Sahara 24.215500\n", "261 Sao Tome and Principe 0.186360\n", "262 Yemen 15.552727\n", "263 Comoros -11.645500\n", "264 Tajikistan 38.861034\n", "265 Lesotho -29.609988\n", "\n", "[266 rows x 2 columns]" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "x.loc[:,['Country/Region', 'Lat']]" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "x.loc[[1,2],:]" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "y.loc[['Belgium','China'],:]" ] }, { "cell_type": "code", "execution_count": 36, "metadata": {}, "outputs": [], "source": [ "Belgique=y.loc[['Belgium'],:]\n", "Chine=y.loc[['China'],:]\n", "France=y.loc[['France'],:]\n", "Allemagne=y.loc[['Germany'],:]\n", "Iran=y.loc[['Iran'],:]\n", "Italie=y.loc[['Italy'],:]\n", "Japon=y.loc[['Japan'],:]\n", "Hollande_et_colonies=y.loc[['Netherlands'],:]\n", "Portugal=y.loc[['Portugal'],:]\n", "Espagne=y.loc[['Spain'],:]\n", "RoyaumeUni_et_colonies=y.loc[['United Kingdom'],:]\n", "CoréeduSud=y.loc[['Korea, South'],:]\n", "EtatsUnis=y.loc[['US'],:]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "attention nous n'avons pas encore séparé hong kong et les colonies" ] }, { "cell_type": "code", "execution_count": 24, "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", "
Province/StateLatLong1/22/201/23/201/24/201/25/201/26/201/27/201/28/20...5/31/206/1/206/2/206/3/206/4/206/5/206/6/206/7/206/8/206/9/20
Country/Region
BelgiumNaN50.83334.00000000...58381585175861558685587675890759072592265934859437
\n", "

1 rows × 143 columns

\n", "
" ], "text/plain": [ " Province/State Lat Long 1/22/20 1/23/20 1/24/20 \\\n", "Country/Region \n", "Belgium NaN 50.8333 4.0 0 0 0 \n", "\n", " 1/25/20 1/26/20 1/27/20 1/28/20 ... 5/31/20 6/1/20 \\\n", "Country/Region ... \n", "Belgium 0 0 0 0 ... 58381 58517 \n", "\n", " 6/2/20 6/3/20 6/4/20 6/5/20 6/6/20 6/7/20 6/8/20 6/9/20 \n", "Country/Region \n", "Belgium 58615 58685 58767 58907 59072 59226 59348 59437 \n", "\n", "[1 rows x 143 columns]" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ " Belgique[Belgique.isnull().any(axis=1)]" ] }, { "cell_type": "code", "execution_count": 37, "metadata": {}, "outputs": [], "source": [ "France_metropolitaine=France[France.isnull().any(axis=1)]\n", "RoyaumeUnis=RoyaumeUni_et_colonies[RoyaumeUni_et_colonies.isnull().any(axis=1)]\n", "Hollande=Hollande_et_colonies[Hollande_et_colonies.isnull().any(axis=1)]" ] }, { "cell_type": "code", "execution_count": 38, "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", "
Province/StateLatLong1/22/201/23/201/24/201/25/201/26/201/27/201/28/20...5/31/206/1/206/2/206/3/206/4/206/5/206/6/206/7/206/8/206/9/20
Country/Region
United KingdomNaN55.3781-3.4360000000...274762276332277985279856281661283311284868286194287399289140
\n", "

1 rows × 143 columns

\n", "
" ], "text/plain": [ " Province/State Lat Long 1/22/20 1/23/20 1/24/20 \\\n", "Country/Region \n", "United Kingdom NaN 55.3781 -3.436 0 0 0 \n", "\n", " 1/25/20 1/26/20 1/27/20 1/28/20 ... 5/31/20 6/1/20 \\\n", "Country/Region ... \n", "United Kingdom 0 0 0 0 ... 274762 276332 \n", "\n", " 6/2/20 6/3/20 6/4/20 6/5/20 6/6/20 6/7/20 6/8/20 6/9/20 \n", "Country/Region \n", "United Kingdom 277985 279856 281661 283311 284868 286194 287399 289140 \n", "\n", "[1 rows x 143 columns]" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ "RoyaumeUnis" ] }, { "cell_type": "code", "execution_count": 39, "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", "
Province/StateLatLong1/22/201/23/201/24/201/25/201/26/201/27/201/28/20...5/31/206/1/206/2/206/3/206/4/206/5/206/6/206/7/206/8/206/9/20
Country/Region
ChinaAnhui31.8257117.22641915396070106...991991991991991991991991991991
ChinaBeijing40.1824116.414214223641688091...593593593594594594594594594594
ChinaChongqing30.0572107.874069275775110132...579579579579579579579579579579
ChinaFujian26.0789117.9874151018355980...358358358358358358359359359359
ChinaGansu37.8099101.0583022471419...139139139139139139139139139139
ChinaGuangdong23.3417113.424426325378111151207...1595159615971598159816011602160216041604
ChinaGuangxi23.8298108.7881252323364651...254254254254254254254254254254
ChinaGuizhou26.8154106.87481334579...147147147147147147147147147147
ChinaHainan19.1959109.745345819223340...169169169169169169170170170170
ChinaHebei39.5490116.13061128131833...328328328328328328328328328328
ChinaHeilongjiang47.8620127.76150249152133...945945945947947947947947947947
ChinaHenan33.8820113.61405593283128168...1276127612761276127612761276127612761276
ChinaHong Kong22.3000114.20000225888...1084108710931093109911021105110611071107
ChinaHubei30.9756112.2707444444549761105814233554...68135681356813568135681356813568135681356813568135
ChinaHunan27.6104111.708849244369100143...1019101910191019101910191019101910191019
ChinaInner Mongolia44.0935113.9448001771115...235235235235235235235235235237
ChinaJiangsu32.9711119.455015918334770...653653653653653653653653653653
ChinaJiangxi27.6140115.72212718183672109...937937937932932932932932932932
ChinaJilin43.6661126.19230134468...155155155155155155155155155155
ChinaLiaoning41.2956122.608523417212734...149149149149149149149149149149
ChinaMacau22.1667113.55001222567...45454545454545454545
ChinaNingxia37.2692106.165511234711...75757575757575757575
ChinaQinghai35.745295.99560001166...18181818181818181818
ChinaShaanxi35.1917108.870103515223546...308309309309309309311311311311
ChinaShandong36.3427118.1498261527467595...792792792792792792792792792792
ChinaShanghai31.2020121.44919162033405366...672673673673677677677678678678
ChinaShanxi37.5777112.2922111691327...198198198198198198198198198198
ChinaSichuan30.6171102.7103581528446990...575577577577578578578581582582
ChinaTianjin39.3054117.323044810142324...192192192192192192193193193194
ChinaTibet31.692788.09240000000...1111111111
ChinaXinjiang41.112985.240102234510...76767676767676767676
ChinaYunnan24.9740101.487012511162644...185185185185185185185185185185
ChinaZhejiang29.1832120.093410274362104128173...1268126812681268126812681268126812681268
\n", "

33 rows × 143 columns

\n", "
" ], "text/plain": [ " Province/State Lat Long 1/22/20 1/23/20 1/24/20 \\\n", "Country/Region \n", "China Anhui 31.8257 117.2264 1 9 15 \n", "China Beijing 40.1824 116.4142 14 22 36 \n", "China Chongqing 30.0572 107.8740 6 9 27 \n", "China Fujian 26.0789 117.9874 1 5 10 \n", "China Gansu 37.8099 101.0583 0 2 2 \n", "China Guangdong 23.3417 113.4244 26 32 53 \n", "China Guangxi 23.8298 108.7881 2 5 23 \n", "China Guizhou 26.8154 106.8748 1 3 3 \n", "China Hainan 19.1959 109.7453 4 5 8 \n", "China Hebei 39.5490 116.1306 1 1 2 \n", "China Heilongjiang 47.8620 127.7615 0 2 4 \n", "China Henan 33.8820 113.6140 5 5 9 \n", "China Hong Kong 22.3000 114.2000 0 2 2 \n", "China Hubei 30.9756 112.2707 444 444 549 \n", "China Hunan 27.6104 111.7088 4 9 24 \n", "China Inner Mongolia 44.0935 113.9448 0 0 1 \n", "China Jiangsu 32.9711 119.4550 1 5 9 \n", "China Jiangxi 27.6140 115.7221 2 7 18 \n", "China Jilin 43.6661 126.1923 0 1 3 \n", "China Liaoning 41.2956 122.6085 2 3 4 \n", "China Macau 22.1667 113.5500 1 2 2 \n", "China Ningxia 37.2692 106.1655 1 1 2 \n", "China Qinghai 35.7452 95.9956 0 0 0 \n", "China Shaanxi 35.1917 108.8701 0 3 5 \n", "China Shandong 36.3427 118.1498 2 6 15 \n", "China Shanghai 31.2020 121.4491 9 16 20 \n", "China Shanxi 37.5777 112.2922 1 1 1 \n", "China Sichuan 30.6171 102.7103 5 8 15 \n", "China Tianjin 39.3054 117.3230 4 4 8 \n", "China Tibet 31.6927 88.0924 0 0 0 \n", "China Xinjiang 41.1129 85.2401 0 2 2 \n", "China Yunnan 24.9740 101.4870 1 2 5 \n", "China Zhejiang 29.1832 120.0934 10 27 43 \n", "\n", " 1/25/20 1/26/20 1/27/20 1/28/20 ... 5/31/20 6/1/20 \\\n", "Country/Region ... \n", "China 39 60 70 106 ... 991 991 \n", "China 41 68 80 91 ... 593 593 \n", "China 57 75 110 132 ... 579 579 \n", "China 18 35 59 80 ... 358 358 \n", "China 4 7 14 19 ... 139 139 \n", "China 78 111 151 207 ... 1595 1596 \n", "China 23 36 46 51 ... 254 254 \n", "China 4 5 7 9 ... 147 147 \n", "China 19 22 33 40 ... 169 169 \n", "China 8 13 18 33 ... 328 328 \n", "China 9 15 21 33 ... 945 945 \n", "China 32 83 128 168 ... 1276 1276 \n", "China 5 8 8 8 ... 1084 1087 \n", "China 761 1058 1423 3554 ... 68135 68135 \n", "China 43 69 100 143 ... 1019 1019 \n", "China 7 7 11 15 ... 235 235 \n", "China 18 33 47 70 ... 653 653 \n", "China 18 36 72 109 ... 937 937 \n", "China 4 4 6 8 ... 155 155 \n", "China 17 21 27 34 ... 149 149 \n", "China 2 5 6 7 ... 45 45 \n", "China 3 4 7 11 ... 75 75 \n", "China 1 1 6 6 ... 18 18 \n", "China 15 22 35 46 ... 308 309 \n", "China 27 46 75 95 ... 792 792 \n", "China 33 40 53 66 ... 672 673 \n", "China 6 9 13 27 ... 198 198 \n", "China 28 44 69 90 ... 575 577 \n", "China 10 14 23 24 ... 192 192 \n", "China 0 0 0 0 ... 1 1 \n", "China 3 4 5 10 ... 76 76 \n", "China 11 16 26 44 ... 185 185 \n", "China 62 104 128 173 ... 1268 1268 \n", "\n", " 6/2/20 6/3/20 6/4/20 6/5/20 6/6/20 6/7/20 6/8/20 6/9/20 \n", "Country/Region \n", "China 991 991 991 991 991 991 991 991 \n", "China 593 594 594 594 594 594 594 594 \n", "China 579 579 579 579 579 579 579 579 \n", "China 358 358 358 358 359 359 359 359 \n", "China 139 139 139 139 139 139 139 139 \n", "China 1597 1598 1598 1601 1602 1602 1604 1604 \n", "China 254 254 254 254 254 254 254 254 \n", "China 147 147 147 147 147 147 147 147 \n", "China 169 169 169 169 170 170 170 170 \n", "China 328 328 328 328 328 328 328 328 \n", "China 945 947 947 947 947 947 947 947 \n", "China 1276 1276 1276 1276 1276 1276 1276 1276 \n", "China 1093 1093 1099 1102 1105 1106 1107 1107 \n", "China 68135 68135 68135 68135 68135 68135 68135 68135 \n", "China 1019 1019 1019 1019 1019 1019 1019 1019 \n", "China 235 235 235 235 235 235 235 237 \n", "China 653 653 653 653 653 653 653 653 \n", "China 937 932 932 932 932 932 932 932 \n", "China 155 155 155 155 155 155 155 155 \n", "China 149 149 149 149 149 149 149 149 \n", "China 45 45 45 45 45 45 45 45 \n", "China 75 75 75 75 75 75 75 75 \n", "China 18 18 18 18 18 18 18 18 \n", "China 309 309 309 309 311 311 311 311 \n", "China 792 792 792 792 792 792 792 792 \n", "China 673 673 677 677 677 678 678 678 \n", "China 198 198 198 198 198 198 198 198 \n", "China 577 577 578 578 578 581 582 582 \n", "China 192 192 192 192 193 193 193 194 \n", "China 1 1 1 1 1 1 1 1 \n", "China 76 76 76 76 76 76 76 76 \n", "China 185 185 185 185 185 185 185 185 \n", "China 1268 1268 1268 1268 1268 1268 1268 1268 \n", "\n", "[33 rows x 143 columns]" ] }, "execution_count": 39, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Chine" ] }, { "cell_type": "code", "execution_count": 40, "metadata": {}, "outputs": [ { "ename": "SyntaxError", "evalue": "invalid syntax (, line 1)", "output_type": "error", "traceback": [ "\u001b[0;36m File \u001b[0;32m\"\"\u001b[0;36m, line \u001b[0;32m1\u001b[0m\n\u001b[0;31m HongKong=Chine[Chine.is'Hong Kong'().any(axis=1)]\u001b[0m\n\u001b[0m ^\u001b[0m\n\u001b[0;31mSyntaxError\u001b[0m\u001b[0;31m:\u001b[0m invalid syntax\n" ] } ], "source": [ "HongKong=Chine[Chine.is'Hong Kong'().any(axis=1)]" ] }, { "cell_type": "code", "execution_count": 41, "metadata": {}, "outputs": [ { "ename": "NameError", "evalue": "name 'plot' is not defined", "output_type": "error", "traceback": [ "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[0;31mNameError\u001b[0m Traceback (most recent call last)", "\u001b[0;32m\u001b[0m in \u001b[0;36m\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mplot\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mFrance\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m", "\u001b[0;31mNameError\u001b[0m: name 'plot' is not defined" ] } ], "source": [ "plot.France" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "hide_code_all_hidden": false, "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 }