notebooks/Key Features Examples.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pystops"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Establish the location of the results file\n",
    "pystops assumes results are being read from the standard FTA STOPS folder structure:\n",
    "\n",
    "&nbsp;&nbsp;STOPS  \n",
    "&nbsp;&nbsp;&nbsp;&nbsp;|- Districts  \n",
    "&nbsp;&nbsp;&nbsp;&nbsp;|- Inputs  \n",
    "&nbsp;&nbsp;&nbsp;&nbsp;|- OutputData  \n",
    "&nbsp;&nbsp;&nbsp;&nbsp;|- Reports  \n",
    "&nbsp;&nbsp;&nbsp;&nbsp;|- Skims  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "report_file = os.path.join('..', 'data', 'STOPS', 'Reports', 'AC_m19-s19-d19#m19-s19-d19#m20-s19-d19-alt2_20_STOPSY2019Results.prn')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Read Skim Files  \n",
    "scenario =  ('exist', 'nobuild', 'build')  \n",
    "mode = ('bs', 'fg', 'tr')  \n",
    "<i>bs=bus only; fg=fixed guideway; tr=all transit</i>  \n",
    "access = ('walk', 'pnr', 'knr')  \n",
    "period = ('op', 'pk')  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MODE</th>\n",
       "      <th>ITAZ</th>\n",
       "      <th>JTAZ</th>\n",
       "      <th>ACC_TIME</th>\n",
       "      <th>XFW_TIME</th>\n",
       "      <th>EGR_TIME</th>\n",
       "      <th>WT1_TIME</th>\n",
       "      <th>WTX_TIME</th>\n",
       "      <th>FG__TIME</th>\n",
       "      <th>BUS_TIME</th>\n",
       "      <th>...</th>\n",
       "      <th>JSTOP_NO-04</th>\n",
       "      <th>MODE-01</th>\n",
       "      <th>MODE-02</th>\n",
       "      <th>MODE-03</th>\n",
       "      <th>MODE-04</th>\n",
       "      <th>TRIP_NO-01</th>\n",
       "      <th>TRIP_NO-02</th>\n",
       "      <th>TRIP_NO-03</th>\n",
       "      <th>TRIP_NO-04</th>\n",
       "      <th>PROJECTFLG</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>09001$0001</td>\n",
       "      <td>09001$0005</td>\n",
       "      <td>11.608398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.67627</td>\n",
       "      <td>0.67627</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>164</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>09001$0002</td>\n",
       "      <td>09001$0005</td>\n",
       "      <td>12.438965</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.67627</td>\n",
       "      <td>2.67627</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>166</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>09001$0003</td>\n",
       "      <td>09001$0005</td>\n",
       "      <td>11.485596</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.67627</td>\n",
       "      <td>2.67627</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>166</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>09001$0004</td>\n",
       "      <td>09001$0005</td>\n",
       "      <td>8.729248</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.67627</td>\n",
       "      <td>5.32373</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>166</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   MODE        ITAZ        JTAZ   ACC_TIME  XFW_TIME  EGR_TIME  WT1_TIME  \\\n",
       "0     3  09001$0001  09001$0005  11.608398       0.0  25.67627   0.67627   \n",
       "1     3  09001$0002  09001$0005  12.438965       0.0  25.67627   2.67627   \n",
       "2     3  09001$0003  09001$0005  11.485596       0.0  25.67627   2.67627   \n",
       "3     3  09001$0004  09001$0005   8.729248       0.0  25.67627   5.32373   \n",
       "\n",
       "   WTX_TIME  FG__TIME  BUS_TIME  ...  JSTOP_NO-04  MODE-01  MODE-02  MODE-03  \\\n",
       "0       0.0       6.0       0.0  ...            0        2        0        0   \n",
       "1       0.0       6.0       0.0  ...            0        2        0        0   \n",
       "2       0.0       6.0       0.0  ...            0        2        0        0   \n",
       "3       0.0       6.0       0.0  ...            0        2        0        0   \n",
       "\n",
       "   MODE-04  TRIP_NO-01  TRIP_NO-02  TRIP_NO-03  TRIP_NO-04  PROJECTFLG  \n",
       "0        0         164           0           0           0           0  \n",
       "1        0         166           0           0           0           0  \n",
       "2        0         166           0           0           0           0  \n",
       "3        0         166           0           0           0           0  \n",
       "\n",
       "[4 rows x 28 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pystops.read_skim(report_file, scenario='nobuild', mode='fg', access='pnr', period='pk').head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Example Table Reads"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 1.02: Station Listing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S2S#</th>\n",
       "      <th>Sequence</th>\n",
       "      <th>Station Name</th>\n",
       "      <th>Code</th>\n",
       "      <th>Group</th>\n",
       "      <th>Type</th>\n",
       "      <th>New/Exist</th>\n",
       "      <th>BoardCount</th>\n",
       "      <th>WalkPen</th>\n",
       "      <th>KNRPen</th>\n",
       "      <th>PNRPen</th>\n",
       "      <th>SameGTFS</th>\n",
       "      <th>DiffGTFS</th>\n",
       "      <th>GTF STOP1</th>\n",
       "      <th>GTF STOP2</th>\n",
       "      <th>GTF STOP3</th>\n",
       "      <th>GTF STOP4</th>\n",
       "      <th>FareZone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>400 CESAR CHAVEZ/TRI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1-CBD</td>\n",
       "      <td>1</td>\n",
       "      <td>E</td>\n",
       "      <td>6</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1038&amp;C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1801 ENFIELD/HARTFOR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1-CBD</td>\n",
       "      <td>1</td>\n",
       "      <td>E</td>\n",
       "      <td>8</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1444&amp;C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1603 ENFIELD/WEST LY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1-CBD</td>\n",
       "      <td>1</td>\n",
       "      <td>E</td>\n",
       "      <td>5</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1446&amp;C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  S2S# Sequence          Station Name  Code  Group Type New/Exist  BoardCount  \\\n",
       "1    1        1  400 CESAR CHAVEZ/TRI   NaN  1-CBD    1         E           6   \n",
       "2    1        2  1801 ENFIELD/HARTFOR   NaN  1-CBD    1         E           8   \n",
       "3    1        3  1603 ENFIELD/WEST LY   NaN  1-CBD    1         E           5   \n",
       "\n",
       "  WalkPen KNRPen PNRPen SameGTFS DiffGTFS GTF STOP1  GTF STOP2  GTF STOP3  \\\n",
       "1    0.00   0.00   0.00     0.00     0.00    1038&C        NaN        NaN   \n",
       "2    0.00   0.00   0.00     0.00     0.00    1444&C        NaN        NaN   \n",
       "3    0.00   0.00   0.00     0.00     0.00    1446&C        NaN        NaN   \n",
       "\n",
       "   GTF STOP4 FareZone  \n",
       "1        NaN        0  \n",
       "2        NaN        0  \n",
       "3        NaN        0  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pystops.parse_table(report_file, '1.02').head(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 2.04: Station Group Boardings Prior To Adjustment"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CBD</th>\n",
       "      <th>UT</th>\n",
       "      <th>EAust</th>\n",
       "      <th>NEAust</th>\n",
       "      <th>NLamar</th>\n",
       "      <th>ERiver</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>SSide</th>\n",
       "      <th>SSub</th>\n",
       "      <th>WSub</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>Unnamed: 14</th>\n",
       "      <th>Unnamed: 15</th>\n",
       "      <th>Unnamed: 16</th>\n",
       "      <th>Unnamed: 17</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origin</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1-CBD   :</th>\n",
       "      <td>644</td>\n",
       "      <td>2351</td>\n",
       "      <td>1153</td>\n",
       "      <td>656</td>\n",
       "      <td>1782</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1960</td>\n",
       "      <td>2011</td>\n",
       "      <td>1566</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>12134</td>\n",
       "      <td>10975</td>\n",
       "      <td>10975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2-UT    :</th>\n",
       "      <td>2351</td>\n",
       "      <td>16162</td>\n",
       "      <td>802</td>\n",
       "      <td>678</td>\n",
       "      <td>2858</td>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4556</td>\n",
       "      <td>1408</td>\n",
       "      <td>2755</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>31656</td>\n",
       "      <td>26293</td>\n",
       "      <td>26293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3-EAust :</th>\n",
       "      <td>1153</td>\n",
       "      <td>802</td>\n",
       "      <td>1086</td>\n",
       "      <td>547</td>\n",
       "      <td>525</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>837</td>\n",
       "      <td>89</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5238</td>\n",
       "      <td>5656</td>\n",
       "      <td>5656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4-NEAust:</th>\n",
       "      <td>656</td>\n",
       "      <td>678</td>\n",
       "      <td>547</td>\n",
       "      <td>1001</td>\n",
       "      <td>903</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>388</td>\n",
       "      <td>46</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4441</td>\n",
       "      <td>5258</td>\n",
       "      <td>5258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5-NLamar:</th>\n",
       "      <td>1782</td>\n",
       "      <td>2858</td>\n",
       "      <td>525</td>\n",
       "      <td>903</td>\n",
       "      <td>8260</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>920</td>\n",
       "      <td>523</td>\n",
       "      <td>1083</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16872</td>\n",
       "      <td>17503</td>\n",
       "      <td>17503</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            CBD     UT  EAust  NEAust  NLamar  ERiver  Unnamed: 7  Unnamed: 8  \\\n",
       "origin                                                                          \n",
       "1-CBD   :   644   2351   1153     656    1782       7           0           0   \n",
       "2-UT    :  2351  16162    802     678    2858      64           0           0   \n",
       "3-EAust :  1153    802   1086     547     525       0           0           0   \n",
       "4-NEAust:   656    678    547    1001     903     200           0           0   \n",
       "5-NLamar:  1782   2858    525     903    8260      18           0           0   \n",
       "\n",
       "           Unnamed: 9  SSide  SSub  WSub  Unnamed: 13  Unnamed: 14  \\\n",
       "origin                                                               \n",
       "1-CBD   :           0   1960  2011  1566            0            4   \n",
       "2-UT    :           0   4556  1408  2755            0           22   \n",
       "3-EAust :           0    837    89   200            0            0   \n",
       "4-NEAust:           0    388    46    22            0            0   \n",
       "5-NLamar:           0    920   523  1083            0            0   \n",
       "\n",
       "           Unnamed: 15  Unnamed: 16  Unnamed: 17  \n",
       "origin                                            \n",
       "1-CBD   :        12134        10975        10975  \n",
       "2-UT    :        31656        26293        26293  \n",
       "3-EAust :         5238         5656         5656  \n",
       "4-NEAust:         4441         5258         5258  \n",
       "5-NLamar:        16872        17503        17503  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pystops.parse_table(report_file, '2.04').head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 4.02: Weekday Incremental Linked Dist-to-Dist Transit Trips, Build, All Trips"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CBD</th>\n",
       "      <th>UT</th>\n",
       "      <th>EAust</th>\n",
       "      <th>NEAus</th>\n",
       "      <th>NLama</th>\n",
       "      <th>ERive</th>\n",
       "      <th>SPflu</th>\n",
       "      <th>RRock</th>\n",
       "      <th>NPflu</th>\n",
       "      <th>SSide</th>\n",
       "      <th>SSub</th>\n",
       "      <th>WSub</th>\n",
       "      <th>NSub</th>\n",
       "      <th>ESub</th>\n",
       "      <th>Other</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origin</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CBD</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UT</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EAust</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NEAus</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NLama</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ERive</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPflu</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RRock</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NPflu</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SSide</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SSub</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WSub</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NSub</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ESub</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       CBD UT EAust NEAus NLama ERive SPflu RRock NPflu SSide SSub WSub NSub  \\\n",
       "origin                                                                         \n",
       "CBD      0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "UT       0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "EAust    0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "NEAus    0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "NLama    0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "ERive    0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "SPflu    0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "RRock    0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "NPflu    0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "SSide    0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "SSub     0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "WSub     0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "NSub     0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "ESub     0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "Other    0  0     0     0     0     0     0     0     0     0    0    0    0   \n",
       "\n",
       "       ESub Other Total  \n",
       "origin                   \n",
       "CBD       0     0     0  \n",
       "UT        0     0     0  \n",
       "EAust     0     0     0  \n",
       "NEAus     0     0     0  \n",
       "NLama     0     0     0  \n",
       "ERive     0     0     0  \n",
       "SPflu     0     0     0  \n",
       "RRock     0     0     0  \n",
       "NPflu     0     0     0  \n",
       "SSide     0     0     0  \n",
       "SSub      0     0     0  \n",
       "WSub      0     0     0  \n",
       "NSub      0     0     0  \n",
       "ESub      0     0     0  \n",
       "Other     0     0     0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pystops.parse_table(report_file, '4.02')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 9.01: Average Weekday Station Boardings by Mode of Access"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>stop_id</th>\n",
       "      <th>station_name</th>\n",
       "      <th>exist_wlk</th>\n",
       "      <th>exist_knr</th>\n",
       "      <th>exist_pnr</th>\n",
       "      <th>exist_xfr</th>\n",
       "      <th>exist_all</th>\n",
       "      <th>nb_wlk</th>\n",
       "      <th>nb_knr</th>\n",
       "      <th>nb_pnr</th>\n",
       "      <th>nb_xfr</th>\n",
       "      <th>nb_all</th>\n",
       "      <th>bld_wlk</th>\n",
       "      <th>bld_knr</th>\n",
       "      <th>bld_pnr</th>\n",
       "      <th>bld_xfr</th>\n",
       "      <th>bld_all</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1038&amp;C</td>\n",
       "      <td>400 CESAR CHAVEZ/TRI</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1444&amp;C</td>\n",
       "      <td>1801 ENFIELD/HARTFOR</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1446&amp;C</td>\n",
       "      <td>1603 ENFIELD/WEST LY</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1448&amp;C</td>\n",
       "      <td>12TH/EASON</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1450&amp;C</td>\n",
       "      <td>1201 12TH/BLANCO</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  stop_id          station_name  exist_wlk  exist_knr  exist_pnr  exist_xfr  \\\n",
       "0  1038&C  400 CESAR CHAVEZ/TRI          0          1          0          0   \n",
       "1  1444&C  1801 ENFIELD/HARTFOR          6          0          0          0   \n",
       "2  1446&C  1603 ENFIELD/WEST LY          3          0          0          0   \n",
       "3  1448&C            12TH/EASON          0          0          0          0   \n",
       "4  1450&C      1201 12TH/BLANCO         34          0          0          0   \n",
       "\n",
       "   exist_all  nb_wlk  nb_knr  nb_pnr  nb_xfr  nb_all  bld_wlk  bld_knr  \\\n",
       "0          1       0       1       0       0       1        0        1   \n",
       "1          6       6       0       0       0       6        6        0   \n",
       "2          3       3       0       0       0       3        3        0   \n",
       "3          0       0       0       0       0       0        0        0   \n",
       "4         34      34       0       0       0      34       34        0   \n",
       "\n",
       "   bld_pnr  bld_xfr  bld_all  \n",
       "0        0        0        1  \n",
       "1        0        0        6  \n",
       "2        0        0        3  \n",
       "3        0        0        0  \n",
       "4        0        0       34  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pystops.parse_table(report_file, '9.01').head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 10.01: Average Weekday Route Boardings by Zone (Production-End) Access Type"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>route_id</th>\n",
       "      <th>route_name</th>\n",
       "      <th>route_count</th>\n",
       "      <th>exist_wlk</th>\n",
       "      <th>exist_knr</th>\n",
       "      <th>exist_pnr</th>\n",
       "      <th>exist_all</th>\n",
       "      <th>nb_wlk</th>\n",
       "      <th>nb_knr</th>\n",
       "      <th>nb_pnr</th>\n",
       "      <th>nb_all</th>\n",
       "      <th>bld_wlk</th>\n",
       "      <th>bld_knr</th>\n",
       "      <th>bld_pnr</th>\n",
       "      <th>bld_all</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1&amp;C</td>\n",
       "      <td>--1-Metric/South Congress</td>\n",
       "      <td>6227</td>\n",
       "      <td>5394</td>\n",
       "      <td>242</td>\n",
       "      <td>117</td>\n",
       "      <td>5754</td>\n",
       "      <td>5394</td>\n",
       "      <td>242</td>\n",
       "      <td>117</td>\n",
       "      <td>5754</td>\n",
       "      <td>5394</td>\n",
       "      <td>242</td>\n",
       "      <td>117</td>\n",
       "      <td>5754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10&amp;C</td>\n",
       "      <td>--10-South 1st/Red River</td>\n",
       "      <td>4683</td>\n",
       "      <td>4883</td>\n",
       "      <td>392</td>\n",
       "      <td>52</td>\n",
       "      <td>5327</td>\n",
       "      <td>4883</td>\n",
       "      <td>392</td>\n",
       "      <td>52</td>\n",
       "      <td>5327</td>\n",
       "      <td>4883</td>\n",
       "      <td>392</td>\n",
       "      <td>52</td>\n",
       "      <td>5327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>100&amp;C</td>\n",
       "      <td>--100-MetroAirport</td>\n",
       "      <td>914</td>\n",
       "      <td>676</td>\n",
       "      <td>239</td>\n",
       "      <td>20</td>\n",
       "      <td>934</td>\n",
       "      <td>676</td>\n",
       "      <td>239</td>\n",
       "      <td>20</td>\n",
       "      <td>934</td>\n",
       "      <td>676</td>\n",
       "      <td>239</td>\n",
       "      <td>20</td>\n",
       "      <td>934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>103&amp;C</td>\n",
       "      <td>--103-Manchaca Flyer</td>\n",
       "      <td>56</td>\n",
       "      <td>310</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>322</td>\n",
       "      <td>310</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>322</td>\n",
       "      <td>310</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>110&amp;C</td>\n",
       "      <td>--110-South Central Flyer</td>\n",
       "      <td>63</td>\n",
       "      <td>133</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>158</td>\n",
       "      <td>133</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>158</td>\n",
       "      <td>133</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>158</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  route_id                 route_name  route_count  exist_wlk  exist_knr  \\\n",
       "1      1&C  --1-Metric/South Congress         6227       5394        242   \n",
       "2     10&C   --10-South 1st/Red River         4683       4883        392   \n",
       "3    100&C         --100-MetroAirport          914        676        239   \n",
       "4    103&C       --103-Manchaca Flyer           56        310         12   \n",
       "5    110&C  --110-South Central Flyer           63        133         24   \n",
       "\n",
       "   exist_pnr  exist_all  nb_wlk  nb_knr  nb_pnr  nb_all  bld_wlk  bld_knr  \\\n",
       "1        117       5754    5394     242     117    5754     5394      242   \n",
       "2         52       5327    4883     392      52    5327     4883      392   \n",
       "3         20        934     676     239      20     934      676      239   \n",
       "4          0        322     310      12       0     322      310       12   \n",
       "5          0        158     133      24       0     158      133       24   \n",
       "\n",
       "   bld_pnr  bld_all  \n",
       "1      117     5754  \n",
       "2       52     5327  \n",
       "3       20      934  \n",
       "4        0      322  \n",
       "5        0      158  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pystops.parse_table(report_file, '10.01').head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 345.01: Existing WEEKDAY LINKED TRANSIT TRIPS (All Transit/All car HH)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CBD</th>\n",
       "      <th>UT</th>\n",
       "      <th>EAust</th>\n",
       "      <th>NEAus</th>\n",
       "      <th>NLama</th>\n",
       "      <th>ERive</th>\n",
       "      <th>SPflu</th>\n",
       "      <th>RRock</th>\n",
       "      <th>NPflu</th>\n",
       "      <th>SSide</th>\n",
       "      <th>SSub</th>\n",
       "      <th>WSub</th>\n",
       "      <th>NSub</th>\n",
       "      <th>ESub</th>\n",
       "      <th>Other</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>origin</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CBD</th>\n",
       "      <td>293</td>\n",
       "      <td>892</td>\n",
       "      <td>466</td>\n",
       "      <td>118</td>\n",
       "      <td>608</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>477</td>\n",
       "      <td>331</td>\n",
       "      <td>197</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UT</th>\n",
       "      <td>2781</td>\n",
       "      <td>12068</td>\n",
       "      <td>466</td>\n",
       "      <td>163</td>\n",
       "      <td>987</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1018</td>\n",
       "      <td>520</td>\n",
       "      <td>690</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EAust</th>\n",
       "      <td>902</td>\n",
       "      <td>974</td>\n",
       "      <td>688</td>\n",
       "      <td>390</td>\n",
       "      <td>665</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>517</td>\n",
       "      <td>315</td>\n",
       "      <td>195</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NEAus</th>\n",
       "      <td>856</td>\n",
       "      <td>941</td>\n",
       "      <td>651</td>\n",
       "      <td>612</td>\n",
       "      <td>1150</td>\n",
       "      <td>62</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>414</td>\n",
       "      <td>596</td>\n",
       "      <td>253</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NLama</th>\n",
       "      <td>2395</td>\n",
       "      <td>3268</td>\n",
       "      <td>776</td>\n",
       "      <td>503</td>\n",
       "      <td>4333</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>878</td>\n",
       "      <td>843</td>\n",
       "      <td>987</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13994</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         CBD     UT  EAust  NEAus  NLama  ERive  SPflu  RRock  NPflu  SSide  \\\n",
       "origin                                                                        \n",
       "CBD      293    892    466    118    608      5      0      0      0    477   \n",
       "UT      2781  12068    466    163    987      9      0      0      0   1018   \n",
       "EAust    902    974    688    390    665     14      0      0      0    517   \n",
       "NEAus    856    941    651    612   1150     62      0      0      0    414   \n",
       "NLama   2395   3268    776    503   4333     10      0      0      0    878   \n",
       "\n",
       "        SSub  WSub  NSub  ESub  Other  Total  \n",
       "origin                                        \n",
       "CBD      331   197     0     0      0   3387  \n",
       "UT       520   690     0     0      0  18702  \n",
       "EAust    315   195     0     0      0   4662  \n",
       "NEAus    596   253     0     0      0   5535  \n",
       "NLama    843   987     0     0      0  13994  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pystops.parse_table(report_file, '345.01').head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Summarize Access Mode Percentages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>wlk</th>\n",
       "      <th>knr</th>\n",
       "      <th>pnr</th>\n",
       "      <th>xfr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>existing</th>\n",
       "      <td>0.763322</td>\n",
       "      <td>0.034366</td>\n",
       "      <td>0.017277</td>\n",
       "      <td>0.185035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nb</th>\n",
       "      <td>0.763322</td>\n",
       "      <td>0.034366</td>\n",
       "      <td>0.017277</td>\n",
       "      <td>0.185035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bld</th>\n",
       "      <td>0.763322</td>\n",
       "      <td>0.034366</td>\n",
       "      <td>0.017277</td>\n",
       "      <td>0.185035</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               wlk       knr       pnr       xfr\n",
       "existing  0.763322  0.034366  0.017277  0.185035\n",
       "nb        0.763322  0.034366  0.017277  0.185035\n",
       "bld       0.763322  0.034366  0.017277  0.185035"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pystops.summarize_access_modes(report_file, percentage=True)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "geo",
   "language": "python",
   "name": "geo"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}