JS_Dashboard/processing_csv_to_json.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import dependancies\n",
    "import pandas as pd\n",
    "from pathlib import Path\n",
    "import numpy as np"
   ]
  },
  {
   "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>Row_ID</th>\n",
       "      <th>Case_Date</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Status</th>\n",
       "      <th>Outbreak_Related</th>\n",
       "      <th>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Reporting_PHU_Address</th>\n",
       "      <th>Reporting_PHU_City</th>\n",
       "      <th>Reporting_PHU_Postal_Code</th>\n",
       "      <th>Reporting_PHU_Website</th>\n",
       "      <th>Case_Month</th>\n",
       "      <th>Case_Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>353346</td>\n",
       "      <td>2020-12-20T00:00:00</td>\n",
       "      <td>70s</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>35075</td>\n",
       "      <td>2020-11-09T00:00:00</td>\n",
       "      <td>&lt;20</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>11</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>131941</td>\n",
       "      <td>2021-02-05T00:00:00</td>\n",
       "      <td>20s</td>\n",
       "      <td>MALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>Yes</td>\n",
       "      <td>2246</td>\n",
       "      <td>Niagara Region Public Health Department</td>\n",
       "      <td>1815 Sir Isaac Brock Way</td>\n",
       "      <td>Thorold</td>\n",
       "      <td>L2V 4T7</td>\n",
       "      <td>www.niagararegion.ca/health</td>\n",
       "      <td>2</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>205769</td>\n",
       "      <td>2020-12-29T00:00:00</td>\n",
       "      <td>20s</td>\n",
       "      <td>MALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>12</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>387018</td>\n",
       "      <td>2021-01-23T00:00:00</td>\n",
       "      <td>90+</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>Yes</td>\n",
       "      <td>2246</td>\n",
       "      <td>Niagara Region Public Health Department</td>\n",
       "      <td>1815 Sir Isaac Brock Way</td>\n",
       "      <td>Thorold</td>\n",
       "      <td>L2V 4T7</td>\n",
       "      <td>www.niagararegion.ca/health</td>\n",
       "      <td>1</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Row_ID            Case_Date Age_Group  Gender    Status Outbreak_Related  \\\n",
       "0  353346  2020-12-20T00:00:00       70s  FEMALE  Resolved              Yes   \n",
       "1   35075  2020-11-09T00:00:00       <20  FEMALE  Resolved              Yes   \n",
       "2  131941  2021-02-05T00:00:00       20s    MALE  Resolved              Yes   \n",
       "3  205769  2020-12-29T00:00:00       20s    MALE  Resolved              Yes   \n",
       "4  387018  2021-01-23T00:00:00       90+  FEMALE  Resolved              Yes   \n",
       "\n",
       "   PHU_ID                                      PHU  \\\n",
       "0    3895                    Toronto Public Health   \n",
       "1    3895                    Toronto Public Health   \n",
       "2    2246  Niagara Region Public Health Department   \n",
       "3    3895                    Toronto Public Health   \n",
       "4    2246  Niagara Region Public Health Department   \n",
       "\n",
       "            Reporting_PHU_Address Reporting_PHU_City  \\\n",
       "0  277 Victoria Street, 5th Floor            Toronto   \n",
       "1  277 Victoria Street, 5th Floor            Toronto   \n",
       "2        1815 Sir Isaac Brock Way            Thorold   \n",
       "3  277 Victoria Street, 5th Floor            Toronto   \n",
       "4        1815 Sir Isaac Brock Way            Thorold   \n",
       "\n",
       "  Reporting_PHU_Postal_Code  \\\n",
       "0                   M5B 1W2   \n",
       "1                   M5B 1W2   \n",
       "2                   L2V 4T7   \n",
       "3                   M5B 1W2   \n",
       "4                   L2V 4T7   \n",
       "\n",
       "                               Reporting_PHU_Website  Case_Month  Case_Year  \n",
       "0  www.toronto.ca/community-people/health-wellnes...          12       2020  \n",
       "1  www.toronto.ca/community-people/health-wellnes...          11       2020  \n",
       "2                        www.niagararegion.ca/health           2       2021  \n",
       "3  www.toronto.ca/community-people/health-wellnes...          12       2020  \n",
       "4                        www.niagararegion.ca/health           1       2021  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# reading in csv file\n",
    "file = Path('covid_data.csv')\n",
    "covid = pd.read_csv(file)\n",
    "covid.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "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>Age_Group</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Status</th>\n",
       "      <th>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Reporting_PHU_Address</th>\n",
       "      <th>Reporting_PHU_City</th>\n",
       "      <th>Reporting_PHU_Postal_Code</th>\n",
       "      <th>Reporting_PHU_Website</th>\n",
       "      <th>Case_Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>70s</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>&lt;20</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20s</td>\n",
       "      <td>MALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>2246</td>\n",
       "      <td>Niagara Region Public Health Department</td>\n",
       "      <td>1815 Sir Isaac Brock Way</td>\n",
       "      <td>Thorold</td>\n",
       "      <td>L2V 4T7</td>\n",
       "      <td>www.niagararegion.ca/health</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20s</td>\n",
       "      <td>MALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>90+</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>Resolved</td>\n",
       "      <td>2246</td>\n",
       "      <td>Niagara Region Public Health Department</td>\n",
       "      <td>1815 Sir Isaac Brock Way</td>\n",
       "      <td>Thorold</td>\n",
       "      <td>L2V 4T7</td>\n",
       "      <td>www.niagararegion.ca/health</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Age_Group  Gender    Status  PHU_ID  \\\n",
       "0       70s  FEMALE  Resolved    3895   \n",
       "1       <20  FEMALE  Resolved    3895   \n",
       "2       20s    MALE  Resolved    2246   \n",
       "3       20s    MALE  Resolved    3895   \n",
       "4       90+  FEMALE  Resolved    2246   \n",
       "\n",
       "                                       PHU           Reporting_PHU_Address  \\\n",
       "0                    Toronto Public Health  277 Victoria Street, 5th Floor   \n",
       "1                    Toronto Public Health  277 Victoria Street, 5th Floor   \n",
       "2  Niagara Region Public Health Department        1815 Sir Isaac Brock Way   \n",
       "3                    Toronto Public Health  277 Victoria Street, 5th Floor   \n",
       "4  Niagara Region Public Health Department        1815 Sir Isaac Brock Way   \n",
       "\n",
       "  Reporting_PHU_City Reporting_PHU_Postal_Code  \\\n",
       "0            Toronto                   M5B 1W2   \n",
       "1            Toronto                   M5B 1W2   \n",
       "2            Thorold                   L2V 4T7   \n",
       "3            Toronto                   M5B 1W2   \n",
       "4            Thorold                   L2V 4T7   \n",
       "\n",
       "                               Reporting_PHU_Website  Case_Year  \n",
       "0  www.toronto.ca/community-people/health-wellnes...       2020  \n",
       "1  www.toronto.ca/community-people/health-wellnes...       2020  \n",
       "2                        www.niagararegion.ca/health       2021  \n",
       "3  www.toronto.ca/community-people/health-wellnes...       2020  \n",
       "4                        www.niagararegion.ca/health       2021  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# dropping columns not required\n",
    "covid = covid.drop(columns=['Row_ID','Case_Date','Case_Month','Outbreak_Related'])\n",
    "covid.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# filling NaN valuesdd\n",
    "covid = covid.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# removing float values\n",
    "covid['PHU_ID'] = covid['PHU_ID'].astype(int)\n",
    "covid['Case_Year'] = covid['Case_Year'].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# converting to binary data\n",
    "df_one = pd.get_dummies(covid, columns=['Age_Group','Gender','Status','Case_Year'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['PHU_ID', 'PHU', 'Reporting_PHU_Address', 'Reporting_PHU_City',\n",
       "       'Reporting_PHU_Postal_Code', 'Reporting_PHU_Website', 'Age_Group_20s',\n",
       "       'Age_Group_30s', 'Age_Group_40s', 'Age_Group_50s', 'Age_Group_60s',\n",
       "       'Age_Group_70s', 'Age_Group_80s', 'Age_Group_90+', 'Age_Group_<20',\n",
       "       'Gender_FEMALE', 'Gender_GENDER DIVERSE', 'Gender_MALE',\n",
       "       'Gender_UNSPECIFIED', 'Status_Fatal', 'Status_Not Resolved',\n",
       "       'Status_Resolved', 'Case_Year_2020', 'Case_Year_2021', 'Age_Group',\n",
       "       'Gender', 'Status', 'Case_Year'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# merging dataframes\n",
    "covid_df = pd.concat((df_one, covid))\n",
    "covid_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# dropping duplicate columns\n",
    "df_two = covid_df.drop(columns=['Age_Group','Gender','Status','Case_Year'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal_Code</th>\n",
       "      <th>Website</th>\n",
       "      <th>Age_20s</th>\n",
       "      <th>Age_30s</th>\n",
       "      <th>Age_40s</th>\n",
       "      <th>Age_50s</th>\n",
       "      <th>...</th>\n",
       "      <th>Age_Under_20</th>\n",
       "      <th>Female</th>\n",
       "      <th>Gender_Diverse</th>\n",
       "      <th>Male</th>\n",
       "      <th>Unspecified</th>\n",
       "      <th>Fatal</th>\n",
       "      <th>Not_Resolved</th>\n",
       "      <th>Resolved</th>\n",
       "      <th>Cases_in_2020</th>\n",
       "      <th>Cases_in_2021</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2246</td>\n",
       "      <td>Niagara Region Public Health Department</td>\n",
       "      <td>1815 Sir Isaac Brock Way</td>\n",
       "      <td>Thorold</td>\n",
       "      <td>L2V 4T7</td>\n",
       "      <td>www.niagararegion.ca/health</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2246</td>\n",
       "      <td>Niagara Region Public Health Department</td>\n",
       "      <td>1815 Sir Isaac Brock Way</td>\n",
       "      <td>Thorold</td>\n",
       "      <td>L2V 4T7</td>\n",
       "      <td>www.niagararegion.ca/health</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13519</th>\n",
       "      <td>2253</td>\n",
       "      <td>Peel Public Health</td>\n",
       "      <td>7120 Hurontario Street</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>L5W 1N4</td>\n",
       "      <td>www.peelregion.ca/health/</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13520</th>\n",
       "      <td>2261</td>\n",
       "      <td>Sudbury &amp; District Health Unit</td>\n",
       "      <td>1300 Paris Street</td>\n",
       "      <td>Sudbury</td>\n",
       "      <td>P3E 3A3</td>\n",
       "      <td>www.phsd.ca</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13521</th>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13522</th>\n",
       "      <td>2253</td>\n",
       "      <td>Peel Public Health</td>\n",
       "      <td>7120 Hurontario Street</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>L5W 1N4</td>\n",
       "      <td>www.peelregion.ca/health/</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13523</th>\n",
       "      <td>2253</td>\n",
       "      <td>Peel Public Health</td>\n",
       "      <td>7120 Hurontario Street</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>L5W 1N4</td>\n",
       "      <td>www.peelregion.ca/health/</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27048 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       PHU_ID                                      PHU  \\\n",
       "0        3895                    Toronto Public Health   \n",
       "1        3895                    Toronto Public Health   \n",
       "2        2246  Niagara Region Public Health Department   \n",
       "3        3895                    Toronto Public Health   \n",
       "4        2246  Niagara Region Public Health Department   \n",
       "...       ...                                      ...   \n",
       "13519    2253                       Peel Public Health   \n",
       "13520    2261           Sudbury & District Health Unit   \n",
       "13521    3895                    Toronto Public Health   \n",
       "13522    2253                       Peel Public Health   \n",
       "13523    2253                       Peel Public Health   \n",
       "\n",
       "                              Address         City Postal_Code  \\\n",
       "0      277 Victoria Street, 5th Floor      Toronto     M5B 1W2   \n",
       "1      277 Victoria Street, 5th Floor      Toronto     M5B 1W2   \n",
       "2            1815 Sir Isaac Brock Way      Thorold     L2V 4T7   \n",
       "3      277 Victoria Street, 5th Floor      Toronto     M5B 1W2   \n",
       "4            1815 Sir Isaac Brock Way      Thorold     L2V 4T7   \n",
       "...                               ...          ...         ...   \n",
       "13519          7120 Hurontario Street  Mississauga     L5W 1N4   \n",
       "13520               1300 Paris Street      Sudbury     P3E 3A3   \n",
       "13521  277 Victoria Street, 5th Floor      Toronto     M5B 1W2   \n",
       "13522          7120 Hurontario Street  Mississauga     L5W 1N4   \n",
       "13523          7120 Hurontario Street  Mississauga     L5W 1N4   \n",
       "\n",
       "                                                 Website  Age_20s  Age_30s  \\\n",
       "0      www.toronto.ca/community-people/health-wellnes...      0.0      0.0   \n",
       "1      www.toronto.ca/community-people/health-wellnes...      0.0      0.0   \n",
       "2                            www.niagararegion.ca/health      1.0      0.0   \n",
       "3      www.toronto.ca/community-people/health-wellnes...      1.0      0.0   \n",
       "4                            www.niagararegion.ca/health      0.0      0.0   \n",
       "...                                                  ...      ...      ...   \n",
       "13519                          www.peelregion.ca/health/      NaN      NaN   \n",
       "13520                                        www.phsd.ca      NaN      NaN   \n",
       "13521  www.toronto.ca/community-people/health-wellnes...      NaN      NaN   \n",
       "13522                          www.peelregion.ca/health/      NaN      NaN   \n",
       "13523                          www.peelregion.ca/health/      NaN      NaN   \n",
       "\n",
       "       Age_40s  Age_50s  ...  Age_Under_20  Female  Gender_Diverse  Male  \\\n",
       "0          0.0      0.0  ...           0.0     1.0             0.0   0.0   \n",
       "1          0.0      0.0  ...           1.0     1.0             0.0   0.0   \n",
       "2          0.0      0.0  ...           0.0     0.0             0.0   1.0   \n",
       "3          0.0      0.0  ...           0.0     0.0             0.0   1.0   \n",
       "4          0.0      0.0  ...           0.0     1.0             0.0   0.0   \n",
       "...        ...      ...  ...           ...     ...             ...   ...   \n",
       "13519      NaN      NaN  ...           NaN     NaN             NaN   NaN   \n",
       "13520      NaN      NaN  ...           NaN     NaN             NaN   NaN   \n",
       "13521      NaN      NaN  ...           NaN     NaN             NaN   NaN   \n",
       "13522      NaN      NaN  ...           NaN     NaN             NaN   NaN   \n",
       "13523      NaN      NaN  ...           NaN     NaN             NaN   NaN   \n",
       "\n",
       "       Unspecified  Fatal  Not_Resolved  Resolved  Cases_in_2020  \\\n",
       "0              0.0    0.0           0.0       1.0            1.0   \n",
       "1              0.0    0.0           0.0       1.0            1.0   \n",
       "2              0.0    0.0           0.0       1.0            0.0   \n",
       "3              0.0    0.0           0.0       1.0            1.0   \n",
       "4              0.0    0.0           0.0       1.0            0.0   \n",
       "...            ...    ...           ...       ...            ...   \n",
       "13519          NaN    NaN           NaN       NaN            NaN   \n",
       "13520          NaN    NaN           NaN       NaN            NaN   \n",
       "13521          NaN    NaN           NaN       NaN            NaN   \n",
       "13522          NaN    NaN           NaN       NaN            NaN   \n",
       "13523          NaN    NaN           NaN       NaN            NaN   \n",
       "\n",
       "       Cases_in_2021  \n",
       "0                0.0  \n",
       "1                0.0  \n",
       "2                1.0  \n",
       "3                0.0  \n",
       "4                1.0  \n",
       "...              ...  \n",
       "13519            NaN  \n",
       "13520            NaN  \n",
       "13521            NaN  \n",
       "13522            NaN  \n",
       "13523            NaN  \n",
       "\n",
       "[27048 rows x 24 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# renaming columns for efficiency and readable by JS\n",
    "clean_covid = df_two.rename(columns={'Age_Group_<20':'Age_Under_20',\n",
    "                        'Age_Group_20s':'Age_20s',\n",
    "                        'Age_Group_30s':'Age_30s',\n",
    "                        'Age_Group_40s':'Age_40s',\n",
    "                        'Age_Group_50s':'Age_50s',\n",
    "                        'Age_Group_60s':'Age_60s',\n",
    "                        'Age_Group_70s':'Age_70s',\n",
    "                        'Age_Group_80s':'Age_80s',\n",
    "                        'Age_Group_90+':'Age_Over_90',\n",
    "                        'Gender_FEMALE':'Female',\n",
    "                        'Gender_MALE':'Male',\n",
    "                        'Gender_GENDER DIVERSE':'Gender_Diverse',\n",
    "                        'Gender_UNSPECIFIED':'Unspecified',\n",
    "                        'Status_Fatal':'Fatal',\n",
    "                        'Status_Not Resolved':'Not_Resolved',\n",
    "                        'Status_Resolved':'Resolved',\n",
    "                        'Case_Year_2020':'Cases_in_2020',\n",
    "                        'Case_Year_2021':'Cases_in_2021',\n",
    "                        'Reporting_PHU_Address':'Address',\n",
    "                        'Reporting_PHU_City':'City',\n",
    "                        'Reporting_PHU_Postal_Code':'Postal_Code',\n",
    "                        'Reporting_PHU_Website':'Website'})\n",
    "clean_covid"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": false
   },
   "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>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal_Code</th>\n",
       "      <th>Website</th>\n",
       "      <th>Age_20s</th>\n",
       "      <th>Age_30s</th>\n",
       "      <th>Age_40s</th>\n",
       "      <th>Age_50s</th>\n",
       "      <th>...</th>\n",
       "      <th>Age_Under_20</th>\n",
       "      <th>Female</th>\n",
       "      <th>Gender_Diverse</th>\n",
       "      <th>Male</th>\n",
       "      <th>Unspecified</th>\n",
       "      <th>Fatal</th>\n",
       "      <th>Not_Resolved</th>\n",
       "      <th>Resolved</th>\n",
       "      <th>Cases_in_2020</th>\n",
       "      <th>Cases_in_2021</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2246</td>\n",
       "      <td>Niagara Region Public Health Department</td>\n",
       "      <td>1815 Sir Isaac Brock Way</td>\n",
       "      <td>Thorold</td>\n",
       "      <td>L2V 4T7</td>\n",
       "      <td>www.niagararegion.ca/health</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2246</td>\n",
       "      <td>Niagara Region Public Health Department</td>\n",
       "      <td>1815 Sir Isaac Brock Way</td>\n",
       "      <td>Thorold</td>\n",
       "      <td>L2V 4T7</td>\n",
       "      <td>www.niagararegion.ca/health</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13519</th>\n",
       "      <td>2253</td>\n",
       "      <td>Peel Public Health</td>\n",
       "      <td>7120 Hurontario Street</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>L5W 1N4</td>\n",
       "      <td>www.peelregion.ca/health/</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13520</th>\n",
       "      <td>2261</td>\n",
       "      <td>Sudbury &amp; District Health Unit</td>\n",
       "      <td>1300 Paris Street</td>\n",
       "      <td>Sudbury</td>\n",
       "      <td>P3E 3A3</td>\n",
       "      <td>www.phsd.ca</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13521</th>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13522</th>\n",
       "      <td>2253</td>\n",
       "      <td>Peel Public Health</td>\n",
       "      <td>7120 Hurontario Street</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>L5W 1N4</td>\n",
       "      <td>www.peelregion.ca/health/</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13523</th>\n",
       "      <td>2253</td>\n",
       "      <td>Peel Public Health</td>\n",
       "      <td>7120 Hurontario Street</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>L5W 1N4</td>\n",
       "      <td>www.peelregion.ca/health/</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27048 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       PHU_ID                                      PHU  \\\n",
       "0        3895                    Toronto Public Health   \n",
       "1        3895                    Toronto Public Health   \n",
       "2        2246  Niagara Region Public Health Department   \n",
       "3        3895                    Toronto Public Health   \n",
       "4        2246  Niagara Region Public Health Department   \n",
       "...       ...                                      ...   \n",
       "13519    2253                       Peel Public Health   \n",
       "13520    2261           Sudbury & District Health Unit   \n",
       "13521    3895                    Toronto Public Health   \n",
       "13522    2253                       Peel Public Health   \n",
       "13523    2253                       Peel Public Health   \n",
       "\n",
       "                              Address         City Postal_Code  \\\n",
       "0      277 Victoria Street, 5th Floor      Toronto     M5B 1W2   \n",
       "1      277 Victoria Street, 5th Floor      Toronto     M5B 1W2   \n",
       "2            1815 Sir Isaac Brock Way      Thorold     L2V 4T7   \n",
       "3      277 Victoria Street, 5th Floor      Toronto     M5B 1W2   \n",
       "4            1815 Sir Isaac Brock Way      Thorold     L2V 4T7   \n",
       "...                               ...          ...         ...   \n",
       "13519          7120 Hurontario Street  Mississauga     L5W 1N4   \n",
       "13520               1300 Paris Street      Sudbury     P3E 3A3   \n",
       "13521  277 Victoria Street, 5th Floor      Toronto     M5B 1W2   \n",
       "13522          7120 Hurontario Street  Mississauga     L5W 1N4   \n",
       "13523          7120 Hurontario Street  Mississauga     L5W 1N4   \n",
       "\n",
       "                                                 Website  Age_20s  Age_30s  \\\n",
       "0      www.toronto.ca/community-people/health-wellnes...      0.0      0.0   \n",
       "1      www.toronto.ca/community-people/health-wellnes...      0.0      0.0   \n",
       "2                            www.niagararegion.ca/health      1.0      0.0   \n",
       "3      www.toronto.ca/community-people/health-wellnes...      1.0      0.0   \n",
       "4                            www.niagararegion.ca/health      0.0      0.0   \n",
       "...                                                  ...      ...      ...   \n",
       "13519                          www.peelregion.ca/health/      0.0      0.0   \n",
       "13520                                        www.phsd.ca      0.0      0.0   \n",
       "13521  www.toronto.ca/community-people/health-wellnes...      0.0      0.0   \n",
       "13522                          www.peelregion.ca/health/      0.0      0.0   \n",
       "13523                          www.peelregion.ca/health/      0.0      0.0   \n",
       "\n",
       "       Age_40s  Age_50s  ...  Age_Under_20  Female  Gender_Diverse  Male  \\\n",
       "0          0.0      0.0  ...           0.0     1.0             0.0   0.0   \n",
       "1          0.0      0.0  ...           1.0     1.0             0.0   0.0   \n",
       "2          0.0      0.0  ...           0.0     0.0             0.0   1.0   \n",
       "3          0.0      0.0  ...           0.0     0.0             0.0   1.0   \n",
       "4          0.0      0.0  ...           0.0     1.0             0.0   0.0   \n",
       "...        ...      ...  ...           ...     ...             ...   ...   \n",
       "13519      0.0      0.0  ...           0.0     0.0             0.0   0.0   \n",
       "13520      0.0      0.0  ...           0.0     0.0             0.0   0.0   \n",
       "13521      0.0      0.0  ...           0.0     0.0             0.0   0.0   \n",
       "13522      0.0      0.0  ...           0.0     0.0             0.0   0.0   \n",
       "13523      0.0      0.0  ...           0.0     0.0             0.0   0.0   \n",
       "\n",
       "       Unspecified  Fatal  Not_Resolved  Resolved  Cases_in_2020  \\\n",
       "0              0.0    0.0           0.0       1.0            1.0   \n",
       "1              0.0    0.0           0.0       1.0            1.0   \n",
       "2              0.0    0.0           0.0       1.0            0.0   \n",
       "3              0.0    0.0           0.0       1.0            1.0   \n",
       "4              0.0    0.0           0.0       1.0            0.0   \n",
       "...            ...    ...           ...       ...            ...   \n",
       "13519          0.0    0.0           0.0       0.0            0.0   \n",
       "13520          0.0    0.0           0.0       0.0            0.0   \n",
       "13521          0.0    0.0           0.0       0.0            0.0   \n",
       "13522          0.0    0.0           0.0       0.0            0.0   \n",
       "13523          0.0    0.0           0.0       0.0            0.0   \n",
       "\n",
       "       Cases_in_2021  \n",
       "0                0.0  \n",
       "1                0.0  \n",
       "2                1.0  \n",
       "3                0.0  \n",
       "4                1.0  \n",
       "...              ...  \n",
       "13519            0.0  \n",
       "13520            0.0  \n",
       "13521            0.0  \n",
       "13522            0.0  \n",
       "13523            0.0  \n",
       "\n",
       "[27048 rows x 24 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# fill in NaN values\n",
    "clean_covid.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "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></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Age_Under_20</th>\n",
       "      <th>Age_20s</th>\n",
       "      <th>Age_30s</th>\n",
       "      <th>Age_40s</th>\n",
       "      <th>Age_50s</th>\n",
       "      <th>Age_60s</th>\n",
       "      <th>Age_70s</th>\n",
       "      <th>Age_80s</th>\n",
       "      <th>Age_Over_90</th>\n",
       "      <th>Female</th>\n",
       "      <th>Male</th>\n",
       "      <th>Gender_Diverse</th>\n",
       "      <th>Unspecified</th>\n",
       "      <th>Fatal</th>\n",
       "      <th>Not_Resolved</th>\n",
       "      <th>Resolved</th>\n",
       "      <th>Cases_in_2020</th>\n",
       "      <th>Cases_in_2021</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal_Code</th>\n",
       "      <th>Website</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2226</th>\n",
       "      <th>Algoma Public Health Unit</th>\n",
       "      <th>294 Willow Avenue</th>\n",
       "      <th>Sault Ste. Marie</th>\n",
       "      <th>P6B 0A9</th>\n",
       "      <th>www.algomapublichealth.com</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2227</th>\n",
       "      <th>Brant County Health Unit</th>\n",
       "      <th>194 Terrace Hill Street</th>\n",
       "      <th>Brantford</th>\n",
       "      <th>N3R 1G7</th>\n",
       "      <th>www.bchu.org/</th>\n",
       "      <td>15.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>51.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2230</th>\n",
       "      <th>Durham Region Health Department</th>\n",
       "      <th>605 Rossland Road East</th>\n",
       "      <th>Whitby</th>\n",
       "      <th>L1N 0B2</th>\n",
       "      <th>www.durham.ca/en/health-and-wellness/health-and-wellness.aspx</th>\n",
       "      <td>81.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>298.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2233</th>\n",
       "      <th>Grey Bruce Health Unit</th>\n",
       "      <th>101 17th Street East</th>\n",
       "      <th>Owen Sound</th>\n",
       "      <th>N4K 0A5</th>\n",
       "      <th>www.publichealthgreybruce.on.ca/</th>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2234</th>\n",
       "      <th>Haldimand-Norfolk Health Unit</th>\n",
       "      <th>12 Gilbertson Drive</th>\n",
       "      <th>Simcoe</th>\n",
       "      <th>N3Y 4N5</th>\n",
       "      <th>www.hnhu.org</th>\n",
       "      <td>7.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                                Age_Under_20  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                            \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                                   1.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                               15.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...          81.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                            10.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                                 7.0   \n",
       "\n",
       "                                                                                                                                                Age_20s  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                       \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                              5.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                          13.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...     70.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                        1.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                           19.0   \n",
       "\n",
       "                                                                                                                                                Age_30s  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                       \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                              3.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                          13.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...     80.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                        1.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                           20.0   \n",
       "\n",
       "                                                                                                                                                Age_40s  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                       \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                              2.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                          12.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...     97.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                        6.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                           26.0   \n",
       "\n",
       "                                                                                                                                                Age_50s  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                       \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                              0.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                           8.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...    109.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                        6.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                           20.0   \n",
       "\n",
       "                                                                                                                                                Age_60s  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                       \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                              1.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                           6.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...     45.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                        2.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                            5.0   \n",
       "\n",
       "                                                                                                                                                Age_70s  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                       \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                              0.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                           2.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...     28.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                        1.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                            4.0   \n",
       "\n",
       "                                                                                                                                                Age_80s  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                       \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                              0.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                           2.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...     57.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                        3.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                            3.0   \n",
       "\n",
       "                                                                                                                                                Age_Over_90  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                           \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                                  0.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                               0.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...         42.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                            1.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                                7.0   \n",
       "\n",
       "                                                                                                                                                Female  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                      \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                             4.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                         33.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...   378.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                      19.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                          44.0   \n",
       "\n",
       "                                                                                                                                                 Male  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                     \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                            8.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                        38.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...  231.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                     12.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                         66.0   \n",
       "\n",
       "                                                                                                                                                Gender_Diverse  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                              \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                                     0.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                                  0.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...             0.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                               0.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                                   0.0   \n",
       "\n",
       "                                                                                                                                                Unspecified  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                           \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                                  0.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                               0.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...          0.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                            0.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                                1.0   \n",
       "\n",
       "                                                                                                                                                Fatal  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                     \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                            0.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                         2.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...   39.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                      0.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                          1.0   \n",
       "\n",
       "                                                                                                                                                Not_Resolved  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                            \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                                   0.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                                0.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...          22.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                             0.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                                 2.0   \n",
       "\n",
       "                                                                                                                                                Resolved  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                        \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                              12.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                           69.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...     548.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                        31.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                           108.0   \n",
       "\n",
       "                                                                                                                                                Cases_in_2020  \\\n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                             \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                                    3.0   \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                                20.0   \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...          311.0   \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                             11.0   \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                                 62.0   \n",
       "\n",
       "                                                                                                                                                Cases_in_2021  \n",
       "PHU_ID PHU                             Address                 City             Postal_Code Website                                                            \n",
       "2226   Algoma Public Health Unit       294 Willow Avenue       Sault Ste. Marie P6B 0A9     www.algomapublichealth.com                                    9.0  \n",
       "2227   Brant County Health Unit        194 Terrace Hill Street Brantford        N3R 1G7     www.bchu.org/                                                51.0  \n",
       "2230   Durham Region Health Department 605 Rossland Road East  Whitby           L1N 0B2     www.durham.ca/en/health-and-wellness/health-and...          298.0  \n",
       "2233   Grey Bruce Health Unit          101 17th Street East    Owen Sound       N4K 0A5     www.publichealthgreybruce.on.ca/                             20.0  \n",
       "2234   Haldimand-Norfolk Health Unit   12 Gilbertson Drive     Simcoe           N3Y 4N5     www.hnhu.org                                                 49.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# grouping by PHU_ID and summing values associated\n",
    "phu_status = clean_covid.groupby(['PHU_ID','PHU','Address','City','Postal_Code','Website'])[['Age_Under_20','Age_20s',\n",
    "                                                                        'Age_30s','Age_40s','Age_50s','Age_60s','Age_70s',\n",
    "                                                                        'Age_80s','Age_Over_90','Female','Male',\n",
    "                                                                        'Gender_Diverse','Unspecified','Fatal',\n",
    "                                                                        'Not_Resolved','Resolved','Cases_in_2020',\n",
    "                                                                            'Cases_in_2021']].apply(sum)\n",
    "phu_status.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "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>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal_Code</th>\n",
       "      <th>Website</th>\n",
       "      <th>Age_Under_20</th>\n",
       "      <th>Age_20s</th>\n",
       "      <th>Age_30s</th>\n",
       "      <th>Age_40s</th>\n",
       "      <th>...</th>\n",
       "      <th>Age_Over_90</th>\n",
       "      <th>Female</th>\n",
       "      <th>Male</th>\n",
       "      <th>Gender_Diverse</th>\n",
       "      <th>Unspecified</th>\n",
       "      <th>Fatal</th>\n",
       "      <th>Not_Resolved</th>\n",
       "      <th>Resolved</th>\n",
       "      <th>Cases_in_2020</th>\n",
       "      <th>Cases_in_2021</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2226</td>\n",
       "      <td>Algoma Public Health Unit</td>\n",
       "      <td>294 Willow Avenue</td>\n",
       "      <td>Sault Ste. Marie</td>\n",
       "      <td>P6B 0A9</td>\n",
       "      <td>www.algomapublichealth.com</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2227</td>\n",
       "      <td>Brant County Health Unit</td>\n",
       "      <td>194 Terrace Hill Street</td>\n",
       "      <td>Brantford</td>\n",
       "      <td>N3R 1G7</td>\n",
       "      <td>www.bchu.org/</td>\n",
       "      <td>15.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>51.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2230</td>\n",
       "      <td>Durham Region Health Department</td>\n",
       "      <td>605 Rossland Road East</td>\n",
       "      <td>Whitby</td>\n",
       "      <td>L1N 0B2</td>\n",
       "      <td>www.durham.ca/en/health-and-wellness/health-an...</td>\n",
       "      <td>81.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>...</td>\n",
       "      <td>42.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>298.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2233</td>\n",
       "      <td>Grey Bruce Health Unit</td>\n",
       "      <td>101 17th Street East</td>\n",
       "      <td>Owen Sound</td>\n",
       "      <td>N4K 0A5</td>\n",
       "      <td>www.publichealthgreybruce.on.ca/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2234</td>\n",
       "      <td>Haldimand-Norfolk Health Unit</td>\n",
       "      <td>12 Gilbertson Drive</td>\n",
       "      <td>Simcoe</td>\n",
       "      <td>N3Y 4N5</td>\n",
       "      <td>www.hnhu.org</td>\n",
       "      <td>7.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   PHU_ID                              PHU                  Address  \\\n",
       "0    2226        Algoma Public Health Unit        294 Willow Avenue   \n",
       "1    2227         Brant County Health Unit  194 Terrace Hill Street   \n",
       "2    2230  Durham Region Health Department   605 Rossland Road East   \n",
       "3    2233           Grey Bruce Health Unit     101 17th Street East   \n",
       "4    2234    Haldimand-Norfolk Health Unit      12 Gilbertson Drive   \n",
       "\n",
       "               City Postal_Code  \\\n",
       "0  Sault Ste. Marie     P6B 0A9   \n",
       "1         Brantford     N3R 1G7   \n",
       "2            Whitby     L1N 0B2   \n",
       "3        Owen Sound     N4K 0A5   \n",
       "4            Simcoe     N3Y 4N5   \n",
       "\n",
       "                                             Website  Age_Under_20  Age_20s  \\\n",
       "0                         www.algomapublichealth.com           1.0      5.0   \n",
       "1                                      www.bchu.org/          15.0     13.0   \n",
       "2  www.durham.ca/en/health-and-wellness/health-an...          81.0     70.0   \n",
       "3                   www.publichealthgreybruce.on.ca/          10.0      1.0   \n",
       "4                                       www.hnhu.org           7.0     19.0   \n",
       "\n",
       "   Age_30s  Age_40s  ...  Age_Over_90  Female   Male  Gender_Diverse  \\\n",
       "0      3.0      2.0  ...          0.0     4.0    8.0             0.0   \n",
       "1     13.0     12.0  ...          0.0    33.0   38.0             0.0   \n",
       "2     80.0     97.0  ...         42.0   378.0  231.0             0.0   \n",
       "3      1.0      6.0  ...          1.0    19.0   12.0             0.0   \n",
       "4     20.0     26.0  ...          7.0    44.0   66.0             0.0   \n",
       "\n",
       "   Unspecified  Fatal  Not_Resolved  Resolved  Cases_in_2020  Cases_in_2021  \n",
       "0          0.0    0.0           0.0      12.0            3.0            9.0  \n",
       "1          0.0    2.0           0.0      69.0           20.0           51.0  \n",
       "2          0.0   39.0          22.0     548.0          311.0          298.0  \n",
       "3          0.0    0.0           0.0      31.0           11.0           20.0  \n",
       "4          1.0    1.0           2.0     108.0           62.0           49.0  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# resetting index into columns\n",
    "phu = phu_status.reset_index(level=['PHU_ID','PHU','Address','City','Postal_Code','Website'])\n",
    "phu.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "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>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal_Code</th>\n",
       "      <th>Website</th>\n",
       "      <th>Age_Under_20</th>\n",
       "      <th>Age_20s</th>\n",
       "      <th>Age_30s</th>\n",
       "      <th>Age_40s</th>\n",
       "      <th>...</th>\n",
       "      <th>Female</th>\n",
       "      <th>Male</th>\n",
       "      <th>Gender_Diverse</th>\n",
       "      <th>Unspecified</th>\n",
       "      <th>Fatal</th>\n",
       "      <th>Not_Resolved</th>\n",
       "      <th>Resolved</th>\n",
       "      <th>Cases_in_2020</th>\n",
       "      <th>Cases_in_2021</th>\n",
       "      <th>Total_Cases</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2226</td>\n",
       "      <td>Algoma Public Health Unit</td>\n",
       "      <td>294 Willow Avenue</td>\n",
       "      <td>Sault Ste. Marie</td>\n",
       "      <td>P6B 0A9</td>\n",
       "      <td>www.algomapublichealth.com</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2227</td>\n",
       "      <td>Brant County Health Unit</td>\n",
       "      <td>194 Terrace Hill Street</td>\n",
       "      <td>Brantford</td>\n",
       "      <td>N3R 1G7</td>\n",
       "      <td>www.bchu.org/</td>\n",
       "      <td>15.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>...</td>\n",
       "      <td>33.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>71.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2230</td>\n",
       "      <td>Durham Region Health Department</td>\n",
       "      <td>605 Rossland Road East</td>\n",
       "      <td>Whitby</td>\n",
       "      <td>L1N 0B2</td>\n",
       "      <td>www.durham.ca/en/health-and-wellness/health-an...</td>\n",
       "      <td>81.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>...</td>\n",
       "      <td>378.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>298.0</td>\n",
       "      <td>609.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2233</td>\n",
       "      <td>Grey Bruce Health Unit</td>\n",
       "      <td>101 17th Street East</td>\n",
       "      <td>Owen Sound</td>\n",
       "      <td>N4K 0A5</td>\n",
       "      <td>www.publichealthgreybruce.on.ca/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>19.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2234</td>\n",
       "      <td>Haldimand-Norfolk Health Unit</td>\n",
       "      <td>12 Gilbertson Drive</td>\n",
       "      <td>Simcoe</td>\n",
       "      <td>N3Y 4N5</td>\n",
       "      <td>www.hnhu.org</td>\n",
       "      <td>7.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>...</td>\n",
       "      <td>44.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   PHU_ID                              PHU                  Address  \\\n",
       "0    2226        Algoma Public Health Unit        294 Willow Avenue   \n",
       "1    2227         Brant County Health Unit  194 Terrace Hill Street   \n",
       "2    2230  Durham Region Health Department   605 Rossland Road East   \n",
       "3    2233           Grey Bruce Health Unit     101 17th Street East   \n",
       "4    2234    Haldimand-Norfolk Health Unit      12 Gilbertson Drive   \n",
       "\n",
       "               City Postal_Code  \\\n",
       "0  Sault Ste. Marie     P6B 0A9   \n",
       "1         Brantford     N3R 1G7   \n",
       "2            Whitby     L1N 0B2   \n",
       "3        Owen Sound     N4K 0A5   \n",
       "4            Simcoe     N3Y 4N5   \n",
       "\n",
       "                                             Website  Age_Under_20  Age_20s  \\\n",
       "0                         www.algomapublichealth.com           1.0      5.0   \n",
       "1                                      www.bchu.org/          15.0     13.0   \n",
       "2  www.durham.ca/en/health-and-wellness/health-an...          81.0     70.0   \n",
       "3                   www.publichealthgreybruce.on.ca/          10.0      1.0   \n",
       "4                                       www.hnhu.org           7.0     19.0   \n",
       "\n",
       "   Age_30s  Age_40s  ...  Female   Male  Gender_Diverse  Unspecified  Fatal  \\\n",
       "0      3.0      2.0  ...     4.0    8.0             0.0          0.0    0.0   \n",
       "1     13.0     12.0  ...    33.0   38.0             0.0          0.0    2.0   \n",
       "2     80.0     97.0  ...   378.0  231.0             0.0          0.0   39.0   \n",
       "3      1.0      6.0  ...    19.0   12.0             0.0          0.0    0.0   \n",
       "4     20.0     26.0  ...    44.0   66.0             0.0          1.0    1.0   \n",
       "\n",
       "   Not_Resolved  Resolved  Cases_in_2020  Cases_in_2021  Total_Cases  \n",
       "0           0.0      12.0            3.0            9.0         12.0  \n",
       "1           0.0      69.0           20.0           51.0         71.0  \n",
       "2          22.0     548.0          311.0          298.0        609.0  \n",
       "3           0.0      31.0           11.0           20.0         31.0  \n",
       "4           2.0     108.0           62.0           49.0        111.0  \n",
       "\n",
       "[5 rows x 25 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# creating total columns\n",
    "total = phu['Cases_in_2020'] + phu['Cases_in_2021']\n",
    "phu['Total_Cases'] = total\n",
    "phu.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "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>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal_Code</th>\n",
       "      <th>Website</th>\n",
       "      <th>Age_Under_20</th>\n",
       "      <th>Age_20s</th>\n",
       "      <th>Age_30s</th>\n",
       "      <th>Age_40s</th>\n",
       "      <th>...</th>\n",
       "      <th>Male</th>\n",
       "      <th>Gender_Diverse</th>\n",
       "      <th>Unspecified</th>\n",
       "      <th>Fatal</th>\n",
       "      <th>Not_Resolved</th>\n",
       "      <th>Resolved</th>\n",
       "      <th>Cases_in_2020</th>\n",
       "      <th>Cases_in_2021</th>\n",
       "      <th>Total_Cases</th>\n",
       "      <th>Unknown</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2226</td>\n",
       "      <td>Algoma Public Health Unit</td>\n",
       "      <td>294 Willow Avenue</td>\n",
       "      <td>Sault Ste. Marie</td>\n",
       "      <td>P6B 0A9</td>\n",
       "      <td>www.algomapublichealth.com</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2227</td>\n",
       "      <td>Brant County Health Unit</td>\n",
       "      <td>194 Terrace Hill Street</td>\n",
       "      <td>Brantford</td>\n",
       "      <td>N3R 1G7</td>\n",
       "      <td>www.bchu.org/</td>\n",
       "      <td>15.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>...</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2230</td>\n",
       "      <td>Durham Region Health Department</td>\n",
       "      <td>605 Rossland Road East</td>\n",
       "      <td>Whitby</td>\n",
       "      <td>L1N 0B2</td>\n",
       "      <td>www.durham.ca/en/health-and-wellness/health-an...</td>\n",
       "      <td>81.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>...</td>\n",
       "      <td>231.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>298.0</td>\n",
       "      <td>609.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2233</td>\n",
       "      <td>Grey Bruce Health Unit</td>\n",
       "      <td>101 17th Street East</td>\n",
       "      <td>Owen Sound</td>\n",
       "      <td>N4K 0A5</td>\n",
       "      <td>www.publichealthgreybruce.on.ca/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2234</td>\n",
       "      <td>Haldimand-Norfolk Health Unit</td>\n",
       "      <td>12 Gilbertson Drive</td>\n",
       "      <td>Simcoe</td>\n",
       "      <td>N3Y 4N5</td>\n",
       "      <td>www.hnhu.org</td>\n",
       "      <td>7.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>...</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   PHU_ID                              PHU                  Address  \\\n",
       "0    2226        Algoma Public Health Unit        294 Willow Avenue   \n",
       "1    2227         Brant County Health Unit  194 Terrace Hill Street   \n",
       "2    2230  Durham Region Health Department   605 Rossland Road East   \n",
       "3    2233           Grey Bruce Health Unit     101 17th Street East   \n",
       "4    2234    Haldimand-Norfolk Health Unit      12 Gilbertson Drive   \n",
       "\n",
       "               City Postal_Code  \\\n",
       "0  Sault Ste. Marie     P6B 0A9   \n",
       "1         Brantford     N3R 1G7   \n",
       "2            Whitby     L1N 0B2   \n",
       "3        Owen Sound     N4K 0A5   \n",
       "4            Simcoe     N3Y 4N5   \n",
       "\n",
       "                                             Website  Age_Under_20  Age_20s  \\\n",
       "0                         www.algomapublichealth.com           1.0      5.0   \n",
       "1                                      www.bchu.org/          15.0     13.0   \n",
       "2  www.durham.ca/en/health-and-wellness/health-an...          81.0     70.0   \n",
       "3                   www.publichealthgreybruce.on.ca/          10.0      1.0   \n",
       "4                                       www.hnhu.org           7.0     19.0   \n",
       "\n",
       "   Age_30s  Age_40s  ...   Male  Gender_Diverse  Unspecified  Fatal  \\\n",
       "0      3.0      2.0  ...    8.0             0.0          0.0    0.0   \n",
       "1     13.0     12.0  ...   38.0             0.0          0.0    2.0   \n",
       "2     80.0     97.0  ...  231.0             0.0          0.0   39.0   \n",
       "3      1.0      6.0  ...   12.0             0.0          0.0    0.0   \n",
       "4     20.0     26.0  ...   66.0             0.0          1.0    1.0   \n",
       "\n",
       "   Not_Resolved  Resolved  Cases_in_2020  Cases_in_2021  Total_Cases  Unknown  \n",
       "0           0.0      12.0            3.0            9.0         12.0      0.0  \n",
       "1           0.0      69.0           20.0           51.0         71.0      0.0  \n",
       "2          22.0     548.0          311.0          298.0        609.0      0.0  \n",
       "3           0.0      31.0           11.0           20.0         31.0      0.0  \n",
       "4           2.0     108.0           62.0           49.0        111.0      1.0  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# combining gender_diverse and unspecified columns in one\n",
    "total1 = phu['Gender_Diverse'] + phu['Unspecified']\n",
    "phu['Unknown'] = total1\n",
    "phu.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal_Code</th>\n",
       "      <th>Website</th>\n",
       "      <th>Age_Under_20</th>\n",
       "      <th>Age_20s</th>\n",
       "      <th>Age_30s</th>\n",
       "      <th>Age_40s</th>\n",
       "      <th>...</th>\n",
       "      <th>Age_70s</th>\n",
       "      <th>Age_80s</th>\n",
       "      <th>Age_Over_90</th>\n",
       "      <th>Female</th>\n",
       "      <th>Male</th>\n",
       "      <th>Fatal</th>\n",
       "      <th>Not_Resolved</th>\n",
       "      <th>Resolved</th>\n",
       "      <th>Total_Cases</th>\n",
       "      <th>Unknown</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2226</td>\n",
       "      <td>Algoma Public Health Unit</td>\n",
       "      <td>294 Willow Avenue</td>\n",
       "      <td>Sault Ste. Marie</td>\n",
       "      <td>P6B 0A9</td>\n",
       "      <td>www.algomapublichealth.com</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2227</td>\n",
       "      <td>Brant County Health Unit</td>\n",
       "      <td>194 Terrace Hill Street</td>\n",
       "      <td>Brantford</td>\n",
       "      <td>N3R 1G7</td>\n",
       "      <td>www.bchu.org/</td>\n",
       "      <td>15.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2230</td>\n",
       "      <td>Durham Region Health Department</td>\n",
       "      <td>605 Rossland Road East</td>\n",
       "      <td>Whitby</td>\n",
       "      <td>L1N 0B2</td>\n",
       "      <td>www.durham.ca/en/health-and-wellness/health-an...</td>\n",
       "      <td>81.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>...</td>\n",
       "      <td>28.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>609.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2233</td>\n",
       "      <td>Grey Bruce Health Unit</td>\n",
       "      <td>101 17th Street East</td>\n",
       "      <td>Owen Sound</td>\n",
       "      <td>N4K 0A5</td>\n",
       "      <td>www.publichealthgreybruce.on.ca/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2234</td>\n",
       "      <td>Haldimand-Norfolk Health Unit</td>\n",
       "      <td>12 Gilbertson Drive</td>\n",
       "      <td>Simcoe</td>\n",
       "      <td>N3Y 4N5</td>\n",
       "      <td>www.hnhu.org</td>\n",
       "      <td>7.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   PHU_ID                              PHU                  Address  \\\n",
       "0    2226        Algoma Public Health Unit        294 Willow Avenue   \n",
       "1    2227         Brant County Health Unit  194 Terrace Hill Street   \n",
       "2    2230  Durham Region Health Department   605 Rossland Road East   \n",
       "3    2233           Grey Bruce Health Unit     101 17th Street East   \n",
       "4    2234    Haldimand-Norfolk Health Unit      12 Gilbertson Drive   \n",
       "\n",
       "               City Postal_Code  \\\n",
       "0  Sault Ste. Marie     P6B 0A9   \n",
       "1         Brantford     N3R 1G7   \n",
       "2            Whitby     L1N 0B2   \n",
       "3        Owen Sound     N4K 0A5   \n",
       "4            Simcoe     N3Y 4N5   \n",
       "\n",
       "                                             Website  Age_Under_20  Age_20s  \\\n",
       "0                         www.algomapublichealth.com           1.0      5.0   \n",
       "1                                      www.bchu.org/          15.0     13.0   \n",
       "2  www.durham.ca/en/health-and-wellness/health-an...          81.0     70.0   \n",
       "3                   www.publichealthgreybruce.on.ca/          10.0      1.0   \n",
       "4                                       www.hnhu.org           7.0     19.0   \n",
       "\n",
       "   Age_30s  Age_40s  ...  Age_70s  Age_80s  Age_Over_90  Female   Male  Fatal  \\\n",
       "0      3.0      2.0  ...      0.0      0.0          0.0     4.0    8.0    0.0   \n",
       "1     13.0     12.0  ...      2.0      2.0          0.0    33.0   38.0    2.0   \n",
       "2     80.0     97.0  ...     28.0     57.0         42.0   378.0  231.0   39.0   \n",
       "3      1.0      6.0  ...      1.0      3.0          1.0    19.0   12.0    0.0   \n",
       "4     20.0     26.0  ...      4.0      3.0          7.0    44.0   66.0    1.0   \n",
       "\n",
       "   Not_Resolved  Resolved  Total_Cases  Unknown  \n",
       "0           0.0      12.0         12.0      0.0  \n",
       "1           0.0      69.0         71.0      0.0  \n",
       "2          22.0     548.0        609.0      0.0  \n",
       "3           0.0      31.0         31.0      0.0  \n",
       "4           2.0     108.0        111.0      1.0  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# dropping duplicate columns\n",
    "phu_revised = phu.drop(columns=['Gender_Diverse','Unspecified','Cases_in_2020','Cases_in_2021'])\n",
    "phu_revised.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>PHU_ID</th>\n",
       "      <th>PHU</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal_Code</th>\n",
       "      <th>Website</th>\n",
       "      <th>Age_Under_20</th>\n",
       "      <th>Age_20s</th>\n",
       "      <th>Age_30s</th>\n",
       "      <th>Age_40s</th>\n",
       "      <th>...</th>\n",
       "      <th>Age_70s</th>\n",
       "      <th>Age_80s</th>\n",
       "      <th>Age_Over_90</th>\n",
       "      <th>Female</th>\n",
       "      <th>Male</th>\n",
       "      <th>Fatal</th>\n",
       "      <th>Not_Resolved</th>\n",
       "      <th>Resolved</th>\n",
       "      <th>Total_Cases</th>\n",
       "      <th>Unknown</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3895</td>\n",
       "      <td>Toronto Public Health</td>\n",
       "      <td>277 Victoria Street, 5th Floor</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>M5B 1W2</td>\n",
       "      <td>www.toronto.ca/community-people/health-wellnes...</td>\n",
       "      <td>407.0</td>\n",
       "      <td>365.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>463.0</td>\n",
       "      <td>...</td>\n",
       "      <td>256.0</td>\n",
       "      <td>436.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>1520.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>3236.0</td>\n",
       "      <td>3581.0</td>\n",
       "      <td>65.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2253</td>\n",
       "      <td>Peel Public Health</td>\n",
       "      <td>7120 Hurontario Street</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>L5W 1N4</td>\n",
       "      <td>www.peelregion.ca/health/</td>\n",
       "      <td>163.0</td>\n",
       "      <td>443.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>372.0</td>\n",
       "      <td>...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>1114.0</td>\n",
       "      <td>961.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1945.0</td>\n",
       "      <td>2077.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2270</td>\n",
       "      <td>York Region Public Health Services</td>\n",
       "      <td>17250 Yonge Street</td>\n",
       "      <td>Newmarket</td>\n",
       "      <td>L3Y 6Z1</td>\n",
       "      <td>www.york.ca/wps/portal/yorkhome/health/</td>\n",
       "      <td>122.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>...</td>\n",
       "      <td>54.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>444.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>869.0</td>\n",
       "      <td>943.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2251</td>\n",
       "      <td>Ottawa Public Health</td>\n",
       "      <td>100 Constellation Drive</td>\n",
       "      <td>Ottawa</td>\n",
       "      <td>K2G 6J8</td>\n",
       "      <td>www.ottawapublichealth.ca</td>\n",
       "      <td>122.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>...</td>\n",
       "      <td>52.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>462.0</td>\n",
       "      <td>345.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>730.0</td>\n",
       "      <td>808.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2246</td>\n",
       "      <td>Niagara Region Public Health Department</td>\n",
       "      <td>1815 Sir Isaac Brock Way</td>\n",
       "      <td>Thorold</td>\n",
       "      <td>L2V 4T7</td>\n",
       "      <td>www.niagararegion.ca/health</td>\n",
       "      <td>49.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>...</td>\n",
       "      <td>61.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>469.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>659.0</td>\n",
       "      <td>726.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2268</td>\n",
       "      <td>Windsor-Essex County Health Unit</td>\n",
       "      <td>1005 Ouellette Avenue</td>\n",
       "      <td>Windsor</td>\n",
       "      <td>N9A 4J8</td>\n",
       "      <td>www.wechu.org</td>\n",
       "      <td>26.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>...</td>\n",
       "      <td>48.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>304.0</td>\n",
       "      <td>384.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>647.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2237</td>\n",
       "      <td>Hamilton Public Health Services</td>\n",
       "      <td>110 King St. West, 2nd Floor</td>\n",
       "      <td>Hamilton</td>\n",
       "      <td>L8P 4S6</td>\n",
       "      <td>www.hamilton.ca/publichealth</td>\n",
       "      <td>51.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>...</td>\n",
       "      <td>46.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>331.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>568.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2230</td>\n",
       "      <td>Durham Region Health Department</td>\n",
       "      <td>605 Rossland Road East</td>\n",
       "      <td>Whitby</td>\n",
       "      <td>L1N 0B2</td>\n",
       "      <td>www.durham.ca/en/health-and-wellness/health-an...</td>\n",
       "      <td>81.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>...</td>\n",
       "      <td>28.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>548.0</td>\n",
       "      <td>609.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2265</td>\n",
       "      <td>Region of Waterloo, Public Health</td>\n",
       "      <td>99 Regina Street South</td>\n",
       "      <td>Waterloo</td>\n",
       "      <td>N2J 4V3</td>\n",
       "      <td>www.regionofwaterloo.ca</td>\n",
       "      <td>44.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>...</td>\n",
       "      <td>29.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>248.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>482.0</td>\n",
       "      <td>516.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2236</td>\n",
       "      <td>Halton Region Health Department</td>\n",
       "      <td>1151 Bronte Road</td>\n",
       "      <td>Oakville</td>\n",
       "      <td>L6M 3Ll</td>\n",
       "      <td>www.halton.ca/For-Residents/Public-Health/</td>\n",
       "      <td>43.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>...</td>\n",
       "      <td>24.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>433.0</td>\n",
       "      <td>472.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2244</td>\n",
       "      <td>Middlesex-London Health Unit</td>\n",
       "      <td>50 King Street</td>\n",
       "      <td>London</td>\n",
       "      <td>N6A 5L7</td>\n",
       "      <td>www.healthunit.com</td>\n",
       "      <td>100.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>...</td>\n",
       "      <td>18.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>202.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>351.0</td>\n",
       "      <td>389.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2260</td>\n",
       "      <td>Simcoe Muskoka District Health Unit</td>\n",
       "      <td>15 Sperling Drive</td>\n",
       "      <td>Barrie</td>\n",
       "      <td>L4M 6K9</td>\n",
       "      <td>www.simcoemuskokahealth.org</td>\n",
       "      <td>46.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>211.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>352.0</td>\n",
       "      <td>383.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2266</td>\n",
       "      <td>Wellington-Dufferin-Guelph Public Health</td>\n",
       "      <td>160 Chancellors Way</td>\n",
       "      <td>Guelph</td>\n",
       "      <td>N1G 0E1</td>\n",
       "      <td>www.wdgpublichealth.ca</td>\n",
       "      <td>26.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2262</td>\n",
       "      <td>Thunder Bay District Health Unit</td>\n",
       "      <td>999 Balmoral Street</td>\n",
       "      <td>Thunder Bay</td>\n",
       "      <td>P7B 6E7</td>\n",
       "      <td>www.tbdhu.com</td>\n",
       "      <td>15.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>193.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4913</td>\n",
       "      <td>Southwestern Public Health</td>\n",
       "      <td>1230 Talbot Street</td>\n",
       "      <td>St. Thomas</td>\n",
       "      <td>N5P 1G9</td>\n",
       "      <td>www.swpublichealth.ca</td>\n",
       "      <td>6.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>...</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2258</td>\n",
       "      <td>Eastern Ontario Health Unit</td>\n",
       "      <td>1000 Pitt Street</td>\n",
       "      <td>Cornwall</td>\n",
       "      <td>K6J 5T1</td>\n",
       "      <td>www.eohu.ca</td>\n",
       "      <td>15.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2234</td>\n",
       "      <td>Haldimand-Norfolk Health Unit</td>\n",
       "      <td>12 Gilbertson Drive</td>\n",
       "      <td>Simcoe</td>\n",
       "      <td>N3Y 4N5</td>\n",
       "      <td>www.hnhu.org</td>\n",
       "      <td>7.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2242</td>\n",
       "      <td>Lambton Public Health</td>\n",
       "      <td>160 Exmouth Street</td>\n",
       "      <td>Point Edward</td>\n",
       "      <td>N7T 7Z6</td>\n",
       "      <td>www.lambtonhealth.on.ca</td>\n",
       "      <td>14.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2243</td>\n",
       "      <td>Leeds, Grenville and Lanark District Health Unit</td>\n",
       "      <td>458 Laurier Boulevard</td>\n",
       "      <td>Brockville</td>\n",
       "      <td>K6V 7A3</td>\n",
       "      <td>www.healthunit.org</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>...</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2261</td>\n",
       "      <td>Sudbury &amp; District Health Unit</td>\n",
       "      <td>1300 Paris Street</td>\n",
       "      <td>Sudbury</td>\n",
       "      <td>P3E 3A3</td>\n",
       "      <td>www.phsd.ca</td>\n",
       "      <td>18.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2227</td>\n",
       "      <td>Brant County Health Unit</td>\n",
       "      <td>194 Terrace Hill Street</td>\n",
       "      <td>Brantford</td>\n",
       "      <td>N3R 1G7</td>\n",
       "      <td>www.bchu.org/</td>\n",
       "      <td>15.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5183</td>\n",
       "      <td>Huron Perth District Health Unit</td>\n",
       "      <td>653 West Gore Street</td>\n",
       "      <td>Stratford</td>\n",
       "      <td>N5A 1L4</td>\n",
       "      <td>www.hpph.ca</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2235</td>\n",
       "      <td>Haliburton, Kawartha, Pine Ridge District Heal...</td>\n",
       "      <td>200 Rose Glen Road</td>\n",
       "      <td>Port Hope</td>\n",
       "      <td>L1A 3V6</td>\n",
       "      <td>www.hkpr.on.ca/</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2249</td>\n",
       "      <td>Northwestern Health Unit</td>\n",
       "      <td>210 First Street North</td>\n",
       "      <td>Kenora</td>\n",
       "      <td>P9N 2K4</td>\n",
       "      <td>www.nwhu.on.ca</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2240</td>\n",
       "      <td>Chatham-Kent Health Unit</td>\n",
       "      <td>435 Grand Avenue West</td>\n",
       "      <td>Chatham</td>\n",
       "      <td>N7M 5L8</td>\n",
       "      <td>www.ckphu.com</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2241</td>\n",
       "      <td>Kingston, Frontenac and Lennox &amp; Addington Pub...</td>\n",
       "      <td>221 Portsmouth Avenue</td>\n",
       "      <td>Kingston</td>\n",
       "      <td>K7M 1V5</td>\n",
       "      <td>www.kflaph.ca</td>\n",
       "      <td>12.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2238</td>\n",
       "      <td>Hastings and Prince Edward Counties Health Unit</td>\n",
       "      <td>179 North Park Street</td>\n",
       "      <td>Belleville</td>\n",
       "      <td>K8P 4P1</td>\n",
       "      <td>www.hpePublicHealth.ca</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2255</td>\n",
       "      <td>Peterborough Public Health</td>\n",
       "      <td>185 King Street</td>\n",
       "      <td>Peterborough</td>\n",
       "      <td>K9J 2R8</td>\n",
       "      <td>www.peterboroughpublichealth.ca</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2256</td>\n",
       "      <td>Porcupine Health Unit</td>\n",
       "      <td>169 Pine Street South</td>\n",
       "      <td>Timmins</td>\n",
       "      <td>P4N 8B7</td>\n",
       "      <td>www.porcupinehu.on.ca</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2233</td>\n",
       "      <td>Grey Bruce Health Unit</td>\n",
       "      <td>101 17th Street East</td>\n",
       "      <td>Owen Sound</td>\n",
       "      <td>N4K 0A5</td>\n",
       "      <td>www.publichealthgreybruce.on.ca/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2257</td>\n",
       "      <td>Renfrew County and District Health Unit</td>\n",
       "      <td>7 International Drive</td>\n",
       "      <td>Pembroke</td>\n",
       "      <td>K8A 6W5</td>\n",
       "      <td>www.rcdhu.com</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2247</td>\n",
       "      <td>North Bay Parry Sound District Health Unit</td>\n",
       "      <td>345 Oak Street West</td>\n",
       "      <td>North Bay</td>\n",
       "      <td>P1B 2T2</td>\n",
       "      <td>www.myhealthunit.ca</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2226</td>\n",
       "      <td>Algoma Public Health Unit</td>\n",
       "      <td>294 Willow Avenue</td>\n",
       "      <td>Sault Ste. Marie</td>\n",
       "      <td>P6B 0A9</td>\n",
       "      <td>www.algomapublichealth.com</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2263</td>\n",
       "      <td>Timiskaming Health Unit</td>\n",
       "      <td>247 Whitewood Avenue, Unit 43</td>\n",
       "      <td>New Liskeard</td>\n",
       "      <td>P0J 1P0</td>\n",
       "      <td>www.timiskaminghu.com</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>34 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    PHU_ID                                                PHU  \\\n",
       "0     3895                              Toronto Public Health   \n",
       "1     2253                                 Peel Public Health   \n",
       "2     2270                 York Region Public Health Services   \n",
       "3     2251                               Ottawa Public Health   \n",
       "4     2246            Niagara Region Public Health Department   \n",
       "5     2268                   Windsor-Essex County Health Unit   \n",
       "6     2237                    Hamilton Public Health Services   \n",
       "7     2230                    Durham Region Health Department   \n",
       "8     2265                  Region of Waterloo, Public Health   \n",
       "9     2236                    Halton Region Health Department   \n",
       "10    2244                       Middlesex-London Health Unit   \n",
       "11    2260                Simcoe Muskoka District Health Unit   \n",
       "12    2266           Wellington-Dufferin-Guelph Public Health   \n",
       "13    2262                   Thunder Bay District Health Unit   \n",
       "14    4913                         Southwestern Public Health   \n",
       "15    2258                        Eastern Ontario Health Unit   \n",
       "16    2234                      Haldimand-Norfolk Health Unit   \n",
       "17    2242                              Lambton Public Health   \n",
       "18    2243   Leeds, Grenville and Lanark District Health Unit   \n",
       "19    2261                     Sudbury & District Health Unit   \n",
       "20    2227                           Brant County Health Unit   \n",
       "21    5183                   Huron Perth District Health Unit   \n",
       "22    2235  Haliburton, Kawartha, Pine Ridge District Heal...   \n",
       "23    2249                           Northwestern Health Unit   \n",
       "24    2240                           Chatham-Kent Health Unit   \n",
       "25    2241  Kingston, Frontenac and Lennox & Addington Pub...   \n",
       "26    2238    Hastings and Prince Edward Counties Health Unit   \n",
       "27    2255                         Peterborough Public Health   \n",
       "28    2256                              Porcupine Health Unit   \n",
       "29    2233                             Grey Bruce Health Unit   \n",
       "30    2257            Renfrew County and District Health Unit   \n",
       "31    2247         North Bay Parry Sound District Health Unit   \n",
       "32    2226                          Algoma Public Health Unit   \n",
       "33    2263                            Timiskaming Health Unit   \n",
       "\n",
       "                           Address              City Postal_Code  \\\n",
       "0   277 Victoria Street, 5th Floor           Toronto     M5B 1W2   \n",
       "1           7120 Hurontario Street       Mississauga     L5W 1N4   \n",
       "2               17250 Yonge Street         Newmarket     L3Y 6Z1   \n",
       "3          100 Constellation Drive            Ottawa     K2G 6J8   \n",
       "4         1815 Sir Isaac Brock Way           Thorold     L2V 4T7   \n",
       "5            1005 Ouellette Avenue           Windsor     N9A 4J8   \n",
       "6     110 King St. West, 2nd Floor          Hamilton     L8P 4S6   \n",
       "7           605 Rossland Road East            Whitby     L1N 0B2   \n",
       "8           99 Regina Street South          Waterloo     N2J 4V3   \n",
       "9                 1151 Bronte Road          Oakville     L6M 3Ll   \n",
       "10                  50 King Street            London     N6A 5L7   \n",
       "11               15 Sperling Drive            Barrie     L4M 6K9   \n",
       "12             160 Chancellors Way            Guelph     N1G 0E1   \n",
       "13             999 Balmoral Street       Thunder Bay     P7B 6E7   \n",
       "14              1230 Talbot Street        St. Thomas     N5P 1G9   \n",
       "15                1000 Pitt Street          Cornwall     K6J 5T1   \n",
       "16             12 Gilbertson Drive            Simcoe     N3Y 4N5   \n",
       "17              160 Exmouth Street      Point Edward     N7T 7Z6   \n",
       "18           458 Laurier Boulevard        Brockville     K6V 7A3   \n",
       "19               1300 Paris Street           Sudbury     P3E 3A3   \n",
       "20         194 Terrace Hill Street         Brantford     N3R 1G7   \n",
       "21            653 West Gore Street         Stratford     N5A 1L4   \n",
       "22              200 Rose Glen Road         Port Hope     L1A 3V6   \n",
       "23         210 First Street North             Kenora     P9N 2K4   \n",
       "24           435 Grand Avenue West           Chatham     N7M 5L8   \n",
       "25           221 Portsmouth Avenue          Kingston     K7M 1V5   \n",
       "26           179 North Park Street        Belleville     K8P 4P1   \n",
       "27                 185 King Street      Peterborough     K9J 2R8   \n",
       "28           169 Pine Street South           Timmins     P4N 8B7   \n",
       "29            101 17th Street East        Owen Sound     N4K 0A5   \n",
       "30           7 International Drive          Pembroke     K8A 6W5   \n",
       "31             345 Oak Street West         North Bay     P1B 2T2   \n",
       "32               294 Willow Avenue  Sault Ste. Marie     P6B 0A9   \n",
       "33   247 Whitewood Avenue, Unit 43      New Liskeard     P0J 1P0   \n",
       "\n",
       "                                              Website  Age_Under_20  Age_20s  \\\n",
       "0   www.toronto.ca/community-people/health-wellnes...         407.0    365.0   \n",
       "1                           www.peelregion.ca/health/         163.0    443.0   \n",
       "2            www.york.ca/wps/portal/yorkhome/health/          122.0     90.0   \n",
       "3                           www.ottawapublichealth.ca         122.0    103.0   \n",
       "4                         www.niagararegion.ca/health          49.0    108.0   \n",
       "5                                       www.wechu.org          26.0    153.0   \n",
       "6                        www.hamilton.ca/publichealth          51.0    100.0   \n",
       "7   www.durham.ca/en/health-and-wellness/health-an...          81.0     70.0   \n",
       "8                             www.regionofwaterloo.ca          44.0    106.0   \n",
       "9         www.halton.ca/For-Residents/Public-Health/           43.0     52.0   \n",
       "10                                 www.healthunit.com         100.0     65.0   \n",
       "11                        www.simcoemuskokahealth.org          46.0     73.0   \n",
       "12                             www.wdgpublichealth.ca          26.0     42.0   \n",
       "13                                      www.tbdhu.com          15.0     36.0   \n",
       "14                              www.swpublichealth.ca           6.0     32.0   \n",
       "15                                        www.eohu.ca          15.0      8.0   \n",
       "16                                       www.hnhu.org           7.0     19.0   \n",
       "17                            www.lambtonhealth.on.ca          14.0      9.0   \n",
       "18                                 www.healthunit.org           8.0      8.0   \n",
       "19                                        www.phsd.ca          18.0     14.0   \n",
       "20                                      www.bchu.org/          15.0     13.0   \n",
       "21                                        www.hpph.ca           1.0     10.0   \n",
       "22                                    www.hkpr.on.ca/           7.0      9.0   \n",
       "23                                     www.nwhu.on.ca          11.0      4.0   \n",
       "24                                      www.ckphu.com           6.0      5.0   \n",
       "25                                      www.kflaph.ca          12.0      7.0   \n",
       "26                             www.hpePublicHealth.ca           8.0      8.0   \n",
       "27                    www.peterboroughpublichealth.ca           6.0     10.0   \n",
       "28                              www.porcupinehu.on.ca           5.0      5.0   \n",
       "29                   www.publichealthgreybruce.on.ca/          10.0      1.0   \n",
       "30                                      www.rcdhu.com           9.0      2.0   \n",
       "31                               www.myhealthunit.ca            3.0      6.0   \n",
       "32                         www.algomapublichealth.com           1.0      5.0   \n",
       "33                              www.timiskaminghu.com           1.0      2.0   \n",
       "\n",
       "    Age_30s  Age_40s  ...  Age_70s  Age_80s  Age_Over_90  Female    Male  \\\n",
       "0     419.0    463.0  ...    256.0    436.0        355.0  1996.0  1520.0   \n",
       "1     326.0    372.0  ...     70.0    116.0        102.0  1114.0   961.0   \n",
       "2     115.0    124.0  ...     54.0     98.0         73.0   494.0   444.0   \n",
       "3      91.0    103.0  ...     52.0     95.0         72.0   462.0   345.0   \n",
       "4     105.0     86.0  ...     61.0     94.0         76.0   469.0   256.0   \n",
       "5     119.0    110.0  ...     48.0     65.0         55.0   304.0   384.0   \n",
       "6      86.0     83.0  ...     46.0     65.0         49.0   331.0   297.0   \n",
       "7      80.0     97.0  ...     28.0     57.0         42.0   378.0   231.0   \n",
       "8      70.0     78.0  ...     29.0     49.0         31.0   248.0   266.0   \n",
       "9      64.0     77.0  ...     24.0     61.0         45.0   240.0   232.0   \n",
       "10     47.0     50.0  ...     18.0     21.0         12.0   202.0   187.0   \n",
       "11     62.0     51.0  ...     21.0     30.0         16.0   211.0   172.0   \n",
       "12     61.0     40.0  ...      8.0     24.0         16.0   140.0   123.0   \n",
       "13     38.0     29.0  ...      8.0     13.0          7.0    86.0   105.0   \n",
       "14     28.0     23.0  ...     14.0      8.0          7.0    70.0    84.0   \n",
       "15      7.0     14.0  ...     10.0     19.0         14.0    78.0    40.0   \n",
       "16     20.0     26.0  ...      4.0      3.0          7.0    44.0    66.0   \n",
       "17     10.0     14.0  ...      6.0     12.0         11.0    52.0    44.0   \n",
       "18      5.0     10.0  ...     15.0      9.0         12.0    55.0    40.0   \n",
       "19     10.0     15.0  ...      3.0      4.0          6.0    45.0    41.0   \n",
       "20     13.0     12.0  ...      2.0      2.0          0.0    33.0    38.0   \n",
       "21     10.0      7.0  ...      4.0     17.0         12.0    45.0    25.0   \n",
       "22      6.0      9.0  ...      5.0      7.0          7.0    42.0    25.0   \n",
       "23     11.0      6.0  ...      3.0      2.0          2.0    23.0    27.0   \n",
       "24     12.0     11.0  ...      2.0      2.0          2.0    28.0    21.0   \n",
       "25      7.0      3.0  ...      0.0      0.0          2.0    24.0    23.0   \n",
       "26      3.0      4.0  ...      4.0      1.0          0.0    15.0    22.0   \n",
       "27      2.0      6.0  ...      2.0      3.0          1.0    21.0    14.0   \n",
       "28      6.0      2.0  ...      0.0      3.0          2.0    18.0    13.0   \n",
       "29      1.0      6.0  ...      1.0      3.0          1.0    19.0    12.0   \n",
       "30      5.0      5.0  ...      1.0      1.0          1.0    13.0    14.0   \n",
       "31      2.0      3.0  ...      1.0      0.0          0.0    11.0     9.0   \n",
       "32      3.0      2.0  ...      0.0      0.0          0.0     4.0     8.0   \n",
       "33      2.0      2.0  ...      0.0      1.0          0.0     6.0     4.0   \n",
       "\n",
       "    Fatal  Not_Resolved  Resolved  Total_Cases  Unknown  \n",
       "0   275.0          70.0    3236.0       3581.0     65.0  \n",
       "1    70.0          62.0    1945.0       2077.0      2.0  \n",
       "2    63.0          11.0     869.0        943.0      5.0  \n",
       "3    64.0          14.0     730.0        808.0      1.0  \n",
       "4    47.0          20.0     659.0        726.0      1.0  \n",
       "5    50.0           3.0     647.0        700.0     12.0  \n",
       "6    32.0          30.0     568.0        630.0      2.0  \n",
       "7    39.0          22.0     548.0        609.0      0.0  \n",
       "8    30.0           4.0     482.0        516.0      2.0  \n",
       "9    24.0          15.0     433.0        472.0      0.0  \n",
       "10   17.0          21.0     351.0        389.0      0.0  \n",
       "11   22.0           9.0     352.0        383.0      0.0  \n",
       "12   13.0           4.0     256.0        273.0     10.0  \n",
       "13   11.0           0.0     182.0        193.0      2.0  \n",
       "14    8.0           3.0     144.0        155.0      1.0  \n",
       "15   13.0           2.0     103.0        118.0      0.0  \n",
       "16    1.0           2.0     108.0        111.0      1.0  \n",
       "17    5.0           4.0      87.0         96.0      0.0  \n",
       "18    6.0           0.0      89.0         95.0      0.0  \n",
       "19    3.0           1.0      83.0         87.0      1.0  \n",
       "20    2.0           0.0      69.0         71.0      0.0  \n",
       "21    8.0           1.0      61.0         70.0      0.0  \n",
       "22    4.0           4.0      59.0         67.0      0.0  \n",
       "23    1.0           0.0      51.0         52.0      2.0  \n",
       "24    1.0           1.0      47.0         49.0      0.0  \n",
       "25    0.0           3.0      44.0         47.0      0.0  \n",
       "26    1.0           0.0      36.0         37.0      0.0  \n",
       "27    0.0           3.0      33.0         36.0      1.0  \n",
       "28    0.0           2.0      30.0         32.0      1.0  \n",
       "29    0.0           0.0      31.0         31.0      0.0  \n",
       "30    0.0           1.0      27.0         28.0      1.0  \n",
       "31    0.0           3.0      17.0         20.0      0.0  \n",
       "32    0.0           0.0      12.0         12.0      0.0  \n",
       "33    1.0           0.0       9.0         10.0      0.0  \n",
       "\n",
       "[34 rows x 22 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# sorting dataframe by PHU name\n",
    "phu_sorted = phu_revised.sort_values(by='Total_Cases',ascending=False)\n",
    "phu_sorted.reset_index(drop=True)\n",
    "phu_sorted"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'PHU': {0: 'Toronto Public Health',\n",
       "  1: 'Peel Public Health',\n",
       "  2: 'York Region Public Health Services',\n",
       "  3: 'Ottawa Public Health',\n",
       "  4: 'Niagara Region Public Health Department',\n",
       "  5: 'Windsor-Essex County Health Unit',\n",
       "  6: 'Hamilton Public Health Services',\n",
       "  7: 'Durham Region Health Department',\n",
       "  8: 'Region of Waterloo, Public Health',\n",
       "  9: 'Halton Region Health Department',\n",
       "  10: 'Middlesex-London Health Unit',\n",
       "  11: 'Simcoe Muskoka District Health Unit',\n",
       "  12: 'Wellington-Dufferin-Guelph Public Health',\n",
       "  13: 'Thunder Bay District Health Unit',\n",
       "  14: 'Southwestern Public Health',\n",
       "  15: 'Eastern Ontario Health Unit',\n",
       "  16: 'Haldimand-Norfolk Health Unit',\n",
       "  17: 'Lambton Public Health',\n",
       "  18: 'Leeds, Grenville and Lanark District Health Unit',\n",
       "  19: 'Sudbury & District Health Unit',\n",
       "  20: 'Brant County Health Unit',\n",
       "  21: 'Huron Perth District Health Unit',\n",
       "  22: 'Haliburton, Kawartha, Pine Ridge District Health Unit',\n",
       "  23: 'Northwestern Health Unit',\n",
       "  24: 'Chatham-Kent Health Unit',\n",
       "  25: 'Kingston, Frontenac and Lennox & Addington Public Health',\n",
       "  26: 'Hastings and Prince Edward Counties Health Unit',\n",
       "  27: 'Peterborough Public Health',\n",
       "  28: 'Porcupine Health Unit',\n",
       "  29: 'Grey Bruce Health Unit',\n",
       "  30: 'Renfrew County and District Health Unit',\n",
       "  31: 'North Bay Parry Sound District Health Unit',\n",
       "  32: 'Algoma Public Health Unit',\n",
       "  33: 'Timiskaming Health Unit'}}"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# creating name dataframe and converting to a dict\n",
    "name = phu_sorted[['PHU']].to_dict()\n",
    "name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{0: {'PHU': 'Toronto Public Health',\n",
       "  'PHU_ID': 3895,\n",
       "  'Address': '277 Victoria Street, 5th Floor',\n",
       "  'City': 'Toronto',\n",
       "  'Postal_Code': 'M5B 1W2',\n",
       "  'Website': 'www.toronto.ca/community-people/health-wellness-care/'},\n",
       " 1: {'PHU': 'Peel Public Health',\n",
       "  'PHU_ID': 2253,\n",
       "  'Address': '7120 Hurontario Street',\n",
       "  'City': 'Mississauga',\n",
       "  'Postal_Code': 'L5W 1N4',\n",
       "  'Website': 'www.peelregion.ca/health/'},\n",
       " 2: {'PHU': 'York Region Public Health Services',\n",
       "  'PHU_ID': 2270,\n",
       "  'Address': '17250 Yonge Street',\n",
       "  'City': 'Newmarket',\n",
       "  'Postal_Code': 'L3Y 6Z1',\n",
       "  'Website': 'www.york.ca/wps/portal/yorkhome/health/ '},\n",
       " 3: {'PHU': 'Ottawa Public Health',\n",
       "  'PHU_ID': 2251,\n",
       "  'Address': '100 Constellation Drive',\n",
       "  'City': 'Ottawa',\n",
       "  'Postal_Code': 'K2G 6J8',\n",
       "  'Website': 'www.ottawapublichealth.ca'},\n",
       " 4: {'PHU': 'Niagara Region Public Health Department',\n",
       "  'PHU_ID': 2246,\n",
       "  'Address': '1815 Sir Isaac Brock Way',\n",
       "  'City': 'Thorold',\n",
       "  'Postal_Code': 'L2V 4T7',\n",
       "  'Website': 'www.niagararegion.ca/health'},\n",
       " 5: {'PHU': 'Windsor-Essex County Health Unit',\n",
       "  'PHU_ID': 2268,\n",
       "  'Address': '1005 Ouellette Avenue',\n",
       "  'City': 'Windsor',\n",
       "  'Postal_Code': 'N9A 4J8',\n",
       "  'Website': 'www.wechu.org'},\n",
       " 6: {'PHU': 'Hamilton Public Health Services',\n",
       "  'PHU_ID': 2237,\n",
       "  'Address': '110 King St. West, 2nd Floor',\n",
       "  'City': 'Hamilton',\n",
       "  'Postal_Code': 'L8P 4S6',\n",
       "  'Website': 'www.hamilton.ca/publichealth'},\n",
       " 7: {'PHU': 'Durham Region Health Department',\n",
       "  'PHU_ID': 2230,\n",
       "  'Address': '605 Rossland Road East',\n",
       "  'City': 'Whitby',\n",
       "  'Postal_Code': 'L1N 0B2',\n",
       "  'Website': 'www.durham.ca/en/health-and-wellness/health-and-wellness.aspx'},\n",
       " 8: {'PHU': 'Region of Waterloo, Public Health',\n",
       "  'PHU_ID': 2265,\n",
       "  'Address': '99 Regina Street South',\n",
       "  'City': 'Waterloo',\n",
       "  'Postal_Code': 'N2J 4V3',\n",
       "  'Website': 'www.regionofwaterloo.ca'},\n",
       " 9: {'PHU': 'Halton Region Health Department',\n",
       "  'PHU_ID': 2236,\n",
       "  'Address': '1151 Bronte Road',\n",
       "  'City': 'Oakville',\n",
       "  'Postal_Code': 'L6M 3Ll',\n",
       "  'Website': 'www.halton.ca/For-Residents/Public-Health/ '},\n",
       " 10: {'PHU': 'Middlesex-London Health Unit',\n",
       "  'PHU_ID': 2244,\n",
       "  'Address': '50 King Street',\n",
       "  'City': 'London',\n",
       "  'Postal_Code': 'N6A 5L7',\n",
       "  'Website': 'www.healthunit.com'},\n",
       " 11: {'PHU': 'Simcoe Muskoka District Health Unit',\n",
       "  'PHU_ID': 2260,\n",
       "  'Address': '15 Sperling Drive',\n",
       "  'City': 'Barrie',\n",
       "  'Postal_Code': 'L4M 6K9',\n",
       "  'Website': 'www.simcoemuskokahealth.org'},\n",
       " 12: {'PHU': 'Wellington-Dufferin-Guelph Public Health',\n",
       "  'PHU_ID': 2266,\n",
       "  'Address': '160 Chancellors Way',\n",
       "  'City': 'Guelph',\n",
       "  'Postal_Code': 'N1G 0E1',\n",
       "  'Website': 'www.wdgpublichealth.ca'},\n",
       " 13: {'PHU': 'Thunder Bay District Health Unit',\n",
       "  'PHU_ID': 2262,\n",
       "  'Address': '999 Balmoral Street',\n",
       "  'City': 'Thunder Bay',\n",
       "  'Postal_Code': 'P7B 6E7',\n",
       "  'Website': 'www.tbdhu.com'},\n",
       " 14: {'PHU': 'Southwestern Public Health',\n",
       "  'PHU_ID': 4913,\n",
       "  'Address': '1230 Talbot Street',\n",
       "  'City': 'St. Thomas',\n",
       "  'Postal_Code': 'N5P 1G9',\n",
       "  'Website': 'www.swpublichealth.ca'},\n",
       " 15: {'PHU': 'Eastern Ontario Health Unit',\n",
       "  'PHU_ID': 2258,\n",
       "  'Address': '1000 Pitt Street',\n",
       "  'City': 'Cornwall',\n",
       "  'Postal_Code': 'K6J 5T1',\n",
       "  'Website': 'www.eohu.ca'},\n",
       " 16: {'PHU': 'Haldimand-Norfolk Health Unit',\n",
       "  'PHU_ID': 2234,\n",
       "  'Address': '12 Gilbertson Drive',\n",
       "  'City': 'Simcoe',\n",
       "  'Postal_Code': 'N3Y 4N5',\n",
       "  'Website': 'www.hnhu.org'},\n",
       " 17: {'PHU': 'Lambton Public Health',\n",
       "  'PHU_ID': 2242,\n",
       "  'Address': '160 Exmouth Street',\n",
       "  'City': 'Point Edward',\n",
       "  'Postal_Code': 'N7T 7Z6',\n",
       "  'Website': 'www.lambtonhealth.on.ca'},\n",
       " 18: {'PHU': 'Leeds, Grenville and Lanark District Health Unit',\n",
       "  'PHU_ID': 2243,\n",
       "  'Address': '458 Laurier Boulevard',\n",
       "  'City': 'Brockville',\n",
       "  'Postal_Code': 'K6V 7A3',\n",
       "  'Website': 'www.healthunit.org'},\n",
       " 19: {'PHU': 'Sudbury & District Health Unit',\n",
       "  'PHU_ID': 2261,\n",
       "  'Address': '1300 Paris Street',\n",
       "  'City': 'Sudbury',\n",
       "  'Postal_Code': 'P3E 3A3',\n",
       "  'Website': 'www.phsd.ca'},\n",
       " 20: {'PHU': 'Brant County Health Unit',\n",
       "  'PHU_ID': 2227,\n",
       "  'Address': '194 Terrace Hill Street',\n",
       "  'City': 'Brantford',\n",
       "  'Postal_Code': 'N3R 1G7',\n",
       "  'Website': 'www.bchu.org/'},\n",
       " 21: {'PHU': 'Huron Perth District Health Unit',\n",
       "  'PHU_ID': 5183,\n",
       "  'Address': '653 West Gore Street',\n",
       "  'City': 'Stratford',\n",
       "  'Postal_Code': 'N5A 1L4',\n",
       "  'Website': 'www.hpph.ca'},\n",
       " 22: {'PHU': 'Haliburton, Kawartha, Pine Ridge District Health Unit',\n",
       "  'PHU_ID': 2235,\n",
       "  'Address': '200 Rose Glen Road',\n",
       "  'City': 'Port Hope',\n",
       "  'Postal_Code': 'L1A 3V6',\n",
       "  'Website': 'www.hkpr.on.ca/'},\n",
       " 23: {'PHU': 'Northwestern Health Unit',\n",
       "  'PHU_ID': 2249,\n",
       "  'Address': '210 First Street North ',\n",
       "  'City': 'Kenora',\n",
       "  'Postal_Code': 'P9N 2K4',\n",
       "  'Website': 'www.nwhu.on.ca'},\n",
       " 24: {'PHU': 'Chatham-Kent Health Unit',\n",
       "  'PHU_ID': 2240,\n",
       "  'Address': '435 Grand Avenue West',\n",
       "  'City': 'Chatham',\n",
       "  'Postal_Code': 'N7M 5L8',\n",
       "  'Website': 'www.ckphu.com'},\n",
       " 25: {'PHU': 'Kingston, Frontenac and Lennox & Addington Public Health',\n",
       "  'PHU_ID': 2241,\n",
       "  'Address': '221 Portsmouth Avenue',\n",
       "  'City': 'Kingston',\n",
       "  'Postal_Code': 'K7M 1V5',\n",
       "  'Website': 'www.kflaph.ca'},\n",
       " 26: {'PHU': 'Hastings and Prince Edward Counties Health Unit',\n",
       "  'PHU_ID': 2238,\n",
       "  'Address': '179 North Park Street',\n",
       "  'City': 'Belleville',\n",
       "  'Postal_Code': 'K8P 4P1',\n",
       "  'Website': 'www.hpePublicHealth.ca'},\n",
       " 27: {'PHU': 'Peterborough Public Health',\n",
       "  'PHU_ID': 2255,\n",
       "  'Address': '185 King Street',\n",
       "  'City': 'Peterborough',\n",
       "  'Postal_Code': 'K9J 2R8',\n",
       "  'Website': 'www.peterboroughpublichealth.ca'},\n",
       " 28: {'PHU': 'Porcupine Health Unit',\n",
       "  'PHU_ID': 2256,\n",
       "  'Address': '169 Pine Street South',\n",
       "  'City': 'Timmins',\n",
       "  'Postal_Code': 'P4N 8B7',\n",
       "  'Website': 'www.porcupinehu.on.ca'},\n",
       " 29: {'PHU': 'Grey Bruce Health Unit',\n",
       "  'PHU_ID': 2233,\n",
       "  'Address': '101 17th Street East',\n",
       "  'City': 'Owen Sound',\n",
       "  'Postal_Code': 'N4K 0A5',\n",
       "  'Website': 'www.publichealthgreybruce.on.ca/'},\n",
       " 30: {'PHU': 'Renfrew County and District Health Unit',\n",
       "  'PHU_ID': 2257,\n",
       "  'Address': '7 International Drive',\n",
       "  'City': 'Pembroke',\n",
       "  'Postal_Code': 'K8A 6W5',\n",
       "  'Website': 'www.rcdhu.com'},\n",
       " 31: {'PHU': 'North Bay Parry Sound District Health Unit',\n",
       "  'PHU_ID': 2247,\n",
       "  'Address': '345 Oak Street West',\n",
       "  'City': 'North Bay',\n",
       "  'Postal_Code': 'P1B 2T2',\n",
       "  'Website': 'www.myhealthunit.ca '},\n",
       " 32: {'PHU': 'Algoma Public Health Unit',\n",
       "  'PHU_ID': 2226,\n",
       "  'Address': '294 Willow Avenue',\n",
       "  'City': 'Sault Ste. Marie',\n",
       "  'Postal_Code': 'P6B 0A9',\n",
       "  'Website': 'www.algomapublichealth.com'},\n",
       " 33: {'PHU': 'Timiskaming Health Unit',\n",
       "  'PHU_ID': 2263,\n",
       "  'Address': '247 Whitewood Avenue, Unit 43',\n",
       "  'City': 'New Liskeard',\n",
       "  'Postal_Code': 'P0J 1P0',\n",
       "  'Website': 'www.timiskaminghu.com'}}"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# creating dataframe with PHU info and converting to dict\n",
    "info = phu_sorted[['PHU','PHU_ID','Address','City','Postal_Code','Website']].to_dict(orient='index')\n",
    "info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{0: {'PHU': 'Toronto Public Health',\n",
       "  'Age_Under_20': 407.0,\n",
       "  'Age_20s': 365.0,\n",
       "  'Age_30s': 419.0,\n",
       "  'Age_40s': 463.0,\n",
       "  'Age_50s': 552.0,\n",
       "  'Age_60s': 328.0,\n",
       "  'Age_70s': 256.0,\n",
       "  'Age_80s': 436.0,\n",
       "  'Age_Over_90': 355.0,\n",
       "  'Female': 1996.0,\n",
       "  'Male': 1520.0,\n",
       "  'Unknown': 65.0,\n",
       "  'Fatal': 275.0,\n",
       "  'Not_Resolved': 70.0,\n",
       "  'Resolved': 3236.0,\n",
       "  'Total_Cases': 3581.0},\n",
       " 1: {'PHU': 'Peel Public Health',\n",
       "  'Age_Under_20': 163.0,\n",
       "  'Age_20s': 443.0,\n",
       "  'Age_30s': 326.0,\n",
       "  'Age_40s': 372.0,\n",
       "  'Age_50s': 329.0,\n",
       "  'Age_60s': 156.0,\n",
       "  'Age_70s': 70.0,\n",
       "  'Age_80s': 116.0,\n",
       "  'Age_Over_90': 102.0,\n",
       "  'Female': 1114.0,\n",
       "  'Male': 961.0,\n",
       "  'Unknown': 2.0,\n",
       "  'Fatal': 70.0,\n",
       "  'Not_Resolved': 62.0,\n",
       "  'Resolved': 1945.0,\n",
       "  'Total_Cases': 2077.0},\n",
       " 2: {'PHU': 'York Region Public Health Services',\n",
       "  'Age_Under_20': 122.0,\n",
       "  'Age_20s': 90.0,\n",
       "  'Age_30s': 115.0,\n",
       "  'Age_40s': 124.0,\n",
       "  'Age_50s': 165.0,\n",
       "  'Age_60s': 102.0,\n",
       "  'Age_70s': 54.0,\n",
       "  'Age_80s': 98.0,\n",
       "  'Age_Over_90': 73.0,\n",
       "  'Female': 494.0,\n",
       "  'Male': 444.0,\n",
       "  'Unknown': 5.0,\n",
       "  'Fatal': 63.0,\n",
       "  'Not_Resolved': 11.0,\n",
       "  'Resolved': 869.0,\n",
       "  'Total_Cases': 943.0},\n",
       " 3: {'PHU': 'Ottawa Public Health',\n",
       "  'Age_Under_20': 122.0,\n",
       "  'Age_20s': 103.0,\n",
       "  'Age_30s': 91.0,\n",
       "  'Age_40s': 103.0,\n",
       "  'Age_50s': 95.0,\n",
       "  'Age_60s': 75.0,\n",
       "  'Age_70s': 52.0,\n",
       "  'Age_80s': 95.0,\n",
       "  'Age_Over_90': 72.0,\n",
       "  'Female': 462.0,\n",
       "  'Male': 345.0,\n",
       "  'Unknown': 1.0,\n",
       "  'Fatal': 64.0,\n",
       "  'Not_Resolved': 14.0,\n",
       "  'Resolved': 730.0,\n",
       "  'Total_Cases': 808.0},\n",
       " 4: {'PHU': 'Niagara Region Public Health Department',\n",
       "  'Age_Under_20': 49.0,\n",
       "  'Age_20s': 108.0,\n",
       "  'Age_30s': 105.0,\n",
       "  'Age_40s': 86.0,\n",
       "  'Age_50s': 89.0,\n",
       "  'Age_60s': 58.0,\n",
       "  'Age_70s': 61.0,\n",
       "  'Age_80s': 94.0,\n",
       "  'Age_Over_90': 76.0,\n",
       "  'Female': 469.0,\n",
       "  'Male': 256.0,\n",
       "  'Unknown': 1.0,\n",
       "  'Fatal': 47.0,\n",
       "  'Not_Resolved': 20.0,\n",
       "  'Resolved': 659.0,\n",
       "  'Total_Cases': 726.0},\n",
       " 5: {'PHU': 'Windsor-Essex County Health Unit',\n",
       "  'Age_Under_20': 26.0,\n",
       "  'Age_20s': 153.0,\n",
       "  'Age_30s': 119.0,\n",
       "  'Age_40s': 110.0,\n",
       "  'Age_50s': 76.0,\n",
       "  'Age_60s': 48.0,\n",
       "  'Age_70s': 48.0,\n",
       "  'Age_80s': 65.0,\n",
       "  'Age_Over_90': 55.0,\n",
       "  'Female': 304.0,\n",
       "  'Male': 384.0,\n",
       "  'Unknown': 12.0,\n",
       "  'Fatal': 50.0,\n",
       "  'Not_Resolved': 3.0,\n",
       "  'Resolved': 647.0,\n",
       "  'Total_Cases': 700.0},\n",
       " 6: {'PHU': 'Hamilton Public Health Services',\n",
       "  'Age_Under_20': 51.0,\n",
       "  'Age_20s': 100.0,\n",
       "  'Age_30s': 86.0,\n",
       "  'Age_40s': 83.0,\n",
       "  'Age_50s': 84.0,\n",
       "  'Age_60s': 66.0,\n",
       "  'Age_70s': 46.0,\n",
       "  'Age_80s': 65.0,\n",
       "  'Age_Over_90': 49.0,\n",
       "  'Female': 331.0,\n",
       "  'Male': 297.0,\n",
       "  'Unknown': 2.0,\n",
       "  'Fatal': 32.0,\n",
       "  'Not_Resolved': 30.0,\n",
       "  'Resolved': 568.0,\n",
       "  'Total_Cases': 630.0},\n",
       " 7: {'PHU': 'Durham Region Health Department',\n",
       "  'Age_Under_20': 81.0,\n",
       "  'Age_20s': 70.0,\n",
       "  'Age_30s': 80.0,\n",
       "  'Age_40s': 97.0,\n",
       "  'Age_50s': 109.0,\n",
       "  'Age_60s': 45.0,\n",
       "  'Age_70s': 28.0,\n",
       "  'Age_80s': 57.0,\n",
       "  'Age_Over_90': 42.0,\n",
       "  'Female': 378.0,\n",
       "  'Male': 231.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 39.0,\n",
       "  'Not_Resolved': 22.0,\n",
       "  'Resolved': 548.0,\n",
       "  'Total_Cases': 609.0},\n",
       " 8: {'PHU': 'Region of Waterloo, Public Health',\n",
       "  'Age_Under_20': 44.0,\n",
       "  'Age_20s': 106.0,\n",
       "  'Age_30s': 70.0,\n",
       "  'Age_40s': 78.0,\n",
       "  'Age_50s': 65.0,\n",
       "  'Age_60s': 44.0,\n",
       "  'Age_70s': 29.0,\n",
       "  'Age_80s': 49.0,\n",
       "  'Age_Over_90': 31.0,\n",
       "  'Female': 248.0,\n",
       "  'Male': 266.0,\n",
       "  'Unknown': 2.0,\n",
       "  'Fatal': 30.0,\n",
       "  'Not_Resolved': 4.0,\n",
       "  'Resolved': 482.0,\n",
       "  'Total_Cases': 516.0},\n",
       " 9: {'PHU': 'Halton Region Health Department',\n",
       "  'Age_Under_20': 43.0,\n",
       "  'Age_20s': 52.0,\n",
       "  'Age_30s': 64.0,\n",
       "  'Age_40s': 77.0,\n",
       "  'Age_50s': 70.0,\n",
       "  'Age_60s': 36.0,\n",
       "  'Age_70s': 24.0,\n",
       "  'Age_80s': 61.0,\n",
       "  'Age_Over_90': 45.0,\n",
       "  'Female': 240.0,\n",
       "  'Male': 232.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 24.0,\n",
       "  'Not_Resolved': 15.0,\n",
       "  'Resolved': 433.0,\n",
       "  'Total_Cases': 472.0},\n",
       " 10: {'PHU': 'Middlesex-London Health Unit',\n",
       "  'Age_Under_20': 100.0,\n",
       "  'Age_20s': 65.0,\n",
       "  'Age_30s': 47.0,\n",
       "  'Age_40s': 50.0,\n",
       "  'Age_50s': 54.0,\n",
       "  'Age_60s': 22.0,\n",
       "  'Age_70s': 18.0,\n",
       "  'Age_80s': 21.0,\n",
       "  'Age_Over_90': 12.0,\n",
       "  'Female': 202.0,\n",
       "  'Male': 187.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 17.0,\n",
       "  'Not_Resolved': 21.0,\n",
       "  'Resolved': 351.0,\n",
       "  'Total_Cases': 389.0},\n",
       " 11: {'PHU': 'Simcoe Muskoka District Health Unit',\n",
       "  'Age_Under_20': 46.0,\n",
       "  'Age_20s': 73.0,\n",
       "  'Age_30s': 62.0,\n",
       "  'Age_40s': 51.0,\n",
       "  'Age_50s': 52.0,\n",
       "  'Age_60s': 32.0,\n",
       "  'Age_70s': 21.0,\n",
       "  'Age_80s': 30.0,\n",
       "  'Age_Over_90': 16.0,\n",
       "  'Female': 211.0,\n",
       "  'Male': 172.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 22.0,\n",
       "  'Not_Resolved': 9.0,\n",
       "  'Resolved': 352.0,\n",
       "  'Total_Cases': 383.0},\n",
       " 12: {'PHU': 'Wellington-Dufferin-Guelph Public Health',\n",
       "  'Age_Under_20': 26.0,\n",
       "  'Age_20s': 42.0,\n",
       "  'Age_30s': 61.0,\n",
       "  'Age_40s': 40.0,\n",
       "  'Age_50s': 37.0,\n",
       "  'Age_60s': 19.0,\n",
       "  'Age_70s': 8.0,\n",
       "  'Age_80s': 24.0,\n",
       "  'Age_Over_90': 16.0,\n",
       "  'Female': 140.0,\n",
       "  'Male': 123.0,\n",
       "  'Unknown': 10.0,\n",
       "  'Fatal': 13.0,\n",
       "  'Not_Resolved': 4.0,\n",
       "  'Resolved': 256.0,\n",
       "  'Total_Cases': 273.0},\n",
       " 13: {'PHU': 'Thunder Bay District Health Unit',\n",
       "  'Age_Under_20': 15.0,\n",
       "  'Age_20s': 36.0,\n",
       "  'Age_30s': 38.0,\n",
       "  'Age_40s': 29.0,\n",
       "  'Age_50s': 31.0,\n",
       "  'Age_60s': 16.0,\n",
       "  'Age_70s': 8.0,\n",
       "  'Age_80s': 13.0,\n",
       "  'Age_Over_90': 7.0,\n",
       "  'Female': 86.0,\n",
       "  'Male': 105.0,\n",
       "  'Unknown': 2.0,\n",
       "  'Fatal': 11.0,\n",
       "  'Not_Resolved': 0.0,\n",
       "  'Resolved': 182.0,\n",
       "  'Total_Cases': 193.0},\n",
       " 14: {'PHU': 'Southwestern Public Health',\n",
       "  'Age_Under_20': 6.0,\n",
       "  'Age_20s': 32.0,\n",
       "  'Age_30s': 28.0,\n",
       "  'Age_40s': 23.0,\n",
       "  'Age_50s': 25.0,\n",
       "  'Age_60s': 12.0,\n",
       "  'Age_70s': 14.0,\n",
       "  'Age_80s': 8.0,\n",
       "  'Age_Over_90': 7.0,\n",
       "  'Female': 70.0,\n",
       "  'Male': 84.0,\n",
       "  'Unknown': 1.0,\n",
       "  'Fatal': 8.0,\n",
       "  'Not_Resolved': 3.0,\n",
       "  'Resolved': 144.0,\n",
       "  'Total_Cases': 155.0},\n",
       " 15: {'PHU': 'Eastern Ontario Health Unit',\n",
       "  'Age_Under_20': 15.0,\n",
       "  'Age_20s': 8.0,\n",
       "  'Age_30s': 7.0,\n",
       "  'Age_40s': 14.0,\n",
       "  'Age_50s': 18.0,\n",
       "  'Age_60s': 13.0,\n",
       "  'Age_70s': 10.0,\n",
       "  'Age_80s': 19.0,\n",
       "  'Age_Over_90': 14.0,\n",
       "  'Female': 78.0,\n",
       "  'Male': 40.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 13.0,\n",
       "  'Not_Resolved': 2.0,\n",
       "  'Resolved': 103.0,\n",
       "  'Total_Cases': 118.0},\n",
       " 16: {'PHU': 'Haldimand-Norfolk Health Unit',\n",
       "  'Age_Under_20': 7.0,\n",
       "  'Age_20s': 19.0,\n",
       "  'Age_30s': 20.0,\n",
       "  'Age_40s': 26.0,\n",
       "  'Age_50s': 20.0,\n",
       "  'Age_60s': 5.0,\n",
       "  'Age_70s': 4.0,\n",
       "  'Age_80s': 3.0,\n",
       "  'Age_Over_90': 7.0,\n",
       "  'Female': 44.0,\n",
       "  'Male': 66.0,\n",
       "  'Unknown': 1.0,\n",
       "  'Fatal': 1.0,\n",
       "  'Not_Resolved': 2.0,\n",
       "  'Resolved': 108.0,\n",
       "  'Total_Cases': 111.0},\n",
       " 17: {'PHU': 'Lambton Public Health',\n",
       "  'Age_Under_20': 14.0,\n",
       "  'Age_20s': 9.0,\n",
       "  'Age_30s': 10.0,\n",
       "  'Age_40s': 14.0,\n",
       "  'Age_50s': 13.0,\n",
       "  'Age_60s': 7.0,\n",
       "  'Age_70s': 6.0,\n",
       "  'Age_80s': 12.0,\n",
       "  'Age_Over_90': 11.0,\n",
       "  'Female': 52.0,\n",
       "  'Male': 44.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 5.0,\n",
       "  'Not_Resolved': 4.0,\n",
       "  'Resolved': 87.0,\n",
       "  'Total_Cases': 96.0},\n",
       " 18: {'PHU': 'Leeds, Grenville and Lanark District Health Unit',\n",
       "  'Age_Under_20': 8.0,\n",
       "  'Age_20s': 8.0,\n",
       "  'Age_30s': 5.0,\n",
       "  'Age_40s': 10.0,\n",
       "  'Age_50s': 13.0,\n",
       "  'Age_60s': 15.0,\n",
       "  'Age_70s': 15.0,\n",
       "  'Age_80s': 9.0,\n",
       "  'Age_Over_90': 12.0,\n",
       "  'Female': 55.0,\n",
       "  'Male': 40.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 6.0,\n",
       "  'Not_Resolved': 0.0,\n",
       "  'Resolved': 89.0,\n",
       "  'Total_Cases': 95.0},\n",
       " 19: {'PHU': 'Sudbury & District Health Unit',\n",
       "  'Age_Under_20': 18.0,\n",
       "  'Age_20s': 14.0,\n",
       "  'Age_30s': 10.0,\n",
       "  'Age_40s': 15.0,\n",
       "  'Age_50s': 8.0,\n",
       "  'Age_60s': 9.0,\n",
       "  'Age_70s': 3.0,\n",
       "  'Age_80s': 4.0,\n",
       "  'Age_Over_90': 6.0,\n",
       "  'Female': 45.0,\n",
       "  'Male': 41.0,\n",
       "  'Unknown': 1.0,\n",
       "  'Fatal': 3.0,\n",
       "  'Not_Resolved': 1.0,\n",
       "  'Resolved': 83.0,\n",
       "  'Total_Cases': 87.0},\n",
       " 20: {'PHU': 'Brant County Health Unit',\n",
       "  'Age_Under_20': 15.0,\n",
       "  'Age_20s': 13.0,\n",
       "  'Age_30s': 13.0,\n",
       "  'Age_40s': 12.0,\n",
       "  'Age_50s': 8.0,\n",
       "  'Age_60s': 6.0,\n",
       "  'Age_70s': 2.0,\n",
       "  'Age_80s': 2.0,\n",
       "  'Age_Over_90': 0.0,\n",
       "  'Female': 33.0,\n",
       "  'Male': 38.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 2.0,\n",
       "  'Not_Resolved': 0.0,\n",
       "  'Resolved': 69.0,\n",
       "  'Total_Cases': 71.0},\n",
       " 21: {'PHU': 'Huron Perth District Health Unit',\n",
       "  'Age_Under_20': 1.0,\n",
       "  'Age_20s': 10.0,\n",
       "  'Age_30s': 10.0,\n",
       "  'Age_40s': 7.0,\n",
       "  'Age_50s': 6.0,\n",
       "  'Age_60s': 3.0,\n",
       "  'Age_70s': 4.0,\n",
       "  'Age_80s': 17.0,\n",
       "  'Age_Over_90': 12.0,\n",
       "  'Female': 45.0,\n",
       "  'Male': 25.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 8.0,\n",
       "  'Not_Resolved': 1.0,\n",
       "  'Resolved': 61.0,\n",
       "  'Total_Cases': 70.0},\n",
       " 22: {'PHU': 'Haliburton, Kawartha, Pine Ridge District Health Unit',\n",
       "  'Age_Under_20': 7.0,\n",
       "  'Age_20s': 9.0,\n",
       "  'Age_30s': 6.0,\n",
       "  'Age_40s': 9.0,\n",
       "  'Age_50s': 12.0,\n",
       "  'Age_60s': 5.0,\n",
       "  'Age_70s': 5.0,\n",
       "  'Age_80s': 7.0,\n",
       "  'Age_Over_90': 7.0,\n",
       "  'Female': 42.0,\n",
       "  'Male': 25.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 4.0,\n",
       "  'Not_Resolved': 4.0,\n",
       "  'Resolved': 59.0,\n",
       "  'Total_Cases': 67.0},\n",
       " 23: {'PHU': 'Northwestern Health Unit',\n",
       "  'Age_Under_20': 11.0,\n",
       "  'Age_20s': 4.0,\n",
       "  'Age_30s': 11.0,\n",
       "  'Age_40s': 6.0,\n",
       "  'Age_50s': 7.0,\n",
       "  'Age_60s': 6.0,\n",
       "  'Age_70s': 3.0,\n",
       "  'Age_80s': 2.0,\n",
       "  'Age_Over_90': 2.0,\n",
       "  'Female': 23.0,\n",
       "  'Male': 27.0,\n",
       "  'Unknown': 2.0,\n",
       "  'Fatal': 1.0,\n",
       "  'Not_Resolved': 0.0,\n",
       "  'Resolved': 51.0,\n",
       "  'Total_Cases': 52.0},\n",
       " 24: {'PHU': 'Chatham-Kent Health Unit',\n",
       "  'Age_Under_20': 6.0,\n",
       "  'Age_20s': 5.0,\n",
       "  'Age_30s': 12.0,\n",
       "  'Age_40s': 11.0,\n",
       "  'Age_50s': 5.0,\n",
       "  'Age_60s': 4.0,\n",
       "  'Age_70s': 2.0,\n",
       "  'Age_80s': 2.0,\n",
       "  'Age_Over_90': 2.0,\n",
       "  'Female': 28.0,\n",
       "  'Male': 21.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 1.0,\n",
       "  'Not_Resolved': 1.0,\n",
       "  'Resolved': 47.0,\n",
       "  'Total_Cases': 49.0},\n",
       " 25: {'PHU': 'Kingston, Frontenac and Lennox & Addington Public Health',\n",
       "  'Age_Under_20': 12.0,\n",
       "  'Age_20s': 7.0,\n",
       "  'Age_30s': 7.0,\n",
       "  'Age_40s': 3.0,\n",
       "  'Age_50s': 8.0,\n",
       "  'Age_60s': 8.0,\n",
       "  'Age_70s': 0.0,\n",
       "  'Age_80s': 0.0,\n",
       "  'Age_Over_90': 2.0,\n",
       "  'Female': 24.0,\n",
       "  'Male': 23.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 0.0,\n",
       "  'Not_Resolved': 3.0,\n",
       "  'Resolved': 44.0,\n",
       "  'Total_Cases': 47.0},\n",
       " 26: {'PHU': 'Hastings and Prince Edward Counties Health Unit',\n",
       "  'Age_Under_20': 8.0,\n",
       "  'Age_20s': 8.0,\n",
       "  'Age_30s': 3.0,\n",
       "  'Age_40s': 4.0,\n",
       "  'Age_50s': 8.0,\n",
       "  'Age_60s': 1.0,\n",
       "  'Age_70s': 4.0,\n",
       "  'Age_80s': 1.0,\n",
       "  'Age_Over_90': 0.0,\n",
       "  'Female': 15.0,\n",
       "  'Male': 22.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 1.0,\n",
       "  'Not_Resolved': 0.0,\n",
       "  'Resolved': 36.0,\n",
       "  'Total_Cases': 37.0},\n",
       " 27: {'PHU': 'Peterborough Public Health',\n",
       "  'Age_Under_20': 6.0,\n",
       "  'Age_20s': 10.0,\n",
       "  'Age_30s': 2.0,\n",
       "  'Age_40s': 6.0,\n",
       "  'Age_50s': 4.0,\n",
       "  'Age_60s': 2.0,\n",
       "  'Age_70s': 2.0,\n",
       "  'Age_80s': 3.0,\n",
       "  'Age_Over_90': 1.0,\n",
       "  'Female': 21.0,\n",
       "  'Male': 14.0,\n",
       "  'Unknown': 1.0,\n",
       "  'Fatal': 0.0,\n",
       "  'Not_Resolved': 3.0,\n",
       "  'Resolved': 33.0,\n",
       "  'Total_Cases': 36.0},\n",
       " 28: {'PHU': 'Porcupine Health Unit',\n",
       "  'Age_Under_20': 5.0,\n",
       "  'Age_20s': 5.0,\n",
       "  'Age_30s': 6.0,\n",
       "  'Age_40s': 2.0,\n",
       "  'Age_50s': 5.0,\n",
       "  'Age_60s': 4.0,\n",
       "  'Age_70s': 0.0,\n",
       "  'Age_80s': 3.0,\n",
       "  'Age_Over_90': 2.0,\n",
       "  'Female': 18.0,\n",
       "  'Male': 13.0,\n",
       "  'Unknown': 1.0,\n",
       "  'Fatal': 0.0,\n",
       "  'Not_Resolved': 2.0,\n",
       "  'Resolved': 30.0,\n",
       "  'Total_Cases': 32.0},\n",
       " 29: {'PHU': 'Grey Bruce Health Unit',\n",
       "  'Age_Under_20': 10.0,\n",
       "  'Age_20s': 1.0,\n",
       "  'Age_30s': 1.0,\n",
       "  'Age_40s': 6.0,\n",
       "  'Age_50s': 6.0,\n",
       "  'Age_60s': 2.0,\n",
       "  'Age_70s': 1.0,\n",
       "  'Age_80s': 3.0,\n",
       "  'Age_Over_90': 1.0,\n",
       "  'Female': 19.0,\n",
       "  'Male': 12.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 0.0,\n",
       "  'Not_Resolved': 0.0,\n",
       "  'Resolved': 31.0,\n",
       "  'Total_Cases': 31.0},\n",
       " 30: {'PHU': 'Renfrew County and District Health Unit',\n",
       "  'Age_Under_20': 9.0,\n",
       "  'Age_20s': 2.0,\n",
       "  'Age_30s': 5.0,\n",
       "  'Age_40s': 5.0,\n",
       "  'Age_50s': 3.0,\n",
       "  'Age_60s': 1.0,\n",
       "  'Age_70s': 1.0,\n",
       "  'Age_80s': 1.0,\n",
       "  'Age_Over_90': 1.0,\n",
       "  'Female': 13.0,\n",
       "  'Male': 14.0,\n",
       "  'Unknown': 1.0,\n",
       "  'Fatal': 0.0,\n",
       "  'Not_Resolved': 1.0,\n",
       "  'Resolved': 27.0,\n",
       "  'Total_Cases': 28.0},\n",
       " 31: {'PHU': 'North Bay Parry Sound District Health Unit',\n",
       "  'Age_Under_20': 3.0,\n",
       "  'Age_20s': 6.0,\n",
       "  'Age_30s': 2.0,\n",
       "  'Age_40s': 3.0,\n",
       "  'Age_50s': 2.0,\n",
       "  'Age_60s': 3.0,\n",
       "  'Age_70s': 1.0,\n",
       "  'Age_80s': 0.0,\n",
       "  'Age_Over_90': 0.0,\n",
       "  'Female': 11.0,\n",
       "  'Male': 9.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 0.0,\n",
       "  'Not_Resolved': 3.0,\n",
       "  'Resolved': 17.0,\n",
       "  'Total_Cases': 20.0},\n",
       " 32: {'PHU': 'Algoma Public Health Unit',\n",
       "  'Age_Under_20': 1.0,\n",
       "  'Age_20s': 5.0,\n",
       "  'Age_30s': 3.0,\n",
       "  'Age_40s': 2.0,\n",
       "  'Age_50s': 0.0,\n",
       "  'Age_60s': 1.0,\n",
       "  'Age_70s': 0.0,\n",
       "  'Age_80s': 0.0,\n",
       "  'Age_Over_90': 0.0,\n",
       "  'Female': 4.0,\n",
       "  'Male': 8.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 0.0,\n",
       "  'Not_Resolved': 0.0,\n",
       "  'Resolved': 12.0,\n",
       "  'Total_Cases': 12.0},\n",
       " 33: {'PHU': 'Timiskaming Health Unit',\n",
       "  'Age_Under_20': 1.0,\n",
       "  'Age_20s': 2.0,\n",
       "  'Age_30s': 2.0,\n",
       "  'Age_40s': 2.0,\n",
       "  'Age_50s': 2.0,\n",
       "  'Age_60s': 0.0,\n",
       "  'Age_70s': 0.0,\n",
       "  'Age_80s': 1.0,\n",
       "  'Age_Over_90': 0.0,\n",
       "  'Female': 6.0,\n",
       "  'Male': 4.0,\n",
       "  'Unknown': 0.0,\n",
       "  'Fatal': 1.0,\n",
       "  'Not_Resolved': 0.0,\n",
       "  'Resolved': 9.0,\n",
       "  'Total_Cases': 10.0}}"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# creating stats dataframe into dict\n",
    "stats = phu_sorted[['PHU','Age_Under_20','Age_20s','Age_30s','Age_40s','Age_50s','Age_60s','Age_70s','Age_80s',\n",
    "                    'Age_Over_90','Female','Male','Unknown','Fatal','Not_Resolved','Resolved',\n",
    "                    'Total_Cases']].to_dict(orient='index')\n",
    "stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'{\"name\": {\"PHU\": {\"0\": \"Toronto Public Health\", \"1\": \"Peel Public Health\", \"2\": \"York Region Public Health Services\", \"3\": \"Ottawa Public Health\", \"4\": \"Niagara Region Public Health Department\", \"5\": \"Windsor-Essex County Health Unit\", \"6\": \"Hamilton Public Health Services\", \"7\": \"Durham Region Health Department\", \"8\": \"Region of Waterloo, Public Health\", \"9\": \"Halton Region Health Department\", \"10\": \"Middlesex-London Health Unit\", \"11\": \"Simcoe Muskoka District Health Unit\", \"12\": \"Wellington-Dufferin-Guelph Public Health\", \"13\": \"Thunder Bay District Health Unit\", \"14\": \"Southwestern Public Health\", \"15\": \"Eastern Ontario Health Unit\", \"16\": \"Haldimand-Norfolk Health Unit\", \"17\": \"Lambton Public Health\", \"18\": \"Leeds, Grenville and Lanark District Health Unit\", \"19\": \"Sudbury & District Health Unit\", \"20\": \"Brant County Health Unit\", \"21\": \"Huron Perth District Health Unit\", \"22\": \"Haliburton, Kawartha, Pine Ridge District Health Unit\", \"23\": \"Northwestern Health Unit\", \"24\": \"Chatham-Kent Health Unit\", \"25\": \"Kingston, Frontenac and Lennox & Addington Public Health\", \"26\": \"Hastings and Prince Edward Counties Health Unit\", \"27\": \"Peterborough Public Health\", \"28\": \"Porcupine Health Unit\", \"29\": \"Grey Bruce Health Unit\", \"30\": \"Renfrew County and District Health Unit\", \"31\": \"North Bay Parry Sound District Health Unit\", \"32\": \"Algoma Public Health Unit\", \"33\": \"Timiskaming Health Unit\"}}, \"info\": {\"0\": {\"PHU\": \"Toronto Public Health\", \"PHU_ID\": 3895, \"Address\": \"277 Victoria Street, 5th Floor\", \"City\": \"Toronto\", \"Postal_Code\": \"M5B 1W2\", \"Website\": \"www.toronto.ca/community-people/health-wellness-care/\"}, \"1\": {\"PHU\": \"Peel Public Health\", \"PHU_ID\": 2253, \"Address\": \"7120 Hurontario Street\", \"City\": \"Mississauga\", \"Postal_Code\": \"L5W 1N4\", \"Website\": \"www.peelregion.ca/health/\"}, \"2\": {\"PHU\": \"York Region Public Health Services\", \"PHU_ID\": 2270, \"Address\": \"17250 Yonge Street\", \"City\": \"Newmarket\", \"Postal_Code\": \"L3Y 6Z1\", \"Website\": \"www.york.ca/wps/portal/yorkhome/health/ \"}, \"3\": {\"PHU\": \"Ottawa Public Health\", \"PHU_ID\": 2251, \"Address\": \"100 Constellation Drive\", \"City\": \"Ottawa\", \"Postal_Code\": \"K2G 6J8\", \"Website\": \"www.ottawapublichealth.ca\"}, \"4\": {\"PHU\": \"Niagara Region Public Health Department\", \"PHU_ID\": 2246, \"Address\": \"1815 Sir Isaac Brock Way\", \"City\": \"Thorold\", \"Postal_Code\": \"L2V 4T7\", \"Website\": \"www.niagararegion.ca/health\"}, \"5\": {\"PHU\": \"Windsor-Essex County Health Unit\", \"PHU_ID\": 2268, \"Address\": \"1005 Ouellette Avenue\", \"City\": \"Windsor\", \"Postal_Code\": \"N9A 4J8\", \"Website\": \"www.wechu.org\"}, \"6\": {\"PHU\": \"Hamilton Public Health Services\", \"PHU_ID\": 2237, \"Address\": \"110 King St. West, 2nd Floor\", \"City\": \"Hamilton\", \"Postal_Code\": \"L8P 4S6\", \"Website\": \"www.hamilton.ca/publichealth\"}, \"7\": {\"PHU\": \"Durham Region Health Department\", \"PHU_ID\": 2230, \"Address\": \"605 Rossland Road East\", \"City\": \"Whitby\", \"Postal_Code\": \"L1N 0B2\", \"Website\": \"www.durham.ca/en/health-and-wellness/health-and-wellness.aspx\"}, \"8\": {\"PHU\": \"Region of Waterloo, Public Health\", \"PHU_ID\": 2265, \"Address\": \"99 Regina Street South\", \"City\": \"Waterloo\", \"Postal_Code\": \"N2J 4V3\", \"Website\": \"www.regionofwaterloo.ca\"}, \"9\": {\"PHU\": \"Halton Region Health Department\", \"PHU_ID\": 2236, \"Address\": \"1151 Bronte Road\", \"City\": \"Oakville\", \"Postal_Code\": \"L6M 3Ll\", \"Website\": \"www.halton.ca/For-Residents/Public-Health/ \"}, \"10\": {\"PHU\": \"Middlesex-London Health Unit\", \"PHU_ID\": 2244, \"Address\": \"50 King Street\", \"City\": \"London\", \"Postal_Code\": \"N6A 5L7\", \"Website\": \"www.healthunit.com\"}, \"11\": {\"PHU\": \"Simcoe Muskoka District Health Unit\", \"PHU_ID\": 2260, \"Address\": \"15 Sperling Drive\", \"City\": \"Barrie\", \"Postal_Code\": \"L4M 6K9\", \"Website\": \"www.simcoemuskokahealth.org\"}, \"12\": {\"PHU\": \"Wellington-Dufferin-Guelph Public Health\", \"PHU_ID\": 2266, \"Address\": \"160 Chancellors Way\", \"City\": \"Guelph\", \"Postal_Code\": \"N1G 0E1\", \"Website\": \"www.wdgpublichealth.ca\"}, \"13\": {\"PHU\": \"Thunder Bay District Health Unit\", \"PHU_ID\": 2262, \"Address\": \"999 Balmoral Street\", \"City\": \"Thunder Bay\", \"Postal_Code\": \"P7B 6E7\", \"Website\": \"www.tbdhu.com\"}, \"14\": {\"PHU\": \"Southwestern Public Health\", \"PHU_ID\": 4913, \"Address\": \"1230 Talbot Street\", \"City\": \"St. Thomas\", \"Postal_Code\": \"N5P 1G9\", \"Website\": \"www.swpublichealth.ca\"}, \"15\": {\"PHU\": \"Eastern Ontario Health Unit\", \"PHU_ID\": 2258, \"Address\": \"1000 Pitt Street\", \"City\": \"Cornwall\", \"Postal_Code\": \"K6J 5T1\", \"Website\": \"www.eohu.ca\"}, \"16\": {\"PHU\": \"Haldimand-Norfolk Health Unit\", \"PHU_ID\": 2234, \"Address\": \"12 Gilbertson Drive\", \"City\": \"Simcoe\", \"Postal_Code\": \"N3Y 4N5\", \"Website\": \"www.hnhu.org\"}, \"17\": {\"PHU\": \"Lambton Public Health\", \"PHU_ID\": 2242, \"Address\": \"160 Exmouth Street\", \"City\": \"Point Edward\", \"Postal_Code\": \"N7T 7Z6\", \"Website\": \"www.lambtonhealth.on.ca\"}, \"18\": {\"PHU\": \"Leeds, Grenville and Lanark District Health Unit\", \"PHU_ID\": 2243, \"Address\": \"458 Laurier Boulevard\", \"City\": \"Brockville\", \"Postal_Code\": \"K6V 7A3\", \"Website\": \"www.healthunit.org\"}, \"19\": {\"PHU\": \"Sudbury & District Health Unit\", \"PHU_ID\": 2261, \"Address\": \"1300 Paris Street\", \"City\": \"Sudbury\", \"Postal_Code\": \"P3E 3A3\", \"Website\": \"www.phsd.ca\"}, \"20\": {\"PHU\": \"Brant County Health Unit\", \"PHU_ID\": 2227, \"Address\": \"194 Terrace Hill Street\", \"City\": \"Brantford\", \"Postal_Code\": \"N3R 1G7\", \"Website\": \"www.bchu.org/\"}, \"21\": {\"PHU\": \"Huron Perth District Health Unit\", \"PHU_ID\": 5183, \"Address\": \"653 West Gore Street\", \"City\": \"Stratford\", \"Postal_Code\": \"N5A 1L4\", \"Website\": \"www.hpph.ca\"}, \"22\": {\"PHU\": \"Haliburton, Kawartha, Pine Ridge District Health Unit\", \"PHU_ID\": 2235, \"Address\": \"200 Rose Glen Road\", \"City\": \"Port Hope\", \"Postal_Code\": \"L1A 3V6\", \"Website\": \"www.hkpr.on.ca/\"}, \"23\": {\"PHU\": \"Northwestern Health Unit\", \"PHU_ID\": 2249, \"Address\": \"210 First Street North \", \"City\": \"Kenora\", \"Postal_Code\": \"P9N 2K4\", \"Website\": \"www.nwhu.on.ca\"}, \"24\": {\"PHU\": \"Chatham-Kent Health Unit\", \"PHU_ID\": 2240, \"Address\": \"435 Grand Avenue West\", \"City\": \"Chatham\", \"Postal_Code\": \"N7M 5L8\", \"Website\": \"www.ckphu.com\"}, \"25\": {\"PHU\": \"Kingston, Frontenac and Lennox & Addington Public Health\", \"PHU_ID\": 2241, \"Address\": \"221 Portsmouth Avenue\", \"City\": \"Kingston\", \"Postal_Code\": \"K7M 1V5\", \"Website\": \"www.kflaph.ca\"}, \"26\": {\"PHU\": \"Hastings and Prince Edward Counties Health Unit\", \"PHU_ID\": 2238, \"Address\": \"179 North Park Street\", \"City\": \"Belleville\", \"Postal_Code\": \"K8P 4P1\", \"Website\": \"www.hpePublicHealth.ca\"}, \"27\": {\"PHU\": \"Peterborough Public Health\", \"PHU_ID\": 2255, \"Address\": \"185 King Street\", \"City\": \"Peterborough\", \"Postal_Code\": \"K9J 2R8\", \"Website\": \"www.peterboroughpublichealth.ca\"}, \"28\": {\"PHU\": \"Porcupine Health Unit\", \"PHU_ID\": 2256, \"Address\": \"169 Pine Street South\", \"City\": \"Timmins\", \"Postal_Code\": \"P4N 8B7\", \"Website\": \"www.porcupinehu.on.ca\"}, \"29\": {\"PHU\": \"Grey Bruce Health Unit\", \"PHU_ID\": 2233, \"Address\": \"101 17th Street East\", \"City\": \"Owen Sound\", \"Postal_Code\": \"N4K 0A5\", \"Website\": \"www.publichealthgreybruce.on.ca/\"}, \"30\": {\"PHU\": \"Renfrew County and District Health Unit\", \"PHU_ID\": 2257, \"Address\": \"7 International Drive\", \"City\": \"Pembroke\", \"Postal_Code\": \"K8A 6W5\", \"Website\": \"www.rcdhu.com\"}, \"31\": {\"PHU\": \"North Bay Parry Sound District Health Unit\", \"PHU_ID\": 2247, \"Address\": \"345 Oak Street West\", \"City\": \"North Bay\", \"Postal_Code\": \"P1B 2T2\", \"Website\": \"www.myhealthunit.ca \"}, \"32\": {\"PHU\": \"Algoma Public Health Unit\", \"PHU_ID\": 2226, \"Address\": \"294 Willow Avenue\", \"City\": \"Sault Ste. Marie\", \"Postal_Code\": \"P6B 0A9\", \"Website\": \"www.algomapublichealth.com\"}, \"33\": {\"PHU\": \"Timiskaming Health Unit\", \"PHU_ID\": 2263, \"Address\": \"247 Whitewood Avenue, Unit 43\", \"City\": \"New Liskeard\", \"Postal_Code\": \"P0J 1P0\", \"Website\": \"www.timiskaminghu.com\"}}, \"stats\": {\"0\": {\"PHU\": \"Toronto Public Health\", \"Age_Under_20\": 407.0, \"Age_20s\": 365.0, \"Age_30s\": 419.0, \"Age_40s\": 463.0, \"Age_50s\": 552.0, \"Age_60s\": 328.0, \"Age_70s\": 256.0, \"Age_80s\": 436.0, \"Age_Over_90\": 355.0, \"Female\": 1996.0, \"Male\": 1520.0, \"Unknown\": 65.0, \"Fatal\": 275.0, \"Not_Resolved\": 70.0, \"Resolved\": 3236.0, \"Total_Cases\": 3581.0}, \"1\": {\"PHU\": \"Peel Public Health\", \"Age_Under_20\": 163.0, \"Age_20s\": 443.0, \"Age_30s\": 326.0, \"Age_40s\": 372.0, \"Age_50s\": 329.0, \"Age_60s\": 156.0, \"Age_70s\": 70.0, \"Age_80s\": 116.0, \"Age_Over_90\": 102.0, \"Female\": 1114.0, \"Male\": 961.0, \"Unknown\": 2.0, \"Fatal\": 70.0, \"Not_Resolved\": 62.0, \"Resolved\": 1945.0, \"Total_Cases\": 2077.0}, \"2\": {\"PHU\": \"York Region Public Health Services\", \"Age_Under_20\": 122.0, \"Age_20s\": 90.0, \"Age_30s\": 115.0, \"Age_40s\": 124.0, \"Age_50s\": 165.0, \"Age_60s\": 102.0, \"Age_70s\": 54.0, \"Age_80s\": 98.0, \"Age_Over_90\": 73.0, \"Female\": 494.0, \"Male\": 444.0, \"Unknown\": 5.0, \"Fatal\": 63.0, \"Not_Resolved\": 11.0, \"Resolved\": 869.0, \"Total_Cases\": 943.0}, \"3\": {\"PHU\": \"Ottawa Public Health\", \"Age_Under_20\": 122.0, \"Age_20s\": 103.0, \"Age_30s\": 91.0, \"Age_40s\": 103.0, \"Age_50s\": 95.0, \"Age_60s\": 75.0, \"Age_70s\": 52.0, \"Age_80s\": 95.0, \"Age_Over_90\": 72.0, \"Female\": 462.0, \"Male\": 345.0, \"Unknown\": 1.0, \"Fatal\": 64.0, \"Not_Resolved\": 14.0, \"Resolved\": 730.0, \"Total_Cases\": 808.0}, \"4\": {\"PHU\": \"Niagara Region Public Health Department\", \"Age_Under_20\": 49.0, \"Age_20s\": 108.0, \"Age_30s\": 105.0, \"Age_40s\": 86.0, \"Age_50s\": 89.0, \"Age_60s\": 58.0, \"Age_70s\": 61.0, \"Age_80s\": 94.0, \"Age_Over_90\": 76.0, \"Female\": 469.0, \"Male\": 256.0, \"Unknown\": 1.0, \"Fatal\": 47.0, \"Not_Resolved\": 20.0, \"Resolved\": 659.0, \"Total_Cases\": 726.0}, \"5\": {\"PHU\": \"Windsor-Essex County Health Unit\", \"Age_Under_20\": 26.0, \"Age_20s\": 153.0, \"Age_30s\": 119.0, \"Age_40s\": 110.0, \"Age_50s\": 76.0, \"Age_60s\": 48.0, \"Age_70s\": 48.0, \"Age_80s\": 65.0, \"Age_Over_90\": 55.0, \"Female\": 304.0, \"Male\": 384.0, \"Unknown\": 12.0, \"Fatal\": 50.0, \"Not_Resolved\": 3.0, \"Resolved\": 647.0, \"Total_Cases\": 700.0}, \"6\": {\"PHU\": \"Hamilton Public Health Services\", \"Age_Under_20\": 51.0, \"Age_20s\": 100.0, \"Age_30s\": 86.0, \"Age_40s\": 83.0, \"Age_50s\": 84.0, \"Age_60s\": 66.0, \"Age_70s\": 46.0, \"Age_80s\": 65.0, \"Age_Over_90\": 49.0, \"Female\": 331.0, \"Male\": 297.0, \"Unknown\": 2.0, \"Fatal\": 32.0, \"Not_Resolved\": 30.0, \"Resolved\": 568.0, \"Total_Cases\": 630.0}, \"7\": {\"PHU\": \"Durham Region Health Department\", \"Age_Under_20\": 81.0, \"Age_20s\": 70.0, \"Age_30s\": 80.0, \"Age_40s\": 97.0, \"Age_50s\": 109.0, \"Age_60s\": 45.0, \"Age_70s\": 28.0, \"Age_80s\": 57.0, \"Age_Over_90\": 42.0, \"Female\": 378.0, \"Male\": 231.0, \"Unknown\": 0.0, \"Fatal\": 39.0, \"Not_Resolved\": 22.0, \"Resolved\": 548.0, \"Total_Cases\": 609.0}, \"8\": {\"PHU\": \"Region of Waterloo, Public Health\", \"Age_Under_20\": 44.0, \"Age_20s\": 106.0, \"Age_30s\": 70.0, \"Age_40s\": 78.0, \"Age_50s\": 65.0, \"Age_60s\": 44.0, \"Age_70s\": 29.0, \"Age_80s\": 49.0, \"Age_Over_90\": 31.0, \"Female\": 248.0, \"Male\": 266.0, \"Unknown\": 2.0, \"Fatal\": 30.0, \"Not_Resolved\": 4.0, \"Resolved\": 482.0, \"Total_Cases\": 516.0}, \"9\": {\"PHU\": \"Halton Region Health Department\", \"Age_Under_20\": 43.0, \"Age_20s\": 52.0, \"Age_30s\": 64.0, \"Age_40s\": 77.0, \"Age_50s\": 70.0, \"Age_60s\": 36.0, \"Age_70s\": 24.0, \"Age_80s\": 61.0, \"Age_Over_90\": 45.0, \"Female\": 240.0, \"Male\": 232.0, \"Unknown\": 0.0, \"Fatal\": 24.0, \"Not_Resolved\": 15.0, \"Resolved\": 433.0, \"Total_Cases\": 472.0}, \"10\": {\"PHU\": \"Middlesex-London Health Unit\", \"Age_Under_20\": 100.0, \"Age_20s\": 65.0, \"Age_30s\": 47.0, \"Age_40s\": 50.0, \"Age_50s\": 54.0, \"Age_60s\": 22.0, \"Age_70s\": 18.0, \"Age_80s\": 21.0, \"Age_Over_90\": 12.0, \"Female\": 202.0, \"Male\": 187.0, \"Unknown\": 0.0, \"Fatal\": 17.0, \"Not_Resolved\": 21.0, \"Resolved\": 351.0, \"Total_Cases\": 389.0}, \"11\": {\"PHU\": \"Simcoe Muskoka District Health Unit\", \"Age_Under_20\": 46.0, \"Age_20s\": 73.0, \"Age_30s\": 62.0, \"Age_40s\": 51.0, \"Age_50s\": 52.0, \"Age_60s\": 32.0, \"Age_70s\": 21.0, \"Age_80s\": 30.0, \"Age_Over_90\": 16.0, \"Female\": 211.0, \"Male\": 172.0, \"Unknown\": 0.0, \"Fatal\": 22.0, \"Not_Resolved\": 9.0, \"Resolved\": 352.0, \"Total_Cases\": 383.0}, \"12\": {\"PHU\": \"Wellington-Dufferin-Guelph Public Health\", \"Age_Under_20\": 26.0, \"Age_20s\": 42.0, \"Age_30s\": 61.0, \"Age_40s\": 40.0, \"Age_50s\": 37.0, \"Age_60s\": 19.0, \"Age_70s\": 8.0, \"Age_80s\": 24.0, \"Age_Over_90\": 16.0, \"Female\": 140.0, \"Male\": 123.0, \"Unknown\": 10.0, \"Fatal\": 13.0, \"Not_Resolved\": 4.0, \"Resolved\": 256.0, \"Total_Cases\": 273.0}, \"13\": {\"PHU\": \"Thunder Bay District Health Unit\", \"Age_Under_20\": 15.0, \"Age_20s\": 36.0, \"Age_30s\": 38.0, \"Age_40s\": 29.0, \"Age_50s\": 31.0, \"Age_60s\": 16.0, \"Age_70s\": 8.0, \"Age_80s\": 13.0, \"Age_Over_90\": 7.0, \"Female\": 86.0, \"Male\": 105.0, \"Unknown\": 2.0, \"Fatal\": 11.0, \"Not_Resolved\": 0.0, \"Resolved\": 182.0, \"Total_Cases\": 193.0}, \"14\": {\"PHU\": \"Southwestern Public Health\", \"Age_Under_20\": 6.0, \"Age_20s\": 32.0, \"Age_30s\": 28.0, \"Age_40s\": 23.0, \"Age_50s\": 25.0, \"Age_60s\": 12.0, \"Age_70s\": 14.0, \"Age_80s\": 8.0, \"Age_Over_90\": 7.0, \"Female\": 70.0, \"Male\": 84.0, \"Unknown\": 1.0, \"Fatal\": 8.0, \"Not_Resolved\": 3.0, \"Resolved\": 144.0, \"Total_Cases\": 155.0}, \"15\": {\"PHU\": \"Eastern Ontario Health Unit\", \"Age_Under_20\": 15.0, \"Age_20s\": 8.0, \"Age_30s\": 7.0, \"Age_40s\": 14.0, \"Age_50s\": 18.0, \"Age_60s\": 13.0, \"Age_70s\": 10.0, \"Age_80s\": 19.0, \"Age_Over_90\": 14.0, \"Female\": 78.0, \"Male\": 40.0, \"Unknown\": 0.0, \"Fatal\": 13.0, \"Not_Resolved\": 2.0, \"Resolved\": 103.0, \"Total_Cases\": 118.0}, \"16\": {\"PHU\": \"Haldimand-Norfolk Health Unit\", \"Age_Under_20\": 7.0, \"Age_20s\": 19.0, \"Age_30s\": 20.0, \"Age_40s\": 26.0, \"Age_50s\": 20.0, \"Age_60s\": 5.0, \"Age_70s\": 4.0, \"Age_80s\": 3.0, \"Age_Over_90\": 7.0, \"Female\": 44.0, \"Male\": 66.0, \"Unknown\": 1.0, \"Fatal\": 1.0, \"Not_Resolved\": 2.0, \"Resolved\": 108.0, \"Total_Cases\": 111.0}, \"17\": {\"PHU\": \"Lambton Public Health\", \"Age_Under_20\": 14.0, \"Age_20s\": 9.0, \"Age_30s\": 10.0, \"Age_40s\": 14.0, \"Age_50s\": 13.0, \"Age_60s\": 7.0, \"Age_70s\": 6.0, \"Age_80s\": 12.0, \"Age_Over_90\": 11.0, \"Female\": 52.0, \"Male\": 44.0, \"Unknown\": 0.0, \"Fatal\": 5.0, \"Not_Resolved\": 4.0, \"Resolved\": 87.0, \"Total_Cases\": 96.0}, \"18\": {\"PHU\": \"Leeds, Grenville and Lanark District Health Unit\", \"Age_Under_20\": 8.0, \"Age_20s\": 8.0, \"Age_30s\": 5.0, \"Age_40s\": 10.0, \"Age_50s\": 13.0, \"Age_60s\": 15.0, \"Age_70s\": 15.0, \"Age_80s\": 9.0, \"Age_Over_90\": 12.0, \"Female\": 55.0, \"Male\": 40.0, \"Unknown\": 0.0, \"Fatal\": 6.0, \"Not_Resolved\": 0.0, \"Resolved\": 89.0, \"Total_Cases\": 95.0}, \"19\": {\"PHU\": \"Sudbury & District Health Unit\", \"Age_Under_20\": 18.0, \"Age_20s\": 14.0, \"Age_30s\": 10.0, \"Age_40s\": 15.0, \"Age_50s\": 8.0, \"Age_60s\": 9.0, \"Age_70s\": 3.0, \"Age_80s\": 4.0, \"Age_Over_90\": 6.0, \"Female\": 45.0, \"Male\": 41.0, \"Unknown\": 1.0, \"Fatal\": 3.0, \"Not_Resolved\": 1.0, \"Resolved\": 83.0, \"Total_Cases\": 87.0}, \"20\": {\"PHU\": \"Brant County Health Unit\", \"Age_Under_20\": 15.0, \"Age_20s\": 13.0, \"Age_30s\": 13.0, \"Age_40s\": 12.0, \"Age_50s\": 8.0, \"Age_60s\": 6.0, \"Age_70s\": 2.0, \"Age_80s\": 2.0, \"Age_Over_90\": 0.0, \"Female\": 33.0, \"Male\": 38.0, \"Unknown\": 0.0, \"Fatal\": 2.0, \"Not_Resolved\": 0.0, \"Resolved\": 69.0, \"Total_Cases\": 71.0}, \"21\": {\"PHU\": \"Huron Perth District Health Unit\", \"Age_Under_20\": 1.0, \"Age_20s\": 10.0, \"Age_30s\": 10.0, \"Age_40s\": 7.0, \"Age_50s\": 6.0, \"Age_60s\": 3.0, \"Age_70s\": 4.0, \"Age_80s\": 17.0, \"Age_Over_90\": 12.0, \"Female\": 45.0, \"Male\": 25.0, \"Unknown\": 0.0, \"Fatal\": 8.0, \"Not_Resolved\": 1.0, \"Resolved\": 61.0, \"Total_Cases\": 70.0}, \"22\": {\"PHU\": \"Haliburton, Kawartha, Pine Ridge District Health Unit\", \"Age_Under_20\": 7.0, \"Age_20s\": 9.0, \"Age_30s\": 6.0, \"Age_40s\": 9.0, \"Age_50s\": 12.0, \"Age_60s\": 5.0, \"Age_70s\": 5.0, \"Age_80s\": 7.0, \"Age_Over_90\": 7.0, \"Female\": 42.0, \"Male\": 25.0, \"Unknown\": 0.0, \"Fatal\": 4.0, \"Not_Resolved\": 4.0, \"Resolved\": 59.0, \"Total_Cases\": 67.0}, \"23\": {\"PHU\": \"Northwestern Health Unit\", \"Age_Under_20\": 11.0, \"Age_20s\": 4.0, \"Age_30s\": 11.0, \"Age_40s\": 6.0, \"Age_50s\": 7.0, \"Age_60s\": 6.0, \"Age_70s\": 3.0, \"Age_80s\": 2.0, \"Age_Over_90\": 2.0, \"Female\": 23.0, \"Male\": 27.0, \"Unknown\": 2.0, \"Fatal\": 1.0, \"Not_Resolved\": 0.0, \"Resolved\": 51.0, \"Total_Cases\": 52.0}, \"24\": {\"PHU\": \"Chatham-Kent Health Unit\", \"Age_Under_20\": 6.0, \"Age_20s\": 5.0, \"Age_30s\": 12.0, \"Age_40s\": 11.0, \"Age_50s\": 5.0, \"Age_60s\": 4.0, \"Age_70s\": 2.0, \"Age_80s\": 2.0, \"Age_Over_90\": 2.0, \"Female\": 28.0, \"Male\": 21.0, \"Unknown\": 0.0, \"Fatal\": 1.0, \"Not_Resolved\": 1.0, \"Resolved\": 47.0, \"Total_Cases\": 49.0}, \"25\": {\"PHU\": \"Kingston, Frontenac and Lennox & Addington Public Health\", \"Age_Under_20\": 12.0, \"Age_20s\": 7.0, \"Age_30s\": 7.0, \"Age_40s\": 3.0, \"Age_50s\": 8.0, \"Age_60s\": 8.0, \"Age_70s\": 0.0, \"Age_80s\": 0.0, \"Age_Over_90\": 2.0, \"Female\": 24.0, \"Male\": 23.0, \"Unknown\": 0.0, \"Fatal\": 0.0, \"Not_Resolved\": 3.0, \"Resolved\": 44.0, \"Total_Cases\": 47.0}, \"26\": {\"PHU\": \"Hastings and Prince Edward Counties Health Unit\", \"Age_Under_20\": 8.0, \"Age_20s\": 8.0, \"Age_30s\": 3.0, \"Age_40s\": 4.0, \"Age_50s\": 8.0, \"Age_60s\": 1.0, \"Age_70s\": 4.0, \"Age_80s\": 1.0, \"Age_Over_90\": 0.0, \"Female\": 15.0, \"Male\": 22.0, \"Unknown\": 0.0, \"Fatal\": 1.0, \"Not_Resolved\": 0.0, \"Resolved\": 36.0, \"Total_Cases\": 37.0}, \"27\": {\"PHU\": \"Peterborough Public Health\", \"Age_Under_20\": 6.0, \"Age_20s\": 10.0, \"Age_30s\": 2.0, \"Age_40s\": 6.0, \"Age_50s\": 4.0, \"Age_60s\": 2.0, \"Age_70s\": 2.0, \"Age_80s\": 3.0, \"Age_Over_90\": 1.0, \"Female\": 21.0, \"Male\": 14.0, \"Unknown\": 1.0, \"Fatal\": 0.0, \"Not_Resolved\": 3.0, \"Resolved\": 33.0, \"Total_Cases\": 36.0}, \"28\": {\"PHU\": \"Porcupine Health Unit\", \"Age_Under_20\": 5.0, \"Age_20s\": 5.0, \"Age_30s\": 6.0, \"Age_40s\": 2.0, \"Age_50s\": 5.0, \"Age_60s\": 4.0, \"Age_70s\": 0.0, \"Age_80s\": 3.0, \"Age_Over_90\": 2.0, \"Female\": 18.0, \"Male\": 13.0, \"Unknown\": 1.0, \"Fatal\": 0.0, \"Not_Resolved\": 2.0, \"Resolved\": 30.0, \"Total_Cases\": 32.0}, \"29\": {\"PHU\": \"Grey Bruce Health Unit\", \"Age_Under_20\": 10.0, \"Age_20s\": 1.0, \"Age_30s\": 1.0, \"Age_40s\": 6.0, \"Age_50s\": 6.0, \"Age_60s\": 2.0, \"Age_70s\": 1.0, \"Age_80s\": 3.0, \"Age_Over_90\": 1.0, \"Female\": 19.0, \"Male\": 12.0, \"Unknown\": 0.0, \"Fatal\": 0.0, \"Not_Resolved\": 0.0, \"Resolved\": 31.0, \"Total_Cases\": 31.0}, \"30\": {\"PHU\": \"Renfrew County and District Health Unit\", \"Age_Under_20\": 9.0, \"Age_20s\": 2.0, \"Age_30s\": 5.0, \"Age_40s\": 5.0, \"Age_50s\": 3.0, \"Age_60s\": 1.0, \"Age_70s\": 1.0, \"Age_80s\": 1.0, \"Age_Over_90\": 1.0, \"Female\": 13.0, \"Male\": 14.0, \"Unknown\": 1.0, \"Fatal\": 0.0, \"Not_Resolved\": 1.0, \"Resolved\": 27.0, \"Total_Cases\": 28.0}, \"31\": {\"PHU\": \"North Bay Parry Sound District Health Unit\", \"Age_Under_20\": 3.0, \"Age_20s\": 6.0, \"Age_30s\": 2.0, \"Age_40s\": 3.0, \"Age_50s\": 2.0, \"Age_60s\": 3.0, \"Age_70s\": 1.0, \"Age_80s\": 0.0, \"Age_Over_90\": 0.0, \"Female\": 11.0, \"Male\": 9.0, \"Unknown\": 0.0, \"Fatal\": 0.0, \"Not_Resolved\": 3.0, \"Resolved\": 17.0, \"Total_Cases\": 20.0}, \"32\": {\"PHU\": \"Algoma Public Health Unit\", \"Age_Under_20\": 1.0, \"Age_20s\": 5.0, \"Age_30s\": 3.0, \"Age_40s\": 2.0, \"Age_50s\": 0.0, \"Age_60s\": 1.0, \"Age_70s\": 0.0, \"Age_80s\": 0.0, \"Age_Over_90\": 0.0, \"Female\": 4.0, \"Male\": 8.0, \"Unknown\": 0.0, \"Fatal\": 0.0, \"Not_Resolved\": 0.0, \"Resolved\": 12.0, \"Total_Cases\": 12.0}, \"33\": {\"PHU\": \"Timiskaming Health Unit\", \"Age_Under_20\": 1.0, \"Age_20s\": 2.0, \"Age_30s\": 2.0, \"Age_40s\": 2.0, \"Age_50s\": 2.0, \"Age_60s\": 0.0, \"Age_70s\": 0.0, \"Age_80s\": 1.0, \"Age_Over_90\": 0.0, \"Female\": 6.0, \"Male\": 4.0, \"Unknown\": 0.0, \"Fatal\": 1.0, \"Not_Resolved\": 0.0, \"Resolved\": 9.0, \"Total_Cases\": 10.0}}}'"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# importing dependancies\n",
    "import json\n",
    "# combining all dicts and converting in JSON string format\n",
    "temp = json.dumps({'name':name,'info':info,'stats':stats})\n",
    "temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# saving file\n",
    "with open('covid.json', 'w')as out:\n",
    "    json.dump({'name':name,'info':info,'stats':stats}, out)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}