mxnet linear regression 1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "file = 'C:/Users/anna/Desktop/maria/Upwork/ML courses/Sample_Data.xlsx'\n",
    "data = pd.read_excel(file, encoding=\"utf8\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ID number       int64\n",
      "Outcome        object\n",
      "Time            int64\n",
      "Feature 1     float64\n",
      "Feature 2     float64\n",
      "Feature 3     float64\n",
      "Feature 4     float64\n",
      "Feature 5     float64\n",
      "Feature 6     float64\n",
      "Feature 7     float64\n",
      "Feature 8     float64\n",
      "Feature 9     float64\n",
      "Feature 10    float64\n",
      "Feature 11    float64\n",
      "Feature 12    float64\n",
      "Feature 13    float64\n",
      "Feature 14    float64\n",
      "Feature 15    float64\n",
      "Feature 16    float64\n",
      "Feature 17    float64\n",
      "Feature 18    float64\n",
      "Feature 19    float64\n",
      "Feature 20    float64\n",
      "Feature 21    float64\n",
      "Feature 22    float64\n",
      "Feature 23    float64\n",
      "Feature 24    float64\n",
      "Feature 25    float64\n",
      "Feature 26    float64\n",
      "Feature 27    float64\n",
      "Feature 28    float64\n",
      "Feature 29    float64\n",
      "Feature 30    float64\n",
      "Feature 31    float64\n",
      "Feature 32     object\n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(data.dtypes)"
   ]
  },
  {
   "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>ID number</th>\n",
       "      <th>Outcome</th>\n",
       "      <th>Time</th>\n",
       "      <th>Feature 1</th>\n",
       "      <th>Feature 2</th>\n",
       "      <th>Feature 3</th>\n",
       "      <th>Feature 4</th>\n",
       "      <th>Feature 5</th>\n",
       "      <th>Feature 6</th>\n",
       "      <th>Feature 7</th>\n",
       "      <th>...</th>\n",
       "      <th>Feature 23</th>\n",
       "      <th>Feature 24</th>\n",
       "      <th>Feature 25</th>\n",
       "      <th>Feature 26</th>\n",
       "      <th>Feature 27</th>\n",
       "      <th>Feature 28</th>\n",
       "      <th>Feature 29</th>\n",
       "      <th>Feature 30</th>\n",
       "      <th>Feature 31</th>\n",
       "      <th>Feature 32</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>119513</td>\n",
       "      <td>N</td>\n",
       "      <td>31</td>\n",
       "      <td>18.02</td>\n",
       "      <td>27.60</td>\n",
       "      <td>117.50</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>0.09489</td>\n",
       "      <td>0.10360</td>\n",
       "      <td>0.10860</td>\n",
       "      <td>...</td>\n",
       "      <td>139.70</td>\n",
       "      <td>1436.0</td>\n",
       "      <td>0.11950</td>\n",
       "      <td>0.19260</td>\n",
       "      <td>0.31400</td>\n",
       "      <td>0.11700</td>\n",
       "      <td>0.2677</td>\n",
       "      <td>0.08113</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8423</td>\n",
       "      <td>N</td>\n",
       "      <td>61</td>\n",
       "      <td>17.99</td>\n",
       "      <td>10.38</td>\n",
       "      <td>122.80</td>\n",
       "      <td>1001.0</td>\n",
       "      <td>0.11840</td>\n",
       "      <td>0.27760</td>\n",
       "      <td>0.30010</td>\n",
       "      <td>...</td>\n",
       "      <td>184.60</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>0.16220</td>\n",
       "      <td>0.66560</td>\n",
       "      <td>0.71190</td>\n",
       "      <td>0.26540</td>\n",
       "      <td>0.4601</td>\n",
       "      <td>0.11890</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>842517</td>\n",
       "      <td>N</td>\n",
       "      <td>116</td>\n",
       "      <td>21.37</td>\n",
       "      <td>17.44</td>\n",
       "      <td>137.50</td>\n",
       "      <td>1373.0</td>\n",
       "      <td>0.08836</td>\n",
       "      <td>0.11890</td>\n",
       "      <td>0.12550</td>\n",
       "      <td>...</td>\n",
       "      <td>159.10</td>\n",
       "      <td>1949.0</td>\n",
       "      <td>0.11880</td>\n",
       "      <td>0.34490</td>\n",
       "      <td>0.34140</td>\n",
       "      <td>0.20320</td>\n",
       "      <td>0.4334</td>\n",
       "      <td>0.09067</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>843483</td>\n",
       "      <td>N</td>\n",
       "      <td>123</td>\n",
       "      <td>11.42</td>\n",
       "      <td>20.38</td>\n",
       "      <td>77.58</td>\n",
       "      <td>386.1</td>\n",
       "      <td>0.14250</td>\n",
       "      <td>0.28390</td>\n",
       "      <td>0.24140</td>\n",
       "      <td>...</td>\n",
       "      <td>98.87</td>\n",
       "      <td>567.7</td>\n",
       "      <td>0.20980</td>\n",
       "      <td>0.86630</td>\n",
       "      <td>0.68690</td>\n",
       "      <td>0.25750</td>\n",
       "      <td>0.6638</td>\n",
       "      <td>0.17300</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>843584</td>\n",
       "      <td>R</td>\n",
       "      <td>27</td>\n",
       "      <td>20.29</td>\n",
       "      <td>14.34</td>\n",
       "      <td>135.10</td>\n",
       "      <td>1297.0</td>\n",
       "      <td>0.10030</td>\n",
       "      <td>0.13280</td>\n",
       "      <td>0.19800</td>\n",
       "      <td>...</td>\n",
       "      <td>152.20</td>\n",
       "      <td>1575.0</td>\n",
       "      <td>0.13740</td>\n",
       "      <td>0.20500</td>\n",
       "      <td>0.40000</td>\n",
       "      <td>0.16250</td>\n",
       "      <td>0.2364</td>\n",
       "      <td>0.07678</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>843786</td>\n",
       "      <td>R</td>\n",
       "      <td>77</td>\n",
       "      <td>12.75</td>\n",
       "      <td>15.29</td>\n",
       "      <td>84.60</td>\n",
       "      <td>502.7</td>\n",
       "      <td>0.11890</td>\n",
       "      <td>0.15690</td>\n",
       "      <td>0.16640</td>\n",
       "      <td>...</td>\n",
       "      <td>107.30</td>\n",
       "      <td>733.2</td>\n",
       "      <td>0.17060</td>\n",
       "      <td>0.41960</td>\n",
       "      <td>0.59990</td>\n",
       "      <td>0.17090</td>\n",
       "      <td>0.3485</td>\n",
       "      <td>0.11790</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>844359</td>\n",
       "      <td>N</td>\n",
       "      <td>60</td>\n",
       "      <td>18.98</td>\n",
       "      <td>19.61</td>\n",
       "      <td>124.40</td>\n",
       "      <td>1112.0</td>\n",
       "      <td>0.09087</td>\n",
       "      <td>0.12370</td>\n",
       "      <td>0.12130</td>\n",
       "      <td>...</td>\n",
       "      <td>152.60</td>\n",
       "      <td>1593.0</td>\n",
       "      <td>0.11440</td>\n",
       "      <td>0.33710</td>\n",
       "      <td>0.29900</td>\n",
       "      <td>0.19220</td>\n",
       "      <td>0.2726</td>\n",
       "      <td>0.09581</td>\n",
       "      <td>1.5</td>\n",
       "      <td>?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>844582</td>\n",
       "      <td>R</td>\n",
       "      <td>77</td>\n",
       "      <td>13.71</td>\n",
       "      <td>20.83</td>\n",
       "      <td>90.20</td>\n",
       "      <td>577.9</td>\n",
       "      <td>0.11890</td>\n",
       "      <td>0.16450</td>\n",
       "      <td>0.09366</td>\n",
       "      <td>...</td>\n",
       "      <td>110.60</td>\n",
       "      <td>897.0</td>\n",
       "      <td>0.16540</td>\n",
       "      <td>0.36820</td>\n",
       "      <td>0.26780</td>\n",
       "      <td>0.15560</td>\n",
       "      <td>0.3196</td>\n",
       "      <td>0.11510</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>844981</td>\n",
       "      <td>N</td>\n",
       "      <td>119</td>\n",
       "      <td>13.00</td>\n",
       "      <td>21.82</td>\n",
       "      <td>87.50</td>\n",
       "      <td>519.8</td>\n",
       "      <td>0.12730</td>\n",
       "      <td>0.19320</td>\n",
       "      <td>0.18590</td>\n",
       "      <td>...</td>\n",
       "      <td>106.20</td>\n",
       "      <td>739.3</td>\n",
       "      <td>0.17030</td>\n",
       "      <td>0.54010</td>\n",
       "      <td>0.53900</td>\n",
       "      <td>0.20600</td>\n",
       "      <td>0.4378</td>\n",
       "      <td>0.10720</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>845010</td>\n",
       "      <td>N</td>\n",
       "      <td>76</td>\n",
       "      <td>12.46</td>\n",
       "      <td>24.04</td>\n",
       "      <td>83.97</td>\n",
       "      <td>475.9</td>\n",
       "      <td>0.11860</td>\n",
       "      <td>0.23960</td>\n",
       "      <td>0.22730</td>\n",
       "      <td>...</td>\n",
       "      <td>97.65</td>\n",
       "      <td>711.4</td>\n",
       "      <td>0.18530</td>\n",
       "      <td>1.05800</td>\n",
       "      <td>1.10500</td>\n",
       "      <td>0.22100</td>\n",
       "      <td>0.4366</td>\n",
       "      <td>0.20750</td>\n",
       "      <td>6.0</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>845636</td>\n",
       "      <td>N</td>\n",
       "      <td>123</td>\n",
       "      <td>16.02</td>\n",
       "      <td>23.24</td>\n",
       "      <td>102.70</td>\n",
       "      <td>797.8</td>\n",
       "      <td>0.08206</td>\n",
       "      <td>0.06669</td>\n",
       "      <td>0.03299</td>\n",
       "      <td>...</td>\n",
       "      <td>123.80</td>\n",
       "      <td>1150.0</td>\n",
       "      <td>0.11810</td>\n",
       "      <td>0.15510</td>\n",
       "      <td>0.14590</td>\n",
       "      <td>0.09975</td>\n",
       "      <td>0.2948</td>\n",
       "      <td>0.08452</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>846100</td>\n",
       "      <td>N</td>\n",
       "      <td>125</td>\n",
       "      <td>15.78</td>\n",
       "      <td>17.89</td>\n",
       "      <td>103.60</td>\n",
       "      <td>781.0</td>\n",
       "      <td>0.09710</td>\n",
       "      <td>0.12920</td>\n",
       "      <td>0.09954</td>\n",
       "      <td>...</td>\n",
       "      <td>136.50</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>0.13960</td>\n",
       "      <td>0.56090</td>\n",
       "      <td>0.39650</td>\n",
       "      <td>0.18100</td>\n",
       "      <td>0.3792</td>\n",
       "      <td>0.10480</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>846381</td>\n",
       "      <td>N</td>\n",
       "      <td>117</td>\n",
       "      <td>15.85</td>\n",
       "      <td>23.95</td>\n",
       "      <td>103.70</td>\n",
       "      <td>782.7</td>\n",
       "      <td>0.08401</td>\n",
       "      <td>0.10020</td>\n",
       "      <td>0.09938</td>\n",
       "      <td>...</td>\n",
       "      <td>112.00</td>\n",
       "      <td>876.5</td>\n",
       "      <td>0.11310</td>\n",
       "      <td>0.19240</td>\n",
       "      <td>0.23220</td>\n",
       "      <td>0.11190</td>\n",
       "      <td>0.2809</td>\n",
       "      <td>0.06287</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>847990</td>\n",
       "      <td>R</td>\n",
       "      <td>36</td>\n",
       "      <td>14.54</td>\n",
       "      <td>27.54</td>\n",
       "      <td>96.73</td>\n",
       "      <td>658.8</td>\n",
       "      <td>0.11390</td>\n",
       "      <td>0.15950</td>\n",
       "      <td>0.16390</td>\n",
       "      <td>...</td>\n",
       "      <td>124.10</td>\n",
       "      <td>943.2</td>\n",
       "      <td>0.16780</td>\n",
       "      <td>0.65770</td>\n",
       "      <td>0.70260</td>\n",
       "      <td>0.17120</td>\n",
       "      <td>0.4218</td>\n",
       "      <td>0.13410</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>848406</td>\n",
       "      <td>N</td>\n",
       "      <td>123</td>\n",
       "      <td>14.68</td>\n",
       "      <td>20.13</td>\n",
       "      <td>94.74</td>\n",
       "      <td>684.5</td>\n",
       "      <td>0.09867</td>\n",
       "      <td>0.07200</td>\n",
       "      <td>0.07395</td>\n",
       "      <td>...</td>\n",
       "      <td>123.40</td>\n",
       "      <td>1138.0</td>\n",
       "      <td>0.14640</td>\n",
       "      <td>0.18710</td>\n",
       "      <td>0.29140</td>\n",
       "      <td>0.16090</td>\n",
       "      <td>0.3029</td>\n",
       "      <td>0.08216</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>848620</td>\n",
       "      <td>R</td>\n",
       "      <td>10</td>\n",
       "      <td>16.13</td>\n",
       "      <td>20.68</td>\n",
       "      <td>108.10</td>\n",
       "      <td>798.8</td>\n",
       "      <td>0.11700</td>\n",
       "      <td>0.20220</td>\n",
       "      <td>0.17220</td>\n",
       "      <td>...</td>\n",
       "      <td>136.80</td>\n",
       "      <td>1315.0</td>\n",
       "      <td>0.17890</td>\n",
       "      <td>0.42330</td>\n",
       "      <td>0.47840</td>\n",
       "      <td>0.20730</td>\n",
       "      <td>0.3706</td>\n",
       "      <td>0.11420</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>8511133</td>\n",
       "      <td>N</td>\n",
       "      <td>20</td>\n",
       "      <td>15.34</td>\n",
       "      <td>14.26</td>\n",
       "      <td>102.50</td>\n",
       "      <td>704.4</td>\n",
       "      <td>0.10730</td>\n",
       "      <td>0.21350</td>\n",
       "      <td>0.20770</td>\n",
       "      <td>...</td>\n",
       "      <td>125.10</td>\n",
       "      <td>980.9</td>\n",
       "      <td>0.13900</td>\n",
       "      <td>0.59540</td>\n",
       "      <td>0.63050</td>\n",
       "      <td>0.23930</td>\n",
       "      <td>0.4667</td>\n",
       "      <td>0.09946</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>851509</td>\n",
       "      <td>R</td>\n",
       "      <td>10</td>\n",
       "      <td>21.16</td>\n",
       "      <td>23.04</td>\n",
       "      <td>137.20</td>\n",
       "      <td>1404.0</td>\n",
       "      <td>0.09428</td>\n",
       "      <td>0.10220</td>\n",
       "      <td>0.10970</td>\n",
       "      <td>...</td>\n",
       "      <td>188.00</td>\n",
       "      <td>2615.0</td>\n",
       "      <td>0.14010</td>\n",
       "      <td>0.26000</td>\n",
       "      <td>0.31550</td>\n",
       "      <td>0.20090</td>\n",
       "      <td>0.2822</td>\n",
       "      <td>0.07526</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>852552</td>\n",
       "      <td>N</td>\n",
       "      <td>96</td>\n",
       "      <td>16.65</td>\n",
       "      <td>21.38</td>\n",
       "      <td>110.00</td>\n",
       "      <td>904.6</td>\n",
       "      <td>0.11210</td>\n",
       "      <td>0.14570</td>\n",
       "      <td>0.15250</td>\n",
       "      <td>...</td>\n",
       "      <td>177.00</td>\n",
       "      <td>2215.0</td>\n",
       "      <td>0.18050</td>\n",
       "      <td>0.35780</td>\n",
       "      <td>0.46950</td>\n",
       "      <td>0.20950</td>\n",
       "      <td>0.3613</td>\n",
       "      <td>0.09564</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>852631</td>\n",
       "      <td>N</td>\n",
       "      <td>116</td>\n",
       "      <td>17.14</td>\n",
       "      <td>16.40</td>\n",
       "      <td>116.00</td>\n",
       "      <td>912.7</td>\n",
       "      <td>0.11860</td>\n",
       "      <td>0.22760</td>\n",
       "      <td>0.22290</td>\n",
       "      <td>...</td>\n",
       "      <td>152.40</td>\n",
       "      <td>1461.0</td>\n",
       "      <td>0.15450</td>\n",
       "      <td>0.39490</td>\n",
       "      <td>0.38530</td>\n",
       "      <td>0.25500</td>\n",
       "      <td>0.4066</td>\n",
       "      <td>0.10590</td>\n",
       "      <td>4.4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>852763</td>\n",
       "      <td>N</td>\n",
       "      <td>103</td>\n",
       "      <td>14.58</td>\n",
       "      <td>21.53</td>\n",
       "      <td>97.41</td>\n",
       "      <td>644.8</td>\n",
       "      <td>0.10540</td>\n",
       "      <td>0.18680</td>\n",
       "      <td>0.14250</td>\n",
       "      <td>...</td>\n",
       "      <td>122.40</td>\n",
       "      <td>896.9</td>\n",
       "      <td>0.15250</td>\n",
       "      <td>0.66430</td>\n",
       "      <td>0.55390</td>\n",
       "      <td>0.27010</td>\n",
       "      <td>0.4264</td>\n",
       "      <td>0.12750</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>852781</td>\n",
       "      <td>N</td>\n",
       "      <td>16</td>\n",
       "      <td>18.61</td>\n",
       "      <td>20.25</td>\n",
       "      <td>122.10</td>\n",
       "      <td>1094.0</td>\n",
       "      <td>0.09440</td>\n",
       "      <td>0.10660</td>\n",
       "      <td>0.14900</td>\n",
       "      <td>...</td>\n",
       "      <td>139.90</td>\n",
       "      <td>1403.0</td>\n",
       "      <td>0.13380</td>\n",
       "      <td>0.21170</td>\n",
       "      <td>0.34460</td>\n",
       "      <td>0.14900</td>\n",
       "      <td>0.2341</td>\n",
       "      <td>0.07421</td>\n",
       "      <td>3.4</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>852973</td>\n",
       "      <td>N</td>\n",
       "      <td>52</td>\n",
       "      <td>15.30</td>\n",
       "      <td>25.27</td>\n",
       "      <td>102.40</td>\n",
       "      <td>732.4</td>\n",
       "      <td>0.10820</td>\n",
       "      <td>0.16970</td>\n",
       "      <td>0.16830</td>\n",
       "      <td>...</td>\n",
       "      <td>149.30</td>\n",
       "      <td>1269.0</td>\n",
       "      <td>0.16410</td>\n",
       "      <td>0.61100</td>\n",
       "      <td>0.63350</td>\n",
       "      <td>0.20240</td>\n",
       "      <td>0.4027</td>\n",
       "      <td>0.09876</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>853201</td>\n",
       "      <td>N</td>\n",
       "      <td>94</td>\n",
       "      <td>17.57</td>\n",
       "      <td>15.05</td>\n",
       "      <td>115.00</td>\n",
       "      <td>955.1</td>\n",
       "      <td>0.09847</td>\n",
       "      <td>0.11570</td>\n",
       "      <td>0.09875</td>\n",
       "      <td>...</td>\n",
       "      <td>134.90</td>\n",
       "      <td>1227.0</td>\n",
       "      <td>0.12550</td>\n",
       "      <td>0.28120</td>\n",
       "      <td>0.24890</td>\n",
       "      <td>0.14560</td>\n",
       "      <td>0.2756</td>\n",
       "      <td>0.07919</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>853612</td>\n",
       "      <td>N</td>\n",
       "      <td>116</td>\n",
       "      <td>11.84</td>\n",
       "      <td>18.70</td>\n",
       "      <td>77.93</td>\n",
       "      <td>440.6</td>\n",
       "      <td>0.11090</td>\n",
       "      <td>0.15160</td>\n",
       "      <td>0.12180</td>\n",
       "      <td>...</td>\n",
       "      <td>119.40</td>\n",
       "      <td>888.7</td>\n",
       "      <td>0.16370</td>\n",
       "      <td>0.57750</td>\n",
       "      <td>0.69560</td>\n",
       "      <td>0.15460</td>\n",
       "      <td>0.4761</td>\n",
       "      <td>0.14020</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>853826</td>\n",
       "      <td>N</td>\n",
       "      <td>87</td>\n",
       "      <td>17.02</td>\n",
       "      <td>23.98</td>\n",
       "      <td>112.80</td>\n",
       "      <td>899.3</td>\n",
       "      <td>0.11970</td>\n",
       "      <td>0.14960</td>\n",
       "      <td>0.24170</td>\n",
       "      <td>...</td>\n",
       "      <td>136.10</td>\n",
       "      <td>1344.0</td>\n",
       "      <td>0.16340</td>\n",
       "      <td>0.35590</td>\n",
       "      <td>0.55880</td>\n",
       "      <td>0.18470</td>\n",
       "      <td>0.3530</td>\n",
       "      <td>0.08482</td>\n",
       "      <td>1.3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>854002</td>\n",
       "      <td>N</td>\n",
       "      <td>53</td>\n",
       "      <td>19.27</td>\n",
       "      <td>26.47</td>\n",
       "      <td>127.90</td>\n",
       "      <td>1162.0</td>\n",
       "      <td>0.09401</td>\n",
       "      <td>0.17190</td>\n",
       "      <td>0.16570</td>\n",
       "      <td>...</td>\n",
       "      <td>161.40</td>\n",
       "      <td>1813.0</td>\n",
       "      <td>0.15090</td>\n",
       "      <td>0.65900</td>\n",
       "      <td>0.60910</td>\n",
       "      <td>0.17850</td>\n",
       "      <td>0.3672</td>\n",
       "      <td>0.11230</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>854039</td>\n",
       "      <td>N</td>\n",
       "      <td>109</td>\n",
       "      <td>16.13</td>\n",
       "      <td>17.88</td>\n",
       "      <td>107.00</td>\n",
       "      <td>807.2</td>\n",
       "      <td>0.10400</td>\n",
       "      <td>0.15590</td>\n",
       "      <td>0.13540</td>\n",
       "      <td>...</td>\n",
       "      <td>132.70</td>\n",
       "      <td>1261.0</td>\n",
       "      <td>0.14460</td>\n",
       "      <td>0.58040</td>\n",
       "      <td>0.52740</td>\n",
       "      <td>0.18640</td>\n",
       "      <td>0.4270</td>\n",
       "      <td>0.12330</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>854253</td>\n",
       "      <td>N</td>\n",
       "      <td>12</td>\n",
       "      <td>16.74</td>\n",
       "      <td>21.59</td>\n",
       "      <td>110.10</td>\n",
       "      <td>869.5</td>\n",
       "      <td>0.09610</td>\n",
       "      <td>0.13360</td>\n",
       "      <td>0.13480</td>\n",
       "      <td>...</td>\n",
       "      <td>133.50</td>\n",
       "      <td>1229.0</td>\n",
       "      <td>0.15630</td>\n",
       "      <td>0.38350</td>\n",
       "      <td>0.54090</td>\n",
       "      <td>0.18130</td>\n",
       "      <td>0.4863</td>\n",
       "      <td>0.08633</td>\n",
       "      <td>1.5</td>\n",
       "      <td>?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>854268</td>\n",
       "      <td>N</td>\n",
       "      <td>31</td>\n",
       "      <td>14.25</td>\n",
       "      <td>21.72</td>\n",
       "      <td>93.63</td>\n",
       "      <td>633.0</td>\n",
       "      <td>0.09823</td>\n",
       "      <td>0.10980</td>\n",
       "      <td>0.13190</td>\n",
       "      <td>...</td>\n",
       "      <td>116.20</td>\n",
       "      <td>799.6</td>\n",
       "      <td>0.14460</td>\n",
       "      <td>0.42380</td>\n",
       "      <td>0.51860</td>\n",
       "      <td>0.14470</td>\n",
       "      <td>0.3591</td>\n",
       "      <td>0.10140</td>\n",
       "      <td>3.0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>925622</td>\n",
       "      <td>N</td>\n",
       "      <td>30</td>\n",
       "      <td>15.22</td>\n",
       "      <td>30.62</td>\n",
       "      <td>103.40</td>\n",
       "      <td>716.9</td>\n",
       "      <td>0.10480</td>\n",
       "      <td>0.20870</td>\n",
       "      <td>0.25500</td>\n",
       "      <td>...</td>\n",
       "      <td>128.70</td>\n",
       "      <td>915.0</td>\n",
       "      <td>0.14170</td>\n",
       "      <td>0.79170</td>\n",
       "      <td>1.17000</td>\n",
       "      <td>0.23560</td>\n",
       "      <td>0.4089</td>\n",
       "      <td>0.14090</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>926125</td>\n",
       "      <td>N</td>\n",
       "      <td>17</td>\n",
       "      <td>20.92</td>\n",
       "      <td>25.09</td>\n",
       "      <td>143.00</td>\n",
       "      <td>1347.0</td>\n",
       "      <td>0.10990</td>\n",
       "      <td>0.22360</td>\n",
       "      <td>0.31740</td>\n",
       "      <td>...</td>\n",
       "      <td>179.10</td>\n",
       "      <td>1819.0</td>\n",
       "      <td>0.14070</td>\n",
       "      <td>0.41860</td>\n",
       "      <td>0.65990</td>\n",
       "      <td>0.25420</td>\n",
       "      <td>0.2929</td>\n",
       "      <td>0.09873</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>926424</td>\n",
       "      <td>N</td>\n",
       "      <td>28</td>\n",
       "      <td>21.56</td>\n",
       "      <td>22.39</td>\n",
       "      <td>142.00</td>\n",
       "      <td>1479.0</td>\n",
       "      <td>0.11100</td>\n",
       "      <td>0.11590</td>\n",
       "      <td>0.24390</td>\n",
       "      <td>...</td>\n",
       "      <td>166.10</td>\n",
       "      <td>2027.0</td>\n",
       "      <td>0.14100</td>\n",
       "      <td>0.21130</td>\n",
       "      <td>0.41070</td>\n",
       "      <td>0.22160</td>\n",
       "      <td>0.2060</td>\n",
       "      <td>0.07115</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>926682</td>\n",
       "      <td>N</td>\n",
       "      <td>20</td>\n",
       "      <td>20.13</td>\n",
       "      <td>28.25</td>\n",
       "      <td>131.20</td>\n",
       "      <td>1261.0</td>\n",
       "      <td>0.09780</td>\n",
       "      <td>0.10340</td>\n",
       "      <td>0.14400</td>\n",
       "      <td>...</td>\n",
       "      <td>155.00</td>\n",
       "      <td>1731.0</td>\n",
       "      <td>0.11660</td>\n",
       "      <td>0.19220</td>\n",
       "      <td>0.32150</td>\n",
       "      <td>0.16280</td>\n",
       "      <td>0.2572</td>\n",
       "      <td>0.06637</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>926954</td>\n",
       "      <td>N</td>\n",
       "      <td>16</td>\n",
       "      <td>16.60</td>\n",
       "      <td>28.08</td>\n",
       "      <td>108.30</td>\n",
       "      <td>858.1</td>\n",
       "      <td>0.08455</td>\n",
       "      <td>0.10230</td>\n",
       "      <td>0.09251</td>\n",
       "      <td>...</td>\n",
       "      <td>126.70</td>\n",
       "      <td>1124.0</td>\n",
       "      <td>0.11390</td>\n",
       "      <td>0.30940</td>\n",
       "      <td>0.34030</td>\n",
       "      <td>0.14180</td>\n",
       "      <td>0.2218</td>\n",
       "      <td>0.07820</td>\n",
       "      <td>3.5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>927992</td>\n",
       "      <td>N</td>\n",
       "      <td>26</td>\n",
       "      <td>13.86</td>\n",
       "      <td>23.83</td>\n",
       "      <td>89.60</td>\n",
       "      <td>595.8</td>\n",
       "      <td>0.10670</td>\n",
       "      <td>0.08318</td>\n",
       "      <td>0.07671</td>\n",
       "      <td>...</td>\n",
       "      <td>101.20</td>\n",
       "      <td>730.6</td>\n",
       "      <td>0.14670</td>\n",
       "      <td>0.12790</td>\n",
       "      <td>0.16770</td>\n",
       "      <td>0.11140</td>\n",
       "      <td>0.2180</td>\n",
       "      <td>0.06057</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>927997</td>\n",
       "      <td>N</td>\n",
       "      <td>27</td>\n",
       "      <td>18.11</td>\n",
       "      <td>26.17</td>\n",
       "      <td>118.70</td>\n",
       "      <td>970.2</td>\n",
       "      <td>0.09867</td>\n",
       "      <td>0.17160</td>\n",
       "      <td>0.21770</td>\n",
       "      <td>...</td>\n",
       "      <td>145.10</td>\n",
       "      <td>1251.0</td>\n",
       "      <td>0.14640</td>\n",
       "      <td>0.51270</td>\n",
       "      <td>0.87740</td>\n",
       "      <td>0.26030</td>\n",
       "      <td>0.3941</td>\n",
       "      <td>0.09318</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>928594</td>\n",
       "      <td>N</td>\n",
       "      <td>29</td>\n",
       "      <td>21.93</td>\n",
       "      <td>30.64</td>\n",
       "      <td>146.70</td>\n",
       "      <td>1487.0</td>\n",
       "      <td>0.08679</td>\n",
       "      <td>0.17230</td>\n",
       "      <td>0.20530</td>\n",
       "      <td>...</td>\n",
       "      <td>171.50</td>\n",
       "      <td>1951.0</td>\n",
       "      <td>0.11680</td>\n",
       "      <td>0.40720</td>\n",
       "      <td>0.44940</td>\n",
       "      <td>0.18860</td>\n",
       "      <td>0.2784</td>\n",
       "      <td>0.07353</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>929684</td>\n",
       "      <td>R</td>\n",
       "      <td>14</td>\n",
       "      <td>17.53</td>\n",
       "      <td>25.28</td>\n",
       "      <td>114.00</td>\n",
       "      <td>966.6</td>\n",
       "      <td>0.09278</td>\n",
       "      <td>0.09175</td>\n",
       "      <td>0.11050</td>\n",
       "      <td>...</td>\n",
       "      <td>142.60</td>\n",
       "      <td>1483.0</td>\n",
       "      <td>0.12870</td>\n",
       "      <td>0.24720</td>\n",
       "      <td>0.27530</td>\n",
       "      <td>0.13720</td>\n",
       "      <td>0.2404</td>\n",
       "      <td>0.07156</td>\n",
       "      <td>10.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>931652</td>\n",
       "      <td>R</td>\n",
       "      <td>1</td>\n",
       "      <td>18.11</td>\n",
       "      <td>30.99</td>\n",
       "      <td>115.80</td>\n",
       "      <td>984.4</td>\n",
       "      <td>0.08625</td>\n",
       "      <td>0.09240</td>\n",
       "      <td>0.06214</td>\n",
       "      <td>...</td>\n",
       "      <td>128.00</td>\n",
       "      <td>1214.0</td>\n",
       "      <td>0.11940</td>\n",
       "      <td>0.20880</td>\n",
       "      <td>0.23850</td>\n",
       "      <td>0.13330</td>\n",
       "      <td>0.2652</td>\n",
       "      <td>0.07006</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>931678</td>\n",
       "      <td>N</td>\n",
       "      <td>24</td>\n",
       "      <td>24.29</td>\n",
       "      <td>25.48</td>\n",
       "      <td>161.80</td>\n",
       "      <td>1715.0</td>\n",
       "      <td>0.09374</td>\n",
       "      <td>0.22840</td>\n",
       "      <td>0.27020</td>\n",
       "      <td>...</td>\n",
       "      <td>184.80</td>\n",
       "      <td>2213.0</td>\n",
       "      <td>0.12470</td>\n",
       "      <td>0.39350</td>\n",
       "      <td>0.61180</td>\n",
       "      <td>0.20630</td>\n",
       "      <td>0.3983</td>\n",
       "      <td>0.07978</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>935058</td>\n",
       "      <td>N</td>\n",
       "      <td>13</td>\n",
       "      <td>15.60</td>\n",
       "      <td>26.79</td>\n",
       "      <td>99.85</td>\n",
       "      <td>760.0</td>\n",
       "      <td>0.07885</td>\n",
       "      <td>0.05240</td>\n",
       "      <td>0.03778</td>\n",
       "      <td>...</td>\n",
       "      <td>117.20</td>\n",
       "      <td>1027.0</td>\n",
       "      <td>0.10970</td>\n",
       "      <td>0.09745</td>\n",
       "      <td>0.12630</td>\n",
       "      <td>0.08222</td>\n",
       "      <td>0.2805</td>\n",
       "      <td>0.06378</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>935878</td>\n",
       "      <td>N</td>\n",
       "      <td>13</td>\n",
       "      <td>15.78</td>\n",
       "      <td>17.10</td>\n",
       "      <td>102.20</td>\n",
       "      <td>769.0</td>\n",
       "      <td>0.09668</td>\n",
       "      <td>0.09030</td>\n",
       "      <td>0.07268</td>\n",
       "      <td>...</td>\n",
       "      <td>111.70</td>\n",
       "      <td>921.4</td>\n",
       "      <td>0.13860</td>\n",
       "      <td>0.26400</td>\n",
       "      <td>0.29010</td>\n",
       "      <td>0.12340</td>\n",
       "      <td>0.3261</td>\n",
       "      <td>0.07752</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>937100</td>\n",
       "      <td>N</td>\n",
       "      <td>12</td>\n",
       "      <td>19.28</td>\n",
       "      <td>20.88</td>\n",
       "      <td>124.90</td>\n",
       "      <td>1127.0</td>\n",
       "      <td>0.09033</td>\n",
       "      <td>0.11970</td>\n",
       "      <td>0.06435</td>\n",
       "      <td>...</td>\n",
       "      <td>130.00</td>\n",
       "      <td>1214.0</td>\n",
       "      <td>0.09273</td>\n",
       "      <td>0.12590</td>\n",
       "      <td>0.08201</td>\n",
       "      <td>0.11160</td>\n",
       "      <td>0.2147</td>\n",
       "      <td>0.05644</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>937653</td>\n",
       "      <td>N</td>\n",
       "      <td>15</td>\n",
       "      <td>15.66</td>\n",
       "      <td>24.51</td>\n",
       "      <td>102.00</td>\n",
       "      <td>771.1</td>\n",
       "      <td>0.08886</td>\n",
       "      <td>0.08731</td>\n",
       "      <td>0.09483</td>\n",
       "      <td>...</td>\n",
       "      <td>124.00</td>\n",
       "      <td>1066.0</td>\n",
       "      <td>0.11820</td>\n",
       "      <td>0.24860</td>\n",
       "      <td>0.35080</td>\n",
       "      <td>0.12730</td>\n",
       "      <td>0.2964</td>\n",
       "      <td>0.06591</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>937654</td>\n",
       "      <td>N</td>\n",
       "      <td>11</td>\n",
       "      <td>22.44</td>\n",
       "      <td>27.42</td>\n",
       "      <td>150.60</td>\n",
       "      <td>1504.0</td>\n",
       "      <td>0.12110</td>\n",
       "      <td>0.20820</td>\n",
       "      <td>0.35790</td>\n",
       "      <td>...</td>\n",
       "      <td>161.20</td>\n",
       "      <td>1689.0</td>\n",
       "      <td>0.13300</td>\n",
       "      <td>0.25800</td>\n",
       "      <td>0.47410</td>\n",
       "      <td>0.21350</td>\n",
       "      <td>0.2809</td>\n",
       "      <td>0.06318</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>937664</td>\n",
       "      <td>N</td>\n",
       "      <td>17</td>\n",
       "      <td>17.98</td>\n",
       "      <td>23.96</td>\n",
       "      <td>120.00</td>\n",
       "      <td>995.0</td>\n",
       "      <td>0.11570</td>\n",
       "      <td>0.17390</td>\n",
       "      <td>0.19540</td>\n",
       "      <td>...</td>\n",
       "      <td>135.20</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>0.13400</td>\n",
       "      <td>0.26060</td>\n",
       "      <td>0.31240</td>\n",
       "      <td>0.17530</td>\n",
       "      <td>0.2746</td>\n",
       "      <td>0.07830</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>937897</td>\n",
       "      <td>N</td>\n",
       "      <td>17</td>\n",
       "      <td>13.63</td>\n",
       "      <td>24.70</td>\n",
       "      <td>89.65</td>\n",
       "      <td>569.2</td>\n",
       "      <td>0.10550</td>\n",
       "      <td>0.13120</td>\n",
       "      <td>0.11610</td>\n",
       "      <td>...</td>\n",
       "      <td>107.70</td>\n",
       "      <td>712.2</td>\n",
       "      <td>0.15540</td>\n",
       "      <td>0.35150</td>\n",
       "      <td>0.34090</td>\n",
       "      <td>0.16890</td>\n",
       "      <td>0.2739</td>\n",
       "      <td>0.09945</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>938225</td>\n",
       "      <td>N</td>\n",
       "      <td>9</td>\n",
       "      <td>23.01</td>\n",
       "      <td>33.87</td>\n",
       "      <td>156.80</td>\n",
       "      <td>1705.0</td>\n",
       "      <td>0.11570</td>\n",
       "      <td>0.19480</td>\n",
       "      <td>0.29790</td>\n",
       "      <td>...</td>\n",
       "      <td>197.80</td>\n",
       "      <td>2481.0</td>\n",
       "      <td>0.14320</td>\n",
       "      <td>0.28950</td>\n",
       "      <td>0.49370</td>\n",
       "      <td>0.21100</td>\n",
       "      <td>0.2774</td>\n",
       "      <td>0.07542</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>938412</td>\n",
       "      <td>N</td>\n",
       "      <td>10</td>\n",
       "      <td>22.41</td>\n",
       "      <td>29.95</td>\n",
       "      <td>145.50</td>\n",
       "      <td>1528.0</td>\n",
       "      <td>0.11190</td>\n",
       "      <td>0.16990</td>\n",
       "      <td>0.30760</td>\n",
       "      <td>...</td>\n",
       "      <td>194.50</td>\n",
       "      <td>2690.0</td>\n",
       "      <td>0.12510</td>\n",
       "      <td>0.38320</td>\n",
       "      <td>0.58420</td>\n",
       "      <td>0.24220</td>\n",
       "      <td>0.2729</td>\n",
       "      <td>0.09391</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>938413</td>\n",
       "      <td>N</td>\n",
       "      <td>15</td>\n",
       "      <td>12.53</td>\n",
       "      <td>30.98</td>\n",
       "      <td>80.41</td>\n",
       "      <td>490.9</td>\n",
       "      <td>0.09252</td>\n",
       "      <td>0.06271</td>\n",
       "      <td>0.06151</td>\n",
       "      <td>...</td>\n",
       "      <td>96.75</td>\n",
       "      <td>694.6</td>\n",
       "      <td>0.15600</td>\n",
       "      <td>0.13580</td>\n",
       "      <td>0.24360</td>\n",
       "      <td>0.12590</td>\n",
       "      <td>0.3292</td>\n",
       "      <td>0.09406</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>939095</td>\n",
       "      <td>N</td>\n",
       "      <td>6</td>\n",
       "      <td>19.80</td>\n",
       "      <td>20.46</td>\n",
       "      <td>130.20</td>\n",
       "      <td>1235.0</td>\n",
       "      <td>0.09652</td>\n",
       "      <td>0.10770</td>\n",
       "      <td>0.15990</td>\n",
       "      <td>...</td>\n",
       "      <td>155.10</td>\n",
       "      <td>1623.0</td>\n",
       "      <td>0.13730</td>\n",
       "      <td>0.23680</td>\n",
       "      <td>0.39310</td>\n",
       "      <td>0.18400</td>\n",
       "      <td>0.2382</td>\n",
       "      <td>0.06831</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>939426</td>\n",
       "      <td>N</td>\n",
       "      <td>8</td>\n",
       "      <td>19.96</td>\n",
       "      <td>27.41</td>\n",
       "      <td>130.80</td>\n",
       "      <td>1238.0</td>\n",
       "      <td>0.09075</td>\n",
       "      <td>0.11670</td>\n",
       "      <td>0.13550</td>\n",
       "      <td>...</td>\n",
       "      <td>150.30</td>\n",
       "      <td>1603.0</td>\n",
       "      <td>0.12930</td>\n",
       "      <td>0.25130</td>\n",
       "      <td>0.41060</td>\n",
       "      <td>0.16380</td>\n",
       "      <td>0.2245</td>\n",
       "      <td>0.07842</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>9411286</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td>19.22</td>\n",
       "      <td>27.18</td>\n",
       "      <td>128.80</td>\n",
       "      <td>1134.0</td>\n",
       "      <td>0.10900</td>\n",
       "      <td>0.17770</td>\n",
       "      <td>0.21380</td>\n",
       "      <td>...</td>\n",
       "      <td>161.00</td>\n",
       "      <td>1565.0</td>\n",
       "      <td>0.15010</td>\n",
       "      <td>0.51300</td>\n",
       "      <td>0.68410</td>\n",
       "      <td>0.20990</td>\n",
       "      <td>0.3484</td>\n",
       "      <td>0.09774</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>9411300</td>\n",
       "      <td>N</td>\n",
       "      <td>3</td>\n",
       "      <td>14.72</td>\n",
       "      <td>25.26</td>\n",
       "      <td>99.28</td>\n",
       "      <td>657.5</td>\n",
       "      <td>0.11740</td>\n",
       "      <td>0.21120</td>\n",
       "      <td>0.17290</td>\n",
       "      <td>...</td>\n",
       "      <td>111.60</td>\n",
       "      <td>814.8</td>\n",
       "      <td>0.14640</td>\n",
       "      <td>0.53520</td>\n",
       "      <td>0.56550</td>\n",
       "      <td>0.19740</td>\n",
       "      <td>0.3778</td>\n",
       "      <td>0.11320</td>\n",
       "      <td>1.7</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>942640</td>\n",
       "      <td>N</td>\n",
       "      <td>10</td>\n",
       "      <td>22.52</td>\n",
       "      <td>21.92</td>\n",
       "      <td>146.90</td>\n",
       "      <td>1597.0</td>\n",
       "      <td>0.07592</td>\n",
       "      <td>0.09162</td>\n",
       "      <td>0.06862</td>\n",
       "      <td>...</td>\n",
       "      <td>162.10</td>\n",
       "      <td>1902.0</td>\n",
       "      <td>0.08191</td>\n",
       "      <td>0.13190</td>\n",
       "      <td>0.10560</td>\n",
       "      <td>0.09378</td>\n",
       "      <td>0.2061</td>\n",
       "      <td>0.05788</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>943471</td>\n",
       "      <td>N</td>\n",
       "      <td>8</td>\n",
       "      <td>15.44</td>\n",
       "      <td>31.18</td>\n",
       "      <td>101.00</td>\n",
       "      <td>740.4</td>\n",
       "      <td>0.09399</td>\n",
       "      <td>0.10620</td>\n",
       "      <td>0.13750</td>\n",
       "      <td>...</td>\n",
       "      <td>112.60</td>\n",
       "      <td>929.0</td>\n",
       "      <td>0.12720</td>\n",
       "      <td>0.23620</td>\n",
       "      <td>0.29750</td>\n",
       "      <td>0.12860</td>\n",
       "      <td>0.2914</td>\n",
       "      <td>0.08024</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>94547</td>\n",
       "      <td>N</td>\n",
       "      <td>12</td>\n",
       "      <td>17.17</td>\n",
       "      <td>29.19</td>\n",
       "      <td>110.00</td>\n",
       "      <td>915.3</td>\n",
       "      <td>0.08952</td>\n",
       "      <td>0.06655</td>\n",
       "      <td>0.06583</td>\n",
       "      <td>...</td>\n",
       "      <td>132.50</td>\n",
       "      <td>1295.0</td>\n",
       "      <td>0.12610</td>\n",
       "      <td>0.15720</td>\n",
       "      <td>0.21410</td>\n",
       "      <td>0.09520</td>\n",
       "      <td>0.3362</td>\n",
       "      <td>0.06033</td>\n",
       "      <td>3.7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>947204</td>\n",
       "      <td>R</td>\n",
       "      <td>3</td>\n",
       "      <td>21.42</td>\n",
       "      <td>22.84</td>\n",
       "      <td>145.00</td>\n",
       "      <td>1440.0</td>\n",
       "      <td>0.10700</td>\n",
       "      <td>0.19390</td>\n",
       "      <td>0.23800</td>\n",
       "      <td>...</td>\n",
       "      <td>198.30</td>\n",
       "      <td>2375.0</td>\n",
       "      <td>0.14980</td>\n",
       "      <td>0.43790</td>\n",
       "      <td>0.54110</td>\n",
       "      <td>0.22150</td>\n",
       "      <td>0.2832</td>\n",
       "      <td>0.08981</td>\n",
       "      <td>3.0</td>\n",
       "      <td>?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>947489</td>\n",
       "      <td>N</td>\n",
       "      <td>6</td>\n",
       "      <td>16.70</td>\n",
       "      <td>28.13</td>\n",
       "      <td>110.30</td>\n",
       "      <td>885.4</td>\n",
       "      <td>0.08896</td>\n",
       "      <td>0.11310</td>\n",
       "      <td>0.10120</td>\n",
       "      <td>...</td>\n",
       "      <td>128.80</td>\n",
       "      <td>1213.0</td>\n",
       "      <td>0.13300</td>\n",
       "      <td>0.28080</td>\n",
       "      <td>0.34550</td>\n",
       "      <td>0.13170</td>\n",
       "      <td>0.3035</td>\n",
       "      <td>0.08036</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>198 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ID number Outcome  Time  Feature 1  Feature 2  Feature 3  Feature 4  \\\n",
       "0       119513       N    31      18.02      27.60     117.50     1013.0   \n",
       "1         8423       N    61      17.99      10.38     122.80     1001.0   \n",
       "2       842517       N   116      21.37      17.44     137.50     1373.0   \n",
       "3       843483       N   123      11.42      20.38      77.58      386.1   \n",
       "4       843584       R    27      20.29      14.34     135.10     1297.0   \n",
       "5       843786       R    77      12.75      15.29      84.60      502.7   \n",
       "6       844359       N    60      18.98      19.61     124.40     1112.0   \n",
       "7       844582       R    77      13.71      20.83      90.20      577.9   \n",
       "8       844981       N   119      13.00      21.82      87.50      519.8   \n",
       "9       845010       N    76      12.46      24.04      83.97      475.9   \n",
       "10      845636       N   123      16.02      23.24     102.70      797.8   \n",
       "11      846100       N   125      15.78      17.89     103.60      781.0   \n",
       "12      846381       N   117      15.85      23.95     103.70      782.7   \n",
       "13      847990       R    36      14.54      27.54      96.73      658.8   \n",
       "14      848406       N   123      14.68      20.13      94.74      684.5   \n",
       "15      848620       R    10      16.13      20.68     108.10      798.8   \n",
       "16     8511133       N    20      15.34      14.26     102.50      704.4   \n",
       "17      851509       R    10      21.16      23.04     137.20     1404.0   \n",
       "18      852552       N    96      16.65      21.38     110.00      904.6   \n",
       "19      852631       N   116      17.14      16.40     116.00      912.7   \n",
       "20      852763       N   103      14.58      21.53      97.41      644.8   \n",
       "21      852781       N    16      18.61      20.25     122.10     1094.0   \n",
       "22      852973       N    52      15.30      25.27     102.40      732.4   \n",
       "23      853201       N    94      17.57      15.05     115.00      955.1   \n",
       "24      853612       N   116      11.84      18.70      77.93      440.6   \n",
       "25      853826       N    87      17.02      23.98     112.80      899.3   \n",
       "26      854002       N    53      19.27      26.47     127.90     1162.0   \n",
       "27      854039       N   109      16.13      17.88     107.00      807.2   \n",
       "28      854253       N    12      16.74      21.59     110.10      869.5   \n",
       "29      854268       N    31      14.25      21.72      93.63      633.0   \n",
       "..         ...     ...   ...        ...        ...        ...        ...   \n",
       "168     925622       N    30      15.22      30.62     103.40      716.9   \n",
       "169     926125       N    17      20.92      25.09     143.00     1347.0   \n",
       "170     926424       N    28      21.56      22.39     142.00     1479.0   \n",
       "171     926682       N    20      20.13      28.25     131.20     1261.0   \n",
       "172     926954       N    16      16.60      28.08     108.30      858.1   \n",
       "173     927992       N    26      13.86      23.83      89.60      595.8   \n",
       "174     927997       N    27      18.11      26.17     118.70      970.2   \n",
       "175     928594       N    29      21.93      30.64     146.70     1487.0   \n",
       "176     929684       R    14      17.53      25.28     114.00      966.6   \n",
       "177     931652       R     1      18.11      30.99     115.80      984.4   \n",
       "178     931678       N    24      24.29      25.48     161.80     1715.0   \n",
       "179     935058       N    13      15.60      26.79      99.85      760.0   \n",
       "180     935878       N    13      15.78      17.10     102.20      769.0   \n",
       "181     937100       N    12      19.28      20.88     124.90     1127.0   \n",
       "182     937653       N    15      15.66      24.51     102.00      771.1   \n",
       "183     937654       N    11      22.44      27.42     150.60     1504.0   \n",
       "184     937664       N    17      17.98      23.96     120.00      995.0   \n",
       "185     937897       N    17      13.63      24.70      89.65      569.2   \n",
       "186     938225       N     9      23.01      33.87     156.80     1705.0   \n",
       "187     938412       N    10      22.41      29.95     145.50     1528.0   \n",
       "188     938413       N    15      12.53      30.98      80.41      490.9   \n",
       "189     939095       N     6      19.80      20.46     130.20     1235.0   \n",
       "190     939426       N     8      19.96      27.41     130.80     1238.0   \n",
       "191    9411286       N     3      19.22      27.18     128.80     1134.0   \n",
       "192    9411300       N     3      14.72      25.26      99.28      657.5   \n",
       "193     942640       N    10      22.52      21.92     146.90     1597.0   \n",
       "194     943471       N     8      15.44      31.18     101.00      740.4   \n",
       "195      94547       N    12      17.17      29.19     110.00      915.3   \n",
       "196     947204       R     3      21.42      22.84     145.00     1440.0   \n",
       "197     947489       N     6      16.70      28.13     110.30      885.4   \n",
       "\n",
       "     Feature 5  Feature 6  Feature 7     ...      Feature 23  Feature 24  \\\n",
       "0      0.09489    0.10360    0.10860     ...          139.70      1436.0   \n",
       "1      0.11840    0.27760    0.30010     ...          184.60      2019.0   \n",
       "2      0.08836    0.11890    0.12550     ...          159.10      1949.0   \n",
       "3      0.14250    0.28390    0.24140     ...           98.87       567.7   \n",
       "4      0.10030    0.13280    0.19800     ...          152.20      1575.0   \n",
       "5      0.11890    0.15690    0.16640     ...          107.30       733.2   \n",
       "6      0.09087    0.12370    0.12130     ...          152.60      1593.0   \n",
       "7      0.11890    0.16450    0.09366     ...          110.60       897.0   \n",
       "8      0.12730    0.19320    0.18590     ...          106.20       739.3   \n",
       "9      0.11860    0.23960    0.22730     ...           97.65       711.4   \n",
       "10     0.08206    0.06669    0.03299     ...          123.80      1150.0   \n",
       "11     0.09710    0.12920    0.09954     ...          136.50      1299.0   \n",
       "12     0.08401    0.10020    0.09938     ...          112.00       876.5   \n",
       "13     0.11390    0.15950    0.16390     ...          124.10       943.2   \n",
       "14     0.09867    0.07200    0.07395     ...          123.40      1138.0   \n",
       "15     0.11700    0.20220    0.17220     ...          136.80      1315.0   \n",
       "16     0.10730    0.21350    0.20770     ...          125.10       980.9   \n",
       "17     0.09428    0.10220    0.10970     ...          188.00      2615.0   \n",
       "18     0.11210    0.14570    0.15250     ...          177.00      2215.0   \n",
       "19     0.11860    0.22760    0.22290     ...          152.40      1461.0   \n",
       "20     0.10540    0.18680    0.14250     ...          122.40       896.9   \n",
       "21     0.09440    0.10660    0.14900     ...          139.90      1403.0   \n",
       "22     0.10820    0.16970    0.16830     ...          149.30      1269.0   \n",
       "23     0.09847    0.11570    0.09875     ...          134.90      1227.0   \n",
       "24     0.11090    0.15160    0.12180     ...          119.40       888.7   \n",
       "25     0.11970    0.14960    0.24170     ...          136.10      1344.0   \n",
       "26     0.09401    0.17190    0.16570     ...          161.40      1813.0   \n",
       "27     0.10400    0.15590    0.13540     ...          132.70      1261.0   \n",
       "28     0.09610    0.13360    0.13480     ...          133.50      1229.0   \n",
       "29     0.09823    0.10980    0.13190     ...          116.20       799.6   \n",
       "..         ...        ...        ...     ...             ...         ...   \n",
       "168    0.10480    0.20870    0.25500     ...          128.70       915.0   \n",
       "169    0.10990    0.22360    0.31740     ...          179.10      1819.0   \n",
       "170    0.11100    0.11590    0.24390     ...          166.10      2027.0   \n",
       "171    0.09780    0.10340    0.14400     ...          155.00      1731.0   \n",
       "172    0.08455    0.10230    0.09251     ...          126.70      1124.0   \n",
       "173    0.10670    0.08318    0.07671     ...          101.20       730.6   \n",
       "174    0.09867    0.17160    0.21770     ...          145.10      1251.0   \n",
       "175    0.08679    0.17230    0.20530     ...          171.50      1951.0   \n",
       "176    0.09278    0.09175    0.11050     ...          142.60      1483.0   \n",
       "177    0.08625    0.09240    0.06214     ...          128.00      1214.0   \n",
       "178    0.09374    0.22840    0.27020     ...          184.80      2213.0   \n",
       "179    0.07885    0.05240    0.03778     ...          117.20      1027.0   \n",
       "180    0.09668    0.09030    0.07268     ...          111.70       921.4   \n",
       "181    0.09033    0.11970    0.06435     ...          130.00      1214.0   \n",
       "182    0.08886    0.08731    0.09483     ...          124.00      1066.0   \n",
       "183    0.12110    0.20820    0.35790     ...          161.20      1689.0   \n",
       "184    0.11570    0.17390    0.19540     ...          135.20      1225.0   \n",
       "185    0.10550    0.13120    0.11610     ...          107.70       712.2   \n",
       "186    0.11570    0.19480    0.29790     ...          197.80      2481.0   \n",
       "187    0.11190    0.16990    0.30760     ...          194.50      2690.0   \n",
       "188    0.09252    0.06271    0.06151     ...           96.75       694.6   \n",
       "189    0.09652    0.10770    0.15990     ...          155.10      1623.0   \n",
       "190    0.09075    0.11670    0.13550     ...          150.30      1603.0   \n",
       "191    0.10900    0.17770    0.21380     ...          161.00      1565.0   \n",
       "192    0.11740    0.21120    0.17290     ...          111.60       814.8   \n",
       "193    0.07592    0.09162    0.06862     ...          162.10      1902.0   \n",
       "194    0.09399    0.10620    0.13750     ...          112.60       929.0   \n",
       "195    0.08952    0.06655    0.06583     ...          132.50      1295.0   \n",
       "196    0.10700    0.19390    0.23800     ...          198.30      2375.0   \n",
       "197    0.08896    0.11310    0.10120     ...          128.80      1213.0   \n",
       "\n",
       "     Feature 25  Feature 26  Feature 27  Feature 28  Feature 29  Feature 30  \\\n",
       "0       0.11950     0.19260     0.31400     0.11700      0.2677     0.08113   \n",
       "1       0.16220     0.66560     0.71190     0.26540      0.4601     0.11890   \n",
       "2       0.11880     0.34490     0.34140     0.20320      0.4334     0.09067   \n",
       "3       0.20980     0.86630     0.68690     0.25750      0.6638     0.17300   \n",
       "4       0.13740     0.20500     0.40000     0.16250      0.2364     0.07678   \n",
       "5       0.17060     0.41960     0.59990     0.17090      0.3485     0.11790   \n",
       "6       0.11440     0.33710     0.29900     0.19220      0.2726     0.09581   \n",
       "7       0.16540     0.36820     0.26780     0.15560      0.3196     0.11510   \n",
       "8       0.17030     0.54010     0.53900     0.20600      0.4378     0.10720   \n",
       "9       0.18530     1.05800     1.10500     0.22100      0.4366     0.20750   \n",
       "10      0.11810     0.15510     0.14590     0.09975      0.2948     0.08452   \n",
       "11      0.13960     0.56090     0.39650     0.18100      0.3792     0.10480   \n",
       "12      0.11310     0.19240     0.23220     0.11190      0.2809     0.06287   \n",
       "13      0.16780     0.65770     0.70260     0.17120      0.4218     0.13410   \n",
       "14      0.14640     0.18710     0.29140     0.16090      0.3029     0.08216   \n",
       "15      0.17890     0.42330     0.47840     0.20730      0.3706     0.11420   \n",
       "16      0.13900     0.59540     0.63050     0.23930      0.4667     0.09946   \n",
       "17      0.14010     0.26000     0.31550     0.20090      0.2822     0.07526   \n",
       "18      0.18050     0.35780     0.46950     0.20950      0.3613     0.09564   \n",
       "19      0.15450     0.39490     0.38530     0.25500      0.4066     0.10590   \n",
       "20      0.15250     0.66430     0.55390     0.27010      0.4264     0.12750   \n",
       "21      0.13380     0.21170     0.34460     0.14900      0.2341     0.07421   \n",
       "22      0.16410     0.61100     0.63350     0.20240      0.4027     0.09876   \n",
       "23      0.12550     0.28120     0.24890     0.14560      0.2756     0.07919   \n",
       "24      0.16370     0.57750     0.69560     0.15460      0.4761     0.14020   \n",
       "25      0.16340     0.35590     0.55880     0.18470      0.3530     0.08482   \n",
       "26      0.15090     0.65900     0.60910     0.17850      0.3672     0.11230   \n",
       "27      0.14460     0.58040     0.52740     0.18640      0.4270     0.12330   \n",
       "28      0.15630     0.38350     0.54090     0.18130      0.4863     0.08633   \n",
       "29      0.14460     0.42380     0.51860     0.14470      0.3591     0.10140   \n",
       "..          ...         ...         ...         ...         ...         ...   \n",
       "168     0.14170     0.79170     1.17000     0.23560      0.4089     0.14090   \n",
       "169     0.14070     0.41860     0.65990     0.25420      0.2929     0.09873   \n",
       "170     0.14100     0.21130     0.41070     0.22160      0.2060     0.07115   \n",
       "171     0.11660     0.19220     0.32150     0.16280      0.2572     0.06637   \n",
       "172     0.11390     0.30940     0.34030     0.14180      0.2218     0.07820   \n",
       "173     0.14670     0.12790     0.16770     0.11140      0.2180     0.06057   \n",
       "174     0.14640     0.51270     0.87740     0.26030      0.3941     0.09318   \n",
       "175     0.11680     0.40720     0.44940     0.18860      0.2784     0.07353   \n",
       "176     0.12870     0.24720     0.27530     0.13720      0.2404     0.07156   \n",
       "177     0.11940     0.20880     0.23850     0.13330      0.2652     0.07006   \n",
       "178     0.12470     0.39350     0.61180     0.20630      0.3983     0.07978   \n",
       "179     0.10970     0.09745     0.12630     0.08222      0.2805     0.06378   \n",
       "180     0.13860     0.26400     0.29010     0.12340      0.3261     0.07752   \n",
       "181     0.09273     0.12590     0.08201     0.11160      0.2147     0.05644   \n",
       "182     0.11820     0.24860     0.35080     0.12730      0.2964     0.06591   \n",
       "183     0.13300     0.25800     0.47410     0.21350      0.2809     0.06318   \n",
       "184     0.13400     0.26060     0.31240     0.17530      0.2746     0.07830   \n",
       "185     0.15540     0.35150     0.34090     0.16890      0.2739     0.09945   \n",
       "186     0.14320     0.28950     0.49370     0.21100      0.2774     0.07542   \n",
       "187     0.12510     0.38320     0.58420     0.24220      0.2729     0.09391   \n",
       "188     0.15600     0.13580     0.24360     0.12590      0.3292     0.09406   \n",
       "189     0.13730     0.23680     0.39310     0.18400      0.2382     0.06831   \n",
       "190     0.12930     0.25130     0.41060     0.16380      0.2245     0.07842   \n",
       "191     0.15010     0.51300     0.68410     0.20990      0.3484     0.09774   \n",
       "192     0.14640     0.53520     0.56550     0.19740      0.3778     0.11320   \n",
       "193     0.08191     0.13190     0.10560     0.09378      0.2061     0.05788   \n",
       "194     0.12720     0.23620     0.29750     0.12860      0.2914     0.08024   \n",
       "195     0.12610     0.15720     0.21410     0.09520      0.3362     0.06033   \n",
       "196     0.14980     0.43790     0.54110     0.22150      0.2832     0.08981   \n",
       "197     0.13300     0.28080     0.34550     0.13170      0.3035     0.08036   \n",
       "\n",
       "     Feature 31  Feature 32  \n",
       "0           5.0           5  \n",
       "1           3.0           2  \n",
       "2           2.5           0  \n",
       "3           2.0           0  \n",
       "4           3.5           0  \n",
       "5           2.5           0  \n",
       "6           1.5           ?  \n",
       "7           4.0          10  \n",
       "8           2.0           1  \n",
       "9           6.0          20  \n",
       "10          2.0           0  \n",
       "11          1.4           0  \n",
       "12          1.0           0  \n",
       "13          6.0           6  \n",
       "14          1.1           0  \n",
       "15          3.0           1  \n",
       "16          1.3           0  \n",
       "17          4.0           1  \n",
       "18          3.0           0  \n",
       "19          4.4           1  \n",
       "20          2.5           0  \n",
       "21          3.4          13  \n",
       "22          2.0           0  \n",
       "23          4.0           0  \n",
       "24          3.0           2  \n",
       "25          1.3           1  \n",
       "26          3.5           0  \n",
       "27          2.5           0  \n",
       "28          1.5           ?  \n",
       "29          3.0          13  \n",
       "..          ...         ...  \n",
       "168         2.5           0  \n",
       "169         1.5           0  \n",
       "170         1.2           0  \n",
       "171         1.0           0  \n",
       "172         3.5           1  \n",
       "173         1.5           1  \n",
       "174         2.4           2  \n",
       "175         3.5           0  \n",
       "176        10.0           9  \n",
       "177         2.7           4  \n",
       "178         1.2           0  \n",
       "179         2.0           2  \n",
       "180         0.8           0  \n",
       "181         2.5           0  \n",
       "182         2.0           4  \n",
       "183         1.0           0  \n",
       "184         2.5           0  \n",
       "185         2.0           0  \n",
       "186         4.0           0  \n",
       "187         1.0           1  \n",
       "188         3.0           7  \n",
       "189         2.1           2  \n",
       "190         4.0           0  \n",
       "191         0.8           1  \n",
       "192         1.7          21  \n",
       "193         6.0           2  \n",
       "194         1.5           0  \n",
       "195         3.7           0  \n",
       "196         3.0           ?  \n",
       "197         3.5           0  \n",
       "\n",
       "[198 rows x 35 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Drop missing rows\n",
    "data.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Find the indices of the rows where the outcome is N (= nonrecur)\n",
    "indexNames = data[data['Outcome'] == 'N'].index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Delete these row indexes from dataFrame\n",
    "data.drop(indexNames , inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# It is easier to have adjacent indices\n",
    "data = data.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    index  ID number Outcome  Time  Feature 1  Feature 2  Feature 3  \\\n",
      "0       4     843584       R    27      20.29      14.34     135.10   \n",
      "1       5     843786       R    77      12.75      15.29      84.60   \n",
      "2       7     844582       R    77      13.71      20.83      90.20   \n",
      "3      13     847990       R    36      14.54      27.54      96.73   \n",
      "4      15     848620       R    10      16.13      20.68     108.10   \n",
      "5      17     851509       R    10      21.16      23.04     137.20   \n",
      "6      34     855625       R     9      19.07      24.81     128.30   \n",
      "7      37     857010       R     8      18.65      17.60     123.70   \n",
      "8      39     857438       R    48      15.10      22.02      97.26   \n",
      "9      40     857637       R    11      19.21      18.57     125.50   \n",
      "10     42     858986       R    34      14.25      22.15      96.42   \n",
      "11     43     859223       R    19      12.68      23.84      82.69   \n",
      "12     46     859983       R    26      13.80      15.79      90.43   \n",
      "13     48    8611792       R    40      19.10      26.29     129.10   \n",
      "14     50      86208       R    10      20.77      22.83     137.40   \n",
      "15     56     865128       R    35      17.95      20.01     114.20   \n",
      "16     59     866203       R    73      19.00      18.91     123.40   \n",
      "17     62     867739       R     7      20.29      21.49     132.80   \n",
      "18     67      87112       R    44      17.68      20.74     117.40   \n",
      "19     69     871201       R     8      19.59      18.15     130.70   \n",
      "20     75     873592       R    17      27.22      21.87     182.10   \n",
      "21     81     875263       R    74      12.34      26.86      81.15   \n",
      "22     88     879523       R    17      15.12      16.68      98.78   \n",
      "23    105     886490       R    19      19.55      28.77     133.60   \n",
      "24    109     887549       R    39      20.31      27.06     132.90   \n",
      "25    110     888570       R    12      17.29      22.13     114.40   \n",
      "26    112     889719       R    37      17.19      22.07     111.60   \n",
      "27    114    8910988       R     5      21.75      20.99     147.30   \n",
      "28    120     892438       R    58      19.53      18.90     129.50   \n",
      "29    125      89539       R    78      16.27      20.71     106.90   \n",
      "30    128      89812       R    24      23.51      24.27     155.10   \n",
      "31    129     898431       R    33      19.68      21.68     129.90   \n",
      "32    131     899987       R     4      25.73      17.46     174.20   \n",
      "33    132    9010018       R     5      15.08      25.74      98.00   \n",
      "34    135    9012000       R     2      22.01      21.90     147.20   \n",
      "35    143     906023       R    49      15.50      21.08     102.90   \n",
      "36    145     908194       R     1      20.18      19.54     133.80   \n",
      "37    147     908489       R     9      13.98      19.62      91.12   \n",
      "38    150    9110732       R    16      17.75      28.03     117.30   \n",
      "39    152    9111805       R     9      19.59      25.00     127.70   \n",
      "40    155     913505       R    14      19.44      18.82     128.10   \n",
      "41    157     914062       R    12      18.01      20.56     118.40   \n",
      "42    159      91485       R    11      20.59      21.24     137.80   \n",
      "43    161     915143       R     7      24.24      18.74     159.60   \n",
      "44    176     929684       R    14      17.53      25.28     114.00   \n",
      "45    177     931652       R     1      18.11      30.99     115.80   \n",
      "46    196     947204       R     3      21.42      22.84     145.00   \n",
      "\n",
      "    Feature 4  Feature 5  Feature 6     ...      Feature 23  Feature 24  \\\n",
      "0      1297.0    0.10030    0.13280     ...           152.2      1575.0   \n",
      "1       502.7    0.11890    0.15690     ...           107.3       733.2   \n",
      "2       577.9    0.11890    0.16450     ...           110.6       897.0   \n",
      "3       658.8    0.11390    0.15950     ...           124.1       943.2   \n",
      "4       798.8    0.11700    0.20220     ...           136.8      1315.0   \n",
      "5      1404.0    0.09428    0.10220     ...           188.0      2615.0   \n",
      "6      1104.0    0.09081    0.21900     ...           177.4      1651.0   \n",
      "7      1076.0    0.10990    0.16860     ...           150.6      1567.0   \n",
      "8       712.8    0.09056    0.07081     ...           117.7      1030.0   \n",
      "9      1152.0    0.10530    0.12670     ...           170.1      2145.0   \n",
      "10      645.7    0.10490    0.20080     ...           119.1       959.5   \n",
      "11      499.0    0.11220    0.12620     ...           111.8       888.3   \n",
      "12      584.1    0.10070    0.12800     ...           110.3       812.4   \n",
      "13     1132.0    0.12150    0.17910     ...           141.3      1298.0   \n",
      "14     1336.0    0.10330    0.15150     ...           159.9      1816.0   \n",
      "15      982.0    0.08402    0.06722     ...           129.2      1261.0   \n",
      "16     1138.0    0.08217    0.08028     ...           148.2      1538.0   \n",
      "17     1291.0    0.09258    0.12050     ...           171.6      2196.0   \n",
      "18      963.7    0.11150    0.16650     ...           132.9      1302.0   \n",
      "19     1214.0    0.11200    0.16660     ...           174.9      2232.0   \n",
      "20     2250.0    0.10940    0.19140     ...           220.8      3216.0   \n",
      "21      477.4    0.10340    0.13530     ...           101.7       768.9   \n",
      "22      716.6    0.08876    0.09588     ...           117.7       989.5   \n",
      "23     1207.0    0.09260    0.20630     ...           178.6      1926.0   \n",
      "24     1288.0    0.10000    0.10880     ...           162.3      1844.0   \n",
      "25      947.8    0.08999    0.12730     ...           137.9      1295.0   \n",
      "26      928.3    0.09726    0.08995     ...           140.5      1436.0   \n",
      "27     1491.0    0.09401    0.19610     ...           195.9      2384.0   \n",
      "28     1217.0    0.11500    0.16420     ...           171.1      2053.0   \n",
      "29      813.7    0.11690    0.13190     ...           129.8      1121.0   \n",
      "30     1747.0    0.10690    0.12830     ...           202.4      2906.0   \n",
      "31     1194.0    0.09797    0.13390     ...           157.6      1540.0   \n",
      "32     2010.0    0.11490    0.23630     ...           229.3      3234.0   \n",
      "33      716.6    0.10240    0.09769     ...           121.2      1050.0   \n",
      "34     1482.0    0.10630    0.19540     ...           195.0      2227.0   \n",
      "35      803.1    0.11200    0.15710     ...           157.1      1748.0   \n",
      "36     1250.0    0.11330    0.14890     ...           146.0      1479.0   \n",
      "37      599.5    0.10600    0.11330     ...           113.9       869.3   \n",
      "38      981.6    0.09997    0.13140     ...           145.4      1437.0   \n",
      "39     1191.0    0.10320    0.09871     ...           139.8      1421.0   \n",
      "40     1167.0    0.10890    0.14480     ...           153.9      1740.0   \n",
      "41     1007.0    0.10010    0.12890     ...           143.4      1426.0   \n",
      "42     1320.0    0.10850    0.16440     ...           163.2      1760.0   \n",
      "43     1945.0    0.08938    0.11360     ...           232.2      3903.0   \n",
      "44      966.6    0.09278    0.09175     ...           142.6      1483.0   \n",
      "45      984.4    0.08625    0.09240     ...           128.0      1214.0   \n",
      "46     1440.0    0.10700    0.19390     ...           198.3      2375.0   \n",
      "\n",
      "    Feature 25  Feature 26  Feature 27  Feature 28  Feature 29  Feature 30  \\\n",
      "0       0.1374      0.2050      0.4000      0.1625      0.2364     0.07678   \n",
      "1       0.1706      0.4196      0.5999      0.1709      0.3485     0.11790   \n",
      "2       0.1654      0.3682      0.2678      0.1556      0.3196     0.11510   \n",
      "3       0.1678      0.6577      0.7026      0.1712      0.4218     0.13410   \n",
      "4       0.1789      0.4233      0.4784      0.2073      0.3706     0.11420   \n",
      "5       0.1401      0.2600      0.3155      0.2009      0.2822     0.07526   \n",
      "6       0.1247      0.7444      0.7242      0.2493      0.4670     0.10380   \n",
      "7       0.1679      0.5090      0.7345      0.2378      0.3799     0.09185   \n",
      "8       0.1389      0.2057      0.2712      0.1530      0.2675     0.07873   \n",
      "9       0.1624      0.3511      0.3879      0.2091      0.3537     0.08294   \n",
      "10      0.1640      0.6247      0.6922      0.1785      0.2844     0.11320   \n",
      "11      0.1851      0.4061      0.4024      0.1716      0.3383     0.10310   \n",
      "12      0.1411      0.3542      0.2779      0.1383      0.2589     0.10300   \n",
      "13      0.1392      0.2817      0.2432      0.1841      0.2311     0.09203   \n",
      "14      0.1385      0.4107      0.3757      0.1881      0.3371     0.07651   \n",
      "15      0.1072      0.1202      0.2249      0.1185      0.4882     0.06111   \n",
      "16      0.1021      0.2264      0.3207      0.1218      0.2841     0.06541   \n",
      "17      0.1225      0.3449      0.4509      0.1943      0.4416     0.07863   \n",
      "18      0.1418      0.3498      0.3583      0.1515      0.2463     0.07738   \n",
      "19      0.1438      0.3846      0.6810      0.2247      0.3643     0.09223   \n",
      "20      0.1472      0.4034      0.5340      0.2688      0.2856     0.08082   \n",
      "21      0.1785      0.4706      0.4425      0.1459      0.3215     0.12050   \n",
      "22      0.1491      0.3331      0.3327      0.1252      0.3415     0.09740   \n",
      "23      0.1281      0.5329      0.4251      0.1941      0.2818     0.10050   \n",
      "24      0.1522      0.2945      0.3788      0.1697      0.3151     0.07999   \n",
      "25      0.1134      0.2867      0.2298      0.1528      0.3067     0.07484   \n",
      "26      0.1558      0.2567      0.3889      0.1984      0.3216     0.07570   \n",
      "27      0.1272      0.4725      0.5807      0.1841      0.2833     0.08858   \n",
      "28      0.1495      0.4116      0.6121      0.1980      0.2968     0.09929   \n",
      "29      0.1590      0.2947      0.3597      0.1583      0.3103     0.08200   \n",
      "30      0.1515      0.2678      0.4819      0.2089      0.2593     0.07738   \n",
      "31      0.1218      0.3458      0.4734      0.2255      0.4045     0.07918   \n",
      "32      0.1530      0.5937      0.6451      0.2756      0.3690     0.08815   \n",
      "33      0.1660      0.2356      0.4029      0.1526      0.2654     0.09438   \n",
      "34      0.1294      0.3885      0.4756      0.2432      0.2741     0.08574   \n",
      "35      0.1517      0.4002      0.4211      0.2134      0.3003     0.10480   \n",
      "36      0.1665      0.2942      0.5308      0.2173      0.3032     0.08075   \n",
      "37      0.1613      0.3568      0.4069      0.1827      0.3179     0.10550   \n",
      "38      0.1401      0.3762      0.6399      0.1970      0.2972     0.09075   \n",
      "39      0.1528      0.1845      0.3977      0.1466      0.2293     0.06091   \n",
      "40      0.1514      0.3725      0.5936      0.2060      0.3266     0.09009   \n",
      "41      0.1309      0.2327      0.2544      0.1489      0.3251     0.07625   \n",
      "42      0.1464      0.3597      0.5179      0.2113      0.2480     0.08999   \n",
      "43      0.1154      0.1772      0.2917      0.1795      0.2336     0.06259   \n",
      "44      0.1287      0.2472      0.2753      0.1372      0.2404     0.07156   \n",
      "45      0.1194      0.2088      0.2385      0.1333      0.2652     0.07006   \n",
      "46      0.1498      0.4379      0.5411      0.2215      0.2832     0.08981   \n",
      "\n",
      "    Feature 31  Feature 32  \n",
      "0          3.5           0  \n",
      "1          2.5           0  \n",
      "2          4.0          10  \n",
      "3          6.0           6  \n",
      "4          3.0           1  \n",
      "5          4.0           1  \n",
      "6          2.3           0  \n",
      "7          1.8           0  \n",
      "8          2.5           0  \n",
      "9          3.2          13  \n",
      "10         1.5           0  \n",
      "11         1.2           1  \n",
      "12         3.0           2  \n",
      "13         3.0           1  \n",
      "14         4.0           2  \n",
      "15         3.0           1  \n",
      "16         3.5          15  \n",
      "17         2.5           9  \n",
      "18         9.0           7  \n",
      "19         3.5           0  \n",
      "20         4.0           4  \n",
      "21         1.2           4  \n",
      "22         1.5           0  \n",
      "23         6.0          15  \n",
      "24         1.8           1  \n",
      "25         4.0           1  \n",
      "26         8.5           6  \n",
      "27         2.5          11  \n",
      "28         2.0           0  \n",
      "29         2.5           2  \n",
      "30         3.5           4  \n",
      "31         1.5          13  \n",
      "32         4.5           0  \n",
      "33         2.6           0  \n",
      "34         3.0           1  \n",
      "35         0.4           0  \n",
      "36         4.5          27  \n",
      "37         3.5           4  \n",
      "38         1.5           7  \n",
      "39         2.0           7  \n",
      "40         7.0           9  \n",
      "41         3.5           2  \n",
      "42         5.5          20  \n",
      "43         3.0           4  \n",
      "44        10.0           9  \n",
      "45         2.7           4  \n",
      "46         3.0           ?  \n",
      "\n",
      "[47 rows x 36 columns]\n"
     ]
    }
   ],
   "source": [
    "print(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    Time  Feature 1  Feature 2  Feature 3  Feature 4  Feature 5  Feature 6  \\\n",
      "0     27      20.29      14.34     135.10     1297.0    0.10030    0.13280   \n",
      "1     77      12.75      15.29      84.60      502.7    0.11890    0.15690   \n",
      "2     77      13.71      20.83      90.20      577.9    0.11890    0.16450   \n",
      "3     36      14.54      27.54      96.73      658.8    0.11390    0.15950   \n",
      "4     10      16.13      20.68     108.10      798.8    0.11700    0.20220   \n",
      "5     10      21.16      23.04     137.20     1404.0    0.09428    0.10220   \n",
      "6      9      19.07      24.81     128.30     1104.0    0.09081    0.21900   \n",
      "7      8      18.65      17.60     123.70     1076.0    0.10990    0.16860   \n",
      "8     48      15.10      22.02      97.26      712.8    0.09056    0.07081   \n",
      "9     11      19.21      18.57     125.50     1152.0    0.10530    0.12670   \n",
      "10    34      14.25      22.15      96.42      645.7    0.10490    0.20080   \n",
      "11    19      12.68      23.84      82.69      499.0    0.11220    0.12620   \n",
      "12    26      13.80      15.79      90.43      584.1    0.10070    0.12800   \n",
      "13    40      19.10      26.29     129.10     1132.0    0.12150    0.17910   \n",
      "14    10      20.77      22.83     137.40     1336.0    0.10330    0.15150   \n",
      "15    35      17.95      20.01     114.20      982.0    0.08402    0.06722   \n",
      "16    73      19.00      18.91     123.40     1138.0    0.08217    0.08028   \n",
      "17     7      20.29      21.49     132.80     1291.0    0.09258    0.12050   \n",
      "18    44      17.68      20.74     117.40      963.7    0.11150    0.16650   \n",
      "19     8      19.59      18.15     130.70     1214.0    0.11200    0.16660   \n",
      "20    17      27.22      21.87     182.10     2250.0    0.10940    0.19140   \n",
      "21    74      12.34      26.86      81.15      477.4    0.10340    0.13530   \n",
      "22    17      15.12      16.68      98.78      716.6    0.08876    0.09588   \n",
      "23    19      19.55      28.77     133.60     1207.0    0.09260    0.20630   \n",
      "24    39      20.31      27.06     132.90     1288.0    0.10000    0.10880   \n",
      "25    12      17.29      22.13     114.40      947.8    0.08999    0.12730   \n",
      "26    37      17.19      22.07     111.60      928.3    0.09726    0.08995   \n",
      "27     5      21.75      20.99     147.30     1491.0    0.09401    0.19610   \n",
      "28    58      19.53      18.90     129.50     1217.0    0.11500    0.16420   \n",
      "29    78      16.27      20.71     106.90      813.7    0.11690    0.13190   \n",
      "30    24      23.51      24.27     155.10     1747.0    0.10690    0.12830   \n",
      "31    33      19.68      21.68     129.90     1194.0    0.09797    0.13390   \n",
      "32     4      25.73      17.46     174.20     2010.0    0.11490    0.23630   \n",
      "33     5      15.08      25.74      98.00      716.6    0.10240    0.09769   \n",
      "34     2      22.01      21.90     147.20     1482.0    0.10630    0.19540   \n",
      "35    49      15.50      21.08     102.90      803.1    0.11200    0.15710   \n",
      "36     1      20.18      19.54     133.80     1250.0    0.11330    0.14890   \n",
      "37     9      13.98      19.62      91.12      599.5    0.10600    0.11330   \n",
      "38    16      17.75      28.03     117.30      981.6    0.09997    0.13140   \n",
      "39     9      19.59      25.00     127.70     1191.0    0.10320    0.09871   \n",
      "40    14      19.44      18.82     128.10     1167.0    0.10890    0.14480   \n",
      "41    12      18.01      20.56     118.40     1007.0    0.10010    0.12890   \n",
      "42    11      20.59      21.24     137.80     1320.0    0.10850    0.16440   \n",
      "43     7      24.24      18.74     159.60     1945.0    0.08938    0.11360   \n",
      "44    14      17.53      25.28     114.00      966.6    0.09278    0.09175   \n",
      "45     1      18.11      30.99     115.80      984.4    0.08625    0.09240   \n",
      "46     3      21.42      22.84     145.00     1440.0    0.10700    0.19390   \n",
      "\n",
      "    Feature 7  Feature 8  Feature 9     ...      Feature 23  Feature 24  \\\n",
      "0     0.19800    0.10430     0.1809     ...           152.2      1575.0   \n",
      "1     0.16640    0.07666     0.1995     ...           107.3       733.2   \n",
      "2     0.09366    0.05985     0.2196     ...           110.6       897.0   \n",
      "3     0.16390    0.07364     0.2303     ...           124.1       943.2   \n",
      "4     0.17220    0.10280     0.2164     ...           136.8      1315.0   \n",
      "5     0.10970    0.08632     0.1769     ...           188.0      2615.0   \n",
      "6     0.21070    0.09961     0.2310     ...           177.4      1651.0   \n",
      "7     0.19740    0.10090     0.1907     ...           150.6      1567.0   \n",
      "8     0.05253    0.03334     0.1616     ...           117.7      1030.0   \n",
      "9     0.13230    0.08994     0.1917     ...           170.1      2145.0   \n",
      "10    0.21350    0.08653     0.1949     ...           119.1       959.5   \n",
      "11    0.11280    0.06873     0.1905     ...           111.8       888.3   \n",
      "12    0.07789    0.05069     0.1662     ...           110.3       812.4   \n",
      "13    0.19370    0.14690     0.1634     ...           141.3      1298.0   \n",
      "14    0.16370    0.10150     0.1800     ...           159.9      1816.0   \n",
      "15    0.07293    0.05596     0.2129     ...           129.2      1261.0   \n",
      "16    0.09271    0.05627     0.1946     ...           148.2      1538.0   \n",
      "17    0.15230    0.08636     0.2356     ...           171.6      2196.0   \n",
      "18    0.18550    0.10540     0.1971     ...           132.9      1302.0   \n",
      "19    0.25080    0.12860     0.2027     ...           174.9      2232.0   \n",
      "20    0.28710    0.18780     0.1800     ...           220.8      3216.0   \n",
      "21    0.10850    0.04562     0.1943     ...           101.7       768.9   \n",
      "22    0.07550    0.04079     0.1594     ...           117.7       989.5   \n",
      "23    0.17840    0.11440     0.1893     ...           178.6      1926.0   \n",
      "24    0.15190    0.09333     0.1814     ...           162.3      1844.0   \n",
      "25    0.09697    0.07507     0.2108     ...           137.9      1295.0   \n",
      "26    0.09061    0.06527     0.1867     ...           140.5      1436.0   \n",
      "27    0.21950    0.10880     0.1721     ...           195.9      2384.0   \n",
      "28    0.21970    0.10620     0.1792     ...           171.1      2053.0   \n",
      "29    0.14780    0.08488     0.1948     ...           129.8      1121.0   \n",
      "30    0.23080    0.14100     0.1797     ...           202.4      2906.0   \n",
      "31    0.18630    0.11030     0.2082     ...           157.6      1540.0   \n",
      "32    0.33680    0.19130     0.1956     ...           229.3      3234.0   \n",
      "33    0.12350    0.06553     0.1647     ...           121.2      1050.0   \n",
      "34    0.24480    0.15010     0.1824     ...           195.0      2227.0   \n",
      "35    0.15220    0.08481     0.2085     ...           157.1      1748.0   \n",
      "36    0.21330    0.12590     0.1724     ...           146.0      1479.0   \n",
      "37    0.11260    0.06463     0.1669     ...           113.9       869.3   \n",
      "38    0.16980    0.08293     0.1713     ...           145.4      1437.0   \n",
      "39    0.16550    0.09063     0.1663     ...           139.8      1421.0   \n",
      "40    0.22560    0.11940     0.1823     ...           153.9      1740.0   \n",
      "41    0.11700    0.07762     0.2116     ...           143.4      1426.0   \n",
      "42    0.21880    0.11210     0.1848     ...           163.2      1760.0   \n",
      "43    0.17270    0.10710     0.1591     ...           232.2      3903.0   \n",
      "44    0.11050    0.06741     0.1424     ...           142.6      1483.0   \n",
      "45    0.06214    0.05598     0.1603     ...           128.0      1214.0   \n",
      "46    0.23800    0.13180     0.1884     ...           198.3      2375.0   \n",
      "\n",
      "    Feature 25  Feature 26  Feature 27  Feature 28  Feature 29  Feature 30  \\\n",
      "0       0.1374      0.2050      0.4000      0.1625      0.2364     0.07678   \n",
      "1       0.1706      0.4196      0.5999      0.1709      0.3485     0.11790   \n",
      "2       0.1654      0.3682      0.2678      0.1556      0.3196     0.11510   \n",
      "3       0.1678      0.6577      0.7026      0.1712      0.4218     0.13410   \n",
      "4       0.1789      0.4233      0.4784      0.2073      0.3706     0.11420   \n",
      "5       0.1401      0.2600      0.3155      0.2009      0.2822     0.07526   \n",
      "6       0.1247      0.7444      0.7242      0.2493      0.4670     0.10380   \n",
      "7       0.1679      0.5090      0.7345      0.2378      0.3799     0.09185   \n",
      "8       0.1389      0.2057      0.2712      0.1530      0.2675     0.07873   \n",
      "9       0.1624      0.3511      0.3879      0.2091      0.3537     0.08294   \n",
      "10      0.1640      0.6247      0.6922      0.1785      0.2844     0.11320   \n",
      "11      0.1851      0.4061      0.4024      0.1716      0.3383     0.10310   \n",
      "12      0.1411      0.3542      0.2779      0.1383      0.2589     0.10300   \n",
      "13      0.1392      0.2817      0.2432      0.1841      0.2311     0.09203   \n",
      "14      0.1385      0.4107      0.3757      0.1881      0.3371     0.07651   \n",
      "15      0.1072      0.1202      0.2249      0.1185      0.4882     0.06111   \n",
      "16      0.1021      0.2264      0.3207      0.1218      0.2841     0.06541   \n",
      "17      0.1225      0.3449      0.4509      0.1943      0.4416     0.07863   \n",
      "18      0.1418      0.3498      0.3583      0.1515      0.2463     0.07738   \n",
      "19      0.1438      0.3846      0.6810      0.2247      0.3643     0.09223   \n",
      "20      0.1472      0.4034      0.5340      0.2688      0.2856     0.08082   \n",
      "21      0.1785      0.4706      0.4425      0.1459      0.3215     0.12050   \n",
      "22      0.1491      0.3331      0.3327      0.1252      0.3415     0.09740   \n",
      "23      0.1281      0.5329      0.4251      0.1941      0.2818     0.10050   \n",
      "24      0.1522      0.2945      0.3788      0.1697      0.3151     0.07999   \n",
      "25      0.1134      0.2867      0.2298      0.1528      0.3067     0.07484   \n",
      "26      0.1558      0.2567      0.3889      0.1984      0.3216     0.07570   \n",
      "27      0.1272      0.4725      0.5807      0.1841      0.2833     0.08858   \n",
      "28      0.1495      0.4116      0.6121      0.1980      0.2968     0.09929   \n",
      "29      0.1590      0.2947      0.3597      0.1583      0.3103     0.08200   \n",
      "30      0.1515      0.2678      0.4819      0.2089      0.2593     0.07738   \n",
      "31      0.1218      0.3458      0.4734      0.2255      0.4045     0.07918   \n",
      "32      0.1530      0.5937      0.6451      0.2756      0.3690     0.08815   \n",
      "33      0.1660      0.2356      0.4029      0.1526      0.2654     0.09438   \n",
      "34      0.1294      0.3885      0.4756      0.2432      0.2741     0.08574   \n",
      "35      0.1517      0.4002      0.4211      0.2134      0.3003     0.10480   \n",
      "36      0.1665      0.2942      0.5308      0.2173      0.3032     0.08075   \n",
      "37      0.1613      0.3568      0.4069      0.1827      0.3179     0.10550   \n",
      "38      0.1401      0.3762      0.6399      0.1970      0.2972     0.09075   \n",
      "39      0.1528      0.1845      0.3977      0.1466      0.2293     0.06091   \n",
      "40      0.1514      0.3725      0.5936      0.2060      0.3266     0.09009   \n",
      "41      0.1309      0.2327      0.2544      0.1489      0.3251     0.07625   \n",
      "42      0.1464      0.3597      0.5179      0.2113      0.2480     0.08999   \n",
      "43      0.1154      0.1772      0.2917      0.1795      0.2336     0.06259   \n",
      "44      0.1287      0.2472      0.2753      0.1372      0.2404     0.07156   \n",
      "45      0.1194      0.2088      0.2385      0.1333      0.2652     0.07006   \n",
      "46      0.1498      0.4379      0.5411      0.2215      0.2832     0.08981   \n",
      "\n",
      "    Feature 31  Feature 32  \n",
      "0          3.5           0  \n",
      "1          2.5           0  \n",
      "2          4.0          10  \n",
      "3          6.0           6  \n",
      "4          3.0           1  \n",
      "5          4.0           1  \n",
      "6          2.3           0  \n",
      "7          1.8           0  \n",
      "8          2.5           0  \n",
      "9          3.2          13  \n",
      "10         1.5           0  \n",
      "11         1.2           1  \n",
      "12         3.0           2  \n",
      "13         3.0           1  \n",
      "14         4.0           2  \n",
      "15         3.0           1  \n",
      "16         3.5          15  \n",
      "17         2.5           9  \n",
      "18         9.0           7  \n",
      "19         3.5           0  \n",
      "20         4.0           4  \n",
      "21         1.2           4  \n",
      "22         1.5           0  \n",
      "23         6.0          15  \n",
      "24         1.8           1  \n",
      "25         4.0           1  \n",
      "26         8.5           6  \n",
      "27         2.5          11  \n",
      "28         2.0           0  \n",
      "29         2.5           2  \n",
      "30         3.5           4  \n",
      "31         1.5          13  \n",
      "32         4.5           0  \n",
      "33         2.6           0  \n",
      "34         3.0           1  \n",
      "35         0.4           0  \n",
      "36         4.5          27  \n",
      "37         3.5           4  \n",
      "38         1.5           7  \n",
      "39         2.0           7  \n",
      "40         7.0           9  \n",
      "41         3.5           2  \n",
      "42         5.5          20  \n",
      "43         3.0           4  \n",
      "44        10.0           9  \n",
      "45         2.7           4  \n",
      "46         3.0           ?  \n",
      "\n",
      "[47 rows x 33 columns]\n"
     ]
    }
   ],
   "source": [
    "temp = data.iloc[:,3:36]\n",
    "print(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0      True\n",
      "1      True\n",
      "2      True\n",
      "3      True\n",
      "4      True\n",
      "5      True\n",
      "6      True\n",
      "7      True\n",
      "8      True\n",
      "9      True\n",
      "10     True\n",
      "11     True\n",
      "12     True\n",
      "13     True\n",
      "14     True\n",
      "15     True\n",
      "16     True\n",
      "17     True\n",
      "18     True\n",
      "19     True\n",
      "20     True\n",
      "21     True\n",
      "22     True\n",
      "23     True\n",
      "24     True\n",
      "25     True\n",
      "26     True\n",
      "27     True\n",
      "28     True\n",
      "29     True\n",
      "30     True\n",
      "31     True\n",
      "32     True\n",
      "33     True\n",
      "34     True\n",
      "35     True\n",
      "36     True\n",
      "37     True\n",
      "38     True\n",
      "39     True\n",
      "40     True\n",
      "41     True\n",
      "42     True\n",
      "43     True\n",
      "44     True\n",
      "45     True\n",
      "46    False\n",
      "dtype: bool\n"
     ]
    }
   ],
   "source": [
    "#temp.apply(lambda s: pd.to_numeric(s, errors='coerce').notnull().all())\n",
    "# Check if all rows are real numbers. Initially, it checks per element (applymap) and it returns True only if the whole row\n",
    "# is True (all(1))\n",
    "b = temp.applymap(np.isreal).all(1)\n",
    "b.columns = ['truth']\n",
    "print(b)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "idx = []     # this list will contain the row indices that are False\n",
    "for i in range(len(b)): \n",
    "    # check if rows are True and if False, append the index in the list\n",
    "    if not b.iloc[i]:\n",
    "        idx.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Delete these row indexes from the initial dataFrame (data)\n",
    "data.drop(data.index[idx], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "#print(data.dtypes)\n",
    "feat = data.iloc[:,4:36]\n",
    "lab = data.iloc[:,3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "int64\n",
      "<class 'pandas.core.series.Series'>\n"
     ]
    }
   ],
   "source": [
    "# Transform them to np arrays\n",
    "print(lab.dtype)\n",
    "print(type(lab))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import d2l\n",
    "from mxnet import autograd, np, npx, nd\n",
    "import mxnet as mx\n",
    "import random\n",
    "npx.set_np()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[27. 77. 77. 36. 10. 10.  9.  8. 48. 11. 34. 19. 26. 40. 10. 35. 73.  7.\n",
      " 44.  8. 17. 74. 17. 19. 39. 12. 37.  5. 58. 78. 24. 33.  4.  5.  2. 49.\n",
      "  1.  9. 16.  9. 14. 12. 11.  7. 14.  1.]\n"
     ]
    }
   ],
   "source": [
    "l = np.array(lab)\n",
    "labels = l.astype('float32') \n",
    "print(labels)\n",
    "#print(l.dtype)\n",
    "#print(type(l))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[2.029e+01 1.434e+01 1.351e+02 ... 7.678e-02 3.500e+00 0.000e+00]\n",
      " [1.275e+01 1.529e+01 8.460e+01 ... 1.179e-01 2.500e+00 0.000e+00]\n",
      " [1.371e+01 2.083e+01 9.020e+01 ... 1.151e-01 4.000e+00 1.000e+01]\n",
      " ...\n",
      " [2.424e+01 1.874e+01 1.596e+02 ... 6.259e-02 3.000e+00 4.000e+00]\n",
      " [1.753e+01 2.528e+01 1.140e+02 ... 7.156e-02 1.000e+01 9.000e+00]\n",
      " [1.811e+01 3.099e+01 1.158e+02 ... 7.006e-02 2.700e+00 4.000e+00]]\n"
     ]
    }
   ],
   "source": [
    "f = np.array(feat)\n",
    "features = f.astype('float32') \n",
    "print(features)\n",
    "#print(f.dtype)\n",
    "#print(type(f))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 250,
   "metadata": {},
   "outputs": [],
   "source": [
    "def data_iter(batch_size, features, labels):\n",
    "    num_examples = len(features)\n",
    "    indices = list(range(num_examples))\n",
    "    # The examples are read at random, in no particular order\n",
    "    random.shuffle(indices)\n",
    "    for i in range(0, num_examples, batch_size):\n",
    "        batch_indices = np.array(\n",
    "            indices[i: min(i + batch_size, num_examples)])\n",
    "        yield features[batch_indices], labels[batch_indices]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 457,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[1.275e+01 1.529e+01 8.460e+01 5.027e+02 1.189e-01 1.569e-01 1.664e-01\n",
      "  7.666e-02 1.995e-01 7.164e-02 3.877e-01 7.402e-01 2.999e+00 3.085e+01\n",
      "  7.775e-03 2.987e-02 4.561e-02 1.357e-02 1.774e-02 5.114e-03 1.551e+01\n",
      "  2.037e+01 1.073e+02 7.332e+02 1.706e-01 4.196e-01 5.999e-01 1.709e-01\n",
      "  3.485e-01 1.179e-01 2.500e+00 0.000e+00]\n",
      " [1.729e+01 2.213e+01 1.144e+02 9.478e+02 8.999e-02 1.273e-01 9.697e-02\n",
      "  7.507e-02 2.108e-01 5.464e-02 8.348e-01 1.633e+00 6.146e+00 9.094e+01\n",
      "  6.717e-03 5.981e-02 4.638e-02 2.149e-02 2.747e-02 5.838e-03 2.039e+01\n",
      "  2.724e+01 1.379e+02 1.295e+03 1.134e-01 2.867e-01 2.298e-01 1.528e-01\n",
      "  3.067e-01 7.484e-02 4.000e+00 1.000e+00]\n",
      " [2.424e+01 1.874e+01 1.596e+02 1.945e+03 8.938e-02 1.136e-01 1.727e-01\n",
      "  1.071e-01 1.591e-01 5.175e-02 1.730e+00 8.535e-01 1.156e+01 3.160e+02\n",
      "  5.137e-03 1.279e-02 2.353e-02 1.508e-02 1.615e-02 2.252e-03 3.513e+01\n",
      "  2.336e+01 2.322e+02 3.903e+03 1.154e-01 1.772e-01 2.917e-01 1.795e-01\n",
      "  2.336e-01 6.259e-02 3.000e+00 4.000e+00]\n",
      " [1.775e+01 2.803e+01 1.173e+02 9.816e+02 9.997e-02 1.314e-01 1.698e-01\n",
      "  8.293e-02 1.713e-01 5.916e-02 3.897e-01 1.077e+00 2.873e+00 4.395e+01\n",
      "  4.714e-03 2.015e-02 3.697e-02 1.110e-02 1.237e-02 2.556e-03 2.153e+01\n",
      "  3.854e+01 1.454e+02 1.437e+03 1.401e-01 3.762e-01 6.399e-01 1.970e-01\n",
      "  2.972e-01 9.075e-02 1.500e+00 7.000e+00]\n",
      " [2.077e+01 2.283e+01 1.374e+02 1.336e+03 1.033e-01 1.515e-01 1.637e-01\n",
      "  1.015e-01 1.800e-01 5.641e-02 7.569e-01 1.458e+00 5.095e+00 9.299e+01\n",
      "  6.852e-03 4.575e-02 3.694e-02 1.598e-02 2.958e-02 4.069e-03 2.422e+01\n",
      "  2.943e+01 1.599e+02 1.816e+03 1.385e-01 4.107e-01 3.757e-01 1.881e-01\n",
      "  3.371e-01 7.651e-02 4.000e+00 2.000e+00]\n",
      " [1.865e+01 1.760e+01 1.237e+02 1.076e+03 1.099e-01 1.686e-01 1.974e-01\n",
      "  1.009e-01 1.907e-01 6.049e-02 6.289e-01 6.633e-01 4.293e+00 7.156e+01\n",
      "  6.294e-03 3.994e-02 5.554e-02 1.695e-02 2.428e-02 3.535e-03 2.282e+01\n",
      "  2.132e+01 1.506e+02 1.567e+03 1.679e-01 5.090e-01 7.345e-01 2.378e-01\n",
      "  3.799e-01 9.185e-02 1.800e+00 0.000e+00]\n",
      " [2.573e+01 1.746e+01 1.742e+02 2.010e+03 1.149e-01 2.363e-01 3.368e-01\n",
      "  1.913e-01 1.956e-01 6.121e-02 9.948e-01 8.509e-01 7.222e+00 1.531e+02\n",
      "  6.369e-03 4.243e-02 4.266e-02 1.508e-02 2.335e-02 3.385e-03 3.313e+01\n",
      "  2.358e+01 2.293e+02 3.234e+03 1.530e-01 5.937e-01 6.451e-01 2.756e-01\n",
      "  3.690e-01 8.815e-02 4.500e+00 0.000e+00]\n",
      " [1.968e+01 2.168e+01 1.299e+02 1.194e+03 9.797e-02 1.339e-01 1.863e-01\n",
      "  1.103e-01 2.082e-01 5.715e-02 6.226e-01 2.284e+00 5.173e+00 6.766e+01\n",
      "  4.756e-03 3.368e-02 4.345e-02 1.806e-02 3.756e-02 3.288e-03 2.275e+01\n",
      "  3.466e+01 1.576e+02 1.540e+03 1.218e-01 3.458e-01 4.734e-01 2.255e-01\n",
      "  4.045e-01 7.918e-02 1.500e+00 1.300e+01]\n",
      " [1.753e+01 2.528e+01 1.140e+02 9.666e+02 9.278e-02 9.175e-02 1.105e-01\n",
      "  6.741e-02 1.424e-01 5.563e-02 4.587e-01 1.318e+00 3.032e+00 5.227e+01\n",
      "  4.540e-03 1.312e-02 1.720e-02 7.299e-03 9.783e-03 1.526e-03 2.175e+01\n",
      "  4.014e+01 1.426e+02 1.483e+03 1.287e-01 2.472e-01 2.753e-01 1.372e-01\n",
      "  2.404e-01 7.156e-02 1.000e+01 9.000e+00]\n",
      " [2.116e+01 2.304e+01 1.372e+02 1.404e+03 9.428e-02 1.022e-01 1.097e-01\n",
      "  8.632e-02 1.769e-01 5.278e-02 6.917e-01 1.127e+00 4.303e+00 9.399e+01\n",
      "  4.728e-03 1.259e-02 1.715e-02 1.038e-02 1.083e-02 1.987e-03 2.917e+01\n",
      "  3.559e+01 1.880e+02 2.615e+03 1.401e-01 2.600e-01 3.155e-01 2.009e-01\n",
      "  2.822e-01 7.526e-02 4.000e+00 1.000e+00]] \n",
      " [77. 12.  7. 16. 10.  8.  4. 33. 14. 10.]\n"
     ]
    }
   ],
   "source": [
    "batch_size = 10\n",
    "\n",
    "for X, y in data_iter(batch_size, features, labels):\n",
    "    print(X, '\\n', y)\n",
    "    break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 458,
   "metadata": {},
   "outputs": [],
   "source": [
    "w = np.random.normal(0, 1e-10, (32,1))\n",
    "b = np.zeros(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 459,
   "metadata": {},
   "outputs": [],
   "source": [
    "w.attach_grad()\n",
    "b.attach_grad()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 460,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Saved in the d2l package for later use\n",
    "def linreg(X, w, b):\n",
    "    regr = np.dot(X, w) + b\n",
    "    #print('X', X)\n",
    "    #print('Regr', regr)\n",
    "    return regr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 461,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(32, 1) (1,)\n",
      "(46, 32) (46,)\n"
     ]
    }
   ],
   "source": [
    "print(w.shape, b.shape)\n",
    "print(features.shape, labels.shape)\n",
    "# f* w + b = l"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 462,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Saved in the d2l package for later use\n",
    "def squared_loss(y_hat, y):\n",
    "    #print('regr output', y_hat)\n",
    "    #print('yhat - y:',(y_hat - y.reshape(y_hat.shape))** 2 / 2  )\n",
    "    sq_loss = (y_hat - y.reshape(y_hat.shape)) ** 2 / 2\n",
    "    return sq_loss"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 463,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Saved in the d2l package for later use\n",
    "def sgd(params, lr, batch_size):\n",
    "    for param in params:\n",
    "        param[:] = param - lr * param.grad / batch_size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 464,
   "metadata": {},
   "outputs": [],
   "source": [
    "# In our case, big learning rate gets the gradient large very fast, so the output of the linear regression becomes infinite\n",
    "# therefore the loss function becomes infinite as well\n",
    "# until 1e-7 everything is ok, but if you go down to 1e-6, the gradient starts exploding again!\n",
    "lr = 1e-7  # Learning rate\n",
    "\n",
    "# Smaller learning rate means we learn slowly, so we can increase the number of epochs, until the point \n",
    "# the loss starts increasing again\n",
    "num_epochs = 100  # Number of iterations\n",
    "\n",
    "net = linreg  # Our fancy linear model\n",
    "loss = squared_loss  # 0.5 (y-y')^2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 465,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "epoch 1, loss 374.042084\n",
      "epoch 2, loss 383.830078\n",
      "epoch 3, loss 372.009308\n",
      "epoch 4, loss 371.146698\n",
      "epoch 5, loss 371.072815\n",
      "epoch 6, loss 371.000397\n",
      "epoch 7, loss 370.216492\n",
      "epoch 8, loss 380.395111\n",
      "epoch 9, loss 371.651947\n",
      "epoch 10, loss 371.086060\n",
      "epoch 11, loss 371.625397\n",
      "epoch 12, loss 369.494385\n",
      "epoch 13, loss 367.876007\n",
      "epoch 14, loss 383.181305\n",
      "epoch 15, loss 366.800781\n",
      "epoch 16, loss 367.044891\n",
      "epoch 17, loss 365.556732\n",
      "epoch 18, loss 365.431000\n",
      "epoch 19, loss 365.190857\n",
      "epoch 20, loss 365.546844\n",
      "epoch 21, loss 364.269287\n",
      "epoch 22, loss 366.632294\n",
      "epoch 23, loss 363.222626\n",
      "epoch 24, loss 363.971344\n",
      "epoch 25, loss 365.917114\n",
      "epoch 26, loss 365.077789\n",
      "epoch 27, loss 362.811951\n",
      "epoch 28, loss 363.856964\n",
      "epoch 29, loss 371.256927\n",
      "epoch 30, loss 361.549347\n",
      "epoch 31, loss 361.392059\n",
      "epoch 32, loss 366.647125\n",
      "epoch 33, loss 361.018158\n",
      "epoch 34, loss 362.172211\n",
      "epoch 35, loss 358.915588\n",
      "epoch 36, loss 363.737946\n",
      "epoch 37, loss 363.813507\n",
      "epoch 38, loss 358.870667\n",
      "epoch 39, loss 360.640320\n",
      "epoch 40, loss 362.115540\n",
      "epoch 41, loss 358.013794\n",
      "epoch 42, loss 364.030060\n",
      "epoch 43, loss 356.506042\n",
      "epoch 44, loss 358.113251\n",
      "epoch 45, loss 355.989838\n",
      "epoch 46, loss 358.087311\n",
      "epoch 47, loss 368.904541\n",
      "epoch 48, loss 356.459076\n",
      "epoch 49, loss 355.205048\n",
      "epoch 50, loss 357.186615\n",
      "epoch 51, loss 354.362457\n",
      "epoch 52, loss 355.009796\n",
      "epoch 53, loss 374.278961\n",
      "epoch 54, loss 363.750580\n",
      "epoch 55, loss 353.208862\n",
      "epoch 56, loss 354.528778\n",
      "epoch 57, loss 355.357391\n",
      "epoch 58, loss 352.364197\n",
      "epoch 59, loss 354.547485\n",
      "epoch 60, loss 352.887207\n",
      "epoch 61, loss 351.859650\n",
      "epoch 62, loss 351.353668\n",
      "epoch 63, loss 359.052551\n",
      "epoch 64, loss 352.958038\n",
      "epoch 65, loss 353.067841\n",
      "epoch 66, loss 351.280701\n",
      "epoch 67, loss 351.537140\n",
      "epoch 68, loss 350.072906\n",
      "epoch 69, loss 350.027222\n",
      "epoch 70, loss 353.709412\n",
      "epoch 71, loss 359.451752\n",
      "epoch 72, loss 349.079895\n",
      "epoch 73, loss 353.855530\n",
      "epoch 74, loss 355.005066\n",
      "epoch 75, loss 352.283234\n",
      "epoch 76, loss 348.400421\n",
      "epoch 77, loss 351.624847\n",
      "epoch 78, loss 349.022339\n",
      "epoch 79, loss 349.696655\n",
      "epoch 80, loss 347.785889\n",
      "epoch 81, loss 347.322845\n",
      "epoch 82, loss 346.846497\n",
      "epoch 83, loss 357.365814\n",
      "epoch 84, loss 346.776886\n",
      "epoch 85, loss 346.340271\n",
      "epoch 86, loss 346.060852\n",
      "epoch 87, loss 350.156677\n",
      "epoch 88, loss 345.665771\n",
      "epoch 89, loss 347.147491\n",
      "epoch 90, loss 345.270355\n",
      "epoch 91, loss 345.136627\n",
      "epoch 92, loss 347.622864\n",
      "epoch 93, loss 344.810272\n",
      "epoch 94, loss 347.317932\n",
      "epoch 95, loss 345.009216\n",
      "epoch 96, loss 349.091370\n",
      "epoch 97, loss 344.364197\n",
      "epoch 98, loss 344.199463\n",
      "epoch 99, loss 343.959137\n",
      "epoch 100, loss 343.491608\n"
     ]
    }
   ],
   "source": [
    "for epoch in range(num_epochs):\n",
    "    # Assuming the number of examples can be divided by the batch size, all\n",
    "    # the examples in the training dataset are used once in one epoch\n",
    "    # iteration. The features and tags of minibatch examples are given by X\n",
    "    # and y respectively\n",
    "    for X, y in data_iter(batch_size, features, labels):\n",
    "        with autograd.record():\n",
    "            l = loss(net(X, w, b), y)  # Minibatch loss in X and y\n",
    "        l.backward()  # Compute gradient on l with respect to [w, b]\n",
    "        sgd([w, b], lr, batch_size)  # Update parameters using their gradient\n",
    "    train_l = loss(net(features, w, b), labels)\n",
    "    print('epoch %d, loss %f' % (epoch + 1, train_l.mean().asnumpy()))"
   ]
  },
  {
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}