COVID19 Africa!.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# COVID-19 DATASET"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### imports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [],
   "source": [
    "data =  pd.read_csv('covid_19_africa.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ObservationDate</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Confirmed</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Recovered</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-27</td>\n",
       "      <td>Ivory Coast</td>\n",
       "      <td>Western Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-02-14</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-02-15</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-02-16</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-02-17</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  ObservationDate      Country           Region  Confirmed  Deaths  Recovered  \\\n",
       "0      2020-01-27  Ivory Coast   Western Africa          1       0          0   \n",
       "1      2020-02-14        Egypt  Northern Africa          1       0          0   \n",
       "2      2020-02-15        Egypt  Northern Africa          1       0          0   \n",
       "3      2020-02-16        Egypt  Northern Africa          1       0          0   \n",
       "4      2020-02-17        Egypt  Northern Africa          1       0          0   \n",
       "\n",
       "   Active  \n",
       "0       1  \n",
       "1       1  \n",
       "2       1  \n",
       "3       1  \n",
       "4       1  "
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3737, 7)"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ObservationDate', 'Country', 'Region', 'Confirmed', 'Deaths',\n",
       "       'Recovered', 'Active'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3737 entries, 0 to 3736\n",
      "Data columns (total 7 columns):\n",
      " #   Column           Non-Null Count  Dtype \n",
      "---  ------           --------------  ----- \n",
      " 0   ObservationDate  3737 non-null   object\n",
      " 1   Country          3737 non-null   object\n",
      " 2   Region           3737 non-null   object\n",
      " 3   Confirmed        3737 non-null   int64 \n",
      " 4   Deaths           3737 non-null   int64 \n",
      " 5   Recovered        3737 non-null   int64 \n",
      " 6   Active           3737 non-null   int64 \n",
      "dtypes: int64(4), object(3)\n",
      "memory usage: 204.5+ KB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObservationDate    object\n",
       "Country            object\n",
       "Region             object\n",
       "Confirmed           int64\n",
       "Deaths              int64\n",
       "Recovered           int64\n",
       "Active              int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObservationDate    0\n",
       "Country            0\n",
       "Region             0\n",
       "Confirmed          0\n",
       "Deaths             0\n",
       "Recovered          0\n",
       "Active             0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "92093"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Deaths'].sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Find out All Statistics by Region"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#First Find out all the Regions Available in our Dataset\n",
    "data['Region'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObservationDate    2020-01-272020-02-282020-02-292020-03-012020-0...\n",
       "Country            Ivory CoastNigeriaNigeriaNigeriaNigeriaSenegal...\n",
       "Region             Western AfricaWestern AfricaWestern AfricaWest...\n",
       "Confirmed                                                     664118\n",
       "Deaths                                                         14941\n",
       "Recovered                                                     214362\n",
       "Active                                                        434815\n",
       "dtype: object"
      ]
     },
     "execution_count": 139,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Region'] == 'Western Africa'].sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Western Africa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObservationDate    2020-03-182020-03-192020-03-202020-03-212020-0...\n",
       "Country            Burkina FasoBurkina FasoBurkina FasoGhanaGhana...\n",
       "Region             Western AfricaWestern AfricaWestern AfricaWest...\n",
       "Confirmed                                                     328983\n",
       "Deaths                                                          7267\n",
       "Recovered                                                     108566\n",
       "Active                                                        213150\n",
       "dtype: object"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Filtering\n",
    "data[data['Deaths'] & (data['Region'] == 'Western Africa')].sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Northen Africa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObservationDate    2020-03-082020-03-092020-03-102020-03-102020-0...\n",
       "Country            EgyptEgyptEgyptMoroccoEgyptMoroccoEgyptAlgeria...\n",
       "Region             Northern AfricaNorthern AfricaNorthern AfricaN...\n",
       "Confirmed                                                     443354\n",
       "Deaths                                                         27491\n",
       "Recovered                                                     138143\n",
       "Active                                                        277720\n",
       "dtype: object"
      ]
     },
     "execution_count": 141,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Deaths'] & (data['Region'] == 'Northern Africa')].sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Eastern Africa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObservationDate    2020-03-212020-03-232020-03-242020-03-252020-0...\n",
       "Country            MauritiusZimbabweZimbabweZimbabweKenyaZimbabwe...\n",
       "Region             Eastern AfricaEastern AfricaEastern AfricaEast...\n",
       "Confirmed                                                      86177\n",
       "Deaths                                                          2354\n",
       "Recovered                                                      29444\n",
       "Active                                                         54379\n",
       "dtype: object"
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Deaths'] & (data['Region'] == 'Eastern Africa')].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObservationDate    2020-03-272020-03-282020-03-302020-03-312020-0...\n",
       "Country            South AfricaSouth AfricaSouth AfricaBotswanaSo...\n",
       "Region             Southern AfricaSouthern AfricaSouthern AfricaS...\n",
       "Confirmed                                                     251831\n",
       "Deaths                                                          4564\n",
       "Recovered                                                     104328\n",
       "Active                                                        142939\n",
       "dtype: object"
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Deaths'] & (data['Region'] == 'Southern Africa')].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ObservationDate    2020-03-202020-03-212020-03-212020-03-222020-0...\n",
       "Country            GabonCongo (Kinshasa)GabonCongo (Kinshasa)Gabo...\n",
       "Region             Central AfricaCentral AfricaCentral AfricaCent...\n",
       "Confirmed                                                     107613\n",
       "Deaths                                                          3635\n",
       "Recovered                                                      26834\n",
       "Active                                                         77144\n",
       "dtype: object"
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "data[data['Deaths'] & (data['Region'] == 'Central Africa')].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [],
   "source": [
    "#data['ObservationDate'] = data({'ObservationDate': ['2020-01-01', '2020-01-02', '2020-01-31']\n",
    "#data.to_datetime(data['ObservationDate']\n",
    "#data[data['ObservationDate'].dt.month == 5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ObservationDate</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Confirmed</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Recovered</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3732</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Togo</td>\n",
       "      <td>Western Africa</td>\n",
       "      <td>386</td>\n",
       "      <td>13</td>\n",
       "      <td>161</td>\n",
       "      <td>212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3733</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>1051</td>\n",
       "      <td>48</td>\n",
       "      <td>919</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3734</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>222</td>\n",
       "      <td>0</td>\n",
       "      <td>69</td>\n",
       "      <td>153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3735</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>920</td>\n",
       "      <td>7</td>\n",
       "      <td>336</td>\n",
       "      <td>577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3736</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>56</td>\n",
       "      <td>4</td>\n",
       "      <td>25</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ObservationDate   Country           Region  Confirmed  Deaths  Recovered  \\\n",
       "3732      2020-05-25      Togo   Western Africa        386      13        161   \n",
       "3733      2020-05-25   Tunisia  Northern Africa       1051      48        919   \n",
       "3734      2020-05-25    Uganda   Eastern Africa        222       0         69   \n",
       "3735      2020-05-25    Zambia   Eastern Africa        920       7        336   \n",
       "3736      2020-05-25  Zimbabwe   Eastern Africa         56       4         25   \n",
       "\n",
       "      Active  \n",
       "3732     212  \n",
       "3733      84  \n",
       "3734     153  \n",
       "3735     577  \n",
       "3736      27  "
      ]
     },
     "execution_count": 146,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "223.76103826598876"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Recovered'].mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Find Out All instances when the death cases greater than 50"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ObservationDate</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Confirmed</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Recovered</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>848</th>\n",
       "      <td>2020-04-01</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>847</td>\n",
       "      <td>58</td>\n",
       "      <td>61</td>\n",
       "      <td>728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>861</th>\n",
       "      <td>2020-04-01</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>779</td>\n",
       "      <td>52</td>\n",
       "      <td>179</td>\n",
       "      <td>548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>2020-04-02</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>986</td>\n",
       "      <td>86</td>\n",
       "      <td>61</td>\n",
       "      <td>839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>2020-04-02</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>865</td>\n",
       "      <td>58</td>\n",
       "      <td>201</td>\n",
       "      <td>606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947</th>\n",
       "      <td>2020-04-03</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>1171</td>\n",
       "      <td>105</td>\n",
       "      <td>62</td>\n",
       "      <td>1004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3720</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Niger</td>\n",
       "      <td>Western Africa</td>\n",
       "      <td>951</td>\n",
       "      <td>62</td>\n",
       "      <td>786</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3721</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>Western Africa</td>\n",
       "      <td>8068</td>\n",
       "      <td>233</td>\n",
       "      <td>2311</td>\n",
       "      <td>5524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3727</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Somalia</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>1689</td>\n",
       "      <td>66</td>\n",
       "      <td>235</td>\n",
       "      <td>1388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3728</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Southern Africa</td>\n",
       "      <td>23615</td>\n",
       "      <td>481</td>\n",
       "      <td>11917</td>\n",
       "      <td>11217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3730</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Sudan</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>3976</td>\n",
       "      <td>170</td>\n",
       "      <td>503</td>\n",
       "      <td>3303</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>348 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ObservationDate       Country           Region  Confirmed  Deaths  \\\n",
       "848       2020-04-01       Algeria  Northern Africa        847      58   \n",
       "861       2020-04-01         Egypt  Northern Africa        779      52   \n",
       "897       2020-04-02       Algeria  Northern Africa        986      86   \n",
       "910       2020-04-02         Egypt  Northern Africa        865      58   \n",
       "947       2020-04-03       Algeria  Northern Africa       1171     105   \n",
       "...              ...           ...              ...        ...     ...   \n",
       "3720      2020-05-25         Niger   Western Africa        951      62   \n",
       "3721      2020-05-25       Nigeria   Western Africa       8068     233   \n",
       "3727      2020-05-25       Somalia   Eastern Africa       1689      66   \n",
       "3728      2020-05-25  South Africa  Southern Africa      23615     481   \n",
       "3730      2020-05-25         Sudan  Northern Africa       3976     170   \n",
       "\n",
       "      Recovered  Active  \n",
       "848          61     728  \n",
       "861         179     548  \n",
       "897          61     839  \n",
       "910         201     606  \n",
       "947          62    1004  \n",
       "...         ...     ...  \n",
       "3720        786     103  \n",
       "3721       2311    5524  \n",
       "3727        235    1388  \n",
       "3728      11917   11217  \n",
       "3730        503    3303  \n",
       "\n",
       "[348 rows x 7 columns]"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Deaths'] > 50]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Display all Stats Related to Uganda"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ObservationDate</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Confirmed</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Recovered</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-27</td>\n",
       "      <td>Ivory Coast</td>\n",
       "      <td>Western Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-02-14</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  ObservationDate      Country           Region  Confirmed  Deaths  Recovered  \\\n",
       "0      2020-01-27  Ivory Coast   Western Africa          1       0          0   \n",
       "1      2020-02-14        Egypt  Northern Africa          1       0          0   \n",
       "\n",
       "   Active  \n",
       "0       1  \n",
       "1       1  "
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ObservationDate</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Confirmed</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Recovered</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>2020-03-21</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>2020-03-22</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>2020-03-23</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>2020-03-24</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>565</th>\n",
       "      <td>2020-03-25</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3518</th>\n",
       "      <td>2020-05-21</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>160</td>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3572</th>\n",
       "      <td>2020-05-22</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>175</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3626</th>\n",
       "      <td>2020-05-23</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>198</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3680</th>\n",
       "      <td>2020-05-24</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>198</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3734</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>222</td>\n",
       "      <td>0</td>\n",
       "      <td>69</td>\n",
       "      <td>153</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>66 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ObservationDate Country          Region  Confirmed  Deaths  Recovered  \\\n",
       "391       2020-03-21  Uganda  Eastern Africa          1       0          0   \n",
       "432       2020-03-22  Uganda  Eastern Africa          1       0          0   \n",
       "475       2020-03-23  Uganda  Eastern Africa          9       0          0   \n",
       "519       2020-03-24  Uganda  Eastern Africa          9       0          0   \n",
       "565       2020-03-25  Uganda  Eastern Africa         14       0          0   \n",
       "...              ...     ...             ...        ...     ...        ...   \n",
       "3518      2020-05-21  Uganda  Eastern Africa        160       0         66   \n",
       "3572      2020-05-22  Uganda  Eastern Africa        175       0         68   \n",
       "3626      2020-05-23  Uganda  Eastern Africa        198       0         68   \n",
       "3680      2020-05-24  Uganda  Eastern Africa        198       0         68   \n",
       "3734      2020-05-25  Uganda  Eastern Africa        222       0         69   \n",
       "\n",
       "      Active  \n",
       "391        1  \n",
       "432        1  \n",
       "475        9  \n",
       "519        9  \n",
       "565       14  \n",
       "...      ...  \n",
       "3518      94  \n",
       "3572     107  \n",
       "3626     130  \n",
       "3680     130  \n",
       "3734     153  \n",
       "\n",
       "[66 rows x 7 columns]"
      ]
     },
     "execution_count": 150,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Country'] == 'Uganda']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Find Out the Sum of all Confirmed, Deaths, Recoveries and Active Cases against each Country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Confirmed</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Recovered</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>231373</td>\n",
       "      <td>22615</td>\n",
       "      <td>102427</td>\n",
       "      <td>106331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>1822</td>\n",
       "      <td>127</td>\n",
       "      <td>488</td>\n",
       "      <td>1207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Benin</th>\n",
       "      <td>6504</td>\n",
       "      <td>80</td>\n",
       "      <td>2127</td>\n",
       "      <td>4297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Botswana</th>\n",
       "      <td>1077</td>\n",
       "      <td>56</td>\n",
       "      <td>360</td>\n",
       "      <td>661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Burkina Faso</th>\n",
       "      <td>36079</td>\n",
       "      <td>2245</td>\n",
       "      <td>23036</td>\n",
       "      <td>10798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Burundi</th>\n",
       "      <td>780</td>\n",
       "      <td>43</td>\n",
       "      <td>328</td>\n",
       "      <td>409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cabo Verde</th>\n",
       "      <td>8377</td>\n",
       "      <td>97</td>\n",
       "      <td>1781</td>\n",
       "      <td>6499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cameroon</th>\n",
       "      <td>107516</td>\n",
       "      <td>3887</td>\n",
       "      <td>44418</td>\n",
       "      <td>59211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Central African Republic</th>\n",
       "      <td>6849</td>\n",
       "      <td>3</td>\n",
       "      <td>457</td>\n",
       "      <td>6389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chad</th>\n",
       "      <td>10446</td>\n",
       "      <td>968</td>\n",
       "      <td>2726</td>\n",
       "      <td>6752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comoros</th>\n",
       "      <td>557</td>\n",
       "      <td>20</td>\n",
       "      <td>112</td>\n",
       "      <td>425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Congo (Brazzaville)</th>\n",
       "      <td>12239</td>\n",
       "      <td>472</td>\n",
       "      <td>2178</td>\n",
       "      <td>9589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Congo (Kinshasa)</th>\n",
       "      <td>41031</td>\n",
       "      <td>1913</td>\n",
       "      <td>5574</td>\n",
       "      <td>33544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Djibouti</th>\n",
       "      <td>53121</td>\n",
       "      <td>167</td>\n",
       "      <td>27082</td>\n",
       "      <td>25872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Egypt</th>\n",
       "      <td>364804</td>\n",
       "      <td>20693</td>\n",
       "      <td>92059</td>\n",
       "      <td>252052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Equatorial Guinea</th>\n",
       "      <td>17792</td>\n",
       "      <td>156</td>\n",
       "      <td>1125</td>\n",
       "      <td>16511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Eritrea</th>\n",
       "      <td>2067</td>\n",
       "      <td>0</td>\n",
       "      <td>1027</td>\n",
       "      <td>1040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Eswatini</th>\n",
       "      <td>5396</td>\n",
       "      <td>60</td>\n",
       "      <td>1631</td>\n",
       "      <td>3705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ethiopia</th>\n",
       "      <td>10068</td>\n",
       "      <td>186</td>\n",
       "      <td>3244</td>\n",
       "      <td>6638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gabon</th>\n",
       "      <td>29166</td>\n",
       "      <td>286</td>\n",
       "      <td>5920</td>\n",
       "      <td>22960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gambia</th>\n",
       "      <td>793</td>\n",
       "      <td>64</td>\n",
       "      <td>373</td>\n",
       "      <td>356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ghana</th>\n",
       "      <td>144581</td>\n",
       "      <td>905</td>\n",
       "      <td>27668</td>\n",
       "      <td>116008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Guinea</th>\n",
       "      <td>75731</td>\n",
       "      <td>426</td>\n",
       "      <td>27056</td>\n",
       "      <td>48249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Guinea-Bissau</th>\n",
       "      <td>21128</td>\n",
       "      <td>92</td>\n",
       "      <td>832</td>\n",
       "      <td>20204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ivory Coast</th>\n",
       "      <td>68998</td>\n",
       "      <td>810</td>\n",
       "      <td>28901</td>\n",
       "      <td>39287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kenya</th>\n",
       "      <td>27374</td>\n",
       "      <td>1263</td>\n",
       "      <td>8423</td>\n",
       "      <td>17688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lesotho</th>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Liberia</th>\n",
       "      <td>7353</td>\n",
       "      <td>728</td>\n",
       "      <td>2790</td>\n",
       "      <td>3835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Libya</th>\n",
       "      <td>2868</td>\n",
       "      <td>113</td>\n",
       "      <td>1028</td>\n",
       "      <td>1727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Madagascar</th>\n",
       "      <td>10128</td>\n",
       "      <td>16</td>\n",
       "      <td>3829</td>\n",
       "      <td>6283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Malawi</th>\n",
       "      <td>2034</td>\n",
       "      <td>130</td>\n",
       "      <td>567</td>\n",
       "      <td>1337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mali</th>\n",
       "      <td>25362</td>\n",
       "      <td>1493</td>\n",
       "      <td>11484</td>\n",
       "      <td>12385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mauritania</th>\n",
       "      <td>1965</td>\n",
       "      <td>103</td>\n",
       "      <td>292</td>\n",
       "      <td>1570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mauritius</th>\n",
       "      <td>18059</td>\n",
       "      <td>531</td>\n",
       "      <td>11999</td>\n",
       "      <td>5529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Morocco</th>\n",
       "      <td>232841</td>\n",
       "      <td>8506</td>\n",
       "      <td>85757</td>\n",
       "      <td>138578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mozambique</th>\n",
       "      <td>4094</td>\n",
       "      <td>1</td>\n",
       "      <td>1046</td>\n",
       "      <td>3047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Namibia</th>\n",
       "      <td>988</td>\n",
       "      <td>0</td>\n",
       "      <td>440</td>\n",
       "      <td>548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Niger</th>\n",
       "      <td>36459</td>\n",
       "      <td>1736</td>\n",
       "      <td>20613</td>\n",
       "      <td>14110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nigeria</th>\n",
       "      <td>145906</td>\n",
       "      <td>4477</td>\n",
       "      <td>33792</td>\n",
       "      <td>107637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rwanda</th>\n",
       "      <td>12066</td>\n",
       "      <td>0</td>\n",
       "      <td>5727</td>\n",
       "      <td>6339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sao Tome and Principe</th>\n",
       "      <td>4975</td>\n",
       "      <td>141</td>\n",
       "      <td>112</td>\n",
       "      <td>4722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Senegal</th>\n",
       "      <td>65352</td>\n",
       "      <td>653</td>\n",
       "      <td>26986</td>\n",
       "      <td>37713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Seychelles</th>\n",
       "      <td>711</td>\n",
       "      <td>0</td>\n",
       "      <td>310</td>\n",
       "      <td>401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sierra Leone</th>\n",
       "      <td>11016</td>\n",
       "      <td>626</td>\n",
       "      <td>2969</td>\n",
       "      <td>7421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Somalia</th>\n",
       "      <td>35127</td>\n",
       "      <td>1496</td>\n",
       "      <td>3454</td>\n",
       "      <td>30177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Africa</th>\n",
       "      <td>425097</td>\n",
       "      <td>7564</td>\n",
       "      <td>169447</td>\n",
       "      <td>248086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Sudan</th>\n",
       "      <td>6465</td>\n",
       "      <td>58</td>\n",
       "      <td>67</td>\n",
       "      <td>6340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sudan</th>\n",
       "      <td>51009</td>\n",
       "      <td>2486</td>\n",
       "      <td>5363</td>\n",
       "      <td>43160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tanzania</th>\n",
       "      <td>17260</td>\n",
       "      <td>662</td>\n",
       "      <td>5200</td>\n",
       "      <td>11398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Togo</th>\n",
       "      <td>8514</td>\n",
       "      <td>406</td>\n",
       "      <td>3662</td>\n",
       "      <td>4446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tunisia</th>\n",
       "      <td>51350</td>\n",
       "      <td>2130</td>\n",
       "      <td>20494</td>\n",
       "      <td>28726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Uganda</th>\n",
       "      <td>5935</td>\n",
       "      <td>0</td>\n",
       "      <td>2121</td>\n",
       "      <td>3814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>14365</td>\n",
       "      <td>208</td>\n",
       "      <td>4945</td>\n",
       "      <td>9212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>1704</td>\n",
       "      <td>195</td>\n",
       "      <td>348</td>\n",
       "      <td>1161</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Confirmed  Deaths  Recovered  Active\n",
       "Country                                                       \n",
       "Algeria                      231373   22615     102427  106331\n",
       "Angola                         1822     127        488    1207\n",
       "Benin                          6504      80       2127    4297\n",
       "Botswana                       1077      56        360     661\n",
       "Burkina Faso                  36079    2245      23036   10798\n",
       "Burundi                         780      43        328     409\n",
       "Cabo Verde                     8377      97       1781    6499\n",
       "Cameroon                     107516    3887      44418   59211\n",
       "Central African Republic       6849       3        457    6389\n",
       "Chad                          10446     968       2726    6752\n",
       "Comoros                         557      20        112     425\n",
       "Congo (Brazzaville)           12239     472       2178    9589\n",
       "Congo (Kinshasa)              41031    1913       5574   33544\n",
       "Djibouti                      53121     167      27082   25872\n",
       "Egypt                        364804   20693      92059  252052\n",
       "Equatorial Guinea             17792     156       1125   16511\n",
       "Eritrea                        2067       0       1027    1040\n",
       "Eswatini                       5396      60       1631    3705\n",
       "Ethiopia                      10068     186       3244    6638\n",
       "Gabon                         29166     286       5920   22960\n",
       "Gambia                          793      64        373     356\n",
       "Ghana                        144581     905      27668  116008\n",
       "Guinea                        75731     426      27056   48249\n",
       "Guinea-Bissau                 21128      92        832   20204\n",
       "Ivory Coast                   68998     810      28901   39287\n",
       "Kenya                         27374    1263       8423   17688\n",
       "Lesotho                          17       0          0      17\n",
       "Liberia                        7353     728       2790    3835\n",
       "Libya                          2868     113       1028    1727\n",
       "Madagascar                    10128      16       3829    6283\n",
       "Malawi                         2034     130        567    1337\n",
       "Mali                          25362    1493      11484   12385\n",
       "Mauritania                     1965     103        292    1570\n",
       "Mauritius                     18059     531      11999    5529\n",
       "Morocco                      232841    8506      85757  138578\n",
       "Mozambique                     4094       1       1046    3047\n",
       "Namibia                         988       0        440     548\n",
       "Niger                         36459    1736      20613   14110\n",
       "Nigeria                      145906    4477      33792  107637\n",
       "Rwanda                        12066       0       5727    6339\n",
       "Sao Tome and Principe          4975     141        112    4722\n",
       "Senegal                       65352     653      26986   37713\n",
       "Seychelles                      711       0        310     401\n",
       "Sierra Leone                  11016     626       2969    7421\n",
       "Somalia                       35127    1496       3454   30177\n",
       "South Africa                 425097    7564     169447  248086\n",
       "South Sudan                    6465      58         67    6340\n",
       "Sudan                         51009    2486       5363   43160\n",
       "Tanzania                      17260     662       5200   11398\n",
       "Togo                           8514     406       3662    4446\n",
       "Tunisia                       51350    2130      20494   28726\n",
       "Uganda                         5935       0       2121    3814\n",
       "Zambia                        14365     208       4945    9212\n",
       "Zimbabwe                       1704     195        348    1161"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('Country').sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Find all instances when confirmed is greater than 100 or Recovered is greater than 100\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ObservationDate</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Confirmed</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Recovered</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-27</td>\n",
       "      <td>Ivory Coast</td>\n",
       "      <td>Western Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-02-14</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  ObservationDate      Country           Region  Confirmed  Deaths  Recovered  \\\n",
       "0      2020-01-27  Ivory Coast   Western Africa          1       0          0   \n",
       "1      2020-02-14        Egypt  Northern Africa          1       0          0   \n",
       "\n",
       "   Active  \n",
       "0       1  \n",
       "1       1  "
      ]
     },
     "execution_count": 152,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ObservationDate</th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Confirmed</th>\n",
       "      <th>Deaths</th>\n",
       "      <th>Recovered</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3730</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Sudan</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>3976</td>\n",
       "      <td>170</td>\n",
       "      <td>503</td>\n",
       "      <td>3303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3731</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Tanzania</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>509</td>\n",
       "      <td>21</td>\n",
       "      <td>183</td>\n",
       "      <td>305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3732</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Togo</td>\n",
       "      <td>Western Africa</td>\n",
       "      <td>386</td>\n",
       "      <td>13</td>\n",
       "      <td>161</td>\n",
       "      <td>212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3733</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Northern Africa</td>\n",
       "      <td>1051</td>\n",
       "      <td>48</td>\n",
       "      <td>919</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3735</th>\n",
       "      <td>2020-05-25</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>920</td>\n",
       "      <td>7</td>\n",
       "      <td>336</td>\n",
       "      <td>577</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ObservationDate   Country           Region  Confirmed  Deaths  Recovered  \\\n",
       "3730      2020-05-25     Sudan  Northern Africa       3976     170        503   \n",
       "3731      2020-05-25  Tanzania   Eastern Africa        509      21        183   \n",
       "3732      2020-05-25      Togo   Western Africa        386      13        161   \n",
       "3733      2020-05-25   Tunisia  Northern Africa       1051      48        919   \n",
       "3735      2020-05-25    Zambia   Eastern Africa        920       7        336   \n",
       "\n",
       "      Active  \n",
       "3730    3303  \n",
       "3731     305  \n",
       "3732     212  \n",
       "3733      84  \n",
       "3735     577  "
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data['Confirmed'] > 100) & (data['Recovered'] > 100)].tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}