ESPN_Roster_Grab

{
 "metadata": {
  "name": "ESPNRosterGrab_Clean"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "Final, Grabs and cleans the rosters into a list"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "import csv\nfrom bs4 import BeautifulSoup\nfrom urllib2 import urlopen\nimport string\nimport re\n\nrows = []\n\n\n\nsoup = BeautifulSoup(urlopen('http://games.espn.go.com/ffl/leaguerosters?leagueId=280610'))\n\nfor table in soup.findAll('table', attrs={ 'class' : 'playerTableTable'}):\n    team = [header.text for header in table.find_all('th')]\n    team= [team[0][:-6]]\n    for row in table.find_all('tr'):\n        #print(row)\n        if len(row)>1:\n            levelone = [val.text.encode('utf8') for val in row.find_all('td')]\n            #print(levelone)\n            if levelone != ['SLOT', 'PLAYER, TEAM POS', 'ACQ'] and len(levelone)>0:\n                playerdata = levelone[1].split(\",\")\n                #print(playerdata)\n                if len(playerdata)>1:\n                    player2 = re.compile(\"\\W\").split(playerdata[1])\n                    player2 = filter(None, player2)\n                    #print(player2)\n                    player1 = [playerdata[0]]\n                    #print(player1)\n                    x = team + [levelone[0]]+ player1 + player2[:2]\n                    #print(x)\n                else:\n                    player1 = re.compile(\"\\W\").split(playerdata[0])\n                    x = team + [levelone[0]] + player1[:2]\n                    #print(x)\n                \n                rows.append(x)\nprint(rows)\n          \n\n    \n\n#with open('output_file.csv', 'wb') as f:\n#     writer = csv.writer(f)\n#     writer.writerows(row for row in rows if row)",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": "[[u'FUCK JOKER ZOMBIES', 'QB', 'Robert Griffin III', 'Wsh', 'QB'], [u'FUCK JOKER ZOMBIES', 'RB', 'Arian Foster', 'Hou', 'RB'], [u'FUCK JOKER ZOMBIES', 'RB', 'Ray Rice', 'Bal', 'RB'], [u'FUCK JOKER ZOMBIES', 'RB/WR', 'Marques Colston', 'NO', 'WR'], [u'FUCK JOKER ZOMBIES', 'WR', 'Demaryius Thomas', 'Den', 'WR'], [u'FUCK JOKER ZOMBIES', 'WR', 'Reggie Wayne', 'Ind', 'WR'], [u'FUCK JOKER ZOMBIES', 'TE', 'Owen Daniels*', 'Hou', 'TE'], [u'FUCK JOKER ZOMBIES', 'D/ST', 'Texans', 'D'], [u'FUCK JOKER ZOMBIES', 'K', 'Randy Bullock', 'Hou', 'K'], [u'FUCK JOKER ZOMBIES', 'Bench', 'Antonio Brown', 'Pit', 'WR'], [u'FUCK JOKER ZOMBIES', 'Bench', 'Tavon Austin', 'StL', 'WR'], [u'FUCK JOKER ZOMBIES', 'Bench', 'Steve Johnson', 'Buf', 'WR'], [u'FUCK JOKER ZOMBIES', 'Bench', 'Rashard Mendenhall', 'Ari', 'RB'], [u'FUCK JOKER ZOMBIES', 'Bench', 'Sam Bradford', 'StL', 'QB'], [u'FUCK JOKER ZOMBIES', 'Bench', 'Bilal Powell', 'NYJ', 'RB'], [u'BEGGING  FOR A PEGGING', 'QB', 'Aaron Rodgers', 'GB', 'QB'], [u'BEGGING  FOR A PEGGING', 'RB', 'Johnathan Franklin', 'GB', 'RB'], [u'BEGGING  FOR A PEGGING', 'RB', 'LeGarrette Blount', 'NE', 'RB'], [u'BEGGING  FOR A PEGGING', 'RB/WR', 'DeSean Jackson', 'Phi', 'WR'], [u'BEGGING  FOR A PEGGING', 'WR', 'Dez Bryant', 'Dal', 'WR'], [u'BEGGING  FOR A PEGGING', 'WR', 'Victor Cruz', 'NYG', 'WR'], [u'BEGGING  FOR A PEGGING', 'TE', 'Julius Thomas', 'Den', 'TE'], [u'BEGGING  FOR A PEGGING', 'D/ST', 'Colts', 'D'], [u'BEGGING  FOR A PEGGING', 'K', 'Steven Hauschka', 'Sea', 'K'], [u'BEGGING  FOR A PEGGING', 'Bench', 'Alfred Morris', 'Wsh', 'RB'], [u'BEGGING  FOR A PEGGING', 'Bench', 'Stevan Ridley', 'NE', 'RB'], [u'BEGGING  FOR A PEGGING', 'Bench', 'Tony Gonzalez', 'Atl', 'TE'], [u'BEGGING  FOR A PEGGING', 'Bench', 'Ahmad Bradshaw*', 'Ind', 'RB'], [u'BEGGING  FOR A PEGGING', 'Bench', 'Julian Edelman', 'NE', 'WR'], [u'BEGGING  FOR A PEGGING', 'Bench', 'Eddie Royal', 'SD', 'WR'], [u\"SIXT-NINE'IN AND PREGNANT\", 'QB', 'Matthew Stafford', 'Det', 'QB'], [u\"SIXT-NINE'IN AND PREGNANT\", 'RB', 'Adrian Peterson', 'Min', 'RB'], [u\"SIXT-NINE'IN AND PREGNANT\", 'RB', 'LeSean McCoy', 'Phi', 'RB'], [u\"SIXT-NINE'IN AND PREGNANT\", 'RB/WR', 'Fred Jackson', 'Buf', 'RB'], [u\"SIXT-NINE'IN AND PREGNANT\", 'WR', 'Vincent Jackson', 'TB', 'WR'], [u\"SIXT-NINE'IN AND PREGNANT\", 'WR', 'Larry Fitzgerald', 'Ari', 'WR'], [u\"SIXT-NINE'IN AND PREGNANT\", 'TE', 'Martellus Bennett', 'Chi', 'TE'], [u\"SIXT-NINE'IN AND PREGNANT\", 'D/ST', 'Chiefs', 'D'], [u\"SIXT-NINE'IN AND PREGNANT\", 'K', 'Stephen Gostkowski', 'NE', 'K'], [u\"SIXT-NINE'IN AND PREGNANT\", 'Bench', 'C.J. Spiller', 'Buf', 'RB'], [u\"SIXT-NINE'IN AND PREGNANT\", 'Bench', 'Rob Gronkowski', 'NE', 'TE'], [u\"SIXT-NINE'IN AND PREGNANT\", 'Bench', 'Michael Vick', 'Phi', 'QB'], [u\"SIXT-NINE'IN AND PREGNANT\", 'Bench', 'Matt Prater', 'Den', 'K'], [u\"SIXT-NINE'IN AND PREGNANT\", 'Bench', 'Brian Hartline', 'Mia', 'WR'], [u\"SIXT-NINE'IN AND PREGNANT\", 'Bench', 'Nate Washington', 'Ten', 'WR'], [u'DEEP INSIDE OF YOU', 'QB', 'Jay Cutler', 'Chi', 'QB'], [u'DEEP INSIDE OF YOU', 'RB', 'Marshawn Lynch', 'Sea', 'RB'], [u'DEEP INSIDE OF YOU', 'RB', \"Le'Veon Bell\", 'Pit', 'RB'], [u'DEEP INSIDE OF YOU', 'RB/WR', 'Hakeem Nicks', 'NYG', 'WR'], [u'DEEP INSIDE OF YOU', 'WR', 'A.J. Green', 'Cin', 'WR'], [u'DEEP INSIDE OF YOU', 'WR', 'Rueben Randle', 'NYG', 'WR'], [u'DEEP INSIDE OF YOU', 'TE', 'Charles Clay', 'Mia', 'TE'], [u'DEEP INSIDE OF YOU', 'D/ST', 'Browns', 'D'], [u'DEEP INSIDE OF YOU', 'K', 'Alex Henery', 'Phi', 'K'], [u'DEEP INSIDE OF YOU', 'Bench', 'David Wilson*', 'NYG', 'RB'], [u'DEEP INSIDE OF YOU', 'Bench', 'Mike Wallace', 'Mia', 'WR'], [u'DEEP INSIDE OF YOU', 'Bench', 'Daryl Richardson', 'StL', 'RB'], [u'DEEP INSIDE OF YOU', 'Bench', 'Brandon Myers', 'NYG', 'TE'], [u'DEEP INSIDE OF YOU', 'Bench', 'Matt Schaub', 'Hou', 'QB'], [u'DEEP INSIDE OF YOU', 'Bench', 'Marlon Brown', 'Bal', 'WR'], [u'SECTION V DEVIANTS', 'QB', 'Matt Ryan', 'Atl', 'QB'], [u'SECTION V DEVIANTS', 'RB', 'DeAngelo Williams', 'Car', 'RB'], [u'SECTION V DEVIANTS', 'RB', 'Jacquizz Rodgers', 'Atl', 'RB'], [u'SECTION V DEVIANTS', 'RB/WR', 'Anquan Boldin', 'SF', 'WR'], [u'SECTION V DEVIANTS', 'WR', 'Wes Welker', 'Den', 'WR'], [u'SECTION V DEVIANTS', 'WR', 'Danny Amendola', 'NE', 'WR'], [u'SECTION V DEVIANTS', 'TE', 'Heath Miller', 'Pit', 'TE'], [u'SECTION V DEVIANTS', 'D/ST', 'Bengals', 'D'], [u'SECTION V DEVIANTS', 'K', 'Matt Bryant', 'Atl', 'K'], [u'SECTION V DEVIANTS', 'Bench', 'Tom Brady', 'NE', 'QB'], [u'SECTION V DEVIANTS', 'Bench', 'Steven Jackson*', 'Atl', 'RB'], [u'SECTION V DEVIANTS', 'Bench', 'Ted Ginn', 'Car', 'WR'], [u'SECTION V DEVIANTS', 'Bench', 'Robert Meachem', 'NO', 'WR'], [u'SECTION V DEVIANTS', 'Bench', 'Kenbrell Thompkins', 'NE', 'WR'], [u'SECTION V DEVIANTS', 'Bench', 'Jason Snelling', 'Atl', 'RB'], [u\"OJ'S SLASHERS AND DASHERS\", 'QB', 'Andrew Luck', 'Ind', 'QB'], [u\"OJ'S SLASHERS AND DASHERS\", 'RB', 'Eddie Lacy', 'GB', 'RB'], [u\"OJ'S SLASHERS AND DASHERS\", 'RB', 'Knowshon Moreno', 'Den', 'RB'], [u\"OJ'S SLASHERS AND DASHERS\", 'RB/WR', 'Trent Richardson', 'Ind', 'RB'], [u\"OJ'S SLASHERS AND DASHERS\", 'WR', 'Brandon Marshall', 'Chi', 'WR'], [u\"OJ'S SLASHERS AND DASHERS\", 'WR', 'Jordy Nelson', 'GB', 'WR'], [u\"OJ'S SLASHERS AND DASHERS\", 'TE', 'Greg Olsen', 'Car', 'TE'], [u\"OJ'S SLASHERS AND DASHERS\", 'D/ST', 'Broncos', 'D'], [u\"OJ'S SLASHERS AND DASHERS\", 'K', 'Garrett Hartley', 'NO', 'K'], [u\"OJ'S SLASHERS AND DASHERS\", 'Bench', 'Eric Decker', 'Den', 'WR'], [u\"OJ'S SLASHERS AND DASHERS\", 'Bench', 'Ben Tate', 'Hou', 'RB'], [u\"OJ'S SLASHERS AND DASHERS\", 'Bench', 'T.Y. Hilton', 'Ind', 'WR'], [u\"OJ'S SLASHERS AND DASHERS\", 'Bench', 'Quinton Patton*', 'SF', 'WR'], [u\"OJ'S SLASHERS AND DASHERS\", 'Bench', 'Joique Bell', 'Det', 'RB'], [u\"OJ'S SLASHERS AND DASHERS\", 'Bench', 'Scott Chandler', 'Buf', 'TE'], [u'TEAM HEIM', 'QB', 'Drew Brees', 'NO', 'QB'], [u'TEAM HEIM', 'RB', 'Jamaal Charles', 'KC', 'RB'], [u'TEAM HEIM', 'RB', 'Danny Woodhead', 'SD', 'RB'], [u'TEAM HEIM', 'RB/WR', 'Darren Sproles', 'NO', 'RB'], [u'TEAM HEIM', 'WR', 'Julio Jones', 'Atl', 'WR'], [u'TEAM HEIM', 'WR', 'Torrey Smith', 'Bal', 'WR'], [u'TEAM HEIM', 'TE', 'Jared Cook', 'StL', 'TE'], [u'TEAM HEIM', 'D/ST', 'Bears', 'D'], [u'TEAM HEIM', 'K', 'Dan Bailey', 'Dal', 'K'], [u'TEAM HEIM', 'Bench', 'Vernon Davis', 'SF', 'TE'], [u'TEAM HEIM', 'Bench', 'Chris Johnson', 'Ten', 'RB'], [u'TEAM HEIM', 'Bench', 'Eli Manning', 'NYG', 'QB'], [u'TEAM HEIM', 'Bench', 'Michael Floyd', 'Ari', 'WR'], [u'TEAM HEIM', 'Bench', 'Michael Bush', 'Chi', 'RB'], [u'TEAM HEIM', 'Bench', 'James Jones', 'GB', 'WR'], [u'JOKER ZOMBIES RULE', 'QB', 'Tony Romo', 'Dal', 'QB'], [u'JOKER ZOMBIES RULE', 'RB', 'Matt Forte', 'Chi', 'RB'], [u'JOKER ZOMBIES RULE', 'RB', 'DeMarco Murray', 'Dal', 'RB'], [u'JOKER ZOMBIES RULE', 'RB/WR', 'Reggie Bush', 'Det', 'RB'], [u'JOKER ZOMBIES RULE', 'WR', 'Calvin Johnson', 'Det', 'WR'], [u'JOKER ZOMBIES RULE', 'WR', 'Josh Gordon', 'Cle', 'WR'], [u'JOKER ZOMBIES RULE', 'TE', 'Jimmy Graham', 'NO', 'TE'], [u'JOKER ZOMBIES RULE', 'D/ST', '49ers', 'D'], [u'JOKER ZOMBIES RULE', 'K', 'Phil Dawson', 'SF', 'K'], [u'JOKER ZOMBIES RULE', 'Bench', 'Cam Newton', 'Car', 'QB'], [u'JOKER ZOMBIES RULE', 'Bench', 'Darren McFadden', 'Oak', 'RB'], [u'JOKER ZOMBIES RULE', 'Bench', 'Cecil Shorts', 'Jac', 'WR'], [u'JOKER ZOMBIES RULE', 'Bench', 'Jordan Cameron', 'Cle', 'TE'], [u'JOKER ZOMBIES RULE', 'Bench', 'Giovani Bernard', 'Cin', 'RB'], [u'JOKER ZOMBIES RULE', 'Bench', 'Philip Rivers', 'SD', 'QB'], [u'TITTY CITY TOBLERONES', 'QB', 'Peyton Manning', 'Den', 'QB'], [u'TITTY CITY TOBLERONES', 'RB', 'Frank Gore', 'SF', 'RB'], [u'TITTY CITY TOBLERONES', 'RB', 'Bernard Pierce', 'Bal', 'RB'], [u'TITTY CITY TOBLERONES', 'RB/WR', 'BenJarvus Green-Ellis', 'Cin', 'RB'], [u'TITTY CITY TOBLERONES', 'WR', 'Randall Cobb', 'GB', 'WR'], [u'TITTY CITY TOBLERONES', 'WR', 'Denarius Moore', 'Oak', 'WR'], [u'TITTY CITY TOBLERONES', 'TE', 'Antonio Gates', 'SD', 'TE'], [u'TITTY CITY TOBLERONES', 'D/ST', 'Rams', 'D'], [u'TITTY CITY TOBLERONES', 'K', 'Blair Walsh', 'Min', 'K'], [u'TITTY CITY TOBLERONES', 'Bench', 'Maurice Jones-Drew', 'Jac', 'RB'], [u'TITTY CITY TOBLERONES', 'Bench', 'Steve Smith', 'Car', 'WR'], [u'TITTY CITY TOBLERONES', 'Bench', 'Pierre Garcon', 'Wsh', 'WR'], [u'TITTY CITY TOBLERONES', 'Bench', 'Jermichael Finley', 'GB', 'TE'], [u'TITTY CITY TOBLERONES', 'Bench', 'LaMichael James', 'SF', 'RB'], [u'TITTY CITY TOBLERONES', 'Bench', 'Ryan Succop', 'KC', 'K'], [u'STUPID SEXY FLANDERS', 'QB', 'Russell Wilson', 'Sea', 'QB'], [u'STUPID SEXY FLANDERS', 'RB', 'Doug Martin', 'TB', 'RB'], [u'STUPID SEXY FLANDERS', 'RB', 'Isaiah Pead', 'StL', 'RB'], [u'STUPID SEXY FLANDERS', 'RB/WR', 'Golden Tate', 'Sea', 'WR'], [u'STUPID SEXY FLANDERS', 'WR', 'Andre Johnson', 'Hou', 'WR'], [u'STUPID SEXY FLANDERS', 'WR', 'Dwayne Bowe', 'KC', 'WR'], [u'STUPID SEXY FLANDERS', 'TE', 'Jason Witten', 'Dal', 'TE'], [u'STUPID SEXY FLANDERS', 'D/ST', 'Seahawks', 'D'], [u'STUPID SEXY FLANDERS', 'K', 'Greg Zuerlein', 'StL', 'K'], [u'STUPID SEXY FLANDERS', 'Bench', 'Colin Kaepernick', 'SF', 'QB'], [u'STUPID SEXY FLANDERS', 'Bench', 'Percy Harvin*', 'Sea', 'WR'], [u'STUPID SEXY FLANDERS', 'Bench', 'Lamar Miller', 'Mia', 'RB'], [u'STUPID SEXY FLANDERS', 'Bench', 'Ben Roethlisberger', 'Pit', 'QB'], [u'STUPID SEXY FLANDERS', 'Bench', 'Montee Ball', 'Den', 'RB'], [u'STUPID SEXY FLANDERS', 'Bench', 'Jermaine Gresham', 'Cin', 'TE']]\n"
      }
     ],
     "prompt_number": 271
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "Pandas version that makes data frames"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "import pandas as pd\nimport html5lib\npd.io.html.read_html('http://games.espn.go.com/ffl/leaguerosters?leagueId=280610','.+',None)",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 1,
       "text": "[                           0                           1            2\n0   SECTION V DEVIANTS (3-2)                        None         None\n1                       SLOT            PLAYER, TEAM POS          ACQ\n2                         QB           Matt Ryan, Atl\u00a0QB        Draft\n3                         RB   DeAngelo Williams, Car\u00a0RB        Draft\n4                         RB    Jacquizz Rodgers, Atl\u00a0RB  Free Agency\n5                      RB/WR        Anquan Boldin, SF\u00a0WR        Draft\n6                         WR          Wes Welker, Den\u00a0WR        Draft\n7                         WR    Danny Amendola, NE\u00a0WR\u00a0\u00a0P        Draft\n8                         TE        Heath Miller, Pit\u00a0TE  Free Agency\n9                       D/ST           Bengals D/ST\u00a0D/ST        Draft\n10                         K          Matt Bryant, Atl\u00a0K        Draft\n11                     Bench            Tom Brady, NE\u00a0QB        Draft\n12                     Bench  Steven Jackson*, Atl\u00a0RB\u00a0\u00a0O        Draft\n13                     Bench            Ted Ginn, Car\u00a0WR        Draft\n14                     Bench       Robert Meachem, NO\u00a0WR  Free Agency\n15                     Bench   Kenbrell Thompkins, NE\u00a0WR  Free Agency\n16                     Bench   Jason Snelling, Atl\u00a0RB\u00a0\u00a0Q  Free Agency,\n                            0                           1            2\n0   FUCK JOKER ZOMBIES (2-3)                        None         None\n1                       SLOT            PLAYER, TEAM POS          ACQ\n2                         QB  Robert Griffin III, Wsh\u00a0QB        Draft\n3                         RB        Arian Foster, Hou\u00a0RB        Draft\n4                         RB            Ray Rice, Bal\u00a0RB        Draft\n5                      RB/WR      Marques Colston, NO\u00a0WR        Draft\n6                         WR    Demaryius Thomas, Den\u00a0WR        Draft\n7                         WR        Reggie Wayne, Ind\u00a0WR        Draft\n8                         TE    Owen Daniels*, Hou\u00a0TE\u00a0\u00a0O        Draft\n9                       D/ST            Texans D/ST\u00a0D/ST  Free Agency\n10                         K        Randy Bullock, Hou\u00a0K        Draft\n11                     Bench       Antonio Brown, Pit\u00a0WR        Draft\n12                     Bench       Steve Johnson, Buf\u00a0WR        Draft\n13                     Bench  Rashard Mendenhall, Ari\u00a0RB        Draft\n14                     Bench        Sam Bradford, StL\u00a0QB        Draft\n15                     Bench        Bilal Powell, NYJ\u00a0RB  Free Agency\n16                     Bench        Coby Fleener, Ind\u00a0TE  Free Agency,\n                                   0                          1            2\n0   OJ'S SLASHERS AND DASHERS (5-0)                       None         None\n1                              SLOT           PLAYER, TEAM POS          ACQ\n2                                QB        Andrew Luck, Ind\u00a0QB        Draft\n3                                RB          Eddie Lacy, GB\u00a0RB        Draft\n4                                RB    Knowshon Moreno, Den\u00a0RB        Draft\n5                             RB/WR   Trent Richardson, Ind\u00a0RB        Draft\n6                                WR   Brandon Marshall, Chi\u00a0WR        Draft\n7                                WR        Jordy Nelson, GB\u00a0WR        Draft\n8                                TE      Greg Olsen, Car\u00a0TE\u00a0\u00a0Q        Draft\n9                              D/ST          Broncos D/ST\u00a0D/ST        Draft\n10                                K      Garrett Hartley, NO\u00a0K        Draft\n11                            Bench        Eric Decker, Den\u00a0WR        Draft\n12                            Bench           Ben Tate, Hou\u00a0RB        Draft\n13                            Bench        T.Y. Hilton, Ind\u00a0WR        Draft\n14                            Bench  Quinton Patton*, SF\u00a0WR\u00a0\u00a0O        Draft\n15                            Bench        Joique Bell, Det\u00a0RB  Free Agency\n16                            Bench     Scott Chandler, Buf\u00a0TE  Free Agency,\n                            0                          1            2\n0   DEEP INSIDE OF YOU (0-5)                       None         None\n1                       SLOT           PLAYER, TEAM POS          ACQ\n2                         QB         Jay Cutler, Chi\u00a0QB        Draft\n3                         RB     Marshawn Lynch, Sea\u00a0RB        Draft\n4                         RB       Le'Veon Bell, Pit\u00a0RB  Free Agency\n5                      RB/WR       Hakeem Nicks, NYG\u00a0WR        Draft\n6                         WR         A.J. Green, Cin\u00a0WR        Draft\n7                         WR      Rueben Randle, NYG\u00a0WR  Free Agency\n8                         TE       Charles Clay, Mia\u00a0TE  Free Agency\n9                       D/ST           Browns D/ST\u00a0D/ST  Free Agency\n10                         K         Alex Henery, Phi\u00a0K  Free Agency\n11                     Bench       Mike Wallace, Mia\u00a0WR        Draft\n12                     Bench   Daryl Richardson, StL\u00a0RB        Draft\n13                     Bench   Brandon Myers, NYG\u00a0TE\u00a0\u00a0Q  Free Agency\n14                     Bench        Matt Schaub, Hou\u00a0QB  Free Agency\n15                     Bench    Marlon Brown, Bal\u00a0WR\u00a0\u00a0Q  Free Agency\n16                     Bench  Alshon Jeffery, Chi\u00a0WR\u00a0\u00a0Q  Free Agency,\n                   0                         1            2\n0   TEAM HEIM (3-2)                      None         None\n1              SLOT          PLAYER, TEAM POS          ACQ\n2                QB         Drew Brees, NO\u00a0QB        Draft\n3                RB  Jamaal Charles, KC\u00a0RB\u00a0\u00a0P        Draft\n4                RB     Danny Woodhead, SD\u00a0RB        Draft\n5             RB/WR     Darren Sproles, NO\u00a0RB        Draft\n6                WR    Julio Jones, Atl\u00a0WR\u00a0\u00a0Q        Draft\n7                WR      Torrey Smith, Bal\u00a0WR        Draft\n8                TE        Jared Cook, StL\u00a0TE        Draft\n9              D/ST           Bears D/ST\u00a0D/ST        Draft\n10                K         Dan Bailey, Dal\u00a0K        Draft\n11            Bench    Vernon Davis, SF\u00a0TE\u00a0\u00a0P        Draft\n12            Bench     Chris Johnson, Ten\u00a0RB        Draft\n13            Bench       Eli Manning, NYG\u00a0QB        Draft\n14            Bench     Michael Floyd, Ari\u00a0WR        Draft\n15            Bench      Michael Bush, Chi\u00a0RB        Draft\n16            Bench        James Jones, GB\u00a0WR  Free Agency,\n                            0                           1            2\n0   JOKER ZOMBIES RULE (3-2)                        None         None\n1                       SLOT            PLAYER, TEAM POS          ACQ\n2                         QB           Tony Romo, Dal\u00a0QB        Draft\n3                         RB          Matt Forte, Chi\u00a0RB        Draft\n4                         RB      DeMarco Murray, Dal\u00a0RB        Draft\n5                      RB/WR         Reggie Bush, Det\u00a0RB        Draft\n6                         WR   Calvin Johnson, Det\u00a0WR\u00a0\u00a0Q        Draft\n7                         WR         Josh Gordon, Cle\u00a0WR        Draft\n8                         TE         Jimmy Graham, NO\u00a0TE        Draft\n9                       D/ST             49ers D/ST\u00a0D/ST        Draft\n10                         K           Phil Dawson, SF\u00a0K        Draft\n11                     Bench          Cam Newton, Car\u00a0QB        Draft\n12                     Bench  Darren McFadden, Oak\u00a0RB\u00a0\u00a0Q        Draft\n13                     Bench        Cecil Shorts, Jac\u00a0WR        Draft\n14                     Bench      Jordan Cameron, Cle\u00a0TE        Draft\n15                     Bench     Giovani Bernard, Cin\u00a0RB        Draft\n16                     Bench        Philip Rivers, SD\u00a0QB  Free Agency,\n                               0                              1            2\n0   TITTY CITY TOBLERONES (3-2)                           None         None\n1                          SLOT               PLAYER, TEAM POS          ACQ\n2                            QB         Peyton Manning, Den\u00a0QB        Draft\n3                            RB              Frank Gore, SF\u00a0RB        Draft\n4                            RB         Bernard Pierce, Bal\u00a0RB        Draft\n5                         RB/WR  BenJarvus Green-Ellis, Cin\u00a0RB  Free Agency\n6                            WR            Randall Cobb, GB\u00a0WR        Draft\n7                            WR         Denarius Moore, Oak\u00a0WR  Free Agency\n8                            TE           Antonio Gates, SD\u00a0TE  Free Agency\n9                          D/ST                 Rams D/ST\u00a0D/ST        Draft\n10                            K             Blair Walsh, Min\u00a0K        Draft\n11                        Bench     Maurice Jones-Drew, Jac\u00a0RB        Draft\n12                        Bench            Steve Smith, Car\u00a0WR        Draft\n13                        Bench          Pierre Garcon, Wsh\u00a0WR        Draft\n14                        Bench       Jermichael Finley, GB\u00a0TE        Draft\n15                        Bench              Alex Smith, KC\u00a0QB  Free Agency\n16                        Bench            Cardinals D/ST\u00a0D/ST  Free Agency,\n                               0                          1            2\n0   BEGGING FOR A PEGGING (3-2)                       None         None\n1                          SLOT           PLAYER, TEAM POS          ACQ\n2                            QB       Aaron Rodgers, GB\u00a0QB        Draft\n3                            RB  Johnathan Franklin, GB\u00a0RB  Free Agency\n4                            RB   LeGarrette Blount, NE\u00a0RB  Free Agency\n5                         RB/WR     DeSean Jackson, Phi\u00a0WR        Draft\n6                            WR         Dez Bryant, Dal\u00a0WR        Draft\n7                            WR        Victor Cruz, NYG\u00a0WR        Draft\n8                            TE      Julius Thomas, Den\u00a0TE        Draft\n9                          D/ST            Colts D/ST\u00a0D/ST  Free Agency\n10                            K     Steven Hauschka, Sea\u00a0K  Free Agency\n11                        Bench   Alfred Morris, Wsh\u00a0RB\u00a0\u00a0Q        Draft\n12                        Bench      Tony Gonzalez, Atl\u00a0TE        Draft\n13                        Bench      Julian Edelman, NE\u00a0WR  Free Agency\n14                        Bench         Eddie Royal, SD\u00a0WR  Free Agency\n15                        Bench     Willis McGahee, Cle\u00a0RB  Free Agency\n16                        Bench       Zac Stacy, StL\u00a0RB\u00a0\u00a0P  Free Agency,\n                                   0                             1            2\n0   SIXT-NINE'IN AND PREGNANT (2-3)                          None         None\n1                              SLOT              PLAYER, TEAM POS          ACQ\n2                                QB      Matthew Stafford, Det\u00a0QB        Draft\n3                                RB       Adrian Peterson, Min\u00a0RB        Draft\n4                                RB          LeSean McCoy, Phi\u00a0RB        Draft\n5                             RB/WR          Fred Jackson, Buf\u00a0RB        Draft\n6                                WR        Vincent Jackson, TB\u00a0WR        Draft\n7                                WR     Terrance Williams, Dal\u00a0WR  Free Agency\n8                                TE      Rob Gronkowski, NE\u00a0TE\u00a0\u00a0Q        Draft\n9                              D/ST              Chiefs D/ST\u00a0D/ST  Free Agency\n10                                K            Matt Prater, Den\u00a0K        Draft\n11                            Bench       C.J. Spiller, Buf\u00a0RB\u00a0\u00a0P        Draft\n12                            Bench      Larry Fitzgerald, Ari\u00a0WR        Draft\n13                            Bench      Stephen Gostkowski, NE\u00a0K        Draft\n14                            Bench       Michael Vick, Phi\u00a0QB\u00a0\u00a0Q        Draft\n15                            Bench        Brian Hartline, Mia\u00a0WR  Free Agency\n16                            Bench  Martellus Bennett, Chi\u00a0TE\u00a0\u00a0Q  Free Agency,\n                              0                              1            2\n0   STUPID SEXY FLANDERS (1-4)                           None         None\n1                         SLOT               PLAYER, TEAM POS          ACQ\n2                           QB         Russell Wilson, Sea\u00a0QB        Draft\n3                           RB             Doug Martin, TB\u00a0RB        Draft\n4                           RB            Isaiah Pead, StL\u00a0RB  Free Agency\n5                        RB/WR            Golden Tate, Sea\u00a0WR        Draft\n6                           WR          Andre Johnson, Hou\u00a0WR        Draft\n7                           WR             Dwayne Bowe, KC\u00a0WR        Draft\n8                           TE           Jason Witten, Dal\u00a0TE        Draft\n9                         D/ST             Seahawks D/ST\u00a0D/ST        Draft\n10                           K           Greg Zuerlein, StL\u00a0K        Draft\n11                       Bench        Colin Kaepernick, SF\u00a0QB        Draft\n12                       Bench       Percy Harvin*, Sea\u00a0WR\u00a0\u00a0O        Draft\n13                       Bench           Lamar Miller, Mia\u00a0RB        Draft\n14                       Bench  Ben Roethlisberger, Pit\u00a0QB\u00a0\u00a0P        Draft\n15                       Bench            Montee Ball, Den\u00a0RB        Draft\n16                       Bench       Jermaine Gresham, Cin\u00a0TE        Draft,\n <class 'pandas.core.frame.DataFrame'>\nInt64Index: 175 entries, 0 to 174\nColumns: 501 entries, 0 to 500\ndtypes: object(501)]"
      }
     ],
     "prompt_number": 1
    }
   ],
   "metadata": {}
  }
 ]
}