openbus_28_route_stats.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-03-29T16:05:38.856093Z",
     "start_time": "2019-03-29T16:05:36.090758Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-03-29T16:08:29.491770Z",
     "start_time": "2019-03-29T16:08:28.835634Z"
    }
   },
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>route_id</th>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>10000</td>\n",
       "      <td>10001</td>\n",
       "      <td>10002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>route_short_name</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>91</td>\n",
       "      <td>91</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>agency_id</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>agency_name</th>\n",
       "      <td>אפיקים</td>\n",
       "      <td>אפיקים</td>\n",
       "      <td>נתיב אקספרס</td>\n",
       "      <td>נתיב אקספרס</td>\n",
       "      <td>נתיב אקספרס</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>route_long_name</th>\n",
       "      <td>ת. רכבת יבנה מערב-יבנה&lt;-&gt;ת. רכבת יבנה מזרח-יבנ...</td>\n",
       "      <td>ת. רכבת יבנה מזרח-יבנה&lt;-&gt;ת. רכבת יבנה מערב-יבנ...</td>\n",
       "      <td>קופת חולים/הנשיא-צפת&lt;-&gt;דרך חטיבת יפתח-צפת-11</td>\n",
       "      <td>האר''י/ישראל ב''ק-צפת&lt;-&gt;שפרינצק/קרן היסוד-צפת-2#</td>\n",
       "      <td>געתון/מירון-כפר ורדים&lt;-&gt;בית ספר כפר ורדים-כפר ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>route_type</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>route_mkt</th>\n",
       "      <td>67001</td>\n",
       "      <td>47004</td>\n",
       "      <td>27091</td>\n",
       "      <td>27091</td>\n",
       "      <td>25092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>route_direction</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>route_alternative</th>\n",
       "      <td>#</td>\n",
       "      <td>#</td>\n",
       "      <td>1</td>\n",
       "      <td>#</td>\n",
       "      <td>#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>num_trips</th>\n",
       "      <td>26</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>num_trip_starts</th>\n",
       "      <td>26</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>num_trip_ends</th>\n",
       "      <td>26</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>is_loop</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>is_bidirectional</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_time</th>\n",
       "      <td>05:10:00</td>\n",
       "      <td>06:05:00</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>13:00:00</td>\n",
       "      <td>07:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_time</th>\n",
       "      <td>21:54:38</td>\n",
       "      <td>22:50:38</td>\n",
       "      <td>08:17:31</td>\n",
       "      <td>16:51:42</td>\n",
       "      <td>07:53:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max_headway</th>\n",
       "      <td>65</td>\n",
       "      <td>50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min_headway</th>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean_headway</th>\n",
       "      <td>37.8125</td>\n",
       "      <td>28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>52.5</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>peak_num_trips</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>peak_start_time</th>\n",
       "      <td>05:10:00</td>\n",
       "      <td>15:55:00</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>13:00:00</td>\n",
       "      <td>07:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>peak_end_time</th>\n",
       "      <td>05:29:38</td>\n",
       "      <td>16:05:38</td>\n",
       "      <td>08:17:31</td>\n",
       "      <td>13:21:42</td>\n",
       "      <td>07:53:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>service_distance</th>\n",
       "      <td>183144</td>\n",
       "      <td>280490</td>\n",
       "      <td>6326</td>\n",
       "      <td>41880</td>\n",
       "      <td>7340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>service_duration</th>\n",
       "      <td>8.50778</td>\n",
       "      <td>12.0361</td>\n",
       "      <td>0.291944</td>\n",
       "      <td>1.80833</td>\n",
       "      <td>0.390278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>service_speed</th>\n",
       "      <td>21.5267</td>\n",
       "      <td>23.304</td>\n",
       "      <td>21.6685</td>\n",
       "      <td>23.1594</td>\n",
       "      <td>18.8071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean_trip_distance</th>\n",
       "      <td>7044</td>\n",
       "      <td>8014</td>\n",
       "      <td>6326</td>\n",
       "      <td>8376</td>\n",
       "      <td>7340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean_trip_duration</th>\n",
       "      <td>0.327222</td>\n",
       "      <td>0.343889</td>\n",
       "      <td>0.291944</td>\n",
       "      <td>0.361667</td>\n",
       "      <td>0.390278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_stop_id</th>\n",
       "      <td>38725</td>\n",
       "      <td>15745</td>\n",
       "      <td>18423</td>\n",
       "      <td>37179</td>\n",
       "      <td>7270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_stop_id</th>\n",
       "      <td>15745</td>\n",
       "      <td>38725</td>\n",
       "      <td>38800</td>\n",
       "      <td>18420</td>\n",
       "      <td>17976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_stop_name</th>\n",
       "      <td>ת. רכבת יבנה מערב</td>\n",
       "      <td>ת. רכבת יבנה מזרח</td>\n",
       "      <td>קופת חולים/הנשיא</td>\n",
       "      <td>האר''י/ישראל ב''ק</td>\n",
       "      <td>געתון/מירון</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_stop_name</th>\n",
       "      <td>ת. רכבת יבנה מזרח</td>\n",
       "      <td>ת. רכבת יבנה מערב</td>\n",
       "      <td>דרך חטיבת יפתח</td>\n",
       "      <td>שפרינצק/קרן היסוד</td>\n",
       "      <td>בית ספר כפר ורדים</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_stop_city</th>\n",
       "      <td>יבנה</td>\n",
       "      <td>יבנה</td>\n",
       "      <td>צפת</td>\n",
       "      <td>צפת</td>\n",
       "      <td>כפר ורדים</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_stop_city</th>\n",
       "      <td>יבנה</td>\n",
       "      <td>יבנה</td>\n",
       "      <td>צפת</td>\n",
       "      <td>צפת</td>\n",
       "      <td>כפר ורדים</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_stop_desc</th>\n",
       "      <td>רחוב:  עיר: יבנה רציף:   קומה:</td>\n",
       "      <td>רחוב:  עיר: יבנה רציף:   קומה:</td>\n",
       "      <td>רחוב:הנשיא  עיר: צפת רציף:   קומה:</td>\n",
       "      <td>רחוב:האר''י 4 עיר: צפת רציף:   קומה:</td>\n",
       "      <td>רחוב:מירון 69 עיר: כפר ורדים רציף:   קומה:</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_stop_desc</th>\n",
       "      <td>רחוב:  עיר: יבנה רציף:   קומה:</td>\n",
       "      <td>רחוב:  עיר: יבנה רציף:   קומה:</td>\n",
       "      <td>רחוב:דרך חטיבת יפתח  עיר: צפת רציף:   קומה:</td>\n",
       "      <td>רחוב:שפרינצק  עיר: צפת רציף:   קומה:</td>\n",
       "      <td>רחוב:אשכר  עיר: כפר ורדים רציף:   קומה:</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_stop_lat</th>\n",
       "      <td>31.8907</td>\n",
       "      <td>31.8621</td>\n",
       "      <td>32.9605</td>\n",
       "      <td>32.9719</td>\n",
       "      <td>32.9928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_stop_lon</th>\n",
       "      <td>34.7312</td>\n",
       "      <td>34.7442</td>\n",
       "      <td>35.4955</td>\n",
       "      <td>35.4933</td>\n",
       "      <td>35.258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_stop_lat</th>\n",
       "      <td>31.8621</td>\n",
       "      <td>31.8907</td>\n",
       "      <td>32.9684</td>\n",
       "      <td>32.9585</td>\n",
       "      <td>32.9961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_stop_lon</th>\n",
       "      <td>34.7442</td>\n",
       "      <td>34.7312</td>\n",
       "      <td>35.4944</td>\n",
       "      <td>35.4942</td>\n",
       "      <td>35.2771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>num_stops</th>\n",
       "      <td>19</td>\n",
       "      <td>25</td>\n",
       "      <td>23</td>\n",
       "      <td>26</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_zone</th>\n",
       "      <td>רחובות</td>\n",
       "      <td>רחובות</td>\n",
       "      <td>גליל עליון ורמת הגולן</td>\n",
       "      <td>גליל עליון ורמת הגולן</td>\n",
       "      <td>נהריה</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>end_zone</th>\n",
       "      <td>רחובות</td>\n",
       "      <td>רחובות</td>\n",
       "      <td>גליל עליון ורמת הגולן</td>\n",
       "      <td>גליל עליון ורמת הגולן</td>\n",
       "      <td>נהריה</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>num_zones</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>num_zones_missing</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>all_stop_latlon</th>\n",
       "      <td>31.8907,34.731190999999995;31.887865,34.734514...</td>\n",
       "      <td>31.862122999999997,34.744215000000004;31.86247...</td>\n",
       "      <td>32.960471999999996,35.495490999999994;32.95867...</td>\n",
       "      <td>32.971863,35.493324;32.966725,35.495154;32.963...</td>\n",
       "      <td>32.992835,35.25803;32.992971000000004,35.25616...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>all_stop_code</th>\n",
       "      <td>37471;31272;31273;31512;31513;31556;31514;3151...</td>\n",
       "      <td>31521;31225;31307;31517;31518;31227;31228;3253...</td>\n",
       "      <td>51090;58004;51173;58005;58006;51094;51148;5115...</td>\n",
       "      <td>55797;51087;59922;51102;51090;57027;57028;5800...</td>\n",
       "      <td>59976;59975;59974;58363;59972;58365;58366;5836...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>all_stop_id</th>\n",
       "      <td>38725;15582;15583;15736;15737;15778;15738;1573...</td>\n",
       "      <td>15745;15538;15598;15741;15742;15539;15540;1646...</td>\n",
       "      <td>18423;5617;18496;5618;5619;18426;18477;18484;1...</td>\n",
       "      <td>37179;18421;7216;18434;18423;5242;5243;5617;56...</td>\n",
       "      <td>7270;7269;7268;5951;7266;5953;5954;5955;5956;5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>all_stop_desc_city</th>\n",
       "      <td>יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;י...</td>\n",
       "      <td>יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;י...</td>\n",
       "      <td>צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפ...</td>\n",
       "      <td>צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפ...</td>\n",
       "      <td>כפר ורדים;כפר ורדים;כפר ורדים;כפר ורדים;כפר ור...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>all_start_time</th>\n",
       "      <td>05:10:00;05:40:00;06:00:00;06:20:00;08:45:00;0...</td>\n",
       "      <td>06:05:00;06:25:00;07:05:00;07:25:00;08:05:00;0...</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>13:00:00;16:30:00;14:00:00;16:30:00;13:00:00</td>\n",
       "      <td>07:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>all_trip_id</th>\n",
       "      <td>29647586_270319;29647587_270319;29647588_27031...</td>\n",
       "      <td>29648621_270319;29648622_270319;29648623_27031...</td>\n",
       "      <td>15441277_270319</td>\n",
       "      <td>35390699_270319;35390704_270319;35390709_27031...</td>\n",
       "      <td>4585781_270319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <td>2019-03-28</td>\n",
       "      <td>2019-03-28</td>\n",
       "      <td>2019-03-28</td>\n",
       "      <td>2019-03-28</td>\n",
       "      <td>2019-03-28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                    0  \\\n",
       "route_id                                                            1   \n",
       "route_short_name                                                    1   \n",
       "agency_id                                                          25   \n",
       "agency_name                                                    אפיקים   \n",
       "route_long_name     ת. רכבת יבנה מערב-יבנה<->ת. רכבת יבנה מזרח-יבנ...   \n",
       "route_type                                                          3   \n",
       "route_mkt                                                       67001   \n",
       "route_direction                                                     1   \n",
       "route_alternative                                                   #   \n",
       "num_trips                                                          26   \n",
       "num_trip_starts                                                    26   \n",
       "num_trip_ends                                                      26   \n",
       "is_loop                                                             0   \n",
       "is_bidirectional                                                    0   \n",
       "start_time                                                   05:10:00   \n",
       "end_time                                                     21:54:38   \n",
       "max_headway                                                        65   \n",
       "min_headway                                                        20   \n",
       "mean_headway                                                  37.8125   \n",
       "peak_num_trips                                                      1   \n",
       "peak_start_time                                              05:10:00   \n",
       "peak_end_time                                                05:29:38   \n",
       "service_distance                                               183144   \n",
       "service_duration                                              8.50778   \n",
       "service_speed                                                 21.5267   \n",
       "mean_trip_distance                                               7044   \n",
       "mean_trip_duration                                           0.327222   \n",
       "start_stop_id                                                   38725   \n",
       "end_stop_id                                                     15745   \n",
       "start_stop_name                                     ת. רכבת יבנה מערב   \n",
       "end_stop_name                                       ת. רכבת יבנה מזרח   \n",
       "start_stop_city                                                  יבנה   \n",
       "end_stop_city                                                    יבנה   \n",
       "start_stop_desc                        רחוב:  עיר: יבנה רציף:   קומה:   \n",
       "end_stop_desc                          רחוב:  עיר: יבנה רציף:   קומה:   \n",
       "start_stop_lat                                                31.8907   \n",
       "start_stop_lon                                                34.7312   \n",
       "end_stop_lat                                                  31.8621   \n",
       "end_stop_lon                                                  34.7442   \n",
       "num_stops                                                          19   \n",
       "start_zone                                                     רחובות   \n",
       "end_zone                                                       רחובות   \n",
       "num_zones                                                           1   \n",
       "num_zones_missing                                                   0   \n",
       "all_stop_latlon     31.8907,34.731190999999995;31.887865,34.734514...   \n",
       "all_stop_code       37471;31272;31273;31512;31513;31556;31514;3151...   \n",
       "all_stop_id         38725;15582;15583;15736;15737;15778;15738;1573...   \n",
       "all_stop_desc_city  יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;י...   \n",
       "all_start_time      05:10:00;05:40:00;06:00:00;06:20:00;08:45:00;0...   \n",
       "all_trip_id         29647586_270319;29647587_270319;29647588_27031...   \n",
       "date                                                       2019-03-28   \n",
       "\n",
       "                                                                    1  \\\n",
       "route_id                                                           10   \n",
       "route_short_name                                                    4   \n",
       "agency_id                                                          25   \n",
       "agency_name                                                    אפיקים   \n",
       "route_long_name     ת. רכבת יבנה מזרח-יבנה<->ת. רכבת יבנה מערב-יבנ...   \n",
       "route_type                                                          3   \n",
       "route_mkt                                                       47004   \n",
       "route_direction                                                     2   \n",
       "route_alternative                                                   #   \n",
       "num_trips                                                          35   \n",
       "num_trip_starts                                                    35   \n",
       "num_trip_ends                                                      35   \n",
       "is_loop                                                             0   \n",
       "is_bidirectional                                                    0   \n",
       "start_time                                                   06:05:00   \n",
       "end_time                                                     22:50:38   \n",
       "max_headway                                                        50   \n",
       "min_headway                                                        10   \n",
       "mean_headway                                                       28   \n",
       "peak_num_trips                                                      2   \n",
       "peak_start_time                                              15:55:00   \n",
       "peak_end_time                                                16:05:38   \n",
       "service_distance                                               280490   \n",
       "service_duration                                              12.0361   \n",
       "service_speed                                                  23.304   \n",
       "mean_trip_distance                                               8014   \n",
       "mean_trip_duration                                           0.343889   \n",
       "start_stop_id                                                   15745   \n",
       "end_stop_id                                                     38725   \n",
       "start_stop_name                                     ת. רכבת יבנה מזרח   \n",
       "end_stop_name                                       ת. רכבת יבנה מערב   \n",
       "start_stop_city                                                  יבנה   \n",
       "end_stop_city                                                    יבנה   \n",
       "start_stop_desc                        רחוב:  עיר: יבנה רציף:   קומה:   \n",
       "end_stop_desc                          רחוב:  עיר: יבנה רציף:   קומה:   \n",
       "start_stop_lat                                                31.8621   \n",
       "start_stop_lon                                                34.7442   \n",
       "end_stop_lat                                                  31.8907   \n",
       "end_stop_lon                                                  34.7312   \n",
       "num_stops                                                          25   \n",
       "start_zone                                                     רחובות   \n",
       "end_zone                                                       רחובות   \n",
       "num_zones                                                           1   \n",
       "num_zones_missing                                                   0   \n",
       "all_stop_latlon     31.862122999999997,34.744215000000004;31.86247...   \n",
       "all_stop_code       31521;31225;31307;31517;31518;31227;31228;3253...   \n",
       "all_stop_id         15745;15538;15598;15741;15742;15539;15540;1646...   \n",
       "all_stop_desc_city  יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;יבנה;י...   \n",
       "all_start_time      06:05:00;06:25:00;07:05:00;07:25:00;08:05:00;0...   \n",
       "all_trip_id         29648621_270319;29648622_270319;29648623_27031...   \n",
       "date                                                       2019-03-28   \n",
       "\n",
       "                                                                    2  \\\n",
       "route_id                                                        10000   \n",
       "route_short_name                                                   91   \n",
       "agency_id                                                          14   \n",
       "agency_name                                               נתיב אקספרס   \n",
       "route_long_name          קופת חולים/הנשיא-צפת<->דרך חטיבת יפתח-צפת-11   \n",
       "route_type                                                          3   \n",
       "route_mkt                                                       27091   \n",
       "route_direction                                                     1   \n",
       "route_alternative                                                   1   \n",
       "num_trips                                                           1   \n",
       "num_trip_starts                                                     1   \n",
       "num_trip_ends                                                       1   \n",
       "is_loop                                                             0   \n",
       "is_bidirectional                                                    0   \n",
       "start_time                                                   08:00:00   \n",
       "end_time                                                     08:17:31   \n",
       "max_headway                                                       NaN   \n",
       "min_headway                                                       NaN   \n",
       "mean_headway                                                      NaN   \n",
       "peak_num_trips                                                      1   \n",
       "peak_start_time                                              08:00:00   \n",
       "peak_end_time                                                08:17:31   \n",
       "service_distance                                                 6326   \n",
       "service_duration                                             0.291944   \n",
       "service_speed                                                 21.6685   \n",
       "mean_trip_distance                                               6326   \n",
       "mean_trip_duration                                           0.291944   \n",
       "start_stop_id                                                   18423   \n",
       "end_stop_id                                                     38800   \n",
       "start_stop_name                                      קופת חולים/הנשיא   \n",
       "end_stop_name                                          דרך חטיבת יפתח   \n",
       "start_stop_city                                                   צפת   \n",
       "end_stop_city                                                     צפת   \n",
       "start_stop_desc                    רחוב:הנשיא  עיר: צפת רציף:   קומה:   \n",
       "end_stop_desc             רחוב:דרך חטיבת יפתח  עיר: צפת רציף:   קומה:   \n",
       "start_stop_lat                                                32.9605   \n",
       "start_stop_lon                                                35.4955   \n",
       "end_stop_lat                                                  32.9684   \n",
       "end_stop_lon                                                  35.4944   \n",
       "num_stops                                                          23   \n",
       "start_zone                                      גליל עליון ורמת הגולן   \n",
       "end_zone                                        גליל עליון ורמת הגולן   \n",
       "num_zones                                                           1   \n",
       "num_zones_missing                                                   0   \n",
       "all_stop_latlon     32.960471999999996,35.495490999999994;32.95867...   \n",
       "all_stop_code       51090;58004;51173;58005;58006;51094;51148;5115...   \n",
       "all_stop_id         18423;5617;18496;5618;5619;18426;18477;18484;1...   \n",
       "all_stop_desc_city  צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפ...   \n",
       "all_start_time                                               08:00:00   \n",
       "all_trip_id                                           15441277_270319   \n",
       "date                                                       2019-03-28   \n",
       "\n",
       "                                                                    3  \\\n",
       "route_id                                                        10001   \n",
       "route_short_name                                                   91   \n",
       "agency_id                                                          14   \n",
       "agency_name                                               נתיב אקספרס   \n",
       "route_long_name      האר''י/ישראל ב''ק-צפת<->שפרינצק/קרן היסוד-צפת-2#   \n",
       "route_type                                                          3   \n",
       "route_mkt                                                       27091   \n",
       "route_direction                                                     2   \n",
       "route_alternative                                                   #   \n",
       "num_trips                                                           5   \n",
       "num_trip_starts                                                     5   \n",
       "num_trip_ends                                                       5   \n",
       "is_loop                                                             0   \n",
       "is_bidirectional                                                    0   \n",
       "start_time                                                   13:00:00   \n",
       "end_time                                                     16:51:42   \n",
       "max_headway                                                       150   \n",
       "min_headway                                                         0   \n",
       "mean_headway                                                     52.5   \n",
       "peak_num_trips                                                      2   \n",
       "peak_start_time                                              13:00:00   \n",
       "peak_end_time                                                13:21:42   \n",
       "service_distance                                                41880   \n",
       "service_duration                                              1.80833   \n",
       "service_speed                                                 23.1594   \n",
       "mean_trip_distance                                               8376   \n",
       "mean_trip_duration                                           0.361667   \n",
       "start_stop_id                                                   37179   \n",
       "end_stop_id                                                     18420   \n",
       "start_stop_name                                     האר''י/ישראל ב''ק   \n",
       "end_stop_name                                       שפרינצק/קרן היסוד   \n",
       "start_stop_city                                                   צפת   \n",
       "end_stop_city                                                     צפת   \n",
       "start_stop_desc                  רחוב:האר''י 4 עיר: צפת רציף:   קומה:   \n",
       "end_stop_desc                    רחוב:שפרינצק  עיר: צפת רציף:   קומה:   \n",
       "start_stop_lat                                                32.9719   \n",
       "start_stop_lon                                                35.4933   \n",
       "end_stop_lat                                                  32.9585   \n",
       "end_stop_lon                                                  35.4942   \n",
       "num_stops                                                          26   \n",
       "start_zone                                      גליל עליון ורמת הגולן   \n",
       "end_zone                                        גליל עליון ורמת הגולן   \n",
       "num_zones                                                           1   \n",
       "num_zones_missing                                                   0   \n",
       "all_stop_latlon     32.971863,35.493324;32.966725,35.495154;32.963...   \n",
       "all_stop_code       55797;51087;59922;51102;51090;57027;57028;5800...   \n",
       "all_stop_id         37179;18421;7216;18434;18423;5242;5243;5617;56...   \n",
       "all_stop_desc_city  צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפת;צפ...   \n",
       "all_start_time           13:00:00;16:30:00;14:00:00;16:30:00;13:00:00   \n",
       "all_trip_id         35390699_270319;35390704_270319;35390709_27031...   \n",
       "date                                                       2019-03-28   \n",
       "\n",
       "                                                                    4  \n",
       "route_id                                                        10002  \n",
       "route_short_name                                                   92  \n",
       "agency_id                                                          14  \n",
       "agency_name                                               נתיב אקספרס  \n",
       "route_long_name     געתון/מירון-כפר ורדים<->בית ספר כפר ורדים-כפר ...  \n",
       "route_type                                                          3  \n",
       "route_mkt                                                       25092  \n",
       "route_direction                                                     1  \n",
       "route_alternative                                                   #  \n",
       "num_trips                                                           1  \n",
       "num_trip_starts                                                     1  \n",
       "num_trip_ends                                                       1  \n",
       "is_loop                                                             0  \n",
       "is_bidirectional                                                    0  \n",
       "start_time                                                   07:30:00  \n",
       "end_time                                                     07:53:25  \n",
       "max_headway                                                       NaN  \n",
       "min_headway                                                       NaN  \n",
       "mean_headway                                                      NaN  \n",
       "peak_num_trips                                                      1  \n",
       "peak_start_time                                              07:30:00  \n",
       "peak_end_time                                                07:53:25  \n",
       "service_distance                                                 7340  \n",
       "service_duration                                             0.390278  \n",
       "service_speed                                                 18.8071  \n",
       "mean_trip_distance                                               7340  \n",
       "mean_trip_duration                                           0.390278  \n",
       "start_stop_id                                                    7270  \n",
       "end_stop_id                                                     17976  \n",
       "start_stop_name                                           געתון/מירון  \n",
       "end_stop_name                                       בית ספר כפר ורדים  \n",
       "start_stop_city                                             כפר ורדים  \n",
       "end_stop_city                                               כפר ורדים  \n",
       "start_stop_desc            רחוב:מירון 69 עיר: כפר ורדים רציף:   קומה:  \n",
       "end_stop_desc                 רחוב:אשכר  עיר: כפר ורדים רציף:   קומה:  \n",
       "start_stop_lat                                                32.9928  \n",
       "start_stop_lon                                                 35.258  \n",
       "end_stop_lat                                                  32.9961  \n",
       "end_stop_lon                                                  35.2771  \n",
       "num_stops                                                          17  \n",
       "start_zone                                                      נהריה  \n",
       "end_zone                                                        נהריה  \n",
       "num_zones                                                           1  \n",
       "num_zones_missing                                                   0  \n",
       "all_stop_latlon     32.992835,35.25803;32.992971000000004,35.25616...  \n",
       "all_stop_code       59976;59975;59974;58363;59972;58365;58366;5836...  \n",
       "all_stop_id         7270;7269;7268;5951;7266;5953;5954;5955;5956;5...  \n",
       "all_stop_desc_city  כפר ורדים;כפר ורדים;כפר ורדים;כפר ורדים;כפר ור...  \n",
       "all_start_time                                               07:30:00  \n",
       "all_trip_id                                            4585781_270319  \n",
       "date                                                       2019-03-28  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rs_path = 'data/gtfs_stats_csv_gz_hack/2019-03-28_route_stats.csv.gz'\n",
    "\n",
    "rs = pd.read_csv(rs_path, compression='gzip', index_col=0)\n",
    "\n",
    "rs.head().T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-03-29T16:09:06.670495Z",
     "start_time": "2019-03-29T16:09:06.561109Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>route_id</th>\n",
       "      <th>route_short_name</th>\n",
       "      <th>agency_id</th>\n",
       "      <th>agency_name</th>\n",
       "      <th>route_long_name</th>\n",
       "      <th>route_type</th>\n",
       "      <th>route_mkt</th>\n",
       "      <th>route_direction</th>\n",
       "      <th>route_alternative</th>\n",
       "      <th>num_trips</th>\n",
       "      <th>...</th>\n",
       "      <th>end_zone</th>\n",
       "      <th>num_zones</th>\n",
       "      <th>num_zones_missing</th>\n",
       "      <th>all_stop_latlon</th>\n",
       "      <th>all_stop_code</th>\n",
       "      <th>all_stop_id</th>\n",
       "      <th>all_stop_desc_city</th>\n",
       "      <th>all_start_time</th>\n",
       "      <th>all_trip_id</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4395</th>\n",
       "      <td>2369</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>דן</td>\n",
       "      <td>מסוף האוניברסיטה-תל אביב יפו&lt;-&gt;מרינה-בת ים-10</td>\n",
       "      <td>3</td>\n",
       "      <td>15025</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>82</td>\n",
       "      <td>...</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32.117554,34.804116;32.117385999999996,34.8059...</td>\n",
       "      <td>21508;20482;21734;20137;25075;21227;21385;2146...</td>\n",
       "      <td>13124;29568;13229;29398;13359;12936;13049;1310...</td>\n",
       "      <td>תל אביב יפו;תל אביב יפו;תל אביב יפו;תל אביב יפ...</td>\n",
       "      <td>08:05:00;08:15:00;08:25:00;08:34:00;08:43:00;0...</td>\n",
       "      <td>36921116_270319;36921117_270319;36921118_27031...</td>\n",
       "      <td>2019-03-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4402</th>\n",
       "      <td>2373</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>דן</td>\n",
       "      <td>מסוף האוניברסיטה-תל אביב יפו&lt;-&gt;מרינה-בת ים-13</td>\n",
       "      <td>3</td>\n",
       "      <td>15025</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32.117554,34.804116;32.122078,34.798889;32.124...</td>\n",
       "      <td>21508;21234;26649;26688;26693;26689;21389;2138...</td>\n",
       "      <td>13124;12943;14113;14127;14131;14128;13052;1305...</td>\n",
       "      <td>תל אביב יפו;תל אביב יפו;תל אביב יפו;תל אביב יפ...</td>\n",
       "      <td>06:45:00;07:05:00;07:14:00;07:22:00;07:30:00;0...</td>\n",
       "      <td>36331418_270319;36331419_270319;36331420_27031...</td>\n",
       "      <td>2019-03-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4409</th>\n",
       "      <td>2376</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>דן</td>\n",
       "      <td>מסוף האוניברסיטה-תל אביב יפו&lt;-&gt;מרינה-בת ים-16</td>\n",
       "      <td>3</td>\n",
       "      <td>15025</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32.117554,34.804116;32.117385999999996,34.8059...</td>\n",
       "      <td>21508;20482;21734;20137;25075;21227;21385;2146...</td>\n",
       "      <td>13124;29568;13229;29398;13359;12936;13049;1310...</td>\n",
       "      <td>תל אביב יפו;תל אביב יפו;תל אביב יפו;תל אביב יפ...</td>\n",
       "      <td>06:56:00;08:59:00;10:03:00;11:05:00;11:54:00;1...</td>\n",
       "      <td>36331462_270319;36331463_270319;36331464_27031...</td>\n",
       "      <td>2019-03-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4416</th>\n",
       "      <td>2377</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>דן</td>\n",
       "      <td>בית התפוצות/קלאוזנר-תל אביב יפו&lt;-&gt;מרינה-בת ים-17</td>\n",
       "      <td>3</td>\n",
       "      <td>15025</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32.113359,34.80742;32.109701,34.80702;32.10670...</td>\n",
       "      <td>20137;25075;21227;21385;21469;26312;26635;2167...</td>\n",
       "      <td>29398;13359;12936;13049;13100;13947;14104;1320...</td>\n",
       "      <td>תל אביב יפו;תל אביב יפו;תל אביב יפו;תל אביב יפ...</td>\n",
       "      <td>05:30:00;05:55:00;06:15:00;06:30:00;23:50:00</td>\n",
       "      <td>36331525_270319;36331526_270319;36331527_27031...</td>\n",
       "      <td>2019-03-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4424</th>\n",
       "      <td>2379</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>דן</td>\n",
       "      <td>מרינה-בת ים&lt;-&gt;מסוף האוניברסיטה-תל אביב יפו-20</td>\n",
       "      <td>3</td>\n",
       "      <td>15025</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>...</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32.008577,34.737856;32.011267,34.740164;32.012...</td>\n",
       "      <td>36095;36101;36103;36130;33891;36206;36204;3621...</td>\n",
       "      <td>23907;23911;23913;23937;21940;23997;23995;2400...</td>\n",
       "      <td>בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת י...</td>\n",
       "      <td>05:43:00;05:57:00;06:08:00;06:16:00;06:24:00;0...</td>\n",
       "      <td>36921568_270319;36921569_270319;36921570_27031...</td>\n",
       "      <td>2019-03-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4427</th>\n",
       "      <td>2381</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>דן</td>\n",
       "      <td>מרינה-בת ים&lt;-&gt;מסוף האוניברסיטה-תל אביב יפו-26</td>\n",
       "      <td>3</td>\n",
       "      <td>15025</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32.008577,34.737856;32.011267,34.740164;32.012...</td>\n",
       "      <td>36095;36101;36103;36130;33891;36206;36204;3621...</td>\n",
       "      <td>23907;23911;23913;23937;21940;23997;23995;2400...</td>\n",
       "      <td>בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת י...</td>\n",
       "      <td>08:56:00;09:56:00;10:59:00;12:03:00;12:56:00;1...</td>\n",
       "      <td>36331554_270319;36331555_270319;36331556_27031...</td>\n",
       "      <td>2019-03-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4435</th>\n",
       "      <td>2382</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>דן</td>\n",
       "      <td>מרינה-בת ים&lt;-&gt;בית התפוצות/קלאוזנר-תל אביב יפו-27</td>\n",
       "      <td>3</td>\n",
       "      <td>15025</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>גוש דן</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32.008577,34.737856;32.011267,34.740164;32.012...</td>\n",
       "      <td>36095;36101;36103;36130;33891;36206;36204;3621...</td>\n",
       "      <td>23907;23911;23913;23937;21940;23997;23995;2400...</td>\n",
       "      <td>בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת י...</td>\n",
       "      <td>04:50:00;05:10:00;05:28:00;22:25:00</td>\n",
       "      <td>36331608_270319;36331609_270319;36331610_27031...</td>\n",
       "      <td>2019-03-28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7 rows × 51 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      route_id route_short_name  agency_id agency_name  \\\n",
       "4395      2369               25          5          דן   \n",
       "4402      2373               25          5          דן   \n",
       "4409      2376               25          5          דן   \n",
       "4416      2377               25          5          דן   \n",
       "4424      2379               25          5          דן   \n",
       "4427      2381               25          5          דן   \n",
       "4435      2382               25          5          דן   \n",
       "\n",
       "                                       route_long_name  route_type  route_mkt  \\\n",
       "4395     מסוף האוניברסיטה-תל אביב יפו<->מרינה-בת ים-10           3      15025   \n",
       "4402     מסוף האוניברסיטה-תל אביב יפו<->מרינה-בת ים-13           3      15025   \n",
       "4409     מסוף האוניברסיטה-תל אביב יפו<->מרינה-בת ים-16           3      15025   \n",
       "4416  בית התפוצות/קלאוזנר-תל אביב יפו<->מרינה-בת ים-17           3      15025   \n",
       "4424     מרינה-בת ים<->מסוף האוניברסיטה-תל אביב יפו-20           3      15025   \n",
       "4427     מרינה-בת ים<->מסוף האוניברסיטה-תל אביב יפו-26           3      15025   \n",
       "4435  מרינה-בת ים<->בית התפוצות/קלאוזנר-תל אביב יפו-27           3      15025   \n",
       "\n",
       "      route_direction route_alternative  num_trips     ...      end_zone  \\\n",
       "4395                1                 0         82     ...        גוש דן   \n",
       "4402                1                 3          8     ...        גוש דן   \n",
       "4409                1                 6         12     ...        גוש דן   \n",
       "4416                1                 7          5     ...        גוש דן   \n",
       "4424                2                 0         89     ...        גוש דן   \n",
       "4427                2                 6         10     ...        גוש דן   \n",
       "4435                2                 7          4     ...        גוש דן   \n",
       "\n",
       "      num_zones  num_zones_missing  \\\n",
       "4395          1                  0   \n",
       "4402          1                  0   \n",
       "4409          1                  0   \n",
       "4416          1                  0   \n",
       "4424          1                  0   \n",
       "4427          1                  0   \n",
       "4435          1                  0   \n",
       "\n",
       "                                        all_stop_latlon  \\\n",
       "4395  32.117554,34.804116;32.117385999999996,34.8059...   \n",
       "4402  32.117554,34.804116;32.122078,34.798889;32.124...   \n",
       "4409  32.117554,34.804116;32.117385999999996,34.8059...   \n",
       "4416  32.113359,34.80742;32.109701,34.80702;32.10670...   \n",
       "4424  32.008577,34.737856;32.011267,34.740164;32.012...   \n",
       "4427  32.008577,34.737856;32.011267,34.740164;32.012...   \n",
       "4435  32.008577,34.737856;32.011267,34.740164;32.012...   \n",
       "\n",
       "                                          all_stop_code  \\\n",
       "4395  21508;20482;21734;20137;25075;21227;21385;2146...   \n",
       "4402  21508;21234;26649;26688;26693;26689;21389;2138...   \n",
       "4409  21508;20482;21734;20137;25075;21227;21385;2146...   \n",
       "4416  20137;25075;21227;21385;21469;26312;26635;2167...   \n",
       "4424  36095;36101;36103;36130;33891;36206;36204;3621...   \n",
       "4427  36095;36101;36103;36130;33891;36206;36204;3621...   \n",
       "4435  36095;36101;36103;36130;33891;36206;36204;3621...   \n",
       "\n",
       "                                            all_stop_id  \\\n",
       "4395  13124;29568;13229;29398;13359;12936;13049;1310...   \n",
       "4402  13124;12943;14113;14127;14131;14128;13052;1305...   \n",
       "4409  13124;29568;13229;29398;13359;12936;13049;1310...   \n",
       "4416  29398;13359;12936;13049;13100;13947;14104;1320...   \n",
       "4424  23907;23911;23913;23937;21940;23997;23995;2400...   \n",
       "4427  23907;23911;23913;23937;21940;23997;23995;2400...   \n",
       "4435  23907;23911;23913;23937;21940;23997;23995;2400...   \n",
       "\n",
       "                                     all_stop_desc_city  \\\n",
       "4395  תל אביב יפו;תל אביב יפו;תל אביב יפו;תל אביב יפ...   \n",
       "4402  תל אביב יפו;תל אביב יפו;תל אביב יפו;תל אביב יפ...   \n",
       "4409  תל אביב יפו;תל אביב יפו;תל אביב יפו;תל אביב יפ...   \n",
       "4416  תל אביב יפו;תל אביב יפו;תל אביב יפו;תל אביב יפ...   \n",
       "4424  בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת י...   \n",
       "4427  בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת י...   \n",
       "4435  בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת ים;בת י...   \n",
       "\n",
       "                                         all_start_time  \\\n",
       "4395  08:05:00;08:15:00;08:25:00;08:34:00;08:43:00;0...   \n",
       "4402  06:45:00;07:05:00;07:14:00;07:22:00;07:30:00;0...   \n",
       "4409  06:56:00;08:59:00;10:03:00;11:05:00;11:54:00;1...   \n",
       "4416       05:30:00;05:55:00;06:15:00;06:30:00;23:50:00   \n",
       "4424  05:43:00;05:57:00;06:08:00;06:16:00;06:24:00;0...   \n",
       "4427  08:56:00;09:56:00;10:59:00;12:03:00;12:56:00;1...   \n",
       "4435                04:50:00;05:10:00;05:28:00;22:25:00   \n",
       "\n",
       "                                            all_trip_id        date  \n",
       "4395  36921116_270319;36921117_270319;36921118_27031...  2019-03-28  \n",
       "4402  36331418_270319;36331419_270319;36331420_27031...  2019-03-28  \n",
       "4409  36331462_270319;36331463_270319;36331464_27031...  2019-03-28  \n",
       "4416  36331525_270319;36331526_270319;36331527_27031...  2019-03-28  \n",
       "4424  36921568_270319;36921569_270319;36921570_27031...  2019-03-28  \n",
       "4427  36331554_270319;36331555_270319;36331556_27031...  2019-03-28  \n",
       "4435  36331608_270319;36331609_270319;36331610_27031...  2019-03-28  \n",
       "\n",
       "[7 rows x 51 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rs[(rs.route_short_name=='25') & (rs.agency_name=='דן')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-03-29T16:09:17.464784Z",
     "start_time": "2019-03-29T16:09:17.417922Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "route_mkt\n",
       "11900    77\n",
       "32020    15\n",
       "24041    14\n",
       "15019    12\n",
       "18058    12\n",
       "33055    11\n",
       "15101    11\n",
       "41081    11\n",
       "10480    11\n",
       "27070    10\n",
       "15050    10\n",
       "12185    10\n",
       "10511     9\n",
       "30072     9\n",
       "13026     9\n",
       "20054     9\n",
       "15013     8\n",
       "11500     8\n",
       "39080     8\n",
       "21070     8\n",
       "33070     8\n",
       "22073     8\n",
       "10561     8\n",
       "70001     8\n",
       "14102     8\n",
       "12350     8\n",
       "13007     8\n",
       "19049     8\n",
       "10110     8\n",
       "12186     7\n",
       "         ..\n",
       "29089     1\n",
       "29091     1\n",
       "29092     1\n",
       "11286     1\n",
       "11278     1\n",
       "11270     1\n",
       "11264     1\n",
       "28097     1\n",
       "11381     1\n",
       "28090     1\n",
       "27080     1\n",
       "11699     1\n",
       "11680     1\n",
       "11668     1\n",
       "11502     1\n",
       "27041     1\n",
       "27051     1\n",
       "11483     1\n",
       "11482     1\n",
       "11471     1\n",
       "11392     1\n",
       "27081     1\n",
       "27095     1\n",
       "27097     1\n",
       "11430     1\n",
       "28079     1\n",
       "28083     1\n",
       "28086     1\n",
       "28087     1\n",
       "10003     1\n",
       "Name: route_id, Length: 2833, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rs.groupby('route_mkt').route_id.nunique().sort_values(ascending=False)"
   ]
  },
  {
   "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"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}