qb_df.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "582fb3c5-760f-4663-8ab3-f8199113aa19",
   "metadata": {},
   "outputs": [],
   "source": [
    "# This produces the dataframe for QB"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c7da2b3f-06bc-4750-ab86-9530c4eb73d6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c98a57e8-6f9d-4242-b55a-084a50ee6dee",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Notes on the NFL Library ##\n",
    "# the NFL python library seem to not work on Tuesday probably due to updates (not confirmed)\n",
    "# unbalanced dataframe - pfr stats start at 2018; all other stats go back to 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d0bf3ca3-8b7c-42cc-b3df-4bd39f8e99fe",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "21ad7f6c-5cb9-4dc3-a2c7-44401c56a525",
   "metadata": {},
   "outputs": [],
   "source": [
    "## REQUIRED ACTIONS - Include in a README doc ## \n",
    "# modify the season start date in the 'get_current_week' function\n",
    "# modify the number of weeks if the NFL adds regular season games to the schedule"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0b01f34e-7a01-41f7-8080-0f3317ed92ab",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "251d4fbb-9090-4618-8f13-0f6ec2fc0670",
   "metadata": {},
   "outputs": [],
   "source": [
    "# import the libraries\n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd\n",
    "import json\n",
    "import glob\n",
    "from IPython.display import display, HTML\n",
    "from datetime import datetime\n",
    "import nfl_data_py as nfl\n",
    "import os\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9ad493c2-3c27-4f13-ad17-149feceb37a7",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "7b79c33b-9fb1-43b1-8cb5-9b7c3f5e69db",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Set Pandas options to display all columns in a single row without wrapping\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.width', 1000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3e2251a1-1d53-4b3f-b4c9-80208e19d2c6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "5b595ad1-65f9-4a36-b36d-059c4e32118f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to calculate the current week of the NFL season\n",
    "def get_current_week():\n",
    "    current_date = datetime.now()\n",
    "    season_start_date = datetime(2024, 9, 4)  # Update for the season start\n",
    "    current_week = ((current_date - season_start_date).days // 7) + 1\n",
    "    return current_week\n",
    "\n",
    "# Define the current NFL year, week, and season type\n",
    "current_year = datetime.now().year\n",
    "current_week = get_current_week()\n",
    "seasontype = 2 if current_week <= 18 else 3  # Regular season or playoffs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d75c245d-9f4c-4d87-bdeb-4937e8aa8667",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ce477098-ff0f-44fc-a442-bdf5c69b5933",
   "metadata": {},
   "outputs": [],
   "source": [
    "# define the years to pull\n",
    "# nfl.import_weekly_data(years, columns, downcast)\n",
    "def get_year_range(current_year, current_week, start_year=2017):\n",
    "    if current_week <= 18:  # Regular season\n",
    "        return list(range(start_year, current_year + 1))\n",
    "    else:  # Playoffs\n",
    "        return list(range(start_year, current_year))\n",
    "\n",
    "# Use the function\n",
    "years = get_year_range(current_year, current_week)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f7e6fb3b-fcc0-4232-ac79-395b09133639",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "d9df950b-b53b-433b-870e-37d9650f0146",
   "metadata": {},
   "outputs": [],
   "source": [
    "# define the base columns. \n",
    "base_columns = [\n",
    "    'season', 'season_type', 'week', 'player_id', 'player_name', \n",
    "    'position', 'position_group', 'recent_team'\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8f4a4263-f900-4ec7-ba6a-702dc22c1113",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "4fbbee15-9d55-4845-987e-e3be8134f0d4",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import the player IDs from nfl.import_ids() - without parameters\n",
    "ids_data = nfl.import_ids()\n",
    "\n",
    "# Drop the unnecessary columns\n",
    "columns_to_drop = [\n",
    "    'position', 'team', 'birthdate', 'age', 'draft_year', \n",
    "    'draft_round', 'draft_pick', 'draft_ovr', 'twitter_username', \n",
    "    'height', 'weight', 'college', 'db_season'\n",
    "]\n",
    "ids_data = ids_data.drop(columns=columns_to_drop, errors='ignore')\n",
    "\n",
    "# Display the resulting dataframe for review\n",
    "# print(f\"Columns after dropping unnecessary ones: {ids_data.columns.tolist()}\")\n",
    "# display(ids_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ff0afa14-cff4-40bb-9fd3-fd387a7670ca",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "4c9a3096-2082-41e8-914c-e8cbbf88304b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Downcasting floats.\n"
     ]
    }
   ],
   "source": [
    "# import the weekly data from nfl.import_weekly_data(years, columns, downcast)\n",
    "weekly_data = nfl.import_weekly_data(\n",
    "    years=years,\n",
    "    columns=base_columns\n",
    ")\n",
    "\n",
    "# display(weekly_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "11968118-b092-4d84-9c1a-2a58782892c2",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "433f9d9b-4db5-431b-900a-6f4b328645db",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Output: a dataframe of ALL NFL athletes info and ids since 2017\n",
    "\n",
    "# Merge the two dataframes on 'player_id' and 'gsis_id'\n",
    "# Align column names for merging\n",
    "ids_data = ids_data.rename(columns={'gsis_id': 'player_id'})  \n",
    "id_dataframe = pd.merge(weekly_data, ids_data, on='player_id', how='inner')\n",
    "\n",
    "# Assign the resulting dataframe to a variable\n",
    "all_players_id_data = id_dataframe\n",
    "\n",
    "# Display the resulting ID dataframe\n",
    "# display(all_players_id_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "056f1495-28ff-4afb-abbc-f058c9c77f42",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "94ff1842-bc42-4858-a6e9-8500ba79510a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of merged dataframe: (5289, 29)\n"
     ]
    }
   ],
   "source": [
    "## Output: a dataframe of NFL QB info and ids since 2017\n",
    "# Extract QB data from the dataframe\n",
    "# Create a new dataframe with only quarterbacks\n",
    "quarterback_ids = all_players_id_data[all_players_id_data['position'] == 'QB']\n",
    "\n",
    "# Display the resulting dataframe for review\n",
    "print(f\"Shape of merged dataframe: {quarterback_ids.shape}\")\n",
    "\n",
    "# Display the resulting dataframe for review\n",
    "# display(quarterback_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4b7d533b-4fc2-4c42-9d69-8245afda5c99",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "f034786a-793a-44be-b2e6-a6a9fb062038",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Downcasting floats.\n",
      "Shape of merged dataframe: (5289, 46)\n",
      "Row count matches: True\n"
     ]
    }
   ],
   "source": [
    "## Output: a dataframe of NFL QB info, ids, and stats since 2017\n",
    "\n",
    "# QB-specific columns (passing-related)\n",
    "qb_specific_columns = [\n",
    "    'completions', 'attempts', 'passing_yards', 'passing_tds', 'rushing_yards',\n",
    "    'interceptions', 'sacks', 'sack_yards', 'sack_fumbles', \n",
    "    'sack_fumbles_lost', 'passing_air_yards', \n",
    "    'passing_yards_after_catch', 'passing_first_downs', \n",
    "    'passing_epa', 'passing_2pt_conversions', 'pacr', 'dakota'\n",
    "]\n",
    "\n",
    "# Pull QB-specific columns from weekly data\n",
    "qb_stats = nfl.import_weekly_data(\n",
    "    years=years,\n",
    "    columns=['player_id', 'season', 'week'] + qb_specific_columns  # Include keys for merging\n",
    ")\n",
    "\n",
    "# Merge QB-specific stats with quarterback_ids\n",
    "qb_ids_weekly_stats = pd.merge(\n",
    "    quarterback_ids,\n",
    "    qb_stats,\n",
    "    on=['player_id', 'season', 'week'],  # Ensure correct alignment\n",
    "    how='inner'\n",
    ")\n",
    "\n",
    "# Display the resulting dataframe for review\n",
    "print(f\"Shape of merged dataframe: {qb_ids_weekly_stats.shape}\")\n",
    "\n",
    "# Row integrity check\n",
    "print(\n",
    "    f\"Row count matches: {qb_ids_weekly_stats.shape[0] == quarterback_ids.shape[0]}\"\n",
    ")\n",
    "\n",
    "# Display the dataframe\n",
    "# display(qb_ids_weekly_stats)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "926d3bde-1c84-4a9e-a771-9c3ff00f4bcc",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d992dd04-d1f9-4c28-93c7-391937007cd4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of NGS QB DataFrame after dropping columns: (4419, 23)\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>season</th>\n",
       "      <th>week</th>\n",
       "      <th>player_display_name</th>\n",
       "      <th>team_abbr</th>\n",
       "      <th>avg_time_to_throw</th>\n",
       "      <th>avg_completed_air_yards</th>\n",
       "      <th>avg_intended_air_yards</th>\n",
       "      <th>avg_air_yards_differential</th>\n",
       "      <th>aggressiveness</th>\n",
       "      <th>max_completed_air_distance</th>\n",
       "      <th>avg_air_yards_to_sticks</th>\n",
       "      <th>pass_yards</th>\n",
       "      <th>pass_touchdowns</th>\n",
       "      <th>passer_rating</th>\n",
       "      <th>completion_percentage</th>\n",
       "      <th>expected_completion_percentage</th>\n",
       "      <th>completion_percentage_above_expectation</th>\n",
       "      <th>avg_air_distance</th>\n",
       "      <th>max_air_distance</th>\n",
       "      <th>player_gsis_id</th>\n",
       "      <th>player_first_name</th>\n",
       "      <th>player_last_name</th>\n",
       "      <th>player_short_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>614</th>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Russell Wilson</td>\n",
       "      <td>SEA</td>\n",
       "      <td>3.198296</td>\n",
       "      <td>7.710000</td>\n",
       "      <td>10.460000</td>\n",
       "      <td>-2.750000</td>\n",
       "      <td>18.518519</td>\n",
       "      <td>46.771380</td>\n",
       "      <td>2.460000</td>\n",
       "      <td>158</td>\n",
       "      <td>0</td>\n",
       "      <td>69.675926</td>\n",
       "      <td>51.851852</td>\n",
       "      <td>55.170944</td>\n",
       "      <td>-3.319092</td>\n",
       "      <td>23.691973</td>\n",
       "      <td>51.569332</td>\n",
       "      <td>00-0029263</td>\n",
       "      <td>Russell</td>\n",
       "      <td>Wilson</td>\n",
       "      <td>R.Wilson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>615</th>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Scott Tolzien</td>\n",
       "      <td>IND</td>\n",
       "      <td>2.516167</td>\n",
       "      <td>5.704444</td>\n",
       "      <td>9.126111</td>\n",
       "      <td>-3.421667</td>\n",
       "      <td>27.777778</td>\n",
       "      <td>35.658975</td>\n",
       "      <td>0.681667</td>\n",
       "      <td>128</td>\n",
       "      <td>0</td>\n",
       "      <td>33.796296</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>60.038921</td>\n",
       "      <td>-10.038921</td>\n",
       "      <td>22.228064</td>\n",
       "      <td>39.893389</td>\n",
       "      <td>00-0028595</td>\n",
       "      <td>Scott</td>\n",
       "      <td>Tolzien</td>\n",
       "      <td>S.Tolzien</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>616</th>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Josh McCown</td>\n",
       "      <td>NYJ</td>\n",
       "      <td>2.372103</td>\n",
       "      <td>2.592917</td>\n",
       "      <td>4.661351</td>\n",
       "      <td>-2.068435</td>\n",
       "      <td>10.256410</td>\n",
       "      <td>28.385873</td>\n",
       "      <td>-4.095405</td>\n",
       "      <td>187</td>\n",
       "      <td>0</td>\n",
       "      <td>56.250000</td>\n",
       "      <td>66.666667</td>\n",
       "      <td>69.385185</td>\n",
       "      <td>-2.718518</td>\n",
       "      <td>17.795295</td>\n",
       "      <td>36.042798</td>\n",
       "      <td>00-0021206</td>\n",
       "      <td>Joshua</td>\n",
       "      <td>McCown</td>\n",
       "      <td>J.McCown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>617</th>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Alex Smith</td>\n",
       "      <td>KC</td>\n",
       "      <td>3.023914</td>\n",
       "      <td>5.651429</td>\n",
       "      <td>7.390571</td>\n",
       "      <td>-1.739143</td>\n",
       "      <td>14.285714</td>\n",
       "      <td>51.773205</td>\n",
       "      <td>-0.580857</td>\n",
       "      <td>368</td>\n",
       "      <td>4</td>\n",
       "      <td>148.571429</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>70.111395</td>\n",
       "      <td>9.888605</td>\n",
       "      <td>18.876969</td>\n",
       "      <td>51.773205</td>\n",
       "      <td>00-0023436</td>\n",
       "      <td>Alexander</td>\n",
       "      <td>Smith</td>\n",
       "      <td>A.Smith</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Trevor Siemian</td>\n",
       "      <td>DEN</td>\n",
       "      <td>2.264107</td>\n",
       "      <td>8.797059</td>\n",
       "      <td>7.482500</td>\n",
       "      <td>1.314559</td>\n",
       "      <td>10.714286</td>\n",
       "      <td>38.528541</td>\n",
       "      <td>-0.374643</td>\n",
       "      <td>219</td>\n",
       "      <td>2</td>\n",
       "      <td>94.196429</td>\n",
       "      <td>60.714286</td>\n",
       "      <td>60.348870</td>\n",
       "      <td>0.365416</td>\n",
       "      <td>21.617479</td>\n",
       "      <td>38.528541</td>\n",
       "      <td>00-0032156</td>\n",
       "      <td>Trevor</td>\n",
       "      <td>Siemian</td>\n",
       "      <td>T.Siemian</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5313</th>\n",
       "      <td>2024</td>\n",
       "      <td>19</td>\n",
       "      <td>Jayden Daniels</td>\n",
       "      <td>WAS</td>\n",
       "      <td>2.819886</td>\n",
       "      <td>5.825417</td>\n",
       "      <td>6.187187</td>\n",
       "      <td>-0.361771</td>\n",
       "      <td>14.285714</td>\n",
       "      <td>43.095299</td>\n",
       "      <td>-0.344063</td>\n",
       "      <td>268</td>\n",
       "      <td>2</td>\n",
       "      <td>110.178571</td>\n",
       "      <td>68.571429</td>\n",
       "      <td>61.994531</td>\n",
       "      <td>6.576898</td>\n",
       "      <td>19.686468</td>\n",
       "      <td>45.874247</td>\n",
       "      <td>00-0039910</td>\n",
       "      <td>Jayden</td>\n",
       "      <td>Daniels</td>\n",
       "      <td>J.Daniels</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5314</th>\n",
       "      <td>2024</td>\n",
       "      <td>20</td>\n",
       "      <td>Jared Goff</td>\n",
       "      <td>DET</td>\n",
       "      <td>3.196595</td>\n",
       "      <td>7.301739</td>\n",
       "      <td>9.410833</td>\n",
       "      <td>-2.109094</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>37.782701</td>\n",
       "      <td>0.160833</td>\n",
       "      <td>313</td>\n",
       "      <td>1</td>\n",
       "      <td>59.687500</td>\n",
       "      <td>57.500000</td>\n",
       "      <td>63.481805</td>\n",
       "      <td>-5.981805</td>\n",
       "      <td>21.587656</td>\n",
       "      <td>53.567051</td>\n",
       "      <td>00-0033106</td>\n",
       "      <td>Jared</td>\n",
       "      <td>Goff</td>\n",
       "      <td>J.Goff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5315</th>\n",
       "      <td>2024</td>\n",
       "      <td>20</td>\n",
       "      <td>Patrick Mahomes</td>\n",
       "      <td>KC</td>\n",
       "      <td>2.616160</td>\n",
       "      <td>4.476875</td>\n",
       "      <td>6.087917</td>\n",
       "      <td>-1.611042</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>34.660123</td>\n",
       "      <td>-3.120417</td>\n",
       "      <td>177</td>\n",
       "      <td>1</td>\n",
       "      <td>98.250000</td>\n",
       "      <td>64.000000</td>\n",
       "      <td>64.416556</td>\n",
       "      <td>-0.416556</td>\n",
       "      <td>18.482824</td>\n",
       "      <td>52.013423</td>\n",
       "      <td>00-0033873</td>\n",
       "      <td>Patrick</td>\n",
       "      <td>Mahomes</td>\n",
       "      <td>P.Mahomes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5316</th>\n",
       "      <td>2024</td>\n",
       "      <td>20</td>\n",
       "      <td>C.J. Stroud</td>\n",
       "      <td>HOU</td>\n",
       "      <td>2.951321</td>\n",
       "      <td>9.506316</td>\n",
       "      <td>9.137500</td>\n",
       "      <td>0.368816</td>\n",
       "      <td>28.571429</td>\n",
       "      <td>35.346520</td>\n",
       "      <td>0.708929</td>\n",
       "      <td>245</td>\n",
       "      <td>0</td>\n",
       "      <td>95.089286</td>\n",
       "      <td>67.857143</td>\n",
       "      <td>61.638141</td>\n",
       "      <td>6.219002</td>\n",
       "      <td>20.664023</td>\n",
       "      <td>35.346520</td>\n",
       "      <td>00-0039163</td>\n",
       "      <td>Coleridge</td>\n",
       "      <td>Stroud</td>\n",
       "      <td>C.Stroud</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5317</th>\n",
       "      <td>2024</td>\n",
       "      <td>20</td>\n",
       "      <td>Jayden Daniels</td>\n",
       "      <td>WAS</td>\n",
       "      <td>2.472742</td>\n",
       "      <td>4.951818</td>\n",
       "      <td>5.642069</td>\n",
       "      <td>-0.690251</td>\n",
       "      <td>9.677419</td>\n",
       "      <td>48.299591</td>\n",
       "      <td>-1.737241</td>\n",
       "      <td>299</td>\n",
       "      <td>2</td>\n",
       "      <td>122.916667</td>\n",
       "      <td>70.967742</td>\n",
       "      <td>70.779632</td>\n",
       "      <td>0.188110</td>\n",
       "      <td>19.847636</td>\n",
       "      <td>48.299591</td>\n",
       "      <td>00-0039910</td>\n",
       "      <td>Jayden</td>\n",
       "      <td>Daniels</td>\n",
       "      <td>J.Daniels</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4419 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      season  week player_display_name team_abbr  avg_time_to_throw  avg_completed_air_yards  avg_intended_air_yards  avg_air_yards_differential  aggressiveness  max_completed_air_distance  avg_air_yards_to_sticks  pass_yards  pass_touchdowns  passer_rating  completion_percentage  expected_completion_percentage  completion_percentage_above_expectation  avg_air_distance  max_air_distance player_gsis_id player_first_name player_last_name player_short_name\n",
       "614     2017     1      Russell Wilson       SEA           3.198296                 7.710000               10.460000                   -2.750000       18.518519                   46.771380                 2.460000         158                0      69.675926              51.851852                       55.170944                                -3.319092         23.691973         51.569332     00-0029263           Russell           Wilson          R.Wilson\n",
       "615     2017     1       Scott Tolzien       IND           2.516167                 5.704444                9.126111                   -3.421667       27.777778                   35.658975                 0.681667         128                0      33.796296              50.000000                       60.038921                               -10.038921         22.228064         39.893389     00-0028595             Scott          Tolzien         S.Tolzien\n",
       "616     2017     1         Josh McCown       NYJ           2.372103                 2.592917                4.661351                   -2.068435       10.256410                   28.385873                -4.095405         187                0      56.250000              66.666667                       69.385185                                -2.718518         17.795295         36.042798     00-0021206            Joshua           McCown          J.McCown\n",
       "617     2017     1          Alex Smith        KC           3.023914                 5.651429                7.390571                   -1.739143       14.285714                   51.773205                -0.580857         368                4     148.571429              80.000000                       70.111395                                 9.888605         18.876969         51.773205     00-0023436         Alexander            Smith           A.Smith\n",
       "618     2017     1      Trevor Siemian       DEN           2.264107                 8.797059                7.482500                    1.314559       10.714286                   38.528541                -0.374643         219                2      94.196429              60.714286                       60.348870                                 0.365416         21.617479         38.528541     00-0032156            Trevor          Siemian         T.Siemian\n",
       "...      ...   ...                 ...       ...                ...                      ...                     ...                         ...             ...                         ...                      ...         ...              ...            ...                    ...                             ...                                      ...               ...               ...            ...               ...              ...               ...\n",
       "5313    2024    19      Jayden Daniels       WAS           2.819886                 5.825417                6.187187                   -0.361771       14.285714                   43.095299                -0.344063         268                2     110.178571              68.571429                       61.994531                                 6.576898         19.686468         45.874247     00-0039910            Jayden          Daniels         J.Daniels\n",
       "5314    2024    20          Jared Goff       DET           3.196595                 7.301739                9.410833                   -2.109094        0.000000                   37.782701                 0.160833         313                1      59.687500              57.500000                       63.481805                                -5.981805         21.587656         53.567051     00-0033106             Jared             Goff            J.Goff\n",
       "5315    2024    20     Patrick Mahomes        KC           2.616160                 4.476875                6.087917                   -1.611042       12.000000                   34.660123                -3.120417         177                1      98.250000              64.000000                       64.416556                                -0.416556         18.482824         52.013423     00-0033873           Patrick          Mahomes         P.Mahomes\n",
       "5316    2024    20         C.J. Stroud       HOU           2.951321                 9.506316                9.137500                    0.368816       28.571429                   35.346520                 0.708929         245                0      95.089286              67.857143                       61.638141                                 6.219002         20.664023         35.346520     00-0039163         Coleridge           Stroud          C.Stroud\n",
       "5317    2024    20      Jayden Daniels       WAS           2.472742                 4.951818                5.642069                   -0.690251        9.677419                   48.299591                -1.737241         299                2     122.916667              70.967742                       70.779632                                 0.188110         19.847636         48.299591     00-0039910            Jayden          Daniels         J.Daniels\n",
       "\n",
       "[4419 rows x 23 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Output: imports the NFL next-generation stats for quarterbacks from the nfl python library\n",
    "\n",
    "# Import the next-generation stats (NGS) for passing\n",
    "# Note: NGS starts at week 0 (previous season totals) - these rows are excluded\n",
    "\n",
    "# Pull NGS passing data for the specified years\n",
    "ngs_qb_df = nfl.import_ngs_data('passing', years)\n",
    "\n",
    "# Exclude rows where 'week' == 0 and filter for 'QB' position\n",
    "ngs_qb_df = ngs_qb_df[(ngs_qb_df['week'] != 0) & (ngs_qb_df['player_position'] == 'QB')]\n",
    "\n",
    "# Drop unnecessary columns\n",
    "ngs_qb_df = ngs_qb_df.drop(\n",
    "    columns=['season_type', 'player_position', 'player_jersey_number',\n",
    "             'attempts','completions','interceptions'], errors='ignore'\n",
    ")\n",
    "\n",
    "# Display the resulting dataframe\n",
    "print(f\"Shape of NGS QB DataFrame after dropping columns: {ngs_qb_df.shape}\")\n",
    "display(ngs_qb_df)\n",
    "\n",
    "# Save the dataframe to a CSV file\n",
    "# ngs_qb_df.to_csv('ngs_qb_df.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a27dc298-b7d7-425b-b053-47e9f33466ed",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "09aad67f-43ac-4a18-b90e-15c6e7959719",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of merged dataframe: (5289, 67)\n",
      "Row count matches: True\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>season</th>\n",
       "      <th>season_type</th>\n",
       "      <th>week</th>\n",
       "      <th>player_id</th>\n",
       "      <th>player_name</th>\n",
       "      <th>position</th>\n",
       "      <th>position_group</th>\n",
       "      <th>recent_team</th>\n",
       "      <th>mfl_id</th>\n",
       "      <th>sportradar_id</th>\n",
       "      <th>fantasypros_id</th>\n",
       "      <th>pff_id</th>\n",
       "      <th>sleeper_id</th>\n",
       "      <th>nfl_id</th>\n",
       "      <th>espn_id</th>\n",
       "      <th>yahoo_id</th>\n",
       "      <th>fleaflicker_id</th>\n",
       "      <th>cbs_id</th>\n",
       "      <th>pfr_id</th>\n",
       "      <th>cfbref_id</th>\n",
       "      <th>rotowire_id</th>\n",
       "      <th>rotoworld_id</th>\n",
       "      <th>ktc_id</th>\n",
       "      <th>stats_id</th>\n",
       "      <th>stats_global_id</th>\n",
       "      <th>fantasy_data_id</th>\n",
       "      <th>swish_id</th>\n",
       "      <th>name</th>\n",
       "      <th>merge_name</th>\n",
       "      <th>completions</th>\n",
       "      <th>attempts</th>\n",
       "      <th>passing_yards</th>\n",
       "      <th>passing_tds</th>\n",
       "      <th>rushing_yards</th>\n",
       "      <th>interceptions</th>\n",
       "      <th>sacks</th>\n",
       "      <th>sack_yards</th>\n",
       "      <th>sack_fumbles</th>\n",
       "      <th>sack_fumbles_lost</th>\n",
       "      <th>passing_air_yards</th>\n",
       "      <th>passing_yards_after_catch</th>\n",
       "      <th>passing_first_downs</th>\n",
       "      <th>passing_epa</th>\n",
       "      <th>passing_2pt_conversions</th>\n",
       "      <th>pacr</th>\n",
       "      <th>dakota</th>\n",
       "      <th>player_display_name</th>\n",
       "      <th>team_abbr</th>\n",
       "      <th>avg_time_to_throw</th>\n",
       "      <th>avg_completed_air_yards</th>\n",
       "      <th>avg_intended_air_yards</th>\n",
       "      <th>avg_air_yards_differential</th>\n",
       "      <th>aggressiveness</th>\n",
       "      <th>max_completed_air_distance</th>\n",
       "      <th>avg_air_yards_to_sticks</th>\n",
       "      <th>pass_yards</th>\n",
       "      <th>pass_touchdowns</th>\n",
       "      <th>passer_rating</th>\n",
       "      <th>completion_percentage</th>\n",
       "      <th>expected_completion_percentage</th>\n",
       "      <th>completion_percentage_above_expectation</th>\n",
       "      <th>avg_air_distance</th>\n",
       "      <th>max_air_distance</th>\n",
       "      <th>player_gsis_id</th>\n",
       "      <th>player_first_name</th>\n",
       "      <th>player_last_name</th>\n",
       "      <th>player_short_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>1</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>16</td>\n",
       "      <td>36</td>\n",
       "      <td>267.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>567.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.753902</td>\n",
       "      <td>0</td>\n",
       "      <td>0.470899</td>\n",
       "      <td>0.042110</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>3.120750</td>\n",
       "      <td>9.219375</td>\n",
       "      <td>15.085833</td>\n",
       "      <td>-5.866458</td>\n",
       "      <td>33.333333</td>\n",
       "      <td>57.983004</td>\n",
       "      <td>6.196944</td>\n",
       "      <td>267.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.023148</td>\n",
       "      <td>44.444444</td>\n",
       "      <td>53.709919</td>\n",
       "      <td>-9.265475</td>\n",
       "      <td>27.996684</td>\n",
       "      <td>59.048235</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>2</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>30</td>\n",
       "      <td>39</td>\n",
       "      <td>447.0</td>\n",
       "      <td>3</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>25.089682</td>\n",
       "      <td>0</td>\n",
       "      <td>1.590747</td>\n",
       "      <td>0.304464</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>2.301564</td>\n",
       "      <td>6.826333</td>\n",
       "      <td>7.545385</td>\n",
       "      <td>-0.719051</td>\n",
       "      <td>12.820513</td>\n",
       "      <td>45.270829</td>\n",
       "      <td>-1.095641</td>\n",
       "      <td>447.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>139.583333</td>\n",
       "      <td>76.923077</td>\n",
       "      <td>66.956657</td>\n",
       "      <td>9.966420</td>\n",
       "      <td>19.953223</td>\n",
       "      <td>45.270829</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>3</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>378.0</td>\n",
       "      <td>5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>415.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>10.521861</td>\n",
       "      <td>1</td>\n",
       "      <td>0.910843</td>\n",
       "      <td>0.240395</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>2.707400</td>\n",
       "      <td>10.840000</td>\n",
       "      <td>11.857143</td>\n",
       "      <td>-1.017143</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.057143</td>\n",
       "      <td>378.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>146.190476</td>\n",
       "      <td>71.428571</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>4</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>32</td>\n",
       "      <td>45</td>\n",
       "      <td>307.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>341.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.758528</td>\n",
       "      <td>0</td>\n",
       "      <td>0.900293</td>\n",
       "      <td>0.149092</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>2.456489</td>\n",
       "      <td>5.467500</td>\n",
       "      <td>7.515333</td>\n",
       "      <td>-2.047833</td>\n",
       "      <td>8.888889</td>\n",
       "      <td>32.986209</td>\n",
       "      <td>0.159778</td>\n",
       "      <td>307.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>104.583333</td>\n",
       "      <td>71.111111</td>\n",
       "      <td>74.774611</td>\n",
       "      <td>-3.663500</td>\n",
       "      <td>19.146993</td>\n",
       "      <td>49.445393</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>5</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>30</td>\n",
       "      <td>40</td>\n",
       "      <td>303.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>248.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2.653190</td>\n",
       "      <td>0</td>\n",
       "      <td>1.221774</td>\n",
       "      <td>0.115276</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>2.694575</td>\n",
       "      <td>5.328000</td>\n",
       "      <td>6.224500</td>\n",
       "      <td>-0.896500</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>38.576066</td>\n",
       "      <td>-3.475500</td>\n",
       "      <td>303.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>94.062500</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>67.303628</td>\n",
       "      <td>7.696372</td>\n",
       "      <td>18.631851</td>\n",
       "      <td>38.576066</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</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",
       "      <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",
       "      <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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5284</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>14</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>134.0</td>\n",
       "      <td>2</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>137.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>-6.575400</td>\n",
       "      <td>0</td>\n",
       "      <td>0.978102</td>\n",
       "      <td>0.043877</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>2.860217</td>\n",
       "      <td>4.263529</td>\n",
       "      <td>6.112609</td>\n",
       "      <td>-1.849079</td>\n",
       "      <td>8.695652</td>\n",
       "      <td>34.417414</td>\n",
       "      <td>-1.365652</td>\n",
       "      <td>134.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>116.938406</td>\n",
       "      <td>73.913043</td>\n",
       "      <td>73.322051</td>\n",
       "      <td>0.590993</td>\n",
       "      <td>20.952260</td>\n",
       "      <td>36.292903</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5285</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>15</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>18</td>\n",
       "      <td>31</td>\n",
       "      <td>191.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>235.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>-3.401174</td>\n",
       "      <td>0</td>\n",
       "      <td>0.812766</td>\n",
       "      <td>-0.006490</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>3.278581</td>\n",
       "      <td>4.203889</td>\n",
       "      <td>8.167000</td>\n",
       "      <td>-3.963111</td>\n",
       "      <td>12.903226</td>\n",
       "      <td>38.640762</td>\n",
       "      <td>-1.633000</td>\n",
       "      <td>191.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>86.895161</td>\n",
       "      <td>58.064516</td>\n",
       "      <td>62.604289</td>\n",
       "      <td>-4.539772</td>\n",
       "      <td>22.596859</td>\n",
       "      <td>46.472393</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5286</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>16</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>26</td>\n",
       "      <td>40</td>\n",
       "      <td>334.0</td>\n",
       "      <td>2</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>365.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>16.464520</td>\n",
       "      <td>0</td>\n",
       "      <td>0.915069</td>\n",
       "      <td>0.163077</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>3.172625</td>\n",
       "      <td>6.116923</td>\n",
       "      <td>9.302432</td>\n",
       "      <td>-3.185509</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>42.081298</td>\n",
       "      <td>0.167297</td>\n",
       "      <td>334.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>107.708333</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>61.272584</td>\n",
       "      <td>3.727416</td>\n",
       "      <td>21.701507</td>\n",
       "      <td>53.100679</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5287</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>17</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>16</td>\n",
       "      <td>28</td>\n",
       "      <td>122.0</td>\n",
       "      <td>0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>202.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>-10.225746</td>\n",
       "      <td>0</td>\n",
       "      <td>0.603960</td>\n",
       "      <td>-0.000481</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>2.834179</td>\n",
       "      <td>0.964375</td>\n",
       "      <td>6.360385</td>\n",
       "      <td>-5.396010</td>\n",
       "      <td>3.571429</td>\n",
       "      <td>29.989131</td>\n",
       "      <td>-3.831923</td>\n",
       "      <td>122.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.976190</td>\n",
       "      <td>57.142857</td>\n",
       "      <td>63.191599</td>\n",
       "      <td>-6.048742</td>\n",
       "      <td>20.304159</td>\n",
       "      <td>39.255328</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5288</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>18</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>21</td>\n",
       "      <td>29</td>\n",
       "      <td>148.0</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.353224</td>\n",
       "      <td>0</td>\n",
       "      <td>1.275862</td>\n",
       "      <td>0.157300</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>3.187000</td>\n",
       "      <td>1.983810</td>\n",
       "      <td>1.928261</td>\n",
       "      <td>0.055549</td>\n",
       "      <td>6.896552</td>\n",
       "      <td>28.094928</td>\n",
       "      <td>-8.332609</td>\n",
       "      <td>148.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>95.186782</td>\n",
       "      <td>72.413793</td>\n",
       "      <td>61.554118</td>\n",
       "      <td>10.859675</td>\n",
       "      <td>15.773489</td>\n",
       "      <td>28.094928</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5289 rows × 67 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      season season_type  week   player_id player_name position position_group recent_team  mfl_id                         sportradar_id  fantasypros_id  pff_id  sleeper_id            nfl_id    espn_id  yahoo_id  fleaflicker_id      cbs_id    pfr_id         cfbref_id  rotowire_id  rotoworld_id  ktc_id  stats_id  stats_global_id  fantasy_data_id   swish_id            name      merge_name  completions  attempts  passing_yards  passing_tds  rushing_yards  interceptions  sacks  sack_yards  sack_fumbles  sack_fumbles_lost  passing_air_yards  passing_yards_after_catch  passing_first_downs  passing_epa  passing_2pt_conversions      pacr    dakota player_display_name team_abbr  avg_time_to_throw  avg_completed_air_yards  avg_intended_air_yards  avg_air_yards_differential  aggressiveness  max_completed_air_distance  avg_air_yards_to_sticks  pass_yards  pass_touchdowns  passer_rating  completion_percentage  expected_completion_percentage  completion_percentage_above_expectation  \\\n",
       "0       2017         REG     1  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           16        36          267.0            0            0.0            0.0    3.0        20.0             0                  0              567.0                      112.0                 11.0     1.753902                        0  0.470899  0.042110           Tom Brady        NE           3.120750                 9.219375               15.085833                   -5.866458       33.333333                   57.983004                 6.196944       267.0              0.0      70.023148              44.444444                       53.709919                                -9.265475   \n",
       "1       2017         REG     2  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           30        39          447.0            3            9.0            0.0    2.0        11.0             0                  0              281.0                      237.0                 19.0    25.089682                        0  1.590747  0.304464           Tom Brady        NE           2.301564                 6.826333                7.545385                   -0.719051       12.820513                   45.270829                -1.095641       447.0              3.0     139.583333              76.923077                       66.956657                                 9.966420   \n",
       "2       2017         REG     3  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           25        35          378.0            5            6.0            0.0    5.0        41.0             3                  1              415.0                      107.0                 16.0    10.521861                        1  0.910843  0.240395           Tom Brady        NE           2.707400                10.840000               11.857143                   -1.017143       20.000000                         NaN                 2.057143       378.0              5.0     146.190476              71.428571                             NaN                                      NaN   \n",
       "3       2017         REG     4  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           32        45          307.0            2            2.0            0.0    3.0        14.0             0                  0              341.0                      132.0                 18.0     9.758528                        0  0.900293  0.149092           Tom Brady        NE           2.456489                 5.467500                7.515333                   -2.047833        8.888889                   32.986209                 0.159778       307.0              2.0     104.583333              71.111111                       74.774611                                -3.663500   \n",
       "4       2017         REG     5  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           30        40          303.0            1            5.0            1.0    3.0        14.0             1                  1              248.0                      130.0                 15.0     2.653190                        0  1.221774  0.115276           Tom Brady        NE           2.694575                 5.328000                6.224500                   -0.896500       10.000000                   38.576066                -3.475500       303.0              1.0      94.062500              75.000000                       67.303628                                 7.696372   \n",
       "...      ...         ...   ...         ...         ...      ...            ...         ...     ...                                   ...             ...     ...         ...               ...        ...       ...             ...         ...       ...               ...          ...           ...     ...       ...              ...              ...        ...             ...             ...          ...       ...            ...          ...            ...            ...    ...         ...           ...                ...                ...                        ...                  ...          ...                      ...       ...       ...                 ...       ...                ...                      ...                     ...                         ...             ...                         ...                      ...         ...              ...            ...                    ...                             ...                                      ...   \n",
       "5284    2024         REG    14  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           17        23          134.0            2           27.0            0.0    7.0        46.0             1                  1              137.0                       69.0                  9.0    -6.575400                        0  0.978102  0.043877      Caleb Williams       CHI           2.860217                 4.263529                6.112609                   -1.849079        8.695652                   34.417414                -1.365652       134.0              2.0     116.938406              73.913043                       73.322051                                 0.590993   \n",
       "5285    2024         REG    15  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           18        31          191.0            1            3.0            0.0    2.0        25.0             1                  1              235.0                      116.0                  8.0    -3.401174                        0  0.812766 -0.006490      Caleb Williams       CHI           3.278581                 4.203889                8.167000                   -3.963111       12.903226                   38.640762                -1.633000       191.0              1.0      86.895161              58.064516                       62.604289                                -4.539772   \n",
       "5286    2024         REG    16  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           26        40          334.0            2           34.0            0.0    2.0        11.0             0                  0              365.0                      167.0                 15.0    16.464520                        0  0.915069  0.163077      Caleb Williams       CHI           3.172625                 6.116923                9.302432                   -3.185509       20.000000                   42.081298                 0.167297       334.0              2.0     107.708333              65.000000                       61.272584                                 3.727416   \n",
       "5287    2024         REG    17  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           16        28          122.0            0           37.0            1.0    7.0        46.0             1                  0              202.0                      108.0                  7.0   -10.225746                        0  0.603960 -0.000481      Caleb Williams       CHI           2.834179                 0.964375                6.360385                   -5.396010        3.571429                   29.989131                -3.831923       122.0              0.0      52.976190              57.142857                       63.191599                                -6.048742   \n",
       "5288    2024         REG    18  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           21        29          148.0            1           10.0            0.0    1.0         7.0             1                  0              116.0                       98.0                 10.0     4.353224                        0  1.275862  0.157300      Caleb Williams       CHI           3.187000                 1.983810                1.928261                    0.055549        6.896552                   28.094928                -8.332609       148.0              1.0      95.186782              72.413793                       61.554118                                10.859675   \n",
       "\n",
       "      avg_air_distance  max_air_distance player_gsis_id player_first_name player_last_name player_short_name  \n",
       "0            27.996684         59.048235     00-0019596               Tom            Brady           T.Brady  \n",
       "1            19.953223         45.270829     00-0019596               Tom            Brady           T.Brady  \n",
       "2                  NaN               NaN     00-0019596               Tom            Brady           T.Brady  \n",
       "3            19.146993         49.445393     00-0019596               Tom            Brady           T.Brady  \n",
       "4            18.631851         38.576066     00-0019596               Tom            Brady           T.Brady  \n",
       "...                ...               ...            ...               ...              ...               ...  \n",
       "5284         20.952260         36.292903     00-0039918             Caleb         Williams        C.Williams  \n",
       "5285         22.596859         46.472393     00-0039918             Caleb         Williams        C.Williams  \n",
       "5286         21.701507         53.100679     00-0039918             Caleb         Williams        C.Williams  \n",
       "5287         20.304159         39.255328     00-0039918             Caleb         Williams        C.Williams  \n",
       "5288         15.773489         28.094928     00-0039918             Caleb         Williams        C.Williams  \n",
       "\n",
       "[5289 rows x 67 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Output: a dataframe of NFL QB info, ids, weekly stats, and next-gen stats since 2017\n",
    "\n",
    "# Joins qb_ids_weekly_stats dataframe with ngs_qb_df using the keys 'player_id' and 'player_gsis_id'\n",
    "# Merge qb_ids_weekly_stats with ngs_qb_df using a left join\n",
    "qb_ids_ngs_weekly_stats = pd.merge(\n",
    "    qb_ids_weekly_stats,\n",
    "    ngs_qb_df,\n",
    "    left_on=['player_id', 'season', 'week'],  # Keys from qb_ids_weekly_stats\n",
    "    right_on=['player_gsis_id', 'season', 'week'],  # Keys from ngs_qb_df\n",
    "    how='left'  # Retain all rows from qb_ids_weekly_stats\n",
    ")\n",
    "\n",
    "# Display the shape of the resulting dataframe\n",
    "print(f\"Shape of merged dataframe: {qb_ids_ngs_weekly_stats.shape}\")\n",
    "print(f\"Row count matches: {qb_ids_weekly_stats.shape[0] == qb_ids_ngs_weekly_stats.shape[0]}\")\n",
    "\n",
    "# Display a sample of the merged dataframe\n",
    "display(qb_ids_ngs_weekly_stats)\n",
    "\n",
    "# Save the dataframe to a CSV file\n",
    "# qb_ids_ngs_weekly_stats.to_csv('qb_ids_ngs_weekly_stats.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2ce10125-206f-49dd-a613-edd59ef1bd0b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "caf29834-06ee-4642-92eb-d3cb511a703c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of PFR dataframe: (4721, 22)\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>season</th>\n",
       "      <th>week</th>\n",
       "      <th>game_type</th>\n",
       "      <th>team</th>\n",
       "      <th>opponent</th>\n",
       "      <th>pfr_player_name</th>\n",
       "      <th>pfr_player_id</th>\n",
       "      <th>passing_drops</th>\n",
       "      <th>passing_drop_pct</th>\n",
       "      <th>receiving_drop</th>\n",
       "      <th>receiving_drop_pct</th>\n",
       "      <th>passing_bad_throws</th>\n",
       "      <th>passing_bad_throw_pct</th>\n",
       "      <th>times_sacked</th>\n",
       "      <th>times_blitzed</th>\n",
       "      <th>times_hurried</th>\n",
       "      <th>times_hit</th>\n",
       "      <th>times_pressured</th>\n",
       "      <th>times_pressured_pct</th>\n",
       "      <th>def_times_blitzed</th>\n",
       "      <th>def_times_hurried</th>\n",
       "      <th>def_times_hitqb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>REG</td>\n",
       "      <td>PHI</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Nick Foles</td>\n",
       "      <td>FoleNi00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.118</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.176</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>REG</td>\n",
       "      <td>PHI</td>\n",
       "      <td>ATL</td>\n",
       "      <td>Nelson Agholor</td>\n",
       "      <td>AghoNe00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>REG</td>\n",
       "      <td>ATL</td>\n",
       "      <td>PHI</td>\n",
       "      <td>Matt Ryan</td>\n",
       "      <td>RyanMa00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.250</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.265</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>REG</td>\n",
       "      <td>BAL</td>\n",
       "      <td>BUF</td>\n",
       "      <td>Joe Flacco</td>\n",
       "      <td>FlacJo00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.059</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.088</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>REG</td>\n",
       "      <td>BAL</td>\n",
       "      <td>BUF</td>\n",
       "      <td>Lamar Jackson</td>\n",
       "      <td>JackLa00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.333</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>2024</td>\n",
       "      <td>19</td>\n",
       "      <td>WC</td>\n",
       "      <td>GB</td>\n",
       "      <td>PHI</td>\n",
       "      <td>Jordan Love</td>\n",
       "      <td>LoveJo03</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.061</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.303</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.194</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>2024</td>\n",
       "      <td>19</td>\n",
       "      <td>WC</td>\n",
       "      <td>TB</td>\n",
       "      <td>WAS</td>\n",
       "      <td>Baker Mayfield</td>\n",
       "      <td>MayfBa00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.059</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.059</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.043</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>2024</td>\n",
       "      <td>19</td>\n",
       "      <td>WC</td>\n",
       "      <td>WAS</td>\n",
       "      <td>TB</td>\n",
       "      <td>Jayden Daniels</td>\n",
       "      <td>DaniJa02</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.030</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.152</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.125</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>2024</td>\n",
       "      <td>19</td>\n",
       "      <td>WC</td>\n",
       "      <td>LA</td>\n",
       "      <td>MIN</td>\n",
       "      <td>Matthew Stafford</td>\n",
       "      <td>StafMa00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.077</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.115</td>\n",
       "      <td>2.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.241</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>2024</td>\n",
       "      <td>19</td>\n",
       "      <td>WC</td>\n",
       "      <td>MIN</td>\n",
       "      <td>LA</td>\n",
       "      <td>Sam Darnold</td>\n",
       "      <td>DarnSa00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.250</td>\n",
       "      <td>9.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.220</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4721 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     season  week game_type team opponent   pfr_player_name pfr_player_id  passing_drops  passing_drop_pct  receiving_drop  receiving_drop_pct  passing_bad_throws  passing_bad_throw_pct  times_sacked  times_blitzed  times_hurried  times_hit  times_pressured  times_pressured_pct  def_times_blitzed  def_times_hurried  def_times_hitqb\n",
       "0      2018     1       REG  PHI      ATL        Nick Foles      FoleNi00            4.0             0.118             NaN                 NaN                 6.0                  0.176           2.0            7.0            5.0        2.0              9.0                0.250                NaN                NaN              NaN\n",
       "1      2018     1       REG  PHI      ATL    Nelson Agholor      AghoNe00            0.0             0.000             NaN                 NaN                 0.0                  0.000           0.0            0.0            0.0        0.0              0.0                0.000                NaN                NaN              NaN\n",
       "2      2018     1       REG  ATL      PHI         Matt Ryan      RyanMa00            2.0             0.050             NaN                 NaN                10.0                  0.250           4.0           12.0            3.0        6.0             13.0                0.265                NaN                NaN              NaN\n",
       "3      2018     1       REG  BAL      BUF        Joe Flacco      FlacJo00            2.0             0.059             NaN                 NaN                 3.0                  0.088           1.0            3.0            8.0        1.0             10.0                0.286                NaN                NaN              NaN\n",
       "4      2018     1       REG  BAL      BUF     Lamar Jackson      JackLa00            0.0             0.000             NaN                 NaN                 1.0                  0.333           1.0            1.0            2.0        0.0              3.0                0.500                NaN                NaN              NaN\n",
       "..      ...   ...       ...  ...      ...               ...           ...            ...               ...             ...                 ...                 ...                    ...           ...            ...            ...        ...              ...                  ...                ...                ...              ...\n",
       "673    2024    19        WC   GB      PHI       Jordan Love      LoveJo03            2.0             0.061             NaN                 NaN                10.0                  0.303           2.0            1.0            2.0        3.0              7.0                0.194                NaN                NaN              NaN\n",
       "674    2024    19        WC   TB      WAS    Baker Mayfield      MayfBa00            1.0             0.059             NaN                 NaN                 1.0                  0.059           1.0            2.0            0.0        0.0              1.0                0.043                NaN                NaN              NaN\n",
       "675    2024    19        WC  WAS       TB    Jayden Daniels      DaniJa02            1.0             0.030             NaN                 NaN                 5.0                  0.152           1.0            8.0            1.0        3.0              5.0                0.125                NaN                NaN              NaN\n",
       "676    2024    19        WC   LA      MIN  Matthew Stafford      StafMa00            2.0             0.077             NaN                 NaN                 3.0                  0.115           2.0           18.0            2.0        3.0              7.0                0.241                NaN                NaN              NaN\n",
       "677    2024    19        WC  MIN       LA       Sam Darnold      DarnSa00            1.0             0.025             NaN                 NaN                10.0                  0.250           9.0            7.0            1.0        1.0             11.0                0.220                NaN                NaN              NaN\n",
       "\n",
       "[4721 rows x 22 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Output: pro-football reference dataframe for passing data from the python NFL library\n",
    "# note: PFR data not available before 2018\n",
    "# there is no position info so the data will pull QB, TE, RB, and WR passing data\n",
    "\n",
    "# Define the range of years for PFR data (2018 to the current year)\n",
    "pfr_years = list(range(2018, current_year))\n",
    "\n",
    "# Import pro-football reference data for QBs\n",
    "pfr_pass_df = nfl.import_weekly_pfr('pass', pfr_years)\n",
    "\n",
    "# Drop unnecessary columns\n",
    "pfr_pass_df = pfr_pass_df.drop(\n",
    "    columns=['game_id', 'pfr_game_id', 'receiving_int', 'rushing_int'], errors='ignore'\n",
    ")\n",
    "\n",
    "# Display dataframe shape\n",
    "print(f\"Shape of PFR dataframe: {pfr_pass_df.shape}\")\n",
    "\n",
    "# Display a sample of the dataframe\n",
    "display(pfr_pass_df)\n",
    "\n",
    "# Save the dataframe to a CSV file\n",
    "# pfr_pass_df.to_csv('pfr_pass_df.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b09c9b09-d088-464a-ab75-3622385a8ed9",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "934e2ef1-ed51-40e7-a446-94402c75ea3c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of merged dataframe: (5289, 87)\n",
      "Row count matches: True\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>season</th>\n",
       "      <th>season_type</th>\n",
       "      <th>week</th>\n",
       "      <th>player_id</th>\n",
       "      <th>player_name</th>\n",
       "      <th>position</th>\n",
       "      <th>position_group</th>\n",
       "      <th>recent_team</th>\n",
       "      <th>mfl_id</th>\n",
       "      <th>sportradar_id</th>\n",
       "      <th>fantasypros_id</th>\n",
       "      <th>pff_id</th>\n",
       "      <th>sleeper_id</th>\n",
       "      <th>nfl_id</th>\n",
       "      <th>espn_id</th>\n",
       "      <th>yahoo_id</th>\n",
       "      <th>fleaflicker_id</th>\n",
       "      <th>cbs_id</th>\n",
       "      <th>pfr_id</th>\n",
       "      <th>cfbref_id</th>\n",
       "      <th>rotowire_id</th>\n",
       "      <th>rotoworld_id</th>\n",
       "      <th>ktc_id</th>\n",
       "      <th>stats_id</th>\n",
       "      <th>stats_global_id</th>\n",
       "      <th>fantasy_data_id</th>\n",
       "      <th>swish_id</th>\n",
       "      <th>name</th>\n",
       "      <th>merge_name</th>\n",
       "      <th>completions</th>\n",
       "      <th>attempts</th>\n",
       "      <th>passing_yards</th>\n",
       "      <th>passing_tds</th>\n",
       "      <th>rushing_yards</th>\n",
       "      <th>interceptions</th>\n",
       "      <th>sacks</th>\n",
       "      <th>sack_yards</th>\n",
       "      <th>sack_fumbles</th>\n",
       "      <th>sack_fumbles_lost</th>\n",
       "      <th>passing_air_yards</th>\n",
       "      <th>passing_yards_after_catch</th>\n",
       "      <th>passing_first_downs</th>\n",
       "      <th>passing_epa</th>\n",
       "      <th>passing_2pt_conversions</th>\n",
       "      <th>pacr</th>\n",
       "      <th>dakota</th>\n",
       "      <th>player_display_name</th>\n",
       "      <th>team_abbr</th>\n",
       "      <th>avg_time_to_throw</th>\n",
       "      <th>avg_completed_air_yards</th>\n",
       "      <th>avg_intended_air_yards</th>\n",
       "      <th>avg_air_yards_differential</th>\n",
       "      <th>aggressiveness</th>\n",
       "      <th>max_completed_air_distance</th>\n",
       "      <th>avg_air_yards_to_sticks</th>\n",
       "      <th>pass_yards</th>\n",
       "      <th>pass_touchdowns</th>\n",
       "      <th>passer_rating</th>\n",
       "      <th>completion_percentage</th>\n",
       "      <th>expected_completion_percentage</th>\n",
       "      <th>completion_percentage_above_expectation</th>\n",
       "      <th>avg_air_distance</th>\n",
       "      <th>max_air_distance</th>\n",
       "      <th>player_gsis_id</th>\n",
       "      <th>player_first_name</th>\n",
       "      <th>player_last_name</th>\n",
       "      <th>player_short_name</th>\n",
       "      <th>game_type</th>\n",
       "      <th>team</th>\n",
       "      <th>opponent</th>\n",
       "      <th>pfr_player_name</th>\n",
       "      <th>pfr_player_id</th>\n",
       "      <th>passing_drops</th>\n",
       "      <th>passing_drop_pct</th>\n",
       "      <th>receiving_drop</th>\n",
       "      <th>receiving_drop_pct</th>\n",
       "      <th>passing_bad_throws</th>\n",
       "      <th>passing_bad_throw_pct</th>\n",
       "      <th>times_sacked</th>\n",
       "      <th>times_blitzed</th>\n",
       "      <th>times_hurried</th>\n",
       "      <th>times_hit</th>\n",
       "      <th>times_pressured</th>\n",
       "      <th>times_pressured_pct</th>\n",
       "      <th>def_times_blitzed</th>\n",
       "      <th>def_times_hurried</th>\n",
       "      <th>def_times_hitqb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>1</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>16</td>\n",
       "      <td>36</td>\n",
       "      <td>267.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>567.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.753902</td>\n",
       "      <td>0</td>\n",
       "      <td>0.470899</td>\n",
       "      <td>0.042110</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>3.120750</td>\n",
       "      <td>9.219375</td>\n",
       "      <td>15.085833</td>\n",
       "      <td>-5.866458</td>\n",
       "      <td>33.333333</td>\n",
       "      <td>57.983004</td>\n",
       "      <td>6.196944</td>\n",
       "      <td>267.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.023148</td>\n",
       "      <td>44.444444</td>\n",
       "      <td>53.709919</td>\n",
       "      <td>-9.265475</td>\n",
       "      <td>27.996684</td>\n",
       "      <td>59.048235</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>2</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>30</td>\n",
       "      <td>39</td>\n",
       "      <td>447.0</td>\n",
       "      <td>3</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>25.089682</td>\n",
       "      <td>0</td>\n",
       "      <td>1.590747</td>\n",
       "      <td>0.304464</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>2.301564</td>\n",
       "      <td>6.826333</td>\n",
       "      <td>7.545385</td>\n",
       "      <td>-0.719051</td>\n",
       "      <td>12.820513</td>\n",
       "      <td>45.270829</td>\n",
       "      <td>-1.095641</td>\n",
       "      <td>447.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>139.583333</td>\n",
       "      <td>76.923077</td>\n",
       "      <td>66.956657</td>\n",
       "      <td>9.966420</td>\n",
       "      <td>19.953223</td>\n",
       "      <td>45.270829</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>3</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>25</td>\n",
       "      <td>35</td>\n",
       "      <td>378.0</td>\n",
       "      <td>5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>415.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>10.521861</td>\n",
       "      <td>1</td>\n",
       "      <td>0.910843</td>\n",
       "      <td>0.240395</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>2.707400</td>\n",
       "      <td>10.840000</td>\n",
       "      <td>11.857143</td>\n",
       "      <td>-1.017143</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.057143</td>\n",
       "      <td>378.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>146.190476</td>\n",
       "      <td>71.428571</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>4</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>32</td>\n",
       "      <td>45</td>\n",
       "      <td>307.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>341.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.758528</td>\n",
       "      <td>0</td>\n",
       "      <td>0.900293</td>\n",
       "      <td>0.149092</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>2.456489</td>\n",
       "      <td>5.467500</td>\n",
       "      <td>7.515333</td>\n",
       "      <td>-2.047833</td>\n",
       "      <td>8.888889</td>\n",
       "      <td>32.986209</td>\n",
       "      <td>0.159778</td>\n",
       "      <td>307.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>104.583333</td>\n",
       "      <td>71.111111</td>\n",
       "      <td>74.774611</td>\n",
       "      <td>-3.663500</td>\n",
       "      <td>19.146993</td>\n",
       "      <td>49.445393</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>5</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>T.Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>NE</td>\n",
       "      <td>5848</td>\n",
       "      <td>41c44740-d0f6-44ab-8347-3b5d515e5ecf</td>\n",
       "      <td>9603.0</td>\n",
       "      <td>698.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>tombrady/2504211</td>\n",
       "      <td>2330.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>187741.0</td>\n",
       "      <td>BradTo00</td>\n",
       "      <td>tom-brady-1</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1163.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>4314.0</td>\n",
       "      <td>25347.0</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>tom brady</td>\n",
       "      <td>30</td>\n",
       "      <td>40</td>\n",
       "      <td>303.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>248.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2.653190</td>\n",
       "      <td>0</td>\n",
       "      <td>1.221774</td>\n",
       "      <td>0.115276</td>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>NE</td>\n",
       "      <td>2.694575</td>\n",
       "      <td>5.328000</td>\n",
       "      <td>6.224500</td>\n",
       "      <td>-0.896500</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>38.576066</td>\n",
       "      <td>-3.475500</td>\n",
       "      <td>303.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>94.062500</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>67.303628</td>\n",
       "      <td>7.696372</td>\n",
       "      <td>18.631851</td>\n",
       "      <td>38.576066</td>\n",
       "      <td>00-0019596</td>\n",
       "      <td>Tom</td>\n",
       "      <td>Brady</td>\n",
       "      <td>T.Brady</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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",
       "      <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",
       "      <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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5284</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>14</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>134.0</td>\n",
       "      <td>2</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>137.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>-6.575400</td>\n",
       "      <td>0</td>\n",
       "      <td>0.978102</td>\n",
       "      <td>0.043877</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>2.860217</td>\n",
       "      <td>4.263529</td>\n",
       "      <td>6.112609</td>\n",
       "      <td>-1.849079</td>\n",
       "      <td>8.695652</td>\n",
       "      <td>34.417414</td>\n",
       "      <td>-1.365652</td>\n",
       "      <td>134.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>116.938406</td>\n",
       "      <td>73.913043</td>\n",
       "      <td>73.322051</td>\n",
       "      <td>0.590993</td>\n",
       "      <td>20.952260</td>\n",
       "      <td>36.292903</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>REG</td>\n",
       "      <td>CHI</td>\n",
       "      <td>SF</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.043</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.087</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5285</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>15</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>18</td>\n",
       "      <td>31</td>\n",
       "      <td>191.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>235.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>-3.401174</td>\n",
       "      <td>0</td>\n",
       "      <td>0.812766</td>\n",
       "      <td>-0.006490</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>3.278581</td>\n",
       "      <td>4.203889</td>\n",
       "      <td>8.167000</td>\n",
       "      <td>-3.963111</td>\n",
       "      <td>12.903226</td>\n",
       "      <td>38.640762</td>\n",
       "      <td>-1.633000</td>\n",
       "      <td>191.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>86.895161</td>\n",
       "      <td>58.064516</td>\n",
       "      <td>62.604289</td>\n",
       "      <td>-4.539772</td>\n",
       "      <td>22.596859</td>\n",
       "      <td>46.472393</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>REG</td>\n",
       "      <td>CHI</td>\n",
       "      <td>MIN</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.167</td>\n",
       "      <td>2.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.286</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5286</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>16</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>26</td>\n",
       "      <td>40</td>\n",
       "      <td>334.0</td>\n",
       "      <td>2</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>365.0</td>\n",
       "      <td>167.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>16.464520</td>\n",
       "      <td>0</td>\n",
       "      <td>0.915069</td>\n",
       "      <td>0.163077</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>3.172625</td>\n",
       "      <td>6.116923</td>\n",
       "      <td>9.302432</td>\n",
       "      <td>-3.185509</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>42.081298</td>\n",
       "      <td>0.167297</td>\n",
       "      <td>334.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>107.708333</td>\n",
       "      <td>65.000000</td>\n",
       "      <td>61.272584</td>\n",
       "      <td>3.727416</td>\n",
       "      <td>21.701507</td>\n",
       "      <td>53.100679</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>REG</td>\n",
       "      <td>CHI</td>\n",
       "      <td>DET</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.162</td>\n",
       "      <td>2.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.174</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5287</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>17</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>16</td>\n",
       "      <td>28</td>\n",
       "      <td>122.0</td>\n",
       "      <td>0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>202.0</td>\n",
       "      <td>108.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>-10.225746</td>\n",
       "      <td>0</td>\n",
       "      <td>0.603960</td>\n",
       "      <td>-0.000481</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>2.834179</td>\n",
       "      <td>0.964375</td>\n",
       "      <td>6.360385</td>\n",
       "      <td>-5.396010</td>\n",
       "      <td>3.571429</td>\n",
       "      <td>29.989131</td>\n",
       "      <td>-3.831923</td>\n",
       "      <td>122.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.976190</td>\n",
       "      <td>57.142857</td>\n",
       "      <td>63.191599</td>\n",
       "      <td>-6.048742</td>\n",
       "      <td>20.304159</td>\n",
       "      <td>39.255328</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>REG</td>\n",
       "      <td>CHI</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.184</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5288</th>\n",
       "      <td>2024</td>\n",
       "      <td>REG</td>\n",
       "      <td>18</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>CHI</td>\n",
       "      <td>16579</td>\n",
       "      <td>49d4b627-3f19-49a8-ae33-f539e0fb1f88</td>\n",
       "      <td>23084.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4431611.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26695775.0</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>caleb-williams-3</td>\n",
       "      <td>17695.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>40900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1286445.0</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>caleb williams</td>\n",
       "      <td>21</td>\n",
       "      <td>29</td>\n",
       "      <td>148.0</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.353224</td>\n",
       "      <td>0</td>\n",
       "      <td>1.275862</td>\n",
       "      <td>0.157300</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>CHI</td>\n",
       "      <td>3.187000</td>\n",
       "      <td>1.983810</td>\n",
       "      <td>1.928261</td>\n",
       "      <td>0.055549</td>\n",
       "      <td>6.896552</td>\n",
       "      <td>28.094928</td>\n",
       "      <td>-8.332609</td>\n",
       "      <td>148.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>95.186782</td>\n",
       "      <td>72.413793</td>\n",
       "      <td>61.554118</td>\n",
       "      <td>10.859675</td>\n",
       "      <td>15.773489</td>\n",
       "      <td>28.094928</td>\n",
       "      <td>00-0039918</td>\n",
       "      <td>Caleb</td>\n",
       "      <td>Williams</td>\n",
       "      <td>C.Williams</td>\n",
       "      <td>REG</td>\n",
       "      <td>CHI</td>\n",
       "      <td>GB</td>\n",
       "      <td>Caleb Williams</td>\n",
       "      <td>WillCa03</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.043</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.043</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.188</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5289 rows × 87 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      season season_type  week   player_id player_name position position_group recent_team  mfl_id                         sportradar_id  fantasypros_id  pff_id  sleeper_id            nfl_id    espn_id  yahoo_id  fleaflicker_id      cbs_id    pfr_id         cfbref_id  rotowire_id  rotoworld_id  ktc_id  stats_id  stats_global_id  fantasy_data_id   swish_id            name      merge_name  completions  attempts  passing_yards  passing_tds  rushing_yards  interceptions  sacks  sack_yards  sack_fumbles  sack_fumbles_lost  passing_air_yards  passing_yards_after_catch  passing_first_downs  passing_epa  passing_2pt_conversions      pacr    dakota player_display_name team_abbr  avg_time_to_throw  avg_completed_air_yards  avg_intended_air_yards  avg_air_yards_differential  aggressiveness  max_completed_air_distance  avg_air_yards_to_sticks  pass_yards  pass_touchdowns  passer_rating  completion_percentage  expected_completion_percentage  completion_percentage_above_expectation  \\\n",
       "0       2017         REG     1  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           16        36          267.0            0            0.0            0.0    3.0        20.0             0                  0              567.0                      112.0                 11.0     1.753902                        0  0.470899  0.042110           Tom Brady        NE           3.120750                 9.219375               15.085833                   -5.866458       33.333333                   57.983004                 6.196944       267.0              0.0      70.023148              44.444444                       53.709919                                -9.265475   \n",
       "1       2017         REG     2  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           30        39          447.0            3            9.0            0.0    2.0        11.0             0                  0              281.0                      237.0                 19.0    25.089682                        0  1.590747  0.304464           Tom Brady        NE           2.301564                 6.826333                7.545385                   -0.719051       12.820513                   45.270829                -1.095641       447.0              3.0     139.583333              76.923077                       66.956657                                 9.966420   \n",
       "2       2017         REG     3  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           25        35          378.0            5            6.0            0.0    5.0        41.0             3                  1              415.0                      107.0                 16.0    10.521861                        1  0.910843  0.240395           Tom Brady        NE           2.707400                10.840000               11.857143                   -1.017143       20.000000                         NaN                 2.057143       378.0              5.0     146.190476              71.428571                             NaN                                      NaN   \n",
       "3       2017         REG     4  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           32        45          307.0            2            2.0            0.0    3.0        14.0             0                  0              341.0                      132.0                 18.0     9.758528                        0  0.900293  0.149092           Tom Brady        NE           2.456489                 5.467500                7.515333                   -2.047833        8.888889                   32.986209                 0.159778       307.0              2.0     104.583333              71.111111                       74.774611                                -3.663500   \n",
       "4       2017         REG     5  00-0019596     T.Brady       QB             QB          NE    5848  41c44740-d0f6-44ab-8347-3b5d515e5ecf          9603.0   698.0       167.0  tombrady/2504211     2330.0    5228.0           309.0    187741.0  BradTo00       tom-brady-1       1350.0        1163.0     NaN    5228.0          25347.0           4314.0    25347.0       Tom Brady       tom brady           30        40          303.0            1            5.0            1.0    3.0        14.0             1                  1              248.0                      130.0                 15.0     2.653190                        0  1.221774  0.115276           Tom Brady        NE           2.694575                 5.328000                6.224500                   -0.896500       10.000000                   38.576066                -3.475500       303.0              1.0      94.062500              75.000000                       67.303628                                 7.696372   \n",
       "...      ...         ...   ...         ...         ...      ...            ...         ...     ...                                   ...             ...     ...         ...               ...        ...       ...             ...         ...       ...               ...          ...           ...     ...       ...              ...              ...        ...             ...             ...          ...       ...            ...          ...            ...            ...    ...         ...           ...                ...                ...                        ...                  ...          ...                      ...       ...       ...                 ...       ...                ...                      ...                     ...                         ...             ...                         ...                      ...         ...              ...            ...                    ...                             ...                                      ...   \n",
       "5284    2024         REG    14  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           17        23          134.0            2           27.0            0.0    7.0        46.0             1                  1              137.0                       69.0                  9.0    -6.575400                        0  0.978102  0.043877      Caleb Williams       CHI           2.860217                 4.263529                6.112609                   -1.849079        8.695652                   34.417414                -1.365652       134.0              2.0     116.938406              73.913043                       73.322051                                 0.590993   \n",
       "5285    2024         REG    15  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           18        31          191.0            1            3.0            0.0    2.0        25.0             1                  1              235.0                      116.0                  8.0    -3.401174                        0  0.812766 -0.006490      Caleb Williams       CHI           3.278581                 4.203889                8.167000                   -3.963111       12.903226                   38.640762                -1.633000       191.0              1.0      86.895161              58.064516                       62.604289                                -4.539772   \n",
       "5286    2024         REG    16  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           26        40          334.0            2           34.0            0.0    2.0        11.0             0                  0              365.0                      167.0                 15.0    16.464520                        0  0.915069  0.163077      Caleb Williams       CHI           3.172625                 6.116923                9.302432                   -3.185509       20.000000                   42.081298                 0.167297       334.0              2.0     107.708333              65.000000                       61.272584                                 3.727416   \n",
       "5287    2024         REG    17  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           16        28          122.0            0           37.0            1.0    7.0        46.0             1                  0              202.0                      108.0                  7.0   -10.225746                        0  0.603960 -0.000481      Caleb Williams       CHI           2.834179                 0.964375                6.360385                   -5.396010        3.571429                   29.989131                -3.831923       122.0              0.0      52.976190              57.142857                       63.191599                                -6.048742   \n",
       "5288    2024         REG    18  00-0039918  C.Williams       QB             QB         CHI   16579  49d4b627-3f19-49a8-ae33-f539e0fb1f88         23084.0     NaN     11560.0               NaN  4431611.0   40900.0             NaN  26695775.0  WillCa03  caleb-williams-3      17695.0           NaN  1550.0   40900.0              0.0              NaN  1286445.0  Caleb Williams  caleb williams           21        29          148.0            1           10.0            0.0    1.0         7.0             1                  0              116.0                       98.0                 10.0     4.353224                        0  1.275862  0.157300      Caleb Williams       CHI           3.187000                 1.983810                1.928261                    0.055549        6.896552                   28.094928                -8.332609       148.0              1.0      95.186782              72.413793                       61.554118                                10.859675   \n",
       "\n",
       "      avg_air_distance  max_air_distance player_gsis_id player_first_name player_last_name player_short_name game_type team opponent pfr_player_name pfr_player_id  passing_drops  passing_drop_pct  receiving_drop  receiving_drop_pct  passing_bad_throws  passing_bad_throw_pct  times_sacked  times_blitzed  times_hurried  times_hit  times_pressured  times_pressured_pct  def_times_blitzed  def_times_hurried  def_times_hitqb  \n",
       "0            27.996684         59.048235     00-0019596               Tom            Brady           T.Brady       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "1            19.953223         45.270829     00-0019596               Tom            Brady           T.Brady       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "2                  NaN               NaN     00-0019596               Tom            Brady           T.Brady       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "3            19.146993         49.445393     00-0019596               Tom            Brady           T.Brady       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "4            18.631851         38.576066     00-0019596               Tom            Brady           T.Brady       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "...                ...               ...            ...               ...              ...               ...       ...  ...      ...             ...           ...            ...               ...             ...                 ...                 ...                    ...           ...            ...            ...        ...              ...                  ...                ...                ...              ...  \n",
       "5284         20.952260         36.292903     00-0039918             Caleb         Williams        C.Williams       REG  CHI       SF  Caleb Williams      WillCa03            1.0             0.043             NaN                 NaN                 2.0                  0.087           7.0            3.0            0.0        1.0              8.0                0.250                NaN                NaN              NaN  \n",
       "5285         22.596859         46.472393     00-0039918             Caleb         Williams        C.Williams       REG  CHI      MIN  Caleb Williams      WillCa03            3.0             0.100             NaN                 NaN                 5.0                  0.167           2.0           15.0            7.0        1.0             10.0                0.286                NaN                NaN              NaN  \n",
       "5286         21.701507         53.100679     00-0039918             Caleb         Williams        C.Williams       REG  CHI      DET  Caleb Williams      WillCa03            0.0             0.000             NaN                 NaN                 6.0                  0.162           2.0           19.0            3.0        3.0              8.0                0.174                NaN                NaN              NaN  \n",
       "5287         20.304159         39.255328     00-0039918             Caleb         Williams        C.Williams       REG  CHI      SEA  Caleb Williams      WillCa03            0.0             0.000             NaN                 NaN                 0.0                  0.000           7.0            0.0            0.0        0.0              7.0                0.184                NaN                NaN              NaN  \n",
       "5288         15.773489         28.094928     00-0039918             Caleb         Williams        C.Williams       REG  CHI       GB  Caleb Williams      WillCa03            1.0             0.043             NaN                 NaN                 1.0                  0.043           1.0            3.0            4.0        1.0              6.0                0.188                NaN                NaN              NaN  \n",
       "\n",
       "[5289 rows x 87 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Output: a dataframe of NFL QB info, ids, weekly stats, next-gen stats, and pro-football reference data\n",
    "# NOTE: unbalanced dataframe - PFR stats start at 2018\n",
    "\n",
    "# Merge the pfr_pass_df with the qb_ids_ngs_weekly_stats dataframe\n",
    "qb_ids_ngs_pfr_stats = pd.merge(\n",
    "    qb_ids_ngs_weekly_stats,\n",
    "    pfr_pass_df,  # Use the full PFR dataframe as position data is unavailable\n",
    "    left_on=['pfr_id', 'season', 'week'],  # Keys from qb_ids_ngs_weekly_stats\n",
    "    right_on=['pfr_player_id', 'season', 'week'],  # Keys from pfr_pass_df\n",
    "    how='left'  # Retain all rows from qb_ids_ngs_weekly_stats\n",
    ")\n",
    "\n",
    "# Display the shape of the resulting dataframe\n",
    "print(f\"Shape of merged dataframe: {qb_ids_ngs_pfr_stats.shape}\")\n",
    "\n",
    "# Row integrity check\n",
    "print(\n",
    "    f\"Row count matches: {qb_ids_weekly_stats.shape[0] == qb_ids_ngs_weekly_stats.shape[0] == qb_ids_ngs_pfr_stats.shape[0]}\"\n",
    ")\n",
    "\n",
    "# Display the first few rows of the merged dataframe for review\n",
    "display(qb_ids_ngs_pfr_stats)\n",
    "\n",
    "# Save the dataframe to a CSV file\n",
    "# qb_ids_ngs_pfr_stats.to_csv('qb_ids_ngs_pfr_stats.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3e5d519d-98f9-4dfb-9293-5d5b59b69010",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "ba6425e5-a1a0-4b7c-8340-5896c5bf4d7f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of merged dataframe: (5289, 87)\n",
      "Row count matches: True\n",
      "Dataframe sorted by season, week, and passing_yards:\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>season</th>\n",
       "      <th>season_type</th>\n",
       "      <th>week</th>\n",
       "      <th>player_id</th>\n",
       "      <th>player_name</th>\n",
       "      <th>position</th>\n",
       "      <th>position_group</th>\n",
       "      <th>recent_team</th>\n",
       "      <th>mfl_id</th>\n",
       "      <th>sportradar_id</th>\n",
       "      <th>fantasypros_id</th>\n",
       "      <th>pff_id</th>\n",
       "      <th>sleeper_id</th>\n",
       "      <th>nfl_id</th>\n",
       "      <th>espn_id</th>\n",
       "      <th>yahoo_id</th>\n",
       "      <th>fleaflicker_id</th>\n",
       "      <th>cbs_id</th>\n",
       "      <th>pfr_id</th>\n",
       "      <th>cfbref_id</th>\n",
       "      <th>rotowire_id</th>\n",
       "      <th>rotoworld_id</th>\n",
       "      <th>ktc_id</th>\n",
       "      <th>stats_id</th>\n",
       "      <th>stats_global_id</th>\n",
       "      <th>fantasy_data_id</th>\n",
       "      <th>swish_id</th>\n",
       "      <th>name</th>\n",
       "      <th>merge_name</th>\n",
       "      <th>completions</th>\n",
       "      <th>attempts</th>\n",
       "      <th>passing_yards</th>\n",
       "      <th>passing_tds</th>\n",
       "      <th>rushing_yards</th>\n",
       "      <th>interceptions</th>\n",
       "      <th>sacks</th>\n",
       "      <th>sack_yards</th>\n",
       "      <th>sack_fumbles</th>\n",
       "      <th>sack_fumbles_lost</th>\n",
       "      <th>passing_air_yards</th>\n",
       "      <th>passing_yards_after_catch</th>\n",
       "      <th>passing_first_downs</th>\n",
       "      <th>passing_epa</th>\n",
       "      <th>passing_2pt_conversions</th>\n",
       "      <th>pacr</th>\n",
       "      <th>dakota</th>\n",
       "      <th>player_display_name</th>\n",
       "      <th>team_abbr</th>\n",
       "      <th>avg_time_to_throw</th>\n",
       "      <th>avg_completed_air_yards</th>\n",
       "      <th>avg_intended_air_yards</th>\n",
       "      <th>avg_air_yards_differential</th>\n",
       "      <th>aggressiveness</th>\n",
       "      <th>max_completed_air_distance</th>\n",
       "      <th>avg_air_yards_to_sticks</th>\n",
       "      <th>pass_yards</th>\n",
       "      <th>pass_touchdowns</th>\n",
       "      <th>passer_rating</th>\n",
       "      <th>completion_percentage</th>\n",
       "      <th>expected_completion_percentage</th>\n",
       "      <th>completion_percentage_above_expectation</th>\n",
       "      <th>avg_air_distance</th>\n",
       "      <th>max_air_distance</th>\n",
       "      <th>player_gsis_id</th>\n",
       "      <th>player_first_name</th>\n",
       "      <th>player_last_name</th>\n",
       "      <th>player_short_name</th>\n",
       "      <th>game_type</th>\n",
       "      <th>team</th>\n",
       "      <th>opponent</th>\n",
       "      <th>pfr_player_name</th>\n",
       "      <th>pfr_player_id</th>\n",
       "      <th>passing_drops</th>\n",
       "      <th>passing_drop_pct</th>\n",
       "      <th>receiving_drop</th>\n",
       "      <th>receiving_drop_pct</th>\n",
       "      <th>passing_bad_throws</th>\n",
       "      <th>passing_bad_throw_pct</th>\n",
       "      <th>times_sacked</th>\n",
       "      <th>times_blitzed</th>\n",
       "      <th>times_hurried</th>\n",
       "      <th>times_hit</th>\n",
       "      <th>times_pressured</th>\n",
       "      <th>times_pressured_pct</th>\n",
       "      <th>def_times_blitzed</th>\n",
       "      <th>def_times_hurried</th>\n",
       "      <th>def_times_hitqb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>1</td>\n",
       "      <td>00-0023436</td>\n",
       "      <td>A.Smith</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>KC</td>\n",
       "      <td>7813</td>\n",
       "      <td>2fda010a-8c62-4c07-b601-4ba03f57e6af</td>\n",
       "      <td>9012.0</td>\n",
       "      <td>2218.0</td>\n",
       "      <td>268.0</td>\n",
       "      <td>alexsmith/2506340</td>\n",
       "      <td>8416.0</td>\n",
       "      <td>7177.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>552642.0</td>\n",
       "      <td>SmitAl03</td>\n",
       "      <td>alex-smith-3</td>\n",
       "      <td>4306.0</td>\n",
       "      <td>3119.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7177.0</td>\n",
       "      <td>217357.0</td>\n",
       "      <td>6739.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alex Smith</td>\n",
       "      <td>alex smith</td>\n",
       "      <td>28</td>\n",
       "      <td>35</td>\n",
       "      <td>368.0</td>\n",
       "      <td>4</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>17.560724</td>\n",
       "      <td>0</td>\n",
       "      <td>1.415385</td>\n",
       "      <td>0.300653</td>\n",
       "      <td>Alex Smith</td>\n",
       "      <td>KC</td>\n",
       "      <td>3.023914</td>\n",
       "      <td>5.651429</td>\n",
       "      <td>7.390571</td>\n",
       "      <td>-1.739143</td>\n",
       "      <td>14.285714</td>\n",
       "      <td>51.773205</td>\n",
       "      <td>-0.580857</td>\n",
       "      <td>368.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>148.571429</td>\n",
       "      <td>80.000000</td>\n",
       "      <td>70.111395</td>\n",
       "      <td>9.888605</td>\n",
       "      <td>18.876969</td>\n",
       "      <td>51.773205</td>\n",
       "      <td>00-0023436</td>\n",
       "      <td>Alexander</td>\n",
       "      <td>Smith</td>\n",
       "      <td>A.Smith</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>1</td>\n",
       "      <td>00-0027854</td>\n",
       "      <td>S.Bradford</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>MIN</td>\n",
       "      <td>9817</td>\n",
       "      <td>cc3640b0-7560-431f-84ab-599e9dc8cac6</td>\n",
       "      <td>9678.0</td>\n",
       "      <td>5526.0</td>\n",
       "      <td>621.0</td>\n",
       "      <td>sambradford/497095</td>\n",
       "      <td>13197.0</td>\n",
       "      <td>23976.0</td>\n",
       "      <td>6558.0</td>\n",
       "      <td>1123599.0</td>\n",
       "      <td>BradSa00</td>\n",
       "      <td>sam-bradford-1</td>\n",
       "      <td>6452.0</td>\n",
       "      <td>5161.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23976.0</td>\n",
       "      <td>333276.0</td>\n",
       "      <td>11527.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sam Bradford</td>\n",
       "      <td>sam bradford</td>\n",
       "      <td>27</td>\n",
       "      <td>32</td>\n",
       "      <td>346.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>239.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>21.096104</td>\n",
       "      <td>0</td>\n",
       "      <td>1.447699</td>\n",
       "      <td>0.349325</td>\n",
       "      <td>Sam Bradford</td>\n",
       "      <td>MIN</td>\n",
       "      <td>2.568281</td>\n",
       "      <td>8.178519</td>\n",
       "      <td>7.892500</td>\n",
       "      <td>0.286019</td>\n",
       "      <td>18.750000</td>\n",
       "      <td>48.379334</td>\n",
       "      <td>-0.232500</td>\n",
       "      <td>346.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>142.968750</td>\n",
       "      <td>84.375000</td>\n",
       "      <td>59.131884</td>\n",
       "      <td>25.243116</td>\n",
       "      <td>20.657261</td>\n",
       "      <td>48.379334</td>\n",
       "      <td>00-0027854</td>\n",
       "      <td>Samuel</td>\n",
       "      <td>Bradford</td>\n",
       "      <td>S.Bradford</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>1</td>\n",
       "      <td>00-0026143</td>\n",
       "      <td>M.Ryan</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>ATL</td>\n",
       "      <td>9099</td>\n",
       "      <td>7e648a0b-fdc8-4661-a587-5826f2cac11b</td>\n",
       "      <td>9444.0</td>\n",
       "      <td>4317.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>mattryan/310</td>\n",
       "      <td>11237.0</td>\n",
       "      <td>8780.0</td>\n",
       "      <td>5371.0</td>\n",
       "      <td>420095.0</td>\n",
       "      <td>RyanMa00</td>\n",
       "      <td>matt-ryan-1</td>\n",
       "      <td>5610.0</td>\n",
       "      <td>4637.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8780.0</td>\n",
       "      <td>216263.0</td>\n",
       "      <td>732.0</td>\n",
       "      <td>216263.0</td>\n",
       "      <td>Matt Ryan</td>\n",
       "      <td>matt ryan</td>\n",
       "      <td>21</td>\n",
       "      <td>30</td>\n",
       "      <td>321.0</td>\n",
       "      <td>1</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>13.515724</td>\n",
       "      <td>0</td>\n",
       "      <td>1.486111</td>\n",
       "      <td>0.257653</td>\n",
       "      <td>Matt Ryan</td>\n",
       "      <td>ATL</td>\n",
       "      <td>2.577133</td>\n",
       "      <td>7.064286</td>\n",
       "      <td>7.096667</td>\n",
       "      <td>-0.032381</td>\n",
       "      <td>26.666667</td>\n",
       "      <td>39.611728</td>\n",
       "      <td>-1.936667</td>\n",
       "      <td>321.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>116.111111</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>60.505824</td>\n",
       "      <td>9.494176</td>\n",
       "      <td>19.851132</td>\n",
       "      <td>41.219875</td>\n",
       "      <td>00-0026143</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>Ryan</td>\n",
       "      <td>M.Ryan</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>1</td>\n",
       "      <td>00-0023459</td>\n",
       "      <td>A.Rodgers</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>GB</td>\n",
       "      <td>7836</td>\n",
       "      <td>0ce48193-e2fa-466e-a986-33f751add206</td>\n",
       "      <td>9001.0</td>\n",
       "      <td>2241.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>aaronrodgers/2506363</td>\n",
       "      <td>8439.0</td>\n",
       "      <td>7200.0</td>\n",
       "      <td>3452.0</td>\n",
       "      <td>419780.0</td>\n",
       "      <td>RodgAa00</td>\n",
       "      <td>aaron-rodgers-1</td>\n",
       "      <td>4307.0</td>\n",
       "      <td>3118.0</td>\n",
       "      <td>235.0</td>\n",
       "      <td>7200.0</td>\n",
       "      <td>213957.0</td>\n",
       "      <td>2593.0</td>\n",
       "      <td>213957.0</td>\n",
       "      <td>Aaron Rodgers</td>\n",
       "      <td>aaron rodgers</td>\n",
       "      <td>28</td>\n",
       "      <td>42</td>\n",
       "      <td>311.0</td>\n",
       "      <td>1</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>289.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.171718</td>\n",
       "      <td>0</td>\n",
       "      <td>1.076125</td>\n",
       "      <td>0.098124</td>\n",
       "      <td>Aaron Rodgers</td>\n",
       "      <td>GB</td>\n",
       "      <td>2.997238</td>\n",
       "      <td>4.837857</td>\n",
       "      <td>7.115238</td>\n",
       "      <td>-2.277381</td>\n",
       "      <td>19.047619</td>\n",
       "      <td>39.088602</td>\n",
       "      <td>-2.480000</td>\n",
       "      <td>311.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>86.507937</td>\n",
       "      <td>66.666667</td>\n",
       "      <td>63.435491</td>\n",
       "      <td>3.231176</td>\n",
       "      <td>21.338579</td>\n",
       "      <td>48.441297</td>\n",
       "      <td>00-0023459</td>\n",
       "      <td>Aaron</td>\n",
       "      <td>Rodgers</td>\n",
       "      <td>A.Rodgers</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>2017</td>\n",
       "      <td>REG</td>\n",
       "      <td>1</td>\n",
       "      <td>00-0032950</td>\n",
       "      <td>C.Wentz</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>PHI</td>\n",
       "      <td>12610</td>\n",
       "      <td>e9a5c16b-4472-4be9-8030-3f77be7890cb</td>\n",
       "      <td>15520.0</td>\n",
       "      <td>10636.0</td>\n",
       "      <td>3161.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2573079.0</td>\n",
       "      <td>29236.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1907522.0</td>\n",
       "      <td>WentCa00</td>\n",
       "      <td>carson-wentz-1</td>\n",
       "      <td>10856.0</td>\n",
       "      <td>11257.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29236.0</td>\n",
       "      <td>613866.0</td>\n",
       "      <td>17920.0</td>\n",
       "      <td>613866.0</td>\n",
       "      <td>Carson Wentz</td>\n",
       "      <td>carson wentz</td>\n",
       "      <td>26</td>\n",
       "      <td>39</td>\n",
       "      <td>307.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>8.479346</td>\n",
       "      <td>1</td>\n",
       "      <td>0.765586</td>\n",
       "      <td>0.119461</td>\n",
       "      <td>Carson Wentz</td>\n",
       "      <td>PHI</td>\n",
       "      <td>2.944949</td>\n",
       "      <td>6.493462</td>\n",
       "      <td>10.586667</td>\n",
       "      <td>-4.093205</td>\n",
       "      <td>15.384615</td>\n",
       "      <td>43.672102</td>\n",
       "      <td>1.022564</td>\n",
       "      <td>307.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>96.848291</td>\n",
       "      <td>66.666667</td>\n",
       "      <td>59.235665</td>\n",
       "      <td>7.431002</td>\n",
       "      <td>23.047144</td>\n",
       "      <td>60.306328</td>\n",
       "      <td>00-0032950</td>\n",
       "      <td>Carson</td>\n",
       "      <td>Wentz</td>\n",
       "      <td>C.Wentz</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <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",
       "      <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",
       "      <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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5266</th>\n",
       "      <td>2024</td>\n",
       "      <td>POST</td>\n",
       "      <td>20</td>\n",
       "      <td>00-0039910</td>\n",
       "      <td>J.Daniels</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>WAS</td>\n",
       "      <td>16581</td>\n",
       "      <td>bab8c65a-9fff-410d-8e34-dc2f636d890e</td>\n",
       "      <td>22902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11566.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4426348.0</td>\n",
       "      <td>40896.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3123337.0</td>\n",
       "      <td>DaniJa02</td>\n",
       "      <td>jayden-daniels-1</td>\n",
       "      <td>17692.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1552.0</td>\n",
       "      <td>40896.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1161228.0</td>\n",
       "      <td>Jayden Daniels</td>\n",
       "      <td>jayden daniels</td>\n",
       "      <td>22</td>\n",
       "      <td>31</td>\n",
       "      <td>299.0</td>\n",
       "      <td>2</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>19.172676</td>\n",
       "      <td>0</td>\n",
       "      <td>1.661111</td>\n",
       "      <td>0.234313</td>\n",
       "      <td>Jayden Daniels</td>\n",
       "      <td>WAS</td>\n",
       "      <td>2.472742</td>\n",
       "      <td>4.951818</td>\n",
       "      <td>5.642069</td>\n",
       "      <td>-0.690251</td>\n",
       "      <td>9.677419</td>\n",
       "      <td>48.299591</td>\n",
       "      <td>-1.737241</td>\n",
       "      <td>299.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>122.916667</td>\n",
       "      <td>70.967742</td>\n",
       "      <td>70.779632</td>\n",
       "      <td>0.188110</td>\n",
       "      <td>19.847636</td>\n",
       "      <td>48.299591</td>\n",
       "      <td>00-0039910</td>\n",
       "      <td>Jayden</td>\n",
       "      <td>Daniels</td>\n",
       "      <td>J.Daniels</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5197</th>\n",
       "      <td>2024</td>\n",
       "      <td>POST</td>\n",
       "      <td>20</td>\n",
       "      <td>00-0039163</td>\n",
       "      <td>C.Stroud</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>HOU</td>\n",
       "      <td>16150</td>\n",
       "      <td>7e91086f-9ca4-4bd9-a099-b88b2f37e6c6</td>\n",
       "      <td>23071.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9758.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4432577.0</td>\n",
       "      <td>40030.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3163079.0</td>\n",
       "      <td>StroCJ00</td>\n",
       "      <td>cj-stroud-1</td>\n",
       "      <td>16886.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1403.0</td>\n",
       "      <td>40030.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1214084.0</td>\n",
       "      <td>C.J. Stroud</td>\n",
       "      <td>cj stroud</td>\n",
       "      <td>19</td>\n",
       "      <td>28</td>\n",
       "      <td>245.0</td>\n",
       "      <td>0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.970950</td>\n",
       "      <td>0</td>\n",
       "      <td>0.907407</td>\n",
       "      <td>0.101948</td>\n",
       "      <td>C.J. Stroud</td>\n",
       "      <td>HOU</td>\n",
       "      <td>2.951321</td>\n",
       "      <td>9.506316</td>\n",
       "      <td>9.137500</td>\n",
       "      <td>0.368816</td>\n",
       "      <td>28.571429</td>\n",
       "      <td>35.346520</td>\n",
       "      <td>0.708929</td>\n",
       "      <td>245.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>95.089286</td>\n",
       "      <td>67.857143</td>\n",
       "      <td>61.638141</td>\n",
       "      <td>6.219002</td>\n",
       "      <td>20.664023</td>\n",
       "      <td>35.346520</td>\n",
       "      <td>00-0039163</td>\n",
       "      <td>Coleridge</td>\n",
       "      <td>Stroud</td>\n",
       "      <td>C.Stroud</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4818</th>\n",
       "      <td>2024</td>\n",
       "      <td>POST</td>\n",
       "      <td>20</td>\n",
       "      <td>00-0033873</td>\n",
       "      <td>P.Mahomes</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>KC</td>\n",
       "      <td>13116</td>\n",
       "      <td>11cad59d-90dd-449c-a839-dddaba4fe16c</td>\n",
       "      <td>16413.0</td>\n",
       "      <td>11765.0</td>\n",
       "      <td>4046.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3139477.0</td>\n",
       "      <td>30123.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2142052.0</td>\n",
       "      <td>MahoPa00</td>\n",
       "      <td>patrick-mahomes-1</td>\n",
       "      <td>11839.0</td>\n",
       "      <td>12142.0</td>\n",
       "      <td>272.0</td>\n",
       "      <td>30123.0</td>\n",
       "      <td>839031.0</td>\n",
       "      <td>18890.0</td>\n",
       "      <td>839031.0</td>\n",
       "      <td>Patrick Mahomes</td>\n",
       "      <td>patrick mahomes</td>\n",
       "      <td>16</td>\n",
       "      <td>25</td>\n",
       "      <td>177.0</td>\n",
       "      <td>1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>-0.542988</td>\n",
       "      <td>0</td>\n",
       "      <td>1.187919</td>\n",
       "      <td>0.079145</td>\n",
       "      <td>Patrick Mahomes</td>\n",
       "      <td>KC</td>\n",
       "      <td>2.616160</td>\n",
       "      <td>4.476875</td>\n",
       "      <td>6.087917</td>\n",
       "      <td>-1.611042</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>34.660123</td>\n",
       "      <td>-3.120417</td>\n",
       "      <td>177.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>98.250000</td>\n",
       "      <td>64.000000</td>\n",
       "      <td>64.416556</td>\n",
       "      <td>-0.416556</td>\n",
       "      <td>18.482824</td>\n",
       "      <td>52.013423</td>\n",
       "      <td>00-0033873</td>\n",
       "      <td>Patrick</td>\n",
       "      <td>Mahomes</td>\n",
       "      <td>P.Mahomes</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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4700</th>\n",
       "      <td>2024</td>\n",
       "      <td>POST</td>\n",
       "      <td>20</td>\n",
       "      <td>00-0031237</td>\n",
       "      <td>T.Bridgewater</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>DET</td>\n",
       "      <td>11640</td>\n",
       "      <td>d4cb52a9-f6b4-42ed-b40b-27bff5f1eea7</td>\n",
       "      <td>12088.0</td>\n",
       "      <td>8667.0</td>\n",
       "      <td>2152.0</td>\n",
       "      <td>teddybridgewater/2543465</td>\n",
       "      <td>16728.0</td>\n",
       "      <td>27560.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1825122.0</td>\n",
       "      <td>BridTe00</td>\n",
       "      <td>teddy-bridgewater-1</td>\n",
       "      <td>9245.0</td>\n",
       "      <td>9274.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27560.0</td>\n",
       "      <td>592195.0</td>\n",
       "      <td>16497.0</td>\n",
       "      <td>592195.0</td>\n",
       "      <td>Teddy Bridgewater</td>\n",
       "      <td>teddy bridgewater</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.131952</td>\n",
       "      <td>0</td>\n",
       "      <td>1.000000</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",
       "      <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",
       "      <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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4731</th>\n",
       "      <td>2024</td>\n",
       "      <td>POST</td>\n",
       "      <td>20</td>\n",
       "      <td>00-0032268</td>\n",
       "      <td>M.Mariota</td>\n",
       "      <td>QB</td>\n",
       "      <td>QB</td>\n",
       "      <td>WAS</td>\n",
       "      <td>12141</td>\n",
       "      <td>7c16c04c-04de-41f3-ac16-ad6a9435e3f7</td>\n",
       "      <td>13890.0</td>\n",
       "      <td>9435.0</td>\n",
       "      <td>2307.0</td>\n",
       "      <td>marcusmariota/2552466</td>\n",
       "      <td>2576980.0</td>\n",
       "      <td>28390.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1880862.0</td>\n",
       "      <td>MariMa01</td>\n",
       "      <td>marcus-mariota-1</td>\n",
       "      <td>10074.0</td>\n",
       "      <td>9385.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28390.0</td>\n",
       "      <td>607843.0</td>\n",
       "      <td>16763.0</td>\n",
       "      <td>607843.0</td>\n",
       "      <td>Marcus Mariota</td>\n",
       "      <td>marcus mariota</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</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",
       "      <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",
       "      <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",
       "      <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",
       "      <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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5289 rows × 87 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      season season_type  week   player_id    player_name position position_group recent_team  mfl_id                         sportradar_id  fantasypros_id   pff_id  sleeper_id                    nfl_id    espn_id  yahoo_id  fleaflicker_id     cbs_id    pfr_id            cfbref_id  rotowire_id  rotoworld_id  ktc_id  stats_id  stats_global_id  fantasy_data_id   swish_id               name         merge_name  completions  attempts  passing_yards  passing_tds  rushing_yards  interceptions  sacks  sack_yards  sack_fumbles  sack_fumbles_lost  passing_air_yards  passing_yards_after_catch  passing_first_downs  passing_epa  passing_2pt_conversions      pacr    dakota player_display_name team_abbr  avg_time_to_throw  avg_completed_air_yards  avg_intended_air_yards  avg_air_yards_differential  aggressiveness  max_completed_air_distance  avg_air_yards_to_sticks  pass_yards  pass_touchdowns  passer_rating  completion_percentage  expected_completion_percentage  \\\n",
       "104     2017         REG     1  00-0023436        A.Smith       QB             QB          KC    7813  2fda010a-8c62-4c07-b601-4ba03f57e6af          9012.0   2218.0       268.0         alexsmith/2506340     8416.0    7177.0             NaN   552642.0  SmitAl03         alex-smith-3       4306.0        3119.0     NaN    7177.0         217357.0           6739.0        NaN         Alex Smith         alex smith           28        35          368.0            4            3.0            0.0    3.0        16.0             0                  0              260.0                      201.0                 17.0    17.560724                        0  1.415385  0.300653          Alex Smith        KC           3.023914                 5.651429                7.390571                   -1.739143       14.285714                   51.773205                -0.580857       368.0              4.0     148.571429              80.000000                       70.111395   \n",
       "231     2017         REG     1  00-0027854     S.Bradford       QB             QB         MIN    9817  cc3640b0-7560-431f-84ab-599e9dc8cac6          9678.0   5526.0       621.0        sambradford/497095    13197.0   23976.0          6558.0  1123599.0  BradSa00       sam-bradford-1       6452.0        5161.0     NaN   23976.0         333276.0          11527.0        NaN       Sam Bradford       sam bradford           27        32          346.0            3           -3.0            0.0    1.0         5.0             0                  0              239.0                      136.0                 14.0    21.096104                        0  1.447699  0.349325        Sam Bradford       MIN           2.568281                 8.178519                7.892500                    0.286019       18.750000                   48.379334                -0.232500       346.0              3.0     142.968750              84.375000                       59.131884   \n",
       "165     2017         REG     1  00-0026143         M.Ryan       QB             QB         ATL    9099  7e648a0b-fdc8-4661-a587-5826f2cac11b          9444.0   4317.0        24.0              mattryan/310    11237.0    8780.0          5371.0   420095.0  RyanMa00          matt-ryan-1       5610.0        4637.0     NaN    8780.0         216263.0            732.0   216263.0          Matt Ryan          matt ryan           21        30          321.0            1           11.0            0.0    2.0        13.0             0                  0              216.0                      158.0                 12.0    13.515724                        0  1.486111  0.257653           Matt Ryan       ATL           2.577133                 7.064286                7.096667                   -0.032381       26.666667                   39.611728                -1.936667       321.0              1.0     116.111111              70.000000                       60.505824   \n",
       "120     2017         REG     1  00-0023459      A.Rodgers       QB             QB          GB    7836  0ce48193-e2fa-466e-a986-33f751add206          9001.0   2241.0        96.0      aaronrodgers/2506363     8439.0    7200.0          3452.0   419780.0  RodgAa00      aaron-rodgers-1       4307.0        3118.0   235.0    7200.0         213957.0           2593.0   213957.0      Aaron Rodgers      aaron rodgers           28        42          311.0            1           21.0            1.0    4.0        25.0             0                  0              289.0                      170.0                 16.0     2.171718                        0  1.076125  0.098124       Aaron Rodgers        GB           2.997238                 4.837857                7.115238                   -2.277381       19.047619                   39.088602                -2.480000       311.0              1.0      86.507937              66.666667                       63.435491   \n",
       "494     2017         REG     1  00-0032950        C.Wentz       QB             QB         PHI   12610  e9a5c16b-4472-4be9-8030-3f77be7890cb         15520.0  10636.0      3161.0                       NaN  2573079.0   29236.0             NaN  1907522.0  WentCa00       carson-wentz-1      10856.0       11257.0     NaN   29236.0         613866.0          17920.0   613866.0       Carson Wentz       carson wentz           26        39          307.0            2            6.0            1.0    2.0         9.0             0                  0              401.0                      140.0                 17.0     8.479346                        1  0.765586  0.119461        Carson Wentz       PHI           2.944949                 6.493462               10.586667                   -4.093205       15.384615                   43.672102                 1.022564       307.0              2.0      96.848291              66.666667                       59.235665   \n",
       "...      ...         ...   ...         ...            ...      ...            ...         ...     ...                                   ...             ...      ...         ...                       ...        ...       ...             ...        ...       ...                  ...          ...           ...     ...       ...              ...              ...        ...                ...                ...          ...       ...            ...          ...            ...            ...    ...         ...           ...                ...                ...                        ...                  ...          ...                      ...       ...       ...                 ...       ...                ...                      ...                     ...                         ...             ...                         ...                      ...         ...              ...            ...                    ...                             ...   \n",
       "5266    2024        POST    20  00-0039910      J.Daniels       QB             QB         WAS   16581  bab8c65a-9fff-410d-8e34-dc2f636d890e         22902.0      NaN     11566.0                       NaN  4426348.0   40896.0             NaN  3123337.0  DaniJa02     jayden-daniels-1      17692.0           NaN  1552.0   40896.0              0.0              NaN  1161228.0     Jayden Daniels     jayden daniels           22        31          299.0            2           51.0            0.0    0.0        -0.0             0                  0              180.0                      188.0                 12.0    19.172676                        0  1.661111  0.234313      Jayden Daniels       WAS           2.472742                 4.951818                5.642069                   -0.690251        9.677419                   48.299591                -1.737241       299.0              2.0     122.916667              70.967742                       70.779632   \n",
       "5197    2024        POST    20  00-0039163       C.Stroud       QB             QB         HOU   16150  7e91086f-9ca4-4bd9-a099-b88b2f37e6c6         23071.0      NaN      9758.0                       NaN  4432577.0   40030.0             NaN  3163079.0  StroCJ00          cj-stroud-1      16886.0           NaN  1403.0   40030.0              0.0              NaN  1214084.0        C.J. Stroud          cj stroud           19        28          245.0            0           42.0            0.0    8.0        58.0             1                  0              270.0                       60.0                 12.0     0.970950                        0  0.907407  0.101948         C.J. Stroud       HOU           2.951321                 9.506316                9.137500                    0.368816       28.571429                   35.346520                 0.708929       245.0              0.0      95.089286              67.857143                       61.638141   \n",
       "4818    2024        POST    20  00-0033873      P.Mahomes       QB             QB          KC   13116  11cad59d-90dd-449c-a839-dddaba4fe16c         16413.0  11765.0      4046.0                       NaN  3139477.0   30123.0             NaN  2142052.0  MahoPa00    patrick-mahomes-1      11839.0       12142.0   272.0   30123.0         839031.0          18890.0   839031.0    Patrick Mahomes    patrick mahomes           16        25          177.0            1           14.0            0.0    3.0        15.0             0                  0              149.0                       98.0                  7.0    -0.542988                        0  1.187919  0.079145     Patrick Mahomes        KC           2.616160                 4.476875                6.087917                   -1.611042       12.000000                   34.660123                -3.120417       177.0              1.0      98.250000              64.000000                       64.416556   \n",
       "4700    2024        POST    20  00-0031237  T.Bridgewater       QB             QB         DET   11640  d4cb52a9-f6b4-42ed-b40b-27bff5f1eea7         12088.0   8667.0      2152.0  teddybridgewater/2543465    16728.0   27560.0             NaN  1825122.0  BridTe00  teddy-bridgewater-1       9245.0        9274.0     NaN   27560.0         592195.0          16497.0   592195.0  Teddy Bridgewater  teddy bridgewater            1         1            3.0            0            0.0            0.0    0.0        -0.0             0                  0                3.0                        0.0                  1.0    -0.131952                        0  1.000000       NaN                 NaN       NaN                NaN                      NaN                     NaN                         NaN             NaN                         NaN                      NaN         NaN              NaN            NaN                    NaN                             NaN   \n",
       "4731    2024        POST    20  00-0032268      M.Mariota       QB             QB         WAS   12141  7c16c04c-04de-41f3-ac16-ad6a9435e3f7         13890.0   9435.0      2307.0     marcusmariota/2552466  2576980.0   28390.0             NaN  1880862.0  MariMa01     marcus-mariota-1      10074.0        9385.0     NaN   28390.0         607843.0          16763.0   607843.0     Marcus Mariota     marcus mariota            0         0            0.0            0           -1.0            0.0    0.0         0.0             0                  0                0.0                        0.0                  0.0          NaN                        0       NaN       NaN                 NaN       NaN                NaN                      NaN                     NaN                         NaN             NaN                         NaN                      NaN         NaN              NaN            NaN                    NaN                             NaN   \n",
       "\n",
       "      completion_percentage_above_expectation  avg_air_distance  max_air_distance player_gsis_id player_first_name player_last_name player_short_name game_type team opponent pfr_player_name pfr_player_id  passing_drops  passing_drop_pct  receiving_drop  receiving_drop_pct  passing_bad_throws  passing_bad_throw_pct  times_sacked  times_blitzed  times_hurried  times_hit  times_pressured  times_pressured_pct  def_times_blitzed  def_times_hurried  def_times_hitqb  \n",
       "104                                  9.888605         18.876969         51.773205     00-0023436         Alexander            Smith           A.Smith       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "231                                 25.243116         20.657261         48.379334     00-0027854            Samuel         Bradford        S.Bradford       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "165                                  9.494176         19.851132         41.219875     00-0026143           Matthew             Ryan            M.Ryan       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "120                                  3.231176         21.338579         48.441297     00-0023459             Aaron          Rodgers         A.Rodgers       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "494                                  7.431002         23.047144         60.306328     00-0032950            Carson            Wentz           C.Wentz       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "...                                       ...               ...               ...            ...               ...              ...               ...       ...  ...      ...             ...           ...            ...               ...             ...                 ...                 ...                    ...           ...            ...            ...        ...              ...                  ...                ...                ...              ...  \n",
       "5266                                 0.188110         19.847636         48.299591     00-0039910            Jayden          Daniels         J.Daniels       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "5197                                 6.219002         20.664023         35.346520     00-0039163         Coleridge           Stroud          C.Stroud       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "4818                                -0.416556         18.482824         52.013423     00-0033873           Patrick          Mahomes         P.Mahomes       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "4700                                      NaN               NaN               NaN            NaN               NaN              NaN               NaN       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "4731                                      NaN               NaN               NaN            NaN               NaN              NaN               NaN       NaN  NaN      NaN             NaN           NaN            NaN               NaN             NaN                 NaN                 NaN                    NaN           NaN            NaN            NaN        NaN              NaN                  NaN                NaN                NaN              NaN  \n",
       "\n",
       "[5289 rows x 87 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Output: a dataframe of NFL QB info, ids, weekly stats, next-gen stats, and pro-football reference data\n",
    "# Output: Ordered the df by year, week, and passing yards\n",
    "# NOTE: unbalanced dataframe - PFR stats start at 2018\n",
    "\n",
    "# Order the dataframe by season (year), week, and passing_yards\n",
    "qb_ids_ngs_pfr_stats_sorted = qb_ids_ngs_pfr_stats.sort_values(\n",
    "    by=['season', 'week', 'passing_yards'], \n",
    "    ascending=[True, True, False]  # Ascending for season and week, descending for passing_yards\n",
    ")\n",
    "\n",
    "# Display the shape of the resulting dataframe\n",
    "print(f\"Shape of merged dataframe: {qb_ids_ngs_pfr_stats_sorted.shape}\")\n",
    "\n",
    "# Row integrity check\n",
    "print(\n",
    "    f\"Row count matches: {qb_ids_weekly_stats.shape[0] == qb_ids_ngs_weekly_stats.shape[0] == qb_ids_ngs_pfr_stats.shape[0] == qb_ids_ngs_pfr_stats_sorted.shape[0]}\"\n",
    ")\n",
    "\n",
    "# Display the sorted dataframe\n",
    "print(\"Dataframe sorted by season, week, and passing_yards:\")\n",
    "display(qb_ids_ngs_pfr_stats_sorted)\n",
    "\n",
    "# Save the sorted dataframe to a CSV file\n",
    "# qb_ids_ngs_pfr_stats_sorted.to_csv('qb_ids_ngs_pfr_stats_sorted.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e5ed8794-f5e7-4ce5-95f7-9e548bbe91cf",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "762833e2-db3b-433e-bb9e-176cccca489c",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}