sequencePatternData.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,
    "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>MEETING_TYPE</th>\n",
       "      <th>MEETING_DATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2013-10-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-10-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2013-10-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-10-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Hearing</td>\n",
       "      <td>2013-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Hearing</td>\n",
       "      <td>2013-11-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2013-11-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-11-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-11-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2013-11-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-11-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-11-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-11-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2013-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Hearing</td>\n",
       "      <td>2013-11-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2013-11-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-11-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2013-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2013-11-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Hearing</td>\n",
       "      <td>2013-12-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-12-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Council</td>\n",
       "      <td>2013-12-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Council</td>\n",
       "      <td>2014-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2014-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Council</td>\n",
       "      <td>2014-01-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2014-01-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2014-01-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2014-01-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>682</th>\n",
       "      <td>Council</td>\n",
       "      <td>2017-06-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>683</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-06-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>Hearing</td>\n",
       "      <td>2017-06-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-07-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-07-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-07-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>689</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-07-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td>Hearing</td>\n",
       "      <td>2017-07-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td>Council</td>\n",
       "      <td>2017-07-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-07-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-08-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-08-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>695</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-08-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>697</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-08-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-08-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-08-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-08-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>702</th>\n",
       "      <td>Hearing</td>\n",
       "      <td>2017-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>703</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-08-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>704</th>\n",
       "      <td>Council</td>\n",
       "      <td>2017-08-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705</th>\n",
       "      <td>Council</td>\n",
       "      <td>2017-09-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-09-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>708</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-09-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>709</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-09-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>711</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-09-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>712</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-09-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>713</th>\n",
       "      <td>Hearing</td>\n",
       "      <td>2017-09-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>714</th>\n",
       "      <td>Council</td>\n",
       "      <td>2017-09-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715</th>\n",
       "      <td>Committee</td>\n",
       "      <td>2017-10-02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>630 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    MEETING_TYPE MEETING_DATE\n",
       "0      Committee   2013-10-23\n",
       "1        Council   2013-10-29\n",
       "2      Committee   2013-10-30\n",
       "5        Council   2013-10-30\n",
       "6        Hearing   2013-10-31\n",
       "7        Hearing   2013-11-04\n",
       "8      Committee   2013-11-05\n",
       "9        Council   2013-11-06\n",
       "10       Council   2013-11-07\n",
       "11     Committee   2013-11-08\n",
       "13       Council   2013-11-12\n",
       "14       Council   2013-11-13\n",
       "15       Council   2013-11-14\n",
       "16     Committee   2013-11-15\n",
       "17       Hearing   2013-11-18\n",
       "18     Committee   2013-11-18\n",
       "19       Council   2013-11-19\n",
       "20     Committee   2013-11-25\n",
       "21       Council   2013-11-25\n",
       "22     Committee   2013-11-26\n",
       "24       Council   2013-12-02\n",
       "25       Hearing   2013-12-09\n",
       "26       Council   2013-12-11\n",
       "27       Council   2013-12-17\n",
       "28       Council   2014-01-20\n",
       "29     Committee   2014-01-20\n",
       "31       Council   2014-01-21\n",
       "32     Committee   2014-01-21\n",
       "33     Committee   2014-01-22\n",
       "34     Committee   2014-01-23\n",
       "..           ...          ...\n",
       "682      Council   2017-06-27\n",
       "683    Committee   2017-06-29\n",
       "684      Hearing   2017-06-28\n",
       "685    Committee   2017-07-04\n",
       "687    Committee   2017-07-06\n",
       "688    Committee   2017-07-05\n",
       "689    Committee   2017-07-07\n",
       "690      Hearing   2017-07-10\n",
       "691      Council   2017-07-11\n",
       "692    Committee   2017-07-13\n",
       "693    Committee   2017-08-10\n",
       "694    Committee   2017-08-15\n",
       "695    Committee   2017-08-22\n",
       "696    Committee   2017-08-28\n",
       "697    Committee   2017-08-24\n",
       "698    Committee   2017-08-21\n",
       "699    Committee   2017-08-23\n",
       "701    Committee   2017-08-29\n",
       "702      Hearing   2017-08-28\n",
       "703    Committee   2017-08-30\n",
       "704      Council   2017-08-29\n",
       "705      Council   2017-09-01\n",
       "706    Committee   2017-09-05\n",
       "708    Committee   2017-09-06\n",
       "709    Committee   2017-09-07\n",
       "711    Committee   2017-09-14\n",
       "712    Committee   2017-09-11\n",
       "713      Hearing   2017-09-11\n",
       "714      Council   2017-09-12\n",
       "715    Committee   2017-10-02\n",
       "\n",
       "[630 rows x 2 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3 = df3.drop_duplicates()\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>MEETING_DATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2013-10-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2013-10-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2013-10-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2013-10-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013-11-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2013-11-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2013-11-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2013-11-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2013-11-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2013-11-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2013-11-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2013-11-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2013-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2013-11-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2013-11-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2013-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2013-11-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2013-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2013-12-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2013-12-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2013-12-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2014-01-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2014-01-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2014-01-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2014-01-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2014-01-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2014-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2014-01-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2014-02-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501</th>\n",
       "      <td>2017-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502</th>\n",
       "      <td>2017-06-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503</th>\n",
       "      <td>2017-06-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>2017-06-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>2017-06-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>2017-06-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>2017-07-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>2017-07-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>2017-07-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>2017-07-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511</th>\n",
       "      <td>2017-07-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>512</th>\n",
       "      <td>2017-07-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>2017-07-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>2017-08-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>2017-08-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>2017-08-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>2017-08-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>2017-08-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>2017-08-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>2017-08-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>2017-08-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>2017-08-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523</th>\n",
       "      <td>2017-09-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>524</th>\n",
       "      <td>2017-09-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>2017-09-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>2017-09-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>2017-09-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>2017-09-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>2017-09-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>2017-10-02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>531 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    MEETING_DATE\n",
       "0     2013-10-23\n",
       "1     2013-10-29\n",
       "2     2013-10-30\n",
       "3     2013-10-31\n",
       "4     2013-11-04\n",
       "5     2013-11-05\n",
       "6     2013-11-06\n",
       "7     2013-11-07\n",
       "8     2013-11-08\n",
       "9     2013-11-12\n",
       "10    2013-11-13\n",
       "11    2013-11-14\n",
       "12    2013-11-15\n",
       "13    2013-11-18\n",
       "14    2013-11-19\n",
       "15    2013-11-25\n",
       "16    2013-11-26\n",
       "17    2013-12-02\n",
       "18    2013-12-09\n",
       "19    2013-12-11\n",
       "20    2013-12-17\n",
       "21    2014-01-20\n",
       "22    2014-01-21\n",
       "23    2014-01-22\n",
       "24    2014-01-23\n",
       "25    2014-01-27\n",
       "26    2014-01-28\n",
       "27    2014-01-29\n",
       "28    2014-01-30\n",
       "29    2014-02-03\n",
       "..           ...\n",
       "501   2017-06-15\n",
       "502   2017-06-19\n",
       "503   2017-06-23\n",
       "504   2017-06-27\n",
       "505   2017-06-29\n",
       "506   2017-06-28\n",
       "507   2017-07-04\n",
       "508   2017-07-06\n",
       "509   2017-07-05\n",
       "510   2017-07-07\n",
       "511   2017-07-10\n",
       "512   2017-07-11\n",
       "513   2017-07-13\n",
       "514   2017-08-10\n",
       "515   2017-08-15\n",
       "516   2017-08-22\n",
       "517   2017-08-28\n",
       "518   2017-08-24\n",
       "519   2017-08-21\n",
       "520   2017-08-23\n",
       "521   2017-08-29\n",
       "522   2017-08-30\n",
       "523   2017-09-01\n",
       "524   2017-09-05\n",
       "525   2017-09-06\n",
       "526   2017-09-07\n",
       "527   2017-09-14\n",
       "528   2017-09-11\n",
       "529   2017-09-12\n",
       "530   2017-10-02\n",
       "\n",
       "[531 rows x 1 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df8 = pd.DataFrame({'MEETING_DATE':df3['MEETING_DATE'].unique()})\n",
    "df8"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "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'        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Committee                    320\n",
       "Council                       96\n",
       "Hearing/Committee             54\n",
       "Council/Committee             39\n",
       "Hearing                       19\n",
       "Council/Hearing/Committee      3\n",
       "Name: MEETING_TYPE, dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df8['MEETING_TYPE'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True    4016\n",
       "Name: Holidays Created, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# add holidays to 311 data\n",
    "from datetime import date\n",
    "\n",
    "import holidays\n",
    "\n",
    "df['Holidays Created'] = np.nan\n",
    "\n",
    "for x in holidays.CA(prov='AB',years=[2013,2014,2015,2016,2017]):\n",
    "    df.loc[df['Date Created'] == x, 'Holidays Created'] = True\n",
    "    \n",
    "df['Holidays Created'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# merge weather and 311\n",
    "#df2 = df2.add_suffix(' Created')\n",
    "#df4 = pd.merge(df,df2,how='left',left_on='Date Created',right_on='date Created')\n",
    "#df5 = pd.merge(df4,df2,how='left',left_on='Date Closed',right_on='date',suffixes=('_created','_closed'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# merge with council data\n",
    "df3 = df8.add_suffix(' Created')\n",
    "df7 = pd.merge(df,df3,how='left',left_on='Date Created',right_on='MEETING_DATE Created')\n",
    "#df7 = pd.merge(df6,df3,how='left',left_on='Date Closed',right_on='MEETING_DATE',suffixes=('_created','_closed'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "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 Created',\n",
       "       'MEETING_DATE Created', 'MEETING_TYPE Created'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Roadway Operations                             156642\n",
       "Drainage Operations                             29281\n",
       "Traffic Engineering                             26969\n",
       "Forestry                                        23155\n",
       "Parks                                           20383\n",
       "Community Standards                             19207\n",
       "Animal Control                                  10492\n",
       "River Valley Operations                          2914\n",
       "Pest                                             1687\n",
       "Transit                                           494\n",
       "Waste                                             180\n",
       "Rangers/River Valley Trails                        99\n",
       "Capitial City Clean Up - Community Services        13\n",
       "Name: Business Unit, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7['Business Unit'].value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "729           Vandalism/Graffiti\n",
       "960           Vandalism/Graffiti\n",
       "1025      Traffic Lights & Signs\n",
       "1147          Vandalism/Graffiti\n",
       "1219          Vandalism/Graffiti\n",
       "1333      Traffic Lights & Signs\n",
       "3669      Traffic Lights & Signs\n",
       "4229          Vandalism/Graffiti\n",
       "4529          Vandalism/Graffiti\n",
       "4992      Traffic Lights & Signs\n",
       "5504          Vandalism/Graffiti\n",
       "5688          Vandalism/Graffiti\n",
       "7810      Traffic Lights & Signs\n",
       "8678          Vandalism/Graffiti\n",
       "8685          Vandalism/Graffiti\n",
       "10371         Vandalism/Graffiti\n",
       "13996         Vandalism/Graffiti\n",
       "14100     Traffic Lights & Signs\n",
       "15674     Traffic Lights & Signs\n",
       "20351         Vandalism/Graffiti\n",
       "20491         Vandalism/Graffiti\n",
       "20843     Traffic Lights & Signs\n",
       "21618     Traffic Lights & Signs\n",
       "22887         Vandalism/Graffiti\n",
       "22893         Vandalism/Graffiti\n",
       "24055     Traffic Lights & Signs\n",
       "24858         Vandalism/Graffiti\n",
       "25540         Vandalism/Graffiti\n",
       "25686         Vandalism/Graffiti\n",
       "25908         Vandalism/Graffiti\n",
       "                   ...          \n",
       "258702    Traffic Lights & Signs\n",
       "258937        Vandalism/Graffiti\n",
       "261890    Traffic Lights & Signs\n",
       "262010        Vandalism/Graffiti\n",
       "262243    Traffic Lights & Signs\n",
       "262695    Traffic Lights & Signs\n",
       "263711    Traffic Lights & Signs\n",
       "265189        Vandalism/Graffiti\n",
       "265664    Traffic Lights & Signs\n",
       "266072    Traffic Lights & Signs\n",
       "267691        Vandalism/Graffiti\n",
       "268245    Traffic Lights & Signs\n",
       "269180    Traffic Lights & Signs\n",
       "273341    Traffic Lights & Signs\n",
       "275058    Traffic Lights & Signs\n",
       "276992    Traffic Lights & Signs\n",
       "277048    Traffic Lights & Signs\n",
       "278467    Traffic Lights & Signs\n",
       "280974        Vandalism/Graffiti\n",
       "282437    Traffic Lights & Signs\n",
       "283653    Traffic Lights & Signs\n",
       "285158        Vandalism/Graffiti\n",
       "285235        Vandalism/Graffiti\n",
       "286150    Traffic Lights & Signs\n",
       "286288        Vandalism/Graffiti\n",
       "286787    Traffic Lights & Signs\n",
       "286845        Vandalism/Graffiti\n",
       "289482    Traffic Lights & Signs\n",
       "290681        Vandalism/Graffiti\n",
       "291325    Traffic Lights & Signs\n",
       "Name: Service Category, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7.loc[df7['Business Unit'] == \"Transit\", 'Service Category']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Pothole                            58577\n",
       "Snow & Ice Maintenance             48635\n",
       "Drainage Maintenance               32851\n",
       "Traffic Lights & Signs             27155\n",
       "Road/Sidewalk Maintenance          26018\n",
       "Litter & Waste                     23784\n",
       "Tree Maintenance                   23324\n",
       "Parking Enforcement                18309\n",
       "Parks & Sportsfield Maintenance    12854\n",
       "Dead Animal Removal                10492\n",
       "Vandalism/Graffiti                  6708\n",
       "Pest Management                     1687\n",
       "Structure Maintenance               1122\n",
       "Name: Service Category, dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7['Service Category'].value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "del df7['Date Closed']\n",
    "del df7['Request Status']\n",
    "del df7['Ward']\n",
    "del df7['Address']\n",
    "del df7['Lat']\n",
    "del df7['Long']\n",
    "del df7['Location']\n",
    "del df7['Calendar Year']\n",
    "del df7['Month Closed']\n",
    "del df7['Day of Week Request Closed']\n",
    "#del df7['date Created']\n",
    "del df7['MEETING_DATE Created']\n",
    "del df7['Days to Resolution']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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 Created</th>\n",
       "      <th>Status Detail</th>\n",
       "      <th>Service Category</th>\n",
       "      <th>Service Code</th>\n",
       "      <th>Business Unit</th>\n",
       "      <th>Neighbourhood</th>\n",
       "      <th>Community League</th>\n",
       "      <th>Ticket Source</th>\n",
       "      <th>Month Created</th>\n",
       "      <th>Day of Week Request Created</th>\n",
       "      <th>Holidays Created</th>\n",
       "      <th>MEETING_TYPE Created</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>133345190</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>ROPER INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>133350619</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>LARKSPUR</td>\n",
       "      <td>The Meadows Community League Association</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>133358214</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>GROVENOR</td>\n",
       "      <td>Grovenor Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>133362915</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>KENSINGTON</td>\n",
       "      <td>Kensington Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>133793810</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>RAMPART INDUSTRIAL</td>\n",
       "      <td>Cumberland/Oxford Community League (COCL)</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>133801539</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>BONNIE DOON</td>\n",
       "      <td>The Cloverdale Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8007107432</td>\n",
       "      <td>2013-02-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>PARSONS INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8007110682</td>\n",
       "      <td>2013-02-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>SOUTHEAST INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>162275947</td>\n",
       "      <td>2014-10-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>BELVEDERE</td>\n",
       "      <td>Belvedere Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>10</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>8007119869</td>\n",
       "      <td>2013-02-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>CORONET INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Monday</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>8007120136</td>\n",
       "      <td>2013-02-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Litter &amp; Waste</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>PYLYPOW INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Monday</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>134009024</td>\n",
       "      <td>2013-01-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>ANTHONY HENDAY ENERGY PARK</td>\n",
       "      <td>Lago Lindo Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>134291431</td>\n",
       "      <td>2013-01-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>DUNLUCE</td>\n",
       "      <td>Dunluce Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>134468293</td>\n",
       "      <td>2013-01-24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>RUTHERFORD</td>\n",
       "      <td>Heritage Point Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>135052771</td>\n",
       "      <td>2013-02-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>RITCHIE</td>\n",
       "      <td>Ritchie Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>135055479</td>\n",
       "      <td>2013-02-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>Oliver Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>135124187</td>\n",
       "      <td>2013-02-12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>NORTHMOUNT</td>\n",
       "      <td>Northmount Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>8007128303</td>\n",
       "      <td>2013-02-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>PLACE LARUE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>8007129609</td>\n",
       "      <td>2013-02-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>CORONET INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>8007133219</td>\n",
       "      <td>2013-02-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>ARMSTRONG INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>8007138194</td>\n",
       "      <td>2013-02-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>PARSONS INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>8007166448</td>\n",
       "      <td>2013-02-26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>SOUTHEAST INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>184808717</td>\n",
       "      <td>2015-12-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>Park Structure</td>\n",
       "      <td>Parks</td>\n",
       "      <td>LEE RIDGE</td>\n",
       "      <td>Leefield Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>12</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>8007167108</td>\n",
       "      <td>2013-02-26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>LAMBTON INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>2</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>8007192892</td>\n",
       "      <td>2013-03-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>LAMBTON INDUSTRIAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>3</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>8010104743</td>\n",
       "      <td>2014-07-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road/Sidewalk Maintenance</td>\n",
       "      <td>Road Dip</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>AMBLESIDE</td>\n",
       "      <td>Greater Windermere Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>7</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>8014004114</td>\n",
       "      <td>2016-05-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>EASTWOOD</td>\n",
       "      <td>Eastwood Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>5</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>8010332289</td>\n",
       "      <td>2014-08-06</td>\n",
       "      <td>Duplicate Request Exists</td>\n",
       "      <td>Road/Sidewalk Maintenance</td>\n",
       "      <td>Crack</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>FALCONER HEIGHTS</td>\n",
       "      <td>The Ridge Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>8</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>8011972372</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>ERMINESKIN</td>\n",
       "      <td>Ermineskin Community League</td>\n",
       "      <td>Web Form</td>\n",
       "      <td>5</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>8012041787</td>\n",
       "      <td>2015-05-26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>LEGER</td>\n",
       "      <td>Oak Hills Community League</td>\n",
       "      <td>Web Form</td>\n",
       "      <td>5</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291486</th>\n",
       "      <td>8013398735</td>\n",
       "      <td>2016-01-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Sign Request</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291487</th>\n",
       "      <td>8013499119</td>\n",
       "      <td>2016-02-10</td>\n",
       "      <td>Assessed-No Action Required</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Spruce Avenue Community League</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>2</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291488</th>\n",
       "      <td>8014001563</td>\n",
       "      <td>2016-05-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Signal Timing (Green Light)</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Spruce Avenue Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>5</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291489</th>\n",
       "      <td>8014051567</td>\n",
       "      <td>2016-05-26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road/Sidewalk Maintenance</td>\n",
       "      <td>Sidewalk Displacement</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>The Westwood Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>5</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291490</th>\n",
       "      <td>8014062985</td>\n",
       "      <td>2016-05-28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drainage Maintenance</td>\n",
       "      <td>Sinkhole</td>\n",
       "      <td>Drainage Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Rupert Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>5</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291491</th>\n",
       "      <td>8014063095</td>\n",
       "      <td>2016-05-28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Signal Timing (Green Light)</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Spruce Avenue Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>5</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291492</th>\n",
       "      <td>8014083087</td>\n",
       "      <td>2016-05-31</td>\n",
       "      <td>Deferred-Future Work Planned.</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Alley</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>PRINCE RUPERT</td>\n",
       "      <td>Prince Rupert Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>5</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Council/Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291493</th>\n",
       "      <td>8014096999</td>\n",
       "      <td>2016-06-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Signal Timing (Green Light)</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Spruce Avenue Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>6</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291494</th>\n",
       "      <td>8014155832</td>\n",
       "      <td>2016-06-13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>The Westwood Community League</td>\n",
       "      <td>Web Form</td>\n",
       "      <td>6</td>\n",
       "      <td>Monday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hearing/Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291495</th>\n",
       "      <td>8014160649</td>\n",
       "      <td>2016-06-14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>The Westwood Community League</td>\n",
       "      <td>Web Form</td>\n",
       "      <td>6</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291496</th>\n",
       "      <td>8014180955</td>\n",
       "      <td>2016-06-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>Park Structure</td>\n",
       "      <td>Parks</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Internet Mail</td>\n",
       "      <td>6</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291497</th>\n",
       "      <td>8014207359</td>\n",
       "      <td>2016-06-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Signal Timing (Green Light)</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Spruce Avenue Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>6</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291498</th>\n",
       "      <td>8014209692</td>\n",
       "      <td>2016-06-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>The Westwood Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>6</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291499</th>\n",
       "      <td>8014241665</td>\n",
       "      <td>2016-06-27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Signal Timing (Green Light)</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Spruce Avenue Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>6</td>\n",
       "      <td>Monday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hearing/Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291500</th>\n",
       "      <td>8014293462</td>\n",
       "      <td>2016-07-06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road/Sidewalk Maintenance</td>\n",
       "      <td>Road Dip</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Rupert Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>7</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291501</th>\n",
       "      <td>8014316395</td>\n",
       "      <td>2016-07-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Rupert Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>7</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291502</th>\n",
       "      <td>8014321984</td>\n",
       "      <td>2016-07-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road/Sidewalk Maintenance</td>\n",
       "      <td>Street Sweeping</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>The Westwood Community League</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>7</td>\n",
       "      <td>Monday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hearing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291503</th>\n",
       "      <td>8014345258</td>\n",
       "      <td>2016-07-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road/Sidewalk Maintenance</td>\n",
       "      <td>Road Dip</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Rupert Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>7</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291504</th>\n",
       "      <td>8014421130</td>\n",
       "      <td>2016-07-28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drainage Maintenance</td>\n",
       "      <td>Manhole Cover Concern</td>\n",
       "      <td>Drainage Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>The Westwood Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>7</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291505</th>\n",
       "      <td>8014451076</td>\n",
       "      <td>2016-08-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Sign Request</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>8</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291506</th>\n",
       "      <td>8015608801</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Vehicle Damaged Sign</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Rupert Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>3</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Council/Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291507</th>\n",
       "      <td>8015608789</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Litter &amp; Waste</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Rupert Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>3</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Council/Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291508</th>\n",
       "      <td>146266236</td>\n",
       "      <td>2013-11-18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Charles Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>11</td>\n",
       "      <td>Monday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hearing/Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291509</th>\n",
       "      <td>8014951718</td>\n",
       "      <td>2016-11-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drainage Maintenance</td>\n",
       "      <td>Manhole Cover Concern</td>\n",
       "      <td>Drainage Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Internet Mail</td>\n",
       "      <td>11</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291510</th>\n",
       "      <td>8014192127</td>\n",
       "      <td>2016-06-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Signal Timing (Green Light)</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Spruce Avenue Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>6</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291511</th>\n",
       "      <td>8015234357</td>\n",
       "      <td>2017-01-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drainage Maintenance</td>\n",
       "      <td>Broken Manhole Cover</td>\n",
       "      <td>Drainage Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Charles Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>1</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291512</th>\n",
       "      <td>8015524047</td>\n",
       "      <td>2017-03-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Damaged Non-Emergency Signs (i.e. Speed Limit)</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Rupert Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>3</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291513</th>\n",
       "      <td>8015626025</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drainage Maintenance</td>\n",
       "      <td>Manhole Cover Concern</td>\n",
       "      <td>Drainage Operations</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Charles Community League</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>3</td>\n",
       "      <td>Friday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291514</th>\n",
       "      <td>228414770</td>\n",
       "      <td>2016-08-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>Prince Rupert Community League</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>8</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Committee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291515</th>\n",
       "      <td>161212528</td>\n",
       "      <td>2014-09-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>BLATCHFORD AREA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>9</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>291516 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Reference Number Date Created                  Status Detail  \\\n",
       "0              133345190   2013-01-02                            NaN   \n",
       "1              133350619   2013-01-02                            NaN   \n",
       "2              133358214   2013-01-02                            NaN   \n",
       "3              133362915   2013-01-02                            NaN   \n",
       "4              133793810   2013-01-04                            NaN   \n",
       "5              133801539   2013-01-04                            NaN   \n",
       "6             8007107432   2013-02-15                            NaN   \n",
       "7             8007110682   2013-02-16                            NaN   \n",
       "8              162275947   2014-10-10                            NaN   \n",
       "9             8007119869   2013-02-18                            NaN   \n",
       "10            8007120136   2013-02-18                            NaN   \n",
       "11             134009024   2013-01-10                            NaN   \n",
       "12             134291431   2013-01-19                            NaN   \n",
       "13             134468293   2013-01-24                            NaN   \n",
       "14             135052771   2013-02-09                            NaN   \n",
       "15             135055479   2013-02-09                            NaN   \n",
       "16             135124187   2013-02-12                            NaN   \n",
       "17            8007128303   2013-02-19                            NaN   \n",
       "18            8007129609   2013-02-19                            NaN   \n",
       "19            8007133219   2013-02-20                            NaN   \n",
       "20            8007138194   2013-02-21                            NaN   \n",
       "21            8007166448   2013-02-26                            NaN   \n",
       "22             184808717   2015-12-18                            NaN   \n",
       "23            8007167108   2013-02-26                            NaN   \n",
       "24            8007192892   2013-03-02                            NaN   \n",
       "25            8010104743   2014-07-02                            NaN   \n",
       "26            8014004114   2016-05-18                            NaN   \n",
       "27            8010332289   2014-08-06       Duplicate Request Exists   \n",
       "28            8011972372   2015-05-15                            NaN   \n",
       "29            8012041787   2015-05-26                            NaN   \n",
       "...                  ...          ...                            ...   \n",
       "291486        8013398735   2016-01-21                            NaN   \n",
       "291487        8013499119   2016-02-10    Assessed-No Action Required   \n",
       "291488        8014001563   2016-05-17                            NaN   \n",
       "291489        8014051567   2016-05-26                            NaN   \n",
       "291490        8014062985   2016-05-28                            NaN   \n",
       "291491        8014063095   2016-05-28                            NaN   \n",
       "291492        8014083087   2016-05-31  Deferred-Future Work Planned.   \n",
       "291493        8014096999   2016-06-02                            NaN   \n",
       "291494        8014155832   2016-06-13                            NaN   \n",
       "291495        8014160649   2016-06-14                            NaN   \n",
       "291496        8014180955   2016-06-17                            NaN   \n",
       "291497        8014207359   2016-06-22                            NaN   \n",
       "291498        8014209692   2016-06-22                            NaN   \n",
       "291499        8014241665   2016-06-27                            NaN   \n",
       "291500        8014293462   2016-07-06                            NaN   \n",
       "291501        8014316395   2016-07-10                            NaN   \n",
       "291502        8014321984   2016-07-11                            NaN   \n",
       "291503        8014345258   2016-07-15                            NaN   \n",
       "291504        8014421130   2016-07-28                            NaN   \n",
       "291505        8014451076   2016-08-02                            NaN   \n",
       "291506        8015608801   2017-03-21                            NaN   \n",
       "291507        8015608789   2017-03-21                            NaN   \n",
       "291508         146266236   2013-11-18                            NaN   \n",
       "291509        8014951718   2016-11-02                            NaN   \n",
       "291510        8014192127   2016-06-19                            NaN   \n",
       "291511        8015234357   2017-01-03                            NaN   \n",
       "291512        8015524047   2017-03-03                            NaN   \n",
       "291513        8015626025   2017-03-24                            NaN   \n",
       "291514         228414770   2016-08-17                            NaN   \n",
       "291515         161212528   2014-09-23                            NaN   \n",
       "\n",
       "                 Service Category  \\\n",
       "0             Dead Animal Removal   \n",
       "1             Dead Animal Removal   \n",
       "2             Dead Animal Removal   \n",
       "3             Dead Animal Removal   \n",
       "4             Dead Animal Removal   \n",
       "5             Dead Animal Removal   \n",
       "6                         Pothole   \n",
       "7                         Pothole   \n",
       "8             Dead Animal Removal   \n",
       "9                         Pothole   \n",
       "10                 Litter & Waste   \n",
       "11            Dead Animal Removal   \n",
       "12            Dead Animal Removal   \n",
       "13            Dead Animal Removal   \n",
       "14            Dead Animal Removal   \n",
       "15            Dead Animal Removal   \n",
       "16            Dead Animal Removal   \n",
       "17                        Pothole   \n",
       "18                        Pothole   \n",
       "19                        Pothole   \n",
       "20                        Pothole   \n",
       "21                        Pothole   \n",
       "22             Vandalism/Graffiti   \n",
       "23                        Pothole   \n",
       "24                        Pothole   \n",
       "25      Road/Sidewalk Maintenance   \n",
       "26                        Pothole   \n",
       "27      Road/Sidewalk Maintenance   \n",
       "28                        Pothole   \n",
       "29                        Pothole   \n",
       "...                           ...   \n",
       "291486     Traffic Lights & Signs   \n",
       "291487                    Pothole   \n",
       "291488     Traffic Lights & Signs   \n",
       "291489  Road/Sidewalk Maintenance   \n",
       "291490       Drainage Maintenance   \n",
       "291491     Traffic Lights & Signs   \n",
       "291492                    Pothole   \n",
       "291493     Traffic Lights & Signs   \n",
       "291494                    Pothole   \n",
       "291495                    Pothole   \n",
       "291496         Vandalism/Graffiti   \n",
       "291497     Traffic Lights & Signs   \n",
       "291498                    Pothole   \n",
       "291499     Traffic Lights & Signs   \n",
       "291500  Road/Sidewalk Maintenance   \n",
       "291501                    Pothole   \n",
       "291502  Road/Sidewalk Maintenance   \n",
       "291503  Road/Sidewalk Maintenance   \n",
       "291504       Drainage Maintenance   \n",
       "291505     Traffic Lights & Signs   \n",
       "291506     Traffic Lights & Signs   \n",
       "291507             Litter & Waste   \n",
       "291508         Vandalism/Graffiti   \n",
       "291509       Drainage Maintenance   \n",
       "291510     Traffic Lights & Signs   \n",
       "291511       Drainage Maintenance   \n",
       "291512     Traffic Lights & Signs   \n",
       "291513       Drainage Maintenance   \n",
       "291514        Dead Animal Removal   \n",
       "291515        Dead Animal Removal   \n",
       "\n",
       "                                          Service Code        Business Unit  \\\n",
       "0                                          Dead Animal       Animal Control   \n",
       "1                                          Dead Animal       Animal Control   \n",
       "2                                          Dead Animal       Animal Control   \n",
       "3                                          Dead Animal       Animal Control   \n",
       "4                                          Dead Animal       Animal Control   \n",
       "5                                          Dead Animal       Animal Control   \n",
       "6                                                 Road   Roadway Operations   \n",
       "7                                                 Road   Roadway Operations   \n",
       "8                                          Dead Animal       Animal Control   \n",
       "9                                                 Road   Roadway Operations   \n",
       "10                                                Road   Roadway Operations   \n",
       "11                                         Dead Animal       Animal Control   \n",
       "12                                         Dead Animal       Animal Control   \n",
       "13                                         Dead Animal       Animal Control   \n",
       "14                                         Dead Animal       Animal Control   \n",
       "15                                         Dead Animal       Animal Control   \n",
       "16                                         Dead Animal       Animal Control   \n",
       "17                                                Road   Roadway Operations   \n",
       "18                                                Road   Roadway Operations   \n",
       "19                                                Road   Roadway Operations   \n",
       "20                                                Road   Roadway Operations   \n",
       "21                                                Road   Roadway Operations   \n",
       "22                                      Park Structure                Parks   \n",
       "23                                                Road   Roadway Operations   \n",
       "24                                                Road   Roadway Operations   \n",
       "25                                            Road Dip   Roadway Operations   \n",
       "26                                                Road   Roadway Operations   \n",
       "27                                               Crack   Roadway Operations   \n",
       "28                                             Pothole   Roadway Operations   \n",
       "29                                             Pothole   Roadway Operations   \n",
       "...                                                ...                  ...   \n",
       "291486                                    Sign Request  Traffic Engineering   \n",
       "291487                                         Pothole   Roadway Operations   \n",
       "291488                     Signal Timing (Green Light)  Traffic Engineering   \n",
       "291489                           Sidewalk Displacement   Roadway Operations   \n",
       "291490                                        Sinkhole  Drainage Operations   \n",
       "291491                     Signal Timing (Green Light)  Traffic Engineering   \n",
       "291492                                           Alley   Roadway Operations   \n",
       "291493                     Signal Timing (Green Light)  Traffic Engineering   \n",
       "291494                                         Pothole   Roadway Operations   \n",
       "291495                                         Pothole   Roadway Operations   \n",
       "291496                                  Park Structure                Parks   \n",
       "291497                     Signal Timing (Green Light)  Traffic Engineering   \n",
       "291498                                            Road   Roadway Operations   \n",
       "291499                     Signal Timing (Green Light)  Traffic Engineering   \n",
       "291500                                        Road Dip   Roadway Operations   \n",
       "291501                                            Road   Roadway Operations   \n",
       "291502                                 Street Sweeping   Roadway Operations   \n",
       "291503                                        Road Dip   Roadway Operations   \n",
       "291504                           Manhole Cover Concern  Drainage Operations   \n",
       "291505                                    Sign Request  Traffic Engineering   \n",
       "291506                            Vehicle Damaged Sign  Traffic Engineering   \n",
       "291507                                            Road   Roadway Operations   \n",
       "291508                    EPCOR Power Box/Street Light  Community Standards   \n",
       "291509                           Manhole Cover Concern  Drainage Operations   \n",
       "291510                     Signal Timing (Green Light)  Traffic Engineering   \n",
       "291511                            Broken Manhole Cover  Drainage Operations   \n",
       "291512  Damaged Non-Emergency Signs (i.e. Speed Limit)  Traffic Engineering   \n",
       "291513                           Manhole Cover Concern  Drainage Operations   \n",
       "291514                                     Dead Animal       Animal Control   \n",
       "291515                                     Dead Animal       Animal Control   \n",
       "\n",
       "                     Neighbourhood                           Community League  \\\n",
       "0                 ROPER INDUSTRIAL                                        NaN   \n",
       "1                         LARKSPUR   The Meadows Community League Association   \n",
       "2                         GROVENOR                  Grovenor Community League   \n",
       "3                       KENSINGTON                Kensington Community League   \n",
       "4               RAMPART INDUSTRIAL  Cumberland/Oxford Community League (COCL)   \n",
       "5                      BONNIE DOON            The Cloverdale Community League   \n",
       "6               PARSONS INDUSTRIAL                                        NaN   \n",
       "7             SOUTHEAST INDUSTRIAL                                        NaN   \n",
       "8                        BELVEDERE                 Belvedere Community League   \n",
       "9               CORONET INDUSTRIAL                                        NaN   \n",
       "10              PYLYPOW INDUSTRIAL                                        NaN   \n",
       "11      ANTHONY HENDAY ENERGY PARK                Lago Lindo Community League   \n",
       "12                         DUNLUCE                   Dunluce Community League   \n",
       "13                      RUTHERFORD            Heritage Point Community League   \n",
       "14                         RITCHIE                   Ritchie Community League   \n",
       "15                          OLIVER                    Oliver Community League   \n",
       "16                      NORTHMOUNT                Northmount Community League   \n",
       "17                     PLACE LARUE                                        NaN   \n",
       "18              CORONET INDUSTRIAL                                        NaN   \n",
       "19            ARMSTRONG INDUSTRIAL                                        NaN   \n",
       "20              PARSONS INDUSTRIAL                                        NaN   \n",
       "21            SOUTHEAST INDUSTRIAL                                        NaN   \n",
       "22                       LEE RIDGE                  Leefield Community League   \n",
       "23              LAMBTON INDUSTRIAL                                        NaN   \n",
       "24              LAMBTON INDUSTRIAL                                        NaN   \n",
       "25                       AMBLESIDE        Greater Windermere Community League   \n",
       "26                        EASTWOOD                  Eastwood Community League   \n",
       "27                FALCONER HEIGHTS                 The Ridge Community League   \n",
       "28                      ERMINESKIN                Ermineskin Community League   \n",
       "29                           LEGER                 Oak Hills Community League   \n",
       "...                            ...                                        ...   \n",
       "291486             BLATCHFORD AREA                                        NaN   \n",
       "291487             BLATCHFORD AREA             Spruce Avenue Community League   \n",
       "291488             BLATCHFORD AREA             Spruce Avenue Community League   \n",
       "291489             BLATCHFORD AREA              The Westwood Community League   \n",
       "291490             BLATCHFORD AREA             Prince Rupert Community League   \n",
       "291491             BLATCHFORD AREA             Spruce Avenue Community League   \n",
       "291492               PRINCE RUPERT             Prince Rupert Community League   \n",
       "291493             BLATCHFORD AREA             Spruce Avenue Community League   \n",
       "291494             BLATCHFORD AREA              The Westwood Community League   \n",
       "291495             BLATCHFORD AREA              The Westwood Community League   \n",
       "291496             BLATCHFORD AREA                                        NaN   \n",
       "291497             BLATCHFORD AREA             Spruce Avenue Community League   \n",
       "291498             BLATCHFORD AREA              The Westwood Community League   \n",
       "291499             BLATCHFORD AREA             Spruce Avenue Community League   \n",
       "291500             BLATCHFORD AREA             Prince Rupert Community League   \n",
       "291501             BLATCHFORD AREA             Prince Rupert Community League   \n",
       "291502             BLATCHFORD AREA              The Westwood Community League   \n",
       "291503             BLATCHFORD AREA             Prince Rupert Community League   \n",
       "291504             BLATCHFORD AREA              The Westwood Community League   \n",
       "291505             BLATCHFORD AREA                                        NaN   \n",
       "291506             BLATCHFORD AREA             Prince Rupert Community League   \n",
       "291507             BLATCHFORD AREA             Prince Rupert Community League   \n",
       "291508             BLATCHFORD AREA            Prince Charles Community League   \n",
       "291509             BLATCHFORD AREA                                        NaN   \n",
       "291510             BLATCHFORD AREA             Spruce Avenue Community League   \n",
       "291511             BLATCHFORD AREA            Prince Charles Community League   \n",
       "291512             BLATCHFORD AREA             Prince Rupert Community League   \n",
       "291513             BLATCHFORD AREA            Prince Charles Community League   \n",
       "291514             BLATCHFORD AREA             Prince Rupert Community League   \n",
       "291515             BLATCHFORD AREA                                        NaN   \n",
       "\n",
       "         Ticket Source  Month Created Day of Week Request Created  \\\n",
       "0       Telephone call              1                   Wednesday   \n",
       "1       Telephone call              1                   Wednesday   \n",
       "2       Telephone call              1                   Wednesday   \n",
       "3       Telephone call              1                   Wednesday   \n",
       "4       Telephone call              1                      Friday   \n",
       "5       Telephone call              1                      Friday   \n",
       "6       Telephone call              2                      Friday   \n",
       "7       Telephone call              2                    Saturday   \n",
       "8       Telephone call             10                      Friday   \n",
       "9       Telephone call              2                      Monday   \n",
       "10      Telephone call              2                      Monday   \n",
       "11      Telephone call              1                    Thursday   \n",
       "12      Telephone call              1                    Saturday   \n",
       "13      Telephone call              1                    Thursday   \n",
       "14      Telephone call              2                    Saturday   \n",
       "15      Telephone call              2                    Saturday   \n",
       "16      Telephone call              2                     Tuesday   \n",
       "17      Telephone call              2                     Tuesday   \n",
       "18      Telephone call              2                     Tuesday   \n",
       "19      Telephone call              2                   Wednesday   \n",
       "20      Telephone call              2                    Thursday   \n",
       "21      Telephone call              2                     Tuesday   \n",
       "22      Telephone call             12                      Friday   \n",
       "23      Telephone call              2                     Tuesday   \n",
       "24      Telephone call              3                    Saturday   \n",
       "25      Telephone call              7                   Wednesday   \n",
       "26      Telephone call              5                   Wednesday   \n",
       "27      Telephone call              8                   Wednesday   \n",
       "28            Web Form              5                      Friday   \n",
       "29            Web Form              5                     Tuesday   \n",
       "...                ...            ...                         ...   \n",
       "291486  Telephone call              1                    Thursday   \n",
       "291487       MobileApp              2                   Wednesday   \n",
       "291488  Telephone call              5                     Tuesday   \n",
       "291489  Telephone call              5                    Thursday   \n",
       "291490  Telephone call              5                    Saturday   \n",
       "291491  Telephone call              5                    Saturday   \n",
       "291492  Telephone call              5                     Tuesday   \n",
       "291493  Telephone call              6                    Thursday   \n",
       "291494        Web Form              6                      Monday   \n",
       "291495        Web Form              6                     Tuesday   \n",
       "291496   Internet Mail              6                      Friday   \n",
       "291497  Telephone call              6                   Wednesday   \n",
       "291498  Telephone call              6                   Wednesday   \n",
       "291499  Telephone call              6                      Monday   \n",
       "291500  Telephone call              7                   Wednesday   \n",
       "291501  Telephone call              7                      Sunday   \n",
       "291502       MobileApp              7                      Monday   \n",
       "291503  Telephone call              7                      Friday   \n",
       "291504  Telephone call              7                    Thursday   \n",
       "291505  Telephone call              8                     Tuesday   \n",
       "291506  Telephone call              3                     Tuesday   \n",
       "291507  Telephone call              3                     Tuesday   \n",
       "291508  Telephone call             11                      Monday   \n",
       "291509   Internet Mail             11                   Wednesday   \n",
       "291510  Telephone call              6                      Sunday   \n",
       "291511  Telephone call              1                     Tuesday   \n",
       "291512  Telephone call              3                      Friday   \n",
       "291513       MobileApp              3                      Friday   \n",
       "291514  Telephone call              8                   Wednesday   \n",
       "291515  Telephone call              9                     Tuesday   \n",
       "\n",
       "       Holidays Created MEETING_TYPE Created  \n",
       "0                   NaN                  NaN  \n",
       "1                   NaN                  NaN  \n",
       "2                   NaN                  NaN  \n",
       "3                   NaN                  NaN  \n",
       "4                   NaN                  NaN  \n",
       "5                   NaN                  NaN  \n",
       "6                   NaN                  NaN  \n",
       "7                   NaN                  NaN  \n",
       "8                   NaN                  NaN  \n",
       "9                  True                  NaN  \n",
       "10                 True                  NaN  \n",
       "11                  NaN                  NaN  \n",
       "12                  NaN                  NaN  \n",
       "13                  NaN                  NaN  \n",
       "14                  NaN                  NaN  \n",
       "15                  NaN                  NaN  \n",
       "16                  NaN                  NaN  \n",
       "17                  NaN                  NaN  \n",
       "18                  NaN                  NaN  \n",
       "19                  NaN                  NaN  \n",
       "20                  NaN                  NaN  \n",
       "21                  NaN                  NaN  \n",
       "22                  NaN                  NaN  \n",
       "23                  NaN                  NaN  \n",
       "24                  NaN                  NaN  \n",
       "25                  NaN            Committee  \n",
       "26                  NaN                  NaN  \n",
       "27                  NaN            Committee  \n",
       "28                  NaN                  NaN  \n",
       "29                  NaN            Committee  \n",
       "...                 ...                  ...  \n",
       "291486              NaN                  NaN  \n",
       "291487              NaN                  NaN  \n",
       "291488              NaN                  NaN  \n",
       "291489              NaN              Council  \n",
       "291490              NaN                  NaN  \n",
       "291491              NaN                  NaN  \n",
       "291492              NaN    Council/Committee  \n",
       "291493              NaN            Committee  \n",
       "291494              NaN    Hearing/Committee  \n",
       "291495              NaN              Council  \n",
       "291496              NaN                  NaN  \n",
       "291497              NaN            Committee  \n",
       "291498              NaN            Committee  \n",
       "291499              NaN    Hearing/Committee  \n",
       "291500              NaN            Committee  \n",
       "291501              NaN                  NaN  \n",
       "291502              NaN              Hearing  \n",
       "291503              NaN                  NaN  \n",
       "291504              NaN                  NaN  \n",
       "291505              NaN                  NaN  \n",
       "291506              NaN    Council/Committee  \n",
       "291507              NaN    Council/Committee  \n",
       "291508              NaN    Hearing/Committee  \n",
       "291509              NaN            Committee  \n",
       "291510              NaN                  NaN  \n",
       "291511              NaN                  NaN  \n",
       "291512              NaN            Committee  \n",
       "291513              NaN                  NaN  \n",
       "291514              NaN            Committee  \n",
       "291515              NaN              Council  \n",
       "\n",
       "[291516 rows x 13 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df7 = df7.sort_values('Reference Number')\n",
    "df7 = df7.replace('no', np.NaN)\n",
    "df7 = df7.replace('below_freezing', np.NaN)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Reference Number', 'Date Created', 'Status Detail', 'Service Category',\n",
       "       'Service Code', 'Business Unit', 'Neighbourhood', 'Community League',\n",
       "       'Ticket Source', 'Month Created', 'Day of Week Request Created',\n",
       "       'Holidays Created', 'MEETING_TYPE Created'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "del df7['Month Created']\n",
    "del df7['Day of Week Request Created']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df7.to_csv('data/sequence_merged_created_no_weather.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "del df7['Community League']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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 Created</th>\n",
       "      <th>Status Detail</th>\n",
       "      <th>Service Category</th>\n",
       "      <th>Service Code</th>\n",
       "      <th>Business Unit</th>\n",
       "      <th>Neighbourhood</th>\n",
       "      <th>Ticket Source</th>\n",
       "      <th>Holidays Created</th>\n",
       "      <th>MEETING_TYPE Created</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>284799</th>\n",
       "      <td>133341338</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>Shaw/Telus Box</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>WESTMOUNT</td>\n",
       "      <td>Internet Mail</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>133345190</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>ROPER INDUSTRIAL</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>133350619</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>LARKSPUR</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>133358214</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>GROVENOR</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>133362915</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>KENSINGTON</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274894</th>\n",
       "      <td>133365471</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>HOLYROOD</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284800</th>\n",
       "      <td>133562918</td>\n",
       "      <td>2013-01-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>HIGHLANDS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284801</th>\n",
       "      <td>133720292</td>\n",
       "      <td>2013-01-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>MCCAULEY</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284802</th>\n",
       "      <td>133780574</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>Newspaper Box/Sign</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276418</th>\n",
       "      <td>133783648</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>DAVIES INDUSTRIAL EAST</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>133793810</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>RAMPART INDUSTRIAL</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</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>Vandalism/Graffiti</td>\n",
       "      <td>Shaw/Telus Box</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>133801539</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>BONNIE DOON</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</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 Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>FOREST HEIGHTS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284804</th>\n",
       "      <td>133810779</td>\n",
       "      <td>2013-01-06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>CAPILANO</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276421</th>\n",
       "      <td>133813341</td>\n",
       "      <td>2013-01-06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>CRAWFORD PLAINS</td>\n",
       "      <td>Internet Mail</td>\n",
       "      <td>NaN</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 Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>SPRUCE AVENUE</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289926</th>\n",
       "      <td>133867955</td>\n",
       "      <td>2013-01-08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>SPRUCE AVENUE</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</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 Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>RAMPART INDUSTRIAL</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274028</th>\n",
       "      <td>133936021</td>\n",
       "      <td>2013-01-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>Canada Post Mail box</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>GREENVIEW</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255442</th>\n",
       "      <td>133951927</td>\n",
       "      <td>2013-01-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>INGLEWOOD</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274029</th>\n",
       "      <td>133991035</td>\n",
       "      <td>2013-01-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>BELLEVUE</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272239</th>\n",
       "      <td>133991130</td>\n",
       "      <td>2013-01-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>EPCOR Power Box/Street Light</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>VIRGINIA PARK</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284806</th>\n",
       "      <td>133993315</td>\n",
       "      <td>2013-01-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vandalism/Graffiti</td>\n",
       "      <td>Canada Post Mail box</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>BULYEA HEIGHTS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>134009024</td>\n",
       "      <td>2013-01-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>ANTHONY HENDAY ENERGY PARK</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</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 Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>ANTHONY HENDAY ENERGY PARK</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284808</th>\n",
       "      <td>134016156</td>\n",
       "      <td>2013-01-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>HAWIN PARK ESTATE INDUSTRIAL</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</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 Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>CHAMBERY</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284809</th>\n",
       "      <td>134025493</td>\n",
       "      <td>2013-01-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>MEYOKUMIN</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262102</th>\n",
       "      <td>134120282</td>\n",
       "      <td>2013-01-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dead Animal Removal</td>\n",
       "      <td>Dead Animal</td>\n",
       "      <td>Animal Control</td>\n",
       "      <td>GLENORA</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282365</th>\n",
       "      <td>8016889146</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Parking Enforcement</td>\n",
       "      <td>Restricted Residential</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>SOUTH TERWILLEGAR</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282367</th>\n",
       "      <td>8016889171</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Sign Request</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>WEBBER GREENS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282808</th>\n",
       "      <td>8016889179</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Signal Timing (Left Turn Arrow)</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>WEBBER GREENS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282376</th>\n",
       "      <td>8016889189</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Redirected to Other Government Agency</td>\n",
       "      <td>Road/Sidewalk Maintenance</td>\n",
       "      <td>Road Dip</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>ALLENDALE</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282383</th>\n",
       "      <td>8016889229</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Parking Enforcement</td>\n",
       "      <td>Restricted Residential</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</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>Parking Enforcement</td>\n",
       "      <td>Tow Away Zone</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>THE HAMPTONS</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</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>Parking Enforcement</td>\n",
       "      <td>Disable Stall</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>STRATHCONA</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>NaN</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>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>EASTWOOD</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>NaN</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>Parking Enforcement</td>\n",
       "      <td>Disable Stall</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>HADDOW</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287718</th>\n",
       "      <td>8016889552</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Deferred-Future Work Planned.</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>OLIVER</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287719</th>\n",
       "      <td>8016889563</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Sign Request</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>THE HAMPTONS</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281384</th>\n",
       "      <td>8016889571</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road/Sidewalk Maintenance</td>\n",
       "      <td>Road Dip</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>ORMSBY PLACE</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282391</th>\n",
       "      <td>8016889587</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Litter &amp; Waste</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>JACKSON HEIGHTS</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</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>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>NORTHMOUNT</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287720</th>\n",
       "      <td>8016889595</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Citizen Complied</td>\n",
       "      <td>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>TERWILLEGAR TOWNE</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273937</th>\n",
       "      <td>8016889600</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Traffic Lights &amp; Signs</td>\n",
       "      <td>Signal Timing (Green Light)</td>\n",
       "      <td>Traffic Engineering</td>\n",
       "      <td>POLLARD MEADOWS</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</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>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>HIGHLANDS</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282392</th>\n",
       "      <td>8016889728</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>HILLVIEW</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282393</th>\n",
       "      <td>8016889755</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Citizen Complied</td>\n",
       "      <td>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>IDYLWYLDE</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>NaN</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>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>BRINTNELL</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</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>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>RUTHERFORD</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282411</th>\n",
       "      <td>8016889814</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Road/Sidewalk Maintenance</td>\n",
       "      <td>Paving</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>CAPILANO</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282415</th>\n",
       "      <td>8016889823</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Deferred-Future Work Planned.</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>ROYAL GARDENS</td>\n",
       "      <td>Web Form</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282804</th>\n",
       "      <td>8016889844</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Assessed-No Action Required</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Pothole</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>CALLAGHAN</td>\n",
       "      <td>Web Form</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287721</th>\n",
       "      <td>8016889895</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Vehicle Gone Upon Arrival</td>\n",
       "      <td>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>QUEEN ALEXANDRA</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239156</th>\n",
       "      <td>8016889901</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drainage Maintenance</td>\n",
       "      <td>Broken Manhole Cover</td>\n",
       "      <td>Drainage Operations</td>\n",
       "      <td>BLACKMUD CREEK</td>\n",
       "      <td>Telephone call</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282401</th>\n",
       "      <td>8016889974</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Citizen Complied</td>\n",
       "      <td>Parking Enforcement</td>\n",
       "      <td>Abandoned Vehicle</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>CHAPPELLE AREA</td>\n",
       "      <td>Posse Auto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269793</th>\n",
       "      <td>8016890048</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Litter &amp; Waste</td>\n",
       "      <td>Road</td>\n",
       "      <td>Roadway Operations</td>\n",
       "      <td>LYNNWOOD</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282416</th>\n",
       "      <td>8016890086</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Enforcement Action Taken</td>\n",
       "      <td>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>DOWNTOWN</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282417</th>\n",
       "      <td>8016890096</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>Does Not Meet Bylaw Offence Standards</td>\n",
       "      <td>Parking Enforcement</td>\n",
       "      <td>Safety &amp; Other</td>\n",
       "      <td>Community Standards</td>\n",
       "      <td>DOWNTOWN</td>\n",
       "      <td>MobileApp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>291516 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Reference Number Date Created  \\\n",
       "284799         133341338   2013-01-02   \n",
       "0              133345190   2013-01-02   \n",
       "1              133350619   2013-01-02   \n",
       "2              133358214   2013-01-02   \n",
       "3              133362915   2013-01-02   \n",
       "274894         133365471   2013-01-02   \n",
       "284800         133562918   2013-01-03   \n",
       "284801         133720292   2013-01-03   \n",
       "284802         133780574   2013-01-04   \n",
       "276418         133783648   2013-01-04   \n",
       "4              133793810   2013-01-04   \n",
       "251            133800575   2013-01-04   \n",
       "5              133801539   2013-01-04   \n",
       "284803         133810231   2013-01-06   \n",
       "284804         133810779   2013-01-06   \n",
       "276421         133813341   2013-01-06   \n",
       "270907         133867738   2013-01-08   \n",
       "289926         133867955   2013-01-08   \n",
       "284805         133918986   2013-01-09   \n",
       "274028         133936021   2013-01-09   \n",
       "255442         133951927   2013-01-09   \n",
       "274029         133991035   2013-01-10   \n",
       "272239         133991130   2013-01-10   \n",
       "284806         133993315   2013-01-10   \n",
       "11             134009024   2013-01-10   \n",
       "284807         134010455   2013-01-10   \n",
       "284808         134016156   2013-01-10   \n",
       "270201         134022420   2013-01-11   \n",
       "284809         134025493   2013-01-11   \n",
       "262102         134120282   2013-01-15   \n",
       "...                  ...          ...   \n",
       "282365        8016889146   2017-10-31   \n",
       "282367        8016889171   2017-10-31   \n",
       "282808        8016889179   2017-10-31   \n",
       "282376        8016889189   2017-10-31   \n",
       "282383        8016889229   2017-10-31   \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-10-31   \n",
       "287719        8016889563   2017-10-31   \n",
       "281384        8016889571   2017-10-31   \n",
       "282391        8016889587   2017-10-31   \n",
       "238996        8016889589   2017-10-31   \n",
       "287720        8016889595   2017-10-31   \n",
       "273937        8016889600   2017-10-31   \n",
       "239053        8016889719   2017-10-31   \n",
       "282392        8016889728   2017-10-31   \n",
       "282393        8016889755   2017-10-31   \n",
       "239088        8016889763   2017-10-31   \n",
       "239095        8016889804   2017-10-31   \n",
       "282411        8016889814   2017-10-31   \n",
       "282415        8016889823   2017-10-31   \n",
       "282804        8016889844   2017-10-31   \n",
       "287721        8016889895   2017-10-31   \n",
       "239156        8016889901   2017-10-31   \n",
       "282401        8016889974   2017-10-31   \n",
       "269793        8016890048   2017-10-31   \n",
       "282416        8016890086   2017-10-31   \n",
       "282417        8016890096   2017-10-31   \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 Category                     Service Code  \\\n",
       "284799         Vandalism/Graffiti                   Shaw/Telus Box   \n",
       "0             Dead Animal Removal                      Dead Animal   \n",
       "1             Dead Animal Removal                      Dead Animal   \n",
       "2             Dead Animal Removal                      Dead Animal   \n",
       "3             Dead Animal Removal                      Dead Animal   \n",
       "274894        Dead Animal Removal                      Dead Animal   \n",
       "284800        Dead Animal Removal                      Dead Animal   \n",
       "284801        Dead Animal Removal                      Dead Animal   \n",
       "284802         Vandalism/Graffiti               Newspaper Box/Sign   \n",
       "276418        Dead Animal Removal                      Dead Animal   \n",
       "4             Dead Animal Removal                      Dead Animal   \n",
       "251            Vandalism/Graffiti                   Shaw/Telus Box   \n",
       "5             Dead Animal Removal                      Dead Animal   \n",
       "284803        Dead Animal Removal                      Dead Animal   \n",
       "284804        Dead Animal Removal                      Dead Animal   \n",
       "276421        Dead Animal Removal                      Dead Animal   \n",
       "270907        Dead Animal Removal                      Dead Animal   \n",
       "289926        Dead Animal Removal                      Dead Animal   \n",
       "284805        Dead Animal Removal                      Dead Animal   \n",
       "274028         Vandalism/Graffiti             Canada Post Mail box   \n",
       "255442         Vandalism/Graffiti     EPCOR Power Box/Street Light   \n",
       "274029         Vandalism/Graffiti     EPCOR Power Box/Street Light   \n",
       "272239         Vandalism/Graffiti     EPCOR Power Box/Street Light   \n",
       "284806         Vandalism/Graffiti             Canada Post Mail box   \n",
       "11            Dead Animal Removal                      Dead Animal   \n",
       "284807        Dead Animal Removal                      Dead Animal   \n",
       "284808        Dead Animal Removal                      Dead Animal   \n",
       "270201        Dead Animal Removal                      Dead Animal   \n",
       "284809        Dead Animal Removal                      Dead Animal   \n",
       "262102        Dead Animal Removal                      Dead Animal   \n",
       "...                           ...                              ...   \n",
       "282365        Parking Enforcement           Restricted Residential   \n",
       "282367     Traffic Lights & Signs                     Sign Request   \n",
       "282808     Traffic Lights & Signs  Signal Timing (Left Turn Arrow)   \n",
       "282376  Road/Sidewalk Maintenance                         Road Dip   \n",
       "282383        Parking Enforcement           Restricted Residential   \n",
       "238865        Parking Enforcement                    Tow Away Zone   \n",
       "238888        Parking Enforcement                    Disable Stall   \n",
       "238906        Parking Enforcement                   Safety & Other   \n",
       "238907        Parking Enforcement                    Disable Stall   \n",
       "287718                    Pothole                             Road   \n",
       "287719     Traffic Lights & Signs                     Sign Request   \n",
       "281384  Road/Sidewalk Maintenance                         Road Dip   \n",
       "282391             Litter & Waste                             Road   \n",
       "238996        Parking Enforcement                   Safety & Other   \n",
       "287720        Parking Enforcement                   Safety & Other   \n",
       "273937     Traffic Lights & Signs      Signal Timing (Green Light)   \n",
       "239053        Parking Enforcement                   Safety & Other   \n",
       "282392        Parking Enforcement                   Safety & Other   \n",
       "282393        Parking Enforcement                   Safety & Other   \n",
       "239088        Parking Enforcement                   Safety & Other   \n",
       "239095        Parking Enforcement                   Safety & Other   \n",
       "282411  Road/Sidewalk Maintenance                           Paving   \n",
       "282415                    Pothole                          Pothole   \n",
       "282804                    Pothole                          Pothole   \n",
       "287721        Parking Enforcement                   Safety & Other   \n",
       "239156       Drainage Maintenance             Broken Manhole Cover   \n",
       "282401        Parking Enforcement                Abandoned Vehicle   \n",
       "269793             Litter & Waste                             Road   \n",
       "282416        Parking Enforcement                   Safety & Other   \n",
       "282417        Parking Enforcement                   Safety & Other   \n",
       "\n",
       "              Business Unit                 Neighbourhood   Ticket Source  \\\n",
       "284799  Community Standards                     WESTMOUNT   Internet Mail   \n",
       "0            Animal Control              ROPER INDUSTRIAL  Telephone call   \n",
       "1            Animal Control                      LARKSPUR  Telephone call   \n",
       "2            Animal Control                      GROVENOR  Telephone call   \n",
       "3            Animal Control                    KENSINGTON  Telephone call   \n",
       "274894       Animal Control                      HOLYROOD  Telephone call   \n",
       "284800       Animal Control                     HIGHLANDS  Telephone call   \n",
       "284801       Animal Control                      MCCAULEY  Telephone call   \n",
       "284802  Community Standards                        OLIVER  Telephone call   \n",
       "276418       Animal Control        DAVIES INDUSTRIAL EAST  Telephone call   \n",
       "4            Animal Control            RAMPART INDUSTRIAL  Telephone call   \n",
       "251     Community Standards                        OLIVER  Telephone call   \n",
       "5            Animal Control                   BONNIE DOON  Telephone call   \n",
       "284803       Animal Control                FOREST HEIGHTS  Telephone call   \n",
       "284804       Animal Control                      CAPILANO  Telephone call   \n",
       "276421       Animal Control               CRAWFORD PLAINS   Internet Mail   \n",
       "270907       Animal Control                 SPRUCE AVENUE  Telephone call   \n",
       "289926       Animal Control                 SPRUCE AVENUE  Telephone call   \n",
       "284805       Animal Control            RAMPART INDUSTRIAL  Telephone call   \n",
       "274028  Community Standards                     GREENVIEW  Telephone call   \n",
       "255442  Community Standards                     INGLEWOOD  Telephone call   \n",
       "274029  Community Standards                      BELLEVUE  Telephone call   \n",
       "272239  Community Standards                 VIRGINIA PARK  Telephone call   \n",
       "284806  Community Standards                BULYEA HEIGHTS  Telephone call   \n",
       "11           Animal Control    ANTHONY HENDAY ENERGY PARK  Telephone call   \n",
       "284807       Animal Control    ANTHONY HENDAY ENERGY PARK  Telephone call   \n",
       "284808       Animal Control  HAWIN PARK ESTATE INDUSTRIAL  Telephone call   \n",
       "270201       Animal Control                      CHAMBERY  Telephone call   \n",
       "284809       Animal Control                     MEYOKUMIN  Telephone call   \n",
       "262102       Animal Control                       GLENORA  Telephone call   \n",
       "...                     ...                           ...             ...   \n",
       "282365  Community Standards             SOUTH TERWILLEGAR       MobileApp   \n",
       "282367  Traffic Engineering                 WEBBER GREENS  Telephone call   \n",
       "282808  Traffic Engineering                 WEBBER GREENS  Telephone call   \n",
       "282376   Roadway Operations                     ALLENDALE  Telephone call   \n",
       "282383  Community Standards                        OLIVER       MobileApp   \n",
       "238865  Community Standards                  THE HAMPTONS       MobileApp   \n",
       "238888  Community Standards                    STRATHCONA      Posse Auto   \n",
       "238906  Community Standards                      EASTWOOD      Posse Auto   \n",
       "238907  Community Standards                        HADDOW       MobileApp   \n",
       "287718   Roadway Operations                        OLIVER  Telephone call   \n",
       "287719  Traffic Engineering                  THE HAMPTONS       MobileApp   \n",
       "281384   Roadway Operations                  ORMSBY PLACE       MobileApp   \n",
       "282391   Roadway Operations               JACKSON HEIGHTS  Telephone call   \n",
       "238996  Community Standards                    NORTHMOUNT      Posse Auto   \n",
       "287720  Community Standards             TERWILLEGAR TOWNE       MobileApp   \n",
       "273937  Traffic Engineering               POLLARD MEADOWS       MobileApp   \n",
       "239053  Community Standards                     HIGHLANDS      Posse Auto   \n",
       "282392  Community Standards                      HILLVIEW       MobileApp   \n",
       "282393  Community Standards                     IDYLWYLDE      Posse Auto   \n",
       "239088  Community Standards                     BRINTNELL       MobileApp   \n",
       "239095  Community Standards                    RUTHERFORD       MobileApp   \n",
       "282411   Roadway Operations                      CAPILANO  Telephone call   \n",
       "282415   Roadway Operations                 ROYAL GARDENS        Web Form   \n",
       "282804   Roadway Operations                     CALLAGHAN        Web Form   \n",
       "287721  Community Standards               QUEEN ALEXANDRA       MobileApp   \n",
       "239156  Drainage Operations                BLACKMUD CREEK  Telephone call   \n",
       "282401  Community Standards                CHAPPELLE AREA      Posse Auto   \n",
       "269793   Roadway Operations                      LYNNWOOD       MobileApp   \n",
       "282416  Community Standards                      DOWNTOWN       MobileApp   \n",
       "282417  Community Standards                      DOWNTOWN       MobileApp   \n",
       "\n",
       "       Holidays Created MEETING_TYPE Created  \n",
       "284799              NaN                  NaN  \n",
       "0                   NaN                  NaN  \n",
       "1                   NaN                  NaN  \n",
       "2                   NaN                  NaN  \n",
       "3                   NaN                  NaN  \n",
       "274894              NaN                  NaN  \n",
       "284800              NaN                  NaN  \n",
       "284801              NaN                  NaN  \n",
       "284802              NaN                  NaN  \n",
       "276418              NaN                  NaN  \n",
       "4                   NaN                  NaN  \n",
       "251                 NaN                  NaN  \n",
       "5                   NaN                  NaN  \n",
       "284803              NaN                  NaN  \n",
       "284804              NaN                  NaN  \n",
       "276421              NaN                  NaN  \n",
       "270907              NaN                  NaN  \n",
       "289926              NaN                  NaN  \n",
       "284805              NaN                  NaN  \n",
       "274028              NaN                  NaN  \n",
       "255442              NaN                  NaN  \n",
       "274029              NaN                  NaN  \n",
       "272239              NaN                  NaN  \n",
       "284806              NaN                  NaN  \n",
       "11                  NaN                  NaN  \n",
       "284807              NaN                  NaN  \n",
       "284808              NaN                  NaN  \n",
       "270201              NaN                  NaN  \n",
       "284809              NaN                  NaN  \n",
       "262102              NaN                  NaN  \n",
       "...                 ...                  ...  \n",
       "282365              NaN                  NaN  \n",
       "282367              NaN                  NaN  \n",
       "282808              NaN                  NaN  \n",
       "282376              NaN                  NaN  \n",
       "282383              NaN                  NaN  \n",
       "238865              NaN                  NaN  \n",
       "238888              NaN                  NaN  \n",
       "238906              NaN                  NaN  \n",
       "238907              NaN                  NaN  \n",
       "287718              NaN                  NaN  \n",
       "287719              NaN                  NaN  \n",
       "281384              NaN                  NaN  \n",
       "282391              NaN                  NaN  \n",
       "238996              NaN                  NaN  \n",
       "287720              NaN                  NaN  \n",
       "273937              NaN                  NaN  \n",
       "239053              NaN                  NaN  \n",
       "282392              NaN                  NaN  \n",
       "282393              NaN                  NaN  \n",
       "239088              NaN                  NaN  \n",
       "239095              NaN                  NaN  \n",
       "282411              NaN                  NaN  \n",
       "282415              NaN                  NaN  \n",
       "282804              NaN                  NaN  \n",
       "287721              NaN                  NaN  \n",
       "239156              NaN                  NaN  \n",
       "282401              NaN                  NaN  \n",
       "269793              NaN                  NaN  \n",
       "282416              NaN                  NaN  \n",
       "282417              NaN                  NaN  \n",
       "\n",
       "[291516 rows x 10 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df7.to_csv('data/sequence_merged_created_min.csv', index=False)"
   ]
  },
  {
   "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
}