dataMergingMonthClosed.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "df = pd.read_csv('data/311_Explorer_02.csv', parse_dates=\\\n",
    "                 ['Date Created','Date Closed'],\\\n",
    "                 low_memory = False)\n",
    "df2 = pd.read_csv('data/weather_categorized.csv', parse_dates=\\\n",
    "                 ['date'],\\\n",
    "                 low_memory = False)\n",
    "df3 = pd.read_csv('data/council_cleaned.csv', parse_dates=\\\n",
    "                 ['MEETING_DATE'],\\\n",
    "                 low_memory = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df3 = df3.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df8 = pd.DataFrame({'MEETING_DATE':df3['MEETING_DATE'].unique()})\n",
    "dates = df3['MEETING_DATE'].unique()\n",
    "for x in dates:\n",
    "    council = False\n",
    "    hearing = False\n",
    "    committee = False\n",
    "    v = df3.loc[df3['MEETING_DATE'] == x]['MEETING_TYPE'].values\n",
    "    \n",
    "    if 'Council' in v:\n",
    "        council = True\n",
    "    if 'Hearing' in v:\n",
    "        hearing = True\n",
    "    if 'Committee' in v:\n",
    "        committee = True\n",
    "        \n",
    "    if council and hearing and committee:\n",
    "        df8.loc[df8['MEETING_DATE'] == x, 'MEETING_TYPE'] = 'Council/Hearing/Committee'\n",
    "    elif hearing and committee:\n",
    "        df8.loc[df8['MEETING_DATE'] == x, 'MEETING_TYPE'] = 'Hearing/Committee'    \n",
    "    elif council and hearing:\n",
    "        df8.loc[df8['MEETING_DATE'] == x, 'MEETING_TYPE'] = 'Council/Hearing'\n",
    "    elif council and committee:\n",
    "        df8.loc[df8['MEETING_DATE'] == x, 'MEETING_TYPE'] = 'Council/Committee'\n",
    "    elif council:\n",
    "        df8.loc[df8['MEETING_DATE'] == x, 'MEETING_TYPE'] = 'Council'\n",
    "    elif hearing:\n",
    "        df8.loc[df8['MEETING_DATE'] == x, 'MEETING_TYPE'] = 'Hearing'\n",
    "    elif committee:\n",
    "        df8.loc[df8['MEETING_DATE'] == x,'MEETING_TYPE'] = 'Committee'   \n",
    "df3 = df8"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True    1688\n",
       "Name: Holidays Closed, dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# add holidays to 311 data\n",
    "from datetime import date\n",
    "\n",
    "import holidays\n",
    "\n",
    "df['Holidays Closed'] = np.nan\n",
    "\n",
    "for x in holidays.CA(prov='AB',years=[2013,2014,2015,2016,2017]):\n",
    "    df.loc[df['Date Closed'] == x, 'Holidays Closed'] = True\n",
    "    \n",
    "df['Holidays Closed'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# merge weather and 311\n",
    "df2 = df2.add_suffix(' Closed')\n",
    "df4 = pd.merge(df,df2,how='left',left_on='Date Closed',right_on='date Closed')\n",
    "#df5 = pd.merge(df4,df2,how='left',left_on='Date Closed',right_on='date',suffixes=('_created','_closed'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# merge with council data\n",
    "df3 = df3.add_suffix(' Closed')\n",
    "df7 = pd.merge(df4,df3,how='left',left_on='Date Closed',right_on='MEETING_DATE Closed')\n",
    "#df7 = pd.merge(df6,df3,how='left',left_on='Date Closed',right_on='MEETING_DATE',suffixes=('_created','_closed'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Reference Number', 'Date Created', 'Date Closed', 'Request Status',\n",
       "       'Status Detail', 'Service Category', 'Service Code', 'Business Unit',\n",
       "       'Neighbourhood', 'Community League', 'Ward', 'Address', 'Lat', 'Long',\n",
       "       'Location', 'Ticket Source', 'Calendar Year', 'Days to Resolution',\n",
       "       'Month Created', 'Month Closed', 'Day of Week Request Created',\n",
       "       'Day of Week Request Closed', 'Holidays Closed', 'date Closed',\n",
       "       'avg_hourly_temperature Closed', 'min_windchill Closed',\n",
       "       'avg_dew_point Closed', 'max_wind_gust Closed',\n",
       "       'wind_gust_dir_10s Closed', 'avg_health_index Closed',\n",
       "       'precipitation Closed', 'sunlight Closed', 'MEETING_DATE Closed',\n",
       "       'MEETING_TYPE Closed'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "del df7['Date Created']\n",
    "del df7['Request Status']\n",
    "del df7['Business Unit']\n",
    "del df7['Community League']\n",
    "del df7['Calendar Year']\n",
    "del df7['Day of Week Request Created']\n",
    "del df7['date Closed']\n",
    "del df7['MEETING_DATE Closed']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Reference Number', 'Date Closed', 'Status Detail', 'Service Category',\n",
       "       'Service Code', 'Neighbourhood', 'Ward', 'Address', 'Lat', 'Long',\n",
       "       'Location', 'Ticket Source', 'Days to Resolution', 'Month Created',\n",
       "       'Month Closed', 'Day of Week Request Closed', 'Holidays Closed',\n",
       "       'avg_hourly_temperature Closed', 'min_windchill Closed',\n",
       "       'avg_dew_point Closed', 'max_wind_gust Closed',\n",
       "       'wind_gust_dir_10s Closed', 'avg_health_index Closed',\n",
       "       'precipitation Closed', 'sunlight Closed', 'MEETING_TYPE Closed'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "291516\n"
     ]
    }
   ],
   "source": [
    "print(sum(df7['Service Code'].value_counts(dropna=False)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df7.loc[df7['Service Code'].isnull(), 'Service Code'] = df7.loc[df7['Service Code'].isnull(), 'Service Category']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "291516\n"
     ]
    }
   ],
   "source": [
    "print(sum(df7['Service Code'].value_counts()))\n",
    "del df7['Service Category']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Reference Number</th>\n",
       "      <th>Date Closed</th>\n",
       "      <th>Status Detail</th>\n",
       "      <th>Service Code</th>\n",
       "      <th>Neighbourhood</th>\n",
       "      <th>Ward</th>\n",
       "      <th>Address</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "      <th>Location</th>\n",
       "      <th>...</th>\n",
       "      <th>Holidays Closed</th>\n",
       "      <th>avg_hourly_temperature Closed</th>\n",
       "      <th>min_windchill Closed</th>\n",
       "      <th>avg_dew_point Closed</th>\n",
       "      <th>max_wind_gust Closed</th>\n",
       "      <th>wind_gust_dir_10s Closed</th>\n",
       "      <th>avg_health_index Closed</th>\n",
       "      <th>precipitation Closed</th>\n",
       "      <th>sunlight Closed</th>\n",
       "      <th>MEETING_TYPE Closed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>284799</th>\n",
       "      <td>133341338</td>\n",
       "      <td>2013-05-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Shaw/Telus Box</td>\n",
       "      <td>WESTMOUNT</td>\n",
       "      <td>6.0</td>\n",
       "      <td>124 STREET NW, 110 AVENUE NW</td>\n",
       "      <td>53.557302</td>\n",
       "      <td>-113.535900</td>\n",
       "      <td>(53.5573017377275, -113.535899946293)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>133345190</td>\n",
       "      <td>2013-01-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>ROPER INDUSTRIAL</td>\n",
       "      <td>9.0</td>\n",
       "      <td>MCINTYRE ROAD NW, 75 STREET NW</td>\n",
       "      <td>53.494909</td>\n",
       "      <td>-113.442684</td>\n",
       "      <td>(53.4949091725789, -113.442683685775)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>133350619</td>\n",
       "      <td>2013-01-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>LARKSPUR</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2004 - 38 AVENUE NW</td>\n",
       "      <td>53.477458</td>\n",
       "      <td>-113.372937</td>\n",
       "      <td>(53.4774575415008, -113.372937215704)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>133358214</td>\n",
       "      <td>2013-01-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>GROVENOR</td>\n",
       "      <td>9.0</td>\n",
       "      <td>STONY PLAIN ROAD NW, 146 STREET NW</td>\n",
       "      <td>53.541951</td>\n",
       "      <td>-113.572553</td>\n",
       "      <td>(53.5419506014602, -113.572553447766)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>133362915</td>\n",
       "      <td>2013-01-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>KENSINGTON</td>\n",
       "      <td>9.0</td>\n",
       "      <td>124 STREET NW, 135 AVENUE NW</td>\n",
       "      <td>53.596425</td>\n",
       "      <td>-113.536605</td>\n",
       "      <td>(53.5964246289633, -113.536605453992)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274894</th>\n",
       "      <td>133365471</td>\n",
       "      <td>2013-01-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>HOLYROOD</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9008 - 75 STREET NW</td>\n",
       "      <td>53.525560</td>\n",
       "      <td>-113.443745</td>\n",
       "      <td>(53.525560385314, -113.443745092005)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284800</th>\n",
       "      <td>133562918</td>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>HIGHLANDS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>118 AVENUE NW, 66 STREET NW</td>\n",
       "      <td>53.570359</td>\n",
       "      <td>-113.443007</td>\n",
       "      <td>(53.5703587926438, -113.44300741219)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284801</th>\n",
       "      <td>133720292</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>MCCAULEY</td>\n",
       "      <td>6.0</td>\n",
       "      <td>107A AVENUE NW, 95 STREET NW</td>\n",
       "      <td>53.553895</td>\n",
       "      <td>-113.483594</td>\n",
       "      <td>(53.5538950664834, -113.483593856346)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284802</th>\n",
       "      <td>133780574</td>\n",
       "      <td>2013-05-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Newspaper Box/Sign</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>6.0</td>\n",
       "      <td>104 AVENUE NW, 116 STREET [NORTHBOUND SIDE] NW</td>\n",
       "      <td>53.546222</td>\n",
       "      <td>-113.521299</td>\n",
       "      <td>(53.5462223336037, -113.521298594868)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276418</th>\n",
       "      <td>133783648</td>\n",
       "      <td>2013-01-05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>DAVIES INDUSTRIAL EAST</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6145 - 75 STREET NW</td>\n",
       "      <td>53.499701</td>\n",
       "      <td>-113.439164</td>\n",
       "      <td>(53.4997013498849, -113.439163787116)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>133793810</td>\n",
       "      <td>2013-01-05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>RAMPART INDUSTRIAL</td>\n",
       "      <td>9.0</td>\n",
       "      <td>142 STREET NW, 145 AVENUE NW</td>\n",
       "      <td>53.607870</td>\n",
       "      <td>-113.569706</td>\n",
       "      <td>(53.607869643367, -113.569705706795)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>133800575</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Shaw/Telus Box</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>6.0</td>\n",
       "      <td>102 AVENUE NW, 121 STREET NW</td>\n",
       "      <td>53.543026</td>\n",
       "      <td>-113.530827</td>\n",
       "      <td>(53.5430264936345, -113.530826745239)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>133801539</td>\n",
       "      <td>2013-01-05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>BONNIE DOON</td>\n",
       "      <td>9.0</td>\n",
       "      <td>97 STREET NW, 95 AVENUE NW</td>\n",
       "      <td>53.531987</td>\n",
       "      <td>-113.479247</td>\n",
       "      <td>(53.5319872998896, -113.479246806762)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284803</th>\n",
       "      <td>133810231</td>\n",
       "      <td>2013-01-06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>FOREST HEIGHTS</td>\n",
       "      <td>8.0</td>\n",
       "      <td>101 AVENUE NW, WAYNE GRETZKY DRIVE [NORTHBOUND...</td>\n",
       "      <td>53.541217</td>\n",
       "      <td>-113.443425</td>\n",
       "      <td>(53.5412168098304, -113.443425113209)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>WNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284804</th>\n",
       "      <td>133810779</td>\n",
       "      <td>2013-01-07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>CAPILANO</td>\n",
       "      <td>8.0</td>\n",
       "      <td>CAPILANO STREET NW, 106A AVENUE NW</td>\n",
       "      <td>53.552084</td>\n",
       "      <td>-113.421402</td>\n",
       "      <td>(53.5520841342649, -113.421402481858)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276421</th>\n",
       "      <td>133813341</td>\n",
       "      <td>2013-01-07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>CRAWFORD PLAINS</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1108 - 49 STREET NW</td>\n",
       "      <td>53.440549</td>\n",
       "      <td>-113.415609</td>\n",
       "      <td>(53.4405492635165, -113.415608529761)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270907</th>\n",
       "      <td>133867738</td>\n",
       "      <td>2013-01-08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>SPRUCE AVENUE</td>\n",
       "      <td>2.0</td>\n",
       "      <td>115 AVENUE NW, 101 STREET NW</td>\n",
       "      <td>53.565770</td>\n",
       "      <td>-113.493701</td>\n",
       "      <td>(53.5657699390287, -113.493700816862)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>WNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289926</th>\n",
       "      <td>133867955</td>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>SPRUCE AVENUE</td>\n",
       "      <td>2.0</td>\n",
       "      <td>116 AVENUE NW, 101 STREET NW</td>\n",
       "      <td>53.567309</td>\n",
       "      <td>-113.493715</td>\n",
       "      <td>(53.5673093779666, -113.493714799226)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284805</th>\n",
       "      <td>133918986</td>\n",
       "      <td>2013-01-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>RAMPART INDUSTRIAL</td>\n",
       "      <td>2.0</td>\n",
       "      <td>142 STREET NW, 145 AVENUE NW</td>\n",
       "      <td>53.607870</td>\n",
       "      <td>-113.569706</td>\n",
       "      <td>(53.607869643367, -113.569705706795)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274028</th>\n",
       "      <td>133936021</td>\n",
       "      <td>2013-05-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada Post Mail box</td>\n",
       "      <td>GREENVIEW</td>\n",
       "      <td>11.0</td>\n",
       "      <td>GRAND MEADOW CRESCENT NW, 62 STREET NW</td>\n",
       "      <td>53.475362</td>\n",
       "      <td>-113.433500</td>\n",
       "      <td>(53.4753623445487, -113.433500336412)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>very humid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16+</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255442</th>\n",
       "      <td>133951927</td>\n",
       "      <td>2013-06-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>INGLEWOOD</td>\n",
       "      <td>2.0</td>\n",
       "      <td>115 AVENUE NW, 124 STREET NW</td>\n",
       "      <td>53.565252</td>\n",
       "      <td>-113.535946</td>\n",
       "      <td>(53.5652518730656, -113.535946468817)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>comfortable</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>16+</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274029</th>\n",
       "      <td>133991035</td>\n",
       "      <td>2014-06-26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>BELLEVUE</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11202 - 68 STREET NW</td>\n",
       "      <td>53.563878</td>\n",
       "      <td>-113.442475</td>\n",
       "      <td>(53.5638779259793, -113.442474522139)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>very humid</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>16+</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272239</th>\n",
       "      <td>133991130</td>\n",
       "      <td>2014-06-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>VIRGINIA PARK</td>\n",
       "      <td>7.0</td>\n",
       "      <td>74 STREET NW, 112 AVENUE NW</td>\n",
       "      <td>53.561873</td>\n",
       "      <td>-113.451552</td>\n",
       "      <td>(53.5618733272057, -113.451552113361)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16+</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284806</th>\n",
       "      <td>133993315</td>\n",
       "      <td>2013-05-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada Post Mail box</td>\n",
       "      <td>BULYEA HEIGHTS</td>\n",
       "      <td>9.0</td>\n",
       "      <td>BUCHANAN ROAD NW, BULYEA ROAD NW, BURLEY DRIVE NW</td>\n",
       "      <td>53.469187</td>\n",
       "      <td>-113.572153</td>\n",
       "      <td>(53.469186545668, -113.572152582369)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>134009024</td>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>ANTHONY HENDAY ENERGY PARK</td>\n",
       "      <td>8.0</td>\n",
       "      <td>66 STREET [NORTHBOUND SIDE] NW, ANTHONY HENDAY...</td>\n",
       "      <td>53.645809</td>\n",
       "      <td>-113.439205</td>\n",
       "      <td>(53.6458092384517, -113.439204665068)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284807</th>\n",
       "      <td>134010455</td>\n",
       "      <td>2013-01-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>ANTHONY HENDAY ENERGY PARK</td>\n",
       "      <td>4.0</td>\n",
       "      <td>66 STREET [NORTHBOUND SIDE] NW, ANTHONY HENDAY...</td>\n",
       "      <td>53.645809</td>\n",
       "      <td>-113.439205</td>\n",
       "      <td>(53.6458092384517, -113.439204665068)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>high</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284808</th>\n",
       "      <td>134016156</td>\n",
       "      <td>2013-01-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>HAWIN PARK ESTATE INDUSTRIAL</td>\n",
       "      <td>1.0</td>\n",
       "      <td>121A AVENUE NW, 156 STREET NW</td>\n",
       "      <td>53.573554</td>\n",
       "      <td>-113.590397</td>\n",
       "      <td>(53.5735538623136, -113.590396684428)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270201</th>\n",
       "      <td>134022420</td>\n",
       "      <td>2013-01-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>CHAMBERY</td>\n",
       "      <td>3.0</td>\n",
       "      <td>110 STREET NW, 176 AVENUE NW</td>\n",
       "      <td>53.639782</td>\n",
       "      <td>-113.513807</td>\n",
       "      <td>(53.6397815788972, -113.51380695011)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284809</th>\n",
       "      <td>134025493</td>\n",
       "      <td>2013-01-12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>MEYOKUMIN</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1743 - 65 STREET NW</td>\n",
       "      <td>53.448017</td>\n",
       "      <td>-113.433263</td>\n",
       "      <td>(53.4480170562162, -113.433262534227)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262102</th>\n",
       "      <td>134120282</td>\n",
       "      <td>2013-01-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>GLENORA</td>\n",
       "      <td>6.0</td>\n",
       "      <td>STONY PLAIN ROAD NW, 139 STREET NW, 102 AVENUE NW</td>\n",
       "      <td>53.543036</td>\n",
       "      <td>-113.561361</td>\n",
       "      <td>(53.5430356122944, -113.561361441275)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282365</th>\n",
       "      <td>8016889146</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Restricted Residential</td>\n",
       "      <td>SOUTH TERWILLEGAR</td>\n",
       "      <td>9.0</td>\n",
       "      <td>7293 SOUTH TERWILLEGAR DRIVE NW</td>\n",
       "      <td>53.434932</td>\n",
       "      <td>-113.580024</td>\n",
       "      <td>(53.4349323033201, -113.580023976462)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282367</th>\n",
       "      <td>8016889171</td>\n",
       "      <td>2017-11-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sign Request</td>\n",
       "      <td>WEBBER GREENS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>SECORD BOULEVARD NW, WINTERBURN ROAD NW</td>\n",
       "      <td>53.533699</td>\n",
       "      <td>-113.689003</td>\n",
       "      <td>(53.5336987787328, -113.689003101287)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282808</th>\n",
       "      <td>8016889179</td>\n",
       "      <td>2017-11-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Signal Timing (Left Turn Arrow)</td>\n",
       "      <td>WEBBER GREENS</td>\n",
       "      <td>1.0</td>\n",
       "      <td>SECORD BOULEVARD NW, WINTERBURN ROAD NW</td>\n",
       "      <td>53.533699</td>\n",
       "      <td>-113.689003</td>\n",
       "      <td>(53.5336987787328, -113.689003101287)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282376</th>\n",
       "      <td>8016889189</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>Redirected to Other Government Agency</td>\n",
       "      <td>Road Dip</td>\n",
       "      <td>ALLENDALE</td>\n",
       "      <td>10.0</td>\n",
       "      <td>69 AVENUE NW, 106 STREET NW</td>\n",
       "      <td>53.505633</td>\n",
       "      <td>-113.504412</td>\n",
       "      <td>(53.5056328706381, -113.504411754936)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282383</th>\n",
       "      <td>8016889229</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Restricted Residential</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10175 114 STREET NW</td>\n",
       "      <td>53.542528</td>\n",
       "      <td>-113.517106</td>\n",
       "      <td>(53.5425275514904, -113.51710601304)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238865</th>\n",
       "      <td>8016889304</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Warning Issued, No Further Action at this Time</td>\n",
       "      <td>Tow Away Zone</td>\n",
       "      <td>THE HAMPTONS</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1165 HAYS DRIVE NW</td>\n",
       "      <td>53.482611</td>\n",
       "      <td>-113.671299</td>\n",
       "      <td>(53.4826109134524, -113.671298916303)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238888</th>\n",
       "      <td>8016889404</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Disable Stall</td>\n",
       "      <td>STRATHCONA</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10040 82 AVENUE NW</td>\n",
       "      <td>53.518382</td>\n",
       "      <td>-113.491025</td>\n",
       "      <td>(53.5183817602085, -113.491024742918)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238906</th>\n",
       "      <td>8016889472</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>EASTWOOD</td>\n",
       "      <td>7.0</td>\n",
       "      <td>12418 82 STREET NW</td>\n",
       "      <td>53.580446</td>\n",
       "      <td>-113.467811</td>\n",
       "      <td>(53.5804459303704, -113.467810982877)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238907</th>\n",
       "      <td>8016889484</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Disable Stall</td>\n",
       "      <td>HADDOW</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2508C HANNA CRESCENT NW</td>\n",
       "      <td>53.450271</td>\n",
       "      <td>-113.592849</td>\n",
       "      <td>(53.45027109225, -113.592848838106)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287718</th>\n",
       "      <td>8016889552</td>\n",
       "      <td>2017-11-02</td>\n",
       "      <td>Deferred-Future Work Planned.</td>\n",
       "      <td>Road</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>6.0</td>\n",
       "      <td>JASPER AVENUE NW, 112 STREET NW</td>\n",
       "      <td>53.540942</td>\n",
       "      <td>-113.513941</td>\n",
       "      <td>(53.540942178767, -113.513940964664)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287719</th>\n",
       "      <td>8016889563</td>\n",
       "      <td>2017-11-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sign Request</td>\n",
       "      <td>THE HAMPTONS</td>\n",
       "      <td>5.0</td>\n",
       "      <td>LESSARD ROAD NW, 199 STREET NW</td>\n",
       "      <td>53.478465</td>\n",
       "      <td>-113.666812</td>\n",
       "      <td>(53.4784649067264, -113.666811915213)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281384</th>\n",
       "      <td>8016889571</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road Dip</td>\n",
       "      <td>ORMSBY PLACE</td>\n",
       "      <td>5.0</td>\n",
       "      <td>ORMSBY ROAD WEST NW, 188 STREET NW</td>\n",
       "      <td>53.499171</td>\n",
       "      <td>-113.648685</td>\n",
       "      <td>(53.4991707516991, -113.648685179994)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282391</th>\n",
       "      <td>8016889587</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road</td>\n",
       "      <td>JACKSON HEIGHTS</td>\n",
       "      <td>12.0</td>\n",
       "      <td>WHITEMUD DRIVE NW, 34 STREET NW</td>\n",
       "      <td>53.487196</td>\n",
       "      <td>-113.393796</td>\n",
       "      <td>(53.4871958016464, -113.393796006368)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238996</th>\n",
       "      <td>8016889589</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Enforcement Action Taken</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>NORTHMOUNT</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8212 137 AVENUE NW</td>\n",
       "      <td>53.600318</td>\n",
       "      <td>-113.468785</td>\n",
       "      <td>(53.6003181983512, -113.468784896396)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287720</th>\n",
       "      <td>8016889595</td>\n",
       "      <td>2017-11-02</td>\n",
       "      <td>Citizen Complied</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>TERWILLEGAR TOWNE</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1811 TOWNE CENTRE BOULEVARD NW</td>\n",
       "      <td>53.447216</td>\n",
       "      <td>-113.577329</td>\n",
       "      <td>(53.4472158300965, -113.577328856391)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273937</th>\n",
       "      <td>8016889600</td>\n",
       "      <td>2017-11-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Signal Timing (Green Light)</td>\n",
       "      <td>POLLARD MEADOWS</td>\n",
       "      <td>12.0</td>\n",
       "      <td>50 STREET NW, 23 AVENUE NW</td>\n",
       "      <td>53.454760</td>\n",
       "      <td>-113.420078</td>\n",
       "      <td>(53.4547603946352, -113.420077786197)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>SE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239053</th>\n",
       "      <td>8016889719</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>HIGHLANDS</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5703 118 AVENUE NW</td>\n",
       "      <td>53.570097</td>\n",
       "      <td>-113.429476</td>\n",
       "      <td>(53.5700971256476, -113.429475914923)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282392</th>\n",
       "      <td>8016889728</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>HILLVIEW</td>\n",
       "      <td>11.0</td>\n",
       "      <td>306 WOODVALE ROAD WEST NW</td>\n",
       "      <td>53.467187</td>\n",
       "      <td>-113.431037</td>\n",
       "      <td>(53.467187032915, -113.431037495228)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282393</th>\n",
       "      <td>8016889755</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>Citizen Complied</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>IDYLWYLDE</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7612 88 AVENUE NW</td>\n",
       "      <td>53.523964</td>\n",
       "      <td>-113.444980</td>\n",
       "      <td>(53.5239639078718, -113.444979716564)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239088</th>\n",
       "      <td>8016889763</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>BRINTNELL</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16413 49 STREET NW</td>\n",
       "      <td>53.624703</td>\n",
       "      <td>-113.410601</td>\n",
       "      <td>(53.624703206057, -113.41060092694)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239095</th>\n",
       "      <td>8016889804</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Enforcement Action Taken</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>RUTHERFORD</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11606 11 AVENUE SW</td>\n",
       "      <td>53.423625</td>\n",
       "      <td>-113.524126</td>\n",
       "      <td>(53.4236247809697, -113.52412604561)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282411</th>\n",
       "      <td>8016889814</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Paving</td>\n",
       "      <td>CAPILANO</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10655 69 STREET NW</td>\n",
       "      <td>53.552294</td>\n",
       "      <td>-113.434740</td>\n",
       "      <td>(53.5522938710843, -113.434740328361)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282415</th>\n",
       "      <td>8016889823</td>\n",
       "      <td>2017-11-03</td>\n",
       "      <td>Deferred-Future Work Planned.</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>ROYAL GARDENS</td>\n",
       "      <td>10.0</td>\n",
       "      <td>115 STREET NW, 40 AVENUE NW</td>\n",
       "      <td>53.476290</td>\n",
       "      <td>-113.530270</td>\n",
       "      <td>(53.4762898987616, -113.530270088611)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282804</th>\n",
       "      <td>8016889844</td>\n",
       "      <td>2017-11-06</td>\n",
       "      <td>Assessed-No Action Required</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>CALLAGHAN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>JAMES MOWATT TRAIL SW, 17 AVENUE SW</td>\n",
       "      <td>53.413897</td>\n",
       "      <td>-113.522821</td>\n",
       "      <td>(53.4138965183847, -113.522820816719)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287721</th>\n",
       "      <td>8016889895</td>\n",
       "      <td>2017-11-02</td>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>QUEEN ALEXANDRA</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10525 76 AVENUE NW</td>\n",
       "      <td>53.512128</td>\n",
       "      <td>-113.501833</td>\n",
       "      <td>(53.5121280621379, -113.501833444329)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239156</th>\n",
       "      <td>8016889901</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Broken Manhole Cover</td>\n",
       "      <td>BLACKMUD CREEK</td>\n",
       "      <td>9.0</td>\n",
       "      <td>970 BLACKMUD CREEK CRESCENT SW</td>\n",
       "      <td>53.419035</td>\n",
       "      <td>-113.511421</td>\n",
       "      <td>(53.4190354620691, -113.511421201755)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282401</th>\n",
       "      <td>8016889974</td>\n",
       "      <td>2017-11-04</td>\n",
       "      <td>Citizen Complied</td>\n",
       "      <td>Abandoned Vehicle</td>\n",
       "      <td>CHAPPELLE AREA</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2735 COUGHLAN GREEN SW</td>\n",
       "      <td>53.409575</td>\n",
       "      <td>-113.583116</td>\n",
       "      <td>(53.4095752014568, -113.583116185724)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269793</th>\n",
       "      <td>8016890048</td>\n",
       "      <td>2017-11-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road</td>\n",
       "      <td>LYNNWOOD</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8101 156 STREET NW</td>\n",
       "      <td>53.515249</td>\n",
       "      <td>-113.590070</td>\n",
       "      <td>(53.5152488340586, -113.590070274486)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282416</th>\n",
       "      <td>8016890086</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>Enforcement Action Taken</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>DOWNTOWN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10503 98 AVENUE NW</td>\n",
       "      <td>53.535275</td>\n",
       "      <td>-113.501607</td>\n",
       "      <td>(53.5352751534937, -113.501607044439)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282417</th>\n",
       "      <td>8016890096</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>DOWNTOWN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10503 98 AVENUE NW</td>\n",
       "      <td>53.535275</td>\n",
       "      <td>-113.501607</td>\n",
       "      <td>(53.5352751534937, -113.501607044439)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>291516 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Reference Number Date Closed  \\\n",
       "284799         133341338  2013-05-16   \n",
       "0              133345190  2013-01-03   \n",
       "1              133350619  2013-01-03   \n",
       "2              133358214  2013-01-03   \n",
       "3              133362915  2013-01-03   \n",
       "274894         133365471  2013-01-03   \n",
       "284800         133562918  2013-04-30   \n",
       "284801         133720292  2013-01-04   \n",
       "284802         133780574  2013-05-15   \n",
       "276418         133783648  2013-01-05   \n",
       "4              133793810  2013-01-05   \n",
       "251            133800575  2013-01-04   \n",
       "5              133801539  2013-01-05   \n",
       "284803         133810231  2013-01-06   \n",
       "284804         133810779  2013-01-07   \n",
       "276421         133813341  2013-01-07   \n",
       "270907         133867738  2013-01-08   \n",
       "289926         133867955  2013-04-30   \n",
       "284805         133918986  2013-01-09   \n",
       "274028         133936021  2013-05-31   \n",
       "255442         133951927  2013-06-25   \n",
       "274029         133991035  2014-06-26   \n",
       "272239         133991130  2014-06-17   \n",
       "284806         133993315  2013-05-03   \n",
       "11             134009024  2013-04-30   \n",
       "284807         134010455  2013-01-10   \n",
       "284808         134016156  2013-01-11   \n",
       "270201         134022420  2013-01-11   \n",
       "284809         134025493  2013-01-12   \n",
       "262102         134120282  2013-01-18   \n",
       "...                  ...         ...   \n",
       "282365        8016889146  2017-11-01   \n",
       "282367        8016889171  2017-11-02   \n",
       "282808        8016889179  2017-11-10   \n",
       "282376        8016889189  2017-11-01   \n",
       "282383        8016889229  2017-11-01   \n",
       "238865        8016889304  2017-10-31   \n",
       "238888        8016889404  2017-10-31   \n",
       "238906        8016889472  2017-10-31   \n",
       "238907        8016889484  2017-10-31   \n",
       "287718        8016889552  2017-11-02   \n",
       "287719        8016889563  2017-11-02   \n",
       "281384        8016889571  2017-11-01   \n",
       "282391        8016889587  2017-11-01   \n",
       "238996        8016889589  2017-10-31   \n",
       "287720        8016889595  2017-11-02   \n",
       "273937        8016889600  2017-11-15   \n",
       "239053        8016889719  2017-10-31   \n",
       "282392        8016889728  2017-11-01   \n",
       "282393        8016889755  2017-11-01   \n",
       "239088        8016889763  2017-10-31   \n",
       "239095        8016889804  2017-10-31   \n",
       "282411        8016889814  2017-11-01   \n",
       "282415        8016889823  2017-11-03   \n",
       "282804        8016889844  2017-11-06   \n",
       "287721        8016889895  2017-11-02   \n",
       "239156        8016889901  2017-11-01   \n",
       "282401        8016889974  2017-11-04   \n",
       "269793        8016890048  2017-11-03   \n",
       "282416        8016890086  2017-11-01   \n",
       "282417        8016890096  2017-11-01   \n",
       "\n",
       "                                         Status Detail  \\\n",
       "284799                                             NaN   \n",
       "0                                                  NaN   \n",
       "1                                                  NaN   \n",
       "2                                                  NaN   \n",
       "3                                                  NaN   \n",
       "274894                                             NaN   \n",
       "284800                                             NaN   \n",
       "284801                                             NaN   \n",
       "284802                                             NaN   \n",
       "276418                                             NaN   \n",
       "4                                                  NaN   \n",
       "251                                                NaN   \n",
       "5                                                  NaN   \n",
       "284803                                             NaN   \n",
       "284804                                             NaN   \n",
       "276421                                             NaN   \n",
       "270907                                             NaN   \n",
       "289926                                             NaN   \n",
       "284805                                             NaN   \n",
       "274028                                             NaN   \n",
       "255442                                             NaN   \n",
       "274029                                             NaN   \n",
       "272239                                             NaN   \n",
       "284806                                             NaN   \n",
       "11                                                 NaN   \n",
       "284807                                             NaN   \n",
       "284808                                             NaN   \n",
       "270201                                             NaN   \n",
       "284809                                             NaN   \n",
       "262102                                             NaN   \n",
       "...                                                ...   \n",
       "282365                       Vehicle Gone Upon Arrival   \n",
       "282367                                             NaN   \n",
       "282808                                             NaN   \n",
       "282376           Redirected to Other Government Agency   \n",
       "282383           Does Not Meet Bylaw Offence Standards   \n",
       "238865  Warning Issued, No Further Action at this Time   \n",
       "238888           Does Not Meet Bylaw Offence Standards   \n",
       "238906                                             NaN   \n",
       "238907                       Vehicle Gone Upon Arrival   \n",
       "287718                   Deferred-Future Work Planned.   \n",
       "287719                                             NaN   \n",
       "281384                                             NaN   \n",
       "282391                                             NaN   \n",
       "238996                        Enforcement Action Taken   \n",
       "287720                                Citizen Complied   \n",
       "273937                                             NaN   \n",
       "239053           Does Not Meet Bylaw Offence Standards   \n",
       "282392                       Vehicle Gone Upon Arrival   \n",
       "282393                                Citizen Complied   \n",
       "239088                       Vehicle Gone Upon Arrival   \n",
       "239095                        Enforcement Action Taken   \n",
       "282411                                             NaN   \n",
       "282415                   Deferred-Future Work Planned.   \n",
       "282804                     Assessed-No Action Required   \n",
       "287721                       Vehicle Gone Upon Arrival   \n",
       "239156                                             NaN   \n",
       "282401                                Citizen Complied   \n",
       "269793                                             NaN   \n",
       "282416                        Enforcement Action Taken   \n",
       "282417           Does Not Meet Bylaw Offence Standards   \n",
       "\n",
       "                           Service Code                 Neighbourhood  Ward  \\\n",
       "284799                   Shaw/Telus Box                     WESTMOUNT   6.0   \n",
       "0                           Dead Animal              ROPER INDUSTRIAL   9.0   \n",
       "1                           Dead Animal                      LARKSPUR   9.0   \n",
       "2                           Dead Animal                      GROVENOR   9.0   \n",
       "3                           Dead Animal                    KENSINGTON   9.0   \n",
       "274894                      Dead Animal                      HOLYROOD   8.0   \n",
       "284800                      Dead Animal                     HIGHLANDS   7.0   \n",
       "284801                      Dead Animal                      MCCAULEY   6.0   \n",
       "284802               Newspaper Box/Sign                        OLIVER   6.0   \n",
       "276418                      Dead Animal        DAVIES INDUSTRIAL EAST  11.0   \n",
       "4                           Dead Animal            RAMPART INDUSTRIAL   9.0   \n",
       "251                      Shaw/Telus Box                        OLIVER   6.0   \n",
       "5                           Dead Animal                   BONNIE DOON   9.0   \n",
       "284803                      Dead Animal                FOREST HEIGHTS   8.0   \n",
       "284804                      Dead Animal                      CAPILANO   8.0   \n",
       "276421                      Dead Animal               CRAWFORD PLAINS  12.0   \n",
       "270907                      Dead Animal                 SPRUCE AVENUE   2.0   \n",
       "289926                      Dead Animal                 SPRUCE AVENUE   2.0   \n",
       "284805                      Dead Animal            RAMPART INDUSTRIAL   2.0   \n",
       "274028             Canada Post Mail box                     GREENVIEW  11.0   \n",
       "255442     EPCOR Power Box/Street Light                     INGLEWOOD   2.0   \n",
       "274029     EPCOR Power Box/Street Light                      BELLEVUE   7.0   \n",
       "272239     EPCOR Power Box/Street Light                 VIRGINIA PARK   7.0   \n",
       "284806             Canada Post Mail box                BULYEA HEIGHTS   9.0   \n",
       "11                          Dead Animal    ANTHONY HENDAY ENERGY PARK   8.0   \n",
       "284807                      Dead Animal    ANTHONY HENDAY ENERGY PARK   4.0   \n",
       "284808                      Dead Animal  HAWIN PARK ESTATE INDUSTRIAL   1.0   \n",
       "270201                      Dead Animal                      CHAMBERY   3.0   \n",
       "284809                      Dead Animal                     MEYOKUMIN  11.0   \n",
       "262102                      Dead Animal                       GLENORA   6.0   \n",
       "...                                 ...                           ...   ...   \n",
       "282365           Restricted Residential             SOUTH TERWILLEGAR   9.0   \n",
       "282367                     Sign Request                 WEBBER GREENS   1.0   \n",
       "282808  Signal Timing (Left Turn Arrow)                 WEBBER GREENS   1.0   \n",
       "282376                         Road Dip                     ALLENDALE  10.0   \n",
       "282383           Restricted Residential                        OLIVER   6.0   \n",
       "238865                    Tow Away Zone                  THE HAMPTONS   5.0   \n",
       "238888                    Disable Stall                    STRATHCONA   8.0   \n",
       "238906                   Safety & Other                      EASTWOOD   7.0   \n",
       "238907                    Disable Stall                        HADDOW   9.0   \n",
       "287718                             Road                        OLIVER   6.0   \n",
       "287719                     Sign Request                  THE HAMPTONS   5.0   \n",
       "281384                         Road Dip                  ORMSBY PLACE   5.0   \n",
       "282391                             Road               JACKSON HEIGHTS  12.0   \n",
       "238996                   Safety & Other                    NORTHMOUNT   7.0   \n",
       "287720                   Safety & Other             TERWILLEGAR TOWNE   9.0   \n",
       "273937      Signal Timing (Green Light)               POLLARD MEADOWS  12.0   \n",
       "239053                   Safety & Other                     HIGHLANDS   7.0   \n",
       "282392                   Safety & Other                      HILLVIEW  11.0   \n",
       "282393                   Safety & Other                     IDYLWYLDE   8.0   \n",
       "239088                   Safety & Other                     BRINTNELL   4.0   \n",
       "239095                   Safety & Other                    RUTHERFORD   9.0   \n",
       "282411                           Paving                      CAPILANO   8.0   \n",
       "282415                          Pothole                 ROYAL GARDENS  10.0   \n",
       "282804                          Pothole                     CALLAGHAN   9.0   \n",
       "287721                   Safety & Other               QUEEN ALEXANDRA   8.0   \n",
       "239156             Broken Manhole Cover                BLACKMUD CREEK   9.0   \n",
       "282401                Abandoned Vehicle                CHAPPELLE AREA   9.0   \n",
       "269793                             Road                      LYNNWOOD   5.0   \n",
       "282416                   Safety & Other                      DOWNTOWN   6.0   \n",
       "282417                   Safety & Other                      DOWNTOWN   6.0   \n",
       "\n",
       "                                                  Address        Lat  \\\n",
       "284799                       124 STREET NW, 110 AVENUE NW  53.557302   \n",
       "0                          MCINTYRE ROAD NW, 75 STREET NW  53.494909   \n",
       "1                                     2004 - 38 AVENUE NW  53.477458   \n",
       "2                      STONY PLAIN ROAD NW, 146 STREET NW  53.541951   \n",
       "3                            124 STREET NW, 135 AVENUE NW  53.596425   \n",
       "274894                                9008 - 75 STREET NW  53.525560   \n",
       "284800                        118 AVENUE NW, 66 STREET NW  53.570359   \n",
       "284801                       107A AVENUE NW, 95 STREET NW  53.553895   \n",
       "284802     104 AVENUE NW, 116 STREET [NORTHBOUND SIDE] NW  53.546222   \n",
       "276418                                6145 - 75 STREET NW  53.499701   \n",
       "4                            142 STREET NW, 145 AVENUE NW  53.607870   \n",
       "251                          102 AVENUE NW, 121 STREET NW  53.543026   \n",
       "5                              97 STREET NW, 95 AVENUE NW  53.531987   \n",
       "284803  101 AVENUE NW, WAYNE GRETZKY DRIVE [NORTHBOUND...  53.541217   \n",
       "284804                 CAPILANO STREET NW, 106A AVENUE NW  53.552084   \n",
       "276421                                1108 - 49 STREET NW  53.440549   \n",
       "270907                       115 AVENUE NW, 101 STREET NW  53.565770   \n",
       "289926                       116 AVENUE NW, 101 STREET NW  53.567309   \n",
       "284805                       142 STREET NW, 145 AVENUE NW  53.607870   \n",
       "274028             GRAND MEADOW CRESCENT NW, 62 STREET NW  53.475362   \n",
       "255442                       115 AVENUE NW, 124 STREET NW  53.565252   \n",
       "274029                               11202 - 68 STREET NW  53.563878   \n",
       "272239                        74 STREET NW, 112 AVENUE NW  53.561873   \n",
       "284806  BUCHANAN ROAD NW, BULYEA ROAD NW, BURLEY DRIVE NW  53.469187   \n",
       "11      66 STREET [NORTHBOUND SIDE] NW, ANTHONY HENDAY...  53.645809   \n",
       "284807  66 STREET [NORTHBOUND SIDE] NW, ANTHONY HENDAY...  53.645809   \n",
       "284808                      121A AVENUE NW, 156 STREET NW  53.573554   \n",
       "270201                       110 STREET NW, 176 AVENUE NW  53.639782   \n",
       "284809                                1743 - 65 STREET NW  53.448017   \n",
       "262102  STONY PLAIN ROAD NW, 139 STREET NW, 102 AVENUE NW  53.543036   \n",
       "...                                                   ...        ...   \n",
       "282365                    7293 SOUTH TERWILLEGAR DRIVE NW  53.434932   \n",
       "282367            SECORD BOULEVARD NW, WINTERBURN ROAD NW  53.533699   \n",
       "282808            SECORD BOULEVARD NW, WINTERBURN ROAD NW  53.533699   \n",
       "282376                        69 AVENUE NW, 106 STREET NW  53.505633   \n",
       "282383                                10175 114 STREET NW  53.542528   \n",
       "238865                                 1165 HAYS DRIVE NW  53.482611   \n",
       "238888                                 10040 82 AVENUE NW  53.518382   \n",
       "238906                                 12418 82 STREET NW  53.580446   \n",
       "238907                            2508C HANNA CRESCENT NW  53.450271   \n",
       "287718                    JASPER AVENUE NW, 112 STREET NW  53.540942   \n",
       "287719                     LESSARD ROAD NW, 199 STREET NW  53.478465   \n",
       "281384                 ORMSBY ROAD WEST NW, 188 STREET NW  53.499171   \n",
       "282391                    WHITEMUD DRIVE NW, 34 STREET NW  53.487196   \n",
       "238996                                 8212 137 AVENUE NW  53.600318   \n",
       "287720                     1811 TOWNE CENTRE BOULEVARD NW  53.447216   \n",
       "273937                         50 STREET NW, 23 AVENUE NW  53.454760   \n",
       "239053                                 5703 118 AVENUE NW  53.570097   \n",
       "282392                          306 WOODVALE ROAD WEST NW  53.467187   \n",
       "282393                                  7612 88 AVENUE NW  53.523964   \n",
       "239088                                 16413 49 STREET NW  53.624703   \n",
       "239095                                 11606 11 AVENUE SW  53.423625   \n",
       "282411                                 10655 69 STREET NW  53.552294   \n",
       "282415                        115 STREET NW, 40 AVENUE NW  53.476290   \n",
       "282804                JAMES MOWATT TRAIL SW, 17 AVENUE SW  53.413897   \n",
       "287721                                 10525 76 AVENUE NW  53.512128   \n",
       "239156                     970 BLACKMUD CREEK CRESCENT SW  53.419035   \n",
       "282401                             2735 COUGHLAN GREEN SW  53.409575   \n",
       "269793                                 8101 156 STREET NW  53.515249   \n",
       "282416                                 10503 98 AVENUE NW  53.535275   \n",
       "282417                                 10503 98 AVENUE NW  53.535275   \n",
       "\n",
       "              Long                               Location         ...          \\\n",
       "284799 -113.535900  (53.5573017377275, -113.535899946293)         ...           \n",
       "0      -113.442684  (53.4949091725789, -113.442683685775)         ...           \n",
       "1      -113.372937  (53.4774575415008, -113.372937215704)         ...           \n",
       "2      -113.572553  (53.5419506014602, -113.572553447766)         ...           \n",
       "3      -113.536605  (53.5964246289633, -113.536605453992)         ...           \n",
       "274894 -113.443745   (53.525560385314, -113.443745092005)         ...           \n",
       "284800 -113.443007   (53.5703587926438, -113.44300741219)         ...           \n",
       "284801 -113.483594  (53.5538950664834, -113.483593856346)         ...           \n",
       "284802 -113.521299  (53.5462223336037, -113.521298594868)         ...           \n",
       "276418 -113.439164  (53.4997013498849, -113.439163787116)         ...           \n",
       "4      -113.569706   (53.607869643367, -113.569705706795)         ...           \n",
       "251    -113.530827  (53.5430264936345, -113.530826745239)         ...           \n",
       "5      -113.479247  (53.5319872998896, -113.479246806762)         ...           \n",
       "284803 -113.443425  (53.5412168098304, -113.443425113209)         ...           \n",
       "284804 -113.421402  (53.5520841342649, -113.421402481858)         ...           \n",
       "276421 -113.415609  (53.4405492635165, -113.415608529761)         ...           \n",
       "270907 -113.493701  (53.5657699390287, -113.493700816862)         ...           \n",
       "289926 -113.493715  (53.5673093779666, -113.493714799226)         ...           \n",
       "284805 -113.569706   (53.607869643367, -113.569705706795)         ...           \n",
       "274028 -113.433500  (53.4753623445487, -113.433500336412)         ...           \n",
       "255442 -113.535946  (53.5652518730656, -113.535946468817)         ...           \n",
       "274029 -113.442475  (53.5638779259793, -113.442474522139)         ...           \n",
       "272239 -113.451552  (53.5618733272057, -113.451552113361)         ...           \n",
       "284806 -113.572153   (53.469186545668, -113.572152582369)         ...           \n",
       "11     -113.439205  (53.6458092384517, -113.439204665068)         ...           \n",
       "284807 -113.439205  (53.6458092384517, -113.439204665068)         ...           \n",
       "284808 -113.590397  (53.5735538623136, -113.590396684428)         ...           \n",
       "270201 -113.513807   (53.6397815788972, -113.51380695011)         ...           \n",
       "284809 -113.433263  (53.4480170562162, -113.433262534227)         ...           \n",
       "262102 -113.561361  (53.5430356122944, -113.561361441275)         ...           \n",
       "...            ...                                    ...         ...           \n",
       "282365 -113.580024  (53.4349323033201, -113.580023976462)         ...           \n",
       "282367 -113.689003  (53.5336987787328, -113.689003101287)         ...           \n",
       "282808 -113.689003  (53.5336987787328, -113.689003101287)         ...           \n",
       "282376 -113.504412  (53.5056328706381, -113.504411754936)         ...           \n",
       "282383 -113.517106   (53.5425275514904, -113.51710601304)         ...           \n",
       "238865 -113.671299  (53.4826109134524, -113.671298916303)         ...           \n",
       "238888 -113.491025  (53.5183817602085, -113.491024742918)         ...           \n",
       "238906 -113.467811  (53.5804459303704, -113.467810982877)         ...           \n",
       "238907 -113.592849    (53.45027109225, -113.592848838106)         ...           \n",
       "287718 -113.513941   (53.540942178767, -113.513940964664)         ...           \n",
       "287719 -113.666812  (53.4784649067264, -113.666811915213)         ...           \n",
       "281384 -113.648685  (53.4991707516991, -113.648685179994)         ...           \n",
       "282391 -113.393796  (53.4871958016464, -113.393796006368)         ...           \n",
       "238996 -113.468785  (53.6003181983512, -113.468784896396)         ...           \n",
       "287720 -113.577329  (53.4472158300965, -113.577328856391)         ...           \n",
       "273937 -113.420078  (53.4547603946352, -113.420077786197)         ...           \n",
       "239053 -113.429476  (53.5700971256476, -113.429475914923)         ...           \n",
       "282392 -113.431037   (53.467187032915, -113.431037495228)         ...           \n",
       "282393 -113.444980  (53.5239639078718, -113.444979716564)         ...           \n",
       "239088 -113.410601    (53.624703206057, -113.41060092694)         ...           \n",
       "239095 -113.524126   (53.4236247809697, -113.52412604561)         ...           \n",
       "282411 -113.434740  (53.5522938710843, -113.434740328361)         ...           \n",
       "282415 -113.530270  (53.4762898987616, -113.530270088611)         ...           \n",
       "282804 -113.522821  (53.4138965183847, -113.522820816719)         ...           \n",
       "287721 -113.501833  (53.5121280621379, -113.501833444329)         ...           \n",
       "239156 -113.511421  (53.4190354620691, -113.511421201755)         ...           \n",
       "282401 -113.583116  (53.4095752014568, -113.583116185724)         ...           \n",
       "269793 -113.590070  (53.5152488340586, -113.590070274486)         ...           \n",
       "282416 -113.501607  (53.5352751534937, -113.501607044439)         ...           \n",
       "282417 -113.501607  (53.5352751534937, -113.501607044439)         ...           \n",
       "\n",
       "       Holidays Closed avg_hourly_temperature Closed  min_windchill Closed  \\\n",
       "284799             NaN                           NaN                   NaN   \n",
       "0                  NaN                           NaN              moderate   \n",
       "1                  NaN                           NaN              moderate   \n",
       "2                  NaN                           NaN              moderate   \n",
       "3                  NaN                           NaN              moderate   \n",
       "274894             NaN                           NaN              moderate   \n",
       "284800             NaN                           NaN              moderate   \n",
       "284801             NaN                           NaN              moderate   \n",
       "284802             NaN                           NaN                   NaN   \n",
       "276418             NaN                           NaN              moderate   \n",
       "4                  NaN                           NaN              moderate   \n",
       "251                NaN                           NaN              moderate   \n",
       "5                  NaN                           NaN              moderate   \n",
       "284803             NaN                           NaN              moderate   \n",
       "284804             NaN                           NaN              moderate   \n",
       "276421             NaN                           NaN              moderate   \n",
       "270907             NaN                           NaN              moderate   \n",
       "289926             NaN                           NaN              moderate   \n",
       "284805             NaN                           NaN              moderate   \n",
       "274028             NaN                           NaN                   NaN   \n",
       "255442             NaN                           NaN                   NaN   \n",
       "274029             NaN                           NaN                   NaN   \n",
       "272239             NaN                           NaN                   NaN   \n",
       "284806             NaN                           NaN                   NaN   \n",
       "11                 NaN                           NaN              moderate   \n",
       "284807             NaN                           NaN                  high   \n",
       "284808             NaN                           NaN              moderate   \n",
       "270201             NaN                           NaN              moderate   \n",
       "284809             NaN                           NaN              moderate   \n",
       "262102             NaN                           NaN              moderate   \n",
       "...                ...                           ...                   ...   \n",
       "282365             NaN                           NaN              moderate   \n",
       "282367             NaN                           NaN              moderate   \n",
       "282808             NaN                           NaN              moderate   \n",
       "282376             NaN                           NaN              moderate   \n",
       "282383             NaN                           NaN              moderate   \n",
       "238865             NaN                           NaN              moderate   \n",
       "238888             NaN                           NaN              moderate   \n",
       "238906             NaN                           NaN              moderate   \n",
       "238907             NaN                           NaN              moderate   \n",
       "287718             NaN                           NaN              moderate   \n",
       "287719             NaN                           NaN              moderate   \n",
       "281384             NaN                           NaN              moderate   \n",
       "282391             NaN                           NaN              moderate   \n",
       "238996             NaN                           NaN              moderate   \n",
       "287720             NaN                           NaN              moderate   \n",
       "273937             NaN                           NaN              moderate   \n",
       "239053             NaN                           NaN              moderate   \n",
       "282392             NaN                           NaN              moderate   \n",
       "282393             NaN                           NaN              moderate   \n",
       "239088             NaN                           NaN              moderate   \n",
       "239095             NaN                           NaN              moderate   \n",
       "282411             NaN                           NaN              moderate   \n",
       "282415             NaN                           NaN              moderate   \n",
       "282804             NaN                           NaN              moderate   \n",
       "287721             NaN                           NaN              moderate   \n",
       "239156             NaN                           NaN              moderate   \n",
       "282401             NaN                           NaN              moderate   \n",
       "269793             NaN                           NaN              moderate   \n",
       "282416             NaN                           NaN              moderate   \n",
       "282417             NaN                           NaN              moderate   \n",
       "\n",
       "        avg_dew_point Closed max_wind_gust Closed wind_gust_dir_10s Closed  \\\n",
       "284799                   NaN                  NaN                      NaN   \n",
       "0                        NaN                  NaN                      NaN   \n",
       "1                        NaN                  NaN                      NaN   \n",
       "2                        NaN                  NaN                      NaN   \n",
       "3                        NaN                  NaN                      NaN   \n",
       "274894                   NaN                  NaN                      NaN   \n",
       "284800                   NaN         strong_winds                       NW   \n",
       "284801                   NaN                  NaN                      NaN   \n",
       "284802                   NaN      windy_direction                       NW   \n",
       "276418                   NaN                  NaN                      NaN   \n",
       "4                        NaN                  NaN                      NaN   \n",
       "251                      NaN                  NaN                      NaN   \n",
       "5                        NaN                  NaN                      NaN   \n",
       "284803                   NaN      windy_direction                      WNW   \n",
       "284804                   NaN                  NaN                      NaN   \n",
       "276421                   NaN                  NaN                      NaN   \n",
       "270907                   NaN         strong_winds                      WNW   \n",
       "289926                   NaN         strong_winds                       NW   \n",
       "284805                   NaN      windy_direction                        N   \n",
       "274028            very humid                  NaN                      NaN   \n",
       "255442           comfortable                  NaN                      NaN   \n",
       "274029            very humid      windy_direction                       NW   \n",
       "272239                   NaN                  NaN                      NaN   \n",
       "284806                   NaN      windy_direction                       NW   \n",
       "11                       NaN         strong_winds                       NW   \n",
       "284807                   NaN      windy_direction                        N   \n",
       "284808                   NaN                  NaN                      NaN   \n",
       "270201                   NaN                  NaN                      NaN   \n",
       "284809                   NaN                  NaN                      NaN   \n",
       "262102                   NaN         strong_winds                      NNW   \n",
       "...                      ...                  ...                      ...   \n",
       "282365                   NaN      windy_direction                      NNE   \n",
       "282367                   NaN                  NaN                      NaN   \n",
       "282808                   NaN                  NaN                      NaN   \n",
       "282376                   NaN      windy_direction                      NNE   \n",
       "282383                   NaN      windy_direction                      NNE   \n",
       "238865                   NaN         strong_winds                      NNW   \n",
       "238888                   NaN         strong_winds                      NNW   \n",
       "238906                   NaN         strong_winds                      NNW   \n",
       "238907                   NaN         strong_winds                      NNW   \n",
       "287718                   NaN                  NaN                      NaN   \n",
       "287719                   NaN                  NaN                      NaN   \n",
       "281384                   NaN      windy_direction                      NNE   \n",
       "282391                   NaN      windy_direction                      NNE   \n",
       "238996                   NaN         strong_winds                      NNW   \n",
       "287720                   NaN                  NaN                      NaN   \n",
       "273937                   NaN         strong_winds                       SE   \n",
       "239053                   NaN         strong_winds                      NNW   \n",
       "282392                   NaN      windy_direction                      NNE   \n",
       "282393                   NaN      windy_direction                      NNE   \n",
       "239088                   NaN         strong_winds                      NNW   \n",
       "239095                   NaN         strong_winds                      NNW   \n",
       "282411                   NaN      windy_direction                      NNE   \n",
       "282415                   NaN                  NaN                      NaN   \n",
       "282804                   NaN      windy_direction                        S   \n",
       "287721                   NaN                  NaN                      NaN   \n",
       "239156                   NaN      windy_direction                      NNE   \n",
       "282401                   NaN                  NaN                      NaN   \n",
       "269793                   NaN                  NaN                      NaN   \n",
       "282416                   NaN      windy_direction                      NNE   \n",
       "282417                   NaN      windy_direction                      NNE   \n",
       "\n",
       "       avg_health_index Closed precipitation Closed sunlight Closed  \\\n",
       "284799                     NaN                  yes              15   \n",
       "0                     moderate                  yes              <8   \n",
       "1                     moderate                  yes              <8   \n",
       "2                     moderate                  yes              <8   \n",
       "3                     moderate                  yes              <8   \n",
       "274894                moderate                  yes              <8   \n",
       "284800                     NaN                  NaN              15   \n",
       "284801                moderate                  yes              <8   \n",
       "284802                     NaN                  yes              15   \n",
       "276418                     NaN                  NaN              <8   \n",
       "4                          NaN                  NaN              <8   \n",
       "251                   moderate                  yes              <8   \n",
       "5                          NaN                  NaN              <8   \n",
       "284803                     NaN                  yes              <8   \n",
       "284804                     NaN                  NaN              <8   \n",
       "276421                     NaN                  NaN              <8   \n",
       "270907                     NaN                  yes              <8   \n",
       "289926                     NaN                  NaN              15   \n",
       "284805                     NaN                  NaN              <8   \n",
       "274028                     NaN                  NaN             16+   \n",
       "255442                     NaN                  yes             16+   \n",
       "274029                     NaN                  yes             16+   \n",
       "272239                     NaN                  NaN             16+   \n",
       "284806                     NaN                  NaN              15   \n",
       "11                         NaN                  NaN              15   \n",
       "284807                     NaN                  NaN              <8   \n",
       "284808                     NaN                  NaN              <8   \n",
       "270201                     NaN                  NaN              <8   \n",
       "284809                     NaN                  yes              <8   \n",
       "262102                     NaN                  yes               8   \n",
       "...                        ...                  ...             ...   \n",
       "282365                     NaN                  yes               9   \n",
       "282367                     NaN                  yes               9   \n",
       "282808                     NaN                  NaN               8   \n",
       "282376                     NaN                  yes               9   \n",
       "282383                     NaN                  yes               9   \n",
       "238865                     NaN                  yes               9   \n",
       "238888                     NaN                  yes               9   \n",
       "238906                     NaN                  yes               9   \n",
       "238907                     NaN                  yes               9   \n",
       "287718                     NaN                  yes               9   \n",
       "287719                     NaN                  yes               9   \n",
       "281384                     NaN                  yes               9   \n",
       "282391                     NaN                  yes               9   \n",
       "238996                     NaN                  yes               9   \n",
       "287720                     NaN                  yes               9   \n",
       "273937                     NaN                  NaN               8   \n",
       "239053                     NaN                  yes               9   \n",
       "282392                     NaN                  yes               9   \n",
       "282393                     NaN                  yes               9   \n",
       "239088                     NaN                  yes               9   \n",
       "239095                     NaN                  yes               9   \n",
       "282411                     NaN                  yes               9   \n",
       "282415                     NaN                  yes               9   \n",
       "282804                     NaN                  yes               9   \n",
       "287721                     NaN                  yes               9   \n",
       "239156                     NaN                  yes               9   \n",
       "282401                     NaN                  yes               9   \n",
       "269793                     NaN                  yes               9   \n",
       "282416                     NaN                  yes               9   \n",
       "282417                     NaN                  yes               9   \n",
       "\n",
       "       MEETING_TYPE Closed  \n",
       "284799                 NaN  \n",
       "0                      NaN  \n",
       "1                      NaN  \n",
       "2                      NaN  \n",
       "3                      NaN  \n",
       "274894                 NaN  \n",
       "284800                 NaN  \n",
       "284801                 NaN  \n",
       "284802                 NaN  \n",
       "276418                 NaN  \n",
       "4                      NaN  \n",
       "251                    NaN  \n",
       "5                      NaN  \n",
       "284803                 NaN  \n",
       "284804                 NaN  \n",
       "276421                 NaN  \n",
       "270907                 NaN  \n",
       "289926                 NaN  \n",
       "284805                 NaN  \n",
       "274028                 NaN  \n",
       "255442                 NaN  \n",
       "274029                 NaN  \n",
       "272239           Committee  \n",
       "284806                 NaN  \n",
       "11                     NaN  \n",
       "284807                 NaN  \n",
       "284808                 NaN  \n",
       "270201                 NaN  \n",
       "284809                 NaN  \n",
       "262102                 NaN  \n",
       "...                    ...  \n",
       "282365                 NaN  \n",
       "282367                 NaN  \n",
       "282808                 NaN  \n",
       "282376                 NaN  \n",
       "282383                 NaN  \n",
       "238865                 NaN  \n",
       "238888                 NaN  \n",
       "238906                 NaN  \n",
       "238907                 NaN  \n",
       "287718                 NaN  \n",
       "287719                 NaN  \n",
       "281384                 NaN  \n",
       "282391                 NaN  \n",
       "238996                 NaN  \n",
       "287720                 NaN  \n",
       "273937                 NaN  \n",
       "239053                 NaN  \n",
       "282392                 NaN  \n",
       "282393                 NaN  \n",
       "239088                 NaN  \n",
       "239095                 NaN  \n",
       "282411                 NaN  \n",
       "282415                 NaN  \n",
       "282804                 NaN  \n",
       "287721                 NaN  \n",
       "239156                 NaN  \n",
       "282401                 NaN  \n",
       "269793                 NaN  \n",
       "282416                 NaN  \n",
       "282417                 NaN  \n",
       "\n",
       "[291516 rows x 25 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7 = df7.sort_values('Reference Number')\n",
    "df7 = df7.replace('no', np.NaN)\n",
    "df7 = df7.replace('below_freezing', np.NaN)\n",
    "df7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "# remove items with < 0.35% support\n",
    "# these are items where the minimum item support could be set for CFPGrowth\n",
    "\n",
    "#for c in df7.columns:\n",
    "#    d = df7[c].value_counts().to_dict()\n",
    "#    for k in d:\n",
    "#        if d[k]/343637 * 100 < 0.05:\n",
    "#            df7[c] = df7[c].replace(k, np.NaN)\n",
    "#            print(c,\":\",k)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RIVER VALLEY WINDERMERE 8\n",
      "ANTHONY HENDAY MISTATIM 8\n",
      "GLENRIDDING HEIGHTS 22\n",
      "ANTHONY HENDAY CASTLEDOWNS 1\n",
      "KINGLET GARDENS 11\n",
      "ANTHONY HENDAY LAKE DISTRICT 25\n",
      "ASTER 39\n",
      "NORWESTER INDUSTRIAL 33\n",
      "ANTHONY HENDAY CLAREVIEW 6\n",
      "GRAYDON HILL 16\n",
      "WINDERMERE AREA 30\n",
      "WHITEMUD CREEK RAVINE TWIN BROOKS 15\n",
      "RIVER VALLEY CAMERON 16\n",
      "DESROCHERS AREA 39\n"
     ]
    }
   ],
   "source": [
    "for x,y in df7['Neighbourhood'].value_counts(dropna=False).to_dict().items():\n",
    "    if y < 40:\n",
    "        print(x,y)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAh4AAAFkCAYAAABvkjJwAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAAPYQAAD2EBqD+naQAAHQlJREFUeJzt3XuUXWWZ5/HvgyBRlDgtkATERlGZOLbBlBdQw6W5NbAG\np21bu0amI9oqgkumxl54mXEpuFqaZkHhjcFuBgHRWjo9Ol4GBQGRQaBpieiogfRI6HBLSLS74gIS\nIzzzxz7pqRzqus+p95yz6/tZ66xkv+fd+zxv3qrKr/Y1MhNJkqQSdut1AZIkaeEweEiSpGIMHpIk\nqRiDhyRJKsbgIUmSijF4SJKkYgwekiSpGIOHJEkqxuAhSZKKMXhIkqRieh48IuL0iPhxRIy3XrdG\nxB/MsM5REXFnRGyLiHURsbpUvZIkqb6eBw/gfuADwEpgCLgR+HpELJ+sc0QcBHwLuAFYAXwSuCwi\njitRrCRJqi/68SFxEfFL4M8z8/OTvHc+cGJmvnxC2xiwODNPKlimJEmao37Y4/EvImK3iPgT4JnA\nbVN0Owy4vq3tWuDw+axNkiR1bvdeFwAQES+jChqLgF8Df5iZd0/RfSmwqa1tE7B3ROyZmdun+Izn\nAicA9wHbulG3JEkLxCLgIODazPxlJxvqi+AB3E11vsZi4E3AVRFxxDTho44TgC92cXuSJC00bwW+\n1MkG+iJ4ZOZvgXtbiz+KiFcDZwHvmaT7RmBJW9sSYOtUezta7gO4+uqrWb580vNWB9batWs59dRT\ngY8DLwAuBN7f26JmtB74SEfzMTIywujoaHfLmsJT/41LqjOfnf/7llZyPnvJcTbPQhjr//8ZWP1f\n2om+CB6T2A3Yc4r3bgNObGs7nqnPCdlpG8Dy5ctZuXJlZ9X1rZOoLg76MlUo7WdrgI90NB+LFy/u\nwVzu/Dcuqc58dv7vW1pv5rM8x9k8C2msdOFUhZ4Hj4j4BPBtYAPwbKqfsEdShQki4jxg/8zcea+O\nS4EzW1e3XA4cQ3V4xitaJEnqcz0PHsB+wJXAMmAc+AlwfGbe2Hp/KXDgzs6ZeV9EnAyMAu8DHgDe\nkZntV7pIkqQ+0/PgkZl/NsP7p03SdjPVzcYkSdIA6av7eKhbhntdQBHDwwtjnM5nszjO5llIY+0G\ng0cjLYxvgoXzzb4wxrlQ5tNxNs9CGms3GDwkSVIxBg9JklSMwUOSJBVj8JAkScUYPCRJUjEGD0mS\nVIzBQ5IkFWPwkCRJxRg8JElSMQYPSZJUjMFDkiQVY/CQJEnFGDwkSVIxBg9JklSMwUOSJBVj8JAk\nScUYPCRJUjEGD0mSVIzBQ5IkFWPwkCRJxRg8JElSMQYPSZJUjMFDkiQVY/CQJEnFGDwkSVIxBg9J\nklSMwUOSJBVj8JAkScUYPCRJUjEGD0mSVIzBQ5IkFWPwkCRJxRg8JElSMQYPSZJUjMFDkiQVY/CQ\nJEnFGDwkSVIxBg9JklSMwUOSJBXT8+ARER+KiDsiYmtEbIqIr0XES2ZY58iIeLLt9URE7FeqbkmS\nNHc9Dx7AKuDTwGuAY4E9gOsi4hkzrJfAi4GlrdeyzHxkPguVJEmd2b3XBWTmSROXI+JtwCPAEHDL\nDKtvzsyt81SaJEnqsn7Y49HuOVR7M341Q78A7oqIhyLiuoh47fyXJkmSOtFXwSMiArgYuCUzfz5N\n14eBdwN/BLwRuB+4KSIOnf8qJUlSXT0/1NLmEuClwOum65SZ64B1E5puj4iDgRFg9XTrjoyMsHjx\n4l3ahoeHGR4erlWwJElNMjY2xtjY2C5t4+PjXdt+3wSPiPgMcBKwKjMfrrGJO5ghsACMjo6ycuXK\nGpuXJKn5JvtlfM2aNQwNDXVl+30RPFqh4w3AkZm5oeZmDqU6BCNJkvpUz4NHRFwCDAOnAI9GxJLW\nW+OZua3V5xPAAZm5urV8FrAe+BmwCHgncDRwXOHyJUnSHPQ8eACnU13FclNb+2nAVa2/LwMOnPDe\n04ELgf2Bx4CfAMdk5s3zWqkkSepIz4NHZs54ZU1mnta2fAFwwbwVJUmS5kVfXU4rSZKazeAhSZKK\nMXhIkqRiDB6SJKkYg4ckSSrG4CFJkooxeEiSpGIMHpIkqRiDhyRJKsbgIUmSijF4SJKkYgwekiSp\nGIOHJEkqxuAhSZKKMXhIkqRiDB6SJKkYg4ckSSrG4CFJkooxeEiSpGIMHpIkqRiDhyRJKsbgIUmS\nijF4SJKkYgwekiSpGIOHJEkqxuAhSZKKMXhIkqRiDB6SJKkYg4ckSSrG4CFJkooxeEiSpGIMHpIk\nqRiDhyRJKsbgIUmSijF4SJKkYgwekiSpGIOHJEkqxuAhSZKKMXhIkqRiDB6SJKmYngePiPhQRNwR\nEVsjYlNEfC0iXjKL9Y6KiDsjYltErIuI1SXqlSRJ9fU8eACrgE8DrwGOBfYArouIZ0y1QkQcBHwL\nuAFYAXwSuCwijpvvYiVJUn2797qAzDxp4nJEvA14BBgCbplitfcA92bm2a3leyLi9cAI8N15KlWS\nJHWoH/Z4tHsOkMCvpulzGHB9W9u1wOHzVZQkSepcXwWPiAjgYuCWzPz5NF2XApva2jYBe0fEnvNV\nnyRJ6kzPD7W0uQR4KfC6XhciSdJcbNiwgS1btvS6jFnbZ599eP7zn1/8c/smeETEZ4CTgFWZ+fAM\n3TcCS9ralgBbM3P7dCuOjIywePHiXdqGh4cZHh6eY8WSJFU2bNjAIYcsZ9u2x3pdyqwtWvRM7rln\n7VPCx9jYGGNjY7u0jY+Pd+1z+yJ4tELHG4AjM3PDLFa5DTixre34Vvu0RkdHWbly5dyLlCRpClu2\nbGmFjquB5b0uZxbWsm3bqWzZsuUpwWOyX8bXrFnD0NBQVz6558EjIi4BhoFTgEcjYueejPHM3Nbq\n8wnggMzcea+OS4EzI+J84HLgGOBNVHtMJEnqkeWAv9xOpx9OLj0d2Bu4CXhowuvNE/osAw7cuZCZ\n9wEnU9334y6qy2jfkZntV7pIkqQ+0vM9Hpk5Y/jJzNMmabuZ6l4fkiRpQPTDHg9JkrRAGDwkSVIx\nBg9JklSMwUOSJBVj8JAkScUYPCRJUjEGD0mSVIzBQ5IkFWPwkCRJxRg8JElSMQYPSZJUjMFDkiQV\nY/CQJEnF1AoeEfEfImJRt4uRJEnNVnePxyiwMSI+FxGv7mZBkiSpueoGj/2BdwLPA34QET+NiPdH\nxL7dK02SJDVNreCRmb/JzP+emScDzwe+ALwDeCAivhoRJ0dEdLNQSZI0+Do+uTQzHwauB74HJPBK\nYAz4h4hY1en2JUlSc9QOHhGxT0T8x4j4MfADYD/g3wG/CxwA/E/gqq5UKUmSGmH3OitFxNeAk4D1\nwGXAlZm5eUKXX0fEXwH/qfMSJUlSU9QKHsBW4NjM/N/T9NkMvLjm9iVJUgPVCh6ZuXoWfRL4RZ3t\nS5KkZqp7A7HRiDhzkvYzI+LCzsuSJElNVPfk0j8Gbp2k/XbgLfXLkSRJTVY3eOxDdZ5Hu/HWe5Ik\nSU9RN3j8AjhhkvYTqK50kSRJeoq6V7VcDFwcEc8Fbmy1HQOcDfx5NwqTJEnNU/eqlr9pPZ32w8A5\nreYHgPdl5uXdKk6SJDVL3T0eZOangU9HxDLg8cz85+6VJUmSmqh28Nip9awWSZKkGdW9j8e+EfH5\niNgQEdsi4jcTX90uUpIkNUPdPR5XAAcDFwAPUz2VVpIkaVp1g8cRwBGZ+aNuFiNJkpqt7n08HsC9\nHJIkaY7qBo8R4LyIeF43i5EkSc1W91DLF4BnA/8YEVuBHRPfzMz9Oi1MkiQ1T93g8cGuViFJkhaE\nuncu/W/dLkSSJDVf3XM8iIiDIuJjEfGFiNiv1XZ8RCzvXnmSJKlJ6t5AbBXwM+BI4M3As1pvDQHn\ndqc0SZLUNHX3eJwPfCwzjwYm3qn0BuCwjquSJEmNVDd4vBz420naHwH2nevGImJVRHwjIh6MiCcj\n4pQZ+h/Z6jfx9cTOQz6SJKk/1Q0e48DSSdpXAA/W2N5ewF3AGcz+xmQJvLhVx1JgWWY+UuOzJUlS\nIXUvp/0y8JcR8SZaQSEiXgNcCFw9141l5neA77S2E3NYdXNmbp3r50mSpN6ou8fjQ8C9wENUJ5b+\nHLgV+Hvg490pbUYB3BURD0XEdRHx2kKfK0mSaqp7H4/twGkRcS7we1ThY01m3t3N4qbxMPBu4IfA\nnsA7gZsi4tWZeVehGiRJ0hzVPdQCQGauB9Z3qZa5fO46YN2Eptsj4mCqZ8isnm7dkZERFi9evEvb\n8PAww8PDXa9TkqRBMzY2xtjY2C5t4+PjXdt+reAREX893fuZ+a565XTkDuB1M3UaHR1l5cqVBcqR\nJGnwTPbL+Jo1axgaGurK9uvu8VjWtrwH8G+oHhx3c0cV1Xco1SEYSZLUp+qe4/Fv29siYnfgUqoT\nTeckIvYCXkR1wijACyNiBfCrzLw/Is4D9s/M1a3+Z1Ed4vkZsIjqHI+jgeNqDEeSJBXS0TkeE2Xm\nbyPiAuAm4KI5rv5K4HtUl+Ym1WW5AFcCb6e6T8eBE/o/vdVnf+Ax4CfAMZnZq70tkiRpFroWPFpe\nQHXYZU4y8/tMc2lvZp7WtnwBcMGcq5MkST1V9+TSv2pvojrv4xRq3EBMkiQtDHX3eBzetvwksBn4\nIPA3HVUkSZIaq+7Jpau6XYgkSWq+urdMlyRJmrO653j8PbN8imxmvrrOZ0iSpOape47H96ielbIO\nuK3VdhhwCPA5YHvnpUmSpKapGzyeA3w2Mz88sTEi/gJYkpl/1nFlkiSpceqe4/Fm4POTtF8B/HHt\naiRJUqPVDR7bqQ6ttDsMD7NIkqQp1D3U8ingcxHxCqqnwgK8huqZKed1ozBJktQ8de/j8RcRsR44\nC9h5Psda4F2Z+aVuFSdJkpql9rNaWgHDkCFJkmat9g3EImLviHhbRJwbEf+q1bYiIpZ1rzxJktQk\ndW8g9jLgeqpH0h9IdTXLPwFvAQ4AVnepPkmS1CB193iMUh1mORjYNqH9fwFHdFqUJElqprrB41XA\nJZnZftv0BwEPtUiSpEnVDR47gGdN0v4iYEv9ciRJUpPVDR7fBD4SETvPEcmIOAD4S+CrXalMkiQ1\nTt3g8X7gd4CNwDOAG4F7qc73+PA060mSpAWs7g3E/gk4OiKOBFZQHXZZA1w7yXkfkiRJQI3gERF7\nAN8C3puZ3we+3/WqJElSI835UEtm7gCGAPdsSJKkOal7jscXgdO6WYgkSWq+us9qSeC9EXEs8EPg\n0V3ezDy708IkSVLz1A0eQ8BPWn9/edt7HoKRJEmTmlPwiIgXAuszc9U81SNJkhpsrud4/AOw786F\niPhyRCzpbkmSJKmp5ho8om35JGCvLtUiSZIaru5VLZIkSXM21+CRPPXkUU8mlSRJszLXq1oCuCIi\ntreWFwGXRkT75bRv7EZxkiSpWeYaPK5sW766W4VIkqTmm1PwyEzvVipJkmrz5FJJklSMwUOSJBVj\n8JAkScUYPCRJUjEGD0mSVIzBQ5IkFWPwkCRJxRg8JElSMX0RPCJiVUR8IyIejIgnI+KUWaxzVETc\nGRHbImJdRKwuUaskSaqvL4IHsBdwF3AGs3joXEQcBHwLuAFYAXwSuCwijpu/EiVJUqfm+qyWeZGZ\n3wG+AxARMYtV3gPcm5lnt5bviYjXAyPAd+enSkmS1Kl+2eMxV4cB17e1XQsc3oNaJEnSLPXFHo8a\nlgKb2to2AXtHxJ6Zub2TjY+Pj3POOeewfXtHmylm8+bNvS6htrVr1/a6hFkZlDoH2YYNG9iyZUuv\ny5i17du3s+eee/a6jFkbtHphsGr2Z8TsDWrwqG1kZITFixfv0jY8PMzw8PC/LF9++eWMjl7MHnsc\nWrq8Wp54YhCDx8PAbpx66qm9LkR9YMOGDRxyyHK2bXus16XMwdOAJ3pdxBwMWr0wmDUPvrGxMcbG\nxnZpGx8f79r2BzV4bASWtLUtAbbOtLdjdHSUlStXTrvxzORpT3sWO3as6azKYi4Bzux1EXP0z8CT\nwNXA8h7XMhvXAB/pdRGNtWXLllboGLSvB+udP4NWc3N+RrT/Mg6wZs0ahoaGurL9QQ0etwEntrUd\n32rXQFkOTB8E+4O7UcsYtK8H650/g1azPyNmqy9OLo2IvSJiRUTsPLbxwtbyga33z4uIKyescmmr\nz/kRcUhEnAG8CbiocOmSJGkO+iJ4AK8EfgTcSXUfjwuBNcA5rfeXAgfu7JyZ9wEnA8dS3f9jBHhH\nZrZf6SJJkvpIXxxqyczvM00IyszTJmm7GejOASdJklREv+zxkCRJC4DBQ5IkFWPwkCRJxRg8JElS\nMQYPSZJUjMFDkiQVY/CQJEnFGDwkSVIxBg9JklSMwUOSJBVj8JAkScUYPCRJUjEGD0mSVIzBQ5Ik\nFWPwkCRJxRg8JElSMQYPSZJUjMFDkiQVY/CQJEnFGDwkSVIxBg9JklSMwUOSJBVj8JAkScUYPCRJ\nUjEGD0mSVIzBQ5IkFWPwkCRJxRg8JElSMQYPSZJUjMFDkiQVY/CQJEnFGDwkSVIxBg9JklSMwUOS\nJBVj8JAkScUYPCRJUjEGD0mSVIzBQ5IkFWPwkCRJxRg8JElSMX0TPCLizIhYHxGPR8TtEfGqafoe\nGRFPtr2eiIj9StYsSZLmpi+CR0S8BbgQ+CjwCuDHwLURsc80qyXwYmBp67UsMx+Z71olSVJ9fRE8\ngBHgc5l5VWbeDZwOPAa8fYb1NmfmIztf816lJEnqSM+DR0TsAQwBN+xsy8wErgcOn25V4K6IeCgi\nrouI185vpZIkqVM9Dx7APsDTgE1t7ZuoDqFM5mHg3cAfAW8E7gduiohD56tISZLUud17XUAdmbkO\nWDeh6faIOJjqkM3q3lQlSZJm0g/BYwvwBLCkrX0JsHEO27kDeN1MnUZGRli8ePEubcPDwwwPD8/h\noyRJaqaxsTHGxsZ2aRsfH+/a9nsePDJzR0TcCRwDfAMgIqK1/Kk5bOpQqkMw0xodHWXlypV1SpUk\nqfEm+2V8zZo1DA0NdWX7PQ8eLRcBV7QCyB1Uh0yeCVwBEBHnAftn5urW8lnAeuBnwCLgncDRwHHF\nK5ckSbPWF8EjM7/SumfHuVSHWO4CTsjMza0uS4EDJ6zydKr7fuxPddntT4BjMvPmclVLkqS56ovg\nAZCZlwCXTPHeaW3LFwAXlKhLkiR1Tz9cTitJkhYIg4ckSSrG4CFJkooxeEiSpGIMHpIkqRiDhyRJ\nKsbgIUmSijF4SJKkYgwekiSpGIOHJEkqxuAhSZKKMXhIkqRiDB6SJKkYg4ckSSrG4CFJkooxeEiS\npGIMHpIkqRiDhyRJKsbgIUmSijF4SJKkYgwekiSpGIOHJEkqxuAhSZKKMXhIkqRiDB6SJKkYg4ck\nSSrG4CFJkooxeEiSpGIMHpIkqRiDhyRJKsbgIUmSijF4SJKkYgwekiSpGIOHJEkqxuAhSZKKMXhI\nkqRiDB6SJKkYg4ckSSrG4CFJkooxeEiSpGIMHo001usCCnGcGkQLZT4XyjhhYY21c30TPCLizIhY\nHxGPR8TtEfGqGfofFRF3RsS2iFgXEatL1dr/Fso3gePUIFoo87lQxgkLa6yd64vgERFvAS4EPgq8\nAvgxcG1E7DNF/4OAbwE3ACuATwKXRcRxJeqVJEn19EXwAEaAz2XmVZl5N3A68Bjw9in6vwe4NzPP\nzsx7MvOzwN+2tiNJkvpUz4NHROwBDFHtvQAgMxO4Hjh8itUOa70/0bXT9JckSX1g914XAOwDPA3Y\n1Na+CThkinWWTtF/74jYMzO3T7LOIoC1a9fOWNADDzzAk0/+BvjrGfv2h1taf14DrAUeAL7Yu3Jm\n5QetP3fWXEfJcXaj3rrqjHM9ANdcc82svuZ7bf369a2/9eLft45Ovh568f3Zi6/fTsfZy++5uXqA\nwaoXdv6MmO3Phwn9FnX6yVHtXOidiFgGPAgcnpl/N6H9fOCIzHzKXoyIuAe4PDPPn9B2ItV5H8+c\nLHhExL+n//83liSpn701M7/UyQb6YY/HFuAJYElb+xJg4xTrbJyi/9Yp9nZAdSjmrcB9wLZalUqS\ntDAtAg6i+r+0Iz0PHpm5IyLuBI4BvgEQEdFa/tQUq90GnNjWdnyrfarP+SXQUUqTJGkBu7UbG+n5\nyaUtFwHvjIg/jYh/DVwKPBO4AiAizouIKyf0vxR4YUScHxGHRMQZwJta25EkSX2q53s8ADLzK617\ndpxLdcjkLuCEzNzc6rIUOHBC//si4mRgFHgf1Zk978jM9itdJElSH+n5yaWSJGnh6JdDLZIkaQEw\neEiSpGIWRPCY6wPoBk1EfDQinmx7/bzXdXVDRKyKiG9ExIOtcZ0ySZ9zI+KhiHgsIr4bES/qRa2d\nmGmcEfH5Seb4ml7VW0dEfCgi7oiIrRGxKSK+FhEvmaTfQM/nbMbZhPkEiIjTI+LHETHeet0aEX/Q\n1meg5xNmHmdT5nOiiPhgaxwXtbV3PJ+NDx5zfQDdAPsp1Ym5S1uv1/e2nK7Zi+pk4zOAp5yQFBEf\nAN4LvAt4NfAo1fw+vWSRXTDtOFu+za5zPFymtK5ZBXwaeA1wLLAHcF1EPGNnh4bM54zjbBn0+QS4\nH/gAsJLq0Rc3Al+PiOXQmPmEGcbZ0oT5BKD1y/m7qP6/nNjenfnMzEa/gNuBT05YDqqrYM7udW1d\nHONHgTW9rqPAOJ8ETmlrewgYmbC8N/A48OZe19vlcX4e+Gqva+vyOPdpjfX1DZ/PycbZuPmcMLZf\nAqc1dT6nGGdj5hN4FnAP8PvA94CLJrzXlfls9B6Pmg+gG1Qvbu2m/0VEXB0RB868ymCLiBdQ/WYx\ncX63An9H8+YX4KjWrvu7I+KSiPidXhfUoedQ7d35FTR6PncZ5wSNms+I2C0i/oTqHky3NnU+28c5\n4a2mzOdngW9m5o0TG7s5n31xH495VOcBdIPoduBtVCl1GfAx4OaIeFlmPtrDuubbUqof6JPN79Ly\n5cyrbwP/g+rJTgcD5wHXRMThrTA9UCIigIuBWzJz5/lIjZvPKcYJDZrPiHgZ1V2jFwG/Bv4wM++J\niMNp0HxONc7W242Yz1agOhR45SRvd+37s+nBY0HIzIn3zv9pRNwB/CPwZqpdgBpwmfmVCYs/i4j/\nA/wCOIpqd+iguQR4KfC6XhcyzyYdZ8Pm825gBbCY6g7SV0XEEb0taV5MOs7MvLsJ8xkRz6MKycdm\n5o75/KxGH2qh3gPoBl5mjgPrgIE7e3yONlKds7Og5hcgM9dTfX0P3BxHxGeAk4CjMvPhCW81aj6n\nGedTDPJ8ZuZvM/PezPxRZv5nqhMSz6Jh8znNOCfrO4jzOQTsC6yJiB0RsQM4EjgrIn5DtWejK/PZ\n6ODRSm07H0AH7PIAuq487KYfRcSzqL7gp/1hN+ha39wb2XV+96a6mqCx8wv/8tvJcxmwOW79Z/wG\n4OjM3DDxvSbN53TjnKL/QM7nFHYD9mzSfE5hN2DPyd4Y0Pm8Hvg9qkMtK1qvHwJXAysy8166NJ8L\n4VDLRcAVUT0B9w5ghAkPoGuCiLgA+CbV4ZUDgHOAHcBYL+vqhojYiypERavphRGxAvhVZt5PtWvw\nv0TE/wXuAz5OddXS13tQbm3TjbP1+ijVMeSNrX7nU+3V6vgR1aVExCVUlxieAjwaETt/cxrPzG2t\nvw/8fM40ztZcD/x8AkTEJ6jOb9gAPBt4K9Vvyce3ugz8fML042zKfLbOB9zl/k8R8Sjwy8xc22rq\nznz2+tKdQpcHndH6R3qc6uSgV/a6pi6Pb6w1+Y9TfWN8CXhBr+vq0tiOpLoU8Ym21+UT+nyM6jKv\nx6i+0V/U67q7OU6qk9m+Q/VDbRtwL/BfgX17XfccxzjZ+J4A/rSt30DP50zjbMp8tsZyWav+x1vj\nuQ74/SbN50zjbNJ8TjLuG5lwOW235tOHxEmSpGIafY6HJEnqLwYPSZJUjMFDkiQVY/CQJEnFGDwk\nSVIxBg9JklSMwUOSJBVj8JAkScUYPCRJUjEGD0mSVIzBQ5IkFfP/ABWzVdNWXzgDAAAAAElFTkSu\nQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f64e381b860>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt \n",
    "\n",
    "a = df7['Neighbourhood'].value_counts(dropna=False)\n",
    "a[a<40].plot.hist()\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Reference Number</th>\n",
       "      <th>Date Closed</th>\n",
       "      <th>Status Detail</th>\n",
       "      <th>Service Code</th>\n",
       "      <th>Neighbourhood</th>\n",
       "      <th>Ward</th>\n",
       "      <th>Address</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "      <th>Location</th>\n",
       "      <th>...</th>\n",
       "      <th>Holidays Closed</th>\n",
       "      <th>avg_hourly_temperature Closed</th>\n",
       "      <th>min_windchill Closed</th>\n",
       "      <th>avg_dew_point Closed</th>\n",
       "      <th>max_wind_gust Closed</th>\n",
       "      <th>wind_gust_dir_10s Closed</th>\n",
       "      <th>avg_health_index Closed</th>\n",
       "      <th>precipitation Closed</th>\n",
       "      <th>sunlight Closed</th>\n",
       "      <th>MEETING_TYPE Closed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>237516</th>\n",
       "      <td>8015914532</td>\n",
       "      <td>2017-05-30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Boulevard</td>\n",
       "      <td>ANTHONY HENDAY CASTLEDOWNS</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18040 112 STREET NW</td>\n",
       "      <td>53.643035</td>\n",
       "      <td>-113.528442</td>\n",
       "      <td>(53.643034946994, -113.528441730397)</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>SSE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16+</td>\n",
       "      <td>Council/Committee</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Reference Number Date Closed Status Detail Service Code  \\\n",
       "237516        8015914532  2017-05-30           NaN    Boulevard   \n",
       "\n",
       "                     Neighbourhood  Ward              Address        Lat  \\\n",
       "237516  ANTHONY HENDAY CASTLEDOWNS   3.0  18040 112 STREET NW  53.643035   \n",
       "\n",
       "              Long                              Location         ...          \\\n",
       "237516 -113.528442  (53.643034946994, -113.528441730397)         ...           \n",
       "\n",
       "       Holidays Closed avg_hourly_temperature Closed  min_windchill Closed  \\\n",
       "237516             NaN                           NaN                   NaN   \n",
       "\n",
       "        avg_dew_point Closed max_wind_gust Closed wind_gust_dir_10s Closed  \\\n",
       "237516                   NaN         strong_winds                      SSE   \n",
       "\n",
       "       avg_health_index Closed precipitation Closed sunlight Closed  \\\n",
       "237516                     NaN                  NaN             16+   \n",
       "\n",
       "       MEETING_TYPE Closed  \n",
       "237516   Council/Committee  \n",
       "\n",
       "[1 rows x 25 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7.loc[df7['Neighbourhood']==\"ANTHONY HENDAY CASTLEDOWNS\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Reference Number</th>\n",
       "      <th>Neighbourhood</th>\n",
       "      <th>Long</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Location</th>\n",
       "      <th>Ward</th>\n",
       "      <th>Address</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124350</th>\n",
       "      <td>138161895</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.319828</td>\n",
       "      <td>53.572165</td>\n",
       "      <td>(53.5721647587943, -113.319828128951)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17 STREET NE, YELLOWHEAD TRAIL [WESTBOUND SIDE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280555</th>\n",
       "      <td>144439715</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393851</td>\n",
       "      <td>53.541093</td>\n",
       "      <td>(53.5410929339599, -113.393851164659)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284734</th>\n",
       "      <td>144938773</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.431093</td>\n",
       "      <td>53.657816</td>\n",
       "      <td>(53.6578161005905, -113.431092714122)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>195 AVENUE NW, 66 STREET [SOUTHBOUND SIDE] NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285411</th>\n",
       "      <td>144997410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.435104</td>\n",
       "      <td>53.651982</td>\n",
       "      <td>(53.6519824931068, -113.435103806662)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66 STREET [SOUTHBOUND SIDE] NW, ANTHONY HENDAY...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275590</th>\n",
       "      <td>146016603</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393851</td>\n",
       "      <td>53.541093</td>\n",
       "      <td>(53.5410929339599, -113.393851164659)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81569</th>\n",
       "      <td>151576805</td>\n",
       "      <td>ANTHONY HENDAY ENERGY PARK</td>\n",
       "      <td>-113.435104</td>\n",
       "      <td>53.651982</td>\n",
       "      <td>(53.6519824931068, -113.435103806662)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66 STREET NW, ANTHONY HENDAY DRIVE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285562</th>\n",
       "      <td>153265751</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.369257</td>\n",
       "      <td>53.539393</td>\n",
       "      <td>(53.5393933297421, -113.369257408744)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17 STREET, BASELINE ROAD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285881</th>\n",
       "      <td>153608576</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.492369</td>\n",
       "      <td>53.652614</td>\n",
       "      <td>(53.6526143917998, -113.49236850964)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>97 STREET [SOUTHBOUND SIDE] NW, ANTHONY HENDAY...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286312</th>\n",
       "      <td>156410749</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.368849</td>\n",
       "      <td>53.715999</td>\n",
       "      <td>(53.7159985749835, -113.368849209972)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18 STREET NW, 259 AVENUE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285641</th>\n",
       "      <td>159208149</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.369257</td>\n",
       "      <td>53.539393</td>\n",
       "      <td>(53.5393933297421, -113.369257408744)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17 STREET, BASELINE ROAD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269697</th>\n",
       "      <td>160052684</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.430779</td>\n",
       "      <td>53.657810</td>\n",
       "      <td>(53.6578098259984, -113.43077878735)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>195 AVENUE NW, 66 STREET [NORTHBOUND SIDE] NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280045</th>\n",
       "      <td>162359075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.435104</td>\n",
       "      <td>53.651982</td>\n",
       "      <td>(53.6519824931068, -113.435103806662)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66 STREET [SOUTHBOUND SIDE] NW, ANTHONY HENDAY...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267960</th>\n",
       "      <td>162767387</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393876</td>\n",
       "      <td>53.517725</td>\n",
       "      <td>(53.5177250160081, -113.39387642079)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, SHERWOOD PARK FREEWAY [WESTBOUND...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272562</th>\n",
       "      <td>162769123</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393884</td>\n",
       "      <td>53.519351</td>\n",
       "      <td>(53.519351264349, -113.393883823288)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 84 AVENUE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187545</th>\n",
       "      <td>162773490</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393888</td>\n",
       "      <td>53.526661</td>\n",
       "      <td>(53.5266609736857, -113.393887759204)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>92 AVENUE NW, 34 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273749</th>\n",
       "      <td>162829112</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393884</td>\n",
       "      <td>53.519351</td>\n",
       "      <td>(53.519351264349, -113.393883823288)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 84 AVENUE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281337</th>\n",
       "      <td>162832991</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393888</td>\n",
       "      <td>53.526661</td>\n",
       "      <td>(53.5266609736857, -113.393887759204)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>92 AVENUE NW, 34 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201935</th>\n",
       "      <td>162860180</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393884</td>\n",
       "      <td>53.519351</td>\n",
       "      <td>(53.519351264349, -113.393883823288)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 84 AVENUE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256411</th>\n",
       "      <td>167244202</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.435104</td>\n",
       "      <td>53.651982</td>\n",
       "      <td>(53.6519824931068, -113.435103806662)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66 STREET [SOUTHBOUND SIDE] NW, ANTHONY HENDAY...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151022</th>\n",
       "      <td>172620737</td>\n",
       "      <td>ANTHONY HENDAY ENERGY PARK</td>\n",
       "      <td>-113.435104</td>\n",
       "      <td>53.651982</td>\n",
       "      <td>(53.6519824931068, -113.435103806662)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>66 STREET NW, ANTHONY HENDAY DRIVE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281881</th>\n",
       "      <td>172840369</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393888</td>\n",
       "      <td>53.526661</td>\n",
       "      <td>(53.5266609736857, -113.393887759204)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>92 AVENUE NW, 34 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148554</th>\n",
       "      <td>174895385</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.319828</td>\n",
       "      <td>53.572165</td>\n",
       "      <td>(53.5721647587943, -113.319828128951)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17 STREET NE, YELLOWHEAD TRAIL [WESTBOUND SIDE...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278554</th>\n",
       "      <td>188602040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.344502</td>\n",
       "      <td>53.424890</td>\n",
       "      <td>(53.4248904564429, -113.344501521042)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ELLERSLIE ROAD SW, MERIDIAN STREET SW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51881</th>\n",
       "      <td>219094972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.368849</td>\n",
       "      <td>53.715999</td>\n",
       "      <td>(53.7159985749835, -113.368849209972)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18 STREET NW, 259 AVENUE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203962</th>\n",
       "      <td>221407383</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393860</td>\n",
       "      <td>53.541267</td>\n",
       "      <td>(53.5412666727894, -113.393860432771)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 101 AVENUE [WESTBOUND SIDE] NW, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193831</th>\n",
       "      <td>223808226</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393860</td>\n",
       "      <td>53.541267</td>\n",
       "      <td>(53.5412666727894, -113.393860432771)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 101 AVENUE [WESTBOUND SIDE] NW, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216487</th>\n",
       "      <td>226231010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393851</td>\n",
       "      <td>53.541093</td>\n",
       "      <td>(53.5410929339599, -113.393851164659)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289411</th>\n",
       "      <td>226749588</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393851</td>\n",
       "      <td>53.541093</td>\n",
       "      <td>(53.5410929339599, -113.393851164659)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289412</th>\n",
       "      <td>226770525</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393860</td>\n",
       "      <td>53.541267</td>\n",
       "      <td>(53.5412666727894, -113.393860432771)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 101 AVENUE [WESTBOUND SIDE] NW, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282449</th>\n",
       "      <td>229195226</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393851</td>\n",
       "      <td>53.541093</td>\n",
       "      <td>(53.5410929339599, -113.393851164659)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW, ...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214082</th>\n",
       "      <td>8015849149</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.430939</td>\n",
       "      <td>53.657816</td>\n",
       "      <td>(53.6578157933353, -113.430939427393)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>195 AVENUE NW, 66 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209274</th>\n",
       "      <td>8015885883</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.639035</td>\n",
       "      <td>53.602633</td>\n",
       "      <td>(53.6026331887335, -113.639034592283)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>137 AVENUE NW, 184 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208454</th>\n",
       "      <td>8015894427</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.333073</td>\n",
       "      <td>53.569059</td>\n",
       "      <td>(53.5690593584477, -113.333072742178)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277531</th>\n",
       "      <td>8015907342</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393868</td>\n",
       "      <td>53.517021</td>\n",
       "      <td>(53.5170210930796, -113.393867920675)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, SHERWOOD PARK FREEWAY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259720</th>\n",
       "      <td>8015953554</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.319723</td>\n",
       "      <td>53.572210</td>\n",
       "      <td>(53.5722101793048, -113.319722696429)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YELLOWHEAD TRAIL, 17 STREET NE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215802</th>\n",
       "      <td>8015998256</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393868</td>\n",
       "      <td>53.517021</td>\n",
       "      <td>(53.5170210930796, -113.393867920675)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, SHERWOOD PARK FREEWAY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286668</th>\n",
       "      <td>8016004935</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393855</td>\n",
       "      <td>53.541176</td>\n",
       "      <td>(53.5411756042498, -113.393854824035)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101 AVENUE NW, 34 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226027</th>\n",
       "      <td>8016091240</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.329029</td>\n",
       "      <td>53.569872</td>\n",
       "      <td>(53.5698724501474, -113.329029270362)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANTHONY HENDAY DRIVE, YELLOWHEAD TRAIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220584</th>\n",
       "      <td>8016130398</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.344263</td>\n",
       "      <td>53.715978</td>\n",
       "      <td>(53.7159783396282, -113.344263299772)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>259 AVENUE NW, MERIDIAN STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233347</th>\n",
       "      <td>8016137467</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.344263</td>\n",
       "      <td>53.715978</td>\n",
       "      <td>(53.7159783396282, -113.344263299772)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MERIDIAN STREET NW, 259 AVENUE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205555</th>\n",
       "      <td>8016168359</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.329029</td>\n",
       "      <td>53.569872</td>\n",
       "      <td>(53.5698724501474, -113.329029270362)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236444</th>\n",
       "      <td>8016193996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.369110</td>\n",
       "      <td>53.517109</td>\n",
       "      <td>(53.5171086789885, -113.369109632496)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHERWOOD PARK FREEWAY, 17 STREET</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230901</th>\n",
       "      <td>8016196629</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.369110</td>\n",
       "      <td>53.517109</td>\n",
       "      <td>(53.5171086789885, -113.369109632496)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17 STREET, SHERWOOD PARK FREEWAY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237311</th>\n",
       "      <td>8016204175</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.319723</td>\n",
       "      <td>53.572210</td>\n",
       "      <td>(53.5722101793048, -113.319722696429)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YELLOWHEAD TRAIL, 17 STREET NE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266023</th>\n",
       "      <td>8016253888</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393868</td>\n",
       "      <td>53.517021</td>\n",
       "      <td>(53.5170210930796, -113.393867920675)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHERWOOD PARK FREEWAY, 34 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286085</th>\n",
       "      <td>8016292659</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393868</td>\n",
       "      <td>53.517021</td>\n",
       "      <td>(53.5170210930796, -113.393867920675)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHERWOOD PARK FREEWAY, 34 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286185</th>\n",
       "      <td>8016301495</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.337840</td>\n",
       "      <td>53.569248</td>\n",
       "      <td>(53.5692475906975, -113.3378401001)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278835</th>\n",
       "      <td>8016324398</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393881</td>\n",
       "      <td>53.526663</td>\n",
       "      <td>(53.5266632330489, -113.393881074527)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, 92 AVENUE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287819</th>\n",
       "      <td>8016344421</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.369249</td>\n",
       "      <td>53.540231</td>\n",
       "      <td>(53.5402306240876, -113.369248651913)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BASELINE ROAD, 17 STREET</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284646</th>\n",
       "      <td>8016397932</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393868</td>\n",
       "      <td>53.517021</td>\n",
       "      <td>(53.5170210930796, -113.393867920675)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34 STREET NW, SHERWOOD PARK FREEWAY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286914</th>\n",
       "      <td>8016501718</td>\n",
       "      <td>RUNDLE HEIGHTS</td>\n",
       "      <td>-113.399925</td>\n",
       "      <td>53.553974</td>\n",
       "      <td>(53.5539741683956, -113.399924667067)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>103 AVENUE NW, 102 AVENUE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264421</th>\n",
       "      <td>8016513216</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.319723</td>\n",
       "      <td>53.572210</td>\n",
       "      <td>(53.5722101793048, -113.319722696429)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YELLOWHEAD TRAIL, 17 STREET NE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97945</th>\n",
       "      <td>8016526499</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.368849</td>\n",
       "      <td>53.716003</td>\n",
       "      <td>(53.7160025364029, -113.368848822252)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18 STREET NW, 259 AVENUE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51100</th>\n",
       "      <td>8016633504</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.319704</td>\n",
       "      <td>53.568670</td>\n",
       "      <td>(53.568669567728, -113.319704040263)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANTHONY HENDAY DRIVE, 17 STREET NE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268636</th>\n",
       "      <td>8016634848</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.319704</td>\n",
       "      <td>53.568670</td>\n",
       "      <td>(53.568669567728, -113.319704040263)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANTHONY HENDAY DRIVE, 17 STREET NE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232895</th>\n",
       "      <td>8016666083</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.337840</td>\n",
       "      <td>53.569248</td>\n",
       "      <td>(53.5692475906975, -113.3378401001)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268654</th>\n",
       "      <td>8016672872</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.689189</td>\n",
       "      <td>53.403168</td>\n",
       "      <td>(53.403167739067, -113.689188887702)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WINTERBURN ROAD SW, 33 AVENUE SW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220203</th>\n",
       "      <td>8016687667</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393880</td>\n",
       "      <td>53.519349</td>\n",
       "      <td>(53.5193485524044, -113.393879935041)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84 AVENUE NW, 34 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219871</th>\n",
       "      <td>8016732338</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.393855</td>\n",
       "      <td>53.541176</td>\n",
       "      <td>(53.5411756042498, -113.393854824035)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101 AVENUE NW, 34 STREET NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290635</th>\n",
       "      <td>8016879975</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-113.337840</td>\n",
       "      <td>53.569248</td>\n",
       "      <td>(53.5692475906975, -113.3378401001)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE NW</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>553 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Reference Number               Neighbourhood        Long        Lat  \\\n",
       "124350         138161895                         NaN -113.319828  53.572165   \n",
       "280555         144439715                         NaN -113.393851  53.541093   \n",
       "284734         144938773                         NaN -113.431093  53.657816   \n",
       "285411         144997410                         NaN -113.435104  53.651982   \n",
       "275590         146016603                         NaN -113.393851  53.541093   \n",
       "81569          151576805  ANTHONY HENDAY ENERGY PARK -113.435104  53.651982   \n",
       "285562         153265751                         NaN -113.369257  53.539393   \n",
       "285881         153608576                         NaN -113.492369  53.652614   \n",
       "286312         156410749                         NaN -113.368849  53.715999   \n",
       "285641         159208149                         NaN -113.369257  53.539393   \n",
       "269697         160052684                         NaN -113.430779  53.657810   \n",
       "280045         162359075                         NaN -113.435104  53.651982   \n",
       "267960         162767387                         NaN -113.393876  53.517725   \n",
       "272562         162769123                         NaN -113.393884  53.519351   \n",
       "187545         162773490                         NaN -113.393888  53.526661   \n",
       "273749         162829112                         NaN -113.393884  53.519351   \n",
       "281337         162832991                         NaN -113.393888  53.526661   \n",
       "201935         162860180                         NaN -113.393884  53.519351   \n",
       "256411         167244202                         NaN -113.435104  53.651982   \n",
       "151022         172620737  ANTHONY HENDAY ENERGY PARK -113.435104  53.651982   \n",
       "281881         172840369                         NaN -113.393888  53.526661   \n",
       "148554         174895385                         NaN -113.319828  53.572165   \n",
       "278554         188602040                         NaN -113.344502  53.424890   \n",
       "51881          219094972                         NaN -113.368849  53.715999   \n",
       "203962         221407383                         NaN -113.393860  53.541267   \n",
       "193831         223808226                         NaN -113.393860  53.541267   \n",
       "216487         226231010                         NaN -113.393851  53.541093   \n",
       "289411         226749588                         NaN -113.393851  53.541093   \n",
       "289412         226770525                         NaN -113.393860  53.541267   \n",
       "282449         229195226                         NaN -113.393851  53.541093   \n",
       "...                  ...                         ...         ...        ...   \n",
       "214082        8015849149                         NaN -113.430939  53.657816   \n",
       "209274        8015885883                         NaN -113.639035  53.602633   \n",
       "208454        8015894427                         NaN -113.333073  53.569059   \n",
       "277531        8015907342                         NaN -113.393868  53.517021   \n",
       "259720        8015953554                         NaN -113.319723  53.572210   \n",
       "215802        8015998256                         NaN -113.393868  53.517021   \n",
       "286668        8016004935                         NaN -113.393855  53.541176   \n",
       "226027        8016091240                         NaN -113.329029  53.569872   \n",
       "220584        8016130398                         NaN -113.344263  53.715978   \n",
       "233347        8016137467                         NaN -113.344263  53.715978   \n",
       "205555        8016168359                         NaN -113.329029  53.569872   \n",
       "236444        8016193996                         NaN -113.369110  53.517109   \n",
       "230901        8016196629                         NaN -113.369110  53.517109   \n",
       "237311        8016204175                         NaN -113.319723  53.572210   \n",
       "266023        8016253888                         NaN -113.393868  53.517021   \n",
       "286085        8016292659                         NaN -113.393868  53.517021   \n",
       "286185        8016301495                         NaN -113.337840  53.569248   \n",
       "278835        8016324398                         NaN -113.393881  53.526663   \n",
       "287819        8016344421                         NaN -113.369249  53.540231   \n",
       "284646        8016397932                         NaN -113.393868  53.517021   \n",
       "286914        8016501718              RUNDLE HEIGHTS -113.399925  53.553974   \n",
       "264421        8016513216                         NaN -113.319723  53.572210   \n",
       "97945         8016526499                         NaN -113.368849  53.716003   \n",
       "51100         8016633504                         NaN -113.319704  53.568670   \n",
       "268636        8016634848                         NaN -113.319704  53.568670   \n",
       "232895        8016666083                         NaN -113.337840  53.569248   \n",
       "268654        8016672872                         NaN -113.689189  53.403168   \n",
       "220203        8016687667                         NaN -113.393880  53.519349   \n",
       "219871        8016732338                         NaN -113.393855  53.541176   \n",
       "290635        8016879975                         NaN -113.337840  53.569248   \n",
       "\n",
       "                                     Location  Ward  \\\n",
       "124350  (53.5721647587943, -113.319828128951)   NaN   \n",
       "280555  (53.5410929339599, -113.393851164659)   NaN   \n",
       "284734  (53.6578161005905, -113.431092714122)   NaN   \n",
       "285411  (53.6519824931068, -113.435103806662)   NaN   \n",
       "275590  (53.5410929339599, -113.393851164659)   NaN   \n",
       "81569   (53.6519824931068, -113.435103806662)   NaN   \n",
       "285562  (53.5393933297421, -113.369257408744)   NaN   \n",
       "285881   (53.6526143917998, -113.49236850964)   NaN   \n",
       "286312  (53.7159985749835, -113.368849209972)   NaN   \n",
       "285641  (53.5393933297421, -113.369257408744)   NaN   \n",
       "269697   (53.6578098259984, -113.43077878735)   NaN   \n",
       "280045  (53.6519824931068, -113.435103806662)   NaN   \n",
       "267960   (53.5177250160081, -113.39387642079)   NaN   \n",
       "272562   (53.519351264349, -113.393883823288)   NaN   \n",
       "187545  (53.5266609736857, -113.393887759204)   NaN   \n",
       "273749   (53.519351264349, -113.393883823288)   NaN   \n",
       "281337  (53.5266609736857, -113.393887759204)   NaN   \n",
       "201935   (53.519351264349, -113.393883823288)   NaN   \n",
       "256411  (53.6519824931068, -113.435103806662)   NaN   \n",
       "151022  (53.6519824931068, -113.435103806662)   NaN   \n",
       "281881  (53.5266609736857, -113.393887759204)   NaN   \n",
       "148554  (53.5721647587943, -113.319828128951)   NaN   \n",
       "278554  (53.4248904564429, -113.344501521042)   NaN   \n",
       "51881   (53.7159985749835, -113.368849209972)   NaN   \n",
       "203962  (53.5412666727894, -113.393860432771)   NaN   \n",
       "193831  (53.5412666727894, -113.393860432771)   NaN   \n",
       "216487  (53.5410929339599, -113.393851164659)   NaN   \n",
       "289411  (53.5410929339599, -113.393851164659)   NaN   \n",
       "289412  (53.5412666727894, -113.393860432771)   NaN   \n",
       "282449  (53.5410929339599, -113.393851164659)   NaN   \n",
       "...                                       ...   ...   \n",
       "214082  (53.6578157933353, -113.430939427393)   NaN   \n",
       "209274  (53.6026331887335, -113.639034592283)   NaN   \n",
       "208454  (53.5690593584477, -113.333072742178)   NaN   \n",
       "277531  (53.5170210930796, -113.393867920675)   NaN   \n",
       "259720  (53.5722101793048, -113.319722696429)   NaN   \n",
       "215802  (53.5170210930796, -113.393867920675)   NaN   \n",
       "286668  (53.5411756042498, -113.393854824035)   NaN   \n",
       "226027  (53.5698724501474, -113.329029270362)   NaN   \n",
       "220584  (53.7159783396282, -113.344263299772)   NaN   \n",
       "233347  (53.7159783396282, -113.344263299772)   NaN   \n",
       "205555  (53.5698724501474, -113.329029270362)   NaN   \n",
       "236444  (53.5171086789885, -113.369109632496)   NaN   \n",
       "230901  (53.5171086789885, -113.369109632496)   NaN   \n",
       "237311  (53.5722101793048, -113.319722696429)   NaN   \n",
       "266023  (53.5170210930796, -113.393867920675)   NaN   \n",
       "286085  (53.5170210930796, -113.393867920675)   NaN   \n",
       "286185    (53.5692475906975, -113.3378401001)   NaN   \n",
       "278835  (53.5266632330489, -113.393881074527)   NaN   \n",
       "287819  (53.5402306240876, -113.369248651913)   NaN   \n",
       "284646  (53.5170210930796, -113.393867920675)   NaN   \n",
       "286914  (53.5539741683956, -113.399924667067)   NaN   \n",
       "264421  (53.5722101793048, -113.319722696429)   NaN   \n",
       "97945   (53.7160025364029, -113.368848822252)   NaN   \n",
       "51100    (53.568669567728, -113.319704040263)   NaN   \n",
       "268636   (53.568669567728, -113.319704040263)   NaN   \n",
       "232895    (53.5692475906975, -113.3378401001)   NaN   \n",
       "268654   (53.403167739067, -113.689188887702)   NaN   \n",
       "220203  (53.5193485524044, -113.393879935041)   NaN   \n",
       "219871  (53.5411756042498, -113.393854824035)   NaN   \n",
       "290635    (53.5692475906975, -113.3378401001)   NaN   \n",
       "\n",
       "                                                  Address  \n",
       "124350  17 STREET NE, YELLOWHEAD TRAIL [WESTBOUND SIDE...  \n",
       "280555  34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW, ...  \n",
       "284734      195 AVENUE NW, 66 STREET [SOUTHBOUND SIDE] NW  \n",
       "285411  66 STREET [SOUTHBOUND SIDE] NW, ANTHONY HENDAY...  \n",
       "275590  34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW, ...  \n",
       "81569               66 STREET NW, ANTHONY HENDAY DRIVE NW  \n",
       "285562                           17 STREET, BASELINE ROAD  \n",
       "285881  97 STREET [SOUTHBOUND SIDE] NW, ANTHONY HENDAY...  \n",
       "286312                        18 STREET NW, 259 AVENUE NW  \n",
       "285641                           17 STREET, BASELINE ROAD  \n",
       "269697      195 AVENUE NW, 66 STREET [NORTHBOUND SIDE] NW  \n",
       "280045  66 STREET [SOUTHBOUND SIDE] NW, ANTHONY HENDAY...  \n",
       "267960  34 STREET NW, SHERWOOD PARK FREEWAY [WESTBOUND...  \n",
       "272562                         34 STREET NW, 84 AVENUE NW  \n",
       "187545                         92 AVENUE NW, 34 STREET NW  \n",
       "273749                         34 STREET NW, 84 AVENUE NW  \n",
       "281337                         92 AVENUE NW, 34 STREET NW  \n",
       "201935                         34 STREET NW, 84 AVENUE NW  \n",
       "256411  66 STREET [SOUTHBOUND SIDE] NW, ANTHONY HENDAY...  \n",
       "151022              66 STREET NW, ANTHONY HENDAY DRIVE NW  \n",
       "281881                         92 AVENUE NW, 34 STREET NW  \n",
       "148554  17 STREET NE, YELLOWHEAD TRAIL [WESTBOUND SIDE...  \n",
       "278554              ELLERSLIE ROAD SW, MERIDIAN STREET SW  \n",
       "51881                         18 STREET NW, 259 AVENUE NW  \n",
       "203962  34 STREET NW, 101 AVENUE [WESTBOUND SIDE] NW, ...  \n",
       "193831  34 STREET NW, 101 AVENUE [WESTBOUND SIDE] NW, ...  \n",
       "216487       34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW  \n",
       "289411  34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW, ...  \n",
       "289412  34 STREET NW, 101 AVENUE [WESTBOUND SIDE] NW, ...  \n",
       "282449  34 STREET NW, 101 AVENUE [EASTBOUND SIDE] NW, ...  \n",
       "...                                                   ...  \n",
       "214082                        195 AVENUE NW, 66 STREET NW  \n",
       "209274                       137 AVENUE NW, 184 STREET NW  \n",
       "208454          YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE NW  \n",
       "277531                34 STREET NW, SHERWOOD PARK FREEWAY  \n",
       "259720                     YELLOWHEAD TRAIL, 17 STREET NE  \n",
       "215802                34 STREET NW, SHERWOOD PARK FREEWAY  \n",
       "286668                        101 AVENUE NW, 34 STREET NW  \n",
       "226027             ANTHONY HENDAY DRIVE, YELLOWHEAD TRAIL  \n",
       "220584                  259 AVENUE NW, MERIDIAN STREET NW  \n",
       "233347                  MERIDIAN STREET NW, 259 AVENUE NW  \n",
       "205555             YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE  \n",
       "236444                   SHERWOOD PARK FREEWAY, 17 STREET  \n",
       "230901                   17 STREET, SHERWOOD PARK FREEWAY  \n",
       "237311                     YELLOWHEAD TRAIL, 17 STREET NE  \n",
       "266023                SHERWOOD PARK FREEWAY, 34 STREET NW  \n",
       "286085                SHERWOOD PARK FREEWAY, 34 STREET NW  \n",
       "286185          YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE NW  \n",
       "278835                         34 STREET NW, 92 AVENUE NW  \n",
       "287819                           BASELINE ROAD, 17 STREET  \n",
       "284646                34 STREET NW, SHERWOOD PARK FREEWAY  \n",
       "286914                       103 AVENUE NW, 102 AVENUE NW  \n",
       "264421                     YELLOWHEAD TRAIL, 17 STREET NE  \n",
       "97945                         18 STREET NW, 259 AVENUE NW  \n",
       "51100                  ANTHONY HENDAY DRIVE, 17 STREET NE  \n",
       "268636                 ANTHONY HENDAY DRIVE, 17 STREET NE  \n",
       "232895          YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE NW  \n",
       "268654                   WINTERBURN ROAD SW, 33 AVENUE SW  \n",
       "220203                         84 AVENUE NW, 34 STREET NW  \n",
       "219871                        101 AVENUE NW, 34 STREET NW  \n",
       "290635          YELLOWHEAD TRAIL, ANTHONY HENDAY DRIVE NW  \n",
       "\n",
       "[553 rows x 7 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7.loc[df7['Ward'].isnull(), ['Reference Number','Neighbourhood', 'Long', 'Lat','Location','Ward', 'Address']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "del df7['Address']\n",
    "del df7['Lat']\n",
    "del df7['Long']\n",
    "del df7['Location']\n",
    "del df7['Reference Number']\n",
    "\n",
    "#binarization is done on a server with more memory"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date Closed', 'Status Detail', 'Service Code', 'Neighbourhood', 'Ward',\n",
       "       'Ticket Source', 'Days to Resolution', 'Month Created', 'Month Closed',\n",
       "       'Day of Week Request Closed', 'Holidays Closed',\n",
       "       'avg_hourly_temperature Closed', 'min_windchill Closed',\n",
       "       'avg_dew_point Closed', 'max_wind_gust Closed',\n",
       "       'wind_gust_dir_10s Closed', 'avg_health_index Closed',\n",
       "       'precipitation Closed', 'sunlight Closed', 'MEETING_TYPE Closed'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NaN         273985\n",
       "moderate     16345\n",
       "high          1186\n",
       "Name: avg_health_index Closed, dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# drop low because it is really common\n",
    "#df7.loc[df7['avg_health_index Created'] == 'low', 'avg_health_index Created'] = np.nan\n",
    "df7['avg_health_index Closed'].value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NaN            246059\n",
       "very humid      32006\n",
       "comfortable     11330\n",
       "ok               1856\n",
       "somewhat          265\n",
       "Name: avg_dew_point Closed, dtype: int64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# drop dry because it is really common\n",
    "#df7.loc[df7['avg_dew_point Created'] == 'dry', 'avg_dew_point Created'] = np.nan\n",
    "df7['avg_dew_point Closed'].value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "del df7['Month Created']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Abandoned Vehicle': 6273,\n",
       " 'Alley': 2596,\n",
       " 'Alley Dust': 133,\n",
       " 'Alley Flooding': 183,\n",
       " 'Alley Windrow': 761,\n",
       " 'Ashtray': 13,\n",
       " 'Audible Signal Outage': 133,\n",
       " 'Audible Signal Request': 821,\n",
       " 'Ball Diamond Repair': 84,\n",
       " 'Beaver/Muskrat Dam': 82,\n",
       " 'Bees/Wasps': 575,\n",
       " 'Bike Lanes': 1,\n",
       " 'Boulevard': 2243,\n",
       " 'Bridge': 173,\n",
       " 'Broken Branches': 6096,\n",
       " 'Broken Concrete': 35,\n",
       " 'Broken Glass': 31,\n",
       " 'Broken Manhole Cover': 3672,\n",
       " 'Broken Play Structure': 1954,\n",
       " 'Broken Sports Structure': 75,\n",
       " 'Bus': 269,\n",
       " 'Bus Bench Request': 20,\n",
       " 'Bus Pads or Shelter Request': 72,\n",
       " 'Bus Phone - Out of Order': 24,\n",
       " 'Bus Stop': 1117,\n",
       " 'Canada Post Mail box': 39,\n",
       " 'City Sidewalks': 2728,\n",
       " 'Crack': 1425,\n",
       " 'Cross Walk Painting Request': 618,\n",
       " 'Curb': 444,\n",
       " 'Curb Installation': 109,\n",
       " 'DATS Bus Stuck in Snow': 58,\n",
       " 'Damaged Bus Stop Sign': 59,\n",
       " 'Damaged Emergency Sign (i.e. Stop Sign)': 2382,\n",
       " 'Damaged Non-Emergency Signs (i.e. Speed Limit)': 4105,\n",
       " 'Dead Animal': 10492,\n",
       " 'Dead Tree': 2081,\n",
       " 'Disable Stall': 605,\n",
       " 'Drain/Manhole Cover/Sewer': 86,\n",
       " 'Dumpster': 180,\n",
       " 'EPCOR Power Box/Street Light': 551,\n",
       " 'ETS Sign Request': 226,\n",
       " 'Empty Sandbox at Community League': 2333,\n",
       " 'Facility': 85,\n",
       " 'Facility Sidewalk': 283,\n",
       " 'Federal/Provincial Building': 85,\n",
       " 'Flooded Trail': 16,\n",
       " 'Flooding - Playground': 345,\n",
       " 'Flooding Sidewalk': 906,\n",
       " 'Flowers': 49,\n",
       " 'Garbage Can Full': 1771,\n",
       " 'Garbage Can Needed': 551,\n",
       " 'Garbage Can Request': 57,\n",
       " 'Gophers/Squirrels': 263,\n",
       " 'Green Shack/Gazebo': 42,\n",
       " 'Green Space': 1850,\n",
       " 'Green Space Grass Clipppings': 116,\n",
       " 'Hazardous Branch': 5949,\n",
       " 'Hazardous Stump': 221,\n",
       " 'Herbicide Spray Compliant': 100,\n",
       " 'Holes on Soccer Field': 60,\n",
       " 'LRT Arms Malfunction': 74,\n",
       " 'Line Marking request': 452,\n",
       " 'Manhole Cover Concern': 19012,\n",
       " 'Meter Maintenance': 151,\n",
       " 'Newspaper Box/Sign': 140,\n",
       " 'Obstruction': 1079,\n",
       " 'On Trail': 35,\n",
       " 'Other': 1466,\n",
       " 'Other Grass Clippings': 384,\n",
       " 'Overgrown Grass': 5570,\n",
       " 'Paint Marking Request': 1026,\n",
       " 'Park Structure': 1250,\n",
       " 'Parking Lot': 91,\n",
       " 'Pathway': 93,\n",
       " 'Pathway Grass Clippings': 138,\n",
       " 'Paving': 1250,\n",
       " 'Pedestrian Light Request': 1587,\n",
       " 'Plants Need Watering': 54,\n",
       " 'Play Apparatus': 270,\n",
       " 'Pothole': 15025,\n",
       " 'Rail Crossing': 109,\n",
       " 'Rail Crossing Repair': 3,\n",
       " 'Request for New Off-Leash Park': 58,\n",
       " 'Restricted Residential': 1266,\n",
       " 'River Valley': 301,\n",
       " 'Road': 56437,\n",
       " 'Road Blocked By Snow': 5714,\n",
       " 'Road Dip': 7185,\n",
       " 'Road Flooding': 2551,\n",
       " 'Road Snow Removal': 18918,\n",
       " 'Road Vibration': 197,\n",
       " 'Road Windrow': 2047,\n",
       " 'Safety & Other': 8766,\n",
       " 'Sandbox': 5,\n",
       " 'Sanding': 10066,\n",
       " 'Seasonal Parking Ban': 57,\n",
       " 'Sewer': 3738,\n",
       " 'Shaw/Telus Box': 59,\n",
       " 'Shrubs Need Trimming': 577,\n",
       " 'Sidewalk': 1716,\n",
       " 'Sidewalk Crack': 3210,\n",
       " 'Sidewalk Displacement': 5270,\n",
       " 'Sidewalk Windrow': 2749,\n",
       " 'Sidewalks': 3503,\n",
       " 'Sign Request': 7547,\n",
       " 'Sign Requested': 93,\n",
       " 'Signal Malfunction - Pedestrian Walk light': 1835,\n",
       " 'Signal Timing (Green Light)': 3774,\n",
       " 'Signal Timing (Left Turn Arrow)': 2535,\n",
       " 'Sinkhole': 1647,\n",
       " 'Skateboard Park': 65,\n",
       " 'Snow Fence': 91,\n",
       " 'Sound Wall': 276,\n",
       " 'Spillage': 1107,\n",
       " 'Sports Track': 24,\n",
       " 'Sportsfield Grass Clippings': 81,\n",
       " 'Spray Park': 15,\n",
       " 'Stairs': 52,\n",
       " 'Steel Plate': 878,\n",
       " 'Storm Outfall': 19,\n",
       " 'Street Furniture': 435,\n",
       " 'Street Light': 39,\n",
       " 'Street Sweeping': 3636,\n",
       " 'Temporary Stop Sign Damaged': 33,\n",
       " 'Tennis Court Nets': 15,\n",
       " 'Tow Away Zone': 1342,\n",
       " 'Track Repair': 10,\n",
       " 'Trail': 600,\n",
       " 'Trail Clearing': 767,\n",
       " 'Tree Bugs': 767,\n",
       " 'Tree Damage': 165,\n",
       " 'Tree Light Outage': 125,\n",
       " 'Tree Planting': 141,\n",
       " 'Tree Pruning Debris': 1064,\n",
       " 'Tree Pruning Request': 6181,\n",
       " 'Tree Removal': 71,\n",
       " 'Tree Replacement': 147,\n",
       " 'Turf Damage': 740,\n",
       " 'Vandalism - Play Structure': 1431,\n",
       " 'Vandalism - Skateboard Park': 41,\n",
       " 'Vandalism - Spray Park': 130,\n",
       " 'Vehicle Damaged Sign': 377,\n",
       " 'Walkway': 117,\n",
       " 'Waste Bin- Private Property': 24,\n",
       " 'Weed Control': 692,\n",
       " 'Wooden Stairs': 32}"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7['Service Code'].value_counts().to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df7.loc[df7['Service Code'] == \"Sidewalks\", 'Service Code'] = \"Sidewalk\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NaN          168761\n",
       "moderate     105936\n",
       "high          12440\n",
       "low            3869\n",
       "very high       510\n",
       "Name: min_windchill Closed, dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7['min_windchill Closed'].value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date Closed', 'Status Detail', 'Service Code', 'Neighbourhood', 'Ward',\n",
       "       'Ticket Source', 'Days to Resolution', 'Month Closed',\n",
       "       'Day of Week Request Closed', 'Holidays Closed',\n",
       "       'avg_hourly_temperature Closed', 'min_windchill Closed',\n",
       "       'avg_dew_point Closed', 'max_wind_gust Closed',\n",
       "       'wind_gust_dir_10s Closed', 'avg_health_index Closed',\n",
       "       'precipitation Closed', 'sunlight Closed', 'MEETING_TYPE Closed'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df7 = df7.loc[df7['Date Closed'].notnull()]\n",
    "del df7['Date Closed']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "del df7['Ward']\n",
    "df7.to_csv('data/data_merged_closed_month.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Status Detail</th>\n",
       "      <th>Service Code</th>\n",
       "      <th>Neighbourhood</th>\n",
       "      <th>Ticket Source</th>\n",
       "      <th>Days to Resolution</th>\n",
       "      <th>Month Closed</th>\n",
       "      <th>Day of Week Request Closed</th>\n",
       "      <th>Holidays Closed</th>\n",
       "      <th>avg_hourly_temperature Closed</th>\n",
       "      <th>min_windchill Closed</th>\n",
       "      <th>avg_dew_point Closed</th>\n",
       "      <th>max_wind_gust Closed</th>\n",
       "      <th>wind_gust_dir_10s Closed</th>\n",
       "      <th>avg_health_index Closed</th>\n",
       "      <th>precipitation Closed</th>\n",
       "      <th>sunlight Closed</th>\n",
       "      <th>MEETING_TYPE Closed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>284799</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Shaw/Telus Box</td>\n",
       "      <td>WESTMOUNT</td>\n",
       "      <td>Internet Mail</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>ROPER INDUSTRIAL</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>LARKSPUR</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>GROVENOR</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>KENSINGTON</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274894</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>HOLYROOD</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284800</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>HIGHLANDS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284801</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>MCCAULEY</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284802</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Newspaper Box/Sign</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276418</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>DAVIES INDUSTRIAL EAST</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>RAMPART INDUSTRIAL</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Shaw/Telus Box</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>BONNIE DOON</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284803</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>FOREST HEIGHTS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>WNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284804</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>CAPILANO</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276421</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>CRAWFORD PLAINS</td>\n",
       "      <td>Internet Mail</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270907</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>SPRUCE AVENUE</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>WNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289926</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>SPRUCE AVENUE</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284805</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>RAMPART INDUSTRIAL</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274028</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada Post Mail box</td>\n",
       "      <td>GREENVIEW</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>very humid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16+</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255442</th>\n",
       "      <td>NaN</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>INGLEWOOD</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>comfortable</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>16+</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274029</th>\n",
       "      <td>NaN</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>BELLEVUE</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>very humid</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>16+</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272239</th>\n",
       "      <td>NaN</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>VIRGINIA PARK</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16+</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284806</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada Post Mail box</td>\n",
       "      <td>BULYEA HEIGHTS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>ANTHONY HENDAY ENERGY PARK</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(80, inf]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284807</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>ANTHONY HENDAY ENERGY PARK</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>high</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284808</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>HAWIN PARK ESTATE INDUSTRIAL</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270201</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>CHAMBERY</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284809</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>MEYOKUMIN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>&lt;8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262102</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>GLENORA</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(2, 4]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282365</th>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Restricted Residential</td>\n",
       "      <td>SOUTH TERWILLEGAR</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282367</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Sign Request</td>\n",
       "      <td>WEBBER GREENS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282808</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Signal Timing (Left Turn Arrow)</td>\n",
       "      <td>WEBBER GREENS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>(8, 10]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282376</th>\n",
       "      <td>Redirected to Other Government Agency</td>\n",
       "      <td>Road Dip</td>\n",
       "      <td>ALLENDALE</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282383</th>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Restricted Residential</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238865</th>\n",
       "      <td>Warning Issued, No Further Action at this Time</td>\n",
       "      <td>Tow Away Zone</td>\n",
       "      <td>THE HAMPTONS</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238888</th>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Disable Stall</td>\n",
       "      <td>STRATHCONA</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238906</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>EASTWOOD</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238907</th>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Disable Stall</td>\n",
       "      <td>HADDOW</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287718</th>\n",
       "      <td>Deferred-Future Work Planned.</td>\n",
       "      <td>Road</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287719</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Sign Request</td>\n",
       "      <td>THE HAMPTONS</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281384</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Road Dip</td>\n",
       "      <td>ORMSBY PLACE</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282391</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Road</td>\n",
       "      <td>JACKSON HEIGHTS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238996</th>\n",
       "      <td>Enforcement Action Taken</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>NORTHMOUNT</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287720</th>\n",
       "      <td>Citizen Complied</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>TERWILLEGAR TOWNE</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273937</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Signal Timing (Green Light)</td>\n",
       "      <td>POLLARD MEADOWS</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>(14, 16]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>SE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239053</th>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>HIGHLANDS</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282392</th>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>HILLVIEW</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282393</th>\n",
       "      <td>Citizen Complied</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>IDYLWYLDE</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239088</th>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>BRINTNELL</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239095</th>\n",
       "      <td>Enforcement Action Taken</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>RUTHERFORD</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>strong_winds</td>\n",
       "      <td>NNW</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282411</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Paving</td>\n",
       "      <td>CAPILANO</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282415</th>\n",
       "      <td>Deferred-Future Work Planned.</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>ROYAL GARDENS</td>\n",
       "      <td>Web Form</td>\n",
       "      <td>(2, 4]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282804</th>\n",
       "      <td>Assessed-No Action Required</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>CALLAGHAN</td>\n",
       "      <td>Web Form</td>\n",
       "      <td>(4, 6]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Monday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>S</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287721</th>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>QUEEN ALEXANDRA</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239156</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Broken Manhole Cover</td>\n",
       "      <td>BLACKMUD CREEK</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282401</th>\n",
       "      <td>Citizen Complied</td>\n",
       "      <td>Abandoned Vehicle</td>\n",
       "      <td>CHAPPELLE AREA</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>(2, 4]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269793</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Road</td>\n",
       "      <td>LYNNWOOD</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>(2, 4]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282416</th>\n",
       "      <td>Enforcement Action Taken</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>DOWNTOWN</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282417</th>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>DOWNTOWN</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>[0, 2]</td>\n",
       "      <td>11.0</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>NaN</td>\n",
       "      <td>windy_direction</td>\n",
       "      <td>NNE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>yes</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>290851 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Status Detail  \\\n",
       "284799                                             NaN   \n",
       "0                                                  NaN   \n",
       "1                                                  NaN   \n",
       "2                                                  NaN   \n",
       "3                                                  NaN   \n",
       "274894                                             NaN   \n",
       "284800                                             NaN   \n",
       "284801                                             NaN   \n",
       "284802                                             NaN   \n",
       "276418                                             NaN   \n",
       "4                                                  NaN   \n",
       "251                                                NaN   \n",
       "5                                                  NaN   \n",
       "284803                                             NaN   \n",
       "284804                                             NaN   \n",
       "276421                                             NaN   \n",
       "270907                                             NaN   \n",
       "289926                                             NaN   \n",
       "284805                                             NaN   \n",
       "274028                                             NaN   \n",
       "255442                                             NaN   \n",
       "274029                                             NaN   \n",
       "272239                                             NaN   \n",
       "284806                                             NaN   \n",
       "11                                                 NaN   \n",
       "284807                                             NaN   \n",
       "284808                                             NaN   \n",
       "270201                                             NaN   \n",
       "284809                                             NaN   \n",
       "262102                                             NaN   \n",
       "...                                                ...   \n",
       "282365                       Vehicle Gone Upon Arrival   \n",
       "282367                                             NaN   \n",
       "282808                                             NaN   \n",
       "282376           Redirected to Other Government Agency   \n",
       "282383           Does Not Meet Bylaw Offence Standards   \n",
       "238865  Warning Issued, No Further Action at this Time   \n",
       "238888           Does Not Meet Bylaw Offence Standards   \n",
       "238906                                             NaN   \n",
       "238907                       Vehicle Gone Upon Arrival   \n",
       "287718                   Deferred-Future Work Planned.   \n",
       "287719                                             NaN   \n",
       "281384                                             NaN   \n",
       "282391                                             NaN   \n",
       "238996                        Enforcement Action Taken   \n",
       "287720                                Citizen Complied   \n",
       "273937                                             NaN   \n",
       "239053           Does Not Meet Bylaw Offence Standards   \n",
       "282392                       Vehicle Gone Upon Arrival   \n",
       "282393                                Citizen Complied   \n",
       "239088                       Vehicle Gone Upon Arrival   \n",
       "239095                        Enforcement Action Taken   \n",
       "282411                                             NaN   \n",
       "282415                   Deferred-Future Work Planned.   \n",
       "282804                     Assessed-No Action Required   \n",
       "287721                       Vehicle Gone Upon Arrival   \n",
       "239156                                             NaN   \n",
       "282401                                Citizen Complied   \n",
       "269793                                             NaN   \n",
       "282416                        Enforcement Action Taken   \n",
       "282417           Does Not Meet Bylaw Offence Standards   \n",
       "\n",
       "                           Service Code                 Neighbourhood  \\\n",
       "284799                   Shaw/Telus Box                     WESTMOUNT   \n",
       "0                           Dead Animal              ROPER INDUSTRIAL   \n",
       "1                           Dead Animal                      LARKSPUR   \n",
       "2                           Dead Animal                      GROVENOR   \n",
       "3                           Dead Animal                    KENSINGTON   \n",
       "274894                      Dead Animal                      HOLYROOD   \n",
       "284800                      Dead Animal                     HIGHLANDS   \n",
       "284801                      Dead Animal                      MCCAULEY   \n",
       "284802               Newspaper Box/Sign                        OLIVER   \n",
       "276418                      Dead Animal        DAVIES INDUSTRIAL EAST   \n",
       "4                           Dead Animal            RAMPART INDUSTRIAL   \n",
       "251                      Shaw/Telus Box                        OLIVER   \n",
       "5                           Dead Animal                   BONNIE DOON   \n",
       "284803                      Dead Animal                FOREST HEIGHTS   \n",
       "284804                      Dead Animal                      CAPILANO   \n",
       "276421                      Dead Animal               CRAWFORD PLAINS   \n",
       "270907                      Dead Animal                 SPRUCE AVENUE   \n",
       "289926                      Dead Animal                 SPRUCE AVENUE   \n",
       "284805                      Dead Animal            RAMPART INDUSTRIAL   \n",
       "274028             Canada Post Mail box                     GREENVIEW   \n",
       "255442     EPCOR Power Box/Street Light                     INGLEWOOD   \n",
       "274029     EPCOR Power Box/Street Light                      BELLEVUE   \n",
       "272239     EPCOR Power Box/Street Light                 VIRGINIA PARK   \n",
       "284806             Canada Post Mail box                BULYEA HEIGHTS   \n",
       "11                          Dead Animal    ANTHONY HENDAY ENERGY PARK   \n",
       "284807                      Dead Animal    ANTHONY HENDAY ENERGY PARK   \n",
       "284808                      Dead Animal  HAWIN PARK ESTATE INDUSTRIAL   \n",
       "270201                      Dead Animal                      CHAMBERY   \n",
       "284809                      Dead Animal                     MEYOKUMIN   \n",
       "262102                      Dead Animal                       GLENORA   \n",
       "...                                 ...                           ...   \n",
       "282365           Restricted Residential             SOUTH TERWILLEGAR   \n",
       "282367                     Sign Request                 WEBBER GREENS   \n",
       "282808  Signal Timing (Left Turn Arrow)                 WEBBER GREENS   \n",
       "282376                         Road Dip                     ALLENDALE   \n",
       "282383           Restricted Residential                        OLIVER   \n",
       "238865                    Tow Away Zone                  THE HAMPTONS   \n",
       "238888                    Disable Stall                    STRATHCONA   \n",
       "238906                   Safety & Other                      EASTWOOD   \n",
       "238907                    Disable Stall                        HADDOW   \n",
       "287718                             Road                        OLIVER   \n",
       "287719                     Sign Request                  THE HAMPTONS   \n",
       "281384                         Road Dip                  ORMSBY PLACE   \n",
       "282391                             Road               JACKSON HEIGHTS   \n",
       "238996                   Safety & Other                    NORTHMOUNT   \n",
       "287720                   Safety & Other             TERWILLEGAR TOWNE   \n",
       "273937      Signal Timing (Green Light)               POLLARD MEADOWS   \n",
       "239053                   Safety & Other                     HIGHLANDS   \n",
       "282392                   Safety & Other                      HILLVIEW   \n",
       "282393                   Safety & Other                     IDYLWYLDE   \n",
       "239088                   Safety & Other                     BRINTNELL   \n",
       "239095                   Safety & Other                    RUTHERFORD   \n",
       "282411                           Paving                      CAPILANO   \n",
       "282415                          Pothole                 ROYAL GARDENS   \n",
       "282804                          Pothole                     CALLAGHAN   \n",
       "287721                   Safety & Other               QUEEN ALEXANDRA   \n",
       "239156             Broken Manhole Cover                BLACKMUD CREEK   \n",
       "282401                Abandoned Vehicle                CHAPPELLE AREA   \n",
       "269793                             Road                      LYNNWOOD   \n",
       "282416                   Safety & Other                      DOWNTOWN   \n",
       "282417                   Safety & Other                      DOWNTOWN   \n",
       "\n",
       "         Ticket Source Days to Resolution  Month Closed  \\\n",
       "284799   Internet Mail          (80, inf]           5.0   \n",
       "0       Telephone call             [0, 2]           1.0   \n",
       "1       Telephone call             [0, 2]           1.0   \n",
       "2       Telephone call             [0, 2]           1.0   \n",
       "3       Telephone call             [0, 2]           1.0   \n",
       "274894  Telephone call             [0, 2]           1.0   \n",
       "284800  Telephone call          (80, inf]           4.0   \n",
       "284801  Telephone call             [0, 2]           1.0   \n",
       "284802  Telephone call          (80, inf]           5.0   \n",
       "276418  Telephone call             [0, 2]           1.0   \n",
       "4       Telephone call             [0, 2]           1.0   \n",
       "251     Telephone call             [0, 2]           1.0   \n",
       "5       Telephone call             [0, 2]           1.0   \n",
       "284803  Telephone call             [0, 2]           1.0   \n",
       "284804  Telephone call             [0, 2]           1.0   \n",
       "276421   Internet Mail             [0, 2]           1.0   \n",
       "270907  Telephone call             [0, 2]           1.0   \n",
       "289926  Telephone call          (80, inf]           4.0   \n",
       "284805  Telephone call             [0, 2]           1.0   \n",
       "274028  Telephone call          (80, inf]           5.0   \n",
       "255442  Telephone call          (80, inf]           6.0   \n",
       "274029  Telephone call          (80, inf]           6.0   \n",
       "272239  Telephone call          (80, inf]           6.0   \n",
       "284806  Telephone call          (80, inf]           5.0   \n",
       "11      Telephone call          (80, inf]           4.0   \n",
       "284807  Telephone call             [0, 2]           1.0   \n",
       "284808  Telephone call             [0, 2]           1.0   \n",
       "270201  Telephone call             [0, 2]           1.0   \n",
       "284809  Telephone call             [0, 2]           1.0   \n",
       "262102  Telephone call             (2, 4]           1.0   \n",
       "...                ...                ...           ...   \n",
       "282365       MobileApp             [0, 2]          11.0   \n",
       "282367  Telephone call             [0, 2]          11.0   \n",
       "282808  Telephone call            (8, 10]          11.0   \n",
       "282376  Telephone call             [0, 2]          11.0   \n",
       "282383       MobileApp             [0, 2]          11.0   \n",
       "238865       MobileApp             [0, 2]          10.0   \n",
       "238888      Posse Auto             [0, 2]          10.0   \n",
       "238906      Posse Auto             [0, 2]          10.0   \n",
       "238907       MobileApp             [0, 2]          10.0   \n",
       "287718  Telephone call             [0, 2]          11.0   \n",
       "287719       MobileApp             [0, 2]          11.0   \n",
       "281384       MobileApp             [0, 2]          11.0   \n",
       "282391  Telephone call             [0, 2]          11.0   \n",
       "238996      Posse Auto             [0, 2]          10.0   \n",
       "287720       MobileApp             [0, 2]          11.0   \n",
       "273937       MobileApp           (14, 16]          11.0   \n",
       "239053      Posse Auto             [0, 2]          10.0   \n",
       "282392       MobileApp             [0, 2]          11.0   \n",
       "282393      Posse Auto             [0, 2]          11.0   \n",
       "239088       MobileApp             [0, 2]          10.0   \n",
       "239095       MobileApp             [0, 2]          10.0   \n",
       "282411  Telephone call             [0, 2]          11.0   \n",
       "282415        Web Form             (2, 4]          11.0   \n",
       "282804        Web Form             (4, 6]          11.0   \n",
       "287721       MobileApp             [0, 2]          11.0   \n",
       "239156  Telephone call             [0, 2]          11.0   \n",
       "282401      Posse Auto             (2, 4]          11.0   \n",
       "269793       MobileApp             (2, 4]          11.0   \n",
       "282416       MobileApp             [0, 2]          11.0   \n",
       "282417       MobileApp             [0, 2]          11.0   \n",
       "\n",
       "       Day of Week Request Closed Holidays Closed  \\\n",
       "284799                   Thursday             NaN   \n",
       "0                        Thursday             NaN   \n",
       "1                        Thursday             NaN   \n",
       "2                        Thursday             NaN   \n",
       "3                        Thursday             NaN   \n",
       "274894                   Thursday             NaN   \n",
       "284800                    Tuesday             NaN   \n",
       "284801                     Friday             NaN   \n",
       "284802                  Wednesday             NaN   \n",
       "276418                   Saturday             NaN   \n",
       "4                        Saturday             NaN   \n",
       "251                        Friday             NaN   \n",
       "5                        Saturday             NaN   \n",
       "284803                     Sunday             NaN   \n",
       "284804                     Monday             NaN   \n",
       "276421                     Monday             NaN   \n",
       "270907                    Tuesday             NaN   \n",
       "289926                    Tuesday             NaN   \n",
       "284805                  Wednesday             NaN   \n",
       "274028                     Friday             NaN   \n",
       "255442                    Tuesday             NaN   \n",
       "274029                   Thursday             NaN   \n",
       "272239                    Tuesday             NaN   \n",
       "284806                     Friday             NaN   \n",
       "11                        Tuesday             NaN   \n",
       "284807                   Thursday             NaN   \n",
       "284808                     Friday             NaN   \n",
       "270201                     Friday             NaN   \n",
       "284809                   Saturday             NaN   \n",
       "262102                     Friday             NaN   \n",
       "...                           ...             ...   \n",
       "282365                  Wednesday             NaN   \n",
       "282367                   Thursday             NaN   \n",
       "282808                     Friday             NaN   \n",
       "282376                  Wednesday             NaN   \n",
       "282383                  Wednesday             NaN   \n",
       "238865                    Tuesday             NaN   \n",
       "238888                    Tuesday             NaN   \n",
       "238906                    Tuesday             NaN   \n",
       "238907                    Tuesday             NaN   \n",
       "287718                   Thursday             NaN   \n",
       "287719                   Thursday             NaN   \n",
       "281384                  Wednesday             NaN   \n",
       "282391                  Wednesday             NaN   \n",
       "238996                    Tuesday             NaN   \n",
       "287720                   Thursday             NaN   \n",
       "273937                  Wednesday             NaN   \n",
       "239053                    Tuesday             NaN   \n",
       "282392                  Wednesday             NaN   \n",
       "282393                  Wednesday             NaN   \n",
       "239088                    Tuesday             NaN   \n",
       "239095                    Tuesday             NaN   \n",
       "282411                  Wednesday             NaN   \n",
       "282415                     Friday             NaN   \n",
       "282804                     Monday             NaN   \n",
       "287721                   Thursday             NaN   \n",
       "239156                  Wednesday             NaN   \n",
       "282401                   Saturday             NaN   \n",
       "269793                     Friday             NaN   \n",
       "282416                  Wednesday             NaN   \n",
       "282417                  Wednesday             NaN   \n",
       "\n",
       "       avg_hourly_temperature Closed min_windchill Closed  \\\n",
       "284799                           NaN                  NaN   \n",
       "0                                NaN             moderate   \n",
       "1                                NaN             moderate   \n",
       "2                                NaN             moderate   \n",
       "3                                NaN             moderate   \n",
       "274894                           NaN             moderate   \n",
       "284800                           NaN             moderate   \n",
       "284801                           NaN             moderate   \n",
       "284802                           NaN                  NaN   \n",
       "276418                           NaN             moderate   \n",
       "4                                NaN             moderate   \n",
       "251                              NaN             moderate   \n",
       "5                                NaN             moderate   \n",
       "284803                           NaN             moderate   \n",
       "284804                           NaN             moderate   \n",
       "276421                           NaN             moderate   \n",
       "270907                           NaN             moderate   \n",
       "289926                           NaN             moderate   \n",
       "284805                           NaN             moderate   \n",
       "274028                           NaN                  NaN   \n",
       "255442                           NaN                  NaN   \n",
       "274029                           NaN                  NaN   \n",
       "272239                           NaN                  NaN   \n",
       "284806                           NaN                  NaN   \n",
       "11                               NaN             moderate   \n",
       "284807                           NaN                 high   \n",
       "284808                           NaN             moderate   \n",
       "270201                           NaN             moderate   \n",
       "284809                           NaN             moderate   \n",
       "262102                           NaN             moderate   \n",
       "...                              ...                  ...   \n",
       "282365                           NaN             moderate   \n",
       "282367                           NaN             moderate   \n",
       "282808                           NaN             moderate   \n",
       "282376                           NaN             moderate   \n",
       "282383                           NaN             moderate   \n",
       "238865                           NaN             moderate   \n",
       "238888                           NaN             moderate   \n",
       "238906                           NaN             moderate   \n",
       "238907                           NaN             moderate   \n",
       "287718                           NaN             moderate   \n",
       "287719                           NaN             moderate   \n",
       "281384                           NaN             moderate   \n",
       "282391                           NaN             moderate   \n",
       "238996                           NaN             moderate   \n",
       "287720                           NaN             moderate   \n",
       "273937                           NaN             moderate   \n",
       "239053                           NaN             moderate   \n",
       "282392                           NaN             moderate   \n",
       "282393                           NaN             moderate   \n",
       "239088                           NaN             moderate   \n",
       "239095                           NaN             moderate   \n",
       "282411                           NaN             moderate   \n",
       "282415                           NaN             moderate   \n",
       "282804                           NaN             moderate   \n",
       "287721                           NaN             moderate   \n",
       "239156                           NaN             moderate   \n",
       "282401                           NaN             moderate   \n",
       "269793                           NaN             moderate   \n",
       "282416                           NaN             moderate   \n",
       "282417                           NaN             moderate   \n",
       "\n",
       "       avg_dew_point Closed max_wind_gust Closed wind_gust_dir_10s Closed  \\\n",
       "284799                  NaN                  NaN                      NaN   \n",
       "0                       NaN                  NaN                      NaN   \n",
       "1                       NaN                  NaN                      NaN   \n",
       "2                       NaN                  NaN                      NaN   \n",
       "3                       NaN                  NaN                      NaN   \n",
       "274894                  NaN                  NaN                      NaN   \n",
       "284800                  NaN         strong_winds                       NW   \n",
       "284801                  NaN                  NaN                      NaN   \n",
       "284802                  NaN      windy_direction                       NW   \n",
       "276418                  NaN                  NaN                      NaN   \n",
       "4                       NaN                  NaN                      NaN   \n",
       "251                     NaN                  NaN                      NaN   \n",
       "5                       NaN                  NaN                      NaN   \n",
       "284803                  NaN      windy_direction                      WNW   \n",
       "284804                  NaN                  NaN                      NaN   \n",
       "276421                  NaN                  NaN                      NaN   \n",
       "270907                  NaN         strong_winds                      WNW   \n",
       "289926                  NaN         strong_winds                       NW   \n",
       "284805                  NaN      windy_direction                        N   \n",
       "274028           very humid                  NaN                      NaN   \n",
       "255442          comfortable                  NaN                      NaN   \n",
       "274029           very humid      windy_direction                       NW   \n",
       "272239                  NaN                  NaN                      NaN   \n",
       "284806                  NaN      windy_direction                       NW   \n",
       "11                      NaN         strong_winds                       NW   \n",
       "284807                  NaN      windy_direction                        N   \n",
       "284808                  NaN                  NaN                      NaN   \n",
       "270201                  NaN                  NaN                      NaN   \n",
       "284809                  NaN                  NaN                      NaN   \n",
       "262102                  NaN         strong_winds                      NNW   \n",
       "...                     ...                  ...                      ...   \n",
       "282365                  NaN      windy_direction                      NNE   \n",
       "282367                  NaN                  NaN                      NaN   \n",
       "282808                  NaN                  NaN                      NaN   \n",
       "282376                  NaN      windy_direction                      NNE   \n",
       "282383                  NaN      windy_direction                      NNE   \n",
       "238865                  NaN         strong_winds                      NNW   \n",
       "238888                  NaN         strong_winds                      NNW   \n",
       "238906                  NaN         strong_winds                      NNW   \n",
       "238907                  NaN         strong_winds                      NNW   \n",
       "287718                  NaN                  NaN                      NaN   \n",
       "287719                  NaN                  NaN                      NaN   \n",
       "281384                  NaN      windy_direction                      NNE   \n",
       "282391                  NaN      windy_direction                      NNE   \n",
       "238996                  NaN         strong_winds                      NNW   \n",
       "287720                  NaN                  NaN                      NaN   \n",
       "273937                  NaN         strong_winds                       SE   \n",
       "239053                  NaN         strong_winds                      NNW   \n",
       "282392                  NaN      windy_direction                      NNE   \n",
       "282393                  NaN      windy_direction                      NNE   \n",
       "239088                  NaN         strong_winds                      NNW   \n",
       "239095                  NaN         strong_winds                      NNW   \n",
       "282411                  NaN      windy_direction                      NNE   \n",
       "282415                  NaN                  NaN                      NaN   \n",
       "282804                  NaN      windy_direction                        S   \n",
       "287721                  NaN                  NaN                      NaN   \n",
       "239156                  NaN      windy_direction                      NNE   \n",
       "282401                  NaN                  NaN                      NaN   \n",
       "269793                  NaN                  NaN                      NaN   \n",
       "282416                  NaN      windy_direction                      NNE   \n",
       "282417                  NaN      windy_direction                      NNE   \n",
       "\n",
       "       avg_health_index Closed precipitation Closed sunlight Closed  \\\n",
       "284799                     NaN                  yes              15   \n",
       "0                     moderate                  yes              <8   \n",
       "1                     moderate                  yes              <8   \n",
       "2                     moderate                  yes              <8   \n",
       "3                     moderate                  yes              <8   \n",
       "274894                moderate                  yes              <8   \n",
       "284800                     NaN                  NaN              15   \n",
       "284801                moderate                  yes              <8   \n",
       "284802                     NaN                  yes              15   \n",
       "276418                     NaN                  NaN              <8   \n",
       "4                          NaN                  NaN              <8   \n",
       "251                   moderate                  yes              <8   \n",
       "5                          NaN                  NaN              <8   \n",
       "284803                     NaN                  yes              <8   \n",
       "284804                     NaN                  NaN              <8   \n",
       "276421                     NaN                  NaN              <8   \n",
       "270907                     NaN                  yes              <8   \n",
       "289926                     NaN                  NaN              15   \n",
       "284805                     NaN                  NaN              <8   \n",
       "274028                     NaN                  NaN             16+   \n",
       "255442                     NaN                  yes             16+   \n",
       "274029                     NaN                  yes             16+   \n",
       "272239                     NaN                  NaN             16+   \n",
       "284806                     NaN                  NaN              15   \n",
       "11                         NaN                  NaN              15   \n",
       "284807                     NaN                  NaN              <8   \n",
       "284808                     NaN                  NaN              <8   \n",
       "270201                     NaN                  NaN              <8   \n",
       "284809                     NaN                  yes              <8   \n",
       "262102                     NaN                  yes               8   \n",
       "...                        ...                  ...             ...   \n",
       "282365                     NaN                  yes               9   \n",
       "282367                     NaN                  yes               9   \n",
       "282808                     NaN                  NaN               8   \n",
       "282376                     NaN                  yes               9   \n",
       "282383                     NaN                  yes               9   \n",
       "238865                     NaN                  yes               9   \n",
       "238888                     NaN                  yes               9   \n",
       "238906                     NaN                  yes               9   \n",
       "238907                     NaN                  yes               9   \n",
       "287718                     NaN                  yes               9   \n",
       "287719                     NaN                  yes               9   \n",
       "281384                     NaN                  yes               9   \n",
       "282391                     NaN                  yes               9   \n",
       "238996                     NaN                  yes               9   \n",
       "287720                     NaN                  yes               9   \n",
       "273937                     NaN                  NaN               8   \n",
       "239053                     NaN                  yes               9   \n",
       "282392                     NaN                  yes               9   \n",
       "282393                     NaN                  yes               9   \n",
       "239088                     NaN                  yes               9   \n",
       "239095                     NaN                  yes               9   \n",
       "282411                     NaN                  yes               9   \n",
       "282415                     NaN                  yes               9   \n",
       "282804                     NaN                  yes               9   \n",
       "287721                     NaN                  yes               9   \n",
       "239156                     NaN                  yes               9   \n",
       "282401                     NaN                  yes               9   \n",
       "269793                     NaN                  yes               9   \n",
       "282416                     NaN                  yes               9   \n",
       "282417                     NaN                  yes               9   \n",
       "\n",
       "       MEETING_TYPE Closed  \n",
       "284799                 NaN  \n",
       "0                      NaN  \n",
       "1                      NaN  \n",
       "2                      NaN  \n",
       "3                      NaN  \n",
       "274894                 NaN  \n",
       "284800                 NaN  \n",
       "284801                 NaN  \n",
       "284802                 NaN  \n",
       "276418                 NaN  \n",
       "4                      NaN  \n",
       "251                    NaN  \n",
       "5                      NaN  \n",
       "284803                 NaN  \n",
       "284804                 NaN  \n",
       "276421                 NaN  \n",
       "270907                 NaN  \n",
       "289926                 NaN  \n",
       "284805                 NaN  \n",
       "274028                 NaN  \n",
       "255442                 NaN  \n",
       "274029                 NaN  \n",
       "272239           Committee  \n",
       "284806                 NaN  \n",
       "11                     NaN  \n",
       "284807                 NaN  \n",
       "284808                 NaN  \n",
       "270201                 NaN  \n",
       "284809                 NaN  \n",
       "262102                 NaN  \n",
       "...                    ...  \n",
       "282365                 NaN  \n",
       "282367                 NaN  \n",
       "282808                 NaN  \n",
       "282376                 NaN  \n",
       "282383                 NaN  \n",
       "238865                 NaN  \n",
       "238888                 NaN  \n",
       "238906                 NaN  \n",
       "238907                 NaN  \n",
       "287718                 NaN  \n",
       "287719                 NaN  \n",
       "281384                 NaN  \n",
       "282391                 NaN  \n",
       "238996                 NaN  \n",
       "287720                 NaN  \n",
       "273937                 NaN  \n",
       "239053                 NaN  \n",
       "282392                 NaN  \n",
       "282393                 NaN  \n",
       "239088                 NaN  \n",
       "239095                 NaN  \n",
       "282411                 NaN  \n",
       "282415                 NaN  \n",
       "282804                 NaN  \n",
       "287721                 NaN  \n",
       "239156                 NaN  \n",
       "282401                 NaN  \n",
       "269793                 NaN  \n",
       "282416                 NaN  \n",
       "282417                 NaN  \n",
       "\n",
       "[290851 rows x 17 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df7.loc[df7['Month Closed'].isnull()])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [conda root]",
   "language": "python",
   "name": "conda-root-py"
  },
  "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}