NYC_traffic_analysis_2011-2018.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "pd.set_option('display.max_columns', None)\n",
    "from matplotlib import pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = pd.read_csv(\"Traffic_Volume_Counts__2011-2012_.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = df1.rename({'GIS ID': 'Segment ID'}, axis=1) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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>1</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/09/2012</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>20</td>\n",
       "      <td>34</td>\n",
       "      <td>66</td>\n",
       "      <td>100</td>\n",
       "      <td>52</td>\n",
       "      <td>68</td>\n",
       "      <td>85</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/10/2012</td>\n",
       "      <td>21</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>31</td>\n",
       "      <td>70</td>\n",
       "      <td>67</td>\n",
       "      <td>45</td>\n",
       "      <td>57</td>\n",
       "      <td>67</td>\n",
       "      <td>73.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/11/2012</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>34</td>\n",
       "      <td>75</td>\n",
       "      <td>69</td>\n",
       "      <td>71</td>\n",
       "      <td>67</td>\n",
       "      <td>70</td>\n",
       "      <td>90.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/12/2012</td>\n",
       "      <td>22</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "      <td>33</td>\n",
       "      <td>75</td>\n",
       "      <td>89</td>\n",
       "      <td>66</td>\n",
       "      <td>70</td>\n",
       "      <td>60</td>\n",
       "      <td>105.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/13/2012</td>\n",
       "      <td>31</td>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "      <td>28</td>\n",
       "      <td>29</td>\n",
       "      <td>68</td>\n",
       "      <td>84</td>\n",
       "      <td>64</td>\n",
       "      <td>83</td>\n",
       "      <td>89</td>\n",
       "      <td>88.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>54.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID  Segment ID  Roadway Name         From                To Direction  \\\n",
       "0   1       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "1   2       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "2   3       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "3   4       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "4   5       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "\n",
       "         Date  12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  \\\n",
       "0  01/09/2012             20           10           11           14   \n",
       "1  01/10/2012             21           16            8            6   \n",
       "2  01/11/2012             27           14            6            5   \n",
       "3  01/12/2012             22            7            7            8   \n",
       "4  01/13/2012             31           17            7            5   \n",
       "\n",
       "   4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  7:00-8:00AM  8:00-9:00AM  \\\n",
       "0           13           20           34           66          100   \n",
       "1           13           13           31           70           67   \n",
       "2           12           16           34           75           69   \n",
       "3           11           12           33           75           89   \n",
       "4           13           28           29           68           84   \n",
       "\n",
       "   9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  12:00-1:00PM  1:00-2:00PM  \\\n",
       "0            52             68             85          85.0         94.0   \n",
       "1            45             57             67          73.0         95.0   \n",
       "2            71             67             70          90.0         89.0   \n",
       "3            66             70             60         105.0        103.0   \n",
       "4            64             83             89          88.0        113.0   \n",
       "\n",
       "   2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  \\\n",
       "0        104.0        105.0        147.0        120.0         91.0   \n",
       "1        102.0         98.0        133.0        131.0         95.0   \n",
       "2        115.0        115.0        130.0        143.0        106.0   \n",
       "3         71.0        127.0        122.0        144.0        122.0   \n",
       "4        113.0        126.0        133.0        135.0        102.0   \n",
       "\n",
       "   7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \n",
       "0         83.0         74.0          49.0           42.0           42.0  \n",
       "1         73.0         70.0          63.0           42.0           35.0  \n",
       "2         89.0         68.0          64.0           56.0           43.0  \n",
       "3         76.0         64.0          58.0           64.0           43.0  \n",
       "4        106.0         58.0          58.0           55.0           54.0  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = pd.read_csv(\"Traffic_Volume_Counts__2012-2013_.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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>1</td>\n",
       "      <td>2153</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02/02/2013</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>45.0</td>\n",
       "      <td>71</td>\n",
       "      <td>145.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>278</td>\n",
       "      <td>387</td>\n",
       "      <td>335</td>\n",
       "      <td>406</td>\n",
       "      <td>411</td>\n",
       "      <td>371</td>\n",
       "      <td>398</td>\n",
       "      <td>324</td>\n",
       "      <td>394</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2153</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02/03/2013</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>25.0</td>\n",
       "      <td>47</td>\n",
       "      <td>74.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>204</td>\n",
       "      <td>249</td>\n",
       "      <td>351</td>\n",
       "      <td>374</td>\n",
       "      <td>350</td>\n",
       "      <td>308</td>\n",
       "      <td>291</td>\n",
       "      <td>313</td>\n",
       "      <td>253</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>2153</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02/04/2013</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>108.0</td>\n",
       "      <td>168</td>\n",
       "      <td>418.0</td>\n",
       "      <td>493.0</td>\n",
       "      <td>263</td>\n",
       "      <td>282</td>\n",
       "      <td>307</td>\n",
       "      <td>304</td>\n",
       "      <td>328</td>\n",
       "      <td>426</td>\n",
       "      <td>425</td>\n",
       "      <td>419</td>\n",
       "      <td>469</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>2153</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02/05/2013</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>109.0</td>\n",
       "      <td>193</td>\n",
       "      <td>397.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>241</td>\n",
       "      <td>255</td>\n",
       "      <td>294</td>\n",
       "      <td>310</td>\n",
       "      <td>382</td>\n",
       "      <td>393</td>\n",
       "      <td>479</td>\n",
       "      <td>441</td>\n",
       "      <td>476</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>2153</td>\n",
       "      <td>HUGUENOT AVE</td>\n",
       "      <td>WOODROW RD</td>\n",
       "      <td>STAFFORD AVE</td>\n",
       "      <td>NB</td>\n",
       "      <td>02/06/2013</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>98.0</td>\n",
       "      <td>195</td>\n",
       "      <td>372.0</td>\n",
       "      <td>490.0</td>\n",
       "      <td>297</td>\n",
       "      <td>260</td>\n",
       "      <td>283</td>\n",
       "      <td>334</td>\n",
       "      <td>324</td>\n",
       "      <td>383</td>\n",
       "      <td>384</td>\n",
       "      <td>391</td>\n",
       "      <td>369</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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID  Segment ID  Roadway Name        From            To Direction  \\\n",
       "0   1        2153  HUGUENOT AVE  WOODROW RD  STAFFORD AVE        NB   \n",
       "1   1        2153  HUGUENOT AVE  WOODROW RD  STAFFORD AVE        NB   \n",
       "2   1        2153  HUGUENOT AVE  WOODROW RD  STAFFORD AVE        NB   \n",
       "3   1        2153  HUGUENOT AVE  WOODROW RD  STAFFORD AVE        NB   \n",
       "4   1        2153  HUGUENOT AVE  WOODROW RD  STAFFORD AVE        NB   \n",
       "\n",
       "         Date  12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  \\\n",
       "0  02/02/2013            106           74         45.0         29.0   \n",
       "1  02/03/2013            109           74         55.0         37.0   \n",
       "2  02/04/2013             36           28         11.0         16.0   \n",
       "3  02/05/2013             42           28         16.0         12.0   \n",
       "4  02/06/2013             35           38         12.0         14.0   \n",
       "\n",
       "   4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  7:00-8:00AM  8:00-9:00AM  \\\n",
       "0           29         45.0           71        145.0        213.0   \n",
       "1           26         25.0           47         74.0        111.0   \n",
       "2           32        108.0          168        418.0        493.0   \n",
       "3           34        109.0          193        397.0        499.0   \n",
       "4           31         98.0          195        372.0        490.0   \n",
       "\n",
       "   9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  12:00-1:00PM  1:00-2:00PM  \\\n",
       "0           278            387            335           406          411   \n",
       "1           204            249            351           374          350   \n",
       "2           263            282            307           304          328   \n",
       "3           241            255            294           310          382   \n",
       "4           297            260            283           334          324   \n",
       "\n",
       "   2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  \\\n",
       "0          371          398          324          394          379   \n",
       "1          308          291          313          253          242   \n",
       "2          426          425          419          469          425   \n",
       "3          393          479          441          476          446   \n",
       "4          383          384          391          369          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  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3 = pd.read_csv(\"Traffic_Volume_Counts__2014-2018_.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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>2</td>\n",
       "      <td>70376</td>\n",
       "      <td>3 Avenue</td>\n",
       "      <td>East 154 Street</td>\n",
       "      <td>East 155 Street</td>\n",
       "      <td>NB</td>\n",
       "      <td>09/13/2014</td>\n",
       "      <td>204.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>223.0</td>\n",
       "      <td>272.0</td>\n",
       "      <td>386.0</td>\n",
       "      <td>339.0</td>\n",
       "      <td>513</td>\n",
       "      <td>506</td>\n",
       "      <td>520</td>\n",
       "      <td>611</td>\n",
       "      <td>573</td>\n",
       "      <td>546</td>\n",
       "      <td>582</td>\n",
       "      <td>528</td>\n",
       "      <td>432</td>\n",
       "      <td>328</td>\n",
       "      <td>282</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>70376</td>\n",
       "      <td>3 Avenue</td>\n",
       "      <td>East 155 Street</td>\n",
       "      <td>East 154 Street</td>\n",
       "      <td>SB</td>\n",
       "      <td>09/13/2014</td>\n",
       "      <td>140.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>128.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>219.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>317.0</td>\n",
       "      <td>325.0</td>\n",
       "      <td>403</td>\n",
       "      <td>414</td>\n",
       "      <td>379</td>\n",
       "      <td>376</td>\n",
       "      <td>329</td>\n",
       "      <td>362</td>\n",
       "      <td>418</td>\n",
       "      <td>335</td>\n",
       "      <td>282</td>\n",
       "      <td>247</td>\n",
       "      <td>237</td>\n",
       "      <td>191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>56</td>\n",
       "      <td>176365</td>\n",
       "      <td>Bedford Park Boulevard</td>\n",
       "      <td>Grand Concourse</td>\n",
       "      <td>Valentine Avenue</td>\n",
       "      <td>EB</td>\n",
       "      <td>09/13/2014</td>\n",
       "      <td>94.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>210.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>245.0</td>\n",
       "      <td>244</td>\n",
       "      <td>233</td>\n",
       "      <td>280</td>\n",
       "      <td>272</td>\n",
       "      <td>264</td>\n",
       "      <td>236</td>\n",
       "      <td>213</td>\n",
       "      <td>190</td>\n",
       "      <td>199</td>\n",
       "      <td>183</td>\n",
       "      <td>147</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>56</td>\n",
       "      <td>176365</td>\n",
       "      <td>Bedford Park Boulevard</td>\n",
       "      <td>Grand Concourse</td>\n",
       "      <td>Valentine Avenue</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/13/2014</td>\n",
       "      <td>88.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>212.0</td>\n",
       "      <td>205.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>257</td>\n",
       "      <td>245</td>\n",
       "      <td>237</td>\n",
       "      <td>276</td>\n",
       "      <td>223</td>\n",
       "      <td>240</td>\n",
       "      <td>217</td>\n",
       "      <td>198</td>\n",
       "      <td>186</td>\n",
       "      <td>162</td>\n",
       "      <td>157</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>62</td>\n",
       "      <td>147673</td>\n",
       "      <td>Broadway</td>\n",
       "      <td>West 242 Street</td>\n",
       "      <td>240 Street</td>\n",
       "      <td>SB</td>\n",
       "      <td>09/13/2014</td>\n",
       "      <td>255.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>128.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>354.0</td>\n",
       "      <td>473.0</td>\n",
       "      <td>567.0</td>\n",
       "      <td>634.0</td>\n",
       "      <td>781.0</td>\n",
       "      <td>785</td>\n",
       "      <td>779</td>\n",
       "      <td>732</td>\n",
       "      <td>809</td>\n",
       "      <td>707</td>\n",
       "      <td>675</td>\n",
       "      <td>641</td>\n",
       "      <td>556</td>\n",
       "      <td>546</td>\n",
       "      <td>465</td>\n",
       "      <td>425</td>\n",
       "      <td>324</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID  Segment ID            Roadway Name             From                To  \\\n",
       "0   2       70376                3 Avenue  East 154 Street   East 155 Street   \n",
       "1   2       70376                3 Avenue  East 155 Street   East 154 Street   \n",
       "2  56      176365  Bedford Park Boulevard  Grand Concourse  Valentine Avenue   \n",
       "3  56      176365  Bedford Park Boulevard  Grand Concourse  Valentine Avenue   \n",
       "4  62      147673                Broadway  West 242 Street        240 Street   \n",
       "\n",
       "  Direction        Date  12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  \\\n",
       "0        NB  09/13/2014          204.0        177.0        133.0        126.0   \n",
       "1        SB  09/13/2014          140.0         51.0        128.0        116.0   \n",
       "2        EB  09/13/2014           94.0         73.0         65.0         61.0   \n",
       "3        WB  09/13/2014           88.0         82.0         75.0         60.0   \n",
       "4        SB  09/13/2014          255.0        209.0        149.0        148.0   \n",
       "\n",
       "   4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  7:00-8:00AM  8:00-9:00AM  \\\n",
       "0        141.0        134.0        121.0        180.0        223.0   \n",
       "1        144.0        146.0        153.0        219.0        226.0   \n",
       "2         64.0         73.0         65.0        113.0        169.0   \n",
       "3         65.0         67.0         71.0        142.0        198.0   \n",
       "4        128.0        136.0        199.0        354.0        473.0   \n",
       "\n",
       "   9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  12:00-1:00PM  1:00-2:00PM  \\\n",
       "0         272.0          386.0          339.0           513          506   \n",
       "1         273.0          317.0          325.0           403          414   \n",
       "2         210.0          182.0          245.0           244          233   \n",
       "3         212.0          205.0          237.0           257          245   \n",
       "4         567.0          634.0          781.0           785          779   \n",
       "\n",
       "   2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  \\\n",
       "0          520          611          573          546          582   \n",
       "1          379          376          329          362          418   \n",
       "2          280          272          264          236          213   \n",
       "3          237          276          223          240          217   \n",
       "4          732          809          707          675          641   \n",
       "\n",
       "   7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \n",
       "0          528          432           328            282            240  \n",
       "1          335          282           247            237            191  \n",
       "2          190          199           183            147            103  \n",
       "3          198          186           162            157            103  \n",
       "4          556          546           465            425            324  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "pdList = [df1, df2, df3]  # List of your dataframes\n",
    "new_df = pd.concat(pdList)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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>1</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/09/2012</td>\n",
       "      <td>20.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/10/2012</td>\n",
       "      <td>21.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/11/2012</td>\n",
       "      <td>27.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/12/2012</td>\n",
       "      <td>22.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/13/2012</td>\n",
       "      <td>31.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>54.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ID  Segment ID  Roadway Name         From                To Direction  \\\n",
       "0   1       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "1   2       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "2   3       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "3   4       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "4   5       15540  BEACH STREET  UNION PLACE  VAN DUZER STREET        NB   \n",
       "\n",
       "         Date  12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  \\\n",
       "0  01/09/2012           20.0         10.0         11.0         14.0   \n",
       "1  01/10/2012           21.0         16.0          8.0          6.0   \n",
       "2  01/11/2012           27.0         14.0          6.0          5.0   \n",
       "3  01/12/2012           22.0          7.0          7.0          8.0   \n",
       "4  01/13/2012           31.0         17.0          7.0          5.0   \n",
       "\n",
       "   4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  7:00-8:00AM  8:00-9:00AM  \\\n",
       "0         13.0         20.0         34.0         66.0        100.0   \n",
       "1         13.0         13.0         31.0         70.0         67.0   \n",
       "2         12.0         16.0         34.0         75.0         69.0   \n",
       "3         11.0         12.0         33.0         75.0         89.0   \n",
       "4         13.0         28.0         29.0         68.0         84.0   \n",
       "\n",
       "   9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  12:00-1:00PM  1:00-2:00PM  \\\n",
       "0          52.0           68.0           85.0          85.0         94.0   \n",
       "1          45.0           57.0           67.0          73.0         95.0   \n",
       "2          71.0           67.0           70.0          90.0         89.0   \n",
       "3          66.0           70.0           60.0         105.0        103.0   \n",
       "4          64.0           83.0           89.0          88.0        113.0   \n",
       "\n",
       "   2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  \\\n",
       "0        104.0        105.0        147.0        120.0         91.0   \n",
       "1        102.0         98.0        133.0        131.0         95.0   \n",
       "2        115.0        115.0        130.0        143.0        106.0   \n",
       "3         71.0        127.0        122.0        144.0        122.0   \n",
       "4        113.0        126.0        133.0        135.0        102.0   \n",
       "\n",
       "   7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \n",
       "0         83.0         74.0          49.0           42.0           42.0  \n",
       "1         73.0         70.0          63.0           42.0           35.0  \n",
       "2         89.0         68.0          64.0           56.0           43.0  \n",
       "3         76.0         64.0          58.0           64.0           43.0  \n",
       "4        106.0         58.0          58.0           55.0           54.0  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3393, 31)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5945, 31)"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(21448, 31)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(30786, 31)"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID                 int64\n",
       "GIS ID           float64\n",
       "Roadway Name      object\n",
       "From              object\n",
       "To                object\n",
       "Direction         object\n",
       "Date              object\n",
       "12:00-1:00 AM    float64\n",
       "1:00-2:00AM      float64\n",
       "2:00-3:00AM      float64\n",
       "3:00-4:00AM      float64\n",
       "4:00-5:00AM      float64\n",
       "5:00-6:00AM      float64\n",
       "6:00-7:00AM      float64\n",
       "7:00-8:00AM      float64\n",
       "8:00-9:00AM      float64\n",
       "9:00-10:00AM     float64\n",
       "10:00-11:00AM    float64\n",
       "11:00-12:00PM    float64\n",
       "12:00-1:00PM     float64\n",
       "1:00-2:00PM      float64\n",
       "2:00-3:00PM      float64\n",
       "3:00-4:00PM      float64\n",
       "4:00-5:00PM      float64\n",
       "5:00-6:00PM      float64\n",
       "6:00-7:00PM      float64\n",
       "7:00-8:00PM      float64\n",
       "8:00-9:00PM      float64\n",
       "9:00-10:00PM     float64\n",
       "10:00-11:00PM    float64\n",
       "11:00-12:00AM    float64\n",
       "Segment ID       float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_df['year'] = pd.DatetimeIndex(new_df['Date']).year\n",
    "# df['month'] = pd.DatetimeIndex(df['ArrivalDate']).month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/09/2012</td>\n",
       "      <td>20.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/10/2012</td>\n",
       "      <td>21.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/11/2012</td>\n",
       "      <td>27.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/12/2012</td>\n",
       "      <td>22.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>15540</td>\n",
       "      <td>BEACH STREET</td>\n",
       "      <td>UNION PLACE</td>\n",
       "      <td>VAN DUZER STREET</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/13/2012</td>\n",
       "      <td>31.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>2012</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",
       "      <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>21443</th>\n",
       "      <td>366</td>\n",
       "      <td>26557</td>\n",
       "      <td>Mc Donald Avenue</td>\n",
       "      <td>Elmwood Avenue</td>\n",
       "      <td>47 Street</td>\n",
       "      <td>EB</td>\n",
       "      <td>04/15/2018</td>\n",
       "      <td>149.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>104.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>283.0</td>\n",
       "      <td>299.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>291.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>251.0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>202.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>154.0</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21444</th>\n",
       "      <td>366</td>\n",
       "      <td>26557</td>\n",
       "      <td>Mc Donald Avenue</td>\n",
       "      <td>Elmwood Avenue</td>\n",
       "      <td>47 Street</td>\n",
       "      <td>WB</td>\n",
       "      <td>04/15/2018</td>\n",
       "      <td>169.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>410.0</td>\n",
       "      <td>411.0</td>\n",
       "      <td>465.0</td>\n",
       "      <td>516.0</td>\n",
       "      <td>509.0</td>\n",
       "      <td>523.0</td>\n",
       "      <td>465.0</td>\n",
       "      <td>531.0</td>\n",
       "      <td>436.0</td>\n",
       "      <td>446.0</td>\n",
       "      <td>374.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>289.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21445</th>\n",
       "      <td>367</td>\n",
       "      <td>42098</td>\n",
       "      <td>Utica Avenue</td>\n",
       "      <td>Lenox Road</td>\n",
       "      <td>Linden Boulevard</td>\n",
       "      <td>NB</td>\n",
       "      <td>04/15/2018</td>\n",
       "      <td>415.0</td>\n",
       "      <td>339.0</td>\n",
       "      <td>239.0</td>\n",
       "      <td>185.0</td>\n",
       "      <td>212.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>249.0</td>\n",
       "      <td>285.0</td>\n",
       "      <td>386.0</td>\n",
       "      <td>393.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>547.0</td>\n",
       "      <td>551.0</td>\n",
       "      <td>631.0</td>\n",
       "      <td>618.0</td>\n",
       "      <td>520.0</td>\n",
       "      <td>564.0</td>\n",
       "      <td>455.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>425.0</td>\n",
       "      <td>404.0</td>\n",
       "      <td>317.0</td>\n",
       "      <td>280.0</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21446</th>\n",
       "      <td>367</td>\n",
       "      <td>42098</td>\n",
       "      <td>Utica Avenue</td>\n",
       "      <td>Lenox Road</td>\n",
       "      <td>Linden Boulevard</td>\n",
       "      <td>SB</td>\n",
       "      <td>04/15/2018</td>\n",
       "      <td>347.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>191.0</td>\n",
       "      <td>254.0</td>\n",
       "      <td>210.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>246.0</td>\n",
       "      <td>282.0</td>\n",
       "      <td>414.0</td>\n",
       "      <td>485.0</td>\n",
       "      <td>512.0</td>\n",
       "      <td>502.0</td>\n",
       "      <td>487.0</td>\n",
       "      <td>527.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>519.0</td>\n",
       "      <td>466.0</td>\n",
       "      <td>493.0</td>\n",
       "      <td>495.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>391.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21447</th>\n",
       "      <td>368</td>\n",
       "      <td>37379</td>\n",
       "      <td>Madison Avenue</td>\n",
       "      <td>East 73 Street</td>\n",
       "      <td>East 74 Street</td>\n",
       "      <td>NB</td>\n",
       "      <td>04/15/2018</td>\n",
       "      <td>1025.0</td>\n",
       "      <td>577.0</td>\n",
       "      <td>435.0</td>\n",
       "      <td>358.0</td>\n",
       "      <td>303.0</td>\n",
       "      <td>217.0</td>\n",
       "      <td>347.0</td>\n",
       "      <td>511.0</td>\n",
       "      <td>587.0</td>\n",
       "      <td>929.0</td>\n",
       "      <td>1255.0</td>\n",
       "      <td>1216.0</td>\n",
       "      <td>1187.0</td>\n",
       "      <td>1150.0</td>\n",
       "      <td>1270.0</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>1248.0</td>\n",
       "      <td>1306.0</td>\n",
       "      <td>1366.0</td>\n",
       "      <td>1131.0</td>\n",
       "      <td>1060.0</td>\n",
       "      <td>859.0</td>\n",
       "      <td>962.0</td>\n",
       "      <td>836.0</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30786 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ID  Segment ID      Roadway Name            From                To  \\\n",
       "0        1       15540      BEACH STREET     UNION PLACE  VAN DUZER STREET   \n",
       "1        2       15540      BEACH STREET     UNION PLACE  VAN DUZER STREET   \n",
       "2        3       15540      BEACH STREET     UNION PLACE  VAN DUZER STREET   \n",
       "3        4       15540      BEACH STREET     UNION PLACE  VAN DUZER STREET   \n",
       "4        5       15540      BEACH STREET     UNION PLACE  VAN DUZER STREET   \n",
       "...    ...         ...               ...             ...               ...   \n",
       "21443  366       26557  Mc Donald Avenue  Elmwood Avenue         47 Street   \n",
       "21444  366       26557  Mc Donald Avenue  Elmwood Avenue         47 Street   \n",
       "21445  367       42098      Utica Avenue      Lenox Road  Linden Boulevard   \n",
       "21446  367       42098      Utica Avenue      Lenox Road  Linden Boulevard   \n",
       "21447  368       37379    Madison Avenue  East 73 Street    East 74 Street   \n",
       "\n",
       "      Direction        Date  12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  \\\n",
       "0            NB  01/09/2012           20.0         10.0         11.0   \n",
       "1            NB  01/10/2012           21.0         16.0          8.0   \n",
       "2            NB  01/11/2012           27.0         14.0          6.0   \n",
       "3            NB  01/12/2012           22.0          7.0          7.0   \n",
       "4            NB  01/13/2012           31.0         17.0          7.0   \n",
       "...         ...         ...            ...          ...          ...   \n",
       "21443        EB  04/15/2018          149.0         81.0         59.0   \n",
       "21444        WB  04/15/2018          169.0         95.0         86.0   \n",
       "21445        NB  04/15/2018          415.0        339.0        239.0   \n",
       "21446        SB  04/15/2018          347.0        276.0        225.0   \n",
       "21447        NB  04/15/2018         1025.0        577.0        435.0   \n",
       "\n",
       "       3:00-4:00AM  4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  7:00-8:00AM  \\\n",
       "0             14.0         13.0         20.0         34.0         66.0   \n",
       "1              6.0         13.0         13.0         31.0         70.0   \n",
       "2              5.0         12.0         16.0         34.0         75.0   \n",
       "3              8.0         11.0         12.0         33.0         75.0   \n",
       "4              5.0         13.0         28.0         29.0         68.0   \n",
       "...            ...          ...          ...          ...          ...   \n",
       "21443         45.0         42.0         37.0         54.0        104.0   \n",
       "21444         56.0         45.0         59.0         98.0        168.0   \n",
       "21445        185.0        212.0        158.0        138.0        249.0   \n",
       "21446        191.0        254.0        210.0        216.0        246.0   \n",
       "21447        358.0        303.0        217.0        347.0        511.0   \n",
       "\n",
       "       8:00-9:00AM  9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  12:00-1:00PM  \\\n",
       "0            100.0          52.0           68.0           85.0          85.0   \n",
       "1             67.0          45.0           57.0           67.0          73.0   \n",
       "2             69.0          71.0           67.0           70.0          90.0   \n",
       "3             89.0          66.0           70.0           60.0         105.0   \n",
       "4             84.0          64.0           83.0           89.0          88.0   \n",
       "...            ...           ...            ...            ...           ...   \n",
       "21443        136.0         216.0          283.0          299.0         286.0   \n",
       "21444        259.0         410.0          411.0          465.0         516.0   \n",
       "21445        285.0         386.0          393.0          481.0         547.0   \n",
       "21446        282.0         414.0          485.0          512.0         502.0   \n",
       "21447        587.0         929.0         1255.0         1216.0        1187.0   \n",
       "\n",
       "       1:00-2:00PM  2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  \\\n",
       "0             94.0        104.0        105.0        147.0        120.0   \n",
       "1             95.0        102.0         98.0        133.0        131.0   \n",
       "2             89.0        115.0        115.0        130.0        143.0   \n",
       "3            103.0         71.0        127.0        122.0        144.0   \n",
       "4            113.0        113.0        126.0        133.0        135.0   \n",
       "...            ...          ...          ...          ...          ...   \n",
       "21443        269.0        256.0        320.0        291.0        266.0   \n",
       "21444        509.0        523.0        465.0        531.0        436.0   \n",
       "21445        551.0        631.0        618.0        520.0        564.0   \n",
       "21446        487.0        527.0        521.0        519.0        466.0   \n",
       "21447       1150.0       1270.0       1350.0       1248.0       1306.0   \n",
       "\n",
       "       6:00-7:00PM  7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  \\\n",
       "0             91.0         83.0         74.0          49.0           42.0   \n",
       "1             95.0         73.0         70.0          63.0           42.0   \n",
       "2            106.0         89.0         68.0          64.0           56.0   \n",
       "3            122.0         76.0         64.0          58.0           64.0   \n",
       "4            102.0        106.0         58.0          58.0           55.0   \n",
       "...            ...          ...          ...           ...            ...   \n",
       "21443        256.0        251.0        228.0         202.0          197.0   \n",
       "21444        446.0        374.0        311.0         289.0          273.0   \n",
       "21445        455.0        481.0        425.0         404.0          317.0   \n",
       "21446        493.0        495.0        401.0         391.0          309.0   \n",
       "21447       1366.0       1131.0       1060.0         859.0          962.0   \n",
       "\n",
       "       11:00-12:00AM  year  \n",
       "0               42.0  2012  \n",
       "1               35.0  2012  \n",
       "2               43.0  2012  \n",
       "3               43.0  2012  \n",
       "4               54.0  2012  \n",
       "...              ...   ...  \n",
       "21443          154.0  2018  \n",
       "21444          170.0  2018  \n",
       "21445          280.0  2018  \n",
       "21446          270.0  2018  \n",
       "21447          836.0  2018  \n",
       "\n",
       "[30786 rows x 32 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>125</td>\n",
       "      <td>9014615</td>\n",
       "      <td>East Fordham Road</td>\n",
       "      <td>Southern Boulevard</td>\n",
       "      <td>Bronx River Parkway</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/13/2014</td>\n",
       "      <td>952.0</td>\n",
       "      <td>816.0</td>\n",
       "      <td>610.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>331.0</td>\n",
       "      <td>367.0</td>\n",
       "      <td>673.0</td>\n",
       "      <td>1106.0</td>\n",
       "      <td>1526.0</td>\n",
       "      <td>1651.0</td>\n",
       "      <td>1646.0</td>\n",
       "      <td>2080.0</td>\n",
       "      <td>2143.0</td>\n",
       "      <td>1970.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>2045.0</td>\n",
       "      <td>1881.0</td>\n",
       "      <td>2086.0</td>\n",
       "      <td>1797.0</td>\n",
       "      <td>1829.0</td>\n",
       "      <td>1721.0</td>\n",
       "      <td>1348.0</td>\n",
       "      <td>1210.0</td>\n",
       "      <td>1012.0</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>125</td>\n",
       "      <td>9014615</td>\n",
       "      <td>East Fordham Road</td>\n",
       "      <td>Southern Boulevard</td>\n",
       "      <td>Bronx River Parkway</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/14/2014</td>\n",
       "      <td>880.0</td>\n",
       "      <td>776.0</td>\n",
       "      <td>529.0</td>\n",
       "      <td>434.0</td>\n",
       "      <td>390.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>449.0</td>\n",
       "      <td>670.0</td>\n",
       "      <td>944.0</td>\n",
       "      <td>1119.0</td>\n",
       "      <td>1521.0</td>\n",
       "      <td>1729.0</td>\n",
       "      <td>1713.0</td>\n",
       "      <td>1739.0</td>\n",
       "      <td>1807.0</td>\n",
       "      <td>1856.0</td>\n",
       "      <td>1779.0</td>\n",
       "      <td>1839.0</td>\n",
       "      <td>1742.0</td>\n",
       "      <td>1696.0</td>\n",
       "      <td>1625.0</td>\n",
       "      <td>1209.0</td>\n",
       "      <td>945.0</td>\n",
       "      <td>723.0</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>125</td>\n",
       "      <td>9014615</td>\n",
       "      <td>East Fordham Road</td>\n",
       "      <td>Southern Boulevard</td>\n",
       "      <td>Bronx River Parkway</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/15/2014</td>\n",
       "      <td>486.0</td>\n",
       "      <td>272.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>184.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>545.0</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>3594.0</td>\n",
       "      <td>3546.0</td>\n",
       "      <td>2361.0</td>\n",
       "      <td>1726.0</td>\n",
       "      <td>1736.0</td>\n",
       "      <td>1692.0</td>\n",
       "      <td>1727.0</td>\n",
       "      <td>2199.0</td>\n",
       "      <td>2331.0</td>\n",
       "      <td>2220.0</td>\n",
       "      <td>2387.0</td>\n",
       "      <td>1936.0</td>\n",
       "      <td>1612.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>907.0</td>\n",
       "      <td>878.0</td>\n",
       "      <td>743.0</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>125</td>\n",
       "      <td>9014615</td>\n",
       "      <td>East Fordham Road</td>\n",
       "      <td>Southern Boulevard</td>\n",
       "      <td>Bronx River Parkway</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/16/2014</td>\n",
       "      <td>412.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>159.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>561.0</td>\n",
       "      <td>2039.0</td>\n",
       "      <td>3386.0</td>\n",
       "      <td>2903.0</td>\n",
       "      <td>3119.0</td>\n",
       "      <td>1859.0</td>\n",
       "      <td>1508.0</td>\n",
       "      <td>1543.0</td>\n",
       "      <td>1654.0</td>\n",
       "      <td>1893.0</td>\n",
       "      <td>2151.0</td>\n",
       "      <td>2475.0</td>\n",
       "      <td>2184.0</td>\n",
       "      <td>1949.0</td>\n",
       "      <td>1693.0</td>\n",
       "      <td>1322.0</td>\n",
       "      <td>976.0</td>\n",
       "      <td>810.0</td>\n",
       "      <td>668.0</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>125</td>\n",
       "      <td>9014615</td>\n",
       "      <td>East Fordham Road</td>\n",
       "      <td>Southern Boulevard</td>\n",
       "      <td>Bronx River Parkway</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/17/2014</td>\n",
       "      <td>465.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>191.0</td>\n",
       "      <td>403.0</td>\n",
       "      <td>2037.0</td>\n",
       "      <td>3590.0</td>\n",
       "      <td>3477.0</td>\n",
       "      <td>2123.0</td>\n",
       "      <td>1880.0</td>\n",
       "      <td>1717.0</td>\n",
       "      <td>1757.0</td>\n",
       "      <td>1784.0</td>\n",
       "      <td>2072.0</td>\n",
       "      <td>2353.0</td>\n",
       "      <td>2335.0</td>\n",
       "      <td>2414.0</td>\n",
       "      <td>1964.0</td>\n",
       "      <td>1709.0</td>\n",
       "      <td>1297.0</td>\n",
       "      <td>1065.0</td>\n",
       "      <td>849.0</td>\n",
       "      <td>897.0</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>125</td>\n",
       "      <td>9014615</td>\n",
       "      <td>East Fordham Road</td>\n",
       "      <td>Southern Boulevard</td>\n",
       "      <td>Bronx River Parkway</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/18/2014</td>\n",
       "      <td>553.0</td>\n",
       "      <td>302.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>544.0</td>\n",
       "      <td>2041.0</td>\n",
       "      <td>3578.0</td>\n",
       "      <td>3328.0</td>\n",
       "      <td>2266.0</td>\n",
       "      <td>1840.0</td>\n",
       "      <td>1764.0</td>\n",
       "      <td>1718.0</td>\n",
       "      <td>1806.0</td>\n",
       "      <td>2054.0</td>\n",
       "      <td>2256.0</td>\n",
       "      <td>2425.0</td>\n",
       "      <td>2336.0</td>\n",
       "      <td>2089.0</td>\n",
       "      <td>1942.0</td>\n",
       "      <td>1388.0</td>\n",
       "      <td>1067.0</td>\n",
       "      <td>751.0</td>\n",
       "      <td>635.0</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>125</td>\n",
       "      <td>9014615</td>\n",
       "      <td>East Fordham Road</td>\n",
       "      <td>Southern Boulevard</td>\n",
       "      <td>Bronx River Parkway</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/19/2014</td>\n",
       "      <td>422.0</td>\n",
       "      <td>318.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>158.0</td>\n",
       "      <td>244.0</td>\n",
       "      <td>513.0</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>3590.0</td>\n",
       "      <td>3304.0</td>\n",
       "      <td>2189.0</td>\n",
       "      <td>1836.0</td>\n",
       "      <td>1805.0</td>\n",
       "      <td>1897.0</td>\n",
       "      <td>1935.0</td>\n",
       "      <td>2176.0</td>\n",
       "      <td>2439.0</td>\n",
       "      <td>2575.0</td>\n",
       "      <td>2595.0</td>\n",
       "      <td>2606.0</td>\n",
       "      <td>2074.0</td>\n",
       "      <td>1684.0</td>\n",
       "      <td>1357.0</td>\n",
       "      <td>1202.0</td>\n",
       "      <td>923.0</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>125</td>\n",
       "      <td>9014615</td>\n",
       "      <td>East Fordham Road</td>\n",
       "      <td>Southern Boulevard</td>\n",
       "      <td>Bronx River Parkway</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/20/2014</td>\n",
       "      <td>790.0</td>\n",
       "      <td>524.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>392.0</td>\n",
       "      <td>373.0</td>\n",
       "      <td>668.0</td>\n",
       "      <td>1142.0</td>\n",
       "      <td>1728.0</td>\n",
       "      <td>1795.0</td>\n",
       "      <td>1757.0</td>\n",
       "      <td>1825.0</td>\n",
       "      <td>1963.0</td>\n",
       "      <td>1916.0</td>\n",
       "      <td>2029.0</td>\n",
       "      <td>2181.0</td>\n",
       "      <td>2042.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>1959.0</td>\n",
       "      <td>1741.0</td>\n",
       "      <td>1444.0</td>\n",
       "      <td>1210.0</td>\n",
       "      <td>1110.0</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>125</td>\n",
       "      <td>9014615</td>\n",
       "      <td>East Fordham Road</td>\n",
       "      <td>Southern Boulevard</td>\n",
       "      <td>Bronx River Parkway</td>\n",
       "      <td>WB</td>\n",
       "      <td>09/21/2014</td>\n",
       "      <td>915.0</td>\n",
       "      <td>686.0</td>\n",
       "      <td>527.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>418.0</td>\n",
       "      <td>356.0</td>\n",
       "      <td>440.0</td>\n",
       "      <td>624.0</td>\n",
       "      <td>860.0</td>\n",
       "      <td>1125.0</td>\n",
       "      <td>1540.0</td>\n",
       "      <td>1686.0</td>\n",
       "      <td>1714.0</td>\n",
       "      <td>1692.0</td>\n",
       "      <td>1661.0</td>\n",
       "      <td>1755.0</td>\n",
       "      <td>1774.0</td>\n",
       "      <td>1780.0</td>\n",
       "      <td>1823.0</td>\n",
       "      <td>1717.0</td>\n",
       "      <td>1526.0</td>\n",
       "      <td>1088.0</td>\n",
       "      <td>897.0</td>\n",
       "      <td>685.0</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID  Segment ID       Roadway Name                From  \\\n",
       "27   125     9014615  East Fordham Road  Southern Boulevard   \n",
       "99   125     9014615  East Fordham Road  Southern Boulevard   \n",
       "171  125     9014615  East Fordham Road  Southern Boulevard   \n",
       "242  125     9014615  East Fordham Road  Southern Boulevard   \n",
       "314  125     9014615  East Fordham Road  Southern Boulevard   \n",
       "387  125     9014615  East Fordham Road  Southern Boulevard   \n",
       "458  125     9014615  East Fordham Road  Southern Boulevard   \n",
       "563  125     9014615  East Fordham Road  Southern Boulevard   \n",
       "720  125     9014615  East Fordham Road  Southern Boulevard   \n",
       "\n",
       "                      To Direction        Date  12:00-1:00 AM  1:00-2:00AM  \\\n",
       "27   Bronx River Parkway        WB  09/13/2014          952.0        816.0   \n",
       "99   Bronx River Parkway        WB  09/14/2014          880.0        776.0   \n",
       "171  Bronx River Parkway        WB  09/15/2014          486.0        272.0   \n",
       "242  Bronx River Parkway        WB  09/16/2014          412.0        311.0   \n",
       "314  Bronx River Parkway        WB  09/17/2014          465.0        259.0   \n",
       "387  Bronx River Parkway        WB  09/18/2014          553.0        302.0   \n",
       "458  Bronx River Parkway        WB  09/19/2014          422.0        318.0   \n",
       "563  Bronx River Parkway        WB  09/20/2014          790.0        524.0   \n",
       "720  Bronx River Parkway        WB  09/21/2014          915.0        686.0   \n",
       "\n",
       "     2:00-3:00AM  3:00-4:00AM  4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  \\\n",
       "27         610.0        336.0        331.0        367.0        673.0   \n",
       "99         529.0        434.0        390.0        343.0        449.0   \n",
       "171        190.0        184.0        279.0        545.0       1991.0   \n",
       "242        159.0        162.0        238.0        561.0       2039.0   \n",
       "314        130.0        107.0        191.0        403.0       2037.0   \n",
       "387        196.0        161.0        224.0        544.0       2041.0   \n",
       "458        192.0        158.0        244.0        513.0       1975.0   \n",
       "563        500.0        319.0        392.0        373.0        668.0   \n",
       "720        527.0        415.0        418.0        356.0        440.0   \n",
       "\n",
       "     7:00-8:00AM  8:00-9:00AM  9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  \\\n",
       "27        1106.0       1526.0        1651.0         1646.0         2080.0   \n",
       "99         670.0        944.0        1119.0         1521.0         1729.0   \n",
       "171       3594.0       3546.0        2361.0         1726.0         1736.0   \n",
       "242       3386.0       2903.0        3119.0         1859.0         1508.0   \n",
       "314       3590.0       3477.0        2123.0         1880.0         1717.0   \n",
       "387       3578.0       3328.0        2266.0         1840.0         1764.0   \n",
       "458       3590.0       3304.0        2189.0         1836.0         1805.0   \n",
       "563       1142.0       1728.0        1795.0         1757.0         1825.0   \n",
       "720        624.0        860.0        1125.0         1540.0         1686.0   \n",
       "\n",
       "     12:00-1:00PM  1:00-2:00PM  2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  \\\n",
       "27         2143.0       1970.0       1994.0       2045.0       1881.0   \n",
       "99         1713.0       1739.0       1807.0       1856.0       1779.0   \n",
       "171        1692.0       1727.0       2199.0       2331.0       2220.0   \n",
       "242        1543.0       1654.0       1893.0       2151.0       2475.0   \n",
       "314        1757.0       1784.0       2072.0       2353.0       2335.0   \n",
       "387        1718.0       1806.0       2054.0       2256.0       2425.0   \n",
       "458        1897.0       1935.0       2176.0       2439.0       2575.0   \n",
       "563        1963.0       1916.0       2029.0       2181.0       2042.0   \n",
       "720        1714.0       1692.0       1661.0       1755.0       1774.0   \n",
       "\n",
       "     5:00-6:00PM  6:00-7:00PM  7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  \\\n",
       "27        2086.0       1797.0       1829.0       1721.0        1348.0   \n",
       "99        1839.0       1742.0       1696.0       1625.0        1209.0   \n",
       "171       2387.0       1936.0       1612.0       1300.0         907.0   \n",
       "242       2184.0       1949.0       1693.0       1322.0         976.0   \n",
       "314       2414.0       1964.0       1709.0       1297.0        1065.0   \n",
       "387       2336.0       2089.0       1942.0       1388.0        1067.0   \n",
       "458       2595.0       2606.0       2074.0       1684.0        1357.0   \n",
       "563       2014.0       2008.0       1959.0       1741.0        1444.0   \n",
       "720       1780.0       1823.0       1717.0       1526.0        1088.0   \n",
       "\n",
       "     10:00-11:00PM  11:00-12:00AM  year  \n",
       "27          1210.0         1012.0  2014  \n",
       "99           945.0          723.0  2014  \n",
       "171          878.0          743.0  2014  \n",
       "242          810.0          668.0  2014  \n",
       "314          849.0          897.0  2014  \n",
       "387          751.0          635.0  2014  \n",
       "458         1202.0          923.0  2014  \n",
       "563         1210.0         1110.0  2014  \n",
       "720          897.0          685.0  2014  "
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df[(new_df['Segment ID']  == 9014615)&(new_df['year']  == 2014 ) ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_df = new_df.groupby([\"Segment ID\",\"year\"]).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>ID</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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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",
       "    <tr>\n",
       "      <th>Segment ID</th>\n",
       "      <th>year</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <th>2014</th>\n",
       "      <td>200.0</td>\n",
       "      <td>305.000000</td>\n",
       "      <td>222.000000</td>\n",
       "      <td>137.000000</td>\n",
       "      <td>138.000000</td>\n",
       "      <td>114.000000</td>\n",
       "      <td>155.000000</td>\n",
       "      <td>283.000000</td>\n",
       "      <td>355.000000</td>\n",
       "      <td>485.000000</td>\n",
       "      <td>549.000000</td>\n",
       "      <td>550.000000</td>\n",
       "      <td>555.000000</td>\n",
       "      <td>621.000000</td>\n",
       "      <td>630.000000</td>\n",
       "      <td>665.000000</td>\n",
       "      <td>649.000000</td>\n",
       "      <td>671.000000</td>\n",
       "      <td>700.000000</td>\n",
       "      <td>658.000000</td>\n",
       "      <td>646.000000</td>\n",
       "      <td>707.000000</td>\n",
       "      <td>620.000000</td>\n",
       "      <td>540.000000</td>\n",
       "      <td>504.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>646</th>\n",
       "      <th>2012</th>\n",
       "      <td>779.5</td>\n",
       "      <td>28.250000</td>\n",
       "      <td>25.375000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>16.375000</td>\n",
       "      <td>26.375000</td>\n",
       "      <td>51.875000</td>\n",
       "      <td>97.250000</td>\n",
       "      <td>134.250000</td>\n",
       "      <td>182.750000</td>\n",
       "      <td>211.500000</td>\n",
       "      <td>200.875000</td>\n",
       "      <td>236.125000</td>\n",
       "      <td>250.375000</td>\n",
       "      <td>271.125000</td>\n",
       "      <td>263.625000</td>\n",
       "      <td>293.875000</td>\n",
       "      <td>290.750000</td>\n",
       "      <td>225.875000</td>\n",
       "      <td>183.000000</td>\n",
       "      <td>152.625000</td>\n",
       "      <td>94.875000</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>43.000000</td>\n",
       "      <td>34.875000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1416</th>\n",
       "      <th>2015</th>\n",
       "      <td>290.0</td>\n",
       "      <td>61.722222</td>\n",
       "      <td>35.833333</td>\n",
       "      <td>19.388889</td>\n",
       "      <td>17.388889</td>\n",
       "      <td>26.388889</td>\n",
       "      <td>54.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>217.277778</td>\n",
       "      <td>246.222222</td>\n",
       "      <td>218.333333</td>\n",
       "      <td>261.555556</td>\n",
       "      <td>293.722222</td>\n",
       "      <td>312.055556</td>\n",
       "      <td>326.111111</td>\n",
       "      <td>352.833333</td>\n",
       "      <td>348.888889</td>\n",
       "      <td>346.888889</td>\n",
       "      <td>353.166667</td>\n",
       "      <td>319.611111</td>\n",
       "      <td>261.777778</td>\n",
       "      <td>210.333333</td>\n",
       "      <td>156.055556</td>\n",
       "      <td>113.666667</td>\n",
       "      <td>81.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421</th>\n",
       "      <th>2012</th>\n",
       "      <td>670.5</td>\n",
       "      <td>53.750000</td>\n",
       "      <td>30.250000</td>\n",
       "      <td>21.750000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>25.125000</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>151.500000</td>\n",
       "      <td>315.500000</td>\n",
       "      <td>353.375000</td>\n",
       "      <td>213.000000</td>\n",
       "      <td>219.625000</td>\n",
       "      <td>259.250000</td>\n",
       "      <td>287.125000</td>\n",
       "      <td>294.125000</td>\n",
       "      <td>352.125000</td>\n",
       "      <td>400.375000</td>\n",
       "      <td>395.375000</td>\n",
       "      <td>410.375000</td>\n",
       "      <td>366.250000</td>\n",
       "      <td>315.625000</td>\n",
       "      <td>183.625000</td>\n",
       "      <td>140.125000</td>\n",
       "      <td>87.875000</td>\n",
       "      <td>61.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1883</th>\n",
       "      <th>2012</th>\n",
       "      <td>686.0</td>\n",
       "      <td>57.000000</td>\n",
       "      <td>30.500000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>19.500000</td>\n",
       "      <td>52.500000</td>\n",
       "      <td>134.500000</td>\n",
       "      <td>422.500000</td>\n",
       "      <td>352.000000</td>\n",
       "      <td>206.000000</td>\n",
       "      <td>207.000000</td>\n",
       "      <td>253.000000</td>\n",
       "      <td>289.000000</td>\n",
       "      <td>311.000000</td>\n",
       "      <td>367.000000</td>\n",
       "      <td>428.500000</td>\n",
       "      <td>379.500000</td>\n",
       "      <td>371.000000</td>\n",
       "      <td>325.000000</td>\n",
       "      <td>276.500000</td>\n",
       "      <td>223.000000</td>\n",
       "      <td>185.500000</td>\n",
       "      <td>119.500000</td>\n",
       "      <td>89.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9014615</th>\n",
       "      <th>2014</th>\n",
       "      <td>125.0</td>\n",
       "      <td>652.777778</td>\n",
       "      <td>473.777778</td>\n",
       "      <td>337.000000</td>\n",
       "      <td>252.888889</td>\n",
       "      <td>300.777778</td>\n",
       "      <td>445.000000</td>\n",
       "      <td>1368.111111</td>\n",
       "      <td>2364.444444</td>\n",
       "      <td>2401.777778</td>\n",
       "      <td>1972.000000</td>\n",
       "      <td>1733.888889</td>\n",
       "      <td>1761.111111</td>\n",
       "      <td>1793.333333</td>\n",
       "      <td>1802.555556</td>\n",
       "      <td>1987.222222</td>\n",
       "      <td>2151.888889</td>\n",
       "      <td>2167.333333</td>\n",
       "      <td>2181.666667</td>\n",
       "      <td>1990.444444</td>\n",
       "      <td>1803.444444</td>\n",
       "      <td>1511.555556</td>\n",
       "      <td>1162.333333</td>\n",
       "      <td>972.444444</td>\n",
       "      <td>821.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9014764</th>\n",
       "      <th>2014</th>\n",
       "      <td>135.0</td>\n",
       "      <td>1592.222222</td>\n",
       "      <td>1049.111111</td>\n",
       "      <td>798.888889</td>\n",
       "      <td>706.444444</td>\n",
       "      <td>768.333333</td>\n",
       "      <td>1264.111111</td>\n",
       "      <td>2587.888889</td>\n",
       "      <td>3070.444444</td>\n",
       "      <td>3149.333333</td>\n",
       "      <td>3156.777778</td>\n",
       "      <td>3050.333333</td>\n",
       "      <td>3144.888889</td>\n",
       "      <td>3203.222222</td>\n",
       "      <td>3348.777778</td>\n",
       "      <td>3573.555556</td>\n",
       "      <td>3420.555556</td>\n",
       "      <td>3463.888889</td>\n",
       "      <td>3577.111111</td>\n",
       "      <td>3552.111111</td>\n",
       "      <td>3339.333333</td>\n",
       "      <td>3183.555556</td>\n",
       "      <td>2876.777778</td>\n",
       "      <td>2636.000000</td>\n",
       "      <td>2023.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017020</th>\n",
       "      <th>2014</th>\n",
       "      <td>5.0</td>\n",
       "      <td>370.000000</td>\n",
       "      <td>260.555556</td>\n",
       "      <td>192.888889</td>\n",
       "      <td>169.555556</td>\n",
       "      <td>188.333333</td>\n",
       "      <td>333.777778</td>\n",
       "      <td>832.555556</td>\n",
       "      <td>1077.222222</td>\n",
       "      <td>1019.777778</td>\n",
       "      <td>965.888889</td>\n",
       "      <td>940.222222</td>\n",
       "      <td>1038.444444</td>\n",
       "      <td>1046.666667</td>\n",
       "      <td>1095.666667</td>\n",
       "      <td>1159.666667</td>\n",
       "      <td>1110.222222</td>\n",
       "      <td>1201.111111</td>\n",
       "      <td>1228.888889</td>\n",
       "      <td>1201.000000</td>\n",
       "      <td>995.000000</td>\n",
       "      <td>779.333333</td>\n",
       "      <td>661.555556</td>\n",
       "      <td>610.000000</td>\n",
       "      <td>535.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017037</th>\n",
       "      <th>2014</th>\n",
       "      <td>255.0</td>\n",
       "      <td>174.222222</td>\n",
       "      <td>111.333333</td>\n",
       "      <td>78.555556</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>120.777778</td>\n",
       "      <td>329.555556</td>\n",
       "      <td>708.222222</td>\n",
       "      <td>976.666667</td>\n",
       "      <td>934.555556</td>\n",
       "      <td>893.111111</td>\n",
       "      <td>840.111111</td>\n",
       "      <td>820.111111</td>\n",
       "      <td>800.888889</td>\n",
       "      <td>757.777778</td>\n",
       "      <td>806.444444</td>\n",
       "      <td>777.777778</td>\n",
       "      <td>786.000000</td>\n",
       "      <td>741.222222</td>\n",
       "      <td>691.222222</td>\n",
       "      <td>602.444444</td>\n",
       "      <td>524.000000</td>\n",
       "      <td>416.666667</td>\n",
       "      <td>368.444444</td>\n",
       "      <td>267.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017039</th>\n",
       "      <th>2014</th>\n",
       "      <td>255.0</td>\n",
       "      <td>260.777778</td>\n",
       "      <td>166.888889</td>\n",
       "      <td>125.333333</td>\n",
       "      <td>103.888889</td>\n",
       "      <td>113.888889</td>\n",
       "      <td>148.888889</td>\n",
       "      <td>259.666667</td>\n",
       "      <td>554.222222</td>\n",
       "      <td>823.666667</td>\n",
       "      <td>807.333333</td>\n",
       "      <td>717.888889</td>\n",
       "      <td>700.000000</td>\n",
       "      <td>752.666667</td>\n",
       "      <td>870.111111</td>\n",
       "      <td>1080.888889</td>\n",
       "      <td>1470.666667</td>\n",
       "      <td>1524.444444</td>\n",
       "      <td>1441.333333</td>\n",
       "      <td>1285.111111</td>\n",
       "      <td>1213.888889</td>\n",
       "      <td>875.222222</td>\n",
       "      <td>610.888889</td>\n",
       "      <td>455.333333</td>\n",
       "      <td>367.777778</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2490 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    ID  12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  \\\n",
       "Segment ID year                                                                \n",
       "202        2014  200.0     305.000000   222.000000   137.000000   138.000000   \n",
       "646        2012  779.5      28.250000    25.375000    19.000000    16.375000   \n",
       "1416       2015  290.0      61.722222    35.833333    19.388889    17.388889   \n",
       "1421       2012  670.5      53.750000    30.250000    21.750000    19.000000   \n",
       "1883       2012  686.0      57.000000    30.500000    19.000000     6.500000   \n",
       "...                ...            ...          ...          ...          ...   \n",
       "9014615    2014  125.0     652.777778   473.777778   337.000000   252.888889   \n",
       "9014764    2014  135.0    1592.222222  1049.111111   798.888889   706.444444   \n",
       "9017020    2014    5.0     370.000000   260.555556   192.888889   169.555556   \n",
       "9017037    2014  255.0     174.222222   111.333333    78.555556    68.000000   \n",
       "9017039    2014  255.0     260.777778   166.888889   125.333333   103.888889   \n",
       "\n",
       "                 4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  7:00-8:00AM  \\\n",
       "Segment ID year                                                       \n",
       "202        2014   114.000000   155.000000   283.000000   355.000000   \n",
       "646        2012    26.375000    51.875000    97.250000   134.250000   \n",
       "1416       2015    26.388889    54.000000   118.000000   217.277778   \n",
       "1421       2012    25.125000    55.000000   151.500000   315.500000   \n",
       "1883       2012    19.500000    52.500000   134.500000   422.500000   \n",
       "...                      ...          ...          ...          ...   \n",
       "9014615    2014   300.777778   445.000000  1368.111111  2364.444444   \n",
       "9014764    2014   768.333333  1264.111111  2587.888889  3070.444444   \n",
       "9017020    2014   188.333333   333.777778   832.555556  1077.222222   \n",
       "9017037    2014   120.777778   329.555556   708.222222   976.666667   \n",
       "9017039    2014   113.888889   148.888889   259.666667   554.222222   \n",
       "\n",
       "                 8:00-9:00AM  9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  \\\n",
       "Segment ID year                                                            \n",
       "202        2014   485.000000    549.000000     550.000000     555.000000   \n",
       "646        2012   182.750000    211.500000     200.875000     236.125000   \n",
       "1416       2015   246.222222    218.333333     261.555556     293.722222   \n",
       "1421       2012   353.375000    213.000000     219.625000     259.250000   \n",
       "1883       2012   352.000000    206.000000     207.000000     253.000000   \n",
       "...                      ...           ...            ...            ...   \n",
       "9014615    2014  2401.777778   1972.000000    1733.888889    1761.111111   \n",
       "9014764    2014  3149.333333   3156.777778    3050.333333    3144.888889   \n",
       "9017020    2014  1019.777778    965.888889     940.222222    1038.444444   \n",
       "9017037    2014   934.555556    893.111111     840.111111     820.111111   \n",
       "9017039    2014   823.666667    807.333333     717.888889     700.000000   \n",
       "\n",
       "                 12:00-1:00PM  1:00-2:00PM  2:00-3:00PM  3:00-4:00PM  \\\n",
       "Segment ID year                                                        \n",
       "202        2014    621.000000   630.000000   665.000000   649.000000   \n",
       "646        2012    250.375000   271.125000   263.625000   293.875000   \n",
       "1416       2015    312.055556   326.111111   352.833333   348.888889   \n",
       "1421       2012    287.125000   294.125000   352.125000   400.375000   \n",
       "1883       2012    289.000000   311.000000   367.000000   428.500000   \n",
       "...                       ...          ...          ...          ...   \n",
       "9014615    2014   1793.333333  1802.555556  1987.222222  2151.888889   \n",
       "9014764    2014   3203.222222  3348.777778  3573.555556  3420.555556   \n",
       "9017020    2014   1046.666667  1095.666667  1159.666667  1110.222222   \n",
       "9017037    2014    800.888889   757.777778   806.444444   777.777778   \n",
       "9017039    2014    752.666667   870.111111  1080.888889  1470.666667   \n",
       "\n",
       "                 4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  7:00-8:00PM  \\\n",
       "Segment ID year                                                       \n",
       "202        2014   671.000000   700.000000   658.000000   646.000000   \n",
       "646        2012   290.750000   225.875000   183.000000   152.625000   \n",
       "1416       2015   346.888889   353.166667   319.611111   261.777778   \n",
       "1421       2012   395.375000   410.375000   366.250000   315.625000   \n",
       "1883       2012   379.500000   371.000000   325.000000   276.500000   \n",
       "...                      ...          ...          ...          ...   \n",
       "9014615    2014  2167.333333  2181.666667  1990.444444  1803.444444   \n",
       "9014764    2014  3463.888889  3577.111111  3552.111111  3339.333333   \n",
       "9017020    2014  1201.111111  1228.888889  1201.000000   995.000000   \n",
       "9017037    2014   786.000000   741.222222   691.222222   602.444444   \n",
       "9017039    2014  1524.444444  1441.333333  1285.111111  1213.888889   \n",
       "\n",
       "                 8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \n",
       "Segment ID year                                                           \n",
       "202        2014   707.000000    620.000000     540.000000     504.000000  \n",
       "646        2012    94.875000     72.000000      43.000000      34.875000  \n",
       "1416       2015   210.333333    156.055556     113.666667      81.166667  \n",
       "1421       2012   183.625000    140.125000      87.875000      61.750000  \n",
       "1883       2012   223.000000    185.500000     119.500000      89.000000  \n",
       "...                      ...           ...            ...            ...  \n",
       "9014615    2014  1511.555556   1162.333333     972.444444     821.777778  \n",
       "9014764    2014  3183.555556   2876.777778    2636.000000    2023.888889  \n",
       "9017020    2014   779.333333    661.555556     610.000000     535.222222  \n",
       "9017037    2014   524.000000    416.666667     368.444444     267.222222  \n",
       "9017039    2014   875.222222    610.888889     455.333333     367.777778  \n",
       "\n",
       "[2490 rows x 25 columns]"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_df = test_df.sort_values(by=['Segment ID','year'], ascending=[True, True])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_df.drop('ID', axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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",
       "    <tr>\n",
       "      <th>Segment ID</th>\n",
       "      <th>year</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <th>2014</th>\n",
       "      <td>305.000000</td>\n",
       "      <td>222.000000</td>\n",
       "      <td>137.000000</td>\n",
       "      <td>138.000000</td>\n",
       "      <td>114.000000</td>\n",
       "      <td>155.000000</td>\n",
       "      <td>283.000000</td>\n",
       "      <td>355.000000</td>\n",
       "      <td>485.000000</td>\n",
       "      <td>549.000000</td>\n",
       "      <td>550.000000</td>\n",
       "      <td>555.000000</td>\n",
       "      <td>621.000000</td>\n",
       "      <td>630.000000</td>\n",
       "      <td>665.000000</td>\n",
       "      <td>649.000000</td>\n",
       "      <td>671.000000</td>\n",
       "      <td>700.000000</td>\n",
       "      <td>658.000000</td>\n",
       "      <td>646.000000</td>\n",
       "      <td>707.000000</td>\n",
       "      <td>620.000000</td>\n",
       "      <td>540.000000</td>\n",
       "      <td>504.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>646</th>\n",
       "      <th>2012</th>\n",
       "      <td>28.250000</td>\n",
       "      <td>25.375000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>16.375000</td>\n",
       "      <td>26.375000</td>\n",
       "      <td>51.875000</td>\n",
       "      <td>97.250000</td>\n",
       "      <td>134.250000</td>\n",
       "      <td>182.750000</td>\n",
       "      <td>211.500000</td>\n",
       "      <td>200.875000</td>\n",
       "      <td>236.125000</td>\n",
       "      <td>250.375000</td>\n",
       "      <td>271.125000</td>\n",
       "      <td>263.625000</td>\n",
       "      <td>293.875000</td>\n",
       "      <td>290.750000</td>\n",
       "      <td>225.875000</td>\n",
       "      <td>183.000000</td>\n",
       "      <td>152.625000</td>\n",
       "      <td>94.875000</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>43.000000</td>\n",
       "      <td>34.875000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1416</th>\n",
       "      <th>2015</th>\n",
       "      <td>61.722222</td>\n",
       "      <td>35.833333</td>\n",
       "      <td>19.388889</td>\n",
       "      <td>17.388889</td>\n",
       "      <td>26.388889</td>\n",
       "      <td>54.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>217.277778</td>\n",
       "      <td>246.222222</td>\n",
       "      <td>218.333333</td>\n",
       "      <td>261.555556</td>\n",
       "      <td>293.722222</td>\n",
       "      <td>312.055556</td>\n",
       "      <td>326.111111</td>\n",
       "      <td>352.833333</td>\n",
       "      <td>348.888889</td>\n",
       "      <td>346.888889</td>\n",
       "      <td>353.166667</td>\n",
       "      <td>319.611111</td>\n",
       "      <td>261.777778</td>\n",
       "      <td>210.333333</td>\n",
       "      <td>156.055556</td>\n",
       "      <td>113.666667</td>\n",
       "      <td>81.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421</th>\n",
       "      <th>2012</th>\n",
       "      <td>53.750000</td>\n",
       "      <td>30.250000</td>\n",
       "      <td>21.750000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>25.125000</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>151.500000</td>\n",
       "      <td>315.500000</td>\n",
       "      <td>353.375000</td>\n",
       "      <td>213.000000</td>\n",
       "      <td>219.625000</td>\n",
       "      <td>259.250000</td>\n",
       "      <td>287.125000</td>\n",
       "      <td>294.125000</td>\n",
       "      <td>352.125000</td>\n",
       "      <td>400.375000</td>\n",
       "      <td>395.375000</td>\n",
       "      <td>410.375000</td>\n",
       "      <td>366.250000</td>\n",
       "      <td>315.625000</td>\n",
       "      <td>183.625000</td>\n",
       "      <td>140.125000</td>\n",
       "      <td>87.875000</td>\n",
       "      <td>61.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1883</th>\n",
       "      <th>2012</th>\n",
       "      <td>57.000000</td>\n",
       "      <td>30.500000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>19.500000</td>\n",
       "      <td>52.500000</td>\n",
       "      <td>134.500000</td>\n",
       "      <td>422.500000</td>\n",
       "      <td>352.000000</td>\n",
       "      <td>206.000000</td>\n",
       "      <td>207.000000</td>\n",
       "      <td>253.000000</td>\n",
       "      <td>289.000000</td>\n",
       "      <td>311.000000</td>\n",
       "      <td>367.000000</td>\n",
       "      <td>428.500000</td>\n",
       "      <td>379.500000</td>\n",
       "      <td>371.000000</td>\n",
       "      <td>325.000000</td>\n",
       "      <td>276.500000</td>\n",
       "      <td>223.000000</td>\n",
       "      <td>185.500000</td>\n",
       "      <td>119.500000</td>\n",
       "      <td>89.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9014615</th>\n",
       "      <th>2014</th>\n",
       "      <td>652.777778</td>\n",
       "      <td>473.777778</td>\n",
       "      <td>337.000000</td>\n",
       "      <td>252.888889</td>\n",
       "      <td>300.777778</td>\n",
       "      <td>445.000000</td>\n",
       "      <td>1368.111111</td>\n",
       "      <td>2364.444444</td>\n",
       "      <td>2401.777778</td>\n",
       "      <td>1972.000000</td>\n",
       "      <td>1733.888889</td>\n",
       "      <td>1761.111111</td>\n",
       "      <td>1793.333333</td>\n",
       "      <td>1802.555556</td>\n",
       "      <td>1987.222222</td>\n",
       "      <td>2151.888889</td>\n",
       "      <td>2167.333333</td>\n",
       "      <td>2181.666667</td>\n",
       "      <td>1990.444444</td>\n",
       "      <td>1803.444444</td>\n",
       "      <td>1511.555556</td>\n",
       "      <td>1162.333333</td>\n",
       "      <td>972.444444</td>\n",
       "      <td>821.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9014764</th>\n",
       "      <th>2014</th>\n",
       "      <td>1592.222222</td>\n",
       "      <td>1049.111111</td>\n",
       "      <td>798.888889</td>\n",
       "      <td>706.444444</td>\n",
       "      <td>768.333333</td>\n",
       "      <td>1264.111111</td>\n",
       "      <td>2587.888889</td>\n",
       "      <td>3070.444444</td>\n",
       "      <td>3149.333333</td>\n",
       "      <td>3156.777778</td>\n",
       "      <td>3050.333333</td>\n",
       "      <td>3144.888889</td>\n",
       "      <td>3203.222222</td>\n",
       "      <td>3348.777778</td>\n",
       "      <td>3573.555556</td>\n",
       "      <td>3420.555556</td>\n",
       "      <td>3463.888889</td>\n",
       "      <td>3577.111111</td>\n",
       "      <td>3552.111111</td>\n",
       "      <td>3339.333333</td>\n",
       "      <td>3183.555556</td>\n",
       "      <td>2876.777778</td>\n",
       "      <td>2636.000000</td>\n",
       "      <td>2023.888889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017020</th>\n",
       "      <th>2014</th>\n",
       "      <td>370.000000</td>\n",
       "      <td>260.555556</td>\n",
       "      <td>192.888889</td>\n",
       "      <td>169.555556</td>\n",
       "      <td>188.333333</td>\n",
       "      <td>333.777778</td>\n",
       "      <td>832.555556</td>\n",
       "      <td>1077.222222</td>\n",
       "      <td>1019.777778</td>\n",
       "      <td>965.888889</td>\n",
       "      <td>940.222222</td>\n",
       "      <td>1038.444444</td>\n",
       "      <td>1046.666667</td>\n",
       "      <td>1095.666667</td>\n",
       "      <td>1159.666667</td>\n",
       "      <td>1110.222222</td>\n",
       "      <td>1201.111111</td>\n",
       "      <td>1228.888889</td>\n",
       "      <td>1201.000000</td>\n",
       "      <td>995.000000</td>\n",
       "      <td>779.333333</td>\n",
       "      <td>661.555556</td>\n",
       "      <td>610.000000</td>\n",
       "      <td>535.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017037</th>\n",
       "      <th>2014</th>\n",
       "      <td>174.222222</td>\n",
       "      <td>111.333333</td>\n",
       "      <td>78.555556</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>120.777778</td>\n",
       "      <td>329.555556</td>\n",
       "      <td>708.222222</td>\n",
       "      <td>976.666667</td>\n",
       "      <td>934.555556</td>\n",
       "      <td>893.111111</td>\n",
       "      <td>840.111111</td>\n",
       "      <td>820.111111</td>\n",
       "      <td>800.888889</td>\n",
       "      <td>757.777778</td>\n",
       "      <td>806.444444</td>\n",
       "      <td>777.777778</td>\n",
       "      <td>786.000000</td>\n",
       "      <td>741.222222</td>\n",
       "      <td>691.222222</td>\n",
       "      <td>602.444444</td>\n",
       "      <td>524.000000</td>\n",
       "      <td>416.666667</td>\n",
       "      <td>368.444444</td>\n",
       "      <td>267.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017039</th>\n",
       "      <th>2014</th>\n",
       "      <td>260.777778</td>\n",
       "      <td>166.888889</td>\n",
       "      <td>125.333333</td>\n",
       "      <td>103.888889</td>\n",
       "      <td>113.888889</td>\n",
       "      <td>148.888889</td>\n",
       "      <td>259.666667</td>\n",
       "      <td>554.222222</td>\n",
       "      <td>823.666667</td>\n",
       "      <td>807.333333</td>\n",
       "      <td>717.888889</td>\n",
       "      <td>700.000000</td>\n",
       "      <td>752.666667</td>\n",
       "      <td>870.111111</td>\n",
       "      <td>1080.888889</td>\n",
       "      <td>1470.666667</td>\n",
       "      <td>1524.444444</td>\n",
       "      <td>1441.333333</td>\n",
       "      <td>1285.111111</td>\n",
       "      <td>1213.888889</td>\n",
       "      <td>875.222222</td>\n",
       "      <td>610.888889</td>\n",
       "      <td>455.333333</td>\n",
       "      <td>367.777778</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2490 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  \\\n",
       "Segment ID year                                                         \n",
       "202        2014     305.000000   222.000000   137.000000   138.000000   \n",
       "646        2012      28.250000    25.375000    19.000000    16.375000   \n",
       "1416       2015      61.722222    35.833333    19.388889    17.388889   \n",
       "1421       2012      53.750000    30.250000    21.750000    19.000000   \n",
       "1883       2012      57.000000    30.500000    19.000000     6.500000   \n",
       "...                        ...          ...          ...          ...   \n",
       "9014615    2014     652.777778   473.777778   337.000000   252.888889   \n",
       "9014764    2014    1592.222222  1049.111111   798.888889   706.444444   \n",
       "9017020    2014     370.000000   260.555556   192.888889   169.555556   \n",
       "9017037    2014     174.222222   111.333333    78.555556    68.000000   \n",
       "9017039    2014     260.777778   166.888889   125.333333   103.888889   \n",
       "\n",
       "                 4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  7:00-8:00AM  \\\n",
       "Segment ID year                                                       \n",
       "202        2014   114.000000   155.000000   283.000000   355.000000   \n",
       "646        2012    26.375000    51.875000    97.250000   134.250000   \n",
       "1416       2015    26.388889    54.000000   118.000000   217.277778   \n",
       "1421       2012    25.125000    55.000000   151.500000   315.500000   \n",
       "1883       2012    19.500000    52.500000   134.500000   422.500000   \n",
       "...                      ...          ...          ...          ...   \n",
       "9014615    2014   300.777778   445.000000  1368.111111  2364.444444   \n",
       "9014764    2014   768.333333  1264.111111  2587.888889  3070.444444   \n",
       "9017020    2014   188.333333   333.777778   832.555556  1077.222222   \n",
       "9017037    2014   120.777778   329.555556   708.222222   976.666667   \n",
       "9017039    2014   113.888889   148.888889   259.666667   554.222222   \n",
       "\n",
       "                 8:00-9:00AM  9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  \\\n",
       "Segment ID year                                                            \n",
       "202        2014   485.000000    549.000000     550.000000     555.000000   \n",
       "646        2012   182.750000    211.500000     200.875000     236.125000   \n",
       "1416       2015   246.222222    218.333333     261.555556     293.722222   \n",
       "1421       2012   353.375000    213.000000     219.625000     259.250000   \n",
       "1883       2012   352.000000    206.000000     207.000000     253.000000   \n",
       "...                      ...           ...            ...            ...   \n",
       "9014615    2014  2401.777778   1972.000000    1733.888889    1761.111111   \n",
       "9014764    2014  3149.333333   3156.777778    3050.333333    3144.888889   \n",
       "9017020    2014  1019.777778    965.888889     940.222222    1038.444444   \n",
       "9017037    2014   934.555556    893.111111     840.111111     820.111111   \n",
       "9017039    2014   823.666667    807.333333     717.888889     700.000000   \n",
       "\n",
       "                 12:00-1:00PM  1:00-2:00PM  2:00-3:00PM  3:00-4:00PM  \\\n",
       "Segment ID year                                                        \n",
       "202        2014    621.000000   630.000000   665.000000   649.000000   \n",
       "646        2012    250.375000   271.125000   263.625000   293.875000   \n",
       "1416       2015    312.055556   326.111111   352.833333   348.888889   \n",
       "1421       2012    287.125000   294.125000   352.125000   400.375000   \n",
       "1883       2012    289.000000   311.000000   367.000000   428.500000   \n",
       "...                       ...          ...          ...          ...   \n",
       "9014615    2014   1793.333333  1802.555556  1987.222222  2151.888889   \n",
       "9014764    2014   3203.222222  3348.777778  3573.555556  3420.555556   \n",
       "9017020    2014   1046.666667  1095.666667  1159.666667  1110.222222   \n",
       "9017037    2014    800.888889   757.777778   806.444444   777.777778   \n",
       "9017039    2014    752.666667   870.111111  1080.888889  1470.666667   \n",
       "\n",
       "                 4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  7:00-8:00PM  \\\n",
       "Segment ID year                                                       \n",
       "202        2014   671.000000   700.000000   658.000000   646.000000   \n",
       "646        2012   290.750000   225.875000   183.000000   152.625000   \n",
       "1416       2015   346.888889   353.166667   319.611111   261.777778   \n",
       "1421       2012   395.375000   410.375000   366.250000   315.625000   \n",
       "1883       2012   379.500000   371.000000   325.000000   276.500000   \n",
       "...                      ...          ...          ...          ...   \n",
       "9014615    2014  2167.333333  2181.666667  1990.444444  1803.444444   \n",
       "9014764    2014  3463.888889  3577.111111  3552.111111  3339.333333   \n",
       "9017020    2014  1201.111111  1228.888889  1201.000000   995.000000   \n",
       "9017037    2014   786.000000   741.222222   691.222222   602.444444   \n",
       "9017039    2014  1524.444444  1441.333333  1285.111111  1213.888889   \n",
       "\n",
       "                 8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \n",
       "Segment ID year                                                           \n",
       "202        2014   707.000000    620.000000     540.000000     504.000000  \n",
       "646        2012    94.875000     72.000000      43.000000      34.875000  \n",
       "1416       2015   210.333333    156.055556     113.666667      81.166667  \n",
       "1421       2012   183.625000    140.125000      87.875000      61.750000  \n",
       "1883       2012   223.000000    185.500000     119.500000      89.000000  \n",
       "...                      ...           ...            ...            ...  \n",
       "9014615    2014  1511.555556   1162.333333     972.444444     821.777778  \n",
       "9014764    2014  3183.555556   2876.777778    2636.000000    2023.888889  \n",
       "9017020    2014   779.333333    661.555556     610.000000     535.222222  \n",
       "9017037    2014   524.000000    416.666667     368.444444     267.222222  \n",
       "9017039    2014   875.222222    610.888889     455.333333     367.777778  \n",
       "\n",
       "[2490 rows x 24 columns]"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_df['total'] = test_df.sum(axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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",
       "      <th>total</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Segment ID</th>\n",
       "      <th>year</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <th>2014</th>\n",
       "      <td>305.000000</td>\n",
       "      <td>222.000000</td>\n",
       "      <td>137.000000</td>\n",
       "      <td>138.000000</td>\n",
       "      <td>114.000000</td>\n",
       "      <td>155.000000</td>\n",
       "      <td>283.000000</td>\n",
       "      <td>355.000000</td>\n",
       "      <td>485.000000</td>\n",
       "      <td>549.000000</td>\n",
       "      <td>550.000000</td>\n",
       "      <td>555.000000</td>\n",
       "      <td>621.000000</td>\n",
       "      <td>630.000000</td>\n",
       "      <td>665.000000</td>\n",
       "      <td>649.000000</td>\n",
       "      <td>671.000000</td>\n",
       "      <td>700.000000</td>\n",
       "      <td>658.000000</td>\n",
       "      <td>646.000000</td>\n",
       "      <td>707.000000</td>\n",
       "      <td>620.000000</td>\n",
       "      <td>540.000000</td>\n",
       "      <td>504.000000</td>\n",
       "      <td>11459.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>646</th>\n",
       "      <th>2012</th>\n",
       "      <td>28.250000</td>\n",
       "      <td>25.375000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>16.375000</td>\n",
       "      <td>26.375000</td>\n",
       "      <td>51.875000</td>\n",
       "      <td>97.250000</td>\n",
       "      <td>134.250000</td>\n",
       "      <td>182.750000</td>\n",
       "      <td>211.500000</td>\n",
       "      <td>200.875000</td>\n",
       "      <td>236.125000</td>\n",
       "      <td>250.375000</td>\n",
       "      <td>271.125000</td>\n",
       "      <td>263.625000</td>\n",
       "      <td>293.875000</td>\n",
       "      <td>290.750000</td>\n",
       "      <td>225.875000</td>\n",
       "      <td>183.000000</td>\n",
       "      <td>152.625000</td>\n",
       "      <td>94.875000</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>43.000000</td>\n",
       "      <td>34.875000</td>\n",
       "      <td>3406.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1416</th>\n",
       "      <th>2015</th>\n",
       "      <td>61.722222</td>\n",
       "      <td>35.833333</td>\n",
       "      <td>19.388889</td>\n",
       "      <td>17.388889</td>\n",
       "      <td>26.388889</td>\n",
       "      <td>54.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>217.277778</td>\n",
       "      <td>246.222222</td>\n",
       "      <td>218.333333</td>\n",
       "      <td>261.555556</td>\n",
       "      <td>293.722222</td>\n",
       "      <td>312.055556</td>\n",
       "      <td>326.111111</td>\n",
       "      <td>352.833333</td>\n",
       "      <td>348.888889</td>\n",
       "      <td>346.888889</td>\n",
       "      <td>353.166667</td>\n",
       "      <td>319.611111</td>\n",
       "      <td>261.777778</td>\n",
       "      <td>210.333333</td>\n",
       "      <td>156.055556</td>\n",
       "      <td>113.666667</td>\n",
       "      <td>81.166667</td>\n",
       "      <td>4752.388889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1421</th>\n",
       "      <th>2012</th>\n",
       "      <td>53.750000</td>\n",
       "      <td>30.250000</td>\n",
       "      <td>21.750000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>25.125000</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>151.500000</td>\n",
       "      <td>315.500000</td>\n",
       "      <td>353.375000</td>\n",
       "      <td>213.000000</td>\n",
       "      <td>219.625000</td>\n",
       "      <td>259.250000</td>\n",
       "      <td>287.125000</td>\n",
       "      <td>294.125000</td>\n",
       "      <td>352.125000</td>\n",
       "      <td>400.375000</td>\n",
       "      <td>395.375000</td>\n",
       "      <td>410.375000</td>\n",
       "      <td>366.250000</td>\n",
       "      <td>315.625000</td>\n",
       "      <td>183.625000</td>\n",
       "      <td>140.125000</td>\n",
       "      <td>87.875000</td>\n",
       "      <td>61.750000</td>\n",
       "      <td>5011.875000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1883</th>\n",
       "      <th>2012</th>\n",
       "      <td>57.000000</td>\n",
       "      <td>30.500000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>19.500000</td>\n",
       "      <td>52.500000</td>\n",
       "      <td>134.500000</td>\n",
       "      <td>422.500000</td>\n",
       "      <td>352.000000</td>\n",
       "      <td>206.000000</td>\n",
       "      <td>207.000000</td>\n",
       "      <td>253.000000</td>\n",
       "      <td>289.000000</td>\n",
       "      <td>311.000000</td>\n",
       "      <td>367.000000</td>\n",
       "      <td>428.500000</td>\n",
       "      <td>379.500000</td>\n",
       "      <td>371.000000</td>\n",
       "      <td>325.000000</td>\n",
       "      <td>276.500000</td>\n",
       "      <td>223.000000</td>\n",
       "      <td>185.500000</td>\n",
       "      <td>119.500000</td>\n",
       "      <td>89.000000</td>\n",
       "      <td>5124.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9014615</th>\n",
       "      <th>2014</th>\n",
       "      <td>652.777778</td>\n",
       "      <td>473.777778</td>\n",
       "      <td>337.000000</td>\n",
       "      <td>252.888889</td>\n",
       "      <td>300.777778</td>\n",
       "      <td>445.000000</td>\n",
       "      <td>1368.111111</td>\n",
       "      <td>2364.444444</td>\n",
       "      <td>2401.777778</td>\n",
       "      <td>1972.000000</td>\n",
       "      <td>1733.888889</td>\n",
       "      <td>1761.111111</td>\n",
       "      <td>1793.333333</td>\n",
       "      <td>1802.555556</td>\n",
       "      <td>1987.222222</td>\n",
       "      <td>2151.888889</td>\n",
       "      <td>2167.333333</td>\n",
       "      <td>2181.666667</td>\n",
       "      <td>1990.444444</td>\n",
       "      <td>1803.444444</td>\n",
       "      <td>1511.555556</td>\n",
       "      <td>1162.333333</td>\n",
       "      <td>972.444444</td>\n",
       "      <td>821.777778</td>\n",
       "      <td>34409.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9014764</th>\n",
       "      <th>2014</th>\n",
       "      <td>1592.222222</td>\n",
       "      <td>1049.111111</td>\n",
       "      <td>798.888889</td>\n",
       "      <td>706.444444</td>\n",
       "      <td>768.333333</td>\n",
       "      <td>1264.111111</td>\n",
       "      <td>2587.888889</td>\n",
       "      <td>3070.444444</td>\n",
       "      <td>3149.333333</td>\n",
       "      <td>3156.777778</td>\n",
       "      <td>3050.333333</td>\n",
       "      <td>3144.888889</td>\n",
       "      <td>3203.222222</td>\n",
       "      <td>3348.777778</td>\n",
       "      <td>3573.555556</td>\n",
       "      <td>3420.555556</td>\n",
       "      <td>3463.888889</td>\n",
       "      <td>3577.111111</td>\n",
       "      <td>3552.111111</td>\n",
       "      <td>3339.333333</td>\n",
       "      <td>3183.555556</td>\n",
       "      <td>2876.777778</td>\n",
       "      <td>2636.000000</td>\n",
       "      <td>2023.888889</td>\n",
       "      <td>62537.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017020</th>\n",
       "      <th>2014</th>\n",
       "      <td>370.000000</td>\n",
       "      <td>260.555556</td>\n",
       "      <td>192.888889</td>\n",
       "      <td>169.555556</td>\n",
       "      <td>188.333333</td>\n",
       "      <td>333.777778</td>\n",
       "      <td>832.555556</td>\n",
       "      <td>1077.222222</td>\n",
       "      <td>1019.777778</td>\n",
       "      <td>965.888889</td>\n",
       "      <td>940.222222</td>\n",
       "      <td>1038.444444</td>\n",
       "      <td>1046.666667</td>\n",
       "      <td>1095.666667</td>\n",
       "      <td>1159.666667</td>\n",
       "      <td>1110.222222</td>\n",
       "      <td>1201.111111</td>\n",
       "      <td>1228.888889</td>\n",
       "      <td>1201.000000</td>\n",
       "      <td>995.000000</td>\n",
       "      <td>779.333333</td>\n",
       "      <td>661.555556</td>\n",
       "      <td>610.000000</td>\n",
       "      <td>535.222222</td>\n",
       "      <td>19013.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017037</th>\n",
       "      <th>2014</th>\n",
       "      <td>174.222222</td>\n",
       "      <td>111.333333</td>\n",
       "      <td>78.555556</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>120.777778</td>\n",
       "      <td>329.555556</td>\n",
       "      <td>708.222222</td>\n",
       "      <td>976.666667</td>\n",
       "      <td>934.555556</td>\n",
       "      <td>893.111111</td>\n",
       "      <td>840.111111</td>\n",
       "      <td>820.111111</td>\n",
       "      <td>800.888889</td>\n",
       "      <td>757.777778</td>\n",
       "      <td>806.444444</td>\n",
       "      <td>777.777778</td>\n",
       "      <td>786.000000</td>\n",
       "      <td>741.222222</td>\n",
       "      <td>691.222222</td>\n",
       "      <td>602.444444</td>\n",
       "      <td>524.000000</td>\n",
       "      <td>416.666667</td>\n",
       "      <td>368.444444</td>\n",
       "      <td>267.222222</td>\n",
       "      <td>13595.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017039</th>\n",
       "      <th>2014</th>\n",
       "      <td>260.777778</td>\n",
       "      <td>166.888889</td>\n",
       "      <td>125.333333</td>\n",
       "      <td>103.888889</td>\n",
       "      <td>113.888889</td>\n",
       "      <td>148.888889</td>\n",
       "      <td>259.666667</td>\n",
       "      <td>554.222222</td>\n",
       "      <td>823.666667</td>\n",
       "      <td>807.333333</td>\n",
       "      <td>717.888889</td>\n",
       "      <td>700.000000</td>\n",
       "      <td>752.666667</td>\n",
       "      <td>870.111111</td>\n",
       "      <td>1080.888889</td>\n",
       "      <td>1470.666667</td>\n",
       "      <td>1524.444444</td>\n",
       "      <td>1441.333333</td>\n",
       "      <td>1285.111111</td>\n",
       "      <td>1213.888889</td>\n",
       "      <td>875.222222</td>\n",
       "      <td>610.888889</td>\n",
       "      <td>455.333333</td>\n",
       "      <td>367.777778</td>\n",
       "      <td>16730.777778</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2490 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  \\\n",
       "Segment ID year                                                         \n",
       "202        2014     305.000000   222.000000   137.000000   138.000000   \n",
       "646        2012      28.250000    25.375000    19.000000    16.375000   \n",
       "1416       2015      61.722222    35.833333    19.388889    17.388889   \n",
       "1421       2012      53.750000    30.250000    21.750000    19.000000   \n",
       "1883       2012      57.000000    30.500000    19.000000     6.500000   \n",
       "...                        ...          ...          ...          ...   \n",
       "9014615    2014     652.777778   473.777778   337.000000   252.888889   \n",
       "9014764    2014    1592.222222  1049.111111   798.888889   706.444444   \n",
       "9017020    2014     370.000000   260.555556   192.888889   169.555556   \n",
       "9017037    2014     174.222222   111.333333    78.555556    68.000000   \n",
       "9017039    2014     260.777778   166.888889   125.333333   103.888889   \n",
       "\n",
       "                 4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  7:00-8:00AM  \\\n",
       "Segment ID year                                                       \n",
       "202        2014   114.000000   155.000000   283.000000   355.000000   \n",
       "646        2012    26.375000    51.875000    97.250000   134.250000   \n",
       "1416       2015    26.388889    54.000000   118.000000   217.277778   \n",
       "1421       2012    25.125000    55.000000   151.500000   315.500000   \n",
       "1883       2012    19.500000    52.500000   134.500000   422.500000   \n",
       "...                      ...          ...          ...          ...   \n",
       "9014615    2014   300.777778   445.000000  1368.111111  2364.444444   \n",
       "9014764    2014   768.333333  1264.111111  2587.888889  3070.444444   \n",
       "9017020    2014   188.333333   333.777778   832.555556  1077.222222   \n",
       "9017037    2014   120.777778   329.555556   708.222222   976.666667   \n",
       "9017039    2014   113.888889   148.888889   259.666667   554.222222   \n",
       "\n",
       "                 8:00-9:00AM  9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  \\\n",
       "Segment ID year                                                            \n",
       "202        2014   485.000000    549.000000     550.000000     555.000000   \n",
       "646        2012   182.750000    211.500000     200.875000     236.125000   \n",
       "1416       2015   246.222222    218.333333     261.555556     293.722222   \n",
       "1421       2012   353.375000    213.000000     219.625000     259.250000   \n",
       "1883       2012   352.000000    206.000000     207.000000     253.000000   \n",
       "...                      ...           ...            ...            ...   \n",
       "9014615    2014  2401.777778   1972.000000    1733.888889    1761.111111   \n",
       "9014764    2014  3149.333333   3156.777778    3050.333333    3144.888889   \n",
       "9017020    2014  1019.777778    965.888889     940.222222    1038.444444   \n",
       "9017037    2014   934.555556    893.111111     840.111111     820.111111   \n",
       "9017039    2014   823.666667    807.333333     717.888889     700.000000   \n",
       "\n",
       "                 12:00-1:00PM  1:00-2:00PM  2:00-3:00PM  3:00-4:00PM  \\\n",
       "Segment ID year                                                        \n",
       "202        2014    621.000000   630.000000   665.000000   649.000000   \n",
       "646        2012    250.375000   271.125000   263.625000   293.875000   \n",
       "1416       2015    312.055556   326.111111   352.833333   348.888889   \n",
       "1421       2012    287.125000   294.125000   352.125000   400.375000   \n",
       "1883       2012    289.000000   311.000000   367.000000   428.500000   \n",
       "...                       ...          ...          ...          ...   \n",
       "9014615    2014   1793.333333  1802.555556  1987.222222  2151.888889   \n",
       "9014764    2014   3203.222222  3348.777778  3573.555556  3420.555556   \n",
       "9017020    2014   1046.666667  1095.666667  1159.666667  1110.222222   \n",
       "9017037    2014    800.888889   757.777778   806.444444   777.777778   \n",
       "9017039    2014    752.666667   870.111111  1080.888889  1470.666667   \n",
       "\n",
       "                 4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  7:00-8:00PM  \\\n",
       "Segment ID year                                                       \n",
       "202        2014   671.000000   700.000000   658.000000   646.000000   \n",
       "646        2012   290.750000   225.875000   183.000000   152.625000   \n",
       "1416       2015   346.888889   353.166667   319.611111   261.777778   \n",
       "1421       2012   395.375000   410.375000   366.250000   315.625000   \n",
       "1883       2012   379.500000   371.000000   325.000000   276.500000   \n",
       "...                      ...          ...          ...          ...   \n",
       "9014615    2014  2167.333333  2181.666667  1990.444444  1803.444444   \n",
       "9014764    2014  3463.888889  3577.111111  3552.111111  3339.333333   \n",
       "9017020    2014  1201.111111  1228.888889  1201.000000   995.000000   \n",
       "9017037    2014   786.000000   741.222222   691.222222   602.444444   \n",
       "9017039    2014  1524.444444  1441.333333  1285.111111  1213.888889   \n",
       "\n",
       "                 8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \\\n",
       "Segment ID year                                                            \n",
       "202        2014   707.000000    620.000000     540.000000     504.000000   \n",
       "646        2012    94.875000     72.000000      43.000000      34.875000   \n",
       "1416       2015   210.333333    156.055556     113.666667      81.166667   \n",
       "1421       2012   183.625000    140.125000      87.875000      61.750000   \n",
       "1883       2012   223.000000    185.500000     119.500000      89.000000   \n",
       "...                      ...           ...            ...            ...   \n",
       "9014615    2014  1511.555556   1162.333333     972.444444     821.777778   \n",
       "9014764    2014  3183.555556   2876.777778    2636.000000    2023.888889   \n",
       "9017020    2014   779.333333    661.555556     610.000000     535.222222   \n",
       "9017037    2014   524.000000    416.666667     368.444444     267.222222   \n",
       "9017039    2014   875.222222    610.888889     455.333333     367.777778   \n",
       "\n",
       "                        total  \n",
       "Segment ID year                \n",
       "202        2014  11459.000000  \n",
       "646        2012   3406.000000  \n",
       "1416       2015   4752.388889  \n",
       "1421       2012   5011.875000  \n",
       "1883       2012   5124.500000  \n",
       "...                       ...  \n",
       "9014615    2014  34409.555556  \n",
       "9014764    2014  62537.555556  \n",
       "9017020    2014  19013.555556  \n",
       "9017037    2014  13595.333333  \n",
       "9017039    2014  16730.777778  \n",
       "\n",
       "[2490 rows x 25 columns]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Segment ID</th>\n",
       "      <th>Roadway Name</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Direction</th>\n",
       "      <th>Date</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>5:00-6:00AM</th>\n",
       "      <th>6:00-7:00AM</th>\n",
       "      <th>7:00-8:00AM</th>\n",
       "      <th>8:00-9:00AM</th>\n",
       "      <th>9:00-10:00AM</th>\n",
       "      <th>10:00-11:00AM</th>\n",
       "      <th>11:00-12:00PM</th>\n",
       "      <th>12:00-1:00PM</th>\n",
       "      <th>1:00-2:00PM</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",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>684</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>01/10/2012</td>\n",
       "      <td>64.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>318.0</td>\n",
       "      <td>305.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>392.0</td>\n",
       "      <td>489.0</td>\n",
       "      <td>424.0</td>\n",
       "      <td>433.0</td>\n",
       "      <td>383.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>296.0</td>\n",
       "      <td>229.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>688</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>01/10/2012</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>185.0</td>\n",
       "      <td>527.0</td>\n",
       "      <td>399.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>243.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>284.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>342.0</td>\n",
       "      <td>368.0</td>\n",
       "      <td>335.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>267.0</td>\n",
       "      <td>233.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9709</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>10/24/2015</td>\n",
       "      <td>104.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>293.0</td>\n",
       "      <td>394.0</td>\n",
       "      <td>421.0</td>\n",
       "      <td>352.0</td>\n",
       "      <td>327.0</td>\n",
       "      <td>351.0</td>\n",
       "      <td>341.0</td>\n",
       "      <td>348.0</td>\n",
       "      <td>398.0</td>\n",
       "      <td>289.0</td>\n",
       "      <td>286.0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9710</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>10/24/2015</td>\n",
       "      <td>66.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>233.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>355.0</td>\n",
       "      <td>398.0</td>\n",
       "      <td>386.0</td>\n",
       "      <td>341.0</td>\n",
       "      <td>329.0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>318.0</td>\n",
       "      <td>328.0</td>\n",
       "      <td>258.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9787</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>10/25/2015</td>\n",
       "      <td>130.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>185.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>284.0</td>\n",
       "      <td>388.0</td>\n",
       "      <td>361.0</td>\n",
       "      <td>353.0</td>\n",
       "      <td>323.0</td>\n",
       "      <td>325.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>297.0</td>\n",
       "      <td>267.0</td>\n",
       "      <td>215.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9788</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>10/25/2015</td>\n",
       "      <td>66.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>260.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>335.0</td>\n",
       "      <td>305.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>249.0</td>\n",
       "      <td>258.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>229.0</td>\n",
       "      <td>210.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9865</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>10/26/2015</td>\n",
       "      <td>40.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>246.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>296.0</td>\n",
       "      <td>404.0</td>\n",
       "      <td>478.0</td>\n",
       "      <td>475.0</td>\n",
       "      <td>457.0</td>\n",
       "      <td>432.0</td>\n",
       "      <td>337.0</td>\n",
       "      <td>254.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9866</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>10/26/2015</td>\n",
       "      <td>22.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>247.0</td>\n",
       "      <td>531.0</td>\n",
       "      <td>337.0</td>\n",
       "      <td>248.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>233.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>368.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>339.0</td>\n",
       "      <td>311.0</td>\n",
       "      <td>217.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9943</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>10/27/2015</td>\n",
       "      <td>31.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>313.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>202.0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>257.0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>409.0</td>\n",
       "      <td>431.0</td>\n",
       "      <td>448.0</td>\n",
       "      <td>451.0</td>\n",
       "      <td>447.0</td>\n",
       "      <td>358.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>195.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9944</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>10/27/2015</td>\n",
       "      <td>28.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td>459.0</td>\n",
       "      <td>322.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>212.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>211.0</td>\n",
       "      <td>287.0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>241.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10021</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>10/28/2015</td>\n",
       "      <td>54.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>244.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>406.0</td>\n",
       "      <td>386.0</td>\n",
       "      <td>390.0</td>\n",
       "      <td>407.0</td>\n",
       "      <td>373.0</td>\n",
       "      <td>285.0</td>\n",
       "      <td>256.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10022</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>10/28/2015</td>\n",
       "      <td>30.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>511.0</td>\n",
       "      <td>284.0</td>\n",
       "      <td>211.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>271.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>323.0</td>\n",
       "      <td>339.0</td>\n",
       "      <td>321.0</td>\n",
       "      <td>310.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>229.0</td>\n",
       "      <td>146.0</td>\n",
       "      <td>128.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10099</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>10/29/2015</td>\n",
       "      <td>37.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>184.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>227.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>416.0</td>\n",
       "      <td>399.0</td>\n",
       "      <td>425.0</td>\n",
       "      <td>408.0</td>\n",
       "      <td>417.0</td>\n",
       "      <td>359.0</td>\n",
       "      <td>280.0</td>\n",
       "      <td>212.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10100</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>10/29/2015</td>\n",
       "      <td>15.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>232.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>217.0</td>\n",
       "      <td>189.0</td>\n",
       "      <td>207.0</td>\n",
       "      <td>277.0</td>\n",
       "      <td>280.0</td>\n",
       "      <td>302.0</td>\n",
       "      <td>315.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>332.0</td>\n",
       "      <td>318.0</td>\n",
       "      <td>264.0</td>\n",
       "      <td>214.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10177</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>10/30/2015</td>\n",
       "      <td>51.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>295.0</td>\n",
       "      <td>223.0</td>\n",
       "      <td>241.0</td>\n",
       "      <td>272.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>328.0</td>\n",
       "      <td>458.0</td>\n",
       "      <td>456.0</td>\n",
       "      <td>493.0</td>\n",
       "      <td>441.0</td>\n",
       "      <td>484.0</td>\n",
       "      <td>394.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>191.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10178</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>10/30/2015</td>\n",
       "      <td>22.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>459.0</td>\n",
       "      <td>272.0</td>\n",
       "      <td>231.0</td>\n",
       "      <td>241.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>291.0</td>\n",
       "      <td>263.0</td>\n",
       "      <td>288.0</td>\n",
       "      <td>282.0</td>\n",
       "      <td>345.0</td>\n",
       "      <td>364.0</td>\n",
       "      <td>366.0</td>\n",
       "      <td>285.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10327</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>10/31/2015</td>\n",
       "      <td>101.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>289.0</td>\n",
       "      <td>397.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>382.0</td>\n",
       "      <td>441.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>382.0</td>\n",
       "      <td>394.0</td>\n",
       "      <td>334.0</td>\n",
       "      <td>309.0</td>\n",
       "      <td>247.0</td>\n",
       "      <td>242.0</td>\n",
       "      <td>159.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10328</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>10/31/2015</td>\n",
       "      <td>78.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>289.0</td>\n",
       "      <td>314.0</td>\n",
       "      <td>344.0</td>\n",
       "      <td>352.0</td>\n",
       "      <td>327.0</td>\n",
       "      <td>338.0</td>\n",
       "      <td>341.0</td>\n",
       "      <td>333.0</td>\n",
       "      <td>305.0</td>\n",
       "      <td>277.0</td>\n",
       "      <td>233.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10474</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>NB</td>\n",
       "      <td>11/01/2015</td>\n",
       "      <td>141.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>281.0</td>\n",
       "      <td>365.0</td>\n",
       "      <td>352.0</td>\n",
       "      <td>358.0</td>\n",
       "      <td>353.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>283.0</td>\n",
       "      <td>307.0</td>\n",
       "      <td>248.0</td>\n",
       "      <td>184.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10475</th>\n",
       "      <td>296</td>\n",
       "      <td>1883</td>\n",
       "      <td>FOSTER ROAD</td>\n",
       "      <td>RATHBUN AVENUE</td>\n",
       "      <td>RAMONA AVENUE</td>\n",
       "      <td>SB</td>\n",
       "      <td>11/01/2015</td>\n",
       "      <td>89.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>109.0</td>\n",
       "      <td>188.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>295.0</td>\n",
       "      <td>289.0</td>\n",
       "      <td>347.0</td>\n",
       "      <td>299.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>195.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        ID  Segment ID Roadway Name            From              To Direction  \\\n",
       "684    684        1883  FOSTER ROAD   RAMONA AVENUE  RATHBUN AVENUE        NB   \n",
       "688    688        1883  FOSTER ROAD   RAMONA AVENUE  RATHBUN AVENUE        SB   \n",
       "9709   296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        NB   \n",
       "9710   296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        SB   \n",
       "9787   296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        NB   \n",
       "9788   296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        SB   \n",
       "9865   296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        NB   \n",
       "9866   296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        SB   \n",
       "9943   296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        NB   \n",
       "9944   296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        SB   \n",
       "10021  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        NB   \n",
       "10022  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        SB   \n",
       "10099  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        NB   \n",
       "10100  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        SB   \n",
       "10177  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        NB   \n",
       "10178  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        SB   \n",
       "10327  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        NB   \n",
       "10328  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        SB   \n",
       "10474  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        NB   \n",
       "10475  296        1883  FOSTER ROAD  RATHBUN AVENUE   RAMONA AVENUE        SB   \n",
       "\n",
       "             Date  12:00-1:00 AM  1:00-2:00AM  2:00-3:00AM  3:00-4:00AM  \\\n",
       "684    01/10/2012           64.0         36.0         22.0         10.0   \n",
       "688    01/10/2012           50.0         25.0         16.0          3.0   \n",
       "9709   10/24/2015          104.0         65.0         44.0         21.0   \n",
       "9710   10/24/2015           66.0         46.0         20.0         17.0   \n",
       "9787   10/25/2015          130.0         80.0         44.0         37.0   \n",
       "9788   10/25/2015           66.0         53.0         31.0         19.0   \n",
       "9865   10/26/2015           40.0          8.0         12.0          3.0   \n",
       "9866   10/26/2015           22.0         11.0         20.0          5.0   \n",
       "9943   10/27/2015           31.0         24.0         15.0          4.0   \n",
       "9944   10/27/2015           28.0         13.0          9.0          4.0   \n",
       "10021  10/28/2015           54.0         47.0          9.0         11.0   \n",
       "10022  10/28/2015           30.0         22.0         10.0         12.0   \n",
       "10099  10/29/2015           37.0         20.0         19.0         10.0   \n",
       "10100  10/29/2015           15.0          4.0          6.0          6.0   \n",
       "10177  10/30/2015           51.0         32.0         10.0          7.0   \n",
       "10178  10/30/2015           22.0          9.0          7.0          4.0   \n",
       "10327  10/31/2015          101.0         73.0         35.0         24.0   \n",
       "10328  10/31/2015           78.0         43.0         28.0         12.0   \n",
       "10474  11/01/2015          141.0         99.0         31.0         23.0   \n",
       "10475  11/01/2015           89.0         58.0         20.0         23.0   \n",
       "\n",
       "       4:00-5:00AM  5:00-6:00AM  6:00-7:00AM  7:00-8:00AM  8:00-9:00AM  \\\n",
       "684           17.0         42.0         84.0        318.0        305.0   \n",
       "688           22.0         63.0        185.0        527.0        399.0   \n",
       "9709           9.0         30.0         42.0         90.0        174.0   \n",
       "9710          15.0         32.0         72.0        146.0        233.0   \n",
       "9787          19.0         20.0         23.0         80.0        112.0   \n",
       "9788          11.0         14.0         46.0         89.0        161.0   \n",
       "9865          19.0         60.0        121.0        309.0        319.0   \n",
       "9866          30.0         93.0        247.0        531.0        337.0   \n",
       "9943          20.0         58.0        114.0        278.0        313.0   \n",
       "9944          27.0         94.0        255.0        459.0        322.0   \n",
       "10021         20.0         56.0        106.0        244.0        278.0   \n",
       "10022         30.0         83.0        237.0        511.0        284.0   \n",
       "10099         17.0         59.0        125.0        240.0        275.0   \n",
       "10100         27.0         63.0        232.0        499.0        276.0   \n",
       "10177         23.0         49.0        122.0        279.0        295.0   \n",
       "10178         40.0         75.0        198.0        459.0        272.0   \n",
       "10327         14.0         20.0         40.0         81.0        148.0   \n",
       "10328         13.0         28.0         63.0        106.0        224.0   \n",
       "10474         19.0         16.0         46.0         86.0        139.0   \n",
       "10475         18.0         13.0         53.0        109.0        188.0   \n",
       "\n",
       "       9:00-10:00AM  10:00-11:00AM  11:00-12:00PM  12:00-1:00PM  1:00-2:00PM  \\\n",
       "684           186.0          171.0          253.0         294.0        311.0   \n",
       "688           226.0          243.0          253.0         284.0        311.0   \n",
       "9709          281.0          293.0          394.0         421.0        352.0   \n",
       "9710          340.0          355.0          398.0         386.0        341.0   \n",
       "9787          185.0          237.0          284.0         388.0        361.0   \n",
       "9788          259.0          260.0          309.0         335.0        305.0   \n",
       "9865          199.0          220.0          246.0         290.0        296.0   \n",
       "9866          248.0          275.0          233.0         281.0        276.0   \n",
       "9943          174.0          202.0          228.0         257.0        294.0   \n",
       "9944          194.0          212.0          183.0         174.0        211.0   \n",
       "10021         190.0          148.0          186.0         227.0        231.0   \n",
       "10022         211.0          190.0          194.0         271.0        319.0   \n",
       "10099         184.0          180.0          227.0         225.0        266.0   \n",
       "10100         217.0          189.0          207.0         277.0        280.0   \n",
       "10177         223.0          241.0          272.0         279.0        328.0   \n",
       "10178         231.0          241.0          198.0         291.0        263.0   \n",
       "10327         224.0          289.0          397.0         428.0        382.0   \n",
       "10328         289.0          314.0          344.0         352.0        327.0   \n",
       "10474         187.0          281.0          365.0         352.0        358.0   \n",
       "10475         224.0          295.0          289.0         347.0        299.0   \n",
       "\n",
       "       2:00-3:00PM  3:00-4:00PM  4:00-5:00PM  5:00-6:00PM  6:00-7:00PM  \\\n",
       "684          392.0        489.0        424.0        433.0        383.0   \n",
       "688          342.0        368.0        335.0        309.0        267.0   \n",
       "9709         327.0        351.0        341.0        348.0        398.0   \n",
       "9710         329.0        294.0        266.0        318.0        328.0   \n",
       "9787         353.0        323.0        325.0        311.0        297.0   \n",
       "9788         281.0        249.0        258.0        227.0        229.0   \n",
       "9865         404.0        478.0        475.0        457.0        432.0   \n",
       "9866         350.0        368.0        309.0        339.0        311.0   \n",
       "9943         409.0        431.0        448.0        451.0        447.0   \n",
       "9944         287.0        228.0        279.0        241.0        250.0   \n",
       "10021        406.0        386.0        390.0        407.0        373.0   \n",
       "10022        301.0        323.0        339.0        321.0        310.0   \n",
       "10099        416.0        399.0        425.0        408.0        417.0   \n",
       "10100        302.0        315.0        350.0        332.0        318.0   \n",
       "10177        458.0        456.0        493.0        441.0        484.0   \n",
       "10178        288.0        282.0        345.0        364.0        366.0   \n",
       "10327        441.0        437.0        382.0        394.0        334.0   \n",
       "10328        338.0        341.0        333.0        305.0        277.0   \n",
       "10474        353.0        343.0        326.0        283.0        307.0   \n",
       "10475        278.0        261.0        236.0        179.0        195.0   \n",
       "\n",
       "       7:00-8:00PM  8:00-9:00PM  9:00-10:00PM  10:00-11:00PM  11:00-12:00AM  \\\n",
       "684          320.0        296.0         229.0          123.0          109.0   \n",
       "688          233.0        150.0         142.0          116.0           69.0   \n",
       "9709         289.0        286.0         228.0          169.0          151.0   \n",
       "9710         258.0        161.0         132.0          133.0           94.0   \n",
       "9787         267.0        215.0         157.0          120.0           62.0   \n",
       "9788         210.0        136.0         114.0           74.0           41.0   \n",
       "9865         337.0        254.0         180.0           99.0           76.0   \n",
       "9866         217.0        174.0         119.0           75.0           54.0   \n",
       "9943         358.0        253.0         195.0          117.0           76.0   \n",
       "9944         197.0        124.0          89.0           52.0           38.0   \n",
       "10021        285.0        256.0         157.0          106.0           71.0   \n",
       "10022        270.0        229.0         146.0          128.0           77.0   \n",
       "10099        359.0        280.0         212.0          130.0           87.0   \n",
       "10100        264.0        214.0         151.0          116.0           76.0   \n",
       "10177        394.0        278.0         242.0          191.0          188.0   \n",
       "10178        285.0        222.0         160.0          130.0          120.0   \n",
       "10327        309.0        247.0         242.0          159.0          165.0   \n",
       "10328        233.0        179.0         143.0          109.0          139.0   \n",
       "10474        248.0        184.0         134.0           65.0           54.0   \n",
       "10475        168.0        117.0          84.0           44.0           32.0   \n",
       "\n",
       "       year  \n",
       "684    2012  \n",
       "688    2012  \n",
       "9709   2015  \n",
       "9710   2015  \n",
       "9787   2015  \n",
       "9788   2015  \n",
       "9865   2015  \n",
       "9866   2015  \n",
       "9943   2015  \n",
       "9944   2015  \n",
       "10021  2015  \n",
       "10022  2015  \n",
       "10099  2015  \n",
       "10100  2015  \n",
       "10177  2015  \n",
       "10178  2015  \n",
       "10327  2015  \n",
       "10328  2015  \n",
       "10474  2015  \n",
       "10475  2015  "
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df[(new_df['Segment ID']  == 1883)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}