{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's find the top individual series by shot attempts."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import PbPMethods2 as pm2\n",
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"
\n",
" \n",
" \n",
" | \n",
" Player | \n",
" Team | \n",
" Pos | \n",
" Game | \n",
" Season | \n",
" Date | \n",
" TOION(60s) | \n",
" CFON | \n",
" CAON | \n",
" TOIOFF(60s) | \n",
" ... | \n",
" NZS | \n",
" OZS | \n",
" iG | \n",
" iCF | \n",
" iA1 | \n",
" iA2 | \n",
" SACFON | \n",
" SACAON | \n",
" SACFOFF | \n",
" SACAOFF | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" Patrick O'Sullivan | \n",
" L.A | \n",
" F | \n",
" 20001 | \n",
" 2007 | \n",
" 29-Sep-07 | \n",
" 0.110556 | \n",
" 3 | \n",
" 4 | \n",
" 0.457500 | \n",
" ... | \n",
" 2 | \n",
" 2 | \n",
" 0 | \n",
" 1 | \n",
" 0 | \n",
" 0 | \n",
" 3.324 | \n",
" 3.554 | \n",
" 8.560 | \n",
" 22.067 | \n",
"
\n",
" \n",
" 1 | \n",
" Tom Preissing | \n",
" L.A | \n",
" D | \n",
" 20001 | \n",
" 2007 | \n",
" 29-Sep-07 | \n",
" 0.154444 | \n",
" 5 | \n",
" 7 | \n",
" 0.413611 | \n",
" ... | \n",
" 4 | \n",
" 2 | \n",
" 0 | \n",
" 1 | \n",
" 0 | \n",
" 0 | \n",
" 5.430 | \n",
" 6.509 | \n",
" 6.454 | \n",
" 19.112 | \n",
"
\n",
" \n",
" 2 | \n",
" Lubomir Visnovsky | \n",
" L.A | \n",
" D | \n",
" 20001 | \n",
" 2007 | \n",
" 29-Sep-07 | \n",
" 0.185833 | \n",
" 2 | \n",
" 9 | \n",
" 0.382222 | \n",
" ... | \n",
" 5 | \n",
" 3 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 2.077 | \n",
" 8.354 | \n",
" 9.807 | \n",
" 17.267 | \n",
"
\n",
" \n",
" 3 | \n",
" Raitis Ivanans | \n",
" L.A | \n",
" F | \n",
" 20001 | \n",
" 2007 | \n",
" 29-Sep-07 | \n",
" 0.059722 | \n",
" 1 | \n",
" 2 | \n",
" 0.508333 | \n",
" ... | \n",
" 2 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 1.120 | \n",
" 1.826 | \n",
" 10.764 | \n",
" 23.795 | \n",
"
\n",
" \n",
" 4 | \n",
" Dustin Brown | \n",
" L.A | \n",
" F | \n",
" 20001 | \n",
" 2007 | \n",
" 29-Sep-07 | \n",
" 0.163889 | \n",
" 4 | \n",
" 9 | \n",
" 0.404167 | \n",
" ... | \n",
" 3 | \n",
" 2 | \n",
" 0 | \n",
" 1 | \n",
" 0 | \n",
" 0 | \n",
" 4.228 | \n",
" 8.040 | \n",
" 7.656 | \n",
" 17.581 | \n",
"
\n",
" \n",
"
\n",
"
5 rows × 35 columns
\n",
"
"
],
"text/plain": [
" Player Team Pos Game Season Date TOION(60s) CFON \\\n",
"0 Patrick O'Sullivan L.A F 20001 2007 29-Sep-07 0.110556 3 \n",
"1 Tom Preissing L.A D 20001 2007 29-Sep-07 0.154444 5 \n",
"2 Lubomir Visnovsky L.A D 20001 2007 29-Sep-07 0.185833 2 \n",
"3 Raitis Ivanans L.A F 20001 2007 29-Sep-07 0.059722 1 \n",
"4 Dustin Brown L.A F 20001 2007 29-Sep-07 0.163889 4 \n",
"\n",
" CAON TOIOFF(60s) ... NZS OZS iG iCF iA1 iA2 SACFON SACAON \\\n",
"0 4 0.457500 ... 2 2 0 1 0 0 3.324 3.554 \n",
"1 7 0.413611 ... 4 2 0 1 0 0 5.430 6.509 \n",
"2 9 0.382222 ... 5 3 0 0 0 0 2.077 8.354 \n",
"3 2 0.508333 ... 2 0 0 0 0 0 1.120 1.826 \n",
"4 9 0.404167 ... 3 2 0 1 0 0 4.228 8.040 \n",
"\n",
" SACFOFF SACAOFF \n",
"0 8.560 22.067 \n",
"1 6.454 19.112 \n",
"2 9.807 17.267 \n",
"3 10.764 23.795 \n",
"4 7.656 17.581 \n",
"\n",
"[5 rows x 35 columns]"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dfs = []\n",
"for season in range(2007, 2017):\n",
" dfs.append(pd.read_csv(pm2.get_gamebygame_data_filename(season)))\n",
"dfs = pd.concat(dfs)\n",
"dfs.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Filter for the playoffs and add a variable with the round number"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Player | \n",
" Team | \n",
" Game | \n",
" Season | \n",
" TOION(60s) | \n",
" CFON | \n",
" CAON | \n",
" Round | \n",
"
\n",
" \n",
" \n",
" \n",
" 44227 | \n",
" Alex Kovalev | \n",
" MTL | \n",
" 30111 | \n",
" 2007 | \n",
" 0.205278 | \n",
" 15 | \n",
" 12 | \n",
" 1 | \n",
"
\n",
" \n",
" 44228 | \n",
" Steve Begin | \n",
" MTL | \n",
" 30111 | \n",
" 2007 | \n",
" 0.134444 | \n",
" 5 | \n",
" 8 | \n",
" 1 | \n",
"
\n",
" \n",
" 44229 | \n",
" Maxim Lapierre | \n",
" MTL | \n",
" 30111 | \n",
" 2007 | \n",
" 0.183611 | \n",
" 12 | \n",
" 15 | \n",
" 1 | \n",
"
\n",
" \n",
" 44230 | \n",
" Mike Komisarek | \n",
" MTL | \n",
" 30111 | \n",
" 2007 | \n",
" 0.214722 | \n",
" 19 | \n",
" 13 | \n",
" 1 | \n",
"
\n",
" \n",
" 44231 | \n",
" Mark Streit | \n",
" MTL | \n",
" 30111 | \n",
" 2007 | \n",
" 0.201111 | \n",
" 14 | \n",
" 15 | \n",
" 1 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Player Team Game Season TOION(60s) CFON CAON Round\n",
"44227 Alex Kovalev MTL 30111 2007 0.205278 15 12 1\n",
"44228 Steve Begin MTL 30111 2007 0.134444 5 8 1\n",
"44229 Maxim Lapierre MTL 30111 2007 0.183611 12 15 1\n",
"44230 Mike Komisarek MTL 30111 2007 0.214722 19 13 1\n",
"44231 Mark Streit MTL 30111 2007 0.201111 14 15 1"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"playoffs = dfs.query('Game > 30000')\n",
"playoffs = playoffs[['Player', 'Team', 'Game', 'Season', 'TOION(60s)', 'CFON', 'CAON']]\n",
"playoffs['Round'] = (playoffs['Game'] - 30000) // 100\n",
"playoffs.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Group by round to get gp and counts"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Player | \n",
" Team | \n",
" Season | \n",
" Round | \n",
" GP | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" Aaron Ekblad | \n",
" FLA | \n",
" 2015 | \n",
" 1 | \n",
" 6 | \n",
"
\n",
" \n",
" 1 | \n",
" Aaron Rome | \n",
" CBJ | \n",
" 2008 | \n",
" 1 | \n",
" 1 | \n",
"
\n",
" \n",
" 2 | \n",
" Aaron Rome | \n",
" DAL | \n",
" 2013 | \n",
" 1 | \n",
" 1 | \n",
"
\n",
" \n",
" 3 | \n",
" Aaron Rome | \n",
" VAN | \n",
" 2009 | \n",
" 1 | \n",
" 1 | \n",
"
\n",
" \n",
" 4 | \n",
" Aaron Rome | \n",
" VAN | \n",
" 2010 | \n",
" 1 | \n",
" 2 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Player Team Season Round GP\n",
"0 Aaron Ekblad FLA 2015 1 6\n",
"1 Aaron Rome CBJ 2008 1 1\n",
"2 Aaron Rome DAL 2013 1 1\n",
"3 Aaron Rome VAN 2009 1 1\n",
"4 Aaron Rome VAN 2010 1 2"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"player_gp = playoffs.groupby(['Player', 'Team', 'Season', 'Round']).count()\n",
"player_gp.reset_index(inplace = True)\n",
"player_gp.rename(columns = {'Game': 'GP'}, inplace = True)\n",
"player_gp = player_gp[['Player', 'Team', 'Season', 'Round', 'GP']]\n",
"player_gp.head()"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Player | \n",
" Team | \n",
" Season | \n",
" Round | \n",
" TOION(60s) | \n",
" CFON | \n",
" CAON | \n",
" GP | \n",
" CF60 | \n",
" CA60 | \n",
" CD60 | \n",
"
\n",
" \n",
" \n",
" \n",
" 3253 | \n",
" Lars Eller | \n",
" MTL | \n",
" 2012 | \n",
" 1 | \n",
" 0.100556 | \n",
" 15 | \n",
" 2 | \n",
" 1 | \n",
" 149.171271 | \n",
" 19.889503 | \n",
" 129.281768 | \n",
"
\n",
" \n",
" 4533 | \n",
" Patrick Wiercioch | \n",
" OTT | \n",
" 2012 | \n",
" 1 | \n",
" 0.019167 | \n",
" 3 | \n",
" 1 | \n",
" 1 | \n",
" 156.521739 | \n",
" 52.173913 | \n",
" 104.347826 | \n",
"
\n",
" \n",
" 337 | \n",
" Andrew Shaw | \n",
" CHI | \n",
" 2013 | \n",
" 2 | \n",
" 0.050278 | \n",
" 6 | \n",
" 1 | \n",
" 1 | \n",
" 119.337017 | \n",
" 19.889503 | \n",
" 99.447514 | \n",
"
\n",
" \n",
" 4815 | \n",
" Robert Bortuzzo | \n",
" STL | \n",
" 2015 | \n",
" 2 | \n",
" 0.195833 | \n",
" 20 | \n",
" 3 | \n",
" 1 | \n",
" 102.127660 | \n",
" 15.319149 | \n",
" 86.808511 | \n",
"
\n",
" \n",
" 2569 | \n",
" Jimmy Hayes | \n",
" CHI | \n",
" 2011 | \n",
" 1 | \n",
" 0.334722 | \n",
" 37 | \n",
" 9 | \n",
" 2 | \n",
" 110.539419 | \n",
" 26.887967 | \n",
" 83.651452 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Player Team Season Round TOION(60s) CFON CAON GP \\\n",
"3253 Lars Eller MTL 2012 1 0.100556 15 2 1 \n",
"4533 Patrick Wiercioch OTT 2012 1 0.019167 3 1 1 \n",
"337 Andrew Shaw CHI 2013 2 0.050278 6 1 1 \n",
"4815 Robert Bortuzzo STL 2015 2 0.195833 20 3 1 \n",
"2569 Jimmy Hayes CHI 2011 1 0.334722 37 9 2 \n",
"\n",
" CF60 CA60 CD60 \n",
"3253 149.171271 19.889503 129.281768 \n",
"4533 156.521739 52.173913 104.347826 \n",
"337 119.337017 19.889503 99.447514 \n",
"4815 102.127660 15.319149 86.808511 \n",
"2569 110.539419 26.887967 83.651452 "
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"player_rounds = playoffs.groupby(['Player', 'Team', 'Season', 'Round']).sum()\n",
"player_rounds.drop(['Game'], axis = 1, inplace = True)\n",
"player_rounds.reset_index(inplace = True)\n",
"\n",
"#Join to get the gp column\n",
"player_rounds = player_rounds.merge(player_gp, on = ['Player', 'Team', 'Season', 'Round'], how = 'inner')\n",
"\n",
"player_rounds['CF60'] = player_rounds['CFON'] / player_rounds['TOION(60s)']\n",
"player_rounds['CA60'] = player_rounds['CAON'] / player_rounds['TOION(60s)']\n",
"player_rounds['CD60'] = player_rounds['CF60'] - player_rounds['CA60']\n",
"player_rounds.sort_values(by = 'CD60', ascending = False, inplace = True)\n",
"player_rounds.head()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Filter for at least six games (optional)"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Player | \n",
" Team | \n",
" Season | \n",
" Round | \n",
" TOION(60s) | \n",
" CFON | \n",
" CAON | \n",
" GP | \n",
" CF60 | \n",
" CA60 | \n",
" CD60 | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" Andre Burakovsky | \n",
" WSH | \n",
" 2016 | \n",
" 2 | \n",
" 1.198889 | \n",
" 111 | \n",
" 43 | \n",
" 6 | \n",
" 92.585728 | \n",
" 35.866543 | \n",
" 56.719184 | \n",
"
\n",
" \n",
" 1 | \n",
" Jiri Hudler | \n",
" DET | \n",
" 2007 | \n",
" 1 | \n",
" 0.895556 | \n",
" 77 | \n",
" 32 | \n",
" 6 | \n",
" 85.980149 | \n",
" 35.732010 | \n",
" 50.248139 | \n",
"
\n",
" \n",
" 2 | \n",
" Henrik Sedin | \n",
" VAN | \n",
" 2014 | \n",
" 1 | \n",
" 1.407222 | \n",
" 112 | \n",
" 43 | \n",
" 6 | \n",
" 79.589420 | \n",
" 30.556652 | \n",
" 49.032767 | \n",
"
\n",
" \n",
" 3 | \n",
" Henrik Zetterberg | \n",
" DET | \n",
" 2007 | \n",
" 4 | \n",
" 1.705556 | \n",
" 154 | \n",
" 71 | \n",
" 6 | \n",
" 90.293160 | \n",
" 41.628664 | \n",
" 48.664495 | \n",
"
\n",
" \n",
" 4 | \n",
" Marc-Andre Bergeron | \n",
" T.B | \n",
" 2010 | \n",
" 3 | \n",
" 1.525556 | \n",
" 127 | \n",
" 56 | \n",
" 7 | \n",
" 83.248361 | \n",
" 36.707939 | \n",
" 46.540422 | \n",
"
\n",
" \n",
" 5 | \n",
" Chris Chelios | \n",
" DET | \n",
" 2007 | \n",
" 1 | \n",
" 0.940278 | \n",
" 73 | \n",
" 30 | \n",
" 6 | \n",
" 77.636632 | \n",
" 31.905465 | \n",
" 45.731167 | \n",
"
\n",
" \n",
" 6 | \n",
" Chris Kunitz | \n",
" PIT | \n",
" 2010 | \n",
" 1 | \n",
" 1.165278 | \n",
" 97 | \n",
" 45 | \n",
" 6 | \n",
" 83.241955 | \n",
" 38.617402 | \n",
" 44.624553 | \n",
"
\n",
" \n",
" 7 | \n",
" Mikael Samuelsson | \n",
" DET | \n",
" 2007 | \n",
" 1 | \n",
" 1.242500 | \n",
" 101 | \n",
" 46 | \n",
" 6 | \n",
" 81.287726 | \n",
" 37.022133 | \n",
" 44.265594 | \n",
"
\n",
" \n",
" 8 | \n",
" Daniel Sedin | \n",
" VAN | \n",
" 2014 | \n",
" 1 | \n",
" 1.383611 | \n",
" 107 | \n",
" 46 | \n",
" 6 | \n",
" 77.333869 | \n",
" 33.246336 | \n",
" 44.087533 | \n",
"
\n",
" \n",
" 9 | \n",
" Darren Helm | \n",
" DET | \n",
" 2007 | \n",
" 4 | \n",
" 0.639722 | \n",
" 40 | \n",
" 12 | \n",
" 6 | \n",
" 62.527139 | \n",
" 18.758142 | \n",
" 43.768997 | \n",
"
\n",
" \n",
" 10 | \n",
" Sidney Crosby | \n",
" PIT | \n",
" 2009 | \n",
" 1 | \n",
" 1.568056 | \n",
" 135 | \n",
" 67 | \n",
" 6 | \n",
" 86.093888 | \n",
" 42.728078 | \n",
" 43.365810 | \n",
"
\n",
" \n",
" 11 | \n",
" Lars Eller | \n",
" WSH | \n",
" 2016 | \n",
" 2 | \n",
" 1.131667 | \n",
" 103 | \n",
" 54 | \n",
" 6 | \n",
" 91.016200 | \n",
" 47.717231 | \n",
" 43.298969 | \n",
"
\n",
" \n",
" 12 | \n",
" Mike Green | \n",
" WSH | \n",
" 2009 | \n",
" 1 | \n",
" 1.993056 | \n",
" 192 | \n",
" 108 | \n",
" 7 | \n",
" 96.334495 | \n",
" 54.188153 | \n",
" 42.146341 | \n",
"
\n",
" \n",
" 13 | \n",
" Pavel Datsyuk | \n",
" DET | \n",
" 2008 | \n",
" 2 | \n",
" 1.853056 | \n",
" 133 | \n",
" 55 | \n",
" 7 | \n",
" 71.773347 | \n",
" 29.680708 | \n",
" 42.092640 | \n",
"
\n",
" \n",
" 14 | \n",
" Brian Rafalski | \n",
" DET | \n",
" 2007 | \n",
" 4 | \n",
" 1.958056 | \n",
" 161 | \n",
" 79 | \n",
" 6 | \n",
" 82.224429 | \n",
" 40.346148 | \n",
" 41.878281 | \n",
"
\n",
" \n",
" 15 | \n",
" Joe Pavelski | \n",
" S.J | \n",
" 2009 | \n",
" 1 | \n",
" 1.516111 | \n",
" 126 | \n",
" 63 | \n",
" 6 | \n",
" 83.107365 | \n",
" 41.553683 | \n",
" 41.553683 | \n",
"
\n",
" \n",
" 16 | \n",
" Brett Lebda | \n",
" DET | \n",
" 2007 | \n",
" 4 | \n",
" 1.305000 | \n",
" 95 | \n",
" 41 | \n",
" 6 | \n",
" 72.796935 | \n",
" 31.417625 | \n",
" 41.379310 | \n",
"
\n",
" \n",
" 17 | \n",
" Jiri Hudler | \n",
" DET | \n",
" 2007 | \n",
" 4 | \n",
" 0.945556 | \n",
" 64 | \n",
" 25 | \n",
" 6 | \n",
" 67.685076 | \n",
" 26.439483 | \n",
" 41.245593 | \n",
"
\n",
" \n",
" 18 | \n",
" Tomas Holmstrom | \n",
" DET | \n",
" 2008 | \n",
" 2 | \n",
" 1.370000 | \n",
" 97 | \n",
" 42 | \n",
" 7 | \n",
" 70.802920 | \n",
" 30.656934 | \n",
" 40.145985 | \n",
"
\n",
" \n",
" 19 | \n",
" Ryane Clowe | \n",
" S.J | \n",
" 2009 | \n",
" 1 | \n",
" 1.588611 | \n",
" 131 | \n",
" 68 | \n",
" 6 | \n",
" 82.461969 | \n",
" 42.804686 | \n",
" 39.657283 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Player Team Season Round TOION(60s) CFON CAON GP \\\n",
"0 Andre Burakovsky WSH 2016 2 1.198889 111 43 6 \n",
"1 Jiri Hudler DET 2007 1 0.895556 77 32 6 \n",
"2 Henrik Sedin VAN 2014 1 1.407222 112 43 6 \n",
"3 Henrik Zetterberg DET 2007 4 1.705556 154 71 6 \n",
"4 Marc-Andre Bergeron T.B 2010 3 1.525556 127 56 7 \n",
"5 Chris Chelios DET 2007 1 0.940278 73 30 6 \n",
"6 Chris Kunitz PIT 2010 1 1.165278 97 45 6 \n",
"7 Mikael Samuelsson DET 2007 1 1.242500 101 46 6 \n",
"8 Daniel Sedin VAN 2014 1 1.383611 107 46 6 \n",
"9 Darren Helm DET 2007 4 0.639722 40 12 6 \n",
"10 Sidney Crosby PIT 2009 1 1.568056 135 67 6 \n",
"11 Lars Eller WSH 2016 2 1.131667 103 54 6 \n",
"12 Mike Green WSH 2009 1 1.993056 192 108 7 \n",
"13 Pavel Datsyuk DET 2008 2 1.853056 133 55 7 \n",
"14 Brian Rafalski DET 2007 4 1.958056 161 79 6 \n",
"15 Joe Pavelski S.J 2009 1 1.516111 126 63 6 \n",
"16 Brett Lebda DET 2007 4 1.305000 95 41 6 \n",
"17 Jiri Hudler DET 2007 4 0.945556 64 25 6 \n",
"18 Tomas Holmstrom DET 2008 2 1.370000 97 42 7 \n",
"19 Ryane Clowe S.J 2009 1 1.588611 131 68 6 \n",
"\n",
" CF60 CA60 CD60 \n",
"0 92.585728 35.866543 56.719184 \n",
"1 85.980149 35.732010 50.248139 \n",
"2 79.589420 30.556652 49.032767 \n",
"3 90.293160 41.628664 48.664495 \n",
"4 83.248361 36.707939 46.540422 \n",
"5 77.636632 31.905465 45.731167 \n",
"6 83.241955 38.617402 44.624553 \n",
"7 81.287726 37.022133 44.265594 \n",
"8 77.333869 33.246336 44.087533 \n",
"9 62.527139 18.758142 43.768997 \n",
"10 86.093888 42.728078 43.365810 \n",
"11 91.016200 47.717231 43.298969 \n",
"12 96.334495 54.188153 42.146341 \n",
"13 71.773347 29.680708 42.092640 \n",
"14 82.224429 40.346148 41.878281 \n",
"15 83.107365 41.553683 41.553683 \n",
"16 72.796935 31.417625 41.379310 \n",
"17 67.685076 26.439483 41.245593 \n",
"18 70.802920 30.656934 40.145985 \n",
"19 82.461969 42.804686 39.657283 "
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"temp = player_rounds.query('GP >= 6')\n",
"temp.reset_index(inplace = True, drop = True) #so index = ranks\n",
"temp.head(20)"
]
}
],
"metadata": {
"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.4.3"
}
},
"nbformat": 4,
"nbformat_minor": 0
}