trip_time_dash_lab.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-03-17T16:33:03.848357Z",
     "start_time": "2020-03-17T16:33:02.578550Z"
    },
    "execution": {
     "iopub.execute_input": "2020-03-16T14:18:41.994655Z",
     "iopub.status.busy": "2020-03-16T14:18:41.994401Z",
     "iopub.status.idle": "2020-03-16T14:18:43.175842Z",
     "shell.execute_reply": "2020-03-16T14:18:43.175411Z",
     "shell.execute_reply.started": "2020-03-16T14:18:41.994619Z"
    }
   },
   "outputs": [],
   "source": [
    "import dash\n",
    "from dash.dependencies import Input, Output\n",
    "import dash_html_components as html\n",
    "import dash_core_components as dcc\n",
    "import geopandas as gpd\n",
    "import jupyterlab_dash\n",
    "import os\n",
    "import pandas as pd\n",
    "import plotly.express as px\n",
    "import plotly.graph_objects as go\n",
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-03-16T14:18:43.176954Z",
     "iopub.status.busy": "2020-03-16T14:18:43.176729Z",
     "iopub.status.idle": "2020-03-16T14:18:55.828585Z",
     "shell.execute_reply": "2020-03-16T14:18:55.827786Z",
     "shell.execute_reply.started": "2020-03-16T14:18:43.176918Z"
    }
   },
   "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>cod_issue</th>\n",
       "      <th>cod_stop</th>\n",
       "      <th>cod_line</th>\n",
       "      <th>eta_date</th>\n",
       "      <th>arrival_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8__622____2_17:00:00_2_-__17_8__622___</td>\n",
       "      <td>8_4311</td>\n",
       "      <td>8__622___</td>\n",
       "      <td>15</td>\n",
       "      <td>2020-02-15 17:45:53+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5308413</td>\n",
       "      <td>8_1333</td>\n",
       "      <td>8__653___</td>\n",
       "      <td>15</td>\n",
       "      <td>2020-02-15 17:46:15+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5308274</td>\n",
       "      <td>8_10577</td>\n",
       "      <td>8__562___</td>\n",
       "      <td>15</td>\n",
       "      <td>2020-02-15 17:46:15+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8__661____2_17:45:00_1_-__21_8__661___</td>\n",
       "      <td>8_1338</td>\n",
       "      <td>8__661___</td>\n",
       "      <td>15</td>\n",
       "      <td>2020-02-15 17:46:20+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5308386</td>\n",
       "      <td>8_08458</td>\n",
       "      <td>8__564___</td>\n",
       "      <td>15</td>\n",
       "      <td>2020-02-15 17:46:27+01:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                cod_issue cod_stop   cod_line  eta_date  \\\n",
       "0  8__622____2_17:00:00_2_-__17_8__622___   8_4311  8__622___        15   \n",
       "1                                 5308413   8_1333  8__653___        15   \n",
       "2                                 5308274  8_10577  8__562___        15   \n",
       "3  8__661____2_17:45:00_1_-__21_8__661___   8_1338  8__661___        15   \n",
       "4                                 5308386  8_08458  8__564___        15   \n",
       "\n",
       "               arrival_time  \n",
       "0 2020-02-15 17:45:53+01:00  \n",
       "1 2020-02-15 17:46:15+01:00  \n",
       "2 2020-02-15 17:46:15+01:00  \n",
       "3 2020-02-15 17:46:20+01:00  \n",
       "4 2020-02-15 17:46:27+01:00  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "arrival_times = pd.read_csv('paralel_arrival_times_consecutive.csv', parse_dates=['arrival_time'])\n",
    "arrival_times.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-03-16T14:18:55.830778Z",
     "iopub.status.busy": "2020-03-16T14:18:55.830534Z",
     "iopub.status.idle": "2020-03-16T14:18:55.841525Z",
     "shell.execute_reply": "2020-03-16T14:18:55.840743Z",
     "shell.execute_reply.started": "2020-03-16T14:18:55.830746Z"
    }
   },
   "outputs": [],
   "source": [
    " def get_trip_times(cod_stop_from='8_1336', cod_stop_to = '8_06277'):\n",
    "    trip_times_array = []\n",
    "    #arrival_times_from = arrival_times.query(\"cod_line == '8__658___'\")\n",
    "    selected_arrival_times = arrival_times.query(\"cod_stop == '{cod_stop_from}' | cod_stop == '{cod_stop_to}'\".format(cod_stop_from=cod_stop_from, cod_stop_to=cod_stop_to))\n",
    "\n",
    "    selected_arrival_times_grouped = selected_arrival_times.groupby(['cod_line', 'cod_issue', 'eta_date'])\n",
    "\n",
    "    for name, group in selected_arrival_times_grouped:\n",
    "        if (len(group)==2):\n",
    "            arrival_from = group.iloc[0]\n",
    "            arrival_to = group.iloc[1]\n",
    "            if (\n",
    "                arrival_from['cod_stop'] == cod_stop_from and\n",
    "                arrival_to['cod_stop'] == cod_stop_to\n",
    "                ):\n",
    "                departure_time = arrival_from['arrival_time']\n",
    "                arrival_time = arrival_to['arrival_time']\n",
    "                trip_time = arrival_time - departure_time\n",
    "                if (arrival_from['cod_line'] == arrival_to['cod_line']):\n",
    "                    cod_line = arrival_from['cod_line']\n",
    "                else:\n",
    "                    print(\"from: \" + str(arrival_from['cod_line']) + \" to: \" + arrival_to['cod_line'])\n",
    "                    continue\n",
    "\n",
    "                trip_times_array.append([\n",
    "                                         name[0],\n",
    "                                         departure_time,\n",
    "                                         arrival_time,\n",
    "                                         trip_time,\n",
    "                                         cod_line\n",
    "                                         ])\n",
    "        elif (len(group)>2):\n",
    "            print(\"Error: repeated cod_issue\")\n",
    "            print(group)\n",
    "\n",
    "    selected_arrival_times['cod_issue'].value_counts()\n",
    "\n",
    "    trip_times = pd.DataFrame(trip_times_array, columns=[\n",
    "                                                         'cod_issue',\n",
    "                                                         'departure_time',\n",
    "                                                         'arrival_time',\n",
    "                                                         'trip_time',\n",
    "                                                         'cod_line'\n",
    "                                                         ])\n",
    "    trip_times = trip_times[trip_times['trip_time'] < pd.Timedelta(2, unit='h')]\n",
    "    return trip_times"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-03-16T14:18:55.843358Z",
     "iopub.status.busy": "2020-03-16T14:18:55.843125Z",
     "iopub.status.idle": "2020-03-16T14:18:57.758257Z",
     "shell.execute_reply": "2020-03-16T14:18:57.757800Z",
     "shell.execute_reply.started": "2020-03-16T14:18:55.843326Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Error: repeated cod_issue\n",
      "       cod_issue cod_stop   cod_line  eta_date              arrival_time\n",
      "674655   5307639   8_1336  8__656___         7 2020-03-07 10:15:03+01:00\n",
      "674915   5307639  8_06277  8__656___         7 2020-03-07 10:26:59+01:00\n",
      "675222   5307639  8_06277  8__656___         7 2020-03-07 10:39:00+01:00\n",
      "Error: repeated cod_issue\n",
      "       cod_issue cod_stop   cod_line  eta_date              arrival_time\n",
      "450801   5308363   8_1336  8__656___        29 2020-02-29 17:31:18+01:00\n",
      "451029   5308363  8_06277  8__656___        29 2020-02-29 17:42:14+01:00\n",
      "451263   5308363  8_06277  8__656___        29 2020-02-29 17:51:00+01:00\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "8__656___     1223\n",
       "8__658___      602\n",
       "8_N_901___      41\n",
       "Name: cod_line, dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "get_trip_times()['cod_line'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-03-16T14:18:57.759174Z",
     "iopub.status.busy": "2020-03-16T14:18:57.759056Z",
     "iopub.status.idle": "2020-03-16T14:18:57.809976Z",
     "shell.execute_reply": "2020-03-16T14:18:57.809588Z",
     "shell.execute_reply.started": "2020-03-16T14:18:57.759159Z"
    }
   },
   "outputs": [],
   "source": [
    "file_path = 'm8_Estaciones.json'\n",
    "\n",
    "if not os.path.exists(file_path):\n",
    "  url = 'https://opendata.arcgis.com/datasets/19884a02ac044270b91fa478d80f7858_0.csv?outSR=%7B%22latestWkid%22%3A25830%2C%22wkid%22%3A25830%7D'\n",
    "  r = requests.get(url)\n",
    "  with open(file_path, 'w') as f:\n",
    "    f.write(r.content.decode(\"utf-8\"))\n",
    "\n",
    "with open(file_path, 'r') as f:\n",
    "  est = pd.read_csv(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-03-16T14:18:57.810640Z",
     "iopub.status.busy": "2020-03-16T14:18:57.810534Z",
     "iopub.status.idle": "2020-03-16T14:18:59.234466Z",
     "shell.execute_reply": "2020-03-16T14:18:59.234015Z",
     "shell.execute_reply.started": "2020-03-16T14:18:57.810626Z"
    }
   },
   "outputs": [],
   "source": [
    "file_path = 'm8_Estaciones.geojson'\n",
    "\n",
    "if not os.path.exists(file_path):\n",
    "  url = 'https://opendata.arcgis.com/datasets/19884a02ac044270b91fa478d80f7858_0.geojson'\n",
    "  r = requests.get(url)\n",
    "  with open(file_path, 'w') as f:\n",
    "    f.write(r.content.decode(\"utf-8\"))\n",
    "\n",
    "est_geojson = gpd.read_file(file_path)\n",
    "selected_est_geojson = est_geojson[est_geojson['IDESTACION']\n",
    "                                       .isin(arrival_times['cod_stop'].unique())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-03-16T14:18:59.235189Z",
     "iopub.status.busy": "2020-03-16T14:18:59.235081Z",
     "iopub.status.idle": "2020-03-16T14:18:59.261602Z",
     "shell.execute_reply": "2020-03-16T14:18:59.260920Z",
     "shell.execute_reply.started": "2020-03-16T14:18:59.235175Z"
    }
   },
   "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>OBJECTID</th>\n",
       "      <th>IDESTACION</th>\n",
       "      <th>FECHAACTUAL</th>\n",
       "      <th>MODO</th>\n",
       "      <th>CODIGOESTACION</th>\n",
       "      <th>DENOMINACION</th>\n",
       "      <th>OBSERVACIONES</th>\n",
       "      <th>SITUACION</th>\n",
       "      <th>CODIGOCTMESTACIONREDMETRO</th>\n",
       "      <th>CODIGOEMPRESA</th>\n",
       "      <th>...</th>\n",
       "      <th>FECHAFIN</th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>GRADOACCESIBILIDAD</th>\n",
       "      <th>SITUACIONCALLE</th>\n",
       "      <th>DENOMINACION_SAE</th>\n",
       "      <th>INTERURBANOS_CODIGOEMT_CRTM</th>\n",
       "      <th>INTERURBANOS_CODIGOEMT_EMPRESA</th>\n",
       "      <th>LINEAS</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>8046</td>\n",
       "      <td>8_3840</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>3840</td>\n",
       "      <td>AV.OSA MAYOR-PLEYADES</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>433596</td>\n",
       "      <td>4479218</td>\n",
       "      <td>N</td>\n",
       "      <td>None</td>\n",
       "      <td>AV.OSA MAYOR-PLEYADES</td>\n",
       "      <td>None</td>\n",
       "      <td>3840</td>\n",
       "      <td>656, N906</td>\n",
       "      <td>POINT (-3.78449 40.45910)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>8051</td>\n",
       "      <td>8_4789</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>4789</td>\n",
       "      <td>GOLONDRINA-VELETA</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>433677</td>\n",
       "      <td>4478845</td>\n",
       "      <td>N</td>\n",
       "      <td>None</td>\n",
       "      <td>GOLONDRINA-VELETA</td>\n",
       "      <td>None</td>\n",
       "      <td>4789</td>\n",
       "      <td>657</td>\n",
       "      <td>POINT (-3.78349 40.45575)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>8052</td>\n",
       "      <td>8_4790</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>4790</td>\n",
       "      <td>GOLONDRINA-GTA.CIRILO MARTIN MARTIN</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>433833</td>\n",
       "      <td>4478845</td>\n",
       "      <td>N</td>\n",
       "      <td>None</td>\n",
       "      <td>GOLONDRINA-GTA.CIRILO MARTIN MARTIN</td>\n",
       "      <td>None</td>\n",
       "      <td>4790</td>\n",
       "      <td>657</td>\n",
       "      <td>POINT (-3.78165 40.45576)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>8155</td>\n",
       "      <td>8_20349</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>20349</td>\n",
       "      <td>BADAJOZ-PALENCIA</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>429123</td>\n",
       "      <td>4474582</td>\n",
       "      <td>N</td>\n",
       "      <td>None</td>\n",
       "      <td>BADAJOZ-PALENCIA</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>656A</td>\n",
       "      <td>POINT (-3.83672 40.41697)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>8156</td>\n",
       "      <td>8_50018</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>50018</td>\n",
       "      <td>FERNANDO LAZARO CARRETER-CARLOS GARDIEL</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>432722</td>\n",
       "      <td>4479330</td>\n",
       "      <td>N</td>\n",
       "      <td>None</td>\n",
       "      <td>FERNANDO LAZARO CARRETER-CARLOS GARDIEL</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>656A</td>\n",
       "      <td>POINT (-3.79479 40.46005)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8023</th>\n",
       "      <td>7531</td>\n",
       "      <td>8_15646</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>15646</td>\n",
       "      <td>AV.CASABLANCA-DIEGO DE VELÁZQUEZ</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>433098</td>\n",
       "      <td>4472700</td>\n",
       "      <td>T</td>\n",
       "      <td>None</td>\n",
       "      <td>AV.CASABLANCA-DIEGO DE VELÁZQUEZ</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>658, N902</td>\n",
       "      <td>POINT (-3.78967 40.40035)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8027</th>\n",
       "      <td>7535</td>\n",
       "      <td>8_15760</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>15760</td>\n",
       "      <td>VALLADOLID-OVIEDO</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>429495</td>\n",
       "      <td>4474344</td>\n",
       "      <td>T</td>\n",
       "      <td>None</td>\n",
       "      <td>VALLADOLID-OVIEDO</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>656A</td>\n",
       "      <td>POINT (-3.83231 40.41486)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8043</th>\n",
       "      <td>7551</td>\n",
       "      <td>8_10585</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>10585</td>\n",
       "      <td>ANA TERESA-PLEYADES</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>433583</td>\n",
       "      <td>4479460</td>\n",
       "      <td>T</td>\n",
       "      <td>None</td>\n",
       "      <td>ANA TERESA-PLEYADES</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>656, 657, 656A, N901</td>\n",
       "      <td>POINT (-3.78467 40.46128)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8107</th>\n",
       "      <td>7615</td>\n",
       "      <td>8_10502</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>10502</td>\n",
       "      <td>CºHUERTAS-COLEGIO</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>430782</td>\n",
       "      <td>4476995</td>\n",
       "      <td>T</td>\n",
       "      <td>None</td>\n",
       "      <td>CºHUERTAS-COLEGIO</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>562, 564, 656A</td>\n",
       "      <td>POINT (-3.81743 40.43885)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8224</th>\n",
       "      <td>7732</td>\n",
       "      <td>8_10866</td>\n",
       "      <td>20190912</td>\n",
       "      <td>8</td>\n",
       "      <td>10866</td>\n",
       "      <td>AV.POBLADOS-ALUCHE</td>\n",
       "      <td>None</td>\n",
       "      <td>S</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>435404</td>\n",
       "      <td>4471081</td>\n",
       "      <td>T</td>\n",
       "      <td>None</td>\n",
       "      <td>AV.POBLADOS-ALUCHE</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>561, 562, 563, 564, 561A, 561B</td>\n",
       "      <td>POINT (-3.76234 40.38594)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>284 rows × 54 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      OBJECTID IDESTACION FECHAACTUAL  MODO CODIGOESTACION  \\\n",
       "45        8046     8_3840    20190912     8           3840   \n",
       "50        8051     8_4789    20190912     8           4789   \n",
       "51        8052     8_4790    20190912     8           4790   \n",
       "154       8155    8_20349    20190912     8          20349   \n",
       "155       8156    8_50018    20190912     8          50018   \n",
       "...        ...        ...         ...   ...            ...   \n",
       "8023      7531    8_15646    20190912     8          15646   \n",
       "8027      7535    8_15760    20190912     8          15760   \n",
       "8043      7551    8_10585    20190912     8          10585   \n",
       "8107      7615    8_10502    20190912     8          10502   \n",
       "8224      7732    8_10866    20190912     8          10866   \n",
       "\n",
       "                                 DENOMINACION OBSERVACIONES SITUACION  \\\n",
       "45                      AV.OSA MAYOR-PLEYADES          None         S   \n",
       "50                          GOLONDRINA-VELETA          None         S   \n",
       "51        GOLONDRINA-GTA.CIRILO MARTIN MARTIN          None         S   \n",
       "154                          BADAJOZ-PALENCIA          None         S   \n",
       "155   FERNANDO LAZARO CARRETER-CARLOS GARDIEL          None         S   \n",
       "...                                       ...           ...       ...   \n",
       "8023         AV.CASABLANCA-DIEGO DE VELÁZQUEZ          None         S   \n",
       "8027                        VALLADOLID-OVIEDO          None         S   \n",
       "8043                      ANA TERESA-PLEYADES          None         S   \n",
       "8107                        CºHUERTAS-COLEGIO          None         S   \n",
       "8224                       AV.POBLADOS-ALUCHE          None         S   \n",
       "\n",
       "     CODIGOCTMESTACIONREDMETRO CODIGOEMPRESA  ... FECHAFIN       X        Y  \\\n",
       "45                        None          None  ...     None  433596  4479218   \n",
       "50                        None          None  ...     None  433677  4478845   \n",
       "51                        None          None  ...     None  433833  4478845   \n",
       "154                       None          None  ...     None  429123  4474582   \n",
       "155                       None          None  ...     None  432722  4479330   \n",
       "...                        ...           ...  ...      ...     ...      ...   \n",
       "8023                      None          None  ...     None  433098  4472700   \n",
       "8027                      None          None  ...     None  429495  4474344   \n",
       "8043                      None          None  ...     None  433583  4479460   \n",
       "8107                      None          None  ...     None  430782  4476995   \n",
       "8224                      None          None  ...     None  435404  4471081   \n",
       "\n",
       "     GRADOACCESIBILIDAD SITUACIONCALLE  \\\n",
       "45                    N           None   \n",
       "50                    N           None   \n",
       "51                    N           None   \n",
       "154                   N           None   \n",
       "155                   N           None   \n",
       "...                 ...            ...   \n",
       "8023                  T           None   \n",
       "8027                  T           None   \n",
       "8043                  T           None   \n",
       "8107                  T           None   \n",
       "8224                  T           None   \n",
       "\n",
       "                             DENOMINACION_SAE INTERURBANOS_CODIGOEMT_CRTM  \\\n",
       "45                      AV.OSA MAYOR-PLEYADES                        None   \n",
       "50                          GOLONDRINA-VELETA                        None   \n",
       "51        GOLONDRINA-GTA.CIRILO MARTIN MARTIN                        None   \n",
       "154                          BADAJOZ-PALENCIA                        None   \n",
       "155   FERNANDO LAZARO CARRETER-CARLOS GARDIEL                        None   \n",
       "...                                       ...                         ...   \n",
       "8023         AV.CASABLANCA-DIEGO DE VELÁZQUEZ                        None   \n",
       "8027                        VALLADOLID-OVIEDO                        None   \n",
       "8043                      ANA TERESA-PLEYADES                        None   \n",
       "8107                        CºHUERTAS-COLEGIO                        None   \n",
       "8224                       AV.POBLADOS-ALUCHE                        None   \n",
       "\n",
       "     INTERURBANOS_CODIGOEMT_EMPRESA                          LINEAS  \\\n",
       "45                             3840                       656, N906   \n",
       "50                             4789                             657   \n",
       "51                             4790                             657   \n",
       "154                            None                            656A   \n",
       "155                            None                            656A   \n",
       "...                             ...                             ...   \n",
       "8023                           None                       658, N902   \n",
       "8027                           None                            656A   \n",
       "8043                           None            656, 657, 656A, N901   \n",
       "8107                           None                  562, 564, 656A   \n",
       "8224                           None  561, 562, 563, 564, 561A, 561B   \n",
       "\n",
       "                       geometry  \n",
       "45    POINT (-3.78449 40.45910)  \n",
       "50    POINT (-3.78349 40.45575)  \n",
       "51    POINT (-3.78165 40.45576)  \n",
       "154   POINT (-3.83672 40.41697)  \n",
       "155   POINT (-3.79479 40.46005)  \n",
       "...                         ...  \n",
       "8023  POINT (-3.78967 40.40035)  \n",
       "8027  POINT (-3.83231 40.41486)  \n",
       "8043  POINT (-3.78467 40.46128)  \n",
       "8107  POINT (-3.81743 40.43885)  \n",
       "8224  POINT (-3.76234 40.38594)  \n",
       "\n",
       "[284 rows x 54 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "selected_est_geojson"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-03-16T14:18:59.262859Z",
     "iopub.status.busy": "2020-03-16T14:18:59.262639Z",
     "iopub.status.idle": "2020-03-16T14:18:59.266687Z",
     "shell.execute_reply": "2020-03-16T14:18:59.266339Z",
     "shell.execute_reply.started": "2020-03-16T14:18:59.262829Z"
    }
   },
   "outputs": [],
   "source": [
    "def get_stop_name(cod_stop):\n",
    "    stop_row = est[est['IDESTACION'] == cod_stop].iloc[0]\n",
    "    return str(stop_row['DENOMINACION'] + \" (\" + str(stop_row['CODIGOESTACION']) + \")\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-03-16T14:18:59.267790Z",
     "iopub.status.busy": "2020-03-16T14:18:59.267684Z",
     "iopub.status.idle": "2020-03-16T14:18:59.823017Z",
     "shell.execute_reply": "2020-03-16T14:18:59.822418Z",
     "shell.execute_reply.started": "2020-03-16T14:18:59.267776Z"
    }
   },
   "outputs": [],
   "source": [
    "viewer = jupyterlab_dash.AppViewer()\n",
    "app = dash.Dash(__name__)\n",
    "\n",
    "cod_stops = sorted(arrival_times['cod_stop'].unique())\n",
    "\n",
    "app.layout = html.Div(\n",
    "    html.Div([\n",
    "        dcc.Dropdown(\n",
    "            id='from-dropdown',\n",
    "            options=[{'label': get_stop_name(cod_stop), 'value': cod_stop} for cod_stop in cod_stops],\n",
    "            value='8_1336'\n",
    "        ),\n",
    "        dcc.Dropdown(\n",
    "            id='to-dropdown',\n",
    "            options=[{'label': get_stop_name(cod_stop), 'value': cod_stop} for cod_stop in cod_stops],\n",
    "            value='8_06277'\n",
    "        ),\n",
    "        dcc.Graph(id=\"boxplot\"),\n",
    "        dcc.Graph(id=\"map\")\n",
    "    ])\n",
    ")\n",
    "\n",
    "@app.callback(Output(\"boxplot\", \"figure\"), [Input('from-dropdown', 'value'),\n",
    "                                          Input('to-dropdown', 'value')])\n",
    "def make_figure(cod_stop_from, cod_stop_to):\n",
    "    trip_times = get_trip_times(cod_stop_from, cod_stop_to)\n",
    "    if (trip_times.size <= 0):\n",
    "        return 0\n",
    "    else:\n",
    "        return px.box(x=trip_times['departure_time'].dt.hour,\n",
    "                                        y=trip_times['trip_time'].astype('timedelta64[s]')/60,\n",
    "                                        color=trip_times['cod_line'],\n",
    "                                        points=\"all\",\n",
    "                                        hover_data=[\n",
    "                                            trip_times['departure_time'].dt.day_name(),\n",
    "                                            trip_times['departure_time'].dt.minute,\n",
    "                                            trip_times['departure_time'].dt.day\n",
    "                                            ],\n",
    "                                        title=\"Trip time through the day\"\n",
    "                                       )\n",
    "    \n",
    "    \n",
    "@app.callback(Output(\"map\", \"figure\"), [Input('from-dropdown', 'value'),\n",
    "                                          Input('to-dropdown', 'value')])\n",
    "def make_figure(cod_stop_from, cod_stop_to):\n",
    "    us_cities = pd.read_csv(\"https://raw.githubusercontent.com/plotly/datasets/master/us-cities-top-1k.csv\")\n",
    "\n",
    "    fig = px.scatter_mapbox(\n",
    "                            selected_est_geojson,\n",
    "                            lat=selected_est_geojson['geometry'].y,\n",
    "                            lon=selected_est_geojson['geometry'].x,\n",
    "                            hover_data=['IDESTACION'],\n",
    "                            height=300\n",
    "                            )\n",
    "    selected_est_geojson_from = selected_est_geojson[\n",
    "                                selected_est_geojson['IDESTACION'] == cod_stop_from].iloc[0]\n",
    "    selected_est_geojson_to = selected_est_geojson[\n",
    "                                selected_est_geojson['IDESTACION'] == cod_stop_to].iloc[0]\n",
    "\n",
    "    \n",
    "    fig.add_trace(\n",
    "        go.Scattermapbox(\n",
    "            mode='markers',\n",
    "            lat=[selected_est_geojson_from['geometry'].y],\n",
    "            lon=[selected_est_geojson_from['geometry'].x],\n",
    "            marker=go.scattermapbox.Marker(\n",
    "                size=17,\n",
    "                color='rgb(255, 0, 0)',\n",
    "                opacity=0.7\n",
    "            ),\n",
    "            hovertext = \"From: \" + cod_stop_from,\n",
    "            hoverinfo = 'text',\n",
    "            showlegend=False\n",
    "        )\n",
    "    )\n",
    "    fig.add_trace(\n",
    "        go.Scattermapbox(\n",
    "            mode='markers',\n",
    "            lat=[selected_est_geojson_to['geometry'].y],\n",
    "            lon=[selected_est_geojson_to['geometry'].x],\n",
    "            marker=go.scattermapbox.Marker(\n",
    "                size=17,\n",
    "                color='rgb(255, 0, 0)',\n",
    "                opacity=0.7\n",
    "            ),\n",
    "            hovertext = \"To: \" + cod_stop_to,\n",
    "            hoverinfo = 'text',\n",
    "            showlegend=False\n",
    "        )\n",
    "    )\n",
    "    fig\n",
    "    fig.update_layout(mapbox_style=\"open-street-map\")\n",
    "    fig.update_layout(margin={\"r\":0,\"t\":0,\"l\":0,\"b\":0})\n",
    "    return fig\n",
    "\n",
    "\n",
    "viewer.show(app)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## TODO\n",
    "\n",
    "* Label axis\n",
    "* Plot map with shape and stops"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2020-03-16T14:30:27.869993Z",
     "iopub.status.busy": "2020-03-16T14:30:27.869710Z",
     "iopub.status.idle": "2020-03-16T14:30:27.919413Z",
     "shell.execute_reply": "2020-03-16T14:30:27.919106Z",
     "shell.execute_reply.started": "2020-03-16T14:30:27.869960Z"
    }
   },
   "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>cod_issue</th>\n",
       "      <th>cod_stop</th>\n",
       "      <th>cod_line</th>\n",
       "      <th>eta_date</th>\n",
       "      <th>arrival_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>648893</th>\n",
       "      <td>5306605</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 14:48:54+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649117</th>\n",
       "      <td>5306618</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 14:54:45+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649528</th>\n",
       "      <td>5306624</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 15:03:32+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650429</th>\n",
       "      <td>5306629</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 15:25:13+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650635</th>\n",
       "      <td>5306642</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 15:30:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651061</th>\n",
       "      <td>5306733</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 15:40:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651501</th>\n",
       "      <td>5306799</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 15:50:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651661</th>\n",
       "      <td>5306975</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 15:54:30+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652090</th>\n",
       "      <td>5307077</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 16:03:51+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652663</th>\n",
       "      <td>5307195</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 16:17:59+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652892</th>\n",
       "      <td>5306779</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 16:26:37+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653423</th>\n",
       "      <td>5306869</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 16:39:36+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654083</th>\n",
       "      <td>5307024</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 16:54:31+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654308</th>\n",
       "      <td>5307357</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 17:00:16+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654732</th>\n",
       "      <td>5306735</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 17:10:37+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654961</th>\n",
       "      <td>5306801</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 17:16:35+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655649</th>\n",
       "      <td>5306977</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 17:34:02+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655908</th>\n",
       "      <td>5307079</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 17:40:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>656119</th>\n",
       "      <td>5307443</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 17:45:30+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>656781</th>\n",
       "      <td>5306781</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 18:00:08+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657084</th>\n",
       "      <td>5306871</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 18:06:58+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657726</th>\n",
       "      <td>5307026</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 18:23:05+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657943</th>\n",
       "      <td>5307359</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 18:27:35+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658474</th>\n",
       "      <td>5306737</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 18:40:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658895</th>\n",
       "      <td>5307536</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 18:50:47+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659218</th>\n",
       "      <td>5306979</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 18:58:46+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659759</th>\n",
       "      <td>5307081</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 19:12:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660184</th>\n",
       "      <td>5307445</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 19:23:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660516</th>\n",
       "      <td>5306873</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 19:31:48+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661177</th>\n",
       "      <td>5307028</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 19:48:44+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661266</th>\n",
       "      <td>5307361</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 19:50:53+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661898</th>\n",
       "      <td>5306739</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 20:07:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662328</th>\n",
       "      <td>5307558</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 20:18:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662746</th>\n",
       "      <td>5306981</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 20:29:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663149</th>\n",
       "      <td>5307083</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 20:40:08+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663376</th>\n",
       "      <td>5307447</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 20:46:39+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663845</th>\n",
       "      <td>5306875</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 20:58:27+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664427</th>\n",
       "      <td>5307030</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 21:13:01+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664687</th>\n",
       "      <td>5307363</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 21:20:28+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665241</th>\n",
       "      <td>5306741</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 21:36:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665338</th>\n",
       "      <td>5307560</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 21:39:47+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666184</th>\n",
       "      <td>5307085</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 22:02:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666602</th>\n",
       "      <td>5307449</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 22:15:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667072</th>\n",
       "      <td>5306877</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 22:28:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667313</th>\n",
       "      <td>5307032</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 22:35:19+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667685</th>\n",
       "      <td>5307365</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 22:47:53+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668152</th>\n",
       "      <td>5307581</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 23:03:30+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668691</th>\n",
       "      <td>5307087</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 23:28:00+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668716</th>\n",
       "      <td>5307451</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 23:29:11+01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668979</th>\n",
       "      <td>5307592</td>\n",
       "      <td>8_23</td>\n",
       "      <td>8__656___</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06 23:46:08+01:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       cod_issue cod_stop   cod_line  eta_date              arrival_time\n",
       "648893   5306605     8_23  8__656___         6 2020-03-06 14:48:54+01:00\n",
       "649117   5306618     8_23  8__656___         6 2020-03-06 14:54:45+01:00\n",
       "649528   5306624     8_23  8__656___         6 2020-03-06 15:03:32+01:00\n",
       "650429   5306629     8_23  8__656___         6 2020-03-06 15:25:13+01:00\n",
       "650635   5306642     8_23  8__656___         6 2020-03-06 15:30:00+01:00\n",
       "651061   5306733     8_23  8__656___         6 2020-03-06 15:40:00+01:00\n",
       "651501   5306799     8_23  8__656___         6 2020-03-06 15:50:00+01:00\n",
       "651661   5306975     8_23  8__656___         6 2020-03-06 15:54:30+01:00\n",
       "652090   5307077     8_23  8__656___         6 2020-03-06 16:03:51+01:00\n",
       "652663   5307195     8_23  8__656___         6 2020-03-06 16:17:59+01:00\n",
       "652892   5306779     8_23  8__656___         6 2020-03-06 16:26:37+01:00\n",
       "653423   5306869     8_23  8__656___         6 2020-03-06 16:39:36+01:00\n",
       "654083   5307024     8_23  8__656___         6 2020-03-06 16:54:31+01:00\n",
       "654308   5307357     8_23  8__656___         6 2020-03-06 17:00:16+01:00\n",
       "654732   5306735     8_23  8__656___         6 2020-03-06 17:10:37+01:00\n",
       "654961   5306801     8_23  8__656___         6 2020-03-06 17:16:35+01:00\n",
       "655649   5306977     8_23  8__656___         6 2020-03-06 17:34:02+01:00\n",
       "655908   5307079     8_23  8__656___         6 2020-03-06 17:40:00+01:00\n",
       "656119   5307443     8_23  8__656___         6 2020-03-06 17:45:30+01:00\n",
       "656781   5306781     8_23  8__656___         6 2020-03-06 18:00:08+01:00\n",
       "657084   5306871     8_23  8__656___         6 2020-03-06 18:06:58+01:00\n",
       "657726   5307026     8_23  8__656___         6 2020-03-06 18:23:05+01:00\n",
       "657943   5307359     8_23  8__656___         6 2020-03-06 18:27:35+01:00\n",
       "658474   5306737     8_23  8__656___         6 2020-03-06 18:40:00+01:00\n",
       "658895   5307536     8_23  8__656___         6 2020-03-06 18:50:47+01:00\n",
       "659218   5306979     8_23  8__656___         6 2020-03-06 18:58:46+01:00\n",
       "659759   5307081     8_23  8__656___         6 2020-03-06 19:12:00+01:00\n",
       "660184   5307445     8_23  8__656___         6 2020-03-06 19:23:00+01:00\n",
       "660516   5306873     8_23  8__656___         6 2020-03-06 19:31:48+01:00\n",
       "661177   5307028     8_23  8__656___         6 2020-03-06 19:48:44+01:00\n",
       "661266   5307361     8_23  8__656___         6 2020-03-06 19:50:53+01:00\n",
       "661898   5306739     8_23  8__656___         6 2020-03-06 20:07:00+01:00\n",
       "662328   5307558     8_23  8__656___         6 2020-03-06 20:18:00+01:00\n",
       "662746   5306981     8_23  8__656___         6 2020-03-06 20:29:00+01:00\n",
       "663149   5307083     8_23  8__656___         6 2020-03-06 20:40:08+01:00\n",
       "663376   5307447     8_23  8__656___         6 2020-03-06 20:46:39+01:00\n",
       "663845   5306875     8_23  8__656___         6 2020-03-06 20:58:27+01:00\n",
       "664427   5307030     8_23  8__656___         6 2020-03-06 21:13:01+01:00\n",
       "664687   5307363     8_23  8__656___         6 2020-03-06 21:20:28+01:00\n",
       "665241   5306741     8_23  8__656___         6 2020-03-06 21:36:00+01:00\n",
       "665338   5307560     8_23  8__656___         6 2020-03-06 21:39:47+01:00\n",
       "666184   5307085     8_23  8__656___         6 2020-03-06 22:02:00+01:00\n",
       "666602   5307449     8_23  8__656___         6 2020-03-06 22:15:00+01:00\n",
       "667072   5306877     8_23  8__656___         6 2020-03-06 22:28:00+01:00\n",
       "667313   5307032     8_23  8__656___         6 2020-03-06 22:35:19+01:00\n",
       "667685   5307365     8_23  8__656___         6 2020-03-06 22:47:53+01:00\n",
       "668152   5307581     8_23  8__656___         6 2020-03-06 23:03:30+01:00\n",
       "668691   5307087     8_23  8__656___         6 2020-03-06 23:28:00+01:00\n",
       "668716   5307451     8_23  8__656___         6 2020-03-06 23:29:11+01:00\n",
       "668979   5307592     8_23  8__656___         6 2020-03-06 23:46:08+01:00"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "arrival_times.query(\"cod_line == '8__656___' & cod_stop == '8_23' & eta_date == 6\").tail(50)"
   ]
  },
  {
   "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.7.6"
  },
  "record_timing": true,
  "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
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}