leaves_prediction.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 257,
   "metadata": {},
   "outputs": [],
   "source": [
    "#importing libraries\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.preprocessing import LabelEncoder,OneHotEncoder\n",
    "from sklearn.ensemble import RandomForestRegressor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 264,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('C:\\\\Users\\\\binary\\\\Downloads\\\\data_set.csv',encoding = 'latin') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(40027, 20)\n"
     ]
    },
    {
     "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>APPLICANT_ID</th>\n",
       "      <th>LEAVE_TYPE</th>\n",
       "      <th>STAFF_NO</th>\n",
       "      <th>DESIGNATION</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>HEAD_OF_DEPARTMENT</th>\n",
       "      <th>BUSINESS</th>\n",
       "      <th>DEPARTMENT</th>\n",
       "      <th>SUPERVISOR</th>\n",
       "      <th>S_DATE</th>\n",
       "      <th>S_Month</th>\n",
       "      <th>E_DATE</th>\n",
       "      <th>SEASON</th>\n",
       "      <th>TOTAL_NO_DAYS</th>\n",
       "      <th>IS_ACTIVE</th>\n",
       "      <th>REASON</th>\n",
       "      <th>LEAVE_STATUS_ID</th>\n",
       "      <th>BUSINESS_MANAGER</th>\n",
       "      <th>LEAVE_CODE</th>\n",
       "      <th>STATUS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>102897</td>\n",
       "      <td>PL</td>\n",
       "      <td>159</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Others</td>\n",
       "      <td>Others</td>\n",
       "      <td>4-Dec-15</td>\n",
       "      <td>12</td>\n",
       "      <td>12/5/2015</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>Inprogress</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>105771</td>\n",
       "      <td>PL</td>\n",
       "      <td>159</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Others</td>\n",
       "      <td>Others</td>\n",
       "      <td>17-Dec-16</td>\n",
       "      <td>12</td>\n",
       "      <td>12/17/2016</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>test</td>\n",
       "      <td>3</td>\n",
       "      <td>Shabbir Ali</td>\n",
       "      <td>9004</td>\n",
       "      <td>Posted</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>102974</td>\n",
       "      <td>PL</td>\n",
       "      <td>221</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Cirin Pharma</td>\n",
       "      <td>Others</td>\n",
       "      <td>29-Sep-16</td>\n",
       "      <td>9</td>\n",
       "      <td>9/30/2016</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>test</td>\n",
       "      <td>8</td>\n",
       "      <td>Shabbir Ali</td>\n",
       "      <td>9001</td>\n",
       "      <td>Posted</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102978</td>\n",
       "      <td>PL</td>\n",
       "      <td>221</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Cirin Pharma</td>\n",
       "      <td>Others</td>\n",
       "      <td>30-Sep-16</td>\n",
       "      <td>9</td>\n",
       "      <td>10/1/2016</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>test 02</td>\n",
       "      <td>3</td>\n",
       "      <td>Shabbir Ali</td>\n",
       "      <td>9004</td>\n",
       "      <td>Posted</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>102982</td>\n",
       "      <td>SL</td>\n",
       "      <td>221</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Cirin Pharma</td>\n",
       "      <td>Others</td>\n",
       "      <td>14-Oct-16</td>\n",
       "      <td>10</td>\n",
       "      <td>10/18/2016</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>test</td>\n",
       "      <td>8</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9001</td>\n",
       "      <td>Posted</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   APPLICANT_ID LEAVE_TYPE STAFF_NO       DESIGNATION     LOCATION  \\\n",
       "0        102897         PL      159  Accounts Officer  Abbbottabad   \n",
       "1        105771         PL      159  Accounts Officer  Abbbottabad   \n",
       "2        102974         PL      221  Accounts Officer  Abbbottabad   \n",
       "3        102978         PL      221  Accounts Officer  Abbbottabad   \n",
       "4        102982         SL      221  Accounts Officer  Abbbottabad   \n",
       "\n",
       "  HEAD_OF_DEPARTMENT    BUSINESS    DEPARTMENT SUPERVISOR     S_DATE  S_Month  \\\n",
       "0             Others  Business 5        Others     Others   4-Dec-15       12   \n",
       "1             Others  Business 5        Others     Others  17-Dec-16       12   \n",
       "2             Others  Business 5  Cirin Pharma     Others  29-Sep-16        9   \n",
       "3             Others  Business 5  Cirin Pharma     Others  30-Sep-16        9   \n",
       "4             Others  Business 5  Cirin Pharma     Others  14-Oct-16       10   \n",
       "\n",
       "       E_DATE  SEASON  TOTAL_NO_DAYS  IS_ACTIVE   REASON  LEAVE_STATUS_ID  \\\n",
       "0   12/5/2015       1              1        1.0        1                8   \n",
       "1  12/17/2016       1              0        1.0     test                3   \n",
       "2   9/30/2016       4              1        1.0     test                8   \n",
       "3   10/1/2016       4              1        1.0  test 02                3   \n",
       "4  10/18/2016       4              4        1.0     test                8   \n",
       "\n",
       "  BUSINESS_MANAGER  LEAVE_CODE      STATUS  \n",
       "0       Syed Akram        9001  Inprogress  \n",
       "1      Shabbir Ali        9004      Posted  \n",
       "2      Shabbir Ali        9001      Posted  \n",
       "3      Shabbir Ali        9004      Posted  \n",
       "4     Umran Shahid        9001      Posted  "
      ]
     },
     "execution_count": 265,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#exploratory data analysis\n",
    "\n",
    "print(df.shape)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 266,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(26828, 20)\n"
     ]
    },
    {
     "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>APPLICANT_ID</th>\n",
       "      <th>LEAVE_TYPE</th>\n",
       "      <th>STAFF_NO</th>\n",
       "      <th>DESIGNATION</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>HEAD_OF_DEPARTMENT</th>\n",
       "      <th>BUSINESS</th>\n",
       "      <th>DEPARTMENT</th>\n",
       "      <th>SUPERVISOR</th>\n",
       "      <th>S_DATE</th>\n",
       "      <th>S_Month</th>\n",
       "      <th>E_DATE</th>\n",
       "      <th>SEASON</th>\n",
       "      <th>TOTAL_NO_DAYS</th>\n",
       "      <th>IS_ACTIVE</th>\n",
       "      <th>REASON</th>\n",
       "      <th>LEAVE_STATUS_ID</th>\n",
       "      <th>BUSINESS_MANAGER</th>\n",
       "      <th>LEAVE_CODE</th>\n",
       "      <th>STATUS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>105771</td>\n",
       "      <td>PL</td>\n",
       "      <td>159</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Others</td>\n",
       "      <td>Others</td>\n",
       "      <td>17-Dec-16</td>\n",
       "      <td>12</td>\n",
       "      <td>12/17/2016</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>test</td>\n",
       "      <td>3</td>\n",
       "      <td>Shabbir Ali</td>\n",
       "      <td>9004</td>\n",
       "      <td>Posted</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>102974</td>\n",
       "      <td>PL</td>\n",
       "      <td>221</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Cirin Pharma</td>\n",
       "      <td>Others</td>\n",
       "      <td>29-Sep-16</td>\n",
       "      <td>9</td>\n",
       "      <td>9/30/2016</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>test</td>\n",
       "      <td>8</td>\n",
       "      <td>Shabbir Ali</td>\n",
       "      <td>9001</td>\n",
       "      <td>Posted</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>102978</td>\n",
       "      <td>PL</td>\n",
       "      <td>221</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Cirin Pharma</td>\n",
       "      <td>Others</td>\n",
       "      <td>30-Sep-16</td>\n",
       "      <td>9</td>\n",
       "      <td>10/1/2016</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>test 02</td>\n",
       "      <td>3</td>\n",
       "      <td>Shabbir Ali</td>\n",
       "      <td>9004</td>\n",
       "      <td>Posted</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>102982</td>\n",
       "      <td>SL</td>\n",
       "      <td>221</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Cirin Pharma</td>\n",
       "      <td>Others</td>\n",
       "      <td>14-Oct-16</td>\n",
       "      <td>10</td>\n",
       "      <td>10/18/2016</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>test</td>\n",
       "      <td>8</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9001</td>\n",
       "      <td>Posted</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>103000</td>\n",
       "      <td>SL</td>\n",
       "      <td>221</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>Abbbottabad</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Cirin Pharma</td>\n",
       "      <td>Others</td>\n",
       "      <td>29-Sep-16</td>\n",
       "      <td>9</td>\n",
       "      <td>10/6/2016</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>testing</td>\n",
       "      <td>8</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>Posted</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   APPLICANT_ID LEAVE_TYPE STAFF_NO       DESIGNATION     LOCATION  \\\n",
       "1        105771         PL      159  Accounts Officer  Abbbottabad   \n",
       "2        102974         PL      221  Accounts Officer  Abbbottabad   \n",
       "3        102978         PL      221  Accounts Officer  Abbbottabad   \n",
       "4        102982         SL      221  Accounts Officer  Abbbottabad   \n",
       "5        103000         SL      221  Accounts Officer  Abbbottabad   \n",
       "\n",
       "  HEAD_OF_DEPARTMENT    BUSINESS    DEPARTMENT SUPERVISOR     S_DATE  S_Month  \\\n",
       "1             Others  Business 5        Others     Others  17-Dec-16       12   \n",
       "2             Others  Business 5  Cirin Pharma     Others  29-Sep-16        9   \n",
       "3             Others  Business 5  Cirin Pharma     Others  30-Sep-16        9   \n",
       "4             Others  Business 5  Cirin Pharma     Others  14-Oct-16       10   \n",
       "5             Others  Business 5  Cirin Pharma     Others  29-Sep-16        9   \n",
       "\n",
       "       E_DATE  SEASON  TOTAL_NO_DAYS  IS_ACTIVE   REASON  LEAVE_STATUS_ID  \\\n",
       "1  12/17/2016       1              0        1.0     test                3   \n",
       "2   9/30/2016       4              1        1.0     test                8   \n",
       "3   10/1/2016       4              1        1.0  test 02                3   \n",
       "4  10/18/2016       4              4        1.0     test                8   \n",
       "5   10/6/2016       4              7        1.0  testing                8   \n",
       "\n",
       "  BUSINESS_MANAGER  LEAVE_CODE  STATUS  \n",
       "1      Shabbir Ali        9004  Posted  \n",
       "2      Shabbir Ali        9001  Posted  \n",
       "3      Shabbir Ali        9004  Posted  \n",
       "4     Umran Shahid        9001  Posted  \n",
       "5       Syed Akram        9001  Posted  "
      ]
     },
     "execution_count": 266,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#filtering out data that is approved to predict the number of leaves that will be approved\n",
    "\n",
    "df = df[df['STATUS']=='Posted']\n",
    "print(df.shape)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 267,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['APPLICANT_ID', 'LEAVE_TYPE', 'STAFF_NO', 'DESIGNATION', 'LOCATION',\n",
       "       'HEAD_OF_DEPARTMENT', 'BUSINESS', 'DEPARTMENT', 'SUPERVISOR', 'S_DATE',\n",
       "       'S_Month', 'E_DATE', 'SEASON', 'TOTAL_NO_DAYS', 'IS_ACTIVE', 'REASON',\n",
       "       'LEAVE_STATUS_ID', 'BUSINESS_MANAGER', 'LEAVE_CODE', 'STATUS'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 267,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 268,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "APPLICANT_ID            int64\n",
       "LEAVE_TYPE             object\n",
       "STAFF_NO               object\n",
       "DESIGNATION            object\n",
       "LOCATION               object\n",
       "HEAD_OF_DEPARTMENT     object\n",
       "BUSINESS               object\n",
       "DEPARTMENT             object\n",
       "SUPERVISOR             object\n",
       "S_DATE                 object\n",
       "S_Month                 int64\n",
       "E_DATE                 object\n",
       "SEASON                  int64\n",
       "TOTAL_NO_DAYS           int64\n",
       "IS_ACTIVE             float64\n",
       "REASON                 object\n",
       "LEAVE_STATUS_ID         int64\n",
       "BUSINESS_MANAGER       object\n",
       "LEAVE_CODE              int64\n",
       "STATUS                 object\n",
       "dtype: object"
      ]
     },
     "execution_count": 268,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 269,
   "metadata": {},
   "outputs": [],
   "source": [
    "# feature elimination: discarding the irrelevant fields that won't have an effect on the number of leaves availed and on the overall predictions. \n",
    "df = df.drop(['APPLICANT_ID','IS_ACTIVE','REASON','STATUS'], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 270,
   "metadata": {},
   "outputs": [],
   "source": [
    "#spliting the data on training and testing\n",
    "# data recorded in the year 2018 is used for testing and the model will be trained on the data before that\n",
    "\n",
    "test = df[pd.to_datetime(df['S_DATE']).dt.year == 2018]\n",
    "train = df[pd.to_datetime(df['S_DATE']).dt.year != 2018]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 271,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PL     17770\n",
       "SL      5567\n",
       "LW      1620\n",
       "EPL     1127\n",
       "LR       341\n",
       "PAL      221\n",
       "OL       120\n",
       "MAL       29\n",
       "TL        28\n",
       "PTL        5\n",
       "Name: LEAVE_TYPE, dtype: int64"
      ]
     },
     "execution_count": 271,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['LEAVE_TYPE'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9001    26555\n",
       "9004     8047\n",
       "9010     2218\n",
       "9012     1631\n",
       "1111      509\n",
       "9011      475\n",
       "9013      318\n",
       "9019      180\n",
       "9003       52\n",
       "9005       35\n",
       "9002        7\n",
       "Name: LEAVE_CODE, dtype: int64"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['LEAVE_CODE'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 272,
   "metadata": {},
   "outputs": [],
   "source": [
    "# sdate and edate was helpful just for spliting data and won't contribute to the overall predictions so eliminating them as well \n",
    "\n",
    "train = train.drop(['S_DATE','E_DATE'], axis = 1)\n",
    "test = test.drop(['S_DATE','E_DATE'], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 273,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(26381, 14)\n",
      "(447, 14)\n"
     ]
    }
   ],
   "source": [
    "print(train.shape)\n",
    "print(test.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 274,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['LEAVE_TYPE', 'STAFF_NO', 'DESIGNATION', 'LOCATION',\n",
       "       'HEAD_OF_DEPARTMENT', 'BUSINESS', 'DEPARTMENT', 'SUPERVISOR', 'S_DATE',\n",
       "       'S_Month', 'E_DATE', 'SEASON', 'TOTAL_NO_DAYS', 'LEAVE_STATUS_ID',\n",
       "       'BUSINESS_MANAGER', 'LEAVE_CODE'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 274,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.keys()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 275,
   "metadata": {},
   "outputs": [],
   "source": [
    "#assigning the features and targets variable. \n",
    "\n",
    "X_train = train.drop(['TOTAL_NO_DAYS'],axis = 1)\n",
    "Y_train = train['TOTAL_NO_DAYS']\n",
    "\n",
    "X_test = test.drop(['TOTAL_NO_DAYS'],axis = 1)\n",
    "Y_test = test['TOTAL_NO_DAYS']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 276,
   "metadata": {},
   "outputs": [],
   "source": [
    "# combining the train and test features to label encode. there are a lot of new features that are present in \n",
    "# the testing data but not the training data like a new depatment added later in the years or any new employee joining.\n",
    "# to avoid label encoder throwing an error we combine the data and fit that\n",
    "data = X_train.append(X_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 277,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(26828, 13)"
      ]
     },
     "execution_count": 277,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 278,
   "metadata": {},
   "outputs": [],
   "source": [
    "#label encoder is used to encode features in a format that can  be understood by the model\n",
    "# we fit the label encoder on the entire dataset and later on use it to transform our training and test sets\n",
    "\n",
    "le = LabelEncoder()\n",
    "for i in range(0,12):\n",
    "    data.iloc[:,i] = le.fit_transform(data.iloc[:,i])\n",
    "    X_test.iloc[:,i] = le.transform(X_test.iloc[:,i])\n",
    "    X_train.iloc[:,i] = le.transform(X_train.iloc[:,i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 279,
   "metadata": {},
   "outputs": [],
   "source": [
    "# since the spread of the data is a bit skewed and does not follow any fixed pregression non linear models like\n",
    "# tree based algorithms can woek best. random forest being the most popular choice we go for this \n",
    "# keeping the samples split to 20 to bring about a generalizaton and avoid overfiting \n",
    "model = RandomForestRegressor(min_samples_split = 20,n_jobs = -1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 280,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\python36\\scripts\\osamaenv\\lib\\site-packages\\sklearn\\ensemble\\forest.py:246: FutureWarning: The default value of n_estimators will change from 10 in version 0.20 to 100 in 0.22.\n",
      "  \"10 in version 0.20 to 100 in 0.22.\", FutureWarning)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "RandomForestRegressor(bootstrap=True, criterion='mse', max_depth=None,\n",
       "           max_features='auto', max_leaf_nodes=None,\n",
       "           min_impurity_decrease=0.0, min_impurity_split=None,\n",
       "           min_samples_leaf=1, min_samples_split=20,\n",
       "           min_weight_fraction_leaf=0.0, n_estimators=10, n_jobs=-1,\n",
       "           oob_score=False, random_state=None, verbose=0, warm_start=False)"
      ]
     },
     "execution_count": 280,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.fit(X_train.values,Y_train.values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 281,
   "metadata": {},
   "outputs": [],
   "source": [
    "# model predicting test values\n",
    "pred = model.predict(X_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 282,
   "metadata": {},
   "outputs": [],
   "source": [
    "#changing format to integer\n",
    "pred = pred.astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 283,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2.335570469798658"
      ]
     },
     "execution_count": 283,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#error on a single prediciton\n",
    "from sklearn.metrics import mean_absolute_error\n",
    "mean_absolute_error(Y_test,pred)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 284,
   "metadata": {},
   "outputs": [],
   "source": [
    "#appending predictions to test data\n",
    "test['pred'] = pred"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 285,
   "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>LEAVE_TYPE</th>\n",
       "      <th>STAFF_NO</th>\n",
       "      <th>DESIGNATION</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>HEAD_OF_DEPARTMENT</th>\n",
       "      <th>BUSINESS</th>\n",
       "      <th>DEPARTMENT</th>\n",
       "      <th>SUPERVISOR</th>\n",
       "      <th>S_Month</th>\n",
       "      <th>SEASON</th>\n",
       "      <th>TOTAL_NO_DAYS</th>\n",
       "      <th>LEAVE_STATUS_ID</th>\n",
       "      <th>BUSINESS_MANAGER</th>\n",
       "      <th>LEAVE_CODE</th>\n",
       "      <th>pred</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>PL</td>\n",
       "      <td>2197</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Accounting</td>\n",
       "      <td>Shamim Ahmed</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9012</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>PL</td>\n",
       "      <td>3706</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>SSD</td>\n",
       "      <td>Noman K Dar</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>PL</td>\n",
       "      <td>567</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Shamim Ahmed</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>Mehjabeen Batlay</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>SL</td>\n",
       "      <td>2172</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Aamir Jamil</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Accounting</td>\n",
       "      <td>Faizan Ahmed(Shared Accounting)</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Yousaf Awan</td>\n",
       "      <td>9004</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1257</th>\n",
       "      <td>EPL</td>\n",
       "      <td>2488</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Saba Ali</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9001</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1288</th>\n",
       "      <td>SL</td>\n",
       "      <td>2645</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Shamim Ahmed</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Saba Ali</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1346</th>\n",
       "      <td>PL</td>\n",
       "      <td>2890</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Noman K Dar</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1347</th>\n",
       "      <td>PL</td>\n",
       "      <td>2890</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Noman K Dar</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1348</th>\n",
       "      <td>EPL</td>\n",
       "      <td>2890</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Noman K Dar</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1370</th>\n",
       "      <td>PL</td>\n",
       "      <td>3496</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Shamim Ahmed</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Saba Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>Naureen Rodrigues</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1371</th>\n",
       "      <td>PL</td>\n",
       "      <td>3496</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Shamim Ahmed</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Saba Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1372</th>\n",
       "      <td>PL</td>\n",
       "      <td>3496</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Shamim Ahmed</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Saba Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>Naureen Rodrigues</td>\n",
       "      <td>9004</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1373</th>\n",
       "      <td>PL</td>\n",
       "      <td>3496</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Shamim Ahmed</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Saba Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>Shabbir Ali</td>\n",
       "      <td>9004</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1374</th>\n",
       "      <td>PL</td>\n",
       "      <td>3496</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Shamim Ahmed</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Saba Ali</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>Shabbir Ali</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1375</th>\n",
       "      <td>PL</td>\n",
       "      <td>3706</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Finance</td>\n",
       "      <td>Noman K Dar</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>Naureen Rodrigues</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1377</th>\n",
       "      <td>PL</td>\n",
       "      <td>3885</td>\n",
       "      <td>Accounts Officer</td>\n",
       "      <td>LHR</td>\n",
       "      <td>Aamir Jamil</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Shared Services Accounting</td>\n",
       "      <td>Faizan Ahmed(Shared Accounting)</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9001</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1430</th>\n",
       "      <td>PL</td>\n",
       "      <td>1998</td>\n",
       "      <td>Administration Manager</td>\n",
       "      <td>Quetta</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 1</td>\n",
       "      <td>Administration</td>\n",
       "      <td>Aqil Karim</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1431</th>\n",
       "      <td>PL</td>\n",
       "      <td>1998</td>\n",
       "      <td>Administration Manager</td>\n",
       "      <td>Quetta</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 1</td>\n",
       "      <td>Administration</td>\n",
       "      <td>Aqil Karim</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1763</th>\n",
       "      <td>PL</td>\n",
       "      <td>516</td>\n",
       "      <td>Administration Manager</td>\n",
       "      <td>ISL</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 2</td>\n",
       "      <td>Administration</td>\n",
       "      <td>Ahmed Jamal Cheema</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9004</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1764</th>\n",
       "      <td>PL</td>\n",
       "      <td>516</td>\n",
       "      <td>Administration Manager</td>\n",
       "      <td>ISL</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 2</td>\n",
       "      <td>Administration</td>\n",
       "      <td>Ahmed Jamal Cheema</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>Dilnavaz Malbari</td>\n",
       "      <td>9001</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2037</th>\n",
       "      <td>PL</td>\n",
       "      <td>2968</td>\n",
       "      <td>Area Manager Retail</td>\n",
       "      <td>Multan</td>\n",
       "      <td>Anwaar Ul Haq</td>\n",
       "      <td>Business 7</td>\n",
       "      <td>Commercial</td>\n",
       "      <td>Muhamamd Umar Latif</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Yousaf Awan</td>\n",
       "      <td>9012</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2038</th>\n",
       "      <td>PL</td>\n",
       "      <td>2916</td>\n",
       "      <td>Analyst Business Intelligence</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 5</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Zain A Khawaja</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9011</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2095</th>\n",
       "      <td>PL</td>\n",
       "      <td>740</td>\n",
       "      <td>Area Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Mahmood Ahmed. Awan</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Naeem Mustafa</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9004</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2630</th>\n",
       "      <td>PL</td>\n",
       "      <td>2245</td>\n",
       "      <td>Area Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Abdul Manan</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9001</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2631</th>\n",
       "      <td>PL</td>\n",
       "      <td>2245</td>\n",
       "      <td>Area Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Abdul Manan</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9010</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2632</th>\n",
       "      <td>PL</td>\n",
       "      <td>2245</td>\n",
       "      <td>Area Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Abdul Manan</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Murial D Souza</td>\n",
       "      <td>9001</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2651</th>\n",
       "      <td>SL</td>\n",
       "      <td>2299</td>\n",
       "      <td>Area Manager</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Fahad Iqtidar</td>\n",
       "      <td>Business 3</td>\n",
       "      <td>Agriculture</td>\n",
       "      <td>Ghaffar Alizada</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9010</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2749</th>\n",
       "      <td>PL</td>\n",
       "      <td>2572</td>\n",
       "      <td>Area Manager</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Atif Mushtaq</td>\n",
       "      <td>Business 3</td>\n",
       "      <td>Others</td>\n",
       "      <td>Saleem Ahmed Alizada</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Naureen Rodrigues</td>\n",
       "      <td>9001</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2799</th>\n",
       "      <td>PL</td>\n",
       "      <td>2790</td>\n",
       "      <td>Area Manager</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Fahad Iqtidar</td>\n",
       "      <td>Business 3</td>\n",
       "      <td>Others</td>\n",
       "      <td>Ghaffar Alizada</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>Syed Akram</td>\n",
       "      <td>9001</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2860</th>\n",
       "      <td>SL</td>\n",
       "      <td>3249</td>\n",
       "      <td>Area Manager</td>\n",
       "      <td>Islamabad</td>\n",
       "      <td>Anwaar Ul Haq</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Zafar Iqbal</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Naureen Rodrigues</td>\n",
       "      <td>9001</td>\n",
       "      <td>4</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37336</th>\n",
       "      <td>PL</td>\n",
       "      <td>3209</td>\n",
       "      <td>Technical Services Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 3</td>\n",
       "      <td>Others</td>\n",
       "      <td>Muhammad Raheel Chhipa</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>3</td>\n",
       "      <td>Mamoona Ashfaq</td>\n",
       "      <td>9001</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37519</th>\n",
       "      <td>PL</td>\n",
       "      <td>3742</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>Gujrat</td>\n",
       "      <td>Imtiaz A Awan</td>\n",
       "      <td>Business 7</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Zaheer Saim</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>Others</td>\n",
       "      <td>9001</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37529</th>\n",
       "      <td>PL</td>\n",
       "      <td>2981</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Syed Saleem Akhtar</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Qaisar Hanif</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9004</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37597</th>\n",
       "      <td>PL</td>\n",
       "      <td>739</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Naeem Mustafa</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9010</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38356</th>\n",
       "      <td>PL</td>\n",
       "      <td>2542</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mahmood Ahmed. Awan</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Masood Rana</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Nabia Akhtar</td>\n",
       "      <td>9001</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38492</th>\n",
       "      <td>PL</td>\n",
       "      <td>2987</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Fahad Iqtidar</td>\n",
       "      <td>Business 3</td>\n",
       "      <td>Others</td>\n",
       "      <td>Ghaffar Alizada</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>1111</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38540</th>\n",
       "      <td>SL</td>\n",
       "      <td>3206</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>Sargodha</td>\n",
       "      <td>Anwaar Ul Haq</td>\n",
       "      <td>Business 7</td>\n",
       "      <td>Commercial</td>\n",
       "      <td>Muhammad Junaid Arshad</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Naureen Rodrigues</td>\n",
       "      <td>9004</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38552</th>\n",
       "      <td>SL</td>\n",
       "      <td>3228</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Nadeem Abbas</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Bilal Javed</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>Joanna D.Thomas</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38553</th>\n",
       "      <td>SL</td>\n",
       "      <td>3228</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Nadeem Abbas</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Bilal Javed</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>Nabia Akhtar</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38554</th>\n",
       "      <td>SL</td>\n",
       "      <td>3228</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Nadeem Abbas</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Bilal Javed</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Sidra Saleem</td>\n",
       "      <td>9004</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38602</th>\n",
       "      <td>PL</td>\n",
       "      <td>3467</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Syed Arif Rajput</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Irshad Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9001</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38603</th>\n",
       "      <td>PL</td>\n",
       "      <td>3467</td>\n",
       "      <td>Territory Manager</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Syed Arif Rajput</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Irshad Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>Naureen Rodrigues</td>\n",
       "      <td>9001</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38691</th>\n",
       "      <td>PL</td>\n",
       "      <td>2998</td>\n",
       "      <td>Territory Manger</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Fahad Iqtidar</td>\n",
       "      <td>Business 3</td>\n",
       "      <td>Others</td>\n",
       "      <td>Ghaffar Alizada</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9001</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38692</th>\n",
       "      <td>SL</td>\n",
       "      <td>2998</td>\n",
       "      <td>Territory Manger</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Fahad Iqtidar</td>\n",
       "      <td>Business 3</td>\n",
       "      <td>Others</td>\n",
       "      <td>Ghaffar Alizada</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38737</th>\n",
       "      <td>SL</td>\n",
       "      <td>3404</td>\n",
       "      <td>Territory Manger</td>\n",
       "      <td>Islamabad</td>\n",
       "      <td>Imtiaz A Awan</td>\n",
       "      <td>Business 4</td>\n",
       "      <td>Commercial</td>\n",
       "      <td>Sajid Nawaz Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38738</th>\n",
       "      <td>SL</td>\n",
       "      <td>3404</td>\n",
       "      <td>Territory Manger</td>\n",
       "      <td>Islamabad</td>\n",
       "      <td>Imtiaz A Awan</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Sajid Nawaz Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9001</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38739</th>\n",
       "      <td>PL</td>\n",
       "      <td>3404</td>\n",
       "      <td>Territory Manger</td>\n",
       "      <td>Islamabad</td>\n",
       "      <td>Imtiaz A Awan</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Sajid Nawaz Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9001</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38926</th>\n",
       "      <td>PL</td>\n",
       "      <td>2049</td>\n",
       "      <td>TM</td>\n",
       "      <td>Peshawar</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Liaqat Ali Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9001</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38927</th>\n",
       "      <td>PL</td>\n",
       "      <td>2049</td>\n",
       "      <td>TM</td>\n",
       "      <td>Peshawar</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Liaqat Ali Ali</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>Sidra Saleem</td>\n",
       "      <td>9010</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39060</th>\n",
       "      <td>PL</td>\n",
       "      <td>2045</td>\n",
       "      <td>TM</td>\n",
       "      <td>LHR</td>\n",
       "      <td>Irshad Ali</td>\n",
       "      <td>Business 7</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Saleem Bhutto</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>Sidra Saleem</td>\n",
       "      <td>9012</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39061</th>\n",
       "      <td>PL</td>\n",
       "      <td>2045</td>\n",
       "      <td>TM</td>\n",
       "      <td>LHR</td>\n",
       "      <td>Irshad Ali</td>\n",
       "      <td>Business 7</td>\n",
       "      <td>Animal Health</td>\n",
       "      <td>Saleem Bhutto</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Sidra Saleem</td>\n",
       "      <td>9012</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39073</th>\n",
       "      <td>PL</td>\n",
       "      <td>2547</td>\n",
       "      <td>TM - Swat</td>\n",
       "      <td>Peshawar</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Liaqat Ali Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9001</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39074</th>\n",
       "      <td>PL</td>\n",
       "      <td>2547</td>\n",
       "      <td>TM - Swat</td>\n",
       "      <td>Peshawar</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Liaqat Ali Ali</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Sana Idrees</td>\n",
       "      <td>9001</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39204</th>\n",
       "      <td>PL</td>\n",
       "      <td>3401</td>\n",
       "      <td>Trade Officer</td>\n",
       "      <td>LHR</td>\n",
       "      <td>Syed Jawad Nagani</td>\n",
       "      <td>Business 3</td>\n",
       "      <td>Others</td>\n",
       "      <td>Noman Jafri</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Sidra Saleem</td>\n",
       "      <td>9001</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39205</th>\n",
       "      <td>PL</td>\n",
       "      <td>3401</td>\n",
       "      <td>Trade Officer</td>\n",
       "      <td>LHR</td>\n",
       "      <td>Syed Jawad Nagani</td>\n",
       "      <td>Business 3</td>\n",
       "      <td>Others</td>\n",
       "      <td>Noman Jafri</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9001</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39644</th>\n",
       "      <td>PL</td>\n",
       "      <td>2357</td>\n",
       "      <td>Turbine Officer</td>\n",
       "      <td>ISL</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 2</td>\n",
       "      <td>Production</td>\n",
       "      <td>Tanveer Ahmed Bhatti</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>Umran Shahid</td>\n",
       "      <td>9012</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39656</th>\n",
       "      <td>PL</td>\n",
       "      <td>2406</td>\n",
       "      <td>Turbine Officer</td>\n",
       "      <td>ISL</td>\n",
       "      <td>Rehman Ali</td>\n",
       "      <td>Business 2</td>\n",
       "      <td>Production</td>\n",
       "      <td>Tanveer Ahmed Bhatti</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9001</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39717</th>\n",
       "      <td>PL</td>\n",
       "      <td>3378</td>\n",
       "      <td>Veterinary Trainee Officer</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Others</td>\n",
       "      <td>Anwaar Ul Haq</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>Mubashra Bukhsh</td>\n",
       "      <td>9001</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39895</th>\n",
       "      <td>EPL</td>\n",
       "      <td>2478</td>\n",
       "      <td>Warehouse In Charge</td>\n",
       "      <td>KHI</td>\n",
       "      <td>Razi Hassan</td>\n",
       "      <td>Business 6</td>\n",
       "      <td>Supply Chain</td>\n",
       "      <td>Muhammad Ilyas</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9010</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39971</th>\n",
       "      <td>LW</td>\n",
       "      <td>318</td>\n",
       "      <td>Works Manager</td>\n",
       "      <td>Quetta</td>\n",
       "      <td>Others</td>\n",
       "      <td>Business 1</td>\n",
       "      <td>Operations</td>\n",
       "      <td>Suhail A Ali</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Shahana Murshad</td>\n",
       "      <td>9001</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>447 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      LEAVE_TYPE STAFF_NO                    DESIGNATION   LOCATION  \\\n",
       "127           PL     2197               Accounts Officer        KHI   \n",
       "167           PL     3706               Accounts Officer        KHI   \n",
       "360           PL      567               Accounts Officer        KHI   \n",
       "1044          SL     2172               Accounts Officer        KHI   \n",
       "1257         EPL     2488               Accounts Officer        KHI   \n",
       "1288          SL     2645               Accounts Officer        KHI   \n",
       "1346          PL     2890               Accounts Officer        KHI   \n",
       "1347          PL     2890               Accounts Officer        KHI   \n",
       "1348         EPL     2890               Accounts Officer        KHI   \n",
       "1370          PL     3496               Accounts Officer        KHI   \n",
       "1371          PL     3496               Accounts Officer        KHI   \n",
       "1372          PL     3496               Accounts Officer        KHI   \n",
       "1373          PL     3496               Accounts Officer        KHI   \n",
       "1374          PL     3496               Accounts Officer        KHI   \n",
       "1375          PL     3706               Accounts Officer        KHI   \n",
       "1377          PL     3885               Accounts Officer        LHR   \n",
       "1430          PL     1998         Administration Manager     Quetta   \n",
       "1431          PL     1998         Administration Manager     Quetta   \n",
       "1763          PL      516         Administration Manager        ISL   \n",
       "1764          PL      516         Administration Manager        ISL   \n",
       "2037          PL     2968            Area Manager Retail     Multan   \n",
       "2038          PL     2916  Analyst Business Intelligence        KHI   \n",
       "2095          PL      740                   Area Manager        KHI   \n",
       "2630          PL     2245                   Area Manager        KHI   \n",
       "2631          PL     2245                   Area Manager        KHI   \n",
       "2632          PL     2245                   Area Manager        KHI   \n",
       "2651          SL     2299                   Area Manager  Hyderabad   \n",
       "2749          PL     2572                   Area Manager  Hyderabad   \n",
       "2799          PL     2790                   Area Manager  Hyderabad   \n",
       "2860          SL     3249                   Area Manager  Islamabad   \n",
       "...          ...      ...                            ...        ...   \n",
       "37336         PL     3209     Technical Services Manager        KHI   \n",
       "37519         PL     3742              Territory Manager     Gujrat   \n",
       "37529         PL     2981              Territory Manager        KHI   \n",
       "37597         PL      739              Territory Manager        KHI   \n",
       "38356         PL     2542              Territory Manager  Hyderabad   \n",
       "38492         PL     2987              Territory Manager  Hyderabad   \n",
       "38540         SL     3206              Territory Manager   Sargodha   \n",
       "38552         SL     3228              Territory Manager        KHI   \n",
       "38553         SL     3228              Territory Manager        KHI   \n",
       "38554         SL     3228              Territory Manager        KHI   \n",
       "38602         PL     3467              Territory Manager  Hyderabad   \n",
       "38603         PL     3467              Territory Manager  Hyderabad   \n",
       "38691         PL     2998               Territory Manger  Hyderabad   \n",
       "38692         SL     2998               Territory Manger  Hyderabad   \n",
       "38737         SL     3404               Territory Manger  Islamabad   \n",
       "38738         SL     3404               Territory Manger  Islamabad   \n",
       "38739         PL     3404               Territory Manger  Islamabad   \n",
       "38926         PL     2049                             TM   Peshawar   \n",
       "38927         PL     2049                             TM   Peshawar   \n",
       "39060         PL     2045                             TM        LHR   \n",
       "39061         PL     2045                             TM        LHR   \n",
       "39073         PL     2547                      TM - Swat   Peshawar   \n",
       "39074         PL     2547                      TM - Swat   Peshawar   \n",
       "39204         PL     3401                  Trade Officer        LHR   \n",
       "39205         PL     3401                  Trade Officer        LHR   \n",
       "39644         PL     2357                Turbine Officer        ISL   \n",
       "39656         PL     2406                Turbine Officer        ISL   \n",
       "39717         PL     3378     Veterinary Trainee Officer        KHI   \n",
       "39895        EPL     2478            Warehouse In Charge        KHI   \n",
       "39971         LW      318                  Works Manager     Quetta   \n",
       "\n",
       "        HEAD_OF_DEPARTMENT    BUSINESS                  DEPARTMENT  \\\n",
       "127                 Others  Business 5  Shared Services Accounting   \n",
       "167                 Others  Business 5                         SSD   \n",
       "360                 Others  Business 5     Shared Services Finance   \n",
       "1044           Aamir Jamil  Business 5  Shared Services Accounting   \n",
       "1257                Others  Business 5     Shared Services Finance   \n",
       "1288          Shamim Ahmed  Business 5     Shared Services Finance   \n",
       "1346                Others  Business 5     Shared Services Finance   \n",
       "1347                Others  Business 5     Shared Services Finance   \n",
       "1348                Others  Business 5     Shared Services Finance   \n",
       "1370          Shamim Ahmed  Business 5     Shared Services Finance   \n",
       "1371          Shamim Ahmed  Business 5     Shared Services Finance   \n",
       "1372          Shamim Ahmed  Business 5     Shared Services Finance   \n",
       "1373          Shamim Ahmed  Business 5     Shared Services Finance   \n",
       "1374          Shamim Ahmed  Business 5     Shared Services Finance   \n",
       "1375                Others  Business 5     Shared Services Finance   \n",
       "1377           Aamir Jamil  Business 5  Shared Services Accounting   \n",
       "1430                Others  Business 1              Administration   \n",
       "1431                Others  Business 1              Administration   \n",
       "1763                Others  Business 2              Administration   \n",
       "1764                Others  Business 2              Administration   \n",
       "2037         Anwaar Ul Haq  Business 7                  Commercial   \n",
       "2038                Others  Business 5      Information Technology   \n",
       "2095   Mahmood Ahmed. Awan  Business 6               Animal Health   \n",
       "2630                Others  Business 6               Animal Health   \n",
       "2631                Others  Business 6               Animal Health   \n",
       "2632                Others  Business 6               Animal Health   \n",
       "2651         Fahad Iqtidar  Business 3                 Agriculture   \n",
       "2749          Atif Mushtaq  Business 3                      Others   \n",
       "2799         Fahad Iqtidar  Business 3                      Others   \n",
       "2860         Anwaar Ul Haq  Business 6                      Others   \n",
       "...                    ...         ...                         ...   \n",
       "37336               Others  Business 3                      Others   \n",
       "37519        Imtiaz A Awan  Business 7               Animal Health   \n",
       "37529   Syed Saleem Akhtar  Business 6                      Others   \n",
       "37597               Others  Business 6               Animal Health   \n",
       "38356  Mahmood Ahmed. Awan  Business 6               Animal Health   \n",
       "38492        Fahad Iqtidar  Business 3                      Others   \n",
       "38540        Anwaar Ul Haq  Business 7                  Commercial   \n",
       "38552         Nadeem Abbas  Business 6                      Others   \n",
       "38553         Nadeem Abbas  Business 6                      Others   \n",
       "38554         Nadeem Abbas  Business 6                      Others   \n",
       "38602     Syed Arif Rajput  Business 6                      Others   \n",
       "38603     Syed Arif Rajput  Business 6                      Others   \n",
       "38691        Fahad Iqtidar  Business 3                      Others   \n",
       "38692        Fahad Iqtidar  Business 3                      Others   \n",
       "38737        Imtiaz A Awan  Business 4                  Commercial   \n",
       "38738        Imtiaz A Awan  Business 6                      Others   \n",
       "38739        Imtiaz A Awan  Business 6                      Others   \n",
       "38926               Others  Business 6               Animal Health   \n",
       "38927               Others  Business 6               Animal Health   \n",
       "39060           Irshad Ali  Business 7               Animal Health   \n",
       "39061           Irshad Ali  Business 7               Animal Health   \n",
       "39073               Others  Business 6                      Others   \n",
       "39074               Others  Business 6                      Others   \n",
       "39204    Syed Jawad Nagani  Business 3                      Others   \n",
       "39205    Syed Jawad Nagani  Business 3                      Others   \n",
       "39644               Others  Business 2                  Production   \n",
       "39656           Rehman Ali  Business 2                  Production   \n",
       "39717               Others  Business 6                      Others   \n",
       "39895          Razi Hassan  Business 6                Supply Chain   \n",
       "39971               Others  Business 1                  Operations   \n",
       "\n",
       "                            SUPERVISOR  S_Month  SEASON  TOTAL_NO_DAYS  \\\n",
       "127                       Shamim Ahmed        1       1              3   \n",
       "167                        Noman K Dar        1       1              1   \n",
       "360                       Shamim Ahmed        1       1              0   \n",
       "1044   Faizan Ahmed(Shared Accounting)        1       1              1   \n",
       "1257                          Saba Ali        2       1              0   \n",
       "1288                          Saba Ali        2       1              0   \n",
       "1346                       Noman K Dar        1       1              1   \n",
       "1347                       Noman K Dar        1       1              1   \n",
       "1348                       Noman K Dar        2       1              1   \n",
       "1370                          Saba Ali        1       1              0   \n",
       "1371                          Saba Ali        1       1              0   \n",
       "1372                          Saba Ali        1       1              0   \n",
       "1373                          Saba Ali        1       1              0   \n",
       "1374                          Saba Ali        2       1              0   \n",
       "1375                       Noman K Dar        1       1              0   \n",
       "1377   Faizan Ahmed(Shared Accounting)        1       1              1   \n",
       "1430                        Aqil Karim        1       1              1   \n",
       "1431                        Aqil Karim        2       1              1   \n",
       "1763                Ahmed Jamal Cheema        2       1              7   \n",
       "1764                Ahmed Jamal Cheema        2       1              4   \n",
       "2037               Muhamamd Umar Latif        1       1              1   \n",
       "2038                    Zain A Khawaja        1       1              1   \n",
       "2095                     Naeem Mustafa        1       1              1   \n",
       "2630                       Abdul Manan        1       1              1   \n",
       "2631                       Abdul Manan        1       1              1   \n",
       "2632                       Abdul Manan        2       1              1   \n",
       "2651                   Ghaffar Alizada        1       1              1   \n",
       "2749              Saleem Ahmed Alizada        1       1              0   \n",
       "2799                   Ghaffar Alizada        2       1              3   \n",
       "2860                       Zafar Iqbal        1       1              1   \n",
       "...                                ...      ...     ...            ...   \n",
       "37336           Muhammad Raheel Chhipa        1       1             21   \n",
       "37519                      Zaheer Saim        1       1              3   \n",
       "37529                     Qaisar Hanif        2       1              1   \n",
       "37597                    Naeem Mustafa        1       1              3   \n",
       "38356                      Masood Rana        1       1              1   \n",
       "38492                  Ghaffar Alizada        2       1              3   \n",
       "38540           Muhammad Junaid Arshad        1       1              1   \n",
       "38552                      Bilal Javed        1       1              0   \n",
       "38553                      Bilal Javed        1       1              0   \n",
       "38554                      Bilal Javed        1       1              1   \n",
       "38602                       Irshad Ali        1       1              1   \n",
       "38603                       Irshad Ali        1       1              4   \n",
       "38691                  Ghaffar Alizada        1       1              1   \n",
       "38692                  Ghaffar Alizada        1       1              1   \n",
       "38737                  Sajid Nawaz Ali        1       1              1   \n",
       "38738                  Sajid Nawaz Ali        1       1              3   \n",
       "38739                  Sajid Nawaz Ali        1       1              1   \n",
       "38926                   Liaqat Ali Ali        1       1              1   \n",
       "38927                   Liaqat Ali Ali        2       1              0   \n",
       "39060                    Saleem Bhutto        1       1              3   \n",
       "39061                    Saleem Bhutto        1       1              1   \n",
       "39073                   Liaqat Ali Ali        1       1              1   \n",
       "39074                   Liaqat Ali Ali        1       1              1   \n",
       "39204                      Noman Jafri        1       1              1   \n",
       "39205                      Noman Jafri        1       1              1   \n",
       "39644             Tanveer Ahmed Bhatti        1       1              4   \n",
       "39656             Tanveer Ahmed Bhatti        2       1              3   \n",
       "39717                    Anwaar Ul Haq        2       1              1   \n",
       "39895                   Muhammad Ilyas        2       1              3   \n",
       "39971                     Suhail A Ali        2       1              0   \n",
       "\n",
       "       LEAVE_STATUS_ID   BUSINESS_MANAGER  LEAVE_CODE  pred  \n",
       "127                  3       Umran Shahid        9012     1  \n",
       "167                  3         Syed Akram        9001     1  \n",
       "360                  8   Mehjabeen Batlay        9001     1  \n",
       "1044                 9        Yousaf Awan        9004     1  \n",
       "1257                 8       Umran Shahid        9001     4  \n",
       "1288                 9         Syed Akram        9001     1  \n",
       "1346                 8         Syed Akram        9001     5  \n",
       "1347                 8         Syed Akram        9001     5  \n",
       "1348                 8         Syed Akram        9001     2  \n",
       "1370                 9  Naureen Rodrigues        9001     1  \n",
       "1371                 9       Umran Shahid        9001     1  \n",
       "1372                 9  Naureen Rodrigues        9004     1  \n",
       "1373                 9        Shabbir Ali        9004     1  \n",
       "1374                 9        Shabbir Ali        9001     1  \n",
       "1375                 8  Naureen Rodrigues        9001     1  \n",
       "1377                 9       Umran Shahid        9001    16  \n",
       "1430                 3         Syed Akram        9001     1  \n",
       "1431                 8         Syed Akram        9001     1  \n",
       "1763                 3       Umran Shahid        9004     2  \n",
       "1764                 8   Dilnavaz Malbari        9001     2  \n",
       "2037                 8        Yousaf Awan        9012     5  \n",
       "2038                 8         Syed Akram        9011     8  \n",
       "2095                 8       Umran Shahid        9004     2  \n",
       "2630                 8       Umran Shahid        9001     3  \n",
       "2631                 8         Syed Akram        9010     3  \n",
       "2632                 8     Murial D Souza        9001     2  \n",
       "2651                 9         Syed Akram        9010     1  \n",
       "2749                 3  Naureen Rodrigues        9001     5  \n",
       "2799                 9         Syed Akram        9001     3  \n",
       "2860                 9  Naureen Rodrigues        9001     4  \n",
       "...                ...                ...         ...   ...  \n",
       "37336                3     Mamoona Ashfaq        9001     4  \n",
       "37519                9             Others        9001     4  \n",
       "37529                8    Shahana Murshad        9004     3  \n",
       "37597                8    Shahana Murshad        9010     2  \n",
       "38356                8       Nabia Akhtar        9001     3  \n",
       "38492                9       Umran Shahid        1111     3  \n",
       "38540                9  Naureen Rodrigues        9004     1  \n",
       "38552                8    Joanna D.Thomas        9001     1  \n",
       "38553                8       Nabia Akhtar        9001     1  \n",
       "38554                8       Sidra Saleem        9004     1  \n",
       "38602                9    Shahana Murshad        9001     3  \n",
       "38603                7  Naureen Rodrigues        9001     2  \n",
       "38691                9    Shahana Murshad        9001     3  \n",
       "38692                9    Shahana Murshad        9001     1  \n",
       "38737                3    Shahana Murshad        9001     1  \n",
       "38738                9       Umran Shahid        9001     2  \n",
       "38739                9       Umran Shahid        9001     1  \n",
       "38926                8    Shahana Murshad        9001     3  \n",
       "38927                8       Sidra Saleem        9010     3  \n",
       "39060                9       Sidra Saleem        9012     3  \n",
       "39061                9       Sidra Saleem        9012     3  \n",
       "39073                8    Shahana Murshad        9001     3  \n",
       "39074                8        Sana Idrees        9001     3  \n",
       "39204                9       Sidra Saleem        9001     4  \n",
       "39205                9    Shahana Murshad        9001     4  \n",
       "39644                3       Umran Shahid        9012     8  \n",
       "39656                3    Shahana Murshad        9001     4  \n",
       "39717                8    Mubashra Bukhsh        9001     3  \n",
       "39895                8    Shahana Murshad        9010     2  \n",
       "39971                3    Shahana Murshad        9001     4  \n",
       "\n",
       "[447 rows x 15 columns]"
      ]
     },
     "execution_count": 285,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1    310\n",
      "2    135\n",
      "3      2\n",
      "Name: S_Month, dtype: int64\n",
      "Business 1    137\n",
      "Business 6    108\n",
      "Business 2     69\n",
      "Business 3     65\n",
      "Business 5     47\n",
      "Business 7     13\n",
      "Business 4      8\n",
      "Name: BUSINESS, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(test['S_Month'].value_counts())\n",
    "print(test['BUSINESS'].value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 287,
   "metadata": {},
   "outputs": [],
   "source": [
    "month_breakdown = test.groupby('S_Month')[['TOTAL_NO_DAYS','pred']].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 288,
   "metadata": {},
   "outputs": [],
   "source": [
    "# agregating by monthly predicitons \n",
    "month_breakdown['accuracy'] = 100*(month_breakdown['TOTAL_NO_DAYS'] - abs(month_breakdown['TOTAL_NO_DAYS']- month_breakdown['pred']))/month_breakdown['TOTAL_NO_DAYS']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 289,
   "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>TOTAL_NO_DAYS</th>\n",
       "      <th>pred</th>\n",
       "      <th>accuracy</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>S_Month</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>732</td>\n",
       "      <td>803</td>\n",
       "      <td>90.300546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>381</td>\n",
       "      <td>372</td>\n",
       "      <td>97.637795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>21</td>\n",
       "      <td>7</td>\n",
       "      <td>33.333333</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         TOTAL_NO_DAYS  pred   accuracy\n",
       "S_Month                                \n",
       "1                  732   803  90.300546\n",
       "2                  381   372  97.637795\n",
       "3                   21     7  33.333333"
      ]
     },
     "execution_count": 289,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "month_breakdown"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 290,
   "metadata": {},
   "outputs": [],
   "source": [
    "# agregating business wise leaves prediciton\n",
    "business_breakdown = test.groupby('BUSINESS')[['TOTAL_NO_DAYS','pred']].sum()\n",
    "business_breakdown['accuracy'] = 100*(business_breakdown['TOTAL_NO_DAYS'] - abs(business_breakdown['TOTAL_NO_DAYS']- business_breakdown['pred']))/business_breakdown['TOTAL_NO_DAYS']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 291,
   "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>TOTAL_NO_DAYS</th>\n",
       "      <th>pred</th>\n",
       "      <th>accuracy</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BUSINESS</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Business 1</th>\n",
       "      <td>315</td>\n",
       "      <td>282</td>\n",
       "      <td>89.523810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 2</th>\n",
       "      <td>206</td>\n",
       "      <td>205</td>\n",
       "      <td>99.514563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 3</th>\n",
       "      <td>179</td>\n",
       "      <td>214</td>\n",
       "      <td>80.446927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 4</th>\n",
       "      <td>77</td>\n",
       "      <td>18</td>\n",
       "      <td>23.376623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 5</th>\n",
       "      <td>99</td>\n",
       "      <td>139</td>\n",
       "      <td>59.595960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 6</th>\n",
       "      <td>234</td>\n",
       "      <td>283</td>\n",
       "      <td>79.059829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 7</th>\n",
       "      <td>24</td>\n",
       "      <td>41</td>\n",
       "      <td>29.166667</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            TOTAL_NO_DAYS  pred   accuracy\n",
       "BUSINESS                                  \n",
       "Business 1            315   282  89.523810\n",
       "Business 2            206   205  99.514563\n",
       "Business 3            179   214  80.446927\n",
       "Business 4             77    18  23.376623\n",
       "Business 5             99   139  59.595960\n",
       "Business 6            234   283  79.059829\n",
       "Business 7             24    41  29.166667"
      ]
     },
     "execution_count": 291,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "business_breakdown"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 292,
   "metadata": {},
   "outputs": [],
   "source": [
    "# aggregatiing predictions department wise \n",
    "department_breakdown = test.groupby('DEPARTMENT')[['TOTAL_NO_DAYS','pred']].sum()\n",
    "department_breakdown['accuracy'] = 100*(department_breakdown['TOTAL_NO_DAYS'] - abs(department_breakdown['TOTAL_NO_DAYS']- department_breakdown['pred']))/department_breakdown['TOTAL_NO_DAYS']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 293,
   "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>TOTAL_NO_DAYS</th>\n",
       "      <th>pred</th>\n",
       "      <th>accuracy</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DEPARTMENT</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Administration</th>\n",
       "      <td>15</td>\n",
       "      <td>9</td>\n",
       "      <td>60.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Agriculture</th>\n",
       "      <td>56</td>\n",
       "      <td>47</td>\n",
       "      <td>83.928571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Animal Health</th>\n",
       "      <td>74</td>\n",
       "      <td>66</td>\n",
       "      <td>89.189189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 3</th>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>-100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemical</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemical &amp; Agri</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>75.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cirin Pharma</th>\n",
       "      <td>50</td>\n",
       "      <td>58</td>\n",
       "      <td>84.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Commercial</th>\n",
       "      <td>10</td>\n",
       "      <td>23</td>\n",
       "      <td>-30.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Engineering Electrical And Instrumentation</th>\n",
       "      <td>105</td>\n",
       "      <td>79</td>\n",
       "      <td>75.238095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finance</th>\n",
       "      <td>24</td>\n",
       "      <td>25</td>\n",
       "      <td>95.833333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Head Office</th>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>-400.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health &amp; Safety</th>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>15.789474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Human Resource</th>\n",
       "      <td>21</td>\n",
       "      <td>11</td>\n",
       "      <td>52.380952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Information Technology</th>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Marketing</th>\n",
       "      <td>102</td>\n",
       "      <td>60</td>\n",
       "      <td>58.823529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical</th>\n",
       "      <td>23</td>\n",
       "      <td>4</td>\n",
       "      <td>17.391304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Operations</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>-600.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Others</th>\n",
       "      <td>146</td>\n",
       "      <td>158</td>\n",
       "      <td>91.780822</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Peads &amp; Nutra</th>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>33.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pharmaceutical</th>\n",
       "      <td>26</td>\n",
       "      <td>23</td>\n",
       "      <td>88.461538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Power Generation</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Production</th>\n",
       "      <td>171</td>\n",
       "      <td>200</td>\n",
       "      <td>83.040936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Raw Material</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Reporting Group</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SSD</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Salary</th>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>-200.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sales</th>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>-inf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shared Services Accounting</th>\n",
       "      <td>13</td>\n",
       "      <td>27</td>\n",
       "      <td>-7.692308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shared Services Finance</th>\n",
       "      <td>6</td>\n",
       "      <td>29</td>\n",
       "      <td>-283.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shipping</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Supply Chain</th>\n",
       "      <td>64</td>\n",
       "      <td>52</td>\n",
       "      <td>81.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technical</th>\n",
       "      <td>129</td>\n",
       "      <td>160</td>\n",
       "      <td>75.968992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technical &amp; Enginearing</th>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>80.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wyeth Pakistan</th>\n",
       "      <td>11</td>\n",
       "      <td>44</td>\n",
       "      <td>-200.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            TOTAL_NO_DAYS  pred    accuracy\n",
       "DEPARTMENT                                                                 \n",
       "Administration                                         15     9   60.000000\n",
       "Agriculture                                            56    47   83.928571\n",
       "Animal Health                                          74    66   89.189189\n",
       "Business 3                                              2     6 -100.000000\n",
       "Chemical                                                1     2    0.000000\n",
       "Chemical & Agri                                         4     5   75.000000\n",
       "Cirin Pharma                                           50    58   84.000000\n",
       "Commercial                                             10    23  -30.000000\n",
       "Engineering Electrical And Instrumentation            105    79   75.238095\n",
       "Finance                                                24    25   95.833333\n",
       "Head Office                                             2    12 -400.000000\n",
       "Health & Safety                                        19     3   15.789474\n",
       "Human Resource                                         21    11   52.380952\n",
       "Information Technology                                 27    27  100.000000\n",
       "Marketing                                             102    60   58.823529\n",
       "Medical                                                23     4   17.391304\n",
       "Operations                                              1     8 -600.000000\n",
       "Others                                                146   158   91.780822\n",
       "Peads & Nutra                                           9     3   33.333333\n",
       "Pharmaceutical                                         26    23   88.461538\n",
       "Power Generation                                        3     3  100.000000\n",
       "Production                                            171   200   83.040936\n",
       "Raw Material                                            1     1  100.000000\n",
       "Reporting Group                                         3     3  100.000000\n",
       "SSD                                                     1     1  100.000000\n",
       "Salary                                                  2     8 -200.000000\n",
       "Sales                                                   0    11        -inf\n",
       "Shared Services Accounting                             13    27   -7.692308\n",
       "Shared Services Finance                                 6    29 -283.333333\n",
       "Shipping                                                3     6    0.000000\n",
       "Supply Chain                                           64    52   81.250000\n",
       "Technical                                             129   160   75.968992\n",
       "Technical & Enginearing                                10     8   80.000000\n",
       "Wyeth Pakistan                                         11    44 -200.000000"
      ]
     },
     "execution_count": 293,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "department_breakdown"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 294,
   "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>TOTAL_NO_DAYS</th>\n",
       "      <th>pred</th>\n",
       "      <th>accuracy</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LEAVE_TYPE</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>EPL</th>\n",
       "      <td>30</td>\n",
       "      <td>32</td>\n",
       "      <td>93.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LR</th>\n",
       "      <td>19</td>\n",
       "      <td>9</td>\n",
       "      <td>47.368421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LW</th>\n",
       "      <td>35</td>\n",
       "      <td>42</td>\n",
       "      <td>80.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAL</th>\n",
       "      <td>29</td>\n",
       "      <td>25</td>\n",
       "      <td>86.206897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PL</th>\n",
       "      <td>892</td>\n",
       "      <td>916</td>\n",
       "      <td>97.309417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SL</th>\n",
       "      <td>122</td>\n",
       "      <td>153</td>\n",
       "      <td>74.590164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TL</th>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>71.428571</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            TOTAL_NO_DAYS  pred   accuracy\n",
       "LEAVE_TYPE                                \n",
       "EPL                    30    32  93.333333\n",
       "LR                     19     9  47.368421\n",
       "LW                     35    42  80.000000\n",
       "PAL                    29    25  86.206897\n",
       "PL                    892   916  97.309417\n",
       "SL                    122   153  74.590164\n",
       "TL                      7     5  71.428571"
      ]
     },
     "execution_count": 294,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# aggregatiing predictions by leave types \n",
    "\n",
    "lt_breakdown = test.groupby('LEAVE_TYPE')[['TOTAL_NO_DAYS','pred']].sum()\n",
    "lt_breakdown['accuracy'] = 100*(lt_breakdown['TOTAL_NO_DAYS'] - abs(lt_breakdown['TOTAL_NO_DAYS']- lt_breakdown['pred']))/lt_breakdown['TOTAL_NO_DAYS']\n",
    "lt_breakdown"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 295,
   "metadata": {},
   "outputs": [],
   "source": [
    "# splitting all these breakdowns month wise\n",
    "\n",
    "business = test.groupby(['S_Month','BUSINESS'])[['TOTAL_NO_DAYS','pred']].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 296,
   "metadata": {},
   "outputs": [],
   "source": [
    "leave_type = test.groupby(['S_Month','LEAVE_TYPE'])[['TOTAL_NO_DAYS','pred']].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 297,
   "metadata": {},
   "outputs": [],
   "source": [
    "dept = test.groupby(['S_Month','DEPARTMENT'])[['TOTAL_NO_DAYS','pred']].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 298,
   "metadata": {},
   "outputs": [],
   "source": [
    "month = month_breakdown"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 299,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>TOTAL_NO_DAYS</th>\n",
       "      <th>pred</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>S_Month</th>\n",
       "      <th>BUSINESS</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">1</th>\n",
       "      <th>Business 1</th>\n",
       "      <td>258</td>\n",
       "      <td>214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 2</th>\n",
       "      <td>97</td>\n",
       "      <td>115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 3</th>\n",
       "      <td>107</td>\n",
       "      <td>151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 4</th>\n",
       "      <td>34</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 5</th>\n",
       "      <td>70</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 6</th>\n",
       "      <td>147</td>\n",
       "      <td>183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 7</th>\n",
       "      <td>19</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">2</th>\n",
       "      <th>Business 1</th>\n",
       "      <td>57</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 2</th>\n",
       "      <td>88</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 3</th>\n",
       "      <td>72</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 4</th>\n",
       "      <td>43</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 5</th>\n",
       "      <td>29</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 6</th>\n",
       "      <td>87</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 7</th>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <th>Business 2</th>\n",
       "      <td>21</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    TOTAL_NO_DAYS  pred\n",
       "S_Month BUSINESS                       \n",
       "1       Business 1            258   214\n",
       "        Business 2             97   115\n",
       "        Business 3            107   151\n",
       "        Business 4             34     9\n",
       "        Business 5             70   100\n",
       "        Business 6            147   183\n",
       "        Business 7             19    31\n",
       "2       Business 1             57    68\n",
       "        Business 2             88    83\n",
       "        Business 3             72    63\n",
       "        Business 4             43     9\n",
       "        Business 5             29    39\n",
       "        Business 6             87   100\n",
       "        Business 7              5    10\n",
       "3       Business 2             21     7"
      ]
     },
     "execution_count": 299,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "business"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 300,
   "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>TOTAL_NO_DAYS</th>\n",
       "      <th>pred</th>\n",
       "      <th>accuracy</th>\n",
       "      <th>difference</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>S_Month</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>732</td>\n",
       "      <td>803</td>\n",
       "      <td>90.300546</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>381</td>\n",
       "      <td>372</td>\n",
       "      <td>97.637795</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>21</td>\n",
       "      <td>7</td>\n",
       "      <td>33.333333</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         TOTAL_NO_DAYS  pred   accuracy  difference\n",
       "S_Month                                            \n",
       "1                  732   803  90.300546          71\n",
       "2                  381   372  97.637795           9\n",
       "3                   21     7  33.333333          14"
      ]
     },
     "execution_count": 300,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "month['difference'] = abs(month['TOTAL_NO_DAYS']-month['pred'])\n",
    "month\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 301,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>TOTAL_NO_DAYS</th>\n",
       "      <th>pred</th>\n",
       "      <th>difference</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>S_Month</th>\n",
       "      <th>DEPARTMENT</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">1</th>\n",
       "      <th>Administration</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Agriculture</th>\n",
       "      <td>37</td>\n",
       "      <td>29</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Animal Health</th>\n",
       "      <td>64</td>\n",
       "      <td>52</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Business 3</th>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemical &amp; Agri</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cirin Pharma</th>\n",
       "      <td>32</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Commercial</th>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Engineering Electrical And Instrumentation</th>\n",
       "      <td>74</td>\n",
       "      <td>57</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finance</th>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Head Office</th>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health &amp; Safety</th>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Human Resource</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Information Technology</th>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Marketing</th>\n",
       "      <td>11</td>\n",
       "      <td>25</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical</th>\n",
       "      <td>23</td>\n",
       "      <td>4</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Others</th>\n",
       "      <td>94</td>\n",
       "      <td>124</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Peads &amp; Nutra</th>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pharmaceutical</th>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Production</th>\n",
       "      <td>115</td>\n",
       "      <td>144</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Raw Material</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SSD</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Salary</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sales</th>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shared Services Accounting</th>\n",
       "      <td>13</td>\n",
       "      <td>27</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shared Services Finance</th>\n",
       "      <td>3</td>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shipping</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Supply Chain</th>\n",
       "      <td>53</td>\n",
       "      <td>37</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technical</th>\n",
       "      <td>102</td>\n",
       "      <td>108</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technical &amp; Enginearing</th>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wyeth Pakistan</th>\n",
       "      <td>6</td>\n",
       "      <td>29</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"25\" valign=\"top\">2</th>\n",
       "      <th>Administration</th>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Agriculture</th>\n",
       "      <td>19</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Animal Health</th>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemical</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cirin Pharma</th>\n",
       "      <td>18</td>\n",
       "      <td>27</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Commercial</th>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Engineering Electrical And Instrumentation</th>\n",
       "      <td>31</td>\n",
       "      <td>22</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finance</th>\n",
       "      <td>7</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Head Office</th>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Human Resource</th>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Information Technology</th>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Marketing</th>\n",
       "      <td>76</td>\n",
       "      <td>31</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Operations</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Others</th>\n",
       "      <td>52</td>\n",
       "      <td>34</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pharmaceutical</th>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Power Generation</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Production</th>\n",
       "      <td>50</td>\n",
       "      <td>53</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Reporting Group</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Salary</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shared Services Finance</th>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shipping</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Supply Chain</th>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technical</th>\n",
       "      <td>27</td>\n",
       "      <td>52</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technical &amp; Enginearing</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wyeth Pakistan</th>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">3</th>\n",
       "      <th>Marketing</th>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Production</th>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    TOTAL_NO_DAYS  pred  \\\n",
       "S_Month DEPARTMENT                                                        \n",
       "1       Administration                                          3     4   \n",
       "        Agriculture                                            37    29   \n",
       "        Animal Health                                          64    52   \n",
       "        Business 3                                              2     6   \n",
       "        Chemical & Agri                                         4     5   \n",
       "        Cirin Pharma                                           32    31   \n",
       "        Commercial                                              8    16   \n",
       "        Engineering Electrical And Instrumentation             74    57   \n",
       "        Finance                                                17    11   \n",
       "        Head Office                                             1     6   \n",
       "        Health & Safety                                        19     3   \n",
       "        Human Resource                                          8     8   \n",
       "        Information Technology                                  7    17   \n",
       "        Marketing                                              11    25   \n",
       "        Medical                                                23     4   \n",
       "        Others                                                 94   124   \n",
       "        Peads & Nutra                                           9     3   \n",
       "        Pharmaceutical                                         12    13   \n",
       "        Production                                            115   144   \n",
       "        Raw Material                                            1     1   \n",
       "        SSD                                                     1     1   \n",
       "        Salary                                                  1     4   \n",
       "        Sales                                                   0    11   \n",
       "        Shared Services Accounting                             13    27   \n",
       "        Shared Services Finance                                 3    18   \n",
       "        Shipping                                                3     4   \n",
       "        Supply Chain                                           53    37   \n",
       "        Technical                                             102   108   \n",
       "        Technical & Enginearing                                 9     5   \n",
       "        Wyeth Pakistan                                          6    29   \n",
       "2       Administration                                         12     5   \n",
       "        Agriculture                                            19    18   \n",
       "        Animal Health                                          10    14   \n",
       "        Chemical                                                1     2   \n",
       "        Cirin Pharma                                           18    27   \n",
       "        Commercial                                              2     7   \n",
       "        Engineering Electrical And Instrumentation             31    22   \n",
       "        Finance                                                 7    14   \n",
       "        Head Office                                             1     6   \n",
       "        Human Resource                                         13     3   \n",
       "        Information Technology                                 20    10   \n",
       "        Marketing                                              76    31   \n",
       "        Operations                                              1     8   \n",
       "        Others                                                 52    34   \n",
       "        Pharmaceutical                                         14    10   \n",
       "        Power Generation                                        3     3   \n",
       "        Production                                             50    53   \n",
       "        Reporting Group                                         3     3   \n",
       "        Salary                                                  1     4   \n",
       "        Shared Services Finance                                 3    11   \n",
       "        Shipping                                                0     2   \n",
       "        Supply Chain                                           11    15   \n",
       "        Technical                                              27    52   \n",
       "        Technical & Enginearing                                 1     3   \n",
       "        Wyeth Pakistan                                          5    15   \n",
       "3       Marketing                                              15     4   \n",
       "        Production                                              6     3   \n",
       "\n",
       "                                                    difference  \n",
       "S_Month DEPARTMENT                                              \n",
       "1       Administration                                       1  \n",
       "        Agriculture                                          8  \n",
       "        Animal Health                                       12  \n",
       "        Business 3                                           4  \n",
       "        Chemical & Agri                                      1  \n",
       "        Cirin Pharma                                         1  \n",
       "        Commercial                                           8  \n",
       "        Engineering Electrical And Instrumentation          17  \n",
       "        Finance                                              6  \n",
       "        Head Office                                          5  \n",
       "        Health & Safety                                     16  \n",
       "        Human Resource                                       0  \n",
       "        Information Technology                              10  \n",
       "        Marketing                                           14  \n",
       "        Medical                                             19  \n",
       "        Others                                              30  \n",
       "        Peads & Nutra                                        6  \n",
       "        Pharmaceutical                                       1  \n",
       "        Production                                          29  \n",
       "        Raw Material                                         0  \n",
       "        SSD                                                  0  \n",
       "        Salary                                               3  \n",
       "        Sales                                               11  \n",
       "        Shared Services Accounting                          14  \n",
       "        Shared Services Finance                             15  \n",
       "        Shipping                                             1  \n",
       "        Supply Chain                                        16  \n",
       "        Technical                                            6  \n",
       "        Technical & Enginearing                              4  \n",
       "        Wyeth Pakistan                                      23  \n",
       "2       Administration                                       7  \n",
       "        Agriculture                                          1  \n",
       "        Animal Health                                        4  \n",
       "        Chemical                                             1  \n",
       "        Cirin Pharma                                         9  \n",
       "        Commercial                                           5  \n",
       "        Engineering Electrical And Instrumentation           9  \n",
       "        Finance                                              7  \n",
       "        Head Office                                          5  \n",
       "        Human Resource                                      10  \n",
       "        Information Technology                              10  \n",
       "        Marketing                                           45  \n",
       "        Operations                                           7  \n",
       "        Others                                              18  \n",
       "        Pharmaceutical                                       4  \n",
       "        Power Generation                                     0  \n",
       "        Production                                           3  \n",
       "        Reporting Group                                      0  \n",
       "        Salary                                               3  \n",
       "        Shared Services Finance                              8  \n",
       "        Shipping                                             2  \n",
       "        Supply Chain                                         4  \n",
       "        Technical                                           25  \n",
       "        Technical & Enginearing                              2  \n",
       "        Wyeth Pakistan                                      10  \n",
       "3       Marketing                                           11  \n",
       "        Production                                           3  "
      ]
     },
     "execution_count": 301,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dept['difference'] = abs(dept['TOTAL_NO_DAYS']-dept['pred'])\n",
    "dept"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 305,
   "metadata": {},
   "outputs": [],
   "source": [
    "leave_type.to_csv('C:\\\\Users\\\\binary\\\\Downloads\\\\leave_type_leaves.csv')"
   ]
  },
  {
   "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.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}