nba_KNN.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# KNN\n",
    "We'll be using the K-nearest neighbors algorithm to predict how many points NBA players scored in a season. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 408,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from sklearn import preprocessing\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 409,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['player' 'pos' 'age' 'bref_team_id' 'g' 'gs' 'mp' 'fg' 'fga' 'fg.' 'x3p'\n",
      " 'x3pa' 'x3p.' 'x2p' 'x2pa' 'x2p.' 'efg.' 'ft' 'fta' 'ft.' 'orb' 'drb'\n",
      " 'trb' 'ast' 'stl' 'blk' 'tov' 'pf' 'pts' 'season' 'season_end']\n"
     ]
    }
   ],
   "source": [
    "df = pd.read_csv(\"nba_2013.csv\")\n",
    "\n",
    "\n",
    "print(df.columns.values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 410,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>player</th>\n",
       "      <th>pos</th>\n",
       "      <th>age</th>\n",
       "      <th>bref_team_id</th>\n",
       "      <th>g</th>\n",
       "      <th>gs</th>\n",
       "      <th>mp</th>\n",
       "      <th>fg</th>\n",
       "      <th>fga</th>\n",
       "      <th>fg.</th>\n",
       "      <th>...</th>\n",
       "      <th>drb</th>\n",
       "      <th>trb</th>\n",
       "      <th>ast</th>\n",
       "      <th>stl</th>\n",
       "      <th>blk</th>\n",
       "      <th>tov</th>\n",
       "      <th>pf</th>\n",
       "      <th>pts</th>\n",
       "      <th>season</th>\n",
       "      <th>season_end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Quincy Acy</td>\n",
       "      <td>SF</td>\n",
       "      <td>23</td>\n",
       "      <td>TOT</td>\n",
       "      <td>63</td>\n",
       "      <td>0</td>\n",
       "      <td>847</td>\n",
       "      <td>66</td>\n",
       "      <td>141</td>\n",
       "      <td>0.468</td>\n",
       "      <td>...</td>\n",
       "      <td>144</td>\n",
       "      <td>216</td>\n",
       "      <td>28</td>\n",
       "      <td>23</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>122</td>\n",
       "      <td>171</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Steven Adams</td>\n",
       "      <td>C</td>\n",
       "      <td>20</td>\n",
       "      <td>OKC</td>\n",
       "      <td>81</td>\n",
       "      <td>20</td>\n",
       "      <td>1197</td>\n",
       "      <td>93</td>\n",
       "      <td>185</td>\n",
       "      <td>0.503</td>\n",
       "      <td>...</td>\n",
       "      <td>190</td>\n",
       "      <td>332</td>\n",
       "      <td>43</td>\n",
       "      <td>40</td>\n",
       "      <td>57</td>\n",
       "      <td>71</td>\n",
       "      <td>203</td>\n",
       "      <td>265</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jeff Adrien</td>\n",
       "      <td>PF</td>\n",
       "      <td>27</td>\n",
       "      <td>TOT</td>\n",
       "      <td>53</td>\n",
       "      <td>12</td>\n",
       "      <td>961</td>\n",
       "      <td>143</td>\n",
       "      <td>275</td>\n",
       "      <td>0.520</td>\n",
       "      <td>...</td>\n",
       "      <td>204</td>\n",
       "      <td>306</td>\n",
       "      <td>38</td>\n",
       "      <td>24</td>\n",
       "      <td>36</td>\n",
       "      <td>39</td>\n",
       "      <td>108</td>\n",
       "      <td>362</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Arron Afflalo</td>\n",
       "      <td>SG</td>\n",
       "      <td>28</td>\n",
       "      <td>ORL</td>\n",
       "      <td>73</td>\n",
       "      <td>73</td>\n",
       "      <td>2552</td>\n",
       "      <td>464</td>\n",
       "      <td>1011</td>\n",
       "      <td>0.459</td>\n",
       "      <td>...</td>\n",
       "      <td>230</td>\n",
       "      <td>262</td>\n",
       "      <td>248</td>\n",
       "      <td>35</td>\n",
       "      <td>3</td>\n",
       "      <td>146</td>\n",
       "      <td>136</td>\n",
       "      <td>1330</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alexis Ajinca</td>\n",
       "      <td>C</td>\n",
       "      <td>25</td>\n",
       "      <td>NOP</td>\n",
       "      <td>56</td>\n",
       "      <td>30</td>\n",
       "      <td>951</td>\n",
       "      <td>136</td>\n",
       "      <td>249</td>\n",
       "      <td>0.546</td>\n",
       "      <td>...</td>\n",
       "      <td>183</td>\n",
       "      <td>277</td>\n",
       "      <td>40</td>\n",
       "      <td>23</td>\n",
       "      <td>46</td>\n",
       "      <td>63</td>\n",
       "      <td>187</td>\n",
       "      <td>328</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Cole Aldrich</td>\n",
       "      <td>C</td>\n",
       "      <td>25</td>\n",
       "      <td>NYK</td>\n",
       "      <td>46</td>\n",
       "      <td>2</td>\n",
       "      <td>330</td>\n",
       "      <td>33</td>\n",
       "      <td>61</td>\n",
       "      <td>0.541</td>\n",
       "      <td>...</td>\n",
       "      <td>92</td>\n",
       "      <td>129</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>40</td>\n",
       "      <td>92</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>LaMarcus Aldridge</td>\n",
       "      <td>PF</td>\n",
       "      <td>28</td>\n",
       "      <td>POR</td>\n",
       "      <td>69</td>\n",
       "      <td>69</td>\n",
       "      <td>2498</td>\n",
       "      <td>652</td>\n",
       "      <td>1423</td>\n",
       "      <td>0.458</td>\n",
       "      <td>...</td>\n",
       "      <td>599</td>\n",
       "      <td>765</td>\n",
       "      <td>178</td>\n",
       "      <td>63</td>\n",
       "      <td>68</td>\n",
       "      <td>123</td>\n",
       "      <td>147</td>\n",
       "      <td>1603</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Lavoy Allen</td>\n",
       "      <td>PF</td>\n",
       "      <td>24</td>\n",
       "      <td>TOT</td>\n",
       "      <td>65</td>\n",
       "      <td>2</td>\n",
       "      <td>1072</td>\n",
       "      <td>134</td>\n",
       "      <td>300</td>\n",
       "      <td>0.447</td>\n",
       "      <td>...</td>\n",
       "      <td>192</td>\n",
       "      <td>311</td>\n",
       "      <td>71</td>\n",
       "      <td>24</td>\n",
       "      <td>33</td>\n",
       "      <td>44</td>\n",
       "      <td>126</td>\n",
       "      <td>303</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ray Allen</td>\n",
       "      <td>SG</td>\n",
       "      <td>38</td>\n",
       "      <td>MIA</td>\n",
       "      <td>73</td>\n",
       "      <td>9</td>\n",
       "      <td>1936</td>\n",
       "      <td>240</td>\n",
       "      <td>543</td>\n",
       "      <td>0.442</td>\n",
       "      <td>...</td>\n",
       "      <td>182</td>\n",
       "      <td>205</td>\n",
       "      <td>143</td>\n",
       "      <td>54</td>\n",
       "      <td>8</td>\n",
       "      <td>84</td>\n",
       "      <td>115</td>\n",
       "      <td>701</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Tony Allen</td>\n",
       "      <td>SG</td>\n",
       "      <td>32</td>\n",
       "      <td>MEM</td>\n",
       "      <td>55</td>\n",
       "      <td>28</td>\n",
       "      <td>1278</td>\n",
       "      <td>204</td>\n",
       "      <td>413</td>\n",
       "      <td>0.494</td>\n",
       "      <td>...</td>\n",
       "      <td>129</td>\n",
       "      <td>208</td>\n",
       "      <td>94</td>\n",
       "      <td>90</td>\n",
       "      <td>19</td>\n",
       "      <td>90</td>\n",
       "      <td>121</td>\n",
       "      <td>495</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Al-Farouq Aminu</td>\n",
       "      <td>SF</td>\n",
       "      <td>23</td>\n",
       "      <td>NOP</td>\n",
       "      <td>80</td>\n",
       "      <td>65</td>\n",
       "      <td>2045</td>\n",
       "      <td>234</td>\n",
       "      <td>494</td>\n",
       "      <td>0.474</td>\n",
       "      <td>...</td>\n",
       "      <td>367</td>\n",
       "      <td>496</td>\n",
       "      <td>114</td>\n",
       "      <td>82</td>\n",
       "      <td>38</td>\n",
       "      <td>88</td>\n",
       "      <td>147</td>\n",
       "      <td>572</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Louis Amundson</td>\n",
       "      <td>PF</td>\n",
       "      <td>31</td>\n",
       "      <td>TOT</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>185</td>\n",
       "      <td>16</td>\n",
       "      <td>32</td>\n",
       "      <td>0.500</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>55</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>49</td>\n",
       "      <td>38</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Chris Andersen</td>\n",
       "      <td>C</td>\n",
       "      <td>35</td>\n",
       "      <td>MIA</td>\n",
       "      <td>72</td>\n",
       "      <td>0</td>\n",
       "      <td>1396</td>\n",
       "      <td>177</td>\n",
       "      <td>275</td>\n",
       "      <td>0.644</td>\n",
       "      <td>...</td>\n",
       "      <td>250</td>\n",
       "      <td>379</td>\n",
       "      <td>19</td>\n",
       "      <td>32</td>\n",
       "      <td>97</td>\n",
       "      <td>53</td>\n",
       "      <td>162</td>\n",
       "      <td>477</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Alan Anderson</td>\n",
       "      <td>SF</td>\n",
       "      <td>31</td>\n",
       "      <td>BRK</td>\n",
       "      <td>78</td>\n",
       "      <td>26</td>\n",
       "      <td>1773</td>\n",
       "      <td>194</td>\n",
       "      <td>485</td>\n",
       "      <td>0.400</td>\n",
       "      <td>...</td>\n",
       "      <td>135</td>\n",
       "      <td>175</td>\n",
       "      <td>81</td>\n",
       "      <td>48</td>\n",
       "      <td>11</td>\n",
       "      <td>62</td>\n",
       "      <td>147</td>\n",
       "      <td>564</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>James Anderson</td>\n",
       "      <td>SG</td>\n",
       "      <td>24</td>\n",
       "      <td>PHI</td>\n",
       "      <td>80</td>\n",
       "      <td>62</td>\n",
       "      <td>2309</td>\n",
       "      <td>309</td>\n",
       "      <td>717</td>\n",
       "      <td>0.431</td>\n",
       "      <td>...</td>\n",
       "      <td>241</td>\n",
       "      <td>300</td>\n",
       "      <td>149</td>\n",
       "      <td>74</td>\n",
       "      <td>28</td>\n",
       "      <td>106</td>\n",
       "      <td>154</td>\n",
       "      <td>810</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Ryan Anderson</td>\n",
       "      <td>PF</td>\n",
       "      <td>25</td>\n",
       "      <td>NOP</td>\n",
       "      <td>22</td>\n",
       "      <td>14</td>\n",
       "      <td>795</td>\n",
       "      <td>155</td>\n",
       "      <td>354</td>\n",
       "      <td>0.438</td>\n",
       "      <td>...</td>\n",
       "      <td>76</td>\n",
       "      <td>142</td>\n",
       "      <td>17</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>20</td>\n",
       "      <td>47</td>\n",
       "      <td>436</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Giannis Antetokounmpo</td>\n",
       "      <td>SF</td>\n",
       "      <td>19</td>\n",
       "      <td>MIL</td>\n",
       "      <td>77</td>\n",
       "      <td>23</td>\n",
       "      <td>1897</td>\n",
       "      <td>173</td>\n",
       "      <td>418</td>\n",
       "      <td>0.414</td>\n",
       "      <td>...</td>\n",
       "      <td>261</td>\n",
       "      <td>339</td>\n",
       "      <td>150</td>\n",
       "      <td>60</td>\n",
       "      <td>61</td>\n",
       "      <td>122</td>\n",
       "      <td>173</td>\n",
       "      <td>525</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Carmelo Anthony</td>\n",
       "      <td>PF</td>\n",
       "      <td>29</td>\n",
       "      <td>NYK</td>\n",
       "      <td>77</td>\n",
       "      <td>77</td>\n",
       "      <td>2982</td>\n",
       "      <td>743</td>\n",
       "      <td>1643</td>\n",
       "      <td>0.452</td>\n",
       "      <td>...</td>\n",
       "      <td>477</td>\n",
       "      <td>622</td>\n",
       "      <td>242</td>\n",
       "      <td>95</td>\n",
       "      <td>51</td>\n",
       "      <td>198</td>\n",
       "      <td>224</td>\n",
       "      <td>2112</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Joel Anthony</td>\n",
       "      <td>C</td>\n",
       "      <td>31</td>\n",
       "      <td>TOT</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>186</td>\n",
       "      <td>12</td>\n",
       "      <td>32</td>\n",
       "      <td>0.375</td>\n",
       "      <td>...</td>\n",
       "      <td>23</td>\n",
       "      <td>38</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>17</td>\n",
       "      <td>28</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Pero Antic</td>\n",
       "      <td>PF</td>\n",
       "      <td>31</td>\n",
       "      <td>ATL</td>\n",
       "      <td>50</td>\n",
       "      <td>26</td>\n",
       "      <td>925</td>\n",
       "      <td>123</td>\n",
       "      <td>294</td>\n",
       "      <td>0.418</td>\n",
       "      <td>...</td>\n",
       "      <td>152</td>\n",
       "      <td>209</td>\n",
       "      <td>58</td>\n",
       "      <td>19</td>\n",
       "      <td>12</td>\n",
       "      <td>55</td>\n",
       "      <td>126</td>\n",
       "      <td>352</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Trevor Ariza</td>\n",
       "      <td>SF</td>\n",
       "      <td>28</td>\n",
       "      <td>WAS</td>\n",
       "      <td>77</td>\n",
       "      <td>77</td>\n",
       "      <td>2723</td>\n",
       "      <td>389</td>\n",
       "      <td>853</td>\n",
       "      <td>0.456</td>\n",
       "      <td>...</td>\n",
       "      <td>376</td>\n",
       "      <td>475</td>\n",
       "      <td>191</td>\n",
       "      <td>126</td>\n",
       "      <td>20</td>\n",
       "      <td>132</td>\n",
       "      <td>179</td>\n",
       "      <td>1107</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Hilton Armstrong</td>\n",
       "      <td>C</td>\n",
       "      <td>29</td>\n",
       "      <td>GSW</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>97</td>\n",
       "      <td>9</td>\n",
       "      <td>19</td>\n",
       "      <td>0.474</td>\n",
       "      <td>...</td>\n",
       "      <td>28</td>\n",
       "      <td>47</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>25</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Darrell Arthur</td>\n",
       "      <td>SF</td>\n",
       "      <td>25</td>\n",
       "      <td>DEN</td>\n",
       "      <td>68</td>\n",
       "      <td>1</td>\n",
       "      <td>1161</td>\n",
       "      <td>162</td>\n",
       "      <td>410</td>\n",
       "      <td>0.395</td>\n",
       "      <td>...</td>\n",
       "      <td>158</td>\n",
       "      <td>210</td>\n",
       "      <td>61</td>\n",
       "      <td>39</td>\n",
       "      <td>47</td>\n",
       "      <td>58</td>\n",
       "      <td>185</td>\n",
       "      <td>401</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Omer Asik</td>\n",
       "      <td>C</td>\n",
       "      <td>27</td>\n",
       "      <td>HOU</td>\n",
       "      <td>48</td>\n",
       "      <td>19</td>\n",
       "      <td>968</td>\n",
       "      <td>101</td>\n",
       "      <td>190</td>\n",
       "      <td>0.532</td>\n",
       "      <td>...</td>\n",
       "      <td>277</td>\n",
       "      <td>378</td>\n",
       "      <td>25</td>\n",
       "      <td>14</td>\n",
       "      <td>37</td>\n",
       "      <td>59</td>\n",
       "      <td>92</td>\n",
       "      <td>280</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>D.J. Augustin</td>\n",
       "      <td>PG</td>\n",
       "      <td>26</td>\n",
       "      <td>TOT</td>\n",
       "      <td>71</td>\n",
       "      <td>9</td>\n",
       "      <td>1939</td>\n",
       "      <td>298</td>\n",
       "      <td>718</td>\n",
       "      <td>0.415</td>\n",
       "      <td>...</td>\n",
       "      <td>115</td>\n",
       "      <td>130</td>\n",
       "      <td>313</td>\n",
       "      <td>53</td>\n",
       "      <td>3</td>\n",
       "      <td>125</td>\n",
       "      <td>147</td>\n",
       "      <td>930</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Gustavo Ayon</td>\n",
       "      <td>C</td>\n",
       "      <td>28</td>\n",
       "      <td>ATL</td>\n",
       "      <td>26</td>\n",
       "      <td>14</td>\n",
       "      <td>429</td>\n",
       "      <td>52</td>\n",
       "      <td>102</td>\n",
       "      <td>0.510</td>\n",
       "      <td>...</td>\n",
       "      <td>83</td>\n",
       "      <td>125</td>\n",
       "      <td>28</td>\n",
       "      <td>25</td>\n",
       "      <td>10</td>\n",
       "      <td>29</td>\n",
       "      <td>47</td>\n",
       "      <td>112</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Jeff Ayres</td>\n",
       "      <td>PF</td>\n",
       "      <td>26</td>\n",
       "      <td>SAS</td>\n",
       "      <td>73</td>\n",
       "      <td>10</td>\n",
       "      <td>952</td>\n",
       "      <td>101</td>\n",
       "      <td>174</td>\n",
       "      <td>0.580</td>\n",
       "      <td>...</td>\n",
       "      <td>169</td>\n",
       "      <td>258</td>\n",
       "      <td>60</td>\n",
       "      <td>13</td>\n",
       "      <td>25</td>\n",
       "      <td>63</td>\n",
       "      <td>146</td>\n",
       "      <td>240</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Chris Babb</td>\n",
       "      <td>SG</td>\n",
       "      <td>23</td>\n",
       "      <td>BOS</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>132</td>\n",
       "      <td>8</td>\n",
       "      <td>30</td>\n",
       "      <td>0.267</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>17</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>13</td>\n",
       "      <td>22</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Luke Babbitt</td>\n",
       "      <td>PF</td>\n",
       "      <td>24</td>\n",
       "      <td>NOP</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>473</td>\n",
       "      <td>60</td>\n",
       "      <td>154</td>\n",
       "      <td>0.390</td>\n",
       "      <td>...</td>\n",
       "      <td>70</td>\n",
       "      <td>88</td>\n",
       "      <td>29</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "      <td>52</td>\n",
       "      <td>170</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Leandro Barbosa</td>\n",
       "      <td>PG</td>\n",
       "      <td>31</td>\n",
       "      <td>PHO</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>368</td>\n",
       "      <td>56</td>\n",
       "      <td>131</td>\n",
       "      <td>0.427</td>\n",
       "      <td>...</td>\n",
       "      <td>32</td>\n",
       "      <td>37</td>\n",
       "      <td>32</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>150</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</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>451</th>\n",
       "      <td>John Wall</td>\n",
       "      <td>PG</td>\n",
       "      <td>23</td>\n",
       "      <td>WAS</td>\n",
       "      <td>82</td>\n",
       "      <td>82</td>\n",
       "      <td>2980</td>\n",
       "      <td>579</td>\n",
       "      <td>1337</td>\n",
       "      <td>0.433</td>\n",
       "      <td>...</td>\n",
       "      <td>295</td>\n",
       "      <td>333</td>\n",
       "      <td>721</td>\n",
       "      <td>149</td>\n",
       "      <td>40</td>\n",
       "      <td>295</td>\n",
       "      <td>219</td>\n",
       "      <td>1583</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>Gerald Wallace</td>\n",
       "      <td>SF</td>\n",
       "      <td>31</td>\n",
       "      <td>BOS</td>\n",
       "      <td>58</td>\n",
       "      <td>16</td>\n",
       "      <td>1416</td>\n",
       "      <td>116</td>\n",
       "      <td>230</td>\n",
       "      <td>0.504</td>\n",
       "      <td>...</td>\n",
       "      <td>176</td>\n",
       "      <td>212</td>\n",
       "      <td>143</td>\n",
       "      <td>73</td>\n",
       "      <td>14</td>\n",
       "      <td>97</td>\n",
       "      <td>79</td>\n",
       "      <td>298</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>Casper Ware</td>\n",
       "      <td>PG</td>\n",
       "      <td>24</td>\n",
       "      <td>PHI</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>116</td>\n",
       "      <td>18</td>\n",
       "      <td>42</td>\n",
       "      <td>0.429</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>48</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>C.J. Watson</td>\n",
       "      <td>PG</td>\n",
       "      <td>29</td>\n",
       "      <td>IND</td>\n",
       "      <td>63</td>\n",
       "      <td>5</td>\n",
       "      <td>1193</td>\n",
       "      <td>146</td>\n",
       "      <td>334</td>\n",
       "      <td>0.437</td>\n",
       "      <td>...</td>\n",
       "      <td>82</td>\n",
       "      <td>101</td>\n",
       "      <td>107</td>\n",
       "      <td>60</td>\n",
       "      <td>8</td>\n",
       "      <td>60</td>\n",
       "      <td>66</td>\n",
       "      <td>414</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>Earl Watson</td>\n",
       "      <td>PG</td>\n",
       "      <td>34</td>\n",
       "      <td>POR</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>161</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>0.273</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>28</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>33</td>\n",
       "      <td>12</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>Maalik Wayns</td>\n",
       "      <td>PG</td>\n",
       "      <td>22</td>\n",
       "      <td>LAC</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.500</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>Martell Webster</td>\n",
       "      <td>SF</td>\n",
       "      <td>27</td>\n",
       "      <td>WAS</td>\n",
       "      <td>78</td>\n",
       "      <td>13</td>\n",
       "      <td>2157</td>\n",
       "      <td>254</td>\n",
       "      <td>587</td>\n",
       "      <td>0.433</td>\n",
       "      <td>...</td>\n",
       "      <td>184</td>\n",
       "      <td>222</td>\n",
       "      <td>97</td>\n",
       "      <td>41</td>\n",
       "      <td>15</td>\n",
       "      <td>58</td>\n",
       "      <td>150</td>\n",
       "      <td>759</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>David West</td>\n",
       "      <td>PF</td>\n",
       "      <td>33</td>\n",
       "      <td>IND</td>\n",
       "      <td>80</td>\n",
       "      <td>80</td>\n",
       "      <td>2472</td>\n",
       "      <td>458</td>\n",
       "      <td>939</td>\n",
       "      <td>0.488</td>\n",
       "      <td>...</td>\n",
       "      <td>422</td>\n",
       "      <td>542</td>\n",
       "      <td>223</td>\n",
       "      <td>61</td>\n",
       "      <td>74</td>\n",
       "      <td>133</td>\n",
       "      <td>186</td>\n",
       "      <td>1118</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>Russell Westbrook</td>\n",
       "      <td>PG</td>\n",
       "      <td>25</td>\n",
       "      <td>OKC</td>\n",
       "      <td>46</td>\n",
       "      <td>46</td>\n",
       "      <td>1412</td>\n",
       "      <td>346</td>\n",
       "      <td>791</td>\n",
       "      <td>0.437</td>\n",
       "      <td>...</td>\n",
       "      <td>208</td>\n",
       "      <td>263</td>\n",
       "      <td>319</td>\n",
       "      <td>88</td>\n",
       "      <td>7</td>\n",
       "      <td>177</td>\n",
       "      <td>104</td>\n",
       "      <td>1002</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>D.J. White</td>\n",
       "      <td>PF</td>\n",
       "      <td>27</td>\n",
       "      <td>CHA</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>Royce White</td>\n",
       "      <td>PF</td>\n",
       "      <td>22</td>\n",
       "      <td>SAC</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>Deron Williams</td>\n",
       "      <td>PG</td>\n",
       "      <td>29</td>\n",
       "      <td>BRK</td>\n",
       "      <td>64</td>\n",
       "      <td>58</td>\n",
       "      <td>2059</td>\n",
       "      <td>322</td>\n",
       "      <td>716</td>\n",
       "      <td>0.450</td>\n",
       "      <td>...</td>\n",
       "      <td>153</td>\n",
       "      <td>168</td>\n",
       "      <td>392</td>\n",
       "      <td>93</td>\n",
       "      <td>13</td>\n",
       "      <td>143</td>\n",
       "      <td>148</td>\n",
       "      <td>915</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>Derrick Williams</td>\n",
       "      <td>SF</td>\n",
       "      <td>22</td>\n",
       "      <td>TOT</td>\n",
       "      <td>78</td>\n",
       "      <td>15</td>\n",
       "      <td>1820</td>\n",
       "      <td>206</td>\n",
       "      <td>482</td>\n",
       "      <td>0.427</td>\n",
       "      <td>...</td>\n",
       "      <td>252</td>\n",
       "      <td>323</td>\n",
       "      <td>56</td>\n",
       "      <td>48</td>\n",
       "      <td>20</td>\n",
       "      <td>76</td>\n",
       "      <td>114</td>\n",
       "      <td>624</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>Elliot Williams</td>\n",
       "      <td>SG</td>\n",
       "      <td>24</td>\n",
       "      <td>PHI</td>\n",
       "      <td>67</td>\n",
       "      <td>2</td>\n",
       "      <td>1157</td>\n",
       "      <td>140</td>\n",
       "      <td>337</td>\n",
       "      <td>0.415</td>\n",
       "      <td>...</td>\n",
       "      <td>100</td>\n",
       "      <td>130</td>\n",
       "      <td>72</td>\n",
       "      <td>35</td>\n",
       "      <td>3</td>\n",
       "      <td>68</td>\n",
       "      <td>126</td>\n",
       "      <td>404</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>Louis Williams</td>\n",
       "      <td>PG</td>\n",
       "      <td>27</td>\n",
       "      <td>ATL</td>\n",
       "      <td>60</td>\n",
       "      <td>7</td>\n",
       "      <td>1445</td>\n",
       "      <td>197</td>\n",
       "      <td>493</td>\n",
       "      <td>0.400</td>\n",
       "      <td>...</td>\n",
       "      <td>114</td>\n",
       "      <td>124</td>\n",
       "      <td>210</td>\n",
       "      <td>45</td>\n",
       "      <td>4</td>\n",
       "      <td>92</td>\n",
       "      <td>65</td>\n",
       "      <td>625</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>Marvin Williams</td>\n",
       "      <td>PF</td>\n",
       "      <td>27</td>\n",
       "      <td>UTA</td>\n",
       "      <td>66</td>\n",
       "      <td>50</td>\n",
       "      <td>1674</td>\n",
       "      <td>231</td>\n",
       "      <td>526</td>\n",
       "      <td>0.439</td>\n",
       "      <td>...</td>\n",
       "      <td>252</td>\n",
       "      <td>334</td>\n",
       "      <td>78</td>\n",
       "      <td>54</td>\n",
       "      <td>31</td>\n",
       "      <td>53</td>\n",
       "      <td>151</td>\n",
       "      <td>603</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>Mo Williams</td>\n",
       "      <td>PG</td>\n",
       "      <td>31</td>\n",
       "      <td>POR</td>\n",
       "      <td>74</td>\n",
       "      <td>0</td>\n",
       "      <td>1834</td>\n",
       "      <td>280</td>\n",
       "      <td>672</td>\n",
       "      <td>0.417</td>\n",
       "      <td>...</td>\n",
       "      <td>111</td>\n",
       "      <td>153</td>\n",
       "      <td>321</td>\n",
       "      <td>55</td>\n",
       "      <td>10</td>\n",
       "      <td>149</td>\n",
       "      <td>197</td>\n",
       "      <td>721</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>Reggie Williams</td>\n",
       "      <td>SF</td>\n",
       "      <td>27</td>\n",
       "      <td>OKC</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>0.556</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>Shawne Williams</td>\n",
       "      <td>PF</td>\n",
       "      <td>27</td>\n",
       "      <td>LAL</td>\n",
       "      <td>36</td>\n",
       "      <td>13</td>\n",
       "      <td>751</td>\n",
       "      <td>73</td>\n",
       "      <td>192</td>\n",
       "      <td>0.380</td>\n",
       "      <td>...</td>\n",
       "      <td>142</td>\n",
       "      <td>167</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>21</td>\n",
       "      <td>93</td>\n",
       "      <td>202</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>Jeff Withey</td>\n",
       "      <td>C</td>\n",
       "      <td>23</td>\n",
       "      <td>NOP</td>\n",
       "      <td>58</td>\n",
       "      <td>4</td>\n",
       "      <td>684</td>\n",
       "      <td>69</td>\n",
       "      <td>129</td>\n",
       "      <td>0.535</td>\n",
       "      <td>...</td>\n",
       "      <td>101</td>\n",
       "      <td>150</td>\n",
       "      <td>26</td>\n",
       "      <td>15</td>\n",
       "      <td>50</td>\n",
       "      <td>20</td>\n",
       "      <td>73</td>\n",
       "      <td>190</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>Nate Wolters</td>\n",
       "      <td>PG</td>\n",
       "      <td>22</td>\n",
       "      <td>MIL</td>\n",
       "      <td>58</td>\n",
       "      <td>31</td>\n",
       "      <td>1309</td>\n",
       "      <td>170</td>\n",
       "      <td>389</td>\n",
       "      <td>0.437</td>\n",
       "      <td>...</td>\n",
       "      <td>116</td>\n",
       "      <td>149</td>\n",
       "      <td>187</td>\n",
       "      <td>35</td>\n",
       "      <td>15</td>\n",
       "      <td>57</td>\n",
       "      <td>67</td>\n",
       "      <td>417</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>Metta World Peace</td>\n",
       "      <td>SF</td>\n",
       "      <td>34</td>\n",
       "      <td>NYK</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>388</td>\n",
       "      <td>56</td>\n",
       "      <td>141</td>\n",
       "      <td>0.397</td>\n",
       "      <td>...</td>\n",
       "      <td>41</td>\n",
       "      <td>59</td>\n",
       "      <td>17</td>\n",
       "      <td>24</td>\n",
       "      <td>8</td>\n",
       "      <td>19</td>\n",
       "      <td>44</td>\n",
       "      <td>139</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>Brandan Wright</td>\n",
       "      <td>C</td>\n",
       "      <td>26</td>\n",
       "      <td>DAL</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>1077</td>\n",
       "      <td>224</td>\n",
       "      <td>331</td>\n",
       "      <td>0.677</td>\n",
       "      <td>...</td>\n",
       "      <td>142</td>\n",
       "      <td>244</td>\n",
       "      <td>31</td>\n",
       "      <td>32</td>\n",
       "      <td>55</td>\n",
       "      <td>35</td>\n",
       "      <td>94</td>\n",
       "      <td>525</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>Chris Wright</td>\n",
       "      <td>SF</td>\n",
       "      <td>25</td>\n",
       "      <td>MIL</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>126</td>\n",
       "      <td>21</td>\n",
       "      <td>35</td>\n",
       "      <td>0.600</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>17</td>\n",
       "      <td>48</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>Dorell Wright</td>\n",
       "      <td>SF</td>\n",
       "      <td>28</td>\n",
       "      <td>POR</td>\n",
       "      <td>68</td>\n",
       "      <td>13</td>\n",
       "      <td>984</td>\n",
       "      <td>111</td>\n",
       "      <td>297</td>\n",
       "      <td>0.374</td>\n",
       "      <td>...</td>\n",
       "      <td>162</td>\n",
       "      <td>191</td>\n",
       "      <td>64</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>39</td>\n",
       "      <td>62</td>\n",
       "      <td>343</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>Tony Wroten</td>\n",
       "      <td>SG</td>\n",
       "      <td>20</td>\n",
       "      <td>PHI</td>\n",
       "      <td>72</td>\n",
       "      <td>16</td>\n",
       "      <td>1765</td>\n",
       "      <td>345</td>\n",
       "      <td>808</td>\n",
       "      <td>0.427</td>\n",
       "      <td>...</td>\n",
       "      <td>159</td>\n",
       "      <td>228</td>\n",
       "      <td>217</td>\n",
       "      <td>78</td>\n",
       "      <td>16</td>\n",
       "      <td>204</td>\n",
       "      <td>151</td>\n",
       "      <td>939</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>Nick Young</td>\n",
       "      <td>SG</td>\n",
       "      <td>28</td>\n",
       "      <td>LAL</td>\n",
       "      <td>64</td>\n",
       "      <td>9</td>\n",
       "      <td>1810</td>\n",
       "      <td>387</td>\n",
       "      <td>889</td>\n",
       "      <td>0.435</td>\n",
       "      <td>...</td>\n",
       "      <td>137</td>\n",
       "      <td>166</td>\n",
       "      <td>95</td>\n",
       "      <td>46</td>\n",
       "      <td>12</td>\n",
       "      <td>95</td>\n",
       "      <td>156</td>\n",
       "      <td>1144</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>Thaddeus Young</td>\n",
       "      <td>PF</td>\n",
       "      <td>25</td>\n",
       "      <td>PHI</td>\n",
       "      <td>79</td>\n",
       "      <td>78</td>\n",
       "      <td>2718</td>\n",
       "      <td>582</td>\n",
       "      <td>1283</td>\n",
       "      <td>0.454</td>\n",
       "      <td>...</td>\n",
       "      <td>310</td>\n",
       "      <td>476</td>\n",
       "      <td>182</td>\n",
       "      <td>167</td>\n",
       "      <td>36</td>\n",
       "      <td>165</td>\n",
       "      <td>213</td>\n",
       "      <td>1417</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>Cody Zeller</td>\n",
       "      <td>C</td>\n",
       "      <td>21</td>\n",
       "      <td>CHA</td>\n",
       "      <td>82</td>\n",
       "      <td>3</td>\n",
       "      <td>1416</td>\n",
       "      <td>172</td>\n",
       "      <td>404</td>\n",
       "      <td>0.426</td>\n",
       "      <td>...</td>\n",
       "      <td>235</td>\n",
       "      <td>353</td>\n",
       "      <td>92</td>\n",
       "      <td>40</td>\n",
       "      <td>41</td>\n",
       "      <td>87</td>\n",
       "      <td>170</td>\n",
       "      <td>490</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>Tyler Zeller</td>\n",
       "      <td>C</td>\n",
       "      <td>24</td>\n",
       "      <td>CLE</td>\n",
       "      <td>70</td>\n",
       "      <td>9</td>\n",
       "      <td>1049</td>\n",
       "      <td>156</td>\n",
       "      <td>290</td>\n",
       "      <td>0.538</td>\n",
       "      <td>...</td>\n",
       "      <td>179</td>\n",
       "      <td>282</td>\n",
       "      <td>36</td>\n",
       "      <td>18</td>\n",
       "      <td>38</td>\n",
       "      <td>60</td>\n",
       "      <td>137</td>\n",
       "      <td>399</td>\n",
       "      <td>2013-2014</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>481 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    player pos  age bref_team_id   g  gs    mp   fg   fga  \\\n",
       "0               Quincy Acy  SF   23          TOT  63   0   847   66   141   \n",
       "1             Steven Adams   C   20          OKC  81  20  1197   93   185   \n",
       "2              Jeff Adrien  PF   27          TOT  53  12   961  143   275   \n",
       "3            Arron Afflalo  SG   28          ORL  73  73  2552  464  1011   \n",
       "4            Alexis Ajinca   C   25          NOP  56  30   951  136   249   \n",
       "5             Cole Aldrich   C   25          NYK  46   2   330   33    61   \n",
       "6        LaMarcus Aldridge  PF   28          POR  69  69  2498  652  1423   \n",
       "7              Lavoy Allen  PF   24          TOT  65   2  1072  134   300   \n",
       "8                Ray Allen  SG   38          MIA  73   9  1936  240   543   \n",
       "9               Tony Allen  SG   32          MEM  55  28  1278  204   413   \n",
       "10         Al-Farouq Aminu  SF   23          NOP  80  65  2045  234   494   \n",
       "11          Louis Amundson  PF   31          TOT  19   0   185   16    32   \n",
       "12          Chris Andersen   C   35          MIA  72   0  1396  177   275   \n",
       "13           Alan Anderson  SF   31          BRK  78  26  1773  194   485   \n",
       "14          James Anderson  SG   24          PHI  80  62  2309  309   717   \n",
       "15           Ryan Anderson  PF   25          NOP  22  14   795  155   354   \n",
       "16   Giannis Antetokounmpo  SF   19          MIL  77  23  1897  173   418   \n",
       "17         Carmelo Anthony  PF   29          NYK  77  77  2982  743  1643   \n",
       "18            Joel Anthony   C   31          TOT  33   0   186   12    32   \n",
       "19              Pero Antic  PF   31          ATL  50  26   925  123   294   \n",
       "20            Trevor Ariza  SF   28          WAS  77  77  2723  389   853   \n",
       "21        Hilton Armstrong   C   29          GSW  15   1    97    9    19   \n",
       "22          Darrell Arthur  SF   25          DEN  68   1  1161  162   410   \n",
       "23               Omer Asik   C   27          HOU  48  19   968  101   190   \n",
       "24           D.J. Augustin  PG   26          TOT  71   9  1939  298   718   \n",
       "25            Gustavo Ayon   C   28          ATL  26  14   429   52   102   \n",
       "26              Jeff Ayres  PF   26          SAS  73  10   952  101   174   \n",
       "27              Chris Babb  SG   23          BOS  14   0   132    8    30   \n",
       "28            Luke Babbitt  PF   24          NOP  27   2   473   60   154   \n",
       "29         Leandro Barbosa  PG   31          PHO  20   0   368   56   131   \n",
       "..                     ...  ..  ...          ...  ..  ..   ...  ...   ...   \n",
       "451              John Wall  PG   23          WAS  82  82  2980  579  1337   \n",
       "452         Gerald Wallace  SF   31          BOS  58  16  1416  116   230   \n",
       "453            Casper Ware  PG   24          PHI   9   0   116   18    42   \n",
       "454            C.J. Watson  PG   29          IND  63   5  1193  146   334   \n",
       "455            Earl Watson  PG   34          POR  24   0   161    3    11   \n",
       "456           Maalik Wayns  PG   22          LAC   2   0     9    1     2   \n",
       "457        Martell Webster  SF   27          WAS  78  13  2157  254   587   \n",
       "458             David West  PF   33          IND  80  80  2472  458   939   \n",
       "459      Russell Westbrook  PG   25          OKC  46  46  1412  346   791   \n",
       "460             D.J. White  PF   27          CHA   2   0    10    0     1   \n",
       "461            Royce White  PF   22          SAC   3   0     9    0     1   \n",
       "462         Deron Williams  PG   29          BRK  64  58  2059  322   716   \n",
       "463       Derrick Williams  SF   22          TOT  78  15  1820  206   482   \n",
       "464        Elliot Williams  SG   24          PHI  67   2  1157  140   337   \n",
       "465         Louis Williams  PG   27          ATL  60   7  1445  197   493   \n",
       "466        Marvin Williams  PF   27          UTA  66  50  1674  231   526   \n",
       "467            Mo Williams  PG   31          POR  74   0  1834  280   672   \n",
       "468        Reggie Williams  SF   27          OKC   3   0    17    5     9   \n",
       "469        Shawne Williams  PF   27          LAL  36  13   751   73   192   \n",
       "470            Jeff Withey   C   23          NOP  58   4   684   69   129   \n",
       "471           Nate Wolters  PG   22          MIL  58  31  1309  170   389   \n",
       "472      Metta World Peace  SF   34          NYK  29   1   388   56   141   \n",
       "473         Brandan Wright   C   26          DAL  58   0  1077  224   331   \n",
       "474           Chris Wright  SF   25          MIL   8   0   126   21    35   \n",
       "475          Dorell Wright  SF   28          POR  68  13   984  111   297   \n",
       "476            Tony Wroten  SG   20          PHI  72  16  1765  345   808   \n",
       "477             Nick Young  SG   28          LAL  64   9  1810  387   889   \n",
       "478         Thaddeus Young  PF   25          PHI  79  78  2718  582  1283   \n",
       "479            Cody Zeller   C   21          CHA  82   3  1416  172   404   \n",
       "480           Tyler Zeller   C   24          CLE  70   9  1049  156   290   \n",
       "\n",
       "       fg.     ...      drb  trb  ast  stl  blk  tov   pf   pts     season  \\\n",
       "0    0.468     ...      144  216   28   23   26   30  122   171  2013-2014   \n",
       "1    0.503     ...      190  332   43   40   57   71  203   265  2013-2014   \n",
       "2    0.520     ...      204  306   38   24   36   39  108   362  2013-2014   \n",
       "3    0.459     ...      230  262  248   35    3  146  136  1330  2013-2014   \n",
       "4    0.546     ...      183  277   40   23   46   63  187   328  2013-2014   \n",
       "5    0.541     ...       92  129   14    8   30   18   40    92  2013-2014   \n",
       "6    0.458     ...      599  765  178   63   68  123  147  1603  2013-2014   \n",
       "7    0.447     ...      192  311   71   24   33   44  126   303  2013-2014   \n",
       "8    0.442     ...      182  205  143   54    8   84  115   701  2013-2014   \n",
       "9    0.494     ...      129  208   94   90   19   90  121   495  2013-2014   \n",
       "10   0.474     ...      367  496  114   82   38   88  147   572  2013-2014   \n",
       "11   0.500     ...       27   55    6    9   11   14   49    38  2013-2014   \n",
       "12   0.644     ...      250  379   19   32   97   53  162   477  2013-2014   \n",
       "13   0.400     ...      135  175   81   48   11   62  147   564  2013-2014   \n",
       "14   0.431     ...      241  300  149   74   28  106  154   810  2013-2014   \n",
       "15   0.438     ...       76  142   17   10    7   20   47   436  2013-2014   \n",
       "16   0.414     ...      261  339  150   60   61  122  173   525  2013-2014   \n",
       "17   0.452     ...      477  622  242   95   51  198  224  2112  2013-2014   \n",
       "18   0.375     ...       23   38    2    3   12    3   17    28  2013-2014   \n",
       "19   0.418     ...      152  209   58   19   12   55  126   352  2013-2014   \n",
       "20   0.456     ...      376  475  191  126   20  132  179  1107  2013-2014   \n",
       "21   0.474     ...       28   47    5    4    4    6   11    25  2013-2014   \n",
       "22   0.395     ...      158  210   61   39   47   58  185   401  2013-2014   \n",
       "23   0.532     ...      277  378   25   14   37   59   92   280  2013-2014   \n",
       "24   0.415     ...      115  130  313   53    3  125  147   930  2013-2014   \n",
       "25   0.510     ...       83  125   28   25   10   29   47   112  2013-2014   \n",
       "26   0.580     ...      169  258   60   13   25   63  146   240  2013-2014   \n",
       "27   0.267     ...       13   17    3    6    0    3   13    22  2013-2014   \n",
       "28   0.390     ...       70   88   29    7   11   15   52   170  2013-2014   \n",
       "29   0.427     ...       32   37   32    7    4   19   30   150  2013-2014   \n",
       "..     ...     ...      ...  ...  ...  ...  ...  ...  ...   ...        ...   \n",
       "451  0.433     ...      295  333  721  149   40  295  219  1583  2013-2014   \n",
       "452  0.504     ...      176  212  143   73   14   97   79   298  2013-2014   \n",
       "453  0.429     ...        9    9   10    8    0    5   11    48  2013-2014   \n",
       "454  0.437     ...       82  101  107   60    8   60   66   414  2013-2014   \n",
       "455  0.273     ...       10   15   28    5    1   17   33    12  2013-2014   \n",
       "456  0.500     ...        2    2    2    2    0    0    4     2  2013-2014   \n",
       "457  0.433     ...      184  222   97   41   15   58  150   759  2013-2014   \n",
       "458  0.488     ...      422  542  223   61   74  133  186  1118  2013-2014   \n",
       "459  0.437     ...      208  263  319   88    7  177  104  1002  2013-2014   \n",
       "460  0.000     ...        2    2    0    1    0    0    1     0  2013-2014   \n",
       "461  0.000     ...        0    0    0    0    0    0    2     0  2013-2014   \n",
       "462  0.450     ...      153  168  392   93   13  143  148   915  2013-2014   \n",
       "463  0.427     ...      252  323   56   48   20   76  114   624  2013-2014   \n",
       "464  0.415     ...      100  130   72   35    3   68  126   404  2013-2014   \n",
       "465  0.400     ...      114  124  210   45    4   92   65   625  2013-2014   \n",
       "466  0.439     ...      252  334   78   54   31   53  151   603  2013-2014   \n",
       "467  0.417     ...      111  153  321   55   10  149  197   721  2013-2014   \n",
       "468  0.556     ...        0    0    1    1    0    2    1    11  2013-2014   \n",
       "469  0.380     ...      142  167   30   19   30   21   93   202  2013-2014   \n",
       "470  0.535     ...      101  150   26   15   50   20   73   190  2013-2014   \n",
       "471  0.437     ...      116  149  187   35   15   57   67   417  2013-2014   \n",
       "472  0.397     ...       41   59   17   24    8   19   44   139  2013-2014   \n",
       "473  0.677     ...      142  244   31   32   55   35   94   525  2013-2014   \n",
       "474  0.600     ...       10   20    5    7    5    5   17    48  2013-2014   \n",
       "475  0.374     ...      162  191   64   23   16   39   62   343  2013-2014   \n",
       "476  0.427     ...      159  228  217   78   16  204  151   939  2013-2014   \n",
       "477  0.435     ...      137  166   95   46   12   95  156  1144  2013-2014   \n",
       "478  0.454     ...      310  476  182  167   36  165  213  1417  2013-2014   \n",
       "479  0.426     ...      235  353   92   40   41   87  170   490  2013-2014   \n",
       "480  0.538     ...      179  282   36   18   38   60  137   399  2013-2014   \n",
       "\n",
       "     season_end  \n",
       "0          2013  \n",
       "1          2013  \n",
       "2          2013  \n",
       "3          2013  \n",
       "4          2013  \n",
       "5          2013  \n",
       "6          2013  \n",
       "7          2013  \n",
       "8          2013  \n",
       "9          2013  \n",
       "10         2013  \n",
       "11         2013  \n",
       "12         2013  \n",
       "13         2013  \n",
       "14         2013  \n",
       "15         2013  \n",
       "16         2013  \n",
       "17         2013  \n",
       "18         2013  \n",
       "19         2013  \n",
       "20         2013  \n",
       "21         2013  \n",
       "22         2013  \n",
       "23         2013  \n",
       "24         2013  \n",
       "25         2013  \n",
       "26         2013  \n",
       "27         2013  \n",
       "28         2013  \n",
       "29         2013  \n",
       "..          ...  \n",
       "451        2013  \n",
       "452        2013  \n",
       "453        2013  \n",
       "454        2013  \n",
       "455        2013  \n",
       "456        2013  \n",
       "457        2013  \n",
       "458        2013  \n",
       "459        2013  \n",
       "460        2013  \n",
       "461        2013  \n",
       "462        2013  \n",
       "463        2013  \n",
       "464        2013  \n",
       "465        2013  \n",
       "466        2013  \n",
       "467        2013  \n",
       "468        2013  \n",
       "469        2013  \n",
       "470        2013  \n",
       "471        2013  \n",
       "472        2013  \n",
       "473        2013  \n",
       "474        2013  \n",
       "475        2013  \n",
       "476        2013  \n",
       "477        2013  \n",
       "478        2013  \n",
       "479        2013  \n",
       "480        2013  \n",
       "\n",
       "[481 rows x 31 columns]"
      ]
     },
     "execution_count": 410,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 411,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "player           object\n",
       "pos              object\n",
       "age               int64\n",
       "bref_team_id     object\n",
       "g                 int64\n",
       "gs                int64\n",
       "mp                int64\n",
       "fg                int64\n",
       "fga               int64\n",
       "fg.             float64\n",
       "x3p               int64\n",
       "x3pa              int64\n",
       "x3p.            float64\n",
       "x2p               int64\n",
       "x2pa              int64\n",
       "x2p.            float64\n",
       "efg.            float64\n",
       "ft                int64\n",
       "fta               int64\n",
       "ft.             float64\n",
       "orb               int64\n",
       "drb               int64\n",
       "trb               int64\n",
       "ast               int64\n",
       "stl               int64\n",
       "blk               int64\n",
       "tov               int64\n",
       "pf                int64\n",
       "pts               int64\n",
       "season           object\n",
       "season_end        int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 411,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 412,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "labels ['season'] not contained in axis",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-412-09576145c3d6>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      2\u001b[0m \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mselect_dtypes\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mexclude\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0;34m'object'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'season_end'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0maxis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'season'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0maxis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/usr/local/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36mdrop\u001b[0;34m(self, labels, axis, level, inplace, errors)\u001b[0m\n\u001b[1;32m   2159\u001b[0m                 \u001b[0mnew_axis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlabels\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0merrors\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2160\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2161\u001b[0;31m                 \u001b[0mnew_axis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlabels\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0merrors\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2162\u001b[0m             \u001b[0mdropped\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreindex\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m**\u001b[0m\u001b[0;34m{\u001b[0m\u001b[0maxis_name\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mnew_axis\u001b[0m\u001b[0;34m}\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2163\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python3.6/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mdrop\u001b[0;34m(self, labels, errors)\u001b[0m\n\u001b[1;32m   3622\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0merrors\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0;34m'ignore'\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3623\u001b[0m                 raise ValueError('labels %s not contained in axis' %\n\u001b[0;32m-> 3624\u001b[0;31m                                  labels[mask])\n\u001b[0m\u001b[1;32m   3625\u001b[0m             \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mindexer\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m~\u001b[0m\u001b[0mmask\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3626\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdelete\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mValueError\u001b[0m: labels ['season'] not contained in axis"
     ]
    }
   ],
   "source": [
    "# choosing only numeric columns\n",
    "df = df.select_dtypes(exclude = ['object'] )\n",
    "df = df.drop(['season_end'],axis = 1)\n",
    "df = df.drop(['season'],axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 413,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "age      0\n",
       "g        0\n",
       "gs       0\n",
       "mp       0\n",
       "fg       0\n",
       "fga      0\n",
       "fg.      2\n",
       "x3p      0\n",
       "x3pa     0\n",
       "x3p.    67\n",
       "x2p      0\n",
       "x2pa     0\n",
       "x2p.     3\n",
       "efg.     2\n",
       "ft       0\n",
       "fta      0\n",
       "ft.     20\n",
       "orb      0\n",
       "drb      0\n",
       "trb      0\n",
       "ast      0\n",
       "stl      0\n",
       "blk      0\n",
       "tov      0\n",
       "pf       0\n",
       "pts      0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 413,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# zero out missing values ONLY FOR DEMONSTRATION, IN REAL LIFE MUST BE IMPUTED\n",
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 414,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.fillna(0,inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 415,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "age     0\n",
       "g       0\n",
       "gs      0\n",
       "mp      0\n",
       "fg      0\n",
       "fga     0\n",
       "fg.     0\n",
       "x3p     0\n",
       "x3pa    0\n",
       "x3p.    0\n",
       "x2p     0\n",
       "x2pa    0\n",
       "x2p.    0\n",
       "efg.    0\n",
       "ft      0\n",
       "fta     0\n",
       "ft.     0\n",
       "orb     0\n",
       "drb     0\n",
       "trb     0\n",
       "ast     0\n",
       "stl     0\n",
       "blk     0\n",
       "tov     0\n",
       "pf      0\n",
       "pts     0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 415,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 416,
   "metadata": {},
   "outputs": [],
   "source": [
    "y = df['pts']\n",
    "x = df.drop(['pts'],axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Normalizing our Columns\n",
    "\n",
    "Since we are dealing with KNN, we have to care about scaling. Some columns are large in absolute terms, and thus may dwarf the impact of other columns in the euclidean distance calculations.\n",
    "\n",
    "This can be bad, because a variable having larger values doesn't necessarily make it better at predicting what rows are similar.\n",
    "\n",
    "A simple way to deal with this is to normalize all the columns to have a mean of 0, and a standard deviation of 1. This will ensure that no single column has a dominant impact on the euclidean distance calculations.\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 417,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "x = x.values #returns a numpy array\n",
    "\n",
    "# Create a minimum and maximum processor object\n",
    "min_max_scaler = preprocessing.MinMaxScaler()\n",
    "\n",
    "x_scaled = min_max_scaler.fit_transform(x)\n",
    "df = pd.DataFrame(x_scaled)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 418,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python3.6/site-packages/sklearn/utils/validation.py:429: DataConversionWarning: Data with input dtype int64 was converted to float64 by MinMaxScaler.\n",
      "  warnings.warn(msg, _DataConversionWarning)\n",
      "/usr/local/lib/python3.6/site-packages/sklearn/preprocessing/data.py:321: DeprecationWarning: Passing 1d arrays as data is deprecated in 0.17 and will raise ValueError in 0.19. Reshape your data either using X.reshape(-1, 1) if your data has a single feature or X.reshape(1, -1) if it contains a single sample.\n",
      "  warnings.warn(DEPRECATION_MSG_1D, DeprecationWarning)\n",
      "/usr/local/lib/python3.6/site-packages/sklearn/preprocessing/data.py:356: DeprecationWarning: Passing 1d arrays as data is deprecated in 0.17 and will raise ValueError in 0.19. Reshape your data either using X.reshape(-1, 1) if your data has a single feature or X.reshape(1, -1) if it contains a single sample.\n",
      "  warnings.warn(DEPRECATION_MSG_1D, DeprecationWarning)\n"
     ]
    }
   ],
   "source": [
    "y = y.values\n",
    "\n",
    "# Create a minimum and maximum processor object\n",
    "min_max_scaler = preprocessing.MinMaxScaler()\n",
    "\n",
    "x_scaled = min_max_scaler.fit_transform(y)\n",
    "df_y = pd.DataFrame(x_scaled)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 419,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>19</th>\n",
       "      <th>20</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.20</td>\n",
       "      <td>0.756098</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.271067</td>\n",
       "      <td>0.077739</td>\n",
       "      <td>0.083531</td>\n",
       "      <td>0.468</td>\n",
       "      <td>0.015326</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>...</td>\n",
       "      <td>0.065839</td>\n",
       "      <td>0.660</td>\n",
       "      <td>0.163636</td>\n",
       "      <td>0.183908</td>\n",
       "      <td>0.193896</td>\n",
       "      <td>0.038835</td>\n",
       "      <td>0.120419</td>\n",
       "      <td>0.118721</td>\n",
       "      <td>0.101695</td>\n",
       "      <td>0.446886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.05</td>\n",
       "      <td>0.975610</td>\n",
       "      <td>0.243902</td>\n",
       "      <td>0.383211</td>\n",
       "      <td>0.109541</td>\n",
       "      <td>0.109597</td>\n",
       "      <td>0.503</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.168944</td>\n",
       "      <td>0.581</td>\n",
       "      <td>0.322727</td>\n",
       "      <td>0.242656</td>\n",
       "      <td>0.298025</td>\n",
       "      <td>0.059639</td>\n",
       "      <td>0.209424</td>\n",
       "      <td>0.260274</td>\n",
       "      <td>0.240678</td>\n",
       "      <td>0.743590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.40</td>\n",
       "      <td>0.634146</td>\n",
       "      <td>0.146341</td>\n",
       "      <td>0.307594</td>\n",
       "      <td>0.168433</td>\n",
       "      <td>0.162915</td>\n",
       "      <td>0.520</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.147826</td>\n",
       "      <td>0.639</td>\n",
       "      <td>0.231818</td>\n",
       "      <td>0.260536</td>\n",
       "      <td>0.274686</td>\n",
       "      <td>0.052705</td>\n",
       "      <td>0.125654</td>\n",
       "      <td>0.164384</td>\n",
       "      <td>0.132203</td>\n",
       "      <td>0.395604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.45</td>\n",
       "      <td>0.878049</td>\n",
       "      <td>0.890244</td>\n",
       "      <td>0.817366</td>\n",
       "      <td>0.546525</td>\n",
       "      <td>0.598934</td>\n",
       "      <td>0.459</td>\n",
       "      <td>0.490421</td>\n",
       "      <td>0.487805</td>\n",
       "      <td>0.426667</td>\n",
       "      <td>...</td>\n",
       "      <td>0.417391</td>\n",
       "      <td>0.815</td>\n",
       "      <td>0.072727</td>\n",
       "      <td>0.293742</td>\n",
       "      <td>0.235189</td>\n",
       "      <td>0.343967</td>\n",
       "      <td>0.183246</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.494915</td>\n",
       "      <td>0.498168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.30</td>\n",
       "      <td>0.670732</td>\n",
       "      <td>0.365854</td>\n",
       "      <td>0.304390</td>\n",
       "      <td>0.160188</td>\n",
       "      <td>0.147512</td>\n",
       "      <td>0.546</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001626</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.083230</td>\n",
       "      <td>0.836</td>\n",
       "      <td>0.213636</td>\n",
       "      <td>0.233716</td>\n",
       "      <td>0.248654</td>\n",
       "      <td>0.055479</td>\n",
       "      <td>0.120419</td>\n",
       "      <td>0.210046</td>\n",
       "      <td>0.213559</td>\n",
       "      <td>0.684982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.30</td>\n",
       "      <td>0.548780</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.105415</td>\n",
       "      <td>0.038869</td>\n",
       "      <td>0.036137</td>\n",
       "      <td>0.541</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.037267</td>\n",
       "      <td>0.867</td>\n",
       "      <td>0.084091</td>\n",
       "      <td>0.117497</td>\n",
       "      <td>0.115799</td>\n",
       "      <td>0.019417</td>\n",
       "      <td>0.041885</td>\n",
       "      <td>0.136986</td>\n",
       "      <td>0.061017</td>\n",
       "      <td>0.146520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.45</td>\n",
       "      <td>0.829268</td>\n",
       "      <td>0.841463</td>\n",
       "      <td>0.800064</td>\n",
       "      <td>0.767962</td>\n",
       "      <td>0.843009</td>\n",
       "      <td>0.458</td>\n",
       "      <td>0.011494</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.447205</td>\n",
       "      <td>0.822</td>\n",
       "      <td>0.377273</td>\n",
       "      <td>0.765006</td>\n",
       "      <td>0.686715</td>\n",
       "      <td>0.246879</td>\n",
       "      <td>0.329843</td>\n",
       "      <td>0.310502</td>\n",
       "      <td>0.416949</td>\n",
       "      <td>0.538462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.25</td>\n",
       "      <td>0.780488</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.343159</td>\n",
       "      <td>0.157833</td>\n",
       "      <td>0.177725</td>\n",
       "      <td>0.447</td>\n",
       "      <td>0.007663</td>\n",
       "      <td>0.021138</td>\n",
       "      <td>0.153846</td>\n",
       "      <td>...</td>\n",
       "      <td>0.062112</td>\n",
       "      <td>0.660</td>\n",
       "      <td>0.270455</td>\n",
       "      <td>0.245211</td>\n",
       "      <td>0.279174</td>\n",
       "      <td>0.098474</td>\n",
       "      <td>0.125654</td>\n",
       "      <td>0.150685</td>\n",
       "      <td>0.149153</td>\n",
       "      <td>0.461538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.95</td>\n",
       "      <td>0.878049</td>\n",
       "      <td>0.109756</td>\n",
       "      <td>0.619994</td>\n",
       "      <td>0.282686</td>\n",
       "      <td>0.321682</td>\n",
       "      <td>0.442</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>0.502439</td>\n",
       "      <td>0.375405</td>\n",
       "      <td>...</td>\n",
       "      <td>0.144099</td>\n",
       "      <td>0.905</td>\n",
       "      <td>0.052273</td>\n",
       "      <td>0.232439</td>\n",
       "      <td>0.184022</td>\n",
       "      <td>0.198336</td>\n",
       "      <td>0.282723</td>\n",
       "      <td>0.036530</td>\n",
       "      <td>0.284746</td>\n",
       "      <td>0.421245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.65</td>\n",
       "      <td>0.658537</td>\n",
       "      <td>0.341463</td>\n",
       "      <td>0.409164</td>\n",
       "      <td>0.240283</td>\n",
       "      <td>0.244668</td>\n",
       "      <td>0.494</td>\n",
       "      <td>0.042146</td>\n",
       "      <td>0.076423</td>\n",
       "      <td>0.234043</td>\n",
       "      <td>...</td>\n",
       "      <td>0.150311</td>\n",
       "      <td>0.628</td>\n",
       "      <td>0.179545</td>\n",
       "      <td>0.164751</td>\n",
       "      <td>0.186715</td>\n",
       "      <td>0.130374</td>\n",
       "      <td>0.471204</td>\n",
       "      <td>0.086758</td>\n",
       "      <td>0.305085</td>\n",
       "      <td>0.443223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.20</td>\n",
       "      <td>0.963415</td>\n",
       "      <td>0.792683</td>\n",
       "      <td>0.654918</td>\n",
       "      <td>0.275618</td>\n",
       "      <td>0.292654</td>\n",
       "      <td>0.474</td>\n",
       "      <td>0.049808</td>\n",
       "      <td>0.078049</td>\n",
       "      <td>0.270833</td>\n",
       "      <td>...</td>\n",
       "      <td>0.170186</td>\n",
       "      <td>0.664</td>\n",
       "      <td>0.293182</td>\n",
       "      <td>0.468710</td>\n",
       "      <td>0.445242</td>\n",
       "      <td>0.158114</td>\n",
       "      <td>0.429319</td>\n",
       "      <td>0.173516</td>\n",
       "      <td>0.298305</td>\n",
       "      <td>0.538462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.60</td>\n",
       "      <td>0.219512</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.058955</td>\n",
       "      <td>0.018846</td>\n",
       "      <td>0.018957</td>\n",
       "      <td>0.500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.029814</td>\n",
       "      <td>0.250</td>\n",
       "      <td>0.063636</td>\n",
       "      <td>0.034483</td>\n",
       "      <td>0.049372</td>\n",
       "      <td>0.008322</td>\n",
       "      <td>0.047120</td>\n",
       "      <td>0.050228</td>\n",
       "      <td>0.047458</td>\n",
       "      <td>0.179487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.80</td>\n",
       "      <td>0.865854</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.446972</td>\n",
       "      <td>0.208481</td>\n",
       "      <td>0.162915</td>\n",
       "      <td>0.644</td>\n",
       "      <td>0.011494</td>\n",
       "      <td>0.019512</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.209938</td>\n",
       "      <td>0.710</td>\n",
       "      <td>0.293182</td>\n",
       "      <td>0.319285</td>\n",
       "      <td>0.340215</td>\n",
       "      <td>0.026352</td>\n",
       "      <td>0.167539</td>\n",
       "      <td>0.442922</td>\n",
       "      <td>0.179661</td>\n",
       "      <td>0.593407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.60</td>\n",
       "      <td>0.939024</td>\n",
       "      <td>0.317073</td>\n",
       "      <td>0.567767</td>\n",
       "      <td>0.228504</td>\n",
       "      <td>0.287322</td>\n",
       "      <td>0.400</td>\n",
       "      <td>0.321839</td>\n",
       "      <td>0.403252</td>\n",
       "      <td>0.338710</td>\n",
       "      <td>...</td>\n",
       "      <td>0.146584</td>\n",
       "      <td>0.780</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.172414</td>\n",
       "      <td>0.157092</td>\n",
       "      <td>0.112344</td>\n",
       "      <td>0.251309</td>\n",
       "      <td>0.050228</td>\n",
       "      <td>0.210169</td>\n",
       "      <td>0.538462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.25</td>\n",
       "      <td>0.963415</td>\n",
       "      <td>0.756098</td>\n",
       "      <td>0.739507</td>\n",
       "      <td>0.363958</td>\n",
       "      <td>0.424763</td>\n",
       "      <td>0.431</td>\n",
       "      <td>0.440613</td>\n",
       "      <td>0.570732</td>\n",
       "      <td>0.327635</td>\n",
       "      <td>...</td>\n",
       "      <td>0.131677</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.134091</td>\n",
       "      <td>0.307791</td>\n",
       "      <td>0.269300</td>\n",
       "      <td>0.206657</td>\n",
       "      <td>0.387435</td>\n",
       "      <td>0.127854</td>\n",
       "      <td>0.359322</td>\n",
       "      <td>0.564103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.30</td>\n",
       "      <td>0.256098</td>\n",
       "      <td>0.170732</td>\n",
       "      <td>0.254406</td>\n",
       "      <td>0.182568</td>\n",
       "      <td>0.209716</td>\n",
       "      <td>0.438</td>\n",
       "      <td>0.256705</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>0.408537</td>\n",
       "      <td>...</td>\n",
       "      <td>0.077019</td>\n",
       "      <td>0.952</td>\n",
       "      <td>0.150000</td>\n",
       "      <td>0.097063</td>\n",
       "      <td>0.127469</td>\n",
       "      <td>0.023578</td>\n",
       "      <td>0.052356</td>\n",
       "      <td>0.031963</td>\n",
       "      <td>0.067797</td>\n",
       "      <td>0.172161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.926829</td>\n",
       "      <td>0.280488</td>\n",
       "      <td>0.607498</td>\n",
       "      <td>0.203769</td>\n",
       "      <td>0.247630</td>\n",
       "      <td>0.414</td>\n",
       "      <td>0.157088</td>\n",
       "      <td>0.191870</td>\n",
       "      <td>0.347458</td>\n",
       "      <td>...</td>\n",
       "      <td>0.250932</td>\n",
       "      <td>0.683</td>\n",
       "      <td>0.177273</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.304309</td>\n",
       "      <td>0.208044</td>\n",
       "      <td>0.314136</td>\n",
       "      <td>0.278539</td>\n",
       "      <td>0.413559</td>\n",
       "      <td>0.633700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.50</td>\n",
       "      <td>0.926829</td>\n",
       "      <td>0.939024</td>\n",
       "      <td>0.955143</td>\n",
       "      <td>0.875147</td>\n",
       "      <td>0.973341</td>\n",
       "      <td>0.452</td>\n",
       "      <td>0.639847</td>\n",
       "      <td>0.674797</td>\n",
       "      <td>0.402410</td>\n",
       "      <td>...</td>\n",
       "      <td>0.672050</td>\n",
       "      <td>0.848</td>\n",
       "      <td>0.329545</td>\n",
       "      <td>0.609195</td>\n",
       "      <td>0.558348</td>\n",
       "      <td>0.335645</td>\n",
       "      <td>0.497382</td>\n",
       "      <td>0.232877</td>\n",
       "      <td>0.671186</td>\n",
       "      <td>0.820513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.60</td>\n",
       "      <td>0.390244</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.059276</td>\n",
       "      <td>0.014134</td>\n",
       "      <td>0.018957</td>\n",
       "      <td>0.375</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.009938</td>\n",
       "      <td>0.500</td>\n",
       "      <td>0.034091</td>\n",
       "      <td>0.029374</td>\n",
       "      <td>0.034111</td>\n",
       "      <td>0.002774</td>\n",
       "      <td>0.015707</td>\n",
       "      <td>0.054795</td>\n",
       "      <td>0.010169</td>\n",
       "      <td>0.062271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.60</td>\n",
       "      <td>0.597561</td>\n",
       "      <td>0.317073</td>\n",
       "      <td>0.296059</td>\n",
       "      <td>0.144876</td>\n",
       "      <td>0.174171</td>\n",
       "      <td>0.418</td>\n",
       "      <td>0.214559</td>\n",
       "      <td>0.278049</td>\n",
       "      <td>0.327485</td>\n",
       "      <td>...</td>\n",
       "      <td>0.081988</td>\n",
       "      <td>0.758</td>\n",
       "      <td>0.129545</td>\n",
       "      <td>0.194125</td>\n",
       "      <td>0.187612</td>\n",
       "      <td>0.080444</td>\n",
       "      <td>0.099476</td>\n",
       "      <td>0.054795</td>\n",
       "      <td>0.186441</td>\n",
       "      <td>0.461538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0.45</td>\n",
       "      <td>0.926829</td>\n",
       "      <td>0.939024</td>\n",
       "      <td>0.872156</td>\n",
       "      <td>0.458186</td>\n",
       "      <td>0.505332</td>\n",
       "      <td>0.456</td>\n",
       "      <td>0.689655</td>\n",
       "      <td>0.718699</td>\n",
       "      <td>0.407240</td>\n",
       "      <td>...</td>\n",
       "      <td>0.239752</td>\n",
       "      <td>0.772</td>\n",
       "      <td>0.225000</td>\n",
       "      <td>0.480204</td>\n",
       "      <td>0.426391</td>\n",
       "      <td>0.264910</td>\n",
       "      <td>0.659686</td>\n",
       "      <td>0.091324</td>\n",
       "      <td>0.447458</td>\n",
       "      <td>0.655678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.50</td>\n",
       "      <td>0.170732</td>\n",
       "      <td>0.012195</td>\n",
       "      <td>0.030759</td>\n",
       "      <td>0.010601</td>\n",
       "      <td>0.011256</td>\n",
       "      <td>0.474</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.019876</td>\n",
       "      <td>0.438</td>\n",
       "      <td>0.043182</td>\n",
       "      <td>0.035760</td>\n",
       "      <td>0.042190</td>\n",
       "      <td>0.006935</td>\n",
       "      <td>0.020942</td>\n",
       "      <td>0.018265</td>\n",
       "      <td>0.020339</td>\n",
       "      <td>0.040293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.30</td>\n",
       "      <td>0.817073</td>\n",
       "      <td>0.012195</td>\n",
       "      <td>0.371676</td>\n",
       "      <td>0.190813</td>\n",
       "      <td>0.242891</td>\n",
       "      <td>0.395</td>\n",
       "      <td>0.091954</td>\n",
       "      <td>0.104065</td>\n",
       "      <td>0.375000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.077019</td>\n",
       "      <td>0.855</td>\n",
       "      <td>0.118182</td>\n",
       "      <td>0.201788</td>\n",
       "      <td>0.188510</td>\n",
       "      <td>0.084605</td>\n",
       "      <td>0.204188</td>\n",
       "      <td>0.214612</td>\n",
       "      <td>0.196610</td>\n",
       "      <td>0.677656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.40</td>\n",
       "      <td>0.573171</td>\n",
       "      <td>0.231707</td>\n",
       "      <td>0.309837</td>\n",
       "      <td>0.118963</td>\n",
       "      <td>0.112559</td>\n",
       "      <td>0.532</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.156522</td>\n",
       "      <td>0.619</td>\n",
       "      <td>0.229545</td>\n",
       "      <td>0.353768</td>\n",
       "      <td>0.339318</td>\n",
       "      <td>0.034674</td>\n",
       "      <td>0.073298</td>\n",
       "      <td>0.168950</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.336996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.35</td>\n",
       "      <td>0.853659</td>\n",
       "      <td>0.109756</td>\n",
       "      <td>0.620955</td>\n",
       "      <td>0.351001</td>\n",
       "      <td>0.425355</td>\n",
       "      <td>0.415</td>\n",
       "      <td>0.509579</td>\n",
       "      <td>0.539837</td>\n",
       "      <td>0.400602</td>\n",
       "      <td>...</td>\n",
       "      <td>0.281988</td>\n",
       "      <td>0.885</td>\n",
       "      <td>0.034091</td>\n",
       "      <td>0.146871</td>\n",
       "      <td>0.116697</td>\n",
       "      <td>0.434119</td>\n",
       "      <td>0.277487</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.423729</td>\n",
       "      <td>0.538462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0.45</td>\n",
       "      <td>0.304878</td>\n",
       "      <td>0.170732</td>\n",
       "      <td>0.137136</td>\n",
       "      <td>0.061249</td>\n",
       "      <td>0.060427</td>\n",
       "      <td>0.510</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.024845</td>\n",
       "      <td>0.400</td>\n",
       "      <td>0.095455</td>\n",
       "      <td>0.106003</td>\n",
       "      <td>0.112208</td>\n",
       "      <td>0.038835</td>\n",
       "      <td>0.130890</td>\n",
       "      <td>0.045662</td>\n",
       "      <td>0.098305</td>\n",
       "      <td>0.172161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0.35</td>\n",
       "      <td>0.878049</td>\n",
       "      <td>0.121951</td>\n",
       "      <td>0.304710</td>\n",
       "      <td>0.118963</td>\n",
       "      <td>0.103081</td>\n",
       "      <td>0.580</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.068323</td>\n",
       "      <td>0.691</td>\n",
       "      <td>0.202273</td>\n",
       "      <td>0.215837</td>\n",
       "      <td>0.231598</td>\n",
       "      <td>0.083218</td>\n",
       "      <td>0.068063</td>\n",
       "      <td>0.114155</td>\n",
       "      <td>0.213559</td>\n",
       "      <td>0.534799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.20</td>\n",
       "      <td>0.158537</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.041974</td>\n",
       "      <td>0.009423</td>\n",
       "      <td>0.017773</td>\n",
       "      <td>0.267</td>\n",
       "      <td>0.022989</td>\n",
       "      <td>0.043902</td>\n",
       "      <td>0.222222</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.009091</td>\n",
       "      <td>0.016603</td>\n",
       "      <td>0.015260</td>\n",
       "      <td>0.004161</td>\n",
       "      <td>0.031414</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010169</td>\n",
       "      <td>0.047619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.25</td>\n",
       "      <td>0.317073</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.151234</td>\n",
       "      <td>0.070671</td>\n",
       "      <td>0.091232</td>\n",
       "      <td>0.390</td>\n",
       "      <td>0.137931</td>\n",
       "      <td>0.154472</td>\n",
       "      <td>0.378947</td>\n",
       "      <td>...</td>\n",
       "      <td>0.022360</td>\n",
       "      <td>0.778</td>\n",
       "      <td>0.040909</td>\n",
       "      <td>0.089400</td>\n",
       "      <td>0.078995</td>\n",
       "      <td>0.040222</td>\n",
       "      <td>0.036649</td>\n",
       "      <td>0.050228</td>\n",
       "      <td>0.050847</td>\n",
       "      <td>0.190476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.60</td>\n",
       "      <td>0.231707</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.117591</td>\n",
       "      <td>0.065960</td>\n",
       "      <td>0.077607</td>\n",
       "      <td>0.427</td>\n",
       "      <td>0.026820</td>\n",
       "      <td>0.040650</td>\n",
       "      <td>0.280000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.048447</td>\n",
       "      <td>0.795</td>\n",
       "      <td>0.011364</td>\n",
       "      <td>0.040868</td>\n",
       "      <td>0.033214</td>\n",
       "      <td>0.044383</td>\n",
       "      <td>0.036649</td>\n",
       "      <td>0.018265</td>\n",
       "      <td>0.064407</td>\n",
       "      <td>0.109890</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>451</th>\n",
       "      <td>0.20</td>\n",
       "      <td>0.987805</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.954502</td>\n",
       "      <td>0.681979</td>\n",
       "      <td>0.792062</td>\n",
       "      <td>0.433</td>\n",
       "      <td>0.413793</td>\n",
       "      <td>0.500813</td>\n",
       "      <td>0.350649</td>\n",
       "      <td>...</td>\n",
       "      <td>0.489441</td>\n",
       "      <td>0.805</td>\n",
       "      <td>0.086364</td>\n",
       "      <td>0.376756</td>\n",
       "      <td>0.298923</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.780105</td>\n",
       "      <td>0.182648</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.802198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>0.60</td>\n",
       "      <td>0.695122</td>\n",
       "      <td>0.195122</td>\n",
       "      <td>0.453380</td>\n",
       "      <td>0.136631</td>\n",
       "      <td>0.136256</td>\n",
       "      <td>0.504</td>\n",
       "      <td>0.072797</td>\n",
       "      <td>0.104065</td>\n",
       "      <td>0.296875</td>\n",
       "      <td>...</td>\n",
       "      <td>0.125466</td>\n",
       "      <td>0.465</td>\n",
       "      <td>0.081818</td>\n",
       "      <td>0.224777</td>\n",
       "      <td>0.190305</td>\n",
       "      <td>0.198336</td>\n",
       "      <td>0.382199</td>\n",
       "      <td>0.063927</td>\n",
       "      <td>0.328814</td>\n",
       "      <td>0.289377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>0.25</td>\n",
       "      <td>0.097561</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.036847</td>\n",
       "      <td>0.021201</td>\n",
       "      <td>0.024882</td>\n",
       "      <td>0.429</td>\n",
       "      <td>0.026820</td>\n",
       "      <td>0.034146</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>...</td>\n",
       "      <td>0.007453</td>\n",
       "      <td>0.833</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.011494</td>\n",
       "      <td>0.008079</td>\n",
       "      <td>0.013870</td>\n",
       "      <td>0.041885</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.016949</td>\n",
       "      <td>0.040293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>0.50</td>\n",
       "      <td>0.756098</td>\n",
       "      <td>0.060976</td>\n",
       "      <td>0.381929</td>\n",
       "      <td>0.171967</td>\n",
       "      <td>0.197867</td>\n",
       "      <td>0.437</td>\n",
       "      <td>0.203065</td>\n",
       "      <td>0.235772</td>\n",
       "      <td>0.365517</td>\n",
       "      <td>...</td>\n",
       "      <td>0.109317</td>\n",
       "      <td>0.784</td>\n",
       "      <td>0.043182</td>\n",
       "      <td>0.104725</td>\n",
       "      <td>0.090664</td>\n",
       "      <td>0.148405</td>\n",
       "      <td>0.314136</td>\n",
       "      <td>0.036530</td>\n",
       "      <td>0.203390</td>\n",
       "      <td>0.241758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>0.75</td>\n",
       "      <td>0.280488</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.051266</td>\n",
       "      <td>0.003534</td>\n",
       "      <td>0.006517</td>\n",
       "      <td>0.273</td>\n",
       "      <td>0.007663</td>\n",
       "      <td>0.011382</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004969</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.011364</td>\n",
       "      <td>0.012771</td>\n",
       "      <td>0.013465</td>\n",
       "      <td>0.038835</td>\n",
       "      <td>0.026178</td>\n",
       "      <td>0.004566</td>\n",
       "      <td>0.057627</td>\n",
       "      <td>0.120879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>0.15</td>\n",
       "      <td>0.012195</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002563</td>\n",
       "      <td>0.001178</td>\n",
       "      <td>0.001185</td>\n",
       "      <td>0.500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002554</td>\n",
       "      <td>0.001795</td>\n",
       "      <td>0.002774</td>\n",
       "      <td>0.010471</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.014652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>0.40</td>\n",
       "      <td>0.939024</td>\n",
       "      <td>0.158537</td>\n",
       "      <td>0.690804</td>\n",
       "      <td>0.299176</td>\n",
       "      <td>0.347749</td>\n",
       "      <td>0.433</td>\n",
       "      <td>0.559387</td>\n",
       "      <td>0.604878</td>\n",
       "      <td>0.392473</td>\n",
       "      <td>...</td>\n",
       "      <td>0.155280</td>\n",
       "      <td>0.840</td>\n",
       "      <td>0.086364</td>\n",
       "      <td>0.234994</td>\n",
       "      <td>0.199282</td>\n",
       "      <td>0.134535</td>\n",
       "      <td>0.214660</td>\n",
       "      <td>0.068493</td>\n",
       "      <td>0.196610</td>\n",
       "      <td>0.549451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>0.70</td>\n",
       "      <td>0.963415</td>\n",
       "      <td>0.975610</td>\n",
       "      <td>0.791733</td>\n",
       "      <td>0.539458</td>\n",
       "      <td>0.556280</td>\n",
       "      <td>0.488</td>\n",
       "      <td>0.015326</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>...</td>\n",
       "      <td>0.311801</td>\n",
       "      <td>0.789</td>\n",
       "      <td>0.272727</td>\n",
       "      <td>0.538953</td>\n",
       "      <td>0.486535</td>\n",
       "      <td>0.309293</td>\n",
       "      <td>0.319372</td>\n",
       "      <td>0.337900</td>\n",
       "      <td>0.450847</td>\n",
       "      <td>0.681319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>0.30</td>\n",
       "      <td>0.548780</td>\n",
       "      <td>0.560976</td>\n",
       "      <td>0.452099</td>\n",
       "      <td>0.407538</td>\n",
       "      <td>0.468602</td>\n",
       "      <td>0.437</td>\n",
       "      <td>0.260536</td>\n",
       "      <td>0.347967</td>\n",
       "      <td>0.317757</td>\n",
       "      <td>...</td>\n",
       "      <td>0.363975</td>\n",
       "      <td>0.826</td>\n",
       "      <td>0.125000</td>\n",
       "      <td>0.265645</td>\n",
       "      <td>0.236086</td>\n",
       "      <td>0.442441</td>\n",
       "      <td>0.460733</td>\n",
       "      <td>0.031963</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.380952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>0.40</td>\n",
       "      <td>0.012195</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002884</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000592</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002554</td>\n",
       "      <td>0.001795</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.005236</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.003663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>0.15</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002563</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000592</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.007326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>0.50</td>\n",
       "      <td>0.768293</td>\n",
       "      <td>0.707317</td>\n",
       "      <td>0.659404</td>\n",
       "      <td>0.379270</td>\n",
       "      <td>0.424171</td>\n",
       "      <td>0.450</td>\n",
       "      <td>0.375479</td>\n",
       "      <td>0.435772</td>\n",
       "      <td>0.365672</td>\n",
       "      <td>...</td>\n",
       "      <td>0.268323</td>\n",
       "      <td>0.801</td>\n",
       "      <td>0.034091</td>\n",
       "      <td>0.195402</td>\n",
       "      <td>0.150808</td>\n",
       "      <td>0.543689</td>\n",
       "      <td>0.486911</td>\n",
       "      <td>0.059361</td>\n",
       "      <td>0.484746</td>\n",
       "      <td>0.542125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>0.15</td>\n",
       "      <td>0.939024</td>\n",
       "      <td>0.182927</td>\n",
       "      <td>0.582826</td>\n",
       "      <td>0.242638</td>\n",
       "      <td>0.285545</td>\n",
       "      <td>0.427</td>\n",
       "      <td>0.099617</td>\n",
       "      <td>0.160976</td>\n",
       "      <td>0.262626</td>\n",
       "      <td>...</td>\n",
       "      <td>0.321739</td>\n",
       "      <td>0.718</td>\n",
       "      <td>0.161364</td>\n",
       "      <td>0.321839</td>\n",
       "      <td>0.289946</td>\n",
       "      <td>0.077670</td>\n",
       "      <td>0.251309</td>\n",
       "      <td>0.091324</td>\n",
       "      <td>0.257627</td>\n",
       "      <td>0.417582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>0.25</td>\n",
       "      <td>0.804878</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.370394</td>\n",
       "      <td>0.164900</td>\n",
       "      <td>0.199645</td>\n",
       "      <td>0.415</td>\n",
       "      <td>0.141762</td>\n",
       "      <td>0.203252</td>\n",
       "      <td>0.296000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.147826</td>\n",
       "      <td>0.731</td>\n",
       "      <td>0.068182</td>\n",
       "      <td>0.127714</td>\n",
       "      <td>0.116697</td>\n",
       "      <td>0.099861</td>\n",
       "      <td>0.183246</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.230508</td>\n",
       "      <td>0.461538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>0.40</td>\n",
       "      <td>0.719512</td>\n",
       "      <td>0.085366</td>\n",
       "      <td>0.462672</td>\n",
       "      <td>0.232038</td>\n",
       "      <td>0.292062</td>\n",
       "      <td>0.400</td>\n",
       "      <td>0.302682</td>\n",
       "      <td>0.375610</td>\n",
       "      <td>0.341991</td>\n",
       "      <td>...</td>\n",
       "      <td>0.222360</td>\n",
       "      <td>0.849</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.145594</td>\n",
       "      <td>0.111311</td>\n",
       "      <td>0.291262</td>\n",
       "      <td>0.235602</td>\n",
       "      <td>0.018265</td>\n",
       "      <td>0.311864</td>\n",
       "      <td>0.238095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>0.40</td>\n",
       "      <td>0.792683</td>\n",
       "      <td>0.609756</td>\n",
       "      <td>0.536046</td>\n",
       "      <td>0.272085</td>\n",
       "      <td>0.311611</td>\n",
       "      <td>0.439</td>\n",
       "      <td>0.321839</td>\n",
       "      <td>0.380488</td>\n",
       "      <td>0.358974</td>\n",
       "      <td>...</td>\n",
       "      <td>0.090683</td>\n",
       "      <td>0.781</td>\n",
       "      <td>0.186364</td>\n",
       "      <td>0.321839</td>\n",
       "      <td>0.299820</td>\n",
       "      <td>0.108183</td>\n",
       "      <td>0.282723</td>\n",
       "      <td>0.141553</td>\n",
       "      <td>0.179661</td>\n",
       "      <td>0.553114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>0.60</td>\n",
       "      <td>0.890244</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.587312</td>\n",
       "      <td>0.329800</td>\n",
       "      <td>0.398104</td>\n",
       "      <td>0.417</td>\n",
       "      <td>0.318008</td>\n",
       "      <td>0.365854</td>\n",
       "      <td>0.368889</td>\n",
       "      <td>...</td>\n",
       "      <td>0.110559</td>\n",
       "      <td>0.876</td>\n",
       "      <td>0.095455</td>\n",
       "      <td>0.141762</td>\n",
       "      <td>0.137343</td>\n",
       "      <td>0.445215</td>\n",
       "      <td>0.287958</td>\n",
       "      <td>0.045662</td>\n",
       "      <td>0.505085</td>\n",
       "      <td>0.721612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>0.40</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.005127</td>\n",
       "      <td>0.005889</td>\n",
       "      <td>0.005332</td>\n",
       "      <td>0.556</td>\n",
       "      <td>0.003831</td>\n",
       "      <td>0.004878</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001387</td>\n",
       "      <td>0.005236</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.006780</td>\n",
       "      <td>0.003663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>0.40</td>\n",
       "      <td>0.426829</td>\n",
       "      <td>0.158537</td>\n",
       "      <td>0.240308</td>\n",
       "      <td>0.085984</td>\n",
       "      <td>0.113744</td>\n",
       "      <td>0.380</td>\n",
       "      <td>0.160920</td>\n",
       "      <td>0.209756</td>\n",
       "      <td>0.325581</td>\n",
       "      <td>...</td>\n",
       "      <td>0.024845</td>\n",
       "      <td>0.700</td>\n",
       "      <td>0.056818</td>\n",
       "      <td>0.181354</td>\n",
       "      <td>0.149910</td>\n",
       "      <td>0.041609</td>\n",
       "      <td>0.099476</td>\n",
       "      <td>0.136986</td>\n",
       "      <td>0.071186</td>\n",
       "      <td>0.340659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>0.20</td>\n",
       "      <td>0.695122</td>\n",
       "      <td>0.048780</td>\n",
       "      <td>0.218840</td>\n",
       "      <td>0.081272</td>\n",
       "      <td>0.076422</td>\n",
       "      <td>0.535</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001626</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.090683</td>\n",
       "      <td>0.712</td>\n",
       "      <td>0.111364</td>\n",
       "      <td>0.128991</td>\n",
       "      <td>0.134650</td>\n",
       "      <td>0.036061</td>\n",
       "      <td>0.078534</td>\n",
       "      <td>0.228311</td>\n",
       "      <td>0.067797</td>\n",
       "      <td>0.267399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>0.15</td>\n",
       "      <td>0.695122</td>\n",
       "      <td>0.378049</td>\n",
       "      <td>0.419096</td>\n",
       "      <td>0.200236</td>\n",
       "      <td>0.230450</td>\n",
       "      <td>0.437</td>\n",
       "      <td>0.068966</td>\n",
       "      <td>0.100813</td>\n",
       "      <td>0.290323</td>\n",
       "      <td>...</td>\n",
       "      <td>0.111801</td>\n",
       "      <td>0.656</td>\n",
       "      <td>0.075000</td>\n",
       "      <td>0.148148</td>\n",
       "      <td>0.133752</td>\n",
       "      <td>0.259362</td>\n",
       "      <td>0.183246</td>\n",
       "      <td>0.068493</td>\n",
       "      <td>0.193220</td>\n",
       "      <td>0.245421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>0.75</td>\n",
       "      <td>0.341463</td>\n",
       "      <td>0.012195</td>\n",
       "      <td>0.123999</td>\n",
       "      <td>0.065960</td>\n",
       "      <td>0.083531</td>\n",
       "      <td>0.397</td>\n",
       "      <td>0.065134</td>\n",
       "      <td>0.087805</td>\n",
       "      <td>0.314815</td>\n",
       "      <td>...</td>\n",
       "      <td>0.019876</td>\n",
       "      <td>0.625</td>\n",
       "      <td>0.040909</td>\n",
       "      <td>0.052363</td>\n",
       "      <td>0.052962</td>\n",
       "      <td>0.023578</td>\n",
       "      <td>0.125654</td>\n",
       "      <td>0.036530</td>\n",
       "      <td>0.064407</td>\n",
       "      <td>0.161172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>0.35</td>\n",
       "      <td>0.695122</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.344761</td>\n",
       "      <td>0.263840</td>\n",
       "      <td>0.196090</td>\n",
       "      <td>0.677</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.131677</td>\n",
       "      <td>0.726</td>\n",
       "      <td>0.231818</td>\n",
       "      <td>0.181354</td>\n",
       "      <td>0.219031</td>\n",
       "      <td>0.042996</td>\n",
       "      <td>0.167539</td>\n",
       "      <td>0.251142</td>\n",
       "      <td>0.118644</td>\n",
       "      <td>0.344322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>0.30</td>\n",
       "      <td>0.085366</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.040051</td>\n",
       "      <td>0.024735</td>\n",
       "      <td>0.020735</td>\n",
       "      <td>0.600</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001626</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.018634</td>\n",
       "      <td>0.400</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.012771</td>\n",
       "      <td>0.017953</td>\n",
       "      <td>0.006935</td>\n",
       "      <td>0.036649</td>\n",
       "      <td>0.022831</td>\n",
       "      <td>0.016949</td>\n",
       "      <td>0.062271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>0.45</td>\n",
       "      <td>0.817073</td>\n",
       "      <td>0.158537</td>\n",
       "      <td>0.314963</td>\n",
       "      <td>0.130742</td>\n",
       "      <td>0.175948</td>\n",
       "      <td>0.374</td>\n",
       "      <td>0.264368</td>\n",
       "      <td>0.328455</td>\n",
       "      <td>0.341584</td>\n",
       "      <td>...</td>\n",
       "      <td>0.085714</td>\n",
       "      <td>0.754</td>\n",
       "      <td>0.065909</td>\n",
       "      <td>0.206897</td>\n",
       "      <td>0.171454</td>\n",
       "      <td>0.088766</td>\n",
       "      <td>0.120419</td>\n",
       "      <td>0.073059</td>\n",
       "      <td>0.132203</td>\n",
       "      <td>0.227106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>0.05</td>\n",
       "      <td>0.865854</td>\n",
       "      <td>0.195122</td>\n",
       "      <td>0.565203</td>\n",
       "      <td>0.406360</td>\n",
       "      <td>0.478673</td>\n",
       "      <td>0.427</td>\n",
       "      <td>0.153257</td>\n",
       "      <td>0.305691</td>\n",
       "      <td>0.212766</td>\n",
       "      <td>...</td>\n",
       "      <td>0.404969</td>\n",
       "      <td>0.641</td>\n",
       "      <td>0.156818</td>\n",
       "      <td>0.203065</td>\n",
       "      <td>0.204668</td>\n",
       "      <td>0.300971</td>\n",
       "      <td>0.408377</td>\n",
       "      <td>0.073059</td>\n",
       "      <td>0.691525</td>\n",
       "      <td>0.553114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>0.45</td>\n",
       "      <td>0.768293</td>\n",
       "      <td>0.109756</td>\n",
       "      <td>0.579622</td>\n",
       "      <td>0.455830</td>\n",
       "      <td>0.526659</td>\n",
       "      <td>0.435</td>\n",
       "      <td>0.517241</td>\n",
       "      <td>0.569106</td>\n",
       "      <td>0.385714</td>\n",
       "      <td>...</td>\n",
       "      <td>0.354037</td>\n",
       "      <td>0.825</td>\n",
       "      <td>0.065909</td>\n",
       "      <td>0.174968</td>\n",
       "      <td>0.149013</td>\n",
       "      <td>0.131761</td>\n",
       "      <td>0.240838</td>\n",
       "      <td>0.054795</td>\n",
       "      <td>0.322034</td>\n",
       "      <td>0.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>0.30</td>\n",
       "      <td>0.951220</td>\n",
       "      <td>0.951220</td>\n",
       "      <td>0.870554</td>\n",
       "      <td>0.685512</td>\n",
       "      <td>0.760071</td>\n",
       "      <td>0.454</td>\n",
       "      <td>0.344828</td>\n",
       "      <td>0.474797</td>\n",
       "      <td>0.308219</td>\n",
       "      <td>...</td>\n",
       "      <td>0.284472</td>\n",
       "      <td>0.712</td>\n",
       "      <td>0.377273</td>\n",
       "      <td>0.395913</td>\n",
       "      <td>0.427289</td>\n",
       "      <td>0.252427</td>\n",
       "      <td>0.874346</td>\n",
       "      <td>0.164384</td>\n",
       "      <td>0.559322</td>\n",
       "      <td>0.780220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>0.10</td>\n",
       "      <td>0.987805</td>\n",
       "      <td>0.036585</td>\n",
       "      <td>0.453380</td>\n",
       "      <td>0.202591</td>\n",
       "      <td>0.239336</td>\n",
       "      <td>0.426</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001626</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.248447</td>\n",
       "      <td>0.730</td>\n",
       "      <td>0.268182</td>\n",
       "      <td>0.300128</td>\n",
       "      <td>0.316876</td>\n",
       "      <td>0.127601</td>\n",
       "      <td>0.209424</td>\n",
       "      <td>0.187215</td>\n",
       "      <td>0.294915</td>\n",
       "      <td>0.622711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>0.25</td>\n",
       "      <td>0.841463</td>\n",
       "      <td>0.109756</td>\n",
       "      <td>0.335790</td>\n",
       "      <td>0.183746</td>\n",
       "      <td>0.171801</td>\n",
       "      <td>0.538</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001626</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.150311</td>\n",
       "      <td>0.719</td>\n",
       "      <td>0.234091</td>\n",
       "      <td>0.228608</td>\n",
       "      <td>0.253142</td>\n",
       "      <td>0.049931</td>\n",
       "      <td>0.094241</td>\n",
       "      <td>0.173516</td>\n",
       "      <td>0.203390</td>\n",
       "      <td>0.501832</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>481 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       0         1         2         3         4         5      6         7   \\\n",
       "0    0.20  0.756098  0.000000  0.271067  0.077739  0.083531  0.468  0.015326   \n",
       "1    0.05  0.975610  0.243902  0.383211  0.109541  0.109597  0.503  0.000000   \n",
       "2    0.40  0.634146  0.146341  0.307594  0.168433  0.162915  0.520  0.000000   \n",
       "3    0.45  0.878049  0.890244  0.817366  0.546525  0.598934  0.459  0.490421   \n",
       "4    0.30  0.670732  0.365854  0.304390  0.160188  0.147512  0.546  0.000000   \n",
       "5    0.30  0.548780  0.024390  0.105415  0.038869  0.036137  0.541  0.000000   \n",
       "6    0.45  0.829268  0.841463  0.800064  0.767962  0.843009  0.458  0.011494   \n",
       "7    0.25  0.780488  0.024390  0.343159  0.157833  0.177725  0.447  0.007663   \n",
       "8    0.95  0.878049  0.109756  0.619994  0.282686  0.321682  0.442  0.444444   \n",
       "9    0.65  0.658537  0.341463  0.409164  0.240283  0.244668  0.494  0.042146   \n",
       "10   0.20  0.963415  0.792683  0.654918  0.275618  0.292654  0.474  0.049808   \n",
       "11   0.60  0.219512  0.000000  0.058955  0.018846  0.018957  0.500  0.000000   \n",
       "12   0.80  0.865854  0.000000  0.446972  0.208481  0.162915  0.644  0.011494   \n",
       "13   0.60  0.939024  0.317073  0.567767  0.228504  0.287322  0.400  0.321839   \n",
       "14   0.25  0.963415  0.756098  0.739507  0.363958  0.424763  0.431  0.440613   \n",
       "15   0.30  0.256098  0.170732  0.254406  0.182568  0.209716  0.438  0.256705   \n",
       "16   0.00  0.926829  0.280488  0.607498  0.203769  0.247630  0.414  0.157088   \n",
       "17   0.50  0.926829  0.939024  0.955143  0.875147  0.973341  0.452  0.639847   \n",
       "18   0.60  0.390244  0.000000  0.059276  0.014134  0.018957  0.375  0.000000   \n",
       "19   0.60  0.597561  0.317073  0.296059  0.144876  0.174171  0.418  0.214559   \n",
       "20   0.45  0.926829  0.939024  0.872156  0.458186  0.505332  0.456  0.689655   \n",
       "21   0.50  0.170732  0.012195  0.030759  0.010601  0.011256  0.474  0.000000   \n",
       "22   0.30  0.817073  0.012195  0.371676  0.190813  0.242891  0.395  0.091954   \n",
       "23   0.40  0.573171  0.231707  0.309837  0.118963  0.112559  0.532  0.000000   \n",
       "24   0.35  0.853659  0.109756  0.620955  0.351001  0.425355  0.415  0.509579   \n",
       "25   0.45  0.304878  0.170732  0.137136  0.061249  0.060427  0.510  0.000000   \n",
       "26   0.35  0.878049  0.121951  0.304710  0.118963  0.103081  0.580  0.000000   \n",
       "27   0.20  0.158537  0.000000  0.041974  0.009423  0.017773  0.267  0.022989   \n",
       "28   0.25  0.317073  0.024390  0.151234  0.070671  0.091232  0.390  0.137931   \n",
       "29   0.60  0.231707  0.000000  0.117591  0.065960  0.077607  0.427  0.026820   \n",
       "..    ...       ...       ...       ...       ...       ...    ...       ...   \n",
       "451  0.20  0.987805  1.000000  0.954502  0.681979  0.792062  0.433  0.413793   \n",
       "452  0.60  0.695122  0.195122  0.453380  0.136631  0.136256  0.504  0.072797   \n",
       "453  0.25  0.097561  0.000000  0.036847  0.021201  0.024882  0.429  0.026820   \n",
       "454  0.50  0.756098  0.060976  0.381929  0.171967  0.197867  0.437  0.203065   \n",
       "455  0.75  0.280488  0.000000  0.051266  0.003534  0.006517  0.273  0.007663   \n",
       "456  0.15  0.012195  0.000000  0.002563  0.001178  0.001185  0.500  0.000000   \n",
       "457  0.40  0.939024  0.158537  0.690804  0.299176  0.347749  0.433  0.559387   \n",
       "458  0.70  0.963415  0.975610  0.791733  0.539458  0.556280  0.488  0.015326   \n",
       "459  0.30  0.548780  0.560976  0.452099  0.407538  0.468602  0.437  0.260536   \n",
       "460  0.40  0.012195  0.000000  0.002884  0.000000  0.000592  0.000  0.000000   \n",
       "461  0.15  0.024390  0.000000  0.002563  0.000000  0.000592  0.000  0.000000   \n",
       "462  0.50  0.768293  0.707317  0.659404  0.379270  0.424171  0.450  0.375479   \n",
       "463  0.15  0.939024  0.182927  0.582826  0.242638  0.285545  0.427  0.099617   \n",
       "464  0.25  0.804878  0.024390  0.370394  0.164900  0.199645  0.415  0.141762   \n",
       "465  0.40  0.719512  0.085366  0.462672  0.232038  0.292062  0.400  0.302682   \n",
       "466  0.40  0.792683  0.609756  0.536046  0.272085  0.311611  0.439  0.321839   \n",
       "467  0.60  0.890244  0.000000  0.587312  0.329800  0.398104  0.417  0.318008   \n",
       "468  0.40  0.024390  0.000000  0.005127  0.005889  0.005332  0.556  0.003831   \n",
       "469  0.40  0.426829  0.158537  0.240308  0.085984  0.113744  0.380  0.160920   \n",
       "470  0.20  0.695122  0.048780  0.218840  0.081272  0.076422  0.535  0.000000   \n",
       "471  0.15  0.695122  0.378049  0.419096  0.200236  0.230450  0.437  0.068966   \n",
       "472  0.75  0.341463  0.012195  0.123999  0.065960  0.083531  0.397  0.065134   \n",
       "473  0.35  0.695122  0.000000  0.344761  0.263840  0.196090  0.677  0.000000   \n",
       "474  0.30  0.085366  0.000000  0.040051  0.024735  0.020735  0.600  0.000000   \n",
       "475  0.45  0.817073  0.158537  0.314963  0.130742  0.175948  0.374  0.264368   \n",
       "476  0.05  0.865854  0.195122  0.565203  0.406360  0.478673  0.427  0.153257   \n",
       "477  0.45  0.768293  0.109756  0.579622  0.455830  0.526659  0.435  0.517241   \n",
       "478  0.30  0.951220  0.951220  0.870554  0.685512  0.760071  0.454  0.344828   \n",
       "479  0.10  0.987805  0.036585  0.453380  0.202591  0.239336  0.426  0.000000   \n",
       "480  0.25  0.841463  0.109756  0.335790  0.183746  0.171801  0.538  0.000000   \n",
       "\n",
       "           8         9     ...           15     16        17        18  \\\n",
       "0    0.024390  0.266667    ...     0.065839  0.660  0.163636  0.183908   \n",
       "1    0.000000  0.000000    ...     0.168944  0.581  0.322727  0.242656   \n",
       "2    0.000000  0.000000    ...     0.147826  0.639  0.231818  0.260536   \n",
       "3    0.487805  0.426667    ...     0.417391  0.815  0.072727  0.293742   \n",
       "4    0.001626  0.000000    ...     0.083230  0.836  0.213636  0.233716   \n",
       "5    0.000000  0.000000    ...     0.037267  0.867  0.084091  0.117497   \n",
       "6    0.024390  0.200000    ...     0.447205  0.822  0.377273  0.765006   \n",
       "7    0.021138  0.153846    ...     0.062112  0.660  0.270455  0.245211   \n",
       "8    0.502439  0.375405    ...     0.144099  0.905  0.052273  0.232439   \n",
       "9    0.076423  0.234043    ...     0.150311  0.628  0.179545  0.164751   \n",
       "10   0.078049  0.270833    ...     0.170186  0.664  0.293182  0.468710   \n",
       "11   0.000000  0.000000    ...     0.029814  0.250  0.063636  0.034483   \n",
       "12   0.019512  0.250000    ...     0.209938  0.710  0.293182  0.319285   \n",
       "13   0.403252  0.338710    ...     0.146584  0.780  0.090909  0.172414   \n",
       "14   0.570732  0.327635    ...     0.131677  0.726  0.134091  0.307791   \n",
       "15   0.266667  0.408537    ...     0.077019  0.952  0.150000  0.097063   \n",
       "16   0.191870  0.347458    ...     0.250932  0.683  0.177273  0.333333   \n",
       "17   0.674797  0.402410    ...     0.672050  0.848  0.329545  0.609195   \n",
       "18   0.000000  0.000000    ...     0.009938  0.500  0.034091  0.029374   \n",
       "19   0.278049  0.327485    ...     0.081988  0.758  0.129545  0.194125   \n",
       "20   0.718699  0.407240    ...     0.239752  0.772  0.225000  0.480204   \n",
       "21   0.000000  0.000000    ...     0.019876  0.438  0.043182  0.035760   \n",
       "22   0.104065  0.375000    ...     0.077019  0.855  0.118182  0.201788   \n",
       "23   0.000000  0.000000    ...     0.156522  0.619  0.229545  0.353768   \n",
       "24   0.539837  0.400602    ...     0.281988  0.885  0.034091  0.146871   \n",
       "25   0.000000  0.000000    ...     0.024845  0.400  0.095455  0.106003   \n",
       "26   0.000000  0.000000    ...     0.068323  0.691  0.202273  0.215837   \n",
       "27   0.043902  0.222222    ...     0.000000  0.000  0.009091  0.016603   \n",
       "28   0.154472  0.378947    ...     0.022360  0.778  0.040909  0.089400   \n",
       "29   0.040650  0.280000    ...     0.048447  0.795  0.011364  0.040868   \n",
       "..        ...       ...    ...          ...    ...       ...       ...   \n",
       "451  0.500813  0.350649    ...     0.489441  0.805  0.086364  0.376756   \n",
       "452  0.104065  0.296875    ...     0.125466  0.465  0.081818  0.224777   \n",
       "453  0.034146  0.333333    ...     0.007453  0.833  0.000000  0.011494   \n",
       "454  0.235772  0.365517    ...     0.109317  0.784  0.043182  0.104725   \n",
       "455  0.011382  0.285714    ...     0.004969  1.000  0.011364  0.012771   \n",
       "456  0.000000  0.000000    ...     0.000000  0.000  0.000000  0.002554   \n",
       "457  0.604878  0.392473    ...     0.155280  0.840  0.086364  0.234994   \n",
       "458  0.024390  0.266667    ...     0.311801  0.789  0.272727  0.538953   \n",
       "459  0.347967  0.317757    ...     0.363975  0.826  0.125000  0.265645   \n",
       "460  0.000000  0.000000    ...     0.000000  0.000  0.000000  0.002554   \n",
       "461  0.000000  0.000000    ...     0.000000  0.000  0.000000  0.000000   \n",
       "462  0.435772  0.365672    ...     0.268323  0.801  0.034091  0.195402   \n",
       "463  0.160976  0.262626    ...     0.321739  0.718  0.161364  0.321839   \n",
       "464  0.203252  0.296000    ...     0.147826  0.731  0.068182  0.127714   \n",
       "465  0.375610  0.341991    ...     0.222360  0.849  0.022727  0.145594   \n",
       "466  0.380488  0.358974    ...     0.090683  0.781  0.186364  0.321839   \n",
       "467  0.365854  0.368889    ...     0.110559  0.876  0.095455  0.141762   \n",
       "468  0.004878  0.333333    ...     0.000000  0.000  0.000000  0.000000   \n",
       "469  0.209756  0.325581    ...     0.024845  0.700  0.056818  0.181354   \n",
       "470  0.001626  0.000000    ...     0.090683  0.712  0.111364  0.128991   \n",
       "471  0.100813  0.290323    ...     0.111801  0.656  0.075000  0.148148   \n",
       "472  0.087805  0.314815    ...     0.019876  0.625  0.040909  0.052363   \n",
       "473  0.000000  0.000000    ...     0.131677  0.726  0.231818  0.181354   \n",
       "474  0.001626  0.000000    ...     0.018634  0.400  0.022727  0.012771   \n",
       "475  0.328455  0.341584    ...     0.085714  0.754  0.065909  0.206897   \n",
       "476  0.305691  0.212766    ...     0.404969  0.641  0.156818  0.203065   \n",
       "477  0.569106  0.385714    ...     0.354037  0.825  0.065909  0.174968   \n",
       "478  0.474797  0.308219    ...     0.284472  0.712  0.377273  0.395913   \n",
       "479  0.001626  0.000000    ...     0.248447  0.730  0.268182  0.300128   \n",
       "480  0.001626  0.000000    ...     0.150311  0.719  0.234091  0.228608   \n",
       "\n",
       "           19        20        21        22        23        24  \n",
       "0    0.193896  0.038835  0.120419  0.118721  0.101695  0.446886  \n",
       "1    0.298025  0.059639  0.209424  0.260274  0.240678  0.743590  \n",
       "2    0.274686  0.052705  0.125654  0.164384  0.132203  0.395604  \n",
       "3    0.235189  0.343967  0.183246  0.013699  0.494915  0.498168  \n",
       "4    0.248654  0.055479  0.120419  0.210046  0.213559  0.684982  \n",
       "5    0.115799  0.019417  0.041885  0.136986  0.061017  0.146520  \n",
       "6    0.686715  0.246879  0.329843  0.310502  0.416949  0.538462  \n",
       "7    0.279174  0.098474  0.125654  0.150685  0.149153  0.461538  \n",
       "8    0.184022  0.198336  0.282723  0.036530  0.284746  0.421245  \n",
       "9    0.186715  0.130374  0.471204  0.086758  0.305085  0.443223  \n",
       "10   0.445242  0.158114  0.429319  0.173516  0.298305  0.538462  \n",
       "11   0.049372  0.008322  0.047120  0.050228  0.047458  0.179487  \n",
       "12   0.340215  0.026352  0.167539  0.442922  0.179661  0.593407  \n",
       "13   0.157092  0.112344  0.251309  0.050228  0.210169  0.538462  \n",
       "14   0.269300  0.206657  0.387435  0.127854  0.359322  0.564103  \n",
       "15   0.127469  0.023578  0.052356  0.031963  0.067797  0.172161  \n",
       "16   0.304309  0.208044  0.314136  0.278539  0.413559  0.633700  \n",
       "17   0.558348  0.335645  0.497382  0.232877  0.671186  0.820513  \n",
       "18   0.034111  0.002774  0.015707  0.054795  0.010169  0.062271  \n",
       "19   0.187612  0.080444  0.099476  0.054795  0.186441  0.461538  \n",
       "20   0.426391  0.264910  0.659686  0.091324  0.447458  0.655678  \n",
       "21   0.042190  0.006935  0.020942  0.018265  0.020339  0.040293  \n",
       "22   0.188510  0.084605  0.204188  0.214612  0.196610  0.677656  \n",
       "23   0.339318  0.034674  0.073298  0.168950  0.200000  0.336996  \n",
       "24   0.116697  0.434119  0.277487  0.013699  0.423729  0.538462  \n",
       "25   0.112208  0.038835  0.130890  0.045662  0.098305  0.172161  \n",
       "26   0.231598  0.083218  0.068063  0.114155  0.213559  0.534799  \n",
       "27   0.015260  0.004161  0.031414  0.000000  0.010169  0.047619  \n",
       "28   0.078995  0.040222  0.036649  0.050228  0.050847  0.190476  \n",
       "29   0.033214  0.044383  0.036649  0.018265  0.064407  0.109890  \n",
       "..        ...       ...       ...       ...       ...       ...  \n",
       "451  0.298923  1.000000  0.780105  0.182648  1.000000  0.802198  \n",
       "452  0.190305  0.198336  0.382199  0.063927  0.328814  0.289377  \n",
       "453  0.008079  0.013870  0.041885  0.000000  0.016949  0.040293  \n",
       "454  0.090664  0.148405  0.314136  0.036530  0.203390  0.241758  \n",
       "455  0.013465  0.038835  0.026178  0.004566  0.057627  0.120879  \n",
       "456  0.001795  0.002774  0.010471  0.000000  0.000000  0.014652  \n",
       "457  0.199282  0.134535  0.214660  0.068493  0.196610  0.549451  \n",
       "458  0.486535  0.309293  0.319372  0.337900  0.450847  0.681319  \n",
       "459  0.236086  0.442441  0.460733  0.031963  0.600000  0.380952  \n",
       "460  0.001795  0.000000  0.005236  0.000000  0.000000  0.003663  \n",
       "461  0.000000  0.000000  0.000000  0.000000  0.000000  0.007326  \n",
       "462  0.150808  0.543689  0.486911  0.059361  0.484746  0.542125  \n",
       "463  0.289946  0.077670  0.251309  0.091324  0.257627  0.417582  \n",
       "464  0.116697  0.099861  0.183246  0.013699  0.230508  0.461538  \n",
       "465  0.111311  0.291262  0.235602  0.018265  0.311864  0.238095  \n",
       "466  0.299820  0.108183  0.282723  0.141553  0.179661  0.553114  \n",
       "467  0.137343  0.445215  0.287958  0.045662  0.505085  0.721612  \n",
       "468  0.000000  0.001387  0.005236  0.000000  0.006780  0.003663  \n",
       "469  0.149910  0.041609  0.099476  0.136986  0.071186  0.340659  \n",
       "470  0.134650  0.036061  0.078534  0.228311  0.067797  0.267399  \n",
       "471  0.133752  0.259362  0.183246  0.068493  0.193220  0.245421  \n",
       "472  0.052962  0.023578  0.125654  0.036530  0.064407  0.161172  \n",
       "473  0.219031  0.042996  0.167539  0.251142  0.118644  0.344322  \n",
       "474  0.017953  0.006935  0.036649  0.022831  0.016949  0.062271  \n",
       "475  0.171454  0.088766  0.120419  0.073059  0.132203  0.227106  \n",
       "476  0.204668  0.300971  0.408377  0.073059  0.691525  0.553114  \n",
       "477  0.149013  0.131761  0.240838  0.054795  0.322034  0.571429  \n",
       "478  0.427289  0.252427  0.874346  0.164384  0.559322  0.780220  \n",
       "479  0.316876  0.127601  0.209424  0.187215  0.294915  0.622711  \n",
       "480  0.253142  0.049931  0.094241  0.173516  0.203390  0.501832  \n",
       "\n",
       "[481 rows x 25 columns]"
      ]
     },
     "execution_count": 419,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 420,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>19</th>\n",
       "      <th>20</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "      <td>481.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.375468</td>\n",
       "      <td>0.637239</td>\n",
       "      <td>0.311850</td>\n",
       "      <td>0.396151</td>\n",
       "      <td>0.227187</td>\n",
       "      <td>0.251459</td>\n",
       "      <td>0.434622</td>\n",
       "      <td>0.151775</td>\n",
       "      <td>0.179075</td>\n",
       "      <td>0.245397</td>\n",
       "      <td>...</td>\n",
       "      <td>0.149866</td>\n",
       "      <td>0.692380</td>\n",
       "      <td>0.126843</td>\n",
       "      <td>0.207940</td>\n",
       "      <td>0.196255</td>\n",
       "      <td>0.156084</td>\n",
       "      <td>0.205658</td>\n",
       "      <td>0.110064</td>\n",
       "      <td>0.243603</td>\n",
       "      <td>0.387799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.209913</td>\n",
       "      <td>0.308814</td>\n",
       "      <td>0.361689</td>\n",
       "      <td>0.287491</td>\n",
       "      <td>0.202394</td>\n",
       "      <td>0.218514</td>\n",
       "      <td>0.102401</td>\n",
       "      <td>0.194849</td>\n",
       "      <td>0.215856</td>\n",
       "      <td>0.176482</td>\n",
       "      <td>...</td>\n",
       "      <td>0.163032</td>\n",
       "      <td>0.213133</td>\n",
       "      <td>0.141139</td>\n",
       "      <td>0.185630</td>\n",
       "      <td>0.179853</td>\n",
       "      <td>0.181719</td>\n",
       "      <td>0.182113</td>\n",
       "      <td>0.140983</td>\n",
       "      <td>0.212548</td>\n",
       "      <td>0.260856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.378049</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.123999</td>\n",
       "      <td>0.055359</td>\n",
       "      <td>0.065166</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.004878</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.027329</td>\n",
       "      <td>0.640000</td>\n",
       "      <td>0.027273</td>\n",
       "      <td>0.054917</td>\n",
       "      <td>0.049372</td>\n",
       "      <td>0.027739</td>\n",
       "      <td>0.047120</td>\n",
       "      <td>0.018265</td>\n",
       "      <td>0.071186</td>\n",
       "      <td>0.161172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.350000</td>\n",
       "      <td>0.731707</td>\n",
       "      <td>0.121951</td>\n",
       "      <td>0.365268</td>\n",
       "      <td>0.171967</td>\n",
       "      <td>0.196682</td>\n",
       "      <td>0.437000</td>\n",
       "      <td>0.061303</td>\n",
       "      <td>0.078049</td>\n",
       "      <td>0.314607</td>\n",
       "      <td>...</td>\n",
       "      <td>0.090683</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.079545</td>\n",
       "      <td>0.172414</td>\n",
       "      <td>0.150808</td>\n",
       "      <td>0.090153</td>\n",
       "      <td>0.167539</td>\n",
       "      <td>0.063927</td>\n",
       "      <td>0.196610</td>\n",
       "      <td>0.380952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.914634</td>\n",
       "      <td>0.658537</td>\n",
       "      <td>0.645626</td>\n",
       "      <td>0.361602</td>\n",
       "      <td>0.398104</td>\n",
       "      <td>0.479000</td>\n",
       "      <td>0.260536</td>\n",
       "      <td>0.313821</td>\n",
       "      <td>0.366460</td>\n",
       "      <td>...</td>\n",
       "      <td>0.222360</td>\n",
       "      <td>0.816000</td>\n",
       "      <td>0.165909</td>\n",
       "      <td>0.293742</td>\n",
       "      <td>0.278276</td>\n",
       "      <td>0.210818</td>\n",
       "      <td>0.314136</td>\n",
       "      <td>0.146119</td>\n",
       "      <td>0.366102</td>\n",
       "      <td>0.578755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               0           1           2           3           4           5   \\\n",
       "count  481.000000  481.000000  481.000000  481.000000  481.000000  481.000000   \n",
       "mean     0.375468    0.637239    0.311850    0.396151    0.227187    0.251459   \n",
       "std      0.209913    0.308814    0.361689    0.287491    0.202394    0.218514   \n",
       "min      0.000000    0.000000    0.000000    0.000000    0.000000    0.000000   \n",
       "25%      0.200000    0.378049    0.000000    0.123999    0.055359    0.065166   \n",
       "50%      0.350000    0.731707    0.121951    0.365268    0.171967    0.196682   \n",
       "75%      0.500000    0.914634    0.658537    0.645626    0.361602    0.398104   \n",
       "max      1.000000    1.000000    1.000000    1.000000    1.000000    1.000000   \n",
       "\n",
       "               6           7           8           9      ...              15  \\\n",
       "count  481.000000  481.000000  481.000000  481.000000     ...      481.000000   \n",
       "mean     0.434622    0.151775    0.179075    0.245397     ...        0.149866   \n",
       "std      0.102401    0.194849    0.215856    0.176482     ...        0.163032   \n",
       "min      0.000000    0.000000    0.000000    0.000000     ...        0.000000   \n",
       "25%      0.400000    0.000000    0.004878    0.000000     ...        0.027329   \n",
       "50%      0.437000    0.061303    0.078049    0.314607     ...        0.090683   \n",
       "75%      0.479000    0.260536    0.313821    0.366460     ...        0.222360   \n",
       "max      1.000000    1.000000    1.000000    1.000000     ...        1.000000   \n",
       "\n",
       "               16          17          18          19          20          21  \\\n",
       "count  481.000000  481.000000  481.000000  481.000000  481.000000  481.000000   \n",
       "mean     0.692380    0.126843    0.207940    0.196255    0.156084    0.205658   \n",
       "std      0.213133    0.141139    0.185630    0.179853    0.181719    0.182113   \n",
       "min      0.000000    0.000000    0.000000    0.000000    0.000000    0.000000   \n",
       "25%      0.640000    0.027273    0.054917    0.049372    0.027739    0.047120   \n",
       "50%      0.750000    0.079545    0.172414    0.150808    0.090153    0.167539   \n",
       "75%      0.816000    0.165909    0.293742    0.278276    0.210818    0.314136   \n",
       "max      1.000000    1.000000    1.000000    1.000000    1.000000    1.000000   \n",
       "\n",
       "               22          23          24  \n",
       "count  481.000000  481.000000  481.000000  \n",
       "mean     0.110064    0.243603    0.387799  \n",
       "std      0.140983    0.212548    0.260856  \n",
       "min      0.000000    0.000000    0.000000  \n",
       "25%      0.018265    0.071186    0.161172  \n",
       "50%      0.063927    0.196610    0.380952  \n",
       "75%      0.146119    0.366102    0.578755  \n",
       "max      1.000000    1.000000    1.000000  \n",
       "\n",
       "[8 rows x 25 columns]"
      ]
     },
     "execution_count": 420,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Split into Train and Test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 336,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "\n",
    "x_train,x_test,y_train,y_test = train_test_split(df,df_y,test_size = 0.3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 337,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(336, 25)"
      ]
     },
     "execution_count": 337,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x_train.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 338,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(336, 1)"
      ]
     },
     "execution_count": 338,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_train.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 421,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "KNeighborsRegressor(algorithm='auto', leaf_size=30, metric='minkowski',\n",
       "          metric_params=None, n_jobs=1, n_neighbors=5, p=2,\n",
       "          weights='uniform')"
      ]
     },
     "execution_count": 421,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.neighbors import KNeighborsRegressor\n",
    "\n",
    "\n",
    "knn = KNeighborsRegressor()\n",
    "\n",
    "knn.fit(x_train,y_train)\n",
    "# Make point predictions on the test set using the fit model.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 340,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(336, 1)"
      ]
     },
     "execution_count": 340,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_train.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 285,
   "metadata": {},
   "outputs": [],
   "source": [
    "predictions_train = knn.predict(x_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from sklearn.metrics import mean_squared_error\n",
    "from math import sqrt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 287,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "rmse_train = sqrt(mean_squared_error(predictions_train,y_train))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 288,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.028147407128808533"
      ]
     },
     "execution_count": 288,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rmse_train"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tuning \n",
    "At this point, we have to find values of K that minimize the train rmse. We will do by having a validation set held out via K-fold cross validation. In k-fold cross validation (the k is totally unrelated to K) involves randomly dividing the training set into k groups, or folds, of approximately equal size. The first fold is treated as a validation set, and the method is fit on the remaining k−1 folds. The misclassification rate is then computed on the observations in the held-out fold. This procedure is repeated k times; each time, a different group of observations is treated as a validation set. This process results in k estimates of the test error which are then averaged out. So each result is an average of K models. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 422,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "knn_k_values = list(range(1,30))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 295,
   "metadata": {},
   "outputs": [],
   "source": [
    "from math import sqrt\n",
    "from sklearn.model_selection import cross_val_score\n",
    "cv_scores = []\n",
    "for k in knn_k_values:\n",
    "    knn = KNeighborsRegressor(n_neighbors=k)\n",
    "    scores = cross_val_score(knn, x_train, y_train,10, cv= scoring='neg_mean_squared_error')\n",
    "    cv_scores.append(sqrt(abs(scores.mean())))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 296,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[0.04181517079711655,\n",
       " 0.03613331663743811,\n",
       " 0.03576693430522966,\n",
       " 0.03590103507447338,\n",
       " 0.036341965424389444,\n",
       " 0.03656043092367904,\n",
       " 0.03740754453097262,\n",
       " 0.03896096821184395,\n",
       " 0.03924945115304185,\n",
       " 0.03957231712988443,\n",
       " 0.03995484355747046,\n",
       " 0.0402977613359609,\n",
       " 0.04102356344597432,\n",
       " 0.0412196918737542,\n",
       " 0.04101875934051161,\n",
       " 0.04132140961824846,\n",
       " 0.04193037243647651,\n",
       " 0.042280099236260714,\n",
       " 0.043029150095914216,\n",
       " 0.04364032554028936,\n",
       " 0.044482866983084644,\n",
       " 0.04461696731886122,\n",
       " 0.044819804716495236,\n",
       " 0.0452794107385732,\n",
       " 0.045965656091332574,\n",
       " 0.04635611233654867,\n",
       " 0.04681156305201423,\n",
       " 0.046964188246119455,\n",
       " 0.04766589934601674]"
      ]
     },
     "execution_count": 296,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cv_scores"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 423,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The optimal number of neighbors is 3\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZIAAAEKCAYAAAA4t9PUAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3Xl8VOXZ//HPRQIkbAk7CWFfBUXEAO61RZRWK+oPK664\nV63Vx5aq7dNa6tNNa6ttta0IWndUqhXrvldbBMK+a2RLwhaWBAIkIcn1+2NO7JgGkpBMJpP5vl8v\nXz1zzj1nrrsDc3GfezN3R0RE5Ei1iHYAIiIS25RIRESkXpRIRESkXpRIRESkXpRIRESkXpRIRESk\nXpRIRESkXpRIRESkXpRIRESkXhKjHUBj6NKli/ft2zfaYYiIxIyFCxfucPeutSkb0URiZhOA3wMJ\nwAx3/3WV662BJ4DjgZ3ARe6+Iex6b2AVMM3d7wvO3QZcCziwHLjK3YsPF0ffvn3JyspqqGqJiDR7\nZraxtmUj9mjLzBKAh4CvA8OAi81sWJVi1wC73X0gcD9wT5XrvwNeD7tnT+AWINPdjyaUoCZHpgYi\nIlIbkewjGQNku/s6dy8FZgETq5SZCDweHM8GxpmZAZjZecB6YGWV9yQCyWaWCLQBNkcofhERqYVI\nJpKeQE7Y69zgXLVl3L0MKAQ6m1k74A7gZ+GF3T0PuA/YBGwBCt39rYhELyIitdJUR21NA+5396Lw\nk2bWkVArph+QDrQ1s8uqu4GZXW9mWWaWlZ+fH+l4RUTiViQ72/OAXmGvM4Jz1ZXJDR5VpRDqdB8L\nTDKze4FUoMLMioFtwHp3zwcwsxeBk4Cnqn64u08HpgNkZmZq0xURkQiJZCJZAAwys36EEsZk4JIq\nZeYAU4C5wCTgPQ/ttHVqZQEzmwYUufuDZjYWOMHM2gAHgHGAhmOJiERRxBKJu5eZ2c3Am4RGVz3q\n7ivN7G4gy93nADOBJ80sG9hFDSOw3H2emc0GFgFlwGKCVoeIiESHxcNWu5mZma55JCISTxZu3M2i\njbu57rT+R/R+M1vo7pm1KdtUO9tFROQIrd6yh6sem8/T8zZSVFIW8c9TIhERaUY27NjH5TPn06ZV\nIk9dO5Z2rSO/EpYSiYhIM7G1sJhLZ8yjvKKCp64dQ0bHNo3yuXGxaKOISHO3a18pl82cR+GBgzxz\n3VgGdmvfaJ+tRCIiEuOKSsq46rH5bNq1n8evGsOIjNRG/Xw92hIRiWHFB8u57vEsVmzew58uGcWJ\nAzo3egxKJCIiMaqsvIKbn1nM3HU7ue/CEZwxrHtU4lAiERGJQRUVzu2zl/HO6m3cPXE45x+XEbVY\nlEhERGKMu3P3P1bx4uI8vj9+MFec2Deq8SiRiIjEmPvf+Yy//nsD157Sj5u/NjDa4SiRiIjEkpkf\nr+cP737Ghcdn8L9nH0WwF2BUafiviEgTVlpWwfK8QhZu3MX89bt5Z/U2Jgzvwa8uOKZJJBFQIhER\naVIKDxxk0cbdLNiwi6yNu1maU0BJWQUAfTu34cqT+vLDbwwlMaHpPFBSIhERiaKSsnLeWLGV+et3\nsXDjbtZu24s7JLYwhvdM4bIT+jC6b0eO79OJru1bRzvcaimRiIhEyZqte/ifWUtYs3Uv7Vsnclyf\njpx9TBqZfTsxslcqya0Soh1irSiRiIg0sooKZ+bH6/nNm2vpkNyS6Zcfz7ijupPQomn0edSVEomI\nSCPK3b2fqS8s5ZN1uzhzWHd+dcExdG7XNB9Z1ZYSiYhII3B3Xlqcx09fXokDv5k0gknHZzSZkVf1\noUQiIhJhu/eV8r9/X85ry7cyum9HfvetkfTq1Dh7hTQGJRIRkQj68NN8fvDCUnbvL+WOCUO5/rT+\nMdsXcihKJCIiEXCgtJxfvb6aJ+ZuZHD3djx21WiGp6dEO6yIUCIREWlgcz/fyf/+fTnr8vdx7Sn9\nmHrWEJJaxsZQ3iOhRCIi0kC2Fhbzi9dW88rSzWR0TOaZa8dy0sAu0Q4r4pRIRETqqbSsgkf/FVpM\nsazCuXXcIG48fUCzboWEi+hiLWY2wczWmlm2md1ZzfXWZvZccH2emfWtcr23mRWZ2dSwc6lmNtvM\n1pjZajM7MZJ1EBE5nI8/28HXf/9Pfv36Gk4a0IV3bvsKt40fHDdJBCLYIjGzBOAhYDyQCywwsznu\nviqs2DXAbncfaGaTgXuAi8Ku/w54vcqtfw+84e6TzKwV0HzG0IlIzMgrOMDP/7GK11dspU/nNjx2\n5Wi+OrRbtMOKikg+2hoDZLv7OgAzmwVMBMITyURgWnA8G3jQzMzd3czOA9YD+yoLm1kKcBpwJYC7\nlwKlEayDiMiXlJSVM+Oj9Tz4XjaOM/XMwVx7av+4aoFUFclE0hPICXudC4w9VBl3LzOzQqCzmRUD\ndxBqzUwNK98PyAceM7NjgYXAre6+DxGRCPvw03x++vIKNuzcz4ThPfjxOUeR0VEPRZrOgvZfNg24\n392LqpxPBEYBf3b34wi1Vv6r7wXAzK43sywzy8rPz49osCLS/D2flcOUR+fTwozHrx7DXy4/Xkkk\nEMkWSR7QK+x1RnCuujK5ZpYIpAA7CbVcJpnZvUAqUBG0UmYDue4+L3j/bA6RSNx9OjAdIDMz0xuk\nRiISl15Zupk7/7aMUwd14ZErMuP6MVZ1IplIFgCDzKwfoYQxGbikSpk5wBRgLjAJeM/dHTi1soCZ\nTQOK3P3B4HWOmQ1x97XAOL7c5yIi0qDeWbWN255bQmafTky/XEmkOhFLJEGfx83Am0AC8Ki7rzSz\nu4Esd58DzASeNLNsYBehZFOT7wJPByO21gFXRaYGIhLvPv5sBzc9vYjh6R2YeWVmzGw01dgs1ABo\n3jIzMz0rKyvaYYhIDFmwYRdXzJxPn85tmHX9CaS2aRXtkBqVmS1098zalG2qne0iIlGzLLeAqx9b\nQFpKEk9eMzbukkhdKZGIiIRZu3UvVzw6n5Q2LXn6urF0bR/buxc2BiUSEZHA+h37uHTGPFontuCZ\na08gLSU52iHFBCUSERFCe6lf+sgnuDtPX3sCvTtrjkhtKZGISNzbvqeYS2fMo6ikjCeuGcPAbu2i\nHVJMUSIRkbi2a18pl86Yx469Jfz16jHNdhfDSFIiEZG4lb29iEse+YRNu/YzY8poRvXuGO2QYpI2\nthKRuOPuPDVvE794dRVJLROYMSWTEwd0jnZYMUuJRETiSv7eEm6fvZT31+Zz2uCu/GbSCLp3SIp2\nWDFNiURE4sbbq7Zx59+WUVRSxs/OHc4VJ/bBzKIdVsxTIhGRZm9fSRk/f3UVz87PYVhaB2ZNHsmg\n7u2jHVazoUQiIs3a4k27ue25JWzctZ8bvjKA740fTKtEjTNqSEokItIslZVX8ND7n/OH9z6jR4ck\nZl13AmP7q0M9EpRIRKTZyd6+lx/MXsbiTQWcf1xPfjZxOB2SWkY7rGZLiUREYp67syJvD2+v2spb\nq7axZuteOiQl8seLj+Obx6ZHO7xmT4lERGJSaVkF89bv5O1V23hn1TY2FxbTwiCzbyd+fPZRnHts\nOt00rLdRKJGISMzYW3yQD9bm8/aqbby/djt7i8tIatmC0wZ15bbxgxl3VHc6tdXeIY1NiUREmiR3\nZ8PO/SzLLWB5biHLcgtZnLObg+VO57at+PrRPRg/rAenDOyiLXCjTIlERKLO3dlcWMyynAKW5RV+\nkTz2FJcB0DqxBcPTO3DVyf0YP6w7o3p3JKGFJhI2FUokIhI1WRt28eD72SzPLWTnvlIAWiYYQ3t0\n4Jxj0xnRM4URGakM6t6Olgma+9FUKZGISFTk7NrPNY9nkdSyBV8b2o0RGaGkMaRHe5Ja6lFVLFEi\nEZFGV3ywnBufXkiFO89/+0T6dG4b7ZCkHpRIRKTRTZuzkhV5e5hxRaaSSDOgh44i0qieX5DDrAU5\nfOerAzhjWPdohyMNIKKJxMwmmNlaM8s2szurud7azJ4Lrs8zs75Vrvc2syIzm1rlfIKZLTazf0Qy\nfhFpWCvyCvnxyys4eWBnvjd+SLTDkQYSsURiZgnAQ8DXgWHAxWY2rEqxa4Dd7j4QuB+4p8r13wGv\nV3P7W4HVDRuxiERSwf5SbnhqIZ3btuIPk4/T8N1mJJItkjFAtruvc/dSYBYwsUqZicDjwfFsYJwF\nu8yY2XnAemBl+BvMLAM4G5gRwdhFpAFVVDi3PbeEbXuK+dOlo+jcrnW0Q5IGFMlE0hPICXudG5yr\ntoy7lwGFQGczawfcAfysmvs+ANwOVDR0wCISGQ++n837a/O565xhHNe7Y7TDkQbWVDvbpwH3u3tR\n+EkzOwfY7u4La7qBmV1vZllmlpWfnx+hMEWkJh9+ms/973zK+cf15LIT+kQ7HImASA7/zQN6hb3O\nCM5VVybXzBKBFGAnMBaYZGb3AqlAhZkVE2rBnGtm3wCSgA5m9pS7X1b1w919OjAdIDMz0xu0ZiJS\nK7m793PrrMUM6d6eX55/jPZHb6YimUgWAIPMrB+hhDEZuKRKmTnAFGAuMAl4z90dOLWygJlNA4rc\n/cHg1A+D86cDU6tLIiISfSVl5Xzn6UWUlzt/vux4LazYjEUskbh7mZndDLwJJACPuvtKM7sbyHL3\nOcBM4EkzywZ2EUo2ItIM/OyVVSzNLeThy4+nXxdNOmzOLNQAaN4yMzM9Kysr2mGIxI3ZC3OZ+sJS\nbvjKAO78+tBohyNHwMwWuntmbco21c52EYlRS3MK+N+XlnNi/85MPXNwtMORRqBEIiINZt66nVw6\nYx5d27fmj5ccR6KWfo8L+pZFpEG8t2YbVzw6nx4pScy+4SS6aNJh3NDqvyJSby8vyeP7zy/lqLQO\nPH71GO2bHmeUSESkXp76ZCM/eXkFY/p2YsaUTNontYx2SNLIlEhE5Ij96YNs7n1jLeOGduOhS0dp\nZ8M4pUQiInXm7vz6jTU8/OE6Jo5M574Lj9We6nFMiURE6qS8wvnx31fw7PxNXH5CH3527nBaaEn4\nuKZEIiK1VlpWwfeeX8I/lm3hO18dwNQzh2j9LFEiEZHaOVBazo1PL+SDtfn86BtDuf60AdEOSZoI\nJRIRqdHe4oNc/dcFZG3cza8vOIbJY3pHOyRpQpRIROSwDpZXcNPTi1i8qYA/Xnwc54xIj3ZI0sQo\nkYjIIbk7P3pxOR99toN7J41QEpFqabyeiBzSH97N5oWFudwybhDfyuxV8xskLimRiEi1Zi/M5f53\nPuWCUT257YxB0Q5HmjAlEhH5L//K3sGdf1vGSQM68+sLRmiIrxyWEomIfMmarXu44cmFDOjajr9c\nfjytEvUzIYenPyEi8oWthcVc9dgC2rRO4LGrRtNBCzBKLSiRiAgARSVlXPXXBew5cJBHrxxNempy\ntEOSGKHhvyLyxVyRT7ftZeaUTIanp0Q7JIkhapGIxDl35yd/X8E/P83nF+cdzelDukU7JIkxh00k\nZva1sON+Va5dEKmgRKTxPPR+NrMW5HDzVwdq6RM5IjW1SO4LO/5blWs/buBYRKSRvbQ4l/ve+pTz\nj+vJ988cHO1wJEbV1Edihziu7rWIxIidRSU8+H42T87dyAn9O3HP/9NcETlyNSUSP8Rxda9FpInb\nV1LGjI/W88hH69hfWsak4zP437OHaa6I1EtNiaS/mc0h1PqoPCZ43e/QbwsKmU0Afg8kADPc/ddV\nrrcGngCOB3YCF7n7hrDrvYFVwDR3v8/MegXluxNKZNPd/fc11lIkzpWWVfDs/E388b3P2FFUylnD\nu/ODs4YwsFv7aIcmzUBNiWRi2PF9Va5Vff0lZpYAPASMB3KBBWY2x91XhRW7Btjt7gPNbDJwD3BR\n2PXfAa+HvS4Dvu/ui8ysPbDQzN6uck8RCVRUOK8s28xv3/qUTbv2M7ZfJ6ZfMZRRvTtGOzRpRg6b\nSNz9w/DXZtYSOBrIc/ftNdx7DJDt7uuC984ilJjCf/QnAtOC49nAg2Zm7u5mdh6wHtgXFs8WYEtw\nvNfMVgM9q9xTJO65Ox98ms+9b6xl9ZY9HJXWgceuGs3pg7uqL0Qa3GETiZn9Bfiju680sxRgLlAO\ndDKzqe7+7GHe3hPICXudC4w9VBl3LzOzQqCzmRUDdxBqzUw9RGx9geOAeYe4fj1wPUDv3hrSKPFj\nSU4Bv3ptNfPW76JXp2R+P3kk3xyRTosWSiASGTU92jrV3W8Ijq8CPnX388ysB6FHTodLJPUxDbjf\n3Yuq+9eTmbUjNBz5f9x9T3U3cPfpwHSAzMxMDQyQuPB8Vg53/m0Zndq24mfnDufiMb3VkS4RV1Mi\nKQ07Hg+8AODuW2vRPM4DwnfCyQjOVVcm18wSgRRCne5jgUlmdi+QClSYWbG7Pxg8Xvsb8LS7v1hT\nEEeqosL58LN80lKSGNqjQ6Q+RqTBzPhoHT9/dTWnDurCny4dRXstuCiNpKZ/qhSY2TlmdhxwMvAG\nQPCjX9OKbguAQWbWz8xaAZOBOVXKzAGmBMeTgPc85FR37+vufYEHgF8GScSAmcBqd/9dLet4RMzg\nxqcW8kJWbiQ/RqTe3J3fvrWWn7+6mm8c04MZUzKVRKRR1dQi+TbwB6AHocdIW4Pz44BXD/fGoM/j\nZuBNQsN/Hw36Wu4Gstx9DqGk8KSZZQO7CCWbwzkZuBxYbmZLgnM/cvfXanhfnZkZ6anJbCk80NC3\nFmkwFRXOtFdW8sTcjVyU2YtfXnAMCeoLkUZW06itT4EJ1Zx/k1CCOKzgB/61KufuCjsuBi6s4R7T\nwo4/phFn1KenJJNXUNxYHydSJwfLK5j6wlJeXrKZ60/rzw+/PlQjsiQqahq19YfDXXf3Wxo2nKYl\nPTWJD9bmRzsMkf9SfLCcm55exHtrtvODs4Zw0+kDlEQkamp6tHUDsAJ4HthMnK2vlZaSTH5RCaVl\nFRr5Ik3GnuKDXPt4Fgs27OLn5x3NZSf0iXZIEudqSiRphB49XURoVvlzwGx3L4h0YE1Bz9Rk3GHb\nnmJ6dWoT7XBE2FlUwpTH5rNmy15+P/k4zj02PdohiRx+1Ja773T3v7j7VwnNI0kFVpnZ5Y0SXZSl\npSYBkFegDneJvryCA1z48FyytxfxyJRMJRFpMmq11a6ZjQIuJjSX5HVgYSSDaioq96zWyC2Jts/z\ni7h8xjz2lpTx5DVjGd23U7RDEvlCTZ3tdwNnA6uBWcAP3b2sMQJrCtJTQolks0ZuSZTk7t7PjI/W\n89yCHNq2TmDW9SdoP3VpcmpqkfyY0MKJxwb//TIYGWKAu/uIyIYXXcmtEujYpiWb9WhLaqGkrJz5\n63exr6SMkwd2qdekwFWb9zD9n5/zyrItGHDuyHRuO2Ow+uqkSaopkdS450hzl5aSrEQih7SjqIT3\n12zn3dXb+eizfPaVlgPQMsE4oX9nzhzWnTOGdSctpaaFIEIz1Oeu28nDH67jw0/zadsqgatO6svV\np/T74jGrSFNU04TEjdWdN7MWhPpMqr3enKSnJpO7e3+0w5Amwt1Zu20v767ezrurt7E4pwB36N6h\nNeeO7MkZR3WjXetE3lm9jbdXbeMnL6/kJy+v5OieHRh/VA/OGNaNYWkdvjTno7zCeXPlVh7+8HOW\n5hbSpV0rfnDWEC4b24eUNlrqRJq+mvpIOgDfIbTc+xzgbeBm4PvAUuDpSAcYbempScxbvzPaYUgU\nlVc4H2fv4L3V23hn9fYvRvEd0zOFW8cN4oyjujM8/cvJYWz/zvzoG0fxeX4Rb63axjurtvHAu59y\n/zuf0jM1mfHDujPuqG5s2rWfR/65jg0799O3cxt+cf7R/L9RGSS1TIhWdUXqrKZHW08CuwntQ3It\n8CNC/SPnufuSw72xuUhPTWZvcRl7iw9qIbw4VFZewU1PL+KtVdtIatmCUwZ24eavDeRrQ7vRvUPS\nYd9rZgzs1p6B3dpz0+kDyd9bwntrQi2VZ+dv4q//3gDAiIwU/nTpKM4a3kPrZElMqnHPdnc/BsDM\nZhDanbB3sEZWXEhLCf1YbCksViKJM+7OT15eyVurtnH7hCFcfXK/erUUurZvzUWje3PR6N4cKC3n\n35/voH1SS0b37ajlTSSm1ZRIDlYeuHu5meXGUxKB0Ox2gM0FBxjcvX2Uo5HG9MA7n/Hs/E3cdPoA\nbjp9YIPeO7lVAuOO6t6g9xSJlpoSybFmVrkDoQHJwevK4b/NfsentFTNJYlHT32ykd+/+xmTjs/g\nB2cNiXY4Ik1aTaO24r7Hr3v71rQwzW6PJ2+s2MpdL6/gq0O68qsLjtFjJ5EaaEnbGiQmtKB7hySt\ntxUn5q/fxS2zFjMiI5WHLh1FywT9FRGpif6W1EJ6ajJb9Gir2Vu7dS/XPr6AjI7JPHrlaNq0qtVS\ndCJxT4mkFtJSktisR1vNWl7BAaY8Op/kVgk8cfUYOrVtFe2QRGKGEkkt9ExNZkthMe4e7VAkAnbv\nK+WKmfPYV1rG41ePIaOj1rMSqQslklpIS0mitKyCnftKox2KNLADpeVc8/gCcnYfYMYVmQzt0ewH\nIoo0OCWSWkgPm0sizUdZeQU3P7OIxTkF/GHySMb27xztkERikhJJLaRrLkmz4+786KXlvLtmO3dP\nPJoJR6dFOySRmKVhKbWgFknzsnDjLu59Yy3z1u/ilq8N5PIT+kQ7JJGYpkRSCx3btKR1YgtNSoxx\nqzbv4bdvreXdNdvp0q41/zdxOJcpiYjUW0QfbZnZBDNba2bZZnZnNddbm9lzwfV5Zta3yvXeZlZk\nZlNre89IMDN6pibr0VaMWr9jH999djHf+MNHLNiwi9snDOGft5/O5Sf21ax1kQYQsRaJmSUADwHj\ngVxggZnNcfdVYcWuAXa7+0AzmwzcA1wUdv13wOt1vGdEpKVqLkms2VxwgD++9xnPZ+XSKqEFN391\nINed1p+UZK3iLNKQIvloawyQ7e7rAMxsFjARCP/RnwhMC45nAw+ambm7m9l5hPaL31fHe0ZEekoy\n//wsP9IfIw1gZ1EJf/rgc578ZCM4XH5CH77z1YF0bd862qGJNEuRTCQ9gZyw17nA2EOVcfcyMysE\nOptZMXAHoZbH1OrKH+aeEZGWmsz2vSUcLK/Q+ktNVFFJGdM//JyZH6/nwMFyJh2fwS3jBmmCoUiE\nNdXO9mnA/e5edKTPsM3seuB6gN69e9c7oPSUJNxha2ExvTrph6kpcXf+viSPX722hu17Szj7mDRu\nGz+Ygd3aRTs0kbgQyUSSB/QKe50RnKuuTK6ZJQIpwE5CrYxJZnYvkApUBK2UhbW4JwDuPh2YDpCZ\nmVnvtU0qhwBvUSJpUpblFjBtzkoWbSrg2IwUHr78eI7r3THaYYnElUgmkgXAIDPrR+jHfjJwSZUy\nc4AphPaEnwS856EFrU6tLGBm04Aid38wSDY13TMi0lNDW+5qLknTsKOohN+8sZbnF+bQuW0r7p00\ngkmjMmihPc9FGl3EEknQ53Ez8CaQADzq7ivN7G4gy93nADOBJ80sG9hFKDHU+Z6RqkO4tJRgUqJG\nbkXVwfIKnpi7kQfe+ZQDpeVce0o/vjtuEB2SNBJLJFoi2kfi7q8Br1U5d1fYcTFwYQ33mFbTPRtD\n29aJpCS3VIskij76LJ+fvbKK7O1FnDa4K3edM0z9ICJNQFPtbG+StMFVdGzauZ+fv7qKt1Zto0/n\nNsy4IpNxR3XTZEKRJkKJpA7SU7TlbmPKKzjAXz74nOcW5JCYYNw+YQjXnNKP1okJ0Q5NRMIokdRB\nemoyWRt3RzuMZi9n137+9MHnzF4YmjI06fhe3DpuED1SkqIcmYhUR4mkDtJSkyg8cJB9JWW0ba3/\n6xraxp37eOj9bF5clEcLMyaP7s2Npw/4Yui1iDRN+jWsg55fzCU5wMBu7aMcTfOxfsc+Hnwvm78v\nySOxhXHZCX244SsD1AIRiRFKJHVQOQQ4r6BYiaQBZG8v4qH3s3l5SR6tEltw5Ul9+fZp/enWQQlE\nJJYokdRB5aTELepwr5elOQU88tE6Xl2+haTEBK49tT/XndpfiyqKxCglkjro3iEJM9hcqCHAdVVW\nXsFbq7Yx8+P1LNy4m/atE/n2aQO47tR+dG6nBCISy5RI6qBlQgu6t0/SpMQ62FN8kOcX5PDYvzaQ\nV3CAXp2SueucYVyYmUF7zUYXaRaUSOooLTVJW+7Wwqad+3ns3+t5ISuXopIyxvTtxE/OGcb4Yd1J\n0HpYIs2KEkkdpacms2rznmiH0SS5O/PX72Lmx+t5e/U2Esw4Z0Qa15zSn2MyUqIdnohEiBJJHaWn\nJPHOqm24u5boqOLGpxbxxsqtpLZpyU2nD+DyE/pqCK9IHFAiqaP01GRKyirYta9UncRhluYU8MbK\nrVxzSj+mnjmE5FZaxkQkXmjP2DqqnEuyRSO3vuSJuRtp2yqB/zljkJKISJxRIqmjytntWrzxP3YW\nlfDKss2cP6qnRmKJxCElkjpK06TE//JcVg6lZRVccWLfaIciIlGgRFJHndu2olViC01KDJSVV/D0\nJ5s4sX9nBnfXsjEi8UiJpI7MjPQUTUqs9O6a7eQVHGDKSX2iHYqIRIkSyRFIT01WIgk8MXcDaSlJ\nnHFU92iHIiJRokRyBNJSkjVqC8jevpd/Ze/kshP6kJigP0oi8Up/+49Az9Qktu0ppqy8ItqhRNWT\nczfSKqEFF43uFe1QRCSKlEiOQFpqMhUO2/aWRDuUqNlbfJDZC3M5e0QaXTQxUySuKZEcgcqtX+O5\nn+SlxXnsKy3nihPVyS4S75RIjkB6sH5UvCYSd+fxf29gREYKI3ulRjscEYmyiCYSM5tgZmvNLNvM\n7qzmemszey64Ps/M+gbnx5jZkuC/pWZ2fth7bjOzlWa2wsyeNbNGXxUw7YsWSXx2uP/78518nr+P\nK07sq4UrRSRyicTMEoCHgK8Dw4CLzWxYlWLXALvdfSBwP3BPcH4FkOnuI4EJwMNmlmhmPYFbgmtH\nAwnA5EjV4VDatU6kQ1Ji3O5L8sTcDXRs05JzRqRFOxQRaQIi2SIZA2S7+zp3LwVmAROrlJkIPB4c\nzwbGmZm5+353LwvOJwEe9p5EINnMEoE2wOaI1eAw4nUuSV7BAd5etY2LRvcmqaUWZxSRyCaSnkBO\n2Ovc4FxjlS/LAAARMklEQVS1ZYLEUQh0BjCzsWa2ElgO3ODuZe6eB9wHbAK2AIXu/lYE63BIoUQS\nf4+2nv5kIwCXju0d5UhEpKlosp3t7j7P3YcDo4EfmlmSmXUk1IrpB6QDbc3ssureb2bXm1mWmWXl\n5+c3eHxpKUlsjrNHW8UHy5m1IIdxR3WnV6c20Q5HRJqISCaSPCB8plpGcK7aMsGjqhRgZ3gBd18N\nFAFHA2cA6909390PAi8CJ1X34e4+3d0z3T2za9euDVCdL0tPTaZg/0EOlJY3+L2bqleXbWHXvlKm\naJVfEQkTyUSyABhkZv3MrBWhTvE5VcrMAaYEx5OA99zdg/ckAphZH2AosIHQI60TzKyNhYYLjQNW\nR7AOh5QeLCcfT62SJz7ZSP+ubTl5YOdohyIiTUjEEknQ53Ez8CahH/vn3X2lmd1tZucGxWYCnc0s\nG/geUDlE+BRgqZktAV4CbnL3He4+j1Cn/CJCfSctgOmRqsPhpKfE16TEJTkFLM0pYIqG/IpIFRHd\ns93dXwNeq3LurrDjYuDCat73JPDkIe75U+CnDRtp3VXObt8SJx3uT8zdQNtWCVwwqup4CRGJd022\ns72p694hCbP42HJ3Z1EJ/1i6hQtGZWgrXRH5L0okR6hVYgu6tmsdF5MSZy3IobS8QutqiUi1lEjq\nIR7mkoS20t3ISQM6M0hb6YpINZRI6iE9tfnPJXl3zXY2FxZzhYb8isghKJHUQ3pKaJkUd6+5cAwq\nKSvnj+99RnpKEmcc1S3a4YhIE6VEUg9pqckUH6ygYP/BaIcSEf/3j1WsyNvDXd8cpq10ReSQ9OtQ\nDz2DSYnNceTWS4tzeeqTTVx/Wn8mHK1VfkXk0JRI6iEtmJS4pbB5dbiv2bqHH764nDH9OnH7WUOi\nHY6INHFKJPXQHLfc3Vt8kBufWkT7pJY8ePFxeqQlIjWK6Mz25q5z21a0SmjRbEZuuTu3z17Gpl37\neebasXTr0OibT4pIDNI/N+uhRQsjLTWp2cwlmfnxel5fsZU7JgxhbH8tzCgitaNEUk9pKUlsaQaP\ntuav38WvXl/DhOE9uO7U/tEOR0RiiBJJPTWHLXe37y3mO88sonenNtx74Qit7isidaJEUk/pKcls\n21tCWXlFtEM5ImXlFXz3mcXsLT7Iny8bRQctyigidaREUk/pqcmUVzjb95ZEO5Qj8pu31jJv/S5+\nef4xDO3RIdrhiEgMUiKpp7RgUmIsrgL8xoqtPPzhOi4d25sLRmVEOxwRiVFKJPXUM5hLkhdjI7fW\n79jHD15YyoiMFO765rBohyMiMUyJpJ7SUoIWSQx1uB8oLefGpxaSkGD86dJRtE5MiHZIIhLDNCGx\nntontaR9UmKTXybF3VmzdS+vLd/CK0s3s3HXfh67cjQZHdtEOzQRiXFKJA0gPSW5SS7c6O6s3baX\nV5dt4dXlW1iXv48WBif078wdE4Zy+hAtDS8i9adE0gDSU5OaTGd7ZfJ4bdkW/hGWPMb268zVJ/dj\nwtE96NKudbTDFJFmRImkAaSlJrM0tzCqMWzfW8xTn2zi1WWb+TwseVx1cj8mDO9B1/ZKHiISGUok\nDaBnajK79pVSfLCcpJaN23Ht7sxZupmfzlnJngMHGduvM1cqeYhII1IiaQCVI7c2Fxygf9d2jfa5\nO4pK+MnfV/D6iq2M7JXKfRcey8Bujff5IiIQ4eG/ZjbBzNaaWbaZ3VnN9dZm9lxwfZ6Z9Q3OjzGz\nJcF/S83s/LD3pJrZbDNbY2arzezESNahNir3JWnMkVuvLd/Cmff/k3dXb+fOrw/lbzeepCQiIlER\nsRaJmSUADwHjgVxggZnNcfdVYcWuAXa7+0AzmwzcA1wErAAy3b3MzNKApWb2iruXAb8H3nD3SWbW\nCoj6+NXKSYnPLchheHoHUtu0ithn7d5Xyl1zVvLK0s0c0zOF337rWAZ3bx+xzxMRqUkkH22NAbLd\nfR2Amc0CJgLhiWQiMC04ng08aGbm7vvDyiQBHtwjBTgNuBLA3UuB0shVoXYyOiZz9cn9+Ou/1/PB\n2u3cMm4QV5zYl1aJDdvge3vVNn744nIKD5Ty/fGDueH0AbTUDoYiEmWR/BXqCeSEvc4NzlVbJmht\nFAKdAcxsrJmtBJYDNwTX+wH5wGNmttjMZphZ2wjWoVbMjLu+OYzXbz2Nkb078vNXVzP+/g95ffkW\n3L3e9y/cf5DvPbeE657Iomv71rz8nVP47rhBSiIi0iQ02V8id5/n7sOB0cAPzSyJUAtqFPBndz8O\n2Af8V98LgJldb2ZZZpaVn5/fKDEP6dGeJ64ew+NXj6F1YgtufHoR33p4LktzCo74nu+v3c6ZD3zI\ny0s3c8vXBvLyd05mWLpW6RWRpiOSj7bygF5hrzOCc9WVyTWzRCAF2BlewN1Xm1kRcDShVk2uu88L\nLs/mEInE3acD0wEyMzPr3yyog68M7srJA07l+axcfvf2WiY+9C8mjkzn9glDv+hPqc6ufaUsyy1g\neW4hy/IKWZZbwLY9JQzu3o4ZV4zmmIyURqyFiEjtRDKRLAAGmVk/QgljMnBJlTJzgCnAXGAS8J67\ne/CenKCzvQ8wFNjg7jvMLMfMhrj7WmAcX+5zaTISE1pwydjenDsynT9/kM2Mj0L7oV97Sj9uPH0A\nDqzIK2RZbiHLcwtZmltA7u7/zI7v37UtJw3owqg+HflWZoYWVhSRJssa4hn+IW9u9g3gASABeNTd\nf2FmdwNZ7j4neFz1JHAcsAuY7O7rzOxyQi2Ng0AFcLe7/z2450hgBtAKWAdc5e67DxdHZmamZ2Vl\nRaaStZRXcID73lzLS4vzSG6ZwIGD5V9c69UpmRE9UxmRkcIxGSkc0zOF9tqpUESiyMwWuntmrcpG\nMpE0FU0hkVRallvAs/M3kZ6SzIheqRzTM4VObSM3XFhE5EjUJZFoZnsjG5GRyoiM1GiHISLSYJrs\nqC0REYkNSiQiIlIvSiQiIlIvSiQiIlIvSiQiIlIvSiQiIlIvSiQiIlIvSiQiIlIvcTGz3czygY1h\np7oAO6IUTiQ113pB862b6hV7mmvdqtarj7t3rc0b4yKRVGVmWbWd+h9Lmmu9oPnWTfWKPc21bvWp\nlx5tiYhIvSiRiIhIvcRrIpke7QAipLnWC5pv3VSv2NNc63bE9YrLPhIREWk48doiERGRBhJXicTM\nJpjZWjPLNrNq93qPVWa2wcyWm9kSM2sau3gdATN71My2m9mKsHOdzOxtM/ss+N+O0YzxSB2ibtPM\nLC/43pYEu4rGFDPrZWbvm9kqM1tpZrcG52P6eztMvZrDd5ZkZvPNbGlQt58F5/uZ2bzgN/I5M6vV\nrntx82jLzBKAT4HxQC6hPeUvdvcmued7XZnZBiDT3WN6fLuZnQYUAU+4+9HBuXuBXe7+6+AfAB3d\n/Y5oxnkkDlG3aUCRu98Xzdjqw8zSgDR3X2Rm7YGFwHnAlcTw93aYen2L2P/ODGjr7kVm1hL4GLgV\n+B7worvPMrO/AEvd/c813S+eWiRjgGx3X+fupcAsYGKUY5Iq3P2fwK4qpycCjwfHjxP6yxxzDlG3\nmOfuW9x9UXC8F1gN9CTGv7fD1CvmeUhR8LJl8J8DXwNmB+dr/Z3FUyLpCeSEvc6lmfyhCDjwlpkt\nNLProx1MA+vu7luC461A92gGEwE3m9my4NFXTD3+qcrM+gLHAfNoRt9blXpBM/jOzCzBzJYA24G3\ngc+BAncvC4rU+jcynhJJc3eKu48Cvg58J3iM0ux46Flsc3oe+2dgADAS2AL8NrrhHDkzawf8Dfgf\nd98Tfi2Wv7dq6tUsvjN3L3f3kUAGoSc2Q4/0XvGUSPKAXmGvM4JzzYK75wX/ux14idAfjOZiW/C8\nuvK59fYox9Ng3H1b8Be6AniEGP3egufsfwOedvcXg9Mx/71VV6/m8p1VcvcC4H3gRCDVzBKDS7X+\njYynRLIAGBSMSmgFTAbmRDmmBmFmbYPOQMysLXAmsOLw74opc4ApwfEU4OUoxtKgKn9oA+cTg99b\n0HE7E1jt7r8LuxTT39uh6tVMvrOuZpYaHCcTGoS0mlBCmRQUq/V3FjejtgCCYXoPAAnAo+7+iyiH\n1CDMrD+hVghAIvBMrNbNzJ4FTie0Euk24KfA34Hngd6EVnH+lrvHXKf1Iep2OqFHJA5sAL4d1q8Q\nE8zsFOAjYDlQEZz+EaH+hJj93g5Tr4uJ/e9sBKHO9ARCDYrn3f3u4LdkFtAJWAxc5u4lNd4vnhKJ\niIg0vHh6tCUiIhGgRCIiIvWiRCIiIvWiRCIiIvWiRCIiIvWiRCJNlpm5mf027PXUYJHDhrj3X81s\nUs0l6/05F5rZajN7v8r5vkH9vht27kEzu7KG+91gZlfUUOZKM3vwENeKqjvfUIJ6ha9ufF2wbE9M\nLiMitaNEIk1ZCXCBmXWJdiDhwmb+1sY1wHXu/tVqrm0Hbq3tUt0A7v4Xd3+iDp/fYOpYb8zscuC7\nwFnuvjsyUUlToEQiTVkZoe0/b6t6oWqLovJf2mZ2upl9aGYvm9k6M/u1mV0a7L2w3MwGhN3mDDPL\nMrNPzeyc4P0JZvYbM1sQLMr37bD7fmRmc4D/2nrAzC4O7r/CzO4Jzt0FnALMNLPfVFO/fOBd/jP7\nO/x+A8zsjeBf8x+Z2dDg/DQzmxocjw5iXBLEHD7DOj14/2cWWoY//N73W2gPinfNrGtwbqSZfRLc\n76XKFoSZfWBmD1hoj5tbgxbWCgvtY/HPaupU+RnfAu4Ezoz1rQ2kZkok0tQ9BFxqZil1eM+xwA3A\nUcDlwGB3HwPMIPQv5Ep9Ca2TdDbwFzNLItSCKHT30cBo4Doz6xeUHwXc6u6Dwz/MzNKBewgtwT0S\nGG1m57n73UAWcKm7/+AQsd4DTLXQfjnhpgPfdffjganAn6p572OEZlWPBMqrXBsJXAQcA1xkZpXr\nzLUFstx9OPAhodn1AE8Ad7j7CEIzuX8adq9W7p7p7r8F7iLUwjgWOPcQdeoDPEgoiWw9RBlpRpRI\npEkLVlt9ArilDm9bEOwlUUJoaey3gvPLCSWPSs+7e4W7fwasI7T66ZnAFRZaXnse0BkYFJSf7+7r\nq/m80cAH7p4fLMH9NFCr1ZfdfV3wOZdUnrPQarMnAS8EcTwMhK/vRLBOUnt3nxuceqbKrd9190J3\nLybUguoTnK8AnguOnwJOCZJ0qrt/GJx/vEr8z4Ud/wv4q5ldR2h5jerkA5sIbQAlcaBOzzxFouQB\nYBGhf4FXKiP4h5CZtQDC+xnC1waqCHtdwZf/zFddH8gBI9QSeDP8gpmdDuw7svBr9EtCmwlV/pC3\nILQvxMh63DP8/4NyDv13vTZrJH1Rb3e/wczGEmrFLTSz4919Z5Xy+4FvAB+Z2XZ3f7oOcUsMUotE\nmrxgob/nCT12qrQBOD44PpfQDm91daGZtQj6TfoDa4E3gRsttHw4ZjbYQisqH8584Ctm1iV4RHUx\n/0kKNXL3NYRaDd8MXu8B1pvZhUEMZmbHVnlPAbA3+FGH0GrWtdGC/6zuegnwsbsXArvN7NTg/OWH\nit/MBrj7PHe/i1DLo1d15YLtDCYAvzSzs2oZm8QoJRKJFb8ltGpupUcI/XgvJbSPwpG0FjYRSgKv\nAzcEj4FmEPpRXxR0Xj9MDS33YOXXOwktwb0UWOjudV0y/ReE9n+odClwTVC/lVS/LfQ1wCPB46+2\nQGEtPmcfMCao29eAu4PzU4DfmNkyQv0rdx/i/b+pHFQA/JtQfasVPAY8F3jUzGJ6zw45PK3+KxKj\nzKxd5b7bZnYnkObut0Y5LIlD6iMRiV1nm9kPCf093ghcGd1wJF6pRSIiIvWiPhIREakXJRIREakX\nJRIREakXJRIREakXJRIREakXJRIREamX/w9bBdujzRMF4wAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10aec6588>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "\n",
    "\n",
    "# determining best k\n",
    "optimal_k = knn_k_values[cv_scores.index(min(cv_scores))]\n",
    "print (\"The optimal number of neighbors is %d\" % optimal_k)\n",
    "\n",
    "# plot misclassification error vs k\n",
    "plt.plot(knn_k_values, cv_scores)\n",
    "plt.xlabel('Number of Neighbors K')\n",
    "plt.ylabel('RMSE')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}