openbus_26_school_kids_rides.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is an intro / tutorial notebook for getting started with GTFS data.  \n",
    "\n",
    "It is based on work that is shown on my dev blog [simplistic.me](http://simplistic.me/tag/gtfs.html). Posts there are not updated to current versions, mine or other packages'. Still, do check it out and feel free to comment or post an issue or pull request.\n",
    "\n",
    "This is only one basic workflow which I like. You can find many more examples for working with GTFS online. There are tools and packages in many languages.\n",
    "\n",
    "THE place to start is [awesome-transit](https://github.com/CUTR-at-USF/awesome-transit). \n",
    "\n",
    "TODO: Add more tools to this notebook - peartree, GTFSTK, UrbanAccess, Pandana"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Installation\n",
    "TODO: Go to open-bus README (this needs to be there)\n",
    "\n",
    "1. Install Anaconda3\n",
    "1. Create a virtual environment (call it openbus or something indicative): `conda create -n openbus`\n",
    "1. Clone [open-bus-explore](https://github.com/cjer/open-bus-explore) - `git clone https://github.com/cjer/open-bus-explore`\n",
    "1. Install everything in [requirements.txt](https://github.com/cjer/open-bus-explore/blob/master/requirements.txt)\n",
    "    1. partridge, peartree and GTFSTK require `pip install`\n",
    "    1. the rest you should install using `conda install -c conda-forge <package_name>`\n",
    "1. Run JupyterLab or Jupyter Notebook"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Imports and config"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-19T10:41:17.747534Z",
     "start_time": "2019-02-19T10:41:17.528797Z"
    }
   },
   "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": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-19T10:41:23.605494Z",
     "start_time": "2019-02-19T10:41:18.138028Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import partridge as ptg\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import altair as alt\n",
    "import datetime\n",
    "\n",
    "from gtfs_utils import *\n",
    "\n",
    "alt.renderers.enable('notebook')\n",
    "alt.data_transformers.enable('json')\n",
    "\n",
    "sns.set_style(\"white\")\n",
    "sns.set_context(\"talk\")\n",
    "sns.set_palette('Set2', 10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating a `partridge` feed\n",
    "We have a util function for getting a `partridge` feed object by date.  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-19T10:41:23.933569Z",
     "start_time": "2019-02-19T10:41:23.605494Z"
    }
   },
   "outputs": [],
   "source": [
    "LOCAL_GTFS_ZIP_PATH = 'data/gtfs_feeds/2019-02-03.zip' \n",
    "LOCAL_TARIFF_PATH = 'data/archive/2019-02-03/Tariff.zip' "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-19T10:41:37.149629Z",
     "start_time": "2019-02-19T10:41:26.464197Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "partridge.gtfs.feed"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "feed = get_partridge_feed_by_date(LOCAL_GTFS_ZIP_PATH, datetime.date.today())\n",
    "type(feed)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* *Another option would be to use `ptg.get_representative_feed()` which finds the busiest day of the gtfs file and returns a feed for that day. Not showing this here.*"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The feed has in it all the (standard) files in the original GTFS zip, as [pandas](https://github.com/pandas-dev/pandas) DataFrames."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-19T10:41:43.147781Z",
     "start_time": "2019-02-19T10:41:42.757252Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['agency',\n",
       " 'calendar',\n",
       " 'calendar_dates',\n",
       " 'config',\n",
       " 'fare_attributes',\n",
       " 'fare_rules',\n",
       " 'feed_info',\n",
       " 'frequencies',\n",
       " 'get',\n",
       " 'is_dir',\n",
       " 'path',\n",
       " 'read_file_chunks',\n",
       " 'routes',\n",
       " 'shapes',\n",
       " 'stop_times',\n",
       " 'stops',\n",
       " 'transfers',\n",
       " 'trips',\n",
       " 'view',\n",
       " 'zmap']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[x for x in dir(feed) if not x.startswith('_')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-19T10:52:45.900513Z",
     "start_time": "2019-02-19T10:52:45.572470Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43078"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "feed.stops.stop_code.astype(int).max()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-19T10:49:44.849260Z",
     "start_time": "2019-02-19T10:49:44.458726Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>stop_id</th>\n",
       "      <th>stop_code</th>\n",
       "      <th>stop_name</th>\n",
       "      <th>stop_desc</th>\n",
       "      <th>stop_lat</th>\n",
       "      <th>stop_lon</th>\n",
       "      <th>location_type</th>\n",
       "      <th>parent_station</th>\n",
       "      <th>zone_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>24068</th>\n",
       "      <td>37404</td>\n",
       "      <td>10030</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:קניון הסיטי  עיר: אשדוד רציף: 1   קומה:</td>\n",
       "      <td>31.790888</td>\n",
       "      <td>34.639905</td>\n",
       "      <td>0</td>\n",
       "      <td>11947</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24071</th>\n",
       "      <td>37407</td>\n",
       "      <td>10030</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:קניון הסיטי  עיר: אשדוד רציף: 5   קומה:</td>\n",
       "      <td>31.790888</td>\n",
       "      <td>34.639905</td>\n",
       "      <td>0</td>\n",
       "      <td>11947</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24070</th>\n",
       "      <td>37406</td>\n",
       "      <td>10030</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:קניון הסיטי  עיר: אשדוד רציף: 4   קומה:</td>\n",
       "      <td>31.790888</td>\n",
       "      <td>34.639905</td>\n",
       "      <td>0</td>\n",
       "      <td>11947</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24069</th>\n",
       "      <td>37405</td>\n",
       "      <td>10030</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:קניון הסיטי  עיר: אשדוד רציף: 3   קומה:</td>\n",
       "      <td>31.790888</td>\n",
       "      <td>34.639905</td>\n",
       "      <td>0</td>\n",
       "      <td>11947</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24001</th>\n",
       "      <td>37265</td>\n",
       "      <td>10030</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:קניון הסיטי  עיר: אשדוד רציף: 2   קומה:</td>\n",
       "      <td>31.790888</td>\n",
       "      <td>34.639905</td>\n",
       "      <td>0</td>\n",
       "      <td>11947</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24072</th>\n",
       "      <td>37408</td>\n",
       "      <td>10030</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:קניון הסיטי  עיר: אשדוד רציף: 6   קומה:</td>\n",
       "      <td>31.790888</td>\n",
       "      <td>34.639905</td>\n",
       "      <td>0</td>\n",
       "      <td>11947</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23785</th>\n",
       "      <td>36918</td>\n",
       "      <td>10313</td>\n",
       "      <td>ת. מרכזית ערד/רציפים</td>\n",
       "      <td>רחוב:  עיר: ערד רציף: 5   קומה:</td>\n",
       "      <td>31.255802</td>\n",
       "      <td>35.211836</td>\n",
       "      <td>0</td>\n",
       "      <td>12209</td>\n",
       "      <td>2560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23784</th>\n",
       "      <td>36917</td>\n",
       "      <td>10313</td>\n",
       "      <td>ת. מרכזית ערד/רציפים</td>\n",
       "      <td>רחוב:  עיר: ערד רציף: 2   קומה:</td>\n",
       "      <td>31.255802</td>\n",
       "      <td>35.211836</td>\n",
       "      <td>0</td>\n",
       "      <td>12209</td>\n",
       "      <td>2560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23770</th>\n",
       "      <td>36877</td>\n",
       "      <td>10313</td>\n",
       "      <td>ת. מרכזית ערד/רציפים</td>\n",
       "      <td>רחוב:  עיר: ערד רציף: 1   קומה:</td>\n",
       "      <td>31.255802</td>\n",
       "      <td>35.211836</td>\n",
       "      <td>0</td>\n",
       "      <td>12209</td>\n",
       "      <td>2560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23632</th>\n",
       "      <td>36154</td>\n",
       "      <td>10313</td>\n",
       "      <td>ת. מרכזית ערד/רציפים</td>\n",
       "      <td>רחוב:  עיר: ערד רציף: 4   קומה:</td>\n",
       "      <td>31.255802</td>\n",
       "      <td>35.211836</td>\n",
       "      <td>0</td>\n",
       "      <td>12209</td>\n",
       "      <td>2560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23768</th>\n",
       "      <td>36867</td>\n",
       "      <td>10313</td>\n",
       "      <td>ת. מרכזית ערד/רציפים</td>\n",
       "      <td>רחוב:  עיר: ערד רציף: 3   קומה:</td>\n",
       "      <td>31.255802</td>\n",
       "      <td>35.211836</td>\n",
       "      <td>0</td>\n",
       "      <td>12209</td>\n",
       "      <td>2560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23638</th>\n",
       "      <td>36181</td>\n",
       "      <td>10466</td>\n",
       "      <td>ת. מרכזית אילת/רציפים</td>\n",
       "      <td>רחוב:  עיר: אילת רציף: 7   קומה:</td>\n",
       "      <td>29.556565</td>\n",
       "      <td>34.952682</td>\n",
       "      <td>0</td>\n",
       "      <td>12362</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27837</th>\n",
       "      <td>42844</td>\n",
       "      <td>10466</td>\n",
       "      <td>ת. מרכזית אילת/רציפים</td>\n",
       "      <td>רחוב:  עיר: אילת רציף: 4   קומה:</td>\n",
       "      <td>29.556565</td>\n",
       "      <td>34.952682</td>\n",
       "      <td>0</td>\n",
       "      <td>12362</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23715</th>\n",
       "      <td>36558</td>\n",
       "      <td>10466</td>\n",
       "      <td>ת. מרכזית אילת/רציפים</td>\n",
       "      <td>רחוב:  עיר: אילת רציף: 2   קומה:</td>\n",
       "      <td>29.556565</td>\n",
       "      <td>34.952682</td>\n",
       "      <td>0</td>\n",
       "      <td>12362</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23664</th>\n",
       "      <td>36312</td>\n",
       "      <td>10466</td>\n",
       "      <td>ת. מרכזית אילת/רציפים</td>\n",
       "      <td>רחוב:  עיר: אילת רציף: 6   קומה:</td>\n",
       "      <td>29.556565</td>\n",
       "      <td>34.952682</td>\n",
       "      <td>0</td>\n",
       "      <td>12362</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23666</th>\n",
       "      <td>36329</td>\n",
       "      <td>10466</td>\n",
       "      <td>ת. מרכזית אילת/רציפים</td>\n",
       "      <td>רחוב:  עיר: אילת רציף: 1   קומה:</td>\n",
       "      <td>29.556565</td>\n",
       "      <td>34.952682</td>\n",
       "      <td>0</td>\n",
       "      <td>12362</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23639</th>\n",
       "      <td>36187</td>\n",
       "      <td>10466</td>\n",
       "      <td>ת. מרכזית אילת/רציפים</td>\n",
       "      <td>רחוב:  עיר: אילת רציף: 5   קומה:</td>\n",
       "      <td>29.556565</td>\n",
       "      <td>34.952682</td>\n",
       "      <td>0</td>\n",
       "      <td>12362</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23804</th>\n",
       "      <td>36947</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 1   קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24220</th>\n",
       "      <td>37658</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 6   קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23723</th>\n",
       "      <td>36763</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 3   קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24221</th>\n",
       "      <td>37659</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 7   קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24140</th>\n",
       "      <td>37537</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 9   קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24218</th>\n",
       "      <td>37656</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 4   קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23720</th>\n",
       "      <td>36599</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 2   קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24219</th>\n",
       "      <td>37657</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 5   קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24222</th>\n",
       "      <td>37660</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 8   קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24967</th>\n",
       "      <td>38961</td>\n",
       "      <td>11001</td>\n",
       "      <td>ת. מרכזית אשדוד/רציפים</td>\n",
       "      <td>רחוב:  עיר: אשדוד רציף: 10  קומה:</td>\n",
       "      <td>31.790926</td>\n",
       "      <td>34.639056</td>\n",
       "      <td>0</td>\n",
       "      <td>25539</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27701</th>\n",
       "      <td>42623</td>\n",
       "      <td>12000</td>\n",
       "      <td>ת. רכבת מלאכי-יואב/איסוף</td>\n",
       "      <td>רחוב:  עיר: יואב רציף: 1   קומה:</td>\n",
       "      <td>31.746571</td>\n",
       "      <td>34.821871</td>\n",
       "      <td>0</td>\n",
       "      <td>42174</td>\n",
       "      <td>1913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27495</th>\n",
       "      <td>42242</td>\n",
       "      <td>12000</td>\n",
       "      <td>ת. רכבת מלאכי-יואב/איסוף</td>\n",
       "      <td>רחוב:  עיר: יואב רציף:   קומה:</td>\n",
       "      <td>31.746571</td>\n",
       "      <td>34.821871</td>\n",
       "      <td>0</td>\n",
       "      <td>42174</td>\n",
       "      <td>1913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27496</th>\n",
       "      <td>42243</td>\n",
       "      <td>12001</td>\n",
       "      <td>ת. רכבת מלאכי-יואב/הורדה</td>\n",
       "      <td>רחוב:  עיר: יואב רציף:   קומה:</td>\n",
       "      <td>31.746204</td>\n",
       "      <td>34.821985</td>\n",
       "      <td>0</td>\n",
       "      <td>42173</td>\n",
       "      <td>1913</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23672</th>\n",
       "      <td>36361</td>\n",
       "      <td>55637</td>\n",
       "      <td>ת. מרכזית עפולה/רציפים</td>\n",
       "      <td>רחוב:  עיר: עפולה רציף: 5   קומה:</td>\n",
       "      <td>32.607821</td>\n",
       "      <td>35.292233</td>\n",
       "      <td>0</td>\n",
       "      <td>4967</td>\n",
       "      <td>7700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24251</th>\n",
       "      <td>37704</td>\n",
       "      <td>55815</td>\n",
       "      <td>ת. מרכזית כרמיאל/רציפים</td>\n",
       "      <td>רחוב:  עיר: כרמיאל רציף: 3   קומה:</td>\n",
       "      <td>32.922952</td>\n",
       "      <td>35.299805</td>\n",
       "      <td>0</td>\n",
       "      <td>37411</td>\n",
       "      <td>1139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24250</th>\n",
       "      <td>37703</td>\n",
       "      <td>55815</td>\n",
       "      <td>ת. מרכזית כרמיאל/רציפים</td>\n",
       "      <td>רחוב:  עיר: כרמיאל רציף: 2   קומה:</td>\n",
       "      <td>32.922952</td>\n",
       "      <td>35.299805</td>\n",
       "      <td>0</td>\n",
       "      <td>37411</td>\n",
       "      <td>1139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24150</th>\n",
       "      <td>37549</td>\n",
       "      <td>55815</td>\n",
       "      <td>ת. מרכזית כרמיאל/רציפים</td>\n",
       "      <td>רחוב:  עיר: כרמיאל רציף: 1   קומה:</td>\n",
       "      <td>32.922952</td>\n",
       "      <td>35.299805</td>\n",
       "      <td>0</td>\n",
       "      <td>37411</td>\n",
       "      <td>1139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27536</th>\n",
       "      <td>42316</td>\n",
       "      <td>55816</td>\n",
       "      <td>מסוף מגדל העמק</td>\n",
       "      <td>רחוב:  עיר: מגדל העמק רציף:   קומה:</td>\n",
       "      <td>32.679317</td>\n",
       "      <td>35.239048</td>\n",
       "      <td>0</td>\n",
       "      <td>37410</td>\n",
       "      <td>874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27662</th>\n",
       "      <td>42541</td>\n",
       "      <td>55816</td>\n",
       "      <td>מסוף מגדל העמק</td>\n",
       "      <td>רחוב:  עיר: מגדל העמק רציף: 1   קומה:</td>\n",
       "      <td>32.679317</td>\n",
       "      <td>35.239048</td>\n",
       "      <td>0</td>\n",
       "      <td>37410</td>\n",
       "      <td>874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24304</th>\n",
       "      <td>37788</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 6   קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23645</th>\n",
       "      <td>36224</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 3   קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23641</th>\n",
       "      <td>36199</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 8   קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24305</th>\n",
       "      <td>37789</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 7   קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23724</th>\n",
       "      <td>36767</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 10  קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26342</th>\n",
       "      <td>40731</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 11  קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23710</th>\n",
       "      <td>36537</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 9   קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26345</th>\n",
       "      <td>40734</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 14  קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26344</th>\n",
       "      <td>40733</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 13  קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26343</th>\n",
       "      <td>40732</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 12  קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24217</th>\n",
       "      <td>37655</td>\n",
       "      <td>57001</td>\n",
       "      <td>ת. מרכזית טבריה/רציפים</td>\n",
       "      <td>רחוב:411  עיר: טבריה רציף: 5   קומה:</td>\n",
       "      <td>32.787514</td>\n",
       "      <td>35.536817</td>\n",
       "      <td>0</td>\n",
       "      <td>5216</td>\n",
       "      <td>6700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27541</th>\n",
       "      <td>42321</td>\n",
       "      <td>57453</td>\n",
       "      <td>מסוף בית שאן</td>\n",
       "      <td>רחוב:שדרות מנחם בגין  עיר: בית שאן רציף:   קומה:</td>\n",
       "      <td>32.498160</td>\n",
       "      <td>35.505008</td>\n",
       "      <td>0</td>\n",
       "      <td>5561</td>\n",
       "      <td>9200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27592</th>\n",
       "      <td>42454</td>\n",
       "      <td>57453</td>\n",
       "      <td>מסוף בית שאן</td>\n",
       "      <td>רחוב:שדרות מנחם בגין  עיר: בית שאן רציף: 5   ק...</td>\n",
       "      <td>32.498160</td>\n",
       "      <td>35.505008</td>\n",
       "      <td>0</td>\n",
       "      <td>5561</td>\n",
       "      <td>9200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27547</th>\n",
       "      <td>42399</td>\n",
       "      <td>57453</td>\n",
       "      <td>מסוף בית שאן</td>\n",
       "      <td>רחוב:שדרות מנחם בגין  עיר: בית שאן רציף: 1   ק...</td>\n",
       "      <td>32.498160</td>\n",
       "      <td>35.505008</td>\n",
       "      <td>0</td>\n",
       "      <td>5561</td>\n",
       "      <td>9200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24151</th>\n",
       "      <td>37550</td>\n",
       "      <td>58002</td>\n",
       "      <td>ת. מרכזית צפת/רציפים</td>\n",
       "      <td>רחוב:  עיר: צפת רציף: 1   קומה:</td>\n",
       "      <td>32.969703</td>\n",
       "      <td>35.497205</td>\n",
       "      <td>0</td>\n",
       "      <td>5615</td>\n",
       "      <td>8000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24556</th>\n",
       "      <td>38379</td>\n",
       "      <td>58002</td>\n",
       "      <td>ת. מרכזית צפת/רציפים</td>\n",
       "      <td>רחוב:  עיר: צפת רציף: 3   קומה:</td>\n",
       "      <td>32.969703</td>\n",
       "      <td>35.497205</td>\n",
       "      <td>0</td>\n",
       "      <td>5615</td>\n",
       "      <td>8000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24174</th>\n",
       "      <td>37599</td>\n",
       "      <td>58002</td>\n",
       "      <td>ת. מרכזית צפת/רציפים</td>\n",
       "      <td>רחוב:  עיר: צפת רציף: 2   קומה:</td>\n",
       "      <td>32.969703</td>\n",
       "      <td>35.497205</td>\n",
       "      <td>0</td>\n",
       "      <td>5615</td>\n",
       "      <td>8000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24784</th>\n",
       "      <td>38740</td>\n",
       "      <td>58002</td>\n",
       "      <td>ת. מרכזית צפת/רציפים</td>\n",
       "      <td>רחוב:  עיר: צפת רציף: 4   קומה:</td>\n",
       "      <td>32.969703</td>\n",
       "      <td>35.497205</td>\n",
       "      <td>0</td>\n",
       "      <td>5615</td>\n",
       "      <td>8000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24307</th>\n",
       "      <td>37795</td>\n",
       "      <td>58002</td>\n",
       "      <td>ת. מרכזית צפת/רציפים</td>\n",
       "      <td>רחוב:  עיר: צפת רציף: 5   קומה:</td>\n",
       "      <td>32.969703</td>\n",
       "      <td>35.497205</td>\n",
       "      <td>0</td>\n",
       "      <td>5615</td>\n",
       "      <td>8000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27544</th>\n",
       "      <td>42352</td>\n",
       "      <td>59903</td>\n",
       "      <td>מסוף חצור הגלילית/הורדה</td>\n",
       "      <td>רחוב:  עיר: חצור הגלילית רציף:   קומה:</td>\n",
       "      <td>32.980861</td>\n",
       "      <td>35.556525</td>\n",
       "      <td>0</td>\n",
       "      <td>7197</td>\n",
       "      <td>2034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27548</th>\n",
       "      <td>42400</td>\n",
       "      <td>59903</td>\n",
       "      <td>מסוף חצור הגלילית/הורדה</td>\n",
       "      <td>רחוב:  עיר: חצור הגלילית רציף: 1   קומה:</td>\n",
       "      <td>32.980861</td>\n",
       "      <td>35.556525</td>\n",
       "      <td>0</td>\n",
       "      <td>7197</td>\n",
       "      <td>2034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27565</th>\n",
       "      <td>42424</td>\n",
       "      <td>59903</td>\n",
       "      <td>מסוף חצור הגלילית/הורדה</td>\n",
       "      <td>רחוב:  עיר: חצור הגלילית רציף:   קומה:</td>\n",
       "      <td>32.980861</td>\n",
       "      <td>35.556525</td>\n",
       "      <td>0</td>\n",
       "      <td>7197</td>\n",
       "      <td>2034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27457</th>\n",
       "      <td>42157</td>\n",
       "      <td>61316</td>\n",
       "      <td>מסוף שער בנימין/איסוף</td>\n",
       "      <td>רחוב:  עיר: מטה בנימין רציף: 2   קומה:</td>\n",
       "      <td>31.864886</td>\n",
       "      <td>35.261684</td>\n",
       "      <td>0</td>\n",
       "      <td>42149</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27456</th>\n",
       "      <td>42156</td>\n",
       "      <td>61316</td>\n",
       "      <td>מסוף שער בנימין/איסוף</td>\n",
       "      <td>רחוב:  עיר: מטה בנימין רציף: 1   קומה:</td>\n",
       "      <td>31.864886</td>\n",
       "      <td>35.261684</td>\n",
       "      <td>0</td>\n",
       "      <td>42149</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>388 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      stop_id stop_code                 stop_name  \\\n",
       "24068   37404     10030    ת. מרכזית אשדוד/רציפים   \n",
       "24071   37407     10030    ת. מרכזית אשדוד/רציפים   \n",
       "24070   37406     10030    ת. מרכזית אשדוד/רציפים   \n",
       "24069   37405     10030    ת. מרכזית אשדוד/רציפים   \n",
       "24001   37265     10030    ת. מרכזית אשדוד/רציפים   \n",
       "24072   37408     10030    ת. מרכזית אשדוד/רציפים   \n",
       "23785   36918     10313      ת. מרכזית ערד/רציפים   \n",
       "23784   36917     10313      ת. מרכזית ערד/רציפים   \n",
       "23770   36877     10313      ת. מרכזית ערד/רציפים   \n",
       "23632   36154     10313      ת. מרכזית ערד/רציפים   \n",
       "23768   36867     10313      ת. מרכזית ערד/רציפים   \n",
       "23638   36181     10466     ת. מרכזית אילת/רציפים   \n",
       "27837   42844     10466     ת. מרכזית אילת/רציפים   \n",
       "23715   36558     10466     ת. מרכזית אילת/רציפים   \n",
       "23664   36312     10466     ת. מרכזית אילת/רציפים   \n",
       "23666   36329     10466     ת. מרכזית אילת/רציפים   \n",
       "23639   36187     10466     ת. מרכזית אילת/רציפים   \n",
       "23804   36947     11001    ת. מרכזית אשדוד/רציפים   \n",
       "24220   37658     11001    ת. מרכזית אשדוד/רציפים   \n",
       "23723   36763     11001    ת. מרכזית אשדוד/רציפים   \n",
       "24221   37659     11001    ת. מרכזית אשדוד/רציפים   \n",
       "24140   37537     11001    ת. מרכזית אשדוד/רציפים   \n",
       "24218   37656     11001    ת. מרכזית אשדוד/רציפים   \n",
       "23720   36599     11001    ת. מרכזית אשדוד/רציפים   \n",
       "24219   37657     11001    ת. מרכזית אשדוד/רציפים   \n",
       "24222   37660     11001    ת. מרכזית אשדוד/רציפים   \n",
       "24967   38961     11001    ת. מרכזית אשדוד/רציפים   \n",
       "27701   42623     12000  ת. רכבת מלאכי-יואב/איסוף   \n",
       "27495   42242     12000  ת. רכבת מלאכי-יואב/איסוף   \n",
       "27496   42243     12001  ת. רכבת מלאכי-יואב/הורדה   \n",
       "...       ...       ...                       ...   \n",
       "23672   36361     55637    ת. מרכזית עפולה/רציפים   \n",
       "24251   37704     55815   ת. מרכזית כרמיאל/רציפים   \n",
       "24250   37703     55815   ת. מרכזית כרמיאל/רציפים   \n",
       "24150   37549     55815   ת. מרכזית כרמיאל/רציפים   \n",
       "27536   42316     55816            מסוף מגדל העמק   \n",
       "27662   42541     55816            מסוף מגדל העמק   \n",
       "24304   37788     57001    ת. מרכזית טבריה/רציפים   \n",
       "23645   36224     57001    ת. מרכזית טבריה/רציפים   \n",
       "23641   36199     57001    ת. מרכזית טבריה/רציפים   \n",
       "24305   37789     57001    ת. מרכזית טבריה/רציפים   \n",
       "23724   36767     57001    ת. מרכזית טבריה/רציפים   \n",
       "26342   40731     57001    ת. מרכזית טבריה/רציפים   \n",
       "23710   36537     57001    ת. מרכזית טבריה/רציפים   \n",
       "26345   40734     57001    ת. מרכזית טבריה/רציפים   \n",
       "26344   40733     57001    ת. מרכזית טבריה/רציפים   \n",
       "26343   40732     57001    ת. מרכזית טבריה/רציפים   \n",
       "24217   37655     57001    ת. מרכזית טבריה/רציפים   \n",
       "27541   42321     57453              מסוף בית שאן   \n",
       "27592   42454     57453              מסוף בית שאן   \n",
       "27547   42399     57453              מסוף בית שאן   \n",
       "24151   37550     58002      ת. מרכזית צפת/רציפים   \n",
       "24556   38379     58002      ת. מרכזית צפת/רציפים   \n",
       "24174   37599     58002      ת. מרכזית צפת/רציפים   \n",
       "24784   38740     58002      ת. מרכזית צפת/רציפים   \n",
       "24307   37795     58002      ת. מרכזית צפת/רציפים   \n",
       "27544   42352     59903   מסוף חצור הגלילית/הורדה   \n",
       "27548   42400     59903   מסוף חצור הגלילית/הורדה   \n",
       "27565   42424     59903   מסוף חצור הגלילית/הורדה   \n",
       "27457   42157     61316     מסוף שער בנימין/איסוף   \n",
       "27456   42156     61316     מסוף שער בנימין/איסוף   \n",
       "\n",
       "                                               stop_desc   stop_lat  \\\n",
       "24068       רחוב:קניון הסיטי  עיר: אשדוד רציף: 1   קומה:  31.790888   \n",
       "24071       רחוב:קניון הסיטי  עיר: אשדוד רציף: 5   קומה:  31.790888   \n",
       "24070       רחוב:קניון הסיטי  עיר: אשדוד רציף: 4   קומה:  31.790888   \n",
       "24069       רחוב:קניון הסיטי  עיר: אשדוד רציף: 3   קומה:  31.790888   \n",
       "24001       רחוב:קניון הסיטי  עיר: אשדוד רציף: 2   קומה:  31.790888   \n",
       "24072       רחוב:קניון הסיטי  עיר: אשדוד רציף: 6   קומה:  31.790888   \n",
       "23785                    רחוב:  עיר: ערד רציף: 5   קומה:  31.255802   \n",
       "23784                    רחוב:  עיר: ערד רציף: 2   קומה:  31.255802   \n",
       "23770                    רחוב:  עיר: ערד רציף: 1   קומה:  31.255802   \n",
       "23632                    רחוב:  עיר: ערד רציף: 4   קומה:  31.255802   \n",
       "23768                    רחוב:  עיר: ערד רציף: 3   קומה:  31.255802   \n",
       "23638                   רחוב:  עיר: אילת רציף: 7   קומה:  29.556565   \n",
       "27837                   רחוב:  עיר: אילת רציף: 4   קומה:  29.556565   \n",
       "23715                   רחוב:  עיר: אילת רציף: 2   קומה:  29.556565   \n",
       "23664                   רחוב:  עיר: אילת רציף: 6   קומה:  29.556565   \n",
       "23666                   רחוב:  עיר: אילת רציף: 1   קומה:  29.556565   \n",
       "23639                   רחוב:  עיר: אילת רציף: 5   קומה:  29.556565   \n",
       "23804                  רחוב:  עיר: אשדוד רציף: 1   קומה:  31.790926   \n",
       "24220                  רחוב:  עיר: אשדוד רציף: 6   קומה:  31.790926   \n",
       "23723                  רחוב:  עיר: אשדוד רציף: 3   קומה:  31.790926   \n",
       "24221                  רחוב:  עיר: אשדוד רציף: 7   קומה:  31.790926   \n",
       "24140                  רחוב:  עיר: אשדוד רציף: 9   קומה:  31.790926   \n",
       "24218                  רחוב:  עיר: אשדוד רציף: 4   קומה:  31.790926   \n",
       "23720                  רחוב:  עיר: אשדוד רציף: 2   קומה:  31.790926   \n",
       "24219                  רחוב:  עיר: אשדוד רציף: 5   קומה:  31.790926   \n",
       "24222                  רחוב:  עיר: אשדוד רציף: 8   קומה:  31.790926   \n",
       "24967                  רחוב:  עיר: אשדוד רציף: 10  קומה:  31.790926   \n",
       "27701                   רחוב:  עיר: יואב רציף: 1   קומה:  31.746571   \n",
       "27495                     רחוב:  עיר: יואב רציף:   קומה:  31.746571   \n",
       "27496                     רחוב:  עיר: יואב רציף:   קומה:  31.746204   \n",
       "...                                                  ...        ...   \n",
       "23672                  רחוב:  עיר: עפולה רציף: 5   קומה:  32.607821   \n",
       "24251                 רחוב:  עיר: כרמיאל רציף: 3   קומה:  32.922952   \n",
       "24250                 רחוב:  עיר: כרמיאל רציף: 2   קומה:  32.922952   \n",
       "24150                 רחוב:  עיר: כרמיאל רציף: 1   קומה:  32.922952   \n",
       "27536                רחוב:  עיר: מגדל העמק רציף:   קומה:  32.679317   \n",
       "27662              רחוב:  עיר: מגדל העמק רציף: 1   קומה:  32.679317   \n",
       "24304               רחוב:411  עיר: טבריה רציף: 6   קומה:  32.787514   \n",
       "23645               רחוב:411  עיר: טבריה רציף: 3   קומה:  32.787514   \n",
       "23641               רחוב:411  עיר: טבריה רציף: 8   קומה:  32.787514   \n",
       "24305               רחוב:411  עיר: טבריה רציף: 7   קומה:  32.787514   \n",
       "23724               רחוב:411  עיר: טבריה רציף: 10  קומה:  32.787514   \n",
       "26342               רחוב:411  עיר: טבריה רציף: 11  קומה:  32.787514   \n",
       "23710               רחוב:411  עיר: טבריה רציף: 9   קומה:  32.787514   \n",
       "26345               רחוב:411  עיר: טבריה רציף: 14  קומה:  32.787514   \n",
       "26344               רחוב:411  עיר: טבריה רציף: 13  קומה:  32.787514   \n",
       "26343               רחוב:411  עיר: טבריה רציף: 12  קומה:  32.787514   \n",
       "24217               רחוב:411  עיר: טבריה רציף: 5   קומה:  32.787514   \n",
       "27541   רחוב:שדרות מנחם בגין  עיר: בית שאן רציף:   קומה:  32.498160   \n",
       "27592  רחוב:שדרות מנחם בגין  עיר: בית שאן רציף: 5   ק...  32.498160   \n",
       "27547  רחוב:שדרות מנחם בגין  עיר: בית שאן רציף: 1   ק...  32.498160   \n",
       "24151                    רחוב:  עיר: צפת רציף: 1   קומה:  32.969703   \n",
       "24556                    רחוב:  עיר: צפת רציף: 3   קומה:  32.969703   \n",
       "24174                    רחוב:  עיר: צפת רציף: 2   קומה:  32.969703   \n",
       "24784                    רחוב:  עיר: צפת רציף: 4   קומה:  32.969703   \n",
       "24307                    רחוב:  עיר: צפת רציף: 5   קומה:  32.969703   \n",
       "27544             רחוב:  עיר: חצור הגלילית רציף:   קומה:  32.980861   \n",
       "27548           רחוב:  עיר: חצור הגלילית רציף: 1   קומה:  32.980861   \n",
       "27565             רחוב:  עיר: חצור הגלילית רציף:   קומה:  32.980861   \n",
       "27457             רחוב:  עיר: מטה בנימין רציף: 2   קומה:  31.864886   \n",
       "27456             רחוב:  עיר: מטה בנימין רציף: 1   קומה:  31.864886   \n",
       "\n",
       "        stop_lon  location_type parent_station zone_id  \n",
       "24068  34.639905              0          11947      70  \n",
       "24071  34.639905              0          11947      70  \n",
       "24070  34.639905              0          11947      70  \n",
       "24069  34.639905              0          11947      70  \n",
       "24001  34.639905              0          11947      70  \n",
       "24072  34.639905              0          11947      70  \n",
       "23785  35.211836              0          12209    2560  \n",
       "23784  35.211836              0          12209    2560  \n",
       "23770  35.211836              0          12209    2560  \n",
       "23632  35.211836              0          12209    2560  \n",
       "23768  35.211836              0          12209    2560  \n",
       "23638  34.952682              0          12362    2600  \n",
       "27837  34.952682              0          12362    2600  \n",
       "23715  34.952682              0          12362    2600  \n",
       "23664  34.952682              0          12362    2600  \n",
       "23666  34.952682              0          12362    2600  \n",
       "23639  34.952682              0          12362    2600  \n",
       "23804  34.639056              0          25539      70  \n",
       "24220  34.639056              0          25539      70  \n",
       "23723  34.639056              0          25539      70  \n",
       "24221  34.639056              0          25539      70  \n",
       "24140  34.639056              0          25539      70  \n",
       "24218  34.639056              0          25539      70  \n",
       "23720  34.639056              0          25539      70  \n",
       "24219  34.639056              0          25539      70  \n",
       "24222  34.639056              0          25539      70  \n",
       "24967  34.639056              0          25539      70  \n",
       "27701  34.821871              0          42174    1913  \n",
       "27495  34.821871              0          42174    1913  \n",
       "27496  34.821985              0          42173    1913  \n",
       "...          ...            ...            ...     ...  \n",
       "23672  35.292233              0           4967    7700  \n",
       "24251  35.299805              0          37411    1139  \n",
       "24250  35.299805              0          37411    1139  \n",
       "24150  35.299805              0          37411    1139  \n",
       "27536  35.239048              0          37410     874  \n",
       "27662  35.239048              0          37410     874  \n",
       "24304  35.536817              0           5216    6700  \n",
       "23645  35.536817              0           5216    6700  \n",
       "23641  35.536817              0           5216    6700  \n",
       "24305  35.536817              0           5216    6700  \n",
       "23724  35.536817              0           5216    6700  \n",
       "26342  35.536817              0           5216    6700  \n",
       "23710  35.536817              0           5216    6700  \n",
       "26345  35.536817              0           5216    6700  \n",
       "26344  35.536817              0           5216    6700  \n",
       "26343  35.536817              0           5216    6700  \n",
       "24217  35.536817              0           5216    6700  \n",
       "27541  35.505008              0           5561    9200  \n",
       "27592  35.505008              0           5561    9200  \n",
       "27547  35.505008              0           5561    9200  \n",
       "24151  35.497205              0           5615    8000  \n",
       "24556  35.497205              0           5615    8000  \n",
       "24174  35.497205              0           5615    8000  \n",
       "24784  35.497205              0           5615    8000  \n",
       "24307  35.497205              0           5615    8000  \n",
       "27544  35.556525              0           7197    2034  \n",
       "27548  35.556525              0           7197    2034  \n",
       "27565  35.556525              0           7197    2034  \n",
       "27457  35.261684              0          42149      73  \n",
       "27456  35.261684              0          42149      73  \n",
       "\n",
       "[388 rows x 9 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "feed.stops[feed.stops.stop_code.isin((feed.stops.groupby('stop_code').size()[feed.stops.groupby('stop_code').size()>1]).index)].sort_values('stop_code')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Figuring out geographical zones requires using another zip file on MoT's FTP, using `get_zones_df()`. Which returns a simple mapping `stop_code` -> (Hebrew) `zone_name` in a DataFrame as well."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-04T19:09:59.054123Z",
     "start_time": "2019-02-04T19:09:58.694791Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>stop_code</th>\n",
       "      <th>zone_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>אזור בית שמש</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>אזור בית שמש</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>הרי ירושלים</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>אזור בית שמש</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>אזור בית שמש</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  stop_code     zone_name\n",
       "0         1  אזור בית שמש\n",
       "1         2  אזור בית שמש\n",
       "2         3   הרי ירושלים\n",
       "3         4  אזור בית שמש\n",
       "4         5  אזור בית שמש"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zones = get_zones_df(LOCAL_TARIFF_PATH)\n",
    "zones.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:17:27.396566Z",
     "start_time": "2019-02-05T15:17:26.756133Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(6690, 7)"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "feed.routes.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-04T19:10:01.084917Z",
     "start_time": "2019-02-04T19:09:59.054123Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "FF9933    1370\n",
       "33CC33     228\n",
       "9933FF       9\n",
       "Name: route_color, dtype: int64"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "feed.routes.route_color.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tidy DataFrame\n",
    "A (monstrous) merged DataFrame for fancy analysis can be got using `get_tidy_feed_df()`, whom you pass a partridge feed and extra dataframes you want to merge to it (only `zones` is used here).\n",
    "\n",
    "This takes a few minutes (MoT's GTFS is big)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-04T19:15:33.497807Z",
     "start_time": "2019-02-04T19:11:30.099516Z"
    }
   },
   "outputs": [],
   "source": [
    "f = get_tidy_feed_df(feed, [zones])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "and what you get is this:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-04T19:15:34.747304Z",
     "start_time": "2019-02-04T19:15:33.497807Z"
    }
   },
   "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>departure_time</th>\n",
       "      <th>arrival_time</th>\n",
       "      <th>stop_id</th>\n",
       "      <th>stop_sequence</th>\n",
       "      <th>stop_name</th>\n",
       "      <th>stop_lat</th>\n",
       "      <th>stop_lon</th>\n",
       "      <th>stop_code</th>\n",
       "      <th>route_id</th>\n",
       "      <th>direction_id</th>\n",
       "      <th>route_short_name</th>\n",
       "      <th>route_long_name</th>\n",
       "      <th>agency_id</th>\n",
       "      <th>agency_name</th>\n",
       "      <th>zone_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10096398_020219</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>34657</td>\n",
       "      <td>1</td>\n",
       "      <td>קניון קרני שומרון</td>\n",
       "      <td>32.174395</td>\n",
       "      <td>35.091190</td>\n",
       "      <td>63436</td>\n",
       "      <td>9735</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>קניון קרני שומרון-קרני שומרון&lt;-&gt;אוניברסיטת ארי...</td>\n",
       "      <td>25</td>\n",
       "      <td>אפיקים</td>\n",
       "      <td>השומרון</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10096398_020219</td>\n",
       "      <td>21:00:40</td>\n",
       "      <td>21:00:40</td>\n",
       "      <td>35317</td>\n",
       "      <td>2</td>\n",
       "      <td>שדרות רחבעם/קרני שומרון</td>\n",
       "      <td>32.175203</td>\n",
       "      <td>35.093854</td>\n",
       "      <td>65268</td>\n",
       "      <td>9735</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>קניון קרני שומרון-קרני שומרון&lt;-&gt;אוניברסיטת ארי...</td>\n",
       "      <td>25</td>\n",
       "      <td>אפיקים</td>\n",
       "      <td>השומרון</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10096398_020219</td>\n",
       "      <td>21:01:56</td>\n",
       "      <td>21:01:56</td>\n",
       "      <td>34436</td>\n",
       "      <td>3</td>\n",
       "      <td>קוממיות/שדרות רחבעם</td>\n",
       "      <td>32.175484</td>\n",
       "      <td>35.099323</td>\n",
       "      <td>63200</td>\n",
       "      <td>9735</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>קניון קרני שומרון-קרני שומרון&lt;-&gt;אוניברסיטת ארי...</td>\n",
       "      <td>25</td>\n",
       "      <td>אפיקים</td>\n",
       "      <td>השומרון</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10096398_020219</td>\n",
       "      <td>21:04:18</td>\n",
       "      <td>21:04:18</td>\n",
       "      <td>34444</td>\n",
       "      <td>4</td>\n",
       "      <td>נווה מנחם</td>\n",
       "      <td>32.179561</td>\n",
       "      <td>35.107716</td>\n",
       "      <td>63213</td>\n",
       "      <td>9735</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>קניון קרני שומרון-קרני שומרון&lt;-&gt;אוניברסיטת ארי...</td>\n",
       "      <td>25</td>\n",
       "      <td>אפיקים</td>\n",
       "      <td>השומרון</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10096398_020219</td>\n",
       "      <td>21:14:43</td>\n",
       "      <td>21:14:43</td>\n",
       "      <td>35506</td>\n",
       "      <td>5</td>\n",
       "      <td>יקיר בסיס צבאי</td>\n",
       "      <td>32.145644</td>\n",
       "      <td>35.116951</td>\n",
       "      <td>65290</td>\n",
       "      <td>9735</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>קניון קרני שומרון-קרני שומרון&lt;-&gt;אוניברסיטת ארי...</td>\n",
       "      <td>25</td>\n",
       "      <td>אפיקים</td>\n",
       "      <td>השומרון</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           trip_id departure_time arrival_time stop_id  stop_sequence  \\\n",
       "0  10096398_020219       21:00:00     21:00:00   34657              1   \n",
       "1  10096398_020219       21:00:40     21:00:40   35317              2   \n",
       "2  10096398_020219       21:01:56     21:01:56   34436              3   \n",
       "3  10096398_020219       21:04:18     21:04:18   34444              4   \n",
       "4  10096398_020219       21:14:43     21:14:43   35506              5   \n",
       "\n",
       "                 stop_name   stop_lat   stop_lon stop_code route_id  \\\n",
       "0        קניון קרני שומרון  32.174395  35.091190     63436     9735   \n",
       "1  שדרות רחבעם/קרני שומרון  32.175203  35.093854     65268     9735   \n",
       "2      קוממיות/שדרות רחבעם  32.175484  35.099323     63200     9735   \n",
       "3                נווה מנחם  32.179561  35.107716     63213     9735   \n",
       "4           יקיר בסיס צבאי  32.145644  35.116951     65290     9735   \n",
       "\n",
       "  direction_id route_short_name  \\\n",
       "0            1               70   \n",
       "1            1               70   \n",
       "2            1               70   \n",
       "3            1               70   \n",
       "4            1               70   \n",
       "\n",
       "                                     route_long_name agency_id agency_name  \\\n",
       "0  קניון קרני שומרון-קרני שומרון<->אוניברסיטת ארי...        25      אפיקים   \n",
       "1  קניון קרני שומרון-קרני שומרון<->אוניברסיטת ארי...        25      אפיקים   \n",
       "2  קניון קרני שומרון-קרני שומרון<->אוניברסיטת ארי...        25      אפיקים   \n",
       "3  קניון קרני שומרון-קרני שומרון<->אוניברסיטת ארי...        25      אפיקים   \n",
       "4  קניון קרני שומרון-קרני שומרון<->אוניברסיטת ארי...        25      אפיקים   \n",
       "\n",
       "  zone_name  \n",
       "0   השומרון  \n",
       "1   השומרון  \n",
       "2   השומרון  \n",
       "3   השומרון  \n",
       "4   השומרון  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In the future I intend to make this more customizable (field selection, transformations and more). "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-04T19:15:35.025256Z",
     "start_time": "2019-02-04T19:15:34.747304Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3388973, 16)"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:35:11.521407Z",
     "start_time": "2019-02-05T15:35:11.333953Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "trip_id                      object\n",
       "departure_time      timedelta64[ns]\n",
       "arrival_time        timedelta64[ns]\n",
       "stop_id                      object\n",
       "stop_sequence                 int64\n",
       "stop_name                    object\n",
       "stop_lat                    float64\n",
       "stop_lon                    float64\n",
       "stop_code                    object\n",
       "route_id                   category\n",
       "direction_id               category\n",
       "route_short_name           category\n",
       "route_long_name              object\n",
       "agency_id                  category\n",
       "agency_name                category\n",
       "zone_name                  category\n",
       "dtype: object"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-04T19:15:36.083507Z",
     "start_time": "2019-02-04T19:15:35.833560Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3388973, 8)"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "feed.stop_times.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:24:14.627093Z",
     "start_time": "2019-02-05T15:24:14.408393Z"
    }
   },
   "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>agency_id</th>\n",
       "      <th>route_short_name</th>\n",
       "      <th>route_long_name</th>\n",
       "      <th>route_desc</th>\n",
       "      <th>route_type</th>\n",
       "      <th>route_color</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2923</th>\n",
       "      <td>10001</td>\n",
       "      <td>14</td>\n",
       "      <td>91</td>\n",
       "      <td>האר''י/ישראל ב''ק-צפת&lt;-&gt;שפרינצק/קרן היסוד-צפת-2#</td>\n",
       "      <td>27091-2-#</td>\n",
       "      <td>3</td>\n",
       "      <td>FF9933</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     route_id agency_id route_short_name  \\\n",
       "2923    10001        14               91   \n",
       "\n",
       "                                       route_long_name route_desc  route_type  \\\n",
       "2923  האר''י/ישראל ב''ק-צפת<->שפרינצק/קרן היסוד-צפת-2#  27091-2-#           3   \n",
       "\n",
       "     route_color  \n",
       "2923      FF9933  "
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "feed.routes[feed.routes.route_id=='10001']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:26:51.418286Z",
     "start_time": "2019-02-05T15:26:51.215211Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['270', '396', '397', ..., '25264', '25270', '25271'], dtype=object)"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "school_routes = feed.routes[feed.routes.route_color=='FF9933'].route_id.values\n",
    "school_routes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:29:57.358868Z",
     "start_time": "2019-02-05T15:29:56.874605Z"
    }
   },
   "outputs": [],
   "source": [
    "school_trips = f[f.route_id.isin(school_routes)].groupby('route_id').trip_id.nunique()\n",
    "school_trips = school_trips[school_trips>0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:31:51.825266Z",
     "start_time": "2019-02-05T15:31:51.637809Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1.5605839416058394"
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "school_trips.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:25:37.685724Z",
     "start_time": "2019-02-05T15:25:35.295619Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14.3"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.groupby('route_id').trip_id.nunique().mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:32:04.915895Z",
     "start_time": "2019-02-05T15:32:04.713261Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2138"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "school_trips.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:32:14.444903Z",
     "start_time": "2019-02-05T15:32:13.991882Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "95667"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.trip_id.nunique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "So we truly have all the stop times for one whole day of trips."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:37:55.668088Z",
     "start_time": "2019-02-05T15:37:55.152808Z"
    }
   },
   "outputs": [],
   "source": [
    "morning_school_trips = f[(f.route_id.isin(school_routes)) & (f.departure_time>=pd.Timedelta('7 hours')) & (f.departure_time<=pd.Timedelta('9 hours'))].groupby('route_id').trip_id.nunique()\n",
    "morning_school_trips = morning_school_trips[morning_school_trips>0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:38:13.444937Z",
     "start_time": "2019-02-05T15:38:13.257520Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "851"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "morning_school_trips.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:38:44.359529Z",
     "start_time": "2019-02-05T15:38:43.141071Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "18176"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f[(f.departure_time>=pd.Timedelta('7 hours')) & (f.departure_time<=pd.Timedelta('9 hours'))].trip_id.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:44:18.043868Z",
     "start_time": "2019-02-05T15:44:17.185060Z"
    }
   },
   "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>school</th>\n",
       "      <th>total</th>\n",
       "      <th>ratio</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zone_name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>גליל עליון ורמת הגולן</th>\n",
       "      <td>57</td>\n",
       "      <td>340</td>\n",
       "      <td>0.167647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>סובב כנרת ודרום רמת הגולן</th>\n",
       "      <td>34</td>\n",
       "      <td>317</td>\n",
       "      <td>0.107256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>יוקנעם- טבעון</th>\n",
       "      <td>35</td>\n",
       "      <td>338</td>\n",
       "      <td>0.103550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>כרמיאל</th>\n",
       "      <td>49</td>\n",
       "      <td>479</td>\n",
       "      <td>0.102296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>זכרון</th>\n",
       "      <td>13</td>\n",
       "      <td>137</td>\n",
       "      <td>0.094891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>נהריה</th>\n",
       "      <td>24</td>\n",
       "      <td>266</td>\n",
       "      <td>0.090226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>השומרון</th>\n",
       "      <td>9</td>\n",
       "      <td>113</td>\n",
       "      <td>0.079646</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>נצרת</th>\n",
       "      <td>69</td>\n",
       "      <td>904</td>\n",
       "      <td>0.076327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>חבל מודיעין</th>\n",
       "      <td>35</td>\n",
       "      <td>527</td>\n",
       "      <td>0.066414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>סובב חיפה</th>\n",
       "      <td>116</td>\n",
       "      <td>1837</td>\n",
       "      <td>0.063146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>חריש ואדי ערה</th>\n",
       "      <td>32</td>\n",
       "      <td>576</td>\n",
       "      <td>0.055556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>רחובות</th>\n",
       "      <td>27</td>\n",
       "      <td>531</td>\n",
       "      <td>0.050847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>נתניה</th>\n",
       "      <td>39</td>\n",
       "      <td>813</td>\n",
       "      <td>0.047970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ערד דימונה</th>\n",
       "      <td>10</td>\n",
       "      <td>221</td>\n",
       "      <td>0.045249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>אשקלון</th>\n",
       "      <td>25</td>\n",
       "      <td>561</td>\n",
       "      <td>0.044563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>סובב ירושלים</th>\n",
       "      <td>125</td>\n",
       "      <td>2916</td>\n",
       "      <td>0.042867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>עכו</th>\n",
       "      <td>19</td>\n",
       "      <td>461</td>\n",
       "      <td>0.041215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>שרון</th>\n",
       "      <td>46</td>\n",
       "      <td>1245</td>\n",
       "      <td>0.036948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ראש העין שוהם</th>\n",
       "      <td>24</td>\n",
       "      <td>716</td>\n",
       "      <td>0.033520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>גוש דן</th>\n",
       "      <td>82</td>\n",
       "      <td>5660</td>\n",
       "      <td>0.014488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>אשדוד</th>\n",
       "      <td>8</td>\n",
       "      <td>648</td>\n",
       "      <td>0.012346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>באר שבע</th>\n",
       "      <td>10</td>\n",
       "      <td>828</td>\n",
       "      <td>0.012077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>עפולה</th>\n",
       "      <td>3</td>\n",
       "      <td>363</td>\n",
       "      <td>0.008264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>עומר חורה</th>\n",
       "      <td>1</td>\n",
       "      <td>124</td>\n",
       "      <td>0.008065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>אזור בית שמש</th>\n",
       "      <td>3</td>\n",
       "      <td>375</td>\n",
       "      <td>0.008000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>הרי ירושלים</th>\n",
       "      <td>3</td>\n",
       "      <td>529</td>\n",
       "      <td>0.005671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>קריית גת</th>\n",
       "      <td>1</td>\n",
       "      <td>194</td>\n",
       "      <td>0.005155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>אזור חדרה</th>\n",
       "      <td>0</td>\n",
       "      <td>250</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>רהט להבים</th>\n",
       "      <td>0</td>\n",
       "      <td>230</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>אזור קריית ארבע</th>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>בית שאן</th>\n",
       "      <td>0</td>\n",
       "      <td>77</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>בנימין</th>\n",
       "      <td>0</td>\n",
       "      <td>57</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>בקעת ים המלח</th>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>נתיבות שדרות</th>\n",
       "      <td>0</td>\n",
       "      <td>272</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>גוש עציון</th>\n",
       "      <td>0</td>\n",
       "      <td>82</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>גוש שילה ובקעה</th>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ירוחם</th>\n",
       "      <td>0</td>\n",
       "      <td>59</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>דרום הר חברון</th>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>אופקים</th>\n",
       "      <td>0</td>\n",
       "      <td>214</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           school  total     ratio\n",
       "zone_name                                         \n",
       "גליל עליון ורמת הגולן          57    340  0.167647\n",
       "סובב כנרת ודרום רמת הגולן      34    317  0.107256\n",
       "יוקנעם- טבעון                  35    338  0.103550\n",
       "כרמיאל                         49    479  0.102296\n",
       "זכרון                          13    137  0.094891\n",
       "נהריה                          24    266  0.090226\n",
       "השומרון                         9    113  0.079646\n",
       "נצרת                           69    904  0.076327\n",
       "חבל מודיעין                    35    527  0.066414\n",
       "סובב חיפה                     116   1837  0.063146\n",
       "חריש ואדי ערה                  32    576  0.055556\n",
       "רחובות                         27    531  0.050847\n",
       "נתניה                          39    813  0.047970\n",
       "ערד דימונה                     10    221  0.045249\n",
       "אשקלון                         25    561  0.044563\n",
       "סובב ירושלים                  125   2916  0.042867\n",
       "עכו                            19    461  0.041215\n",
       "שרון                           46   1245  0.036948\n",
       "ראש העין שוהם                  24    716  0.033520\n",
       "גוש דן                         82   5660  0.014488\n",
       "אשדוד                           8    648  0.012346\n",
       "באר שבע                        10    828  0.012077\n",
       "עפולה                           3    363  0.008264\n",
       "עומר חורה                       1    124  0.008065\n",
       "אזור בית שמש                    3    375  0.008000\n",
       "הרי ירושלים                     3    529  0.005671\n",
       "קריית גת                        1    194  0.005155\n",
       "אזור חדרה                       0    250  0.000000\n",
       "רהט להבים                       0    230  0.000000\n",
       "אזור קריית ארבע                 0     32  0.000000\n",
       "בית שאן                         0     77  0.000000\n",
       "בנימין                          0     57  0.000000\n",
       "בקעת ים המלח                    0     12  0.000000\n",
       "נתיבות שדרות                    0    272  0.000000\n",
       "גוש עציון                       0     82  0.000000\n",
       "גוש שילה ובקעה                  0     20  0.000000\n",
       "ירוחם                           0     59  0.000000\n",
       "דרום הר חברון                   0     21  0.000000\n",
       "אופקים                          0    214  0.000000"
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "morn_school_by_zone = f[(f.route_id.isin(school_routes)) & (f.departure_time>=pd.Timedelta('7 hours')) & (f.departure_time<=pd.Timedelta('9 hours'))].groupby('zone_name').trip_id.nunique()\n",
    "morn_total_by_zone = f[(f.departure_time>=pd.Timedelta('7 hours')) & (f.departure_time<=pd.Timedelta('9 hours'))].groupby('zone_name').trip_id.nunique()\n",
    "\n",
    "morn_zone = pd.concat([morn_school_by_zone, morn_total_by_zone], axis=1, keys=['school', 'total'])\n",
    "morn_zone['ratio'] = morn_zone.school / morn_zone.total\n",
    "morn_zone.sort_values('ratio', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:50:28.675415Z",
     "start_time": "2019-02-05T15:50:28.472240Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(39, 3)"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "morn_zone.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:51:00.839579Z",
     "start_time": "2019-02-05T15:51:00.636538Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(17, 3)"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "morn_zone[morn_zone.ratio<0.01].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T15:51:27.536454Z",
     "start_time": "2019-02-05T15:51:27.333634Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(12, 3)"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "morn_zone[morn_zone.ratio==0].shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "וכדי לקבל סדר גודל. זה מתוך סה\"כ 6690 חלופות ברחבי הארץ. קצת יותר מעשרים אחוז.\n",
    "\n",
    "מן הסתם, אם מסתכלים על סך הנסיעות, זה הרבה פחות - קצת יותר מ-2%. אבל אם מסתכלים על נסיעות הבוקר בלבד (7 עד 9) הסעות תלמידים הן כמעט 5% מסך הנסיעות ברחבי הארץ.\n",
    "\n",
    "בחתך אשכולות גם עולים דברים מעניינים. השיא הוא של גליל עליון ורמת הגולן - 17% מנסיעות הבוקר שם הן נסיעות תלמידים. במטרופולינים גוש דן, ירושלים וחיפה זה 1%, 4% ו-6% בהתאמה. יש גם לא מעט אשכולות ללא הסעות תלמידים בכלל. 17 מתוך 39 עם פחות מ-1%, 12 מתוכם ללא נסיעות תלמידים בכלל. הגדולים בינהם הם חדרה, רהט-להבים, נתיבות-שדרות ואופקים."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-04T19:15:36.349061Z",
     "start_time": "2019-02-04T19:15:36.083507Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>stop_id</th>\n",
       "      <th>stop_code</th>\n",
       "      <th>stop_name</th>\n",
       "      <th>stop_desc</th>\n",
       "      <th>stop_lat</th>\n",
       "      <th>stop_lon</th>\n",
       "      <th>location_type</th>\n",
       "      <th>parent_station</th>\n",
       "      <th>zone_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>38831</td>\n",
       "      <td>בי''ס בר לב/בן יהודה</td>\n",
       "      <td>רחוב:בן יהודה 76 עיר: כפר סבא רציף:   קומה:</td>\n",
       "      <td>32.183939</td>\n",
       "      <td>34.917812</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>38832</td>\n",
       "      <td>הרצל/צומת בילו</td>\n",
       "      <td>רחוב:הרצל  עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>31.870034</td>\n",
       "      <td>34.819541</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>38833</td>\n",
       "      <td>הנחשול/הדייגים</td>\n",
       "      <td>רחוב:הנחשול 30 עיר: ראשון לציון רציף:   קומה:</td>\n",
       "      <td>31.984553</td>\n",
       "      <td>34.782828</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>38834</td>\n",
       "      <td>פריד/ששת הימים</td>\n",
       "      <td>רחוב:משה פריד 9 עיר: רחובות רציף:   קומה:</td>\n",
       "      <td>31.888550</td>\n",
       "      <td>34.790904</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>38836</td>\n",
       "      <td>ת. מרכזית לוד/הורדה</td>\n",
       "      <td>רחוב:  עיר: לוד רציף:   קומה:</td>\n",
       "      <td>31.956576</td>\n",
       "      <td>34.898125</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  stop_id stop_code             stop_name  \\\n",
       "0       1     38831  בי''ס בר לב/בן יהודה   \n",
       "1       2     38832        הרצל/צומת בילו   \n",
       "2       3     38833        הנחשול/הדייגים   \n",
       "3       4     38834        פריד/ששת הימים   \n",
       "4       6     38836   ת. מרכזית לוד/הורדה   \n",
       "\n",
       "                                       stop_desc   stop_lat   stop_lon  \\\n",
       "0    רחוב:בן יהודה 76 עיר: כפר סבא רציף:   קומה:  32.183939  34.917812   \n",
       "1       רחוב:הרצל  עיר: קרית עקרון רציף:   קומה:  31.870034  34.819541   \n",
       "2  רחוב:הנחשול 30 עיר: ראשון לציון רציף:   קומה:  31.984553  34.782828   \n",
       "3      רחוב:משה פריד 9 עיר: רחובות רציף:   קומה:  31.888550  34.790904   \n",
       "4                  רחוב:  עיר: לוד רציף:   קומה:  31.956576  34.898125   \n",
       "\n",
       "   location_type parent_station zone_id  \n",
       "0              0            NaN    6900  \n",
       "1              0            NaN     469  \n",
       "2              0            NaN    8300  \n",
       "3              0            NaN    8400  \n",
       "4              0            NaN    7000  "
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "feed.stops.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T13:08:28.330016Z",
     "start_time": "2019-02-05T13:08:28.110979Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'רחוב:(?P<stop_desc_street>.*)עיר:(?P<stop_desc_city>.*)רציף:(?P<stop_desc_platform>.*)קומה:(?P<stop_desc_floor>.*)'"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fields = { 'street': 'רחוב', \n",
    "           'city': 'עיר', \n",
    "           'platform': 'רציף', \n",
    "           'floor': 'קומה' }\n",
    "\n",
    "prefix='stop_desc_'\n",
    "\n",
    "STOP_DESC_RE = ''\n",
    "for n, fld in fields.items():\n",
    "    STOP_DESC_RE += fld+f':(?P<{prefix+n}>.*)'\n",
    "    \n",
    "STOP_DESC_RE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T13:08:29.501280Z",
     "start_time": "2019-02-05T13:08:29.329478Z"
    }
   },
   "outputs": [],
   "source": [
    "#STOP_DESC_RE = 'רחוב:(.*)עיר:(.*)רציף:(.*)קומה:(.*)'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T13:08:30.266720Z",
     "start_time": "2019-02-05T13:08:30.079265Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'רחוב:בן יהודה 76 עיר: כפר סבא רציף:   קומה:'"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "feed.stops.stop_desc.iat[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T13:08:31.110330Z",
     "start_time": "2019-02-05T13:08:30.688615Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>stop_desc_street</th>\n",
       "      <th>stop_desc_city</th>\n",
       "      <th>stop_desc_platform</th>\n",
       "      <th>stop_desc_floor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>בן יהודה 76</td>\n",
       "      <td>כפר סבא</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>הרצל</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>הנחשול 30</td>\n",
       "      <td>ראשון לציון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>משה פריד 9</td>\n",
       "      <td>רחובות</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td></td>\n",
       "      <td>לוד</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  stop_desc_street stop_desc_city stop_desc_platform stop_desc_floor\n",
       "0      בן יהודה 76        כפר סבא                                   \n",
       "1             הרצל     קרית עקרון                                   \n",
       "2        הנחשול 30    ראשון לציון                                   \n",
       "3       משה פריד 9         רחובות                                   \n",
       "4                             לוד                                   "
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sd = feed.stops.stop_desc.str.extract(STOP_DESC_RE).apply(lambda x: x.str.strip())\n",
    "\n",
    "sd.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-02-05T13:08:34.187717Z",
     "start_time": "2019-02-05T13:08:33.953351Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>stop_desc</th>\n",
       "      <th>stop_desc_street</th>\n",
       "      <th>stop_desc_city</th>\n",
       "      <th>stop_desc_platform</th>\n",
       "      <th>stop_desc_floor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>רחוב:בן יהודה 76 עיר: כפר סבא רציף:   קומה:</td>\n",
       "      <td>בן יהודה 76</td>\n",
       "      <td>כפר סבא</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>רחוב:הרצל  עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>הרצל</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>רחוב:הנחשול 30 עיר: ראשון לציון רציף:   קומה:</td>\n",
       "      <td>הנחשול 30</td>\n",
       "      <td>ראשון לציון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>רחוב:משה פריד 9 עיר: רחובות רציף:   קומה:</td>\n",
       "      <td>משה פריד 9</td>\n",
       "      <td>רחובות</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>רחוב:  עיר: לוד רציף:   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>לוד</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>רחוב:חנה אברך 9 עיר: רחובות רציף:   קומה:</td>\n",
       "      <td>חנה אברך 9</td>\n",
       "      <td>רחובות</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>רחוב:הרצל 20 עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>הרצל 20</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>רחוב:הבנים 4 עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>הבנים 4</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>רחוב:וייצמן 11 עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>וייצמן 11</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>רחוב:האירוס 16 עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>האירוס 16</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>רחוב:הכלנית  עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>הכלנית</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>רחוב:אלי כהן 62 עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>אלי כהן 62</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>רחוב:שבזי 40 עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>שבזי 40</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>רחוב:שבזי 31 עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>שבזי 31</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>רחוב:חיים ברלב  עיר: ראשון לציון רציף:   קומה:</td>\n",
       "      <td>חיים ברלב</td>\n",
       "      <td>ראשון לציון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>רחוב:  עיר: צור משה רציף:   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>צור משה</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>רחוב:  עיר: צור משה רציף:   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>צור משה</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>רחוב:חיים הולצמן  עיר: רחובות רציף:   קומה:</td>\n",
       "      <td>חיים הולצמן</td>\n",
       "      <td>רחובות</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>רחוב:  עיר: באר יעקב רציף:   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>באר יעקב</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>רחוב:הרצל 4 עיר: קרית עקרון רציף:   קומה:</td>\n",
       "      <td>הרצל 4</td>\n",
       "      <td>קרית עקרון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>רחוב:הרותם 3 עיר: רחובות רציף:   קומה:</td>\n",
       "      <td>הרותם 3</td>\n",
       "      <td>רחובות</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>רחוב:הערבה  עיר: צור משה רציף:   קומה:</td>\n",
       "      <td>הערבה</td>\n",
       "      <td>צור משה</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>רחוב:מבוא הגפן  עיר: ינוב רציף:   קומה:</td>\n",
       "      <td>מבוא הגפן</td>\n",
       "      <td>ינוב</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>רחוב:מבוא הגפן  עיר: ינוב רציף:   קומה:</td>\n",
       "      <td>מבוא הגפן</td>\n",
       "      <td>ינוב</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>רחוב:ההרחבה  עיר: גאולים רציף:   קומה:</td>\n",
       "      <td>ההרחבה</td>\n",
       "      <td>גאולים</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>רחוב:ההרחבה  עיר: גאולים רציף:   קומה:</td>\n",
       "      <td>ההרחבה</td>\n",
       "      <td>גאולים</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>רחוב:ההרחבה  עיר: גאולים רציף:   קומה:</td>\n",
       "      <td>ההרחבה</td>\n",
       "      <td>גאולים</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>רחוב:שדרות העליה  עיר: נמל תעופה בן גוריון רצי...</td>\n",
       "      <td>שדרות העליה</td>\n",
       "      <td>נמל תעופה בן גוריון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>רחוב:כנף  עיר: נמל תעופה בן גוריון רציף:   קומה:</td>\n",
       "      <td>כנף</td>\n",
       "      <td>נמל תעופה בן גוריון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>רחוב:החבורה 24 עיר: רחובות רציף:   קומה:</td>\n",
       "      <td>החבורה 24</td>\n",
       "      <td>רחובות</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27849</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 11  קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>11</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27851</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 10  קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>10</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27852</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 13  קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>13</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27853</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 8   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27854</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 9   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>9</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27855</th>\n",
       "      <td>רחוב:1285  עיר: תל אביב יפו רציף:   קומה:</td>\n",
       "      <td>1285</td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27856</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 7   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>7</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27857</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 14  קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>14</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27858</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 15  קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>15</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27859</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 2   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27860</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 3   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27861</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 4   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>4</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27862</th>\n",
       "      <td>רחוב:  עיר: תל אביב יפו רציף: 5   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>תל אביב יפו</td>\n",
       "      <td>5</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27863</th>\n",
       "      <td>רחוב:742  עיר: שפרעם רציף:   קומה:</td>\n",
       "      <td>742</td>\n",
       "      <td>שפרעם</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27864</th>\n",
       "      <td>רחוב:אבשלום גיסין  עיר: פתח תקווה רציף:   קומה:</td>\n",
       "      <td>אבשלום גיסין</td>\n",
       "      <td>פתח תקווה</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27865</th>\n",
       "      <td>רחוב:אבי אורן  עיר: פתח תקווה רציף:   קומה:</td>\n",
       "      <td>אבי אורן</td>\n",
       "      <td>פתח תקווה</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27866</th>\n",
       "      <td>רחוב:הסיבים  עיר: פתח תקווה רציף:   קומה:</td>\n",
       "      <td>הסיבים</td>\n",
       "      <td>פתח תקווה</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27867</th>\n",
       "      <td>רחוב:עין עבדת 2 עיר: אשקלון רציף:   קומה:</td>\n",
       "      <td>עין עבדת 2</td>\n",
       "      <td>אשקלון</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27872</th>\n",
       "      <td>רחוב:  עיר: חבל אילות רציף:   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>חבל אילות</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27873</th>\n",
       "      <td>רחוב:8721  עיר: מטה אשר רציף:   קומה:</td>\n",
       "      <td>8721</td>\n",
       "      <td>מטה אשר</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27874</th>\n",
       "      <td>רחוב:תמר  עיר: חריש רציף:   קומה:</td>\n",
       "      <td>תמר</td>\n",
       "      <td>חריש</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27875</th>\n",
       "      <td>רחוב:תמר  עיר: חריש רציף:   קומה:</td>\n",
       "      <td>תמר</td>\n",
       "      <td>חריש</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27876</th>\n",
       "      <td>רחוב:ברלב  עיר: שדרות רציף:   קומה:</td>\n",
       "      <td>ברלב</td>\n",
       "      <td>שדרות</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27877</th>\n",
       "      <td>רחוב:60  עיר: מטה בנימין רציף:   קומה:</td>\n",
       "      <td>60</td>\n",
       "      <td>מטה בנימין</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27878</th>\n",
       "      <td>רחוב:60  עיר: מטה בנימין רציף:   קומה:</td>\n",
       "      <td>60</td>\n",
       "      <td>מטה בנימין</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27879</th>\n",
       "      <td>רחוב:  עיר: חבל אילות רציף: 1   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>חבל אילות</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27880</th>\n",
       "      <td>רחוב:  עיר: חבל אילות רציף: 2   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>חבל אילות</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27881</th>\n",
       "      <td>רחוב:  עיר: לוד רציף: 1   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>לוד</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27882</th>\n",
       "      <td>רחוב:  עיר: לוד רציף: 1   קומה:</td>\n",
       "      <td></td>\n",
       "      <td>לוד</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27883</th>\n",
       "      <td>רחוב:הרב מיימון  עיר: בת ים רציף:   קומה:</td>\n",
       "      <td>הרב מיימון</td>\n",
       "      <td>בת ים</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27672 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               stop_desc stop_desc_street  \\\n",
       "0            רחוב:בן יהודה 76 עיר: כפר סבא רציף:   קומה:      בן יהודה 76   \n",
       "1               רחוב:הרצל  עיר: קרית עקרון רציף:   קומה:             הרצל   \n",
       "2          רחוב:הנחשול 30 עיר: ראשון לציון רציף:   קומה:        הנחשול 30   \n",
       "3              רחוב:משה פריד 9 עיר: רחובות רציף:   קומה:       משה פריד 9   \n",
       "4                          רחוב:  עיר: לוד רציף:   קומה:                    \n",
       "5              רחוב:חנה אברך 9 עיר: רחובות רציף:   קומה:       חנה אברך 9   \n",
       "6             רחוב:הרצל 20 עיר: קרית עקרון רציף:   קומה:          הרצל 20   \n",
       "7             רחוב:הבנים 4 עיר: קרית עקרון רציף:   קומה:          הבנים 4   \n",
       "8           רחוב:וייצמן 11 עיר: קרית עקרון רציף:   קומה:        וייצמן 11   \n",
       "9           רחוב:האירוס 16 עיר: קרית עקרון רציף:   קומה:        האירוס 16   \n",
       "10            רחוב:הכלנית  עיר: קרית עקרון רציף:   קומה:           הכלנית   \n",
       "11         רחוב:אלי כהן 62 עיר: קרית עקרון רציף:   קומה:       אלי כהן 62   \n",
       "12            רחוב:שבזי 40 עיר: קרית עקרון רציף:   קומה:          שבזי 40   \n",
       "13            רחוב:שבזי 31 עיר: קרית עקרון רציף:   קומה:          שבזי 31   \n",
       "14        רחוב:חיים ברלב  עיר: ראשון לציון רציף:   קומה:        חיים ברלב   \n",
       "15                     רחוב:  עיר: צור משה רציף:   קומה:                    \n",
       "16                     רחוב:  עיר: צור משה רציף:   קומה:                    \n",
       "17           רחוב:חיים הולצמן  עיר: רחובות רציף:   קומה:      חיים הולצמן   \n",
       "18                    רחוב:  עיר: באר יעקב רציף:   קומה:                    \n",
       "19             רחוב:הרצל 4 עיר: קרית עקרון רציף:   קומה:           הרצל 4   \n",
       "20                רחוב:הרותם 3 עיר: רחובות רציף:   קומה:          הרותם 3   \n",
       "21                רחוב:הערבה  עיר: צור משה רציף:   קומה:            הערבה   \n",
       "22               רחוב:מבוא הגפן  עיר: ינוב רציף:   קומה:        מבוא הגפן   \n",
       "23               רחוב:מבוא הגפן  עיר: ינוב רציף:   קומה:        מבוא הגפן   \n",
       "24                רחוב:ההרחבה  עיר: גאולים רציף:   קומה:           ההרחבה   \n",
       "25                רחוב:ההרחבה  עיר: גאולים רציף:   קומה:           ההרחבה   \n",
       "26                רחוב:ההרחבה  עיר: גאולים רציף:   קומה:           ההרחבה   \n",
       "27     רחוב:שדרות העליה  עיר: נמל תעופה בן גוריון רצי...      שדרות העליה   \n",
       "28      רחוב:כנף  עיר: נמל תעופה בן גוריון רציף:   קומה:              כנף   \n",
       "29              רחוב:החבורה 24 עיר: רחובות רציף:   קומה:        החבורה 24   \n",
       "...                                                  ...              ...   \n",
       "27849            רחוב:  עיר: תל אביב יפו רציף: 11  קומה:                    \n",
       "27851            רחוב:  עיר: תל אביב יפו רציף: 10  קומה:                    \n",
       "27852            רחוב:  עיר: תל אביב יפו רציף: 13  קומה:                    \n",
       "27853            רחוב:  עיר: תל אביב יפו רציף: 8   קומה:                    \n",
       "27854            רחוב:  עיר: תל אביב יפו רציף: 9   קומה:                    \n",
       "27855          רחוב:1285  עיר: תל אביב יפו רציף:   קומה:             1285   \n",
       "27856            רחוב:  עיר: תל אביב יפו רציף: 7   קומה:                    \n",
       "27857            רחוב:  עיר: תל אביב יפו רציף: 14  קומה:                    \n",
       "27858            רחוב:  עיר: תל אביב יפו רציף: 15  קומה:                    \n",
       "27859            רחוב:  עיר: תל אביב יפו רציף: 2   קומה:                    \n",
       "27860            רחוב:  עיר: תל אביב יפו רציף: 3   קומה:                    \n",
       "27861            רחוב:  עיר: תל אביב יפו רציף: 4   קומה:                    \n",
       "27862            רחוב:  עיר: תל אביב יפו רציף: 5   קומה:                    \n",
       "27863                 רחוב:742  עיר: שפרעם רציף:   קומה:              742   \n",
       "27864    רחוב:אבשלום גיסין  עיר: פתח תקווה רציף:   קומה:     אבשלום גיסין   \n",
       "27865        רחוב:אבי אורן  עיר: פתח תקווה רציף:   קומה:         אבי אורן   \n",
       "27866          רחוב:הסיבים  עיר: פתח תקווה רציף:   קומה:           הסיבים   \n",
       "27867          רחוב:עין עבדת 2 עיר: אשקלון רציף:   קומה:       עין עבדת 2   \n",
       "27872                רחוב:  עיר: חבל אילות רציף:   קומה:                    \n",
       "27873              רחוב:8721  עיר: מטה אשר רציף:   קומה:             8721   \n",
       "27874                  רחוב:תמר  עיר: חריש רציף:   קומה:              תמר   \n",
       "27875                  רחוב:תמר  עיר: חריש רציף:   קומה:              תמר   \n",
       "27876                רחוב:ברלב  עיר: שדרות רציף:   קומה:             ברלב   \n",
       "27877             רחוב:60  עיר: מטה בנימין רציף:   קומה:               60   \n",
       "27878             רחוב:60  עיר: מטה בנימין רציף:   קומה:               60   \n",
       "27879              רחוב:  עיר: חבל אילות רציף: 1   קומה:                    \n",
       "27880              רחוב:  עיר: חבל אילות רציף: 2   קומה:                    \n",
       "27881                    רחוב:  עיר: לוד רציף: 1   קומה:                    \n",
       "27882                    רחוב:  עיר: לוד רציף: 1   קומה:                    \n",
       "27883          רחוב:הרב מיימון  עיר: בת ים רציף:   קומה:       הרב מיימון   \n",
       "\n",
       "            stop_desc_city stop_desc_platform stop_desc_floor  \n",
       "0                  כפר סבא                                     \n",
       "1               קרית עקרון                                     \n",
       "2              ראשון לציון                                     \n",
       "3                   רחובות                                     \n",
       "4                      לוד                                     \n",
       "5                   רחובות                                     \n",
       "6               קרית עקרון                                     \n",
       "7               קרית עקרון                                     \n",
       "8               קרית עקרון                                     \n",
       "9               קרית עקרון                                     \n",
       "10              קרית עקרון                                     \n",
       "11              קרית עקרון                                     \n",
       "12              קרית עקרון                                     \n",
       "13              קרית עקרון                                     \n",
       "14             ראשון לציון                                     \n",
       "15                 צור משה                                     \n",
       "16                 צור משה                                     \n",
       "17                  רחובות                                     \n",
       "18                באר יעקב                                     \n",
       "19              קרית עקרון                                     \n",
       "20                  רחובות                                     \n",
       "21                 צור משה                                     \n",
       "22                    ינוב                                     \n",
       "23                    ינוב                                     \n",
       "24                  גאולים                                     \n",
       "25                  גאולים                                     \n",
       "26                  גאולים                                     \n",
       "27     נמל תעופה בן גוריון                                     \n",
       "28     נמל תעופה בן גוריון                                     \n",
       "29                  רחובות                                     \n",
       "...                    ...                ...             ...  \n",
       "27849          תל אביב יפו                 11                  \n",
       "27851          תל אביב יפו                 10                  \n",
       "27852          תל אביב יפו                 13                  \n",
       "27853          תל אביב יפו                  8                  \n",
       "27854          תל אביב יפו                  9                  \n",
       "27855          תל אביב יפו                                     \n",
       "27856          תל אביב יפו                  7                  \n",
       "27857          תל אביב יפו                 14                  \n",
       "27858          תל אביב יפו                 15                  \n",
       "27859          תל אביב יפו                  2                  \n",
       "27860          תל אביב יפו                  3                  \n",
       "27861          תל אביב יפו                  4                  \n",
       "27862          תל אביב יפו                  5                  \n",
       "27863                שפרעם                                     \n",
       "27864            פתח תקווה                                     \n",
       "27865            פתח תקווה                                     \n",
       "27866            פתח תקווה                                     \n",
       "27867               אשקלון                                     \n",
       "27872            חבל אילות                                     \n",
       "27873              מטה אשר                                     \n",
       "27874                 חריש                                     \n",
       "27875                 חריש                                     \n",
       "27876                שדרות                                     \n",
       "27877           מטה בנימין                                     \n",
       "27878           מטה בנימין                                     \n",
       "27879            חבל אילות                  1                  \n",
       "27880            חבל אילות                  2                  \n",
       "27881                  לוד                  1                  \n",
       "27882                  לוד                  1                  \n",
       "27883                בת ים                                     \n",
       "\n",
       "[27672 rows x 5 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.concat([feed.stops.stop_desc, sd], axis=1)"
   ]
  },
  {
   "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
}