{ "metadata": { "name": "" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "df = pd.read_csv('/Users/danielforsyth/Desktop/salaries.csv')\n", "df.head()" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | Rk | \n", "Player | \n", "Tm | \n", "Cap Hit | \n", "2013-14 | \n", "2014-15 | \n", "2015-16 | \n", "2016-17 | \n", "2017-18 | \n", "Signed Using | \n", "Guaranteed | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "Kobe Bryant | \n", "LAL | \n", "30453805 | \n", "30453805 | \n", "23500000 | \n", "25000000 | \n", "NaN | \n", "NaN | \n", "Bird Rights | \n", "78953805 | \n", "
1 | \n", "2 | \n", "Dirk Nowitzki | \n", "DAL | \n", "22721381 | \n", "22721381 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Bird Rights | \n", "22721381 | \n", "
2 | \n", "3 | \n", "Amar'e Stoudemire | \n", "NYK | \n", "21679893 | \n", "21679893 | \n", "23410988 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Bird Rights | \n", "45090881 | \n", "
3 | \n", "4 | \n", "Joe Johnson | \n", "BRK | \n", "21466718 | \n", "21466718 | \n", "23180790 | \n", "24894863 | \n", "NaN | \n", "NaN | \n", "Bird Rights | \n", "69542371 | \n", "
4 | \n", "5 | \n", "Carmelo Anthony | \n", "NYK | \n", "21388953 | \n", "21388953 | \n", "23333405 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Bird Rights | \n", "44722359 | \n", "
5 rows \u00d7 11 columns
\n", "\n", " | Player | \n", "Cap Hit | \n", "
---|---|---|
0 | \n", "Kobe Bryant | \n", "30453805 | \n", "
1 | \n", "Dirk Nowitzki | \n", "22721381 | \n", "
2 | \n", "Amar'e Stoudemire | \n", "21679893 | \n", "
3 | \n", "Joe Johnson | \n", "21466718 | \n", "
4 | \n", "Carmelo Anthony | \n", "21388953 | \n", "
5 rows \u00d7 2 columns
\n", "\n", " | Rk | \n", "Player | \n", "Pos | \n", "Age | \n", "Tm | \n", "G | \n", "MP | \n", "PER | \n", "TS% | \n", "eFG% | \n", "FTr | \n", "3PAr | \n", "ORB% | \n", "DRB% | \n", "TRB% | \n", "AST% | \n", "STL% | \n", "BLK% | \n", "TOV% | \n", "USG% | \n", "\n", " |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "DeAndre Liggins | \n", "SG | \n", "25 | \n", "MIA | \n", "1 | \n", "1 | \n", "128.3 | \n", "1.000 | \n", "1.000 | \n", "0.000 | \n", "0.000 | \n", "100.0 | \n", "0.0 | \n", "62.5 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "47.5 | \n", "... | \n", "
1 | \n", "2 | \n", "Tony Mitchell | \n", "SF | \n", "24 | \n", "MIL | \n", "3 | \n", "10 | \n", "31.0 | \n", "0.600 | \n", "0.600 | \n", "0.000 | \n", "0.200 | \n", "11.0 | \n", "0.0 | \n", "5.7 | \n", "22.7 | \n", "5.2 | \n", "0.0 | \n", "0.0 | \n", "22.6 | \n", "... | \n", "
2 | \n", "3 | \n", "Kevin Durant | \n", "SF | \n", "25 | \n", "OKC | \n", "69 | \n", "2654 | \n", "30.4 | \n", "0.639 | \n", "0.564 | \n", "0.488 | \n", "0.285 | \n", "2.2 | \n", "19.4 | \n", "11.2 | \n", "27.2 | \n", "1.7 | \n", "1.6 | \n", "12.4 | \n", "32.9 | \n", "... | \n", "
3 | \n", "4 | \n", "LeBron James | \n", "PF | \n", "29 | \n", "MIA | \n", "66 | \n", "2489 | \n", "29.1 | \n", "0.649 | \n", "0.612 | \n", "0.420 | \n", "0.221 | \n", "3.6 | \n", "18.6 | \n", "11.4 | \n", "31.7 | \n", "2.3 | \n", "0.8 | \n", "14.4 | \n", "30.4 | \n", "... | \n", "
4 | \n", "5 | \n", "Kevin Love | \n", "PF | \n", "25 | \n", "MIN | \n", "66 | \n", "2408 | \n", "27.9 | \n", "0.594 | \n", "0.528 | \n", "0.449 | \n", "0.350 | \n", "8.6 | \n", "29.8 | \n", "18.8 | \n", "20.9 | \n", "1.1 | \n", "1.0 | \n", "9.4 | \n", "28.7 | \n", "... | \n", "
5 rows \u00d7 26 columns
\n", "\n", " | Player | \n", "PER | \n", "MPG | \n", "
---|---|---|---|
2 | \n", "Kevin Durant | \n", "30.4 | \n", "38.463768 | \n", "
3 | \n", "LeBron James | \n", "29.1 | \n", "37.712121 | \n", "
4 | \n", "Kevin Love | \n", "27.9 | \n", "36.484848 | \n", "
5 | \n", "Anthony Davis | \n", "27.2 | \n", "36.245902 | \n", "
6 | \n", "Chris Paul | \n", "26.1 | \n", "34.826923 | \n", "
5 rows \u00d7 3 columns
\n", "\n", " | Rk | \n", "Player | \n", "Cap Hit | \n", "PER | \n", "MPG | \n", "
---|---|---|---|---|---|
0 | \n", "1 | \n", "Kobe Bryant | \n", "30453805 | \n", "10.9 | \n", "29.500000 | \n", "
1 | \n", "2 | \n", "Dirk Nowitzki | \n", "22721381 | \n", "23.2 | \n", "32.318841 | \n", "
2 | \n", "3 | \n", "Amar'e Stoudemire | \n", "21679893 | \n", "18.6 | \n", "21.296296 | \n", "
3 | \n", "4 | \n", "Joe Johnson | \n", "21466718 | \n", "15.1 | \n", "32.895522 | \n", "
4 | \n", "5 | \n", "Carmelo Anthony | \n", "21388953 | \n", "24.9 | \n", "38.820896 | \n", "
5 rows \u00d7 5 columns
\n", "\n", " | Player | \n", "Cap Hit | \n", "PER | \n", "MPG | \n", "
---|---|---|---|---|
0 | \n", "Kobe Bryant | \n", "30453805 | \n", "10.9 | \n", "29.500000 | \n", "
1 | \n", "Dirk Nowitzki | \n", "22721381 | \n", "23.2 | \n", "32.318841 | \n", "
2 | \n", "Amar'e Stoudemire | \n", "21679893 | \n", "18.6 | \n", "21.296296 | \n", "
3 | \n", "Joe Johnson | \n", "21466718 | \n", "15.1 | \n", "32.895522 | \n", "
4 | \n", "Carmelo Anthony | \n", "21388953 | \n", "24.9 | \n", "38.820896 | \n", "
5 rows \u00d7 4 columns
\n", "\n", " | Cap Hit | \n", "PER | \n", "MPG | \n", "
---|---|---|---|
Cap Hit | \n", "1.000000 | \n", "0.502899 | \n", "0.574893 | \n", "
PER | \n", "0.502899 | \n", "1.000000 | \n", "0.654308 | \n", "
MPG | \n", "0.574893 | \n", "0.654308 | \n", "1.000000 | \n", "
3 rows \u00d7 3 columns
\n", "\n", " | RK | \n", "PLAYER | \n", "GP | \n", "MPG | \n", "AST | \n", "TO | \n", "USG | \n", "ORR | \n", "DRR | \n", "REBR | \n", "PER | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "Doug McDermott, CREI | \n", "33 | \n", "33.6 | \n", "6.6 | \n", "7.7 | \n", "27.8 | \n", "5.7 | \n", "18.5 | \n", "12.1 | \n", "33.68 | \n", "
1 | \n", "2 | \n", "Alan Williams, UCSB | \n", "26 | \n", "31.7 | \n", "5.4 | \n", "10.2 | \n", "27.1 | \n", "13.2 | \n", "28.4 | \n", "20.8 | \n", "33.37 | \n", "
2 | \n", "3 | \n", "De'Mon Brooks, DAV | \n", "26 | \n", "26.8 | \n", "7.8 | \n", "12.9 | \n", "24.2 | \n", "10.4 | \n", "22.6 | \n", "16.5 | \n", "32.13 | \n", "
3 | \n", "4 | \n", "T.J. Warren, NCST | \n", "33 | \n", "35.3 | \n", "4.5 | \n", "9.6 | \n", "28.0 | \n", "10.9 | \n", "13.1 | \n", "12.0 | \n", "32.06 | \n", "
4 | \n", "5 | \n", "Javonte Green, RAD | \n", "30 | \n", "26.1 | \n", "6.1 | \n", "10.8 | \n", "23.0 | \n", "9.7 | \n", "27.7 | \n", "18.7 | \n", "30.61 | \n", "
5 rows \u00d7 11 columns
\n", "\n", " | PLAYER | \n", "PER | \n", "
---|---|---|
0 | \n", "Doug McDermott, CREI | \n", "33.68 | \n", "
1 | \n", "Alan Williams, UCSB | \n", "33.37 | \n", "
2 | \n", "De'Mon Brooks, DAV | \n", "32.13 | \n", "
3 | \n", "T.J. Warren, NCST | \n", "32.06 | \n", "
4 | \n", "Javonte Green, RAD | \n", "30.61 | \n", "
5 rows \u00d7 2 columns
\n", "\n", " | PLAYER | \n", "PER | \n", "Predicted Salary | \n", "
---|---|---|---|
0 | \n", "Doug McDermott, CREI | \n", "33.68 | \n", "14560859.24 | \n", "
1 | \n", "Alan Williams, UCSB | \n", "33.37 | \n", "14406288.32 | \n", "
2 | \n", "De'Mon Brooks, DAV | \n", "32.13 | \n", "13788004.62 | \n", "
3 | \n", "T.J. Warren, NCST | \n", "32.06 | \n", "13753101.51 | \n", "
4 | \n", "Javonte Green, RAD | \n", "30.61 | \n", "13030108.47 | \n", "
5 | \n", "John Brown, HP | \n", "30.56 | \n", "13005177.68 | \n", "
6 | \n", "Javon McCrea, BUFF | \n", "30.30 | \n", "12875537.55 | \n", "
7 | \n", "Frank Kaminsky, WIS | \n", "29.73 | \n", "12591326.49 | \n", "
8 | \n", "Cameron Bairstow, UNM | \n", "29.68 | \n", "12566395.70 | \n", "
9 | \n", "Jabari Parker, DUKE | \n", "29.46 | \n", "12456700.20 | \n", "
10 | \n", "Troy Huff, UND | \n", "29.44 | \n", "12446727.89 | \n", "
11 | \n", "Billy Baron, CAN | \n", "29.38 | \n", "12416810.93 | \n", "
12 | \n", "Justin Sears, YALE | \n", "28.98 | \n", "12217364.58 | \n", "
13 | \n", "Jordan Parks, NCCU | \n", "28.90 | \n", "12177475.31 | \n", "
14 | \n", "Brad Waldow, SMC | \n", "28.83 | \n", "12142572.19 | \n", "
15 rows \u00d7 3 columns
\n", "