A_Prepare-Segment-Factors.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import os\n",
    "import pandas as pd\n",
    "\n",
    "# Import the required ArcGIS API for Python modules\n",
    "import arcgis\n",
    "from arcgis.gis import GIS\n",
    "gis = arcgis.GIS()\n",
    "from arcgis.geoanalytics import manage_data\n",
    "\n",
    "from IPython.display import display, Markdown"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "dirWork         = os.getcwd()\n",
    "dirInput        = os.path.join(dirWork, r'input'         )\n",
    "dirIntermediate = os.path.join(dirWork, r'intermediate'  )\n",
    "dirResults      = os.path.join(dirWork, r'results'       )\n",
    "dirParams       = os.path.join(dirWork, r'params'        )\n",
    "dirWebApp       = os.path.join(dirResults, r'webapp_data')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "#intermediate output\n",
    "dfFactors = pd.read_csv(os.path.join(dirIntermediate,'CCS_Factors_AllGroupings.csv'))\n",
    "dfSegFac  = pd.read_csv(os.path.join(dirIntermediate, 'SegmentsMatchedToFactorGroups.csv'))\n",
    "dfSegFacWithTrk = pd.read_csv(os.path.join(dirIntermediate, r'SegmentTruckFactors.csv'))\n",
    "\n",
    "#Start with UDOT Base\n",
    "#sdfSegments = pd.DataFrame.spatial.from_featureclass(os.path.join(dirWork,  r\"arcgis\\UDOT-Segments.gdb\\Master_Segs_20210811\"))\n",
    "\n",
    "#Start with Modified Base - and strip down of factor fields\n",
    "sdfSegments = pd.DataFrame.spatial.from_featureclass(r\"K:\\TDM\\0 - ModelDev\\1 - Official Release\\v8.3.2\\WF TDM v8.3.2 - 2021-11-10\\1_Inputs\\6_Segment\\Master_Segs_withFactors_20211117.shp\")\n",
    "sdfSegments = sdfSegments.drop(columns=['FAC_MON'  ,'FAC_TUE'  ,'FAC_WED'  ,'FAC_THU'  ,'FAC_FRI'  ,'FAC_SAT'  ,'FAC_SUN'  ,'FAC_WDAVG','FAC_WEAVG','FAC_WEMAX','FAC_JAN'  ,'FAC_FEB'  ,'FAC_MAR'  ,'FAC_APR'  ,'FAC_MAY'  ,'FAC_JUN'  ,'FAC_JUL'  ,'FAC_AUG'  ,'FAC_SEP'  ,'FAC_OCT'  ,'FAC_NOV'  ,'FAC_DEC'  ,'FAC_WIN'   ,'FAC_SPR'   ,'FAC_SUM'   ,'FAC_FAL'  ,'FAC_MAXMO','FAC_MAX'  ,'FACMANADJ','CUTRUCKS','SUTRUCKS'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "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>SEGID</th>\n",
       "      <th>AADT2019</th>\n",
       "      <th>AREATYPE</th>\n",
       "      <th>FTGROUP</th>\n",
       "      <th>FACGEO</th>\n",
       "      <th>STATIONGROUP</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>WD0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>SNP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0006_000.7</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>WD0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0006_000.7</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>SNP</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25684</th>\n",
       "      <td>WFRC_8222</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>SNU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25685</th>\n",
       "      <td>WFRC_8222</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25686</th>\n",
       "      <td>WFRC_8223</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>WD3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25687</th>\n",
       "      <td>WFRC_8223</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>SNU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25688</th>\n",
       "      <td>WFRC_8223</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COU</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25689 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            SEGID  AADT2019  AREATYPE   FTGROUP     FACGEO STATIONGROUP\n",
       "0      0006_000.0     415.0       1.0  Arterial  Statewide          WD0\n",
       "1      0006_000.0     415.0       1.0  Arterial  Statewide          SNP\n",
       "2      0006_000.0     415.0       1.0  Arterial  Statewide          COP\n",
       "3      0006_000.7     415.0       1.0  Arterial  Statewide          WD0\n",
       "4      0006_000.7     415.0       1.0  Arterial  Statewide          SNP\n",
       "...           ...       ...       ...       ...        ...          ...\n",
       "25684   WFRC_8222       0.0       4.0  Arterial  Statewide          SNU\n",
       "25685   WFRC_8222       0.0       4.0  Arterial  Statewide          COU\n",
       "25686   WFRC_8223       0.0       4.0  Arterial  Statewide          WD3\n",
       "25687   WFRC_8223       0.0       4.0  Arterial  Statewide          SNU\n",
       "25688   WFRC_8223       0.0       4.0  Arterial  Statewide          COU\n",
       "\n",
       "[25689 rows x 6 columns]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfSegFac"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#parameters\n",
    "prmInterpolate = pd.read_csv(os.path.join(dirParams,'segment_factors_interpolate.csv'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "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>SEASONGROUP</th>\n",
       "      <th>YEARGROUP</th>\n",
       "      <th>FACTORNAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_MON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_TUE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_WED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_THU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_FRI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_SAT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_SUN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_WDAVG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_WEAVG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_WEMAX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>M01-Jan</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_JAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>M02-Feb</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_FEB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>M03-Mar</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_MAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>M04-Apr</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_APR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>M05-May</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_MAY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>M06-Jun</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_JUN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>M07-Jul</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_JUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>M08-Aug</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_AUG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>M09-Sep</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_SEP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>M10-Oct</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_OCT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>M11-Nov</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_NOV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>M12-Dec</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_DEC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>S01-Winter</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_WIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>S02-Spring</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_SPR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>S03-Summer</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_SUM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>S04-Fall</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_FAL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_MAXMO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Year</td>\n",
       "      <td>2015-2019</td>\n",
       "      <td>FAC_MAX</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   SEASONGROUP  YEARGROUP FACTORNAME\n",
       "0         Year  2015-2019    FAC_MON\n",
       "1         Year  2015-2019    FAC_TUE\n",
       "2         Year  2015-2019    FAC_WED\n",
       "3         Year  2015-2019    FAC_THU\n",
       "4         Year  2015-2019    FAC_FRI\n",
       "5         Year  2015-2019    FAC_SAT\n",
       "6         Year  2015-2019    FAC_SUN\n",
       "7         Year  2015-2019  FAC_WDAVG\n",
       "8         Year  2015-2019  FAC_WEAVG\n",
       "9         Year  2015-2019  FAC_WEMAX\n",
       "10     M01-Jan  2015-2019    FAC_JAN\n",
       "11     M02-Feb  2015-2019    FAC_FEB\n",
       "12     M03-Mar  2015-2019    FAC_MAR\n",
       "13     M04-Apr  2015-2019    FAC_APR\n",
       "14     M05-May  2015-2019    FAC_MAY\n",
       "15     M06-Jun  2015-2019    FAC_JUN\n",
       "16     M07-Jul  2015-2019    FAC_JUL\n",
       "17     M08-Aug  2015-2019    FAC_AUG\n",
       "18     M09-Sep  2015-2019    FAC_SEP\n",
       "19     M10-Oct  2015-2019    FAC_OCT\n",
       "20     M11-Nov  2015-2019    FAC_NOV\n",
       "21     M12-Dec  2015-2019    FAC_DEC\n",
       "22  S01-Winter  2015-2019    FAC_WIN\n",
       "23  S02-Spring  2015-2019    FAC_SPR\n",
       "24  S03-Summer  2015-2019    FAC_SUM\n",
       "25    S04-Fall  2015-2019    FAC_FAL\n",
       "26        Year  2015-2019  FAC_MAXMO\n",
       "27        Year  2015-2019    FAC_MAX"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>STATIONGROUP</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CO0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CO1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CO2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CO3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CO7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CO4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CO5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CO6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CO8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CO9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>COA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>COB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>COC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>COD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>COY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>COE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>COZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>COF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>COG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>COH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>COI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>COJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>COK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>COL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>COM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>COO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>COP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>COQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>COR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>COS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>COT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>COU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>XX3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>COV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>COW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>COX</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATIONGROUP\n",
       "0           CO0\n",
       "1           CO1\n",
       "2           CO2\n",
       "3           CO3\n",
       "4           CO7\n",
       "5           CO4\n",
       "6           CO5\n",
       "7           CO6\n",
       "8           CO8\n",
       "9           CO9\n",
       "10          COA\n",
       "11          COB\n",
       "12          COC\n",
       "13          COD\n",
       "14          COY\n",
       "15          COE\n",
       "16          COZ\n",
       "17          COF\n",
       "18          COG\n",
       "19          COH\n",
       "20          COI\n",
       "21          COJ\n",
       "22          COK\n",
       "23          COL\n",
       "24          COM\n",
       "25          CON\n",
       "26          COO\n",
       "27          COP\n",
       "28          COQ\n",
       "29          COR\n",
       "30          COS\n",
       "31          COT\n",
       "32          COU\n",
       "33          XX3\n",
       "34          COV\n",
       "35          COW\n",
       "36          COX"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>STATIONGROUP</th>\n",
       "      <th>FACTORNAME</th>\n",
       "      <th>FACTOR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CO0</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.320612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CO1</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.432402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CO2</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>1.140254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CO3</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.385754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CO4</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.751806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1031</th>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_TUE</td>\n",
       "      <td>1.146486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1032</th>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_WDAVG</td>\n",
       "      <td>1.156760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1033</th>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_WEAVG</td>\n",
       "      <td>0.631137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1034</th>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_WED</td>\n",
       "      <td>1.158740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1035</th>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_WEMAX</td>\n",
       "      <td>0.733154</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1036 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     STATIONGROUP FACTORNAME    FACTOR\n",
       "0             CO0    FAC_JAN  0.320612\n",
       "1             CO1    FAC_JAN  0.432402\n",
       "2             CO2    FAC_JAN  1.140254\n",
       "3             CO3    FAC_JAN  0.385754\n",
       "4             CO4    FAC_JAN  0.751806\n",
       "...           ...        ...       ...\n",
       "1031          XX3    FAC_TUE  1.146486\n",
       "1032          XX3  FAC_WDAVG  1.156760\n",
       "1033          XX3  FAC_WEAVG  0.631137\n",
       "1034          XX3    FAC_WED  1.158740\n",
       "1035          XX3  FAC_WEMAX  0.733154\n",
       "\n",
       "[1036 rows x 3 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "dFactorGroupsToPublish = {\n",
    "                           'SEASONGROUP': ['Year'     ,'Year'     ,'Year'     ,'Year'     ,'Year'     ,'Year'     ,'Year'     ,'Year'     ,'Year'     ,'Year'     ,'M01-Jan'  ,'M02-Feb'  ,'M03-Mar'  ,'M04-Apr'  ,'M05-May'  ,'M06-Jun'  ,'M07-Jul'  ,'M08-Aug'  ,'M09-Sep'  ,'M10-Oct'  ,'M11-Nov'  ,'M12-Dec'  ,'S01-Winter','S02-Spring','S03-Summer','S04-Fall' ,'Year'     ,'Year'     ],\n",
    "                           'YEARGROUP'  : ['2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019','2015-2019' ,'2015-2019' ,'2015-2019' ,'2015-2019','2015-2019','2015-2019'],\n",
    "                           'FACTORNAME' : ['FAC_MON'  ,'FAC_TUE'  ,'FAC_WED'  ,'FAC_THU'  ,'FAC_FRI'  ,'FAC_SAT'  ,'FAC_SUN'  ,'FAC_WDAVG','FAC_WEAVG','FAC_WEMAX','FAC_JAN'  ,'FAC_FEB'  ,'FAC_MAR'  ,'FAC_APR'  ,'FAC_MAY'  ,'FAC_JUN'  ,'FAC_JUL'  ,'FAC_AUG'  ,'FAC_SEP'  ,'FAC_OCT'  ,'FAC_NOV'  ,'FAC_DEC'  ,'FAC_WIN'   ,'FAC_SPR'   ,'FAC_SUM'   ,'FAC_FAL'  ,'FAC_MAXMO','FAC_MAX'  ]\n",
    "                         }\n",
    "\n",
    "dStationGroupsToPublish = {'STATIONGROUP': ['CO0',\n",
    "                                            'CO1',\n",
    "                                            'CO2',\n",
    "                                            'CO3',\n",
    "                                            'CO7',\n",
    "                                            'CO4',\n",
    "                                            'CO5',\n",
    "                                            'CO6',\n",
    "                                            'CO8',\n",
    "                                            'CO9',\n",
    "                                            'COA',\n",
    "                                            'COB',\n",
    "                                            'COC',\n",
    "                                            'COD',\n",
    "                                            'COY',\n",
    "                                            'COE',\n",
    "                                            'COZ',\n",
    "                                            'COF',\n",
    "                                            'COG',\n",
    "                                            'COH',\n",
    "                                            'COI',\n",
    "                                            'COJ',\n",
    "                                            'COK',\n",
    "                                            'COL',\n",
    "                                            'COM',\n",
    "                                            'CON',\n",
    "                                            'COO',\n",
    "                                            'COP',\n",
    "                                            'COQ',\n",
    "                                            'COR',\n",
    "                                            'COS',\n",
    "                                            'COT',\n",
    "                                            'COU',\n",
    "                                            'XX3',\n",
    "                                            'COV',\n",
    "                                            'COW',\n",
    "                                            'COX']}\n",
    "\n",
    "dfFactorGroupsToPublish = pd.DataFrame(dFactorGroupsToPublish)\n",
    "display(dfFactorGroupsToPublish)\n",
    "\n",
    "dfStationGroupsToPublish = pd.DataFrame(dStationGroupsToPublish)\n",
    "display(dfStationGroupsToPublish)\n",
    "\n",
    "dfToPublish = pd.DataFrame.merge(dfStationGroupsToPublish,dfFactorGroupsToPublish,how='cross')\n",
    "\n",
    "dfFactorsToPublish = pd.DataFrame.merge(dfFactors,dfToPublish,on=('STATIONGROUP','SEASONGROUP','YEARGROUP','FACTORNAME'))\n",
    "dfFactorsToPublish = dfFactorsToPublish[['STATIONGROUP','FACTORNAME','FACTOR']]\n",
    "display(dfFactorsToPublish)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>FACTORNAME</th>\n",
       "      <th>STATIONGROUP</th>\n",
       "      <th>FAC_APR</th>\n",
       "      <th>FAC_AUG</th>\n",
       "      <th>FAC_DEC</th>\n",
       "      <th>FAC_FAL</th>\n",
       "      <th>FAC_FEB</th>\n",
       "      <th>FAC_FRI</th>\n",
       "      <th>FAC_JAN</th>\n",
       "      <th>FAC_JUL</th>\n",
       "      <th>FAC_JUN</th>\n",
       "      <th>...</th>\n",
       "      <th>FAC_SPR</th>\n",
       "      <th>FAC_SUM</th>\n",
       "      <th>FAC_SUN</th>\n",
       "      <th>FAC_THU</th>\n",
       "      <th>FAC_TUE</th>\n",
       "      <th>FAC_WDAVG</th>\n",
       "      <th>FAC_WEAVG</th>\n",
       "      <th>FAC_WED</th>\n",
       "      <th>FAC_WEMAX</th>\n",
       "      <th>FAC_WIN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CO0</td>\n",
       "      <td>0.553110</td>\n",
       "      <td>1.769128</td>\n",
       "      <td>0.339259</td>\n",
       "      <td>1.107878</td>\n",
       "      <td>0.339494</td>\n",
       "      <td>1.001066</td>\n",
       "      <td>0.320612</td>\n",
       "      <td>2.065796</td>\n",
       "      <td>1.891442</td>\n",
       "      <td>...</td>\n",
       "      <td>0.650212</td>\n",
       "      <td>1.908789</td>\n",
       "      <td>1.528408</td>\n",
       "      <td>0.741788</td>\n",
       "      <td>0.674528</td>\n",
       "      <td>0.715249</td>\n",
       "      <td>1.574201</td>\n",
       "      <td>0.729430</td>\n",
       "      <td>1.619994</td>\n",
       "      <td>0.333122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CO1</td>\n",
       "      <td>0.583450</td>\n",
       "      <td>2.109072</td>\n",
       "      <td>0.476375</td>\n",
       "      <td>0.766020</td>\n",
       "      <td>0.456070</td>\n",
       "      <td>1.232986</td>\n",
       "      <td>0.432402</td>\n",
       "      <td>2.609596</td>\n",
       "      <td>1.676910</td>\n",
       "      <td>...</td>\n",
       "      <td>0.647172</td>\n",
       "      <td>2.131859</td>\n",
       "      <td>1.031369</td>\n",
       "      <td>0.908397</td>\n",
       "      <td>0.769153</td>\n",
       "      <td>0.824043</td>\n",
       "      <td>1.253923</td>\n",
       "      <td>0.794578</td>\n",
       "      <td>1.476478</td>\n",
       "      <td>0.454949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CO2</td>\n",
       "      <td>0.671815</td>\n",
       "      <td>1.230627</td>\n",
       "      <td>1.090283</td>\n",
       "      <td>0.838699</td>\n",
       "      <td>1.120695</td>\n",
       "      <td>1.013876</td>\n",
       "      <td>1.140254</td>\n",
       "      <td>1.352569</td>\n",
       "      <td>1.212064</td>\n",
       "      <td>...</td>\n",
       "      <td>0.779137</td>\n",
       "      <td>1.265087</td>\n",
       "      <td>1.429561</td>\n",
       "      <td>0.801945</td>\n",
       "      <td>0.743486</td>\n",
       "      <td>0.790750</td>\n",
       "      <td>1.445970</td>\n",
       "      <td>0.826818</td>\n",
       "      <td>1.462380</td>\n",
       "      <td>1.117077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CO3</td>\n",
       "      <td>0.671761</td>\n",
       "      <td>1.629033</td>\n",
       "      <td>0.509268</td>\n",
       "      <td>1.159915</td>\n",
       "      <td>0.419881</td>\n",
       "      <td>1.194883</td>\n",
       "      <td>0.385754</td>\n",
       "      <td>1.868239</td>\n",
       "      <td>1.583304</td>\n",
       "      <td>...</td>\n",
       "      <td>0.708258</td>\n",
       "      <td>1.693525</td>\n",
       "      <td>1.105323</td>\n",
       "      <td>0.913895</td>\n",
       "      <td>0.809172</td>\n",
       "      <td>0.853478</td>\n",
       "      <td>1.213439</td>\n",
       "      <td>0.837366</td>\n",
       "      <td>1.321555</td>\n",
       "      <td>0.438301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CO4</td>\n",
       "      <td>1.067708</td>\n",
       "      <td>1.075263</td>\n",
       "      <td>0.890783</td>\n",
       "      <td>1.006220</td>\n",
       "      <td>0.835322</td>\n",
       "      <td>1.228552</td>\n",
       "      <td>0.751806</td>\n",
       "      <td>1.169057</td>\n",
       "      <td>1.125786</td>\n",
       "      <td>...</td>\n",
       "      <td>1.044441</td>\n",
       "      <td>1.123369</td>\n",
       "      <td>1.209043</td>\n",
       "      <td>1.019046</td>\n",
       "      <td>0.810814</td>\n",
       "      <td>0.904970</td>\n",
       "      <td>1.111261</td>\n",
       "      <td>0.885049</td>\n",
       "      <td>1.209043</td>\n",
       "      <td>0.825970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CO5</td>\n",
       "      <td>1.006596</td>\n",
       "      <td>1.101546</td>\n",
       "      <td>0.934678</td>\n",
       "      <td>1.013803</td>\n",
       "      <td>0.871004</td>\n",
       "      <td>1.179292</td>\n",
       "      <td>0.808263</td>\n",
       "      <td>1.137219</td>\n",
       "      <td>1.098088</td>\n",
       "      <td>...</td>\n",
       "      <td>1.002598</td>\n",
       "      <td>1.112284</td>\n",
       "      <td>0.937604</td>\n",
       "      <td>1.028941</td>\n",
       "      <td>0.921979</td>\n",
       "      <td>0.970144</td>\n",
       "      <td>0.995377</td>\n",
       "      <td>0.959513</td>\n",
       "      <td>1.053150</td>\n",
       "      <td>0.871315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CO6</td>\n",
       "      <td>1.018984</td>\n",
       "      <td>1.039075</td>\n",
       "      <td>0.989176</td>\n",
       "      <td>1.013135</td>\n",
       "      <td>0.938123</td>\n",
       "      <td>1.143646</td>\n",
       "      <td>0.893055</td>\n",
       "      <td>1.031387</td>\n",
       "      <td>1.041649</td>\n",
       "      <td>...</td>\n",
       "      <td>1.009377</td>\n",
       "      <td>1.037371</td>\n",
       "      <td>0.677117</td>\n",
       "      <td>1.087783</td>\n",
       "      <td>1.048176</td>\n",
       "      <td>1.065356</td>\n",
       "      <td>0.821210</td>\n",
       "      <td>1.060111</td>\n",
       "      <td>0.965303</td>\n",
       "      <td>0.940118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CO7</td>\n",
       "      <td>0.969037</td>\n",
       "      <td>1.227101</td>\n",
       "      <td>0.860510</td>\n",
       "      <td>0.984139</td>\n",
       "      <td>0.775596</td>\n",
       "      <td>1.234002</td>\n",
       "      <td>0.770656</td>\n",
       "      <td>1.313964</td>\n",
       "      <td>1.169820</td>\n",
       "      <td>...</td>\n",
       "      <td>0.976645</td>\n",
       "      <td>1.236962</td>\n",
       "      <td>1.069474</td>\n",
       "      <td>0.974001</td>\n",
       "      <td>0.854521</td>\n",
       "      <td>0.905874</td>\n",
       "      <td>1.089591</td>\n",
       "      <td>0.889101</td>\n",
       "      <td>1.109709</td>\n",
       "      <td>0.802254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CO8</td>\n",
       "      <td>1.013020</td>\n",
       "      <td>1.005864</td>\n",
       "      <td>0.990349</td>\n",
       "      <td>1.011359</td>\n",
       "      <td>0.978147</td>\n",
       "      <td>1.152104</td>\n",
       "      <td>0.946190</td>\n",
       "      <td>0.997644</td>\n",
       "      <td>1.017415</td>\n",
       "      <td>...</td>\n",
       "      <td>1.010105</td>\n",
       "      <td>1.006974</td>\n",
       "      <td>0.576285</td>\n",
       "      <td>1.147047</td>\n",
       "      <td>1.122313</td>\n",
       "      <td>1.134873</td>\n",
       "      <td>0.681143</td>\n",
       "      <td>1.135259</td>\n",
       "      <td>0.786002</td>\n",
       "      <td>0.971562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CO9</td>\n",
       "      <td>0.997279</td>\n",
       "      <td>1.204012</td>\n",
       "      <td>0.766509</td>\n",
       "      <td>0.994121</td>\n",
       "      <td>0.668810</td>\n",
       "      <td>1.099762</td>\n",
       "      <td>0.649665</td>\n",
       "      <td>1.332174</td>\n",
       "      <td>1.322174</td>\n",
       "      <td>...</td>\n",
       "      <td>1.024764</td>\n",
       "      <td>1.286120</td>\n",
       "      <td>1.005688</td>\n",
       "      <td>1.038314</td>\n",
       "      <td>0.926450</td>\n",
       "      <td>0.979628</td>\n",
       "      <td>1.026169</td>\n",
       "      <td>0.974121</td>\n",
       "      <td>1.046649</td>\n",
       "      <td>0.694994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>COA</td>\n",
       "      <td>0.958342</td>\n",
       "      <td>1.180943</td>\n",
       "      <td>0.815886</td>\n",
       "      <td>1.028209</td>\n",
       "      <td>0.858733</td>\n",
       "      <td>1.121896</td>\n",
       "      <td>0.772274</td>\n",
       "      <td>1.210769</td>\n",
       "      <td>1.163521</td>\n",
       "      <td>...</td>\n",
       "      <td>0.971082</td>\n",
       "      <td>1.185078</td>\n",
       "      <td>1.176762</td>\n",
       "      <td>0.938099</td>\n",
       "      <td>0.832334</td>\n",
       "      <td>0.881412</td>\n",
       "      <td>1.205332</td>\n",
       "      <td>0.873804</td>\n",
       "      <td>1.233903</td>\n",
       "      <td>0.815631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>COB</td>\n",
       "      <td>0.990546</td>\n",
       "      <td>1.077877</td>\n",
       "      <td>0.960467</td>\n",
       "      <td>1.025010</td>\n",
       "      <td>0.917789</td>\n",
       "      <td>1.144096</td>\n",
       "      <td>0.865479</td>\n",
       "      <td>1.056890</td>\n",
       "      <td>1.062943</td>\n",
       "      <td>...</td>\n",
       "      <td>0.994509</td>\n",
       "      <td>1.065904</td>\n",
       "      <td>0.717595</td>\n",
       "      <td>1.076699</td>\n",
       "      <td>1.034051</td>\n",
       "      <td>1.055212</td>\n",
       "      <td>0.840390</td>\n",
       "      <td>1.054887</td>\n",
       "      <td>0.963184</td>\n",
       "      <td>0.914578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>COC</td>\n",
       "      <td>0.979742</td>\n",
       "      <td>1.056728</td>\n",
       "      <td>0.975044</td>\n",
       "      <td>1.012474</td>\n",
       "      <td>0.957638</td>\n",
       "      <td>1.134289</td>\n",
       "      <td>0.926396</td>\n",
       "      <td>1.033595</td>\n",
       "      <td>1.041483</td>\n",
       "      <td>...</td>\n",
       "      <td>0.990564</td>\n",
       "      <td>1.043935</td>\n",
       "      <td>0.645556</td>\n",
       "      <td>1.130753</td>\n",
       "      <td>1.090563</td>\n",
       "      <td>1.110675</td>\n",
       "      <td>0.738239</td>\n",
       "      <td>1.110709</td>\n",
       "      <td>0.830923</td>\n",
       "      <td>0.953026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>COD</td>\n",
       "      <td>0.879025</td>\n",
       "      <td>1.154115</td>\n",
       "      <td>0.945462</td>\n",
       "      <td>0.979889</td>\n",
       "      <td>0.939971</td>\n",
       "      <td>1.136323</td>\n",
       "      <td>0.958303</td>\n",
       "      <td>1.180784</td>\n",
       "      <td>1.106120</td>\n",
       "      <td>...</td>\n",
       "      <td>0.925192</td>\n",
       "      <td>1.147006</td>\n",
       "      <td>0.828224</td>\n",
       "      <td>1.055055</td>\n",
       "      <td>0.988592</td>\n",
       "      <td>1.022154</td>\n",
       "      <td>0.920031</td>\n",
       "      <td>1.022814</td>\n",
       "      <td>1.011838</td>\n",
       "      <td>0.947912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>COE</td>\n",
       "      <td>0.972938</td>\n",
       "      <td>1.198171</td>\n",
       "      <td>0.877662</td>\n",
       "      <td>1.013444</td>\n",
       "      <td>0.767278</td>\n",
       "      <td>1.155351</td>\n",
       "      <td>0.739934</td>\n",
       "      <td>1.268665</td>\n",
       "      <td>1.185283</td>\n",
       "      <td>...</td>\n",
       "      <td>0.974225</td>\n",
       "      <td>1.217373</td>\n",
       "      <td>1.054029</td>\n",
       "      <td>1.011116</td>\n",
       "      <td>0.903059</td>\n",
       "      <td>0.956483</td>\n",
       "      <td>1.043823</td>\n",
       "      <td>0.955275</td>\n",
       "      <td>1.054029</td>\n",
       "      <td>0.794958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>COF</td>\n",
       "      <td>1.015765</td>\n",
       "      <td>1.047768</td>\n",
       "      <td>0.933520</td>\n",
       "      <td>1.003538</td>\n",
       "      <td>0.958187</td>\n",
       "      <td>1.180275</td>\n",
       "      <td>0.944954</td>\n",
       "      <td>1.012798</td>\n",
       "      <td>1.056352</td>\n",
       "      <td>...</td>\n",
       "      <td>1.011936</td>\n",
       "      <td>1.038973</td>\n",
       "      <td>0.408360</td>\n",
       "      <td>1.230385</td>\n",
       "      <td>1.218505</td>\n",
       "      <td>1.225303</td>\n",
       "      <td>0.485429</td>\n",
       "      <td>1.227019</td>\n",
       "      <td>0.562498</td>\n",
       "      <td>0.945554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>COG</td>\n",
       "      <td>1.012845</td>\n",
       "      <td>1.042308</td>\n",
       "      <td>0.952082</td>\n",
       "      <td>1.016523</td>\n",
       "      <td>0.955523</td>\n",
       "      <td>1.148653</td>\n",
       "      <td>0.917319</td>\n",
       "      <td>1.014985</td>\n",
       "      <td>1.033373</td>\n",
       "      <td>...</td>\n",
       "      <td>1.011613</td>\n",
       "      <td>1.030222</td>\n",
       "      <td>0.602700</td>\n",
       "      <td>1.117735</td>\n",
       "      <td>1.098648</td>\n",
       "      <td>1.110110</td>\n",
       "      <td>0.726823</td>\n",
       "      <td>1.113948</td>\n",
       "      <td>0.850945</td>\n",
       "      <td>0.941641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>COH</td>\n",
       "      <td>0.890689</td>\n",
       "      <td>1.172115</td>\n",
       "      <td>0.946997</td>\n",
       "      <td>0.993039</td>\n",
       "      <td>0.898190</td>\n",
       "      <td>1.168174</td>\n",
       "      <td>0.911989</td>\n",
       "      <td>1.190121</td>\n",
       "      <td>1.122754</td>\n",
       "      <td>...</td>\n",
       "      <td>0.926239</td>\n",
       "      <td>1.161663</td>\n",
       "      <td>0.766689</td>\n",
       "      <td>1.054648</td>\n",
       "      <td>1.003792</td>\n",
       "      <td>1.024200</td>\n",
       "      <td>0.892690</td>\n",
       "      <td>1.014160</td>\n",
       "      <td>1.018691</td>\n",
       "      <td>0.919059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>COI</td>\n",
       "      <td>0.994114</td>\n",
       "      <td>0.981053</td>\n",
       "      <td>1.187553</td>\n",
       "      <td>0.778123</td>\n",
       "      <td>1.365925</td>\n",
       "      <td>1.037229</td>\n",
       "      <td>1.319877</td>\n",
       "      <td>1.029057</td>\n",
       "      <td>0.815650</td>\n",
       "      <td>...</td>\n",
       "      <td>0.988838</td>\n",
       "      <td>0.941920</td>\n",
       "      <td>1.324023</td>\n",
       "      <td>0.864268</td>\n",
       "      <td>0.795682</td>\n",
       "      <td>0.829661</td>\n",
       "      <td>1.351617</td>\n",
       "      <td>0.829033</td>\n",
       "      <td>1.379212</td>\n",
       "      <td>1.291119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>COJ</td>\n",
       "      <td>1.283475</td>\n",
       "      <td>1.090750</td>\n",
       "      <td>0.530997</td>\n",
       "      <td>1.082658</td>\n",
       "      <td>0.537454</td>\n",
       "      <td>1.115335</td>\n",
       "      <td>0.414975</td>\n",
       "      <td>1.178014</td>\n",
       "      <td>1.262902</td>\n",
       "      <td>...</td>\n",
       "      <td>1.245645</td>\n",
       "      <td>1.177222</td>\n",
       "      <td>1.084143</td>\n",
       "      <td>0.972125</td>\n",
       "      <td>0.880744</td>\n",
       "      <td>0.924252</td>\n",
       "      <td>1.110333</td>\n",
       "      <td>0.919886</td>\n",
       "      <td>1.136524</td>\n",
       "      <td>0.494476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>COK</td>\n",
       "      <td>0.810862</td>\n",
       "      <td>1.072966</td>\n",
       "      <td>1.070443</td>\n",
       "      <td>0.928446</td>\n",
       "      <td>1.079648</td>\n",
       "      <td>1.123787</td>\n",
       "      <td>1.147655</td>\n",
       "      <td>1.116225</td>\n",
       "      <td>1.001429</td>\n",
       "      <td>...</td>\n",
       "      <td>0.908765</td>\n",
       "      <td>1.063540</td>\n",
       "      <td>0.770501</td>\n",
       "      <td>1.070599</td>\n",
       "      <td>1.032891</td>\n",
       "      <td>1.053012</td>\n",
       "      <td>0.858467</td>\n",
       "      <td>1.055546</td>\n",
       "      <td>0.946432</td>\n",
       "      <td>1.099249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>COL</td>\n",
       "      <td>0.833645</td>\n",
       "      <td>1.499055</td>\n",
       "      <td>0.575127</td>\n",
       "      <td>0.935288</td>\n",
       "      <td>0.581189</td>\n",
       "      <td>1.091321</td>\n",
       "      <td>0.559594</td>\n",
       "      <td>1.748279</td>\n",
       "      <td>1.615222</td>\n",
       "      <td>...</td>\n",
       "      <td>0.871890</td>\n",
       "      <td>1.620852</td>\n",
       "      <td>0.995612</td>\n",
       "      <td>0.984997</td>\n",
       "      <td>0.926167</td>\n",
       "      <td>0.955525</td>\n",
       "      <td>1.065638</td>\n",
       "      <td>0.955411</td>\n",
       "      <td>1.135663</td>\n",
       "      <td>0.571970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>COM</td>\n",
       "      <td>0.313427</td>\n",
       "      <td>2.173473</td>\n",
       "      <td>0.429007</td>\n",
       "      <td>1.187267</td>\n",
       "      <td>0.210211</td>\n",
       "      <td>1.268188</td>\n",
       "      <td>0.250985</td>\n",
       "      <td>2.400516</td>\n",
       "      <td>1.695622</td>\n",
       "      <td>...</td>\n",
       "      <td>0.426128</td>\n",
       "      <td>2.089870</td>\n",
       "      <td>1.431384</td>\n",
       "      <td>0.821745</td>\n",
       "      <td>0.642343</td>\n",
       "      <td>0.716077</td>\n",
       "      <td>1.465258</td>\n",
       "      <td>0.684143</td>\n",
       "      <td>1.499133</td>\n",
       "      <td>0.296734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CON</td>\n",
       "      <td>0.985634</td>\n",
       "      <td>1.271879</td>\n",
       "      <td>0.621499</td>\n",
       "      <td>1.029523</td>\n",
       "      <td>0.601001</td>\n",
       "      <td>1.134997</td>\n",
       "      <td>0.536800</td>\n",
       "      <td>1.447241</td>\n",
       "      <td>1.412545</td>\n",
       "      <td>...</td>\n",
       "      <td>1.006821</td>\n",
       "      <td>1.377222</td>\n",
       "      <td>1.010765</td>\n",
       "      <td>1.005359</td>\n",
       "      <td>0.906498</td>\n",
       "      <td>0.957425</td>\n",
       "      <td>1.037619</td>\n",
       "      <td>0.960418</td>\n",
       "      <td>1.064473</td>\n",
       "      <td>0.586434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>COO</td>\n",
       "      <td>1.039256</td>\n",
       "      <td>1.153738</td>\n",
       "      <td>0.797731</td>\n",
       "      <td>1.031216</td>\n",
       "      <td>0.717879</td>\n",
       "      <td>1.106269</td>\n",
       "      <td>0.660661</td>\n",
       "      <td>1.231291</td>\n",
       "      <td>1.204436</td>\n",
       "      <td>...</td>\n",
       "      <td>1.046872</td>\n",
       "      <td>1.196488</td>\n",
       "      <td>0.969728</td>\n",
       "      <td>1.028066</td>\n",
       "      <td>0.949013</td>\n",
       "      <td>0.988711</td>\n",
       "      <td>0.994228</td>\n",
       "      <td>0.989054</td>\n",
       "      <td>1.018727</td>\n",
       "      <td>0.725423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>COP</td>\n",
       "      <td>1.036642</td>\n",
       "      <td>1.089736</td>\n",
       "      <td>0.882206</td>\n",
       "      <td>1.031575</td>\n",
       "      <td>0.850375</td>\n",
       "      <td>1.150489</td>\n",
       "      <td>0.815937</td>\n",
       "      <td>1.079645</td>\n",
       "      <td>1.104686</td>\n",
       "      <td>...</td>\n",
       "      <td>1.027564</td>\n",
       "      <td>1.091356</td>\n",
       "      <td>0.881934</td>\n",
       "      <td>1.011980</td>\n",
       "      <td>0.962836</td>\n",
       "      <td>0.984028</td>\n",
       "      <td>0.973438</td>\n",
       "      <td>0.977268</td>\n",
       "      <td>1.064941</td>\n",
       "      <td>0.849506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>COQ</td>\n",
       "      <td>0.975787</td>\n",
       "      <td>1.143742</td>\n",
       "      <td>0.884885</td>\n",
       "      <td>1.003014</td>\n",
       "      <td>0.836042</td>\n",
       "      <td>1.178218</td>\n",
       "      <td>0.790973</td>\n",
       "      <td>1.205599</td>\n",
       "      <td>1.171896</td>\n",
       "      <td>...</td>\n",
       "      <td>0.985940</td>\n",
       "      <td>1.173746</td>\n",
       "      <td>0.921822</td>\n",
       "      <td>1.001303</td>\n",
       "      <td>0.923608</td>\n",
       "      <td>0.959262</td>\n",
       "      <td>1.014440</td>\n",
       "      <td>0.952876</td>\n",
       "      <td>1.107057</td>\n",
       "      <td>0.837300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>COR</td>\n",
       "      <td>0.955408</td>\n",
       "      <td>1.145751</td>\n",
       "      <td>0.923895</td>\n",
       "      <td>1.016222</td>\n",
       "      <td>0.883577</td>\n",
       "      <td>1.174995</td>\n",
       "      <td>0.852293</td>\n",
       "      <td>1.147366</td>\n",
       "      <td>1.102245</td>\n",
       "      <td>...</td>\n",
       "      <td>0.965402</td>\n",
       "      <td>1.131788</td>\n",
       "      <td>0.714944</td>\n",
       "      <td>1.042735</td>\n",
       "      <td>0.988414</td>\n",
       "      <td>1.012025</td>\n",
       "      <td>0.909884</td>\n",
       "      <td>1.004926</td>\n",
       "      <td>1.104824</td>\n",
       "      <td>0.886589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>COS</td>\n",
       "      <td>1.011891</td>\n",
       "      <td>1.072395</td>\n",
       "      <td>0.939938</td>\n",
       "      <td>1.032368</td>\n",
       "      <td>0.898178</td>\n",
       "      <td>1.155831</td>\n",
       "      <td>0.859970</td>\n",
       "      <td>1.036621</td>\n",
       "      <td>1.063569</td>\n",
       "      <td>...</td>\n",
       "      <td>1.010742</td>\n",
       "      <td>1.057529</td>\n",
       "      <td>0.642878</td>\n",
       "      <td>1.113245</td>\n",
       "      <td>1.074360</td>\n",
       "      <td>1.091796</td>\n",
       "      <td>0.758529</td>\n",
       "      <td>1.087784</td>\n",
       "      <td>0.874179</td>\n",
       "      <td>0.899362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>COT</td>\n",
       "      <td>1.014589</td>\n",
       "      <td>1.039588</td>\n",
       "      <td>0.961608</td>\n",
       "      <td>1.024274</td>\n",
       "      <td>0.947121</td>\n",
       "      <td>1.141811</td>\n",
       "      <td>0.902416</td>\n",
       "      <td>1.010038</td>\n",
       "      <td>1.035186</td>\n",
       "      <td>...</td>\n",
       "      <td>1.010407</td>\n",
       "      <td>1.028271</td>\n",
       "      <td>0.606058</td>\n",
       "      <td>1.107149</td>\n",
       "      <td>1.081282</td>\n",
       "      <td>1.092362</td>\n",
       "      <td>0.765260</td>\n",
       "      <td>1.088655</td>\n",
       "      <td>0.924463</td>\n",
       "      <td>0.937048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>COU</td>\n",
       "      <td>1.014230</td>\n",
       "      <td>1.022302</td>\n",
       "      <td>0.990750</td>\n",
       "      <td>1.009500</td>\n",
       "      <td>0.970454</td>\n",
       "      <td>1.144961</td>\n",
       "      <td>0.934585</td>\n",
       "      <td>0.995964</td>\n",
       "      <td>1.022216</td>\n",
       "      <td>...</td>\n",
       "      <td>1.011743</td>\n",
       "      <td>1.013494</td>\n",
       "      <td>0.629310</td>\n",
       "      <td>1.106342</td>\n",
       "      <td>1.085062</td>\n",
       "      <td>1.094640</td>\n",
       "      <td>0.758306</td>\n",
       "      <td>1.092516</td>\n",
       "      <td>0.887302</td>\n",
       "      <td>0.965263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>COV</td>\n",
       "      <td>1.036596</td>\n",
       "      <td>0.968398</td>\n",
       "      <td>1.035125</td>\n",
       "      <td>1.012721</td>\n",
       "      <td>1.017691</td>\n",
       "      <td>1.154932</td>\n",
       "      <td>0.960021</td>\n",
       "      <td>0.940887</td>\n",
       "      <td>0.969969</td>\n",
       "      <td>...</td>\n",
       "      <td>1.023248</td>\n",
       "      <td>0.959752</td>\n",
       "      <td>0.568467</td>\n",
       "      <td>1.079760</td>\n",
       "      <td>1.071039</td>\n",
       "      <td>1.071159</td>\n",
       "      <td>0.789826</td>\n",
       "      <td>1.062677</td>\n",
       "      <td>1.011186</td>\n",
       "      <td>1.004279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>COW</td>\n",
       "      <td>1.070999</td>\n",
       "      <td>1.032981</td>\n",
       "      <td>0.922086</td>\n",
       "      <td>1.020207</td>\n",
       "      <td>0.945079</td>\n",
       "      <td>1.153680</td>\n",
       "      <td>0.859148</td>\n",
       "      <td>1.008220</td>\n",
       "      <td>1.031021</td>\n",
       "      <td>...</td>\n",
       "      <td>1.046949</td>\n",
       "      <td>1.024074</td>\n",
       "      <td>0.641564</td>\n",
       "      <td>1.085876</td>\n",
       "      <td>1.047623</td>\n",
       "      <td>1.067677</td>\n",
       "      <td>0.802865</td>\n",
       "      <td>1.069531</td>\n",
       "      <td>0.964166</td>\n",
       "      <td>0.908771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>COX</td>\n",
       "      <td>1.042388</td>\n",
       "      <td>0.942570</td>\n",
       "      <td>1.051032</td>\n",
       "      <td>1.082170</td>\n",
       "      <td>0.988983</td>\n",
       "      <td>1.125735</td>\n",
       "      <td>0.866713</td>\n",
       "      <td>0.908056</td>\n",
       "      <td>0.926412</td>\n",
       "      <td>...</td>\n",
       "      <td>1.023242</td>\n",
       "      <td>0.925679</td>\n",
       "      <td>0.717286</td>\n",
       "      <td>1.099638</td>\n",
       "      <td>1.070748</td>\n",
       "      <td>1.087913</td>\n",
       "      <td>0.783008</td>\n",
       "      <td>1.093354</td>\n",
       "      <td>0.848730</td>\n",
       "      <td>0.968910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>COY</td>\n",
       "      <td>0.891602</td>\n",
       "      <td>1.317828</td>\n",
       "      <td>0.802686</td>\n",
       "      <td>1.009133</td>\n",
       "      <td>0.748698</td>\n",
       "      <td>1.126338</td>\n",
       "      <td>0.747063</td>\n",
       "      <td>1.375967</td>\n",
       "      <td>1.232689</td>\n",
       "      <td>...</td>\n",
       "      <td>0.915890</td>\n",
       "      <td>1.308828</td>\n",
       "      <td>1.005872</td>\n",
       "      <td>1.014422</td>\n",
       "      <td>0.911891</td>\n",
       "      <td>0.967245</td>\n",
       "      <td>1.042500</td>\n",
       "      <td>0.975422</td>\n",
       "      <td>1.079129</td>\n",
       "      <td>0.766149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>COZ</td>\n",
       "      <td>0.929730</td>\n",
       "      <td>1.209825</td>\n",
       "      <td>0.894764</td>\n",
       "      <td>1.018517</td>\n",
       "      <td>0.815384</td>\n",
       "      <td>1.146418</td>\n",
       "      <td>0.784277</td>\n",
       "      <td>1.232098</td>\n",
       "      <td>1.173193</td>\n",
       "      <td>...</td>\n",
       "      <td>0.944970</td>\n",
       "      <td>1.205038</td>\n",
       "      <td>0.811813</td>\n",
       "      <td>1.043752</td>\n",
       "      <td>0.973782</td>\n",
       "      <td>1.006499</td>\n",
       "      <td>0.941545</td>\n",
       "      <td>1.001962</td>\n",
       "      <td>1.071277</td>\n",
       "      <td>0.831475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>XX3</td>\n",
       "      <td>1.013877</td>\n",
       "      <td>1.031978</td>\n",
       "      <td>0.958653</td>\n",
       "      <td>1.010473</td>\n",
       "      <td>0.963954</td>\n",
       "      <td>1.160343</td>\n",
       "      <td>0.936155</td>\n",
       "      <td>1.008474</td>\n",
       "      <td>1.035711</td>\n",
       "      <td>...</td>\n",
       "      <td>1.011218</td>\n",
       "      <td>1.025388</td>\n",
       "      <td>0.529119</td>\n",
       "      <td>1.165054</td>\n",
       "      <td>1.146486</td>\n",
       "      <td>1.156760</td>\n",
       "      <td>0.631137</td>\n",
       "      <td>1.158740</td>\n",
       "      <td>0.733154</td>\n",
       "      <td>0.952921</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>37 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "FACTORNAME STATIONGROUP   FAC_APR   FAC_AUG   FAC_DEC   FAC_FAL   FAC_FEB  \\\n",
       "0                   CO0  0.553110  1.769128  0.339259  1.107878  0.339494   \n",
       "1                   CO1  0.583450  2.109072  0.476375  0.766020  0.456070   \n",
       "2                   CO2  0.671815  1.230627  1.090283  0.838699  1.120695   \n",
       "3                   CO3  0.671761  1.629033  0.509268  1.159915  0.419881   \n",
       "4                   CO4  1.067708  1.075263  0.890783  1.006220  0.835322   \n",
       "5                   CO5  1.006596  1.101546  0.934678  1.013803  0.871004   \n",
       "6                   CO6  1.018984  1.039075  0.989176  1.013135  0.938123   \n",
       "7                   CO7  0.969037  1.227101  0.860510  0.984139  0.775596   \n",
       "8                   CO8  1.013020  1.005864  0.990349  1.011359  0.978147   \n",
       "9                   CO9  0.997279  1.204012  0.766509  0.994121  0.668810   \n",
       "10                  COA  0.958342  1.180943  0.815886  1.028209  0.858733   \n",
       "11                  COB  0.990546  1.077877  0.960467  1.025010  0.917789   \n",
       "12                  COC  0.979742  1.056728  0.975044  1.012474  0.957638   \n",
       "13                  COD  0.879025  1.154115  0.945462  0.979889  0.939971   \n",
       "14                  COE  0.972938  1.198171  0.877662  1.013444  0.767278   \n",
       "15                  COF  1.015765  1.047768  0.933520  1.003538  0.958187   \n",
       "16                  COG  1.012845  1.042308  0.952082  1.016523  0.955523   \n",
       "17                  COH  0.890689  1.172115  0.946997  0.993039  0.898190   \n",
       "18                  COI  0.994114  0.981053  1.187553  0.778123  1.365925   \n",
       "19                  COJ  1.283475  1.090750  0.530997  1.082658  0.537454   \n",
       "20                  COK  0.810862  1.072966  1.070443  0.928446  1.079648   \n",
       "21                  COL  0.833645  1.499055  0.575127  0.935288  0.581189   \n",
       "22                  COM  0.313427  2.173473  0.429007  1.187267  0.210211   \n",
       "23                  CON  0.985634  1.271879  0.621499  1.029523  0.601001   \n",
       "24                  COO  1.039256  1.153738  0.797731  1.031216  0.717879   \n",
       "25                  COP  1.036642  1.089736  0.882206  1.031575  0.850375   \n",
       "26                  COQ  0.975787  1.143742  0.884885  1.003014  0.836042   \n",
       "27                  COR  0.955408  1.145751  0.923895  1.016222  0.883577   \n",
       "28                  COS  1.011891  1.072395  0.939938  1.032368  0.898178   \n",
       "29                  COT  1.014589  1.039588  0.961608  1.024274  0.947121   \n",
       "30                  COU  1.014230  1.022302  0.990750  1.009500  0.970454   \n",
       "31                  COV  1.036596  0.968398  1.035125  1.012721  1.017691   \n",
       "32                  COW  1.070999  1.032981  0.922086  1.020207  0.945079   \n",
       "33                  COX  1.042388  0.942570  1.051032  1.082170  0.988983   \n",
       "34                  COY  0.891602  1.317828  0.802686  1.009133  0.748698   \n",
       "35                  COZ  0.929730  1.209825  0.894764  1.018517  0.815384   \n",
       "36                  XX3  1.013877  1.031978  0.958653  1.010473  0.963954   \n",
       "\n",
       "FACTORNAME   FAC_FRI   FAC_JAN   FAC_JUL   FAC_JUN  ...   FAC_SPR   FAC_SUM  \\\n",
       "0           1.001066  0.320612  2.065796  1.891442  ...  0.650212  1.908789   \n",
       "1           1.232986  0.432402  2.609596  1.676910  ...  0.647172  2.131859   \n",
       "2           1.013876  1.140254  1.352569  1.212064  ...  0.779137  1.265087   \n",
       "3           1.194883  0.385754  1.868239  1.583304  ...  0.708258  1.693525   \n",
       "4           1.228552  0.751806  1.169057  1.125786  ...  1.044441  1.123369   \n",
       "5           1.179292  0.808263  1.137219  1.098088  ...  1.002598  1.112284   \n",
       "6           1.143646  0.893055  1.031387  1.041649  ...  1.009377  1.037371   \n",
       "7           1.234002  0.770656  1.313964  1.169820  ...  0.976645  1.236962   \n",
       "8           1.152104  0.946190  0.997644  1.017415  ...  1.010105  1.006974   \n",
       "9           1.099762  0.649665  1.332174  1.322174  ...  1.024764  1.286120   \n",
       "10          1.121896  0.772274  1.210769  1.163521  ...  0.971082  1.185078   \n",
       "11          1.144096  0.865479  1.056890  1.062943  ...  0.994509  1.065904   \n",
       "12          1.134289  0.926396  1.033595  1.041483  ...  0.990564  1.043935   \n",
       "13          1.136323  0.958303  1.180784  1.106120  ...  0.925192  1.147006   \n",
       "14          1.155351  0.739934  1.268665  1.185283  ...  0.974225  1.217373   \n",
       "15          1.180275  0.944954  1.012798  1.056352  ...  1.011936  1.038973   \n",
       "16          1.148653  0.917319  1.014985  1.033373  ...  1.011613  1.030222   \n",
       "17          1.168174  0.911989  1.190121  1.122754  ...  0.926239  1.161663   \n",
       "18          1.037229  1.319877  1.029057  0.815650  ...  0.988838  0.941920   \n",
       "19          1.115335  0.414975  1.178014  1.262902  ...  1.245645  1.177222   \n",
       "20          1.123787  1.147655  1.116225  1.001429  ...  0.908765  1.063540   \n",
       "21          1.091321  0.559594  1.748279  1.615222  ...  0.871890  1.620852   \n",
       "22          1.268188  0.250985  2.400516  1.695622  ...  0.426128  2.089870   \n",
       "23          1.134997  0.536800  1.447241  1.412545  ...  1.006821  1.377222   \n",
       "24          1.106269  0.660661  1.231291  1.204436  ...  1.046872  1.196488   \n",
       "25          1.150489  0.815937  1.079645  1.104686  ...  1.027564  1.091356   \n",
       "26          1.178218  0.790973  1.205599  1.171896  ...  0.985940  1.173746   \n",
       "27          1.174995  0.852293  1.147366  1.102245  ...  0.965402  1.131788   \n",
       "28          1.155831  0.859970  1.036621  1.063569  ...  1.010742  1.057529   \n",
       "29          1.141811  0.902416  1.010038  1.035186  ...  1.010407  1.028271   \n",
       "30          1.144961  0.934585  0.995964  1.022216  ...  1.011743  1.013494   \n",
       "31          1.154932  0.960021  0.940887  0.969969  ...  1.023248  0.959752   \n",
       "32          1.153680  0.859148  1.008220  1.031021  ...  1.046949  1.024074   \n",
       "33          1.125735  0.866713  0.908056  0.926412  ...  1.023242  0.925679   \n",
       "34          1.126338  0.747063  1.375967  1.232689  ...  0.915890  1.308828   \n",
       "35          1.146418  0.784277  1.232098  1.173193  ...  0.944970  1.205038   \n",
       "36          1.160343  0.936155  1.008474  1.035711  ...  1.011218  1.025388   \n",
       "\n",
       "FACTORNAME   FAC_SUN   FAC_THU   FAC_TUE  FAC_WDAVG  FAC_WEAVG   FAC_WED  \\\n",
       "0           1.528408  0.741788  0.674528   0.715249   1.574201  0.729430   \n",
       "1           1.031369  0.908397  0.769153   0.824043   1.253923  0.794578   \n",
       "2           1.429561  0.801945  0.743486   0.790750   1.445970  0.826818   \n",
       "3           1.105323  0.913895  0.809172   0.853478   1.213439  0.837366   \n",
       "4           1.209043  1.019046  0.810814   0.904970   1.111261  0.885049   \n",
       "5           0.937604  1.028941  0.921979   0.970144   0.995377  0.959513   \n",
       "6           0.677117  1.087783  1.048176   1.065356   0.821210  1.060111   \n",
       "7           1.069474  0.974001  0.854521   0.905874   1.089591  0.889101   \n",
       "8           0.576285  1.147047  1.122313   1.134873   0.681143  1.135259   \n",
       "9           1.005688  1.038314  0.926450   0.979628   1.026169  0.974121   \n",
       "10          1.176762  0.938099  0.832334   0.881412   1.205332  0.873804   \n",
       "11          0.717595  1.076699  1.034051   1.055212   0.840390  1.054887   \n",
       "12          0.645556  1.130753  1.090563   1.110675   0.738239  1.110709   \n",
       "13          0.828224  1.055055  0.988592   1.022154   0.920031  1.022814   \n",
       "14          1.054029  1.011116  0.903059   0.956483   1.043823  0.955275   \n",
       "15          0.408360  1.230385  1.218505   1.225303   0.485429  1.227019   \n",
       "16          0.602700  1.117735  1.098648   1.110110   0.726823  1.113948   \n",
       "17          0.766689  1.054648  1.003792   1.024200   0.892690  1.014160   \n",
       "18          1.324023  0.864268  0.795682   0.829661   1.351617  0.829033   \n",
       "19          1.084143  0.972125  0.880744   0.924252   1.110333  0.919886   \n",
       "20          0.770501  1.070599  1.032891   1.053012   0.858467  1.055546   \n",
       "21          0.995612  0.984997  0.926167   0.955525   1.065638  0.955411   \n",
       "22          1.431384  0.821745  0.642343   0.716077   1.465258  0.684143   \n",
       "23          1.010765  1.005359  0.906498   0.957425   1.037619  0.960418   \n",
       "24          0.969728  1.028066  0.949013   0.988711   0.994228  0.989054   \n",
       "25          0.881934  1.011980  0.962836   0.984028   0.973438  0.977268   \n",
       "26          0.921822  1.001303  0.923608   0.959262   1.014440  0.952876   \n",
       "27          0.714944  1.042735  0.988414   1.012025   0.909884  1.004926   \n",
       "28          0.642878  1.113245  1.074360   1.091796   0.758529  1.087784   \n",
       "29          0.606058  1.107149  1.081282   1.092362   0.765260  1.088655   \n",
       "30          0.629310  1.106342  1.085062   1.094640   0.758306  1.092516   \n",
       "31          0.568467  1.079760  1.071039   1.071159   0.789826  1.062677   \n",
       "32          0.641564  1.085876  1.047623   1.067677   0.802865  1.069531   \n",
       "33          0.717286  1.099638  1.070748   1.087913   0.783008  1.093354   \n",
       "34          1.005872  1.014422  0.911891   0.967245   1.042500  0.975422   \n",
       "35          0.811813  1.043752  0.973782   1.006499   0.941545  1.001962   \n",
       "36          0.529119  1.165054  1.146486   1.156760   0.631137  1.158740   \n",
       "\n",
       "FACTORNAME  FAC_WEMAX   FAC_WIN  \n",
       "0            1.619994  0.333122  \n",
       "1            1.476478  0.454949  \n",
       "2            1.462380  1.117077  \n",
       "3            1.321555  0.438301  \n",
       "4            1.209043  0.825970  \n",
       "5            1.053150  0.871315  \n",
       "6            0.965303  0.940118  \n",
       "7            1.109709  0.802254  \n",
       "8            0.786002  0.971562  \n",
       "9            1.046649  0.694994  \n",
       "10           1.233903  0.815631  \n",
       "11           0.963184  0.914578  \n",
       "12           0.830923  0.953026  \n",
       "13           1.011838  0.947912  \n",
       "14           1.054029  0.794958  \n",
       "15           0.562498  0.945554  \n",
       "16           0.850945  0.941641  \n",
       "17           1.018691  0.919059  \n",
       "18           1.379212  1.291119  \n",
       "19           1.136524  0.494476  \n",
       "20           0.946432  1.099249  \n",
       "21           1.135663  0.571970  \n",
       "22           1.499133  0.296734  \n",
       "23           1.064473  0.586434  \n",
       "24           1.018727  0.725423  \n",
       "25           1.064941  0.849506  \n",
       "26           1.107057  0.837300  \n",
       "27           1.104824  0.886589  \n",
       "28           0.874179  0.899362  \n",
       "29           0.924463  0.937048  \n",
       "30           0.887302  0.965263  \n",
       "31           1.011186  1.004279  \n",
       "32           0.964166  0.908771  \n",
       "33           0.848730  0.968910  \n",
       "34           1.079129  0.766149  \n",
       "35           1.071277  0.831475  \n",
       "36           0.733154  0.952921  \n",
       "\n",
       "[37 rows x 29 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#pivot for final table\n",
    "dfFactorsToPublishStationGroup_pivot = dfFactorsToPublish.pivot(index=('STATIONGROUP'),columns='FACTORNAME',values='FACTOR')\n",
    "\n",
    "dfFactorsToPublishStationGroup_pivot = dfFactorsToPublishStationGroup_pivot.reset_index()\n",
    "display(dfFactorsToPublishStationGroup_pivot)\n",
    "\n",
    "dfFactorsToPublishStationGroup_pivot.to_csv(os.path.join(dirResults, r'CCSFactors.csv'),index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "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>SEGID</th>\n",
       "      <th>AADT2019</th>\n",
       "      <th>AREATYPE</th>\n",
       "      <th>FTGROUP</th>\n",
       "      <th>FACGEO</th>\n",
       "      <th>STATIONGROUP</th>\n",
       "      <th>FACTORNAME</th>\n",
       "      <th>FACTOR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.815937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_FEB</td>\n",
       "      <td>0.850375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_MAR</td>\n",
       "      <td>0.939590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_APR</td>\n",
       "      <td>1.036642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_MAY</td>\n",
       "      <td>1.106459</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239759</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_THU</td>\n",
       "      <td>1.147047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239760</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_FRI</td>\n",
       "      <td>1.152104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239761</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_SAT</td>\n",
       "      <td>0.786002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239762</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_SUN</td>\n",
       "      <td>0.576285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239763</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_WEMAX</td>\n",
       "      <td>0.786002</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>239764 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             SEGID  AADT2019  AREATYPE   FTGROUP     FACGEO STATIONGROUP  \\\n",
       "0       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "1       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "2       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "3       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "4       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "...            ...       ...       ...       ...        ...          ...   \n",
       "239759  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "239760  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "239761  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "239762  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "239763  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "\n",
       "       FACTORNAME    FACTOR  \n",
       "0         FAC_JAN  0.815937  \n",
       "1         FAC_FEB  0.850375  \n",
       "2         FAC_MAR  0.939590  \n",
       "3         FAC_APR  1.036642  \n",
       "4         FAC_MAY  1.106459  \n",
       "...           ...       ...  \n",
       "239759    FAC_THU  1.147047  \n",
       "239760    FAC_FRI  1.152104  \n",
       "239761    FAC_SAT  0.786002  \n",
       "239762    FAC_SUN  0.576285  \n",
       "239763  FAC_WEMAX  0.786002  \n",
       "\n",
       "[239764 rows x 8 columns]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfSegFacToPublish = pd.DataFrame.merge(dfSegFac,dfFactorsToPublish,on='STATIONGROUP')\n",
    "dfSegFacToPublish"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>SEGIDTOREV</th>\n",
       "      <th>SEGIDFROM</th>\n",
       "      <th>PORTIONFROM</th>\n",
       "      <th>SEGIDTO</th>\n",
       "      <th>PORTIONTO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>0015_222.8</td>\n",
       "      <td>11</td>\n",
       "      <td>0015_261.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>0015_225.8</td>\n",
       "      <td>0015_222.8</td>\n",
       "      <td>11</td>\n",
       "      <td>0015_261.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>0015_228.1</td>\n",
       "      <td>0015_222.8</td>\n",
       "      <td>10</td>\n",
       "      <td>0015_261.8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>0015_230.0</td>\n",
       "      <td>0015_222.8</td>\n",
       "      <td>10</td>\n",
       "      <td>0015_261.8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>0015_233.0</td>\n",
       "      <td>0015_222.8</td>\n",
       "      <td>10</td>\n",
       "      <td>0015_261.8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>65</td>\n",
       "      <td>0006_175.6</td>\n",
       "      <td>0006_178.8</td>\n",
       "      <td>5</td>\n",
       "      <td>0006_173.4</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>66</td>\n",
       "      <td>0006_174.9</td>\n",
       "      <td>0006_178.8</td>\n",
       "      <td>4</td>\n",
       "      <td>0006_173.4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>67</td>\n",
       "      <td>0006_174.4</td>\n",
       "      <td>0006_178.8</td>\n",
       "      <td>3</td>\n",
       "      <td>0006_173.4</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>68</td>\n",
       "      <td>0006_174.0</td>\n",
       "      <td>0006_178.8</td>\n",
       "      <td>2</td>\n",
       "      <td>0006_173.4</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>69</td>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>0006_178.8</td>\n",
       "      <td>1</td>\n",
       "      <td>0006_173.4</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>69 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    ID  SEGIDTOREV   SEGIDFROM  PORTIONFROM     SEGIDTO  PORTIONTO\n",
       "0    1  0015_225.3  0015_222.8           11  0015_261.8          1\n",
       "1    2  0015_225.8  0015_222.8           11  0015_261.8          1\n",
       "2    3  0015_228.1  0015_222.8           10  0015_261.8          2\n",
       "3    4  0015_230.0  0015_222.8           10  0015_261.8          2\n",
       "4    5  0015_233.0  0015_222.8           10  0015_261.8          2\n",
       "..  ..         ...         ...          ...         ...        ...\n",
       "64  65  0006_175.6  0006_178.8            5  0006_173.4          6\n",
       "65  66  0006_174.9  0006_178.8            4  0006_173.4          7\n",
       "66  67  0006_174.4  0006_178.8            3  0006_173.4          8\n",
       "67  68  0006_174.0  0006_178.8            2  0006_173.4          9\n",
       "68  69  0006_173.7  0006_178.8            1  0006_173.4         10\n",
       "\n",
       "[69 rows x 6 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>SEGIDTOREV</th>\n",
       "      <th>FACTORNAME</th>\n",
       "      <th>FACTORFROM</th>\n",
       "      <th>PORTIONFROM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.751806</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_FEB</td>\n",
       "      <td>0.835322</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_MAR</td>\n",
       "      <td>1.045239</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_APR</td>\n",
       "      <td>1.067708</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_MAY</td>\n",
       "      <td>1.020377</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1927</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_THU</td>\n",
       "      <td>1.001303</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1928</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_FRI</td>\n",
       "      <td>1.178218</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1929</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_SAT</td>\n",
       "      <td>1.107057</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1930</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_SUN</td>\n",
       "      <td>0.921822</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1931</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_WEMAX</td>\n",
       "      <td>1.107057</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1932 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      SEGIDTOREV FACTORNAME  FACTORFROM  PORTIONFROM\n",
       "0     0015_225.3    FAC_JAN    0.751806           11\n",
       "1     0015_225.3    FAC_FEB    0.835322           11\n",
       "2     0015_225.3    FAC_MAR    1.045239           11\n",
       "3     0015_225.3    FAC_APR    1.067708           11\n",
       "4     0015_225.3    FAC_MAY    1.020377           11\n",
       "...          ...        ...         ...          ...\n",
       "1927  0006_173.7    FAC_THU    1.001303            1\n",
       "1928  0006_173.7    FAC_FRI    1.178218            1\n",
       "1929  0006_173.7    FAC_SAT    1.107057            1\n",
       "1930  0006_173.7    FAC_SUN    0.921822            1\n",
       "1931  0006_173.7  FAC_WEMAX    1.107057            1\n",
       "\n",
       "[1932 rows x 4 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>SEGIDTOREV</th>\n",
       "      <th>FACTORNAME</th>\n",
       "      <th>FACTORTO</th>\n",
       "      <th>PORTIONTO</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.893055</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_FEB</td>\n",
       "      <td>0.938123</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_MAR</td>\n",
       "      <td>0.988979</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_APR</td>\n",
       "      <td>1.018984</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_MAY</td>\n",
       "      <td>1.020168</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1927</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_THU</td>\n",
       "      <td>1.106342</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1928</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_FRI</td>\n",
       "      <td>1.144961</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1929</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_SAT</td>\n",
       "      <td>0.887302</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1930</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_SUN</td>\n",
       "      <td>0.629310</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1931</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_WEMAX</td>\n",
       "      <td>0.887302</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1932 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      SEGIDTOREV FACTORNAME  FACTORTO  PORTIONTO\n",
       "0     0015_225.3    FAC_JAN  0.893055          1\n",
       "1     0015_225.3    FAC_FEB  0.938123          1\n",
       "2     0015_225.3    FAC_MAR  0.988979          1\n",
       "3     0015_225.3    FAC_APR  1.018984          1\n",
       "4     0015_225.3    FAC_MAY  1.020168          1\n",
       "...          ...        ...       ...        ...\n",
       "1927  0006_173.7    FAC_THU  1.106342         10\n",
       "1928  0006_173.7    FAC_FRI  1.144961         10\n",
       "1929  0006_173.7    FAC_SAT  0.887302         10\n",
       "1930  0006_173.7    FAC_SUN  0.629310         10\n",
       "1931  0006_173.7  FAC_WEMAX  0.887302         10\n",
       "\n",
       "[1932 rows x 4 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>SEGIDTOREV</th>\n",
       "      <th>FACTORNAME</th>\n",
       "      <th>FACTORFROM</th>\n",
       "      <th>PORTIONFROM</th>\n",
       "      <th>FACTORTO</th>\n",
       "      <th>PORTIONTO</th>\n",
       "      <th>PF</th>\n",
       "      <th>PT</th>\n",
       "      <th>FACTORINTERPOLATED</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.751806</td>\n",
       "      <td>11</td>\n",
       "      <td>0.893055</td>\n",
       "      <td>1</td>\n",
       "      <td>0.916667</td>\n",
       "      <td>0.083333</td>\n",
       "      <td>0.763577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_FEB</td>\n",
       "      <td>0.835322</td>\n",
       "      <td>11</td>\n",
       "      <td>0.938123</td>\n",
       "      <td>1</td>\n",
       "      <td>0.916667</td>\n",
       "      <td>0.083333</td>\n",
       "      <td>0.843888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_MAR</td>\n",
       "      <td>1.045239</td>\n",
       "      <td>11</td>\n",
       "      <td>0.988979</td>\n",
       "      <td>1</td>\n",
       "      <td>0.916667</td>\n",
       "      <td>0.083333</td>\n",
       "      <td>1.040550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_APR</td>\n",
       "      <td>1.067708</td>\n",
       "      <td>11</td>\n",
       "      <td>1.018984</td>\n",
       "      <td>1</td>\n",
       "      <td>0.916667</td>\n",
       "      <td>0.083333</td>\n",
       "      <td>1.063648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_MAY</td>\n",
       "      <td>1.020377</td>\n",
       "      <td>11</td>\n",
       "      <td>1.020168</td>\n",
       "      <td>1</td>\n",
       "      <td>0.916667</td>\n",
       "      <td>0.083333</td>\n",
       "      <td>1.020360</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1927</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_THU</td>\n",
       "      <td>1.001303</td>\n",
       "      <td>1</td>\n",
       "      <td>1.106342</td>\n",
       "      <td>10</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.909091</td>\n",
       "      <td>1.096793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1928</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_FRI</td>\n",
       "      <td>1.178218</td>\n",
       "      <td>1</td>\n",
       "      <td>1.144961</td>\n",
       "      <td>10</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.909091</td>\n",
       "      <td>1.147985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1929</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_SAT</td>\n",
       "      <td>1.107057</td>\n",
       "      <td>1</td>\n",
       "      <td>0.887302</td>\n",
       "      <td>10</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.909091</td>\n",
       "      <td>0.907280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1930</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_SUN</td>\n",
       "      <td>0.921822</td>\n",
       "      <td>1</td>\n",
       "      <td>0.629310</td>\n",
       "      <td>10</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.909091</td>\n",
       "      <td>0.655902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1931</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_WEMAX</td>\n",
       "      <td>1.107057</td>\n",
       "      <td>1</td>\n",
       "      <td>0.887302</td>\n",
       "      <td>10</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.909091</td>\n",
       "      <td>0.907280</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1932 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      SEGIDTOREV FACTORNAME  FACTORFROM  PORTIONFROM  FACTORTO  PORTIONTO  \\\n",
       "0     0015_225.3    FAC_JAN    0.751806           11  0.893055          1   \n",
       "1     0015_225.3    FAC_FEB    0.835322           11  0.938123          1   \n",
       "2     0015_225.3    FAC_MAR    1.045239           11  0.988979          1   \n",
       "3     0015_225.3    FAC_APR    1.067708           11  1.018984          1   \n",
       "4     0015_225.3    FAC_MAY    1.020377           11  1.020168          1   \n",
       "...          ...        ...         ...          ...       ...        ...   \n",
       "1927  0006_173.7    FAC_THU    1.001303            1  1.106342         10   \n",
       "1928  0006_173.7    FAC_FRI    1.178218            1  1.144961         10   \n",
       "1929  0006_173.7    FAC_SAT    1.107057            1  0.887302         10   \n",
       "1930  0006_173.7    FAC_SUN    0.921822            1  0.629310         10   \n",
       "1931  0006_173.7  FAC_WEMAX    1.107057            1  0.887302         10   \n",
       "\n",
       "            PF        PT  FACTORINTERPOLATED  \n",
       "0     0.916667  0.083333            0.763577  \n",
       "1     0.916667  0.083333            0.843888  \n",
       "2     0.916667  0.083333            1.040550  \n",
       "3     0.916667  0.083333            1.063648  \n",
       "4     0.916667  0.083333            1.020360  \n",
       "...        ...       ...                 ...  \n",
       "1927  0.090909  0.909091            1.096793  \n",
       "1928  0.090909  0.909091            1.147985  \n",
       "1929  0.090909  0.909091            0.907280  \n",
       "1930  0.090909  0.909091            0.655902  \n",
       "1931  0.090909  0.909091            0.907280  \n",
       "\n",
       "[1932 rows x 9 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>SEGID</th>\n",
       "      <th>FACTORNAME</th>\n",
       "      <th>FACTORINTERPOLATED</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.763577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_FEB</td>\n",
       "      <td>0.843888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_MAR</td>\n",
       "      <td>1.040550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_APR</td>\n",
       "      <td>1.063648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0015_225.3</td>\n",
       "      <td>FAC_MAY</td>\n",
       "      <td>1.020360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1927</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_THU</td>\n",
       "      <td>1.096793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1928</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_FRI</td>\n",
       "      <td>1.147985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1929</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_SAT</td>\n",
       "      <td>0.907280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1930</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_SUN</td>\n",
       "      <td>0.655902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1931</th>\n",
       "      <td>0006_173.7</td>\n",
       "      <td>FAC_WEMAX</td>\n",
       "      <td>0.907280</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1932 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           SEGID FACTORNAME  FACTORINTERPOLATED\n",
       "0     0015_225.3    FAC_JAN            0.763577\n",
       "1     0015_225.3    FAC_FEB            0.843888\n",
       "2     0015_225.3    FAC_MAR            1.040550\n",
       "3     0015_225.3    FAC_APR            1.063648\n",
       "4     0015_225.3    FAC_MAY            1.020360\n",
       "...          ...        ...                 ...\n",
       "1927  0006_173.7    FAC_THU            1.096793\n",
       "1928  0006_173.7    FAC_FRI            1.147985\n",
       "1929  0006_173.7    FAC_SAT            0.907280\n",
       "1930  0006_173.7    FAC_SUN            0.655902\n",
       "1931  0006_173.7  FAC_WEMAX            0.907280\n",
       "\n",
       "[1932 rows x 3 columns]"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#manual interpolatation\n",
    "\n",
    "display(prmInterpolate)\n",
    "\n",
    "dfFactorsToPublish_InterpolateFrom = pd.DataFrame.merge(prmInterpolate,dfSegFacToPublish,left_on='SEGIDFROM',right_on='SEGID')\n",
    "dfFactorsToPublish_InterpolateFrom = dfFactorsToPublish_InterpolateFrom[['SEGIDTOREV','FACTORNAME','FACTOR','PORTIONFROM']]\n",
    "dfFactorsToPublish_InterpolateFrom = dfFactorsToPublish_InterpolateFrom.rename(columns={'FACTOR':'FACTORFROM'})\n",
    "display(dfFactorsToPublish_InterpolateFrom)\n",
    "\n",
    "dfFactorsToPublish_InterpolateTo   = pd.DataFrame.merge(prmInterpolate,dfSegFacToPublish,left_on='SEGIDTO'  ,right_on='SEGID')\n",
    "dfFactorsToPublish_InterpolateTo   = dfFactorsToPublish_InterpolateTo  [['SEGIDTOREV','FACTORNAME','FACTOR','PORTIONTO']]\n",
    "dfFactorsToPublish_InterpolateTo   = dfFactorsToPublish_InterpolateTo.rename(columns={'FACTOR':'FACTORTO'})\n",
    "display(dfFactorsToPublish_InterpolateTo)\n",
    "\n",
    "dfFactorsToPublish_Interpolate = pd.DataFrame.merge(dfFactorsToPublish_InterpolateFrom,dfFactorsToPublish_InterpolateTo,on=('SEGIDTOREV','FACTORNAME'))\n",
    "\n",
    "dfFactorsToPublish_Interpolate['PF'] = dfFactorsToPublish_Interpolate['PORTIONFROM']/(dfFactorsToPublish_Interpolate['PORTIONTO']+dfFactorsToPublish_Interpolate['PORTIONFROM'])\n",
    "dfFactorsToPublish_Interpolate['PT'] = dfFactorsToPublish_Interpolate['PORTIONTO'  ]/(dfFactorsToPublish_Interpolate['PORTIONTO']+dfFactorsToPublish_Interpolate['PORTIONFROM'])\n",
    "dfFactorsToPublish_Interpolate['FACTORINTERPOLATED'] = dfFactorsToPublish_Interpolate['FACTORFROM'] * dfFactorsToPublish_Interpolate['PF'] + dfFactorsToPublish_Interpolate['FACTORTO'] * dfFactorsToPublish_Interpolate['PT']\n",
    "display(dfFactorsToPublish_Interpolate)\n",
    "\n",
    "dfFactorsToPublish_Interpolate = dfFactorsToPublish_Interpolate[['SEGIDTOREV','FACTORNAME','FACTORINTERPOLATED']]\n",
    "dfFactorsToPublish_Interpolate = dfFactorsToPublish_Interpolate.rename(columns={'SEGIDTOREV':'SEGID'})\n",
    "dfFactorsToPublish_Interpolate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SEGID</th>\n",
       "      <th>AADT2019</th>\n",
       "      <th>AREATYPE</th>\n",
       "      <th>FTGROUP</th>\n",
       "      <th>FACGEO</th>\n",
       "      <th>STATIONGROUP</th>\n",
       "      <th>FACTORNAME</th>\n",
       "      <th>FACTOR</th>\n",
       "      <th>FACTORINTERPOLATED</th>\n",
       "      <th>FACMANADJ</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>49868</th>\n",
       "      <td>0006_177.5</td>\n",
       "      <td>13166.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Expressway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COS</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.8171</td>\n",
       "      <td>0.817084</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49869</th>\n",
       "      <td>0006_177.5</td>\n",
       "      <td>13166.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Expressway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COS</td>\n",
       "      <td>FAC_FEB</td>\n",
       "      <td>0.8605</td>\n",
       "      <td>0.860481</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49870</th>\n",
       "      <td>0006_177.5</td>\n",
       "      <td>13166.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Expressway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COS</td>\n",
       "      <td>FAC_MAR</td>\n",
       "      <td>0.9433</td>\n",
       "      <td>0.943343</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49871</th>\n",
       "      <td>0006_177.5</td>\n",
       "      <td>13166.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Expressway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COS</td>\n",
       "      <td>FAC_APR</td>\n",
       "      <td>0.9828</td>\n",
       "      <td>0.982777</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49872</th>\n",
       "      <td>0006_177.5</td>\n",
       "      <td>13166.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Expressway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COS</td>\n",
       "      <td>FAC_MAY</td>\n",
       "      <td>1.0458</td>\n",
       "      <td>1.045775</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237099</th>\n",
       "      <td>WFRC_8218</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_TUE</td>\n",
       "      <td>0.9886</td>\n",
       "      <td>0.988592</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237100</th>\n",
       "      <td>WFRC_8218</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_WDAVG</td>\n",
       "      <td>1.0222</td>\n",
       "      <td>1.022154</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237101</th>\n",
       "      <td>WFRC_8218</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_WEAVG</td>\n",
       "      <td>0.9200</td>\n",
       "      <td>0.920031</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237102</th>\n",
       "      <td>WFRC_8218</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_WED</td>\n",
       "      <td>1.0228</td>\n",
       "      <td>1.022814</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237103</th>\n",
       "      <td>WFRC_8218</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>XX3</td>\n",
       "      <td>FAC_WEMAX</td>\n",
       "      <td>1.0118</td>\n",
       "      <td>1.011838</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1848 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             SEGID  AADT2019  AREATYPE     FTGROUP     FACGEO STATIONGROUP  \\\n",
       "49868   0006_177.5   13166.0       2.0  Expressway  Statewide          COS   \n",
       "49869   0006_177.5   13166.0       2.0  Expressway  Statewide          COS   \n",
       "49870   0006_177.5   13166.0       2.0  Expressway  Statewide          COS   \n",
       "49871   0006_177.5   13166.0       2.0  Expressway  Statewide          COS   \n",
       "49872   0006_177.5   13166.0       2.0  Expressway  Statewide          COS   \n",
       "...            ...       ...       ...         ...        ...          ...   \n",
       "237099   WFRC_8218       0.0       1.0     Freeway  Statewide          XX3   \n",
       "237100   WFRC_8218       0.0       1.0     Freeway  Statewide          XX3   \n",
       "237101   WFRC_8218       0.0       1.0     Freeway  Statewide          XX3   \n",
       "237102   WFRC_8218       0.0       1.0     Freeway  Statewide          XX3   \n",
       "237103   WFRC_8218       0.0       1.0     Freeway  Statewide          XX3   \n",
       "\n",
       "       FACTORNAME  FACTOR  FACTORINTERPOLATED  FACMANADJ  \n",
       "49868     FAC_JAN  0.8171            0.817084          1  \n",
       "49869     FAC_FEB  0.8605            0.860481          1  \n",
       "49870     FAC_MAR  0.9433            0.943343          1  \n",
       "49871     FAC_APR  0.9828            0.982777          1  \n",
       "49872     FAC_MAY  1.0458            1.045775          1  \n",
       "...           ...     ...                 ...        ...  \n",
       "237099    FAC_TUE  0.9886            0.988592          1  \n",
       "237100  FAC_WDAVG  1.0222            1.022154          1  \n",
       "237101  FAC_WEAVG  0.9200            0.920031          1  \n",
       "237102    FAC_WED  1.0228            1.022814          1  \n",
       "237103  FAC_WEMAX  1.0118            1.011838          1  \n",
       "\n",
       "[1848 rows x 10 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>SEGID</th>\n",
       "      <th>AADT2019</th>\n",
       "      <th>AREATYPE</th>\n",
       "      <th>FTGROUP</th>\n",
       "      <th>FACGEO</th>\n",
       "      <th>STATIONGROUP</th>\n",
       "      <th>FACTORNAME</th>\n",
       "      <th>FACTOR</th>\n",
       "      <th>FACTORINTERPOLATED</th>\n",
       "      <th>FACMANADJ</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_JAN</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_FEB</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_MAR</td>\n",
       "      <td>0.9396</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_APR</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>COP</td>\n",
       "      <td>FAC_MAY</td>\n",
       "      <td>1.1065</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239759</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_THU</td>\n",
       "      <td>1.1470</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239760</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_FRI</td>\n",
       "      <td>1.1521</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239761</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_SAT</td>\n",
       "      <td>0.7860</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239762</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_SUN</td>\n",
       "      <td>0.5763</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239763</th>\n",
       "      <td>0215_027.4</td>\n",
       "      <td>39875.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Freeway</td>\n",
       "      <td>I215</td>\n",
       "      <td>CO8</td>\n",
       "      <td>FAC_WEMAX</td>\n",
       "      <td>0.7860</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>239764 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             SEGID  AADT2019  AREATYPE   FTGROUP     FACGEO STATIONGROUP  \\\n",
       "0       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "1       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "2       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "3       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "4       0006_000.0     415.0       1.0  Arterial  Statewide          COP   \n",
       "...            ...       ...       ...       ...        ...          ...   \n",
       "239759  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "239760  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "239761  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "239762  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "239763  0215_027.4   39875.0       2.0   Freeway       I215          CO8   \n",
       "\n",
       "       FACTORNAME  FACTOR  FACTORINTERPOLATED  FACMANADJ  \n",
       "0         FAC_JAN  0.8159                 0.0          0  \n",
       "1         FAC_FEB  0.8504                 0.0          0  \n",
       "2         FAC_MAR  0.9396                 0.0          0  \n",
       "3         FAC_APR  1.0366                 0.0          0  \n",
       "4         FAC_MAY  1.1065                 0.0          0  \n",
       "...           ...     ...                 ...        ...  \n",
       "239759    FAC_THU  1.1470                 0.0          0  \n",
       "239760    FAC_FRI  1.1521                 0.0          0  \n",
       "239761    FAC_SAT  0.7860                 0.0          0  \n",
       "239762    FAC_SUN  0.5763                 0.0          0  \n",
       "239763  FAC_WEMAX  0.7860                 0.0          0  \n",
       "\n",
       "[239764 rows x 10 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#update with interpolated values\n",
    "\n",
    "dfSegFacToPublishWithInterpolation = pd.DataFrame.merge(dfSegFacToPublish,dfFactorsToPublish_Interpolate,on=('SEGID','FACTORNAME'),how='left')\n",
    "dfSegFacToPublishWithInterpolation = dfSegFacToPublishWithInterpolation.fillna(0)\n",
    "dfSegFacToPublishWithInterpolation.loc[(dfSegFacToPublishWithInterpolation['FACTORINTERPOLATED']>0),'FACTOR'] = dfSegFacToPublishWithInterpolation['FACTORINTERPOLATED']\n",
    "\n",
    "dfSegFacToPublishWithInterpolation['FACMANADJ'] = 0\n",
    "dfSegFacToPublishWithInterpolation.loc[(dfSegFacToPublishWithInterpolation['FACTORINTERPOLATED']>0),'FACMANADJ'] = 1\n",
    "\n",
    "\n",
    "dfSegFacToPublishWithInterpolation['FACTOR'] = round(dfSegFacToPublishWithInterpolation['FACTOR'],4)\n",
    "\n",
    "display(dfSegFacToPublishWithInterpolation[dfSegFacToPublishWithInterpolation['FACTORINTERPOLATED']>0])\n",
    "\n",
    "display(dfSegFacToPublishWithInterpolation)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "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>FACTORNAME</th>\n",
       "      <th>SEGID</th>\n",
       "      <th>STATIONGROUP</th>\n",
       "      <th>FACMANADJ</th>\n",
       "      <th>FAC_APR</th>\n",
       "      <th>FAC_AUG</th>\n",
       "      <th>FAC_DEC</th>\n",
       "      <th>FAC_FAL</th>\n",
       "      <th>FAC_FEB</th>\n",
       "      <th>FAC_FRI</th>\n",
       "      <th>FAC_JAN</th>\n",
       "      <th>...</th>\n",
       "      <th>FAC_SPR</th>\n",
       "      <th>FAC_SUM</th>\n",
       "      <th>FAC_SUN</th>\n",
       "      <th>FAC_THU</th>\n",
       "      <th>FAC_TUE</th>\n",
       "      <th>FAC_WDAVG</th>\n",
       "      <th>FAC_WEAVG</th>\n",
       "      <th>FAC_WED</th>\n",
       "      <th>FAC_WEMAX</th>\n",
       "      <th>FAC_WIN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>0.8819</td>\n",
       "      <td>1.0120</td>\n",
       "      <td>0.9628</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0006_000.7</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>0.8819</td>\n",
       "      <td>1.0120</td>\n",
       "      <td>0.9628</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0006_016.0</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>0.8819</td>\n",
       "      <td>1.0120</td>\n",
       "      <td>0.9628</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0006_046.0</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>0.8819</td>\n",
       "      <td>1.0120</td>\n",
       "      <td>0.9628</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0006_060.2</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>0.8819</td>\n",
       "      <td>1.0120</td>\n",
       "      <td>0.9628</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8558</th>\n",
       "      <td>WFRC_8219</td>\n",
       "      <td>COS</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0119</td>\n",
       "      <td>1.0724</td>\n",
       "      <td>0.9399</td>\n",
       "      <td>1.0324</td>\n",
       "      <td>0.8982</td>\n",
       "      <td>1.1558</td>\n",
       "      <td>0.8600</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0107</td>\n",
       "      <td>1.0575</td>\n",
       "      <td>0.6429</td>\n",
       "      <td>1.1132</td>\n",
       "      <td>1.0744</td>\n",
       "      <td>1.0918</td>\n",
       "      <td>0.7585</td>\n",
       "      <td>1.0878</td>\n",
       "      <td>0.8742</td>\n",
       "      <td>0.8994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8559</th>\n",
       "      <td>WFRC_8220</td>\n",
       "      <td>COT</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0146</td>\n",
       "      <td>1.0396</td>\n",
       "      <td>0.9616</td>\n",
       "      <td>1.0243</td>\n",
       "      <td>0.9471</td>\n",
       "      <td>1.1418</td>\n",
       "      <td>0.9024</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0104</td>\n",
       "      <td>1.0283</td>\n",
       "      <td>0.6061</td>\n",
       "      <td>1.1071</td>\n",
       "      <td>1.0813</td>\n",
       "      <td>1.0924</td>\n",
       "      <td>0.7653</td>\n",
       "      <td>1.0887</td>\n",
       "      <td>0.9245</td>\n",
       "      <td>0.9370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8560</th>\n",
       "      <td>WFRC_8221</td>\n",
       "      <td>COU</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0142</td>\n",
       "      <td>1.0223</td>\n",
       "      <td>0.9907</td>\n",
       "      <td>1.0095</td>\n",
       "      <td>0.9705</td>\n",
       "      <td>1.1450</td>\n",
       "      <td>0.9346</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0117</td>\n",
       "      <td>1.0135</td>\n",
       "      <td>0.6293</td>\n",
       "      <td>1.1063</td>\n",
       "      <td>1.0851</td>\n",
       "      <td>1.0946</td>\n",
       "      <td>0.7583</td>\n",
       "      <td>1.0925</td>\n",
       "      <td>0.8873</td>\n",
       "      <td>0.9653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8561</th>\n",
       "      <td>WFRC_8222</td>\n",
       "      <td>COU</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0142</td>\n",
       "      <td>1.0223</td>\n",
       "      <td>0.9907</td>\n",
       "      <td>1.0095</td>\n",
       "      <td>0.9705</td>\n",
       "      <td>1.1450</td>\n",
       "      <td>0.9346</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0117</td>\n",
       "      <td>1.0135</td>\n",
       "      <td>0.6293</td>\n",
       "      <td>1.1063</td>\n",
       "      <td>1.0851</td>\n",
       "      <td>1.0946</td>\n",
       "      <td>0.7583</td>\n",
       "      <td>1.0925</td>\n",
       "      <td>0.8873</td>\n",
       "      <td>0.9653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8562</th>\n",
       "      <td>WFRC_8223</td>\n",
       "      <td>COU</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0142</td>\n",
       "      <td>1.0223</td>\n",
       "      <td>0.9907</td>\n",
       "      <td>1.0095</td>\n",
       "      <td>0.9705</td>\n",
       "      <td>1.1450</td>\n",
       "      <td>0.9346</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0117</td>\n",
       "      <td>1.0135</td>\n",
       "      <td>0.6293</td>\n",
       "      <td>1.1063</td>\n",
       "      <td>1.0851</td>\n",
       "      <td>1.0946</td>\n",
       "      <td>0.7583</td>\n",
       "      <td>1.0925</td>\n",
       "      <td>0.8873</td>\n",
       "      <td>0.9653</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8563 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "FACTORNAME       SEGID STATIONGROUP  FACMANADJ  FAC_APR  FAC_AUG  FAC_DEC  \\\n",
       "0           0006_000.0          COP          0   1.0366   1.0897   0.8822   \n",
       "1           0006_000.7          COP          0   1.0366   1.0897   0.8822   \n",
       "2           0006_016.0          COP          0   1.0366   1.0897   0.8822   \n",
       "3           0006_046.0          COP          0   1.0366   1.0897   0.8822   \n",
       "4           0006_060.2          COP          0   1.0366   1.0897   0.8822   \n",
       "...                ...          ...        ...      ...      ...      ...   \n",
       "8558         WFRC_8219          COS          0   1.0119   1.0724   0.9399   \n",
       "8559         WFRC_8220          COT          0   1.0146   1.0396   0.9616   \n",
       "8560         WFRC_8221          COU          0   1.0142   1.0223   0.9907   \n",
       "8561         WFRC_8222          COU          0   1.0142   1.0223   0.9907   \n",
       "8562         WFRC_8223          COU          0   1.0142   1.0223   0.9907   \n",
       "\n",
       "FACTORNAME  FAC_FAL  FAC_FEB  FAC_FRI  FAC_JAN  ...  FAC_SPR  FAC_SUM  \\\n",
       "0            1.0316   0.8504   1.1505   0.8159  ...   1.0276   1.0914   \n",
       "1            1.0316   0.8504   1.1505   0.8159  ...   1.0276   1.0914   \n",
       "2            1.0316   0.8504   1.1505   0.8159  ...   1.0276   1.0914   \n",
       "3            1.0316   0.8504   1.1505   0.8159  ...   1.0276   1.0914   \n",
       "4            1.0316   0.8504   1.1505   0.8159  ...   1.0276   1.0914   \n",
       "...             ...      ...      ...      ...  ...      ...      ...   \n",
       "8558         1.0324   0.8982   1.1558   0.8600  ...   1.0107   1.0575   \n",
       "8559         1.0243   0.9471   1.1418   0.9024  ...   1.0104   1.0283   \n",
       "8560         1.0095   0.9705   1.1450   0.9346  ...   1.0117   1.0135   \n",
       "8561         1.0095   0.9705   1.1450   0.9346  ...   1.0117   1.0135   \n",
       "8562         1.0095   0.9705   1.1450   0.9346  ...   1.0117   1.0135   \n",
       "\n",
       "FACTORNAME  FAC_SUN  FAC_THU  FAC_TUE  FAC_WDAVG  FAC_WEAVG  FAC_WED  \\\n",
       "0            0.8819   1.0120   0.9628     0.9840     0.9734   0.9773   \n",
       "1            0.8819   1.0120   0.9628     0.9840     0.9734   0.9773   \n",
       "2            0.8819   1.0120   0.9628     0.9840     0.9734   0.9773   \n",
       "3            0.8819   1.0120   0.9628     0.9840     0.9734   0.9773   \n",
       "4            0.8819   1.0120   0.9628     0.9840     0.9734   0.9773   \n",
       "...             ...      ...      ...        ...        ...      ...   \n",
       "8558         0.6429   1.1132   1.0744     1.0918     0.7585   1.0878   \n",
       "8559         0.6061   1.1071   1.0813     1.0924     0.7653   1.0887   \n",
       "8560         0.6293   1.1063   1.0851     1.0946     0.7583   1.0925   \n",
       "8561         0.6293   1.1063   1.0851     1.0946     0.7583   1.0925   \n",
       "8562         0.6293   1.1063   1.0851     1.0946     0.7583   1.0925   \n",
       "\n",
       "FACTORNAME  FAC_WEMAX  FAC_WIN  \n",
       "0              1.0649   0.8495  \n",
       "1              1.0649   0.8495  \n",
       "2              1.0649   0.8495  \n",
       "3              1.0649   0.8495  \n",
       "4              1.0649   0.8495  \n",
       "...               ...      ...  \n",
       "8558           0.8742   0.8994  \n",
       "8559           0.9245   0.9370  \n",
       "8560           0.8873   0.9653  \n",
       "8561           0.8873   0.9653  \n",
       "8562           0.8873   0.9653  \n",
       "\n",
       "[8563 rows x 31 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#pivot for final table\n",
    "\n",
    "dfFactorsToPublish_pivot = dfSegFacToPublishWithInterpolation.pivot(index=('SEGID','STATIONGROUP','FACMANADJ'),columns='FACTORNAME',values='FACTOR')\n",
    "\n",
    "#change maximum month to integer\n",
    "dfFactorsToPublish_pivot['FAC_MAXMO'] = dfFactorsToPublish_pivot['FAC_MAXMO'].astype(int)\n",
    "\n",
    "dfFactorsToPublish_pivot = dfFactorsToPublish_pivot.reset_index()\n",
    "display(dfFactorsToPublish_pivot)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['SEGID', 'AADT2019', 'AREATYPE', 'FTGROUP', 'FACGEO', 'STATIONGROUP',\n",
       "       'SUTRUCKS', 'CUTRUCKS'],\n",
       "      dtype='object')"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>SEGID</th>\n",
       "      <th>STATIONGROUP</th>\n",
       "      <th>FACMANADJ</th>\n",
       "      <th>FAC_APR</th>\n",
       "      <th>FAC_AUG</th>\n",
       "      <th>FAC_DEC</th>\n",
       "      <th>FAC_FAL</th>\n",
       "      <th>FAC_FEB</th>\n",
       "      <th>FAC_FRI</th>\n",
       "      <th>FAC_JAN</th>\n",
       "      <th>...</th>\n",
       "      <th>FAC_WDAVG</th>\n",
       "      <th>FAC_WEAVG</th>\n",
       "      <th>FAC_WED</th>\n",
       "      <th>FAC_WEMAX</th>\n",
       "      <th>FAC_WIN</th>\n",
       "      <th>AREATYPE</th>\n",
       "      <th>FTGROUP</th>\n",
       "      <th>FACGEO</th>\n",
       "      <th>SUTRUCKS</th>\n",
       "      <th>CUTRUCKS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.2496</td>\n",
       "      <td>0.2324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0006_000.7</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.2496</td>\n",
       "      <td>0.2324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0006_016.0</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.2496</td>\n",
       "      <td>0.2324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0006_046.0</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.1751</td>\n",
       "      <td>0.3338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0006_060.2</td>\n",
       "      <td>COP</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0366</td>\n",
       "      <td>1.0897</td>\n",
       "      <td>0.8822</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>0.8504</td>\n",
       "      <td>1.1505</td>\n",
       "      <td>0.8159</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9840</td>\n",
       "      <td>0.9734</td>\n",
       "      <td>0.9773</td>\n",
       "      <td>1.0649</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.1751</td>\n",
       "      <td>0.3338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8558</th>\n",
       "      <td>WFRC_8219</td>\n",
       "      <td>COS</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0119</td>\n",
       "      <td>1.0724</td>\n",
       "      <td>0.9399</td>\n",
       "      <td>1.0324</td>\n",
       "      <td>0.8982</td>\n",
       "      <td>1.1558</td>\n",
       "      <td>0.8600</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0918</td>\n",
       "      <td>0.7585</td>\n",
       "      <td>1.0878</td>\n",
       "      <td>0.8742</td>\n",
       "      <td>0.8994</td>\n",
       "      <td>2</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.1278</td>\n",
       "      <td>0.0879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8559</th>\n",
       "      <td>WFRC_8220</td>\n",
       "      <td>COT</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0146</td>\n",
       "      <td>1.0396</td>\n",
       "      <td>0.9616</td>\n",
       "      <td>1.0243</td>\n",
       "      <td>0.9471</td>\n",
       "      <td>1.1418</td>\n",
       "      <td>0.9024</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0924</td>\n",
       "      <td>0.7653</td>\n",
       "      <td>1.0887</td>\n",
       "      <td>0.9245</td>\n",
       "      <td>0.9370</td>\n",
       "      <td>3</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.1143</td>\n",
       "      <td>0.0577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8560</th>\n",
       "      <td>WFRC_8221</td>\n",
       "      <td>COU</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0142</td>\n",
       "      <td>1.0223</td>\n",
       "      <td>0.9907</td>\n",
       "      <td>1.0095</td>\n",
       "      <td>0.9705</td>\n",
       "      <td>1.1450</td>\n",
       "      <td>0.9346</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0946</td>\n",
       "      <td>0.7583</td>\n",
       "      <td>1.0925</td>\n",
       "      <td>0.8873</td>\n",
       "      <td>0.9653</td>\n",
       "      <td>4</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.1097</td>\n",
       "      <td>0.0482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8561</th>\n",
       "      <td>WFRC_8222</td>\n",
       "      <td>COU</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0142</td>\n",
       "      <td>1.0223</td>\n",
       "      <td>0.9907</td>\n",
       "      <td>1.0095</td>\n",
       "      <td>0.9705</td>\n",
       "      <td>1.1450</td>\n",
       "      <td>0.9346</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0946</td>\n",
       "      <td>0.7583</td>\n",
       "      <td>1.0925</td>\n",
       "      <td>0.8873</td>\n",
       "      <td>0.9653</td>\n",
       "      <td>4</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.1097</td>\n",
       "      <td>0.0482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8562</th>\n",
       "      <td>WFRC_8223</td>\n",
       "      <td>COU</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0142</td>\n",
       "      <td>1.0223</td>\n",
       "      <td>0.9907</td>\n",
       "      <td>1.0095</td>\n",
       "      <td>0.9705</td>\n",
       "      <td>1.1450</td>\n",
       "      <td>0.9346</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0946</td>\n",
       "      <td>0.7583</td>\n",
       "      <td>1.0925</td>\n",
       "      <td>0.8873</td>\n",
       "      <td>0.9653</td>\n",
       "      <td>4</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Statewide</td>\n",
       "      <td>0.1097</td>\n",
       "      <td>0.0482</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8563 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           SEGID STATIONGROUP  FACMANADJ  FAC_APR  FAC_AUG  FAC_DEC  FAC_FAL  \\\n",
       "0     0006_000.0          COP          0   1.0366   1.0897   0.8822   1.0316   \n",
       "1     0006_000.7          COP          0   1.0366   1.0897   0.8822   1.0316   \n",
       "2     0006_016.0          COP          0   1.0366   1.0897   0.8822   1.0316   \n",
       "3     0006_046.0          COP          0   1.0366   1.0897   0.8822   1.0316   \n",
       "4     0006_060.2          COP          0   1.0366   1.0897   0.8822   1.0316   \n",
       "...          ...          ...        ...      ...      ...      ...      ...   \n",
       "8558   WFRC_8219          COS          0   1.0119   1.0724   0.9399   1.0324   \n",
       "8559   WFRC_8220          COT          0   1.0146   1.0396   0.9616   1.0243   \n",
       "8560   WFRC_8221          COU          0   1.0142   1.0223   0.9907   1.0095   \n",
       "8561   WFRC_8222          COU          0   1.0142   1.0223   0.9907   1.0095   \n",
       "8562   WFRC_8223          COU          0   1.0142   1.0223   0.9907   1.0095   \n",
       "\n",
       "      FAC_FEB  FAC_FRI  FAC_JAN  ...  FAC_WDAVG  FAC_WEAVG  FAC_WED  \\\n",
       "0      0.8504   1.1505   0.8159  ...     0.9840     0.9734   0.9773   \n",
       "1      0.8504   1.1505   0.8159  ...     0.9840     0.9734   0.9773   \n",
       "2      0.8504   1.1505   0.8159  ...     0.9840     0.9734   0.9773   \n",
       "3      0.8504   1.1505   0.8159  ...     0.9840     0.9734   0.9773   \n",
       "4      0.8504   1.1505   0.8159  ...     0.9840     0.9734   0.9773   \n",
       "...       ...      ...      ...  ...        ...        ...      ...   \n",
       "8558   0.8982   1.1558   0.8600  ...     1.0918     0.7585   1.0878   \n",
       "8559   0.9471   1.1418   0.9024  ...     1.0924     0.7653   1.0887   \n",
       "8560   0.9705   1.1450   0.9346  ...     1.0946     0.7583   1.0925   \n",
       "8561   0.9705   1.1450   0.9346  ...     1.0946     0.7583   1.0925   \n",
       "8562   0.9705   1.1450   0.9346  ...     1.0946     0.7583   1.0925   \n",
       "\n",
       "      FAC_WEMAX  FAC_WIN  AREATYPE   FTGROUP     FACGEO  SUTRUCKS  CUTRUCKS  \n",
       "0        1.0649   0.8495         1  Arterial  Statewide    0.2496    0.2324  \n",
       "1        1.0649   0.8495         1  Arterial  Statewide    0.2496    0.2324  \n",
       "2        1.0649   0.8495         1  Arterial  Statewide    0.2496    0.2324  \n",
       "3        1.0649   0.8495         1  Arterial  Statewide    0.1751    0.3338  \n",
       "4        1.0649   0.8495         1  Arterial  Statewide    0.1751    0.3338  \n",
       "...         ...      ...       ...       ...        ...       ...       ...  \n",
       "8558     0.8742   0.8994         2  Arterial  Statewide    0.1278    0.0879  \n",
       "8559     0.9245   0.9370         3  Arterial  Statewide    0.1143    0.0577  \n",
       "8560     0.8873   0.9653         4  Arterial  Statewide    0.1097    0.0482  \n",
       "8561     0.8873   0.9653         4  Arterial  Statewide    0.1097    0.0482  \n",
       "8562     0.8873   0.9653         4  Arterial  Statewide    0.1097    0.0482  \n",
       "\n",
       "[8563 rows x 36 columns]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "display(dfSegFacWithTrk.columns)\n",
    "dfFinalFactors = pd.DataFrame.merge(dfFactorsToPublish_pivot,dfSegFacWithTrk,on=('SEGID','STATIONGROUP'))\n",
    "dfFinalFactors = dfFinalFactors.drop(columns='AADT2019')\n",
    "dfFinalFactors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "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>SEGID</th>\n",
       "      <th>BMP</th>\n",
       "      <th>EMP</th>\n",
       "      <th>DISTANCE</th>\n",
       "      <th>FULLNAME</th>\n",
       "      <th>FNCLASS</th>\n",
       "      <th>FC_CODE</th>\n",
       "      <th>FC_GROUP</th>\n",
       "      <th>FC_NAME</th>\n",
       "      <th>CO_FIPS</th>\n",
       "      <th>...</th>\n",
       "      <th>FAC_WIN</th>\n",
       "      <th>FAC_SPR</th>\n",
       "      <th>FAC_SUM</th>\n",
       "      <th>FAC_FAL</th>\n",
       "      <th>FAC_MAXMO</th>\n",
       "      <th>FAC_MAX</th>\n",
       "      <th>FACMANADJ</th>\n",
       "      <th>SUTRUCKS</th>\n",
       "      <th>CUTRUCKS</th>\n",
       "      <th>SHAPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0006_000.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.665</td>\n",
       "      <td>0.666641</td>\n",
       "      <td>HWY 6</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>3</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Other Principal Arterial</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>5</td>\n",
       "      <td>1.1065</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2496</td>\n",
       "      <td>0.2324</td>\n",
       "      <td>{\"paths\": [[[236177.7000000002, 4327541.25], [...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0006_000.7</td>\n",
       "      <td>0.665</td>\n",
       "      <td>16.022</td>\n",
       "      <td>15.369839</td>\n",
       "      <td>HWY 6</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>3</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Other Principal Arterial</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>5</td>\n",
       "      <td>1.1065</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2496</td>\n",
       "      <td>0.2324</td>\n",
       "      <td>{\"paths\": [[[237241.1799999997, 4327399.720000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0006_016.0</td>\n",
       "      <td>16.022</td>\n",
       "      <td>46.017</td>\n",
       "      <td>30.001961</td>\n",
       "      <td>HWY 6</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>3</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Other Principal Arterial</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>5</td>\n",
       "      <td>1.1065</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2496</td>\n",
       "      <td>0.2324</td>\n",
       "      <td>{\"paths\": [[[261403.90000000037, 4327045.4], [...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0006_046.0</td>\n",
       "      <td>46.017</td>\n",
       "      <td>60.218</td>\n",
       "      <td>14.194306</td>\n",
       "      <td>HWY 6</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>3</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Other Principal Arterial</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>5</td>\n",
       "      <td>1.1065</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1751</td>\n",
       "      <td>0.3338</td>\n",
       "      <td>{\"paths\": [[[305380.16000000015, 4325741.85], ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0006_060.2</td>\n",
       "      <td>60.218</td>\n",
       "      <td>77.545</td>\n",
       "      <td>17.323237</td>\n",
       "      <td>HWY 6</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>3</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Other Principal Arterial</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8495</td>\n",
       "      <td>1.0276</td>\n",
       "      <td>1.0914</td>\n",
       "      <td>1.0316</td>\n",
       "      <td>5</td>\n",
       "      <td>1.1065</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1751</td>\n",
       "      <td>0.3338</td>\n",
       "      <td>{\"paths\": [[[324618, 4337936.9], [324647.40000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8558</th>\n",
       "      <td>WFRC_8219</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.154153</td>\n",
       "      <td></td>\n",
       "      <td>Arterial</td>\n",
       "      <td>50</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Proposed Major Collector</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8994</td>\n",
       "      <td>1.0107</td>\n",
       "      <td>1.0575</td>\n",
       "      <td>1.0324</td>\n",
       "      <td>8</td>\n",
       "      <td>1.0724</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1278</td>\n",
       "      <td>0.0879</td>\n",
       "      <td>{\"paths\": [[[419504.53110000025, 4554272.0693]...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8559</th>\n",
       "      <td>WFRC_8220</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.192948</td>\n",
       "      <td>AIRPORT RD</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>4</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Minor Arterial</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9370</td>\n",
       "      <td>1.0104</td>\n",
       "      <td>1.0283</td>\n",
       "      <td>1.0243</td>\n",
       "      <td>9</td>\n",
       "      <td>1.0434</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1143</td>\n",
       "      <td>0.0577</td>\n",
       "      <td>{\"paths\": [[[415710.1200000001, 4495585.710000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8560</th>\n",
       "      <td>WFRC_8221</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.442365</td>\n",
       "      <td>9400 S</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>2</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Major Collector</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9653</td>\n",
       "      <td>1.0117</td>\n",
       "      <td>1.0135</td>\n",
       "      <td>1.0095</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0245</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1097</td>\n",
       "      <td>0.0482</td>\n",
       "      <td>{\"paths\": [[[423366.5, 4492605.300000003], [42...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8561</th>\n",
       "      <td>WFRC_8222</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.442365</td>\n",
       "      <td>300 W</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>5</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Minor Collector</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9653</td>\n",
       "      <td>1.0117</td>\n",
       "      <td>1.0135</td>\n",
       "      <td>1.0095</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0245</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1097</td>\n",
       "      <td>0.0482</td>\n",
       "      <td>{\"paths\": [[[423433.7000000011, 4493180.6], [4...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8562</th>\n",
       "      <td>WFRC_8223</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.442365</td>\n",
       "      <td>300 W</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>5</td>\n",
       "      <td>Arterial</td>\n",
       "      <td>Major Collector</td>\n",
       "      <td>35</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9653</td>\n",
       "      <td>1.0117</td>\n",
       "      <td>1.0135</td>\n",
       "      <td>1.0095</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0245</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1097</td>\n",
       "      <td>0.0482</td>\n",
       "      <td>{\"paths\": [[[423769.45167498384, 4492597.57415...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8563 rows × 90 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           SEGID     BMP     EMP   DISTANCE    FULLNAME   FNCLASS  FC_CODE  \\\n",
       "0     0006_000.0   0.000   0.665   0.666641       HWY 6  Arterial        3   \n",
       "1     0006_000.7   0.665  16.022  15.369839       HWY 6  Arterial        3   \n",
       "2     0006_016.0  16.022  46.017  30.001961       HWY 6  Arterial        3   \n",
       "3     0006_046.0  46.017  60.218  14.194306       HWY 6  Arterial        3   \n",
       "4     0006_060.2  60.218  77.545  17.323237       HWY 6  Arterial        3   \n",
       "...          ...     ...     ...        ...         ...       ...      ...   \n",
       "8558   WFRC_8219   0.000   0.000   1.154153              Arterial       50   \n",
       "8559   WFRC_8220   0.000   0.000   0.192948  AIRPORT RD  Arterial        4   \n",
       "8560   WFRC_8221   0.000   0.000   0.442365      9400 S  Arterial        2   \n",
       "8561   WFRC_8222   0.000   0.000   0.442365       300 W  Arterial        5   \n",
       "8562   WFRC_8223   0.000   0.000   0.442365       300 W  Arterial        5   \n",
       "\n",
       "      FC_GROUP                   FC_NAME  CO_FIPS  ... FAC_WIN FAC_SPR  \\\n",
       "0     Arterial  Other Principal Arterial       27  ...  0.8495  1.0276   \n",
       "1     Arterial  Other Principal Arterial       27  ...  0.8495  1.0276   \n",
       "2     Arterial  Other Principal Arterial       27  ...  0.8495  1.0276   \n",
       "3     Arterial  Other Principal Arterial       27  ...  0.8495  1.0276   \n",
       "4     Arterial  Other Principal Arterial       27  ...  0.8495  1.0276   \n",
       "...        ...                       ...      ...  ...     ...     ...   \n",
       "8558  Arterial  Proposed Major Collector       11  ...  0.8994  1.0107   \n",
       "8559  Arterial            Minor Arterial       35  ...  0.9370  1.0104   \n",
       "8560  Arterial           Major Collector       35  ...  0.9653  1.0117   \n",
       "8561  Arterial           Minor Collector       35  ...  0.9653  1.0117   \n",
       "8562  Arterial           Major Collector       35  ...  0.9653  1.0117   \n",
       "\n",
       "      FAC_SUM  FAC_FAL FAC_MAXMO FAC_MAX  FACMANADJ  SUTRUCKS  CUTRUCKS  \\\n",
       "0      1.0914   1.0316         5  1.1065          0    0.2496    0.2324   \n",
       "1      1.0914   1.0316         5  1.1065          0    0.2496    0.2324   \n",
       "2      1.0914   1.0316         5  1.1065          0    0.2496    0.2324   \n",
       "3      1.0914   1.0316         5  1.1065          0    0.1751    0.3338   \n",
       "4      1.0914   1.0316         5  1.1065          0    0.1751    0.3338   \n",
       "...       ...      ...       ...     ...        ...       ...       ...   \n",
       "8558   1.0575   1.0324         8  1.0724          0    0.1278    0.0879   \n",
       "8559   1.0283   1.0243         9  1.0434          0    0.1143    0.0577   \n",
       "8560   1.0135   1.0095         5  1.0245          0    0.1097    0.0482   \n",
       "8561   1.0135   1.0095         5  1.0245          0    0.1097    0.0482   \n",
       "8562   1.0135   1.0095         5  1.0245          0    0.1097    0.0482   \n",
       "\n",
       "                                                  SHAPE  \n",
       "0     {\"paths\": [[[236177.7000000002, 4327541.25], [...  \n",
       "1     {\"paths\": [[[237241.1799999997, 4327399.720000...  \n",
       "2     {\"paths\": [[[261403.90000000037, 4327045.4], [...  \n",
       "3     {\"paths\": [[[305380.16000000015, 4325741.85], ...  \n",
       "4     {\"paths\": [[[324618, 4337936.9], [324647.40000...  \n",
       "...                                                 ...  \n",
       "8558  {\"paths\": [[[419504.53110000025, 4554272.0693]...  \n",
       "8559  {\"paths\": [[[415710.1200000001, 4495585.710000...  \n",
       "8560  {\"paths\": [[[423366.5, 4492605.300000003], [42...  \n",
       "8561  {\"paths\": [[[423433.7000000011, 4493180.6], [4...  \n",
       "8562  {\"paths\": [[[423769.45167498384, 4492597.57415...  \n",
       "\n",
       "[8563 rows x 90 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from datetime import datetime\n",
    "#get today's date in yyyymmdd format\n",
    "today = datetime.today().strftime('%Y%m%d')\n",
    "\n",
    "sdfSegmentsWithFinalFactors = pd.DataFrame.merge(sdfSegments,dfFinalFactors,on='SEGID')\n",
    "sdfSegmentsWithFinalFactors = sdfSegmentsWithFinalFactors[['SEGID','BMP','EMP','DISTANCE','FULLNAME','FNCLASS','FC_CODE','FC_GROUP','FC_NAME','CO_FIPS','CO_NAME','PLANAREA','X','Y','ONLRS','T_MODEL','USE','RT_NUM','AADT2019','AADT2018','AADT2017','AADT2016','AADT2015','AADT2014','AADT2013','AADT2012','AADT2011','AADT2010','AADT2009','AADT2008','AADT2007','AADT2006','AADT2005','AADT2004','AADT2003','AADT2002','AADT2001','AADT2000','AADT1999','AADT1998','AADT1997','AADT1996','AADT1994','AADT1993','AADT1992','AADT1991','AADT1990','AADT1989','AADT1988','AADT1987','AADT1986','AADT1985','AADT1984','AADT1983','AADT1982','AADT1981','FACGEO','STATIONGROUP','FAC_MON','FAC_TUE','FAC_WED','FAC_THU','FAC_FRI','FAC_SAT','FAC_SUN','FAC_WDAVG','FAC_WEAVG','FAC_WEMAX','FAC_JAN','FAC_FEB','FAC_MAR','FAC_APR','FAC_MAY','FAC_JUN','FAC_JUL','FAC_AUG','FAC_SEP','FAC_OCT','FAC_NOV','FAC_DEC','FAC_WIN','FAC_SPR','FAC_SUM','FAC_FAL','FAC_MAXMO','FAC_MAX','FACMANADJ','SUTRUCKS','CUTRUCKS','SHAPE']]\n",
    "sdfSegmentsWithFinalFactors = sdfSegmentsWithFinalFactors.sort_values(by=['SEGID'])\n",
    "sdfSegmentsWithFinalFactors = sdfSegmentsWithFinalFactors.fillna(0)\n",
    "\n",
    "#Rename STATIONGROUP to CCSGROUP\n",
    "sdfSegmentsWithFinalFactors = sdfSegmentsWithFinalFactors.rename(columns={\"STATIONGROUP\": \"CCSGROUP19\"})\n",
    "\n",
    "sdfSegmentsWithFinalFactors.spatial.to_featureclass(location=os.path.join(dirResults, r'layers\\Master_Segs_withFactors_' + today + '.shp'),sanitize_columns=False)\n",
    "display(sdfSegmentsWithFinalFactors)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['SEGID', 'STATIONGROUP', 'FACMANADJ', 'FAC_APR', 'FAC_AUG', 'FAC_DEC',\n",
       "       'FAC_FAL', 'FAC_FEB', 'FAC_FRI', 'FAC_JAN', 'FAC_JUL', 'FAC_JUN',\n",
       "       'FAC_MAR', 'FAC_MAX', 'FAC_MAXMO', 'FAC_MAY', 'FAC_MON', 'FAC_NOV',\n",
       "       'FAC_OCT', 'FAC_SAT', 'FAC_SEP', 'FAC_SPR', 'FAC_SUM', 'FAC_SUN',\n",
       "       'FAC_THU', 'FAC_TUE', 'FAC_WDAVG', 'FAC_WEAVG', 'FAC_WED', 'FAC_WEMAX',\n",
       "       'FAC_WIN', 'AREATYPE', 'FTGROUP', 'FACGEO', 'SUTRUCKS', 'CUTRUCKS'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfFinalFactors.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [],
   "source": [
    "#export table to csv\n",
    "\n",
    "dfSegmentsWithFinalFactors = sdfSegmentsWithFinalFactors.drop(columns=['SHAPE'])\n",
    "dfSegmentsWithFinalFactors.to_csv(os.path.join(dirResults, r'Master_Segs_withFactors_' + today + '.csv'),index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'E:\\\\GitHub\\\\UDOT-Segment-Factors\\\\results\\\\Master_Segs_withFactors_20211119.csv'"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.path.join(dirResults, r'Master_Segs_withFactors_' + today + '.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['SEGID', 'BMP', 'EMP', 'DISTANCE', 'FULLNAME', 'FNCLASS', 'FC_CODE',\n",
       "       'FC_GROUP', 'FC_NAME', 'CO_FIPS', 'CO_NAME', 'PLANAREA', 'X', 'Y',\n",
       "       'ONLRS', 'T_MODEL', 'USE', 'RT_NUM', 'AADT2019', 'AADT2018', 'AADT2017',\n",
       "       'AADT2016', 'AADT2015', 'AADT2014', 'AADT2013', 'AADT2012', 'AADT2011',\n",
       "       'AADT2010', 'AADT2009', 'AADT2008', 'AADT2007', 'AADT2006', 'AADT2005',\n",
       "       'AADT2004', 'AADT2003', 'AADT2002', 'AADT2001', 'AADT2000', 'AADT1999',\n",
       "       'AADT1998', 'AADT1997', 'AADT1996', 'AADT1994', 'AADT1993', 'AADT1992',\n",
       "       'AADT1991', 'AADT1990', 'AADT1989', 'AADT1988', 'AADT1987', 'AADT1986',\n",
       "       'AADT1985', 'AADT1984', 'AADT1983', 'AADT1982', 'AADT1981', 'FACGEO',\n",
       "       'CCSGROUP19', 'FAC_MON', 'FAC_TUE', 'FAC_WED', 'FAC_THU', 'FAC_FRI',\n",
       "       'FAC_SAT', 'FAC_SUN', 'FAC_WDAVG', 'FAC_WEAVG', 'FAC_WEMAX', 'FAC_JAN',\n",
       "       'FAC_FEB', 'FAC_MAR', 'FAC_APR', 'FAC_MAY', 'FAC_JUN', 'FAC_JUL',\n",
       "       'FAC_AUG', 'FAC_SEP', 'FAC_OCT', 'FAC_NOV', 'FAC_DEC', 'FAC_WIN',\n",
       "       'FAC_SPR', 'FAC_SUM', 'FAC_FAL', 'FAC_MAXMO', 'FAC_MAX', 'FACMANADJ',\n",
       "       'SUTRUCKS', 'CUTRUCKS', 'SHAPE'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sdfSegmentsWithFinalFactors.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       COP\n",
       "1       COP\n",
       "2       COP\n",
       "3       COP\n",
       "4       COP\n",
       "       ... \n",
       "8558    COS\n",
       "8559    COT\n",
       "8560    COU\n",
       "8561    COU\n",
       "8562    COU\n",
       "Name: CCSGROUP19, Length: 8563, dtype: object"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sdfSegmentsWithFinalFactors['CCSGROUP19']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}