Lecture 15 - Pandas DataFrames.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from pandas import DataFrame, Series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# python's built in method to grab a web page\n",
    "import webbrowser\n",
    "website = 'http://en.wikipedia.org/wiki/NFL_win-loss_records'\n",
    "webbrowser.open(website)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# This method opens up a new tab at the URL specified. This page was a typical wikipedia page, we scrolled down to the win/loss\n",
    "# section and highlit the section, crtl-c to clipboard and now we're using a pandas function to read the contents of the \n",
    "# clipboard into a DataFrame\n",
    "nfl_frame = pd.read_clipboard()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Rank</th>\n",
       "      <th>Team</th>\n",
       "      <th>Won</th>\n",
       "      <th>Lost</th>\n",
       "      <th>Tied</th>\n",
       "      <th>Pct.</th>\n",
       "      <th>First NFL Season</th>\n",
       "      <th>Total Games</th>\n",
       "      <th>Division</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Dallas Cowboys</td>\n",
       "      <td>511</td>\n",
       "      <td>367</td>\n",
       "      <td>1</td>\n",
       "      <td>0.573</td>\n",
       "      <td>1960</td>\n",
       "      <td>860</td>\n",
       "      <td>NFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Green Bay Packers</td>\n",
       "      <td>730</td>\n",
       "      <td>553</td>\n",
       "      <td>37</td>\n",
       "      <td>0.567</td>\n",
       "      <td>1921</td>\n",
       "      <td>1,320</td>\n",
       "      <td>NFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Chicago Bears</td>\n",
       "      <td>744</td>\n",
       "      <td>568</td>\n",
       "      <td>42</td>\n",
       "      <td>0.565</td>\n",
       "      <td>1920</td>\n",
       "      <td>1,354</td>\n",
       "      <td>NFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Miami Dolphins</td>\n",
       "      <td>439</td>\n",
       "      <td>341</td>\n",
       "      <td>4</td>\n",
       "      <td>0.563</td>\n",
       "      <td>1966</td>\n",
       "      <td>784</td>\n",
       "      <td>AFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>New England Patriots[b]</td>\n",
       "      <td>476</td>\n",
       "      <td>383</td>\n",
       "      <td>9</td>\n",
       "      <td>0.554</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.0</td>\n",
       "      <td>New York Giants</td>\n",
       "      <td>684</td>\n",
       "      <td>572</td>\n",
       "      <td>33</td>\n",
       "      <td>0.543</td>\n",
       "      <td>1925</td>\n",
       "      <td>1,289</td>\n",
       "      <td>NFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7.0</td>\n",
       "      <td>Denver Broncos</td>\n",
       "      <td>465</td>\n",
       "      <td>393</td>\n",
       "      <td>10</td>\n",
       "      <td>0.541</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.0</td>\n",
       "      <td>Minnesota Vikings</td>\n",
       "      <td>457</td>\n",
       "      <td>387</td>\n",
       "      <td>10</td>\n",
       "      <td>0.541</td>\n",
       "      <td>1961</td>\n",
       "      <td>854</td>\n",
       "      <td>NFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9.0</td>\n",
       "      <td>Baltimore Ravens</td>\n",
       "      <td>181</td>\n",
       "      <td>154</td>\n",
       "      <td>1</td>\n",
       "      <td>0.540</td>\n",
       "      <td>1996</td>\n",
       "      <td>336</td>\n",
       "      <td>AFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10.0</td>\n",
       "      <td>San Francisco 49ers</td>\n",
       "      <td>522</td>\n",
       "      <td>450</td>\n",
       "      <td>14</td>\n",
       "      <td>0.537</td>\n",
       "      <td>1950</td>\n",
       "      <td>986</td>\n",
       "      <td>NFC West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11.0</td>\n",
       "      <td>Indianapolis Colts[c]</td>\n",
       "      <td>502</td>\n",
       "      <td>441</td>\n",
       "      <td>7</td>\n",
       "      <td>0.532</td>\n",
       "      <td>1953</td>\n",
       "      <td>950</td>\n",
       "      <td>AFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12.0</td>\n",
       "      <td>Oakland Raiders</td>\n",
       "      <td>456</td>\n",
       "      <td>401</td>\n",
       "      <td>11</td>\n",
       "      <td>0.532</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13.0</td>\n",
       "      <td>Pittsburgh Steelers</td>\n",
       "      <td>601</td>\n",
       "      <td>535</td>\n",
       "      <td>20</td>\n",
       "      <td>0.529</td>\n",
       "      <td>1933</td>\n",
       "      <td>1,156</td>\n",
       "      <td>AFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14.0</td>\n",
       "      <td>Kansas City Chiefs</td>\n",
       "      <td>447</td>\n",
       "      <td>409</td>\n",
       "      <td>12</td>\n",
       "      <td>0.522</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15.0</td>\n",
       "      <td>Washington Redskins</td>\n",
       "      <td>586</td>\n",
       "      <td>572</td>\n",
       "      <td>28</td>\n",
       "      <td>0.506</td>\n",
       "      <td>1932</td>\n",
       "      <td>1,186</td>\n",
       "      <td>NFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16.0</td>\n",
       "      <td>Seattle Seahawks</td>\n",
       "      <td>325</td>\n",
       "      <td>318</td>\n",
       "      <td>1</td>\n",
       "      <td>0.505</td>\n",
       "      <td>1976</td>\n",
       "      <td>644</td>\n",
       "      <td>NFC West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17.0</td>\n",
       "      <td>Cleveland Browns</td>\n",
       "      <td>462</td>\n",
       "      <td>466</td>\n",
       "      <td>10</td>\n",
       "      <td>0.498</td>\n",
       "      <td>1950</td>\n",
       "      <td>938</td>\n",
       "      <td>AFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18.0</td>\n",
       "      <td>Los Angeles Chargers</td>\n",
       "      <td>426</td>\n",
       "      <td>431</td>\n",
       "      <td>11</td>\n",
       "      <td>0.497</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19.0</td>\n",
       "      <td>Los Angeles Rams</td>\n",
       "      <td>544</td>\n",
       "      <td>554</td>\n",
       "      <td>21</td>\n",
       "      <td>0.496</td>\n",
       "      <td>1937</td>\n",
       "      <td>1,119</td>\n",
       "      <td>NFC West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20.0</td>\n",
       "      <td>Carolina Panthers</td>\n",
       "      <td>172</td>\n",
       "      <td>179</td>\n",
       "      <td>1</td>\n",
       "      <td>0.490</td>\n",
       "      <td>1995</td>\n",
       "      <td>352</td>\n",
       "      <td>NFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21.0</td>\n",
       "      <td>Philadelphia Eagles</td>\n",
       "      <td>555</td>\n",
       "      <td>591</td>\n",
       "      <td>26</td>\n",
       "      <td>0.485</td>\n",
       "      <td>1933</td>\n",
       "      <td>1,172</td>\n",
       "      <td>NFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22.0</td>\n",
       "      <td>Tennessee Titans</td>\n",
       "      <td>413</td>\n",
       "      <td>449</td>\n",
       "      <td>6</td>\n",
       "      <td>0.479</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23.0</td>\n",
       "      <td>Buffalo Bills</td>\n",
       "      <td>400</td>\n",
       "      <td>460</td>\n",
       "      <td>8</td>\n",
       "      <td>0.465</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24.0</td>\n",
       "      <td>Detroit Lions</td>\n",
       "      <td>544</td>\n",
       "      <td>641</td>\n",
       "      <td>32</td>\n",
       "      <td>0.460</td>\n",
       "      <td>1930</td>\n",
       "      <td>1,217</td>\n",
       "      <td>NFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25.0</td>\n",
       "      <td>Cincinnati Bengals</td>\n",
       "      <td>344</td>\n",
       "      <td>408</td>\n",
       "      <td>4</td>\n",
       "      <td>0.458</td>\n",
       "      <td>1968</td>\n",
       "      <td>756</td>\n",
       "      <td>AFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26.0</td>\n",
       "      <td>New York Jets</td>\n",
       "      <td>392</td>\n",
       "      <td>468</td>\n",
       "      <td>8</td>\n",
       "      <td>0.456</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27.0</td>\n",
       "      <td>New Orleans Saints</td>\n",
       "      <td>338</td>\n",
       "      <td>427</td>\n",
       "      <td>5</td>\n",
       "      <td>0.442</td>\n",
       "      <td>1967</td>\n",
       "      <td>770</td>\n",
       "      <td>NFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28.0</td>\n",
       "      <td>Houston Texans</td>\n",
       "      <td>106</td>\n",
       "      <td>134</td>\n",
       "      <td>0</td>\n",
       "      <td>0.442</td>\n",
       "      <td>2002</td>\n",
       "      <td>240</td>\n",
       "      <td>AFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29.0</td>\n",
       "      <td>Jacksonville Jaguars</td>\n",
       "      <td>155</td>\n",
       "      <td>197</td>\n",
       "      <td>0</td>\n",
       "      <td>0.440</td>\n",
       "      <td>1995</td>\n",
       "      <td>352</td>\n",
       "      <td>AFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30.0</td>\n",
       "      <td>Atlanta Falcons</td>\n",
       "      <td>341</td>\n",
       "      <td>437</td>\n",
       "      <td>6</td>\n",
       "      <td>0.439</td>\n",
       "      <td>1966</td>\n",
       "      <td>784</td>\n",
       "      <td>NFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31.0</td>\n",
       "      <td>Arizona Cardinals</td>\n",
       "      <td>542</td>\n",
       "      <td>732</td>\n",
       "      <td>40</td>\n",
       "      <td>0.428</td>\n",
       "      <td>1920</td>\n",
       "      <td>1,314</td>\n",
       "      <td>NFC West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32.0</td>\n",
       "      <td>Tampa Bay Buccaneers</td>\n",
       "      <td>250</td>\n",
       "      <td>393</td>\n",
       "      <td>1</td>\n",
       "      <td>0.389</td>\n",
       "      <td>1976</td>\n",
       "      <td>866</td>\n",
       "      <td>NFC South</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Rank                     Team  Won  Lost  Tied   Pct.  First NFL Season  \\\n",
       "0    1.0           Dallas Cowboys  511   367     1  0.573              1960   \n",
       "1    2.0        Green Bay Packers  730   553    37  0.567              1921   \n",
       "2    3.0            Chicago Bears  744   568    42  0.565              1920   \n",
       "3    4.0           Miami Dolphins  439   341     4  0.563              1966   \n",
       "4    5.0  New England Patriots[b]  476   383     9  0.554              1960   \n",
       "5    6.0          New York Giants  684   572    33  0.543              1925   \n",
       "6    7.0           Denver Broncos  465   393    10  0.541              1960   \n",
       "7    8.0        Minnesota Vikings  457   387    10  0.541              1961   \n",
       "8    9.0         Baltimore Ravens  181   154     1  0.540              1996   \n",
       "9   10.0      San Francisco 49ers  522   450    14  0.537              1950   \n",
       "10  11.0    Indianapolis Colts[c]  502   441     7  0.532              1953   \n",
       "11  12.0          Oakland Raiders  456   401    11  0.532              1960   \n",
       "12  13.0      Pittsburgh Steelers  601   535    20  0.529              1933   \n",
       "13  14.0       Kansas City Chiefs  447   409    12  0.522              1960   \n",
       "14  15.0      Washington Redskins  586   572    28  0.506              1932   \n",
       "15  16.0         Seattle Seahawks  325   318     1  0.505              1976   \n",
       "16  17.0         Cleveland Browns  462   466    10  0.498              1950   \n",
       "17  18.0     Los Angeles Chargers  426   431    11  0.497              1960   \n",
       "18  19.0         Los Angeles Rams  544   554    21  0.496              1937   \n",
       "19  20.0        Carolina Panthers  172   179     1  0.490              1995   \n",
       "20  21.0      Philadelphia Eagles  555   591    26  0.485              1933   \n",
       "21  22.0         Tennessee Titans  413   449     6  0.479              1960   \n",
       "22  23.0            Buffalo Bills  400   460     8  0.465              1960   \n",
       "23  24.0            Detroit Lions  544   641    32  0.460              1930   \n",
       "24  25.0       Cincinnati Bengals  344   408     4  0.458              1968   \n",
       "25  26.0            New York Jets  392   468     8  0.456              1960   \n",
       "26  27.0       New Orleans Saints  338   427     5  0.442              1967   \n",
       "27  28.0           Houston Texans  106   134     0  0.442              2002   \n",
       "28  29.0     Jacksonville Jaguars  155   197     0  0.440              1995   \n",
       "29  30.0          Atlanta Falcons  341   437     6  0.439              1966   \n",
       "30  31.0        Arizona Cardinals  542   732    40  0.428              1920   \n",
       "31  32.0     Tampa Bay Buccaneers  250   393     1  0.389              1976   \n",
       "\n",
       "   Total Games   Division  \n",
       "0          860   NFC East  \n",
       "1        1,320  NFC North  \n",
       "2        1,354  NFC North  \n",
       "3          784   AFC East  \n",
       "4          868   AFC East  \n",
       "5        1,289   NFC East  \n",
       "6          868   AFC West  \n",
       "7          854  NFC North  \n",
       "8          336  AFC North  \n",
       "9          986   NFC West  \n",
       "10         950  AFC South  \n",
       "11         868   AFC West  \n",
       "12       1,156  AFC North  \n",
       "13         868   AFC West  \n",
       "14       1,186   NFC East  \n",
       "15         644   NFC West  \n",
       "16         938  AFC North  \n",
       "17         868   AFC West  \n",
       "18       1,119   NFC West  \n",
       "19         352  NFC South  \n",
       "20       1,172   NFC East  \n",
       "21         868  AFC South  \n",
       "22         868   AFC East  \n",
       "23       1,217  NFC North  \n",
       "24         756  AFC North  \n",
       "25         868   AFC East  \n",
       "26         770  NFC South  \n",
       "27         240  AFC South  \n",
       "28         352  AFC South  \n",
       "29         784  NFC South  \n",
       "30       1,314   NFC West  \n",
       "31         866  NFC South  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# This is an interesting \"down and dirty\" method to prototype some data \n",
    "nfl_frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Rank', 'Team', 'Won', 'Lost', 'Tied', 'Pct.', 'First NFL Season',\n",
       "       'Total Games', 'Division'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# return a list of column names\n",
    "nfl_frame.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0              Dallas Cowboys\n",
       "1           Green Bay Packers\n",
       "2               Chicago Bears\n",
       "3              Miami Dolphins\n",
       "4     New England Patriots[b]\n",
       "5             New York Giants\n",
       "6              Denver Broncos\n",
       "7           Minnesota Vikings\n",
       "8            Baltimore Ravens\n",
       "9         San Francisco 49ers\n",
       "10      Indianapolis Colts[c]\n",
       "11            Oakland Raiders\n",
       "12        Pittsburgh Steelers\n",
       "13         Kansas City Chiefs\n",
       "14        Washington Redskins\n",
       "15           Seattle Seahawks\n",
       "16           Cleveland Browns\n",
       "17       Los Angeles Chargers\n",
       "18           Los Angeles Rams\n",
       "19          Carolina Panthers\n",
       "20        Philadelphia Eagles\n",
       "21           Tennessee Titans\n",
       "22              Buffalo Bills\n",
       "23              Detroit Lions\n",
       "24         Cincinnati Bengals\n",
       "25              New York Jets\n",
       "26         New Orleans Saints\n",
       "27             Houston Texans\n",
       "28       Jacksonville Jaguars\n",
       "29            Atlanta Falcons\n",
       "30          Arizona Cardinals\n",
       "31       Tampa Bay Buccaneers\n",
       "Name: Team, dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# we can grab a single column by specifying the name as dot notation\n",
    "nfl_frame.Team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     1960\n",
       "1     1921\n",
       "2     1920\n",
       "3     1966\n",
       "4     1960\n",
       "5     1925\n",
       "6     1960\n",
       "7     1961\n",
       "8     1996\n",
       "9     1950\n",
       "10    1953\n",
       "11    1960\n",
       "12    1933\n",
       "13    1960\n",
       "14    1932\n",
       "15    1976\n",
       "16    1950\n",
       "17    1960\n",
       "18    1937\n",
       "19    1995\n",
       "20    1933\n",
       "21    1960\n",
       "22    1960\n",
       "23    1930\n",
       "24    1968\n",
       "25    1960\n",
       "26    1967\n",
       "27    2002\n",
       "28    1995\n",
       "29    1966\n",
       "30    1920\n",
       "31    1976\n",
       "Name: First NFL Season, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Columns with more than a single word require this method\n",
    "nfl_frame['First NFL Season']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Won</th>\n",
       "      <th>Lost</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dallas Cowboys</td>\n",
       "      <td>511</td>\n",
       "      <td>367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Green Bay Packers</td>\n",
       "      <td>730</td>\n",
       "      <td>553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chicago Bears</td>\n",
       "      <td>744</td>\n",
       "      <td>568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Miami Dolphins</td>\n",
       "      <td>439</td>\n",
       "      <td>341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>New England Patriots[b]</td>\n",
       "      <td>476</td>\n",
       "      <td>383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>New York Giants</td>\n",
       "      <td>684</td>\n",
       "      <td>572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Denver Broncos</td>\n",
       "      <td>465</td>\n",
       "      <td>393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Minnesota Vikings</td>\n",
       "      <td>457</td>\n",
       "      <td>387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Baltimore Ravens</td>\n",
       "      <td>181</td>\n",
       "      <td>154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>San Francisco 49ers</td>\n",
       "      <td>522</td>\n",
       "      <td>450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Indianapolis Colts[c]</td>\n",
       "      <td>502</td>\n",
       "      <td>441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Oakland Raiders</td>\n",
       "      <td>456</td>\n",
       "      <td>401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Pittsburgh Steelers</td>\n",
       "      <td>601</td>\n",
       "      <td>535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Kansas City Chiefs</td>\n",
       "      <td>447</td>\n",
       "      <td>409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Washington Redskins</td>\n",
       "      <td>586</td>\n",
       "      <td>572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Seattle Seahawks</td>\n",
       "      <td>325</td>\n",
       "      <td>318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Cleveland Browns</td>\n",
       "      <td>462</td>\n",
       "      <td>466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Los Angeles Chargers</td>\n",
       "      <td>426</td>\n",
       "      <td>431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Los Angeles Rams</td>\n",
       "      <td>544</td>\n",
       "      <td>554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Carolina Panthers</td>\n",
       "      <td>172</td>\n",
       "      <td>179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Philadelphia Eagles</td>\n",
       "      <td>555</td>\n",
       "      <td>591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Tennessee Titans</td>\n",
       "      <td>413</td>\n",
       "      <td>449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Buffalo Bills</td>\n",
       "      <td>400</td>\n",
       "      <td>460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Detroit Lions</td>\n",
       "      <td>544</td>\n",
       "      <td>641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Cincinnati Bengals</td>\n",
       "      <td>344</td>\n",
       "      <td>408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>New York Jets</td>\n",
       "      <td>392</td>\n",
       "      <td>468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>New Orleans Saints</td>\n",
       "      <td>338</td>\n",
       "      <td>427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Houston Texans</td>\n",
       "      <td>106</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Jacksonville Jaguars</td>\n",
       "      <td>155</td>\n",
       "      <td>197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Atlanta Falcons</td>\n",
       "      <td>341</td>\n",
       "      <td>437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Arizona Cardinals</td>\n",
       "      <td>542</td>\n",
       "      <td>732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Tampa Bay Buccaneers</td>\n",
       "      <td>250</td>\n",
       "      <td>393</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Team  Won  Lost\n",
       "0            Dallas Cowboys  511   367\n",
       "1         Green Bay Packers  730   553\n",
       "2             Chicago Bears  744   568\n",
       "3            Miami Dolphins  439   341\n",
       "4   New England Patriots[b]  476   383\n",
       "5           New York Giants  684   572\n",
       "6            Denver Broncos  465   393\n",
       "7         Minnesota Vikings  457   387\n",
       "8          Baltimore Ravens  181   154\n",
       "9       San Francisco 49ers  522   450\n",
       "10    Indianapolis Colts[c]  502   441\n",
       "11          Oakland Raiders  456   401\n",
       "12      Pittsburgh Steelers  601   535\n",
       "13       Kansas City Chiefs  447   409\n",
       "14      Washington Redskins  586   572\n",
       "15         Seattle Seahawks  325   318\n",
       "16         Cleveland Browns  462   466\n",
       "17     Los Angeles Chargers  426   431\n",
       "18         Los Angeles Rams  544   554\n",
       "19        Carolina Panthers  172   179\n",
       "20      Philadelphia Eagles  555   591\n",
       "21         Tennessee Titans  413   449\n",
       "22            Buffalo Bills  400   460\n",
       "23            Detroit Lions  544   641\n",
       "24       Cincinnati Bengals  344   408\n",
       "25            New York Jets  392   468\n",
       "26       New Orleans Saints  338   427\n",
       "27           Houston Texans  106   134\n",
       "28     Jacksonville Jaguars  155   197\n",
       "29          Atlanta Falcons  341   437\n",
       "30        Arizona Cardinals  542   732\n",
       "31     Tampa Bay Buccaneers  250   393"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Grab multiple columns by invoking the DataFrame method, specifying the DF object and a list of columns\n",
    "DataFrame(nfl_frame, columns=['Team', 'Won', 'Lost'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>Rank</th>\n",
       "      <th>Team</th>\n",
       "      <th>Won</th>\n",
       "      <th>Lost</th>\n",
       "      <th>Tied</th>\n",
       "      <th>Pct.</th>\n",
       "      <th>First NFL Season</th>\n",
       "      <th>Total Games</th>\n",
       "      <th>Division</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Dallas Cowboys</td>\n",
       "      <td>511</td>\n",
       "      <td>367</td>\n",
       "      <td>1</td>\n",
       "      <td>0.573</td>\n",
       "      <td>1960</td>\n",
       "      <td>860</td>\n",
       "      <td>NFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Green Bay Packers</td>\n",
       "      <td>730</td>\n",
       "      <td>553</td>\n",
       "      <td>37</td>\n",
       "      <td>0.567</td>\n",
       "      <td>1921</td>\n",
       "      <td>1,320</td>\n",
       "      <td>NFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Chicago Bears</td>\n",
       "      <td>744</td>\n",
       "      <td>568</td>\n",
       "      <td>42</td>\n",
       "      <td>0.565</td>\n",
       "      <td>1920</td>\n",
       "      <td>1,354</td>\n",
       "      <td>NFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Miami Dolphins</td>\n",
       "      <td>439</td>\n",
       "      <td>341</td>\n",
       "      <td>4</td>\n",
       "      <td>0.563</td>\n",
       "      <td>1966</td>\n",
       "      <td>784</td>\n",
       "      <td>AFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>New England Patriots[b]</td>\n",
       "      <td>476</td>\n",
       "      <td>383</td>\n",
       "      <td>9</td>\n",
       "      <td>0.554</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC East</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                     Team  Won  Lost  Tied   Pct.  First NFL Season  \\\n",
       "0   1.0           Dallas Cowboys  511   367     1  0.573              1960   \n",
       "1   2.0        Green Bay Packers  730   553    37  0.567              1921   \n",
       "2   3.0            Chicago Bears  744   568    42  0.565              1920   \n",
       "3   4.0           Miami Dolphins  439   341     4  0.563              1966   \n",
       "4   5.0  New England Patriots[b]  476   383     9  0.554              1960   \n",
       "\n",
       "  Total Games   Division  \n",
       "0         860   NFC East  \n",
       "1       1,320  NFC North  \n",
       "2       1,354  NFC North  \n",
       "3         784   AFC East  \n",
       "4         868   AFC East  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# grab first 5 rows\n",
    "nfl_frame.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>Rank</th>\n",
       "      <th>Team</th>\n",
       "      <th>Won</th>\n",
       "      <th>Lost</th>\n",
       "      <th>Tied</th>\n",
       "      <th>Pct.</th>\n",
       "      <th>First NFL Season</th>\n",
       "      <th>Total Games</th>\n",
       "      <th>Division</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28.0</td>\n",
       "      <td>Houston Texans</td>\n",
       "      <td>106</td>\n",
       "      <td>134</td>\n",
       "      <td>0</td>\n",
       "      <td>0.442</td>\n",
       "      <td>2002</td>\n",
       "      <td>240</td>\n",
       "      <td>AFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29.0</td>\n",
       "      <td>Jacksonville Jaguars</td>\n",
       "      <td>155</td>\n",
       "      <td>197</td>\n",
       "      <td>0</td>\n",
       "      <td>0.440</td>\n",
       "      <td>1995</td>\n",
       "      <td>352</td>\n",
       "      <td>AFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30.0</td>\n",
       "      <td>Atlanta Falcons</td>\n",
       "      <td>341</td>\n",
       "      <td>437</td>\n",
       "      <td>6</td>\n",
       "      <td>0.439</td>\n",
       "      <td>1966</td>\n",
       "      <td>784</td>\n",
       "      <td>NFC South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31.0</td>\n",
       "      <td>Arizona Cardinals</td>\n",
       "      <td>542</td>\n",
       "      <td>732</td>\n",
       "      <td>40</td>\n",
       "      <td>0.428</td>\n",
       "      <td>1920</td>\n",
       "      <td>1,314</td>\n",
       "      <td>NFC West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32.0</td>\n",
       "      <td>Tampa Bay Buccaneers</td>\n",
       "      <td>250</td>\n",
       "      <td>393</td>\n",
       "      <td>1</td>\n",
       "      <td>0.389</td>\n",
       "      <td>1976</td>\n",
       "      <td>866</td>\n",
       "      <td>NFC South</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Rank                  Team  Won  Lost  Tied   Pct.  First NFL Season  \\\n",
       "27  28.0        Houston Texans  106   134     0  0.442              2002   \n",
       "28  29.0  Jacksonville Jaguars  155   197     0  0.440              1995   \n",
       "29  30.0       Atlanta Falcons  341   437     6  0.439              1966   \n",
       "30  31.0     Arizona Cardinals  542   732    40  0.428              1920   \n",
       "31  32.0  Tampa Bay Buccaneers  250   393     1  0.389              1976   \n",
       "\n",
       "   Total Games   Division  \n",
       "27         240  AFC South  \n",
       "28         352  AFC South  \n",
       "29         784  NFC South  \n",
       "30       1,314   NFC West  \n",
       "31         866  NFC South  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# grab last 5 rows\n",
    "nfl_frame.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:2: DeprecationWarning: \n",
      ".ix is deprecated. Please use\n",
      ".loc for label based indexing or\n",
      ".iloc for positional indexing\n",
      "\n",
      "See the documentation here:\n",
      "http://pandas.pydata.org/pandas-docs/stable/indexing.html#ix-indexer-is-deprecated\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Rank                             12\n",
       "Team                Oakland Raiders\n",
       "Won                             456\n",
       "Lost                            401\n",
       "Tied                             11\n",
       "Pct.                          0.532\n",
       "First NFL Season               1960\n",
       "Total Games                     868\n",
       "Division                   AFC West\n",
       "Name: 11, dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Grab a particular record NOTE: Deprecated, use .loc instead\n",
    "nfl_frame.ix[11]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Rank                                 13\n",
       "Team                Pittsburgh Steelers\n",
       "Won                                 601\n",
       "Lost                                535\n",
       "Tied                                 20\n",
       "Pct.                              0.529\n",
       "First NFL Season                   1933\n",
       "Total Games                       1,156\n",
       "Division                      AFC North\n",
       "Name: 12, dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nfl_frame.loc[12]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# add a column and assign a static value\n",
    "nfl_frame['Stadium'] = 'Corporate America'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>Rank</th>\n",
       "      <th>Team</th>\n",
       "      <th>Won</th>\n",
       "      <th>Lost</th>\n",
       "      <th>Tied</th>\n",
       "      <th>Pct.</th>\n",
       "      <th>First NFL Season</th>\n",
       "      <th>Total Games</th>\n",
       "      <th>Division</th>\n",
       "      <th>Stadium</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Dallas Cowboys</td>\n",
       "      <td>511</td>\n",
       "      <td>367</td>\n",
       "      <td>1</td>\n",
       "      <td>0.573</td>\n",
       "      <td>1960</td>\n",
       "      <td>860</td>\n",
       "      <td>NFC East</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Green Bay Packers</td>\n",
       "      <td>730</td>\n",
       "      <td>553</td>\n",
       "      <td>37</td>\n",
       "      <td>0.567</td>\n",
       "      <td>1921</td>\n",
       "      <td>1,320</td>\n",
       "      <td>NFC North</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Chicago Bears</td>\n",
       "      <td>744</td>\n",
       "      <td>568</td>\n",
       "      <td>42</td>\n",
       "      <td>0.565</td>\n",
       "      <td>1920</td>\n",
       "      <td>1,354</td>\n",
       "      <td>NFC North</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Miami Dolphins</td>\n",
       "      <td>439</td>\n",
       "      <td>341</td>\n",
       "      <td>4</td>\n",
       "      <td>0.563</td>\n",
       "      <td>1966</td>\n",
       "      <td>784</td>\n",
       "      <td>AFC East</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>New England Patriots[b]</td>\n",
       "      <td>476</td>\n",
       "      <td>383</td>\n",
       "      <td>9</td>\n",
       "      <td>0.554</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC East</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.0</td>\n",
       "      <td>New York Giants</td>\n",
       "      <td>684</td>\n",
       "      <td>572</td>\n",
       "      <td>33</td>\n",
       "      <td>0.543</td>\n",
       "      <td>1925</td>\n",
       "      <td>1,289</td>\n",
       "      <td>NFC East</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7.0</td>\n",
       "      <td>Denver Broncos</td>\n",
       "      <td>465</td>\n",
       "      <td>393</td>\n",
       "      <td>10</td>\n",
       "      <td>0.541</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC West</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.0</td>\n",
       "      <td>Minnesota Vikings</td>\n",
       "      <td>457</td>\n",
       "      <td>387</td>\n",
       "      <td>10</td>\n",
       "      <td>0.541</td>\n",
       "      <td>1961</td>\n",
       "      <td>854</td>\n",
       "      <td>NFC North</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9.0</td>\n",
       "      <td>Baltimore Ravens</td>\n",
       "      <td>181</td>\n",
       "      <td>154</td>\n",
       "      <td>1</td>\n",
       "      <td>0.540</td>\n",
       "      <td>1996</td>\n",
       "      <td>336</td>\n",
       "      <td>AFC North</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10.0</td>\n",
       "      <td>San Francisco 49ers</td>\n",
       "      <td>522</td>\n",
       "      <td>450</td>\n",
       "      <td>14</td>\n",
       "      <td>0.537</td>\n",
       "      <td>1950</td>\n",
       "      <td>986</td>\n",
       "      <td>NFC West</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11.0</td>\n",
       "      <td>Indianapolis Colts[c]</td>\n",
       "      <td>502</td>\n",
       "      <td>441</td>\n",
       "      <td>7</td>\n",
       "      <td>0.532</td>\n",
       "      <td>1953</td>\n",
       "      <td>950</td>\n",
       "      <td>AFC South</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12.0</td>\n",
       "      <td>Oakland Raiders</td>\n",
       "      <td>456</td>\n",
       "      <td>401</td>\n",
       "      <td>11</td>\n",
       "      <td>0.532</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC West</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13.0</td>\n",
       "      <td>Pittsburgh Steelers</td>\n",
       "      <td>601</td>\n",
       "      <td>535</td>\n",
       "      <td>20</td>\n",
       "      <td>0.529</td>\n",
       "      <td>1933</td>\n",
       "      <td>1,156</td>\n",
       "      <td>AFC North</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14.0</td>\n",
       "      <td>Kansas City Chiefs</td>\n",
       "      <td>447</td>\n",
       "      <td>409</td>\n",
       "      <td>12</td>\n",
       "      <td>0.522</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC West</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15.0</td>\n",
       "      <td>Washington Redskins</td>\n",
       "      <td>586</td>\n",
       "      <td>572</td>\n",
       "      <td>28</td>\n",
       "      <td>0.506</td>\n",
       "      <td>1932</td>\n",
       "      <td>1,186</td>\n",
       "      <td>NFC East</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16.0</td>\n",
       "      <td>Seattle Seahawks</td>\n",
       "      <td>325</td>\n",
       "      <td>318</td>\n",
       "      <td>1</td>\n",
       "      <td>0.505</td>\n",
       "      <td>1976</td>\n",
       "      <td>644</td>\n",
       "      <td>NFC West</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17.0</td>\n",
       "      <td>Cleveland Browns</td>\n",
       "      <td>462</td>\n",
       "      <td>466</td>\n",
       "      <td>10</td>\n",
       "      <td>0.498</td>\n",
       "      <td>1950</td>\n",
       "      <td>938</td>\n",
       "      <td>AFC North</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18.0</td>\n",
       "      <td>Los Angeles Chargers</td>\n",
       "      <td>426</td>\n",
       "      <td>431</td>\n",
       "      <td>11</td>\n",
       "      <td>0.497</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC West</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19.0</td>\n",
       "      <td>Los Angeles Rams</td>\n",
       "      <td>544</td>\n",
       "      <td>554</td>\n",
       "      <td>21</td>\n",
       "      <td>0.496</td>\n",
       "      <td>1937</td>\n",
       "      <td>1,119</td>\n",
       "      <td>NFC West</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20.0</td>\n",
       "      <td>Carolina Panthers</td>\n",
       "      <td>172</td>\n",
       "      <td>179</td>\n",
       "      <td>1</td>\n",
       "      <td>0.490</td>\n",
       "      <td>1995</td>\n",
       "      <td>352</td>\n",
       "      <td>NFC South</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21.0</td>\n",
       "      <td>Philadelphia Eagles</td>\n",
       "      <td>555</td>\n",
       "      <td>591</td>\n",
       "      <td>26</td>\n",
       "      <td>0.485</td>\n",
       "      <td>1933</td>\n",
       "      <td>1,172</td>\n",
       "      <td>NFC East</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22.0</td>\n",
       "      <td>Tennessee Titans</td>\n",
       "      <td>413</td>\n",
       "      <td>449</td>\n",
       "      <td>6</td>\n",
       "      <td>0.479</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC South</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23.0</td>\n",
       "      <td>Buffalo Bills</td>\n",
       "      <td>400</td>\n",
       "      <td>460</td>\n",
       "      <td>8</td>\n",
       "      <td>0.465</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC East</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24.0</td>\n",
       "      <td>Detroit Lions</td>\n",
       "      <td>544</td>\n",
       "      <td>641</td>\n",
       "      <td>32</td>\n",
       "      <td>0.460</td>\n",
       "      <td>1930</td>\n",
       "      <td>1,217</td>\n",
       "      <td>NFC North</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25.0</td>\n",
       "      <td>Cincinnati Bengals</td>\n",
       "      <td>344</td>\n",
       "      <td>408</td>\n",
       "      <td>4</td>\n",
       "      <td>0.458</td>\n",
       "      <td>1968</td>\n",
       "      <td>756</td>\n",
       "      <td>AFC North</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26.0</td>\n",
       "      <td>New York Jets</td>\n",
       "      <td>392</td>\n",
       "      <td>468</td>\n",
       "      <td>8</td>\n",
       "      <td>0.456</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC East</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27.0</td>\n",
       "      <td>New Orleans Saints</td>\n",
       "      <td>338</td>\n",
       "      <td>427</td>\n",
       "      <td>5</td>\n",
       "      <td>0.442</td>\n",
       "      <td>1967</td>\n",
       "      <td>770</td>\n",
       "      <td>NFC South</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28.0</td>\n",
       "      <td>Houston Texans</td>\n",
       "      <td>106</td>\n",
       "      <td>134</td>\n",
       "      <td>0</td>\n",
       "      <td>0.442</td>\n",
       "      <td>2002</td>\n",
       "      <td>240</td>\n",
       "      <td>AFC South</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29.0</td>\n",
       "      <td>Jacksonville Jaguars</td>\n",
       "      <td>155</td>\n",
       "      <td>197</td>\n",
       "      <td>0</td>\n",
       "      <td>0.440</td>\n",
       "      <td>1995</td>\n",
       "      <td>352</td>\n",
       "      <td>AFC South</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30.0</td>\n",
       "      <td>Atlanta Falcons</td>\n",
       "      <td>341</td>\n",
       "      <td>437</td>\n",
       "      <td>6</td>\n",
       "      <td>0.439</td>\n",
       "      <td>1966</td>\n",
       "      <td>784</td>\n",
       "      <td>NFC South</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31.0</td>\n",
       "      <td>Arizona Cardinals</td>\n",
       "      <td>542</td>\n",
       "      <td>732</td>\n",
       "      <td>40</td>\n",
       "      <td>0.428</td>\n",
       "      <td>1920</td>\n",
       "      <td>1,314</td>\n",
       "      <td>NFC West</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32.0</td>\n",
       "      <td>Tampa Bay Buccaneers</td>\n",
       "      <td>250</td>\n",
       "      <td>393</td>\n",
       "      <td>1</td>\n",
       "      <td>0.389</td>\n",
       "      <td>1976</td>\n",
       "      <td>866</td>\n",
       "      <td>NFC South</td>\n",
       "      <td>Corporate America</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Rank                     Team  Won  Lost  Tied   Pct.  First NFL Season  \\\n",
       "0    1.0           Dallas Cowboys  511   367     1  0.573              1960   \n",
       "1    2.0        Green Bay Packers  730   553    37  0.567              1921   \n",
       "2    3.0            Chicago Bears  744   568    42  0.565              1920   \n",
       "3    4.0           Miami Dolphins  439   341     4  0.563              1966   \n",
       "4    5.0  New England Patriots[b]  476   383     9  0.554              1960   \n",
       "5    6.0          New York Giants  684   572    33  0.543              1925   \n",
       "6    7.0           Denver Broncos  465   393    10  0.541              1960   \n",
       "7    8.0        Minnesota Vikings  457   387    10  0.541              1961   \n",
       "8    9.0         Baltimore Ravens  181   154     1  0.540              1996   \n",
       "9   10.0      San Francisco 49ers  522   450    14  0.537              1950   \n",
       "10  11.0    Indianapolis Colts[c]  502   441     7  0.532              1953   \n",
       "11  12.0          Oakland Raiders  456   401    11  0.532              1960   \n",
       "12  13.0      Pittsburgh Steelers  601   535    20  0.529              1933   \n",
       "13  14.0       Kansas City Chiefs  447   409    12  0.522              1960   \n",
       "14  15.0      Washington Redskins  586   572    28  0.506              1932   \n",
       "15  16.0         Seattle Seahawks  325   318     1  0.505              1976   \n",
       "16  17.0         Cleveland Browns  462   466    10  0.498              1950   \n",
       "17  18.0     Los Angeles Chargers  426   431    11  0.497              1960   \n",
       "18  19.0         Los Angeles Rams  544   554    21  0.496              1937   \n",
       "19  20.0        Carolina Panthers  172   179     1  0.490              1995   \n",
       "20  21.0      Philadelphia Eagles  555   591    26  0.485              1933   \n",
       "21  22.0         Tennessee Titans  413   449     6  0.479              1960   \n",
       "22  23.0            Buffalo Bills  400   460     8  0.465              1960   \n",
       "23  24.0            Detroit Lions  544   641    32  0.460              1930   \n",
       "24  25.0       Cincinnati Bengals  344   408     4  0.458              1968   \n",
       "25  26.0            New York Jets  392   468     8  0.456              1960   \n",
       "26  27.0       New Orleans Saints  338   427     5  0.442              1967   \n",
       "27  28.0           Houston Texans  106   134     0  0.442              2002   \n",
       "28  29.0     Jacksonville Jaguars  155   197     0  0.440              1995   \n",
       "29  30.0          Atlanta Falcons  341   437     6  0.439              1966   \n",
       "30  31.0        Arizona Cardinals  542   732    40  0.428              1920   \n",
       "31  32.0     Tampa Bay Buccaneers  250   393     1  0.389              1976   \n",
       "\n",
       "   Total Games   Division            Stadium  \n",
       "0          860   NFC East  Corporate America  \n",
       "1        1,320  NFC North  Corporate America  \n",
       "2        1,354  NFC North  Corporate America  \n",
       "3          784   AFC East  Corporate America  \n",
       "4          868   AFC East  Corporate America  \n",
       "5        1,289   NFC East  Corporate America  \n",
       "6          868   AFC West  Corporate America  \n",
       "7          854  NFC North  Corporate America  \n",
       "8          336  AFC North  Corporate America  \n",
       "9          986   NFC West  Corporate America  \n",
       "10         950  AFC South  Corporate America  \n",
       "11         868   AFC West  Corporate America  \n",
       "12       1,156  AFC North  Corporate America  \n",
       "13         868   AFC West  Corporate America  \n",
       "14       1,186   NFC East  Corporate America  \n",
       "15         644   NFC West  Corporate America  \n",
       "16         938  AFC North  Corporate America  \n",
       "17         868   AFC West  Corporate America  \n",
       "18       1,119   NFC West  Corporate America  \n",
       "19         352  NFC South  Corporate America  \n",
       "20       1,172   NFC East  Corporate America  \n",
       "21         868  AFC South  Corporate America  \n",
       "22         868   AFC East  Corporate America  \n",
       "23       1,217  NFC North  Corporate America  \n",
       "24         756  AFC North  Corporate America  \n",
       "25         868   AFC East  Corporate America  \n",
       "26         770  NFC South  Corporate America  \n",
       "27         240  AFC South  Corporate America  \n",
       "28         352  AFC South  Corporate America  \n",
       "29         784  NFC South  Corporate America  \n",
       "30       1,314   NFC West  Corporate America  \n",
       "31         866  NFC South  Corporate America  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nfl_frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "# add a Series to a DataFrame\n",
    "stadiums = Series(['Michigan Stadium',\n",
    "'Beaver Stadium',\n",
    "'Ohio Stadium',\n",
    "'Kyle Field',\n",
    "'Neyland Stadium',\n",
    "'Tiger Stadium',\n",
    "'Bryant–Denny Stadium',\n",
    "'Darrell K Royal–Texas Memorial Stadium',\n",
    "'Los Angeles Memorial Coliseum',\n",
    "'Sanford Stadium',\n",
    "'Rose Bowl',\n",
    "'Cotton Bowl Stadium',\n",
    "'Ben Hill Griffin Stadium',\n",
    "'Jordan–Hare Stadium',\n",
    "'Memorial Stadium',\n",
    "'Gaylord Family Oklahoma Memorial Stadium',\n",
    "'FedExField',\n",
    "'Memorial Stadium',\n",
    "'Lambeau Field',\n",
    "'Notre Dame Stadium',\n",
    "'Camp Randall Stadium',\n",
    "'Williams-Brice Stadium',\n",
    "'AT&T Stadium',\n",
    "'Bobby Bowden Field at Doak Campbell Stadium',\n",
    "'Arrowhead Stadium',\n",
    "'EverBank Field',\n",
    "'Donald W. Reynolds Razorback Stadium',\n",
    "'Spartan Stadium',\n",
    "'Ralph Wilson Stadium',\n",
    "'Bank of America Stadium',\n",
    "'FirstEnergy Stadium',\n",
    "'NRG Stadium',\n",
    "])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "nfl_frame['Stadium'] = stadiums"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>Rank</th>\n",
       "      <th>Team</th>\n",
       "      <th>Won</th>\n",
       "      <th>Lost</th>\n",
       "      <th>Tied</th>\n",
       "      <th>Pct.</th>\n",
       "      <th>First NFL Season</th>\n",
       "      <th>Total Games</th>\n",
       "      <th>Division</th>\n",
       "      <th>Stadium</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Dallas Cowboys</td>\n",
       "      <td>511</td>\n",
       "      <td>367</td>\n",
       "      <td>1</td>\n",
       "      <td>0.573</td>\n",
       "      <td>1960</td>\n",
       "      <td>860</td>\n",
       "      <td>NFC East</td>\n",
       "      <td>Michigan Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Green Bay Packers</td>\n",
       "      <td>730</td>\n",
       "      <td>553</td>\n",
       "      <td>37</td>\n",
       "      <td>0.567</td>\n",
       "      <td>1921</td>\n",
       "      <td>1,320</td>\n",
       "      <td>NFC North</td>\n",
       "      <td>Beaver Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Chicago Bears</td>\n",
       "      <td>744</td>\n",
       "      <td>568</td>\n",
       "      <td>42</td>\n",
       "      <td>0.565</td>\n",
       "      <td>1920</td>\n",
       "      <td>1,354</td>\n",
       "      <td>NFC North</td>\n",
       "      <td>Ohio Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Miami Dolphins</td>\n",
       "      <td>439</td>\n",
       "      <td>341</td>\n",
       "      <td>4</td>\n",
       "      <td>0.563</td>\n",
       "      <td>1966</td>\n",
       "      <td>784</td>\n",
       "      <td>AFC East</td>\n",
       "      <td>Kyle Field</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>New England Patriots[b]</td>\n",
       "      <td>476</td>\n",
       "      <td>383</td>\n",
       "      <td>9</td>\n",
       "      <td>0.554</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC East</td>\n",
       "      <td>Neyland Stadium</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                     Team  Won  Lost  Tied   Pct.  First NFL Season  \\\n",
       "0   1.0           Dallas Cowboys  511   367     1  0.573              1960   \n",
       "1   2.0        Green Bay Packers  730   553    37  0.567              1921   \n",
       "2   3.0            Chicago Bears  744   568    42  0.565              1920   \n",
       "3   4.0           Miami Dolphins  439   341     4  0.563              1966   \n",
       "4   5.0  New England Patriots[b]  476   383     9  0.554              1960   \n",
       "\n",
       "  Total Games   Division           Stadium  \n",
       "0         860   NFC East  Michigan Stadium  \n",
       "1       1,320  NFC North    Beaver Stadium  \n",
       "2       1,354  NFC North      Ohio Stadium  \n",
       "3         784   AFC East        Kyle Field  \n",
       "4         868   AFC East   Neyland Stadium  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nfl_frame.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "# delete a column\n",
    "del nfl_frame['Stadium']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>Rank</th>\n",
       "      <th>Team</th>\n",
       "      <th>Won</th>\n",
       "      <th>Lost</th>\n",
       "      <th>Tied</th>\n",
       "      <th>Pct.</th>\n",
       "      <th>First NFL Season</th>\n",
       "      <th>Total Games</th>\n",
       "      <th>Division</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Dallas Cowboys</td>\n",
       "      <td>511</td>\n",
       "      <td>367</td>\n",
       "      <td>1</td>\n",
       "      <td>0.573</td>\n",
       "      <td>1960</td>\n",
       "      <td>860</td>\n",
       "      <td>NFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Green Bay Packers</td>\n",
       "      <td>730</td>\n",
       "      <td>553</td>\n",
       "      <td>37</td>\n",
       "      <td>0.567</td>\n",
       "      <td>1921</td>\n",
       "      <td>1,320</td>\n",
       "      <td>NFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Chicago Bears</td>\n",
       "      <td>744</td>\n",
       "      <td>568</td>\n",
       "      <td>42</td>\n",
       "      <td>0.565</td>\n",
       "      <td>1920</td>\n",
       "      <td>1,354</td>\n",
       "      <td>NFC North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Miami Dolphins</td>\n",
       "      <td>439</td>\n",
       "      <td>341</td>\n",
       "      <td>4</td>\n",
       "      <td>0.563</td>\n",
       "      <td>1966</td>\n",
       "      <td>784</td>\n",
       "      <td>AFC East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>New England Patriots[b]</td>\n",
       "      <td>476</td>\n",
       "      <td>383</td>\n",
       "      <td>9</td>\n",
       "      <td>0.554</td>\n",
       "      <td>1960</td>\n",
       "      <td>868</td>\n",
       "      <td>AFC East</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Rank                     Team  Won  Lost  Tied   Pct.  First NFL Season  \\\n",
       "0   1.0           Dallas Cowboys  511   367     1  0.573              1960   \n",
       "1   2.0        Green Bay Packers  730   553    37  0.567              1921   \n",
       "2   3.0            Chicago Bears  744   568    42  0.565              1920   \n",
       "3   4.0           Miami Dolphins  439   341     4  0.563              1966   \n",
       "4   5.0  New England Patriots[b]  476   383     9  0.554              1960   \n",
       "\n",
       "  Total Games   Division  \n",
       "0         860   NFC East  \n",
       "1       1,320  NFC North  \n",
       "2       1,354  NFC North  \n",
       "3         784   AFC East  \n",
       "4         868   AFC East  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nfl_frame.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "# construct a DataFrame from a dictionary\n",
    "data = {'City':['Phoenix', 'San Diego', 'Houston', 'Tucson'], 'Population':[1615017, 1406630, 2303482, 530706]}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>City</th>\n",
       "      <th>Population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Phoenix</td>\n",
       "      <td>1615017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>San Diego</td>\n",
       "      <td>1406630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Houston</td>\n",
       "      <td>2303482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tucson</td>\n",
       "      <td>530706</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        City  Population\n",
       "0    Phoenix     1615017\n",
       "1  San Diego     1406630\n",
       "2    Houston     2303482\n",
       "3     Tucson      530706"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# \n",
    "city_frame = DataFrame(data)\n",
    "city_frame"
   ]
  },
  {
   "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.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}