{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd \n",
    "from datetime import datetime \n",
    "from datetime import date\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from keras.models import Sequential\n",
    "from keras.layers import LSTM, Dense\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.preprocessing import MinMaxScaler,StandardScaler\n",
    "from keras.callbacks import ModelCheckpoint\n",
    "import tensorflow as tf\n",
    "import joblib\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged = pd.read_csv(r'../data/long_merge.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "zones = [72, 71, 63, 62, 60, 59, 58,57, 50, 49, 44, 43, 35, 34, 33, 32, 31, 30, 29, 28, ]\n",
    "rtus = [2]\n",
    "cols = []\n",
    "\n",
    "for zone in zones:\n",
    "        for column in merged.columns:\n",
    "            if f\"zone_0{zone}\" in column and 'co2' not in column and \"hw_valve\" not in column and \"cooling_sp\" not in column and \"heating_sp\" not in column:\n",
    "                cols.append(column)\n",
    "\n",
    "for zone in zones:\n",
    "        for column in merged.columns:\n",
    "              if f\"zone_0{zone}\" in column: \n",
    "                if \"cooling_sp\" in column or \"heating_sp\" in column:\n",
    "                  cols.append(column)\n",
    "# for rtu in rtus:\n",
    "#     for column in merged.columns:\n",
    "#         if f\"rtu_00{rtu}_fltrd_sa\" in column:\n",
    "#                 cols.append(column)\n",
    "cols =['date'] + cols + ['air_temp_set_1',\n",
    " 'air_temp_set_2',\n",
    " 'dew_point_temperature_set_1d',\n",
    " 'relative_humidity_set_1',\n",
    " 'solar_radiation_set_1']\n",
    "input_dataset = merged[cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\arbal\\AppData\\Local\\Temp\\ipykernel_18672\\1855433847.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  input_dataset['date'] = pd.to_datetime(input_dataset['date'], format = \"%Y-%m-%d %H:%M:%S\")\n"
     ]
    }
   ],
   "source": [
    "input_dataset['date'] = pd.to_datetime(input_dataset['date'], format = \"%Y-%m-%d %H:%M:%S\")\n",
    "df_filtered = input_dataset[ (input_dataset.date.dt.date >date(2019, 3, 1)) & (input_dataset.date.dt.date< date(2021, 1, 1))]\n",
    "\n",
    "if df_filtered.isna().any().any():\n",
    "    print(\"There are NA values in the DataFrame columns.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>zone_072_temp</th>\n",
       "      <th>zone_072_fan_spd</th>\n",
       "      <th>zone_071_temp</th>\n",
       "      <th>zone_071_fan_spd</th>\n",
       "      <th>zone_063_temp</th>\n",
       "      <th>zone_063_fan_spd</th>\n",
       "      <th>zone_062_temp</th>\n",
       "      <th>zone_062_fan_spd</th>\n",
       "      <th>zone_059_temp</th>\n",
       "      <th>...</th>\n",
       "      <th>zone_035_heating_sp</th>\n",
       "      <th>zone_032_cooling_sp</th>\n",
       "      <th>zone_032_heating_sp</th>\n",
       "      <th>zone_030_cooling_sp</th>\n",
       "      <th>zone_030_heating_sp</th>\n",
       "      <th>air_temp_set_1</th>\n",
       "      <th>air_temp_set_2</th>\n",
       "      <th>dew_point_temperature_set_1d</th>\n",
       "      <th>relative_humidity_set_1</th>\n",
       "      <th>solar_radiation_set_1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>511205</th>\n",
       "      <td>2019-03-02 00:00:00</td>\n",
       "      <td>71.2</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.5</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.9</td>\n",
       "      <td>55.0</td>\n",
       "      <td>71.9</td>\n",
       "      <td>...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>11.590</td>\n",
       "      <td>11.130</td>\n",
       "      <td>3.00</td>\n",
       "      <td>55.87</td>\n",
       "      <td>120.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511206</th>\n",
       "      <td>2019-03-02 00:01:00</td>\n",
       "      <td>71.2</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.5</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.9</td>\n",
       "      <td>55.0</td>\n",
       "      <td>71.9</td>\n",
       "      <td>...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>11.590</td>\n",
       "      <td>11.130</td>\n",
       "      <td>3.00</td>\n",
       "      <td>55.87</td>\n",
       "      <td>120.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511207</th>\n",
       "      <td>2019-03-02 00:02:00</td>\n",
       "      <td>71.2</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.5</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.6</td>\n",
       "      <td>55.0</td>\n",
       "      <td>71.9</td>\n",
       "      <td>...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>11.590</td>\n",
       "      <td>11.130</td>\n",
       "      <td>3.00</td>\n",
       "      <td>55.87</td>\n",
       "      <td>120.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511208</th>\n",
       "      <td>2019-03-02 00:03:00</td>\n",
       "      <td>71.2</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.5</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.9</td>\n",
       "      <td>55.0</td>\n",
       "      <td>71.9</td>\n",
       "      <td>...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>11.590</td>\n",
       "      <td>11.130</td>\n",
       "      <td>3.00</td>\n",
       "      <td>55.87</td>\n",
       "      <td>120.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511209</th>\n",
       "      <td>2019-03-02 00:04:00</td>\n",
       "      <td>71.2</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.4</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>72.9</td>\n",
       "      <td>55.0</td>\n",
       "      <td>71.9</td>\n",
       "      <td>...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>11.590</td>\n",
       "      <td>11.130</td>\n",
       "      <td>3.00</td>\n",
       "      <td>55.87</td>\n",
       "      <td>120.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>2072148</th>\n",
       "      <td>2020-12-31 23:57:00</td>\n",
       "      <td>69.5</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.2</td>\n",
       "      <td>20.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>67.6</td>\n",
       "      <td>40.0</td>\n",
       "      <td>67.5</td>\n",
       "      <td>...</td>\n",
       "      <td>68.0</td>\n",
       "      <td>72.714138</td>\n",
       "      <td>71.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>13.994</td>\n",
       "      <td>13.528</td>\n",
       "      <td>4.11</td>\n",
       "      <td>51.61</td>\n",
       "      <td>188.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2072149</th>\n",
       "      <td>2020-12-31 23:58:00</td>\n",
       "      <td>69.5</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>67.6</td>\n",
       "      <td>40.0</td>\n",
       "      <td>67.5</td>\n",
       "      <td>...</td>\n",
       "      <td>68.0</td>\n",
       "      <td>72.714138</td>\n",
       "      <td>71.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>13.994</td>\n",
       "      <td>13.528</td>\n",
       "      <td>4.11</td>\n",
       "      <td>51.61</td>\n",
       "      <td>188.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2072150</th>\n",
       "      <td>2020-12-31 23:58:00</td>\n",
       "      <td>69.5</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>67.6</td>\n",
       "      <td>40.0</td>\n",
       "      <td>67.5</td>\n",
       "      <td>...</td>\n",
       "      <td>68.0</td>\n",
       "      <td>72.714138</td>\n",
       "      <td>71.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>13.994</td>\n",
       "      <td>13.528</td>\n",
       "      <td>4.11</td>\n",
       "      <td>51.61</td>\n",
       "      <td>188.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2072151</th>\n",
       "      <td>2020-12-31 23:59:00</td>\n",
       "      <td>69.5</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.5</td>\n",
       "      <td>20.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>67.6</td>\n",
       "      <td>40.0</td>\n",
       "      <td>67.5</td>\n",
       "      <td>...</td>\n",
       "      <td>68.0</td>\n",
       "      <td>72.714138</td>\n",
       "      <td>71.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>13.994</td>\n",
       "      <td>13.528</td>\n",
       "      <td>4.11</td>\n",
       "      <td>51.61</td>\n",
       "      <td>188.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2072152</th>\n",
       "      <td>2020-12-31 23:59:00</td>\n",
       "      <td>69.5</td>\n",
       "      <td>40.0</td>\n",
       "      <td>71.5</td>\n",
       "      <td>20.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>67.6</td>\n",
       "      <td>40.0</td>\n",
       "      <td>67.5</td>\n",
       "      <td>...</td>\n",
       "      <td>68.0</td>\n",
       "      <td>72.714138</td>\n",
       "      <td>71.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>13.994</td>\n",
       "      <td>13.528</td>\n",
       "      <td>4.11</td>\n",
       "      <td>51.61</td>\n",
       "      <td>188.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1560948 rows × 56 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       date  zone_072_temp  zone_072_fan_spd  zone_071_temp  \\\n",
       "511205  2019-03-02 00:00:00           71.2              40.0           71.5   \n",
       "511206  2019-03-02 00:01:00           71.2              40.0           71.5   \n",
       "511207  2019-03-02 00:02:00           71.2              40.0           71.5   \n",
       "511208  2019-03-02 00:03:00           71.2              40.0           71.5   \n",
       "511209  2019-03-02 00:04:00           71.2              40.0           71.4   \n",
       "...                     ...            ...               ...            ...   \n",
       "2072148 2020-12-31 23:57:00           69.5              40.0           71.2   \n",
       "2072149 2020-12-31 23:58:00           69.5              40.0           71.3   \n",
       "2072150 2020-12-31 23:58:00           69.5              40.0           71.3   \n",
       "2072151 2020-12-31 23:59:00           69.5              40.0           71.5   \n",
       "2072152 2020-12-31 23:59:00           69.5              40.0           71.5   \n",
       "\n",
       "         zone_071_fan_spd  zone_063_temp  zone_063_fan_spd  zone_062_temp  \\\n",
       "511205               20.0           72.3              20.0           72.9   \n",
       "511206               20.0           72.3              20.0           72.9   \n",
       "511207               20.0           72.3              20.0           72.6   \n",
       "511208               20.0           72.3              20.0           72.9   \n",
       "511209               20.0           72.3              20.0           72.9   \n",
       "...                   ...            ...               ...            ...   \n",
       "2072148              20.0           68.0              20.0           67.6   \n",
       "2072149              20.0           68.0              20.0           67.6   \n",
       "2072150              20.0           68.0              20.0           67.6   \n",
       "2072151              20.0           68.0              20.0           67.6   \n",
       "2072152              20.0           68.0              20.0           67.6   \n",
       "\n",
       "         zone_062_fan_spd  zone_059_temp  ...  zone_035_heating_sp  \\\n",
       "511205               55.0           71.9  ...                 70.0   \n",
       "511206               55.0           71.9  ...                 70.0   \n",
       "511207               55.0           71.9  ...                 70.0   \n",
       "511208               55.0           71.9  ...                 70.0   \n",
       "511209               55.0           71.9  ...                 70.0   \n",
       "...                   ...            ...  ...                  ...   \n",
       "2072148              40.0           67.5  ...                 68.0   \n",
       "2072149              40.0           67.5  ...                 68.0   \n",
       "2072150              40.0           67.5  ...                 68.0   \n",
       "2072151              40.0           67.5  ...                 68.0   \n",
       "2072152              40.0           67.5  ...                 68.0   \n",
       "\n",
       "         zone_032_cooling_sp  zone_032_heating_sp  zone_030_cooling_sp  \\\n",
       "511205             74.000000                 68.0                 73.0   \n",
       "511206             74.000000                 68.0                 73.0   \n",
       "511207             74.000000                 68.0                 73.0   \n",
       "511208             74.000000                 68.0                 73.0   \n",
       "511209             74.000000                 68.0                 73.0   \n",
       "...                      ...                  ...                  ...   \n",
       "2072148            72.714138                 71.0                 71.0   \n",
       "2072149            72.714138                 71.0                 71.0   \n",
       "2072150            72.714138                 71.0                 71.0   \n",
       "2072151            72.714138                 71.0                 71.0   \n",
       "2072152            72.714138                 71.0                 71.0   \n",
       "\n",
       "         zone_030_heating_sp  air_temp_set_1  air_temp_set_2  \\\n",
       "511205                  67.0          11.590          11.130   \n",
       "511206                  67.0          11.590          11.130   \n",
       "511207                  67.0          11.590          11.130   \n",
       "511208                  67.0          11.590          11.130   \n",
       "511209                  67.0          11.590          11.130   \n",
       "...                      ...             ...             ...   \n",
       "2072148                 70.0          13.994          13.528   \n",
       "2072149                 70.0          13.994          13.528   \n",
       "2072150                 70.0          13.994          13.528   \n",
       "2072151                 70.0          13.994          13.528   \n",
       "2072152                 70.0          13.994          13.528   \n",
       "\n",
       "         dew_point_temperature_set_1d  relative_humidity_set_1  \\\n",
       "511205                           3.00                    55.87   \n",
       "511206                           3.00                    55.87   \n",
       "511207                           3.00                    55.87   \n",
       "511208                           3.00                    55.87   \n",
       "511209                           3.00                    55.87   \n",
       "...                               ...                      ...   \n",
       "2072148                          4.11                    51.61   \n",
       "2072149                          4.11                    51.61   \n",
       "2072150                          4.11                    51.61   \n",
       "2072151                          4.11                    51.61   \n",
       "2072152                          4.11                    51.61   \n",
       "\n",
       "         solar_radiation_set_1  \n",
       "511205                   120.3  \n",
       "511206                   120.3  \n",
       "511207                   120.3  \n",
       "511208                   120.3  \n",
       "511209                   120.3  \n",
       "...                        ...  \n",
       "2072148                  188.8  \n",
       "2072149                  188.8  \n",
       "2072150                  188.8  \n",
       "2072151                  188.8  \n",
       "2072152                  188.8  \n",
       "\n",
       "[1560948 rows x 56 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_filtered"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "testdataset_df = df_filtered[(df_filtered.date.dt.date >date(2020, 3, 1)) & (df_filtered.date.dt.date <date(2020,7, 1))]\n",
    "testdataset_df.set_index('date', inplace=True)\n",
    "# traindataset_df = df_filtered[ (df_filtered.date.dt.date >date(2019, 11, 8))]\n",
    "\n",
    "traindataset_df = df_filtered[(df_filtered.date.dt.date >date(2019, 3, 1)) & (df_filtered.date.dt.date <date(2020, 3, 1)) | (df_filtered.date.dt.date >date(2020, 7, 1)) & (df_filtered.date.dt.date <date(2020, 12, 1))]\n",
    "testdataset = testdataset_df.drop(columns=[\"date\"]).values\n",
    "traindataset = traindataset_df.drop(columns=[\"date\"]).values\n",
    "\n",
    "columns_with_na = traindataset_df.columns[traindataset_df.isna().any()].tolist()\n",
    "columns_with_na"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['date', 'zone_072_temp', 'zone_072_fan_spd', 'zone_071_temp',\n",
       "       'zone_071_fan_spd', 'zone_063_temp', 'zone_063_fan_spd',\n",
       "       'zone_062_temp', 'zone_062_fan_spd', 'zone_059_temp',\n",
       "       'zone_059_fan_spd', 'zone_058_temp', 'zone_058_fan_spd',\n",
       "       'zone_057_temp', 'zone_057_fan_spd', 'zone_049_temp',\n",
       "       'zone_049_fan_spd', 'zone_044_temp', 'zone_044_fan_spd',\n",
       "       'zone_043_temp', 'zone_043_fan_spd', 'zone_035_temp',\n",
       "       'zone_035_fan_spd', 'zone_033_temp', 'zone_033_fan_spd',\n",
       "       'zone_032_temp', 'zone_032_fan_spd', 'zone_030_temp',\n",
       "       'zone_030_fan_spd', 'zone_028_temp', 'zone_028_fan_spd'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "traindataset_df.columns[0:31]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1073512, 391818)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(traindataset), len(testdataset)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['scaler_vav_2.pkl']"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "traindataset = traindataset.astype('float32')\n",
    "testdataset = testdataset.astype('float32')\n",
    "\n",
    "scaler = StandardScaler()\n",
    "traindataset = scaler.fit_transform(traindataset)\n",
    "testdataset = scaler.transform(testdataset)\n",
    "\n",
    "joblib.dump(scaler, 'scaler_vav_2.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [],
   "source": [
    "train,test = traindataset,testdataset\n",
    "\n",
    "def create_dataset(dataset,time_step):\n",
    "    x = []\n",
    "    Y = []\n",
    "    for i in range(len(dataset) - time_step - 1):\n",
    "        x.append(dataset[i:(i+time_step),:])\n",
    "        Y.append(dataset[i+time_step,0:31])\n",
    "    x= np.array(x)\n",
    "    Y = np.array(Y)\n",
    "    return x,Y\n",
    "time_step = 30\n",
    "X_train, y_train = create_dataset(train, time_step)\n",
    "X_test, y_test = create_dataset(test, time_step)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((1073481, 30, 55), (1073481, 31))"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X_train.shape, y_train.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "d:\\anaconda3\\envs\\smartbuilding\\Lib\\site-packages\\keras\\src\\layers\\rnn\\rnn.py:204: UserWarning: Do not pass an `input_shape`/`input_dim` argument to a layer. When using Sequential models, prefer using an `Input(shape)` object as the first layer in the model instead.\n",
      "  super().__init__(**kwargs)\n"
     ]
    }
   ],
   "source": [
    "\n",
    "model = Sequential()\n",
    "model.add(LSTM(units=50, return_sequences=True, input_shape=(X_train.shape[1], X_train.shape[2])))\n",
    "model.add(LSTM(units=50, return_sequences=True))\n",
    "model.add(LSTM(units=30))\n",
    "model.add(Dense(units=y_train.shape[1]))\n",
    "\n",
    "model.compile(optimizer='adam', loss='mean_squared_error')\n",
    "\n",
    "checkpoint_path = \"lstm_vav_02.keras\"\n",
    "checkpoint_callback = ModelCheckpoint(filepath=checkpoint_path, monitor='val_loss', verbose=1, save_best_only=True, mode='min')\n",
    "# model.fit(X_train, y_train, validation_data=(X_test, y_test), epochs=3, batch_size=128, verbose=1, callbacks=[checkpoint_callback])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "d:\\anaconda3\\envs\\smartbuilding\\Lib\\site-packages\\keras\\src\\saving\\saving_lib.py:415: UserWarning: Skipping variable loading for optimizer 'adam', because it has 2 variables whereas the saved optimizer has 24 variables. \n",
      "  saveable.load_own_variables(weights_store.get(inner_path))\n"
     ]
    }
   ],
   "source": [
    "model.load_weights(checkpoint_path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[1m12244/12244\u001b[0m \u001b[32m━━━━━━━━━━━━━━━━━━━━\u001b[0m\u001b[37m\u001b[0m \u001b[1m71s\u001b[0m 6ms/step\n"
     ]
    }
   ],
   "source": [
    "test_predict1 = model.predict(X_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{0: 'zone_072_temp',\n",
       " 1: 'zone_072_fan_spd',\n",
       " 2: 'zone_071_temp',\n",
       " 3: 'zone_071_fan_spd',\n",
       " 4: 'zone_063_temp',\n",
       " 5: 'zone_063_fan_spd',\n",
       " 6: 'zone_062_temp',\n",
       " 7: 'zone_062_fan_spd',\n",
       " 8: 'zone_059_temp',\n",
       " 9: 'zone_059_fan_spd',\n",
       " 10: 'zone_058_temp',\n",
       " 11: 'zone_058_fan_spd',\n",
       " 12: 'zone_057_temp',\n",
       " 13: 'zone_057_fan_spd',\n",
       " 14: 'zone_049_temp',\n",
       " 15: 'zone_049_fan_spd',\n",
       " 16: 'zone_044_temp',\n",
       " 17: 'zone_044_fan_spd',\n",
       " 18: 'zone_043_temp',\n",
       " 19: 'zone_043_fan_spd',\n",
       " 20: 'zone_035_temp',\n",
       " 21: 'zone_035_fan_spd',\n",
       " 22: 'zone_033_temp',\n",
       " 23: 'zone_033_fan_spd',\n",
       " 24: 'zone_032_temp',\n",
       " 25: 'zone_032_fan_spd',\n",
       " 26: 'zone_030_temp',\n",
       " 27: 'zone_030_fan_spd',\n",
       " 28: 'zone_028_temp',\n",
       " 29: 'zone_028_fan_spd',\n",
       " 30: 'zone_071_cooling_sp',\n",
       " 31: 'zone_071_heating_sp',\n",
       " 32: 'zone_063_cooling_sp',\n",
       " 33: 'zone_063_heating_sp',\n",
       " 34: 'zone_062_cooling_sp',\n",
       " 35: 'zone_062_heating_sp',\n",
       " 36: 'zone_059_cooling_sp',\n",
       " 37: 'zone_059_heating_sp',\n",
       " 38: 'zone_057_cooling_sp',\n",
       " 39: 'zone_057_heating_sp',\n",
       " 40: 'zone_049_cooling_sp',\n",
       " 41: 'zone_049_heating_sp',\n",
       " 42: 'zone_043_cooling_sp',\n",
       " 43: 'zone_043_heating_sp',\n",
       " 44: 'zone_035_cooling_sp',\n",
       " 45: 'zone_035_heating_sp',\n",
       " 46: 'zone_032_cooling_sp',\n",
       " 47: 'zone_032_heating_sp',\n",
       " 48: 'zone_030_cooling_sp',\n",
       " 49: 'zone_030_heating_sp',\n",
       " 50: 'air_temp_set_1',\n",
       " 51: 'air_temp_set_2',\n",
       " 52: 'dew_point_temperature_set_1d',\n",
       " 53: 'relative_humidity_set_1',\n",
       " 54: 'solar_radiation_set_1'}"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "idx_2_col = {}\n",
    "for i, col in enumerate(traindataset_df.columns[1:]):\n",
    "    idx_2_col[i] = col\n",
    "\n",
    "idx_2_col"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(391787, 31)"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_predict1.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_predict1_unscaled = test_predict1*scaler.scale_[0:31] + scaler.mean_[0:31]\n",
    "y_test_unscaled = y_test*scaler.scale_[0:31] + scaler.mean_[0:31]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "d:\\anaconda3\\envs\\smartbuilding\\Lib\\site-packages\\pandas\\core\\indexes\\base.py:7588: FutureWarning: Dtype inference on a pandas object (Series, Index, ExtensionArray) is deprecated. The Index constructor will keep the original dtype in the future. Call `infer_objects` on the result to get the old behavior.\n",
      "  return Index(sequences[0], name=names)\n",
      "d:\\anaconda3\\envs\\smartbuilding\\Lib\\site-packages\\pandas\\core\\indexes\\base.py:7588: FutureWarning: Dtype inference on a pandas object (Series, Index, ExtensionArray) is deprecated. The Index constructor will keep the original dtype in the future. Call `infer_objects` on the result to get the old behavior.\n",
      "  return Index(sequences[0], name=names)\n"
     ]
    }
   ],
   "source": [
    "%matplotlib qt\n",
    "var = 0\n",
    "\n",
    "df = pd.DataFrame([testdataset_df.index[31:],test_predict1_unscaled[:,var], y_test_unscaled[:,var]] ).T\n",
    "fig, ax = plt.subplots(figsize=(20,15), dpi = 600)\n",
    "df.plot(x = 0, y=1, ax = ax, label = 'Predicted')\n",
    "df.plot(x = 0, y=2, ax = ax, label = 'Actual')\n",
    "\n",
    "anomalies = df.where(df[1]-df[2]>0.38)[0]\n",
    "df['anomalies'] = anomalies\n",
    "\n",
    "df_new = df.dropna()\n",
    "\n",
    "df_new.plot.scatter(x='anomalies', y=1,  c='r', ax = ax, label = 'Anomalies')\n",
    "\n",
    "# ax.scatter(anomalies,test_predict1[anomalies,var], color='black',marker =\"o\",s=100 )\n",
    "\n",
    "\n",
    "ax.set_title('Testing Data - Predicted vs Actual [Zone 72 Temperature]')\n",
    "ax.set_xlabel('Time')\n",
    "ax.set_ylabel('Value')\n",
    "ax.legend()\n",
    "fig.tight_layout()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[1m33547/33547\u001b[0m \u001b[32m━━━━━━━━━━━━━━━━━━━━\u001b[0m\u001b[37m\u001b[0m \u001b[1m308s\u001b[0m 9ms/step\n"
     ]
    }
   ],
   "source": [
    "%matplotlib qt\n",
    "test_predict2 = model.predict(X_train)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [],
   "source": [
    "plt.figure()\n",
    "var = 0\n",
    "plt.plot(y_train[:,var], label='Original Training Data', color='blue')\n",
    "plt.plot(test_predict2[:,var], label='Predicted Training Data', color='red',alpha=0.8)\n",
    "anomalies = np.where(abs(test_predict2[:,var] - y_train[:,var]) > 0.38)\n",
    "plt.scatter(anomalies,test_predict2[anomalies,var], color='black',marker =\"o\",s=100 )\n",
    "\n",
    "\n",
    "plt.title('Training Data - Predicted vs Actual')\n",
    "plt.xlabel('Time')\n",
    "plt.ylabel('Value')\n",
    "plt.legend()\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.mixture import GaussianMixture\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "from sklearn.decomposition import PCA\n",
    "\n",
    "\n",
    "# Generating random data for demonstration\n",
    "np.random.seed(0)\n",
    "X =  test_predict1 - y_test\n",
    "\n",
    "\n",
    "pca = PCA(n_components=2)\n",
    "X = pca.fit_transform(X)\n",
    "\n",
    "\n",
    "# Creating the GMM instance with desired number of clusters\n",
    "gmm = GaussianMixture(n_components=2)\n",
    "\n",
    "# Fitting the model to the data\n",
    "gmm.fit(X)\n",
    "\n",
    "# Getting the cluster labels\n",
    "labels = gmm.predict(X)\n",
    "\n",
    "# Plotting the data points with colors representing different clusters\n",
    "plt.scatter(X[:, 0], X[:, 1], c=labels, cmap='viridis', alpha=0.5)\n",
    "plt.title('GMM Clustering')\n",
    "plt.xlabel('Feature 1')\n",
    "plt.ylabel('Feature 2')\n",
    "plt.show()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.cluster import KMeans\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "from sklearn.decomposition import PCA\n",
    "\n",
    "# Generating random data for demonstration\n",
    "np.random.seed(0)\n",
    "X = (test_predict1 - y_test)\n",
    "\n",
    "k = 2\n",
    "\n",
    "pca = PCA(n_components=2)\n",
    "X = pca.fit_transform(X)\n",
    "\n",
    "kmeans = KMeans(n_clusters=k)\n",
    "\n",
    "kmeans.fit(X)\n",
    "\n",
    "\n",
    "\n",
    "# Getting the cluster centers and labels\n",
    "centroids = kmeans.cluster_centers_\n",
    "# centroids = pca.transform(centroids)\n",
    "labels = kmeans.labels_\n",
    "\n",
    "# Plotting the data points and cluster centers\n",
    "plt.scatter(X[:, 0], X[:, 1], c=labels, cmap='viridis', alpha=0.5)\n",
    "plt.scatter(centroids[:, 0], centroids[:, 1], marker='x', c='red', s=200, linewidths=2)\n",
    "plt.text(centroids[0,0]+0.2, centroids[0,1]+0.3, 'Normal', fontsize=12, color='red')\n",
    "plt.text(centroids[1,0]+0.5, centroids[1,1], 'Anomaly', fontsize=12, color='red')\n",
    "plt.title('KMeans Clustering')\n",
    "plt.xlabel('Feature 1')\n",
    "plt.ylabel('Feature 2')\n",
    "plt.tight_layout()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "k = 60\n",
    "X= test_predict1 - y_test\n",
    "processed_data = []\n",
    "feat_df = pd.DataFrame(columns=[\"mean\",\"std\",])\n",
    "for i in range(0,len(X), 60):\n",
    "    mean = X[i:i+k].mean(axis = 0)\n",
    "    std = X[i:i+k].std(axis = 0)\n",
    "    max = X[i:i+k].max(axis = 0)\n",
    "    min = X[i:i+k].min(axis = 0)\n",
    "    iqr = np.percentile(X[i:i+k], 75, axis=0) - np.percentile(X[i:i+k], 25,axis=0)\n",
    "    data = np.concatenate([mean, std, max, min, iqr])\n",
    "    processed_data.append([data])\n",
    "processed_data = np.concatenate(processed_data,axis=0) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "X = processed_data\n",
    "\n",
    "kmeans = KMeans(n_clusters=2, algorithm='elkan', max_iter=1000, n_init = 5)\n",
    "\n",
    "kmeans.fit(X)\n",
    "\n",
    "pca = PCA(n_components=2)\n",
    "X = pca.fit_transform(X)\n",
    "\n",
    "\n",
    "# Getting the cluster centers and labels\n",
    "centroids = kmeans.cluster_centers_\n",
    "centroids = pca.transform(centroids)\n",
    "labels = kmeans.labels_\n",
    "\n",
    "# Plotting the data points and cluster centers\n",
    "plt.scatter(X[:, 0], X[:, 1], c=labels, cmap='viridis', alpha=0.5)\n",
    "plt.scatter(centroids[:, 0], centroids[:, 1], marker='x', c='red', s=200, linewidths=2)\n",
    "plt.title('KMeans Clustering')\n",
    "plt.xlabel('Feature 1')\n",
    "plt.ylabel('Feature 2')\n",
    "plt.show()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.mixture import GaussianMixture\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "from sklearn.decomposition import PCA\n",
    "\n",
    "# Generating random data for demonstration\n",
    "np.random.seed(0)\n",
    "X = processed_data\n",
    "\n",
    "# Creating the GMM instance with desired number of clusters\n",
    "gmm = GaussianMixture(n_components=2, init_params='k-means++')\n",
    "\n",
    "# Fitting the model to the data\n",
    "gmm.fit(X)\n",
    "labels = gmm.predict(X)\n",
    "\n",
    "\n",
    "pca = PCA(n_components=2)\n",
    "X = pca.fit_transform(X)\n",
    "\n",
    "\n",
    "# Getting the cluster labels\n",
    "\n",
    "# Plotting the data points with colors representing different clusters\n",
    "plt.scatter(X[:, 0], X[:, 1], c=labels, cmap='viridis', alpha=0.5)\n",
    "plt.title('GMM Clustering')\n",
    "plt.xlabel('Feature 1')\n",
    "plt.ylabel('Feature 2')\n",
    "plt.show()\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.cluster import KMeans\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "# Generating random data for demonstration\n",
    "np.random.seed(0)\n",
    "X = test_predict1 - y_test \n",
    "\n",
    "kmeans = KMeans(n_clusters=2)\n",
    "\n",
    "kmeans.fit(X)\n",
    "\n",
    "\n",
    "pca = PCA(n_components=2)\n",
    "X = pca.fit_transform(X)\n",
    "\n",
    "\n",
    "\n",
    "# Getting the cluster centers and labels\n",
    "centroids = kmeans.cluster_centers_\n",
    "centroids = pca.transform(centroids)\n",
    "labels = kmeans.labels_\n",
    "\n",
    "# Plotting the data points and cluster centers\n",
    "plt.figure()\n",
    "plt.scatter(X[:, 0], X[:, 1], c=labels, cmap='viridis', alpha=0.5)\n",
    "plt.scatter(centroids[:, 0], centroids[:, 1], marker='x', c='red', s=200, linewidths=2)\n",
    "plt.text(centroids[0,0], centroids[0,1], 'Normal', fontsize=12, color='red')\n",
    "plt.text(centroids[1,0], centroids[1,1], 'Anomaly', fontsize=12, color='red')\n",
    "plt.title('KMeans Clustering')\n",
    "plt.xlabel('Feature 1')\n",
    "plt.ylabel('Feature 2')\n",
    "plt.show()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "329763"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(labels==0)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "tensorflow",
   "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.11.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}