notebooks/01b-data-processing-merging.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "4cc59c2c-3614-40e5-97c0-021b23cf11f2",
   "metadata": {},
   "source": [
    "# Merging Provided Data with Supplemental Data\n",
    "\n",
    "This notebook focuses on merging two datasets to create a consolidated view of player performance. The primary data set, `data/k.csv`, contains aggregated statistics for individual pitchers across MLB seasons, while the supplemental data set, `data/supplemental-stats.csv`, provides more granular, team-specific metrics. \n",
    "\n",
    "## Overview of Datasets\n",
    "\n",
    "### Provided Data (`data/k.csv`)\n",
    "This data set includes 8 columns summarizing player performance for each season:\n",
    "1. **MLBAMID**: MLB player ID.\n",
    "2. **PlayerId**: FanGraphs player ID.\n",
    "3. **Name**: Player name.\n",
    "4. **Team**: Team abbreviation (or `\"- - -\"` for players with multiple teams in a season).\n",
    "5. **Age**: Player’s age during the 2024 season.\n",
    "6. **Season**: Season year.\n",
    "7. **TBF**: Total batters faced in the season.\n",
    "8. **K%**: Strikeout percentage for the season.\n",
    "\n",
    "### Supplemental Data (`data/supplemental-stats.csv`)\n",
    "This data set contains 36 columns detailing additional player statistics, including granular performance metrics such as pitches per plate appearance, strike percentages, and inning-specific data. These statistics are broken down by team, which allows for a more detailed analysis of multi-team players.\n",
    "\n",
    "## Data Consolidation Challenges\n",
    "While the provided data set aggregates statistics across all teams a player has played for in a season, the supplemental data set retains team-specific records. For example, the provided data set shows one row per player-season, whereas the supplemental data set has multiple rows for players who played for multiple teams. In addition, the indicator for a player having a multi-team season is `'TOT'` in the supplemental data and marked as `'- - -'` in the provided data.  \n",
    "\n",
    "Consider the case of **Yohan Ramírez**'s 2022 and 2024 seasons:  \n",
    "- In the provided data set, his statistics are aggregated into a single row under `\"- - -\"`.\n",
    "- In the supplemental data set, his stats are detailed separately for teams `SEA`, `CLE`, `PIT`, `NYM`, `BAL`, `LAD`, `BOS` and a total across all teams (`TOT`).\n",
    "- **Notice that there are multiple `TOT` indicators in 2022 and 2024. The highest `TOT` is taken to represent that players year.\n",
    "\n",
    "### Example: Yohan Ramírez\n",
    "#### Provided Data (`data/k.csv`)\n",
    "|      |   MLBAMID |   PlayerId | Name          | Team   |   Age |   Season |   TBF |       K% |\n",
    "|-----:|----------:|-----------:|:--------------|:-------|------:|---------:|------:|---------:|\n",
    "|  267 |    670990 |      19444 | Yohan Ramírez | - - -  |    29 |     2024 |   208 | 0.216346 |\n",
    "| 1299 |    670990 |      19444 | Yohan Ramírez | - - -  |    27 |     2022 |   167 | 0.191617 |\n",
    "\n",
    "#### Supplemental Data (`data/supplemental-stats.csv`)\n",
    "|      |   Rk | Name          |   Age | Tm   |   IP |   PA |   Pit |   Pit/PA |   Str |   Str% |   L/Str |   S/Str |   F/Str |   I/Str |   AS/Str |   I/Bll |   AS/Pit |   Con |   1st% |   30% |   30c |   30s |   02% |   02c |   02s |   02h |   L/SO |   S/SO |   L/SO% |   3pK |   4pW |   PAu |   Pitu |   Stru |   Season |\n",
    "|-----:|-----:|:--------------|------:|:-----|-----:|-----:|------:|---------:|------:|-------:|--------:|--------:|--------:|--------:|---------:|--------:|---------:|------:|-------:|------:|------:|------:|------:|------:|------:|------:|-------:|-------:|--------:|------:|------:|------:|-------:|-------:|---------:|\n",
    "| 1942 |  784 | Yohan Ramírez |    27 | TOT  | 37.1 |  167 |   620 |     3.71 |   383 |  0.618 |   0.308 |   0.164 |   0.243 |   0.285 |    0.692 |       0 |    0.427 | 0.762 |  0.569 | 0.042 |     7 |     5 | 0.281 |    47 |    26 |     3 |     12 |     20 |   0.375 |     7 |     1 |     0 |      0 |      0 |     2022 |\n",
    "| 1943 |  785 | Yohan Ramírez |    27 | TOT  | 10.1 |   51 |   198 |     3.88 |   117 |  0.591 |   0.274 |   0.256 |   0.214 |   0.256 |    0.726 |       0 |    0.429 | 0.647 |  0.569 | 0.02  |     1 |     1 | 0.137 |     7 |     5 |     1 |      3 |      8 |   0.273 |     2 |     0 |     0 |      0 |      0 |     2022 |\n",
    "| 1944 |  786 | Yohan Ramírez |    27 | SEA  |  8.1 |   40 |   158 |     3.95 |    92 |  0.582 |   0.217 |   0.326 |   0.217 |   0.239 |    0.783 |       0 |    0.456 | 0.583 |  0.55  | 0.025 |     1 |     1 | 0.175 |     7 |     5 |     1 |      2 |      8 |   0.2   |     2 |     0 |     0 |      0 |      0 |     2022 |\n",
    "| 1945 |  787 | Yohan Ramírez |    27 | CLE  |  2   |   11 |    40 |     3.64 |    25 |  0.625 |   0.48  |   0     |   0.2   |   0.32  |    0.52  |       0 |    0.325 | 1     |  0.636 | 0     |     0 |     0 | 0     |     0 |     0 |     0 |      1 |      0 |   1     |     0 |     0 |     0 |      0 |      0 |     2022 |\n",
    "| 1946 |  788 | Yohan Ramírez |    27 | PIT  | 27   |  116 |   422 |     3.64 |   266 |  0.63  |   0.323 |   0.124 |   0.256 |   0.297 |    0.677 |       0 |    0.427 | 0.817 |  0.569 | 0.052 |     6 |     4 | 0.345 |    40 |    21 |     2 |      9 |     12 |   0.429 |     5 |     1 |     0 |      0 |      0 |     2022 |\n",
    "| 4097 |  794 | Yohan Ramírez |    29 | TOT  | 44.9 |  208 |   761 |     3.66 |   467 |  0.614 |   0.315 |   0.171 |   0.227 |   0.287 |    0.685 |       0 |    0.42  | 0.75  |  0.51  | 0.077 |    16 |     7 | 0.207 |    43 |    30 |     1 |      9 |     36 |   0.2   |    10 |     5 |     0 |      0 |      0 |     2024 |\n",
    "| 4098 |  795 | Yohan Ramírez |    29 | TOT  |  7.1 |   33 |   133 |     4.03 |    77 |  0.579 |   0.377 |   0.182 |   0.195 |   0.247 |    0.623 |       0 |    0.361 | 0.708 |  0.303 | 0.061 |     2 |     1 | 0.03  |     1 |     1 |     0 |      0 |      7 |   0     |     0 |     1 |     0 |      0 |      0 |     2024 |\n",
    "| 4099 |  796 | Yohan Ramírez |    29 | TOT  | 37.2 |  175 |   628 |     3.59 |   390 |  0.621 |   0.303 |   0.169 |   0.233 |   0.295 |    0.697 |       0 |    0.433 | 0.757 |  0.549 | 0.08  |    14 |     6 | 0.24  |    42 |    29 |     1 |      9 |     29 |   0.237 |    10 |     4 |     0 |      0 |      0 |     2024 |\n",
    "| 4100 |  797 | Yohan Ramírez |    29 | NYM  |  8.1 |   41 |   147 |     3.59 |    93 |  0.633 |   0.323 |   0.247 |   0.151 |   0.28  |    0.677 |       0 |    0.429 | 0.635 |  0.537 | 0.122 |     5 |     2 | 0.195 |     8 |     4 |     0 |      3 |      8 |   0.273 |     2 |     2 |     0 |      0 |      0 |     2024 |\n",
    "| 4101 |  798 | Yohan Ramírez |    29 | BAL  |  6   |   24 |   104 |     4.33 |    61 |  0.587 |   0.41  |   0.164 |   0.213 |   0.213 |    0.59  |       0 |    0.346 | 0.722 |  0.375 | 0.083 |     2 |     1 | 0.042 |     1 |     1 |     0 |      0 |      6 |   0     |     0 |     1 |     0 |      0 |      0 |     2024 |\n",
    "| 4102 |  799 | Yohan Ramírez |    29 | LAD  | 29.1 |  134 |   481 |     3.59 |   297 |  0.617 |   0.296 |   0.145 |   0.259 |   0.3   |    0.704 |       0 |    0.435 | 0.794 |  0.552 | 0.067 |     9 |     4 | 0.254 |    34 |    25 |     1 |      6 |     21 |   0.222 |     8 |     2 |     0 |      0 |      0 |     2024 |\n",
    "| 4103 |  800 | Yohan Ramírez |    29 | BOS  |  1.1 |    9 |    29 |     3.22 |    16 |  0.552 |   0.25  |   0.25  |   0.125 |   0.375 |    0.75  |       0 |    0.414 | 0.667 |  0.111 | 0     |     0 |     0 | 0     |     0 |     0 |     0 |      0 |      1 |   0     |     0 |     0 |     0 |      0 |      0 |     2024 |\n",
    "\n",
    "#### Desired Output\n",
    "|      |   PlayerId | Team   |   Season |   MLBAMID | Name          |   Age |   TBF |       K% |   Rk |   IP |   PA |   Pit |   Pit/PA |   Str |   Str% |   L/Str |   S/Str |   F/Str |   I/Str |   AS/Str |   I/Bll |   AS/Pit |   Con |   1st% |   30% |   30c |   30s |   02% |   02c |   02s |   02h |   L/SO |   S/SO |   L/SO% |   3pK |   4pW |   PAu |   Pitu |   Stru |\n",
    "|-----:|-----------:|:-------|---------:|----------:|:--------------|------:|------:|---------:|-----:|-----:|-----:|------:|---------:|------:|-------:|--------:|--------:|--------:|--------:|---------:|--------:|---------:|------:|-------:|------:|------:|------:|------:|------:|------:|------:|-------:|-------:|--------:|------:|------:|------:|-------:|-------:|\n",
    "| 1213 |      19444 | - - -  |     2022 |    670990 | Yohan Ramírez |    27 |   167 | 0.191617 |  784 | 37.1 |  167 |   620 |     3.71 |   383 |  0.618 |   0.308 |   0.164 |   0.243 |   0.285 |    0.692 |       0 |    0.427 | 0.762 |  0.569 | 0.042 |     7 |     5 | 0.281 |    47 |    26 |     3 |     12 |     20 |   0.375 |     7 |     1 |     0 |      0 |      0 |\n",
    "| 1214 |      19444 | - - -  |     2023 |    670990 | Yohan Ramírez |    28 |   176 | 0.198864 |  770 | 38.1 |  177 |   708 |     4    |   428 |  0.605 |   0.332 |   0.138 |   0.266 |   0.264 |    0.668 |       0 |    0.404 | 0.794 |  0.554 | 0.045 |     8 |     2 | 0.237 |    42 |    19 |     5 |     12 |     23 |   0.343 |     4 |     5 |     0 |      0 |      0 |\n",
    "| 1215 |      19444 | - - -  |     2024 |    670990 | Yohan Ramírez |    29 |   208 | 0.216346 |  794 | 44.9 |  208 |   761 |     3.66 |   467 |  0.614 |   0.315 |   0.171 |   0.227 |   0.287 |    0.685 |       0 |    0.42  | 0.75  |  0.51  | 0.077 |    16 |     7 | 0.207 |    43 |    30 |     1 |      9 |     36 |   0.2   |    10 |     5 |     0 |      0 |      0 |\n",
    "---\n",
    "\n",
    "## Workflow for Merging and Aggregation\n",
    "1. **Standardization**: Harmonize column names and formats between datasets. For example, rename the `Tm` column in the supplemental data set to `Team` for consistency and the multi-team indicator from `'TOT'` to `'- - - '`.\n",
    "2. **Aggregation**: Consolidate team-specific rows in the supplemental data set into a single row per player-season by selecting only the _first_ `TOT` rows where it exists and re-naming it to `- - -` for consistency with the provided data.\n",
    "3. **Joining**: Merge the aggregated supplemental data with the provided data set, ensuring alignment on player identifiers (`Name`, `Season`, `Age`, and `Team`).\n",
    "\n",
    "---\n",
    "\n",
    "## Development Workflow\n",
    "\n",
    "All functions demonstrated in this notebook are defined in the `bullpen.data_utils` module for clarity, reusability, and unit testing. While this notebook retains the initial development and intent of these functions, their inclusion here is primarily for transparency and ease of reference.  \n",
    "\n",
    "For production usage, refer to the source code in the `bullpen.data_utils` module."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "81dd0130-f437-4d5a-ae38-4a566d2218e7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "DATA_DIR=PosixPath('/Users/logan/Desktop/repos/mlb-pitcher-xK/data')\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "from bullpen.data_utils import DATA_DIR\n",
    "\n",
    "print(f\"{DATA_DIR=}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a88d831a-bc91-4004-a38a-4777157eb6b2",
   "metadata": {},
   "source": [
    "## Loading Data\n",
    "\n",
    "Refer to the companion notebook: [01a-data-processing-fixing-names.ipynb](./01a-data-processing-fixing-names.ipynb) for detailed preprocessing steps.\n",
    "\n",
    "**Note**: While the data loading process is encapsulated in the `bullpen.data_utils.load_data()` function for modularity and reuse, the relevant code is included here to provide full transparency into the data processing pipeline. This allows for a clear understanding of the transformations and ensures traceability for debugging or further customization."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "8faa1a72-8049-4291-9c2d-4cd760bf5116",
   "metadata": {},
   "outputs": [],
   "source": [
    "provided_data = pd.read_csv(DATA_DIR.joinpath(\"k.csv\"))\n",
    "supplemental_data = pd.read_csv(DATA_DIR.joinpath(\"supplemental-stats.csv\"))\n",
    "\n",
    "\n",
    "supplemental_data.Name = supplemental_data.Name.replace(\n",
    "    {\n",
    "        \"Manny Banuelos\": \"Manny Bañuelos\",\n",
    "        \"Ralph Garza\": \"Ralph Garza Jr.\",\n",
    "        \"Luis Ortiz\": \"Luis L. Ortiz\",\n",
    "        \"Jose Hernandez\": \"Jose E. Hernandez\",\n",
    "        \"Hyeon-jong Yang\": \"Hyeon-Jong Yang\",\n",
    "        \"Adrián Martinez\": \"Adrián Martínez\",\n",
    "    }\n",
    ")\n",
    "\n",
    "provided_data.Name = provided_data.Name.replace(\n",
    "    {\n",
    "        \"Eduardo Rodriguez\": \"Eduardo Rodríguez\",\n",
    "        \"Jose Alvarez\": \"José Álvarez\",\n",
    "        \"Sandy Alcantara\": \"Sandy Alcántara\",\n",
    "        \"Carlos Martinez\": \"Carlos Martínez\",\n",
    "        \"Phillips Valdez\": \"Phillips Valdéz\",\n",
    "        \"Jovani Moran\": \"Jovani Morán\",\n",
    "        \"Jose Cuas\": \"José Cuas\",\n",
    "        \"Jorge Alcala\": \"Jorge Alcalá\",\n",
    "        \"Jhoan Duran\": \"Jhoan Durán\",\n",
    "        \"Jesus Tinoco\": \"Jesús Tinoco\",\n",
    "        \"Brent Honeywell\": \"Brent Honeywell Jr.\",\n",
    "        \"Adrian Morejon\": \"Adrián Morejón\",\n",
    "    }\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d6e7579f-23cb-4a78-94c2-d2f555368fd6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>Rk</th>\n",
       "      <th>Name</th>\n",
       "      <th>Age</th>\n",
       "      <th>Tm</th>\n",
       "      <th>IP</th>\n",
       "      <th>PA</th>\n",
       "      <th>Pit</th>\n",
       "      <th>Pit/PA</th>\n",
       "      <th>Str</th>\n",
       "      <th>Str%</th>\n",
       "      <th>...</th>\n",
       "      <th>02h</th>\n",
       "      <th>L/SO</th>\n",
       "      <th>S/SO</th>\n",
       "      <th>L/SO%</th>\n",
       "      <th>3pK</th>\n",
       "      <th>4pW</th>\n",
       "      <th>PAu</th>\n",
       "      <th>Pitu</th>\n",
       "      <th>Stru</th>\n",
       "      <th>Season</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>836</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>26</td>\n",
       "      <td>SEA</td>\n",
       "      <td>27.2</td>\n",
       "      <td>114</td>\n",
       "      <td>436</td>\n",
       "      <td>3.82</td>\n",
       "      <td>275</td>\n",
       "      <td>0.631</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>31</td>\n",
       "      <td>0.114</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1942</th>\n",
       "      <td>784</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>TOT</td>\n",
       "      <td>37.1</td>\n",
       "      <td>167</td>\n",
       "      <td>620</td>\n",
       "      <td>3.71</td>\n",
       "      <td>383</td>\n",
       "      <td>0.618</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>0.375</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1943</th>\n",
       "      <td>785</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>TOT</td>\n",
       "      <td>10.1</td>\n",
       "      <td>51</td>\n",
       "      <td>198</td>\n",
       "      <td>3.88</td>\n",
       "      <td>117</td>\n",
       "      <td>0.591</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>0.273</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1944</th>\n",
       "      <td>786</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>SEA</td>\n",
       "      <td>8.1</td>\n",
       "      <td>40</td>\n",
       "      <td>158</td>\n",
       "      <td>3.95</td>\n",
       "      <td>92</td>\n",
       "      <td>0.582</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>0.200</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1945</th>\n",
       "      <td>787</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>CLE</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>3.64</td>\n",
       "      <td>25</td>\n",
       "      <td>0.625</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1946</th>\n",
       "      <td>788</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>PIT</td>\n",
       "      <td>27.0</td>\n",
       "      <td>116</td>\n",
       "      <td>422</td>\n",
       "      <td>3.64</td>\n",
       "      <td>266</td>\n",
       "      <td>0.630</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>0.429</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3009</th>\n",
       "      <td>770</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>28</td>\n",
       "      <td>TOT</td>\n",
       "      <td>38.1</td>\n",
       "      <td>177</td>\n",
       "      <td>708</td>\n",
       "      <td>4.00</td>\n",
       "      <td>428</td>\n",
       "      <td>0.605</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>0.343</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3010</th>\n",
       "      <td>771</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>28</td>\n",
       "      <td>PIT</td>\n",
       "      <td>34.1</td>\n",
       "      <td>156</td>\n",
       "      <td>602</td>\n",
       "      <td>3.86</td>\n",
       "      <td>373</td>\n",
       "      <td>0.620</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>22</td>\n",
       "      <td>0.290</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3011</th>\n",
       "      <td>772</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>28</td>\n",
       "      <td>CHW</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21</td>\n",
       "      <td>106</td>\n",
       "      <td>5.05</td>\n",
       "      <td>55</td>\n",
       "      <td>0.519</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0.750</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4097</th>\n",
       "      <td>794</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>TOT</td>\n",
       "      <td>44.9</td>\n",
       "      <td>208</td>\n",
       "      <td>761</td>\n",
       "      <td>3.66</td>\n",
       "      <td>467</td>\n",
       "      <td>0.614</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>36</td>\n",
       "      <td>0.200</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4098</th>\n",
       "      <td>795</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>TOT</td>\n",
       "      <td>7.1</td>\n",
       "      <td>33</td>\n",
       "      <td>133</td>\n",
       "      <td>4.03</td>\n",
       "      <td>77</td>\n",
       "      <td>0.579</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4099</th>\n",
       "      <td>796</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>TOT</td>\n",
       "      <td>37.2</td>\n",
       "      <td>175</td>\n",
       "      <td>628</td>\n",
       "      <td>3.59</td>\n",
       "      <td>390</td>\n",
       "      <td>0.621</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>29</td>\n",
       "      <td>0.237</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4100</th>\n",
       "      <td>797</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>NYM</td>\n",
       "      <td>8.1</td>\n",
       "      <td>41</td>\n",
       "      <td>147</td>\n",
       "      <td>3.59</td>\n",
       "      <td>93</td>\n",
       "      <td>0.633</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>0.273</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4101</th>\n",
       "      <td>798</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>BAL</td>\n",
       "      <td>6.0</td>\n",
       "      <td>24</td>\n",
       "      <td>104</td>\n",
       "      <td>4.33</td>\n",
       "      <td>61</td>\n",
       "      <td>0.587</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4102</th>\n",
       "      <td>799</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>LAD</td>\n",
       "      <td>29.1</td>\n",
       "      <td>134</td>\n",
       "      <td>481</td>\n",
       "      <td>3.59</td>\n",
       "      <td>297</td>\n",
       "      <td>0.617</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>21</td>\n",
       "      <td>0.222</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4103</th>\n",
       "      <td>800</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>BOS</td>\n",
       "      <td>1.1</td>\n",
       "      <td>9</td>\n",
       "      <td>29</td>\n",
       "      <td>3.22</td>\n",
       "      <td>16</td>\n",
       "      <td>0.552</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>16 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Rk           Name  Age   Tm    IP   PA  Pit  Pit/PA  Str   Str%  ...  \\\n",
       "835   836  Yohan Ramírez   26  SEA  27.2  114  436    3.82  275  0.631  ...   \n",
       "1942  784  Yohan Ramírez   27  TOT  37.1  167  620    3.71  383  0.618  ...   \n",
       "1943  785  Yohan Ramírez   27  TOT  10.1   51  198    3.88  117  0.591  ...   \n",
       "1944  786  Yohan Ramírez   27  SEA   8.1   40  158    3.95   92  0.582  ...   \n",
       "1945  787  Yohan Ramírez   27  CLE   2.0   11   40    3.64   25  0.625  ...   \n",
       "1946  788  Yohan Ramírez   27  PIT  27.0  116  422    3.64  266  0.630  ...   \n",
       "3009  770  Yohan Ramírez   28  TOT  38.1  177  708    4.00  428  0.605  ...   \n",
       "3010  771  Yohan Ramírez   28  PIT  34.1  156  602    3.86  373  0.620  ...   \n",
       "3011  772  Yohan Ramírez   28  CHW   4.0   21  106    5.05   55  0.519  ...   \n",
       "4097  794  Yohan Ramírez   29  TOT  44.9  208  761    3.66  467  0.614  ...   \n",
       "4098  795  Yohan Ramírez   29  TOT   7.1   33  133    4.03   77  0.579  ...   \n",
       "4099  796  Yohan Ramírez   29  TOT  37.2  175  628    3.59  390  0.621  ...   \n",
       "4100  797  Yohan Ramírez   29  NYM   8.1   41  147    3.59   93  0.633  ...   \n",
       "4101  798  Yohan Ramírez   29  BAL   6.0   24  104    4.33   61  0.587  ...   \n",
       "4102  799  Yohan Ramírez   29  LAD  29.1  134  481    3.59  297  0.617  ...   \n",
       "4103  800  Yohan Ramírez   29  BOS   1.1    9   29    3.22   16  0.552  ...   \n",
       "\n",
       "      02h  L/SO  S/SO  L/SO%  3pK  4pW  PAu  Pitu  Stru  Season  \n",
       "835     2     4    31  0.114    6    1    0     0     0    2021  \n",
       "1942    3    12    20  0.375    7    1    0     0     0    2022  \n",
       "1943    1     3     8  0.273    2    0    0     0     0    2022  \n",
       "1944    1     2     8  0.200    2    0    0     0     0    2022  \n",
       "1945    0     1     0  1.000    0    0    0     0     0    2022  \n",
       "1946    2     9    12  0.429    5    1    0     0     0    2022  \n",
       "3009    5    12    23  0.343    4    5    0     0     0    2023  \n",
       "3010    5     9    22  0.290    4    3    0     0     0    2023  \n",
       "3011    0     3     1  0.750    0    2    0     0     0    2023  \n",
       "4097    1     9    36  0.200   10    5    0     0     0    2024  \n",
       "4098    0     0     7  0.000    0    1    0     0     0    2024  \n",
       "4099    1     9    29  0.237   10    4    0     0     0    2024  \n",
       "4100    0     3     8  0.273    2    2    0     0     0    2024  \n",
       "4101    0     0     6  0.000    0    1    0     0     0    2024  \n",
       "4102    1     6    21  0.222    8    2    0     0     0    2024  \n",
       "4103    0     0     1  0.000    0    0    0     0     0    2024  \n",
       "\n",
       "[16 rows x 35 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "supplemental_data[supplemental_data.Name == \"Yohan Ramírez\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5933ee2c-6379-444f-b7eb-d4d2c0fe5f0f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>Rk</th>\n",
       "      <th>Name</th>\n",
       "      <th>Age</th>\n",
       "      <th>Tm</th>\n",
       "      <th>IP</th>\n",
       "      <th>PA</th>\n",
       "      <th>Pit</th>\n",
       "      <th>Pit/PA</th>\n",
       "      <th>Str</th>\n",
       "      <th>Str%</th>\n",
       "      <th>...</th>\n",
       "      <th>02h</th>\n",
       "      <th>L/SO</th>\n",
       "      <th>S/SO</th>\n",
       "      <th>L/SO%</th>\n",
       "      <th>3pK</th>\n",
       "      <th>4pW</th>\n",
       "      <th>PAu</th>\n",
       "      <th>Pitu</th>\n",
       "      <th>Stru</th>\n",
       "      <th>Season</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Fernando Abad</td>\n",
       "      <td>35</td>\n",
       "      <td>BAL</td>\n",
       "      <td>17.2</td>\n",
       "      <td>82</td>\n",
       "      <td>299</td>\n",
       "      <td>3.65</td>\n",
       "      <td>183</td>\n",
       "      <td>0.612</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0.500</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Cory Abbott</td>\n",
       "      <td>25</td>\n",
       "      <td>CHC</td>\n",
       "      <td>17.1</td>\n",
       "      <td>82</td>\n",
       "      <td>352</td>\n",
       "      <td>4.29</td>\n",
       "      <td>203</td>\n",
       "      <td>0.577</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>0.333</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Albert Abreu</td>\n",
       "      <td>25</td>\n",
       "      <td>NYY</td>\n",
       "      <td>36.2</td>\n",
       "      <td>156</td>\n",
       "      <td>642</td>\n",
       "      <td>4.12</td>\n",
       "      <td>392</td>\n",
       "      <td>0.611</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>26</td>\n",
       "      <td>0.257</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Bryan Abreu</td>\n",
       "      <td>24</td>\n",
       "      <td>HOU</td>\n",
       "      <td>36.0</td>\n",
       "      <td>161</td>\n",
       "      <td>689</td>\n",
       "      <td>4.28</td>\n",
       "      <td>407</td>\n",
       "      <td>0.591</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>0.167</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Domingo Acevedo</td>\n",
       "      <td>27</td>\n",
       "      <td>OAK</td>\n",
       "      <td>11.0</td>\n",
       "      <td>44</td>\n",
       "      <td>174</td>\n",
       "      <td>3.95</td>\n",
       "      <td>114</td>\n",
       "      <td>0.655</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0.000</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4393</th>\n",
       "      <td>1090</td>\n",
       "      <td>Ryan Zeferjahn</td>\n",
       "      <td>26</td>\n",
       "      <td>LAA</td>\n",
       "      <td>17.0</td>\n",
       "      <td>64</td>\n",
       "      <td>212</td>\n",
       "      <td>3.31</td>\n",
       "      <td>137</td>\n",
       "      <td>0.646</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>0.056</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4394</th>\n",
       "      <td>1091</td>\n",
       "      <td>Angel Zerpa</td>\n",
       "      <td>24</td>\n",
       "      <td>KCR</td>\n",
       "      <td>53.2</td>\n",
       "      <td>239</td>\n",
       "      <td>952</td>\n",
       "      <td>3.98</td>\n",
       "      <td>602</td>\n",
       "      <td>0.632</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>27</td>\n",
       "      <td>22</td>\n",
       "      <td>0.551</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4395</th>\n",
       "      <td>1092</td>\n",
       "      <td>Tyler Zuber</td>\n",
       "      <td>29</td>\n",
       "      <td>TBR</td>\n",
       "      <td>3.1</td>\n",
       "      <td>15</td>\n",
       "      <td>75</td>\n",
       "      <td>5.00</td>\n",
       "      <td>43</td>\n",
       "      <td>0.573</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0.250</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4396</th>\n",
       "      <td>1093</td>\n",
       "      <td>Yosver Zulueta</td>\n",
       "      <td>26</td>\n",
       "      <td>CIN</td>\n",
       "      <td>16.1</td>\n",
       "      <td>69</td>\n",
       "      <td>286</td>\n",
       "      <td>4.14</td>\n",
       "      <td>175</td>\n",
       "      <td>0.612</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>0.450</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4397</th>\n",
       "      <td>1094</td>\n",
       "      <td>Guillo Zuñiga</td>\n",
       "      <td>25</td>\n",
       "      <td>LAA</td>\n",
       "      <td>17.2</td>\n",
       "      <td>76</td>\n",
       "      <td>271</td>\n",
       "      <td>3.57</td>\n",
       "      <td>162</td>\n",
       "      <td>0.598</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0.083</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4398 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Rk             Name  Age   Tm    IP   PA  Pit  Pit/PA  Str   Str%  \\\n",
       "0        1    Fernando Abad   35  BAL  17.2   82  299    3.65  183  0.612   \n",
       "1        2      Cory Abbott   25  CHC  17.1   82  352    4.29  203  0.577   \n",
       "2        3     Albert Abreu   25  NYY  36.2  156  642    4.12  392  0.611   \n",
       "3        4      Bryan Abreu   24  HOU  36.0  161  689    4.28  407  0.591   \n",
       "4        5  Domingo Acevedo   27  OAK  11.0   44  174    3.95  114  0.655   \n",
       "...    ...              ...  ...  ...   ...  ...  ...     ...  ...    ...   \n",
       "4393  1090   Ryan Zeferjahn   26  LAA  17.0   64  212    3.31  137  0.646   \n",
       "4394  1091      Angel Zerpa   24  KCR  53.2  239  952    3.98  602  0.632   \n",
       "4395  1092      Tyler Zuber   29  TBR   3.1   15   75    5.00   43  0.573   \n",
       "4396  1093   Yosver Zulueta   26  CIN  16.1   69  286    4.14  175  0.612   \n",
       "4397  1094    Guillo Zuñiga   25  LAA  17.2   76  271    3.57  162  0.598   \n",
       "\n",
       "      ...  02h  L/SO  S/SO  L/SO%  3pK  4pW  PAu  Pitu  Stru  Season  \n",
       "0     ...    1     5     5  0.500    1    0    0     0     0    2021  \n",
       "1     ...    0     4     8  0.333    1    2    0     0     0    2021  \n",
       "2     ...    1     9    26  0.257    7    2    0     0     0    2021  \n",
       "3     ...    3     6    30  0.167    6    4    0     0     0    2021  \n",
       "4     ...    1     0     9  0.000    4    1    0     0     0    2021  \n",
       "...   ...  ...   ...   ...    ...  ...  ...  ...   ...   ...     ...  \n",
       "4393  ...    0     1    17  0.056    3    1    0     0     0    2024  \n",
       "4394  ...    5    27    22  0.551    7    2    0     0     0    2024  \n",
       "4395  ...    1     1     3  0.250    0    0    0     0     0    2024  \n",
       "4396  ...    1     9    11  0.450    1    0    0     0     0    2024  \n",
       "4397  ...    1     1    11  0.083    1    0    0     0     0    2024  \n",
       "\n",
       "[4398 rows x 35 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "supplemental_data.Tm = supplemental_data.Tm.replace(\"TOT\", \"- - -\")\n",
    "supplemental_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "318eb0c0-591c-433a-947f-3c493308231a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>Rk</th>\n",
       "      <th>Name</th>\n",
       "      <th>Age</th>\n",
       "      <th>Tm</th>\n",
       "      <th>IP</th>\n",
       "      <th>PA</th>\n",
       "      <th>Pit</th>\n",
       "      <th>Pit/PA</th>\n",
       "      <th>Str</th>\n",
       "      <th>Str%</th>\n",
       "      <th>...</th>\n",
       "      <th>02h</th>\n",
       "      <th>L/SO</th>\n",
       "      <th>S/SO</th>\n",
       "      <th>L/SO%</th>\n",
       "      <th>3pK</th>\n",
       "      <th>4pW</th>\n",
       "      <th>PAu</th>\n",
       "      <th>Pitu</th>\n",
       "      <th>Stru</th>\n",
       "      <th>Season</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>836</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>26</td>\n",
       "      <td>SEA</td>\n",
       "      <td>27.2</td>\n",
       "      <td>114</td>\n",
       "      <td>436</td>\n",
       "      <td>3.82</td>\n",
       "      <td>275</td>\n",
       "      <td>0.631</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>31</td>\n",
       "      <td>0.114</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1942</th>\n",
       "      <td>784</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>- - -</td>\n",
       "      <td>37.1</td>\n",
       "      <td>167</td>\n",
       "      <td>620</td>\n",
       "      <td>3.71</td>\n",
       "      <td>383</td>\n",
       "      <td>0.618</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>0.375</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1943</th>\n",
       "      <td>785</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>- - -</td>\n",
       "      <td>10.1</td>\n",
       "      <td>51</td>\n",
       "      <td>198</td>\n",
       "      <td>3.88</td>\n",
       "      <td>117</td>\n",
       "      <td>0.591</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>0.273</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1944</th>\n",
       "      <td>786</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>SEA</td>\n",
       "      <td>8.1</td>\n",
       "      <td>40</td>\n",
       "      <td>158</td>\n",
       "      <td>3.95</td>\n",
       "      <td>92</td>\n",
       "      <td>0.582</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>0.200</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1945</th>\n",
       "      <td>787</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>CLE</td>\n",
       "      <td>2.0</td>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>3.64</td>\n",
       "      <td>25</td>\n",
       "      <td>0.625</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1946</th>\n",
       "      <td>788</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>PIT</td>\n",
       "      <td>27.0</td>\n",
       "      <td>116</td>\n",
       "      <td>422</td>\n",
       "      <td>3.64</td>\n",
       "      <td>266</td>\n",
       "      <td>0.630</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>0.429</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3009</th>\n",
       "      <td>770</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>28</td>\n",
       "      <td>- - -</td>\n",
       "      <td>38.1</td>\n",
       "      <td>177</td>\n",
       "      <td>708</td>\n",
       "      <td>4.00</td>\n",
       "      <td>428</td>\n",
       "      <td>0.605</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>0.343</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3010</th>\n",
       "      <td>771</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>28</td>\n",
       "      <td>PIT</td>\n",
       "      <td>34.1</td>\n",
       "      <td>156</td>\n",
       "      <td>602</td>\n",
       "      <td>3.86</td>\n",
       "      <td>373</td>\n",
       "      <td>0.620</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>22</td>\n",
       "      <td>0.290</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3011</th>\n",
       "      <td>772</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>28</td>\n",
       "      <td>CHW</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21</td>\n",
       "      <td>106</td>\n",
       "      <td>5.05</td>\n",
       "      <td>55</td>\n",
       "      <td>0.519</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0.750</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4097</th>\n",
       "      <td>794</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>- - -</td>\n",
       "      <td>44.9</td>\n",
       "      <td>208</td>\n",
       "      <td>761</td>\n",
       "      <td>3.66</td>\n",
       "      <td>467</td>\n",
       "      <td>0.614</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>36</td>\n",
       "      <td>0.200</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4098</th>\n",
       "      <td>795</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>- - -</td>\n",
       "      <td>7.1</td>\n",
       "      <td>33</td>\n",
       "      <td>133</td>\n",
       "      <td>4.03</td>\n",
       "      <td>77</td>\n",
       "      <td>0.579</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4099</th>\n",
       "      <td>796</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>- - -</td>\n",
       "      <td>37.2</td>\n",
       "      <td>175</td>\n",
       "      <td>628</td>\n",
       "      <td>3.59</td>\n",
       "      <td>390</td>\n",
       "      <td>0.621</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>29</td>\n",
       "      <td>0.237</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4100</th>\n",
       "      <td>797</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>NYM</td>\n",
       "      <td>8.1</td>\n",
       "      <td>41</td>\n",
       "      <td>147</td>\n",
       "      <td>3.59</td>\n",
       "      <td>93</td>\n",
       "      <td>0.633</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>0.273</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4101</th>\n",
       "      <td>798</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>BAL</td>\n",
       "      <td>6.0</td>\n",
       "      <td>24</td>\n",
       "      <td>104</td>\n",
       "      <td>4.33</td>\n",
       "      <td>61</td>\n",
       "      <td>0.587</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4102</th>\n",
       "      <td>799</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>LAD</td>\n",
       "      <td>29.1</td>\n",
       "      <td>134</td>\n",
       "      <td>481</td>\n",
       "      <td>3.59</td>\n",
       "      <td>297</td>\n",
       "      <td>0.617</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>21</td>\n",
       "      <td>0.222</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4103</th>\n",
       "      <td>800</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>BOS</td>\n",
       "      <td>1.1</td>\n",
       "      <td>9</td>\n",
       "      <td>29</td>\n",
       "      <td>3.22</td>\n",
       "      <td>16</td>\n",
       "      <td>0.552</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2024</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>16 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Rk           Name  Age     Tm    IP   PA  Pit  Pit/PA  Str   Str%  ...  \\\n",
       "835   836  Yohan Ramírez   26    SEA  27.2  114  436    3.82  275  0.631  ...   \n",
       "1942  784  Yohan Ramírez   27  - - -  37.1  167  620    3.71  383  0.618  ...   \n",
       "1943  785  Yohan Ramírez   27  - - -  10.1   51  198    3.88  117  0.591  ...   \n",
       "1944  786  Yohan Ramírez   27    SEA   8.1   40  158    3.95   92  0.582  ...   \n",
       "1945  787  Yohan Ramírez   27    CLE   2.0   11   40    3.64   25  0.625  ...   \n",
       "1946  788  Yohan Ramírez   27    PIT  27.0  116  422    3.64  266  0.630  ...   \n",
       "3009  770  Yohan Ramírez   28  - - -  38.1  177  708    4.00  428  0.605  ...   \n",
       "3010  771  Yohan Ramírez   28    PIT  34.1  156  602    3.86  373  0.620  ...   \n",
       "3011  772  Yohan Ramírez   28    CHW   4.0   21  106    5.05   55  0.519  ...   \n",
       "4097  794  Yohan Ramírez   29  - - -  44.9  208  761    3.66  467  0.614  ...   \n",
       "4098  795  Yohan Ramírez   29  - - -   7.1   33  133    4.03   77  0.579  ...   \n",
       "4099  796  Yohan Ramírez   29  - - -  37.2  175  628    3.59  390  0.621  ...   \n",
       "4100  797  Yohan Ramírez   29    NYM   8.1   41  147    3.59   93  0.633  ...   \n",
       "4101  798  Yohan Ramírez   29    BAL   6.0   24  104    4.33   61  0.587  ...   \n",
       "4102  799  Yohan Ramírez   29    LAD  29.1  134  481    3.59  297  0.617  ...   \n",
       "4103  800  Yohan Ramírez   29    BOS   1.1    9   29    3.22   16  0.552  ...   \n",
       "\n",
       "      02h  L/SO  S/SO  L/SO%  3pK  4pW  PAu  Pitu  Stru  Season  \n",
       "835     2     4    31  0.114    6    1    0     0     0    2021  \n",
       "1942    3    12    20  0.375    7    1    0     0     0    2022  \n",
       "1943    1     3     8  0.273    2    0    0     0     0    2022  \n",
       "1944    1     2     8  0.200    2    0    0     0     0    2022  \n",
       "1945    0     1     0  1.000    0    0    0     0     0    2022  \n",
       "1946    2     9    12  0.429    5    1    0     0     0    2022  \n",
       "3009    5    12    23  0.343    4    5    0     0     0    2023  \n",
       "3010    5     9    22  0.290    4    3    0     0     0    2023  \n",
       "3011    0     3     1  0.750    0    2    0     0     0    2023  \n",
       "4097    1     9    36  0.200   10    5    0     0     0    2024  \n",
       "4098    0     0     7  0.000    0    1    0     0     0    2024  \n",
       "4099    1     9    29  0.237   10    4    0     0     0    2024  \n",
       "4100    0     3     8  0.273    2    2    0     0     0    2024  \n",
       "4101    0     0     6  0.000    0    1    0     0     0    2024  \n",
       "4102    1     6    21  0.222    8    2    0     0     0    2024  \n",
       "4103    0     0     1  0.000    0    0    0     0     0    2024  \n",
       "\n",
       "[16 rows x 35 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "supplemental_data[supplemental_data.Name == \"Yohan Ramírez\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "74909371-0c54-4a40-847b-458ff96e5ff7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>PlayerId</th>\n",
       "      <th>Team</th>\n",
       "      <th>Season</th>\n",
       "      <th>MLBAMID</th>\n",
       "      <th>Name</th>\n",
       "      <th>Age</th>\n",
       "      <th>TBF</th>\n",
       "      <th>K%</th>\n",
       "      <th>Rk</th>\n",
       "      <th>IP</th>\n",
       "      <th>...</th>\n",
       "      <th>02s</th>\n",
       "      <th>02h</th>\n",
       "      <th>L/SO</th>\n",
       "      <th>S/SO</th>\n",
       "      <th>L/SO%</th>\n",
       "      <th>3pK</th>\n",
       "      <th>4pW</th>\n",
       "      <th>PAu</th>\n",
       "      <th>Pitu</th>\n",
       "      <th>Stru</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1106</th>\n",
       "      <td>18655</td>\n",
       "      <td>ATL</td>\n",
       "      <td>2021</td>\n",
       "      <td>621345</td>\n",
       "      <td>A.J. Minter</td>\n",
       "      <td>27</td>\n",
       "      <td>221</td>\n",
       "      <td>0.257919</td>\n",
       "      <td>696</td>\n",
       "      <td>52.1</td>\n",
       "      <td>...</td>\n",
       "      <td>44</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>46</td>\n",
       "      <td>0.193</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1107</th>\n",
       "      <td>18655</td>\n",
       "      <td>ATL</td>\n",
       "      <td>2022</td>\n",
       "      <td>621345</td>\n",
       "      <td>A.J. Minter</td>\n",
       "      <td>28</td>\n",
       "      <td>271</td>\n",
       "      <td>0.346863</td>\n",
       "      <td>649</td>\n",
       "      <td>70.0</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>71</td>\n",
       "      <td>0.245</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1108</th>\n",
       "      <td>18655</td>\n",
       "      <td>ATL</td>\n",
       "      <td>2023</td>\n",
       "      <td>621345</td>\n",
       "      <td>A.J. Minter</td>\n",
       "      <td>29</td>\n",
       "      <td>260</td>\n",
       "      <td>0.315385</td>\n",
       "      <td>647</td>\n",
       "      <td>64.2</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>69</td>\n",
       "      <td>0.159</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1109</th>\n",
       "      <td>18655</td>\n",
       "      <td>ATL</td>\n",
       "      <td>2024</td>\n",
       "      <td>621345</td>\n",
       "      <td>A.J. Minter</td>\n",
       "      <td>30</td>\n",
       "      <td>134</td>\n",
       "      <td>0.261194</td>\n",
       "      <td>676</td>\n",
       "      <td>34.1</td>\n",
       "      <td>...</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>28</td>\n",
       "      <td>0.200</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1177</th>\n",
       "      <td>19343</td>\n",
       "      <td>OAK</td>\n",
       "      <td>2022</td>\n",
       "      <td>640462</td>\n",
       "      <td>A.J. Puk</td>\n",
       "      <td>27</td>\n",
       "      <td>281</td>\n",
       "      <td>0.270463</td>\n",
       "      <td>773</td>\n",
       "      <td>66.1</td>\n",
       "      <td>...</td>\n",
       "      <td>48</td>\n",
       "      <td>6</td>\n",
       "      <td>22</td>\n",
       "      <td>54</td>\n",
       "      <td>0.289</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>10310</td>\n",
       "      <td>PHI</td>\n",
       "      <td>2021</td>\n",
       "      <td>554430</td>\n",
       "      <td>Zack Wheeler</td>\n",
       "      <td>31</td>\n",
       "      <td>849</td>\n",
       "      <td>0.290931</td>\n",
       "      <td>1107</td>\n",
       "      <td>213.1</td>\n",
       "      <td>...</td>\n",
       "      <td>155</td>\n",
       "      <td>15</td>\n",
       "      <td>70</td>\n",
       "      <td>176</td>\n",
       "      <td>0.283</td>\n",
       "      <td>50</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>10310</td>\n",
       "      <td>PHI</td>\n",
       "      <td>2022</td>\n",
       "      <td>554430</td>\n",
       "      <td>Zack Wheeler</td>\n",
       "      <td>32</td>\n",
       "      <td>607</td>\n",
       "      <td>0.268534</td>\n",
       "      <td>1037</td>\n",
       "      <td>153.0</td>\n",
       "      <td>...</td>\n",
       "      <td>87</td>\n",
       "      <td>5</td>\n",
       "      <td>39</td>\n",
       "      <td>124</td>\n",
       "      <td>0.239</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>10310</td>\n",
       "      <td>PHI</td>\n",
       "      <td>2023</td>\n",
       "      <td>554430</td>\n",
       "      <td>Zack Wheeler</td>\n",
       "      <td>33</td>\n",
       "      <td>787</td>\n",
       "      <td>0.269377</td>\n",
       "      <td>1023</td>\n",
       "      <td>192.0</td>\n",
       "      <td>...</td>\n",
       "      <td>121</td>\n",
       "      <td>8</td>\n",
       "      <td>41</td>\n",
       "      <td>170</td>\n",
       "      <td>0.194</td>\n",
       "      <td>43</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>10310</td>\n",
       "      <td>PHI</td>\n",
       "      <td>2024</td>\n",
       "      <td>554430</td>\n",
       "      <td>Zack Wheeler</td>\n",
       "      <td>34</td>\n",
       "      <td>787</td>\n",
       "      <td>0.284625</td>\n",
       "      <td>1043</td>\n",
       "      <td>200.0</td>\n",
       "      <td>...</td>\n",
       "      <td>132</td>\n",
       "      <td>11</td>\n",
       "      <td>71</td>\n",
       "      <td>153</td>\n",
       "      <td>0.317</td>\n",
       "      <td>39</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880</th>\n",
       "      <td>31827</td>\n",
       "      <td>MIN</td>\n",
       "      <td>2024</td>\n",
       "      <td>805673</td>\n",
       "      <td>Zebby Matthews</td>\n",
       "      <td>24</td>\n",
       "      <td>177</td>\n",
       "      <td>0.242938</td>\n",
       "      <td>627</td>\n",
       "      <td>37.2</td>\n",
       "      <td>...</td>\n",
       "      <td>21</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>34</td>\n",
       "      <td>0.209</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1892 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      PlayerId Team  Season  MLBAMID            Name  Age  TBF        K%  \\\n",
       "1106     18655  ATL    2021   621345     A.J. Minter   27  221  0.257919   \n",
       "1107     18655  ATL    2022   621345     A.J. Minter   28  271  0.346863   \n",
       "1108     18655  ATL    2023   621345     A.J. Minter   29  260  0.315385   \n",
       "1109     18655  ATL    2024   621345     A.J. Minter   30  134  0.261194   \n",
       "1177     19343  OAK    2022   640462        A.J. Puk   27  281  0.270463   \n",
       "...        ...  ...     ...      ...             ...  ...  ...       ...   \n",
       "248      10310  PHI    2021   554430    Zack Wheeler   31  849  0.290931   \n",
       "249      10310  PHI    2022   554430    Zack Wheeler   32  607  0.268534   \n",
       "250      10310  PHI    2023   554430    Zack Wheeler   33  787  0.269377   \n",
       "251      10310  PHI    2024   554430    Zack Wheeler   34  787  0.284625   \n",
       "1880     31827  MIN    2024   805673  Zebby Matthews   24  177  0.242938   \n",
       "\n",
       "        Rk     IP  ...  02s  02h  L/SO  S/SO  L/SO%  3pK  4pW  PAu  Pitu  Stru  \n",
       "1106   696   52.1  ...   44    7    11    46  0.193   11    4    0     0     0  \n",
       "1107   649   70.0  ...   50    2    23    71  0.245   12    0    0     0     0  \n",
       "1108   647   64.2  ...   40    4    13    69  0.159    8    1    0     0     0  \n",
       "1109   676   34.1  ...   20    1     7    28  0.200    6    3    0     0     0  \n",
       "1177   773   66.1  ...   48    6    22    54  0.289   15    4    0     0     0  \n",
       "...    ...    ...  ...  ...  ...   ...   ...    ...  ...  ...  ...   ...   ...  \n",
       "248   1107  213.1  ...  155   15    70   176  0.283   50    6    0     0     0  \n",
       "249   1037  153.0  ...   87    5    39   124  0.239   27    2    0     0     0  \n",
       "250   1023  192.0  ...  121    8    41   170  0.194   43    3    0     0     0  \n",
       "251   1043  200.0  ...  132   11    71   153  0.317   39   10    0     0     0  \n",
       "1880   627   37.2  ...   21    5     9    34  0.209    5    1    0     0     0  \n",
       "\n",
       "[1892 rows x 39 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged = (\n",
    "    provided_data.merge(\n",
    "        supplemental_data,\n",
    "        left_on=[\"Name\", \"Season\", \"Age\", \"Team\"],\n",
    "        right_on=[\"Name\", \"Season\", \"Age\", \"Tm\"],\n",
    "        how=\"left\",\n",
    "    )\n",
    "    # Ensure top TOT is taken from supplemental data\n",
    "    .groupby([\"PlayerId\", \"Team\", \"Season\"])\n",
    "    .first()\n",
    "    .reset_index()\n",
    "    .drop(\"Tm\", axis=1)\n",
    "    .reset_index(drop=True)\n",
    "    .sort_values([\"Name\", \"Season\", \"Team\"])\n",
    ")\n",
    "merged"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "d9b5bdf2-0dd6-4917-8bd9-15f95ffd13c1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((1892, 8), (1892, 39))"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "provided_data.shape, merged.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "bbd1654a-0093-4767-bb01-51eb285d938f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "provided_data.shape[0] == merged.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "57ab0d34-c889-45c5-8a25-cb8835e70b83",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>PlayerId</th>\n",
       "      <th>Team</th>\n",
       "      <th>Season</th>\n",
       "      <th>MLBAMID</th>\n",
       "      <th>Name</th>\n",
       "      <th>Age</th>\n",
       "      <th>TBF</th>\n",
       "      <th>K%</th>\n",
       "      <th>Rk</th>\n",
       "      <th>IP</th>\n",
       "      <th>...</th>\n",
       "      <th>02s</th>\n",
       "      <th>02h</th>\n",
       "      <th>L/SO</th>\n",
       "      <th>S/SO</th>\n",
       "      <th>L/SO%</th>\n",
       "      <th>3pK</th>\n",
       "      <th>4pW</th>\n",
       "      <th>PAu</th>\n",
       "      <th>Pitu</th>\n",
       "      <th>Stru</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1213</th>\n",
       "      <td>19444</td>\n",
       "      <td>- - -</td>\n",
       "      <td>2022</td>\n",
       "      <td>670990</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>27</td>\n",
       "      <td>167</td>\n",
       "      <td>0.191617</td>\n",
       "      <td>784</td>\n",
       "      <td>37.1</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>0.375</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1214</th>\n",
       "      <td>19444</td>\n",
       "      <td>- - -</td>\n",
       "      <td>2023</td>\n",
       "      <td>670990</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>28</td>\n",
       "      <td>176</td>\n",
       "      <td>0.198864</td>\n",
       "      <td>770</td>\n",
       "      <td>38.1</td>\n",
       "      <td>...</td>\n",
       "      <td>19</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>0.343</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1215</th>\n",
       "      <td>19444</td>\n",
       "      <td>- - -</td>\n",
       "      <td>2024</td>\n",
       "      <td>670990</td>\n",
       "      <td>Yohan Ramírez</td>\n",
       "      <td>29</td>\n",
       "      <td>208</td>\n",
       "      <td>0.216346</td>\n",
       "      <td>794</td>\n",
       "      <td>44.9</td>\n",
       "      <td>...</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>36</td>\n",
       "      <td>0.200</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      PlayerId   Team  Season  MLBAMID           Name  Age  TBF        K%  \\\n",
       "1213     19444  - - -    2022   670990  Yohan Ramírez   27  167  0.191617   \n",
       "1214     19444  - - -    2023   670990  Yohan Ramírez   28  176  0.198864   \n",
       "1215     19444  - - -    2024   670990  Yohan Ramírez   29  208  0.216346   \n",
       "\n",
       "       Rk    IP  ...  02s  02h  L/SO  S/SO  L/SO%  3pK  4pW  PAu  Pitu  Stru  \n",
       "1213  784  37.1  ...   26    3    12    20  0.375    7    1    0     0     0  \n",
       "1214  770  38.1  ...   19    5    12    23  0.343    4    5    0     0     0  \n",
       "1215  794  44.9  ...   30    1     9    36  0.200   10    5    0     0     0  \n",
       "\n",
       "[3 rows x 39 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged[merged.Name == \"Yohan Ramírez\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "b86b9a88-902f-4a41-b14d-3d7359641c69",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.duplicated().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "97438f49-2378-49d2-a012-eb2dfe2dbd6b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PlayerId      int64\n",
       "Team         object\n",
       "Season        int64\n",
       "MLBAMID       int64\n",
       "Name         object\n",
       "Age           int64\n",
       "TBF           int64\n",
       "K%          float64\n",
       "Rk            int64\n",
       "IP          float64\n",
       "PA            int64\n",
       "Pit           int64\n",
       "Pit/PA      float64\n",
       "Str           int64\n",
       "Str%        float64\n",
       "L/Str       float64\n",
       "S/Str       float64\n",
       "F/Str       float64\n",
       "I/Str       float64\n",
       "AS/Str      float64\n",
       "I/Bll       float64\n",
       "AS/Pit      float64\n",
       "Con         float64\n",
       "1st%        float64\n",
       "30%         float64\n",
       "30c           int64\n",
       "30s           int64\n",
       "02%         float64\n",
       "02c           int64\n",
       "02s           int64\n",
       "02h           int64\n",
       "L/SO          int64\n",
       "S/SO          int64\n",
       "L/SO%       float64\n",
       "3pK           int64\n",
       "4pW           int64\n",
       "PAu           int64\n",
       "Pitu          int64\n",
       "Stru          int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cf7e2ba6-0035-4b86-94ad-946183f2a0a1",
   "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
}