{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## IDENTIFYING MOST COMMON NBA PLAYERS FROM THE 2017 DRAFT CLASS USING PCA DIMENSIONALITY REDUCTION AND K NEAREST NEIGHBORS ALGORITHM\n",
    "\n",
    "**Its so common that we hear talking heads tell us about how Lonzo Ball looks like the next Jason Kidd, or how John Jackson is a better shooting version of Kawhi Leonard.  But there's a lot of inherent bias in the prognostications. One - they're limited to players we're familiar with; Two - we choose to see certain aspects of a players' game, wanted to describe someone as a great shooter, or passer, or rebounder. The goal of this analysis is to strip away those biases and get the most accurate comparisons possible, using the best data we have available. **\n",
    "\n",
    "The approach is pretty straightforward, and is outlined below before digging into all of the code.\n",
    "\n",
    "* Take every player who has been drafted since 2010 - who also played in the NCAA\n",
    "* Append their basic and advanced college stats from CBB Reference\n",
    "* Take all NCAA players from this season and retrieve their advanced stats as well. \n",
    "* Since we have about 36 different statistics - there's alot of covariance among our features, so we'll perform something called \"dimensionality reduction\" to reduce them to the fewest # of features that can explain the variance we see in our dataset\n",
    "* Take every player and measure their euclidean distance to every other player in the dataset \n",
    "* Limit the dataset to NCAA players compared to NBA players (this is the comparison we wanted to make from the beginning)\n",
    "* return every NBA player and sort by ascending distance metric\n",
    "* limit to Chad Fords top 50 and export to CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#import necessary libraries\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from time import sleep \n",
    "from scipy.spatial import distance\n",
    "from scipy.spatial.distance import squareform\n",
    "from scipy.spatial.distance import pdist\n",
    "from sklearn.decomposition import PCA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#read in datasets\n",
    "nba = pd.read_csv(\"nba_draft_picks_final.csv\")\n",
    "\n",
    "df = pd.read_csv(\"ncaa_stats.csv\")\n",
    "df.drop('Unnamed: 0',axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 228,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#scrape data from bbref if pulling data for the first time\n",
    "#df = pd.read_html(\"http://www.sports-reference.com/cbb/play-index/psl_finder.cgi?request=1&match=single&year_min=2011&year_max=&conf_id=&school_id=&class_is_fr=Y&class_is_so=Y&class_is_jr=Y&class_is_sr=Y&pos_is_g=Y&pos_is_gf=Y&pos_is_fg=Y&pos_is_f=Y&pos_is_fc=Y&pos_is_cf=Y&pos_is_c=Y&games_type=A&qual=pts_per_g&c1stat=mp_per_g&c1comp=gt&c1val=10&c2stat=pts_per_g&c2comp=gt&c2val=5&c3stat=&c3comp=&c3val=&c4stat=&c4comp=&c4val=&order_by=bpm&order_by_asc=\")[0]\n",
    "#i = 100\n",
    "\n",
    "#while(i < 15000):\n",
    "#    print(\"Number of players retrieved:\", str(i))\n",
    "#    df = df.append(pd.read_html(\"http://www.sports-reference.com/cbb/play-index/psl_finder.cgi?request=1&match=single&year_min=2011&year_max=&conf_id=&school_id=&class_is_fr=Y&class_is_so=Y&class_is_jr=Y&class_is_sr=Y&pos_is_g=Y&pos_is_gf=Y&pos_is_fg=Y&pos_is_f=Y&pos_is_fc=Y&pos_is_cf=Y&pos_is_c=Y&games_type=A&qual=pts_per_g&c1stat=mp_per_g&c1comp=gt&c1val=10&c2stat=pts_per_g&c2comp=gt&c2val=5&c3stat=&c3comp=&c3val=&c4stat=&c4comp=&c4val=&order_by=bpm&order_by_asc=&offset=\"+str(i))[0])\n",
    "#    i = i+100\n",
    "#    sleep(10)\n",
    "\n",
    "#realign columns properly\n",
    "#cols = ['Rk', 'Player', 'Class', 'Season',\n",
    "#       'Pos', 'School', 'Conf', 'G', 'MP', 'MP.1', 'FG', 'FGA', '2P', '2PA',\n",
    "#       '3P', '3PA', 'FT', 'FTA', 'ORB', 'DRB', 'TRB', 'AST', 'STL', 'BLK',\n",
    "#       'TOV', 'PF', 'PTS', 'PER', 'TS%', 'eFG%', 'ORB%', 'DRB%', 'TRB%',\n",
    "#       'AST%', 'STL%', 'BLK%', 'TOV%', 'USG%', 'PProd', 'ORtg', 'DRtg', 'OWS',\n",
    "#       'DWS', 'WS', 'OBPM', 'DBPM', 'BPM','drop1','drop2','drop3']\n",
    "\n",
    "#df.columns = cols\n",
    "\n",
    "#df.drop(['drop1','drop2','drop3'], axis=1, inplace=True)\n",
    "\n",
    "#df = df.drop(df[df.Class == 'Advanced'].index)\n",
    "#df = df.drop(df[df.Class == 'Class'].index)\n",
    "\n",
    "#send to CSV for perpetuity\n",
    "#df.to_csv(\"ncaa_stats.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#get the max year for each player (only one row for the season)\n",
    "df_new = df.groupby(['Player'])['Season'].transform(max) == df['Season']\n",
    "\n",
    "stats = df[df_new]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#limit to the few columns we need from the NBA dataset\n",
    "nba = nba[['Player','Rd','Pk','Year']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#merge nba players and get their ncaa stats\n",
    "draft_stats = pd.merge(nba,stats,on='Player',how='left')\n",
    "\n",
    "draft_stats = draft_stats.dropna(subset=['Class']) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\coreyjez\\Anaconda3\\lib\\site-packages\\ipykernel\\__main__.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  from ipykernel import kernelapp as app\n"
     ]
    }
   ],
   "source": [
    "#limit to the most recent NCAA season and drop the raw MP column (we only want Min/Gm)\n",
    "test = stats[stats['Season']== '2016-17']\n",
    "test.drop('MP',axis=1,inplace=True)\n",
    "\n",
    "draft_stats_test = draft_stats[draft_stats['Year'] < 2017]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 236,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#drop unwanted columns\n",
    "draft_stats_vars = draft_stats_test.drop(['Rd','Pk','Year','Rk','Class','Season','Pos','School','Conf','G','MP'],axis=1)\n",
    "test_16_vars = test.drop(['Class','Rk','Season','Pos','School','Conf','G'],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "test df shape: (2080, 39)\n",
      "draft df shape: (272, 39)\n"
     ]
    }
   ],
   "source": [
    "#verify they have the same # of columns\n",
    "print (\"test df shape:\",test_16_vars.shape)\n",
    "print (\"draft df shape:\",draft_stats_vars.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 238,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# concat the two DFs together into one big DF \n",
    "final = pd.concat([test_16_vars,draft_stats_vars])\n",
    "final = final.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#finally drop the player and additional index column\n",
    "df_final = final.drop(['Player','index'],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 240,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#normalize the data so that distance is equalized regardless of the scale of the metric\n",
    "final_normal = (df_final - df_final.mean()) / df_final.std()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "       MP.1        FG       FGA        2P       2PA        3P       3PA  \\\n",
      "0  1.214320  1.676989  1.813782  1.160537  1.524675  0.978063  0.792355   \n",
      "1  0.184873  1.405143  0.496129  2.210807  1.755843 -1.315460 -1.417786   \n",
      "2 -1.393613 -0.905546 -1.464283 -0.169806 -0.594367 -1.315460 -1.417786   \n",
      "3  0.339290  0.385722 -0.500146  1.090519  0.407362 -1.194749 -1.229689   \n",
      "4  0.510865 -0.157970 -0.628698 -0.309842 -0.787007  0.133081  0.039967   \n",
      "\n",
      "         FT       FTA       ORB    ...         USG%     PProd      ORtg  \\\n",
      "0  3.794487  3.365690  1.594710    ...     1.726118  2.079515  1.316056   \n",
      "1 -0.014472  0.844939  2.430493    ...     1.105218  1.340251  0.764449   \n",
      "2 -1.149055 -0.856568  0.400733    ...    -1.292741 -1.222051  0.291643   \n",
      "3 -0.095513 -0.037324  2.072300    ...    -0.736072  0.708647  1.473658   \n",
      "4 -0.662805 -0.919586 -0.076857    ...    -1.314151  0.012447  2.133616   \n",
      "\n",
      "       DRtg       OWS       DWS        WS      OBPM      DBPM       BPM  \n",
      "0 -2.210414  2.258310  2.564215  2.687228  2.628517  2.274177  3.040330  \n",
      "1 -2.560484  1.446197  2.875438  2.201929  1.684870  3.228015  2.956779  \n",
      "2 -2.088651 -0.584086  0.541266 -0.224570  0.363764  4.108481  2.580799  \n",
      "3 -2.179973  1.283774  2.875438  2.080604  1.087227  3.117957  2.497248  \n",
      "4 -1.525496  1.202563  1.941769  1.655967  1.684870  2.347549  2.455473  \n",
      "\n",
      "[5 rows x 38 columns]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>component_1</th>\n",
       "      <th>component_2</th>\n",
       "      <th>component_3</th>\n",
       "      <th>component_4</th>\n",
       "      <th>component_5</th>\n",
       "      <th>component_6</th>\n",
       "      <th>component_7</th>\n",
       "      <th>component_8</th>\n",
       "      <th>component_9</th>\n",
       "      <th>component_10</th>\n",
       "      <th>...</th>\n",
       "      <th>component_29</th>\n",
       "      <th>component_30</th>\n",
       "      <th>component_31</th>\n",
       "      <th>component_32</th>\n",
       "      <th>component_33</th>\n",
       "      <th>component_34</th>\n",
       "      <th>component_35</th>\n",
       "      <th>component_36</th>\n",
       "      <th>component_37</th>\n",
       "      <th>component_38</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.276067</td>\n",
       "      <td>1.605826</td>\n",
       "      <td>0.772921</td>\n",
       "      <td>2.503615</td>\n",
       "      <td>-1.112311</td>\n",
       "      <td>-1.594821</td>\n",
       "      <td>-0.589460</td>\n",
       "      <td>0.639170</td>\n",
       "      <td>-0.174985</td>\n",
       "      <td>1.860121</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.173023</td>\n",
       "      <td>-0.133946</td>\n",
       "      <td>-0.141375</td>\n",
       "      <td>0.002717</td>\n",
       "      <td>0.017823</td>\n",
       "      <td>-0.004699</td>\n",
       "      <td>-0.041912</td>\n",
       "      <td>0.010904</td>\n",
       "      <td>-0.005366</td>\n",
       "      <td>0.002974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8.860138</td>\n",
       "      <td>-3.794910</td>\n",
       "      <td>-0.077645</td>\n",
       "      <td>4.185647</td>\n",
       "      <td>-0.216325</td>\n",
       "      <td>-0.925672</td>\n",
       "      <td>-1.518631</td>\n",
       "      <td>-0.144931</td>\n",
       "      <td>0.604341</td>\n",
       "      <td>-1.232700</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.267700</td>\n",
       "      <td>-0.014189</td>\n",
       "      <td>0.101492</td>\n",
       "      <td>-0.010417</td>\n",
       "      <td>0.005115</td>\n",
       "      <td>-0.000098</td>\n",
       "      <td>0.002593</td>\n",
       "      <td>-0.001163</td>\n",
       "      <td>0.001736</td>\n",
       "      <td>-0.000472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.206886</td>\n",
       "      <td>-6.265915</td>\n",
       "      <td>2.390440</td>\n",
       "      <td>4.415517</td>\n",
       "      <td>0.160699</td>\n",
       "      <td>-1.142673</td>\n",
       "      <td>2.502830</td>\n",
       "      <td>3.200884</td>\n",
       "      <td>-0.197537</td>\n",
       "      <td>-0.942359</td>\n",
       "      <td>...</td>\n",
       "      <td>0.176014</td>\n",
       "      <td>-0.076339</td>\n",
       "      <td>-0.066579</td>\n",
       "      <td>-0.015415</td>\n",
       "      <td>-0.015631</td>\n",
       "      <td>-0.000041</td>\n",
       "      <td>0.002867</td>\n",
       "      <td>-0.022992</td>\n",
       "      <td>-0.002697</td>\n",
       "      <td>-0.002196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6.413919</td>\n",
       "      <td>-5.715263</td>\n",
       "      <td>2.318523</td>\n",
       "      <td>3.536236</td>\n",
       "      <td>0.269141</td>\n",
       "      <td>0.516624</td>\n",
       "      <td>1.059161</td>\n",
       "      <td>0.196717</td>\n",
       "      <td>0.208271</td>\n",
       "      <td>-1.431863</td>\n",
       "      <td>...</td>\n",
       "      <td>0.027190</td>\n",
       "      <td>0.038664</td>\n",
       "      <td>0.004368</td>\n",
       "      <td>-0.008195</td>\n",
       "      <td>0.003281</td>\n",
       "      <td>0.008977</td>\n",
       "      <td>0.004088</td>\n",
       "      <td>-0.017837</td>\n",
       "      <td>0.001622</td>\n",
       "      <td>-0.000914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2.651144</td>\n",
       "      <td>-1.205150</td>\n",
       "      <td>4.764476</td>\n",
       "      <td>4.285265</td>\n",
       "      <td>0.440931</td>\n",
       "      <td>0.745651</td>\n",
       "      <td>-0.708535</td>\n",
       "      <td>1.183168</td>\n",
       "      <td>-0.092450</td>\n",
       "      <td>-0.207216</td>\n",
       "      <td>...</td>\n",
       "      <td>0.120202</td>\n",
       "      <td>0.048320</td>\n",
       "      <td>0.073231</td>\n",
       "      <td>0.011929</td>\n",
       "      <td>0.018293</td>\n",
       "      <td>-0.037068</td>\n",
       "      <td>-0.039336</td>\n",
       "      <td>-0.005705</td>\n",
       "      <td>0.000903</td>\n",
       "      <td>-0.001435</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   component_1  component_2  component_3  component_4  component_5  \\\n",
       "0    10.276067     1.605826     0.772921     2.503615    -1.112311   \n",
       "1     8.860138    -3.794910    -0.077645     4.185647    -0.216325   \n",
       "2     0.206886    -6.265915     2.390440     4.415517     0.160699   \n",
       "3     6.413919    -5.715263     2.318523     3.536236     0.269141   \n",
       "4     2.651144    -1.205150     4.764476     4.285265     0.440931   \n",
       "\n",
       "   component_6  component_7  component_8  component_9  component_10  \\\n",
       "0    -1.594821    -0.589460     0.639170    -0.174985      1.860121   \n",
       "1    -0.925672    -1.518631    -0.144931     0.604341     -1.232700   \n",
       "2    -1.142673     2.502830     3.200884    -0.197537     -0.942359   \n",
       "3     0.516624     1.059161     0.196717     0.208271     -1.431863   \n",
       "4     0.745651    -0.708535     1.183168    -0.092450     -0.207216   \n",
       "\n",
       "       ...       component_29  component_30  component_31  component_32  \\\n",
       "0      ...          -0.173023     -0.133946     -0.141375      0.002717   \n",
       "1      ...          -0.267700     -0.014189      0.101492     -0.010417   \n",
       "2      ...           0.176014     -0.076339     -0.066579     -0.015415   \n",
       "3      ...           0.027190      0.038664      0.004368     -0.008195   \n",
       "4      ...           0.120202      0.048320      0.073231      0.011929   \n",
       "\n",
       "   component_33  component_34  component_35  component_36  component_37  \\\n",
       "0      0.017823     -0.004699     -0.041912      0.010904     -0.005366   \n",
       "1      0.005115     -0.000098      0.002593     -0.001163      0.001736   \n",
       "2     -0.015631     -0.000041      0.002867     -0.022992     -0.002697   \n",
       "3      0.003281      0.008977      0.004088     -0.017837      0.001622   \n",
       "4      0.018293     -0.037068     -0.039336     -0.005705      0.000903   \n",
       "\n",
       "   component_38  \n",
       "0      0.002974  \n",
       "1     -0.000472  \n",
       "2     -0.002196  \n",
       "3     -0.000914  \n",
       "4     -0.001435  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 241,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#introduce PCA Dimensionality Reduction to get the best features that explain the variance in our matrix\n",
    "pca = PCA()\n",
    "transformed_pca_x = pca.fit_transform(final_normal)\n",
    "#create component indices\n",
    "component_names = [\"component_\"+str(comp) for comp in range(1, len(pca.explained_variance_)+1)]\n",
    "\n",
    "#generate new component dataframe\n",
    "transformed_pca_x = pd.DataFrame(transformed_pca_x,columns=component_names)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 264,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "explained variance running sum by component: component_1     0.361325\n",
      "component_2     0.583178\n",
      "component_3     0.699289\n",
      "component_4     0.779868\n",
      "component_5     0.822355\n",
      "component_6     0.852970\n",
      "component_7     0.879692\n",
      "component_8     0.904938\n",
      "component_9     0.925857\n",
      "component_10    0.942240\n",
      "component_11    0.955429\n",
      "component_12    0.967679\n",
      "component_13    0.977788\n",
      "component_14    0.985724\n",
      "component_15    0.989414\n",
      "component_16    0.991526\n",
      "component_17    0.993078\n",
      "component_18    0.994361\n",
      "component_19    0.995431\n",
      "component_20    0.996239\n",
      "component_21    0.996847\n",
      "component_22    0.997343\n",
      "component_23    0.997810\n",
      "component_24    0.998226\n",
      "component_25    0.998636\n",
      "component_26    0.998989\n",
      "component_27    0.999272\n",
      "component_28    0.999514\n",
      "component_29    0.999744\n",
      "component_30    0.999874\n",
      "component_31    0.999943\n",
      "component_32    0.999957\n",
      "component_33    0.999970\n",
      "component_34    0.999982\n",
      "component_35    0.999991\n",
      "component_36    0.999996\n",
      "component_37    0.999998\n",
      "component_38    1.000000\n",
      "Name: explained_variance_ratio, dtype: float64\n"
     ]
    }
   ],
   "source": [
    "#generate component loadings on original features\n",
    "component_matrix = pd.DataFrame(pca.components_,index=component_names,columns = df_final.columns)\n",
    "#add additional columns to describe what\n",
    "component_matrix[\"explained_variance_ratio\"] = pca.explained_variance_ratio_\n",
    "component_matrix[\"eigenvalue\"] = pca.explained_variance_\n",
    "\n",
    "print(\"explained variance running sum by component:\",component_matrix.explained_variance_ratio.cumsum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#so letes perform the KNN algorithm on components 1-14, since they expalin 98.15% of the variance in the dataset\n",
    "pca_final = transformed_pca_x.iloc[:,:14]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#get the distance between every obs in the final D\n",
    "distances_euclidean = pdist(pca_final, metric='euclidean')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 246,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[  0.        ,  20.88732888,  35.13218736, ...,  25.94866902,\n",
       "         24.31348246,  24.06270058],\n",
       "       [ 20.88732888,   0.        ,  25.82637323, ...,  26.99952771,\n",
       "         23.93688809,  24.37278189],\n",
       "       [ 35.13218736,  25.82637323,   0.        , ...,  24.78983909,\n",
       "         27.13142578,  28.85847513],\n",
       "       ..., \n",
       "       [ 25.94866902,  26.99952771,  24.78983909, ...,   0.        ,\n",
       "         14.00979177,  16.17721438],\n",
       "       [ 24.31348246,  23.93688809,  27.13142578, ...,  14.00979177,\n",
       "          0.        ,  12.05671275],\n",
       "       [ 24.06270058,  24.37278189,  28.85847513, ...,  16.17721438,\n",
       "         12.05671275,   0.        ]])"
      ]
     },
     "execution_count": 246,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#create a pairwise matrix \n",
    "distances_matrix = squareform(distances_euclidean)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 247,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\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>2343</th>\n",
       "      <th>2344</th>\n",
       "      <th>2345</th>\n",
       "      <th>2346</th>\n",
       "      <th>2347</th>\n",
       "      <th>2348</th>\n",
       "      <th>2349</th>\n",
       "      <th>2350</th>\n",
       "      <th>2351</th>\n",
       "      <th>id_a</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>20.887329</td>\n",
       "      <td>35.132187</td>\n",
       "      <td>26.087636</td>\n",
       "      <td>26.702912</td>\n",
       "      <td>27.043791</td>\n",
       "      <td>25.089999</td>\n",
       "      <td>29.283917</td>\n",
       "      <td>20.236402</td>\n",
       "      <td>16.541398</td>\n",
       "      <td>...</td>\n",
       "      <td>23.732446</td>\n",
       "      <td>30.058939</td>\n",
       "      <td>27.202155</td>\n",
       "      <td>21.132404</td>\n",
       "      <td>25.292953</td>\n",
       "      <td>30.492015</td>\n",
       "      <td>25.948669</td>\n",
       "      <td>24.313482</td>\n",
       "      <td>24.062701</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.887329</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>25.826373</td>\n",
       "      <td>16.572213</td>\n",
       "      <td>22.913603</td>\n",
       "      <td>19.197107</td>\n",
       "      <td>19.541230</td>\n",
       "      <td>27.641119</td>\n",
       "      <td>21.757821</td>\n",
       "      <td>18.055367</td>\n",
       "      <td>...</td>\n",
       "      <td>17.035436</td>\n",
       "      <td>25.575648</td>\n",
       "      <td>21.268822</td>\n",
       "      <td>23.118253</td>\n",
       "      <td>29.960605</td>\n",
       "      <td>26.592151</td>\n",
       "      <td>26.999528</td>\n",
       "      <td>23.936888</td>\n",
       "      <td>24.372782</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>35.132187</td>\n",
       "      <td>25.826373</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>18.614549</td>\n",
       "      <td>20.941981</td>\n",
       "      <td>13.929478</td>\n",
       "      <td>29.310328</td>\n",
       "      <td>33.334112</td>\n",
       "      <td>29.194351</td>\n",
       "      <td>33.430191</td>\n",
       "      <td>...</td>\n",
       "      <td>23.729913</td>\n",
       "      <td>25.141384</td>\n",
       "      <td>23.215902</td>\n",
       "      <td>40.104858</td>\n",
       "      <td>24.370200</td>\n",
       "      <td>35.457359</td>\n",
       "      <td>24.789839</td>\n",
       "      <td>27.131426</td>\n",
       "      <td>28.858475</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>26.087636</td>\n",
       "      <td>16.572213</td>\n",
       "      <td>18.614549</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>19.288614</td>\n",
       "      <td>12.727091</td>\n",
       "      <td>19.429013</td>\n",
       "      <td>21.493559</td>\n",
       "      <td>22.047909</td>\n",
       "      <td>21.372450</td>\n",
       "      <td>...</td>\n",
       "      <td>16.091108</td>\n",
       "      <td>16.148922</td>\n",
       "      <td>24.852787</td>\n",
       "      <td>29.462924</td>\n",
       "      <td>26.806176</td>\n",
       "      <td>27.935244</td>\n",
       "      <td>26.345192</td>\n",
       "      <td>24.074822</td>\n",
       "      <td>26.579903</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>26.702912</td>\n",
       "      <td>22.913603</td>\n",
       "      <td>20.941981</td>\n",
       "      <td>19.288614</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.406146</td>\n",
       "      <td>21.812691</td>\n",
       "      <td>21.842560</td>\n",
       "      <td>15.930106</td>\n",
       "      <td>20.433810</td>\n",
       "      <td>...</td>\n",
       "      <td>20.206717</td>\n",
       "      <td>24.155608</td>\n",
       "      <td>16.821444</td>\n",
       "      <td>28.147994</td>\n",
       "      <td>21.506791</td>\n",
       "      <td>27.476980</td>\n",
       "      <td>16.496903</td>\n",
       "      <td>20.102148</td>\n",
       "      <td>23.606290</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 2353 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           0          1          2          3          4          5  \\\n",
       "0   0.000000  20.887329  35.132187  26.087636  26.702912  27.043791   \n",
       "1  20.887329   0.000000  25.826373  16.572213  22.913603  19.197107   \n",
       "2  35.132187  25.826373   0.000000  18.614549  20.941981  13.929478   \n",
       "3  26.087636  16.572213  18.614549   0.000000  19.288614  12.727091   \n",
       "4  26.702912  22.913603  20.941981  19.288614   0.000000  15.406146   \n",
       "\n",
       "           6          7          8          9  ...        2343       2344  \\\n",
       "0  25.089999  29.283917  20.236402  16.541398  ...   23.732446  30.058939   \n",
       "1  19.541230  27.641119  21.757821  18.055367  ...   17.035436  25.575648   \n",
       "2  29.310328  33.334112  29.194351  33.430191  ...   23.729913  25.141384   \n",
       "3  19.429013  21.493559  22.047909  21.372450  ...   16.091108  16.148922   \n",
       "4  21.812691  21.842560  15.930106  20.433810  ...   20.206717  24.155608   \n",
       "\n",
       "        2345       2346       2347       2348       2349       2350  \\\n",
       "0  27.202155  21.132404  25.292953  30.492015  25.948669  24.313482   \n",
       "1  21.268822  23.118253  29.960605  26.592151  26.999528  23.936888   \n",
       "2  23.215902  40.104858  24.370200  35.457359  24.789839  27.131426   \n",
       "3  24.852787  29.462924  26.806176  27.935244  26.345192  24.074822   \n",
       "4  16.821444  28.147994  21.506791  27.476980  16.496903  20.102148   \n",
       "\n",
       "        2351  id_a  \n",
       "0  24.062701     0  \n",
       "1  24.372782     1  \n",
       "2  28.858475     2  \n",
       "3  26.579903     3  \n",
       "4  23.606290     4  \n",
       "\n",
       "[5 rows x 2353 columns]"
      ]
     },
     "execution_count": 247,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#transform that pairwise matrix into a dataframe and add an index field for joining\n",
    "distances = pd.DataFrame(distances_matrix)\n",
    "distances['id_a'] = range(0, len(distances))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_a</th>\n",
       "      <th>variable</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>20.887329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>35.132187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>26.087636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>26.702912</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_a variable      value\n",
       "0     0        0   0.000000\n",
       "1     1        0  20.887329\n",
       "2     2        0  35.132187\n",
       "3     3        0  26.087636\n",
       "4     4        0  26.702912"
      ]
     },
     "execution_count": 248,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#pivot this data so that we can have one row per player comparison\n",
    "distances_final = pd.melt(distances,id_vars='id_a')\n",
    "\n",
    "#rename columns\n",
    "cols = ['player_a','player_b','eucl_dist']\n",
    "distances_final.columns = cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 251,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#merge over the players' names'\n",
    "final1 = pd.merge(distances_final, final, how='inner',left_on='player_a', right_index=True)\n",
    "\n",
    "final2 = pd.merge(final1,final,how='inner',left_on='player_b',right_index=True)\n",
    "\n",
    "final2 = final2[['eucl_dist','Player_y','Player_x']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 255,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\coreyjez\\Anaconda3\\lib\\site-packages\\ipykernel\\__main__.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  from ipykernel import kernelapp as app\n",
      "C:\\Users\\coreyjez\\Anaconda3\\lib\\site-packages\\ipykernel\\__main__.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    }
   ],
   "source": [
    "#create lookup tables \n",
    "ncaa_lookup = test[['Player']]\n",
    "ncaa_lookup['player_type'] = 'NCAA'\n",
    "\n",
    "nba_lookup = draft_stats_test[['Player']]\n",
    "nba_lookup['player_type'] = 'NBA'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#join over whether or not the players are NBA comparisons or NCAA players\n",
    "final3 = pd.merge(final2,ncaa_lookup,how='left',left_on='Player_y',right_on='Player')\n",
    "final3 = final3.drop('Player',axis=1)\n",
    "final3.rename(columns={'player_type':'player_y_type'},inplace=True)\n",
    "\n",
    "final4 = pd.merge(final3,ncaa_lookup,how='left',left_on='Player_x',right_on='Player')\n",
    "final4.drop('Player',axis=1,inplace=True)\n",
    "final4.rename(columns={'player_type':'player_x_type'},inplace=True)\n",
    "\n",
    "final4.fillna('NBA',inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 259,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#create final final dataframe with one NCAA players compared to NBA players\n",
    "final_final = final4[(final4.player_y_type =='NCAA') & (final4.player_x_type=='NBA')]\n",
    "\n",
    "#df[(df.A == 1) & (df.D == 6)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>eucl_dist</th>\n",
       "      <th>Player_y</th>\n",
       "      <th>Player_x</th>\n",
       "      <th>player_y_type</th>\n",
       "      <th>player_x_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18847</th>\n",
       "      <td>13.716531</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Shane Larkin</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18767</th>\n",
       "      <td>15.257080</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Reggie Jackson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18843</th>\n",
       "      <td>15.593754</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Jerian Grant</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18929</th>\n",
       "      <td>16.083855</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Lamar Patterson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18870</th>\n",
       "      <td>16.613314</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Patrick McCaw</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18886</th>\n",
       "      <td>17.019915</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Shabazz Napier</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18865</th>\n",
       "      <td>17.092628</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Tyus Jones</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18962</th>\n",
       "      <td>17.203179</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Lorenzo Brown</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18853</th>\n",
       "      <td>17.436172</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Reggie Bullock</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18757</th>\n",
       "      <td>18.096593</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Isaiah Thomas</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18869</th>\n",
       "      <td>18.109116</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Delon Wright</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18882</th>\n",
       "      <td>18.261786</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>D'Angelo Russell</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18751</th>\n",
       "      <td>18.609615</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Trey Burke</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18836</th>\n",
       "      <td>18.690465</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Ben McLemore</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18903</th>\n",
       "      <td>18.895548</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Denzel Valentine</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18901</th>\n",
       "      <td>18.964175</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Tyler Ulis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18973</th>\n",
       "      <td>19.131855</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Wade Baldwin</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18958</th>\n",
       "      <td>19.170505</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Michael Gbinije</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18913</th>\n",
       "      <td>19.406235</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Pat Connaughton</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18984</th>\n",
       "      <td>19.436834</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Marcus Denmon</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18931</th>\n",
       "      <td>19.696883</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Kris Dunn</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19006</th>\n",
       "      <td>19.841475</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Isaiah Cousins</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18800</th>\n",
       "      <td>19.850398</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Allen Crabbe</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18808</th>\n",
       "      <td>19.928488</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Solomon Hill</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18878</th>\n",
       "      <td>19.954606</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Jamal Murray</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18861</th>\n",
       "      <td>19.981715</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Ray McCallum</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18876</th>\n",
       "      <td>19.984895</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Orlando Johnson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18832</th>\n",
       "      <td>19.996917</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Josh Richardson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18835</th>\n",
       "      <td>20.028378</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Malcolm Brogdon</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18895</th>\n",
       "      <td>20.102194</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Cameron Payne</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19000</th>\n",
       "      <td>31.974613</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Cady Lalanne</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18845</th>\n",
       "      <td>32.226368</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Jordan Hamilton</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18996</th>\n",
       "      <td>32.377422</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Dakari Johnson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18902</th>\n",
       "      <td>32.601743</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Jarnell Stokes</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18946</th>\n",
       "      <td>33.082097</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Damian Jones</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18814</th>\n",
       "      <td>33.309737</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Shabazz Muhammad</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18920</th>\n",
       "      <td>33.330938</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Tony Mitchell</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18829</th>\n",
       "      <td>33.377107</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Julius Randle</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18759</th>\n",
       "      <td>33.571917</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Tristan Thompson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18855</th>\n",
       "      <td>33.813413</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Jimmer Fredette</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18924</th>\n",
       "      <td>34.171508</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Joel Bolomboy</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18823</th>\n",
       "      <td>34.273858</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Festus Ezeli</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18955</th>\n",
       "      <td>34.390509</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Cameron Bairstow</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18788</th>\n",
       "      <td>34.604572</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>John Henson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18991</th>\n",
       "      <td>34.906913</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Alec Brown</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18909</th>\n",
       "      <td>35.015887</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Rakeem Christmas</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18939</th>\n",
       "      <td>35.619096</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Fab Melo</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18758</th>\n",
       "      <td>36.065498</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Andre Drummond</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18873</th>\n",
       "      <td>36.104126</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Pascal Siakam</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18819</th>\n",
       "      <td>36.443424</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Jeff Withey</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18793</th>\n",
       "      <td>36.852015</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Myles Turner</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18818</th>\n",
       "      <td>37.646551</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Mike Muscala</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18833</th>\n",
       "      <td>37.727792</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Thomas Robinson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18737</th>\n",
       "      <td>38.120727</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18922</th>\n",
       "      <td>38.253961</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Jordan Mickey</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18937</th>\n",
       "      <td>39.284590</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Keith Benson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18740</th>\n",
       "      <td>39.583770</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Kenneth Faried</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18817</th>\n",
       "      <td>39.696040</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>T.J. Warren</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18884</th>\n",
       "      <td>40.637818</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>Skal Labissiere</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18777</th>\n",
       "      <td>41.570897</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>James Johnson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>271 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       eucl_dist    Player_y          Player_x player_y_type player_x_type\n",
       "18847  13.716531  Lonzo Ball      Shane Larkin          NCAA           NBA\n",
       "18767  15.257080  Lonzo Ball    Reggie Jackson          NCAA           NBA\n",
       "18843  15.593754  Lonzo Ball      Jerian Grant          NCAA           NBA\n",
       "18929  16.083855  Lonzo Ball   Lamar Patterson          NCAA           NBA\n",
       "18870  16.613314  Lonzo Ball     Patrick McCaw          NCAA           NBA\n",
       "18886  17.019915  Lonzo Ball    Shabazz Napier          NCAA           NBA\n",
       "18865  17.092628  Lonzo Ball        Tyus Jones          NCAA           NBA\n",
       "18962  17.203179  Lonzo Ball     Lorenzo Brown          NCAA           NBA\n",
       "18853  17.436172  Lonzo Ball    Reggie Bullock          NCAA           NBA\n",
       "18757  18.096593  Lonzo Ball     Isaiah Thomas          NCAA           NBA\n",
       "18869  18.109116  Lonzo Ball      Delon Wright          NCAA           NBA\n",
       "18882  18.261786  Lonzo Ball  D'Angelo Russell          NCAA           NBA\n",
       "18751  18.609615  Lonzo Ball        Trey Burke          NCAA           NBA\n",
       "18836  18.690465  Lonzo Ball      Ben McLemore          NCAA           NBA\n",
       "18903  18.895548  Lonzo Ball  Denzel Valentine          NCAA           NBA\n",
       "18901  18.964175  Lonzo Ball        Tyler Ulis          NCAA           NBA\n",
       "18973  19.131855  Lonzo Ball      Wade Baldwin          NCAA           NBA\n",
       "18958  19.170505  Lonzo Ball   Michael Gbinije          NCAA           NBA\n",
       "18913  19.406235  Lonzo Ball   Pat Connaughton          NCAA           NBA\n",
       "18984  19.436834  Lonzo Ball     Marcus Denmon          NCAA           NBA\n",
       "18931  19.696883  Lonzo Ball         Kris Dunn          NCAA           NBA\n",
       "19006  19.841475  Lonzo Ball    Isaiah Cousins          NCAA           NBA\n",
       "18800  19.850398  Lonzo Ball      Allen Crabbe          NCAA           NBA\n",
       "18808  19.928488  Lonzo Ball      Solomon Hill          NCAA           NBA\n",
       "18878  19.954606  Lonzo Ball      Jamal Murray          NCAA           NBA\n",
       "18861  19.981715  Lonzo Ball      Ray McCallum          NCAA           NBA\n",
       "18876  19.984895  Lonzo Ball   Orlando Johnson          NCAA           NBA\n",
       "18832  19.996917  Lonzo Ball   Josh Richardson          NCAA           NBA\n",
       "18835  20.028378  Lonzo Ball   Malcolm Brogdon          NCAA           NBA\n",
       "18895  20.102194  Lonzo Ball     Cameron Payne          NCAA           NBA\n",
       "...          ...         ...               ...           ...           ...\n",
       "19000  31.974613  Lonzo Ball      Cady Lalanne          NCAA           NBA\n",
       "18845  32.226368  Lonzo Ball   Jordan Hamilton          NCAA           NBA\n",
       "18996  32.377422  Lonzo Ball    Dakari Johnson          NCAA           NBA\n",
       "18902  32.601743  Lonzo Ball    Jarnell Stokes          NCAA           NBA\n",
       "18946  33.082097  Lonzo Ball      Damian Jones          NCAA           NBA\n",
       "18814  33.309737  Lonzo Ball  Shabazz Muhammad          NCAA           NBA\n",
       "18920  33.330938  Lonzo Ball     Tony Mitchell          NCAA           NBA\n",
       "18829  33.377107  Lonzo Ball     Julius Randle          NCAA           NBA\n",
       "18759  33.571917  Lonzo Ball  Tristan Thompson          NCAA           NBA\n",
       "18855  33.813413  Lonzo Ball   Jimmer Fredette          NCAA           NBA\n",
       "18924  34.171508  Lonzo Ball     Joel Bolomboy          NCAA           NBA\n",
       "18823  34.273858  Lonzo Ball      Festus Ezeli          NCAA           NBA\n",
       "18955  34.390509  Lonzo Ball  Cameron Bairstow          NCAA           NBA\n",
       "18788  34.604572  Lonzo Ball       John Henson          NCAA           NBA\n",
       "18991  34.906913  Lonzo Ball        Alec Brown          NCAA           NBA\n",
       "18909  35.015887  Lonzo Ball  Rakeem Christmas          NCAA           NBA\n",
       "18939  35.619096  Lonzo Ball          Fab Melo          NCAA           NBA\n",
       "18758  36.065498  Lonzo Ball    Andre Drummond          NCAA           NBA\n",
       "18873  36.104126  Lonzo Ball     Pascal Siakam          NCAA           NBA\n",
       "18819  36.443424  Lonzo Ball       Jeff Withey          NCAA           NBA\n",
       "18793  36.852015  Lonzo Ball      Myles Turner          NCAA           NBA\n",
       "18818  37.646551  Lonzo Ball      Mike Muscala          NCAA           NBA\n",
       "18833  37.727792  Lonzo Ball   Thomas Robinson          NCAA           NBA\n",
       "18737  38.120727  Lonzo Ball     Anthony Davis          NCAA           NBA\n",
       "18922  38.253961  Lonzo Ball     Jordan Mickey          NCAA           NBA\n",
       "18937  39.284590  Lonzo Ball      Keith Benson          NCAA           NBA\n",
       "18740  39.583770  Lonzo Ball    Kenneth Faried          NCAA           NBA\n",
       "18817  39.696040  Lonzo Ball       T.J. Warren          NCAA           NBA\n",
       "18884  40.637818  Lonzo Ball   Skal Labissiere          NCAA           NBA\n",
       "18777  41.570897  Lonzo Ball     James Johnson          NCAA           NBA\n",
       "\n",
       "[271 rows x 5 columns]"
      ]
     },
     "execution_count": 265,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#examine the comparisons for Lonzo Ball\n",
    "final_final[final_final['Player_y'] == 'Lonzo Ball'].sort_values(by='eucl_dist',ascending = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 263,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>eucl_dist</th>\n",
       "      <th>Player_y</th>\n",
       "      <th>Player_x</th>\n",
       "      <th>player_y_type</th>\n",
       "      <th>player_x_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>553466</th>\n",
       "      <td>4.897065</td>\n",
       "      <td>Steve Vasturia</td>\n",
       "      <td>Caris LeVert</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066727</th>\n",
       "      <td>5.062801</td>\n",
       "      <td>Jared Terrell</td>\n",
       "      <td>Malcolm Lee</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230272</th>\n",
       "      <td>5.379588</td>\n",
       "      <td>Rawle Alkins</td>\n",
       "      <td>Solomon Hill</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589021</th>\n",
       "      <td>5.415472</td>\n",
       "      <td>Dylan Ennis</td>\n",
       "      <td>Cory Joseph</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1361372</th>\n",
       "      <td>5.521101</td>\n",
       "      <td>Rodney Purvis</td>\n",
       "      <td>Malachi Richardson</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2157231</th>\n",
       "      <td>5.577684</td>\n",
       "      <td>Christian Terrell</td>\n",
       "      <td>Zach LaVine</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503535</th>\n",
       "      <td>5.852017</td>\n",
       "      <td>Tracy Abrams</td>\n",
       "      <td>Zach LaVine</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762657</th>\n",
       "      <td>5.911154</td>\n",
       "      <td>Khadeen Carrington</td>\n",
       "      <td>Darius Johnson-Odom</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116274</th>\n",
       "      <td>5.911482</td>\n",
       "      <td>Sterling Brown</td>\n",
       "      <td>Justise Winslow</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413247</th>\n",
       "      <td>6.009668</td>\n",
       "      <td>Sviatoslav Mykhailiuk</td>\n",
       "      <td>Zach LaVine</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676827</th>\n",
       "      <td>6.016287</td>\n",
       "      <td>Justin Robinson</td>\n",
       "      <td>Isaiah Canaan</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676826</th>\n",
       "      <td>6.016287</td>\n",
       "      <td>Justin Robinson</td>\n",
       "      <td>Isaiah Canaan</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>966792</th>\n",
       "      <td>6.018570</td>\n",
       "      <td>Jordan Murphy</td>\n",
       "      <td>Marcus Thornton</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>967018</th>\n",
       "      <td>6.018570</td>\n",
       "      <td>Jordan Murphy</td>\n",
       "      <td>Marcus Thornton</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762514</th>\n",
       "      <td>6.030128</td>\n",
       "      <td>Khadeen Carrington</td>\n",
       "      <td>Austin Rivers</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2285549</th>\n",
       "      <td>6.036571</td>\n",
       "      <td>Darrell Davis</td>\n",
       "      <td>Jordan Hamilton</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696001</th>\n",
       "      <td>6.080880</td>\n",
       "      <td>Jack Gibbs</td>\n",
       "      <td>Isaiah Canaan</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1197419</th>\n",
       "      <td>6.142668</td>\n",
       "      <td>Xavier Johnson</td>\n",
       "      <td>Malik Beasley</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069023</th>\n",
       "      <td>6.158689</td>\n",
       "      <td>Christian Vital</td>\n",
       "      <td>Zach LaVine</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1674917</th>\n",
       "      <td>6.229392</td>\n",
       "      <td>Cullen VanLeer</td>\n",
       "      <td>Jordan Hamilton</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2468661</th>\n",
       "      <td>6.258655</td>\n",
       "      <td>Alex Murphy</td>\n",
       "      <td>Abdel Nader</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2656239</th>\n",
       "      <td>6.387709</td>\n",
       "      <td>Rob Edwards</td>\n",
       "      <td>Jordan Williams</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1553807</th>\n",
       "      <td>6.409944</td>\n",
       "      <td>D.J. Fenner</td>\n",
       "      <td>Malcolm Lee</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120981</th>\n",
       "      <td>6.443540</td>\n",
       "      <td>Edrice Adebayo</td>\n",
       "      <td>Quincy Acy</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000483</th>\n",
       "      <td>6.444821</td>\n",
       "      <td>Brynton Lemar</td>\n",
       "      <td>James Young</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000410</th>\n",
       "      <td>6.457194</td>\n",
       "      <td>Brynton Lemar</td>\n",
       "      <td>Austin Rivers</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2439989</th>\n",
       "      <td>6.606846</td>\n",
       "      <td>Alexander Aka Gorski</td>\n",
       "      <td>Jordan Hamilton</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33068</th>\n",
       "      <td>6.608452</td>\n",
       "      <td>Donovan Mitchell</td>\n",
       "      <td>Gary Harris</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914535</th>\n",
       "      <td>6.698608</td>\n",
       "      <td>Kavin Gilder-Tilbury</td>\n",
       "      <td>Terrence Ross</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280171</th>\n",
       "      <td>6.719336</td>\n",
       "      <td>London Perrantes</td>\n",
       "      <td>Tony Snell</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4723217</th>\n",
       "      <td>55.659372</td>\n",
       "      <td>Sebastian Townes</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4834889</th>\n",
       "      <td>55.806828</td>\n",
       "      <td>Darius Moore</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4808753</th>\n",
       "      <td>55.818913</td>\n",
       "      <td>Eliel Gonzalez</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4792121</th>\n",
       "      <td>55.901396</td>\n",
       "      <td>Mike Green</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4017545</th>\n",
       "      <td>55.908765</td>\n",
       "      <td>Christian Ellis</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4616297</th>\n",
       "      <td>56.092542</td>\n",
       "      <td>Isaiah Walton</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4956065</th>\n",
       "      <td>56.164070</td>\n",
       "      <td>Darrell Riley</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4915673</th>\n",
       "      <td>56.267556</td>\n",
       "      <td>Sam Hunt</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4958441</th>\n",
       "      <td>56.304151</td>\n",
       "      <td>Raheem Watts</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4899041</th>\n",
       "      <td>56.318796</td>\n",
       "      <td>Sam Burmeister</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4918049</th>\n",
       "      <td>56.357529</td>\n",
       "      <td>Jermaine Marrow</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4925177</th>\n",
       "      <td>56.468464</td>\n",
       "      <td>Reggie Dillard</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4637681</th>\n",
       "      <td>56.498150</td>\n",
       "      <td>Matthew Butler</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4685201</th>\n",
       "      <td>56.636098</td>\n",
       "      <td>Asante Gist</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4908545</th>\n",
       "      <td>56.642419</td>\n",
       "      <td>Jo'Vontae Millner</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4682825</th>\n",
       "      <td>56.740089</td>\n",
       "      <td>Josh Boyd</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4782617</th>\n",
       "      <td>56.883457</td>\n",
       "      <td>Reggie Oliver</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4877657</th>\n",
       "      <td>56.946361</td>\n",
       "      <td>Charles Tucker Jr.</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4963193</th>\n",
       "      <td>56.987312</td>\n",
       "      <td>Max Heidegger</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4825385</th>\n",
       "      <td>57.088632</td>\n",
       "      <td>Delante Jones</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4991705</th>\n",
       "      <td>57.289504</td>\n",
       "      <td>Amos Given</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4939433</th>\n",
       "      <td>57.606328</td>\n",
       "      <td>Tyson Batiste</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4708961</th>\n",
       "      <td>57.632143</td>\n",
       "      <td>Taylor Johnson</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4998833</th>\n",
       "      <td>57.667914</td>\n",
       "      <td>Marcus Merriweather</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4970321</th>\n",
       "      <td>57.728321</td>\n",
       "      <td>Rakim Lubin</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4763609</th>\n",
       "      <td>57.844177</td>\n",
       "      <td>August Haas</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4982201</th>\n",
       "      <td>58.519947</td>\n",
       "      <td>Rakiya Battle</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4865777</th>\n",
       "      <td>58.674243</td>\n",
       "      <td>Junior Lomomba</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4984577</th>\n",
       "      <td>59.255539</td>\n",
       "      <td>Elijah Pughsley</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4977449</th>\n",
       "      <td>59.585905</td>\n",
       "      <td>Chris Shields</td>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>NCAA</td>\n",
       "      <td>NBA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>570455 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         eucl_dist               Player_y             Player_x player_y_type  \\\n",
       "553466    4.897065         Steve Vasturia         Caris LeVert          NCAA   \n",
       "1066727   5.062801          Jared Terrell          Malcolm Lee          NCAA   \n",
       "230272    5.379588           Rawle Alkins         Solomon Hill          NCAA   \n",
       "589021    5.415472            Dylan Ennis          Cory Joseph          NCAA   \n",
       "1361372   5.521101          Rodney Purvis   Malachi Richardson          NCAA   \n",
       "2157231   5.577684      Christian Terrell          Zach LaVine          NCAA   \n",
       "503535    5.852017           Tracy Abrams          Zach LaVine          NCAA   \n",
       "762657    5.911154     Khadeen Carrington  Darius Johnson-Odom          NCAA   \n",
       "116274    5.911482         Sterling Brown      Justise Winslow          NCAA   \n",
       "413247    6.009668  Sviatoslav Mykhailiuk          Zach LaVine          NCAA   \n",
       "676827    6.016287        Justin Robinson        Isaiah Canaan          NCAA   \n",
       "676826    6.016287        Justin Robinson        Isaiah Canaan          NCAA   \n",
       "966792    6.018570          Jordan Murphy      Marcus Thornton          NCAA   \n",
       "967018    6.018570          Jordan Murphy      Marcus Thornton          NCAA   \n",
       "762514    6.030128     Khadeen Carrington        Austin Rivers          NCAA   \n",
       "2285549   6.036571          Darrell Davis      Jordan Hamilton          NCAA   \n",
       "696001    6.080880             Jack Gibbs        Isaiah Canaan          NCAA   \n",
       "1197419   6.142668         Xavier Johnson        Malik Beasley          NCAA   \n",
       "1069023   6.158689        Christian Vital          Zach LaVine          NCAA   \n",
       "1674917   6.229392         Cullen VanLeer      Jordan Hamilton          NCAA   \n",
       "2468661   6.258655            Alex Murphy          Abdel Nader          NCAA   \n",
       "2656239   6.387709            Rob Edwards      Jordan Williams          NCAA   \n",
       "1553807   6.409944            D.J. Fenner          Malcolm Lee          NCAA   \n",
       "120981    6.443540         Edrice Adebayo           Quincy Acy          NCAA   \n",
       "2000483   6.444821          Brynton Lemar          James Young          NCAA   \n",
       "2000410   6.457194          Brynton Lemar        Austin Rivers          NCAA   \n",
       "2439989   6.606846   Alexander Aka Gorski      Jordan Hamilton          NCAA   \n",
       "33068     6.608452       Donovan Mitchell          Gary Harris          NCAA   \n",
       "914535    6.698608   Kavin Gilder-Tilbury        Terrence Ross          NCAA   \n",
       "280171    6.719336       London Perrantes           Tony Snell          NCAA   \n",
       "...            ...                    ...                  ...           ...   \n",
       "4723217  55.659372       Sebastian Townes        Anthony Davis          NCAA   \n",
       "4834889  55.806828           Darius Moore        Anthony Davis          NCAA   \n",
       "4808753  55.818913         Eliel Gonzalez        Anthony Davis          NCAA   \n",
       "4792121  55.901396             Mike Green        Anthony Davis          NCAA   \n",
       "4017545  55.908765        Christian Ellis        Anthony Davis          NCAA   \n",
       "4616297  56.092542          Isaiah Walton        Anthony Davis          NCAA   \n",
       "4956065  56.164070          Darrell Riley        Anthony Davis          NCAA   \n",
       "4915673  56.267556               Sam Hunt        Anthony Davis          NCAA   \n",
       "4958441  56.304151           Raheem Watts        Anthony Davis          NCAA   \n",
       "4899041  56.318796         Sam Burmeister        Anthony Davis          NCAA   \n",
       "4918049  56.357529        Jermaine Marrow        Anthony Davis          NCAA   \n",
       "4925177  56.468464         Reggie Dillard        Anthony Davis          NCAA   \n",
       "4637681  56.498150         Matthew Butler        Anthony Davis          NCAA   \n",
       "4685201  56.636098            Asante Gist        Anthony Davis          NCAA   \n",
       "4908545  56.642419      Jo'Vontae Millner        Anthony Davis          NCAA   \n",
       "4682825  56.740089              Josh Boyd        Anthony Davis          NCAA   \n",
       "4782617  56.883457          Reggie Oliver        Anthony Davis          NCAA   \n",
       "4877657  56.946361     Charles Tucker Jr.        Anthony Davis          NCAA   \n",
       "4963193  56.987312          Max Heidegger        Anthony Davis          NCAA   \n",
       "4825385  57.088632          Delante Jones        Anthony Davis          NCAA   \n",
       "4991705  57.289504             Amos Given        Anthony Davis          NCAA   \n",
       "4939433  57.606328          Tyson Batiste        Anthony Davis          NCAA   \n",
       "4708961  57.632143         Taylor Johnson        Anthony Davis          NCAA   \n",
       "4998833  57.667914    Marcus Merriweather        Anthony Davis          NCAA   \n",
       "4970321  57.728321            Rakim Lubin        Anthony Davis          NCAA   \n",
       "4763609  57.844177            August Haas        Anthony Davis          NCAA   \n",
       "4982201  58.519947          Rakiya Battle        Anthony Davis          NCAA   \n",
       "4865777  58.674243         Junior Lomomba        Anthony Davis          NCAA   \n",
       "4984577  59.255539        Elijah Pughsley        Anthony Davis          NCAA   \n",
       "4977449  59.585905          Chris Shields        Anthony Davis          NCAA   \n",
       "\n",
       "        player_x_type  \n",
       "553466            NBA  \n",
       "1066727           NBA  \n",
       "230272            NBA  \n",
       "589021            NBA  \n",
       "1361372           NBA  \n",
       "2157231           NBA  \n",
       "503535            NBA  \n",
       "762657            NBA  \n",
       "116274            NBA  \n",
       "413247            NBA  \n",
       "676827            NBA  \n",
       "676826            NBA  \n",
       "966792            NBA  \n",
       "967018            NBA  \n",
       "762514            NBA  \n",
       "2285549           NBA  \n",
       "696001            NBA  \n",
       "1197419           NBA  \n",
       "1069023           NBA  \n",
       "1674917           NBA  \n",
       "2468661           NBA  \n",
       "2656239           NBA  \n",
       "1553807           NBA  \n",
       "120981            NBA  \n",
       "2000483           NBA  \n",
       "2000410           NBA  \n",
       "2439989           NBA  \n",
       "33068             NBA  \n",
       "914535            NBA  \n",
       "280171            NBA  \n",
       "...               ...  \n",
       "4723217           NBA  \n",
       "4834889           NBA  \n",
       "4808753           NBA  \n",
       "4792121           NBA  \n",
       "4017545           NBA  \n",
       "4616297           NBA  \n",
       "4956065           NBA  \n",
       "4915673           NBA  \n",
       "4958441           NBA  \n",
       "4899041           NBA  \n",
       "4918049           NBA  \n",
       "4925177           NBA  \n",
       "4637681           NBA  \n",
       "4685201           NBA  \n",
       "4908545           NBA  \n",
       "4682825           NBA  \n",
       "4782617           NBA  \n",
       "4877657           NBA  \n",
       "4963193           NBA  \n",
       "4825385           NBA  \n",
       "4991705           NBA  \n",
       "4939433           NBA  \n",
       "4708961           NBA  \n",
       "4998833           NBA  \n",
       "4970321           NBA  \n",
       "4763609           NBA  \n",
       "4982201           NBA  \n",
       "4865777           NBA  \n",
       "4984577           NBA  \n",
       "4977449           NBA  \n",
       "\n",
       "[570455 rows x 5 columns]"
      ]
     },
     "execution_count": 263,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#write this final_final table out to CSV\n",
    "final_final.to_csv(\"player_comparison_2017_pca.csv\")"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}