{ "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": [ "
\n", " | component_1 | \n", "component_2 | \n", "component_3 | \n", "component_4 | \n", "component_5 | \n", "component_6 | \n", "component_7 | \n", "component_8 | \n", "component_9 | \n", "component_10 | \n", "... | \n", "component_29 | \n", "component_30 | \n", "component_31 | \n", "component_32 | \n", "component_33 | \n", "component_34 | \n", "component_35 | \n", "component_36 | \n", "component_37 | \n", "component_38 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "10.276067 | \n", "1.605826 | \n", "0.772921 | \n", "2.503615 | \n", "-1.112311 | \n", "-1.594821 | \n", "-0.589460 | \n", "0.639170 | \n", "-0.174985 | \n", "1.860121 | \n", "... | \n", "-0.173023 | \n", "-0.133946 | \n", "-0.141375 | \n", "0.002717 | \n", "0.017823 | \n", "-0.004699 | \n", "-0.041912 | \n", "0.010904 | \n", "-0.005366 | \n", "0.002974 | \n", "
1 | \n", "8.860138 | \n", "-3.794910 | \n", "-0.077645 | \n", "4.185647 | \n", "-0.216325 | \n", "-0.925672 | \n", "-1.518631 | \n", "-0.144931 | \n", "0.604341 | \n", "-1.232700 | \n", "... | \n", "-0.267700 | \n", "-0.014189 | \n", "0.101492 | \n", "-0.010417 | \n", "0.005115 | \n", "-0.000098 | \n", "0.002593 | \n", "-0.001163 | \n", "0.001736 | \n", "-0.000472 | \n", "
2 | \n", "0.206886 | \n", "-6.265915 | \n", "2.390440 | \n", "4.415517 | \n", "0.160699 | \n", "-1.142673 | \n", "2.502830 | \n", "3.200884 | \n", "-0.197537 | \n", "-0.942359 | \n", "... | \n", "0.176014 | \n", "-0.076339 | \n", "-0.066579 | \n", "-0.015415 | \n", "-0.015631 | \n", "-0.000041 | \n", "0.002867 | \n", "-0.022992 | \n", "-0.002697 | \n", "-0.002196 | \n", "
3 | \n", "6.413919 | \n", "-5.715263 | \n", "2.318523 | \n", "3.536236 | \n", "0.269141 | \n", "0.516624 | \n", "1.059161 | \n", "0.196717 | \n", "0.208271 | \n", "-1.431863 | \n", "... | \n", "0.027190 | \n", "0.038664 | \n", "0.004368 | \n", "-0.008195 | \n", "0.003281 | \n", "0.008977 | \n", "0.004088 | \n", "-0.017837 | \n", "0.001622 | \n", "-0.000914 | \n", "
4 | \n", "2.651144 | \n", "-1.205150 | \n", "4.764476 | \n", "4.285265 | \n", "0.440931 | \n", "0.745651 | \n", "-0.708535 | \n", "1.183168 | \n", "-0.092450 | \n", "-0.207216 | \n", "... | \n", "0.120202 | \n", "0.048320 | \n", "0.073231 | \n", "0.011929 | \n", "0.018293 | \n", "-0.037068 | \n", "-0.039336 | \n", "-0.005705 | \n", "0.000903 | \n", "-0.001435 | \n", "
5 rows × 38 columns
\n", "\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "2343 | \n", "2344 | \n", "2345 | \n", "2346 | \n", "2347 | \n", "2348 | \n", "2349 | \n", "2350 | \n", "2351 | \n", "id_a | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0.000000 | \n", "20.887329 | \n", "35.132187 | \n", "26.087636 | \n", "26.702912 | \n", "27.043791 | \n", "25.089999 | \n", "29.283917 | \n", "20.236402 | \n", "16.541398 | \n", "... | \n", "23.732446 | \n", "30.058939 | \n", "27.202155 | \n", "21.132404 | \n", "25.292953 | \n", "30.492015 | \n", "25.948669 | \n", "24.313482 | \n", "24.062701 | \n", "0 | \n", "
1 | \n", "20.887329 | \n", "0.000000 | \n", "25.826373 | \n", "16.572213 | \n", "22.913603 | \n", "19.197107 | \n", "19.541230 | \n", "27.641119 | \n", "21.757821 | \n", "18.055367 | \n", "... | \n", "17.035436 | \n", "25.575648 | \n", "21.268822 | \n", "23.118253 | \n", "29.960605 | \n", "26.592151 | \n", "26.999528 | \n", "23.936888 | \n", "24.372782 | \n", "1 | \n", "
2 | \n", "35.132187 | \n", "25.826373 | \n", "0.000000 | \n", "18.614549 | \n", "20.941981 | \n", "13.929478 | \n", "29.310328 | \n", "33.334112 | \n", "29.194351 | \n", "33.430191 | \n", "... | \n", "23.729913 | \n", "25.141384 | \n", "23.215902 | \n", "40.104858 | \n", "24.370200 | \n", "35.457359 | \n", "24.789839 | \n", "27.131426 | \n", "28.858475 | \n", "2 | \n", "
3 | \n", "26.087636 | \n", "16.572213 | \n", "18.614549 | \n", "0.000000 | \n", "19.288614 | \n", "12.727091 | \n", "19.429013 | \n", "21.493559 | \n", "22.047909 | \n", "21.372450 | \n", "... | \n", "16.091108 | \n", "16.148922 | \n", "24.852787 | \n", "29.462924 | \n", "26.806176 | \n", "27.935244 | \n", "26.345192 | \n", "24.074822 | \n", "26.579903 | \n", "3 | \n", "
4 | \n", "26.702912 | \n", "22.913603 | \n", "20.941981 | \n", "19.288614 | \n", "0.000000 | \n", "15.406146 | \n", "21.812691 | \n", "21.842560 | \n", "15.930106 | \n", "20.433810 | \n", "... | \n", "20.206717 | \n", "24.155608 | \n", "16.821444 | \n", "28.147994 | \n", "21.506791 | \n", "27.476980 | \n", "16.496903 | \n", "20.102148 | \n", "23.606290 | \n", "4 | \n", "
5 rows × 2353 columns
\n", "\n", " | id_a | \n", "variable | \n", "value | \n", "
---|---|---|---|
0 | \n", "0 | \n", "0 | \n", "0.000000 | \n", "
1 | \n", "1 | \n", "0 | \n", "20.887329 | \n", "
2 | \n", "2 | \n", "0 | \n", "35.132187 | \n", "
3 | \n", "3 | \n", "0 | \n", "26.087636 | \n", "
4 | \n", "4 | \n", "0 | \n", "26.702912 | \n", "
\n", " | eucl_dist | \n", "Player_y | \n", "Player_x | \n", "player_y_type | \n", "player_x_type | \n", "
---|---|---|---|---|---|
18847 | \n", "13.716531 | \n", "Lonzo Ball | \n", "Shane Larkin | \n", "NCAA | \n", "NBA | \n", "
18767 | \n", "15.257080 | \n", "Lonzo Ball | \n", "Reggie Jackson | \n", "NCAA | \n", "NBA | \n", "
18843 | \n", "15.593754 | \n", "Lonzo Ball | \n", "Jerian Grant | \n", "NCAA | \n", "NBA | \n", "
18929 | \n", "16.083855 | \n", "Lonzo Ball | \n", "Lamar Patterson | \n", "NCAA | \n", "NBA | \n", "
18870 | \n", "16.613314 | \n", "Lonzo Ball | \n", "Patrick McCaw | \n", "NCAA | \n", "NBA | \n", "
18886 | \n", "17.019915 | \n", "Lonzo Ball | \n", "Shabazz Napier | \n", "NCAA | \n", "NBA | \n", "
18865 | \n", "17.092628 | \n", "Lonzo Ball | \n", "Tyus Jones | \n", "NCAA | \n", "NBA | \n", "
18962 | \n", "17.203179 | \n", "Lonzo Ball | \n", "Lorenzo Brown | \n", "NCAA | \n", "NBA | \n", "
18853 | \n", "17.436172 | \n", "Lonzo Ball | \n", "Reggie Bullock | \n", "NCAA | \n", "NBA | \n", "
18757 | \n", "18.096593 | \n", "Lonzo Ball | \n", "Isaiah Thomas | \n", "NCAA | \n", "NBA | \n", "
18869 | \n", "18.109116 | \n", "Lonzo Ball | \n", "Delon Wright | \n", "NCAA | \n", "NBA | \n", "
18882 | \n", "18.261786 | \n", "Lonzo Ball | \n", "D'Angelo Russell | \n", "NCAA | \n", "NBA | \n", "
18751 | \n", "18.609615 | \n", "Lonzo Ball | \n", "Trey Burke | \n", "NCAA | \n", "NBA | \n", "
18836 | \n", "18.690465 | \n", "Lonzo Ball | \n", "Ben McLemore | \n", "NCAA | \n", "NBA | \n", "
18903 | \n", "18.895548 | \n", "Lonzo Ball | \n", "Denzel Valentine | \n", "NCAA | \n", "NBA | \n", "
18901 | \n", "18.964175 | \n", "Lonzo Ball | \n", "Tyler Ulis | \n", "NCAA | \n", "NBA | \n", "
18973 | \n", "19.131855 | \n", "Lonzo Ball | \n", "Wade Baldwin | \n", "NCAA | \n", "NBA | \n", "
18958 | \n", "19.170505 | \n", "Lonzo Ball | \n", "Michael Gbinije | \n", "NCAA | \n", "NBA | \n", "
18913 | \n", "19.406235 | \n", "Lonzo Ball | \n", "Pat Connaughton | \n", "NCAA | \n", "NBA | \n", "
18984 | \n", "19.436834 | \n", "Lonzo Ball | \n", "Marcus Denmon | \n", "NCAA | \n", "NBA | \n", "
18931 | \n", "19.696883 | \n", "Lonzo Ball | \n", "Kris Dunn | \n", "NCAA | \n", "NBA | \n", "
19006 | \n", "19.841475 | \n", "Lonzo Ball | \n", "Isaiah Cousins | \n", "NCAA | \n", "NBA | \n", "
18800 | \n", "19.850398 | \n", "Lonzo Ball | \n", "Allen Crabbe | \n", "NCAA | \n", "NBA | \n", "
18808 | \n", "19.928488 | \n", "Lonzo Ball | \n", "Solomon Hill | \n", "NCAA | \n", "NBA | \n", "
18878 | \n", "19.954606 | \n", "Lonzo Ball | \n", "Jamal Murray | \n", "NCAA | \n", "NBA | \n", "
18861 | \n", "19.981715 | \n", "Lonzo Ball | \n", "Ray McCallum | \n", "NCAA | \n", "NBA | \n", "
18876 | \n", "19.984895 | \n", "Lonzo Ball | \n", "Orlando Johnson | \n", "NCAA | \n", "NBA | \n", "
18832 | \n", "19.996917 | \n", "Lonzo Ball | \n", "Josh Richardson | \n", "NCAA | \n", "NBA | \n", "
18835 | \n", "20.028378 | \n", "Lonzo Ball | \n", "Malcolm Brogdon | \n", "NCAA | \n", "NBA | \n", "
18895 | \n", "20.102194 | \n", "Lonzo Ball | \n", "Cameron Payne | \n", "NCAA | \n", "NBA | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
19000 | \n", "31.974613 | \n", "Lonzo Ball | \n", "Cady Lalanne | \n", "NCAA | \n", "NBA | \n", "
18845 | \n", "32.226368 | \n", "Lonzo Ball | \n", "Jordan Hamilton | \n", "NCAA | \n", "NBA | \n", "
18996 | \n", "32.377422 | \n", "Lonzo Ball | \n", "Dakari Johnson | \n", "NCAA | \n", "NBA | \n", "
18902 | \n", "32.601743 | \n", "Lonzo Ball | \n", "Jarnell Stokes | \n", "NCAA | \n", "NBA | \n", "
18946 | \n", "33.082097 | \n", "Lonzo Ball | \n", "Damian Jones | \n", "NCAA | \n", "NBA | \n", "
18814 | \n", "33.309737 | \n", "Lonzo Ball | \n", "Shabazz Muhammad | \n", "NCAA | \n", "NBA | \n", "
18920 | \n", "33.330938 | \n", "Lonzo Ball | \n", "Tony Mitchell | \n", "NCAA | \n", "NBA | \n", "
18829 | \n", "33.377107 | \n", "Lonzo Ball | \n", "Julius Randle | \n", "NCAA | \n", "NBA | \n", "
18759 | \n", "33.571917 | \n", "Lonzo Ball | \n", "Tristan Thompson | \n", "NCAA | \n", "NBA | \n", "
18855 | \n", "33.813413 | \n", "Lonzo Ball | \n", "Jimmer Fredette | \n", "NCAA | \n", "NBA | \n", "
18924 | \n", "34.171508 | \n", "Lonzo Ball | \n", "Joel Bolomboy | \n", "NCAA | \n", "NBA | \n", "
18823 | \n", "34.273858 | \n", "Lonzo Ball | \n", "Festus Ezeli | \n", "NCAA | \n", "NBA | \n", "
18955 | \n", "34.390509 | \n", "Lonzo Ball | \n", "Cameron Bairstow | \n", "NCAA | \n", "NBA | \n", "
18788 | \n", "34.604572 | \n", "Lonzo Ball | \n", "John Henson | \n", "NCAA | \n", "NBA | \n", "
18991 | \n", "34.906913 | \n", "Lonzo Ball | \n", "Alec Brown | \n", "NCAA | \n", "NBA | \n", "
18909 | \n", "35.015887 | \n", "Lonzo Ball | \n", "Rakeem Christmas | \n", "NCAA | \n", "NBA | \n", "
18939 | \n", "35.619096 | \n", "Lonzo Ball | \n", "Fab Melo | \n", "NCAA | \n", "NBA | \n", "
18758 | \n", "36.065498 | \n", "Lonzo Ball | \n", "Andre Drummond | \n", "NCAA | \n", "NBA | \n", "
18873 | \n", "36.104126 | \n", "Lonzo Ball | \n", "Pascal Siakam | \n", "NCAA | \n", "NBA | \n", "
18819 | \n", "36.443424 | \n", "Lonzo Ball | \n", "Jeff Withey | \n", "NCAA | \n", "NBA | \n", "
18793 | \n", "36.852015 | \n", "Lonzo Ball | \n", "Myles Turner | \n", "NCAA | \n", "NBA | \n", "
18818 | \n", "37.646551 | \n", "Lonzo Ball | \n", "Mike Muscala | \n", "NCAA | \n", "NBA | \n", "
18833 | \n", "37.727792 | \n", "Lonzo Ball | \n", "Thomas Robinson | \n", "NCAA | \n", "NBA | \n", "
18737 | \n", "38.120727 | \n", "Lonzo Ball | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
18922 | \n", "38.253961 | \n", "Lonzo Ball | \n", "Jordan Mickey | \n", "NCAA | \n", "NBA | \n", "
18937 | \n", "39.284590 | \n", "Lonzo Ball | \n", "Keith Benson | \n", "NCAA | \n", "NBA | \n", "
18740 | \n", "39.583770 | \n", "Lonzo Ball | \n", "Kenneth Faried | \n", "NCAA | \n", "NBA | \n", "
18817 | \n", "39.696040 | \n", "Lonzo Ball | \n", "T.J. Warren | \n", "NCAA | \n", "NBA | \n", "
18884 | \n", "40.637818 | \n", "Lonzo Ball | \n", "Skal Labissiere | \n", "NCAA | \n", "NBA | \n", "
18777 | \n", "41.570897 | \n", "Lonzo Ball | \n", "James Johnson | \n", "NCAA | \n", "NBA | \n", "
271 rows × 5 columns
\n", "\n", " | eucl_dist | \n", "Player_y | \n", "Player_x | \n", "player_y_type | \n", "player_x_type | \n", "
---|---|---|---|---|---|
553466 | \n", "4.897065 | \n", "Steve Vasturia | \n", "Caris LeVert | \n", "NCAA | \n", "NBA | \n", "
1066727 | \n", "5.062801 | \n", "Jared Terrell | \n", "Malcolm Lee | \n", "NCAA | \n", "NBA | \n", "
230272 | \n", "5.379588 | \n", "Rawle Alkins | \n", "Solomon Hill | \n", "NCAA | \n", "NBA | \n", "
589021 | \n", "5.415472 | \n", "Dylan Ennis | \n", "Cory Joseph | \n", "NCAA | \n", "NBA | \n", "
1361372 | \n", "5.521101 | \n", "Rodney Purvis | \n", "Malachi Richardson | \n", "NCAA | \n", "NBA | \n", "
2157231 | \n", "5.577684 | \n", "Christian Terrell | \n", "Zach LaVine | \n", "NCAA | \n", "NBA | \n", "
503535 | \n", "5.852017 | \n", "Tracy Abrams | \n", "Zach LaVine | \n", "NCAA | \n", "NBA | \n", "
762657 | \n", "5.911154 | \n", "Khadeen Carrington | \n", "Darius Johnson-Odom | \n", "NCAA | \n", "NBA | \n", "
116274 | \n", "5.911482 | \n", "Sterling Brown | \n", "Justise Winslow | \n", "NCAA | \n", "NBA | \n", "
413247 | \n", "6.009668 | \n", "Sviatoslav Mykhailiuk | \n", "Zach LaVine | \n", "NCAA | \n", "NBA | \n", "
676827 | \n", "6.016287 | \n", "Justin Robinson | \n", "Isaiah Canaan | \n", "NCAA | \n", "NBA | \n", "
676826 | \n", "6.016287 | \n", "Justin Robinson | \n", "Isaiah Canaan | \n", "NCAA | \n", "NBA | \n", "
966792 | \n", "6.018570 | \n", "Jordan Murphy | \n", "Marcus Thornton | \n", "NCAA | \n", "NBA | \n", "
967018 | \n", "6.018570 | \n", "Jordan Murphy | \n", "Marcus Thornton | \n", "NCAA | \n", "NBA | \n", "
762514 | \n", "6.030128 | \n", "Khadeen Carrington | \n", "Austin Rivers | \n", "NCAA | \n", "NBA | \n", "
2285549 | \n", "6.036571 | \n", "Darrell Davis | \n", "Jordan Hamilton | \n", "NCAA | \n", "NBA | \n", "
696001 | \n", "6.080880 | \n", "Jack Gibbs | \n", "Isaiah Canaan | \n", "NCAA | \n", "NBA | \n", "
1197419 | \n", "6.142668 | \n", "Xavier Johnson | \n", "Malik Beasley | \n", "NCAA | \n", "NBA | \n", "
1069023 | \n", "6.158689 | \n", "Christian Vital | \n", "Zach LaVine | \n", "NCAA | \n", "NBA | \n", "
1674917 | \n", "6.229392 | \n", "Cullen VanLeer | \n", "Jordan Hamilton | \n", "NCAA | \n", "NBA | \n", "
2468661 | \n", "6.258655 | \n", "Alex Murphy | \n", "Abdel Nader | \n", "NCAA | \n", "NBA | \n", "
2656239 | \n", "6.387709 | \n", "Rob Edwards | \n", "Jordan Williams | \n", "NCAA | \n", "NBA | \n", "
1553807 | \n", "6.409944 | \n", "D.J. Fenner | \n", "Malcolm Lee | \n", "NCAA | \n", "NBA | \n", "
120981 | \n", "6.443540 | \n", "Edrice Adebayo | \n", "Quincy Acy | \n", "NCAA | \n", "NBA | \n", "
2000483 | \n", "6.444821 | \n", "Brynton Lemar | \n", "James Young | \n", "NCAA | \n", "NBA | \n", "
2000410 | \n", "6.457194 | \n", "Brynton Lemar | \n", "Austin Rivers | \n", "NCAA | \n", "NBA | \n", "
2439989 | \n", "6.606846 | \n", "Alexander Aka Gorski | \n", "Jordan Hamilton | \n", "NCAA | \n", "NBA | \n", "
33068 | \n", "6.608452 | \n", "Donovan Mitchell | \n", "Gary Harris | \n", "NCAA | \n", "NBA | \n", "
914535 | \n", "6.698608 | \n", "Kavin Gilder-Tilbury | \n", "Terrence Ross | \n", "NCAA | \n", "NBA | \n", "
280171 | \n", "6.719336 | \n", "London Perrantes | \n", "Tony Snell | \n", "NCAA | \n", "NBA | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
4723217 | \n", "55.659372 | \n", "Sebastian Townes | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4834889 | \n", "55.806828 | \n", "Darius Moore | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4808753 | \n", "55.818913 | \n", "Eliel Gonzalez | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4792121 | \n", "55.901396 | \n", "Mike Green | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4017545 | \n", "55.908765 | \n", "Christian Ellis | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4616297 | \n", "56.092542 | \n", "Isaiah Walton | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4956065 | \n", "56.164070 | \n", "Darrell Riley | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4915673 | \n", "56.267556 | \n", "Sam Hunt | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4958441 | \n", "56.304151 | \n", "Raheem Watts | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4899041 | \n", "56.318796 | \n", "Sam Burmeister | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4918049 | \n", "56.357529 | \n", "Jermaine Marrow | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4925177 | \n", "56.468464 | \n", "Reggie Dillard | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4637681 | \n", "56.498150 | \n", "Matthew Butler | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4685201 | \n", "56.636098 | \n", "Asante Gist | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4908545 | \n", "56.642419 | \n", "Jo'Vontae Millner | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4682825 | \n", "56.740089 | \n", "Josh Boyd | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4782617 | \n", "56.883457 | \n", "Reggie Oliver | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4877657 | \n", "56.946361 | \n", "Charles Tucker Jr. | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4963193 | \n", "56.987312 | \n", "Max Heidegger | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4825385 | \n", "57.088632 | \n", "Delante Jones | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4991705 | \n", "57.289504 | \n", "Amos Given | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4939433 | \n", "57.606328 | \n", "Tyson Batiste | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4708961 | \n", "57.632143 | \n", "Taylor Johnson | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4998833 | \n", "57.667914 | \n", "Marcus Merriweather | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4970321 | \n", "57.728321 | \n", "Rakim Lubin | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4763609 | \n", "57.844177 | \n", "August Haas | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4982201 | \n", "58.519947 | \n", "Rakiya Battle | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4865777 | \n", "58.674243 | \n", "Junior Lomomba | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4984577 | \n", "59.255539 | \n", "Elijah Pughsley | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
4977449 | \n", "59.585905 | \n", "Chris Shields | \n", "Anthony Davis | \n", "NCAA | \n", "NBA | \n", "
570455 rows × 5 columns
\n", "