{ "cells": [ { "cell_type": "code", "execution_count": 34, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import pandas as pd\n", "import pickle\n", "import seaborn as sns\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 24, "metadata": { "collapsed": false }, "outputs": [], "source": [ "with open(\"../data/2015_draft\",'r') as f:\n", " player_data = pickle.load(f)\n", "df = pd.DataFrame(player_data[1:], columns=player_data[0])" ] }, { "cell_type": "code", "execution_count": 25, "metadata": { "collapsed": true }, "outputs": [], "source": [ "df = df.convert_objects(convert_numeric=True)" ] }, { "cell_type": "code", "execution_count": 26, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | Rnd | \n", "Pick | \n", "Tm | \n", "Name | \n", "Pos | \n", "Age | \n", "To | \n", "AP1 | \n", "PB | \n", "St | \n", "... | \n", "TD | \n", "Rec | \n", "Yds | \n", "TD | \n", "Tkl | \n", "Int | \n", "Sk | \n", "College/Univ | \n", "College_Stats | \n", "year | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "1 | \n", "CLE | \n", "Courtney Brown | \n", "DE | \n", "22 | \n", "2005 | \n", "0 | \n", "0 | \n", "4 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "155 | \n", "NaN | \n", "19.0 | \n", "Penn St. | \n", "College Stats | \n", "2000 | \n", "
1 | \n", "1 | \n", "2 | \n", "WAS | \n", "LaVar Arrington | \n", "LB | \n", "22 | \n", "2006 | \n", "0 | \n", "3 | \n", "5 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "331 | \n", "3 | \n", "23.5 | \n", "Penn St. | \n", "College Stats | \n", "2000 | \n", "
2 | \n", "1 | \n", "3 | \n", "WAS | \n", "Chris Samuels | \n", "T | \n", "23 | \n", "2009 | \n", "0 | \n", "6 | \n", "9 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "Alabama | \n", "College Stats | \n", "2000 | \n", "
3 | \n", "1 | \n", "4 | \n", "CIN | \n", "Peter Warrick | \n", "WR | \n", "23 | \n", "2005 | \n", "0 | \n", "0 | \n", "4 | \n", "... | \n", "2 | \n", "275 | \n", "2991 | \n", "18 | \n", "12 | \n", "NaN | \n", "NaN | \n", "Florida St. | \n", "College Stats | \n", "2000 | \n", "
4 | \n", "1 | \n", "5 | \n", "BAL | \n", "Jamal Lewis | \n", "RB | \n", "21 | \n", "2009 | \n", "1 | \n", "1 | \n", "9 | \n", "... | \n", "58 | \n", "221 | \n", "1879 | \n", "4 | \n", "8 | \n", "NaN | \n", "NaN | \n", "Tennessee | \n", "College Stats | \n", "2000 | \n", "
5 rows × 30 columns
\n", "\n", " | Name | \n", "Pos | \n", "Rnd | \n", "Pick | \n", "CarAV | \n", "
---|---|---|---|---|---|
208 | \n", "Tom Brady | \n", "QB | \n", "6 | \n", "199 | \n", "160 | \n", "
299 | \n", "Drew Brees | \n", "QB | \n", "2 | \n", "32 | \n", "147 | \n", "
270 | \n", "LaDainian Tomlinson | \n", "RB | \n", "1 | \n", "5 | \n", "128 | \n", "
522 | \n", "Julius Peppers | \n", "DE | \n", "1 | \n", "2 | \n", "126 | \n", "
1071 | \n", "Philip Rivers | \n", "QB | \n", "1 | \n", "4 | \n", "121 | \n", "
8 | \n", "Brian Urlacher | \n", "LB | \n", "1 | \n", "9 | \n", "118 | \n", "
295 | \n", "Reggie Wayne | \n", "WR | \n", "1 | \n", "30 | \n", "117 | \n", "
1355 | \n", "Aaron Rodgers | \n", "QB | \n", "1 | \n", "24 | \n", "112 | \n", "
1078 | \n", "Ben Roethlisberger | \n", "QB | \n", "1 | \n", "11 | \n", "108 | \n", "
544 | \n", "Ed Reed | \n", "DB | \n", "1 | \n", "24 | \n", "106 | \n", "