Traffic Count Percentile Cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import patsy\n",
    "import statsmodels.api as sm\n",
    "from scipy.stats import ttest_ind"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df1 = 'Cleaned_Traffic_Count.csv'\n",
    "df1 = pd.read_csv(df1)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "del df1['Unnamed: 0']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>Date</th>\n",
       "      <th>Weekday</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Total Traffic</th>\n",
       "      <th>12:00-1:00 AM</th>\n",
       "      <th>1:00-2:00AM</th>\n",
       "      <th>2:00-3:00AM</th>\n",
       "      <th>3:00-4:00AM</th>\n",
       "      <th>4:00-5:00AM</th>\n",
       "      <th>...</th>\n",
       "      <th>6:00-7:00PM</th>\n",
       "      <th>7:00-8:00PM</th>\n",
       "      <th>8:00-9:00PM</th>\n",
       "      <th>9:00-10:00PM</th>\n",
       "      <th>10:00-11:00PM</th>\n",
       "      <th>11:00-12:00AM</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5391.0</td>\n",
       "      <td>106</td>\n",
       "      <td>74</td>\n",
       "      <td>45.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>379</td>\n",
       "      <td>329</td>\n",
       "      <td>249</td>\n",
       "      <td>197</td>\n",
       "      <td>187</td>\n",
       "      <td>169</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>4085.0</td>\n",
       "      <td>109</td>\n",
       "      <td>74</td>\n",
       "      <td>55.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>242</td>\n",
       "      <td>217</td>\n",
       "      <td>210</td>\n",
       "      <td>144</td>\n",
       "      <td>125</td>\n",
       "      <td>79</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5867.0</td>\n",
       "      <td>36</td>\n",
       "      <td>28</td>\n",
       "      <td>11.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>425</td>\n",
       "      <td>358</td>\n",
       "      <td>224</td>\n",
       "      <td>185</td>\n",
       "      <td>132</td>\n",
       "      <td>74</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>6172.0</td>\n",
       "      <td>42</td>\n",
       "      <td>28</td>\n",
       "      <td>16.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>446</td>\n",
       "      <td>424</td>\n",
       "      <td>305</td>\n",
       "      <td>219</td>\n",
       "      <td>171</td>\n",
       "      <td>76</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5597.0</td>\n",
       "      <td>35</td>\n",
       "      <td>38</td>\n",
       "      <td>12.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>401</td>\n",
       "      <td>338</td>\n",
       "      <td>236</td>\n",
       "      <td>186</td>\n",
       "      <td>123</td>\n",
       "      <td>76</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date    Weekday  Segment ID Direction  Total Traffic  12:00-1:00 AM  \\\n",
       "0  02/02/2013   Saturday        2153        NB         5391.0            106   \n",
       "1  02/03/2013     Sunday        2153        NB         4085.0            109   \n",
       "2  02/04/2013     Monday        2153        NB         5867.0             36   \n",
       "3  02/05/2013    Tuesday        2153        NB         6172.0             42   \n",
       "4  02/06/2013  Wednesday        2153        NB         5597.0             35   \n",
       "\n",
       "   1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  4:00-5:00AM ...  6:00-7:00PM  \\\n",
       "0           74         45.0         29.0           29 ...          379   \n",
       "1           74         55.0         37.0           26 ...          242   \n",
       "2           28         11.0         16.0           32 ...          425   \n",
       "3           28         16.0         12.0           34 ...          446   \n",
       "4           38         12.0         14.0           31 ...          401   \n",
       "\n",
       "   7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \\\n",
       "0          329          249           197            187            169   \n",
       "1          217          210           144            125             79   \n",
       "2          358          224           185            132             74   \n",
       "3          424          305           219            171             76   \n",
       "4          338          236           186            123             76   \n",
       "\n",
       "   Roadway Name        From            To  ID  \n",
       "0  HUGUENOT AVE  WOODROW RD  STAFFORD AVE   1  \n",
       "1  HUGUENOT AVE  WOODROW RD  STAFFORD AVE   1  \n",
       "2  HUGUENOT AVE  WOODROW RD  STAFFORD AVE   1  \n",
       "3  HUGUENOT AVE  WOODROW RD  STAFFORD AVE   1  \n",
       "4  HUGUENOT AVE  WOODROW RD  STAFFORD AVE   1  \n",
       "\n",
       "[5 rows x 33 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head(n=5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>Date</th>\n",
       "      <th>Weekday</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Total Traffic</th>\n",
       "      <th>12:00-1:00 AM</th>\n",
       "      <th>1:00-2:00AM</th>\n",
       "      <th>2:00-3:00AM</th>\n",
       "      <th>3:00-4:00AM</th>\n",
       "      <th>4:00-5:00AM</th>\n",
       "      <th>...</th>\n",
       "      <th>6:00-7:00PM</th>\n",
       "      <th>7:00-8:00PM</th>\n",
       "      <th>8:00-9:00PM</th>\n",
       "      <th>9:00-10:00PM</th>\n",
       "      <th>10:00-11:00PM</th>\n",
       "      <th>11:00-12:00AM</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5391.0</td>\n",
       "      <td>106</td>\n",
       "      <td>74</td>\n",
       "      <td>45.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>379</td>\n",
       "      <td>329</td>\n",
       "      <td>249</td>\n",
       "      <td>197</td>\n",
       "      <td>187</td>\n",
       "      <td>169</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>4085.0</td>\n",
       "      <td>109</td>\n",
       "      <td>74</td>\n",
       "      <td>55.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>242</td>\n",
       "      <td>217</td>\n",
       "      <td>210</td>\n",
       "      <td>144</td>\n",
       "      <td>125</td>\n",
       "      <td>79</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5867.0</td>\n",
       "      <td>36</td>\n",
       "      <td>28</td>\n",
       "      <td>11.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>425</td>\n",
       "      <td>358</td>\n",
       "      <td>224</td>\n",
       "      <td>185</td>\n",
       "      <td>132</td>\n",
       "      <td>74</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>6172.0</td>\n",
       "      <td>42</td>\n",
       "      <td>28</td>\n",
       "      <td>16.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>446</td>\n",
       "      <td>424</td>\n",
       "      <td>305</td>\n",
       "      <td>219</td>\n",
       "      <td>171</td>\n",
       "      <td>76</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5597.0</td>\n",
       "      <td>35</td>\n",
       "      <td>38</td>\n",
       "      <td>12.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>401</td>\n",
       "      <td>338</td>\n",
       "      <td>236</td>\n",
       "      <td>186</td>\n",
       "      <td>123</td>\n",
       "      <td>76</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5302.0</td>\n",
       "      <td>33</td>\n",
       "      <td>26</td>\n",
       "      <td>14.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>356</td>\n",
       "      <td>339</td>\n",
       "      <td>275</td>\n",
       "      <td>225</td>\n",
       "      <td>169</td>\n",
       "      <td>104</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>02/08/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>6448.0</td>\n",
       "      <td>35</td>\n",
       "      <td>28</td>\n",
       "      <td>18.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>531</td>\n",
       "      <td>393</td>\n",
       "      <td>351</td>\n",
       "      <td>276</td>\n",
       "      <td>242</td>\n",
       "      <td>154</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>02/09/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5504.0</td>\n",
       "      <td>110</td>\n",
       "      <td>73</td>\n",
       "      <td>46.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>29</td>\n",
       "      <td>...</td>\n",
       "      <td>387</td>\n",
       "      <td>336</td>\n",
       "      <td>254</td>\n",
       "      <td>201</td>\n",
       "      <td>191</td>\n",
       "      <td>174</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>02/10/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>4171.0</td>\n",
       "      <td>114</td>\n",
       "      <td>77</td>\n",
       "      <td>58.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>246</td>\n",
       "      <td>221</td>\n",
       "      <td>214</td>\n",
       "      <td>147</td>\n",
       "      <td>121</td>\n",
       "      <td>85</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>02/11/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5989.0</td>\n",
       "      <td>38</td>\n",
       "      <td>30</td>\n",
       "      <td>15.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>433</td>\n",
       "      <td>365</td>\n",
       "      <td>228</td>\n",
       "      <td>189</td>\n",
       "      <td>136</td>\n",
       "      <td>75</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>02/12/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>6326.0</td>\n",
       "      <td>43</td>\n",
       "      <td>32</td>\n",
       "      <td>20.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>36</td>\n",
       "      <td>...</td>\n",
       "      <td>454</td>\n",
       "      <td>433</td>\n",
       "      <td>312</td>\n",
       "      <td>223</td>\n",
       "      <td>175</td>\n",
       "      <td>97</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>02/13/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5696.0</td>\n",
       "      <td>38</td>\n",
       "      <td>41</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>409</td>\n",
       "      <td>345</td>\n",
       "      <td>240</td>\n",
       "      <td>190</td>\n",
       "      <td>126</td>\n",
       "      <td>79</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>02/14/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5338.0</td>\n",
       "      <td>37</td>\n",
       "      <td>29</td>\n",
       "      <td>18.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>394</td>\n",
       "      <td>354</td>\n",
       "      <td>247</td>\n",
       "      <td>200</td>\n",
       "      <td>151</td>\n",
       "      <td>97</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5121.0</td>\n",
       "      <td>132</td>\n",
       "      <td>88</td>\n",
       "      <td>63.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>336</td>\n",
       "      <td>272</td>\n",
       "      <td>228</td>\n",
       "      <td>199</td>\n",
       "      <td>190</td>\n",
       "      <td>155</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>4056.0</td>\n",
       "      <td>126</td>\n",
       "      <td>89</td>\n",
       "      <td>72.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>43</td>\n",
       "      <td>...</td>\n",
       "      <td>255</td>\n",
       "      <td>254</td>\n",
       "      <td>210</td>\n",
       "      <td>138</td>\n",
       "      <td>101</td>\n",
       "      <td>89</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5546.0</td>\n",
       "      <td>59</td>\n",
       "      <td>30</td>\n",
       "      <td>13.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>390</td>\n",
       "      <td>358</td>\n",
       "      <td>251</td>\n",
       "      <td>194</td>\n",
       "      <td>132</td>\n",
       "      <td>79</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5784.0</td>\n",
       "      <td>62</td>\n",
       "      <td>27</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>434</td>\n",
       "      <td>387</td>\n",
       "      <td>301</td>\n",
       "      <td>212</td>\n",
       "      <td>146</td>\n",
       "      <td>101</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5389.0</td>\n",
       "      <td>67</td>\n",
       "      <td>29</td>\n",
       "      <td>16.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>426</td>\n",
       "      <td>306</td>\n",
       "      <td>253</td>\n",
       "      <td>176</td>\n",
       "      <td>127</td>\n",
       "      <td>89</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5361.0</td>\n",
       "      <td>49</td>\n",
       "      <td>30</td>\n",
       "      <td>8.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>26</td>\n",
       "      <td>...</td>\n",
       "      <td>367</td>\n",
       "      <td>369</td>\n",
       "      <td>283</td>\n",
       "      <td>185</td>\n",
       "      <td>155</td>\n",
       "      <td>146</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>02/08/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5301.0</td>\n",
       "      <td>76</td>\n",
       "      <td>36</td>\n",
       "      <td>23.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>418</td>\n",
       "      <td>387</td>\n",
       "      <td>264</td>\n",
       "      <td>211</td>\n",
       "      <td>178</td>\n",
       "      <td>167</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>02/09/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5173.0</td>\n",
       "      <td>121</td>\n",
       "      <td>60</td>\n",
       "      <td>62.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>340</td>\n",
       "      <td>311</td>\n",
       "      <td>258</td>\n",
       "      <td>186</td>\n",
       "      <td>171</td>\n",
       "      <td>191</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>02/10/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>4174.0</td>\n",
       "      <td>126</td>\n",
       "      <td>98</td>\n",
       "      <td>77.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>275</td>\n",
       "      <td>208</td>\n",
       "      <td>171</td>\n",
       "      <td>139</td>\n",
       "      <td>97</td>\n",
       "      <td>48</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>02/11/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5222.0</td>\n",
       "      <td>23</td>\n",
       "      <td>15</td>\n",
       "      <td>11.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>64</td>\n",
       "      <td>...</td>\n",
       "      <td>355</td>\n",
       "      <td>272</td>\n",
       "      <td>175</td>\n",
       "      <td>149</td>\n",
       "      <td>69</td>\n",
       "      <td>54</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>02/12/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>3289.0</td>\n",
       "      <td>33</td>\n",
       "      <td>17</td>\n",
       "      <td>3.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>62</td>\n",
       "      <td>...</td>\n",
       "      <td>221</td>\n",
       "      <td>134</td>\n",
       "      <td>114</td>\n",
       "      <td>54</td>\n",
       "      <td>27</td>\n",
       "      <td>21</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>02/13/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>3016.0</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>220</td>\n",
       "      <td>135</td>\n",
       "      <td>107</td>\n",
       "      <td>67</td>\n",
       "      <td>37</td>\n",
       "      <td>19</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>02/14/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>2911.0</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>230</td>\n",
       "      <td>171</td>\n",
       "      <td>130</td>\n",
       "      <td>92</td>\n",
       "      <td>56</td>\n",
       "      <td>26</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>09/29/2012</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>6644</td>\n",
       "      <td>NB</td>\n",
       "      <td>7148.0</td>\n",
       "      <td>89</td>\n",
       "      <td>40</td>\n",
       "      <td>33.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>492</td>\n",
       "      <td>358</td>\n",
       "      <td>221</td>\n",
       "      <td>164</td>\n",
       "      <td>145</td>\n",
       "      <td>130</td>\n",
       "      <td>RICHMOND HILL ROAD</td>\n",
       "      <td>EDINBORO ROAD</td>\n",
       "      <td>FOREST HILL ROAD</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>09/30/2012</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>6644</td>\n",
       "      <td>NB</td>\n",
       "      <td>5166.0</td>\n",
       "      <td>99</td>\n",
       "      <td>66</td>\n",
       "      <td>41.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>28</td>\n",
       "      <td>...</td>\n",
       "      <td>231</td>\n",
       "      <td>190</td>\n",
       "      <td>139</td>\n",
       "      <td>110</td>\n",
       "      <td>104</td>\n",
       "      <td>66</td>\n",
       "      <td>RICHMOND HILL ROAD</td>\n",
       "      <td>EDINBORO ROAD</td>\n",
       "      <td>FOREST HILL ROAD</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>10/01/2012</td>\n",
       "      <td>Monday</td>\n",
       "      <td>6644</td>\n",
       "      <td>NB</td>\n",
       "      <td>5774.0</td>\n",
       "      <td>51</td>\n",
       "      <td>35</td>\n",
       "      <td>24.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>436</td>\n",
       "      <td>291</td>\n",
       "      <td>203</td>\n",
       "      <td>137</td>\n",
       "      <td>93</td>\n",
       "      <td>55</td>\n",
       "      <td>RICHMOND HILL ROAD</td>\n",
       "      <td>EDINBORO ROAD</td>\n",
       "      <td>FOREST HILL ROAD</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>10/02/2012</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>6644</td>\n",
       "      <td>NB</td>\n",
       "      <td>6337.0</td>\n",
       "      <td>30</td>\n",
       "      <td>20</td>\n",
       "      <td>14.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>46</td>\n",
       "      <td>...</td>\n",
       "      <td>418</td>\n",
       "      <td>330</td>\n",
       "      <td>212</td>\n",
       "      <td>140</td>\n",
       "      <td>94</td>\n",
       "      <td>56</td>\n",
       "      <td>RICHMOND HILL ROAD</td>\n",
       "      <td>EDINBORO ROAD</td>\n",
       "      <td>FOREST HILL ROAD</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5915</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>34697.0</td>\n",
       "      <td>1141</td>\n",
       "      <td>523</td>\n",
       "      <td>263.0</td>\n",
       "      <td>204.0</td>\n",
       "      <td>218</td>\n",
       "      <td>...</td>\n",
       "      <td>2403</td>\n",
       "      <td>1570</td>\n",
       "      <td>1330</td>\n",
       "      <td>1577</td>\n",
       "      <td>1238</td>\n",
       "      <td>1011</td>\n",
       "      <td>THROGS NECK EXPRESSWAY</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5916</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>47502.0</td>\n",
       "      <td>812</td>\n",
       "      <td>393</td>\n",
       "      <td>233.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>470</td>\n",
       "      <td>...</td>\n",
       "      <td>2647</td>\n",
       "      <td>2001</td>\n",
       "      <td>1502</td>\n",
       "      <td>1286</td>\n",
       "      <td>1052</td>\n",
       "      <td>677</td>\n",
       "      <td>THROGS NECK EXPRESSWAY</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5917</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>46805.0</td>\n",
       "      <td>419</td>\n",
       "      <td>292</td>\n",
       "      <td>245.0</td>\n",
       "      <td>296.0</td>\n",
       "      <td>473</td>\n",
       "      <td>...</td>\n",
       "      <td>2455</td>\n",
       "      <td>1828</td>\n",
       "      <td>1431</td>\n",
       "      <td>1254</td>\n",
       "      <td>1116</td>\n",
       "      <td>703</td>\n",
       "      <td>THROGS NECK EXPRESSWAY</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5918</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>48843.0</td>\n",
       "      <td>408</td>\n",
       "      <td>250</td>\n",
       "      <td>236.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>525</td>\n",
       "      <td>...</td>\n",
       "      <td>2783</td>\n",
       "      <td>2058</td>\n",
       "      <td>1621</td>\n",
       "      <td>1388</td>\n",
       "      <td>1116</td>\n",
       "      <td>683</td>\n",
       "      <td>THROGS NECK EXPRESSWAY</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5919</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>54334.0</td>\n",
       "      <td>459</td>\n",
       "      <td>293</td>\n",
       "      <td>284.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>606</td>\n",
       "      <td>...</td>\n",
       "      <td>2896</td>\n",
       "      <td>2648</td>\n",
       "      <td>2195</td>\n",
       "      <td>1802</td>\n",
       "      <td>1442</td>\n",
       "      <td>1248</td>\n",
       "      <td>THROGS NECK EXPRESSWAY</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5920</th>\n",
       "      <td>10/27/2012</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>3082.0</td>\n",
       "      <td>34</td>\n",
       "      <td>16</td>\n",
       "      <td>15.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>244</td>\n",
       "      <td>296</td>\n",
       "      <td>250</td>\n",
       "      <td>292</td>\n",
       "      <td>74</td>\n",
       "      <td>69</td>\n",
       "      <td>THROGS NECK EXPWY SER RD</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5921</th>\n",
       "      <td>10/28/2012</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>2517.0</td>\n",
       "      <td>28</td>\n",
       "      <td>23</td>\n",
       "      <td>19.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>187</td>\n",
       "      <td>82</td>\n",
       "      <td>99</td>\n",
       "      <td>61</td>\n",
       "      <td>44</td>\n",
       "      <td>31</td>\n",
       "      <td>THROGS NECK EXPWY SER RD</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5922</th>\n",
       "      <td>02/01/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1354.0</td>\n",
       "      <td>25</td>\n",
       "      <td>15</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>71</td>\n",
       "      <td>84</td>\n",
       "      <td>40</td>\n",
       "      <td>51</td>\n",
       "      <td>56</td>\n",
       "      <td>34</td>\n",
       "      <td>THROGS NECK EXPWY SER RD</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5923</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1092.0</td>\n",
       "      <td>51</td>\n",
       "      <td>21</td>\n",
       "      <td>29.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>94</td>\n",
       "      <td>75</td>\n",
       "      <td>44</td>\n",
       "      <td>51</td>\n",
       "      <td>58</td>\n",
       "      <td>72</td>\n",
       "      <td>THROGS NECK EXPWY SER RD</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5924</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1039.0</td>\n",
       "      <td>78</td>\n",
       "      <td>22</td>\n",
       "      <td>19.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>78</td>\n",
       "      <td>61</td>\n",
       "      <td>36</td>\n",
       "      <td>52</td>\n",
       "      <td>44</td>\n",
       "      <td>106</td>\n",
       "      <td>THROGS NECK EXPWY SER RD</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5925</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1442.0</td>\n",
       "      <td>115</td>\n",
       "      <td>28</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>83</td>\n",
       "      <td>57</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "      <td>47</td>\n",
       "      <td>22</td>\n",
       "      <td>THROGS NECK EXPWY SER RD</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5926</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1311.0</td>\n",
       "      <td>18</td>\n",
       "      <td>14</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>70</td>\n",
       "      <td>64</td>\n",
       "      <td>45</td>\n",
       "      <td>42</td>\n",
       "      <td>56</td>\n",
       "      <td>15</td>\n",
       "      <td>THROGS NECK EXPWY SER RD</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5927</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1334.0</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>73</td>\n",
       "      <td>72</td>\n",
       "      <td>55</td>\n",
       "      <td>55</td>\n",
       "      <td>61</td>\n",
       "      <td>24</td>\n",
       "      <td>THROGS NECK EXPWY SER RD</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5928</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1617.0</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>11.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>115</td>\n",
       "      <td>82</td>\n",
       "      <td>40</td>\n",
       "      <td>73</td>\n",
       "      <td>62</td>\n",
       "      <td>46</td>\n",
       "      <td>THROGS NECK EXPWY SER RD</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5929</th>\n",
       "      <td>10/27/2012</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>3165.0</td>\n",
       "      <td>32</td>\n",
       "      <td>27</td>\n",
       "      <td>19.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>314</td>\n",
       "      <td>284</td>\n",
       "      <td>253</td>\n",
       "      <td>290</td>\n",
       "      <td>80</td>\n",
       "      <td>54</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5930</th>\n",
       "      <td>10/28/2012</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>2437.0</td>\n",
       "      <td>38</td>\n",
       "      <td>29</td>\n",
       "      <td>26.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>173</td>\n",
       "      <td>64</td>\n",
       "      <td>79</td>\n",
       "      <td>59</td>\n",
       "      <td>59</td>\n",
       "      <td>34</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5931</th>\n",
       "      <td>02/01/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1721.0</td>\n",
       "      <td>16</td>\n",
       "      <td>20</td>\n",
       "      <td>10.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>124</td>\n",
       "      <td>97</td>\n",
       "      <td>85</td>\n",
       "      <td>70</td>\n",
       "      <td>84</td>\n",
       "      <td>42</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5932</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1412.0</td>\n",
       "      <td>31</td>\n",
       "      <td>24</td>\n",
       "      <td>20.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>88</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>65</td>\n",
       "      <td>61</td>\n",
       "      <td>62</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5933</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1257.0</td>\n",
       "      <td>34</td>\n",
       "      <td>36</td>\n",
       "      <td>32.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>90</td>\n",
       "      <td>55</td>\n",
       "      <td>42</td>\n",
       "      <td>40</td>\n",
       "      <td>35</td>\n",
       "      <td>63</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5934</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1377.0</td>\n",
       "      <td>23</td>\n",
       "      <td>17</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>98</td>\n",
       "      <td>82</td>\n",
       "      <td>73</td>\n",
       "      <td>54</td>\n",
       "      <td>52</td>\n",
       "      <td>23</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5935</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1476.0</td>\n",
       "      <td>18</td>\n",
       "      <td>11</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>128</td>\n",
       "      <td>91</td>\n",
       "      <td>73</td>\n",
       "      <td>56</td>\n",
       "      <td>51</td>\n",
       "      <td>41</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5936</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1513.0</td>\n",
       "      <td>27</td>\n",
       "      <td>9</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>126</td>\n",
       "      <td>103</td>\n",
       "      <td>89</td>\n",
       "      <td>76</td>\n",
       "      <td>60</td>\n",
       "      <td>25</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5937</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1587.0</td>\n",
       "      <td>18</td>\n",
       "      <td>14</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>120</td>\n",
       "      <td>110</td>\n",
       "      <td>70</td>\n",
       "      <td>84</td>\n",
       "      <td>69</td>\n",
       "      <td>30</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5938</th>\n",
       "      <td>02/01/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1663.0</td>\n",
       "      <td>8</td>\n",
       "      <td>14</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>97</td>\n",
       "      <td>91</td>\n",
       "      <td>72</td>\n",
       "      <td>47</td>\n",
       "      <td>53</td>\n",
       "      <td>37</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5939</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1344.0</td>\n",
       "      <td>19</td>\n",
       "      <td>14</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>84</td>\n",
       "      <td>69</td>\n",
       "      <td>69</td>\n",
       "      <td>50</td>\n",
       "      <td>41</td>\n",
       "      <td>47</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5940</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1120.0</td>\n",
       "      <td>11</td>\n",
       "      <td>17</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>65</td>\n",
       "      <td>47</td>\n",
       "      <td>45</td>\n",
       "      <td>44</td>\n",
       "      <td>29</td>\n",
       "      <td>111</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5941</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1263.0</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>71</td>\n",
       "      <td>64</td>\n",
       "      <td>45</td>\n",
       "      <td>24</td>\n",
       "      <td>21</td>\n",
       "      <td>25</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5942</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1340.0</td>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>88</td>\n",
       "      <td>68</td>\n",
       "      <td>73</td>\n",
       "      <td>30</td>\n",
       "      <td>21</td>\n",
       "      <td>31</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5943</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1403.0</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>109</td>\n",
       "      <td>64</td>\n",
       "      <td>50</td>\n",
       "      <td>41</td>\n",
       "      <td>58</td>\n",
       "      <td>17</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5944</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1474.0</td>\n",
       "      <td>20</td>\n",
       "      <td>11</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>100</td>\n",
       "      <td>68</td>\n",
       "      <td>61</td>\n",
       "      <td>48</td>\n",
       "      <td>34</td>\n",
       "      <td>29</td>\n",
       "      <td>E 177 ST</td>\n",
       "      <td>HARDING AVENUE</td>\n",
       "      <td>LONGSTREET AVENUE</td>\n",
       "      <td>377</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5945 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date    Weekday  Segment ID Direction  Total Traffic  \\\n",
       "0     02/02/2013   Saturday        2153        NB         5391.0   \n",
       "1     02/03/2013     Sunday        2153        NB         4085.0   \n",
       "2     02/04/2013     Monday        2153        NB         5867.0   \n",
       "3     02/05/2013    Tuesday        2153        NB         6172.0   \n",
       "4     02/06/2013  Wednesday        2153        NB         5597.0   \n",
       "5     02/07/2013   Thursday        2153        NB         5302.0   \n",
       "6     02/08/2013     Friday        2153        NB         6448.0   \n",
       "7     02/09/2013   Saturday        2153        NB         5504.0   \n",
       "8     02/10/2013     Sunday        2153        NB         4171.0   \n",
       "9     02/11/2013     Monday        2153        NB         5989.0   \n",
       "10    02/12/2013    Tuesday        2153        NB         6326.0   \n",
       "11    02/13/2013  Wednesday        2153        NB         5696.0   \n",
       "12    02/14/2013   Thursday        2153        NB         5338.0   \n",
       "13    02/02/2013   Saturday        2153        SB         5121.0   \n",
       "14    02/03/2013     Sunday        2153        SB         4056.0   \n",
       "15    02/04/2013     Monday        2153        SB         5546.0   \n",
       "16    02/05/2013    Tuesday        2153        SB         5784.0   \n",
       "17    02/06/2013  Wednesday        2153        SB         5389.0   \n",
       "18    02/07/2013   Thursday        2153        SB         5361.0   \n",
       "19    02/08/2013     Friday        2153        SB         5301.0   \n",
       "20    02/09/2013   Saturday        2153        SB         5173.0   \n",
       "21    02/10/2013     Sunday        2153        SB         4174.0   \n",
       "22    02/11/2013     Monday        2153        SB         5222.0   \n",
       "23    02/12/2013    Tuesday        2153        SB         3289.0   \n",
       "24    02/13/2013  Wednesday        2153        SB         3016.0   \n",
       "25    02/14/2013   Thursday        2153        SB         2911.0   \n",
       "26    09/29/2012   Saturday        6644        NB         7148.0   \n",
       "27    09/30/2012     Sunday        6644        NB         5166.0   \n",
       "28    10/01/2012     Monday        6644        NB         5774.0   \n",
       "29    10/02/2012    Tuesday        6644        NB         6337.0   \n",
       "...          ...        ...         ...       ...            ...   \n",
       "5915  02/03/2013     Sunday      179545        WB        34697.0   \n",
       "5916  02/04/2013     Monday      179545        WB        47502.0   \n",
       "5917  02/05/2013    Tuesday      179545        WB        46805.0   \n",
       "5918  02/06/2013  Wednesday      179545        WB        48843.0   \n",
       "5919  02/07/2013   Thursday      179545        WB        54334.0   \n",
       "5920  10/27/2012   Saturday      179547        WB         3082.0   \n",
       "5921  10/28/2012     Sunday      179547        WB         2517.0   \n",
       "5922  02/01/2013     Friday      179547       WB          1354.0   \n",
       "5923  02/02/2013   Saturday      179547       WB          1092.0   \n",
       "5924  02/03/2013     Sunday      179547       WB          1039.0   \n",
       "5925  02/04/2013     Monday      179547       WB          1442.0   \n",
       "5926  02/05/2013    Tuesday      179547       WB          1311.0   \n",
       "5927  02/06/2013  Wednesday      179547       WB          1334.0   \n",
       "5928  02/07/2013   Thursday      179547       WB          1617.0   \n",
       "5929  10/27/2012   Saturday      179545        EB         3165.0   \n",
       "5930  10/28/2012     Sunday      179545        EB         2437.0   \n",
       "5931  02/01/2013     Friday      179545       EB          1721.0   \n",
       "5932  02/02/2013   Saturday      179545       EB          1412.0   \n",
       "5933  02/03/2013     Sunday      179545       EB          1257.0   \n",
       "5934  02/04/2013     Monday      179545       EB          1377.0   \n",
       "5935  02/05/2013    Tuesday      179545       EB          1476.0   \n",
       "5936  02/06/2013  Wednesday      179545       EB          1513.0   \n",
       "5937  02/07/2013   Thursday      179545       EB          1587.0   \n",
       "5938  02/01/2013     Friday      179545        WB         1663.0   \n",
       "5939  02/02/2013   Saturday      179545        WB         1344.0   \n",
       "5940  02/03/2013     Sunday      179545        WB         1120.0   \n",
       "5941  02/04/2013     Monday      179545        WB         1263.0   \n",
       "5942  02/05/2013    Tuesday      179545        WB         1340.0   \n",
       "5943  02/06/2013  Wednesday      179545        WB         1403.0   \n",
       "5944  02/07/2013   Thursday      179545        WB         1474.0   \n",
       "\n",
       "      12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  4:00-5:00AM ...   \\\n",
       "0               106           74         45.0         29.0           29 ...    \n",
       "1               109           74         55.0         37.0           26 ...    \n",
       "2                36           28         11.0         16.0           32 ...    \n",
       "3                42           28         16.0         12.0           34 ...    \n",
       "4                35           38         12.0         14.0           31 ...    \n",
       "5                33           26         14.0         22.0           31 ...    \n",
       "6                35           28         18.0         14.0           34 ...    \n",
       "7               110           73         46.0         32.0           29 ...    \n",
       "8               114           77         58.0         40.0           28 ...    \n",
       "9                38           30         15.0         19.0           34 ...    \n",
       "10               43           32         20.0         15.0           36 ...    \n",
       "11               38           41         16.0         16.0           33 ...    \n",
       "12               37           29         18.0         23.0           33 ...    \n",
       "13              132           88         63.0         39.0           24 ...    \n",
       "14              126           89         72.0         42.0           43 ...    \n",
       "15               59           30         13.0         10.0           28 ...    \n",
       "16               62           27         11.0         10.0           25 ...    \n",
       "17               67           29         16.0         14.0           19 ...    \n",
       "18               49           30          8.0         23.0           26 ...    \n",
       "19               76           36         23.0         16.0           25 ...    \n",
       "20              121           60         62.0         35.0           19 ...    \n",
       "21              126           98         77.0         33.0           24 ...    \n",
       "22               23           15         11.0         23.0           64 ...    \n",
       "23               33           17          3.0         17.0           62 ...    \n",
       "24                6            7          1.0          9.0           33 ...    \n",
       "25               13            2          3.0         10.0           31 ...    \n",
       "26               89           40         33.0         32.0           31 ...    \n",
       "27               99           66         41.0         33.0           28 ...    \n",
       "28               51           35         24.0         18.0           35 ...    \n",
       "29               30           20         14.0         18.0           46 ...    \n",
       "...             ...          ...          ...          ...          ... ...    \n",
       "5915           1141          523        263.0        204.0          218 ...    \n",
       "5916            812          393        233.0        271.0          470 ...    \n",
       "5917            419          292        245.0        296.0          473 ...    \n",
       "5918            408          250        236.0        286.0          525 ...    \n",
       "5919            459          293        284.0        336.0          606 ...    \n",
       "5920             34           16         15.0         16.0            5 ...    \n",
       "5921             28           23         19.0         16.0           18 ...    \n",
       "5922             25           15          4.0         14.0           15 ...    \n",
       "5923             51           21         29.0          3.0           15 ...    \n",
       "5924             78           22         19.0         17.0            8 ...    \n",
       "5925            115           28          7.0          2.0           19 ...    \n",
       "5926             18           14          2.0          5.0           11 ...    \n",
       "5927             20           12          6.0          4.0           11 ...    \n",
       "5928             12           15         11.0          9.0           20 ...    \n",
       "5929             32           27         19.0         20.0            7 ...    \n",
       "5930             38           29         26.0         29.0           15 ...    \n",
       "5931             16           20         10.0         16.0            9 ...    \n",
       "5932             31           24         20.0          7.0           11 ...    \n",
       "5933             34           36         32.0         16.0            8 ...    \n",
       "5934             23           17          7.0          4.0            9 ...    \n",
       "5935             18           11          9.0          3.0            9 ...    \n",
       "5936             27            9          8.0          9.0            5 ...    \n",
       "5937             18           14          8.0          7.0            3 ...    \n",
       "5938              8           14          7.0          9.0           10 ...    \n",
       "5939             19           14         11.0          6.0            6 ...    \n",
       "5940             11           17         22.0          8.0            5 ...    \n",
       "5941             14           15          7.0          4.0            9 ...    \n",
       "5942             13            9          5.0          3.0            7 ...    \n",
       "5943             12            8          1.0          8.0            4 ...    \n",
       "5944             20           11          6.0          5.0            4 ...    \n",
       "\n",
       "      6:00-7:00PM  7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  \\\n",
       "0             379          329          249           197            187   \n",
       "1             242          217          210           144            125   \n",
       "2             425          358          224           185            132   \n",
       "3             446          424          305           219            171   \n",
       "4             401          338          236           186            123   \n",
       "5             356          339          275           225            169   \n",
       "6             531          393          351           276            242   \n",
       "7             387          336          254           201            191   \n",
       "8             246          221          214           147            121   \n",
       "9             433          365          228           189            136   \n",
       "10            454          433          312           223            175   \n",
       "11            409          345          240           190            126   \n",
       "12            394          354          247           200            151   \n",
       "13            336          272          228           199            190   \n",
       "14            255          254          210           138            101   \n",
       "15            390          358          251           194            132   \n",
       "16            434          387          301           212            146   \n",
       "17            426          306          253           176            127   \n",
       "18            367          369          283           185            155   \n",
       "19            418          387          264           211            178   \n",
       "20            340          311          258           186            171   \n",
       "21            275          208          171           139             97   \n",
       "22            355          272          175           149             69   \n",
       "23            221          134          114            54             27   \n",
       "24            220          135          107            67             37   \n",
       "25            230          171          130            92             56   \n",
       "26            492          358          221           164            145   \n",
       "27            231          190          139           110            104   \n",
       "28            436          291          203           137             93   \n",
       "29            418          330          212           140             94   \n",
       "...           ...          ...          ...           ...            ...   \n",
       "5915         2403         1570         1330          1577           1238   \n",
       "5916         2647         2001         1502          1286           1052   \n",
       "5917         2455         1828         1431          1254           1116   \n",
       "5918         2783         2058         1621          1388           1116   \n",
       "5919         2896         2648         2195          1802           1442   \n",
       "5920          244          296          250           292             74   \n",
       "5921          187           82           99            61             44   \n",
       "5922           71           84           40            51             56   \n",
       "5923           94           75           44            51             58   \n",
       "5924           78           61           36            52             44   \n",
       "5925           83           57           47            47             47   \n",
       "5926           70           64           45            42             56   \n",
       "5927           73           72           55            55             61   \n",
       "5928          115           82           40            73             62   \n",
       "5929          314          284          253           290             80   \n",
       "5930          173           64           79            59             59   \n",
       "5931          124           97           85            70             84   \n",
       "5932           88           77           75            65             61   \n",
       "5933           90           55           42            40             35   \n",
       "5934           98           82           73            54             52   \n",
       "5935          128           91           73            56             51   \n",
       "5936          126          103           89            76             60   \n",
       "5937          120          110           70            84             69   \n",
       "5938           97           91           72            47             53   \n",
       "5939           84           69           69            50             41   \n",
       "5940           65           47           45            44             29   \n",
       "5941           71           64           45            24             21   \n",
       "5942           88           68           73            30             21   \n",
       "5943          109           64           50            41             58   \n",
       "5944          100           68           61            48             34   \n",
       "\n",
       "      11:00-12:00AM              Roadway Name              From  \\\n",
       "0               169              HUGUENOT AVE        WOODROW RD   \n",
       "1                79              HUGUENOT AVE        WOODROW RD   \n",
       "2                74              HUGUENOT AVE        WOODROW RD   \n",
       "3                76              HUGUENOT AVE        WOODROW RD   \n",
       "4                76              HUGUENOT AVE        WOODROW RD   \n",
       "5               104              HUGUENOT AVE        WOODROW RD   \n",
       "6               154              HUGUENOT AVE        WOODROW RD   \n",
       "7               174              HUGUENOT AVE        WOODROW RD   \n",
       "8                85              HUGUENOT AVE        WOODROW RD   \n",
       "9                75              HUGUENOT AVE        WOODROW RD   \n",
       "10               97              HUGUENOT AVE        WOODROW RD   \n",
       "11               79              HUGUENOT AVE        WOODROW RD   \n",
       "12               97              HUGUENOT AVE        WOODROW RD   \n",
       "13              155              HUGUENOT AVE        WOODROW RD   \n",
       "14               89              HUGUENOT AVE        WOODROW RD   \n",
       "15               79              HUGUENOT AVE        WOODROW RD   \n",
       "16              101              HUGUENOT AVE        WOODROW RD   \n",
       "17               89              HUGUENOT AVE        WOODROW RD   \n",
       "18              146              HUGUENOT AVE        WOODROW RD   \n",
       "19              167              HUGUENOT AVE        WOODROW RD   \n",
       "20              191              HUGUENOT AVE        WOODROW RD   \n",
       "21               48              HUGUENOT AVE        WOODROW RD   \n",
       "22               54              HUGUENOT AVE        WOODROW RD   \n",
       "23               21              HUGUENOT AVE        WOODROW RD   \n",
       "24               19              HUGUENOT AVE        WOODROW RD   \n",
       "25               26              HUGUENOT AVE        WOODROW RD   \n",
       "26              130        RICHMOND HILL ROAD     EDINBORO ROAD   \n",
       "27               66        RICHMOND HILL ROAD     EDINBORO ROAD   \n",
       "28               55        RICHMOND HILL ROAD     EDINBORO ROAD   \n",
       "29               56        RICHMOND HILL ROAD     EDINBORO ROAD   \n",
       "...             ...                       ...               ...   \n",
       "5915           1011   THROGS NECK EXPRESSWAY    HARDING AVENUE    \n",
       "5916            677   THROGS NECK EXPRESSWAY    HARDING AVENUE    \n",
       "5917            703   THROGS NECK EXPRESSWAY    HARDING AVENUE    \n",
       "5918            683   THROGS NECK EXPRESSWAY    HARDING AVENUE    \n",
       "5919           1248   THROGS NECK EXPRESSWAY    HARDING AVENUE    \n",
       "5920             69  THROGS NECK EXPWY SER RD   HARDING AVENUE    \n",
       "5921             31  THROGS NECK EXPWY SER RD   HARDING AVENUE    \n",
       "5922             34  THROGS NECK EXPWY SER RD   HARDING AVENUE    \n",
       "5923             72  THROGS NECK EXPWY SER RD   HARDING AVENUE    \n",
       "5924            106  THROGS NECK EXPWY SER RD   HARDING AVENUE    \n",
       "5925             22  THROGS NECK EXPWY SER RD   HARDING AVENUE    \n",
       "5926             15  THROGS NECK EXPWY SER RD   HARDING AVENUE    \n",
       "5927             24  THROGS NECK EXPWY SER RD   HARDING AVENUE    \n",
       "5928             46  THROGS NECK EXPWY SER RD   HARDING AVENUE    \n",
       "5929             54                  E 177 ST   HARDING AVENUE    \n",
       "5930             34                  E 177 ST   HARDING AVENUE    \n",
       "5931             42                  E 177 ST   HARDING AVENUE    \n",
       "5932             62                  E 177 ST   HARDING AVENUE    \n",
       "5933             63                  E 177 ST   HARDING AVENUE    \n",
       "5934             23                  E 177 ST   HARDING AVENUE    \n",
       "5935             41                  E 177 ST   HARDING AVENUE    \n",
       "5936             25                  E 177 ST   HARDING AVENUE    \n",
       "5937             30                  E 177 ST   HARDING AVENUE    \n",
       "5938             37                  E 177 ST   HARDING AVENUE    \n",
       "5939             47                  E 177 ST   HARDING AVENUE    \n",
       "5940            111                  E 177 ST   HARDING AVENUE    \n",
       "5941             25                  E 177 ST   HARDING AVENUE    \n",
       "5942             31                  E 177 ST   HARDING AVENUE    \n",
       "5943             17                  E 177 ST   HARDING AVENUE    \n",
       "5944             29                  E 177 ST   HARDING AVENUE    \n",
       "\n",
       "                       To   ID  \n",
       "0            STAFFORD AVE    1  \n",
       "1            STAFFORD AVE    1  \n",
       "2            STAFFORD AVE    1  \n",
       "3            STAFFORD AVE    1  \n",
       "4            STAFFORD AVE    1  \n",
       "5            STAFFORD AVE    1  \n",
       "6            STAFFORD AVE    1  \n",
       "7            STAFFORD AVE    1  \n",
       "8            STAFFORD AVE    1  \n",
       "9            STAFFORD AVE    1  \n",
       "10           STAFFORD AVE    1  \n",
       "11           STAFFORD AVE    1  \n",
       "12           STAFFORD AVE    1  \n",
       "13           STAFFORD AVE    1  \n",
       "14           STAFFORD AVE    1  \n",
       "15           STAFFORD AVE    1  \n",
       "16           STAFFORD AVE    1  \n",
       "17           STAFFORD AVE    1  \n",
       "18           STAFFORD AVE    1  \n",
       "19           STAFFORD AVE    1  \n",
       "20           STAFFORD AVE    1  \n",
       "21           STAFFORD AVE    1  \n",
       "22           STAFFORD AVE    1  \n",
       "23           STAFFORD AVE    1  \n",
       "24           STAFFORD AVE    1  \n",
       "25           STAFFORD AVE    1  \n",
       "26       FOREST HILL ROAD    2  \n",
       "27       FOREST HILL ROAD    2  \n",
       "28       FOREST HILL ROAD    2  \n",
       "29       FOREST HILL ROAD    2  \n",
       "...                   ...  ...  \n",
       "5915   LONGSTREET AVENUE   375  \n",
       "5916   LONGSTREET AVENUE   375  \n",
       "5917   LONGSTREET AVENUE   375  \n",
       "5918   LONGSTREET AVENUE   375  \n",
       "5919   LONGSTREET AVENUE   375  \n",
       "5920   LONGSTREET AVENUE   376  \n",
       "5921   LONGSTREET AVENUE   376  \n",
       "5922   LONGSTREET AVENUE   376  \n",
       "5923   LONGSTREET AVENUE   376  \n",
       "5924   LONGSTREET AVENUE   376  \n",
       "5925   LONGSTREET AVENUE   376  \n",
       "5926   LONGSTREET AVENUE   376  \n",
       "5927   LONGSTREET AVENUE   376  \n",
       "5928   LONGSTREET AVENUE   376  \n",
       "5929   LONGSTREET AVENUE   377  \n",
       "5930   LONGSTREET AVENUE   377  \n",
       "5931   LONGSTREET AVENUE   377  \n",
       "5932   LONGSTREET AVENUE   377  \n",
       "5933   LONGSTREET AVENUE   377  \n",
       "5934   LONGSTREET AVENUE   377  \n",
       "5935   LONGSTREET AVENUE   377  \n",
       "5936   LONGSTREET AVENUE   377  \n",
       "5937   LONGSTREET AVENUE   377  \n",
       "5938   LONGSTREET AVENUE   377  \n",
       "5939   LONGSTREET AVENUE   377  \n",
       "5940   LONGSTREET AVENUE   377  \n",
       "5941   LONGSTREET AVENUE   377  \n",
       "5942   LONGSTREET AVENUE   377  \n",
       "5943   LONGSTREET AVENUE   377  \n",
       "5944   LONGSTREET AVENUE   377  \n",
       "\n",
       "[5945 rows x 33 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#df_change will be the hourly increase/decrease of traffic in % each day.The first hour will be based on the \n",
    "#previous day's traffic if it exists.\n",
    "df2 = df1.copy()\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "del df2['Roadway Name']\n",
    "del df2['From']\n",
    "del df2['To']\n",
    "del df2['ID']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5945"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#find the percentile change in traffic between every hour\n",
    "#loop through each row and the before and after midnight times\n",
    "#perform the calculation and save to df2 for non-zero values, changes of traffic from and value to 0 cant be determined\n",
    "\n",
    "for i in range(len(df1)):\n",
    "    for j in range(5,28):\n",
    "        x = df1.iloc[i,j]\n",
    "        y = df1.iloc[i,j+1]\n",
    "        if x>0:\n",
    "            z = 100*(y-x)/x\n",
    "            df2.iloc[i,j+1] = z\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#find the percentile change in traffic during midnight between 2 days\n",
    "#loop through each row and the before and after midnight times\n",
    "#if the 2 times are of the same segment, then perform the calculation and save to df2\n",
    "\n",
    "for i in range(len(df1)-1):\n",
    "    if df1.iloc[i,2] == df1.iloc[i+1,2]:\n",
    "        if df1.iloc[i,3] == df1.iloc[i+1,3]:\n",
    "            x = df1.iloc[i,28]\n",
    "            y = df1.iloc[i+1,5]\n",
    "            if x>0:\n",
    "                z = 100*(y-x)/x\n",
    "                df2.iloc[i+1,5] = z"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>Date</th>\n",
       "      <th>Weekday</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Total Traffic</th>\n",
       "      <th>12:00-1:00 AM</th>\n",
       "      <th>1:00-2:00AM</th>\n",
       "      <th>2:00-3:00AM</th>\n",
       "      <th>3:00-4:00AM</th>\n",
       "      <th>4:00-5:00AM</th>\n",
       "      <th>...</th>\n",
       "      <th>2:00-3:00PM</th>\n",
       "      <th>3:00-4:00PM</th>\n",
       "      <th>4:00-5:00PM</th>\n",
       "      <th>5:00-6:00PM</th>\n",
       "      <th>6:00-7:00PM</th>\n",
       "      <th>7:00-8:00PM</th>\n",
       "      <th>8:00-9:00PM</th>\n",
       "      <th>9:00-10:00PM</th>\n",
       "      <th>10:00-11:00PM</th>\n",
       "      <th>11:00-12:00AM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5391.0</td>\n",
       "      <td>106.000000</td>\n",
       "      <td>-30.188679</td>\n",
       "      <td>-39.189189</td>\n",
       "      <td>-35.555556</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-9.732360</td>\n",
       "      <td>7.277628</td>\n",
       "      <td>-18.592965</td>\n",
       "      <td>21.604938</td>\n",
       "      <td>-3.807107</td>\n",
       "      <td>-13.192612</td>\n",
       "      <td>-24.316109</td>\n",
       "      <td>-20.883534</td>\n",
       "      <td>-5.076142</td>\n",
       "      <td>-9.625668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>4085.0</td>\n",
       "      <td>-35.502959</td>\n",
       "      <td>-32.110092</td>\n",
       "      <td>-25.675676</td>\n",
       "      <td>-32.727273</td>\n",
       "      <td>-29.729730</td>\n",
       "      <td>...</td>\n",
       "      <td>-12.000000</td>\n",
       "      <td>-5.519481</td>\n",
       "      <td>7.560137</td>\n",
       "      <td>-19.169329</td>\n",
       "      <td>-4.347826</td>\n",
       "      <td>-10.330579</td>\n",
       "      <td>-3.225806</td>\n",
       "      <td>-31.428571</td>\n",
       "      <td>-13.194444</td>\n",
       "      <td>-36.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5867.0</td>\n",
       "      <td>-54.430380</td>\n",
       "      <td>-22.222222</td>\n",
       "      <td>-60.714286</td>\n",
       "      <td>45.454545</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>29.878049</td>\n",
       "      <td>-0.234742</td>\n",
       "      <td>-1.411765</td>\n",
       "      <td>11.933174</td>\n",
       "      <td>-9.381663</td>\n",
       "      <td>-15.764706</td>\n",
       "      <td>-37.430168</td>\n",
       "      <td>-17.410714</td>\n",
       "      <td>-28.648649</td>\n",
       "      <td>-43.939394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>6172.0</td>\n",
       "      <td>-43.243243</td>\n",
       "      <td>-33.333333</td>\n",
       "      <td>-42.857143</td>\n",
       "      <td>-25.000000</td>\n",
       "      <td>183.333333</td>\n",
       "      <td>...</td>\n",
       "      <td>2.879581</td>\n",
       "      <td>21.882952</td>\n",
       "      <td>-7.933194</td>\n",
       "      <td>7.936508</td>\n",
       "      <td>-6.302521</td>\n",
       "      <td>-4.932735</td>\n",
       "      <td>-28.066038</td>\n",
       "      <td>-28.196721</td>\n",
       "      <td>-21.917808</td>\n",
       "      <td>-55.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5597.0</td>\n",
       "      <td>-53.947368</td>\n",
       "      <td>8.571429</td>\n",
       "      <td>-68.421053</td>\n",
       "      <td>16.666667</td>\n",
       "      <td>121.428571</td>\n",
       "      <td>...</td>\n",
       "      <td>18.209877</td>\n",
       "      <td>0.261097</td>\n",
       "      <td>1.822917</td>\n",
       "      <td>-5.626598</td>\n",
       "      <td>8.672087</td>\n",
       "      <td>-15.710723</td>\n",
       "      <td>-30.177515</td>\n",
       "      <td>-21.186441</td>\n",
       "      <td>-33.870968</td>\n",
       "      <td>-38.211382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5302.0</td>\n",
       "      <td>-56.578947</td>\n",
       "      <td>-21.212121</td>\n",
       "      <td>-46.153846</td>\n",
       "      <td>57.142857</td>\n",
       "      <td>40.909091</td>\n",
       "      <td>...</td>\n",
       "      <td>-50.165017</td>\n",
       "      <td>170.860927</td>\n",
       "      <td>3.178484</td>\n",
       "      <td>-13.744076</td>\n",
       "      <td>-2.197802</td>\n",
       "      <td>-4.775281</td>\n",
       "      <td>-18.879056</td>\n",
       "      <td>-18.181818</td>\n",
       "      <td>-24.888889</td>\n",
       "      <td>-38.461538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>02/08/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>6448.0</td>\n",
       "      <td>-66.346154</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-35.714286</td>\n",
       "      <td>-22.222222</td>\n",
       "      <td>142.857143</td>\n",
       "      <td>...</td>\n",
       "      <td>21.813031</td>\n",
       "      <td>20.465116</td>\n",
       "      <td>-11.003861</td>\n",
       "      <td>5.206074</td>\n",
       "      <td>9.484536</td>\n",
       "      <td>-25.988701</td>\n",
       "      <td>-10.687023</td>\n",
       "      <td>-21.367521</td>\n",
       "      <td>-12.318841</td>\n",
       "      <td>-36.363636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>02/09/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5504.0</td>\n",
       "      <td>-28.571429</td>\n",
       "      <td>-33.636364</td>\n",
       "      <td>-36.986301</td>\n",
       "      <td>-30.434783</td>\n",
       "      <td>-9.375000</td>\n",
       "      <td>...</td>\n",
       "      <td>-9.546539</td>\n",
       "      <td>7.124011</td>\n",
       "      <td>-18.719212</td>\n",
       "      <td>21.818182</td>\n",
       "      <td>-3.731343</td>\n",
       "      <td>-13.178295</td>\n",
       "      <td>-24.404762</td>\n",
       "      <td>-20.866142</td>\n",
       "      <td>-4.975124</td>\n",
       "      <td>-8.900524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>02/10/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>4171.0</td>\n",
       "      <td>-34.482759</td>\n",
       "      <td>-32.456140</td>\n",
       "      <td>-24.675325</td>\n",
       "      <td>-31.034483</td>\n",
       "      <td>-30.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-11.516854</td>\n",
       "      <td>-5.714286</td>\n",
       "      <td>7.744108</td>\n",
       "      <td>-19.687500</td>\n",
       "      <td>-4.280156</td>\n",
       "      <td>-10.162602</td>\n",
       "      <td>-3.167421</td>\n",
       "      <td>-31.308411</td>\n",
       "      <td>-17.687075</td>\n",
       "      <td>-29.752066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>02/11/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5989.0</td>\n",
       "      <td>-55.294118</td>\n",
       "      <td>-21.052632</td>\n",
       "      <td>-50.000000</td>\n",
       "      <td>26.666667</td>\n",
       "      <td>78.947368</td>\n",
       "      <td>...</td>\n",
       "      <td>35.202492</td>\n",
       "      <td>-0.230415</td>\n",
       "      <td>1.154734</td>\n",
       "      <td>9.132420</td>\n",
       "      <td>-9.414226</td>\n",
       "      <td>-15.704388</td>\n",
       "      <td>-37.534247</td>\n",
       "      <td>-17.105263</td>\n",
       "      <td>-28.042328</td>\n",
       "      <td>-44.852941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>02/12/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>6326.0</td>\n",
       "      <td>-42.666667</td>\n",
       "      <td>-25.581395</td>\n",
       "      <td>-37.500000</td>\n",
       "      <td>-25.000000</td>\n",
       "      <td>140.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>2.820513</td>\n",
       "      <td>21.695761</td>\n",
       "      <td>-7.786885</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>-6.584362</td>\n",
       "      <td>-4.625551</td>\n",
       "      <td>-27.944573</td>\n",
       "      <td>-28.525641</td>\n",
       "      <td>-21.524664</td>\n",
       "      <td>-44.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>02/13/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5696.0</td>\n",
       "      <td>-60.824742</td>\n",
       "      <td>7.894737</td>\n",
       "      <td>-60.975610</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>106.250000</td>\n",
       "      <td>...</td>\n",
       "      <td>18.126888</td>\n",
       "      <td>0.255754</td>\n",
       "      <td>1.785714</td>\n",
       "      <td>-5.513784</td>\n",
       "      <td>8.488064</td>\n",
       "      <td>-15.647922</td>\n",
       "      <td>-30.434783</td>\n",
       "      <td>-20.833333</td>\n",
       "      <td>-33.684211</td>\n",
       "      <td>-37.301587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>02/14/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2153</td>\n",
       "      <td>NB</td>\n",
       "      <td>5338.0</td>\n",
       "      <td>-53.164557</td>\n",
       "      <td>-21.621622</td>\n",
       "      <td>-37.931034</td>\n",
       "      <td>27.777778</td>\n",
       "      <td>43.478261</td>\n",
       "      <td>...</td>\n",
       "      <td>-50.161812</td>\n",
       "      <td>170.779221</td>\n",
       "      <td>-2.877698</td>\n",
       "      <td>-7.654321</td>\n",
       "      <td>5.347594</td>\n",
       "      <td>-10.152284</td>\n",
       "      <td>-30.225989</td>\n",
       "      <td>-19.028340</td>\n",
       "      <td>-24.500000</td>\n",
       "      <td>-35.761589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5121.0</td>\n",
       "      <td>132.000000</td>\n",
       "      <td>-33.333333</td>\n",
       "      <td>-28.409091</td>\n",
       "      <td>-38.095238</td>\n",
       "      <td>-38.461538</td>\n",
       "      <td>...</td>\n",
       "      <td>0.789474</td>\n",
       "      <td>6.005222</td>\n",
       "      <td>-16.009852</td>\n",
       "      <td>0.293255</td>\n",
       "      <td>-1.754386</td>\n",
       "      <td>-19.047619</td>\n",
       "      <td>-16.176471</td>\n",
       "      <td>-12.719298</td>\n",
       "      <td>-4.522613</td>\n",
       "      <td>-18.421053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>4056.0</td>\n",
       "      <td>-18.709677</td>\n",
       "      <td>-29.365079</td>\n",
       "      <td>-19.101124</td>\n",
       "      <td>-41.666667</td>\n",
       "      <td>2.380952</td>\n",
       "      <td>...</td>\n",
       "      <td>0.928793</td>\n",
       "      <td>-5.521472</td>\n",
       "      <td>1.948052</td>\n",
       "      <td>-11.464968</td>\n",
       "      <td>-8.273381</td>\n",
       "      <td>-0.392157</td>\n",
       "      <td>-17.322835</td>\n",
       "      <td>-34.285714</td>\n",
       "      <td>-26.811594</td>\n",
       "      <td>-11.881188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5546.0</td>\n",
       "      <td>-33.707865</td>\n",
       "      <td>-49.152542</td>\n",
       "      <td>-56.666667</td>\n",
       "      <td>-23.076923</td>\n",
       "      <td>180.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>22.402597</td>\n",
       "      <td>12.732095</td>\n",
       "      <td>1.411765</td>\n",
       "      <td>-5.104408</td>\n",
       "      <td>-4.645477</td>\n",
       "      <td>-8.205128</td>\n",
       "      <td>-29.888268</td>\n",
       "      <td>-22.709163</td>\n",
       "      <td>-31.958763</td>\n",
       "      <td>-40.151515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5784.0</td>\n",
       "      <td>-21.518987</td>\n",
       "      <td>-56.451613</td>\n",
       "      <td>-59.259259</td>\n",
       "      <td>-9.090909</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>51.908397</td>\n",
       "      <td>22.613065</td>\n",
       "      <td>-6.967213</td>\n",
       "      <td>-0.220264</td>\n",
       "      <td>-4.194260</td>\n",
       "      <td>-10.829493</td>\n",
       "      <td>-22.222222</td>\n",
       "      <td>-29.568106</td>\n",
       "      <td>-31.132075</td>\n",
       "      <td>-30.821918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5389.0</td>\n",
       "      <td>-33.663366</td>\n",
       "      <td>-56.716418</td>\n",
       "      <td>-44.827586</td>\n",
       "      <td>-12.500000</td>\n",
       "      <td>35.714286</td>\n",
       "      <td>...</td>\n",
       "      <td>45.559846</td>\n",
       "      <td>13.527851</td>\n",
       "      <td>2.336449</td>\n",
       "      <td>-10.730594</td>\n",
       "      <td>8.951407</td>\n",
       "      <td>-28.169014</td>\n",
       "      <td>-17.320261</td>\n",
       "      <td>-30.434783</td>\n",
       "      <td>-27.840909</td>\n",
       "      <td>-29.921260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5361.0</td>\n",
       "      <td>-44.943820</td>\n",
       "      <td>-38.775510</td>\n",
       "      <td>-73.333333</td>\n",
       "      <td>187.500000</td>\n",
       "      <td>13.043478</td>\n",
       "      <td>...</td>\n",
       "      <td>42.338710</td>\n",
       "      <td>22.379603</td>\n",
       "      <td>-18.518519</td>\n",
       "      <td>17.045455</td>\n",
       "      <td>-10.922330</td>\n",
       "      <td>0.544959</td>\n",
       "      <td>-23.306233</td>\n",
       "      <td>-34.628975</td>\n",
       "      <td>-16.216216</td>\n",
       "      <td>-5.806452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>02/08/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5301.0</td>\n",
       "      <td>-47.945205</td>\n",
       "      <td>-52.631579</td>\n",
       "      <td>-36.111111</td>\n",
       "      <td>-30.434783</td>\n",
       "      <td>56.250000</td>\n",
       "      <td>...</td>\n",
       "      <td>57.939914</td>\n",
       "      <td>-1.086957</td>\n",
       "      <td>4.120879</td>\n",
       "      <td>-3.693931</td>\n",
       "      <td>14.520548</td>\n",
       "      <td>-7.416268</td>\n",
       "      <td>-31.782946</td>\n",
       "      <td>-20.075758</td>\n",
       "      <td>-15.639810</td>\n",
       "      <td>-6.179775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>02/09/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5173.0</td>\n",
       "      <td>-27.544910</td>\n",
       "      <td>-50.413223</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>-43.548387</td>\n",
       "      <td>-45.714286</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.264550</td>\n",
       "      <td>24.403183</td>\n",
       "      <td>-23.454158</td>\n",
       "      <td>-8.077994</td>\n",
       "      <td>3.030303</td>\n",
       "      <td>-8.529412</td>\n",
       "      <td>-17.041801</td>\n",
       "      <td>-27.906977</td>\n",
       "      <td>-8.064516</td>\n",
       "      <td>11.695906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>02/10/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>4174.0</td>\n",
       "      <td>-34.031414</td>\n",
       "      <td>-22.222222</td>\n",
       "      <td>-21.428571</td>\n",
       "      <td>-57.142857</td>\n",
       "      <td>-27.272727</td>\n",
       "      <td>...</td>\n",
       "      <td>-26.777251</td>\n",
       "      <td>3.236246</td>\n",
       "      <td>-4.075235</td>\n",
       "      <td>-7.189542</td>\n",
       "      <td>-3.169014</td>\n",
       "      <td>-24.363636</td>\n",
       "      <td>-17.788462</td>\n",
       "      <td>-18.713450</td>\n",
       "      <td>-30.215827</td>\n",
       "      <td>-50.515464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>02/11/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>5222.0</td>\n",
       "      <td>-52.083333</td>\n",
       "      <td>-34.782609</td>\n",
       "      <td>-26.666667</td>\n",
       "      <td>109.090909</td>\n",
       "      <td>178.260870</td>\n",
       "      <td>...</td>\n",
       "      <td>-11.051213</td>\n",
       "      <td>28.181818</td>\n",
       "      <td>-16.312057</td>\n",
       "      <td>2.259887</td>\n",
       "      <td>-1.933702</td>\n",
       "      <td>-23.380282</td>\n",
       "      <td>-35.661765</td>\n",
       "      <td>-14.857143</td>\n",
       "      <td>-53.691275</td>\n",
       "      <td>-21.739130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>02/12/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>3289.0</td>\n",
       "      <td>-38.888889</td>\n",
       "      <td>-48.484848</td>\n",
       "      <td>-82.352941</td>\n",
       "      <td>466.666667</td>\n",
       "      <td>264.705882</td>\n",
       "      <td>...</td>\n",
       "      <td>144.954128</td>\n",
       "      <td>-23.220974</td>\n",
       "      <td>19.024390</td>\n",
       "      <td>-29.508197</td>\n",
       "      <td>28.488372</td>\n",
       "      <td>-39.366516</td>\n",
       "      <td>-14.925373</td>\n",
       "      <td>-52.631579</td>\n",
       "      <td>-50.000000</td>\n",
       "      <td>-22.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>02/13/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>3016.0</td>\n",
       "      <td>-71.428571</td>\n",
       "      <td>16.666667</td>\n",
       "      <td>-85.714286</td>\n",
       "      <td>800.000000</td>\n",
       "      <td>266.666667</td>\n",
       "      <td>...</td>\n",
       "      <td>27.127660</td>\n",
       "      <td>5.439331</td>\n",
       "      <td>10.317460</td>\n",
       "      <td>-1.079137</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-38.636364</td>\n",
       "      <td>-20.740741</td>\n",
       "      <td>-37.383178</td>\n",
       "      <td>-44.776119</td>\n",
       "      <td>-48.648649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>02/14/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2153</td>\n",
       "      <td>SB</td>\n",
       "      <td>2911.0</td>\n",
       "      <td>-31.578947</td>\n",
       "      <td>-84.615385</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>233.333333</td>\n",
       "      <td>210.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>106.923077</td>\n",
       "      <td>-7.806691</td>\n",
       "      <td>8.870968</td>\n",
       "      <td>-8.518519</td>\n",
       "      <td>-6.882591</td>\n",
       "      <td>-25.652174</td>\n",
       "      <td>-23.976608</td>\n",
       "      <td>-29.230769</td>\n",
       "      <td>-39.130435</td>\n",
       "      <td>-53.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>09/29/2012</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>6644</td>\n",
       "      <td>NB</td>\n",
       "      <td>7148.0</td>\n",
       "      <td>89.000000</td>\n",
       "      <td>-55.056180</td>\n",
       "      <td>-17.500000</td>\n",
       "      <td>-3.030303</td>\n",
       "      <td>-3.125000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.497512</td>\n",
       "      <td>-17.326733</td>\n",
       "      <td>7.584830</td>\n",
       "      <td>-6.679035</td>\n",
       "      <td>-2.186879</td>\n",
       "      <td>-27.235772</td>\n",
       "      <td>-38.268156</td>\n",
       "      <td>-25.791855</td>\n",
       "      <td>-11.585366</td>\n",
       "      <td>-10.344828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>09/30/2012</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>6644</td>\n",
       "      <td>NB</td>\n",
       "      <td>5166.0</td>\n",
       "      <td>-23.846154</td>\n",
       "      <td>-33.333333</td>\n",
       "      <td>-37.878788</td>\n",
       "      <td>-19.512195</td>\n",
       "      <td>-15.151515</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.348337</td>\n",
       "      <td>-14.028056</td>\n",
       "      <td>-17.715618</td>\n",
       "      <td>-14.730878</td>\n",
       "      <td>-23.255814</td>\n",
       "      <td>-17.748918</td>\n",
       "      <td>-26.842105</td>\n",
       "      <td>-20.863309</td>\n",
       "      <td>-5.454545</td>\n",
       "      <td>-36.538462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>10/01/2012</td>\n",
       "      <td>Monday</td>\n",
       "      <td>6644</td>\n",
       "      <td>NB</td>\n",
       "      <td>5774.0</td>\n",
       "      <td>-22.727273</td>\n",
       "      <td>-31.372549</td>\n",
       "      <td>-31.428571</td>\n",
       "      <td>-25.000000</td>\n",
       "      <td>94.444444</td>\n",
       "      <td>...</td>\n",
       "      <td>19.676550</td>\n",
       "      <td>8.558559</td>\n",
       "      <td>-8.713693</td>\n",
       "      <td>-5.454545</td>\n",
       "      <td>4.807692</td>\n",
       "      <td>-33.256881</td>\n",
       "      <td>-30.240550</td>\n",
       "      <td>-32.512315</td>\n",
       "      <td>-32.116788</td>\n",
       "      <td>-40.860215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>10/02/2012</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>6644</td>\n",
       "      <td>NB</td>\n",
       "      <td>6337.0</td>\n",
       "      <td>-45.454545</td>\n",
       "      <td>-33.333333</td>\n",
       "      <td>-30.000000</td>\n",
       "      <td>28.571429</td>\n",
       "      <td>155.555556</td>\n",
       "      <td>...</td>\n",
       "      <td>21.388889</td>\n",
       "      <td>12.356979</td>\n",
       "      <td>-7.942974</td>\n",
       "      <td>-7.964602</td>\n",
       "      <td>0.480769</td>\n",
       "      <td>-21.052632</td>\n",
       "      <td>-35.757576</td>\n",
       "      <td>-33.962264</td>\n",
       "      <td>-32.857143</td>\n",
       "      <td>-40.425532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5915</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>34697.0</td>\n",
       "      <td>-17.557803</td>\n",
       "      <td>-54.163015</td>\n",
       "      <td>-49.713193</td>\n",
       "      <td>-22.433460</td>\n",
       "      <td>6.862745</td>\n",
       "      <td>...</td>\n",
       "      <td>2.641056</td>\n",
       "      <td>1.793372</td>\n",
       "      <td>14.017618</td>\n",
       "      <td>2.653678</td>\n",
       "      <td>-21.367801</td>\n",
       "      <td>-34.665002</td>\n",
       "      <td>-15.286624</td>\n",
       "      <td>18.571429</td>\n",
       "      <td>-21.496512</td>\n",
       "      <td>-18.336026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5916</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>47502.0</td>\n",
       "      <td>-19.683482</td>\n",
       "      <td>-51.600985</td>\n",
       "      <td>-40.712468</td>\n",
       "      <td>16.309013</td>\n",
       "      <td>73.431734</td>\n",
       "      <td>...</td>\n",
       "      <td>8.208955</td>\n",
       "      <td>2.112069</td>\n",
       "      <td>8.864500</td>\n",
       "      <td>-0.116324</td>\n",
       "      <td>2.756211</td>\n",
       "      <td>-24.404987</td>\n",
       "      <td>-24.937531</td>\n",
       "      <td>-14.380826</td>\n",
       "      <td>-18.195956</td>\n",
       "      <td>-35.646388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5917</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>46805.0</td>\n",
       "      <td>-38.109306</td>\n",
       "      <td>-30.310263</td>\n",
       "      <td>-16.095890</td>\n",
       "      <td>20.816327</td>\n",
       "      <td>59.797297</td>\n",
       "      <td>...</td>\n",
       "      <td>8.489681</td>\n",
       "      <td>10.678772</td>\n",
       "      <td>5.820312</td>\n",
       "      <td>-1.734958</td>\n",
       "      <td>-7.776108</td>\n",
       "      <td>-25.539715</td>\n",
       "      <td>-21.717724</td>\n",
       "      <td>-12.368973</td>\n",
       "      <td>-11.004785</td>\n",
       "      <td>-37.007168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5918</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>48843.0</td>\n",
       "      <td>-41.963016</td>\n",
       "      <td>-38.725490</td>\n",
       "      <td>-5.600000</td>\n",
       "      <td>21.186441</td>\n",
       "      <td>83.566434</td>\n",
       "      <td>...</td>\n",
       "      <td>10.933941</td>\n",
       "      <td>2.422998</td>\n",
       "      <td>8.781075</td>\n",
       "      <td>1.916697</td>\n",
       "      <td>0.650995</td>\n",
       "      <td>-26.051024</td>\n",
       "      <td>-21.234208</td>\n",
       "      <td>-14.373843</td>\n",
       "      <td>-19.596542</td>\n",
       "      <td>-38.799283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5919</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>54334.0</td>\n",
       "      <td>-32.796486</td>\n",
       "      <td>-36.165577</td>\n",
       "      <td>-3.071672</td>\n",
       "      <td>18.309859</td>\n",
       "      <td>80.357143</td>\n",
       "      <td>...</td>\n",
       "      <td>10.914928</td>\n",
       "      <td>3.002894</td>\n",
       "      <td>8.535300</td>\n",
       "      <td>-7.087379</td>\n",
       "      <td>0.870777</td>\n",
       "      <td>-8.563536</td>\n",
       "      <td>-17.107251</td>\n",
       "      <td>-17.904328</td>\n",
       "      <td>-19.977802</td>\n",
       "      <td>-13.453537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5920</th>\n",
       "      <td>10/27/2012</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>3082.0</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>-52.941176</td>\n",
       "      <td>-6.250000</td>\n",
       "      <td>6.666667</td>\n",
       "      <td>-68.750000</td>\n",
       "      <td>...</td>\n",
       "      <td>40.476190</td>\n",
       "      <td>57.062147</td>\n",
       "      <td>16.546763</td>\n",
       "      <td>8.024691</td>\n",
       "      <td>-30.285714</td>\n",
       "      <td>21.311475</td>\n",
       "      <td>-15.540541</td>\n",
       "      <td>16.800000</td>\n",
       "      <td>-74.657534</td>\n",
       "      <td>-6.756757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5921</th>\n",
       "      <td>10/28/2012</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>2517.0</td>\n",
       "      <td>-59.420290</td>\n",
       "      <td>-17.857143</td>\n",
       "      <td>-17.391304</td>\n",
       "      <td>-15.789474</td>\n",
       "      <td>12.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>41.081081</td>\n",
       "      <td>-11.877395</td>\n",
       "      <td>28.260870</td>\n",
       "      <td>-16.610169</td>\n",
       "      <td>-23.983740</td>\n",
       "      <td>-56.149733</td>\n",
       "      <td>20.731707</td>\n",
       "      <td>-38.383838</td>\n",
       "      <td>-27.868852</td>\n",
       "      <td>-29.545455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5922</th>\n",
       "      <td>02/01/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1354.0</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>-40.000000</td>\n",
       "      <td>-73.333333</td>\n",
       "      <td>250.000000</td>\n",
       "      <td>7.142857</td>\n",
       "      <td>...</td>\n",
       "      <td>33.846154</td>\n",
       "      <td>-6.896552</td>\n",
       "      <td>37.037037</td>\n",
       "      <td>-26.126126</td>\n",
       "      <td>-13.414634</td>\n",
       "      <td>18.309859</td>\n",
       "      <td>-52.380952</td>\n",
       "      <td>27.500000</td>\n",
       "      <td>9.803922</td>\n",
       "      <td>-39.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5923</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1092.0</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>-58.823529</td>\n",
       "      <td>38.095238</td>\n",
       "      <td>-89.655172</td>\n",
       "      <td>400.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>36.206897</td>\n",
       "      <td>-7.594937</td>\n",
       "      <td>1.369863</td>\n",
       "      <td>-1.351351</td>\n",
       "      <td>28.767123</td>\n",
       "      <td>-20.212766</td>\n",
       "      <td>-41.333333</td>\n",
       "      <td>15.909091</td>\n",
       "      <td>13.725490</td>\n",
       "      <td>24.137931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5924</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1039.0</td>\n",
       "      <td>8.333333</td>\n",
       "      <td>-71.794872</td>\n",
       "      <td>-13.636364</td>\n",
       "      <td>-10.526316</td>\n",
       "      <td>-52.941176</td>\n",
       "      <td>...</td>\n",
       "      <td>16.279070</td>\n",
       "      <td>38.000000</td>\n",
       "      <td>8.695652</td>\n",
       "      <td>40.000000</td>\n",
       "      <td>-25.714286</td>\n",
       "      <td>-21.794872</td>\n",
       "      <td>-40.983607</td>\n",
       "      <td>44.444444</td>\n",
       "      <td>-15.384615</td>\n",
       "      <td>140.909091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5925</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1442.0</td>\n",
       "      <td>8.490566</td>\n",
       "      <td>-75.652174</td>\n",
       "      <td>-75.000000</td>\n",
       "      <td>-71.428571</td>\n",
       "      <td>850.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>13.333333</td>\n",
       "      <td>-1.176471</td>\n",
       "      <td>26.190476</td>\n",
       "      <td>-10.377358</td>\n",
       "      <td>-12.631579</td>\n",
       "      <td>-31.325301</td>\n",
       "      <td>-17.543860</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-53.191489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5926</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1311.0</td>\n",
       "      <td>-18.181818</td>\n",
       "      <td>-22.222222</td>\n",
       "      <td>-85.714286</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>120.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>57.777778</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>38.028169</td>\n",
       "      <td>-7.142857</td>\n",
       "      <td>-23.076923</td>\n",
       "      <td>-8.571429</td>\n",
       "      <td>-29.687500</td>\n",
       "      <td>-6.666667</td>\n",
       "      <td>33.333333</td>\n",
       "      <td>-73.214286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5927</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1334.0</td>\n",
       "      <td>33.333333</td>\n",
       "      <td>-40.000000</td>\n",
       "      <td>-50.000000</td>\n",
       "      <td>-33.333333</td>\n",
       "      <td>175.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>61.224490</td>\n",
       "      <td>-2.531646</td>\n",
       "      <td>10.389610</td>\n",
       "      <td>5.882353</td>\n",
       "      <td>-18.888889</td>\n",
       "      <td>-1.369863</td>\n",
       "      <td>-23.611111</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.909091</td>\n",
       "      <td>-60.655738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5928</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>179547</td>\n",
       "      <td>WB</td>\n",
       "      <td>1617.0</td>\n",
       "      <td>-50.000000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>-26.666667</td>\n",
       "      <td>-18.181818</td>\n",
       "      <td>122.222222</td>\n",
       "      <td>...</td>\n",
       "      <td>57.627119</td>\n",
       "      <td>-35.483871</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>24.509804</td>\n",
       "      <td>-9.448819</td>\n",
       "      <td>-28.695652</td>\n",
       "      <td>-51.219512</td>\n",
       "      <td>82.500000</td>\n",
       "      <td>-15.068493</td>\n",
       "      <td>-25.806452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5929</th>\n",
       "      <td>10/27/2012</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>3165.0</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>-15.625000</td>\n",
       "      <td>-29.629630</td>\n",
       "      <td>5.263158</td>\n",
       "      <td>-65.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>22.463768</td>\n",
       "      <td>44.378698</td>\n",
       "      <td>52.868852</td>\n",
       "      <td>-7.506702</td>\n",
       "      <td>-8.985507</td>\n",
       "      <td>-9.554140</td>\n",
       "      <td>-10.915493</td>\n",
       "      <td>14.624506</td>\n",
       "      <td>-72.413793</td>\n",
       "      <td>-32.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5930</th>\n",
       "      <td>10/28/2012</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>2437.0</td>\n",
       "      <td>-29.629630</td>\n",
       "      <td>-23.684211</td>\n",
       "      <td>-10.344828</td>\n",
       "      <td>11.538462</td>\n",
       "      <td>-48.275862</td>\n",
       "      <td>...</td>\n",
       "      <td>55.865922</td>\n",
       "      <td>2.508961</td>\n",
       "      <td>-4.195804</td>\n",
       "      <td>-18.248175</td>\n",
       "      <td>-22.767857</td>\n",
       "      <td>-63.005780</td>\n",
       "      <td>23.437500</td>\n",
       "      <td>-25.316456</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-42.372881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5931</th>\n",
       "      <td>02/01/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1721.0</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>-50.000000</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>-43.750000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.716981</td>\n",
       "      <td>14.414414</td>\n",
       "      <td>-8.661417</td>\n",
       "      <td>6.896552</td>\n",
       "      <td>-21.774194</td>\n",
       "      <td>-12.371134</td>\n",
       "      <td>-17.647059</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>-50.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5932</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1412.0</td>\n",
       "      <td>-26.190476</td>\n",
       "      <td>-22.580645</td>\n",
       "      <td>-16.666667</td>\n",
       "      <td>-65.000000</td>\n",
       "      <td>57.142857</td>\n",
       "      <td>...</td>\n",
       "      <td>22.916667</td>\n",
       "      <td>-16.101695</td>\n",
       "      <td>-5.050505</td>\n",
       "      <td>11.702128</td>\n",
       "      <td>-16.190476</td>\n",
       "      <td>-12.500000</td>\n",
       "      <td>-2.597403</td>\n",
       "      <td>-13.333333</td>\n",
       "      <td>-6.153846</td>\n",
       "      <td>1.639344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5933</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1257.0</td>\n",
       "      <td>-45.161290</td>\n",
       "      <td>5.882353</td>\n",
       "      <td>-11.111111</td>\n",
       "      <td>-50.000000</td>\n",
       "      <td>-50.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-19.191919</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>32.692308</td>\n",
       "      <td>-2.898551</td>\n",
       "      <td>-32.835821</td>\n",
       "      <td>-38.888889</td>\n",
       "      <td>-23.636364</td>\n",
       "      <td>-4.761905</td>\n",
       "      <td>-12.500000</td>\n",
       "      <td>80.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5934</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1377.0</td>\n",
       "      <td>-63.492063</td>\n",
       "      <td>-26.086957</td>\n",
       "      <td>-58.823529</td>\n",
       "      <td>-42.857143</td>\n",
       "      <td>125.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>60.000000</td>\n",
       "      <td>-14.423077</td>\n",
       "      <td>26.966292</td>\n",
       "      <td>8.849558</td>\n",
       "      <td>-20.325203</td>\n",
       "      <td>-16.326531</td>\n",
       "      <td>-10.975610</td>\n",
       "      <td>-26.027397</td>\n",
       "      <td>-3.703704</td>\n",
       "      <td>-55.769231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5935</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1476.0</td>\n",
       "      <td>-21.739130</td>\n",
       "      <td>-38.888889</td>\n",
       "      <td>-18.181818</td>\n",
       "      <td>-66.666667</td>\n",
       "      <td>200.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>61.290323</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>10.185185</td>\n",
       "      <td>11.764706</td>\n",
       "      <td>-3.759398</td>\n",
       "      <td>-28.906250</td>\n",
       "      <td>-19.780220</td>\n",
       "      <td>-23.287671</td>\n",
       "      <td>-8.928571</td>\n",
       "      <td>-19.607843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5936</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1513.0</td>\n",
       "      <td>-34.146341</td>\n",
       "      <td>-66.666667</td>\n",
       "      <td>-11.111111</td>\n",
       "      <td>12.500000</td>\n",
       "      <td>-44.444444</td>\n",
       "      <td>...</td>\n",
       "      <td>24.418605</td>\n",
       "      <td>6.542056</td>\n",
       "      <td>11.403509</td>\n",
       "      <td>7.086614</td>\n",
       "      <td>-7.352941</td>\n",
       "      <td>-18.253968</td>\n",
       "      <td>-13.592233</td>\n",
       "      <td>-14.606742</td>\n",
       "      <td>-21.052632</td>\n",
       "      <td>-58.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5937</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>179545</td>\n",
       "      <td>EB</td>\n",
       "      <td>1587.0</td>\n",
       "      <td>-28.000000</td>\n",
       "      <td>-22.222222</td>\n",
       "      <td>-42.857143</td>\n",
       "      <td>-12.500000</td>\n",
       "      <td>-57.142857</td>\n",
       "      <td>...</td>\n",
       "      <td>7.142857</td>\n",
       "      <td>1.904762</td>\n",
       "      <td>12.149533</td>\n",
       "      <td>16.666667</td>\n",
       "      <td>-14.285714</td>\n",
       "      <td>-8.333333</td>\n",
       "      <td>-36.363636</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>-17.857143</td>\n",
       "      <td>-56.521739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5938</th>\n",
       "      <td>02/01/2013</td>\n",
       "      <td>Friday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1663.0</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>75.000000</td>\n",
       "      <td>-50.000000</td>\n",
       "      <td>28.571429</td>\n",
       "      <td>11.111111</td>\n",
       "      <td>...</td>\n",
       "      <td>4.385965</td>\n",
       "      <td>-23.529412</td>\n",
       "      <td>23.076923</td>\n",
       "      <td>-19.642857</td>\n",
       "      <td>7.777778</td>\n",
       "      <td>-6.185567</td>\n",
       "      <td>-20.879121</td>\n",
       "      <td>-34.722222</td>\n",
       "      <td>12.765957</td>\n",
       "      <td>-30.188679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5939</th>\n",
       "      <td>02/02/2013</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1344.0</td>\n",
       "      <td>-48.648649</td>\n",
       "      <td>-26.315789</td>\n",
       "      <td>-21.428571</td>\n",
       "      <td>-45.454545</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-10.000000</td>\n",
       "      <td>6.172840</td>\n",
       "      <td>17.441860</td>\n",
       "      <td>-2.970297</td>\n",
       "      <td>-14.285714</td>\n",
       "      <td>-17.857143</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-27.536232</td>\n",
       "      <td>-18.000000</td>\n",
       "      <td>14.634146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5940</th>\n",
       "      <td>02/03/2013</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1120.0</td>\n",
       "      <td>-76.595745</td>\n",
       "      <td>54.545455</td>\n",
       "      <td>29.411765</td>\n",
       "      <td>-63.636364</td>\n",
       "      <td>-37.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>-13.750000</td>\n",
       "      <td>21.739130</td>\n",
       "      <td>-16.666667</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>-38.095238</td>\n",
       "      <td>-27.692308</td>\n",
       "      <td>-4.255319</td>\n",
       "      <td>-2.222222</td>\n",
       "      <td>-34.090909</td>\n",
       "      <td>282.758621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5941</th>\n",
       "      <td>02/04/2013</td>\n",
       "      <td>Monday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1263.0</td>\n",
       "      <td>-87.387387</td>\n",
       "      <td>7.142857</td>\n",
       "      <td>-53.333333</td>\n",
       "      <td>-42.857143</td>\n",
       "      <td>125.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>14.864865</td>\n",
       "      <td>9.411765</td>\n",
       "      <td>-12.903226</td>\n",
       "      <td>-9.876543</td>\n",
       "      <td>-2.739726</td>\n",
       "      <td>-9.859155</td>\n",
       "      <td>-29.687500</td>\n",
       "      <td>-46.666667</td>\n",
       "      <td>-12.500000</td>\n",
       "      <td>19.047619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5942</th>\n",
       "      <td>02/05/2013</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1340.0</td>\n",
       "      <td>-48.000000</td>\n",
       "      <td>-30.769231</td>\n",
       "      <td>-44.444444</td>\n",
       "      <td>-40.000000</td>\n",
       "      <td>133.333333</td>\n",
       "      <td>...</td>\n",
       "      <td>69.090909</td>\n",
       "      <td>10.752688</td>\n",
       "      <td>-19.417476</td>\n",
       "      <td>15.662651</td>\n",
       "      <td>-8.333333</td>\n",
       "      <td>-22.727273</td>\n",
       "      <td>7.352941</td>\n",
       "      <td>-58.904110</td>\n",
       "      <td>-30.000000</td>\n",
       "      <td>47.619048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5943</th>\n",
       "      <td>02/06/2013</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1403.0</td>\n",
       "      <td>-61.290323</td>\n",
       "      <td>-33.333333</td>\n",
       "      <td>-87.500000</td>\n",
       "      <td>700.000000</td>\n",
       "      <td>-50.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>31.081081</td>\n",
       "      <td>10.309278</td>\n",
       "      <td>-27.102804</td>\n",
       "      <td>11.538462</td>\n",
       "      <td>25.287356</td>\n",
       "      <td>-41.284404</td>\n",
       "      <td>-21.875000</td>\n",
       "      <td>-18.000000</td>\n",
       "      <td>41.463415</td>\n",
       "      <td>-70.689655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5944</th>\n",
       "      <td>02/07/2013</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>179545</td>\n",
       "      <td>WB</td>\n",
       "      <td>1474.0</td>\n",
       "      <td>17.647059</td>\n",
       "      <td>-45.000000</td>\n",
       "      <td>-45.454545</td>\n",
       "      <td>-16.666667</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.388350</td>\n",
       "      <td>26.829268</td>\n",
       "      <td>-19.230769</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>-4.761905</td>\n",
       "      <td>-32.000000</td>\n",
       "      <td>-10.294118</td>\n",
       "      <td>-21.311475</td>\n",
       "      <td>-29.166667</td>\n",
       "      <td>-14.705882</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5945 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Date    Weekday  Segment ID Direction  Total Traffic  \\\n",
       "0     02/02/2013   Saturday        2153        NB         5391.0   \n",
       "1     02/03/2013     Sunday        2153        NB         4085.0   \n",
       "2     02/04/2013     Monday        2153        NB         5867.0   \n",
       "3     02/05/2013    Tuesday        2153        NB         6172.0   \n",
       "4     02/06/2013  Wednesday        2153        NB         5597.0   \n",
       "5     02/07/2013   Thursday        2153        NB         5302.0   \n",
       "6     02/08/2013     Friday        2153        NB         6448.0   \n",
       "7     02/09/2013   Saturday        2153        NB         5504.0   \n",
       "8     02/10/2013     Sunday        2153        NB         4171.0   \n",
       "9     02/11/2013     Monday        2153        NB         5989.0   \n",
       "10    02/12/2013    Tuesday        2153        NB         6326.0   \n",
       "11    02/13/2013  Wednesday        2153        NB         5696.0   \n",
       "12    02/14/2013   Thursday        2153        NB         5338.0   \n",
       "13    02/02/2013   Saturday        2153        SB         5121.0   \n",
       "14    02/03/2013     Sunday        2153        SB         4056.0   \n",
       "15    02/04/2013     Monday        2153        SB         5546.0   \n",
       "16    02/05/2013    Tuesday        2153        SB         5784.0   \n",
       "17    02/06/2013  Wednesday        2153        SB         5389.0   \n",
       "18    02/07/2013   Thursday        2153        SB         5361.0   \n",
       "19    02/08/2013     Friday        2153        SB         5301.0   \n",
       "20    02/09/2013   Saturday        2153        SB         5173.0   \n",
       "21    02/10/2013     Sunday        2153        SB         4174.0   \n",
       "22    02/11/2013     Monday        2153        SB         5222.0   \n",
       "23    02/12/2013    Tuesday        2153        SB         3289.0   \n",
       "24    02/13/2013  Wednesday        2153        SB         3016.0   \n",
       "25    02/14/2013   Thursday        2153        SB         2911.0   \n",
       "26    09/29/2012   Saturday        6644        NB         7148.0   \n",
       "27    09/30/2012     Sunday        6644        NB         5166.0   \n",
       "28    10/01/2012     Monday        6644        NB         5774.0   \n",
       "29    10/02/2012    Tuesday        6644        NB         6337.0   \n",
       "...          ...        ...         ...       ...            ...   \n",
       "5915  02/03/2013     Sunday      179545        WB        34697.0   \n",
       "5916  02/04/2013     Monday      179545        WB        47502.0   \n",
       "5917  02/05/2013    Tuesday      179545        WB        46805.0   \n",
       "5918  02/06/2013  Wednesday      179545        WB        48843.0   \n",
       "5919  02/07/2013   Thursday      179545        WB        54334.0   \n",
       "5920  10/27/2012   Saturday      179547        WB         3082.0   \n",
       "5921  10/28/2012     Sunday      179547        WB         2517.0   \n",
       "5922  02/01/2013     Friday      179547       WB          1354.0   \n",
       "5923  02/02/2013   Saturday      179547       WB          1092.0   \n",
       "5924  02/03/2013     Sunday      179547       WB          1039.0   \n",
       "5925  02/04/2013     Monday      179547       WB          1442.0   \n",
       "5926  02/05/2013    Tuesday      179547       WB          1311.0   \n",
       "5927  02/06/2013  Wednesday      179547       WB          1334.0   \n",
       "5928  02/07/2013   Thursday      179547       WB          1617.0   \n",
       "5929  10/27/2012   Saturday      179545        EB         3165.0   \n",
       "5930  10/28/2012     Sunday      179545        EB         2437.0   \n",
       "5931  02/01/2013     Friday      179545       EB          1721.0   \n",
       "5932  02/02/2013   Saturday      179545       EB          1412.0   \n",
       "5933  02/03/2013     Sunday      179545       EB          1257.0   \n",
       "5934  02/04/2013     Monday      179545       EB          1377.0   \n",
       "5935  02/05/2013    Tuesday      179545       EB          1476.0   \n",
       "5936  02/06/2013  Wednesday      179545       EB          1513.0   \n",
       "5937  02/07/2013   Thursday      179545       EB          1587.0   \n",
       "5938  02/01/2013     Friday      179545        WB         1663.0   \n",
       "5939  02/02/2013   Saturday      179545        WB         1344.0   \n",
       "5940  02/03/2013     Sunday      179545        WB         1120.0   \n",
       "5941  02/04/2013     Monday      179545        WB         1263.0   \n",
       "5942  02/05/2013    Tuesday      179545        WB         1340.0   \n",
       "5943  02/06/2013  Wednesday      179545        WB         1403.0   \n",
       "5944  02/07/2013   Thursday      179545        WB         1474.0   \n",
       "\n",
       "      12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  4:00-5:00AM  \\\n",
       "0        106.000000   -30.188679   -39.189189   -35.555556     0.000000   \n",
       "1        -35.502959   -32.110092   -25.675676   -32.727273   -29.729730   \n",
       "2        -54.430380   -22.222222   -60.714286    45.454545   100.000000   \n",
       "3        -43.243243   -33.333333   -42.857143   -25.000000   183.333333   \n",
       "4        -53.947368     8.571429   -68.421053    16.666667   121.428571   \n",
       "5        -56.578947   -21.212121   -46.153846    57.142857    40.909091   \n",
       "6        -66.346154   -20.000000   -35.714286   -22.222222   142.857143   \n",
       "7        -28.571429   -33.636364   -36.986301   -30.434783    -9.375000   \n",
       "8        -34.482759   -32.456140   -24.675325   -31.034483   -30.000000   \n",
       "9        -55.294118   -21.052632   -50.000000    26.666667    78.947368   \n",
       "10       -42.666667   -25.581395   -37.500000   -25.000000   140.000000   \n",
       "11       -60.824742     7.894737   -60.975610     0.000000   106.250000   \n",
       "12       -53.164557   -21.621622   -37.931034    27.777778    43.478261   \n",
       "13       132.000000   -33.333333   -28.409091   -38.095238   -38.461538   \n",
       "14       -18.709677   -29.365079   -19.101124   -41.666667     2.380952   \n",
       "15       -33.707865   -49.152542   -56.666667   -23.076923   180.000000   \n",
       "16       -21.518987   -56.451613   -59.259259    -9.090909   150.000000   \n",
       "17       -33.663366   -56.716418   -44.827586   -12.500000    35.714286   \n",
       "18       -44.943820   -38.775510   -73.333333   187.500000    13.043478   \n",
       "19       -47.945205   -52.631579   -36.111111   -30.434783    56.250000   \n",
       "20       -27.544910   -50.413223     3.333333   -43.548387   -45.714286   \n",
       "21       -34.031414   -22.222222   -21.428571   -57.142857   -27.272727   \n",
       "22       -52.083333   -34.782609   -26.666667   109.090909   178.260870   \n",
       "23       -38.888889   -48.484848   -82.352941   466.666667   264.705882   \n",
       "24       -71.428571    16.666667   -85.714286   800.000000   266.666667   \n",
       "25       -31.578947   -84.615385    50.000000   233.333333   210.000000   \n",
       "26        89.000000   -55.056180   -17.500000    -3.030303    -3.125000   \n",
       "27       -23.846154   -33.333333   -37.878788   -19.512195   -15.151515   \n",
       "28       -22.727273   -31.372549   -31.428571   -25.000000    94.444444   \n",
       "29       -45.454545   -33.333333   -30.000000    28.571429   155.555556   \n",
       "...             ...          ...          ...          ...          ...   \n",
       "5915     -17.557803   -54.163015   -49.713193   -22.433460     6.862745   \n",
       "5916     -19.683482   -51.600985   -40.712468    16.309013    73.431734   \n",
       "5917     -38.109306   -30.310263   -16.095890    20.816327    59.797297   \n",
       "5918     -41.963016   -38.725490    -5.600000    21.186441    83.566434   \n",
       "5919     -32.796486   -36.165577    -3.071672    18.309859    80.357143   \n",
       "5920      34.000000   -52.941176    -6.250000     6.666667   -68.750000   \n",
       "5921     -59.420290   -17.857143   -17.391304   -15.789474    12.500000   \n",
       "5922      25.000000   -40.000000   -73.333333   250.000000     7.142857   \n",
       "5923      50.000000   -58.823529    38.095238   -89.655172   400.000000   \n",
       "5924       8.333333   -71.794872   -13.636364   -10.526316   -52.941176   \n",
       "5925       8.490566   -75.652174   -75.000000   -71.428571   850.000000   \n",
       "5926     -18.181818   -22.222222   -85.714286   150.000000   120.000000   \n",
       "5927      33.333333   -40.000000   -50.000000   -33.333333   175.000000   \n",
       "5928     -50.000000    25.000000   -26.666667   -18.181818   122.222222   \n",
       "5929      32.000000   -15.625000   -29.629630     5.263158   -65.000000   \n",
       "5930     -29.629630   -23.684211   -10.344828    11.538462   -48.275862   \n",
       "5931      16.000000    25.000000   -50.000000    60.000000   -43.750000   \n",
       "5932     -26.190476   -22.580645   -16.666667   -65.000000    57.142857   \n",
       "5933     -45.161290     5.882353   -11.111111   -50.000000   -50.000000   \n",
       "5934     -63.492063   -26.086957   -58.823529   -42.857143   125.000000   \n",
       "5935     -21.739130   -38.888889   -18.181818   -66.666667   200.000000   \n",
       "5936     -34.146341   -66.666667   -11.111111    12.500000   -44.444444   \n",
       "5937     -28.000000   -22.222222   -42.857143   -12.500000   -57.142857   \n",
       "5938       8.000000    75.000000   -50.000000    28.571429    11.111111   \n",
       "5939     -48.648649   -26.315789   -21.428571   -45.454545     0.000000   \n",
       "5940     -76.595745    54.545455    29.411765   -63.636364   -37.500000   \n",
       "5941     -87.387387     7.142857   -53.333333   -42.857143   125.000000   \n",
       "5942     -48.000000   -30.769231   -44.444444   -40.000000   133.333333   \n",
       "5943     -61.290323   -33.333333   -87.500000   700.000000   -50.000000   \n",
       "5944      17.647059   -45.000000   -45.454545   -16.666667   -20.000000   \n",
       "\n",
       "          ...        2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  \\\n",
       "0         ...          -9.732360     7.277628   -18.592965    21.604938   \n",
       "1         ...         -12.000000    -5.519481     7.560137   -19.169329   \n",
       "2         ...          29.878049    -0.234742    -1.411765    11.933174   \n",
       "3         ...           2.879581    21.882952    -7.933194     7.936508   \n",
       "4         ...          18.209877     0.261097     1.822917    -5.626598   \n",
       "5         ...         -50.165017   170.860927     3.178484   -13.744076   \n",
       "6         ...          21.813031    20.465116   -11.003861     5.206074   \n",
       "7         ...          -9.546539     7.124011   -18.719212    21.818182   \n",
       "8         ...         -11.516854    -5.714286     7.744108   -19.687500   \n",
       "9         ...          35.202492    -0.230415     1.154734     9.132420   \n",
       "10        ...           2.820513    21.695761    -7.786885     8.000000   \n",
       "11        ...          18.126888     0.255754     1.785714    -5.513784   \n",
       "12        ...         -50.161812   170.779221    -2.877698    -7.654321   \n",
       "13        ...           0.789474     6.005222   -16.009852     0.293255   \n",
       "14        ...           0.928793    -5.521472     1.948052   -11.464968   \n",
       "15        ...          22.402597    12.732095     1.411765    -5.104408   \n",
       "16        ...          51.908397    22.613065    -6.967213    -0.220264   \n",
       "17        ...          45.559846    13.527851     2.336449   -10.730594   \n",
       "18        ...          42.338710    22.379603   -18.518519    17.045455   \n",
       "19        ...          57.939914    -1.086957     4.120879    -3.693931   \n",
       "20        ...          -0.264550    24.403183   -23.454158    -8.077994   \n",
       "21        ...         -26.777251     3.236246    -4.075235    -7.189542   \n",
       "22        ...         -11.051213    28.181818   -16.312057     2.259887   \n",
       "23        ...         144.954128   -23.220974    19.024390   -29.508197   \n",
       "24        ...          27.127660     5.439331    10.317460    -1.079137   \n",
       "25        ...         106.923077    -7.806691     8.870968    -8.518519   \n",
       "26        ...           0.497512   -17.326733     7.584830    -6.679035   \n",
       "27        ...          -2.348337   -14.028056   -17.715618   -14.730878   \n",
       "28        ...          19.676550     8.558559    -8.713693    -5.454545   \n",
       "29        ...          21.388889    12.356979    -7.942974    -7.964602   \n",
       "...       ...                ...          ...          ...          ...   \n",
       "5915      ...           2.641056     1.793372    14.017618     2.653678   \n",
       "5916      ...           8.208955     2.112069     8.864500    -0.116324   \n",
       "5917      ...           8.489681    10.678772     5.820312    -1.734958   \n",
       "5918      ...          10.933941     2.422998     8.781075     1.916697   \n",
       "5919      ...          10.914928     3.002894     8.535300    -7.087379   \n",
       "5920      ...          40.476190    57.062147    16.546763     8.024691   \n",
       "5921      ...          41.081081   -11.877395    28.260870   -16.610169   \n",
       "5922      ...          33.846154    -6.896552    37.037037   -26.126126   \n",
       "5923      ...          36.206897    -7.594937     1.369863    -1.351351   \n",
       "5924      ...          16.279070    38.000000     8.695652    40.000000   \n",
       "5925      ...          13.333333    -1.176471    26.190476   -10.377358   \n",
       "5926      ...          57.777778     0.000000    38.028169    -7.142857   \n",
       "5927      ...          61.224490    -2.531646    10.389610     5.882353   \n",
       "5928      ...          57.627119   -35.483871    70.000000    24.509804   \n",
       "5929      ...          22.463768    44.378698    52.868852    -7.506702   \n",
       "5930      ...          55.865922     2.508961    -4.195804   -18.248175   \n",
       "5931      ...           0.000000     4.716981    14.414414    -8.661417   \n",
       "5932      ...          22.916667   -16.101695    -5.050505    11.702128   \n",
       "5933      ...         -19.191919    30.000000    32.692308    -2.898551   \n",
       "5934      ...          60.000000   -14.423077    26.966292     8.849558   \n",
       "5935      ...          61.290323     8.000000    10.185185    11.764706   \n",
       "5936      ...          24.418605     6.542056    11.403509     7.086614   \n",
       "5937      ...           7.142857     1.904762    12.149533    16.666667   \n",
       "5938      ...           4.385965   -23.529412    23.076923   -19.642857   \n",
       "5939      ...         -10.000000     6.172840    17.441860    -2.970297   \n",
       "5940      ...         -13.750000    21.739130   -16.666667    50.000000   \n",
       "5941      ...          14.864865     9.411765   -12.903226    -9.876543   \n",
       "5942      ...          69.090909    10.752688   -19.417476    15.662651   \n",
       "5943      ...          31.081081    10.309278   -27.102804    11.538462   \n",
       "5944      ...         -20.388350    26.829268   -19.230769    25.000000   \n",
       "\n",
       "      6:00-7:00PM  7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  \\\n",
       "0       -3.807107   -13.192612   -24.316109    -20.883534      -5.076142   \n",
       "1       -4.347826   -10.330579    -3.225806    -31.428571     -13.194444   \n",
       "2       -9.381663   -15.764706   -37.430168    -17.410714     -28.648649   \n",
       "3       -6.302521    -4.932735   -28.066038    -28.196721     -21.917808   \n",
       "4        8.672087   -15.710723   -30.177515    -21.186441     -33.870968   \n",
       "5       -2.197802    -4.775281   -18.879056    -18.181818     -24.888889   \n",
       "6        9.484536   -25.988701   -10.687023    -21.367521     -12.318841   \n",
       "7       -3.731343   -13.178295   -24.404762    -20.866142      -4.975124   \n",
       "8       -4.280156   -10.162602    -3.167421    -31.308411     -17.687075   \n",
       "9       -9.414226   -15.704388   -37.534247    -17.105263     -28.042328   \n",
       "10      -6.584362    -4.625551   -27.944573    -28.525641     -21.524664   \n",
       "11       8.488064   -15.647922   -30.434783    -20.833333     -33.684211   \n",
       "12       5.347594   -10.152284   -30.225989    -19.028340     -24.500000   \n",
       "13      -1.754386   -19.047619   -16.176471    -12.719298      -4.522613   \n",
       "14      -8.273381    -0.392157   -17.322835    -34.285714     -26.811594   \n",
       "15      -4.645477    -8.205128   -29.888268    -22.709163     -31.958763   \n",
       "16      -4.194260   -10.829493   -22.222222    -29.568106     -31.132075   \n",
       "17       8.951407   -28.169014   -17.320261    -30.434783     -27.840909   \n",
       "18     -10.922330     0.544959   -23.306233    -34.628975     -16.216216   \n",
       "19      14.520548    -7.416268   -31.782946    -20.075758     -15.639810   \n",
       "20       3.030303    -8.529412   -17.041801    -27.906977      -8.064516   \n",
       "21      -3.169014   -24.363636   -17.788462    -18.713450     -30.215827   \n",
       "22      -1.933702   -23.380282   -35.661765    -14.857143     -53.691275   \n",
       "23      28.488372   -39.366516   -14.925373    -52.631579     -50.000000   \n",
       "24     -20.000000   -38.636364   -20.740741    -37.383178     -44.776119   \n",
       "25      -6.882591   -25.652174   -23.976608    -29.230769     -39.130435   \n",
       "26      -2.186879   -27.235772   -38.268156    -25.791855     -11.585366   \n",
       "27     -23.255814   -17.748918   -26.842105    -20.863309      -5.454545   \n",
       "28       4.807692   -33.256881   -30.240550    -32.512315     -32.116788   \n",
       "29       0.480769   -21.052632   -35.757576    -33.962264     -32.857143   \n",
       "...           ...          ...          ...           ...            ...   \n",
       "5915   -21.367801   -34.665002   -15.286624     18.571429     -21.496512   \n",
       "5916     2.756211   -24.404987   -24.937531    -14.380826     -18.195956   \n",
       "5917    -7.776108   -25.539715   -21.717724    -12.368973     -11.004785   \n",
       "5918     0.650995   -26.051024   -21.234208    -14.373843     -19.596542   \n",
       "5919     0.870777    -8.563536   -17.107251    -17.904328     -19.977802   \n",
       "5920   -30.285714    21.311475   -15.540541     16.800000     -74.657534   \n",
       "5921   -23.983740   -56.149733    20.731707    -38.383838     -27.868852   \n",
       "5922   -13.414634    18.309859   -52.380952     27.500000       9.803922   \n",
       "5923    28.767123   -20.212766   -41.333333     15.909091      13.725490   \n",
       "5924   -25.714286   -21.794872   -40.983607     44.444444     -15.384615   \n",
       "5925   -12.631579   -31.325301   -17.543860      0.000000       0.000000   \n",
       "5926   -23.076923    -8.571429   -29.687500     -6.666667      33.333333   \n",
       "5927   -18.888889    -1.369863   -23.611111      0.000000      10.909091   \n",
       "5928    -9.448819   -28.695652   -51.219512     82.500000     -15.068493   \n",
       "5929    -8.985507    -9.554140   -10.915493     14.624506     -72.413793   \n",
       "5930   -22.767857   -63.005780    23.437500    -25.316456       0.000000   \n",
       "5931     6.896552   -21.774194   -12.371134    -17.647059      20.000000   \n",
       "5932   -16.190476   -12.500000    -2.597403    -13.333333      -6.153846   \n",
       "5933   -32.835821   -38.888889   -23.636364     -4.761905     -12.500000   \n",
       "5934   -20.325203   -16.326531   -10.975610    -26.027397      -3.703704   \n",
       "5935    -3.759398   -28.906250   -19.780220    -23.287671      -8.928571   \n",
       "5936    -7.352941   -18.253968   -13.592233    -14.606742     -21.052632   \n",
       "5937   -14.285714    -8.333333   -36.363636     20.000000     -17.857143   \n",
       "5938     7.777778    -6.185567   -20.879121    -34.722222      12.765957   \n",
       "5939   -14.285714   -17.857143     0.000000    -27.536232     -18.000000   \n",
       "5940   -38.095238   -27.692308    -4.255319     -2.222222     -34.090909   \n",
       "5941    -2.739726    -9.859155   -29.687500    -46.666667     -12.500000   \n",
       "5942    -8.333333   -22.727273     7.352941    -58.904110     -30.000000   \n",
       "5943    25.287356   -41.284404   -21.875000    -18.000000      41.463415   \n",
       "5944    -4.761905   -32.000000   -10.294118    -21.311475     -29.166667   \n",
       "\n",
       "      11:00-12:00AM  \n",
       "0         -9.625668  \n",
       "1        -36.800000  \n",
       "2        -43.939394  \n",
       "3        -55.555556  \n",
       "4        -38.211382  \n",
       "5        -38.461538  \n",
       "6        -36.363636  \n",
       "7         -8.900524  \n",
       "8        -29.752066  \n",
       "9        -44.852941  \n",
       "10       -44.571429  \n",
       "11       -37.301587  \n",
       "12       -35.761589  \n",
       "13       -18.421053  \n",
       "14       -11.881188  \n",
       "15       -40.151515  \n",
       "16       -30.821918  \n",
       "17       -29.921260  \n",
       "18        -5.806452  \n",
       "19        -6.179775  \n",
       "20        11.695906  \n",
       "21       -50.515464  \n",
       "22       -21.739130  \n",
       "23       -22.222222  \n",
       "24       -48.648649  \n",
       "25       -53.571429  \n",
       "26       -10.344828  \n",
       "27       -36.538462  \n",
       "28       -40.860215  \n",
       "29       -40.425532  \n",
       "...             ...  \n",
       "5915     -18.336026  \n",
       "5916     -35.646388  \n",
       "5917     -37.007168  \n",
       "5918     -38.799283  \n",
       "5919     -13.453537  \n",
       "5920      -6.756757  \n",
       "5921     -29.545455  \n",
       "5922     -39.285714  \n",
       "5923      24.137931  \n",
       "5924     140.909091  \n",
       "5925     -53.191489  \n",
       "5926     -73.214286  \n",
       "5927     -60.655738  \n",
       "5928     -25.806452  \n",
       "5929     -32.500000  \n",
       "5930     -42.372881  \n",
       "5931     -50.000000  \n",
       "5932       1.639344  \n",
       "5933      80.000000  \n",
       "5934     -55.769231  \n",
       "5935     -19.607843  \n",
       "5936     -58.333333  \n",
       "5937     -56.521739  \n",
       "5938     -30.188679  \n",
       "5939      14.634146  \n",
       "5940     282.758621  \n",
       "5941      19.047619  \n",
       "5942      47.619048  \n",
       "5943     -70.689655  \n",
       "5944     -14.705882  \n",
       "\n",
       "[5945 rows x 29 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df2.to_csv('Change_in_Traffic_Count.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}