test_sdk.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tip 4 - Provide an Python SDK"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>player_id</th>\n",
       "      <th>gsis_id</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>position</th>\n",
       "      <th>last_changed_date</th>\n",
       "      <th>performances</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1001</td>\n",
       "      <td>00-0023459</td>\n",
       "      <td>Aaron</td>\n",
       "      <td>Rodgers</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2501, 'player_id': 1001, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1002</td>\n",
       "      <td>00-0023853</td>\n",
       "      <td>Matt</td>\n",
       "      <td>Prater</td>\n",
       "      <td>K</td>\n",
       "      <td>2024-04-18</td>\n",
       "      <td>[{'performance_id': 2502, 'player_id': 1002, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1003</td>\n",
       "      <td>00-0024243</td>\n",
       "      <td>Marcedes</td>\n",
       "      <td>Lewis</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-04-18</td>\n",
       "      <td>[{'performance_id': 2503, 'player_id': 1003, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1004</td>\n",
       "      <td>00-0025565</td>\n",
       "      <td>Nick</td>\n",
       "      <td>Folk</td>\n",
       "      <td>K</td>\n",
       "      <td>2024-04-18</td>\n",
       "      <td>[{'performance_id': 2504, 'player_id': 1004, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1005</td>\n",
       "      <td>00-0025580</td>\n",
       "      <td>Mason</td>\n",
       "      <td>Crosby</td>\n",
       "      <td>K</td>\n",
       "      <td>2024-04-18</td>\n",
       "      <td>[{'performance_id': 2505, 'player_id': 1005, '...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>1096</td>\n",
       "      <td>00-0032392</td>\n",
       "      <td>Austin</td>\n",
       "      <td>Hooper</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2596, 'player_id': 1096, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>1097</td>\n",
       "      <td>00-0032394</td>\n",
       "      <td>Nick</td>\n",
       "      <td>Vannett</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-04-18</td>\n",
       "      <td>[{'performance_id': 2597, 'player_id': 1097, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>1098</td>\n",
       "      <td>00-0032398</td>\n",
       "      <td>Chris</td>\n",
       "      <td>Moore</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-04-18</td>\n",
       "      <td>[{'performance_id': 2598, 'player_id': 1098, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>1099</td>\n",
       "      <td>00-0032434</td>\n",
       "      <td>Brandon</td>\n",
       "      <td>Allen</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-04-18</td>\n",
       "      <td>[{'performance_id': 2599, 'player_id': 1099, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>1100</td>\n",
       "      <td>00-0032436</td>\n",
       "      <td>Jeff</td>\n",
       "      <td>Driskel</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-04-18</td>\n",
       "      <td>[{'performance_id': 2600, 'player_id': 1100, '...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    player_id     gsis_id first_name last_name position last_changed_date  \\\n",
       "0        1001  00-0023459      Aaron   Rodgers       QB        2024-10-01   \n",
       "1        1002  00-0023853       Matt    Prater        K        2024-04-18   \n",
       "2        1003  00-0024243   Marcedes     Lewis       TE        2024-04-18   \n",
       "3        1004  00-0025565       Nick      Folk        K        2024-04-18   \n",
       "4        1005  00-0025580      Mason    Crosby        K        2024-04-18   \n",
       "..        ...         ...        ...       ...      ...               ...   \n",
       "95       1096  00-0032392     Austin    Hooper       TE        2024-10-01   \n",
       "96       1097  00-0032394       Nick   Vannett       TE        2024-04-18   \n",
       "97       1098  00-0032398      Chris     Moore       WR        2024-04-18   \n",
       "98       1099  00-0032434    Brandon     Allen       QB        2024-04-18   \n",
       "99       1100  00-0032436       Jeff   Driskel       QB        2024-04-18   \n",
       "\n",
       "                                         performances  \n",
       "0   [{'performance_id': 2501, 'player_id': 1001, '...  \n",
       "1   [{'performance_id': 2502, 'player_id': 1002, '...  \n",
       "2   [{'performance_id': 2503, 'player_id': 1003, '...  \n",
       "3   [{'performance_id': 2504, 'player_id': 1004, '...  \n",
       "4   [{'performance_id': 2505, 'player_id': 1005, '...  \n",
       "..                                                ...  \n",
       "95  [{'performance_id': 2596, 'player_id': 1096, '...  \n",
       "96  [{'performance_id': 2597, 'player_id': 1097, '...  \n",
       "97  [{'performance_id': 2598, 'player_id': 1098, '...  \n",
       "98  [{'performance_id': 2599, 'player_id': 1099, '...  \n",
       "99  [{'performance_id': 2600, 'player_id': 1100, '...  \n",
       "\n",
       "[100 rows x 7 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "\n",
    "from swcpy import SWCClient, SWCConfig\n",
    "import pandas as pd\n",
    "import os\n",
    "\n",
    "api_base_url = os.getenv('API_BASE_URL')\n",
    "config = SWCConfig(url=api_base_url,backoff=False)\n",
    "client = SWCClient(config)\n",
    "\n",
    "#get all players from API\n",
    "sdk_players = client.list_players()\n",
    "\n",
    "#convert the list of players instances to dictionaries\n",
    "df = pd.DataFrame([player.model_dump() for player in sdk_players])\n",
    "display(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Tip 5 - Provide Bulk Files with SDK"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#get a list of players from bulk file\n",
    "player_file = client.get_bulk_player_file()\n",
    "\n",
    "#write the file to disk to verify file download\n",
    "output_file_path = 'players_file.csv' \n",
    "with open(output_file_path, 'wb') as f:\n",
    "    f.write(player_file)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Tip  6 - Last Changed Date with SDK"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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>player_id</th>\n",
       "      <th>gsis_id</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>position</th>\n",
       "      <th>last_changed_date</th>\n",
       "      <th>performances</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1001</td>\n",
       "      <td>00-0023459</td>\n",
       "      <td>Aaron</td>\n",
       "      <td>Rodgers</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2501, 'player_id': 1001, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1016</td>\n",
       "      <td>00-0027973</td>\n",
       "      <td>Andy</td>\n",
       "      <td>Dalton</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2516, 'player_id': 1016, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1032</td>\n",
       "      <td>00-0030035</td>\n",
       "      <td>Adam</td>\n",
       "      <td>Thielen</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2532, 'player_id': 1032, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1055</td>\n",
       "      <td>00-0031288</td>\n",
       "      <td>AJ</td>\n",
       "      <td>McCarron</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2555, 'player_id': 1055, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1062</td>\n",
       "      <td>00-0031428</td>\n",
       "      <td>Allen</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2562, 'player_id': 1062, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1066</td>\n",
       "      <td>00-0031544</td>\n",
       "      <td>Amari</td>\n",
       "      <td>Cooper</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2566, 'player_id': 1066, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1079</td>\n",
       "      <td>00-0032009</td>\n",
       "      <td>Adam</td>\n",
       "      <td>Humphries</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2579, 'player_id': 1079, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1082</td>\n",
       "      <td>00-0032104</td>\n",
       "      <td>Ameer</td>\n",
       "      <td>Abdullah</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2582, 'player_id': 1082, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1096</td>\n",
       "      <td>00-0032392</td>\n",
       "      <td>Austin</td>\n",
       "      <td>Hooper</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2596, 'player_id': 1096, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1103</td>\n",
       "      <td>00-0032543</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Erickson</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2603, 'player_id': 1103, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1137</td>\n",
       "      <td>00-0033293</td>\n",
       "      <td>Aaron</td>\n",
       "      <td>Jones</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2637, 'player_id': 1137, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1138</td>\n",
       "      <td>00-0033296</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Armah</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2638, 'player_id': 1138, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1148</td>\n",
       "      <td>00-0033455</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Firkser</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2648, 'player_id': 1148, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1167</td>\n",
       "      <td>00-0033699</td>\n",
       "      <td>Austin</td>\n",
       "      <td>Ekeler</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2667, 'player_id': 1167, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1189</td>\n",
       "      <td>00-0033906</td>\n",
       "      <td>Alvin</td>\n",
       "      <td>Kamara</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2689, 'player_id': 1189, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1224</td>\n",
       "      <td>00-0034353</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Miller</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2724, 'player_id': 1224, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1246</td>\n",
       "      <td>00-0034521</td>\n",
       "      <td>Allen</td>\n",
       "      <td>Lazard</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2746, 'player_id': 1246, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1257</td>\n",
       "      <td>00-0034732</td>\n",
       "      <td>Alex</td>\n",
       "      <td>McGough</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2757, 'player_id': 1257, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1289</td>\n",
       "      <td>00-0034959</td>\n",
       "      <td>Andrew</td>\n",
       "      <td>Beck</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2789, 'player_id': 1289, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1293</td>\n",
       "      <td>00-0034972</td>\n",
       "      <td>Alexander</td>\n",
       "      <td>Mattison</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2793, 'player_id': 1293, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1298</td>\n",
       "      <td>00-0035021</td>\n",
       "      <td>Ashton</td>\n",
       "      <td>Dulin</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2798, 'player_id': 1298, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1308</td>\n",
       "      <td>00-0035125</td>\n",
       "      <td>Alec</td>\n",
       "      <td>Ingold</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2808, 'player_id': 1308, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1309</td>\n",
       "      <td>00-0035126</td>\n",
       "      <td>Antoine</td>\n",
       "      <td>Wesley</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2809, 'player_id': 1309, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1311</td>\n",
       "      <td>00-0035145</td>\n",
       "      <td>Austin</td>\n",
       "      <td>Seibert</td>\n",
       "      <td>K</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2811, 'player_id': 1311, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1317</td>\n",
       "      <td>00-0035187</td>\n",
       "      <td>Austin</td>\n",
       "      <td>Walter</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2817, 'player_id': 1317, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1343</td>\n",
       "      <td>00-0035309</td>\n",
       "      <td>Alize</td>\n",
       "      <td>Mack</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2843, 'player_id': 1343, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1361</td>\n",
       "      <td>00-0035527</td>\n",
       "      <td>Andy</td>\n",
       "      <td>Isabella</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2861, 'player_id': 1361, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1373</td>\n",
       "      <td>00-0035602</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Bachman</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2873, 'player_id': 1373, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1388</td>\n",
       "      <td>00-0035676</td>\n",
       "      <td>A.J.</td>\n",
       "      <td>Brown</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2888, 'player_id': 1388, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1411</td>\n",
       "      <td>00-0035876</td>\n",
       "      <td>Andre</td>\n",
       "      <td>Baccellia</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2911, 'player_id': 1411, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1464</td>\n",
       "      <td>00-0036265</td>\n",
       "      <td>AJ</td>\n",
       "      <td>Dillon</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2964, 'player_id': 1464, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1477</td>\n",
       "      <td>00-0036328</td>\n",
       "      <td>Antonio</td>\n",
       "      <td>Gibson</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2977, 'player_id': 1477, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1480</td>\n",
       "      <td>00-0036336</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>McFarland</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2980, 'player_id': 1480, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1498</td>\n",
       "      <td>00-0036422</td>\n",
       "      <td>Adam</td>\n",
       "      <td>Trautman</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2998, 'player_id': 1498, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1499</td>\n",
       "      <td>00-0036423</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Okwuegbunam</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 2999, 'player_id': 1499, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1555</td>\n",
       "      <td>00-0036676</td>\n",
       "      <td>Austin</td>\n",
       "      <td>Watkins Jr.</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3055, 'player_id': 1555, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1559</td>\n",
       "      <td>00-0036727</td>\n",
       "      <td>Adam</td>\n",
       "      <td>Prentice</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3059, 'player_id': 1559, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1570</td>\n",
       "      <td>00-0036841</td>\n",
       "      <td>Austin</td>\n",
       "      <td>Trammell</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3070, 'player_id': 1570, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1600</td>\n",
       "      <td>00-0036950</td>\n",
       "      <td>Avery</td>\n",
       "      <td>Williams</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3100, 'player_id': 1600, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1604</td>\n",
       "      <td>00-0036963</td>\n",
       "      <td>Amon-Ra</td>\n",
       "      <td>St. Brown</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3104, 'player_id': 1604, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>1612</td>\n",
       "      <td>00-0036991</td>\n",
       "      <td>Amari</td>\n",
       "      <td>Rodgers</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3112, 'player_id': 1612, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1614</td>\n",
       "      <td>00-0036999</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Schwartz</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3114, 'player_id': 1614, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>1642</td>\n",
       "      <td>00-0037168</td>\n",
       "      <td>Armani</td>\n",
       "      <td>Rogers</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3142, 'player_id': 1642, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>1646</td>\n",
       "      <td>00-0037175</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Brown</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3146, 'player_id': 1646, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1675</td>\n",
       "      <td>00-0037292</td>\n",
       "      <td>Andrew</td>\n",
       "      <td>Ogletree</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3175, 'player_id': 1675, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>1694</td>\n",
       "      <td>00-0037369</td>\n",
       "      <td>Austin</td>\n",
       "      <td>Allen</td>\n",
       "      <td>TE</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3194, 'player_id': 1694, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>1724</td>\n",
       "      <td>00-0037546</td>\n",
       "      <td>Abram</td>\n",
       "      <td>Smith</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3224, 'player_id': 1724, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>1736</td>\n",
       "      <td>00-0037609</td>\n",
       "      <td>Aaron</td>\n",
       "      <td>Shampklin</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3236, 'player_id': 1736, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>1740</td>\n",
       "      <td>00-0037664</td>\n",
       "      <td>Alec</td>\n",
       "      <td>Pierce</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3240, 'player_id': 1740, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>1802</td>\n",
       "      <td>00-0038402</td>\n",
       "      <td>Anders</td>\n",
       "      <td>Carlson</td>\n",
       "      <td>K</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3302, 'player_id': 1802, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>1807</td>\n",
       "      <td>00-0038422</td>\n",
       "      <td>Aron</td>\n",
       "      <td>Cruickshank</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3307, 'player_id': 1807, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>1854</td>\n",
       "      <td>00-0038579</td>\n",
       "      <td>Aidan</td>\n",
       "      <td>O'Connell</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3354, 'player_id': 1854, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>1864</td>\n",
       "      <td>00-0038612</td>\n",
       "      <td>A.T.</td>\n",
       "      <td>Perry</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3364, 'player_id': 1864, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>1866</td>\n",
       "      <td>00-0038619</td>\n",
       "      <td>Andrei</td>\n",
       "      <td>Iosivas</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3366, 'player_id': 1866, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>1869</td>\n",
       "      <td>00-0038627</td>\n",
       "      <td>Antoine</td>\n",
       "      <td>Green</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3369, 'player_id': 1869, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>1879</td>\n",
       "      <td>00-0038658</td>\n",
       "      <td>Adrian</td>\n",
       "      <td>Martinez</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3379, 'player_id': 1879, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>1972</td>\n",
       "      <td>00-0038957</td>\n",
       "      <td>Alfonzo</td>\n",
       "      <td>Graham</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3472, 'player_id': 1972, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2012</td>\n",
       "      <td>00-0039164</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Richardson</td>\n",
       "      <td>QB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3512, 'player_id': 2012, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2016</td>\n",
       "      <td>00-0039186</td>\n",
       "      <td>Avery</td>\n",
       "      <td>Davis</td>\n",
       "      <td>WR</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3516, 'player_id': 2016, '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2018</td>\n",
       "      <td>00-0039191</td>\n",
       "      <td>Aaron</td>\n",
       "      <td>Dykes</td>\n",
       "      <td>RB</td>\n",
       "      <td>2024-10-01</td>\n",
       "      <td>[{'performance_id': 3518, 'player_id': 2018, '...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    player_id     gsis_id first_name    last_name position last_changed_date  \\\n",
       "0        1001  00-0023459      Aaron      Rodgers       QB        2024-10-01   \n",
       "1        1016  00-0027973       Andy       Dalton       QB        2024-10-01   \n",
       "2        1032  00-0030035       Adam      Thielen       WR        2024-10-01   \n",
       "3        1055  00-0031288         AJ     McCarron       QB        2024-10-01   \n",
       "4        1062  00-0031428      Allen     Robinson       WR        2024-10-01   \n",
       "5        1066  00-0031544      Amari       Cooper       WR        2024-10-01   \n",
       "6        1079  00-0032009       Adam    Humphries       WR        2024-10-01   \n",
       "7        1082  00-0032104      Ameer     Abdullah       RB        2024-10-01   \n",
       "8        1096  00-0032392     Austin       Hooper       TE        2024-10-01   \n",
       "9        1103  00-0032543       Alex     Erickson       WR        2024-10-01   \n",
       "10       1137  00-0033293      Aaron        Jones       RB        2024-10-01   \n",
       "11       1138  00-0033296       Alex        Armah       RB        2024-10-01   \n",
       "12       1148  00-0033455    Anthony      Firkser       TE        2024-10-01   \n",
       "13       1167  00-0033699     Austin       Ekeler       RB        2024-10-01   \n",
       "14       1189  00-0033906      Alvin       Kamara       RB        2024-10-01   \n",
       "15       1224  00-0034353    Anthony       Miller       WR        2024-10-01   \n",
       "16       1246  00-0034521      Allen       Lazard       WR        2024-10-01   \n",
       "17       1257  00-0034732       Alex      McGough       QB        2024-10-01   \n",
       "18       1289  00-0034959     Andrew         Beck       RB        2024-10-01   \n",
       "19       1293  00-0034972  Alexander     Mattison       RB        2024-10-01   \n",
       "20       1298  00-0035021     Ashton        Dulin       WR        2024-10-01   \n",
       "21       1308  00-0035125       Alec       Ingold       RB        2024-10-01   \n",
       "22       1309  00-0035126    Antoine       Wesley       WR        2024-10-01   \n",
       "23       1311  00-0035145     Austin      Seibert        K        2024-10-01   \n",
       "24       1317  00-0035187     Austin       Walter       RB        2024-10-01   \n",
       "25       1343  00-0035309      Alize         Mack       TE        2024-10-01   \n",
       "26       1361  00-0035527       Andy     Isabella       WR        2024-10-01   \n",
       "27       1373  00-0035602       Alex      Bachman       WR        2024-10-01   \n",
       "28       1388  00-0035676       A.J.        Brown       WR        2024-10-01   \n",
       "29       1411  00-0035876      Andre    Baccellia       WR        2024-10-01   \n",
       "30       1464  00-0036265         AJ       Dillon       RB        2024-10-01   \n",
       "31       1477  00-0036328    Antonio       Gibson       RB        2024-10-01   \n",
       "32       1480  00-0036336    Anthony    McFarland       RB        2024-10-01   \n",
       "33       1498  00-0036422       Adam     Trautman       TE        2024-10-01   \n",
       "34       1499  00-0036423     Albert  Okwuegbunam       TE        2024-10-01   \n",
       "35       1555  00-0036676     Austin  Watkins Jr.       WR        2024-10-01   \n",
       "36       1559  00-0036727       Adam     Prentice       RB        2024-10-01   \n",
       "37       1570  00-0036841     Austin     Trammell       WR        2024-10-01   \n",
       "38       1600  00-0036950      Avery     Williams       RB        2024-10-01   \n",
       "39       1604  00-0036963    Amon-Ra    St. Brown       WR        2024-10-01   \n",
       "40       1612  00-0036991      Amari      Rodgers       WR        2024-10-01   \n",
       "41       1614  00-0036999    Anthony     Schwartz       WR        2024-10-01   \n",
       "42       1642  00-0037168     Armani       Rogers       TE        2024-10-01   \n",
       "43       1646  00-0037175    Anthony        Brown       QB        2024-10-01   \n",
       "44       1675  00-0037292     Andrew     Ogletree       TE        2024-10-01   \n",
       "45       1694  00-0037369     Austin        Allen       TE        2024-10-01   \n",
       "46       1724  00-0037546      Abram        Smith       RB        2024-10-01   \n",
       "47       1736  00-0037609      Aaron    Shampklin       RB        2024-10-01   \n",
       "48       1740  00-0037664       Alec       Pierce       WR        2024-10-01   \n",
       "49       1802  00-0038402     Anders      Carlson        K        2024-10-01   \n",
       "50       1807  00-0038422       Aron  Cruickshank       WR        2024-10-01   \n",
       "51       1854  00-0038579      Aidan    O'Connell       QB        2024-10-01   \n",
       "52       1864  00-0038612       A.T.        Perry       WR        2024-10-01   \n",
       "53       1866  00-0038619     Andrei      Iosivas       WR        2024-10-01   \n",
       "54       1869  00-0038627    Antoine        Green       WR        2024-10-01   \n",
       "55       1879  00-0038658     Adrian     Martinez       QB        2024-10-01   \n",
       "56       1972  00-0038957    Alfonzo       Graham       RB        2024-10-01   \n",
       "57       2012  00-0039164    Anthony   Richardson       QB        2024-10-01   \n",
       "58       2016  00-0039186      Avery        Davis       WR        2024-10-01   \n",
       "59       2018  00-0039191      Aaron        Dykes       RB        2024-10-01   \n",
       "\n",
       "                                         performances  \n",
       "0   [{'performance_id': 2501, 'player_id': 1001, '...  \n",
       "1   [{'performance_id': 2516, 'player_id': 1016, '...  \n",
       "2   [{'performance_id': 2532, 'player_id': 1032, '...  \n",
       "3   [{'performance_id': 2555, 'player_id': 1055, '...  \n",
       "4   [{'performance_id': 2562, 'player_id': 1062, '...  \n",
       "5   [{'performance_id': 2566, 'player_id': 1066, '...  \n",
       "6   [{'performance_id': 2579, 'player_id': 1079, '...  \n",
       "7   [{'performance_id': 2582, 'player_id': 1082, '...  \n",
       "8   [{'performance_id': 2596, 'player_id': 1096, '...  \n",
       "9   [{'performance_id': 2603, 'player_id': 1103, '...  \n",
       "10  [{'performance_id': 2637, 'player_id': 1137, '...  \n",
       "11  [{'performance_id': 2638, 'player_id': 1138, '...  \n",
       "12  [{'performance_id': 2648, 'player_id': 1148, '...  \n",
       "13  [{'performance_id': 2667, 'player_id': 1167, '...  \n",
       "14  [{'performance_id': 2689, 'player_id': 1189, '...  \n",
       "15  [{'performance_id': 2724, 'player_id': 1224, '...  \n",
       "16  [{'performance_id': 2746, 'player_id': 1246, '...  \n",
       "17  [{'performance_id': 2757, 'player_id': 1257, '...  \n",
       "18  [{'performance_id': 2789, 'player_id': 1289, '...  \n",
       "19  [{'performance_id': 2793, 'player_id': 1293, '...  \n",
       "20  [{'performance_id': 2798, 'player_id': 1298, '...  \n",
       "21  [{'performance_id': 2808, 'player_id': 1308, '...  \n",
       "22  [{'performance_id': 2809, 'player_id': 1309, '...  \n",
       "23  [{'performance_id': 2811, 'player_id': 1311, '...  \n",
       "24  [{'performance_id': 2817, 'player_id': 1317, '...  \n",
       "25  [{'performance_id': 2843, 'player_id': 1343, '...  \n",
       "26  [{'performance_id': 2861, 'player_id': 1361, '...  \n",
       "27  [{'performance_id': 2873, 'player_id': 1373, '...  \n",
       "28  [{'performance_id': 2888, 'player_id': 1388, '...  \n",
       "29  [{'performance_id': 2911, 'player_id': 1411, '...  \n",
       "30  [{'performance_id': 2964, 'player_id': 1464, '...  \n",
       "31  [{'performance_id': 2977, 'player_id': 1477, '...  \n",
       "32  [{'performance_id': 2980, 'player_id': 1480, '...  \n",
       "33  [{'performance_id': 2998, 'player_id': 1498, '...  \n",
       "34  [{'performance_id': 2999, 'player_id': 1499, '...  \n",
       "35  [{'performance_id': 3055, 'player_id': 1555, '...  \n",
       "36  [{'performance_id': 3059, 'player_id': 1559, '...  \n",
       "37  [{'performance_id': 3070, 'player_id': 1570, '...  \n",
       "38  [{'performance_id': 3100, 'player_id': 1600, '...  \n",
       "39  [{'performance_id': 3104, 'player_id': 1604, '...  \n",
       "40  [{'performance_id': 3112, 'player_id': 1612, '...  \n",
       "41  [{'performance_id': 3114, 'player_id': 1614, '...  \n",
       "42  [{'performance_id': 3142, 'player_id': 1642, '...  \n",
       "43  [{'performance_id': 3146, 'player_id': 1646, '...  \n",
       "44  [{'performance_id': 3175, 'player_id': 1675, '...  \n",
       "45  [{'performance_id': 3194, 'player_id': 1694, '...  \n",
       "46  [{'performance_id': 3224, 'player_id': 1724, '...  \n",
       "47  [{'performance_id': 3236, 'player_id': 1736, '...  \n",
       "48  [{'performance_id': 3240, 'player_id': 1740, '...  \n",
       "49  [{'performance_id': 3302, 'player_id': 1802, '...  \n",
       "50  [{'performance_id': 3307, 'player_id': 1807, '...  \n",
       "51  [{'performance_id': 3354, 'player_id': 1854, '...  \n",
       "52  [{'performance_id': 3364, 'player_id': 1864, '...  \n",
       "53  [{'performance_id': 3366, 'player_id': 1866, '...  \n",
       "54  [{'performance_id': 3369, 'player_id': 1869, '...  \n",
       "55  [{'performance_id': 3379, 'player_id': 1879, '...  \n",
       "56  [{'performance_id': 3472, 'player_id': 1972, '...  \n",
       "57  [{'performance_id': 3512, 'player_id': 2012, '...  \n",
       "58  [{'performance_id': 3516, 'player_id': 2016, '...  \n",
       "59  [{'performance_id': 3518, 'player_id': 2018, '...  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#get players from sdk with last changed date\n",
    "sdk_players = client.list_players(minimum_last_changed_date=\"2024-09-15\")\n",
    "\n",
    "#convert the list of players instances to dictionaries\n",
    "df = pd.DataFrame([player.model_dump() for player in sdk_players])\n",
    "display(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}