toronto-parking-ticket-data-2012-weekdays.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:b81d551f6fc983fba194fb50b817038ec38c1ea0fa560d95354cfd8842366406"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd\n",
      "import datetime as dt\n",
      "\n",
      "df = pd.read_csv('Parking_Tags_Data_2012.csv')\n",
      "df"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>tag_number_masked</th>\n",
        "      <th>date_of_infraction</th>\n",
        "      <th>infraction_code</th>\n",
        "      <th>infraction_description</th>\n",
        "      <th>set_fine_amount</th>\n",
        "      <th>time_of_infraction</th>\n",
        "      <th>location1</th>\n",
        "      <th>location2</th>\n",
        "      <th>location3</th>\n",
        "      <th>location4</th>\n",
        "      <th>province</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0 </th>\n",
        "      <td> ***78746</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 192</td>\n",
        "      <td>      STAND SIGNED TRANSIT STOP</td>\n",
        "      <td>  60</td>\n",
        "      <td>   0</td>\n",
        "      <td>  NR</td>\n",
        "      <td>        355 PARKSIDE DR</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1 </th>\n",
        "      <td> ***31670</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>   1</td>\n",
        "      <td>  NR</td>\n",
        "      <td>          220 KING ST W</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2 </th>\n",
        "      <td> ***47870</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>   1</td>\n",
        "      <td> N/S</td>\n",
        "      <td>                 ELM ST</td>\n",
        "      <td> W/O</td>\n",
        "      <td>   ELIZABETH ST</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3 </th>\n",
        "      <td> ***68489</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   8</td>\n",
        "      <td>    STD VEH HWY PROHIB TIME/DAY</td>\n",
        "      <td>  60</td>\n",
        "      <td>   1</td>\n",
        "      <td> N/S</td>\n",
        "      <td>              WALTON ST</td>\n",
        "      <td> E/O</td>\n",
        "      <td>         BAY ST</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4 </th>\n",
        "      <td> ***98802</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 337</td>\n",
        "      <td>            PARK - ON BOULEVARD</td>\n",
        "      <td>  50</td>\n",
        "      <td>   1</td>\n",
        "      <td> S/S</td>\n",
        "      <td>         SHEPPARD AVE E</td>\n",
        "      <td> E/O</td>\n",
        "      <td>    NEILSON AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5 </th>\n",
        "      <td> ***85083</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   8</td>\n",
        "      <td>    STD VEH HWY PROHIB TIME/DAY</td>\n",
        "      <td>  60</td>\n",
        "      <td>   2</td>\n",
        "      <td> N/S</td>\n",
        "      <td>              WALTON ST</td>\n",
        "      <td> E/O</td>\n",
        "      <td>         BAY ST</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6 </th>\n",
        "      <td> ***98803</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 337</td>\n",
        "      <td>            PARK - ON BOULEVARD</td>\n",
        "      <td>  50</td>\n",
        "      <td>   2</td>\n",
        "      <td> S/S</td>\n",
        "      <td>         SHEPPARD AVE E</td>\n",
        "      <td> E/O</td>\n",
        "      <td>    NEILSON AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7 </th>\n",
        "      <td> ***08841</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>  15</td>\n",
        "      <td>     PARK - 3 M OF FIRE HYDRANT</td>\n",
        "      <td> 100</td>\n",
        "      <td>   2</td>\n",
        "      <td>  NR</td>\n",
        "      <td> 35 THORNCLIFFE PARK DR</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> NJ</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8 </th>\n",
        "      <td> ***47871</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>   3</td>\n",
        "      <td> N/S</td>\n",
        "      <td>                 ELM ST</td>\n",
        "      <td> E/O</td>\n",
        "      <td> UNIVERSITY AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9 </th>\n",
        "      <td> ***98804</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 337</td>\n",
        "      <td>            PARK - ON BOULEVARD</td>\n",
        "      <td>  50</td>\n",
        "      <td>   3</td>\n",
        "      <td> S/S</td>\n",
        "      <td>         SHEPPARD AVE E</td>\n",
        "      <td> E/O</td>\n",
        "      <td>    NEILSON AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td> ***98805</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 337</td>\n",
        "      <td>            PARK - ON BOULEVARD</td>\n",
        "      <td>  50</td>\n",
        "      <td>   3</td>\n",
        "      <td> S/S</td>\n",
        "      <td>         SHEPPARD AVE E</td>\n",
        "      <td> E/O</td>\n",
        "      <td>    NEILSON AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td> ***99287</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>   3</td>\n",
        "      <td>  NR</td>\n",
        "      <td>         968 QUEEN ST W</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td> ***47872</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>   4</td>\n",
        "      <td> N/S</td>\n",
        "      <td>                 ELM ST</td>\n",
        "      <td> E/O</td>\n",
        "      <td> UNIVERSITY AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td> ***98806</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 337</td>\n",
        "      <td>            PARK - ON BOULEVARD</td>\n",
        "      <td>  50</td>\n",
        "      <td>   4</td>\n",
        "      <td> S/S</td>\n",
        "      <td>         SHEPPARD AVE E</td>\n",
        "      <td> E/O</td>\n",
        "      <td>    NEILSON AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td> ***13375</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 192</td>\n",
        "      <td>      STAND SIGNED TRANSIT STOP</td>\n",
        "      <td>  60</td>\n",
        "      <td>   4</td>\n",
        "      <td>  NR</td>\n",
        "      <td>        193 PARKSIDE DR</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> UT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td> ***13376</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 192</td>\n",
        "      <td>      STAND SIGNED TRANSIT STOP</td>\n",
        "      <td>  60</td>\n",
        "      <td>   5</td>\n",
        "      <td>  NR</td>\n",
        "      <td>        193 PARKSIDE DR</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td> ***13377</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 192</td>\n",
        "      <td>      STAND SIGNED TRANSIT STOP</td>\n",
        "      <td>  60</td>\n",
        "      <td>   5</td>\n",
        "      <td>  NR</td>\n",
        "      <td>        193 PARKSIDE DR</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td> ***98807</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 337</td>\n",
        "      <td>            PARK - ON BOULEVARD</td>\n",
        "      <td>  50</td>\n",
        "      <td>   6</td>\n",
        "      <td> S/S</td>\n",
        "      <td>         SHEPPARD AVE E</td>\n",
        "      <td> E/O</td>\n",
        "      <td>    NEILSON AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td> ***68490</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 384</td>\n",
        "      <td> STOP VEH OTR THN BCYCL-BYCL LN</td>\n",
        "      <td>  60</td>\n",
        "      <td>   7</td>\n",
        "      <td> OPP</td>\n",
        "      <td>        86 GERRARD ST E</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td> ***85084</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 384</td>\n",
        "      <td> STOP VEH OTR THN BCYCL-BYCL LN</td>\n",
        "      <td>  60</td>\n",
        "      <td>   8</td>\n",
        "      <td> OPP</td>\n",
        "      <td>        86 GERRARD ST E</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td> ***98808</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 337</td>\n",
        "      <td>            PARK - ON BOULEVARD</td>\n",
        "      <td>  50</td>\n",
        "      <td>   8</td>\n",
        "      <td> S/S</td>\n",
        "      <td>         SHEPPARD AVE E</td>\n",
        "      <td> E/O</td>\n",
        "      <td>    NEILSON AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td> ***68491</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 384</td>\n",
        "      <td> STOP VEH OTR THN BCYCL-BYCL LN</td>\n",
        "      <td>  60</td>\n",
        "      <td>   9</td>\n",
        "      <td>  NR</td>\n",
        "      <td>       101 GERRARD ST E</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> GA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td> ***86155</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>   9</td>\n",
        "      <td>  AT</td>\n",
        "      <td>         361 FRONT ST W</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td> ***98809</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 337</td>\n",
        "      <td>            PARK - ON BOULEVARD</td>\n",
        "      <td>  50</td>\n",
        "      <td>   9</td>\n",
        "      <td> S/S</td>\n",
        "      <td>         SHEPPARD AVE E</td>\n",
        "      <td> E/O</td>\n",
        "      <td>    NEILSON AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td> ***99288</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>   9</td>\n",
        "      <td>  NR</td>\n",
        "      <td>         942 QUEEN ST W</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td> ***47873</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   9</td>\n",
        "      <td>   STOP HWY PROHIBITED TIME/DAY</td>\n",
        "      <td>  60</td>\n",
        "      <td>  10</td>\n",
        "      <td> W/S</td>\n",
        "      <td>           ELIZABETH ST</td>\n",
        "      <td> N/O</td>\n",
        "      <td>      EDWARD ST</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26</th>\n",
        "      <td> ***47874</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  12</td>\n",
        "      <td>  NR</td>\n",
        "      <td>       150 ELIZABETH ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27</th>\n",
        "      <td> ***68492</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 192</td>\n",
        "      <td>      STAND SIGNED TRANSIT STOP</td>\n",
        "      <td>  60</td>\n",
        "      <td>  14</td>\n",
        "      <td> W/S</td>\n",
        "      <td>          PARLIAMENT ST</td>\n",
        "      <td> S/O</td>\n",
        "      <td>    VERNER LANE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28</th>\n",
        "      <td> ***99289</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  14</td>\n",
        "      <td>  NR</td>\n",
        "      <td>         723 QUEEN ST W</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29</th>\n",
        "      <td> ***47875</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  16</td>\n",
        "      <td> OPP</td>\n",
        "      <td>              77 ELM ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>30</th>\n",
        "      <td> ***47876</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  17</td>\n",
        "      <td> OPP</td>\n",
        "      <td>              77 ELM ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>31</th>\n",
        "      <td> ***86156</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>  15</td>\n",
        "      <td>        PARK 3M OF FIRE HYDRANT</td>\n",
        "      <td> 100</td>\n",
        "      <td>  20</td>\n",
        "      <td>  AT</td>\n",
        "      <td>         361 FRONT ST W</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>32</th>\n",
        "      <td> ***99290</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  22</td>\n",
        "      <td>  NR</td>\n",
        "      <td>          801 KING ST W</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>33</th>\n",
        "      <td> ***08842</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  22</td>\n",
        "      <td>  AT</td>\n",
        "      <td>        177 REDPATH AVE</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>34</th>\n",
        "      <td> ***08843</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  23</td>\n",
        "      <td>  AT</td>\n",
        "      <td>        177 REDPATH AVE</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>35</th>\n",
        "      <td> ***47877</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>  15</td>\n",
        "      <td>        PARK 3M OF FIRE HYDRANT</td>\n",
        "      <td> 100</td>\n",
        "      <td>  25</td>\n",
        "      <td>  NR</td>\n",
        "      <td>              13 ELM ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>36</th>\n",
        "      <td> ***99291</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  26</td>\n",
        "      <td>  NR</td>\n",
        "      <td>          901 KING ST W</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>37</th>\n",
        "      <td> ***08844</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  26</td>\n",
        "      <td>  AT</td>\n",
        "      <td>     200 ROEHAMPTON AVE</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>38</th>\n",
        "      <td> ***08845</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  26</td>\n",
        "      <td>  AT</td>\n",
        "      <td>     200 ROEHAMPTON AVE</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>39</th>\n",
        "      <td> ***98810</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>  14</td>\n",
        "      <td>       PARK OBSTRUCT DRIVE/LANE</td>\n",
        "      <td>  40</td>\n",
        "      <td>  28</td>\n",
        "      <td>  NR</td>\n",
        "      <td>         11 PROTEA GDNS</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>40</th>\n",
        "      <td> ***08846</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  28</td>\n",
        "      <td>  AT</td>\n",
        "      <td>     200 ROEHAMPTON AVE</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>41</th>\n",
        "      <td> ***08847</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  31</td>\n",
        "      <td>  AT</td>\n",
        "      <td>     200 ROEHAMPTON AVE</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>42</th>\n",
        "      <td> ***94096</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 192</td>\n",
        "      <td>      STAND SIGNED TRANSIT STOP</td>\n",
        "      <td>  60</td>\n",
        "      <td>  37</td>\n",
        "      <td>  NR</td>\n",
        "      <td>           922 PAPE AVE</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>43</th>\n",
        "      <td> ***99292</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>  PARK-HWY DRNG PROH TIMES/DAYS</td>\n",
        "      <td>  40</td>\n",
        "      <td>  39</td>\n",
        "      <td>  NR</td>\n",
        "      <td>       1366 DUNDAS ST W</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>44</th>\n",
        "      <td> ***47878</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 369</td>\n",
        "      <td> STAND STR DISABL LDG NO DROPOF</td>\n",
        "      <td> 450</td>\n",
        "      <td>  41</td>\n",
        "      <td>  NR</td>\n",
        "      <td>        32 GRENVILLE ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>45</th>\n",
        "      <td> ***47879</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 369</td>\n",
        "      <td> STAND STR DISABL LDG NO DROPOF</td>\n",
        "      <td> 450</td>\n",
        "      <td>  43</td>\n",
        "      <td>  NR</td>\n",
        "      <td>        18 GRENVILLE ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>46</th>\n",
        "      <td> ***47880</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  47</td>\n",
        "      <td>  NR</td>\n",
        "      <td>       7 BREADALBANE ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>47</th>\n",
        "      <td> ***37886</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  48</td>\n",
        "      <td>  AT</td>\n",
        "      <td>         735 COLLEGE ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>48</th>\n",
        "      <td> ***37887</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  49</td>\n",
        "      <td>  AT</td>\n",
        "      <td>         735 COLLEGE ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>49</th>\n",
        "      <td> ***86157</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  49</td>\n",
        "      <td>  AT</td>\n",
        "      <td>        37 GROSVENOR ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>50</th>\n",
        "      <td> ***08848</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  50</td>\n",
        "      <td> E/S</td>\n",
        "      <td>      MOUNT PLEASANT RD</td>\n",
        "      <td> S/O</td>\n",
        "      <td>   GARFIELD AVE</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>51</th>\n",
        "      <td> ***54745</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   3</td>\n",
        "      <td> PARK/LEAVE ON PRIVATE PROPERTY</td>\n",
        "      <td>  30</td>\n",
        "      <td>  51</td>\n",
        "      <td>  AT</td>\n",
        "      <td>             1 SCOTT ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>52</th>\n",
        "      <td> ***37888</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>  30</td>\n",
        "      <td> STOP ON/OVER SIDEWALK/FOOTPATH</td>\n",
        "      <td>  60</td>\n",
        "      <td>  52</td>\n",
        "      <td>  NR</td>\n",
        "      <td>        178 BEATRICE ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>53</th>\n",
        "      <td> ***44968</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  55</td>\n",
        "      <td> OPP</td>\n",
        "      <td>          168 SIMCOE ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>54</th>\n",
        "      <td> ***47881</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  56</td>\n",
        "      <td>  NR</td>\n",
        "      <td>          27 CARLTON ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>55</th>\n",
        "      <td> ***47882</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  58</td>\n",
        "      <td>  NR</td>\n",
        "      <td>          27 CARLTON ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>56</th>\n",
        "      <td> ***47883</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td>  59</td>\n",
        "      <td>  NR</td>\n",
        "      <td>          27 CARLTON ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>57</th>\n",
        "      <td> ***44969</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   5</td>\n",
        "      <td>     PARK HWY PROHIBED TIME/DAY</td>\n",
        "      <td>  40</td>\n",
        "      <td> 103</td>\n",
        "      <td>  NR</td>\n",
        "      <td>          100 SIMCOE ST</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>58</th>\n",
        "      <td> ***09737</td>\n",
        "      <td> 20120101</td>\n",
        "      <td> 356</td>\n",
        "      <td>    STAND IN DISABLED NO PERMIT</td>\n",
        "      <td> 450</td>\n",
        "      <td> 110</td>\n",
        "      <td>  AT</td>\n",
        "      <td>           11 BRUNEL CT</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>59</th>\n",
        "      <td> ***47884</td>\n",
        "      <td> 20120101</td>\n",
        "      <td>   9</td>\n",
        "      <td>   STOP HWY PROHIBITED TIME/DAY</td>\n",
        "      <td>  60</td>\n",
        "      <td> 111</td>\n",
        "      <td> OPP</td>\n",
        "      <td>        86 GERRARD ST E</td>\n",
        "      <td> NaN</td>\n",
        "      <td>            NaN</td>\n",
        "      <td> ON</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",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>2746154 rows \u00d7 11 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 1,
       "text": [
        "   tag_number_masked  date_of_infraction  infraction_code  \\\n",
        "0           ***78746            20120101              192   \n",
        "1           ***31670            20120101                5   \n",
        "2           ***47870            20120101                5   \n",
        "3           ***68489            20120101                8   \n",
        "4           ***98802            20120101              337   \n",
        "5           ***85083            20120101                8   \n",
        "6           ***98803            20120101              337   \n",
        "7           ***08841            20120101               15   \n",
        "8           ***47871            20120101                5   \n",
        "9           ***98804            20120101              337   \n",
        "10          ***98805            20120101              337   \n",
        "11          ***99287            20120101                5   \n",
        "12          ***47872            20120101                5   \n",
        "13          ***98806            20120101              337   \n",
        "14          ***13375            20120101              192   \n",
        "15          ***13376            20120101              192   \n",
        "16          ***13377            20120101              192   \n",
        "17          ***98807            20120101              337   \n",
        "18          ***68490            20120101              384   \n",
        "19          ***85084            20120101              384   \n",
        "20          ***98808            20120101              337   \n",
        "21          ***68491            20120101              384   \n",
        "22          ***86155            20120101                3   \n",
        "23          ***98809            20120101              337   \n",
        "24          ***99288            20120101                5   \n",
        "25          ***47873            20120101                9   \n",
        "26          ***47874            20120101                5   \n",
        "27          ***68492            20120101              192   \n",
        "28          ***99289            20120101                5   \n",
        "29          ***47875            20120101                5   \n",
        "30          ***47876            20120101                5   \n",
        "31          ***86156            20120101               15   \n",
        "32          ***99290            20120101                5   \n",
        "33          ***08842            20120101                3   \n",
        "34          ***08843            20120101                3   \n",
        "35          ***47877            20120101               15   \n",
        "36          ***99291            20120101                5   \n",
        "37          ***08844            20120101                3   \n",
        "38          ***08845            20120101                3   \n",
        "39          ***98810            20120101               14   \n",
        "40          ***08846            20120101                3   \n",
        "41          ***08847            20120101                3   \n",
        "42          ***94096            20120101              192   \n",
        "43          ***99292            20120101                5   \n",
        "44          ***47878            20120101              369   \n",
        "45          ***47879            20120101              369   \n",
        "46          ***47880            20120101                5   \n",
        "47          ***37886            20120101                3   \n",
        "48          ***37887            20120101                3   \n",
        "49          ***86157            20120101                3   \n",
        "50          ***08848            20120101                5   \n",
        "51          ***54745            20120101                3   \n",
        "52          ***37888            20120101               30   \n",
        "53          ***44968            20120101                5   \n",
        "54          ***47881            20120101                5   \n",
        "55          ***47882            20120101                5   \n",
        "56          ***47883            20120101                5   \n",
        "57          ***44969            20120101                5   \n",
        "58          ***09737            20120101              356   \n",
        "59          ***47884            20120101                9   \n",
        "                 ...                 ...              ...   \n",
        "\n",
        "            infraction_description  set_fine_amount  time_of_infraction  \\\n",
        "0        STAND SIGNED TRANSIT STOP               60                   0   \n",
        "1       PARK HWY PROHIBED TIME/DAY               40                   1   \n",
        "2       PARK HWY PROHIBED TIME/DAY               40                   1   \n",
        "3      STD VEH HWY PROHIB TIME/DAY               60                   1   \n",
        "4              PARK - ON BOULEVARD               50                   1   \n",
        "5      STD VEH HWY PROHIB TIME/DAY               60                   2   \n",
        "6              PARK - ON BOULEVARD               50                   2   \n",
        "7       PARK - 3 M OF FIRE HYDRANT              100                   2   \n",
        "8       PARK HWY PROHIBED TIME/DAY               40                   3   \n",
        "9              PARK - ON BOULEVARD               50                   3   \n",
        "10             PARK - ON BOULEVARD               50                   3   \n",
        "11      PARK HWY PROHIBED TIME/DAY               40                   3   \n",
        "12      PARK HWY PROHIBED TIME/DAY               40                   4   \n",
        "13             PARK - ON BOULEVARD               50                   4   \n",
        "14       STAND SIGNED TRANSIT STOP               60                   4   \n",
        "15       STAND SIGNED TRANSIT STOP               60                   5   \n",
        "16       STAND SIGNED TRANSIT STOP               60                   5   \n",
        "17             PARK - ON BOULEVARD               50                   6   \n",
        "18  STOP VEH OTR THN BCYCL-BYCL LN               60                   7   \n",
        "19  STOP VEH OTR THN BCYCL-BYCL LN               60                   8   \n",
        "20             PARK - ON BOULEVARD               50                   8   \n",
        "21  STOP VEH OTR THN BCYCL-BYCL LN               60                   9   \n",
        "22  PARK/LEAVE ON PRIVATE PROPERTY               30                   9   \n",
        "23             PARK - ON BOULEVARD               50                   9   \n",
        "24      PARK HWY PROHIBED TIME/DAY               40                   9   \n",
        "25    STOP HWY PROHIBITED TIME/DAY               60                  10   \n",
        "26      PARK HWY PROHIBED TIME/DAY               40                  12   \n",
        "27       STAND SIGNED TRANSIT STOP               60                  14   \n",
        "28      PARK HWY PROHIBED TIME/DAY               40                  14   \n",
        "29      PARK HWY PROHIBED TIME/DAY               40                  16   \n",
        "30      PARK HWY PROHIBED TIME/DAY               40                  17   \n",
        "31         PARK 3M OF FIRE HYDRANT              100                  20   \n",
        "32      PARK HWY PROHIBED TIME/DAY               40                  22   \n",
        "33  PARK/LEAVE ON PRIVATE PROPERTY               30                  22   \n",
        "34  PARK/LEAVE ON PRIVATE PROPERTY               30                  23   \n",
        "35         PARK 3M OF FIRE HYDRANT              100                  25   \n",
        "36      PARK HWY PROHIBED TIME/DAY               40                  26   \n",
        "37  PARK/LEAVE ON PRIVATE PROPERTY               30                  26   \n",
        "38  PARK/LEAVE ON PRIVATE PROPERTY               30                  26   \n",
        "39        PARK OBSTRUCT DRIVE/LANE               40                  28   \n",
        "40  PARK/LEAVE ON PRIVATE PROPERTY               30                  28   \n",
        "41  PARK/LEAVE ON PRIVATE PROPERTY               30                  31   \n",
        "42       STAND SIGNED TRANSIT STOP               60                  37   \n",
        "43   PARK-HWY DRNG PROH TIMES/DAYS               40                  39   \n",
        "44  STAND STR DISABL LDG NO DROPOF              450                  41   \n",
        "45  STAND STR DISABL LDG NO DROPOF              450                  43   \n",
        "46      PARK HWY PROHIBED TIME/DAY               40                  47   \n",
        "47  PARK/LEAVE ON PRIVATE PROPERTY               30                  48   \n",
        "48  PARK/LEAVE ON PRIVATE PROPERTY               30                  49   \n",
        "49  PARK/LEAVE ON PRIVATE PROPERTY               30                  49   \n",
        "50      PARK HWY PROHIBED TIME/DAY               40                  50   \n",
        "51  PARK/LEAVE ON PRIVATE PROPERTY               30                  51   \n",
        "52  STOP ON/OVER SIDEWALK/FOOTPATH               60                  52   \n",
        "53      PARK HWY PROHIBED TIME/DAY               40                  55   \n",
        "54      PARK HWY PROHIBED TIME/DAY               40                  56   \n",
        "55      PARK HWY PROHIBED TIME/DAY               40                  58   \n",
        "56      PARK HWY PROHIBED TIME/DAY               40                  59   \n",
        "57      PARK HWY PROHIBED TIME/DAY               40                 103   \n",
        "58     STAND IN DISABLED NO PERMIT              450                 110   \n",
        "59    STOP HWY PROHIBITED TIME/DAY               60                 111   \n",
        "                               ...              ...                 ...   \n",
        "\n",
        "   location1               location2 location3       location4 province  \n",
        "0         NR         355 PARKSIDE DR       NaN             NaN       ON  \n",
        "1         NR           220 KING ST W       NaN             NaN       ON  \n",
        "2        N/S                  ELM ST       W/O    ELIZABETH ST       ON  \n",
        "3        N/S               WALTON ST       E/O          BAY ST       ON  \n",
        "4        S/S          SHEPPARD AVE E       E/O     NEILSON AVE       ON  \n",
        "5        N/S               WALTON ST       E/O          BAY ST       ON  \n",
        "6        S/S          SHEPPARD AVE E       E/O     NEILSON AVE       ON  \n",
        "7         NR  35 THORNCLIFFE PARK DR       NaN             NaN       NJ  \n",
        "8        N/S                  ELM ST       E/O  UNIVERSITY AVE       ON  \n",
        "9        S/S          SHEPPARD AVE E       E/O     NEILSON AVE       ON  \n",
        "10       S/S          SHEPPARD AVE E       E/O     NEILSON AVE       ON  \n",
        "11        NR          968 QUEEN ST W       NaN             NaN       ON  \n",
        "12       N/S                  ELM ST       E/O  UNIVERSITY AVE       ON  \n",
        "13       S/S          SHEPPARD AVE E       E/O     NEILSON AVE       ON  \n",
        "14        NR         193 PARKSIDE DR       NaN             NaN       UT  \n",
        "15        NR         193 PARKSIDE DR       NaN             NaN       ON  \n",
        "16        NR         193 PARKSIDE DR       NaN             NaN       ON  \n",
        "17       S/S          SHEPPARD AVE E       E/O     NEILSON AVE       ON  \n",
        "18       OPP         86 GERRARD ST E       NaN             NaN       ON  \n",
        "19       OPP         86 GERRARD ST E       NaN             NaN       ON  \n",
        "20       S/S          SHEPPARD AVE E       E/O     NEILSON AVE       ON  \n",
        "21        NR        101 GERRARD ST E       NaN             NaN       GA  \n",
        "22        AT          361 FRONT ST W       NaN             NaN       ON  \n",
        "23       S/S          SHEPPARD AVE E       E/O     NEILSON AVE       ON  \n",
        "24        NR          942 QUEEN ST W       NaN             NaN       ON  \n",
        "25       W/S            ELIZABETH ST       N/O       EDWARD ST       ON  \n",
        "26        NR        150 ELIZABETH ST       NaN             NaN       ON  \n",
        "27       W/S           PARLIAMENT ST       S/O     VERNER LANE       ON  \n",
        "28        NR          723 QUEEN ST W       NaN             NaN       ON  \n",
        "29       OPP               77 ELM ST       NaN             NaN       ON  \n",
        "30       OPP               77 ELM ST       NaN             NaN       ON  \n",
        "31        AT          361 FRONT ST W       NaN             NaN       ON  \n",
        "32        NR           801 KING ST W       NaN             NaN       ON  \n",
        "33        AT         177 REDPATH AVE       NaN             NaN       ON  \n",
        "34        AT         177 REDPATH AVE       NaN             NaN       ON  \n",
        "35        NR               13 ELM ST       NaN             NaN       ON  \n",
        "36        NR           901 KING ST W       NaN             NaN       ON  \n",
        "37        AT      200 ROEHAMPTON AVE       NaN             NaN       ON  \n",
        "38        AT      200 ROEHAMPTON AVE       NaN             NaN       ON  \n",
        "39        NR          11 PROTEA GDNS       NaN             NaN       ON  \n",
        "40        AT      200 ROEHAMPTON AVE       NaN             NaN       ON  \n",
        "41        AT      200 ROEHAMPTON AVE       NaN             NaN       ON  \n",
        "42        NR            922 PAPE AVE       NaN             NaN       ON  \n",
        "43        NR        1366 DUNDAS ST W       NaN             NaN       ON  \n",
        "44        NR         32 GRENVILLE ST       NaN             NaN       ON  \n",
        "45        NR         18 GRENVILLE ST       NaN             NaN       ON  \n",
        "46        NR        7 BREADALBANE ST       NaN             NaN       ON  \n",
        "47        AT          735 COLLEGE ST       NaN             NaN       ON  \n",
        "48        AT          735 COLLEGE ST       NaN             NaN       ON  \n",
        "49        AT         37 GROSVENOR ST       NaN             NaN       ON  \n",
        "50       E/S       MOUNT PLEASANT RD       S/O    GARFIELD AVE       ON  \n",
        "51        AT              1 SCOTT ST       NaN             NaN       ON  \n",
        "52        NR         178 BEATRICE ST       NaN             NaN       ON  \n",
        "53       OPP           168 SIMCOE ST       NaN             NaN       ON  \n",
        "54        NR           27 CARLTON ST       NaN             NaN       ON  \n",
        "55        NR           27 CARLTON ST       NaN             NaN       ON  \n",
        "56        NR           27 CARLTON ST       NaN             NaN       ON  \n",
        "57        NR           100 SIMCOE ST       NaN             NaN       ON  \n",
        "58        AT            11 BRUNEL CT       NaN             NaN       ON  \n",
        "59       OPP         86 GERRARD ST E       NaN             NaN       ON  \n",
        "         ...                     ...       ...             ...      ...  \n",
        "\n",
        "[2746154 rows x 11 columns]"
       ]
      }
     ],
     "prompt_number": 1
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df.dtypes"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 2,
       "text": [
        "tag_number_masked          object\n",
        "date_of_infraction          int64\n",
        "infraction_code             int64\n",
        "infraction_description     object\n",
        "set_fine_amount             int64\n",
        "time_of_infraction        float64\n",
        "location1                  object\n",
        "location2                  object\n",
        "location3                  object\n",
        "location4                  object\n",
        "province                   object\n",
        "dtype: object"
       ]
      }
     ],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "pd.isnull(df['date_of_infraction']).value_counts()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 3,
       "text": [
        "False    2746154\n",
        "dtype: int64"
       ]
      }
     ],
     "prompt_number": 3
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "date_format = '%Y%m%d'\n",
      "\n",
      "def create_weekday(x):\n",
      "    d = dt.datetime.strptime(str(x['date_of_infraction']), date_format)\n",
      "    return d.strftime('%A')\n",
      "\n",
      "df['weekday'] = df.apply(create_weekday, axis=1)\n",
      "weekday_counts = df['weekday'].value_counts()\n",
      "weekday_counts"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 4,
       "text": [
        "Thursday     432138\n",
        "Wednesday    430728\n",
        "Friday       428295\n",
        "Tuesday      424923\n",
        "Monday       379130\n",
        "Saturday     368239\n",
        "Sunday       282701\n",
        "dtype: int64"
       ]
      }
     ],
     "prompt_number": 4
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "weekdays = pd.DataFrame({ 'label': weekday_counts.keys(), 'count': weekday_counts.values })\n",
      "weekdays"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>count</th>\n",
        "      <th>label</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 432138</td>\n",
        "      <td>  Thursday</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 430728</td>\n",
        "      <td> Wednesday</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 428295</td>\n",
        "      <td>    Friday</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 424923</td>\n",
        "      <td>   Tuesday</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 379130</td>\n",
        "      <td>    Monday</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> 368239</td>\n",
        "      <td>  Saturday</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td> 282701</td>\n",
        "      <td>    Sunday</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>7 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 5,
       "text": [
        "    count      label\n",
        "0  432138   Thursday\n",
        "1  430728  Wednesday\n",
        "2  428295     Friday\n",
        "3  424923    Tuesday\n",
        "4  379130     Monday\n",
        "5  368239   Saturday\n",
        "6  282701     Sunday\n",
        "\n",
        "[7 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 5
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "weekdays = weekdays.reindex_axis(sorted(weekdays.columns, reverse=True), axis=1)\n",
      "weekdays"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>label</th>\n",
        "      <th>count</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>  Thursday</td>\n",
        "      <td> 432138</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> Wednesday</td>\n",
        "      <td> 430728</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>    Friday</td>\n",
        "      <td> 428295</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>   Tuesday</td>\n",
        "      <td> 424923</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td>    Monday</td>\n",
        "      <td> 379130</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td>  Saturday</td>\n",
        "      <td> 368239</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td>    Sunday</td>\n",
        "      <td> 282701</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>7 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 6,
       "text": [
        "       label   count\n",
        "0   Thursday  432138\n",
        "1  Wednesday  430728\n",
        "2     Friday  428295\n",
        "3    Tuesday  424923\n",
        "4     Monday  379130\n",
        "5   Saturday  368239\n",
        "6     Sunday  282701\n",
        "\n",
        "[7 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 6
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "weekdays = weekdays.reindex_axis([4,3,1,0,2,5,6], axis=0)\n",
      "weekdays"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>label</th>\n",
        "      <th>count</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td>    Monday</td>\n",
        "      <td> 379130</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>   Tuesday</td>\n",
        "      <td> 424923</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> Wednesday</td>\n",
        "      <td> 430728</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>  Thursday</td>\n",
        "      <td> 432138</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>    Friday</td>\n",
        "      <td> 428295</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td>  Saturday</td>\n",
        "      <td> 368239</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td>    Sunday</td>\n",
        "      <td> 282701</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>7 rows \u00d7 2 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 7,
       "text": [
        "       label   count\n",
        "4     Monday  379130\n",
        "3    Tuesday  424923\n",
        "1  Wednesday  430728\n",
        "0   Thursday  432138\n",
        "2     Friday  428295\n",
        "5   Saturday  368239\n",
        "6     Sunday  282701\n",
        "\n",
        "[7 rows x 2 columns]"
       ]
      }
     ],
     "prompt_number": 7
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "weekdays.to_csv('weekdays.csv', index=False)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 8
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}