renewables_data_cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#Import statements for pandas and numpy\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\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>Hour</th>\n",
       "      <th>Geothermal</th>\n",
       "      <th>Biomass</th>\n",
       "      <th>Biogas</th>\n",
       "      <th>Small Hydro</th>\n",
       "      <th>Wind</th>\n",
       "      <th>Solar</th>\n",
       "      <th>Index</th>\n",
       "      <th>Solar_num</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1056</td>\n",
       "      <td>323</td>\n",
       "      <td>170</td>\n",
       "      <td>250</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>1055</td>\n",
       "      <td>318</td>\n",
       "      <td>169</td>\n",
       "      <td>245</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>1058</td>\n",
       "      <td>316</td>\n",
       "      <td>168</td>\n",
       "      <td>240</td>\n",
       "      <td>677</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>1063</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>238</td>\n",
       "      <td>923</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>1066</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>247</td>\n",
       "      <td>875</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>169</td>\n",
       "      <td>247</td>\n",
       "      <td>998</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>1066</td>\n",
       "      <td>312</td>\n",
       "      <td>166</td>\n",
       "      <td>244</td>\n",
       "      <td>763</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>1067</td>\n",
       "      <td>313</td>\n",
       "      <td>167</td>\n",
       "      <td>269</td>\n",
       "      <td>544</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>1065</td>\n",
       "      <td>315</td>\n",
       "      <td>169</td>\n",
       "      <td>280</td>\n",
       "      <td>572</td>\n",
       "      <td>191</td>\n",
       "      <td>10</td>\n",
       "      <td>191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>1063</td>\n",
       "      <td>316</td>\n",
       "      <td>167</td>\n",
       "      <td>294</td>\n",
       "      <td>721</td>\n",
       "      <td>299</td>\n",
       "      <td>11</td>\n",
       "      <td>299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>1063</td>\n",
       "      <td>314</td>\n",
       "      <td>169</td>\n",
       "      <td>294</td>\n",
       "      <td>658</td>\n",
       "      <td>278</td>\n",
       "      <td>12</td>\n",
       "      <td>278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>171</td>\n",
       "      <td>271</td>\n",
       "      <td>772</td>\n",
       "      <td>198</td>\n",
       "      <td>13</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>1068</td>\n",
       "      <td>324</td>\n",
       "      <td>171</td>\n",
       "      <td>270</td>\n",
       "      <td>1012</td>\n",
       "      <td>126</td>\n",
       "      <td>14</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>1066</td>\n",
       "      <td>322</td>\n",
       "      <td>169</td>\n",
       "      <td>282</td>\n",
       "      <td>1350</td>\n",
       "      <td>139</td>\n",
       "      <td>15</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>1067</td>\n",
       "      <td>326</td>\n",
       "      <td>170</td>\n",
       "      <td>292</td>\n",
       "      <td>1489</td>\n",
       "      <td>111</td>\n",
       "      <td>16</td>\n",
       "      <td>111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>1070</td>\n",
       "      <td>324</td>\n",
       "      <td>160</td>\n",
       "      <td>294</td>\n",
       "      <td>1475</td>\n",
       "      <td>39</td>\n",
       "      <td>17</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>1071</td>\n",
       "      <td>320</td>\n",
       "      <td>147</td>\n",
       "      <td>295</td>\n",
       "      <td>1518</td>\n",
       "      <td>25</td>\n",
       "      <td>18</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>1070</td>\n",
       "      <td>320</td>\n",
       "      <td>148</td>\n",
       "      <td>297</td>\n",
       "      <td>1511</td>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>1070</td>\n",
       "      <td>314</td>\n",
       "      <td>153</td>\n",
       "      <td>302</td>\n",
       "      <td>1356</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>1072</td>\n",
       "      <td>299</td>\n",
       "      <td>151</td>\n",
       "      <td>305</td>\n",
       "      <td>1083</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "      <td>1072</td>\n",
       "      <td>300</td>\n",
       "      <td>124</td>\n",
       "      <td>307</td>\n",
       "      <td>1126</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>1071</td>\n",
       "      <td>277</td>\n",
       "      <td>123</td>\n",
       "      <td>297</td>\n",
       "      <td>1024</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "      <td>1071</td>\n",
       "      <td>284</td>\n",
       "      <td>126</td>\n",
       "      <td>266</td>\n",
       "      <td>1017</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "      <td>1072</td>\n",
       "      <td>284</td>\n",
       "      <td>140</td>\n",
       "      <td>245</td>\n",
       "      <td>1018</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1072</td>\n",
       "      <td>285</td>\n",
       "      <td>145</td>\n",
       "      <td>253</td>\n",
       "      <td>1055</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>1072</td>\n",
       "      <td>280</td>\n",
       "      <td>142</td>\n",
       "      <td>253</td>\n",
       "      <td>938</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>1072</td>\n",
       "      <td>277</td>\n",
       "      <td>153</td>\n",
       "      <td>254</td>\n",
       "      <td>864</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>59</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>1073</td>\n",
       "      <td>275</td>\n",
       "      <td>167</td>\n",
       "      <td>255</td>\n",
       "      <td>828</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>1074</td>\n",
       "      <td>282</td>\n",
       "      <td>164</td>\n",
       "      <td>263</td>\n",
       "      <td>843</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>61</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>1074</td>\n",
       "      <td>286</td>\n",
       "      <td>163</td>\n",
       "      <td>274</td>\n",
       "      <td>850</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22806</th>\n",
       "      <td>51308</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>2928</td>\n",
       "      <td>2239</td>\n",
       "      <td>16505</td>\n",
       "      <td>6758</td>\n",
       "      <td>2622</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22807</th>\n",
       "      <td>51309</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>2925</td>\n",
       "      <td>2240</td>\n",
       "      <td>16105</td>\n",
       "      <td>7221</td>\n",
       "      <td>2572</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22808</th>\n",
       "      <td>51310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>2917</td>\n",
       "      <td>2240</td>\n",
       "      <td>15448</td>\n",
       "      <td>7423</td>\n",
       "      <td>2542</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22809</th>\n",
       "      <td>51311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "      <td>3155</td>\n",
       "      <td>2240</td>\n",
       "      <td>14137</td>\n",
       "      <td>7683</td>\n",
       "      <td>2404</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22810</th>\n",
       "      <td>51312</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>3055</td>\n",
       "      <td>2242</td>\n",
       "      <td>13259</td>\n",
       "      <td>7265</td>\n",
       "      <td>2061</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22811</th>\n",
       "      <td>51313</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "      <td>2951</td>\n",
       "      <td>2243</td>\n",
       "      <td>11561</td>\n",
       "      <td>7007</td>\n",
       "      <td>1868</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22812</th>\n",
       "      <td>51314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "      <td>3079</td>\n",
       "      <td>2242</td>\n",
       "      <td>10166</td>\n",
       "      <td>5904</td>\n",
       "      <td>1879</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22813</th>\n",
       "      <td>51315</td>\n",
       "      <td>&lt;/p&gt;&lt;/body&gt;&lt;/html&gt;&lt;html&gt;&lt;body&gt;&lt;p&gt;11/30/12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hourly Breakdown of Renewable Resources</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22814</th>\n",
       "      <td>51316</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hour</td>\n",
       "      <td>GEOTHERMAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WIND TOTAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22815</th>\n",
       "      <td>51317</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>916</td>\n",
       "      <td>351</td>\n",
       "      <td>195</td>\n",
       "      <td>270</td>\n",
       "      <td>1561</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22816</th>\n",
       "      <td>51318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>915</td>\n",
       "      <td>355</td>\n",
       "      <td>200</td>\n",
       "      <td>233</td>\n",
       "      <td>1662</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22817</th>\n",
       "      <td>51319</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>915</td>\n",
       "      <td>360</td>\n",
       "      <td>197</td>\n",
       "      <td>228</td>\n",
       "      <td>1770</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22818</th>\n",
       "      <td>51320</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>917</td>\n",
       "      <td>350</td>\n",
       "      <td>198</td>\n",
       "      <td>224</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22819</th>\n",
       "      <td>51321</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>201</td>\n",
       "      <td>231</td>\n",
       "      <td>1526</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22820</th>\n",
       "      <td>51322</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>203</td>\n",
       "      <td>279</td>\n",
       "      <td>1034</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22821</th>\n",
       "      <td>51323</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>918</td>\n",
       "      <td>338</td>\n",
       "      <td>202</td>\n",
       "      <td>283</td>\n",
       "      <td>896</td>\n",
       "      <td>6</td>\n",
       "      <td>23</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22822</th>\n",
       "      <td>51324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>917</td>\n",
       "      <td>337</td>\n",
       "      <td>198</td>\n",
       "      <td>287</td>\n",
       "      <td>807</td>\n",
       "      <td>124</td>\n",
       "      <td>24</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22823</th>\n",
       "      <td>51325</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>914</td>\n",
       "      <td>328</td>\n",
       "      <td>194</td>\n",
       "      <td>290</td>\n",
       "      <td>838</td>\n",
       "      <td>282</td>\n",
       "      <td>25</td>\n",
       "      <td>282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22824</th>\n",
       "      <td>51356</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>3734</td>\n",
       "      <td>2244</td>\n",
       "      <td>13444</td>\n",
       "      <td>7743</td>\n",
       "      <td>1916</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22825</th>\n",
       "      <td>51357</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>3801</td>\n",
       "      <td>2242</td>\n",
       "      <td>12950</td>\n",
       "      <td>7943</td>\n",
       "      <td>1877</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22826</th>\n",
       "      <td>51358</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>3903</td>\n",
       "      <td>2241</td>\n",
       "      <td>12785</td>\n",
       "      <td>7606</td>\n",
       "      <td>1878</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22827</th>\n",
       "      <td>51359</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>3566</td>\n",
       "      <td>2240</td>\n",
       "      <td>13951</td>\n",
       "      <td>6210</td>\n",
       "      <td>1926</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22828</th>\n",
       "      <td>51360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>3238</td>\n",
       "      <td>2237</td>\n",
       "      <td>13618</td>\n",
       "      <td>6741</td>\n",
       "      <td>1951</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22829</th>\n",
       "      <td>51361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>2962</td>\n",
       "      <td>2236</td>\n",
       "      <td>14851</td>\n",
       "      <td>6611</td>\n",
       "      <td>2034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22830</th>\n",
       "      <td>51362</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>2690</td>\n",
       "      <td>2237</td>\n",
       "      <td>16175</td>\n",
       "      <td>7281</td>\n",
       "      <td>2262</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22831</th>\n",
       "      <td>51363</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>2586</td>\n",
       "      <td>2238</td>\n",
       "      <td>16316</td>\n",
       "      <td>6807</td>\n",
       "      <td>2412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22832</th>\n",
       "      <td>51364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>2642</td>\n",
       "      <td>2239</td>\n",
       "      <td>15716</td>\n",
       "      <td>6664</td>\n",
       "      <td>2286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22833</th>\n",
       "      <td>51365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "      <td>2896</td>\n",
       "      <td>2240</td>\n",
       "      <td>13684</td>\n",
       "      <td>7498</td>\n",
       "      <td>2302</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22834</th>\n",
       "      <td>51366</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>2862</td>\n",
       "      <td>2241</td>\n",
       "      <td>12663</td>\n",
       "      <td>7195</td>\n",
       "      <td>2296</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22835</th>\n",
       "      <td>51367</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "      <td>2991</td>\n",
       "      <td>2242</td>\n",
       "      <td>11170</td>\n",
       "      <td>6655</td>\n",
       "      <td>2329</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22836 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0                                       Date  Hour  \\\n",
       "0               2                                        NaN     1   \n",
       "1               3                                        NaN     2   \n",
       "2               4                                        NaN     3   \n",
       "3               5                                        NaN     4   \n",
       "4               6                                        NaN     5   \n",
       "5               7                                        NaN     6   \n",
       "6               8                                        NaN     7   \n",
       "7               9                                        NaN     8   \n",
       "8              10                                        NaN     9   \n",
       "9              11                                        NaN    10   \n",
       "10             12                                        NaN    11   \n",
       "11             13                                        NaN    12   \n",
       "12             14                                        NaN    13   \n",
       "13             15                                        NaN    14   \n",
       "14             16                                        NaN    15   \n",
       "15             17                                        NaN    16   \n",
       "16             18                                        NaN    17   \n",
       "17             19                                        NaN    18   \n",
       "18             20                                        NaN    19   \n",
       "19             21                                        NaN    20   \n",
       "20             22                                        NaN    21   \n",
       "21             23                                        NaN    22   \n",
       "22             24                                        NaN    23   \n",
       "23             25                                        NaN    24   \n",
       "24             56                                        NaN     1   \n",
       "25             57                                        NaN     2   \n",
       "26             58                                        NaN     3   \n",
       "27             59                                        NaN     4   \n",
       "28             60                                        NaN     5   \n",
       "29             61                                        NaN     6   \n",
       "...           ...                                        ...   ...   \n",
       "22806       51308                                        NaN    18   \n",
       "22807       51309                                        NaN    19   \n",
       "22808       51310                                        NaN    20   \n",
       "22809       51311                                        NaN    21   \n",
       "22810       51312                                        NaN    22   \n",
       "22811       51313                                        NaN    23   \n",
       "22812       51314                                        NaN    24   \n",
       "22813       51315  </p></body></html><html><body><p>11/30/12   NaN   \n",
       "22814       51316                                        NaN  Hour   \n",
       "22815       51317                                        NaN     1   \n",
       "22816       51318                                        NaN     2   \n",
       "22817       51319                                        NaN     3   \n",
       "22818       51320                                        NaN     4   \n",
       "22819       51321                                        NaN     5   \n",
       "22820       51322                                        NaN     6   \n",
       "22821       51323                                        NaN     7   \n",
       "22822       51324                                        NaN     8   \n",
       "22823       51325                                        NaN     9   \n",
       "22824       51356                                        NaN    12   \n",
       "22825       51357                                        NaN    13   \n",
       "22826       51358                                        NaN    14   \n",
       "22827       51359                                        NaN    15   \n",
       "22828       51360                                        NaN    16   \n",
       "22829       51361                                        NaN    17   \n",
       "22830       51362                                        NaN    18   \n",
       "22831       51363                                        NaN    19   \n",
       "22832       51364                                        NaN    20   \n",
       "22833       51365                                        NaN    21   \n",
       "22834       51366                                        NaN    22   \n",
       "22835       51367                                        NaN    23   \n",
       "\n",
       "                                    Geothermal Biomass Biogas Small Hydro  \\\n",
       "0                                         1056     323    170         250   \n",
       "1                                         1055     318    169         245   \n",
       "2                                         1058     316    168         240   \n",
       "3                                         1063     318    168         238   \n",
       "4                                         1066     318    168         247   \n",
       "5                                         1066     317    169         247   \n",
       "6                                         1066     312    166         244   \n",
       "7                                         1067     313    167         269   \n",
       "8                                         1065     315    169         280   \n",
       "9                                         1063     316    167         294   \n",
       "10                                        1063     314    169         294   \n",
       "11                                        1066     317    171         271   \n",
       "12                                        1068     324    171         270   \n",
       "13                                        1066     322    169         282   \n",
       "14                                        1067     326    170         292   \n",
       "15                                        1070     324    160         294   \n",
       "16                                        1071     320    147         295   \n",
       "17                                        1070     320    148         297   \n",
       "18                                        1070     314    153         302   \n",
       "19                                        1072     299    151         305   \n",
       "20                                        1072     300    124         307   \n",
       "21                                        1071     277    123         297   \n",
       "22                                        1071     284    126         266   \n",
       "23                                        1072     284    140         245   \n",
       "24                                        1072     285    145         253   \n",
       "25                                        1072     280    142         253   \n",
       "26                                        1072     277    153         254   \n",
       "27                                        1073     275    167         255   \n",
       "28                                        1074     282    164         263   \n",
       "29                                        1074     286    163         274   \n",
       "...                                        ...     ...    ...         ...   \n",
       "22806                                     2928    2239  16505        6758   \n",
       "22807                                     2925    2240  16105        7221   \n",
       "22808                                     2917    2240  15448        7423   \n",
       "22809                                     3155    2240  14137        7683   \n",
       "22810                                     3055    2242  13259        7265   \n",
       "22811                                     2951    2243  11561        7007   \n",
       "22812                                     3079    2242  10166        5904   \n",
       "22813  Hourly Breakdown of Renewable Resources     NaN    NaN         NaN   \n",
       "22814                               GEOTHERMAL     NaN    NaN  WIND TOTAL   \n",
       "22815                                      916     351    195         270   \n",
       "22816                                      915     355    200         233   \n",
       "22817                                      915     360    197         228   \n",
       "22818                                      917     350    198         224   \n",
       "22819                                      918     340    201         231   \n",
       "22820                                      918     340    203         279   \n",
       "22821                                      918     338    202         283   \n",
       "22822                                      917     337    198         287   \n",
       "22823                                      914     328    194         290   \n",
       "22824                                     3734    2244  13444        7743   \n",
       "22825                                     3801    2242  12950        7943   \n",
       "22826                                     3903    2241  12785        7606   \n",
       "22827                                     3566    2240  13951        6210   \n",
       "22828                                     3238    2237  13618        6741   \n",
       "22829                                     2962    2236  14851        6611   \n",
       "22830                                     2690    2237  16175        7281   \n",
       "22831                                     2586    2238  16316        6807   \n",
       "22832                                     2642    2239  15716        6664   \n",
       "22833                                     2896    2240  13684        7498   \n",
       "22834                                     2862    2241  12663        7195   \n",
       "22835                                     2991    2242  11170        6655   \n",
       "\n",
       "       Wind Solar  Index  Solar_num  \n",
       "0       632     0      2          0  \n",
       "1       632     0      3          0  \n",
       "2       677     0      4          0  \n",
       "3       923     0      5          0  \n",
       "4       875     0      6          0  \n",
       "5       998     0      7          0  \n",
       "6       763     0      8          0  \n",
       "7       544     1      9          1  \n",
       "8       572   191     10        191  \n",
       "9       721   299     11        299  \n",
       "10      658   278     12        278  \n",
       "11      772   198     13        198  \n",
       "12     1012   126     14        126  \n",
       "13     1350   139     15        139  \n",
       "14     1489   111     16        111  \n",
       "15     1475    39     17         39  \n",
       "16     1518    25     18         25  \n",
       "17     1511     3     19          3  \n",
       "18     1356     0     20          0  \n",
       "19     1083     0     21          0  \n",
       "20     1126     0     22          0  \n",
       "21     1024     0     23          0  \n",
       "22     1017     0     24          0  \n",
       "23     1018     0     25          0  \n",
       "24     1055     0      2          0  \n",
       "25      938     0      3          0  \n",
       "26      864     0      4          0  \n",
       "27      828     0      5          0  \n",
       "28      843     0      6          0  \n",
       "29      850     0      7          0  \n",
       "...     ...   ...    ...        ...  \n",
       "22806  2622   NaN      8          0  \n",
       "22807  2572   NaN      9          0  \n",
       "22808  2542   NaN     10          0  \n",
       "22809  2404   NaN     11          0  \n",
       "22810  2061   NaN     12          0  \n",
       "22811  1868   NaN     13          0  \n",
       "22812  1879   NaN     14          0  \n",
       "22813   NaN   NaN     15          0  \n",
       "22814   NaN   NaN     16          0  \n",
       "22815  1561     0     17          0  \n",
       "22816  1662     0     18          0  \n",
       "22817  1770     0     19          0  \n",
       "22818  1794     0     20          0  \n",
       "22819  1526     0     21          0  \n",
       "22820  1034     0     22          0  \n",
       "22821   896     6     23          6  \n",
       "22822   807   124     24        124  \n",
       "22823   838   282     25        282  \n",
       "22824  1916   NaN      2          0  \n",
       "22825  1877   NaN      3          0  \n",
       "22826  1878   NaN      4          0  \n",
       "22827  1926   NaN      5          0  \n",
       "22828  1951   NaN      6          0  \n",
       "22829  2034   NaN      7          0  \n",
       "22830  2262   NaN      8          0  \n",
       "22831  2412   NaN      9          0  \n",
       "22832  2286   NaN     10          0  \n",
       "22833  2302   NaN     11          0  \n",
       "22834  2296   NaN     12          0  \n",
       "22835  2329   NaN     13          0  \n",
       "\n",
       "[22836 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Read data gathered from the scraping noteobook into a csv for cleaning \n",
    "renewables_data = pd.read_csv('renewables_data.csv')\n",
    "renewables_data\n",
    "\n",
    "####CODE USED FOR CLEANING#####\n",
    "#type(renewables_data.iloc[0]['Date'])\n",
    "#type(renewables_data.iloc[22813]['Date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#####This code was used to understand the types of the values in the columns####\n",
    "\n",
    "#renewables_data_cleaned = renewables_data[renewables_data['Date'].map(type) != str]\n",
    "#renewables_data_cleaned "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'str'>\n",
      "<class 'str'>\n",
      "<class 'str'>\n"
     ]
    }
   ],
   "source": [
    "#####This code was used to understand the types of the values in the columns####\n",
    "print(type(pd.to_numeric(renewables_data.iloc[22814]['Geothermal'], errors='ignore')))\n",
    "print(type(renewables_data.iloc[0]['Geothermal']))\n",
    "print(type(renewables_data.iloc[22814]['Geothermal']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'numpy.int64'>\n",
      "<class 'str'>\n"
     ]
    }
   ],
   "source": [
    "#Creation of new geothermal array with all numbers in string format converted to numpy.int64 format \n",
    "#All erroneous values were left as they were which allowed for data cleaning later\n",
    "\n",
    "new_geothermal_array = []\n",
    "for i in range(len(renewables_data['Geothermal'])):\n",
    "    new_geothermal_array.append(pd.to_numeric(renewables_data.iloc[i]['Geothermal'], errors='ignore'))\n",
    "    \n",
    "print(type(new_geothermal_array[0]))\n",
    "print(type(new_geothermal_array[22814]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Biomass data type:  <class 'str'>\n",
      "Biogas data type:  <class 'str'>\n",
      "Small Hydro data type:  <class 'str'>\n",
      "Wind data type:  <class 'str'>\n",
      "Solar data type:  <class 'str'>\n"
     ]
    }
   ],
   "source": [
    "#These print statements were used to understand the type of values in the other data columns to see if they needed \n",
    "#conversions similar to the Geothermal column as done above\n",
    "\n",
    "print(\"Biomass data type: \", type(renewables_data.iloc[0]['Biomass']))\n",
    "print(\"Biogas data type: \", type(renewables_data.iloc[0]['Biogas']))\n",
    "print(\"Small Hydro data type: \", type(renewables_data.iloc[0]['Small Hydro']))\n",
    "print(\"Wind data type: \", type(renewables_data.iloc[0]['Wind']))\n",
    "print(\"Solar data type: \", type(renewables_data.iloc[0]['Solar']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'numpy.int64'>\n",
      "<class 'float'>\n"
     ]
    }
   ],
   "source": [
    "#Creation of new biomass array with all numbers in string format converted to numpy.int64 format \n",
    "#All erroneous values were left as they were which allowed for data cleaning later\n",
    "\n",
    "new_biomass_array = []\n",
    "for i in range(len(renewables_data['Biomass'])):\n",
    "    new_biomass_array.append(pd.to_numeric(renewables_data.iloc[i]['Biomass'], errors='ignore'))\n",
    "    \n",
    "print(type(new_biomass_array[0]))\n",
    "print(type(new_biomass_array[22814]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'numpy.int64'>\n",
      "<class 'float'>\n"
     ]
    }
   ],
   "source": [
    "#Creation of new biomgas array with all numbers in string format converted to numpy.int64 format \n",
    "#All erroneous values were left as they were which allowed for data cleaning later\n",
    "\n",
    "new_biogas_array = []\n",
    "for i in range(len(renewables_data['Biogas'])):\n",
    "    new_biogas_array.append(pd.to_numeric(renewables_data.iloc[i]['Biogas'], errors='ignore'))\n",
    "    \n",
    "print(type(new_biogas_array[0]))\n",
    "print(type(new_biogas_array[22814]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'numpy.int64'>\n",
      "<class 'str'>\n"
     ]
    }
   ],
   "source": [
    "#Creation of new small hydro array with all numbers in string format converted to numpy.int64 format \n",
    "#All erroneous values were left as they were which allowed for data cleaning later\n",
    "\n",
    "new_smallHydro_array = []\n",
    "for i in range(len(renewables_data['Small Hydro'])):\n",
    "    new_smallHydro_array.append(pd.to_numeric(renewables_data.iloc[i]['Small Hydro'], errors='ignore'))\n",
    "    \n",
    "print(type(new_smallHydro_array[0]))\n",
    "print(type(new_smallHydro_array[22814]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'numpy.int64'>\n",
      "<class 'float'>\n"
     ]
    }
   ],
   "source": [
    "#Creation of new wind array with all numbers in string format converted to numpy.int64 format \n",
    "#All erroneous values were left as they were which allowed for data cleaning later\n",
    "\n",
    "new_wind_array = []\n",
    "for i in range(len(renewables_data['Wind'])):\n",
    "    new_wind_array.append(pd.to_numeric(renewables_data.iloc[i]['Wind'], errors='ignore'))\n",
    "    \n",
    "print(type(new_wind_array[0]))\n",
    "print(type(new_wind_array[22814]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'numpy.int64'>\n",
      "<class 'float'>\n"
     ]
    }
   ],
   "source": [
    "#Creation of new Solar array with all numbers in string format converted to numpy.int64 format \n",
    "#All erroneous values were left as they were which allowed for data cleaning later\n",
    "\n",
    "new_solar_array = []\n",
    "for i in range(len(renewables_data['Solar'])):\n",
    "    new_solar_array.append(pd.to_numeric(renewables_data.iloc[i]['Solar'], errors='ignore'))\n",
    "    \n",
    "print(type(new_solar_array[0]))\n",
    "print(type(new_solar_array[22814]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Checking length of Geothermal array:  22836\n",
      "Checking length of Biomass array:  22836\n",
      "Checking length of Biogas array:  22836\n",
      "Checking length of Small Hydro array:  22836\n",
      "Checking length of Wind array:  22836\n",
      "Checking length of Solar array:  22836\n"
     ]
    }
   ],
   "source": [
    "#Checking length of each array post-processed to see if they would fit into the renewables_data dataframe\n",
    "\n",
    "print(\"Checking length of Geothermal array: \", len(new_geothermal_array))\n",
    "print(\"Checking length of Biomass array: \", len(new_biomass_array))\n",
    "print(\"Checking length of Biogas array: \", len(new_biogas_array))\n",
    "print(\"Checking length of Small Hydro array: \", len(new_smallHydro_array))\n",
    "print(\"Checking length of Wind array: \", len(new_wind_array))\n",
    "print(\"Checking length of Solar array: \", len(new_solar_array))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\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>Hour</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>59</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>61</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22806</th>\n",
       "      <td>51308</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22807</th>\n",
       "      <td>51309</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22808</th>\n",
       "      <td>51310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22809</th>\n",
       "      <td>51311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22810</th>\n",
       "      <td>51312</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22811</th>\n",
       "      <td>51313</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22812</th>\n",
       "      <td>51314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22813</th>\n",
       "      <td>51315</td>\n",
       "      <td>&lt;/p&gt;&lt;/body&gt;&lt;/html&gt;&lt;html&gt;&lt;body&gt;&lt;p&gt;11/30/12</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22814</th>\n",
       "      <td>51316</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hour</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22815</th>\n",
       "      <td>51317</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22816</th>\n",
       "      <td>51318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22817</th>\n",
       "      <td>51319</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22818</th>\n",
       "      <td>51320</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22819</th>\n",
       "      <td>51321</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22820</th>\n",
       "      <td>51322</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22821</th>\n",
       "      <td>51323</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22822</th>\n",
       "      <td>51324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22823</th>\n",
       "      <td>51325</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22824</th>\n",
       "      <td>51356</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22825</th>\n",
       "      <td>51357</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22826</th>\n",
       "      <td>51358</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22827</th>\n",
       "      <td>51359</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22828</th>\n",
       "      <td>51360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22829</th>\n",
       "      <td>51361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22830</th>\n",
       "      <td>51362</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22831</th>\n",
       "      <td>51363</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22832</th>\n",
       "      <td>51364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22833</th>\n",
       "      <td>51365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22834</th>\n",
       "      <td>51366</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22835</th>\n",
       "      <td>51367</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22836 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0                                       Date  Hour\n",
       "0               2                                        NaN     1\n",
       "1               3                                        NaN     2\n",
       "2               4                                        NaN     3\n",
       "3               5                                        NaN     4\n",
       "4               6                                        NaN     5\n",
       "5               7                                        NaN     6\n",
       "6               8                                        NaN     7\n",
       "7               9                                        NaN     8\n",
       "8              10                                        NaN     9\n",
       "9              11                                        NaN    10\n",
       "10             12                                        NaN    11\n",
       "11             13                                        NaN    12\n",
       "12             14                                        NaN    13\n",
       "13             15                                        NaN    14\n",
       "14             16                                        NaN    15\n",
       "15             17                                        NaN    16\n",
       "16             18                                        NaN    17\n",
       "17             19                                        NaN    18\n",
       "18             20                                        NaN    19\n",
       "19             21                                        NaN    20\n",
       "20             22                                        NaN    21\n",
       "21             23                                        NaN    22\n",
       "22             24                                        NaN    23\n",
       "23             25                                        NaN    24\n",
       "24             56                                        NaN     1\n",
       "25             57                                        NaN     2\n",
       "26             58                                        NaN     3\n",
       "27             59                                        NaN     4\n",
       "28             60                                        NaN     5\n",
       "29             61                                        NaN     6\n",
       "...           ...                                        ...   ...\n",
       "22806       51308                                        NaN    18\n",
       "22807       51309                                        NaN    19\n",
       "22808       51310                                        NaN    20\n",
       "22809       51311                                        NaN    21\n",
       "22810       51312                                        NaN    22\n",
       "22811       51313                                        NaN    23\n",
       "22812       51314                                        NaN    24\n",
       "22813       51315  </p></body></html><html><body><p>11/30/12   NaN\n",
       "22814       51316                                        NaN  Hour\n",
       "22815       51317                                        NaN     1\n",
       "22816       51318                                        NaN     2\n",
       "22817       51319                                        NaN     3\n",
       "22818       51320                                        NaN     4\n",
       "22819       51321                                        NaN     5\n",
       "22820       51322                                        NaN     6\n",
       "22821       51323                                        NaN     7\n",
       "22822       51324                                        NaN     8\n",
       "22823       51325                                        NaN     9\n",
       "22824       51356                                        NaN    12\n",
       "22825       51357                                        NaN    13\n",
       "22826       51358                                        NaN    14\n",
       "22827       51359                                        NaN    15\n",
       "22828       51360                                        NaN    16\n",
       "22829       51361                                        NaN    17\n",
       "22830       51362                                        NaN    18\n",
       "22831       51363                                        NaN    19\n",
       "22832       51364                                        NaN    20\n",
       "22833       51365                                        NaN    21\n",
       "22834       51366                                        NaN    22\n",
       "22835       51367                                        NaN    23\n",
       "\n",
       "[22836 rows x 3 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Dropping all of the previous feature columns since they contained numbers in string format instead of in numerical formats\n",
    "#Also dropping useless columns created during datascraping and initial cleaning\n",
    "\n",
    "renewables_data = renewables_data.drop('Geothermal', axis=1)\n",
    "renewables_data = renewables_data.drop('Biomass', axis=1)\n",
    "renewables_data = renewables_data.drop('Biogas', axis=1)\n",
    "renewables_data = renewables_data.drop('Small Hydro', axis=1)\n",
    "renewables_data = renewables_data.drop('Wind', axis=1)\n",
    "renewables_data = renewables_data.drop('Solar', axis=1)\n",
    "renewables_data = renewables_data.drop('Index', axis=1)\n",
    "renewables_data = renewables_data.drop('Solar_num', axis=1)\n",
    "renewables_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#Assigning new feature columns to be the post-processing arrays with numbers in proper numerical format\n",
    "#Also contains erroneous values in their original format allowing for distinction and cleaning\n",
    "\n",
    "renewables_data['Geothermal'] = pd.Series(new_geothermal_array)\n",
    "renewables_data['Biomass'] = pd.Series(new_biomass_array)\n",
    "renewables_data['Biogas'] = pd.Series(new_biogas_array)\n",
    "renewables_data['Small Hydro'] = pd.Series(new_smallHydro_array)\n",
    "renewables_data['Wind'] = pd.Series(new_wind_array)\n",
    "renewables_data['Solar'] = pd.Series(new_solar_array)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "numpy.int64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Checking results of processing and adding to dataframe\n",
    "type(renewables_data.iloc[0]['Geothermal'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\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>Hour</th>\n",
       "      <th>Geothermal</th>\n",
       "      <th>Biomass</th>\n",
       "      <th>Biogas</th>\n",
       "      <th>Small Hydro</th>\n",
       "      <th>Wind</th>\n",
       "      <th>Solar</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1056</td>\n",
       "      <td>323</td>\n",
       "      <td>170</td>\n",
       "      <td>250</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>1055</td>\n",
       "      <td>318</td>\n",
       "      <td>169</td>\n",
       "      <td>245</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>1058</td>\n",
       "      <td>316</td>\n",
       "      <td>168</td>\n",
       "      <td>240</td>\n",
       "      <td>677</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>1063</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>238</td>\n",
       "      <td>923</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>1066</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>247</td>\n",
       "      <td>875</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>169</td>\n",
       "      <td>247</td>\n",
       "      <td>998</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>1066</td>\n",
       "      <td>312</td>\n",
       "      <td>166</td>\n",
       "      <td>244</td>\n",
       "      <td>763</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>1067</td>\n",
       "      <td>313</td>\n",
       "      <td>167</td>\n",
       "      <td>269</td>\n",
       "      <td>544</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>1065</td>\n",
       "      <td>315</td>\n",
       "      <td>169</td>\n",
       "      <td>280</td>\n",
       "      <td>572</td>\n",
       "      <td>191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>1063</td>\n",
       "      <td>316</td>\n",
       "      <td>167</td>\n",
       "      <td>294</td>\n",
       "      <td>721</td>\n",
       "      <td>299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>1063</td>\n",
       "      <td>314</td>\n",
       "      <td>169</td>\n",
       "      <td>294</td>\n",
       "      <td>658</td>\n",
       "      <td>278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>171</td>\n",
       "      <td>271</td>\n",
       "      <td>772</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>1068</td>\n",
       "      <td>324</td>\n",
       "      <td>171</td>\n",
       "      <td>270</td>\n",
       "      <td>1012</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>1066</td>\n",
       "      <td>322</td>\n",
       "      <td>169</td>\n",
       "      <td>282</td>\n",
       "      <td>1350</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>1067</td>\n",
       "      <td>326</td>\n",
       "      <td>170</td>\n",
       "      <td>292</td>\n",
       "      <td>1489</td>\n",
       "      <td>111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>1070</td>\n",
       "      <td>324</td>\n",
       "      <td>160</td>\n",
       "      <td>294</td>\n",
       "      <td>1475</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>1071</td>\n",
       "      <td>320</td>\n",
       "      <td>147</td>\n",
       "      <td>295</td>\n",
       "      <td>1518</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>1070</td>\n",
       "      <td>320</td>\n",
       "      <td>148</td>\n",
       "      <td>297</td>\n",
       "      <td>1511</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>1070</td>\n",
       "      <td>314</td>\n",
       "      <td>153</td>\n",
       "      <td>302</td>\n",
       "      <td>1356</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>1072</td>\n",
       "      <td>299</td>\n",
       "      <td>151</td>\n",
       "      <td>305</td>\n",
       "      <td>1083</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "      <td>1072</td>\n",
       "      <td>300</td>\n",
       "      <td>124</td>\n",
       "      <td>307</td>\n",
       "      <td>1126</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>1071</td>\n",
       "      <td>277</td>\n",
       "      <td>123</td>\n",
       "      <td>297</td>\n",
       "      <td>1024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "      <td>1071</td>\n",
       "      <td>284</td>\n",
       "      <td>126</td>\n",
       "      <td>266</td>\n",
       "      <td>1017</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "      <td>1072</td>\n",
       "      <td>284</td>\n",
       "      <td>140</td>\n",
       "      <td>245</td>\n",
       "      <td>1018</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1072</td>\n",
       "      <td>285</td>\n",
       "      <td>145</td>\n",
       "      <td>253</td>\n",
       "      <td>1055</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>1072</td>\n",
       "      <td>280</td>\n",
       "      <td>142</td>\n",
       "      <td>253</td>\n",
       "      <td>938</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>1072</td>\n",
       "      <td>277</td>\n",
       "      <td>153</td>\n",
       "      <td>254</td>\n",
       "      <td>864</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>59</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>1073</td>\n",
       "      <td>275</td>\n",
       "      <td>167</td>\n",
       "      <td>255</td>\n",
       "      <td>828</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>1074</td>\n",
       "      <td>282</td>\n",
       "      <td>164</td>\n",
       "      <td>263</td>\n",
       "      <td>843</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>61</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>1074</td>\n",
       "      <td>286</td>\n",
       "      <td>163</td>\n",
       "      <td>274</td>\n",
       "      <td>850</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22804</th>\n",
       "      <td>51306</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>3374</td>\n",
       "      <td>2240</td>\n",
       "      <td>13205</td>\n",
       "      <td>6755</td>\n",
       "      <td>2201</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22805</th>\n",
       "      <td>51307</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>2987</td>\n",
       "      <td>2239</td>\n",
       "      <td>14676</td>\n",
       "      <td>6561</td>\n",
       "      <td>2453</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22806</th>\n",
       "      <td>51308</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>2928</td>\n",
       "      <td>2239</td>\n",
       "      <td>16505</td>\n",
       "      <td>6758</td>\n",
       "      <td>2622</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22807</th>\n",
       "      <td>51309</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>2925</td>\n",
       "      <td>2240</td>\n",
       "      <td>16105</td>\n",
       "      <td>7221</td>\n",
       "      <td>2572</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22808</th>\n",
       "      <td>51310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>2917</td>\n",
       "      <td>2240</td>\n",
       "      <td>15448</td>\n",
       "      <td>7423</td>\n",
       "      <td>2542</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22809</th>\n",
       "      <td>51311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "      <td>3155</td>\n",
       "      <td>2240</td>\n",
       "      <td>14137</td>\n",
       "      <td>7683</td>\n",
       "      <td>2404</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22810</th>\n",
       "      <td>51312</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>3055</td>\n",
       "      <td>2242</td>\n",
       "      <td>13259</td>\n",
       "      <td>7265</td>\n",
       "      <td>2061</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22811</th>\n",
       "      <td>51313</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "      <td>2951</td>\n",
       "      <td>2243</td>\n",
       "      <td>11561</td>\n",
       "      <td>7007</td>\n",
       "      <td>1868</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22812</th>\n",
       "      <td>51314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "      <td>3079</td>\n",
       "      <td>2242</td>\n",
       "      <td>10166</td>\n",
       "      <td>5904</td>\n",
       "      <td>1879</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22815</th>\n",
       "      <td>51317</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>916</td>\n",
       "      <td>351</td>\n",
       "      <td>195</td>\n",
       "      <td>270</td>\n",
       "      <td>1561</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22816</th>\n",
       "      <td>51318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>915</td>\n",
       "      <td>355</td>\n",
       "      <td>200</td>\n",
       "      <td>233</td>\n",
       "      <td>1662</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22817</th>\n",
       "      <td>51319</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>915</td>\n",
       "      <td>360</td>\n",
       "      <td>197</td>\n",
       "      <td>228</td>\n",
       "      <td>1770</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22818</th>\n",
       "      <td>51320</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>917</td>\n",
       "      <td>350</td>\n",
       "      <td>198</td>\n",
       "      <td>224</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22819</th>\n",
       "      <td>51321</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>201</td>\n",
       "      <td>231</td>\n",
       "      <td>1526</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22820</th>\n",
       "      <td>51322</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>203</td>\n",
       "      <td>279</td>\n",
       "      <td>1034</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22821</th>\n",
       "      <td>51323</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>918</td>\n",
       "      <td>338</td>\n",
       "      <td>202</td>\n",
       "      <td>283</td>\n",
       "      <td>896</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22822</th>\n",
       "      <td>51324</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>917</td>\n",
       "      <td>337</td>\n",
       "      <td>198</td>\n",
       "      <td>287</td>\n",
       "      <td>807</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22823</th>\n",
       "      <td>51325</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>914</td>\n",
       "      <td>328</td>\n",
       "      <td>194</td>\n",
       "      <td>290</td>\n",
       "      <td>838</td>\n",
       "      <td>282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22824</th>\n",
       "      <td>51356</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>3734</td>\n",
       "      <td>2244</td>\n",
       "      <td>13444</td>\n",
       "      <td>7743</td>\n",
       "      <td>1916</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22825</th>\n",
       "      <td>51357</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>3801</td>\n",
       "      <td>2242</td>\n",
       "      <td>12950</td>\n",
       "      <td>7943</td>\n",
       "      <td>1877</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22826</th>\n",
       "      <td>51358</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>3903</td>\n",
       "      <td>2241</td>\n",
       "      <td>12785</td>\n",
       "      <td>7606</td>\n",
       "      <td>1878</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22827</th>\n",
       "      <td>51359</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>3566</td>\n",
       "      <td>2240</td>\n",
       "      <td>13951</td>\n",
       "      <td>6210</td>\n",
       "      <td>1926</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22828</th>\n",
       "      <td>51360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>3238</td>\n",
       "      <td>2237</td>\n",
       "      <td>13618</td>\n",
       "      <td>6741</td>\n",
       "      <td>1951</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22829</th>\n",
       "      <td>51361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>2962</td>\n",
       "      <td>2236</td>\n",
       "      <td>14851</td>\n",
       "      <td>6611</td>\n",
       "      <td>2034</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22830</th>\n",
       "      <td>51362</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>2690</td>\n",
       "      <td>2237</td>\n",
       "      <td>16175</td>\n",
       "      <td>7281</td>\n",
       "      <td>2262</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22831</th>\n",
       "      <td>51363</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>2586</td>\n",
       "      <td>2238</td>\n",
       "      <td>16316</td>\n",
       "      <td>6807</td>\n",
       "      <td>2412</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22832</th>\n",
       "      <td>51364</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>2642</td>\n",
       "      <td>2239</td>\n",
       "      <td>15716</td>\n",
       "      <td>6664</td>\n",
       "      <td>2286</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22833</th>\n",
       "      <td>51365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "      <td>2896</td>\n",
       "      <td>2240</td>\n",
       "      <td>13684</td>\n",
       "      <td>7498</td>\n",
       "      <td>2302</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22834</th>\n",
       "      <td>51366</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>2862</td>\n",
       "      <td>2241</td>\n",
       "      <td>12663</td>\n",
       "      <td>7195</td>\n",
       "      <td>2296</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22835</th>\n",
       "      <td>51367</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "      <td>2991</td>\n",
       "      <td>2242</td>\n",
       "      <td>11170</td>\n",
       "      <td>6655</td>\n",
       "      <td>2329</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21112 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 Date Hour Geothermal Biomass Biogas Small Hydro  Wind Solar\n",
       "0               2  NaN    1       1056     323    170         250   632     0\n",
       "1               3  NaN    2       1055     318    169         245   632     0\n",
       "2               4  NaN    3       1058     316    168         240   677     0\n",
       "3               5  NaN    4       1063     318    168         238   923     0\n",
       "4               6  NaN    5       1066     318    168         247   875     0\n",
       "5               7  NaN    6       1066     317    169         247   998     0\n",
       "6               8  NaN    7       1066     312    166         244   763     0\n",
       "7               9  NaN    8       1067     313    167         269   544     1\n",
       "8              10  NaN    9       1065     315    169         280   572   191\n",
       "9              11  NaN   10       1063     316    167         294   721   299\n",
       "10             12  NaN   11       1063     314    169         294   658   278\n",
       "11             13  NaN   12       1066     317    171         271   772   198\n",
       "12             14  NaN   13       1068     324    171         270  1012   126\n",
       "13             15  NaN   14       1066     322    169         282  1350   139\n",
       "14             16  NaN   15       1067     326    170         292  1489   111\n",
       "15             17  NaN   16       1070     324    160         294  1475    39\n",
       "16             18  NaN   17       1071     320    147         295  1518    25\n",
       "17             19  NaN   18       1070     320    148         297  1511     3\n",
       "18             20  NaN   19       1070     314    153         302  1356     0\n",
       "19             21  NaN   20       1072     299    151         305  1083     0\n",
       "20             22  NaN   21       1072     300    124         307  1126     0\n",
       "21             23  NaN   22       1071     277    123         297  1024     0\n",
       "22             24  NaN   23       1071     284    126         266  1017     0\n",
       "23             25  NaN   24       1072     284    140         245  1018     0\n",
       "24             56  NaN    1       1072     285    145         253  1055     0\n",
       "25             57  NaN    2       1072     280    142         253   938     0\n",
       "26             58  NaN    3       1072     277    153         254   864     0\n",
       "27             59  NaN    4       1073     275    167         255   828     0\n",
       "28             60  NaN    5       1074     282    164         263   843     0\n",
       "29             61  NaN    6       1074     286    163         274   850     0\n",
       "...           ...  ...  ...        ...     ...    ...         ...   ...   ...\n",
       "22804       51306  NaN   16       3374    2240  13205        6755  2201   NaN\n",
       "22805       51307  NaN   17       2987    2239  14676        6561  2453   NaN\n",
       "22806       51308  NaN   18       2928    2239  16505        6758  2622   NaN\n",
       "22807       51309  NaN   19       2925    2240  16105        7221  2572   NaN\n",
       "22808       51310  NaN   20       2917    2240  15448        7423  2542   NaN\n",
       "22809       51311  NaN   21       3155    2240  14137        7683  2404   NaN\n",
       "22810       51312  NaN   22       3055    2242  13259        7265  2061   NaN\n",
       "22811       51313  NaN   23       2951    2243  11561        7007  1868   NaN\n",
       "22812       51314  NaN   24       3079    2242  10166        5904  1879   NaN\n",
       "22815       51317  NaN    1        916     351    195         270  1561     0\n",
       "22816       51318  NaN    2        915     355    200         233  1662     0\n",
       "22817       51319  NaN    3        915     360    197         228  1770     0\n",
       "22818       51320  NaN    4        917     350    198         224  1794     0\n",
       "22819       51321  NaN    5        918     340    201         231  1526     0\n",
       "22820       51322  NaN    6        918     340    203         279  1034     0\n",
       "22821       51323  NaN    7        918     338    202         283   896     6\n",
       "22822       51324  NaN    8        917     337    198         287   807   124\n",
       "22823       51325  NaN    9        914     328    194         290   838   282\n",
       "22824       51356  NaN   12       3734    2244  13444        7743  1916   NaN\n",
       "22825       51357  NaN   13       3801    2242  12950        7943  1877   NaN\n",
       "22826       51358  NaN   14       3903    2241  12785        7606  1878   NaN\n",
       "22827       51359  NaN   15       3566    2240  13951        6210  1926   NaN\n",
       "22828       51360  NaN   16       3238    2237  13618        6741  1951   NaN\n",
       "22829       51361  NaN   17       2962    2236  14851        6611  2034   NaN\n",
       "22830       51362  NaN   18       2690    2237  16175        7281  2262   NaN\n",
       "22831       51363  NaN   19       2586    2238  16316        6807  2412   NaN\n",
       "22832       51364  NaN   20       2642    2239  15716        6664  2286   NaN\n",
       "22833       51365  NaN   21       2896    2240  13684        7498  2302   NaN\n",
       "22834       51366  NaN   22       2862    2241  12663        7195  2296   NaN\n",
       "22835       51367  NaN   23       2991    2242  11170        6655  2329   NaN\n",
       "\n",
       "[21112 rows x 9 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Cleaning of dataframe by removing erroneous values in two steps \n",
    "#First the values in the 'Date' column which were not strings (i.e. those which were NaN values are kept), dropping the erroneous ones\n",
    "#Then the values in the Other columns which are in the format np.int64 are kept, dropping the string values which are erroneous\n",
    "\n",
    "renewables_data_cleaned = renewables_data[renewables_data['Date'].map(type) != str]\n",
    "renewables_data_cleaned = renewables_data_cleaned[renewables_data_cleaned['Geothermal'].map(type) == np.int64]\n",
    "renewables_data_cleaned = renewables_data_cleaned[renewables_data_cleaned['Biogas'].map(type) == np.int64]\n",
    "renewables_data_cleaned = renewables_data_cleaned[renewables_data_cleaned['Small Hydro'].map(type) == np.int64]\n",
    "renewables_data_cleaned = renewables_data_cleaned[renewables_data_cleaned['Wind'].map(type) == np.int64]\n",
    "renewables_data_cleaned"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#Dropping of the Date column which is full of NaN values erroneously\n",
    "#Dropping of the first column which is unnamed and contains outdated indexing\n",
    "\n",
    "renewables_data_cleaned = renewables_data_cleaned.drop('Date', axis=1)\n",
    "renewables_data_cleaned = renewables_data_cleaned.drop('Unnamed: 0', axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#renewables_data_cleaned"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#dates = pd.date_range('4/20/2010 00:00', periods=21134, freq = 'H')\n",
    "#len(dates)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#renewables_data_cleaned[\"Date\"] = pd.Series(dates)\n",
    "#renewables_data_cleaned "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>Hour</th>\n",
       "      <th>Geothermal</th>\n",
       "      <th>Biomass</th>\n",
       "      <th>Biogas</th>\n",
       "      <th>Small Hydro</th>\n",
       "      <th>Wind</th>\n",
       "      <th>Solar</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1056</td>\n",
       "      <td>323</td>\n",
       "      <td>170</td>\n",
       "      <td>250</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1055</td>\n",
       "      <td>318</td>\n",
       "      <td>169</td>\n",
       "      <td>245</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1058</td>\n",
       "      <td>316</td>\n",
       "      <td>168</td>\n",
       "      <td>240</td>\n",
       "      <td>677</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1063</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>238</td>\n",
       "      <td>923</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>1066</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>247</td>\n",
       "      <td>875</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>169</td>\n",
       "      <td>247</td>\n",
       "      <td>998</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>1066</td>\n",
       "      <td>312</td>\n",
       "      <td>166</td>\n",
       "      <td>244</td>\n",
       "      <td>763</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>1067</td>\n",
       "      <td>313</td>\n",
       "      <td>167</td>\n",
       "      <td>269</td>\n",
       "      <td>544</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>1065</td>\n",
       "      <td>315</td>\n",
       "      <td>169</td>\n",
       "      <td>280</td>\n",
       "      <td>572</td>\n",
       "      <td>191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>1063</td>\n",
       "      <td>316</td>\n",
       "      <td>167</td>\n",
       "      <td>294</td>\n",
       "      <td>721</td>\n",
       "      <td>299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>1063</td>\n",
       "      <td>314</td>\n",
       "      <td>169</td>\n",
       "      <td>294</td>\n",
       "      <td>658</td>\n",
       "      <td>278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>171</td>\n",
       "      <td>271</td>\n",
       "      <td>772</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>1068</td>\n",
       "      <td>324</td>\n",
       "      <td>171</td>\n",
       "      <td>270</td>\n",
       "      <td>1012</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>1066</td>\n",
       "      <td>322</td>\n",
       "      <td>169</td>\n",
       "      <td>282</td>\n",
       "      <td>1350</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>1067</td>\n",
       "      <td>326</td>\n",
       "      <td>170</td>\n",
       "      <td>292</td>\n",
       "      <td>1489</td>\n",
       "      <td>111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>16</td>\n",
       "      <td>1070</td>\n",
       "      <td>324</td>\n",
       "      <td>160</td>\n",
       "      <td>294</td>\n",
       "      <td>1475</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>17</td>\n",
       "      <td>1071</td>\n",
       "      <td>320</td>\n",
       "      <td>147</td>\n",
       "      <td>295</td>\n",
       "      <td>1518</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "      <td>1070</td>\n",
       "      <td>320</td>\n",
       "      <td>148</td>\n",
       "      <td>297</td>\n",
       "      <td>1511</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>1070</td>\n",
       "      <td>314</td>\n",
       "      <td>153</td>\n",
       "      <td>302</td>\n",
       "      <td>1356</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>1072</td>\n",
       "      <td>299</td>\n",
       "      <td>151</td>\n",
       "      <td>305</td>\n",
       "      <td>1083</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>21</td>\n",
       "      <td>1072</td>\n",
       "      <td>300</td>\n",
       "      <td>124</td>\n",
       "      <td>307</td>\n",
       "      <td>1126</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>22</td>\n",
       "      <td>1071</td>\n",
       "      <td>277</td>\n",
       "      <td>123</td>\n",
       "      <td>297</td>\n",
       "      <td>1024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>23</td>\n",
       "      <td>1071</td>\n",
       "      <td>284</td>\n",
       "      <td>126</td>\n",
       "      <td>266</td>\n",
       "      <td>1017</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>24</td>\n",
       "      <td>1072</td>\n",
       "      <td>284</td>\n",
       "      <td>140</td>\n",
       "      <td>245</td>\n",
       "      <td>1018</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>1072</td>\n",
       "      <td>285</td>\n",
       "      <td>145</td>\n",
       "      <td>253</td>\n",
       "      <td>1055</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>1072</td>\n",
       "      <td>280</td>\n",
       "      <td>142</td>\n",
       "      <td>253</td>\n",
       "      <td>938</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>3</td>\n",
       "      <td>1072</td>\n",
       "      <td>277</td>\n",
       "      <td>153</td>\n",
       "      <td>254</td>\n",
       "      <td>864</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>4</td>\n",
       "      <td>1073</td>\n",
       "      <td>275</td>\n",
       "      <td>167</td>\n",
       "      <td>255</td>\n",
       "      <td>828</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>5</td>\n",
       "      <td>1074</td>\n",
       "      <td>282</td>\n",
       "      <td>164</td>\n",
       "      <td>263</td>\n",
       "      <td>843</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>6</td>\n",
       "      <td>1074</td>\n",
       "      <td>286</td>\n",
       "      <td>163</td>\n",
       "      <td>274</td>\n",
       "      <td>850</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21082</th>\n",
       "      <td>22804</td>\n",
       "      <td>16</td>\n",
       "      <td>3374</td>\n",
       "      <td>2240</td>\n",
       "      <td>13205</td>\n",
       "      <td>6755</td>\n",
       "      <td>2201</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21083</th>\n",
       "      <td>22805</td>\n",
       "      <td>17</td>\n",
       "      <td>2987</td>\n",
       "      <td>2239</td>\n",
       "      <td>14676</td>\n",
       "      <td>6561</td>\n",
       "      <td>2453</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21084</th>\n",
       "      <td>22806</td>\n",
       "      <td>18</td>\n",
       "      <td>2928</td>\n",
       "      <td>2239</td>\n",
       "      <td>16505</td>\n",
       "      <td>6758</td>\n",
       "      <td>2622</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21085</th>\n",
       "      <td>22807</td>\n",
       "      <td>19</td>\n",
       "      <td>2925</td>\n",
       "      <td>2240</td>\n",
       "      <td>16105</td>\n",
       "      <td>7221</td>\n",
       "      <td>2572</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21086</th>\n",
       "      <td>22808</td>\n",
       "      <td>20</td>\n",
       "      <td>2917</td>\n",
       "      <td>2240</td>\n",
       "      <td>15448</td>\n",
       "      <td>7423</td>\n",
       "      <td>2542</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21087</th>\n",
       "      <td>22809</td>\n",
       "      <td>21</td>\n",
       "      <td>3155</td>\n",
       "      <td>2240</td>\n",
       "      <td>14137</td>\n",
       "      <td>7683</td>\n",
       "      <td>2404</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21088</th>\n",
       "      <td>22810</td>\n",
       "      <td>22</td>\n",
       "      <td>3055</td>\n",
       "      <td>2242</td>\n",
       "      <td>13259</td>\n",
       "      <td>7265</td>\n",
       "      <td>2061</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21089</th>\n",
       "      <td>22811</td>\n",
       "      <td>23</td>\n",
       "      <td>2951</td>\n",
       "      <td>2243</td>\n",
       "      <td>11561</td>\n",
       "      <td>7007</td>\n",
       "      <td>1868</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21090</th>\n",
       "      <td>22812</td>\n",
       "      <td>24</td>\n",
       "      <td>3079</td>\n",
       "      <td>2242</td>\n",
       "      <td>10166</td>\n",
       "      <td>5904</td>\n",
       "      <td>1879</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21091</th>\n",
       "      <td>22815</td>\n",
       "      <td>1</td>\n",
       "      <td>916</td>\n",
       "      <td>351</td>\n",
       "      <td>195</td>\n",
       "      <td>270</td>\n",
       "      <td>1561</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21092</th>\n",
       "      <td>22816</td>\n",
       "      <td>2</td>\n",
       "      <td>915</td>\n",
       "      <td>355</td>\n",
       "      <td>200</td>\n",
       "      <td>233</td>\n",
       "      <td>1662</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21093</th>\n",
       "      <td>22817</td>\n",
       "      <td>3</td>\n",
       "      <td>915</td>\n",
       "      <td>360</td>\n",
       "      <td>197</td>\n",
       "      <td>228</td>\n",
       "      <td>1770</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21094</th>\n",
       "      <td>22818</td>\n",
       "      <td>4</td>\n",
       "      <td>917</td>\n",
       "      <td>350</td>\n",
       "      <td>198</td>\n",
       "      <td>224</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21095</th>\n",
       "      <td>22819</td>\n",
       "      <td>5</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>201</td>\n",
       "      <td>231</td>\n",
       "      <td>1526</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21096</th>\n",
       "      <td>22820</td>\n",
       "      <td>6</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>203</td>\n",
       "      <td>279</td>\n",
       "      <td>1034</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21097</th>\n",
       "      <td>22821</td>\n",
       "      <td>7</td>\n",
       "      <td>918</td>\n",
       "      <td>338</td>\n",
       "      <td>202</td>\n",
       "      <td>283</td>\n",
       "      <td>896</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21098</th>\n",
       "      <td>22822</td>\n",
       "      <td>8</td>\n",
       "      <td>917</td>\n",
       "      <td>337</td>\n",
       "      <td>198</td>\n",
       "      <td>287</td>\n",
       "      <td>807</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21099</th>\n",
       "      <td>22823</td>\n",
       "      <td>9</td>\n",
       "      <td>914</td>\n",
       "      <td>328</td>\n",
       "      <td>194</td>\n",
       "      <td>290</td>\n",
       "      <td>838</td>\n",
       "      <td>282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21100</th>\n",
       "      <td>22824</td>\n",
       "      <td>12</td>\n",
       "      <td>3734</td>\n",
       "      <td>2244</td>\n",
       "      <td>13444</td>\n",
       "      <td>7743</td>\n",
       "      <td>1916</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21101</th>\n",
       "      <td>22825</td>\n",
       "      <td>13</td>\n",
       "      <td>3801</td>\n",
       "      <td>2242</td>\n",
       "      <td>12950</td>\n",
       "      <td>7943</td>\n",
       "      <td>1877</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21102</th>\n",
       "      <td>22826</td>\n",
       "      <td>14</td>\n",
       "      <td>3903</td>\n",
       "      <td>2241</td>\n",
       "      <td>12785</td>\n",
       "      <td>7606</td>\n",
       "      <td>1878</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21103</th>\n",
       "      <td>22827</td>\n",
       "      <td>15</td>\n",
       "      <td>3566</td>\n",
       "      <td>2240</td>\n",
       "      <td>13951</td>\n",
       "      <td>6210</td>\n",
       "      <td>1926</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21104</th>\n",
       "      <td>22828</td>\n",
       "      <td>16</td>\n",
       "      <td>3238</td>\n",
       "      <td>2237</td>\n",
       "      <td>13618</td>\n",
       "      <td>6741</td>\n",
       "      <td>1951</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21105</th>\n",
       "      <td>22829</td>\n",
       "      <td>17</td>\n",
       "      <td>2962</td>\n",
       "      <td>2236</td>\n",
       "      <td>14851</td>\n",
       "      <td>6611</td>\n",
       "      <td>2034</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21106</th>\n",
       "      <td>22830</td>\n",
       "      <td>18</td>\n",
       "      <td>2690</td>\n",
       "      <td>2237</td>\n",
       "      <td>16175</td>\n",
       "      <td>7281</td>\n",
       "      <td>2262</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21107</th>\n",
       "      <td>22831</td>\n",
       "      <td>19</td>\n",
       "      <td>2586</td>\n",
       "      <td>2238</td>\n",
       "      <td>16316</td>\n",
       "      <td>6807</td>\n",
       "      <td>2412</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21108</th>\n",
       "      <td>22832</td>\n",
       "      <td>20</td>\n",
       "      <td>2642</td>\n",
       "      <td>2239</td>\n",
       "      <td>15716</td>\n",
       "      <td>6664</td>\n",
       "      <td>2286</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21109</th>\n",
       "      <td>22833</td>\n",
       "      <td>21</td>\n",
       "      <td>2896</td>\n",
       "      <td>2240</td>\n",
       "      <td>13684</td>\n",
       "      <td>7498</td>\n",
       "      <td>2302</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21110</th>\n",
       "      <td>22834</td>\n",
       "      <td>22</td>\n",
       "      <td>2862</td>\n",
       "      <td>2241</td>\n",
       "      <td>12663</td>\n",
       "      <td>7195</td>\n",
       "      <td>2296</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21111</th>\n",
       "      <td>22835</td>\n",
       "      <td>23</td>\n",
       "      <td>2991</td>\n",
       "      <td>2242</td>\n",
       "      <td>11170</td>\n",
       "      <td>6655</td>\n",
       "      <td>2329</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21112 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       index Hour Geothermal Biomass Biogas Small Hydro  Wind Solar\n",
       "0          0    1       1056     323    170         250   632     0\n",
       "1          1    2       1055     318    169         245   632     0\n",
       "2          2    3       1058     316    168         240   677     0\n",
       "3          3    4       1063     318    168         238   923     0\n",
       "4          4    5       1066     318    168         247   875     0\n",
       "5          5    6       1066     317    169         247   998     0\n",
       "6          6    7       1066     312    166         244   763     0\n",
       "7          7    8       1067     313    167         269   544     1\n",
       "8          8    9       1065     315    169         280   572   191\n",
       "9          9   10       1063     316    167         294   721   299\n",
       "10        10   11       1063     314    169         294   658   278\n",
       "11        11   12       1066     317    171         271   772   198\n",
       "12        12   13       1068     324    171         270  1012   126\n",
       "13        13   14       1066     322    169         282  1350   139\n",
       "14        14   15       1067     326    170         292  1489   111\n",
       "15        15   16       1070     324    160         294  1475    39\n",
       "16        16   17       1071     320    147         295  1518    25\n",
       "17        17   18       1070     320    148         297  1511     3\n",
       "18        18   19       1070     314    153         302  1356     0\n",
       "19        19   20       1072     299    151         305  1083     0\n",
       "20        20   21       1072     300    124         307  1126     0\n",
       "21        21   22       1071     277    123         297  1024     0\n",
       "22        22   23       1071     284    126         266  1017     0\n",
       "23        23   24       1072     284    140         245  1018     0\n",
       "24        24    1       1072     285    145         253  1055     0\n",
       "25        25    2       1072     280    142         253   938     0\n",
       "26        26    3       1072     277    153         254   864     0\n",
       "27        27    4       1073     275    167         255   828     0\n",
       "28        28    5       1074     282    164         263   843     0\n",
       "29        29    6       1074     286    163         274   850     0\n",
       "...      ...  ...        ...     ...    ...         ...   ...   ...\n",
       "21082  22804   16       3374    2240  13205        6755  2201   NaN\n",
       "21083  22805   17       2987    2239  14676        6561  2453   NaN\n",
       "21084  22806   18       2928    2239  16505        6758  2622   NaN\n",
       "21085  22807   19       2925    2240  16105        7221  2572   NaN\n",
       "21086  22808   20       2917    2240  15448        7423  2542   NaN\n",
       "21087  22809   21       3155    2240  14137        7683  2404   NaN\n",
       "21088  22810   22       3055    2242  13259        7265  2061   NaN\n",
       "21089  22811   23       2951    2243  11561        7007  1868   NaN\n",
       "21090  22812   24       3079    2242  10166        5904  1879   NaN\n",
       "21091  22815    1        916     351    195         270  1561     0\n",
       "21092  22816    2        915     355    200         233  1662     0\n",
       "21093  22817    3        915     360    197         228  1770     0\n",
       "21094  22818    4        917     350    198         224  1794     0\n",
       "21095  22819    5        918     340    201         231  1526     0\n",
       "21096  22820    6        918     340    203         279  1034     0\n",
       "21097  22821    7        918     338    202         283   896     6\n",
       "21098  22822    8        917     337    198         287   807   124\n",
       "21099  22823    9        914     328    194         290   838   282\n",
       "21100  22824   12       3734    2244  13444        7743  1916   NaN\n",
       "21101  22825   13       3801    2242  12950        7943  1877   NaN\n",
       "21102  22826   14       3903    2241  12785        7606  1878   NaN\n",
       "21103  22827   15       3566    2240  13951        6210  1926   NaN\n",
       "21104  22828   16       3238    2237  13618        6741  1951   NaN\n",
       "21105  22829   17       2962    2236  14851        6611  2034   NaN\n",
       "21106  22830   18       2690    2237  16175        7281  2262   NaN\n",
       "21107  22831   19       2586    2238  16316        6807  2412   NaN\n",
       "21108  22832   20       2642    2239  15716        6664  2286   NaN\n",
       "21109  22833   21       2896    2240  13684        7498  2302   NaN\n",
       "21110  22834   22       2862    2241  12663        7195  2296   NaN\n",
       "21111  22835   23       2991    2242  11170        6655  2329   NaN\n",
       "\n",
       "[21112 rows x 8 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#resetting index values of the dataframe to match new datasize after processing and cleaning\n",
    "\n",
    "renewables_data_cleaned = renewables_data_cleaned.reset_index()\n",
    "renewables_data_cleaned"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hour</th>\n",
       "      <th>Geothermal</th>\n",
       "      <th>Biomass</th>\n",
       "      <th>Biogas</th>\n",
       "      <th>Small Hydro</th>\n",
       "      <th>Wind</th>\n",
       "      <th>Solar</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1056</td>\n",
       "      <td>323</td>\n",
       "      <td>170</td>\n",
       "      <td>250</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>1055</td>\n",
       "      <td>318</td>\n",
       "      <td>169</td>\n",
       "      <td>245</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>1058</td>\n",
       "      <td>316</td>\n",
       "      <td>168</td>\n",
       "      <td>240</td>\n",
       "      <td>677</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>1063</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>238</td>\n",
       "      <td>923</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>1066</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>247</td>\n",
       "      <td>875</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>169</td>\n",
       "      <td>247</td>\n",
       "      <td>998</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>1066</td>\n",
       "      <td>312</td>\n",
       "      <td>166</td>\n",
       "      <td>244</td>\n",
       "      <td>763</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>1067</td>\n",
       "      <td>313</td>\n",
       "      <td>167</td>\n",
       "      <td>269</td>\n",
       "      <td>544</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>1065</td>\n",
       "      <td>315</td>\n",
       "      <td>169</td>\n",
       "      <td>280</td>\n",
       "      <td>572</td>\n",
       "      <td>191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>1063</td>\n",
       "      <td>316</td>\n",
       "      <td>167</td>\n",
       "      <td>294</td>\n",
       "      <td>721</td>\n",
       "      <td>299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>1063</td>\n",
       "      <td>314</td>\n",
       "      <td>169</td>\n",
       "      <td>294</td>\n",
       "      <td>658</td>\n",
       "      <td>278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>171</td>\n",
       "      <td>271</td>\n",
       "      <td>772</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>1068</td>\n",
       "      <td>324</td>\n",
       "      <td>171</td>\n",
       "      <td>270</td>\n",
       "      <td>1012</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>1066</td>\n",
       "      <td>322</td>\n",
       "      <td>169</td>\n",
       "      <td>282</td>\n",
       "      <td>1350</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>1067</td>\n",
       "      <td>326</td>\n",
       "      <td>170</td>\n",
       "      <td>292</td>\n",
       "      <td>1489</td>\n",
       "      <td>111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>1070</td>\n",
       "      <td>324</td>\n",
       "      <td>160</td>\n",
       "      <td>294</td>\n",
       "      <td>1475</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>1071</td>\n",
       "      <td>320</td>\n",
       "      <td>147</td>\n",
       "      <td>295</td>\n",
       "      <td>1518</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>1070</td>\n",
       "      <td>320</td>\n",
       "      <td>148</td>\n",
       "      <td>297</td>\n",
       "      <td>1511</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>1070</td>\n",
       "      <td>314</td>\n",
       "      <td>153</td>\n",
       "      <td>302</td>\n",
       "      <td>1356</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>1072</td>\n",
       "      <td>299</td>\n",
       "      <td>151</td>\n",
       "      <td>305</td>\n",
       "      <td>1083</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>1072</td>\n",
       "      <td>300</td>\n",
       "      <td>124</td>\n",
       "      <td>307</td>\n",
       "      <td>1126</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>1071</td>\n",
       "      <td>277</td>\n",
       "      <td>123</td>\n",
       "      <td>297</td>\n",
       "      <td>1024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>1071</td>\n",
       "      <td>284</td>\n",
       "      <td>126</td>\n",
       "      <td>266</td>\n",
       "      <td>1017</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>1072</td>\n",
       "      <td>284</td>\n",
       "      <td>140</td>\n",
       "      <td>245</td>\n",
       "      <td>1018</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>1072</td>\n",
       "      <td>285</td>\n",
       "      <td>145</td>\n",
       "      <td>253</td>\n",
       "      <td>1055</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2</td>\n",
       "      <td>1072</td>\n",
       "      <td>280</td>\n",
       "      <td>142</td>\n",
       "      <td>253</td>\n",
       "      <td>938</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3</td>\n",
       "      <td>1072</td>\n",
       "      <td>277</td>\n",
       "      <td>153</td>\n",
       "      <td>254</td>\n",
       "      <td>864</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4</td>\n",
       "      <td>1073</td>\n",
       "      <td>275</td>\n",
       "      <td>167</td>\n",
       "      <td>255</td>\n",
       "      <td>828</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5</td>\n",
       "      <td>1074</td>\n",
       "      <td>282</td>\n",
       "      <td>164</td>\n",
       "      <td>263</td>\n",
       "      <td>843</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>6</td>\n",
       "      <td>1074</td>\n",
       "      <td>286</td>\n",
       "      <td>163</td>\n",
       "      <td>274</td>\n",
       "      <td>850</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21082</th>\n",
       "      <td>16</td>\n",
       "      <td>3374</td>\n",
       "      <td>2240</td>\n",
       "      <td>13205</td>\n",
       "      <td>6755</td>\n",
       "      <td>2201</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21083</th>\n",
       "      <td>17</td>\n",
       "      <td>2987</td>\n",
       "      <td>2239</td>\n",
       "      <td>14676</td>\n",
       "      <td>6561</td>\n",
       "      <td>2453</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21084</th>\n",
       "      <td>18</td>\n",
       "      <td>2928</td>\n",
       "      <td>2239</td>\n",
       "      <td>16505</td>\n",
       "      <td>6758</td>\n",
       "      <td>2622</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21085</th>\n",
       "      <td>19</td>\n",
       "      <td>2925</td>\n",
       "      <td>2240</td>\n",
       "      <td>16105</td>\n",
       "      <td>7221</td>\n",
       "      <td>2572</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21086</th>\n",
       "      <td>20</td>\n",
       "      <td>2917</td>\n",
       "      <td>2240</td>\n",
       "      <td>15448</td>\n",
       "      <td>7423</td>\n",
       "      <td>2542</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21087</th>\n",
       "      <td>21</td>\n",
       "      <td>3155</td>\n",
       "      <td>2240</td>\n",
       "      <td>14137</td>\n",
       "      <td>7683</td>\n",
       "      <td>2404</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21088</th>\n",
       "      <td>22</td>\n",
       "      <td>3055</td>\n",
       "      <td>2242</td>\n",
       "      <td>13259</td>\n",
       "      <td>7265</td>\n",
       "      <td>2061</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21089</th>\n",
       "      <td>23</td>\n",
       "      <td>2951</td>\n",
       "      <td>2243</td>\n",
       "      <td>11561</td>\n",
       "      <td>7007</td>\n",
       "      <td>1868</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21090</th>\n",
       "      <td>24</td>\n",
       "      <td>3079</td>\n",
       "      <td>2242</td>\n",
       "      <td>10166</td>\n",
       "      <td>5904</td>\n",
       "      <td>1879</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21091</th>\n",
       "      <td>1</td>\n",
       "      <td>916</td>\n",
       "      <td>351</td>\n",
       "      <td>195</td>\n",
       "      <td>270</td>\n",
       "      <td>1561</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21092</th>\n",
       "      <td>2</td>\n",
       "      <td>915</td>\n",
       "      <td>355</td>\n",
       "      <td>200</td>\n",
       "      <td>233</td>\n",
       "      <td>1662</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21093</th>\n",
       "      <td>3</td>\n",
       "      <td>915</td>\n",
       "      <td>360</td>\n",
       "      <td>197</td>\n",
       "      <td>228</td>\n",
       "      <td>1770</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21094</th>\n",
       "      <td>4</td>\n",
       "      <td>917</td>\n",
       "      <td>350</td>\n",
       "      <td>198</td>\n",
       "      <td>224</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21095</th>\n",
       "      <td>5</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>201</td>\n",
       "      <td>231</td>\n",
       "      <td>1526</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21096</th>\n",
       "      <td>6</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>203</td>\n",
       "      <td>279</td>\n",
       "      <td>1034</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21097</th>\n",
       "      <td>7</td>\n",
       "      <td>918</td>\n",
       "      <td>338</td>\n",
       "      <td>202</td>\n",
       "      <td>283</td>\n",
       "      <td>896</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21098</th>\n",
       "      <td>8</td>\n",
       "      <td>917</td>\n",
       "      <td>337</td>\n",
       "      <td>198</td>\n",
       "      <td>287</td>\n",
       "      <td>807</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21099</th>\n",
       "      <td>9</td>\n",
       "      <td>914</td>\n",
       "      <td>328</td>\n",
       "      <td>194</td>\n",
       "      <td>290</td>\n",
       "      <td>838</td>\n",
       "      <td>282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21100</th>\n",
       "      <td>12</td>\n",
       "      <td>3734</td>\n",
       "      <td>2244</td>\n",
       "      <td>13444</td>\n",
       "      <td>7743</td>\n",
       "      <td>1916</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21101</th>\n",
       "      <td>13</td>\n",
       "      <td>3801</td>\n",
       "      <td>2242</td>\n",
       "      <td>12950</td>\n",
       "      <td>7943</td>\n",
       "      <td>1877</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21102</th>\n",
       "      <td>14</td>\n",
       "      <td>3903</td>\n",
       "      <td>2241</td>\n",
       "      <td>12785</td>\n",
       "      <td>7606</td>\n",
       "      <td>1878</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21103</th>\n",
       "      <td>15</td>\n",
       "      <td>3566</td>\n",
       "      <td>2240</td>\n",
       "      <td>13951</td>\n",
       "      <td>6210</td>\n",
       "      <td>1926</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21104</th>\n",
       "      <td>16</td>\n",
       "      <td>3238</td>\n",
       "      <td>2237</td>\n",
       "      <td>13618</td>\n",
       "      <td>6741</td>\n",
       "      <td>1951</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21105</th>\n",
       "      <td>17</td>\n",
       "      <td>2962</td>\n",
       "      <td>2236</td>\n",
       "      <td>14851</td>\n",
       "      <td>6611</td>\n",
       "      <td>2034</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21106</th>\n",
       "      <td>18</td>\n",
       "      <td>2690</td>\n",
       "      <td>2237</td>\n",
       "      <td>16175</td>\n",
       "      <td>7281</td>\n",
       "      <td>2262</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21107</th>\n",
       "      <td>19</td>\n",
       "      <td>2586</td>\n",
       "      <td>2238</td>\n",
       "      <td>16316</td>\n",
       "      <td>6807</td>\n",
       "      <td>2412</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21108</th>\n",
       "      <td>20</td>\n",
       "      <td>2642</td>\n",
       "      <td>2239</td>\n",
       "      <td>15716</td>\n",
       "      <td>6664</td>\n",
       "      <td>2286</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21109</th>\n",
       "      <td>21</td>\n",
       "      <td>2896</td>\n",
       "      <td>2240</td>\n",
       "      <td>13684</td>\n",
       "      <td>7498</td>\n",
       "      <td>2302</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21110</th>\n",
       "      <td>22</td>\n",
       "      <td>2862</td>\n",
       "      <td>2241</td>\n",
       "      <td>12663</td>\n",
       "      <td>7195</td>\n",
       "      <td>2296</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21111</th>\n",
       "      <td>23</td>\n",
       "      <td>2991</td>\n",
       "      <td>2242</td>\n",
       "      <td>11170</td>\n",
       "      <td>6655</td>\n",
       "      <td>2329</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21112 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Hour Geothermal Biomass Biogas Small Hydro  Wind Solar\n",
       "0        1       1056     323    170         250   632     0\n",
       "1        2       1055     318    169         245   632     0\n",
       "2        3       1058     316    168         240   677     0\n",
       "3        4       1063     318    168         238   923     0\n",
       "4        5       1066     318    168         247   875     0\n",
       "5        6       1066     317    169         247   998     0\n",
       "6        7       1066     312    166         244   763     0\n",
       "7        8       1067     313    167         269   544     1\n",
       "8        9       1065     315    169         280   572   191\n",
       "9       10       1063     316    167         294   721   299\n",
       "10      11       1063     314    169         294   658   278\n",
       "11      12       1066     317    171         271   772   198\n",
       "12      13       1068     324    171         270  1012   126\n",
       "13      14       1066     322    169         282  1350   139\n",
       "14      15       1067     326    170         292  1489   111\n",
       "15      16       1070     324    160         294  1475    39\n",
       "16      17       1071     320    147         295  1518    25\n",
       "17      18       1070     320    148         297  1511     3\n",
       "18      19       1070     314    153         302  1356     0\n",
       "19      20       1072     299    151         305  1083     0\n",
       "20      21       1072     300    124         307  1126     0\n",
       "21      22       1071     277    123         297  1024     0\n",
       "22      23       1071     284    126         266  1017     0\n",
       "23      24       1072     284    140         245  1018     0\n",
       "24       1       1072     285    145         253  1055     0\n",
       "25       2       1072     280    142         253   938     0\n",
       "26       3       1072     277    153         254   864     0\n",
       "27       4       1073     275    167         255   828     0\n",
       "28       5       1074     282    164         263   843     0\n",
       "29       6       1074     286    163         274   850     0\n",
       "...    ...        ...     ...    ...         ...   ...   ...\n",
       "21082   16       3374    2240  13205        6755  2201   NaN\n",
       "21083   17       2987    2239  14676        6561  2453   NaN\n",
       "21084   18       2928    2239  16505        6758  2622   NaN\n",
       "21085   19       2925    2240  16105        7221  2572   NaN\n",
       "21086   20       2917    2240  15448        7423  2542   NaN\n",
       "21087   21       3155    2240  14137        7683  2404   NaN\n",
       "21088   22       3055    2242  13259        7265  2061   NaN\n",
       "21089   23       2951    2243  11561        7007  1868   NaN\n",
       "21090   24       3079    2242  10166        5904  1879   NaN\n",
       "21091    1        916     351    195         270  1561     0\n",
       "21092    2        915     355    200         233  1662     0\n",
       "21093    3        915     360    197         228  1770     0\n",
       "21094    4        917     350    198         224  1794     0\n",
       "21095    5        918     340    201         231  1526     0\n",
       "21096    6        918     340    203         279  1034     0\n",
       "21097    7        918     338    202         283   896     6\n",
       "21098    8        917     337    198         287   807   124\n",
       "21099    9        914     328    194         290   838   282\n",
       "21100   12       3734    2244  13444        7743  1916   NaN\n",
       "21101   13       3801    2242  12950        7943  1877   NaN\n",
       "21102   14       3903    2241  12785        7606  1878   NaN\n",
       "21103   15       3566    2240  13951        6210  1926   NaN\n",
       "21104   16       3238    2237  13618        6741  1951   NaN\n",
       "21105   17       2962    2236  14851        6611  2034   NaN\n",
       "21106   18       2690    2237  16175        7281  2262   NaN\n",
       "21107   19       2586    2238  16316        6807  2412   NaN\n",
       "21108   20       2642    2239  15716        6664  2286   NaN\n",
       "21109   21       2896    2240  13684        7498  2302   NaN\n",
       "21110   22       2862    2241  12663        7195  2296   NaN\n",
       "21111   23       2991    2242  11170        6655  2329   NaN\n",
       "\n",
       "[21112 rows x 7 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#droping previous, outdated index column\n",
    "\n",
    "renewables_data_cleaned = renewables_data_cleaned.drop('index', axis=1)\n",
    "renewables_data_cleaned"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "21112"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Creating a new date column based on data format\n",
    "\n",
    "dates = pd.date_range('4/20/2010 00:00', periods=21112, freq = 'H')\n",
    "len(dates)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hour</th>\n",
       "      <th>Geothermal</th>\n",
       "      <th>Biomass</th>\n",
       "      <th>Biogas</th>\n",
       "      <th>Small Hydro</th>\n",
       "      <th>Wind</th>\n",
       "      <th>Solar</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1056</td>\n",
       "      <td>323</td>\n",
       "      <td>170</td>\n",
       "      <td>250</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>1055</td>\n",
       "      <td>318</td>\n",
       "      <td>169</td>\n",
       "      <td>245</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>1058</td>\n",
       "      <td>316</td>\n",
       "      <td>168</td>\n",
       "      <td>240</td>\n",
       "      <td>677</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>1063</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>238</td>\n",
       "      <td>923</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>1066</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>247</td>\n",
       "      <td>875</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 04:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>169</td>\n",
       "      <td>247</td>\n",
       "      <td>998</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 05:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>1066</td>\n",
       "      <td>312</td>\n",
       "      <td>166</td>\n",
       "      <td>244</td>\n",
       "      <td>763</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>1067</td>\n",
       "      <td>313</td>\n",
       "      <td>167</td>\n",
       "      <td>269</td>\n",
       "      <td>544</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-04-20 07:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>1065</td>\n",
       "      <td>315</td>\n",
       "      <td>169</td>\n",
       "      <td>280</td>\n",
       "      <td>572</td>\n",
       "      <td>191</td>\n",
       "      <td>2010-04-20 08:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>1063</td>\n",
       "      <td>316</td>\n",
       "      <td>167</td>\n",
       "      <td>294</td>\n",
       "      <td>721</td>\n",
       "      <td>299</td>\n",
       "      <td>2010-04-20 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>1063</td>\n",
       "      <td>314</td>\n",
       "      <td>169</td>\n",
       "      <td>294</td>\n",
       "      <td>658</td>\n",
       "      <td>278</td>\n",
       "      <td>2010-04-20 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>171</td>\n",
       "      <td>271</td>\n",
       "      <td>772</td>\n",
       "      <td>198</td>\n",
       "      <td>2010-04-20 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>1068</td>\n",
       "      <td>324</td>\n",
       "      <td>171</td>\n",
       "      <td>270</td>\n",
       "      <td>1012</td>\n",
       "      <td>126</td>\n",
       "      <td>2010-04-20 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>1066</td>\n",
       "      <td>322</td>\n",
       "      <td>169</td>\n",
       "      <td>282</td>\n",
       "      <td>1350</td>\n",
       "      <td>139</td>\n",
       "      <td>2010-04-20 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>1067</td>\n",
       "      <td>326</td>\n",
       "      <td>170</td>\n",
       "      <td>292</td>\n",
       "      <td>1489</td>\n",
       "      <td>111</td>\n",
       "      <td>2010-04-20 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>1070</td>\n",
       "      <td>324</td>\n",
       "      <td>160</td>\n",
       "      <td>294</td>\n",
       "      <td>1475</td>\n",
       "      <td>39</td>\n",
       "      <td>2010-04-20 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>1071</td>\n",
       "      <td>320</td>\n",
       "      <td>147</td>\n",
       "      <td>295</td>\n",
       "      <td>1518</td>\n",
       "      <td>25</td>\n",
       "      <td>2010-04-20 16:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>1070</td>\n",
       "      <td>320</td>\n",
       "      <td>148</td>\n",
       "      <td>297</td>\n",
       "      <td>1511</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-04-20 17:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>1070</td>\n",
       "      <td>314</td>\n",
       "      <td>153</td>\n",
       "      <td>302</td>\n",
       "      <td>1356</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>1072</td>\n",
       "      <td>299</td>\n",
       "      <td>151</td>\n",
       "      <td>305</td>\n",
       "      <td>1083</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 19:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>1072</td>\n",
       "      <td>300</td>\n",
       "      <td>124</td>\n",
       "      <td>307</td>\n",
       "      <td>1126</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 20:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>1071</td>\n",
       "      <td>277</td>\n",
       "      <td>123</td>\n",
       "      <td>297</td>\n",
       "      <td>1024</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 21:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>1071</td>\n",
       "      <td>284</td>\n",
       "      <td>126</td>\n",
       "      <td>266</td>\n",
       "      <td>1017</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 22:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>1072</td>\n",
       "      <td>284</td>\n",
       "      <td>140</td>\n",
       "      <td>245</td>\n",
       "      <td>1018</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 23:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>1072</td>\n",
       "      <td>285</td>\n",
       "      <td>145</td>\n",
       "      <td>253</td>\n",
       "      <td>1055</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2</td>\n",
       "      <td>1072</td>\n",
       "      <td>280</td>\n",
       "      <td>142</td>\n",
       "      <td>253</td>\n",
       "      <td>938</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3</td>\n",
       "      <td>1072</td>\n",
       "      <td>277</td>\n",
       "      <td>153</td>\n",
       "      <td>254</td>\n",
       "      <td>864</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4</td>\n",
       "      <td>1073</td>\n",
       "      <td>275</td>\n",
       "      <td>167</td>\n",
       "      <td>255</td>\n",
       "      <td>828</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5</td>\n",
       "      <td>1074</td>\n",
       "      <td>282</td>\n",
       "      <td>164</td>\n",
       "      <td>263</td>\n",
       "      <td>843</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 04:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>6</td>\n",
       "      <td>1074</td>\n",
       "      <td>286</td>\n",
       "      <td>163</td>\n",
       "      <td>274</td>\n",
       "      <td>850</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 05:00:00</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21082</th>\n",
       "      <td>16</td>\n",
       "      <td>3374</td>\n",
       "      <td>2240</td>\n",
       "      <td>13205</td>\n",
       "      <td>6755</td>\n",
       "      <td>2201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21083</th>\n",
       "      <td>17</td>\n",
       "      <td>2987</td>\n",
       "      <td>2239</td>\n",
       "      <td>14676</td>\n",
       "      <td>6561</td>\n",
       "      <td>2453</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21084</th>\n",
       "      <td>18</td>\n",
       "      <td>2928</td>\n",
       "      <td>2239</td>\n",
       "      <td>16505</td>\n",
       "      <td>6758</td>\n",
       "      <td>2622</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21085</th>\n",
       "      <td>19</td>\n",
       "      <td>2925</td>\n",
       "      <td>2240</td>\n",
       "      <td>16105</td>\n",
       "      <td>7221</td>\n",
       "      <td>2572</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21086</th>\n",
       "      <td>20</td>\n",
       "      <td>2917</td>\n",
       "      <td>2240</td>\n",
       "      <td>15448</td>\n",
       "      <td>7423</td>\n",
       "      <td>2542</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21087</th>\n",
       "      <td>21</td>\n",
       "      <td>3155</td>\n",
       "      <td>2240</td>\n",
       "      <td>14137</td>\n",
       "      <td>7683</td>\n",
       "      <td>2404</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21088</th>\n",
       "      <td>22</td>\n",
       "      <td>3055</td>\n",
       "      <td>2242</td>\n",
       "      <td>13259</td>\n",
       "      <td>7265</td>\n",
       "      <td>2061</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 16:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21089</th>\n",
       "      <td>23</td>\n",
       "      <td>2951</td>\n",
       "      <td>2243</td>\n",
       "      <td>11561</td>\n",
       "      <td>7007</td>\n",
       "      <td>1868</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 17:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21090</th>\n",
       "      <td>24</td>\n",
       "      <td>3079</td>\n",
       "      <td>2242</td>\n",
       "      <td>10166</td>\n",
       "      <td>5904</td>\n",
       "      <td>1879</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21091</th>\n",
       "      <td>1</td>\n",
       "      <td>916</td>\n",
       "      <td>351</td>\n",
       "      <td>195</td>\n",
       "      <td>270</td>\n",
       "      <td>1561</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 19:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21092</th>\n",
       "      <td>2</td>\n",
       "      <td>915</td>\n",
       "      <td>355</td>\n",
       "      <td>200</td>\n",
       "      <td>233</td>\n",
       "      <td>1662</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 20:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21093</th>\n",
       "      <td>3</td>\n",
       "      <td>915</td>\n",
       "      <td>360</td>\n",
       "      <td>197</td>\n",
       "      <td>228</td>\n",
       "      <td>1770</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 21:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21094</th>\n",
       "      <td>4</td>\n",
       "      <td>917</td>\n",
       "      <td>350</td>\n",
       "      <td>198</td>\n",
       "      <td>224</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 22:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21095</th>\n",
       "      <td>5</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>201</td>\n",
       "      <td>231</td>\n",
       "      <td>1526</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 23:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21096</th>\n",
       "      <td>6</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>203</td>\n",
       "      <td>279</td>\n",
       "      <td>1034</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-15 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21097</th>\n",
       "      <td>7</td>\n",
       "      <td>918</td>\n",
       "      <td>338</td>\n",
       "      <td>202</td>\n",
       "      <td>283</td>\n",
       "      <td>896</td>\n",
       "      <td>6</td>\n",
       "      <td>2012-09-15 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21098</th>\n",
       "      <td>8</td>\n",
       "      <td>917</td>\n",
       "      <td>337</td>\n",
       "      <td>198</td>\n",
       "      <td>287</td>\n",
       "      <td>807</td>\n",
       "      <td>124</td>\n",
       "      <td>2012-09-15 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21099</th>\n",
       "      <td>9</td>\n",
       "      <td>914</td>\n",
       "      <td>328</td>\n",
       "      <td>194</td>\n",
       "      <td>290</td>\n",
       "      <td>838</td>\n",
       "      <td>282</td>\n",
       "      <td>2012-09-15 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21100</th>\n",
       "      <td>12</td>\n",
       "      <td>3734</td>\n",
       "      <td>2244</td>\n",
       "      <td>13444</td>\n",
       "      <td>7743</td>\n",
       "      <td>1916</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 04:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21101</th>\n",
       "      <td>13</td>\n",
       "      <td>3801</td>\n",
       "      <td>2242</td>\n",
       "      <td>12950</td>\n",
       "      <td>7943</td>\n",
       "      <td>1877</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 05:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21102</th>\n",
       "      <td>14</td>\n",
       "      <td>3903</td>\n",
       "      <td>2241</td>\n",
       "      <td>12785</td>\n",
       "      <td>7606</td>\n",
       "      <td>1878</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21103</th>\n",
       "      <td>15</td>\n",
       "      <td>3566</td>\n",
       "      <td>2240</td>\n",
       "      <td>13951</td>\n",
       "      <td>6210</td>\n",
       "      <td>1926</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 07:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21104</th>\n",
       "      <td>16</td>\n",
       "      <td>3238</td>\n",
       "      <td>2237</td>\n",
       "      <td>13618</td>\n",
       "      <td>6741</td>\n",
       "      <td>1951</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 08:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21105</th>\n",
       "      <td>17</td>\n",
       "      <td>2962</td>\n",
       "      <td>2236</td>\n",
       "      <td>14851</td>\n",
       "      <td>6611</td>\n",
       "      <td>2034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21106</th>\n",
       "      <td>18</td>\n",
       "      <td>2690</td>\n",
       "      <td>2237</td>\n",
       "      <td>16175</td>\n",
       "      <td>7281</td>\n",
       "      <td>2262</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21107</th>\n",
       "      <td>19</td>\n",
       "      <td>2586</td>\n",
       "      <td>2238</td>\n",
       "      <td>16316</td>\n",
       "      <td>6807</td>\n",
       "      <td>2412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21108</th>\n",
       "      <td>20</td>\n",
       "      <td>2642</td>\n",
       "      <td>2239</td>\n",
       "      <td>15716</td>\n",
       "      <td>6664</td>\n",
       "      <td>2286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21109</th>\n",
       "      <td>21</td>\n",
       "      <td>2896</td>\n",
       "      <td>2240</td>\n",
       "      <td>13684</td>\n",
       "      <td>7498</td>\n",
       "      <td>2302</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21110</th>\n",
       "      <td>22</td>\n",
       "      <td>2862</td>\n",
       "      <td>2241</td>\n",
       "      <td>12663</td>\n",
       "      <td>7195</td>\n",
       "      <td>2296</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21111</th>\n",
       "      <td>23</td>\n",
       "      <td>2991</td>\n",
       "      <td>2242</td>\n",
       "      <td>11170</td>\n",
       "      <td>6655</td>\n",
       "      <td>2329</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 15:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21112 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Hour Geothermal Biomass Biogas Small Hydro  Wind Solar  \\\n",
       "0        1       1056     323    170         250   632     0   \n",
       "1        2       1055     318    169         245   632     0   \n",
       "2        3       1058     316    168         240   677     0   \n",
       "3        4       1063     318    168         238   923     0   \n",
       "4        5       1066     318    168         247   875     0   \n",
       "5        6       1066     317    169         247   998     0   \n",
       "6        7       1066     312    166         244   763     0   \n",
       "7        8       1067     313    167         269   544     1   \n",
       "8        9       1065     315    169         280   572   191   \n",
       "9       10       1063     316    167         294   721   299   \n",
       "10      11       1063     314    169         294   658   278   \n",
       "11      12       1066     317    171         271   772   198   \n",
       "12      13       1068     324    171         270  1012   126   \n",
       "13      14       1066     322    169         282  1350   139   \n",
       "14      15       1067     326    170         292  1489   111   \n",
       "15      16       1070     324    160         294  1475    39   \n",
       "16      17       1071     320    147         295  1518    25   \n",
       "17      18       1070     320    148         297  1511     3   \n",
       "18      19       1070     314    153         302  1356     0   \n",
       "19      20       1072     299    151         305  1083     0   \n",
       "20      21       1072     300    124         307  1126     0   \n",
       "21      22       1071     277    123         297  1024     0   \n",
       "22      23       1071     284    126         266  1017     0   \n",
       "23      24       1072     284    140         245  1018     0   \n",
       "24       1       1072     285    145         253  1055     0   \n",
       "25       2       1072     280    142         253   938     0   \n",
       "26       3       1072     277    153         254   864     0   \n",
       "27       4       1073     275    167         255   828     0   \n",
       "28       5       1074     282    164         263   843     0   \n",
       "29       6       1074     286    163         274   850     0   \n",
       "...    ...        ...     ...    ...         ...   ...   ...   \n",
       "21082   16       3374    2240  13205        6755  2201   NaN   \n",
       "21083   17       2987    2239  14676        6561  2453   NaN   \n",
       "21084   18       2928    2239  16505        6758  2622   NaN   \n",
       "21085   19       2925    2240  16105        7221  2572   NaN   \n",
       "21086   20       2917    2240  15448        7423  2542   NaN   \n",
       "21087   21       3155    2240  14137        7683  2404   NaN   \n",
       "21088   22       3055    2242  13259        7265  2061   NaN   \n",
       "21089   23       2951    2243  11561        7007  1868   NaN   \n",
       "21090   24       3079    2242  10166        5904  1879   NaN   \n",
       "21091    1        916     351    195         270  1561     0   \n",
       "21092    2        915     355    200         233  1662     0   \n",
       "21093    3        915     360    197         228  1770     0   \n",
       "21094    4        917     350    198         224  1794     0   \n",
       "21095    5        918     340    201         231  1526     0   \n",
       "21096    6        918     340    203         279  1034     0   \n",
       "21097    7        918     338    202         283   896     6   \n",
       "21098    8        917     337    198         287   807   124   \n",
       "21099    9        914     328    194         290   838   282   \n",
       "21100   12       3734    2244  13444        7743  1916   NaN   \n",
       "21101   13       3801    2242  12950        7943  1877   NaN   \n",
       "21102   14       3903    2241  12785        7606  1878   NaN   \n",
       "21103   15       3566    2240  13951        6210  1926   NaN   \n",
       "21104   16       3238    2237  13618        6741  1951   NaN   \n",
       "21105   17       2962    2236  14851        6611  2034   NaN   \n",
       "21106   18       2690    2237  16175        7281  2262   NaN   \n",
       "21107   19       2586    2238  16316        6807  2412   NaN   \n",
       "21108   20       2642    2239  15716        6664  2286   NaN   \n",
       "21109   21       2896    2240  13684        7498  2302   NaN   \n",
       "21110   22       2862    2241  12663        7195  2296   NaN   \n",
       "21111   23       2991    2242  11170        6655  2329   NaN   \n",
       "\n",
       "                     Date  \n",
       "0     2010-04-20 00:00:00  \n",
       "1     2010-04-20 01:00:00  \n",
       "2     2010-04-20 02:00:00  \n",
       "3     2010-04-20 03:00:00  \n",
       "4     2010-04-20 04:00:00  \n",
       "5     2010-04-20 05:00:00  \n",
       "6     2010-04-20 06:00:00  \n",
       "7     2010-04-20 07:00:00  \n",
       "8     2010-04-20 08:00:00  \n",
       "9     2010-04-20 09:00:00  \n",
       "10    2010-04-20 10:00:00  \n",
       "11    2010-04-20 11:00:00  \n",
       "12    2010-04-20 12:00:00  \n",
       "13    2010-04-20 13:00:00  \n",
       "14    2010-04-20 14:00:00  \n",
       "15    2010-04-20 15:00:00  \n",
       "16    2010-04-20 16:00:00  \n",
       "17    2010-04-20 17:00:00  \n",
       "18    2010-04-20 18:00:00  \n",
       "19    2010-04-20 19:00:00  \n",
       "20    2010-04-20 20:00:00  \n",
       "21    2010-04-20 21:00:00  \n",
       "22    2010-04-20 22:00:00  \n",
       "23    2010-04-20 23:00:00  \n",
       "24    2010-04-21 00:00:00  \n",
       "25    2010-04-21 01:00:00  \n",
       "26    2010-04-21 02:00:00  \n",
       "27    2010-04-21 03:00:00  \n",
       "28    2010-04-21 04:00:00  \n",
       "29    2010-04-21 05:00:00  \n",
       "...                   ...  \n",
       "21082 2012-09-14 10:00:00  \n",
       "21083 2012-09-14 11:00:00  \n",
       "21084 2012-09-14 12:00:00  \n",
       "21085 2012-09-14 13:00:00  \n",
       "21086 2012-09-14 14:00:00  \n",
       "21087 2012-09-14 15:00:00  \n",
       "21088 2012-09-14 16:00:00  \n",
       "21089 2012-09-14 17:00:00  \n",
       "21090 2012-09-14 18:00:00  \n",
       "21091 2012-09-14 19:00:00  \n",
       "21092 2012-09-14 20:00:00  \n",
       "21093 2012-09-14 21:00:00  \n",
       "21094 2012-09-14 22:00:00  \n",
       "21095 2012-09-14 23:00:00  \n",
       "21096 2012-09-15 00:00:00  \n",
       "21097 2012-09-15 01:00:00  \n",
       "21098 2012-09-15 02:00:00  \n",
       "21099 2012-09-15 03:00:00  \n",
       "21100 2012-09-15 04:00:00  \n",
       "21101 2012-09-15 05:00:00  \n",
       "21102 2012-09-15 06:00:00  \n",
       "21103 2012-09-15 07:00:00  \n",
       "21104 2012-09-15 08:00:00  \n",
       "21105 2012-09-15 09:00:00  \n",
       "21106 2012-09-15 10:00:00  \n",
       "21107 2012-09-15 11:00:00  \n",
       "21108 2012-09-15 12:00:00  \n",
       "21109 2012-09-15 13:00:00  \n",
       "21110 2012-09-15 14:00:00  \n",
       "21111 2012-09-15 15:00:00  \n",
       "\n",
       "[21112 rows x 8 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Adding above created date column to the renewables_data_cleaned dataframe\n",
    "\n",
    "renewables_data_cleaned[\"Date\"] = pd.Series(dates)\n",
    "renewables_data_cleaned "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Hour</th>\n",
       "      <th>Geothermal</th>\n",
       "      <th>Biomass</th>\n",
       "      <th>Biogas</th>\n",
       "      <th>Small Hydro</th>\n",
       "      <th>Wind</th>\n",
       "      <th>Solar</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1056</td>\n",
       "      <td>323</td>\n",
       "      <td>170</td>\n",
       "      <td>250</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>1055</td>\n",
       "      <td>318</td>\n",
       "      <td>169</td>\n",
       "      <td>245</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>1058</td>\n",
       "      <td>316</td>\n",
       "      <td>168</td>\n",
       "      <td>240</td>\n",
       "      <td>677</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>1063</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>238</td>\n",
       "      <td>923</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>1066</td>\n",
       "      <td>318</td>\n",
       "      <td>168</td>\n",
       "      <td>247</td>\n",
       "      <td>875</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 04:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>169</td>\n",
       "      <td>247</td>\n",
       "      <td>998</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 05:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>1066</td>\n",
       "      <td>312</td>\n",
       "      <td>166</td>\n",
       "      <td>244</td>\n",
       "      <td>763</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>1067</td>\n",
       "      <td>313</td>\n",
       "      <td>167</td>\n",
       "      <td>269</td>\n",
       "      <td>544</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-04-20 07:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>1065</td>\n",
       "      <td>315</td>\n",
       "      <td>169</td>\n",
       "      <td>280</td>\n",
       "      <td>572</td>\n",
       "      <td>191</td>\n",
       "      <td>2010-04-20 08:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>1063</td>\n",
       "      <td>316</td>\n",
       "      <td>167</td>\n",
       "      <td>294</td>\n",
       "      <td>721</td>\n",
       "      <td>299</td>\n",
       "      <td>2010-04-20 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>1063</td>\n",
       "      <td>314</td>\n",
       "      <td>169</td>\n",
       "      <td>294</td>\n",
       "      <td>658</td>\n",
       "      <td>278</td>\n",
       "      <td>2010-04-20 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>1066</td>\n",
       "      <td>317</td>\n",
       "      <td>171</td>\n",
       "      <td>271</td>\n",
       "      <td>772</td>\n",
       "      <td>198</td>\n",
       "      <td>2010-04-20 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>1068</td>\n",
       "      <td>324</td>\n",
       "      <td>171</td>\n",
       "      <td>270</td>\n",
       "      <td>1012</td>\n",
       "      <td>126</td>\n",
       "      <td>2010-04-20 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>1066</td>\n",
       "      <td>322</td>\n",
       "      <td>169</td>\n",
       "      <td>282</td>\n",
       "      <td>1350</td>\n",
       "      <td>139</td>\n",
       "      <td>2010-04-20 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>1067</td>\n",
       "      <td>326</td>\n",
       "      <td>170</td>\n",
       "      <td>292</td>\n",
       "      <td>1489</td>\n",
       "      <td>111</td>\n",
       "      <td>2010-04-20 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>1070</td>\n",
       "      <td>324</td>\n",
       "      <td>160</td>\n",
       "      <td>294</td>\n",
       "      <td>1475</td>\n",
       "      <td>39</td>\n",
       "      <td>2010-04-20 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>1071</td>\n",
       "      <td>320</td>\n",
       "      <td>147</td>\n",
       "      <td>295</td>\n",
       "      <td>1518</td>\n",
       "      <td>25</td>\n",
       "      <td>2010-04-20 16:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>1070</td>\n",
       "      <td>320</td>\n",
       "      <td>148</td>\n",
       "      <td>297</td>\n",
       "      <td>1511</td>\n",
       "      <td>3</td>\n",
       "      <td>2010-04-20 17:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>1070</td>\n",
       "      <td>314</td>\n",
       "      <td>153</td>\n",
       "      <td>302</td>\n",
       "      <td>1356</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>1072</td>\n",
       "      <td>299</td>\n",
       "      <td>151</td>\n",
       "      <td>305</td>\n",
       "      <td>1083</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 19:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>1072</td>\n",
       "      <td>300</td>\n",
       "      <td>124</td>\n",
       "      <td>307</td>\n",
       "      <td>1126</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 20:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>1071</td>\n",
       "      <td>277</td>\n",
       "      <td>123</td>\n",
       "      <td>297</td>\n",
       "      <td>1024</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 21:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>1071</td>\n",
       "      <td>284</td>\n",
       "      <td>126</td>\n",
       "      <td>266</td>\n",
       "      <td>1017</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 22:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>1072</td>\n",
       "      <td>284</td>\n",
       "      <td>140</td>\n",
       "      <td>245</td>\n",
       "      <td>1018</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-20 23:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>1072</td>\n",
       "      <td>285</td>\n",
       "      <td>145</td>\n",
       "      <td>253</td>\n",
       "      <td>1055</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2</td>\n",
       "      <td>1072</td>\n",
       "      <td>280</td>\n",
       "      <td>142</td>\n",
       "      <td>253</td>\n",
       "      <td>938</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3</td>\n",
       "      <td>1072</td>\n",
       "      <td>277</td>\n",
       "      <td>153</td>\n",
       "      <td>254</td>\n",
       "      <td>864</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4</td>\n",
       "      <td>1073</td>\n",
       "      <td>275</td>\n",
       "      <td>167</td>\n",
       "      <td>255</td>\n",
       "      <td>828</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5</td>\n",
       "      <td>1074</td>\n",
       "      <td>282</td>\n",
       "      <td>164</td>\n",
       "      <td>263</td>\n",
       "      <td>843</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 04:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>6</td>\n",
       "      <td>1074</td>\n",
       "      <td>286</td>\n",
       "      <td>163</td>\n",
       "      <td>274</td>\n",
       "      <td>850</td>\n",
       "      <td>0</td>\n",
       "      <td>2010-04-21 05:00:00</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21082</th>\n",
       "      <td>16</td>\n",
       "      <td>3374</td>\n",
       "      <td>2240</td>\n",
       "      <td>13205</td>\n",
       "      <td>6755</td>\n",
       "      <td>2201</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21083</th>\n",
       "      <td>17</td>\n",
       "      <td>2987</td>\n",
       "      <td>2239</td>\n",
       "      <td>14676</td>\n",
       "      <td>6561</td>\n",
       "      <td>2453</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21084</th>\n",
       "      <td>18</td>\n",
       "      <td>2928</td>\n",
       "      <td>2239</td>\n",
       "      <td>16505</td>\n",
       "      <td>6758</td>\n",
       "      <td>2622</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21085</th>\n",
       "      <td>19</td>\n",
       "      <td>2925</td>\n",
       "      <td>2240</td>\n",
       "      <td>16105</td>\n",
       "      <td>7221</td>\n",
       "      <td>2572</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21086</th>\n",
       "      <td>20</td>\n",
       "      <td>2917</td>\n",
       "      <td>2240</td>\n",
       "      <td>15448</td>\n",
       "      <td>7423</td>\n",
       "      <td>2542</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21087</th>\n",
       "      <td>21</td>\n",
       "      <td>3155</td>\n",
       "      <td>2240</td>\n",
       "      <td>14137</td>\n",
       "      <td>7683</td>\n",
       "      <td>2404</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21088</th>\n",
       "      <td>22</td>\n",
       "      <td>3055</td>\n",
       "      <td>2242</td>\n",
       "      <td>13259</td>\n",
       "      <td>7265</td>\n",
       "      <td>2061</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 16:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21089</th>\n",
       "      <td>23</td>\n",
       "      <td>2951</td>\n",
       "      <td>2243</td>\n",
       "      <td>11561</td>\n",
       "      <td>7007</td>\n",
       "      <td>1868</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 17:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21090</th>\n",
       "      <td>24</td>\n",
       "      <td>3079</td>\n",
       "      <td>2242</td>\n",
       "      <td>10166</td>\n",
       "      <td>5904</td>\n",
       "      <td>1879</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-14 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21091</th>\n",
       "      <td>1</td>\n",
       "      <td>916</td>\n",
       "      <td>351</td>\n",
       "      <td>195</td>\n",
       "      <td>270</td>\n",
       "      <td>1561</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 19:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21092</th>\n",
       "      <td>2</td>\n",
       "      <td>915</td>\n",
       "      <td>355</td>\n",
       "      <td>200</td>\n",
       "      <td>233</td>\n",
       "      <td>1662</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 20:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21093</th>\n",
       "      <td>3</td>\n",
       "      <td>915</td>\n",
       "      <td>360</td>\n",
       "      <td>197</td>\n",
       "      <td>228</td>\n",
       "      <td>1770</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 21:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21094</th>\n",
       "      <td>4</td>\n",
       "      <td>917</td>\n",
       "      <td>350</td>\n",
       "      <td>198</td>\n",
       "      <td>224</td>\n",
       "      <td>1794</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 22:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21095</th>\n",
       "      <td>5</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>201</td>\n",
       "      <td>231</td>\n",
       "      <td>1526</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-14 23:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21096</th>\n",
       "      <td>6</td>\n",
       "      <td>918</td>\n",
       "      <td>340</td>\n",
       "      <td>203</td>\n",
       "      <td>279</td>\n",
       "      <td>1034</td>\n",
       "      <td>0</td>\n",
       "      <td>2012-09-15 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21097</th>\n",
       "      <td>7</td>\n",
       "      <td>918</td>\n",
       "      <td>338</td>\n",
       "      <td>202</td>\n",
       "      <td>283</td>\n",
       "      <td>896</td>\n",
       "      <td>6</td>\n",
       "      <td>2012-09-15 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21098</th>\n",
       "      <td>8</td>\n",
       "      <td>917</td>\n",
       "      <td>337</td>\n",
       "      <td>198</td>\n",
       "      <td>287</td>\n",
       "      <td>807</td>\n",
       "      <td>124</td>\n",
       "      <td>2012-09-15 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21099</th>\n",
       "      <td>9</td>\n",
       "      <td>914</td>\n",
       "      <td>328</td>\n",
       "      <td>194</td>\n",
       "      <td>290</td>\n",
       "      <td>838</td>\n",
       "      <td>282</td>\n",
       "      <td>2012-09-15 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21100</th>\n",
       "      <td>12</td>\n",
       "      <td>3734</td>\n",
       "      <td>2244</td>\n",
       "      <td>13444</td>\n",
       "      <td>7743</td>\n",
       "      <td>1916</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 04:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21101</th>\n",
       "      <td>13</td>\n",
       "      <td>3801</td>\n",
       "      <td>2242</td>\n",
       "      <td>12950</td>\n",
       "      <td>7943</td>\n",
       "      <td>1877</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 05:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21102</th>\n",
       "      <td>14</td>\n",
       "      <td>3903</td>\n",
       "      <td>2241</td>\n",
       "      <td>12785</td>\n",
       "      <td>7606</td>\n",
       "      <td>1878</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21103</th>\n",
       "      <td>15</td>\n",
       "      <td>3566</td>\n",
       "      <td>2240</td>\n",
       "      <td>13951</td>\n",
       "      <td>6210</td>\n",
       "      <td>1926</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 07:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21104</th>\n",
       "      <td>16</td>\n",
       "      <td>3238</td>\n",
       "      <td>2237</td>\n",
       "      <td>13618</td>\n",
       "      <td>6741</td>\n",
       "      <td>1951</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 08:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21105</th>\n",
       "      <td>17</td>\n",
       "      <td>2962</td>\n",
       "      <td>2236</td>\n",
       "      <td>14851</td>\n",
       "      <td>6611</td>\n",
       "      <td>2034</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21106</th>\n",
       "      <td>18</td>\n",
       "      <td>2690</td>\n",
       "      <td>2237</td>\n",
       "      <td>16175</td>\n",
       "      <td>7281</td>\n",
       "      <td>2262</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 10:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21107</th>\n",
       "      <td>19</td>\n",
       "      <td>2586</td>\n",
       "      <td>2238</td>\n",
       "      <td>16316</td>\n",
       "      <td>6807</td>\n",
       "      <td>2412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 11:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21108</th>\n",
       "      <td>20</td>\n",
       "      <td>2642</td>\n",
       "      <td>2239</td>\n",
       "      <td>15716</td>\n",
       "      <td>6664</td>\n",
       "      <td>2286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21109</th>\n",
       "      <td>21</td>\n",
       "      <td>2896</td>\n",
       "      <td>2240</td>\n",
       "      <td>13684</td>\n",
       "      <td>7498</td>\n",
       "      <td>2302</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21110</th>\n",
       "      <td>22</td>\n",
       "      <td>2862</td>\n",
       "      <td>2241</td>\n",
       "      <td>12663</td>\n",
       "      <td>7195</td>\n",
       "      <td>2296</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21111</th>\n",
       "      <td>23</td>\n",
       "      <td>2991</td>\n",
       "      <td>2242</td>\n",
       "      <td>11170</td>\n",
       "      <td>6655</td>\n",
       "      <td>2329</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-09-15 15:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21112 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Hour Geothermal Biomass Biogas Small Hydro  Wind Solar  \\\n",
       "0        1       1056     323    170         250   632     0   \n",
       "1        2       1055     318    169         245   632     0   \n",
       "2        3       1058     316    168         240   677     0   \n",
       "3        4       1063     318    168         238   923     0   \n",
       "4        5       1066     318    168         247   875     0   \n",
       "5        6       1066     317    169         247   998     0   \n",
       "6        7       1066     312    166         244   763     0   \n",
       "7        8       1067     313    167         269   544     1   \n",
       "8        9       1065     315    169         280   572   191   \n",
       "9       10       1063     316    167         294   721   299   \n",
       "10      11       1063     314    169         294   658   278   \n",
       "11      12       1066     317    171         271   772   198   \n",
       "12      13       1068     324    171         270  1012   126   \n",
       "13      14       1066     322    169         282  1350   139   \n",
       "14      15       1067     326    170         292  1489   111   \n",
       "15      16       1070     324    160         294  1475    39   \n",
       "16      17       1071     320    147         295  1518    25   \n",
       "17      18       1070     320    148         297  1511     3   \n",
       "18      19       1070     314    153         302  1356     0   \n",
       "19      20       1072     299    151         305  1083     0   \n",
       "20      21       1072     300    124         307  1126     0   \n",
       "21      22       1071     277    123         297  1024     0   \n",
       "22      23       1071     284    126         266  1017     0   \n",
       "23      24       1072     284    140         245  1018     0   \n",
       "24       1       1072     285    145         253  1055     0   \n",
       "25       2       1072     280    142         253   938     0   \n",
       "26       3       1072     277    153         254   864     0   \n",
       "27       4       1073     275    167         255   828     0   \n",
       "28       5       1074     282    164         263   843     0   \n",
       "29       6       1074     286    163         274   850     0   \n",
       "...    ...        ...     ...    ...         ...   ...   ...   \n",
       "21082   16       3374    2240  13205        6755  2201   NaN   \n",
       "21083   17       2987    2239  14676        6561  2453   NaN   \n",
       "21084   18       2928    2239  16505        6758  2622   NaN   \n",
       "21085   19       2925    2240  16105        7221  2572   NaN   \n",
       "21086   20       2917    2240  15448        7423  2542   NaN   \n",
       "21087   21       3155    2240  14137        7683  2404   NaN   \n",
       "21088   22       3055    2242  13259        7265  2061   NaN   \n",
       "21089   23       2951    2243  11561        7007  1868   NaN   \n",
       "21090   24       3079    2242  10166        5904  1879   NaN   \n",
       "21091    1        916     351    195         270  1561     0   \n",
       "21092    2        915     355    200         233  1662     0   \n",
       "21093    3        915     360    197         228  1770     0   \n",
       "21094    4        917     350    198         224  1794     0   \n",
       "21095    5        918     340    201         231  1526     0   \n",
       "21096    6        918     340    203         279  1034     0   \n",
       "21097    7        918     338    202         283   896     6   \n",
       "21098    8        917     337    198         287   807   124   \n",
       "21099    9        914     328    194         290   838   282   \n",
       "21100   12       3734    2244  13444        7743  1916   NaN   \n",
       "21101   13       3801    2242  12950        7943  1877   NaN   \n",
       "21102   14       3903    2241  12785        7606  1878   NaN   \n",
       "21103   15       3566    2240  13951        6210  1926   NaN   \n",
       "21104   16       3238    2237  13618        6741  1951   NaN   \n",
       "21105   17       2962    2236  14851        6611  2034   NaN   \n",
       "21106   18       2690    2237  16175        7281  2262   NaN   \n",
       "21107   19       2586    2238  16316        6807  2412   NaN   \n",
       "21108   20       2642    2239  15716        6664  2286   NaN   \n",
       "21109   21       2896    2240  13684        7498  2302   NaN   \n",
       "21110   22       2862    2241  12663        7195  2296   NaN   \n",
       "21111   23       2991    2242  11170        6655  2329   NaN   \n",
       "\n",
       "                     Date  \n",
       "0     2010-04-20 00:00:00  \n",
       "1     2010-04-20 01:00:00  \n",
       "2     2010-04-20 02:00:00  \n",
       "3     2010-04-20 03:00:00  \n",
       "4     2010-04-20 04:00:00  \n",
       "5     2010-04-20 05:00:00  \n",
       "6     2010-04-20 06:00:00  \n",
       "7     2010-04-20 07:00:00  \n",
       "8     2010-04-20 08:00:00  \n",
       "9     2010-04-20 09:00:00  \n",
       "10    2010-04-20 10:00:00  \n",
       "11    2010-04-20 11:00:00  \n",
       "12    2010-04-20 12:00:00  \n",
       "13    2010-04-20 13:00:00  \n",
       "14    2010-04-20 14:00:00  \n",
       "15    2010-04-20 15:00:00  \n",
       "16    2010-04-20 16:00:00  \n",
       "17    2010-04-20 17:00:00  \n",
       "18    2010-04-20 18:00:00  \n",
       "19    2010-04-20 19:00:00  \n",
       "20    2010-04-20 20:00:00  \n",
       "21    2010-04-20 21:00:00  \n",
       "22    2010-04-20 22:00:00  \n",
       "23    2010-04-20 23:00:00  \n",
       "24    2010-04-21 00:00:00  \n",
       "25    2010-04-21 01:00:00  \n",
       "26    2010-04-21 02:00:00  \n",
       "27    2010-04-21 03:00:00  \n",
       "28    2010-04-21 04:00:00  \n",
       "29    2010-04-21 05:00:00  \n",
       "...                   ...  \n",
       "21082 2012-09-14 10:00:00  \n",
       "21083 2012-09-14 11:00:00  \n",
       "21084 2012-09-14 12:00:00  \n",
       "21085 2012-09-14 13:00:00  \n",
       "21086 2012-09-14 14:00:00  \n",
       "21087 2012-09-14 15:00:00  \n",
       "21088 2012-09-14 16:00:00  \n",
       "21089 2012-09-14 17:00:00  \n",
       "21090 2012-09-14 18:00:00  \n",
       "21091 2012-09-14 19:00:00  \n",
       "21092 2012-09-14 20:00:00  \n",
       "21093 2012-09-14 21:00:00  \n",
       "21094 2012-09-14 22:00:00  \n",
       "21095 2012-09-14 23:00:00  \n",
       "21096 2012-09-15 00:00:00  \n",
       "21097 2012-09-15 01:00:00  \n",
       "21098 2012-09-15 02:00:00  \n",
       "21099 2012-09-15 03:00:00  \n",
       "21100 2012-09-15 04:00:00  \n",
       "21101 2012-09-15 05:00:00  \n",
       "21102 2012-09-15 06:00:00  \n",
       "21103 2012-09-15 07:00:00  \n",
       "21104 2012-09-15 08:00:00  \n",
       "21105 2012-09-15 09:00:00  \n",
       "21106 2012-09-15 10:00:00  \n",
       "21107 2012-09-15 11:00:00  \n",
       "21108 2012-09-15 12:00:00  \n",
       "21109 2012-09-15 13:00:00  \n",
       "21110 2012-09-15 14:00:00  \n",
       "21111 2012-09-15 15:00:00  \n",
       "\n",
       "[21112 rows x 8 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#print for verification\n",
    "\n",
    "renewables_data_cleaned"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'numpy.int64'>\n",
      "<class 'numpy.int64'>\n",
      "<class 'numpy.int64'>\n",
      "<class 'numpy.int64'>\n",
      "<class 'numpy.int64'>\n",
      "<class 'numpy.int64'>\n"
     ]
    }
   ],
   "source": [
    "#Checking results\n",
    "\n",
    "print(type(renewables_data_cleaned.iloc[0]['Geothermal']))\n",
    "print(type(renewables_data_cleaned.iloc[0]['Biomass']))\n",
    "print(type(renewables_data_cleaned.iloc[0]['Biogas']))\n",
    "print(type(renewables_data_cleaned.iloc[0]['Small Hydro']))\n",
    "print(type(renewables_data_cleaned.iloc[0]['Wind']))\n",
    "print(type(renewables_data_cleaned.iloc[0]['Solar']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#Export data to csv for usage in model \n",
    "\n",
    "renewables_data_cleaned.to_csv('renewables_data.cleaned.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}