Integration.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from Module import *"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Reason for Absence</th>\n",
       "      <th>Date</th>\n",
       "      <th>Transportation Expense</th>\n",
       "      <th>Distance to Work</th>\n",
       "      <th>Age</th>\n",
       "      <th>Daily Work Load Average</th>\n",
       "      <th>Body Mass Index</th>\n",
       "      <th>Education</th>\n",
       "      <th>Children</th>\n",
       "      <th>Pets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22</td>\n",
       "      <td>27</td>\n",
       "      <td>01/06/2018</td>\n",
       "      <td>179</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>237.656</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>04/06/2018</td>\n",
       "      <td>361</td>\n",
       "      <td>52</td>\n",
       "      <td>28</td>\n",
       "      <td>237.656</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>06/06/2018</td>\n",
       "      <td>155</td>\n",
       "      <td>12</td>\n",
       "      <td>34</td>\n",
       "      <td>237.656</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17</td>\n",
       "      <td>25</td>\n",
       "      <td>08/06/2018</td>\n",
       "      <td>179</td>\n",
       "      <td>22</td>\n",
       "      <td>40</td>\n",
       "      <td>237.656</td>\n",
       "      <td>22</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>08/06/2018</td>\n",
       "      <td>155</td>\n",
       "      <td>12</td>\n",
       "      <td>34</td>\n",
       "      <td>237.656</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>28</td>\n",
       "      <td>11</td>\n",
       "      <td>11/06/2018</td>\n",
       "      <td>225</td>\n",
       "      <td>26</td>\n",
       "      <td>28</td>\n",
       "      <td>237.656</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>16</td>\n",
       "      <td>7</td>\n",
       "      <td>13/06/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>15</td>\n",
       "      <td>46</td>\n",
       "      <td>275.089</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22</td>\n",
       "      <td>27</td>\n",
       "      <td>13/06/2018</td>\n",
       "      <td>179</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>275.089</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>34</td>\n",
       "      <td>26</td>\n",
       "      <td>15/06/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>275.089</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>34</td>\n",
       "      <td>10</td>\n",
       "      <td>20/06/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>275.089</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>23</td>\n",
       "      <td>22</td>\n",
       "      <td>21/06/2018</td>\n",
       "      <td>378</td>\n",
       "      <td>49</td>\n",
       "      <td>36</td>\n",
       "      <td>275.089</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>36</td>\n",
       "      <td>19</td>\n",
       "      <td>21/06/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>13</td>\n",
       "      <td>50</td>\n",
       "      <td>275.089</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>19</td>\n",
       "      <td>22/06/2018</td>\n",
       "      <td>233</td>\n",
       "      <td>51</td>\n",
       "      <td>31</td>\n",
       "      <td>275.089</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>22</td>\n",
       "      <td>27</td>\n",
       "      <td>22/06/2018</td>\n",
       "      <td>179</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>275.089</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>25/06/2018</td>\n",
       "      <td>235</td>\n",
       "      <td>29</td>\n",
       "      <td>48</td>\n",
       "      <td>275.089</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>28/06/2018</td>\n",
       "      <td>268</td>\n",
       "      <td>11</td>\n",
       "      <td>33</td>\n",
       "      <td>275.089</td>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>36</td>\n",
       "      <td>19</td>\n",
       "      <td>28/06/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>13</td>\n",
       "      <td>50</td>\n",
       "      <td>275.089</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>22</td>\n",
       "      <td>13</td>\n",
       "      <td>28/06/2018</td>\n",
       "      <td>179</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>275.089</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>15</td>\n",
       "      <td>28</td>\n",
       "      <td>28/06/2018</td>\n",
       "      <td>291</td>\n",
       "      <td>31</td>\n",
       "      <td>40</td>\n",
       "      <td>275.089</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>22</td>\n",
       "      <td>13</td>\n",
       "      <td>02/07/2018</td>\n",
       "      <td>179</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>275.089</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>34</td>\n",
       "      <td>25</td>\n",
       "      <td>02/07/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>275.089</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>12</td>\n",
       "      <td>22</td>\n",
       "      <td>05/07/2018</td>\n",
       "      <td>233</td>\n",
       "      <td>51</td>\n",
       "      <td>31</td>\n",
       "      <td>275.089</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>34</td>\n",
       "      <td>8</td>\n",
       "      <td>06/07/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>275.089</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>34</td>\n",
       "      <td>10</td>\n",
       "      <td>11/07/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>275.089</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>12</td>\n",
       "      <td>22</td>\n",
       "      <td>11/07/2018</td>\n",
       "      <td>233</td>\n",
       "      <td>51</td>\n",
       "      <td>31</td>\n",
       "      <td>275.089</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>5</td>\n",
       "      <td>26</td>\n",
       "      <td>11/07/2018</td>\n",
       "      <td>235</td>\n",
       "      <td>20</td>\n",
       "      <td>43</td>\n",
       "      <td>264.604</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>12</td>\n",
       "      <td>19</td>\n",
       "      <td>13/07/2018</td>\n",
       "      <td>233</td>\n",
       "      <td>51</td>\n",
       "      <td>31</td>\n",
       "      <td>264.604</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>16/07/2018</td>\n",
       "      <td>228</td>\n",
       "      <td>14</td>\n",
       "      <td>58</td>\n",
       "      <td>264.604</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>34</td>\n",
       "      <td>28</td>\n",
       "      <td>16/07/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>264.604</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>17/07/2018</td>\n",
       "      <td>228</td>\n",
       "      <td>14</td>\n",
       "      <td>58</td>\n",
       "      <td>264.604</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>6</td>\n",
       "      <td>22</td>\n",
       "      <td>17/07/2018</td>\n",
       "      <td>189</td>\n",
       "      <td>29</td>\n",
       "      <td>33</td>\n",
       "      <td>264.604</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>34</td>\n",
       "      <td>23</td>\n",
       "      <td>18/07/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>37</td>\n",
       "      <td>264.604</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>18/07/2018</td>\n",
       "      <td>361</td>\n",
       "      <td>52</td>\n",
       "      <td>28</td>\n",
       "      <td>264.604</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>28</td>\n",
       "      <td>22</td>\n",
       "      <td>18/07/2018</td>\n",
       "      <td>225</td>\n",
       "      <td>26</td>\n",
       "      <td>28</td>\n",
       "      <td>264.604</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>23/07/2018</td>\n",
       "      <td>369</td>\n",
       "      <td>17</td>\n",
       "      <td>31</td>\n",
       "      <td>264.604</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>24/07/2018</td>\n",
       "      <td>289</td>\n",
       "      <td>36</td>\n",
       "      <td>33</td>\n",
       "      <td>264.604</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>24/07/2018</td>\n",
       "      <td>235</td>\n",
       "      <td>11</td>\n",
       "      <td>37</td>\n",
       "      <td>264.604</td>\n",
       "      <td>29</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>24/07/2018</td>\n",
       "      <td>118</td>\n",
       "      <td>14</td>\n",
       "      <td>40</td>\n",
       "      <td>271.219</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>25/07/2018</td>\n",
       "      <td>231</td>\n",
       "      <td>35</td>\n",
       "      <td>39</td>\n",
       "      <td>271.219</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>27/07/2018</td>\n",
       "      <td>179</td>\n",
       "      <td>45</td>\n",
       "      <td>53</td>\n",
       "      <td>271.219</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ID  Reason for Absence        Date  Transportation Expense  \\\n",
       "0   22                  27  01/06/2018                     179   \n",
       "1   10                   7  04/06/2018                     361   \n",
       "2   14                  23  06/06/2018                     155   \n",
       "3   17                  25  08/06/2018                     179   \n",
       "4   14                  10  08/06/2018                     155   \n",
       "5   28                  11  11/06/2018                     225   \n",
       "6   16                   7  13/06/2018                     118   \n",
       "7   22                  27  13/06/2018                     179   \n",
       "8   34                  26  15/06/2018                     118   \n",
       "9   34                  10  20/06/2018                     118   \n",
       "10  23                  22  21/06/2018                     378   \n",
       "11  36                  19  21/06/2018                     118   \n",
       "12  12                  19  22/06/2018                     233   \n",
       "13  22                  27  22/06/2018                     179   \n",
       "14   2                   0  25/06/2018                     235   \n",
       "15  21                   0  28/06/2018                     268   \n",
       "16  36                  19  28/06/2018                     118   \n",
       "17  22                  13  28/06/2018                     179   \n",
       "18  15                  28  28/06/2018                     291   \n",
       "19  22                  13  02/07/2018                     179   \n",
       "20  34                  25  02/07/2018                     118   \n",
       "21  12                  22  05/07/2018                     233   \n",
       "22  34                   8  06/07/2018                     118   \n",
       "23  34                  10  11/07/2018                     118   \n",
       "24  12                  22  11/07/2018                     233   \n",
       "25   5                  26  11/07/2018                     235   \n",
       "26  12                  19  13/07/2018                     233   \n",
       "27   9                   6  16/07/2018                     228   \n",
       "28  34                  28  16/07/2018                     118   \n",
       "29   9                   6  17/07/2018                     228   \n",
       "30   6                  22  17/07/2018                     189   \n",
       "31  34                  23  18/07/2018                     118   \n",
       "32  10                  22  18/07/2018                     361   \n",
       "33  28                  22  18/07/2018                     225   \n",
       "34  13                  13  23/07/2018                     369   \n",
       "35  11                  14  24/07/2018                     289   \n",
       "36   1                  11  24/07/2018                     235   \n",
       "37   4                   0  24/07/2018                     118   \n",
       "38   8                   0  25/07/2018                     231   \n",
       "39  35                   0  27/07/2018                     179   \n",
       "\n",
       "    Distance to Work  Age  Daily Work Load Average  Body Mass Index  \\\n",
       "0                 26   30                  237.656               19   \n",
       "1                 52   28                  237.656               27   \n",
       "2                 12   34                  237.656               25   \n",
       "3                 22   40                  237.656               22   \n",
       "4                 12   34                  237.656               25   \n",
       "5                 26   28                  237.656               24   \n",
       "6                 15   46                  275.089               25   \n",
       "7                 26   30                  275.089               19   \n",
       "8                 10   37                  275.089               28   \n",
       "9                 10   37                  275.089               28   \n",
       "10                49   36                  275.089               21   \n",
       "11                13   50                  275.089               31   \n",
       "12                51   31                  275.089               21   \n",
       "13                26   30                  275.089               19   \n",
       "14                29   48                  275.089               33   \n",
       "15                11   33                  275.089               25   \n",
       "16                13   50                  275.089               31   \n",
       "17                26   30                  275.089               19   \n",
       "18                31   40                  275.089               25   \n",
       "19                26   30                  275.089               19   \n",
       "20                10   37                  275.089               28   \n",
       "21                51   31                  275.089               21   \n",
       "22                10   37                  275.089               28   \n",
       "23                10   37                  275.089               28   \n",
       "24                51   31                  275.089               21   \n",
       "25                20   43                  264.604               38   \n",
       "26                51   31                  264.604               21   \n",
       "27                14   58                  264.604               22   \n",
       "28                10   37                  264.604               28   \n",
       "29                14   58                  264.604               22   \n",
       "30                29   33                  264.604               25   \n",
       "31                10   37                  264.604               28   \n",
       "32                52   28                  264.604               27   \n",
       "33                26   28                  264.604               24   \n",
       "34                17   31                  264.604               25   \n",
       "35                36   33                  264.604               30   \n",
       "36                11   37                  264.604               29   \n",
       "37                14   40                  271.219               34   \n",
       "38                35   39                  271.219               35   \n",
       "39                45   53                  271.219               25   \n",
       "\n",
       "    Education  Children  Pets  \n",
       "0           3         0     0  \n",
       "1           1         1     4  \n",
       "2           1         2     0  \n",
       "3           2         2     0  \n",
       "4           1         2     0  \n",
       "5           1         1     2  \n",
       "6           1         2     0  \n",
       "7           3         0     0  \n",
       "8           1         0     0  \n",
       "9           1         0     0  \n",
       "10          1         2     4  \n",
       "11          1         1     0  \n",
       "12          2         1     8  \n",
       "13          3         0     0  \n",
       "14          1         1     5  \n",
       "15          2         0     0  \n",
       "16          1         1     0  \n",
       "17          3         0     0  \n",
       "18          1         1     1  \n",
       "19          3         0     0  \n",
       "20          1         0     0  \n",
       "21          2         1     8  \n",
       "22          1         0     0  \n",
       "23          1         0     0  \n",
       "24          2         1     8  \n",
       "25          1         1     0  \n",
       "26          2         1     8  \n",
       "27          1         2     1  \n",
       "28          1         0     0  \n",
       "29          1         2     1  \n",
       "30          1         2     2  \n",
       "31          1         0     0  \n",
       "32          1         1     4  \n",
       "33          1         1     2  \n",
       "34          1         3     0  \n",
       "35          1         2     1  \n",
       "36          3         1     1  \n",
       "37          1         1     8  \n",
       "38          1         2     2  \n",
       "39          1         1     1  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv(\"Absenteeism_new_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "model = absenteeism_model('model','scaler')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "model.load_and_clean_data(\"Absenteeism_new_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Reason_1</th>\n",
       "      <th>Reason_2</th>\n",
       "      <th>Reason_3</th>\n",
       "      <th>Reason_4</th>\n",
       "      <th>Month Value</th>\n",
       "      <th>Transportation Expense</th>\n",
       "      <th>Age</th>\n",
       "      <th>Body Mass Index</th>\n",
       "      <th>Education</th>\n",
       "      <th>Children</th>\n",
       "      <th>Pets</th>\n",
       "      <th>Probability</th>\n",
       "      <th>Prediction</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>179</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.127203</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>361</td>\n",
       "      <td>28</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0.864029</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>155</td>\n",
       "      <td>34</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.265096</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>179</td>\n",
       "      <td>40</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.202894</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>155</td>\n",
       "      <td>34</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.719413</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>225</td>\n",
       "      <td>28</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.707978</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>118</td>\n",
       "      <td>46</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.570469</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>179</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.127203</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>118</td>\n",
       "      <td>37</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.133909</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>118</td>\n",
       "      <td>37</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.523575</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>378</td>\n",
       "      <td>36</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>0.437458</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>118</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.639695</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>233</td>\n",
       "      <td>31</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0.344741</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>179</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.127203</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>235</td>\n",
       "      <td>48</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.077404</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>268</td>\n",
       "      <td>33</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.162866</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>118</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.639695</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>179</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.508818</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>291</td>\n",
       "      <td>40</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.380199</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>179</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.520152</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>118</td>\n",
       "      <td>37</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.139260</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>233</td>\n",
       "      <td>31</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0.053484</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>118</td>\n",
       "      <td>37</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.534880</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>118</td>\n",
       "      <td>37</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.534880</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>233</td>\n",
       "      <td>31</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0.053484</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>235</td>\n",
       "      <td>43</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.514699</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>233</td>\n",
       "      <td>31</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0.355062</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>228</td>\n",
       "      <td>58</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.640744</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>118</td>\n",
       "      <td>37</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.139260</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>228</td>\n",
       "      <td>58</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.640744</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>189</td>\n",
       "      <td>33</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.247281</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>118</td>\n",
       "      <td>37</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.139260</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>361</td>\n",
       "      <td>28</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0.483342</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>225</td>\n",
       "      <td>28</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.263038</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>369</td>\n",
       "      <td>31</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.965609</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>289</td>\n",
       "      <td>33</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.911216</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>235</td>\n",
       "      <td>37</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.757500</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>118</td>\n",
       "      <td>40</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0.019140</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>231</td>\n",
       "      <td>39</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0.255343</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>179</td>\n",
       "      <td>53</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.065876</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Reason_1  Reason_2  Reason_3  Reason_4  Month Value  \\\n",
       "0          0       0.0         0         1            6   \n",
       "1          1       0.0         0         0            6   \n",
       "2          0       0.0         0         1            6   \n",
       "3          0       0.0         0         1            6   \n",
       "4          1       0.0         0         0            6   \n",
       "5          1       0.0         0         0            6   \n",
       "6          1       0.0         0         0            6   \n",
       "7          0       0.0         0         1            6   \n",
       "8          0       0.0         0         1            6   \n",
       "9          1       0.0         0         0            6   \n",
       "10         0       0.0         0         1            6   \n",
       "11         0       0.0         1         0            6   \n",
       "12         0       0.0         1         0            6   \n",
       "13         0       0.0         0         1            6   \n",
       "14         0       0.0         0         0            6   \n",
       "15         0       0.0         0         0            6   \n",
       "16         0       0.0         1         0            6   \n",
       "17         1       0.0         0         0            6   \n",
       "18         0       0.0         0         1            6   \n",
       "19         1       0.0         0         0            7   \n",
       "20         0       0.0         0         1            7   \n",
       "21         0       0.0         0         1            7   \n",
       "22         1       0.0         0         0            7   \n",
       "23         1       0.0         0         0            7   \n",
       "24         0       0.0         0         1            7   \n",
       "25         0       0.0         0         1            7   \n",
       "26         0       0.0         1         0            7   \n",
       "27         1       0.0         0         0            7   \n",
       "28         0       0.0         0         1            7   \n",
       "29         1       0.0         0         0            7   \n",
       "30         0       0.0         0         1            7   \n",
       "31         0       0.0         0         1            7   \n",
       "32         0       0.0         0         1            7   \n",
       "33         0       0.0         0         1            7   \n",
       "34         1       0.0         0         0            7   \n",
       "35         1       0.0         0         0            7   \n",
       "36         1       0.0         0         0            7   \n",
       "37         0       0.0         0         0            7   \n",
       "38         0       0.0         0         0            7   \n",
       "39         0       0.0         0         0            7   \n",
       "\n",
       "    Transportation Expense  Age  Body Mass Index  Education  Children  Pets  \\\n",
       "0                      179   30               19          1         0     0   \n",
       "1                      361   28               27          0         1     4   \n",
       "2                      155   34               25          0         2     0   \n",
       "3                      179   40               22          1         2     0   \n",
       "4                      155   34               25          0         2     0   \n",
       "5                      225   28               24          0         1     2   \n",
       "6                      118   46               25          0         2     0   \n",
       "7                      179   30               19          1         0     0   \n",
       "8                      118   37               28          0         0     0   \n",
       "9                      118   37               28          0         0     0   \n",
       "10                     378   36               21          0         2     4   \n",
       "11                     118   50               31          0         1     0   \n",
       "12                     233   31               21          1         1     8   \n",
       "13                     179   30               19          1         0     0   \n",
       "14                     235   48               33          0         1     5   \n",
       "15                     268   33               25          1         0     0   \n",
       "16                     118   50               31          0         1     0   \n",
       "17                     179   30               19          1         0     0   \n",
       "18                     291   40               25          0         1     1   \n",
       "19                     179   30               19          1         0     0   \n",
       "20                     118   37               28          0         0     0   \n",
       "21                     233   31               21          1         1     8   \n",
       "22                     118   37               28          0         0     0   \n",
       "23                     118   37               28          0         0     0   \n",
       "24                     233   31               21          1         1     8   \n",
       "25                     235   43               38          0         1     0   \n",
       "26                     233   31               21          1         1     8   \n",
       "27                     228   58               22          0         2     1   \n",
       "28                     118   37               28          0         0     0   \n",
       "29                     228   58               22          0         2     1   \n",
       "30                     189   33               25          0         2     2   \n",
       "31                     118   37               28          0         0     0   \n",
       "32                     361   28               27          0         1     4   \n",
       "33                     225   28               24          0         1     2   \n",
       "34                     369   31               25          0         3     0   \n",
       "35                     289   33               30          0         2     1   \n",
       "36                     235   37               29          1         1     1   \n",
       "37                     118   40               34          0         1     8   \n",
       "38                     231   39               35          0         2     2   \n",
       "39                     179   53               25          0         1     1   \n",
       "\n",
       "    Probability  Prediction  \n",
       "0      0.127203           0  \n",
       "1      0.864029           1  \n",
       "2      0.265096           0  \n",
       "3      0.202894           0  \n",
       "4      0.719413           1  \n",
       "5      0.707978           1  \n",
       "6      0.570469           1  \n",
       "7      0.127203           0  \n",
       "8      0.133909           0  \n",
       "9      0.523575           1  \n",
       "10     0.437458           0  \n",
       "11     0.639695           1  \n",
       "12     0.344741           0  \n",
       "13     0.127203           0  \n",
       "14     0.077404           0  \n",
       "15     0.162866           0  \n",
       "16     0.639695           1  \n",
       "17     0.508818           1  \n",
       "18     0.380199           0  \n",
       "19     0.520152           1  \n",
       "20     0.139260           0  \n",
       "21     0.053484           0  \n",
       "22     0.534880           1  \n",
       "23     0.534880           1  \n",
       "24     0.053484           0  \n",
       "25     0.514699           1  \n",
       "26     0.355062           0  \n",
       "27     0.640744           1  \n",
       "28     0.139260           0  \n",
       "29     0.640744           1  \n",
       "30     0.247281           0  \n",
       "31     0.139260           0  \n",
       "32     0.483342           0  \n",
       "33     0.263038           0  \n",
       "34     0.965609           1  \n",
       "35     0.911216           1  \n",
       "36     0.757500           1  \n",
       "37     0.019140           0  \n",
       "38     0.255343           0  \n",
       "39     0.065876           0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.predicted_outputs()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new_obs = model.predicted_outputs()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(40, 13)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_new_obs.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pymysql"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "conn = pymysql.connect(database = 'predicted_outputs', user = 'YOUR_USERNAME_HERE', password = 'YOUR_PASSWORD_HERE')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor = conn.cursor()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cursor.execute('SELECT * FROM predicted_outputs;')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "insert_query = 'INSERT INTO predicted_outputs VALUES '"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'INSERT INTO predicted_outputs VALUES '"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "insert_query"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(df_new_obs.shape[0]):\n",
    "    insert_query += '(' \n",
    "    \n",
    "    for j in range(df_new_obs.shape[1]):\n",
    "        insert_query += str(df_new_obs[df_new_obs.columns.values[j]][i]) + ', '\n",
    "    \n",
    "    insert_query = insert_query[:-2] + '), '  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'INSERT INTO predicted_outputs VALUES (0, 0.0, 0, 1, 6, 179, 30, 19, 1, 0, 0, 0.12720268400193385, 0), (1, 0.0, 0, 0, 6, 361, 28, 27, 0, 1, 4, 0.8640291016335164, 1), (0, 0.0, 0, 1, 6, 155, 34, 25, 0, 2, 0, 0.26509643065626914, 0), (0, 0.0, 0, 1, 6, 179, 40, 22, 1, 2, 0, 0.20289411791455972, 0), (1, 0.0, 0, 0, 6, 155, 34, 25, 0, 2, 0, 0.7194128174545772, 1), (1, 0.0, 0, 0, 6, 225, 28, 24, 0, 1, 2, 0.7079782480120872, 1), (1, 0.0, 0, 0, 6, 118, 46, 25, 0, 2, 0, 0.5704693209939068, 1), (0, 0.0, 0, 1, 6, 179, 30, 19, 1, 0, 0, 0.12720268400193385, 0), (0, 0.0, 0, 1, 6, 118, 37, 28, 0, 0, 0, 0.13390924916629343, 0), (1, 0.0, 0, 0, 6, 118, 37, 28, 0, 0, 0, 0.523574790280447, 1), (0, 0.0, 0, 1, 6, 378, 36, 21, 0, 2, 4, 0.4374578443945194, 0), (0, 0.0, 1, 0, 6, 118, 50, 31, 0, 1, 0, 0.6396948957998115, 1), (0, 0.0, 1, 0, 6, 233, 31, 21, 1, 1, 8, 0.34474091170264454, 0), (0, 0.0, 0, 1, 6, 179, 30, 19, 1, 0, 0, 0.12720268400193385, 0), (0, 0.0, 0, 0, 6, 235, 48, 33, 0, 1, 5, 0.07740378316762019, 0), (0, 0.0, 0, 0, 6, 268, 33, 25, 1, 0, 0, 0.16286564638404982, 0), (0, 0.0, 1, 0, 6, 118, 50, 31, 0, 1, 0, 0.6396948957998115, 1), (1, 0.0, 0, 0, 6, 179, 30, 19, 1, 0, 0, 0.5088178095302305, 1), (0, 0.0, 0, 1, 6, 291, 40, 25, 0, 1, 1, 0.3801987139444249, 0), (1, 0.0, 0, 0, 7, 179, 30, 19, 1, 0, 0, 0.5201518176515881, 1), (0, 0.0, 0, 1, 7, 118, 37, 28, 0, 0, 0, 0.1392598187166621, 0), (0, 0.0, 0, 1, 7, 233, 31, 21, 1, 1, 8, 0.05348355855914449, 0), (1, 0.0, 0, 0, 7, 118, 37, 28, 0, 0, 0, 0.5348795547666452, 1), (1, 0.0, 0, 0, 7, 118, 37, 28, 0, 0, 0, 0.5348795547666452, 1), (0, 0.0, 0, 1, 7, 233, 31, 21, 1, 1, 8, 0.05348355855914449, 0), (0, 0.0, 0, 1, 7, 235, 43, 38, 0, 1, 0, 0.5146989725667077, 1), (0, 0.0, 1, 0, 7, 233, 31, 21, 1, 1, 8, 0.35506206222709974, 0), (1, 0.0, 0, 0, 7, 228, 58, 22, 0, 2, 1, 0.64074438219099, 1), (0, 0.0, 0, 1, 7, 118, 37, 28, 0, 0, 0, 0.1392598187166621, 0), (1, 0.0, 0, 0, 7, 228, 58, 22, 0, 2, 1, 0.64074438219099, 1), (0, 0.0, 0, 1, 7, 189, 33, 25, 0, 2, 2, 0.2472814790894781, 0), (0, 0.0, 0, 1, 7, 118, 37, 28, 0, 0, 0, 0.1392598187166621, 0), (0, 0.0, 0, 1, 7, 361, 28, 27, 0, 1, 4, 0.48334244943418053, 0), (0, 0.0, 0, 1, 7, 225, 28, 24, 0, 1, 2, 0.2630384767756279, 0), (1, 0.0, 0, 0, 7, 369, 31, 25, 0, 3, 0, 0.9656086228487334, 1), (1, 0.0, 0, 0, 7, 289, 33, 30, 0, 2, 1, 0.911215675703966, 1), (1, 0.0, 0, 0, 7, 235, 37, 29, 1, 1, 1, 0.7574999600199465, 1), (0, 0.0, 0, 0, 7, 118, 40, 34, 0, 1, 8, 0.01914049624339444, 0), (0, 0.0, 0, 0, 7, 231, 39, 35, 0, 2, 2, 0.2553430429348338, 0), (0, 0.0, 0, 0, 7, 179, 53, 25, 0, 1, 1, 0.06587617923046041, 0), '"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "insert_query"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "insert_query = insert_query[:-2] + ';'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'INSERT INTO predicted_outputs VALUES (0, 0.0, 0, 1, 6, 179, 30, 19, 1, 0, 0, 0.12720268400193385, 0), (1, 0.0, 0, 0, 6, 361, 28, 27, 0, 1, 4, 0.8640291016335164, 1), (0, 0.0, 0, 1, 6, 155, 34, 25, 0, 2, 0, 0.26509643065626914, 0), (0, 0.0, 0, 1, 6, 179, 40, 22, 1, 2, 0, 0.20289411791455972, 0), (1, 0.0, 0, 0, 6, 155, 34, 25, 0, 2, 0, 0.7194128174545772, 1), (1, 0.0, 0, 0, 6, 225, 28, 24, 0, 1, 2, 0.7079782480120872, 1), (1, 0.0, 0, 0, 6, 118, 46, 25, 0, 2, 0, 0.5704693209939068, 1), (0, 0.0, 0, 1, 6, 179, 30, 19, 1, 0, 0, 0.12720268400193385, 0), (0, 0.0, 0, 1, 6, 118, 37, 28, 0, 0, 0, 0.13390924916629343, 0), (1, 0.0, 0, 0, 6, 118, 37, 28, 0, 0, 0, 0.523574790280447, 1), (0, 0.0, 0, 1, 6, 378, 36, 21, 0, 2, 4, 0.4374578443945194, 0), (0, 0.0, 1, 0, 6, 118, 50, 31, 0, 1, 0, 0.6396948957998115, 1), (0, 0.0, 1, 0, 6, 233, 31, 21, 1, 1, 8, 0.34474091170264454, 0), (0, 0.0, 0, 1, 6, 179, 30, 19, 1, 0, 0, 0.12720268400193385, 0), (0, 0.0, 0, 0, 6, 235, 48, 33, 0, 1, 5, 0.07740378316762019, 0), (0, 0.0, 0, 0, 6, 268, 33, 25, 1, 0, 0, 0.16286564638404982, 0), (0, 0.0, 1, 0, 6, 118, 50, 31, 0, 1, 0, 0.6396948957998115, 1), (1, 0.0, 0, 0, 6, 179, 30, 19, 1, 0, 0, 0.5088178095302305, 1), (0, 0.0, 0, 1, 6, 291, 40, 25, 0, 1, 1, 0.3801987139444249, 0), (1, 0.0, 0, 0, 7, 179, 30, 19, 1, 0, 0, 0.5201518176515881, 1), (0, 0.0, 0, 1, 7, 118, 37, 28, 0, 0, 0, 0.1392598187166621, 0), (0, 0.0, 0, 1, 7, 233, 31, 21, 1, 1, 8, 0.05348355855914449, 0), (1, 0.0, 0, 0, 7, 118, 37, 28, 0, 0, 0, 0.5348795547666452, 1), (1, 0.0, 0, 0, 7, 118, 37, 28, 0, 0, 0, 0.5348795547666452, 1), (0, 0.0, 0, 1, 7, 233, 31, 21, 1, 1, 8, 0.05348355855914449, 0), (0, 0.0, 0, 1, 7, 235, 43, 38, 0, 1, 0, 0.5146989725667077, 1), (0, 0.0, 1, 0, 7, 233, 31, 21, 1, 1, 8, 0.35506206222709974, 0), (1, 0.0, 0, 0, 7, 228, 58, 22, 0, 2, 1, 0.64074438219099, 1), (0, 0.0, 0, 1, 7, 118, 37, 28, 0, 0, 0, 0.1392598187166621, 0), (1, 0.0, 0, 0, 7, 228, 58, 22, 0, 2, 1, 0.64074438219099, 1), (0, 0.0, 0, 1, 7, 189, 33, 25, 0, 2, 2, 0.2472814790894781, 0), (0, 0.0, 0, 1, 7, 118, 37, 28, 0, 0, 0, 0.1392598187166621, 0), (0, 0.0, 0, 1, 7, 361, 28, 27, 0, 1, 4, 0.48334244943418053, 0), (0, 0.0, 0, 1, 7, 225, 28, 24, 0, 1, 2, 0.2630384767756279, 0), (1, 0.0, 0, 0, 7, 369, 31, 25, 0, 3, 0, 0.9656086228487334, 1), (1, 0.0, 0, 0, 7, 289, 33, 30, 0, 2, 1, 0.911215675703966, 1), (1, 0.0, 0, 0, 7, 235, 37, 29, 1, 1, 1, 0.7574999600199465, 1), (0, 0.0, 0, 0, 7, 118, 40, 34, 0, 1, 8, 0.01914049624339444, 0), (0, 0.0, 0, 0, 7, 231, 39, 35, 0, 2, 2, 0.2553430429348338, 0), (0, 0.0, 0, 0, 7, 179, 53, 25, 0, 1, 1, 0.06587617923046041, 0);'"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "insert_query"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "40"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cursor.execute(insert_query)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "conn.commit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}