Receiving Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Populating the interactive namespace from numpy and matplotlib\n"
     ]
    }
   ],
   "source": [
    "%pylab inline\n",
    "import pandas as pd\n",
    "from os import listdir\n",
    "from os.path import isfile, join"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['YW-Dogs 2017-03-11_09-15.csv',\n",
       " 'PH-Dogs 2017-03-03_16-00.csv',\n",
       " 'CI-Vapour 2017-03-29_16-30.csv',\n",
       " 'HK-Joint 2017-05-20_09-00.csv',\n",
       " 'BN-Wolves 2017-04-08_14-45.csv',\n",
       " 'DQ-Cheetahs 2017-05-12_15-45.csv',\n",
       " 'NO-Mosquitos1 2017-04-08_11-00.csv',\n",
       " 'SC-Warriors 2017-05-09_16-30.csv',\n",
       " 'BJ-Tornados 2017-05-21_09-00.csv',\n",
       " 'YK-Buddha 2017-03-11_12-30.csv',\n",
       " 'NO-Mosquitos2 2017-04-08_10-00.csv',\n",
       " 'YK-Buddha 2017-03-11_14-30.csv',\n",
       " 'NM-Lions 2017-03-17_16-00.csv',\n",
       " 'JK-Sea Otters 2017-03-31_15-45.csv',\n",
       " 'CI-Vapour 2017-05-20_12-00.csv',\n",
       " 'DQ-Cheetahs 2017-03-11_13-40.csv',\n",
       " 'KC-Gators 2017-03-11_11-30.csv',\n",
       " 'TJ-Donut1 2017-04-08_13-30.csv',\n",
       " 'DQ-Cheetahs 2017-02-24_16-15.csv',\n",
       " 'CI-HZSR 2017-05-21_15-50.csv',\n",
       " 'NM-Lions 2017-05-20_10-00.csv',\n",
       " 'YW-Dogs 2017-03-24_16-00.csv',\n",
       " 'SC-Warriors 2017-04-21_15-00.csv',\n",
       " 'NM-Lions 2017-05-21_12-20.csv',\n",
       " 'LW-Kraken 2017-05-20_15-00.csv']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mypath = 'WY-Wolves/'\n",
    "onlyfiles = [f for f in listdir(mypath) if isfile(join(mypath, f))]\n",
    "games = []\n",
    "for f in onlyfiles:\n",
    "    if('vs.' in f):\n",
    "        idx = f.index('vs.')\n",
    "        games.append(f[idx + 4:])\n",
    "\n",
    "games = list(set(games))\n",
    "games"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def single_game_single_thrower(receiver, thrower, df):\n",
    "    #df should be passed in\n",
    "    data = {'Drops': len(df[df['Receiver error?'] == 1]),\n",
    "            'Catches': len(df[df['Turnover?'] == 0]),\n",
    "            'Throwaways': len(df[df['Thrower error?'] == 1]),\n",
    "            'Attempts': len(df[df['Receiver error?'] == 1]) + len(df[df['Turnover?'] == 0]) + len(df[df['Thrower error?'] == 1]),\n",
    "            'Goals': len(df[df['Assist?'] == 1])}\n",
    "    return pd.Series(data)\n",
    "\n",
    "def single_game_passing_data(receiver, game):\n",
    "    df = pd.read_csv('WY-Wolves/Passes vs. ' + game)\n",
    "    df = df[df['Receiver'] == receiver]\n",
    "    data = pd.DataFrame(columns=['Drops', 'Catches', 'Catch Pct', 'Throwaways', 'Attempts', 'Goals'], index=['Thrower'])\n",
    "    for thrower, frame in df.groupby('Thrower'):\n",
    "        data.loc[thrower] = single_game_single_thrower(receiver, thrower, frame)\n",
    "\n",
    "    return data\n",
    "\n",
    "def player_receiving_data(receiver):\n",
    "    # Statto\n",
    "    data = single_game_passing_data(receiver, games[0])\n",
    "    for game in games[1:]:\n",
    "        data = data.add(single_game_passing_data(receiver, game), fill_value=0)\n",
    "\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Drops</th>\n",
       "      <th>Catches</th>\n",
       "      <th>Catch Pct</th>\n",
       "      <th>Throwaways</th>\n",
       "      <th>Attempts</th>\n",
       "      <th>Goals</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>#22 Paul Simpson</th>\n",
       "      <td>4</td>\n",
       "      <td>75</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>88</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#27 Daniel Zhang</th>\n",
       "      <td>3</td>\n",
       "      <td>52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>61</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#55 Tigger Li</th>\n",
       "      <td>5</td>\n",
       "      <td>28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>39</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 Joyce Wang</th>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Oscar Yao</th>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#19 Ben Wang</th>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#28 Tina Zhu</th>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#66 Jerry Chen</th>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#0 Julie Luo</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#76 Jack Xia</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#69 Justin Chen</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Peter</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#52 Emily Zhang</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#39 David Xiao</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#2 Jamie Chen</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Melody Zheng</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#11 Momoka Goto</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#41 Billy Ni</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thrower</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Drops Catches Catch Pct Throwaways Attempts Goals\n",
       "#22 Paul Simpson     4      75       NaN          9       88     5\n",
       "#27 Daniel Zhang     3      52       NaN          6       61     5\n",
       "#55 Tigger Li        5      28       NaN          6       39     3\n",
       "#1 Joyce Wang        2      18       NaN          5       25     0\n",
       "Oscar Yao            0       7       NaN          0        7     0\n",
       "#19 Ben Wang         0       3       NaN          2        5     1\n",
       "#28 Tina Zhu         0       3       NaN          0        3     0\n",
       "#66 Jerry Chen       0       3       NaN          0        3     0\n",
       "#0 Julie Luo         0       2       NaN          0        2     0\n",
       "#76 Jack Xia         0       2       NaN          0        2     0\n",
       "#69 Justin Chen      0       2       NaN          0        2     0\n",
       "Peter                0       2       NaN          0        2     0\n",
       "#52 Emily Zhang      0       1       NaN          0        1     0\n",
       "#39 David Xiao       0       1       NaN          0        1     0\n",
       "#2 Jamie Chen        0       1       NaN          0        1     0\n",
       "Melody Zheng         0       1       NaN          1        2     0\n",
       "#11 Momoka Goto      0       1       NaN          0        1     0\n",
       "#41 Billy Ni         0       1       NaN          0        1     0\n",
       "Thrower            NaN     NaN       NaN        NaN      NaN   NaN"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_receiving_data('#14 Cecilia Wu').sort_values('Catches',ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def ulti_receiving_data(receiver):\n",
    "    ulti_df = pd.read_csv('WY-Wolves/1617SUISWolves-stats.csv')\n",
    "    ulti_df = ulti_df[ulti_df['Receiver'] == receiver]\n",
    "    data = pd.DataFrame(columns=['Drops', 'Catches', 'Catch Pct', 'Throwaways', 'Attempts', 'Goals'], index=['Player'])\n",
    "    for thrower, frame in ulti_df.groupby('Passer'):\n",
    "        data.loc[thrower] = pd.Series({'Drops': len(frame[frame['Action'] == 'Drop']),\n",
    "                                       'Catches': len(frame[frame['Action'] == 'Catch']),\n",
    "                                       'Throwaways': len(frame[frame['Action'] == 'Throwaway']),\n",
    "                                       'Attempts': len(frame[frame['Action'] == 'Drop']) + len(frame[frame['Action'] == 'Catch']) + len(frame[frame['Action'] == 'Throwaway']),\n",
    "                                       'Goals': len(frame[frame['Action'] == 'Goal'])})\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Drops</th>\n",
       "      <th>Catches</th>\n",
       "      <th>Catch Pct</th>\n",
       "      <th>Throwaways</th>\n",
       "      <th>Attempts</th>\n",
       "      <th>Goals</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>#22 Paul Simpson</th>\n",
       "      <td>4.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 Joyce Wang</th>\n",
       "      <td>3.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#27 Daniel Zhang</th>\n",
       "      <td>4.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th># 69 Justin Chen</th>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#55 Tigger Li</th>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#66 Jerry Chen</th>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#2 Jamie Chen</th>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Oscar Yao</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#39 David Xiao</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chris Xu</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#19 Ben Wang</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#28 Tina Zhu</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Khloris Liu</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nathan B</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#41 Billy Ni</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bruce Gu</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#30 Jimmy Peng</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Teresa Z</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Richard</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Player</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Drops  Catches  Catch Pct  Throwaways  Attempts  Goals\n",
       "#22 Paul Simpson    4.0     61.0        NaN         0.0      65.0   10.0\n",
       "#1 Joyce Wang       3.0     17.0        NaN         0.0      20.0    0.0\n",
       "#27 Daniel Zhang    4.0     15.0        NaN         0.0      19.0    1.0\n",
       "# 69 Justin Chen    2.0     11.0        NaN         0.0      13.0    0.0\n",
       "#55 Tigger Li       1.0     10.0        NaN         0.0      11.0    0.0\n",
       "#66 Jerry Chen      0.0      8.0        NaN         0.0       8.0    0.0\n",
       "#2 Jamie Chen       0.0      5.0        NaN         0.0       5.0    0.0\n",
       "Oscar Yao           0.0      3.0        NaN         0.0       3.0    0.0\n",
       "#39 David Xiao      0.0      3.0        NaN         0.0       3.0    0.0\n",
       "Chris Xu            0.0      3.0        NaN         0.0       3.0    0.0\n",
       "#19 Ben Wang        0.0      2.0        NaN         0.0       2.0    0.0\n",
       "#28 Tina Zhu        0.0      2.0        NaN         0.0       2.0    0.0\n",
       "Khloris Liu         0.0      1.0        NaN         0.0       1.0    0.0\n",
       "Nathan B            1.0      1.0        NaN         0.0       2.0    0.0\n",
       "#41 Billy Ni        0.0      1.0        NaN         0.0       1.0    1.0\n",
       "Bruce Gu            0.0      1.0        NaN         0.0       1.0    0.0\n",
       "#30 Jimmy Peng      0.0      1.0        NaN         0.0       1.0    0.0\n",
       "Teresa Z            1.0      1.0        NaN         0.0       2.0    0.0\n",
       "Richard             1.0      0.0        NaN         0.0       1.0    0.0\n",
       "Player              NaN      NaN        NaN         NaN       NaN    NaN"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ulti_receiving_data('#14 Cecilia Wu').sort_values('Catches', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "receiver = '#22 Paul Simpson'\n",
    "sdf = player_receiving_data(receiver)\n",
    "udf = ulti_receiving_data(receiver)\n",
    "pdf = sdf.add(udf, fill_value=0)\n",
    "\n",
    "def catch_percent(row):\n",
    "        catch_pct = 0\n",
    "        if row['Drops'] + row['Catches'] != 0:\n",
    "            catch_pct = row['Catches'] / (row['Drops'] + row['Catches'])\n",
    "        row['Catch Pct'] = catch_pct\n",
    "        return row\n",
    "        \n",
    "pdf = pdf.apply(catch_percent, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Drops</th>\n",
       "      <th>Catches</th>\n",
       "      <th>Catch Pct</th>\n",
       "      <th>Throwaways</th>\n",
       "      <th>Attempts</th>\n",
       "      <th>Goals</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>#55 Tigger Li</th>\n",
       "      <td>3.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.940000</td>\n",
       "      <td>10.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#27 Daniel Zhang</th>\n",
       "      <td>5.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>0.968750</td>\n",
       "      <td>15.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#1 Joyce Wang</th>\n",
       "      <td>2.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>0.964912</td>\n",
       "      <td>5.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th># 69 Justin Chen</th>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#69 Justin Chen</th>\n",
       "      <td>2.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.866667</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Peter</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#14 Cecilia Wu</th>\n",
       "      <td>2.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>0.984127</td>\n",
       "      <td>6.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#2 Jamie Chen</th>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.928571</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th># 36 Jason Ling</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Oscar Yao</th>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Melody Zheng</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Khloris Liu</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chris Xu</th>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.928571</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#77 Zoe Wu</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#76 Jack Xia</th>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#7 Cici Qiu</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#41 Billy Ni</th>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.909091</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#66 Jerry Chen</th>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#52 Emily Zhang</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#39 David Xiao</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#30 Jimmy Peng</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#28 Tina Zhu</th>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#25 Alex Chen</th>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#19 Ben Wang</th>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#11 Momoka Goto</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>#0 Julie Luo</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theresa Zhang</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Player</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thrower</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Drops  Catches  Catch Pct  Throwaways  Attempts  Goals\n",
       "#55 Tigger Li       3.0     47.0   0.940000        10.0      60.0   11.0\n",
       "#27 Daniel Zhang    5.0    155.0   0.968750        15.0     175.0    6.0\n",
       "#1 Joyce Wang       2.0     55.0   0.964912         5.0      62.0    2.0\n",
       "# 69 Justin Chen    2.0      8.0   0.800000         0.0      10.0    2.0\n",
       "#69 Justin Chen     2.0     13.0   0.866667         3.0      18.0    1.0\n",
       "Peter               0.0      2.0   1.000000         0.0       2.0    1.0\n",
       "#14 Cecilia Wu      2.0    124.0   0.984127         6.0     132.0    1.0\n",
       "#2 Jamie Chen       1.0     13.0   0.928571         1.0      15.0    1.0\n",
       "# 36 Jason Ling     0.0      1.0   1.000000         0.0       1.0    0.0\n",
       "Oscar Yao           0.0      8.0   1.000000         0.0       8.0    0.0\n",
       "Melody Zheng        0.0      3.0   1.000000         1.0       4.0    0.0\n",
       "Khloris Liu         0.0      1.0   1.000000         0.0       1.0    0.0\n",
       "Chris Xu            1.0     13.0   0.928571         0.0      14.0    0.0\n",
       "#77 Zoe Wu          0.0      2.0   1.000000         0.0       2.0    0.0\n",
       "#76 Jack Xia        0.0      5.0   1.000000         2.0       7.0    0.0\n",
       "#7 Cici Qiu         0.0      1.0   1.000000         0.0       1.0    0.0\n",
       "#41 Billy Ni        1.0     10.0   0.909091         0.0      11.0    0.0\n",
       "#66 Jerry Chen      0.0      8.0   1.000000         1.0       9.0    0.0\n",
       "#52 Emily Zhang     0.0      2.0   1.000000         1.0       3.0    0.0\n",
       "#39 David Xiao      0.0      1.0   1.000000         0.0       1.0    0.0\n",
       "#30 Jimmy Peng      0.0      3.0   1.000000         0.0       3.0    0.0\n",
       "#28 Tina Zhu        0.0     13.0   1.000000         0.0      13.0    0.0\n",
       "#25 Alex Chen       0.0      3.0   1.000000         0.0       3.0    0.0\n",
       "#19 Ben Wang        0.0     15.0   1.000000         0.0      15.0    0.0\n",
       "#11 Momoka Goto     0.0      1.0   1.000000         1.0       2.0    0.0\n",
       "#0 Julie Luo        0.0      2.0   1.000000         0.0       2.0    0.0\n",
       "Theresa Zhang       0.0      1.0   1.000000         1.0       2.0    0.0\n",
       "Player              NaN      NaN        NaN         NaN       NaN    NaN\n",
       "Thrower             NaN      NaN        NaN         NaN       NaN    NaN"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pdf.sort_values('Goals', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}