epa.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# EPA for XFL 3.0\n",
    "## Author:\n",
    "Joseph Armstrong armstrongjoseph08@gmail.com"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['td_prob', 'opp_td_prob', 'fg_prob', 'opp_fg_prob', 'safety_prob',\n",
      "       'opp_safety_prob', 'no_score_prob', 'ep', 'season', 'game_id',\n",
      "       ...\n",
      "       'field_goal_made', 'touchdown', 'FootballMiscScore_MiscScoreType',\n",
      "       'FootballMiscScore_TeamId', 'FootballMiscScore_PlayerId',\n",
      "       'MapRoleSacker2', 'FootballKickYards', 'MapRoleBlockedby', 'ep_f',\n",
      "       'epa'],\n",
      "      dtype='object', length=116)\n"
     ]
    },
    {
     "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>td_prob</th>\n",
       "      <th>opp_td_prob</th>\n",
       "      <th>fg_prob</th>\n",
       "      <th>opp_fg_prob</th>\n",
       "      <th>safety_prob</th>\n",
       "      <th>opp_safety_prob</th>\n",
       "      <th>no_score_prob</th>\n",
       "      <th>ep</th>\n",
       "      <th>season</th>\n",
       "      <th>game_id</th>\n",
       "      <th>...</th>\n",
       "      <th>field_goal_made</th>\n",
       "      <th>touchdown</th>\n",
       "      <th>FootballMiscScore_MiscScoreType</th>\n",
       "      <th>FootballMiscScore_TeamId</th>\n",
       "      <th>FootballMiscScore_PlayerId</th>\n",
       "      <th>MapRoleSacker2</th>\n",
       "      <th>FootballKickYards</th>\n",
       "      <th>MapRoleBlockedby</th>\n",
       "      <th>ep_f</th>\n",
       "      <th>epa</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.492549</td>\n",
       "      <td>0.106991</td>\n",
       "      <td>0.336864</td>\n",
       "      <td>0.056475</td>\n",
       "      <td>0.003063</td>\n",
       "      <td>0.000892</td>\n",
       "      <td>0.003166</td>\n",
       "      <td>3.544413</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_18_ORL@HOU</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>3.544413</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.492549</td>\n",
       "      <td>0.106991</td>\n",
       "      <td>0.336864</td>\n",
       "      <td>0.056475</td>\n",
       "      <td>0.003063</td>\n",
       "      <td>0.000892</td>\n",
       "      <td>0.003166</td>\n",
       "      <td>3.544413</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_18_ORL@HOU</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>0.501925</td>\n",
       "      <td>-3.042488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.341274</td>\n",
       "      <td>0.292912</td>\n",
       "      <td>0.204486</td>\n",
       "      <td>0.150795</td>\n",
       "      <td>0.003432</td>\n",
       "      <td>0.002271</td>\n",
       "      <td>0.004831</td>\n",
       "      <td>0.501925</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_18_ORL@HOU</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>0.316884</td>\n",
       "      <td>-0.185041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.326845</td>\n",
       "      <td>0.302498</td>\n",
       "      <td>0.204167</td>\n",
       "      <td>0.155986</td>\n",
       "      <td>0.003322</td>\n",
       "      <td>0.002367</td>\n",
       "      <td>0.004816</td>\n",
       "      <td>0.316884</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_18_ORL@HOU</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>1.016378</td>\n",
       "      <td>0.699495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.373440</td>\n",
       "      <td>0.256007</td>\n",
       "      <td>0.211740</td>\n",
       "      <td>0.147257</td>\n",
       "      <td>0.003371</td>\n",
       "      <td>0.002922</td>\n",
       "      <td>0.005263</td>\n",
       "      <td>1.016378</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_18_ORL@HOU</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>1.819799</td>\n",
       "      <td>0.803421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3882</th>\n",
       "      <td>0.014834</td>\n",
       "      <td>0.011522</td>\n",
       "      <td>0.059171</td>\n",
       "      <td>0.012132</td>\n",
       "      <td>0.000222</td>\n",
       "      <td>0.000585</td>\n",
       "      <td>0.901534</td>\n",
       "      <td>0.163577</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_STL@DC</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>-0.035412</td>\n",
       "      <td>-0.198988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3883</th>\n",
       "      <td>0.005797</td>\n",
       "      <td>0.010061</td>\n",
       "      <td>0.011133</td>\n",
       "      <td>0.011901</td>\n",
       "      <td>0.000229</td>\n",
       "      <td>0.001858</td>\n",
       "      <td>0.959022</td>\n",
       "      <td>-0.035412</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_STL@DC</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>2.789534</td>\n",
       "      <td>2.824946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3884</th>\n",
       "      <td>0.121513</td>\n",
       "      <td>0.005493</td>\n",
       "      <td>0.661540</td>\n",
       "      <td>0.002452</td>\n",
       "      <td>0.000358</td>\n",
       "      <td>0.000291</td>\n",
       "      <td>0.208353</td>\n",
       "      <td>2.789534</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_STL@DC</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>2.621115</td>\n",
       "      <td>-0.168420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3885</th>\n",
       "      <td>0.063502</td>\n",
       "      <td>0.004973</td>\n",
       "      <td>0.739108</td>\n",
       "      <td>0.002025</td>\n",
       "      <td>0.000378</td>\n",
       "      <td>0.000298</td>\n",
       "      <td>0.189716</td>\n",
       "      <td>2.621115</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_STL@DC</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>2.621115</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3886</th>\n",
       "      <td>0.063502</td>\n",
       "      <td>0.004973</td>\n",
       "      <td>0.739108</td>\n",
       "      <td>0.002025</td>\n",
       "      <td>0.000378</td>\n",
       "      <td>0.000298</td>\n",
       "      <td>0.189716</td>\n",
       "      <td>2.621115</td>\n",
       "      <td>2023</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_STL@DC</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3887 rows × 116 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       td_prob  opp_td_prob   fg_prob  opp_fg_prob  safety_prob  \\\n",
       "0     0.492549     0.106991  0.336864     0.056475     0.003063   \n",
       "1     0.492549     0.106991  0.336864     0.056475     0.003063   \n",
       "2     0.341274     0.292912  0.204486     0.150795     0.003432   \n",
       "3     0.326845     0.302498  0.204167     0.155986     0.003322   \n",
       "4     0.373440     0.256007  0.211740     0.147257     0.003371   \n",
       "...        ...          ...       ...          ...          ...   \n",
       "3882  0.014834     0.011522  0.059171     0.012132     0.000222   \n",
       "3883  0.005797     0.010061  0.011133     0.011901     0.000229   \n",
       "3884  0.121513     0.005493  0.661540     0.002452     0.000358   \n",
       "3885  0.063502     0.004973  0.739108     0.002025     0.000378   \n",
       "3886  0.063502     0.004973  0.739108     0.002025     0.000378   \n",
       "\n",
       "      opp_safety_prob  no_score_prob        ep  season  \\\n",
       "0            0.000892       0.003166  3.544413    2023   \n",
       "1            0.000892       0.003166  3.544413    2023   \n",
       "2            0.002271       0.004831  0.501925    2023   \n",
       "3            0.002367       0.004816  0.316884    2023   \n",
       "4            0.002922       0.005263  1.016378    2023   \n",
       "...               ...            ...       ...     ...   \n",
       "3882         0.000585       0.901534  0.163577    2023   \n",
       "3883         0.001858       0.959022 -0.035412    2023   \n",
       "3884         0.000291       0.208353  2.789534    2023   \n",
       "3885         0.000298       0.189716  2.621115    2023   \n",
       "3886         0.000298       0.189716  2.621115    2023   \n",
       "\n",
       "                             game_id  ... field_goal_made  touchdown  \\\n",
       "0     FOOTBALL_XFL_2023_2_18_ORL@HOU  ...               0          0   \n",
       "1     FOOTBALL_XFL_2023_2_18_ORL@HOU  ...               0          0   \n",
       "2     FOOTBALL_XFL_2023_2_18_ORL@HOU  ...               0          0   \n",
       "3     FOOTBALL_XFL_2023_2_18_ORL@HOU  ...               0          0   \n",
       "4     FOOTBALL_XFL_2023_2_18_ORL@HOU  ...               0          0   \n",
       "...                              ...  ...             ...        ...   \n",
       "3882    FOOTBALL_XFL_2023_3_5_STL@DC  ...               0          0   \n",
       "3883    FOOTBALL_XFL_2023_3_5_STL@DC  ...               0          0   \n",
       "3884    FOOTBALL_XFL_2023_3_5_STL@DC  ...               0          0   \n",
       "3885    FOOTBALL_XFL_2023_3_5_STL@DC  ...               0          0   \n",
       "3886    FOOTBALL_XFL_2023_3_5_STL@DC  ...               0          0   \n",
       "\n",
       "     FootballMiscScore_MiscScoreType  FootballMiscScore_TeamId  \\\n",
       "0                                NaN                       NaN   \n",
       "1                                NaN                       NaN   \n",
       "2                                NaN                       NaN   \n",
       "3                                NaN                       NaN   \n",
       "4                                NaN                       NaN   \n",
       "...                              ...                       ...   \n",
       "3882                             NaN                       NaN   \n",
       "3883                             NaN                       NaN   \n",
       "3884                             NaN                       NaN   \n",
       "3885                             NaN                       NaN   \n",
       "3886                             NaN                       NaN   \n",
       "\n",
       "     FootballMiscScore_PlayerId  MapRoleSacker2  FootballKickYards  \\\n",
       "0                           NaN             NaN                NaN   \n",
       "1                           NaN             NaN                NaN   \n",
       "2                           NaN             NaN                NaN   \n",
       "3                           NaN             NaN                NaN   \n",
       "4                           NaN             NaN                NaN   \n",
       "...                         ...             ...                ...   \n",
       "3882                        NaN             NaN                NaN   \n",
       "3883                        NaN             NaN                NaN   \n",
       "3884                        NaN             NaN                NaN   \n",
       "3885                        NaN             NaN                NaN   \n",
       "3886                        NaN             NaN                NaN   \n",
       "\n",
       "      MapRoleBlockedby      ep_f       epa  \n",
       "0                  NaN  3.544413  0.000000  \n",
       "1                  NaN  0.501925 -3.042488  \n",
       "2                  NaN  0.316884 -0.185041  \n",
       "3                  NaN  1.016378  0.699495  \n",
       "4                  NaN  1.819799  0.803421  \n",
       "...                ...       ...       ...  \n",
       "3882               NaN -0.035412 -0.198988  \n",
       "3883               NaN  2.789534  2.824946  \n",
       "3884               NaN  2.621115 -0.168420  \n",
       "3885               NaN  2.621115  0.000000  \n",
       "3886               NaN       NaN       NaN  \n",
       "\n",
       "[3887 rows x 116 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pbp_df = pd.read_csv('pbp/season/csv/2023_xfl_pbp_EP.csv')\n",
    "print(pbp_df.columns)\n",
    "pbp_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "pbp_df.loc[pbp_df['play_type']=='EventFootballPass','epa_pass'] = pbp_df['epa']\n",
    "pbp_df.loc[pbp_df['play_type']=='EventFootballRush','epa_rush'] = pbp_df['epa']\n",
    "#pbp_df[,'epa_rush'] = "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>posteam_abv</th>\n",
       "      <th>game_id</th>\n",
       "      <th colspan=\"2\" halign=\"left\">epa</th>\n",
       "      <th colspan=\"2\" halign=\"left\">epa_pass</th>\n",
       "      <th colspan=\"2\" halign=\"left\">epa_rush</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>mean</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ARL</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_18_VGS@ARL</td>\n",
       "      <td>-0.153075</td>\n",
       "      <td>84</td>\n",
       "      <td>0.188988</td>\n",
       "      <td>25</td>\n",
       "      <td>-0.214525</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ARL</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_26_ARL@HOU</td>\n",
       "      <td>0.091745</td>\n",
       "      <td>76</td>\n",
       "      <td>0.095962</td>\n",
       "      <td>30</td>\n",
       "      <td>-0.348942</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ARL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_12_ARL@STL</td>\n",
       "      <td>0.000697</td>\n",
       "      <td>73</td>\n",
       "      <td>0.151119</td>\n",
       "      <td>39</td>\n",
       "      <td>0.145666</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ARL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_19_ARL@SA</td>\n",
       "      <td>0.014537</td>\n",
       "      <td>84</td>\n",
       "      <td>0.374734</td>\n",
       "      <td>26</td>\n",
       "      <td>-0.185009</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ARL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_26_SA@ARL</td>\n",
       "      <td>-0.063330</td>\n",
       "      <td>81</td>\n",
       "      <td>-0.005252</td>\n",
       "      <td>29</td>\n",
       "      <td>-0.155953</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ARL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_ORL@ARL</td>\n",
       "      <td>-0.175500</td>\n",
       "      <td>70</td>\n",
       "      <td>0.036580</td>\n",
       "      <td>23</td>\n",
       "      <td>-0.424715</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>DC</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_19_SEA@DC</td>\n",
       "      <td>-0.198273</td>\n",
       "      <td>79</td>\n",
       "      <td>-0.143659</td>\n",
       "      <td>21</td>\n",
       "      <td>-0.130373</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DC</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_25_DC@VGS</td>\n",
       "      <td>0.103626</td>\n",
       "      <td>83</td>\n",
       "      <td>-0.046817</td>\n",
       "      <td>25</td>\n",
       "      <td>0.104703</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DC</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_12_VGS@DC</td>\n",
       "      <td>0.040518</td>\n",
       "      <td>88</td>\n",
       "      <td>0.621004</td>\n",
       "      <td>21</td>\n",
       "      <td>-0.070663</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>DC</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_18_DC@STL</td>\n",
       "      <td>-0.103258</td>\n",
       "      <td>77</td>\n",
       "      <td>-0.006225</td>\n",
       "      <td>19</td>\n",
       "      <td>0.020104</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>DC</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_27_HOU@DC</td>\n",
       "      <td>-0.016623</td>\n",
       "      <td>89</td>\n",
       "      <td>0.216430</td>\n",
       "      <td>32</td>\n",
       "      <td>-0.097385</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>DC</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_STL@DC</td>\n",
       "      <td>0.142473</td>\n",
       "      <td>83</td>\n",
       "      <td>0.467355</td>\n",
       "      <td>23</td>\n",
       "      <td>0.251272</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>HOU</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_18_ORL@HOU</td>\n",
       "      <td>-0.018755</td>\n",
       "      <td>85</td>\n",
       "      <td>0.179711</td>\n",
       "      <td>42</td>\n",
       "      <td>-0.124999</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>HOU</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_26_ARL@HOU</td>\n",
       "      <td>-0.109476</td>\n",
       "      <td>79</td>\n",
       "      <td>-0.123988</td>\n",
       "      <td>29</td>\n",
       "      <td>0.010122</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>HOU</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_11_HOU@ORL</td>\n",
       "      <td>0.091270</td>\n",
       "      <td>74</td>\n",
       "      <td>0.293959</td>\n",
       "      <td>33</td>\n",
       "      <td>0.538282</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>HOU</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_16_HOU@SEA</td>\n",
       "      <td>-0.001939</td>\n",
       "      <td>89</td>\n",
       "      <td>-0.031869</td>\n",
       "      <td>47</td>\n",
       "      <td>-0.090288</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>HOU</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_27_HOU@DC</td>\n",
       "      <td>-0.002296</td>\n",
       "      <td>75</td>\n",
       "      <td>0.733751</td>\n",
       "      <td>28</td>\n",
       "      <td>-0.080291</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>HOU</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_SA@HOU</td>\n",
       "      <td>0.022892</td>\n",
       "      <td>90</td>\n",
       "      <td>0.358716</td>\n",
       "      <td>36</td>\n",
       "      <td>0.016445</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ORL</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_18_ORL@HOU</td>\n",
       "      <td>-0.009983</td>\n",
       "      <td>84</td>\n",
       "      <td>0.376711</td>\n",
       "      <td>39</td>\n",
       "      <td>0.188442</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ORL</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_26_SA@ORL</td>\n",
       "      <td>-0.058945</td>\n",
       "      <td>86</td>\n",
       "      <td>-0.111051</td>\n",
       "      <td>32</td>\n",
       "      <td>-0.046282</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>ORL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_11_HOU@ORL</td>\n",
       "      <td>-0.120370</td>\n",
       "      <td>85</td>\n",
       "      <td>0.295070</td>\n",
       "      <td>34</td>\n",
       "      <td>0.141587</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>ORL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_18_ORL@VGS</td>\n",
       "      <td>0.033532</td>\n",
       "      <td>92</td>\n",
       "      <td>0.438818</td>\n",
       "      <td>34</td>\n",
       "      <td>0.174036</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ORL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_25_SEA@ORL</td>\n",
       "      <td>-0.041116</td>\n",
       "      <td>96</td>\n",
       "      <td>-0.059181</td>\n",
       "      <td>44</td>\n",
       "      <td>0.417658</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ORL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_ORL@ARL</td>\n",
       "      <td>0.143842</td>\n",
       "      <td>76</td>\n",
       "      <td>0.624933</td>\n",
       "      <td>31</td>\n",
       "      <td>-0.097852</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>SA</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_19_STL@SA</td>\n",
       "      <td>0.004783</td>\n",
       "      <td>96</td>\n",
       "      <td>0.148532</td>\n",
       "      <td>36</td>\n",
       "      <td>-0.037244</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>SA</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_26_SA@ORL</td>\n",
       "      <td>0.044653</td>\n",
       "      <td>74</td>\n",
       "      <td>0.400708</td>\n",
       "      <td>24</td>\n",
       "      <td>-0.160469</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>SA</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_11_SA@SEA</td>\n",
       "      <td>-0.005807</td>\n",
       "      <td>77</td>\n",
       "      <td>0.152469</td>\n",
       "      <td>39</td>\n",
       "      <td>-0.527409</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>SA</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_19_ARL@SA</td>\n",
       "      <td>-0.064799</td>\n",
       "      <td>71</td>\n",
       "      <td>-0.005546</td>\n",
       "      <td>34</td>\n",
       "      <td>0.019952</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>SA</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_26_SA@ARL</td>\n",
       "      <td>0.038347</td>\n",
       "      <td>75</td>\n",
       "      <td>-0.188643</td>\n",
       "      <td>20</td>\n",
       "      <td>0.009114</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>SA</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_SA@HOU</td>\n",
       "      <td>-0.081666</td>\n",
       "      <td>72</td>\n",
       "      <td>-0.188775</td>\n",
       "      <td>20</td>\n",
       "      <td>-0.201757</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>SEA</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_19_SEA@DC</td>\n",
       "      <td>0.132956</td>\n",
       "      <td>89</td>\n",
       "      <td>0.505908</td>\n",
       "      <td>56</td>\n",
       "      <td>-0.429221</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>SEA</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_23_STL@SEA</td>\n",
       "      <td>-0.049026</td>\n",
       "      <td>62</td>\n",
       "      <td>0.050403</td>\n",
       "      <td>29</td>\n",
       "      <td>0.154771</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>SEA</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_11_SA@SEA</td>\n",
       "      <td>-0.038553</td>\n",
       "      <td>79</td>\n",
       "      <td>0.158605</td>\n",
       "      <td>41</td>\n",
       "      <td>-0.134310</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>SEA</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_16_HOU@SEA</td>\n",
       "      <td>-0.050619</td>\n",
       "      <td>71</td>\n",
       "      <td>0.071864</td>\n",
       "      <td>32</td>\n",
       "      <td>0.039489</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>SEA</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_25_SEA@ORL</td>\n",
       "      <td>0.002657</td>\n",
       "      <td>82</td>\n",
       "      <td>-0.070022</td>\n",
       "      <td>35</td>\n",
       "      <td>-0.147605</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>SEA</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_4_SEA@VGS</td>\n",
       "      <td>0.096195</td>\n",
       "      <td>84</td>\n",
       "      <td>0.443056</td>\n",
       "      <td>37</td>\n",
       "      <td>0.424393</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>STL</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_19_STL@SA</td>\n",
       "      <td>-0.060018</td>\n",
       "      <td>71</td>\n",
       "      <td>0.364377</td>\n",
       "      <td>26</td>\n",
       "      <td>0.158652</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>STL</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_23_STL@SEA</td>\n",
       "      <td>0.010092</td>\n",
       "      <td>90</td>\n",
       "      <td>0.088492</td>\n",
       "      <td>36</td>\n",
       "      <td>-0.093097</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>STL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_12_ARL@STL</td>\n",
       "      <td>-0.048606</td>\n",
       "      <td>70</td>\n",
       "      <td>0.323925</td>\n",
       "      <td>27</td>\n",
       "      <td>-0.144030</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>STL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_18_DC@STL</td>\n",
       "      <td>0.054760</td>\n",
       "      <td>83</td>\n",
       "      <td>0.119266</td>\n",
       "      <td>34</td>\n",
       "      <td>0.102651</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>STL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_25_STL@VGS</td>\n",
       "      <td>0.151931</td>\n",
       "      <td>71</td>\n",
       "      <td>0.401209</td>\n",
       "      <td>29</td>\n",
       "      <td>-0.074383</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>STL</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_5_STL@DC</td>\n",
       "      <td>-0.149211</td>\n",
       "      <td>87</td>\n",
       "      <td>0.143353</td>\n",
       "      <td>42</td>\n",
       "      <td>-0.523829</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>VGS</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_18_VGS@ARL</td>\n",
       "      <td>0.140460</td>\n",
       "      <td>79</td>\n",
       "      <td>0.680391</td>\n",
       "      <td>36</td>\n",
       "      <td>-0.033687</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>VGS</td>\n",
       "      <td>FOOTBALL_XFL_2023_2_25_DC@VGS</td>\n",
       "      <td>-0.159233</td>\n",
       "      <td>71</td>\n",
       "      <td>-0.066656</td>\n",
       "      <td>23</td>\n",
       "      <td>-0.453290</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>VGS</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_12_VGS@DC</td>\n",
       "      <td>-0.063450</td>\n",
       "      <td>82</td>\n",
       "      <td>0.343717</td>\n",
       "      <td>37</td>\n",
       "      <td>0.188104</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>VGS</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_18_ORL@VGS</td>\n",
       "      <td>-0.080902</td>\n",
       "      <td>87</td>\n",
       "      <td>0.506837</td>\n",
       "      <td>28</td>\n",
       "      <td>-0.086580</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>VGS</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_25_STL@VGS</td>\n",
       "      <td>-0.162688</td>\n",
       "      <td>77</td>\n",
       "      <td>0.023904</td>\n",
       "      <td>39</td>\n",
       "      <td>-0.058562</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>VGS</td>\n",
       "      <td>FOOTBALL_XFL_2023_3_4_SEA@VGS</td>\n",
       "      <td>-0.137715</td>\n",
       "      <td>85</td>\n",
       "      <td>0.176693</td>\n",
       "      <td>28</td>\n",
       "      <td>-0.111861</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   posteam_abv                         game_id       epa        epa_pass  \\\n",
       "                                                    mean count      mean   \n",
       "0          ARL  FOOTBALL_XFL_2023_2_18_VGS@ARL -0.153075    84  0.188988   \n",
       "1          ARL  FOOTBALL_XFL_2023_2_26_ARL@HOU  0.091745    76  0.095962   \n",
       "2          ARL  FOOTBALL_XFL_2023_3_12_ARL@STL  0.000697    73  0.151119   \n",
       "3          ARL   FOOTBALL_XFL_2023_3_19_ARL@SA  0.014537    84  0.374734   \n",
       "4          ARL   FOOTBALL_XFL_2023_3_26_SA@ARL -0.063330    81 -0.005252   \n",
       "5          ARL   FOOTBALL_XFL_2023_3_5_ORL@ARL -0.175500    70  0.036580   \n",
       "6           DC   FOOTBALL_XFL_2023_2_19_SEA@DC -0.198273    79 -0.143659   \n",
       "7           DC   FOOTBALL_XFL_2023_2_25_DC@VGS  0.103626    83 -0.046817   \n",
       "8           DC   FOOTBALL_XFL_2023_3_12_VGS@DC  0.040518    88  0.621004   \n",
       "9           DC   FOOTBALL_XFL_2023_3_18_DC@STL -0.103258    77 -0.006225   \n",
       "10          DC   FOOTBALL_XFL_2023_3_27_HOU@DC -0.016623    89  0.216430   \n",
       "11          DC    FOOTBALL_XFL_2023_3_5_STL@DC  0.142473    83  0.467355   \n",
       "12         HOU  FOOTBALL_XFL_2023_2_18_ORL@HOU -0.018755    85  0.179711   \n",
       "13         HOU  FOOTBALL_XFL_2023_2_26_ARL@HOU -0.109476    79 -0.123988   \n",
       "14         HOU  FOOTBALL_XFL_2023_3_11_HOU@ORL  0.091270    74  0.293959   \n",
       "15         HOU  FOOTBALL_XFL_2023_3_16_HOU@SEA -0.001939    89 -0.031869   \n",
       "16         HOU   FOOTBALL_XFL_2023_3_27_HOU@DC -0.002296    75  0.733751   \n",
       "17         HOU    FOOTBALL_XFL_2023_3_5_SA@HOU  0.022892    90  0.358716   \n",
       "18         ORL  FOOTBALL_XFL_2023_2_18_ORL@HOU -0.009983    84  0.376711   \n",
       "19         ORL   FOOTBALL_XFL_2023_2_26_SA@ORL -0.058945    86 -0.111051   \n",
       "20         ORL  FOOTBALL_XFL_2023_3_11_HOU@ORL -0.120370    85  0.295070   \n",
       "21         ORL  FOOTBALL_XFL_2023_3_18_ORL@VGS  0.033532    92  0.438818   \n",
       "22         ORL  FOOTBALL_XFL_2023_3_25_SEA@ORL -0.041116    96 -0.059181   \n",
       "23         ORL   FOOTBALL_XFL_2023_3_5_ORL@ARL  0.143842    76  0.624933   \n",
       "24          SA   FOOTBALL_XFL_2023_2_19_STL@SA  0.004783    96  0.148532   \n",
       "25          SA   FOOTBALL_XFL_2023_2_26_SA@ORL  0.044653    74  0.400708   \n",
       "26          SA   FOOTBALL_XFL_2023_3_11_SA@SEA -0.005807    77  0.152469   \n",
       "27          SA   FOOTBALL_XFL_2023_3_19_ARL@SA -0.064799    71 -0.005546   \n",
       "28          SA   FOOTBALL_XFL_2023_3_26_SA@ARL  0.038347    75 -0.188643   \n",
       "29          SA    FOOTBALL_XFL_2023_3_5_SA@HOU -0.081666    72 -0.188775   \n",
       "30         SEA   FOOTBALL_XFL_2023_2_19_SEA@DC  0.132956    89  0.505908   \n",
       "31         SEA  FOOTBALL_XFL_2023_2_23_STL@SEA -0.049026    62  0.050403   \n",
       "32         SEA   FOOTBALL_XFL_2023_3_11_SA@SEA -0.038553    79  0.158605   \n",
       "33         SEA  FOOTBALL_XFL_2023_3_16_HOU@SEA -0.050619    71  0.071864   \n",
       "34         SEA  FOOTBALL_XFL_2023_3_25_SEA@ORL  0.002657    82 -0.070022   \n",
       "35         SEA   FOOTBALL_XFL_2023_3_4_SEA@VGS  0.096195    84  0.443056   \n",
       "36         STL   FOOTBALL_XFL_2023_2_19_STL@SA -0.060018    71  0.364377   \n",
       "37         STL  FOOTBALL_XFL_2023_2_23_STL@SEA  0.010092    90  0.088492   \n",
       "38         STL  FOOTBALL_XFL_2023_3_12_ARL@STL -0.048606    70  0.323925   \n",
       "39         STL   FOOTBALL_XFL_2023_3_18_DC@STL  0.054760    83  0.119266   \n",
       "40         STL  FOOTBALL_XFL_2023_3_25_STL@VGS  0.151931    71  0.401209   \n",
       "41         STL    FOOTBALL_XFL_2023_3_5_STL@DC -0.149211    87  0.143353   \n",
       "42         VGS  FOOTBALL_XFL_2023_2_18_VGS@ARL  0.140460    79  0.680391   \n",
       "43         VGS   FOOTBALL_XFL_2023_2_25_DC@VGS -0.159233    71 -0.066656   \n",
       "44         VGS   FOOTBALL_XFL_2023_3_12_VGS@DC -0.063450    82  0.343717   \n",
       "45         VGS  FOOTBALL_XFL_2023_3_18_ORL@VGS -0.080902    87  0.506837   \n",
       "46         VGS  FOOTBALL_XFL_2023_3_25_STL@VGS -0.162688    77  0.023904   \n",
       "47         VGS   FOOTBALL_XFL_2023_3_4_SEA@VGS -0.137715    85  0.176693   \n",
       "\n",
       "          epa_rush        \n",
       "   count      mean count  \n",
       "0     25 -0.214525    31  \n",
       "1     30 -0.348942    19  \n",
       "2     39  0.145666    15  \n",
       "3     26 -0.185009    33  \n",
       "4     29 -0.155953    25  \n",
       "5     23 -0.424715    27  \n",
       "6     21 -0.130373    33  \n",
       "7     25  0.104703    42  \n",
       "8     21 -0.070663    39  \n",
       "9     19  0.020104    35  \n",
       "10    32 -0.097385    30  \n",
       "11    23  0.251272    39  \n",
       "12    42 -0.124999    20  \n",
       "13    29  0.010122    28  \n",
       "14    33  0.538282    15  \n",
       "15    47 -0.090288    13  \n",
       "16    28 -0.080291    19  \n",
       "17    36  0.016445    30  \n",
       "18    39  0.188442    16  \n",
       "19    32 -0.046282    22  \n",
       "20    34  0.141587    21  \n",
       "21    34  0.174036    24  \n",
       "22    44  0.417658    22  \n",
       "23    31 -0.097852    25  \n",
       "24    36 -0.037244    39  \n",
       "25    24 -0.160469    26  \n",
       "26    39 -0.527409    11  \n",
       "27    34  0.019952    14  \n",
       "28    20  0.009114    24  \n",
       "29    20 -0.201757    27  \n",
       "30    56 -0.429221    17  \n",
       "31    29  0.154771    21  \n",
       "32    41 -0.134310    20  \n",
       "33    32  0.039489    23  \n",
       "34    35 -0.147605    20  \n",
       "35    37  0.424393    25  \n",
       "36    26  0.158652    15  \n",
       "37    36 -0.093097    26  \n",
       "38    27 -0.144030    28  \n",
       "39    34  0.102651    21  \n",
       "40    29 -0.074383    23  \n",
       "41    42 -0.523829    17  \n",
       "42    36 -0.033687    15  \n",
       "43    23 -0.453290    21  \n",
       "44    37  0.188104    20  \n",
       "45    28 -0.086580    31  \n",
       "46    39 -0.058562    13  \n",
       "47    28 -0.111861    30  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# home team = home_team_abv\n",
    "# away team = away_team\n",
    "\n",
    "# offense = posteam_abv\n",
    "# defense = defteam_abv\n",
    "\n",
    "# posteam = posteam\n",
    "# EPA = epa\n",
    "off_df = pbp_df.groupby([\"posteam_abv\",\"game_id\"],as_index=False).aggregate(\n",
    "    {\n",
    "        'epa':['mean','count'],\n",
    "        'epa_pass':['mean','count'],\n",
    "        'epa_rush':['mean','count']\n",
    "    }\n",
    ")\n",
    "#off_df['EPA/Play'] = off_df['sum'] / off_df['count']\n",
    "off_df\n"
   ]
  }
 ],
 "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.10.8"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}