Skip to content

Instantly share code, notes, and snippets.

@nealcaren

nealcaren/ncaa_mbb_alert.ipynb

Last active March 18, 2016 19:20
Show Gist options
  • Save nealcaren/d5c61689008b5d78114b to your computer and use it in GitHub Desktop.
Save nealcaren/d5c61689008b5d78114b to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
ncaa_mbb_alert.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Build your own NCAA close game alert system\n",
"**Neal Caren** - University of North Carolina, Chapel Hill\n",
"[mail](mailto:neal.caren@unc.edu)\n",
"[web](http://nealcaren.web.unc.edu)\n",
"[twitter](http://twitter.com/HaphazardSoc)\n",
"[scholar](http://scholar.google.com/citations?user=cy0u16kAAAAJ&hl=en)\n",
"\n",
"\n",
"Seems like everyone has there own real-time scoring update system these days. I wanted one too, so I built one. While they don't advertise it, the NCAA produces JSONish file with scores and play-by-play data for a number of sports, including football and men's and women's basketball. I built a quick system to alert me to when games are close. With the right supporting data (such as win probability model or betting lines), it wouldn't be hard to expand this in more interesting directions."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Get realtime data."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"url = 'http://data.ncaa.com/jsonp/scoreboard/basketball-men/d1/2016/03/18/scoreboard.html'"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"from time import strftime\n",
"import json\n",
"\n",
"import requests\n",
"import numpy as np\n",
"import pandas as pd\n",
"from pandas.io.json import json_normalize\n",
"\n",
"pd.set_option('display.max_columns', 500)"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"def get_scoreboard():\n",
" # the secret NCAA real-time data url\n",
" year = strftime('%Y')\n",
" month = strftime('%m')\n",
" day = strftime('%d')\n",
"\n",
" url_base = 'http://data.ncaa.com/jsonp/scoreboard/basketball-men/d1/'\n",
" scoreboard_url = url_base + '%s/%s/%s/scoreboard.html' % (year,month,day)\n",
" \n",
" # NCAA doesn't like Python\n",
" user_agent = ('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_3) '\n",
" 'AppleWebKit/601.4.4 (KHTML, like Gecko) '\n",
" 'Version/9.0.3 Safari/601.4.4')\n",
"\n",
" headers = {'user-agent': user_agent}\n",
"\n",
" scoreboard_html = requests.get(scoreboard_url, headers=headers).text\n",
" \n",
" # the scoreboard html has a little crud at the front and back of the json\n",
" scoreboard_json = json.loads(scoreboard_html[16:-2])\n",
" \n",
" # the games are listed pretty deep in \n",
" df = json_normalize(scoreboard_json['scoreboard'][0]['games'])\n",
" return df\n",
" "
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"scoreboard_df = get_scoreboard()\n"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>away.color</th>\n",
" <th>away.currentScore</th>\n",
" <th>away.description</th>\n",
" <th>away.iconURL</th>\n",
" <th>away.name</th>\n",
" <th>away.nameRaw</th>\n",
" <th>away.nameSeo</th>\n",
" <th>away.scoreBreakdown</th>\n",
" <th>away.shortname</th>\n",
" <th>away.social.twitter.accounts.athleticDept</th>\n",
" <th>away.social.twitter.accounts.conference</th>\n",
" <th>away.social.twitter.accounts.ncaa</th>\n",
" <th>away.social.twitter.accounts.sport</th>\n",
" <th>away.social.twitter.keywords</th>\n",
" <th>away.teamRank</th>\n",
" <th>away.teamSeed</th>\n",
" <th>away.winner</th>\n",
" <th>bracket</th>\n",
" <th>bracketId</th>\n",
" <th>bracketRegion</th>\n",
" <th>bracketRound</th>\n",
" <th>champInfo.radioUrl</th>\n",
" <th>champInfo.watchLiveUrl</th>\n",
" <th>conference</th>\n",
" <th>contestName</th>\n",
" <th>currentPeriod</th>\n",
" <th>downToGo</th>\n",
" <th>finalMessage</th>\n",
" <th>gameCenterUrl</th>\n",
" <th>gameState</th>\n",
" <th>gameStatus</th>\n",
" <th>highlightsUrl</th>\n",
" <th>home.color</th>\n",
" <th>home.currentScore</th>\n",
" <th>home.description</th>\n",
" <th>home.iconURL</th>\n",
" <th>home.name</th>\n",
" <th>home.nameRaw</th>\n",
" <th>home.nameSeo</th>\n",
" <th>home.scoreBreakdown</th>\n",
" <th>home.shortname</th>\n",
" <th>home.social.twitter.accounts.athleticDept</th>\n",
" <th>home.social.twitter.accounts.conference</th>\n",
" <th>home.social.twitter.accounts.ncaa</th>\n",
" <th>home.social.twitter.accounts.sport</th>\n",
" <th>home.social.twitter.keywords</th>\n",
" <th>home.teamRank</th>\n",
" <th>home.teamSeed</th>\n",
" <th>home.winner</th>\n",
" <th>id</th>\n",
" <th>isLiveEnabled</th>\n",
" <th>liveAudioUrl</th>\n",
" <th>location</th>\n",
" <th>network</th>\n",
" <th>network_logo</th>\n",
" <th>periodStatus</th>\n",
" <th>scoreBreakdown</th>\n",
" <th>season_year</th>\n",
" <th>startDate</th>\n",
" <th>startDateDisplay</th>\n",
" <th>startTime</th>\n",
" <th>startTimeEpoch</th>\n",
" <th>status.distance</th>\n",
" <th>status.down</th>\n",
" <th>status.possession</th>\n",
" <th>status.yardline</th>\n",
" <th>tabs</th>\n",
" <th>tabsArray</th>\n",
" <th>timeclock</th>\n",
" <th>tournament_id</th>\n",
" <th>url</th>\n",
" <th>venue</th>\n",
" <th>venueCity</th>\n",
" <th>venueCityState</th>\n",
" <th>venueState</th>\n",
" <th>videos</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>#ff5113</td>\n",
" <td>70</td>\n",
" <td>19-13</td>\n",
" <td>/sites/default/files/images/logos/schools/s/sy...</td>\n",
" <td>&lt;a href='/schools/syracuse'&gt;Syracuse&lt;/a&gt;</td>\n",
" <td>Syracuse</td>\n",
" <td>syracuse</td>\n",
" <td>[30, 40]</td>\n",
" <td>SYR</td>\n",
" <td>Cuse</td>\n",
" <td>BigEastMBB</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>true</td>\n",
" <td>MBB-1</td>\n",
" <td>231</td>\n",
" <td>MIDWEST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/231</td>\n",
" <td>all-conf atlantic-10 atlantic-coast</td>\n",
" <td></td>\n",
" <td>Final</td>\n",
" <td></td>\n",
" <td>Final</td>\n",
" <td></td>\n",
" <td>final</td>\n",
" <td>Final</td>\n",
" <td></td>\n",
" <td>#002453</td>\n",
" <td>51</td>\n",
" <td>25-7</td>\n",
" <td>/sites/default/files/images/logos/schools/d/da...</td>\n",
" <td>&lt;a href='/schools/dayton'&gt;Dayton&lt;/a&gt;</td>\n",
" <td>Dayton</td>\n",
" <td>dayton</td>\n",
" <td>[28, 23]</td>\n",
" <td>DAYTON</td>\n",
" <td>DaytonFlyers</td>\n",
" <td>atlantic10</td>\n",
" <td>marchmadness</td>\n",
" <td>DaytonMBB</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>false</td>\n",
" <td>1688784</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>Scottrade Center, St. Louis, Missouri</td>\n",
" <td>CBS</td>\n",
" <td></td>\n",
" <td>In-Progress</td>\n",
" <td>[1, 2]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>12:15 ET</td>\n",
" <td>1458317700</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'recap', u'file': u'/sites/defaul...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/syracuse-da...</td>\n",
" <td>Scottrade Center</td>\n",
" <td>St. Louis</td>\n",
" <td>St. Louis, Mo.</td>\n",
" <td>Mo.</td>\n",
" <td>[]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>#003C77</td>\n",
" <td>56</td>\n",
" <td>22-11</td>\n",
" <td>/sites/default/files/images/logos/schools/u/un...</td>\n",
" <td>&lt;a href='/schools/unc-asheville'&gt;UNC Asheville...</td>\n",
" <td>UNC Asheville</td>\n",
" <td>unc-asheville</td>\n",
" <td>[26, 30]</td>\n",
" <td>UNC A</td>\n",
" <td>ashevilledogs</td>\n",
" <td>BigSouthSports</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>15</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>208</td>\n",
" <td>SOUTH</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/208</td>\n",
" <td>all-conf top-25 big-east big-south</td>\n",
" <td></td>\n",
" <td>Final</td>\n",
" <td></td>\n",
" <td>Final</td>\n",
" <td></td>\n",
" <td>final</td>\n",
" <td>Final</td>\n",
" <td></td>\n",
" <td>#003366</td>\n",
" <td>86</td>\n",
" <td>29-5</td>\n",
" <td>/sites/default/files/images/logos/schools/v/vi...</td>\n",
" <td>&lt;a href='/schools/villanova'&gt;Villanova&lt;/a&gt;</td>\n",
" <td>Villanova</td>\n",
" <td>villanova</td>\n",
" <td>[40, 46]</td>\n",
" <td>NOVA</td>\n",
" <td>NovaAthletics</td>\n",
" <td>BigEastMBB</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>6</td>\n",
" <td>2</td>\n",
" <td>true</td>\n",
" <td>1688792</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>Barclays Center, Brooklyn, New York</td>\n",
" <td>truTV</td>\n",
" <td></td>\n",
" <td>In-Progress</td>\n",
" <td>[1, 2]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>12:40 ET</td>\n",
" <td>1458319200</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'boxscore', u'file': u'/sites/def...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/unc-ashevil...</td>\n",
" <td>Barclays Center</td>\n",
" <td>Brooklyn</td>\n",
" <td>Brooklyn, N.Y.</td>\n",
" <td>N.Y.</td>\n",
" <td>[]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>#000000</td>\n",
" <td>58</td>\n",
" <td>24-10</td>\n",
" <td>/sites/default/files/images/logos/schools/v/vc...</td>\n",
" <td>&lt;a href='/schools/vcu'&gt;VCU&lt;/a&gt;</td>\n",
" <td>VCU</td>\n",
" <td>vcu</td>\n",
" <td>[36, 22]</td>\n",
" <td>VCU</td>\n",
" <td>VCUathletics</td>\n",
" <td>atlantic10</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>215</td>\n",
" <td>WEST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/215</td>\n",
" <td>all-conf pac-12 atlantic-10</td>\n",
" <td></td>\n",
" <td>2nd Half</td>\n",
" <td></td>\n",
" <td>2nd Half</td>\n",
" <td></td>\n",
" <td>live</td>\n",
" <td>In-Progress</td>\n",
" <td></td>\n",
" <td>#e24912</td>\n",
" <td>52</td>\n",
" <td>19-12</td>\n",
" <td>/sites/default/files/images/logos/schools/o/or...</td>\n",
" <td>&lt;a href='/schools/oregon-st'&gt;Oregon State&lt;/a&gt;</td>\n",
" <td>Oregon State</td>\n",
" <td>oregon-st</td>\n",
" <td>[28, 24]</td>\n",
" <td>ORE ST</td>\n",
" <td>beaverathletics</td>\n",
" <td>pac12</td>\n",
" <td>marchmadness</td>\n",
" <td>OregonStateMBB</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>false</td>\n",
" <td>1688806</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>Chesapeake Energy Arena, Oklahoma City, Oklahoma</td>\n",
" <td>TNT</td>\n",
" <td></td>\n",
" <td>In-Progress</td>\n",
" <td>[1, 2]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>1:30 ET</td>\n",
" <td>1458322200</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td>6:30</td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/vcu-oregon-st</td>\n",
" <td>Chesapeake Energy Arena</td>\n",
" <td>Oklahoma City</td>\n",
" <td>Oklahoma City, Okla.</td>\n",
" <td>Okla.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>#004631</td>\n",
" <td>36</td>\n",
" <td>27-5</td>\n",
" <td>/sites/default/files/images/logos/schools/h/ha...</td>\n",
" <td>&lt;a href='/schools/hawaii'&gt;Hawaii&lt;/a&gt;</td>\n",
" <td>Hawaii</td>\n",
" <td>hawaii</td>\n",
" <td>[36]</td>\n",
" <td>HAWAII</td>\n",
" <td>HawaiiAthletics</td>\n",
" <td>BigWestSports</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>13</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>204</td>\n",
" <td>SOUTH</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/204</td>\n",
" <td>all-conf top-25 pac-12 big-west</td>\n",
" <td></td>\n",
" <td>Halftime</td>\n",
" <td></td>\n",
" <td>Halftime</td>\n",
" <td></td>\n",
" <td>live</td>\n",
" <td>In-Progress</td>\n",
" <td></td>\n",
" <td>#00325b</td>\n",
" <td>30</td>\n",
" <td>23-10</td>\n",
" <td>/sites/default/files/images/logos/schools/c/ca...</td>\n",
" <td>&lt;a href='/schools/california'&gt;California&lt;/a&gt;</td>\n",
" <td>California</td>\n",
" <td>california</td>\n",
" <td>[30]</td>\n",
" <td>CAL</td>\n",
" <td>CalAthletics</td>\n",
" <td>pac12</td>\n",
" <td>marchmadness</td>\n",
" <td>CalMensBBall</td>\n",
" <td>[]</td>\n",
" <td>23</td>\n",
" <td>4</td>\n",
" <td>false</td>\n",
" <td>1688773</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>Spokane Veterans Memorial Arena, Spokane, Wash...</td>\n",
" <td>TBS</td>\n",
" <td></td>\n",
" <td>In-Progress</td>\n",
" <td>[1]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>2:00 ET</td>\n",
" <td>1458324000</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/hawaii-cali...</td>\n",
" <td>Spokane Veterans Memorial Arena</td>\n",
" <td>Spokane</td>\n",
" <td>Spokane, Wash.</td>\n",
" <td>Wash.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>#0047aa</td>\n",
" <td>25</td>\n",
" <td>24-9</td>\n",
" <td>/sites/default/files/images/logos/schools/m/mi...</td>\n",
" <td>&lt;a href='/schools/middle-tenn'&gt;Middle Tenn.&lt;/a&gt;</td>\n",
" <td>Middle Tenn.</td>\n",
" <td>middle-tenn</td>\n",
" <td>[25]</td>\n",
" <td>MIDTEN</td>\n",
" <td>MTAthletics</td>\n",
" <td>The_Sun_Belt</td>\n",
" <td>marchmadness</td>\n",
" <td>MT_MBB</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>15</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>232</td>\n",
" <td>MIDWEST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/232</td>\n",
" <td>all-conf top-25 big-ten conference-usa</td>\n",
" <td></td>\n",
" <td>1st Half</td>\n",
" <td></td>\n",
" <td>1st Half</td>\n",
" <td></td>\n",
" <td>live</td>\n",
" <td>In-Progress</td>\n",
" <td></td>\n",
" <td>#18453B</td>\n",
" <td>22</td>\n",
" <td>29-5</td>\n",
" <td>/sites/default/files/images/logos/schools/m/mi...</td>\n",
" <td>&lt;a href='/schools/michigan-st'&gt;Michigan State&lt;/a&gt;</td>\n",
" <td>Michigan State</td>\n",
" <td>michigan-st</td>\n",
" <td>[22]</td>\n",
" <td>MICHST</td>\n",
" <td>MSU_Athletics</td>\n",
" <td>bigtenconf</td>\n",
" <td>marchmadness</td>\n",
" <td>MSU_Basketball</td>\n",
" <td>[]</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>false</td>\n",
" <td>1688811</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>Scottrade Center, St. Louis, Missouri</td>\n",
" <td>CBS</td>\n",
" <td></td>\n",
" <td>In-Progress</td>\n",
" <td>[1]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>2:50 ET</td>\n",
" <td>1458327000</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td>7:52</td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/middle-tenn...</td>\n",
" <td>Scottrade Center</td>\n",
" <td>St. Louis</td>\n",
" <td>St. Louis, Mo.</td>\n",
" <td>Mo.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>#9e1b34</td>\n",
" <td>6</td>\n",
" <td>21-11</td>\n",
" <td>/sites/default/files/images/logos/schools/t/te...</td>\n",
" <td>&lt;a href='/schools/temple'&gt;Temple&lt;/a&gt;</td>\n",
" <td>Temple</td>\n",
" <td>temple</td>\n",
" <td>[6]</td>\n",
" <td>TEMPLE</td>\n",
" <td>Owlsports_com</td>\n",
" <td>atlantic10</td>\n",
" <td>marchmadness</td>\n",
" <td>TUMBBHoops</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>207</td>\n",
" <td>SOUTH</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/207</td>\n",
" <td>all-conf top-25 big-ten american-athletic</td>\n",
" <td></td>\n",
" <td>1st Half</td>\n",
" <td></td>\n",
" <td>1st Half</td>\n",
" <td></td>\n",
" <td>live</td>\n",
" <td>In-Progress</td>\n",
" <td></td>\n",
" <td>#000000</td>\n",
" <td>5</td>\n",
" <td>21-10</td>\n",
" <td>/sites/default/files/images/logos/schools/i/io...</td>\n",
" <td>&lt;a href='/schools/iowa'&gt;Iowa&lt;/a&gt;</td>\n",
" <td>Iowa</td>\n",
" <td>iowa</td>\n",
" <td>[5]</td>\n",
" <td>IOWA</td>\n",
" <td>TheIowaHawkeyes</td>\n",
" <td>bigtenconf</td>\n",
" <td>marchmadness</td>\n",
" <td>IowaHoops</td>\n",
" <td>[]</td>\n",
" <td>25</td>\n",
" <td>7</td>\n",
" <td>false</td>\n",
" <td>1688801</td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>Barclays Center, Brooklyn, New York</td>\n",
" <td>truTV</td>\n",
" <td></td>\n",
" <td>In-Progress</td>\n",
" <td>[1]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>3:12 ET</td>\n",
" <td>1458328320</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td>16:30</td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/temple-iowa</td>\n",
" <td>Barclays Center</td>\n",
" <td>Brooklyn</td>\n",
" <td>Brooklyn, N.Y.</td>\n",
" <td>N.Y.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>#fdc300</td>\n",
" <td></td>\n",
" <td>24-8</td>\n",
" <td>/sites/default/files/images/logos/schools/b/ba...</td>\n",
" <td>&lt;a href='/schools/bakersfield'&gt;CSU Bakersfield...</td>\n",
" <td>CSU Bakersfield</td>\n",
" <td>bakersfield</td>\n",
" <td>[]</td>\n",
" <td>CSUBAK</td>\n",
" <td>CSUBAthletics</td>\n",
" <td>NaN</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>15</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>216</td>\n",
" <td>WEST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/216</td>\n",
" <td>all-conf top-25 big-12 western-athletic</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#B30838</td>\n",
" <td></td>\n",
" <td>25-7</td>\n",
" <td>/sites/default/files/images/logos/schools/o/ok...</td>\n",
" <td>&lt;a href='/schools/oklahoma'&gt;Oklahoma&lt;/a&gt;</td>\n",
" <td>Oklahoma</td>\n",
" <td>oklahoma</td>\n",
" <td>[]</td>\n",
" <td>OKLA</td>\n",
" <td>SoonerSportscom</td>\n",
" <td>Big12Conference</td>\n",
" <td>marchmadness</td>\n",
" <td>SoonerHoops</td>\n",
" <td>[]</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>false</td>\n",
" <td>1688761</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Chesapeake Energy Arena, Oklahoma City, Oklahoma</td>\n",
" <td>TNT</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>4:00 PM ET</td>\n",
" <td>1458331200</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/bakersfield...</td>\n",
" <td>Chesapeake Energy Arena</td>\n",
" <td>Oklahoma City</td>\n",
" <td>Oklahoma City, Okla.</td>\n",
" <td>Okla.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>#e4b300</td>\n",
" <td></td>\n",
" <td>25-7</td>\n",
" <td>/sites/default/files/images/logos/schools/s/so...</td>\n",
" <td>&lt;a href='/schools/south-dakota-st'&gt;South Dakot...</td>\n",
" <td>South Dakota St.</td>\n",
" <td>south-dakota-st</td>\n",
" <td>[]</td>\n",
" <td>SDAKST</td>\n",
" <td>SDSU_Jacks</td>\n",
" <td>SummitHoops</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>12</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>203</td>\n",
" <td>SOUTH</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/203</td>\n",
" <td>all-conf top-25 big-ten summit</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#e31836</td>\n",
" <td></td>\n",
" <td>25-8</td>\n",
" <td>/sites/default/files/images/logos/schools/m/ma...</td>\n",
" <td>&lt;a href='/schools/maryland'&gt;Maryland&lt;/a&gt;</td>\n",
" <td>Maryland</td>\n",
" <td>maryland</td>\n",
" <td>[]</td>\n",
" <td>MD</td>\n",
" <td>umterps</td>\n",
" <td>accmbb</td>\n",
" <td>marchmadness</td>\n",
" <td>TerrapinHoops</td>\n",
" <td>[]</td>\n",
" <td>18</td>\n",
" <td>5</td>\n",
" <td>false</td>\n",
" <td>1688791</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Spokane Veterans Memorial Arena, Spokane, Wash...</td>\n",
" <td>TBS</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>4:30 PM ET</td>\n",
" <td>1458333000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/south-dakot...</td>\n",
" <td>Spokane Veterans Memorial Arena</td>\n",
" <td>Spokane</td>\n",
" <td>Spokane, Wash.</td>\n",
" <td>Wash.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>#002144</td>\n",
" <td></td>\n",
" <td>21-11</td>\n",
" <td>/sites/default/files/images/logos/schools/p/pi...</td>\n",
" <td>&lt;a href='/schools/pittsburgh'&gt;Pittsburgh&lt;/a&gt;</td>\n",
" <td>Pittsburgh</td>\n",
" <td>pittsburgh</td>\n",
" <td>[]</td>\n",
" <td>PITT</td>\n",
" <td>PittAthletics</td>\n",
" <td>BigEastMBB</td>\n",
" <td>marchmadness</td>\n",
" <td>HailToPittHoops</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>10</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>223</td>\n",
" <td>EAST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/223</td>\n",
" <td>all-conf big-ten atlantic-coast</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#be0f34</td>\n",
" <td></td>\n",
" <td>20-12</td>\n",
" <td>/sites/default/files/images/logos/schools/w/wi...</td>\n",
" <td>&lt;a href='/schools/wisconsin'&gt;Wisconsin&lt;/a&gt;</td>\n",
" <td>Wisconsin</td>\n",
" <td>wisconsin</td>\n",
" <td>[]</td>\n",
" <td>WISC</td>\n",
" <td>UWBadgersdotcom</td>\n",
" <td>bigtenconf</td>\n",
" <td>marchmadness</td>\n",
" <td>BadgerMBB</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" <td>false</td>\n",
" <td>1688786</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Scottrade Center, St. Louis, Missouri</td>\n",
" <td>TNT</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>6:50 PM ET</td>\n",
" <td>1458341400</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/pittsburgh-...</td>\n",
" <td>Scottrade Center</td>\n",
" <td>St. Louis</td>\n",
" <td>St. Louis, Mo.</td>\n",
" <td>Mo.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>#330066</td>\n",
" <td></td>\n",
" <td>27-5</td>\n",
" <td>/sites/default/files/images/logos/schools/s/st...</td>\n",
" <td>&lt;a href='/schools/stephen-f-austin'&gt;Steph. F. ...</td>\n",
" <td>Steph. F. Austin</td>\n",
" <td>stephen-f-austin</td>\n",
" <td>[]</td>\n",
" <td>SFA</td>\n",
" <td>SFA_Athletics</td>\n",
" <td>SouthlandSports</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>222</td>\n",
" <td>EAST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/222</td>\n",
" <td>all-conf top-25 big-12 southland</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#eeb211</td>\n",
" <td></td>\n",
" <td>26-8</td>\n",
" <td>/sites/default/files/images/logos/schools/w/we...</td>\n",
" <td>&lt;a href='/schools/west-virginia'&gt;West Virginia...</td>\n",
" <td>West Virginia</td>\n",
" <td>west-virginia</td>\n",
" <td>[]</td>\n",
" <td>WVU</td>\n",
" <td>WVUSportsBuzz</td>\n",
" <td>Big12Conference</td>\n",
" <td>marchmadness</td>\n",
" <td>WVUhoops</td>\n",
" <td>[]</td>\n",
" <td>8</td>\n",
" <td>3</td>\n",
" <td>false</td>\n",
" <td>1688764</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Barclays Center, Brooklyn, New York</td>\n",
" <td>CBS</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>7:10 PM ET</td>\n",
" <td>1458342600</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/stephen-f-a...</td>\n",
" <td>Barclays Center</td>\n",
" <td>Brooklyn</td>\n",
" <td>Brooklyn, N.Y.</td>\n",
" <td>N.Y.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>#4e0c76</td>\n",
" <td></td>\n",
" <td>23-12</td>\n",
" <td>/sites/default/files/images/logos/schools/g/gr...</td>\n",
" <td>&lt;a href='/schools/green-bay'&gt;Green Bay&lt;/a&gt;</td>\n",
" <td>Green Bay</td>\n",
" <td>green-bay</td>\n",
" <td>[]</td>\n",
" <td>GRNBAY</td>\n",
" <td>GBPhoenix</td>\n",
" <td>HorizonLeague</td>\n",
" <td>marchmadness</td>\n",
" <td>gbphoenixmbb</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>214</td>\n",
" <td>WEST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/214</td>\n",
" <td>all-conf top-25 southeastern horizon</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#500000</td>\n",
" <td></td>\n",
" <td>26-8</td>\n",
" <td>/sites/default/files/images/logos/schools/t/te...</td>\n",
" <td>&lt;a href='/schools/texas-am'&gt;Texas A&amp;M&lt;/a&gt;</td>\n",
" <td>Texas A&amp;M</td>\n",
" <td>texas-am</td>\n",
" <td>[]</td>\n",
" <td>TX A&amp;M</td>\n",
" <td>AggieAthletics</td>\n",
" <td>SECSportsUpdate</td>\n",
" <td>marchmadness</td>\n",
" <td>AggieMensHoops</td>\n",
" <td>[]</td>\n",
" <td>15</td>\n",
" <td>3</td>\n",
" <td>false</td>\n",
" <td>1688823</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Chesapeake Energy Arena, Oklahoma City, Oklahoma</td>\n",
" <td>TBS</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>7:20 PM ET</td>\n",
" <td>1458343200</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/green-bay-t...</td>\n",
" <td>Chesapeake Energy Arena</td>\n",
" <td>Oklahoma City</td>\n",
" <td>Oklahoma City, Okla.</td>\n",
" <td>Okla.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>#4f318b</td>\n",
" <td></td>\n",
" <td>15-19</td>\n",
" <td>/sites/default/files/images/logos/schools/h/ho...</td>\n",
" <td>&lt;a href='/schools/holy-cross'&gt;Holy Cross&lt;/a&gt;</td>\n",
" <td>Holy Cross</td>\n",
" <td>holy-cross</td>\n",
" <td>[]</td>\n",
" <td>HOLYCR</td>\n",
" <td>GoHolyCross</td>\n",
" <td>PL_MBB</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>16</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>209</td>\n",
" <td>WEST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/209</td>\n",
" <td>all-conf top-25 pac-12 patriot</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#004F27</td>\n",
" <td></td>\n",
" <td>28-6</td>\n",
" <td>/sites/default/files/images/logos/schools/o/or...</td>\n",
" <td>&lt;a href='/schools/oregon'&gt;Oregon&lt;/a&gt;</td>\n",
" <td>Oregon</td>\n",
" <td>oregon</td>\n",
" <td>[]</td>\n",
" <td>OREGN</td>\n",
" <td>GoDucks</td>\n",
" <td>pac12</td>\n",
" <td>marchmadness</td>\n",
" <td>OregonMBB</td>\n",
" <td>[]</td>\n",
" <td>5</td>\n",
" <td>1</td>\n",
" <td>false</td>\n",
" <td>1688782</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Spokane Veterans Memorial Arena, Spokane, Wash...</td>\n",
" <td>truTV</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>7:27 PM ET</td>\n",
" <td>1458343620</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/holy-cross-...</td>\n",
" <td>Spokane Veterans Memorial Arena</td>\n",
" <td>Spokane</td>\n",
" <td>Spokane, Wash.</td>\n",
" <td>Wash.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>#5f3c99</td>\n",
" <td></td>\n",
" <td>26-8</td>\n",
" <td>/sites/default/files/images/logos/schools/w/we...</td>\n",
" <td>&lt;a href='/schools/weber-st'&gt;Weber State&lt;/a&gt;</td>\n",
" <td>Weber State</td>\n",
" <td>weber-st</td>\n",
" <td>[]</td>\n",
" <td>WEB ST</td>\n",
" <td>weberstate</td>\n",
" <td>BigSkyConf</td>\n",
" <td>marchmadness</td>\n",
" <td>WeberStateMBB</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>15</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>224</td>\n",
" <td>EAST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/224</td>\n",
" <td>all-conf top-25 big-east big-sky</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#002144</td>\n",
" <td></td>\n",
" <td>27-5</td>\n",
" <td>/sites/default/files/images/logos/schools/x/xa...</td>\n",
" <td>&lt;a href='/schools/xavier'&gt;Xavier&lt;/a&gt;</td>\n",
" <td>Xavier</td>\n",
" <td>xavier</td>\n",
" <td>[]</td>\n",
" <td>XAVIER</td>\n",
" <td>XUAthletics</td>\n",
" <td>atlantic10</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>9</td>\n",
" <td>2</td>\n",
" <td>false</td>\n",
" <td>1688802</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Scottrade Center, St. Louis, Missouri</td>\n",
" <td>TNT</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>9:20 PM ET</td>\n",
" <td>1458350400</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/weber-st-xa...</td>\n",
" <td>Scottrade Center</td>\n",
" <td>St. Louis</td>\n",
" <td>St. Louis, Mo.</td>\n",
" <td>Mo.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>#660000</td>\n",
" <td></td>\n",
" <td>20-14</td>\n",
" <td>/sites/default/files/images/logos/schools/v/vi...</td>\n",
" <td>&lt;a href='/schools/virginia-tech'&gt;Virginia Tech...</td>\n",
" <td>Virginia Tech</td>\n",
" <td>virginia-tech</td>\n",
" <td>[]</td>\n",
" <td>VATECH</td>\n",
" <td>hokiesports</td>\n",
" <td>accmbb</td>\n",
" <td>marchmadness</td>\n",
" <td>VT_MBBall</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>false</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>all-conf west-coast atlantic-coast</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#002255</td>\n",
" <td></td>\n",
" <td>24-10</td>\n",
" <td>/sites/default/files/images/logos/schools/b/by...</td>\n",
" <td>&lt;a href='/schools/byu'&gt;BYU&lt;/a&gt;</td>\n",
" <td>BYU</td>\n",
" <td>byu</td>\n",
" <td>[]</td>\n",
" <td>BYU</td>\n",
" <td>BYUcougars</td>\n",
" <td>WCCsports</td>\n",
" <td>marchmadness</td>\n",
" <td>byubasketball</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>false</td>\n",
" <td>1884721</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Marriott Center, Provo, UT</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>NaN</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>9:30 PM ET</td>\n",
" <td>1458351000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/virginia-te...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>#002147</td>\n",
" <td></td>\n",
" <td>23-12</td>\n",
" <td>/sites/default/files/images/logos/schools/m/mi...</td>\n",
" <td>&lt;a href='/schools/michigan'&gt;Michigan&lt;/a&gt;</td>\n",
" <td>Michigan</td>\n",
" <td>michigan</td>\n",
" <td>[]</td>\n",
" <td>MICH</td>\n",
" <td>NaN</td>\n",
" <td>bigtenconf</td>\n",
" <td>marchmadness</td>\n",
" <td>umichbball</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>11</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>221</td>\n",
" <td>EAST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/221</td>\n",
" <td>all-conf atlantic-coast big-ten</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#002b5c</td>\n",
" <td></td>\n",
" <td>21-11</td>\n",
" <td>/sites/default/files/images/logos/schools/n/no...</td>\n",
" <td>&lt;a href='/schools/notre-dame'&gt;Notre Dame&lt;/a&gt;</td>\n",
" <td>Notre Dame</td>\n",
" <td>notre-dame</td>\n",
" <td>[]</td>\n",
" <td>N DAME</td>\n",
" <td>FightingIrish</td>\n",
" <td>BigEastMBB</td>\n",
" <td>marchmadness</td>\n",
" <td>NDmbb</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>false</td>\n",
" <td>1688826</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Barclays Center, Brooklyn, New York</td>\n",
" <td>CBS</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>9:40 PM ET</td>\n",
" <td>1458351600</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/michigan-no...</td>\n",
" <td>Barclays Center</td>\n",
" <td>Brooklyn</td>\n",
" <td>Brooklyn, N.Y.</td>\n",
" <td>N.Y.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>#4a3394</td>\n",
" <td></td>\n",
" <td>22-12</td>\n",
" <td>/sites/default/files/images/logos/schools/u/un...</td>\n",
" <td>&lt;a href='/schools/uni'&gt;UNI&lt;/a&gt;</td>\n",
" <td>UNI</td>\n",
" <td>uni</td>\n",
" <td>[]</td>\n",
" <td>N IOWA</td>\n",
" <td>UNIAthletics</td>\n",
" <td>ValleyHoops</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>11</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>213</td>\n",
" <td>WEST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/213</td>\n",
" <td>all-conf big-12 missouri-valley</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#CC5500</td>\n",
" <td></td>\n",
" <td>20-12</td>\n",
" <td>/sites/default/files/images/logos/schools/t/te...</td>\n",
" <td>&lt;a href='/schools/texas'&gt;Texas&lt;/a&gt;</td>\n",
" <td>Texas</td>\n",
" <td>texas</td>\n",
" <td>[]</td>\n",
" <td>TEXAS</td>\n",
" <td>TexasSports</td>\n",
" <td>Big12Conference</td>\n",
" <td>marchmadness</td>\n",
" <td>TexasMBB</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>false</td>\n",
" <td>1688822</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Chesapeake Energy Arena, Oklahoma City, Oklahoma</td>\n",
" <td>TBS</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>9:50 PM ET</td>\n",
" <td>1458352200</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/uni-texas</td>\n",
" <td>Chesapeake Energy Arena</td>\n",
" <td>Oklahoma City</td>\n",
" <td>Oklahoma City, Okla.</td>\n",
" <td>Okla.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>#cc092f</td>\n",
" <td></td>\n",
" <td>22-10</td>\n",
" <td>/sites/default/files/images/logos/schools/c/ci...</td>\n",
" <td>&lt;a href='/schools/cincinnati'&gt;Cincinnati&lt;/a&gt;</td>\n",
" <td>Cincinnati</td>\n",
" <td>cincinnati</td>\n",
" <td>[]</td>\n",
" <td>CINCY</td>\n",
" <td>GoBEARCATS</td>\n",
" <td>BigEastMBB</td>\n",
" <td>marchmadness</td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>9</td>\n",
" <td>false</td>\n",
" <td>MBB-1</td>\n",
" <td>210</td>\n",
" <td>WEST</td>\n",
" <td>First Round</td>\n",
" <td></td>\n",
" <td>http://www.ncaa.com/march-madness-live/game/210</td>\n",
" <td>all-conf atlantic-10 american-athletic</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>pre</td>\n",
" <td>NaN</td>\n",
" <td></td>\n",
" <td>#9e1b32</td>\n",
" <td></td>\n",
" <td>27-7</td>\n",
" <td>/sites/default/files/images/logos/schools/s/sa...</td>\n",
" <td>&lt;a href='/schools/saint-josephs'&gt;Saint Joseph'...</td>\n",
" <td>Saint Joseph's</td>\n",
" <td>saint-josephs</td>\n",
" <td>[]</td>\n",
" <td>STJOES</td>\n",
" <td>SJUHawks</td>\n",
" <td>atlantic10</td>\n",
" <td>marchmadness</td>\n",
" <td>SJUHawks_MBB</td>\n",
" <td>[]</td>\n",
" <td>0</td>\n",
" <td>8</td>\n",
" <td>false</td>\n",
" <td>1688779</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>Spokane Veterans Memorial Arena, Spokane, Wash...</td>\n",
" <td>truTV</td>\n",
" <td></td>\n",
" <td>NaN</td>\n",
" <td>[]</td>\n",
" <td>2015</td>\n",
" <td>2016-03-18</td>\n",
" <td>March 18</td>\n",
" <td>9:57 PM ET</td>\n",
" <td>1458352620</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>/sites/default/files/data//game/basketball-men...</td>\n",
" <td>[[{u'type': u'preview', u'file': u'/sites/defa...</td>\n",
" <td></td>\n",
" <td>1</td>\n",
" <td>/game/basketball-men/d1/2016/03/18/cincinnati-...</td>\n",
" <td>Spokane Veterans Memorial Arena</td>\n",
" <td>Spokane</td>\n",
" <td>Spokane, Wash.</td>\n",
" <td>Wash.</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" away.color away.currentScore away.description \\\n",
"0 #ff5113 70 19-13 \n",
"1 #003C77 56 22-11 \n",
"2 #000000 58 24-10 \n",
"3 #004631 36 27-5 \n",
"4 #0047aa 25 24-9 \n",
"5 #9e1b34 6 21-11 \n",
"6 #fdc300 24-8 \n",
"7 #e4b300 25-7 \n",
"8 #002144 21-11 \n",
"9 #330066 27-5 \n",
"10 #4e0c76 23-12 \n",
"11 #4f318b 15-19 \n",
"12 #5f3c99 26-8 \n",
"13 #660000 20-14 \n",
"14 #002147 23-12 \n",
"15 #4a3394 22-12 \n",
"16 #cc092f 22-10 \n",
"\n",
" away.iconURL \\\n",
"0 /sites/default/files/images/logos/schools/s/sy... \n",
"1 /sites/default/files/images/logos/schools/u/un... \n",
"2 /sites/default/files/images/logos/schools/v/vc... \n",
"3 /sites/default/files/images/logos/schools/h/ha... \n",
"4 /sites/default/files/images/logos/schools/m/mi... \n",
"5 /sites/default/files/images/logos/schools/t/te... \n",
"6 /sites/default/files/images/logos/schools/b/ba... \n",
"7 /sites/default/files/images/logos/schools/s/so... \n",
"8 /sites/default/files/images/logos/schools/p/pi... \n",
"9 /sites/default/files/images/logos/schools/s/st... \n",
"10 /sites/default/files/images/logos/schools/g/gr... \n",
"11 /sites/default/files/images/logos/schools/h/ho... \n",
"12 /sites/default/files/images/logos/schools/w/we... \n",
"13 /sites/default/files/images/logos/schools/v/vi... \n",
"14 /sites/default/files/images/logos/schools/m/mi... \n",
"15 /sites/default/files/images/logos/schools/u/un... \n",
"16 /sites/default/files/images/logos/schools/c/ci... \n",
"\n",
" away.name away.nameRaw \\\n",
"0 <a href='/schools/syracuse'>Syracuse</a> Syracuse \n",
"1 <a href='/schools/unc-asheville'>UNC Asheville... UNC Asheville \n",
"2 <a href='/schools/vcu'>VCU</a> VCU \n",
"3 <a href='/schools/hawaii'>Hawaii</a> Hawaii \n",
"4 <a href='/schools/middle-tenn'>Middle Tenn.</a> Middle Tenn. \n",
"5 <a href='/schools/temple'>Temple</a> Temple \n",
"6 <a href='/schools/bakersfield'>CSU Bakersfield... CSU Bakersfield \n",
"7 <a href='/schools/south-dakota-st'>South Dakot... South Dakota St. \n",
"8 <a href='/schools/pittsburgh'>Pittsburgh</a> Pittsburgh \n",
"9 <a href='/schools/stephen-f-austin'>Steph. F. ... Steph. F. Austin \n",
"10 <a href='/schools/green-bay'>Green Bay</a> Green Bay \n",
"11 <a href='/schools/holy-cross'>Holy Cross</a> Holy Cross \n",
"12 <a href='/schools/weber-st'>Weber State</a> Weber State \n",
"13 <a href='/schools/virginia-tech'>Virginia Tech... Virginia Tech \n",
"14 <a href='/schools/michigan'>Michigan</a> Michigan \n",
"15 <a href='/schools/uni'>UNI</a> UNI \n",
"16 <a href='/schools/cincinnati'>Cincinnati</a> Cincinnati \n",
"\n",
" away.nameSeo away.scoreBreakdown away.shortname \\\n",
"0 syracuse [30, 40] SYR \n",
"1 unc-asheville [26, 30] UNC A \n",
"2 vcu [36, 22] VCU \n",
"3 hawaii [36] HAWAII \n",
"4 middle-tenn [25] MIDTEN \n",
"5 temple [6] TEMPLE \n",
"6 bakersfield [] CSUBAK \n",
"7 south-dakota-st [] SDAKST \n",
"8 pittsburgh [] PITT \n",
"9 stephen-f-austin [] SFA \n",
"10 green-bay [] GRNBAY \n",
"11 holy-cross [] HOLYCR \n",
"12 weber-st [] WEB ST \n",
"13 virginia-tech [] VATECH \n",
"14 michigan [] MICH \n",
"15 uni [] N IOWA \n",
"16 cincinnati [] CINCY \n",
"\n",
" away.social.twitter.accounts.athleticDept \\\n",
"0 Cuse \n",
"1 ashevilledogs \n",
"2 VCUathletics \n",
"3 HawaiiAthletics \n",
"4 MTAthletics \n",
"5 Owlsports_com \n",
"6 CSUBAthletics \n",
"7 SDSU_Jacks \n",
"8 PittAthletics \n",
"9 SFA_Athletics \n",
"10 GBPhoenix \n",
"11 GoHolyCross \n",
"12 weberstate \n",
"13 hokiesports \n",
"14 NaN \n",
"15 UNIAthletics \n",
"16 GoBEARCATS \n",
"\n",
" away.social.twitter.accounts.conference away.social.twitter.accounts.ncaa \\\n",
"0 BigEastMBB marchmadness \n",
"1 BigSouthSports marchmadness \n",
"2 atlantic10 marchmadness \n",
"3 BigWestSports marchmadness \n",
"4 The_Sun_Belt marchmadness \n",
"5 atlantic10 marchmadness \n",
"6 NaN marchmadness \n",
"7 SummitHoops marchmadness \n",
"8 BigEastMBB marchmadness \n",
"9 SouthlandSports marchmadness \n",
"10 HorizonLeague marchmadness \n",
"11 PL_MBB marchmadness \n",
"12 BigSkyConf marchmadness \n",
"13 accmbb marchmadness \n",
"14 bigtenconf marchmadness \n",
"15 ValleyHoops marchmadness \n",
"16 BigEastMBB marchmadness \n",
"\n",
" away.social.twitter.accounts.sport away.social.twitter.keywords \\\n",
"0 NaN [] \n",
"1 NaN [] \n",
"2 NaN [] \n",
"3 NaN [] \n",
"4 MT_MBB [] \n",
"5 TUMBBHoops [] \n",
"6 NaN [] \n",
"7 NaN [] \n",
"8 HailToPittHoops [] \n",
"9 NaN [] \n",
"10 gbphoenixmbb [] \n",
"11 NaN [] \n",
"12 WeberStateMBB [] \n",
"13 VT_MBBall [] \n",
"14 umichbball [] \n",
"15 NaN [] \n",
"16 NaN [] \n",
"\n",
" away.teamRank away.teamSeed away.winner bracket bracketId bracketRegion \\\n",
"0 0 10 true MBB-1 231 MIDWEST \n",
"1 0 15 false MBB-1 208 SOUTH \n",
"2 0 10 false MBB-1 215 WEST \n",
"3 0 13 false MBB-1 204 SOUTH \n",
"4 0 15 false MBB-1 232 MIDWEST \n",
"5 0 10 false MBB-1 207 SOUTH \n",
"6 0 15 false MBB-1 216 WEST \n",
"7 0 12 false MBB-1 203 SOUTH \n",
"8 0 10 false MBB-1 223 EAST \n",
"9 0 14 false MBB-1 222 EAST \n",
"10 0 14 false MBB-1 214 WEST \n",
"11 0 16 false MBB-1 209 WEST \n",
"12 0 15 false MBB-1 224 EAST \n",
"13 0 NaN false NaN NaN NaN \n",
"14 0 11 false MBB-1 221 EAST \n",
"15 0 11 false MBB-1 213 WEST \n",
"16 0 9 false MBB-1 210 WEST \n",
"\n",
" bracketRound champInfo.radioUrl \\\n",
"0 First Round \n",
"1 First Round \n",
"2 First Round \n",
"3 First Round \n",
"4 First Round \n",
"5 First Round \n",
"6 First Round \n",
"7 First Round \n",
"8 First Round \n",
"9 First Round \n",
"10 First Round \n",
"11 First Round \n",
"12 First Round \n",
"13 NaN NaN \n",
"14 First Round \n",
"15 First Round \n",
"16 First Round \n",
"\n",
" champInfo.watchLiveUrl \\\n",
"0 http://www.ncaa.com/march-madness-live/game/231 \n",
"1 http://www.ncaa.com/march-madness-live/game/208 \n",
"2 http://www.ncaa.com/march-madness-live/game/215 \n",
"3 http://www.ncaa.com/march-madness-live/game/204 \n",
"4 http://www.ncaa.com/march-madness-live/game/232 \n",
"5 http://www.ncaa.com/march-madness-live/game/207 \n",
"6 http://www.ncaa.com/march-madness-live/game/216 \n",
"7 http://www.ncaa.com/march-madness-live/game/203 \n",
"8 http://www.ncaa.com/march-madness-live/game/223 \n",
"9 http://www.ncaa.com/march-madness-live/game/222 \n",
"10 http://www.ncaa.com/march-madness-live/game/214 \n",
"11 http://www.ncaa.com/march-madness-live/game/209 \n",
"12 http://www.ncaa.com/march-madness-live/game/224 \n",
"13 NaN \n",
"14 http://www.ncaa.com/march-madness-live/game/221 \n",
"15 http://www.ncaa.com/march-madness-live/game/213 \n",
"16 http://www.ncaa.com/march-madness-live/game/210 \n",
"\n",
" conference contestName currentPeriod \\\n",
"0 all-conf atlantic-10 atlantic-coast Final \n",
"1 all-conf top-25 big-east big-south Final \n",
"2 all-conf pac-12 atlantic-10 2nd Half \n",
"3 all-conf top-25 pac-12 big-west Halftime \n",
"4 all-conf top-25 big-ten conference-usa 1st Half \n",
"5 all-conf top-25 big-ten american-athletic 1st Half \n",
"6 all-conf top-25 big-12 western-athletic \n",
"7 all-conf top-25 big-ten summit \n",
"8 all-conf big-ten atlantic-coast \n",
"9 all-conf top-25 big-12 southland \n",
"10 all-conf top-25 southeastern horizon \n",
"11 all-conf top-25 pac-12 patriot \n",
"12 all-conf top-25 big-east big-sky \n",
"13 all-conf west-coast atlantic-coast \n",
"14 all-conf atlantic-coast big-ten \n",
"15 all-conf big-12 missouri-valley \n",
"16 all-conf atlantic-10 american-athletic \n",
"\n",
" downToGo finalMessage gameCenterUrl gameState gameStatus highlightsUrl \\\n",
"0 Final final Final \n",
"1 Final final Final \n",
"2 2nd Half live In-Progress \n",
"3 Halftime live In-Progress \n",
"4 1st Half live In-Progress \n",
"5 1st Half live In-Progress \n",
"6 NaN NaN pre NaN \n",
"7 NaN NaN pre NaN \n",
"8 NaN NaN pre NaN \n",
"9 NaN NaN pre NaN \n",
"10 NaN NaN pre NaN \n",
"11 NaN NaN pre NaN \n",
"12 NaN NaN pre NaN \n",
"13 NaN NaN pre NaN \n",
"14 NaN NaN pre NaN \n",
"15 NaN NaN pre NaN \n",
"16 NaN NaN pre NaN \n",
"\n",
" home.color home.currentScore home.description \\\n",
"0 #002453 51 25-7 \n",
"1 #003366 86 29-5 \n",
"2 #e24912 52 19-12 \n",
"3 #00325b 30 23-10 \n",
"4 #18453B 22 29-5 \n",
"5 #000000 5 21-10 \n",
"6 #B30838 25-7 \n",
"7 #e31836 25-8 \n",
"8 #be0f34 20-12 \n",
"9 #eeb211 26-8 \n",
"10 #500000 26-8 \n",
"11 #004F27 28-6 \n",
"12 #002144 27-5 \n",
"13 #002255 24-10 \n",
"14 #002b5c 21-11 \n",
"15 #CC5500 20-12 \n",
"16 #9e1b32 27-7 \n",
"\n",
" home.iconURL \\\n",
"0 /sites/default/files/images/logos/schools/d/da... \n",
"1 /sites/default/files/images/logos/schools/v/vi... \n",
"2 /sites/default/files/images/logos/schools/o/or... \n",
"3 /sites/default/files/images/logos/schools/c/ca... \n",
"4 /sites/default/files/images/logos/schools/m/mi... \n",
"5 /sites/default/files/images/logos/schools/i/io... \n",
"6 /sites/default/files/images/logos/schools/o/ok... \n",
"7 /sites/default/files/images/logos/schools/m/ma... \n",
"8 /sites/default/files/images/logos/schools/w/wi... \n",
"9 /sites/default/files/images/logos/schools/w/we... \n",
"10 /sites/default/files/images/logos/schools/t/te... \n",
"11 /sites/default/files/images/logos/schools/o/or... \n",
"12 /sites/default/files/images/logos/schools/x/xa... \n",
"13 /sites/default/files/images/logos/schools/b/by... \n",
"14 /sites/default/files/images/logos/schools/n/no... \n",
"15 /sites/default/files/images/logos/schools/t/te... \n",
"16 /sites/default/files/images/logos/schools/s/sa... \n",
"\n",
" home.name home.nameRaw \\\n",
"0 <a href='/schools/dayton'>Dayton</a> Dayton \n",
"1 <a href='/schools/villanova'>Villanova</a> Villanova \n",
"2 <a href='/schools/oregon-st'>Oregon State</a> Oregon State \n",
"3 <a href='/schools/california'>California</a> California \n",
"4 <a href='/schools/michigan-st'>Michigan State</a> Michigan State \n",
"5 <a href='/schools/iowa'>Iowa</a> Iowa \n",
"6 <a href='/schools/oklahoma'>Oklahoma</a> Oklahoma \n",
"7 <a href='/schools/maryland'>Maryland</a> Maryland \n",
"8 <a href='/schools/wisconsin'>Wisconsin</a> Wisconsin \n",
"9 <a href='/schools/west-virginia'>West Virginia... West Virginia \n",
"10 <a href='/schools/texas-am'>Texas A&M</a> Texas A&M \n",
"11 <a href='/schools/oregon'>Oregon</a> Oregon \n",
"12 <a href='/schools/xavier'>Xavier</a> Xavier \n",
"13 <a href='/schools/byu'>BYU</a> BYU \n",
"14 <a href='/schools/notre-dame'>Notre Dame</a> Notre Dame \n",
"15 <a href='/schools/texas'>Texas</a> Texas \n",
"16 <a href='/schools/saint-josephs'>Saint Joseph'... Saint Joseph's \n",
"\n",
" home.nameSeo home.scoreBreakdown home.shortname \\\n",
"0 dayton [28, 23] DAYTON \n",
"1 villanova [40, 46] NOVA \n",
"2 oregon-st [28, 24] ORE ST \n",
"3 california [30] CAL \n",
"4 michigan-st [22] MICHST \n",
"5 iowa [5] IOWA \n",
"6 oklahoma [] OKLA \n",
"7 maryland [] MD \n",
"8 wisconsin [] WISC \n",
"9 west-virginia [] WVU \n",
"10 texas-am [] TX A&M \n",
"11 oregon [] OREGN \n",
"12 xavier [] XAVIER \n",
"13 byu [] BYU \n",
"14 notre-dame [] N DAME \n",
"15 texas [] TEXAS \n",
"16 saint-josephs [] STJOES \n",
"\n",
" home.social.twitter.accounts.athleticDept \\\n",
"0 DaytonFlyers \n",
"1 NovaAthletics \n",
"2 beaverathletics \n",
"3 CalAthletics \n",
"4 MSU_Athletics \n",
"5 TheIowaHawkeyes \n",
"6 SoonerSportscom \n",
"7 umterps \n",
"8 UWBadgersdotcom \n",
"9 WVUSportsBuzz \n",
"10 AggieAthletics \n",
"11 GoDucks \n",
"12 XUAthletics \n",
"13 BYUcougars \n",
"14 FightingIrish \n",
"15 TexasSports \n",
"16 SJUHawks \n",
"\n",
" home.social.twitter.accounts.conference home.social.twitter.accounts.ncaa \\\n",
"0 atlantic10 marchmadness \n",
"1 BigEastMBB marchmadness \n",
"2 pac12 marchmadness \n",
"3 pac12 marchmadness \n",
"4 bigtenconf marchmadness \n",
"5 bigtenconf marchmadness \n",
"6 Big12Conference marchmadness \n",
"7 accmbb marchmadness \n",
"8 bigtenconf marchmadness \n",
"9 Big12Conference marchmadness \n",
"10 SECSportsUpdate marchmadness \n",
"11 pac12 marchmadness \n",
"12 atlantic10 marchmadness \n",
"13 WCCsports marchmadness \n",
"14 BigEastMBB marchmadness \n",
"15 Big12Conference marchmadness \n",
"16 atlantic10 marchmadness \n",
"\n",
" home.social.twitter.accounts.sport home.social.twitter.keywords \\\n",
"0 DaytonMBB [] \n",
"1 NaN [] \n",
"2 OregonStateMBB [] \n",
"3 CalMensBBall [] \n",
"4 MSU_Basketball [] \n",
"5 IowaHoops [] \n",
"6 SoonerHoops [] \n",
"7 TerrapinHoops [] \n",
"8 BadgerMBB [] \n",
"9 WVUhoops [] \n",
"10 AggieMensHoops [] \n",
"11 OregonMBB [] \n",
"12 NaN [] \n",
"13 byubasketball [] \n",
"14 NDmbb [] \n",
"15 TexasMBB [] \n",
"16 SJUHawks_MBB [] \n",
"\n",
" home.teamRank home.teamSeed home.winner id isLiveEnabled \\\n",
"0 0 7 false 1688784 0 \n",
"1 6 2 true 1688792 0 \n",
"2 0 7 false 1688806 0 \n",
"3 23 4 false 1688773 0 \n",
"4 2 2 false 1688811 0 \n",
"5 25 7 false 1688801 0 \n",
"6 7 2 false 1688761 1 \n",
"7 18 5 false 1688791 1 \n",
"8 0 7 false 1688786 1 \n",
"9 8 3 false 1688764 1 \n",
"10 15 3 false 1688823 1 \n",
"11 5 1 false 1688782 1 \n",
"12 9 2 false 1688802 1 \n",
"13 0 NaN false 1884721 NaN \n",
"14 0 6 false 1688826 1 \n",
"15 0 6 false 1688822 1 \n",
"16 0 8 false 1688779 1 \n",
"\n",
" liveAudioUrl location network \\\n",
"0 Scottrade Center, St. Louis, Missouri CBS \n",
"1 Barclays Center, Brooklyn, New York truTV \n",
"2 Chesapeake Energy Arena, Oklahoma City, Oklahoma TNT \n",
"3 Spokane Veterans Memorial Arena, Spokane, Wash... TBS \n",
"4 Scottrade Center, St. Louis, Missouri CBS \n",
"5 Barclays Center, Brooklyn, New York truTV \n",
"6 NaN Chesapeake Energy Arena, Oklahoma City, Oklahoma TNT \n",
"7 NaN Spokane Veterans Memorial Arena, Spokane, Wash... TBS \n",
"8 NaN Scottrade Center, St. Louis, Missouri TNT \n",
"9 NaN Barclays Center, Brooklyn, New York CBS \n",
"10 NaN Chesapeake Energy Arena, Oklahoma City, Oklahoma TBS \n",
"11 NaN Spokane Veterans Memorial Arena, Spokane, Wash... truTV \n",
"12 NaN Scottrade Center, St. Louis, Missouri TNT \n",
"13 NaN Marriott Center, Provo, UT NaN \n",
"14 NaN Barclays Center, Brooklyn, New York CBS \n",
"15 NaN Chesapeake Energy Arena, Oklahoma City, Oklahoma TBS \n",
"16 NaN Spokane Veterans Memorial Arena, Spokane, Wash... truTV \n",
"\n",
" network_logo periodStatus scoreBreakdown season_year startDate \\\n",
"0 In-Progress [1, 2] 2015 2016-03-18 \n",
"1 In-Progress [1, 2] 2015 2016-03-18 \n",
"2 In-Progress [1, 2] 2015 2016-03-18 \n",
"3 In-Progress [1] 2015 2016-03-18 \n",
"4 In-Progress [1] 2015 2016-03-18 \n",
"5 In-Progress [1] 2015 2016-03-18 \n",
"6 NaN [] 2015 2016-03-18 \n",
"7 NaN [] 2015 2016-03-18 \n",
"8 NaN [] 2015 2016-03-18 \n",
"9 NaN [] 2015 2016-03-18 \n",
"10 NaN [] 2015 2016-03-18 \n",
"11 NaN [] 2015 2016-03-18 \n",
"12 NaN [] 2015 2016-03-18 \n",
"13 NaN [] NaN 2016-03-18 \n",
"14 NaN [] 2015 2016-03-18 \n",
"15 NaN [] 2015 2016-03-18 \n",
"16 NaN [] 2015 2016-03-18 \n",
"\n",
" startDateDisplay startTime startTimeEpoch status.distance status.down \\\n",
"0 March 18 12:15 ET 1458317700 NaN NaN \n",
"1 March 18 12:40 ET 1458319200 NaN NaN \n",
"2 March 18 1:30 ET 1458322200 \n",
"3 March 18 2:00 ET 1458324000 \n",
"4 March 18 2:50 ET 1458327000 \n",
"5 March 18 3:12 ET 1458328320 \n",
"6 March 18 4:00 PM ET 1458331200 NaN NaN \n",
"7 March 18 4:30 PM ET 1458333000 NaN NaN \n",
"8 March 18 6:50 PM ET 1458341400 NaN NaN \n",
"9 March 18 7:10 PM ET 1458342600 NaN NaN \n",
"10 March 18 7:20 PM ET 1458343200 NaN NaN \n",
"11 March 18 7:27 PM ET 1458343620 NaN NaN \n",
"12 March 18 9:20 PM ET 1458350400 NaN NaN \n",
"13 March 18 9:30 PM ET 1458351000 NaN NaN \n",
"14 March 18 9:40 PM ET 1458351600 NaN NaN \n",
"15 March 18 9:50 PM ET 1458352200 NaN NaN \n",
"16 March 18 9:57 PM ET 1458352620 NaN NaN \n",
"\n",
" status.possession status.yardline \\\n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 \n",
"3 \n",
"4 \n",
"5 \n",
"6 NaN NaN \n",
"7 NaN NaN \n",
"8 NaN NaN \n",
"9 NaN NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 NaN NaN \n",
"13 NaN NaN \n",
"14 NaN NaN \n",
"15 NaN NaN \n",
"16 NaN NaN \n",
"\n",
" tabs \\\n",
"0 /sites/default/files/data//game/basketball-men... \n",
"1 /sites/default/files/data//game/basketball-men... \n",
"2 /sites/default/files/data//game/basketball-men... \n",
"3 /sites/default/files/data//game/basketball-men... \n",
"4 /sites/default/files/data//game/basketball-men... \n",
"5 /sites/default/files/data//game/basketball-men... \n",
"6 /sites/default/files/data//game/basketball-men... \n",
"7 /sites/default/files/data//game/basketball-men... \n",
"8 /sites/default/files/data//game/basketball-men... \n",
"9 /sites/default/files/data//game/basketball-men... \n",
"10 /sites/default/files/data//game/basketball-men... \n",
"11 /sites/default/files/data//game/basketball-men... \n",
"12 /sites/default/files/data//game/basketball-men... \n",
"13 /sites/default/files/data//game/basketball-men... \n",
"14 /sites/default/files/data//game/basketball-men... \n",
"15 /sites/default/files/data//game/basketball-men... \n",
"16 /sites/default/files/data//game/basketball-men... \n",
"\n",
" tabsArray timeclock tournament_id \\\n",
"0 [[{u'type': u'recap', u'file': u'/sites/defaul... 1 \n",
"1 [[{u'type': u'boxscore', u'file': u'/sites/def... 1 \n",
"2 [[{u'type': u'preview', u'file': u'/sites/defa... 6:30 1 \n",
"3 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"4 [[{u'type': u'preview', u'file': u'/sites/defa... 7:52 1 \n",
"5 [[{u'type': u'preview', u'file': u'/sites/defa... 16:30 1 \n",
"6 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"7 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"8 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"9 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"10 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"11 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"12 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"13 [[{u'type': u'preview', u'file': u'/sites/defa... NaN \n",
"14 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"15 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"16 [[{u'type': u'preview', u'file': u'/sites/defa... 1 \n",
"\n",
" url \\\n",
"0 /game/basketball-men/d1/2016/03/18/syracuse-da... \n",
"1 /game/basketball-men/d1/2016/03/18/unc-ashevil... \n",
"2 /game/basketball-men/d1/2016/03/18/vcu-oregon-st \n",
"3 /game/basketball-men/d1/2016/03/18/hawaii-cali... \n",
"4 /game/basketball-men/d1/2016/03/18/middle-tenn... \n",
"5 /game/basketball-men/d1/2016/03/18/temple-iowa \n",
"6 /game/basketball-men/d1/2016/03/18/bakersfield... \n",
"7 /game/basketball-men/d1/2016/03/18/south-dakot... \n",
"8 /game/basketball-men/d1/2016/03/18/pittsburgh-... \n",
"9 /game/basketball-men/d1/2016/03/18/stephen-f-a... \n",
"10 /game/basketball-men/d1/2016/03/18/green-bay-t... \n",
"11 /game/basketball-men/d1/2016/03/18/holy-cross-... \n",
"12 /game/basketball-men/d1/2016/03/18/weber-st-xa... \n",
"13 /game/basketball-men/d1/2016/03/18/virginia-te... \n",
"14 /game/basketball-men/d1/2016/03/18/michigan-no... \n",
"15 /game/basketball-men/d1/2016/03/18/uni-texas \n",
"16 /game/basketball-men/d1/2016/03/18/cincinnati-... \n",
"\n",
" venue venueCity venueCityState \\\n",
"0 Scottrade Center St. Louis St. Louis, Mo. \n",
"1 Barclays Center Brooklyn Brooklyn, N.Y. \n",
"2 Chesapeake Energy Arena Oklahoma City Oklahoma City, Okla. \n",
"3 Spokane Veterans Memorial Arena Spokane Spokane, Wash. \n",
"4 Scottrade Center St. Louis St. Louis, Mo. \n",
"5 Barclays Center Brooklyn Brooklyn, N.Y. \n",
"6 Chesapeake Energy Arena Oklahoma City Oklahoma City, Okla. \n",
"7 Spokane Veterans Memorial Arena Spokane Spokane, Wash. \n",
"8 Scottrade Center St. Louis St. Louis, Mo. \n",
"9 Barclays Center Brooklyn Brooklyn, N.Y. \n",
"10 Chesapeake Energy Arena Oklahoma City Oklahoma City, Okla. \n",
"11 Spokane Veterans Memorial Arena Spokane Spokane, Wash. \n",
"12 Scottrade Center St. Louis St. Louis, Mo. \n",
"13 NaN NaN NaN \n",
"14 Barclays Center Brooklyn Brooklyn, N.Y. \n",
"15 Chesapeake Energy Arena Oklahoma City Oklahoma City, Okla. \n",
"16 Spokane Veterans Memorial Arena Spokane Spokane, Wash. \n",
"\n",
" venueState videos \n",
"0 Mo. [] \n",
"1 N.Y. [] \n",
"2 Okla. NaN \n",
"3 Wash. NaN \n",
"4 Mo. NaN \n",
"5 N.Y. NaN \n",
"6 Okla. NaN \n",
"7 Wash. NaN \n",
"8 Mo. NaN \n",
"9 N.Y. NaN \n",
"10 Okla. NaN \n",
"11 Wash. NaN \n",
"12 Mo. NaN \n",
"13 NaN NaN \n",
"14 N.Y. NaN \n",
"15 Okla. NaN \n",
"16 Wash. NaN "
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"scoreboard_df"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Write a function that describes the current game situation."
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"current_games = scoreboard_df.loc[scoreboard_df['gameStatus'] == 'In-Progress'].copy()"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"array([u'VCU ahead of Oregon State 58-52 with 6:30 left in the 2nd Half.',\n",
" u'Hawaii ahead of California 36-30 with left in the Halftime.',\n",
" u'Middle Tenn. ahead of Michigan State 25-22 with 7:52 left in the 1st Half.',\n",
" u'Temple ahead of Iowa 6-5 with 16:30 left in the 1st Half.'], dtype=object)"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"def current_scores(row):\n",
" time_left = 'with %s left in the %s.' % (row['timeclock'],\n",
" row['currentPeriod'])\n",
" \n",
" if row['away.currentScore'] == row['home.currentScore']:\n",
" return '%s and %s are tied at %s %s' % (row['home.nameRaw'],\n",
" row['away.nameRaw'],\n",
" row['home.currentScore'],\n",
" time_left)\n",
" \n",
" if row['away.currentScore'] > row['home.currentScore']:\n",
" winning = 'away'\n",
" losing = 'home'\n",
" else:\n",
" winning = 'home'\n",
" losing = 'away'\n",
" \n",
" \n",
" winning_team = row['%s.nameRaw' % winning]\n",
" winning_score = row['%s.currentScore' % winning]\n",
" losing_team = row['%s.nameRaw' % losing]\n",
" losing_score = row['%s.currentScore' % losing]\n",
" return '%s ahead of %s %s-%s %s' % (winning_team,\n",
" losing_team,\n",
" winning_score,\n",
" losing_score,\n",
" time_left)\n",
"\n",
"current_games['update_text'] = current_games.apply(current_scores, axis=1)\n",
"current_games['update_text'].values"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"I decided that a NCAA tournament game is arbitrarily interesting if the score difference is less than the seed difference or if there is less than five minutes left and the score difference is less than five.\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>update_text</th>\n",
" <th>interesting</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>VCU ahead of Oregon State 58-52 with 6:30 left...</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Hawaii ahead of California 36-30 with left in...</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Middle Tenn. ahead of Michigan State 25-22 wit...</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Temple ahead of Iowa 6-5 with 16:30 left in th...</td>\n",
" <td>True</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" update_text interesting\n",
"2 VCU ahead of Oregon State 58-52 with 6:30 left... False\n",
"3 Hawaii ahead of California 36-30 with left in... False\n",
"4 Middle Tenn. ahead of Michigan State 25-22 wit... True\n",
"5 Temple ahead of Iowa 6-5 with 16:30 left in th... True"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"def interesting(row):\n",
" if 'Halftime' in row['currentPeriod']:\n",
" return 'False'\n",
" \n",
" score_gap = abs(int(row['home.currentScore']) - int(row['away.currentScore']))\n",
" minutes_left = int(row['timeclock'].split(':')[0])\n",
"\n",
" seed_dif = abs(int(row['away.teamSeed'])- int(row['home.teamSeed']))\n",
" \n",
" if '1st Half' not in row['currentPeriod'] and score_gap <= 5 and minutes_left < 5:\n",
" return True\n",
" if seed_dif > score_gap:\n",
" return True\n",
" return False\n",
"\n",
"current_games['interesting'] = current_games.apply(interesting, axis=1)\n",
"current_games[['update_text','interesting']]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Putting it all together"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"def update_me():\n",
" scoreboard_df = get_scoreboard()\n",
" current_games = scoreboard_df.loc[scoreboard_df['gameStatus'] == 'In-Progress'].copy()\n",
" current_games['interesting'] = current_games.apply(interesting, axis=1)\n",
" interesting_games = current_games.loc[current_games['interesting'] == True].copy()\n",
" if len(interesting_games) > 0:\n",
" interesting_games['update_text'] = interesting_games.apply(current_scores, axis=1)\n",
" return list(interesting_games['update_text'].values)\n",
" else:\n",
" print 'Nothing exciting going on.'"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"[u'Middle Tenn. ahead of Michigan State 25-22 with 7:52 left in the 1st Half.',\n",
" u'Temple ahead of Iowa 6-5 with 16:30 left in the 1st Half.']"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"update_me()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Now you can pipe these results to whatever bot you want."
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 2",
"language": "python",
"name": "python2"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.11"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment