All-Fiscal-Years-Closed_on_Time-KPI.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import datetime as dt\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "% matplotlib inline\n",
    "plt.style.use('fivethirtyeight')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# get the data "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = pd.read_excel('9.14.2017 impact analysis.xlsx',index_col='date_requested',\\\n",
    "                  parse_dates=['date_requested','date_completed'])\n",
    "df = df[['wo_id','date_completed','prob_type']]\n",
    "df['duration'] = df.date_completed - df.index\n",
    "df['fiscal_year'] = np.where(df.index.month >= 7,df.index.year+1, df.index.year)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# checkout what the data looks like"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>wo_id</th>\n",
       "      <th>date_completed</th>\n",
       "      <th>prob_type</th>\n",
       "      <th>duration</th>\n",
       "      <th>fiscal_year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date_requested</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2013-10-11</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2015-08-27</td>\n",
       "      <td>TEST(DO NOT USE)</td>\n",
       "      <td>685 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2013-10-23</td>\n",
       "      <td>FENCE_GATE</td>\n",
       "      <td>7 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>6.0</td>\n",
       "      <td>2013-10-16</td>\n",
       "      <td>PLUMB/OTHER</td>\n",
       "      <td>0 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>7.0</td>\n",
       "      <td>2013-10-17</td>\n",
       "      <td>PAINT</td>\n",
       "      <td>1 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>8.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>9.0</td>\n",
       "      <td>2013-10-21</td>\n",
       "      <td>ROOF</td>\n",
       "      <td>5 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>10.0</td>\n",
       "      <td>2013-10-21</td>\n",
       "      <td>PAINT</td>\n",
       "      <td>5 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>11.0</td>\n",
       "      <td>2013-10-16</td>\n",
       "      <td>PLUMB/OTHER</td>\n",
       "      <td>0 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>20.0</td>\n",
       "      <td>2013-10-23</td>\n",
       "      <td>CEILTILE</td>\n",
       "      <td>7 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>14.0</td>\n",
       "      <td>2014-04-07</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>173 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>15.0</td>\n",
       "      <td>2014-04-07</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>173 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>16.0</td>\n",
       "      <td>2014-01-08</td>\n",
       "      <td>CEILTILE</td>\n",
       "      <td>84 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>17.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>18.0</td>\n",
       "      <td>2014-03-04</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>139 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>19.0</td>\n",
       "      <td>2014-03-12</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>147 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-16</th>\n",
       "      <td>13.0</td>\n",
       "      <td>2013-10-18</td>\n",
       "      <td>DOOR</td>\n",
       "      <td>2 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>44.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>45.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>46.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>47.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>ROOF</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>48.0</td>\n",
       "      <td>2014-12-30</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>439 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>49.0</td>\n",
       "      <td>2013-11-07</td>\n",
       "      <td>PLUMB/LEAK</td>\n",
       "      <td>21 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>53.0</td>\n",
       "      <td>2014-03-12</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>146 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>51.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>ROOF</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>52.0</td>\n",
       "      <td>2014-03-12</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>146 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>43.0</td>\n",
       "      <td>2013-10-18</td>\n",
       "      <td>ELEC/GENERAL</td>\n",
       "      <td>1 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>54.0</td>\n",
       "      <td>2013-10-21</td>\n",
       "      <td>PAINT</td>\n",
       "      <td>4 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>55.0</td>\n",
       "      <td>2014-02-28</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>134 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>56.0</td>\n",
       "      <td>2013-10-18</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>1 days</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-10-17</th>\n",
       "      <td>50.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92741.0</td>\n",
       "      <td>2017-09-13</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>0 days</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92754.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>ELEC/GENERAL</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92775.0</td>\n",
       "      <td>2017-09-13</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>0 days</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92756.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92781.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>HVAC</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92780.0</td>\n",
       "      <td>2017-09-13</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>0 days</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92779.0</td>\n",
       "      <td>2017-09-13</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>0 days</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92778.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92777.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>PLUMB/UNCLOG</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92776.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92774.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>LOCK</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92773.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>ELECTRICAL</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92772.0</td>\n",
       "      <td>2017-09-13</td>\n",
       "      <td>PLUMBING-TOILET</td>\n",
       "      <td>0 days</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92771.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>ELEC/LIGHT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92770.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>_DELIVERY</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92755.0</td>\n",
       "      <td>2017-09-13</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>0 days</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92769.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>_DELIVERY</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92767.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>ELEC/OTHER</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92766.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>ELEC/SECURITY</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92765.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>PLUMB/UNCLOG</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92764.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92763.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92762.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92761.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92760.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92759.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92758.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92757.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>BUILDING PM</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92768.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>92729.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>OTHER</td>\n",
       "      <td>NaT</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64330 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  wo_id date_completed         prob_type duration  fiscal_year\n",
       "date_requested                                                                \n",
       "2013-10-11          1.0     2015-08-27  TEST(DO NOT USE) 685 days         2014\n",
       "2013-10-16          2.0     2013-10-23        FENCE_GATE   7 days         2014\n",
       "2013-10-16          6.0     2013-10-16       PLUMB/OTHER   0 days         2014\n",
       "2013-10-16          7.0     2013-10-17             PAINT   1 days         2014\n",
       "2013-10-16          8.0            NaT              HVAC      NaT         2014\n",
       "2013-10-16          9.0     2013-10-21              ROOF   5 days         2014\n",
       "2013-10-16         10.0     2013-10-21             PAINT   5 days         2014\n",
       "2013-10-16         11.0     2013-10-16       PLUMB/OTHER   0 days         2014\n",
       "2013-10-16         20.0     2013-10-23          CEILTILE   7 days         2014\n",
       "2013-10-16         14.0     2014-04-07              HVAC 173 days         2014\n",
       "2013-10-16         15.0     2014-04-07              HVAC 173 days         2014\n",
       "2013-10-16         16.0     2014-01-08          CEILTILE  84 days         2014\n",
       "2013-10-16         17.0            NaT              HVAC      NaT         2014\n",
       "2013-10-16         18.0     2014-03-04              HVAC 139 days         2014\n",
       "2013-10-16         19.0     2014-03-12              HVAC 147 days         2014\n",
       "2013-10-16         13.0     2013-10-18              DOOR   2 days         2014\n",
       "2013-10-17         44.0            NaT              HVAC      NaT         2014\n",
       "2013-10-17         45.0            NaT              HVAC      NaT         2014\n",
       "2013-10-17         46.0            NaT              HVAC      NaT         2014\n",
       "2013-10-17         47.0            NaT              ROOF      NaT         2014\n",
       "2013-10-17         48.0     2014-12-30              HVAC 439 days         2014\n",
       "2013-10-17         49.0     2013-11-07        PLUMB/LEAK  21 days         2014\n",
       "2013-10-17         53.0     2014-03-12              HVAC 146 days         2014\n",
       "2013-10-17         51.0            NaT              ROOF      NaT         2014\n",
       "2013-10-17         52.0     2014-03-12              HVAC 146 days         2014\n",
       "2013-10-17         43.0     2013-10-18      ELEC/GENERAL   1 days         2014\n",
       "2013-10-17         54.0     2013-10-21             PAINT   4 days         2014\n",
       "2013-10-17         55.0     2014-02-28              HVAC 134 days         2014\n",
       "2013-10-17         56.0     2013-10-18              HVAC   1 days         2014\n",
       "2013-10-17         50.0            NaT              HVAC      NaT         2014\n",
       "...                 ...            ...               ...      ...          ...\n",
       "2017-09-13      92741.0     2017-09-13              HVAC   0 days         2018\n",
       "2017-09-13      92754.0            NaT      ELEC/GENERAL      NaT         2018\n",
       "2017-09-13      92775.0     2017-09-13             OTHER   0 days         2018\n",
       "2017-09-13      92756.0            NaT       BUILDING PM      NaT         2018\n",
       "2017-09-13      92781.0            NaT              HVAC      NaT         2018\n",
       "2017-09-13      92780.0     2017-09-13             OTHER   0 days         2018\n",
       "2017-09-13      92779.0     2017-09-13             OTHER   0 days         2018\n",
       "2017-09-13      92778.0            NaT             OTHER      NaT         2018\n",
       "2017-09-13      92777.0            NaT      PLUMB/UNCLOG      NaT         2018\n",
       "2017-09-13      92776.0            NaT             OTHER      NaT         2018\n",
       "2017-09-13      92774.0            NaT              LOCK      NaT         2018\n",
       "2017-09-13      92773.0            NaT        ELECTRICAL      NaT         2018\n",
       "2017-09-13      92772.0     2017-09-13   PLUMBING-TOILET   0 days         2018\n",
       "2017-09-13      92771.0            NaT        ELEC/LIGHT      NaT         2018\n",
       "2017-09-13      92770.0            NaT         _DELIVERY      NaT         2018\n",
       "2017-09-13      92755.0     2017-09-13       BUILDING PM   0 days         2018\n",
       "2017-09-13      92769.0            NaT         _DELIVERY      NaT         2018\n",
       "2017-09-13      92767.0            NaT        ELEC/OTHER      NaT         2018\n",
       "2017-09-13      92766.0            NaT     ELEC/SECURITY      NaT         2018\n",
       "2017-09-13      92765.0            NaT      PLUMB/UNCLOG      NaT         2018\n",
       "2017-09-13      92764.0            NaT       BUILDING PM      NaT         2018\n",
       "2017-09-13      92763.0            NaT       BUILDING PM      NaT         2018\n",
       "2017-09-13      92762.0            NaT       BUILDING PM      NaT         2018\n",
       "2017-09-13      92761.0            NaT       BUILDING PM      NaT         2018\n",
       "2017-09-13      92760.0            NaT       BUILDING PM      NaT         2018\n",
       "2017-09-13      92759.0            NaT       BUILDING PM      NaT         2018\n",
       "2017-09-13      92758.0            NaT       BUILDING PM      NaT         2018\n",
       "2017-09-13      92757.0            NaT       BUILDING PM      NaT         2018\n",
       "2017-09-13      92768.0            NaT             OTHER      NaT         2018\n",
       "2017-09-13      92729.0            NaT             OTHER      NaT         2018\n",
       "\n",
       "[64330 rows x 5 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_index(inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# filter to get dataframe with only work orders requested in that fiscal year and in doing this exclude all 'test' work orders."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "fy_list = []\n",
    "fy_dfs = []\n",
    "for year in df.fiscal_year.unique():\n",
    "    fy_dfs.append(df.loc[(df.fiscal_year==year) &\\\n",
    "                    (df.prob_type != 'TEST(DO NOT USE)')])\n",
    "    fy_list.append(year)\n",
    "fy_dfs = dict(zip(fy_list,fy_dfs))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# get and store the total number of work orders that were requested in each fiscal year. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{2014: 12209, 2015: 14521, 2016: 16668, 2017: 17193, 2018: 3338}"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "work_order_volume = []\n",
    "for key, value in fy_dfs.items():\n",
    "    work_order_volume.append(value.wo_id.count())\n",
    "work_order_volume = dict(zip(fy_list,work_order_volume))\n",
    "work_order_volume"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# drop work orders that were not closed in each fiscal year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_values([                  wo_id date_completed      prob_type duration  fiscal_year\n",
       "date_requested                                                             \n",
       "2013-10-16          2.0     2013-10-23     FENCE_GATE   7 days         2014\n",
       "2013-10-16          6.0     2013-10-16    PLUMB/OTHER   0 days         2014\n",
       "2013-10-16          7.0     2013-10-17          PAINT   1 days         2014\n",
       "2013-10-16          9.0     2013-10-21           ROOF   5 days         2014\n",
       "2013-10-16         10.0     2013-10-21          PAINT   5 days         2014\n",
       "2013-10-16         11.0     2013-10-16    PLUMB/OTHER   0 days         2014\n",
       "2013-10-16         20.0     2013-10-23       CEILTILE   7 days         2014\n",
       "2013-10-16         14.0     2014-04-07           HVAC 173 days         2014\n",
       "2013-10-16         15.0     2014-04-07           HVAC 173 days         2014\n",
       "2013-10-16         16.0     2014-01-08       CEILTILE  84 days         2014\n",
       "2013-10-16         18.0     2014-03-04           HVAC 139 days         2014\n",
       "2013-10-16         19.0     2014-03-12           HVAC 147 days         2014\n",
       "2013-10-16         13.0     2013-10-18           DOOR   2 days         2014\n",
       "2013-10-17         48.0     2014-12-30           HVAC 439 days         2014\n",
       "2013-10-17         49.0     2013-11-07     PLUMB/LEAK  21 days         2014\n",
       "2013-10-17         53.0     2014-03-12           HVAC 146 days         2014\n",
       "2013-10-17         52.0     2014-03-12           HVAC 146 days         2014\n",
       "2013-10-17         43.0     2013-10-18   ELEC/GENERAL   1 days         2014\n",
       "2013-10-17         54.0     2013-10-21          PAINT   4 days         2014\n",
       "2013-10-17         55.0     2014-02-28           HVAC 134 days         2014\n",
       "2013-10-17         56.0     2013-10-18           HVAC   1 days         2014\n",
       "2013-10-17         42.0     2013-10-17      _DELIVERY   0 days         2014\n",
       "2013-10-17         37.0     2013-10-18  BATHROOM_FIXT   1 days         2014\n",
       "2013-10-17         40.0     2014-07-02      _DELIVERY 258 days         2014\n",
       "2013-10-17         21.0     2013-10-18           HVAC   1 days         2014\n",
       "2013-10-17         23.0     2014-02-11           HVAC 117 days         2014\n",
       "2013-10-17         24.0     2013-10-17  BATHROOM_FIXT   0 days         2014\n",
       "2013-10-17         25.0     2013-10-18  BATHROOM_FIXT   1 days         2014\n",
       "2013-10-17         26.0     2013-10-18  BATHROOM_FIXT   1 days         2014\n",
       "2013-10-17         41.0     2014-03-04           HVAC 138 days         2014\n",
       "...                 ...            ...            ...      ...          ...\n",
       "2014-06-30      12418.0     2014-06-30          OTHER   0 days         2014\n",
       "2014-06-30      12417.0     2014-06-30      SERV/PEST   0 days         2014\n",
       "2014-06-30      12416.0     2014-06-30          FLOOR   0 days         2014\n",
       "2014-06-30      12437.0     2014-08-28     PLUMB/LEAK  59 days         2014\n",
       "2014-06-30      12426.0     2014-06-30          OTHER   0 days         2014\n",
       "2014-06-30      12438.0     2014-09-10           HVAC  72 days         2014\n",
       "2014-06-30      12447.0     2014-07-01          OTHER   1 days         2014\n",
       "2014-06-30      12440.0     2014-07-01      _DELIVERY   1 days         2014\n",
       "2014-06-30      12439.0     2014-07-01      _DELIVERY   1 days         2014\n",
       "2014-06-30      12462.0     2014-09-02     ELEC/LIGHT  64 days         2014\n",
       "2014-06-30      12461.0     2014-07-02          OTHER   2 days         2014\n",
       "2014-06-30      12460.0     2014-07-02  BATHROOM_FIXT   2 days         2014\n",
       "2014-06-30      12459.0     2014-07-02           LOCK   2 days         2014\n",
       "2014-06-30      12458.0     2014-07-03      CARPENTRY   3 days         2014\n",
       "2014-06-30      12457.0     2014-09-02          OTHER  64 days         2014\n",
       "2014-06-30      12455.0     2014-07-01           HVAC   1 days         2014\n",
       "2014-06-30      12454.0     2014-08-13    PLUMB/OTHER  44 days         2014\n",
       "2014-06-30      12453.0     2014-08-15     PLUMB/LEAK  46 days         2014\n",
       "2014-06-30      12452.0     2014-12-03           HVAC 156 days         2014\n",
       "2014-06-30      12456.0     2014-07-02           LOCK   2 days         2014\n",
       "2014-06-30      12450.0     2014-07-01     OVERHDDOOR   1 days         2014\n",
       "2014-06-30      12441.0     2014-07-01      _DELIVERY   1 days         2014\n",
       "2014-06-30      12451.0     2014-07-14     PLUMB/LEAK  14 days         2014\n",
       "2014-06-30      12443.0     2014-07-01      _DELIVERY   1 days         2014\n",
       "2014-06-30      12444.0     2014-07-01      _DELIVERY   1 days         2014\n",
       "2014-06-30      12445.0     2014-08-27    PLUMB/OTHER  58 days         2014\n",
       "2014-06-30      12442.0     2014-07-01      _DELIVERY   1 days         2014\n",
       "2014-06-30      12448.0     2015-05-18     OVERHDDOOR 322 days         2014\n",
       "2014-06-30      12449.0     2014-07-01     OVERHDDOOR   1 days         2014\n",
       "2014-06-30      12446.0     2014-08-28     ELEC/MOTOR  59 days         2014\n",
       "\n",
       "[10455 rows x 5 columns],                   wo_id date_completed       prob_type duration  fiscal_year\n",
       "date_requested                                                              \n",
       "2014-07-01      12489.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12497.0     2014-07-01            DOOR   0 days         2015\n",
       "2014-07-01      12490.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12491.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12492.0     2014-07-01     PLUMB/OTHER   0 days         2015\n",
       "2014-07-01      12493.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12494.0     2014-07-01     PLUMB/OTHER   0 days         2015\n",
       "2014-07-01      12495.0     2014-07-01      ELEC/LIGHT   0 days         2015\n",
       "2014-07-01      12496.0     2014-07-01    ELEC/GENERAL   0 days         2015\n",
       "2014-07-01      12498.0     2014-07-01           OTHER   0 days         2015\n",
       "2014-07-01      12509.0     2014-07-01     PLUMB/OTHER   0 days         2015\n",
       "2014-07-01      12500.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12501.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12502.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12503.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12504.0     2014-07-01    PLUMB/UNCLOG   0 days         2015\n",
       "2014-07-01      12505.0     2014-07-01     PLUMB/OTHER   0 days         2015\n",
       "2014-07-01      12506.0     2014-07-02      PLUMB/LEAK   1 days         2015\n",
       "2014-07-01      12507.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12508.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12488.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12510.0     2014-07-01    ELEC/GENERAL   0 days         2015\n",
       "2014-07-01      12499.0     2014-07-01   SERV/SECURITY   0 days         2015\n",
       "2014-07-01      12487.0     2014-07-18      PLUMB/LEAK  17 days         2015\n",
       "2014-07-01      12476.0     2014-07-01  SERV/CUSTODIAL   0 days         2015\n",
       "2014-07-01      12485.0     2014-07-14       CARPENTRY  13 days         2015\n",
       "2014-07-01      12511.0     2014-07-02          WINDOW   1 days         2015\n",
       "2014-07-01      12463.0     2014-07-07            LAWN   6 days         2015\n",
       "2014-07-01      12464.0     2014-07-01    ELEC/GENERAL   0 days         2015\n",
       "2014-07-01      12465.0     2014-07-02          WINDOW   1 days         2015\n",
       "...                 ...            ...             ...      ...          ...\n",
       "2015-06-29      39559.0     2015-06-30    ELEC/GENERAL   1 days         2015\n",
       "2015-06-29      39567.0     2015-06-30           PAINT   1 days         2015\n",
       "2015-06-30      39586.0     2015-07-07      ELEC/LIGHT   7 days         2015\n",
       "2015-06-30      39585.0     2015-07-07    ELEC/GENERAL   7 days         2015\n",
       "2015-06-30      39584.0     2015-07-15        CEILTILE  15 days         2015\n",
       "2015-06-30      39583.0     2015-07-07   ELEC/EMERLGHT   7 days         2015\n",
       "2015-06-30      39582.0     2015-07-10   BATHROOM_FIXT  10 days         2015\n",
       "2015-06-30      39577.0     2015-07-07      ELEC/LIGHT   7 days         2015\n",
       "2015-06-30      39580.0     2015-07-07     PLUMB/OTHER   7 days         2015\n",
       "2015-06-30      39579.0     2015-07-09            WALL   9 days         2015\n",
       "2015-06-30      39578.0     2015-07-07   BATHROOM_FIXT   7 days         2015\n",
       "2015-06-30      39588.0     2015-07-01            HVAC   1 days         2015\n",
       "2015-06-30      39581.0     2015-07-07     PLUMB/OTHER   7 days         2015\n",
       "2015-06-30      39589.0     2015-07-02    ELEC/GENERAL   2 days         2015\n",
       "2015-06-30      39587.0     2015-07-08      ELEC/LIGHT   8 days         2015\n",
       "2015-06-30      39591.0     2015-07-02       _DELIVERY   2 days         2015\n",
       "2015-06-30      39590.0     2015-07-22      ELEC/OTHER  22 days         2015\n",
       "2015-06-30      39605.0     2015-07-01           OTHER   1 days         2015\n",
       "2015-06-30      39604.0     2015-07-02      ELEC/LIGHT   2 days         2015\n",
       "2015-06-30      39602.0     2015-07-13      ENVIR/MOLD  13 days         2015\n",
       "2015-06-30      39601.0     2015-06-30       _DELIVERY   0 days         2015\n",
       "2015-06-30      39600.0     2015-06-30            LOCK   0 days         2015\n",
       "2015-06-30      39599.0     2015-07-14            HVAC  14 days         2015\n",
       "2015-06-30      39603.0     2015-08-20      ENVIR/MOLD  51 days         2015\n",
       "2015-06-30      39597.0     2015-07-06       SERV/PEST   6 days         2015\n",
       "2015-06-30      39596.0     2015-07-02   BATHROOM_FIXT   2 days         2015\n",
       "2015-06-30      39594.0     2015-06-30      ELEC/LIGHT   0 days         2015\n",
       "2015-06-30      39593.0     2015-07-02      ELEC/LIGHT   2 days         2015\n",
       "2015-06-30      39598.0     2015-07-02   BATHROOM_FIXT   2 days         2015\n",
       "2015-06-30      39592.0     2015-07-02       _DELIVERY   2 days         2015\n",
       "\n",
       "[14356 rows x 5 columns],                   wo_id date_completed       prob_type duration  fiscal_year\n",
       "date_requested                                                              \n",
       "2015-07-01      39640.0     2015-07-01  SERV/CUSTODIAL   0 days         2016\n",
       "2015-07-01      39639.0     2015-07-01  SERV/CUSTODIAL   0 days         2016\n",
       "2015-07-01      39638.0     2015-07-01           OTHER   0 days         2016\n",
       "2015-07-01      39637.0     2015-07-01           OTHER   0 days         2016\n",
       "2015-07-01      39635.0     2015-07-01       SERV/PEST   0 days         2016\n",
       "2015-07-01      39634.0     2015-07-01        ELEVATOR   0 days         2016\n",
       "2015-07-01      39633.0     2015-07-01            HVAC   0 days         2016\n",
       "2015-07-01      39632.0     2015-07-01      ELEC/LIGHT   0 days         2016\n",
       "2015-07-01      39641.0     2015-07-01           OTHER   0 days         2016\n",
       "2015-07-01      39636.0     2015-07-01            HVAC   0 days         2016\n",
       "2015-07-01      39642.0     2015-07-01   SERV/SECURITY   0 days         2016\n",
       "2015-07-01      39649.0     2015-07-01  SERV/CUSTODIAL   0 days         2016\n",
       "2015-07-01      39644.0     2015-07-01           OTHER   0 days         2016\n",
       "2015-07-01      39645.0     2015-07-01  SERV/CUSTODIAL   0 days         2016\n",
       "2015-07-01      39646.0     2015-07-01  SERV/CUSTODIAL   0 days         2016\n",
       "2015-07-01      39647.0     2015-07-01           OTHER   0 days         2016\n",
       "2015-07-01      39648.0     2015-07-24          WINDOW  23 days         2016\n",
       "2015-07-01      39650.0     2015-08-06            ROOF  36 days         2016\n",
       "2015-07-01      39651.0     2015-07-01  SERV/CUSTODIAL   0 days         2016\n",
       "2015-07-01      39653.0     2015-07-01            LAWN   0 days         2016\n",
       "2015-07-01      39652.0     2015-08-14            HVAC  44 days         2016\n",
       "2015-07-01      39631.0     2015-07-01     PLUMB/OTHER   0 days         2016\n",
       "2015-07-01      39643.0     2015-07-01  SERV/CUSTODIAL   0 days         2016\n",
       "2015-07-01      39630.0     2015-07-07      PLUMB/LEAK   6 days         2016\n",
       "2015-07-01      39606.0     2015-08-14            HVAC  44 days         2016\n",
       "2015-07-01      39628.0     2015-07-01            HVAC   0 days         2016\n",
       "2015-07-01      39654.0     2015-07-01  SERV/CUSTODIAL   0 days         2016\n",
       "2015-07-01      39665.0     2015-09-06      OVERHDDOOR  67 days         2016\n",
       "2015-07-01      39607.0     2015-08-20     PLUMB/OTHER  50 days         2016\n",
       "2015-07-01      39608.0     2015-07-15    ELEC/GENERAL  14 days         2016\n",
       "...                 ...            ...             ...      ...          ...\n",
       "2016-06-30      69038.0     2016-08-25          WINDOW  56 days         2016\n",
       "2016-06-30      69017.0     2016-07-08      OVERHDDOOR   8 days         2016\n",
       "2016-06-30      69036.0     2016-06-30           OTHER   0 days         2016\n",
       "2016-06-30      69024.0     2016-07-07            DOOR   7 days         2016\n",
       "2016-06-30      69037.0     2016-06-30           OTHER   0 days         2016\n",
       "2016-06-30      69064.0     2016-09-02  ENVIR/ASBESTOS  64 days         2016\n",
       "2016-06-30      69040.0     2016-07-14           OTHER  14 days         2016\n",
       "2016-06-30      69065.0     2016-08-04            HVAC  35 days         2016\n",
       "2016-06-30      69063.0     2016-06-30           OTHER   0 days         2016\n",
       "2016-06-30      69039.0     2016-06-30            DOOR   0 days         2016\n",
       "2016-06-30      69061.0     2016-07-11    ELEC/GENERAL  11 days         2016\n",
       "2016-06-30      69060.0     2016-06-30           OTHER   0 days         2016\n",
       "2016-06-30      69059.0     2016-06-30           OTHER   0 days         2016\n",
       "2016-06-30      69058.0     2016-06-30           OTHER   0 days         2016\n",
       "2016-06-30      69057.0     2016-07-07    PLUMB/UNCLOG   7 days         2016\n",
       "2016-06-30      69056.0     2016-07-11           PAINT  11 days         2016\n",
       "2016-06-30      69055.0     2016-08-05   PLUMBING-SINK  36 days         2016\n",
       "2016-06-30      69054.0     2016-07-06   ENVIRONMENTAL   6 days         2016\n",
       "2016-06-30      69062.0     2016-06-30           OTHER   0 days         2016\n",
       "2016-06-30      69052.0     2016-07-03           OTHER   3 days         2016\n",
       "2016-06-30      69050.0     2016-06-30           OTHER   0 days         2016\n",
       "2016-06-30      69049.0     2016-06-30      ELEC/LIGHT   0 days         2016\n",
       "2016-06-30      69048.0     2016-08-04           OTHER  35 days         2016\n",
       "2016-06-30      69046.0     2016-06-30           OTHER   0 days         2016\n",
       "2016-06-30      69045.0     2016-07-27           OTHER  27 days         2016\n",
       "2016-06-30      69044.0     2016-07-14           OTHER  14 days         2016\n",
       "2016-06-30      69043.0     2016-06-30            HVAC   0 days         2016\n",
       "2016-06-30      69042.0     2016-08-03     PLUMB/OTHER  34 days         2016\n",
       "2016-06-30      69053.0     2016-07-07           OTHER   7 days         2016\n",
       "2016-06-30      69041.0     2016-07-14           OTHER  14 days         2016\n",
       "\n",
       "[16347 rows x 5 columns],                   wo_id date_completed          prob_type duration  \\\n",
       "date_requested                                                       \n",
       "2016-07-01      69075.0     2016-07-28               DOOR  27 days   \n",
       "2016-07-01      69076.0     2016-07-01     SERV/CUSTODIAL   0 days   \n",
       "2016-07-01      69080.0     2016-07-01     SERV/CUSTODIAL   0 days   \n",
       "2016-07-01      69078.0     2016-07-01               DOOR   0 days   \n",
       "2016-07-01      69079.0     2016-07-01     SERV/CUSTODIAL   0 days   \n",
       "2016-07-01      69074.0     2016-07-06           PAINTING   5 days   \n",
       "2016-07-01      69077.0     2016-07-01              OTHER   0 days   \n",
       "2016-07-01      69073.0     2016-07-11       PLUMB/UNCLOG  10 days   \n",
       "2016-07-01      69068.0     2016-12-11         ELEC/LIGHT 163 days   \n",
       "2016-07-01      69071.0     2016-07-20         PLUMB/LEAK  19 days   \n",
       "2016-07-01      69069.0     2016-07-05              OTHER   4 days   \n",
       "2016-07-01      69067.0     2016-07-01    PLUMBING-TOILET   0 days   \n",
       "2016-07-01      69066.0     2016-07-13         PLUMB/LEAK  12 days   \n",
       "2016-07-01      69087.0     2016-08-25         OVERHDDOOR  55 days   \n",
       "2016-07-01      69081.0     2016-07-01              OTHER   0 days   \n",
       "2016-07-01      69072.0     2016-07-05         PLUMB/LEAK   4 days   \n",
       "2016-07-01      69082.0     2016-07-01               ROOF   0 days   \n",
       "2016-07-01      69091.0     2016-08-23   PREVENTIVE MAINT  53 days   \n",
       "2016-07-01      69084.0     2016-07-01              OTHER   0 days   \n",
       "2016-07-01      69093.0     2016-07-13    PLUMBING-TOILET  12 days   \n",
       "2016-07-01      69091.0     2016-08-23   PREVENTIVE MAINT  53 days   \n",
       "2016-07-01      69091.0     2016-08-23   PREVENTIVE MAINT  53 days   \n",
       "2016-07-01      69091.0     2016-08-23   PREVENTIVE MAINT  53 days   \n",
       "2016-07-01      69091.0     2016-08-03   PREVENTIVE MAINT  33 days   \n",
       "2016-07-01      69091.0     2016-08-10   PREVENTIVE MAINT  40 days   \n",
       "2016-07-01      69091.0     2016-07-27   PREVENTIVE MAINT  26 days   \n",
       "2016-07-01      69083.0     2016-07-01       ELEC/GENERAL   0 days   \n",
       "2016-07-01      69091.0     2016-07-22   PREVENTIVE MAINT  21 days   \n",
       "2016-07-01      69091.0     2016-07-22   PREVENTIVE MAINT  21 days   \n",
       "2016-07-01      69090.0     2016-08-05       PLUMB/UNCLOG  35 days   \n",
       "...                 ...            ...                ...      ...   \n",
       "2017-06-30      89479.0     2017-07-03        PLUMB/OTHER   3 days   \n",
       "2017-06-30      89485.0     2017-08-03               HVAC  34 days   \n",
       "2017-06-30      89488.0     2017-07-27       ELEC/GENERAL  27 days   \n",
       "2017-06-30      89489.0     2017-07-31               HVAC  31 days   \n",
       "2017-06-30      89490.0     2017-07-11       PLUMB/UNCLOG  11 days   \n",
       "2017-06-30      89491.0     2017-07-03    PLUMBING-TOILET   3 days   \n",
       "2017-06-30      89492.0     2017-07-31               HVAC  31 days   \n",
       "2017-06-30      89463.0     2017-06-30     SERV/CUSTODIAL   0 days   \n",
       "2017-06-30      89462.0     2017-06-30               HVAC   0 days   \n",
       "2017-06-30      89467.0     2017-06-30           ELEVATOR   0 days   \n",
       "2017-06-30      89460.0     2017-06-30       PLUMB/UNCLOG   0 days   \n",
       "2017-06-30      89423.0     2017-08-07               HVAC  38 days   \n",
       "2017-06-30      89425.0     2017-07-03        PLUMB/OTHER   3 days   \n",
       "2017-06-30      89426.0     2017-07-12    PLUMBING-TOILET  12 days   \n",
       "2017-06-30      89461.0     2017-06-30     SERV/CUSTODIAL   0 days   \n",
       "2017-06-30      89432.0     2017-07-05   PREVENTIVE MAINT   5 days   \n",
       "2017-06-30      89433.0     2017-07-07          CARPENTRY   7 days   \n",
       "2017-06-30      89436.0     2017-06-30  PLUMBING FIXTURES   0 days   \n",
       "2017-06-30      89437.0     2017-06-30        PLUMB/OTHER   0 days   \n",
       "2017-06-30      89438.0     2017-06-30     SERV/CUSTODIAL   0 days   \n",
       "2017-06-30      89428.0     2017-07-28              PAINT  28 days   \n",
       "2017-06-30      89440.0     2017-06-30         ELEC/LIGHT   0 days   \n",
       "2017-06-30      89441.0     2017-06-30       ELEC/GENERAL   0 days   \n",
       "2017-06-30      89443.0     2017-06-30     SERV/CUSTODIAL   0 days   \n",
       "2017-06-30      89444.0     2017-06-30      BATHROOM_FIXT   0 days   \n",
       "2017-06-30      89448.0     2017-06-30     SERV/CUSTODIAL   0 days   \n",
       "2017-06-30      89449.0     2017-06-30               HVAC   0 days   \n",
       "2017-06-30      89450.0     2017-06-30         ELEC/LIGHT   0 days   \n",
       "2017-06-30      89454.0     2017-07-05      PLUMBING-SINK   5 days   \n",
       "2017-06-30      89457.0     2017-07-05         PLUMB/LEAK   5 days   \n",
       "\n",
       "                fiscal_year  \n",
       "date_requested               \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "2016-07-01             2017  \n",
       "...                     ...  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "2017-06-30             2017  \n",
       "\n",
       "[16297 rows x 5 columns],                   wo_id date_completed                     prob_type duration  \\\n",
       "date_requested                                                                  \n",
       "2017-07-03      89495.0     2017-07-03                         OTHER   0 days   \n",
       "2017-07-03      89494.0     2017-08-17                          HVAC  45 days   \n",
       "2017-07-03      89493.0     2017-07-07                      CEILTILE   4 days   \n",
       "2017-07-03      89499.0     2017-08-07                          HVAC  35 days   \n",
       "2017-07-03      89506.0     2017-08-21             BUILDING EXTERIOR  49 days   \n",
       "2017-07-03      89505.0     2017-07-10                          DOOR   7 days   \n",
       "2017-07-03      89496.0     2017-07-03                         OTHER   0 days   \n",
       "2017-07-03      89498.0     2017-08-25                          HVAC  53 days   \n",
       "2017-07-03      89509.0     2017-07-07                      ELEVATOR   4 days   \n",
       "2017-07-03      89497.0     2017-07-03                         OTHER   0 days   \n",
       "2017-07-03      89500.0     2017-07-03                         OTHER   0 days   \n",
       "2017-07-03      89501.0     2017-07-03                         OTHER   0 days   \n",
       "2017-07-03      89520.0     2017-07-13                  ELEC/GENERAL  10 days   \n",
       "2017-07-03      89519.0     2017-07-05               PLUMBING-TOILET   2 days   \n",
       "2017-07-03      89518.0     2017-07-05                  PLUMB/UNCLOG   2 days   \n",
       "2017-07-03      89515.0     2017-07-05                         OTHER   2 days   \n",
       "2017-07-03      89514.0     2017-07-03                 BATHROOM_FIXT   0 days   \n",
       "2017-07-03      89513.0     2017-07-11                          DOOR   8 days   \n",
       "2017-07-03      89516.0     2017-07-03                         OTHER   0 days   \n",
       "2017-07-03      89511.0     2017-07-13                 ELEC/EMERLGHT  10 days   \n",
       "2017-07-03      89508.0     2017-07-05                  PLUMB/UNCLOG   2 days   \n",
       "2017-07-03      89507.0     2017-07-06                      CEILTILE   3 days   \n",
       "2017-07-03      89503.0     2017-07-05                         OTHER   2 days   \n",
       "2017-07-03      89502.0     2017-07-19                SERV/CUSTODIAL  16 days   \n",
       "2017-07-03      89512.0     2017-08-01                          LOCK  29 days   \n",
       "2017-07-05      89561.0     2017-07-13                SERV/CUSTODIAL   8 days   \n",
       "2017-07-05      89556.0     2017-07-07                      ELEVATOR   2 days   \n",
       "2017-07-05      89557.0     2017-07-07                      ELEVATOR   2 days   \n",
       "2017-07-05      89558.0     2017-07-11                         FLOOR   6 days   \n",
       "2017-07-05      89559.0     2017-08-14                  ELEC/GENERAL  40 days   \n",
       "...                 ...            ...                           ...      ...   \n",
       "2017-09-12      92684.0     2017-09-12                 PLUMBING-SINK   0 days   \n",
       "2017-09-12      92651.0     2017-09-13              PREVENTIVE MAINT   1 days   \n",
       "2017-09-12      92649.0     2017-09-12              PREVENTIVE MAINT   0 days   \n",
       "2017-09-12      92650.0     2017-09-12              PREVENTIVE MAINT   0 days   \n",
       "2017-09-12      92652.0     2017-09-13              PREVENTIVE MAINT   1 days   \n",
       "2017-09-12      92653.0     2017-09-13              PREVENTIVE MAINT   1 days   \n",
       "2017-09-12      92654.0     2017-09-12              PREVENTIVE MAINT   0 days   \n",
       "2017-09-12      92656.0     2017-09-12              PREVENTIVE MAINT   0 days   \n",
       "2017-09-12      92663.0     2017-09-12              PREVENTIVE MAINT   0 days   \n",
       "2017-09-12      92655.0     2017-09-12              PREVENTIVE MAINT   0 days   \n",
       "2017-09-12      92677.0     2017-09-13                         OTHER   1 days   \n",
       "2017-09-12      92695.0     2017-09-12                         OTHER   0 days   \n",
       "2017-09-12      92691.0     2017-09-12                   BUILDING PM   0 days   \n",
       "2017-09-12      92693.0     2017-09-12                    ELEC/LIGHT   0 days   \n",
       "2017-09-12      92697.0     2017-09-12                   BUILDING PM   0 days   \n",
       "2017-09-12      92694.0     2017-09-13               PLUMBING-TOILET   1 days   \n",
       "2017-09-12      92704.0     2017-09-12                    ELEC/LIGHT   0 days   \n",
       "2017-09-12      92705.0     2017-09-12                    ELEC/LIGHT   0 days   \n",
       "2017-09-13      92752.0     2017-09-13                    ELEC/LIGHT   0 days   \n",
       "2017-09-13      92748.0     2017-09-13                   BUILDING PM   0 days   \n",
       "2017-09-13      92751.0     2017-09-13                  PLUMB/UNCLOG   0 days   \n",
       "2017-09-13      92742.0     2017-09-13                SERV/CUSTODIAL   0 days   \n",
       "2017-09-13      92740.0     2017-09-13                SERV/CUSTODIAL   0 days   \n",
       "2017-09-13      92739.0     2017-09-13  BUILDING INTERIOR INSPECTION   0 days   \n",
       "2017-09-13      92741.0     2017-09-13                          HVAC   0 days   \n",
       "2017-09-13      92775.0     2017-09-13                         OTHER   0 days   \n",
       "2017-09-13      92780.0     2017-09-13                         OTHER   0 days   \n",
       "2017-09-13      92779.0     2017-09-13                         OTHER   0 days   \n",
       "2017-09-13      92772.0     2017-09-13               PLUMBING-TOILET   0 days   \n",
       "2017-09-13      92755.0     2017-09-13                   BUILDING PM   0 days   \n",
       "\n",
       "                fiscal_year  \n",
       "date_requested               \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-03             2018  \n",
       "2017-07-05             2018  \n",
       "2017-07-05             2018  \n",
       "2017-07-05             2018  \n",
       "2017-07-05             2018  \n",
       "2017-07-05             2018  \n",
       "...                     ...  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-12             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "2017-09-13             2018  \n",
       "\n",
       "[2275 rows x 5 columns]])"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleaned_fy_dfs = []\n",
    "for key, value in fy_dfs.items():\n",
    "    cleaned_fy_dfs.append(value[value.date_completed.notnull()])\n",
    "cleaned_fy_dfs = dict(zip(fy_list,cleaned_fy_dfs))\n",
    "cleaned_fy_dfs.values()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# add columns for the following: \n",
    "1. work order volume by problem type\n",
    "2. average duration by problem type\n",
    "3. status for whether or not specific work orders 'hit' or 'missed' on timem\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http:https://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \n",
      "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http:https://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n",
      "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/ipykernel_launcher.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http:https://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  after removing the cwd from sys.path.\n"
     ]
    }
   ],
   "source": [
    "for key, value in cleaned_fy_dfs.items():\n",
    "    value['count'] = value.groupby(['prob_type'])['prob_type'].transform('count')\n",
    "    value['avg_duration'] = (value.groupby(['prob_type'])['duration'].\\\n",
    "                        transform('sum') / value['count'])\n",
    "    value['on_time'] = np.where(value.duration <= value.avg_duration,'hit','miss')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# display the the work orders closed on time ( divide the number of work orders closed on time by the total number of work orders received )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "In 2014, 67.17 pct of work orders were closed on time.\n",
      "In 2015, 76.25 pct of work orders were closed on time.\n",
      "In 2016, 74.56 pct of work orders were closed on time.\n",
      "In 2017, 67.88 pct of work orders were closed on time.\n",
      "In 2018, 46.46 pct of work orders were closed on time.\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAakAAAEoCAYAAADiwA4mAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XlYVfW+x/E3YBSDRtcQzIkUBDVNRcWh7KL3ZEmmOFWa\nmhkqakcNVFCPPVoeQnGg4qAe9UrJvY44VlonOYrz0ORNNMyhPCmiV0QEHGDfP3rcN1JwB6zNQj+v\n5+F53Guvvdb393XDZ6+11+CQnZ1tQURExIQcK7sAERGRkiikRETEtBRSIiJiWgopERExLYWUiIiY\nlkJKRERMSyElVZaHhwcbNmyo1BomTJhASEhIpdbwWyEhIUyYMMHu6z19+jQeHh58/fXX5VqOGf5P\nxVyqVXYBIvLHJScnM3HiRP71r38Vm758+XKqVau6v9bHjh3Dw8OjsssQE6m672YRuc0jjzxS2SWU\ni5eXV2WXICaj3X1iWhaLhQ8++IDWrVtTq1YtmjZtyvTp00uc//vvv6dnz554e3vj4+NDeHg4ly9f\nLvb8iy++SL169ahTpw6dOnVix44d1uePHj1K//79qVu3Lr6+vgwbNozMzEzr84WFhUydOpUGDRrQ\noEEDoqKiKCwsvOs4du3aRdeuXfHy8sLPz4/o6GiuX79ufT4kJISIiAhmzJhBw4YN8fX1ZerUqRQV\nFd1xeWlpaYwePZqrV6/i4eGBh4cHMTEx1mX9dndf8+bNiY2NJTw8nLp169KsWTNSUlLIzs7m9ddf\np06dOrRu3Zpt27YVW8fdenE3RUVFREZG0qJFC3788Ufg1115ixYton///tSuXZsnnniClStXFnud\ndvfJ7ymkxLRmzJjB7NmzGT9+PHv37mXZsmXUqVPnjvNevXqVPn364Obmxpdffsny5cvZv38/Y8aM\nsc4TFhaGt7c3X375JWlpaURFRfHQQw8BcO7cObp3706TJk348ssvWb9+Pbm5uQwYMMAaFh9++CEf\nffQR8+fP54svvqCwsJDVq1eXOoZffvmFfv360aJFC3bs2MEHH3zA2rVrbwvb1atX4+TkxOeff87s\n2bNJTEwkJSXljssMCgoiJiYGV1dXjh07xrFjx3jzzTdLrCExMZHAwEC2b99Or169CA8PJywsjD/9\n6U+kpaXRsWNHhg8fTkFBgc29KM2NGzcICwtj165dbN26lUaNGlmfi4mJ4fnnnyctLY3XXnuNkSNH\nlvt7LLm3aXefmFJubi5/+9vfiImJYdCgQQA0bNiQdu3a3XH+NWvWkJeXx8KFC6levToA8+fPp0eP\nHpw4cYKGDRvy888/M2bMGBo3bmxd3i1LlizhiSeeKBYeCxcuxMfHh6+//prAwEASExP585//TGho\nKACxsbG3bYH83pIlS/D29mbOnDk4Ojri7+/P22+/zfjx45kyZQqurq4A+Pv7M2XKFAB8fX1JSkpi\n+/bt9O3b97ZlOjs7U6NGDRwcHGzaPda1a1feeOMNAKKjo0lISODxxx/nlVdeAX49+GP58uWkp6fT\nqlUrm3pRkqtXr/Lyyy9z+fJlPv3009t2P/bo0YOhQ4cCEBkZSVpaGomJiSxatOiu45D7k7akxJSO\nHTvGtWvXeOaZZ2yev1mzZtaAgl+3OBwdHTl69CgAo0aN4s9//jM9evQgLi6OH374wTrvt99+y+7d\nu6lTp471p1mzZgCcPHmSy5cvc+7cOdq2bWt9jaOjY6l/sG/V1aZNGxwd//9XrUOHDly/fp0TJ05Y\np91a1y3e3t5kZWXZNPa7+e2y3d3dcXV1LTatVq1aANb13a0XpRkxYgSXLl1iw4YNd/x+7Lf9u/X4\n1v+PyJ1oS0rueQ4ODsCvWxH9+/fniy++YNu2bcTGxjJ37lwGDRpEUVERzz77LO++++5tr/f09LRp\nN1dZ6wJ44IEHbnvOYqmYGxTcadm/PQLwVh23xni3XpTm2WefZcWKFezbt48uXbqUt3QRbUmJOTVu\n3JgHH3yQ7du32zS/v78/33//PVeuXLFO27dvH0VFRfj7+1unNWrUiJEjR7Jq1SoGDRrExx9/DMCT\nTz7J0aNHqVevHg0bNiz2U716dR5++GG8vb05ePCgdVkWi4WvvvrqrnUdPHiwWMjt2bMHZ2dnHn/8\ncZvGdifOzs42HbRRFnfrRWkGDx5MTEwMAwcOJDU19bbnf9u/W49/+/8j8nsKKTGl6tWrM3LkSKZP\nn87y5cs5efIkhw4dYsmSJXecv1+/fri6ujJy5Ei+//57du3axfjx4+nRowcNGzYkPz/f+h3I6dOn\nOXjwIHv37rX+gXzjjTfIyclh6NChHDx4kFOnTvHPf/6TsWPHWoNv5MiRxMfHs2HDBjIyMoiKirrr\nEW/Dhg3j3LlzREREcOzYMbZu3cr06dMJCwuzfh9VFvXr16egoIDU1FQuXrxIXl5emZf1e7b0ojSv\nvfYaf/3rX+8YVJs2bSIpKYkff/yRuXPnsn37dsLDwyusdrn3KKTEtN5++23GjRvH7NmzadeuHYMH\nD+aXX36547yurq6sXbuWK1eu0LVrVwYMGEDbtm358MMPAXByciI7O5tRo0bRtm1bXn31Vdq2bcvM\nmTMBqF27Nlu3bsXR0ZE+ffrQvn17IiMjcXZ25sEHHwRgzJgxDBw4kDfffJOuXbtSVFREv379Sh3D\nY489xurVq/nuu+94+umnGTNmDH369GHatGnl6k1QUBCvv/46w4YNo1GjRsTHx5dreb9lSy/uZujQ\nobz77ru3BVVUVBQbN26kU6dOLF26lISEBFq3bl1htcu9x0F35hURe/Dw8CApKYmePXtWdilShWhL\nSkRETMuwkCosLOTdd9+lRYsWeHl50aJFC959911u3rxpncdisRATE0NAQADe3t6EhISQnp5uVEki\nIlLFGHYI+vz581m8eDGJiYk0bdqU77//nvDwcJydnZk4cSIA8fHxJCQkkJCQgJ+fH7NmzSI0NJQD\nBw7c9SgiEalasrOzK7sEqYIM+07qpZde4pFHHmHBggXWaSNHjuTSpUusXLkSi8VCQEAAYWFhREZG\nApCfn4+fnx/vvPOO9ax0ERG5fxm2u699+/bs3LnTelb/0aNHSUtL409/+hPw6/1nMjMzi53w5+Li\nQseOHdm3b59RZYmISBVi2O6+cePGkZubS1BQEE5OTty8eZPIyEjrNcRunV/y+zPYPT09OXv2rFFl\niYhIFWJYSKWkpLBixQoWL15MQEAAhw8fJioqivr16zN48GCjVisiIvcQw3b3TZs2zXriYrNmzXj5\n5ZcZPXo08+bNA/7/5ma/v4hmVlaW9YKX94KMjIzKLsG01JuSqTclU29Kd6/1x7CQysvLw8nJqdg0\nJycn6zXMGjRogJeXV7Gz0QsKCtizZw9BQUFGlSUiIlWIYbv7nnvuOebPn0+DBg0ICAjgu+++IyEh\ngZdffhn49crL4eHhzJ07Fz8/P3x9fYmLi8PNze2O99AREZH7j2EhNWvWLGbOnElERAQXLlzAy8uL\nIUOGWM+RAhg7diz5+flMmDCB7OxsAgMDSUlJ0TlSIiIC6Np9hsvIyMDPz6+yyzAl9aZk6k3J1JvS\n3Wv90bX7RETEtBRSIiJiWgopERExLYWUiIiYlmFH90nVc/DQfq5fz7Hb+vLz88i6cNpu6wNwdq5B\nm8B2dl2niJSdQkqsrl/P4Ym6/7LzWi/ZdW3/c8auqxORctLuPhERMS2FlIiImJZCSkRETEvfSYnY\nQAeViFQOhZSIDXRQiUjl0O4+ERExLYWUiIiYlkJKRERMSyElIiKmpZASERHTUkiJiIhpKaRERMS0\nFFIiImJaCikRETEthZSIiJiWQkpERExLISUiIqalkBIREdNSSImIiGkppERExLQUUiIiYloKKRER\nMS2FlIiImJZuHy8i5XLw0H6uX8+x2/ry8/PIunDabusDcHauQZvAdnZdp/xKISUi5XL9eg5P1P2X\nndd6ya5r+58zdl2d/MZ9FVL2/sQH9v/Up098InIvua9CqnI+8YE9P/XpE5+I3Et04ISIiJiWQkpE\nRExLISUiIqalkBIREdNSSImIiGkppERExLQUUiIiYloKKRERMS2FlIiImJZCSkRETEshJSIipqWQ\nEhER01JIiYiIaSmkRETEtAwNqXPnzjFy5EgaNWqEl5cXQUFB7Ny50/q8xWIhJiaGgIAAvL29CQkJ\nIT093ciSRESkCjEspLKzs+nWrRsWi4VVq1axb98+Zs2ahaenp3We+Ph4EhISiI2NZdu2bXh6ehIa\nGsqVK1eMKktERKoQw256+P777+Pt7c3ChQut03x8fKz/tlgsJCYmMm7cOHr27AlAYmIifn5+rFmz\nhqFDhxpVmoiIVBGGbUl98sknBAYGMnToUHx9fXnqqadYtGgRFosFgNOnT5OZmUmXLl2sr3FxcaFj\nx47s27fPqLJERKQKMWxL6tSpUyxZsoRRo0Yxbtw4Dh8+zKRJkwAYPnw4mZmZAMV2/916fPbs2RKX\nm5GRUeaa8vPzyvzaqiI/P6/MPVJ/Sn/dvU69KVl5fq8qQ1Wq1c/Pr9TnDQupoqIiWrVqxdtvvw3A\nk08+yYkTJ1i8eDHDhw8v83LvNqDSZF04DVwq8+urAhcX1zL3SP0pmXpTMvXGXDIyMqpMrbYwbHef\nl5cX/v7+xaY1btyYM2fOWJ8HyMrKKjZPVlYWtWrVMqosERGpQgwLqfbt23P8+PFi044fP069evUA\naNCgAV5eXqSmplqfLygoYM+ePQQFBRlVloiIVCGGhdSoUaM4cOAAcXFxnDhxgvXr17No0SLeeOMN\nABwcHAgPDyc+Pp6NGzdy5MgRRo0ahZubG3379jWqLBERqUIM+06qdevWJCcnM2PGDGbPnk3dunWZ\nPHmyNaQAxo4dS35+PhMmTCA7O5vAwEBSUlKoXr26UWWJiEgVYlhIAXTr1o1u3bqV+LyDgwPR0dFE\nR0cbWYaIiFRRunafiIiYlkJKRERMSyElIiKmpZASERHTUkiJiIhpKaRERMS0FFIiImJaCikRETEt\nhZSIiJiWQkpERExLISUiIqalkBIREdNSSImIiGkppERExLQUUiIiYloKKRERMS2FlIiImJZCSkRE\nTEshJSIipqWQEhER01JIiYiIaSmkRETEtBRSIiJiWgopERExLYWUiIiYls0htWfPHpYvXw7AhQsX\nOHXqlFE1iYiIADaG1Hvvvcf8+fOZN28eADdu3GDEiBGGFiYiImJTSG3evJkVK1bg6uoKQO3atbly\n5YqhhYmIiNgUUs7Ozjg4OODg4ADA1atXDS1KREQEbAyp0NBQxo0bx+XLl0lKSqJXr14MGTLE6NpE\nROQ+V82Wmd58801SU1OpXr06GRkZTJ48meDgYKNrExGR+5xNIQUQHBysYBIREbuyKaTq1q1r/T7q\nlho1atCyZUtmzpyJj4+PEbWJiMh9zqaQGjlyJHXq1KFv375YLBZSUlI4efIkTz75JKNHj+aTTz4x\nuk4RkSrn4KH9XL+eY9d15ufnkXXhtN3W5+xcgzaB7Qxbvk0h9dlnn7Fr1y7r49dee42nnnqK6dOn\nM2fOHMOKExGpyq5fz+GJuv+qhDVfstua/ueMscu36eg+V1dX1q1bR1FREUVFRaxbt46HHnoI4Lbd\ngCIiIhXFppD6+9//zooVK/D19cXPz48VK1awaNEi8vPzmT17ttE1iojIfcqm3X0+Pj6sXLnyjs91\n6NChQgsSERG5xaaQKigo4OOPP+bo0aMUFBRYpyckJBhWmIiIiE27+0aMGEFmZiZffvklnTp14pdf\nfsHd3d3o2kRE5D5nU0idOHGCqVOn4urqyoABA1i1ahWHDh0yujYREbnP2RRSDzzwAAAPP/wwR44c\nIScnh6ysLEMLExERsek7qddee43s7GymTp3KK6+8wtWrV5kyZYrRtYmIyH3OppDq3LkzHh4edOrU\niW+//RZAd+YVERHD2bS7b/DgwbdN0606RETEaKVuSf3www+kp6eTk5PDxo0brdOvXLnCtWvXDC9O\nRETub6WGVEZGBlu3buXy5cts2bLFOt3d3Z34+HjDixMRkftbqSEVEhJCSEgI+/fvp1278l3ldu7c\nucyYMYOwsDDrpZQsFgvvvfceSUlJZGdnExgYSFxcHE2aNCnXukRE5N5g04ETDRs2ZM6cOfz000/c\nvHnTOt3WK04cOHCAZcuW0axZs2LT4+PjSUhIICEhAT8/P2bNmkVoaCgHDhygevXqf2AYIiJyL7Lp\nwIkBAwaQk5PDv//7v/Pss89af2xx+fJlwsLC+PDDD/Hw8LBOt1gsJCYmMm7cOHr27EnTpk1JTEwk\nNzeXNWvWlG00IiJyT7FpSyovL4/p06eXaQW3Qqhz587ExsZap58+fZrMzEy6dOlinebi4kLHjh3Z\nt28fQ4cOLdP6RETk3mHTltRzzz3H559//ocXnpSUZL2k0u9lZmYC4OnpWWy6p6cn58+f/8PrEhGR\ne49NW1ILFixgzpw5ODs74+zsjMViwcHBgZ9//rnE12RkZDBjxgy2bNlivaxSRcjIyCjza/Pz8yqs\nDrPKz88rc4/Un9Jfd69Tb0qm3pSsPH9zAPz8/Ep93qaQOnPmj98feP/+/Vy8eJH27dtbpxUWFrJ7\n926WLl3K3r17AcjKyqJevXrWebKysqhVq1aJy73bgEqTdeE09rytcmVwcXEtc4/Un5KpNyVTb0qm\n3pSfTbv7LBYLK1euZNasWcCvoXW3q6CHhISwe/du0tLSrD+tWrWiT58+pKWl4evri5eXF6mpqdbX\nFBQUsGfPHoKCgsoxJBERuVfYtCUVERGBo6MjO3bsYOLEibi7uzNo0KBiAfN7Hh4exY7mA3B1deWR\nRx6hadOmAISHhzN37lz8/Pzw9fUlLi4ONzc3+vbtW44hiYjIvcKmkDp48CA7duzg6aefBn4NoOvX\nr5d75WPHjiU/P58JEyZYT+ZNSUnROVIiIgLYGFIPPPAAhYWFODg4AHDhwgUcHW3aU1jMJ598Uuyx\ng4MD0dHRREdH/+FliYjIvc/m28cPHDiQCxcu8M477/Dcc88RERFhdG0iInKfs2lLqn///rRs2ZLt\n27djsVhITk7G39/f6NpEROQ+Z1NIHThwgICAAMLCwgDIycnh4MGDtGnTxtDiRETk/mbT7r633noL\nd3d362N3d3feeustw4oSERGBP3Ce1K2DJgAcHR2LXQ1dRETECDaFlI+PDwsWLODGjRvcuHGDxMRE\nfHx8DC5NRETudzaF1Lx589i/fz9NmjShadOmHDp0SHfmFRERw931wInCwkJWrVrF0qVL7VGPiIiI\n1V23pJycnFi7dq09ahERESnGpkPQg4KCmDBhAqGhobi6ulqnt2zZ0rDCREREbAqpw4cPA5Cenm6d\n5uDgwKZNm4ypSkREBBtDavPmzUbXISIichubju47f/48Y8aMsd5C4+jRo3z00UeGFiYiImJTSI0a\nNYquXbty9uxZAHx9fVmwYIGhhYmIiNgUUhcvXiQ0NNR6e45q1aqV6VYdIiIif4RNSePq6sr//u//\nWi+NdODAAWrUqGFoYSIiIjYdODFz5kxeeeUVTp06Rbdu3bhw4QJJSUlG1yYiIvc5m0IqICCAF154\nARcXF9zd3QkJCcHX19fo2kRE5D5n0+6+kSNH8sMPP/DWW28xfPhwjh8/zogRI4yuTURE7nM2bUml\np6ezb98+6+POnTsTFBRkWFEiIiJg45bUk08+yYEDB6yPDx48qEsiiYiI4Wzakvrmm2949tlnqVu3\nLgBnzpzBz8+Pjh07ArB7927jKhQRkfuWTSG1Zs0ao+sQERG5jU0hVb9+faPrEBERuY0uGyEiIqal\nkBIREdNSSImIiGkppERExLQUUiIiYloKKRERMS2FlIiImJZCSkRETEshJSIipqWQEhER01JIiYiI\naSmkRETEtBRSIiJiWgopERExLYWUiIiYlkJKRERMSyElIiKmpZASERHTUkiJiIhpKaRERMS0FFIi\nImJaCikRETEthZSIiJiWQkpEREzLsJCaO3cuwcHB1KtXj0aNGvHSSy9x5MiRYvNYLBZiYmIICAjA\n29ubkJAQ0tPTjSpJRESqGMNCaufOnQwbNoytW7eyceNGqlWrRq9evbh06ZJ1nvj4eBISEoiNjWXb\ntm14enoSGhrKlStXjCpLRESqkGpGLTglJaXY44ULF1K/fn327t3L888/j8ViITExkXHjxtGzZ08A\nEhMT8fPzY82aNQwdOtSo0kREpIqw23dSubm5FBUV4eHhAcDp06fJzMykS5cu1nlcXFzo2LEj+/bt\ns1dZIiJiYoZtSf1eVFQUzZs3p127dgBkZmYC4OnpWWw+T09Pzp49W+JyMjIyylxDfn5emV9bVeTn\n55W5R+pP6a+716k3JVNvSlaevzkAfn5+pT5vl5CaPHkye/fuZcuWLTg5OZVrWXcbUGmyLpwGLt11\nvqrMxcW1zD1Sf0qm3pRMvSmZelN+hu/ui46OZu3atWzcuBEfHx/rdC8vLwCysrKKzZ+VlUWtWrWM\nLktERKoAQ0Nq0qRJ1oBq3LhxsecaNGiAl5cXqamp1mkFBQXs2bOHoKAgI8sSEZEqwrDdfZGRkaxc\nuZLly5fj4eFh/Q7Kzc0Nd3d3HBwcCA8PZ+7cufj5+eHr60tcXBxubm707dvXqLJERKQKMSykFi9e\nDGA9vPyWSZMmER0dDcDYsWPJz89nwoQJZGdnExgYSEpKCtWrVzeqLBERqUIMC6ns7Oy7zuPg4EB0\ndLQ1tERERH5L1+4TERHTUkiJiIhpKaRERMS0FFIiImJaCikRETEthZSIiJiWQkpERExLISUiIqal\nkBIREdNSSImIiGkppERExLQUUiIiYloKKRERMS2FlIiImJZCSkRETEshJSIipqWQEhER01JIiYiI\naSmkRETEtBRSIiJiWgopERExLYWUiIiYlkJKRERMSyElIiKmpZASERHTUkiJiIhpKaRERMS0FFIi\nImJaCikRETEthZSIiJiWQkpERExLISUiIqalkBIREdNSSImIiGkppERExLQUUiIiYloKKRERMS2F\nlIiImJZCSkRETEshJSIipqWQEhER01JIiYiIaSmkRETEtBRSIiJiWgopERExLYWUiIiYlkJKRERM\nyxQhtXjxYlq0aIGXlxfPPPMMu3fvruySRETEBCo9pFJSUoiKiiIiIoIdO3bQrl07+vXrx88//1zZ\npYmISCWr9JBKSEhgwIABDBkyBH9/f2bPno2XlxdLly6t7NJERKSSOWRnZ1sqa+XXr1+ndu3aLFmy\nhF69elmnR0ZGcuTIET799NPKKk1EREygUrekLl68SGFhIZ6ensWme3p6cv78+UqqSkREzKLSd/eJ\niIiUpFJDqmbNmjg5OZGVlVVselZWFrVq1aqkqkRExCwqNaScnZ1p2bIlqampxaanpqYSFBRUSVWJ\niIhZVKvsAkaPHs2IESMIDAwkKCiIpUuXcu7cOYYOHVrZpYmISCWr9O+kevfuTUxMDLNnz+bpp59m\n7969rFq1ivr161d2acydO5fg4GDq1atHo0aNeOmllzhy5EixeSwWCzExMQQEBODt7U1ISAjp6enF\n5omLi6Nbt2489thjeHh4lLrOixcv0qRJEzw8PLh48WKFj6mi2LM3Hh4et/2Y/RQFe793Vq5cyVNP\nPYWXlxcNGzZkxIgRhoyrItirN8nJyXd873h4ePDVV18ZOsaysuf75quvvqJnz57Ur1+f+vXr8+KL\nL3Lo0CHDxlZWlR5SAG+88QaHDx/m/PnzbN++nU6dOlV2SQDs3LmTYcOGsXXrVjZu3Ei1atXo1asX\nly5dss4THx9PQkICsbGxbNu2DU9PT0JDQ7ly5Yp1nmvXrvHCCy8QHh5+13WOGjWK5s2bGzKeimTv\n3rz//vscO3bM+vPKK68YNraKYM/+LFiwgGnTpvHmm2+yZ88eNm3aRPfu3Q0dX3nYqze9e/cu9p45\nduwY/fv3x8fHh1atWhk+zrKwV29yc3Pp06cP3t7e/OMf/+CLL77A29ub3r17F1uOGVTqeVJVTW5u\nLvXr1yc5OZnnn38ei8VCQEAAYWFhREZGApCfn4+fnx/vvPPObbssN2zYwJAhQ8jOzr7j8hMTE/ns\ns8+IiIigZ8+e/Pjjj9SsWdPwcVUEI3vj4eFBUlISPXv2tMtYjGBUf7Kzs2natCnJyckEBwfbbTwV\nyejfq1vy8vIICAhg7NixREREGDaeimRUb77++muCg4P55ptv8PHxAeDUqVPWYwTMFOKm2JKqKnJz\ncykqKrJuPp8+fZrMzEy6dOlincfFxYWOHTuyb9++P7Tsb7/9lvj4eBYsWICjY9X7bzGyNwBRUVE0\nbNiQ4OBgli5dSlFRUYXVbg9G9Sc1NZXCwkLOnz9PUFAQTZo0YeDAgZw6daqih2AYo987t6xbt468\nvDxeffXVctdsL0b1xtfXl0cffZTly5dz7do1rl27xkcffUTdunUJCAio8HGUR9X7a1iJoqKiaN68\nOe3atQMgMzMToNwnI1+9epVhw4YRGxvLY489VnEF25FRvQGYPHkyS5cuZf369fTu3ZupU6cyZ86c\niincTozqz6lTpygqKiIuLo6ZM2eyfPlybt68yQsvvEBeXl7FDcBARr53fispKYlu3brh5eVV9mLt\nzKjeVK9enc2bN7Nu3Tpq165N7dq1SUlJYf369bi4uFTcACpApR/dV1VMnjyZvXv3smXLFpycnCp0\n2ZMmTaJ9+/ZVdneWkb0BmDhxovXfLVq0oKioiDlz5jBhwoQKX5cRjOxPUVERN27cIDY21vrpetGi\nRfj7+7NlyxZ69+5doeuraEa/d25JT09n//79rFq1yrB1VDQje5Ofn8+YMWNo06YNf//73yksLOSD\nDz5gwIABpKam4ubmVqHrKw9tSdkgOjqatWvXsnHjRuv+W8D6iay8JyNv376d//qv/6JmzZrUrFnT\nGlaNGzfmnXfeKf8ADGR0b+4kMDCQnJycKnHpLKP7c2s5/v7+1mkPP/ww3t7enDlzphyVG8+e751l\ny5ZRt24Gc1CJAAAGBUlEQVRd/uM//qPM9dqT0b1ZvXo1J0+e5G9/+xutW7embdu2LF68mDNnzrB5\n8+YKGUNFUUjdxaRJk6xvlsaNGxd7rkGDBnh5eRU7GbmgoIA9e/b8oZOR161bx86dO0lLSyMtLY33\n338fgM2bN5v6UGJ79OZODh8+zEMPPcTDDz9cruUYzR79ad++PQDHjx+3TsvNzSUzM5N69eqVcwTG\nsed7p6CggJUrVzJw4MAq8X2vPXqTn5+Pg4NDsX44Ojri4OBguu97tbuvFJGRkaxcuZLly5fj4eFh\n3R/s5uaGu7s7Dg4OhIeHM3fuXPz8/PD19SUuLg43Nzf69u1rXc7PP//MpUuX+OmnnwD47rvvAGjY\nsCHu7u74+voWW++t86MaN25s2qP77NWbzz77jPPnz9O2bVtcXFxIS0sjJiaGIUOG8OCDD9p/4Day\n53une/fuREVFMW/ePDw8PIiJieHRRx+lW7du9h+4DezVm1s2bNhATk5OlThgwl69CQ4OZtq0aURE\nRDBixAiKioqYN28eTk5OdO7c2f4DL4UOQS9FSSfBTZo0iejoaODXE+vee+89li1bRnZ2NoGBgcTF\nxdG0aVPr/OHh4fz3f//3bcvZtGkTTz/99G3T09LS6NGjh6kPQbdXb/7xj38wffp0Tp48SVFRET4+\nPgwaNIiwsDCqVTPvZyx7vneuXLnClClT2LhxIxaLhfbt2/Pee+/x+OOPGzCy8rP371X37t1xc3Nj\n9erVFTySimfP3qSmphIbG8uRI0dwcHCgefPm/OUvfzHdJekUUiIiYlrm30ErIiL3LYWUiIiYlkJK\nRERMSyElIiKmpZASERHTUkiJiIhpKaRE/qAFCxbQrl07wsLC+PTTT5k3b16FLTs8PJwNGzZU2PJE\nqjrzng0pYlJLlixh/fr11KlTB8DUNxgszc2bN019QrQIaEtK5A8ZP348p06dol+/fiQkJJCcnGy9\nGvv69evp0KEDnTp14vnnnwegsLCQqVOn0qFDBzp27MjChQsBiI2NJTg4mA4dOjB27FgslpLPqT95\n8mSxS9X8+OOP1sfffPMN3bt355lnnqF3796cO3cO+PW2FMHBwXTq1IlBgwZZb9sRHh7O+PHj6dq1\nK9OmTav4BolUMIWUyB8wb948vL292bRpE6NHjy723KxZs1i7di27du2yXpJm2bJl/PTTT6SlpbF7\n92769+8PwPDhw0lNTWXPnj3k5+ezZcuWEtf5+OOPU6NGDev115KTkxk4cCA3btxg4sSJfPTRR2zf\nvp1XX33VetX8Hj16kJqayq5du/D39+fjjz+2Lu+XX37h888/569//WuF9kbECNrWF6kgQUFBjBo1\nitDQUHr06AHAP//5T15//XXrbrVHHnkEgB07dvD++++Tn5/PpUuXaNKkiXXr604GDx5McnIyzZo1\nIyUlhW3btpGRkUF6ejq9evUCfr231K1bORw5coSZM2dy+fJlcnNz6dq1q3VZPXv2NPTeTSIVSSEl\nUkHmzZvHwYMH2bp1K8888wzbt2+/43wFBQVERkaSmppK3bp1iYmJoaCgoNRlv/jii8TGxtK5c2da\ntmzJv/3bv3H27FkCAgL44osvbpt/1KhRJCcn07x5c5KTk9m5c6f1OTPd0E7kbrS7T6SCnDx5kjZt\n2jBlyhQeffRRzpw5Q3BwMP/5n//JzZs3Abh06ZI1kGrWrElubi4bN26867IfeughunTpQkREBAMH\nDgTAz8+PCxcusH//fgBu3LhBeno68Os9pby9vblx40aVuPq3SEm0JSVSQf7yl79w4sQJLBYLnTt3\npnnz5jRt2pTjx4/TqVMnqlWrxpAhQxg+fDhDhgyhQ4cOeHl50apVK5uW379/fz755BPrbeKdnZ1J\nSkpi0qRJ5OTkUFhYSHh4OE2aNGHKlCl07dqVRx99lMDAQHJzc40cuohhdKsOkSrigw8+4PLly0yd\nOrWySxGxG21JiVQBAwcO5OTJk2zatKmySxGxK21JiYiIaenACRERMS2FlIiImJZCSkRETEshJSIi\npqWQEhER01JIiYiIaf0fr5T94ar4hikAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10c4141d0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "pct_timely_kpi = []\n",
    "for year in fy_list:\n",
    "    pct_timely_kpi.append(cleaned_fy_dfs[year].on_time.value_counts()[0]/ \\\n",
    "         work_order_volume[year]*100)\n",
    "    print('In {}, {} pct of work orders were closed on time.'.\\\n",
    "         format(year,round(cleaned_fy_dfs[year].on_time.value_counts()[0]/ \\\n",
    "         work_order_volume[year]*100,2)))\n",
    "pct_timely_kpi = dict(zip(fy_list,pct_timely_kpi))\n",
    "\n",
    "plt.bar(range(len(fy_list)),list(pct_timely_kpi.values()),color='#e2d391',\\\n",
    "        edgecolor='#868e99',align='center')\n",
    "plt.xticks(range(len(fy_list)),list(pct_timely_kpi.keys()))\n",
    "plt.title('closed on time kpi',fontsize=14)\n",
    "plt.xlabel('fiscal year',fontsize=10)\n",
    "plt.ylabel('percentage',fontsize=10);\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# show results arrived in error from not removing the open work orders.  \n",
    "NOTE: the kpi will be different, potentially higher if the denominator used is the total number of all closed work orders instead of the total number of work orders requested. This measure calls for using the total number of work orders requested as the denominator for work order volume</font>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "In 2014, 78.47 pct of work orders were closed on time.\n",
      "In 2015, 77.12 pct of work orders were closed on time.\n",
      "In 2016, 76.18 pct of work orders were closed on time.\n",
      "In 2017, 71.61 pct of work orders were closed on time.\n",
      "In 2018, 68.18 pct of work orders were closed on time.\n"
     ]
    }
   ],
   "source": [
    "old_non_drop_values_methodology = []\n",
    "for year in fy_list:\n",
    "    print('In {}, {} pct of work orders were closed on time.'.\\\n",
    "         format(year,round(cleaned_fy_dfs[year].on_time.value_counts()[0]/ \\\n",
    "         cleaned_fy_dfs[year].wo_id.count()*100,2)))\n",
    "    old_non_drop_values_methodology.append(cleaned_fy_dfs[year].on_time.value_counts()[0]/ \\\n",
    "         cleaned_fy_dfs[year].wo_id.count()*100)\n",
    "old_non_drop_values_methodology = dict(zip(fy_list,old_non_drop_values_methodology))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}