data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>location</th>\n",
       "      <th>date</th>\n",
       "      <th>vaccine</th>\n",
       "      <th>total_vaccinations</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>Moderna</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>Oxford/AstraZeneca</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>Sinopharm/Beijing</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>Sputnik V</td>\n",
       "      <td>20481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>Moderna</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35618</th>\n",
       "      <td>European Union</td>\n",
       "      <td>2022-03-29</td>\n",
       "      <td>Oxford/AstraZeneca</td>\n",
       "      <td>67403106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35619</th>\n",
       "      <td>European Union</td>\n",
       "      <td>2022-03-29</td>\n",
       "      <td>Pfizer/BioNTech</td>\n",
       "      <td>600519998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35620</th>\n",
       "      <td>European Union</td>\n",
       "      <td>2022-03-29</td>\n",
       "      <td>Sinopharm/Beijing</td>\n",
       "      <td>2301516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35621</th>\n",
       "      <td>European Union</td>\n",
       "      <td>2022-03-29</td>\n",
       "      <td>Sinovac</td>\n",
       "      <td>1809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35622</th>\n",
       "      <td>European Union</td>\n",
       "      <td>2022-03-29</td>\n",
       "      <td>Sputnik V</td>\n",
       "      <td>1845103</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>35623 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             location        date             vaccine  total_vaccinations\n",
       "0           Argentina  2020-12-29             Moderna                   2\n",
       "1           Argentina  2020-12-29  Oxford/AstraZeneca                   3\n",
       "2           Argentina  2020-12-29   Sinopharm/Beijing                   1\n",
       "3           Argentina  2020-12-29           Sputnik V               20481\n",
       "4           Argentina  2020-12-30             Moderna                   2\n",
       "...               ...         ...                 ...                 ...\n",
       "35618  European Union  2022-03-29  Oxford/AstraZeneca            67403106\n",
       "35619  European Union  2022-03-29     Pfizer/BioNTech           600519998\n",
       "35620  European Union  2022-03-29   Sinopharm/Beijing             2301516\n",
       "35621  European Union  2022-03-29             Sinovac                1809\n",
       "35622  European Union  2022-03-29           Sputnik V             1845103\n",
       "\n",
       "[35623 rows x 4 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_main = pd.read_csv('vaccinations.csv')\n",
    "df_main"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Moderna', 'Oxford/AstraZeneca', 'Sinopharm/Beijing', 'Sputnik V',\n",
       "       'CanSino', 'Pfizer/BioNTech', 'Johnson&Johnson', 'Novavax',\n",
       "       'Sinovac', 'Covaxin'], dtype=object)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_main['vaccine'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>vaccine</th>\n",
       "      <th>total_vaccinations</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Pfizer/BioNTech</td>\n",
       "      <td>344835955037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Moderna</td>\n",
       "      <td>103072147621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Oxford/AstraZeneca</td>\n",
       "      <td>46451509497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sinovac</td>\n",
       "      <td>13407163275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Johnson&amp;Johnson</td>\n",
       "      <td>12611375881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Sinopharm/Beijing</td>\n",
       "      <td>10877006517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sputnik V</td>\n",
       "      <td>5787343199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CanSino</td>\n",
       "      <td>271397675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Novavax</td>\n",
       "      <td>8268113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Covaxin</td>\n",
       "      <td>3572</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              vaccine  total_vaccinations\n",
       "0     Pfizer/BioNTech        344835955037\n",
       "1             Moderna        103072147621\n",
       "2  Oxford/AstraZeneca         46451509497\n",
       "3             Sinovac         13407163275\n",
       "4     Johnson&Johnson         12611375881\n",
       "5   Sinopharm/Beijing         10877006517\n",
       "6           Sputnik V          5787343199\n",
       "7             CanSino           271397675\n",
       "8             Novavax             8268113\n",
       "9             Covaxin                3572"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_vaccines = df_main.groupby('vaccine')['total_vaccinations'].sum().reset_index()\n",
    "df_vaccines = df_vaccines.sort_values('total_vaccinations', ascending=False)\n",
    "df_vaccines = df_vaccines.reset_index(drop=True)\n",
    "df_vaccines"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_vaccines.to_csv('vaccination_numbers.csv', index= False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2020-12-29'"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_main['date'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "def find_num(y, m):\n",
    "    if y == 2020:\n",
    "        return 1\n",
    "    elif y == 2021:\n",
    "        return  m + 1\n",
    "    else:\n",
    "        return m + 13\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "df_main['year'] = pd.to_datetime(df_main['date']).dt.year # create a new column for year\n",
    "df_main['month'] = pd.to_datetime(df_main['date']).dt.month # create a new column for month\n",
    "df_main['number'] = df_main.apply(lambda row: find_num(row['year'], row['month']), axis=1)\n",
    "vaccine_trends = df_main.groupby(['vaccine', 'year', 'month', 'number'])['total_vaccinations'].sum().reset_index().sort_values(['number','vaccine'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "vaccine_trends[vaccine_trends.vaccine == 'Pfizer/BioNTech'].to_csv('Pfizer.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "vaccine_trends[vaccine_trends.vaccine == 'Moderna'].to_csv('Moderna.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "vaccine_trends[vaccine_trends.vaccine == 'Oxford/AstraZeneca'].to_csv('AstraZeneca.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Argentina', 'Austria', 'Belgium', 'Bulgaria', 'Chile', 'Croatia',\n",
       "       'Cyprus', 'Czechia', 'Denmark', 'Ecuador', 'Estonia', 'Finland',\n",
       "       'France', 'Germany', 'Hong Kong', 'Hungary', 'Iceland', 'Ireland',\n",
       "       'Italy', 'Japan', 'Latvia', 'Liechtenstein', 'Lithuania',\n",
       "       'Luxembourg', 'Malta', 'Nepal', 'Netherlands', 'Norway', 'Peru',\n",
       "       'Poland', 'Portugal', 'Romania', 'Slovakia', 'Slovenia',\n",
       "       'South Africa', 'South Korea', 'Spain', 'Sweden', 'Switzerland',\n",
       "       'Ukraine', 'United States', 'Uruguay', 'European Union'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_main['location'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>Country</th>\n",
       "      <th>Deaths/1M pop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>195.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Albania</td>\n",
       "      <td>1257.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>152.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Andorra</td>\n",
       "      <td>2130.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Angola</td>\n",
       "      <td>55.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>Western Sahara</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>World</td>\n",
       "      <td>886.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>Yemen</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>Zambia</td>\n",
       "      <td>209.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>373.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>231 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Country  Deaths/1M pop\n",
       "0       Afghanistan          195.0\n",
       "1           Albania         1257.0\n",
       "2           Algeria          152.0\n",
       "3           Andorra         2130.0\n",
       "4            Angola           55.0\n",
       "..              ...            ...\n",
       "226  Western Sahara            2.0\n",
       "227           World          886.0\n",
       "228           Yemen           69.0\n",
       "229          Zambia          209.0\n",
       "230        Zimbabwe          373.0\n",
       "\n",
       "[231 rows x 2 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries = pd.read_csv('countries.csv')\n",
    "countries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_combined = df_main.groupby(['location', 'vaccine'])['total_vaccinations'].sum().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "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>location</th>\n",
       "      <th>vaccine</th>\n",
       "      <th>total_vaccinations</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>CanSino</td>\n",
       "      <td>53950431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>Moderna</td>\n",
       "      <td>893386753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>Oxford/AstraZeneca</td>\n",
       "      <td>5618580845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>Pfizer/BioNTech</td>\n",
       "      <td>1307660776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>Sinopharm/Beijing</td>\n",
       "      <td>5713239160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>United States</td>\n",
       "      <td>Moderna</td>\n",
       "      <td>55294886137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>United States</td>\n",
       "      <td>Pfizer/BioNTech</td>\n",
       "      <td>79776473000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>Oxford/AstraZeneca</td>\n",
       "      <td>27243328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>Pfizer/BioNTech</td>\n",
       "      <td>589726730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>Sinovac</td>\n",
       "      <td>1047602618</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>194 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          location             vaccine  total_vaccinations\n",
       "0        Argentina             CanSino            53950431\n",
       "1        Argentina             Moderna           893386753\n",
       "2        Argentina  Oxford/AstraZeneca          5618580845\n",
       "3        Argentina     Pfizer/BioNTech          1307660776\n",
       "4        Argentina   Sinopharm/Beijing          5713239160\n",
       "..             ...                 ...                 ...\n",
       "189  United States             Moderna         55294886137\n",
       "190  United States     Pfizer/BioNTech         79776473000\n",
       "191        Uruguay  Oxford/AstraZeneca            27243328\n",
       "192        Uruguay     Pfizer/BioNTech           589726730\n",
       "193        Uruguay             Sinovac          1047602618\n",
       "\n",
       "[194 rows x 3 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_combined"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['CanSino', 'Moderna', 'Oxford/AstraZeneca', 'Pfizer/BioNTech',\n",
       "       'Sinopharm/Beijing', 'Sputnik V', 'Johnson&Johnson', 'Novavax',\n",
       "       'Sinovac', 'Covaxin'], dtype=object)"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_combined[\"vaccine\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_combined.to_csv('country_numbers.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>location</th>\n",
       "      <th>CanSino</th>\n",
       "      <th>Covaxin</th>\n",
       "      <th>Johnson&amp;Johnson</th>\n",
       "      <th>Moderna</th>\n",
       "      <th>Novavax</th>\n",
       "      <th>Oxford/AstraZeneca</th>\n",
       "      <th>Pfizer/BioNTech</th>\n",
       "      <th>Sinopharm/Beijing</th>\n",
       "      <th>Sinovac</th>\n",
       "      <th>Sputnik V</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>53950431.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.933868e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.618581e+09</td>\n",
       "      <td>1.307661e+09</td>\n",
       "      <td>5.713239e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.092133e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Austria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.263894e+07</td>\n",
       "      <td>5.436887e+07</td>\n",
       "      <td>11819.0</td>\n",
       "      <td>7.372778e+07</td>\n",
       "      <td>4.557673e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.621113e+07</td>\n",
       "      <td>9.354474e+07</td>\n",
       "      <td>107.0</td>\n",
       "      <td>1.256663e+08</td>\n",
       "      <td>5.989736e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.198064e+07</td>\n",
       "      <td>1.560478e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.352012e+07</td>\n",
       "      <td>8.313276e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chile</td>\n",
       "      <td>153505458.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.513017e+08</td>\n",
       "      <td>2.205676e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.421275e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.382836e+06</td>\n",
       "      <td>1.783213e+07</td>\n",
       "      <td>479.0</td>\n",
       "      <td>2.639237e+07</td>\n",
       "      <td>1.308606e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Cyprus</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.168150e+05</td>\n",
       "      <td>4.782633e+06</td>\n",
       "      <td>59.0</td>\n",
       "      <td>1.139933e+07</td>\n",
       "      <td>3.796457e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Czechia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.293091e+07</td>\n",
       "      <td>3.552392e+08</td>\n",
       "      <td>41996.0</td>\n",
       "      <td>2.252249e+08</td>\n",
       "      <td>3.441540e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.947563e+06</td>\n",
       "      <td>5.252257e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.301687e+06</td>\n",
       "      <td>3.475988e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>63941786.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.740528e+08</td>\n",
       "      <td>1.399258e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.561852e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Estonia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.382223e+06</td>\n",
       "      <td>7.100996e+06</td>\n",
       "      <td>207.0</td>\n",
       "      <td>1.151180e+07</td>\n",
       "      <td>4.942954e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>European Union</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3506.0</td>\n",
       "      <td>4.519774e+09</td>\n",
       "      <td>2.439189e+10</td>\n",
       "      <td>2066859.0</td>\n",
       "      <td>2.170061e+10</td>\n",
       "      <td>1.410337e+11</td>\n",
       "      <td>7.438711e+08</td>\n",
       "      <td>5.175290e+05</td>\n",
       "      <td>6.277489e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Finland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>4.801806e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.676701e+07</td>\n",
       "      <td>2.991248e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.978426e+08</td>\n",
       "      <td>4.074001e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.579872e+09</td>\n",
       "      <td>2.522532e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.205289e+08</td>\n",
       "      <td>4.719170e+09</td>\n",
       "      <td>1348545.0</td>\n",
       "      <td>4.188139e+09</td>\n",
       "      <td>2.915364e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.643527e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.041142e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Hungary</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.331140e+06</td>\n",
       "      <td>3.786128e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.847525e+07</td>\n",
       "      <td>3.139785e+08</td>\n",
       "      <td>1.045858e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.708046e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Iceland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.913000e+03</td>\n",
       "      <td>3.548400e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.200000e+01</td>\n",
       "      <td>4.200838e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.756933e+06</td>\n",
       "      <td>3.216439e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.431227e+07</td>\n",
       "      <td>2.610461e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Italy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.220771e+08</td>\n",
       "      <td>4.925954e+09</td>\n",
       "      <td>507902.0</td>\n",
       "      <td>2.425777e+09</td>\n",
       "      <td>2.053227e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Japan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.415208e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.768902e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Latvia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.726386e+07</td>\n",
       "      <td>1.244435e+08</td>\n",
       "      <td>2189.0</td>\n",
       "      <td>6.160848e+07</td>\n",
       "      <td>3.528115e+08</td>\n",
       "      <td>3.560000e+02</td>\n",
       "      <td>3.800000e+01</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.646000e+03</td>\n",
       "      <td>1.543114e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.512990e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Lithuania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.440297e+06</td>\n",
       "      <td>1.224147e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.402843e+07</td>\n",
       "      <td>1.097743e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.596563e+06</td>\n",
       "      <td>5.942258e+06</td>\n",
       "      <td>532.0</td>\n",
       "      <td>4.841859e+06</td>\n",
       "      <td>2.516063e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Malta</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.202381e+06</td>\n",
       "      <td>4.502141e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.063862e+07</td>\n",
       "      <td>2.624406e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Nepal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.118813e+08</td>\n",
       "      <td>1.812575e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.530906e+08</td>\n",
       "      <td>1.984490e+07</td>\n",
       "      <td>6.771564e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Netherlands</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.404599e+07</td>\n",
       "      <td>1.347043e+08</td>\n",
       "      <td>323.0</td>\n",
       "      <td>1.297025e+08</td>\n",
       "      <td>8.180842e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.614750e+05</td>\n",
       "      <td>6.222832e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.044875e+06</td>\n",
       "      <td>2.860577e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Peru</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.241190e+08</td>\n",
       "      <td>6.157883e+09</td>\n",
       "      <td>3.638123e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Poland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.837319e+07</td>\n",
       "      <td>1.480395e+08</td>\n",
       "      <td>11067.0</td>\n",
       "      <td>2.452178e+08</td>\n",
       "      <td>1.342429e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66.0</td>\n",
       "      <td>3.906225e+07</td>\n",
       "      <td>9.117436e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.593523e+07</td>\n",
       "      <td>4.756099e+08</td>\n",
       "      <td>3.048300e+04</td>\n",
       "      <td>6.502200e+04</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Romania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.737618e+08</td>\n",
       "      <td>2.846886e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.030900e+08</td>\n",
       "      <td>3.290245e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.577868e+06</td>\n",
       "      <td>2.406459e+07</td>\n",
       "      <td>660.0</td>\n",
       "      <td>2.319607e+07</td>\n",
       "      <td>1.717788e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.805440e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Slovenia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.084514e+06</td>\n",
       "      <td>9.077059e+06</td>\n",
       "      <td>51.0</td>\n",
       "      <td>1.354594e+07</td>\n",
       "      <td>7.256522e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.005567e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.203154e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>South Korea</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.108059e+08</td>\n",
       "      <td>3.442773e+09</td>\n",
       "      <td>4275195.0</td>\n",
       "      <td>5.415624e+09</td>\n",
       "      <td>1.251304e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.824416e+07</td>\n",
       "      <td>5.084171e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.316192e+08</td>\n",
       "      <td>2.244537e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.586669e+07</td>\n",
       "      <td>123.0</td>\n",
       "      <td>6.119736e+07</td>\n",
       "      <td>4.820933e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Switzerland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.809174e+06</td>\n",
       "      <td>2.327226e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.356914e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.987506e+06</td>\n",
       "      <td>4.637534e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.451318e+08</td>\n",
       "      <td>1.810085e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.334709e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.872710e+09</td>\n",
       "      <td>5.529489e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.977647e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.724333e+07</td>\n",
       "      <td>5.897267e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.047603e+09</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          location      CanSino  Covaxin  Johnson&Johnson       Moderna  \\\n",
       "0        Argentina   53950431.0      NaN              NaN  8.933868e+08   \n",
       "1          Austria          NaN      NaN     1.263894e+07  5.436887e+07   \n",
       "2          Belgium          NaN      NaN     1.621113e+07  9.354474e+07   \n",
       "3         Bulgaria          NaN      NaN     1.198064e+07  1.560478e+07   \n",
       "4            Chile  153505458.0      NaN              NaN           NaN   \n",
       "5          Croatia          NaN      NaN     5.382836e+06  1.783213e+07   \n",
       "6           Cyprus          NaN      NaN     9.168150e+05  4.782633e+06   \n",
       "7          Czechia          NaN      NaN     8.293091e+07  3.552392e+08   \n",
       "8          Denmark          NaN      NaN     1.947563e+06  5.252257e+07   \n",
       "9          Ecuador   63941786.0      NaN              NaN           NaN   \n",
       "10         Estonia          NaN      NaN     2.382223e+06  7.100996e+06   \n",
       "11  European Union          NaN   3506.0     4.519774e+09  2.439189e+10   \n",
       "12         Finland          NaN      NaN     0.000000e+00  4.801806e+07   \n",
       "13          France          NaN      NaN     2.978426e+08  4.074001e+09   \n",
       "14         Germany          NaN      NaN     9.205289e+08  4.719170e+09   \n",
       "15       Hong Kong          NaN      NaN              NaN           NaN   \n",
       "16         Hungary          NaN      NaN     9.331140e+06  3.786128e+07   \n",
       "17         Iceland          NaN      NaN     4.913000e+03  3.548400e+05   \n",
       "18         Ireland          NaN      NaN     8.756933e+06  3.216439e+07   \n",
       "19           Italy          NaN      NaN     4.220771e+08  4.925954e+09   \n",
       "20           Japan          NaN      NaN              NaN  1.415208e+08   \n",
       "21          Latvia          NaN      NaN     5.726386e+07  1.244435e+08   \n",
       "22   Liechtenstein          NaN      NaN     4.646000e+03  1.543114e+06   \n",
       "23       Lithuania          NaN      NaN     8.440297e+06  1.224147e+07   \n",
       "24      Luxembourg          NaN      NaN     1.596563e+06  5.942258e+06   \n",
       "25           Malta          NaN      NaN     1.202381e+06  4.502141e+06   \n",
       "26           Nepal          NaN      NaN     1.118813e+08  1.812575e+08   \n",
       "27     Netherlands          NaN      NaN     3.404599e+07  1.347043e+08   \n",
       "28          Norway          NaN      NaN     2.614750e+05  6.222832e+07   \n",
       "29            Peru          NaN      NaN              NaN           NaN   \n",
       "30          Poland          NaN      NaN     8.837319e+07  1.480395e+08   \n",
       "31        Portugal          NaN     66.0     3.906225e+07  9.117436e+07   \n",
       "32         Romania          NaN      NaN     3.737618e+08  2.846886e+08   \n",
       "33        Slovakia          NaN      NaN     4.577868e+06  2.406459e+07   \n",
       "34        Slovenia          NaN      NaN     4.084514e+06  9.077059e+06   \n",
       "35    South Africa          NaN      NaN     2.005567e+08           NaN   \n",
       "36     South Korea          NaN      NaN     4.108059e+08  3.442773e+09   \n",
       "37           Spain          NaN      NaN     7.824416e+07  5.084171e+08   \n",
       "38          Sweden          NaN      NaN              NaN  8.586669e+07   \n",
       "39     Switzerland          NaN      NaN     7.809174e+06  2.327226e+09   \n",
       "40         Ukraine          NaN      NaN     3.987506e+06  4.637534e+08   \n",
       "41   United States          NaN      NaN     4.872710e+09  5.529489e+10   \n",
       "42         Uruguay          NaN      NaN              NaN           NaN   \n",
       "\n",
       "      Novavax  Oxford/AstraZeneca  Pfizer/BioNTech  Sinopharm/Beijing  \\\n",
       "0         NaN        5.618581e+09     1.307661e+09       5.713239e+09   \n",
       "1     11819.0        7.372778e+07     4.557673e+08                NaN   \n",
       "2       107.0        1.256663e+08     5.989736e+08                NaN   \n",
       "3         NaN        2.352012e+07     8.313276e+07                NaN   \n",
       "4         NaN        1.513017e+08     2.205676e+09                NaN   \n",
       "5       479.0        2.639237e+07     1.308606e+08                NaN   \n",
       "6        59.0        1.139933e+07     3.796457e+07                NaN   \n",
       "7     41996.0        2.252249e+08     3.441540e+09                NaN   \n",
       "8         NaN        8.301687e+06     3.475988e+08                NaN   \n",
       "9         NaN        5.740528e+08     1.399258e+09                NaN   \n",
       "10      207.0        1.151180e+07     4.942954e+07                NaN   \n",
       "11  2066859.0        2.170061e+10     1.410337e+11       7.438711e+08   \n",
       "12        NaN        2.676701e+07     2.991248e+08                NaN   \n",
       "13        NaN        2.579872e+09     2.522532e+10                NaN   \n",
       "14  1348545.0        4.188139e+09     2.915364e+10                NaN   \n",
       "15        NaN                 NaN     1.643527e+09                NaN   \n",
       "16        NaN        5.847525e+07     3.139785e+08       1.045858e+08   \n",
       "17        NaN        7.200000e+01     4.200838e+06                NaN   \n",
       "18        NaN        4.431227e+07     2.610461e+08                NaN   \n",
       "19   507902.0        2.425777e+09     2.053227e+10                NaN   \n",
       "20        NaN                 NaN     3.768902e+09                NaN   \n",
       "21     2189.0        6.160848e+07     3.528115e+08       3.560000e+02   \n",
       "22        NaN                 NaN     7.512990e+05                NaN   \n",
       "23        NaN        2.402843e+07     1.097743e+08                NaN   \n",
       "24      532.0        4.841859e+06     2.516063e+07                NaN   \n",
       "25        NaN        1.063862e+07     2.624406e+07                NaN   \n",
       "26        NaN        3.530906e+08     1.984490e+07       6.771564e+08   \n",
       "27      323.0        1.297025e+08     8.180842e+08                NaN   \n",
       "28        NaN        8.044875e+06     2.860577e+08                NaN   \n",
       "29        NaN        7.241190e+08     6.157883e+09       3.638123e+09   \n",
       "30    11067.0        2.452178e+08     1.342429e+09                NaN   \n",
       "31        0.0        9.593523e+07     4.756099e+08       3.048300e+04   \n",
       "32        NaN        2.030900e+08     3.290245e+09                NaN   \n",
       "33      660.0        2.319607e+07     1.717788e+08                NaN   \n",
       "34       51.0        1.354594e+07     7.256522e+07                NaN   \n",
       "35        NaN                 NaN     6.203154e+08                NaN   \n",
       "36  4275195.0        5.415624e+09     1.251304e+10                NaN   \n",
       "37        NaN        4.316192e+08     2.244537e+09                NaN   \n",
       "38      123.0        6.119736e+07     4.820933e+08                NaN   \n",
       "39        NaN                 NaN     1.356914e+09                NaN   \n",
       "40        NaN        7.451318e+08     1.810085e+09                NaN   \n",
       "41        NaN                 NaN     7.977647e+10                NaN   \n",
       "42        NaN        2.724333e+07     5.897267e+08                NaN   \n",
       "\n",
       "         Sinovac     Sputnik V  \n",
       "0            NaN  5.092133e+09  \n",
       "1            NaN           NaN  \n",
       "2            NaN           NaN  \n",
       "3            NaN           NaN  \n",
       "4   7.421275e+09           NaN  \n",
       "5            NaN           NaN  \n",
       "6            NaN           NaN  \n",
       "7            NaN           NaN  \n",
       "8            NaN           NaN  \n",
       "9   2.561852e+09           NaN  \n",
       "10           NaN           NaN  \n",
       "11  5.175290e+05  6.277489e+08  \n",
       "12           NaN           NaN  \n",
       "13           NaN           NaN  \n",
       "14           NaN           NaN  \n",
       "15  1.041142e+09           NaN  \n",
       "16           NaN  6.708046e+07  \n",
       "17           NaN           NaN  \n",
       "18           NaN           NaN  \n",
       "19           NaN           NaN  \n",
       "20           NaN           NaN  \n",
       "21  3.800000e+01           NaN  \n",
       "22           NaN           NaN  \n",
       "23           NaN           NaN  \n",
       "24           NaN           NaN  \n",
       "25           NaN           NaN  \n",
       "26           NaN           NaN  \n",
       "27           NaN           NaN  \n",
       "28           NaN           NaN  \n",
       "29           NaN           NaN  \n",
       "30           NaN           NaN  \n",
       "31  6.502200e+04           NaN  \n",
       "32           NaN           NaN  \n",
       "33           NaN  3.805440e+05  \n",
       "34           NaN           NaN  \n",
       "35           NaN           NaN  \n",
       "36           NaN           NaN  \n",
       "37           NaN           NaN  \n",
       "38           NaN           NaN  \n",
       "39           NaN           NaN  \n",
       "40  1.334709e+09           NaN  \n",
       "41           NaN           NaN  \n",
       "42  1.047603e+09           NaN  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_combined= df_combined.pivot(index='location', columns='vaccine', values='total_vaccinations')\n",
    "df_combined.to_csv('flattened_file.csv') # save the flattened file\n",
    "df_combined = pd.read_csv('flattened_file.csv')\n",
    "df_combined"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>location</th>\n",
       "      <th>CanSino</th>\n",
       "      <th>Covaxin</th>\n",
       "      <th>Johnson&amp;Johnson</th>\n",
       "      <th>Moderna</th>\n",
       "      <th>Novavax</th>\n",
       "      <th>Oxford/AstraZeneca</th>\n",
       "      <th>Pfizer/BioNTech</th>\n",
       "      <th>Sinopharm/Beijing</th>\n",
       "      <th>Sinovac</th>\n",
       "      <th>Sputnik V</th>\n",
       "      <th>Country</th>\n",
       "      <th>Deaths/1M pop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>53950431.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.933868e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.618581e+09</td>\n",
       "      <td>1.307661e+09</td>\n",
       "      <td>5.713239e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.092133e+09</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>2837.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Austria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.263894e+07</td>\n",
       "      <td>5.436887e+07</td>\n",
       "      <td>11819.0</td>\n",
       "      <td>7.372778e+07</td>\n",
       "      <td>4.557673e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Austria</td>\n",
       "      <td>2486.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.621113e+07</td>\n",
       "      <td>9.354474e+07</td>\n",
       "      <td>107.0</td>\n",
       "      <td>1.256663e+08</td>\n",
       "      <td>5.989736e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>2946.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.198064e+07</td>\n",
       "      <td>1.560478e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.352012e+07</td>\n",
       "      <td>8.313276e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>5616.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chile</td>\n",
       "      <td>153505458.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.513017e+08</td>\n",
       "      <td>2.205676e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.421275e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chile</td>\n",
       "      <td>3350.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.382836e+06</td>\n",
       "      <td>1.783213e+07</td>\n",
       "      <td>479.0</td>\n",
       "      <td>2.639237e+07</td>\n",
       "      <td>1.308606e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>4504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Cyprus</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.168150e+05</td>\n",
       "      <td>4.782633e+06</td>\n",
       "      <td>59.0</td>\n",
       "      <td>1.139933e+07</td>\n",
       "      <td>3.796457e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cyprus</td>\n",
       "      <td>1115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Czechia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.293091e+07</td>\n",
       "      <td>3.552392e+08</td>\n",
       "      <td>41996.0</td>\n",
       "      <td>2.252249e+08</td>\n",
       "      <td>3.441540e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Czechia</td>\n",
       "      <td>3987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.947563e+06</td>\n",
       "      <td>5.252257e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.301687e+06</td>\n",
       "      <td>3.475988e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>1503.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>63941786.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.740528e+08</td>\n",
       "      <td>1.399258e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.561852e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Estonia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.382223e+06</td>\n",
       "      <td>7.100996e+06</td>\n",
       "      <td>207.0</td>\n",
       "      <td>1.151180e+07</td>\n",
       "      <td>4.942954e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Estonia</td>\n",
       "      <td>2270.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Finland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>4.801806e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.676701e+07</td>\n",
       "      <td>2.991248e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Finland</td>\n",
       "      <td>1816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.978426e+08</td>\n",
       "      <td>4.074001e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.579872e+09</td>\n",
       "      <td>2.522532e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>France</td>\n",
       "      <td>2556.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.205289e+08</td>\n",
       "      <td>4.719170e+09</td>\n",
       "      <td>1348545.0</td>\n",
       "      <td>4.188139e+09</td>\n",
       "      <td>2.915364e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>2078.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.643527e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.041142e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>1817.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Hungary</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.331140e+06</td>\n",
       "      <td>3.786128e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.847525e+07</td>\n",
       "      <td>3.139785e+08</td>\n",
       "      <td>1.045858e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.708046e+07</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>5088.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Iceland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.913000e+03</td>\n",
       "      <td>3.548400e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.200000e+01</td>\n",
       "      <td>4.200838e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Iceland</td>\n",
       "      <td>663.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.756933e+06</td>\n",
       "      <td>3.216439e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.431227e+07</td>\n",
       "      <td>2.610461e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>1814.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Italy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.220771e+08</td>\n",
       "      <td>4.925954e+09</td>\n",
       "      <td>507902.0</td>\n",
       "      <td>2.425777e+09</td>\n",
       "      <td>2.053227e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Italy</td>\n",
       "      <td>3170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Japan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.415208e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.768902e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Japan</td>\n",
       "      <td>595.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Latvia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.726386e+07</td>\n",
       "      <td>1.244435e+08</td>\n",
       "      <td>2189.0</td>\n",
       "      <td>6.160848e+07</td>\n",
       "      <td>3.528115e+08</td>\n",
       "      <td>3.560000e+02</td>\n",
       "      <td>3.800000e+01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Latvia</td>\n",
       "      <td>3456.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.646000e+03</td>\n",
       "      <td>1.543114e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.512990e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>2449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Lithuania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.440297e+06</td>\n",
       "      <td>1.224147e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.402843e+07</td>\n",
       "      <td>1.097743e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td>3642.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.596563e+06</td>\n",
       "      <td>5.942258e+06</td>\n",
       "      <td>532.0</td>\n",
       "      <td>4.841859e+06</td>\n",
       "      <td>2.516063e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>1918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Malta</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.202381e+06</td>\n",
       "      <td>4.502141e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.063862e+07</td>\n",
       "      <td>2.624406e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Malta</td>\n",
       "      <td>1917.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Nepal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.118813e+08</td>\n",
       "      <td>1.812575e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.530906e+08</td>\n",
       "      <td>1.984490e+07</td>\n",
       "      <td>6.771564e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>398.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Netherlands</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.404599e+07</td>\n",
       "      <td>1.347043e+08</td>\n",
       "      <td>323.0</td>\n",
       "      <td>1.297025e+08</td>\n",
       "      <td>8.180842e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>1336.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.614750e+05</td>\n",
       "      <td>6.222832e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.044875e+06</td>\n",
       "      <td>2.860577e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Norway</td>\n",
       "      <td>1018.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Peru</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.241190e+08</td>\n",
       "      <td>6.157883e+09</td>\n",
       "      <td>3.638123e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Peru</td>\n",
       "      <td>6569.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Poland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.837319e+07</td>\n",
       "      <td>1.480395e+08</td>\n",
       "      <td>11067.0</td>\n",
       "      <td>2.452178e+08</td>\n",
       "      <td>1.342429e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poland</td>\n",
       "      <td>3170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66.0</td>\n",
       "      <td>3.906225e+07</td>\n",
       "      <td>9.117436e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.593523e+07</td>\n",
       "      <td>4.756099e+08</td>\n",
       "      <td>3.048300e+04</td>\n",
       "      <td>6.502200e+04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>2658.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Romania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.737618e+08</td>\n",
       "      <td>2.846886e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.030900e+08</td>\n",
       "      <td>3.290245e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Romania</td>\n",
       "      <td>3586.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.577868e+06</td>\n",
       "      <td>2.406459e+07</td>\n",
       "      <td>660.0</td>\n",
       "      <td>2.319607e+07</td>\n",
       "      <td>1.717788e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.805440e+05</td>\n",
       "      <td>Slovakia</td>\n",
       "      <td>3877.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Slovenia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.084514e+06</td>\n",
       "      <td>9.077059e+06</td>\n",
       "      <td>51.0</td>\n",
       "      <td>1.354594e+07</td>\n",
       "      <td>7.256522e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Slovenia</td>\n",
       "      <td>3417.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.005567e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.203154e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>1689.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.824416e+07</td>\n",
       "      <td>5.084171e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.316192e+08</td>\n",
       "      <td>2.244537e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Spain</td>\n",
       "      <td>2606.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.586669e+07</td>\n",
       "      <td>123.0</td>\n",
       "      <td>6.119736e+07</td>\n",
       "      <td>4.820933e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>2401.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Switzerland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.809174e+06</td>\n",
       "      <td>2.327226e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.356914e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>1647.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.987506e+06</td>\n",
       "      <td>4.637534e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.451318e+08</td>\n",
       "      <td>1.810085e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.334709e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td>2603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.872710e+09</td>\n",
       "      <td>5.529489e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.977647e+10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>3494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.724333e+07</td>\n",
       "      <td>5.897267e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.047603e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2184.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         location      CanSino  Covaxin  Johnson&Johnson       Moderna  \\\n",
       "0       Argentina   53950431.0      NaN              NaN  8.933868e+08   \n",
       "1         Austria          NaN      NaN     1.263894e+07  5.436887e+07   \n",
       "2         Belgium          NaN      NaN     1.621113e+07  9.354474e+07   \n",
       "3        Bulgaria          NaN      NaN     1.198064e+07  1.560478e+07   \n",
       "4           Chile  153505458.0      NaN              NaN           NaN   \n",
       "5         Croatia          NaN      NaN     5.382836e+06  1.783213e+07   \n",
       "6          Cyprus          NaN      NaN     9.168150e+05  4.782633e+06   \n",
       "7         Czechia          NaN      NaN     8.293091e+07  3.552392e+08   \n",
       "8         Denmark          NaN      NaN     1.947563e+06  5.252257e+07   \n",
       "9         Ecuador   63941786.0      NaN              NaN           NaN   \n",
       "10        Estonia          NaN      NaN     2.382223e+06  7.100996e+06   \n",
       "11        Finland          NaN      NaN     0.000000e+00  4.801806e+07   \n",
       "12         France          NaN      NaN     2.978426e+08  4.074001e+09   \n",
       "13        Germany          NaN      NaN     9.205289e+08  4.719170e+09   \n",
       "14      Hong Kong          NaN      NaN              NaN           NaN   \n",
       "15        Hungary          NaN      NaN     9.331140e+06  3.786128e+07   \n",
       "16        Iceland          NaN      NaN     4.913000e+03  3.548400e+05   \n",
       "17        Ireland          NaN      NaN     8.756933e+06  3.216439e+07   \n",
       "18          Italy          NaN      NaN     4.220771e+08  4.925954e+09   \n",
       "19          Japan          NaN      NaN              NaN  1.415208e+08   \n",
       "20         Latvia          NaN      NaN     5.726386e+07  1.244435e+08   \n",
       "21  Liechtenstein          NaN      NaN     4.646000e+03  1.543114e+06   \n",
       "22      Lithuania          NaN      NaN     8.440297e+06  1.224147e+07   \n",
       "23     Luxembourg          NaN      NaN     1.596563e+06  5.942258e+06   \n",
       "24          Malta          NaN      NaN     1.202381e+06  4.502141e+06   \n",
       "25          Nepal          NaN      NaN     1.118813e+08  1.812575e+08   \n",
       "26    Netherlands          NaN      NaN     3.404599e+07  1.347043e+08   \n",
       "27         Norway          NaN      NaN     2.614750e+05  6.222832e+07   \n",
       "28           Peru          NaN      NaN              NaN           NaN   \n",
       "29         Poland          NaN      NaN     8.837319e+07  1.480395e+08   \n",
       "30       Portugal          NaN     66.0     3.906225e+07  9.117436e+07   \n",
       "31        Romania          NaN      NaN     3.737618e+08  2.846886e+08   \n",
       "32       Slovakia          NaN      NaN     4.577868e+06  2.406459e+07   \n",
       "33       Slovenia          NaN      NaN     4.084514e+06  9.077059e+06   \n",
       "34   South Africa          NaN      NaN     2.005567e+08           NaN   \n",
       "35          Spain          NaN      NaN     7.824416e+07  5.084171e+08   \n",
       "36         Sweden          NaN      NaN              NaN  8.586669e+07   \n",
       "37    Switzerland          NaN      NaN     7.809174e+06  2.327226e+09   \n",
       "38        Ukraine          NaN      NaN     3.987506e+06  4.637534e+08   \n",
       "39  United States          NaN      NaN     4.872710e+09  5.529489e+10   \n",
       "40        Uruguay          NaN      NaN              NaN           NaN   \n",
       "\n",
       "      Novavax  Oxford/AstraZeneca  Pfizer/BioNTech  Sinopharm/Beijing  \\\n",
       "0         NaN        5.618581e+09     1.307661e+09       5.713239e+09   \n",
       "1     11819.0        7.372778e+07     4.557673e+08                NaN   \n",
       "2       107.0        1.256663e+08     5.989736e+08                NaN   \n",
       "3         NaN        2.352012e+07     8.313276e+07                NaN   \n",
       "4         NaN        1.513017e+08     2.205676e+09                NaN   \n",
       "5       479.0        2.639237e+07     1.308606e+08                NaN   \n",
       "6        59.0        1.139933e+07     3.796457e+07                NaN   \n",
       "7     41996.0        2.252249e+08     3.441540e+09                NaN   \n",
       "8         NaN        8.301687e+06     3.475988e+08                NaN   \n",
       "9         NaN        5.740528e+08     1.399258e+09                NaN   \n",
       "10      207.0        1.151180e+07     4.942954e+07                NaN   \n",
       "11        NaN        2.676701e+07     2.991248e+08                NaN   \n",
       "12        NaN        2.579872e+09     2.522532e+10                NaN   \n",
       "13  1348545.0        4.188139e+09     2.915364e+10                NaN   \n",
       "14        NaN                 NaN     1.643527e+09                NaN   \n",
       "15        NaN        5.847525e+07     3.139785e+08       1.045858e+08   \n",
       "16        NaN        7.200000e+01     4.200838e+06                NaN   \n",
       "17        NaN        4.431227e+07     2.610461e+08                NaN   \n",
       "18   507902.0        2.425777e+09     2.053227e+10                NaN   \n",
       "19        NaN                 NaN     3.768902e+09                NaN   \n",
       "20     2189.0        6.160848e+07     3.528115e+08       3.560000e+02   \n",
       "21        NaN                 NaN     7.512990e+05                NaN   \n",
       "22        NaN        2.402843e+07     1.097743e+08                NaN   \n",
       "23      532.0        4.841859e+06     2.516063e+07                NaN   \n",
       "24        NaN        1.063862e+07     2.624406e+07                NaN   \n",
       "25        NaN        3.530906e+08     1.984490e+07       6.771564e+08   \n",
       "26      323.0        1.297025e+08     8.180842e+08                NaN   \n",
       "27        NaN        8.044875e+06     2.860577e+08                NaN   \n",
       "28        NaN        7.241190e+08     6.157883e+09       3.638123e+09   \n",
       "29    11067.0        2.452178e+08     1.342429e+09                NaN   \n",
       "30        0.0        9.593523e+07     4.756099e+08       3.048300e+04   \n",
       "31        NaN        2.030900e+08     3.290245e+09                NaN   \n",
       "32      660.0        2.319607e+07     1.717788e+08                NaN   \n",
       "33       51.0        1.354594e+07     7.256522e+07                NaN   \n",
       "34        NaN                 NaN     6.203154e+08                NaN   \n",
       "35        NaN        4.316192e+08     2.244537e+09                NaN   \n",
       "36      123.0        6.119736e+07     4.820933e+08                NaN   \n",
       "37        NaN                 NaN     1.356914e+09                NaN   \n",
       "38        NaN        7.451318e+08     1.810085e+09                NaN   \n",
       "39        NaN                 NaN     7.977647e+10                NaN   \n",
       "40        NaN        2.724333e+07     5.897267e+08                NaN   \n",
       "\n",
       "         Sinovac     Sputnik V        Country  Deaths/1M pop  \n",
       "0            NaN  5.092133e+09      Argentina         2837.0  \n",
       "1            NaN           NaN        Austria         2486.0  \n",
       "2            NaN           NaN        Belgium         2946.0  \n",
       "3            NaN           NaN       Bulgaria         5616.0  \n",
       "4   7.421275e+09           NaN          Chile         3350.0  \n",
       "5            NaN           NaN        Croatia         4504.0  \n",
       "6            NaN           NaN         Cyprus         1115.0  \n",
       "7            NaN           NaN        Czechia         3987.0  \n",
       "8            NaN           NaN        Denmark         1503.0  \n",
       "9   2.561852e+09           NaN        Ecuador         1990.0  \n",
       "10           NaN           NaN        Estonia         2270.0  \n",
       "11           NaN           NaN        Finland         1816.0  \n",
       "12           NaN           NaN         France         2556.0  \n",
       "13           NaN           NaN        Germany         2078.0  \n",
       "14  1.041142e+09           NaN      Hong Kong         1817.0  \n",
       "15           NaN  6.708046e+07        Hungary         5088.0  \n",
       "16           NaN           NaN        Iceland          663.0  \n",
       "17           NaN           NaN        Ireland         1814.0  \n",
       "18           NaN           NaN          Italy         3170.0  \n",
       "19           NaN           NaN          Japan          595.0  \n",
       "20  3.800000e+01           NaN         Latvia         3456.0  \n",
       "21           NaN           NaN  Liechtenstein         2449.0  \n",
       "22           NaN           NaN      Lithuania         3642.0  \n",
       "23           NaN           NaN     Luxembourg         1918.0  \n",
       "24           NaN           NaN          Malta         1917.0  \n",
       "25           NaN           NaN          Nepal          398.0  \n",
       "26           NaN           NaN    Netherlands         1336.0  \n",
       "27           NaN           NaN         Norway         1018.0  \n",
       "28           NaN           NaN           Peru         6569.0  \n",
       "29           NaN           NaN         Poland         3170.0  \n",
       "30  6.502200e+04           NaN       Portugal         2658.0  \n",
       "31           NaN           NaN        Romania         3586.0  \n",
       "32           NaN  3.805440e+05       Slovakia         3877.0  \n",
       "33           NaN           NaN       Slovenia         3417.0  \n",
       "34           NaN           NaN   South Africa         1689.0  \n",
       "35           NaN           NaN          Spain         2606.0  \n",
       "36           NaN           NaN         Sweden         2401.0  \n",
       "37           NaN           NaN    Switzerland         1647.0  \n",
       "38  1.334709e+09           NaN        Ukraine         2603.0  \n",
       "39           NaN           NaN  United States         3494.0  \n",
       "40  1.047603e+09           NaN        Uruguay         2184.0  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_combined = df_combined.merge(countries, left_on= 'location', right_on='Country')\n",
    "final_combined"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_combined.fillna(0, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "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>location</th>\n",
       "      <th>CanSino</th>\n",
       "      <th>Covaxin</th>\n",
       "      <th>Johnson&amp;Johnson</th>\n",
       "      <th>Moderna</th>\n",
       "      <th>Novavax</th>\n",
       "      <th>Oxford/AstraZeneca</th>\n",
       "      <th>Pfizer/BioNTech</th>\n",
       "      <th>Sinopharm/Beijing</th>\n",
       "      <th>Sinovac</th>\n",
       "      <th>Sputnik V</th>\n",
       "      <th>Country</th>\n",
       "      <th>Deaths/1M pop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>53950431.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.933868e+08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.618581e+09</td>\n",
       "      <td>1.307661e+09</td>\n",
       "      <td>5.713239e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>5.092133e+09</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>2837.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Austria</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.263894e+07</td>\n",
       "      <td>5.436887e+07</td>\n",
       "      <td>11819.0</td>\n",
       "      <td>7.372778e+07</td>\n",
       "      <td>4.557673e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Austria</td>\n",
       "      <td>2486.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.621113e+07</td>\n",
       "      <td>9.354474e+07</td>\n",
       "      <td>107.0</td>\n",
       "      <td>1.256663e+08</td>\n",
       "      <td>5.989736e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>2946.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.198064e+07</td>\n",
       "      <td>1.560478e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.352012e+07</td>\n",
       "      <td>8.313276e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>5616.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chile</td>\n",
       "      <td>153505458.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.513017e+08</td>\n",
       "      <td>2.205676e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.421275e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Chile</td>\n",
       "      <td>3350.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.382836e+06</td>\n",
       "      <td>1.783213e+07</td>\n",
       "      <td>479.0</td>\n",
       "      <td>2.639237e+07</td>\n",
       "      <td>1.308606e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Croatia</td>\n",
       "      <td>4504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Cyprus</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.168150e+05</td>\n",
       "      <td>4.782633e+06</td>\n",
       "      <td>59.0</td>\n",
       "      <td>1.139933e+07</td>\n",
       "      <td>3.796457e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Cyprus</td>\n",
       "      <td>1115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Czechia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.293091e+07</td>\n",
       "      <td>3.552392e+08</td>\n",
       "      <td>41996.0</td>\n",
       "      <td>2.252249e+08</td>\n",
       "      <td>3.441540e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Czechia</td>\n",
       "      <td>3987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.947563e+06</td>\n",
       "      <td>5.252257e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.301687e+06</td>\n",
       "      <td>3.475988e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>1503.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>63941786.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.740528e+08</td>\n",
       "      <td>1.399258e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.561852e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Ecuador</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Estonia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.382223e+06</td>\n",
       "      <td>7.100996e+06</td>\n",
       "      <td>207.0</td>\n",
       "      <td>1.151180e+07</td>\n",
       "      <td>4.942954e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Estonia</td>\n",
       "      <td>2270.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Finland</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>4.801806e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.676701e+07</td>\n",
       "      <td>2.991248e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Finland</td>\n",
       "      <td>1816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>France</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.978426e+08</td>\n",
       "      <td>4.074001e+09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.579872e+09</td>\n",
       "      <td>2.522532e+10</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>France</td>\n",
       "      <td>2556.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Germany</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.205289e+08</td>\n",
       "      <td>4.719170e+09</td>\n",
       "      <td>1348545.0</td>\n",
       "      <td>4.188139e+09</td>\n",
       "      <td>2.915364e+10</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Germany</td>\n",
       "      <td>2078.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.643527e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.041142e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>1817.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Hungary</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.331140e+06</td>\n",
       "      <td>3.786128e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.847525e+07</td>\n",
       "      <td>3.139785e+08</td>\n",
       "      <td>1.045858e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.708046e+07</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>5088.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Iceland</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.913000e+03</td>\n",
       "      <td>3.548400e+05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.200000e+01</td>\n",
       "      <td>4.200838e+06</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Iceland</td>\n",
       "      <td>663.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.756933e+06</td>\n",
       "      <td>3.216439e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.431227e+07</td>\n",
       "      <td>2.610461e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>1814.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Italy</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.220771e+08</td>\n",
       "      <td>4.925954e+09</td>\n",
       "      <td>507902.0</td>\n",
       "      <td>2.425777e+09</td>\n",
       "      <td>2.053227e+10</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Italy</td>\n",
       "      <td>3170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Japan</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.415208e+08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.768902e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Japan</td>\n",
       "      <td>595.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Latvia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.726386e+07</td>\n",
       "      <td>1.244435e+08</td>\n",
       "      <td>2189.0</td>\n",
       "      <td>6.160848e+07</td>\n",
       "      <td>3.528115e+08</td>\n",
       "      <td>3.560000e+02</td>\n",
       "      <td>3.800000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Latvia</td>\n",
       "      <td>3456.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.646000e+03</td>\n",
       "      <td>1.543114e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.512990e+05</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>2449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Lithuania</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.440297e+06</td>\n",
       "      <td>1.224147e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.402843e+07</td>\n",
       "      <td>1.097743e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Lithuania</td>\n",
       "      <td>3642.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.596563e+06</td>\n",
       "      <td>5.942258e+06</td>\n",
       "      <td>532.0</td>\n",
       "      <td>4.841859e+06</td>\n",
       "      <td>2.516063e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>1918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Malta</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.202381e+06</td>\n",
       "      <td>4.502141e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.063862e+07</td>\n",
       "      <td>2.624406e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Malta</td>\n",
       "      <td>1917.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Nepal</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.118813e+08</td>\n",
       "      <td>1.812575e+08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.530906e+08</td>\n",
       "      <td>1.984490e+07</td>\n",
       "      <td>6.771564e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>398.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Netherlands</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.404599e+07</td>\n",
       "      <td>1.347043e+08</td>\n",
       "      <td>323.0</td>\n",
       "      <td>1.297025e+08</td>\n",
       "      <td>8.180842e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>1336.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Norway</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.614750e+05</td>\n",
       "      <td>6.222832e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.044875e+06</td>\n",
       "      <td>2.860577e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Norway</td>\n",
       "      <td>1018.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Peru</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.241190e+08</td>\n",
       "      <td>6.157883e+09</td>\n",
       "      <td>3.638123e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Peru</td>\n",
       "      <td>6569.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Poland</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.837319e+07</td>\n",
       "      <td>1.480395e+08</td>\n",
       "      <td>11067.0</td>\n",
       "      <td>2.452178e+08</td>\n",
       "      <td>1.342429e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Poland</td>\n",
       "      <td>3170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>3.906225e+07</td>\n",
       "      <td>9.117436e+07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.593523e+07</td>\n",
       "      <td>4.756099e+08</td>\n",
       "      <td>3.048300e+04</td>\n",
       "      <td>6.502200e+04</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>2658.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Romania</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.737618e+08</td>\n",
       "      <td>2.846886e+08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.030900e+08</td>\n",
       "      <td>3.290245e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Romania</td>\n",
       "      <td>3586.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.577868e+06</td>\n",
       "      <td>2.406459e+07</td>\n",
       "      <td>660.0</td>\n",
       "      <td>2.319607e+07</td>\n",
       "      <td>1.717788e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.805440e+05</td>\n",
       "      <td>Slovakia</td>\n",
       "      <td>3877.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Slovenia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.084514e+06</td>\n",
       "      <td>9.077059e+06</td>\n",
       "      <td>51.0</td>\n",
       "      <td>1.354594e+07</td>\n",
       "      <td>7.256522e+07</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Slovenia</td>\n",
       "      <td>3417.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.005567e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.203154e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>1689.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Spain</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.824416e+07</td>\n",
       "      <td>5.084171e+08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.316192e+08</td>\n",
       "      <td>2.244537e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Spain</td>\n",
       "      <td>2606.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.586669e+07</td>\n",
       "      <td>123.0</td>\n",
       "      <td>6.119736e+07</td>\n",
       "      <td>4.820933e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Sweden</td>\n",
       "      <td>2401.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Switzerland</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.809174e+06</td>\n",
       "      <td>2.327226e+09</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.356914e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>1647.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.987506e+06</td>\n",
       "      <td>4.637534e+08</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.451318e+08</td>\n",
       "      <td>1.810085e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.334709e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Ukraine</td>\n",
       "      <td>2603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>United States</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.872710e+09</td>\n",
       "      <td>5.529489e+10</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.977647e+10</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>United States</td>\n",
       "      <td>3494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.724333e+07</td>\n",
       "      <td>5.897267e+08</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.047603e+09</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2184.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         location      CanSino  Covaxin  Johnson&Johnson       Moderna  \\\n",
       "0       Argentina   53950431.0      0.0     0.000000e+00  8.933868e+08   \n",
       "1         Austria          0.0      0.0     1.263894e+07  5.436887e+07   \n",
       "2         Belgium          0.0      0.0     1.621113e+07  9.354474e+07   \n",
       "3        Bulgaria          0.0      0.0     1.198064e+07  1.560478e+07   \n",
       "4           Chile  153505458.0      0.0     0.000000e+00  0.000000e+00   \n",
       "5         Croatia          0.0      0.0     5.382836e+06  1.783213e+07   \n",
       "6          Cyprus          0.0      0.0     9.168150e+05  4.782633e+06   \n",
       "7         Czechia          0.0      0.0     8.293091e+07  3.552392e+08   \n",
       "8         Denmark          0.0      0.0     1.947563e+06  5.252257e+07   \n",
       "9         Ecuador   63941786.0      0.0     0.000000e+00  0.000000e+00   \n",
       "10        Estonia          0.0      0.0     2.382223e+06  7.100996e+06   \n",
       "11        Finland          0.0      0.0     0.000000e+00  4.801806e+07   \n",
       "12         France          0.0      0.0     2.978426e+08  4.074001e+09   \n",
       "13        Germany          0.0      0.0     9.205289e+08  4.719170e+09   \n",
       "14      Hong Kong          0.0      0.0     0.000000e+00  0.000000e+00   \n",
       "15        Hungary          0.0      0.0     9.331140e+06  3.786128e+07   \n",
       "16        Iceland          0.0      0.0     4.913000e+03  3.548400e+05   \n",
       "17        Ireland          0.0      0.0     8.756933e+06  3.216439e+07   \n",
       "18          Italy          0.0      0.0     4.220771e+08  4.925954e+09   \n",
       "19          Japan          0.0      0.0     0.000000e+00  1.415208e+08   \n",
       "20         Latvia          0.0      0.0     5.726386e+07  1.244435e+08   \n",
       "21  Liechtenstein          0.0      0.0     4.646000e+03  1.543114e+06   \n",
       "22      Lithuania          0.0      0.0     8.440297e+06  1.224147e+07   \n",
       "23     Luxembourg          0.0      0.0     1.596563e+06  5.942258e+06   \n",
       "24          Malta          0.0      0.0     1.202381e+06  4.502141e+06   \n",
       "25          Nepal          0.0      0.0     1.118813e+08  1.812575e+08   \n",
       "26    Netherlands          0.0      0.0     3.404599e+07  1.347043e+08   \n",
       "27         Norway          0.0      0.0     2.614750e+05  6.222832e+07   \n",
       "28           Peru          0.0      0.0     0.000000e+00  0.000000e+00   \n",
       "29         Poland          0.0      0.0     8.837319e+07  1.480395e+08   \n",
       "30       Portugal          0.0     66.0     3.906225e+07  9.117436e+07   \n",
       "31        Romania          0.0      0.0     3.737618e+08  2.846886e+08   \n",
       "32       Slovakia          0.0      0.0     4.577868e+06  2.406459e+07   \n",
       "33       Slovenia          0.0      0.0     4.084514e+06  9.077059e+06   \n",
       "34   South Africa          0.0      0.0     2.005567e+08  0.000000e+00   \n",
       "35          Spain          0.0      0.0     7.824416e+07  5.084171e+08   \n",
       "36         Sweden          0.0      0.0     0.000000e+00  8.586669e+07   \n",
       "37    Switzerland          0.0      0.0     7.809174e+06  2.327226e+09   \n",
       "38        Ukraine          0.0      0.0     3.987506e+06  4.637534e+08   \n",
       "39  United States          0.0      0.0     4.872710e+09  5.529489e+10   \n",
       "40        Uruguay          0.0      0.0     0.000000e+00  0.000000e+00   \n",
       "\n",
       "      Novavax  Oxford/AstraZeneca  Pfizer/BioNTech  Sinopharm/Beijing  \\\n",
       "0         0.0        5.618581e+09     1.307661e+09       5.713239e+09   \n",
       "1     11819.0        7.372778e+07     4.557673e+08       0.000000e+00   \n",
       "2       107.0        1.256663e+08     5.989736e+08       0.000000e+00   \n",
       "3         0.0        2.352012e+07     8.313276e+07       0.000000e+00   \n",
       "4         0.0        1.513017e+08     2.205676e+09       0.000000e+00   \n",
       "5       479.0        2.639237e+07     1.308606e+08       0.000000e+00   \n",
       "6        59.0        1.139933e+07     3.796457e+07       0.000000e+00   \n",
       "7     41996.0        2.252249e+08     3.441540e+09       0.000000e+00   \n",
       "8         0.0        8.301687e+06     3.475988e+08       0.000000e+00   \n",
       "9         0.0        5.740528e+08     1.399258e+09       0.000000e+00   \n",
       "10      207.0        1.151180e+07     4.942954e+07       0.000000e+00   \n",
       "11        0.0        2.676701e+07     2.991248e+08       0.000000e+00   \n",
       "12        0.0        2.579872e+09     2.522532e+10       0.000000e+00   \n",
       "13  1348545.0        4.188139e+09     2.915364e+10       0.000000e+00   \n",
       "14        0.0        0.000000e+00     1.643527e+09       0.000000e+00   \n",
       "15        0.0        5.847525e+07     3.139785e+08       1.045858e+08   \n",
       "16        0.0        7.200000e+01     4.200838e+06       0.000000e+00   \n",
       "17        0.0        4.431227e+07     2.610461e+08       0.000000e+00   \n",
       "18   507902.0        2.425777e+09     2.053227e+10       0.000000e+00   \n",
       "19        0.0        0.000000e+00     3.768902e+09       0.000000e+00   \n",
       "20     2189.0        6.160848e+07     3.528115e+08       3.560000e+02   \n",
       "21        0.0        0.000000e+00     7.512990e+05       0.000000e+00   \n",
       "22        0.0        2.402843e+07     1.097743e+08       0.000000e+00   \n",
       "23      532.0        4.841859e+06     2.516063e+07       0.000000e+00   \n",
       "24        0.0        1.063862e+07     2.624406e+07       0.000000e+00   \n",
       "25        0.0        3.530906e+08     1.984490e+07       6.771564e+08   \n",
       "26      323.0        1.297025e+08     8.180842e+08       0.000000e+00   \n",
       "27        0.0        8.044875e+06     2.860577e+08       0.000000e+00   \n",
       "28        0.0        7.241190e+08     6.157883e+09       3.638123e+09   \n",
       "29    11067.0        2.452178e+08     1.342429e+09       0.000000e+00   \n",
       "30        0.0        9.593523e+07     4.756099e+08       3.048300e+04   \n",
       "31        0.0        2.030900e+08     3.290245e+09       0.000000e+00   \n",
       "32      660.0        2.319607e+07     1.717788e+08       0.000000e+00   \n",
       "33       51.0        1.354594e+07     7.256522e+07       0.000000e+00   \n",
       "34        0.0        0.000000e+00     6.203154e+08       0.000000e+00   \n",
       "35        0.0        4.316192e+08     2.244537e+09       0.000000e+00   \n",
       "36      123.0        6.119736e+07     4.820933e+08       0.000000e+00   \n",
       "37        0.0        0.000000e+00     1.356914e+09       0.000000e+00   \n",
       "38        0.0        7.451318e+08     1.810085e+09       0.000000e+00   \n",
       "39        0.0        0.000000e+00     7.977647e+10       0.000000e+00   \n",
       "40        0.0        2.724333e+07     5.897267e+08       0.000000e+00   \n",
       "\n",
       "         Sinovac     Sputnik V        Country  Deaths/1M pop  \n",
       "0   0.000000e+00  5.092133e+09      Argentina         2837.0  \n",
       "1   0.000000e+00  0.000000e+00        Austria         2486.0  \n",
       "2   0.000000e+00  0.000000e+00        Belgium         2946.0  \n",
       "3   0.000000e+00  0.000000e+00       Bulgaria         5616.0  \n",
       "4   7.421275e+09  0.000000e+00          Chile         3350.0  \n",
       "5   0.000000e+00  0.000000e+00        Croatia         4504.0  \n",
       "6   0.000000e+00  0.000000e+00         Cyprus         1115.0  \n",
       "7   0.000000e+00  0.000000e+00        Czechia         3987.0  \n",
       "8   0.000000e+00  0.000000e+00        Denmark         1503.0  \n",
       "9   2.561852e+09  0.000000e+00        Ecuador         1990.0  \n",
       "10  0.000000e+00  0.000000e+00        Estonia         2270.0  \n",
       "11  0.000000e+00  0.000000e+00        Finland         1816.0  \n",
       "12  0.000000e+00  0.000000e+00         France         2556.0  \n",
       "13  0.000000e+00  0.000000e+00        Germany         2078.0  \n",
       "14  1.041142e+09  0.000000e+00      Hong Kong         1817.0  \n",
       "15  0.000000e+00  6.708046e+07        Hungary         5088.0  \n",
       "16  0.000000e+00  0.000000e+00        Iceland          663.0  \n",
       "17  0.000000e+00  0.000000e+00        Ireland         1814.0  \n",
       "18  0.000000e+00  0.000000e+00          Italy         3170.0  \n",
       "19  0.000000e+00  0.000000e+00          Japan          595.0  \n",
       "20  3.800000e+01  0.000000e+00         Latvia         3456.0  \n",
       "21  0.000000e+00  0.000000e+00  Liechtenstein         2449.0  \n",
       "22  0.000000e+00  0.000000e+00      Lithuania         3642.0  \n",
       "23  0.000000e+00  0.000000e+00     Luxembourg         1918.0  \n",
       "24  0.000000e+00  0.000000e+00          Malta         1917.0  \n",
       "25  0.000000e+00  0.000000e+00          Nepal          398.0  \n",
       "26  0.000000e+00  0.000000e+00    Netherlands         1336.0  \n",
       "27  0.000000e+00  0.000000e+00         Norway         1018.0  \n",
       "28  0.000000e+00  0.000000e+00           Peru         6569.0  \n",
       "29  0.000000e+00  0.000000e+00         Poland         3170.0  \n",
       "30  6.502200e+04  0.000000e+00       Portugal         2658.0  \n",
       "31  0.000000e+00  0.000000e+00        Romania         3586.0  \n",
       "32  0.000000e+00  3.805440e+05       Slovakia         3877.0  \n",
       "33  0.000000e+00  0.000000e+00       Slovenia         3417.0  \n",
       "34  0.000000e+00  0.000000e+00   South Africa         1689.0  \n",
       "35  0.000000e+00  0.000000e+00          Spain         2606.0  \n",
       "36  0.000000e+00  0.000000e+00         Sweden         2401.0  \n",
       "37  0.000000e+00  0.000000e+00    Switzerland         1647.0  \n",
       "38  1.334709e+09  0.000000e+00        Ukraine         2603.0  \n",
       "39  0.000000e+00  0.000000e+00  United States         3494.0  \n",
       "40  1.047603e+09  0.000000e+00        Uruguay         2184.0  "
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_combined.fillna(0, inplace=True)\n",
    "final_combined"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_combined = final_combined.reset_index(drop = True)\n",
    "final_combined.to_csv('Death_Rates.csv', index = False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "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>location</th>\n",
       "      <th>Deaths/1M pop</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Argentina</td>\n",
       "      <td>2837.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Austria</td>\n",
       "      <td>2486.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>2946.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>5616.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chile</td>\n",
       "      <td>3350.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Croatia</td>\n",
       "      <td>4504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Cyprus</td>\n",
       "      <td>1115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Czechia</td>\n",
       "      <td>3987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>1503.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ecuador</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Estonia</td>\n",
       "      <td>2270.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Finland</td>\n",
       "      <td>1816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>France</td>\n",
       "      <td>2556.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Germany</td>\n",
       "      <td>2078.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>1817.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Hungary</td>\n",
       "      <td>5088.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Iceland</td>\n",
       "      <td>663.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>1814.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Italy</td>\n",
       "      <td>3170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Japan</td>\n",
       "      <td>595.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Latvia</td>\n",
       "      <td>3456.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>2449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Lithuania</td>\n",
       "      <td>3642.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Luxembourg</td>\n",
       "      <td>1918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Malta</td>\n",
       "      <td>1917.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Nepal</td>\n",
       "      <td>398.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Netherlands</td>\n",
       "      <td>1336.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Norway</td>\n",
       "      <td>1018.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Peru</td>\n",
       "      <td>6569.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Poland</td>\n",
       "      <td>3170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>2658.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Romania</td>\n",
       "      <td>3586.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Slovakia</td>\n",
       "      <td>3877.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Slovenia</td>\n",
       "      <td>3417.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>1689.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Spain</td>\n",
       "      <td>2606.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Sweden</td>\n",
       "      <td>2401.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Switzerland</td>\n",
       "      <td>1647.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>2603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>United States</td>\n",
       "      <td>3494.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Uruguay</td>\n",
       "      <td>2184.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         location  Deaths/1M pop\n",
       "0       Argentina         2837.0\n",
       "1         Austria         2486.0\n",
       "2         Belgium         2946.0\n",
       "3        Bulgaria         5616.0\n",
       "4           Chile         3350.0\n",
       "5         Croatia         4504.0\n",
       "6          Cyprus         1115.0\n",
       "7         Czechia         3987.0\n",
       "8         Denmark         1503.0\n",
       "9         Ecuador         1990.0\n",
       "10        Estonia         2270.0\n",
       "11        Finland         1816.0\n",
       "12         France         2556.0\n",
       "13        Germany         2078.0\n",
       "14      Hong Kong         1817.0\n",
       "15        Hungary         5088.0\n",
       "16        Iceland          663.0\n",
       "17        Ireland         1814.0\n",
       "18          Italy         3170.0\n",
       "19          Japan          595.0\n",
       "20         Latvia         3456.0\n",
       "21  Liechtenstein         2449.0\n",
       "22      Lithuania         3642.0\n",
       "23     Luxembourg         1918.0\n",
       "24          Malta         1917.0\n",
       "25          Nepal          398.0\n",
       "26    Netherlands         1336.0\n",
       "27         Norway         1018.0\n",
       "28           Peru         6569.0\n",
       "29         Poland         3170.0\n",
       "30       Portugal         2658.0\n",
       "31        Romania         3586.0\n",
       "32       Slovakia         3877.0\n",
       "33       Slovenia         3417.0\n",
       "34   South Africa         1689.0\n",
       "35          Spain         2606.0\n",
       "36         Sweden         2401.0\n",
       "37    Switzerland         1647.0\n",
       "38        Ukraine         2603.0\n",
       "39  United States         3494.0\n",
       "40        Uruguay         2184.0"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "death_rates = final_combined[['location', 'Deaths/1M pop']]\n",
    "death_rates.to_csv('death_rates.csv', index = False)\n",
    "death_rates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2639.9024390243903"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "death_rates['Deaths/1M pop'].mean()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.9.15"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}