openbus_15_gtfs_stats_prod - Copy.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Using a mix of `partridge` and `gtfstk` with some of my own additions to create daily statistical DataFrames for trips, routes and stops. This will later become a module which we will run on our historical MoT GTFS archive and schedule for nightly runs. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Imports and config"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Put these at the top of every notebook, to get automatic reloading and inline plotting\n",
    "%reload_ext autoreload\n",
    "%autoreload 2\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import partridge as ptg\n",
    "import datetime\n",
    "\n",
    "from gtfs_utils import *\n",
    "import gtfstk\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "LOCAL_GTFS_ZIP_PATH = 'data/gtfs_feeds/2018-03-05.zip' \n",
    "LOCAL_TARIFF_PATH = 'data/sample/latest_tariff.zip' "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "from collections import OrderedDict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "def compute_trip_stats_partridge(feed, zones):\n",
    "    f = feed.trips\n",
    "    f = (\n",
    "        f[['route_id', 'trip_id', 'direction_id', 'shape_id']]\n",
    "        .merge(feed.routes[['route_id', 'route_short_name', 'route_type']])\n",
    "        .merge(feed.stop_times)\n",
    "        .merge(feed.stops[['stop_id', 'stop_name', 'stop_lat', 'stop_lon', 'stop_code']])\n",
    "        .merge(zones)\n",
    "        .sort_values(['trip_id', 'stop_sequence'])\n",
    "        #.assign(departure_time=lambda x: x['departure_time'].map(\n",
    "        #    hp.timestr_to_seconds)\n",
    "        #       )\n",
    "        )\n",
    "    geometry_by_stop = gtfstk.build_geometry_by_stop(feed, use_utm=True)\n",
    "    \n",
    "    g = f.groupby('trip_id')\n",
    "    \n",
    "    def my_agg(group):\n",
    "        d = OrderedDict()\n",
    "        d['route_id'] = group['route_id'].iat[0]\n",
    "        d['route_short_name'] = group['route_short_name'].iat[0]\n",
    "        d['route_type'] = group['route_type'].iat[0]\n",
    "        d['direction_id'] = group['direction_id'].iat[0]\n",
    "        d['shape_id'] = group['shape_id'].iat[0]\n",
    "        d['num_stops'] = group.shape[0]\n",
    "        d['start_time'] = group['departure_time'].iat[0]\n",
    "        d['end_time'] = group['departure_time'].iat[-1]\n",
    "        d['start_stop_id'] = group['stop_id'].iat[0]\n",
    "        d['end_stop_id'] = group['stop_id'].iat[-1]\n",
    "        d['start_stop_code'] = group['stop_code'].iat[0]\n",
    "        d['end_stop_code'] = group['stop_code'].iat[-1]\n",
    "        d['start_stop_name'] = group['stop_name'].iat[0]\n",
    "        d['end_stop_name'] = group['stop_name'].iat[-1]\n",
    "        d['start_zone'] = group['zone_name'].iat[0]\n",
    "        d['end_zone'] = group['zone_name'].iat[-1]\n",
    "        dist = geometry_by_stop[d['start_stop_id']].distance(\n",
    "          geometry_by_stop[d['end_stop_id']])\n",
    "        d['is_loop'] = int(dist < 400)\n",
    "        d['duration'] = (d['end_time'] - d['start_time'])/3600\n",
    "        return pd.Series(d)\n",
    "    \n",
    "    h = g.apply(my_agg)\n",
    "    h['distance'] = g.shape_dist_traveled.max()\n",
    "    \n",
    "    # Reset index and compute final stats\n",
    "    h = h.reset_index()\n",
    "    h['speed'] = h['distance'] / h['duration'] / 1000\n",
    "    h[['start_time', 'end_time']] = (\n",
    "      h[['start_time', 'end_time']].applymap(\n",
    "          lambda x: gtfstk.helpers.timestr_to_seconds(x, inverse=True))\n",
    "        )\n",
    "    return h\n",
    "\n",
    "def compute_route_stats_base_partridge(trip_stats_subset,\n",
    "  headway_start_time='07:00:00', headway_end_time='19:00:00', *,\n",
    "  split_directions=False):\n",
    "    \"\"\"\n",
    "    Compute stats for the given subset of trips stats.\n",
    "\n",
    "    Parameters\n",
    "    ----------\n",
    "    trip_stats_subset : DataFrame\n",
    "        Subset of the output of :func:`.trips.compute_trip_stats`\n",
    "    split_directions : boolean\n",
    "        If ``True``, then separate the stats by trip direction (0 or 1);\n",
    "        otherwise aggregate trips visiting from both directions. \n",
    "        Default: ``False``\n",
    "    headway_start_time : string\n",
    "        HH:MM:SS time string indicating the start time for computing\n",
    "        headway stats\n",
    "        Default: ``'07:00:00'``\n",
    "    headway_end_time : string\n",
    "        HH:MM:SS time string indicating the end time for computing\n",
    "        headway stats.\n",
    "        Default: ``'19:00:00'``\n",
    "\n",
    "    Returns\n",
    "    -------\n",
    "    DataFrame\n",
    "        Columns are\n",
    "\n",
    "        - ``'route_id'``\n",
    "        - ``'route_short_name'``\n",
    "        - ``'agency_id'``\n",
    "        - ``'agency_name'``\n",
    "        - ``'route_long_name'``\n",
    "        - ``'route_type'``\n",
    "        - ``'direction_id'``: 1/0\n",
    "        - ``'num_trips'``: number of trips on the route in the subset\n",
    "        - ``'num_trip_starts'``: number of trips on the route with\n",
    "          nonnull start times\n",
    "        - ``'num_trip_ends'``: number of trips on the route with nonnull\n",
    "          end times that end before 23:59:59\n",
    "        - ``'is_loop'``: 1 if at least one of the trips on the route has\n",
    "          its ``is_loop`` field equal to 1; 0 otherwise\n",
    "        - ``'is_bidirectional'``: 1 if the route has trips in both\n",
    "          directions; 0 otherwise\n",
    "        - ``'start_time'``: start time of the earliest trip on the route\n",
    "        - ``'end_time'``: end time of latest trip on the route\n",
    "        - ``'max_headway'``: maximum of the durations (in minutes)\n",
    "          between trip starts on the route between\n",
    "          ``headway_start_time`` and ``headway_end_time`` on the given\n",
    "          dates\n",
    "        - ``'min_headway'``: minimum of the durations (in minutes)\n",
    "          mentioned above\n",
    "        - ``'mean_headway'``: mean of the durations (in minutes)\n",
    "          mentioned above\n",
    "        - ``'peak_num_trips'``: maximum number of simultaneous trips in\n",
    "          service (for the given direction, or for both directions when\n",
    "          ``split_directions==False``)\n",
    "        - ``'peak_start_time'``: start time of first longest period\n",
    "          during which the peak number of trips occurs\n",
    "        - ``'peak_end_time'``: end time of first longest period during\n",
    "          which the peak number of trips occurs\n",
    "        - ``'service_duration'``: total of the duration of each trip on\n",
    "          the route in the given subset of trips; measured in hours\n",
    "        - ``'service_distance'``: total of the distance traveled by each\n",
    "          trip on the route in the given subset of trips; measured in\n",
    "          whatever distance units are present in ``trip_stats_subset``;\n",
    "          contains all ``np.nan`` entries if ``feed.shapes is None``\n",
    "        - ``'service_speed'``: service_distance/service_duration;\n",
    "          measured in distance units per hour\n",
    "        - ``'mean_trip_distance'``: service_distance/num_trips\n",
    "        - ``'mean_trip_duration'``: service_duration/num_trips\n",
    "        - ``'start_stop_id'``: ``start_stop_id`` of the first trip for the route\n",
    "        - ``'end_stop_id'``: ``end_stop_id`` of the first trip for the route\n",
    "        - ``'num_stops'``: ``num_stops`` of the first trip for the route\n",
    "        - ``'start_zone'``: ``start_zone`` of the first trip for the route\n",
    "        - ``'end_zone'``: ``end_zone`` of the first trip for the route\n",
    "        \n",
    "        If not ``split_directions``, then remove the\n",
    "        direction_id column and compute each route's stats,\n",
    "        except for headways, using\n",
    "        its trips running in both directions.\n",
    "        In this case, (1) compute max headway by taking the max of the\n",
    "        max headways in both directions; (2) compute mean headway by\n",
    "        taking the weighted mean of the mean headways in both\n",
    "        directions.\n",
    "        \n",
    "        If ``trip_stats_subset`` is empty, return an empty DataFrame.\n",
    "\n",
    "    \"\"\"\n",
    "    f = trip_stats_subset.copy()\n",
    "    f[['start_time', 'end_time']] = f[['start_time', 'end_time']\n",
    "      ].applymap(gtfstk.helpers.timestr_to_seconds)\n",
    "\n",
    "    headway_start = gtfstk.helpers.timestr_to_seconds(headway_start_time)\n",
    "    headway_end = gtfstk.helpers.timestr_to_seconds(headway_end_time)\n",
    "    \n",
    "    def compute_route_stats(group):\n",
    "        d = OrderedDict()\n",
    "        d['route_short_name'] = group['route_short_name'].iat[0]\n",
    "        d['route_type'] = group['route_type'].iat[0]\n",
    "        d['num_trips'] = group.shape[0]\n",
    "        d['num_trip_starts'] = group['start_time'].count()\n",
    "        d['num_trip_ends'] = group.loc[\n",
    "          group['end_time'] < 24*3600, 'end_time'].count()\n",
    "        d['is_loop'] = int(group['is_loop'].any())\n",
    "        d['is_bidirectional'] = int(group['direction_id'].unique().size > 1)\n",
    "        d['start_time'] = group['start_time'].min()\n",
    "        d['end_time'] = group['end_time'].max()\n",
    "\n",
    "        # Compute headway stats\n",
    "        headways = np.array([])\n",
    "        for direction in [0, 1]:\n",
    "            stimes = group[group['direction_id'] == direction][\n",
    "              'start_time'].values\n",
    "            stimes = sorted([stime for stime in stimes\n",
    "              if headway_start <= stime <= headway_end])\n",
    "            headways = np.concatenate([headways, np.diff(stimes)])\n",
    "        if headways.size:\n",
    "            d['max_headway'] = np.max(headways)/60  # minutes\n",
    "            d['min_headway'] = np.min(headways)/60  # minutes\n",
    "            d['mean_headway'] = np.mean(headways)/60  # minutes\n",
    "        else:\n",
    "            d['max_headway'] = np.nan\n",
    "            d['min_headway'] = np.nan\n",
    "            d['mean_headway'] = np.nan\n",
    "\n",
    "        # Compute peak num trips\n",
    "        times = np.unique(group[['start_time', 'end_time']].values)\n",
    "        counts = [gtfstk.helpers.count_active_trips(group, t) for t in times]\n",
    "        start, end = gtfstk.helpers.get_peak_indices(times, counts)\n",
    "        d['peak_num_trips'] = counts[start]\n",
    "        d['peak_start_time'] = times[start]\n",
    "        d['peak_end_time'] = times[end]\n",
    "\n",
    "        d['service_distance'] = group['distance'].sum()\n",
    "        d['service_duration'] = group['duration'].sum()\n",
    "\n",
    "        # Added by cjer\n",
    "        d['start_stop_id'] = group['start_stop_id'].iat[0]\n",
    "        d['end_stop_id'] = group['end_stop_id'].iat[0]\n",
    "\n",
    "        d['num_stops'] = group['num_stops'].iat[0]\n",
    "\n",
    "        d['start_zone'] = group['start_zone'].iat[0]\n",
    "        d['end_zone'] = group['end_zone'].iat[0]\n",
    "\n",
    "\n",
    "        return pd.Series(d)\n",
    "    \n",
    "    g = f.groupby('route_id').apply(\n",
    "        compute_route_stats).reset_index()\n",
    "\n",
    "    # Compute a few more stats\n",
    "    g['service_speed'] = g['service_distance']/g['service_duration']\n",
    "    g['mean_trip_distance'] = g['service_distance']/g['num_trips']\n",
    "    g['mean_trip_duration'] = g['service_duration']/g['num_trips']\n",
    "    \n",
    "    # Convert route times to time strings\n",
    "    g[['start_time', 'end_time', 'peak_start_time', 'peak_end_time']] =\\\n",
    "        g[['start_time', 'end_time', 'peak_start_time', 'peak_end_time']].\\\n",
    "            applymap(lambda x: gtfstk.helpers.timestr_to_seconds(x, inverse=True))\n",
    "    \n",
    "    g['service_speed'] = g.service_speed/1000\n",
    "    g = (g\n",
    "         .merge(feed.routes[['route_id', 'route_long_name', 'agency_id']], how='left', on='route_id')\n",
    "         .merge(feed.agency[['agency_id', 'agency_name']], how='left', on='agency_id')\n",
    "        )\n",
    "    g = g[['route_id', 'route_short_name', 'agency_id', 'agency_name', 'route_long_name', 'route_type', \n",
    "           'num_trips', 'num_trip_starts', 'num_trip_ends', 'is_loop', \n",
    "           'is_bidirectional', 'start_time', 'end_time', 'max_headway', 'min_headway', \n",
    "           'mean_headway', 'peak_num_trips', 'peak_start_time', 'peak_end_time',\n",
    "           'service_distance', 'service_duration', 'service_speed',\n",
    "           'mean_trip_distance', 'mean_trip_duration', 'start_stop_id',\n",
    "           'end_stop_id', 'num_stops', 'start_zone', 'end_zone', \n",
    "           ]]\n",
    "    \n",
    "    return g"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts = compute_trip_stats_partridge(feed, zones)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "rs = compute_route_stats_base_partridge(ts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "OUTPUT_DIR = 'data/gtfs_stats/'\n",
    "os.mkdir(OUTPUT_DIR)\n",
    "date_str = '2018-03-05'\n",
    "ts.to_pickle(OUTPUT_DIR+date_str+'_trip_stats.pkl.gz', compression='gzip')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>trip_id</th>\n",
       "      <th>route_id</th>\n",
       "      <th>route_short_name</th>\n",
       "      <th>route_type</th>\n",
       "      <th>direction_id</th>\n",
       "      <th>shape_id</th>\n",
       "      <th>num_stops</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>start_stop_id</th>\n",
       "      <th>...</th>\n",
       "      <th>start_stop_code</th>\n",
       "      <th>end_stop_code</th>\n",
       "      <th>start_stop_name</th>\n",
       "      <th>end_stop_name</th>\n",
       "      <th>start_zone</th>\n",
       "      <th>end_zone</th>\n",
       "      <th>is_loop</th>\n",
       "      <th>duration</th>\n",
       "      <th>distance</th>\n",
       "      <th>speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10096398_040318</td>\n",
       "      <td>9735</td>\n",
       "      <td>70</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>88862</td>\n",
       "      <td>37</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>22:05:22</td>\n",
       "      <td>34657</td>\n",
       "      <td>...</td>\n",
       "      <td>63436</td>\n",
       "      <td>63275</td>\n",
       "      <td>קניון קרני שומרון</td>\n",
       "      <td>אוניברסיטת אריאל/כביש 31</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>1.089444</td>\n",
       "      <td>45786</td>\n",
       "      <td>42.026925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10096399_040318</td>\n",
       "      <td>9735</td>\n",
       "      <td>70</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>88862</td>\n",
       "      <td>37</td>\n",
       "      <td>23:00:00</td>\n",
       "      <td>24:05:22</td>\n",
       "      <td>34657</td>\n",
       "      <td>...</td>\n",
       "      <td>63436</td>\n",
       "      <td>63275</td>\n",
       "      <td>קניון קרני שומרון</td>\n",
       "      <td>אוניברסיטת אריאל/כביש 31</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>1.089444</td>\n",
       "      <td>45786</td>\n",
       "      <td>42.026925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10221383_040318</td>\n",
       "      <td>9194</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>69510</td>\n",
       "      <td>16</td>\n",
       "      <td>14:45:00</td>\n",
       "      <td>15:21:28</td>\n",
       "      <td>34583</td>\n",
       "      <td>...</td>\n",
       "      <td>63362</td>\n",
       "      <td>63433</td>\n",
       "      <td>קופת חולים כללית</td>\n",
       "      <td>קופת חולים לאומית/דרך הנחשונים</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.607778</td>\n",
       "      <td>30736</td>\n",
       "      <td>50.571115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10221384_040318</td>\n",
       "      <td>9194</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>69510</td>\n",
       "      <td>16</td>\n",
       "      <td>15:50:00</td>\n",
       "      <td>16:26:28</td>\n",
       "      <td>34583</td>\n",
       "      <td>...</td>\n",
       "      <td>63362</td>\n",
       "      <td>63433</td>\n",
       "      <td>קופת חולים כללית</td>\n",
       "      <td>קופת חולים לאומית/דרך הנחשונים</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.607778</td>\n",
       "      <td>30736</td>\n",
       "      <td>50.571115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10230038_040318</td>\n",
       "      <td>11169</td>\n",
       "      <td>101</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>84074</td>\n",
       "      <td>31</td>\n",
       "      <td>15:30:00</td>\n",
       "      <td>16:26:40</td>\n",
       "      <td>29309</td>\n",
       "      <td>...</td>\n",
       "      <td>20001</td>\n",
       "      <td>34138</td>\n",
       "      <td>מסוף 2000</td>\n",
       "      <td>בריכה/עמק דותן</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>חבל מודיעין</td>\n",
       "      <td>0</td>\n",
       "      <td>0.944444</td>\n",
       "      <td>44754</td>\n",
       "      <td>47.386588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>10253006_040318</td>\n",
       "      <td>11286</td>\n",
       "      <td>115</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>91096</td>\n",
       "      <td>46</td>\n",
       "      <td>05:05:00</td>\n",
       "      <td>05:36:13</td>\n",
       "      <td>17318</td>\n",
       "      <td>...</td>\n",
       "      <td>47222</td>\n",
       "      <td>42657</td>\n",
       "      <td>בית התעשייה</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.520278</td>\n",
       "      <td>12080</td>\n",
       "      <td>23.218366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>10292410_040318</td>\n",
       "      <td>9631</td>\n",
       "      <td>291</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>84207</td>\n",
       "      <td>13</td>\n",
       "      <td>08:10:00</td>\n",
       "      <td>08:43:40</td>\n",
       "      <td>6382</td>\n",
       "      <td>...</td>\n",
       "      <td>59054</td>\n",
       "      <td>54154</td>\n",
       "      <td>מגאר ג'/מרכז</td>\n",
       "      <td>סחנין משרד הרישוי</td>\n",
       "      <td>כרמיאל</td>\n",
       "      <td>כרמיאל</td>\n",
       "      <td>0</td>\n",
       "      <td>0.561111</td>\n",
       "      <td>14414</td>\n",
       "      <td>25.688317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>10292416_040318</td>\n",
       "      <td>9631</td>\n",
       "      <td>291</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>84207</td>\n",
       "      <td>13</td>\n",
       "      <td>15:30:00</td>\n",
       "      <td>16:03:40</td>\n",
       "      <td>6382</td>\n",
       "      <td>...</td>\n",
       "      <td>59054</td>\n",
       "      <td>54154</td>\n",
       "      <td>מגאר ג'/מרכז</td>\n",
       "      <td>סחנין משרד הרישוי</td>\n",
       "      <td>כרמיאל</td>\n",
       "      <td>כרמיאל</td>\n",
       "      <td>0</td>\n",
       "      <td>0.561111</td>\n",
       "      <td>14414</td>\n",
       "      <td>25.688317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10320309_050318</td>\n",
       "      <td>10490</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>93013</td>\n",
       "      <td>37</td>\n",
       "      <td>09:30:00</td>\n",
       "      <td>09:58:03</td>\n",
       "      <td>10414</td>\n",
       "      <td>...</td>\n",
       "      <td>3242</td>\n",
       "      <td>5677</td>\n",
       "      <td>ברנדייס</td>\n",
       "      <td>מעלה הזיתים</td>\n",
       "      <td>סובב ירושלים</td>\n",
       "      <td>סובב ירושלים</td>\n",
       "      <td>0</td>\n",
       "      <td>0.467500</td>\n",
       "      <td>10027</td>\n",
       "      <td>21.448128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10320310_050318</td>\n",
       "      <td>10490</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>93013</td>\n",
       "      <td>37</td>\n",
       "      <td>13:40:00</td>\n",
       "      <td>14:08:03</td>\n",
       "      <td>10414</td>\n",
       "      <td>...</td>\n",
       "      <td>3242</td>\n",
       "      <td>5677</td>\n",
       "      <td>ברנדייס</td>\n",
       "      <td>מעלה הזיתים</td>\n",
       "      <td>סובב ירושלים</td>\n",
       "      <td>סובב ירושלים</td>\n",
       "      <td>0</td>\n",
       "      <td>0.467500</td>\n",
       "      <td>10027</td>\n",
       "      <td>21.448128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10320311_050318</td>\n",
       "      <td>10490</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>93013</td>\n",
       "      <td>37</td>\n",
       "      <td>16:15:00</td>\n",
       "      <td>16:43:03</td>\n",
       "      <td>10414</td>\n",
       "      <td>...</td>\n",
       "      <td>3242</td>\n",
       "      <td>5677</td>\n",
       "      <td>ברנדייס</td>\n",
       "      <td>מעלה הזיתים</td>\n",
       "      <td>סובב ירושלים</td>\n",
       "      <td>סובב ירושלים</td>\n",
       "      <td>0</td>\n",
       "      <td>0.467500</td>\n",
       "      <td>10027</td>\n",
       "      <td>21.448128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10350680_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>07:30:00</td>\n",
       "      <td>08:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>10350682_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>09:00:00</td>\n",
       "      <td>09:58:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10350684_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>16:00:00</td>\n",
       "      <td>16:58:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>10350687_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>12:30:00</td>\n",
       "      <td>13:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>10350693_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>18:00:00</td>\n",
       "      <td>18:58:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>10350694_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>14:00:00</td>\n",
       "      <td>14:58:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>10350695_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>19:00:00</td>\n",
       "      <td>19:58:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10350699_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>14:30:00</td>\n",
       "      <td>15:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10350701_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>08:30:00</td>\n",
       "      <td>09:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>10350712_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>19:30:00</td>\n",
       "      <td>20:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>10350714_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>12:58:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>10350735_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>16:30:00</td>\n",
       "      <td>17:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>10350744_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>11:00:00</td>\n",
       "      <td>11:58:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>10350745_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>17:30:00</td>\n",
       "      <td>18:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>10350755_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>15:30:00</td>\n",
       "      <td>16:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>10350757_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>11:30:00</td>\n",
       "      <td>12:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>10350764_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>10:00:00</td>\n",
       "      <td>10:58:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>10350771_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>15:00:00</td>\n",
       "      <td>15:58:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>10350788_040318</td>\n",
       "      <td>7526</td>\n",
       "      <td>146</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>90939</td>\n",
       "      <td>53</td>\n",
       "      <td>20:30:00</td>\n",
       "      <td>21:28:27</td>\n",
       "      <td>36371</td>\n",
       "      <td>...</td>\n",
       "      <td>43009</td>\n",
       "      <td>42657</td>\n",
       "      <td>מרכזית המפרץ/רציפים בינעירוני</td>\n",
       "      <td>תחנה מרכזית חוף כרמל/הורדה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>סובב חיפה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974167</td>\n",
       "      <td>22019</td>\n",
       "      <td>22.602908</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90224</th>\n",
       "      <td>9937762_040318</td>\n",
       "      <td>10982</td>\n",
       "      <td>476</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>84436</td>\n",
       "      <td>47</td>\n",
       "      <td>22:20:00</td>\n",
       "      <td>23:38:48</td>\n",
       "      <td>36290</td>\n",
       "      <td>...</td>\n",
       "      <td>21256</td>\n",
       "      <td>30952</td>\n",
       "      <td>תחנה מרכזית תל אביב קומה 6/רציפים</td>\n",
       "      <td>אהרון לובלין/ארבע עונות</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>1.313333</td>\n",
       "      <td>38382</td>\n",
       "      <td>29.224873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90225</th>\n",
       "      <td>9937763_040318</td>\n",
       "      <td>10982</td>\n",
       "      <td>476</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>84436</td>\n",
       "      <td>47</td>\n",
       "      <td>22:40:00</td>\n",
       "      <td>23:58:48</td>\n",
       "      <td>36290</td>\n",
       "      <td>...</td>\n",
       "      <td>21256</td>\n",
       "      <td>30952</td>\n",
       "      <td>תחנה מרכזית תל אביב קומה 6/רציפים</td>\n",
       "      <td>אהרון לובלין/ארבע עונות</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>1.313333</td>\n",
       "      <td>38382</td>\n",
       "      <td>29.224873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90226</th>\n",
       "      <td>9937764_040318</td>\n",
       "      <td>10982</td>\n",
       "      <td>476</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>84436</td>\n",
       "      <td>47</td>\n",
       "      <td>23:00:00</td>\n",
       "      <td>24:18:48</td>\n",
       "      <td>36290</td>\n",
       "      <td>...</td>\n",
       "      <td>21256</td>\n",
       "      <td>30952</td>\n",
       "      <td>תחנה מרכזית תל אביב קומה 6/רציפים</td>\n",
       "      <td>אהרון לובלין/ארבע עונות</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>1.313333</td>\n",
       "      <td>38382</td>\n",
       "      <td>29.224873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90227</th>\n",
       "      <td>9937765_040318</td>\n",
       "      <td>10982</td>\n",
       "      <td>476</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>84436</td>\n",
       "      <td>47</td>\n",
       "      <td>23:40:00</td>\n",
       "      <td>24:58:48</td>\n",
       "      <td>36290</td>\n",
       "      <td>...</td>\n",
       "      <td>21256</td>\n",
       "      <td>30952</td>\n",
       "      <td>תחנה מרכזית תל אביב קומה 6/רציפים</td>\n",
       "      <td>אהרון לובלין/ארבע עונות</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>1.313333</td>\n",
       "      <td>38382</td>\n",
       "      <td>29.224873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90228</th>\n",
       "      <td>9937798_040318</td>\n",
       "      <td>10984</td>\n",
       "      <td>464</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>71221</td>\n",
       "      <td>46</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>08:56:43</td>\n",
       "      <td>13124</td>\n",
       "      <td>...</td>\n",
       "      <td>21508</td>\n",
       "      <td>34034</td>\n",
       "      <td>מסוף האוניברסיטה</td>\n",
       "      <td>תחנת רכבת</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.945278</td>\n",
       "      <td>34361</td>\n",
       "      <td>36.350162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90229</th>\n",
       "      <td>9937799_040318</td>\n",
       "      <td>10984</td>\n",
       "      <td>464</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>71221</td>\n",
       "      <td>46</td>\n",
       "      <td>14:25:00</td>\n",
       "      <td>15:21:43</td>\n",
       "      <td>13124</td>\n",
       "      <td>...</td>\n",
       "      <td>21508</td>\n",
       "      <td>34034</td>\n",
       "      <td>מסוף האוניברסיטה</td>\n",
       "      <td>תחנת רכבת</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.945278</td>\n",
       "      <td>34361</td>\n",
       "      <td>36.350162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90230</th>\n",
       "      <td>9937800_040318</td>\n",
       "      <td>10984</td>\n",
       "      <td>464</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>71221</td>\n",
       "      <td>46</td>\n",
       "      <td>15:25:00</td>\n",
       "      <td>16:21:43</td>\n",
       "      <td>13124</td>\n",
       "      <td>...</td>\n",
       "      <td>21508</td>\n",
       "      <td>34034</td>\n",
       "      <td>מסוף האוניברסיטה</td>\n",
       "      <td>תחנת רכבת</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.945278</td>\n",
       "      <td>34361</td>\n",
       "      <td>36.350162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90231</th>\n",
       "      <td>9937801_040318</td>\n",
       "      <td>10984</td>\n",
       "      <td>464</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>71221</td>\n",
       "      <td>46</td>\n",
       "      <td>16:25:00</td>\n",
       "      <td>17:21:43</td>\n",
       "      <td>13124</td>\n",
       "      <td>...</td>\n",
       "      <td>21508</td>\n",
       "      <td>34034</td>\n",
       "      <td>מסוף האוניברסיטה</td>\n",
       "      <td>תחנת רכבת</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.945278</td>\n",
       "      <td>34361</td>\n",
       "      <td>36.350162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90232</th>\n",
       "      <td>9951408_040318</td>\n",
       "      <td>4711</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>92169</td>\n",
       "      <td>28</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>06:29:22</td>\n",
       "      <td>36911</td>\n",
       "      <td>...</td>\n",
       "      <td>47918</td>\n",
       "      <td>40110</td>\n",
       "      <td>הפרדס/משמר הגבול</td>\n",
       "      <td>תחנה מרכזית חדרה/הורדה</td>\n",
       "      <td>חריש ואדי ערה</td>\n",
       "      <td>חריש ואדי ערה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.489444</td>\n",
       "      <td>9886</td>\n",
       "      <td>20.198411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90233</th>\n",
       "      <td>9951410_040318</td>\n",
       "      <td>4711</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>92169</td>\n",
       "      <td>28</td>\n",
       "      <td>04:50:00</td>\n",
       "      <td>05:19:22</td>\n",
       "      <td>36911</td>\n",
       "      <td>...</td>\n",
       "      <td>47918</td>\n",
       "      <td>40110</td>\n",
       "      <td>הפרדס/משמר הגבול</td>\n",
       "      <td>תחנה מרכזית חדרה/הורדה</td>\n",
       "      <td>חריש ואדי ערה</td>\n",
       "      <td>חריש ואדי ערה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.489444</td>\n",
       "      <td>9886</td>\n",
       "      <td>20.198411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90234</th>\n",
       "      <td>9951415_040318</td>\n",
       "      <td>4711</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>92169</td>\n",
       "      <td>28</td>\n",
       "      <td>05:25:00</td>\n",
       "      <td>05:54:22</td>\n",
       "      <td>36911</td>\n",
       "      <td>...</td>\n",
       "      <td>47918</td>\n",
       "      <td>40110</td>\n",
       "      <td>הפרדס/משמר הגבול</td>\n",
       "      <td>תחנה מרכזית חדרה/הורדה</td>\n",
       "      <td>חריש ואדי ערה</td>\n",
       "      <td>חריש ואדי ערה</td>\n",
       "      <td>0</td>\n",
       "      <td>0.489444</td>\n",
       "      <td>9886</td>\n",
       "      <td>20.198411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90235</th>\n",
       "      <td>9957519_040318</td>\n",
       "      <td>9111</td>\n",
       "      <td>77</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>71958</td>\n",
       "      <td>20</td>\n",
       "      <td>06:20:00</td>\n",
       "      <td>06:48:37</td>\n",
       "      <td>35018</td>\n",
       "      <td>...</td>\n",
       "      <td>63946</td>\n",
       "      <td>63116</td>\n",
       "      <td>מגרש כדורגל</td>\n",
       "      <td>עלי זהב</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.476944</td>\n",
       "      <td>20988</td>\n",
       "      <td>44.005125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90236</th>\n",
       "      <td>9957520_040318</td>\n",
       "      <td>9111</td>\n",
       "      <td>77</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>71958</td>\n",
       "      <td>20</td>\n",
       "      <td>13:00:00</td>\n",
       "      <td>13:28:37</td>\n",
       "      <td>35018</td>\n",
       "      <td>...</td>\n",
       "      <td>63946</td>\n",
       "      <td>63116</td>\n",
       "      <td>מגרש כדורגל</td>\n",
       "      <td>עלי זהב</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.476944</td>\n",
       "      <td>20988</td>\n",
       "      <td>44.005125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90237</th>\n",
       "      <td>9957521_040318</td>\n",
       "      <td>9111</td>\n",
       "      <td>77</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>71958</td>\n",
       "      <td>20</td>\n",
       "      <td>15:00:00</td>\n",
       "      <td>15:28:37</td>\n",
       "      <td>35018</td>\n",
       "      <td>...</td>\n",
       "      <td>63946</td>\n",
       "      <td>63116</td>\n",
       "      <td>מגרש כדורגל</td>\n",
       "      <td>עלי זהב</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.476944</td>\n",
       "      <td>20988</td>\n",
       "      <td>44.005125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90238</th>\n",
       "      <td>9957522_040318</td>\n",
       "      <td>9111</td>\n",
       "      <td>77</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>71958</td>\n",
       "      <td>20</td>\n",
       "      <td>17:05:00</td>\n",
       "      <td>17:33:37</td>\n",
       "      <td>35018</td>\n",
       "      <td>...</td>\n",
       "      <td>63946</td>\n",
       "      <td>63116</td>\n",
       "      <td>מגרש כדורגל</td>\n",
       "      <td>עלי זהב</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.476944</td>\n",
       "      <td>20988</td>\n",
       "      <td>44.005125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90239</th>\n",
       "      <td>9957541_040318</td>\n",
       "      <td>9111</td>\n",
       "      <td>77</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>71958</td>\n",
       "      <td>20</td>\n",
       "      <td>10:30:00</td>\n",
       "      <td>10:58:37</td>\n",
       "      <td>35018</td>\n",
       "      <td>...</td>\n",
       "      <td>63946</td>\n",
       "      <td>63116</td>\n",
       "      <td>מגרש כדורגל</td>\n",
       "      <td>עלי זהב</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.476944</td>\n",
       "      <td>20988</td>\n",
       "      <td>44.005125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90240</th>\n",
       "      <td>9957728_040318</td>\n",
       "      <td>9239</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>83124</td>\n",
       "      <td>33</td>\n",
       "      <td>08:45:00</td>\n",
       "      <td>09:35:51</td>\n",
       "      <td>34407</td>\n",
       "      <td>...</td>\n",
       "      <td>63169</td>\n",
       "      <td>32175</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.847500</td>\n",
       "      <td>28850</td>\n",
       "      <td>34.041298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90241</th>\n",
       "      <td>9957734_040318</td>\n",
       "      <td>9239</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>83124</td>\n",
       "      <td>33</td>\n",
       "      <td>09:50:00</td>\n",
       "      <td>10:40:51</td>\n",
       "      <td>34407</td>\n",
       "      <td>...</td>\n",
       "      <td>63169</td>\n",
       "      <td>32175</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.847500</td>\n",
       "      <td>28850</td>\n",
       "      <td>34.041298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90242</th>\n",
       "      <td>9957740_040318</td>\n",
       "      <td>9239</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>83124</td>\n",
       "      <td>33</td>\n",
       "      <td>11:20:00</td>\n",
       "      <td>12:10:51</td>\n",
       "      <td>34407</td>\n",
       "      <td>...</td>\n",
       "      <td>63169</td>\n",
       "      <td>32175</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.847500</td>\n",
       "      <td>28850</td>\n",
       "      <td>34.041298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90243</th>\n",
       "      <td>9957746_040318</td>\n",
       "      <td>9239</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>83124</td>\n",
       "      <td>33</td>\n",
       "      <td>12:50:00</td>\n",
       "      <td>13:40:51</td>\n",
       "      <td>34407</td>\n",
       "      <td>...</td>\n",
       "      <td>63169</td>\n",
       "      <td>32175</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.847500</td>\n",
       "      <td>28850</td>\n",
       "      <td>34.041298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90244</th>\n",
       "      <td>9957752_040318</td>\n",
       "      <td>9239</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>83124</td>\n",
       "      <td>33</td>\n",
       "      <td>14:20:00</td>\n",
       "      <td>15:10:51</td>\n",
       "      <td>34407</td>\n",
       "      <td>...</td>\n",
       "      <td>63169</td>\n",
       "      <td>32175</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.847500</td>\n",
       "      <td>28850</td>\n",
       "      <td>34.041298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90245</th>\n",
       "      <td>9957757_040318</td>\n",
       "      <td>9239</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>83124</td>\n",
       "      <td>33</td>\n",
       "      <td>18:50:00</td>\n",
       "      <td>19:40:51</td>\n",
       "      <td>34407</td>\n",
       "      <td>...</td>\n",
       "      <td>63169</td>\n",
       "      <td>32175</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.847500</td>\n",
       "      <td>28850</td>\n",
       "      <td>34.041298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90246</th>\n",
       "      <td>9957762_040318</td>\n",
       "      <td>9239</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>83124</td>\n",
       "      <td>33</td>\n",
       "      <td>20:10:00</td>\n",
       "      <td>21:00:51</td>\n",
       "      <td>34407</td>\n",
       "      <td>...</td>\n",
       "      <td>63169</td>\n",
       "      <td>32175</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.847500</td>\n",
       "      <td>28850</td>\n",
       "      <td>34.041298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90247</th>\n",
       "      <td>9957767_040318</td>\n",
       "      <td>9239</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>83124</td>\n",
       "      <td>33</td>\n",
       "      <td>21:35:00</td>\n",
       "      <td>22:25:51</td>\n",
       "      <td>34407</td>\n",
       "      <td>...</td>\n",
       "      <td>63169</td>\n",
       "      <td>32175</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>0.847500</td>\n",
       "      <td>28850</td>\n",
       "      <td>34.041298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90248</th>\n",
       "      <td>9957772_040318</td>\n",
       "      <td>9241</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>83126</td>\n",
       "      <td>54</td>\n",
       "      <td>23:00:00</td>\n",
       "      <td>24:15:23</td>\n",
       "      <td>34407</td>\n",
       "      <td>...</td>\n",
       "      <td>63169</td>\n",
       "      <td>32175</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>0</td>\n",
       "      <td>1.256389</td>\n",
       "      <td>41241</td>\n",
       "      <td>32.825028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90249</th>\n",
       "      <td>9957863_040318</td>\n",
       "      <td>9249</td>\n",
       "      <td>185</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>87732</td>\n",
       "      <td>36</td>\n",
       "      <td>16:15:00</td>\n",
       "      <td>17:18:02</td>\n",
       "      <td>16117</td>\n",
       "      <td>...</td>\n",
       "      <td>32175</td>\n",
       "      <td>63169</td>\n",
       "      <td>זאב אורלוב/ליברמן</td>\n",
       "      <td>בית כנסת עץ עפר/החרוב</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>ראש העין שוהם</td>\n",
       "      <td>0</td>\n",
       "      <td>1.050556</td>\n",
       "      <td>33314</td>\n",
       "      <td>31.710841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90250</th>\n",
       "      <td>9957868_040318</td>\n",
       "      <td>9173</td>\n",
       "      <td>101</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>88890</td>\n",
       "      <td>26</td>\n",
       "      <td>13:15:00</td>\n",
       "      <td>14:23:50</td>\n",
       "      <td>34581</td>\n",
       "      <td>...</td>\n",
       "      <td>63360</td>\n",
       "      <td>63433</td>\n",
       "      <td>'איתמר א</td>\n",
       "      <td>קופת חולים לאומית/דרך הנחשונים</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>1.147222</td>\n",
       "      <td>54176</td>\n",
       "      <td>47.223632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90251</th>\n",
       "      <td>9957962_040318</td>\n",
       "      <td>11077</td>\n",
       "      <td>211</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>83147</td>\n",
       "      <td>17</td>\n",
       "      <td>17:00:00</td>\n",
       "      <td>17:45:03</td>\n",
       "      <td>13290</td>\n",
       "      <td>...</td>\n",
       "      <td>22980</td>\n",
       "      <td>63174</td>\n",
       "      <td>דרך ז'בוטינסקי/רבי עקיבא</td>\n",
       "      <td>ערבי הנחל/הדס</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>שרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.750833</td>\n",
       "      <td>32068</td>\n",
       "      <td>42.709878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90252</th>\n",
       "      <td>9967462_040318</td>\n",
       "      <td>9193</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>69509</td>\n",
       "      <td>19</td>\n",
       "      <td>11:00:00</td>\n",
       "      <td>11:44:53</td>\n",
       "      <td>34583</td>\n",
       "      <td>...</td>\n",
       "      <td>63362</td>\n",
       "      <td>63275</td>\n",
       "      <td>קופת חולים כללית</td>\n",
       "      <td>אוניברסיטת אריאל/כביש 31</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.748056</td>\n",
       "      <td>39576</td>\n",
       "      <td>52.905162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90253</th>\n",
       "      <td>9967467_040318</td>\n",
       "      <td>9193</td>\n",
       "      <td>102</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>69509</td>\n",
       "      <td>19</td>\n",
       "      <td>18:15:00</td>\n",
       "      <td>18:59:53</td>\n",
       "      <td>34583</td>\n",
       "      <td>...</td>\n",
       "      <td>63362</td>\n",
       "      <td>63275</td>\n",
       "      <td>קופת חולים כללית</td>\n",
       "      <td>אוניברסיטת אריאל/כביש 31</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>השומרון</td>\n",
       "      <td>0</td>\n",
       "      <td>0.748056</td>\n",
       "      <td>39576</td>\n",
       "      <td>52.905162</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90254 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               trip_id route_id route_short_name  route_type  direction_id  \\\n",
       "0      10096398_040318     9735               70           3             1   \n",
       "1      10096399_040318     9735               70           3             1   \n",
       "2      10221383_040318     9194              102           3             1   \n",
       "3      10221384_040318     9194              102           3             1   \n",
       "4      10230038_040318    11169              101           3             1   \n",
       "5      10253006_040318    11286              115           3             1   \n",
       "6      10292410_040318     9631              291           3             0   \n",
       "7      10292416_040318     9631              291           3             0   \n",
       "8      10320309_050318    10490               51           3             0   \n",
       "9      10320310_050318    10490               51           3             0   \n",
       "10     10320311_050318    10490               51           3             0   \n",
       "11     10350680_040318     7526              146           3             1   \n",
       "12     10350682_040318     7526              146           3             1   \n",
       "13     10350684_040318     7526              146           3             1   \n",
       "14     10350687_040318     7526              146           3             1   \n",
       "15     10350693_040318     7526              146           3             1   \n",
       "16     10350694_040318     7526              146           3             1   \n",
       "17     10350695_040318     7526              146           3             1   \n",
       "18     10350699_040318     7526              146           3             1   \n",
       "19     10350701_040318     7526              146           3             1   \n",
       "20     10350712_040318     7526              146           3             1   \n",
       "21     10350714_040318     7526              146           3             1   \n",
       "22     10350735_040318     7526              146           3             1   \n",
       "23     10350744_040318     7526              146           3             1   \n",
       "24     10350745_040318     7526              146           3             1   \n",
       "25     10350755_040318     7526              146           3             1   \n",
       "26     10350757_040318     7526              146           3             1   \n",
       "27     10350764_040318     7526              146           3             1   \n",
       "28     10350771_040318     7526              146           3             1   \n",
       "29     10350788_040318     7526              146           3             1   \n",
       "...                ...      ...              ...         ...           ...   \n",
       "90224   9937762_040318    10982              476           3             1   \n",
       "90225   9937763_040318    10982              476           3             1   \n",
       "90226   9937764_040318    10982              476           3             1   \n",
       "90227   9937765_040318    10982              476           3             1   \n",
       "90228   9937798_040318    10984              464           3             1   \n",
       "90229   9937799_040318    10984              464           3             1   \n",
       "90230   9937800_040318    10984              464           3             1   \n",
       "90231   9937801_040318    10984              464           3             1   \n",
       "90232   9951408_040318     4711               14           3             1   \n",
       "90233   9951410_040318     4711               14           3             1   \n",
       "90234   9951415_040318     4711               14           3             1   \n",
       "90235   9957519_040318     9111               77           3             0   \n",
       "90236   9957520_040318     9111               77           3             0   \n",
       "90237   9957521_040318     9111               77           3             0   \n",
       "90238   9957522_040318     9111               77           3             0   \n",
       "90239   9957541_040318     9111               77           3             0   \n",
       "90240   9957728_040318     9239              185           3             0   \n",
       "90241   9957734_040318     9239              185           3             0   \n",
       "90242   9957740_040318     9239              185           3             0   \n",
       "90243   9957746_040318     9239              185           3             0   \n",
       "90244   9957752_040318     9239              185           3             0   \n",
       "90245   9957757_040318     9239              185           3             0   \n",
       "90246   9957762_040318     9239              185           3             0   \n",
       "90247   9957767_040318     9239              185           3             0   \n",
       "90248   9957772_040318     9241              185           3             0   \n",
       "90249   9957863_040318     9249              185           3             1   \n",
       "90250   9957868_040318     9173              101           3             1   \n",
       "90251   9957962_040318    11077              211           3             1   \n",
       "90252   9967462_040318     9193              102           3             1   \n",
       "90253   9967467_040318     9193              102           3             1   \n",
       "\n",
       "      shape_id  num_stops start_time  end_time start_stop_id    ...      \\\n",
       "0        88862         37   21:00:00  22:05:22         34657    ...       \n",
       "1        88862         37   23:00:00  24:05:22         34657    ...       \n",
       "2        69510         16   14:45:00  15:21:28         34583    ...       \n",
       "3        69510         16   15:50:00  16:26:28         34583    ...       \n",
       "4        84074         31   15:30:00  16:26:40         29309    ...       \n",
       "5        91096         46   05:05:00  05:36:13         17318    ...       \n",
       "6        84207         13   08:10:00  08:43:40          6382    ...       \n",
       "7        84207         13   15:30:00  16:03:40          6382    ...       \n",
       "8        93013         37   09:30:00  09:58:03         10414    ...       \n",
       "9        93013         37   13:40:00  14:08:03         10414    ...       \n",
       "10       93013         37   16:15:00  16:43:03         10414    ...       \n",
       "11       90939         53   07:30:00  08:28:27         36371    ...       \n",
       "12       90939         53   09:00:00  09:58:27         36371    ...       \n",
       "13       90939         53   16:00:00  16:58:27         36371    ...       \n",
       "14       90939         53   12:30:00  13:28:27         36371    ...       \n",
       "15       90939         53   18:00:00  18:58:27         36371    ...       \n",
       "16       90939         53   14:00:00  14:58:27         36371    ...       \n",
       "17       90939         53   19:00:00  19:58:27         36371    ...       \n",
       "18       90939         53   14:30:00  15:28:27         36371    ...       \n",
       "19       90939         53   08:30:00  09:28:27         36371    ...       \n",
       "20       90939         53   19:30:00  20:28:27         36371    ...       \n",
       "21       90939         53   12:00:00  12:58:27         36371    ...       \n",
       "22       90939         53   16:30:00  17:28:27         36371    ...       \n",
       "23       90939         53   11:00:00  11:58:27         36371    ...       \n",
       "24       90939         53   17:30:00  18:28:27         36371    ...       \n",
       "25       90939         53   15:30:00  16:28:27         36371    ...       \n",
       "26       90939         53   11:30:00  12:28:27         36371    ...       \n",
       "27       90939         53   10:00:00  10:58:27         36371    ...       \n",
       "28       90939         53   15:00:00  15:58:27         36371    ...       \n",
       "29       90939         53   20:30:00  21:28:27         36371    ...       \n",
       "...        ...        ...        ...       ...           ...    ...       \n",
       "90224    84436         47   22:20:00  23:38:48         36290    ...       \n",
       "90225    84436         47   22:40:00  23:58:48         36290    ...       \n",
       "90226    84436         47   23:00:00  24:18:48         36290    ...       \n",
       "90227    84436         47   23:40:00  24:58:48         36290    ...       \n",
       "90228    71221         46   08:00:00  08:56:43         13124    ...       \n",
       "90229    71221         46   14:25:00  15:21:43         13124    ...       \n",
       "90230    71221         46   15:25:00  16:21:43         13124    ...       \n",
       "90231    71221         46   16:25:00  17:21:43         13124    ...       \n",
       "90232    92169         28   06:00:00  06:29:22         36911    ...       \n",
       "90233    92169         28   04:50:00  05:19:22         36911    ...       \n",
       "90234    92169         28   05:25:00  05:54:22         36911    ...       \n",
       "90235    71958         20   06:20:00  06:48:37         35018    ...       \n",
       "90236    71958         20   13:00:00  13:28:37         35018    ...       \n",
       "90237    71958         20   15:00:00  15:28:37         35018    ...       \n",
       "90238    71958         20   17:05:00  17:33:37         35018    ...       \n",
       "90239    71958         20   10:30:00  10:58:37         35018    ...       \n",
       "90240    83124         33   08:45:00  09:35:51         34407    ...       \n",
       "90241    83124         33   09:50:00  10:40:51         34407    ...       \n",
       "90242    83124         33   11:20:00  12:10:51         34407    ...       \n",
       "90243    83124         33   12:50:00  13:40:51         34407    ...       \n",
       "90244    83124         33   14:20:00  15:10:51         34407    ...       \n",
       "90245    83124         33   18:50:00  19:40:51         34407    ...       \n",
       "90246    83124         33   20:10:00  21:00:51         34407    ...       \n",
       "90247    83124         33   21:35:00  22:25:51         34407    ...       \n",
       "90248    83126         54   23:00:00  24:15:23         34407    ...       \n",
       "90249    87732         36   16:15:00  17:18:02         16117    ...       \n",
       "90250    88890         26   13:15:00  14:23:50         34581    ...       \n",
       "90251    83147         17   17:00:00  17:45:03         13290    ...       \n",
       "90252    69509         19   11:00:00  11:44:53         34583    ...       \n",
       "90253    69509         19   18:15:00  18:59:53         34583    ...       \n",
       "\n",
       "      start_stop_code end_stop_code                    start_stop_name  \\\n",
       "0               63436         63275                  קניון קרני שומרון   \n",
       "1               63436         63275                  קניון קרני שומרון   \n",
       "2               63362         63433                   קופת חולים כללית   \n",
       "3               63362         63433                   קופת חולים כללית   \n",
       "4               20001         34138                          מסוף 2000   \n",
       "5               47222         42657                        בית התעשייה   \n",
       "6               59054         54154                       מגאר ג'/מרכז   \n",
       "7               59054         54154                       מגאר ג'/מרכז   \n",
       "8                3242          5677                            ברנדייס   \n",
       "9                3242          5677                            ברנדייס   \n",
       "10               3242          5677                            ברנדייס   \n",
       "11              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "12              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "13              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "14              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "15              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "16              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "17              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "18              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "19              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "20              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "21              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "22              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "23              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "24              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "25              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "26              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "27              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "28              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "29              43009         42657      מרכזית המפרץ/רציפים בינעירוני   \n",
       "...               ...           ...                                ...   \n",
       "90224           21256         30952  תחנה מרכזית תל אביב קומה 6/רציפים   \n",
       "90225           21256         30952  תחנה מרכזית תל אביב קומה 6/רציפים   \n",
       "90226           21256         30952  תחנה מרכזית תל אביב קומה 6/רציפים   \n",
       "90227           21256         30952  תחנה מרכזית תל אביב קומה 6/רציפים   \n",
       "90228           21508         34034                   מסוף האוניברסיטה   \n",
       "90229           21508         34034                   מסוף האוניברסיטה   \n",
       "90230           21508         34034                   מסוף האוניברסיטה   \n",
       "90231           21508         34034                   מסוף האוניברסיטה   \n",
       "90232           47918         40110                   הפרדס/משמר הגבול   \n",
       "90233           47918         40110                   הפרדס/משמר הגבול   \n",
       "90234           47918         40110                   הפרדס/משמר הגבול   \n",
       "90235           63946         63116                        מגרש כדורגל   \n",
       "90236           63946         63116                        מגרש כדורגל   \n",
       "90237           63946         63116                        מגרש כדורגל   \n",
       "90238           63946         63116                        מגרש כדורגל   \n",
       "90239           63946         63116                        מגרש כדורגל   \n",
       "90240           63169         32175              בית כנסת עץ עפר/החרוב   \n",
       "90241           63169         32175              בית כנסת עץ עפר/החרוב   \n",
       "90242           63169         32175              בית כנסת עץ עפר/החרוב   \n",
       "90243           63169         32175              בית כנסת עץ עפר/החרוב   \n",
       "90244           63169         32175              בית כנסת עץ עפר/החרוב   \n",
       "90245           63169         32175              בית כנסת עץ עפר/החרוב   \n",
       "90246           63169         32175              בית כנסת עץ עפר/החרוב   \n",
       "90247           63169         32175              בית כנסת עץ עפר/החרוב   \n",
       "90248           63169         32175              בית כנסת עץ עפר/החרוב   \n",
       "90249           32175         63169                  זאב אורלוב/ליברמן   \n",
       "90250           63360         63433                           'איתמר א   \n",
       "90251           22980         63174           דרך ז'בוטינסקי/רבי עקיבא   \n",
       "90252           63362         63275                   קופת חולים כללית   \n",
       "90253           63362         63275                   קופת חולים כללית   \n",
       "\n",
       "                        end_stop_name     start_zone       end_zone is_loop  \\\n",
       "0            אוניברסיטת אריאל/כביש 31        השומרון        השומרון       0   \n",
       "1            אוניברסיטת אריאל/כביש 31        השומרון        השומרון       0   \n",
       "2      קופת חולים לאומית/דרך הנחשונים        השומרון        השומרון       0   \n",
       "3      קופת חולים לאומית/דרך הנחשונים        השומרון        השומרון       0   \n",
       "4                      בריכה/עמק דותן         גוש דן    חבל מודיעין       0   \n",
       "5          תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "6                   סחנין משרד הרישוי         כרמיאל         כרמיאל       0   \n",
       "7                   סחנין משרד הרישוי         כרמיאל         כרמיאל       0   \n",
       "8                         מעלה הזיתים   סובב ירושלים   סובב ירושלים       0   \n",
       "9                         מעלה הזיתים   סובב ירושלים   סובב ירושלים       0   \n",
       "10                        מעלה הזיתים   סובב ירושלים   סובב ירושלים       0   \n",
       "11         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "12         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "13         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "14         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "15         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "16         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "17         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "18         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "19         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "20         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "21         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "22         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "23         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "24         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "25         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "26         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "27         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "28         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "29         תחנה מרכזית חוף כרמל/הורדה      סובב חיפה      סובב חיפה       0   \n",
       "...                               ...            ...            ...     ...   \n",
       "90224         אהרון לובלין/ארבע עונות         גוש דן         גוש דן       0   \n",
       "90225         אהרון לובלין/ארבע עונות         גוש דן         גוש דן       0   \n",
       "90226         אהרון לובלין/ארבע עונות         גוש דן         גוש דן       0   \n",
       "90227         אהרון לובלין/ארבע עונות         גוש דן         גוש דן       0   \n",
       "90228                       תחנת רכבת         גוש דן         גוש דן       0   \n",
       "90229                       תחנת רכבת         גוש דן         גוש דן       0   \n",
       "90230                       תחנת רכבת         גוש דן         גוש דן       0   \n",
       "90231                       תחנת רכבת         גוש דן         גוש דן       0   \n",
       "90232          תחנה מרכזית חדרה/הורדה  חריש ואדי ערה  חריש ואדי ערה       0   \n",
       "90233          תחנה מרכזית חדרה/הורדה  חריש ואדי ערה  חריש ואדי ערה       0   \n",
       "90234          תחנה מרכזית חדרה/הורדה  חריש ואדי ערה  חריש ואדי ערה       0   \n",
       "90235                         עלי זהב        השומרון        השומרון       0   \n",
       "90236                         עלי זהב        השומרון        השומרון       0   \n",
       "90237                         עלי זהב        השומרון        השומרון       0   \n",
       "90238                         עלי זהב        השומרון        השומרון       0   \n",
       "90239                         עלי זהב        השומרון        השומרון       0   \n",
       "90240               זאב אורלוב/ליברמן  ראש העין שוהם         גוש דן       0   \n",
       "90241               זאב אורלוב/ליברמן  ראש העין שוהם         גוש דן       0   \n",
       "90242               זאב אורלוב/ליברמן  ראש העין שוהם         גוש דן       0   \n",
       "90243               זאב אורלוב/ליברמן  ראש העין שוהם         גוש דן       0   \n",
       "90244               זאב אורלוב/ליברמן  ראש העין שוהם         גוש דן       0   \n",
       "90245               זאב אורלוב/ליברמן  ראש העין שוהם         גוש דן       0   \n",
       "90246               זאב אורלוב/ליברמן  ראש העין שוהם         גוש דן       0   \n",
       "90247               זאב אורלוב/ליברמן  ראש העין שוהם         גוש דן       0   \n",
       "90248               זאב אורלוב/ליברמן  ראש העין שוהם         גוש דן       0   \n",
       "90249           בית כנסת עץ עפר/החרוב         גוש דן  ראש העין שוהם       0   \n",
       "90250  קופת חולים לאומית/דרך הנחשונים        השומרון        השומרון       0   \n",
       "90251                   ערבי הנחל/הדס         גוש דן           שרון       0   \n",
       "90252        אוניברסיטת אריאל/כביש 31        השומרון        השומרון       0   \n",
       "90253        אוניברסיטת אריאל/כביש 31        השומרון        השומרון       0   \n",
       "\n",
       "       duration  distance      speed  \n",
       "0      1.089444     45786  42.026925  \n",
       "1      1.089444     45786  42.026925  \n",
       "2      0.607778     30736  50.571115  \n",
       "3      0.607778     30736  50.571115  \n",
       "4      0.944444     44754  47.386588  \n",
       "5      0.520278     12080  23.218366  \n",
       "6      0.561111     14414  25.688317  \n",
       "7      0.561111     14414  25.688317  \n",
       "8      0.467500     10027  21.448128  \n",
       "9      0.467500     10027  21.448128  \n",
       "10     0.467500     10027  21.448128  \n",
       "11     0.974167     22019  22.602908  \n",
       "12     0.974167     22019  22.602908  \n",
       "13     0.974167     22019  22.602908  \n",
       "14     0.974167     22019  22.602908  \n",
       "15     0.974167     22019  22.602908  \n",
       "16     0.974167     22019  22.602908  \n",
       "17     0.974167     22019  22.602908  \n",
       "18     0.974167     22019  22.602908  \n",
       "19     0.974167     22019  22.602908  \n",
       "20     0.974167     22019  22.602908  \n",
       "21     0.974167     22019  22.602908  \n",
       "22     0.974167     22019  22.602908  \n",
       "23     0.974167     22019  22.602908  \n",
       "24     0.974167     22019  22.602908  \n",
       "25     0.974167     22019  22.602908  \n",
       "26     0.974167     22019  22.602908  \n",
       "27     0.974167     22019  22.602908  \n",
       "28     0.974167     22019  22.602908  \n",
       "29     0.974167     22019  22.602908  \n",
       "...         ...       ...        ...  \n",
       "90224  1.313333     38382  29.224873  \n",
       "90225  1.313333     38382  29.224873  \n",
       "90226  1.313333     38382  29.224873  \n",
       "90227  1.313333     38382  29.224873  \n",
       "90228  0.945278     34361  36.350162  \n",
       "90229  0.945278     34361  36.350162  \n",
       "90230  0.945278     34361  36.350162  \n",
       "90231  0.945278     34361  36.350162  \n",
       "90232  0.489444      9886  20.198411  \n",
       "90233  0.489444      9886  20.198411  \n",
       "90234  0.489444      9886  20.198411  \n",
       "90235  0.476944     20988  44.005125  \n",
       "90236  0.476944     20988  44.005125  \n",
       "90237  0.476944     20988  44.005125  \n",
       "90238  0.476944     20988  44.005125  \n",
       "90239  0.476944     20988  44.005125  \n",
       "90240  0.847500     28850  34.041298  \n",
       "90241  0.847500     28850  34.041298  \n",
       "90242  0.847500     28850  34.041298  \n",
       "90243  0.847500     28850  34.041298  \n",
       "90244  0.847500     28850  34.041298  \n",
       "90245  0.847500     28850  34.041298  \n",
       "90246  0.847500     28850  34.041298  \n",
       "90247  0.847500     28850  34.041298  \n",
       "90248  1.256389     41241  32.825028  \n",
       "90249  1.050556     33314  31.710841  \n",
       "90250  1.147222     54176  47.223632  \n",
       "90251  0.750833     32068  42.709878  \n",
       "90252  0.748056     39576  52.905162  \n",
       "90253  0.748056     39576  52.905162  \n",
       "\n",
       "[90254 rows x 21 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_pickle(OUTPUT_DIR+date_str+'_trip_stats.pkl.gz')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "rs.to_pickle(OUTPUT_DIR+date_str+'_route_stats.pkl.gz', compression='gzip')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "import os\n",
    "import re\n",
    "\n",
    "def batch_stats(folder, output_folder):\n",
    "    for file in os.listdir(folder):\n",
    "        date_str = file.split('.')[0]\n",
    "        date = datetime.datetime.strptime(date_str, '%Y-%m-%d').date()\n",
    "        feed = get_partridge_feed_by_date(folder+file, date)\n",
    "        zones = get_zones_df(LOCAL_TARIFF_PATH)\n",
    "        ts = compute_trip_stats_partridge(feed, zones)\n",
    "        ts.to_pickle(output_folder+date_str+'_trip_stats.pkl.gz', compression='gzip')\n",
    "        rs = compute_route_stats_base_partridge(ts)\n",
    "        rs.to_pickle(output_folder+date_str+'_route_stats.pkl.gz', compression='gzip')\n",
    "\n",
    "GTFS_FEEDS_PATH = 'data/gtfs_feeds/'\n",
    "OUTPUT_DIR = 'data/gtfs_stats/'\n",
    "\n",
    "batch_stats(GTFS_FEEDS_PATH, OUTPUT_DIR)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "FILE_NAME_RE = re.compile('^(?P<date_str>[^_]+?)_(?P<type>\\w+)\\.pkl.gz')\n",
    "\n",
    "STATS_TYPES = ['trip_stats', 'route_stats']\n",
    "\n",
    "existing_files = [(g[0], g[1]) for g in \n",
    "                  (re.match(FILE_NAME_RE, file).groups() for file in os.listdir(OUTPUT_DIR))]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## What's next\n",
    "\n",
    "TODO\n",
    "\n",
    "1. put this all back into proper documented functions\n",
    "1. add date\n",
    "1. integrate with custom day cutoff\n",
    "1. add logging\n",
    "1. write tests\n",
    "1. add split_directions\n",
    "1. add time between stops - max, min, mean (using delta)\n",
    "1. add day and night headways and num_trips (maybe noon also)\n",
    "1. create a function for converting this to a timeseries good for pandas\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}