testml_grace.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import json\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import dotenv\n",
    "import os\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "from sklearn.model_selection import train_test_split, GridSearchCV, cross_val_score, cross_validate\n",
    "from sklearn.ensemble import RandomForestClassifier, AdaBoostClassifier, BaggingClassifier\n",
    "from sklearn.metrics import accuracy_score, roc_curve, auc, ConfusionMatrixDisplay, confusion_matrix, classification_report, precision_score\n",
    "from sklearn.preprocessing import OneHotEncoder, StandardScaler, MinMaxScaler\n",
    "from sklearn.linear_model import LinearRegression\n",
    "from sklearn.tree import DecisionTreeClassifier\n",
    "from sklearn.compose import ColumnTransformer\n",
    "from sklearn.pipeline import Pipeline\n",
    "from xgboost import XGBClassifier\n",
    "import statsmodels.api as sm\n",
    "\n",
    "\n",
    "from datetime import datetime,timedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>facility_name</th>\n",
       "      <th>ParkID</th>\n",
       "      <th>zone_id</th>\n",
       "      <th>total_parking_spots</th>\n",
       "      <th>occupancy_total</th>\n",
       "      <th>day_of_week</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>parking_availability</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Warriewood Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>244</td>\n",
       "      <td>20</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>00:53:26</td>\n",
       "      <td>224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Warriewood Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>244</td>\n",
       "      <td>19</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>00:55:59</td>\n",
       "      <td>225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Warriewood Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>244</td>\n",
       "      <td>18</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>01:25:34</td>\n",
       "      <td>226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Warriewood Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>244</td>\n",
       "      <td>17</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>01:26:37</td>\n",
       "      <td>227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Warriewood Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>244</td>\n",
       "      <td>16</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>01:53:18</td>\n",
       "      <td>228</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503027</th>\n",
       "      <td>Revesby Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>934</td>\n",
       "      <td>52</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2023-12-31</td>\n",
       "      <td>23:19:07</td>\n",
       "      <td>882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503028</th>\n",
       "      <td>Revesby Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>934</td>\n",
       "      <td>51</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2023-12-31</td>\n",
       "      <td>23:21:53</td>\n",
       "      <td>883</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503029</th>\n",
       "      <td>Revesby Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>934</td>\n",
       "      <td>51</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2023-12-31</td>\n",
       "      <td>23:31:53</td>\n",
       "      <td>883</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503030</th>\n",
       "      <td>Revesby Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>934</td>\n",
       "      <td>51</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2023-12-31</td>\n",
       "      <td>23:41:54</td>\n",
       "      <td>883</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503031</th>\n",
       "      <td>Revesby Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>934</td>\n",
       "      <td>51</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2023-12-31</td>\n",
       "      <td>23:51:56</td>\n",
       "      <td>883</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>503008 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              facility_name  ParkID  zone_id  total_parking_spots  \\\n",
       "0       Warriewood Car Park       1        1                  244   \n",
       "1       Warriewood Car Park       1        1                  244   \n",
       "2       Warriewood Car Park       1        1                  244   \n",
       "3       Warriewood Car Park       1        1                  244   \n",
       "4       Warriewood Car Park       1        1                  244   \n",
       "...                     ...     ...      ...                  ...   \n",
       "503027     Revesby Car Park       1        1                  934   \n",
       "503028     Revesby Car Park       1        1                  934   \n",
       "503029     Revesby Car Park       1        1                  934   \n",
       "503030     Revesby Car Park       1        1                  934   \n",
       "503031     Revesby Car Park       1        1                  934   \n",
       "\n",
       "        occupancy_total day_of_week        date      time  \\\n",
       "0                    20      Friday  2023-12-01  00:53:26   \n",
       "1                    19      Friday  2023-12-01  00:55:59   \n",
       "2                    18      Friday  2023-12-01  01:25:34   \n",
       "3                    17      Friday  2023-12-01  01:26:37   \n",
       "4                    16      Friday  2023-12-01  01:53:18   \n",
       "...                 ...         ...         ...       ...   \n",
       "503027               52      Sunday  2023-12-31  23:19:07   \n",
       "503028               51      Sunday  2023-12-31  23:21:53   \n",
       "503029               51      Sunday  2023-12-31  23:31:53   \n",
       "503030               51      Sunday  2023-12-31  23:41:54   \n",
       "503031               51      Sunday  2023-12-31  23:51:56   \n",
       "\n",
       "        parking_availability  \n",
       "0                        224  \n",
       "1                        225  \n",
       "2                        226  \n",
       "3                        227  \n",
       "4                        228  \n",
       "...                      ...  \n",
       "503027                   882  \n",
       "503028                   883  \n",
       "503029                   883  \n",
       "503030                   883  \n",
       "503031                   883  \n",
       "\n",
       "[503008 rows x 9 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('./data/no_duplicate_df.csv', index_col=0)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>facility_name</th>\n",
       "      <th>ParkID</th>\n",
       "      <th>zone_id</th>\n",
       "      <th>total_parking_spots</th>\n",
       "      <th>occupancy_total</th>\n",
       "      <th>day_of_week</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>parking_availability</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>414580</th>\n",
       "      <td>Cherrybrook Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>384</td>\n",
       "      <td>384</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2023-12-04</td>\n",
       "      <td>13:16:37</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106542</th>\n",
       "      <td>Edmondson Park South Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1429</td>\n",
       "      <td>144</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-22</td>\n",
       "      <td>07:36:01</td>\n",
       "      <td>1285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341610</th>\n",
       "      <td>Kellyville South Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>964</td>\n",
       "      <td>310</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2023-12-27</td>\n",
       "      <td>16:04:07</td>\n",
       "      <td>654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489537</th>\n",
       "      <td>Revesby Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>934</td>\n",
       "      <td>243</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2023-12-06</td>\n",
       "      <td>18:23:49</td>\n",
       "      <td>691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68249</th>\n",
       "      <td>Leppington Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1884</td>\n",
       "      <td>345</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-15</td>\n",
       "      <td>06:03:39</td>\n",
       "      <td>1539</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14181</th>\n",
       "      <td>Mona Vale Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-08</td>\n",
       "      <td>16:57:38</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278091</th>\n",
       "      <td>Tallawong P3 Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>397</td>\n",
       "      <td>120</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>07:51:56</td>\n",
       "      <td>277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Warriewood Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>244</td>\n",
       "      <td>101</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>08:32:57</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218888</th>\n",
       "      <td>Schofields Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>700</td>\n",
       "      <td>506</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2023-12-19</td>\n",
       "      <td>08:26:24</td>\n",
       "      <td>194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91919</th>\n",
       "      <td>Edmondson Park South Car Park</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1429</td>\n",
       "      <td>95</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2023-12-08</td>\n",
       "      <td>22:45:32</td>\n",
       "      <td>1334</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5030 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        facility_name  ParkID  zone_id  total_parking_spots  \\\n",
       "414580           Cherrybrook Car Park       1        1                  384   \n",
       "106542  Edmondson Park South Car Park       1        1                 1429   \n",
       "341610      Kellyville South Car Park       1        1                  964   \n",
       "489537               Revesby Car Park       1        1                  934   \n",
       "68249             Leppington Car Park       1        1                 1884   \n",
       "...                               ...     ...      ...                  ...   \n",
       "14181              Mona Vale Car Park       1        1                   68   \n",
       "278091          Tallawong P3 Car Park       1        1                  397   \n",
       "95                Warriewood Car Park       1        1                  244   \n",
       "218888            Schofields Car Park       1        1                  700   \n",
       "91919   Edmondson Park South Car Park       1        1                 1429   \n",
       "\n",
       "        occupancy_total day_of_week        date      time  \\\n",
       "414580              384      Monday  2023-12-04  13:16:37   \n",
       "106542              144      Friday  2023-12-22  07:36:01   \n",
       "341610              310   Wednesday  2023-12-27  16:04:07   \n",
       "489537              243   Wednesday  2023-12-06  18:23:49   \n",
       "68249               345      Friday  2023-12-15  06:03:39   \n",
       "...                 ...         ...         ...       ...   \n",
       "14181                63      Friday  2023-12-08  16:57:38   \n",
       "278091              120      Friday  2023-12-01  07:51:56   \n",
       "95                  101      Friday  2023-12-01  08:32:57   \n",
       "218888              506     Tuesday  2023-12-19  08:26:24   \n",
       "91919                95      Friday  2023-12-08  22:45:32   \n",
       "\n",
       "        parking_availability  \n",
       "414580                     0  \n",
       "106542                  1285  \n",
       "341610                   654  \n",
       "489537                   691  \n",
       "68249                   1539  \n",
       "...                      ...  \n",
       "14181                      5  \n",
       "278091                   277  \n",
       "95                       143  \n",
       "218888                   194  \n",
       "91919                   1334  \n",
       "\n",
       "[5030 rows x 9 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.sample(frac=0.01)\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>ParkID</th>\n",
       "      <th>zone_id</th>\n",
       "      <th>total_parking_spots</th>\n",
       "      <th>occupancy_total</th>\n",
       "      <th>parking_availability</th>\n",
       "      <th>facility_name_Bella Vista Car Park</th>\n",
       "      <th>facility_name_Campbelltown Farrow Rd North Car Park</th>\n",
       "      <th>facility_name_Campbelltown Hurley Street South Car Park</th>\n",
       "      <th>facility_name_Cherrybrook Car Park</th>\n",
       "      <th>facility_name_Dee Why Car Park</th>\n",
       "      <th>...</th>\n",
       "      <th>date_2023-12-22</th>\n",
       "      <th>date_2023-12-23</th>\n",
       "      <th>date_2023-12-24</th>\n",
       "      <th>date_2023-12-25</th>\n",
       "      <th>date_2023-12-26</th>\n",
       "      <th>date_2023-12-27</th>\n",
       "      <th>date_2023-12-28</th>\n",
       "      <th>date_2023-12-29</th>\n",
       "      <th>date_2023-12-30</th>\n",
       "      <th>date_2023-12-31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>414580</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>384</td>\n",
       "      <td>384</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106542</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1429</td>\n",
       "      <td>144</td>\n",
       "      <td>1285</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341610</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>964</td>\n",
       "      <td>310</td>\n",
       "      <td>654</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489537</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>934</td>\n",
       "      <td>243</td>\n",
       "      <td>691</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68249</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1884</td>\n",
       "      <td>345</td>\n",
       "      <td>1539</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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>14181</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>68</td>\n",
       "      <td>63</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278091</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>397</td>\n",
       "      <td>120</td>\n",
       "      <td>277</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>244</td>\n",
       "      <td>101</td>\n",
       "      <td>143</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218888</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>700</td>\n",
       "      <td>506</td>\n",
       "      <td>194</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91919</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1429</td>\n",
       "      <td>95</td>\n",
       "      <td>1334</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5030 rows × 71 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ParkID  zone_id  total_parking_spots  occupancy_total  \\\n",
       "414580       1        1                  384              384   \n",
       "106542       1        1                 1429              144   \n",
       "341610       1        1                  964              310   \n",
       "489537       1        1                  934              243   \n",
       "68249        1        1                 1884              345   \n",
       "...        ...      ...                  ...              ...   \n",
       "14181        1        1                   68               63   \n",
       "278091       1        1                  397              120   \n",
       "95           1        1                  244              101   \n",
       "218888       1        1                  700              506   \n",
       "91919        1        1                 1429               95   \n",
       "\n",
       "        parking_availability  facility_name_Bella Vista Car Park  \\\n",
       "414580                     0                                   0   \n",
       "106542                  1285                                   0   \n",
       "341610                   654                                   0   \n",
       "489537                   691                                   0   \n",
       "68249                   1539                                   0   \n",
       "...                      ...                                 ...   \n",
       "14181                      5                                   0   \n",
       "278091                   277                                   0   \n",
       "95                       143                                   0   \n",
       "218888                   194                                   0   \n",
       "91919                   1334                                   0   \n",
       "\n",
       "        facility_name_Campbelltown Farrow Rd North Car Park  \\\n",
       "414580                                                  0     \n",
       "106542                                                  0     \n",
       "341610                                                  0     \n",
       "489537                                                  0     \n",
       "68249                                                   0     \n",
       "...                                                   ...     \n",
       "14181                                                   0     \n",
       "278091                                                  0     \n",
       "95                                                      0     \n",
       "218888                                                  0     \n",
       "91919                                                   0     \n",
       "\n",
       "        facility_name_Campbelltown Hurley Street South Car Park  \\\n",
       "414580                                                  0         \n",
       "106542                                                  0         \n",
       "341610                                                  0         \n",
       "489537                                                  0         \n",
       "68249                                                   0         \n",
       "...                                                   ...         \n",
       "14181                                                   0         \n",
       "278091                                                  0         \n",
       "95                                                      0         \n",
       "218888                                                  0         \n",
       "91919                                                   0         \n",
       "\n",
       "        facility_name_Cherrybrook Car Park  facility_name_Dee Why Car Park  \\\n",
       "414580                                   1                               0   \n",
       "106542                                   0                               0   \n",
       "341610                                   0                               0   \n",
       "489537                                   0                               0   \n",
       "68249                                    0                               0   \n",
       "...                                    ...                             ...   \n",
       "14181                                    0                               0   \n",
       "278091                                   0                               0   \n",
       "95                                       0                               0   \n",
       "218888                                   0                               0   \n",
       "91919                                    0                               0   \n",
       "\n",
       "        ...  date_2023-12-22  date_2023-12-23  date_2023-12-24  \\\n",
       "414580  ...                0                0                0   \n",
       "106542  ...                1                0                0   \n",
       "341610  ...                0                0                0   \n",
       "489537  ...                0                0                0   \n",
       "68249   ...                0                0                0   \n",
       "...     ...              ...              ...              ...   \n",
       "14181   ...                0                0                0   \n",
       "278091  ...                0                0                0   \n",
       "95      ...                0                0                0   \n",
       "218888  ...                0                0                0   \n",
       "91919   ...                0                0                0   \n",
       "\n",
       "        date_2023-12-25  date_2023-12-26  date_2023-12-27  date_2023-12-28  \\\n",
       "414580                0                0                0                0   \n",
       "106542                0                0                0                0   \n",
       "341610                0                0                1                0   \n",
       "489537                0                0                0                0   \n",
       "68249                 0                0                0                0   \n",
       "...                 ...              ...              ...              ...   \n",
       "14181                 0                0                0                0   \n",
       "278091                0                0                0                0   \n",
       "95                    0                0                0                0   \n",
       "218888                0                0                0                0   \n",
       "91919                 0                0                0                0   \n",
       "\n",
       "        date_2023-12-29  date_2023-12-30  date_2023-12-31  \n",
       "414580                0                0                0  \n",
       "106542                0                0                0  \n",
       "341610                0                0                0  \n",
       "489537                0                0                0  \n",
       "68249                 0                0                0  \n",
       "...                 ...              ...              ...  \n",
       "14181                 0                0                0  \n",
       "278091                0                0                0  \n",
       "95                    0                0                0  \n",
       "218888                0                0                0  \n",
       "91919                 0                0                0  \n",
       "\n",
       "[5030 rows x 71 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(['time'], inplace=True, axis=1)\n",
    "df = pd.get_dummies(df)\n",
    "df = df.astype(int)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>ParkID</th>\n",
       "      <th>zone_id</th>\n",
       "      <th>total_parking_spots</th>\n",
       "      <th>occupancy_total</th>\n",
       "      <th>facility_name_Bella Vista Car Park</th>\n",
       "      <th>facility_name_Campbelltown Farrow Rd North Car Park</th>\n",
       "      <th>facility_name_Campbelltown Hurley Street South Car Park</th>\n",
       "      <th>facility_name_Cherrybrook Car Park</th>\n",
       "      <th>facility_name_Dee Why Car Park</th>\n",
       "      <th>facility_name_Edmondson Park South Car Park</th>\n",
       "      <th>...</th>\n",
       "      <th>date_2023-12-22</th>\n",
       "      <th>date_2023-12-23</th>\n",
       "      <th>date_2023-12-24</th>\n",
       "      <th>date_2023-12-25</th>\n",
       "      <th>date_2023-12-26</th>\n",
       "      <th>date_2023-12-27</th>\n",
       "      <th>date_2023-12-28</th>\n",
       "      <th>date_2023-12-29</th>\n",
       "      <th>date_2023-12-30</th>\n",
       "      <th>date_2023-12-31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>370065</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>777</td>\n",
       "      <td>404</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35838</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>151</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292305</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>351</td>\n",
       "      <td>186</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470530</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1057</td>\n",
       "      <td>569</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472429</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1057</td>\n",
       "      <td>308</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>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>318743</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>964</td>\n",
       "      <td>582</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94427</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1429</td>\n",
       "      <td>287</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223210</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>700</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484146</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1057</td>\n",
       "      <td>297</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443540</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>213</td>\n",
       "      <td>173</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3521 rows × 70 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ParkID  zone_id  total_parking_spots  occupancy_total  \\\n",
       "370065       1        1                  777              404   \n",
       "35838        1        1                  151               13   \n",
       "292305       1        1                  351              186   \n",
       "470530       1        1                 1057              569   \n",
       "472429       1        1                 1057              308   \n",
       "...        ...      ...                  ...              ...   \n",
       "318743       1        1                  964              582   \n",
       "94427        1        1                 1429              287   \n",
       "223210       1        1                  700               44   \n",
       "484146       1        1                 1057              297   \n",
       "443540       1        1                  213              173   \n",
       "\n",
       "        facility_name_Bella Vista Car Park  \\\n",
       "370065                                   1   \n",
       "35838                                    0   \n",
       "292305                                   0   \n",
       "470530                                   0   \n",
       "472429                                   0   \n",
       "...                                    ...   \n",
       "318743                                   0   \n",
       "94427                                    0   \n",
       "223210                                   0   \n",
       "484146                                   0   \n",
       "443540                                   0   \n",
       "\n",
       "        facility_name_Campbelltown Farrow Rd North Car Park  \\\n",
       "370065                                                  0     \n",
       "35838                                                   0     \n",
       "292305                                                  0     \n",
       "470530                                                  0     \n",
       "472429                                                  0     \n",
       "...                                                   ...     \n",
       "318743                                                  0     \n",
       "94427                                                   0     \n",
       "223210                                                  0     \n",
       "484146                                                  0     \n",
       "443540                                                  0     \n",
       "\n",
       "        facility_name_Campbelltown Hurley Street South Car Park  \\\n",
       "370065                                                  0         \n",
       "35838                                                   0         \n",
       "292305                                                  0         \n",
       "470530                                                  0         \n",
       "472429                                                  0         \n",
       "...                                                   ...         \n",
       "318743                                                  0         \n",
       "94427                                                   0         \n",
       "223210                                                  0         \n",
       "484146                                                  0         \n",
       "443540                                                  0         \n",
       "\n",
       "        facility_name_Cherrybrook Car Park  facility_name_Dee Why Car Park  \\\n",
       "370065                                   0                               0   \n",
       "35838                                    0                               0   \n",
       "292305                                   0                               0   \n",
       "470530                                   0                               0   \n",
       "472429                                   0                               0   \n",
       "...                                    ...                             ...   \n",
       "318743                                   0                               0   \n",
       "94427                                    0                               0   \n",
       "223210                                   0                               0   \n",
       "484146                                   0                               0   \n",
       "443540                                   0                               0   \n",
       "\n",
       "        facility_name_Edmondson Park South Car Park  ...  date_2023-12-22  \\\n",
       "370065                                            0  ...                0   \n",
       "35838                                             0  ...                0   \n",
       "292305                                            0  ...                0   \n",
       "470530                                            0  ...                0   \n",
       "472429                                            0  ...                0   \n",
       "...                                             ...  ...              ...   \n",
       "318743                                            0  ...                0   \n",
       "94427                                             1  ...                0   \n",
       "223210                                            0  ...                0   \n",
       "484146                                            0  ...                0   \n",
       "443540                                            0  ...                0   \n",
       "\n",
       "        date_2023-12-23  date_2023-12-24  date_2023-12-25  date_2023-12-26  \\\n",
       "370065                0                0                0                0   \n",
       "35838                 0                0                0                0   \n",
       "292305                0                0                0                0   \n",
       "470530                0                0                0                0   \n",
       "472429                0                0                0                0   \n",
       "...                 ...              ...              ...              ...   \n",
       "318743                0                0                0                0   \n",
       "94427                 0                0                0                0   \n",
       "223210                1                0                0                0   \n",
       "484146                0                0                0                0   \n",
       "443540                0                0                0                0   \n",
       "\n",
       "        date_2023-12-27  date_2023-12-28  date_2023-12-29  date_2023-12-30  \\\n",
       "370065                0                0                0                0   \n",
       "35838                 0                0                0                0   \n",
       "292305                0                0                0                0   \n",
       "470530                0                0                0                0   \n",
       "472429                0                0                0                0   \n",
       "...                 ...              ...              ...              ...   \n",
       "318743                0                0                0                0   \n",
       "94427                 0                0                0                0   \n",
       "223210                0                0                0                0   \n",
       "484146                0                0                0                0   \n",
       "443540                0                0                0                0   \n",
       "\n",
       "        date_2023-12-31  \n",
       "370065                0  \n",
       "35838                 1  \n",
       "292305                0  \n",
       "470530                0  \n",
       "472429                0  \n",
       "...                 ...  \n",
       "318743                0  \n",
       "94427                 0  \n",
       "223210                0  \n",
       "484146                1  \n",
       "443540                0  \n",
       "\n",
       "[3521 rows x 70 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# Define the target column and the features\n",
    "\n",
    "y = df.parking_availability\n",
    "X = df.drop(['parking_availability'], axis = 1)\n",
    "\n",
    "# Split the data into test and train samples, with a random state of 121 for reproducability and test size of 30%\n",
    "\n",
    "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size= 0.3, random_state = 121)\n",
    "X_train"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Your code here\n",
    "iterated_model = sm.OLS(y_train, sm.add_constant(X_train))\n",
    "iterated_results = iterated_model.fit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                             OLS Regression Results                             \n",
      "================================================================================\n",
      "Dep. Variable:     parking_availability   R-squared:                       1.000\n",
      "Model:                              OLS   Adj. R-squared:                  1.000\n",
      "Method:                   Least Squares   F-statistic:                 2.120e+31\n",
      "Date:                  Wed, 07 Feb 2024   Prob (F-statistic):               0.00\n",
      "Time:                          22:33:21   Log-Likelihood:                 93668.\n",
      "No. Observations:                  3521   AIC:                        -1.872e+05\n",
      "Df Residuals:                      3462   BIC:                        -1.869e+05\n",
      "Df Model:                            58                                         \n",
      "Covariance Type:              nonrobust                                         \n",
      "===========================================================================================================================\n",
      "                                                              coef    std err          t      P>|t|      [0.025      0.975]\n",
      "---------------------------------------------------------------------------------------------------------------------------\n",
      "ParkID                                                   3.862e-05   1.29e-14   2.99e+09      0.000    3.86e-05    3.86e-05\n",
      "zone_id                                                  3.862e-05   1.29e-14   2.99e+09      0.000    3.86e-05    3.86e-05\n",
      "total_parking_spots                                         1.0000   3.54e-17   2.82e+16      0.000       1.000       1.000\n",
      "occupancy_total                                            -1.0000   6.72e-17  -1.49e+16      0.000      -1.000      -1.000\n",
      "facility_name_Bella Vista Car Park                       4.334e-05   4.67e-14   9.29e+08      0.000    4.33e-05    4.33e-05\n",
      "facility_name_Campbelltown Farrow Rd North Car Park     -7.287e-05   8.57e-14   -8.5e+08      0.000   -7.29e-05   -7.29e-05\n",
      "facility_name_Campbelltown Hurley Street South Car Park -6.468e-05   7.42e-14  -8.72e+08      0.000   -6.47e-05   -6.47e-05\n",
      "facility_name_Cherrybrook Car Park                      -2.108e-05   4.83e-14  -4.37e+08      0.000   -2.11e-05   -2.11e-05\n",
      "facility_name_Dee Why Car Park                          -6.484e-05   1.16e-13  -5.57e+08      0.000   -6.48e-05   -6.48e-05\n",
      "facility_name_Edmondson Park South Car Park                 0.0002   4.45e-14   3.38e+09      0.000       0.000       0.000\n",
      "facility_name_Gordon Henry St North Car Park             -4.91e-05   8.76e-14  -5.61e+08      0.000   -4.91e-05   -4.91e-05\n",
      "facility_name_Gosford Car Park                           8.923e-05   4.48e-14   1.99e+09      0.000    8.92e-05    8.92e-05\n",
      "facility_name_Hills Showground Car Park                  1.171e-05   4.66e-14   2.51e+08      0.000    1.17e-05    1.17e-05\n",
      "facility_name_Hornsby Jersey St Car Park                -6.025e-05    8.6e-14     -7e+08      0.000   -6.03e-05   -6.03e-05\n",
      "facility_name_Kellyville North Car Park                 -2.649e-05   7.47e-14  -3.55e+08      0.000   -2.65e-05   -2.65e-05\n",
      "facility_name_Kellyville South Car Park                  7.399e-05   4.11e-14    1.8e+09      0.000     7.4e-05     7.4e-05\n",
      "facility_name_Kiama Car Park                            -7.713e-05   2.03e-13   -3.8e+08      0.000   -7.71e-05   -7.71e-05\n",
      "facility_name_Leppington Car Park                           0.0002   4.48e-14   5.01e+09      0.000       0.000       0.000\n",
      "facility_name_Mona Vale Car Park                        -7.287e-05   1.11e-13  -6.56e+08      0.000   -7.29e-05   -7.29e-05\n",
      "facility_name_Narrabeen Car Park                        -7.648e-05   1.02e-13  -7.53e+08      0.000   -7.65e-05   -7.65e-05\n",
      "facility_name_Penrith Combewood At-Grade Car Park       -4.632e-05   1.07e-13  -4.35e+08      0.000   -4.63e-05   -4.63e-05\n",
      "facility_name_Penrith Combewood Multi-Level Car Park        0.0001   5.09e-14   2.03e+09      0.000       0.000       0.000\n",
      "facility_name_Revesby Car Park                           6.907e-05   6.37e-14   1.08e+09      0.000    6.91e-05    6.91e-05\n",
      "facility_name_Schofields Car Park                        3.072e-05   4.96e-14   6.19e+08      0.000    3.07e-05    3.07e-05\n",
      "facility_name_St Marys Car Park                          2.777e-05   6.26e-14   4.43e+08      0.000    2.78e-05    2.78e-05\n",
      "facility_name_Sutherland East Parade Car Park           -2.288e-05   5.87e-14   -3.9e+08      0.000   -2.29e-05   -2.29e-05\n",
      "facility_name_Tallawong P1 Car Park                     -6.418e-05    6.8e-14  -9.43e+08      0.000   -6.42e-05   -6.42e-05\n",
      "facility_name_Tallawong P2 Car Park                     -9.439e-06   4.98e-14  -1.89e+08      0.000   -9.44e-06   -9.44e-06\n",
      "facility_name_Tallawong P3 Car Park                     -1.895e-05   6.92e-14  -2.74e+08      0.000   -1.89e-05   -1.89e-05\n",
      "facility_name_Warriewood Car Park                       -4.402e-05   9.23e-14  -4.77e+08      0.000    -4.4e-05    -4.4e-05\n",
      "facility_name_Warwick Farm Car Park                      6.514e-05   5.47e-14   1.19e+09      0.000    6.51e-05    6.51e-05\n",
      "facility_name_West Ryde Car Park                        -5.927e-05   6.98e-14  -8.49e+08      0.000   -5.93e-05   -5.93e-05\n",
      "day_of_week_Friday                                       5.646e-06   2.32e-14   2.44e+08      0.000    5.65e-06    5.65e-06\n",
      "day_of_week_Monday                                        5.42e-06   3.12e-14   1.74e+08      0.000    5.42e-06    5.42e-06\n",
      "day_of_week_Saturday                                     5.646e-06   2.85e-14   1.98e+08      0.000    5.65e-06    5.65e-06\n",
      "day_of_week_Sunday                                       5.646e-06   2.96e-14   1.91e+08      0.000    5.65e-06    5.65e-06\n",
      "day_of_week_Thursday                                      5.42e-06   2.36e-14    2.3e+08      0.000    5.42e-06    5.42e-06\n",
      "day_of_week_Tuesday                                       5.42e-06   2.32e-14   2.33e+08      0.000    5.42e-06    5.42e-06\n",
      "day_of_week_Wednesday                                     5.42e-06   2.27e-14   2.39e+08      0.000    5.42e-06    5.42e-06\n",
      "date_2023-12-01                                          1.129e-06   5.34e-14   2.12e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-02                                          1.129e-06   7.06e-14    1.6e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-03                                          1.129e-06   8.48e-14   1.33e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-04                                          1.355e-06   5.54e-14   2.45e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-05                                          1.355e-06   4.87e-14   2.78e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-06                                          1.355e-06   4.72e-14   2.87e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-07                                          1.355e-06   4.69e-14   2.89e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-08                                          1.129e-06   5.03e-14   2.25e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-09                                          1.129e-06    7.5e-14   1.51e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-10                                          1.129e-06   7.35e-14   1.54e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-11                                          1.355e-06   5.58e-14   2.43e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-12                                          1.355e-06   4.63e-14   2.93e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-13                                          1.355e-06   4.63e-14   2.93e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-14                                          1.355e-06   4.74e-14   2.86e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-15                                          1.129e-06   5.36e-14   2.11e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-16                                          1.129e-06   7.41e-14   1.52e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-17                                          1.129e-06    7.5e-14   1.51e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-18                                          1.355e-06   5.83e-14   2.32e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-19                                          1.355e-06   4.75e-14   2.85e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-20                                          1.355e-06    4.9e-14   2.77e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-21                                          1.355e-06   5.01e-14    2.7e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-22                                          1.129e-06   5.91e-14   1.91e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-23                                          1.129e-06   6.84e-14   1.65e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-24                                          1.129e-06   8.06e-14    1.4e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-25                                          1.355e-06   1.14e-13   1.19e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-26                                          1.355e-06   6.62e-14   2.05e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-27                                          1.355e-06    6.2e-14   2.19e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-28                                          1.355e-06   6.91e-14   1.96e+07      0.000    1.36e-06    1.36e-06\n",
      "date_2023-12-29                                          1.129e-06   7.46e-14   1.51e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-30                                          1.129e-06   8.16e-14   1.38e+07      0.000    1.13e-06    1.13e-06\n",
      "date_2023-12-31                                          1.129e-06   6.78e-14   1.67e+07      0.000    1.13e-06    1.13e-06\n",
      "==============================================================================\n",
      "Omnibus:                     1044.587   Durbin-Watson:                   1.392\n",
      "Prob(Omnibus):                  0.000   Jarque-Bera (JB):             5172.070\n",
      "Skew:                          -1.336   Prob(JB):                         0.00\n",
      "Kurtosis:                       8.302   Cond. No.                     1.19e+16\n",
      "==============================================================================\n",
      "\n",
      "Notes:\n",
      "[1] Standard Errors assume that the covariance matrix of the errors is correctly specified.\n",
      "[2] The smallest eigenvalue is 2.04e-23. This might indicate that there are\n",
      "strong multicollinearity problems or that the design matrix is singular.\n"
     ]
    }
   ],
   "source": [
    "print(iterated_results.summary())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5.379312130327341e-13"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.metrics import mean_absolute_error\n",
    "\n",
    "y_pred = iterated_results.predict(sm.add_constant(X_train))\n",
    "mean_absolute_error(y_train, y_pred)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "project-env",
   "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": "0.0.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}