BikeData_LocationAnalysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 219,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "%matplotlib inline\n",
    "import numpy as np\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.neighbors import KNeighborsClassifier\n",
    "from sklearn.metrics import accuracy_score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 220,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#import sys\n",
    "#!{sys.executable} -m pip install gmplot\n",
    "\n",
    "#import gmplot\n",
    "\n",
    "# Reference for using/plotting to google maps:\n",
    "#https://eatsleepdata.com/how-to-generate-a-geographical-heatmap-with-python\n",
    "\n",
    "# Need a google maps API Key - see: https://developers.google.com/maps/documentation/embed/get-api-key\n",
    "# See forum here: https://github.com/vgm64/gmplot/issues/79\n",
    "\n",
    "#key = 'AIzaSyAgZuY9Jj4y8nwtxKUa2tfOo4VlekigpmQ'\n",
    "#gmap.apikey = key\n",
    "\n",
    "\n",
    "# COME BACK TO THIS ONCE THE API ISSUE IS RESOLVED OR A WORKAROUND IS FOUND"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 221,
   "metadata": {},
   "outputs": [],
   "source": [
    "bikeData = pd.read_csv('data_join1.csv',header = 0, sep = ',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 222,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>trip_duration_seconds</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>trip_start_time</th>\n",
       "      <th>trip_stop_time</th>\n",
       "      <th>user_type</th>\n",
       "      <th>from_station_id_corr</th>\n",
       "      <th>...</th>\n",
       "      <th>from_lat</th>\n",
       "      <th>from_lon</th>\n",
       "      <th>to_station_id_corr</th>\n",
       "      <th>to_station_name_corr</th>\n",
       "      <th>to_lat</th>\n",
       "      <th>to_lon</th>\n",
       "      <th>trip_start_date</th>\n",
       "      <th>Temp (°C)</th>\n",
       "      <th>work_day</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7051.0</td>\n",
       "      <td>Wellesley St E / Yonge St Green P</td>\n",
       "      <td>7089.0</td>\n",
       "      <td>Church St  / Wood St</td>\n",
       "      <td>223</td>\n",
       "      <td>712382</td>\n",
       "      <td>2017-01-01 00:00:00</td>\n",
       "      <td>2017-01-01 00:03:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7051.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.665060</td>\n",
       "      <td>-79.383570</td>\n",
       "      <td>7089.0</td>\n",
       "      <td>Church St  / Wood St</td>\n",
       "      <td>43.662712</td>\n",
       "      <td>-79.379903</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7143.0</td>\n",
       "      <td>Kendal Ave / Bernard Ave</td>\n",
       "      <td>7154.0</td>\n",
       "      <td>Bathurst Subway Station</td>\n",
       "      <td>279</td>\n",
       "      <td>712383</td>\n",
       "      <td>2017-01-01 00:00:00</td>\n",
       "      <td>2017-01-01 00:05:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7143.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.671513</td>\n",
       "      <td>-79.408317</td>\n",
       "      <td>7154.0</td>\n",
       "      <td>Bathurst Subway Station</td>\n",
       "      <td>43.666667</td>\n",
       "      <td>-79.411667</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7113.0</td>\n",
       "      <td>Parliament St / Aberdeen Ave</td>\n",
       "      <td>7199.0</td>\n",
       "      <td>College St W / Markham St</td>\n",
       "      <td>1394</td>\n",
       "      <td>712384</td>\n",
       "      <td>2017-01-01 00:05:00</td>\n",
       "      <td>2017-01-01 00:29:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7113.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.665278</td>\n",
       "      <td>-79.368333</td>\n",
       "      <td>7199.0</td>\n",
       "      <td>College St / Markham St</td>\n",
       "      <td>43.656389</td>\n",
       "      <td>-79.409167</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7077.0</td>\n",
       "      <td>College Park South</td>\n",
       "      <td>7010.0</td>\n",
       "      <td>King St W / Spadina Ave</td>\n",
       "      <td>826</td>\n",
       "      <td>712385</td>\n",
       "      <td>2017-01-01 00:07:00</td>\n",
       "      <td>2017-01-01 00:21:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7077.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.659777</td>\n",
       "      <td>-79.382767</td>\n",
       "      <td>7010.0</td>\n",
       "      <td>King St W / Spadina Ave</td>\n",
       "      <td>43.645323</td>\n",
       "      <td>-79.395003</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7079.0</td>\n",
       "      <td>McGill St / Church St</td>\n",
       "      <td>7047.0</td>\n",
       "      <td>University Ave / Gerrard St W</td>\n",
       "      <td>279</td>\n",
       "      <td>712386</td>\n",
       "      <td>2017-01-01 00:08:00</td>\n",
       "      <td>2017-01-01 00:12:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7079.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.660694</td>\n",
       "      <td>-79.379052</td>\n",
       "      <td>7047.0</td>\n",
       "      <td>University Ave / Gerrard St W</td>\n",
       "      <td>43.657763</td>\n",
       "      <td>-79.389165</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7021.0</td>\n",
       "      <td>Bay St / Albert St</td>\n",
       "      <td>7046.0</td>\n",
       "      <td>Niagara St / Richmond St W</td>\n",
       "      <td>571</td>\n",
       "      <td>712387</td>\n",
       "      <td>2017-01-01 00:12:00</td>\n",
       "      <td>2017-01-01 00:22:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7021.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.653264</td>\n",
       "      <td>-79.382458</td>\n",
       "      <td>7046.0</td>\n",
       "      <td>Niagara St / Richmond St W</td>\n",
       "      <td>43.645340</td>\n",
       "      <td>-79.409597</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7161.0</td>\n",
       "      <td>Beverly St / College St W</td>\n",
       "      <td>7176.0</td>\n",
       "      <td>Bathurst St / Fort York Blvd</td>\n",
       "      <td>1084</td>\n",
       "      <td>712388</td>\n",
       "      <td>2017-01-01 00:15:00</td>\n",
       "      <td>2017-01-01 00:33:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7161.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.657500</td>\n",
       "      <td>-79.395278</td>\n",
       "      <td>7176.0</td>\n",
       "      <td>Bathurst St / Fort York Blvd</td>\n",
       "      <td>43.639179</td>\n",
       "      <td>-79.399595</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7195.0</td>\n",
       "      <td>Ulster St / Bathurst St</td>\n",
       "      <td>7037.0</td>\n",
       "      <td>Bathurst St / Dundas St W</td>\n",
       "      <td>307</td>\n",
       "      <td>712389</td>\n",
       "      <td>2017-01-01 00:15:00</td>\n",
       "      <td>2017-01-01 00:21:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7195.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.660000</td>\n",
       "      <td>-79.408889</td>\n",
       "      <td>7037.0</td>\n",
       "      <td>Bathurst St / Dundas St W</td>\n",
       "      <td>43.652300</td>\n",
       "      <td>-79.405800</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7017.0</td>\n",
       "      <td>Widmer St / Adelaide St</td>\n",
       "      <td>7101.0</td>\n",
       "      <td>Lower Sherbourne St / The Esplanade</td>\n",
       "      <td>647</td>\n",
       "      <td>712390</td>\n",
       "      <td>2017-01-01 00:20:00</td>\n",
       "      <td>2017-01-01 00:31:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7017.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.647508</td>\n",
       "      <td>-79.391484</td>\n",
       "      <td>7101.0</td>\n",
       "      <td>Lower Sherbourne St / The Esplanade</td>\n",
       "      <td>43.648655</td>\n",
       "      <td>-79.367061</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7017.0</td>\n",
       "      <td>Widmer St / Adelaide St</td>\n",
       "      <td>7005.0</td>\n",
       "      <td>University Ave / King St W</td>\n",
       "      <td>217</td>\n",
       "      <td>712391</td>\n",
       "      <td>2017-01-01 00:23:00</td>\n",
       "      <td>2017-01-01 00:27:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7017.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.647508</td>\n",
       "      <td>-79.391484</td>\n",
       "      <td>7005.0</td>\n",
       "      <td>King St W / York St</td>\n",
       "      <td>43.648001</td>\n",
       "      <td>-79.383177</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   from_station_id                  from_station_name  to_station_id  \\\n",
       "0           7051.0  Wellesley St E / Yonge St Green P         7089.0   \n",
       "1           7143.0           Kendal Ave / Bernard Ave         7154.0   \n",
       "2           7113.0       Parliament St / Aberdeen Ave         7199.0   \n",
       "3           7077.0                 College Park South         7010.0   \n",
       "4           7079.0              McGill St / Church St         7047.0   \n",
       "5           7021.0                 Bay St / Albert St         7046.0   \n",
       "6           7161.0          Beverly St / College St W         7176.0   \n",
       "7           7195.0            Ulster St / Bathurst St         7037.0   \n",
       "8           7017.0           Widmer St / Adelaide St          7101.0   \n",
       "9           7017.0           Widmer St / Adelaide St          7005.0   \n",
       "\n",
       "                       to_station_name  trip_duration_seconds  trip_id  \\\n",
       "0                 Church St  / Wood St                    223   712382   \n",
       "1              Bathurst Subway Station                    279   712383   \n",
       "2            College St W / Markham St                   1394   712384   \n",
       "3              King St W / Spadina Ave                    826   712385   \n",
       "4        University Ave / Gerrard St W                    279   712386   \n",
       "5           Niagara St / Richmond St W                    571   712387   \n",
       "6         Bathurst St / Fort York Blvd                   1084   712388   \n",
       "7            Bathurst St / Dundas St W                    307   712389   \n",
       "8  Lower Sherbourne St / The Esplanade                    647   712390   \n",
       "9           University Ave / King St W                    217   712391   \n",
       "\n",
       "       trip_start_time       trip_stop_time user_type  from_station_id_corr  \\\n",
       "0  2017-01-01 00:00:00  2017-01-01 00:03:00    Member                7051.0   \n",
       "1  2017-01-01 00:00:00  2017-01-01 00:05:00    Member                7143.0   \n",
       "2  2017-01-01 00:05:00  2017-01-01 00:29:00    Member                7113.0   \n",
       "3  2017-01-01 00:07:00  2017-01-01 00:21:00    Member                7077.0   \n",
       "4  2017-01-01 00:08:00  2017-01-01 00:12:00    Member                7079.0   \n",
       "5  2017-01-01 00:12:00  2017-01-01 00:22:00    Member                7021.0   \n",
       "6  2017-01-01 00:15:00  2017-01-01 00:33:00    Member                7161.0   \n",
       "7  2017-01-01 00:15:00  2017-01-01 00:21:00    Member                7195.0   \n",
       "8  2017-01-01 00:20:00  2017-01-01 00:31:00    Member                7017.0   \n",
       "9  2017-01-01 00:23:00  2017-01-01 00:27:00    Member                7017.0   \n",
       "\n",
       "   ...   from_lat   from_lon  to_station_id_corr  \\\n",
       "0  ...  43.665060 -79.383570              7089.0   \n",
       "1  ...  43.671513 -79.408317              7154.0   \n",
       "2  ...  43.665278 -79.368333              7199.0   \n",
       "3  ...  43.659777 -79.382767              7010.0   \n",
       "4  ...  43.660694 -79.379052              7047.0   \n",
       "5  ...  43.653264 -79.382458              7046.0   \n",
       "6  ...  43.657500 -79.395278              7176.0   \n",
       "7  ...  43.660000 -79.408889              7037.0   \n",
       "8  ...  43.647508 -79.391484              7101.0   \n",
       "9  ...  43.647508 -79.391484              7005.0   \n",
       "\n",
       "                  to_station_name_corr     to_lat     to_lon  trip_start_date  \\\n",
       "0                 Church St  / Wood St  43.662712 -79.379903       2017-01-01   \n",
       "1              Bathurst Subway Station  43.666667 -79.411667       2017-01-01   \n",
       "2              College St / Markham St  43.656389 -79.409167       2017-01-01   \n",
       "3              King St W / Spadina Ave  43.645323 -79.395003       2017-01-01   \n",
       "4        University Ave / Gerrard St W  43.657763 -79.389165       2017-01-01   \n",
       "5           Niagara St / Richmond St W  43.645340 -79.409597       2017-01-01   \n",
       "6         Bathurst St / Fort York Blvd  43.639179 -79.399595       2017-01-01   \n",
       "7            Bathurst St / Dundas St W  43.652300 -79.405800       2017-01-01   \n",
       "8  Lower Sherbourne St / The Esplanade  43.648655 -79.367061       2017-01-01   \n",
       "9                  King St W / York St  43.648001 -79.383177       2017-01-01   \n",
       "\n",
       "  Temp (°C)  work_day month  \n",
       "0    1.2875       Sun     1  \n",
       "1    1.2875       Sun     1  \n",
       "2    1.2875       Sun     1  \n",
       "3    1.2875       Sun     1  \n",
       "4    1.2875       Sun     1  \n",
       "5    1.2875       Sun     1  \n",
       "6    1.2875       Sun     1  \n",
       "7    1.2875       Sun     1  \n",
       "8    1.2875       Sun     1  \n",
       "9    1.2875       Sun     1  \n",
       "\n",
       "[10 rows x 21 columns]"
      ]
     },
     "execution_count": 222,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeData.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 223,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>trip_duration_seconds</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>trip_start_time</th>\n",
       "      <th>trip_stop_time</th>\n",
       "      <th>user_type</th>\n",
       "      <th>from_station_id_corr</th>\n",
       "      <th>...</th>\n",
       "      <th>from_lat</th>\n",
       "      <th>from_lon</th>\n",
       "      <th>to_station_id_corr</th>\n",
       "      <th>to_station_name_corr</th>\n",
       "      <th>to_lat</th>\n",
       "      <th>to_lon</th>\n",
       "      <th>trip_start_date</th>\n",
       "      <th>Temp (°C)</th>\n",
       "      <th>work_day</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>699995</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dockside Dr / Queens Quay E (Sugar Beach)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bremner Blvd / Rees St</td>\n",
       "      <td>731</td>\n",
       "      <td>1382388</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:01:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7068.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.644607</td>\n",
       "      <td>-79.366295</td>\n",
       "      <td>7018.0</td>\n",
       "      <td>Bremner Blvd / Rees St</td>\n",
       "      <td>43.641529</td>\n",
       "      <td>-79.386741</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699996</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Summerhill Station</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Donlands Station</td>\n",
       "      <td>1147</td>\n",
       "      <td>1382389</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:08:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7133.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.681944</td>\n",
       "      <td>-79.390556</td>\n",
       "      <td>7091.0</td>\n",
       "      <td>Donlands Station</td>\n",
       "      <td>43.681126</td>\n",
       "      <td>-79.337779</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699997</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Ted Rogers Way / Bloor St E</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Danforth Ave / Gough Ave</td>\n",
       "      <td>762</td>\n",
       "      <td>1382390</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:02:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7025.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.671293</td>\n",
       "      <td>-79.380471</td>\n",
       "      <td>7093.0</td>\n",
       "      <td>Danforth Ave / Gough Ave</td>\n",
       "      <td>43.678401</td>\n",
       "      <td>-79.346289</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699998</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dundas St W / Yonge St</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25 York St (ACC/Union Station South)</td>\n",
       "      <td>761</td>\n",
       "      <td>1382393</td>\n",
       "      <td>2017-07-18 18:50:00</td>\n",
       "      <td>2017-07-18 19:02:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7038.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.656094</td>\n",
       "      <td>-79.381484</td>\n",
       "      <td>7070.0</td>\n",
       "      <td>25 York St 鈥� Union Station South</td>\n",
       "      <td>43.643667</td>\n",
       "      <td>-79.380414</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699999</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Bay St / Bloor St W</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ted Rogers Way / Bloor St E</td>\n",
       "      <td>347</td>\n",
       "      <td>1382394</td>\n",
       "      <td>2017-07-18 18:50:00</td>\n",
       "      <td>2017-07-18 18:55:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7029.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43.669430</td>\n",
       "      <td>-79.389150</td>\n",
       "      <td>7025.0</td>\n",
       "      <td>Ted Rogers Way / Bloor St E</td>\n",
       "      <td>43.671293</td>\n",
       "      <td>-79.380471</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        from_station_id                          from_station_name  \\\n",
       "699995              NaN  Dockside Dr / Queens Quay E (Sugar Beach)   \n",
       "699996              NaN                         Summerhill Station   \n",
       "699997              NaN                Ted Rogers Way / Bloor St E   \n",
       "699998              NaN                     Dundas St W / Yonge St   \n",
       "699999              NaN                        Bay St / Bloor St W   \n",
       "\n",
       "        to_station_id                       to_station_name  \\\n",
       "699995            NaN                Bremner Blvd / Rees St   \n",
       "699996            NaN                      Donlands Station   \n",
       "699997            NaN              Danforth Ave / Gough Ave   \n",
       "699998            NaN  25 York St (ACC/Union Station South)   \n",
       "699999            NaN           Ted Rogers Way / Bloor St E   \n",
       "\n",
       "        trip_duration_seconds  trip_id      trip_start_time  \\\n",
       "699995                    731  1382388  2017-07-18 18:49:00   \n",
       "699996                   1147  1382389  2017-07-18 18:49:00   \n",
       "699997                    762  1382390  2017-07-18 18:49:00   \n",
       "699998                    761  1382393  2017-07-18 18:50:00   \n",
       "699999                    347  1382394  2017-07-18 18:50:00   \n",
       "\n",
       "             trip_stop_time user_type  from_station_id_corr  ...   from_lat  \\\n",
       "699995  2017-07-18 19:01:00    Casual                7068.0  ...  43.644607   \n",
       "699996  2017-07-18 19:08:00    Member                7133.0  ...  43.681944   \n",
       "699997  2017-07-18 19:02:00    Member                7025.0  ...  43.671293   \n",
       "699998  2017-07-18 19:02:00    Member                7038.0  ...  43.656094   \n",
       "699999  2017-07-18 18:55:00    Casual                7029.0  ...  43.669430   \n",
       "\n",
       "         from_lon  to_station_id_corr               to_station_name_corr  \\\n",
       "699995 -79.366295              7018.0             Bremner Blvd / Rees St   \n",
       "699996 -79.390556              7091.0                   Donlands Station   \n",
       "699997 -79.380471              7093.0           Danforth Ave / Gough Ave   \n",
       "699998 -79.381484              7070.0  25 York St 鈥� Union Station South   \n",
       "699999 -79.389150              7025.0        Ted Rogers Way / Bloor St E   \n",
       "\n",
       "           to_lat     to_lon  trip_start_date  Temp (°C)  work_day month  \n",
       "699995  43.641529 -79.386741       2017-07-18  22.895833       Tue     7  \n",
       "699996  43.681126 -79.337779       2017-07-18  22.895833       Tue     7  \n",
       "699997  43.678401 -79.346289       2017-07-18  22.895833       Tue     7  \n",
       "699998  43.643667 -79.380414       2017-07-18  22.895833       Tue     7  \n",
       "699999  43.671293 -79.380471       2017-07-18  22.895833       Tue     7  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 223,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeData.tail(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 224,
   "metadata": {},
   "outputs": [],
   "source": [
    "bikeDataClean = bikeData.drop(['from_station_id','from_station_name','to_station_id','to_station_name'],axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 225,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>trip_duration_seconds</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>trip_start_time</th>\n",
       "      <th>trip_stop_time</th>\n",
       "      <th>user_type</th>\n",
       "      <th>from_station_id_corr</th>\n",
       "      <th>from_station_name_corr</th>\n",
       "      <th>from_lat</th>\n",
       "      <th>from_lon</th>\n",
       "      <th>to_station_id_corr</th>\n",
       "      <th>to_station_name_corr</th>\n",
       "      <th>to_lat</th>\n",
       "      <th>to_lon</th>\n",
       "      <th>trip_start_date</th>\n",
       "      <th>Temp (°C)</th>\n",
       "      <th>work_day</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>223</td>\n",
       "      <td>712382</td>\n",
       "      <td>2017-01-01 00:00:00</td>\n",
       "      <td>2017-01-01 00:03:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7051.0</td>\n",
       "      <td>Wellesley St E / Yonge St (Green P)</td>\n",
       "      <td>43.665060</td>\n",
       "      <td>-79.383570</td>\n",
       "      <td>7089.0</td>\n",
       "      <td>Church St  / Wood St</td>\n",
       "      <td>43.662712</td>\n",
       "      <td>-79.379903</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>279</td>\n",
       "      <td>712383</td>\n",
       "      <td>2017-01-01 00:00:00</td>\n",
       "      <td>2017-01-01 00:05:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7143.0</td>\n",
       "      <td>Kendal Ave / Bernard Ave</td>\n",
       "      <td>43.671513</td>\n",
       "      <td>-79.408317</td>\n",
       "      <td>7154.0</td>\n",
       "      <td>Bathurst Subway Station</td>\n",
       "      <td>43.666667</td>\n",
       "      <td>-79.411667</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1394</td>\n",
       "      <td>712384</td>\n",
       "      <td>2017-01-01 00:05:00</td>\n",
       "      <td>2017-01-01 00:29:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7113.0</td>\n",
       "      <td>Parliament St / Aberdeen Ave</td>\n",
       "      <td>43.665278</td>\n",
       "      <td>-79.368333</td>\n",
       "      <td>7199.0</td>\n",
       "      <td>College St / Markham St</td>\n",
       "      <td>43.656389</td>\n",
       "      <td>-79.409167</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>826</td>\n",
       "      <td>712385</td>\n",
       "      <td>2017-01-01 00:07:00</td>\n",
       "      <td>2017-01-01 00:21:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7077.0</td>\n",
       "      <td>College Park South</td>\n",
       "      <td>43.659777</td>\n",
       "      <td>-79.382767</td>\n",
       "      <td>7010.0</td>\n",
       "      <td>King St W / Spadina Ave</td>\n",
       "      <td>43.645323</td>\n",
       "      <td>-79.395003</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>279</td>\n",
       "      <td>712386</td>\n",
       "      <td>2017-01-01 00:08:00</td>\n",
       "      <td>2017-01-01 00:12:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7079.0</td>\n",
       "      <td>McGill St / Church St</td>\n",
       "      <td>43.660694</td>\n",
       "      <td>-79.379052</td>\n",
       "      <td>7047.0</td>\n",
       "      <td>University Ave / Gerrard St W</td>\n",
       "      <td>43.657763</td>\n",
       "      <td>-79.389165</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.2875</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   trip_duration_seconds  trip_id      trip_start_time       trip_stop_time  \\\n",
       "0                    223   712382  2017-01-01 00:00:00  2017-01-01 00:03:00   \n",
       "1                    279   712383  2017-01-01 00:00:00  2017-01-01 00:05:00   \n",
       "2                   1394   712384  2017-01-01 00:05:00  2017-01-01 00:29:00   \n",
       "3                    826   712385  2017-01-01 00:07:00  2017-01-01 00:21:00   \n",
       "4                    279   712386  2017-01-01 00:08:00  2017-01-01 00:12:00   \n",
       "\n",
       "  user_type  from_station_id_corr               from_station_name_corr  \\\n",
       "0    Member                7051.0  Wellesley St E / Yonge St (Green P)   \n",
       "1    Member                7143.0             Kendal Ave / Bernard Ave   \n",
       "2    Member                7113.0         Parliament St / Aberdeen Ave   \n",
       "3    Member                7077.0                   College Park South   \n",
       "4    Member                7079.0                McGill St / Church St   \n",
       "\n",
       "    from_lat   from_lon  to_station_id_corr           to_station_name_corr  \\\n",
       "0  43.665060 -79.383570              7089.0           Church St  / Wood St   \n",
       "1  43.671513 -79.408317              7154.0        Bathurst Subway Station   \n",
       "2  43.665278 -79.368333              7199.0        College St / Markham St   \n",
       "3  43.659777 -79.382767              7010.0        King St W / Spadina Ave   \n",
       "4  43.660694 -79.379052              7047.0  University Ave / Gerrard St W   \n",
       "\n",
       "      to_lat     to_lon trip_start_date  Temp (°C) work_day  month  \n",
       "0  43.662712 -79.379903      2017-01-01     1.2875      Sun      1  \n",
       "1  43.666667 -79.411667      2017-01-01     1.2875      Sun      1  \n",
       "2  43.656389 -79.409167      2017-01-01     1.2875      Sun      1  \n",
       "3  43.645323 -79.395003      2017-01-01     1.2875      Sun      1  \n",
       "4  43.657763 -79.389165      2017-01-01     1.2875      Sun      1  "
      ]
     },
     "execution_count": 225,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 226,
   "metadata": {},
   "outputs": [],
   "source": [
    "#from_lat, from_lon\n",
    "#to_lat, to_lon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 227,
   "metadata": {},
   "outputs": [],
   "source": [
    "startLats = bikeDataClean[\"from_lat\"]\n",
    "startLons =  bikeDataClean[\"from_lon\"]\n",
    "\n",
    "endLats = bikeDataClean[\"to_lat\"]\n",
    "endLons = bikeDataClean[\"to_lon\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 228,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creating the location we would like to initialize the focus on. \n",
    "# Parameters: Latitude, Longitude, Zoom\n",
    "gmap = gmplot.GoogleMapPlotter(34.0522, -118.2437, 10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {},
   "outputs": [],
   "source": [
    "gmap.draw('testmap.html')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Look up the most popular stations \n",
    "#(and routes - create a new column for this) \n",
    "#all year, \n",
    "#month by month, \n",
    "#weekdays, \n",
    "#hourly (rush hours vs midnights)\n",
    "\n",
    "# no GPS data, so you could only really derive the station-station distance, \n",
    "# without road consideration.\n",
    "\n",
    "# Also - perhaps look up Toronto bike accident data, \n",
    "##\\ see if there is any relationship to the busiest areas?\n",
    "\n",
    "# Look up some way of visualizing month-to-month animation,\n",
    "# if I get the bubble or heat map working\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Union Station                      11005\n",
       "Simcoe St / Wellington St South    10639\n",
       "Dundas St W / Yonge St              9878\n",
       "King St W / Spadina Ave             9593\n",
       "Bay St / Wellesley St W             9441\n",
       "Bay St / College St (East Side)     9275\n",
       "Queen St W / Portland St            9113\n",
       "Widmer St / Adelaide St W           8842\n",
       "Princess St / Adelaide St E         8114\n",
       "Sherbourne St / Wellesley St E      7984\n",
       "Name: from_station_name_corr, dtype: int64"
      ]
     },
     "execution_count": 231,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean['from_station_name_corr'].value_counts().head(10)\n",
    "# The majority of start points are downtown "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 232,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Wright / Sorauren (Sorauren Park) - SMART     73\n",
       "Wallace Ave / Symington Ave - SMART           59\n",
       "Sorauren/Geoffrey (Sorauren Park) - SMART     58\n",
       "Howard Park Ave / Dundas St W - SMART         53\n",
       "Exhibition GO Station                         51\n",
       "Dufferin Gate - SMART                         47\n",
       "Chorley Park - SMART                          46\n",
       "Parkside Dr / Bloor St W - SMART              36\n",
       "Dundas St W / Roncesvalles Green P - SMART    30\n",
       "Victoria Park Subway Station - SMART          17\n",
       "Name: from_station_name_corr, dtype: int64"
      ]
     },
     "execution_count": 232,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean['from_station_name_corr'].value_counts().tail(10)\n",
    "# while the lowest amount start in residential areas (primarily in the west end)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Union Station                      14663\n",
       "Simcoe St / Wellington St South    11572\n",
       "Dundas St W / Yonge St             10872\n",
       "King St W / Spadina Ave            10502\n",
       "Princess St / Adelaide St E         9983\n",
       "Queen St W / Portland St            9572\n",
       "Widmer St / Adelaide St W           9077\n",
       "Bay St / College St (East Side)     9049\n",
       "York St / Queens Quay W             8623\n",
       "Phoebe St / Spadina Ave             8282\n",
       "Name: to_station_name_corr, dtype: int64"
      ]
     },
     "execution_count": 233,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean['to_station_name_corr'].value_counts().head(10)\n",
    "# End points are the same; most end downtown"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Wright / Sorauren (Sorauren Park) - SMART     65\n",
       "Howard Park Ave / Dundas St W - SMART         61\n",
       "Wychwood Ave / Benson Ave - SMART             59\n",
       "Chorley Park - SMART                          54\n",
       "Exhibition GO Station                         48\n",
       "Parkside Dr / Bloor St W - SMART              46\n",
       "Wallace Ave / Symington Ave - SMART           45\n",
       "Dufferin Gate - SMART                         44\n",
       "Victoria Park Subway Station - SMART          22\n",
       "Dundas St W / Roncesvalles Green P - SMART    18\n",
       "Name: to_station_name_corr, dtype: int64"
      ]
     },
     "execution_count": 234,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean['to_station_name_corr'].value_counts().tail(10)\n",
    "# ...and the least end the western residential areas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a new column for PointA-PointB trip designations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 236,
   "metadata": {},
   "outputs": [],
   "source": [
    "tripItinerary = bikeDataClean['from_station_name_corr'] + ' TO ' + bikeDataClean['to_station_name_corr']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 237,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(tripItinerary)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 238,
   "metadata": {},
   "outputs": [],
   "source": [
    "bikeDataClean['TripItinerary'] = tripItinerary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Front St W / Blue Jays Way TO Union Station                                       1060\n",
       "Ontario Place Blvd / Lakeshore Blvd W TO Ontario Place Blvd / Lakeshore Blvd W     970\n",
       "Bay St / Wellesley St W TO Union Station                                           661\n",
       "King St W / Spadina Ave TO Simcoe St / Wellington St South                         647\n",
       "Simcoe St / Wellington St South TO King St W / Spadina Ave                         608\n",
       "King St W / Spadina Ave TO Union Station                                           578\n",
       "Gould St / Mutual St TO Front St W / Yonge St (Hockey Hall of Fame)                535\n",
       "Wellesley St E / Yonge St (Green P) TO Sherbourne St / Wellesley St E              500\n",
       "Widmer St / Adelaide St W TO Princess St / Adelaide St E                           484\n",
       "424 Wellington St W TO Union Station                                               474\n",
       "Name: TripItinerary, dtype: int64"
      ]
     },
     "execution_count": 239,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean['TripItinerary'].value_counts().head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 240,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Claremont St / Dundas St W TO Front St W / Yonge St (Hockey Hall of Fame)             1\n",
       "Bay St / Queens Quay W (Ferry Terminal) TO Ossington Ave / College St                 1\n",
       "519 Church St - SMART TO Bay St / Charles St - SMART                                  1\n",
       "Sorauren/Geoffrey (Sorauren Park) - SMART TO Howard Park Ave / Dundas St W - SMART    1\n",
       "York St / King St W - SMART TO Yonge St / Wood St                                     1\n",
       "Scott St / The Esplanade TO Queen's Park Cres E / Grosvenor St - SMART                1\n",
       "Hayter St / Laplante Ave TO Davenport Rd / Christie St                                1\n",
       "Mary McCormick Rec Centre (Sheridan Ave) TO Bond St / Queen St E                      1\n",
       "Queen St E / Pape Ave - SMART TO Cherry St / Mill St                                  1\n",
       "Bloor St W / Manning Ave - SMART TO Bay St / Charles St - SMART                       1\n",
       "Euclid Ave / Bloor St W TO Jarvis St / Carlton St                                     1\n",
       "Dalton Rd / Bloor St W TO Jimmie Simpson Park (Queen St E)                            1\n",
       "King / Cowan Ave - SMART TO 424 Wellington St W                                       1\n",
       "Garden Ave / Roncesvalles Ave TO Lakeshore Blvd W / Ellis Ave                         1\n",
       "Queen's Park Cres E / Grosvenor St - SMART TO King St W / Bay St (West Side)          1\n",
       "College St / Huron St TO Mortimer Ave / Coxwell Ave                                   1\n",
       "Dundas St W / Crawford St TO Davenport Rd / Avenue Rd                                 1\n",
       "Euclid Ave / Bloor St W TO Lansdowne Ave / Whytock Ave                                1\n",
       "Jarvis St / Dundas St E TO Yonge St / Dundonald St - SMART                            1\n",
       "Ted Rogers Way / Bloor St E TO Victoria Park Subway Station - SMART                   1\n",
       "Name: TripItinerary, dtype: int64"
      ]
     },
     "execution_count": 240,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean['TripItinerary'].value_counts().tail(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "metadata": {},
   "outputs": [],
   "source": [
    "# A couple more data columns we could create:\n",
    "# Check whether or not a start & stop point is the same;\n",
    "# This would indicate renting a bike for a round trip (sightsee-ing)\n",
    "# as opposed to going from Point A to Point B ()\n",
    "commuteOrSightsee = (bikeDataClean['from_station_name_corr'] == bikeDataClean['to_station_name_corr'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    688634\n",
       "True      11366\n",
       "dtype: int64"
      ]
     },
     "execution_count": 242,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "commuteOrSightsee.value_counts()\n",
    "# we can see that ~ 1% of the total number of trips is for sight-seeing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    688631\n",
       "True      11369\n",
       "dtype: int64"
      ]
     },
     "execution_count": 243,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# lets confirm this by comparing start & stop longitudes and latitudes;\n",
    "# this will also allow us to check if there are any stops with overlapping coordinates\n",
    "longStartEnd = (bikeDataClean['from_lon'] == bikeDataClean['to_lon'])\n",
    "longStartEnd.value_counts()\n",
    "# longitude has a delta of 3 more sightseeing locations\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 244,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    688605\n",
       "True      11395\n",
       "dtype: int64"
      ]
     },
     "execution_count": 244,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "latStartEnd = (bikeDataClean['from_lat'] == bikeDataClean['to_lat'])\n",
    "latStartEnd.value_counts()\n",
    "# Latitude has a delta of 29 more sightseeing locations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True    700000\n",
       "dtype: int64"
      ]
     },
     "execution_count": 245,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# One more check - add the start long/lat columns together, compare to added end long/lat columns\n",
    "totalFrom = bikeDataClean['from_lat'] + bikeDataClean['from_lon']\n",
    "totalTo = bikeDataClean['to_lat'] + bikeDataClean['to_lon']\n",
    "totalFromToCheck = (totalFrom == totalTo)\n",
    "totalFromToCheck.value_counts()\n",
    "\n",
    "# this gives the exact same results as using the stop names\n",
    "# confirmation that they are all overlapping properly:\n",
    "(totalFromToCheck == commuteOrSightsee).value_counts()\n",
    "# all OK"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 246,
   "metadata": {},
   "outputs": [],
   "source": [
    "bikeDataClean['Sightseeing'] = commuteOrSightsee"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 247,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>trip_duration_seconds</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>trip_start_time</th>\n",
       "      <th>trip_stop_time</th>\n",
       "      <th>user_type</th>\n",
       "      <th>from_station_id_corr</th>\n",
       "      <th>from_station_name_corr</th>\n",
       "      <th>from_lat</th>\n",
       "      <th>from_lon</th>\n",
       "      <th>to_station_id_corr</th>\n",
       "      <th>to_station_name_corr</th>\n",
       "      <th>to_lat</th>\n",
       "      <th>to_lon</th>\n",
       "      <th>trip_start_date</th>\n",
       "      <th>Temp (°C)</th>\n",
       "      <th>work_day</th>\n",
       "      <th>month</th>\n",
       "      <th>TripItinerary</th>\n",
       "      <th>Sightseeing</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>223</td>\n",
       "      <td>712382</td>\n",
       "      <td>2017-01-01 00:00:00</td>\n",
       "      <td>2017-01-01 00:03:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7051.0</td>\n",
       "      <td>Wellesley St E / Yonge St (Green P)</td>\n",
       "      <td>43.665060</td>\n",
       "      <td>-79.383570</td>\n",
       "      <td>7089.0</td>\n",
       "      <td>Church St  / Wood St</td>\n",
       "      <td>43.662712</td>\n",
       "      <td>-79.379903</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Wellesley St E / Yonge St (Green P) TO Church ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>279</td>\n",
       "      <td>712383</td>\n",
       "      <td>2017-01-01 00:00:00</td>\n",
       "      <td>2017-01-01 00:05:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7143.0</td>\n",
       "      <td>Kendal Ave / Bernard Ave</td>\n",
       "      <td>43.671513</td>\n",
       "      <td>-79.408317</td>\n",
       "      <td>7154.0</td>\n",
       "      <td>Bathurst Subway Station</td>\n",
       "      <td>43.666667</td>\n",
       "      <td>-79.411667</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Kendal Ave / Bernard Ave TO Bathurst Subway St...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1394</td>\n",
       "      <td>712384</td>\n",
       "      <td>2017-01-01 00:05:00</td>\n",
       "      <td>2017-01-01 00:29:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7113.0</td>\n",
       "      <td>Parliament St / Aberdeen Ave</td>\n",
       "      <td>43.665278</td>\n",
       "      <td>-79.368333</td>\n",
       "      <td>7199.0</td>\n",
       "      <td>College St / Markham St</td>\n",
       "      <td>43.656389</td>\n",
       "      <td>-79.409167</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Parliament St / Aberdeen Ave TO College St / M...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>826</td>\n",
       "      <td>712385</td>\n",
       "      <td>2017-01-01 00:07:00</td>\n",
       "      <td>2017-01-01 00:21:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7077.0</td>\n",
       "      <td>College Park South</td>\n",
       "      <td>43.659777</td>\n",
       "      <td>-79.382767</td>\n",
       "      <td>7010.0</td>\n",
       "      <td>King St W / Spadina Ave</td>\n",
       "      <td>43.645323</td>\n",
       "      <td>-79.395003</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>College Park South TO King St W / Spadina Ave</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>279</td>\n",
       "      <td>712386</td>\n",
       "      <td>2017-01-01 00:08:00</td>\n",
       "      <td>2017-01-01 00:12:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7079.0</td>\n",
       "      <td>McGill St / Church St</td>\n",
       "      <td>43.660694</td>\n",
       "      <td>-79.379052</td>\n",
       "      <td>7047.0</td>\n",
       "      <td>University Ave / Gerrard St W</td>\n",
       "      <td>43.657763</td>\n",
       "      <td>-79.389165</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>McGill St / Church St TO University Ave / Gerr...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>571</td>\n",
       "      <td>712387</td>\n",
       "      <td>2017-01-01 00:12:00</td>\n",
       "      <td>2017-01-01 00:22:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7021.0</td>\n",
       "      <td>Bay St / Albert St</td>\n",
       "      <td>43.653264</td>\n",
       "      <td>-79.382458</td>\n",
       "      <td>7046.0</td>\n",
       "      <td>Niagara St / Richmond St W</td>\n",
       "      <td>43.645340</td>\n",
       "      <td>-79.409597</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Bay St / Albert St TO Niagara St / Richmond St W</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1084</td>\n",
       "      <td>712388</td>\n",
       "      <td>2017-01-01 00:15:00</td>\n",
       "      <td>2017-01-01 00:33:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7161.0</td>\n",
       "      <td>Beverley St / College St</td>\n",
       "      <td>43.657500</td>\n",
       "      <td>-79.395278</td>\n",
       "      <td>7176.0</td>\n",
       "      <td>Bathurst St / Fort York Blvd</td>\n",
       "      <td>43.639179</td>\n",
       "      <td>-79.399595</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Beverley St / College St TO Bathurst St / Fort...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>307</td>\n",
       "      <td>712389</td>\n",
       "      <td>2017-01-01 00:15:00</td>\n",
       "      <td>2017-01-01 00:21:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7195.0</td>\n",
       "      <td>Ulster St / Bathurst St</td>\n",
       "      <td>43.660000</td>\n",
       "      <td>-79.408889</td>\n",
       "      <td>7037.0</td>\n",
       "      <td>Bathurst St / Dundas St W</td>\n",
       "      <td>43.652300</td>\n",
       "      <td>-79.405800</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Ulster St / Bathurst St TO Bathurst St / Dunda...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>647</td>\n",
       "      <td>712390</td>\n",
       "      <td>2017-01-01 00:20:00</td>\n",
       "      <td>2017-01-01 00:31:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7017.0</td>\n",
       "      <td>Widmer St / Adelaide St W</td>\n",
       "      <td>43.647508</td>\n",
       "      <td>-79.391484</td>\n",
       "      <td>7101.0</td>\n",
       "      <td>Lower Sherbourne St / The Esplanade</td>\n",
       "      <td>43.648655</td>\n",
       "      <td>-79.367061</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Widmer St / Adelaide St W TO Lower Sherbourne ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>217</td>\n",
       "      <td>712391</td>\n",
       "      <td>2017-01-01 00:23:00</td>\n",
       "      <td>2017-01-01 00:27:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7017.0</td>\n",
       "      <td>Widmer St / Adelaide St W</td>\n",
       "      <td>43.647508</td>\n",
       "      <td>-79.391484</td>\n",
       "      <td>7005.0</td>\n",
       "      <td>King St W / York St</td>\n",
       "      <td>43.648001</td>\n",
       "      <td>-79.383177</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Widmer St / Adelaide St W TO King St W / York St</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>467</td>\n",
       "      <td>712392</td>\n",
       "      <td>2017-01-01 00:28:00</td>\n",
       "      <td>2017-01-01 00:36:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7009.0</td>\n",
       "      <td>King St E / Jarvis St</td>\n",
       "      <td>43.650325</td>\n",
       "      <td>-79.372287</td>\n",
       "      <td>7016.0</td>\n",
       "      <td>Bay St / Queens Quay W (Ferry Terminal)</td>\n",
       "      <td>43.640823</td>\n",
       "      <td>-79.376265</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>King St E / Jarvis St TO Bay St / Queens Quay ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>880</td>\n",
       "      <td>712393</td>\n",
       "      <td>2017-01-01 00:28:00</td>\n",
       "      <td>2017-01-01 00:43:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7032.0</td>\n",
       "      <td>Augusta Ave / Dundas St W</td>\n",
       "      <td>43.652473</td>\n",
       "      <td>-79.401456</td>\n",
       "      <td>7070.0</td>\n",
       "      <td>25 York St 鈥� Union Station South</td>\n",
       "      <td>43.643667</td>\n",
       "      <td>-79.380414</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Augusta Ave / Dundas St W TO 25 York St 鈥� Uni...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>228</td>\n",
       "      <td>712394</td>\n",
       "      <td>2017-01-01 00:31:00</td>\n",
       "      <td>2017-01-01 00:35:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7177.0</td>\n",
       "      <td>East Liberty St / Pirandello St</td>\n",
       "      <td>43.638611</td>\n",
       "      <td>-79.414722</td>\n",
       "      <td>7158.0</td>\n",
       "      <td>King St W / Stafford St</td>\n",
       "      <td>43.642222</td>\n",
       "      <td>-79.411111</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>East Liberty St / Pirandello St TO King St W /...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>361</td>\n",
       "      <td>712395</td>\n",
       "      <td>2017-01-01 00:33:00</td>\n",
       "      <td>2017-01-01 00:39:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7045.0</td>\n",
       "      <td>Bond St / Queen St E</td>\n",
       "      <td>43.653236</td>\n",
       "      <td>-79.376716</td>\n",
       "      <td>7060.0</td>\n",
       "      <td>Princess St / Adelaide St E</td>\n",
       "      <td>43.652123</td>\n",
       "      <td>-79.367139</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Bond St / Queen St E TO Princess St / Adelaide...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>227</td>\n",
       "      <td>712396</td>\n",
       "      <td>2017-01-01 00:38:00</td>\n",
       "      <td>2017-01-01 00:42:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7158.0</td>\n",
       "      <td>King St W / Stafford St</td>\n",
       "      <td>43.642222</td>\n",
       "      <td>-79.411111</td>\n",
       "      <td>7177.0</td>\n",
       "      <td>East Liberty St / Pirandello St</td>\n",
       "      <td>43.638611</td>\n",
       "      <td>-79.414722</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>King St W / Stafford St TO East Liberty St / P...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>354</td>\n",
       "      <td>712397</td>\n",
       "      <td>2017-01-01 00:53:00</td>\n",
       "      <td>2017-01-01 00:59:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7022.0</td>\n",
       "      <td>Simcoe St / Queen St W</td>\n",
       "      <td>43.650858</td>\n",
       "      <td>-79.387582</td>\n",
       "      <td>7033.0</td>\n",
       "      <td>Union Station</td>\n",
       "      <td>43.645609</td>\n",
       "      <td>-79.380386</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Simcoe St / Queen St W TO Union Station</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>591</td>\n",
       "      <td>712398</td>\n",
       "      <td>2017-01-01 00:55:00</td>\n",
       "      <td>2017-01-01 01:05:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7077.0</td>\n",
       "      <td>College Park South</td>\n",
       "      <td>43.659777</td>\n",
       "      <td>-79.382767</td>\n",
       "      <td>7101.0</td>\n",
       "      <td>Lower Sherbourne St / The Esplanade</td>\n",
       "      <td>43.648655</td>\n",
       "      <td>-79.367061</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>College Park South TO Lower Sherbourne St / Th...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>169</td>\n",
       "      <td>712399</td>\n",
       "      <td>2017-01-01 00:59:00</td>\n",
       "      <td>2017-01-01 01:02:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7028.0</td>\n",
       "      <td>Gould St / Mutual St</td>\n",
       "      <td>43.658200</td>\n",
       "      <td>-79.376800</td>\n",
       "      <td>7164.0</td>\n",
       "      <td>Gould St / Yonge St (Ryerson University)</td>\n",
       "      <td>43.657424</td>\n",
       "      <td>-79.381019</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Gould St / Mutual St TO Gould St / Yonge St (R...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>451</td>\n",
       "      <td>712400</td>\n",
       "      <td>2017-01-01 00:59:00</td>\n",
       "      <td>2017-01-01 01:07:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7038.0</td>\n",
       "      <td>Dundas St W / Yonge St</td>\n",
       "      <td>43.656094</td>\n",
       "      <td>-79.381484</td>\n",
       "      <td>7065.0</td>\n",
       "      <td>Dundas St E / Parliament St</td>\n",
       "      <td>43.659575</td>\n",
       "      <td>-79.365769</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Dundas St W / Yonge St TO Dundas St E / Parlia...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>920</td>\n",
       "      <td>712401</td>\n",
       "      <td>2017-01-01 01:02:00</td>\n",
       "      <td>2017-01-01 01:17:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7130.0</td>\n",
       "      <td>Davenport Rd / Bedford Rd</td>\n",
       "      <td>43.674398</td>\n",
       "      <td>-79.398660</td>\n",
       "      <td>7038.0</td>\n",
       "      <td>Dundas St W / Yonge St</td>\n",
       "      <td>43.656094</td>\n",
       "      <td>-79.381484</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Davenport Rd / Bedford Rd TO Dundas St W / Yon...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>256</td>\n",
       "      <td>712402</td>\n",
       "      <td>2017-01-01 01:07:00</td>\n",
       "      <td>2017-01-01 01:11:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7042.0</td>\n",
       "      <td>Sherbourne St / Wellesley St E</td>\n",
       "      <td>43.667300</td>\n",
       "      <td>-79.374000</td>\n",
       "      <td>7031.0</td>\n",
       "      <td>Jarvis St / Isabella St</td>\n",
       "      <td>43.668991</td>\n",
       "      <td>-79.379385</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Sherbourne St / Wellesley St E TO Jarvis St / ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>398</td>\n",
       "      <td>712403</td>\n",
       "      <td>2017-01-01 01:12:00</td>\n",
       "      <td>2017-01-01 01:19:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7160.0</td>\n",
       "      <td>King St W / Tecumseth St</td>\n",
       "      <td>43.643333</td>\n",
       "      <td>-79.405556</td>\n",
       "      <td>7054.0</td>\n",
       "      <td>Navy Wharf Ct. / Bremner Blvd.</td>\n",
       "      <td>43.640722</td>\n",
       "      <td>-79.391051</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>King St W / Tecumseth St TO Navy Wharf Ct. / B...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>982</td>\n",
       "      <td>712404</td>\n",
       "      <td>2017-01-01 01:14:00</td>\n",
       "      <td>2017-01-01 01:30:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7004.0</td>\n",
       "      <td>University Ave / Elm St</td>\n",
       "      <td>43.656518</td>\n",
       "      <td>-79.389099</td>\n",
       "      <td>7164.0</td>\n",
       "      <td>Gould St / Yonge St (Ryerson University)</td>\n",
       "      <td>43.657424</td>\n",
       "      <td>-79.381019</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>University Ave / Elm St TO Gould St / Yonge St...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>261</td>\n",
       "      <td>712405</td>\n",
       "      <td>2017-01-01 01:29:00</td>\n",
       "      <td>2017-01-01 01:33:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7163.0</td>\n",
       "      <td>Yonge St / Wood St</td>\n",
       "      <td>43.662222</td>\n",
       "      <td>-79.382500</td>\n",
       "      <td>7041.0</td>\n",
       "      <td>Edward St / Yonge St</td>\n",
       "      <td>43.656729</td>\n",
       "      <td>-79.382736</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Yonge St / Wood St TO Edward St / Yonge St</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>182</td>\n",
       "      <td>712406</td>\n",
       "      <td>2017-01-01 01:31:00</td>\n",
       "      <td>2017-01-01 01:34:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7164.0</td>\n",
       "      <td>Gould St / Yonge St (Ryerson University)</td>\n",
       "      <td>43.657424</td>\n",
       "      <td>-79.381019</td>\n",
       "      <td>7045.0</td>\n",
       "      <td>Bond St / Queen St E</td>\n",
       "      <td>43.653236</td>\n",
       "      <td>-79.376716</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Gould St / Yonge St (Ryerson University) TO Bo...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>780</td>\n",
       "      <td>712407</td>\n",
       "      <td>2017-01-01 01:31:00</td>\n",
       "      <td>2017-01-01 01:44:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7050.0</td>\n",
       "      <td>Richmond St E / Jarvis St Green P</td>\n",
       "      <td>43.652634</td>\n",
       "      <td>-79.374222</td>\n",
       "      <td>7043.0</td>\n",
       "      <td>Queens Quay W / Lower Simcoe St</td>\n",
       "      <td>43.639510</td>\n",
       "      <td>-79.383717</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Richmond St E / Jarvis St Green P TO Queens Qu...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1183</td>\n",
       "      <td>712408</td>\n",
       "      <td>2017-01-01 01:32:00</td>\n",
       "      <td>2017-01-01 01:51:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7133.0</td>\n",
       "      <td>Summerhill Station</td>\n",
       "      <td>43.681944</td>\n",
       "      <td>-79.390556</td>\n",
       "      <td>7049.0</td>\n",
       "      <td>Queen St W / Portland St</td>\n",
       "      <td>43.647600</td>\n",
       "      <td>-79.401500</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Summerhill Station TO Queen St W / Portland St</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>474</td>\n",
       "      <td>712409</td>\n",
       "      <td>2017-01-01 01:32:00</td>\n",
       "      <td>2017-01-01 01:40:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7192.0</td>\n",
       "      <td>Harbord St / Clinton St</td>\n",
       "      <td>43.660414</td>\n",
       "      <td>-79.415646</td>\n",
       "      <td>7205.0</td>\n",
       "      <td>Rusholme Park Cres / College St</td>\n",
       "      <td>43.652778</td>\n",
       "      <td>-79.429722</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Harbord St / Clinton St TO Rusholme Park Cres ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>473</td>\n",
       "      <td>712410</td>\n",
       "      <td>2017-01-01 01:40:00</td>\n",
       "      <td>2017-01-01 01:48:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7070.0</td>\n",
       "      <td>25 York St 鈥� Union Station South</td>\n",
       "      <td>43.643667</td>\n",
       "      <td>-79.380414</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>Fort York  Blvd / Capreol Ct</td>\n",
       "      <td>43.639832</td>\n",
       "      <td>-79.395954</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>25 York St 鈥� Union Station South TO Fort York...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>999</td>\n",
       "      <td>712411</td>\n",
       "      <td>2017-01-01 01:43:00</td>\n",
       "      <td>2017-01-01 02:00:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7059.0</td>\n",
       "      <td>Front St W / Blue Jays Way</td>\n",
       "      <td>43.643473</td>\n",
       "      <td>-79.390477</td>\n",
       "      <td>7208.0</td>\n",
       "      <td>80 Clinton St (North of College)</td>\n",
       "      <td>43.656296</td>\n",
       "      <td>-79.414663</td>\n",
       "      <td>2017-01-01</td>\n",
       "      <td>1.287500</td>\n",
       "      <td>Sun</td>\n",
       "      <td>1</td>\n",
       "      <td>Front St W / Blue Jays Way TO 80 Clinton St (N...</td>\n",
       "      <td>False</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699970</th>\n",
       "      <td>637</td>\n",
       "      <td>1382359</td>\n",
       "      <td>2017-07-18 18:48:00</td>\n",
       "      <td>2017-07-18 18:58:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7032.0</td>\n",
       "      <td>Augusta Ave / Dundas St W</td>\n",
       "      <td>43.652473</td>\n",
       "      <td>-79.401456</td>\n",
       "      <td>7038.0</td>\n",
       "      <td>Dundas St W / Yonge St</td>\n",
       "      <td>43.656094</td>\n",
       "      <td>-79.381484</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Augusta Ave / Dundas St W TO Dundas St W / Yon...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699971</th>\n",
       "      <td>375</td>\n",
       "      <td>1382360</td>\n",
       "      <td>2017-07-18 18:48:00</td>\n",
       "      <td>2017-07-18 18:54:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7108.0</td>\n",
       "      <td>Front St E / Cherry St</td>\n",
       "      <td>43.652686</td>\n",
       "      <td>-79.358395</td>\n",
       "      <td>7109.0</td>\n",
       "      <td>Seaton St / Dundas St E</td>\n",
       "      <td>43.658777</td>\n",
       "      <td>-79.369596</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Front St E / Cherry St TO Seaton St / Dundas St E</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699972</th>\n",
       "      <td>1184</td>\n",
       "      <td>1382361</td>\n",
       "      <td>2017-07-18 18:48:00</td>\n",
       "      <td>2017-07-18 19:08:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7043.0</td>\n",
       "      <td>Queens Quay W / Lower Simcoe St</td>\n",
       "      <td>43.639510</td>\n",
       "      <td>-79.383717</td>\n",
       "      <td>7002.0</td>\n",
       "      <td>St. George St / Bloor St W</td>\n",
       "      <td>43.667333</td>\n",
       "      <td>-79.399429</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Queens Quay W / Lower Simcoe St TO St. George ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699973</th>\n",
       "      <td>459</td>\n",
       "      <td>1382363</td>\n",
       "      <td>2017-07-18 18:48:00</td>\n",
       "      <td>2017-07-18 18:56:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7033.0</td>\n",
       "      <td>Union Station</td>\n",
       "      <td>43.645609</td>\n",
       "      <td>-79.380386</td>\n",
       "      <td>7073.0</td>\n",
       "      <td>Spadina Ave / Fort York Blvd</td>\n",
       "      <td>43.640114</td>\n",
       "      <td>-79.393249</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Union Station TO Spadina Ave / Fort York Blvd</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699974</th>\n",
       "      <td>808</td>\n",
       "      <td>1382364</td>\n",
       "      <td>2017-07-18 18:48:00</td>\n",
       "      <td>2017-07-18 19:02:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7107.0</td>\n",
       "      <td>Cherry St / Distillery Ln</td>\n",
       "      <td>43.650279</td>\n",
       "      <td>-79.356832</td>\n",
       "      <td>7009.0</td>\n",
       "      <td>King St E / Jarvis St</td>\n",
       "      <td>43.650325</td>\n",
       "      <td>-79.372287</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Cherry St / Distillery Ln TO King St E / Jarvi...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699975</th>\n",
       "      <td>272</td>\n",
       "      <td>1382365</td>\n",
       "      <td>2017-07-18 18:48:00</td>\n",
       "      <td>2017-07-18 18:53:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7077.0</td>\n",
       "      <td>College Park South</td>\n",
       "      <td>43.659777</td>\n",
       "      <td>-79.382767</td>\n",
       "      <td>7024.0</td>\n",
       "      <td>Dundonald St / Church St</td>\n",
       "      <td>43.666630</td>\n",
       "      <td>-79.381480</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>College Park South TO Dundonald St / Church St</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699976</th>\n",
       "      <td>84</td>\n",
       "      <td>1382366</td>\n",
       "      <td>2017-07-18 18:48:00</td>\n",
       "      <td>2017-07-18 18:50:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7123.0</td>\n",
       "      <td>424 Wellington St W</td>\n",
       "      <td>43.643834</td>\n",
       "      <td>-79.396649</td>\n",
       "      <td>7011.0</td>\n",
       "      <td>Wellington St W / Portland St</td>\n",
       "      <td>43.642982</td>\n",
       "      <td>-79.399256</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>424 Wellington St W TO Wellington St W / Portl...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699977</th>\n",
       "      <td>362</td>\n",
       "      <td>1382367</td>\n",
       "      <td>2017-07-18 18:48:00</td>\n",
       "      <td>2017-07-18 18:54:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7041.0</td>\n",
       "      <td>Edward St / Yonge St</td>\n",
       "      <td>43.656729</td>\n",
       "      <td>-79.382736</td>\n",
       "      <td>7102.0</td>\n",
       "      <td>Nelson St / Duncan St</td>\n",
       "      <td>43.648711</td>\n",
       "      <td>-79.389728</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Edward St / Yonge St TO Nelson St / Duncan St</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699978</th>\n",
       "      <td>241</td>\n",
       "      <td>1382368</td>\n",
       "      <td>2017-07-18 18:48:00</td>\n",
       "      <td>2017-07-18 18:52:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7189.0</td>\n",
       "      <td>Augusta Ave / Denison Sq</td>\n",
       "      <td>43.653766</td>\n",
       "      <td>-79.401676</td>\n",
       "      <td>7049.0</td>\n",
       "      <td>Queen St W / Portland St</td>\n",
       "      <td>43.647600</td>\n",
       "      <td>-79.401500</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Augusta Ave / Denison Sq TO Queen St W / Portl...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699979</th>\n",
       "      <td>440</td>\n",
       "      <td>1382369</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 18:56:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7002.0</td>\n",
       "      <td>St. George St / Bloor St W</td>\n",
       "      <td>43.667333</td>\n",
       "      <td>-79.399429</td>\n",
       "      <td>7040.0</td>\n",
       "      <td>Euclid Ave / Bloor St W</td>\n",
       "      <td>43.664467</td>\n",
       "      <td>-79.414783</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>St. George St / Bloor St W TO Euclid Ave / Blo...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699980</th>\n",
       "      <td>774</td>\n",
       "      <td>1382370</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:01:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7068.0</td>\n",
       "      <td>Dockside Dr / Queens Quay E (Sugar Beach)</td>\n",
       "      <td>43.644607</td>\n",
       "      <td>-79.366295</td>\n",
       "      <td>7018.0</td>\n",
       "      <td>Bremner Blvd / Rees St</td>\n",
       "      <td>43.641529</td>\n",
       "      <td>-79.386741</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Dockside Dr / Queens Quay E (Sugar Beach) TO B...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699981</th>\n",
       "      <td>328</td>\n",
       "      <td>1382371</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 18:54:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7169.0</td>\n",
       "      <td>Front St W / Bay St (North Side)</td>\n",
       "      <td>43.646162</td>\n",
       "      <td>-79.378912</td>\n",
       "      <td>7059.0</td>\n",
       "      <td>Front St W / Blue Jays Way</td>\n",
       "      <td>43.643473</td>\n",
       "      <td>-79.390477</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Front St W / Bay St (North Side) TO Front St W...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699982</th>\n",
       "      <td>1148</td>\n",
       "      <td>1382372</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:08:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7189.0</td>\n",
       "      <td>Augusta Ave / Denison Sq</td>\n",
       "      <td>43.653766</td>\n",
       "      <td>-79.401676</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699983</th>\n",
       "      <td>1095</td>\n",
       "      <td>1382373</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:07:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7011.0</td>\n",
       "      <td>Wellington St W / Portland St</td>\n",
       "      <td>43.642982</td>\n",
       "      <td>-79.399256</td>\n",
       "      <td>7056.0</td>\n",
       "      <td>Parliament St / Gerrard St</td>\n",
       "      <td>43.662132</td>\n",
       "      <td>-79.365680</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Wellington St W / Portland St TO Parliament St...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699984</th>\n",
       "      <td>951</td>\n",
       "      <td>1382374</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:05:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7077.0</td>\n",
       "      <td>College Park South</td>\n",
       "      <td>43.659777</td>\n",
       "      <td>-79.382767</td>\n",
       "      <td>7036.0</td>\n",
       "      <td>Trinity St /Front St E</td>\n",
       "      <td>43.651318</td>\n",
       "      <td>-79.360230</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>College Park South TO Trinity St /Front St E</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699985</th>\n",
       "      <td>943</td>\n",
       "      <td>1382375</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:04:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7077.0</td>\n",
       "      <td>College Park South</td>\n",
       "      <td>43.659777</td>\n",
       "      <td>-79.382767</td>\n",
       "      <td>7036.0</td>\n",
       "      <td>Trinity St /Front St E</td>\n",
       "      <td>43.651318</td>\n",
       "      <td>-79.360230</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>College Park South TO Trinity St /Front St E</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699986</th>\n",
       "      <td>1159</td>\n",
       "      <td>1382378</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:08:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7057.0</td>\n",
       "      <td>Simcoe St / Wellington St South</td>\n",
       "      <td>43.645857</td>\n",
       "      <td>-79.385365</td>\n",
       "      <td>7023.0</td>\n",
       "      <td>College St / Borden St</td>\n",
       "      <td>43.657100</td>\n",
       "      <td>-79.405600</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Simcoe St / Wellington St South TO College St ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699987</th>\n",
       "      <td>457</td>\n",
       "      <td>1382379</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 18:57:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7057.0</td>\n",
       "      <td>Simcoe St / Wellington St South</td>\n",
       "      <td>43.645857</td>\n",
       "      <td>-79.385365</td>\n",
       "      <td>7123.0</td>\n",
       "      <td>424 Wellington St W</td>\n",
       "      <td>43.643834</td>\n",
       "      <td>-79.396649</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Simcoe St / Wellington St South TO 424 Welling...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699988</th>\n",
       "      <td>370</td>\n",
       "      <td>1382380</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 18:55:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7029.0</td>\n",
       "      <td>Bay St / Bloor St W (East Side)</td>\n",
       "      <td>43.669430</td>\n",
       "      <td>-79.389150</td>\n",
       "      <td>7025.0</td>\n",
       "      <td>Ted Rogers Way / Bloor St E</td>\n",
       "      <td>43.671293</td>\n",
       "      <td>-79.380471</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Bay St / Bloor St W (East Side) TO Ted Rogers ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699989</th>\n",
       "      <td>814</td>\n",
       "      <td>1382381</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:03:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7052.0</td>\n",
       "      <td>Wellington St W / Bay St</td>\n",
       "      <td>43.647259</td>\n",
       "      <td>-79.379878</td>\n",
       "      <td>7007.0</td>\n",
       "      <td>College St / Huron St</td>\n",
       "      <td>43.658148</td>\n",
       "      <td>-79.398167</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Wellington St W / Bay St TO College St / Huron St</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699990</th>\n",
       "      <td>639</td>\n",
       "      <td>1382382</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:00:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7169.0</td>\n",
       "      <td>Front St W / Bay St (North Side)</td>\n",
       "      <td>43.646162</td>\n",
       "      <td>-79.378912</td>\n",
       "      <td>7203.0</td>\n",
       "      <td>Bathurst St/Queens Quay(Billy Bishop Airport)</td>\n",
       "      <td>43.635492</td>\n",
       "      <td>-79.398253</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Front St W / Bay St (North Side) TO Bathurst S...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699991</th>\n",
       "      <td>340</td>\n",
       "      <td>1382383</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 18:55:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7204.0</td>\n",
       "      <td>College St / Crawford St</td>\n",
       "      <td>43.655000</td>\n",
       "      <td>-79.418889</td>\n",
       "      <td>7205.0</td>\n",
       "      <td>Rusholme Park Cres / College St</td>\n",
       "      <td>43.652778</td>\n",
       "      <td>-79.429722</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>College St / Crawford St TO Rusholme Park Cres...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699992</th>\n",
       "      <td>182</td>\n",
       "      <td>1382385</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 18:52:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7199.0</td>\n",
       "      <td>College St / Markham St</td>\n",
       "      <td>43.656389</td>\n",
       "      <td>-79.409167</td>\n",
       "      <td>7208.0</td>\n",
       "      <td>80 Clinton St (North of College)</td>\n",
       "      <td>43.656296</td>\n",
       "      <td>-79.414663</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>College St / Markham St TO 80 Clinton St (Nort...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699993</th>\n",
       "      <td>1207</td>\n",
       "      <td>1382386</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:09:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7069.0</td>\n",
       "      <td>Queen St W / Spadina Ave</td>\n",
       "      <td>43.649147</td>\n",
       "      <td>-79.395504</td>\n",
       "      <td>7065.0</td>\n",
       "      <td>Dundas St E / Parliament St</td>\n",
       "      <td>43.659575</td>\n",
       "      <td>-79.365769</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Queen St W / Spadina Ave TO Dundas St E / Parl...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699994</th>\n",
       "      <td>1239</td>\n",
       "      <td>1382387</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:10:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7069.0</td>\n",
       "      <td>Queen St W / Spadina Ave</td>\n",
       "      <td>43.649147</td>\n",
       "      <td>-79.395504</td>\n",
       "      <td>7065.0</td>\n",
       "      <td>Dundas St E / Parliament St</td>\n",
       "      <td>43.659575</td>\n",
       "      <td>-79.365769</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Queen St W / Spadina Ave TO Dundas St E / Parl...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699995</th>\n",
       "      <td>731</td>\n",
       "      <td>1382388</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:01:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7068.0</td>\n",
       "      <td>Dockside Dr / Queens Quay E (Sugar Beach)</td>\n",
       "      <td>43.644607</td>\n",
       "      <td>-79.366295</td>\n",
       "      <td>7018.0</td>\n",
       "      <td>Bremner Blvd / Rees St</td>\n",
       "      <td>43.641529</td>\n",
       "      <td>-79.386741</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Dockside Dr / Queens Quay E (Sugar Beach) TO B...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699996</th>\n",
       "      <td>1147</td>\n",
       "      <td>1382389</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:08:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7133.0</td>\n",
       "      <td>Summerhill Station</td>\n",
       "      <td>43.681944</td>\n",
       "      <td>-79.390556</td>\n",
       "      <td>7091.0</td>\n",
       "      <td>Donlands Station</td>\n",
       "      <td>43.681126</td>\n",
       "      <td>-79.337779</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Summerhill Station TO Donlands Station</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699997</th>\n",
       "      <td>762</td>\n",
       "      <td>1382390</td>\n",
       "      <td>2017-07-18 18:49:00</td>\n",
       "      <td>2017-07-18 19:02:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7025.0</td>\n",
       "      <td>Ted Rogers Way / Bloor St E</td>\n",
       "      <td>43.671293</td>\n",
       "      <td>-79.380471</td>\n",
       "      <td>7093.0</td>\n",
       "      <td>Danforth Ave / Gough Ave</td>\n",
       "      <td>43.678401</td>\n",
       "      <td>-79.346289</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Ted Rogers Way / Bloor St E TO Danforth Ave / ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699998</th>\n",
       "      <td>761</td>\n",
       "      <td>1382393</td>\n",
       "      <td>2017-07-18 18:50:00</td>\n",
       "      <td>2017-07-18 19:02:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7038.0</td>\n",
       "      <td>Dundas St W / Yonge St</td>\n",
       "      <td>43.656094</td>\n",
       "      <td>-79.381484</td>\n",
       "      <td>7070.0</td>\n",
       "      <td>25 York St 鈥� Union Station South</td>\n",
       "      <td>43.643667</td>\n",
       "      <td>-79.380414</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Dundas St W / Yonge St TO 25 York St 鈥� Union ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699999</th>\n",
       "      <td>347</td>\n",
       "      <td>1382394</td>\n",
       "      <td>2017-07-18 18:50:00</td>\n",
       "      <td>2017-07-18 18:55:00</td>\n",
       "      <td>Casual</td>\n",
       "      <td>7029.0</td>\n",
       "      <td>Bay St / Bloor St W (East Side)</td>\n",
       "      <td>43.669430</td>\n",
       "      <td>-79.389150</td>\n",
       "      <td>7025.0</td>\n",
       "      <td>Ted Rogers Way / Bloor St E</td>\n",
       "      <td>43.671293</td>\n",
       "      <td>-79.380471</td>\n",
       "      <td>2017-07-18</td>\n",
       "      <td>22.895833</td>\n",
       "      <td>Tue</td>\n",
       "      <td>7</td>\n",
       "      <td>Bay St / Bloor St W (East Side) TO Ted Rogers ...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>700000 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        trip_duration_seconds  trip_id      trip_start_time  \\\n",
       "0                         223   712382  2017-01-01 00:00:00   \n",
       "1                         279   712383  2017-01-01 00:00:00   \n",
       "2                        1394   712384  2017-01-01 00:05:00   \n",
       "3                         826   712385  2017-01-01 00:07:00   \n",
       "4                         279   712386  2017-01-01 00:08:00   \n",
       "5                         571   712387  2017-01-01 00:12:00   \n",
       "6                        1084   712388  2017-01-01 00:15:00   \n",
       "7                         307   712389  2017-01-01 00:15:00   \n",
       "8                         647   712390  2017-01-01 00:20:00   \n",
       "9                         217   712391  2017-01-01 00:23:00   \n",
       "10                        467   712392  2017-01-01 00:28:00   \n",
       "11                        880   712393  2017-01-01 00:28:00   \n",
       "12                        228   712394  2017-01-01 00:31:00   \n",
       "13                        361   712395  2017-01-01 00:33:00   \n",
       "14                        227   712396  2017-01-01 00:38:00   \n",
       "15                        354   712397  2017-01-01 00:53:00   \n",
       "16                        591   712398  2017-01-01 00:55:00   \n",
       "17                        169   712399  2017-01-01 00:59:00   \n",
       "18                        451   712400  2017-01-01 00:59:00   \n",
       "19                        920   712401  2017-01-01 01:02:00   \n",
       "20                        256   712402  2017-01-01 01:07:00   \n",
       "21                        398   712403  2017-01-01 01:12:00   \n",
       "22                        982   712404  2017-01-01 01:14:00   \n",
       "23                        261   712405  2017-01-01 01:29:00   \n",
       "24                        182   712406  2017-01-01 01:31:00   \n",
       "25                        780   712407  2017-01-01 01:31:00   \n",
       "26                       1183   712408  2017-01-01 01:32:00   \n",
       "27                        474   712409  2017-01-01 01:32:00   \n",
       "28                        473   712410  2017-01-01 01:40:00   \n",
       "29                        999   712411  2017-01-01 01:43:00   \n",
       "...                       ...      ...                  ...   \n",
       "699970                    637  1382359  2017-07-18 18:48:00   \n",
       "699971                    375  1382360  2017-07-18 18:48:00   \n",
       "699972                   1184  1382361  2017-07-18 18:48:00   \n",
       "699973                    459  1382363  2017-07-18 18:48:00   \n",
       "699974                    808  1382364  2017-07-18 18:48:00   \n",
       "699975                    272  1382365  2017-07-18 18:48:00   \n",
       "699976                     84  1382366  2017-07-18 18:48:00   \n",
       "699977                    362  1382367  2017-07-18 18:48:00   \n",
       "699978                    241  1382368  2017-07-18 18:48:00   \n",
       "699979                    440  1382369  2017-07-18 18:49:00   \n",
       "699980                    774  1382370  2017-07-18 18:49:00   \n",
       "699981                    328  1382371  2017-07-18 18:49:00   \n",
       "699982                   1148  1382372  2017-07-18 18:49:00   \n",
       "699983                   1095  1382373  2017-07-18 18:49:00   \n",
       "699984                    951  1382374  2017-07-18 18:49:00   \n",
       "699985                    943  1382375  2017-07-18 18:49:00   \n",
       "699986                   1159  1382378  2017-07-18 18:49:00   \n",
       "699987                    457  1382379  2017-07-18 18:49:00   \n",
       "699988                    370  1382380  2017-07-18 18:49:00   \n",
       "699989                    814  1382381  2017-07-18 18:49:00   \n",
       "699990                    639  1382382  2017-07-18 18:49:00   \n",
       "699991                    340  1382383  2017-07-18 18:49:00   \n",
       "699992                    182  1382385  2017-07-18 18:49:00   \n",
       "699993                   1207  1382386  2017-07-18 18:49:00   \n",
       "699994                   1239  1382387  2017-07-18 18:49:00   \n",
       "699995                    731  1382388  2017-07-18 18:49:00   \n",
       "699996                   1147  1382389  2017-07-18 18:49:00   \n",
       "699997                    762  1382390  2017-07-18 18:49:00   \n",
       "699998                    761  1382393  2017-07-18 18:50:00   \n",
       "699999                    347  1382394  2017-07-18 18:50:00   \n",
       "\n",
       "             trip_stop_time user_type  from_station_id_corr  \\\n",
       "0       2017-01-01 00:03:00    Member                7051.0   \n",
       "1       2017-01-01 00:05:00    Member                7143.0   \n",
       "2       2017-01-01 00:29:00    Member                7113.0   \n",
       "3       2017-01-01 00:21:00    Member                7077.0   \n",
       "4       2017-01-01 00:12:00    Member                7079.0   \n",
       "5       2017-01-01 00:22:00    Member                7021.0   \n",
       "6       2017-01-01 00:33:00    Member                7161.0   \n",
       "7       2017-01-01 00:21:00    Member                7195.0   \n",
       "8       2017-01-01 00:31:00    Member                7017.0   \n",
       "9       2017-01-01 00:27:00    Member                7017.0   \n",
       "10      2017-01-01 00:36:00    Member                7009.0   \n",
       "11      2017-01-01 00:43:00    Member                7032.0   \n",
       "12      2017-01-01 00:35:00    Member                7177.0   \n",
       "13      2017-01-01 00:39:00    Member                7045.0   \n",
       "14      2017-01-01 00:42:00    Member                7158.0   \n",
       "15      2017-01-01 00:59:00    Member                7022.0   \n",
       "16      2017-01-01 01:05:00    Member                7077.0   \n",
       "17      2017-01-01 01:02:00    Member                7028.0   \n",
       "18      2017-01-01 01:07:00    Member                7038.0   \n",
       "19      2017-01-01 01:17:00    Member                7130.0   \n",
       "20      2017-01-01 01:11:00    Member                7042.0   \n",
       "21      2017-01-01 01:19:00    Member                7160.0   \n",
       "22      2017-01-01 01:30:00    Member                7004.0   \n",
       "23      2017-01-01 01:33:00    Member                7163.0   \n",
       "24      2017-01-01 01:34:00    Member                7164.0   \n",
       "25      2017-01-01 01:44:00    Member                7050.0   \n",
       "26      2017-01-01 01:51:00    Member                7133.0   \n",
       "27      2017-01-01 01:40:00    Casual                7192.0   \n",
       "28      2017-01-01 01:48:00    Member                7070.0   \n",
       "29      2017-01-01 02:00:00    Member                7059.0   \n",
       "...                     ...       ...                   ...   \n",
       "699970  2017-07-18 18:58:00    Member                7032.0   \n",
       "699971  2017-07-18 18:54:00    Member                7108.0   \n",
       "699972  2017-07-18 19:08:00    Member                7043.0   \n",
       "699973  2017-07-18 18:56:00    Member                7033.0   \n",
       "699974  2017-07-18 19:02:00    Member                7107.0   \n",
       "699975  2017-07-18 18:53:00    Member                7077.0   \n",
       "699976  2017-07-18 18:50:00    Member                7123.0   \n",
       "699977  2017-07-18 18:54:00    Member                7041.0   \n",
       "699978  2017-07-18 18:52:00    Member                7189.0   \n",
       "699979  2017-07-18 18:56:00    Casual                7002.0   \n",
       "699980  2017-07-18 19:01:00    Casual                7068.0   \n",
       "699981  2017-07-18 18:54:00    Casual                7169.0   \n",
       "699982  2017-07-18 19:08:00    Member                   NaN   \n",
       "699983  2017-07-18 19:07:00    Member                7011.0   \n",
       "699984  2017-07-18 19:05:00    Casual                7077.0   \n",
       "699985  2017-07-18 19:04:00    Member                7077.0   \n",
       "699986  2017-07-18 19:08:00    Member                7057.0   \n",
       "699987  2017-07-18 18:57:00    Member                7057.0   \n",
       "699988  2017-07-18 18:55:00    Casual                7029.0   \n",
       "699989  2017-07-18 19:03:00    Member                7052.0   \n",
       "699990  2017-07-18 19:00:00    Member                7169.0   \n",
       "699991  2017-07-18 18:55:00    Member                7204.0   \n",
       "699992  2017-07-18 18:52:00    Casual                7199.0   \n",
       "699993  2017-07-18 19:09:00    Member                7069.0   \n",
       "699994  2017-07-18 19:10:00    Member                7069.0   \n",
       "699995  2017-07-18 19:01:00    Casual                7068.0   \n",
       "699996  2017-07-18 19:08:00    Member                7133.0   \n",
       "699997  2017-07-18 19:02:00    Member                7025.0   \n",
       "699998  2017-07-18 19:02:00    Member                7038.0   \n",
       "699999  2017-07-18 18:55:00    Casual                7029.0   \n",
       "\n",
       "                           from_station_name_corr   from_lat   from_lon  \\\n",
       "0             Wellesley St E / Yonge St (Green P)  43.665060 -79.383570   \n",
       "1                        Kendal Ave / Bernard Ave  43.671513 -79.408317   \n",
       "2                    Parliament St / Aberdeen Ave  43.665278 -79.368333   \n",
       "3                              College Park South  43.659777 -79.382767   \n",
       "4                           McGill St / Church St  43.660694 -79.379052   \n",
       "5                              Bay St / Albert St  43.653264 -79.382458   \n",
       "6                        Beverley St / College St  43.657500 -79.395278   \n",
       "7                         Ulster St / Bathurst St  43.660000 -79.408889   \n",
       "8                       Widmer St / Adelaide St W  43.647508 -79.391484   \n",
       "9                       Widmer St / Adelaide St W  43.647508 -79.391484   \n",
       "10                          King St E / Jarvis St  43.650325 -79.372287   \n",
       "11                      Augusta Ave / Dundas St W  43.652473 -79.401456   \n",
       "12                East Liberty St / Pirandello St  43.638611 -79.414722   \n",
       "13                           Bond St / Queen St E  43.653236 -79.376716   \n",
       "14                        King St W / Stafford St  43.642222 -79.411111   \n",
       "15                         Simcoe St / Queen St W  43.650858 -79.387582   \n",
       "16                             College Park South  43.659777 -79.382767   \n",
       "17                           Gould St / Mutual St  43.658200 -79.376800   \n",
       "18                         Dundas St W / Yonge St  43.656094 -79.381484   \n",
       "19                      Davenport Rd / Bedford Rd  43.674398 -79.398660   \n",
       "20                 Sherbourne St / Wellesley St E  43.667300 -79.374000   \n",
       "21                       King St W / Tecumseth St  43.643333 -79.405556   \n",
       "22                        University Ave / Elm St  43.656518 -79.389099   \n",
       "23                             Yonge St / Wood St  43.662222 -79.382500   \n",
       "24       Gould St / Yonge St (Ryerson University)  43.657424 -79.381019   \n",
       "25              Richmond St E / Jarvis St Green P  43.652634 -79.374222   \n",
       "26                             Summerhill Station  43.681944 -79.390556   \n",
       "27                        Harbord St / Clinton St  43.660414 -79.415646   \n",
       "28              25 York St 鈥� Union Station South  43.643667 -79.380414   \n",
       "29                     Front St W / Blue Jays Way  43.643473 -79.390477   \n",
       "...                                           ...        ...        ...   \n",
       "699970                  Augusta Ave / Dundas St W  43.652473 -79.401456   \n",
       "699971                     Front St E / Cherry St  43.652686 -79.358395   \n",
       "699972            Queens Quay W / Lower Simcoe St  43.639510 -79.383717   \n",
       "699973                              Union Station  43.645609 -79.380386   \n",
       "699974                  Cherry St / Distillery Ln  43.650279 -79.356832   \n",
       "699975                         College Park South  43.659777 -79.382767   \n",
       "699976                        424 Wellington St W  43.643834 -79.396649   \n",
       "699977                       Edward St / Yonge St  43.656729 -79.382736   \n",
       "699978                   Augusta Ave / Denison Sq  43.653766 -79.401676   \n",
       "699979                 St. George St / Bloor St W  43.667333 -79.399429   \n",
       "699980  Dockside Dr / Queens Quay E (Sugar Beach)  43.644607 -79.366295   \n",
       "699981           Front St W / Bay St (North Side)  43.646162 -79.378912   \n",
       "699982                                        NaN        NaN        NaN   \n",
       "699983              Wellington St W / Portland St  43.642982 -79.399256   \n",
       "699984                         College Park South  43.659777 -79.382767   \n",
       "699985                         College Park South  43.659777 -79.382767   \n",
       "699986            Simcoe St / Wellington St South  43.645857 -79.385365   \n",
       "699987            Simcoe St / Wellington St South  43.645857 -79.385365   \n",
       "699988            Bay St / Bloor St W (East Side)  43.669430 -79.389150   \n",
       "699989                   Wellington St W / Bay St  43.647259 -79.379878   \n",
       "699990           Front St W / Bay St (North Side)  43.646162 -79.378912   \n",
       "699991                   College St / Crawford St  43.655000 -79.418889   \n",
       "699992                    College St / Markham St  43.656389 -79.409167   \n",
       "699993                   Queen St W / Spadina Ave  43.649147 -79.395504   \n",
       "699994                   Queen St W / Spadina Ave  43.649147 -79.395504   \n",
       "699995  Dockside Dr / Queens Quay E (Sugar Beach)  43.644607 -79.366295   \n",
       "699996                         Summerhill Station  43.681944 -79.390556   \n",
       "699997                Ted Rogers Way / Bloor St E  43.671293 -79.380471   \n",
       "699998                     Dundas St W / Yonge St  43.656094 -79.381484   \n",
       "699999            Bay St / Bloor St W (East Side)  43.669430 -79.389150   \n",
       "\n",
       "        to_station_id_corr                           to_station_name_corr  \\\n",
       "0                   7089.0                           Church St  / Wood St   \n",
       "1                   7154.0                        Bathurst Subway Station   \n",
       "2                   7199.0                        College St / Markham St   \n",
       "3                   7010.0                        King St W / Spadina Ave   \n",
       "4                   7047.0                  University Ave / Gerrard St W   \n",
       "5                   7046.0                     Niagara St / Richmond St W   \n",
       "6                   7176.0                   Bathurst St / Fort York Blvd   \n",
       "7                   7037.0                      Bathurst St / Dundas St W   \n",
       "8                   7101.0            Lower Sherbourne St / The Esplanade   \n",
       "9                   7005.0                            King St W / York St   \n",
       "10                  7016.0        Bay St / Queens Quay W (Ferry Terminal)   \n",
       "11                  7070.0              25 York St 鈥� Union Station South   \n",
       "12                  7158.0                        King St W / Stafford St   \n",
       "13                  7060.0                    Princess St / Adelaide St E   \n",
       "14                  7177.0                East Liberty St / Pirandello St   \n",
       "15                  7033.0                                  Union Station   \n",
       "16                  7101.0            Lower Sherbourne St / The Esplanade   \n",
       "17                  7164.0       Gould St / Yonge St (Ryerson University)   \n",
       "18                  7065.0                    Dundas St E / Parliament St   \n",
       "19                  7038.0                         Dundas St W / Yonge St   \n",
       "20                  7031.0                        Jarvis St / Isabella St   \n",
       "21                  7054.0                 Navy Wharf Ct. / Bremner Blvd.   \n",
       "22                  7164.0       Gould St / Yonge St (Ryerson University)   \n",
       "23                  7041.0                           Edward St / Yonge St   \n",
       "24                  7045.0                           Bond St / Queen St E   \n",
       "25                  7043.0                Queens Quay W / Lower Simcoe St   \n",
       "26                  7049.0                       Queen St W / Portland St   \n",
       "27                  7205.0                Rusholme Park Cres / College St   \n",
       "28                  7000.0                   Fort York  Blvd / Capreol Ct   \n",
       "29                  7208.0               80 Clinton St (North of College)   \n",
       "...                    ...                                            ...   \n",
       "699970              7038.0                         Dundas St W / Yonge St   \n",
       "699971              7109.0                        Seaton St / Dundas St E   \n",
       "699972              7002.0                     St. George St / Bloor St W   \n",
       "699973              7073.0                   Spadina Ave / Fort York Blvd   \n",
       "699974              7009.0                          King St E / Jarvis St   \n",
       "699975              7024.0                       Dundonald St / Church St   \n",
       "699976              7011.0                  Wellington St W / Portland St   \n",
       "699977              7102.0                          Nelson St / Duncan St   \n",
       "699978              7049.0                       Queen St W / Portland St   \n",
       "699979              7040.0                        Euclid Ave / Bloor St W   \n",
       "699980              7018.0                         Bremner Blvd / Rees St   \n",
       "699981              7059.0                     Front St W / Blue Jays Way   \n",
       "699982              7189.0                       Augusta Ave / Denison Sq   \n",
       "699983              7056.0                     Parliament St / Gerrard St   \n",
       "699984              7036.0                         Trinity St /Front St E   \n",
       "699985              7036.0                         Trinity St /Front St E   \n",
       "699986              7023.0                         College St / Borden St   \n",
       "699987              7123.0                            424 Wellington St W   \n",
       "699988              7025.0                    Ted Rogers Way / Bloor St E   \n",
       "699989              7007.0                          College St / Huron St   \n",
       "699990              7203.0  Bathurst St/Queens Quay(Billy Bishop Airport)   \n",
       "699991              7205.0                Rusholme Park Cres / College St   \n",
       "699992              7208.0               80 Clinton St (North of College)   \n",
       "699993              7065.0                    Dundas St E / Parliament St   \n",
       "699994              7065.0                    Dundas St E / Parliament St   \n",
       "699995              7018.0                         Bremner Blvd / Rees St   \n",
       "699996              7091.0                               Donlands Station   \n",
       "699997              7093.0                       Danforth Ave / Gough Ave   \n",
       "699998              7070.0              25 York St 鈥� Union Station South   \n",
       "699999              7025.0                    Ted Rogers Way / Bloor St E   \n",
       "\n",
       "           to_lat     to_lon trip_start_date  Temp (°C) work_day  month  \\\n",
       "0       43.662712 -79.379903      2017-01-01   1.287500      Sun      1   \n",
       "1       43.666667 -79.411667      2017-01-01   1.287500      Sun      1   \n",
       "2       43.656389 -79.409167      2017-01-01   1.287500      Sun      1   \n",
       "3       43.645323 -79.395003      2017-01-01   1.287500      Sun      1   \n",
       "4       43.657763 -79.389165      2017-01-01   1.287500      Sun      1   \n",
       "5       43.645340 -79.409597      2017-01-01   1.287500      Sun      1   \n",
       "6       43.639179 -79.399595      2017-01-01   1.287500      Sun      1   \n",
       "7       43.652300 -79.405800      2017-01-01   1.287500      Sun      1   \n",
       "8       43.648655 -79.367061      2017-01-01   1.287500      Sun      1   \n",
       "9       43.648001 -79.383177      2017-01-01   1.287500      Sun      1   \n",
       "10      43.640823 -79.376265      2017-01-01   1.287500      Sun      1   \n",
       "11      43.643667 -79.380414      2017-01-01   1.287500      Sun      1   \n",
       "12      43.642222 -79.411111      2017-01-01   1.287500      Sun      1   \n",
       "13      43.652123 -79.367139      2017-01-01   1.287500      Sun      1   \n",
       "14      43.638611 -79.414722      2017-01-01   1.287500      Sun      1   \n",
       "15      43.645609 -79.380386      2017-01-01   1.287500      Sun      1   \n",
       "16      43.648655 -79.367061      2017-01-01   1.287500      Sun      1   \n",
       "17      43.657424 -79.381019      2017-01-01   1.287500      Sun      1   \n",
       "18      43.659575 -79.365769      2017-01-01   1.287500      Sun      1   \n",
       "19      43.656094 -79.381484      2017-01-01   1.287500      Sun      1   \n",
       "20      43.668991 -79.379385      2017-01-01   1.287500      Sun      1   \n",
       "21      43.640722 -79.391051      2017-01-01   1.287500      Sun      1   \n",
       "22      43.657424 -79.381019      2017-01-01   1.287500      Sun      1   \n",
       "23      43.656729 -79.382736      2017-01-01   1.287500      Sun      1   \n",
       "24      43.653236 -79.376716      2017-01-01   1.287500      Sun      1   \n",
       "25      43.639510 -79.383717      2017-01-01   1.287500      Sun      1   \n",
       "26      43.647600 -79.401500      2017-01-01   1.287500      Sun      1   \n",
       "27      43.652778 -79.429722      2017-01-01   1.287500      Sun      1   \n",
       "28      43.639832 -79.395954      2017-01-01   1.287500      Sun      1   \n",
       "29      43.656296 -79.414663      2017-01-01   1.287500      Sun      1   \n",
       "...           ...        ...             ...        ...      ...    ...   \n",
       "699970  43.656094 -79.381484      2017-07-18  22.895833      Tue      7   \n",
       "699971  43.658777 -79.369596      2017-07-18  22.895833      Tue      7   \n",
       "699972  43.667333 -79.399429      2017-07-18  22.895833      Tue      7   \n",
       "699973  43.640114 -79.393249      2017-07-18  22.895833      Tue      7   \n",
       "699974  43.650325 -79.372287      2017-07-18  22.895833      Tue      7   \n",
       "699975  43.666630 -79.381480      2017-07-18  22.895833      Tue      7   \n",
       "699976  43.642982 -79.399256      2017-07-18  22.895833      Tue      7   \n",
       "699977  43.648711 -79.389728      2017-07-18  22.895833      Tue      7   \n",
       "699978  43.647600 -79.401500      2017-07-18  22.895833      Tue      7   \n",
       "699979  43.664467 -79.414783      2017-07-18  22.895833      Tue      7   \n",
       "699980  43.641529 -79.386741      2017-07-18  22.895833      Tue      7   \n",
       "699981  43.643473 -79.390477      2017-07-18  22.895833      Tue      7   \n",
       "699982  43.653766 -79.401676      2017-07-18  22.895833      Tue      7   \n",
       "699983  43.662132 -79.365680      2017-07-18  22.895833      Tue      7   \n",
       "699984  43.651318 -79.360230      2017-07-18  22.895833      Tue      7   \n",
       "699985  43.651318 -79.360230      2017-07-18  22.895833      Tue      7   \n",
       "699986  43.657100 -79.405600      2017-07-18  22.895833      Tue      7   \n",
       "699987  43.643834 -79.396649      2017-07-18  22.895833      Tue      7   \n",
       "699988  43.671293 -79.380471      2017-07-18  22.895833      Tue      7   \n",
       "699989  43.658148 -79.398167      2017-07-18  22.895833      Tue      7   \n",
       "699990  43.635492 -79.398253      2017-07-18  22.895833      Tue      7   \n",
       "699991  43.652778 -79.429722      2017-07-18  22.895833      Tue      7   \n",
       "699992  43.656296 -79.414663      2017-07-18  22.895833      Tue      7   \n",
       "699993  43.659575 -79.365769      2017-07-18  22.895833      Tue      7   \n",
       "699994  43.659575 -79.365769      2017-07-18  22.895833      Tue      7   \n",
       "699995  43.641529 -79.386741      2017-07-18  22.895833      Tue      7   \n",
       "699996  43.681126 -79.337779      2017-07-18  22.895833      Tue      7   \n",
       "699997  43.678401 -79.346289      2017-07-18  22.895833      Tue      7   \n",
       "699998  43.643667 -79.380414      2017-07-18  22.895833      Tue      7   \n",
       "699999  43.671293 -79.380471      2017-07-18  22.895833      Tue      7   \n",
       "\n",
       "                                            TripItinerary  Sightseeing  \n",
       "0       Wellesley St E / Yonge St (Green P) TO Church ...        False  \n",
       "1       Kendal Ave / Bernard Ave TO Bathurst Subway St...        False  \n",
       "2       Parliament St / Aberdeen Ave TO College St / M...        False  \n",
       "3           College Park South TO King St W / Spadina Ave        False  \n",
       "4       McGill St / Church St TO University Ave / Gerr...        False  \n",
       "5        Bay St / Albert St TO Niagara St / Richmond St W        False  \n",
       "6       Beverley St / College St TO Bathurst St / Fort...        False  \n",
       "7       Ulster St / Bathurst St TO Bathurst St / Dunda...        False  \n",
       "8       Widmer St / Adelaide St W TO Lower Sherbourne ...        False  \n",
       "9        Widmer St / Adelaide St W TO King St W / York St        False  \n",
       "10      King St E / Jarvis St TO Bay St / Queens Quay ...        False  \n",
       "11      Augusta Ave / Dundas St W TO 25 York St 鈥� Uni...        False  \n",
       "12      East Liberty St / Pirandello St TO King St W /...        False  \n",
       "13      Bond St / Queen St E TO Princess St / Adelaide...        False  \n",
       "14      King St W / Stafford St TO East Liberty St / P...        False  \n",
       "15                Simcoe St / Queen St W TO Union Station        False  \n",
       "16      College Park South TO Lower Sherbourne St / Th...        False  \n",
       "17      Gould St / Mutual St TO Gould St / Yonge St (R...        False  \n",
       "18      Dundas St W / Yonge St TO Dundas St E / Parlia...        False  \n",
       "19      Davenport Rd / Bedford Rd TO Dundas St W / Yon...        False  \n",
       "20      Sherbourne St / Wellesley St E TO Jarvis St / ...        False  \n",
       "21      King St W / Tecumseth St TO Navy Wharf Ct. / B...        False  \n",
       "22      University Ave / Elm St TO Gould St / Yonge St...        False  \n",
       "23             Yonge St / Wood St TO Edward St / Yonge St        False  \n",
       "24      Gould St / Yonge St (Ryerson University) TO Bo...        False  \n",
       "25      Richmond St E / Jarvis St Green P TO Queens Qu...        False  \n",
       "26         Summerhill Station TO Queen St W / Portland St        False  \n",
       "27      Harbord St / Clinton St TO Rusholme Park Cres ...        False  \n",
       "28      25 York St 鈥� Union Station South TO Fort York...        False  \n",
       "29      Front St W / Blue Jays Way TO 80 Clinton St (N...        False  \n",
       "...                                                   ...          ...  \n",
       "699970  Augusta Ave / Dundas St W TO Dundas St W / Yon...        False  \n",
       "699971  Front St E / Cherry St TO Seaton St / Dundas St E        False  \n",
       "699972  Queens Quay W / Lower Simcoe St TO St. George ...        False  \n",
       "699973      Union Station TO Spadina Ave / Fort York Blvd        False  \n",
       "699974  Cherry St / Distillery Ln TO King St E / Jarvi...        False  \n",
       "699975     College Park South TO Dundonald St / Church St        False  \n",
       "699976  424 Wellington St W TO Wellington St W / Portl...        False  \n",
       "699977      Edward St / Yonge St TO Nelson St / Duncan St        False  \n",
       "699978  Augusta Ave / Denison Sq TO Queen St W / Portl...        False  \n",
       "699979  St. George St / Bloor St W TO Euclid Ave / Blo...        False  \n",
       "699980  Dockside Dr / Queens Quay E (Sugar Beach) TO B...        False  \n",
       "699981  Front St W / Bay St (North Side) TO Front St W...        False  \n",
       "699982                                                NaN        False  \n",
       "699983  Wellington St W / Portland St TO Parliament St...        False  \n",
       "699984       College Park South TO Trinity St /Front St E        False  \n",
       "699985       College Park South TO Trinity St /Front St E        False  \n",
       "699986  Simcoe St / Wellington St South TO College St ...        False  \n",
       "699987  Simcoe St / Wellington St South TO 424 Welling...        False  \n",
       "699988  Bay St / Bloor St W (East Side) TO Ted Rogers ...        False  \n",
       "699989  Wellington St W / Bay St TO College St / Huron St        False  \n",
       "699990  Front St W / Bay St (North Side) TO Bathurst S...        False  \n",
       "699991  College St / Crawford St TO Rusholme Park Cres...        False  \n",
       "699992  College St / Markham St TO 80 Clinton St (Nort...        False  \n",
       "699993  Queen St W / Spadina Ave TO Dundas St E / Parl...        False  \n",
       "699994  Queen St W / Spadina Ave TO Dundas St E / Parl...        False  \n",
       "699995  Dockside Dr / Queens Quay E (Sugar Beach) TO B...        False  \n",
       "699996             Summerhill Station TO Donlands Station        False  \n",
       "699997  Ted Rogers Way / Bloor St E TO Danforth Ave / ...        False  \n",
       "699998  Dundas St W / Yonge St TO 25 York St 鈥� Union ...        False  \n",
       "699999  Bay St / Bloor St W (East Side) TO Ted Rogers ...        False  \n",
       "\n",
       "[700000 rows x 19 columns]"
      ]
     },
     "execution_count": 247,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     209.359819\n",
       "1     432.121163\n",
       "2     792.599103\n",
       "3    1288.793367\n",
       "4     261.343113\n",
       "5     706.544807\n",
       "6    1633.595080\n",
       "7     686.571809\n",
       "8     102.308116\n",
       "9      43.976262\n",
       "dtype: float64"
      ]
     },
     "execution_count": 248,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Though we do not have GPS tracking on the bikes, we can estimate the\n",
    "# trip *displacement* in cartesian co-ordinates (X=longitude & Y=latitude)\n",
    "# This, in addition to the trip time parameter, can give us a rough idea\n",
    "# of the speed, route lengths, etc.\n",
    "\n",
    "# Rationale: most of the city is laid out in a grid, so a trip could be\n",
    "# broken down into X and Y components. There will be some errors associated\n",
    "# with non-grid like streets, such as Dundas Street West or Lakeshore Blvd\n",
    "\n",
    "# Conversion into km? Take the lat/lon positions of two known stations, convert those\n",
    "# into km\n",
    "\n",
    "latDelta= abs(bikeDataClean['to_lat'] - bikeDataClean['from_lat'])\n",
    "lonDelta= abs(bikeDataClean['to_lon'] - bikeDataClean['from_lon'])\n",
    "\n",
    "# from quick calculations on a Google map, found:\n",
    "longConv = 109426.2 # meters per degree longitude\n",
    "latConv = 89165.17 # meters per degree latitude\n",
    "\n",
    "latDelta = latDelta*latConv\n",
    "latDelta.head(10)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 249,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     401.265875\n",
       "1     366.541295\n",
       "2    4468.272975\n",
       "3    1338.938983\n",
       "4    1106.627161\n",
       "5    2969.717642\n",
       "6     472.417222\n",
       "7     338.005373\n",
       "8    2672.527025\n",
       "9     909.014386\n",
       "dtype: float64"
      ]
     },
     "execution_count": 249,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lonDelta = lonDelta*longConv\n",
    "lonDelta.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 250,
   "metadata": {},
   "outputs": [],
   "source": [
    "cartesianDisplacement = lonDelta + latDelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 251,
   "metadata": {},
   "outputs": [],
   "source": [
    "bikeDataClean['Cartesian_Displacement'] = cartesianDisplacement"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 252,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 252,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean['Cartesian_Displacement'].isnull().values.any()\n",
    "# replace all the NaNs with 0, as these are the \"sight-seeing\" 0 displacement trips\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 253,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          610.625695\n",
       "1          798.662458\n",
       "2         5260.872079\n",
       "3         2627.732350\n",
       "4         1367.970274\n",
       "5         3676.262449\n",
       "6         2106.012302\n",
       "7         1024.577182\n",
       "8         2774.835141\n",
       "9          952.990648\n",
       "10        1282.544869\n",
       "11        3087.734587\n",
       "12         717.133521\n",
       "13        1147.215552\n",
       "14         717.133521\n",
       "15        1255.458913\n",
       "16        2710.342918\n",
       "17         530.861310\n",
       "18        2030.016690\n",
       "19        3511.639208\n",
       "20         740.038389\n",
       "21        1820.018378\n",
       "22         964.947340\n",
       "23         515.626695\n",
       "24         844.284671\n",
       "25        2209.205460\n",
       "26        4259.848931\n",
       "27        2221.192119\n",
       "28        2042.431575\n",
       "29        3789.947048\n",
       "             ...     \n",
       "699970    2508.327147\n",
       "699971    1768.787917\n",
       "699972    4200.146979\n",
       "699973    1897.511820\n",
       "699974    1695.283519\n",
       "699975     751.880429\n",
       "699976     361.242828\n",
       "699977    1480.034323\n",
       "699978     569.040507\n",
       "699979    1935.677252\n",
       "699980    2511.778478\n",
       "699981    1505.279145\n",
       "699982       0.000000\n",
       "699983    5381.650867\n",
       "699984    3220.386442\n",
       "699985    3220.386442\n",
       "699986    3216.688309\n",
       "699987    1415.093693\n",
       "699988    1115.824702\n",
       "699989    2972.215308\n",
       "699990    3067.804498\n",
       "699991    1383.582722\n",
       "699992     609.725324\n",
       "699993    4183.602450\n",
       "699994    4183.602450\n",
       "699995    2511.778478\n",
       "699996    5848.123666\n",
       "699997    4374.192397\n",
       "699998    1225.141602\n",
       "699999    1115.824702\n",
       "Name: Cartesian_Displacement, Length: 700000, dtype: float64"
      ]
     },
     "execution_count": 253,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean['Cartesian_Displacement'].fillna(0)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 254,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.collections.PathCollection at 0x1a4698ec588>"
      ]
     },
     "execution_count": 254,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYwAAAD4CAYAAAD//dEpAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjAsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+17YcXAAAgAElEQVR4nO2dfZAc9Xnnv8+MRjArbEYC2SctWlYoRJSJLAl0SERJypAL4iWGNVjGHMSc4zN1V3YqgG/jJaGMwHJQsontI3E5Zcqc4SAgwHgtLBzBGXy5Ikgg2BWyAorEm6SRDArSylgaSbO7z/3R3auenn6f7nn9fqq2ZvY3/fL0r2d+T/9+z5uoKgghhJAgMo0WgBBCSGtAhUEIISQUVBiEEEJCQYVBCCEkFFQYhBBCQjGl0QLE5fTTT9fe3t5Gi0EIIS3Fyy+//O+qOjPOvi2rMHp7e7F58+ZGi0EIIS2FiLwTd18uSRFCCAkFFQYhhJBQUGEQQggJBRUGIYSQUFBhEEIICUXLekmR5mRouIjBDduxd7SE2YU8+lfMR9/i7kaLRQhJACoMkhhDw0Xc9sRWlMrjAIDiaAm3PbEVAKg0CGkDuCRFEmNww/ZJZWFRKo9jcMP2BklECEkSKgySGHtHS5HaCSGtBRUGSYzZhXykdkJIa0GFQRKjf8V85HPZirZ8Lov+FfMbJBEhJElo9CaJYRm20/aSiuKJRa8tQpKDCoMkSt/i7lQH5CieWPTaIiRZuCRFWooonlj02iIkWagwSEsRxROLXluEJAsVBmkponhi0WuLkGShwiAtRRRPLHptEZIsNHqTliKKJ1a9vLYI6RREVRstQyyWLFmiLNFKCCHREJGXVXVJnH25JEUIISQUVBiEEEJCQYVBCCEkFFQYhBBCQkGFQQghJBRUGIQQQkLR8XEYQ8NF9D82gvKE9zaFfA6rrjw30H8/KDPq7UNb8fCm3RhXRVYE1y2dg9V9Czz3BYBV67ZhtFSePMb0rhzu+GSwLEEYifleRclx4YV8DiLA6JFy1TX4XR+zwtafVu3zVpWbdHgcxtBwETevHQm1bS4jGFy50DeNtj0zKmBEFd999QL0Le7G7UNb8eDGXVX73bCsB0vOnFG1by4rGB9XuOmxXFYw+GlvWYIYGi7i1rUjrsd2Yl0DAM/r8/uMA0E6BH3fmpVWlbudYBxGTKJkLS1PqO/2QZlRH96023W/hzftdt237KEsrM9qybg6uGF7KGUBnLgGv+tjVtj606p93qpyE4OOXpKKmrXUb/ugzKjjHjO5cdVY2VNrybhaj+uOcx4SnlbNxNuqchODjp5hRM1a6rd9UGbUrIjr51mRWNlTa8m4Gue6/a6PWWHrT6v2eavKTQw6WmFEyVqaAXDk+BjmDqzH8jXPYmi4WHUsv8yo1y2d43rc65bOcd03lxXPm5PLSk0ZV/tXzA99461r8Lu+MFlhh4aLWL7mWc/+C0tSx2l1WjUTb6vKTQw6eknKMrIFeUnlcxmMTSgOHjG8ldxKfQZlRl1y5gz846ZdmLCtTGXEaPfaF0jHS8raN6qXlN/1+X2WVKlUllw9Qatm4m1VuYlBR3tJhWX5mmdRdFlj7S7k8fzAxXU7RquS1LV3ch8SkhT0kkqZJAx1nWzsS+raO7kPCWkGqDBCkIShrpONfUldeyf3ISHNABVGCJIw1HWysS+pa+/kPiSkGQhUGCIyR0SeE5HXRGSbiPyp2T5DRJ4RkR3m63SzXUTkHhHZKSKvish5tmPdaG6/Q0RutLWfLyJbzX3uEfHwQW0QfYu7cffVC9BdyENgrJlHjUxN4hitSlLX3sl9SEgzEGj0FpFZAGap6isi8iEALwPoA/BfABxQ1TUiMgBguqp+VUQuB/AnAC4HsBTA/1TVpSIyA8BmAEsAqHmc81X1oIi8COBPAWwE8BSAe1T1p35ysUQrIYREpxajd6BbraruA7DPfP+BiLwGoBvAVQA+YW52P4CfA/iq2f6AGppoo4gUTKXzCQDPqOoBU+hnAFwqIj8H8GFVfcFsfwCGQvJVGK2KPfHaqQ4X1t7T8viXNw8gTce1rAATQMU5um2ujV5JEO1tF50zE8+9vj+UWyQTzRHSPkSKwxCRXgCLAWwC8FFTmUBV94nIR8zNugHYEyftMdv82ve4tLud/yYANwFAT09PFNGbAmccgT2+ojhacnUZTZpxF2VkxTNsfucAfvhysSLOof+xLYAY+ausNnsSRb9YCMZNENJehDZ6i8gpAH4I4GZV/ZXfpi5tGqO9ulH1e6q6RFWXzJw5M0jkpsMt8VqzUCqP4+FNu6uTIE7opLLw29cteRwTzRHSXoRSGCKSg6EsHlLVJ8zmd82lJsvO8Z7ZvgeAPQ/GGQD2BrSf4dLedjR7vIBXgsQwuF0b4yYIaS8Cl6RMj6XvA3hNVb9p+2gdgBsBrDFff2xr/7KIPALD6H3IXLLaAOAvLW8qAJcAuE1VD4jIByKyDMZS1+cA/F0C19Z0zC7k67LsFJesSGylYcVCeBVmsqMArr/3BTz0xQtjnQvwL0ZlyRG32JP1eXG0NNkn3S1of6H9iCRNGC+p3wHw/wBsBSbLKPw5jMH9UQA9AHYBWGkO/gLg7wFcCuAIgM+r6mbzWH9s7gsA31DV/2W2LwHwAwB5GMbuP9EAwRrhJRWmKp5frie34jHNQj6XxTXnd1fYMAAj39VEgA6xF1IKW5gJAJbPmxFLafgVo1rdt8C3SA/gX+zJ7x4lVeinHgN5pxUqonIMTy1eUswlFRK3H6BXVTy/inhOL6ny+AQOH28+BRKFaVOzyGUzFUb8sHQX8r4eWW4//Hm3PeU6E8qK4I27L/fNOQXANx/Vojuf9r0Ov7xVzkGr97Q8Nr55sGIWtOTMGeh/fEuFXajWCoputHPeLWc/X3TOzKoHnXZWjrWSqlstMfCqiueGVRHP7cvat7i7on35mmdx+Lj/MpUAuH5ZT1W222bBUHjxlJ41qHl5ZLl5VfkVowLi2U72jpYwNFwMVHpex3DzCLMP2OOqeHDjLjy2eU/V96Y8rrjzyW2JDm7taj9y6+eHNu6q8pKxnCuoMJKFqUFCkmSVuqjbKYxSrs2oLJLEzSPLzavKrxgV4J9zyu+zMN5bXvuH9YA7Nua+YGelzk+Kds275dbPXj+LVleOzQgVRkiSrM4XZ7taPJhaHecP36sY1cm5DIaGi7GLPQUNMH55q5IYnJIsCNWuebei9HOrK8dmhAojJFGq4kWpiNe/Yj5ymeDUWV5P1Z2A84e/um8BbljWUxXAc/j4+OQSllfOKb98VH4DTFDeqiQGJ2sJLgml0a55t7z62fldaAfl2IzQ6B2BWr2k/I7rrKxnx/JgalYbhhNLXit9yMm5TJWbbS4rgBrLUJNtGamwYVjH8hrokjbs1uJZFNYDbvm8GXjxrYMV1+2kHQzTaeF1j+zfN3pJ+UOjd51wGqzt7X7YFU2hKwdVIy2IW9xDRoALz5qBt98vObxA9jSVsshlgFNOzmH0SHnymg6V3Mu6AtVxE9f+R8NjyB7vUJ5QdJnlcFWNWdU157v3OZCsYde6R6Xy+OR9mW5e1y1rRzC4YbvvIORWetTNS8py+/V7QAgrfye6krLEa2PhDCNl4sZe2GMKosQ2RCWfy2BsXKueeHNZY1Bf++Ju36dhrxlV0KAYFj+X08V3Pe1qLM6K4G8/E95N9fahrVWeNm4zoDiumm4uoD/Zsi+26679uJ0UZ0GSgyVam5i4+aMe3rR7cv+0lAVgeO24KYTyuOKhjbt8lQVgePf0P76lYt19aLiI/se21KwsLDnufHJbVfvQcBG/Pjrmus+4amhbwNBw0dUts+yiRKPmwbIG9eJoCYoTiRuD+uWic4LzpDFPF2kEVBgpE9d7JiimICn89EHYuacVd2IxuGF7oKKJgtssIugcYQfPwQ3bQ18nEO1+xH1YeO71/bHloCspSRMqjJSJ6z0TFFOQFEl5X9kHqnoMWmHOkdQ2dqLcj7j9EGa/do2zIM0NFUbKuLnjhsGKNehfMT+1m5TLGoZYN7feXFYwbWp4ue0DVdKDViGf8z1fGJnibOPsl6iumnH7Icx+7RpnQZobKoyUcfrDT+/KTQ6Abk/3GTlh8Lb2/+a1i5DPnbhVAqNynhPreNZrdyGPG5b1TOZQsp9uelcOg59eiNV9CzC4cmHFoGx99o1PLTCMvwE4407CxpaEIZcRrLry3Kr2IEUcdvB0O47AuAeDKxfWFMcQ52EhrNztGmdBmht6STU5fiVT/dJv291Y7SyfNwMrl/S47u9WehUA7nxym2fqilq9pASGraS7ED75oFvfhHHt9SKue2qYNOhuXlL2Po5S7paQJGC22jbFNUOuS3CbheVWufmdA67pv6PilfI8SjCbMzPr5HWkkKG1ntQjDTohaUCF0aZ4RTL70V3I45eHjiaWe8qrqJIzVsDtKd16+vaTNSjeoJZCSX7bAJUzp0I+hz9cOCvwaT/szMnqtzgFmFo5IC8t2ZOaTRIqjLZl7sD6SC6fwIklnrQRAG+tuQKAdxBZkEup/Rhu1FIoyb4k5DZLmwAwHuD663as/se2xHYZDjPzaOWAvLRkDwp+bZX+aRYYuNemxPGymV3IJ5qo0OtYdtm8gsiC5Ai6Pit40as9TPCaax2TCQ1UFl7HqiW+JExsSCsH5KUle1A8S6v0TztAhdHEuGbIzYin55LlYeOV/jsq+VwW1y2dE+i+6RU3ELQsFuQNlEShpFpjQpKOLwk6RisH5KUlexrxNCQeVBhNjJvr5ODKhRj89MJJV1m7C601LbfSf7s94S+fNwPfvnaR6/6WC67dTXN134JA902vmUJ3IY/pXdUxFIBhMwhaQqilUFKQbGGJeqxaZ1WtHJCXluxJxdyQ2mG22iYnbobc1X0LKozDUfcPI4NF/4r5rmvX1gzC7TO32Aon1y2d42rDsAc1+p3Xa5soNgznsdxsGHaPryDvqaBZVZhralbSkt3tuHZapX/aASoMEtmzxS22wKh5YfygC/kcVl15IjZj8zsHKjyd/FKW27EUnpeXVJhU1/Zt7GnUC/kcyuMTZj1yQ+ZzZ39oMh05ULk2bleadi8pMV2cv/LoFty8dgTdhfxkbQa/+Awv+hZ3x+4vwD9uJ20Po7RSjzuPSy+pxkEvqQ4nqmdLmHTt9v0b4fXjNWi6zTROOXnKZE2PQ0fKrpmBLXmBE4PWqfkcDh8fc40xAaqVZhTZkyzi5Jam3e3aOOB2DnSrJbGJWrUubGyItX/SVfGC8BpwT5qSqSnd+vSuHI6WJyJln40zGNfSX3HidsIem7QPdKslsYnq2RLWG8Xart5eP16unbXW5jh4pBw5VXkcd89a+ivN7LiEALRhdDyzC3nXp1I/j5cwT7HW/lGP74VbxLdV4tVa1z58bAzHPZaIGkVxtISh4WLoWYZff7nlrrLbSApdOc+cX0HnJCQMnGF0OFHTZIfJwGrfP4k03FbEt2WMHlfFgxt34SuPbZmsZnfwSDk1ZVFr5t2w1f8A72p7vaflJ6v3AajoC8BQTL8+OlYVo5PLiq/8nephNDRcxPI1z2LuwHosX/Ns6PvT6XCG0eFE9Wxx294v42oSnjNeEd9horVrRQCccvKUWE/uFtbSlF+OK8vzx2vpzO695YXl/TXtpCme2Y1FAOswXpmGW5Eonn5OO1dxtITbntgKIJq7eSdChUEC4yzqvb2TpBIpxmW0BmVh4bQTOAetIIUUtg8OlcoYueMS18+czgBHy2lWi68fURWAXwoTKgx/uCRFmp4kc2NFZXYhn8gav/MYUet9h+0DL1lbOUdVEFGvrZXTrzQaKgzS9HjlxsomVNXPi1zGqCRYawVBNztBlMHJK6dXmPMEna8dBsmo19bK6VcaDZekSOoEVZ3zWm+275fPZXBsbAITajxtnzWzCzvfO5yYjNOmZqGqOGIu07gF3jnrYFjbbH7nAB7auKsirbyVZl5gPO3evHYEN68dqfg8DCdNyeBYedyzIJZlk7BXLFy+5tnJ4EIR/+Uur0GyETU54p4zqideK6dfaTRUGCRV3NaX7YOf13qzc79SeSLxioKAMYsYXBlc+S/IDuOsSjglY7i7etnlw1pljo352xmmZLzzWIWJPXHzymqEUbiWc0ZVAGmlMOkEApekROQ+EXlPRH5ha1slIkURGTH/Lrd9dpuI7BSR7SKywtZ+qdm2U0QGbO1zRWSTiOwQkbUiMjXJCySNJcxavdt6s9+6tJfXVBzKE5pKvYbyhLeySJLy+An5o9pFAEPROV1KG2HvqOWcblmdgyLs+xZ34/mBi/HWmivw/MDFVBYhCTPD+AGAvwfwgKP9W6r6N/YGEfkYgM8COBfAbAD/R0R+0/z4OwD+AMAeAC+JyDpV/VcAf2Ue6xER+QcAXwDw3ZjXQ5qMqJHhQfvtNeMukqQe9RrSJCiq3g8376BG2DtqPWetnngkHIEzDFX9ZwAHQh7vKgCPqOoxVX0LwE4AF5h/O1X1TVU9DuARAFeJiAC4GMDj5v73A+iLeA2kiQlrSHRu52eYTNprqh71GtLEHlUfB+eg3AijMA3RrUEtNowvi8jnAGwG8BVVPQigG8BG2zZ7zDYA2O1oXwrgNACjqjrmsj1pA4JqGQDu681+69J+NowM4Jpx1o/Dx8aq0neEMcDaU3U4a6nHkSMuxdESFt/1NK74+KwqW0oYMiIV1997mrsR2SsK3cKrz4JSrluOEGtf3F2RVTcD4MjxMfQOrA+dJr7WVP20ZfgTKlutiPQC+Imq/pb5/0cB/DuM38jXAcxS1T8Wke8AeEFVHzS3+z6Ap2Dc+xWq+l/N9j+CMeu4y9z+N8z2OQCeUlXXyj8ichOAmwCgp6fn/HfeeSfmZZN6koSXlHO724e2VnkmOel2nOtURw0MO0Ep2QXA9ct6JmtxhEnzXm9yWUHvaV3YEcN7LKxDQT6Xwcm5LEaPlKuUgpuCv+b87iol5pZyPWxRK2t/y9APGPfizie3uXqDBaXqdxbECusE4UezK6HU05s7FYbXZyJyGwCo6t3mZxsArDI3XaWqK8z228y2NQD2A/gPqjomIhfat/OD6c3JvNue8oyA9hsoglKIe30uAL517SL0Le6OnUq8FgoBNThqpbuQxy8PHY0UWW/1szXTcmLNDJJmelcOw1+7xBj0H9/i2yde6dsX3fm0qydZIZ/zjJYPohH1X6JS9/TmIjLL9u+nAFgeVOsAfFZEThKRuQDOBvAigJcAnG16RE2FYRhfp4a2eg7Ap839bwTw4zgykc7DbyCqJdLX63MFJo9Zb0O3AJh20pTUlAVgXFPUwd3qZ6/+SCutizWbGNywPbBPvGTzcjuuJRV+O0fUA+Hcah8G8AKA+SKyR0S+AOCvRWSriLwK4CIAtwCAqm4D8CiAfwXwTwC+pKrjpo3iywA2AHgNwKPmtgDwVQC3ishOGDaN7yd6haRtCTJ+x4309TO0WsestzF2diGfupKK61BgLb24kXZalzB9Us971c4R9UA4L6nrVHWWquZU9QxV/b6q/pGqLlDVj6vqlaq6z7b9N1R1nqrOV9Wf2tqfUtXfND/7hq39TVW9QFV/Q1VXquqx5C+TtCNeKUMsZhfyuP7eF9A7sH7y7/p7X/BMuX7ROTMDl5qswSdMmveksIz9ha5caucQYLI2e1SsdXq3/phwmWFkM/4p18MgAswdWI9MCIXkZayf7tGfXu1haHdvL+aSIi3L6r4FuGFZD9zGnnwui66pGTz/RqVH+PNvHMBjm3dVBXpZxlk/ZWH35nIGixXyuapaFH6E3XJ6V26ynvihGqsG+sny2/Nm4IcvF10dAvzIZWXSqHv31QuqBlu3xaIMgAvmTg91fC+9omocO8yS13Ov73dtv+OT51bdM+t8UetkWPU1LI85O/aHkVavv8Ga3qQtcPNMseducvL2misq/g+aWWRF8Lef8fee8XIfteegmh5Q98JJkCE+LNOmZpHLZnCoVJ6svXGodMLTyctoHYTTqyisnFGM4bmsYNrUKThUKiPjsV9G4BlZLwDectxvC/s9O9XFqSCMwdrLq05xwlPP6SnWSEN46l5SzQgVBgmid2C952dOhTF3YL2vi67foBOVoHO5nTfKPm54eQrFkclJVgQTqqHL98bBkt9LToF3EsKga7cI8p6Lu1/c46ZF3b2kCGk3gtaYk1yDjnKsWqO4LYKMrrUcf1wVCrgux3gR1Rge5GzgZUcRU64wy0BxDdZen1vn9VKirWgIp8IgbcvyeTNCt/sZsZNOfR3WYG7ZB6x93GwkuYx4XqedIIXQv2J+6MHeDyulux9WfY8oNh8/ZwPr/tjtSgAqou+t7Ld+SiOuwdrvcz8l2oqGcCoM0rY89MULqwbT5fNm4KEvXli1rXOwsZ6Aw2Q+tbAMn0GGTbfsqjcs60Ehf8Jg3JXL4JSTpuCWtSNYvuZZAMDgpxdWGJUL+RwGVy7EQ1+8EDcs6/F8ag+j8PoWdyeW1NFauwdO9KOzP1f3Lai6Hi/8nA2c98fKQttdyFddT1A8hJ8y8sNLmVu4KdFWrb9BGwYhCZBkhG+tx4qbmiKKYd0aAN1Gj7iR0vbcXGFzR3nhZ+vws0XF6Tu3FCNudJuxNHHT4SQFjd6ENAj7IOeG3bsqaFvAGGyDquSFwZkM0W+7rqnZyO60cWWx3lvXaeWkcuYXu+icmfjJln2T3mTOyoL2PFJuA2xUQ3Ocgfr2oa14eNPuUN5eYQzcfvm4wuReCwsVBiENIGwCQq8kfCQe1mwLgOdMzO8zt6zDUWd0tw9tDV31Mezs0C+HmX2UrtUll15ShDSAsBXuSuVxPLxpN5VFQli2CL+8TVGq8MXJ/xS26mMUG5hfDrMosqUJa3oTEpMobpFpJeHrVPz63vosTBW+oWHv6H6/cwTdT7/ZjNfSV5Q4lka55HKGQUhMorhFRo07SDdlX+szu5CvOW+TtRTldw4v/O6n16zCOl/RLDPsdPXtXzE/dI6tRrnkcoZBSAScqSRyWalIJeGWoiKODeM3PjItViGkTsBeedFZRCvIXdV+/7zSjIQ5znVL57jaMLzctgH/pa9J5eLQF9mMIIPKYlONdMnlDIOQkDifEEdLZUCN/FAC49X55CkArjm/G6v7FlTEeQRRL2UhMPJMWe+bAYEx8NrjUqxutZ7eAeCHLxcrlIXV137lW+33z29ZKcjusLpvgWvA5L+8cQC9HnE4QZHkbrU9xicUp5w8JZQtph5whkFISNyeEMsTiq6pUzD8tUuwfM2zVe6wihPZUr3W1MPGP7i5ZjYiT1Ha1QYVwNvvl1xjOfxck+197UZYJwVLqS9f86yvK+vb77vLAJxYbtr8zoFJl1ivGY21vOSlUA4eKWP4a/EqACYNZxiEhCRupb64uYjCbFePgj3OCPZ6lKZ1k98+Q4iyn0UYua1U5E5bw81rR7D4rqcrZg1BfVwqj+Ohjbt8ZzT25SW/eie3D3nbWuoJZxiEhMTLi8WeINDv86jHDXMcr30zIpg7sL7i6ThMoNnyeTMwd+YpntvVq465wsg23JXL4C+v/jj6Fndj1bptgTOEIEO137VnRXBez6me137wSBn9j2/BqnXbfFOtO6/D7TxWdl/r3gwNF/Hro2Oex3lw465JueJGvycBA/cICUlQgFfclB5hAgC9In4BoP/xLb51rfO5LM7rObWqmFSrkBHgPy/tCQyUEwDXL+vB6j7DxuF0Ya2XsgvCLT1J1JlbLcF7tQTucYZBSEisH6eXH33Q51GO65Yqw+5lZa2RX3N+d2AOkFJ5vGWVBWB4nYUJlFMYhvAlZ86o8qBKU1lYMxdnRLZXehbnLMgvFsSLKu+qOsEZBiEtgNcTaJTKdZ1CPpdBqTxR13NO78rhaHl88rzTu3K44uOzPF2prUp89nxZUYlb1IszDELaHC8DK5VFNfVWFkB1sshfHx3Dj17xjrspjpZC56Ly4tR8cGr4pKGXFCEtgJcxN0wEeT6XDVVkiSRHeUJTzQAMnIhNqSdUGIS0AF7FfYIq1xlBedrSNoxOpJDPBQZ51poCPw5UGIS0AF7ZV1f3LcC0qe4ry9OmZnF8bKIhSzQkPrmMYNWV5+L5gYvx7WsXec4iBQisU540tGGQlqceVcqaAa9I8UMeRtO0l0RIOpxy8pQKN20vO5UCdfeU4gyDtDRBGUA7gUZlLm0mmiUPVhKMmktNYVKZ1DvNORUGaWniFL9pN7zsG4UGeNE0inbyFZtdyOP2If8UKPZt6wmXpEhLU49cSs2OV8AgANy8dqSRopEY7P/gaGiX24vOmZmyNJVQYZCaaLT9IEz+pkbLWA+87Bt+CkNgJLxTNewgswt5dE3N+KZWn96Vw+mnTGWtjhQ57pPmxcn6V/dNpkKpB1QYJDbOHEiW/QBA3Qbk/hXzXfM3WU/YzSBjI+n2UKhe6c8X3fm053GeH7h4UvlaNoN2WgpqRertWksbBolNM9gPvNxN7cs0jZaxkXjZN9wqtg0NFz3TVOwdLVU5GFBZdB6cYZDYNIv9wGs5xk+WTrFxBCVE9CtIZCcjgjufDE4vTupLvR0bqDBIbOLWf6gncWRsN5uHl0INk1bdYly1IZHFxJ9VV55b1/MFLkmJyH0i8p6I/MLWNkNEnhGRHebrdLNdROQeEdkpIq+KyHm2fW40t98hIjfa2s8Xka3mPveINCJDCvHDWXHNinGIstzRKKLK2ElxHWFLltaKADj7I9NC5b0i4fFLCZMWYWwYPwBwqaNtAMDPVPVsAD8z/weAywCcbf7dBOC7gKFgANwBYCmACwDcYSkZc5ubbPs5z0UaiN8AGmQ/aAaiythJNo96LcspgJ3vHWZm3YQpj2vdv5eBS1Kq+s8i0utovgrAJ8z39wP4OYCvmu0PqFFkY6OIFERklrntM6p6AABE5BkAl4rIzwF8WFVfMNsfANAH4Ke1XBRJDr8B1FrqaCYF4UYUGTvJ5hGnCl0+l8HRsQlEHfupKtKh3t/LuDaMj6rqPgBQ1X0i8hGzvRuAvTTWHrPNr32PS7srInITjNkIenp6YopOohB1ALWv/9t9/K2iNtbAYa/VDKCi3nRWBO7m6XEAABPjSURBVNctnVPlX+5lW7Abbq2CQlaBGqtqnSXLaKk8uY31WsjnUB6f8M291Ex2maRwc0kO4lgMZUHSo9Ujvd0W1TRGuyuq+j0A3wOMintxBOwEwhhtwxp2oxiNnUZUu5H0iCNj6pHyBG591Agq2/zOgYrI1nFVPLhxF97a/2s89MULXY9dHC3hlrUjuHntSEUpTGvZw1mgxi6LtY31GlTxLKpdpl5G81rPY/egCjvTmOCvrqmot70wrsJ4V0RmmbOLWQDeM9v3AJhj2+4MAHvN9k842n9utp/hsj2JSZhAtSjBbG5Pobms4PCxMcwdWF8xUEU1ok6oMVj98tBR18+ff+MAegfWo7uQx+FjY1XHVsdrGnRHHIi9FNvmdw6EnjHFPY/9Hg4NF3Hnk9smFWUhn8OqK8+tOr61XOdVApYQO6Fqeps2jJ+o6m+Z/w8CeF9V14jIAIAZqvpnInIFgC8DuByGgfseVb3ANHq/DMDymnoFwPmqekBEXgLwJwA2AXgKwN+p6lNBMrGmtzteP3x7ZG+Ybew4l5l+fXQMZdujZj6Xxd1XL8Ata0faaq06Ts1kr74VAN+6dpGn0ra2UYRTUn4DfCGfwwfHxjDumA7kMoLBlQsBVMZl9J6WxwtvHuDsoQU5aUoG21dfFmmfVGt6i8jDMGYHp4vIHhjeTmsAPCoiXwCwC8BKc/OnYCiLnQCOAPg8AJiK4esAXjK3u8sygAP47zA8sfIwjN00eNdAGJtDVLuE3Wi8fM2zVf74lhE8jhG1mYmzPuzVh87aBW6zMWu8DpO+xM/Y6bXEVp7QqiW84mipre5Zp3FsrL7FscJ4SV3n8dHvu2yrAL7kcZz7ANzn0r4ZwG8FyUHCEcbm4LVNoSuH5WuenXzytBuNrSUTr4GqOFrCDct68MOXvQvftxK5jFTkowpjVD9WHvedYRVHS5NLbEGDdKk8jlvWjuCWtSOu0dkZU444cCJB4hJqSaoZ4ZJU9Rr4RefMxE+27Kt6whQAvz1vBt5+P92nyXwui2vO767yTHLzkorD9K4cuqZOSf2JuJDP4Q8XzsJzr+9HcbRU8UTeKATA9ct6sOTMGZE9m0h783bEZdNalqSoMFqUKGkd6omXHcSid2B9qOM4B2nLTpK2gdayHzRj3wqAU/O5QK8u0lnUU2Ewl1QM3J7sradRL/K5DK45/4yqJZ4grxivuAag8U+9bvitrYdNr3GD+STtVhAobW+evaOluqXMiIoi2AWYkDShwoiImztjmOpYpfJExXZhDJt+cQ3Nip+hOEwag+XzZky6n9r7pV4zqtmFfFtGdROSBFQYEUny6dOeYiPtc9WDoAC3MAPxtr0fTL63z65qMfKGxZI/SiBbXHIZAcTIB0RIq0CFEZGknz79jtcKT7pRYgfCuN2OlsqTS1f2GUXaymLa1Cy+8akTSQm9YiSSoNu2xOb0vrJecxmgXF+PSUICYcW9iCSdu8XveFHPlXSy42lTs8j5fEMyYhhhw57XLdW4G6vWbav77OqILY+UW4bbb127CN++dlFN58iKVPRV3+LuyT6xpyvJ57KYdlJ9C+MQEgZ6SUUkybV0u+dPreeyXFqTjIPIZQXTpk7BaKlc9YSdywqgcI34ticEtIzWXVMz2PHe4UTkSgs/D6+h4SJWrdtGozNpKqZNzWLbXdEqQtBLqo64lbxMw0vKGnBL5fHJZYrpNi+pKY4li1J5HM+9vh/n9ZyKjW8enFzeWHbW9NjxF+VxnRwg7cpiui3zq51SeRw3rx3BqnXbcPj42OT6fJxzZ+tgs3Dil4G3/7EtFcqRkGbgG59aELxRglBhxCDtGhDOmYW1THHHJ43kcbcPbXX1zHKmeRhXxSu7DuHuq40vVVIzo6PlCd/jJPEU3ohiO/YlwHob3AlpBWjDaEKCqr49vGm3226u2D2xnOvycQvIW7OeduOic2YCqK4ySGVBmpU7n9xW1/NxhuHB0HARf/7Eq5N1HESA3z4rOL1GGK+hoLTWQckBow5gxdESlq95Fv0r5les0ddij7FmPa3k9hvE+lf3YXXfgpZzZyadS71js6gwXBgaLuLWR0cq0j2rGvUZgrBnAb117chku1d6cLcAPi/3U0X41BpOiqMl9D++BZvfOVBhR7Hnfjo1n4OI8SXMiH+xHEsh1iNmoV5YP75WcGcmpBFwScqFwQ3bE6kNMAHgZrMqnLW8cfBIucp4al9uAk4sjSRNedyoZGfJUhwtYe1Lu9G/Yj6+de0iTDtpCg4eMTyi/K7fCnDrW9yN5wcuxrevXWR4TbUJhS66tJLWwM/tPQ04w3ChEU+Y1jmHhotY+2J4G0WtlMerayS46YqsCCZUXZfQ+hZ3t43L6e1DW1siBQshQP2DO6kwXGhEIaDZhTyGhov4yqNbGmJkDTrjuCpEjFmJNWtqR8LkBSOkU+GSlAv9K+YjU+cVlt7T8rjtia1N7ZHTxKIRQuoAZxguWMstdi+ptLGC7QghpFmhwvDAHpzndIPtPS0faoAP8jSyQ2VBCGl2qDBC4BfZff29L1S42+YywODKRRX5lNrF7ZQQ0tl0tMIICqALw0NfvNDzM7uiWXzX0/S+IYS0NB2rMNwq5wVVwPM6jpfScZZXjbJERQghzUbHKgy/fE1hFYaf0gFQVV41lxV8eOoUHCqVm7IeNyGE+NGxbrVB+ZrC4Kd03D4rjyumnTQFb625InbiP0IIaRQdqzC8qtlFqXLnp3T8PhsaLuJXR2nPIIS0Fh2rMNzKhVo5ksLip3RO9ZhBFLpyuGXtCG0ZhJCWo2MVhlt9CL9yqW54KZ2LzpmJw8fHqrbPCPDro2O0XxBCWpKONXoDtVfOcyvXaqX8tsqT2lGAZT4JIS1LRyuMJHBTOrd4JOZjMDchpJXp2CWpNPGybbRhVVNCSAfBGUYAzuA7VeBQqewbGd6/Yn5V6dN8LguB1i2ZISGEJA0Vhg9Dw0X0P75l0h5hT+3hDNKz2zGMinnVVfUIIaSV6WiFMTRc9E1hHpTKo1QeryokVBwtxSrCk8sIDeKEkKamJhuGiLwtIltFZERENpttM0TkGRHZYb5ON9tFRO4RkZ0i8qqInGc7zo3m9jtE5MbaLikcQ8NF3ProiO8SUT3HbyoLQkizk4TR+yJVXaSqS8z/BwD8TFXPBvAz838AuAzA2ebfTQC+CxgKBsAdAJYCuADAHZaSSZPBDdsZPEcIIRFIw0vqKgD3m+/vB9Bna39ADTYCKIjILAArADyjqgdU9SCAZwBcmoJcFUTJGUUIIaR2haEAnhaRl0XkJrPto6q6DwDM14+Y7d0Adtv23WO2ebVXISI3ichmEdm8f//+mgSPkjOKEEJI7QpjuaqeB2O56Usi8ns+27pFIahPe3Wj6vdUdYmqLpk5c2Z0aW30r5iPDOMiCCEkNDUpDFXda76+B+BHMGwQ75pLTTBf3zM33wNgjm33MwDs9WlPlb7F3fjmZxahK8fYRUIICUPs0VJEponIh6z3AC4B8AsA6wBYnk43Avix+X4dgM+Z3lLLABwyl6w2ALhERKabxu5LzLbU6VvcjX/9+mV4e80VuGFZj+tUhxBCiEEtcRgfBfAjMfJdTAHwj6r6TyLyEoBHReQLAHYBWGlu/xSAywHsBHAEwOcBQFUPiMjXAbxkbneXqh6oQa5YrO5bgNV9CyranBX1CCGkk4mtMFT1TQALXdrfB/D7Lu0K4Esex7oPwH1xZUkLZzbaQlcOx8rjFbEbuQzAbB+EkE6goyO9ndjzRlm5oux0TZ2COz55rmdK9NuHtsaK8iaEkFaACsPEufxUHC2h/7EtgGAyl5Q9f5Sb0lhy5gw8+tJuHHephUEIIa0OXYRMBjdsr7JVlCe0qhBSqTyOwQ3bq/a3FA6VBSGkXaHCMIkS+e22rZvCIYSQdoIKwyRK5Lfbtkw1Qghpd6gwTPpXzEc+l61oy2UEuWxldEY+l60yhgNMNUIIaX+oMEz6Fnfj7qsXoLuQhwDoLuQxuHIhBj+9sKLt7qsXeFbZcyocQghpJ+glZaNvcberMvByo3XbxnLLpembENJuUGEkiF3h9A6sb7A0hBCSLFySSomsMDMVIaS9oMJIieuWzgneiBBCWggqjJRY3bcANyzrmZxpZEWwfN6MSQM6ZyCEkFaDNowUccuAazE0XET/41uqIskJIaRZocKoI1ZywyKD/AghLQgVRh0YGi7izx7fwjxThJCWhgojZYaGi/jKY1swPkFlQQhpbagwEsKrlsbNa0caLBkhhCQDFUYCuNXSoKIghLQbVBg1MjRcxC1rR5gKhBDS9lBh+HD70FY8vGk3xlWRFcF1S+dgyZkz8OdPvFpR15sQQjoBKgwPnPW5x1Xx4MZdrNlNCOlYGOntwcObdjdaBEIIaSqoMFy4/t4XMK60ShBCiB0qDAfX3/sCnn/jQKPFIISQpoMKwwGVBSGEuEOFYeP2oa2NFoEQQpoWekmZ/ME3f44d7x1utBiEENK0UGGA5VQJISQMHakwaNgmhJDodJTCcAbjEUIICU/HGL2pLAghpDY6RmFQWRBCSG10jMIghBBSG02jMETkUhHZLiI7RWSg0fIQQgippCkUhohkAXwHwGUAPgbgOhH5WGOlIoQQYqcpFAaACwDsVNU3VfU4gEcAXNVgmQghhNhoFoXRDcCeT3yP2VaBiNwkIptFZPP+/fvrJhwhhJDmURji0laVX1xVv6eqS1R1ycyZM+sgFiGEEItmURh7AMyx/X8GgL0NkoUQQogLzaIwXgJwtojMFZGpAD4LYF2SJ3h7zRVJHo4QQhpOvce1pkgNoqpjIvJlABsAZAHcp6rbkj4PlQYhhMSnKRQGAKjqUwCearQchBBC3GmWJSlCCCFNDhUGIYSQUFBhEEIICQUVBiGEkFCIalV8XEsgIvsBvONoPh3AvzdAnChQxtppdvkAypgUzS5js8sHVMt4pqrGinxuWYXhhohsVtUljZbDD8pYO80uH0AZk6LZZWx2+YBkZeSSFCGEkFBQYRBCCAlFuymM7zVagBBQxtppdvkAypgUzS5js8sHJChjW9kwCCGEpEe7zTAIIYSkBBUGIYSQULSNwhCRS0Vku4jsFJGBBskwR0SeE5HXRGSbiPyp2b5KRIoiMmL+XW7b5zZT5u0isqJOcr4tIltNWTabbTNE5BkR2WG+TjfbRUTuMWV8VUTOq4N88219NSIivxKRmxvdjyJyn4i8JyK/sLVF7jcRudHcfoeI3JiyfIMi8ropw49EpGC294pIydaX/2Db53zz+7HTvAa3AmdJyhj5vqb5e/eQca1NvrdFZMRsr3s/+owz6X8XVbXl/2CkRH8DwFkApgLYAuBjDZBjFoDzzPcfAvBvAD4GYBWA/+Gy/cdMWU8CMNe8hmwd5HwbwOmOtr8GMGC+HwDwV+b7ywH8FEZVxGUANjXg3v4SwJmN7kcAvwfgPAC/iNtvAGYAeNN8nW6+n56ifJcAmGK+/yubfL327RzHeRHAhabsPwVwWcp9GOm+pv17d5PR8fnfAvhao/rRZ5xJ/bvYLjOMCwDsVNU3VfU4gEcAXFVvIVR1n6q+Yr7/AMBrcKlNbuMqAI+o6jFVfQvAThjX0giuAnC/+f5+AH229gfUYCOAgojMqqNcvw/gDVV1RvXbqUs/quo/Azjgcu4o/bYCwDOqekBVDwJ4BsClacmnqk+r6pj570YY1Sw9MWX8sKq+oMao8oDtmlKR0Qev+5rq791PRnOW8BkAD/sdI81+9BlnUv8utovC6Aaw2/b/HvgP1KkjIr0AFgPYZDZ92ZwO3mdNFdE4uRXA0yLysojcZLZ9VFX3AcYXEsBHGiyjxWdR+eNspn4EovdbI2X9YxhPmhZzRWRYRP6viPyu2dZtylRv+aLc10b24e8CeFdVd9jaGtaPjnEm9e9iuygMt7XBhvkLi8gpAH4I4GZV/RWA7wKYB2ARgH0wprRA4+RerqrnAbgMwJdE5Pd8tm1Y34pRrvdKAI+ZTc3Wj354ydQQWUXkLwCMAXjIbNoHoEdVFwO4FcA/isiHGyRf1PvayPt9HSofYBrWjy7jjOemHrJElrFdFMYeAHNs/58BYG8jBBGRHIyb+JCqPgEAqvquqo6r6gSAe3FiuaQhcqvqXvP1PQA/MuV511pqMl/fa6SMJpcBeEVV3zXlbap+NInab3WX1TRm/iGA683lEZjLPO+b71+GYRP4TVM++7JV6vLFuK8Nud8iMgXA1QDWWm2N6ke3cQZ1+C62i8J4CcDZIjLXfCr9LIB19RbCXN/8PoDXVPWbtnb7mv+nAFjeF+sAfFZEThKRuQDOhmEoS1PGaSLyIes9DKPoL0xZLC+JGwH82Cbj50xPi2UADlnT3jpQ8TTXTP1oI2q/bQBwiYhMN5deLjHbUkFELgXwVQBXquoRW/tMEcma78+C0WdvmjJ+ICLLzO/z52zXlJaMUe9ro37v/wnA66o6udTUiH70GmdQj+9iElb7ZviD4QnwbzA0/F80SIbfgTGlexXAiPl3OYD/DWCr2b4OwCzbPn9hyrwdCXqj+Mh4Fgyvki0Atll9BeA0AD8DsMN8nWG2C4DvmDJuBbCkTn3ZBeB9AKfa2hrajzCU1z4AZRhPZ1+I028wbAk7zb/PpyzfThjr1Nb38R/Mba8x7/8WAK8A+KTtOEtgDNpvAPh7mBkhUpQx8n1N8/fuJqPZ/gMA/82xbd37Ed7jTOrfRaYGIYQQEop2WZIihBCSMlQYhBBCQkGFQQghJBRUGIQQQkJBhUEIISQUVBiEEEJCQYVBCCEkFP8fNEMta1X9NnwAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# plot the relationship between Trip Time and Distance\n",
    "plt.scatter(x=bikeDataClean['trip_duration_seconds'], y = bikeDataClean['Cartesian_Displacement'])\n",
    "\n",
    "\n",
    "# no major correlation to be found here\n",
    "# will need to group by month, day, hours, etc to see if anything shakes out...\n",
    "\n",
    "# Also, the plot seems to indicate some trips hit 20km in ~250 seconds?? What happened here?\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 255,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>trip_duration_seconds</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>trip_start_time</th>\n",
       "      <th>trip_stop_time</th>\n",
       "      <th>user_type</th>\n",
       "      <th>from_station_id_corr</th>\n",
       "      <th>from_station_name_corr</th>\n",
       "      <th>from_lat</th>\n",
       "      <th>from_lon</th>\n",
       "      <th>to_station_id_corr</th>\n",
       "      <th>to_station_name_corr</th>\n",
       "      <th>to_lat</th>\n",
       "      <th>to_lon</th>\n",
       "      <th>trip_start_date</th>\n",
       "      <th>Temp (°C)</th>\n",
       "      <th>work_day</th>\n",
       "      <th>month</th>\n",
       "      <th>TripItinerary</th>\n",
       "      <th>Sightseeing</th>\n",
       "      <th>Cartesian_Displacement</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23981</th>\n",
       "      <td>606</td>\n",
       "      <td>1734556</td>\n",
       "      <td>2017-01-09 19:31:00</td>\n",
       "      <td>2017-01-09 19:41:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7084.0</td>\n",
       "      <td>High Park - Grenadier Cafe</td>\n",
       "      <td>43.645599</td>\n",
       "      <td>-79.465712</td>\n",
       "      <td>7266.0</td>\n",
       "      <td>Victoria Park Subway Station - SMART</td>\n",
       "      <td>43.694016</td>\n",
       "      <td>-79.288984</td>\n",
       "      <td>2017-01-09</td>\n",
       "      <td>-4.829167</td>\n",
       "      <td>Mon</td>\n",
       "      <td>1</td>\n",
       "      <td>High Park - Grenadier Cafe TO Victoria Park Su...</td>\n",
       "      <td>False</td>\n",
       "      <td>23655.749870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514542</th>\n",
       "      <td>760</td>\n",
       "      <td>1769191</td>\n",
       "      <td>2017-06-09 17:52:00</td>\n",
       "      <td>2017-06-09 18:05:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7086.0</td>\n",
       "      <td>High Park - West Rd</td>\n",
       "      <td>43.652508</td>\n",
       "      <td>-79.465423</td>\n",
       "      <td>7266.0</td>\n",
       "      <td>Victoria Park Subway Station - SMART</td>\n",
       "      <td>43.694016</td>\n",
       "      <td>-79.288984</td>\n",
       "      <td>2017-06-09</td>\n",
       "      <td>20.020833</td>\n",
       "      <td>Fri</td>\n",
       "      <td>6</td>\n",
       "      <td>High Park - West Rd TO Victoria Park Subway St...</td>\n",
       "      <td>False</td>\n",
       "      <td>23008.110288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535877</th>\n",
       "      <td>830</td>\n",
       "      <td>2203561</td>\n",
       "      <td>2017-06-11 18:48:26</td>\n",
       "      <td>2017-06-11 19:02:16</td>\n",
       "      <td>Member</td>\n",
       "      <td>7086.0</td>\n",
       "      <td>High Park - West Rd</td>\n",
       "      <td>43.652508</td>\n",
       "      <td>-79.465423</td>\n",
       "      <td>7266.0</td>\n",
       "      <td>Victoria Park Subway Station - SMART</td>\n",
       "      <td>43.694016</td>\n",
       "      <td>-79.288984</td>\n",
       "      <td>2017-06-11</td>\n",
       "      <td>24.508333</td>\n",
       "      <td>Sun</td>\n",
       "      <td>6</td>\n",
       "      <td>High Park - West Rd TO Victoria Park Subway St...</td>\n",
       "      <td>False</td>\n",
       "      <td>23008.110288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46971</th>\n",
       "      <td>109</td>\n",
       "      <td>731835</td>\n",
       "      <td>2017-01-16 14:08:00</td>\n",
       "      <td>2017-01-16 14:10:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7084.0</td>\n",
       "      <td>High Park - Grenadier Cafe</td>\n",
       "      <td>43.645599</td>\n",
       "      <td>-79.465712</td>\n",
       "      <td>7085.0</td>\n",
       "      <td>Danforth Ave / Westlake Ave</td>\n",
       "      <td>43.687323</td>\n",
       "      <td>-79.304848</td>\n",
       "      <td>2017-01-16</td>\n",
       "      <td>-0.045833</td>\n",
       "      <td>Mon</td>\n",
       "      <td>1</td>\n",
       "      <td>High Park - Grenadier Cafe TO Danforth Ave / W...</td>\n",
       "      <td>False</td>\n",
       "      <td>21323.096618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167530</th>\n",
       "      <td>108</td>\n",
       "      <td>826312</td>\n",
       "      <td>2017-03-09 02:57:00</td>\n",
       "      <td>2017-03-09 02:59:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7084.0</td>\n",
       "      <td>High Park - Grenadier Cafe</td>\n",
       "      <td>43.645599</td>\n",
       "      <td>-79.465712</td>\n",
       "      <td>7085.0</td>\n",
       "      <td>Danforth Ave / Westlake Ave</td>\n",
       "      <td>43.687323</td>\n",
       "      <td>-79.304848</td>\n",
       "      <td>2017-03-09</td>\n",
       "      <td>1.233333</td>\n",
       "      <td>Thu</td>\n",
       "      <td>3</td>\n",
       "      <td>High Park - Grenadier Cafe TO Danforth Ave / W...</td>\n",
       "      <td>False</td>\n",
       "      <td>21323.096618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335967</th>\n",
       "      <td>89</td>\n",
       "      <td>969182</td>\n",
       "      <td>2017-05-04 13:04:00</td>\n",
       "      <td>2017-05-04 13:05:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7084.0</td>\n",
       "      <td>High Park - Grenadier Cafe</td>\n",
       "      <td>43.645599</td>\n",
       "      <td>-79.465712</td>\n",
       "      <td>7085.0</td>\n",
       "      <td>Danforth Ave / Westlake Ave</td>\n",
       "      <td>43.687323</td>\n",
       "      <td>-79.304848</td>\n",
       "      <td>2017-05-04</td>\n",
       "      <td>7.812500</td>\n",
       "      <td>Thu</td>\n",
       "      <td>5</td>\n",
       "      <td>High Park - Grenadier Cafe TO Danforth Ave / W...</td>\n",
       "      <td>False</td>\n",
       "      <td>21323.096618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107526</th>\n",
       "      <td>127</td>\n",
       "      <td>1983989</td>\n",
       "      <td>2017-02-10 18:07:08</td>\n",
       "      <td>2017-02-10 18:09:15</td>\n",
       "      <td>Member</td>\n",
       "      <td>7084.0</td>\n",
       "      <td>High Park - Grenadier Cafe</td>\n",
       "      <td>43.645599</td>\n",
       "      <td>-79.465712</td>\n",
       "      <td>7085.0</td>\n",
       "      <td>Danforth Ave / Westlake Ave</td>\n",
       "      <td>43.687323</td>\n",
       "      <td>-79.304848</td>\n",
       "      <td>2017-02-10</td>\n",
       "      <td>-4.666667</td>\n",
       "      <td>Fri</td>\n",
       "      <td>2</td>\n",
       "      <td>High Park - Grenadier Cafe TO Danforth Ave / W...</td>\n",
       "      <td>False</td>\n",
       "      <td>21323.096618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476625</th>\n",
       "      <td>98</td>\n",
       "      <td>1104546</td>\n",
       "      <td>2017-06-05 13:22:00</td>\n",
       "      <td>2017-06-05 13:24:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7084.0</td>\n",
       "      <td>High Park - Grenadier Cafe</td>\n",
       "      <td>43.645599</td>\n",
       "      <td>-79.465712</td>\n",
       "      <td>7085.0</td>\n",
       "      <td>Danforth Ave / Westlake Ave</td>\n",
       "      <td>43.687323</td>\n",
       "      <td>-79.304848</td>\n",
       "      <td>2017-06-05</td>\n",
       "      <td>14.958333</td>\n",
       "      <td>Mon</td>\n",
       "      <td>6</td>\n",
       "      <td>High Park - Grenadier Cafe TO Danforth Ave / W...</td>\n",
       "      <td>False</td>\n",
       "      <td>21323.096618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181007</th>\n",
       "      <td>103</td>\n",
       "      <td>1991865</td>\n",
       "      <td>2017-03-10 17:47:22</td>\n",
       "      <td>2017-03-10 17:49:05</td>\n",
       "      <td>Member</td>\n",
       "      <td>7084.0</td>\n",
       "      <td>High Park - Grenadier Cafe</td>\n",
       "      <td>43.645599</td>\n",
       "      <td>-79.465712</td>\n",
       "      <td>7085.0</td>\n",
       "      <td>Danforth Ave / Westlake Ave</td>\n",
       "      <td>43.687323</td>\n",
       "      <td>-79.304848</td>\n",
       "      <td>2017-03-10</td>\n",
       "      <td>-5.054167</td>\n",
       "      <td>Fri</td>\n",
       "      <td>3</td>\n",
       "      <td>High Park - Grenadier Cafe TO Danforth Ave / W...</td>\n",
       "      <td>False</td>\n",
       "      <td>21323.096618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690001</th>\n",
       "      <td>107</td>\n",
       "      <td>1370289</td>\n",
       "      <td>2017-07-17 09:01:00</td>\n",
       "      <td>2017-07-17 09:02:00</td>\n",
       "      <td>Member</td>\n",
       "      <td>7084.0</td>\n",
       "      <td>High Park - Grenadier Cafe</td>\n",
       "      <td>43.645599</td>\n",
       "      <td>-79.465712</td>\n",
       "      <td>7085.0</td>\n",
       "      <td>Danforth Ave / Westlake Ave</td>\n",
       "      <td>43.687323</td>\n",
       "      <td>-79.304848</td>\n",
       "      <td>2017-07-17</td>\n",
       "      <td>21.904167</td>\n",
       "      <td>Mon</td>\n",
       "      <td>7</td>\n",
       "      <td>High Park - Grenadier Cafe TO Danforth Ave / W...</td>\n",
       "      <td>False</td>\n",
       "      <td>21323.096618</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        trip_duration_seconds  trip_id      trip_start_time  \\\n",
       "23981                     606  1734556  2017-01-09 19:31:00   \n",
       "514542                    760  1769191  2017-06-09 17:52:00   \n",
       "535877                    830  2203561  2017-06-11 18:48:26   \n",
       "46971                     109   731835  2017-01-16 14:08:00   \n",
       "167530                    108   826312  2017-03-09 02:57:00   \n",
       "335967                     89   969182  2017-05-04 13:04:00   \n",
       "107526                    127  1983989  2017-02-10 18:07:08   \n",
       "476625                     98  1104546  2017-06-05 13:22:00   \n",
       "181007                    103  1991865  2017-03-10 17:47:22   \n",
       "690001                    107  1370289  2017-07-17 09:01:00   \n",
       "\n",
       "             trip_stop_time user_type  from_station_id_corr  \\\n",
       "23981   2017-01-09 19:41:00    Member                7084.0   \n",
       "514542  2017-06-09 18:05:00    Member                7086.0   \n",
       "535877  2017-06-11 19:02:16    Member                7086.0   \n",
       "46971   2017-01-16 14:10:00    Member                7084.0   \n",
       "167530  2017-03-09 02:59:00    Member                7084.0   \n",
       "335967  2017-05-04 13:05:00    Member                7084.0   \n",
       "107526  2017-02-10 18:09:15    Member                7084.0   \n",
       "476625  2017-06-05 13:24:00    Member                7084.0   \n",
       "181007  2017-03-10 17:49:05    Member                7084.0   \n",
       "690001  2017-07-17 09:02:00    Member                7084.0   \n",
       "\n",
       "            from_station_name_corr   from_lat   from_lon  to_station_id_corr  \\\n",
       "23981   High Park - Grenadier Cafe  43.645599 -79.465712              7266.0   \n",
       "514542         High Park - West Rd  43.652508 -79.465423              7266.0   \n",
       "535877         High Park - West Rd  43.652508 -79.465423              7266.0   \n",
       "46971   High Park - Grenadier Cafe  43.645599 -79.465712              7085.0   \n",
       "167530  High Park - Grenadier Cafe  43.645599 -79.465712              7085.0   \n",
       "335967  High Park - Grenadier Cafe  43.645599 -79.465712              7085.0   \n",
       "107526  High Park - Grenadier Cafe  43.645599 -79.465712              7085.0   \n",
       "476625  High Park - Grenadier Cafe  43.645599 -79.465712              7085.0   \n",
       "181007  High Park - Grenadier Cafe  43.645599 -79.465712              7085.0   \n",
       "690001  High Park - Grenadier Cafe  43.645599 -79.465712              7085.0   \n",
       "\n",
       "                        to_station_name_corr     to_lat     to_lon  \\\n",
       "23981   Victoria Park Subway Station - SMART  43.694016 -79.288984   \n",
       "514542  Victoria Park Subway Station - SMART  43.694016 -79.288984   \n",
       "535877  Victoria Park Subway Station - SMART  43.694016 -79.288984   \n",
       "46971            Danforth Ave / Westlake Ave  43.687323 -79.304848   \n",
       "167530           Danforth Ave / Westlake Ave  43.687323 -79.304848   \n",
       "335967           Danforth Ave / Westlake Ave  43.687323 -79.304848   \n",
       "107526           Danforth Ave / Westlake Ave  43.687323 -79.304848   \n",
       "476625           Danforth Ave / Westlake Ave  43.687323 -79.304848   \n",
       "181007           Danforth Ave / Westlake Ave  43.687323 -79.304848   \n",
       "690001           Danforth Ave / Westlake Ave  43.687323 -79.304848   \n",
       "\n",
       "       trip_start_date  Temp (°C) work_day  month  \\\n",
       "23981       2017-01-09  -4.829167      Mon      1   \n",
       "514542      2017-06-09  20.020833      Fri      6   \n",
       "535877      2017-06-11  24.508333      Sun      6   \n",
       "46971       2017-01-16  -0.045833      Mon      1   \n",
       "167530      2017-03-09   1.233333      Thu      3   \n",
       "335967      2017-05-04   7.812500      Thu      5   \n",
       "107526      2017-02-10  -4.666667      Fri      2   \n",
       "476625      2017-06-05  14.958333      Mon      6   \n",
       "181007      2017-03-10  -5.054167      Fri      3   \n",
       "690001      2017-07-17  21.904167      Mon      7   \n",
       "\n",
       "                                            TripItinerary  Sightseeing  \\\n",
       "23981   High Park - Grenadier Cafe TO Victoria Park Su...        False   \n",
       "514542  High Park - West Rd TO Victoria Park Subway St...        False   \n",
       "535877  High Park - West Rd TO Victoria Park Subway St...        False   \n",
       "46971   High Park - Grenadier Cafe TO Danforth Ave / W...        False   \n",
       "167530  High Park - Grenadier Cafe TO Danforth Ave / W...        False   \n",
       "335967  High Park - Grenadier Cafe TO Danforth Ave / W...        False   \n",
       "107526  High Park - Grenadier Cafe TO Danforth Ave / W...        False   \n",
       "476625  High Park - Grenadier Cafe TO Danforth Ave / W...        False   \n",
       "181007  High Park - Grenadier Cafe TO Danforth Ave / W...        False   \n",
       "690001  High Park - Grenadier Cafe TO Danforth Ave / W...        False   \n",
       "\n",
       "        Cartesian_Displacement  \n",
       "23981             23655.749870  \n",
       "514542            23008.110288  \n",
       "535877            23008.110288  \n",
       "46971             21323.096618  \n",
       "167530            21323.096618  \n",
       "335967            21323.096618  \n",
       "107526            21323.096618  \n",
       "476625            21323.096618  \n",
       "181007            21323.096618  \n",
       "690001            21323.096618  "
      ]
     },
     "execution_count": 255,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean.sort_values(by='Cartesian_Displacement', ascending = False).head(10)\n",
    "\n",
    "# these numbers are extremely weird - a 10 minute trip from High Park to Victoria Park Subway station? \n",
    "#Even with TTC or GO that's impossible..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "trip_duration_seconds                                                   606\n",
       "trip_id                                                             1734556\n",
       "trip_start_time                                         2017-01-09 19:31:00\n",
       "trip_stop_time                                          2017-01-09 19:41:00\n",
       "user_type                                                            Member\n",
       "from_station_id_corr                                                   7084\n",
       "from_station_name_corr                           High Park - Grenadier Cafe\n",
       "from_lat                                                            43.6456\n",
       "from_lon                                                           -79.4657\n",
       "to_station_id_corr                                                     7266\n",
       "to_station_name_corr                   Victoria Park Subway Station - SMART\n",
       "to_lat                                                               43.694\n",
       "to_lon                                                              -79.289\n",
       "trip_start_date                                                  2017-01-09\n",
       "Temp (°C)                                                          -4.82917\n",
       "work_day                                                                Mon\n",
       "month                                                                     1\n",
       "TripItinerary             High Park - Grenadier Cafe TO Victoria Park Su...\n",
       "Sightseeing                                                           False\n",
       "Cartesian_Displacement                                              23655.7\n",
       "Name: 23981, dtype: object"
      ]
     },
     "execution_count": 256,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikeDataClean.loc[23981]  # this confirms it. Was there a glitch with these readings or data transcribing?\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 257,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "from_station_id                                            NaN\n",
       "from_station_name                     Stephenson Ave / Main St\n",
       "to_station_id                                              NaN\n",
       "to_station_name           Victoria Park Subway Station - SMART\n",
       "trip_duration_seconds                                      606\n",
       "trip_id                                                1734556\n",
       "trip_start_time                            2017-01-09 19:31:00\n",
       "trip_stop_time                             2017-01-09 19:41:00\n",
       "user_type                                               Member\n",
       "from_station_id_corr                                      7084\n",
       "from_station_name_corr              High Park - Grenadier Cafe\n",
       "from_lat                                               43.6456\n",
       "from_lon                                              -79.4657\n",
       "to_station_id_corr                                        7266\n",
       "to_station_name_corr      Victoria Park Subway Station - SMART\n",
       "to_lat                                                  43.694\n",
       "to_lon                                                 -79.289\n",
       "trip_start_date                                     2017-01-09\n",
       "Temp (°C)                                             -4.82917\n",
       "work_day                                                   Mon\n",
       "month                                                        1\n",
       "Name: 23981, dtype: object"
      ]
     },
     "execution_count": 257,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Looking at the original dataset for the same trip ID, we see that the Original data showed a trip from\n",
    "# Stephenson Avenue (stop ID 7084) to Victoria Park Station (7266), which is more reasonable for a 10 minute trip\n",
    "# But based on the JSON data, this stop ID (7084) is now High Park - Grenadier station\n",
    "\n",
    "bikeData.loc[23981]"
   ]
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}