{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "provenance": [], "include_colab_link": true }, "kernelspec": { "name": "python3", "display_name": "Python 3" }, "language_info": { "name": "python" } }, "cells": [ { "cell_type": "markdown", "metadata": { "id": "view-in-github", "colab_type": "text" }, "source": [ "\"Open" ] }, { "cell_type": "markdown", "source": [ "**Importing required libraries**" ], "metadata": { "id": "NiEhYvYVHR1d" } }, { "cell_type": "code", "execution_count": 6, "metadata": { "id": "ouNoyoePxP9n" }, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np" ] }, { "cell_type": "markdown", "source": [ "**Read csv and excel files\n", "for csv - pd.read_csv('link or path of csv file')\n", "\n", "for excel - pd.read_excel('link or path of excel file')**" ], "metadata": { "id": "IwAFhDE5Hbul" } }, { "cell_type": "code", "source": [ "\n", "df = pd.read_csv('https://storage.googleapis.com/kagglesdsdata/datasets/494766/1402868/country_wise_latest.csv?X-Goog-Algorithm=GOOG4-RSA-SHA256&X-Goog-Credential=gcp-kaggle-com%40kaggle-161607.iam.gserviceaccount.com%2F20221024%2Fauto%2Fstorage%2Fgoog4_request&X-Goog-Date=20221024T130017Z&X-Goog-Expires=259200&X-Goog-SignedHeaders=host&X-Goog-Signature=9b288d1845d2d9c53fd33001de5d0d9eb509a5675a2176d40b359a48c520dd0c9c9f29ee98ff2c4ecb816057877eec72dd72797126ac9aee06663f676c7f08b8d2a8d1082dd9e8d766d98502063479e78802e7315cc83b640c9f098d2c800284218548888b8c01281f20e129f02be981d914711e862178ffeaaf39ba4d00572a684c64bf5077188744058e22815fa2ccf3c10498a05e5eaf903ea84895bb17dd933dada2f482f47ce25c5ff2305dde5fcef2baa40e2ee95cb5f3e1e0df09fc16b5693c964aa41b2bb42e3d7dae8c35e086813b2c05f5c8fab9cb9bb9f2459f5e1bf6d180a67e2c3c375604ec6ba068fbb239b2ecb19ff7492fb6303c766d875a')" ], "metadata": { "id": "T7_wT3Skzut0" }, "execution_count": 7, "outputs": [] }, { "cell_type": "markdown", "source": [ "***Indexing/Slicing***" ], "metadata": { "id": "Fjzg61a2HnE4" } }, { "cell_type": "code", "source": [ "#head\n", "df.head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 285 }, "id": "c1OVb65cDiiB", "outputId": "f33f8d06-7ef2-4a1e-a29f-8207ec27284c" }, "execution_count": 8, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases New deaths \\\n", "0 Afghanistan 36263 1269 25198 9796 106 10 \n", "1 Albania 4880 144 2745 1991 117 6 \n", "2 Algeria 27973 1163 18837 7973 616 8 \n", "3 Andorra 907 52 803 52 10 0 \n", "4 Angola 950 41 242 667 18 1 \n", "\n", " New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 18 3.50 69.49 \n", "1 63 2.95 56.25 \n", "2 749 4.16 67.34 \n", "3 0 5.73 88.53 \n", "4 0 4.32 25.47 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", "\n", " 1 week % increase WHO Region \n", "0 2.07 Eastern Mediterranean \n", "1 17.00 Europe \n", "2 18.07 Africa \n", "3 2.60 Europe \n", "4 26.84 Africa " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean
1Albania4880144274519911176632.9556.255.25417170917.00Europe
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa
3Andorra907528035210005.7388.536.48884232.60Europe
4Angola9504124266718104.3225.4716.9474920126.84Africa
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 8 } ] }, { "cell_type": "code", "source": [ "#tail\n", "df.tail()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 302 }, "id": "rIDWEkk2DyEw", "outputId": "076943bc-c2e0-4f52-f3ad-dda872be1f21" }, "execution_count": 9, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "182 West Bank and Gaza 10621 78 3752 6791 152 \n", "183 Western Sahara 10 1 8 1 0 \n", "184 Yemen 1691 483 833 375 10 \n", "185 Zambia 4552 140 2815 1597 71 \n", "186 Zimbabwe 2704 36 542 2126 192 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "182 2 0 0.73 35.33 \n", "183 0 0 10.00 80.00 \n", "184 4 36 28.56 49.26 \n", "185 1 465 3.08 61.84 \n", "186 2 24 1.33 20.04 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "182 2.08 8916 1705 \n", "183 12.50 10 0 \n", "184 57.98 1619 72 \n", "185 4.97 3326 1226 \n", "186 6.64 1713 991 \n", "\n", " 1 week % increase WHO Region \n", "182 19.12 Eastern Mediterranean \n", "183 0.00 Africa \n", "184 4.45 Eastern Mediterranean \n", "185 36.86 Africa \n", "186 57.85 Africa " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
182West Bank and Gaza106217837526791152200.7335.332.088916170519.12Eastern Mediterranean
183Western Sahara1018100010.0080.0012.501000.00Africa
184Yemen16914838333751043628.5649.2657.981619724.45Eastern Mediterranean
185Zambia4552140281515977114653.0861.844.973326122636.86Africa
186Zimbabwe27043654221261922241.3320.046.64171399157.85Africa
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 9 } ] }, { "cell_type": "code", "source": [ "#print specified try df.tail(7)\n", "df.head(8)" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 396 }, "id": "ii7Z6NWOD6xo", "outputId": "a0f56b54-4306-4f67-ccc1-868eaa734e50" }, "execution_count": 10, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "0 Afghanistan 36263 1269 25198 9796 106 \n", "1 Albania 4880 144 2745 1991 117 \n", "2 Algeria 27973 1163 18837 7973 616 \n", "3 Andorra 907 52 803 52 10 \n", "4 Angola 950 41 242 667 18 \n", "5 Antigua and Barbuda 86 3 65 18 4 \n", "6 Argentina 167416 3059 72575 91782 4890 \n", "7 Armenia 37390 711 26665 10014 73 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 10 18 3.50 69.49 \n", "1 6 63 2.95 56.25 \n", "2 8 749 4.16 67.34 \n", "3 0 0 5.73 88.53 \n", "4 1 0 4.32 25.47 \n", "5 0 5 3.49 75.58 \n", "6 120 2057 1.83 43.35 \n", "7 6 187 1.90 71.32 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", "5 4.62 76 10 \n", "6 4.21 130774 36642 \n", "7 2.67 34981 2409 \n", "\n", " 1 week % increase WHO Region \n", "0 2.07 Eastern Mediterranean \n", "1 17.00 Europe \n", "2 18.07 Africa \n", "3 2.60 Europe \n", "4 26.84 Africa \n", "5 13.16 Americas \n", "6 28.02 Americas \n", "7 6.89 Europe " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean
1Albania4880144274519911176632.9556.255.25417170917.00Europe
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa
3Andorra907528035210005.7388.536.48884232.60Europe
4Angola9504124266718104.3225.4716.9474920126.84Africa
5Antigua and Barbuda86365184053.4975.584.62761013.16Americas
6Argentina16741630597257591782489012020571.8343.354.211307743664228.02Americas
7Armenia3739071126665100147361871.9071.322.673498124096.89Europe
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 10 } ] }, { "cell_type": "code", "source": [ "#describe will do some of the default calculations \n", "df.describe()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 379 }, "id": "ccYK647PEXxB", "outputId": "a28260b4-adbb-42aa-b028-e0494f7dfe96" }, "execution_count": 11, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Confirmed Deaths Recovered Active New cases \\\n", "count 1.870000e+02 187.000000 1.870000e+02 1.870000e+02 187.000000 \n", "mean 8.813094e+04 3497.518717 5.063148e+04 3.400194e+04 1222.957219 \n", "std 3.833187e+05 14100.002482 1.901882e+05 2.133262e+05 5710.374790 \n", "min 1.000000e+01 0.000000 0.000000e+00 0.000000e+00 0.000000 \n", "25% 1.114000e+03 18.500000 6.265000e+02 1.415000e+02 4.000000 \n", "50% 5.059000e+03 108.000000 2.815000e+03 1.600000e+03 49.000000 \n", "75% 4.046050e+04 734.000000 2.260600e+04 9.149000e+03 419.500000 \n", "max 4.290259e+06 148011.000000 1.846641e+06 2.816444e+06 56336.000000 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "count 187.000000 187.000000 187.000000 187.000000 \n", "mean 28.957219 933.812834 3.019519 64.820535 \n", "std 120.037173 4197.719635 3.454302 26.287694 \n", "min 0.000000 0.000000 0.000000 0.000000 \n", "25% 0.000000 0.000000 0.945000 48.770000 \n", "50% 1.000000 22.000000 2.150000 71.320000 \n", "75% 6.000000 221.000000 3.875000 86.885000 \n", "max 1076.000000 33728.000000 28.560000 100.000000 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "count 187.00 1.870000e+02 187.000000 \n", "mean inf 7.868248e+04 9448.459893 \n", "std NaN 3.382737e+05 47491.127684 \n", "min 0.00 1.000000e+01 -47.000000 \n", "25% 1.45 1.051500e+03 49.000000 \n", "50% 3.62 5.020000e+03 432.000000 \n", "75% 6.44 3.708050e+04 3172.000000 \n", "max inf 3.834677e+06 455582.000000 \n", "\n", " 1 week % increase \n", "count 187.000000 \n", "mean 13.606203 \n", "std 24.509838 \n", "min -3.840000 \n", "25% 2.775000 \n", "50% 6.890000 \n", "75% 16.855000 \n", "max 226.320000 " ], "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", "
ConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increase
count1.870000e+02187.0000001.870000e+021.870000e+02187.000000187.000000187.000000187.000000187.000000187.001.870000e+02187.000000187.000000
mean8.813094e+043497.5187175.063148e+043.400194e+041222.95721928.957219933.8128343.01951964.820535inf7.868248e+049448.45989313.606203
std3.833187e+0514100.0024821.901882e+052.133262e+055710.374790120.0371734197.7196353.45430226.287694NaN3.382737e+0547491.12768424.509838
min1.000000e+010.0000000.000000e+000.000000e+000.0000000.0000000.0000000.0000000.0000000.001.000000e+01-47.000000-3.840000
25%1.114000e+0318.5000006.265000e+021.415000e+024.0000000.0000000.0000000.94500048.7700001.451.051500e+0349.0000002.775000
50%5.059000e+03108.0000002.815000e+031.600000e+0349.0000001.00000022.0000002.15000071.3200003.625.020000e+03432.0000006.890000
75%4.046050e+04734.0000002.260600e+049.149000e+03419.5000006.000000221.0000003.87500086.8850006.443.708050e+043172.00000016.855000
max4.290259e+06148011.0000001.846641e+062.816444e+0656336.0000001076.00000033728.00000028.560000100.000000inf3.834677e+06455582.000000226.320000
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 11 } ] }, { "cell_type": "code", "source": [ "#Shape - counts no. of rows and colums\n", "df.shape" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "ohiSINFYFW5v", "outputId": "4f8c46db-9390-4ca2-b527-0d73b7cf165e" }, "execution_count": 12, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "(187, 15)" ] }, "metadata": {}, "execution_count": 12 } ] }, { "cell_type": "code", "source": [ "#slicing rows - prints 0 to 10 rows with 1(every element) - [start,stop,step], try df[0:10:2], \n", "df[0:10:1]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 459 }, "id": "LfxMdy8PFq4a", "outputId": "3c9f6774-3a3c-40c2-dff2-f6551be558f6" }, "execution_count": 13, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "0 Afghanistan 36263 1269 25198 9796 106 \n", "1 Albania 4880 144 2745 1991 117 \n", "2 Algeria 27973 1163 18837 7973 616 \n", "3 Andorra 907 52 803 52 10 \n", "4 Angola 950 41 242 667 18 \n", "5 Antigua and Barbuda 86 3 65 18 4 \n", "6 Argentina 167416 3059 72575 91782 4890 \n", "7 Armenia 37390 711 26665 10014 73 \n", "8 Australia 15303 167 9311 5825 368 \n", "9 Austria 20558 713 18246 1599 86 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 10 18 3.50 69.49 \n", "1 6 63 2.95 56.25 \n", "2 8 749 4.16 67.34 \n", "3 0 0 5.73 88.53 \n", "4 1 0 4.32 25.47 \n", "5 0 5 3.49 75.58 \n", "6 120 2057 1.83 43.35 \n", "7 6 187 1.90 71.32 \n", "8 6 137 1.09 60.84 \n", "9 1 37 3.47 88.75 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", "5 4.62 76 10 \n", "6 4.21 130774 36642 \n", "7 2.67 34981 2409 \n", "8 1.79 12428 2875 \n", "9 3.91 19743 815 \n", "\n", " 1 week % increase WHO Region \n", "0 2.07 Eastern Mediterranean \n", "1 17.00 Europe \n", "2 18.07 Africa \n", "3 2.60 Europe \n", "4 26.84 Africa \n", "5 13.16 Americas \n", "6 28.02 Americas \n", "7 6.89 Europe \n", "8 23.13 Western Pacific \n", "9 4.13 Europe " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean
1Albania4880144274519911176632.9556.255.25417170917.00Europe
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa
3Andorra907528035210005.7388.536.48884232.60Europe
4Angola9504124266718104.3225.4716.9474920126.84Africa
5Antigua and Barbuda86365184053.4975.584.62761013.16Americas
6Argentina16741630597257591782489012020571.8343.354.211307743664228.02Americas
7Armenia3739071126665100147361871.9071.322.673498124096.89Europe
8Australia153031679311582536861371.0960.841.7912428287523.13Western Pacific
9Austria20558713182461599861373.4788.753.91197438154.13Europe
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 13 } ] }, { "cell_type": "code", "source": [ "#Sclicing columns\n", "df['Active']" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "9guU7wYDHpfy", "outputId": "67ae801b-52f2-4826-d1e8-10e813311890" }, "execution_count": 14, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "0 9796\n", "1 1991\n", "2 7973\n", "3 52\n", "4 667\n", " ... \n", "182 6791\n", "183 1\n", "184 375\n", "185 1597\n", "186 2126\n", "Name: Active, Length: 187, dtype: int64" ] }, "metadata": {}, "execution_count": 14 } ] }, { "cell_type": "code", "source": [ "#Access multiple columns\n", "df[['Active','Recovered']]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 423 }, "id": "EbHIpyQcH1vG", "outputId": "cfbbe6a1-d3a5-4f2e-e9d9-9f37011187fd" }, "execution_count": 15, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Active Recovered\n", "0 9796 25198\n", "1 1991 2745\n", "2 7973 18837\n", "3 52 803\n", "4 667 242\n", ".. ... ...\n", "182 6791 3752\n", "183 1 8\n", "184 375 833\n", "185 1597 2815\n", "186 2126 542\n", "\n", "[187 rows x 2 columns]" ], "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", "
ActiveRecovered
0979625198
119912745
2797318837
352803
4667242
.........
18267913752
18318
184375833
18515972815
1862126542
\n", "

187 rows × 2 columns

\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 15 } ] }, { "cell_type": "code", "source": [ "#Access multiple columns with filtering rows\n", "df[['Active','Recovered','New cases']][0:20:3]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 269 }, "id": "fIZqwUS3JI9l", "outputId": "5b70cedf-45ed-48d7-a020-8d0809136680" }, "execution_count": 16, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Active Recovered New cases\n", "0 9796 25198 106\n", "3 52 803 10\n", "6 91782 72575 4890\n", "9 1599 18246 86\n", "12 3231 36110 351\n", "15 6221 60492 119\n", "18 699 1036 0" ], "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", "
ActiveRecoveredNew cases
0979625198106
35280310
691782725754890
915991824686
12323136110351
15622160492119
1869910360
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 16 } ] }, { "cell_type": "code", "source": [ "#iteration - it will print the rows wise\n", "for i in df.iterrows():\n", " print(i)" ], "metadata": { "id": "FbafAccONO0G", "colab": { "base_uri": "https://localhost:8080/" }, "outputId": "28676f51-601c-45bf-ddc1-b3e216cefa41" }, "execution_count": 17, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "(0, Country/Region Afghanistan\n", "Confirmed 36263\n", "Deaths 1269\n", "Recovered 25198\n", "Active 9796\n", "New cases 106\n", "New deaths 10\n", "New recovered 18\n", "Deaths / 100 Cases 3.5\n", "Recovered / 100 Cases 69.49\n", "Deaths / 100 Recovered 5.04\n", "Confirmed last week 35526\n", "1 week change 737\n", "1 week % increase 2.07\n", "WHO Region Eastern Mediterranean\n", "Name: 0, dtype: object)\n", "(1, Country/Region Albania\n", "Confirmed 4880\n", "Deaths 144\n", "Recovered 2745\n", "Active 1991\n", "New cases 117\n", "New deaths 6\n", "New recovered 63\n", "Deaths / 100 Cases 2.95\n", "Recovered / 100 Cases 56.25\n", "Deaths / 100 Recovered 5.25\n", "Confirmed last week 4171\n", "1 week change 709\n", "1 week % increase 17.0\n", "WHO Region Europe\n", "Name: 1, dtype: object)\n", "(2, Country/Region Algeria\n", "Confirmed 27973\n", "Deaths 1163\n", "Recovered 18837\n", "Active 7973\n", "New cases 616\n", "New deaths 8\n", "New recovered 749\n", "Deaths / 100 Cases 4.16\n", "Recovered / 100 Cases 67.34\n", "Deaths / 100 Recovered 6.17\n", "Confirmed last week 23691\n", "1 week change 4282\n", "1 week % increase 18.07\n", "WHO Region Africa\n", "Name: 2, dtype: object)\n", "(3, Country/Region Andorra\n", "Confirmed 907\n", "Deaths 52\n", "Recovered 803\n", "Active 52\n", "New cases 10\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 5.73\n", "Recovered / 100 Cases 88.53\n", "Deaths / 100 Recovered 6.48\n", "Confirmed last week 884\n", "1 week change 23\n", "1 week % increase 2.6\n", "WHO Region Europe\n", "Name: 3, dtype: object)\n", "(4, Country/Region Angola\n", "Confirmed 950\n", "Deaths 41\n", "Recovered 242\n", "Active 667\n", "New cases 18\n", "New deaths 1\n", "New recovered 0\n", "Deaths / 100 Cases 4.32\n", "Recovered / 100 Cases 25.47\n", "Deaths / 100 Recovered 16.94\n", "Confirmed last week 749\n", "1 week change 201\n", "1 week % increase 26.84\n", "WHO Region Africa\n", "Name: 4, dtype: object)\n", "(5, Country/Region Antigua and Barbuda\n", "Confirmed 86\n", "Deaths 3\n", "Recovered 65\n", "Active 18\n", "New cases 4\n", "New deaths 0\n", "New recovered 5\n", "Deaths / 100 Cases 3.49\n", "Recovered / 100 Cases 75.58\n", "Deaths / 100 Recovered 4.62\n", "Confirmed last week 76\n", "1 week change 10\n", "1 week % increase 13.16\n", "WHO Region Americas\n", "Name: 5, dtype: object)\n", "(6, Country/Region Argentina\n", "Confirmed 167416\n", "Deaths 3059\n", "Recovered 72575\n", "Active 91782\n", "New cases 4890\n", "New deaths 120\n", "New recovered 2057\n", "Deaths / 100 Cases 1.83\n", "Recovered / 100 Cases 43.35\n", "Deaths / 100 Recovered 4.21\n", "Confirmed last week 130774\n", "1 week change 36642\n", "1 week % increase 28.02\n", "WHO Region Americas\n", "Name: 6, dtype: object)\n", "(7, Country/Region Armenia\n", "Confirmed 37390\n", "Deaths 711\n", "Recovered 26665\n", "Active 10014\n", "New cases 73\n", "New deaths 6\n", "New recovered 187\n", "Deaths / 100 Cases 1.9\n", "Recovered / 100 Cases 71.32\n", "Deaths / 100 Recovered 2.67\n", "Confirmed last week 34981\n", "1 week change 2409\n", "1 week % increase 6.89\n", "WHO Region Europe\n", "Name: 7, dtype: object)\n", "(8, Country/Region Australia\n", "Confirmed 15303\n", "Deaths 167\n", "Recovered 9311\n", "Active 5825\n", "New cases 368\n", "New deaths 6\n", "New recovered 137\n", "Deaths / 100 Cases 1.09\n", "Recovered / 100 Cases 60.84\n", "Deaths / 100 Recovered 1.79\n", "Confirmed last week 12428\n", "1 week change 2875\n", "1 week % increase 23.13\n", "WHO Region Western Pacific\n", "Name: 8, dtype: object)\n", "(9, Country/Region Austria\n", "Confirmed 20558\n", "Deaths 713\n", "Recovered 18246\n", "Active 1599\n", "New cases 86\n", "New deaths 1\n", "New recovered 37\n", "Deaths / 100 Cases 3.47\n", "Recovered / 100 Cases 88.75\n", "Deaths / 100 Recovered 3.91\n", "Confirmed last week 19743\n", "1 week change 815\n", "1 week % increase 4.13\n", "WHO Region Europe\n", "Name: 9, dtype: object)\n", "(10, Country/Region Azerbaijan\n", "Confirmed 30446\n", "Deaths 423\n", "Recovered 23242\n", "Active 6781\n", "New cases 396\n", "New deaths 6\n", "New recovered 558\n", "Deaths / 100 Cases 1.39\n", "Recovered / 100 Cases 76.34\n", "Deaths / 100 Recovered 1.82\n", "Confirmed last week 27890\n", "1 week change 2556\n", "1 week % increase 9.16\n", "WHO Region Europe\n", "Name: 10, dtype: object)\n", "(11, Country/Region Bahamas\n", "Confirmed 382\n", "Deaths 11\n", "Recovered 91\n", "Active 280\n", "New cases 40\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 2.88\n", "Recovered / 100 Cases 23.82\n", "Deaths / 100 Recovered 12.09\n", "Confirmed last week 174\n", "1 week change 208\n", "1 week % increase 119.54\n", "WHO Region Americas\n", "Name: 11, dtype: object)\n", "(12, Country/Region Bahrain\n", "Confirmed 39482\n", "Deaths 141\n", "Recovered 36110\n", "Active 3231\n", "New cases 351\n", "New deaths 1\n", "New recovered 421\n", "Deaths / 100 Cases 0.36\n", "Recovered / 100 Cases 91.46\n", "Deaths / 100 Recovered 0.39\n", "Confirmed last week 36936\n", "1 week change 2546\n", "1 week % increase 6.89\n", "WHO Region Eastern Mediterranean\n", "Name: 12, dtype: object)\n", "(13, Country/Region Bangladesh\n", "Confirmed 226225\n", "Deaths 2965\n", "Recovered 125683\n", "Active 97577\n", "New cases 2772\n", "New deaths 37\n", "New recovered 1801\n", "Deaths / 100 Cases 1.31\n", "Recovered / 100 Cases 55.56\n", "Deaths / 100 Recovered 2.36\n", "Confirmed last week 207453\n", "1 week change 18772\n", "1 week % increase 9.05\n", "WHO Region South-East Asia\n", "Name: 13, dtype: object)\n", "(14, Country/Region Barbados\n", "Confirmed 110\n", "Deaths 7\n", "Recovered 94\n", "Active 9\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 6.36\n", "Recovered / 100 Cases 85.45\n", "Deaths / 100 Recovered 7.45\n", "Confirmed last week 106\n", "1 week change 4\n", "1 week % increase 3.77\n", "WHO Region Americas\n", "Name: 14, dtype: object)\n", "(15, Country/Region Belarus\n", "Confirmed 67251\n", "Deaths 538\n", "Recovered 60492\n", "Active 6221\n", "New cases 119\n", "New deaths 4\n", "New recovered 67\n", "Deaths / 100 Cases 0.8\n", "Recovered / 100 Cases 89.95\n", "Deaths / 100 Recovered 0.89\n", "Confirmed last week 66213\n", "1 week change 1038\n", "1 week % increase 1.57\n", "WHO Region Europe\n", "Name: 15, dtype: object)\n", "(16, Country/Region Belgium\n", "Confirmed 66428\n", "Deaths 9822\n", "Recovered 17452\n", "Active 39154\n", "New cases 402\n", "New deaths 1\n", "New recovered 14\n", "Deaths / 100 Cases 14.79\n", "Recovered / 100 Cases 26.27\n", "Deaths / 100 Recovered 56.28\n", "Confirmed last week 64094\n", "1 week change 2334\n", "1 week % increase 3.64\n", "WHO Region Europe\n", "Name: 16, dtype: object)\n", "(17, Country/Region Belize\n", "Confirmed 48\n", "Deaths 2\n", "Recovered 26\n", "Active 20\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 4.17\n", "Recovered / 100 Cases 54.17\n", "Deaths / 100 Recovered 7.69\n", "Confirmed last week 40\n", "1 week change 8\n", "1 week % increase 20.0\n", "WHO Region Americas\n", "Name: 17, dtype: object)\n", "(18, Country/Region Benin\n", "Confirmed 1770\n", "Deaths 35\n", "Recovered 1036\n", "Active 699\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.98\n", "Recovered / 100 Cases 58.53\n", "Deaths / 100 Recovered 3.38\n", "Confirmed last week 1602\n", "1 week change 168\n", "1 week % increase 10.49\n", "WHO Region Africa\n", "Name: 18, dtype: object)\n", "(19, Country/Region Bhutan\n", "Confirmed 99\n", "Deaths 0\n", "Recovered 86\n", "Active 13\n", "New cases 4\n", "New deaths 0\n", "New recovered 1\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 86.87\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 90\n", "1 week change 9\n", "1 week % increase 10.0\n", "WHO Region South-East Asia\n", "Name: 19, dtype: object)\n", "(20, Country/Region Bolivia\n", "Confirmed 71181\n", "Deaths 2647\n", "Recovered 21478\n", "Active 47056\n", "New cases 1752\n", "New deaths 64\n", "New recovered 309\n", "Deaths / 100 Cases 3.72\n", "Recovered / 100 Cases 30.17\n", "Deaths / 100 Recovered 12.32\n", "Confirmed last week 60991\n", "1 week change 10190\n", "1 week % increase 16.71\n", "WHO Region Americas\n", "Name: 20, dtype: object)\n", "(21, Country/Region Bosnia and Herzegovina\n", "Confirmed 10498\n", "Deaths 294\n", "Recovered 4930\n", "Active 5274\n", "New cases 731\n", "New deaths 14\n", "New recovered 375\n", "Deaths / 100 Cases 2.8\n", "Recovered / 100 Cases 46.96\n", "Deaths / 100 Recovered 5.96\n", "Confirmed last week 8479\n", "1 week change 2019\n", "1 week % increase 23.81\n", "WHO Region Europe\n", "Name: 21, dtype: object)\n", "(22, Country/Region Botswana\n", "Confirmed 739\n", "Deaths 2\n", "Recovered 63\n", "Active 674\n", "New cases 53\n", "New deaths 1\n", "New recovered 11\n", "Deaths / 100 Cases 0.27\n", "Recovered / 100 Cases 8.53\n", "Deaths / 100 Recovered 3.17\n", "Confirmed last week 522\n", "1 week change 217\n", "1 week % increase 41.57\n", "WHO Region Africa\n", "Name: 22, dtype: object)\n", "(23, Country/Region Brazil\n", "Confirmed 2442375\n", "Deaths 87618\n", "Recovered 1846641\n", "Active 508116\n", "New cases 23284\n", "New deaths 614\n", "New recovered 33728\n", "Deaths / 100 Cases 3.59\n", "Recovered / 100 Cases 75.61\n", "Deaths / 100 Recovered 4.74\n", "Confirmed last week 2118646\n", "1 week change 323729\n", "1 week % increase 15.28\n", "WHO Region Americas\n", "Name: 23, dtype: object)\n", "(24, Country/Region Brunei\n", "Confirmed 141\n", "Deaths 3\n", "Recovered 138\n", "Active 0\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 2.13\n", "Recovered / 100 Cases 97.87\n", "Deaths / 100 Recovered 2.17\n", "Confirmed last week 141\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Western Pacific\n", "Name: 24, dtype: object)\n", "(25, Country/Region Bulgaria\n", "Confirmed 10621\n", "Deaths 347\n", "Recovered 5585\n", "Active 4689\n", "New cases 194\n", "New deaths 7\n", "New recovered 230\n", "Deaths / 100 Cases 3.27\n", "Recovered / 100 Cases 52.58\n", "Deaths / 100 Recovered 6.21\n", "Confirmed last week 8929\n", "1 week change 1692\n", "1 week % increase 18.95\n", "WHO Region Europe\n", "Name: 25, dtype: object)\n", "(26, Country/Region Burkina Faso\n", "Confirmed 1100\n", "Deaths 53\n", "Recovered 926\n", "Active 121\n", "New cases 14\n", "New deaths 0\n", "New recovered 6\n", "Deaths / 100 Cases 4.82\n", "Recovered / 100 Cases 84.18\n", "Deaths / 100 Recovered 5.72\n", "Confirmed last week 1065\n", "1 week change 35\n", "1 week % increase 3.29\n", "WHO Region Africa\n", "Name: 26, dtype: object)\n", "(27, Country/Region Burma\n", "Confirmed 350\n", "Deaths 6\n", "Recovered 292\n", "Active 52\n", "New cases 0\n", "New deaths 0\n", "New recovered 2\n", "Deaths / 100 Cases 1.71\n", "Recovered / 100 Cases 83.43\n", "Deaths / 100 Recovered 2.05\n", "Confirmed last week 341\n", "1 week change 9\n", "1 week % increase 2.64\n", "WHO Region South-East Asia\n", "Name: 27, dtype: object)\n", "(28, Country/Region Burundi\n", "Confirmed 378\n", "Deaths 1\n", "Recovered 301\n", "Active 76\n", "New cases 17\n", "New deaths 0\n", "New recovered 22\n", "Deaths / 100 Cases 0.26\n", "Recovered / 100 Cases 79.63\n", "Deaths / 100 Recovered 0.33\n", "Confirmed last week 322\n", "1 week change 56\n", "1 week % increase 17.39\n", "WHO Region Africa\n", "Name: 28, dtype: object)\n", "(29, Country/Region Cabo Verde\n", "Confirmed 2328\n", "Deaths 22\n", "Recovered 1550\n", "Active 756\n", "New cases 21\n", "New deaths 0\n", "New recovered 103\n", "Deaths / 100 Cases 0.95\n", "Recovered / 100 Cases 66.58\n", "Deaths / 100 Recovered 1.42\n", "Confirmed last week 2071\n", "1 week change 257\n", "1 week % increase 12.41\n", "WHO Region Africa\n", "Name: 29, dtype: object)\n", "(30, Country/Region Cambodia\n", "Confirmed 226\n", "Deaths 0\n", "Recovered 147\n", "Active 79\n", "New cases 1\n", "New deaths 0\n", "New recovered 4\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 65.04\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 171\n", "1 week change 55\n", "1 week % increase 32.16\n", "WHO Region Western Pacific\n", "Name: 30, dtype: object)\n", "(31, Country/Region Cameroon\n", "Confirmed 17110\n", "Deaths 391\n", "Recovered 14539\n", "Active 2180\n", "New cases 402\n", "New deaths 6\n", "New recovered 0\n", "Deaths / 100 Cases 2.29\n", "Recovered / 100 Cases 84.97\n", "Deaths / 100 Recovered 2.69\n", "Confirmed last week 16157\n", "1 week change 953\n", "1 week % increase 5.9\n", "WHO Region Africa\n", "Name: 31, dtype: object)\n", "(32, Country/Region Canada\n", "Confirmed 116458\n", "Deaths 8944\n", "Recovered 0\n", "Active 107514\n", "New cases 682\n", "New deaths 11\n", "New recovered 0\n", "Deaths / 100 Cases 7.68\n", "Recovered / 100 Cases 0.0\n", "Deaths / 100 Recovered inf\n", "Confirmed last week 112925\n", "1 week change 3533\n", "1 week % increase 3.13\n", "WHO Region Americas\n", "Name: 32, dtype: object)\n", "(33, Country/Region Central African Republic\n", "Confirmed 4599\n", "Deaths 59\n", "Recovered 1546\n", "Active 2994\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.28\n", "Recovered / 100 Cases 33.62\n", "Deaths / 100 Recovered 3.82\n", "Confirmed last week 4548\n", "1 week change 51\n", "1 week % increase 1.12\n", "WHO Region Africa\n", "Name: 33, dtype: object)\n", "(34, Country/Region Chad\n", "Confirmed 922\n", "Deaths 75\n", "Recovered 810\n", "Active 37\n", "New cases 7\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 8.13\n", "Recovered / 100 Cases 87.85\n", "Deaths / 100 Recovered 9.26\n", "Confirmed last week 889\n", "1 week change 33\n", "1 week % increase 3.71\n", "WHO Region Africa\n", "Name: 34, dtype: object)\n", "(35, Country/Region Chile\n", "Confirmed 347923\n", "Deaths 9187\n", "Recovered 319954\n", "Active 18782\n", "New cases 2133\n", "New deaths 75\n", "New recovered 1859\n", "Deaths / 100 Cases 2.64\n", "Recovered / 100 Cases 91.96\n", "Deaths / 100 Recovered 2.87\n", "Confirmed last week 333029\n", "1 week change 14894\n", "1 week % increase 4.47\n", "WHO Region Americas\n", "Name: 35, dtype: object)\n", "(36, Country/Region China\n", "Confirmed 86783\n", "Deaths 4656\n", "Recovered 78869\n", "Active 3258\n", "New cases 213\n", "New deaths 4\n", "New recovered 7\n", "Deaths / 100 Cases 5.37\n", "Recovered / 100 Cases 90.88\n", "Deaths / 100 Recovered 5.9\n", "Confirmed last week 85622\n", "1 week change 1161\n", "1 week % increase 1.36\n", "WHO Region Western Pacific\n", "Name: 36, dtype: object)\n", "(37, Country/Region Colombia\n", "Confirmed 257101\n", "Deaths 8777\n", "Recovered 131161\n", "Active 117163\n", "New cases 16306\n", "New deaths 508\n", "New recovered 11494\n", "Deaths / 100 Cases 3.41\n", "Recovered / 100 Cases 51.02\n", "Deaths / 100 Recovered 6.69\n", "Confirmed last week 204005\n", "1 week change 53096\n", "1 week % increase 26.03\n", "WHO Region Americas\n", "Name: 37, dtype: object)\n", "(38, Country/Region Comoros\n", "Confirmed 354\n", "Deaths 7\n", "Recovered 328\n", "Active 19\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.98\n", "Recovered / 100 Cases 92.66\n", "Deaths / 100 Recovered 2.13\n", "Confirmed last week 334\n", "1 week change 20\n", "1 week % increase 5.99\n", "WHO Region Africa\n", "Name: 38, dtype: object)\n", "(39, Country/Region Congo (Brazzaville)\n", "Confirmed 3200\n", "Deaths 54\n", "Recovered 829\n", "Active 2317\n", "New cases 162\n", "New deaths 3\n", "New recovered 73\n", "Deaths / 100 Cases 1.69\n", "Recovered / 100 Cases 25.91\n", "Deaths / 100 Recovered 6.51\n", "Confirmed last week 2851\n", "1 week change 349\n", "1 week % increase 12.24\n", "WHO Region Africa\n", "Name: 39, dtype: object)\n", "(40, Country/Region Congo (Kinshasa)\n", "Confirmed 8844\n", "Deaths 208\n", "Recovered 5700\n", "Active 2936\n", "New cases 13\n", "New deaths 4\n", "New recovered 190\n", "Deaths / 100 Cases 2.35\n", "Recovered / 100 Cases 64.45\n", "Deaths / 100 Recovered 3.65\n", "Confirmed last week 8443\n", "1 week change 401\n", "1 week % increase 4.75\n", "WHO Region Africa\n", "Name: 40, dtype: object)\n", "(41, Country/Region Costa Rica\n", "Confirmed 15841\n", "Deaths 115\n", "Recovered 3824\n", "Active 11902\n", "New cases 612\n", "New deaths 11\n", "New recovered 88\n", "Deaths / 100 Cases 0.73\n", "Recovered / 100 Cases 24.14\n", "Deaths / 100 Recovered 3.01\n", "Confirmed last week 11534\n", "1 week change 4307\n", "1 week % increase 37.34\n", "WHO Region Americas\n", "Name: 41, dtype: object)\n", "(42, Country/Region Cote d'Ivoire\n", "Confirmed 15655\n", "Deaths 96\n", "Recovered 10361\n", "Active 5198\n", "New cases 59\n", "New deaths 0\n", "New recovered 183\n", "Deaths / 100 Cases 0.61\n", "Recovered / 100 Cases 66.18\n", "Deaths / 100 Recovered 0.93\n", "Confirmed last week 14312\n", "1 week change 1343\n", "1 week % increase 9.38\n", "WHO Region Africa\n", "Name: 42, dtype: object)\n", "(43, Country/Region Croatia\n", "Confirmed 4881\n", "Deaths 139\n", "Recovered 3936\n", "Active 806\n", "New cases 24\n", "New deaths 3\n", "New recovered 70\n", "Deaths / 100 Cases 2.85\n", "Recovered / 100 Cases 80.64\n", "Deaths / 100 Recovered 3.53\n", "Confirmed last week 4370\n", "1 week change 511\n", "1 week % increase 11.69\n", "WHO Region Europe\n", "Name: 43, dtype: object)\n", "(44, Country/Region Cuba\n", "Confirmed 2532\n", "Deaths 87\n", "Recovered 2351\n", "Active 94\n", "New cases 37\n", "New deaths 0\n", "New recovered 2\n", "Deaths / 100 Cases 3.44\n", "Recovered / 100 Cases 92.85\n", "Deaths / 100 Recovered 3.7\n", "Confirmed last week 2446\n", "1 week change 86\n", "1 week % increase 3.52\n", "WHO Region Americas\n", "Name: 44, dtype: object)\n", "(45, Country/Region Cyprus\n", "Confirmed 1060\n", "Deaths 19\n", "Recovered 852\n", "Active 189\n", "New cases 3\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.79\n", "Recovered / 100 Cases 80.38\n", "Deaths / 100 Recovered 2.23\n", "Confirmed last week 1038\n", "1 week change 22\n", "1 week % increase 2.12\n", "WHO Region Europe\n", "Name: 45, dtype: object)\n", "(46, Country/Region Czechia\n", "Confirmed 15516\n", "Deaths 373\n", "Recovered 11428\n", "Active 3715\n", "New cases 192\n", "New deaths 2\n", "New recovered 0\n", "Deaths / 100 Cases 2.4\n", "Recovered / 100 Cases 73.65\n", "Deaths / 100 Recovered 3.26\n", "Confirmed last week 14098\n", "1 week change 1418\n", "1 week % increase 10.06\n", "WHO Region Europe\n", "Name: 46, dtype: object)\n", "(47, Country/Region Denmark\n", "Confirmed 13761\n", "Deaths 613\n", "Recovered 12605\n", "Active 543\n", "New cases 109\n", "New deaths 0\n", "New recovered 77\n", "Deaths / 100 Cases 4.45\n", "Recovered / 100 Cases 91.6\n", "Deaths / 100 Recovered 4.86\n", "Confirmed last week 13453\n", "1 week change 308\n", "1 week % increase 2.29\n", "WHO Region Europe\n", "Name: 47, dtype: object)\n", "(48, Country/Region Djibouti\n", "Confirmed 5059\n", "Deaths 58\n", "Recovered 4977\n", "Active 24\n", "New cases 9\n", "New deaths 0\n", "New recovered 11\n", "Deaths / 100 Cases 1.15\n", "Recovered / 100 Cases 98.38\n", "Deaths / 100 Recovered 1.17\n", "Confirmed last week 5020\n", "1 week change 39\n", "1 week % increase 0.78\n", "WHO Region Eastern Mediterranean\n", "Name: 48, dtype: object)\n", "(49, Country/Region Dominica\n", "Confirmed 18\n", "Deaths 0\n", "Recovered 18\n", "Active 0\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 100.0\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 18\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Americas\n", "Name: 49, dtype: object)\n", "(50, Country/Region Dominican Republic\n", "Confirmed 64156\n", "Deaths 1083\n", "Recovered 30204\n", "Active 32869\n", "New cases 1248\n", "New deaths 20\n", "New recovered 1601\n", "Deaths / 100 Cases 1.69\n", "Recovered / 100 Cases 47.08\n", "Deaths / 100 Recovered 3.59\n", "Confirmed last week 53956\n", "1 week change 10200\n", "1 week % increase 18.9\n", "WHO Region Americas\n", "Name: 50, dtype: object)\n", "(51, Country/Region Ecuador\n", "Confirmed 81161\n", "Deaths 5532\n", "Recovered 34896\n", "Active 40733\n", "New cases 467\n", "New deaths 17\n", "New recovered 0\n", "Deaths / 100 Cases 6.82\n", "Recovered / 100 Cases 43.0\n", "Deaths / 100 Recovered 15.85\n", "Confirmed last week 74620\n", "1 week change 6541\n", "1 week % increase 8.77\n", "WHO Region Americas\n", "Name: 51, dtype: object)\n", "(52, Country/Region Egypt\n", "Confirmed 92482\n", "Deaths 4652\n", "Recovered 34838\n", "Active 52992\n", "New cases 420\n", "New deaths 46\n", "New recovered 1007\n", "Deaths / 100 Cases 5.03\n", "Recovered / 100 Cases 37.67\n", "Deaths / 100 Recovered 13.35\n", "Confirmed last week 88402\n", "1 week change 4080\n", "1 week % increase 4.62\n", "WHO Region Eastern Mediterranean\n", "Name: 52, dtype: object)\n", "(53, Country/Region El Salvador\n", "Confirmed 15035\n", "Deaths 408\n", "Recovered 7778\n", "Active 6849\n", "New cases 405\n", "New deaths 8\n", "New recovered 130\n", "Deaths / 100 Cases 2.71\n", "Recovered / 100 Cases 51.73\n", "Deaths / 100 Recovered 5.25\n", "Confirmed last week 12207\n", "1 week change 2828\n", "1 week % increase 23.17\n", "WHO Region Americas\n", "Name: 53, dtype: object)\n", "(54, Country/Region Equatorial Guinea\n", "Confirmed 3071\n", "Deaths 51\n", "Recovered 842\n", "Active 2178\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.66\n", "Recovered / 100 Cases 27.42\n", "Deaths / 100 Recovered 6.06\n", "Confirmed last week 3071\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Africa\n", "Name: 54, dtype: object)\n", "(55, Country/Region Eritrea\n", "Confirmed 265\n", "Deaths 0\n", "Recovered 191\n", "Active 74\n", "New cases 2\n", "New deaths 0\n", "New recovered 2\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 72.08\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 251\n", "1 week change 14\n", "1 week % increase 5.58\n", "WHO Region Africa\n", "Name: 55, dtype: object)\n", "(56, Country/Region Estonia\n", "Confirmed 2034\n", "Deaths 69\n", "Recovered 1923\n", "Active 42\n", "New cases 0\n", "New deaths 0\n", "New recovered 1\n", "Deaths / 100 Cases 3.39\n", "Recovered / 100 Cases 94.54\n", "Deaths / 100 Recovered 3.59\n", "Confirmed last week 2021\n", "1 week change 13\n", "1 week % increase 0.64\n", "WHO Region Europe\n", "Name: 56, dtype: object)\n", "(57, Country/Region Eswatini\n", "Confirmed 2316\n", "Deaths 34\n", "Recovered 1025\n", "Active 1257\n", "New cases 109\n", "New deaths 2\n", "New recovered 39\n", "Deaths / 100 Cases 1.47\n", "Recovered / 100 Cases 44.26\n", "Deaths / 100 Recovered 3.32\n", "Confirmed last week 1826\n", "1 week change 490\n", "1 week % increase 26.83\n", "WHO Region Africa\n", "Name: 57, dtype: object)\n", "(58, Country/Region Ethiopia\n", "Confirmed 14547\n", "Deaths 228\n", "Recovered 6386\n", "Active 7933\n", "New cases 579\n", "New deaths 5\n", "New recovered 170\n", "Deaths / 100 Cases 1.57\n", "Recovered / 100 Cases 43.9\n", "Deaths / 100 Recovered 3.57\n", "Confirmed last week 10207\n", "1 week change 4340\n", "1 week % increase 42.52\n", "WHO Region Africa\n", "Name: 58, dtype: object)\n", "(59, Country/Region Fiji\n", "Confirmed 27\n", "Deaths 0\n", "Recovered 18\n", "Active 9\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 66.67\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 27\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Western Pacific\n", "Name: 59, dtype: object)\n", "(60, Country/Region Finland\n", "Confirmed 7398\n", "Deaths 329\n", "Recovered 6920\n", "Active 149\n", "New cases 5\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 4.45\n", "Recovered / 100 Cases 93.54\n", "Deaths / 100 Recovered 4.75\n", "Confirmed last week 7340\n", "1 week change 58\n", "1 week % increase 0.79\n", "WHO Region Europe\n", "Name: 60, dtype: object)\n", "(61, Country/Region France\n", "Confirmed 220352\n", "Deaths 30212\n", "Recovered 81212\n", "Active 108928\n", "New cases 2551\n", "New deaths 17\n", "New recovered 267\n", "Deaths / 100 Cases 13.71\n", "Recovered / 100 Cases 36.86\n", "Deaths / 100 Recovered 37.2\n", "Confirmed last week 214023\n", "1 week change 6329\n", "1 week % increase 2.96\n", "WHO Region Europe\n", "Name: 61, dtype: object)\n", "(62, Country/Region Gabon\n", "Confirmed 7189\n", "Deaths 49\n", "Recovered 4682\n", "Active 2458\n", "New cases 205\n", "New deaths 0\n", "New recovered 219\n", "Deaths / 100 Cases 0.68\n", "Recovered / 100 Cases 65.13\n", "Deaths / 100 Recovered 1.05\n", "Confirmed last week 6433\n", "1 week change 756\n", "1 week % increase 11.75\n", "WHO Region Africa\n", "Name: 62, dtype: object)\n", "(63, Country/Region Gambia\n", "Confirmed 326\n", "Deaths 8\n", "Recovered 66\n", "Active 252\n", "New cases 49\n", "New deaths 2\n", "New recovered 6\n", "Deaths / 100 Cases 2.45\n", "Recovered / 100 Cases 20.25\n", "Deaths / 100 Recovered 12.12\n", "Confirmed last week 112\n", "1 week change 214\n", "1 week % increase 191.07\n", "WHO Region Africa\n", "Name: 63, dtype: object)\n", "(64, Country/Region Georgia\n", "Confirmed 1137\n", "Deaths 16\n", "Recovered 922\n", "Active 199\n", "New cases 6\n", "New deaths 0\n", "New recovered 2\n", "Deaths / 100 Cases 1.41\n", "Recovered / 100 Cases 81.09\n", "Deaths / 100 Recovered 1.74\n", "Confirmed last week 1039\n", "1 week change 98\n", "1 week % increase 9.43\n", "WHO Region Europe\n", "Name: 64, dtype: object)\n", "(65, Country/Region Germany\n", "Confirmed 207112\n", "Deaths 9125\n", "Recovered 190314\n", "Active 7673\n", "New cases 445\n", "New deaths 1\n", "New recovered 259\n", "Deaths / 100 Cases 4.41\n", "Recovered / 100 Cases 91.89\n", "Deaths / 100 Recovered 4.79\n", "Confirmed last week 203325\n", "1 week change 3787\n", "1 week % increase 1.86\n", "WHO Region Europe\n", "Name: 65, dtype: object)\n", "(66, Country/Region Ghana\n", "Confirmed 33624\n", "Deaths 168\n", "Recovered 29801\n", "Active 3655\n", "New cases 655\n", "New deaths 0\n", "New recovered 307\n", "Deaths / 100 Cases 0.5\n", "Recovered / 100 Cases 88.63\n", "Deaths / 100 Recovered 0.56\n", "Confirmed last week 28430\n", "1 week change 5194\n", "1 week % increase 18.27\n", "WHO Region Africa\n", "Name: 66, dtype: object)\n", "(67, Country/Region Greece\n", "Confirmed 4227\n", "Deaths 202\n", "Recovered 1374\n", "Active 2651\n", "New cases 34\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 4.78\n", "Recovered / 100 Cases 32.51\n", "Deaths / 100 Recovered 14.7\n", "Confirmed last week 4012\n", "1 week change 215\n", "1 week % increase 5.36\n", "WHO Region Europe\n", "Name: 67, dtype: object)\n", "(68, Country/Region Greenland\n", "Confirmed 14\n", "Deaths 0\n", "Recovered 13\n", "Active 1\n", "New cases 1\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 92.86\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 13\n", "1 week change 1\n", "1 week % increase 7.69\n", "WHO Region Europe\n", "Name: 68, dtype: object)\n", "(69, Country/Region Grenada\n", "Confirmed 23\n", "Deaths 0\n", "Recovered 23\n", "Active 0\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 100.0\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 23\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Americas\n", "Name: 69, dtype: object)\n", "(70, Country/Region Guatemala\n", "Confirmed 45309\n", "Deaths 1761\n", "Recovered 32455\n", "Active 11093\n", "New cases 256\n", "New deaths 27\n", "New recovered 843\n", "Deaths / 100 Cases 3.89\n", "Recovered / 100 Cases 71.63\n", "Deaths / 100 Recovered 5.43\n", "Confirmed last week 39039\n", "1 week change 6270\n", "1 week % increase 16.06\n", "WHO Region Americas\n", "Name: 70, dtype: object)\n", "(71, Country/Region Guinea\n", "Confirmed 7055\n", "Deaths 45\n", "Recovered 6257\n", "Active 753\n", "New cases 47\n", "New deaths 2\n", "New recovered 105\n", "Deaths / 100 Cases 0.64\n", "Recovered / 100 Cases 88.69\n", "Deaths / 100 Recovered 0.72\n", "Confirmed last week 6590\n", "1 week change 465\n", "1 week % increase 7.06\n", "WHO Region Africa\n", "Name: 71, dtype: object)\n", "(72, Country/Region Guinea-Bissau\n", "Confirmed 1954\n", "Deaths 26\n", "Recovered 803\n", "Active 1125\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.33\n", "Recovered / 100 Cases 41.1\n", "Deaths / 100 Recovered 3.24\n", "Confirmed last week 1949\n", "1 week change 5\n", "1 week % increase 0.26\n", "WHO Region Africa\n", "Name: 72, dtype: object)\n", "(73, Country/Region Guyana\n", "Confirmed 389\n", "Deaths 20\n", "Recovered 181\n", "Active 188\n", "New cases 19\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 5.14\n", "Recovered / 100 Cases 46.53\n", "Deaths / 100 Recovered 11.05\n", "Confirmed last week 337\n", "1 week change 52\n", "1 week % increase 15.43\n", "WHO Region Americas\n", "Name: 73, dtype: object)\n", "(74, Country/Region Haiti\n", "Confirmed 7340\n", "Deaths 158\n", "Recovered 4365\n", "Active 2817\n", "New cases 25\n", "New deaths 1\n", "New recovered 0\n", "Deaths / 100 Cases 2.15\n", "Recovered / 100 Cases 59.47\n", "Deaths / 100 Recovered 3.62\n", "Confirmed last week 7053\n", "1 week change 287\n", "1 week % increase 4.07\n", "WHO Region Americas\n", "Name: 74, dtype: object)\n", "(75, Country/Region Holy See\n", "Confirmed 12\n", "Deaths 0\n", "Recovered 12\n", "Active 0\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 100.0\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 12\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Europe\n", "Name: 75, dtype: object)\n", "(76, Country/Region Honduras\n", "Confirmed 39741\n", "Deaths 1166\n", "Recovered 5039\n", "Active 33536\n", "New cases 465\n", "New deaths 50\n", "New recovered 117\n", "Deaths / 100 Cases 2.93\n", "Recovered / 100 Cases 12.68\n", "Deaths / 100 Recovered 23.14\n", "Confirmed last week 34611\n", "1 week change 5130\n", "1 week % increase 14.82\n", "WHO Region Americas\n", "Name: 76, dtype: object)\n", "(77, Country/Region Hungary\n", "Confirmed 4448\n", "Deaths 596\n", "Recovered 3329\n", "Active 523\n", "New cases 13\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 13.4\n", "Recovered / 100 Cases 74.84\n", "Deaths / 100 Recovered 17.9\n", "Confirmed last week 4339\n", "1 week change 109\n", "1 week % increase 2.51\n", "WHO Region Europe\n", "Name: 77, dtype: object)\n", "(78, Country/Region Iceland\n", "Confirmed 1854\n", "Deaths 10\n", "Recovered 1823\n", "Active 21\n", "New cases 7\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.54\n", "Recovered / 100 Cases 98.33\n", "Deaths / 100 Recovered 0.55\n", "Confirmed last week 1839\n", "1 week change 15\n", "1 week % increase 0.82\n", "WHO Region Europe\n", "Name: 78, dtype: object)\n", "(79, Country/Region India\n", "Confirmed 1480073\n", "Deaths 33408\n", "Recovered 951166\n", "Active 495499\n", "New cases 44457\n", "New deaths 637\n", "New recovered 33598\n", "Deaths / 100 Cases 2.26\n", "Recovered / 100 Cases 64.26\n", "Deaths / 100 Recovered 3.51\n", "Confirmed last week 1155338\n", "1 week change 324735\n", "1 week % increase 28.11\n", "WHO Region South-East Asia\n", "Name: 79, dtype: object)\n", "(80, Country/Region Indonesia\n", "Confirmed 100303\n", "Deaths 4838\n", "Recovered 58173\n", "Active 37292\n", "New cases 1525\n", "New deaths 57\n", "New recovered 1518\n", "Deaths / 100 Cases 4.82\n", "Recovered / 100 Cases 58.0\n", "Deaths / 100 Recovered 8.32\n", "Confirmed last week 88214\n", "1 week change 12089\n", "1 week % increase 13.7\n", "WHO Region South-East Asia\n", "Name: 80, dtype: object)\n", "(81, Country/Region Iran\n", "Confirmed 293606\n", "Deaths 15912\n", "Recovered 255144\n", "Active 22550\n", "New cases 2434\n", "New deaths 212\n", "New recovered 1931\n", "Deaths / 100 Cases 5.42\n", "Recovered / 100 Cases 86.9\n", "Deaths / 100 Recovered 6.24\n", "Confirmed last week 276202\n", "1 week change 17404\n", "1 week % increase 6.3\n", "WHO Region Eastern Mediterranean\n", "Name: 81, dtype: object)\n", "(82, Country/Region Iraq\n", "Confirmed 112585\n", "Deaths 4458\n", "Recovered 77144\n", "Active 30983\n", "New cases 2553\n", "New deaths 96\n", "New recovered 1927\n", "Deaths / 100 Cases 3.96\n", "Recovered / 100 Cases 68.52\n", "Deaths / 100 Recovered 5.78\n", "Confirmed last week 94693\n", "1 week change 17892\n", "1 week % increase 18.89\n", "WHO Region Eastern Mediterranean\n", "Name: 82, dtype: object)\n", "(83, Country/Region Ireland\n", "Confirmed 25892\n", "Deaths 1764\n", "Recovered 23364\n", "Active 764\n", "New cases 11\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 6.81\n", "Recovered / 100 Cases 90.24\n", "Deaths / 100 Recovered 7.55\n", "Confirmed last week 25766\n", "1 week change 126\n", "1 week % increase 0.49\n", "WHO Region Europe\n", "Name: 83, dtype: object)\n", "(84, Country/Region Israel\n", "Confirmed 63985\n", "Deaths 474\n", "Recovered 27133\n", "Active 36378\n", "New cases 2029\n", "New deaths 4\n", "New recovered 108\n", "Deaths / 100 Cases 0.74\n", "Recovered / 100 Cases 42.41\n", "Deaths / 100 Recovered 1.75\n", "Confirmed last week 52003\n", "1 week change 11982\n", "1 week % increase 23.04\n", "WHO Region Europe\n", "Name: 84, dtype: object)\n", "(85, Country/Region Italy\n", "Confirmed 246286\n", "Deaths 35112\n", "Recovered 198593\n", "Active 12581\n", "New cases 168\n", "New deaths 5\n", "New recovered 147\n", "Deaths / 100 Cases 14.26\n", "Recovered / 100 Cases 80.64\n", "Deaths / 100 Recovered 17.68\n", "Confirmed last week 244624\n", "1 week change 1662\n", "1 week % increase 0.68\n", "WHO Region Europe\n", "Name: 85, dtype: object)\n", "(86, Country/Region Jamaica\n", "Confirmed 853\n", "Deaths 10\n", "Recovered 714\n", "Active 129\n", "New cases 11\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.17\n", "Recovered / 100 Cases 83.7\n", "Deaths / 100 Recovered 1.4\n", "Confirmed last week 809\n", "1 week change 44\n", "1 week % increase 5.44\n", "WHO Region Americas\n", "Name: 86, dtype: object)\n", "(87, Country/Region Japan\n", "Confirmed 31142\n", "Deaths 998\n", "Recovered 21970\n", "Active 8174\n", "New cases 594\n", "New deaths 0\n", "New recovered 364\n", "Deaths / 100 Cases 3.2\n", "Recovered / 100 Cases 70.55\n", "Deaths / 100 Recovered 4.54\n", "Confirmed last week 25706\n", "1 week change 5436\n", "1 week % increase 21.15\n", "WHO Region Western Pacific\n", "Name: 87, dtype: object)\n", "(88, Country/Region Jordan\n", "Confirmed 1176\n", "Deaths 11\n", "Recovered 1041\n", "Active 124\n", "New cases 8\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.94\n", "Recovered / 100 Cases 88.52\n", "Deaths / 100 Recovered 1.06\n", "Confirmed last week 1223\n", "1 week change -47\n", "1 week % increase -3.84\n", "WHO Region Eastern Mediterranean\n", "Name: 88, dtype: object)\n", "(89, Country/Region Kazakhstan\n", "Confirmed 84648\n", "Deaths 585\n", "Recovered 54404\n", "Active 29659\n", "New cases 1526\n", "New deaths 0\n", "New recovered 1833\n", "Deaths / 100 Cases 0.69\n", "Recovered / 100 Cases 64.27\n", "Deaths / 100 Recovered 1.08\n", "Confirmed last week 73468\n", "1 week change 11180\n", "1 week % increase 15.22\n", "WHO Region Europe\n", "Name: 89, dtype: object)\n", "(90, Country/Region Kenya\n", "Confirmed 17975\n", "Deaths 285\n", "Recovered 7833\n", "Active 9857\n", "New cases 372\n", "New deaths 5\n", "New recovered 90\n", "Deaths / 100 Cases 1.59\n", "Recovered / 100 Cases 43.58\n", "Deaths / 100 Recovered 3.64\n", "Confirmed last week 13771\n", "1 week change 4204\n", "1 week % increase 30.53\n", "WHO Region Africa\n", "Name: 90, dtype: object)\n", "(91, Country/Region Kosovo\n", "Confirmed 7413\n", "Deaths 185\n", "Recovered 4027\n", "Active 3201\n", "New cases 496\n", "New deaths 16\n", "New recovered 274\n", "Deaths / 100 Cases 2.5\n", "Recovered / 100 Cases 54.32\n", "Deaths / 100 Recovered 4.59\n", "Confirmed last week 5877\n", "1 week change 1536\n", "1 week % increase 26.14\n", "WHO Region Europe\n", "Name: 91, dtype: object)\n", "(92, Country/Region Kuwait\n", "Confirmed 64379\n", "Deaths 438\n", "Recovered 55057\n", "Active 8884\n", "New cases 606\n", "New deaths 5\n", "New recovered 684\n", "Deaths / 100 Cases 0.68\n", "Recovered / 100 Cases 85.52\n", "Deaths / 100 Recovered 0.8\n", "Confirmed last week 59763\n", "1 week change 4616\n", "1 week % increase 7.72\n", "WHO Region Eastern Mediterranean\n", "Name: 92, dtype: object)\n", "(93, Country/Region Kyrgyzstan\n", "Confirmed 33296\n", "Deaths 1301\n", "Recovered 21205\n", "Active 10790\n", "New cases 483\n", "New deaths 24\n", "New recovered 817\n", "Deaths / 100 Cases 3.91\n", "Recovered / 100 Cases 63.69\n", "Deaths / 100 Recovered 6.14\n", "Confirmed last week 27143\n", "1 week change 6153\n", "1 week % increase 22.67\n", "WHO Region Europe\n", "Name: 93, dtype: object)\n", "(94, Country/Region Laos\n", "Confirmed 20\n", "Deaths 0\n", "Recovered 19\n", "Active 1\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 95.0\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 19\n", "1 week change 1\n", "1 week % increase 5.26\n", "WHO Region Western Pacific\n", "Name: 94, dtype: object)\n", "(95, Country/Region Latvia\n", "Confirmed 1219\n", "Deaths 31\n", "Recovered 1045\n", "Active 143\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 2.54\n", "Recovered / 100 Cases 85.73\n", "Deaths / 100 Recovered 2.97\n", "Confirmed last week 1192\n", "1 week change 27\n", "1 week % increase 2.27\n", "WHO Region Europe\n", "Name: 95, dtype: object)\n", "(96, Country/Region Lebanon\n", "Confirmed 3882\n", "Deaths 51\n", "Recovered 1709\n", "Active 2122\n", "New cases 132\n", "New deaths 0\n", "New recovered 17\n", "Deaths / 100 Cases 1.31\n", "Recovered / 100 Cases 44.02\n", "Deaths / 100 Recovered 2.98\n", "Confirmed last week 2905\n", "1 week change 977\n", "1 week % increase 33.63\n", "WHO Region Eastern Mediterranean\n", "Name: 96, dtype: object)\n", "(97, Country/Region Lesotho\n", "Confirmed 505\n", "Deaths 12\n", "Recovered 128\n", "Active 365\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 2.38\n", "Recovered / 100 Cases 25.35\n", "Deaths / 100 Recovered 9.38\n", "Confirmed last week 359\n", "1 week change 146\n", "1 week % increase 40.67\n", "WHO Region Africa\n", "Name: 97, dtype: object)\n", "(98, Country/Region Liberia\n", "Confirmed 1167\n", "Deaths 72\n", "Recovered 646\n", "Active 449\n", "New cases 5\n", "New deaths 0\n", "New recovered 5\n", "Deaths / 100 Cases 6.17\n", "Recovered / 100 Cases 55.36\n", "Deaths / 100 Recovered 11.15\n", "Confirmed last week 1107\n", "1 week change 60\n", "1 week % increase 5.42\n", "WHO Region Africa\n", "Name: 98, dtype: object)\n", "(99, Country/Region Libya\n", "Confirmed 2827\n", "Deaths 64\n", "Recovered 577\n", "Active 2186\n", "New cases 158\n", "New deaths 4\n", "New recovered 24\n", "Deaths / 100 Cases 2.26\n", "Recovered / 100 Cases 20.41\n", "Deaths / 100 Recovered 11.09\n", "Confirmed last week 1980\n", "1 week change 847\n", "1 week % increase 42.78\n", "WHO Region Eastern Mediterranean\n", "Name: 99, dtype: object)\n", "(100, Country/Region Liechtenstein\n", "Confirmed 86\n", "Deaths 1\n", "Recovered 81\n", "Active 4\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.16\n", "Recovered / 100 Cases 94.19\n", "Deaths / 100 Recovered 1.23\n", "Confirmed last week 86\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Europe\n", "Name: 100, dtype: object)\n", "(101, Country/Region Lithuania\n", "Confirmed 2019\n", "Deaths 80\n", "Recovered 1620\n", "Active 319\n", "New cases 11\n", "New deaths 0\n", "New recovered 4\n", "Deaths / 100 Cases 3.96\n", "Recovered / 100 Cases 80.24\n", "Deaths / 100 Recovered 4.94\n", "Confirmed last week 1947\n", "1 week change 72\n", "1 week % increase 3.7\n", "WHO Region Europe\n", "Name: 101, dtype: object)\n", "(102, Country/Region Luxembourg\n", "Confirmed 6321\n", "Deaths 112\n", "Recovered 4825\n", "Active 1384\n", "New cases 49\n", "New deaths 0\n", "New recovered 178\n", "Deaths / 100 Cases 1.77\n", "Recovered / 100 Cases 76.33\n", "Deaths / 100 Recovered 2.32\n", "Confirmed last week 5639\n", "1 week change 682\n", "1 week % increase 12.09\n", "WHO Region Europe\n", "Name: 102, dtype: object)\n", "(103, Country/Region Madagascar\n", "Confirmed 9690\n", "Deaths 91\n", "Recovered 6260\n", "Active 3339\n", "New cases 395\n", "New deaths 6\n", "New recovered 681\n", "Deaths / 100 Cases 0.94\n", "Recovered / 100 Cases 64.6\n", "Deaths / 100 Recovered 1.45\n", "Confirmed last week 7153\n", "1 week change 2537\n", "1 week % increase 35.47\n", "WHO Region Africa\n", "Name: 103, dtype: object)\n", "(104, Country/Region Malawi\n", "Confirmed 3664\n", "Deaths 99\n", "Recovered 1645\n", "Active 1920\n", "New cases 24\n", "New deaths 0\n", "New recovered 6\n", "Deaths / 100 Cases 2.7\n", "Recovered / 100 Cases 44.9\n", "Deaths / 100 Recovered 6.02\n", "Confirmed last week 2992\n", "1 week change 672\n", "1 week % increase 22.46\n", "WHO Region Africa\n", "Name: 104, dtype: object)\n", "(105, Country/Region Malaysia\n", "Confirmed 8904\n", "Deaths 124\n", "Recovered 8601\n", "Active 179\n", "New cases 7\n", "New deaths 0\n", "New recovered 1\n", "Deaths / 100 Cases 1.39\n", "Recovered / 100 Cases 96.6\n", "Deaths / 100 Recovered 1.44\n", "Confirmed last week 8800\n", "1 week change 104\n", "1 week % increase 1.18\n", "WHO Region Western Pacific\n", "Name: 105, dtype: object)\n", "(106, Country/Region Maldives\n", "Confirmed 3369\n", "Deaths 15\n", "Recovered 2547\n", "Active 807\n", "New cases 67\n", "New deaths 0\n", "New recovered 19\n", "Deaths / 100 Cases 0.45\n", "Recovered / 100 Cases 75.6\n", "Deaths / 100 Recovered 0.59\n", "Confirmed last week 2999\n", "1 week change 370\n", "1 week % increase 12.34\n", "WHO Region South-East Asia\n", "Name: 106, dtype: object)\n", "(107, Country/Region Mali\n", "Confirmed 2513\n", "Deaths 124\n", "Recovered 1913\n", "Active 476\n", "New cases 3\n", "New deaths 1\n", "New recovered 2\n", "Deaths / 100 Cases 4.93\n", "Recovered / 100 Cases 76.12\n", "Deaths / 100 Recovered 6.48\n", "Confirmed last week 2475\n", "1 week change 38\n", "1 week % increase 1.54\n", "WHO Region Africa\n", "Name: 107, dtype: object)\n", "(108, Country/Region Malta\n", "Confirmed 701\n", "Deaths 9\n", "Recovered 665\n", "Active 27\n", "New cases 1\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.28\n", "Recovered / 100 Cases 94.86\n", "Deaths / 100 Recovered 1.35\n", "Confirmed last week 677\n", "1 week change 24\n", "1 week % increase 3.55\n", "WHO Region Europe\n", "Name: 108, dtype: object)\n", "(109, Country/Region Mauritania\n", "Confirmed 6208\n", "Deaths 156\n", "Recovered 4653\n", "Active 1399\n", "New cases 37\n", "New deaths 0\n", "New recovered 223\n", "Deaths / 100 Cases 2.51\n", "Recovered / 100 Cases 74.95\n", "Deaths / 100 Recovered 3.35\n", "Confirmed last week 5923\n", "1 week change 285\n", "1 week % increase 4.81\n", "WHO Region Africa\n", "Name: 109, dtype: object)\n", "(110, Country/Region Mauritius\n", "Confirmed 344\n", "Deaths 10\n", "Recovered 332\n", "Active 2\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 2.91\n", "Recovered / 100 Cases 96.51\n", "Deaths / 100 Recovered 3.01\n", "Confirmed last week 343\n", "1 week change 1\n", "1 week % increase 0.29\n", "WHO Region Africa\n", "Name: 110, dtype: object)\n", "(111, Country/Region Mexico\n", "Confirmed 395489\n", "Deaths 44022\n", "Recovered 303810\n", "Active 47657\n", "New cases 4973\n", "New deaths 342\n", "New recovered 8588\n", "Deaths / 100 Cases 11.13\n", "Recovered / 100 Cases 76.82\n", "Deaths / 100 Recovered 14.49\n", "Confirmed last week 349396\n", "1 week change 46093\n", "1 week % increase 13.19\n", "WHO Region Americas\n", "Name: 111, dtype: object)\n", "(112, Country/Region Moldova\n", "Confirmed 23154\n", "Deaths 748\n", "Recovered 16154\n", "Active 6252\n", "New cases 120\n", "New deaths 13\n", "New recovered 245\n", "Deaths / 100 Cases 3.23\n", "Recovered / 100 Cases 69.77\n", "Deaths / 100 Recovered 4.63\n", "Confirmed last week 21115\n", "1 week change 2039\n", "1 week % increase 9.66\n", "WHO Region Europe\n", "Name: 112, dtype: object)\n", "(113, Country/Region Monaco\n", "Confirmed 116\n", "Deaths 4\n", "Recovered 104\n", "Active 8\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 3.45\n", "Recovered / 100 Cases 89.66\n", "Deaths / 100 Recovered 3.85\n", "Confirmed last week 109\n", "1 week change 7\n", "1 week % increase 6.42\n", "WHO Region Europe\n", "Name: 113, dtype: object)\n", "(114, Country/Region Mongolia\n", "Confirmed 289\n", "Deaths 0\n", "Recovered 222\n", "Active 67\n", "New cases 1\n", "New deaths 0\n", "New recovered 4\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 76.82\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 287\n", "1 week change 2\n", "1 week % increase 0.7\n", "WHO Region Western Pacific\n", "Name: 114, dtype: object)\n", "(115, Country/Region Montenegro\n", "Confirmed 2893\n", "Deaths 45\n", "Recovered 809\n", "Active 2039\n", "New cases 94\n", "New deaths 2\n", "New recovered 70\n", "Deaths / 100 Cases 1.56\n", "Recovered / 100 Cases 27.96\n", "Deaths / 100 Recovered 5.56\n", "Confirmed last week 2188\n", "1 week change 705\n", "1 week % increase 32.22\n", "WHO Region Europe\n", "Name: 115, dtype: object)\n", "(116, Country/Region Morocco\n", "Confirmed 20887\n", "Deaths 316\n", "Recovered 16553\n", "Active 4018\n", "New cases 609\n", "New deaths 3\n", "New recovered 115\n", "Deaths / 100 Cases 1.51\n", "Recovered / 100 Cases 79.25\n", "Deaths / 100 Recovered 1.91\n", "Confirmed last week 17562\n", "1 week change 3325\n", "1 week % increase 18.93\n", "WHO Region Eastern Mediterranean\n", "Name: 116, dtype: object)\n", "(117, Country/Region Mozambique\n", "Confirmed 1701\n", "Deaths 11\n", "Recovered 0\n", "Active 1690\n", "New cases 32\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.65\n", "Recovered / 100 Cases 0.0\n", "Deaths / 100 Recovered inf\n", "Confirmed last week 1507\n", "1 week change 194\n", "1 week % increase 12.87\n", "WHO Region Africa\n", "Name: 117, dtype: object)\n", "(118, Country/Region Namibia\n", "Confirmed 1843\n", "Deaths 8\n", "Recovered 101\n", "Active 1734\n", "New cases 68\n", "New deaths 0\n", "New recovered 26\n", "Deaths / 100 Cases 0.43\n", "Recovered / 100 Cases 5.48\n", "Deaths / 100 Recovered 7.92\n", "Confirmed last week 1344\n", "1 week change 499\n", "1 week % increase 37.13\n", "WHO Region Africa\n", "Name: 118, dtype: object)\n", "(119, Country/Region Nepal\n", "Confirmed 18752\n", "Deaths 48\n", "Recovered 13754\n", "Active 4950\n", "New cases 139\n", "New deaths 3\n", "New recovered 626\n", "Deaths / 100 Cases 0.26\n", "Recovered / 100 Cases 73.35\n", "Deaths / 100 Recovered 0.35\n", "Confirmed last week 17844\n", "1 week change 908\n", "1 week % increase 5.09\n", "WHO Region South-East Asia\n", "Name: 119, dtype: object)\n", "(120, Country/Region Netherlands\n", "Confirmed 53413\n", "Deaths 6160\n", "Recovered 189\n", "Active 47064\n", "New cases 419\n", "New deaths 1\n", "New recovered 0\n", "Deaths / 100 Cases 11.53\n", "Recovered / 100 Cases 0.35\n", "Deaths / 100 Recovered 3259.26\n", "Confirmed last week 52132\n", "1 week change 1281\n", "1 week % increase 2.46\n", "WHO Region Europe\n", "Name: 120, dtype: object)\n", "(121, Country/Region New Zealand\n", "Confirmed 1557\n", "Deaths 22\n", "Recovered 1514\n", "Active 21\n", "New cases 1\n", "New deaths 0\n", "New recovered 1\n", "Deaths / 100 Cases 1.41\n", "Recovered / 100 Cases 97.24\n", "Deaths / 100 Recovered 1.45\n", "Confirmed last week 1555\n", "1 week change 2\n", "1 week % increase 0.13\n", "WHO Region Western Pacific\n", "Name: 121, dtype: object)\n", "(122, Country/Region Nicaragua\n", "Confirmed 3439\n", "Deaths 108\n", "Recovered 2492\n", "Active 839\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 3.14\n", "Recovered / 100 Cases 72.46\n", "Deaths / 100 Recovered 4.33\n", "Confirmed last week 3147\n", "1 week change 292\n", "1 week % increase 9.28\n", "WHO Region Americas\n", "Name: 122, dtype: object)\n", "(123, Country/Region Niger\n", "Confirmed 1132\n", "Deaths 69\n", "Recovered 1027\n", "Active 36\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 6.1\n", "Recovered / 100 Cases 90.72\n", "Deaths / 100 Recovered 6.72\n", "Confirmed last week 1105\n", "1 week change 27\n", "1 week % increase 2.44\n", "WHO Region Africa\n", "Name: 123, dtype: object)\n", "(124, Country/Region Nigeria\n", "Confirmed 41180\n", "Deaths 860\n", "Recovered 18203\n", "Active 22117\n", "New cases 648\n", "New deaths 2\n", "New recovered 829\n", "Deaths / 100 Cases 2.09\n", "Recovered / 100 Cases 44.2\n", "Deaths / 100 Recovered 4.72\n", "Confirmed last week 37225\n", "1 week change 3955\n", "1 week % increase 10.62\n", "WHO Region Africa\n", "Name: 124, dtype: object)\n", "(125, Country/Region North Macedonia\n", "Confirmed 10213\n", "Deaths 466\n", "Recovered 5564\n", "Active 4183\n", "New cases 127\n", "New deaths 6\n", "New recovered 137\n", "Deaths / 100 Cases 4.56\n", "Recovered / 100 Cases 54.48\n", "Deaths / 100 Recovered 8.38\n", "Confirmed last week 9249\n", "1 week change 964\n", "1 week % increase 10.42\n", "WHO Region Europe\n", "Name: 125, dtype: object)\n", "(126, Country/Region Norway\n", "Confirmed 9132\n", "Deaths 255\n", "Recovered 8752\n", "Active 125\n", "New cases 15\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 2.79\n", "Recovered / 100 Cases 95.84\n", "Deaths / 100 Recovered 2.91\n", "Confirmed last week 9034\n", "1 week change 98\n", "1 week % increase 1.08\n", "WHO Region Europe\n", "Name: 126, dtype: object)\n", "(127, Country/Region Oman\n", "Confirmed 77058\n", "Deaths 393\n", "Recovered 57028\n", "Active 19637\n", "New cases 1053\n", "New deaths 9\n", "New recovered 1729\n", "Deaths / 100 Cases 0.51\n", "Recovered / 100 Cases 74.01\n", "Deaths / 100 Recovered 0.69\n", "Confirmed last week 68400\n", "1 week change 8658\n", "1 week % increase 12.66\n", "WHO Region Eastern Mediterranean\n", "Name: 127, dtype: object)\n", "(128, Country/Region Pakistan\n", "Confirmed 274289\n", "Deaths 5842\n", "Recovered 241026\n", "Active 27421\n", "New cases 1176\n", "New deaths 20\n", "New recovered 3592\n", "Deaths / 100 Cases 2.13\n", "Recovered / 100 Cases 87.87\n", "Deaths / 100 Recovered 2.42\n", "Confirmed last week 266096\n", "1 week change 8193\n", "1 week % increase 3.08\n", "WHO Region Eastern Mediterranean\n", "Name: 128, dtype: object)\n", "(129, Country/Region Panama\n", "Confirmed 61442\n", "Deaths 1322\n", "Recovered 35086\n", "Active 25034\n", "New cases 1146\n", "New deaths 28\n", "New recovered 955\n", "Deaths / 100 Cases 2.15\n", "Recovered / 100 Cases 57.1\n", "Deaths / 100 Recovered 3.77\n", "Confirmed last week 54426\n", "1 week change 7016\n", "1 week % increase 12.89\n", "WHO Region Americas\n", "Name: 129, dtype: object)\n", "(130, Country/Region Papua New Guinea\n", "Confirmed 62\n", "Deaths 0\n", "Recovered 11\n", "Active 51\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 17.74\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 19\n", "1 week change 43\n", "1 week % increase 226.32\n", "WHO Region Western Pacific\n", "Name: 130, dtype: object)\n", "(131, Country/Region Paraguay\n", "Confirmed 4548\n", "Deaths 43\n", "Recovered 2905\n", "Active 1600\n", "New cases 104\n", "New deaths 2\n", "New recovered 111\n", "Deaths / 100 Cases 0.95\n", "Recovered / 100 Cases 63.87\n", "Deaths / 100 Recovered 1.48\n", "Confirmed last week 3748\n", "1 week change 800\n", "1 week % increase 21.34\n", "WHO Region Americas\n", "Name: 131, dtype: object)\n", "(132, Country/Region Peru\n", "Confirmed 389717\n", "Deaths 18418\n", "Recovered 272547\n", "Active 98752\n", "New cases 13756\n", "New deaths 575\n", "New recovered 4697\n", "Deaths / 100 Cases 4.73\n", "Recovered / 100 Cases 69.93\n", "Deaths / 100 Recovered 6.76\n", "Confirmed last week 357681\n", "1 week change 32036\n", "1 week % increase 8.96\n", "WHO Region Americas\n", "Name: 132, dtype: object)\n", "(133, Country/Region Philippines\n", "Confirmed 82040\n", "Deaths 1945\n", "Recovered 26446\n", "Active 53649\n", "New cases 1592\n", "New deaths 13\n", "New recovered 336\n", "Deaths / 100 Cases 2.37\n", "Recovered / 100 Cases 32.24\n", "Deaths / 100 Recovered 7.35\n", "Confirmed last week 68898\n", "1 week change 13142\n", "1 week % increase 19.07\n", "WHO Region Western Pacific\n", "Name: 133, dtype: object)\n", "(134, Country/Region Poland\n", "Confirmed 43402\n", "Deaths 1676\n", "Recovered 32856\n", "Active 8870\n", "New cases 337\n", "New deaths 5\n", "New recovered 103\n", "Deaths / 100 Cases 3.86\n", "Recovered / 100 Cases 75.7\n", "Deaths / 100 Recovered 5.1\n", "Confirmed last week 40383\n", "1 week change 3019\n", "1 week % increase 7.48\n", "WHO Region Europe\n", "Name: 134, dtype: object)\n", "(135, Country/Region Portugal\n", "Confirmed 50299\n", "Deaths 1719\n", "Recovered 35375\n", "Active 13205\n", "New cases 135\n", "New deaths 2\n", "New recovered 158\n", "Deaths / 100 Cases 3.42\n", "Recovered / 100 Cases 70.33\n", "Deaths / 100 Recovered 4.86\n", "Confirmed last week 48771\n", "1 week change 1528\n", "1 week % increase 3.13\n", "WHO Region Europe\n", "Name: 135, dtype: object)\n", "(136, Country/Region Qatar\n", "Confirmed 109597\n", "Deaths 165\n", "Recovered 106328\n", "Active 3104\n", "New cases 292\n", "New deaths 0\n", "New recovered 304\n", "Deaths / 100 Cases 0.15\n", "Recovered / 100 Cases 97.02\n", "Deaths / 100 Recovered 0.16\n", "Confirmed last week 107037\n", "1 week change 2560\n", "1 week % increase 2.39\n", "WHO Region Eastern Mediterranean\n", "Name: 136, dtype: object)\n", "(137, Country/Region Romania\n", "Confirmed 45902\n", "Deaths 2206\n", "Recovered 25794\n", "Active 17902\n", "New cases 1104\n", "New deaths 19\n", "New recovered 151\n", "Deaths / 100 Cases 4.81\n", "Recovered / 100 Cases 56.19\n", "Deaths / 100 Recovered 8.55\n", "Confirmed last week 38139\n", "1 week change 7763\n", "1 week % increase 20.35\n", "WHO Region Europe\n", "Name: 137, dtype: object)\n", "(138, Country/Region Russia\n", "Confirmed 816680\n", "Deaths 13334\n", "Recovered 602249\n", "Active 201097\n", "New cases 5607\n", "New deaths 85\n", "New recovered 3077\n", "Deaths / 100 Cases 1.63\n", "Recovered / 100 Cases 73.74\n", "Deaths / 100 Recovered 2.21\n", "Confirmed last week 776212\n", "1 week change 40468\n", "1 week % increase 5.21\n", "WHO Region Europe\n", "Name: 138, dtype: object)\n", "(139, Country/Region Rwanda\n", "Confirmed 1879\n", "Deaths 5\n", "Recovered 975\n", "Active 899\n", "New cases 58\n", "New deaths 0\n", "New recovered 57\n", "Deaths / 100 Cases 0.27\n", "Recovered / 100 Cases 51.89\n", "Deaths / 100 Recovered 0.51\n", "Confirmed last week 1629\n", "1 week change 250\n", "1 week % increase 15.35\n", "WHO Region Africa\n", "Name: 139, dtype: object)\n", "(140, Country/Region Saint Kitts and Nevis\n", "Confirmed 17\n", "Deaths 0\n", "Recovered 15\n", "Active 2\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 88.24\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 17\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Americas\n", "Name: 140, dtype: object)\n", "(141, Country/Region Saint Lucia\n", "Confirmed 24\n", "Deaths 0\n", "Recovered 22\n", "Active 2\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 91.67\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 23\n", "1 week change 1\n", "1 week % increase 4.35\n", "WHO Region Americas\n", "Name: 141, dtype: object)\n", "(142, Country/Region Saint Vincent and the Grenadines\n", "Confirmed 52\n", "Deaths 0\n", "Recovered 39\n", "Active 13\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 75.0\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 50\n", "1 week change 2\n", "1 week % increase 4.0\n", "WHO Region Americas\n", "Name: 142, dtype: object)\n", "(143, Country/Region San Marino\n", "Confirmed 699\n", "Deaths 42\n", "Recovered 657\n", "Active 0\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 6.01\n", "Recovered / 100 Cases 93.99\n", "Deaths / 100 Recovered 6.39\n", "Confirmed last week 699\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Europe\n", "Name: 143, dtype: object)\n", "(144, Country/Region Sao Tome and Principe\n", "Confirmed 865\n", "Deaths 14\n", "Recovered 734\n", "Active 117\n", "New cases 2\n", "New deaths 0\n", "New recovered 38\n", "Deaths / 100 Cases 1.62\n", "Recovered / 100 Cases 84.86\n", "Deaths / 100 Recovered 1.91\n", "Confirmed last week 746\n", "1 week change 119\n", "1 week % increase 15.95\n", "WHO Region Africa\n", "Name: 144, dtype: object)\n", "(145, Country/Region Saudi Arabia\n", "Confirmed 268934\n", "Deaths 2760\n", "Recovered 222936\n", "Active 43238\n", "New cases 1993\n", "New deaths 27\n", "New recovered 2613\n", "Deaths / 100 Cases 1.03\n", "Recovered / 100 Cases 82.9\n", "Deaths / 100 Recovered 1.24\n", "Confirmed last week 253349\n", "1 week change 15585\n", "1 week % increase 6.15\n", "WHO Region Eastern Mediterranean\n", "Name: 145, dtype: object)\n", "(146, Country/Region Senegal\n", "Confirmed 9764\n", "Deaths 194\n", "Recovered 6477\n", "Active 3093\n", "New cases 83\n", "New deaths 3\n", "New recovered 68\n", "Deaths / 100 Cases 1.99\n", "Recovered / 100 Cases 66.34\n", "Deaths / 100 Recovered 3.0\n", "Confirmed last week 8948\n", "1 week change 816\n", "1 week % increase 9.12\n", "WHO Region Africa\n", "Name: 146, dtype: object)\n", "(147, Country/Region Serbia\n", "Confirmed 24141\n", "Deaths 543\n", "Recovered 0\n", "Active 23598\n", "New cases 411\n", "New deaths 9\n", "New recovered 0\n", "Deaths / 100 Cases 2.25\n", "Recovered / 100 Cases 0.0\n", "Deaths / 100 Recovered inf\n", "Confirmed last week 21253\n", "1 week change 2888\n", "1 week % increase 13.59\n", "WHO Region Europe\n", "Name: 147, dtype: object)\n", "(148, Country/Region Seychelles\n", "Confirmed 114\n", "Deaths 0\n", "Recovered 39\n", "Active 75\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 34.21\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 108\n", "1 week change 6\n", "1 week % increase 5.56\n", "WHO Region Africa\n", "Name: 148, dtype: object)\n", "(149, Country/Region Sierra Leone\n", "Confirmed 1783\n", "Deaths 66\n", "Recovered 1317\n", "Active 400\n", "New cases 0\n", "New deaths 0\n", "New recovered 4\n", "Deaths / 100 Cases 3.7\n", "Recovered / 100 Cases 73.86\n", "Deaths / 100 Recovered 5.01\n", "Confirmed last week 1711\n", "1 week change 72\n", "1 week % increase 4.21\n", "WHO Region Africa\n", "Name: 149, dtype: object)\n", "(150, Country/Region Singapore\n", "Confirmed 50838\n", "Deaths 27\n", "Recovered 45692\n", "Active 5119\n", "New cases 469\n", "New deaths 0\n", "New recovered 171\n", "Deaths / 100 Cases 0.05\n", "Recovered / 100 Cases 89.88\n", "Deaths / 100 Recovered 0.06\n", "Confirmed last week 48035\n", "1 week change 2803\n", "1 week % increase 5.84\n", "WHO Region Western Pacific\n", "Name: 150, dtype: object)\n", "(151, Country/Region Slovakia\n", "Confirmed 2181\n", "Deaths 28\n", "Recovered 1616\n", "Active 537\n", "New cases 2\n", "New deaths 0\n", "New recovered 39\n", "Deaths / 100 Cases 1.28\n", "Recovered / 100 Cases 74.09\n", "Deaths / 100 Recovered 1.73\n", "Confirmed last week 1980\n", "1 week change 201\n", "1 week % increase 10.15\n", "WHO Region Europe\n", "Name: 151, dtype: object)\n", "(152, Country/Region Slovenia\n", "Confirmed 2087\n", "Deaths 116\n", "Recovered 1733\n", "Active 238\n", "New cases 5\n", "New deaths 0\n", "New recovered 55\n", "Deaths / 100 Cases 5.56\n", "Recovered / 100 Cases 83.04\n", "Deaths / 100 Recovered 6.69\n", "Confirmed last week 1953\n", "1 week change 134\n", "1 week % increase 6.86\n", "WHO Region Europe\n", "Name: 152, dtype: object)\n", "(153, Country/Region Somalia\n", "Confirmed 3196\n", "Deaths 93\n", "Recovered 1543\n", "Active 1560\n", "New cases 18\n", "New deaths 0\n", "New recovered 22\n", "Deaths / 100 Cases 2.91\n", "Recovered / 100 Cases 48.28\n", "Deaths / 100 Recovered 6.03\n", "Confirmed last week 3130\n", "1 week change 66\n", "1 week % increase 2.11\n", "WHO Region Eastern Mediterranean\n", "Name: 153, dtype: object)\n", "(154, Country/Region South Africa\n", "Confirmed 452529\n", "Deaths 7067\n", "Recovered 274925\n", "Active 170537\n", "New cases 7096\n", "New deaths 298\n", "New recovered 9848\n", "Deaths / 100 Cases 1.56\n", "Recovered / 100 Cases 60.75\n", "Deaths / 100 Recovered 2.57\n", "Confirmed last week 373628\n", "1 week change 78901\n", "1 week % increase 21.12\n", "WHO Region Africa\n", "Name: 154, dtype: object)\n", "(155, Country/Region South Korea\n", "Confirmed 14203\n", "Deaths 300\n", "Recovered 13007\n", "Active 896\n", "New cases 28\n", "New deaths 1\n", "New recovered 102\n", "Deaths / 100 Cases 2.11\n", "Recovered / 100 Cases 91.58\n", "Deaths / 100 Recovered 2.31\n", "Confirmed last week 13816\n", "1 week change 387\n", "1 week % increase 2.8\n", "WHO Region Western Pacific\n", "Name: 155, dtype: object)\n", "(156, Country/Region South Sudan\n", "Confirmed 2305\n", "Deaths 46\n", "Recovered 1175\n", "Active 1084\n", "New cases 43\n", "New deaths 1\n", "New recovered 0\n", "Deaths / 100 Cases 2.0\n", "Recovered / 100 Cases 50.98\n", "Deaths / 100 Recovered 3.91\n", "Confirmed last week 2211\n", "1 week change 94\n", "1 week % increase 4.25\n", "WHO Region Africa\n", "Name: 156, dtype: object)\n", "(157, Country/Region Spain\n", "Confirmed 272421\n", "Deaths 28432\n", "Recovered 150376\n", "Active 93613\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 10.44\n", "Recovered / 100 Cases 55.2\n", "Deaths / 100 Recovered 18.91\n", "Confirmed last week 264836\n", "1 week change 7585\n", "1 week % increase 2.86\n", "WHO Region Europe\n", "Name: 157, dtype: object)\n", "(158, Country/Region Sri Lanka\n", "Confirmed 2805\n", "Deaths 11\n", "Recovered 2121\n", "Active 673\n", "New cases 23\n", "New deaths 0\n", "New recovered 15\n", "Deaths / 100 Cases 0.39\n", "Recovered / 100 Cases 75.61\n", "Deaths / 100 Recovered 0.52\n", "Confirmed last week 2730\n", "1 week change 75\n", "1 week % increase 2.75\n", "WHO Region South-East Asia\n", "Name: 158, dtype: object)\n", "(159, Country/Region Sudan\n", "Confirmed 11424\n", "Deaths 720\n", "Recovered 5939\n", "Active 4765\n", "New cases 39\n", "New deaths 3\n", "New recovered 49\n", "Deaths / 100 Cases 6.3\n", "Recovered / 100 Cases 51.99\n", "Deaths / 100 Recovered 12.12\n", "Confirmed last week 10992\n", "1 week change 432\n", "1 week % increase 3.93\n", "WHO Region Eastern Mediterranean\n", "Name: 159, dtype: object)\n", "(160, Country/Region Suriname\n", "Confirmed 1483\n", "Deaths 24\n", "Recovered 925\n", "Active 534\n", "New cases 44\n", "New deaths 1\n", "New recovered 35\n", "Deaths / 100 Cases 1.62\n", "Recovered / 100 Cases 62.37\n", "Deaths / 100 Recovered 2.59\n", "Confirmed last week 1079\n", "1 week change 404\n", "1 week % increase 37.44\n", "WHO Region Americas\n", "Name: 160, dtype: object)\n", "(161, Country/Region Sweden\n", "Confirmed 79395\n", "Deaths 5700\n", "Recovered 0\n", "Active 73695\n", "New cases 398\n", "New deaths 3\n", "New recovered 0\n", "Deaths / 100 Cases 7.18\n", "Recovered / 100 Cases 0.0\n", "Deaths / 100 Recovered inf\n", "Confirmed last week 78048\n", "1 week change 1347\n", "1 week % increase 1.73\n", "WHO Region Europe\n", "Name: 161, dtype: object)\n", "(162, Country/Region Switzerland\n", "Confirmed 34477\n", "Deaths 1978\n", "Recovered 30900\n", "Active 1599\n", "New cases 65\n", "New deaths 1\n", "New recovered 200\n", "Deaths / 100 Cases 5.74\n", "Recovered / 100 Cases 89.62\n", "Deaths / 100 Recovered 6.4\n", "Confirmed last week 33634\n", "1 week change 843\n", "1 week % increase 2.51\n", "WHO Region Europe\n", "Name: 162, dtype: object)\n", "(163, Country/Region Syria\n", "Confirmed 674\n", "Deaths 40\n", "Recovered 0\n", "Active 634\n", "New cases 24\n", "New deaths 2\n", "New recovered 0\n", "Deaths / 100 Cases 5.93\n", "Recovered / 100 Cases 0.0\n", "Deaths / 100 Recovered inf\n", "Confirmed last week 522\n", "1 week change 152\n", "1 week % increase 29.12\n", "WHO Region Eastern Mediterranean\n", "Name: 163, dtype: object)\n", "(164, Country/Region Taiwan*\n", "Confirmed 462\n", "Deaths 7\n", "Recovered 440\n", "Active 15\n", "New cases 4\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 1.52\n", "Recovered / 100 Cases 95.24\n", "Deaths / 100 Recovered 1.59\n", "Confirmed last week 451\n", "1 week change 11\n", "1 week % increase 2.44\n", "WHO Region Western Pacific\n", "Name: 164, dtype: object)\n", "(165, Country/Region Tajikistan\n", "Confirmed 7235\n", "Deaths 60\n", "Recovered 6028\n", "Active 1147\n", "New cases 43\n", "New deaths 1\n", "New recovered 58\n", "Deaths / 100 Cases 0.83\n", "Recovered / 100 Cases 83.32\n", "Deaths / 100 Recovered 1.0\n", "Confirmed last week 6921\n", "1 week change 314\n", "1 week % increase 4.54\n", "WHO Region Europe\n", "Name: 165, dtype: object)\n", "(166, Country/Region Tanzania\n", "Confirmed 509\n", "Deaths 21\n", "Recovered 183\n", "Active 305\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 4.13\n", "Recovered / 100 Cases 35.95\n", "Deaths / 100 Recovered 11.48\n", "Confirmed last week 509\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Africa\n", "Name: 166, dtype: object)\n", "(167, Country/Region Thailand\n", "Confirmed 3297\n", "Deaths 58\n", "Recovered 3111\n", "Active 128\n", "New cases 6\n", "New deaths 0\n", "New recovered 2\n", "Deaths / 100 Cases 1.76\n", "Recovered / 100 Cases 94.36\n", "Deaths / 100 Recovered 1.86\n", "Confirmed last week 3250\n", "1 week change 47\n", "1 week % increase 1.45\n", "WHO Region South-East Asia\n", "Name: 167, dtype: object)\n", "(168, Country/Region Timor-Leste\n", "Confirmed 24\n", "Deaths 0\n", "Recovered 0\n", "Active 24\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 0.0\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 24\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region South-East Asia\n", "Name: 168, dtype: object)\n", "(169, Country/Region Togo\n", "Confirmed 874\n", "Deaths 18\n", "Recovered 607\n", "Active 249\n", "New cases 6\n", "New deaths 0\n", "New recovered 8\n", "Deaths / 100 Cases 2.06\n", "Recovered / 100 Cases 69.45\n", "Deaths / 100 Recovered 2.97\n", "Confirmed last week 783\n", "1 week change 91\n", "1 week % increase 11.62\n", "WHO Region Africa\n", "Name: 169, dtype: object)\n", "(170, Country/Region Trinidad and Tobago\n", "Confirmed 148\n", "Deaths 8\n", "Recovered 128\n", "Active 12\n", "New cases 1\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 5.41\n", "Recovered / 100 Cases 86.49\n", "Deaths / 100 Recovered 6.25\n", "Confirmed last week 137\n", "1 week change 11\n", "1 week % increase 8.03\n", "WHO Region Americas\n", "Name: 170, dtype: object)\n", "(171, Country/Region Tunisia\n", "Confirmed 1455\n", "Deaths 50\n", "Recovered 1157\n", "Active 248\n", "New cases 3\n", "New deaths 0\n", "New recovered 15\n", "Deaths / 100 Cases 3.44\n", "Recovered / 100 Cases 79.52\n", "Deaths / 100 Recovered 4.32\n", "Confirmed last week 1381\n", "1 week change 74\n", "1 week % increase 5.36\n", "WHO Region Eastern Mediterranean\n", "Name: 171, dtype: object)\n", "(172, Country/Region Turkey\n", "Confirmed 227019\n", "Deaths 5630\n", "Recovered 210469\n", "Active 10920\n", "New cases 919\n", "New deaths 17\n", "New recovered 982\n", "Deaths / 100 Cases 2.48\n", "Recovered / 100 Cases 92.71\n", "Deaths / 100 Recovered 2.67\n", "Confirmed last week 220572\n", "1 week change 6447\n", "1 week % increase 2.92\n", "WHO Region Europe\n", "Name: 172, dtype: object)\n", "(173, Country/Region US\n", "Confirmed 4290259\n", "Deaths 148011\n", "Recovered 1325804\n", "Active 2816444\n", "New cases 56336\n", "New deaths 1076\n", "New recovered 27941\n", "Deaths / 100 Cases 3.45\n", "Recovered / 100 Cases 30.9\n", "Deaths / 100 Recovered 11.16\n", "Confirmed last week 3834677\n", "1 week change 455582\n", "1 week % increase 11.88\n", "WHO Region Americas\n", "Name: 173, dtype: object)\n", "(174, Country/Region Uganda\n", "Confirmed 1128\n", "Deaths 2\n", "Recovered 986\n", "Active 140\n", "New cases 13\n", "New deaths 0\n", "New recovered 4\n", "Deaths / 100 Cases 0.18\n", "Recovered / 100 Cases 87.41\n", "Deaths / 100 Recovered 0.2\n", "Confirmed last week 1069\n", "1 week change 59\n", "1 week % increase 5.52\n", "WHO Region Africa\n", "Name: 174, dtype: object)\n", "(175, Country/Region Ukraine\n", "Confirmed 67096\n", "Deaths 1636\n", "Recovered 37202\n", "Active 28258\n", "New cases 835\n", "New deaths 11\n", "New recovered 317\n", "Deaths / 100 Cases 2.44\n", "Recovered / 100 Cases 55.45\n", "Deaths / 100 Recovered 4.4\n", "Confirmed last week 60767\n", "1 week change 6329\n", "1 week % increase 10.42\n", "WHO Region Europe\n", "Name: 175, dtype: object)\n", "(176, Country/Region United Arab Emirates\n", "Confirmed 59177\n", "Deaths 345\n", "Recovered 52510\n", "Active 6322\n", "New cases 264\n", "New deaths 1\n", "New recovered 328\n", "Deaths / 100 Cases 0.58\n", "Recovered / 100 Cases 88.73\n", "Deaths / 100 Recovered 0.66\n", "Confirmed last week 57193\n", "1 week change 1984\n", "1 week % increase 3.47\n", "WHO Region Eastern Mediterranean\n", "Name: 176, dtype: object)\n", "(177, Country/Region United Kingdom\n", "Confirmed 301708\n", "Deaths 45844\n", "Recovered 1437\n", "Active 254427\n", "New cases 688\n", "New deaths 7\n", "New recovered 3\n", "Deaths / 100 Cases 15.19\n", "Recovered / 100 Cases 0.48\n", "Deaths / 100 Recovered 3190.26\n", "Confirmed last week 296944\n", "1 week change 4764\n", "1 week % increase 1.6\n", "WHO Region Europe\n", "Name: 177, dtype: object)\n", "(178, Country/Region Uruguay\n", "Confirmed 1202\n", "Deaths 35\n", "Recovered 951\n", "Active 216\n", "New cases 10\n", "New deaths 1\n", "New recovered 3\n", "Deaths / 100 Cases 2.91\n", "Recovered / 100 Cases 79.12\n", "Deaths / 100 Recovered 3.68\n", "Confirmed last week 1064\n", "1 week change 138\n", "1 week % increase 12.97\n", "WHO Region Americas\n", "Name: 178, dtype: object)\n", "(179, Country/Region Uzbekistan\n", "Confirmed 21209\n", "Deaths 121\n", "Recovered 11674\n", "Active 9414\n", "New cases 678\n", "New deaths 5\n", "New recovered 569\n", "Deaths / 100 Cases 0.57\n", "Recovered / 100 Cases 55.04\n", "Deaths / 100 Recovered 1.04\n", "Confirmed last week 17149\n", "1 week change 4060\n", "1 week % increase 23.67\n", "WHO Region Europe\n", "Name: 179, dtype: object)\n", "(180, Country/Region Venezuela\n", "Confirmed 15988\n", "Deaths 146\n", "Recovered 9959\n", "Active 5883\n", "New cases 525\n", "New deaths 4\n", "New recovered 213\n", "Deaths / 100 Cases 0.91\n", "Recovered / 100 Cases 62.29\n", "Deaths / 100 Recovered 1.47\n", "Confirmed last week 12334\n", "1 week change 3654\n", "1 week % increase 29.63\n", "WHO Region Americas\n", "Name: 180, dtype: object)\n", "(181, Country/Region Vietnam\n", "Confirmed 431\n", "Deaths 0\n", "Recovered 365\n", "Active 66\n", "New cases 11\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 0.0\n", "Recovered / 100 Cases 84.69\n", "Deaths / 100 Recovered 0.0\n", "Confirmed last week 384\n", "1 week change 47\n", "1 week % increase 12.24\n", "WHO Region Western Pacific\n", "Name: 181, dtype: object)\n", "(182, Country/Region West Bank and Gaza\n", "Confirmed 10621\n", "Deaths 78\n", "Recovered 3752\n", "Active 6791\n", "New cases 152\n", "New deaths 2\n", "New recovered 0\n", "Deaths / 100 Cases 0.73\n", "Recovered / 100 Cases 35.33\n", "Deaths / 100 Recovered 2.08\n", "Confirmed last week 8916\n", "1 week change 1705\n", "1 week % increase 19.12\n", "WHO Region Eastern Mediterranean\n", "Name: 182, dtype: object)\n", "(183, Country/Region Western Sahara\n", "Confirmed 10\n", "Deaths 1\n", "Recovered 8\n", "Active 1\n", "New cases 0\n", "New deaths 0\n", "New recovered 0\n", "Deaths / 100 Cases 10.0\n", "Recovered / 100 Cases 80.0\n", "Deaths / 100 Recovered 12.5\n", "Confirmed last week 10\n", "1 week change 0\n", "1 week % increase 0.0\n", "WHO Region Africa\n", "Name: 183, dtype: object)\n", "(184, Country/Region Yemen\n", "Confirmed 1691\n", "Deaths 483\n", "Recovered 833\n", "Active 375\n", "New cases 10\n", "New deaths 4\n", "New recovered 36\n", "Deaths / 100 Cases 28.56\n", "Recovered / 100 Cases 49.26\n", "Deaths / 100 Recovered 57.98\n", "Confirmed last week 1619\n", "1 week change 72\n", "1 week % increase 4.45\n", "WHO Region Eastern Mediterranean\n", "Name: 184, dtype: object)\n", "(185, Country/Region Zambia\n", "Confirmed 4552\n", "Deaths 140\n", "Recovered 2815\n", "Active 1597\n", "New cases 71\n", "New deaths 1\n", "New recovered 465\n", "Deaths / 100 Cases 3.08\n", "Recovered / 100 Cases 61.84\n", "Deaths / 100 Recovered 4.97\n", "Confirmed last week 3326\n", "1 week change 1226\n", "1 week % increase 36.86\n", "WHO Region Africa\n", "Name: 185, dtype: object)\n", "(186, Country/Region Zimbabwe\n", "Confirmed 2704\n", "Deaths 36\n", "Recovered 542\n", "Active 2126\n", "New cases 192\n", "New deaths 2\n", "New recovered 24\n", "Deaths / 100 Cases 1.33\n", "Recovered / 100 Cases 20.04\n", "Deaths / 100 Recovered 6.64\n", "Confirmed last week 1713\n", "1 week change 991\n", "1 week % increase 57.85\n", "WHO Region Africa\n", "Name: 186, dtype: object)\n" ] } ] }, { "cell_type": "markdown", "source": [ "***LOC and iLOC***" ], "metadata": { "id": "I0UeKyEKLcUY" } }, { "cell_type": "code", "source": [ "#LOC - accessing rows\n", "df.loc[1]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "Hm2jwgb7LkGP", "outputId": "c7e43c1a-1ba5-400f-ad0b-170602525048" }, "execution_count": 18, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "Country/Region Albania\n", "Confirmed 4880\n", "Deaths 144\n", "Recovered 2745\n", "Active 1991\n", "New cases 117\n", "New deaths 6\n", "New recovered 63\n", "Deaths / 100 Cases 2.95\n", "Recovered / 100 Cases 56.25\n", "Deaths / 100 Recovered 5.25\n", "Confirmed last week 4171\n", "1 week change 709\n", "1 week % increase 17.0\n", "WHO Region Europe\n", "Name: 1, dtype: object" ] }, "metadata": {}, "execution_count": 18 } ] }, { "cell_type": "code", "source": [ "#LOC - Accessing rows and columns\n", "df.loc[1,['New recovered']]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "eeAkORN5MWtP", "outputId": "fa7f0716-4bf9-472f-a34c-ec28a011d162" }, "execution_count": 19, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "New recovered 63\n", "Name: 1, dtype: object" ] }, "metadata": {}, "execution_count": 19 } ] }, { "cell_type": "code", "source": [ "#Disadvantage with LOC - STOP also included\n", "df.loc[0:5]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 333 }, "id": "iNpvAGQdNWQu", "outputId": "69889f5e-4a1a-4ab5-e7c5-95e7728f7034" }, "execution_count": 20, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "0 Afghanistan 36263 1269 25198 9796 106 \n", "1 Albania 4880 144 2745 1991 117 \n", "2 Algeria 27973 1163 18837 7973 616 \n", "3 Andorra 907 52 803 52 10 \n", "4 Angola 950 41 242 667 18 \n", "5 Antigua and Barbuda 86 3 65 18 4 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 10 18 3.50 69.49 \n", "1 6 63 2.95 56.25 \n", "2 8 749 4.16 67.34 \n", "3 0 0 5.73 88.53 \n", "4 1 0 4.32 25.47 \n", "5 0 5 3.49 75.58 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", "5 4.62 76 10 \n", "\n", " 1 week % increase WHO Region \n", "0 2.07 Eastern Mediterranean \n", "1 17.00 Europe \n", "2 18.07 Africa \n", "3 2.60 Europe \n", "4 26.84 Africa \n", "5 13.16 Americas " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean
1Albania4880144274519911176632.9556.255.25417170917.00Europe
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa
3Andorra907528035210005.7388.536.48884232.60Europe
4Angola9504124266718104.3225.4716.9474920126.84Africa
5Antigua and Barbuda86365184053.4975.584.62761013.16Americas
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 20 } ] }, { "cell_type": "code", "source": [ "#Rectify the disadvantage of LOC with iLOC\n", "df.iloc[0:5]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 285 }, "id": "ooo9TVZEN73G", "outputId": "930d467e-6d2f-4b4e-a53d-ae204546f496" }, "execution_count": 21, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases New deaths \\\n", "0 Afghanistan 36263 1269 25198 9796 106 10 \n", "1 Albania 4880 144 2745 1991 117 6 \n", "2 Algeria 27973 1163 18837 7973 616 8 \n", "3 Andorra 907 52 803 52 10 0 \n", "4 Angola 950 41 242 667 18 1 \n", "\n", " New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 18 3.50 69.49 \n", "1 63 2.95 56.25 \n", "2 749 4.16 67.34 \n", "3 0 5.73 88.53 \n", "4 0 4.32 25.47 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", "\n", " 1 week % increase WHO Region \n", "0 2.07 Eastern Mediterranean \n", "1 17.00 Europe \n", "2 18.07 Africa \n", "3 2.60 Europe \n", "4 26.84 Africa " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean
1Albania4880144274519911176632.9556.255.25417170917.00Europe
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa
3Andorra907528035210005.7388.536.48884232.60Europe
4Angola9504124266718104.3225.4716.9474920126.84Africa
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 21 } ] }, { "cell_type": "code", "source": [ "#loc with [start:start,'column name']\n", "\n", "df.loc[0:5,'Deaths']" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "twVAtgazOggH", "outputId": "0ce9ca12-8e6d-4a32-deeb-7a647a9ec226" }, "execution_count": 22, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "0 1269\n", "1 144\n", "2 1163\n", "3 52\n", "4 41\n", "5 3\n", "Name: Deaths, dtype: int64" ] }, "metadata": {}, "execution_count": 22 } ] }, { "cell_type": "code", "source": [ "#Range not only for rows and also for columns\n", "df.loc[0:5,'Deaths':'New recovered']" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 237 }, "id": "_bTgO_b2PpDm", "outputId": "b6d9b30b-d0ce-4eea-c915-8bdbdd950f0c" }, "execution_count": 23, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Deaths Recovered Active New cases New deaths New recovered\n", "0 1269 25198 9796 106 10 18\n", "1 144 2745 1991 117 6 63\n", "2 1163 18837 7973 616 8 749\n", "3 52 803 52 10 0 0\n", "4 41 242 667 18 1 0\n", "5 3 65 18 4 0 5" ], "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", "
DeathsRecoveredActiveNew casesNew deathsNew recovered
012692519897961061018
114427451991117663
211631883779736168749
352803521000
4412426671810
536518405
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 23 } ] }, { "cell_type": "code", "source": [ "#iLoc - Stop index excluded\n", "df.iloc[0:4]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 253 }, "id": "lXcbBO2lP5sw", "outputId": "3496f035-0323-4640-b57a-04b012917f07" }, "execution_count": 24, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases New deaths \\\n", "0 Afghanistan 36263 1269 25198 9796 106 10 \n", "1 Albania 4880 144 2745 1991 117 6 \n", "2 Algeria 27973 1163 18837 7973 616 8 \n", "3 Andorra 907 52 803 52 10 0 \n", "\n", " New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 18 3.50 69.49 \n", "1 63 2.95 56.25 \n", "2 749 4.16 67.34 \n", "3 0 5.73 88.53 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "\n", " 1 week % increase WHO Region \n", "0 2.07 Eastern Mediterranean \n", "1 17.00 Europe \n", "2 18.07 Africa \n", "3 2.60 Europe " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean
1Albania4880144274519911176632.9556.255.25417170917.00Europe
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa
3Andorra907528035210005.7388.536.48884232.60Europe
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 24 } ] }, { "cell_type": "code", "source": [ "#rows and columns ranges with iloc - columns must be accessed with index numbers - with strings not possible\n", "df.iloc[0:4,0:5]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 175 }, "id": "5G5cQ7j0QTvA", "outputId": "52d0b9e3-3c56-45ce-a689-7d9b21e12b1a" }, "execution_count": 25, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active\n", "0 Afghanistan 36263 1269 25198 9796\n", "1 Albania 4880 144 2745 1991\n", "2 Algeria 27973 1163 18837 7973\n", "3 Andorra 907 52 803 52" ], "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", "
Country/RegionConfirmedDeathsRecoveredActive
0Afghanistan362631269251989796
1Albania488014427451991
2Algeria279731163188377973
3Andorra9075280352
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 25 } ] }, { "cell_type": "code", "source": [ "#Accessing specified - row,column\n", "df.iloc[3,4]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "8yzZqAUuRH8o", "outputId": "efdb4b72-d0b2-4c45-f020-41cd6e3ad311" }, "execution_count": 26, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "52" ] }, "metadata": {}, "execution_count": 26 } ] }, { "cell_type": "code", "source": [ "#rows range with particular column\n", "df.iloc[0:5,3]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "WE8Cr0vCRqTv", "outputId": "482ba3a3-c4af-4684-e274-c535bf1e32d3" }, "execution_count": 27, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "0 25198\n", "1 2745\n", "2 18837\n", "3 803\n", "4 242\n", "Name: Recovered, dtype: int64" ] }, "metadata": {}, "execution_count": 27 } ] }, { "cell_type": "code", "source": [ "#Print only rows without range\n", "df.iloc[[1,5,9]]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 222 }, "id": "OLObJO9hSUs9", "outputId": "22598750-2991-4994-e1ce-084d56f65d37" }, "execution_count": 28, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "1 Albania 4880 144 2745 1991 117 \n", "5 Antigua and Barbuda 86 3 65 18 4 \n", "9 Austria 20558 713 18246 1599 86 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "1 6 63 2.95 56.25 \n", "5 0 5 3.49 75.58 \n", "9 1 37 3.47 88.75 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "1 5.25 4171 709 \n", "5 4.62 76 10 \n", "9 3.91 19743 815 \n", "\n", " 1 week % increase WHO Region \n", "1 17.00 Europe \n", "5 13.16 Americas \n", "9 4.13 Europe " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
1Albania4880144274519911176632.9556.255.25417170917.00Europe
5Antigua and Barbuda86365184053.4975.584.62761013.16Americas
9Austria20558713182461599861373.4788.753.91197438154.13Europe
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 28 } ] }, { "cell_type": "code", "source": [ "#start -stop with columns\n", "df.iloc[0:4,2:5]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 175 }, "id": "-xGEHRQ2S3pw", "outputId": "c7bf1db2-4b49-4eae-a9a7-e7c7b69decf5" }, "execution_count": 29, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Deaths Recovered Active\n", "0 1269 25198 9796\n", "1 144 2745 1991\n", "2 1163 18837 7973\n", "3 52 803 52" ], "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", "
DeathsRecoveredActive
01269251989796
114427451991
21163188377973
35280352
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 29 } ] }, { "cell_type": "markdown", "source": [ "***Sorting***" ], "metadata": { "id": "44D7wXjV_AZr" } }, { "cell_type": "code", "source": [ "#sort column with ascending order\n", "df.sort_values('Recovered')" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 502 }, "id": "XAKQMtNC_D-J", "outputId": "1e8ce2ec-64cc-418d-c375-afa02540cf4a" }, "execution_count": 30, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "32 Canada 116458 8944 0 107514 682 \n", "163 Syria 674 40 0 634 24 \n", "147 Serbia 24141 543 0 23598 411 \n", "161 Sweden 79395 5700 0 73695 398 \n", "117 Mozambique 1701 11 0 1690 32 \n", ".. ... ... ... ... ... ... \n", "35 Chile 347923 9187 319954 18782 2133 \n", "138 Russia 816680 13334 602249 201097 5607 \n", "79 India 1480073 33408 951166 495499 44457 \n", "173 US 4290259 148011 1325804 2816444 56336 \n", "23 Brazil 2442375 87618 1846641 508116 23284 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "32 11 0 7.68 0.00 \n", "163 2 0 5.93 0.00 \n", "147 9 0 2.25 0.00 \n", "161 3 0 7.18 0.00 \n", "117 0 0 0.65 0.00 \n", ".. ... ... ... ... \n", "35 75 1859 2.64 91.96 \n", "138 85 3077 1.63 73.74 \n", "79 637 33598 2.26 64.26 \n", "173 1076 27941 3.45 30.90 \n", "23 614 33728 3.59 75.61 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "32 inf 112925 3533 \n", "163 inf 522 152 \n", "147 inf 21253 2888 \n", "161 inf 78048 1347 \n", "117 inf 1507 194 \n", ".. ... ... ... \n", "35 2.87 333029 14894 \n", "138 2.21 776212 40468 \n", "79 3.51 1155338 324735 \n", "173 11.16 3834677 455582 \n", "23 4.74 2118646 323729 \n", "\n", " 1 week % increase WHO Region \n", "32 3.13 Americas \n", "163 29.12 Eastern Mediterranean \n", "147 13.59 Europe \n", "161 1.73 Europe \n", "117 12.87 Africa \n", ".. ... ... \n", "35 4.47 Americas \n", "138 5.21 Europe \n", "79 28.11 South-East Asia \n", "173 11.88 Americas \n", "23 15.28 Americas \n", "\n", "[187 rows x 15 columns]" ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
32Canada116458894401075146821107.680.00inf11292535333.13Americas
163Syria67440063424205.930.00inf52215229.12Eastern Mediterranean
147Serbia24141543023598411902.250.00inf21253288813.59Europe
161Sweden793955700073695398307.180.00inf7804813471.73Europe
117Mozambique1701110169032000.650.00inf150719412.87Africa
................................................
35Chile34792391873199541878221337518592.6491.962.87333029148944.47Americas
138Russia8166801333460224920109756078530771.6373.742.21776212404685.21Europe
79India14800733340895116649549944457637335982.2664.263.51115533832473528.11South-East Asia
173US429025914801113258042816444563361076279413.4530.9011.16383467745558211.88Americas
23Brazil244237587618184664150811623284614337283.5975.614.74211864632372915.28Americas
\n", "

187 rows × 15 columns

\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 30 } ] }, { "cell_type": "code", "source": [ "#sort column with descending order\n", "df.sort_values('Recovered', ascending=False)" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 502 }, "id": "S1lOzA_cABs5", "outputId": "f1c1fe1f-6141-459e-be01-7eafd4ad4376" }, "execution_count": 31, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "23 Brazil 2442375 87618 1846641 508116 23284 \n", "173 US 4290259 148011 1325804 2816444 56336 \n", "79 India 1480073 33408 951166 495499 44457 \n", "138 Russia 816680 13334 602249 201097 5607 \n", "35 Chile 347923 9187 319954 18782 2133 \n", ".. ... ... ... ... ... ... \n", "32 Canada 116458 8944 0 107514 682 \n", "168 Timor-Leste 24 0 0 24 0 \n", "147 Serbia 24141 543 0 23598 411 \n", "163 Syria 674 40 0 634 24 \n", "161 Sweden 79395 5700 0 73695 398 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "23 614 33728 3.59 75.61 \n", "173 1076 27941 3.45 30.90 \n", "79 637 33598 2.26 64.26 \n", "138 85 3077 1.63 73.74 \n", "35 75 1859 2.64 91.96 \n", ".. ... ... ... ... \n", "32 11 0 7.68 0.00 \n", "168 0 0 0.00 0.00 \n", "147 9 0 2.25 0.00 \n", "163 2 0 5.93 0.00 \n", "161 3 0 7.18 0.00 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "23 4.74 2118646 323729 \n", "173 11.16 3834677 455582 \n", "79 3.51 1155338 324735 \n", "138 2.21 776212 40468 \n", "35 2.87 333029 14894 \n", ".. ... ... ... \n", "32 inf 112925 3533 \n", "168 0.00 24 0 \n", "147 inf 21253 2888 \n", "163 inf 522 152 \n", "161 inf 78048 1347 \n", "\n", " 1 week % increase WHO Region \n", "23 15.28 Americas \n", "173 11.88 Americas \n", "79 28.11 South-East Asia \n", "138 5.21 Europe \n", "35 4.47 Americas \n", ".. ... ... \n", "32 3.13 Americas \n", "168 0.00 South-East Asia \n", "147 13.59 Europe \n", "163 29.12 Eastern Mediterranean \n", "161 1.73 Europe \n", "\n", "[187 rows x 15 columns]" ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
23Brazil244237587618184664150811623284614337283.5975.614.74211864632372915.28Americas
173US429025914801113258042816444563361076279413.4530.9011.16383467745558211.88Americas
79India14800733340895116649549944457637335982.2664.263.51115533832473528.11South-East Asia
138Russia8166801333460224920109756078530771.6373.742.21776212404685.21Europe
35Chile34792391873199541878221337518592.6491.962.87333029148944.47Americas
................................................
32Canada116458894401075146821107.680.00inf11292535333.13Americas
168Timor-Leste2400240000.000.000.002400.00South-East Asia
147Serbia24141543023598411902.250.00inf21253288813.59Europe
163Syria67440063424205.930.00inf52215229.12Eastern Mediterranean
161Sweden793955700073695398307.180.00inf7804813471.73Europe
\n", "

187 rows × 15 columns

\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 31 } ] }, { "cell_type": "code", "source": [ "#sort values by comparing two columns, preference will be given to first given column, try ascending=False\n", "df.sort_values(['Country/Region','Active'])" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 537 }, "id": "RzrQh8ovAldX", "outputId": "949210c8-e30e-4cc3-ccb2-187d8d133bcf" }, "execution_count": 32, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "0 Afghanistan 36263 1269 25198 9796 106 \n", "1 Albania 4880 144 2745 1991 117 \n", "2 Algeria 27973 1163 18837 7973 616 \n", "3 Andorra 907 52 803 52 10 \n", "4 Angola 950 41 242 667 18 \n", ".. ... ... ... ... ... ... \n", "182 West Bank and Gaza 10621 78 3752 6791 152 \n", "183 Western Sahara 10 1 8 1 0 \n", "184 Yemen 1691 483 833 375 10 \n", "185 Zambia 4552 140 2815 1597 71 \n", "186 Zimbabwe 2704 36 542 2126 192 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 10 18 3.50 69.49 \n", "1 6 63 2.95 56.25 \n", "2 8 749 4.16 67.34 \n", "3 0 0 5.73 88.53 \n", "4 1 0 4.32 25.47 \n", ".. ... ... ... ... \n", "182 2 0 0.73 35.33 \n", "183 0 0 10.00 80.00 \n", "184 4 36 28.56 49.26 \n", "185 1 465 3.08 61.84 \n", "186 2 24 1.33 20.04 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", ".. ... ... ... \n", "182 2.08 8916 1705 \n", "183 12.50 10 0 \n", "184 57.98 1619 72 \n", "185 4.97 3326 1226 \n", "186 6.64 1713 991 \n", "\n", " 1 week % increase WHO Region \n", "0 2.07 Eastern Mediterranean \n", "1 17.00 Europe \n", "2 18.07 Africa \n", "3 2.60 Europe \n", "4 26.84 Africa \n", ".. ... ... \n", "182 19.12 Eastern Mediterranean \n", "183 0.00 Africa \n", "184 4.45 Eastern Mediterranean \n", "185 36.86 Africa \n", "186 57.85 Africa \n", "\n", "[187 rows x 15 columns]" ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO Region
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean
1Albania4880144274519911176632.9556.255.25417170917.00Europe
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa
3Andorra907528035210005.7388.536.48884232.60Europe
4Angola9504124266718104.3225.4716.9474920126.84Africa
................................................
182West Bank and Gaza106217837526791152200.7335.332.088916170519.12Eastern Mediterranean
183Western Sahara1018100010.0080.0012.501000.00Africa
184Yemen16914838333751043628.5649.2657.981619724.45Eastern Mediterranean
185Zambia4552140281515977114653.0861.844.973326122636.86Africa
186Zimbabwe27043654221261922241.3320.046.64171399157.85Africa
\n", "

187 rows × 15 columns

\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 32 } ] }, { "cell_type": "markdown", "source": [ "***Manupilating***" ], "metadata": { "id": "80BoeoR-EWWq" } }, { "cell_type": "code", "source": [ "#Adding a new column \n", "df['Total deaths'] = 0\n", "df" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 554 }, "id": "i2eh0gFZEa5g", "outputId": "a7851589-9140-4c33-c0fb-913ffdb80d1e" }, "execution_count": 33, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "0 Afghanistan 36263 1269 25198 9796 106 \n", "1 Albania 4880 144 2745 1991 117 \n", "2 Algeria 27973 1163 18837 7973 616 \n", "3 Andorra 907 52 803 52 10 \n", "4 Angola 950 41 242 667 18 \n", ".. ... ... ... ... ... ... \n", "182 West Bank and Gaza 10621 78 3752 6791 152 \n", "183 Western Sahara 10 1 8 1 0 \n", "184 Yemen 1691 483 833 375 10 \n", "185 Zambia 4552 140 2815 1597 71 \n", "186 Zimbabwe 2704 36 542 2126 192 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 10 18 3.50 69.49 \n", "1 6 63 2.95 56.25 \n", "2 8 749 4.16 67.34 \n", "3 0 0 5.73 88.53 \n", "4 1 0 4.32 25.47 \n", ".. ... ... ... ... \n", "182 2 0 0.73 35.33 \n", "183 0 0 10.00 80.00 \n", "184 4 36 28.56 49.26 \n", "185 1 465 3.08 61.84 \n", "186 2 24 1.33 20.04 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", ".. ... ... ... \n", "182 2.08 8916 1705 \n", "183 12.50 10 0 \n", "184 57.98 1619 72 \n", "185 4.97 3326 1226 \n", "186 6.64 1713 991 \n", "\n", " 1 week % increase WHO Region Total deaths \n", "0 2.07 Eastern Mediterranean 0 \n", "1 17.00 Europe 0 \n", "2 18.07 Africa 0 \n", "3 2.60 Europe 0 \n", "4 26.84 Africa 0 \n", ".. ... ... ... \n", "182 19.12 Eastern Mediterranean 0 \n", "183 0.00 Africa 0 \n", "184 4.45 Eastern Mediterranean 0 \n", "185 36.86 Africa 0 \n", "186 57.85 Africa 0 \n", "\n", "[187 rows x 16 columns]" ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO RegionTotal deaths
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean0
1Albania4880144274519911176632.9556.255.25417170917.00Europe0
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa0
3Andorra907528035210005.7388.536.48884232.60Europe0
4Angola9504124266718104.3225.4716.9474920126.84Africa0
...................................................
182West Bank and Gaza106217837526791152200.7335.332.088916170519.12Eastern Mediterranean0
183Western Sahara1018100010.0080.0012.501000.00Africa0
184Yemen16914838333751043628.5649.2657.981619724.45Eastern Mediterranean0
185Zambia4552140281515977114653.0861.844.973326122636.86Africa0
186Zimbabwe27043654221261922241.3320.046.64171399157.85Africa0
\n", "

187 rows × 16 columns

\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 33 } ] }, { "cell_type": "code", "source": [ "#Adding data to new column\n", "df['Total deaths'] = df['Deaths'] + df['New deaths']\n", "df['Total Recovered'] = df['Recovered'] + df['New recovered']\n", "df" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 554 }, "id": "w8xBzlDhFGM4", "outputId": "e9d56806-abd3-4ca4-d618-3250f84ce59f" }, "execution_count": 34, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "0 Afghanistan 36263 1269 25198 9796 106 \n", "1 Albania 4880 144 2745 1991 117 \n", "2 Algeria 27973 1163 18837 7973 616 \n", "3 Andorra 907 52 803 52 10 \n", "4 Angola 950 41 242 667 18 \n", ".. ... ... ... ... ... ... \n", "182 West Bank and Gaza 10621 78 3752 6791 152 \n", "183 Western Sahara 10 1 8 1 0 \n", "184 Yemen 1691 483 833 375 10 \n", "185 Zambia 4552 140 2815 1597 71 \n", "186 Zimbabwe 2704 36 542 2126 192 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 10 18 3.50 69.49 \n", "1 6 63 2.95 56.25 \n", "2 8 749 4.16 67.34 \n", "3 0 0 5.73 88.53 \n", "4 1 0 4.32 25.47 \n", ".. ... ... ... ... \n", "182 2 0 0.73 35.33 \n", "183 0 0 10.00 80.00 \n", "184 4 36 28.56 49.26 \n", "185 1 465 3.08 61.84 \n", "186 2 24 1.33 20.04 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", ".. ... ... ... \n", "182 2.08 8916 1705 \n", "183 12.50 10 0 \n", "184 57.98 1619 72 \n", "185 4.97 3326 1226 \n", "186 6.64 1713 991 \n", "\n", " 1 week % increase WHO Region Total deaths Total Recovered \n", "0 2.07 Eastern Mediterranean 1279 25216 \n", "1 17.00 Europe 150 2808 \n", "2 18.07 Africa 1171 19586 \n", "3 2.60 Europe 52 803 \n", "4 26.84 Africa 42 242 \n", ".. ... ... ... ... \n", "182 19.12 Eastern Mediterranean 80 3752 \n", "183 0.00 Africa 1 8 \n", "184 4.45 Eastern Mediterranean 487 869 \n", "185 36.86 Africa 141 3280 \n", "186 57.85 Africa 38 566 \n", "\n", "[187 rows x 17 columns]" ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO RegionTotal deathsTotal Recovered
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean127925216
1Albania4880144274519911176632.9556.255.25417170917.00Europe1502808
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa117119586
3Andorra907528035210005.7388.536.48884232.60Europe52803
4Angola9504124266718104.3225.4716.9474920126.84Africa42242
......................................................
182West Bank and Gaza106217837526791152200.7335.332.088916170519.12Eastern Mediterranean803752
183Western Sahara1018100010.0080.0012.501000.00Africa18
184Yemen16914838333751043628.5649.2657.981619724.45Eastern Mediterranean487869
185Zambia4552140281515977114653.0861.844.973326122636.86Africa1413280
186Zimbabwe27043654221261922241.3320.046.64171399157.85Africa38566
\n", "

187 rows × 17 columns

\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 34 } ] }, { "cell_type": "code", "source": [ "#Delete a column temporarly\n", "df.drop(columns='Total deaths')" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 554 }, "id": "Ph_6Pw6mGkeh", "outputId": "90d64e09-e721-4afe-da3f-5f258d03d4a7" }, "execution_count": 35, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "0 Afghanistan 36263 1269 25198 9796 106 \n", "1 Albania 4880 144 2745 1991 117 \n", "2 Algeria 27973 1163 18837 7973 616 \n", "3 Andorra 907 52 803 52 10 \n", "4 Angola 950 41 242 667 18 \n", ".. ... ... ... ... ... ... \n", "182 West Bank and Gaza 10621 78 3752 6791 152 \n", "183 Western Sahara 10 1 8 1 0 \n", "184 Yemen 1691 483 833 375 10 \n", "185 Zambia 4552 140 2815 1597 71 \n", "186 Zimbabwe 2704 36 542 2126 192 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 10 18 3.50 69.49 \n", "1 6 63 2.95 56.25 \n", "2 8 749 4.16 67.34 \n", "3 0 0 5.73 88.53 \n", "4 1 0 4.32 25.47 \n", ".. ... ... ... ... \n", "182 2 0 0.73 35.33 \n", "183 0 0 10.00 80.00 \n", "184 4 36 28.56 49.26 \n", "185 1 465 3.08 61.84 \n", "186 2 24 1.33 20.04 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", ".. ... ... ... \n", "182 2.08 8916 1705 \n", "183 12.50 10 0 \n", "184 57.98 1619 72 \n", "185 4.97 3326 1226 \n", "186 6.64 1713 991 \n", "\n", " 1 week % increase WHO Region Total Recovered \n", "0 2.07 Eastern Mediterranean 25216 \n", "1 17.00 Europe 2808 \n", "2 18.07 Africa 19586 \n", "3 2.60 Europe 803 \n", "4 26.84 Africa 242 \n", ".. ... ... ... \n", "182 19.12 Eastern Mediterranean 3752 \n", "183 0.00 Africa 8 \n", "184 4.45 Eastern Mediterranean 869 \n", "185 36.86 Africa 3280 \n", "186 57.85 Africa 566 \n", "\n", "[187 rows x 16 columns]" ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO RegionTotal Recovered
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean25216
1Albania4880144274519911176632.9556.255.25417170917.00Europe2808
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa19586
3Andorra907528035210005.7388.536.48884232.60Europe803
4Angola9504124266718104.3225.4716.9474920126.84Africa242
...................................................
182West Bank and Gaza106217837526791152200.7335.332.088916170519.12Eastern Mediterranean3752
183Western Sahara1018100010.0080.0012.501000.00Africa8
184Yemen16914838333751043628.5649.2657.981619724.45Eastern Mediterranean869
185Zambia4552140281515977114653.0861.844.973326122636.86Africa3280
186Zimbabwe27043654221261922241.3320.046.64171399157.85Africa566
\n", "

187 rows × 16 columns

\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 35 } ] }, { "cell_type": "code", "source": [ "#Delete a column permanently\n", "df.drop(columns='Total deaths',inplace=True)" ], "metadata": { "id": "MUpo984xHozC" }, "execution_count": 36, "outputs": [] }, { "cell_type": "markdown", "source": [ "***Removing duplicates***" ], "metadata": { "id": "wXkuhg0fIyi5" } }, { "cell_type": "code", "source": [ "#Check duplicates\n", "df.duplicated()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "x65EfnyJH2u4", "outputId": "9e2b7948-3e1f-4611-ecb2-4a0d6a408c89" }, "execution_count": 37, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "0 False\n", "1 False\n", "2 False\n", "3 False\n", "4 False\n", " ... \n", "182 False\n", "183 False\n", "184 False\n", "185 False\n", "186 False\n", "Length: 187, dtype: bool" ] }, "metadata": {}, "execution_count": 37 } ] }, { "cell_type": "code", "source": [ "df" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 554 }, "id": "C0h8_g_RI69I", "outputId": "c355ffe2-4877-4851-fd45-545fe7c7c51b" }, "execution_count": 38, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "0 Afghanistan 36263 1269 25198 9796 106 \n", "1 Albania 4880 144 2745 1991 117 \n", "2 Algeria 27973 1163 18837 7973 616 \n", "3 Andorra 907 52 803 52 10 \n", "4 Angola 950 41 242 667 18 \n", ".. ... ... ... ... ... ... \n", "182 West Bank and Gaza 10621 78 3752 6791 152 \n", "183 Western Sahara 10 1 8 1 0 \n", "184 Yemen 1691 483 833 375 10 \n", "185 Zambia 4552 140 2815 1597 71 \n", "186 Zimbabwe 2704 36 542 2126 192 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 10 18 3.50 69.49 \n", "1 6 63 2.95 56.25 \n", "2 8 749 4.16 67.34 \n", "3 0 0 5.73 88.53 \n", "4 1 0 4.32 25.47 \n", ".. ... ... ... ... \n", "182 2 0 0.73 35.33 \n", "183 0 0 10.00 80.00 \n", "184 4 36 28.56 49.26 \n", "185 1 465 3.08 61.84 \n", "186 2 24 1.33 20.04 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", ".. ... ... ... \n", "182 2.08 8916 1705 \n", "183 12.50 10 0 \n", "184 57.98 1619 72 \n", "185 4.97 3326 1226 \n", "186 6.64 1713 991 \n", "\n", " 1 week % increase WHO Region Total Recovered \n", "0 2.07 Eastern Mediterranean 25216 \n", "1 17.00 Europe 2808 \n", "2 18.07 Africa 19586 \n", "3 2.60 Europe 803 \n", "4 26.84 Africa 242 \n", ".. ... ... ... \n", "182 19.12 Eastern Mediterranean 3752 \n", "183 0.00 Africa 8 \n", "184 4.45 Eastern Mediterranean 869 \n", "185 36.86 Africa 3280 \n", "186 57.85 Africa 566 \n", "\n", "[187 rows x 16 columns]" ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO RegionTotal Recovered
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean25216
1Albania4880144274519911176632.9556.255.25417170917.00Europe2808
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa19586
3Andorra907528035210005.7388.536.48884232.60Europe803
4Angola9504124266718104.3225.4716.9474920126.84Africa242
...................................................
182West Bank and Gaza106217837526791152200.7335.332.088916170519.12Eastern Mediterranean3752
183Western Sahara1018100010.0080.0012.501000.00Africa8
184Yemen16914838333751043628.5649.2657.981619724.45Eastern Mediterranean869
185Zambia4552140281515977114653.0861.844.973326122636.86Africa3280
186Zimbabwe27043654221261922241.3320.046.64171399157.85Africa566
\n", "

187 rows × 16 columns

\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 38 } ] }, { "cell_type": "code", "source": [ "#Creating duplicates in new dataset\n", "df_duplicated = pd.concat([df]*2)" ], "metadata": { "id": "XmVpSN2qMKYp" }, "execution_count": 39, "outputs": [] }, { "cell_type": "code", "source": [ "#Now check duplicates\n", "df_duplicated.duplicated()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "vcGn19TmMS92", "outputId": "a7694fbb-f023-49ec-a3f0-ee9d4f53d869" }, "execution_count": 40, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "0 False\n", "1 False\n", "2 False\n", "3 False\n", "4 False\n", " ... \n", "182 True\n", "183 True\n", "184 True\n", "185 True\n", "186 True\n", "Length: 374, dtype: bool" ] }, "metadata": {}, "execution_count": 40 } ] }, { "cell_type": "code", "source": [ "#Deletes duplicates and check for duplications, take of inplace\n", "df_duplicated.drop_duplicates(inplace=True)\n", "df_duplicated.duplicated()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "ze4WpAZYMpgx", "outputId": "de6dcb51-25e3-4dfc-a436-70e8887190f8" }, "execution_count": 41, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "0 False\n", "1 False\n", "2 False\n", "3 False\n", "4 False\n", " ... \n", "182 False\n", "183 False\n", "184 False\n", "185 False\n", "186 False\n", "Length: 187, dtype: bool" ] }, "metadata": {}, "execution_count": 41 } ] }, { "cell_type": "markdown", "source": [ "***Handling Missing Data***" ], "metadata": { "id": "omixXAHHOWZe" } }, { "cell_type": "code", "source": [ "#Creating a dataframe with df2\n", "my_dict = {'First Score':[100, 90, np.nan, 95],\n", " 'Second Score': [30, 45, 56, np.nan],\n", " 'Third Score':[np.nan, 40, 80, 98]}\n", "\n", "df2 = pd.DataFrame(my_dict)\n", "df2" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 175 }, "id": "6B9inu77ObKH", "outputId": "95a710d4-b139-4d6c-d11a-52e229fc8573" }, "execution_count": 42, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " First Score Second Score Third Score\n", "0 100.0 30.0 NaN\n", "1 90.0 45.0 40.0\n", "2 NaN 56.0 80.0\n", "3 95.0 NaN 98.0" ], "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", "
First ScoreSecond ScoreThird Score
0100.030.0NaN
190.045.040.0
2NaN56.080.0
395.0NaN98.0
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 42 } ] }, { "cell_type": "code", "source": [ "#Filling the missing data with default values, we can give int,float, str and True(any)\n", "df2.fillna(40)" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 175 }, "id": "fN2jxx5iPuPn", "outputId": "ce4218c7-02c0-48f8-f9c6-99e9a0e15ca3" }, "execution_count": 43, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " First Score Second Score Third Score\n", "0 100.0 30.0 40.0\n", "1 90.0 45.0 40.0\n", "2 40.0 56.0 80.0\n", "3 95.0 40.0 98.0" ], "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", "
First ScoreSecond ScoreThird Score
0100.030.040.0
190.045.040.0
240.056.080.0
395.040.098.0
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 43 } ] }, { "cell_type": "code", "source": [ "#Fill missing data with slicing\n", "df2['Third Score'].fillna(20)" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "C-ywRWEGQs5r", "outputId": "98c77d4a-ee0c-4c1c-a72a-51ea13ab1af8" }, "execution_count": 44, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "0 20.0\n", "1 40.0\n", "2 80.0\n", "3 98.0\n", "Name: Third Score, dtype: float64" ] }, "metadata": {}, "execution_count": 44 } ] }, { "cell_type": "code", "source": [ "#Drop missing data\n", "df2.dropna()\n" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 81 }, "id": "gAXqZHiZRgMG", "outputId": "42a04ba4-e8bb-4a73-ebfa-6cd88986c8d3" }, "execution_count": 45, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " First Score Second Score Third Score\n", "1 90.0 45.0 40.0" ], "text/html": [ "\n", "
\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
First ScoreSecond ScoreThird Score
190.045.040.0
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 45 } ] }, { "cell_type": "markdown", "source": [ "***Data filtering and conditional changes***" ], "metadata": { "id": "dGOcKUhnIt9l" } }, { "cell_type": "code", "source": [ "#Simple condition\n", "df.loc[df['Active']<50]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 1000 }, "id": "im0AYK6VIzJe", "outputId": "b9aa7db4-3f5b-4a57-bf32-103213033d0e" }, "execution_count": 46, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active \\\n", "5 Antigua and Barbuda 86 3 65 18 \n", "14 Barbados 110 7 94 9 \n", "17 Belize 48 2 26 20 \n", "19 Bhutan 99 0 86 13 \n", "24 Brunei 141 3 138 0 \n", "34 Chad 922 75 810 37 \n", "38 Comoros 354 7 328 19 \n", "48 Djibouti 5059 58 4977 24 \n", "49 Dominica 18 0 18 0 \n", "56 Estonia 2034 69 1923 42 \n", "59 Fiji 27 0 18 9 \n", "68 Greenland 14 0 13 1 \n", "69 Grenada 23 0 23 0 \n", "75 Holy See 12 0 12 0 \n", "78 Iceland 1854 10 1823 21 \n", "94 Laos 20 0 19 1 \n", "100 Liechtenstein 86 1 81 4 \n", "108 Malta 701 9 665 27 \n", "110 Mauritius 344 10 332 2 \n", "113 Monaco 116 4 104 8 \n", "121 New Zealand 1557 22 1514 21 \n", "123 Niger 1132 69 1027 36 \n", "140 Saint Kitts and Nevis 17 0 15 2 \n", "141 Saint Lucia 24 0 22 2 \n", "142 Saint Vincent and the Grenadines 52 0 39 13 \n", "143 San Marino 699 42 657 0 \n", "164 Taiwan* 462 7 440 15 \n", "168 Timor-Leste 24 0 0 24 \n", "170 Trinidad and Tobago 148 8 128 12 \n", "183 Western Sahara 10 1 8 1 \n", "\n", " New cases New deaths New recovered Deaths / 100 Cases \\\n", "5 4 0 5 3.49 \n", "14 0 0 0 6.36 \n", "17 0 0 0 4.17 \n", "19 4 0 1 0.00 \n", "24 0 0 0 2.13 \n", "34 7 0 0 8.13 \n", "38 0 0 0 1.98 \n", "48 9 0 11 1.15 \n", "49 0 0 0 0.00 \n", "56 0 0 1 3.39 \n", "59 0 0 0 0.00 \n", "68 1 0 0 0.00 \n", "69 0 0 0 0.00 \n", "75 0 0 0 0.00 \n", "78 7 0 0 0.54 \n", "94 0 0 0 0.00 \n", "100 0 0 0 1.16 \n", "108 1 0 0 1.28 \n", "110 0 0 0 2.91 \n", "113 0 0 0 3.45 \n", "121 1 0 1 1.41 \n", "123 0 0 0 6.10 \n", "140 0 0 0 0.00 \n", "141 0 0 0 0.00 \n", "142 0 0 0 0.00 \n", "143 0 0 0 6.01 \n", "164 4 0 0 1.52 \n", "168 0 0 0 0.00 \n", "170 1 0 0 5.41 \n", "183 0 0 0 10.00 \n", "\n", " Recovered / 100 Cases Deaths / 100 Recovered Confirmed last week \\\n", "5 75.58 4.62 76 \n", "14 85.45 7.45 106 \n", "17 54.17 7.69 40 \n", "19 86.87 0.00 90 \n", "24 97.87 2.17 141 \n", "34 87.85 9.26 889 \n", "38 92.66 2.13 334 \n", "48 98.38 1.17 5020 \n", "49 100.00 0.00 18 \n", "56 94.54 3.59 2021 \n", "59 66.67 0.00 27 \n", "68 92.86 0.00 13 \n", "69 100.00 0.00 23 \n", "75 100.00 0.00 12 \n", "78 98.33 0.55 1839 \n", "94 95.00 0.00 19 \n", "100 94.19 1.23 86 \n", "108 94.86 1.35 677 \n", "110 96.51 3.01 343 \n", "113 89.66 3.85 109 \n", "121 97.24 1.45 1555 \n", "123 90.72 6.72 1105 \n", "140 88.24 0.00 17 \n", "141 91.67 0.00 23 \n", "142 75.00 0.00 50 \n", "143 93.99 6.39 699 \n", "164 95.24 1.59 451 \n", "168 0.00 0.00 24 \n", "170 86.49 6.25 137 \n", "183 80.00 12.50 10 \n", "\n", " 1 week change 1 week % increase WHO Region Total Recovered \n", "5 10 13.16 Americas 70 \n", "14 4 3.77 Americas 94 \n", "17 8 20.00 Americas 26 \n", "19 9 10.00 South-East Asia 87 \n", "24 0 0.00 Western Pacific 138 \n", "34 33 3.71 Africa 810 \n", "38 20 5.99 Africa 328 \n", "48 39 0.78 Eastern Mediterranean 4988 \n", "49 0 0.00 Americas 18 \n", "56 13 0.64 Europe 1924 \n", "59 0 0.00 Western Pacific 18 \n", "68 1 7.69 Europe 13 \n", "69 0 0.00 Americas 23 \n", "75 0 0.00 Europe 12 \n", "78 15 0.82 Europe 1823 \n", "94 1 5.26 Western Pacific 19 \n", "100 0 0.00 Europe 81 \n", "108 24 3.55 Europe 665 \n", "110 1 0.29 Africa 332 \n", "113 7 6.42 Europe 104 \n", "121 2 0.13 Western Pacific 1515 \n", "123 27 2.44 Africa 1027 \n", "140 0 0.00 Americas 15 \n", "141 1 4.35 Americas 22 \n", "142 2 4.00 Americas 39 \n", "143 0 0.00 Europe 657 \n", "164 11 2.44 Western Pacific 440 \n", "168 0 0.00 South-East Asia 0 \n", "170 11 8.03 Americas 128 \n", "183 0 0.00 Africa 8 " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO RegionTotal Recovered
5Antigua and Barbuda86365184053.4975.584.62761013.16Americas70
14Barbados11079490006.3685.457.4510643.77Americas94
17Belize48226200004.1754.177.6940820.00Americas26
19Bhutan99086134010.0086.870.0090910.00South-East Asia87
24Brunei141313800002.1397.872.1714100.00Western Pacific138
34Chad92275810377008.1387.859.26889333.71Africa810
38Comoros3547328190001.9892.662.13334205.99Africa328
48Djibouti50595849772490111.1598.381.175020390.78Eastern Mediterranean4988
49Dominica1801800000.00100.000.001800.00Americas18
56Estonia2034691923420013.3994.543.592021130.64Europe1924
59Fiji2701890000.0066.670.002700.00Western Pacific18
68Greenland1401311000.0092.860.001317.69Europe13
69Grenada2302300000.00100.000.002300.00Americas23
75Holy See1201200000.00100.000.001200.00Europe12
78Iceland1854101823217000.5498.330.551839150.82Europe1823
94Laos2001910000.0095.000.001915.26Western Pacific19
100Liechtenstein8618140001.1694.191.238600.00Europe81
108Malta7019665271001.2894.861.35677243.55Europe665
110Mauritius3441033220002.9196.513.0134310.29Africa332
113Monaco116410480003.4589.663.8510976.42Europe104
121New Zealand1557221514211011.4197.241.45155520.13Western Pacific1515
123Niger1132691027360006.1090.726.721105272.44Africa1027
140Saint Kitts and Nevis1701520000.0088.240.001700.00Americas15
141Saint Lucia2402220000.0091.670.002314.35Americas22
142Saint Vincent and the Grenadines52039130000.0075.000.005024.00Americas39
143San Marino6994265700006.0193.996.3969900.00Europe657
164Taiwan*4627440154001.5295.241.59451112.44Western Pacific440
168Timor-Leste2400240000.000.000.002400.00South-East Asia0
170Trinidad and Tobago1488128121005.4186.496.25137118.03Americas128
183Western Sahara1018100010.0080.0012.501000.00Africa8
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 46 } ] }, { "cell_type": "code", "source": [ "#Muti-conditional\n", "df.loc[(df['Deaths']>10) & (df['Deaths']<50)]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 1000 }, "id": "6xRcLYzZJ_MV", "outputId": "acbeb959-72cc-49f0-96ab-40b4dee8d58b" }, "execution_count": 47, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "4 Angola 950 41 242 667 18 \n", "11 Bahamas 382 11 91 280 40 \n", "18 Benin 1770 35 1036 699 0 \n", "29 Cabo Verde 2328 22 1550 756 21 \n", "45 Cyprus 1060 19 852 189 3 \n", "57 Eswatini 2316 34 1025 1257 109 \n", "62 Gabon 7189 49 4682 2458 205 \n", "64 Georgia 1137 16 922 199 6 \n", "71 Guinea 7055 45 6257 753 47 \n", "72 Guinea-Bissau 1954 26 803 1125 0 \n", "73 Guyana 389 20 181 188 19 \n", "88 Jordan 1176 11 1041 124 8 \n", "95 Latvia 1219 31 1045 143 0 \n", "97 Lesotho 505 12 128 365 0 \n", "106 Maldives 3369 15 2547 807 67 \n", "115 Montenegro 2893 45 809 2039 94 \n", "117 Mozambique 1701 11 0 1690 32 \n", "119 Nepal 18752 48 13754 4950 139 \n", "121 New Zealand 1557 22 1514 21 1 \n", "131 Paraguay 4548 43 2905 1600 104 \n", "143 San Marino 699 42 657 0 0 \n", "144 Sao Tome and Principe 865 14 734 117 2 \n", "150 Singapore 50838 27 45692 5119 469 \n", "151 Slovakia 2181 28 1616 537 2 \n", "156 South Sudan 2305 46 1175 1084 43 \n", "158 Sri Lanka 2805 11 2121 673 23 \n", "160 Suriname 1483 24 925 534 44 \n", "163 Syria 674 40 0 634 24 \n", "166 Tanzania 509 21 183 305 0 \n", "169 Togo 874 18 607 249 6 \n", "178 Uruguay 1202 35 951 216 10 \n", "186 Zimbabwe 2704 36 542 2126 192 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "4 1 0 4.32 25.47 \n", "11 0 0 2.88 23.82 \n", "18 0 0 1.98 58.53 \n", "29 0 103 0.95 66.58 \n", "45 0 0 1.79 80.38 \n", "57 2 39 1.47 44.26 \n", "62 0 219 0.68 65.13 \n", "64 0 2 1.41 81.09 \n", "71 2 105 0.64 88.69 \n", "72 0 0 1.33 41.10 \n", "73 0 0 5.14 46.53 \n", "88 0 0 0.94 88.52 \n", "95 0 0 2.54 85.73 \n", "97 0 0 2.38 25.35 \n", "106 0 19 0.45 75.60 \n", "115 2 70 1.56 27.96 \n", "117 0 0 0.65 0.00 \n", "119 3 626 0.26 73.35 \n", "121 0 1 1.41 97.24 \n", "131 2 111 0.95 63.87 \n", "143 0 0 6.01 93.99 \n", "144 0 38 1.62 84.86 \n", "150 0 171 0.05 89.88 \n", "151 0 39 1.28 74.09 \n", "156 1 0 2.00 50.98 \n", "158 0 15 0.39 75.61 \n", "160 1 35 1.62 62.37 \n", "163 2 0 5.93 0.00 \n", "166 0 0 4.13 35.95 \n", "169 0 8 2.06 69.45 \n", "178 1 3 2.91 79.12 \n", "186 2 24 1.33 20.04 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "4 16.94 749 201 \n", "11 12.09 174 208 \n", "18 3.38 1602 168 \n", "29 1.42 2071 257 \n", "45 2.23 1038 22 \n", "57 3.32 1826 490 \n", "62 1.05 6433 756 \n", "64 1.74 1039 98 \n", "71 0.72 6590 465 \n", "72 3.24 1949 5 \n", "73 11.05 337 52 \n", "88 1.06 1223 -47 \n", "95 2.97 1192 27 \n", "97 9.38 359 146 \n", "106 0.59 2999 370 \n", "115 5.56 2188 705 \n", "117 inf 1507 194 \n", "119 0.35 17844 908 \n", "121 1.45 1555 2 \n", "131 1.48 3748 800 \n", "143 6.39 699 0 \n", "144 1.91 746 119 \n", "150 0.06 48035 2803 \n", "151 1.73 1980 201 \n", "156 3.91 2211 94 \n", "158 0.52 2730 75 \n", "160 2.59 1079 404 \n", "163 inf 522 152 \n", "166 11.48 509 0 \n", "169 2.97 783 91 \n", "178 3.68 1064 138 \n", "186 6.64 1713 991 \n", "\n", " 1 week % increase WHO Region Total Recovered \n", "4 26.84 Africa 242 \n", "11 119.54 Americas 91 \n", "18 10.49 Africa 1036 \n", "29 12.41 Africa 1653 \n", "45 2.12 Europe 852 \n", "57 26.83 Africa 1064 \n", "62 11.75 Africa 4901 \n", "64 9.43 Europe 924 \n", "71 7.06 Africa 6362 \n", "72 0.26 Africa 803 \n", "73 15.43 Americas 181 \n", "88 -3.84 Eastern Mediterranean 1041 \n", "95 2.27 Europe 1045 \n", "97 40.67 Africa 128 \n", "106 12.34 South-East Asia 2566 \n", "115 32.22 Europe 879 \n", "117 12.87 Africa 0 \n", "119 5.09 South-East Asia 14380 \n", "121 0.13 Western Pacific 1515 \n", "131 21.34 Americas 3016 \n", "143 0.00 Europe 657 \n", "144 15.95 Africa 772 \n", "150 5.84 Western Pacific 45863 \n", "151 10.15 Europe 1655 \n", "156 4.25 Africa 1175 \n", "158 2.75 South-East Asia 2136 \n", "160 37.44 Americas 960 \n", "163 29.12 Eastern Mediterranean 0 \n", "166 0.00 Africa 183 \n", "169 11.62 Africa 615 \n", "178 12.97 Americas 954 \n", "186 57.85 Africa 566 " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO RegionTotal Recovered
4Angola9504124266718104.3225.4716.9474920126.84Africa242
11Bahamas382119128040002.8823.8212.09174208119.54Americas91
18Benin17703510366990001.9858.533.38160216810.49Africa1036
29Cabo Verde23282215507562101030.9566.581.42207125712.41Africa1653
45Cyprus1060198521893001.7980.382.231038222.12Europe852
57Eswatini231634102512571092391.4744.263.32182649026.83Africa1064
62Gabon7189494682245820502190.6865.131.05643375611.75Africa4901
64Georgia1137169221996021.4181.091.741039989.43Europe924
71Guinea70554562577534721050.6488.690.7265904657.06Africa6362
72Guinea-Bissau19542680311250001.3341.103.24194950.26Africa803
73Guyana3892018118819005.1446.5311.053375215.43Americas181
88Jordan11761110411248000.9488.521.061223-47-3.84Eastern Mediterranean1041
95Latvia12193110451430002.5485.732.971192272.27Europe1045
97Lesotho505121283650002.3825.359.3835914640.67Africa128
106Maldives3369152547807670190.4575.600.59299937012.34South-East Asia2566
115Montenegro2893458092039942701.5627.965.56218870532.22Europe879
117Mozambique1701110169032000.650.00inf150719412.87Africa0
119Nepal187524813754495013936260.2673.350.35178449085.09South-East Asia14380
121New Zealand1557221514211011.4197.241.45155520.13Western Pacific1515
131Paraguay4548432905160010421110.9563.871.48374880021.34Americas3016
143San Marino6994265700006.0193.996.3969900.00Europe657
144Sao Tome and Principe8651473411720381.6284.861.9174611915.95Africa772
150Singapore508382745692511946901710.0589.880.064803528035.84Western Pacific45863
151Slovakia218128161653720391.2874.091.73198020110.15Europe1655
156South Sudan2305461175108443102.0050.983.912211944.25Africa1175
158Sri Lanka2805112121673230150.3975.610.522730752.75South-East Asia2136
160Suriname148324925534441351.6262.372.59107940437.44Americas960
163Syria67440063424205.930.00inf52215229.12Eastern Mediterranean0
166Tanzania509211833050004.1335.9511.4850900.00Africa183
169Togo874186072496082.0669.452.977839111.62Africa615
178Uruguay12023595121610132.9179.123.68106413812.97Americas954
186Zimbabwe27043654221261922241.3320.046.64171399157.85Africa566
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 47 } ] }, { "cell_type": "code", "source": [ "#Filtering strings with containing letter\n", "df.loc[df['Country/Region'].str.contains('b')]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 1000 }, "id": "bKPQBf0lJNZA", "outputId": "ca716236-699d-4393-d4e6-b8cbc0bca028" }, "execution_count": 48, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active \\\n", "1 Albania 4880 144 2745 1991 \n", "5 Antigua and Barbuda 86 3 65 18 \n", "10 Azerbaijan 30446 423 23242 6781 \n", "14 Barbados 110 7 94 9 \n", "29 Cabo Verde 2328 22 1550 756 \n", "30 Cambodia 226 0 147 79 \n", "33 Central African Republic 4599 59 1546 2994 \n", "37 Colombia 257101 8777 131161 117163 \n", "44 Cuba 2532 87 2351 94 \n", "48 Djibouti 5059 58 4977 24 \n", "50 Dominican Republic 64156 1083 30204 32869 \n", "62 Gabon 7189 49 4682 2458 \n", "63 Gambia 326 8 66 252 \n", "96 Lebanon 3882 51 1709 2122 \n", "98 Liberia 1167 72 646 449 \n", "99 Libya 2827 64 577 2186 \n", "102 Luxembourg 6321 112 4825 1384 \n", "117 Mozambique 1701 11 0 1690 \n", "118 Namibia 1843 8 101 1734 \n", "145 Saudi Arabia 268934 2760 222936 43238 \n", "147 Serbia 24141 543 0 23598 \n", "170 Trinidad and Tobago 148 8 128 12 \n", "176 United Arab Emirates 59177 345 52510 6322 \n", "179 Uzbekistan 21209 121 11674 9414 \n", "185 Zambia 4552 140 2815 1597 \n", "186 Zimbabwe 2704 36 542 2126 \n", "\n", " New cases New deaths New recovered Deaths / 100 Cases \\\n", "1 117 6 63 2.95 \n", "5 4 0 5 3.49 \n", "10 396 6 558 1.39 \n", "14 0 0 0 6.36 \n", "29 21 0 103 0.95 \n", "30 1 0 4 0.00 \n", "33 0 0 0 1.28 \n", "37 16306 508 11494 3.41 \n", "44 37 0 2 3.44 \n", "48 9 0 11 1.15 \n", "50 1248 20 1601 1.69 \n", "62 205 0 219 0.68 \n", "63 49 2 6 2.45 \n", "96 132 0 17 1.31 \n", "98 5 0 5 6.17 \n", "99 158 4 24 2.26 \n", "102 49 0 178 1.77 \n", "117 32 0 0 0.65 \n", "118 68 0 26 0.43 \n", "145 1993 27 2613 1.03 \n", "147 411 9 0 2.25 \n", "170 1 0 0 5.41 \n", "176 264 1 328 0.58 \n", "179 678 5 569 0.57 \n", "185 71 1 465 3.08 \n", "186 192 2 24 1.33 \n", "\n", " Recovered / 100 Cases Deaths / 100 Recovered Confirmed last week \\\n", "1 56.25 5.25 4171 \n", "5 75.58 4.62 76 \n", "10 76.34 1.82 27890 \n", "14 85.45 7.45 106 \n", "29 66.58 1.42 2071 \n", "30 65.04 0.00 171 \n", "33 33.62 3.82 4548 \n", "37 51.02 6.69 204005 \n", "44 92.85 3.70 2446 \n", "48 98.38 1.17 5020 \n", "50 47.08 3.59 53956 \n", "62 65.13 1.05 6433 \n", "63 20.25 12.12 112 \n", "96 44.02 2.98 2905 \n", "98 55.36 11.15 1107 \n", "99 20.41 11.09 1980 \n", "102 76.33 2.32 5639 \n", "117 0.00 inf 1507 \n", "118 5.48 7.92 1344 \n", "145 82.90 1.24 253349 \n", "147 0.00 inf 21253 \n", "170 86.49 6.25 137 \n", "176 88.73 0.66 57193 \n", "179 55.04 1.04 17149 \n", "185 61.84 4.97 3326 \n", "186 20.04 6.64 1713 \n", "\n", " 1 week change 1 week % increase WHO Region Total Recovered \n", "1 709 17.00 Europe 2808 \n", "5 10 13.16 Americas 70 \n", "10 2556 9.16 Europe 23800 \n", "14 4 3.77 Americas 94 \n", "29 257 12.41 Africa 1653 \n", "30 55 32.16 Western Pacific 151 \n", "33 51 1.12 Africa 1546 \n", "37 53096 26.03 Americas 142655 \n", "44 86 3.52 Americas 2353 \n", "48 39 0.78 Eastern Mediterranean 4988 \n", "50 10200 18.90 Americas 31805 \n", "62 756 11.75 Africa 4901 \n", "63 214 191.07 Africa 72 \n", "96 977 33.63 Eastern Mediterranean 1726 \n", "98 60 5.42 Africa 651 \n", "99 847 42.78 Eastern Mediterranean 601 \n", "102 682 12.09 Europe 5003 \n", "117 194 12.87 Africa 0 \n", "118 499 37.13 Africa 127 \n", "145 15585 6.15 Eastern Mediterranean 225549 \n", "147 2888 13.59 Europe 0 \n", "170 11 8.03 Americas 128 \n", "176 1984 3.47 Eastern Mediterranean 52838 \n", "179 4060 23.67 Europe 12243 \n", "185 1226 36.86 Africa 3280 \n", "186 991 57.85 Africa 566 " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO RegionTotal Recovered
1Albania4880144274519911176632.9556.255.25417170917.00Europe2808
5Antigua and Barbuda86365184053.4975.584.62761013.16Americas70
10Azerbaijan3044642323242678139665581.3976.341.822789025569.16Europe23800
14Barbados11079490006.3685.457.4510643.77Americas94
29Cabo Verde23282215507562101030.9566.581.42207125712.41Africa1653
30Cambodia2260147791040.0065.040.001715532.16Western Pacific151
33Central African Republic459959154629940001.2833.623.824548511.12Africa1546
37Colombia257101877713116111716316306508114943.4151.026.692040055309626.03Americas142655
44Cuba25328723519437023.4492.853.702446863.52Americas2353
48Djibouti50595849772490111.1598.381.175020390.78Eastern Mediterranean4988
50Dominican Republic641561083302043286912482016011.6947.083.59539561020018.90Americas31805
62Gabon7189494682245820502190.6865.131.05643375611.75Africa4901
63Gambia32686625249262.4520.2512.12112214191.07Africa72
96Lebanon388251170921221320171.3144.022.98290597733.63Eastern Mediterranean1726
98Liberia1167726464495056.1755.3611.151107605.42Africa651
99Libya28276457721861584242.2620.4111.09198084742.78Eastern Mediterranean601
102Luxembourg6321112482513844901781.7776.332.32563968212.09Europe5003
117Mozambique1701110169032000.650.00inf150719412.87Africa0
118Namibia184381011734680260.435.487.92134449937.13Africa127
145Saudi Arabia26893427602229364323819932726131.0382.901.24253349155856.15Eastern Mediterranean225549
147Serbia24141543023598411902.250.00inf21253288813.59Europe0
170Trinidad and Tobago1488128121005.4186.496.25137118.03Americas128
176United Arab Emirates5917734552510632226413280.5888.730.665719319843.47Eastern Mediterranean52838
179Uzbekistan2120912111674941467855690.5755.041.0417149406023.67Europe12243
185Zambia4552140281515977114653.0861.844.973326122636.86Africa3280
186Zimbabwe27043654221261922241.3320.046.64171399157.85Africa566
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 48 } ] }, { "cell_type": "code", "source": [ "#Filtering strigs with starting letters\n", "df.loc[df['Country/Region'].str.startswith('I')]" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 414 }, "id": "rBimAhN9SS5s", "outputId": "f6744f81-d9eb-461c-bea8-9fd1e6a8c21b" }, "execution_count": 49, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "78 Iceland 1854 10 1823 21 7 \n", "79 India 1480073 33408 951166 495499 44457 \n", "80 Indonesia 100303 4838 58173 37292 1525 \n", "81 Iran 293606 15912 255144 22550 2434 \n", "82 Iraq 112585 4458 77144 30983 2553 \n", "83 Ireland 25892 1764 23364 764 11 \n", "84 Israel 63985 474 27133 36378 2029 \n", "85 Italy 246286 35112 198593 12581 168 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "78 0 0 0.54 98.33 \n", "79 637 33598 2.26 64.26 \n", "80 57 1518 4.82 58.00 \n", "81 212 1931 5.42 86.90 \n", "82 96 1927 3.96 68.52 \n", "83 0 0 6.81 90.24 \n", "84 4 108 0.74 42.41 \n", "85 5 147 14.26 80.64 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "78 0.55 1839 15 \n", "79 3.51 1155338 324735 \n", "80 8.32 88214 12089 \n", "81 6.24 276202 17404 \n", "82 5.78 94693 17892 \n", "83 7.55 25766 126 \n", "84 1.75 52003 11982 \n", "85 17.68 244624 1662 \n", "\n", " 1 week % increase WHO Region Total Recovered \n", "78 0.82 Europe 1823 \n", "79 28.11 South-East Asia 984764 \n", "80 13.70 South-East Asia 59691 \n", "81 6.30 Eastern Mediterranean 257075 \n", "82 18.89 Eastern Mediterranean 79071 \n", "83 0.49 Europe 23364 \n", "84 23.04 Europe 27241 \n", "85 0.68 Europe 198740 " ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO RegionTotal Recovered
78Iceland1854101823217000.5498.330.551839150.82Europe1823
79India14800733340895116649549944457637335982.2664.263.51115533832473528.11South-East Asia984764
80Indonesia1003034838581733729215255715184.8258.008.32882141208913.70South-East Asia59691
81Iran2936061591225514422550243421219315.4286.906.24276202174046.30Eastern Mediterranean257075
82Iraq1125854458771443098325539619273.9668.525.78946931789218.89Eastern Mediterranean79071
83Ireland2589217642336476411006.8190.247.55257661260.49Europe23364
84Israel639854742713336378202941080.7442.411.75520031198223.04Europe27241
85Italy2462863511219859312581168514714.2680.6417.6824462416620.68Europe198740
\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 49 } ] }, { "cell_type": "code", "source": [ "#Recomending safe to travel regions with multi conditions\n", "\n", "df['safe to travel']=0\n", "df.loc[df['New cases']<20,['safe to travel']]='yes'\n", "df.loc[(df['New cases']>=20) & (df['New cases']<40), ['safe to travel']]='under observation'\n", "df.loc[df['New cases']>40,['safe to travel']]='no'\n" ], "metadata": { "id": "BBfIzFelTEnD" }, "execution_count": 50, "outputs": [] }, { "cell_type": "code", "source": [ "df\n" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 554 }, "id": "SaM9Qy4nUJcJ", "outputId": "19bd9cd9-e444-406e-bfee-1a7d90825730" }, "execution_count": 51, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Country/Region Confirmed Deaths Recovered Active New cases \\\n", "0 Afghanistan 36263 1269 25198 9796 106 \n", "1 Albania 4880 144 2745 1991 117 \n", "2 Algeria 27973 1163 18837 7973 616 \n", "3 Andorra 907 52 803 52 10 \n", "4 Angola 950 41 242 667 18 \n", ".. ... ... ... ... ... ... \n", "182 West Bank and Gaza 10621 78 3752 6791 152 \n", "183 Western Sahara 10 1 8 1 0 \n", "184 Yemen 1691 483 833 375 10 \n", "185 Zambia 4552 140 2815 1597 71 \n", "186 Zimbabwe 2704 36 542 2126 192 \n", "\n", " New deaths New recovered Deaths / 100 Cases Recovered / 100 Cases \\\n", "0 10 18 3.50 69.49 \n", "1 6 63 2.95 56.25 \n", "2 8 749 4.16 67.34 \n", "3 0 0 5.73 88.53 \n", "4 1 0 4.32 25.47 \n", ".. ... ... ... ... \n", "182 2 0 0.73 35.33 \n", "183 0 0 10.00 80.00 \n", "184 4 36 28.56 49.26 \n", "185 1 465 3.08 61.84 \n", "186 2 24 1.33 20.04 \n", "\n", " Deaths / 100 Recovered Confirmed last week 1 week change \\\n", "0 5.04 35526 737 \n", "1 5.25 4171 709 \n", "2 6.17 23691 4282 \n", "3 6.48 884 23 \n", "4 16.94 749 201 \n", ".. ... ... ... \n", "182 2.08 8916 1705 \n", "183 12.50 10 0 \n", "184 57.98 1619 72 \n", "185 4.97 3326 1226 \n", "186 6.64 1713 991 \n", "\n", " 1 week % increase WHO Region Total Recovered safe to travel \n", "0 2.07 Eastern Mediterranean 25216 no \n", "1 17.00 Europe 2808 no \n", "2 18.07 Africa 19586 no \n", "3 2.60 Europe 803 yes \n", "4 26.84 Africa 242 yes \n", ".. ... ... ... ... \n", "182 19.12 Eastern Mediterranean 3752 no \n", "183 0.00 Africa 8 yes \n", "184 4.45 Eastern Mediterranean 869 yes \n", "185 36.86 Africa 3280 no \n", "186 57.85 Africa 566 no \n", "\n", "[187 rows x 17 columns]" ], "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", "
Country/RegionConfirmedDeathsRecoveredActiveNew casesNew deathsNew recoveredDeaths / 100 CasesRecovered / 100 CasesDeaths / 100 RecoveredConfirmed last week1 week change1 week % increaseWHO RegionTotal Recoveredsafe to travel
0Afghanistan36263126925198979610610183.5069.495.04355267372.07Eastern Mediterranean25216no
1Albania4880144274519911176632.9556.255.25417170917.00Europe2808no
2Algeria27973116318837797361687494.1667.346.1723691428218.07Africa19586no
3Andorra907528035210005.7388.536.48884232.60Europe803yes
4Angola9504124266718104.3225.4716.9474920126.84Africa242yes
......................................................
182West Bank and Gaza106217837526791152200.7335.332.088916170519.12Eastern Mediterranean3752no
183Western Sahara1018100010.0080.0012.501000.00Africa8yes
184Yemen16914838333751043628.5649.2657.981619724.45Eastern Mediterranean869yes
185Zambia4552140281515977114653.0861.844.973326122636.86Africa3280no
186Zimbabwe27043654221261922241.3320.046.64171399157.85Africa566no
\n", "

187 rows × 17 columns

\n", "
\n", " \n", " \n", " \n", "\n", " \n", "
\n", "
\n", " " ] }, "metadata": {}, "execution_count": 51 } ] }, { "cell_type": "markdown", "source": [ "***Saving data frame to csv***" ], "metadata": { "id": "b-XPZHMxKJYI" } }, { "cell_type": "code", "source": [ "df.to_csv('new.csv')" ], "metadata": { "id": "JI97UWrsKScn" }, "execution_count": 54, "outputs": [] }, { "cell_type": "code", "source": [ "ls" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "zMWaLWk3LCZu", "outputId": "f9af6111-f51f-4c17-d977-8e1e95578451" }, "execution_count": 55, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "new new.csv \u001b[0m\u001b[01;34msample_data\u001b[0m/\n" ] } ] } ] }