wr_projections_stp3.3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "a1e80693-7cf7-4b80-bfc8-3994be29f659",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import operator\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "import visuals as vs\n",
    "\n",
    "from scipy.stats import norm\n",
    "from sklearn.preprocessing import MinMaxScaler\n",
    "from time import time\n",
    "from IPython.display import display\n",
    "from io import StringIO\n",
    "from sklearn.ensemble import GradientBoostingClassifier\n",
    "from sklearn.metrics import classification_report, confusion_matrix, roc_curve, auc\n",
    "from sklearn.metrics import precision_score\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.metrics import fbeta_score,accuracy_score\n",
    "from sklearn.pipeline import Pipeline, FeatureUnion\n",
    "from sklearn.preprocessing import OneHotEncoder, StandardScaler\n",
    "from sklearn.model_selection import RandomizedSearchCV, train_test_split\n",
    "from sklearn.base import BaseEstimator, TransformerMixin\n",
    "from sklearn.metrics import mean_squared_error\n",
    "from sklearn.model_selection import GridSearchCV\n",
    "from sklearn.metrics import make_scorer, r2_score, fbeta_score\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "2ee2efa8-b05d-486a-8068-098fbe90fe07",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Player</th>\n",
       "      <th>avoided_tackles</th>\n",
       "      <th>grades_offense</th>\n",
       "      <th>longest</th>\n",
       "      <th>receptions</th>\n",
       "      <th>routes</th>\n",
       "      <th>targets</th>\n",
       "      <th>yards</th>\n",
       "      <th>yards_after_catch</th>\n",
       "      <th>yprr</th>\n",
       "      <th>ypt</th>\n",
       "      <th>1,000 Yard Seasons</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Drake London</td>\n",
       "      <td>8.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>40.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>866.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>2.07</td>\n",
       "      <td>7.596491</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Garrett Wilson</td>\n",
       "      <td>22.0</td>\n",
       "      <td>82.7</td>\n",
       "      <td>60.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>595.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>1103.0</td>\n",
       "      <td>389.0</td>\n",
       "      <td>1.85</td>\n",
       "      <td>7.935252</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Chris Olave</td>\n",
       "      <td>2.0</td>\n",
       "      <td>82.5</td>\n",
       "      <td>53.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>431.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1044.0</td>\n",
       "      <td>219.0</td>\n",
       "      <td>2.42</td>\n",
       "      <td>9.157895</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Jameson Williams</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.4</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.11</td>\n",
       "      <td>5.125000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Jahan Dotson</td>\n",
       "      <td>2.0</td>\n",
       "      <td>70.5</td>\n",
       "      <td>61.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>523.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>1.39</td>\n",
       "      <td>9.339286</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Treylon Burks</td>\n",
       "      <td>4.0</td>\n",
       "      <td>74.1</td>\n",
       "      <td>51.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>254.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>444.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>1.75</td>\n",
       "      <td>8.377358</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Christian Watson</td>\n",
       "      <td>4.0</td>\n",
       "      <td>77.1</td>\n",
       "      <td>63.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>611.0</td>\n",
       "      <td>264.0</td>\n",
       "      <td>2.26</td>\n",
       "      <td>9.400000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>Wan'Dale Robinson</td>\n",
       "      <td>3.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>1.76</td>\n",
       "      <td>7.566667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>Tyquan Thornton</td>\n",
       "      <td>1.0</td>\n",
       "      <td>55.2</td>\n",
       "      <td>29.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>247.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.76</td>\n",
       "      <td>5.744186</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>George Pickens</td>\n",
       "      <td>7.0</td>\n",
       "      <td>68.8</td>\n",
       "      <td>42.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>580.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>801.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>1.38</td>\n",
       "      <td>9.535714</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>Alec Pierce</td>\n",
       "      <td>3.0</td>\n",
       "      <td>61.3</td>\n",
       "      <td>47.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>478.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>593.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>1.24</td>\n",
       "      <td>7.802632</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>Skyy Moore</td>\n",
       "      <td>7.0</td>\n",
       "      <td>70.9</td>\n",
       "      <td>30.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>1.50</td>\n",
       "      <td>7.812500</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>Velus Jones Jr.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.9</td>\n",
       "      <td>44.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>1.51</td>\n",
       "      <td>8.916667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>Jalen Tolbert</td>\n",
       "      <td>0.0</td>\n",
       "      <td>48.7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.30</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>David Bell</td>\n",
       "      <td>2.0</td>\n",
       "      <td>52.5</td>\n",
       "      <td>20.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>305.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>214.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>0.70</td>\n",
       "      <td>6.687500</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Danny Gray</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53.8</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.34</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Erik Ezukanma</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59.7</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Romeo Doubs</td>\n",
       "      <td>1.0</td>\n",
       "      <td>62.6</td>\n",
       "      <td>26.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>312.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>425.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>1.36</td>\n",
       "      <td>6.640625</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Khalil Shakir</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.4</td>\n",
       "      <td>31.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>1.14</td>\n",
       "      <td>9.470588</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>Montrell Washington</td>\n",
       "      <td>1.0</td>\n",
       "      <td>56.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Kyle Philips</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.7</td>\n",
       "      <td>21.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1.63</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>Jalen Nailor</td>\n",
       "      <td>1.0</td>\n",
       "      <td>91.6</td>\n",
       "      <td>47.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>5.77</td>\n",
       "      <td>14.916667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>Michael Woods II</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53.5</td>\n",
       "      <td>15.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.48</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>Dareke Young</td>\n",
       "      <td>1.0</td>\n",
       "      <td>58.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.77</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>Samori Toure</td>\n",
       "      <td>1.0</td>\n",
       "      <td>49.3</td>\n",
       "      <td>37.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.03</td>\n",
       "      <td>9.111111</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>Ja'Marr Chase</td>\n",
       "      <td>19.0</td>\n",
       "      <td>83.1</td>\n",
       "      <td>82.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>579.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>1455.0</td>\n",
       "      <td>657.0</td>\n",
       "      <td>2.51</td>\n",
       "      <td>11.829268</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>Jaylen Waddle</td>\n",
       "      <td>11.0</td>\n",
       "      <td>78.3</td>\n",
       "      <td>57.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>579.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>1015.0</td>\n",
       "      <td>455.0</td>\n",
       "      <td>1.75</td>\n",
       "      <td>7.355072</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>DeVonta Smith</td>\n",
       "      <td>6.0</td>\n",
       "      <td>77.2</td>\n",
       "      <td>46.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>517.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>916.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>1.77</td>\n",
       "      <td>9.069307</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>Kadarius Toney</td>\n",
       "      <td>12.0</td>\n",
       "      <td>72.8</td>\n",
       "      <td>38.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>420.0</td>\n",
       "      <td>234.0</td>\n",
       "      <td>2.14</td>\n",
       "      <td>7.924528</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>Rashod Bateman</td>\n",
       "      <td>2.0</td>\n",
       "      <td>64.9</td>\n",
       "      <td>36.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>515.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>1.26</td>\n",
       "      <td>7.923077</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0               Player  avoided_tackles  grades_offense  longest  \\\n",
       "0            0         Drake London              8.0            83.2     40.0   \n",
       "1            1       Garrett Wilson             22.0            82.7     60.0   \n",
       "2            2          Chris Olave              2.0            82.5     53.0   \n",
       "3            3     Jameson Williams              0.0            63.4     41.0   \n",
       "4            4         Jahan Dotson              2.0            70.5     61.0   \n",
       "5            5        Treylon Burks              4.0            74.1     51.0   \n",
       "6            6     Christian Watson              4.0            77.1     63.0   \n",
       "7            7    Wan'Dale Robinson              3.0            72.0     19.0   \n",
       "8            8      Tyquan Thornton              1.0            55.2     29.0   \n",
       "9            9       George Pickens              7.0            68.8     42.0   \n",
       "10          10          Alec Pierce              3.0            61.3     47.0   \n",
       "11          11           Skyy Moore              7.0            70.9     30.0   \n",
       "12          12      Velus Jones Jr.              0.0            64.9     44.0   \n",
       "13          13        Jalen Tolbert              0.0            48.7      8.0   \n",
       "14          14           David Bell              2.0            52.5     20.0   \n",
       "15          15           Danny Gray              0.0            53.8     10.0   \n",
       "16          16        Erik Ezukanma              0.0            59.7      3.0   \n",
       "17          17          Romeo Doubs              1.0            62.6     26.0   \n",
       "18          18        Khalil Shakir              0.0            62.4     31.0   \n",
       "19          19  Montrell Washington              1.0            56.6      4.0   \n",
       "20          20         Kyle Philips              0.0            63.7     21.0   \n",
       "21          21         Jalen Nailor              1.0            91.6     47.0   \n",
       "22          22     Michael Woods II              0.0            53.5     15.0   \n",
       "23          23         Dareke Young              1.0            58.9     12.0   \n",
       "24          24         Samori Toure              1.0            49.3     37.0   \n",
       "25          25        Ja'Marr Chase             19.0            83.1     82.0   \n",
       "26          26        Jaylen Waddle             11.0            78.3     57.0   \n",
       "27          27        DeVonta Smith              6.0            77.2     46.0   \n",
       "28          28       Kadarius Toney             12.0            72.8     38.0   \n",
       "29          29       Rashod Bateman              2.0            64.9     36.0   \n",
       "\n",
       "    receptions  routes  targets   yards  yards_after_catch  yprr        ypt  \\\n",
       "0         72.0   419.0    114.0   866.0              231.0  2.07   7.596491   \n",
       "1         83.0   595.0    139.0  1103.0              389.0  1.85   7.935252   \n",
       "2         72.0   431.0    114.0  1044.0              219.0  2.42   9.157895   \n",
       "3          1.0    37.0      8.0    41.0                5.0  1.11   5.125000   \n",
       "4         35.0   376.0     56.0   523.0              144.0  1.39   9.339286   \n",
       "5         33.0   254.0     53.0   444.0              177.0  1.75   8.377358   \n",
       "6         41.0   270.0     65.0   611.0              264.0  2.26   9.400000   \n",
       "7         23.0   129.0     30.0   227.0              127.0  1.76   7.566667   \n",
       "8         22.0   326.0     43.0   247.0               66.0  0.76   5.744186   \n",
       "9         52.0   580.0     84.0   801.0              110.0  1.38   9.535714   \n",
       "10        41.0   478.0     76.0   593.0              111.0  1.24   7.802632   \n",
       "11        22.0   167.0     32.0   250.0              146.0  1.50   7.812500   \n",
       "12         7.0    71.0     12.0   107.0               42.0  1.51   8.916667   \n",
       "13         2.0    40.0      3.0    12.0                0.0  0.30   4.000000   \n",
       "14        24.0   305.0     32.0   214.0               74.0  0.70   6.687500   \n",
       "15         1.0    29.0      6.0    10.0                4.0  0.34   1.666667   \n",
       "16         1.0     3.0      1.0     3.0                7.0  1.00   3.000000   \n",
       "17        42.0   312.0     64.0   425.0              194.0  1.36   6.640625   \n",
       "18        10.0   141.0     17.0   161.0               75.0  1.14   9.470588   \n",
       "19         4.0    52.0     10.0     2.0               14.0  0.04   0.200000   \n",
       "20         8.0    48.0     13.0    78.0               19.0  1.63   6.000000   \n",
       "21         9.0    31.0     12.0   179.0               68.0  5.77  14.916667   \n",
       "22         5.0    93.0     10.0    45.0               16.0  0.48   4.500000   \n",
       "23         2.0    31.0      2.0    24.0               24.0  0.77  12.000000   \n",
       "24         5.0    80.0      9.0    82.0               10.0  1.03   9.111111   \n",
       "25        81.0   579.0    123.0  1455.0              657.0  2.51  11.829268   \n",
       "26       104.0   579.0    138.0  1015.0              455.0  1.75   7.355072   \n",
       "27        64.0   517.0    101.0   916.0              208.0  1.77   9.069307   \n",
       "28        39.0   196.0     53.0   420.0              234.0  2.14   7.924528   \n",
       "29        46.0   409.0     65.0   515.0              168.0  1.26   7.923077   \n",
       "\n",
       "    1,000 Yard Seasons  \n",
       "0                    0  \n",
       "1                    2  \n",
       "2                    2  \n",
       "3                    0  \n",
       "4                    0  \n",
       "5                    0  \n",
       "6                    0  \n",
       "7                    0  \n",
       "8                    0  \n",
       "9                    1  \n",
       "10                   0  \n",
       "11                   0  \n",
       "12                   0  \n",
       "13                   0  \n",
       "14                   0  \n",
       "15                   0  \n",
       "16                   0  \n",
       "17                   0  \n",
       "18                   0  \n",
       "19                   0  \n",
       "20                   0  \n",
       "21                   0  \n",
       "22                   0  \n",
       "23                   0  \n",
       "24                   0  \n",
       "25                   3  \n",
       "26                   3  \n",
       "27                   2  \n",
       "28                   0  \n",
       "29                   0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train = pd.read_csv('wr_data.csv')\n",
    "train.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b704b76a-98fa-40ce-b017-8afa02ac9011",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Player</th>\n",
       "      <th>avoided_tackles</th>\n",
       "      <th>grades_offense</th>\n",
       "      <th>longest</th>\n",
       "      <th>receptions</th>\n",
       "      <th>routes</th>\n",
       "      <th>targets</th>\n",
       "      <th>yards</th>\n",
       "      <th>yards_after_catch</th>\n",
       "      <th>yprr</th>\n",
       "      <th>ypt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Jaxon Smith-Njigba</td>\n",
       "      <td>6.0</td>\n",
       "      <td>63.3</td>\n",
       "      <td>35.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>477.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>628.0</td>\n",
       "      <td>370.0</td>\n",
       "      <td>1.32</td>\n",
       "      <td>6.977778</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0              Player  avoided_tackles  grades_offense  longest  \\\n",
       "0           0  Jaxon Smith-Njigba              6.0            63.3     35.0   \n",
       "\n",
       "   receptions  routes  targets  yards  yards_after_catch  yprr       ypt  \n",
       "0        63.0   477.0     90.0  628.0              370.0  1.32  6.977778  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test = pd.read_csv('rookie_23.csv')\n",
    "test.head(1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "3a64ad1c-cc96-4c82-a149-193d3311d60b",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "def onek_fun(x):\n",
    "    if x == 0:\n",
    "        x = 0\n",
    "    else:\n",
    "        x = 1\n",
    "    return x\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "712b0cf1-7cfc-4e80-beb3-33513c2b360e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Player</th>\n",
       "      <th>avoided_tackles</th>\n",
       "      <th>grades_offense</th>\n",
       "      <th>longest</th>\n",
       "      <th>receptions</th>\n",
       "      <th>routes</th>\n",
       "      <th>targets</th>\n",
       "      <th>yards</th>\n",
       "      <th>yards_after_catch</th>\n",
       "      <th>yprr</th>\n",
       "      <th>ypt</th>\n",
       "      <th>1,000 Yard Seasons</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Drake London</td>\n",
       "      <td>8.0</td>\n",
       "      <td>83.2</td>\n",
       "      <td>40.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>419.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>866.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>2.07</td>\n",
       "      <td>7.596491</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Garrett Wilson</td>\n",
       "      <td>22.0</td>\n",
       "      <td>82.7</td>\n",
       "      <td>60.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>595.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>1103.0</td>\n",
       "      <td>389.0</td>\n",
       "      <td>1.85</td>\n",
       "      <td>7.935252</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Chris Olave</td>\n",
       "      <td>2.0</td>\n",
       "      <td>82.5</td>\n",
       "      <td>53.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>431.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1044.0</td>\n",
       "      <td>219.0</td>\n",
       "      <td>2.42</td>\n",
       "      <td>9.157895</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Jameson Williams</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.4</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.11</td>\n",
       "      <td>5.125000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Jahan Dotson</td>\n",
       "      <td>2.0</td>\n",
       "      <td>70.5</td>\n",
       "      <td>61.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>523.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>1.39</td>\n",
       "      <td>9.339286</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Treylon Burks</td>\n",
       "      <td>4.0</td>\n",
       "      <td>74.1</td>\n",
       "      <td>51.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>254.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>444.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>1.75</td>\n",
       "      <td>8.377358</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Christian Watson</td>\n",
       "      <td>4.0</td>\n",
       "      <td>77.1</td>\n",
       "      <td>63.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>611.0</td>\n",
       "      <td>264.0</td>\n",
       "      <td>2.26</td>\n",
       "      <td>9.400000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>Wan'Dale Robinson</td>\n",
       "      <td>3.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>1.76</td>\n",
       "      <td>7.566667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>Tyquan Thornton</td>\n",
       "      <td>1.0</td>\n",
       "      <td>55.2</td>\n",
       "      <td>29.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>247.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.76</td>\n",
       "      <td>5.744186</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>George Pickens</td>\n",
       "      <td>7.0</td>\n",
       "      <td>68.8</td>\n",
       "      <td>42.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>580.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>801.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>1.38</td>\n",
       "      <td>9.535714</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>Alec Pierce</td>\n",
       "      <td>3.0</td>\n",
       "      <td>61.3</td>\n",
       "      <td>47.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>478.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>593.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>1.24</td>\n",
       "      <td>7.802632</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>Skyy Moore</td>\n",
       "      <td>7.0</td>\n",
       "      <td>70.9</td>\n",
       "      <td>30.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>1.50</td>\n",
       "      <td>7.812500</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>Velus Jones Jr.</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.9</td>\n",
       "      <td>44.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>1.51</td>\n",
       "      <td>8.916667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>Jalen Tolbert</td>\n",
       "      <td>0.0</td>\n",
       "      <td>48.7</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.30</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>David Bell</td>\n",
       "      <td>2.0</td>\n",
       "      <td>52.5</td>\n",
       "      <td>20.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>305.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>214.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>0.70</td>\n",
       "      <td>6.687500</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Danny Gray</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53.8</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.34</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Erik Ezukanma</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59.7</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Romeo Doubs</td>\n",
       "      <td>1.0</td>\n",
       "      <td>62.6</td>\n",
       "      <td>26.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>312.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>425.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>1.36</td>\n",
       "      <td>6.640625</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Khalil Shakir</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.4</td>\n",
       "      <td>31.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>1.14</td>\n",
       "      <td>9.470588</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>Montrell Washington</td>\n",
       "      <td>1.0</td>\n",
       "      <td>56.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Kyle Philips</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63.7</td>\n",
       "      <td>21.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1.63</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>Jalen Nailor</td>\n",
       "      <td>1.0</td>\n",
       "      <td>91.6</td>\n",
       "      <td>47.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>5.77</td>\n",
       "      <td>14.916667</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>Michael Woods II</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53.5</td>\n",
       "      <td>15.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.48</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>Dareke Young</td>\n",
       "      <td>1.0</td>\n",
       "      <td>58.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.77</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>Samori Toure</td>\n",
       "      <td>1.0</td>\n",
       "      <td>49.3</td>\n",
       "      <td>37.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.03</td>\n",
       "      <td>9.111111</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>Ja'Marr Chase</td>\n",
       "      <td>19.0</td>\n",
       "      <td>83.1</td>\n",
       "      <td>82.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>579.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>1455.0</td>\n",
       "      <td>657.0</td>\n",
       "      <td>2.51</td>\n",
       "      <td>11.829268</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>Jaylen Waddle</td>\n",
       "      <td>11.0</td>\n",
       "      <td>78.3</td>\n",
       "      <td>57.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>579.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>1015.0</td>\n",
       "      <td>455.0</td>\n",
       "      <td>1.75</td>\n",
       "      <td>7.355072</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>DeVonta Smith</td>\n",
       "      <td>6.0</td>\n",
       "      <td>77.2</td>\n",
       "      <td>46.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>517.0</td>\n",
       "      <td>101.0</td>\n",
       "      <td>916.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>1.77</td>\n",
       "      <td>9.069307</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>Kadarius Toney</td>\n",
       "      <td>12.0</td>\n",
       "      <td>72.8</td>\n",
       "      <td>38.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>420.0</td>\n",
       "      <td>234.0</td>\n",
       "      <td>2.14</td>\n",
       "      <td>7.924528</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>Rashod Bateman</td>\n",
       "      <td>2.0</td>\n",
       "      <td>64.9</td>\n",
       "      <td>36.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>515.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>1.26</td>\n",
       "      <td>7.923077</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0               Player  avoided_tackles  grades_offense  longest  \\\n",
       "0            0         Drake London              8.0            83.2     40.0   \n",
       "1            1       Garrett Wilson             22.0            82.7     60.0   \n",
       "2            2          Chris Olave              2.0            82.5     53.0   \n",
       "3            3     Jameson Williams              0.0            63.4     41.0   \n",
       "4            4         Jahan Dotson              2.0            70.5     61.0   \n",
       "5            5        Treylon Burks              4.0            74.1     51.0   \n",
       "6            6     Christian Watson              4.0            77.1     63.0   \n",
       "7            7    Wan'Dale Robinson              3.0            72.0     19.0   \n",
       "8            8      Tyquan Thornton              1.0            55.2     29.0   \n",
       "9            9       George Pickens              7.0            68.8     42.0   \n",
       "10          10          Alec Pierce              3.0            61.3     47.0   \n",
       "11          11           Skyy Moore              7.0            70.9     30.0   \n",
       "12          12      Velus Jones Jr.              0.0            64.9     44.0   \n",
       "13          13        Jalen Tolbert              0.0            48.7      8.0   \n",
       "14          14           David Bell              2.0            52.5     20.0   \n",
       "15          15           Danny Gray              0.0            53.8     10.0   \n",
       "16          16        Erik Ezukanma              0.0            59.7      3.0   \n",
       "17          17          Romeo Doubs              1.0            62.6     26.0   \n",
       "18          18        Khalil Shakir              0.0            62.4     31.0   \n",
       "19          19  Montrell Washington              1.0            56.6      4.0   \n",
       "20          20         Kyle Philips              0.0            63.7     21.0   \n",
       "21          21         Jalen Nailor              1.0            91.6     47.0   \n",
       "22          22     Michael Woods II              0.0            53.5     15.0   \n",
       "23          23         Dareke Young              1.0            58.9     12.0   \n",
       "24          24         Samori Toure              1.0            49.3     37.0   \n",
       "25          25        Ja'Marr Chase             19.0            83.1     82.0   \n",
       "26          26        Jaylen Waddle             11.0            78.3     57.0   \n",
       "27          27        DeVonta Smith              6.0            77.2     46.0   \n",
       "28          28       Kadarius Toney             12.0            72.8     38.0   \n",
       "29          29       Rashod Bateman              2.0            64.9     36.0   \n",
       "\n",
       "    receptions  routes  targets   yards  yards_after_catch  yprr        ypt  \\\n",
       "0         72.0   419.0    114.0   866.0              231.0  2.07   7.596491   \n",
       "1         83.0   595.0    139.0  1103.0              389.0  1.85   7.935252   \n",
       "2         72.0   431.0    114.0  1044.0              219.0  2.42   9.157895   \n",
       "3          1.0    37.0      8.0    41.0                5.0  1.11   5.125000   \n",
       "4         35.0   376.0     56.0   523.0              144.0  1.39   9.339286   \n",
       "5         33.0   254.0     53.0   444.0              177.0  1.75   8.377358   \n",
       "6         41.0   270.0     65.0   611.0              264.0  2.26   9.400000   \n",
       "7         23.0   129.0     30.0   227.0              127.0  1.76   7.566667   \n",
       "8         22.0   326.0     43.0   247.0               66.0  0.76   5.744186   \n",
       "9         52.0   580.0     84.0   801.0              110.0  1.38   9.535714   \n",
       "10        41.0   478.0     76.0   593.0              111.0  1.24   7.802632   \n",
       "11        22.0   167.0     32.0   250.0              146.0  1.50   7.812500   \n",
       "12         7.0    71.0     12.0   107.0               42.0  1.51   8.916667   \n",
       "13         2.0    40.0      3.0    12.0                0.0  0.30   4.000000   \n",
       "14        24.0   305.0     32.0   214.0               74.0  0.70   6.687500   \n",
       "15         1.0    29.0      6.0    10.0                4.0  0.34   1.666667   \n",
       "16         1.0     3.0      1.0     3.0                7.0  1.00   3.000000   \n",
       "17        42.0   312.0     64.0   425.0              194.0  1.36   6.640625   \n",
       "18        10.0   141.0     17.0   161.0               75.0  1.14   9.470588   \n",
       "19         4.0    52.0     10.0     2.0               14.0  0.04   0.200000   \n",
       "20         8.0    48.0     13.0    78.0               19.0  1.63   6.000000   \n",
       "21         9.0    31.0     12.0   179.0               68.0  5.77  14.916667   \n",
       "22         5.0    93.0     10.0    45.0               16.0  0.48   4.500000   \n",
       "23         2.0    31.0      2.0    24.0               24.0  0.77  12.000000   \n",
       "24         5.0    80.0      9.0    82.0               10.0  1.03   9.111111   \n",
       "25        81.0   579.0    123.0  1455.0              657.0  2.51  11.829268   \n",
       "26       104.0   579.0    138.0  1015.0              455.0  1.75   7.355072   \n",
       "27        64.0   517.0    101.0   916.0              208.0  1.77   9.069307   \n",
       "28        39.0   196.0     53.0   420.0              234.0  2.14   7.924528   \n",
       "29        46.0   409.0     65.0   515.0              168.0  1.26   7.923077   \n",
       "\n",
       "    1,000 Yard Seasons  \n",
       "0                    0  \n",
       "1                    1  \n",
       "2                    1  \n",
       "3                    0  \n",
       "4                    0  \n",
       "5                    0  \n",
       "6                    0  \n",
       "7                    0  \n",
       "8                    0  \n",
       "9                    1  \n",
       "10                   0  \n",
       "11                   0  \n",
       "12                   0  \n",
       "13                   0  \n",
       "14                   0  \n",
       "15                   0  \n",
       "16                   0  \n",
       "17                   0  \n",
       "18                   0  \n",
       "19                   0  \n",
       "20                   0  \n",
       "21                   0  \n",
       "22                   0  \n",
       "23                   0  \n",
       "24                   0  \n",
       "25                   1  \n",
       "26                   1  \n",
       "27                   1  \n",
       "28                   0  \n",
       "29                   0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train['1,000 Yard Seasons'] = train['1,000 Yard Seasons'].apply(onek_fun)\n",
    "train.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f64d575c-71cc-4107-a3fe-876ccb20bac3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "feb19d69-3436-41b1-9b08-7a402bb81500",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 346 entries, 0 to 345\n",
      "Data columns (total 13 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   Unnamed: 0          346 non-null    int64  \n",
      " 1   Player              346 non-null    object \n",
      " 2   avoided_tackles     346 non-null    float64\n",
      " 3   grades_offense      346 non-null    float64\n",
      " 4   longest             346 non-null    float64\n",
      " 5   receptions          346 non-null    float64\n",
      " 6   routes              346 non-null    float64\n",
      " 7   targets             346 non-null    float64\n",
      " 8   yards               346 non-null    float64\n",
      " 9   yards_after_catch   346 non-null    float64\n",
      " 10  yprr                346 non-null    float64\n",
      " 11  ypt                 346 non-null    float64\n",
      " 12  1,000 Yard Seasons  346 non-null    int64  \n",
      "dtypes: float64(10), int64(2), object(1)\n",
      "memory usage: 35.3+ KB\n"
     ]
    }
   ],
   "source": [
    "test2 = test\n",
    "train.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "9b60bf3e-5e6b-4018-9ae2-a638dbc1cdb4",
   "metadata": {},
   "outputs": [],
   "source": [
    "features = [#'avoided_tackles', 'grades_offense', 'longest',\n",
    "       'receptions', \n",
    "    #'routes',\n",
    "    'targets', 'yards', \n",
    "    #'yards_after_catch',\n",
    "    'yprr',\n",
    "       'ypt']\n",
    "prediction_class = ['1,000 Yard Seasons']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "359609ab-e3b2-4661-9150-c2d946b7de4d",
   "metadata": {},
   "outputs": [],
   "source": [
    "X = train[features].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "6bc277fd-a305-42a3-9515-e252bbb103fa",
   "metadata": {},
   "outputs": [],
   "source": [
    "Y = train[prediction_class].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "c934bae3-8d70-4379-9c6e-3d3cef17738d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(numpy.ndarray, numpy.ndarray)"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " type(X), type(Y)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "8c6c8634-cfad-44e6-abb7-c0711bb2bf0b",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "\n",
    "x_train, x_test, y_train, y_test = train_test_split(X, Y, test_size=0.2)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "9270d5a7-9d18-4c73-934e-7b026ae65e92",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Training set has 276 samples.\n",
      "Testing set has 70 samples.\n"
     ]
    }
   ],
   "source": [
    "\n",
    "\n",
    "clf = GradientBoostingClassifier(n_estimators=100,  random_state=1)\n",
    "\n",
    "clf.fit(x_train[:310], y_train[:310].ravel())\n",
    "print(\"Training set has {} samples.\".format(x_train.shape[0]))\n",
    "print(\"Testing set has {} samples.\".format(x_test.shape[0]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "3390786f-ac7b-4d40-a295-177ef30a3f75",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0,\n",
       "       0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0,\n",
       "       0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,\n",
       "       0, 0, 0, 0], dtype=int64)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "predictions = clf.predict(x_test)\n",
    "predictions\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "d9b4efca-a2e7-4c49-8f26-38a7562bb7e0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mean Squared Error: 0.12857142857142856\n"
     ]
    }
   ],
   "source": [
    "\n",
    "mse = mean_squared_error(y_test, predictions)\n",
    "print(\"Mean Squared Error:\", mse)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dbdeb8c0-c2ed-4442-af98-01f3e65c2a79",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "81814421-c0a9-4464-a5da-5dd8da3534b9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The accuracy is:  87.14285714285714\n"
     ]
    }
   ],
   "source": [
    "print('The accuracy is: ', accuracy_score(y_test, predictions)*100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "f2650506-4f44-4507-a55a-1ddcbd8db53e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.8714285714285714\n"
     ]
    }
   ],
   "source": [
    "fscore = clf.score(x_test, y_test)\n",
    "print(fscore)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "4a9979e7-ab0c-40fe-b1d7-35f109720372",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    Actual Values  Predictions\n",
      "0               1            1\n",
      "1               0            0\n",
      "2               1            1\n",
      "3               0            0\n",
      "4               0            0\n",
      "..            ...          ...\n",
      "65              0            0\n",
      "66              0            0\n",
      "67              0            0\n",
      "68              0            0\n",
      "69              0            0\n",
      "\n",
      "[70 rows x 2 columns]\n"
     ]
    }
   ],
   "source": [
    "results = pd.DataFrame()\n",
    "results[['Actual Values']] = y_test\n",
    "results['Predictions'] = predictions\n",
    "print(results)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "126bbcbc-f295-4814-aee4-a955b57fbd90",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Initialize the classifier\n",
    "gb = GradientBoostingClassifier(random_state = 1)\n",
    "\n",
    "\n",
    "\n",
    "# parameters\n",
    "parameters = {'n_estimators' :[50, 100, 150, 200, 250], 'learning_rate': [0.01, 0.05, .1, .5, 1.0], 'max_depth': [3, 5, 7, 8, 9]}\n",
    "\n",
    "\n",
    "\n",
    "grid_search = GridSearchCV(gb, parameters, cv=5, scoring='accuracy')\n",
    "grid_search.fit(x_train, y_train.ravel())\n",
    "\n",
    "best_params = grid_search.best_params_\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "da11d358-8c4d-40f1-995c-10a27ef39f10",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'learning_rate': 0.05, 'max_depth': 3, 'n_estimators': 50}"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "best_params\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "1e5b585e-b130-434e-8dc8-5267837682c2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mean Squared Error: 0.11428571428571428\n",
      "The accuracy is:  88.57142857142857\n",
      "0.8857142857142857\n"
     ]
    }
   ],
   "source": [
    "clf2 = GradientBoostingClassifier(n_estimators=50, learning_rate=0.05, max_depth=3, random_state=1)\n",
    "\n",
    "clf2.fit(x_train[:310], y_train[:310].ravel())\n",
    "predictions = clf2.predict(x_test)\n",
    "mse = mean_squared_error(y_test, predictions)\n",
    "fscore = clf2.score(x_test, y_test)\n",
    "print(\"Mean Squared Error:\", mse)\n",
    "print('The accuracy is: ', accuracy_score(y_test, predictions)*100)\n",
    "print(fscore)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "d1903fd2-e0b1-4b29-aca9-5cae40d9fc27",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    Actual Values  Predictions\n",
      "0               1            1\n",
      "1               0            0\n",
      "2               1            1\n",
      "3               0            0\n",
      "4               0            0\n",
      "..            ...          ...\n",
      "65              0            0\n",
      "66              0            0\n",
      "67              0            0\n",
      "68              0            0\n",
      "69              0            0\n",
      "\n",
      "[70 rows x 2 columns]\n"
     ]
    }
   ],
   "source": [
    "results = pd.DataFrame()\n",
    "results[['Actual Values']] = y_test\n",
    "results['Predictions'] = predictions\n",
    "print(results)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "b424fc30-e074-41ba-9a8c-a1462b1598fb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Player</th>\n",
       "      <th>avoided_tackles</th>\n",
       "      <th>grades_offense</th>\n",
       "      <th>longest</th>\n",
       "      <th>receptions</th>\n",
       "      <th>routes</th>\n",
       "      <th>targets</th>\n",
       "      <th>yards</th>\n",
       "      <th>yards_after_catch</th>\n",
       "      <th>yprr</th>\n",
       "      <th>ypt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Jaxon Smith-Njigba</td>\n",
       "      <td>6.0</td>\n",
       "      <td>63.3</td>\n",
       "      <td>35.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>477.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>628.0</td>\n",
       "      <td>370.0</td>\n",
       "      <td>1.32</td>\n",
       "      <td>6.977778</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0              Player  avoided_tackles  grades_offense  longest  \\\n",
       "0           0  Jaxon Smith-Njigba              6.0            63.3     35.0   \n",
       "\n",
       "   receptions  routes  targets  yards  yards_after_catch  yprr       ypt  \n",
       "0        63.0   477.0     90.0  628.0              370.0  1.32  6.977778  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_23 = pd.read_csv('rookie_23.csv')\n",
    "test_23.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6a1bcff2-2073-4abf-9f72-770a2dc2e585",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "ecb9499a-99f4-4c9e-a745-5e5bb62dc622",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['model.pkl']"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import joblib\n",
    "#saving ML model\n",
    "\n",
    "joblib.dump(clf2, \"model.pkl\") "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7334c819-cf46-436a-a775-db65281245f6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "834611ba-e7dc-40f2-99f8-165b824ca164",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\remsteele\\anaconda3\\Lib\\site-packages\\sklearn\\base.py:486: UserWarning: X has feature names, but GradientBoostingClassifier was fitted without feature names\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "clf3 = joblib.load(\"model.pkl\")\n",
    "X = test_23[[ #'avoided_tackles', 'grades_offense', 'longest',\n",
    "       'receptions', \n",
    "    #'routes',\n",
    "    'targets', 'yards', \n",
    "    #'yards_after_catch',\n",
    "    'yprr',\n",
    "       'ypt']]\n",
    "predictions = clf3.predict(X)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "2980492d-f7a3-4d51-91c8-09357fd44393",
   "metadata": {},
   "outputs": [],
   "source": [
    "lista = predictions.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "0692c213-5fce-49a4-892b-3abf2b689c95",
   "metadata": {},
   "outputs": [],
   "source": [
    "db1 = test_23['Player']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "0d6bf14a-8c4b-47b1-83a8-0bbf259ab064",
   "metadata": {},
   "outputs": [],
   "source": [
    "clf3_db = pd.DataFrame(lista, columns=['Future 1k Seasons'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "86d66a2a-123a-4e6f-86e9-702c1eb1429d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jaxon Smith-Njigba</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Quentin Johnston</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Zay Flowers</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Jordan Addison</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jonathan Mingo</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Jayden Reed</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rashee Rice</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Tank Dell</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Jalin Hyatt</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Cedric Tillman</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Josh Downs</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Michael Wilson</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Tre Tucker</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Derius Davis</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Charlie Jones</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Tyler Scott</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Dontayvion Wicks</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Puka Nacua</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Parker Washington</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Kayshon Boutte</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Trey Palmer</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>A.T. Perry</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Elijah Higgins</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Xavier Hutchinson</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Andrei Iosivas</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Demario Douglas</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Antoine Green</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Colton Dowell</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Jalen Brooks</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Ronnie Bell</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     0  1\n",
       "0   Jaxon Smith-Njigba  0\n",
       "1     Quentin Johnston  0\n",
       "2          Zay Flowers  1\n",
       "3       Jordan Addison  1\n",
       "4       Jonathan Mingo  0\n",
       "5          Jayden Reed  1\n",
       "6          Rashee Rice  1\n",
       "7            Tank Dell  1\n",
       "8          Jalin Hyatt  0\n",
       "9       Cedric Tillman  0\n",
       "10          Josh Downs  1\n",
       "11      Michael Wilson  0\n",
       "12          Tre Tucker  0\n",
       "13        Derius Davis  0\n",
       "14       Charlie Jones  0\n",
       "15         Tyler Scott  0\n",
       "16    Dontayvion Wicks  0\n",
       "17          Puka Nacua  1\n",
       "18   Parker Washington  0\n",
       "19      Kayshon Boutte  0\n",
       "20         Trey Palmer  0\n",
       "21          A.T. Perry  0\n",
       "22      Elijah Higgins  0\n",
       "23   Xavier Hutchinson  0\n",
       "24      Andrei Iosivas  0\n",
       "25     Demario Douglas  1\n",
       "26       Antoine Green  0\n",
       "27       Colton Dowell  0\n",
       "28        Jalen Brooks  0\n",
       "29         Ronnie Bell  0"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 1 shows players it predicts to have future 1k yard seasons\n",
    "df_result = pd.concat([db1, clf3_db],axis=1, ignore_index=True, sort=False)\n",
    "df_result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a7704d69-a066-4df4-b480-748a42a42a9f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "429f1c15-412b-402a-a4c5-bdd255ba2d77",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6d2a6b48-27ef-484f-8975-41fd1299cdad",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}