z_db_init.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from tqdm import tqdm_notebook as tqdm\n",
    "from cfb import models as cfb_models\n",
    "import pandas as pd; DF=pd.DataFrame\n",
    "import numpy as np; import requests\n",
    "import os\n",
    "from django_pandas.io import read_frame as RF\n",
    "from os.path import join\n",
    "pwd=os.getcwd()\n",
    "from utils import *\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create Season Instances\n",
    "for year in range(1900,2100):\n",
    "    season,c = Season.objects.get_or_create(\n",
    "        year=year,defaults=dict(year=year)\n",
    "    )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create Season/Coach/Conference Instances"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "5cf6c1c49eb7483a88bbded335a47fc1",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "HBox(children=(FloatProgress(value=1.0, bar_style='info', max=1.0), HTML(value='')))"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Troy Calhoun\n",
      "Terry Bowden\n",
      "Nick Saban\n",
      "Bill Clark\n",
      "Scott Satterfield\n",
      "Kevin Sumlin\n",
      "Herm Edwards\n",
      "Chad Morris\n",
      "Blake Anderson\n",
      "Jeff Monken\n",
      "Gus Malzahn\n",
      "Mike Neu\n",
      "Matt Rhule\n",
      "Bryan Harsin\n",
      "Steve Addazio\n",
      "Mike Jinks\n",
      "Kalani Sitake\n",
      "Lance Leipold\n",
      "Justin Wilcox\n",
      "Josh Heupel\n",
      "John Bonamego\n",
      "Brad Lambert\n",
      "Luke Fickell\n",
      "Dabo Swinney\n",
      "Joe Moglia\n",
      "Mike MacIntyre\n",
      "Mike Bobo\n",
      "Randy Edsall\n",
      "David Cutcliffe\n",
      "Scottie Montgomery\n",
      "Chris Creighton\n",
      "Dan Mullen\n",
      "Lane Kiffin\n",
      "Butch Davis\n",
      "Willie Taggart\n",
      "Jeff Tedford\n",
      "Kirby Smart\n",
      "Chad Lunsford\n",
      "Shawn Elliott\n",
      "Paul Johnson\n",
      "Nick Rolovich\n",
      "Major Applewhite\n",
      "Lovie Smith\n",
      "Tom Allen\n",
      "Kirk Ferentz\n",
      "Matt Campbell\n",
      "David Beaty\n",
      "Bill Snyder\n",
      "Sean Lewis\n",
      "Mark Stoops\n",
      "Turner Gill\n",
      "Skip Holtz\n",
      "Billy Napier\n",
      "Matt Viator\n",
      "Bobby Petrino\n",
      "Ed Orgeron\n",
      "Doc Holliday\n",
      "DJ Durkin\n",
      "Mark Whipple\n",
      "Mike Norvell\n",
      "Mark Richt\n",
      "Chuck Martin\n",
      "Jim Harbaugh\n",
      "Mark Dantonio\n",
      "Rick Stockstill\n",
      "P.J. Fleck\n",
      "Matt Luke\n",
      "Joe Moorhead\n",
      "Barry Odom\n",
      "Ken Niumatalolo\n",
      "Scott Frost\n",
      "Jay Norvell\n",
      "Tony Sanchez\n",
      "Bob Davie\n",
      "Doug Martin\n",
      "Larry Fedora\n",
      "Dave Doeren\n",
      "Seth Littrell\n",
      "Rod Carey\n",
      "Pat Fitzgerald\n",
      "Brian Kelly\n",
      "Frank Solich\n",
      "Urban Meyer\n",
      "Lincoln Riley\n",
      "Mike Gundy\n",
      "Bobby Wilder\n",
      "Mario Cristobal\n",
      "Jonathan Smith\n",
      "James Franklin\n",
      "Pat Narduzzi\n",
      "Jeff Brohm\n",
      "Mike Bloomgren\n",
      "Chris Ash\n",
      "Rocky Long\n",
      "Brent Brennan\n",
      "Steve Campbell\n",
      "Will Muschamp\n",
      "Charlie Strong\n",
      "Clay Helton\n",
      "Sonny Dykes\n",
      "Jay Hopson\n",
      "David Shaw\n",
      "Dino Babers\n",
      "Jeremy Pruitt\n",
      "Tom Herman\n",
      "Jimbo Fisher\n",
      "Gary Patterson\n",
      "Everett Withers\n",
      "Kliff Kingsbury\n",
      "Dana Dimel\n",
      "Frank Wilson\n",
      "Jason Candle\n",
      "Neal Brown\n",
      "Willie Fritz\n",
      "Philip Montgomery\n",
      "Chip Kelly\n",
      "Kyle Whittingham\n",
      "Matt Wells\n",
      "Derek Mason\n",
      "Bronco Mendenhall\n",
      "Justin Fuente\n",
      "Dave Clawson\n",
      "Chris Petersen\n",
      "Mike Leach\n",
      "Dana Holgorsen\n",
      "Mike Sanford\n",
      "Tim Lester\n",
      "Paul Chryst\n",
      "Craig Bohl\n",
      "\n"
     ]
    }
   ],
   "source": [
    "path = join(pwd,'z_data\\Coaches9.csv')\n",
    "coaches_df=pd.read_csv(path)\n",
    "col_list=['SchoolPay','TotalPay','Bonus','BonusPaid','AssistantPay','Buyout']\n",
    "coaches_df = DataFrameCleaner(coaches_df).keep_numeric_only(col_list=col_list)\n",
    "\n",
    "\n",
    "### Create Season Objects \n",
    "for year in range(1900,2100):\n",
    "    season,c = Season.objects.get_or_create(\n",
    "        year=year,defaults=dict(year=year)\n",
    "    )\n",
    "\n",
    "###  Create TeamSeason Objects for 2019\n",
    "season = Season.objects.get(year=2019)\n",
    "def main():\n",
    "    for tup in tqdm(coaches_df.itertuples()):\n",
    "        # get or create school\n",
    "        school,c=cfb_models.School.objects.get_or_create(\n",
    "            name=tup.School,defaults=dict(name=tup.School)\n",
    "        )\n",
    "        # get or create team\n",
    "        team,c=cfb_models.Team.objects.get_or_create(\n",
    "            school=school,type='Football',\n",
    "            defaults=dict(school=school,type='Football')\n",
    "        )\n",
    "        # get or create conference\n",
    "        conf,c=cfb_models.Conference.objects.get_or_create(\n",
    "            name=tup.Conference,defaults=dict(name=tup.Conference)\n",
    "        )\n",
    "\n",
    "        # get or create coach\n",
    "        coach_name_arr = tup.Coach.strip().split(' ')\n",
    "        cfn=coach_name_arr[0]; cln=coach_name_arr[1]\n",
    "        coach,c = cfb_models.Coach.objects.get_or_create(\n",
    "            firstName=cfn,lastName=cln,\n",
    "            defaults=dict(firstName=cfn,lastName=cln)\n",
    "        )\n",
    "\n",
    "        # get or create team season\n",
    "        tseason,c = TeamSeason.objects.update_or_create(\n",
    "            team=team,season=season,conference=conf,coach=coach,\n",
    "            defaults=dict(team=team,season=season,conference=conf,coach=coach)\n",
    "        )\n",
    "        print(tseason.coach)\n",
    "        cpay,c = CoachPay.objects.update_or_create(\n",
    "            teamseason=tseason,base=tup.SchoolPay,total=tup.TotalPay,\n",
    "            bonus=tup.Bonus,bonusPaid=tup.BonusPaid,buyout=tup.Buyout,\n",
    "            defaults=dict(\n",
    "                teamseason=tseason,base=tup.SchoolPay,total=tup.TotalPay,\n",
    "                bonus=tup.Bonus,bonusPaid=tup.BonusPaid,buyout=tup.Buyout,        \n",
    "            )\n",
    "        )\n",
    "\n",
    "main()  "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create Team Season instances for previous seasons"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def create_team_season_instances():\n",
    "    for season in tqdm(Season.objects.all()):\n",
    "        for team in Team.objects.all():\n",
    "            teamseason,c = TeamSeason.objects.get_or_create(\n",
    "                team=team,season=season,\n",
    "                defaults=dict(team=team,season=season),\n",
    "            )\n",
    "            \n",
    "#create_team_season_instances()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Scrape cfbstats.com to extract url id for each team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "#### Get Teams URL ID from cfbstats\n",
    "\n",
    "def translate_team_name(old_name):\n",
    "    team_match_dict={\n",
    "        'BYU':'Brigham Young',\"Hawai'i\":'Hawaii', \n",
    "        'Miami (Florida)':'Miami (Fla.)', 'SMU':'Southern Methodist', \n",
    "        'TCU':'Texas Christian', 'UAB':'Alabama at Birmingham', \n",
    "        'UCF':'Central Florida', 'UNLV':'Nevada-Las Vegas',\n",
    "        'USC':'Southern California','UTEP':'Texas-El Paso', \n",
    "        'UTSA':'Texas-San Antonio','Appalachian St.':'Appalachian State',\n",
    "        'Fla. Atlantic':'Florida Atlantic',\"Florida Int'l\":'Florida International',\n",
    "        'Western Ky.':'Western Kentucky','Middle Tenn. St.':'Middle Tennessee'\n",
    "    } \n",
    "    old_name = replace_abbrevs(old_name)\n",
    "    if old_name in team_match_dict.keys():\n",
    "        new_name = team_match_dict[old_name]    \n",
    "    else:\n",
    "        new_name = old_name\n",
    "    return new_name\n",
    "\n",
    "def replace_abbrevs(old_name):\n",
    "    new_name=old_name\n",
    "    replace_arr=[\n",
    "        ['St.','State'],\n",
    "        ['Ala.','Alabama'],\n",
    "        ['Ga.','Georgia'],\n",
    "        ['Fla.','Florida'],\n",
    "        ['Ill.','Illinois'],\n",
    "        ['Caro.','Carolina'],\n",
    "        ['Ky.','Kentucky'],\n",
    "        ['La.','Louisiana'],\n",
    "        ['Mich.','Michigan'],\n",
    "        ['Miss.','Mississippi'],\n",
    "    ]\n",
    "    for r in replace_arr:\n",
    "        new_name=new_name.replace(r[0],r[1])\n",
    "    return new_name\n",
    "    \n",
    "def get_team_home_page_dfs_from_cfbstats(team_id,year):\n",
    "    url = f'http://www.cfbstats.com/{year}/team/{team_id}/index.html'\n",
    "    r=requests.get(url)\n",
    "    try:\n",
    "        dfs=pd.read_html(r.content)\n",
    "    except ValueError:\n",
    "        dfs=[]\n",
    "    return dfs\n",
    "\n",
    "def main():\n",
    "    found_count=0\n",
    "    target = len(coaches_df)\n",
    "    for i in tqdm(range(0,1000)):\n",
    "        urlId=str(i)\n",
    "        dfs=get_team_home_page_dfs_from_cfbstats(i,year=2019)\n",
    "        if len(dfs)==0: continue\n",
    "        found_count+=1\n",
    "        tname = dfs[0].columns[1]\n",
    "        tname = translate_team_name(tname)\n",
    "        team = Team.objects.filter(school__name=tname).first()\n",
    "\n",
    "        cfbs_id,c = CfbstatsUrlId.objects.update_or_create(\n",
    "            team=team,urlId=urlId,\n",
    "            defaults=dict(team=team,urlId=urlId)\n",
    "        )\n",
    "#main()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## ----- Get 2019 Season Stats -----"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "def get_home_page_info(teamseason):\n",
    "    dfs = get_team_home_page_dfs_from_cfbstats(teamseason.team.cfbs.urlId,year=teamseason.season.year)\n",
    "    team_stats_df = dfs[0]\n",
    "    team_stats_df = team_stats_df.rename(columns={'Unnamed: 0':'stat_str'})\n",
    "    tname = team_stats_df.columns[1]\n",
    "    team_stats_df = team_stats_df.rename(columns={tname:'value'})\n",
    "\n",
    "    game_result_tdf = dfs[1]\n",
    "    record_df = dfs[2]\n",
    "\n",
    "    def get_loc(val):\n",
    "        if val[0]=='@':\n",
    "            loc = 'A' \n",
    "        elif val[0]=='+':\n",
    "            loc = 'N'\n",
    "        else:\n",
    "            loc = 'H'\n",
    "        return loc\n",
    "\n",
    "    game_result_df = game_result_tdf.iloc[:-1,:].copy()\n",
    "    game_result_df['loc']=game_result_df['Opponent'].map(get_loc)\n",
    "    game_result_df['Opponent']=game_result_df['Opponent'].str.replace('@','').str.replace('+','')\n",
    "    game_result_df['Date']=pd.to_datetime(game_result_df['Date'])\n",
    "    game_result_df=game_result_df.rename(columns={'Game Time':'Game_Time'})\n",
    "\n",
    "    for tup in record_df.itertuples():\n",
    "        desc=tup.Split\n",
    "        record = tup.Record.strip().split('-')\n",
    "        win=record[0]\n",
    "        loss=record[1]\n",
    "        \n",
    "        ts_record,c = TeamSeasonRecord.objects.update_or_create(\n",
    "            teamseason=teamseason,desc=desc,\n",
    "            defaults=dict(teamseason=teamseason,desc=desc,win=win,loss=loss)\n",
    "        )\n",
    "    for tup in game_result_df.itertuples():\n",
    "        date = tup.Date\n",
    "        attendance = tup.Attendance\n",
    "        result_str = tup.Result\n",
    "        result = result_str[0]\n",
    "        if result not in ['L','W']: result = 'T'\n",
    "        score_str = result_str[2:]\n",
    "        score1 = score_str.split('-')[0]\n",
    "        score2 = score_str.split('-')[1]\n",
    "        score_arr = [int(score1),int(score2)]\n",
    "        if result=='W':\n",
    "            score,oscore=(max(score_arr),min(score_arr))\n",
    "        else:\n",
    "            score,oscore=(min(score_arr),max(score_arr))\n",
    "\n",
    "        oname=tup.Opponent.strip()\\\n",
    "            .replace('St.','State').replace('Ala.','Alabama')\n",
    "        if oname[0].isnumeric():\n",
    "            orank = oname.split(' ')[0]\n",
    "            oname = \" \".join(oname.split(' ')[1:])\n",
    "        else:\n",
    "            orank=None\n",
    "        oname = translate_team_name(oname)       \n",
    "\n",
    "        glen = str(tup.Game_Time)\n",
    "        glen_arr = glen.split(':')\n",
    "        hours = float(glen_arr[0])\n",
    "        hour_frac = float(glen_arr[1])/60 if len(glen.split(':'))>1 else 0\n",
    "        glen = hours + hour_frac\n",
    "        opponent = TeamSeason.objects.filter(\n",
    "            season=teamseason.season,\n",
    "            team__school__name=oname\n",
    "        ).first()\n",
    "\n",
    "        gr,c = GameResult.objects.update_or_create(\n",
    "            teamseason=teamseason,\n",
    "            oname=oname,\n",
    "            date=date,\n",
    "            defaults=dict(\n",
    "                teamseason=teamseason,\n",
    "                opponent=opponent,\n",
    "                oname=oname,\n",
    "                date=date,\n",
    "                score=score,\n",
    "                oscore=oscore,\n",
    "                result=result,\n",
    "                attendance=attendance,\n",
    "                length=glen,\n",
    "            )\n",
    "        )\n",
    "    for tup in team_stats_df.itertuples():\n",
    "        stat_str = tup.stat_str\n",
    "        category=(stat_str.split(':')[0]).replace('/','per')\n",
    "        desc_str=(stat_str.split(':')[1]).strip() if len(stat_str.split(':'))>1 else category\n",
    "\n",
    "\n",
    "        desc_arr = desc_str.replace('/','per').split(' - ')\n",
    "        value_arr = tup.value.replace('%','').split(' - ')\n",
    "        ovalue_arr = tup.Opponents.replace('%','').split(' - ')\n",
    "\n",
    "\n",
    "        vtups = list(zip(desc_arr,value_arr,ovalue_arr))\n",
    "        for vtup in vtups:\n",
    "            desc=vtup[0]\n",
    "            value=vtup[1]\n",
    "            ovalue=vtup[2]\n",
    "            value = value.replace(',','')\n",
    "            ovalue = ovalue.replace(',','')  \n",
    "            if ':' in value:\n",
    "                value = float(value.split(':')[0]) + float(value.split(':')[1])/60\n",
    "                ovalue = float(ovalue.split(':')[0]) + float(ovalue.split(':')[1])/60\n",
    "\n",
    "            if value=='-':value=np.nan\n",
    "            if ovalue=='-':ovalue=np.nan\n",
    "            tss,c = TeamSeasonStat.objects.update_or_create(\n",
    "                teamseason=teamseason,\n",
    "                category=category,\n",
    "                desc=desc,\n",
    "                defaults=dict(\n",
    "                    teamseason=teamseason,\n",
    "                    category=category,\n",
    "                    desc=desc,\n",
    "                    value=value,\n",
    "                    ovalue=ovalue               \n",
    "                )\n",
    "            )\n",
    "\n",
    "def get_all_seasons_stats():\n",
    "    ### Get all Seasons Stats\n",
    "    for year_num in tqdm(range(2010,2020)):\n",
    "        season = Season.objects.get(year=year_num)\n",
    "        print(season)\n",
    "        for teamseason in tqdm(TeamSeason.objects.filter(season=season)):\n",
    "            try:\n",
    "                get_home_page_info(teamseason)\n",
    "            except IndexError:\n",
    "                pass\n",
    "#get_all_seasons_stats()   "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get Stadium Capacities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Aggie Memorial Stadium, Las Cruces, NM\n",
      "Alamodome, San Antonio, TX\n",
      "Alaska Airlines Field at Husky Stadium, Seattle, WA\n",
      "Albertsons Stadium, Boise, ID\n",
      "Allen E. Paulson Stadium, Statesboro, GA\n",
      "Aloha Stadium, Honolulu, HI\n",
      "Alumni Stadium, Chestnut Hill, MA\n",
      "Amon G. Carter Stadium, Fort Worth, TX\n",
      "Apogee Stadium, Denton, TX\n",
      "Arizona Stadium, Tucson, AZ\n",
      "Arthur L. Williams Stadium, Lynchburg, VA\n",
      "Autzen Stadium, Eugene, OR\n",
      "Bagwell Field at Dowdy–Ficklen Stadium, Greenville, NC\n",
      "BB&T Field, Winston-Salem, NC\n",
      "Beaver Stadium, University Park, PA\n",
      "Benson Field at Yulman Stadium, New Orleans, LA\n",
      "Bill Snyder Family Football Stadium, Manhattan, KS\n",
      "Blaik Field at Michie Stadium, West Point, NY\n",
      "Bobby Bowden Field at Doak S. Campbell Stadium, Tallahassee, FL\n",
      "Bobby Dodd Stadium at Historic Grant Field, Atlanta, GA\n",
      "Boone Pickens Stadium, Stillwater, OK\n",
      "Brigham Field at Huskie Stadium, DeKalb, IL\n",
      "Brooks Field at Wallace Wade Stadium, Durham, NC\n",
      "Brooks Stadium, Conway, SC\n",
      "Bryant–Denny Stadium, Tuscaloosa, AL\n",
      "Bulldog Stadium at Jim Sweeney Field, Fresno, CA\n",
      "Cajun Field, Lafayette, LA\n",
      "California Memorial Stadium, Berkeley, CA\n",
      "Camp Randall Stadium, Madison, WI\n",
      "Capital One Field at Maryland Stadium, College Park, MD\n",
      "Cardinal Stadium, Louisville, KY\n",
      "Carl Smith Center, Home of David A. Harrison III Field at Scott Stadium, Charlottesville, VA\n",
      "Carlisle-Faulkner Field at M.M. Roberts Stadium, Hattiesburg, MS\n",
      "Carrier Dome, Syracuse, NY\n",
      "CEFCU Stadium, San Jose, CA\n",
      "Centennial Bank Stadium, Jonesboro, AR\n",
      "Darrell K Royal–Texas Memorial Stadium, Austin, TX\n",
      "David Booth Kansas Memorial Stadium, Lawrence, KS\n",
      "Davis Wade Stadium at Scott Field, Starkville, MS\n",
      "Dix Stadium, Kent, OH\n",
      "Doyt L. Perry Stadium, Bowling Green, OH\n",
      "Dreamstyle Stadium, Albuquerque, NM\n",
      "Falcon Stadium, Colorado Springs, CO\n",
      "FAU Stadium, Boca Raton, FL\n",
      "Faurot Field at Memorial Stadium, Columbia, MO\n",
      "Folsom Field, Boulder, CO\n",
      "Frank Kush Field at Sun Devil Stadium, Tempe, AZ\n",
      "Frank Howard Field at Clemson Memorial Stadium, Clemson, SC\n",
      "Fred C. Yager Stadium, Oxford, OH\n",
      "Gaylord Family – Oklahoma Memorial Stadium at Owen Field, Norman, OK\n",
      "Georgia State Stadium, Atlanta, GA\n",
      "Gerald J. Ford Stadium, University Park, TX\n",
      "Glass Bowl, Toledo, OH\n",
      "Hard Rock Stadium, Miami Gardens, FL\n",
      "Heinz Field, Pittsburgh, PA\n",
      "Houchens Industries–L. T. Smith Stadium at Jimmy Feix Field, Bowling Green, KY\n",
      "InfoCision Stadium–Summa Field, Akron, OH\n",
      "Jack Trice Stadium, Ames, IA\n",
      "Jim Wacker Field at Bobcat Stadium, San Marcos, TX\n",
      "Joan C. Edwards Stadium, Huntington, WV\n",
      "Joe Aillet Stadium, Ruston, LA\n",
      "John O'Quinn Field at TDECU Stadium, Houston, TX\n",
      "Johnny \"Red\" Floyd Stadium, Murfreesboro, TN\n",
      "Jonah Field at War Memorial Stadium, Laramie, WY\n",
      "Jones AT&T Stadium, Lubbock, TX\n",
      "JPS Field at Malone Stadium, Monroe, LA\n",
      "Kelly/Shorts Stadium, Mount Pleasant, MI\n",
      "Kenan Memorial Stadium, Chapel Hill, NC\n",
      "Kidd Brewer Stadium, Boone, NC\n",
      "Kinnick Stadium, Iowa City, IA\n",
      "Kornblau Field at S.B. Ballard Stadium, Norfolk, VA\n",
      "Kroger Field at C.M. Newton Grounds, Lexington, KY\n",
      "Kyle Field, College Station, TX\n",
      "Ladd–Peebles Stadium, Mobile, AL\n",
      "Lane Stadium/Worsham Field, Blacksburg, VA\n",
      "LaVell Edwards Stadium, Provo, UT\n",
      "Legion Field, Birmingham, AL\n",
      "Liberty Bowl Memorial Stadium, Memphis, TN\n",
      "Lincoln Financial Field, Philadelphia, PA\n",
      "Los Angeles Memorial Coliseum, Los Angeles, CA\n",
      "Mackay Stadium, Reno, NV\n",
      "Martin Stadium, Pullman, WA\n",
      "McColl–Richardson Field at Jerry Richardson Stadium, Charlotte, NC\n",
      "McLane Stadium, Waco, TX\n",
      "Memorial Stadium, Champaign, IL\n",
      "Memorial Stadium, Bloomington, IN\n",
      "Memorial Stadium, Tom Osborne Field, Lincoln, NE\n",
      "Merlin Olsen Field at Maverik Stadium, Logan, UT\n",
      "Michigan Stadium, Ann Arbor, MI\n",
      "Mountaineer Field at Milan Puskar Stadium, Morgantown, WV\n",
      "Navy–Marine Corps Memorial Stadium, Annapolis, MD\n",
      "Neyland Stadium, Knoxville, TN\n",
      "Nippert Stadium, Cincinnati, OH\n",
      "Notre Dame Stadium, Notre Dame, IN\n",
      "Ohio Stadium, Columbus, OH\n",
      "Pat Dye Field at Jordan–Hare Stadium, Auburn, AL\n",
      "Peden Stadium, Athens, OH\n",
      "Pratt & Whitney Stadium at Rentschler Field, East Hartford, CT\n",
      "Raymond James Stadium, Tampa, FL\n",
      "Donald W. Reynolds Razorback Stadium, Frank Broyles Field, Fayetteville, AR\n",
      "Reser Stadium, Corvallis, OR\n",
      "Riccardo Silva Stadium, Miami, FL\n",
      "Rice Stadium, Houston, TX\n",
      "Rice-Eccles Stadium, Salt Lake City, UT\n",
      "Rose Bowl Stadium, Pasadena, CA\n",
      "Ross–Ade Stadium, West Lafayette, IN\n",
      "Ryan Field, Evanston, IL\n",
      "Rynearson Stadium, Ypsilanti, MI\n",
      "Sam Boyd Stadium, Whitney, NV\n",
      "Sanford Stadium, Athens, GA\n",
      "Scheumann Stadium, Muncie, IN\n",
      "SDCCU Stadium, San Diego, CA\n",
      "SHI Stadium, Piscataway, NJ\n",
      "Skelly Field at H. A. Chapman Stadium, Tulsa, OK\n",
      "Sonny Lubick Field at Canvas Stadium, Fort Collins, CO\n",
      "Spartan Stadium, East Lansing, MI\n",
      "Spectrum Stadium, Orlando, FL\n",
      "Stanford Stadium, Stanford, CA\n",
      "Steve Spurrier-Florida Field at Ben Hill Griffin Stadium, Gainesville, FL\n",
      "Sun Bowl Stadium, El Paso, TX\n",
      "TCF Bank Stadium, Minneapolis, MN\n",
      "Tiger Stadium, Baton Rouge, LA\n",
      "UB Stadium, Amherst, NY\n",
      "Vanderbilt Stadium, Nashville, TN\n",
      "Vaught–Hemingway Stadium at Hollingsworth Field, Oxford, MS\n",
      "Veterans Memorial Stadium at Larry Blakeney Field, Troy, AL\n",
      "Waldo Stadium, Kalamazoo, MI\n",
      "Warren McGuirk Alumni Stadium, Hadley, MA\n",
      "Wayne Day Family Field at Carter–Finley Stadium, Raleigh, NC\n",
      "Williams-Brice Stadium, Columbia, SC\n"
     ]
    }
   ],
   "source": [
    "def get_stadium_capacities(show_results=True):\n",
    "    url=r'https://en.wikipedia.org/wiki/List_of_NCAA_Division_I_FBS_football_stadiums'\n",
    "    df=pd.read_html(url)[0]\n",
    "    df=df.rename(columns={'Record1':'att_record','Expanded 2':'Expanded'})\n",
    "    df=df.drop('Image',axis=1)\n",
    "    def remove_wiki_citation(df,col_list=None):\n",
    "        if col_list == None:\n",
    "            col_list = df.columns\n",
    "        for col in col_list:\n",
    "            df[col].str.split('[',expand=True)[0]\n",
    "\n",
    "    DFC = DataFrameCleaner(df)\n",
    "    DFC.remove_wiki_citation()\n",
    "    DFC.keep_numeric_only(col_list=['Capacity','Built','Expanded'],type_coerce=np.float)\n",
    "    df = DFC.df\n",
    "    df=df.replace(np.nan,None)\n",
    "    df['Built']=df['Built'].astype(str).str[:4].astype(int)\n",
    "    df['Expanded']=df['Expanded'].astype(str).str[:4].astype(int)\n",
    "    for tup in df.itertuples():\n",
    "        if tup.Capacity > 200_000:\n",
    "            cap=float(str(tup.Capacity)[:5])\n",
    "        else:\n",
    "            cap = tup.Capacity\n",
    "        stadium,c = Stadium.objects.update_or_create(\n",
    "            name=tup.Stadium,\n",
    "            defaults=dict(\n",
    "                name=tup.Stadium,\n",
    "                city=tup.City,\n",
    "                state=tup.State,\n",
    "                year_built=tup.Built,\n",
    "                year_expanded=tup.Expanded,\n",
    "                capacity=cap,\n",
    "                wiki_team_name=tup.Team,\n",
    "                surface=tup.Surface\n",
    "            )\n",
    "        )\n",
    "\n",
    "        school_name = stadium.wiki_team_name\n",
    "        if stadium.wiki_team_name == 'Miami':\n",
    "            school_name = 'Miami (Fla.)' if tup.State=='OH' else 'Miami (Ohio)'\n",
    "        if stadium.wiki_team_name == 'Louisiana':\n",
    "            school_name = 'Louisiana-Lafayette'\n",
    "        if stadium.wiki_team_name[:5] == 'Hawai':\n",
    "            school_name = 'Hawaii'  \n",
    "\n",
    "        team = Team.objects.filter(school__name=school_name).first()\n",
    "        if pd.isna(team):\n",
    "            school_name = team_match_dict.get(school_name)\n",
    "            team = Team.objects.filter(school__name=school_name).first()\n",
    "\n",
    "        teamseason_qs = team.teamseason_set.filter(season__year__gte=stadium.year_built)\n",
    "        if len(teamseason_qs)==0:\n",
    "            print(stadium)\n",
    "            print(stadium.year_built)\n",
    "            print(team)\n",
    "        if show_results:\n",
    "            print(stadium)\n",
    "get_stadium_capacities(show_results=True) "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get Grad Rates\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Cohort Year</th>\n",
       "      <th>School</th>\n",
       "      <th>Conference</th>\n",
       "      <th>Sport</th>\n",
       "      <th>State</th>\n",
       "      <th>GSR</th>\n",
       "      <th>FGR</th>\n",
       "      <th>GSR Report</th>\n",
       "      <th>FGR Report</th>\n",
       "      <th>sog</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1998</td>\n",
       "      <td>University of Akron</td>\n",
       "      <td>Mid-American Conference</td>\n",
       "      <td>Football</td>\n",
       "      <td>OH</td>\n",
       "      <td>60.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>University of Akron</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1998</td>\n",
       "      <td>Alabama State University</td>\n",
       "      <td>Southwestern Athletic Conf.</td>\n",
       "      <td>Football</td>\n",
       "      <td>AL</td>\n",
       "      <td>44.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alabama State University</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1998</td>\n",
       "      <td>University of Alabama</td>\n",
       "      <td>Southeastern Conference</td>\n",
       "      <td>Football</td>\n",
       "      <td>AL</td>\n",
       "      <td>39.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>University of Alabama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1998</td>\n",
       "      <td>University of Alabama at Birmingham</td>\n",
       "      <td>Conference USA</td>\n",
       "      <td>Football</td>\n",
       "      <td>AL</td>\n",
       "      <td>51.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>University of Alabama at Birmingham</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1998</td>\n",
       "      <td>Alcorn State University</td>\n",
       "      <td>Southwestern Athletic Conf.</td>\n",
       "      <td>Football</td>\n",
       "      <td>MS</td>\n",
       "      <td>88.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alcorn State University</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3584</th>\n",
       "      <td>2012</td>\n",
       "      <td>Presbyterian College</td>\n",
       "      <td>Big South Conference</td>\n",
       "      <td>Football</td>\n",
       "      <td>SC</td>\n",
       "      <td>72.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Presbyterian College</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3585</th>\n",
       "      <td>2012</td>\n",
       "      <td>1 - DI CA Test</td>\n",
       "      <td>Independent</td>\n",
       "      <td>Football</td>\n",
       "      <td>AK</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1 - DI CA Test</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3586</th>\n",
       "      <td>2012</td>\n",
       "      <td>University of Arkansas, Pine Bluff</td>\n",
       "      <td>Southwestern Athletic Conf.</td>\n",
       "      <td>Football</td>\n",
       "      <td>AR</td>\n",
       "      <td>66.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>University of Arkansas, Pine Bluff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3587</th>\n",
       "      <td>2012</td>\n",
       "      <td>University of the Incarnate Word</td>\n",
       "      <td>Southland Conference</td>\n",
       "      <td>Football</td>\n",
       "      <td>TX</td>\n",
       "      <td>86.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>University of the Incarnate Word</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3588</th>\n",
       "      <td>2012</td>\n",
       "      <td>Wofford College</td>\n",
       "      <td>Southern Conference</td>\n",
       "      <td>Football</td>\n",
       "      <td>SC</td>\n",
       "      <td>92.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wofford College</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3589 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Cohort Year                               School  \\\n",
       "0            1998                  University of Akron   \n",
       "1            1998             Alabama State University   \n",
       "2            1998                University of Alabama   \n",
       "3            1998  University of Alabama at Birmingham   \n",
       "4            1998              Alcorn State University   \n",
       "...           ...                                  ...   \n",
       "3584         2012                 Presbyterian College   \n",
       "3585         2012                       1 - DI CA Test   \n",
       "3586         2012   University of Arkansas, Pine Bluff   \n",
       "3587         2012     University of the Incarnate Word   \n",
       "3588         2012                      Wofford College   \n",
       "\n",
       "                       Conference     Sport State    GSR    FGR  GSR Report  \\\n",
       "0         Mid-American Conference  Football    OH   60.0   53.0         NaN   \n",
       "1     Southwestern Athletic Conf.  Football    AL   44.0   41.0         NaN   \n",
       "2         Southeastern Conference  Football    AL   39.0   39.0         NaN   \n",
       "3                  Conference USA  Football    AL   51.0   52.0         NaN   \n",
       "4     Southwestern Athletic Conf.  Football    MS   88.0   45.0         NaN   \n",
       "...                           ...       ...   ...    ...    ...         ...   \n",
       "3584         Big South Conference  Football    SC   72.0   56.0         NaN   \n",
       "3585                  Independent  Football    AK  100.0  100.0         NaN   \n",
       "3586  Southwestern Athletic Conf.  Football    AR   66.0   51.0         NaN   \n",
       "3587         Southland Conference  Football    TX   86.0   56.0         NaN   \n",
       "3588          Southern Conference  Football    SC   92.0   79.0         NaN   \n",
       "\n",
       "      FGR Report                                  sog  \n",
       "0            NaN                  University of Akron  \n",
       "1            NaN             Alabama State University  \n",
       "2            NaN                University of Alabama  \n",
       "3            NaN  University of Alabama at Birmingham  \n",
       "4            NaN              Alcorn State University  \n",
       "...          ...                                  ...  \n",
       "3584         NaN                 Presbyterian College  \n",
       "3585         NaN                       1 - DI CA Test  \n",
       "3586         NaN   University of Arkansas, Pine Bluff  \n",
       "3587         NaN     University of the Incarnate Word  \n",
       "3588         NaN                      Wofford College  \n",
       "\n",
       "[3589 rows x 10 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>Cohort Year</th>\n",
       "      <th>School</th>\n",
       "      <th>Conference</th>\n",
       "      <th>Sport</th>\n",
       "      <th>State</th>\n",
       "      <th>GSR</th>\n",
       "      <th>FGR</th>\n",
       "      <th>GSR Report</th>\n",
       "      <th>FGR Report</th>\n",
       "      <th>sog</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>1999</td>\n",
       "      <td>South Carolina State University</td>\n",
       "      <td>Mid-Eastern Athletic Conf.</td>\n",
       "      <td>Football</td>\n",
       "      <td>SC</td>\n",
       "      <td>60.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>South Carolina State University</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>2001</td>\n",
       "      <td>Kansas State</td>\n",
       "      <td>Big 12 Conference</td>\n",
       "      <td>Football</td>\n",
       "      <td>KS</td>\n",
       "      <td>67.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kansas State University</td>\n",
       "      <td>2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3126</th>\n",
       "      <td>2011</td>\n",
       "      <td>The Citadel</td>\n",
       "      <td>Southern Conference</td>\n",
       "      <td>Football</td>\n",
       "      <td>SC</td>\n",
       "      <td>82.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The Citadel</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>2000</td>\n",
       "      <td>Florida State</td>\n",
       "      <td>Atlantic Coast Conference</td>\n",
       "      <td>Football</td>\n",
       "      <td>FL</td>\n",
       "      <td>58.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Florida State University</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1199</th>\n",
       "      <td>2003</td>\n",
       "      <td>Florida State</td>\n",
       "      <td>Atlantic Coast Conference</td>\n",
       "      <td>Football</td>\n",
       "      <td>FL</td>\n",
       "      <td>64.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Florida State University</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Cohort Year                           School  \\\n",
       "376          1999  South Carolina State University   \n",
       "754          2001                     Kansas State   \n",
       "3126         2011                      The Citadel   \n",
       "494          2000                    Florida State   \n",
       "1199         2003                    Florida State   \n",
       "\n",
       "                      Conference     Sport State   GSR   FGR  GSR Report  \\\n",
       "376   Mid-Eastern Athletic Conf.  Football    SC  60.0  42.0         NaN   \n",
       "754            Big 12 Conference  Football    KS  67.0  70.0         NaN   \n",
       "3126         Southern Conference  Football    SC  82.0  67.0         NaN   \n",
       "494    Atlantic Coast Conference  Football    FL  58.0  48.0         NaN   \n",
       "1199   Atlantic Coast Conference  Football    FL  64.0  58.0         NaN   \n",
       "\n",
       "      FGR Report                              sog  year  \n",
       "376          NaN  South Carolina State University  1999  \n",
       "754          NaN          Kansas State University  2001  \n",
       "3126         NaN                      The Citadel  2011  \n",
       "494          NaN         Florida State University  2000  \n",
       "1199         NaN         Florida State University  2003  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1998, Football, Akron\n",
      "1998, Football, Alabama\n",
      "1998, Football, Alabama at Birmingham\n",
      "1998, Football, Appalachian State\n",
      "1998, Football, Arizona State\n",
      "1998, Football, Arizona\n",
      "1998, Football, Arkansas State\n",
      "1998, Football, Arkansas\n",
      "1998, Football, Auburn\n",
      "1998, Football, Ball State\n",
      "1998, Football, Baylor\n",
      "1998, Football, Boise State\n",
      "1998, Football, Boston College\n",
      "1998, Football, Bowling Green\n",
      "1998, Football, Brigham Young\n",
      "1998, Football, Buffalo\n",
      "1998, Football, Fresno State\n",
      "1998, Football, California\n",
      "1998, Football, UCLA\n",
      "1998, Football, Central Florida\n",
      "1998, Football, Central Michigan\n",
      "1998, Football, Cincinnati\n",
      "1998, Football, Clemson\n",
      "1998, Football, Colorado State\n",
      "1998, Football, Colorado\n",
      "1998, Football, Connecticut\n",
      "1998, Football, Duke\n",
      "1998, Football, East Carolina\n",
      "1998, Football, Eastern Michigan\n",
      "1998, Football, Florida State\n",
      "1998, Football, Florida\n",
      "1998, Football, Georgia Southern\n",
      "1998, Football, Georgia Tech\n",
      "1998, Football, Georgia\n",
      "1998, Football, Hawaii\n",
      "1998, Football, Houston\n",
      "1998, Football, Illinois\n",
      "1998, Football, Indiana\n",
      "1998, Football, Iowa State\n",
      "1998, Football, Iowa\n",
      "1998, Football, Kansas State\n",
      "1998, Football, Kansas\n",
      "1998, Football, Kent State\n",
      "1998, Football, Kentucky\n",
      "1998, Football, Liberty\n",
      "1998, Football, LSU\n",
      "1998, Football, Louisiana Tech\n",
      "1998, Football, Louisville\n",
      "1998, Football, Marshall\n",
      "1998, Football, Maryland\n",
      "1998, Football, Massachusetts\n",
      "1998, Football, Memphis\n",
      "1998, Football, Miami (Ohio)\n",
      "1998, Football, Miami (Fla.)\n",
      "1998, Football, Michigan State\n",
      "1998, Football, Michigan\n",
      "1998, Football, Middle Tennessee\n",
      "1998, Football, Minnesota\n",
      "1998, Football, Mississippi State\n",
      "1998, Football, Mississippi\n",
      "1998, Football, Missouri\n",
      "1998, Football, North Carolina\n",
      "1998, Football, Nebraska\n",
      "1998, Football, Nevada-Las Vegas\n",
      "1998, Football, Nevada\n",
      "1998, Football, New Mexico State\n",
      "1998, Football, New Mexico\n",
      "1998, Football, North Carolina State\n",
      "1998, Football, North Texas\n",
      "1998, Football, Louisiana-Monroe\n",
      "1998, Football, Northern Illinois\n",
      "1998, Football, Northwestern\n",
      "1998, Football, Notre Dame\n",
      "1998, Football, Ohio State\n",
      "1998, Football, Ohio\n",
      "1998, Football, Oklahoma State\n",
      "1998, Football, Oklahoma\n",
      "1998, Football, Oregon State\n",
      "1998, Football, Oregon\n",
      "1998, Football, Penn State\n",
      "1998, Football, Pittsburgh\n",
      "1998, Football, Purdue\n",
      "1998, Football, Rice\n",
      "1998, Football, Rutgers\n",
      "1998, Football, San Diego State\n",
      "1998, Football, San Jose State\n",
      "1998, Football, South Carolina\n",
      "1998, Football, South Florida\n",
      "1998, Football, Southern California\n",
      "1998, Football, Southern Methodist\n",
      "1998, Football, Southern Mississippi\n",
      "1998, Football, Texas State\n",
      "1998, Football, Louisiana-Lafayette\n",
      "1998, Football, Stanford\n",
      "1998, Football, Syracuse\n",
      "1998, Football, Temple\n",
      "1998, Football, Tennessee\n",
      "1998, Football, Texas A&M\n",
      "1998, Football, Texas Christian\n",
      "1998, Football, Texas Tech\n",
      "1998, Football, Texas\n",
      "1998, Football, Texas-El Paso\n",
      "1998, Football, Toledo\n",
      "1998, Football, Troy\n",
      "1998, Football, Tulane\n",
      "1998, Football, Tulsa\n",
      "1998, Football, Air Force\n",
      "1998, Football, Army\n",
      "1998, Football, Navy\n",
      "1998, Football, Utah State\n",
      "1998, Football, Utah\n",
      "1998, Football, Vanderbilt\n",
      "1998, Football, Virginia Tech\n",
      "1998, Football, Virginia\n",
      "1998, Football, Wake Forest\n",
      "1998, Football, Washington State\n",
      "1998, Football, Washington\n",
      "1998, Football, West Virginia\n",
      "1998, Football, Western Kentucky\n",
      "1998, Football, Western Michigan\n",
      "1998, Football, Wisconsin\n",
      "1998, Football, Wyoming\n",
      "1999, Football, Akron\n",
      "1999, Football, Alabama\n",
      "1999, Football, Alabama at Birmingham\n",
      "1999, Football, Appalachian State\n",
      "1999, Football, Arizona State\n",
      "1999, Football, Arizona\n",
      "1999, Football, Arkansas State\n",
      "1999, Football, Arkansas\n",
      "1999, Football, Auburn\n",
      "1999, Football, Ball State\n",
      "1999, Football, Baylor\n",
      "1999, Football, Boise State\n",
      "1999, Football, Boston College\n",
      "1999, Football, Bowling Green\n",
      "1999, Football, Brigham Young\n",
      "1999, Football, Buffalo\n",
      "1999, Football, Fresno State\n",
      "1999, Football, California\n",
      "1999, Football, UCLA\n",
      "1999, Football, Central Florida\n",
      "1999, Football, Central Michigan\n",
      "1999, Football, Cincinnati\n",
      "1999, Football, Clemson\n",
      "1999, Football, Colorado State\n",
      "1999, Football, Colorado\n",
      "1999, Football, Connecticut\n",
      "1999, Football, Duke\n",
      "1999, Football, East Carolina\n",
      "1999, Football, Eastern Michigan\n",
      "1999, Football, Florida State\n",
      "1999, Football, Florida\n",
      "1999, Football, Georgia Southern\n",
      "1999, Football, Georgia Tech\n",
      "1999, Football, Georgia\n",
      "1999, Football, Hawaii\n",
      "1999, Football, Houston\n",
      "1999, Football, Illinois\n",
      "1999, Football, Indiana\n",
      "1999, Football, Iowa State\n",
      "1999, Football, Iowa\n",
      "1999, Football, Kansas State\n",
      "1999, Football, Kansas\n",
      "1999, Football, Kent State\n",
      "1999, Football, Kentucky\n",
      "1999, Football, Liberty\n",
      "1999, Football, LSU\n",
      "1999, Football, Louisiana Tech\n",
      "1999, Football, Louisville\n",
      "1999, Football, Marshall\n",
      "1999, Football, Maryland\n",
      "1999, Football, Massachusetts\n",
      "1999, Football, Memphis\n",
      "1999, Football, Miami (Ohio)\n",
      "1999, Football, Miami (Fla.)\n",
      "1999, Football, Michigan State\n",
      "1999, Football, Michigan\n",
      "1999, Football, Middle Tennessee\n",
      "1999, Football, Minnesota\n",
      "1999, Football, Mississippi State\n",
      "1999, Football, Mississippi\n",
      "1999, Football, Missouri\n",
      "1999, Football, North Carolina\n",
      "1999, Football, Nebraska\n",
      "1999, Football, Nevada-Las Vegas\n",
      "1999, Football, Nevada\n",
      "1999, Football, New Mexico State\n",
      "1999, Football, New Mexico\n",
      "1999, Football, North Carolina State\n",
      "1999, Football, North Texas\n",
      "1999, Football, Louisiana-Monroe\n",
      "1999, Football, Northern Illinois\n",
      "1999, Football, Northwestern\n",
      "1999, Football, Notre Dame\n",
      "1999, Football, Ohio State\n",
      "1999, Football, Ohio\n",
      "1999, Football, Oklahoma State\n",
      "1999, Football, Oklahoma\n",
      "1999, Football, Oregon State\n",
      "1999, Football, Oregon\n",
      "1999, Football, Penn State\n",
      "1999, Football, Pittsburgh\n",
      "1999, Football, Purdue\n",
      "1999, Football, Rice\n",
      "1999, Football, Rutgers\n",
      "1999, Football, San Diego State\n",
      "1999, Football, San Jose State\n",
      "1999, Football, South Carolina\n",
      "1999, Football, South Florida\n",
      "1999, Football, Southern California\n",
      "1999, Football, Southern Methodist\n",
      "1999, Football, Southern Mississippi\n",
      "1999, Football, Texas State\n",
      "1999, Football, Louisiana-Lafayette\n",
      "1999, Football, Stanford\n",
      "1999, Football, Syracuse\n",
      "1999, Football, Temple\n",
      "1999, Football, Tennessee\n",
      "1999, Football, Texas A&M\n",
      "1999, Football, Texas Christian\n",
      "1999, Football, Texas Tech\n",
      "1999, Football, Texas\n",
      "1999, Football, Texas-El Paso\n",
      "1999, Football, Toledo\n",
      "1999, Football, Troy\n",
      "1999, Football, Tulane\n",
      "1999, Football, Tulsa\n",
      "1999, Football, Air Force\n",
      "1999, Football, Army\n",
      "1999, Football, Navy\n",
      "1999, Football, Utah State\n",
      "1999, Football, Utah\n",
      "1999, Football, Vanderbilt\n",
      "1999, Football, Virginia Tech\n",
      "1999, Football, Virginia\n",
      "1999, Football, Wake Forest\n",
      "1999, Football, Washington State\n",
      "1999, Football, Washington\n",
      "1999, Football, West Virginia\n",
      "1999, Football, Western Kentucky\n",
      "1999, Football, Western Michigan\n",
      "1999, Football, Wisconsin\n",
      "1999, Football, Wyoming\n",
      "2000, Football, Akron\n",
      "2000, Football, Alabama\n",
      "2000, Football, Alabama at Birmingham\n",
      "2000, Football, Appalachian State\n",
      "2000, Football, Arizona State\n",
      "2000, Football, Arizona\n",
      "2000, Football, Arkansas State\n",
      "2000, Football, Arkansas\n",
      "2000, Football, Auburn\n",
      "2000, Football, Ball State\n",
      "2000, Football, Baylor\n",
      "2000, Football, Boise State\n",
      "2000, Football, Boston College\n",
      "2000, Football, Bowling Green\n",
      "2000, Football, Brigham Young\n",
      "2000, Football, Buffalo\n",
      "2000, Football, Fresno State\n",
      "2000, Football, California\n",
      "2000, Football, UCLA\n",
      "2000, Football, Central Florida\n",
      "2000, Football, Central Michigan\n",
      "2000, Football, Cincinnati\n",
      "2000, Football, Clemson\n",
      "2000, Football, Colorado State\n",
      "2000, Football, Colorado\n",
      "2000, Football, Connecticut\n",
      "2000, Football, Duke\n",
      "2000, Football, East Carolina\n",
      "2000, Football, Eastern Michigan\n",
      "2000, Football, Florida State\n",
      "2000, Football, Florida\n",
      "2000, Football, Georgia Southern\n",
      "2000, Football, Georgia Tech\n",
      "2000, Football, Georgia\n",
      "2000, Football, Hawaii\n",
      "2000, Football, Houston\n",
      "2000, Football, Illinois\n",
      "2000, Football, Indiana\n",
      "2000, Football, Iowa State\n",
      "2000, Football, Iowa\n",
      "2000, Football, Kansas State\n",
      "2000, Football, Kansas\n",
      "2000, Football, Kent State\n",
      "2000, Football, Kentucky\n",
      "2000, Football, Liberty\n",
      "2000, Football, LSU\n",
      "2000, Football, Louisiana Tech\n",
      "2000, Football, Louisville\n",
      "2000, Football, Marshall\n",
      "2000, Football, Maryland\n",
      "2000, Football, Massachusetts\n",
      "2000, Football, Memphis\n",
      "2000, Football, Miami (Ohio)\n",
      "2000, Football, Miami (Fla.)\n",
      "2000, Football, Michigan State\n",
      "2000, Football, Michigan\n",
      "2000, Football, Middle Tennessee\n",
      "2000, Football, Minnesota\n",
      "2000, Football, Mississippi State\n",
      "2000, Football, Mississippi\n",
      "2000, Football, Missouri\n",
      "2000, Football, North Carolina\n",
      "2000, Football, Nebraska\n",
      "2000, Football, Nevada-Las Vegas\n",
      "2000, Football, Nevada\n",
      "2000, Football, New Mexico State\n",
      "2000, Football, New Mexico\n",
      "2000, Football, North Carolina State\n",
      "2000, Football, North Texas\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2000, Football, Louisiana-Monroe\n",
      "2000, Football, Northern Illinois\n",
      "2000, Football, Northwestern\n",
      "2000, Football, Notre Dame\n",
      "2000, Football, Ohio State\n",
      "2000, Football, Ohio\n",
      "2000, Football, Oklahoma State\n",
      "2000, Football, Oklahoma\n",
      "2000, Football, Oregon State\n",
      "2000, Football, Oregon\n",
      "2000, Football, Penn State\n",
      "2000, Football, Pittsburgh\n",
      "2000, Football, Purdue\n",
      "2000, Football, Rice\n",
      "2000, Football, Rutgers\n",
      "2000, Football, San Diego State\n",
      "2000, Football, San Jose State\n",
      "2000, Football, South Carolina\n",
      "2000, Football, South Florida\n",
      "2000, Football, Southern California\n",
      "2000, Football, Southern Methodist\n",
      "2000, Football, Southern Mississippi\n",
      "2000, Football, Texas State\n",
      "2000, Football, Louisiana-Lafayette\n",
      "2000, Football, Stanford\n",
      "2000, Football, Syracuse\n",
      "2000, Football, Temple\n",
      "2000, Football, Tennessee\n",
      "2000, Football, Texas A&M\n",
      "2000, Football, Texas Christian\n",
      "2000, Football, Texas Tech\n",
      "2000, Football, Texas\n",
      "2000, Football, Texas-El Paso\n",
      "2000, Football, Toledo\n",
      "2000, Football, Troy\n",
      "2000, Football, Tulane\n",
      "2000, Football, Tulsa\n",
      "2000, Football, Air Force\n",
      "2000, Football, Army\n",
      "2000, Football, Navy\n",
      "2000, Football, Utah State\n",
      "2000, Football, Utah\n",
      "2000, Football, Vanderbilt\n",
      "2000, Football, Virginia Tech\n",
      "2000, Football, Virginia\n",
      "2000, Football, Wake Forest\n",
      "2000, Football, Washington State\n",
      "2000, Football, Washington\n",
      "2000, Football, West Virginia\n",
      "2000, Football, Western Kentucky\n",
      "2000, Football, Western Michigan\n",
      "2000, Football, Wisconsin\n",
      "2000, Football, Wyoming\n",
      "2001, Football, Akron\n",
      "2001, Football, Alabama\n",
      "2001, Football, Alabama at Birmingham\n",
      "2001, Football, Appalachian State\n",
      "2001, Football, Arizona State\n",
      "2001, Football, Arizona\n",
      "2001, Football, Arkansas State\n",
      "2001, Football, Arkansas\n",
      "2001, Football, Auburn\n",
      "2001, Football, Ball State\n",
      "2001, Football, Baylor\n",
      "2001, Football, Boise State\n",
      "2001, Football, Boston College\n",
      "2001, Football, Bowling Green\n",
      "2001, Football, Brigham Young\n",
      "2001, Football, Buffalo\n",
      "2001, Football, Fresno State\n",
      "2001, Football, California\n",
      "2001, Football, UCLA\n",
      "2001, Football, Central Florida\n",
      "2001, Football, Central Michigan\n",
      "2001, Football, Cincinnati\n",
      "2001, Football, Clemson\n",
      "2001, Football, Coastal Carolina\n",
      "2001, Football, Colorado State\n",
      "2001, Football, Colorado\n",
      "2001, Football, Connecticut\n",
      "2001, Football, Duke\n",
      "2001, Football, East Carolina\n",
      "2001, Football, Eastern Michigan\n",
      "2001, Football, Florida Atlantic\n",
      "2001, Football, Florida International\n",
      "2001, Football, Florida State\n",
      "2001, Football, Florida\n",
      "2001, Football, Georgia Southern\n",
      "2001, Football, Georgia Tech\n",
      "2001, Football, Georgia\n",
      "2001, Football, Hawaii\n",
      "2001, Football, Houston\n",
      "2001, Football, Illinois\n",
      "2001, Football, Indiana\n",
      "2001, Football, Iowa State\n",
      "2001, Football, Iowa\n",
      "2001, Football, Kansas State\n",
      "2001, Football, Kansas\n",
      "2001, Football, Kent State\n",
      "2001, Football, Kentucky\n",
      "2001, Football, Liberty\n",
      "2001, Football, LSU\n",
      "2001, Football, Louisiana Tech\n",
      "2001, Football, Louisville\n",
      "2001, Football, Marshall\n",
      "2001, Football, Maryland\n",
      "2001, Football, Massachusetts\n",
      "2001, Football, Memphis\n",
      "2001, Football, Miami (Ohio)\n",
      "2001, Football, Miami (Fla.)\n",
      "2001, Football, Michigan State\n",
      "2001, Football, Michigan\n",
      "2001, Football, Middle Tennessee\n",
      "2001, Football, Minnesota\n",
      "2001, Football, Mississippi State\n",
      "2001, Football, Mississippi\n",
      "2001, Football, Missouri\n",
      "2001, Football, North Carolina\n",
      "2001, Football, Nebraska\n",
      "2001, Football, Nevada-Las Vegas\n",
      "2001, Football, Nevada\n",
      "2001, Football, New Mexico State\n",
      "2001, Football, New Mexico\n",
      "2001, Football, North Carolina State\n",
      "2001, Football, North Texas\n",
      "2001, Football, Louisiana-Monroe\n",
      "2001, Football, Northern Illinois\n",
      "2001, Football, Northwestern\n",
      "2001, Football, Notre Dame\n",
      "2001, Football, Ohio State\n",
      "2001, Football, Ohio\n",
      "2001, Football, Oklahoma State\n",
      "2001, Football, Oklahoma\n",
      "2001, Football, Oregon State\n",
      "2001, Football, Oregon\n",
      "2001, Football, Penn State\n",
      "2001, Football, Pittsburgh\n",
      "2001, Football, Purdue\n",
      "2001, Football, Rice\n",
      "2001, Football, Rutgers\n",
      "2001, Football, San Diego State\n",
      "2001, Football, San Jose State\n",
      "2001, Football, South Carolina\n",
      "2001, Football, South Florida\n",
      "2001, Football, Southern California\n",
      "2001, Football, Southern Methodist\n",
      "2001, Football, Southern Mississippi\n",
      "2001, Football, Texas State\n",
      "2001, Football, Louisiana-Lafayette\n",
      "2001, Football, Stanford\n",
      "2001, Football, Syracuse\n",
      "2001, Football, Temple\n",
      "2001, Football, Tennessee\n",
      "2001, Football, Texas A&M\n",
      "2001, Football, Texas Christian\n",
      "2001, Football, Texas Tech\n",
      "2001, Football, Texas\n",
      "2001, Football, Texas-El Paso\n",
      "2001, Football, Toledo\n",
      "2001, Football, Troy\n",
      "2001, Football, Tulane\n",
      "2001, Football, Tulsa\n",
      "2001, Football, Air Force\n",
      "2001, Football, Army\n",
      "2001, Football, Navy\n",
      "2001, Football, Utah State\n",
      "2001, Football, Utah\n",
      "2001, Football, Vanderbilt\n",
      "2001, Football, Virginia Tech\n",
      "2001, Football, Virginia\n",
      "2001, Football, Wake Forest\n",
      "2001, Football, Washington State\n",
      "2001, Football, Washington\n",
      "2001, Football, West Virginia\n",
      "2001, Football, Western Kentucky\n",
      "2001, Football, Western Michigan\n",
      "2001, Football, Wisconsin\n",
      "2001, Football, Wyoming\n",
      "2002, Football, Akron\n",
      "2002, Football, Alabama\n",
      "2002, Football, Alabama at Birmingham\n",
      "2002, Football, Appalachian State\n",
      "2002, Football, Arizona State\n",
      "2002, Football, Arizona\n",
      "2002, Football, Arkansas State\n",
      "2002, Football, Arkansas\n",
      "2002, Football, Auburn\n",
      "2002, Football, Ball State\n",
      "2002, Football, Baylor\n",
      "2002, Football, Boise State\n",
      "2002, Football, Boston College\n",
      "2002, Football, Bowling Green\n",
      "2002, Football, Brigham Young\n",
      "2002, Football, Buffalo\n",
      "2002, Football, Fresno State\n",
      "2002, Football, California\n",
      "2002, Football, UCLA\n",
      "2002, Football, Central Florida\n",
      "2002, Football, Central Michigan\n",
      "2002, Football, Cincinnati\n",
      "2002, Football, Clemson\n",
      "2002, Football, Coastal Carolina\n",
      "2002, Football, Colorado State\n",
      "2002, Football, Colorado\n",
      "2002, Football, Connecticut\n",
      "2002, Football, Duke\n",
      "2002, Football, East Carolina\n",
      "2002, Football, Eastern Michigan\n",
      "2002, Football, Florida Atlantic\n",
      "2002, Football, Florida International\n",
      "2002, Football, Florida State\n",
      "2002, Football, Florida\n",
      "2002, Football, Georgia Southern\n",
      "2002, Football, Georgia Tech\n",
      "2002, Football, Georgia\n",
      "2002, Football, Hawaii\n",
      "2002, Football, Houston\n",
      "2002, Football, Illinois\n",
      "2002, Football, Indiana\n",
      "2002, Football, Iowa State\n",
      "2002, Football, Iowa\n",
      "2002, Football, Kansas State\n",
      "2002, Football, Kansas\n",
      "2002, Football, Kent State\n",
      "2002, Football, Kentucky\n",
      "2002, Football, Liberty\n",
      "2002, Football, LSU\n",
      "2002, Football, Louisiana Tech\n",
      "2002, Football, Louisville\n",
      "2002, Football, Marshall\n",
      "2002, Football, Maryland\n",
      "2002, Football, Massachusetts\n",
      "2002, Football, Memphis\n",
      "2002, Football, Miami (Ohio)\n",
      "2002, Football, Miami (Fla.)\n",
      "2002, Football, Michigan State\n",
      "2002, Football, Michigan\n",
      "2002, Football, Middle Tennessee\n",
      "2002, Football, Minnesota\n",
      "2002, Football, Mississippi State\n",
      "2002, Football, Mississippi\n",
      "2002, Football, Missouri\n",
      "2002, Football, North Carolina\n",
      "2002, Football, Nebraska\n",
      "2002, Football, Nevada-Las Vegas\n",
      "2002, Football, Nevada\n",
      "2002, Football, New Mexico State\n",
      "2002, Football, New Mexico\n",
      "2002, Football, North Carolina State\n",
      "2002, Football, North Texas\n",
      "2002, Football, Louisiana-Monroe\n",
      "2002, Football, Northern Illinois\n",
      "2002, Football, Northwestern\n",
      "2002, Football, Notre Dame\n",
      "2002, Football, Ohio State\n",
      "2002, Football, Ohio\n",
      "2002, Football, Oklahoma State\n",
      "2002, Football, Oklahoma\n",
      "2002, Football, Oregon State\n",
      "2002, Football, Oregon\n",
      "2002, Football, Penn State\n",
      "2002, Football, Pittsburgh\n",
      "2002, Football, Purdue\n",
      "2002, Football, Rice\n",
      "2002, Football, Rutgers\n",
      "2002, Football, San Diego State\n",
      "2002, Football, San Jose State\n",
      "2002, Football, South Carolina\n",
      "2002, Football, South Florida\n",
      "2002, Football, Southern California\n",
      "2002, Football, Southern Methodist\n",
      "2002, Football, Southern Mississippi\n",
      "2002, Football, Texas State\n",
      "2002, Football, Louisiana-Lafayette\n",
      "2002, Football, Stanford\n",
      "2002, Football, Syracuse\n",
      "2002, Football, Temple\n",
      "2002, Football, Tennessee\n",
      "2002, Football, Texas A&M\n",
      "2002, Football, Texas Christian\n",
      "2002, Football, Texas Tech\n",
      "2002, Football, Texas\n",
      "2002, Football, Texas-El Paso\n",
      "2002, Football, Toledo\n",
      "2002, Football, Troy\n",
      "2002, Football, Tulane\n",
      "2002, Football, Tulsa\n",
      "2002, Football, Air Force\n",
      "2002, Football, Army\n",
      "2002, Football, Navy\n",
      "2002, Football, Utah State\n",
      "2002, Football, Utah\n",
      "2002, Football, Vanderbilt\n",
      "2002, Football, Virginia Tech\n",
      "2002, Football, Virginia\n",
      "2002, Football, Wake Forest\n",
      "2002, Football, Washington State\n",
      "2002, Football, Washington\n",
      "2002, Football, West Virginia\n",
      "2002, Football, Western Kentucky\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2002, Football, Western Michigan\n",
      "2002, Football, Wisconsin\n",
      "2002, Football, Wyoming\n",
      "2003, Football, Akron\n",
      "2003, Football, Alabama\n",
      "2003, Football, Alabama at Birmingham\n",
      "2003, Football, Appalachian State\n",
      "2003, Football, Arizona State\n",
      "2003, Football, Arizona\n",
      "2003, Football, Arkansas State\n",
      "2003, Football, Arkansas\n",
      "2003, Football, Auburn\n",
      "2003, Football, Ball State\n",
      "2003, Football, Baylor\n",
      "2003, Football, Boise State\n",
      "2003, Football, Boston College\n",
      "2003, Football, Bowling Green\n",
      "2003, Football, Brigham Young\n",
      "2003, Football, Buffalo\n",
      "2003, Football, Fresno State\n",
      "2003, Football, California\n",
      "2003, Football, UCLA\n",
      "2003, Football, Central Florida\n",
      "2003, Football, Central Michigan\n",
      "2003, Football, Cincinnati\n",
      "2003, Football, Clemson\n",
      "2003, Football, Coastal Carolina\n",
      "2003, Football, Colorado State\n",
      "2003, Football, Colorado\n",
      "2003, Football, Connecticut\n",
      "2003, Football, Duke\n",
      "2003, Football, East Carolina\n",
      "2003, Football, Eastern Michigan\n",
      "2003, Football, Florida Atlantic\n",
      "2003, Football, Florida International\n",
      "2003, Football, Florida State\n",
      "2003, Football, Florida\n",
      "2003, Football, Georgia Southern\n",
      "2003, Football, Georgia Tech\n",
      "2003, Football, Georgia\n",
      "2003, Football, Hawaii\n",
      "2003, Football, Houston\n",
      "2003, Football, Illinois\n",
      "2003, Football, Indiana\n",
      "2003, Football, Iowa State\n",
      "2003, Football, Iowa\n",
      "2003, Football, Kansas State\n",
      "2003, Football, Kansas\n",
      "2003, Football, Kent State\n",
      "2003, Football, Kentucky\n",
      "2003, Football, Liberty\n",
      "2003, Football, LSU\n",
      "2003, Football, Louisiana Tech\n",
      "2003, Football, Louisville\n",
      "2003, Football, Marshall\n",
      "2003, Football, Maryland\n",
      "2003, Football, Massachusetts\n",
      "2003, Football, Memphis\n",
      "2003, Football, Miami (Ohio)\n",
      "2003, Football, Miami (Fla.)\n",
      "2003, Football, Michigan State\n",
      "2003, Football, Michigan\n",
      "2003, Football, Middle Tennessee\n",
      "2003, Football, Minnesota\n",
      "2003, Football, Mississippi State\n",
      "2003, Football, Mississippi\n",
      "2003, Football, Missouri\n",
      "2003, Football, North Carolina\n",
      "2003, Football, Nebraska\n",
      "2003, Football, Nevada-Las Vegas\n",
      "2003, Football, Nevada\n",
      "2003, Football, New Mexico State\n",
      "2003, Football, New Mexico\n",
      "2003, Football, North Carolina State\n",
      "2003, Football, North Texas\n",
      "2003, Football, Louisiana-Monroe\n",
      "2003, Football, Northern Illinois\n",
      "2003, Football, Northwestern\n",
      "2003, Football, Notre Dame\n",
      "2003, Football, Ohio State\n",
      "2003, Football, Ohio\n",
      "2003, Football, Oklahoma State\n",
      "2003, Football, Oklahoma\n",
      "2003, Football, Oregon State\n",
      "2003, Football, Oregon\n",
      "2003, Football, Penn State\n",
      "2003, Football, Pittsburgh\n",
      "2003, Football, Purdue\n",
      "2003, Football, Rice\n",
      "2003, Football, Rutgers\n",
      "2003, Football, San Diego State\n",
      "2003, Football, San Jose State\n",
      "2003, Football, South Carolina\n",
      "2003, Football, South Florida\n",
      "2003, Football, Southern California\n",
      "2003, Football, Southern Methodist\n",
      "2003, Football, Southern Mississippi\n",
      "2003, Football, Texas State\n",
      "2003, Football, Louisiana-Lafayette\n",
      "2003, Football, Stanford\n",
      "2003, Football, Syracuse\n",
      "2003, Football, Temple\n",
      "2003, Football, Tennessee\n",
      "2003, Football, Texas A&M\n",
      "2003, Football, Texas Christian\n",
      "2003, Football, Texas Tech\n",
      "2003, Football, Texas\n",
      "2003, Football, Texas-El Paso\n",
      "2003, Football, Toledo\n",
      "2003, Football, Troy\n",
      "2003, Football, Tulane\n",
      "2003, Football, Tulsa\n",
      "2003, Football, Air Force\n",
      "2003, Football, Army\n",
      "2003, Football, Navy\n",
      "2003, Football, Utah State\n",
      "2003, Football, Utah\n",
      "2003, Football, Vanderbilt\n",
      "2003, Football, Virginia Tech\n",
      "2003, Football, Virginia\n",
      "2003, Football, Wake Forest\n",
      "2003, Football, Washington State\n",
      "2003, Football, Washington\n",
      "2003, Football, West Virginia\n",
      "2003, Football, Western Kentucky\n",
      "2003, Football, Western Michigan\n",
      "2003, Football, Wisconsin\n",
      "2003, Football, Wyoming\n",
      "2004, Football, Akron\n",
      "2004, Football, Alabama\n",
      "2004, Football, Alabama at Birmingham\n",
      "2004, Football, Appalachian State\n",
      "2004, Football, Arizona State\n",
      "2004, Football, Arizona\n",
      "2004, Football, Arkansas State\n",
      "2004, Football, Arkansas\n",
      "2004, Football, Auburn\n",
      "2004, Football, Ball State\n",
      "2004, Football, Baylor\n",
      "2004, Football, Boise State\n",
      "2004, Football, Boston College\n",
      "2004, Football, Bowling Green\n",
      "2004, Football, Brigham Young\n",
      "2004, Football, Buffalo\n",
      "2004, Football, Fresno State\n",
      "2004, Football, California\n",
      "2004, Football, UCLA\n",
      "2004, Football, Central Florida\n",
      "2004, Football, Central Michigan\n",
      "2004, Football, Cincinnati\n",
      "2004, Football, Clemson\n",
      "2004, Football, Coastal Carolina\n",
      "2004, Football, Colorado State\n",
      "2004, Football, Colorado\n",
      "2004, Football, Connecticut\n",
      "2004, Football, Duke\n",
      "2004, Football, East Carolina\n",
      "2004, Football, Eastern Michigan\n",
      "2004, Football, Florida Atlantic\n",
      "2004, Football, Florida International\n",
      "2004, Football, Florida State\n",
      "2004, Football, Florida\n",
      "2004, Football, Georgia Southern\n",
      "2004, Football, Georgia Tech\n",
      "2004, Football, Georgia\n",
      "2004, Football, Hawaii\n",
      "2004, Football, Houston\n",
      "2004, Football, Illinois\n",
      "2004, Football, Indiana\n",
      "2004, Football, Iowa State\n",
      "2004, Football, Iowa\n",
      "2004, Football, Kansas State\n",
      "2004, Football, Kansas\n",
      "2004, Football, Kent State\n",
      "2004, Football, Kentucky\n",
      "2004, Football, Liberty\n",
      "2004, Football, LSU\n",
      "2004, Football, Louisiana Tech\n",
      "2004, Football, Louisville\n",
      "2004, Football, Marshall\n",
      "2004, Football, Maryland\n",
      "2004, Football, Massachusetts\n",
      "2004, Football, Memphis\n",
      "2004, Football, Miami (Ohio)\n",
      "2004, Football, Miami (Fla.)\n",
      "2004, Football, Michigan State\n",
      "2004, Football, Michigan\n",
      "2004, Football, Middle Tennessee\n",
      "2004, Football, Minnesota\n",
      "2004, Football, Mississippi State\n",
      "2004, Football, Mississippi\n",
      "2004, Football, Missouri\n",
      "2004, Football, North Carolina\n",
      "2004, Football, Nebraska\n",
      "2004, Football, Nevada-Las Vegas\n",
      "2004, Football, Nevada\n",
      "2004, Football, New Mexico State\n",
      "2004, Football, New Mexico\n",
      "2004, Football, North Carolina State\n",
      "2004, Football, North Texas\n",
      "2004, Football, Louisiana-Monroe\n",
      "2004, Football, Northern Illinois\n",
      "2004, Football, Northwestern\n",
      "2004, Football, Notre Dame\n",
      "2004, Football, Ohio State\n",
      "2004, Football, Ohio\n",
      "2004, Football, Oklahoma State\n",
      "2004, Football, Oklahoma\n",
      "2004, Football, Oregon State\n",
      "2004, Football, Oregon\n",
      "2004, Football, Penn State\n",
      "2004, Football, Pittsburgh\n",
      "2004, Football, Purdue\n",
      "2004, Football, Rice\n",
      "2004, Football, Rutgers\n",
      "2004, Football, San Diego State\n",
      "2004, Football, San Jose State\n",
      "2004, Football, South Carolina\n",
      "2004, Football, South Florida\n",
      "2004, Football, Southern California\n",
      "2004, Football, Southern Methodist\n",
      "2004, Football, Southern Mississippi\n",
      "2004, Football, Texas State\n",
      "2004, Football, Louisiana-Lafayette\n",
      "2004, Football, Stanford\n",
      "2004, Football, Syracuse\n",
      "2004, Football, Temple\n",
      "2004, Football, Tennessee\n",
      "2004, Football, Texas A&M\n",
      "2004, Football, Texas Christian\n",
      "2004, Football, Texas Tech\n",
      "2004, Football, Texas\n",
      "2004, Football, Texas-El Paso\n",
      "2004, Football, Toledo\n",
      "2004, Football, Troy\n",
      "2004, Football, Tulane\n",
      "2004, Football, Tulsa\n",
      "2004, Football, Air Force\n",
      "2004, Football, Army\n",
      "2004, Football, Navy\n",
      "2004, Football, Utah State\n",
      "2004, Football, Utah\n",
      "2004, Football, Vanderbilt\n",
      "2004, Football, Virginia Tech\n",
      "2004, Football, Virginia\n",
      "2004, Football, Wake Forest\n",
      "2004, Football, Washington State\n",
      "2004, Football, Washington\n",
      "2004, Football, West Virginia\n",
      "2004, Football, Western Kentucky\n",
      "2004, Football, Western Michigan\n",
      "2004, Football, Wisconsin\n",
      "2004, Football, Wyoming\n",
      "2005, Football, Akron\n",
      "2005, Football, Alabama\n",
      "2005, Football, Alabama at Birmingham\n",
      "2005, Football, Appalachian State\n",
      "2005, Football, Arizona State\n",
      "2005, Football, Arizona\n",
      "2005, Football, Arkansas State\n",
      "2005, Football, Arkansas\n",
      "2005, Football, Auburn\n",
      "2005, Football, Ball State\n",
      "2005, Football, Baylor\n",
      "2005, Football, Boise State\n",
      "2005, Football, Boston College\n",
      "2005, Football, Bowling Green\n",
      "2005, Football, Brigham Young\n",
      "2005, Football, Buffalo\n",
      "2005, Football, Fresno State\n",
      "2005, Football, California\n",
      "2005, Football, UCLA\n",
      "2005, Football, Central Florida\n",
      "2005, Football, Central Michigan\n",
      "2005, Football, Cincinnati\n",
      "2005, Football, Clemson\n",
      "2005, Football, Coastal Carolina\n",
      "2005, Football, Colorado State\n",
      "2005, Football, Colorado\n",
      "2005, Football, Connecticut\n",
      "2005, Football, Duke\n",
      "2005, Football, East Carolina\n",
      "2005, Football, Eastern Michigan\n",
      "2005, Football, Florida Atlantic\n",
      "2005, Football, Florida International\n",
      "2005, Football, Florida State\n",
      "2005, Football, Florida\n",
      "2005, Football, Georgia Southern\n",
      "2005, Football, Georgia Tech\n",
      "2005, Football, Georgia\n",
      "2005, Football, Hawaii\n",
      "2005, Football, Houston\n",
      "2005, Football, Illinois\n",
      "2005, Football, Indiana\n",
      "2005, Football, Iowa State\n",
      "2005, Football, Iowa\n",
      "2005, Football, Kansas State\n",
      "2005, Football, Kansas\n",
      "2005, Football, Kent State\n",
      "2005, Football, Kentucky\n",
      "2005, Football, Liberty\n",
      "2005, Football, LSU\n",
      "2005, Football, Louisiana Tech\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2005, Football, Louisville\n",
      "2005, Football, Marshall\n",
      "2005, Football, Maryland\n",
      "2005, Football, Massachusetts\n",
      "2005, Football, Memphis\n",
      "2005, Football, Miami (Ohio)\n",
      "2005, Football, Miami (Fla.)\n",
      "2005, Football, Michigan State\n",
      "2005, Football, Michigan\n",
      "2005, Football, Middle Tennessee\n",
      "2005, Football, Minnesota\n",
      "2005, Football, Mississippi State\n",
      "2005, Football, Mississippi\n",
      "2005, Football, Missouri\n",
      "2005, Football, North Carolina\n",
      "2005, Football, Nebraska\n",
      "2005, Football, Nevada-Las Vegas\n",
      "2005, Football, Nevada\n",
      "2005, Football, New Mexico State\n",
      "2005, Football, New Mexico\n",
      "2005, Football, North Carolina State\n",
      "2005, Football, North Texas\n",
      "2005, Football, Louisiana-Monroe\n",
      "2005, Football, Northern Illinois\n",
      "2005, Football, Northwestern\n",
      "2005, Football, Notre Dame\n",
      "2005, Football, Ohio State\n",
      "2005, Football, Ohio\n",
      "2005, Football, Oklahoma State\n",
      "2005, Football, Oklahoma\n",
      "2005, Football, Oregon State\n",
      "2005, Football, Oregon\n",
      "2005, Football, Penn State\n",
      "2005, Football, Pittsburgh\n",
      "2005, Football, Purdue\n",
      "2005, Football, Rice\n",
      "2005, Football, Rutgers\n",
      "2005, Football, San Diego State\n",
      "2005, Football, San Jose State\n",
      "2005, Football, South Carolina\n",
      "2005, Football, South Florida\n",
      "2005, Football, Southern California\n",
      "2005, Football, Southern Methodist\n",
      "2005, Football, Southern Mississippi\n",
      "2005, Football, Texas State\n",
      "2005, Football, Louisiana-Lafayette\n",
      "2005, Football, Stanford\n",
      "2005, Football, Syracuse\n",
      "2005, Football, Temple\n",
      "2005, Football, Tennessee\n",
      "2005, Football, Texas A&M\n",
      "2005, Football, Texas Christian\n",
      "2005, Football, Texas Tech\n",
      "2005, Football, Texas\n",
      "2005, Football, Texas-El Paso\n",
      "2005, Football, Toledo\n",
      "2005, Football, Troy\n",
      "2005, Football, Tulane\n",
      "2005, Football, Tulsa\n",
      "2005, Football, Air Force\n",
      "2005, Football, Army\n",
      "2005, Football, Navy\n",
      "2005, Football, Utah State\n",
      "2005, Football, Utah\n",
      "2005, Football, Vanderbilt\n",
      "2005, Football, Virginia Tech\n",
      "2005, Football, Virginia\n",
      "2005, Football, Wake Forest\n",
      "2005, Football, Washington State\n",
      "2005, Football, Washington\n",
      "2005, Football, West Virginia\n",
      "2005, Football, Western Kentucky\n",
      "2005, Football, Western Michigan\n",
      "2005, Football, Wisconsin\n",
      "2005, Football, Wyoming\n",
      "2006, Football, Akron\n",
      "2006, Football, Alabama\n",
      "2006, Football, Alabama at Birmingham\n",
      "2006, Football, Appalachian State\n",
      "2006, Football, Arizona State\n",
      "2006, Football, Arizona\n",
      "2006, Football, Arkansas State\n",
      "2006, Football, Arkansas\n",
      "2006, Football, Auburn\n",
      "2006, Football, Ball State\n",
      "2006, Football, Baylor\n",
      "2006, Football, Boise State\n",
      "2006, Football, Boston College\n",
      "2006, Football, Bowling Green\n",
      "2006, Football, Brigham Young\n",
      "2006, Football, Buffalo\n",
      "2006, Football, Fresno State\n",
      "2006, Football, California\n",
      "2006, Football, UCLA\n",
      "2006, Football, Central Florida\n",
      "2006, Football, Central Michigan\n",
      "2006, Football, Cincinnati\n",
      "2006, Football, Clemson\n",
      "2006, Football, Coastal Carolina\n",
      "2006, Football, Colorado State\n",
      "2006, Football, Colorado\n",
      "2006, Football, Connecticut\n",
      "2006, Football, Duke\n",
      "2006, Football, East Carolina\n",
      "2006, Football, Eastern Michigan\n",
      "2006, Football, Florida Atlantic\n",
      "2006, Football, Florida International\n",
      "2006, Football, Florida State\n",
      "2006, Football, Florida\n",
      "2006, Football, Georgia Southern\n",
      "2006, Football, Georgia Tech\n",
      "2006, Football, Georgia\n",
      "2006, Football, Hawaii\n",
      "2006, Football, Houston\n",
      "2006, Football, Illinois\n",
      "2006, Football, Indiana\n",
      "2006, Football, Iowa State\n",
      "2006, Football, Iowa\n",
      "2006, Football, Kansas State\n",
      "2006, Football, Kansas\n",
      "2006, Football, Kent State\n",
      "2006, Football, Kentucky\n",
      "2006, Football, Liberty\n",
      "2006, Football, LSU\n",
      "2006, Football, Louisiana Tech\n",
      "2006, Football, Louisville\n",
      "2006, Football, Marshall\n",
      "2006, Football, Maryland\n",
      "2006, Football, Massachusetts\n",
      "2006, Football, Memphis\n",
      "2006, Football, Miami (Ohio)\n",
      "2006, Football, Miami (Fla.)\n",
      "2006, Football, Michigan State\n",
      "2006, Football, Michigan\n",
      "2006, Football, Middle Tennessee\n",
      "2006, Football, Minnesota\n",
      "2006, Football, Mississippi State\n",
      "2006, Football, Mississippi\n",
      "2006, Football, Missouri\n",
      "2006, Football, North Carolina\n",
      "2006, Football, Nebraska\n",
      "2006, Football, Nevada-Las Vegas\n",
      "2006, Football, Nevada\n",
      "2006, Football, New Mexico State\n",
      "2006, Football, New Mexico\n",
      "2006, Football, North Carolina State\n",
      "2006, Football, North Texas\n",
      "2006, Football, Louisiana-Monroe\n",
      "2006, Football, Northern Illinois\n",
      "2006, Football, Northwestern\n",
      "2006, Football, Notre Dame\n",
      "2006, Football, Ohio State\n",
      "2006, Football, Ohio\n",
      "2006, Football, Oklahoma State\n",
      "2006, Football, Oklahoma\n",
      "2006, Football, Old Dominion\n",
      "2006, Football, Oregon State\n",
      "2006, Football, Oregon\n",
      "2006, Football, Penn State\n",
      "2006, Football, Pittsburgh\n",
      "2006, Football, Purdue\n",
      "2006, Football, Rice\n",
      "2006, Football, Rutgers\n",
      "2006, Football, San Diego State\n",
      "2006, Football, San Jose State\n",
      "2006, Football, South Carolina\n",
      "2006, Football, South Florida\n",
      "2006, Football, Southern California\n",
      "2006, Football, Southern Methodist\n",
      "2006, Football, Southern Mississippi\n",
      "2006, Football, Texas State\n",
      "2006, Football, Louisiana-Lafayette\n",
      "2006, Football, Stanford\n",
      "2006, Football, Syracuse\n",
      "2006, Football, Temple\n",
      "2006, Football, Tennessee\n",
      "2006, Football, Texas A&M\n",
      "2006, Football, Texas Christian\n",
      "2006, Football, Texas Tech\n",
      "2006, Football, Texas\n",
      "2006, Football, Texas-El Paso\n",
      "2006, Football, Toledo\n",
      "2006, Football, Troy\n",
      "2006, Football, Tulane\n",
      "2006, Football, Tulsa\n",
      "2006, Football, Air Force\n",
      "2006, Football, Army\n",
      "2006, Football, Navy\n",
      "2006, Football, Utah State\n",
      "2006, Football, Utah\n",
      "2006, Football, Vanderbilt\n",
      "2006, Football, Virginia Tech\n",
      "2006, Football, Virginia\n",
      "2006, Football, Wake Forest\n",
      "2006, Football, Washington State\n",
      "2006, Football, Washington\n",
      "2006, Football, West Virginia\n",
      "2006, Football, Western Kentucky\n",
      "2006, Football, Western Michigan\n",
      "2006, Football, Wisconsin\n",
      "2006, Football, Wyoming\n",
      "2007, Football, Akron\n",
      "2007, Football, Alabama\n",
      "2007, Football, Alabama at Birmingham\n",
      "2007, Football, Appalachian State\n",
      "2007, Football, Arizona State\n",
      "2007, Football, Arizona\n",
      "2007, Football, Arkansas State\n",
      "2007, Football, Arkansas\n",
      "2007, Football, Auburn\n",
      "2007, Football, Ball State\n",
      "2007, Football, Baylor\n",
      "2007, Football, Boise State\n",
      "2007, Football, Boston College\n",
      "2007, Football, Bowling Green\n",
      "2007, Football, Brigham Young\n",
      "2007, Football, Buffalo\n",
      "2007, Football, Fresno State\n",
      "2007, Football, California\n",
      "2007, Football, UCLA\n",
      "2007, Football, Central Florida\n",
      "2007, Football, Central Michigan\n",
      "2007, Football, Cincinnati\n",
      "2007, Football, Clemson\n",
      "2007, Football, Coastal Carolina\n",
      "2007, Football, Colorado State\n",
      "2007, Football, Colorado\n",
      "2007, Football, Connecticut\n",
      "2007, Football, Duke\n",
      "2007, Football, East Carolina\n",
      "2007, Football, Eastern Michigan\n",
      "2007, Football, Florida Atlantic\n",
      "2007, Football, Florida International\n",
      "2007, Football, Florida State\n",
      "2007, Football, Florida\n",
      "2007, Football, Georgia Southern\n",
      "2007, Football, Georgia Tech\n",
      "2007, Football, Georgia\n",
      "2007, Football, Hawaii\n",
      "2007, Football, Houston\n",
      "2007, Football, Illinois\n",
      "2007, Football, Indiana\n",
      "2007, Football, Iowa State\n",
      "2007, Football, Iowa\n",
      "2007, Football, Kansas State\n",
      "2007, Football, Kansas\n",
      "2007, Football, Kent State\n",
      "2007, Football, Kentucky\n",
      "2007, Football, Liberty\n",
      "2007, Football, LSU\n",
      "2007, Football, Louisiana Tech\n",
      "2007, Football, Louisville\n",
      "2007, Football, Marshall\n",
      "2007, Football, Maryland\n",
      "2007, Football, Massachusetts\n",
      "2007, Football, Memphis\n",
      "2007, Football, Miami (Ohio)\n",
      "2007, Football, Miami (Fla.)\n",
      "2007, Football, Michigan State\n",
      "2007, Football, Michigan\n",
      "2007, Football, Middle Tennessee\n",
      "2007, Football, Minnesota\n",
      "2007, Football, Mississippi State\n",
      "2007, Football, Mississippi\n",
      "2007, Football, Missouri\n",
      "2007, Football, North Carolina\n",
      "2007, Football, Nebraska\n",
      "2007, Football, Nevada-Las Vegas\n",
      "2007, Football, Nevada\n",
      "2007, Football, New Mexico State\n",
      "2007, Football, New Mexico\n",
      "2007, Football, North Carolina State\n",
      "2007, Football, North Texas\n",
      "2007, Football, Louisiana-Monroe\n",
      "2007, Football, Northern Illinois\n",
      "2007, Football, Northwestern\n",
      "2007, Football, Notre Dame\n",
      "2007, Football, Ohio State\n",
      "2007, Football, Ohio\n",
      "2007, Football, Oklahoma State\n",
      "2007, Football, Oklahoma\n",
      "2007, Football, Old Dominion\n",
      "2007, Football, Oregon State\n",
      "2007, Football, Oregon\n",
      "2007, Football, Penn State\n",
      "2007, Football, Pittsburgh\n",
      "2007, Football, Purdue\n",
      "2007, Football, Rice\n",
      "2007, Football, Rutgers\n",
      "2007, Football, San Diego State\n",
      "2007, Football, San Jose State\n",
      "2007, Football, South Carolina\n",
      "2007, Football, South Florida\n",
      "2007, Football, Southern California\n",
      "2007, Football, Southern Methodist\n",
      "2007, Football, Southern Mississippi\n",
      "2007, Football, Texas State\n",
      "2007, Football, Louisiana-Lafayette\n",
      "2007, Football, Stanford\n",
      "2007, Football, Syracuse\n",
      "2007, Football, Temple\n",
      "2007, Football, Tennessee\n",
      "2007, Football, Texas A&M\n",
      "2007, Football, Texas Christian\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2007, Football, Texas Tech\n",
      "2007, Football, Texas\n",
      "2007, Football, Texas-El Paso\n",
      "2007, Football, Texas-San Antonio\n",
      "2007, Football, Toledo\n",
      "2007, Football, Troy\n",
      "2007, Football, Tulane\n",
      "2007, Football, Tulsa\n",
      "2007, Football, Air Force\n",
      "2007, Football, Army\n",
      "2007, Football, Navy\n",
      "2007, Football, Utah State\n",
      "2007, Football, Utah\n",
      "2007, Football, Vanderbilt\n",
      "2007, Football, Virginia Tech\n",
      "2007, Football, Virginia\n",
      "2007, Football, Wake Forest\n",
      "2007, Football, Washington State\n",
      "2007, Football, Washington\n",
      "2007, Football, West Virginia\n",
      "2007, Football, Western Kentucky\n",
      "2007, Football, Western Michigan\n",
      "2007, Football, Wisconsin\n",
      "2007, Football, Wyoming\n",
      "2008, Football, Akron\n",
      "2008, Football, Alabama\n",
      "2008, Football, Alabama at Birmingham\n",
      "2008, Football, Appalachian State\n",
      "2008, Football, Arizona State\n",
      "2008, Football, Arizona\n",
      "2008, Football, Arkansas State\n",
      "2008, Football, Arkansas\n",
      "2008, Football, Auburn\n",
      "2008, Football, Ball State\n",
      "2008, Football, Baylor\n",
      "2008, Football, Boise State\n",
      "2008, Football, Boston College\n",
      "2008, Football, Bowling Green\n",
      "2008, Football, Brigham Young\n",
      "2008, Football, Buffalo\n",
      "2008, Football, Fresno State\n",
      "2008, Football, California\n",
      "2008, Football, UCLA\n",
      "2008, Football, Central Florida\n",
      "2008, Football, Central Michigan\n",
      "2008, Football, Cincinnati\n",
      "2008, Football, Clemson\n",
      "2008, Football, Coastal Carolina\n",
      "2008, Football, Colorado State\n",
      "2008, Football, Colorado\n",
      "2008, Football, Connecticut\n",
      "2008, Football, Duke\n",
      "2008, Football, East Carolina\n",
      "2008, Football, Eastern Michigan\n",
      "2008, Football, Florida Atlantic\n",
      "2008, Football, Florida International\n",
      "2008, Football, Florida State\n",
      "2008, Football, Florida\n",
      "2008, Football, Georgia Southern\n",
      "2008, Football, Georgia State\n",
      "2008, Football, Georgia Tech\n",
      "2008, Football, Georgia\n",
      "2008, Football, Hawaii\n",
      "2008, Football, Houston\n",
      "2008, Football, Illinois\n",
      "2008, Football, Indiana\n",
      "2008, Football, Iowa State\n",
      "2008, Football, Iowa\n",
      "2008, Football, Kansas State\n",
      "2008, Football, Kansas\n",
      "2008, Football, Kent State\n",
      "2008, Football, Kentucky\n",
      "2008, Football, Liberty\n",
      "2008, Football, LSU\n",
      "2008, Football, Louisiana Tech\n",
      "2008, Football, Louisville\n",
      "2008, Football, Marshall\n",
      "2008, Football, Maryland\n",
      "2008, Football, Massachusetts\n",
      "2008, Football, Memphis\n",
      "2008, Football, Miami (Ohio)\n",
      "2008, Football, Miami (Fla.)\n",
      "2008, Football, Michigan State\n",
      "2008, Football, Michigan\n",
      "2008, Football, Middle Tennessee\n",
      "2008, Football, Minnesota\n",
      "2008, Football, Mississippi State\n",
      "2008, Football, Mississippi\n",
      "2008, Football, Missouri\n",
      "2008, Football, North Carolina\n",
      "2008, Football, Nebraska\n",
      "2008, Football, Nevada-Las Vegas\n",
      "2008, Football, Nevada\n",
      "2008, Football, New Mexico State\n",
      "2008, Football, New Mexico\n",
      "2008, Football, North Carolina State\n",
      "2008, Football, North Texas\n",
      "2008, Football, Louisiana-Monroe\n",
      "2008, Football, Northern Illinois\n",
      "2008, Football, Northwestern\n",
      "2008, Football, Notre Dame\n",
      "2008, Football, Ohio State\n",
      "2008, Football, Ohio\n",
      "2008, Football, Oklahoma State\n",
      "2008, Football, Oklahoma\n",
      "2008, Football, Old Dominion\n",
      "2008, Football, Oregon State\n",
      "2008, Football, Oregon\n",
      "2008, Football, Penn State\n",
      "2008, Football, Pittsburgh\n",
      "2008, Football, Purdue\n",
      "2008, Football, Rice\n",
      "2008, Football, Rutgers\n",
      "2008, Football, San Diego State\n",
      "2008, Football, San Jose State\n",
      "2008, Football, South Alabama\n",
      "2008, Football, South Carolina\n",
      "2008, Football, South Florida\n",
      "2008, Football, Southern California\n",
      "2008, Football, Southern Methodist\n",
      "2008, Football, Southern Mississippi\n",
      "2008, Football, Texas State\n",
      "2008, Football, Louisiana-Lafayette\n",
      "2008, Football, Stanford\n",
      "2008, Football, Syracuse\n",
      "2008, Football, Temple\n",
      "2008, Football, Tennessee\n",
      "2008, Football, Texas A&M\n",
      "2008, Football, Texas Christian\n",
      "2008, Football, Texas Tech\n",
      "2008, Football, Texas\n",
      "2008, Football, Texas-El Paso\n",
      "2008, Football, Texas-San Antonio\n",
      "2008, Football, Toledo\n",
      "2008, Football, Troy\n",
      "2008, Football, Tulane\n",
      "2008, Football, Tulsa\n",
      "2008, Football, Air Force\n",
      "2008, Football, Army\n",
      "2008, Football, Navy\n",
      "2008, Football, Utah State\n",
      "2008, Football, Utah\n",
      "2008, Football, Vanderbilt\n",
      "2008, Football, Virginia Tech\n",
      "2008, Football, Virginia\n",
      "2008, Football, Wake Forest\n",
      "2008, Football, Washington State\n",
      "2008, Football, Washington\n",
      "2008, Football, West Virginia\n",
      "2008, Football, Western Kentucky\n",
      "2008, Football, Western Michigan\n",
      "2008, Football, Wisconsin\n",
      "2008, Football, Wyoming\n",
      "2009, Football, Akron\n",
      "2009, Football, Alabama\n",
      "2009, Football, Alabama at Birmingham\n",
      "2009, Football, Appalachian State\n",
      "2009, Football, Arizona State\n",
      "2009, Football, Arizona\n",
      "2009, Football, Arkansas State\n",
      "2009, Football, Arkansas\n",
      "2009, Football, Auburn\n",
      "2009, Football, Ball State\n",
      "2009, Football, Baylor\n",
      "2009, Football, Boise State\n",
      "2009, Football, Boston College\n",
      "2009, Football, Bowling Green\n",
      "2009, Football, Brigham Young\n",
      "2009, Football, Buffalo\n",
      "2009, Football, Fresno State\n",
      "2009, Football, California\n",
      "2009, Football, UCLA\n",
      "2009, Football, Central Florida\n",
      "2009, Football, Central Michigan\n",
      "2009, Football, Cincinnati\n",
      "2009, Football, Clemson\n",
      "2009, Football, Coastal Carolina\n",
      "2009, Football, Colorado State\n",
      "2009, Football, Colorado\n",
      "2009, Football, Connecticut\n",
      "2009, Football, Duke\n",
      "2009, Football, East Carolina\n",
      "2009, Football, Eastern Michigan\n",
      "2009, Football, Florida Atlantic\n",
      "2009, Football, Florida International\n",
      "2009, Football, Florida State\n",
      "2009, Football, Florida\n",
      "2009, Football, Georgia Southern\n",
      "2009, Football, Georgia State\n",
      "2009, Football, Georgia Tech\n",
      "2009, Football, Georgia\n",
      "2009, Football, Hawaii\n",
      "2009, Football, Houston\n",
      "2009, Football, Illinois\n",
      "2009, Football, Indiana\n",
      "2009, Football, Iowa State\n",
      "2009, Football, Iowa\n",
      "2009, Football, Kansas State\n",
      "2009, Football, Kansas\n",
      "2009, Football, Kent State\n",
      "2009, Football, Kentucky\n",
      "2009, Football, Liberty\n",
      "2009, Football, LSU\n",
      "2009, Football, Louisiana Tech\n",
      "2009, Football, Louisville\n",
      "2009, Football, Marshall\n",
      "2009, Football, Maryland\n",
      "2009, Football, Massachusetts\n",
      "2009, Football, Memphis\n",
      "2009, Football, Miami (Ohio)\n",
      "2009, Football, Miami (Fla.)\n",
      "2009, Football, Michigan State\n",
      "2009, Football, Michigan\n",
      "2009, Football, Middle Tennessee\n",
      "2009, Football, Minnesota\n",
      "2009, Football, Mississippi State\n",
      "2009, Football, Mississippi\n",
      "2009, Football, Missouri\n",
      "2009, Football, North Carolina\n",
      "2009, Football, Nebraska\n",
      "2009, Football, Nevada-Las Vegas\n",
      "2009, Football, Nevada\n",
      "2009, Football, New Mexico State\n",
      "2009, Football, New Mexico\n",
      "2009, Football, North Carolina State\n",
      "2009, Football, North Texas\n",
      "2009, Football, Louisiana-Monroe\n",
      "2009, Football, Northern Illinois\n",
      "2009, Football, Northwestern\n",
      "2009, Football, Notre Dame\n",
      "2009, Football, Ohio State\n",
      "2009, Football, Ohio\n",
      "2009, Football, Oklahoma State\n",
      "2009, Football, Oklahoma\n",
      "2009, Football, Old Dominion\n",
      "2009, Football, Oregon State\n",
      "2009, Football, Oregon\n",
      "2009, Football, Penn State\n",
      "2009, Football, Pittsburgh\n",
      "2009, Football, Purdue\n",
      "2009, Football, Rice\n",
      "2009, Football, Rutgers\n",
      "2009, Football, San Diego State\n",
      "2009, Football, San Jose State\n",
      "2009, Football, South Alabama\n",
      "2009, Football, South Carolina\n",
      "2009, Football, South Florida\n",
      "2009, Football, Southern California\n",
      "2009, Football, Southern Methodist\n",
      "2009, Football, Southern Mississippi\n",
      "2009, Football, Texas State\n",
      "2009, Football, Louisiana-Lafayette\n",
      "2009, Football, Stanford\n",
      "2009, Football, Syracuse\n",
      "2009, Football, Temple\n",
      "2009, Football, Tennessee\n",
      "2009, Football, Texas A&M\n",
      "2009, Football, Texas Christian\n",
      "2009, Football, Texas Tech\n",
      "2009, Football, Texas\n",
      "2009, Football, Texas-El Paso\n",
      "2009, Football, Texas-San Antonio\n",
      "2009, Football, Toledo\n",
      "2009, Football, Troy\n",
      "2009, Football, Tulane\n",
      "2009, Football, Tulsa\n",
      "2009, Football, Air Force\n",
      "2009, Football, Army\n",
      "2009, Football, Navy\n",
      "2009, Football, Utah State\n",
      "2009, Football, Utah\n",
      "2009, Football, Vanderbilt\n",
      "2009, Football, Virginia Tech\n",
      "2009, Football, Virginia\n",
      "2009, Football, Wake Forest\n",
      "2009, Football, Washington State\n",
      "2009, Football, Washington\n",
      "2009, Football, West Virginia\n",
      "2009, Football, Western Kentucky\n",
      "2009, Football, Western Michigan\n",
      "2009, Football, Wisconsin\n",
      "2009, Football, Wyoming\n",
      "2010, Football, Akron\n",
      "2010, Football, Alabama\n",
      "2010, Football, Alabama at Birmingham\n",
      "2010, Football, Appalachian State\n",
      "2010, Football, Arizona State\n",
      "2010, Football, Arizona\n",
      "2010, Football, Arkansas State\n",
      "2010, Football, Arkansas\n",
      "2010, Football, Auburn\n",
      "2010, Football, Ball State\n",
      "2010, Football, Baylor\n",
      "2010, Football, Boise State\n",
      "2010, Football, Boston College\n",
      "2010, Football, Bowling Green\n",
      "2010, Football, Brigham Young\n",
      "2010, Football, Buffalo\n",
      "2010, Football, Fresno State\n",
      "2010, Football, California\n",
      "2010, Football, UCLA\n",
      "2010, Football, Central Florida\n",
      "2010, Football, Central Michigan\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2010, Football, Cincinnati\n",
      "2010, Football, Clemson\n",
      "2010, Football, Coastal Carolina\n",
      "2010, Football, Colorado State\n",
      "2010, Football, Colorado\n",
      "2010, Football, Connecticut\n",
      "2010, Football, Duke\n",
      "2010, Football, East Carolina\n",
      "2010, Football, Eastern Michigan\n",
      "2010, Football, Florida Atlantic\n",
      "2010, Football, Florida International\n",
      "2010, Football, Florida State\n",
      "2010, Football, Florida\n",
      "2010, Football, Georgia Southern\n",
      "2010, Football, Georgia State\n",
      "2010, Football, Georgia Tech\n",
      "2010, Football, Georgia\n",
      "2010, Football, Hawaii\n",
      "2010, Football, Houston\n",
      "2010, Football, Illinois\n",
      "2010, Football, Indiana\n",
      "2010, Football, Iowa State\n",
      "2010, Football, Iowa\n",
      "2010, Football, Kansas State\n",
      "2010, Football, Kansas\n",
      "2010, Football, Kent State\n",
      "2010, Football, Kentucky\n",
      "2010, Football, Liberty\n",
      "2010, Football, LSU\n",
      "2010, Football, Louisiana Tech\n",
      "2010, Football, Louisville\n",
      "2010, Football, Marshall\n",
      "2010, Football, Maryland\n",
      "2010, Football, Massachusetts\n",
      "2010, Football, Memphis\n",
      "2010, Football, Miami (Ohio)\n",
      "2010, Football, Miami (Fla.)\n",
      "2010, Football, Michigan State\n",
      "2010, Football, Michigan\n",
      "2010, Football, Middle Tennessee\n",
      "2010, Football, Minnesota\n",
      "2010, Football, Mississippi State\n",
      "2010, Football, Mississippi\n",
      "2010, Football, Missouri\n",
      "2010, Football, North Carolina\n",
      "2010, Football, Nebraska\n",
      "2010, Football, Nevada-Las Vegas\n",
      "2010, Football, Nevada\n",
      "2010, Football, New Mexico State\n",
      "2010, Football, New Mexico\n",
      "2010, Football, North Carolina State\n",
      "2010, Football, North Texas\n",
      "2010, Football, Louisiana-Monroe\n",
      "2010, Football, Northern Illinois\n",
      "2010, Football, Northwestern\n",
      "2010, Football, Notre Dame\n",
      "2010, Football, Ohio State\n",
      "2010, Football, Ohio\n",
      "2010, Football, Oklahoma State\n",
      "2010, Football, Oklahoma\n",
      "2010, Football, Old Dominion\n",
      "2010, Football, Oregon State\n",
      "2010, Football, Oregon\n",
      "2010, Football, Penn State\n",
      "2010, Football, Pittsburgh\n",
      "2010, Football, Purdue\n",
      "2010, Football, Rice\n",
      "2010, Football, Rutgers\n",
      "2010, Football, San Diego State\n",
      "2010, Football, San Jose State\n",
      "2010, Football, South Alabama\n",
      "2010, Football, South Carolina\n",
      "2010, Football, South Florida\n",
      "2010, Football, Southern California\n",
      "2010, Football, Southern Methodist\n",
      "2010, Football, Southern Mississippi\n",
      "2010, Football, Texas State\n",
      "2010, Football, Louisiana-Lafayette\n",
      "2010, Football, Stanford\n",
      "2010, Football, Syracuse\n",
      "2010, Football, Temple\n",
      "2010, Football, Tennessee\n",
      "2010, Football, Texas A&M\n",
      "2010, Football, Texas Christian\n",
      "2010, Football, Texas Tech\n",
      "2010, Football, Texas\n",
      "2010, Football, Texas-El Paso\n",
      "2010, Football, Texas-San Antonio\n",
      "2010, Football, Toledo\n",
      "2010, Football, Troy\n",
      "2010, Football, Tulane\n",
      "2010, Football, Tulsa\n",
      "2010, Football, Air Force\n",
      "2010, Football, Army\n",
      "2010, Football, Navy\n",
      "2010, Football, Utah State\n",
      "2010, Football, Utah\n",
      "2010, Football, Vanderbilt\n",
      "2010, Football, Virginia Tech\n",
      "2010, Football, Virginia\n",
      "2010, Football, Wake Forest\n",
      "2010, Football, Washington State\n",
      "2010, Football, Washington\n",
      "2010, Football, West Virginia\n",
      "2010, Football, Western Kentucky\n",
      "2010, Football, Western Michigan\n",
      "2010, Football, Wisconsin\n",
      "2010, Football, Wyoming\n",
      "2011, Football, Akron\n",
      "2011, Football, Alabama\n",
      "2011, Football, Alabama at Birmingham\n",
      "2011, Football, Appalachian State\n",
      "2011, Football, Arizona State\n",
      "2011, Football, Arizona\n",
      "2011, Football, Arkansas State\n",
      "2011, Football, Arkansas\n",
      "2011, Football, Auburn\n",
      "2011, Football, Ball State\n",
      "2011, Football, Baylor\n",
      "2011, Football, Boise State\n",
      "2011, Football, Boston College\n",
      "2011, Football, Bowling Green\n",
      "2011, Football, Brigham Young\n",
      "2011, Football, Buffalo\n",
      "2011, Football, Fresno State\n",
      "2011, Football, California\n",
      "2011, Football, UCLA\n",
      "2011, Football, Central Florida\n",
      "2011, Football, Central Michigan\n",
      "2011, Football, Cincinnati\n",
      "2011, Football, Clemson\n",
      "2011, Football, Coastal Carolina\n",
      "2011, Football, Colorado State\n",
      "2011, Football, Colorado\n",
      "2011, Football, Connecticut\n",
      "2011, Football, Duke\n",
      "2011, Football, East Carolina\n",
      "2011, Football, Eastern Michigan\n",
      "2011, Football, Florida Atlantic\n",
      "2011, Football, Florida International\n",
      "2011, Football, Florida State\n",
      "2011, Football, Florida\n",
      "2011, Football, Georgia Southern\n",
      "2011, Football, Georgia State\n",
      "2011, Football, Georgia Tech\n",
      "2011, Football, Georgia\n",
      "2011, Football, Hawaii\n",
      "2011, Football, Houston\n",
      "2011, Football, Illinois\n",
      "2011, Football, Indiana\n",
      "2011, Football, Iowa State\n",
      "2011, Football, Iowa\n",
      "2011, Football, Kansas State\n",
      "2011, Football, Kansas\n",
      "2011, Football, Kent State\n",
      "2011, Football, Kentucky\n",
      "2011, Football, Liberty\n",
      "2011, Football, LSU\n",
      "2011, Football, Louisiana Tech\n",
      "2011, Football, Louisville\n",
      "2011, Football, Marshall\n",
      "2011, Football, Maryland\n",
      "2011, Football, Massachusetts\n",
      "2011, Football, Memphis\n",
      "2011, Football, Miami (Ohio)\n",
      "2011, Football, Miami (Fla.)\n",
      "2011, Football, Michigan State\n",
      "2011, Football, Michigan\n",
      "2011, Football, Middle Tennessee\n",
      "2011, Football, Minnesota\n",
      "2011, Football, Mississippi State\n",
      "2011, Football, Mississippi\n",
      "2011, Football, Missouri\n",
      "2011, Football, North Carolina\n",
      "2011, Football, Charlotte\n",
      "2011, Football, Nebraska\n",
      "2011, Football, Nevada-Las Vegas\n",
      "2011, Football, Nevada\n",
      "2011, Football, New Mexico State\n",
      "2011, Football, New Mexico\n",
      "2011, Football, North Carolina State\n",
      "2011, Football, North Texas\n",
      "2011, Football, Louisiana-Monroe\n",
      "2011, Football, Northern Illinois\n",
      "2011, Football, Northwestern\n",
      "2011, Football, Notre Dame\n",
      "2011, Football, Ohio State\n",
      "2011, Football, Ohio\n",
      "2011, Football, Oklahoma State\n",
      "2011, Football, Oklahoma\n",
      "2011, Football, Old Dominion\n",
      "2011, Football, Oregon State\n",
      "2011, Football, Oregon\n",
      "2011, Football, Penn State\n",
      "2011, Football, Pittsburgh\n",
      "2011, Football, Purdue\n",
      "2011, Football, Rice\n",
      "2011, Football, Rutgers\n",
      "2011, Football, San Diego State\n",
      "2011, Football, San Jose State\n",
      "2011, Football, South Alabama\n",
      "2011, Football, South Carolina\n",
      "2011, Football, South Florida\n",
      "2011, Football, Southern California\n",
      "2011, Football, Southern Methodist\n",
      "2011, Football, Southern Mississippi\n",
      "2011, Football, Texas State\n",
      "2011, Football, Louisiana-Lafayette\n",
      "2011, Football, Stanford\n",
      "2011, Football, Syracuse\n",
      "2011, Football, Temple\n",
      "2011, Football, Tennessee\n",
      "2011, Football, Texas A&M\n",
      "2011, Football, Texas Christian\n",
      "2011, Football, Texas Tech\n",
      "2011, Football, Texas\n",
      "2011, Football, Texas-El Paso\n",
      "2011, Football, Texas-San Antonio\n",
      "2011, Football, Toledo\n",
      "2011, Football, Troy\n",
      "2011, Football, Tulane\n",
      "2011, Football, Tulsa\n",
      "2011, Football, Air Force\n",
      "2011, Football, Army\n",
      "2011, Football, Navy\n",
      "2011, Football, Utah State\n",
      "2011, Football, Utah\n",
      "2011, Football, Vanderbilt\n",
      "2011, Football, Virginia Tech\n",
      "2011, Football, Virginia\n",
      "2011, Football, Wake Forest\n",
      "2011, Football, Washington State\n",
      "2011, Football, Washington\n",
      "2011, Football, West Virginia\n",
      "2011, Football, Western Kentucky\n",
      "2011, Football, Western Michigan\n",
      "2011, Football, Wisconsin\n",
      "2011, Football, Wyoming\n",
      "2012, Football, Akron\n",
      "2012, Football, Alabama\n",
      "2012, Football, Alabama at Birmingham\n",
      "2012, Football, Appalachian State\n",
      "2012, Football, Arizona State\n",
      "2012, Football, Arizona\n",
      "2012, Football, Arkansas State\n",
      "2012, Football, Arkansas\n",
      "2012, Football, Auburn\n",
      "2012, Football, Ball State\n",
      "2012, Football, Baylor\n",
      "2012, Football, Boise State\n",
      "2012, Football, Boston College\n",
      "2012, Football, Bowling Green\n",
      "2012, Football, Brigham Young\n",
      "2012, Football, Buffalo\n",
      "2012, Football, Fresno State\n",
      "2012, Football, California\n",
      "2012, Football, UCLA\n",
      "2012, Football, Central Florida\n",
      "2012, Football, Central Michigan\n",
      "2012, Football, Cincinnati\n",
      "2012, Football, Clemson\n",
      "2012, Football, Coastal Carolina\n",
      "2012, Football, Colorado State\n",
      "2012, Football, Colorado\n",
      "2012, Football, Connecticut\n",
      "2012, Football, Duke\n",
      "2012, Football, East Carolina\n",
      "2012, Football, Eastern Michigan\n",
      "2012, Football, Florida Atlantic\n",
      "2012, Football, Florida International\n",
      "2012, Football, Florida State\n",
      "2012, Football, Florida\n",
      "2012, Football, Georgia Southern\n",
      "2012, Football, Georgia State\n",
      "2012, Football, Georgia Tech\n",
      "2012, Football, Georgia\n",
      "2012, Football, Hawaii\n",
      "2012, Football, Houston\n",
      "2012, Football, Illinois\n",
      "2012, Football, Indiana\n",
      "2012, Football, Iowa State\n",
      "2012, Football, Iowa\n",
      "2012, Football, Kansas State\n",
      "2012, Football, Kansas\n",
      "2012, Football, Kent State\n",
      "2012, Football, Kentucky\n",
      "2012, Football, Liberty\n",
      "2012, Football, LSU\n",
      "2012, Football, Louisiana Tech\n",
      "2012, Football, Louisville\n",
      "2012, Football, Marshall\n",
      "2012, Football, Maryland\n",
      "2012, Football, Massachusetts\n",
      "2012, Football, Memphis\n",
      "2012, Football, Miami (Ohio)\n",
      "2012, Football, Miami (Fla.)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2012, Football, Michigan State\n",
      "2012, Football, Michigan\n",
      "2012, Football, Middle Tennessee\n",
      "2012, Football, Minnesota\n",
      "2012, Football, Mississippi State\n",
      "2012, Football, Mississippi\n",
      "2012, Football, Missouri\n",
      "2012, Football, North Carolina\n",
      "2012, Football, Charlotte\n",
      "2012, Football, Nebraska\n",
      "2012, Football, Nevada-Las Vegas\n",
      "2012, Football, Nevada\n",
      "2012, Football, New Mexico State\n",
      "2012, Football, New Mexico\n",
      "2012, Football, North Carolina State\n",
      "2012, Football, North Texas\n",
      "2012, Football, Louisiana-Monroe\n",
      "2012, Football, Northern Illinois\n",
      "2012, Football, Northwestern\n",
      "2012, Football, Notre Dame\n",
      "2012, Football, Ohio State\n",
      "2012, Football, Ohio\n",
      "2012, Football, Oklahoma State\n",
      "2012, Football, Oklahoma\n",
      "2012, Football, Old Dominion\n",
      "2012, Football, Oregon State\n",
      "2012, Football, Oregon\n",
      "2012, Football, Penn State\n",
      "2012, Football, Pittsburgh\n",
      "2012, Football, Purdue\n",
      "2012, Football, Rice\n",
      "2012, Football, Rutgers\n",
      "2012, Football, San Diego State\n",
      "2012, Football, San Jose State\n",
      "2012, Football, South Alabama\n",
      "2012, Football, South Carolina\n",
      "2012, Football, South Florida\n",
      "2012, Football, Southern California\n",
      "2012, Football, Southern Methodist\n",
      "2012, Football, Southern Mississippi\n",
      "2012, Football, Texas State\n",
      "2012, Football, Louisiana-Lafayette\n",
      "2012, Football, Stanford\n",
      "2012, Football, Syracuse\n",
      "2012, Football, Temple\n",
      "2012, Football, Tennessee\n",
      "2012, Football, Texas A&M\n",
      "2012, Football, Texas Christian\n",
      "2012, Football, Texas Tech\n",
      "2012, Football, Texas\n",
      "2012, Football, Texas-El Paso\n",
      "2012, Football, Texas-San Antonio\n",
      "2012, Football, Toledo\n",
      "2012, Football, Troy\n",
      "2012, Football, Tulane\n",
      "2012, Football, Tulsa\n",
      "2012, Football, Air Force\n",
      "2012, Football, Army\n",
      "2012, Football, Navy\n",
      "2012, Football, Utah State\n",
      "2012, Football, Utah\n",
      "2012, Football, Vanderbilt\n",
      "2012, Football, Virginia Tech\n",
      "2012, Football, Virginia\n",
      "2012, Football, Wake Forest\n",
      "2012, Football, Washington State\n",
      "2012, Football, Washington\n",
      "2012, Football, West Virginia\n",
      "2012, Football, Western Kentucky\n",
      "2012, Football, Western Michigan\n",
      "2012, Football, Wisconsin\n",
      "2012, Football, Wyoming\n"
     ]
    }
   ],
   "source": [
    "def get_grad_rates():\n",
    "    path = join(pwd,f'z_data\\Graduation_Success_Rate.html')\n",
    "    df=pd.read_html(path)[0]\n",
    "    df['sog']=df['School'].copy()\n",
    "    display(df)\n",
    "    def match_teams(name):\n",
    "        if name in team_match_dict.keys():\n",
    "            return team_match_dict[name]\n",
    "        else:\n",
    "            return name\n",
    "    df['School']=df['School'].map(match_teams)\n",
    "    df['School']=df['School'].str.replace('University of','').str.strip()\n",
    "    df['year']=df['Cohort Year']\n",
    "    display(df.sample(5).head())\n",
    "    df['School']=df['School'].str.replace('University of','').str.strip()\n",
    "    df['School']=df['School'].str.replace('University','').str.strip()\n",
    "    for tup in df.itertuples():\n",
    "        season = Season.objects.get(year=tup.year)\n",
    "        team = Team.objects.filter(school__name=tup.School).first()\n",
    "        if pd.isna(team): continue\n",
    "        ts,c = TeamSeason.objects.update_or_create(\n",
    "            team=team,season=season,\n",
    "            defaults=dict(gsr=tup.GSR,fgr=tup.FGR)\n",
    "        )\n",
    "        print(ts.GSR)\n",
    "#get_grad_rates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Django Shell-Plus",
   "language": "python",
   "name": "django_extensions"
  },
  "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}