Perform_Team_Analysis.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "u = pd.read_csv('/Users/jgdwyer/Dropbox/fun/jabo2019/baseball-H2H-AuctionValues/output/U.csv')\n",
        "sp = pd.read_csv('/Users/jgdwyer/Dropbox/fun/jabo2019/baseball-H2H-AuctionValues/output/SP.csv')\n",
        "rp = pd.read_csv('/Users/jgdwyer/Dropbox/fun/jabo2019/baseball-H2H-AuctionValues/output/RP.csv')\n",
        "\n",
        "pd.options.display.max_columns = None\n"
      ],
      "outputs": [],
      "execution_count": 3,
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "u2 = u[u['jabo_team']=='On Waivers']\n",
        "u2 = u2[u2['xusal']>0]"
      ],
      "outputs": [],
      "execution_count": 4,
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "65/(u2['xusal'].sum()/14)"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 5,
          "data": {
            "text/plain": [
              "5.2298850574712645"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 5,
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "team_hitters = u.groupby('jabo_team').agg({'salary': 'sum', 'xsal': 'sum', 'Name': 'count'})\n",
        "team_hitters['actual - predicted'] = team_hitters['salary'] - team_hitters['xsal']\n",
        "team_hitters.sort_values('salary')\n",
        "team_hitters['Name'].sum()-522"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 6,
          "data": {
            "text/plain": [
              "10"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 6,
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "team_hitters['salary'].sum()/14 + team_pitchers['salary'].sum()/14"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 12,
          "data": {
            "text/plain": [
              "330.6428571428571"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 12,
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "print(team_hitters['salary'].sum()/14)\n",
        "print(260*3/5 - team_hitters['salary'].sum()/14)\n",
        "team_hitters.iloc[1:]['actual - predicted'].sum()/14"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "189.78571428571428\n",
            "-33.78571428571428\n"
          ]
        },
        {
          "output_type": "execute_result",
          "execution_count": 13,
          "data": {
            "text/plain": [
              "116.42857142857143"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 13,
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "print(team_pitchers['salary'].sum()/14)\n",
        "print(260*2/5 -team_pitchers['salary'].sum()/14)\n",
        "\nteam_pitchers.iloc[1:]['actual - predicted'].sum()/14"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "140.85714285714286\n",
            "-36.85714285714286\n"
          ]
        },
        {
          "output_type": "execute_result",
          "execution_count": 14,
          "data": {
            "text/plain": [
              "38.714285714285715"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 14,
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "p = pd.concat((sp, rp), axis=0)\n",
        "team_pitchers = p.groupby('jabo_team').agg({'salary': 'sum', 'xsal': 'sum', 'Name': 'count'})\n",
        "team_pitchers['actual - predicted'] = team_pitchers['salary'] - team_pitchers['xsal']\n",
        "team_pitchers.sort_values('salary')"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 11,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>salary</th>\n",
              "      <th>xsal</th>\n",
              "      <th>Name</th>\n",
              "      <th>actual - predicted</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>jabo_team</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Owned By Moose Knucklers</th>\n",
              "      <td>36.0</td>\n",
              "      <td>41.0</td>\n",
              "      <td>3</td>\n",
              "      <td>-5.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By Gwynn-Gwynn Situation</th>\n",
              "      <td>62.0</td>\n",
              "      <td>98.0</td>\n",
              "      <td>8</td>\n",
              "      <td>-36.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>On Waivers</th>\n",
              "      <td>90.0</td>\n",
              "      <td>-6322.0</td>\n",
              "      <td>484</td>\n",
              "      <td>6412.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By 225 Stugots</th>\n",
              "      <td>105.0</td>\n",
              "      <td>101.0</td>\n",
              "      <td>14</td>\n",
              "      <td>4.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By It's Not a Coomer</th>\n",
              "      <td>115.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>12</td>\n",
              "      <td>21.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By The Bennett Agbayanis'</th>\n",
              "      <td>115.0</td>\n",
              "      <td>41.0</td>\n",
              "      <td>10</td>\n",
              "      <td>74.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By No Limit</th>\n",
              "      <td>116.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>14</td>\n",
              "      <td>116.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By Cotton Muffled FootSteps</th>\n",
              "      <td>138.0</td>\n",
              "      <td>138.0</td>\n",
              "      <td>16</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By Roger Dodger</th>\n",
              "      <td>143.0</td>\n",
              "      <td>108.0</td>\n",
              "      <td>15</td>\n",
              "      <td>35.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By American C.R.E.A.M. Team</th>\n",
              "      <td>149.0</td>\n",
              "      <td>110.0</td>\n",
              "      <td>10</td>\n",
              "      <td>39.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By Great Atomic Power</th>\n",
              "      <td>155.0</td>\n",
              "      <td>153.0</td>\n",
              "      <td>13</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By My, oh my!</th>\n",
              "      <td>168.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>12</td>\n",
              "      <td>62.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By Masterbatters</th>\n",
              "      <td>176.0</td>\n",
              "      <td>110.0</td>\n",
              "      <td>14</td>\n",
              "      <td>66.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By Beam Me Up</th>\n",
              "      <td>183.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>12</td>\n",
              "      <td>79.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Owned By Here Comes Joey</th>\n",
              "      <td>221.0</td>\n",
              "      <td>136.0</td>\n",
              "      <td>15</td>\n",
              "      <td>85.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                   salary    xsal  Name  actual - predicted\n",
              "jabo_team                                                                  \n",
              "Owned By Moose Knucklers             36.0    41.0     3                -5.0\n",
              "Owned By Gwynn-Gwynn Situation       62.0    98.0     8               -36.0\n",
              "On Waivers                           90.0 -6322.0   484              6412.0\n",
              "Owned By 225 Stugots                105.0   101.0    14                 4.0\n",
              "Owned By It's Not a Coomer          115.0    94.0    12                21.0\n",
              "Owned By The Bennett Agbayanis'     115.0    41.0    10                74.0\n",
              "Owned By No Limit                   116.0     0.0    14               116.0\n",
              "Owned By Cotton Muffled FootSteps   138.0   138.0    16                 0.0\n",
              "Owned By Roger Dodger               143.0   108.0    15                35.0\n",
              "Owned By American C.R.E.A.M. Team   149.0   110.0    10                39.0\n",
              "Owned By Great Atomic Power         155.0   153.0    13                 2.0\n",
              "Owned By My, oh my!                 168.0   106.0    12                62.0\n",
              "Owned By Masterbatters              176.0   110.0    14                66.0\n",
              "Owned By Beam Me Up                 183.0   104.0    12                79.0\n",
              "Owned By Here Comes Joey            221.0   136.0    15                85.0"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 11,
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "u[u['jabo_team']=='Owned By Great Atomic Power'].sort_values('xsal', ascending=False)"
      ],
      "outputs": [
        {
          "output_type": "execute_result",
          "execution_count": 19,
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>xusal</th>\n",
              "      <th>xsal</th>\n",
              "      <th>salary</th>\n",
              "      <th>dsal</th>\n",
              "      <th>mlb_team</th>\n",
              "      <th>jabo_team</th>\n",
              "      <th>position</th>\n",
              "      <th>PA</th>\n",
              "      <th>AVG</th>\n",
              "      <th>OBP</th>\n",
              "      <th>SLG</th>\n",
              "      <th>HR</th>\n",
              "      <th>SB</th>\n",
              "      <th>sAVG</th>\n",
              "      <th>sOBP</th>\n",
              "      <th>sSLG</th>\n",
              "      <th>sR</th>\n",
              "      <th>sRBI</th>\n",
              "      <th>sTB</th>\n",
              "      <th>sHR</th>\n",
              "      <th>sSB</th>\n",
              "      <th>R</th>\n",
              "      <th>RBI</th>\n",
              "      <th>wOBA</th>\n",
              "      <th>WAR</th>\n",
              "      <th>playerid</th>\n",
              "      <th>SGP</th>\n",
              "      <th>p_SGP</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Kris Bryant</td>\n",
              "      <td>30.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>CHC</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>3B,LF,RF,U</td>\n",
              "      <td>651</td>\n",
              "      <td>0.275</td>\n",
              "      <td>0.382</td>\n",
              "      <td>0.504</td>\n",
              "      <td>29</td>\n",
              "      <td>7</td>\n",
              "      <td>1.1</td>\n",
              "      <td>2.4</td>\n",
              "      <td>1.9</td>\n",
              "      <td>1.8</td>\n",
              "      <td>1.3</td>\n",
              "      <td>1.3</td>\n",
              "      <td>1.6</td>\n",
              "      <td>0.3</td>\n",
              "      <td>96</td>\n",
              "      <td>90</td>\n",
              "      <td>0.378</td>\n",
              "      <td>5.7</td>\n",
              "      <td>15429</td>\n",
              "      <td>11.8</td>\n",
              "      <td>11.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Alex Bregman</td>\n",
              "      <td>30.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>-15.0</td>\n",
              "      <td>HOU</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>3B,SS,U</td>\n",
              "      <td>651</td>\n",
              "      <td>0.280</td>\n",
              "      <td>0.371</td>\n",
              "      <td>0.495</td>\n",
              "      <td>26</td>\n",
              "      <td>11</td>\n",
              "      <td>1.3</td>\n",
              "      <td>1.9</td>\n",
              "      <td>1.7</td>\n",
              "      <td>1.9</td>\n",
              "      <td>1.4</td>\n",
              "      <td>1.3</td>\n",
              "      <td>1.1</td>\n",
              "      <td>1.1</td>\n",
              "      <td>97</td>\n",
              "      <td>91</td>\n",
              "      <td>0.371</td>\n",
              "      <td>5.4</td>\n",
              "      <td>17678</td>\n",
              "      <td>11.7</td>\n",
              "      <td>11.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Juan Soto</td>\n",
              "      <td>34.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>-16.0</td>\n",
              "      <td>WAS</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>LF,U</td>\n",
              "      <td>637</td>\n",
              "      <td>0.292</td>\n",
              "      <td>0.393</td>\n",
              "      <td>0.517</td>\n",
              "      <td>29</td>\n",
              "      <td>7</td>\n",
              "      <td>1.8</td>\n",
              "      <td>2.9</td>\n",
              "      <td>2.3</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1.3</td>\n",
              "      <td>1.6</td>\n",
              "      <td>0.3</td>\n",
              "      <td>92</td>\n",
              "      <td>94</td>\n",
              "      <td>0.386</td>\n",
              "      <td>4.5</td>\n",
              "      <td>20123</td>\n",
              "      <td>13.5</td>\n",
              "      <td>11.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Ronald Acuna Jr.</td>\n",
              "      <td>32.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>-20.0</td>\n",
              "      <td>ATL</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>CF,LF,U</td>\n",
              "      <td>651</td>\n",
              "      <td>0.279</td>\n",
              "      <td>0.347</td>\n",
              "      <td>0.491</td>\n",
              "      <td>28</td>\n",
              "      <td>24</td>\n",
              "      <td>1.3</td>\n",
              "      <td>0.8</td>\n",
              "      <td>1.5</td>\n",
              "      <td>1.8</td>\n",
              "      <td>0.7</td>\n",
              "      <td>1.5</td>\n",
              "      <td>1.4</td>\n",
              "      <td>3.6</td>\n",
              "      <td>95</td>\n",
              "      <td>80</td>\n",
              "      <td>0.358</td>\n",
              "      <td>3.2</td>\n",
              "      <td>18401</td>\n",
              "      <td>12.5</td>\n",
              "      <td>11.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Daniel Murphy</td>\n",
              "      <td>25.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>COL</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>1B,2B,U</td>\n",
              "      <td>616</td>\n",
              "      <td>0.307</td>\n",
              "      <td>0.360</td>\n",
              "      <td>0.506</td>\n",
              "      <td>23</td>\n",
              "      <td>3</td>\n",
              "      <td>2.5</td>\n",
              "      <td>1.5</td>\n",
              "      <td>2.1</td>\n",
              "      <td>1.1</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.5</td>\n",
              "      <td>0.5</td>\n",
              "      <td>-0.4</td>\n",
              "      <td>85</td>\n",
              "      <td>87</td>\n",
              "      <td>0.367</td>\n",
              "      <td>1.9</td>\n",
              "      <td>4316</td>\n",
              "      <td>9.9</td>\n",
              "      <td>8.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>Rhys Hoskins</td>\n",
              "      <td>25.0</td>\n",
              "      <td>21.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>-11.0</td>\n",
              "      <td>PHI</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>1B,LF,U</td>\n",
              "      <td>651</td>\n",
              "      <td>0.249</td>\n",
              "      <td>0.352</td>\n",
              "      <td>0.500</td>\n",
              "      <td>36</td>\n",
              "      <td>5</td>\n",
              "      <td>-0.1</td>\n",
              "      <td>1.1</td>\n",
              "      <td>1.7</td>\n",
              "      <td>1.4</td>\n",
              "      <td>1.9</td>\n",
              "      <td>1.3</td>\n",
              "      <td>2.9</td>\n",
              "      <td>-0.0</td>\n",
              "      <td>89</td>\n",
              "      <td>98</td>\n",
              "      <td>0.364</td>\n",
              "      <td>3.6</td>\n",
              "      <td>16472</td>\n",
              "      <td>10.0</td>\n",
              "      <td>7.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>Justin Turner</td>\n",
              "      <td>21.0</td>\n",
              "      <td>21.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>LAD</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>3B,U</td>\n",
              "      <td>644</td>\n",
              "      <td>0.286</td>\n",
              "      <td>0.371</td>\n",
              "      <td>0.476</td>\n",
              "      <td>23</td>\n",
              "      <td>4</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1.9</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.1</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.1</td>\n",
              "      <td>0.5</td>\n",
              "      <td>-0.2</td>\n",
              "      <td>85</td>\n",
              "      <td>87</td>\n",
              "      <td>0.364</td>\n",
              "      <td>4.9</td>\n",
              "      <td>5235</td>\n",
              "      <td>8.1</td>\n",
              "      <td>7.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>83</th>\n",
              "      <td>Aaron Hicks</td>\n",
              "      <td>9.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>NYY</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>CF,U</td>\n",
              "      <td>630</td>\n",
              "      <td>0.248</td>\n",
              "      <td>0.348</td>\n",
              "      <td>0.430</td>\n",
              "      <td>23</td>\n",
              "      <td>11</td>\n",
              "      <td>-0.1</td>\n",
              "      <td>0.9</td>\n",
              "      <td>-0.5</td>\n",
              "      <td>1.1</td>\n",
              "      <td>0.3</td>\n",
              "      <td>0.3</td>\n",
              "      <td>0.5</td>\n",
              "      <td>1.1</td>\n",
              "      <td>85</td>\n",
              "      <td>74</td>\n",
              "      <td>0.340</td>\n",
              "      <td>3.5</td>\n",
              "      <td>5297</td>\n",
              "      <td>3.7</td>\n",
              "      <td>2.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>115</th>\n",
              "      <td>Jurickson Profar</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>OAK</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>1B,2B,3B,SS,U</td>\n",
              "      <td>616</td>\n",
              "      <td>0.259</td>\n",
              "      <td>0.335</td>\n",
              "      <td>0.420</td>\n",
              "      <td>16</td>\n",
              "      <td>8</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.3</td>\n",
              "      <td>-0.8</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.3</td>\n",
              "      <td>-0.8</td>\n",
              "      <td>0.5</td>\n",
              "      <td>74</td>\n",
              "      <td>70</td>\n",
              "      <td>0.328</td>\n",
              "      <td>2.9</td>\n",
              "      <td>10815</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>211</th>\n",
              "      <td>Jed Lowrie</td>\n",
              "      <td>-10.0</td>\n",
              "      <td>-12.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>NYM</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>2B,3B,U</td>\n",
              "      <td>598</td>\n",
              "      <td>0.243</td>\n",
              "      <td>0.327</td>\n",
              "      <td>0.393</td>\n",
              "      <td>16</td>\n",
              "      <td>1</td>\n",
              "      <td>-0.3</td>\n",
              "      <td>0.1</td>\n",
              "      <td>-1.5</td>\n",
              "      <td>0.2</td>\n",
              "      <td>-0.7</td>\n",
              "      <td>-0.2</td>\n",
              "      <td>-0.8</td>\n",
              "      <td>-0.8</td>\n",
              "      <td>71</td>\n",
              "      <td>58</td>\n",
              "      <td>0.315</td>\n",
              "      <td>2.1</td>\n",
              "      <td>4418</td>\n",
              "      <td>-4.0</td>\n",
              "      <td>-4.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>279</th>\n",
              "      <td>Evan Gattis</td>\n",
              "      <td>-12.0</td>\n",
              "      <td>-19.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>HOU</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>U</td>\n",
              "      <td>350</td>\n",
              "      <td>0.246</td>\n",
              "      <td>0.305</td>\n",
              "      <td>0.463</td>\n",
              "      <td>18</td>\n",
              "      <td>1</td>\n",
              "      <td>0.2</td>\n",
              "      <td>-0.2</td>\n",
              "      <td>0.7</td>\n",
              "      <td>-1.8</td>\n",
              "      <td>-1.1</td>\n",
              "      <td>-1.4</td>\n",
              "      <td>-0.4</td>\n",
              "      <td>-0.8</td>\n",
              "      <td>41</td>\n",
              "      <td>51</td>\n",
              "      <td>0.327</td>\n",
              "      <td>0.4</td>\n",
              "      <td>11003</td>\n",
              "      <td>-4.8</td>\n",
              "      <td>-7.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>466</th>\n",
              "      <td>Clint Frazier</td>\n",
              "      <td>-34.0</td>\n",
              "      <td>-42.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>46.0</td>\n",
              "      <td>NYY</td>\n",
              "      <td>Owned By Great Atomic Power</td>\n",
              "      <td>LF,U</td>\n",
              "      <td>84</td>\n",
              "      <td>0.244</td>\n",
              "      <td>0.316</td>\n",
              "      <td>0.431</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.7</td>\n",
              "      <td>0.7</td>\n",
              "      <td>-3.8</td>\n",
              "      <td>-3.7</td>\n",
              "      <td>-3.7</td>\n",
              "      <td>-3.2</td>\n",
              "      <td>-0.8</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>0.322</td>\n",
              "      <td>0.2</td>\n",
              "      <td>15983</td>\n",
              "      <td>-13.3</td>\n",
              "      <td>-15.5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                 Name  xusal  xsal  salary  dsal mlb_team  \\\n",
              "11        Kris Bryant   30.0  31.0    40.0   9.0      CHC   \n",
              "14       Alex Bregman   30.0  31.0    16.0 -15.0      HOU   \n",
              "15          Juan Soto   34.0  31.0    15.0 -16.0      WAS   \n",
              "16   Ronald Acuna Jr.   32.0  30.0    10.0 -20.0      ATL   \n",
              "26      Daniel Murphy   25.0  24.0    27.0   3.0      COL   \n",
              "31       Rhys Hoskins   25.0  21.0    10.0 -11.0      PHI   \n",
              "32      Justin Turner   21.0  21.0    28.0   7.0      LAD   \n",
              "83        Aaron Hicks    9.0   6.0    13.0   7.0      NYY   \n",
              "115  Jurickson Profar    1.0   0.0     4.0   4.0      OAK   \n",
              "211        Jed Lowrie  -10.0 -12.0     8.0  20.0      NYM   \n",
              "279       Evan Gattis  -12.0 -19.0    10.0  29.0      HOU   \n",
              "466     Clint Frazier  -34.0 -42.0     4.0  46.0      NYY   \n",
              "\n",
              "                       jabo_team       position   PA    AVG    OBP    SLG  HR  \\\n",
              "11   Owned By Great Atomic Power     3B,LF,RF,U  651  0.275  0.382  0.504  29   \n",
              "14   Owned By Great Atomic Power        3B,SS,U  651  0.280  0.371  0.495  26   \n",
              "15   Owned By Great Atomic Power           LF,U  637  0.292  0.393  0.517  29   \n",
              "16   Owned By Great Atomic Power        CF,LF,U  651  0.279  0.347  0.491  28   \n",
              "26   Owned By Great Atomic Power        1B,2B,U  616  0.307  0.360  0.506  23   \n",
              "31   Owned By Great Atomic Power        1B,LF,U  651  0.249  0.352  0.500  36   \n",
              "32   Owned By Great Atomic Power           3B,U  644  0.286  0.371  0.476  23   \n",
              "83   Owned By Great Atomic Power           CF,U  630  0.248  0.348  0.430  23   \n",
              "115  Owned By Great Atomic Power  1B,2B,3B,SS,U  616  0.259  0.335  0.420  16   \n",
              "211  Owned By Great Atomic Power        2B,3B,U  598  0.243  0.327  0.393  16   \n",
              "279  Owned By Great Atomic Power              U  350  0.246  0.305  0.463  18   \n",
              "466  Owned By Great Atomic Power           LF,U   84  0.244  0.316  0.431   3   \n",
              "\n",
              "     SB  sAVG  sOBP  sSLG   sR  sRBI  sTB  sHR  sSB   R  RBI   wOBA  WAR  \\\n",
              "11    7   1.1   2.4   1.9  1.8   1.3  1.3  1.6  0.3  96   90  0.378  5.7   \n",
              "14   11   1.3   1.9   1.7  1.9   1.4  1.3  1.1  1.1  97   91  0.371  5.4   \n",
              "15    7   1.8   2.9   2.3  1.6   1.6  1.3  1.6  0.3  92   94  0.386  4.5   \n",
              "16   24   1.3   0.8   1.5  1.8   0.7  1.5  1.4  3.6  95   80  0.358  3.2   \n",
              "26    3   2.5   1.5   2.1  1.1   1.2  1.5  0.5 -0.4  85   87  0.367  1.9   \n",
              "31    5  -0.1   1.1   1.7  1.4   1.9  1.3  2.9 -0.0  89   98  0.364  3.6   \n",
              "32    4   1.6   1.9   1.0  1.1   1.2  1.1  0.5 -0.2  85   87  0.364  4.9   \n",
              "83   11  -0.1   0.9  -0.5  1.1   0.3  0.3  0.5  1.1  85   74  0.340  3.5   \n",
              "115   8   0.4   0.3  -0.8  0.4   0.1  0.3 -0.8  0.5  74   70  0.328  2.9   \n",
              "211   1  -0.3   0.1  -1.5  0.2  -0.7 -0.2 -0.8 -0.8  71   58  0.315  2.1   \n",
              "279   1   0.2  -0.2   0.7 -1.8  -1.1 -1.4 -0.4 -0.8  41   51  0.327  0.4   \n",
              "466   1   0.6   0.7   0.7 -3.8  -3.7 -3.7 -3.2 -0.8  10   10  0.322  0.2   \n",
              "\n",
              "    playerid   SGP  p_SGP  \n",
              "11     15429  11.8   11.4  \n",
              "14     17678  11.7   11.3  \n",
              "15     20123  13.5   11.3  \n",
              "16     18401  12.5   11.2  \n",
              "26      4316   9.9    8.7  \n",
              "31     16472  10.0    7.9  \n",
              "32      5235   8.1    7.8  \n",
              "83      5297   3.7    2.3  \n",
              "115    10815   0.4    0.1  \n",
              "211     4418  -4.0   -4.3  \n",
              "279    11003  -4.8   -7.0  \n",
              "466    15983 -13.3  -15.5  "
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 19,
      "metadata": {}
    }
  ],
  "metadata": {
    "kernelspec": {
      "name": "python3",
      "language": "python",
      "display_name": "Python 3"
    },
    "language_info": {
      "mimetype": "text/x-python",
      "nbconvert_exporter": "python",
      "name": "python",
      "pygments_lexer": "ipython2",
      "version": "2.7.14",
      "file_extension": ".py",
      "codemirror_mode": {
        "version": 2,
        "name": "ipython"
      }
    },
    "kernel_info": {
      "name": "python3"
    },
    "nteract": {
      "version": "0.12.3"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 2
}