3-9_ASEAN5_GoogleMobilityData.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "114aaf0d-2e4a-481c-b09c-52bf444f1284",
   "metadata": {},
   "source": [
    "# INTRODUCTION #\n",
    "\n",
    "Appending and Merging datasets exercise:\n",
    "Google Mobility Index Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ae3b094f-726d-4c5a-9e1e-0380924de79f",
   "metadata": {},
   "outputs": [],
   "source": [
    "#PACKAGES / PYTHON MODULES\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import openpyxl\n",
    "import os\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "37669019-e426-4e72-b917-3db4d11f67fa",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "New working directory is:  /Users/dino/Documents/Google_Mobility_Data/Region_Mobility_Report_CSVs\n"
     ]
    }
   ],
   "source": [
    "#SET WORKING DIRECTORY\n",
    "absolute_path = '/Users/dino/Documents/Google_Mobility_Data/Region_Mobility_Report_CSVs'\n",
    "\n",
    "os.chdir(absolute_path)\n",
    "\n",
    "print('New working directory is: ', os.getcwd())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "4be2b7fe-285c-4fcc-b62e-ff41474deeb8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Current Working Directory is:  /Users/dino/Documents/Google_Mobility_Data/Region_Mobility_Report_CSVs\n"
     ]
    }
   ],
   "source": [
    "#GET WORKING DIRECTORY\n",
    "cwd = os.getcwd()\n",
    "print('Current Working Directory is: ', cwd)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3e2194f7-dd85-4c42-bc39-4834a5b1cac0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(6475, 15)\n",
      "(3145, 15)\n",
      "(4810, 15)\n",
      "(185, 15)\n",
      "(185, 15)\n"
     ]
    }
   ],
   "source": [
    "#csv files: 2022 Google Mobility Data\n",
    "ID_2022 = pd.read_csv('2022_ID_Region_Mobility_Report.csv')\n",
    "MY_2022 = pd.read_csv('2022_MY_Region_Mobility_Report.csv')\n",
    "PH_2022 = pd.read_csv('2022_PH_Region_Mobility_Report.csv')\n",
    "SG_2022 = pd.read_csv('2022_SG_Region_Mobility_Report.csv')\n",
    "TH_2022 = pd.read_csv('2022_TH_Region_Mobility_Report.csv')\n",
    "\n",
    "#Display dataset shape\n",
    "print(ID_2022.shape)\n",
    "print(MY_2022.shape)\n",
    "print(PH_2022.shape)\n",
    "print(SG_2022.shape)\n",
    "print(TH_2022.shape)\n",
    "\n",
    "#View whole dataframe\n",
    "#print(usdphp_1, psei_1)\n",
    "\n",
    "#print(psei_1.to_string())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7f097332-ff34-449f-8893-263463b0fd8e",
   "metadata": {},
   "outputs": [],
   "source": [
    "ID_2022.rename(columns={'retail_and_recreation_percent_change_from_baseline': 'ID_retail_recreation', \\\n",
    "                          'grocery_and_pharmacy_percent_change_from_baseline':'ID_grocery_pharmacy', \\\n",
    "                                'parks_percent_change_from_baseline':'ID_parks',\\\n",
    "                         'transit_stations_percent_change_from_baseline':'ID_transit_stations',\\\n",
    "                         'workplaces_percent_change_from_baseline':'ID_workplaces',\\\n",
    "                         'residential_percent_change_from_baseline':'ID_residential'},inplace=True)\n",
    "\n",
    "MY_2022.rename(columns={'retail_and_recreation_percent_change_from_baseline': 'MY_retail_recreation', \\\n",
    "                          'grocery_and_pharmacy_percent_change_from_baseline':'MY_grocery_pharmacy', \\\n",
    "                                'parks_percent_change_from_baseline':'MY_parks',\\\n",
    "                         'transit_stations_percent_change_from_baseline':'MY_transit_stations',\\\n",
    "                         'workplaces_percent_change_from_baseline':'MY_workplaces',\\\n",
    "                         'residential_percent_change_from_baseline':'MY_residential'},inplace=True)\n",
    "\n",
    "PH_2022.rename(columns={'retail_and_recreation_percent_change_from_baseline': 'PH_retail_recreation', \\\n",
    "                          'grocery_and_pharmacy_percent_change_from_baseline':'PH_grocery_pharmacy', \\\n",
    "                                'parks_percent_change_from_baseline':'PH_parks',\\\n",
    "                         'transit_stations_percent_change_from_baseline':'PH_transit_stations',\\\n",
    "                         'workplaces_percent_change_from_baseline':'PH_workplaces',\\\n",
    "                         'residential_percent_change_from_baseline':'PH_residential'},inplace=True)\n",
    "\n",
    "SG_2022.rename(columns={'retail_and_recreation_percent_change_from_baseline': 'SG_retail_recreation', \\\n",
    "                          'grocery_and_pharmacy_percent_change_from_baseline':'SG_grocery_pharmacy', \\\n",
    "                                'parks_percent_change_from_baseline':'SG_parks',\\\n",
    "                         'transit_stations_percent_change_from_baseline':'SG_transit_stations',\\\n",
    "                         'workplaces_percent_change_from_baseline':'SG_workplaces',\\\n",
    "                         'residential_percent_change_from_baseline':'SG_residential'},inplace=True)\n",
    "\n",
    "TH_2022.rename(columns={'retail_and_recreation_percent_change_from_baseline': 'TH_retail_recreation', \\\n",
    "                          'grocery_and_pharmacy_percent_change_from_baseline':'TH_grocery_pharmacy', \\\n",
    "                                'parks_percent_change_from_baseline':'TH_parks',\\\n",
    "                         'transit_stations_percent_change_from_baseline':'TH_transit_stations',\\\n",
    "                         'workplaces_percent_change_from_baseline':'TH_workplaces',\\\n",
    "                         'residential_percent_change_from_baseline':'TH_residential'},inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "af8a9150-d55a-4b4c-a5ff-77e6421e2c6a",
   "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>date</th>\n",
       "      <th>TH_retail_recreation</th>\n",
       "      <th>TH_grocery_pharmacy</th>\n",
       "      <th>TH_parks</th>\n",
       "      <th>TH_transit_stations</th>\n",
       "      <th>TH_workplaces</th>\n",
       "      <th>TH_residential</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>-3</td>\n",
       "      <td>20</td>\n",
       "      <td>23</td>\n",
       "      <td>-36</td>\n",
       "      <td>-51</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>3</td>\n",
       "      <td>21</td>\n",
       "      <td>18</td>\n",
       "      <td>-30</td>\n",
       "      <td>-26</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>-38</td>\n",
       "      <td>-54</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>-17</td>\n",
       "      <td>-34</td>\n",
       "      <td>-18</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>-20</td>\n",
       "      <td>-33</td>\n",
       "      <td>-14</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>2022-06-30</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>-11</td>\n",
       "      <td>-20</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>-1</td>\n",
       "      <td>26</td>\n",
       "      <td>-12</td>\n",
       "      <td>-21</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>2022-07-02</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "      <td>-16</td>\n",
       "      <td>-16</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>2022-07-03</td>\n",
       "      <td>4</td>\n",
       "      <td>27</td>\n",
       "      <td>-5</td>\n",
       "      <td>-14</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>2022-07-04</td>\n",
       "      <td>-1</td>\n",
       "      <td>23</td>\n",
       "      <td>-9</td>\n",
       "      <td>-22</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>185 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  TH_retail_recreation  TH_grocery_pharmacy  TH_parks  \\\n",
       "0    2022-01-01                    -3                   20        23   \n",
       "1    2022-01-02                     3                   21        18   \n",
       "2    2022-01-03                     9                   25         5   \n",
       "3    2022-01-04                     3                   24       -17   \n",
       "4    2022-01-05                     1                   20       -20   \n",
       "..          ...                   ...                  ...       ...   \n",
       "180  2022-06-30                     1                   24       -11   \n",
       "181  2022-07-01                    -1                   26       -12   \n",
       "182  2022-07-02                     2                   26       -16   \n",
       "183  2022-07-03                     4                   27        -5   \n",
       "184  2022-07-04                    -1                   23        -9   \n",
       "\n",
       "     TH_transit_stations  TH_workplaces  TH_residential  \n",
       "0                    -36            -51               0  \n",
       "1                    -30            -26              -3  \n",
       "2                    -38            -54               5  \n",
       "3                    -34            -18               2  \n",
       "4                    -33            -14               3  \n",
       "..                   ...            ...             ...  \n",
       "180                  -20              2               7  \n",
       "181                  -21              1               7  \n",
       "182                  -16              7               6  \n",
       "183                  -14              3               6  \n",
       "184                  -22              1               7  \n",
       "\n",
       "[185 rows x 7 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "TH_2022_b = TH_2022 \n",
    "\n",
    "TH_2022_b = TH_2022.dropna(axis=1)\n",
    "\n",
    "columns_to_drop = ['country_region_code','country_region','place_id']\n",
    "TH_2022_b = TH_2022_b.drop(columns_to_drop, axis=1, inplace=False)\n",
    "\n",
    "TH_2022_b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "e4603402-f0fb-4f6f-aeae-9c53af8f1793",
   "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>date</th>\n",
       "      <th>SG_retail_recreation</th>\n",
       "      <th>SG_grocery_pharmacy</th>\n",
       "      <th>SG_parks</th>\n",
       "      <th>SG_transit_stations</th>\n",
       "      <th>SG_workplaces</th>\n",
       "      <th>SG_residential</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>-10</td>\n",
       "      <td>13</td>\n",
       "      <td>-7</td>\n",
       "      <td>-25</td>\n",
       "      <td>-33</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>-12</td>\n",
       "      <td>1</td>\n",
       "      <td>-39</td>\n",
       "      <td>-26</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>-4</td>\n",
       "      <td>18</td>\n",
       "      <td>-4</td>\n",
       "      <td>-26</td>\n",
       "      <td>-30</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>-11</td>\n",
       "      <td>9</td>\n",
       "      <td>-9</td>\n",
       "      <td>-23</td>\n",
       "      <td>-21</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>-13</td>\n",
       "      <td>2</td>\n",
       "      <td>-9</td>\n",
       "      <td>-21</td>\n",
       "      <td>-19</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>2022-06-30</td>\n",
       "      <td>-11</td>\n",
       "      <td>-4</td>\n",
       "      <td>-17</td>\n",
       "      <td>-11</td>\n",
       "      <td>-7</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>-8</td>\n",
       "      <td>-3</td>\n",
       "      <td>-14</td>\n",
       "      <td>-12</td>\n",
       "      <td>-6</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>2022-07-02</td>\n",
       "      <td>-4</td>\n",
       "      <td>3</td>\n",
       "      <td>-8</td>\n",
       "      <td>-10</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>2022-07-03</td>\n",
       "      <td>-5</td>\n",
       "      <td>-2</td>\n",
       "      <td>-4</td>\n",
       "      <td>-13</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>2022-07-04</td>\n",
       "      <td>-8</td>\n",
       "      <td>-2</td>\n",
       "      <td>-14</td>\n",
       "      <td>-18</td>\n",
       "      <td>-16</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>185 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  SG_retail_recreation  SG_grocery_pharmacy  SG_parks  \\\n",
       "0    2022-01-01                   -10                   13        -7   \n",
       "1    2022-01-02                   -12                    1       -39   \n",
       "2    2022-01-03                    -4                   18        -4   \n",
       "3    2022-01-04                   -11                    9        -9   \n",
       "4    2022-01-05                   -13                    2        -9   \n",
       "..          ...                   ...                  ...       ...   \n",
       "180  2022-06-30                   -11                   -4       -17   \n",
       "181  2022-07-01                    -8                   -3       -14   \n",
       "182  2022-07-02                    -4                    3        -8   \n",
       "183  2022-07-03                    -5                   -2        -4   \n",
       "184  2022-07-04                    -8                   -2       -14   \n",
       "\n",
       "     SG_transit_stations  SG_workplaces  SG_residential  \n",
       "0                    -25            -33              14  \n",
       "1                    -26              9              11  \n",
       "2                    -26            -30              17  \n",
       "3                    -23            -21              15  \n",
       "4                    -21            -19              15  \n",
       "..                   ...            ...             ...  \n",
       "180                  -11             -7              10  \n",
       "181                  -12             -6              12  \n",
       "182                  -10              3               6  \n",
       "183                  -13              2               6  \n",
       "184                  -18            -16              12  \n",
       "\n",
       "[185 rows x 7 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "SG_2022_b = SG_2022 \n",
    "\n",
    "SG_2022_b = SG_2022.dropna(axis=1)\n",
    "\n",
    "columns_to_drop = ['country_region_code','country_region','place_id']\n",
    "SG_2022_b = SG_2022_b.drop(columns_to_drop, axis=1, inplace=False)\n",
    "\n",
    "SG_2022_b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "618a9695-0e4a-4dc3-9847-c9ea990be896",
   "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>date</th>\n",
       "      <th>PH_retail_recreation</th>\n",
       "      <th>PH_grocery_pharmacy</th>\n",
       "      <th>PH_parks</th>\n",
       "      <th>PH_transit_stations</th>\n",
       "      <th>PH_workplaces</th>\n",
       "      <th>PH_residential</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>-39</td>\n",
       "      <td>-15.0</td>\n",
       "      <td>27</td>\n",
       "      <td>-48</td>\n",
       "      <td>-52</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>-4</td>\n",
       "      <td>38.0</td>\n",
       "      <td>28</td>\n",
       "      <td>-9</td>\n",
       "      <td>-1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>-4</td>\n",
       "      <td>41.0</td>\n",
       "      <td>17</td>\n",
       "      <td>-24</td>\n",
       "      <td>-22</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>-7</td>\n",
       "      <td>43.0</td>\n",
       "      <td>10</td>\n",
       "      <td>-28</td>\n",
       "      <td>-24</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>-10</td>\n",
       "      <td>41.0</td>\n",
       "      <td>8</td>\n",
       "      <td>-33</td>\n",
       "      <td>-24</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>2022-06-30</td>\n",
       "      <td>18</td>\n",
       "      <td>65.0</td>\n",
       "      <td>54</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>13</td>\n",
       "      <td>59.0</td>\n",
       "      <td>41</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>2022-07-02</td>\n",
       "      <td>17</td>\n",
       "      <td>63.0</td>\n",
       "      <td>46</td>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>2022-07-03</td>\n",
       "      <td>16</td>\n",
       "      <td>62.0</td>\n",
       "      <td>53</td>\n",
       "      <td>22</td>\n",
       "      <td>33</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>2022-07-04</td>\n",
       "      <td>15</td>\n",
       "      <td>54.0</td>\n",
       "      <td>53</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>185 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  PH_retail_recreation  PH_grocery_pharmacy  PH_parks  \\\n",
       "0    2022-01-01                   -39                -15.0        27   \n",
       "1    2022-01-02                    -4                 38.0        28   \n",
       "2    2022-01-03                    -4                 41.0        17   \n",
       "3    2022-01-04                    -7                 43.0        10   \n",
       "4    2022-01-05                   -10                 41.0         8   \n",
       "..          ...                   ...                  ...       ...   \n",
       "180  2022-06-30                    18                 65.0        54   \n",
       "181  2022-07-01                    13                 59.0        41   \n",
       "182  2022-07-02                    17                 63.0        46   \n",
       "183  2022-07-03                    16                 62.0        53   \n",
       "184  2022-07-04                    15                 54.0        53   \n",
       "\n",
       "     PH_transit_stations  PH_workplaces  PH_residential  \n",
       "0                    -48            -52              17  \n",
       "1                     -9             -1               9  \n",
       "2                    -24            -22              18  \n",
       "3                    -28            -24              20  \n",
       "4                    -33            -24              20  \n",
       "..                   ...            ...             ...  \n",
       "180                    5              1              18  \n",
       "181                    4              6              19  \n",
       "182                   14             23              14  \n",
       "183                   22             33              12  \n",
       "184                   10              4              18  \n",
       "\n",
       "[185 rows x 7 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "PH_2022_b = PH_2022 \n",
    "\n",
    "PH_2022_b = PH_2022_b.loc[(PH_2022_b.sub_region_1.isnull()) & (PH_2022_b.metro_area.isnull())]\n",
    "PH_2022_b = PH_2022_b.dropna(axis=1)\n",
    "\n",
    "columns_to_drop = ['country_region_code','country_region','place_id']\n",
    "PH_2022_b = PH_2022_b.drop(columns_to_drop, axis=1, inplace=False)\n",
    "\n",
    "#PH_2022_b['sub_region_1'].value_counts().dtype\n",
    "\n",
    "PH_2022_b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "33cc9dcf-ba49-4b54-8187-34c52c8153b9",
   "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>date</th>\n",
       "      <th>MY_retail_recreation</th>\n",
       "      <th>MY_grocery_pharmacy</th>\n",
       "      <th>MY_parks</th>\n",
       "      <th>MY_transit_stations</th>\n",
       "      <th>MY_workplaces</th>\n",
       "      <th>MY_residential</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>-11</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>-16</td>\n",
       "      <td>-36</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>-11</td>\n",
       "      <td>13.0</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>-18</td>\n",
       "      <td>-14</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>-6</td>\n",
       "      <td>25.0</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>-25</td>\n",
       "      <td>-16</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>-8</td>\n",
       "      <td>22.0</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-28</td>\n",
       "      <td>-13</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>-7</td>\n",
       "      <td>24.0</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>-26</td>\n",
       "      <td>-12</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>2022-06-30</td>\n",
       "      <td>2</td>\n",
       "      <td>24.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>-14</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>3</td>\n",
       "      <td>23.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>-12</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>2022-07-02</td>\n",
       "      <td>4</td>\n",
       "      <td>21.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>-2</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>2022-07-03</td>\n",
       "      <td>4</td>\n",
       "      <td>21.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>-2</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>2022-07-04</td>\n",
       "      <td>-3</td>\n",
       "      <td>21.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-15</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>185 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  MY_retail_recreation  MY_grocery_pharmacy  MY_parks  \\\n",
       "0    2022-01-01                   -11                 14.0       8.0   \n",
       "1    2022-01-02                   -11                 13.0      -3.0   \n",
       "2    2022-01-03                    -6                 25.0      -5.0   \n",
       "3    2022-01-04                    -8                 22.0      -9.0   \n",
       "4    2022-01-05                    -7                 24.0      -6.0   \n",
       "..          ...                   ...                  ...       ...   \n",
       "180  2022-06-30                     2                 24.0      21.0   \n",
       "181  2022-07-01                     3                 23.0      25.0   \n",
       "182  2022-07-02                     4                 21.0      30.0   \n",
       "183  2022-07-03                     4                 21.0      33.0   \n",
       "184  2022-07-04                    -3                 21.0      17.0   \n",
       "\n",
       "     MY_transit_stations  MY_workplaces  MY_residential  \n",
       "0                    -16            -36              11  \n",
       "1                    -18            -14               8  \n",
       "2                    -25            -16              11  \n",
       "3                    -28            -13              10  \n",
       "4                    -26            -12              11  \n",
       "..                   ...            ...             ...  \n",
       "180                  -14              2              10  \n",
       "181                  -12              4              10  \n",
       "182                   -2              1               8  \n",
       "183                   -2              1               8  \n",
       "184                  -15              0              11  \n",
       "\n",
       "[185 rows x 7 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "MY_2022_b = MY_2022 \n",
    "\n",
    "MY_2022_b = MY_2022_b.loc[(MY_2022_b.sub_region_1.isnull()) & (MY_2022_b.iso_3166_2_code.isnull())]\n",
    "MY_2022_b = MY_2022_b.dropna(axis=1)\n",
    "\n",
    "columns_to_drop = ['country_region_code','country_region','place_id']\n",
    "MY_2022_b = MY_2022_b.drop(columns_to_drop, axis=1, inplace=False)\n",
    "\n",
    "MY_2022_b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "18b2bc37-a092-4b96-903f-159596d42fe1",
   "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>date</th>\n",
       "      <th>ID_retail_recreation</th>\n",
       "      <th>ID_grocery_pharmacy</th>\n",
       "      <th>ID_parks</th>\n",
       "      <th>ID_transit_stations</th>\n",
       "      <th>ID_workplaces</th>\n",
       "      <th>ID_residential</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>46</td>\n",
       "      <td>-15.0</td>\n",
       "      <td>-49</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>11</td>\n",
       "      <td>35</td>\n",
       "      <td>28</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>-4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>14</td>\n",
       "      <td>36</td>\n",
       "      <td>20</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>11</td>\n",
       "      <td>33</td>\n",
       "      <td>15</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-8</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>12</td>\n",
       "      <td>34</td>\n",
       "      <td>17</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>-7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>2022-06-30</td>\n",
       "      <td>18</td>\n",
       "      <td>39</td>\n",
       "      <td>60</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>17</td>\n",
       "      <td>40</td>\n",
       "      <td>54</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>2022-07-02</td>\n",
       "      <td>16</td>\n",
       "      <td>41</td>\n",
       "      <td>50</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>2022-07-03</td>\n",
       "      <td>17</td>\n",
       "      <td>39</td>\n",
       "      <td>51</td>\n",
       "      <td>7.0</td>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>2022-07-04</td>\n",
       "      <td>19</td>\n",
       "      <td>39</td>\n",
       "      <td>67</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>185 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           date  ID_retail_recreation  ID_grocery_pharmacy  ID_parks  \\\n",
       "0    2022-01-01                     3                   24        46   \n",
       "1    2022-01-02                    11                   35        28   \n",
       "2    2022-01-03                    14                   36        20   \n",
       "3    2022-01-04                    11                   33        15   \n",
       "4    2022-01-05                    12                   34        17   \n",
       "..          ...                   ...                  ...       ...   \n",
       "180  2022-06-30                    18                   39        60   \n",
       "181  2022-07-01                    17                   40        54   \n",
       "182  2022-07-02                    16                   41        50   \n",
       "183  2022-07-03                    17                   39        51   \n",
       "184  2022-07-04                    19                   39        67   \n",
       "\n",
       "     ID_transit_stations  ID_workplaces  ID_residential  \n",
       "0                  -15.0            -49               6  \n",
       "1                   -4.0             -4               3  \n",
       "2                   -9.0            -10               4  \n",
       "3                   -9.0             -8               4  \n",
       "4                  -10.0             -7               4  \n",
       "..                   ...            ...             ...  \n",
       "180                 -1.0              1              15  \n",
       "181                 -1.0              2              15  \n",
       "182                  6.0             11              12  \n",
       "183                  7.0             24              12  \n",
       "184                  0.0             -1              15  \n",
       "\n",
       "[185 rows x 7 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ID_2022_b = ID_2022 \n",
    "\n",
    "ID_2022_b = ID_2022_b.loc[(ID_2022_b.sub_region_1.isnull()) & (ID_2022_b.iso_3166_2_code.isnull())]\n",
    "ID_2022_b = ID_2022_b.dropna(axis=1)\n",
    "\n",
    "columns_to_drop = ['country_region_code','country_region','place_id']\n",
    "ID_2022_b = ID_2022_b.drop(columns_to_drop, axis=1, inplace=False)\n",
    "\n",
    "ID_2022_b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "522cfc74-bdfd-4db6-bc35-6527a672d3ad",
   "metadata": {},
   "outputs": [],
   "source": [
    "ID_2022_b = ID_2022_b.set_index('date')\n",
    "MY_2022_b = MY_2022_b.set_index('date')\n",
    "PH_2022_b = PH_2022_b.set_index('date')\n",
    "SG_2022_b = SG_2022_b.set_index('date')\n",
    "TH_2022_b = TH_2022_b.set_index('date')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "af01730b-3fc0-492e-b443-13bd940082c5",
   "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>ID_retail_recreation</th>\n",
       "      <th>ID_grocery_pharmacy</th>\n",
       "      <th>ID_parks</th>\n",
       "      <th>ID_transit_stations</th>\n",
       "      <th>ID_workplaces</th>\n",
       "      <th>ID_residential</th>\n",
       "      <th>MY_retail_recreation</th>\n",
       "      <th>MY_grocery_pharmacy</th>\n",
       "      <th>MY_parks</th>\n",
       "      <th>MY_transit_stations</th>\n",
       "      <th>...</th>\n",
       "      <th>SG_parks</th>\n",
       "      <th>SG_transit_stations</th>\n",
       "      <th>SG_workplaces</th>\n",
       "      <th>SG_residential</th>\n",
       "      <th>TH_retail_recreation</th>\n",
       "      <th>TH_grocery_pharmacy</th>\n",
       "      <th>TH_parks</th>\n",
       "      <th>TH_transit_stations</th>\n",
       "      <th>TH_workplaces</th>\n",
       "      <th>TH_residential</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-01-01</th>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>46</td>\n",
       "      <td>-15.0</td>\n",
       "      <td>-49</td>\n",
       "      <td>6</td>\n",
       "      <td>-11</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>-16</td>\n",
       "      <td>...</td>\n",
       "      <td>-7</td>\n",
       "      <td>-25</td>\n",
       "      <td>-33</td>\n",
       "      <td>14</td>\n",
       "      <td>-3</td>\n",
       "      <td>20</td>\n",
       "      <td>23</td>\n",
       "      <td>-36</td>\n",
       "      <td>-51</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-02</th>\n",
       "      <td>11</td>\n",
       "      <td>35</td>\n",
       "      <td>28</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>-4</td>\n",
       "      <td>3</td>\n",
       "      <td>-11</td>\n",
       "      <td>13.0</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>-18</td>\n",
       "      <td>...</td>\n",
       "      <td>-39</td>\n",
       "      <td>-26</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>21</td>\n",
       "      <td>18</td>\n",
       "      <td>-30</td>\n",
       "      <td>-26</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-03</th>\n",
       "      <td>14</td>\n",
       "      <td>36</td>\n",
       "      <td>20</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-10</td>\n",
       "      <td>4</td>\n",
       "      <td>-6</td>\n",
       "      <td>25.0</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>-25</td>\n",
       "      <td>...</td>\n",
       "      <td>-4</td>\n",
       "      <td>-26</td>\n",
       "      <td>-30</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>-38</td>\n",
       "      <td>-54</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-04</th>\n",
       "      <td>11</td>\n",
       "      <td>33</td>\n",
       "      <td>15</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-8</td>\n",
       "      <td>4</td>\n",
       "      <td>-8</td>\n",
       "      <td>22.0</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-28</td>\n",
       "      <td>...</td>\n",
       "      <td>-9</td>\n",
       "      <td>-23</td>\n",
       "      <td>-21</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>-17</td>\n",
       "      <td>-34</td>\n",
       "      <td>-18</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-05</th>\n",
       "      <td>12</td>\n",
       "      <td>34</td>\n",
       "      <td>17</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>-7</td>\n",
       "      <td>4</td>\n",
       "      <td>-7</td>\n",
       "      <td>24.0</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>-26</td>\n",
       "      <td>...</td>\n",
       "      <td>-9</td>\n",
       "      <td>-21</td>\n",
       "      <td>-19</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>-20</td>\n",
       "      <td>-33</td>\n",
       "      <td>-14</td>\n",
       "      <td>3</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>2022-06-30</th>\n",
       "      <td>18</td>\n",
       "      <td>39</td>\n",
       "      <td>60</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>24.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>-14</td>\n",
       "      <td>...</td>\n",
       "      <td>-17</td>\n",
       "      <td>-11</td>\n",
       "      <td>-7</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>-11</td>\n",
       "      <td>-20</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-01</th>\n",
       "      <td>17</td>\n",
       "      <td>40</td>\n",
       "      <td>54</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>23.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>-12</td>\n",
       "      <td>...</td>\n",
       "      <td>-14</td>\n",
       "      <td>-12</td>\n",
       "      <td>-6</td>\n",
       "      <td>12</td>\n",
       "      <td>-1</td>\n",
       "      <td>26</td>\n",
       "      <td>-12</td>\n",
       "      <td>-21</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-02</th>\n",
       "      <td>16</td>\n",
       "      <td>41</td>\n",
       "      <td>50</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>21.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>-2</td>\n",
       "      <td>...</td>\n",
       "      <td>-8</td>\n",
       "      <td>-10</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "      <td>-16</td>\n",
       "      <td>-16</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-03</th>\n",
       "      <td>17</td>\n",
       "      <td>39</td>\n",
       "      <td>51</td>\n",
       "      <td>7.0</td>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>21.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>-2</td>\n",
       "      <td>...</td>\n",
       "      <td>-4</td>\n",
       "      <td>-13</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>27</td>\n",
       "      <td>-5</td>\n",
       "      <td>-14</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-04</th>\n",
       "      <td>19</td>\n",
       "      <td>39</td>\n",
       "      <td>67</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1</td>\n",
       "      <td>15</td>\n",
       "      <td>-3</td>\n",
       "      <td>21.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-15</td>\n",
       "      <td>...</td>\n",
       "      <td>-14</td>\n",
       "      <td>-18</td>\n",
       "      <td>-16</td>\n",
       "      <td>12</td>\n",
       "      <td>-1</td>\n",
       "      <td>23</td>\n",
       "      <td>-9</td>\n",
       "      <td>-22</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>185 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID_retail_recreation  ID_grocery_pharmacy  ID_parks  \\\n",
       "date                                                              \n",
       "2022-01-01                     3                   24        46   \n",
       "2022-01-02                    11                   35        28   \n",
       "2022-01-03                    14                   36        20   \n",
       "2022-01-04                    11                   33        15   \n",
       "2022-01-05                    12                   34        17   \n",
       "...                          ...                  ...       ...   \n",
       "2022-06-30                    18                   39        60   \n",
       "2022-07-01                    17                   40        54   \n",
       "2022-07-02                    16                   41        50   \n",
       "2022-07-03                    17                   39        51   \n",
       "2022-07-04                    19                   39        67   \n",
       "\n",
       "            ID_transit_stations  ID_workplaces  ID_residential  \\\n",
       "date                                                             \n",
       "2022-01-01                -15.0            -49               6   \n",
       "2022-01-02                 -4.0             -4               3   \n",
       "2022-01-03                 -9.0            -10               4   \n",
       "2022-01-04                 -9.0             -8               4   \n",
       "2022-01-05                -10.0             -7               4   \n",
       "...                         ...            ...             ...   \n",
       "2022-06-30                 -1.0              1              15   \n",
       "2022-07-01                 -1.0              2              15   \n",
       "2022-07-02                  6.0             11              12   \n",
       "2022-07-03                  7.0             24              12   \n",
       "2022-07-04                  0.0             -1              15   \n",
       "\n",
       "            MY_retail_recreation  MY_grocery_pharmacy  MY_parks  \\\n",
       "date                                                              \n",
       "2022-01-01                   -11                 14.0       8.0   \n",
       "2022-01-02                   -11                 13.0      -3.0   \n",
       "2022-01-03                    -6                 25.0      -5.0   \n",
       "2022-01-04                    -8                 22.0      -9.0   \n",
       "2022-01-05                    -7                 24.0      -6.0   \n",
       "...                          ...                  ...       ...   \n",
       "2022-06-30                     2                 24.0      21.0   \n",
       "2022-07-01                     3                 23.0      25.0   \n",
       "2022-07-02                     4                 21.0      30.0   \n",
       "2022-07-03                     4                 21.0      33.0   \n",
       "2022-07-04                    -3                 21.0      17.0   \n",
       "\n",
       "            MY_transit_stations  ...  SG_parks  SG_transit_stations  \\\n",
       "date                             ...                                  \n",
       "2022-01-01                  -16  ...        -7                  -25   \n",
       "2022-01-02                  -18  ...       -39                  -26   \n",
       "2022-01-03                  -25  ...        -4                  -26   \n",
       "2022-01-04                  -28  ...        -9                  -23   \n",
       "2022-01-05                  -26  ...        -9                  -21   \n",
       "...                         ...  ...       ...                  ...   \n",
       "2022-06-30                  -14  ...       -17                  -11   \n",
       "2022-07-01                  -12  ...       -14                  -12   \n",
       "2022-07-02                   -2  ...        -8                  -10   \n",
       "2022-07-03                   -2  ...        -4                  -13   \n",
       "2022-07-04                  -15  ...       -14                  -18   \n",
       "\n",
       "            SG_workplaces  SG_residential  TH_retail_recreation  \\\n",
       "date                                                              \n",
       "2022-01-01            -33              14                    -3   \n",
       "2022-01-02              9              11                     3   \n",
       "2022-01-03            -30              17                     9   \n",
       "2022-01-04            -21              15                     3   \n",
       "2022-01-05            -19              15                     1   \n",
       "...                   ...             ...                   ...   \n",
       "2022-06-30             -7              10                     1   \n",
       "2022-07-01             -6              12                    -1   \n",
       "2022-07-02              3               6                     2   \n",
       "2022-07-03              2               6                     4   \n",
       "2022-07-04            -16              12                    -1   \n",
       "\n",
       "            TH_grocery_pharmacy  TH_parks  TH_transit_stations  TH_workplaces  \\\n",
       "date                                                                            \n",
       "2022-01-01                   20        23                  -36            -51   \n",
       "2022-01-02                   21        18                  -30            -26   \n",
       "2022-01-03                   25         5                  -38            -54   \n",
       "2022-01-04                   24       -17                  -34            -18   \n",
       "2022-01-05                   20       -20                  -33            -14   \n",
       "...                         ...       ...                  ...            ...   \n",
       "2022-06-30                   24       -11                  -20              2   \n",
       "2022-07-01                   26       -12                  -21              1   \n",
       "2022-07-02                   26       -16                  -16              7   \n",
       "2022-07-03                   27        -5                  -14              3   \n",
       "2022-07-04                   23        -9                  -22              1   \n",
       "\n",
       "            TH_residential  \n",
       "date                        \n",
       "2022-01-01               0  \n",
       "2022-01-02              -3  \n",
       "2022-01-03               5  \n",
       "2022-01-04               2  \n",
       "2022-01-05               3  \n",
       "...                    ...  \n",
       "2022-06-30               7  \n",
       "2022-07-01               7  \n",
       "2022-07-02               6  \n",
       "2022-07-03               6  \n",
       "2022-07-04               7  \n",
       "\n",
       "[185 rows x 30 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_data = ID_2022_b.join(MY_2022_b.join(PH_2022_b.join(SG_2022_b.join(TH_2022_b))))\n",
    "\n",
    "combined_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "943b6c1b-487f-4bab-a410-15aafb095d78",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['2022-01-01', '2022-01-02', '2022-01-03', '2022-01-04', '2022-01-05',\n",
       "       '2022-01-06', '2022-01-07', '2022-01-08', '2022-01-09', '2022-01-10',\n",
       "       ...\n",
       "       '2022-06-25', '2022-06-26', '2022-06-27', '2022-06-28', '2022-06-29',\n",
       "       '2022-06-30', '2022-07-01', '2022-07-02', '2022-07-03', '2022-07-04'],\n",
       "      dtype='object', name='date', length=185)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_data.index.unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0e52e05b-91bb-4902-b47e-06a36bb10735",
   "metadata": {},
   "source": [
    "**Parsing Dates - Example**\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "57cdb821-f630-4c39-9da1-87b92ceba049",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_data.index.dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "6556770f-891e-41b2-8a38-2d19d606d94e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date\n",
       "2022-01-01   2022-01-01\n",
       "2022-01-02   2022-01-02\n",
       "2022-01-03   2022-01-03\n",
       "2022-01-04   2022-01-04\n",
       "2022-01-05   2022-01-05\n",
       "                ...    \n",
       "2022-06-30   2022-06-30\n",
       "2022-07-01   2022-07-01\n",
       "2022-07-02   2022-07-02\n",
       "2022-07-03   2022-07-03\n",
       "2022-07-04   2022-07-04\n",
       "Name: parsed_dates, Length: 185, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_data['parsed_dates'] = pd.to_datetime(combined_data.index, \\\n",
    "                                               format=\"%Y/%m/%d\")\n",
    "\n",
    "combined_data['parsed_dates']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "6ad014b4-14a0-47bc-9f75-dddc3e0e5dbe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('<M8[ns]')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "combined_data['parsed_dates'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "59111f16-8cb5-457a-bae3-82f6ed1362db",
   "metadata": {},
   "outputs": [],
   "source": [
    "combined_data['Day'] = combined_data['parsed_dates'].dt.day\n",
    "combined_data['Month'] = combined_data['parsed_dates'].dt.month\n",
    "combined_data['Year'] = combined_data['parsed_dates'].dt.year\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "b37eb02b-ec1e-4626-918f-e2ef50fc1c7d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date\n",
       "2022-01-01     1\n",
       "2022-01-02     2\n",
       "2022-01-03     3\n",
       "2022-01-04     4\n",
       "2022-01-05     5\n",
       "              ..\n",
       "2022-06-30    30\n",
       "2022-07-01     1\n",
       "2022-07-02     2\n",
       "2022-07-03     3\n",
       "2022-07-04     4\n",
       "Name: Day, Length: 185, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_data['Day'] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "cac1dee2-13f6-4b93-bcc7-77e9f6cf83b1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date\n",
       "2022-01-01    1\n",
       "2022-01-02    1\n",
       "2022-01-03    1\n",
       "2022-01-04    1\n",
       "2022-01-05    1\n",
       "             ..\n",
       "2022-06-30    6\n",
       "2022-07-01    7\n",
       "2022-07-02    7\n",
       "2022-07-03    7\n",
       "2022-07-04    7\n",
       "Name: Month, Length: 185, dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_data['Month'] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "5f4ab04f-0d1a-4d68-a7d4-be125a8eeb2c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date\n",
       "2022-01-01    2022\n",
       "2022-01-02    2022\n",
       "2022-01-03    2022\n",
       "2022-01-04    2022\n",
       "2022-01-05    2022\n",
       "              ... \n",
       "2022-06-30    2022\n",
       "2022-07-01    2022\n",
       "2022-07-02    2022\n",
       "2022-07-03    2022\n",
       "2022-07-04    2022\n",
       "Name: Year, Length: 185, dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_data['Year']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "89ed8ca5-c651-46cf-b7fa-ea835742890b",
   "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>ID_retail_recreation</th>\n",
       "      <th>ID_grocery_pharmacy</th>\n",
       "      <th>ID_parks</th>\n",
       "      <th>ID_transit_stations</th>\n",
       "      <th>ID_workplaces</th>\n",
       "      <th>ID_residential</th>\n",
       "      <th>MY_retail_recreation</th>\n",
       "      <th>MY_grocery_pharmacy</th>\n",
       "      <th>MY_parks</th>\n",
       "      <th>MY_transit_stations</th>\n",
       "      <th>...</th>\n",
       "      <th>TH_retail_recreation</th>\n",
       "      <th>TH_grocery_pharmacy</th>\n",
       "      <th>TH_parks</th>\n",
       "      <th>TH_transit_stations</th>\n",
       "      <th>TH_workplaces</th>\n",
       "      <th>TH_residential</th>\n",
       "      <th>parsed_dates</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-01-01</th>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>46</td>\n",
       "      <td>-15.0</td>\n",
       "      <td>-49</td>\n",
       "      <td>6</td>\n",
       "      <td>-11</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>-16</td>\n",
       "      <td>...</td>\n",
       "      <td>-3</td>\n",
       "      <td>20</td>\n",
       "      <td>23</td>\n",
       "      <td>-36</td>\n",
       "      <td>-51</td>\n",
       "      <td>0</td>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-02</th>\n",
       "      <td>11</td>\n",
       "      <td>35</td>\n",
       "      <td>28</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>-4</td>\n",
       "      <td>3</td>\n",
       "      <td>-11</td>\n",
       "      <td>13.0</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>-18</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>21</td>\n",
       "      <td>18</td>\n",
       "      <td>-30</td>\n",
       "      <td>-26</td>\n",
       "      <td>-3</td>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-03</th>\n",
       "      <td>14</td>\n",
       "      <td>36</td>\n",
       "      <td>20</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-10</td>\n",
       "      <td>4</td>\n",
       "      <td>-6</td>\n",
       "      <td>25.0</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>-25</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>-38</td>\n",
       "      <td>-54</td>\n",
       "      <td>5</td>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-04</th>\n",
       "      <td>11</td>\n",
       "      <td>33</td>\n",
       "      <td>15</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-8</td>\n",
       "      <td>4</td>\n",
       "      <td>-8</td>\n",
       "      <td>22.0</td>\n",
       "      <td>-9.0</td>\n",
       "      <td>-28</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>-17</td>\n",
       "      <td>-34</td>\n",
       "      <td>-18</td>\n",
       "      <td>2</td>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-05</th>\n",
       "      <td>12</td>\n",
       "      <td>34</td>\n",
       "      <td>17</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>-7</td>\n",
       "      <td>4</td>\n",
       "      <td>-7</td>\n",
       "      <td>24.0</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>-26</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>-20</td>\n",
       "      <td>-33</td>\n",
       "      <td>-14</td>\n",
       "      <td>3</td>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2022</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>2022-06-30</th>\n",
       "      <td>18</td>\n",
       "      <td>39</td>\n",
       "      <td>60</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>24.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>-14</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>-11</td>\n",
       "      <td>-20</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>2022-06-30</td>\n",
       "      <td>30</td>\n",
       "      <td>6</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-01</th>\n",
       "      <td>17</td>\n",
       "      <td>40</td>\n",
       "      <td>54</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>23.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>-12</td>\n",
       "      <td>...</td>\n",
       "      <td>-1</td>\n",
       "      <td>26</td>\n",
       "      <td>-12</td>\n",
       "      <td>-21</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-02</th>\n",
       "      <td>16</td>\n",
       "      <td>41</td>\n",
       "      <td>50</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>21.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>-2</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "      <td>-16</td>\n",
       "      <td>-16</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>2022-07-02</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-03</th>\n",
       "      <td>17</td>\n",
       "      <td>39</td>\n",
       "      <td>51</td>\n",
       "      <td>7.0</td>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>21.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>-2</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>27</td>\n",
       "      <td>-5</td>\n",
       "      <td>-14</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>2022-07-03</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-04</th>\n",
       "      <td>19</td>\n",
       "      <td>39</td>\n",
       "      <td>67</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1</td>\n",
       "      <td>15</td>\n",
       "      <td>-3</td>\n",
       "      <td>21.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>-15</td>\n",
       "      <td>...</td>\n",
       "      <td>-1</td>\n",
       "      <td>23</td>\n",
       "      <td>-9</td>\n",
       "      <td>-22</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>2022-07-04</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>185 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID_retail_recreation  ID_grocery_pharmacy  ID_parks  \\\n",
       "date                                                              \n",
       "2022-01-01                     3                   24        46   \n",
       "2022-01-02                    11                   35        28   \n",
       "2022-01-03                    14                   36        20   \n",
       "2022-01-04                    11                   33        15   \n",
       "2022-01-05                    12                   34        17   \n",
       "...                          ...                  ...       ...   \n",
       "2022-06-30                    18                   39        60   \n",
       "2022-07-01                    17                   40        54   \n",
       "2022-07-02                    16                   41        50   \n",
       "2022-07-03                    17                   39        51   \n",
       "2022-07-04                    19                   39        67   \n",
       "\n",
       "            ID_transit_stations  ID_workplaces  ID_residential  \\\n",
       "date                                                             \n",
       "2022-01-01                -15.0            -49               6   \n",
       "2022-01-02                 -4.0             -4               3   \n",
       "2022-01-03                 -9.0            -10               4   \n",
       "2022-01-04                 -9.0             -8               4   \n",
       "2022-01-05                -10.0             -7               4   \n",
       "...                         ...            ...             ...   \n",
       "2022-06-30                 -1.0              1              15   \n",
       "2022-07-01                 -1.0              2              15   \n",
       "2022-07-02                  6.0             11              12   \n",
       "2022-07-03                  7.0             24              12   \n",
       "2022-07-04                  0.0             -1              15   \n",
       "\n",
       "            MY_retail_recreation  MY_grocery_pharmacy  MY_parks  \\\n",
       "date                                                              \n",
       "2022-01-01                   -11                 14.0       8.0   \n",
       "2022-01-02                   -11                 13.0      -3.0   \n",
       "2022-01-03                    -6                 25.0      -5.0   \n",
       "2022-01-04                    -8                 22.0      -9.0   \n",
       "2022-01-05                    -7                 24.0      -6.0   \n",
       "...                          ...                  ...       ...   \n",
       "2022-06-30                     2                 24.0      21.0   \n",
       "2022-07-01                     3                 23.0      25.0   \n",
       "2022-07-02                     4                 21.0      30.0   \n",
       "2022-07-03                     4                 21.0      33.0   \n",
       "2022-07-04                    -3                 21.0      17.0   \n",
       "\n",
       "            MY_transit_stations  ...  TH_retail_recreation  \\\n",
       "date                             ...                         \n",
       "2022-01-01                  -16  ...                    -3   \n",
       "2022-01-02                  -18  ...                     3   \n",
       "2022-01-03                  -25  ...                     9   \n",
       "2022-01-04                  -28  ...                     3   \n",
       "2022-01-05                  -26  ...                     1   \n",
       "...                         ...  ...                   ...   \n",
       "2022-06-30                  -14  ...                     1   \n",
       "2022-07-01                  -12  ...                    -1   \n",
       "2022-07-02                   -2  ...                     2   \n",
       "2022-07-03                   -2  ...                     4   \n",
       "2022-07-04                  -15  ...                    -1   \n",
       "\n",
       "            TH_grocery_pharmacy  TH_parks  TH_transit_stations  TH_workplaces  \\\n",
       "date                                                                            \n",
       "2022-01-01                   20        23                  -36            -51   \n",
       "2022-01-02                   21        18                  -30            -26   \n",
       "2022-01-03                   25         5                  -38            -54   \n",
       "2022-01-04                   24       -17                  -34            -18   \n",
       "2022-01-05                   20       -20                  -33            -14   \n",
       "...                         ...       ...                  ...            ...   \n",
       "2022-06-30                   24       -11                  -20              2   \n",
       "2022-07-01                   26       -12                  -21              1   \n",
       "2022-07-02                   26       -16                  -16              7   \n",
       "2022-07-03                   27        -5                  -14              3   \n",
       "2022-07-04                   23        -9                  -22              1   \n",
       "\n",
       "            TH_residential  parsed_dates  Day  Month  Year  \n",
       "date                                                        \n",
       "2022-01-01               0    2022-01-01    1      1  2022  \n",
       "2022-01-02              -3    2022-01-02    2      1  2022  \n",
       "2022-01-03               5    2022-01-03    3      1  2022  \n",
       "2022-01-04               2    2022-01-04    4      1  2022  \n",
       "2022-01-05               3    2022-01-05    5      1  2022  \n",
       "...                    ...           ...  ...    ...   ...  \n",
       "2022-06-30               7    2022-06-30   30      6  2022  \n",
       "2022-07-01               7    2022-07-01    1      7  2022  \n",
       "2022-07-02               6    2022-07-02    2      7  2022  \n",
       "2022-07-03               6    2022-07-03    3      7  2022  \n",
       "2022-07-04               7    2022-07-04    4      7  2022  \n",
       "\n",
       "[185 rows x 34 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1812dfc8-7f89-4809-955a-4bc4aa89a99f",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}