New Team Names.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Team names to be renamed to.\n",
    "\n",
    "-Kwasie Agbemadon :)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "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>Team</th>\n",
       "      <th>Position</th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Overall Rating</th>\n",
       "      <th>Jersey Number</th>\n",
       "      <th>Awareness</th>\n",
       "      <th>Speed</th>\n",
       "      <th>Acceleration</th>\n",
       "      <th>Agility</th>\n",
       "      <th>Jumping</th>\n",
       "      <th>...</th>\n",
       "      <th>Archetype</th>\n",
       "      <th>First Name</th>\n",
       "      <th>Last Name</th>\n",
       "      <th>Years Pro</th>\n",
       "      <th>Age</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>College</th>\n",
       "      <th>Player Portrait</th>\n",
       "      <th>Primary Key</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Rams</td>\n",
       "      <td>RE</td>\n",
       "      <td>Aaron Donald</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>82</td>\n",
       "      <td>90</td>\n",
       "      <td>86</td>\n",
       "      <td>78</td>\n",
       "      <td>...</td>\n",
       "      <td>DE_PowerRusher</td>\n",
       "      <td>Aaron</td>\n",
       "      <td>Donald</td>\n",
       "      <td>8</td>\n",
       "      <td>31</td>\n",
       "      <td>73</td>\n",
       "      <td>280</td>\n",
       "      <td>Pittsburgh</td>\n",
       "      <td>6394</td>\n",
       "      <td>10852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raiders</td>\n",
       "      <td>WR</td>\n",
       "      <td>Davante Adams</td>\n",
       "      <td>99</td>\n",
       "      <td>17</td>\n",
       "      <td>99</td>\n",
       "      <td>90</td>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>96</td>\n",
       "      <td>...</td>\n",
       "      <td>WR_DeepThreat</td>\n",
       "      <td>Davante</td>\n",
       "      <td>Adams</td>\n",
       "      <td>8</td>\n",
       "      <td>29</td>\n",
       "      <td>73</td>\n",
       "      <td>215</td>\n",
       "      <td>Fresno State</td>\n",
       "      <td>6328</td>\n",
       "      <td>10823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Browns</td>\n",
       "      <td>RE</td>\n",
       "      <td>Myles Garrett</td>\n",
       "      <td>99</td>\n",
       "      <td>95</td>\n",
       "      <td>98</td>\n",
       "      <td>88</td>\n",
       "      <td>91</td>\n",
       "      <td>85</td>\n",
       "      <td>92</td>\n",
       "      <td>...</td>\n",
       "      <td>DE_PowerRusher</td>\n",
       "      <td>Myles</td>\n",
       "      <td>Garrett</td>\n",
       "      <td>5</td>\n",
       "      <td>26</td>\n",
       "      <td>76</td>\n",
       "      <td>272</td>\n",
       "      <td>Texas AM</td>\n",
       "      <td>8560</td>\n",
       "      <td>12520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>49ers</td>\n",
       "      <td>LT</td>\n",
       "      <td>Trent Williams</td>\n",
       "      <td>99</td>\n",
       "      <td>71</td>\n",
       "      <td>99</td>\n",
       "      <td>76</td>\n",
       "      <td>74</td>\n",
       "      <td>73</td>\n",
       "      <td>83</td>\n",
       "      <td>...</td>\n",
       "      <td>OT_Power</td>\n",
       "      <td>Trent</td>\n",
       "      <td>Williams</td>\n",
       "      <td>12</td>\n",
       "      <td>34</td>\n",
       "      <td>77</td>\n",
       "      <td>320</td>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>3231</td>\n",
       "      <td>9800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Rams</td>\n",
       "      <td>WR</td>\n",
       "      <td>Cooper Kupp</td>\n",
       "      <td>98</td>\n",
       "      <td>10</td>\n",
       "      <td>99</td>\n",
       "      <td>89</td>\n",
       "      <td>96</td>\n",
       "      <td>95</td>\n",
       "      <td>82</td>\n",
       "      <td>...</td>\n",
       "      <td>WR_Slot</td>\n",
       "      <td>Cooper</td>\n",
       "      <td>Kupp</td>\n",
       "      <td>5</td>\n",
       "      <td>29</td>\n",
       "      <td>74</td>\n",
       "      <td>208</td>\n",
       "      <td>Eastern Wash.</td>\n",
       "      <td>8626</td>\n",
       "      <td>12558</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>2363</th>\n",
       "      <td>Jaguars</td>\n",
       "      <td>TE</td>\n",
       "      <td>Ross Matiscik</td>\n",
       "      <td>26</td>\n",
       "      <td>46</td>\n",
       "      <td>55</td>\n",
       "      <td>71</td>\n",
       "      <td>68</td>\n",
       "      <td>69</td>\n",
       "      <td>71</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Possession</td>\n",
       "      <td>Ross</td>\n",
       "      <td>Matiscik</td>\n",
       "      <td>2</td>\n",
       "      <td>25</td>\n",
       "      <td>72</td>\n",
       "      <td>235</td>\n",
       "      <td>Baylor</td>\n",
       "      <td>1482</td>\n",
       "      <td>21400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2364</th>\n",
       "      <td>Buccaneers</td>\n",
       "      <td>TE</td>\n",
       "      <td>Zach Triner</td>\n",
       "      <td>26</td>\n",
       "      <td>97</td>\n",
       "      <td>62</td>\n",
       "      <td>76</td>\n",
       "      <td>81</td>\n",
       "      <td>69</td>\n",
       "      <td>74</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Blocking</td>\n",
       "      <td>Zach</td>\n",
       "      <td>Triner</td>\n",
       "      <td>3</td>\n",
       "      <td>31</td>\n",
       "      <td>74</td>\n",
       "      <td>247</td>\n",
       "      <td>Assumption</td>\n",
       "      <td>628</td>\n",
       "      <td>20801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2365</th>\n",
       "      <td>Patriots</td>\n",
       "      <td>TE</td>\n",
       "      <td>Joe Cardona</td>\n",
       "      <td>25</td>\n",
       "      <td>49</td>\n",
       "      <td>46</td>\n",
       "      <td>73</td>\n",
       "      <td>76</td>\n",
       "      <td>71</td>\n",
       "      <td>80</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Blocking</td>\n",
       "      <td>Joe</td>\n",
       "      <td>Cardona</td>\n",
       "      <td>7</td>\n",
       "      <td>30</td>\n",
       "      <td>75</td>\n",
       "      <td>245</td>\n",
       "      <td>Navy</td>\n",
       "      <td>7040</td>\n",
       "      <td>2605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2366</th>\n",
       "      <td>Rams</td>\n",
       "      <td>TE</td>\n",
       "      <td>Matthew Orzech</td>\n",
       "      <td>25</td>\n",
       "      <td>42</td>\n",
       "      <td>55</td>\n",
       "      <td>77</td>\n",
       "      <td>80</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Possession</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>Orzech</td>\n",
       "      <td>3</td>\n",
       "      <td>27</td>\n",
       "      <td>75</td>\n",
       "      <td>246</td>\n",
       "      <td>Azusa Pacific</td>\n",
       "      <td>1496</td>\n",
       "      <td>20842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2367</th>\n",
       "      <td>Saints</td>\n",
       "      <td>TE</td>\n",
       "      <td>Zach Wood</td>\n",
       "      <td>25</td>\n",
       "      <td>49</td>\n",
       "      <td>63</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>66</td>\n",
       "      <td>70</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Blocking</td>\n",
       "      <td>Zach</td>\n",
       "      <td>Wood</td>\n",
       "      <td>5</td>\n",
       "      <td>29</td>\n",
       "      <td>75</td>\n",
       "      <td>255</td>\n",
       "      <td>SMU</td>\n",
       "      <td>9322</td>\n",
       "      <td>12979</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2368 rows × 72 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Team Position       Full Name  Overall Rating  Jersey Number  \\\n",
       "0           Rams       RE    Aaron Donald              99             99   \n",
       "1        Raiders       WR   Davante Adams              99             17   \n",
       "2         Browns       RE   Myles Garrett              99             95   \n",
       "3          49ers       LT  Trent Williams              99             71   \n",
       "4           Rams       WR     Cooper Kupp              98             10   \n",
       "...          ...      ...             ...             ...            ...   \n",
       "2363     Jaguars       TE   Ross Matiscik              26             46   \n",
       "2364  Buccaneers       TE     Zach Triner              26             97   \n",
       "2365    Patriots       TE     Joe Cardona              25             49   \n",
       "2366        Rams       TE  Matthew Orzech              25             42   \n",
       "2367      Saints       TE       Zach Wood              25             49   \n",
       "\n",
       "      Awareness  Speed  Acceleration  Agility  Jumping  ...       Archetype  \\\n",
       "0            99     82            90       86       78  ...  DE_PowerRusher   \n",
       "1            99     90            92       95       96  ...   WR_DeepThreat   \n",
       "2            98     88            91       85       92  ...  DE_PowerRusher   \n",
       "3            99     76            74       73       83  ...        OT_Power   \n",
       "4            99     89            96       95       82  ...         WR_Slot   \n",
       "...         ...    ...           ...      ...      ...  ...             ...   \n",
       "2363         55     71            68       69       71  ...   TE_Possession   \n",
       "2364         62     76            81       69       74  ...     TE_Blocking   \n",
       "2365         46     73            76       71       80  ...     TE_Blocking   \n",
       "2366         55     77            80       78       84  ...   TE_Possession   \n",
       "2367         63     65            65       66       70  ...     TE_Blocking   \n",
       "\n",
       "      First Name  Last Name  Years Pro  Age  Height  Weight        College  \\\n",
       "0          Aaron     Donald          8   31      73     280     Pittsburgh   \n",
       "1        Davante      Adams          8   29      73     215   Fresno State   \n",
       "2          Myles    Garrett          5   26      76     272       Texas AM   \n",
       "3          Trent   Williams         12   34      77     320       Oklahoma   \n",
       "4         Cooper       Kupp          5   29      74     208  Eastern Wash.   \n",
       "...          ...        ...        ...  ...     ...     ...            ...   \n",
       "2363        Ross   Matiscik          2   25      72     235         Baylor   \n",
       "2364        Zach     Triner          3   31      74     247     Assumption   \n",
       "2365         Joe    Cardona          7   30      75     245           Navy   \n",
       "2366     Matthew     Orzech          3   27      75     246  Azusa Pacific   \n",
       "2367        Zach       Wood          5   29      75     255            SMU   \n",
       "\n",
       "      Player Portrait  Primary Key  \n",
       "0                6394        10852  \n",
       "1                6328        10823  \n",
       "2                8560        12520  \n",
       "3                3231         9800  \n",
       "4                8626        12558  \n",
       "...               ...          ...  \n",
       "2363             1482        21400  \n",
       "2364              628        20801  \n",
       "2365             7040         2605  \n",
       "2366             1496        20842  \n",
       "2367             9322        12979  \n",
       "\n",
       "[2368 rows x 72 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "ratings = pd.read_excel('madden_nfl_23_player_ratings.xlsx')\n",
    "ratings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "ratings.Team.unique()\n",
    "new_names = {'Rams': 'Los Angeles Rams', \n",
    "             'Raiders': 'Las Vegas Raiders', \n",
    "             'Browns': 'Cleveland Browns', \n",
    "             '49ers': 'San Francisco 49ers', \n",
    "             'Chiefs': 'Kansas City Chiefs', \n",
    "             'Cowboys': 'Dallas Cowboys', \n",
    "             'Titans': 'Tennessee Titans', \n",
    "             'Bucaneers': 'Tampa Bay Bucaneers', \n",
    "             'Dolphins': 'Miami Dolphins', \n",
    "             'Packers': 'Green Bay Packers', \n",
    "             'Panthers': 'Carolina Panthers', \n",
    "             'Cardinals': 'Arizona Cardinals', \n",
    "             'Steelers': 'Pittsburgh Steelers', \n",
    "             'Colts': 'Indianapolis Colts', \n",
    "             'Bills': 'Buffalo Bills', \n",
    "             'Vikings': 'Minnesota Vikings', \n",
    "             'Saints': 'New Orleans Saints', \n",
    "             'Chargers': 'Los Angeles Chargers', \n",
    "             'Bengals': 'Cicinnati Bengals', \n",
    "             'Ravens': 'Baltimore Ravens', \n",
    "             'Eagles': 'Philadelphia Eagles', \n",
    "             'Commanders': 'Washington Commanders', \n",
    "             'Broncos': 'Denver Broncos', \n",
    "             'Seahawks': 'Seattle Seahawks', \n",
    "             'Falcons': 'Atlanta Falcons', \n",
    "             'Bears': 'Chicago Bears', \n",
    "             'Lions': 'Detroit Lions', \n",
    "             'Texans': 'Houston Texans', \n",
    "             'Jaguars': 'Jacksonville Jaguars', \n",
    "             'Patriots': 'New England Patriots', \n",
    "             'Jets': 'New York Jets', \n",
    "             'Giants': 'New York Giants'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "ratings.Team.replace(new_names, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Team</th>\n",
       "      <th>Position</th>\n",
       "      <th>Full Name</th>\n",
       "      <th>Overall Rating</th>\n",
       "      <th>Jersey Number</th>\n",
       "      <th>Awareness</th>\n",
       "      <th>Speed</th>\n",
       "      <th>Acceleration</th>\n",
       "      <th>Agility</th>\n",
       "      <th>Jumping</th>\n",
       "      <th>...</th>\n",
       "      <th>Archetype</th>\n",
       "      <th>First Name</th>\n",
       "      <th>Last Name</th>\n",
       "      <th>Years Pro</th>\n",
       "      <th>Age</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>College</th>\n",
       "      <th>Player Portrait</th>\n",
       "      <th>Primary Key</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Los Angeles Rams</td>\n",
       "      <td>RE</td>\n",
       "      <td>Aaron Donald</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>99</td>\n",
       "      <td>82</td>\n",
       "      <td>90</td>\n",
       "      <td>86</td>\n",
       "      <td>78</td>\n",
       "      <td>...</td>\n",
       "      <td>DE_PowerRusher</td>\n",
       "      <td>Aaron</td>\n",
       "      <td>Donald</td>\n",
       "      <td>8</td>\n",
       "      <td>31</td>\n",
       "      <td>73</td>\n",
       "      <td>280</td>\n",
       "      <td>Pittsburgh</td>\n",
       "      <td>6394</td>\n",
       "      <td>10852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Las Vegas Raiders</td>\n",
       "      <td>WR</td>\n",
       "      <td>Davante Adams</td>\n",
       "      <td>99</td>\n",
       "      <td>17</td>\n",
       "      <td>99</td>\n",
       "      <td>90</td>\n",
       "      <td>92</td>\n",
       "      <td>95</td>\n",
       "      <td>96</td>\n",
       "      <td>...</td>\n",
       "      <td>WR_DeepThreat</td>\n",
       "      <td>Davante</td>\n",
       "      <td>Adams</td>\n",
       "      <td>8</td>\n",
       "      <td>29</td>\n",
       "      <td>73</td>\n",
       "      <td>215</td>\n",
       "      <td>Fresno State</td>\n",
       "      <td>6328</td>\n",
       "      <td>10823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Cleveland Browns</td>\n",
       "      <td>RE</td>\n",
       "      <td>Myles Garrett</td>\n",
       "      <td>99</td>\n",
       "      <td>95</td>\n",
       "      <td>98</td>\n",
       "      <td>88</td>\n",
       "      <td>91</td>\n",
       "      <td>85</td>\n",
       "      <td>92</td>\n",
       "      <td>...</td>\n",
       "      <td>DE_PowerRusher</td>\n",
       "      <td>Myles</td>\n",
       "      <td>Garrett</td>\n",
       "      <td>5</td>\n",
       "      <td>26</td>\n",
       "      <td>76</td>\n",
       "      <td>272</td>\n",
       "      <td>Texas AM</td>\n",
       "      <td>8560</td>\n",
       "      <td>12520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>San Francisco 49ers</td>\n",
       "      <td>LT</td>\n",
       "      <td>Trent Williams</td>\n",
       "      <td>99</td>\n",
       "      <td>71</td>\n",
       "      <td>99</td>\n",
       "      <td>76</td>\n",
       "      <td>74</td>\n",
       "      <td>73</td>\n",
       "      <td>83</td>\n",
       "      <td>...</td>\n",
       "      <td>OT_Power</td>\n",
       "      <td>Trent</td>\n",
       "      <td>Williams</td>\n",
       "      <td>12</td>\n",
       "      <td>34</td>\n",
       "      <td>77</td>\n",
       "      <td>320</td>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>3231</td>\n",
       "      <td>9800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Los Angeles Rams</td>\n",
       "      <td>WR</td>\n",
       "      <td>Cooper Kupp</td>\n",
       "      <td>98</td>\n",
       "      <td>10</td>\n",
       "      <td>99</td>\n",
       "      <td>89</td>\n",
       "      <td>96</td>\n",
       "      <td>95</td>\n",
       "      <td>82</td>\n",
       "      <td>...</td>\n",
       "      <td>WR_Slot</td>\n",
       "      <td>Cooper</td>\n",
       "      <td>Kupp</td>\n",
       "      <td>5</td>\n",
       "      <td>29</td>\n",
       "      <td>74</td>\n",
       "      <td>208</td>\n",
       "      <td>Eastern Wash.</td>\n",
       "      <td>8626</td>\n",
       "      <td>12558</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>2363</th>\n",
       "      <td>Jacksonville Jaguars</td>\n",
       "      <td>TE</td>\n",
       "      <td>Ross Matiscik</td>\n",
       "      <td>26</td>\n",
       "      <td>46</td>\n",
       "      <td>55</td>\n",
       "      <td>71</td>\n",
       "      <td>68</td>\n",
       "      <td>69</td>\n",
       "      <td>71</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Possession</td>\n",
       "      <td>Ross</td>\n",
       "      <td>Matiscik</td>\n",
       "      <td>2</td>\n",
       "      <td>25</td>\n",
       "      <td>72</td>\n",
       "      <td>235</td>\n",
       "      <td>Baylor</td>\n",
       "      <td>1482</td>\n",
       "      <td>21400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2364</th>\n",
       "      <td>Buccaneers</td>\n",
       "      <td>TE</td>\n",
       "      <td>Zach Triner</td>\n",
       "      <td>26</td>\n",
       "      <td>97</td>\n",
       "      <td>62</td>\n",
       "      <td>76</td>\n",
       "      <td>81</td>\n",
       "      <td>69</td>\n",
       "      <td>74</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Blocking</td>\n",
       "      <td>Zach</td>\n",
       "      <td>Triner</td>\n",
       "      <td>3</td>\n",
       "      <td>31</td>\n",
       "      <td>74</td>\n",
       "      <td>247</td>\n",
       "      <td>Assumption</td>\n",
       "      <td>628</td>\n",
       "      <td>20801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2365</th>\n",
       "      <td>New England Patriots</td>\n",
       "      <td>TE</td>\n",
       "      <td>Joe Cardona</td>\n",
       "      <td>25</td>\n",
       "      <td>49</td>\n",
       "      <td>46</td>\n",
       "      <td>73</td>\n",
       "      <td>76</td>\n",
       "      <td>71</td>\n",
       "      <td>80</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Blocking</td>\n",
       "      <td>Joe</td>\n",
       "      <td>Cardona</td>\n",
       "      <td>7</td>\n",
       "      <td>30</td>\n",
       "      <td>75</td>\n",
       "      <td>245</td>\n",
       "      <td>Navy</td>\n",
       "      <td>7040</td>\n",
       "      <td>2605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2366</th>\n",
       "      <td>Los Angeles Rams</td>\n",
       "      <td>TE</td>\n",
       "      <td>Matthew Orzech</td>\n",
       "      <td>25</td>\n",
       "      <td>42</td>\n",
       "      <td>55</td>\n",
       "      <td>77</td>\n",
       "      <td>80</td>\n",
       "      <td>78</td>\n",
       "      <td>84</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Possession</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>Orzech</td>\n",
       "      <td>3</td>\n",
       "      <td>27</td>\n",
       "      <td>75</td>\n",
       "      <td>246</td>\n",
       "      <td>Azusa Pacific</td>\n",
       "      <td>1496</td>\n",
       "      <td>20842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2367</th>\n",
       "      <td>New Orleans Saints</td>\n",
       "      <td>TE</td>\n",
       "      <td>Zach Wood</td>\n",
       "      <td>25</td>\n",
       "      <td>49</td>\n",
       "      <td>63</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>66</td>\n",
       "      <td>70</td>\n",
       "      <td>...</td>\n",
       "      <td>TE_Blocking</td>\n",
       "      <td>Zach</td>\n",
       "      <td>Wood</td>\n",
       "      <td>5</td>\n",
       "      <td>29</td>\n",
       "      <td>75</td>\n",
       "      <td>255</td>\n",
       "      <td>SMU</td>\n",
       "      <td>9322</td>\n",
       "      <td>12979</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2368 rows × 72 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Team Position       Full Name  Overall Rating  \\\n",
       "0         Los Angeles Rams       RE    Aaron Donald              99   \n",
       "1        Las Vegas Raiders       WR   Davante Adams              99   \n",
       "2         Cleveland Browns       RE   Myles Garrett              99   \n",
       "3      San Francisco 49ers       LT  Trent Williams              99   \n",
       "4         Los Angeles Rams       WR     Cooper Kupp              98   \n",
       "...                    ...      ...             ...             ...   \n",
       "2363  Jacksonville Jaguars       TE   Ross Matiscik              26   \n",
       "2364            Buccaneers       TE     Zach Triner              26   \n",
       "2365  New England Patriots       TE     Joe Cardona              25   \n",
       "2366      Los Angeles Rams       TE  Matthew Orzech              25   \n",
       "2367    New Orleans Saints       TE       Zach Wood              25   \n",
       "\n",
       "      Jersey Number  Awareness  Speed  Acceleration  Agility  Jumping  ...  \\\n",
       "0                99         99     82            90       86       78  ...   \n",
       "1                17         99     90            92       95       96  ...   \n",
       "2                95         98     88            91       85       92  ...   \n",
       "3                71         99     76            74       73       83  ...   \n",
       "4                10         99     89            96       95       82  ...   \n",
       "...             ...        ...    ...           ...      ...      ...  ...   \n",
       "2363             46         55     71            68       69       71  ...   \n",
       "2364             97         62     76            81       69       74  ...   \n",
       "2365             49         46     73            76       71       80  ...   \n",
       "2366             42         55     77            80       78       84  ...   \n",
       "2367             49         63     65            65       66       70  ...   \n",
       "\n",
       "           Archetype  First Name  Last Name  Years Pro  Age  Height  Weight  \\\n",
       "0     DE_PowerRusher       Aaron     Donald          8   31      73     280   \n",
       "1      WR_DeepThreat     Davante      Adams          8   29      73     215   \n",
       "2     DE_PowerRusher       Myles    Garrett          5   26      76     272   \n",
       "3           OT_Power       Trent   Williams         12   34      77     320   \n",
       "4            WR_Slot      Cooper       Kupp          5   29      74     208   \n",
       "...              ...         ...        ...        ...  ...     ...     ...   \n",
       "2363   TE_Possession        Ross   Matiscik          2   25      72     235   \n",
       "2364     TE_Blocking        Zach     Triner          3   31      74     247   \n",
       "2365     TE_Blocking         Joe    Cardona          7   30      75     245   \n",
       "2366   TE_Possession     Matthew     Orzech          3   27      75     246   \n",
       "2367     TE_Blocking        Zach       Wood          5   29      75     255   \n",
       "\n",
       "            College  Player Portrait  Primary Key  \n",
       "0        Pittsburgh             6394        10852  \n",
       "1      Fresno State             6328        10823  \n",
       "2          Texas AM             8560        12520  \n",
       "3          Oklahoma             3231         9800  \n",
       "4     Eastern Wash.             8626        12558  \n",
       "...             ...              ...          ...  \n",
       "2363         Baylor             1482        21400  \n",
       "2364     Assumption              628        20801  \n",
       "2365           Navy             7040         2605  \n",
       "2366  Azusa Pacific             1496        20842  \n",
       "2367            SMU             9322        12979  \n",
       "\n",
       "[2368 rows x 72 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings"
   ]
  }
 ],
 "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}