Forecast Accuracy Assessment.ipynb

{
 "cells": [
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": 1,
=======
   "execution_count": null,
>>>>>>> parent of c25d92c... Merge branch 'master' of https://github.com/jawadmhoque/accuracy-assessment
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd #for working with dataframe\n",
    "import numpy as np\n",
    "from scipy import stats, integrate #will help in stats operation in histograms\n",
    "import matplotlib.pyplot as plt #to plot the PE\n",
    "import seaborn as sns #nice looking plots\n",
    "%matplotlib inline\n",
    "sns.set(color_codes=True)"
   ]
<<<<<<< HEAD
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"FlatData.csv\",encoding='latin1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>BriefDescription</th>\n",
       "      <th>Length_miles</th>\n",
       "      <th>FunctionalClass</th>\n",
       "      <th>ImprovementType</th>\n",
       "      <th>State</th>\n",
       "      <th>InternalProjectID</th>\n",
       "      <th>main_ProjectInformation_ProjectID</th>\n",
       "      <th>County</th>\n",
       "      <th>TollType</th>\n",
       "      <th>ForecastYear</th>\n",
       "      <th>TrafficForecast</th>\n",
       "      <th>ForecastYearType</th>\n",
       "      <th>YearForecastProduced</th>\n",
       "      <th>ForecastMethodology</th>\n",
       "      <th>SegmentDescription</th>\n",
       "      <th>main_TrafficForecast_ProjectID</th>\n",
       "      <th>SegmentID</th>\n",
       "      <th>Year_ofObservation</th>\n",
       "      <th>Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>IR71/US 30 interchange Modification</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11378</td>\n",
       "      <td>41-2-11378-IR71/US 30 interchange Modification</td>\n",
       "      <td>Richland</td>\n",
       "      <td>1</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>37190</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , RIC7119.08</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "      <td>42310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>IR71/US 30 interchange Modification</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11378</td>\n",
       "      <td>41-2-11378-IR71/US 30 interchange Modification</td>\n",
       "      <td>Richland</td>\n",
       "      <td>1</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>45190</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , RIC7119.08</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>39760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>IR71/US 30 interchange Modification</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11378</td>\n",
       "      <td>41-3-11378-IR71/US 30 interchange Modification</td>\n",
       "      <td>Richland</td>\n",
       "      <td>1</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>12920</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , RIC3017.2</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "      <td>15780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IR71/US 30 interchange Modification</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11378</td>\n",
       "      <td>41-3-11378-IR71/US 30 interchange Modification</td>\n",
       "      <td>Richland</td>\n",
       "      <td>1</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>17390</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , RIC3017.2</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>15630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>IR71/US 30 interchange Modification</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11378</td>\n",
       "      <td>41-4-11378-IR71/US 30 interchange Modification</td>\n",
       "      <td>Richland</td>\n",
       "      <td>1</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>37820</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , RIC7118.78</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "      <td>42450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>IR71/US 30 interchange Modification</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11378</td>\n",
       "      <td>41-4-11378-IR71/US 30 interchange Modification</td>\n",
       "      <td>Richland</td>\n",
       "      <td>1</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>46060</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , RIC7118.78</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>39290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>IR71/US 30 interchange Modification</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11378</td>\n",
       "      <td>41-5-11378-IR71/US 30 interchange Modification</td>\n",
       "      <td>Richland</td>\n",
       "      <td>1</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>16430</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , RIC3016.87</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "      <td>16530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>IR71/US 30 interchange Modification</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11378</td>\n",
       "      <td>41-5-11378-IR71/US 30 interchange Modification</td>\n",
       "      <td>Richland</td>\n",
       "      <td>1</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>22090</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , RIC3016.87</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>18210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>TUS-0036-15.730</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>19055</td>\n",
       "      <td>41-6-19055-TUS-0036-15.730</td>\n",
       "      <td>Tuscarawas</td>\n",
       "      <td>1</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>8990</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , TUS3615.73</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "      <td>9100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>TUS-0036-15.730</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>19055</td>\n",
       "      <td>41-6-19055-TUS-0036-15.730</td>\n",
       "      <td>Tuscarawas</td>\n",
       "      <td>1</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>11530</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , TUS3615.73</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>8960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-7-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>70120</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR9013</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>62330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-7-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>94850</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR9013</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>59970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-8-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>53040</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR9013.2</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>51440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-8-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>76040</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR9013.2</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>52020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-9-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>51350</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR9015.65</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>50470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-9-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>73820</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR9015.65</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>53590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-10-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>29990</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR5720.06</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>33180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-10-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>32960</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR5720.06</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>45300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-11-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>23090</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR5720.33</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>21910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-11-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>24320</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR5720.33</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>18020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-12-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>22700</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR2541.14</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>17830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-12-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>20570</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR2541.14</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>16280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-13-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>25670</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR2541.91</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>27280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-13-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>33470</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR2541.91</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>27460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-14-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>7890</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR2542.28</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>9880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-14-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>9590</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR2542.28</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>10410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-15-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>19610</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR30121.8</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>22630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-15-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>26260</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR30121.8</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>24350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-16-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>9230</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR30122.33</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002</td>\n",
       "      <td>10230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>LOR-0090-13.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>11385</td>\n",
       "      <td>41-16-11385-LOR-0090-13.20</td>\n",
       "      <td>Lorain</td>\n",
       "      <td>1</td>\n",
       "      <td>2022.0</td>\n",
       "      <td>14120</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , LOR30122.33</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008</td>\n",
       "      <td>9530</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17129</th>\n",
       "      <td>The Add Lanes &amp; Reconstruct Project begin east...</td>\n",
       "      <td>5.300</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>240373-1</td>\n",
       "      <td>12-9654-240373-1-The Add Lanes &amp; Reconstruct P...</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>1</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>8440</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9654</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2005</td>\n",
       "      <td>8200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17130</th>\n",
       "      <td>The Add Lanes &amp; Reconstruct Project begin east...</td>\n",
       "      <td>5.300</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>240373-1</td>\n",
       "      <td>12-9654-240373-1-The Add Lanes &amp; Reconstruct P...</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>10460</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9654</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>8900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17131</th>\n",
       "      <td>The Add Lanes &amp; Reconstruct Project begin east...</td>\n",
       "      <td>5.300</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>240373-1</td>\n",
       "      <td>12-9654-240373-1-The Add Lanes &amp; Reconstruct P...</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>1</td>\n",
       "      <td>2025.0</td>\n",
       "      <td>12480</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9654</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>8900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17132</th>\n",
       "      <td>The SR 520 Traffic Ops Improvement Project on ...</td>\n",
       "      <td>0.285</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416408-1</td>\n",
       "      <td>12-9655-416408-1-The SR 520 Traffic Ops Improv...</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>1</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>48500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>MP 8.75 to MP 9.035</td>\n",
       "      <td>9655</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>32500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17133</th>\n",
       "      <td>The SR 520 Traffic Ops Improvement Project on ...</td>\n",
       "      <td>0.285</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416408-1</td>\n",
       "      <td>12-9655-416408-1-The SR 520 Traffic Ops Improv...</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>1</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>55300</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>MP 8.75 to MP 9.035</td>\n",
       "      <td>9655</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>38000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17134</th>\n",
       "      <td>The SR 520 Traffic Ops Improvement Project on ...</td>\n",
       "      <td>0.285</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416408-1</td>\n",
       "      <td>12-9655-416408-1-The SR 520 Traffic Ops Improv...</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>1</td>\n",
       "      <td>2028.0</td>\n",
       "      <td>62000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>MP 8.75 to MP 9.035</td>\n",
       "      <td>9655</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>38000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17135</th>\n",
       "      <td>The SR 93 Resurfacing Project on SR 93 from SR...</td>\n",
       "      <td>7.266</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416939-1</td>\n",
       "      <td>12-9656-416939-1-The SR 93 Resurfacing Project...</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>1</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>82900</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>5</td>\n",
       "      <td>MP 21.730 to South of SR 93</td>\n",
       "      <td>9656</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>71500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17136</th>\n",
       "      <td>The SR 93 Resurfacing Project on SR 93 from SR...</td>\n",
       "      <td>7.266</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416939-1</td>\n",
       "      <td>12-9656-416939-1-The SR 93 Resurfacing Project...</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>1</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>109100</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>5</td>\n",
       "      <td>MP 21.730 to South of SR 93</td>\n",
       "      <td>9656</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>68000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17137</th>\n",
       "      <td>The SR 93 Resurfacing Project on SR 93 from SR...</td>\n",
       "      <td>7.266</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416939-1</td>\n",
       "      <td>12-9656-416939-1-The SR 93 Resurfacing Project...</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>1</td>\n",
       "      <td>2028.0</td>\n",
       "      <td>135200</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>5</td>\n",
       "      <td>MP 21.730 to South of SR 93</td>\n",
       "      <td>9656</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>68000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17138</th>\n",
       "      <td>The SR 93 Resurfacing Project on SR 93 from SR...</td>\n",
       "      <td>7.266</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416939-1</td>\n",
       "      <td>12-9657-416939-1-The SR 93 Resurfacing Project...</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>1</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>83200</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>5</td>\n",
       "      <td>North of SR 93 to MP 28.996</td>\n",
       "      <td>9657</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>68000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17139</th>\n",
       "      <td>The SR 93 Resurfacing Project on SR 93 from SR...</td>\n",
       "      <td>7.266</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416939-1</td>\n",
       "      <td>12-9657-416939-1-The SR 93 Resurfacing Project...</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>1</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>109400</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>5</td>\n",
       "      <td>North of SR 93 to MP 28.996</td>\n",
       "      <td>9657</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>72500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17140</th>\n",
       "      <td>The SR 93 Resurfacing Project on SR 93 from SR...</td>\n",
       "      <td>7.266</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416939-1</td>\n",
       "      <td>12-9657-416939-1-The SR 93 Resurfacing Project...</td>\n",
       "      <td>Sumter</td>\n",
       "      <td>1</td>\n",
       "      <td>2028.0</td>\n",
       "      <td>135600</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>5</td>\n",
       "      <td>North of SR 93 to MP 28.996</td>\n",
       "      <td>9657</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>72500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17141</th>\n",
       "      <td>The SR 11  Resurfacing Project include SR 11 ...</td>\n",
       "      <td>15.507</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>417141-1</td>\n",
       "      <td>12-9658-417141-1-The SR 11  Resurfacing Proje...</td>\n",
       "      <td>Flagler</td>\n",
       "      <td>1</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>3150</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 11 North of Volusia County Line</td>\n",
       "      <td>9658</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17142</th>\n",
       "      <td>The SR 11  Resurfacing Project include SR 11 ...</td>\n",
       "      <td>15.507</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>417141-1</td>\n",
       "      <td>12-9658-417141-1-The SR 11  Resurfacing Proje...</td>\n",
       "      <td>Flagler</td>\n",
       "      <td>1</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>3900</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 11 North of Volusia County Line</td>\n",
       "      <td>9658</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>2800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17143</th>\n",
       "      <td>The SR 11  Resurfacing Project include SR 11 ...</td>\n",
       "      <td>15.507</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>417141-1</td>\n",
       "      <td>12-9658-417141-1-The SR 11  Resurfacing Proje...</td>\n",
       "      <td>Flagler</td>\n",
       "      <td>1</td>\n",
       "      <td>2028.0</td>\n",
       "      <td>4650</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 11 North of Volusia County Line</td>\n",
       "      <td>9658</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>2800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17144</th>\n",
       "      <td>The SR 11  Resurfacing Project include SR 11 ...</td>\n",
       "      <td>15.507</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>417141-1</td>\n",
       "      <td>12-9659-417141-1-The SR 11  Resurfacing Proje...</td>\n",
       "      <td>Flagler</td>\n",
       "      <td>1</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>4850</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 11 South of US 1</td>\n",
       "      <td>9659</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17145</th>\n",
       "      <td>The SR 11  Resurfacing Project include SR 11 ...</td>\n",
       "      <td>15.507</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>417141-1</td>\n",
       "      <td>12-9659-417141-1-The SR 11  Resurfacing Proje...</td>\n",
       "      <td>Flagler</td>\n",
       "      <td>1</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>6000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 11 South of US 1</td>\n",
       "      <td>9659</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>5300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17146</th>\n",
       "      <td>The SR 11  Resurfacing Project include SR 11 ...</td>\n",
       "      <td>15.507</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>417141-1</td>\n",
       "      <td>12-9659-417141-1-The SR 11  Resurfacing Proje...</td>\n",
       "      <td>Flagler</td>\n",
       "      <td>1</td>\n",
       "      <td>2028.0</td>\n",
       "      <td>7100</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 11 South of US 1</td>\n",
       "      <td>9659</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>5300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17147</th>\n",
       "      <td>The SR 518  Traffic Operations Improvement Pr...</td>\n",
       "      <td>0.413</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416187-1</td>\n",
       "      <td>12-9660-416187-1-The SR 518  Traffic Operatio...</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>1</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>35300</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>5</td>\n",
       "      <td>MP 0.093 to MP 0.506</td>\n",
       "      <td>9660</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2007</td>\n",
       "      <td>32000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17148</th>\n",
       "      <td>The SR 518  Traffic Operations Improvement Pr...</td>\n",
       "      <td>0.413</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416187-1</td>\n",
       "      <td>12-9660-416187-1-The SR 518  Traffic Operatio...</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>1</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>46900</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>5</td>\n",
       "      <td>MP 0.093 to MP 0.506</td>\n",
       "      <td>9660</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>38500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17149</th>\n",
       "      <td>The SR 518  Traffic Operations Improvement Pr...</td>\n",
       "      <td>0.413</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>416187-1</td>\n",
       "      <td>12-9660-416187-1-The SR 518  Traffic Operatio...</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>1</td>\n",
       "      <td>2027.0</td>\n",
       "      <td>58400</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>5</td>\n",
       "      <td>MP 0.093 to MP 0.506</td>\n",
       "      <td>9660</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>38500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17150</th>\n",
       "      <td>The SR 3 Resurfacing Project on SR 3 from 0.01...</td>\n",
       "      <td>5.897</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>417153-1</td>\n",
       "      <td>-9661-417153-1-The SR 3 Resurfacing Project on...</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>1</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>22400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>4</td>\n",
       "      <td>(M.P. 3.858) to (M.P. 9.755)</td>\n",
       "      <td>9661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2007</td>\n",
       "      <td>19200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17151</th>\n",
       "      <td>The SR 3 Resurfacing Project on SR 3 from 0.01...</td>\n",
       "      <td>5.897</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>417153-1</td>\n",
       "      <td>-9661-417153-1-The SR 3 Resurfacing Project on...</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>1</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>24100</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>4</td>\n",
       "      <td>(M.P. 3.858) to (M.P. 9.755)</td>\n",
       "      <td>9661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>22500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17152</th>\n",
       "      <td>The SR 3 Resurfacing Project on SR 3 from 0.01...</td>\n",
       "      <td>5.897</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>417153-1</td>\n",
       "      <td>-9661-417153-1-The SR 3 Resurfacing Project on...</td>\n",
       "      <td>Brevard</td>\n",
       "      <td>1</td>\n",
       "      <td>2027.0</td>\n",
       "      <td>25900</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>4</td>\n",
       "      <td>(M.P. 3.858) to (M.P. 9.755)</td>\n",
       "      <td>9661</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>22500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17153</th>\n",
       "      <td>The SR 40  Resurfacing Project from 269 ft ea...</td>\n",
       "      <td>13.336</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>417154-1</td>\n",
       "      <td>-9662-417154-1-The SR 40  Resurfacing Project...</td>\n",
       "      <td>Volusia</td>\n",
       "      <td>1</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>7200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 40 - 4.0 Miles East of US 17/SR 15</td>\n",
       "      <td>9662</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>5800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17154</th>\n",
       "      <td>The SR 40  Resurfacing Project from 269 ft ea...</td>\n",
       "      <td>13.336</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>417154-1</td>\n",
       "      <td>-9662-417154-1-The SR 40  Resurfacing Project...</td>\n",
       "      <td>Volusia</td>\n",
       "      <td>1</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>9600</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 40 - 4.0 Miles East of US 17/SR 15</td>\n",
       "      <td>9662</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>6900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17155</th>\n",
       "      <td>The SR 40  Resurfacing Project from 269 ft ea...</td>\n",
       "      <td>13.336</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>417154-1</td>\n",
       "      <td>-9662-417154-1-The SR 40  Resurfacing Project...</td>\n",
       "      <td>Volusia</td>\n",
       "      <td>1</td>\n",
       "      <td>2028.0</td>\n",
       "      <td>12000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 40 - 4.0 Miles East of US 17/SR 15</td>\n",
       "      <td>9662</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>6900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17156</th>\n",
       "      <td>The SR 40  Resurfacing Project from 269 ft ea...</td>\n",
       "      <td>13.336</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>417154-1</td>\n",
       "      <td>-9663-417154-1-The SR 40  Resurfacing Project...</td>\n",
       "      <td>Volusia</td>\n",
       "      <td>1</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>6700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 40 - 3.0 Miles East of SR 11</td>\n",
       "      <td>9663</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>10800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17157</th>\n",
       "      <td>The SR 40  Resurfacing Project from 269 ft ea...</td>\n",
       "      <td>13.336</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>417154-1</td>\n",
       "      <td>-9663-417154-1-The SR 40  Resurfacing Project...</td>\n",
       "      <td>Volusia</td>\n",
       "      <td>1</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>8900</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 40 - 3.0 Miles East of SR 11</td>\n",
       "      <td>9663</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>11100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17158</th>\n",
       "      <td>The SR 40  Resurfacing Project from 269 ft ea...</td>\n",
       "      <td>13.336</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>417154-1</td>\n",
       "      <td>-9663-417154-1-The SR 40  Resurfacing Project...</td>\n",
       "      <td>Volusia</td>\n",
       "      <td>1</td>\n",
       "      <td>2028.0</td>\n",
       "      <td>11200</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 40 - 3.0 Miles East of SR 11</td>\n",
       "      <td>9663</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>11100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15280 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        BriefDescription  Length_miles  \\\n",
       "0                    IR71/US 30 interchange Modification           NaN   \n",
       "1                    IR71/US 30 interchange Modification           NaN   \n",
       "2                    IR71/US 30 interchange Modification           NaN   \n",
       "3                    IR71/US 30 interchange Modification           NaN   \n",
       "4                    IR71/US 30 interchange Modification           NaN   \n",
       "5                    IR71/US 30 interchange Modification           NaN   \n",
       "6                    IR71/US 30 interchange Modification           NaN   \n",
       "7                    IR71/US 30 interchange Modification           NaN   \n",
       "8                                        TUS-0036-15.730           NaN   \n",
       "9                                        TUS-0036-15.730           NaN   \n",
       "10                                        LOR-0090-13.20           NaN   \n",
       "11                                        LOR-0090-13.20           NaN   \n",
       "12                                        LOR-0090-13.20           NaN   \n",
       "13                                        LOR-0090-13.20           NaN   \n",
       "14                                        LOR-0090-13.20           NaN   \n",
       "15                                        LOR-0090-13.20           NaN   \n",
       "16                                        LOR-0090-13.20           NaN   \n",
       "17                                        LOR-0090-13.20           NaN   \n",
       "18                                        LOR-0090-13.20           NaN   \n",
       "19                                        LOR-0090-13.20           NaN   \n",
       "20                                        LOR-0090-13.20           NaN   \n",
       "21                                        LOR-0090-13.20           NaN   \n",
       "22                                        LOR-0090-13.20           NaN   \n",
       "23                                        LOR-0090-13.20           NaN   \n",
       "24                                        LOR-0090-13.20           NaN   \n",
       "25                                        LOR-0090-13.20           NaN   \n",
       "26                                        LOR-0090-13.20           NaN   \n",
       "27                                        LOR-0090-13.20           NaN   \n",
       "28                                        LOR-0090-13.20           NaN   \n",
       "29                                        LOR-0090-13.20           NaN   \n",
       "...                                                  ...           ...   \n",
       "17129  The Add Lanes & Reconstruct Project begin east...         5.300   \n",
       "17130  The Add Lanes & Reconstruct Project begin east...         5.300   \n",
       "17131  The Add Lanes & Reconstruct Project begin east...         5.300   \n",
       "17132  The SR 520 Traffic Ops Improvement Project on ...         0.285   \n",
       "17133  The SR 520 Traffic Ops Improvement Project on ...         0.285   \n",
       "17134  The SR 520 Traffic Ops Improvement Project on ...         0.285   \n",
       "17135  The SR 93 Resurfacing Project on SR 93 from SR...         7.266   \n",
       "17136  The SR 93 Resurfacing Project on SR 93 from SR...         7.266   \n",
       "17137  The SR 93 Resurfacing Project on SR 93 from SR...         7.266   \n",
       "17138  The SR 93 Resurfacing Project on SR 93 from SR...         7.266   \n",
       "17139  The SR 93 Resurfacing Project on SR 93 from SR...         7.266   \n",
       "17140  The SR 93 Resurfacing Project on SR 93 from SR...         7.266   \n",
       "17141  The SR 11  Resurfacing Project include SR 11 ...        15.507   \n",
       "17142  The SR 11  Resurfacing Project include SR 11 ...        15.507   \n",
       "17143  The SR 11  Resurfacing Project include SR 11 ...        15.507   \n",
       "17144  The SR 11  Resurfacing Project include SR 11 ...        15.507   \n",
       "17145  The SR 11  Resurfacing Project include SR 11 ...        15.507   \n",
       "17146  The SR 11  Resurfacing Project include SR 11 ...        15.507   \n",
       "17147  The SR 518  Traffic Operations Improvement Pr...         0.413   \n",
       "17148  The SR 518  Traffic Operations Improvement Pr...         0.413   \n",
       "17149  The SR 518  Traffic Operations Improvement Pr...         0.413   \n",
       "17150  The SR 3 Resurfacing Project on SR 3 from 0.01...         5.897   \n",
       "17151  The SR 3 Resurfacing Project on SR 3 from 0.01...         5.897   \n",
       "17152  The SR 3 Resurfacing Project on SR 3 from 0.01...         5.897   \n",
       "17153  The SR 40  Resurfacing Project from 269 ft ea...        13.336   \n",
       "17154  The SR 40  Resurfacing Project from 269 ft ea...        13.336   \n",
       "17155  The SR 40  Resurfacing Project from 269 ft ea...        13.336   \n",
       "17156  The SR 40  Resurfacing Project from 269 ft ea...        13.336   \n",
       "17157  The SR 40  Resurfacing Project from 269 ft ea...        13.336   \n",
       "17158  The SR 40  Resurfacing Project from 269 ft ea...        13.336   \n",
       "\n",
       "       FunctionalClass  ImprovementType  State InternalProjectID  \\\n",
       "0                  1.0              NaN   41.0             11378   \n",
       "1                  1.0              NaN   41.0             11378   \n",
       "2                  3.0              NaN   41.0             11378   \n",
       "3                  3.0              NaN   41.0             11378   \n",
       "4                  1.0              NaN   41.0             11378   \n",
       "5                  1.0              NaN   41.0             11378   \n",
       "6                  1.0              NaN   41.0             11378   \n",
       "7                  1.0              NaN   41.0             11378   \n",
       "8                  3.0              NaN   41.0             19055   \n",
       "9                  3.0              NaN   41.0             19055   \n",
       "10                 1.0              NaN   41.0             11385   \n",
       "11                 1.0              NaN   41.0             11385   \n",
       "12                 1.0              NaN   41.0             11385   \n",
       "13                 1.0              NaN   41.0             11385   \n",
       "14                 1.0              NaN   41.0             11385   \n",
       "15                 1.0              NaN   41.0             11385   \n",
       "16                 3.0              NaN   41.0             11385   \n",
       "17                 3.0              NaN   41.0             11385   \n",
       "18                 4.0              NaN   41.0             11385   \n",
       "19                 4.0              NaN   41.0             11385   \n",
       "20                 4.0              NaN   41.0             11385   \n",
       "21                 4.0              NaN   41.0             11385   \n",
       "22                 4.0              NaN   41.0             11385   \n",
       "23                 4.0              NaN   41.0             11385   \n",
       "24                 4.0              NaN   41.0             11385   \n",
       "25                 4.0              NaN   41.0             11385   \n",
       "26                 4.0              NaN   41.0             11385   \n",
       "27                 4.0              NaN   41.0             11385   \n",
       "28                 4.0              NaN   41.0             11385   \n",
       "29                 4.0              NaN   41.0             11385   \n",
       "...                ...              ...    ...               ...   \n",
       "17129              3.0              NaN   12.0          240373-1   \n",
       "17130              3.0              NaN   12.0          240373-1   \n",
       "17131              3.0              NaN   12.0          240373-1   \n",
       "17132              3.0              NaN   12.0          416408-1   \n",
       "17133              3.0              NaN   12.0          416408-1   \n",
       "17134              3.0              NaN   12.0          416408-1   \n",
       "17135              3.0              NaN   12.0          416939-1   \n",
       "17136              3.0              NaN   12.0          416939-1   \n",
       "17137              3.0              NaN   12.0          416939-1   \n",
       "17138              3.0              NaN   12.0          416939-1   \n",
       "17139              3.0              NaN   12.0          416939-1   \n",
       "17140              3.0              NaN   12.0          416939-1   \n",
       "17141              4.0              NaN   12.0          417141-1   \n",
       "17142              4.0              NaN   12.0          417141-1   \n",
       "17143              4.0              NaN   12.0          417141-1   \n",
       "17144              4.0              NaN   12.0          417141-1   \n",
       "17145              4.0              NaN   12.0          417141-1   \n",
       "17146              4.0              NaN   12.0          417141-1   \n",
       "17147              3.0              NaN   12.0          416187-1   \n",
       "17148              3.0              NaN   12.0          416187-1   \n",
       "17149              3.0              NaN   12.0          416187-1   \n",
       "17150              3.0              NaN    NaN          417153-1   \n",
       "17151              3.0              NaN    NaN          417153-1   \n",
       "17152              3.0              NaN    NaN          417153-1   \n",
       "17153              3.0              NaN    NaN          417154-1   \n",
       "17154              3.0              NaN    NaN          417154-1   \n",
       "17155              3.0              NaN    NaN          417154-1   \n",
       "17156              3.0              NaN    NaN          417154-1   \n",
       "17157              3.0              NaN    NaN          417154-1   \n",
       "17158              3.0              NaN    NaN          417154-1   \n",
       "\n",
       "                       main_ProjectInformation_ProjectID      County  \\\n",
       "0         41-2-11378-IR71/US 30 interchange Modification    Richland   \n",
       "1         41-2-11378-IR71/US 30 interchange Modification    Richland   \n",
       "2         41-3-11378-IR71/US 30 interchange Modification    Richland   \n",
       "3         41-3-11378-IR71/US 30 interchange Modification    Richland   \n",
       "4         41-4-11378-IR71/US 30 interchange Modification    Richland   \n",
       "5         41-4-11378-IR71/US 30 interchange Modification    Richland   \n",
       "6         41-5-11378-IR71/US 30 interchange Modification    Richland   \n",
       "7         41-5-11378-IR71/US 30 interchange Modification    Richland   \n",
       "8                             41-6-19055-TUS-0036-15.730  Tuscarawas   \n",
       "9                             41-6-19055-TUS-0036-15.730  Tuscarawas   \n",
       "10                             41-7-11385-LOR-0090-13.20      Lorain   \n",
       "11                             41-7-11385-LOR-0090-13.20      Lorain   \n",
       "12                             41-8-11385-LOR-0090-13.20      Lorain   \n",
       "13                             41-8-11385-LOR-0090-13.20      Lorain   \n",
       "14                             41-9-11385-LOR-0090-13.20      Lorain   \n",
       "15                             41-9-11385-LOR-0090-13.20      Lorain   \n",
       "16                            41-10-11385-LOR-0090-13.20      Lorain   \n",
       "17                            41-10-11385-LOR-0090-13.20      Lorain   \n",
       "18                            41-11-11385-LOR-0090-13.20      Lorain   \n",
       "19                            41-11-11385-LOR-0090-13.20      Lorain   \n",
       "20                            41-12-11385-LOR-0090-13.20      Lorain   \n",
       "21                            41-12-11385-LOR-0090-13.20      Lorain   \n",
       "22                            41-13-11385-LOR-0090-13.20      Lorain   \n",
       "23                            41-13-11385-LOR-0090-13.20      Lorain   \n",
       "24                            41-14-11385-LOR-0090-13.20      Lorain   \n",
       "25                            41-14-11385-LOR-0090-13.20      Lorain   \n",
       "26                            41-15-11385-LOR-0090-13.20      Lorain   \n",
       "27                            41-15-11385-LOR-0090-13.20      Lorain   \n",
       "28                            41-16-11385-LOR-0090-13.20      Lorain   \n",
       "29                            41-16-11385-LOR-0090-13.20      Lorain   \n",
       "...                                                  ...         ...   \n",
       "17129  12-9654-240373-1-The Add Lanes & Reconstruct P...      Sumter   \n",
       "17130  12-9654-240373-1-The Add Lanes & Reconstruct P...      Sumter   \n",
       "17131  12-9654-240373-1-The Add Lanes & Reconstruct P...      Sumter   \n",
       "17132  12-9655-416408-1-The SR 520 Traffic Ops Improv...     Brevard   \n",
       "17133  12-9655-416408-1-The SR 520 Traffic Ops Improv...     Brevard   \n",
       "17134  12-9655-416408-1-The SR 520 Traffic Ops Improv...     Brevard   \n",
       "17135  12-9656-416939-1-The SR 93 Resurfacing Project...      Sumter   \n",
       "17136  12-9656-416939-1-The SR 93 Resurfacing Project...      Sumter   \n",
       "17137  12-9656-416939-1-The SR 93 Resurfacing Project...      Sumter   \n",
       "17138  12-9657-416939-1-The SR 93 Resurfacing Project...      Sumter   \n",
       "17139  12-9657-416939-1-The SR 93 Resurfacing Project...      Sumter   \n",
       "17140  12-9657-416939-1-The SR 93 Resurfacing Project...      Sumter   \n",
       "17141  12-9658-417141-1-The SR 11  Resurfacing Proje...     Flagler   \n",
       "17142  12-9658-417141-1-The SR 11  Resurfacing Proje...     Flagler   \n",
       "17143  12-9658-417141-1-The SR 11  Resurfacing Proje...     Flagler   \n",
       "17144  12-9659-417141-1-The SR 11  Resurfacing Proje...     Flagler   \n",
       "17145  12-9659-417141-1-The SR 11  Resurfacing Proje...     Flagler   \n",
       "17146  12-9659-417141-1-The SR 11  Resurfacing Proje...     Flagler   \n",
       "17147  12-9660-416187-1-The SR 518  Traffic Operatio...     Brevard   \n",
       "17148  12-9660-416187-1-The SR 518  Traffic Operatio...     Brevard   \n",
       "17149  12-9660-416187-1-The SR 518  Traffic Operatio...     Brevard   \n",
       "17150  -9661-417153-1-The SR 3 Resurfacing Project on...     Brevard   \n",
       "17151  -9661-417153-1-The SR 3 Resurfacing Project on...     Brevard   \n",
       "17152  -9661-417153-1-The SR 3 Resurfacing Project on...     Brevard   \n",
       "17153  -9662-417154-1-The SR 40  Resurfacing Project...     Volusia   \n",
       "17154  -9662-417154-1-The SR 40  Resurfacing Project...     Volusia   \n",
       "17155  -9662-417154-1-The SR 40  Resurfacing Project...     Volusia   \n",
       "17156  -9663-417154-1-The SR 40  Resurfacing Project...     Volusia   \n",
       "17157  -9663-417154-1-The SR 40  Resurfacing Project...     Volusia   \n",
       "17158  -9663-417154-1-The SR 40  Resurfacing Project...     Volusia   \n",
       "\n",
       "       TollType  ForecastYear  TrafficForecast  ForecastYearType  \\\n",
       "0             1        2000.0            37190               1.0   \n",
       "1             1        2020.0            45190               3.0   \n",
       "2             1        2000.0            12920               1.0   \n",
       "3             1        2020.0            17390               3.0   \n",
       "4             1        2000.0            37820               1.0   \n",
       "5             1        2020.0            46060               3.0   \n",
       "6             1        2000.0            16430               1.0   \n",
       "7             1        2020.0            22090               3.0   \n",
       "8             1        2000.0             8990               1.0   \n",
       "9             1        2020.0            11530               3.0   \n",
       "10            1        2002.0            70120               1.0   \n",
       "11            1        2022.0            94850               3.0   \n",
       "12            1        2002.0            53040               1.0   \n",
       "13            1        2022.0            76040               3.0   \n",
       "14            1        2002.0            51350               1.0   \n",
       "15            1        2022.0            73820               3.0   \n",
       "16            1        2002.0            29990               1.0   \n",
       "17            1        2022.0            32960               3.0   \n",
       "18            1        2002.0            23090               1.0   \n",
       "19            1        2022.0            24320               3.0   \n",
       "20            1        2002.0            22700               1.0   \n",
       "21            1        2022.0            20570               3.0   \n",
       "22            1        2002.0            25670               1.0   \n",
       "23            1        2022.0            33470               3.0   \n",
       "24            1        2002.0             7890               1.0   \n",
       "25            1        2022.0             9590               3.0   \n",
       "26            1        2002.0            19610               1.0   \n",
       "27            1        2022.0            26260               3.0   \n",
       "28            1        2002.0             9230               1.0   \n",
       "29            1        2022.0            14120               3.0   \n",
       "...         ...           ...              ...               ...   \n",
       "17129         1        2005.0             8440               1.0   \n",
       "17130         1        2015.0            10460               2.0   \n",
       "17131         1        2025.0            12480               3.0   \n",
       "17132         1        2008.0            48500               1.0   \n",
       "17133         1        2018.0            55300               2.0   \n",
       "17134         1        2028.0            62000               3.0   \n",
       "17135         1        2008.0            82900               1.0   \n",
       "17136         1        2018.0           109100               2.0   \n",
       "17137         1        2028.0           135200               3.0   \n",
       "17138         1        2008.0            83200               1.0   \n",
       "17139         1        2018.0           109400               2.0   \n",
       "17140         1        2028.0           135600               3.0   \n",
       "17141         1        2008.0             3150               1.0   \n",
       "17142         1        2018.0             3900               2.0   \n",
       "17143         1        2028.0             4650               3.0   \n",
       "17144         1        2008.0             4850               1.0   \n",
       "17145         1        2018.0             6000               2.0   \n",
       "17146         1        2028.0             7100               3.0   \n",
       "17147         1        2007.0            35300               1.0   \n",
       "17148         1        2017.0            46900               2.0   \n",
       "17149         1        2027.0            58400               3.0   \n",
       "17150         1        2007.0            22400               NaN   \n",
       "17151         1        2017.0            24100               2.0   \n",
       "17152         1        2027.0            25900               3.0   \n",
       "17153         1        2008.0             7200               NaN   \n",
       "17154         1        2018.0             9600               2.0   \n",
       "17155         1        2028.0            12000               3.0   \n",
       "17156         1        2008.0             6700               NaN   \n",
       "17157         1        2018.0             8900               2.0   \n",
       "17158         1        2028.0            11200               3.0   \n",
       "\n",
       "       YearForecastProduced ForecastMethodology  \\\n",
       "0                    1994.0                   6   \n",
       "1                    1994.0                   6   \n",
       "2                    1994.0                   6   \n",
       "3                    1994.0                   6   \n",
       "4                    1994.0                   6   \n",
       "5                    1994.0                   6   \n",
       "6                    1994.0                   6   \n",
       "7                    1994.0                   6   \n",
       "8                    1999.0                   6   \n",
       "9                    1999.0                   6   \n",
       "10                   2000.0                   6   \n",
       "11                   2000.0                   6   \n",
       "12                   2000.0                   6   \n",
       "13                   2000.0                   6   \n",
       "14                   2000.0                   6   \n",
       "15                   2000.0                   6   \n",
       "16                   2000.0                   6   \n",
       "17                   2000.0                   6   \n",
       "18                   2000.0                   6   \n",
       "19                   2000.0                   6   \n",
       "20                   2000.0                   6   \n",
       "21                   2000.0                   6   \n",
       "22                   2000.0                   6   \n",
       "23                   2000.0                   6   \n",
       "24                   2000.0                   6   \n",
       "25                   2000.0                   6   \n",
       "26                   2000.0                   6   \n",
       "27                   2000.0                   6   \n",
       "28                   2000.0                   6   \n",
       "29                   2000.0                   6   \n",
       "...                     ...                 ...   \n",
       "17129                2002.0                   1   \n",
       "17130                2002.0                   1   \n",
       "17131                2002.0                   1   \n",
       "17132                2005.0                   1   \n",
       "17133                2005.0                   1   \n",
       "17134                2005.0                   1   \n",
       "17135                2006.0                   5   \n",
       "17136                2006.0                   5   \n",
       "17137                2006.0                   5   \n",
       "17138                2006.0                   5   \n",
       "17139                2006.0                   5   \n",
       "17140                2006.0                   5   \n",
       "17141                2005.0                   1   \n",
       "17142                2005.0                   1   \n",
       "17143                2005.0                   1   \n",
       "17144                2005.0                   1   \n",
       "17145                2005.0                   1   \n",
       "17146                2005.0                   1   \n",
       "17147                2005.0                   5   \n",
       "17148                2005.0                   5   \n",
       "17149                2005.0                   5   \n",
       "17150                2005.0                   4   \n",
       "17151                2005.0                   4   \n",
       "17152                2005.0                   4   \n",
       "17153                2005.0                   1   \n",
       "17154                2005.0                   1   \n",
       "17155                2005.0                   1   \n",
       "17156                2005.0                   1   \n",
       "17157                2005.0                   1   \n",
       "17158                2005.0                   1   \n",
       "\n",
       "                          SegmentDescription  main_TrafficForecast_ProjectID  \\\n",
       "0                             , , RIC7119.08                               2   \n",
       "1                             , , RIC7119.08                               2   \n",
       "2                              , , RIC3017.2                               3   \n",
       "3                              , , RIC3017.2                               3   \n",
       "4                             , , RIC7118.78                               4   \n",
       "5                             , , RIC7118.78                               4   \n",
       "6                             , , RIC3016.87                               5   \n",
       "7                             , , RIC3016.87                               5   \n",
       "8                             , , TUS3615.73                               6   \n",
       "9                             , , TUS3615.73                               6   \n",
       "10                               , , LOR9013                               7   \n",
       "11                               , , LOR9013                               7   \n",
       "12                             , , LOR9013.2                               8   \n",
       "13                             , , LOR9013.2                               8   \n",
       "14                            , , LOR9015.65                               9   \n",
       "15                            , , LOR9015.65                               9   \n",
       "16                            , , LOR5720.06                              10   \n",
       "17                            , , LOR5720.06                              10   \n",
       "18                            , , LOR5720.33                              11   \n",
       "19                            , , LOR5720.33                              11   \n",
       "20                            , , LOR2541.14                              12   \n",
       "21                            , , LOR2541.14                              12   \n",
       "22                            , , LOR2541.91                              13   \n",
       "23                            , , LOR2541.91                              13   \n",
       "24                            , , LOR2542.28                              14   \n",
       "25                            , , LOR2542.28                              14   \n",
       "26                            , , LOR30121.8                              15   \n",
       "27                            , , LOR30121.8                              15   \n",
       "28                           , , LOR30122.33                              16   \n",
       "29                           , , LOR30122.33                              16   \n",
       "...                                      ...                             ...   \n",
       "17129                                    NaN                            9654   \n",
       "17130                                    NaN                            9654   \n",
       "17131                                    NaN                            9654   \n",
       "17132                    MP 8.75 to MP 9.035                            9655   \n",
       "17133                    MP 8.75 to MP 9.035                            9655   \n",
       "17134                    MP 8.75 to MP 9.035                            9655   \n",
       "17135            MP 21.730 to South of SR 93                            9656   \n",
       "17136            MP 21.730 to South of SR 93                            9656   \n",
       "17137            MP 21.730 to South of SR 93                            9656   \n",
       "17138            North of SR 93 to MP 28.996                            9657   \n",
       "17139            North of SR 93 to MP 28.996                            9657   \n",
       "17140            North of SR 93 to MP 28.996                            9657   \n",
       "17141     SR 11 North of Volusia County Line                            9658   \n",
       "17142     SR 11 North of Volusia County Line                            9658   \n",
       "17143     SR 11 North of Volusia County Line                            9658   \n",
       "17144                    SR 11 South of US 1                            9659   \n",
       "17145                    SR 11 South of US 1                            9659   \n",
       "17146                    SR 11 South of US 1                            9659   \n",
       "17147                   MP 0.093 to MP 0.506                            9660   \n",
       "17148                   MP 0.093 to MP 0.506                            9660   \n",
       "17149                   MP 0.093 to MP 0.506                            9660   \n",
       "17150           (M.P. 3.858) to (M.P. 9.755)                            9661   \n",
       "17151           (M.P. 3.858) to (M.P. 9.755)                            9661   \n",
       "17152           (M.P. 3.858) to (M.P. 9.755)                            9661   \n",
       "17153  SR 40 - 4.0 Miles East of US 17/SR 15                            9662   \n",
       "17154  SR 40 - 4.0 Miles East of US 17/SR 15                            9662   \n",
       "17155  SR 40 - 4.0 Miles East of US 17/SR 15                            9662   \n",
       "17156        SR 40 - 3.0 Miles East of SR 11                            9663   \n",
       "17157        SR 40 - 3.0 Miles East of SR 11                            9663   \n",
       "17158        SR 40 - 3.0 Miles East of SR 11                            9663   \n",
       "\n",
       "       SegmentID  Year_ofObservation  Count  \n",
       "0            NaN                2000  42310  \n",
       "1            NaN                2008  39760  \n",
       "2            NaN                2000  15780  \n",
       "3            NaN                2008  15630  \n",
       "4            NaN                2000  42450  \n",
       "5            NaN                2008  39290  \n",
       "6            NaN                2000  16530  \n",
       "7            NaN                2008  18210  \n",
       "8            NaN                2000   9100  \n",
       "9            NaN                2010   8960  \n",
       "10           NaN                2002  62330  \n",
       "11           NaN                2008  59970  \n",
       "12           NaN                2002  51440  \n",
       "13           NaN                2008  52020  \n",
       "14           NaN                2002  50470  \n",
       "15           NaN                2008  53590  \n",
       "16           NaN                2002  33180  \n",
       "17           NaN                2008  45300  \n",
       "18           NaN                2002  21910  \n",
       "19           NaN                2008  18020  \n",
       "20           NaN                2002  17830  \n",
       "21           NaN                2008  16280  \n",
       "22           NaN                2002  27280  \n",
       "23           NaN                2008  27460  \n",
       "24           NaN                2002   9880  \n",
       "25           NaN                2008  10410  \n",
       "26           NaN                2002  22630  \n",
       "27           NaN                2008  24350  \n",
       "28           NaN                2002  10230  \n",
       "29           NaN                2008   9530  \n",
       "...          ...                 ...    ...  \n",
       "17129        1.0                2005   8200  \n",
       "17130        1.0                2016   8900  \n",
       "17131        1.0                2016   8900  \n",
       "17132        1.0                2008  32500  \n",
       "17133        1.0                2016  38000  \n",
       "17134        1.0                2016  38000  \n",
       "17135        1.0                2008  71500  \n",
       "17136        1.0                2016  68000  \n",
       "17137        1.0                2016  68000  \n",
       "17138        2.0                2008  68000  \n",
       "17139        2.0                2016  72500  \n",
       "17140        2.0                2016  72500  \n",
       "17141        1.0                2008   2600  \n",
       "17142        1.0                2016   2800  \n",
       "17143        1.0                2016   2800  \n",
       "17144        2.0                2008   6000  \n",
       "17145        2.0                2016   5300  \n",
       "17146        2.0                2016   5300  \n",
       "17147        1.0                2007  32000  \n",
       "17148        1.0                2016  38500  \n",
       "17149        1.0                2016  38500  \n",
       "17150        1.0                2007  19200  \n",
       "17151        1.0                2016  22500  \n",
       "17152        1.0                2016  22500  \n",
       "17153        1.0                2008   5800  \n",
       "17154        1.0                2016   6900  \n",
       "17155        1.0                2016   6900  \n",
       "17156        2.0                2008  10800  \n",
       "17157        2.0                2016  11100  \n",
       "17158        2.0                2016  11100  \n",
       "\n",
       "[15280 rows x 19 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flatdata_withID=df[df['InternalProjectID'].notnull()]\n",
    "flatdata_withID"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>BriefDescription</th>\n",
       "      <th>Length_miles</th>\n",
       "      <th>FunctionalClass</th>\n",
       "      <th>ImprovementType</th>\n",
       "      <th>State</th>\n",
       "      <th>InternalProjectID</th>\n",
       "      <th>main_ProjectInformation_ProjectID</th>\n",
       "      <th>County</th>\n",
       "      <th>TollType</th>\n",
       "      <th>ForecastYear</th>\n",
       "      <th>TrafficForecast</th>\n",
       "      <th>ForecastYearType</th>\n",
       "      <th>YearForecastProduced</th>\n",
       "      <th>ForecastMethodology</th>\n",
       "      <th>SegmentDescription</th>\n",
       "      <th>main_TrafficForecast_ProjectID</th>\n",
       "      <th>SegmentID</th>\n",
       "      <th>Year_ofObservation</th>\n",
       "      <th>Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>CUY-71-6.68</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-106--CUY-71-6.68</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>88310</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY715.21</td>\n",
       "      <td>106</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2003</td>\n",
       "      <td>92550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>CUY-71-6.68</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-106--CUY-71-6.68</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2024.0</td>\n",
       "      <td>104720</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY715.21</td>\n",
       "      <td>106</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>93650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>CUY-71-6.68</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-107--CUY-71-6.68</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>99150</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY715.52</td>\n",
       "      <td>107</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2003</td>\n",
       "      <td>108520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>CUY-71-6.68</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-107--CUY-71-6.68</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2024.0</td>\n",
       "      <td>112650</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY715.52</td>\n",
       "      <td>107</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>104340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>CUY-71-6.68</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-108--CUY-71-6.68</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>111280</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY716.68</td>\n",
       "      <td>108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2003</td>\n",
       "      <td>116790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>CUY-71-6.68</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-108--CUY-71-6.68</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2024.0</td>\n",
       "      <td>123940</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY716.68</td>\n",
       "      <td>108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>110160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>CUY-71-6.68</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-109--CUY-71-6.68</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>114080</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY718.84</td>\n",
       "      <td>109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2003</td>\n",
       "      <td>119890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>CUY-71-6.68</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-109--CUY-71-6.68</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2024.0</td>\n",
       "      <td>124140</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY718.84</td>\n",
       "      <td>109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>114050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>CUY-271-13.45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-183--CUY-271-13.45</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>109490</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY27113.45</td>\n",
       "      <td>183</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007</td>\n",
       "      <td>103890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>CUY-271-13.45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-183--CUY-271-13.45</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2025.0</td>\n",
       "      <td>150870</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY27113.45</td>\n",
       "      <td>183</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>113670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>CUY-271-13.45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-200--CUY-271-13.45</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>37800</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY32211.98</td>\n",
       "      <td>200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007</td>\n",
       "      <td>27710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>CUY-271-13.45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-200--CUY-271-13.45</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2025.0</td>\n",
       "      <td>47450</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY32211.98</td>\n",
       "      <td>200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>26070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>620</th>\n",
       "      <td>DAR-36-13.28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-312--DAR-36-13.28</td>\n",
       "      <td>Darke</td>\n",
       "      <td>1</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>7710</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , DAR3613.28</td>\n",
       "      <td>312</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007</td>\n",
       "      <td>6430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>621</th>\n",
       "      <td>DAR-36-13.28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-312--DAR-36-13.28</td>\n",
       "      <td>Darke</td>\n",
       "      <td>1</td>\n",
       "      <td>2026.0</td>\n",
       "      <td>9150</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , DAR3613.28</td>\n",
       "      <td>312</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>6000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>622</th>\n",
       "      <td>DAR-36-13.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-313--DAR-36-13.29</td>\n",
       "      <td>Darke</td>\n",
       "      <td>1</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>13090</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , DAR57113.38</td>\n",
       "      <td>313</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007</td>\n",
       "      <td>12340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623</th>\n",
       "      <td>DAR-36-13.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-313--DAR-36-13.29</td>\n",
       "      <td>Darke</td>\n",
       "      <td>1</td>\n",
       "      <td>2026.0</td>\n",
       "      <td>15560</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , DAR57113.38</td>\n",
       "      <td>313</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>10320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>632</th>\n",
       "      <td>DAR-36-13.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-318--DAR-36-13.30</td>\n",
       "      <td>Darke</td>\n",
       "      <td>1</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>6870</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , DAR57113.51</td>\n",
       "      <td>318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007</td>\n",
       "      <td>4300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>633</th>\n",
       "      <td>DAR-36-13.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-318--DAR-36-13.30</td>\n",
       "      <td>Darke</td>\n",
       "      <td>1</td>\n",
       "      <td>2026.0</td>\n",
       "      <td>8180</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , DAR57113.51</td>\n",
       "      <td>318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>4610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>862</th>\n",
       "      <td>MOT-675 @ Alex Bell Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-433--MOT-675 @ Alex Bell Road</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>1</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>38760</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , MOT6752.1</td>\n",
       "      <td>433</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2006</td>\n",
       "      <td>44030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>863</th>\n",
       "      <td>MOT-675 @ Alex Bell Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-433--MOT-675 @ Alex Bell Road</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>1</td>\n",
       "      <td>2027.0</td>\n",
       "      <td>48600</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , MOT6752.1</td>\n",
       "      <td>433</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009</td>\n",
       "      <td>41610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>864</th>\n",
       "      <td>MOT-675 @ Alex Bell Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-434--MOT-675 @ Alex Bell Road</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>1</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>63940</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , MOT6752.33</td>\n",
       "      <td>434</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2006</td>\n",
       "      <td>64190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>865</th>\n",
       "      <td>MOT-675 @ Alex Bell Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-434--MOT-675 @ Alex Bell Road</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>1</td>\n",
       "      <td>2027.0</td>\n",
       "      <td>77600</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , MOT6752.33</td>\n",
       "      <td>434</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009</td>\n",
       "      <td>66090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>866</th>\n",
       "      <td>MOT-675 @ Alex Bell Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-435--MOT-675 @ Alex Bell Road</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>1</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>54300</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , MOT6754.47</td>\n",
       "      <td>435</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2006</td>\n",
       "      <td>55280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>867</th>\n",
       "      <td>MOT-675 @ Alex Bell Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-435--MOT-675 @ Alex Bell Road</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>1</td>\n",
       "      <td>2027.0</td>\n",
       "      <td>67180</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , MOT6754.47</td>\n",
       "      <td>435</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009</td>\n",
       "      <td>57390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1758</th>\n",
       "      <td>CUY-21-5.93 (Pleasant Valley Rd)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-881--CUY-21-5.93 (Pleasant Valley Rd)</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>15350</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY215.17</td>\n",
       "      <td>881</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007</td>\n",
       "      <td>15580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1759</th>\n",
       "      <td>CUY-21-5.93 (Pleasant Valley Rd)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-881--CUY-21-5.93 (Pleasant Valley Rd)</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2028.0</td>\n",
       "      <td>15430</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY215.17</td>\n",
       "      <td>881</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>16950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1760</th>\n",
       "      <td>CUY-21-5.93 (Pleasant Valley Rd)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-882--CUY-21-5.93 (Pleasant Valley Rd)</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>16570</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY215.17</td>\n",
       "      <td>882</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007</td>\n",
       "      <td>15580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1761</th>\n",
       "      <td>CUY-21-5.93 (Pleasant Valley Rd)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-882--CUY-21-5.93 (Pleasant Valley Rd)</td>\n",
       "      <td>Cuyahoga</td>\n",
       "      <td>1</td>\n",
       "      <td>2028.0</td>\n",
       "      <td>17510</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , CUY215.17</td>\n",
       "      <td>882</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2010</td>\n",
       "      <td>16950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2820</th>\n",
       "      <td>MOT-70- at Arlington Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-1412--MOT-70- at Arlington Road</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>1</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>45520</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , MOT700</td>\n",
       "      <td>1412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009</td>\n",
       "      <td>36930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2821</th>\n",
       "      <td>MOT-70- at Arlington Road</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41-1412--MOT-70- at Arlington Road</td>\n",
       "      <td>Montgomery</td>\n",
       "      <td>1</td>\n",
       "      <td>2030.0</td>\n",
       "      <td>64640</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>6</td>\n",
       "      <td>, , MOT700</td>\n",
       "      <td>1412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2009</td>\n",
       "      <td>36930</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15159</th>\n",
       "      <td>SR 817 at Nova Drive (MP 8.129)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8977--SR 817 at Nova Drive (MP 8.129)</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>53600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>1;4</td>\n",
       "      <td>SR 817 at Nova Drive (MP 8.129)</td>\n",
       "      <td>8977</td>\n",
       "      <td>86220000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>54500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15160</th>\n",
       "      <td>SR 845/Powerline Rd. from N of 19th St. (MP 1....</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8978--SR 845/Powerline Rd. from N of 19th S...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>26700</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>SR 845/Powerline Rd. from N of 19th St. (MP 1....</td>\n",
       "      <td>8978</td>\n",
       "      <td>86065000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>24600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15161</th>\n",
       "      <td>SR 818/Griffin Rd. from (MP 6.176) to (MP 6.276)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8979--SR 818/Griffin Rd. from (MP 6.176) to...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>33200</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>SR 818/Griffin Rd. from (MP 6.176) to (MP 6.276)</td>\n",
       "      <td>8979</td>\n",
       "      <td>86015000.0</td>\n",
       "      <td>2014</td>\n",
       "      <td>32500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15162</th>\n",
       "      <td>SR A1A from Meade St. to Oak St.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8980--SR A1A from Meade St. to Oak St.</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>10800</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>SR A1A from Meade St. to Oak St.</td>\n",
       "      <td>8980</td>\n",
       "      <td>86030000.0</td>\n",
       "      <td>2014</td>\n",
       "      <td>10000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15163</th>\n",
       "      <td>SR A1A FROM Mercedes River Small (MP 0.750) to...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8981--SR A1A FROM Mercedes River Small (MP ...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>30900</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Location # 1</td>\n",
       "      <td>8981</td>\n",
       "      <td>86050000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>37000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15164</th>\n",
       "      <td>SR A1A FROM Mercedes River Small (MP 0.750) to...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8982--SR A1A FROM Mercedes River Small (MP ...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>16700</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Location # 2</td>\n",
       "      <td>8982</td>\n",
       "      <td>86050000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>16200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15165</th>\n",
       "      <td>SR A1A FROM Mercedes River Small (MP 0.750) to...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8983--SR A1A FROM Mercedes River Small (MP ...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>16100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Location # 3</td>\n",
       "      <td>8983</td>\n",
       "      <td>86050000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>14900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15166</th>\n",
       "      <td>SR A1A FROM Mercedes River Small (MP 0.750) to...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8984--SR A1A FROM Mercedes River Small (MP ...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>16300</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Location # 4</td>\n",
       "      <td>8984</td>\n",
       "      <td>86050000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>18200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15167</th>\n",
       "      <td>SR A1A FROM Mercedes River Small (MP 0.750) to...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8985--SR A1A FROM Mercedes River Small (MP ...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>15800</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Location # 5</td>\n",
       "      <td>8985</td>\n",
       "      <td>86050000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>16000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15168</th>\n",
       "      <td>SR A1A FROM Mercedes River Small (MP 0.750) to...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8986--SR A1A FROM Mercedes River Small (MP ...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>32200</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Location # 6</td>\n",
       "      <td>8986</td>\n",
       "      <td>86050000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>33900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15169</th>\n",
       "      <td>SR 810 (Hillsboro Boulevard fro Military Trial...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8987--SR 810 (Hillsboro Boulevard fro Milit...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>48600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>1;4</td>\n",
       "      <td>Military Trail to SR 811 Dixie Highway</td>\n",
       "      <td>8987</td>\n",
       "      <td>86120000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>45600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15170</th>\n",
       "      <td>SR 810 (Hillsboro Boulevard fro Military Trial...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8988--SR 810 (Hillsboro Boulevard fro Milit...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>35300</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>1;4</td>\n",
       "      <td>SR 811 Dixie Highway to US 1</td>\n",
       "      <td>8988</td>\n",
       "      <td>86120000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>28100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15171</th>\n",
       "      <td>SR 812/Hooker Highway from MP 0.00 to MP 0.785</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8989--SR 812/Hooker Highway from MP 0.00 to...</td>\n",
       "      <td>Palm Beach</td>\n",
       "      <td>1</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>6700</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>SR 812/Hooker Highway from MP 0.00 to MP 0.785</td>\n",
       "      <td>8989</td>\n",
       "      <td>93121000.0</td>\n",
       "      <td>2014</td>\n",
       "      <td>3600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15172</th>\n",
       "      <td>SR 80/Hooker Highway from Railroad Crossing (M...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8990--SR 80/Hooker Highway from Railroad Cr...</td>\n",
       "      <td>Palm Beach</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>10500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>6</td>\n",
       "      <td>SR 80 from Railroad Crossing (MP 3.446) to Con...</td>\n",
       "      <td>8990</td>\n",
       "      <td>93110001.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>9300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15173</th>\n",
       "      <td>SR 80/Hooker Highway from Railroad Crossing (M...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8991--SR 80/Hooker Highway from Railroad Cr...</td>\n",
       "      <td>Palm Beach</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>14500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>6</td>\n",
       "      <td>SR 80 from Connors Highway (MP 13.372) to CR 8...</td>\n",
       "      <td>8991</td>\n",
       "      <td>93110001.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>9300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15174</th>\n",
       "      <td>SR A1A from NE 14th Court (MP 3.850) to NE 18t...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8992--SR A1A from NE 14th Court (MP 3.850) ...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>30300</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>1;4</td>\n",
       "      <td>SR A1A from NE 14th Court (MP 3.850) to NE 18t...</td>\n",
       "      <td>8992</td>\n",
       "      <td>86050000.0</td>\n",
       "      <td>2013</td>\n",
       "      <td>19100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15175</th>\n",
       "      <td>SR 842 from 24th Ave. to 7th Ave</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8993--SR 842 from 24th Ave. to 7th Ave</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>72200</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Location # 1</td>\n",
       "      <td>8993</td>\n",
       "      <td>86006000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>79700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15176</th>\n",
       "      <td>SR 842 from 24th Ave. to 7th Ave</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8994--SR 842 from 24th Ave. to 7th Ave</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>57900</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Locaion # 2</td>\n",
       "      <td>8994</td>\n",
       "      <td>86006000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>61900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15177</th>\n",
       "      <td>SR 842 Broward Boulevard/University\\r\\nDrive</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8995--SR 842 Broward Boulevard/University\\r...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>57700</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>2</td>\n",
       "      <td>SR 842 Broward Boulevard/University\\r\\nDrive</td>\n",
       "      <td>8995</td>\n",
       "      <td>86006000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>45000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15178</th>\n",
       "      <td>SR 9/I 95 at 10th St. (MP 23.050)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8996--SR 9/I 95 at 10th St. (MP 23.050)</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>231000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>4</td>\n",
       "      <td>I 95 north of SW 10th St.</td>\n",
       "      <td>8996</td>\n",
       "      <td>86070000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>211100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15179</th>\n",
       "      <td>SR 9/I 95 at 10th St. (MP 23.050)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8997--SR 9/I 95 at 10th St. (MP 23.050)</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>210000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>4</td>\n",
       "      <td>I 95 south of SW 10th St.</td>\n",
       "      <td>8997</td>\n",
       "      <td>86070000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>224000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15180</th>\n",
       "      <td>SR 869/SW 10th St. from Military trail (MP 1.4...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8998--SR 869/SW 10th St. from Military trai...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>52800</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Location # 1</td>\n",
       "      <td>8998</td>\n",
       "      <td>89012000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>52800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15181</th>\n",
       "      <td>SR 869/SW 10th St. from Military trail (MP 1.4...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-8999--SR 869/SW 10th St. from Military trai...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>33200</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Location # 2</td>\n",
       "      <td>8999</td>\n",
       "      <td>89012000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>27800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15182</th>\n",
       "      <td>SR 9/I 95 ramp (MP 0.000) to WB SR 816/Oakland...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-9000--SR 9/I 95 ramp (MP 0.000) to WB SR 81...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>12200</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR 9/I 95 NB Off-ramp MP (0.000) to WB SR 816/...</td>\n",
       "      <td>9000</td>\n",
       "      <td>86070051.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>13600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15183</th>\n",
       "      <td>SR CR 611/Jenkins Rd. from 11001 South of SR 7...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-9001--SR CR 611/Jenkins Rd. from 11001 Sout...</td>\n",
       "      <td>St. Lucie</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>14800</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>1;4</td>\n",
       "      <td>Location # 1</td>\n",
       "      <td>9001</td>\n",
       "      <td>94631003.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>6400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15184</th>\n",
       "      <td>SR CR 611/Jenkins Rd. from 11001 South of SR 7...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-9002--SR CR 611/Jenkins Rd. from 11001 Sout...</td>\n",
       "      <td>St. Lucie</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>11200</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>1;4</td>\n",
       "      <td>Location # 2</td>\n",
       "      <td>9002</td>\n",
       "      <td>94631003.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>8800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15185</th>\n",
       "      <td>SR 710/SW Warfield Blvd from FPL Martin Power ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-9003--SR 710/SW Warfield Blvd from FPL Mart...</td>\n",
       "      <td>Martin</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>9300</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>6</td>\n",
       "      <td>SR 710/SW Warfield Blvd from FPL Martin Power ...</td>\n",
       "      <td>9003</td>\n",
       "      <td>89070000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>6600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15186</th>\n",
       "      <td>SR-834 at Andrews Ave. Ext/ Military Trail (MP...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-9004--SR-834 at Andrews Ave. Ext/ Military ...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>45400</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>1;4</td>\n",
       "      <td>SR-834 at Andrews Ave. Ext/ Military Trail (MP...</td>\n",
       "      <td>9004</td>\n",
       "      <td>86028000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>49300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15187</th>\n",
       "      <td>SR 838/Sunrise Blvd from NE 17th Way to NE 20t...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-9005--SR 838/Sunrise Blvd from NE 17th Way ...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>5700</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>4</td>\n",
       "      <td>NE 20th Ave.</td>\n",
       "      <td>9005</td>\n",
       "      <td>86005000.0</td>\n",
       "      <td>2014</td>\n",
       "      <td>4900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15188</th>\n",
       "      <td>SR-84 from US-1 (MP 19.721) to S. Miami Rd (MP...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-9006--SR-84 from US-1 (MP 19.721) to S. Mia...</td>\n",
       "      <td>Broward</td>\n",
       "      <td>1</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>21900</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>1;4</td>\n",
       "      <td>SR-84 from US-1 (MP 19.721) to S. Miami Rd (MP...</td>\n",
       "      <td>9006</td>\n",
       "      <td>86080000.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>24000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1879 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        BriefDescription  Length_miles  \\\n",
       "208                                          CUY-71-6.68           NaN   \n",
       "209                                          CUY-71-6.68           NaN   \n",
       "210                                          CUY-71-6.68           NaN   \n",
       "211                                          CUY-71-6.68           NaN   \n",
       "212                                          CUY-71-6.68           NaN   \n",
       "213                                          CUY-71-6.68           NaN   \n",
       "214                                          CUY-71-6.68           NaN   \n",
       "215                                          CUY-71-6.68           NaN   \n",
       "362                                        CUY-271-13.45           NaN   \n",
       "363                                        CUY-271-13.45           NaN   \n",
       "396                                        CUY-271-13.45           NaN   \n",
       "397                                        CUY-271-13.45           NaN   \n",
       "620                                         DAR-36-13.28           NaN   \n",
       "621                                         DAR-36-13.28           NaN   \n",
       "622                                         DAR-36-13.29           NaN   \n",
       "623                                         DAR-36-13.29           NaN   \n",
       "632                                         DAR-36-13.30           NaN   \n",
       "633                                         DAR-36-13.30           NaN   \n",
       "862                             MOT-675 @ Alex Bell Road           NaN   \n",
       "863                             MOT-675 @ Alex Bell Road           NaN   \n",
       "864                             MOT-675 @ Alex Bell Road           NaN   \n",
       "865                             MOT-675 @ Alex Bell Road           NaN   \n",
       "866                             MOT-675 @ Alex Bell Road           NaN   \n",
       "867                             MOT-675 @ Alex Bell Road           NaN   \n",
       "1758                    CUY-21-5.93 (Pleasant Valley Rd)           NaN   \n",
       "1759                    CUY-21-5.93 (Pleasant Valley Rd)           NaN   \n",
       "1760                    CUY-21-5.93 (Pleasant Valley Rd)           NaN   \n",
       "1761                    CUY-21-5.93 (Pleasant Valley Rd)           NaN   \n",
       "2820                           MOT-70- at Arlington Road           NaN   \n",
       "2821                           MOT-70- at Arlington Road           NaN   \n",
       "...                                                  ...           ...   \n",
       "15159                    SR 817 at Nova Drive (MP 8.129)           NaN   \n",
       "15160  SR 845/Powerline Rd. from N of 19th St. (MP 1....           NaN   \n",
       "15161   SR 818/Griffin Rd. from (MP 6.176) to (MP 6.276)           NaN   \n",
       "15162                   SR A1A from Meade St. to Oak St.           NaN   \n",
       "15163  SR A1A FROM Mercedes River Small (MP 0.750) to...           NaN   \n",
       "15164  SR A1A FROM Mercedes River Small (MP 0.750) to...           NaN   \n",
       "15165  SR A1A FROM Mercedes River Small (MP 0.750) to...           NaN   \n",
       "15166  SR A1A FROM Mercedes River Small (MP 0.750) to...           NaN   \n",
       "15167  SR A1A FROM Mercedes River Small (MP 0.750) to...           NaN   \n",
       "15168  SR A1A FROM Mercedes River Small (MP 0.750) to...           NaN   \n",
       "15169  SR 810 (Hillsboro Boulevard fro Military Trial...           NaN   \n",
       "15170  SR 810 (Hillsboro Boulevard fro Military Trial...           NaN   \n",
       "15171     SR 812/Hooker Highway from MP 0.00 to MP 0.785           NaN   \n",
       "15172  SR 80/Hooker Highway from Railroad Crossing (M...           NaN   \n",
       "15173  SR 80/Hooker Highway from Railroad Crossing (M...           NaN   \n",
       "15174  SR A1A from NE 14th Court (MP 3.850) to NE 18t...           NaN   \n",
       "15175                   SR 842 from 24th Ave. to 7th Ave           NaN   \n",
       "15176                   SR 842 from 24th Ave. to 7th Ave           NaN   \n",
       "15177       SR 842 Broward Boulevard/University\\r\\nDrive           NaN   \n",
       "15178                  SR 9/I 95 at 10th St. (MP 23.050)           NaN   \n",
       "15179                  SR 9/I 95 at 10th St. (MP 23.050)           NaN   \n",
       "15180  SR 869/SW 10th St. from Military trail (MP 1.4...           NaN   \n",
       "15181  SR 869/SW 10th St. from Military trail (MP 1.4...           NaN   \n",
       "15182  SR 9/I 95 ramp (MP 0.000) to WB SR 816/Oakland...           NaN   \n",
       "15183  SR CR 611/Jenkins Rd. from 11001 South of SR 7...           NaN   \n",
       "15184  SR CR 611/Jenkins Rd. from 11001 South of SR 7...           NaN   \n",
       "15185  SR 710/SW Warfield Blvd from FPL Martin Power ...           NaN   \n",
       "15186  SR-834 at Andrews Ave. Ext/ Military Trail (MP...           NaN   \n",
       "15187  SR 838/Sunrise Blvd from NE 17th Way to NE 20t...           NaN   \n",
       "15188  SR-84 from US-1 (MP 19.721) to S. Miami Rd (MP...           NaN   \n",
       "\n",
       "       FunctionalClass  ImprovementType  State InternalProjectID  \\\n",
       "208                1.0              NaN   41.0               NaN   \n",
       "209                1.0              NaN   41.0               NaN   \n",
       "210                1.0              NaN   41.0               NaN   \n",
       "211                1.0              NaN   41.0               NaN   \n",
       "212                1.0              NaN   41.0               NaN   \n",
       "213                1.0              NaN   41.0               NaN   \n",
       "214                1.0              NaN   41.0               NaN   \n",
       "215                1.0              NaN   41.0               NaN   \n",
       "362                1.0              NaN   41.0               NaN   \n",
       "363                1.0              NaN   41.0               NaN   \n",
       "396                3.0              NaN   41.0               NaN   \n",
       "397                3.0              NaN   41.0               NaN   \n",
       "620                3.0              NaN   41.0               NaN   \n",
       "621                3.0              NaN   41.0               NaN   \n",
       "622                3.0              NaN   41.0               NaN   \n",
       "623                3.0              NaN   41.0               NaN   \n",
       "632                4.0              NaN   41.0               NaN   \n",
       "633                4.0              NaN   41.0               NaN   \n",
       "862                1.0              NaN   41.0               NaN   \n",
       "863                1.0              NaN   41.0               NaN   \n",
       "864                1.0              NaN   41.0               NaN   \n",
       "865                1.0              NaN   41.0               NaN   \n",
       "866                1.0              NaN   41.0               NaN   \n",
       "867                1.0              NaN   41.0               NaN   \n",
       "1758               4.0              NaN   41.0               NaN   \n",
       "1759               4.0              NaN   41.0               NaN   \n",
       "1760               4.0              NaN   41.0               NaN   \n",
       "1761               4.0              NaN   41.0               NaN   \n",
       "2820               1.0              NaN   41.0               NaN   \n",
       "2821               1.0              NaN   41.0               NaN   \n",
       "...                ...              ...    ...               ...   \n",
       "15159              NaN              NaN   12.0               NaN   \n",
       "15160              NaN              NaN   12.0               NaN   \n",
       "15161              NaN              NaN   12.0               NaN   \n",
       "15162              NaN              NaN   12.0               NaN   \n",
       "15163              NaN              NaN   12.0               NaN   \n",
       "15164              NaN              NaN   12.0               NaN   \n",
       "15165              NaN              NaN   12.0               NaN   \n",
       "15166              NaN              NaN   12.0               NaN   \n",
       "15167              NaN              NaN   12.0               NaN   \n",
       "15168              NaN              NaN   12.0               NaN   \n",
       "15169              NaN              NaN   12.0               NaN   \n",
       "15170              NaN              NaN   12.0               NaN   \n",
       "15171              NaN              NaN   12.0               NaN   \n",
       "15172              NaN              NaN   12.0               NaN   \n",
       "15173              NaN              NaN   12.0               NaN   \n",
       "15174              NaN              NaN   12.0               NaN   \n",
       "15175              NaN              NaN   12.0               NaN   \n",
       "15176              NaN              NaN   12.0               NaN   \n",
       "15177              NaN              NaN   12.0               NaN   \n",
       "15178              NaN              NaN   12.0               NaN   \n",
       "15179              NaN              NaN   12.0               NaN   \n",
       "15180              NaN              NaN   12.0               NaN   \n",
       "15181              NaN              NaN   12.0               NaN   \n",
       "15182              NaN              NaN   12.0               NaN   \n",
       "15183              NaN              NaN   12.0               NaN   \n",
       "15184              NaN              NaN   12.0               NaN   \n",
       "15185              NaN              NaN   12.0               NaN   \n",
       "15186              NaN              NaN   12.0               NaN   \n",
       "15187              NaN              NaN   12.0               NaN   \n",
       "15188              NaN              NaN   12.0               NaN   \n",
       "\n",
       "                       main_ProjectInformation_ProjectID      County  \\\n",
       "208                                  41-106--CUY-71-6.68    Cuyahoga   \n",
       "209                                  41-106--CUY-71-6.68    Cuyahoga   \n",
       "210                                  41-107--CUY-71-6.68    Cuyahoga   \n",
       "211                                  41-107--CUY-71-6.68    Cuyahoga   \n",
       "212                                  41-108--CUY-71-6.68    Cuyahoga   \n",
       "213                                  41-108--CUY-71-6.68    Cuyahoga   \n",
       "214                                  41-109--CUY-71-6.68    Cuyahoga   \n",
       "215                                  41-109--CUY-71-6.68    Cuyahoga   \n",
       "362                                41-183--CUY-271-13.45    Cuyahoga   \n",
       "363                                41-183--CUY-271-13.45    Cuyahoga   \n",
       "396                                41-200--CUY-271-13.45    Cuyahoga   \n",
       "397                                41-200--CUY-271-13.45    Cuyahoga   \n",
       "620                                 41-312--DAR-36-13.28       Darke   \n",
       "621                                 41-312--DAR-36-13.28       Darke   \n",
       "622                                 41-313--DAR-36-13.29       Darke   \n",
       "623                                 41-313--DAR-36-13.29       Darke   \n",
       "632                                 41-318--DAR-36-13.30       Darke   \n",
       "633                                 41-318--DAR-36-13.30       Darke   \n",
       "862                     41-433--MOT-675 @ Alex Bell Road  Montgomery   \n",
       "863                     41-433--MOT-675 @ Alex Bell Road  Montgomery   \n",
       "864                     41-434--MOT-675 @ Alex Bell Road  Montgomery   \n",
       "865                     41-434--MOT-675 @ Alex Bell Road  Montgomery   \n",
       "866                     41-435--MOT-675 @ Alex Bell Road  Montgomery   \n",
       "867                     41-435--MOT-675 @ Alex Bell Road  Montgomery   \n",
       "1758            41-881--CUY-21-5.93 (Pleasant Valley Rd)    Cuyahoga   \n",
       "1759            41-881--CUY-21-5.93 (Pleasant Valley Rd)    Cuyahoga   \n",
       "1760            41-882--CUY-21-5.93 (Pleasant Valley Rd)    Cuyahoga   \n",
       "1761            41-882--CUY-21-5.93 (Pleasant Valley Rd)    Cuyahoga   \n",
       "2820                  41-1412--MOT-70- at Arlington Road  Montgomery   \n",
       "2821                  41-1412--MOT-70- at Arlington Road  Montgomery   \n",
       "...                                                  ...         ...   \n",
       "15159           12-8977--SR 817 at Nova Drive (MP 8.129)     Broward   \n",
       "15160  12-8978--SR 845/Powerline Rd. from N of 19th S...     Broward   \n",
       "15161  12-8979--SR 818/Griffin Rd. from (MP 6.176) to...     Broward   \n",
       "15162          12-8980--SR A1A from Meade St. to Oak St.     Broward   \n",
       "15163  12-8981--SR A1A FROM Mercedes River Small (MP ...     Broward   \n",
       "15164  12-8982--SR A1A FROM Mercedes River Small (MP ...     Broward   \n",
       "15165  12-8983--SR A1A FROM Mercedes River Small (MP ...     Broward   \n",
       "15166  12-8984--SR A1A FROM Mercedes River Small (MP ...     Broward   \n",
       "15167  12-8985--SR A1A FROM Mercedes River Small (MP ...     Broward   \n",
       "15168  12-8986--SR A1A FROM Mercedes River Small (MP ...     Broward   \n",
       "15169  12-8987--SR 810 (Hillsboro Boulevard fro Milit...     Broward   \n",
       "15170  12-8988--SR 810 (Hillsboro Boulevard fro Milit...     Broward   \n",
       "15171  12-8989--SR 812/Hooker Highway from MP 0.00 to...  Palm Beach   \n",
       "15172  12-8990--SR 80/Hooker Highway from Railroad Cr...  Palm Beach   \n",
       "15173  12-8991--SR 80/Hooker Highway from Railroad Cr...  Palm Beach   \n",
       "15174  12-8992--SR A1A from NE 14th Court (MP 3.850) ...     Broward   \n",
       "15175          12-8993--SR 842 from 24th Ave. to 7th Ave     Broward   \n",
       "15176          12-8994--SR 842 from 24th Ave. to 7th Ave     Broward   \n",
       "15177  12-8995--SR 842 Broward Boulevard/University\\r...     Broward   \n",
       "15178         12-8996--SR 9/I 95 at 10th St. (MP 23.050)     Broward   \n",
       "15179         12-8997--SR 9/I 95 at 10th St. (MP 23.050)     Broward   \n",
       "15180  12-8998--SR 869/SW 10th St. from Military trai...     Broward   \n",
       "15181  12-8999--SR 869/SW 10th St. from Military trai...     Broward   \n",
       "15182  12-9000--SR 9/I 95 ramp (MP 0.000) to WB SR 81...     Broward   \n",
       "15183  12-9001--SR CR 611/Jenkins Rd. from 11001 Sout...   St. Lucie   \n",
       "15184  12-9002--SR CR 611/Jenkins Rd. from 11001 Sout...   St. Lucie   \n",
       "15185  12-9003--SR 710/SW Warfield Blvd from FPL Mart...      Martin   \n",
       "15186  12-9004--SR-834 at Andrews Ave. Ext/ Military ...     Broward   \n",
       "15187  12-9005--SR 838/Sunrise Blvd from NE 17th Way ...     Broward   \n",
       "15188  12-9006--SR-84 from US-1 (MP 19.721) to S. Mia...     Broward   \n",
       "\n",
       "       TollType  ForecastYear  TrafficForecast  ForecastYearType  \\\n",
       "208           1        2004.0            88310               1.0   \n",
       "209           1        2024.0           104720               3.0   \n",
       "210           1        2004.0            99150               1.0   \n",
       "211           1        2024.0           112650               3.0   \n",
       "212           1        2004.0           111280               1.0   \n",
       "213           1        2024.0           123940               3.0   \n",
       "214           1        2004.0           114080               1.0   \n",
       "215           1        2024.0           124140               3.0   \n",
       "362           1        2005.0           109490               1.0   \n",
       "363           1        2025.0           150870               3.0   \n",
       "396           1        2005.0            37800               1.0   \n",
       "397           1        2025.0            47450               3.0   \n",
       "620           1        2006.0             7710               1.0   \n",
       "621           1        2026.0             9150               3.0   \n",
       "622           1        2006.0            13090               1.0   \n",
       "623           1        2026.0            15560               3.0   \n",
       "632           1        2006.0             6870               1.0   \n",
       "633           1        2026.0             8180               3.0   \n",
       "862           1        2007.0            38760               1.0   \n",
       "863           1        2027.0            48600               3.0   \n",
       "864           1        2007.0            63940               1.0   \n",
       "865           1        2027.0            77600               3.0   \n",
       "866           1        2007.0            54300               1.0   \n",
       "867           1        2027.0            67180               3.0   \n",
       "1758          1        2008.0            15350               1.0   \n",
       "1759          1        2028.0            15430               3.0   \n",
       "1760          1        2008.0            16570               1.0   \n",
       "1761          1        2028.0            17510               3.0   \n",
       "2820          1        2010.0            45520               1.0   \n",
       "2821          1        2030.0            64640               3.0   \n",
       "...         ...           ...              ...               ...   \n",
       "15159         1        2015.0            53600               1.0   \n",
       "15160         1        2015.0            26700               1.0   \n",
       "15161         1        2014.0            33200               1.0   \n",
       "15162         1        2014.0            10800               1.0   \n",
       "15163         1        2015.0            30900               1.0   \n",
       "15164         1        2015.0            16700               1.0   \n",
       "15165         1        2015.0            16100               1.0   \n",
       "15166         1        2015.0            16300               1.0   \n",
       "15167         1        2015.0            15800               1.0   \n",
       "15168         1        2015.0            32200               1.0   \n",
       "15169         1        2015.0            48600               1.0   \n",
       "15170         1        2015.0            35300               1.0   \n",
       "15171         1        2014.0             6700               1.0   \n",
       "15172         1        2015.0            10500               1.0   \n",
       "15173         1        2015.0            14500               1.0   \n",
       "15174         1        2013.0            30300               1.0   \n",
       "15175         1        2015.0            72200               1.0   \n",
       "15176         1        2015.0            57900               1.0   \n",
       "15177         1        2015.0            57700               1.0   \n",
       "15178         1        2015.0           231000               1.0   \n",
       "15179         1        2015.0           210000               1.0   \n",
       "15180         1        2015.0            52800               1.0   \n",
       "15181         1        2015.0            33200               1.0   \n",
       "15182         1        2015.0            12200               1.0   \n",
       "15183         1        2015.0            14800               1.0   \n",
       "15184         1        2015.0            11200               1.0   \n",
       "15185         1        2015.0             9300               1.0   \n",
       "15186         1        2015.0            45400               1.0   \n",
       "15187         1        2014.0             5700               1.0   \n",
       "15188         1        2015.0            21900               1.0   \n",
       "\n",
       "       YearForecastProduced ForecastMethodology  \\\n",
       "208                  2003.0                   6   \n",
       "209                  2003.0                   6   \n",
       "210                  2003.0                   6   \n",
       "211                  2003.0                   6   \n",
       "212                  2003.0                   6   \n",
       "213                  2003.0                   6   \n",
       "214                  2003.0                   6   \n",
       "215                  2003.0                   6   \n",
       "362                  2003.0                   6   \n",
       "363                  2003.0                   6   \n",
       "396                  2003.0                   6   \n",
       "397                  2003.0                   6   \n",
       "620                  2003.0                   6   \n",
       "621                  2003.0                   6   \n",
       "622                  2003.0                   6   \n",
       "623                  2003.0                   6   \n",
       "632                  2003.0                   6   \n",
       "633                  2003.0                   6   \n",
       "862                  2003.0                   6   \n",
       "863                  2003.0                   6   \n",
       "864                  2003.0                   6   \n",
       "865                  2003.0                   6   \n",
       "866                  2003.0                   6   \n",
       "867                  2003.0                   6   \n",
       "1758                 2008.0                   6   \n",
       "1759                 2008.0                   6   \n",
       "1760                 2008.0                   6   \n",
       "1761                 2008.0                   6   \n",
       "2820                 2009.0                   6   \n",
       "2821                 2009.0                   6   \n",
       "...                     ...                 ...   \n",
       "15159                2012.0                 1;4   \n",
       "15160                2012.0                   4   \n",
       "15161                2012.0                   4   \n",
       "15162                2012.0                   4   \n",
       "15163                2012.0                   4   \n",
       "15164                2012.0                   4   \n",
       "15165                2012.0                   4   \n",
       "15166                2012.0                   4   \n",
       "15167                2012.0                   4   \n",
       "15168                2012.0                   4   \n",
       "15169                2012.0                 1;4   \n",
       "15170                2012.0                 1;4   \n",
       "15171                2012.0                   4   \n",
       "15172                2012.0                   6   \n",
       "15173                2012.0                   6   \n",
       "15174                2012.0                 1;4   \n",
       "15175                2012.0                   4   \n",
       "15176                2012.0                   4   \n",
       "15177                2013.0                   2   \n",
       "15178                2013.0                   4   \n",
       "15179                2013.0                   4   \n",
       "15180                2013.0                   4   \n",
       "15181                2013.0                   4   \n",
       "15182                2013.0                   1   \n",
       "15183                2013.0                 1;4   \n",
       "15184                2013.0                 1;4   \n",
       "15185                2013.0                   6   \n",
       "15186                2014.0                 1;4   \n",
       "15187                2014.0                   4   \n",
       "15188                2014.0                 1;4   \n",
       "\n",
       "                                      SegmentDescription  \\\n",
       "208                                        , , CUY715.21   \n",
       "209                                        , , CUY715.21   \n",
       "210                                        , , CUY715.52   \n",
       "211                                        , , CUY715.52   \n",
       "212                                        , , CUY716.68   \n",
       "213                                        , , CUY716.68   \n",
       "214                                        , , CUY718.84   \n",
       "215                                        , , CUY718.84   \n",
       "362                                      , , CUY27113.45   \n",
       "363                                      , , CUY27113.45   \n",
       "396                                      , , CUY32211.98   \n",
       "397                                      , , CUY32211.98   \n",
       "620                                       , , DAR3613.28   \n",
       "621                                       , , DAR3613.28   \n",
       "622                                      , , DAR57113.38   \n",
       "623                                      , , DAR57113.38   \n",
       "632                                      , , DAR57113.51   \n",
       "633                                      , , DAR57113.51   \n",
       "862                                        , , MOT6752.1   \n",
       "863                                        , , MOT6752.1   \n",
       "864                                       , , MOT6752.33   \n",
       "865                                       , , MOT6752.33   \n",
       "866                                       , , MOT6754.47   \n",
       "867                                       , , MOT6754.47   \n",
       "1758                                       , , CUY215.17   \n",
       "1759                                       , , CUY215.17   \n",
       "1760                                       , , CUY215.17   \n",
       "1761                                       , , CUY215.17   \n",
       "2820                                          , , MOT700   \n",
       "2821                                          , , MOT700   \n",
       "...                                                  ...   \n",
       "15159                    SR 817 at Nova Drive (MP 8.129)   \n",
       "15160  SR 845/Powerline Rd. from N of 19th St. (MP 1....   \n",
       "15161   SR 818/Griffin Rd. from (MP 6.176) to (MP 6.276)   \n",
       "15162                   SR A1A from Meade St. to Oak St.   \n",
       "15163                                       Location # 1   \n",
       "15164                                       Location # 2   \n",
       "15165                                       Location # 3   \n",
       "15166                                       Location # 4   \n",
       "15167                                       Location # 5   \n",
       "15168                                       Location # 6   \n",
       "15169             Military Trail to SR 811 Dixie Highway   \n",
       "15170                       SR 811 Dixie Highway to US 1   \n",
       "15171     SR 812/Hooker Highway from MP 0.00 to MP 0.785   \n",
       "15172  SR 80 from Railroad Crossing (MP 3.446) to Con...   \n",
       "15173  SR 80 from Connors Highway (MP 13.372) to CR 8...   \n",
       "15174  SR A1A from NE 14th Court (MP 3.850) to NE 18t...   \n",
       "15175                                       Location # 1   \n",
       "15176                                        Locaion # 2   \n",
       "15177       SR 842 Broward Boulevard/University\\r\\nDrive   \n",
       "15178                          I 95 north of SW 10th St.   \n",
       "15179                          I 95 south of SW 10th St.   \n",
       "15180                                       Location # 1   \n",
       "15181                                       Location # 2   \n",
       "15182  SR 9/I 95 NB Off-ramp MP (0.000) to WB SR 816/...   \n",
       "15183                                       Location # 1   \n",
       "15184                                       Location # 2   \n",
       "15185  SR 710/SW Warfield Blvd from FPL Martin Power ...   \n",
       "15186  SR-834 at Andrews Ave. Ext/ Military Trail (MP...   \n",
       "15187                                       NE 20th Ave.   \n",
       "15188  SR-84 from US-1 (MP 19.721) to S. Miami Rd (MP...   \n",
       "\n",
       "       main_TrafficForecast_ProjectID   SegmentID  Year_ofObservation   Count  \n",
       "208                               106         NaN                2003   92550  \n",
       "209                               106         NaN                2010   93650  \n",
       "210                               107         NaN                2003  108520  \n",
       "211                               107         NaN                2010  104340  \n",
       "212                               108         NaN                2003  116790  \n",
       "213                               108         NaN                2010  110160  \n",
       "214                               109         NaN                2003  119890  \n",
       "215                               109         NaN                2010  114050  \n",
       "362                               183         NaN                2007  103890  \n",
       "363                               183         NaN                2010  113670  \n",
       "396                               200         NaN                2007   27710  \n",
       "397                               200         NaN                2010   26070  \n",
       "620                               312         NaN                2007    6430  \n",
       "621                               312         NaN                2010    6000  \n",
       "622                               313         NaN                2007   12340  \n",
       "623                               313         NaN                2010   10320  \n",
       "632                               318         NaN                2007    4300  \n",
       "633                               318         NaN                2010    4610  \n",
       "862                               433         NaN                2006   44030  \n",
       "863                               433         NaN                2009   41610  \n",
       "864                               434         NaN                2006   64190  \n",
       "865                               434         NaN                2009   66090  \n",
       "866                               435         NaN                2006   55280  \n",
       "867                               435         NaN                2009   57390  \n",
       "1758                              881         NaN                2007   15580  \n",
       "1759                              881         NaN                2010   16950  \n",
       "1760                              882         NaN                2007   15580  \n",
       "1761                              882         NaN                2010   16950  \n",
       "2820                             1412         NaN                2009   36930  \n",
       "2821                             1412         NaN                2009   36930  \n",
       "...                               ...         ...                 ...     ...  \n",
       "15159                            8977  86220000.0                2015   54500  \n",
       "15160                            8978  86065000.0                2015   24600  \n",
       "15161                            8979  86015000.0                2014   32500  \n",
       "15162                            8980  86030000.0                2014   10000  \n",
       "15163                            8981  86050000.0                2015   37000  \n",
       "15164                            8982  86050000.0                2015   16200  \n",
       "15165                            8983  86050000.0                2015   14900  \n",
       "15166                            8984  86050000.0                2015   18200  \n",
       "15167                            8985  86050000.0                2015   16000  \n",
       "15168                            8986  86050000.0                2015   33900  \n",
       "15169                            8987  86120000.0                2015   45600  \n",
       "15170                            8988  86120000.0                2015   28100  \n",
       "15171                            8989  93121000.0                2014    3600  \n",
       "15172                            8990  93110001.0                2015    9300  \n",
       "15173                            8991  93110001.0                2015    9300  \n",
       "15174                            8992  86050000.0                2013   19100  \n",
       "15175                            8993  86006000.0                2015   79700  \n",
       "15176                            8994  86006000.0                2015   61900  \n",
       "15177                            8995  86006000.0                2015   45000  \n",
       "15178                            8996  86070000.0                2015  211100  \n",
       "15179                            8997  86070000.0                2015  224000  \n",
       "15180                            8998  89012000.0                2015   52800  \n",
       "15181                            8999  89012000.0                2015   27800  \n",
       "15182                            9000  86070051.0                2015   13600  \n",
       "15183                            9001  94631003.0                2015    6400  \n",
       "15184                            9002  94631003.0                2015    8800  \n",
       "15185                            9003  89070000.0                2015    6600  \n",
       "15186                            9004  86028000.0                2015   49300  \n",
       "15187                            9005  86005000.0                2014    4900  \n",
       "15188                            9006  86080000.0                2015   24000  \n",
       "\n",
       "[1879 rows x 19 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flatdata_withoutID=df[df['InternalProjectID'].isnull()]\n",
    "flatdata_withoutID"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
=======
>>>>>>> parent of c25d92c... Merge branch 'master' of https://github.com/jawadmhoque/accuracy-assessment
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}