BART.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:6081fe0afd98c302e66e580ecab05bffd33e57ee2bcae2685b511a6bc10d565a"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "notes"
      }
     },
     "source": [
      "# Transit APIs in general\n",
      "\n",
      "Larger context of transit APIs: [45 Transit APIs: Yahoo Traffic, SMSMyBus and BART | ProgrammableWeb](http://www.programmableweb.com/news/45-transit-apis-yahoo-traffic-smsmybus-and-bart/2012/02/14).  How about NYC?\n",
      "\n",
      "[BART - API Documentation, Station](http://api.bart.gov/docs/stn/)\n",
      "\n",
      "get info about stations"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "%run talktools"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "skip"
      }
     },
     "outputs": [
      {
       "html": [
        "\n",
        "<style>\n",
        "\n",
        ".rendered_html\n",
        "{\n",
        "  color: #2C5494;\n",
        "  font-family: Ubuntu;\n",
        "  font-size: 140%;\n",
        "  line-height: 1.1;\n",
        "  margin: 0.5em 0;\n",
        "  }\n",
        "\n",
        ".title\n",
        "{\n",
        "  color: #498AF3;\n",
        "  font-size: 250%;\n",
        "  font-weight:bold;\n",
        "  line-height: 1.2; \n",
        "  margin: 10px 50px 10px;\n",
        "  }\n",
        "\n",
        ".subtitle\n",
        "{\n",
        "  color: #386BBC;\n",
        "  font-size: 180%;\n",
        "  font-weight:bold;\n",
        "  line-height: 1.2; \n",
        "  margin: 20px 50px 20px;\n",
        "  }\n",
        "\n",
        ".slide-header, p.slide-header\n",
        "{\n",
        "  color: #498AF3;\n",
        "  font-size: 200%;\n",
        "  font-weight:bold;\n",
        "  margin: 0px 20px 10px;\n",
        "  page-break-before: always;\n",
        "  text-align: center;\n",
        "  }\n",
        "\n",
        ".rendered_html h1\n",
        "{\n",
        "  color: #498AF3;\n",
        "  line-height: 1.2; \n",
        "  margin: 0.15em 0em 0.5em;\n",
        "  page-break-before: always;\n",
        "  text-align: center;\n",
        "  }\n",
        "\n",
        "\n",
        ".rendered_html h2\n",
        "{ \n",
        "  color: #386BBC;\n",
        "  line-height: 1.2;\n",
        "  margin: 1.1em 0em 0.5em;\n",
        "  }\n",
        "\n",
        ".rendered_html h3\n",
        "{ \n",
        "  font-size: 100%;\n",
        "  line-height: 1.2;\n",
        "  margin: 1.1em 0em 0.5em;\n",
        "  }\n",
        "\n",
        ".rendered_html li\n",
        "{\n",
        "  line-height: 1.8;\n",
        "  }\n",
        "\n",
        ".input_prompt, .CodeMirror-lines, .output_area\n",
        "{\n",
        "  font-family: Consolas;\n",
        "  font-size: 120%;\n",
        "  }\n",
        "\n",
        ".gap-above\n",
        "{\n",
        "  padding-top: 200px;\n",
        "  }\n",
        "\n",
        ".gap01\n",
        "{\n",
        "  padding-top: 10px;\n",
        "  }\n",
        "\n",
        ".gap05\n",
        "{\n",
        "  padding-top: 50px;\n",
        "  }\n",
        "\n",
        ".gap1\n",
        "{\n",
        "  padding-top: 100px;\n",
        "  }\n",
        "\n",
        ".gap2\n",
        "{\n",
        "  padding-top: 200px;\n",
        "  }\n",
        "\n",
        ".gap3\n",
        "{\n",
        "  padding-top: 300px;\n",
        "  }\n",
        "\n",
        ".emph\n",
        "{\n",
        "  color: #386BBC;\n",
        "  }\n",
        "\n",
        ".warn\n",
        "{\n",
        "  color: red;\n",
        "  }\n",
        "\n",
        ".center\n",
        "{\n",
        "  text-align: center;\n",
        "  }\n",
        "\n",
        ".nb_link\n",
        "{\n",
        "    padding-bottom: 0.5em;\n",
        "}\n",
        "\n",
        "</style>\n",
        "\n"
       ],
       "metadata": {},
       "output_type": "display_data",
       "text": [
        "<IPython.core.display.HTML at 0x101c9fb50>"
       ]
      }
     ],
     "prompt_number": 1
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# BART\n",
      "\n",
      "Let's look at the documentation for the BART API:\n",
      "\n",
      "* [The Real BART API | bart.gov](http://www.bart.gov/schedules/developers/api)\n",
      "\n",
      "* [BART - API Documentation](http://api.bart.gov/docs/overview/index.aspx)\n",
      "\n",
      "\n",
      "Definitely good to familiarize yourself with the [BART website](bart.gov)"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "# BART developer's group and interesting data\n",
      "\n",
      "Also a good idea to use the developer's group: https://groups.google.com/forum/#!forum/bart-developers\n",
      "\n",
      "fun to look at [Ridership Reports | bart.gov](http://www.bart.gov/about/reports/ridership) too."
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# BART Map\n",
      "    \n",
      "![BART map](http://www.bart.gov/sites/all/themes/bart_desktop/img/global/system-map.gif)"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# Optional API key signup\n",
      "\n",
      "Two options for use of key\n",
      "\n",
      "* use the public key: `MW9S-E7SL-26DU-VV8V`\n",
      "\n",
      "* get your own key if you [sign up for one](http://api.bart.gov/api/register.aspx).  (read [Developer License Agreement | bart.gov](http://www.bart.gov/schedules/developers/developer-license-agreement))\n",
      "\n",
      "Benefits of signing up:\n",
      "\n",
      "> If you sign up for your own key you'll still be able to access the API if it turns into a tragedy of the commons. Plus you'll get a backstage pass to check out pre-release functionality that might just break everything you're working on -- or maybe give you a leg up in the marketplace.\n",
      "\n"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# setting up the API Key\n",
      "\n",
      "import requests\n",
      "import urllib\n",
      "from lxml.etree import fromstring\n",
      "\n",
      "\n",
      "try:\n",
      "    # to allow import of a registered key if it exists\n",
      "    from settings import BART_API_KEY\n",
      "except:\n",
      "    BART_API_KEY = \"MW9S-E7SL-26DU-VV8V\""
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "fragment"
      }
     },
     "outputs": [],
     "prompt_number": 2
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# Stations\n",
      "\n",
      "Let's look up data about the BART stations.\n",
      "\n",
      "* [BART - API Documentation, Station](http://api.bart.gov/docs/stn/stns.aspx)\n",
      "\n",
      "* See also [Geospatial Data | bart.gov](http://www.bart.gov/schedules/developers/geo) and [daguar/bart-geo](https://github.com/daguar/bart-geo)"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# [BART - API Documentation, Station](http://api.bart.gov/docs/stn/stns.aspx)\n",
      "\n",
      "def stations(key=BART_API_KEY):\n",
      "    url = \"http://api.bart.gov/api/stn.aspx?\" +  \\\n",
      "            urllib.urlencode({'key':key,\n",
      "                              'cmd':'stns'})\n",
      "    r = requests.get(url)\n",
      "    return r\n",
      "\n",
      "# grab the content of the XML document returned by the API\n",
      "r = stations().content\n",
      "print r"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "<?xml version=\"1.0\" encoding=\"utf-8\"?><root><uri><![CDATA[http://api.bart.gov/api/stn.aspx?cmd=stns]]></uri><stations><station><name>12th St. Oakland City Center</name><abbr>12TH</abbr><gtfs_latitude>37.803664</gtfs_latitude><gtfs_longitude>-122.271604</gtfs_longitude><address>1245 Broadway</address><city>Oakland</city><county>alameda</county><state>CA</state><zipcode>94612</zipcode></station><station><name>16th St. Mission</name><abbr>16TH</abbr><gtfs_latitude>37.765062</gtfs_latitude><gtfs_longitude>-122.419694</gtfs_longitude><address>2000 Mission Street</address><city>San Francisco</city><county>sanfrancisco</county><state>CA</state><zipcode>94110</zipcode></station><station><name>19th St. Oakland</name><abbr>19TH</abbr><gtfs_latitude>37.80787</gtfs_latitude><gtfs_longitude>-122.269029</gtfs_longitude><address>1900 Broadway</address><city>Oakland</city><county>alameda</county><state>CA</state><zipcode>94612</zipcode></station><station><name>24th St. Mission</name><abbr>24TH</abbr><gtfs_latitude>37.752254</gtfs_latitude><gtfs_longitude>-122.418466</gtfs_longitude><address>2800 Mission Street</address><city>San Francisco</city><county>sanfrancisco</county><state>CA</state><zipcode>94110</zipcode></station><station><name>Ashby</name><abbr>ASHB</abbr><gtfs_latitude>37.853024</gtfs_latitude><gtfs_longitude>-122.26978</gtfs_longitude><address>3100 Adeline Street</address><city>Berkeley</city><county>alameda</county><state>CA</state><zipcode>94703</zipcode></station><station><name>Balboa Park</name><abbr>BALB</abbr><gtfs_latitude>37.72198087</gtfs_latitude><gtfs_longitude>-122.4474142</gtfs_longitude><address>401 Geneva Avenue</address><city>San Francisco</city><county>sanfrancisco</county><state>CA</state><zipcode>94112</zipcode></station><station><name>Bay Fair</name><abbr>BAYF</abbr><gtfs_latitude>37.697185</gtfs_latitude><gtfs_longitude>-122.126871</gtfs_longitude><address>15242 Hesperian Blvd.</address><city>San Leandro</city><county>alameda</county><state>CA</state><zipcode>94578</zipcode></station><station><name>Castro Valley</name><abbr>CAST</abbr><gtfs_latitude>37.690754</gtfs_latitude><gtfs_longitude>-122.075567</gtfs_longitude><address>3301 Norbridge Dr.</address><city>Castro Valley</city><county>alameda</county><state>CA</state><zipcode>94546</zipcode></station><station><name>Civic Center/UN Plaza</name><abbr>CIVC</abbr><gtfs_latitude>37.779528</gtfs_latitude><gtfs_longitude>-122.413756</gtfs_longitude><address>1150 Market Street</address><city>San Francisco</city><county>sanfrancisco</county><state>CA</state><zipcode>94102</zipcode></station><station><name>Coliseum/Oakland Airport</name><abbr>COLS</abbr><gtfs_latitude>37.754006</gtfs_latitude><gtfs_longitude>-122.197273</gtfs_longitude><address>7200 San Leandro St.</address><city>Oakland</city><county>alameda</county><state>CA</state><zipcode>94621</zipcode></station><station><name>Colma</name><abbr>COLM</abbr><gtfs_latitude>37.684638</gtfs_latitude><gtfs_longitude>-122.466233</gtfs_longitude><address>365 D Street</address><city>Colma</city><county>sanmateo</county><state>CA</state><zipcode>94014</zipcode></station><station><name>Concord</name><abbr>CONC</abbr><gtfs_latitude>37.973737</gtfs_latitude><gtfs_longitude>-122.029095</gtfs_longitude><address>1451 Oakland Avenue</address><city>Concord</city><county>contracosta</county><state>CA</state><zipcode>94520</zipcode></station><station><name>Daly City</name><abbr>DALY</abbr><gtfs_latitude>37.70612055</gtfs_latitude><gtfs_longitude>-122.4690807</gtfs_longitude><address>500 John Daly Blvd.</address><city>Daly City</city><county>sanmateo</county><state>CA</state><zipcode>94014</zipcode></station><station><name>Downtown Berkeley</name><abbr>DBRK</abbr><gtfs_latitude>37.869867</gtfs_latitude><gtfs_longitude>-122.268045</gtfs_longitude><address>2160 Shattuck Avenue</address><city>Berkeley</city><county>alameda</county><state>CA</state><zipcode>94704</zipcode></station><station><name>Dublin/Pleasanton</name><abbr>DUBL</abbr><gtfs_latitude>37.701695</gtfs_latitude><gtfs_longitude>-121.900367</gtfs_longitude><address>5801 Owens Dr.</address><city>Pleasanton</city><county>alameda</county><state>CA</state><zipcode>94588</zipcode></station><station><name>El Cerrito del Norte</name><abbr>DELN</abbr><gtfs_latitude>37.925655</gtfs_latitude><gtfs_longitude>-122.317269</gtfs_longitude><address>6400 Cutting Blvd.</address><city>El Cerrito</city><county>contracosta</county><state>CA</state><zipcode>94530</zipcode></station><station><name>El Cerrito Plaza</name><abbr>PLZA</abbr><gtfs_latitude>37.9030588</gtfs_latitude><gtfs_longitude>-122.2992715</gtfs_longitude><address>6699 Fairmount Avenue</address><city>El Cerrito</city><county>contracosta</county><state>CA</state><zipcode>94530</zipcode></station><station><name>Embarcadero</name><abbr>EMBR</abbr><gtfs_latitude>37.792976</gtfs_latitude><gtfs_longitude>-122.396742</gtfs_longitude><address>298 Market Street</address><city>San Francisco</city><county>sanfrancisco</county><state>CA</state><zipcode>94111</zipcode></station><station><name>Fremont</name><abbr>FRMT</abbr><gtfs_latitude>37.557355</gtfs_latitude><gtfs_longitude>-121.9764</gtfs_longitude><address>2000 BART Way</address><city>Fremont</city><county>alameda</county><state>CA</state><zipcode>94536</zipcode></station><station><name>Fruitvale</name><abbr>FTVL</abbr><gtfs_latitude>37.774963</gtfs_latitude><gtfs_longitude>-122.224274</gtfs_longitude><address>3401 East 12th Street</address><city>Oakland</city><county>alameda</county><state>CA</state><zipcode>94601</zipcode></station><station><name>Glen Park</name><abbr>GLEN</abbr><gtfs_latitude>37.732921</gtfs_latitude><gtfs_longitude>-122.434092</gtfs_longitude><address>2901 Diamond Street</address><city>San Francisco</city><county>sanfrancisco</county><state>CA</state><zipcode>94131</zipcode></station><station><name>Hayward</name><abbr>HAYW</abbr><gtfs_latitude>37.670399</gtfs_latitude><gtfs_longitude>-122.087967</gtfs_longitude><address>699 'B' Street</address><city>Hayward</city><county>alameda</county><state>CA</state><zipcode>94541</zipcode></station><station><name>Lafayette</name><abbr>LAFY</abbr><gtfs_latitude>37.893394</gtfs_latitude><gtfs_longitude>-122.123801</gtfs_longitude><address>3601 Deer Hill Road</address><city>Lafayette</city><county>contracosta</county><state>CA</state><zipcode>94549</zipcode></station><station><name>Lake Merritt</name><abbr>LAKE</abbr><gtfs_latitude>37.797484</gtfs_latitude><gtfs_longitude>-122.265609</gtfs_longitude><address>800 Madison Street</address><city>Oakland</city><county>alameda</county><state>CA</state><zipcode>94607</zipcode></station><station><name>MacArthur</name><abbr>MCAR</abbr><gtfs_latitude>37.828415</gtfs_latitude><gtfs_longitude>-122.267227</gtfs_longitude><address>555 40th Street</address><city>Oakland</city><county>alameda</county><state>CA</state><zipcode>94609</zipcode></station><station><name>Millbrae</name><abbr>MLBR</abbr><gtfs_latitude>37.599787</gtfs_latitude><gtfs_longitude>-122.38666</gtfs_longitude><address>200 North Rollins Road</address><city>Millbrae</city><county>sanmateo</county><state>CA</state><zipcode>94030</zipcode></station><station><name>Montgomery St.</name><abbr>MONT</abbr><gtfs_latitude>37.789256</gtfs_latitude><gtfs_longitude>-122.401407</gtfs_longitude><address>598 Market Street</address><city>San Francisco</city><county>sanfrancisco</county><state>CA</state><zipcode>94104</zipcode></station><station><name>North Berkeley</name><abbr>NBRK</abbr><gtfs_latitude>37.87404</gtfs_latitude><gtfs_longitude>-122.283451</gtfs_longitude><address>1750 Sacramento Street</address><city>Berkeley</city><county>alameda</county><state>CA</state><zipcode>94702</zipcode></station><station><name>North Concord/Martinez</name><abbr>NCON</abbr><gtfs_latitude>38.003275</gtfs_latitude><gtfs_longitude>-122.024597</gtfs_longitude><address>3700 Port Chicago Highway</address><city>Concord</city><county>contracosta</county><state>CA</state><zipcode>94520</zipcode></station><station><name>Orinda</name><abbr>ORIN</abbr><gtfs_latitude>37.87836087</gtfs_latitude><gtfs_longitude>-122.1837911</gtfs_longitude><address>11 Camino Pablo</address><city>Orinda</city><county>contracosta</county><state>CA</state><zipcode>94563</zipcode></station><station><name>Pittsburg/Bay Point</name><abbr>PITT</abbr><gtfs_latitude>38.018914</gtfs_latitude><gtfs_longitude>-121.945154</gtfs_longitude><address>1700 West Leland Road</address><city>Pittsburg</city><county>contracosta</county><state>CA</state><zipcode>94565</zipcode></station><station><name>Pleasant Hill/Contra Costa Centre</name><abbr>PHIL</abbr><gtfs_latitude>37.928403</gtfs_latitude><gtfs_longitude>-122.056013</gtfs_longitude><address>1365 Treat Blvd.</address><city>Walnut Creek</city><county>contracosta</county><state>CA</state><zipcode>94597</zipcode></station><station><name>Powell St.</name><abbr>POWL</abbr><gtfs_latitude>37.784991</gtfs_latitude><gtfs_longitude>-122.406857</gtfs_longitude><address>899 Market Street</address><city>San Francisco</city><county>sanfrancisco</county><state>CA</state><zipcode>94102</zipcode></station><station><name>Richmond</name><abbr>RICH</abbr><gtfs_latitude>37.936887</gtfs_latitude><gtfs_longitude>-122.353165</gtfs_longitude><address>1700 Nevin Avenue</address><city>Richmond</city><county>contracosta</county><state>CA</state><zipcode>94801</zipcode></station><station><name>Rockridge</name><abbr>ROCK</abbr><gtfs_latitude>37.844601</gtfs_latitude><gtfs_longitude>-122.251793</gtfs_longitude><address>5660 College Avenue</address><city>Oakland</city><county>alameda</county><state>CA</state><zipcode>94618</zipcode></station><station><name>San Bruno</name><abbr>SBRN</abbr><gtfs_latitude>37.637753</gtfs_latitude><gtfs_longitude>-122.416038</gtfs_longitude><address>1151 Huntington Avenue</address><city>San Bruno</city><county>sanmateo</county><state>CA</state><zipcode>94066</zipcode></station><station><name>San Francisco Int'l Airport</name><abbr>SFIA</abbr><gtfs_latitude>37.616035</gtfs_latitude><gtfs_longitude>-122.392612</gtfs_longitude><address>International Terminal, Level 3</address><city>San Francisco Int'l Airport</city><county>sanmateo</county><state>CA</state><zipcode>94128</zipcode></station><station><name>San Leandro</name><abbr>SANL</abbr><gtfs_latitude>37.72261921</gtfs_latitude><gtfs_longitude>-122.1613112</gtfs_longitude><address>1401 San Leandro Blvd.</address><city>San Leandro</city><county>alameda</county><state>CA</state><zipcode>94577</zipcode></station><station><name>South Hayward</name><abbr>SHAY</abbr><gtfs_latitude>37.63479954</gtfs_latitude><gtfs_longitude>-122.0575506</gtfs_longitude><address>28601 Dixon Street</address><city>Hayward</city><county>alameda</county><state>CA</state><zipcode>94544</zipcode></station><station><name>South San Francisco</name><abbr>SSAN</abbr><gtfs_latitude>37.664174</gtfs_latitude><gtfs_longitude>-122.444116</gtfs_longitude><address>1333 Mission Road</address><city>South San Francisco</city><county>sanmateo</county><state>CA</state><zipcode>94080</zipcode></station><station><name>Union City</name><abbr>UCTY</abbr><gtfs_latitude>37.591208</gtfs_latitude><gtfs_longitude>-122.017867</gtfs_longitude><address>10 Union Square</address><city>Union City</city><county>alameda</county><state>CA</state><zipcode>94587</zipcode></station><station><name>Walnut Creek</name><abbr>WCRK</abbr><gtfs_latitude>37.905628</gtfs_latitude><gtfs_longitude>-122.067423</gtfs_longitude><address>200 Ygnacio Valley Road</address><city>Walnut Creek</city><county>contracosta</county><state>CA</state><zipcode>94596</zipcode></station><station><name>West Dublin/Pleasanton</name><abbr>WDUB</abbr><gtfs_latitude>37.699759</gtfs_latitude><gtfs_longitude>-121.928099</gtfs_longitude><address>6501 Golden Gate Drive</address><city>Dublin</city><county>alameda</county><state>CA</state><zipcode>94568</zipcode></station><station><name>West Oakland</name><abbr>WOAK</abbr><gtfs_latitude>37.80467476</gtfs_latitude><gtfs_longitude>-122.2945822</gtfs_longitude><address>1451 7th Street</address><city>Oakland</city><county>alameda</county><state>CA</state><zipcode>94607</zipcode></station></stations><message></message></root>\n"
       ]
      }
     ],
     "prompt_number": 3
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# how many stations?\n",
      "# parse the XML document to look for number of nodes with stations/station\n",
      "\n",
      "from lxml import etree\n",
      "\n",
      "stations = etree.fromstring(r).xpath(\"stations/station\")\n",
      "len(stations)"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 4,
       "text": [
        "44"
       ]
      }
     ],
     "prompt_number": 4
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# let's make a DataFrame (table) out of the stations data\n",
      "\n",
      "from pandas import DataFrame\n",
      "from collections import OrderedDict\n",
      "\n",
      "def station_to_ordereddict(station):\n",
      "    return OrderedDict([(child.tag, child.text) for child in station.iterchildren()])\n",
      "\n",
      "stations_df = DataFrame([station_to_ordereddict(station) for station in stations])\n",
      "stations_df"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>abbr</th>\n",
        "      <th>address</th>\n",
        "      <th>city</th>\n",
        "      <th>county</th>\n",
        "      <th>gtfs_latitude</th>\n",
        "      <th>gtfs_longitude</th>\n",
        "      <th>name</th>\n",
        "      <th>state</th>\n",
        "      <th>zipcode</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0 </th>\n",
        "      <td> 12TH</td>\n",
        "      <td>                   1245 Broadway</td>\n",
        "      <td>                     Oakland</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.803664</td>\n",
        "      <td>  -122.271604</td>\n",
        "      <td>      12th St. Oakland City Center</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94612</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1 </th>\n",
        "      <td> 16TH</td>\n",
        "      <td>             2000 Mission Street</td>\n",
        "      <td>               San Francisco</td>\n",
        "      <td> sanfrancisco</td>\n",
        "      <td>   37.765062</td>\n",
        "      <td>  -122.419694</td>\n",
        "      <td>                  16th St. Mission</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94110</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2 </th>\n",
        "      <td> 19TH</td>\n",
        "      <td>                   1900 Broadway</td>\n",
        "      <td>                     Oakland</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>    37.80787</td>\n",
        "      <td>  -122.269029</td>\n",
        "      <td>                  19th St. Oakland</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94612</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3 </th>\n",
        "      <td> 24TH</td>\n",
        "      <td>             2800 Mission Street</td>\n",
        "      <td>               San Francisco</td>\n",
        "      <td> sanfrancisco</td>\n",
        "      <td>   37.752254</td>\n",
        "      <td>  -122.418466</td>\n",
        "      <td>                  24th St. Mission</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94110</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4 </th>\n",
        "      <td> ASHB</td>\n",
        "      <td>             3100 Adeline Street</td>\n",
        "      <td>                    Berkeley</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.853024</td>\n",
        "      <td>   -122.26978</td>\n",
        "      <td>                             Ashby</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94703</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5 </th>\n",
        "      <td> BALB</td>\n",
        "      <td>               401 Geneva Avenue</td>\n",
        "      <td>               San Francisco</td>\n",
        "      <td> sanfrancisco</td>\n",
        "      <td> 37.72198087</td>\n",
        "      <td> -122.4474142</td>\n",
        "      <td>                       Balboa Park</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94112</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6 </th>\n",
        "      <td> BAYF</td>\n",
        "      <td>           15242 Hesperian Blvd.</td>\n",
        "      <td>                 San Leandro</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.697185</td>\n",
        "      <td>  -122.126871</td>\n",
        "      <td>                          Bay Fair</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94578</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7 </th>\n",
        "      <td> CAST</td>\n",
        "      <td>              3301 Norbridge Dr.</td>\n",
        "      <td>               Castro Valley</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.690754</td>\n",
        "      <td>  -122.075567</td>\n",
        "      <td>                     Castro Valley</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94546</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8 </th>\n",
        "      <td> CIVC</td>\n",
        "      <td>              1150 Market Street</td>\n",
        "      <td>               San Francisco</td>\n",
        "      <td> sanfrancisco</td>\n",
        "      <td>   37.779528</td>\n",
        "      <td>  -122.413756</td>\n",
        "      <td>             Civic Center/UN Plaza</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94102</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9 </th>\n",
        "      <td> COLS</td>\n",
        "      <td>            7200 San Leandro St.</td>\n",
        "      <td>                     Oakland</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.754006</td>\n",
        "      <td>  -122.197273</td>\n",
        "      <td>          Coliseum/Oakland Airport</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94621</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td> COLM</td>\n",
        "      <td>                    365 D Street</td>\n",
        "      <td>                       Colma</td>\n",
        "      <td>     sanmateo</td>\n",
        "      <td>   37.684638</td>\n",
        "      <td>  -122.466233</td>\n",
        "      <td>                             Colma</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94014</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td> CONC</td>\n",
        "      <td>             1451 Oakland Avenue</td>\n",
        "      <td>                     Concord</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td>   37.973737</td>\n",
        "      <td>  -122.029095</td>\n",
        "      <td>                           Concord</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94520</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td> DALY</td>\n",
        "      <td>             500 John Daly Blvd.</td>\n",
        "      <td>                   Daly City</td>\n",
        "      <td>     sanmateo</td>\n",
        "      <td> 37.70612055</td>\n",
        "      <td> -122.4690807</td>\n",
        "      <td>                         Daly City</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94014</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td> DBRK</td>\n",
        "      <td>            2160 Shattuck Avenue</td>\n",
        "      <td>                    Berkeley</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.869867</td>\n",
        "      <td>  -122.268045</td>\n",
        "      <td>                 Downtown Berkeley</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94704</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td> DUBL</td>\n",
        "      <td>                  5801 Owens Dr.</td>\n",
        "      <td>                  Pleasanton</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.701695</td>\n",
        "      <td>  -121.900367</td>\n",
        "      <td>                 Dublin/Pleasanton</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94588</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td> DELN</td>\n",
        "      <td>              6400 Cutting Blvd.</td>\n",
        "      <td>                  El Cerrito</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td>   37.925655</td>\n",
        "      <td>  -122.317269</td>\n",
        "      <td>              El Cerrito del Norte</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94530</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td> PLZA</td>\n",
        "      <td>           6699 Fairmount Avenue</td>\n",
        "      <td>                  El Cerrito</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td>  37.9030588</td>\n",
        "      <td> -122.2992715</td>\n",
        "      <td>                  El Cerrito Plaza</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94530</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td> EMBR</td>\n",
        "      <td>               298 Market Street</td>\n",
        "      <td>               San Francisco</td>\n",
        "      <td> sanfrancisco</td>\n",
        "      <td>   37.792976</td>\n",
        "      <td>  -122.396742</td>\n",
        "      <td>                       Embarcadero</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94111</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td> FRMT</td>\n",
        "      <td>                   2000 BART Way</td>\n",
        "      <td>                     Fremont</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.557355</td>\n",
        "      <td>    -121.9764</td>\n",
        "      <td>                           Fremont</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94536</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td> FTVL</td>\n",
        "      <td>           3401 East 12th Street</td>\n",
        "      <td>                     Oakland</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.774963</td>\n",
        "      <td>  -122.224274</td>\n",
        "      <td>                         Fruitvale</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94601</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td> GLEN</td>\n",
        "      <td>             2901 Diamond Street</td>\n",
        "      <td>               San Francisco</td>\n",
        "      <td> sanfrancisco</td>\n",
        "      <td>   37.732921</td>\n",
        "      <td>  -122.434092</td>\n",
        "      <td>                         Glen Park</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94131</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td> HAYW</td>\n",
        "      <td>                  699 'B' Street</td>\n",
        "      <td>                     Hayward</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.670399</td>\n",
        "      <td>  -122.087967</td>\n",
        "      <td>                           Hayward</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94541</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td> LAFY</td>\n",
        "      <td>             3601 Deer Hill Road</td>\n",
        "      <td>                   Lafayette</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td>   37.893394</td>\n",
        "      <td>  -122.123801</td>\n",
        "      <td>                         Lafayette</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94549</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td> LAKE</td>\n",
        "      <td>              800 Madison Street</td>\n",
        "      <td>                     Oakland</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.797484</td>\n",
        "      <td>  -122.265609</td>\n",
        "      <td>                      Lake Merritt</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94607</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td> MCAR</td>\n",
        "      <td>                 555 40th Street</td>\n",
        "      <td>                     Oakland</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.828415</td>\n",
        "      <td>  -122.267227</td>\n",
        "      <td>                         MacArthur</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94609</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td> MLBR</td>\n",
        "      <td>          200 North Rollins Road</td>\n",
        "      <td>                    Millbrae</td>\n",
        "      <td>     sanmateo</td>\n",
        "      <td>   37.599787</td>\n",
        "      <td>   -122.38666</td>\n",
        "      <td>                          Millbrae</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94030</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26</th>\n",
        "      <td> MONT</td>\n",
        "      <td>               598 Market Street</td>\n",
        "      <td>               San Francisco</td>\n",
        "      <td> sanfrancisco</td>\n",
        "      <td>   37.789256</td>\n",
        "      <td>  -122.401407</td>\n",
        "      <td>                    Montgomery St.</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94104</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27</th>\n",
        "      <td> NBRK</td>\n",
        "      <td>          1750 Sacramento Street</td>\n",
        "      <td>                    Berkeley</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>    37.87404</td>\n",
        "      <td>  -122.283451</td>\n",
        "      <td>                    North Berkeley</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94702</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28</th>\n",
        "      <td> NCON</td>\n",
        "      <td>       3700 Port Chicago Highway</td>\n",
        "      <td>                     Concord</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td>   38.003275</td>\n",
        "      <td>  -122.024597</td>\n",
        "      <td>            North Concord/Martinez</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94520</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29</th>\n",
        "      <td> ORIN</td>\n",
        "      <td>                 11 Camino Pablo</td>\n",
        "      <td>                      Orinda</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td> 37.87836087</td>\n",
        "      <td> -122.1837911</td>\n",
        "      <td>                            Orinda</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94563</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>30</th>\n",
        "      <td> PITT</td>\n",
        "      <td>           1700 West Leland Road</td>\n",
        "      <td>                   Pittsburg</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td>   38.018914</td>\n",
        "      <td>  -121.945154</td>\n",
        "      <td>               Pittsburg/Bay Point</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94565</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>31</th>\n",
        "      <td> PHIL</td>\n",
        "      <td>                1365 Treat Blvd.</td>\n",
        "      <td>                Walnut Creek</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td>   37.928403</td>\n",
        "      <td>  -122.056013</td>\n",
        "      <td> Pleasant Hill/Contra Costa Centre</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94597</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>32</th>\n",
        "      <td> POWL</td>\n",
        "      <td>               899 Market Street</td>\n",
        "      <td>               San Francisco</td>\n",
        "      <td> sanfrancisco</td>\n",
        "      <td>   37.784991</td>\n",
        "      <td>  -122.406857</td>\n",
        "      <td>                        Powell St.</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94102</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>33</th>\n",
        "      <td> RICH</td>\n",
        "      <td>               1700 Nevin Avenue</td>\n",
        "      <td>                    Richmond</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td>   37.936887</td>\n",
        "      <td>  -122.353165</td>\n",
        "      <td>                          Richmond</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94801</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>34</th>\n",
        "      <td> ROCK</td>\n",
        "      <td>             5660 College Avenue</td>\n",
        "      <td>                     Oakland</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.844601</td>\n",
        "      <td>  -122.251793</td>\n",
        "      <td>                         Rockridge</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94618</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>35</th>\n",
        "      <td> SBRN</td>\n",
        "      <td>          1151 Huntington Avenue</td>\n",
        "      <td>                   San Bruno</td>\n",
        "      <td>     sanmateo</td>\n",
        "      <td>   37.637753</td>\n",
        "      <td>  -122.416038</td>\n",
        "      <td>                         San Bruno</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94066</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>36</th>\n",
        "      <td> SFIA</td>\n",
        "      <td> International Terminal, Level 3</td>\n",
        "      <td> San Francisco Int'l Airport</td>\n",
        "      <td>     sanmateo</td>\n",
        "      <td>   37.616035</td>\n",
        "      <td>  -122.392612</td>\n",
        "      <td>       San Francisco Int'l Airport</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94128</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>37</th>\n",
        "      <td> SANL</td>\n",
        "      <td>          1401 San Leandro Blvd.</td>\n",
        "      <td>                 San Leandro</td>\n",
        "      <td>      alameda</td>\n",
        "      <td> 37.72261921</td>\n",
        "      <td> -122.1613112</td>\n",
        "      <td>                       San Leandro</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94577</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>38</th>\n",
        "      <td> SHAY</td>\n",
        "      <td>              28601 Dixon Street</td>\n",
        "      <td>                     Hayward</td>\n",
        "      <td>      alameda</td>\n",
        "      <td> 37.63479954</td>\n",
        "      <td> -122.0575506</td>\n",
        "      <td>                     South Hayward</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94544</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>39</th>\n",
        "      <td> SSAN</td>\n",
        "      <td>               1333 Mission Road</td>\n",
        "      <td>         South San Francisco</td>\n",
        "      <td>     sanmateo</td>\n",
        "      <td>   37.664174</td>\n",
        "      <td>  -122.444116</td>\n",
        "      <td>               South San Francisco</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94080</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>40</th>\n",
        "      <td> UCTY</td>\n",
        "      <td>                 10 Union Square</td>\n",
        "      <td>                  Union City</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.591208</td>\n",
        "      <td>  -122.017867</td>\n",
        "      <td>                        Union City</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94587</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>41</th>\n",
        "      <td> WCRK</td>\n",
        "      <td>         200 Ygnacio Valley Road</td>\n",
        "      <td>                Walnut Creek</td>\n",
        "      <td>  contracosta</td>\n",
        "      <td>   37.905628</td>\n",
        "      <td>  -122.067423</td>\n",
        "      <td>                      Walnut Creek</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94596</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>42</th>\n",
        "      <td> WDUB</td>\n",
        "      <td>          6501 Golden Gate Drive</td>\n",
        "      <td>                      Dublin</td>\n",
        "      <td>      alameda</td>\n",
        "      <td>   37.699759</td>\n",
        "      <td>  -121.928099</td>\n",
        "      <td>            West Dublin/Pleasanton</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94568</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>43</th>\n",
        "      <td> WOAK</td>\n",
        "      <td>                 1451 7th Street</td>\n",
        "      <td>                     Oakland</td>\n",
        "      <td>      alameda</td>\n",
        "      <td> 37.80467476</td>\n",
        "      <td> -122.2945822</td>\n",
        "      <td>                      West Oakland</td>\n",
        "      <td> CA</td>\n",
        "      <td> 94607</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>44 rows \u00d7 9 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 5,
       "text": [
        "    abbr                          address                         city  \\\n",
        "0   12TH                    1245 Broadway                      Oakland   \n",
        "1   16TH              2000 Mission Street                San Francisco   \n",
        "2   19TH                    1900 Broadway                      Oakland   \n",
        "3   24TH              2800 Mission Street                San Francisco   \n",
        "4   ASHB              3100 Adeline Street                     Berkeley   \n",
        "5   BALB                401 Geneva Avenue                San Francisco   \n",
        "6   BAYF            15242 Hesperian Blvd.                  San Leandro   \n",
        "7   CAST               3301 Norbridge Dr.                Castro Valley   \n",
        "8   CIVC               1150 Market Street                San Francisco   \n",
        "9   COLS             7200 San Leandro St.                      Oakland   \n",
        "10  COLM                     365 D Street                        Colma   \n",
        "11  CONC              1451 Oakland Avenue                      Concord   \n",
        "12  DALY              500 John Daly Blvd.                    Daly City   \n",
        "13  DBRK             2160 Shattuck Avenue                     Berkeley   \n",
        "14  DUBL                   5801 Owens Dr.                   Pleasanton   \n",
        "15  DELN               6400 Cutting Blvd.                   El Cerrito   \n",
        "16  PLZA            6699 Fairmount Avenue                   El Cerrito   \n",
        "17  EMBR                298 Market Street                San Francisco   \n",
        "18  FRMT                    2000 BART Way                      Fremont   \n",
        "19  FTVL            3401 East 12th Street                      Oakland   \n",
        "20  GLEN              2901 Diamond Street                San Francisco   \n",
        "21  HAYW                   699 'B' Street                      Hayward   \n",
        "22  LAFY              3601 Deer Hill Road                    Lafayette   \n",
        "23  LAKE               800 Madison Street                      Oakland   \n",
        "24  MCAR                  555 40th Street                      Oakland   \n",
        "25  MLBR           200 North Rollins Road                     Millbrae   \n",
        "26  MONT                598 Market Street                San Francisco   \n",
        "27  NBRK           1750 Sacramento Street                     Berkeley   \n",
        "28  NCON        3700 Port Chicago Highway                      Concord   \n",
        "29  ORIN                  11 Camino Pablo                       Orinda   \n",
        "30  PITT            1700 West Leland Road                    Pittsburg   \n",
        "31  PHIL                 1365 Treat Blvd.                 Walnut Creek   \n",
        "32  POWL                899 Market Street                San Francisco   \n",
        "33  RICH                1700 Nevin Avenue                     Richmond   \n",
        "34  ROCK              5660 College Avenue                      Oakland   \n",
        "35  SBRN           1151 Huntington Avenue                    San Bruno   \n",
        "36  SFIA  International Terminal, Level 3  San Francisco Int'l Airport   \n",
        "37  SANL           1401 San Leandro Blvd.                  San Leandro   \n",
        "38  SHAY               28601 Dixon Street                      Hayward   \n",
        "39  SSAN                1333 Mission Road          South San Francisco   \n",
        "40  UCTY                  10 Union Square                   Union City   \n",
        "41  WCRK          200 Ygnacio Valley Road                 Walnut Creek   \n",
        "42  WDUB           6501 Golden Gate Drive                       Dublin   \n",
        "43  WOAK                  1451 7th Street                      Oakland   \n",
        "\n",
        "          county gtfs_latitude gtfs_longitude  \\\n",
        "0        alameda     37.803664    -122.271604   \n",
        "1   sanfrancisco     37.765062    -122.419694   \n",
        "2        alameda      37.80787    -122.269029   \n",
        "3   sanfrancisco     37.752254    -122.418466   \n",
        "4        alameda     37.853024     -122.26978   \n",
        "5   sanfrancisco   37.72198087   -122.4474142   \n",
        "6        alameda     37.697185    -122.126871   \n",
        "7        alameda     37.690754    -122.075567   \n",
        "8   sanfrancisco     37.779528    -122.413756   \n",
        "9        alameda     37.754006    -122.197273   \n",
        "10      sanmateo     37.684638    -122.466233   \n",
        "11   contracosta     37.973737    -122.029095   \n",
        "12      sanmateo   37.70612055   -122.4690807   \n",
        "13       alameda     37.869867    -122.268045   \n",
        "14       alameda     37.701695    -121.900367   \n",
        "15   contracosta     37.925655    -122.317269   \n",
        "16   contracosta    37.9030588   -122.2992715   \n",
        "17  sanfrancisco     37.792976    -122.396742   \n",
        "18       alameda     37.557355      -121.9764   \n",
        "19       alameda     37.774963    -122.224274   \n",
        "20  sanfrancisco     37.732921    -122.434092   \n",
        "21       alameda     37.670399    -122.087967   \n",
        "22   contracosta     37.893394    -122.123801   \n",
        "23       alameda     37.797484    -122.265609   \n",
        "24       alameda     37.828415    -122.267227   \n",
        "25      sanmateo     37.599787     -122.38666   \n",
        "26  sanfrancisco     37.789256    -122.401407   \n",
        "27       alameda      37.87404    -122.283451   \n",
        "28   contracosta     38.003275    -122.024597   \n",
        "29   contracosta   37.87836087   -122.1837911   \n",
        "30   contracosta     38.018914    -121.945154   \n",
        "31   contracosta     37.928403    -122.056013   \n",
        "32  sanfrancisco     37.784991    -122.406857   \n",
        "33   contracosta     37.936887    -122.353165   \n",
        "34       alameda     37.844601    -122.251793   \n",
        "35      sanmateo     37.637753    -122.416038   \n",
        "36      sanmateo     37.616035    -122.392612   \n",
        "37       alameda   37.72261921   -122.1613112   \n",
        "38       alameda   37.63479954   -122.0575506   \n",
        "39      sanmateo     37.664174    -122.444116   \n",
        "40       alameda     37.591208    -122.017867   \n",
        "41   contracosta     37.905628    -122.067423   \n",
        "42       alameda     37.699759    -121.928099   \n",
        "43       alameda   37.80467476   -122.2945822   \n",
        "\n",
        "                                 name state zipcode  \n",
        "0        12th St. Oakland City Center    CA   94612  \n",
        "1                    16th St. Mission    CA   94110  \n",
        "2                    19th St. Oakland    CA   94612  \n",
        "3                    24th St. Mission    CA   94110  \n",
        "4                               Ashby    CA   94703  \n",
        "5                         Balboa Park    CA   94112  \n",
        "6                            Bay Fair    CA   94578  \n",
        "7                       Castro Valley    CA   94546  \n",
        "8               Civic Center/UN Plaza    CA   94102  \n",
        "9            Coliseum/Oakland Airport    CA   94621  \n",
        "10                              Colma    CA   94014  \n",
        "11                            Concord    CA   94520  \n",
        "12                          Daly City    CA   94014  \n",
        "13                  Downtown Berkeley    CA   94704  \n",
        "14                  Dublin/Pleasanton    CA   94588  \n",
        "15               El Cerrito del Norte    CA   94530  \n",
        "16                   El Cerrito Plaza    CA   94530  \n",
        "17                        Embarcadero    CA   94111  \n",
        "18                            Fremont    CA   94536  \n",
        "19                          Fruitvale    CA   94601  \n",
        "20                          Glen Park    CA   94131  \n",
        "21                            Hayward    CA   94541  \n",
        "22                          Lafayette    CA   94549  \n",
        "23                       Lake Merritt    CA   94607  \n",
        "24                          MacArthur    CA   94609  \n",
        "25                           Millbrae    CA   94030  \n",
        "26                     Montgomery St.    CA   94104  \n",
        "27                     North Berkeley    CA   94702  \n",
        "28             North Concord/Martinez    CA   94520  \n",
        "29                             Orinda    CA   94563  \n",
        "30                Pittsburg/Bay Point    CA   94565  \n",
        "31  Pleasant Hill/Contra Costa Centre    CA   94597  \n",
        "32                         Powell St.    CA   94102  \n",
        "33                           Richmond    CA   94801  \n",
        "34                          Rockridge    CA   94618  \n",
        "35                          San Bruno    CA   94066  \n",
        "36        San Francisco Int'l Airport    CA   94128  \n",
        "37                        San Leandro    CA   94577  \n",
        "38                      South Hayward    CA   94544  \n",
        "39                South San Francisco    CA   94080  \n",
        "40                         Union City    CA   94587  \n",
        "41                       Walnut Creek    CA   94596  \n",
        "42             West Dublin/Pleasanton    CA   94568  \n",
        "43                       West Oakland    CA   94607  \n",
        "\n",
        "[44 rows x 9 columns]"
       ]
      }
     ],
     "prompt_number": 5
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "# Plotting stations on a Map\n",
      "\n",
      "Let's use the latitude, longitude information to construct a map of the stations."
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for s in stations_df.T.to_dict().values():\n",
      "    print s['name'], float(s['gtfs_latitude']), float(s['gtfs_longitude'])"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "subslide"
      }
     },
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "12th St. Oakland City Center 37.803664 -122.271604\n",
        "16th St. Mission 37.765062 -122.419694\n",
        "19th St. Oakland 37.80787 -122.269029\n",
        "24th St. Mission 37.752254 -122.418466\n",
        "Ashby 37.853024 -122.26978\n",
        "Balboa Park 37.72198087 -122.4474142\n",
        "Bay Fair 37.697185 -122.126871\n",
        "Castro Valley 37.690754 -122.075567\n",
        "Civic Center/UN Plaza 37.779528 -122.413756\n",
        "Coliseum/Oakland Airport 37.754006 -122.197273\n",
        "Colma 37.684638 -122.466233\n",
        "Concord 37.973737 -122.029095\n",
        "Daly City 37.70612055 -122.4690807\n",
        "Downtown Berkeley 37.869867 -122.268045\n",
        "Dublin/Pleasanton 37.701695 -121.900367\n",
        "El Cerrito del Norte 37.925655 -122.317269\n",
        "El Cerrito Plaza 37.9030588 -122.2992715\n",
        "Embarcadero 37.792976 -122.396742\n",
        "Fremont 37.557355 -121.9764\n",
        "Fruitvale 37.774963 -122.224274\n",
        "Glen Park 37.732921 -122.434092\n",
        "Hayward 37.670399 -122.087967\n",
        "Lafayette 37.893394 -122.123801\n",
        "Lake Merritt 37.797484 -122.265609\n",
        "MacArthur 37.828415 -122.267227\n",
        "Millbrae 37.599787 -122.38666\n",
        "Montgomery St. 37.789256 -122.401407\n",
        "North Berkeley 37.87404 -122.283451\n",
        "North Concord/Martinez 38.003275 -122.024597\n",
        "Orinda 37.87836087 -122.1837911\n",
        "Pittsburg/Bay Point 38.018914 -121.945154\n",
        "Pleasant Hill/Contra Costa Centre 37.928403 -122.056013\n",
        "Powell St. 37.784991 -122.406857\n",
        "Richmond 37.936887 -122.353165\n",
        "Rockridge 37.844601 -122.251793\n",
        "San Bruno 37.637753 -122.416038\n",
        "San Francisco Int'l Airport 37.616035 -122.392612\n",
        "San Leandro 37.72261921 -122.1613112\n",
        "South Hayward 37.63479954 -122.0575506\n",
        "South San Francisco 37.664174 -122.444116\n",
        "Union City 37.591208 -122.017867\n",
        "Walnut Creek 37.905628 -122.067423\n",
        "West Dublin/Pleasanton 37.699759 -121.928099\n",
        "West Oakland 37.80467476 -122.2945822\n"
       ]
      }
     ],
     "prompt_number": 6
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# plot the maps using folium \n",
      "# possible alternative: leaflet.js widget that Brian Granger working on \n",
      "# https://github.com/ellisonbg/leaftletwidget\n",
      "\n",
      "# http://nbviewer.ipython.org/gist/bburky/7763555/folium-ipython.ipynb\n",
      "\n",
      "from IPython.display import HTML\n",
      "import folium\n",
      "\n",
      "def inline_map(map):\n",
      "    \"\"\"\n",
      "    Embeds the HTML source of the map directly into the IPython notebook.\n",
      "    \n",
      "    This method will not work if the map depends on any files (json data). Also this uses\n",
      "    the HTML5 srcdoc attribute, which may not be supported in all browsers.\n",
      "    \"\"\"\n",
      "    map._build_map()\n",
      "    return HTML('<iframe srcdoc=\"{srcdoc}\" style=\"width: 100%; height: 510px; border: none\"></iframe>'.format(srcdoc=map.HTML.replace('\"', '&quot;')))\n",
      "\n",
      "def embed_map(map, path=\"map.html\"):\n",
      "    \"\"\"\n",
      "    Embeds a linked iframe to the map into the IPython notebook.\n",
      "    \n",
      "    Note: this method will not capture the source of the map into the notebook.\n",
      "    This method should work for all maps (as long as they use relative urls).\n",
      "    \"\"\"\n",
      "    map.create_map(path=path)\n",
      "    return HTML('<iframe src=\"files/{path}\" style=\"width: 100%; height: 510px; border: none\"></iframe>'.format(path=path))"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [],
     "prompt_number": 7
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "bart_map = folium.Map(location=[37.8717, -122.2728], zoom_start=9)\n",
      "\n",
      "\n",
      "# for airport in islice(airports,None):\n",
      "#    lat =  float(airport['Origin_lat'])\n",
      "#    lon = float(airport['Origin_long'])\n",
      "#    label = str(airport['Origin_airport'])  # don't know why str necessary here\n",
      "#    airport_map.simple_marker([lat,lon],popup=label)\n",
      "\n",
      "\n",
      "for s in stations_df.T.to_dict().values():\n",
      "    bart_map.simple_marker([float(s['gtfs_latitude']), float(s['gtfs_longitude'])],\n",
      "                           popup=s['name'])\n",
      "inline_map(bart_map)"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<iframe srcdoc=\"<!DOCTYPE html>\n",
        "<head>\n",
        "   <link rel=&quot;stylesheet&quot; href=&quot;http://cdn.leafletjs.com/leaflet-0.5/leaflet.css&quot; />\n",
        "   <script src=&quot;http://cdn.leafletjs.com/leaflet-0.5/leaflet.js&quot;></script>\n",
        "   \n",
        "   \n",
        "   \n",
        "   \n",
        "\n",
        "\n",
        "<style>\n",
        "\n",
        "#map {\n",
        "  position:absolute;\n",
        "  top:0;\n",
        "  bottom:0;\n",
        "  right:0;\n",
        "  left:0;\n",
        "}\n",
        "\n",
        "</style>\n",
        "</head>\n",
        "<body>\n",
        "\n",
        "        <div id=&quot;map&quot; style=&quot;width: 960px; height: 500px&quot;></div>\n",
        "\n",
        "<script>\n",
        "\n",
        "\n",
        "\n",
        "var map = L.map('map').setView([37.8717, -122.2728], 9);\n",
        "\n",
        "L.tileLayer('http://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {\n",
        "    maxZoom: 18,\n",
        "    attribution: 'Map data (c) <a href=&quot;http://openstreetmap.org&quot;>OpenStreetMap</a> contributors'\n",
        "}).addTo(map);\n",
        "\n",
        "\n",
        "var marker_1 = L.marker([37.803664, -122.271604]);\n",
        "marker_1.bindPopup(&quot;12th St. Oakland City Center&quot;);\n",
        "map.addLayer(marker_1)\n",
        "\n",
        "var marker_2 = L.marker([37.765062, -122.419694]);\n",
        "marker_2.bindPopup(&quot;16th St. Mission&quot;);\n",
        "map.addLayer(marker_2)\n",
        "\n",
        "var marker_3 = L.marker([37.80787, -122.269029]);\n",
        "marker_3.bindPopup(&quot;19th St. Oakland&quot;);\n",
        "map.addLayer(marker_3)\n",
        "\n",
        "var marker_4 = L.marker([37.752254, -122.418466]);\n",
        "marker_4.bindPopup(&quot;24th St. Mission&quot;);\n",
        "map.addLayer(marker_4)\n",
        "\n",
        "var marker_5 = L.marker([37.853024, -122.26978]);\n",
        "marker_5.bindPopup(&quot;Ashby&quot;);\n",
        "map.addLayer(marker_5)\n",
        "\n",
        "var marker_6 = L.marker([37.72198087, -122.4474142]);\n",
        "marker_6.bindPopup(&quot;Balboa Park&quot;);\n",
        "map.addLayer(marker_6)\n",
        "\n",
        "var marker_7 = L.marker([37.697185, -122.126871]);\n",
        "marker_7.bindPopup(&quot;Bay Fair&quot;);\n",
        "map.addLayer(marker_7)\n",
        "\n",
        "var marker_8 = L.marker([37.690754, -122.075567]);\n",
        "marker_8.bindPopup(&quot;Castro Valley&quot;);\n",
        "map.addLayer(marker_8)\n",
        "\n",
        "var marker_9 = L.marker([37.779528, -122.413756]);\n",
        "marker_9.bindPopup(&quot;Civic Center/UN Plaza&quot;);\n",
        "map.addLayer(marker_9)\n",
        "\n",
        "var marker_10 = L.marker([37.754006, -122.197273]);\n",
        "marker_10.bindPopup(&quot;Coliseum/Oakland Airport&quot;);\n",
        "map.addLayer(marker_10)\n",
        "\n",
        "var marker_11 = L.marker([37.684638, -122.466233]);\n",
        "marker_11.bindPopup(&quot;Colma&quot;);\n",
        "map.addLayer(marker_11)\n",
        "\n",
        "var marker_12 = L.marker([37.973737, -122.029095]);\n",
        "marker_12.bindPopup(&quot;Concord&quot;);\n",
        "map.addLayer(marker_12)\n",
        "\n",
        "var marker_13 = L.marker([37.70612055, -122.4690807]);\n",
        "marker_13.bindPopup(&quot;Daly City&quot;);\n",
        "map.addLayer(marker_13)\n",
        "\n",
        "var marker_14 = L.marker([37.869867, -122.268045]);\n",
        "marker_14.bindPopup(&quot;Downtown Berkeley&quot;);\n",
        "map.addLayer(marker_14)\n",
        "\n",
        "var marker_15 = L.marker([37.701695, -121.900367]);\n",
        "marker_15.bindPopup(&quot;Dublin/Pleasanton&quot;);\n",
        "map.addLayer(marker_15)\n",
        "\n",
        "var marker_16 = L.marker([37.925655, -122.317269]);\n",
        "marker_16.bindPopup(&quot;El Cerrito del Norte&quot;);\n",
        "map.addLayer(marker_16)\n",
        "\n",
        "var marker_17 = L.marker([37.9030588, -122.2992715]);\n",
        "marker_17.bindPopup(&quot;El Cerrito Plaza&quot;);\n",
        "map.addLayer(marker_17)\n",
        "\n",
        "var marker_18 = L.marker([37.792976, -122.396742]);\n",
        "marker_18.bindPopup(&quot;Embarcadero&quot;);\n",
        "map.addLayer(marker_18)\n",
        "\n",
        "var marker_19 = L.marker([37.557355, -121.9764]);\n",
        "marker_19.bindPopup(&quot;Fremont&quot;);\n",
        "map.addLayer(marker_19)\n",
        "\n",
        "var marker_20 = L.marker([37.774963, -122.224274]);\n",
        "marker_20.bindPopup(&quot;Fruitvale&quot;);\n",
        "map.addLayer(marker_20)\n",
        "\n",
        "var marker_21 = L.marker([37.732921, -122.434092]);\n",
        "marker_21.bindPopup(&quot;Glen Park&quot;);\n",
        "map.addLayer(marker_21)\n",
        "\n",
        "var marker_22 = L.marker([37.670399, -122.087967]);\n",
        "marker_22.bindPopup(&quot;Hayward&quot;);\n",
        "map.addLayer(marker_22)\n",
        "\n",
        "var marker_23 = L.marker([37.893394, -122.123801]);\n",
        "marker_23.bindPopup(&quot;Lafayette&quot;);\n",
        "map.addLayer(marker_23)\n",
        "\n",
        "var marker_24 = L.marker([37.797484, -122.265609]);\n",
        "marker_24.bindPopup(&quot;Lake Merritt&quot;);\n",
        "map.addLayer(marker_24)\n",
        "\n",
        "var marker_25 = L.marker([37.828415, -122.267227]);\n",
        "marker_25.bindPopup(&quot;MacArthur&quot;);\n",
        "map.addLayer(marker_25)\n",
        "\n",
        "var marker_26 = L.marker([37.599787, -122.38666]);\n",
        "marker_26.bindPopup(&quot;Millbrae&quot;);\n",
        "map.addLayer(marker_26)\n",
        "\n",
        "var marker_27 = L.marker([37.789256, -122.401407]);\n",
        "marker_27.bindPopup(&quot;Montgomery St.&quot;);\n",
        "map.addLayer(marker_27)\n",
        "\n",
        "var marker_28 = L.marker([37.87404, -122.283451]);\n",
        "marker_28.bindPopup(&quot;North Berkeley&quot;);\n",
        "map.addLayer(marker_28)\n",
        "\n",
        "var marker_29 = L.marker([38.003275, -122.024597]);\n",
        "marker_29.bindPopup(&quot;North Concord/Martinez&quot;);\n",
        "map.addLayer(marker_29)\n",
        "\n",
        "var marker_30 = L.marker([37.87836087, -122.1837911]);\n",
        "marker_30.bindPopup(&quot;Orinda&quot;);\n",
        "map.addLayer(marker_30)\n",
        "\n",
        "var marker_31 = L.marker([38.018914, -121.945154]);\n",
        "marker_31.bindPopup(&quot;Pittsburg/Bay Point&quot;);\n",
        "map.addLayer(marker_31)\n",
        "\n",
        "var marker_32 = L.marker([37.928403, -122.056013]);\n",
        "marker_32.bindPopup(&quot;Pleasant Hill/Contra Costa Centre&quot;);\n",
        "map.addLayer(marker_32)\n",
        "\n",
        "var marker_33 = L.marker([37.784991, -122.406857]);\n",
        "marker_33.bindPopup(&quot;Powell St.&quot;);\n",
        "map.addLayer(marker_33)\n",
        "\n",
        "var marker_34 = L.marker([37.936887, -122.353165]);\n",
        "marker_34.bindPopup(&quot;Richmond&quot;);\n",
        "map.addLayer(marker_34)\n",
        "\n",
        "var marker_35 = L.marker([37.844601, -122.251793]);\n",
        "marker_35.bindPopup(&quot;Rockridge&quot;);\n",
        "map.addLayer(marker_35)\n",
        "\n",
        "var marker_36 = L.marker([37.637753, -122.416038]);\n",
        "marker_36.bindPopup(&quot;San Bruno&quot;);\n",
        "map.addLayer(marker_36)\n",
        "\n",
        "var marker_37 = L.marker([37.616035, -122.392612]);\n",
        "marker_37.bindPopup(&quot;San Francisco Int'l Airport&quot;);\n",
        "map.addLayer(marker_37)\n",
        "\n",
        "var marker_38 = L.marker([37.72261921, -122.1613112]);\n",
        "marker_38.bindPopup(&quot;San Leandro&quot;);\n",
        "map.addLayer(marker_38)\n",
        "\n",
        "var marker_39 = L.marker([37.63479954, -122.0575506]);\n",
        "marker_39.bindPopup(&quot;South Hayward&quot;);\n",
        "map.addLayer(marker_39)\n",
        "\n",
        "var marker_40 = L.marker([37.664174, -122.444116]);\n",
        "marker_40.bindPopup(&quot;South San Francisco&quot;);\n",
        "map.addLayer(marker_40)\n",
        "\n",
        "var marker_41 = L.marker([37.591208, -122.017867]);\n",
        "marker_41.bindPopup(&quot;Union City&quot;);\n",
        "map.addLayer(marker_41)\n",
        "\n",
        "var marker_42 = L.marker([37.905628, -122.067423]);\n",
        "marker_42.bindPopup(&quot;Walnut Creek&quot;);\n",
        "map.addLayer(marker_42)\n",
        "\n",
        "var marker_43 = L.marker([37.699759, -121.928099]);\n",
        "marker_43.bindPopup(&quot;West Dublin/Pleasanton&quot;);\n",
        "map.addLayer(marker_43)\n",
        "\n",
        "var marker_44 = L.marker([37.80467476, -122.2945822]);\n",
        "marker_44.bindPopup(&quot;West Oakland&quot;);\n",
        "map.addLayer(marker_44)\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "</script>\n",
        "\n",
        "</body>\" style=\"width: 100%; height: 510px; border: none\"></iframe>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 8,
       "text": [
        "<IPython.core.display.HTML at 0x106e6e990>"
       ]
      }
     ],
     "prompt_number": 8
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# Simple real time info:  number of active trains\n",
      "\n",
      "* [BART - API Documentation, Advisory](http://api.bart.gov/docs/bsa/count.aspx)\n",
      "\n",
      "* http://api.bart.gov/api/bsa.aspx?cmd=count&key=MW9S-E7SL-26DU-VV8V"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "def train_count(key=BART_API_KEY):\n",
      "    url = \"http://api.bart.gov/api/bsa.aspx?\" +  \\\n",
      "        urllib.urlencode({'cmd':'count',\n",
      "                          'key':key})\n",
      "                                                                  \n",
      "    r = requests.get(url)\n",
      "    doc = fromstring(r.content)\n",
      "    call_dt = doc.find('date').text + \" \" +doc.find('time').text\n",
      "    count = doc.find('traincount').text\n",
      "    return (call_dt, count)\n",
      "\n",
      "d = train_count()\n",
      "d"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 9,
       "text": [
        "('05/27/2014 14:45:00 PM PDT', '52')"
       ]
      }
     ],
     "prompt_number": 9
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# Real time estimated departure times\n",
      "\n",
      "One of the most useful parts of the BART API is real-time departure information:\n",
      "\n",
      "* http://www.bart.gov/schedules/eta --> the interface on bart.gov\n",
      "* [BART - API Documentation, Real-Time](http://api.bart.gov/docs/etd/etd.aspx)\n",
      "* http://api.bart.gov/api/etd.aspx?cmd=etd&orig=PLZA&key=MW9S-E7SL-26DU-VV8V -> El Cerrito Plaza\n",
      "\n",
      "\n",
      "\n",
      "\n"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "from dateutil.parser import parse\n",
      "from dateutil.tz import tzlocal\n",
      "from lxml.etree import fromstring\n",
      "\n",
      "def etd(orig, key=BART_API_KEY):\n",
      "    url = \"http://api.bart.gov/api/etd.aspx?\" +  \\\n",
      "            urllib.urlencode({'cmd':'etd',\n",
      "                              'orig':orig,\n",
      "                              'key':key})\n",
      "                                                                  \n",
      "    r = requests.get(url)\n",
      "    doc = fromstring(r.content)\n",
      "    \n",
      "    estimations_list = []\n",
      "\n",
      "    # parse the datetime for the API call\n",
      "\n",
      "    s = doc.find('date').text + \" \" +doc.find('time').text\n",
      "    call_dt = parse(s)\n",
      "    \n",
      "    # turn the results into a rectangular format\n",
      "\n",
      "    # parse the station\n",
      "\n",
      "    for station in doc.findall('station'):\n",
      "        etds = station.findall('etd')\n",
      "        for etd in etds:\n",
      "            estimates = etd.findall('estimate')\n",
      "            for estimate in estimates:\n",
      "                estimate_tuple = [(child.tag, child.text) for child in estimate.iterchildren()]\n",
      "                \n",
      "                estimate_tuple += [('call_dt', call_dt),\n",
      "                                   ('station', station.find('abbr').text),\n",
      "                                   ('destination', etd.find('abbreviation').text)]\n",
      "               \n",
      "                estimations_list.append(dict(estimate_tuple))\n",
      "\n",
      "    return estimations_list"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [],
     "prompt_number": 10
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# we can get ETA for all stations\n",
      "\n",
      "from pandas import DataFrame\n",
      "import pandas as pd\n",
      "import numpy as np\n",
      "\n",
      "df = DataFrame(etd('all'))\n",
      "df"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>bikeflag</th>\n",
        "      <th>call_dt</th>\n",
        "      <th>color</th>\n",
        "      <th>destination</th>\n",
        "      <th>direction</th>\n",
        "      <th>hexcolor</th>\n",
        "      <th>length</th>\n",
        "      <th>minutes</th>\n",
        "      <th>platform</th>\n",
        "      <th>station</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  8</td>\n",
        "      <td>       2</td>\n",
        "      <td> 2</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #339933</td>\n",
        "      <td> 10</td>\n",
        "      <td>      10</td>\n",
        "      <td> 2</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  8</td>\n",
        "      <td>      17</td>\n",
        "      <td> 2</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>       7</td>\n",
        "      <td> 1</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      22</td>\n",
        "      <td> 1</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      37</td>\n",
        "      <td> 1</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  8</td>\n",
        "      <td>       4</td>\n",
        "      <td> 1</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  4</td>\n",
        "      <td>      14</td>\n",
        "      <td> 1</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  8</td>\n",
        "      <td>      19</td>\n",
        "      <td> 1</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9 </th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  3</td>\n",
        "      <td>       5</td>\n",
        "      <td> 2</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  3</td>\n",
        "      <td>      19</td>\n",
        "      <td> 2</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  6</td>\n",
        "      <td>      34</td>\n",
        "      <td> 2</td>\n",
        "      <td> LAKE</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #339933</td>\n",
        "      <td> 10</td>\n",
        "      <td>       6</td>\n",
        "      <td> 2</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  8</td>\n",
        "      <td>      12</td>\n",
        "      <td> 2</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  8</td>\n",
        "      <td>      21</td>\n",
        "      <td> 2</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      10</td>\n",
        "      <td> 1</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      26</td>\n",
        "      <td> 1</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      41</td>\n",
        "      <td> 1</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  4</td>\n",
        "      <td>       3</td>\n",
        "      <td> 1</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  8</td>\n",
        "      <td>       8</td>\n",
        "      <td> 1</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  4</td>\n",
        "      <td>      17</td>\n",
        "      <td> 1</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  3</td>\n",
        "      <td>       1</td>\n",
        "      <td> 2</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  3</td>\n",
        "      <td>      15</td>\n",
        "      <td> 2</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  6</td>\n",
        "      <td>      30</td>\n",
        "      <td> 2</td>\n",
        "      <td> FTVL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #339933</td>\n",
        "      <td> 10</td>\n",
        "      <td>       3</td>\n",
        "      <td> 2</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  8</td>\n",
        "      <td>       9</td>\n",
        "      <td> 2</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  8</td>\n",
        "      <td>      18</td>\n",
        "      <td> 2</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      14</td>\n",
        "      <td> 1</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      29</td>\n",
        "      <td> 1</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      44</td>\n",
        "      <td> 1</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>30</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  4</td>\n",
        "      <td>       7</td>\n",
        "      <td> 1</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>31</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  8</td>\n",
        "      <td>      11</td>\n",
        "      <td> 1</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>32</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  4</td>\n",
        "      <td>      21</td>\n",
        "      <td> 1</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>33</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  3</td>\n",
        "      <td>      12</td>\n",
        "      <td> 2</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>34</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  6</td>\n",
        "      <td>      27</td>\n",
        "      <td> 2</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>35</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  4</td>\n",
        "      <td>      42</td>\n",
        "      <td> 2</td>\n",
        "      <td> COLS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>36</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  8</td>\n",
        "      <td>       5</td>\n",
        "      <td> 2</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>37</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  8</td>\n",
        "      <td>      14</td>\n",
        "      <td> 2</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>38</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  8</td>\n",
        "      <td>      21</td>\n",
        "      <td> 2</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>39</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>       3</td>\n",
        "      <td> 1</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>40</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      18</td>\n",
        "      <td> 1</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>41</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      33</td>\n",
        "      <td> 1</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>42</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  6</td>\n",
        "      <td> Leaving</td>\n",
        "      <td> 1</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>43</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  4</td>\n",
        "      <td>      11</td>\n",
        "      <td> 1</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>44</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  8</td>\n",
        "      <td>      15</td>\n",
        "      <td> 1</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>45</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  3</td>\n",
        "      <td>       8</td>\n",
        "      <td> 2</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>46</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  6</td>\n",
        "      <td>      23</td>\n",
        "      <td> 2</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>47</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  4</td>\n",
        "      <td>      38</td>\n",
        "      <td> 2</td>\n",
        "      <td> SANL</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>48</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  8</td>\n",
        "      <td>       1</td>\n",
        "      <td> 2</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>49</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  8</td>\n",
        "      <td>      10</td>\n",
        "      <td> 2</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>50</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DALY</td>\n",
        "      <td> North</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  8</td>\n",
        "      <td>      17</td>\n",
        "      <td> 2</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>51</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>       6</td>\n",
        "      <td> 1</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>52</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      21</td>\n",
        "      <td> 1</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>53</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>   BLUE</td>\n",
        "      <td> DUBL</td>\n",
        "      <td> South</td>\n",
        "      <td> #0099cc</td>\n",
        "      <td>  4</td>\n",
        "      <td>      37</td>\n",
        "      <td> 1</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>54</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  6</td>\n",
        "      <td>       4</td>\n",
        "      <td> 1</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>55</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>  GREEN</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #339933</td>\n",
        "      <td>  4</td>\n",
        "      <td>      14</td>\n",
        "      <td> 1</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>56</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  8</td>\n",
        "      <td>      19</td>\n",
        "      <td> 1</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>57</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  3</td>\n",
        "      <td>       4</td>\n",
        "      <td> 2</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>58</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  6</td>\n",
        "      <td>      19</td>\n",
        "      <td> 2</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>59</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td>  4</td>\n",
        "      <td>      34</td>\n",
        "      <td> 2</td>\n",
        "      <td> BAYF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th></th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>497 rows \u00d7 10 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 11,
       "text": [
        "   bikeflag                    call_dt   color destination direction hexcolor  \\\n",
        "0         1  2014-05-27 14:45:07-07:00    BLUE        DALY     North  #0099cc   \n",
        "1         1  2014-05-27 14:45:07-07:00   GREEN        DALY     North  #339933   \n",
        "2         1  2014-05-27 14:45:07-07:00    BLUE        DALY     North  #0099cc   \n",
        "3         1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "4         1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "5         1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "6         1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "7         1  2014-05-27 14:45:07-07:00   GREEN        FRMT     South  #339933   \n",
        "8         1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "9         1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "10        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "11        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "12        1  2014-05-27 14:45:07-07:00   GREEN        DALY     North  #339933   \n",
        "13        1  2014-05-27 14:45:07-07:00    BLUE        DALY     North  #0099cc   \n",
        "14        1  2014-05-27 14:45:07-07:00   GREEN        DALY     North  #339933   \n",
        "15        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "16        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "17        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "18        1  2014-05-27 14:45:07-07:00   GREEN        FRMT     South  #339933   \n",
        "19        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "20        1  2014-05-27 14:45:07-07:00   GREEN        FRMT     South  #339933   \n",
        "21        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "22        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "23        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "24        1  2014-05-27 14:45:07-07:00   GREEN        DALY     North  #339933   \n",
        "25        1  2014-05-27 14:45:07-07:00    BLUE        DALY     North  #0099cc   \n",
        "26        1  2014-05-27 14:45:07-07:00   GREEN        DALY     North  #339933   \n",
        "27        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "28        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "29        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "30        1  2014-05-27 14:45:07-07:00   GREEN        FRMT     South  #339933   \n",
        "31        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "32        1  2014-05-27 14:45:07-07:00   GREEN        FRMT     South  #339933   \n",
        "33        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "34        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "35        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "36        1  2014-05-27 14:45:07-07:00    BLUE        DALY     North  #0099cc   \n",
        "37        1  2014-05-27 14:45:07-07:00   GREEN        DALY     North  #339933   \n",
        "38        1  2014-05-27 14:45:07-07:00    BLUE        DALY     North  #0099cc   \n",
        "39        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "40        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "41        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "42        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "43        1  2014-05-27 14:45:07-07:00   GREEN        FRMT     South  #339933   \n",
        "44        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "45        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "46        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "47        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "48        1  2014-05-27 14:45:07-07:00    BLUE        DALY     North  #0099cc   \n",
        "49        1  2014-05-27 14:45:07-07:00   GREEN        DALY     North  #339933   \n",
        "50        1  2014-05-27 14:45:07-07:00    BLUE        DALY     North  #0099cc   \n",
        "51        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "52        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "53        1  2014-05-27 14:45:07-07:00    BLUE        DUBL     South  #0099cc   \n",
        "54        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "55        1  2014-05-27 14:45:07-07:00   GREEN        FRMT     South  #339933   \n",
        "56        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "57        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "58        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "59        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "        ...                        ...     ...         ...       ...      ...   \n",
        "\n",
        "   length  minutes platform station  \n",
        "0       8        2        2    LAKE  \n",
        "1      10       10        2    LAKE  \n",
        "2       8       17        2    LAKE  \n",
        "3       4        7        1    LAKE  \n",
        "4       4       22        1    LAKE  \n",
        "5       4       37        1    LAKE  \n",
        "6       8        4        1    LAKE  \n",
        "7       4       14        1    LAKE  \n",
        "8       8       19        1    LAKE  \n",
        "9       3        5        2    LAKE  \n",
        "10      3       19        2    LAKE  \n",
        "11      6       34        2    LAKE  \n",
        "12     10        6        2    FTVL  \n",
        "13      8       12        2    FTVL  \n",
        "14      8       21        2    FTVL  \n",
        "15      4       10        1    FTVL  \n",
        "16      4       26        1    FTVL  \n",
        "17      4       41        1    FTVL  \n",
        "18      4        3        1    FTVL  \n",
        "19      8        8        1    FTVL  \n",
        "20      4       17        1    FTVL  \n",
        "21      3        1        2    FTVL  \n",
        "22      3       15        2    FTVL  \n",
        "23      6       30        2    FTVL  \n",
        "24     10        3        2    COLS  \n",
        "25      8        9        2    COLS  \n",
        "26      8       18        2    COLS  \n",
        "27      4       14        1    COLS  \n",
        "28      4       29        1    COLS  \n",
        "29      4       44        1    COLS  \n",
        "30      4        7        1    COLS  \n",
        "31      8       11        1    COLS  \n",
        "32      4       21        1    COLS  \n",
        "33      3       12        2    COLS  \n",
        "34      6       27        2    COLS  \n",
        "35      4       42        2    COLS  \n",
        "36      8        5        2    SANL  \n",
        "37      8       14        2    SANL  \n",
        "38      8       21        2    SANL  \n",
        "39      4        3        1    SANL  \n",
        "40      4       18        1    SANL  \n",
        "41      4       33        1    SANL  \n",
        "42      6  Leaving        1    SANL  \n",
        "43      4       11        1    SANL  \n",
        "44      8       15        1    SANL  \n",
        "45      3        8        2    SANL  \n",
        "46      6       23        2    SANL  \n",
        "47      4       38        2    SANL  \n",
        "48      8        1        2    BAYF  \n",
        "49      8       10        2    BAYF  \n",
        "50      8       17        2    BAYF  \n",
        "51      4        6        1    BAYF  \n",
        "52      4       21        1    BAYF  \n",
        "53      4       37        1    BAYF  \n",
        "54      6        4        1    BAYF  \n",
        "55      4       14        1    BAYF  \n",
        "56      8       19        1    BAYF  \n",
        "57      3        4        2    BAYF  \n",
        "58      6       19        2    BAYF  \n",
        "59      4       34        2    BAYF  \n",
        "      ...      ...      ...     ...  \n",
        "\n",
        "[497 rows x 10 columns]"
       ]
      }
     ],
     "prompt_number": 11
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# look up information for El Cerrito Plaza\n",
      "\n",
      "df[df.station == 'PLZA']"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>bikeflag</th>\n",
        "      <th>call_dt</th>\n",
        "      <th>color</th>\n",
        "      <th>destination</th>\n",
        "      <th>direction</th>\n",
        "      <th>hexcolor</th>\n",
        "      <th>length</th>\n",
        "      <th>minutes</th>\n",
        "      <th>platform</th>\n",
        "      <th>station</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>431</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td> 6</td>\n",
        "      <td> 13</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>432</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td> 6</td>\n",
        "      <td> 28</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>433</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td> 6</td>\n",
        "      <td> 43</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>434</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> MLBR</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 5</td>\n",
        "      <td>  5</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>435</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> MLBR</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 9</td>\n",
        "      <td> 20</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>436</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> MLBR</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 9</td>\n",
        "      <td> 35</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>437</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 5</td>\n",
        "      <td>  1</td>\n",
        "      <td> 1</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>438</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td> 3</td>\n",
        "      <td> 11</td>\n",
        "      <td> 1</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>439</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 5</td>\n",
        "      <td> 17</td>\n",
        "      <td> 1</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>9 rows \u00d7 10 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 12,
       "text": [
        "    bikeflag                    call_dt   color destination direction  \\\n",
        "431        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South   \n",
        "432        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South   \n",
        "433        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South   \n",
        "434        1  2014-05-27 14:45:07-07:00     RED        MLBR     South   \n",
        "435        1  2014-05-27 14:45:07-07:00     RED        MLBR     South   \n",
        "436        1  2014-05-27 14:45:07-07:00     RED        MLBR     South   \n",
        "437        1  2014-05-27 14:45:07-07:00     RED        RICH     North   \n",
        "438        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North   \n",
        "439        1  2014-05-27 14:45:07-07:00     RED        RICH     North   \n",
        "\n",
        "    hexcolor length minutes platform station  \n",
        "431  #ff9933      6      13        2    PLZA  \n",
        "432  #ff9933      6      28        2    PLZA  \n",
        "433  #ff9933      6      43        2    PLZA  \n",
        "434  #ff0000      5       5        2    PLZA  \n",
        "435  #ff0000      9      20        2    PLZA  \n",
        "436  #ff0000      9      35        2    PLZA  \n",
        "437  #ff0000      5       1        1    PLZA  \n",
        "438  #ff9933      3      11        1    PLZA  \n",
        "439  #ff0000      5      17        1    PLZA  \n",
        "\n",
        "[9 rows x 10 columns]"
       ]
      }
     ],
     "prompt_number": 12
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# Use someone else's BART API library\n",
      "\n",
      "* Now that we have some feel for the BART API, we now decide between:\n",
      "\n",
      "  * implementing more of the API ourselves in Python\n",
      "  * use someone else's library (if such libraries exist.)\n",
      "\n",
      "In the case of the BART API, there is: https://pypi.python.org/pypi/bart_api/0.1 ([github](https://github.com/projectdelphai/bart_api)) by Reuben Castelino\n",
      "\n",
      "Easiest way to use the library is to use `pip` from PyPi.  Should be able to do:\n",
      "\n",
      "    pip install bart_api\n",
      "    \n",
      "but as of 2014.05.25, the version doesn't work for Python 2.x.  The github version is more up-to-date. You can do installation from github (https://github.com/projectdelphai/bart_api):\n",
      "\n",
      "    pip install git+git://github.com/projectdelphai/bart_api.git\n",
      "\n",
      "I've made some changes so it might be helpful to use [my fork](https://github.com/rdhyee/bart_api) until my changes get folded back into the main project:\n",
      "\n",
      "     pip install git+git://github.com/rdhyee/bart_api.git\n"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "# Source code for bart_api\n",
      "\n",
      "https://github.com/projectdelphai/bart_api/blob/master/bart_api/__init__.py\n",
      "   \n",
      "   or\n",
      "    \n",
      "https://github.com/rdhyee/bart_api/blob/master/bart_api/__init__.py"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# example:  use the bart_api to calculate the number of active trains\n",
      "\n",
      "import bart_api \n",
      "reload(bart_api)\n",
      "\n",
      "bart = bart_api.BartApi()\n",
      "bart.number_of_trains()"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 13,
       "text": [
        "'52'"
       ]
      }
     ],
     "prompt_number": 13
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# stations\n",
      "\n",
      "station_list = bart.get_stations()\n",
      "station_list"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 14,
       "text": [
        "[{'abbr': '12TH',\n",
        "  'address': '1245 Broadway',\n",
        "  'city': 'Oakland',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.803664',\n",
        "  'gtfs_longitude': '-122.271604',\n",
        "  'name': '12th St. Oakland City Center',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94612'},\n",
        " {'abbr': '16TH',\n",
        "  'address': '2000 Mission Street',\n",
        "  'city': 'San Francisco',\n",
        "  'county': 'sanfrancisco',\n",
        "  'gtfs_latitude': '37.765062',\n",
        "  'gtfs_longitude': '-122.419694',\n",
        "  'name': '16th St. Mission',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94110'},\n",
        " {'abbr': '19TH',\n",
        "  'address': '1900 Broadway',\n",
        "  'city': 'Oakland',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.80787',\n",
        "  'gtfs_longitude': '-122.269029',\n",
        "  'name': '19th St. Oakland',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94612'},\n",
        " {'abbr': '24TH',\n",
        "  'address': '2800 Mission Street',\n",
        "  'city': 'San Francisco',\n",
        "  'county': 'sanfrancisco',\n",
        "  'gtfs_latitude': '37.752254',\n",
        "  'gtfs_longitude': '-122.418466',\n",
        "  'name': '24th St. Mission',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94110'},\n",
        " {'abbr': 'ASHB',\n",
        "  'address': '3100 Adeline Street',\n",
        "  'city': 'Berkeley',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.853024',\n",
        "  'gtfs_longitude': '-122.26978',\n",
        "  'name': 'Ashby',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94703'},\n",
        " {'abbr': 'BALB',\n",
        "  'address': '401 Geneva Avenue',\n",
        "  'city': 'San Francisco',\n",
        "  'county': 'sanfrancisco',\n",
        "  'gtfs_latitude': '37.72198087',\n",
        "  'gtfs_longitude': '-122.4474142',\n",
        "  'name': 'Balboa Park',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94112'},\n",
        " {'abbr': 'BAYF',\n",
        "  'address': '15242 Hesperian Blvd.',\n",
        "  'city': 'San Leandro',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.697185',\n",
        "  'gtfs_longitude': '-122.126871',\n",
        "  'name': 'Bay Fair',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94578'},\n",
        " {'abbr': 'CAST',\n",
        "  'address': '3301 Norbridge Dr.',\n",
        "  'city': 'Castro Valley',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.690754',\n",
        "  'gtfs_longitude': '-122.075567',\n",
        "  'name': 'Castro Valley',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94546'},\n",
        " {'abbr': 'CIVC',\n",
        "  'address': '1150 Market Street',\n",
        "  'city': 'San Francisco',\n",
        "  'county': 'sanfrancisco',\n",
        "  'gtfs_latitude': '37.779528',\n",
        "  'gtfs_longitude': '-122.413756',\n",
        "  'name': 'Civic Center/UN Plaza',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94102'},\n",
        " {'abbr': 'COLS',\n",
        "  'address': '7200 San Leandro St.',\n",
        "  'city': 'Oakland',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.754006',\n",
        "  'gtfs_longitude': '-122.197273',\n",
        "  'name': 'Coliseum/Oakland Airport',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94621'},\n",
        " {'abbr': 'COLM',\n",
        "  'address': '365 D Street',\n",
        "  'city': 'Colma',\n",
        "  'county': 'sanmateo',\n",
        "  'gtfs_latitude': '37.684638',\n",
        "  'gtfs_longitude': '-122.466233',\n",
        "  'name': 'Colma',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94014'},\n",
        " {'abbr': 'CONC',\n",
        "  'address': '1451 Oakland Avenue',\n",
        "  'city': 'Concord',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '37.973737',\n",
        "  'gtfs_longitude': '-122.029095',\n",
        "  'name': 'Concord',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94520'},\n",
        " {'abbr': 'DALY',\n",
        "  'address': '500 John Daly Blvd.',\n",
        "  'city': 'Daly City',\n",
        "  'county': 'sanmateo',\n",
        "  'gtfs_latitude': '37.70612055',\n",
        "  'gtfs_longitude': '-122.4690807',\n",
        "  'name': 'Daly City',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94014'},\n",
        " {'abbr': 'DBRK',\n",
        "  'address': '2160 Shattuck Avenue',\n",
        "  'city': 'Berkeley',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.869867',\n",
        "  'gtfs_longitude': '-122.268045',\n",
        "  'name': 'Downtown Berkeley',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94704'},\n",
        " {'abbr': 'DUBL',\n",
        "  'address': '5801 Owens Dr.',\n",
        "  'city': 'Pleasanton',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.701695',\n",
        "  'gtfs_longitude': '-121.900367',\n",
        "  'name': 'Dublin/Pleasanton',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94588'},\n",
        " {'abbr': 'DELN',\n",
        "  'address': '6400 Cutting Blvd.',\n",
        "  'city': 'El Cerrito',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '37.925655',\n",
        "  'gtfs_longitude': '-122.317269',\n",
        "  'name': 'El Cerrito del Norte',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94530'},\n",
        " {'abbr': 'PLZA',\n",
        "  'address': '6699 Fairmount Avenue',\n",
        "  'city': 'El Cerrito',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '37.9030588',\n",
        "  'gtfs_longitude': '-122.2992715',\n",
        "  'name': 'El Cerrito Plaza',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94530'},\n",
        " {'abbr': 'EMBR',\n",
        "  'address': '298 Market Street',\n",
        "  'city': 'San Francisco',\n",
        "  'county': 'sanfrancisco',\n",
        "  'gtfs_latitude': '37.792976',\n",
        "  'gtfs_longitude': '-122.396742',\n",
        "  'name': 'Embarcadero',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94111'},\n",
        " {'abbr': 'FRMT',\n",
        "  'address': '2000 BART Way',\n",
        "  'city': 'Fremont',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.557355',\n",
        "  'gtfs_longitude': '-121.9764',\n",
        "  'name': 'Fremont',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94536'},\n",
        " {'abbr': 'FTVL',\n",
        "  'address': '3401 East 12th Street',\n",
        "  'city': 'Oakland',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.774963',\n",
        "  'gtfs_longitude': '-122.224274',\n",
        "  'name': 'Fruitvale',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94601'},\n",
        " {'abbr': 'GLEN',\n",
        "  'address': '2901 Diamond Street',\n",
        "  'city': 'San Francisco',\n",
        "  'county': 'sanfrancisco',\n",
        "  'gtfs_latitude': '37.732921',\n",
        "  'gtfs_longitude': '-122.434092',\n",
        "  'name': 'Glen Park',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94131'},\n",
        " {'abbr': 'HAYW',\n",
        "  'address': \"699 'B' Street\",\n",
        "  'city': 'Hayward',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.670399',\n",
        "  'gtfs_longitude': '-122.087967',\n",
        "  'name': 'Hayward',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94541'},\n",
        " {'abbr': 'LAFY',\n",
        "  'address': '3601 Deer Hill Road',\n",
        "  'city': 'Lafayette',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '37.893394',\n",
        "  'gtfs_longitude': '-122.123801',\n",
        "  'name': 'Lafayette',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94549'},\n",
        " {'abbr': 'LAKE',\n",
        "  'address': '800 Madison Street',\n",
        "  'city': 'Oakland',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.797484',\n",
        "  'gtfs_longitude': '-122.265609',\n",
        "  'name': 'Lake Merritt',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94607'},\n",
        " {'abbr': 'MCAR',\n",
        "  'address': '555 40th Street',\n",
        "  'city': 'Oakland',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.828415',\n",
        "  'gtfs_longitude': '-122.267227',\n",
        "  'name': 'MacArthur',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94609'},\n",
        " {'abbr': 'MLBR',\n",
        "  'address': '200 North Rollins Road',\n",
        "  'city': 'Millbrae',\n",
        "  'county': 'sanmateo',\n",
        "  'gtfs_latitude': '37.599787',\n",
        "  'gtfs_longitude': '-122.38666',\n",
        "  'name': 'Millbrae',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94030'},\n",
        " {'abbr': 'MONT',\n",
        "  'address': '598 Market Street',\n",
        "  'city': 'San Francisco',\n",
        "  'county': 'sanfrancisco',\n",
        "  'gtfs_latitude': '37.789256',\n",
        "  'gtfs_longitude': '-122.401407',\n",
        "  'name': 'Montgomery St.',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94104'},\n",
        " {'abbr': 'NBRK',\n",
        "  'address': '1750 Sacramento Street',\n",
        "  'city': 'Berkeley',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.87404',\n",
        "  'gtfs_longitude': '-122.283451',\n",
        "  'name': 'North Berkeley',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94702'},\n",
        " {'abbr': 'NCON',\n",
        "  'address': '3700 Port Chicago Highway',\n",
        "  'city': 'Concord',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '38.003275',\n",
        "  'gtfs_longitude': '-122.024597',\n",
        "  'name': 'North Concord/Martinez',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94520'},\n",
        " {'abbr': 'ORIN',\n",
        "  'address': '11 Camino Pablo',\n",
        "  'city': 'Orinda',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '37.87836087',\n",
        "  'gtfs_longitude': '-122.1837911',\n",
        "  'name': 'Orinda',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94563'},\n",
        " {'abbr': 'PITT',\n",
        "  'address': '1700 West Leland Road',\n",
        "  'city': 'Pittsburg',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '38.018914',\n",
        "  'gtfs_longitude': '-121.945154',\n",
        "  'name': 'Pittsburg/Bay Point',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94565'},\n",
        " {'abbr': 'PHIL',\n",
        "  'address': '1365 Treat Blvd.',\n",
        "  'city': 'Walnut Creek',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '37.928403',\n",
        "  'gtfs_longitude': '-122.056013',\n",
        "  'name': 'Pleasant Hill/Contra Costa Centre',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94597'},\n",
        " {'abbr': 'POWL',\n",
        "  'address': '899 Market Street',\n",
        "  'city': 'San Francisco',\n",
        "  'county': 'sanfrancisco',\n",
        "  'gtfs_latitude': '37.784991',\n",
        "  'gtfs_longitude': '-122.406857',\n",
        "  'name': 'Powell St.',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94102'},\n",
        " {'abbr': 'RICH',\n",
        "  'address': '1700 Nevin Avenue',\n",
        "  'city': 'Richmond',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '37.936887',\n",
        "  'gtfs_longitude': '-122.353165',\n",
        "  'name': 'Richmond',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94801'},\n",
        " {'abbr': 'ROCK',\n",
        "  'address': '5660 College Avenue',\n",
        "  'city': 'Oakland',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.844601',\n",
        "  'gtfs_longitude': '-122.251793',\n",
        "  'name': 'Rockridge',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94618'},\n",
        " {'abbr': 'SBRN',\n",
        "  'address': '1151 Huntington Avenue',\n",
        "  'city': 'San Bruno',\n",
        "  'county': 'sanmateo',\n",
        "  'gtfs_latitude': '37.637753',\n",
        "  'gtfs_longitude': '-122.416038',\n",
        "  'name': 'San Bruno',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94066'},\n",
        " {'abbr': 'SFIA',\n",
        "  'address': 'International Terminal, Level 3',\n",
        "  'city': \"San Francisco Int'l Airport\",\n",
        "  'county': 'sanmateo',\n",
        "  'gtfs_latitude': '37.616035',\n",
        "  'gtfs_longitude': '-122.392612',\n",
        "  'name': \"San Francisco Int'l Airport\",\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94128'},\n",
        " {'abbr': 'SANL',\n",
        "  'address': '1401 San Leandro Blvd.',\n",
        "  'city': 'San Leandro',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.72261921',\n",
        "  'gtfs_longitude': '-122.1613112',\n",
        "  'name': 'San Leandro',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94577'},\n",
        " {'abbr': 'SHAY',\n",
        "  'address': '28601 Dixon Street',\n",
        "  'city': 'Hayward',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.63479954',\n",
        "  'gtfs_longitude': '-122.0575506',\n",
        "  'name': 'South Hayward',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94544'},\n",
        " {'abbr': 'SSAN',\n",
        "  'address': '1333 Mission Road',\n",
        "  'city': 'South San Francisco',\n",
        "  'county': 'sanmateo',\n",
        "  'gtfs_latitude': '37.664174',\n",
        "  'gtfs_longitude': '-122.444116',\n",
        "  'name': 'South San Francisco',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94080'},\n",
        " {'abbr': 'UCTY',\n",
        "  'address': '10 Union Square',\n",
        "  'city': 'Union City',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.591208',\n",
        "  'gtfs_longitude': '-122.017867',\n",
        "  'name': 'Union City',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94587'},\n",
        " {'abbr': 'WCRK',\n",
        "  'address': '200 Ygnacio Valley Road',\n",
        "  'city': 'Walnut Creek',\n",
        "  'county': 'contracosta',\n",
        "  'gtfs_latitude': '37.905628',\n",
        "  'gtfs_longitude': '-122.067423',\n",
        "  'name': 'Walnut Creek',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94596'},\n",
        " {'abbr': 'WDUB',\n",
        "  'address': '6501 Golden Gate Drive',\n",
        "  'city': 'Dublin',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.699759',\n",
        "  'gtfs_longitude': '-121.928099',\n",
        "  'name': 'West Dublin/Pleasanton',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94568'},\n",
        " {'abbr': 'WOAK',\n",
        "  'address': '1451 7th Street',\n",
        "  'city': 'Oakland',\n",
        "  'county': 'alameda',\n",
        "  'gtfs_latitude': '37.80467476',\n",
        "  'gtfs_longitude': '-122.2945822',\n",
        "  'name': 'West Oakland',\n",
        "  'state': 'CA',\n",
        "  'zipcode': '94607'}]"
       ]
      }
     ],
     "prompt_number": 14
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#routes = bart.routes(sched, date)\n",
      "# http://api.bart.gov/docs/route/routes.aspx\n",
      "# http://api.bart.gov/api/route.aspx?cmd=routes&key=MW9S-E7SL-26DU-VV8V\n",
      "\n",
      "routes = bart.routes(34, '05/27/2014')\n",
      "routes"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 15,
       "text": [
        "[{'abbr': 'PITT-SFIA',\n",
        "  'color': '#ffff33',\n",
        "  'name': 'Pittsburg/Bay Point - SFIA/Millbrae',\n",
        "  'number': '1',\n",
        "  'routeID': 'ROUTE 1'},\n",
        " {'abbr': 'DALY-DUBL',\n",
        "  'color': '#0099cc',\n",
        "  'name': 'Daly City - Dublin/Pleasanton',\n",
        "  'number': '12',\n",
        "  'routeID': 'ROUTE 12'},\n",
        " {'abbr': 'DALY-FRMT',\n",
        "  'color': '#339933',\n",
        "  'name': 'Daly City - Fremont',\n",
        "  'number': '6',\n",
        "  'routeID': 'ROUTE 6'},\n",
        " {'abbr': 'DUBL-DALY',\n",
        "  'color': '#0099cc',\n",
        "  'name': 'Dublin/Pleasanton - Daly City',\n",
        "  'number': '11',\n",
        "  'routeID': 'ROUTE 11'},\n",
        " {'abbr': 'FRMT-DALY',\n",
        "  'color': '#339933',\n",
        "  'name': 'Fremont - Daly City',\n",
        "  'number': '5',\n",
        "  'routeID': 'ROUTE 5'},\n",
        " {'abbr': 'FRMT-RICH',\n",
        "  'color': '#ff9933',\n",
        "  'name': 'Fremont - Richmond',\n",
        "  'number': '3',\n",
        "  'routeID': 'ROUTE 3'},\n",
        " {'abbr': 'MLBR-RICH',\n",
        "  'color': '#ff0000',\n",
        "  'name': 'Millbrae/Daly City - Richmond',\n",
        "  'number': '8',\n",
        "  'routeID': 'ROUTE 8'},\n",
        " {'abbr': 'RICH-FRMT',\n",
        "  'color': '#ff9933',\n",
        "  'name': 'Richmond - Fremont',\n",
        "  'number': '4',\n",
        "  'routeID': 'ROUTE 4'},\n",
        " {'abbr': 'RICH-MLBR',\n",
        "  'color': '#ff0000',\n",
        "  'name': 'Richmond - Daly City/Millbrae',\n",
        "  'number': '7',\n",
        "  'routeID': 'ROUTE 7'},\n",
        " {'abbr': 'SFIA-PITT',\n",
        "  'color': '#ffff33',\n",
        "  'name': 'Millbrae/SFIA - Pittsburg/Bay Point',\n",
        "  'number': '2',\n",
        "  'routeID': 'ROUTE 2'}]"
       ]
      }
     ],
     "prompt_number": 15
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# let's display the routes with the BART color coding\n",
      "# sorted by BART numbering\n",
      "# nice feature of the IPython notebook to able to use HTML\n",
      "\n",
      "from IPython.display import HTML\n",
      "import jinja2\n",
      "\n",
      "\n",
      "ROUTE_TEMPLATE = \"\"\"\n",
      "<div class=\"wrap\">\n",
      "<table>\n",
      " {% for item in items %}<tr>\n",
      " <td style=\"background-color:{{item.color}}\">{{item.name}}</td>\n",
      " <td>{{item.number}}</td>\n",
      " </tr>\n",
      " {% endfor %}\n",
      "</table>\n",
      "</div>\n",
      "\"\"\"\n",
      "\n",
      "template = jinja2.Template(ROUTE_TEMPLATE)\n",
      "\n",
      "HTML(template.render(items=sorted(routes, key=lambda r: int(r.get('number')))))"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "\n",
        "<div class=\"wrap\">\n",
        "<table>\n",
        " <tr>\n",
        " <td style=\"background-color:#ffff33\">Pittsburg/Bay Point - SFIA/Millbrae</td>\n",
        " <td>1</td>\n",
        " </tr>\n",
        " <tr>\n",
        " <td style=\"background-color:#ffff33\">Millbrae/SFIA - Pittsburg/Bay Point</td>\n",
        " <td>2</td>\n",
        " </tr>\n",
        " <tr>\n",
        " <td style=\"background-color:#ff9933\">Fremont - Richmond</td>\n",
        " <td>3</td>\n",
        " </tr>\n",
        " <tr>\n",
        " <td style=\"background-color:#ff9933\">Richmond - Fremont</td>\n",
        " <td>4</td>\n",
        " </tr>\n",
        " <tr>\n",
        " <td style=\"background-color:#339933\">Fremont - Daly City</td>\n",
        " <td>5</td>\n",
        " </tr>\n",
        " <tr>\n",
        " <td style=\"background-color:#339933\">Daly City - Fremont</td>\n",
        " <td>6</td>\n",
        " </tr>\n",
        " <tr>\n",
        " <td style=\"background-color:#ff0000\">Richmond - Daly City/Millbrae</td>\n",
        " <td>7</td>\n",
        " </tr>\n",
        " <tr>\n",
        " <td style=\"background-color:#ff0000\">Millbrae/Daly City - Richmond</td>\n",
        " <td>8</td>\n",
        " </tr>\n",
        " <tr>\n",
        " <td style=\"background-color:#0099cc\">Dublin/Pleasanton - Daly City</td>\n",
        " <td>11</td>\n",
        " </tr>\n",
        " <tr>\n",
        " <td style=\"background-color:#0099cc\">Daly City - Dublin/Pleasanton</td>\n",
        " <td>12</td>\n",
        " </tr>\n",
        " \n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 16,
       "text": [
        "<IPython.core.display.HTML at 0x106e6ef50>"
       ]
      }
     ],
     "prompt_number": 16
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# Pros and Cons of Writing your own library vs using someone else's\n",
      "\n",
      "* a chance to collaborate and improve on what's already there vs doing something different\n",
      "* sometime it takes a fair amount of work to understand other people's code.  (of course, sometimes hard to read one's own code!)\n"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# bart.get_route_schedule seems to be outdated\n",
      "# https://github.com/projectdelphai/bart_api/blob/5101e0deec452ddca2f76d0d6d97d6725080ae31/bart_api/__init__.py#L147\n",
      "\n",
      "\n",
      "bart.get_route_schedule('4')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 17,
       "text": [
        "{}"
       ]
      }
     ],
     "prompt_number": 17
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# http://api.bart.gov/docs/sched/routesched.aspx\n",
      "# The optional \"date\" and \"sched\" parameters should not be used together. \n",
      "# If they are, the date will be ignored, and the sched parameter will be used.\n",
      "\n",
      "# to get route 4 (Richmond->Fremont)\n",
      "# http://api.bart.gov/api/sched.aspx?cmd=routesched&route=4&key=MW9S-E7SL-26DU-VV8V\n",
      "\n",
      "def filter_none(d):\n",
      "    return dict([(k,v) for (k,v) in d.items() if v is not None])\n",
      "\n",
      "def route_schedule(route, sched=None, date=None, l=0, key=BART_API_KEY):\n",
      "    url = \"http://api.bart.gov/api/sched.aspx?\" +  \\\n",
      "        urllib.urlencode(filter_none({'cmd':'routesched',\n",
      "                          'route':route,\n",
      "                          'sched':sched,\n",
      "                          'date':date,\n",
      "                          'l':l,\n",
      "                          'key':key}))\n",
      "                                                                  \n",
      "    r = requests.get(url)\n",
      "    doc = fromstring(r.content)\n",
      "    return doc\n",
      "\n",
      "doc = route_schedule(4)\n",
      "doc\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 18,
       "text": [
        "<Element root at 0x106e8d0e0>"
       ]
      }
     ],
     "prompt_number": 18
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "print doc.find(\"date\").text, \"\\n\"\n",
      "\n",
      "for train in doc.findall('route/train'):\n",
      "    print train.attrib['index']\n",
      "    for stop in train.iterchildren():\n",
      "        print stop.attrib['station'], stop.attrib['origTime']\n",
      "    print"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "5/27/2014 \n",
        "\n",
        "1\n",
        "RICH 4:20 AM\n",
        "DELN 4:24 AM\n",
        "PLZA 4:27 AM\n",
        "NBRK 4:30 AM\n",
        "DBRK 4:33 AM\n",
        "ASHB 4:35 AM\n",
        "MCAR 4:38 AM\n",
        "19TH 4:44 AM\n",
        "12TH 4:45 AM\n",
        "LAKE 4:48 AM\n",
        "FTVL 4:52 AM\n",
        "COLS 4:55 AM\n",
        "SANL 4:59 AM\n",
        "BAYF 5:03 AM\n",
        "HAYW 5:07 AM\n",
        "SHAY 5:11 AM\n",
        "UCTY 5:16 AM\n",
        "FRMT 5:21 AM\n",
        "\n",
        "2\n",
        "RICH 4:35 AM\n",
        "DELN 4:39 AM\n",
        "PLZA 4:42 AM\n",
        "NBRK 4:45 AM\n",
        "DBRK 4:48 AM\n",
        "ASHB 4:50 AM\n",
        "MCAR 4:53 AM\n",
        "19TH 4:59 AM\n",
        "12TH 5:00 AM\n",
        "LAKE 5:03 AM\n",
        "FTVL 5:07 AM\n",
        "COLS 5:10 AM\n",
        "SANL 5:14 AM\n",
        "BAYF 5:18 AM\n",
        "HAYW 5:22 AM\n",
        "SHAY 5:26 AM\n",
        "UCTY 5:31 AM\n",
        "FRMT 5:36 AM\n",
        "\n",
        "3\n",
        "RICH 4:50 AM\n",
        "DELN 4:54 AM\n",
        "PLZA 4:57 AM\n",
        "NBRK 5:00 AM\n",
        "DBRK 5:03 AM\n",
        "ASHB 5:05 AM\n",
        "MCAR 5:08 AM\n",
        "19TH 5:14 AM\n",
        "12TH 5:15 AM\n",
        "LAKE 5:18 AM\n",
        "FTVL 5:22 AM\n",
        "COLS 5:25 AM\n",
        "SANL 5:29 AM\n",
        "BAYF 5:33 AM\n",
        "HAYW 5:37 AM\n",
        "SHAY 5:41 AM\n",
        "UCTY 5:46 AM\n",
        "FRMT 5:51 AM\n",
        "\n",
        "4\n",
        "RICH 5:05 AM\n",
        "DELN 5:09 AM\n",
        "PLZA 5:12 AM\n",
        "NBRK 5:15 AM\n",
        "DBRK 5:18 AM\n",
        "ASHB 5:20 AM\n",
        "MCAR 5:23 AM\n",
        "19TH 5:29 AM\n",
        "12TH 5:30 AM\n",
        "LAKE 5:33 AM\n",
        "FTVL 5:37 AM\n",
        "COLS 5:40 AM\n",
        "SANL 5:44 AM\n",
        "BAYF 5:48 AM\n",
        "HAYW 5:52 AM\n",
        "SHAY 5:56 AM\n",
        "UCTY 6:01 AM\n",
        "FRMT 6:06 AM\n",
        "\n",
        "5\n",
        "RICH 5:20 AM\n",
        "DELN 5:24 AM\n",
        "PLZA 5:27 AM\n",
        "NBRK 5:30 AM\n",
        "DBRK 5:33 AM\n",
        "ASHB 5:35 AM\n",
        "MCAR 5:38 AM\n",
        "19TH 5:44 AM\n",
        "12TH 5:45 AM\n",
        "LAKE 5:48 AM\n",
        "FTVL 5:52 AM\n",
        "COLS 5:55 AM\n",
        "SANL 5:59 AM\n",
        "BAYF 6:03 AM\n",
        "HAYW 6:07 AM\n",
        "SHAY 6:11 AM\n",
        "UCTY 6:16 AM\n",
        "FRMT 6:21 AM\n",
        "\n",
        "6\n",
        "RICH 5:35 AM\n",
        "DELN 5:39 AM\n",
        "PLZA 5:42 AM\n",
        "NBRK 5:45 AM\n",
        "DBRK 5:48 AM\n",
        "ASHB 5:50 AM\n",
        "MCAR 5:53 AM\n",
        "19TH 5:59 AM\n",
        "12TH 6:00 AM\n",
        "LAKE 6:03 AM\n",
        "FTVL 6:07 AM\n",
        "COLS 6:10 AM\n",
        "SANL 6:14 AM\n",
        "BAYF 6:18 AM\n",
        "HAYW 6:22 AM\n",
        "SHAY 6:26 AM\n",
        "UCTY 6:31 AM\n",
        "FRMT 6:36 AM\n",
        "\n",
        "7\n",
        "RICH 5:50 AM\n",
        "DELN 5:54 AM\n",
        "PLZA 5:57 AM\n",
        "NBRK 6:00 AM\n",
        "DBRK 6:03 AM\n",
        "ASHB 6:05 AM\n",
        "MCAR 6:08 AM\n",
        "19TH 6:14 AM\n",
        "12TH 6:15 AM\n",
        "LAKE 6:18 AM\n",
        "FTVL 6:22 AM\n",
        "COLS 6:25 AM\n",
        "SANL 6:29 AM\n",
        "BAYF 6:33 AM\n",
        "HAYW 6:37 AM\n",
        "SHAY 6:41 AM\n",
        "UCTY 6:46 AM\n",
        "FRMT 6:51 AM\n",
        "\n",
        "8\n",
        "RICH 6:05 AM\n",
        "DELN 6:09 AM\n",
        "PLZA 6:12 AM\n",
        "NBRK 6:15 AM\n",
        "DBRK 6:18 AM\n",
        "ASHB 6:20 AM\n",
        "MCAR 6:23 AM\n",
        "19TH 6:29 AM\n",
        "12TH 6:30 AM\n",
        "LAKE 6:33 AM\n",
        "FTVL 6:37 AM\n",
        "COLS 6:40 AM\n",
        "SANL 6:44 AM\n",
        "BAYF 6:48 AM\n",
        "HAYW 6:52 AM\n",
        "SHAY 6:56 AM\n",
        "UCTY 7:01 AM\n",
        "FRMT 7:06 AM\n",
        "\n",
        "9\n",
        "RICH 6:20 AM\n",
        "DELN 6:24 AM\n",
        "PLZA 6:27 AM\n",
        "NBRK 6:30 AM\n",
        "DBRK 6:33 AM\n",
        "ASHB 6:35 AM\n",
        "MCAR 6:38 AM\n",
        "19TH 6:44 AM\n",
        "12TH 6:45 AM\n",
        "LAKE 6:48 AM\n",
        "FTVL 6:52 AM\n",
        "COLS 6:55 AM\n",
        "SANL 6:59 AM\n",
        "BAYF 7:03 AM\n",
        "HAYW 7:07 AM\n",
        "SHAY 7:11 AM\n",
        "UCTY 7:16 AM\n",
        "FRMT 7:21 AM\n",
        "\n",
        "10\n",
        "RICH 6:35 AM\n",
        "DELN 6:39 AM\n",
        "PLZA 6:42 AM\n",
        "NBRK 6:45 AM\n",
        "DBRK 6:48 AM\n",
        "ASHB 6:50 AM\n",
        "MCAR 6:53 AM\n",
        "19TH 6:59 AM\n",
        "12TH 7:00 AM\n",
        "LAKE 7:03 AM\n",
        "FTVL 7:07 AM\n",
        "COLS 7:10 AM\n",
        "SANL 7:14 AM\n",
        "BAYF 7:18 AM\n",
        "HAYW 7:22 AM\n",
        "SHAY 7:26 AM\n",
        "UCTY 7:31 AM\n",
        "FRMT 7:36 AM\n",
        "\n",
        "11\n",
        "RICH 6:50 AM\n",
        "DELN 6:54 AM\n",
        "PLZA 6:57 AM\n",
        "NBRK 7:00 AM\n",
        "DBRK 7:03 AM\n",
        "ASHB 7:05 AM\n",
        "MCAR 7:08 AM\n",
        "19TH 7:14 AM\n",
        "12TH 7:15 AM\n",
        "LAKE 7:18 AM\n",
        "FTVL 7:22 AM\n",
        "COLS 7:25 AM\n",
        "SANL 7:29 AM\n",
        "BAYF 7:33 AM\n",
        "HAYW 7:37 AM\n",
        "SHAY 7:41 AM\n",
        "UCTY 7:46 AM\n",
        "FRMT 7:51 AM\n",
        "\n",
        "12\n",
        "RICH 7:05 AM\n",
        "DELN 7:09 AM\n",
        "PLZA 7:12 AM\n",
        "NBRK 7:15 AM\n",
        "DBRK 7:18 AM\n",
        "ASHB 7:20 AM\n",
        "MCAR 7:23 AM\n",
        "19TH 7:29 AM\n",
        "12TH 7:30 AM\n",
        "LAKE 7:33 AM\n",
        "FTVL 7:37 AM\n",
        "COLS 7:40 AM\n",
        "SANL 7:44 AM\n",
        "BAYF 7:48 AM\n",
        "HAYW 7:52 AM\n",
        "SHAY 7:56 AM\n",
        "UCTY 8:01 AM\n",
        "FRMT 8:06 AM\n",
        "\n",
        "13\n",
        "RICH 7:20 AM\n",
        "DELN 7:24 AM\n",
        "PLZA 7:27 AM\n",
        "NBRK 7:30 AM\n",
        "DBRK 7:33 AM\n",
        "ASHB 7:35 AM\n",
        "MCAR 7:38 AM\n",
        "19TH 7:44 AM\n",
        "12TH 7:45 AM\n",
        "LAKE 7:48 AM\n",
        "FTVL 7:52 AM\n",
        "COLS 7:55 AM\n",
        "SANL 7:59 AM\n",
        "BAYF 8:03 AM\n",
        "HAYW 8:07 AM\n",
        "SHAY 8:11 AM\n",
        "UCTY 8:16 AM\n",
        "FRMT 8:21 AM\n",
        "\n",
        "14\n",
        "RICH 7:35 AM\n",
        "DELN 7:39 AM\n",
        "PLZA 7:42 AM\n",
        "NBRK 7:45 AM\n",
        "DBRK 7:48 AM\n",
        "ASHB 7:50 AM\n",
        "MCAR 7:53 AM\n",
        "19TH 7:59 AM\n",
        "12TH 8:00 AM\n",
        "LAKE 8:03 AM\n",
        "FTVL 8:07 AM\n",
        "COLS 8:10 AM\n",
        "SANL 8:14 AM\n",
        "BAYF 8:18 AM\n",
        "HAYW 8:22 AM\n",
        "SHAY 8:26 AM\n",
        "UCTY 8:31 AM\n",
        "FRMT 8:36 AM\n",
        "\n",
        "15\n",
        "RICH 7:50 AM\n",
        "DELN 7:54 AM\n",
        "PLZA 7:57 AM\n",
        "NBRK 8:00 AM\n",
        "DBRK 8:03 AM\n",
        "ASHB 8:05 AM\n",
        "MCAR 8:08 AM\n",
        "19TH 8:14 AM\n",
        "12TH 8:15 AM\n",
        "LAKE 8:18 AM\n",
        "FTVL 8:22 AM\n",
        "COLS 8:25 AM\n",
        "SANL 8:29 AM\n",
        "BAYF 8:33 AM\n",
        "HAYW 8:37 AM\n",
        "SHAY 8:41 AM\n",
        "UCTY 8:46 AM\n",
        "FRMT 8:51 AM\n",
        "\n",
        "16\n",
        "RICH 8:05 AM\n",
        "DELN 8:09 AM\n",
        "PLZA 8:12 AM\n",
        "NBRK 8:15 AM\n",
        "DBRK 8:18 AM\n",
        "ASHB 8:20 AM\n",
        "MCAR 8:23 AM\n",
        "19TH 8:29 AM\n",
        "12TH 8:30 AM\n",
        "LAKE 8:33 AM\n",
        "FTVL 8:37 AM\n",
        "COLS 8:40 AM\n",
        "SANL 8:44 AM\n",
        "BAYF 8:48 AM\n",
        "HAYW 8:52 AM\n",
        "SHAY 8:56 AM\n",
        "UCTY 9:01 AM\n",
        "FRMT 9:06 AM\n",
        "\n",
        "17\n",
        "RICH 8:20 AM\n",
        "DELN 8:24 AM\n",
        "PLZA 8:27 AM\n",
        "NBRK 8:30 AM\n",
        "DBRK 8:33 AM\n",
        "ASHB 8:35 AM\n",
        "MCAR 8:38 AM\n",
        "19TH 8:44 AM\n",
        "12TH 8:45 AM\n",
        "LAKE 8:48 AM\n",
        "FTVL 8:52 AM\n",
        "COLS 8:55 AM\n",
        "SANL 8:59 AM\n",
        "BAYF 9:03 AM\n",
        "HAYW 9:07 AM\n",
        "SHAY 9:11 AM\n",
        "UCTY 9:16 AM\n",
        "FRMT 9:21 AM\n",
        "\n",
        "18\n",
        "RICH 8:35 AM\n",
        "DELN 8:39 AM\n",
        "PLZA 8:42 AM\n",
        "NBRK 8:45 AM\n",
        "DBRK 8:48 AM\n",
        "ASHB 8:50 AM\n",
        "MCAR 8:53 AM\n",
        "19TH 8:59 AM\n",
        "12TH 9:00 AM\n",
        "LAKE 9:03 AM\n",
        "FTVL 9:07 AM\n",
        "COLS 9:10 AM\n",
        "SANL 9:14 AM\n",
        "BAYF 9:18 AM\n",
        "HAYW 9:22 AM\n",
        "SHAY 9:26 AM\n",
        "UCTY 9:31 AM\n",
        "FRMT 9:36 AM\n",
        "\n",
        "19\n",
        "RICH 8:50 AM\n",
        "DELN 8:54 AM\n",
        "PLZA 8:57 AM\n",
        "NBRK 9:00 AM\n",
        "DBRK 9:03 AM\n",
        "ASHB 9:05 AM\n",
        "MCAR 9:08 AM\n",
        "19TH 9:14 AM\n",
        "12TH 9:15 AM\n",
        "LAKE 9:18 AM\n",
        "FTVL 9:22 AM\n",
        "COLS 9:25 AM\n",
        "SANL 9:29 AM\n",
        "BAYF 9:33 AM\n",
        "HAYW 9:37 AM\n",
        "SHAY 9:41 AM\n",
        "UCTY 9:46 AM\n",
        "FRMT 9:51 AM\n",
        "\n",
        "20\n",
        "RICH 9:05 AM\n",
        "DELN 9:09 AM\n",
        "PLZA 9:12 AM\n",
        "NBRK 9:15 AM\n",
        "DBRK 9:18 AM\n",
        "ASHB 9:20 AM\n",
        "MCAR 9:23 AM\n",
        "19TH 9:29 AM\n",
        "12TH 9:30 AM\n",
        "LAKE 9:33 AM\n",
        "FTVL 9:37 AM\n",
        "COLS 9:40 AM\n",
        "SANL 9:44 AM\n",
        "BAYF 9:48 AM\n",
        "HAYW 9:52 AM\n",
        "SHAY 9:56 AM\n",
        "UCTY 10:01 AM\n",
        "FRMT 10:06 AM\n",
        "\n",
        "21\n",
        "RICH 9:20 AM\n",
        "DELN 9:24 AM\n",
        "PLZA 9:27 AM\n",
        "NBRK 9:30 AM\n",
        "DBRK 9:33 AM\n",
        "ASHB 9:35 AM\n",
        "MCAR 9:38 AM\n",
        "19TH 9:44 AM\n",
        "12TH 9:45 AM\n",
        "LAKE 9:48 AM\n",
        "FTVL 9:52 AM\n",
        "COLS 9:55 AM\n",
        "SANL 9:59 AM\n",
        "BAYF 10:03 AM\n",
        "HAYW 10:07 AM\n",
        "SHAY 10:11 AM\n",
        "UCTY 10:16 AM\n",
        "FRMT 10:21 AM\n",
        "\n",
        "22\n",
        "RICH 9:35 AM\n",
        "DELN 9:39 AM\n",
        "PLZA 9:42 AM\n",
        "NBRK 9:45 AM\n",
        "DBRK 9:48 AM\n",
        "ASHB 9:50 AM\n",
        "MCAR 9:53 AM\n",
        "19TH 9:59 AM\n",
        "12TH 10:00 AM\n",
        "LAKE 10:03 AM\n",
        "FTVL 10:07 AM\n",
        "COLS 10:10 AM\n",
        "SANL 10:14 AM\n",
        "BAYF 10:18 AM\n",
        "HAYW 10:22 AM\n",
        "SHAY 10:26 AM\n",
        "UCTY 10:31 AM\n",
        "FRMT 10:36 AM\n",
        "\n",
        "23\n",
        "RICH 9:50 AM\n",
        "DELN 9:54 AM\n",
        "PLZA 9:57 AM\n",
        "NBRK 10:00 AM\n",
        "DBRK 10:03 AM\n",
        "ASHB 10:05 AM\n",
        "MCAR 10:08 AM\n",
        "19TH 10:14 AM\n",
        "12TH 10:15 AM\n",
        "LAKE 10:18 AM\n",
        "FTVL 10:22 AM\n",
        "COLS 10:25 AM\n",
        "SANL 10:29 AM\n",
        "BAYF 10:33 AM\n",
        "HAYW 10:37 AM\n",
        "SHAY 10:41 AM\n",
        "UCTY 10:46 AM\n",
        "FRMT 10:51 AM\n",
        "\n",
        "24\n",
        "RICH 10:05 AM\n",
        "DELN 10:09 AM\n",
        "PLZA 10:12 AM\n",
        "NBRK 10:15 AM\n",
        "DBRK 10:18 AM\n",
        "ASHB 10:20 AM\n",
        "MCAR 10:23 AM\n",
        "19TH 10:29 AM\n",
        "12TH 10:30 AM\n",
        "LAKE 10:33 AM\n",
        "FTVL 10:37 AM\n",
        "COLS 10:40 AM\n",
        "SANL 10:44 AM\n",
        "BAYF 10:48 AM\n",
        "HAYW 10:52 AM\n",
        "SHAY 10:56 AM\n",
        "UCTY 11:01 AM\n",
        "FRMT 11:06 AM\n",
        "\n",
        "25\n",
        "RICH 10:20 AM\n",
        "DELN 10:24 AM\n",
        "PLZA 10:27 AM\n",
        "NBRK 10:30 AM\n",
        "DBRK 10:33 AM\n",
        "ASHB 10:35 AM\n",
        "MCAR 10:38 AM\n",
        "19TH 10:44 AM\n",
        "12TH 10:45 AM\n",
        "LAKE 10:48 AM\n",
        "FTVL 10:52 AM\n",
        "COLS 10:55 AM\n",
        "SANL 10:59 AM\n",
        "BAYF 11:03 AM\n",
        "HAYW 11:07 AM\n",
        "SHAY 11:11 AM\n",
        "UCTY 11:16 AM\n",
        "FRMT 11:21 AM\n",
        "\n",
        "26\n",
        "RICH 10:35 AM\n",
        "DELN 10:39 AM\n",
        "PLZA 10:42 AM\n",
        "NBRK 10:45 AM\n",
        "DBRK 10:48 AM\n",
        "ASHB 10:50 AM\n",
        "MCAR 10:53 AM\n",
        "19TH 10:59 AM\n",
        "12TH 11:00 AM\n",
        "LAKE 11:03 AM\n",
        "FTVL 11:07 AM\n",
        "COLS 11:10 AM\n",
        "SANL 11:14 AM\n",
        "BAYF 11:18 AM\n",
        "HAYW 11:22 AM\n",
        "SHAY 11:26 AM\n",
        "UCTY 11:31 AM\n",
        "FRMT 11:36 AM\n",
        "\n",
        "27\n",
        "RICH 10:50 AM\n",
        "DELN 10:54 AM\n",
        "PLZA 10:57 AM\n",
        "NBRK 11:00 AM\n",
        "DBRK 11:03 AM\n",
        "ASHB 11:05 AM\n",
        "MCAR 11:08 AM\n",
        "19TH 11:14 AM\n",
        "12TH 11:15 AM\n",
        "LAKE 11:18 AM\n",
        "FTVL 11:22 AM\n",
        "COLS 11:25 AM\n",
        "SANL 11:29 AM\n",
        "BAYF 11:33 AM\n",
        "HAYW 11:37 AM\n",
        "SHAY 11:41 AM\n",
        "UCTY 11:46 AM\n",
        "FRMT 11:51 AM\n",
        "\n",
        "28\n",
        "RICH 11:05 AM\n",
        "DELN 11:09 AM\n",
        "PLZA 11:12 AM\n",
        "NBRK 11:15 AM\n",
        "DBRK 11:18 AM\n",
        "ASHB 11:20 AM\n",
        "MCAR 11:23 AM\n",
        "19TH 11:29 AM\n",
        "12TH 11:30 AM\n",
        "LAKE 11:33 AM\n",
        "FTVL 11:37 AM\n",
        "COLS 11:40 AM\n",
        "SANL 11:44 AM\n",
        "BAYF 11:48 AM\n",
        "HAYW 11:52 AM\n",
        "SHAY 11:56 AM\n",
        "UCTY 12:01 PM\n",
        "FRMT 12:06 PM\n",
        "\n",
        "29\n",
        "RICH 11:20 AM\n",
        "DELN 11:24 AM\n",
        "PLZA 11:27 AM\n",
        "NBRK 11:30 AM\n",
        "DBRK 11:33 AM\n",
        "ASHB 11:35 AM\n",
        "MCAR 11:38 AM\n",
        "19TH 11:44 AM\n",
        "12TH 11:45 AM\n",
        "LAKE 11:48 AM\n",
        "FTVL 11:52 AM\n",
        "COLS 11:55 AM\n",
        "SANL 11:59 AM\n",
        "BAYF 12:03 PM\n",
        "HAYW 12:07 PM\n",
        "SHAY 12:11 PM\n",
        "UCTY 12:16 PM\n",
        "FRMT 12:21 PM\n",
        "\n",
        "30\n",
        "RICH 11:35 AM\n",
        "DELN 11:39 AM\n",
        "PLZA 11:42 AM\n",
        "NBRK 11:45 AM\n",
        "DBRK 11:48 AM\n",
        "ASHB 11:50 AM\n",
        "MCAR 11:53 AM\n",
        "19TH 11:59 AM\n",
        "12TH 12:00 PM\n",
        "LAKE 12:03 PM\n",
        "FTVL 12:07 PM\n",
        "COLS 12:10 PM\n",
        "SANL 12:14 PM\n",
        "BAYF 12:18 PM\n",
        "HAYW 12:22 PM\n",
        "SHAY 12:26 PM\n",
        "UCTY 12:31 PM\n",
        "FRMT 12:36 PM\n",
        "\n",
        "31\n",
        "RICH 11:50 AM\n",
        "DELN 11:54 AM\n",
        "PLZA 11:57 AM\n",
        "NBRK 12:00 PM\n",
        "DBRK 12:03 PM\n",
        "ASHB 12:05 PM\n",
        "MCAR 12:08 PM\n",
        "19TH 12:14 PM\n",
        "12TH 12:15 PM\n",
        "LAKE 12:18 PM\n",
        "FTVL 12:22 PM\n",
        "COLS 12:25 PM\n",
        "SANL 12:29 PM\n",
        "BAYF 12:33 PM\n",
        "HAYW 12:37 PM\n",
        "SHAY 12:41 PM\n",
        "UCTY 12:46 PM\n",
        "FRMT 12:51 PM\n",
        "\n",
        "32\n",
        "RICH 12:05 PM\n",
        "DELN 12:09 PM\n",
        "PLZA 12:12 PM\n",
        "NBRK 12:15 PM\n",
        "DBRK 12:18 PM\n",
        "ASHB 12:20 PM\n",
        "MCAR 12:23 PM\n",
        "19TH 12:29 PM\n",
        "12TH 12:30 PM\n",
        "LAKE 12:33 PM\n",
        "FTVL 12:37 PM\n",
        "COLS 12:40 PM\n",
        "SANL 12:44 PM\n",
        "BAYF 12:48 PM\n",
        "HAYW 12:52 PM\n",
        "SHAY 12:56 PM\n",
        "UCTY 1:01 PM\n",
        "FRMT 1:06 PM\n",
        "\n",
        "33\n",
        "RICH 12:20 PM\n",
        "DELN 12:24 PM\n",
        "PLZA 12:27 PM\n",
        "NBRK 12:30 PM\n",
        "DBRK 12:33 PM\n",
        "ASHB 12:35 PM\n",
        "MCAR 12:38 PM\n",
        "19TH 12:44 PM\n",
        "12TH 12:45 PM\n",
        "LAKE 12:48 PM\n",
        "FTVL 12:52 PM\n",
        "COLS 12:55 PM\n",
        "SANL 12:59 PM\n",
        "BAYF 1:03 PM\n",
        "HAYW 1:07 PM\n",
        "SHAY 1:11 PM\n",
        "UCTY 1:16 PM\n",
        "FRMT 1:21 PM\n",
        "\n",
        "34\n",
        "RICH 12:35 PM\n",
        "DELN 12:39 PM\n",
        "PLZA 12:42 PM\n",
        "NBRK 12:45 PM\n",
        "DBRK 12:48 PM\n",
        "ASHB 12:50 PM\n",
        "MCAR 12:53 PM\n",
        "19TH 12:59 PM\n",
        "12TH 1:00 PM\n",
        "LAKE 1:03 PM\n",
        "FTVL 1:07 PM\n",
        "COLS 1:10 PM\n",
        "SANL 1:14 PM\n",
        "BAYF 1:18 PM\n",
        "HAYW 1:22 PM\n",
        "SHAY 1:26 PM\n",
        "UCTY 1:31 PM\n",
        "FRMT 1:36 PM\n",
        "\n",
        "35\n",
        "RICH 12:50 PM\n",
        "DELN 12:54 PM\n",
        "PLZA 12:57 PM\n",
        "NBRK 1:00 PM\n",
        "DBRK 1:03 PM\n",
        "ASHB 1:05 PM\n",
        "MCAR 1:08 PM\n",
        "19TH 1:14 PM\n",
        "12TH 1:15 PM\n",
        "LAKE 1:18 PM\n",
        "FTVL 1:22 PM\n",
        "COLS 1:25 PM\n",
        "SANL 1:29 PM\n",
        "BAYF 1:33 PM\n",
        "HAYW 1:37 PM\n",
        "SHAY 1:41 PM\n",
        "UCTY 1:46 PM\n",
        "FRMT 1:51 PM\n",
        "\n",
        "36\n",
        "RICH 1:05 PM\n",
        "DELN 1:09 PM\n",
        "PLZA 1:12 PM\n",
        "NBRK 1:15 PM\n",
        "DBRK 1:18 PM\n",
        "ASHB 1:20 PM\n",
        "MCAR 1:23 PM\n",
        "19TH 1:29 PM\n",
        "12TH 1:30 PM\n",
        "LAKE 1:33 PM\n",
        "FTVL 1:37 PM\n",
        "COLS 1:40 PM\n",
        "SANL 1:44 PM\n",
        "BAYF 1:48 PM\n",
        "HAYW 1:52 PM\n",
        "SHAY 1:56 PM\n",
        "UCTY 2:01 PM\n",
        "FRMT 2:06 PM\n",
        "\n",
        "37\n",
        "RICH 1:20 PM\n",
        "DELN 1:24 PM\n",
        "PLZA 1:27 PM\n",
        "NBRK 1:30 PM\n",
        "DBRK 1:33 PM\n",
        "ASHB 1:35 PM\n",
        "MCAR 1:38 PM\n",
        "19TH 1:44 PM\n",
        "12TH 1:45 PM\n",
        "LAKE 1:48 PM\n",
        "FTVL 1:52 PM\n",
        "COLS 1:55 PM\n",
        "SANL 1:59 PM\n",
        "BAYF 2:03 PM\n",
        "HAYW 2:07 PM\n",
        "SHAY 2:11 PM\n",
        "UCTY 2:16 PM\n",
        "FRMT 2:21 PM\n",
        "\n",
        "38\n",
        "RICH 1:35 PM\n",
        "DELN 1:39 PM\n",
        "PLZA 1:42 PM\n",
        "NBRK 1:45 PM\n",
        "DBRK 1:48 PM\n",
        "ASHB 1:50 PM\n",
        "MCAR 1:53 PM\n",
        "19TH 1:59 PM\n",
        "12TH 2:00 PM\n",
        "LAKE 2:03 PM\n",
        "FTVL 2:07 PM\n",
        "COLS 2:10 PM\n",
        "SANL 2:14 PM\n",
        "BAYF 2:18 PM\n",
        "HAYW 2:22 PM\n",
        "SHAY 2:26 PM\n",
        "UCTY 2:31 PM\n",
        "FRMT 2:36 PM\n",
        "\n",
        "39\n",
        "RICH 1:50 PM\n",
        "DELN 1:54 PM\n",
        "PLZA 1:57 PM\n",
        "NBRK 2:00 PM\n",
        "DBRK 2:03 PM\n",
        "ASHB 2:05 PM\n",
        "MCAR 2:08 PM\n",
        "19TH 2:14 PM\n",
        "12TH 2:15 PM\n",
        "LAKE 2:18 PM\n",
        "FTVL 2:22 PM\n",
        "COLS 2:25 PM\n",
        "SANL 2:29 PM\n",
        "BAYF 2:33 PM\n",
        "HAYW 2:37 PM\n",
        "SHAY 2:41 PM\n",
        "UCTY 2:46 PM\n",
        "FRMT 2:51 PM\n",
        "\n",
        "40\n",
        "RICH 2:05 PM\n",
        "DELN 2:09 PM\n",
        "PLZA 2:12 PM\n",
        "NBRK 2:15 PM\n",
        "DBRK 2:18 PM\n",
        "ASHB 2:20 PM\n",
        "MCAR 2:23 PM\n",
        "19TH 2:29 PM\n",
        "12TH 2:30 PM\n",
        "LAKE 2:33 PM\n",
        "FTVL 2:37 PM\n",
        "COLS 2:40 PM\n",
        "SANL 2:44 PM\n",
        "BAYF 2:48 PM\n",
        "HAYW 2:52 PM\n",
        "SHAY 2:56 PM\n",
        "UCTY 3:01 PM\n",
        "FRMT 3:06 PM\n",
        "\n",
        "41\n",
        "RICH 2:20 PM\n",
        "DELN 2:24 PM\n",
        "PLZA 2:27 PM\n",
        "NBRK 2:30 PM\n",
        "DBRK 2:33 PM\n",
        "ASHB 2:35 PM\n",
        "MCAR 2:38 PM\n",
        "19TH 2:44 PM\n",
        "12TH 2:45 PM\n",
        "LAKE 2:48 PM\n",
        "FTVL 2:52 PM\n",
        "COLS 2:55 PM\n",
        "SANL 2:59 PM\n",
        "BAYF 3:03 PM\n",
        "HAYW 3:07 PM\n",
        "SHAY 3:11 PM\n",
        "UCTY 3:16 PM\n",
        "FRMT 3:21 PM\n",
        "\n",
        "42\n",
        "RICH 2:35 PM\n",
        "DELN 2:39 PM\n",
        "PLZA 2:42 PM\n",
        "NBRK 2:45 PM\n",
        "DBRK 2:48 PM\n",
        "ASHB 2:50 PM\n",
        "MCAR 2:53 PM\n",
        "19TH 2:59 PM\n",
        "12TH 3:00 PM\n",
        "LAKE 3:03 PM\n",
        "FTVL 3:07 PM\n",
        "COLS 3:10 PM\n",
        "SANL 3:14 PM\n",
        "BAYF 3:18 PM\n",
        "HAYW 3:22 PM\n",
        "SHAY 3:26 PM\n",
        "UCTY 3:31 PM\n",
        "FRMT 3:36 PM\n",
        "\n",
        "43\n",
        "RICH 2:50 PM\n",
        "DELN 2:54 PM\n",
        "PLZA 2:57 PM\n",
        "NBRK 3:00 PM\n",
        "DBRK 3:03 PM\n",
        "ASHB 3:05 PM\n",
        "MCAR 3:08 PM\n",
        "19TH 3:14 PM\n",
        "12TH 3:15 PM\n",
        "LAKE 3:18 PM\n",
        "FTVL 3:22 PM\n",
        "COLS 3:25 PM\n",
        "SANL 3:29 PM\n",
        "BAYF 3:33 PM\n",
        "HAYW 3:37 PM\n",
        "SHAY 3:41 PM\n",
        "UCTY 3:46 PM\n",
        "FRMT 3:51 PM\n",
        "\n",
        "44\n",
        "RICH 3:05 PM\n",
        "DELN 3:09 PM\n",
        "PLZA 3:12 PM\n",
        "NBRK 3:15 PM\n",
        "DBRK 3:18 PM\n",
        "ASHB 3:20 PM\n",
        "MCAR 3:23 PM\n",
        "19TH 3:29 PM\n",
        "12TH 3:30 PM\n",
        "LAKE 3:33 PM\n",
        "FTVL 3:37 PM\n",
        "COLS 3:40 PM\n",
        "SANL 3:44 PM\n",
        "BAYF 3:48 PM\n",
        "HAYW 3:52 PM\n",
        "SHAY 3:56 PM\n",
        "UCTY 4:01 PM\n",
        "FRMT 4:06 PM\n",
        "\n",
        "45\n",
        "RICH 3:20 PM\n",
        "DELN 3:24 PM\n",
        "PLZA 3:27 PM\n",
        "NBRK 3:30 PM\n",
        "DBRK 3:33 PM\n",
        "ASHB 3:35 PM\n",
        "MCAR 3:38 PM\n",
        "19TH 3:44 PM\n",
        "12TH 3:45 PM\n",
        "LAKE 3:48 PM\n",
        "FTVL 3:52 PM\n",
        "COLS 3:55 PM\n",
        "SANL 3:59 PM\n",
        "BAYF 4:03 PM\n",
        "HAYW 4:07 PM\n",
        "SHAY 4:11 PM\n",
        "UCTY 4:16 PM\n",
        "FRMT 4:21 PM\n",
        "\n",
        "46\n",
        "RICH 3:35 PM\n",
        "DELN 3:39 PM\n",
        "PLZA 3:42 PM\n",
        "NBRK 3:45 PM\n",
        "DBRK 3:48 PM\n",
        "ASHB 3:50 PM\n",
        "MCAR 3:53 PM\n",
        "19TH 3:59 PM\n",
        "12TH 4:00 PM\n",
        "LAKE 4:03 PM\n",
        "FTVL 4:07 PM\n",
        "COLS 4:10 PM\n",
        "SANL 4:14 PM\n",
        "BAYF 4:18 PM\n",
        "HAYW 4:22 PM\n",
        "SHAY 4:26 PM\n",
        "UCTY 4:31 PM\n",
        "FRMT 4:36 PM\n",
        "\n",
        "47\n",
        "RICH 3:50 PM\n",
        "DELN 3:54 PM\n",
        "PLZA 3:57 PM\n",
        "NBRK 4:00 PM\n",
        "DBRK 4:03 PM\n",
        "ASHB 4:05 PM\n",
        "MCAR 4:08 PM\n",
        "19TH 4:14 PM\n",
        "12TH 4:15 PM\n",
        "LAKE 4:18 PM\n",
        "FTVL 4:22 PM\n",
        "COLS 4:25 PM\n",
        "SANL 4:29 PM\n",
        "BAYF 4:33 PM\n",
        "HAYW 4:37 PM\n",
        "SHAY 4:41 PM\n",
        "UCTY 4:46 PM\n",
        "FRMT"
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        " 4:51 PM\n",
        "\n",
        "48\n",
        "RICH 4:05 PM\n",
        "DELN 4:09 PM\n",
        "PLZA 4:12 PM\n",
        "NBRK 4:15 PM\n",
        "DBRK 4:18 PM\n",
        "ASHB 4:20 PM\n",
        "MCAR 4:23 PM\n",
        "19TH 4:29 PM\n",
        "12TH 4:30 PM\n",
        "LAKE 4:33 PM\n",
        "FTVL 4:37 PM\n",
        "COLS 4:40 PM\n",
        "SANL 4:44 PM\n",
        "BAYF 4:48 PM\n",
        "HAYW 4:52 PM\n",
        "SHAY 4:56 PM\n",
        "UCTY 5:01 PM\n",
        "FRMT 5:06 PM\n",
        "\n",
        "49\n",
        "RICH 4:20 PM\n",
        "DELN 4:24 PM\n",
        "PLZA 4:27 PM\n",
        "NBRK 4:30 PM\n",
        "DBRK 4:33 PM\n",
        "ASHB 4:35 PM\n",
        "MCAR 4:38 PM\n",
        "19TH 4:44 PM\n",
        "12TH 4:45 PM\n",
        "LAKE 4:48 PM\n",
        "FTVL 4:52 PM\n",
        "COLS 4:55 PM\n",
        "SANL 4:59 PM\n",
        "BAYF 5:03 PM\n",
        "HAYW 5:07 PM\n",
        "SHAY 5:11 PM\n",
        "UCTY 5:16 PM\n",
        "FRMT 5:21 PM\n",
        "\n",
        "50\n",
        "RICH 4:35 PM\n",
        "DELN 4:39 PM\n",
        "PLZA 4:42 PM\n",
        "NBRK 4:45 PM\n",
        "DBRK 4:48 PM\n",
        "ASHB 4:50 PM\n",
        "MCAR 4:53 PM\n",
        "19TH 4:59 PM\n",
        "12TH 5:00 PM\n",
        "LAKE 5:03 PM\n",
        "FTVL 5:07 PM\n",
        "COLS 5:10 PM\n",
        "SANL 5:14 PM\n",
        "BAYF 5:18 PM\n",
        "HAYW 5:22 PM\n",
        "SHAY 5:26 PM\n",
        "UCTY 5:31 PM\n",
        "FRMT 5:36 PM\n",
        "\n",
        "51\n",
        "RICH 4:50 PM\n",
        "DELN 4:54 PM\n",
        "PLZA 4:57 PM\n",
        "NBRK 5:00 PM\n",
        "DBRK 5:03 PM\n",
        "ASHB 5:05 PM\n",
        "MCAR 5:08 PM\n",
        "19TH 5:14 PM\n",
        "12TH 5:15 PM\n",
        "LAKE 5:18 PM\n",
        "FTVL 5:22 PM\n",
        "COLS 5:25 PM\n",
        "SANL 5:29 PM\n",
        "BAYF 5:33 PM\n",
        "HAYW 5:37 PM\n",
        "SHAY 5:41 PM\n",
        "UCTY 5:46 PM\n",
        "FRMT 5:51 PM\n",
        "\n",
        "52\n",
        "RICH 5:05 PM\n",
        "DELN 5:09 PM\n",
        "PLZA 5:12 PM\n",
        "NBRK 5:15 PM\n",
        "DBRK 5:18 PM\n",
        "ASHB 5:20 PM\n",
        "MCAR 5:23 PM\n",
        "19TH 5:29 PM\n",
        "12TH 5:30 PM\n",
        "LAKE 5:33 PM\n",
        "FTVL 5:37 PM\n",
        "COLS 5:40 PM\n",
        "SANL 5:44 PM\n",
        "BAYF 5:48 PM\n",
        "HAYW 5:52 PM\n",
        "SHAY 5:56 PM\n",
        "UCTY 6:01 PM\n",
        "FRMT 6:06 PM\n",
        "\n",
        "53\n",
        "RICH 5:20 PM\n",
        "DELN 5:24 PM\n",
        "PLZA 5:27 PM\n",
        "NBRK 5:30 PM\n",
        "DBRK 5:33 PM\n",
        "ASHB 5:35 PM\n",
        "MCAR 5:38 PM\n",
        "19TH 5:44 PM\n",
        "12TH 5:45 PM\n",
        "LAKE 5:48 PM\n",
        "FTVL 5:52 PM\n",
        "COLS 5:55 PM\n",
        "SANL 5:59 PM\n",
        "BAYF 6:03 PM\n",
        "HAYW 6:07 PM\n",
        "SHAY 6:11 PM\n",
        "UCTY 6:16 PM\n",
        "FRMT 6:21 PM\n",
        "\n",
        "54\n",
        "RICH 5:35 PM\n",
        "DELN 5:39 PM\n",
        "PLZA 5:42 PM\n",
        "NBRK 5:45 PM\n",
        "DBRK 5:48 PM\n",
        "ASHB 5:50 PM\n",
        "MCAR 5:53 PM\n",
        "19TH 5:59 PM\n",
        "12TH 6:00 PM\n",
        "LAKE 6:03 PM\n",
        "FTVL 6:07 PM\n",
        "COLS 6:10 PM\n",
        "SANL 6:14 PM\n",
        "BAYF 6:18 PM\n",
        "HAYW 6:22 PM\n",
        "SHAY 6:26 PM\n",
        "UCTY 6:31 PM\n",
        "FRMT 6:36 PM\n",
        "\n",
        "55\n",
        "RICH 5:50 PM\n",
        "DELN 5:54 PM\n",
        "PLZA 5:57 PM\n",
        "NBRK 6:00 PM\n",
        "DBRK 6:03 PM\n",
        "ASHB 6:05 PM\n",
        "MCAR 6:08 PM\n",
        "19TH 6:14 PM\n",
        "12TH 6:15 PM\n",
        "LAKE 6:18 PM\n",
        "FTVL 6:22 PM\n",
        "COLS 6:25 PM\n",
        "SANL 6:29 PM\n",
        "BAYF 6:33 PM\n",
        "HAYW 6:37 PM\n",
        "SHAY 6:41 PM\n",
        "UCTY 6:46 PM\n",
        "FRMT 6:51 PM\n",
        "\n",
        "56\n",
        "RICH 6:05 PM\n",
        "DELN 6:09 PM\n",
        "PLZA 6:12 PM\n",
        "NBRK 6:15 PM\n",
        "DBRK 6:18 PM\n",
        "ASHB 6:20 PM\n",
        "MCAR 6:23 PM\n",
        "19TH 6:29 PM\n",
        "12TH 6:30 PM\n",
        "LAKE 6:33 PM\n",
        "FTVL 6:37 PM\n",
        "COLS 6:40 PM\n",
        "SANL 6:44 PM\n",
        "BAYF 6:48 PM\n",
        "HAYW 6:52 PM\n",
        "SHAY 6:56 PM\n",
        "UCTY 7:01 PM\n",
        "FRMT 7:06 PM\n",
        "\n",
        "57\n",
        "RICH 6:20 PM\n",
        "DELN 6:24 PM\n",
        "PLZA 6:27 PM\n",
        "NBRK 6:30 PM\n",
        "DBRK 6:33 PM\n",
        "ASHB 6:35 PM\n",
        "MCAR 6:38 PM\n",
        "19TH 6:44 PM\n",
        "12TH 6:45 PM\n",
        "LAKE 6:48 PM\n",
        "FTVL 6:52 PM\n",
        "COLS 6:55 PM\n",
        "SANL 6:59 PM\n",
        "BAYF 7:03 PM\n",
        "HAYW 7:07 PM\n",
        "SHAY 7:11 PM\n",
        "UCTY 7:16 PM\n",
        "FRMT 7:21 PM\n",
        "\n",
        "58\n",
        "RICH 6:35 PM\n",
        "DELN 6:39 PM\n",
        "PLZA 6:42 PM\n",
        "NBRK 6:45 PM\n",
        "DBRK 6:48 PM\n",
        "ASHB 6:50 PM\n",
        "MCAR 6:53 PM\n",
        "19TH 6:59 PM\n",
        "12TH 7:00 PM\n",
        "LAKE 7:03 PM\n",
        "FTVL 7:07 PM\n",
        "COLS 7:10 PM\n",
        "SANL 7:14 PM\n",
        "BAYF 7:18 PM\n",
        "HAYW 7:22 PM\n",
        "SHAY 7:26 PM\n",
        "UCTY 7:31 PM\n",
        "FRMT 7:36 PM\n",
        "\n",
        "59\n",
        "RICH 6:50 PM\n",
        "DELN 6:54 PM\n",
        "PLZA 6:57 PM\n",
        "NBRK 7:00 PM\n",
        "DBRK 7:03 PM\n",
        "ASHB 7:05 PM\n",
        "MCAR 7:08 PM\n",
        "19TH 7:14 PM\n",
        "12TH 7:15 PM\n",
        "LAKE 7:18 PM\n",
        "FTVL 7:22 PM\n",
        "COLS 7:25 PM\n",
        "SANL 7:29 PM\n",
        "BAYF 7:33 PM\n",
        "HAYW 7:37 PM\n",
        "SHAY 7:41 PM\n",
        "UCTY 7:46 PM\n",
        "FRMT 7:51 PM\n",
        "\n",
        "60\n",
        "RICH 7:05 PM\n",
        "DELN 7:09 PM\n",
        "PLZA 7:12 PM\n",
        "NBRK 7:15 PM\n",
        "DBRK 7:18 PM\n",
        "ASHB 7:20 PM\n",
        "MCAR 7:23 PM\n",
        "19TH 7:29 PM\n",
        "12TH 7:30 PM\n",
        "LAKE 7:33 PM\n",
        "FTVL 7:37 PM\n",
        "COLS 7:40 PM\n",
        "SANL 7:44 PM\n",
        "BAYF 7:48 PM\n",
        "HAYW 7:52 PM\n",
        "SHAY 7:56 PM\n",
        "UCTY 8:01 PM\n",
        "FRMT 8:06 PM\n",
        "\n",
        "61\n",
        "RICH 7:20 PM\n",
        "DELN 7:24 PM\n",
        "PLZA 7:27 PM\n",
        "NBRK 7:30 PM\n",
        "DBRK 7:33 PM\n",
        "ASHB 7:35 PM\n",
        "MCAR 7:38 PM\n",
        "19TH 7:44 PM\n",
        "12TH 7:45 PM\n",
        "LAKE 7:48 PM\n",
        "FTVL 7:52 PM\n",
        "COLS 7:55 PM\n",
        "SANL 7:59 PM\n",
        "BAYF 8:03 PM\n",
        "HAYW 8:07 PM\n",
        "SHAY 8:11 PM\n",
        "UCTY 8:16 PM\n",
        "FRMT 8:21 PM\n",
        "\n",
        "62\n",
        "RICH 7:35 PM\n",
        "DELN 7:39 PM\n",
        "PLZA 7:42 PM\n",
        "NBRK 7:46 PM\n",
        "DBRK 7:48 PM\n",
        "ASHB 7:50 PM\n",
        "MCAR 7:55 PM\n",
        "19TH 8:01 PM\n",
        "12TH 8:02 PM\n",
        "LAKE 8:05 PM\n",
        "FTVL 8:09 PM\n",
        "COLS 8:12 PM\n",
        "SANL 8:16 PM\n",
        "BAYF 8:20 PM\n",
        "HAYW 8:24 PM\n",
        "SHAY 8:28 PM\n",
        "UCTY 8:33 PM\n",
        "FRMT 8:38 PM\n",
        "\n",
        "63\n",
        "RICH 7:55 PM\n",
        "DELN 7:59 PM\n",
        "PLZA 8:02 PM\n",
        "NBRK 8:06 PM\n",
        "DBRK 8:08 PM\n",
        "ASHB 8:10 PM\n",
        "MCAR 8:15 PM\n",
        "19TH 8:21 PM\n",
        "12TH 8:22 PM\n",
        "LAKE 8:25 PM\n",
        "FTVL 8:29 PM\n",
        "COLS 8:32 PM\n",
        "SANL 8:36 PM\n",
        "BAYF 8:40 PM\n",
        "HAYW 8:44 PM\n",
        "SHAY 8:48 PM\n",
        "UCTY 8:53 PM\n",
        "FRMT 8:58 PM\n",
        "\n",
        "64\n",
        "RICH 8:15 PM\n",
        "DELN 8:19 PM\n",
        "PLZA 8:22 PM\n",
        "NBRK 8:26 PM\n",
        "DBRK 8:28 PM\n",
        "ASHB 8:30 PM\n",
        "MCAR 8:35 PM\n",
        "19TH 8:41 PM\n",
        "12TH 8:42 PM\n",
        "LAKE 8:45 PM\n",
        "FTVL 8:49 PM\n",
        "COLS 8:52 PM\n",
        "SANL 8:56 PM\n",
        "BAYF 9:00 PM\n",
        "HAYW 9:04 PM\n",
        "SHAY 9:08 PM\n",
        "UCTY 9:13 PM\n",
        "FRMT 9:18 PM\n",
        "\n",
        "65\n",
        "RICH 8:35 PM\n",
        "DELN 8:39 PM\n",
        "PLZA 8:42 PM\n",
        "NBRK 8:46 PM\n",
        "DBRK 8:48 PM\n",
        "ASHB 8:50 PM\n",
        "MCAR 8:55 PM\n",
        "19TH 9:01 PM\n",
        "12TH 9:02 PM\n",
        "LAKE 9:05 PM\n",
        "FTVL 9:09 PM\n",
        "COLS 9:12 PM\n",
        "SANL 9:16 PM\n",
        "BAYF 9:20 PM\n",
        "HAYW 9:24 PM\n",
        "SHAY 9:28 PM\n",
        "UCTY 9:33 PM\n",
        "FRMT 9:38 PM\n",
        "\n",
        "66\n",
        "RICH 8:55 PM\n",
        "DELN 8:59 PM\n",
        "PLZA 9:02 PM\n",
        "NBRK 9:06 PM\n",
        "DBRK 9:08 PM\n",
        "ASHB 9:10 PM\n",
        "MCAR 9:15 PM\n",
        "19TH 9:21 PM\n",
        "12TH 9:22 PM\n",
        "LAKE 9:25 PM\n",
        "FTVL 9:29 PM\n",
        "COLS 9:32 PM\n",
        "SANL 9:36 PM\n",
        "BAYF 9:40 PM\n",
        "HAYW 9:44 PM\n",
        "SHAY 9:48 PM\n",
        "UCTY 9:53 PM\n",
        "FRMT 9:58 PM\n",
        "\n",
        "67\n",
        "RICH 9:15 PM\n",
        "DELN 9:19 PM\n",
        "PLZA 9:22 PM\n",
        "NBRK 9:26 PM\n",
        "DBRK 9:28 PM\n",
        "ASHB 9:30 PM\n",
        "MCAR 9:35 PM\n",
        "19TH 9:41 PM\n",
        "12TH 9:42 PM\n",
        "LAKE 9:45 PM\n",
        "FTVL 9:49 PM\n",
        "COLS 9:52 PM\n",
        "SANL 9:56 PM\n",
        "BAYF 10:00 PM\n",
        "HAYW 10:04 PM\n",
        "SHAY 10:08 PM\n",
        "UCTY 10:13 PM\n",
        "FRMT 10:18 PM\n",
        "\n",
        "68\n",
        "RICH 9:35 PM\n",
        "DELN 9:39 PM\n",
        "PLZA 9:42 PM\n",
        "NBRK 9:46 PM\n",
        "DBRK 9:48 PM\n",
        "ASHB 9:50 PM\n",
        "MCAR 9:55 PM\n",
        "19TH 10:01 PM\n",
        "12TH 10:02 PM\n",
        "LAKE 10:05 PM\n",
        "FTVL 10:09 PM\n",
        "COLS 10:12 PM\n",
        "SANL 10:16 PM\n",
        "BAYF 10:20 PM\n",
        "HAYW 10:24 PM\n",
        "SHAY 10:28 PM\n",
        "UCTY 10:33 PM\n",
        "FRMT 10:38 PM\n",
        "\n",
        "69\n",
        "RICH 9:55 PM\n",
        "DELN 9:59 PM\n",
        "PLZA 10:02 PM\n",
        "NBRK 10:06 PM\n",
        "DBRK 10:08 PM\n",
        "ASHB 10:10 PM\n",
        "MCAR 10:15 PM\n",
        "19TH 10:21 PM\n",
        "12TH 10:22 PM\n",
        "LAKE 10:25 PM\n",
        "FTVL 10:29 PM\n",
        "COLS 10:32 PM\n",
        "SANL 10:36 PM\n",
        "BAYF 10:40 PM\n",
        "HAYW 10:44 PM\n",
        "SHAY 10:48 PM\n",
        "UCTY 10:53 PM\n",
        "FRMT 10:58 PM\n",
        "\n",
        "70\n",
        "RICH 10:15 PM\n",
        "DELN 10:19 PM\n",
        "PLZA 10:22 PM\n",
        "NBRK 10:26 PM\n",
        "DBRK 10:28 PM\n",
        "ASHB 10:30 PM\n",
        "MCAR 10:35 PM\n",
        "19TH 10:41 PM\n",
        "12TH 10:42 PM\n",
        "LAKE 10:45 PM\n",
        "FTVL 10:49 PM\n",
        "COLS 10:52 PM\n",
        "SANL 10:56 PM\n",
        "BAYF 11:00 PM\n",
        "HAYW 11:04 PM\n",
        "SHAY 11:08 PM\n",
        "UCTY 11:13 PM\n",
        "FRMT 11:18 PM\n",
        "\n",
        "71\n",
        "RICH 10:35 PM\n",
        "DELN 10:39 PM\n",
        "PLZA 10:42 PM\n",
        "NBRK 10:46 PM\n",
        "DBRK 10:48 PM\n",
        "ASHB 10:50 PM\n",
        "MCAR 10:55 PM\n",
        "19TH 11:01 PM\n",
        "12TH 11:02 PM\n",
        "LAKE 11:05 PM\n",
        "FTVL 11:09 PM\n",
        "COLS 11:12 PM\n",
        "SANL 11:16 PM\n",
        "BAYF 11:20 PM\n",
        "HAYW 11:24 PM\n",
        "SHAY 11:28 PM\n",
        "UCTY 11:33 PM\n",
        "FRMT 11:38 PM\n",
        "\n",
        "72\n",
        "RICH 10:55 PM\n",
        "DELN 10:59 PM\n",
        "PLZA 11:02 PM\n",
        "NBRK 11:06 PM\n",
        "DBRK 11:08 PM\n",
        "ASHB 11:10 PM\n",
        "MCAR 11:15 PM\n",
        "19TH 11:21 PM\n",
        "12TH 11:22 PM\n",
        "LAKE 11:25 PM\n",
        "FTVL 11:29 PM\n",
        "COLS 11:32 PM\n",
        "SANL 11:36 PM\n",
        "BAYF 11:40 PM\n",
        "HAYW 11:44 PM\n",
        "SHAY 11:48 PM\n",
        "UCTY 11:53 PM\n",
        "FRMT 11:58 PM\n",
        "\n",
        "73\n",
        "RICH 11:15 PM\n",
        "DELN 11:19 PM\n",
        "PLZA 11:22 PM\n",
        "NBRK 11:26 PM\n",
        "DBRK 11:28 PM\n",
        "ASHB 11:30 PM\n",
        "MCAR 11:35 PM\n",
        "19TH 11:41 PM\n",
        "12TH 11:42 PM\n",
        "LAKE 11:45 PM\n",
        "FTVL 11:49 PM\n",
        "COLS 11:52 PM\n",
        "SANL 11:56 PM\n",
        "BAYF 12:00 AM\n",
        "HAYW 12:04 AM\n",
        "SHAY 12:08 AM\n",
        "UCTY 12:13 AM\n",
        "FRMT 12:18 AM\n",
        "\n",
        "74\n",
        "RICH 11:35 PM\n",
        "DELN 11:39 PM\n",
        "PLZA 11:42 PM\n",
        "NBRK 11:46 PM\n",
        "DBRK 11:48 PM\n",
        "ASHB 11:50 PM\n",
        "MCAR 11:55 PM\n",
        "19TH 12:01 AM\n",
        "12TH 12:02 AM\n",
        "LAKE 12:05 AM\n",
        "FTVL 12:09 AM\n",
        "COLS 12:12 AM\n",
        "SANL 12:16 AM\n",
        "BAYF 12:20 AM\n",
        "HAYW 12:24 AM\n",
        "SHAY 12:28 AM\n",
        "UCTY 12:33 AM\n",
        "FRMT 12:38 AM\n",
        "\n",
        "75\n",
        "RICH 11:55 PM\n",
        "DELN 11:59 PM\n",
        "PLZA 12:02 AM\n",
        "NBRK 12:06 AM\n",
        "DBRK 12:08 AM\n",
        "ASHB 12:10 AM\n",
        "MCAR 12:15 AM\n",
        "19TH 12:21 AM\n",
        "12TH 12:22 AM\n",
        "LAKE 12:25 AM\n",
        "FTVL 12:29 AM\n",
        "COLS 12:32 AM\n",
        "SANL 12:36 AM\n",
        "BAYF 12:40 AM\n",
        "HAYW 12:44 AM\n",
        "SHAY 12:48 AM\n",
        "UCTY 12:53 AM\n",
        "FRMT 12:58 AM\n",
        "\n",
        "76\n",
        "RICH 12:17 AM\n",
        "DELN 12:21 AM\n",
        "PLZA 12:24 AM\n",
        "NBRK 12:27 AM\n",
        "DBRK 12:30 AM\n",
        "ASHB 12:32 AM\n",
        "MCAR 12:46 AM\n",
        "19TH 12:51 AM\n",
        "12TH 12:53 AM\n",
        "LAKE 12:56 AM\n",
        "FTVL 1:00 AM\n",
        "COLS 1:03 AM\n",
        "SANL 1:07 AM\n",
        "BAYF 1:10 AM\n",
        "HAYW 1:14 AM\n",
        "SHAY 1:18 AM\n",
        "UCTY 1:24 AM\n",
        "FRMT 1:29 AM\n",
        "\n"
       ]
      }
     ],
     "prompt_number": 19
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# Comparing schedule and real-time for a specific station\n",
      "\n",
      "Where I'd like to go...but will ultimately leave as an exercise to you all...comparing the scheduled arrival times with the\n",
      "real time BART info to see how individual trains (and the system as a whole) are doing.\n",
      "\n",
      "What we do here:\n",
      "\n",
      "* calculate the schedule for PLZA station\n",
      "* calculate the current real time info for PLZA station\n",
      "* figure out the difference between the real time info for the next train \n",
      "\n",
      "Compare http://www.bart.gov/schedules/eta?stn=PLZA with http://www.bart.gov/schedules/bystationresults?station=PLZA"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "%%html\n",
      "<iframe src=\"http://www.bart.gov/schedules/eta?stn=PLZA\"/ width=800 height=600>"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<iframe src=\"http://www.bart.gov/schedules/eta?stn=PLZA\"/ width=800 height=600>"
       ],
       "metadata": {},
       "output_type": "display_data",
       "text": [
        "<IPython.core.display.HTML at 0x106e6f2d0>"
       ]
      }
     ],
     "prompt_number": 20
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# Get schedule for PLZA\n",
      "\n",
      "# using El Cerrito Plaza station as an example (closest station to me)\n",
      "# http://www.bart.gov/stations/plza\n",
      "# http://api.bart.gov/api/sched.aspx?cmd=stnsched&orig=plza&key=MW9S-E7SL-26DU-VV8V\n",
      "\n",
      "schedule_plza_df = DataFrame(bart.get_station_schedule('PLZA'))\n",
      "schedule_plza_df.head()"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>bikeflag</th>\n",
        "      <th>dest_time</th>\n",
        "      <th>line</th>\n",
        "      <th>orig_time</th>\n",
        "      <th>train_head_station</th>\n",
        "      <th>train_idx</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 1</td>\n",
        "      <td> 5:21 AM</td>\n",
        "      <td> ROUTE 7</td>\n",
        "      <td> 4:19 AM</td>\n",
        "      <td> MLBR</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 1</td>\n",
        "      <td> 5:21 AM</td>\n",
        "      <td> ROUTE 4</td>\n",
        "      <td> 4:27 AM</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 1</td>\n",
        "      <td> 5:36 AM</td>\n",
        "      <td> ROUTE 7</td>\n",
        "      <td> 4:34 AM</td>\n",
        "      <td> MLBR</td>\n",
        "      <td> 2</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 1</td>\n",
        "      <td> 5:36 AM</td>\n",
        "      <td> ROUTE 4</td>\n",
        "      <td> 4:42 AM</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> 2</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 1</td>\n",
        "      <td> 5:51 AM</td>\n",
        "      <td> ROUTE 7</td>\n",
        "      <td> 4:49 AM</td>\n",
        "      <td> MLBR</td>\n",
        "      <td> 3</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>5 rows \u00d7 6 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 21,
       "text": [
        "  bikeflag dest_time     line orig_time train_head_station train_idx\n",
        "0        1   5:21 AM  ROUTE 7   4:19 AM               MLBR         1\n",
        "1        1   5:21 AM  ROUTE 4   4:27 AM               FRMT         1\n",
        "2        1   5:36 AM  ROUTE 7   4:34 AM               MLBR         2\n",
        "3        1   5:36 AM  ROUTE 4   4:42 AM               FRMT         2\n",
        "4        1   5:51 AM  ROUTE 7   4:49 AM               MLBR         3\n",
        "\n",
        "[5 rows x 6 columns]"
       ]
      }
     ],
     "prompt_number": 21
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# Get real time info for PLZA, accounting for 'Leaving', 'Arriving' in Minutes fields\n",
      "\n",
      "# http://api.bart.gov/api/etd.aspx?cmd=etd&orig=PLZA&key=MW9S-E7SL-26DU-VV8V\n",
      "# compare to http://www.bart.gov/schedules/eta?stn=PLZA\n",
      "\n",
      "# need to handle the case of 'Leaving' and 'Arriving' given for minutes in the real time estimates\n",
      "\n",
      "def etd_minutes_to_int(m):\n",
      "    if m in ['Leaving', 'Arriving']:\n",
      "        return 0\n",
      "    else:\n",
      "        try:\n",
      "            return int(m)\n",
      "        except:\n",
      "            return np.nan\n",
      "        \n",
      "\n",
      "etd_plza_df = DataFrame(etd('PLZA'))\n",
      "etd_plza_df['minutes'] = etd_plza_df.minutes.apply(etd_minutes_to_int)\n",
      "etd_plza_df"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>bikeflag</th>\n",
        "      <th>call_dt</th>\n",
        "      <th>color</th>\n",
        "      <th>destination</th>\n",
        "      <th>direction</th>\n",
        "      <th>hexcolor</th>\n",
        "      <th>length</th>\n",
        "      <th>minutes</th>\n",
        "      <th>platform</th>\n",
        "      <th>station</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td> 6</td>\n",
        "      <td> 13</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td> 6</td>\n",
        "      <td> 28</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td> 6</td>\n",
        "      <td> 43</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> MLBR</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 5</td>\n",
        "      <td>  5</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> MLBR</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 9</td>\n",
        "      <td> 20</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> MLBR</td>\n",
        "      <td> South</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 9</td>\n",
        "      <td> 35</td>\n",
        "      <td> 2</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 5</td>\n",
        "      <td>  1</td>\n",
        "      <td> 1</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td> ORANGE</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff9933</td>\n",
        "      <td> 3</td>\n",
        "      <td> 11</td>\n",
        "      <td> 1</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8</th>\n",
        "      <td> 1</td>\n",
        "      <td> 2014-05-27 14:45:07-07:00</td>\n",
        "      <td>    RED</td>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> #ff0000</td>\n",
        "      <td> 5</td>\n",
        "      <td> 17</td>\n",
        "      <td> 1</td>\n",
        "      <td> PLZA</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>9 rows \u00d7 10 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 22,
       "text": [
        "  bikeflag                    call_dt   color destination direction hexcolor  \\\n",
        "0        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "1        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "2        1  2014-05-27 14:45:07-07:00  ORANGE        FRMT     South  #ff9933   \n",
        "3        1  2014-05-27 14:45:07-07:00     RED        MLBR     South  #ff0000   \n",
        "4        1  2014-05-27 14:45:07-07:00     RED        MLBR     South  #ff0000   \n",
        "5        1  2014-05-27 14:45:07-07:00     RED        MLBR     South  #ff0000   \n",
        "6        1  2014-05-27 14:45:07-07:00     RED        RICH     North  #ff0000   \n",
        "7        1  2014-05-27 14:45:07-07:00  ORANGE        RICH     North  #ff9933   \n",
        "8        1  2014-05-27 14:45:07-07:00     RED        RICH     North  #ff0000   \n",
        "\n",
        "  length  minutes platform station  \n",
        "0      6       13        2    PLZA  \n",
        "1      6       28        2    PLZA  \n",
        "2      6       43        2    PLZA  \n",
        "3      5        5        2    PLZA  \n",
        "4      9       20        2    PLZA  \n",
        "5      9       35        2    PLZA  \n",
        "6      5        1        1    PLZA  \n",
        "7      3       11        1    PLZA  \n",
        "8      5       17        1    PLZA  \n",
        "\n",
        "[9 rows x 10 columns]"
       ]
      }
     ],
     "prompt_number": 22
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# compute the absolute time associated with real time estimate\n",
      "\n",
      "from datetime import timedelta\n",
      "\n",
      "etd_plza_df['estimate'] = etd_plza_df.apply(lambda s: s['call_dt'] + \\\n",
      "                                            timedelta(minutes=s['minutes']), axis=1)\n",
      "etd_plza_df[['destination','direction','station','estimate','minutes']]"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>destination</th>\n",
        "      <th>direction</th>\n",
        "      <th>station</th>\n",
        "      <th>estimate</th>\n",
        "      <th>minutes</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> PLZA</td>\n",
        "      <td> 2014-05-27 14:58:07-07:00</td>\n",
        "      <td> 13</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> PLZA</td>\n",
        "      <td> 2014-05-27 15:13:07-07:00</td>\n",
        "      <td> 28</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> FRMT</td>\n",
        "      <td> South</td>\n",
        "      <td> PLZA</td>\n",
        "      <td> 2014-05-27 15:28:07-07:00</td>\n",
        "      <td> 43</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> MLBR</td>\n",
        "      <td> South</td>\n",
        "      <td> PLZA</td>\n",
        "      <td> 2014-05-27 14:50:07-07:00</td>\n",
        "      <td>  5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> MLBR</td>\n",
        "      <td> South</td>\n",
        "      <td> PLZA</td>\n",
        "      <td> 2014-05-27 15:05:07-07:00</td>\n",
        "      <td> 20</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> MLBR</td>\n",
        "      <td> South</td>\n",
        "      <td> PLZA</td>\n",
        "      <td> 2014-05-27 15:20:07-07:00</td>\n",
        "      <td> 35</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> PLZA</td>\n",
        "      <td> 2014-05-27 14:46:07-07:00</td>\n",
        "      <td>  1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> PLZA</td>\n",
        "      <td> 2014-05-27 14:56:07-07:00</td>\n",
        "      <td> 11</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8</th>\n",
        "      <td> RICH</td>\n",
        "      <td> North</td>\n",
        "      <td> PLZA</td>\n",
        "      <td> 2014-05-27 15:02:07-07:00</td>\n",
        "      <td> 17</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>9 rows \u00d7 5 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 23,
       "text": [
        "  destination direction station                   estimate  minutes\n",
        "0        FRMT     South    PLZA  2014-05-27 14:58:07-07:00       13\n",
        "1        FRMT     South    PLZA  2014-05-27 15:13:07-07:00       28\n",
        "2        FRMT     South    PLZA  2014-05-27 15:28:07-07:00       43\n",
        "3        MLBR     South    PLZA  2014-05-27 14:50:07-07:00        5\n",
        "4        MLBR     South    PLZA  2014-05-27 15:05:07-07:00       20\n",
        "5        MLBR     South    PLZA  2014-05-27 15:20:07-07:00       35\n",
        "6        RICH     North    PLZA  2014-05-27 14:46:07-07:00        1\n",
        "7        RICH     North    PLZA  2014-05-27 14:56:07-07:00       11\n",
        "8        RICH     North    PLZA  2014-05-27 15:02:07-07:00       17\n",
        "\n",
        "[9 rows x 5 columns]"
       ]
      }
     ],
     "prompt_number": 23
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# convert scheduled time into an absolute time\n",
      "\n",
      "from pytz import timezone\n",
      "pacific_tz = timezone(\"US/Pacific\")\n",
      "\n",
      "def orig_time_dt(ot):\n",
      "    \"\"\" \"\"\"\n",
      "    dt = parse(ot)\n",
      "    # with rare exception, we should not find any times earlier than 4am -- if so this is the\n",
      "    # next day\n",
      "    # exception:  Bay Bridge repair weekend http://www.bart.gov/news/articles/2013/news20130815\n",
      "\n",
      "    if dt.hour < 4:\n",
      "        dt = dt + timedelta(days=1)\n",
      "\n",
      "    # put dt into local timezone\n",
      "    dt = pacific_tz.localize(dt)\n",
      "   \n",
      "    return dt\n",
      "\n",
      "schedule_plza_df['orig_time'].apply(orig_time_dt)"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 24,
       "text": [
        "0     2014-05-27 04:19:00-07:00\n",
        "1     2014-05-27 04:27:00-07:00\n",
        "2     2014-05-27 04:34:00-07:00\n",
        "3     2014-05-27 04:42:00-07:00\n",
        "4     2014-05-27 04:49:00-07:00\n",
        "5     2014-05-27 04:53:00-07:00\n",
        "6     2014-05-27 04:57:00-07:00\n",
        "7     2014-05-27 05:04:00-07:00\n",
        "8     2014-05-27 05:08:00-07:00\n",
        "9     2014-05-27 05:12:00-07:00\n",
        "10    2014-05-27 05:19:00-07:00\n",
        "11    2014-05-27 05:23:00-07:00\n",
        "12    2014-05-27 05:27:00-07:00\n",
        "13    2014-05-27 05:34:00-07:00\n",
        "14    2014-05-27 05:38:00-07:00\n",
        "...\n",
        "255    2014-05-27 22:22:00-07:00\n",
        "256    2014-05-27 22:28:00-07:00\n",
        "257    2014-05-27 22:42:00-07:00\n",
        "258    2014-05-27 22:48:00-07:00\n",
        "259    2014-05-27 23:02:00-07:00\n",
        "260    2014-05-27 23:08:00-07:00\n",
        "261    2014-05-27 23:22:00-07:00\n",
        "262    2014-05-27 23:28:00-07:00\n",
        "263    2014-05-27 23:42:00-07:00\n",
        "264    2014-05-27 23:48:00-07:00\n",
        "265    2014-05-28 00:02:00-07:00\n",
        "266    2014-05-28 00:08:00-07:00\n",
        "267    2014-05-28 00:24:00-07:00\n",
        "268    2014-05-28 00:33:00-07:00\n",
        "269    2014-05-28 00:56:00-07:00\n",
        "Name: orig_time, Length: 270, dtype: object"
       ]
      }
     ],
     "prompt_number": 24
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# as a first pass, compare only the the next trains for each route\n",
      "\n",
      "next_plza_trains = etd_plza_df.groupby('destination').apply(lambda s: min(s['estimate']))\n",
      "next_plza_trains"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 25,
       "text": [
        "destination\n",
        "FRMT           2014-05-27 14:58:07-07:00\n",
        "MLBR           2014-05-27 14:50:07-07:00\n",
        "RICH           2014-05-27 14:46:07-07:00\n",
        "dtype: object"
       ]
      }
     ],
     "prompt_number": 25
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# do the comparison\n",
      "\n",
      "comparisons = []\n",
      "\n",
      "for (destination, estimate) in next_plza_trains.iterkv():\n",
      "    scheduled_for_dest = schedule_plza_df[schedule_plza_df.train_head_station==destination]\n",
      "    time_diff = scheduled_for_dest['orig_time'].apply(orig_time_dt) - estimate\n",
      "    comparisons.append({'destination':destination,\n",
      "                        'estimate':estimate,\n",
      "                        'schedule':schedule_plza_df.iloc[np.argmin(abs(time_diff))]['orig_time'],\n",
      "                        'diff': np.min(abs(time_diff))})\n",
      "    \n",
      "comparisons_df = DataFrame(comparisons)\n",
      "comparisons_df"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>destination</th>\n",
        "      <th>diff</th>\n",
        "      <th>estimate</th>\n",
        "      <th>schedule</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> FRMT</td>\n",
        "      <td> 0   00:01:07\n",
        "dtype: timedelta64[ns]</td>\n",
        "      <td> 2014-05-27 14:58:07-07:00</td>\n",
        "      <td> 2:57 PM</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> MLBR</td>\n",
        "      <td> 0   00:01:07\n",
        "dtype: timedelta64[ns]</td>\n",
        "      <td> 2014-05-27 14:50:07-07:00</td>\n",
        "      <td> 2:49 PM</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> RICH</td>\n",
        "      <td> 0   00:01:07\n",
        "dtype: timedelta64[ns]</td>\n",
        "      <td> 2014-05-27 14:46:07-07:00</td>\n",
        "      <td> 2:45 PM</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>3 rows \u00d7 4 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 26,
       "text": [
        "  destination                                 diff                   estimate  \\\n",
        "0        FRMT  0   00:01:07\n",
        "dtype: timedelta64[ns]  2014-05-27 14:58:07-07:00   \n",
        "1        MLBR  0   00:01:07\n",
        "dtype: timedelta64[ns]  2014-05-27 14:50:07-07:00   \n",
        "2        RICH  0   00:01:07\n",
        "dtype: timedelta64[ns]  2014-05-27 14:46:07-07:00   \n",
        "\n",
        "  schedule  \n",
        "0  2:57 PM  \n",
        "1  2:49 PM  \n",
        "2  2:45 PM  \n",
        "\n",
        "[3 rows x 4 columns]"
       ]
      }
     ],
     "prompt_number": 26
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# put it all together\n",
      "\n",
      "# first pass at an algorithm\n",
      "# for all ETD, find the minimum difference with a sechedule arrival\n",
      "\n",
      "import requests\n",
      "import urllib\n",
      "from datetime import timedelta\n",
      "\n",
      "from lxml.etree import fromstring\n",
      "\n",
      "from dateutil.parser import parse\n",
      "from dateutil.tz import tzlocal\n",
      "\n",
      "from pandas import DataFrame\n",
      "import numpy as np\n",
      "\n",
      "import bart_api \n",
      "\n",
      "\n",
      "try:\n",
      "    # to allow import of a registered key if it exists\n",
      "    from settings import BART_API_KEY\n",
      "except:\n",
      "    BART_API_KEY = \"MW9S-E7SL-26DU-VV8V\"\n",
      "\n",
      "from pytz import timezone\n",
      "pacific_tz = timezone(\"US/Pacific\")\n",
      "\n",
      "\n",
      "def etd(orig, key=BART_API_KEY):\n",
      "    url = \"http://api.bart.gov/api/etd.aspx?\" +  \\\n",
      "            urllib.urlencode({'cmd':'etd',\n",
      "                              'orig':orig,\n",
      "                              'key':key})\n",
      "                                                                  \n",
      "    r = requests.get(url)\n",
      "    doc = fromstring(r.content)\n",
      "    \n",
      "    estimations_list = []\n",
      "\n",
      "    # parse the datetime for the API call\n",
      "\n",
      "    s = doc.find('date').text + \" \" +doc.find('time').text\n",
      "    call_dt = parse(s)\n",
      "    \n",
      "    # turn the results into a rectangular format\n",
      "\n",
      "    # parse the station\n",
      "\n",
      "    for station in doc.findall('station'):\n",
      "        etds = station.findall('etd')\n",
      "        for etd in etds:\n",
      "            estimates = etd.findall('estimate')\n",
      "            for estimate in estimates:\n",
      "                estimate_tuple = [(child.tag, child.text) for child in estimate.iterchildren()]\n",
      "                \n",
      "                estimate_tuple += [('call_dt', call_dt),\n",
      "                                   ('station', station.find('abbr').text),\n",
      "                                   ('destination', etd.find('abbreviation').text)]\n",
      "               \n",
      "                estimations_list.append(dict(estimate_tuple))\n",
      "\n",
      "    return estimations_list\n",
      "\n",
      "\n",
      "def etd_minutes_to_int(m):\n",
      "    if m in ['Leaving', 'Arriving']:\n",
      "        return 0\n",
      "    else:\n",
      "        try:\n",
      "            return int(m)\n",
      "        except:\n",
      "            return np.nan\n",
      "        \n",
      "\n",
      "def orig_time_dt(ot):\n",
      "    \"\"\" \"\"\"\n",
      "    dt = parse(ot)\n",
      "    # with rare exception, we should not find any times earlier than 4am -- if so this is the\n",
      "    # next day\n",
      "    # exception:  Bay Bridge repair weekend http://www.bart.gov/news/articles/2013/news20130815\n",
      "\n",
      "    if dt.hour < 4:\n",
      "        dt = dt + timedelta(days=1)\n",
      "\n",
      "    # put dt into local timezone\n",
      "    dt = pacific_tz.localize(dt)\n",
      "   \n",
      "    return dt\n",
      "\n",
      "\n",
      "bart = bart_api.BartApi(BART_API_KEY)\n",
      "\n",
      "# using El Cerrito Plaza station as an example (closest station to me)\n",
      "# http://www.bart.gov/stations/plza\n",
      "\n",
      "# station schedule\n",
      "# http://api.bart.gov/api/sched.aspx?cmd=stnsched&orig=plza&key=MW9S-E7SL-26DU-VV8V\n",
      "\n",
      "schedule_plza_df = DataFrame(bart.get_station_schedule('PLZA'))\n",
      "\n",
      "# http://api.bart.gov/api/etd.aspx?cmd=etd&orig=PLZA&key=MW9S-E7SL-26DU-VV8V\n",
      "# compare to http://www.bart.gov/schedules/eta?stn=PLZA\n",
      "\n",
      "etd_plza_df = DataFrame(etd('PLZA'))\n",
      "\n",
      "# make sure minutes are integer\n",
      "etd_plza_df['minutes'] = etd_plza_df.minutes.apply(etd_minutes_to_int)\n",
      "\n",
      "# compute the absolute time of the real time estimates\n",
      "etd_plza_df['estimate'] = etd_plza_df.apply(lambda s: s['call_dt'] + \\\n",
      "                                            timedelta(minutes=s['minutes']), axis=1)\n",
      "\n",
      "# for each route, compute the next train coming into PLZA\n",
      "next_plza_trains = etd_plza_df.groupby('destination').apply(lambda s: min(s['estimate']))\n",
      "\n",
      "comparisons = []\n",
      "\n",
      "for (destination, estimate) in next_plza_trains.iterkv():\n",
      "    scheduled_for_dest = schedule_plza_df[schedule_plza_df.train_head_station==destination]\n",
      "    time_diff = scheduled_for_dest['orig_time'].apply(orig_time_dt) - estimate\n",
      "    comparisons.append({'destination':destination,\n",
      "                        'estimate':estimate,\n",
      "                        'schedule':schedule_plza_df.iloc[np.argmin(abs(time_diff))]['orig_time'],\n",
      "                        'diff': np.min(abs(time_diff))})\n",
      "    #print destination, estimate, schedule_plza_df.iloc[np.argmin(abs(time_diff))]['orig_time'], np.min(abs(time_diff))\n",
      "    \n",
      "comparisons_df = DataFrame(comparisons)\n",
      "comparisons_df"
     ],
     "language": "python",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>destination</th>\n",
        "      <th>diff</th>\n",
        "      <th>estimate</th>\n",
        "      <th>schedule</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> FRMT</td>\n",
        "      <td> 0   00:01:07\n",
        "dtype: timedelta64[ns]</td>\n",
        "      <td> 2014-05-27 14:58:07-07:00</td>\n",
        "      <td> 2:57 PM</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> MLBR</td>\n",
        "      <td> 0   00:01:07\n",
        "dtype: timedelta64[ns]</td>\n",
        "      <td> 2014-05-27 14:50:07-07:00</td>\n",
        "      <td> 2:49 PM</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> RICH</td>\n",
        "      <td> 0   00:01:07\n",
        "dtype: timedelta64[ns]</td>\n",
        "      <td> 2014-05-27 14:46:07-07:00</td>\n",
        "      <td> 2:45 PM</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>3 rows \u00d7 4 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 27,
       "text": [
        "  destination                                 diff                   estimate  \\\n",
        "0        FRMT  0   00:01:07\n",
        "dtype: timedelta64[ns]  2014-05-27 14:58:07-07:00   \n",
        "1        MLBR  0   00:01:07\n",
        "dtype: timedelta64[ns]  2014-05-27 14:50:07-07:00   \n",
        "2        RICH  0   00:01:07\n",
        "dtype: timedelta64[ns]  2014-05-27 14:46:07-07:00   \n",
        "\n",
        "  schedule  \n",
        "0  2:57 PM  \n",
        "1  2:49 PM  \n",
        "2  2:45 PM  \n",
        "\n",
        "[3 rows x 4 columns]"
       ]
      }
     ],
     "prompt_number": 27
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "slide"
      }
     },
     "source": [
      "# Some Next Steps\n",
      "\n",
      "* Generalize to all stations\n",
      "* Accumulate data over a period of time to study BART performance.\n",
      "* Compare delays we see with the alerts that come from BART itself."
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {
      "slideshow": {
       "slide_type": "notes"
      }
     },
     "source": [
      "# Questions (I'm keeping tabs on)\n",
      "\n",
      "* As of 2014.05.26, http://api.bart.gov/api/sched.aspx?cmd=scheds&key=MW9S-E7SL-26DU-VV8V shows two schedules in effect: 33 and 34 -- when does schedule 33 get used?  Is number 33 archival?  How about older schedules -- are they still available from the API?\n",
      "\n",
      "* come back to [Assessing accuracy of real-time arrival estimate systems](https://groups.google.com/forum/#!topic/transit-developers/JJ1REEpknv4)"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 27
    }
   ],
   "metadata": {}
  }
 ]
}