another trial.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "41dfade4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "fd2dedaf",
   "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>Unnamed: 0</th>\n",
       "      <th>Date</th>\n",
       "      <th>Time</th>\n",
       "      <th>AEP_MW</th>\n",
       "      <th>COMED_MW</th>\n",
       "      <th>DAYTON_MW</th>\n",
       "      <th>DEOK_MW</th>\n",
       "      <th>DOM_MW</th>\n",
       "      <th>DUQ_MW</th>\n",
       "      <th>EKPC_MW</th>\n",
       "      <th>...</th>\n",
       "      <th>DAYTON</th>\n",
       "      <th>DEOK</th>\n",
       "      <th>DOM</th>\n",
       "      <th>DUQ</th>\n",
       "      <th>EKPC</th>\n",
       "      <th>FE</th>\n",
       "      <th>PJME</th>\n",
       "      <th>PJMW</th>\n",
       "      <th>PJME_MW</th>\n",
       "      <th>PJMW_MW</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>15128</td>\n",
       "      <td>11979</td>\n",
       "      <td>1930</td>\n",
       "      <td>3065</td>\n",
       "      <td>10239</td>\n",
       "      <td>1563</td>\n",
       "      <td>1861</td>\n",
       "      <td>...</td>\n",
       "      <td>1930</td>\n",
       "      <td>3065</td>\n",
       "      <td>10239</td>\n",
       "      <td>1563</td>\n",
       "      <td>1861</td>\n",
       "      <td>7459</td>\n",
       "      <td>30254</td>\n",
       "      <td>5840</td>\n",
       "      <td>30254</td>\n",
       "      <td>5840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>02:00:00</td>\n",
       "      <td>14886</td>\n",
       "      <td>11438</td>\n",
       "      <td>1884</td>\n",
       "      <td>2970</td>\n",
       "      <td>9964</td>\n",
       "      <td>1498</td>\n",
       "      <td>1835</td>\n",
       "      <td>...</td>\n",
       "      <td>1884</td>\n",
       "      <td>2970</td>\n",
       "      <td>9964</td>\n",
       "      <td>1498</td>\n",
       "      <td>1835</td>\n",
       "      <td>7241</td>\n",
       "      <td>29241</td>\n",
       "      <td>5710</td>\n",
       "      <td>29241</td>\n",
       "      <td>5710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>14831</td>\n",
       "      <td>11113</td>\n",
       "      <td>1845</td>\n",
       "      <td>2917</td>\n",
       "      <td>9921</td>\n",
       "      <td>1469</td>\n",
       "      <td>1841</td>\n",
       "      <td>...</td>\n",
       "      <td>1845</td>\n",
       "      <td>2917</td>\n",
       "      <td>9921</td>\n",
       "      <td>1469</td>\n",
       "      <td>1841</td>\n",
       "      <td>7115</td>\n",
       "      <td>28772</td>\n",
       "      <td>5617</td>\n",
       "      <td>28772</td>\n",
       "      <td>5617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>04:00:00</td>\n",
       "      <td>14873</td>\n",
       "      <td>10928</td>\n",
       "      <td>1843</td>\n",
       "      <td>2910</td>\n",
       "      <td>9981</td>\n",
       "      <td>1461</td>\n",
       "      <td>1872</td>\n",
       "      <td>...</td>\n",
       "      <td>1843</td>\n",
       "      <td>2910</td>\n",
       "      <td>9981</td>\n",
       "      <td>1461</td>\n",
       "      <td>1872</td>\n",
       "      <td>7073</td>\n",
       "      <td>28762</td>\n",
       "      <td>5661</td>\n",
       "      <td>28762</td>\n",
       "      <td>5661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>05:00:00</td>\n",
       "      <td>15001</td>\n",
       "      <td>10926</td>\n",
       "      <td>1875</td>\n",
       "      <td>2958</td>\n",
       "      <td>10290</td>\n",
       "      <td>1481</td>\n",
       "      <td>1934</td>\n",
       "      <td>...</td>\n",
       "      <td>1875</td>\n",
       "      <td>2958</td>\n",
       "      <td>10290</td>\n",
       "      <td>1481</td>\n",
       "      <td>1934</td>\n",
       "      <td>7156</td>\n",
       "      <td>29391</td>\n",
       "      <td>5732</td>\n",
       "      <td>29391</td>\n",
       "      <td>5732</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>51482</th>\n",
       "      <td>51482</td>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>20925</td>\n",
       "      <td>13809</td>\n",
       "      <td>2714</td>\n",
       "      <td>4393</td>\n",
       "      <td>18249</td>\n",
       "      <td>1968</td>\n",
       "      <td>2739</td>\n",
       "      <td>...</td>\n",
       "      <td>2714</td>\n",
       "      <td>4393</td>\n",
       "      <td>18249</td>\n",
       "      <td>1968</td>\n",
       "      <td>2739</td>\n",
       "      <td>9434</td>\n",
       "      <td>44343</td>\n",
       "      <td>8328</td>\n",
       "      <td>44343</td>\n",
       "      <td>8328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51483</th>\n",
       "      <td>51483</td>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>20:00:00</td>\n",
       "      <td>21089</td>\n",
       "      <td>13858</td>\n",
       "      <td>2732</td>\n",
       "      <td>4426</td>\n",
       "      <td>18418</td>\n",
       "      <td>1962</td>\n",
       "      <td>2866</td>\n",
       "      <td>...</td>\n",
       "      <td>2732</td>\n",
       "      <td>4426</td>\n",
       "      <td>18418</td>\n",
       "      <td>1962</td>\n",
       "      <td>2866</td>\n",
       "      <td>9378</td>\n",
       "      <td>44284</td>\n",
       "      <td>8401</td>\n",
       "      <td>44284</td>\n",
       "      <td>8401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51484</th>\n",
       "      <td>51484</td>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>20999</td>\n",
       "      <td>13758</td>\n",
       "      <td>2724</td>\n",
       "      <td>4419</td>\n",
       "      <td>18567</td>\n",
       "      <td>1940</td>\n",
       "      <td>2846</td>\n",
       "      <td>...</td>\n",
       "      <td>2724</td>\n",
       "      <td>4419</td>\n",
       "      <td>18567</td>\n",
       "      <td>1940</td>\n",
       "      <td>2846</td>\n",
       "      <td>9255</td>\n",
       "      <td>43751</td>\n",
       "      <td>8373</td>\n",
       "      <td>43751</td>\n",
       "      <td>8373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51485</th>\n",
       "      <td>51485</td>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>22:00:00</td>\n",
       "      <td>20820</td>\n",
       "      <td>13627</td>\n",
       "      <td>2664</td>\n",
       "      <td>4355</td>\n",
       "      <td>18307</td>\n",
       "      <td>1891</td>\n",
       "      <td>2883</td>\n",
       "      <td>...</td>\n",
       "      <td>2664</td>\n",
       "      <td>4355</td>\n",
       "      <td>18307</td>\n",
       "      <td>1891</td>\n",
       "      <td>2883</td>\n",
       "      <td>9044</td>\n",
       "      <td>42402</td>\n",
       "      <td>8238</td>\n",
       "      <td>42402</td>\n",
       "      <td>8238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51486</th>\n",
       "      <td>51486</td>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>23:00:00</td>\n",
       "      <td>20415</td>\n",
       "      <td>13336</td>\n",
       "      <td>2614</td>\n",
       "      <td>4224</td>\n",
       "      <td>17814</td>\n",
       "      <td>1820</td>\n",
       "      <td>2880</td>\n",
       "      <td>...</td>\n",
       "      <td>2614</td>\n",
       "      <td>4224</td>\n",
       "      <td>17814</td>\n",
       "      <td>1820</td>\n",
       "      <td>2880</td>\n",
       "      <td>8676</td>\n",
       "      <td>40164</td>\n",
       "      <td>7958</td>\n",
       "      <td>40164</td>\n",
       "      <td>7958</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>51487 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0        Date      Time  AEP_MW  COMED_MW  DAYTON_MW  DEOK_MW  \\\n",
       "0               0  12/31/2013  01:00:00   15128     11979       1930     3065   \n",
       "1               1  12/31/2013  02:00:00   14886     11438       1884     2970   \n",
       "2               2  12/31/2013  03:00:00   14831     11113       1845     2917   \n",
       "3               3  12/31/2013  04:00:00   14873     10928       1843     2910   \n",
       "4               4  12/31/2013  05:00:00   15001     10926       1875     2958   \n",
       "...           ...         ...       ...     ...       ...        ...      ...   \n",
       "51482       51482  01-01-2018  19:00:00   20925     13809       2714     4393   \n",
       "51483       51483  01-01-2018  20:00:00   21089     13858       2732     4426   \n",
       "51484       51484  01-01-2018  21:00:00   20999     13758       2724     4419   \n",
       "51485       51485  01-01-2018  22:00:00   20820     13627       2664     4355   \n",
       "51486       51486  01-01-2018  23:00:00   20415     13336       2614     4224   \n",
       "\n",
       "       DOM_MW  DUQ_MW  EKPC_MW  ...  DAYTON  DEOK    DOM   DUQ  EKPC    FE  \\\n",
       "0       10239    1563     1861  ...    1930  3065  10239  1563  1861  7459   \n",
       "1        9964    1498     1835  ...    1884  2970   9964  1498  1835  7241   \n",
       "2        9921    1469     1841  ...    1845  2917   9921  1469  1841  7115   \n",
       "3        9981    1461     1872  ...    1843  2910   9981  1461  1872  7073   \n",
       "4       10290    1481     1934  ...    1875  2958  10290  1481  1934  7156   \n",
       "...       ...     ...      ...  ...     ...   ...    ...   ...   ...   ...   \n",
       "51482   18249    1968     2739  ...    2714  4393  18249  1968  2739  9434   \n",
       "51483   18418    1962     2866  ...    2732  4426  18418  1962  2866  9378   \n",
       "51484   18567    1940     2846  ...    2724  4419  18567  1940  2846  9255   \n",
       "51485   18307    1891     2883  ...    2664  4355  18307  1891  2883  9044   \n",
       "51486   17814    1820     2880  ...    2614  4224  17814  1820  2880  8676   \n",
       "\n",
       "        PJME  PJMW  PJME_MW  PJMW_MW  \n",
       "0      30254  5840    30254     5840  \n",
       "1      29241  5710    29241     5710  \n",
       "2      28772  5617    28772     5617  \n",
       "3      28762  5661    28762     5661  \n",
       "4      29391  5732    29391     5732  \n",
       "...      ...   ...      ...      ...  \n",
       "51482  44343  8328    44343     8328  \n",
       "51483  44284  8401    44284     8401  \n",
       "51484  43751  8373    43751     8373  \n",
       "51485  42402  8238    42402     8238  \n",
       "51486  40164  7958    40164     7958  \n",
       "\n",
       "[51487 rows x 24 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"./finalmodel/finalDataSet.csv\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "4b397b90",
   "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>Time</th>\n",
       "      <th>AEP_MW</th>\n",
       "      <th>COMED_MW</th>\n",
       "      <th>DAYTON_MW</th>\n",
       "      <th>DEOK_MW</th>\n",
       "      <th>DOM_MW</th>\n",
       "      <th>DUQ_MW</th>\n",
       "      <th>EKPC_MW</th>\n",
       "      <th>FE_MW_x</th>\n",
       "      <th>...</th>\n",
       "      <th>DAYTON</th>\n",
       "      <th>DEOK</th>\n",
       "      <th>DOM</th>\n",
       "      <th>DUQ</th>\n",
       "      <th>EKPC</th>\n",
       "      <th>FE</th>\n",
       "      <th>PJME</th>\n",
       "      <th>PJMW</th>\n",
       "      <th>PJME_MW</th>\n",
       "      <th>PJMW_MW</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>01:00:00</td>\n",
       "      <td>15128</td>\n",
       "      <td>11979</td>\n",
       "      <td>1930</td>\n",
       "      <td>3065</td>\n",
       "      <td>10239</td>\n",
       "      <td>1563</td>\n",
       "      <td>1861</td>\n",
       "      <td>7459</td>\n",
       "      <td>...</td>\n",
       "      <td>1930</td>\n",
       "      <td>3065</td>\n",
       "      <td>10239</td>\n",
       "      <td>1563</td>\n",
       "      <td>1861</td>\n",
       "      <td>7459</td>\n",
       "      <td>30254</td>\n",
       "      <td>5840</td>\n",
       "      <td>30254</td>\n",
       "      <td>5840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>02:00:00</td>\n",
       "      <td>14886</td>\n",
       "      <td>11438</td>\n",
       "      <td>1884</td>\n",
       "      <td>2970</td>\n",
       "      <td>9964</td>\n",
       "      <td>1498</td>\n",
       "      <td>1835</td>\n",
       "      <td>7241</td>\n",
       "      <td>...</td>\n",
       "      <td>1884</td>\n",
       "      <td>2970</td>\n",
       "      <td>9964</td>\n",
       "      <td>1498</td>\n",
       "      <td>1835</td>\n",
       "      <td>7241</td>\n",
       "      <td>29241</td>\n",
       "      <td>5710</td>\n",
       "      <td>29241</td>\n",
       "      <td>5710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>03:00:00</td>\n",
       "      <td>14831</td>\n",
       "      <td>11113</td>\n",
       "      <td>1845</td>\n",
       "      <td>2917</td>\n",
       "      <td>9921</td>\n",
       "      <td>1469</td>\n",
       "      <td>1841</td>\n",
       "      <td>7115</td>\n",
       "      <td>...</td>\n",
       "      <td>1845</td>\n",
       "      <td>2917</td>\n",
       "      <td>9921</td>\n",
       "      <td>1469</td>\n",
       "      <td>1841</td>\n",
       "      <td>7115</td>\n",
       "      <td>28772</td>\n",
       "      <td>5617</td>\n",
       "      <td>28772</td>\n",
       "      <td>5617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>04:00:00</td>\n",
       "      <td>14873</td>\n",
       "      <td>10928</td>\n",
       "      <td>1843</td>\n",
       "      <td>2910</td>\n",
       "      <td>9981</td>\n",
       "      <td>1461</td>\n",
       "      <td>1872</td>\n",
       "      <td>7073</td>\n",
       "      <td>...</td>\n",
       "      <td>1843</td>\n",
       "      <td>2910</td>\n",
       "      <td>9981</td>\n",
       "      <td>1461</td>\n",
       "      <td>1872</td>\n",
       "      <td>7073</td>\n",
       "      <td>28762</td>\n",
       "      <td>5661</td>\n",
       "      <td>28762</td>\n",
       "      <td>5661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>05:00:00</td>\n",
       "      <td>15001</td>\n",
       "      <td>10926</td>\n",
       "      <td>1875</td>\n",
       "      <td>2958</td>\n",
       "      <td>10290</td>\n",
       "      <td>1481</td>\n",
       "      <td>1934</td>\n",
       "      <td>7156</td>\n",
       "      <td>...</td>\n",
       "      <td>1875</td>\n",
       "      <td>2958</td>\n",
       "      <td>10290</td>\n",
       "      <td>1481</td>\n",
       "      <td>1934</td>\n",
       "      <td>7156</td>\n",
       "      <td>29391</td>\n",
       "      <td>5732</td>\n",
       "      <td>29391</td>\n",
       "      <td>5732</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>51482</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>20925</td>\n",
       "      <td>13809</td>\n",
       "      <td>2714</td>\n",
       "      <td>4393</td>\n",
       "      <td>18249</td>\n",
       "      <td>1968</td>\n",
       "      <td>2739</td>\n",
       "      <td>9434</td>\n",
       "      <td>...</td>\n",
       "      <td>2714</td>\n",
       "      <td>4393</td>\n",
       "      <td>18249</td>\n",
       "      <td>1968</td>\n",
       "      <td>2739</td>\n",
       "      <td>9434</td>\n",
       "      <td>44343</td>\n",
       "      <td>8328</td>\n",
       "      <td>44343</td>\n",
       "      <td>8328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51483</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>20:00:00</td>\n",
       "      <td>21089</td>\n",
       "      <td>13858</td>\n",
       "      <td>2732</td>\n",
       "      <td>4426</td>\n",
       "      <td>18418</td>\n",
       "      <td>1962</td>\n",
       "      <td>2866</td>\n",
       "      <td>9378</td>\n",
       "      <td>...</td>\n",
       "      <td>2732</td>\n",
       "      <td>4426</td>\n",
       "      <td>18418</td>\n",
       "      <td>1962</td>\n",
       "      <td>2866</td>\n",
       "      <td>9378</td>\n",
       "      <td>44284</td>\n",
       "      <td>8401</td>\n",
       "      <td>44284</td>\n",
       "      <td>8401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51484</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>20999</td>\n",
       "      <td>13758</td>\n",
       "      <td>2724</td>\n",
       "      <td>4419</td>\n",
       "      <td>18567</td>\n",
       "      <td>1940</td>\n",
       "      <td>2846</td>\n",
       "      <td>9255</td>\n",
       "      <td>...</td>\n",
       "      <td>2724</td>\n",
       "      <td>4419</td>\n",
       "      <td>18567</td>\n",
       "      <td>1940</td>\n",
       "      <td>2846</td>\n",
       "      <td>9255</td>\n",
       "      <td>43751</td>\n",
       "      <td>8373</td>\n",
       "      <td>43751</td>\n",
       "      <td>8373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51485</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>22:00:00</td>\n",
       "      <td>20820</td>\n",
       "      <td>13627</td>\n",
       "      <td>2664</td>\n",
       "      <td>4355</td>\n",
       "      <td>18307</td>\n",
       "      <td>1891</td>\n",
       "      <td>2883</td>\n",
       "      <td>9044</td>\n",
       "      <td>...</td>\n",
       "      <td>2664</td>\n",
       "      <td>4355</td>\n",
       "      <td>18307</td>\n",
       "      <td>1891</td>\n",
       "      <td>2883</td>\n",
       "      <td>9044</td>\n",
       "      <td>42402</td>\n",
       "      <td>8238</td>\n",
       "      <td>42402</td>\n",
       "      <td>8238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51486</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>23:00:00</td>\n",
       "      <td>20415</td>\n",
       "      <td>13336</td>\n",
       "      <td>2614</td>\n",
       "      <td>4224</td>\n",
       "      <td>17814</td>\n",
       "      <td>1820</td>\n",
       "      <td>2880</td>\n",
       "      <td>8676</td>\n",
       "      <td>...</td>\n",
       "      <td>2614</td>\n",
       "      <td>4224</td>\n",
       "      <td>17814</td>\n",
       "      <td>1820</td>\n",
       "      <td>2880</td>\n",
       "      <td>8676</td>\n",
       "      <td>40164</td>\n",
       "      <td>7958</td>\n",
       "      <td>40164</td>\n",
       "      <td>7958</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>51487 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date      Time  AEP_MW  COMED_MW  DAYTON_MW  DEOK_MW  DOM_MW  \\\n",
       "0      12/31/2013  01:00:00   15128     11979       1930     3065   10239   \n",
       "1      12/31/2013  02:00:00   14886     11438       1884     2970    9964   \n",
       "2      12/31/2013  03:00:00   14831     11113       1845     2917    9921   \n",
       "3      12/31/2013  04:00:00   14873     10928       1843     2910    9981   \n",
       "4      12/31/2013  05:00:00   15001     10926       1875     2958   10290   \n",
       "...           ...       ...     ...       ...        ...      ...     ...   \n",
       "51482  01-01-2018  19:00:00   20925     13809       2714     4393   18249   \n",
       "51483  01-01-2018  20:00:00   21089     13858       2732     4426   18418   \n",
       "51484  01-01-2018  21:00:00   20999     13758       2724     4419   18567   \n",
       "51485  01-01-2018  22:00:00   20820     13627       2664     4355   18307   \n",
       "51486  01-01-2018  23:00:00   20415     13336       2614     4224   17814   \n",
       "\n",
       "       DUQ_MW  EKPC_MW  FE_MW_x  ...  DAYTON  DEOK    DOM   DUQ  EKPC    FE  \\\n",
       "0        1563     1861     7459  ...    1930  3065  10239  1563  1861  7459   \n",
       "1        1498     1835     7241  ...    1884  2970   9964  1498  1835  7241   \n",
       "2        1469     1841     7115  ...    1845  2917   9921  1469  1841  7115   \n",
       "3        1461     1872     7073  ...    1843  2910   9981  1461  1872  7073   \n",
       "4        1481     1934     7156  ...    1875  2958  10290  1481  1934  7156   \n",
       "...       ...      ...      ...  ...     ...   ...    ...   ...   ...   ...   \n",
       "51482    1968     2739     9434  ...    2714  4393  18249  1968  2739  9434   \n",
       "51483    1962     2866     9378  ...    2732  4426  18418  1962  2866  9378   \n",
       "51484    1940     2846     9255  ...    2724  4419  18567  1940  2846  9255   \n",
       "51485    1891     2883     9044  ...    2664  4355  18307  1891  2883  9044   \n",
       "51486    1820     2880     8676  ...    2614  4224  17814  1820  2880  8676   \n",
       "\n",
       "        PJME  PJMW  PJME_MW  PJMW_MW  \n",
       "0      30254  5840    30254     5840  \n",
       "1      29241  5710    29241     5710  \n",
       "2      28772  5617    28772     5617  \n",
       "3      28762  5661    28762     5661  \n",
       "4      29391  5732    29391     5732  \n",
       "...      ...   ...      ...      ...  \n",
       "51482  44343  8328    44343     8328  \n",
       "51483  44284  8401    44284     8401  \n",
       "51484  43751  8373    43751     8373  \n",
       "51485  42402  8238    42402     8238  \n",
       "51486  40164  7958    40164     7958  \n",
       "\n",
       "[51487 rows x 23 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(['Unnamed: 0'], inplace=True, axis=1)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "cd6604ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "'''df['Datetime'] = pd.to_datetime(df.Datetime)'''\n",
    "df['Time'] = df['Time'].astype('datetime64[ns]')\n",
    "# df = df.set_index('Date', append=False)\n",
    "# df = df.index.to_julian_date()\n",
    "# import datetime as dt\n",
    "# df['Time'] = pd.to_datetime(df['Time'])\n",
    "# df['Time']=df['Time'].map(dt.datetime.toordinal)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "883d6368",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date                 object\n",
       "Time         datetime64[ns]\n",
       "AEP_MW                int64\n",
       "COMED_MW              int64\n",
       "DAYTON_MW             int64\n",
       "DEOK_MW               int64\n",
       "DOM_MW                int64\n",
       "DUQ_MW                int64\n",
       "EKPC_MW               int64\n",
       "FE_MW_x               int64\n",
       "FE_MW_y               int64\n",
       "AEP                   int64\n",
       "COMED                 int64\n",
       "DAYTON                int64\n",
       "DEOK                  int64\n",
       "DOM                   int64\n",
       "DUQ                   int64\n",
       "EKPC                  int64\n",
       "FE                    int64\n",
       "PJME                  int64\n",
       "PJMW                  int64\n",
       "PJME_MW               int64\n",
       "PJMW_MW               int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "7e5c4e27",
   "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>AEP_MW</th>\n",
       "      <th>COMED_MW</th>\n",
       "      <th>DAYTON_MW</th>\n",
       "      <th>DEOK_MW</th>\n",
       "      <th>DOM_MW</th>\n",
       "      <th>DUQ_MW</th>\n",
       "      <th>EKPC_MW</th>\n",
       "      <th>FE_MW_x</th>\n",
       "      <th>FE_MW_y</th>\n",
       "      <th>AEP</th>\n",
       "      <th>...</th>\n",
       "      <th>DAYTON</th>\n",
       "      <th>DEOK</th>\n",
       "      <th>DOM</th>\n",
       "      <th>DUQ</th>\n",
       "      <th>EKPC</th>\n",
       "      <th>FE</th>\n",
       "      <th>PJME</th>\n",
       "      <th>PJMW</th>\n",
       "      <th>PJME_MW</th>\n",
       "      <th>PJMW_MW</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AEP_MW</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.893500</td>\n",
       "      <td>0.969545</td>\n",
       "      <td>0.915597</td>\n",
       "      <td>0.927763</td>\n",
       "      <td>0.925751</td>\n",
       "      <td>0.901961</td>\n",
       "      <td>0.955687</td>\n",
       "      <td>0.955687</td>\n",
       "      <td>0.999673</td>\n",
       "      <td>...</td>\n",
       "      <td>0.969545</td>\n",
       "      <td>0.915597</td>\n",
       "      <td>0.927763</td>\n",
       "      <td>0.925751</td>\n",
       "      <td>0.901961</td>\n",
       "      <td>0.955687</td>\n",
       "      <td>0.927527</td>\n",
       "      <td>0.977336</td>\n",
       "      <td>0.927527</td>\n",
       "      <td>0.977336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COMED_MW</th>\n",
       "      <td>0.893500</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.934141</td>\n",
       "      <td>0.892985</td>\n",
       "      <td>0.848116</td>\n",
       "      <td>0.932611</td>\n",
       "      <td>0.714651</td>\n",
       "      <td>0.944278</td>\n",
       "      <td>0.944278</td>\n",
       "      <td>0.893500</td>\n",
       "      <td>...</td>\n",
       "      <td>0.934141</td>\n",
       "      <td>0.892985</td>\n",
       "      <td>0.848116</td>\n",
       "      <td>0.932611</td>\n",
       "      <td>0.714651</td>\n",
       "      <td>0.944278</td>\n",
       "      <td>0.903474</td>\n",
       "      <td>0.849429</td>\n",
       "      <td>0.903474</td>\n",
       "      <td>0.849429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAYTON_MW</th>\n",
       "      <td>0.969545</td>\n",
       "      <td>0.934141</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.925706</td>\n",
       "      <td>0.896508</td>\n",
       "      <td>0.945652</td>\n",
       "      <td>0.818797</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.969545</td>\n",
       "      <td>...</td>\n",
       "      <td>0.998213</td>\n",
       "      <td>0.925706</td>\n",
       "      <td>0.896508</td>\n",
       "      <td>0.945652</td>\n",
       "      <td>0.818797</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.929067</td>\n",
       "      <td>0.935742</td>\n",
       "      <td>0.929067</td>\n",
       "      <td>0.935742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DEOK_MW</th>\n",
       "      <td>0.915597</td>\n",
       "      <td>0.892985</td>\n",
       "      <td>0.925706</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.873615</td>\n",
       "      <td>0.915498</td>\n",
       "      <td>0.797167</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.915597</td>\n",
       "      <td>...</td>\n",
       "      <td>0.925706</td>\n",
       "      <td>0.957926</td>\n",
       "      <td>0.873615</td>\n",
       "      <td>0.915498</td>\n",
       "      <td>0.797167</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.896925</td>\n",
       "      <td>0.869182</td>\n",
       "      <td>0.896925</td>\n",
       "      <td>0.869182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOM_MW</th>\n",
       "      <td>0.927763</td>\n",
       "      <td>0.848116</td>\n",
       "      <td>0.896508</td>\n",
       "      <td>0.873615</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.910274</td>\n",
       "      <td>0.813660</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.927763</td>\n",
       "      <td>...</td>\n",
       "      <td>0.896508</td>\n",
       "      <td>0.873615</td>\n",
       "      <td>0.999710</td>\n",
       "      <td>0.910274</td>\n",
       "      <td>0.813660</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.960739</td>\n",
       "      <td>0.937741</td>\n",
       "      <td>0.960739</td>\n",
       "      <td>0.937741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DUQ_MW</th>\n",
       "      <td>0.925751</td>\n",
       "      <td>0.932611</td>\n",
       "      <td>0.945652</td>\n",
       "      <td>0.915498</td>\n",
       "      <td>0.910274</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.737241</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.925751</td>\n",
       "      <td>...</td>\n",
       "      <td>0.945652</td>\n",
       "      <td>0.915498</td>\n",
       "      <td>0.910274</td>\n",
       "      <td>0.999536</td>\n",
       "      <td>0.737241</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.959208</td>\n",
       "      <td>0.905609</td>\n",
       "      <td>0.959208</td>\n",
       "      <td>0.905609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EKPC_MW</th>\n",
       "      <td>0.901961</td>\n",
       "      <td>0.714651</td>\n",
       "      <td>0.818797</td>\n",
       "      <td>0.797167</td>\n",
       "      <td>0.813660</td>\n",
       "      <td>0.737241</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>0.901961</td>\n",
       "      <td>...</td>\n",
       "      <td>0.818797</td>\n",
       "      <td>0.797167</td>\n",
       "      <td>0.813660</td>\n",
       "      <td>0.737241</td>\n",
       "      <td>0.999781</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>0.755337</td>\n",
       "      <td>0.875146</td>\n",
       "      <td>0.755337</td>\n",
       "      <td>0.875146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FE_MW_x</th>\n",
       "      <td>0.955687</td>\n",
       "      <td>0.944278</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.999327</td>\n",
       "      <td>0.955687</td>\n",
       "      <td>...</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>0.999327</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.935647</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.935647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FE_MW_y</th>\n",
       "      <td>0.955687</td>\n",
       "      <td>0.944278</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>0.999327</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.955687</td>\n",
       "      <td>...</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>0.999327</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.935647</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.935647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEP</th>\n",
       "      <td>0.999673</td>\n",
       "      <td>0.893500</td>\n",
       "      <td>0.969545</td>\n",
       "      <td>0.915597</td>\n",
       "      <td>0.927763</td>\n",
       "      <td>0.925751</td>\n",
       "      <td>0.901961</td>\n",
       "      <td>0.955687</td>\n",
       "      <td>0.955687</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.970047</td>\n",
       "      <td>0.916954</td>\n",
       "      <td>0.927918</td>\n",
       "      <td>0.925549</td>\n",
       "      <td>0.902182</td>\n",
       "      <td>0.956152</td>\n",
       "      <td>0.927930</td>\n",
       "      <td>0.977486</td>\n",
       "      <td>0.927527</td>\n",
       "      <td>0.977336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COMED</th>\n",
       "      <td>0.893500</td>\n",
       "      <td>0.998613</td>\n",
       "      <td>0.934141</td>\n",
       "      <td>0.892985</td>\n",
       "      <td>0.848116</td>\n",
       "      <td>0.932611</td>\n",
       "      <td>0.714651</td>\n",
       "      <td>0.944278</td>\n",
       "      <td>0.944278</td>\n",
       "      <td>0.894147</td>\n",
       "      <td>...</td>\n",
       "      <td>0.935348</td>\n",
       "      <td>0.896333</td>\n",
       "      <td>0.848566</td>\n",
       "      <td>0.932257</td>\n",
       "      <td>0.715010</td>\n",
       "      <td>0.945216</td>\n",
       "      <td>0.904436</td>\n",
       "      <td>0.849689</td>\n",
       "      <td>0.903474</td>\n",
       "      <td>0.849429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAYTON</th>\n",
       "      <td>0.969545</td>\n",
       "      <td>0.934141</td>\n",
       "      <td>0.998213</td>\n",
       "      <td>0.925706</td>\n",
       "      <td>0.896508</td>\n",
       "      <td>0.945652</td>\n",
       "      <td>0.818797</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.970047</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.933209</td>\n",
       "      <td>0.897116</td>\n",
       "      <td>0.945867</td>\n",
       "      <td>0.819043</td>\n",
       "      <td>0.977916</td>\n",
       "      <td>0.929855</td>\n",
       "      <td>0.936115</td>\n",
       "      <td>0.929067</td>\n",
       "      <td>0.935742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DEOK</th>\n",
       "      <td>0.915597</td>\n",
       "      <td>0.892985</td>\n",
       "      <td>0.925706</td>\n",
       "      <td>0.957926</td>\n",
       "      <td>0.873615</td>\n",
       "      <td>0.915498</td>\n",
       "      <td>0.797167</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.916954</td>\n",
       "      <td>...</td>\n",
       "      <td>0.933209</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.875537</td>\n",
       "      <td>0.918008</td>\n",
       "      <td>0.797878</td>\n",
       "      <td>0.916400</td>\n",
       "      <td>0.898714</td>\n",
       "      <td>0.870513</td>\n",
       "      <td>0.896925</td>\n",
       "      <td>0.869182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOM</th>\n",
       "      <td>0.927763</td>\n",
       "      <td>0.848116</td>\n",
       "      <td>0.896508</td>\n",
       "      <td>0.873615</td>\n",
       "      <td>0.999710</td>\n",
       "      <td>0.910274</td>\n",
       "      <td>0.813660</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.927918</td>\n",
       "      <td>...</td>\n",
       "      <td>0.897116</td>\n",
       "      <td>0.875537</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.910296</td>\n",
       "      <td>0.813673</td>\n",
       "      <td>0.895556</td>\n",
       "      <td>0.961124</td>\n",
       "      <td>0.937818</td>\n",
       "      <td>0.960739</td>\n",
       "      <td>0.937741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DUQ</th>\n",
       "      <td>0.925751</td>\n",
       "      <td>0.932611</td>\n",
       "      <td>0.945652</td>\n",
       "      <td>0.915498</td>\n",
       "      <td>0.910274</td>\n",
       "      <td>0.999536</td>\n",
       "      <td>0.737241</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.925549</td>\n",
       "      <td>...</td>\n",
       "      <td>0.945867</td>\n",
       "      <td>0.918008</td>\n",
       "      <td>0.910296</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.737117</td>\n",
       "      <td>0.966734</td>\n",
       "      <td>0.958912</td>\n",
       "      <td>0.905654</td>\n",
       "      <td>0.959208</td>\n",
       "      <td>0.905609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EKPC</th>\n",
       "      <td>0.901961</td>\n",
       "      <td>0.714651</td>\n",
       "      <td>0.818797</td>\n",
       "      <td>0.797167</td>\n",
       "      <td>0.813660</td>\n",
       "      <td>0.737241</td>\n",
       "      <td>0.999781</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>0.902182</td>\n",
       "      <td>...</td>\n",
       "      <td>0.819043</td>\n",
       "      <td>0.797878</td>\n",
       "      <td>0.813673</td>\n",
       "      <td>0.737117</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.766473</td>\n",
       "      <td>0.755461</td>\n",
       "      <td>0.875320</td>\n",
       "      <td>0.755337</td>\n",
       "      <td>0.875146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FE</th>\n",
       "      <td>0.955687</td>\n",
       "      <td>0.944278</td>\n",
       "      <td>0.977199</td>\n",
       "      <td>0.914762</td>\n",
       "      <td>0.895308</td>\n",
       "      <td>0.967039</td>\n",
       "      <td>0.766169</td>\n",
       "      <td>0.999327</td>\n",
       "      <td>0.999327</td>\n",
       "      <td>0.956152</td>\n",
       "      <td>...</td>\n",
       "      <td>0.977916</td>\n",
       "      <td>0.916400</td>\n",
       "      <td>0.895556</td>\n",
       "      <td>0.966734</td>\n",
       "      <td>0.766473</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.947701</td>\n",
       "      <td>0.935867</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.935647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PJME</th>\n",
       "      <td>0.927527</td>\n",
       "      <td>0.903474</td>\n",
       "      <td>0.929067</td>\n",
       "      <td>0.896925</td>\n",
       "      <td>0.960739</td>\n",
       "      <td>0.959208</td>\n",
       "      <td>0.755337</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.927930</td>\n",
       "      <td>...</td>\n",
       "      <td>0.929855</td>\n",
       "      <td>0.898714</td>\n",
       "      <td>0.961124</td>\n",
       "      <td>0.958912</td>\n",
       "      <td>0.755461</td>\n",
       "      <td>0.947701</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.934269</td>\n",
       "      <td>0.999189</td>\n",
       "      <td>0.934233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PJMW</th>\n",
       "      <td>0.977336</td>\n",
       "      <td>0.849429</td>\n",
       "      <td>0.935742</td>\n",
       "      <td>0.869182</td>\n",
       "      <td>0.937741</td>\n",
       "      <td>0.905609</td>\n",
       "      <td>0.875146</td>\n",
       "      <td>0.935647</td>\n",
       "      <td>0.935647</td>\n",
       "      <td>0.977486</td>\n",
       "      <td>...</td>\n",
       "      <td>0.936115</td>\n",
       "      <td>0.870513</td>\n",
       "      <td>0.937818</td>\n",
       "      <td>0.905654</td>\n",
       "      <td>0.875320</td>\n",
       "      <td>0.935867</td>\n",
       "      <td>0.934269</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.934233</td>\n",
       "      <td>0.999756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PJME_MW</th>\n",
       "      <td>0.927527</td>\n",
       "      <td>0.903474</td>\n",
       "      <td>0.929067</td>\n",
       "      <td>0.896925</td>\n",
       "      <td>0.960739</td>\n",
       "      <td>0.959208</td>\n",
       "      <td>0.755337</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.927527</td>\n",
       "      <td>...</td>\n",
       "      <td>0.929067</td>\n",
       "      <td>0.896925</td>\n",
       "      <td>0.960739</td>\n",
       "      <td>0.959208</td>\n",
       "      <td>0.755337</td>\n",
       "      <td>0.947101</td>\n",
       "      <td>0.999189</td>\n",
       "      <td>0.934233</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.934233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PJMW_MW</th>\n",
       "      <td>0.977336</td>\n",
       "      <td>0.849429</td>\n",
       "      <td>0.935742</td>\n",
       "      <td>0.869182</td>\n",
       "      <td>0.937741</td>\n",
       "      <td>0.905609</td>\n",
       "      <td>0.875146</td>\n",
       "      <td>0.935647</td>\n",
       "      <td>0.935647</td>\n",
       "      <td>0.977336</td>\n",
       "      <td>...</td>\n",
       "      <td>0.935742</td>\n",
       "      <td>0.869182</td>\n",
       "      <td>0.937741</td>\n",
       "      <td>0.905609</td>\n",
       "      <td>0.875146</td>\n",
       "      <td>0.935647</td>\n",
       "      <td>0.934233</td>\n",
       "      <td>0.999756</td>\n",
       "      <td>0.934233</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             AEP_MW  COMED_MW  DAYTON_MW   DEOK_MW    DOM_MW    DUQ_MW  \\\n",
       "AEP_MW     1.000000  0.893500   0.969545  0.915597  0.927763  0.925751   \n",
       "COMED_MW   0.893500  1.000000   0.934141  0.892985  0.848116  0.932611   \n",
       "DAYTON_MW  0.969545  0.934141   1.000000  0.925706  0.896508  0.945652   \n",
       "DEOK_MW    0.915597  0.892985   0.925706  1.000000  0.873615  0.915498   \n",
       "DOM_MW     0.927763  0.848116   0.896508  0.873615  1.000000  0.910274   \n",
       "DUQ_MW     0.925751  0.932611   0.945652  0.915498  0.910274  1.000000   \n",
       "EKPC_MW    0.901961  0.714651   0.818797  0.797167  0.813660  0.737241   \n",
       "FE_MW_x    0.955687  0.944278   0.977199  0.914762  0.895308  0.967039   \n",
       "FE_MW_y    0.955687  0.944278   0.977199  0.914762  0.895308  0.967039   \n",
       "AEP        0.999673  0.893500   0.969545  0.915597  0.927763  0.925751   \n",
       "COMED      0.893500  0.998613   0.934141  0.892985  0.848116  0.932611   \n",
       "DAYTON     0.969545  0.934141   0.998213  0.925706  0.896508  0.945652   \n",
       "DEOK       0.915597  0.892985   0.925706  0.957926  0.873615  0.915498   \n",
       "DOM        0.927763  0.848116   0.896508  0.873615  0.999710  0.910274   \n",
       "DUQ        0.925751  0.932611   0.945652  0.915498  0.910274  0.999536   \n",
       "EKPC       0.901961  0.714651   0.818797  0.797167  0.813660  0.737241   \n",
       "FE         0.955687  0.944278   0.977199  0.914762  0.895308  0.967039   \n",
       "PJME       0.927527  0.903474   0.929067  0.896925  0.960739  0.959208   \n",
       "PJMW       0.977336  0.849429   0.935742  0.869182  0.937741  0.905609   \n",
       "PJME_MW    0.927527  0.903474   0.929067  0.896925  0.960739  0.959208   \n",
       "PJMW_MW    0.977336  0.849429   0.935742  0.869182  0.937741  0.905609   \n",
       "\n",
       "            EKPC_MW   FE_MW_x   FE_MW_y       AEP  ...    DAYTON      DEOK  \\\n",
       "AEP_MW     0.901961  0.955687  0.955687  0.999673  ...  0.969545  0.915597   \n",
       "COMED_MW   0.714651  0.944278  0.944278  0.893500  ...  0.934141  0.892985   \n",
       "DAYTON_MW  0.818797  0.977199  0.977199  0.969545  ...  0.998213  0.925706   \n",
       "DEOK_MW    0.797167  0.914762  0.914762  0.915597  ...  0.925706  0.957926   \n",
       "DOM_MW     0.813660  0.895308  0.895308  0.927763  ...  0.896508  0.873615   \n",
       "DUQ_MW     0.737241  0.967039  0.967039  0.925751  ...  0.945652  0.915498   \n",
       "EKPC_MW    1.000000  0.766169  0.766169  0.901961  ...  0.818797  0.797167   \n",
       "FE_MW_x    0.766169  1.000000  0.999327  0.955687  ...  0.977199  0.914762   \n",
       "FE_MW_y    0.766169  0.999327  1.000000  0.955687  ...  0.977199  0.914762   \n",
       "AEP        0.901961  0.955687  0.955687  1.000000  ...  0.970047  0.916954   \n",
       "COMED      0.714651  0.944278  0.944278  0.894147  ...  0.935348  0.896333   \n",
       "DAYTON     0.818797  0.977199  0.977199  0.970047  ...  1.000000  0.933209   \n",
       "DEOK       0.797167  0.914762  0.914762  0.916954  ...  0.933209  1.000000   \n",
       "DOM        0.813660  0.895308  0.895308  0.927918  ...  0.897116  0.875537   \n",
       "DUQ        0.737241  0.967039  0.967039  0.925549  ...  0.945867  0.918008   \n",
       "EKPC       0.999781  0.766169  0.766169  0.902182  ...  0.819043  0.797878   \n",
       "FE         0.766169  0.999327  0.999327  0.956152  ...  0.977916  0.916400   \n",
       "PJME       0.755337  0.947101  0.947101  0.927930  ...  0.929855  0.898714   \n",
       "PJMW       0.875146  0.935647  0.935647  0.977486  ...  0.936115  0.870513   \n",
       "PJME_MW    0.755337  0.947101  0.947101  0.927527  ...  0.929067  0.896925   \n",
       "PJMW_MW    0.875146  0.935647  0.935647  0.977336  ...  0.935742  0.869182   \n",
       "\n",
       "                DOM       DUQ      EKPC        FE      PJME      PJMW  \\\n",
       "AEP_MW     0.927763  0.925751  0.901961  0.955687  0.927527  0.977336   \n",
       "COMED_MW   0.848116  0.932611  0.714651  0.944278  0.903474  0.849429   \n",
       "DAYTON_MW  0.896508  0.945652  0.818797  0.977199  0.929067  0.935742   \n",
       "DEOK_MW    0.873615  0.915498  0.797167  0.914762  0.896925  0.869182   \n",
       "DOM_MW     0.999710  0.910274  0.813660  0.895308  0.960739  0.937741   \n",
       "DUQ_MW     0.910274  0.999536  0.737241  0.967039  0.959208  0.905609   \n",
       "EKPC_MW    0.813660  0.737241  0.999781  0.766169  0.755337  0.875146   \n",
       "FE_MW_x    0.895308  0.967039  0.766169  0.999327  0.947101  0.935647   \n",
       "FE_MW_y    0.895308  0.967039  0.766169  0.999327  0.947101  0.935647   \n",
       "AEP        0.927918  0.925549  0.902182  0.956152  0.927930  0.977486   \n",
       "COMED      0.848566  0.932257  0.715010  0.945216  0.904436  0.849689   \n",
       "DAYTON     0.897116  0.945867  0.819043  0.977916  0.929855  0.936115   \n",
       "DEOK       0.875537  0.918008  0.797878  0.916400  0.898714  0.870513   \n",
       "DOM        1.000000  0.910296  0.813673  0.895556  0.961124  0.937818   \n",
       "DUQ        0.910296  1.000000  0.737117  0.966734  0.958912  0.905654   \n",
       "EKPC       0.813673  0.737117  1.000000  0.766473  0.755461  0.875320   \n",
       "FE         0.895556  0.966734  0.766473  1.000000  0.947701  0.935867   \n",
       "PJME       0.961124  0.958912  0.755461  0.947701  1.000000  0.934269   \n",
       "PJMW       0.937818  0.905654  0.875320  0.935867  0.934269  1.000000   \n",
       "PJME_MW    0.960739  0.959208  0.755337  0.947101  0.999189  0.934233   \n",
       "PJMW_MW    0.937741  0.905609  0.875146  0.935647  0.934233  0.999756   \n",
       "\n",
       "            PJME_MW   PJMW_MW  \n",
       "AEP_MW     0.927527  0.977336  \n",
       "COMED_MW   0.903474  0.849429  \n",
       "DAYTON_MW  0.929067  0.935742  \n",
       "DEOK_MW    0.896925  0.869182  \n",
       "DOM_MW     0.960739  0.937741  \n",
       "DUQ_MW     0.959208  0.905609  \n",
       "EKPC_MW    0.755337  0.875146  \n",
       "FE_MW_x    0.947101  0.935647  \n",
       "FE_MW_y    0.947101  0.935647  \n",
       "AEP        0.927527  0.977336  \n",
       "COMED      0.903474  0.849429  \n",
       "DAYTON     0.929067  0.935742  \n",
       "DEOK       0.896925  0.869182  \n",
       "DOM        0.960739  0.937741  \n",
       "DUQ        0.959208  0.905609  \n",
       "EKPC       0.755337  0.875146  \n",
       "FE         0.947101  0.935647  \n",
       "PJME       0.999189  0.934233  \n",
       "PJMW       0.934233  0.999756  \n",
       "PJME_MW    1.000000  0.934233  \n",
       "PJMW_MW    0.934233  1.000000  \n",
       "\n",
       "[21 rows x 21 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.corr()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "60231951",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([15128, 14886, 14831, ..., 20999, 20820, 20415], dtype=int64)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Y = df.AEP_MW.values\n",
    "Y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "81019d94",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['2022-12-04T01:00:00.000000000', '2022-12-04T02:00:00.000000000',\n",
       "       '2022-12-04T03:00:00.000000000', ...,\n",
       "       '2022-12-04T21:00:00.000000000', '2022-12-04T22:00:00.000000000',\n",
       "       '2022-12-04T23:00:00.000000000'], dtype='datetime64[ns]')"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X = df.Time.values\n",
    "X"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "2147f964",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\satyam singh\\AppData\\Local\\Temp\\ipykernel_20752\\3969452698.py:1: FutureWarning: Support for multi-dimensional indexing (e.g. `obj[:, None]`) is deprecated and will be removed in a future version.  Convert to a numpy array before indexing instead.\n",
      "  X = df.Time[:,np.newaxis]\n"
     ]
    }
   ],
   "source": [
    "X = df.Time[:,np.newaxis]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "8b5ac1a4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[0.04347826]\n",
      " [0.08695652]\n",
      " [0.13043478]\n",
      " ...\n",
      " [0.91304348]\n",
      " [0.95652174]\n",
      " [1.        ]]\n",
      "[0.36594538 0.34998021 0.34635176 ... 0.7532656  0.74145666 0.71473809]\n"
     ]
    }
   ],
   "source": [
    "Xmin= X.min()\n",
    "Xmax=X.max()\n",
    "Xnorm = (X-Xmin)/(Xmax-Xmin)\n",
    "\n",
    "Ymin = Y.min()\n",
    "Ymax = Y.max()\n",
    "Ynorm = (Y - Ymin)/(Ymax-Ymin)\n",
    "\n",
    "print (Xnorm)\n",
    "print(Ynorm)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "59871dab",
   "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>Time</th>\n",
       "      <th>AEP_MW</th>\n",
       "      <th>COMED_MW</th>\n",
       "      <th>DAYTON_MW</th>\n",
       "      <th>DEOK_MW</th>\n",
       "      <th>DOM_MW</th>\n",
       "      <th>DUQ_MW</th>\n",
       "      <th>EKPC_MW</th>\n",
       "      <th>FE_MW_x</th>\n",
       "      <th>...</th>\n",
       "      <th>DAYTON</th>\n",
       "      <th>DEOK</th>\n",
       "      <th>DOM</th>\n",
       "      <th>DUQ</th>\n",
       "      <th>EKPC</th>\n",
       "      <th>FE</th>\n",
       "      <th>PJME</th>\n",
       "      <th>PJMW</th>\n",
       "      <th>PJME_MW</th>\n",
       "      <th>PJMW_MW</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>0.043478</td>\n",
       "      <td>0.365945</td>\n",
       "      <td>11979</td>\n",
       "      <td>1930</td>\n",
       "      <td>3065</td>\n",
       "      <td>10239</td>\n",
       "      <td>1563</td>\n",
       "      <td>1861</td>\n",
       "      <td>7459</td>\n",
       "      <td>...</td>\n",
       "      <td>1930</td>\n",
       "      <td>3065</td>\n",
       "      <td>10239</td>\n",
       "      <td>1563</td>\n",
       "      <td>1861</td>\n",
       "      <td>7459</td>\n",
       "      <td>30254</td>\n",
       "      <td>5840</td>\n",
       "      <td>30254</td>\n",
       "      <td>5840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>0.349980</td>\n",
       "      <td>11438</td>\n",
       "      <td>1884</td>\n",
       "      <td>2970</td>\n",
       "      <td>9964</td>\n",
       "      <td>1498</td>\n",
       "      <td>1835</td>\n",
       "      <td>7241</td>\n",
       "      <td>...</td>\n",
       "      <td>1884</td>\n",
       "      <td>2970</td>\n",
       "      <td>9964</td>\n",
       "      <td>1498</td>\n",
       "      <td>1835</td>\n",
       "      <td>7241</td>\n",
       "      <td>29241</td>\n",
       "      <td>5710</td>\n",
       "      <td>29241</td>\n",
       "      <td>5710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>0.130435</td>\n",
       "      <td>0.346352</td>\n",
       "      <td>11113</td>\n",
       "      <td>1845</td>\n",
       "      <td>2917</td>\n",
       "      <td>9921</td>\n",
       "      <td>1469</td>\n",
       "      <td>1841</td>\n",
       "      <td>7115</td>\n",
       "      <td>...</td>\n",
       "      <td>1845</td>\n",
       "      <td>2917</td>\n",
       "      <td>9921</td>\n",
       "      <td>1469</td>\n",
       "      <td>1841</td>\n",
       "      <td>7115</td>\n",
       "      <td>28772</td>\n",
       "      <td>5617</td>\n",
       "      <td>28772</td>\n",
       "      <td>5617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>0.173913</td>\n",
       "      <td>0.349123</td>\n",
       "      <td>10928</td>\n",
       "      <td>1843</td>\n",
       "      <td>2910</td>\n",
       "      <td>9981</td>\n",
       "      <td>1461</td>\n",
       "      <td>1872</td>\n",
       "      <td>7073</td>\n",
       "      <td>...</td>\n",
       "      <td>1843</td>\n",
       "      <td>2910</td>\n",
       "      <td>9981</td>\n",
       "      <td>1461</td>\n",
       "      <td>1872</td>\n",
       "      <td>7073</td>\n",
       "      <td>28762</td>\n",
       "      <td>5661</td>\n",
       "      <td>28762</td>\n",
       "      <td>5661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12/31/2013</td>\n",
       "      <td>0.217391</td>\n",
       "      <td>0.357567</td>\n",
       "      <td>10926</td>\n",
       "      <td>1875</td>\n",
       "      <td>2958</td>\n",
       "      <td>10290</td>\n",
       "      <td>1481</td>\n",
       "      <td>1934</td>\n",
       "      <td>7156</td>\n",
       "      <td>...</td>\n",
       "      <td>1875</td>\n",
       "      <td>2958</td>\n",
       "      <td>10290</td>\n",
       "      <td>1481</td>\n",
       "      <td>1934</td>\n",
       "      <td>7156</td>\n",
       "      <td>29391</td>\n",
       "      <td>5732</td>\n",
       "      <td>29391</td>\n",
       "      <td>5732</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>51482</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>0.826087</td>\n",
       "      <td>0.748384</td>\n",
       "      <td>13809</td>\n",
       "      <td>2714</td>\n",
       "      <td>4393</td>\n",
       "      <td>18249</td>\n",
       "      <td>1968</td>\n",
       "      <td>2739</td>\n",
       "      <td>9434</td>\n",
       "      <td>...</td>\n",
       "      <td>2714</td>\n",
       "      <td>4393</td>\n",
       "      <td>18249</td>\n",
       "      <td>1968</td>\n",
       "      <td>2739</td>\n",
       "      <td>9434</td>\n",
       "      <td>44343</td>\n",
       "      <td>8328</td>\n",
       "      <td>44343</td>\n",
       "      <td>8328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51483</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>0.869565</td>\n",
       "      <td>0.759203</td>\n",
       "      <td>13858</td>\n",
       "      <td>2732</td>\n",
       "      <td>4426</td>\n",
       "      <td>18418</td>\n",
       "      <td>1962</td>\n",
       "      <td>2866</td>\n",
       "      <td>9378</td>\n",
       "      <td>...</td>\n",
       "      <td>2732</td>\n",
       "      <td>4426</td>\n",
       "      <td>18418</td>\n",
       "      <td>1962</td>\n",
       "      <td>2866</td>\n",
       "      <td>9378</td>\n",
       "      <td>44284</td>\n",
       "      <td>8401</td>\n",
       "      <td>44284</td>\n",
       "      <td>8401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51484</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>0.913043</td>\n",
       "      <td>0.753266</td>\n",
       "      <td>13758</td>\n",
       "      <td>2724</td>\n",
       "      <td>4419</td>\n",
       "      <td>18567</td>\n",
       "      <td>1940</td>\n",
       "      <td>2846</td>\n",
       "      <td>9255</td>\n",
       "      <td>...</td>\n",
       "      <td>2724</td>\n",
       "      <td>4419</td>\n",
       "      <td>18567</td>\n",
       "      <td>1940</td>\n",
       "      <td>2846</td>\n",
       "      <td>9255</td>\n",
       "      <td>43751</td>\n",
       "      <td>8373</td>\n",
       "      <td>43751</td>\n",
       "      <td>8373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51485</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>0.956522</td>\n",
       "      <td>0.741457</td>\n",
       "      <td>13627</td>\n",
       "      <td>2664</td>\n",
       "      <td>4355</td>\n",
       "      <td>18307</td>\n",
       "      <td>1891</td>\n",
       "      <td>2883</td>\n",
       "      <td>9044</td>\n",
       "      <td>...</td>\n",
       "      <td>2664</td>\n",
       "      <td>4355</td>\n",
       "      <td>18307</td>\n",
       "      <td>1891</td>\n",
       "      <td>2883</td>\n",
       "      <td>9044</td>\n",
       "      <td>42402</td>\n",
       "      <td>8238</td>\n",
       "      <td>42402</td>\n",
       "      <td>8238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51486</th>\n",
       "      <td>01-01-2018</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.714738</td>\n",
       "      <td>13336</td>\n",
       "      <td>2614</td>\n",
       "      <td>4224</td>\n",
       "      <td>17814</td>\n",
       "      <td>1820</td>\n",
       "      <td>2880</td>\n",
       "      <td>8676</td>\n",
       "      <td>...</td>\n",
       "      <td>2614</td>\n",
       "      <td>4224</td>\n",
       "      <td>17814</td>\n",
       "      <td>1820</td>\n",
       "      <td>2880</td>\n",
       "      <td>8676</td>\n",
       "      <td>40164</td>\n",
       "      <td>7958</td>\n",
       "      <td>40164</td>\n",
       "      <td>7958</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>51487 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Date      Time    AEP_MW  COMED_MW  DAYTON_MW  DEOK_MW  DOM_MW  \\\n",
       "0      12/31/2013  0.043478  0.365945     11979       1930     3065   10239   \n",
       "1      12/31/2013  0.086957  0.349980     11438       1884     2970    9964   \n",
       "2      12/31/2013  0.130435  0.346352     11113       1845     2917    9921   \n",
       "3      12/31/2013  0.173913  0.349123     10928       1843     2910    9981   \n",
       "4      12/31/2013  0.217391  0.357567     10926       1875     2958   10290   \n",
       "...           ...       ...       ...       ...        ...      ...     ...   \n",
       "51482  01-01-2018  0.826087  0.748384     13809       2714     4393   18249   \n",
       "51483  01-01-2018  0.869565  0.759203     13858       2732     4426   18418   \n",
       "51484  01-01-2018  0.913043  0.753266     13758       2724     4419   18567   \n",
       "51485  01-01-2018  0.956522  0.741457     13627       2664     4355   18307   \n",
       "51486  01-01-2018  1.000000  0.714738     13336       2614     4224   17814   \n",
       "\n",
       "       DUQ_MW  EKPC_MW  FE_MW_x  ...  DAYTON  DEOK    DOM   DUQ  EKPC    FE  \\\n",
       "0        1563     1861     7459  ...    1930  3065  10239  1563  1861  7459   \n",
       "1        1498     1835     7241  ...    1884  2970   9964  1498  1835  7241   \n",
       "2        1469     1841     7115  ...    1845  2917   9921  1469  1841  7115   \n",
       "3        1461     1872     7073  ...    1843  2910   9981  1461  1872  7073   \n",
       "4        1481     1934     7156  ...    1875  2958  10290  1481  1934  7156   \n",
       "...       ...      ...      ...  ...     ...   ...    ...   ...   ...   ...   \n",
       "51482    1968     2739     9434  ...    2714  4393  18249  1968  2739  9434   \n",
       "51483    1962     2866     9378  ...    2732  4426  18418  1962  2866  9378   \n",
       "51484    1940     2846     9255  ...    2724  4419  18567  1940  2846  9255   \n",
       "51485    1891     2883     9044  ...    2664  4355  18307  1891  2883  9044   \n",
       "51486    1820     2880     8676  ...    2614  4224  17814  1820  2880  8676   \n",
       "\n",
       "        PJME  PJMW  PJME_MW  PJMW_MW  \n",
       "0      30254  5840    30254     5840  \n",
       "1      29241  5710    29241     5710  \n",
       "2      28772  5617    28772     5617  \n",
       "3      28762  5661    28762     5661  \n",
       "4      29391  5732    29391     5732  \n",
       "...      ...   ...      ...      ...  \n",
       "51482  44343  8328    44343     8328  \n",
       "51483  44284  8401    44284     8401  \n",
       "51484  43751  8373    43751     8373  \n",
       "51485  42402  8238    42402     8238  \n",
       "51486  40164  7958    40164     7958  \n",
       "\n",
       "[51487 rows x 23 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df\n",
    "df2.AEP_MW=Ynorm\n",
    "df2.Time=Xnorm\n",
    "df2\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "2994f86d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYMAAAEGCAYAAACHGfl5AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAABM3UlEQVR4nO29e5TcV3Xv+TlV/e7Wo9WSZUstWbJkG/zUxcIPbDyA74CBxE4Gxxc7iecmYYhXQi5DEiArd02SISsrCSS5CRDicVhMrkOAa0x4JOPg5IYQXraxbGTZMhi3X1JLtiy1WlJ3q9995o/qn9Vdfb6/X/12V1W/zmctg/pbVV3n1/Wrs8/Ze5+9nfeeSCQSiaxsCgs9gEgkEoksPNEYRCKRSCQag0gkEolEYxCJRCIRojGIRCKRCNCw0AOwsH79er9t27aFHkYkEoksKR599NFj3vsNoceWpDHYtm0be/bsWehhRCKRyJLCOfeieiy6iSKRSCQSjUEkEolEojGIRCKRCNEYRCKRSIRoDCKRSCRCjY2Bc+4zzrlXnHNPisedc+7jzrke59w+59zrajmeyNKgb3CUxw+eoG9wdKGHEomsGGqdWvo3wCeBe8TjbwfOn/7vKuCvpv8/skL56t5DfPhL+2gsFBifmuKj77qMm3ZtXuhhRSLLnpruDLz33wKOpzzlZuAeX+IhYK1z7pxajimyeOkbHOXDX9rHyPgUA6MTjIxP8aEv7Ys7hEikDix0zGAzcHDGz73T2hycc+91zu1xzu05evRoXQYXqS+9/cM0Fmbfko2FAr39wws0okhk5bDQxsAFtGC3He/93d773d773Rs2BE9TR5Y43Z2tjE9NzdLGp6bo7mxdoBFFIiuHhTYGvcCWGT93A4cXaCyRBaaro5lbd3fP0m7d3U1XR3Pma2PQORKZHwttDL4G3DGdVXQ1cNJ7/9ICjymyQPQNjnLvnt5Z2r17ejMn+K/uPcS1f/wNfu7TD3PtH3+Dr+09VMthRiLLklqnln4eeBC40DnX65z7Jefcnc65O6efcj/wHNAD/DXwK7UcT6T+5FmxW2IGMegciVSHmqaWeu9vy3jcA79ayzFEFo68aaLdna0Mj0/M0obHJ1JjBokBGeFMrCExIJW4lyKRSImFdhNFlinWFbsvyyko/7mcGHSORKpDNAaRmmBx+ew/fJLJqdnJZJNTnv2HT8rXdHU0s3Xd7In/3HWtcVcQieQkGoNITbCt2NUuQO8O9jzfx4+PDM3Snj4yxJ7n+yocaSQSgWgMIjWiq6OZj77rMloaC6xqbqClscBH33VZ6or94k2raSi7IxsKJV3xrWeO5dIjkUiYJdn2MrI0uGnXZq7duZ7e/mG6O7NdN10dzfzZrbv44H2PU3QFJv0UH7vl8tTXXX/+ej7+jZ6gHolEKicag8ii4qZdm7nonNXsPXiCXVvWsnPjqtTn797exRt3dvHtnjNuoTfu7GL39q6K3q/nyEDF7xVZ/vQNjla8eJnPaxYj0RhEaoalAulX9x7iQ/fto1hwTE55PnZL9mv+9j1X869Pvcw/P3WEt160kRsuOrui8f3OV57gnocOvPrzHdds5SM3X1rRayPLD+v9ulyq7MaYQaQmWFJL+wZH+c0vPs7oxBSnxyYZnZjiN774eEUnkH/lcz/gH/a9xK987gcVnUDuOTIwyxAA3PPgAXqODFR2gZFlhfV+tR54XIzlU6IxiNSE3v5hfFmaqJ/ymaml45OzXzM+mZ5aajUgew+eyKVHlh61Pv1urbK7WMunRGMQqZg8X672piKjZRP76KSnvakoX3NqeCKXDjYDArBry9pcemRpkXfC7e5sZWRicpY2MjGZmgptSZ9ezOVTojGIVETeL9fQ2CSNxdnnAxqLjqGxSfEKWN0aDmEpHeDU8HguPaGzvSmXHlk6mE+/e5/6czlJ+nRzQ4G2piLNDdnp04u5Z0c0BpFMLF+u9qZicMWetjPYtCa8olI6wOrW8OSt9IT9h0/l0meyGP29kTP09g8zMTl7xT4xOZXp8mltnL3oaG1syJykffK//sxPaSzm8inRGEQysaxmhsYmaS7bGTRn7Awsr7EcVCuhvrjpX+iv7j3EG/7oG9z21w/xhj9aPP7eyBnGJyaZmD3fMjFV0hUWN1GySBqd8Jwen2R0wmcukiyHMetFTC2NZGJZzXR3tjJZts2e9D7zNa7gYMaOwhVc6muSg2q/+cXH8ZQKV/zJz6QfVANoawzvUJQOZ4LVM3c8v/HFx7l25/pF8WWOlHih77TU086f5HUTWSvm5j2MOZNanmmIO4NIJtbVTNlOfc7P1XqfPS8cZ2zSMz7pGZv07HnxeOY1pU0YCmuwOlJfLMkBvf3DFN3sXWnRudTdr2U3kdDV0czlW9bmmtBrnYUUdwaRisi7mnnw2WNzHC5+Wv+Jy/WhnLzvo84L3HH1ttQTxdu62nLpJfIX0ovUn50bVwVPpafdD5bsNyBYZbcS8q7wZ8btkp3Ih760r6q70mgMIhXT1dFc8Y13bHAsl24l7bxA2pf/9Hh4m6J0gLbG8EZa6TNZLiULlgJ9g6M88mL/LO2RF/vpGxyVf/uhsUkaCsyKNTQUSI1X7T98kvK5f8qX9OsvOEu+znLKvh5NnKIxiNSE63aGC8UpPSHv8X77eYH8AeQnRabRk4dPpfqil1PJgqWAcu2kTZztTcVg0Lna52Kscad6ZCHFmMEKpB6pkTs3ruKOa7bO0u64Zmvqat2Swmp5H4CLN60JnoO4eNMa+Zrm8rSlDB0W9yGj5Up7U5GRsh3eyPhU6sR++ORILh1s52Kscad6ZCGtqJ1B3KrXd5X6kZsv5Y6rt1VcFdS6Fc77PlD6cv3pz1zOb37xcZxzeO8zs5A2i1WY0udzTRE7aRO7vjfy7xSTBcXMyT1rQTGfuNN8spAqYcUYg7hVn38QymJMd25cVXFp6O7OVobHZ2+xh8cnKtoKd7Y3cf7GVblOEHvAOTftu81+vuVQ3GI+ZLSUyHfv2Sb2xIefUCykT+xdHc1cvX3drED11dvXVdTAqTw2kX0u5sx71moRsSLcRMt5q17rYlwJpcNW/8ptdz/EG/7oX2t22MqVpfeV/6zGljfl7syBoTMF7rLuiaGxSco8SxRdepCxq6OZW6/onqXdurt70e0KLK7Der0m70E/iwsQwJUZi/Kfy+k5MjDLEAB8u6cvtfJtV0czV583O750zXlduXon1MrFuyJ2Bst1q553t2NdpfYNjvIb9+6dXs2UJr5fv3dv1Q9b9fYP09JQZHzyzO6gpaGY+jlZdzuWe6K9qUiZu5dJnx5k7Bsc5e++f3CW9ncPH+T9N1yQ+bezujXzvq5edfwtr7EEXLs6mrntyi3c8+CZlOPbrtySeT+0NjYwMHrm3kvKUajXWTLZeo4M8B1hQLJ20LX2bqyIncF8t+qLsRaNZbdjDULtP3wqmGlRSR2fPFg+J+tux/JeQ2OTtJSlkbY0FlJ3Bg8+2xfMRX/w2T7xihLWA0Z5V9H1quNv3Z1by5rfu6d3lnbvnt7U97K4KC2ZbNbS6fXwbqwIYzCfSLz1S1nrLbR1Erxp12a+++G38Nn3XMV3P/yWilYW1sqgUFoJ3bfnYEVNY7o6mrl1dz6XitXQn6k46WhrLNLc4DLvCfU7097rhy+FJy2lg/2Lb+ntYC3qlrdXhfV+tdx7aamlaeR1UVoy2ayp0PWodroi3ERgi8RbXRD12ELPZ7dTyyDUTPK2lewbHOVzD88+Tfy5hw+kulQSAzLTJVCpT740nblSIofPjk0kBuSDMw4MZRmQtqbwV0zpYHdrpq2i1SEoS1E3y2lda3LAwEg4Z1/pyfjyppb29g/PWRkXSD+bAHDFuev4H4/0lm4hYPe56+RzwXY6GuZX+qJSVsTOwIrFGtdrC13P6oeWfGpLW0mLO8riEkhelzeADPlLFl+1PTw5KB1KX/yZvmuAgdFKsqrypy1aajRZelWALTng+FD481A6wOGT4e+n0sFm4GbeQyMTUxXdQ2mno7PIW0gvLytmZ2BZrc/Hh51nVbcQ1Q/zYEmp/E7PMalXM9e7t3+Y0bJV4Oj4VObfzvI3n1myOAmkZ+0UGxuKwVTCxgY9yTx/dFDqade0aU1LLh1sbgtLr4re/mGKhdk5+cWCy/yczu3qyKUDHBKLNaVDugFR96vlpHOai63aAe68rIidgdUHa1l9W8s9z8flk7f6Yd54hmUluF6MR+kA4+Xbggwd4NjASLAg3rEBfXIUbNtuiy+6u7M1uCJOe5+v7z+SS0+wBLgtfm9L3wmL6wbg7NXh+0XpAL394V2N0kvk31VZrslaEK8ebqIVsTOYT2rpTbs2c9E5qys+3ZoYkA+V7ULS3sfyGiuWHZJlJXjNjq7gIZ5rdugaPv/29CtSv+Gis4OPPd4bDsQ+3ntSviYhb8VJ64SWd3u/c0N7Lj2hu7OVsTLDOTaRvajIe4K7u7OVcvM8RXog/Ucvh119P3r5VOr7WepBWeI0ll1Vcu5k5lcj69xJYrBn3kdZBjshuomqwHxW3pbJ0+K+sbp88uSUWwPiyUpw5oomayXY1dHMf7v1cj54375XtY/dkm7gmorhjarSAa4/fz0f/0ZPUE/DUnHS8uW3bO93nhV2gSg94fmjg8FrynIvWchrSK1VbC07zLddfDYf++cfB3WFpYSF5dxJd2drMHsray6qh5uo5sbAOXcj8BdAEfi09/6Pyh5fA3wW2Do9nj/x3v+/1RyDdeVdjxri8yGvobL4OMHWgQzyG7hNa0VsQugA2zeEJ0iln8HmFrB8+fMuRJ4UOfRPHj6ZWh31gadelnra6/JmfVkM6SWi3ILSEyxuos72puCuNK1UiSWF1RJngCRw7st+Tmc+pVoqpaYxA+dcEfhL4O3ARcBtzrmLyp72q8BT3vvLgTcBf+qcq7zATIXctGszn/3FK/mFa7fx2V+8sqL8emtur+VsQt7XWJvUW9wc9cpcahA7AKUD8vBW1qEuq1sgr08++ds1FaG5WKCpSObfbn1HeAxKTzhvfdgAKh1sWV9Pvxx+TOmQnlCQRprrUNHbPxyMcaV9b1e3NubSwVbCOjllP5PklH0WlmysPNR6Z3Al0OO9fw7AOfcF4GbgqRnP8cAqV7qyDuA4oP+aRmaufj7+jZ7M1Q/YVnWW3YTlNZY4iK2aYwmLG+urew/xwS8+jvfgXKk3cZoRtqweX+wLZ94oPcHyt7AcOoOkLScw/VntefF46t9BxVXS4i0Ar98WTldVOsCXf9Ar9Q/e+NrgYy+KtFOlAzz8fLgVqdITToiJVelgW/RYFgeWlGury9qajZWHWmcTbQZmFmbpndZm8kngtcBh4Ang/d77Oekjzrn3Ouf2OOf2HD16NNcgLKsfsK2ILbsJy2tsN1X+1E0rfYOj/J9f2FvqTTxV6k38/i/sTd25WLqPWVIPS+T/W1juB+u9Vyy41J9DWHYuB8QErnSAc0VrUKUDXL45XCRO6QmvP3dtLh3gR2KHonSw9TOwpFxbTtmDfVefh1rvDEJ3cPm37W3AXuAtwA7gX5xz3/bez0oj8N7fDdwNsHv37lyzl7U1IuRfEdcrtdQSB7HcvAl54xNffqw3mPL55cd6ec/1O4KvOSxS/5QO9lW0pWQx5L8fLPfe/sMngwHarHaK3Z2twayvtPtow6rw+JUO0NEcnjaUDnBJd/jvqvSEZ14JT+BKB3jsxfBu47EXj/MTl28KPmaJGVgSCiyn7JP3ypvEkZda7wx6gS0zfu6mtAOYyS8Af+9L9ADPA6+p5iDsrRHzY1k9Wn3yeeMgltUP2OITjx7oz6UD9IlTpUqH9ANaWeQtWWzBdu/ZGqD0D40FjUj/kM7YOV8YJKUDHBe/T+lgKysBNpeU7ZxBfiwJBdaij92drUyWpZJO+nRDn5da7wweAc53zm0HDgHvBm4ve84B4Abg2865jcCFwHPVHMTOjau4bmfXrNKxldQDgfqmluY5zwCWOIjNTWSJT2zpDLsMlA6wrj38u5QO8OW95WuLM3paBk1v/zDladreZ2dW5W1mnhzqmlk7KetQl8V/DbZdyKqWcIBU6cCc1MgsHWwGBKBDjEPpAM3idLfSweb/HxqbpOCYlVlVyNgZzMdVa8lCykNNdwbe+wngfcADwA+Be733+51zdzrn7px+2u8Db3DOPQH8K/Bh7316ikFO+gZH2WOoB1LPpjhf3XuId37iO/zO1/bzzk98JzObyOKLtrqJLG6sNeJLpHSwrYenpsITkNITxicmg6u6tAJtlqqgUCpm1lR0r/6XVczM0kQHYJvw2SsdoEe4W5QOMDAaHofSAcaFoVB6QpdIB1U62NqTWr4bxwZGgim2aaffrd/BJIA8kySAXC1qXo7Ce3+/9/4C7/0O7/0fTGt3ee/vmv73Ye/9W733l3rvL/Hef7baY7CmiFpL4ebtCmaZZCx10S1lBMDmxmoSqzClA/SJVaLSAVobw7ew0hMefj6ceqp0sNfW/417S4H05L9fvzc9kG5xPwC8fCr8O5UOsK/3RC4d4JJN4V2G0gF+INyDSk9Y2xae9JUOzHHDZOmgDW3ad+Pfng4nsijd+j5QnwDyiqhNZK3rYfkAki//6ITn9PgkoxPZX37LJGPxRb96eGwGlRweg5Ib6x/fdx2/+5MX8Y/vuy7TVVZeFiFLB5v7oUvk3is9wfalzL93sfiILVU3AV7sG8qlA7Q0hu9lpYMtTfSYuP+VntB/OrwQUDrANeeFd15KB3j+aHgnpHSApvLtW4YOeteQVUtraGyShrLZuqGQbUTysCKMAdjqeli267YAUf5JZufGVVy4cXatmgs3tqf6oufb5OcnPvkd/u9/eIqf+GS2G2ud2MYrHeCACPApHWDz2vCkr/RXxyFWlkoH3bQ8vZm5xUdsCyCf2xWuXaR0sNXxeURM+koH6GgRGUhCT1DB77Sg+LBIRVY6wBcfDZ+3UDrA64S7T+kAD4m/kdIT2puKwXllKaWWLgqsdT1s2/X8X35LwLDnyABPH5m94nv6yFBmL9V6NflZJb7kSgdYIx5TOsCeF09I/adetyX4GNhOO1tKS1t8xBdvWh0se51udGBiMrxIUTrA+Hj4MaWDbbV+5FR45av0hEGRbaR0sO1CCsLQKh1sLsqNImVX6QnLIbV0UWCt62E5xGP58lvcAtZeqpC/7LUtdpJ/dXv+xvBkp3SAyanwZ6H0hC3is1c6wLeeCec1KB1su8uujmZuv3J2Wenbr9qa+Xl9+jvP59IBnhIJB0oHUF67tFiwZVIHeEq0B1U6QP9g2MAoHeBdV4TdnkoHeEjEl5QO0C7OYig9YT4u3kpZEcYAbHU9ujtbg3nbWU3T83eByj9xzufsRN5+BpbYiaXWiyULpLUx/CVSekL/6fBhIqUDnNURdiEpHWy7y77BUe4tc09U0r3toMi9VzrAlKg2qnSAC88Jn+5WOkCxEJ5qlJ7Qe1wsRIQO8M8/DNctUjrYXEuWWlDWMxBdHc3cekX+k8t5WBHGYD7FofLGGiy1/xO3wEyy3AKd7U2UVygoOFIrM4KtiJ4lC6lNbJWVDsjTv2mngtN6I6dhMaYviAlI6WA76NfbPzynoc/4RHqTeoBWcY8pHZhzr2bpUCq4l0cH5uyOsvSEbpEWq3SAKfEdVTrAv/1IFMQTOthqQVliNGBfIORhRRiD+RSHKl9hJrEGhWXi7Opo5s9u3TWrsuWf3borswZSe9kN1N6UPjbruQnL6UdLxonlNPFrzg7HR5Se8K+i3LPSwVZO2VJiw3IGAuBKMQkpHWDj6vDiQemgkyHSkiRaxWSn9IRbX9edSweYEIZM6WCLMzzyggikCx10T4W0XgtgT4/Pw4owBl0dzbz+3M5Z2uvP7ayozlDeWIPVt+cB5woUiw7nsj+W+fRnnkmlN1TocE21+ZvvvZBLBzgoJlWlJ3z+kYO5dCsjIpVW6ZDe3SsN9RvTjnVZahMVhYtV6QCbRHaX0hO+IXL2lQ4wKoym0gFWixPNSgfbbuKECLIrPWHJ9zNYLPQcGeDbPbODOt/u6cusHAn5Yw1J+mZzg6OtsUhzg8tM3zzTaP3MobOsFfuZ9ynQ1lSkuaE2/ZmhtOILNzPRk5NlxX50IHy9Sgc4IXz8Sk+wTE6WQ12WstzrRQxC6QmWhNRnjoTPICgd4DXnhMeudLB/TpYVu0qESkmQorVZuNiEDnBCFLFTOqQ3IMqi1guyFWEMrJk31lhD6TNy09/C7EC1dcXuk//1Z35Kw37OIH+6rKWMsKX0gHVn8EvXnZdLB9vJW4sBaRUHvpSeYDEGx0SGjdIBTo2EV7FKB3hJZMYpPcES4F7dGv47KR3guDAuSgfYIXpSKx1sQWewLcjysiLOGVgzb+bT3GZ0hhsgKyd/fu/jgcmK3gds5wws6bKnx8Ipg0oHOCAa0igdbKdAwbYLOXQiPEEqHWzNd77yg3BQ/ys/OMQNF2nf8g/FTlfpUPLZ9w/PXTKn+fIP9oevV+kAw2MiW0foCceF+0TpACeGxIpd6KD7RaT1kbAU+Ttf9LFWesIhsbhRuoUVsTNIKkfOJKtyJNgaUVhW+fV6Hys/ejm8+lA62GrKvDIY/rIqHZiT8pqlJ6T1Ga4mlhpNrwiDpPSEDpE1pHSwrbwLYkeodICzRJBd6QnWLKTcePELlQ70vBI26EoHWxtPsFd9zcOKMAaAqZlX3+Aon//+7IDi579/MNWXb6mD1Dc4yr178qWNWf3/eYvoATz1UnjSVzrAmAjWKR3gP4idmtLBVu8eYEwYC6WDrfSF5e+AEzer0pPfKU59KR1svvwWsWtQOkCDOE+g9IRREWhXOoATjjGlAxw/LdxEQgdbZd4jwj2o9FcfF6nISrewIoyBtfWgpYAc5D+bYN1N5PX/W4rogT4glXZ2wtKOcsfG8GNKBxgXpRaUnmCpg7T/pfD9onRgzqHFLB3g6Knwak/pCa+ICUXpYCt7PSrSpJUOcGpEdBITeoIlTfT0uHBRCh1sFXNV43ulA2xdF16sKT3hGZFerXQLKyJmYG97mT8k19s/TNE5JmZsRYouvXG1NW0sr/8/rYje9RdskK/bvFacDBY6lNpOhhp/pLWjfOmECDIKHWx+W4C1YvWmdLAZxWeOiC+x0MG24oRS3aejAb94Wj2oSzav5kevzM0cumSzzgwaEpOq0sHmjgLoWtXE4ZNzJ+SuVdrdaNn1DYgMIKUDPHcs/BkqHWw7HYDLNq/hwefmnl+4LKOHdB5WxM7AGkC2nAxubyrOKiYFMJpxAhls5TLyYunzCvDk4fDKV+kJoRPSaZwU41A62DKQAI4Nhld8SgdbsbVmceJa6WAvsWHJQrLk8beKeIfSwZ5aalmQqU1DymZCpmmm2SqL0bb2Obv2/PBiTekWVoQxSNpezqSStpfJyeCZZwayTgZbittZU1jzlpaw1AsC2ClS5ZQOpWsK7ULSrmnz2rBrQulg8w8DFEUEUukA3302XJBO6QBvv+ScXDrAy8K4KD3B4uowrdjVQiVlAWOZbAFOiLErHWxB5wYxfysdoE9kJykdbO1gwd4KNQ8rwk3UNzg6Z4v1veeO0zc4WlHT+TyuGOXayTq1bE0tzVNW+uJNq5ndRbW0vsoqjWw5pfrEwXAHqycO9nO52JE9K7IwlA7wjGjPqPSEwUA6ZZoOcFxkNSkdbCmsfUPhx5Q+H9qaipwYmXvNbSk72ZGJ8PUqHaClyTE0Nnfmb2lKN9oTEyJmIHSAcfGQ0ku/L58O8IowzkoHGBoVLjahJ6RVNq6kX3olrIidwYPP9gWrjz74rC41O5P+oTGeOTKQ2lAjwRLYtbymt38YX3ZNfspn7iYaypZH5T+H+KcnX8qlA3zx0fAuRekALx4XnbqEDrBJGEylJzSU+/8ydIDNa8Ofh9IBvv5k+GSp0gEmfdh/rPQES59hS3kElQiVliC1QXSeU3qC5WSweiTNUavCCWkZypaeHf/4+OFcesIh8b1WuoUVsTOwtANM+J2vPDErE+mOa7bykZsvTX3NTbs2c9E5q9l78AS7tqytyHLnfY0lNtHbPzxn+z81bUDSdzz5/bZToiKO0qHUBe3Qybmr37TuaINiRaX0hHJXXpYO0L2ujadfmZtt1L1Ob/GfFdkeSoekxs/cZWxa7R+AYXGgT+lg86+r2E9aTKi5Ifyg0s88XoDRuVamOcVoNzc5JgK7kOaUXUjRQWizkbZWOmdNG8eG5qZXn7NG3w/WE/PxnEGVsKyYwJ6SmrdFpOU1lr4JxwZGgtUws/qvvvv14Y5hSrdiyVp6NpAJk6YnrBLNRJQO8OxR8V5CBxgWBXGUDlAUhQqVnmDJ/1/bKg4HCh1sBwotZTnAlpK6XiwelA62OEOxELaYSgfmVBrO0hOahPFTuoUVYQysDSW+0xPOqFA62MpEW15j6ZsQSk1L0xN2b+/ijYEA/O7taWmiYQOjdIBnj4nJVuhgT8McEJOJ0sGWX28plzEqurQpPaFB7ByUDrBF5LcrHWBdWzjhQOlgr7dkcUmdFiUulA62LB9LWQ5je2vGROqp0i2sCGNgKU8L0CxS5ZQOtsYkFv//0NjknPvHkd5O0VKPP6E8INuTEaC1rM7Wt4fHoXSANWIFq/QES/qmcgeluYnahf9Y6QBrW8TKW+gJJ0dFaq7QwZYrf1IE2ZUO9t25cnClOQGPiWwepQOsFosHpQOcFGmxSgfoFAZT6QnKVZrmQs3LijAG5wg3g9ITLG0YLY1JLP7/8YnJOasWT/r7XHB2OGtI6QlfeewgL5edfn3p1BhfeUzX/lcxj7RYyE5RrEvpYPP9A7Q3hx9XOtgmDHUQOu2AtMW1BNAi/O9KBxgM+OPTdIDTYhxKB1v3MSuWVb6lhpSlaohlgVkvVoQxsG6xLG0YLQXQLOWeLQ1QLK0oAb4s4hdKB9gkDK3SAV4Qq1GlAzQVxZdY6AkHRKtKpQMcGxArTqEDnBgOu/qUDvbm8SMid1LpAK3is1c6wLjIt1Q6wIjYsSp9PqiRp93lg8I9qHQAFcJJC+28IuJzSk+IAeQqYT2luvdAOFde6WCz/JYGHhNie610gC+JlbzSEy7cGN45KB3gxyLIrnSAAeHOUPp8sLzX+lXhrbzSweYeUQ9leFRMuxBL6Wa1hkpbWwWOMqTq9cZyTVPiMaUDjIi4hdITYgC5SnQI/6zSE772eDiPXulgS3W0dMNqEM3HlQ62OjkA560PnzRWOtjqDFlKFjSKL4PSX31cVMtUOtjiDJadS7OwLUpPsKxUT54W/n+hA4yKnYbSwV6GoV44kfKsdLBdk6U1KcBzIhVZ6RZWhDF4SZR5VXqCJeBqqUVvSbvbIuIWSge44txwY3SlJ1jKHFgmW5UOn5ImzxFxMlPpCaaVoDj0pXRgTgHCLB2gUwS/lf7qOAwrVTXlpy3YLa+pJ5YJd0ysN5QONndUR4voOSH0hF7hvlS6hRVhDKzNQizphxefEw6QKh3gsRfDqZ1KB+gXq2WlA1zavTaXnqAO+KQd/BkUM7jSAZoaRRqm0AFePC76GQg9YUT4t5UO0CfKTigdQH0cafXZToldpNITLJO0MdOxbtRrfK0icUDpYDt8NyZ2T0pP6BBJCkq3sCKMwdXbwytfpSdYCoadELXMlQ5wUhgXpQNzqqlm6WAzbmAru2vxRa8Vbjulg62CJkBRTCdKB+S5j6x+EHmZFEt5pSdYyjAoO5tif1H7k+olOZ6hbsbKkBqkyiOllE3iiAgUKz1hWCwElG6h5sbAOXejc+5p51yPc+63xHPe5Jzb65zb75z792qPwepXfsOO9bl0sK2iXyNSO5UO8Nyx8MpX6QCjIu1U6QmWHOcLzg7vhJQOtpWtoVshACPCkCkdoH847BZTuhVzADmnDtAm3BNKB2gQsQulA6gs6YzK7mYfe15OjYRncKWDzU1kqYFUGofYLWZkmOWhpsbAOVcE/hJ4O3ARcJtz7qKy56wFPgXc5L2/GPiZao/DWuTpp1/XnUu3co4oQ6t0gHaR+qd0gEtESqzSEywNZCxB51PCd6J0gFWiYJnSExrEDkXpAF2i3ILSAdRZorQzRirbMisL0zI5WfL/CyLuo3SwNQZa9Bi2Yqo8UkbxVtaL2mFKt1DrncGVQI/3/jnv/RjwBeDmsufcDvy99/4AgPc+vTO0AUuaIyCrlKZVL7XkAw8I6650gG+LGvpKB3t9GIt7qVFkNSkdbHVovHAYKD3hYtHJS+kAJ8TnoXSAqanwOJQO9swby+q7oylslZQOzDktn6UDTIjHlJ6wmGMaFheb1UuxTSyilG6h1sZgMzAzib13WpvJBUCnc+6bzrlHnXN3hH6Rc+69zrk9zrk9R4/q2kAhrL7yB/aHywwrHWzduiyVDE+LE6JKB3v11meE0VQ62OpBNRbCs5bSQVfyzKrw2SJSO5UOMCjcQUoHGBHlP5U+LwxNZ4ZEuozSwXa4bWRUuOWEvhSYEr5IpQOMCH+Q0hMsBzLzkmoMnHO73Pz6L4ZeW37HNABXAO8E3gb8X865C+a8yPu7vfe7vfe7N2zI1+rtQuF7V3qCZULrEY1YlA62nPwLhe9d6WA/uKJqJKXVTrLUyR+dDK+wlQ7gRYBP6Qn7Dp3IpYOx3HNOfT4UxDUrHWBgJDwJKd1KvXz/9aS8UGSWDvZdnzU9Pg9Z9+SngWPOuX9xzv2ec+6tzrn0GXQ2vcDMOsfdQHkXh17g6977Ie/9MeBbwOU53iOTDlGWWOkJlh2FpYrmsQHRj1foAOdtCNfrUTrYy3JYguLPi0C20gGGxepI6QDjInVD6QmnhQNe6QAdIg6hdACVCJVx3tGE5fS7ZXKyZLLV82yCJavKgpo+0qYVqzGwutnykGoMvPe7KU3mfwCMAf8FeMY597hz7lMV/P5HgPOdc9udc03Au4GvlT3nq8AbnXMNzrk24CrghzmvIxVrQ4kNq0R3JqGDrShetygXrHRgTi+DLB1sJSwA2ppETSOhg21nsEYEpJUOtkkd4Ow14b+t0gHWiuqpSgdQGcUpmcZmBkVtB6WDbXKq58S+mMdnyfqyxkCs7TLzkLlb9d6f9t5/E/gL4L9Ryg5qB26s4LUTwPuAByhN8Pd67/c75+50zt05/ZwfAl8H9gHfBz7tvX/SdjlhrEWyLMXWLA2vLxOHvpQOcN3OsKtM6QAHhVtH6QkHRH12pYMtjfW8s0QGktDBFnQGWN0qypoLHWBIBIqVDvUtw2Dp/WvBmvq63FDhjrQwiNUYDIu5SukWUjerzrnbgTcAu4BRSiv9h4HrvPc6ijoD7/39wP1l2l1lP38M+FjFo87JS6eET17oCRa3iiUNc7MwFEq3slr4JpSesEGcJ1A6lCbVwbG5u4C0ydbiLmtqgNBcnNE4ipdFuQqlg60sR0sxXIwto/qAiQJhH3zaii/cYDN9clrsdYYWMwUXjjGlnVoGaGkqQqAfQ0sVU3OzPJd3Az8C7gK+5b3/cdXeuY68JFawSk+wBFwtpXA3ifMESgfYe/CE1FXPAMtqGKBPuHaUDtDe3EDJsxjSwwyJTCilA7Q1NnJqZO77tDVmXNOQOE0sdLAdGCo2FIJL5mIVq00mWIK0TQ5GA5NTVt57xEZjEUJlqTIavpmyB/OSdUeuAd4LtAC/N536+Y/Ouf/qnHtL1UZRY7ZvCLsZlJ5g8ctbJhlLPwNLx6Rjg2LlLfQzj+cvsf2KOLugdAB1BCHlaIJ5lepFnr/SrVhy0VvFxKD0+RAyBGl6ZH6cFh5FpSdYDknmJSuAPOm9f8x7/0nv/e3AO4B/An4B+JeqjaLGXCV69So9wXJid50IJiod4MW+cNqp0gEeFT0VlA6wrSvsdlJ6wnFhLJQOcI6o7Kp0gHUdoreu0AEuEYfElJ6gEmyq3XBqSKRoKr00hvzlySPLmwVve+mcu2w62HuPc66HUszgeuATlLJ+lgSWgnNga+9niRlYUgIP9okMKaGDdtGkuW4A1neIfsZCB9gk+gIrHeCUqKGvdIDNa0S8RegJ1jpNeVHOwbTw9piIxCo9snRoE181pSdYe0jnIWup8TfAJZR2Azd477d67/+T9/4vvPd7qjaKGrPnhfBqWekJTws3jdLB1ie3X/jelQ6wRazmlQ721nmXbl6bSwd4QZwnUDrAhKjKqXSwnRIHUHN+lW2BicWerbOYS0Qsdix9NACOinL7SreQao+896+r2jstIKNiJa/0hO/2hMtefLfnKP/H9TuCjx0XfnSlW7lia2cuHexbzR++HO6rrHSAKTGBKx1gUhygUTrY4yAtjQXGAjmALRn9oOuButwqni+aFzGbyI7VGEyJNAClW8hyE+0T/z3hnNtXtVHUmAlxmyo94eip8ISidICv7z+SSwfoFimkSgd4TMQGlA62lpwAL4l0S6WDzfU1JBrfKB3sB4ysvWjrwXIs3RApYf1srUYkD1mppVOUDP7ngH8AqtdjrY60iuJjSk/Yur6V/QGX0Nb1+tBZq1hZKh1sk/SLIjagdIB9Ih1V6QkF4QBQOtgK9g2I0zpKB2htcAwHSk+0NqQ7LSwHtJqLEMrky6iWHYnMG0txwLxkZRPtAm4DOigZhD8ALgYOee9frNooakyjmBiUnnD2alGyQOgAzSJhWOkA338+3N5S6QBnrQpn5Sgd7NVbXyuyp5QOtqYzljo+hYIozib0BHW0Iu3IhUrprmKq97yoZ1G8SH2ph2uuknIUP/Le/+50/OAfgHuAD1RxDDXHiRWs0hPaxOk+pYOtNaLFV36+OFimdIBRUU1R6QlvOC/cHlTpAONi/6p0gMu3rM2lA7SKw2VKTyiIYrxKXwpE91JkPmQaA+fcZufcbzjnvgP8HCVD8Fc1H1kVGZsML92UnjAgqokpHWCNWFoqHeCmy8/JpQO8ItJilQ62EgwAzwnXk9LBVt73ZOC4fZoOsF4Ev5WeYOnwFbETM5Dmh9ocV7P4bVYA+d8p7QYagf8M/O/A/wc0OefSu8kvIqypeo/3nsilA1y3M9wfWekAL4hJVemlMZzMpYO9wuelm8IHuJQOtjaHB0QVWaUDHBU7LqUnOHHrKz0yP2IG0jypgzXNMiznUvq8fplSWYqZQ/DAedUbSu1wormH0hPaRWRQ6QDPiCY2Sgd4WMQGlA62OkMXbOzgyMDc33nBRt0DAeC5Y+FOaEoHaBAlO5QO0NJY5HSgcEtLSrzFWs1xTBQUUnokspC0NhYYCGS6pSWm5CUrgLzNe799+r/zZvy33Xv/qiFwzl1ctRHVAEudHACVEp+SKs/+Q+Hce6UDXLU9vMlSOtiyls4/S8QZhJ7w4HN9uXSwxWlaxa5B6QBrhfFTeoLlZHAkslBYDmTmpVpm5W+r9HtqgqU5O9jKWFjKHFtqBr0oTvIqHeCF48IdJfSEPlFCWulgy+CyGO2TgYqlafpyph5+5cjCUI8mSdUyBssyDnTZ5nDqpNJL5M/p+Pz3D+bSAQ6fDE/gSgdbPaMS+a/JdKjL4FhWRzGq2ABqyaAueQX+KSIGqmUMFnUcyBp7aRcJ7koHWC0K0ikd4PAJMbELHaBYCH90SgfYeVY4NqD0hBbRKUbpAANiNlY6QJOo66x0WPylGyIl1N2f7syzETOXbKyI1InDInVS6QnPHRWBU6EDqMzE9IzF/MeFNovWm0oH2Coqhio94bVnh7OGlA4wJuo+KR3AizWF0iPzp14H1Qoi7KP0BJWrEU99V59qfeaL2kE7JMoZKD1BtZRLazVXEM0mlA6wVtSvVTpAmyg7rXRI746WxvN9YeOndNAZQOmZQfl0iCmL86VeB9WmxBpA6QnqKFDaEaF4T9jIOmdwlnPuz6e7m/2hcy64FPTeX12b4VUHSwctsLWjXNcmKoMKHeD128JZQ0oHuPHijbl0sJewtrixrOm8eYklGJYG1oKCMQ5SP7K+M/cAQ5Sa2XQAH6/5iGqAdYs6IlwaSgc4KiZWpQO849LwSWOlAzSIIntKBxgJNV9N0RNWt4QNmdIBBsWuS+kATeJuVDrEEgzzRd0taV8Ni08+fk6LnyxjcLb3/r967x/w3v8acFk9BlVtvJi7lZ7wI1GvX+kAOzeIIK3QAb7bcyyXDvDlH4QzjZQO0CRcNEpP2CJiCkoHaBIppEoH24QRXQLzw7JitxiQyOInyxg451ync27ddPmJYtnPSwLrhHFU5LcrHWyHQ+5/4qVcOsDeAydy6QAbOsIVTZWeYCmx3S4yjZQOtkN+kfoTXTfLk6zzKGuAR5m9A3xs+v+XTDkKc3chUcFS6QAPi1O5SgcYGBFpmEIHW6VTy/sAOB/+QykdYFKkTykdoKkIw4ElaUq8PjKDBsITcjx0FqmErLaX2+o0jppizTueFKkOSgc4JgqkKR1sFTTbmho4MTJ3HG0pK2/lDcrwEqHK9aSV8bHEJ2xpuZGEuGKPzIesbKKfm/Hva8see1+tBlVt1DmslPNZgC2trWtVONNI6QBTYjWvdIB2kUKqdIAhUbxN6Qnj4oKVDrZKsSPiMaVHIpHqkRUz+PUZ//5E2WO/WOWx1AxrCevNa8MTuNIBtojHlA7Q0RJemisdoEGcW1A6wKhYyis94aUT4VpMSgebIY1EIgtHZgBZ/Dv086JF+ZyzfNEDop+h0gEOiQlS6QDtolSF0sFWwnr9KtEIRugJFjdRdFlEIkuLLGPgxb9DPy9aAq71VD3hhDj6qnSwnU3wwh2kdIBtIq1T6QDHB8NTsdITrLGGSCSydMhKNHiNc24fpV3Ajul/M/3zksgkmg9tjUVOj82dKNtSZkFLGmufaOuodICnXg53NFM6ELyWND1hdWsTw4Fy1atb9Y6isRDeOaT14uhsK9J/eq7R7GyLVicSqTVZxuC1Ac0B3cBvV384i4uzOpo5NjR3ojwrIy8/Lxb//xFx1kHpABtXN/PK4NxJfePq9Otpay7CgNDVa5oKnAxEfttSjhMPhfJKU/RIJFI9sjqdvZj8B3QCvwp8E/h94P5K3sA5d6Nz7mnnXI9z7rdSnvd659ykc+6WyodfGdb6NS8PhCdWpQNMiMMLSgdoaRBF3YQO0CweUzrAReeEq4wqPeHU6fAORekAeGHIlA6Mie2T0iORSPVI3Rk45y4A3g3cBvQB/wNw3vs3V/LLnXNF4C+B/xXoBR5xzn3Ne/9U4Hl/DDyQ+woqGUdOPcHiy7cctrLEJiw9hp96KVxGQ+kJp06H3UhKBzgtYiRKj0QiC0vW4vhHwA3AT3rvr/Pef4LsQoMzuRLo8d4/570fA74A3Bx43q8BXwJeyfG7K8ZajsJSjnpdu6haKnSAVnE2QOkA/aLwndIBDokqo0p/FcvWKhYNikSWFFnG4F3Ay8C/Oef+2jl3A/lSSjcDMyun9U5rr+Kc2wz8NHBX2i9yzr3XObfHObfn6NGjOYZgr5g4LAKrSgcYEfmWSgdoEOUtlA62Xgvjk+GZWOkJKls1ref8hPiVSo9EIgtLVszgy977/wS8hlKs4APARufcXznn3lrB7w/NZuXTwZ8DH/Y+vYao9/5u7/1u7/3uDRs2VPDW80d5NNI8HcPiQaUDnBoRPnmhAzSK+ttKB5gStYSUfuZxUaMpxf8fNwaRyNKioh4g3vsh7/3fee9/glIm0V5ABoNn0AtsmfFzN3C47Dm7gS84514AbgE+5Zz7qUrGVWss+fVNDeE/qdLBVuHTOVE8TugAY8K2KD1hUuwclB6JRJYeuRtCee+Pe+//H+/9Wyp4+iPA+c657c65JkrB6K+V/b7t3vtt00Xx7gN+xXv/lbzjqgWWnYHFvb69K9y3WOlgMyCN4iGlJ1iazsem5JHI0qKm1W299xPTBe0eoNT74jPe+/3OuTunH0+NEyw0liqalmJwzxwN9xJWemkMItMpZXAW41b6nfl0iG6iSGSpUfNS5977+yk7k6CMgPf+P9d6PHloaoCJQKw4ZfFt6vC1pqWRQyfnnl1Yk1Kb6CVxuEzpACoJKiU5CrD3r41EIkuH2Dc8BUtTnKLIAFI6wNCE2E0IHWxlpVe1hK2Y0hMaxdCVHolElh7RGKQwJiZ9pQOcGhWZQUIH6BsIVzRVOkCLcPQrHaC5KE4tCz0hNjOPRJY/0RhUG4Oz3Jb/n/+Njg2JLmxCT7AYxUgksrSIxqDKWCb2ovgUlA4wKIq3KR1AdetM6eIJwKqmsD9I6ZFIZOkRjUGVsfXxzZ+IaUn3VFVG06qPApy9JpziqvRIJLL0iMagylhcKpaCeJbUTUvdJJhHTaNIJLJkiMZgEeDEp6B0sAV1j5wazqUnqErVaRWsI5HI0iIag0WAZbJtE4t5pQOMiPp6So9EIiuHaAyWKB1N4Vlf6WCrPhqJRFYG0RhUGUtNnlYRv1U6wOlx0c9Y6GA7RBeJRFYG0RhUGUtgt0GcE1M6wMSkaK8pdAD1UMpLgFJRqTx6JBJZekRjsAhQZ77SzoKpuncp9fBMJbkBWoTnSemRSGTpEY3BIsDiWlINzVIanZmrlo6ITppKj0QiS49oDJYoqu5dSj0800E1iFVLI5GVQDQGiwBLnEG1YU5pzxwLzkUiEUk0BosAyyRt7VoWiUQiIaIxWARYYgbWonORSCQSIhqDRYBqgpbSHI1RsW1QeiQSiaQRjcEiYFwEB5QeiUQi1SYag0ikQizuvEhkqRCNQSRSIe2imY/SweYCVDkAWbkB6sscv+SRSoj3SSRSIZYudpZmR2vbw9O+0l/9nTn1SGQm0RhEViT1cvlYJuiC+FoqPaGtMTx6pUN0fUXOEI1BZEVicam0iVofSgcoiFlV6QCnRJ0PpSe0iiJTSge7Syqy/AxpNAaRFYmlttPp0fAhDqVb38c6zYxOhPcbSgdoFf2vlQ6xim3CcnPLRWMQWdKovjxZ/XraWsJrX6VbcaJ3qdIBmsQQlJ6wSoxd6QCrWsVrhA7QLP64Sq83Kp6fEuePEI1BZInT3JxPT/Aigqt0sDUH8j78oNIBisXwGlvpCQ0iRUnpAE5crtIB2oRVUvp8sOxC6nVuJ7qJIpFFRHMxPAEpPWFUzOBKB1v1VpVolJKAxLBoSq30hKKYhZQONgNSKIgAt9ABlNcpxRsF2P7m9XLfLDd3WTQGkSXNsCjTqvSECTEbK92KCiekhBkYF/ZI6QknTo/n0gH6h8JBaaUDjIgOSkoH2LSmJZc+H1TyVEpSlQl1h6XfeYuXaAwii4YWsaRSOoBaLGcsos1++cXMsJiMlQ62VqhFMWsoHWBwNPyBKD2hTXweSgdbRz/L4UCLm2gxZ2/V3Bg45250zj3tnOtxzv1W4PGfdc7tm/7ve865y2s9psjixJIaaUndBFurUVNHOvENUzrYy5NbOtk1FMI7IaWD7SBd/+nwpK/0hB0bOnLpAMq+pNmdJjHrKx2Mrq9FHGioqTFwzhWBvwTeDlwE3Oacu6jsac8D/4v3/jLg94G7azmmyOLFi6il0sHut7X0kLCcTWgSGTZKB2gUvnelv/q4YUU8JtxiSgcYmRBuIqGDLXYC8Nyx07l0sMUZVotUKKWDLTahsnxTsn/rRq13BlcCPd7757z3Y8AXgJtnPsF7/z3vff/0jw8B3TUeU2SRYlnZ1rN7m+XLf1rsNJQOMDIWHr3SEybF30npAA3Ct6N0AJUIlZIgRaP4dUpPGBKBEqVbGRgLx0iUDrbdxGKm1sZgM3Bwxs+905ril4B/Cj3gnHuvc26Pc27P0aNHqzjEyGKhUaS9KB2o68kfi7/XMjwV7tVhYPvrLLuQFjGDKx1gSszdSk+wZEi1i0ix0sFm4Kamwr9P6bCovUQ1Nwahawx+D5xzb6ZkDD4cetx7f7f3frf3fveGDRuqOMTIYqFBOPqVDtAgXCBKnw9efFuUDvVNP7S4sU4Nhx3pSgcYFB2UlA72zJsWEVxROmCacRvFDaN0gClhyZQOi/vUcq2NQS+wZcbP3cDh8ic55y4DPg3c7L3vq/GYIouUcZHConSw+6ItgV3LxN4kVqNKB2gQY1B6gmXVaTmgZfHJmzEs2cfE4JUOtgypDnGyW+mwsncGjwDnO+e2O+eagHcDX5v5BOfcVuDvgZ/33v+4xuOJLGLGhB9Y6QDKjZ7hXje5LSyrujYRvVV6aRA59WnqOknXCVWbL61mn2WB0C4i+koHWNvWlEsHUA+lvKRu1DS91Xs/4Zx7H/AApQXUZ7z3+51zd04/fhfwO0AX8CnnHMCE9353LccVWZwMi1lL6VBaUYW+41krLYvbwtJ3+qQ48KB0WNyuhHpjMXAFB1OBP1ZaunFXRyMHT4wEdcWq1vBjSgcougIhq15MqVVVL2p+1sF7fz9wf5l214x/vwd4T63HEVn8WCf2elEkPAmluYks5yAai+EMoLTNROQMzQ0wEYiaN6fMdpbDd+eua+OxAyeDuiJkpNL0erLw5igSmaZVbJWVDvVdRVt8+e1iBlI6QFGkyig94az28IpU6fVEDSFraJYMrmZxOk/pJfJ78zetbc2lA1x8zqpcej2JxiCyaDgt/MBKnw+WQF5ne9gqKR1gZDzsDlI6QJuYtJSeMCmOACsdbBlIlteoy035MwC2bKJO4YBXOkCzCOgrHaC7M7wDUDpAZ0e4nK7S60k0BpEVSYeYTJReIv8+RPmC03zEo+Ikr9ITLNlYyr2d4vY2Zd6MiT+R0hM2rApPkkoHuGRTeJWtdLC5iVa1iJiB0AF2n7sul15PojGI1ATL6rGeaXcd4gurdICTIvde6QDrhB9E6WBb4QOMiqwrpYMti8YSB7EcHgPYtEa4YoQO8OMjg7l0sKbz5l8cvOnCs3Lp9SQag0hNsEzsFv+/1YCMT4QncKUDrBNuBqUDFMVJXqUDdIh6OEpPsJSWGBO5tEoH2+HAK7aszaUntIuqb0oHGBL1wZUOUBA7NaVbOXxyOJee0CouV+kWojGI1ARLSqClhaWl9DBA/+nwSJQOcEqkgyod4LQoH610gM2d4Rr/Sk84Z234caWDzbVk6XS2cU3YraP0V3+nCLQrHeBtF2/MpQNctGl1Lh1gtchsUHoJ2/KlHjW4ojGILBrUIixtcWYJ/IHNjdUsLIzSAVYL57vSS78vvNxTesLubcIfLXSAVWLiUjrAhRvD5aOVDrbOcgCT4qSY0gE2r2vPpQPsWB9+TOkAF29aPceN1FAo6Yp6NvnJSzQGkUWDqcdwTj2hURgLpQPc8NrwylLpANu6wpOJ0gHeeck5ufQES+3/K7d25tLBtuvbuTEcvFV6wtaucGaO0gHWi8wcpQPsOdCfSwfo6mjm9iu3ztJuv2orXSnvMzQ2OSdOUnQlPY0OsRNSuoVoDCI1wZIfbtlAD4l0FKUneHHKR+kAW8UErnSAN78mHBhUOsDW9eHJW+kJh08If7TQATYKF5LSAS7YEJ7AlQ7wFhEgVXrCT/+HcEV7pQNcs6OLYln8olhwXLOjS77m4k1rcukAfYOj3Pto7yzt3j299A3q+uTtTcU5ZTEmfUlP4/Ui20jpFqIxiNQGw8xuWXFaCs4BbBDbcqUDrBPnCZQO8NaLz86ll7Dtd8aF60TpAG+7KDwOpQOcJf5GSgc4LZpSKD2hs71pTpZSwaWf7ejqaOZnr9oyS/vZq7akrtjfLIyS0gF6+4fnlPpuLBTo7dfGd2hsck6p75bGQubOYItwVyndQjQGkZpgrSZaL64QbhClA2wWh4mUDqWJ6ePv3kVjodSXobEAH3/3rtSJ6eJNa+b0cGgsutRVKsBP7dqUSwfYLlxISgc4V7holA5wajjcVUHpCfsPn5xTqmHKl3RF3+Aon//+wVna579/MHXFbpmkuztbGS/LuhqfmqK7U6e9qsfSXgNw9fbwDkDpFqIxiNSEeqWJWmMGO88SPmyhgy1gCHDTrs089Nv/kfvufAMP/fZ/5KZdaf2dSgbkT3/mcpobCrQ1FWluKPCnP3N5qgEB2L29iws2zl4pXrixnd3btXtETappk+01O9YHV+vX7FgvX2PLvAHLXbH/8Mk5u6HxSZ96TZZJuqujmY++6zJaGgusam6gpbHAR991WernZHkN2Pot5KXmheoiK5NGF66Jn5bkUyDsEkpbsVg7aF0lVlRKh9IX+c9u3cUH73ucoisw6af42C3Zk3Ty2kqel3DTrs1cu3M9vf3DdHe2VvTavsFRDhyf7aJ48fgwfYOj8vWWFXtXRzPX7uji2z1nWo9cu6MrY7ezek4hQke2IU0M8MwkgiwDbGnYk0zSH/rSPhoLBcanpiqapC2fk+U19ajCtSKMwapmGAjsEFNOtEfmiaXxtyVmICoCp6ajQmlFVXSz3VZFl73Ssn2RbeQ1IIkPe2TGHyTxYavfY1mx9xwZmGUIAL7d00fPkQGZHdQ/NDZn2vLTetZK+vYrt3LPQwde1bIydqxYP9u8n5PlNYnrcOaOpxLXYR5WiJuons0HI2Bbx1g+pdUt4UeVntDd2Upjmc+nsaGQ6buF0hf58i1ra2oILFh82GqFnbby/k7PsVy69TVQ2u187vsHZmmfe/hAqv/fcrYjYbF+tlbXYR5WxM7A2kYwUl+aGiC0k0852EpDIdxloKRrrG6BxYzlmvqHwiVh01bs6zvCuwallx7Ln/sPsP/wqTnnTCamSvr1F4R7oVtcS0uBWu9KV4QxaG5oIDRhlPTIYsFy6MxSJyehni6fepH3mvYePCF15fJ5zdnhSVXppcfU70o/dHZqOGyslA7zi+0sdiwuqUpZEbPheevbeTkQNDivijm6kflj6H3OlnVtHD4197PdktJtaia1/HItFHmuaZcoFKd0OJOGOTKjGmpWGqblNWB3+SxHQ19rVoSj5CdFnrXSI/NHZQ2lZhOJuzGlwCe3Xbkllx6Zzc6Nq7jjmtklFe64ZmtqmYjuzlYmy5L/J6d8TfLrrWcuYPH6/xcrK8IYvPXis+dkJTuyToFG5oMlm8jSNGWd+KIrPTKXj9x8Kf/zA9fzJ7dcxv/8wPV85OZLM1/jy3orlP9cThLPmBkArSRGU4/AaaTEinATdXU08xfv3sVvfvFxPCVD8Cfxhqop9etNXM+WOMuXnRtXZRaNS+jtH6a1sYGB0TPR/tbGhtQUVkg+ew++/MRBOtHlUx9WhDEA2w3VAISOqayYP9o8aC5CqJdISk8SkwFZrpkjixlLCmvf4Cgf/tI+Ric8STLHh760j2t3rq/Job1IflaEmyghrw+xWWTKKT1yBku/gPKiX1k6nMkcaW5wtDUWaW5w/Nmt6bV/IvPDUlLBUtQtUl/iIjeFjuYmhsbmprB1rDBrYNkhqQ6DKZ0HWdPayMDY3MygNTFzZNGR929u2U1E6suK2hnk5UYRYFb6ckVVdNGVXmwun/7h8KlSpc8kZo7Unzx/c2uBtkj9iDuDFG646Gz++0MHgroixhlKFFy4XHXaWbA1rc0MBXcGccJYDsQd3OIm7gxSsJQsbhcRUqXD8qycpDw7aR6fn7xMnAcRemTpEXdwi5doDFKwBCe9Cx+XVTqAE6tlpUN9EyrbxLZG6QBOlA1VOsC154drzSg9EolUj5XmvchN3q1tQ6EBmFsLvqSr18BEILCaVkiv0UGozW/aCV8ryoyltQxoaywyMDr3GW2Ner8T00QjkYUj7gwqIM/W9uevCpdBUDqAKs+SVralKOZUpYN9NzEpxqF0gK3rRPN4oUNME41EFpK4M6gyH3jba/nUN5+b1eWr0ZV0RUsjnA40lmpJ8a8Xiy5Y26FY1FN7R7NjYHTuazqa081Be3OREyNzZ/60OMjZojm60hNikDESWRhqvjNwzt3onHvaOdfjnPutwOPOOffx6cf3OedeV+sx1Zpn/vCdvP/N57Gtq433v/k8nvnDd6Y+f1d3uAm70gGGQz6iFB3AiSCE0hPO3xhujq50gB1nhR9T+kxikDESqT81NQbOuSLwl8DbgYuA25xzF5U97e3A+dP/vRf4q1qOqV584G2v5ZsffHPqjiDh1996YS4dYHVL+KNTOkBBOISUnnClaKiudIC1beGDeUqPRCILS613BlcCPd7757z3Y8AXgJvLnnMzcI8v8RCw1jl3To3HtajYvb2LN+6cPbG+cWcXu1Mm2xsvCadbKh3gepGVo/SEN194Vi4d4Lqd63PpkUhkYam1MdgMHJzxc++0lvc5OOfe65zb45zbc/To0aoPdKH52/dczX2/fDX/5S07ue+Xr+Zv33N16vN/6brzcukAt7w+HMRWekJjQzFYUz6tebylTn4kElk4ah1ADvkfyp3alTwH7/3dwN0Au3fvrn4l5EXA7u3pu4GZJJPtPQ+eOSGdNdkmjULGZxwNrqRRSHdnK8XC7NcVCy6zrsxHbr6UO67ext6DJ9i1ZW00BJHIIqbWxqAXmLns7AYOG54TCZB3sk0ahXzwvn0UC47JKc/HbqmswYi1eXyeOvmRSGThcFkdiub1y51rAH4M3AAcAh4Bbvfe75/xnHcC7wPeAVwFfNx7f2Xa7929e7ffs2dPzca93OkbHDWlblpfF4lEFgfOuUe997tDj9V0Z+C9n3DOvQ94gFKpnc947/c75+6cfvwu4H5KhqAHOA38Qi3HFLE3CokNRiKR5UvND5157++nNOHP1O6a8W8P/GqtxxGJRCIRTSxHEYlEIpFoDCKRSCQSjUEkEolEiMYgEolEItQ4tbRWOOeOAi8aX74eOFbF4SwF4jWvDOI1rwzmc83neu+D9WeWpDGYD865PSrPdrkSr3llEK95ZVCra45uokgkEolEYxCJRCKRlWkM7l7oASwA8ZpXBvGaVwY1ueYVFzOIRCKRyFxW4s4gEolEImVEYxCJRCKR5WsMnHM3Oueeds71OOd+K/C4c859fPrxfc651y3EOKtJBdf8s9PXus859z3n3OULMc5qknXNM573eufcpHPulnqOrxZUcs3OuTc55/Y65/Y75/693mOsJhXc12ucc//gnHt8+nqXfOVj59xnnHOvOOeeFI9Xf/7y3i+7/yiVy34WOA9oAh4HLip7zjuAf6LUae1q4OGFHncdrvkNQOf0v9++Eq55xvO+Qal67i0LPe46fM5rgaeArdM/n7XQ467x9f428MfT/94AHAeaFnrs87zu64HXAU+Kx6s+fy3XncGVQI/3/jnv/RjwBeDmsufcDNzjSzwErHXOnVPvgVaRzGv23n/Pe98//eNDlLrKLWUq+ZwBfg34EvBKPQdXIyq55tuBv/feHwDw3i/l667kej2wyjnngA5KxmCivsOsLt77b1G6DkXV56/lagw2Awdn/Nw7reV9zlIi7/X8EqWVxVIm85qdc5uBnwbuYnlQyed8AdDpnPumc+5R59wddRtd9ankej8JvJZSu9wngPd776fqM7wFo+rzV82b2ywQLqCV59BW8pylRMXX45x7MyVjcF1NR1R7KrnmPwc+7L2fLC0clzyVXHMDcAWldrOtwIPOuYe89z+u9eBqQCXX+zZgL/AWYAfwL865b3vvT9V4bAtJ1eev5WoMeoEtM37uprRqyPucpURF1+Ocuwz4NPB2731fncZWKyq55t3AF6YNwXrgHc65Ce/9V+oywupT6b19zHs/BAw5574FXE6pH/lSo5Lr/QXgj3zJmd7jnHseeA3w/foMcUGo+vy1XN1EjwDnO+e2O+eagHcDXyt7zteAO6aj8lcDJ733L9V7oFUk85qdc1uBvwd+fomuEsvJvGbv/Xbv/Tbv/TbgPuBXlrAhgMru7a8Cb3TONTjn2oCrgB/WeZzVopLrPUBpF4RzbiNwIfBcXUdZf6o+fy3LnYH3fsI59z7gAUrZCJ/x3u93zt05/fhdlDJL3gH0AKcprS6WLBVe8+8AXcCnplfKE34JV3ys8JqXFZVcs/f+h865rwP7gCng0977YIriYqfCz/j3gb9xzj1ByX3yYe/9ki5r7Zz7PPAmYL1zrhf4XaARajd/xXIUkUgkElm2bqJIJBKJ5CAag0gkEolEYxCJRCKRaAwikUgkQjQGkUgkEiEag0gkFedc13T1z73OuZedc4em/z3onPvUQo8vEqkWMbU0EqkQ59zvAYPe+z9Z6LFEItUm7gwiEQPT/QL+cfrfv+ec++/OuX92zr3gnPvfnHMfdc494Zz7unOucfp5Vzjn/n26eNwDS7xKbmSZEY1BJFIddgDvpFRa+LPAv3nvLwWGgXdOG4RPUOqncAXwGeAPFmqwkUg5y7IcRSSyAPyT9358uiRCEfj6tP4EsI1SvZxLKFXUZPo5S7kWVmSZEY1BJFIdRgG891POuXF/Jhg3Rel75oD93vtrFmqAkUga0U0UidSHp4ENzrlrAJxzjc65ixd4TJHIq0RjEInUgemWjbcAf+yce5xSM5Y3LOigIpEZxNTSSCQSicSdQSQSiUSiMYhEIpEI0RhEIpFIhGgMIpFIJEI0BpFIJBIhGoNIJBKJEI1BJBKJRID/H3dPGz5I/uCQAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "\n",
    "df.plot(kind='scatter',x=\"Time\",y=\"AEP_MW\")\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "abe29c9e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "LinearRegression()"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import sklearn.linear_model as lm\n",
    "lr= lm.LinearRegression()\n",
    "lr.fit(X,Y)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "c4bf5830",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "enter time1223\n",
      "[-1.07687768e+08]\n"
     ]
    }
   ],
   "source": [
    "import datetime as dt\n",
    "Time=int(input(\"enter time\"))\n",
    "# df['Date'] = pd.to_datetime(df['Date'])\n",
    "# df['Date']=df['Date'].map(dt.datetime.toordinal)\n",
    "\n",
    "mrks=lr.predict([[Time]])\n",
    "print(mrks)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ab8e8136",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "dfcc87e0",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle\n",
    "pickle.dump(df, open('finalmodel2.pkl', 'wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6b10f559",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "eeccfc5b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1a3c5fd7",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}