Clean and Analyze Employee Exit Survey.ipynb

{
 "metadata": {
  "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.9.2-final"
  },
  "orig_nbformat": 2,
  "kernelspec": {
   "name": "python392jvsc74a57bd042ffdba7f0de544957ef69efdb450b60517fb3f2f7c6065358c1f9d2622fefe6",
   "display_name": "Python 3.9.2 64-bit"
  },
  "metadata": {
   "interpreter": {
    "hash": "42ffdba7f0de544957ef69efdb450b60517fb3f2f7c6065358c1f9d2622fefe6"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2,
 "cells": [
  {
   "source": [
    "# Clean and Analyze Employee Exit Survey\n",
    "This project is aimed to analyze exit surveys from employees of the Department of Education, Training and Employment (\"DETE\") and the Technical and Further Education (\"TAFE\") institute in Queensland, Australia. The data are taken from <a href=\"https://data.gov.au/dataset/ds-qld-fe96ff30-d157-4a81-851d-215f2a0fe26d/details?q=exit%20survey\">here</a> and <a href=\"https://data.gov.au/dataset/ds-qld-89970a3b-182b-41ea-aea2-6f9f17b5907e/details?q=exit%20survey\">here</a>, respectively.\n",
    "\n",
    "The analysis will answer the following questions:\n",
    "\n",
    "- Are employees who only worked for the institutes for a short period of time resigning due to some kind of dissatisfaction? What about employees who have been there longer?\n",
    "- Are younger employees resigning due to some kind of dissatisfaction? What about older employees?"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "source": [
    "## Get to know the data"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "<_io.TextIOWrapper name='D:\\\\Documents\\\\Python Journey\\\\Dataquest\\\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\\\dete-exit-survey-january-2014.csv' mode='r' encoding='cp1252'>\n<_io.TextIOWrapper name='D:\\\\Documents\\\\Python Journey\\\\Dataquest\\\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\\\tafe-employee-exit-survey-access-database-december-2013.csv' mode='r' encoding='cp1252'>\n"
     ]
    }
   ],
   "source": [
    "# Check encoding of each file\n",
    "\n",
    "with open('D:\\Documents\\Python Journey\\Dataquest\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\dete-exit-survey-january-2014.csv') as dete:\n",
    "    print(dete)\n",
    "    \n",
    "\n",
    "with open('D:\\Documents\\Python Journey\\Dataquest\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\\\tafe-employee-exit-survey-access-database-december-2013.csv') as tafe:\n",
    "    print(tafe)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Convert to UTF-8 encoding and save to new files\n",
    "\n",
    "dete_raw = pd.read_csv(\"D:\\Documents\\Python Journey\\Dataquest\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\dete-exit-survey-january-2014.csv\", encoding=\"cp1252\")\n",
    "dete_raw.to_csv(\"D:\\Documents\\Python Journey\\Dataquest\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\dete-exit-survey-january-2014_utf8.csv\", encoding=\"utf-8\", index=False)\n",
    "\n",
    "tafe_raw = pd.read_csv(\"D:\\Documents\\Python Journey\\Dataquest\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\\\tafe-employee-exit-survey-access-database-december-2013.csv\",  encoding=\"cp1252\")\n",
    "tafe_raw.to_csv(\"D:\\Documents\\Python Journey\\Dataquest\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\\\tafe-employee-exit-survey-access-database-december-2013_utf8.csv\",  encoding=\"utf-8\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read new files\n",
    "\n",
    "dete_survey = pd.read_csv(\"D:\\Documents\\Python Journey\\Dataquest\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\dete-exit-survey-january-2014_utf8.csv\")\n",
    "\n",
    "tafe_survey = pd.read_csv(\"D:\\Documents\\Python Journey\\Dataquest\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\\\tafe-employee-exit-survey-access-database-december-2013_utf8.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\nRangeIndex: 822 entries, 0 to 821\nData columns (total 56 columns):\n #   Column                               Non-Null Count  Dtype \n---  ------                               --------------  ----- \n 0   ID                                   822 non-null    int64 \n 1   SeparationType                       822 non-null    object\n 2   Cease Date                           822 non-null    object\n 3   DETE Start Date                      822 non-null    object\n 4   Role Start Date                      822 non-null    object\n 5   Position                             817 non-null    object\n 6   Classification                       455 non-null    object\n 7   Region                               822 non-null    object\n 8   Business Unit                        126 non-null    object\n 9   Employment Status                    817 non-null    object\n 10  Career move to public sector         822 non-null    bool  \n 11  Career move to private sector        822 non-null    bool  \n 12  Interpersonal conflicts              822 non-null    bool  \n 13  Job dissatisfaction                  822 non-null    bool  \n 14  Dissatisfaction with the department  822 non-null    bool  \n 15  Physical work environment            822 non-null    bool  \n 16  Lack of recognition                  822 non-null    bool  \n 17  Lack of job security                 822 non-null    bool  \n 18  Work location                        822 non-null    bool  \n 19  Employment conditions                822 non-null    bool  \n 20  Maternity/family                     822 non-null    bool  \n 21  Relocation                           822 non-null    bool  \n 22  Study/Travel                         822 non-null    bool  \n 23  Ill Health                           822 non-null    bool  \n 24  Traumatic incident                   822 non-null    bool  \n 25  Work life balance                    822 non-null    bool  \n 26  Workload                             822 non-null    bool  \n 27  None of the above                    822 non-null    bool  \n 28  Professional Development             808 non-null    object\n 29  Opportunities for promotion          735 non-null    object\n 30  Staff morale                         816 non-null    object\n 31  Workplace issue                      788 non-null    object\n 32  Physical environment                 817 non-null    object\n 33  Worklife balance                     815 non-null    object\n 34  Stress and pressure support          810 non-null    object\n 35  Performance of supervisor            813 non-null    object\n 36  Peer support                         812 non-null    object\n 37  Initiative                           813 non-null    object\n 38  Skills                               811 non-null    object\n 39  Coach                                767 non-null    object\n 40  Career Aspirations                   746 non-null    object\n 41  Feedback                             792 non-null    object\n 42  Further PD                           768 non-null    object\n 43  Communication                        814 non-null    object\n 44  My say                               812 non-null    object\n 45  Information                          816 non-null    object\n 46  Kept informed                        813 non-null    object\n 47  Wellness programs                    766 non-null    object\n 48  Health & Safety                      793 non-null    object\n 49  Gender                               798 non-null    object\n 50  Age                                  811 non-null    object\n 51  Aboriginal                           16 non-null     object\n 52  Torres Strait                        3 non-null      object\n 53  South Sea                            7 non-null      object\n 54  Disability                           23 non-null     object\n 55  NESB                                 32 non-null     object\ndtypes: bool(18), int64(1), object(37)\nmemory usage: 258.6+ KB\n"
     ]
    }
   ],
   "source": [
    "# DETE survey\n",
    "\n",
    "dete_survey.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "   ID                    SeparationType Cease Date DETE Start Date  \\\n",
       "0   1             Ill Health Retirement    08/2012            1984   \n",
       "1   2  Voluntary Early Retirement (VER)    08/2012      Not Stated   \n",
       "2   3  Voluntary Early Retirement (VER)    05/2012            2011   \n",
       "3   4         Resignation-Other reasons    05/2012            2005   \n",
       "4   5                    Age Retirement    05/2012            1970   \n",
       "\n",
       "  Role Start Date                                      Position  \\\n",
       "0            2004                                Public Servant   \n",
       "1      Not Stated                                Public Servant   \n",
       "2            2011                               Schools Officer   \n",
       "3            2006                                       Teacher   \n",
       "4            1989  Head of Curriculum/Head of Special Education   \n",
       "\n",
       "  Classification              Region                      Business Unit  \\\n",
       "0        A01-A04      Central Office  Corporate Strategy and Peformance   \n",
       "1        AO5-AO7      Central Office  Corporate Strategy and Peformance   \n",
       "2            NaN      Central Office               Education Queensland   \n",
       "3        Primary  Central Queensland                                NaN   \n",
       "4            NaN          South East                                NaN   \n",
       "\n",
       "     Employment Status  ...  Kept informed  Wellness programs  \\\n",
       "0  Permanent Full-time  ...              N                  N   \n",
       "1  Permanent Full-time  ...              N                  N   \n",
       "2  Permanent Full-time  ...              N                  N   \n",
       "3  Permanent Full-time  ...              A                  N   \n",
       "4  Permanent Full-time  ...              N                  A   \n",
       "\n",
       "   Health & Safety  Gender          Age  Aboriginal  Torres Strait  South Sea  \\\n",
       "0                N    Male        56-60         NaN            NaN        NaN   \n",
       "1                N    Male        56-60         NaN            NaN        NaN   \n",
       "2                N    Male  61 or older         NaN            NaN        NaN   \n",
       "3                A  Female        36-40         NaN            NaN        NaN   \n",
       "4                M  Female  61 or older         NaN            NaN        NaN   \n",
       "\n",
       "   Disability  NESB  \n",
       "0         NaN   Yes  \n",
       "1         NaN   NaN  \n",
       "2         NaN   NaN  \n",
       "3         NaN   NaN  \n",
       "4         NaN   NaN  \n",
       "\n",
       "[5 rows x 56 columns]"
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>ID</th>\n      <th>SeparationType</th>\n      <th>Cease Date</th>\n      <th>DETE Start Date</th>\n      <th>Role Start Date</th>\n      <th>Position</th>\n      <th>Classification</th>\n      <th>Region</th>\n      <th>Business Unit</th>\n      <th>Employment Status</th>\n      <th>...</th>\n      <th>Kept informed</th>\n      <th>Wellness programs</th>\n      <th>Health &amp; Safety</th>\n      <th>Gender</th>\n      <th>Age</th>\n      <th>Aboriginal</th>\n      <th>Torres Strait</th>\n      <th>South Sea</th>\n      <th>Disability</th>\n      <th>NESB</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1</td>\n      <td>Ill Health Retirement</td>\n      <td>08/2012</td>\n      <td>1984</td>\n      <td>2004</td>\n      <td>Public Servant</td>\n      <td>A01-A04</td>\n      <td>Central Office</td>\n      <td>Corporate Strategy and Peformance</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>N</td>\n      <td>N</td>\n      <td>N</td>\n      <td>Male</td>\n      <td>56-60</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Yes</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>2</td>\n      <td>Voluntary Early Retirement (VER)</td>\n      <td>08/2012</td>\n      <td>Not Stated</td>\n      <td>Not Stated</td>\n      <td>Public Servant</td>\n      <td>AO5-AO7</td>\n      <td>Central Office</td>\n      <td>Corporate Strategy and Peformance</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>N</td>\n      <td>N</td>\n      <td>N</td>\n      <td>Male</td>\n      <td>56-60</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>3</td>\n      <td>Voluntary Early Retirement (VER)</td>\n      <td>05/2012</td>\n      <td>2011</td>\n      <td>2011</td>\n      <td>Schools Officer</td>\n      <td>NaN</td>\n      <td>Central Office</td>\n      <td>Education Queensland</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>N</td>\n      <td>N</td>\n      <td>N</td>\n      <td>Male</td>\n      <td>61 or older</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>4</td>\n      <td>Resignation-Other reasons</td>\n      <td>05/2012</td>\n      <td>2005</td>\n      <td>2006</td>\n      <td>Teacher</td>\n      <td>Primary</td>\n      <td>Central Queensland</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>A</td>\n      <td>N</td>\n      <td>A</td>\n      <td>Female</td>\n      <td>36-40</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>5</td>\n      <td>Age Retirement</td>\n      <td>05/2012</td>\n      <td>1970</td>\n      <td>1989</td>\n      <td>Head of Curriculum/Head of Special Education</td>\n      <td>NaN</td>\n      <td>South East</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>N</td>\n      <td>A</td>\n      <td>M</td>\n      <td>Female</td>\n      <td>61 or older</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows × 56 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 6
    }
   ],
   "source": [
    "dete_survey.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\nRangeIndex: 702 entries, 0 to 701\nData columns (total 72 columns):\n #   Column                                                                                                                                                         Non-Null Count  Dtype  \n---  ------                                                                                                                                                         --------------  -----  \n 0   Record ID                                                                                                                                                      702 non-null    int64  \n 1   Institute                                                                                                                                                      702 non-null    object \n 2   WorkArea                                                                                                                                                       702 non-null    object \n 3   CESSATION YEAR                                                                                                                                                 695 non-null    float64\n 4   Reason for ceasing employment                                                                                                                                  701 non-null    object \n 5   Contributing Factors. Career Move - Public Sector                                                                                                              437 non-null    object \n 6   Contributing Factors. Career Move - Private Sector                                                                                                             437 non-null    object \n 7   Contributing Factors. Career Move - Self-employment                                                                                                            437 non-null    object \n 8   Contributing Factors. Ill Health                                                                                                                               437 non-null    object \n 9   Contributing Factors. Maternity/Family                                                                                                                         437 non-null    object \n 10  Contributing Factors. Dissatisfaction                                                                                                                          437 non-null    object \n 11  Contributing Factors. Job Dissatisfaction                                                                                                                      437 non-null    object \n 12  Contributing Factors. Interpersonal Conflict                                                                                                                   437 non-null    object \n 13  Contributing Factors. Study                                                                                                                                    437 non-null    object \n 14  Contributing Factors. Travel                                                                                                                                   437 non-null    object \n 15  Contributing Factors. Other                                                                                                                                    437 non-null    object \n 16  Contributing Factors. NONE                                                                                                                                     437 non-null    object \n 17  Main Factor.     Which of these was the main factor for leaving?                                                                                               113 non-null    object \n 18  InstituteViews. Topic:1. I feel the senior leadership had a clear vision and direction                                                                         608 non-null    object \n 19  InstituteViews. Topic:2. I was given access to skills training to help me do my job better                                                                     613 non-null    object \n 20  InstituteViews. Topic:3. I was given adequate opportunities for personal development                                                                           610 non-null    object \n 21  InstituteViews. Topic:4. I was given adequate opportunities for promotion within %Institute]Q25LBL%                                                            608 non-null    object \n 22  InstituteViews. Topic:5. I felt the salary for the job was right for the responsibilities I had                                                                615 non-null    object \n 23  InstituteViews. Topic:6. The organisation recognised when staff did good work                                                                                  607 non-null    object \n 24  InstituteViews. Topic:7. Management was generally supportive of me                                                                                             614 non-null    object \n 25  InstituteViews. Topic:8. Management was generally supportive of my team                                                                                        608 non-null    object \n 26  InstituteViews. Topic:9. I was kept informed of the changes in the organisation which would affect me                                                          610 non-null    object \n 27  InstituteViews. Topic:10. Staff morale was positive within the Institute                                                                                       602 non-null    object \n 28  InstituteViews. Topic:11. If I had a workplace issue it was dealt with quickly                                                                                 601 non-null    object \n 29  InstituteViews. Topic:12. If I had a workplace issue it was dealt with efficiently                                                                             597 non-null    object \n 30  InstituteViews. Topic:13. If I had a workplace issue it was dealt with discreetly                                                                              601 non-null    object \n 31  WorkUnitViews. Topic:14. I was satisfied with the quality of the management and supervision within my work unit                                                609 non-null    object \n 32  WorkUnitViews. Topic:15. I worked well with my colleagues                                                                                                      605 non-null    object \n 33  WorkUnitViews. Topic:16. My job was challenging and interesting                                                                                                607 non-null    object \n 34  WorkUnitViews. Topic:17. I was encouraged to use my initiative in the course of my work                                                                        610 non-null    object \n 35  WorkUnitViews. Topic:18. I had sufficient contact with other people in my job                                                                                  613 non-null    object \n 36  WorkUnitViews. Topic:19. I was given adequate support and co-operation by my peers to enable me to do my job                                                   609 non-null    object \n 37  WorkUnitViews. Topic:20. I was able to use the full range of my skills in my job                                                                               609 non-null    object \n 38  WorkUnitViews. Topic:21. I was able to use the full range of my abilities in my job. ; Category:Level of Agreement; Question:YOUR VIEWS ABOUT YOUR WORK UNIT]  608 non-null    object \n 39  WorkUnitViews. Topic:22. I was able to use the full range of my knowledge in my job                                                                            608 non-null    object \n 40  WorkUnitViews. Topic:23. My job provided sufficient variety                                                                                                    611 non-null    object \n 41  WorkUnitViews. Topic:24. I was able to cope with the level of stress and pressure in my job                                                                    610 non-null    object \n 42  WorkUnitViews. Topic:25. My job allowed me to balance the demands of work and family to my satisfaction                                                        611 non-null    object \n 43  WorkUnitViews. Topic:26. My supervisor gave me adequate personal recognition and feedback on my performance                                                    606 non-null    object \n 44  WorkUnitViews. Topic:27. My working environment was satisfactory e.g. sufficient space, good lighting, suitable seating and working area                       610 non-null    object \n 45  WorkUnitViews. Topic:28. I was given the opportunity to mentor and coach others in order for me to pass on my skills and knowledge prior to my cessation date  609 non-null    object \n 46  WorkUnitViews. Topic:29. There was adequate communication between staff in my unit                                                                             603 non-null    object \n 47  WorkUnitViews. Topic:30. Staff morale was positive within my work unit                                                                                         606 non-null    object \n 48  Induction. Did you undertake Workplace Induction?                                                                                                              619 non-null    object \n 49  InductionInfo. Topic:Did you undertake a Corporate Induction?                                                                                                  432 non-null    object \n 50  InductionInfo. Topic:Did you undertake a Institute Induction?                                                                                                  483 non-null    object \n 51  InductionInfo. Topic: Did you undertake Team Induction?                                                                                                        440 non-null    object \n 52  InductionInfo. Face to Face Topic:Did you undertake a Corporate Induction; Category:How it was conducted?                                                      555 non-null    object \n 53  InductionInfo. On-line Topic:Did you undertake a Corporate Induction; Category:How it was conducted?                                                           555 non-null    object \n 54  InductionInfo. Induction Manual Topic:Did you undertake a Corporate Induction?                                                                                 555 non-null    object \n 55  InductionInfo. Face to Face Topic:Did you undertake a Institute Induction?                                                                                     530 non-null    object \n 56  InductionInfo. On-line Topic:Did you undertake a Institute Induction?                                                                                          555 non-null    object \n 57  InductionInfo. Induction Manual Topic:Did you undertake a Institute Induction?                                                                                 553 non-null    object \n 58  InductionInfo. Face to Face Topic: Did you undertake Team Induction; Category?                                                                                 555 non-null    object \n 59  InductionInfo. On-line Topic: Did you undertake Team Induction?process you undertook and how it was conducted.]                                                555 non-null    object \n 60  InductionInfo. Induction Manual Topic: Did you undertake Team Induction?                                                                                       555 non-null    object \n 61  Workplace. Topic:Did you and your Manager develop a Performance and Professional Development Plan (PPDP)?                                                      608 non-null    object \n 62  Workplace. Topic:Does your workplace promote a work culture free from all forms of unlawful discrimination?                                                    594 non-null    object \n 63  Workplace. Topic:Does your workplace promote and practice the principles of employment equity?                                                                 587 non-null    object \n 64  Workplace. Topic:Does your workplace value the diversity of its employees?                                                                                     586 non-null    object \n 65  Workplace. Topic:Would you recommend the Institute as an employer to others?                                                                                   581 non-null    object \n 66  Gender.     What is your Gender?                                                                                                                               596 non-null    object \n 67  CurrentAge.     Current Age                                                                                                                                    596 non-null    object \n 68  Employment Type.     Employment Type                                                                                                                           596 non-null    object \n 69  Classification.     Classification                                                                                                                             596 non-null    object \n 70  LengthofServiceOverall. Overall Length of Service at Institute (in years)                                                                                      596 non-null    object \n 71  LengthofServiceCurrent. Length of Service at current workplace (in years)                                                                                      596 non-null    object \ndtypes: float64(1), int64(1), object(70)\nmemory usage: 395.0+ KB\n"
     ]
    }
   ],
   "source": [
    "# TAFE survey\n",
    "\n",
    "tafe_survey.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "            Record ID                              Institute  \\\n",
       "0  634133009996094000  Southern Queensland Institute of TAFE   \n",
       "1  634133654064531000            Mount Isa Institute of TAFE   \n",
       "2  634138845606563000            Mount Isa Institute of TAFE   \n",
       "3  634139903350000000            Mount Isa Institute of TAFE   \n",
       "4  634146578511788000  Southern Queensland Institute of TAFE   \n",
       "\n",
       "                   WorkArea  CESSATION YEAR Reason for ceasing employment  \\\n",
       "0  Non-Delivery (corporate)          2010.0              Contract Expired   \n",
       "1  Non-Delivery (corporate)          2010.0                    Retirement   \n",
       "2       Delivery (teaching)          2010.0                    Retirement   \n",
       "3  Non-Delivery (corporate)          2010.0                   Resignation   \n",
       "4       Delivery (teaching)          2010.0                   Resignation   \n",
       "\n",
       "  Contributing Factors. Career Move - Public Sector   \\\n",
       "0                                                NaN   \n",
       "1                                                  -   \n",
       "2                                                  -   \n",
       "3                                                  -   \n",
       "4                                                  -   \n",
       "\n",
       "  Contributing Factors. Career Move - Private Sector   \\\n",
       "0                                                NaN    \n",
       "1                                                  -    \n",
       "2                                                  -    \n",
       "3                                                  -    \n",
       "4                       Career Move - Private Sector    \n",
       "\n",
       "  Contributing Factors. Career Move - Self-employment  \\\n",
       "0                                                NaN    \n",
       "1                                                  -    \n",
       "2                                                  -    \n",
       "3                                                  -    \n",
       "4                                                  -    \n",
       "\n",
       "  Contributing Factors. Ill Health Contributing Factors. Maternity/Family  \\\n",
       "0                              NaN                                    NaN   \n",
       "1                                -                                      -   \n",
       "2                                -                                      -   \n",
       "3                                -                                      -   \n",
       "4                                -                                      -   \n",
       "\n",
       "   ...  \\\n",
       "0  ...   \n",
       "1  ...   \n",
       "2  ...   \n",
       "3  ...   \n",
       "4  ...   \n",
       "\n",
       "  Workplace. Topic:Does your workplace promote a work culture free from all forms of unlawful discrimination?  \\\n",
       "0                                                Yes                                                            \n",
       "1                                                Yes                                                            \n",
       "2                                                Yes                                                            \n",
       "3                                                Yes                                                            \n",
       "4                                                Yes                                                            \n",
       "\n",
       "  Workplace. Topic:Does your workplace promote and practice the principles of employment equity?  \\\n",
       "0                                                Yes                                               \n",
       "1                                                Yes                                               \n",
       "2                                                Yes                                               \n",
       "3                                                Yes                                               \n",
       "4                                                Yes                                               \n",
       "\n",
       "  Workplace. Topic:Does your workplace value the diversity of its employees?  \\\n",
       "0                                                Yes                           \n",
       "1                                                Yes                           \n",
       "2                                                Yes                           \n",
       "3                                                Yes                           \n",
       "4                                                Yes                           \n",
       "\n",
       "  Workplace. Topic:Would you recommend the Institute as an employer to others?  \\\n",
       "0                                                Yes                             \n",
       "1                                                Yes                             \n",
       "2                                                Yes                             \n",
       "3                                                Yes                             \n",
       "4                                                Yes                             \n",
       "\n",
       "  Gender.     What is your Gender? CurrentAge.     Current Age  \\\n",
       "0                           Female                     26 – 30   \n",
       "1                              NaN                         NaN   \n",
       "2                              NaN                         NaN   \n",
       "3                              NaN                         NaN   \n",
       "4                             Male                     41 – 45   \n",
       "\n",
       "  Employment Type.     Employment Type Classification.     Classification  \\\n",
       "0                  Temporary Full-time                Administration (AO)   \n",
       "1                                  NaN                                NaN   \n",
       "2                                  NaN                                NaN   \n",
       "3                                  NaN                                NaN   \n",
       "4                  Permanent Full-time            Teacher (including LVT)   \n",
       "\n",
       "  LengthofServiceOverall. Overall Length of Service at Institute (in years)  \\\n",
       "0                                                1-2                          \n",
       "1                                                NaN                          \n",
       "2                                                NaN                          \n",
       "3                                                NaN                          \n",
       "4                                                3-4                          \n",
       "\n",
       "  LengthofServiceCurrent. Length of Service at current workplace (in years)  \n",
       "0                                                1-2                         \n",
       "1                                                NaN                         \n",
       "2                                                NaN                         \n",
       "3                                                NaN                         \n",
       "4                                                3-4                         \n",
       "\n",
       "[5 rows x 72 columns]"
      ],
      "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>Record ID</th>\n      <th>Institute</th>\n      <th>WorkArea</th>\n      <th>CESSATION YEAR</th>\n      <th>Reason for ceasing employment</th>\n      <th>Contributing Factors. Career Move - Public Sector</th>\n      <th>Contributing Factors. Career Move - Private Sector</th>\n      <th>Contributing Factors. Career Move - Self-employment</th>\n      <th>Contributing Factors. Ill Health</th>\n      <th>Contributing Factors. Maternity/Family</th>\n      <th>...</th>\n      <th>Workplace. Topic:Does your workplace promote a work culture free from all forms of unlawful discrimination?</th>\n      <th>Workplace. Topic:Does your workplace promote and practice the principles of employment equity?</th>\n      <th>Workplace. Topic:Does your workplace value the diversity of its employees?</th>\n      <th>Workplace. Topic:Would you recommend the Institute as an employer to others?</th>\n      <th>Gender.     What is your Gender?</th>\n      <th>CurrentAge.     Current Age</th>\n      <th>Employment Type.     Employment Type</th>\n      <th>Classification.     Classification</th>\n      <th>LengthofServiceOverall. Overall Length of Service at Institute (in years)</th>\n      <th>LengthofServiceCurrent. Length of Service at current workplace (in years)</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>634133009996094000</td>\n      <td>Southern Queensland Institute of TAFE</td>\n      <td>Non-Delivery (corporate)</td>\n      <td>2010.0</td>\n      <td>Contract Expired</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>...</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Female</td>\n      <td>26 – 30</td>\n      <td>Temporary Full-time</td>\n      <td>Administration (AO)</td>\n      <td>1-2</td>\n      <td>1-2</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>634133654064531000</td>\n      <td>Mount Isa Institute of TAFE</td>\n      <td>Non-Delivery (corporate)</td>\n      <td>2010.0</td>\n      <td>Retirement</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>...</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>634138845606563000</td>\n      <td>Mount Isa Institute of TAFE</td>\n      <td>Delivery (teaching)</td>\n      <td>2010.0</td>\n      <td>Retirement</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>...</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>634139903350000000</td>\n      <td>Mount Isa Institute of TAFE</td>\n      <td>Non-Delivery (corporate)</td>\n      <td>2010.0</td>\n      <td>Resignation</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>...</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>634146578511788000</td>\n      <td>Southern Queensland Institute of TAFE</td>\n      <td>Delivery (teaching)</td>\n      <td>2010.0</td>\n      <td>Resignation</td>\n      <td>-</td>\n      <td>Career Move - Private Sector</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>...</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Yes</td>\n      <td>Male</td>\n      <td>41 – 45</td>\n      <td>Permanent Full-time</td>\n      <td>Teacher (including LVT)</td>\n      <td>3-4</td>\n      <td>3-4</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows × 72 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 8
    }
   ],
   "source": [
    "tafe_survey.head(5)"
   ]
  },
  {
   "source": [
    "### DETE survey data\n",
    "There are 822 rows and 56 columns in the DETE survey. Data are stored in either string or boolean format, except `ID` column. `DETE Start Date`and `Role Start Date` contain \"Not Stated\" instead of null values. There are many columns that we don't need to work with.\n",
    "\n",
    "### TAFE survey data\n",
    "There are 702 rows and 72 columns in the TAFE survey. Data are stored in a string format, except `ID` and `CESSATION YEAR`. Although TAFE survey has more columns than DETE survey, many columns contain same data but with different column names. "
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "source": [
    "## Identify missing values and drop unnecessary columns\n",
    "We will change \"Not Stated\" to null values and drop unnecessary columns (e.g. the detail questions part)."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "   ID                    SeparationType Cease Date  DETE Start Date  \\\n",
       "0   1             Ill Health Retirement    08/2012           1984.0   \n",
       "1   2  Voluntary Early Retirement (VER)    08/2012              NaN   \n",
       "2   3  Voluntary Early Retirement (VER)    05/2012           2011.0   \n",
       "3   4         Resignation-Other reasons    05/2012           2005.0   \n",
       "4   5                    Age Retirement    05/2012           1970.0   \n",
       "\n",
       "   Role Start Date                                      Position  \\\n",
       "0           2004.0                                Public Servant   \n",
       "1              NaN                                Public Servant   \n",
       "2           2011.0                               Schools Officer   \n",
       "3           2006.0                                       Teacher   \n",
       "4           1989.0  Head of Curriculum/Head of Special Education   \n",
       "\n",
       "  Classification              Region                      Business Unit  \\\n",
       "0        A01-A04      Central Office  Corporate Strategy and Peformance   \n",
       "1        AO5-AO7      Central Office  Corporate Strategy and Peformance   \n",
       "2            NaN      Central Office               Education Queensland   \n",
       "3        Primary  Central Queensland                                NaN   \n",
       "4            NaN          South East                                NaN   \n",
       "\n",
       "     Employment Status  ...  Kept informed  Wellness programs  \\\n",
       "0  Permanent Full-time  ...              N                  N   \n",
       "1  Permanent Full-time  ...              N                  N   \n",
       "2  Permanent Full-time  ...              N                  N   \n",
       "3  Permanent Full-time  ...              A                  N   \n",
       "4  Permanent Full-time  ...              N                  A   \n",
       "\n",
       "   Health & Safety  Gender          Age  Aboriginal  Torres Strait  South Sea  \\\n",
       "0                N    Male        56-60         NaN            NaN        NaN   \n",
       "1                N    Male        56-60         NaN            NaN        NaN   \n",
       "2                N    Male  61 or older         NaN            NaN        NaN   \n",
       "3                A  Female        36-40         NaN            NaN        NaN   \n",
       "4                M  Female  61 or older         NaN            NaN        NaN   \n",
       "\n",
       "   Disability  NESB  \n",
       "0         NaN   Yes  \n",
       "1         NaN   NaN  \n",
       "2         NaN   NaN  \n",
       "3         NaN   NaN  \n",
       "4         NaN   NaN  \n",
       "\n",
       "[5 rows x 56 columns]"
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>ID</th>\n      <th>SeparationType</th>\n      <th>Cease Date</th>\n      <th>DETE Start Date</th>\n      <th>Role Start Date</th>\n      <th>Position</th>\n      <th>Classification</th>\n      <th>Region</th>\n      <th>Business Unit</th>\n      <th>Employment Status</th>\n      <th>...</th>\n      <th>Kept informed</th>\n      <th>Wellness programs</th>\n      <th>Health &amp; Safety</th>\n      <th>Gender</th>\n      <th>Age</th>\n      <th>Aboriginal</th>\n      <th>Torres Strait</th>\n      <th>South Sea</th>\n      <th>Disability</th>\n      <th>NESB</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1</td>\n      <td>Ill Health Retirement</td>\n      <td>08/2012</td>\n      <td>1984.0</td>\n      <td>2004.0</td>\n      <td>Public Servant</td>\n      <td>A01-A04</td>\n      <td>Central Office</td>\n      <td>Corporate Strategy and Peformance</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>N</td>\n      <td>N</td>\n      <td>N</td>\n      <td>Male</td>\n      <td>56-60</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Yes</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>2</td>\n      <td>Voluntary Early Retirement (VER)</td>\n      <td>08/2012</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Public Servant</td>\n      <td>AO5-AO7</td>\n      <td>Central Office</td>\n      <td>Corporate Strategy and Peformance</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>N</td>\n      <td>N</td>\n      <td>N</td>\n      <td>Male</td>\n      <td>56-60</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>3</td>\n      <td>Voluntary Early Retirement (VER)</td>\n      <td>05/2012</td>\n      <td>2011.0</td>\n      <td>2011.0</td>\n      <td>Schools Officer</td>\n      <td>NaN</td>\n      <td>Central Office</td>\n      <td>Education Queensland</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>N</td>\n      <td>N</td>\n      <td>N</td>\n      <td>Male</td>\n      <td>61 or older</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>4</td>\n      <td>Resignation-Other reasons</td>\n      <td>05/2012</td>\n      <td>2005.0</td>\n      <td>2006.0</td>\n      <td>Teacher</td>\n      <td>Primary</td>\n      <td>Central Queensland</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>A</td>\n      <td>N</td>\n      <td>A</td>\n      <td>Female</td>\n      <td>36-40</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>5</td>\n      <td>Age Retirement</td>\n      <td>05/2012</td>\n      <td>1970.0</td>\n      <td>1989.0</td>\n      <td>Head of Curriculum/Head of Special Education</td>\n      <td>NaN</td>\n      <td>South East</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>N</td>\n      <td>A</td>\n      <td>M</td>\n      <td>Female</td>\n      <td>61 or older</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows × 56 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 9
    }
   ],
   "source": [
    "# Change \"Not Stated\" to null when reading in the file\n",
    "\n",
    "dete_survey = pd.read_csv(\"D:\\Documents\\Python Journey\\Dataquest\\Guided Project 6_Clean and Analyze Employee Exit Surveys\\dete-exit-survey-january-2014_utf8.csv\", na_values=\"Not Stated\")\n",
    "\n",
    "dete_survey.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop unnecessary columns\n",
    "\n",
    "dete_survey_updated = dete_survey.drop(dete_survey.columns[28:49], axis=1)\n",
    "tafe_survey_updated = tafe_survey.drop(tafe_survey.columns[17:66], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "Index(['ID', 'SeparationType', 'Cease Date', 'DETE Start Date',\n       'Role Start Date', 'Position', 'Classification', 'Region',\n       'Business Unit', 'Employment Status', 'Career move to public sector',\n       'Career move to private sector', 'Interpersonal conflicts',\n       'Job dissatisfaction', 'Dissatisfaction with the department',\n       'Physical work environment', 'Lack of recognition',\n       'Lack of job security', 'Work location', 'Employment conditions',\n       'Maternity/family', 'Relocation', 'Study/Travel', 'Ill Health',\n       'Traumatic incident', 'Work life balance', 'Workload',\n       'None of the above', 'Gender', 'Age', 'Aboriginal', 'Torres Strait',\n       'South Sea', 'Disability', 'NESB'],\n      dtype='object')\nIndex(['Record ID', 'Institute', 'WorkArea', 'CESSATION YEAR',\n       'Reason for ceasing employment',\n       'Contributing Factors. Career Move - Public Sector ',\n       'Contributing Factors. Career Move - Private Sector ',\n       'Contributing Factors. Career Move - Self-employment',\n       'Contributing Factors. Ill Health',\n       'Contributing Factors. Maternity/Family',\n       'Contributing Factors. Dissatisfaction',\n       'Contributing Factors. Job Dissatisfaction',\n       'Contributing Factors. Interpersonal Conflict',\n       'Contributing Factors. Study', 'Contributing Factors. Travel',\n       'Contributing Factors. Other', 'Contributing Factors. NONE',\n       'Gender.     What is your Gender?', 'CurrentAge.     Current Age',\n       'Employment Type.     Employment Type',\n       'Classification.     Classification',\n       'LengthofServiceOverall. Overall Length of Service at Institute (in years)',\n       'LengthofServiceCurrent. Length of Service at current workplace (in years)'],\n      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "print(dete_survey_updated.columns)\n",
    "print(tafe_survey_updated.columns)"
   ]
  },
  {
   "source": [
    "## Align column names\n",
    "As these 2 data sets will be combined later, we will rename columns in both datasets to align with each other."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "Index(['id', 'separationtype', 'cease_date', 'dete_start_date',\n       'role_start_date', 'position', 'classification', 'region',\n       'business_unit', 'employment_status', 'career_move_to_public_sector',\n       'career_move_to_private_sector', 'interpersonal_conflicts',\n       'job_dissatisfaction', 'dissatisfaction_with_the_department',\n       'physical_work_environment', 'lack_of_recognition',\n       'lack_of_job_security', 'work_location', 'employment_conditions',\n       'maternity/family', 'relocation', 'study/travel', 'ill_health',\n       'traumatic_incident', 'work_life_balance', 'workload',\n       'none_of_the_above', 'gender', 'age', 'aboriginal', 'torres_strait',\n       'south_sea', 'disability', 'nesb'],\n      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "# Standardize column names in DETE survey\n",
    "\n",
    "dete_survey_updated.columns = dete_survey_updated.columns.str.lower().str.strip().str.replace(\" \", \"_\")\n",
    "print(dete_survey_updated.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "Index(['id', 'Institute', 'WorkArea', 'cease_date', 'separationtype',\n       'Contributing Factors. Career Move - Public Sector ',\n       'Contributing Factors. Career Move - Private Sector ',\n       'Contributing Factors. Career Move - Self-employment',\n       'Contributing Factors. Ill Health',\n       'Contributing Factors. Maternity/Family',\n       'Contributing Factors. Dissatisfaction',\n       'Contributing Factors. Job Dissatisfaction',\n       'Contributing Factors. Interpersonal Conflict',\n       'Contributing Factors. Study', 'Contributing Factors. Travel',\n       'Contributing Factors. Other', 'Contributing Factors. NONE',\n       'Gender.     What is your Gender?', 'CurrentAge.     Current Age',\n       'Employment Type.     Employment Type',\n       'Classification.     Classification', 'institute_service',\n       'role_service'],\n      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "# Rename columns in TAFE survey to match DETE survey\n",
    "\n",
    "tafe_mapping = {'Record ID': 'id', \n",
    "'CESSATION YEAR': 'cease_date', \n",
    "'Reason for ceasing employment': 'separationtype', \n",
    "'Gender. What is your Gender?': 'gender',\n",
    "'CurrentAge. Current Age': 'age',\n",
    "'Employment Type. Employment Type': 'employment_status',\n",
    "'Classification. Classification': 'position',\n",
    "'LengthofServiceOverall. Overall Length of Service at Institute (in years)': 'institute_service',\n",
    "'LengthofServiceCurrent. Length of Service at current workplace (in years)': 'role_service'}\n",
    "\n",
    "tafe_survey_updated = tafe_survey_updated.rename(tafe_mapping, axis=1)\n",
    "print(tafe_survey_updated.columns)"
   ]
  },
  {
   "source": [
    "## Filter data\n",
    "This project is aiming to answer the questions regarding employees who resigned from DETE and TAFE. Hence, we will focus on the rows which `separationtype` is resignation."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "Age Retirement                          285\n",
       "Resignation-Other reasons               150\n",
       "Resignation-Other employer               91\n",
       "Resignation-Move overseas/interstate     70\n",
       "Voluntary Early Retirement (VER)         67\n",
       "Ill Health Retirement                    61\n",
       "Other                                    49\n",
       "Contract Expired                         34\n",
       "Termination                              15\n",
       "Name: separationtype, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 14
    }
   ],
   "source": [
    "dete_survey_updated[\"separationtype\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "Resignation                 340\n",
       "Contract Expired            127\n",
       "Retrenchment/ Redundancy    104\n",
       "Retirement                   82\n",
       "Transfer                     25\n",
       "Termination                  23\n",
       "Name: separationtype, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 15
    }
   ],
   "source": [
    "tafe_survey_updated[\"separationtype\"].value_counts()"
   ]
  },
  {
   "source": [
    "There are more than 1 types of resignation in DETE survey data. We will change the names into \"Resignation\" to easily handle the data."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "Resignation                         311\n",
       "Age Retirement                      285\n",
       "Voluntary Early Retirement (VER)     67\n",
       "Ill Health Retirement                61\n",
       "Other                                49\n",
       "Contract Expired                     34\n",
       "Termination                          15\n",
       "Name: separationtype, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 16
    }
   ],
   "source": [
    "dete_survey_updated[\"separationtype\"] = dete_survey_updated[\"separationtype\"].str.split(\"-\").str[0]\n",
    "dete_survey_updated[\"separationtype\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "dete_resignations = dete_survey_updated[dete_survey_updated[\"separationtype\"] == \"Resignation\"].copy()\n",
    "tafe_resignations = tafe_survey_updated[tafe_survey_updated[\"separationtype\"] == \"Resignation\"].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "    id separationtype cease_date  dete_start_date  role_start_date  \\\n",
       "3    4    Resignation    05/2012           2005.0           2006.0   \n",
       "5    6    Resignation    05/2012           1994.0           1997.0   \n",
       "8    9    Resignation    07/2012           2009.0           2009.0   \n",
       "9   10    Resignation       2012           1997.0           2008.0   \n",
       "11  12    Resignation       2012           2009.0           2009.0   \n",
       "\n",
       "            position classification                region  \\\n",
       "3            Teacher        Primary    Central Queensland   \n",
       "5   Guidance Officer            NaN        Central Office   \n",
       "8            Teacher      Secondary      North Queensland   \n",
       "9       Teacher Aide            NaN                   NaN   \n",
       "11           Teacher      Secondary  Far North Queensland   \n",
       "\n",
       "           business_unit    employment_status  ...  work_life_balance  \\\n",
       "3                    NaN  Permanent Full-time  ...              False   \n",
       "5   Education Queensland  Permanent Full-time  ...              False   \n",
       "8                    NaN  Permanent Full-time  ...              False   \n",
       "9                    NaN  Permanent Part-time  ...              False   \n",
       "11                   NaN  Permanent Full-time  ...              False   \n",
       "\n",
       "    workload  none_of_the_above  gender    age  aboriginal  torres_strait  \\\n",
       "3      False              False  Female  36-40         NaN            NaN   \n",
       "5      False              False  Female  41-45         NaN            NaN   \n",
       "8      False              False  Female  31-35         NaN            NaN   \n",
       "9      False              False  Female  46-50         NaN            NaN   \n",
       "11     False              False    Male  31-35         NaN            NaN   \n",
       "\n",
       "    south_sea  disability  nesb  \n",
       "3         NaN         NaN   NaN  \n",
       "5         NaN         NaN   NaN  \n",
       "8         NaN         NaN   NaN  \n",
       "9         NaN         NaN   NaN  \n",
       "11        NaN         NaN   NaN  \n",
       "\n",
       "[5 rows x 35 columns]"
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>id</th>\n      <th>separationtype</th>\n      <th>cease_date</th>\n      <th>dete_start_date</th>\n      <th>role_start_date</th>\n      <th>position</th>\n      <th>classification</th>\n      <th>region</th>\n      <th>business_unit</th>\n      <th>employment_status</th>\n      <th>...</th>\n      <th>work_life_balance</th>\n      <th>workload</th>\n      <th>none_of_the_above</th>\n      <th>gender</th>\n      <th>age</th>\n      <th>aboriginal</th>\n      <th>torres_strait</th>\n      <th>south_sea</th>\n      <th>disability</th>\n      <th>nesb</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>3</th>\n      <td>4</td>\n      <td>Resignation</td>\n      <td>05/2012</td>\n      <td>2005.0</td>\n      <td>2006.0</td>\n      <td>Teacher</td>\n      <td>Primary</td>\n      <td>Central Queensland</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Female</td>\n      <td>36-40</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>6</td>\n      <td>Resignation</td>\n      <td>05/2012</td>\n      <td>1994.0</td>\n      <td>1997.0</td>\n      <td>Guidance Officer</td>\n      <td>NaN</td>\n      <td>Central Office</td>\n      <td>Education Queensland</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Female</td>\n      <td>41-45</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>9</td>\n      <td>Resignation</td>\n      <td>07/2012</td>\n      <td>2009.0</td>\n      <td>2009.0</td>\n      <td>Teacher</td>\n      <td>Secondary</td>\n      <td>North Queensland</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Female</td>\n      <td>31-35</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>10</td>\n      <td>Resignation</td>\n      <td>2012</td>\n      <td>1997.0</td>\n      <td>2008.0</td>\n      <td>Teacher Aide</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Permanent Part-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Female</td>\n      <td>46-50</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>12</td>\n      <td>Resignation</td>\n      <td>2012</td>\n      <td>2009.0</td>\n      <td>2009.0</td>\n      <td>Teacher</td>\n      <td>Secondary</td>\n      <td>Far North Queensland</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Male</td>\n      <td>31-35</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows × 35 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 18
    }
   ],
   "source": [
    "dete_resignations.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "                   id                              Institute  \\\n",
       "3  634139903350000000            Mount Isa Institute of TAFE   \n",
       "4  634146578511788000  Southern Queensland Institute of TAFE   \n",
       "5  634147506906311000  Southern Queensland Institute of TAFE   \n",
       "6  634152007975694000         Barrier Reef Institute of TAFE   \n",
       "7  634153745310374000  Southern Queensland Institute of TAFE   \n",
       "\n",
       "                   WorkArea  cease_date separationtype  \\\n",
       "3  Non-Delivery (corporate)      2010.0    Resignation   \n",
       "4       Delivery (teaching)      2010.0    Resignation   \n",
       "5       Delivery (teaching)      2010.0    Resignation   \n",
       "6  Non-Delivery (corporate)      2010.0    Resignation   \n",
       "7       Delivery (teaching)      2010.0    Resignation   \n",
       "\n",
       "  Contributing Factors. Career Move - Public Sector   \\\n",
       "3                                                  -   \n",
       "4                                                  -   \n",
       "5                                                  -   \n",
       "6                                                  -   \n",
       "7                                                  -   \n",
       "\n",
       "  Contributing Factors. Career Move - Private Sector   \\\n",
       "3                                                  -    \n",
       "4                       Career Move - Private Sector    \n",
       "5                                                  -    \n",
       "6                       Career Move - Private Sector    \n",
       "7                                                  -    \n",
       "\n",
       "  Contributing Factors. Career Move - Self-employment  \\\n",
       "3                                                  -    \n",
       "4                                                  -    \n",
       "5                                                  -    \n",
       "6                                                  -    \n",
       "7                                                  -    \n",
       "\n",
       "  Contributing Factors. Ill Health Contributing Factors. Maternity/Family  \\\n",
       "3                                -                                      -   \n",
       "4                                -                                      -   \n",
       "5                                -                                      -   \n",
       "6                                -                       Maternity/Family   \n",
       "7                                -                                      -   \n",
       "\n",
       "   ... Contributing Factors. Study Contributing Factors. Travel  \\\n",
       "3  ...                           -                       Travel   \n",
       "4  ...                           -                            -   \n",
       "5  ...                           -                            -   \n",
       "6  ...                           -                            -   \n",
       "7  ...                           -                            -   \n",
       "\n",
       "  Contributing Factors. Other Contributing Factors. NONE  \\\n",
       "3                           -                          -   \n",
       "4                           -                          -   \n",
       "5                       Other                          -   \n",
       "6                       Other                          -   \n",
       "7                       Other                          -   \n",
       "\n",
       "  Gender.     What is your Gender? CurrentAge.     Current Age  \\\n",
       "3                              NaN                         NaN   \n",
       "4                             Male                     41 – 45   \n",
       "5                           Female                 56 or older   \n",
       "6                             Male               20 or younger   \n",
       "7                             Male                     46 – 50   \n",
       "\n",
       "  Employment Type.     Employment Type Classification.     Classification  \\\n",
       "3                                  NaN                                NaN   \n",
       "4                  Permanent Full-time            Teacher (including LVT)   \n",
       "5                      Contract/casual            Teacher (including LVT)   \n",
       "6                  Temporary Full-time                Administration (AO)   \n",
       "7                  Permanent Full-time            Teacher (including LVT)   \n",
       "\n",
       "  institute_service role_service  \n",
       "3               NaN          NaN  \n",
       "4               3-4          3-4  \n",
       "5              7-10         7-10  \n",
       "6               3-4          3-4  \n",
       "7               3-4          3-4  \n",
       "\n",
       "[5 rows x 23 columns]"
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>id</th>\n      <th>Institute</th>\n      <th>WorkArea</th>\n      <th>cease_date</th>\n      <th>separationtype</th>\n      <th>Contributing Factors. Career Move - Public Sector</th>\n      <th>Contributing Factors. Career Move - Private Sector</th>\n      <th>Contributing Factors. Career Move - Self-employment</th>\n      <th>Contributing Factors. Ill Health</th>\n      <th>Contributing Factors. Maternity/Family</th>\n      <th>...</th>\n      <th>Contributing Factors. Study</th>\n      <th>Contributing Factors. Travel</th>\n      <th>Contributing Factors. Other</th>\n      <th>Contributing Factors. NONE</th>\n      <th>Gender.     What is your Gender?</th>\n      <th>CurrentAge.     Current Age</th>\n      <th>Employment Type.     Employment Type</th>\n      <th>Classification.     Classification</th>\n      <th>institute_service</th>\n      <th>role_service</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>3</th>\n      <td>634139903350000000</td>\n      <td>Mount Isa Institute of TAFE</td>\n      <td>Non-Delivery (corporate)</td>\n      <td>2010.0</td>\n      <td>Resignation</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>-</td>\n      <td>...</td>\n      <td>-</td>\n      <td>Travel</td>\n      <td>-</td>\n      <td>-</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>634146578511788000</td>\n      <td>Southern Queensland Institute of TAFE</td>\n      <td>Delivery (teaching)</td>\n      <td>2010.0</td>\n      <td>Resignation</td>\n      <td>-</td>\n      <td>Career Move - Private Sector</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>Male</td>\n      <td>41 – 45</td>\n      <td>Permanent Full-time</td>\n      <td>Teacher (including LVT)</td>\n      <td>3-4</td>\n      <td>3-4</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>634147506906311000</td>\n      <td>Southern Queensland Institute of TAFE</td>\n      <td>Delivery (teaching)</td>\n      <td>2010.0</td>\n      <td>Resignation</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>Other</td>\n      <td>-</td>\n      <td>Female</td>\n      <td>56 or older</td>\n      <td>Contract/casual</td>\n      <td>Teacher (including LVT)</td>\n      <td>7-10</td>\n      <td>7-10</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>634152007975694000</td>\n      <td>Barrier Reef Institute of TAFE</td>\n      <td>Non-Delivery (corporate)</td>\n      <td>2010.0</td>\n      <td>Resignation</td>\n      <td>-</td>\n      <td>Career Move - Private Sector</td>\n      <td>-</td>\n      <td>-</td>\n      <td>Maternity/Family</td>\n      <td>...</td>\n      <td>-</td>\n      <td>-</td>\n      <td>Other</td>\n      <td>-</td>\n      <td>Male</td>\n      <td>20 or younger</td>\n      <td>Temporary Full-time</td>\n      <td>Administration (AO)</td>\n      <td>3-4</td>\n      <td>3-4</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>634153745310374000</td>\n      <td>Southern Queensland Institute of TAFE</td>\n      <td>Delivery (teaching)</td>\n      <td>2010.0</td>\n      <td>Resignation</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>Other</td>\n      <td>-</td>\n      <td>Male</td>\n      <td>46 – 50</td>\n      <td>Permanent Full-time</td>\n      <td>Teacher (including LVT)</td>\n      <td>3-4</td>\n      <td>3-4</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows × 23 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 19
    }
   ],
   "source": [
    "tafe_resignations.head(5)"
   ]
  },
  {
   "source": [
    "## Verify the data\n",
    "We will verify the years in `cease_date` and `dete_start_date` to ensure that our data are consistent. For example, `dete_start_date` should not be after `cease_date`."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "2012       126\n",
       "2013        74\n",
       "01/2014     22\n",
       "12/2013     17\n",
       "06/2013     14\n",
       "09/2013     11\n",
       "11/2013      9\n",
       "07/2013      9\n",
       "10/2013      6\n",
       "08/2013      4\n",
       "05/2012      2\n",
       "05/2013      2\n",
       "07/2012      1\n",
       "09/2010      1\n",
       "2010         1\n",
       "07/2006      1\n",
       "Name: cease_date, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 20
    }
   ],
   "source": [
    "dete_resignations[\"cease_date\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "2006.0      1\n",
       "2010.0      2\n",
       "2012.0    129\n",
       "2013.0    146\n",
       "2014.0     22\n",
       "Name: cease_date, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 21
    }
   ],
   "source": [
    "dete_resignations[\"cease_date\"] = dete_resignations[\"cease_date\"].str.split(\"/\").str[-1]\n",
    "dete_resignations[\"cease_date\"] = dete_resignations[\"cease_date\"].astype(\"float64\")\n",
    "dete_resignations[\"cease_date\"].value_counts().sort_index(ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "1963.0     1\n",
       "1971.0     1\n",
       "1972.0     1\n",
       "1973.0     1\n",
       "1974.0     2\n",
       "1975.0     1\n",
       "1976.0     2\n",
       "1977.0     1\n",
       "1980.0     5\n",
       "1982.0     1\n",
       "1983.0     2\n",
       "1984.0     1\n",
       "1985.0     3\n",
       "1986.0     3\n",
       "1987.0     1\n",
       "1988.0     4\n",
       "1989.0     4\n",
       "1990.0     5\n",
       "1991.0     4\n",
       "1992.0     6\n",
       "1993.0     5\n",
       "1994.0     6\n",
       "1995.0     4\n",
       "1996.0     6\n",
       "1997.0     5\n",
       "1998.0     6\n",
       "1999.0     8\n",
       "2000.0     9\n",
       "2001.0     3\n",
       "2002.0     6\n",
       "2003.0     6\n",
       "2004.0    14\n",
       "2005.0    15\n",
       "2006.0    13\n",
       "2007.0    21\n",
       "2008.0    22\n",
       "2009.0    13\n",
       "2010.0    17\n",
       "2011.0    24\n",
       "2012.0    21\n",
       "2013.0    10\n",
       "Name: dete_start_date, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 22
    }
   ],
   "source": [
    "dete_resignations[\"dete_start_date\"].value_counts().sort_index(ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "2009.0      2\n",
       "2010.0     68\n",
       "2011.0    116\n",
       "2012.0     94\n",
       "2013.0     55\n",
       "Name: cease_date, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 23
    }
   ],
   "source": [
    "tafe_resignations[\"cease_date\"].value_counts().sort_index(ascending=True)"
   ]
  },
  {
   "source": [
    "The data in `cease_date` and `dete_start_date` columns seem consistent so far. We also noticed that there aren't many results for `cease_date` prior to 2010."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "source": [
    "## Calculate Years of Service\n",
    "Our analysis will answer the questions involving years of service. TAFE survey data has already provided us this number. We will need to calculate years of service for DETE survey data."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "    id separationtype  cease_date  dete_start_date  role_start_date  \\\n",
       "3    4    Resignation      2012.0           2005.0           2006.0   \n",
       "5    6    Resignation      2012.0           1994.0           1997.0   \n",
       "8    9    Resignation      2012.0           2009.0           2009.0   \n",
       "9   10    Resignation      2012.0           1997.0           2008.0   \n",
       "11  12    Resignation      2012.0           2009.0           2009.0   \n",
       "\n",
       "            position classification                region  \\\n",
       "3            Teacher        Primary    Central Queensland   \n",
       "5   Guidance Officer            NaN        Central Office   \n",
       "8            Teacher      Secondary      North Queensland   \n",
       "9       Teacher Aide            NaN                   NaN   \n",
       "11           Teacher      Secondary  Far North Queensland   \n",
       "\n",
       "           business_unit    employment_status  ...  workload  \\\n",
       "3                    NaN  Permanent Full-time  ...     False   \n",
       "5   Education Queensland  Permanent Full-time  ...     False   \n",
       "8                    NaN  Permanent Full-time  ...     False   \n",
       "9                    NaN  Permanent Part-time  ...     False   \n",
       "11                   NaN  Permanent Full-time  ...     False   \n",
       "\n",
       "    none_of_the_above  gender    age  aboriginal  torres_strait  south_sea  \\\n",
       "3               False  Female  36-40         NaN            NaN        NaN   \n",
       "5               False  Female  41-45         NaN            NaN        NaN   \n",
       "8               False  Female  31-35         NaN            NaN        NaN   \n",
       "9               False  Female  46-50         NaN            NaN        NaN   \n",
       "11              False    Male  31-35         NaN            NaN        NaN   \n",
       "\n",
       "    disability  nesb  institute_service  \n",
       "3          NaN   NaN                7.0  \n",
       "5          NaN   NaN               18.0  \n",
       "8          NaN   NaN                3.0  \n",
       "9          NaN   NaN               15.0  \n",
       "11         NaN   NaN                3.0  \n",
       "\n",
       "[5 rows x 36 columns]"
      ],
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>id</th>\n      <th>separationtype</th>\n      <th>cease_date</th>\n      <th>dete_start_date</th>\n      <th>role_start_date</th>\n      <th>position</th>\n      <th>classification</th>\n      <th>region</th>\n      <th>business_unit</th>\n      <th>employment_status</th>\n      <th>...</th>\n      <th>workload</th>\n      <th>none_of_the_above</th>\n      <th>gender</th>\n      <th>age</th>\n      <th>aboriginal</th>\n      <th>torres_strait</th>\n      <th>south_sea</th>\n      <th>disability</th>\n      <th>nesb</th>\n      <th>institute_service</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>3</th>\n      <td>4</td>\n      <td>Resignation</td>\n      <td>2012.0</td>\n      <td>2005.0</td>\n      <td>2006.0</td>\n      <td>Teacher</td>\n      <td>Primary</td>\n      <td>Central Queensland</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Female</td>\n      <td>36-40</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>7.0</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>6</td>\n      <td>Resignation</td>\n      <td>2012.0</td>\n      <td>1994.0</td>\n      <td>1997.0</td>\n      <td>Guidance Officer</td>\n      <td>NaN</td>\n      <td>Central Office</td>\n      <td>Education Queensland</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Female</td>\n      <td>41-45</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>18.0</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>9</td>\n      <td>Resignation</td>\n      <td>2012.0</td>\n      <td>2009.0</td>\n      <td>2009.0</td>\n      <td>Teacher</td>\n      <td>Secondary</td>\n      <td>North Queensland</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Female</td>\n      <td>31-35</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>3.0</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>10</td>\n      <td>Resignation</td>\n      <td>2012.0</td>\n      <td>1997.0</td>\n      <td>2008.0</td>\n      <td>Teacher Aide</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Permanent Part-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Female</td>\n      <td>46-50</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>15.0</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>12</td>\n      <td>Resignation</td>\n      <td>2012.0</td>\n      <td>2009.0</td>\n      <td>2009.0</td>\n      <td>Teacher</td>\n      <td>Secondary</td>\n      <td>Far North Queensland</td>\n      <td>NaN</td>\n      <td>Permanent Full-time</td>\n      <td>...</td>\n      <td>False</td>\n      <td>False</td>\n      <td>Male</td>\n      <td>31-35</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>3.0</td>\n    </tr>\n  </tbody>\n</table>\n<p>5 rows × 36 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 24
    }
   ],
   "source": [
    "dete_resignations[\"institute_service\"] = dete_resignations[\"cease_date\"] - dete_resignations[\"dete_start_date\"]\n",
    "dete_resignations.head(5)"
   ]
  },
  {
   "source": [
    "## Identify Dissatisfied Employees\n",
    "In each dataframe, we will summarize whether the employees resigned because of dissatisfaction. If the employees' results in any of the columns below are true, we deem that they are dissatisfied employees.\n",
    "\n",
    "Columns in TAFE survey data:\n",
    " - `Contributing Factors. Dissatisfaction`\n",
    " - `Contributing Factors. Job Dissatisfaction`\n",
    "\n",
    "Columns in DETE survey data:\n",
    "- `job_dissatisfaction`\n",
    "- `dissatisfaction_with_the_department`\n",
    "- `physical_work_environment`\n",
    "- `lack_of_recognition`\n",
    "- `lack_of_job_security`\n",
    "- `work_location`\n",
    "- `employment_conditions`\n",
    "- `work_life_balance`\n",
    "- `workload`\n",
    "\n",
    "The data in TAFE survey data are now stored in string format. We will update the value into boolean prior to identiying dissatisfied employees."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "-                                         277\nContributing Factors. Dissatisfaction      55\nName: Contributing Factors. Dissatisfaction, dtype: int64\n-                      270\nJob Dissatisfaction     62\nName: Contributing Factors. Job Dissatisfaction, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Identify data in each column\n",
    "\n",
    "print(tafe_resignations[\"Contributing Factors. Dissatisfaction\"].value_counts())\n",
    "print(tafe_resignations[\"Contributing Factors. Job Dissatisfaction\"].value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to update values to boolean type\n",
    "\n",
    "def update_vals(val):\n",
    "    if pd.isnull(val):\n",
    "        return np.nan\n",
    "    elif val == \"-\":\n",
    "        return False\n",
    "    else:\n",
    "        return True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "False    241\n",
       "True      91\n",
       "NaN        8\n",
       "Name: dissatisfied, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 27
    }
   ],
   "source": [
    "tafe_resignations[\"dissatisfied\"] = tafe_resignations[[\"Contributing Factors. Dissatisfaction\", \"Contributing Factors. Job Dissatisfaction\"]].applymap(update_vals).any(axis=1, skipna=False)\n",
    "tafe_resignations_up = tafe_resignations.copy()\n",
    "tafe_resignations_up[\"dissatisfied\"].value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "False    162\n",
       "True     149\n",
       "Name: dissatisfied, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 28
    }
   ],
   "source": [
    "dete_resignations[\"dissatisfied\"] = dete_resignations[[\"job_dissatisfaction\", \"dissatisfaction_with_the_department\", \"physical_work_environment\", \"lack_of_recognition\", \"lack_of_job_security\", \"work_location\", \"employment_conditions\", \"work_life_balance\", \"workload\"]].any(axis=1, skipna=False)\n",
    "dete_resignations_up = dete_resignations.copy()\n",
    "dete_resignations_up[\"dissatisfied\"].value_counts(dropna=False)"
   ]
  },
  {
   "source": [
    "## Combine the data\n",
    "The data will be combined into one dataframe. As there are 651 entries in total, the columns that have more than 500 null values will be dropped."
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Add a column to identify the original dataframe\n",
    "\n",
    "dete_resignations_up[\"institute\"] = \"DETE\"\n",
    "tafe_resignations_up[\"institute\"] = \"TAFE\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "id                                                     651\n",
       "separationtype                                         651\n",
       "cease_date                                             635\n",
       "dete_start_date                                        283\n",
       "role_start_date                                        271\n",
       "position                                               308\n",
       "classification                                         161\n",
       "region                                                 265\n",
       "business_unit                                           32\n",
       "employment_status                                      307\n",
       "career_move_to_public_sector                           311\n",
       "career_move_to_private_sector                          311\n",
       "interpersonal_conflicts                                311\n",
       "job_dissatisfaction                                    311\n",
       "dissatisfaction_with_the_department                    311\n",
       "physical_work_environment                              311\n",
       "lack_of_recognition                                    311\n",
       "lack_of_job_security                                   311\n",
       "work_location                                          311\n",
       "employment_conditions                                  311\n",
       "maternity/family                                       311\n",
       "relocation                                             311\n",
       "study/travel                                           311\n",
       "ill_health                                             311\n",
       "traumatic_incident                                     311\n",
       "work_life_balance                                      311\n",
       "workload                                               311\n",
       "none_of_the_above                                      311\n",
       "gender                                                 302\n",
       "age                                                    306\n",
       "aboriginal                                               7\n",
       "torres_strait                                            0\n",
       "south_sea                                                3\n",
       "disability                                               8\n",
       "nesb                                                     9\n",
       "institute_service                                      563\n",
       "dissatisfied                                           643\n",
       "institute                                              651\n",
       "Institute                                              340\n",
       "WorkArea                                               340\n",
       "Contributing Factors. Career Move - Public Sector      332\n",
       "Contributing Factors. Career Move - Private Sector     332\n",
       "Contributing Factors. Career Move - Self-employment    332\n",
       "Contributing Factors. Ill Health                       332\n",
       "Contributing Factors. Maternity/Family                 332\n",
       "Contributing Factors. Dissatisfaction                  332\n",
       "Contributing Factors. Job Dissatisfaction              332\n",
       "Contributing Factors. Interpersonal Conflict           332\n",
       "Contributing Factors. Study                            332\n",
       "Contributing Factors. Travel                           332\n",
       "Contributing Factors. Other                            332\n",
       "Contributing Factors. NONE                             332\n",
       "Gender.     What is your Gender?                       290\n",
       "CurrentAge.     Current Age                            290\n",
       "Employment Type.     Employment Type                   290\n",
       "Classification.     Classification                     290\n",
       "role_service                                           290\n",
       "dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 30
    }
   ],
   "source": [
    "combined = pd.concat([dete_resignations_up, tafe_resignations_up], ignore_index=True)\n",
    "combined.notnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\nRangeIndex: 651 entries, 0 to 650\nData columns (total 6 columns):\n #   Column             Non-Null Count  Dtype  \n---  ------             --------------  -----  \n 0   id                 651 non-null    int64  \n 1   separationtype     651 non-null    object \n 2   cease_date         635 non-null    float64\n 3   institute_service  563 non-null    object \n 4   dissatisfied       643 non-null    object \n 5   institute          651 non-null    object \ndtypes: float64(1), int64(1), object(4)\nmemory usage: 30.6+ KB\n"
     ]
    }
   ],
   "source": [
    "combined_updated = combined.dropna(axis=1, thresh=500).copy()\n",
    "combined_updated.info()"
   ]
  },
  {
   "source": [
    "## Clean the Service column\n",
    "\n",
    "The data in `institute_service` are stored differently in the original 2 data sets. In DETE survey data, this column stores only numbers as we calculated it by ourselves. In TAFE survey data, the years of service are stored in a range. However, to analyze the data, we will convert them into 4 categories, based on this <a href=\"https://www.businesswire.com/news/home/20171108006002/en/Age-Number-Engage-Employees-Career-Stage\">article</a>.\n",
    "\n",
    "| Category | Career stage | Years of service |\n",
    "|--------------|------------------|\n",
    "| New | Newbie | 0 - 3 years |\n",
    "| Experienced | Sophomore | 3 - 6 years |\n",
    "| Established | Tenured | 7 - 10 years |\n",
    "| Veteran | Sage | 11 years or more |"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "NaN                   88\n",
       "Less than 1 year      73\n",
       "1-2                   64\n",
       "3-4                   63\n",
       "5-6                   33\n",
       "11-20                 26\n",
       "5.0                   23\n",
       "1.0                   22\n",
       "7-10                  21\n",
       "0.0                   20\n",
       "3.0                   20\n",
       "6.0                   17\n",
       "4.0                   16\n",
       "2.0                   14\n",
       "9.0                   14\n",
       "7.0                   13\n",
       "More than 20 years    10\n",
       "8.0                    8\n",
       "13.0                   8\n",
       "20.0                   7\n",
       "15.0                   7\n",
       "17.0                   6\n",
       "10.0                   6\n",
       "22.0                   6\n",
       "12.0                   6\n",
       "14.0                   6\n",
       "16.0                   5\n",
       "18.0                   5\n",
       "11.0                   4\n",
       "24.0                   4\n",
       "23.0                   4\n",
       "32.0                   3\n",
       "19.0                   3\n",
       "21.0                   3\n",
       "39.0                   3\n",
       "28.0                   2\n",
       "25.0                   2\n",
       "36.0                   2\n",
       "26.0                   2\n",
       "30.0                   2\n",
       "49.0                   1\n",
       "27.0                   1\n",
       "29.0                   1\n",
       "42.0                   1\n",
       "38.0                   1\n",
       "35.0                   1\n",
       "34.0                   1\n",
       "33.0                   1\n",
       "31.0                   1\n",
       "41.0                   1\n",
       "Name: institute_service, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 32
    }
   ],
   "source": [
    "combined_updated[\"institute_service\"].value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "0.0      20\n",
       "1.0     159\n",
       "2.0      14\n",
       "3.0      83\n",
       "4.0      16\n",
       "5.0      56\n",
       "6.0      17\n",
       "7.0      34\n",
       "8.0       8\n",
       "9.0      14\n",
       "10.0      6\n",
       "11.0     30\n",
       "12.0      6\n",
       "13.0      8\n",
       "14.0      6\n",
       "15.0      7\n",
       "16.0      5\n",
       "17.0      6\n",
       "18.0      5\n",
       "19.0      3\n",
       "20.0     17\n",
       "21.0      3\n",
       "22.0      6\n",
       "23.0      4\n",
       "24.0      4\n",
       "25.0      2\n",
       "26.0      2\n",
       "27.0      1\n",
       "28.0      2\n",
       "29.0      1\n",
       "30.0      2\n",
       "31.0      1\n",
       "32.0      3\n",
       "33.0      1\n",
       "34.0      1\n",
       "35.0      1\n",
       "36.0      2\n",
       "38.0      1\n",
       "39.0      3\n",
       "41.0      1\n",
       "42.0      1\n",
       "49.0      1\n",
       "NaN      88\n",
       "Name: institute_service, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 33
    }
   ],
   "source": [
    "combined_updated[\"institute_service\"] = combined_updated[\"institute_service\"].astype(\"str\")\n",
    "combined_updated[\"institute_service\"] = combined_updated[\"institute_service\"].str.extract(r\"(\\d+)\")\n",
    "combined_updated[\"institute_service\"] = combined_updated[\"institute_service\"].astype(\"float\")\n",
    "combined_updated[\"institute_service\"].value_counts(dropna=False).sort_index(ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to categorize years of service to their own category\n",
    "\n",
    "def cat_yos(yos):\n",
    "    if pd.isnull(yos):\n",
    "        return np.nan\n",
    "    elif yos >= 11:\n",
    "        return \"Veteran\"\n",
    "    elif 7 <= yos < 11:\n",
    "        return \"Established\"\n",
    "    elif 3 <= yos < 7:\n",
    "        return \"Experienced\"\n",
    "    elif yos < 3:\n",
    "        return \"New\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "New            193\n",
       "Experienced    172\n",
       "Veteran        136\n",
       "NaN             88\n",
       "Established     62\n",
       "Name: service_cat, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 35
    }
   ],
   "source": [
    "combined_updated[\"service_cat\"] = combined_updated[\"institute_service\"].apply(cat_yos)\n",
    "combined_updated[\"service_cat\"].value_counts(dropna=False)"
   ]
  },
  {
   "source": [
    "## Perform analysis"
   ],
   "cell_type": "markdown",
   "metadata": {}
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "False    403\n",
       "True     240\n",
       "NaN        8\n",
       "Name: dissatisfied, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 36
    }
   ],
   "source": [
    "combined_updated[\"dissatisfied\"].value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "False    411\n",
       "True     240\n",
       "Name: dissatisfied, dtype: int64"
      ]
     },
     "metadata": {},
     "execution_count": 37
    }
   ],
   "source": [
    "combined_updated[\"dissatisfied\"] = combined_updated[\"dissatisfied\"].fillna(False)\n",
    "combined_updated[\"dissatisfied\"].value_counts(dropna=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "             dissatisfied\n",
       "service_cat              \n",
       "Established      0.516129\n",
       "Experienced      0.343023\n",
       "New              0.295337\n",
       "Veteran          0.485294"
      ],
      "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>dissatisfied</th>\n    </tr>\n    <tr>\n      <th>service_cat</th>\n      <th></th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>Established</th>\n      <td>0.516129</td>\n    </tr>\n    <tr>\n      <th>Experienced</th>\n      <td>0.343023</td>\n    </tr>\n    <tr>\n      <th>New</th>\n      <td>0.295337</td>\n    </tr>\n    <tr>\n      <th>Veteran</th>\n      <td>0.485294</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 38
    }
   ],
   "source": [
    "combined_pv = combined_updated.pivot_table(values=\"dissatisfied\", index=\"service_cat\")\n",
    "combined_pv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "output_type": "display_data",
     "data": {
      "text/plain": "<Figure size 432x288 with 1 Axes>",
      "image/svg+xml": "<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"no\"?>\r\n<!DOCTYPE svg PUBLIC \"-//W3C//DTD SVG 1.1//EN\"\r\n  \"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd\">\r\n<svg height=\"307.077127pt\" version=\"1.1\" viewBox=\"0 0 385.78125 307.077127\" width=\"385.78125pt\" xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\">\r\n <metadata>\r\n  <rdf:RDF xmlns:cc=\"http://creativecommons.org/ns#\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\">\r\n   <cc:Work>\r\n    <dc:type rdf:resource=\"http://purl.org/dc/dcmitype/StillImage\"/>\r\n    <dc:date>2021-04-16T14:35:53.622996</dc:date>\r\n    <dc:format>image/svg+xml</dc:format>\r\n    <dc:creator>\r\n     <cc:Agent>\r\n      <dc:title>Matplotlib v3.4.0, https://matplotlib.org/</dc:title>\r\n     </cc:Agent>\r\n    </dc:creator>\r\n   </cc:Work>\r\n  </rdf:RDF>\r\n </metadata>\r\n <defs>\r\n  <style type=\"text/css\">*{stroke-linecap:butt;stroke-linejoin:round;}</style>\r\n </defs>\r\n <g id=\"figure_1\">\r\n  <g id=\"patch_1\">\r\n   <path d=\"M 0 307.077127 \r\nL 385.78125 307.077127 \r\nL 385.78125 0 \r\nL 0 0 \r\nz\r\n\" style=\"fill:none;\"/>\r\n  </g>\r\n  <g id=\"axes_1\">\r\n   <g id=\"patch_2\">\r\n    <path d=\"M 43.78125 239.758125 \r\nL 378.58125 239.758125 \r\nL 378.58125 22.318125 \r\nL 43.78125 22.318125 \r\nz\r\n\" style=\"fill:#ffffff;\"/>\r\n   </g>\r\n   <g id=\"patch_3\">\r\n    <path clip-path=\"url(#pf27efde7b2)\" d=\"M 64.70625 239.758125 \r\nL 106.55625 239.758125 \r\nL 106.55625 32.672411 \r\nL 64.70625 32.672411 \r\nz\r\n\" style=\"fill:#1f77b4;\"/>\r\n   </g>\r\n   <g id=\"patch_4\">\r\n    <path clip-path=\"url(#pf27efde7b2)\" d=\"M 148.40625 239.758125 \r\nL 190.25625 239.758125 \r\nL 190.25625 102.127394 \r\nL 148.40625 102.127394 \r\nz\r\n\" style=\"fill:#1f77b4;\"/>\r\n   </g>\r\n   <g id=\"patch_5\">\r\n    <path clip-path=\"url(#pf27efde7b2)\" d=\"M 232.10625 239.758125 \r\nL 273.95625 239.758125 \r\nL 273.95625 121.260568 \r\nL 232.10625 121.260568 \r\nz\r\n\" style=\"fill:#1f77b4;\"/>\r\n   </g>\r\n   <g id=\"patch_6\">\r\n    <path clip-path=\"url(#pf27efde7b2)\" d=\"M 315.80625 239.758125 \r\nL 357.65625 239.758125 \r\nL 357.65625 45.044259 \r\nL 315.80625 45.044259 \r\nz\r\n\" style=\"fill:#1f77b4;\"/>\r\n   </g>\r\n   <g id=\"matplotlib.axis_1\">\r\n    <g id=\"xtick_1\">\r\n     <g id=\"line2d_1\">\r\n      <defs>\r\n       <path d=\"M 0 0 \r\nL 0 3.5 \r\n\" id=\"m2853b896fe\" style=\"stroke:#000000;stroke-width:0.8;\"/>\r\n      </defs>\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"85.63125\" xlink:href=\"#m2853b896fe\" y=\"239.758125\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_1\">\r\n      <!-- Established -->\r\n      <g transform=\"translate(62.099852 282.103409)rotate(-30)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 628 4666 \r\nL 3578 4666 \r\nL 3578 4134 \r\nL 1259 4134 \r\nL 1259 2753 \r\nL 3481 2753 \r\nL 3481 2222 \r\nL 1259 2222 \r\nL 1259 531 \r\nL 3634 531 \r\nL 3634 0 \r\nL 628 0 \r\nL 628 4666 \r\nz\r\n\" id=\"DejaVuSans-45\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 2834 3397 \r\nL 2834 2853 \r\nQ 2591 2978 2328 3040 \r\nQ 2066 3103 1784 3103 \r\nQ 1356 3103 1142 2972 \r\nQ 928 2841 928 2578 \r\nQ 928 2378 1081 2264 \r\nQ 1234 2150 1697 2047 \r\nL 1894 2003 \r\nQ 2506 1872 2764 1633 \r\nQ 3022 1394 3022 966 \r\nQ 3022 478 2636 193 \r\nQ 2250 -91 1575 -91 \r\nQ 1294 -91 989 -36 \r\nQ 684 19 347 128 \r\nL 347 722 \r\nQ 666 556 975 473 \r\nQ 1284 391 1588 391 \r\nQ 1994 391 2212 530 \r\nQ 2431 669 2431 922 \r\nQ 2431 1156 2273 1281 \r\nQ 2116 1406 1581 1522 \r\nL 1381 1569 \r\nQ 847 1681 609 1914 \r\nQ 372 2147 372 2553 \r\nQ 372 3047 722 3315 \r\nQ 1072 3584 1716 3584 \r\nQ 2034 3584 2315 3537 \r\nQ 2597 3491 2834 3397 \r\nz\r\n\" id=\"DejaVuSans-73\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 1172 4494 \r\nL 1172 3500 \r\nL 2356 3500 \r\nL 2356 3053 \r\nL 1172 3053 \r\nL 1172 1153 \r\nQ 1172 725 1289 603 \r\nQ 1406 481 1766 481 \r\nL 2356 481 \r\nL 2356 0 \r\nL 1766 0 \r\nQ 1100 0 847 248 \r\nQ 594 497 594 1153 \r\nL 594 3053 \r\nL 172 3053 \r\nL 172 3500 \r\nL 594 3500 \r\nL 594 4494 \r\nL 1172 4494 \r\nz\r\n\" id=\"DejaVuSans-74\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 2194 1759 \r\nQ 1497 1759 1228 1600 \r\nQ 959 1441 959 1056 \r\nQ 959 750 1161 570 \r\nQ 1363 391 1709 391 \r\nQ 2188 391 2477 730 \r\nQ 2766 1069 2766 1631 \r\nL 2766 1759 \r\nL 2194 1759 \r\nz\r\nM 3341 1997 \r\nL 3341 0 \r\nL 2766 0 \r\nL 2766 531 \r\nQ 2569 213 2275 61 \r\nQ 1981 -91 1556 -91 \r\nQ 1019 -91 701 211 \r\nQ 384 513 384 1019 \r\nQ 384 1609 779 1909 \r\nQ 1175 2209 1959 2209 \r\nL 2766 2209 \r\nL 2766 2266 \r\nQ 2766 2663 2505 2880 \r\nQ 2244 3097 1772 3097 \r\nQ 1472 3097 1187 3025 \r\nQ 903 2953 641 2809 \r\nL 641 3341 \r\nQ 956 3463 1253 3523 \r\nQ 1550 3584 1831 3584 \r\nQ 2591 3584 2966 3190 \r\nQ 3341 2797 3341 1997 \r\nz\r\n\" id=\"DejaVuSans-61\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 3116 1747 \r\nQ 3116 2381 2855 2742 \r\nQ 2594 3103 2138 3103 \r\nQ 1681 3103 1420 2742 \r\nQ 1159 2381 1159 1747 \r\nQ 1159 1113 1420 752 \r\nQ 1681 391 2138 391 \r\nQ 2594 391 2855 752 \r\nQ 3116 1113 3116 1747 \r\nz\r\nM 1159 2969 \r\nQ 1341 3281 1617 3432 \r\nQ 1894 3584 2278 3584 \r\nQ 2916 3584 3314 3078 \r\nQ 3713 2572 3713 1747 \r\nQ 3713 922 3314 415 \r\nQ 2916 -91 2278 -91 \r\nQ 1894 -91 1617 61 \r\nQ 1341 213 1159 525 \r\nL 1159 0 \r\nL 581 0 \r\nL 581 4863 \r\nL 1159 4863 \r\nL 1159 2969 \r\nz\r\n\" id=\"DejaVuSans-62\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 603 4863 \r\nL 1178 4863 \r\nL 1178 0 \r\nL 603 0 \r\nL 603 4863 \r\nz\r\n\" id=\"DejaVuSans-6c\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 603 3500 \r\nL 1178 3500 \r\nL 1178 0 \r\nL 603 0 \r\nL 603 3500 \r\nz\r\nM 603 4863 \r\nL 1178 4863 \r\nL 1178 4134 \r\nL 603 4134 \r\nL 603 4863 \r\nz\r\n\" id=\"DejaVuSans-69\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 3513 2113 \r\nL 3513 0 \r\nL 2938 0 \r\nL 2938 2094 \r\nQ 2938 2591 2744 2837 \r\nQ 2550 3084 2163 3084 \r\nQ 1697 3084 1428 2787 \r\nQ 1159 2491 1159 1978 \r\nL 1159 0 \r\nL 581 0 \r\nL 581 4863 \r\nL 1159 4863 \r\nL 1159 2956 \r\nQ 1366 3272 1645 3428 \r\nQ 1925 3584 2291 3584 \r\nQ 2894 3584 3203 3211 \r\nQ 3513 2838 3513 2113 \r\nz\r\n\" id=\"DejaVuSans-68\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 3597 1894 \r\nL 3597 1613 \r\nL 953 1613 \r\nQ 991 1019 1311 708 \r\nQ 1631 397 2203 397 \r\nQ 2534 397 2845 478 \r\nQ 3156 559 3463 722 \r\nL 3463 178 \r\nQ 3153 47 2828 -22 \r\nQ 2503 -91 2169 -91 \r\nQ 1331 -91 842 396 \r\nQ 353 884 353 1716 \r\nQ 353 2575 817 3079 \r\nQ 1281 3584 2069 3584 \r\nQ 2775 3584 3186 3129 \r\nQ 3597 2675 3597 1894 \r\nz\r\nM 3022 2063 \r\nQ 3016 2534 2758 2815 \r\nQ 2500 3097 2075 3097 \r\nQ 1594 3097 1305 2825 \r\nQ 1016 2553 972 2059 \r\nL 3022 2063 \r\nz\r\n\" id=\"DejaVuSans-65\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 2906 2969 \r\nL 2906 4863 \r\nL 3481 4863 \r\nL 3481 0 \r\nL 2906 0 \r\nL 2906 525 \r\nQ 2725 213 2448 61 \r\nQ 2172 -91 1784 -91 \r\nQ 1150 -91 751 415 \r\nQ 353 922 353 1747 \r\nQ 353 2572 751 3078 \r\nQ 1150 3584 1784 3584 \r\nQ 2172 3584 2448 3432 \r\nQ 2725 3281 2906 2969 \r\nz\r\nM 947 1747 \r\nQ 947 1113 1208 752 \r\nQ 1469 391 1925 391 \r\nQ 2381 391 2643 752 \r\nQ 2906 1113 2906 1747 \r\nQ 2906 2381 2643 2742 \r\nQ 2381 3103 1925 3103 \r\nQ 1469 3103 1208 2742 \r\nQ 947 2381 947 1747 \r\nz\r\n\" id=\"DejaVuSans-64\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-45\"/>\r\n       <use x=\"63.183594\" xlink:href=\"#DejaVuSans-73\"/>\r\n       <use x=\"115.283203\" xlink:href=\"#DejaVuSans-74\"/>\r\n       <use x=\"154.492188\" xlink:href=\"#DejaVuSans-61\"/>\r\n       <use x=\"215.771484\" xlink:href=\"#DejaVuSans-62\"/>\r\n       <use x=\"279.248047\" xlink:href=\"#DejaVuSans-6c\"/>\r\n       <use x=\"307.03125\" xlink:href=\"#DejaVuSans-69\"/>\r\n       <use x=\"334.814453\" xlink:href=\"#DejaVuSans-73\"/>\r\n       <use x=\"386.914062\" xlink:href=\"#DejaVuSans-68\"/>\r\n       <use x=\"450.292969\" xlink:href=\"#DejaVuSans-65\"/>\r\n       <use x=\"511.816406\" xlink:href=\"#DejaVuSans-64\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_2\">\r\n     <g id=\"line2d_2\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"169.33125\" xlink:href=\"#m2853b896fe\" y=\"239.758125\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_2\">\r\n      <!-- Experienced -->\r\n      <g transform=\"translate(143.81273 284.39794)rotate(-30)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 3513 3500 \r\nL 2247 1797 \r\nL 3578 0 \r\nL 2900 0 \r\nL 1881 1375 \r\nL 863 0 \r\nL 184 0 \r\nL 1544 1831 \r\nL 300 3500 \r\nL 978 3500 \r\nL 1906 2253 \r\nL 2834 3500 \r\nL 3513 3500 \r\nz\r\n\" id=\"DejaVuSans-78\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 1159 525 \r\nL 1159 -1331 \r\nL 581 -1331 \r\nL 581 3500 \r\nL 1159 3500 \r\nL 1159 2969 \r\nQ 1341 3281 1617 3432 \r\nQ 1894 3584 2278 3584 \r\nQ 2916 3584 3314 3078 \r\nQ 3713 2572 3713 1747 \r\nQ 3713 922 3314 415 \r\nQ 2916 -91 2278 -91 \r\nQ 1894 -91 1617 61 \r\nQ 1341 213 1159 525 \r\nz\r\nM 3116 1747 \r\nQ 3116 2381 2855 2742 \r\nQ 2594 3103 2138 3103 \r\nQ 1681 3103 1420 2742 \r\nQ 1159 2381 1159 1747 \r\nQ 1159 1113 1420 752 \r\nQ 1681 391 2138 391 \r\nQ 2594 391 2855 752 \r\nQ 3116 1113 3116 1747 \r\nz\r\n\" id=\"DejaVuSans-70\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 2631 2963 \r\nQ 2534 3019 2420 3045 \r\nQ 2306 3072 2169 3072 \r\nQ 1681 3072 1420 2755 \r\nQ 1159 2438 1159 1844 \r\nL 1159 0 \r\nL 581 0 \r\nL 581 3500 \r\nL 1159 3500 \r\nL 1159 2956 \r\nQ 1341 3275 1631 3429 \r\nQ 1922 3584 2338 3584 \r\nQ 2397 3584 2469 3576 \r\nQ 2541 3569 2628 3553 \r\nL 2631 2963 \r\nz\r\n\" id=\"DejaVuSans-72\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 3513 2113 \r\nL 3513 0 \r\nL 2938 0 \r\nL 2938 2094 \r\nQ 2938 2591 2744 2837 \r\nQ 2550 3084 2163 3084 \r\nQ 1697 3084 1428 2787 \r\nQ 1159 2491 1159 1978 \r\nL 1159 0 \r\nL 581 0 \r\nL 581 3500 \r\nL 1159 3500 \r\nL 1159 2956 \r\nQ 1366 3272 1645 3428 \r\nQ 1925 3584 2291 3584 \r\nQ 2894 3584 3203 3211 \r\nQ 3513 2838 3513 2113 \r\nz\r\n\" id=\"DejaVuSans-6e\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 3122 3366 \r\nL 3122 2828 \r\nQ 2878 2963 2633 3030 \r\nQ 2388 3097 2138 3097 \r\nQ 1578 3097 1268 2742 \r\nQ 959 2388 959 1747 \r\nQ 959 1106 1268 751 \r\nQ 1578 397 2138 397 \r\nQ 2388 397 2633 464 \r\nQ 2878 531 3122 666 \r\nL 3122 134 \r\nQ 2881 22 2623 -34 \r\nQ 2366 -91 2075 -91 \r\nQ 1284 -91 818 406 \r\nQ 353 903 353 1747 \r\nQ 353 2603 823 3093 \r\nQ 1294 3584 2113 3584 \r\nQ 2378 3584 2631 3529 \r\nQ 2884 3475 3122 3366 \r\nz\r\n\" id=\"DejaVuSans-63\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-45\"/>\r\n       <use x=\"63.183594\" xlink:href=\"#DejaVuSans-78\"/>\r\n       <use x=\"122.363281\" xlink:href=\"#DejaVuSans-70\"/>\r\n       <use x=\"185.839844\" xlink:href=\"#DejaVuSans-65\"/>\r\n       <use x=\"247.363281\" xlink:href=\"#DejaVuSans-72\"/>\r\n       <use x=\"288.476562\" xlink:href=\"#DejaVuSans-69\"/>\r\n       <use x=\"316.259766\" xlink:href=\"#DejaVuSans-65\"/>\r\n       <use x=\"377.783203\" xlink:href=\"#DejaVuSans-6e\"/>\r\n       <use x=\"441.162109\" xlink:href=\"#DejaVuSans-63\"/>\r\n       <use x=\"496.142578\" xlink:href=\"#DejaVuSans-65\"/>\r\n       <use x=\"557.666016\" xlink:href=\"#DejaVuSans-64\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_3\">\r\n     <g id=\"line2d_3\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"253.03125\" xlink:href=\"#m2853b896fe\" y=\"239.758125\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_3\">\r\n      <!-- New -->\r\n      <g transform=\"translate(244.965848 264.244815)rotate(-30)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 628 4666 \r\nL 1478 4666 \r\nL 3547 763 \r\nL 3547 4666 \r\nL 4159 4666 \r\nL 4159 0 \r\nL 3309 0 \r\nL 1241 3903 \r\nL 1241 0 \r\nL 628 0 \r\nL 628 4666 \r\nz\r\n\" id=\"DejaVuSans-4e\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 269 3500 \r\nL 844 3500 \r\nL 1563 769 \r\nL 2278 3500 \r\nL 2956 3500 \r\nL 3675 769 \r\nL 4391 3500 \r\nL 4966 3500 \r\nL 4050 0 \r\nL 3372 0 \r\nL 2619 2869 \r\nL 1863 0 \r\nL 1184 0 \r\nL 269 3500 \r\nz\r\n\" id=\"DejaVuSans-77\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-4e\"/>\r\n       <use x=\"74.804688\" xlink:href=\"#DejaVuSans-65\"/>\r\n       <use x=\"136.328125\" xlink:href=\"#DejaVuSans-77\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"xtick_4\">\r\n     <g id=\"line2d_4\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"336.73125\" xlink:href=\"#m2853b896fe\" y=\"239.758125\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_4\">\r\n      <!-- Veteran -->\r\n      <g transform=\"translate(321.280275 272.77294)rotate(-30)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 1831 0 \r\nL 50 4666 \r\nL 709 4666 \r\nL 2188 738 \r\nL 3669 4666 \r\nL 4325 4666 \r\nL 2547 0 \r\nL 1831 0 \r\nz\r\n\" id=\"DejaVuSans-56\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-56\"/>\r\n       <use x=\"60.658203\" xlink:href=\"#DejaVuSans-65\"/>\r\n       <use x=\"122.181641\" xlink:href=\"#DejaVuSans-74\"/>\r\n       <use x=\"161.390625\" xlink:href=\"#DejaVuSans-65\"/>\r\n       <use x=\"222.914062\" xlink:href=\"#DejaVuSans-72\"/>\r\n       <use x=\"264.027344\" xlink:href=\"#DejaVuSans-61\"/>\r\n       <use x=\"325.306641\" xlink:href=\"#DejaVuSans-6e\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"text_5\">\r\n     <!-- Service Category -->\r\n     <g transform=\"translate(168.271094 297.79744)scale(0.1 -0.1)\">\r\n      <defs>\r\n       <path d=\"M 3425 4513 \r\nL 3425 3897 \r\nQ 3066 4069 2747 4153 \r\nQ 2428 4238 2131 4238 \r\nQ 1616 4238 1336 4038 \r\nQ 1056 3838 1056 3469 \r\nQ 1056 3159 1242 3001 \r\nQ 1428 2844 1947 2747 \r\nL 2328 2669 \r\nQ 3034 2534 3370 2195 \r\nQ 3706 1856 3706 1288 \r\nQ 3706 609 3251 259 \r\nQ 2797 -91 1919 -91 \r\nQ 1588 -91 1214 -16 \r\nQ 841 59 441 206 \r\nL 441 856 \r\nQ 825 641 1194 531 \r\nQ 1563 422 1919 422 \r\nQ 2459 422 2753 634 \r\nQ 3047 847 3047 1241 \r\nQ 3047 1584 2836 1778 \r\nQ 2625 1972 2144 2069 \r\nL 1759 2144 \r\nQ 1053 2284 737 2584 \r\nQ 422 2884 422 3419 \r\nQ 422 4038 858 4394 \r\nQ 1294 4750 2059 4750 \r\nQ 2388 4750 2728 4690 \r\nQ 3069 4631 3425 4513 \r\nz\r\n\" id=\"DejaVuSans-53\" transform=\"scale(0.015625)\"/>\r\n       <path d=\"M 191 3500 \r\nL 800 3500 \r\nL 1894 563 \r\nL 2988 3500 \r\nL 3597 3500 \r\nL 2284 0 \r\nL 1503 0 \r\nL 191 3500 \r\nz\r\n\" id=\"DejaVuSans-76\" transform=\"scale(0.015625)\"/>\r\n       <path id=\"DejaVuSans-20\" transform=\"scale(0.015625)\"/>\r\n       <path d=\"M 4122 4306 \r\nL 4122 3641 \r\nQ 3803 3938 3442 4084 \r\nQ 3081 4231 2675 4231 \r\nQ 1875 4231 1450 3742 \r\nQ 1025 3253 1025 2328 \r\nQ 1025 1406 1450 917 \r\nQ 1875 428 2675 428 \r\nQ 3081 428 3442 575 \r\nQ 3803 722 4122 1019 \r\nL 4122 359 \r\nQ 3791 134 3420 21 \r\nQ 3050 -91 2638 -91 \r\nQ 1578 -91 968 557 \r\nQ 359 1206 359 2328 \r\nQ 359 3453 968 4101 \r\nQ 1578 4750 2638 4750 \r\nQ 3056 4750 3426 4639 \r\nQ 3797 4528 4122 4306 \r\nz\r\n\" id=\"DejaVuSans-43\" transform=\"scale(0.015625)\"/>\r\n       <path d=\"M 2906 1791 \r\nQ 2906 2416 2648 2759 \r\nQ 2391 3103 1925 3103 \r\nQ 1463 3103 1205 2759 \r\nQ 947 2416 947 1791 \r\nQ 947 1169 1205 825 \r\nQ 1463 481 1925 481 \r\nQ 2391 481 2648 825 \r\nQ 2906 1169 2906 1791 \r\nz\r\nM 3481 434 \r\nQ 3481 -459 3084 -895 \r\nQ 2688 -1331 1869 -1331 \r\nQ 1566 -1331 1297 -1286 \r\nQ 1028 -1241 775 -1147 \r\nL 775 -588 \r\nQ 1028 -725 1275 -790 \r\nQ 1522 -856 1778 -856 \r\nQ 2344 -856 2625 -561 \r\nQ 2906 -266 2906 331 \r\nL 2906 616 \r\nQ 2728 306 2450 153 \r\nQ 2172 0 1784 0 \r\nQ 1141 0 747 490 \r\nQ 353 981 353 1791 \r\nQ 353 2603 747 3093 \r\nQ 1141 3584 1784 3584 \r\nQ 2172 3584 2450 3431 \r\nQ 2728 3278 2906 2969 \r\nL 2906 3500 \r\nL 3481 3500 \r\nL 3481 434 \r\nz\r\n\" id=\"DejaVuSans-67\" transform=\"scale(0.015625)\"/>\r\n       <path d=\"M 1959 3097 \r\nQ 1497 3097 1228 2736 \r\nQ 959 2375 959 1747 \r\nQ 959 1119 1226 758 \r\nQ 1494 397 1959 397 \r\nQ 2419 397 2687 759 \r\nQ 2956 1122 2956 1747 \r\nQ 2956 2369 2687 2733 \r\nQ 2419 3097 1959 3097 \r\nz\r\nM 1959 3584 \r\nQ 2709 3584 3137 3096 \r\nQ 3566 2609 3566 1747 \r\nQ 3566 888 3137 398 \r\nQ 2709 -91 1959 -91 \r\nQ 1206 -91 779 398 \r\nQ 353 888 353 1747 \r\nQ 353 2609 779 3096 \r\nQ 1206 3584 1959 3584 \r\nz\r\n\" id=\"DejaVuSans-6f\" transform=\"scale(0.015625)\"/>\r\n       <path d=\"M 2059 -325 \r\nQ 1816 -950 1584 -1140 \r\nQ 1353 -1331 966 -1331 \r\nL 506 -1331 \r\nL 506 -850 \r\nL 844 -850 \r\nQ 1081 -850 1212 -737 \r\nQ 1344 -625 1503 -206 \r\nL 1606 56 \r\nL 191 3500 \r\nL 800 3500 \r\nL 1894 763 \r\nL 2988 3500 \r\nL 3597 3500 \r\nL 2059 -325 \r\nz\r\n\" id=\"DejaVuSans-79\" transform=\"scale(0.015625)\"/>\r\n      </defs>\r\n      <use xlink:href=\"#DejaVuSans-53\"/>\r\n      <use x=\"63.476562\" xlink:href=\"#DejaVuSans-65\"/>\r\n      <use x=\"125\" xlink:href=\"#DejaVuSans-72\"/>\r\n      <use x=\"166.113281\" xlink:href=\"#DejaVuSans-76\"/>\r\n      <use x=\"225.292969\" xlink:href=\"#DejaVuSans-69\"/>\r\n      <use x=\"253.076172\" xlink:href=\"#DejaVuSans-63\"/>\r\n      <use x=\"308.056641\" xlink:href=\"#DejaVuSans-65\"/>\r\n      <use x=\"369.580078\" xlink:href=\"#DejaVuSans-20\"/>\r\n      <use x=\"401.367188\" xlink:href=\"#DejaVuSans-43\"/>\r\n      <use x=\"471.191406\" xlink:href=\"#DejaVuSans-61\"/>\r\n      <use x=\"532.470703\" xlink:href=\"#DejaVuSans-74\"/>\r\n      <use x=\"571.679688\" xlink:href=\"#DejaVuSans-65\"/>\r\n      <use x=\"633.203125\" xlink:href=\"#DejaVuSans-67\"/>\r\n      <use x=\"696.679688\" xlink:href=\"#DejaVuSans-6f\"/>\r\n      <use x=\"757.861328\" xlink:href=\"#DejaVuSans-72\"/>\r\n      <use x=\"798.974609\" xlink:href=\"#DejaVuSans-79\"/>\r\n     </g>\r\n    </g>\r\n   </g>\r\n   <g id=\"matplotlib.axis_2\">\r\n    <g id=\"ytick_1\">\r\n     <g id=\"line2d_5\">\r\n      <defs>\r\n       <path d=\"M 0 0 \r\nL -3.5 0 \r\n\" id=\"m1e1522b23b\" style=\"stroke:#000000;stroke-width:0.8;\"/>\r\n      </defs>\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#m1e1522b23b\" y=\"239.758125\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_6\">\r\n      <!-- 0.0 -->\r\n      <g transform=\"translate(20.878125 243.557344)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 2034 4250 \r\nQ 1547 4250 1301 3770 \r\nQ 1056 3291 1056 2328 \r\nQ 1056 1369 1301 889 \r\nQ 1547 409 2034 409 \r\nQ 2525 409 2770 889 \r\nQ 3016 1369 3016 2328 \r\nQ 3016 3291 2770 3770 \r\nQ 2525 4250 2034 4250 \r\nz\r\nM 2034 4750 \r\nQ 2819 4750 3233 4129 \r\nQ 3647 3509 3647 2328 \r\nQ 3647 1150 3233 529 \r\nQ 2819 -91 2034 -91 \r\nQ 1250 -91 836 529 \r\nQ 422 1150 422 2328 \r\nQ 422 3509 836 4129 \r\nQ 1250 4750 2034 4750 \r\nz\r\n\" id=\"DejaVuSans-30\" transform=\"scale(0.015625)\"/>\r\n        <path d=\"M 684 794 \r\nL 1344 794 \r\nL 1344 0 \r\nL 684 0 \r\nL 684 794 \r\nz\r\n\" id=\"DejaVuSans-2e\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-30\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-2e\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-30\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_2\">\r\n     <g id=\"line2d_6\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#m1e1522b23b\" y=\"199.635268\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_7\">\r\n      <!-- 0.1 -->\r\n      <g transform=\"translate(20.878125 203.434487)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 794 531 \r\nL 1825 531 \r\nL 1825 4091 \r\nL 703 3866 \r\nL 703 4441 \r\nL 1819 4666 \r\nL 2450 4666 \r\nL 2450 531 \r\nL 3481 531 \r\nL 3481 0 \r\nL 794 0 \r\nL 794 531 \r\nz\r\n\" id=\"DejaVuSans-31\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-30\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-2e\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-31\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_3\">\r\n     <g id=\"line2d_7\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#m1e1522b23b\" y=\"159.512411\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_8\">\r\n      <!-- 0.2 -->\r\n      <g transform=\"translate(20.878125 163.311629)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 1228 531 \r\nL 3431 531 \r\nL 3431 0 \r\nL 469 0 \r\nL 469 531 \r\nQ 828 903 1448 1529 \r\nQ 2069 2156 2228 2338 \r\nQ 2531 2678 2651 2914 \r\nQ 2772 3150 2772 3378 \r\nQ 2772 3750 2511 3984 \r\nQ 2250 4219 1831 4219 \r\nQ 1534 4219 1204 4116 \r\nQ 875 4013 500 3803 \r\nL 500 4441 \r\nQ 881 4594 1212 4672 \r\nQ 1544 4750 1819 4750 \r\nQ 2544 4750 2975 4387 \r\nQ 3406 4025 3406 3419 \r\nQ 3406 3131 3298 2873 \r\nQ 3191 2616 2906 2266 \r\nQ 2828 2175 2409 1742 \r\nQ 1991 1309 1228 531 \r\nz\r\n\" id=\"DejaVuSans-32\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-30\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-2e\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-32\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_4\">\r\n     <g id=\"line2d_8\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#m1e1522b23b\" y=\"119.389554\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_9\">\r\n      <!-- 0.3 -->\r\n      <g transform=\"translate(20.878125 123.188772)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 2597 2516 \r\nQ 3050 2419 3304 2112 \r\nQ 3559 1806 3559 1356 \r\nQ 3559 666 3084 287 \r\nQ 2609 -91 1734 -91 \r\nQ 1441 -91 1130 -33 \r\nQ 819 25 488 141 \r\nL 488 750 \r\nQ 750 597 1062 519 \r\nQ 1375 441 1716 441 \r\nQ 2309 441 2620 675 \r\nQ 2931 909 2931 1356 \r\nQ 2931 1769 2642 2001 \r\nQ 2353 2234 1838 2234 \r\nL 1294 2234 \r\nL 1294 2753 \r\nL 1863 2753 \r\nQ 2328 2753 2575 2939 \r\nQ 2822 3125 2822 3475 \r\nQ 2822 3834 2567 4026 \r\nQ 2313 4219 1838 4219 \r\nQ 1578 4219 1281 4162 \r\nQ 984 4106 628 3988 \r\nL 628 4550 \r\nQ 988 4650 1302 4700 \r\nQ 1616 4750 1894 4750 \r\nQ 2613 4750 3031 4423 \r\nQ 3450 4097 3450 3541 \r\nQ 3450 3153 3228 2886 \r\nQ 3006 2619 2597 2516 \r\nz\r\n\" id=\"DejaVuSans-33\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-30\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-2e\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-33\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_5\">\r\n     <g id=\"line2d_9\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#m1e1522b23b\" y=\"79.266696\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_10\">\r\n      <!-- 0.4 -->\r\n      <g transform=\"translate(20.878125 83.065915)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 2419 4116 \r\nL 825 1625 \r\nL 2419 1625 \r\nL 2419 4116 \r\nz\r\nM 2253 4666 \r\nL 3047 4666 \r\nL 3047 1625 \r\nL 3713 1625 \r\nL 3713 1100 \r\nL 3047 1100 \r\nL 3047 0 \r\nL 2419 0 \r\nL 2419 1100 \r\nL 313 1100 \r\nL 313 1709 \r\nL 2253 4666 \r\nz\r\n\" id=\"DejaVuSans-34\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-30\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-2e\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-34\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"ytick_6\">\r\n     <g id=\"line2d_10\">\r\n      <g>\r\n       <use style=\"stroke:#000000;stroke-width:0.8;\" x=\"43.78125\" xlink:href=\"#m1e1522b23b\" y=\"39.143839\"/>\r\n      </g>\r\n     </g>\r\n     <g id=\"text_11\">\r\n      <!-- 0.5 -->\r\n      <g transform=\"translate(20.878125 42.943058)scale(0.1 -0.1)\">\r\n       <defs>\r\n        <path d=\"M 691 4666 \r\nL 3169 4666 \r\nL 3169 4134 \r\nL 1269 4134 \r\nL 1269 2991 \r\nQ 1406 3038 1543 3061 \r\nQ 1681 3084 1819 3084 \r\nQ 2600 3084 3056 2656 \r\nQ 3513 2228 3513 1497 \r\nQ 3513 744 3044 326 \r\nQ 2575 -91 1722 -91 \r\nQ 1428 -91 1123 -41 \r\nQ 819 9 494 109 \r\nL 494 744 \r\nQ 775 591 1075 516 \r\nQ 1375 441 1709 441 \r\nQ 2250 441 2565 725 \r\nQ 2881 1009 2881 1497 \r\nQ 2881 1984 2565 2268 \r\nQ 2250 2553 1709 2553 \r\nQ 1456 2553 1204 2497 \r\nQ 953 2441 691 2322 \r\nL 691 4666 \r\nz\r\n\" id=\"DejaVuSans-35\" transform=\"scale(0.015625)\"/>\r\n       </defs>\r\n       <use xlink:href=\"#DejaVuSans-30\"/>\r\n       <use x=\"63.623047\" xlink:href=\"#DejaVuSans-2e\"/>\r\n       <use x=\"95.410156\" xlink:href=\"#DejaVuSans-35\"/>\r\n      </g>\r\n     </g>\r\n    </g>\r\n    <g id=\"text_12\">\r\n     <!-- % of dissatisfied employees -->\r\n     <g transform=\"translate(14.798438 200.852969)rotate(-90)scale(0.1 -0.1)\">\r\n      <defs>\r\n       <path d=\"M 4653 2053 \r\nQ 4381 2053 4226 1822 \r\nQ 4072 1591 4072 1178 \r\nQ 4072 772 4226 539 \r\nQ 4381 306 4653 306 \r\nQ 4919 306 5073 539 \r\nQ 5228 772 5228 1178 \r\nQ 5228 1588 5073 1820 \r\nQ 4919 2053 4653 2053 \r\nz\r\nM 4653 2450 \r\nQ 5147 2450 5437 2106 \r\nQ 5728 1763 5728 1178 \r\nQ 5728 594 5436 251 \r\nQ 5144 -91 4653 -91 \r\nQ 4153 -91 3862 251 \r\nQ 3572 594 3572 1178 \r\nQ 3572 1766 3864 2108 \r\nQ 4156 2450 4653 2450 \r\nz\r\nM 1428 4353 \r\nQ 1159 4353 1004 4120 \r\nQ 850 3888 850 3481 \r\nQ 850 3069 1003 2837 \r\nQ 1156 2606 1428 2606 \r\nQ 1700 2606 1854 2837 \r\nQ 2009 3069 2009 3481 \r\nQ 2009 3884 1853 4118 \r\nQ 1697 4353 1428 4353 \r\nz\r\nM 4250 4750 \r\nL 4750 4750 \r\nL 1831 -91 \r\nL 1331 -91 \r\nL 4250 4750 \r\nz\r\nM 1428 4750 \r\nQ 1922 4750 2215 4408 \r\nQ 2509 4066 2509 3481 \r\nQ 2509 2891 2217 2550 \r\nQ 1925 2209 1428 2209 \r\nQ 931 2209 642 2551 \r\nQ 353 2894 353 3481 \r\nQ 353 4063 643 4406 \r\nQ 934 4750 1428 4750 \r\nz\r\n\" id=\"DejaVuSans-25\" transform=\"scale(0.015625)\"/>\r\n       <path d=\"M 2375 4863 \r\nL 2375 4384 \r\nL 1825 4384 \r\nQ 1516 4384 1395 4259 \r\nQ 1275 4134 1275 3809 \r\nL 1275 3500 \r\nL 2222 3500 \r\nL 2222 3053 \r\nL 1275 3053 \r\nL 1275 0 \r\nL 697 0 \r\nL 697 3053 \r\nL 147 3053 \r\nL 147 3500 \r\nL 697 3500 \r\nL 697 3744 \r\nQ 697 4328 969 4595 \r\nQ 1241 4863 1831 4863 \r\nL 2375 4863 \r\nz\r\n\" id=\"DejaVuSans-66\" transform=\"scale(0.015625)\"/>\r\n       <path d=\"M 3328 2828 \r\nQ 3544 3216 3844 3400 \r\nQ 4144 3584 4550 3584 \r\nQ 5097 3584 5394 3201 \r\nQ 5691 2819 5691 2113 \r\nL 5691 0 \r\nL 5113 0 \r\nL 5113 2094 \r\nQ 5113 2597 4934 2840 \r\nQ 4756 3084 4391 3084 \r\nQ 3944 3084 3684 2787 \r\nQ 3425 2491 3425 1978 \r\nL 3425 0 \r\nL 2847 0 \r\nL 2847 2094 \r\nQ 2847 2600 2669 2842 \r\nQ 2491 3084 2119 3084 \r\nQ 1678 3084 1418 2786 \r\nQ 1159 2488 1159 1978 \r\nL 1159 0 \r\nL 581 0 \r\nL 581 3500 \r\nL 1159 3500 \r\nL 1159 2956 \r\nQ 1356 3278 1631 3431 \r\nQ 1906 3584 2284 3584 \r\nQ 2666 3584 2933 3390 \r\nQ 3200 3197 3328 2828 \r\nz\r\n\" id=\"DejaVuSans-6d\" transform=\"scale(0.015625)\"/>\r\n      </defs>\r\n      <use xlink:href=\"#DejaVuSans-25\"/>\r\n      <use x=\"95.019531\" xlink:href=\"#DejaVuSans-20\"/>\r\n      <use x=\"126.806641\" xlink:href=\"#DejaVuSans-6f\"/>\r\n      <use x=\"187.988281\" xlink:href=\"#DejaVuSans-66\"/>\r\n      <use x=\"223.193359\" xlink:href=\"#DejaVuSans-20\"/>\r\n      <use x=\"254.980469\" xlink:href=\"#DejaVuSans-64\"/>\r\n      <use x=\"318.457031\" xlink:href=\"#DejaVuSans-69\"/>\r\n      <use x=\"346.240234\" xlink:href=\"#DejaVuSans-73\"/>\r\n      <use x=\"398.339844\" xlink:href=\"#DejaVuSans-73\"/>\r\n      <use x=\"450.439453\" xlink:href=\"#DejaVuSans-61\"/>\r\n      <use x=\"511.71875\" xlink:href=\"#DejaVuSans-74\"/>\r\n      <use x=\"550.927734\" xlink:href=\"#DejaVuSans-69\"/>\r\n      <use x=\"578.710938\" xlink:href=\"#DejaVuSans-73\"/>\r\n      <use x=\"630.810547\" xlink:href=\"#DejaVuSans-66\"/>\r\n      <use x=\"666.015625\" xlink:href=\"#DejaVuSans-69\"/>\r\n      <use x=\"693.798828\" xlink:href=\"#DejaVuSans-65\"/>\r\n      <use x=\"755.322266\" xlink:href=\"#DejaVuSans-64\"/>\r\n      <use x=\"818.798828\" xlink:href=\"#DejaVuSans-20\"/>\r\n      <use x=\"850.585938\" xlink:href=\"#DejaVuSans-65\"/>\r\n      <use x=\"912.109375\" xlink:href=\"#DejaVuSans-6d\"/>\r\n      <use x=\"1009.521484\" xlink:href=\"#DejaVuSans-70\"/>\r\n      <use x=\"1072.998047\" xlink:href=\"#DejaVuSans-6c\"/>\r\n      <use x=\"1100.78125\" xlink:href=\"#DejaVuSans-6f\"/>\r\n      <use x=\"1161.962891\" xlink:href=\"#DejaVuSans-79\"/>\r\n      <use x=\"1221.142578\" xlink:href=\"#DejaVuSans-65\"/>\r\n      <use x=\"1282.666016\" xlink:href=\"#DejaVuSans-65\"/>\r\n      <use x=\"1344.189453\" xlink:href=\"#DejaVuSans-73\"/>\r\n     </g>\r\n    </g>\r\n   </g>\r\n   <g id=\"patch_7\">\r\n    <path d=\"M 43.78125 239.758125 \r\nL 43.78125 22.318125 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_8\">\r\n    <path d=\"M 378.58125 239.758125 \r\nL 378.58125 22.318125 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_9\">\r\n    <path d=\"M 43.78125 239.758125 \r\nL 378.58125 239.758125 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"patch_10\">\r\n    <path d=\"M 43.78125 22.318125 \r\nL 378.58125 22.318125 \r\n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;stroke-width:0.8;\"/>\r\n   </g>\r\n   <g id=\"text_13\">\r\n    <!-- Percentage of dissatisfied employees -->\r\n    <g transform=\"translate(99.357188 16.318125)scale(0.12 -0.12)\">\r\n     <defs>\r\n      <path d=\"M 1259 4147 \r\nL 1259 2394 \r\nL 2053 2394 \r\nQ 2494 2394 2734 2622 \r\nQ 2975 2850 2975 3272 \r\nQ 2975 3691 2734 3919 \r\nQ 2494 4147 2053 4147 \r\nL 1259 4147 \r\nz\r\nM 628 4666 \r\nL 2053 4666 \r\nQ 2838 4666 3239 4311 \r\nQ 3641 3956 3641 3272 \r\nQ 3641 2581 3239 2228 \r\nQ 2838 1875 2053 1875 \r\nL 1259 1875 \r\nL 1259 0 \r\nL 628 0 \r\nL 628 4666 \r\nz\r\n\" id=\"DejaVuSans-50\" transform=\"scale(0.015625)\"/>\r\n     </defs>\r\n     <use xlink:href=\"#DejaVuSans-50\"/>\r\n     <use x=\"56.677734\" xlink:href=\"#DejaVuSans-65\"/>\r\n     <use x=\"118.201172\" xlink:href=\"#DejaVuSans-72\"/>\r\n     <use x=\"157.064453\" xlink:href=\"#DejaVuSans-63\"/>\r\n     <use x=\"212.044922\" xlink:href=\"#DejaVuSans-65\"/>\r\n     <use x=\"273.568359\" xlink:href=\"#DejaVuSans-6e\"/>\r\n     <use x=\"336.947266\" xlink:href=\"#DejaVuSans-74\"/>\r\n     <use x=\"376.15625\" xlink:href=\"#DejaVuSans-61\"/>\r\n     <use x=\"437.435547\" xlink:href=\"#DejaVuSans-67\"/>\r\n     <use x=\"500.912109\" xlink:href=\"#DejaVuSans-65\"/>\r\n     <use x=\"562.435547\" xlink:href=\"#DejaVuSans-20\"/>\r\n     <use x=\"594.222656\" xlink:href=\"#DejaVuSans-6f\"/>\r\n     <use x=\"655.404297\" xlink:href=\"#DejaVuSans-66\"/>\r\n     <use x=\"690.609375\" xlink:href=\"#DejaVuSans-20\"/>\r\n     <use x=\"722.396484\" xlink:href=\"#DejaVuSans-64\"/>\r\n     <use x=\"785.873047\" xlink:href=\"#DejaVuSans-69\"/>\r\n     <use x=\"813.65625\" xlink:href=\"#DejaVuSans-73\"/>\r\n     <use x=\"865.755859\" xlink:href=\"#DejaVuSans-73\"/>\r\n     <use x=\"917.855469\" xlink:href=\"#DejaVuSans-61\"/>\r\n     <use x=\"979.134766\" xlink:href=\"#DejaVuSans-74\"/>\r\n     <use x=\"1018.34375\" xlink:href=\"#DejaVuSans-69\"/>\r\n     <use x=\"1046.126953\" xlink:href=\"#DejaVuSans-73\"/>\r\n     <use x=\"1098.226562\" xlink:href=\"#DejaVuSans-66\"/>\r\n     <use x=\"1133.431641\" xlink:href=\"#DejaVuSans-69\"/>\r\n     <use x=\"1161.214844\" xlink:href=\"#DejaVuSans-65\"/>\r\n     <use x=\"1222.738281\" xlink:href=\"#DejaVuSans-64\"/>\r\n     <use x=\"1286.214844\" xlink:href=\"#DejaVuSans-20\"/>\r\n     <use x=\"1318.001953\" xlink:href=\"#DejaVuSans-65\"/>\r\n     <use x=\"1379.525391\" xlink:href=\"#DejaVuSans-6d\"/>\r\n     <use x=\"1476.9375\" xlink:href=\"#DejaVuSans-70\"/>\r\n     <use x=\"1540.414062\" xlink:href=\"#DejaVuSans-6c\"/>\r\n     <use x=\"1568.197266\" xlink:href=\"#DejaVuSans-6f\"/>\r\n     <use x=\"1629.378906\" xlink:href=\"#DejaVuSans-79\"/>\r\n     <use x=\"1688.558594\" xlink:href=\"#DejaVuSans-65\"/>\r\n     <use x=\"1750.082031\" xlink:href=\"#DejaVuSans-65\"/>\r\n     <use x=\"1811.605469\" xlink:href=\"#DejaVuSans-73\"/>\r\n    </g>\r\n   </g>\r\n   <g id=\"legend_1\">\r\n    <g id=\"patch_11\">\r\n     <path d=\"M 283.2 44.99625 \r\nL 371.58125 44.99625 \r\nQ 373.58125 44.99625 373.58125 42.99625 \r\nL 373.58125 29.318125 \r\nQ 373.58125 27.318125 371.58125 27.318125 \r\nL 283.2 27.318125 \r\nQ 281.2 27.318125 281.2 29.318125 \r\nL 281.2 42.99625 \r\nQ 281.2 44.99625 283.2 44.99625 \r\nz\r\n\" style=\"fill:#ffffff;opacity:0.8;stroke:#cccccc;stroke-linejoin:miter;\"/>\r\n    </g>\r\n    <g id=\"patch_12\">\r\n     <path d=\"M 285.2 38.916562 \r\nL 305.2 38.916562 \r\nL 305.2 31.916562 \r\nL 285.2 31.916562 \r\nz\r\n\" style=\"fill:#1f77b4;\"/>\r\n    </g>\r\n    <g id=\"text_14\">\r\n     <!-- dissatisfied -->\r\n     <g transform=\"translate(313.2 38.916562)scale(0.1 -0.1)\">\r\n      <use xlink:href=\"#DejaVuSans-64\"/>\r\n      <use x=\"63.476562\" xlink:href=\"#DejaVuSans-69\"/>\r\n      <use x=\"91.259766\" xlink:href=\"#DejaVuSans-73\"/>\r\n      <use x=\"143.359375\" xlink:href=\"#DejaVuSans-73\"/>\r\n      <use x=\"195.458984\" xlink:href=\"#DejaVuSans-61\"/>\r\n      <use x=\"256.738281\" xlink:href=\"#DejaVuSans-74\"/>\r\n      <use x=\"295.947266\" xlink:href=\"#DejaVuSans-69\"/>\r\n      <use x=\"323.730469\" xlink:href=\"#DejaVuSans-73\"/>\r\n      <use x=\"375.830078\" xlink:href=\"#DejaVuSans-66\"/>\r\n      <use x=\"411.035156\" xlink:href=\"#DejaVuSans-69\"/>\r\n      <use x=\"438.818359\" xlink:href=\"#DejaVuSans-65\"/>\r\n      <use x=\"500.341797\" xlink:href=\"#DejaVuSans-64\"/>\r\n     </g>\r\n    </g>\r\n   </g>\r\n  </g>\r\n </g>\r\n <defs>\r\n  <clipPath id=\"pf27efde7b2\">\r\n   <rect height=\"217.44\" width=\"334.8\" x=\"43.78125\" y=\"22.318125\"/>\r\n  </clipPath>\r\n </defs>\r\n</svg>\r\n",
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAE0CAYAAAAhaTThAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8+yak3AAAACXBIWXMAAAsTAAALEwEAmpwYAAAzVUlEQVR4nO3debxVVfnH8c9XQBABLUVTUUHFEpkEFM0hLTWcUEtzSM3ZNId+lolZZuSYJg5RSmbOE+YARqGpmEkaaDhLoqJgjigKKQr6/P5Y6+DhdoeD3HPOvfd836/Xfd2zx/Ocfc/dz95rrb2WIgIzM6tdy1U7ADMzqy4nAjOzGudEYGZW45wIzMxqnBOBmVmNcyIwM6txTgTWZkjaU9IsSfMlbVLC+pMkHZ5ff1vSXeWPcon3ny9pvRLWO1rS63n9VUrdroF9haQNPsu2zamlxGGJE0ELI2mmpA/yP/vrkq6U1KXacRVIOl3StdWOowHnA8dGRJeI+NfSbBgR10XEjmWKa4mkU/SeXSLihSa26wBcAOyY159TynZmS8OJoGXaLSK6AIOAIcBPlmZjJbX4t10XeKraQTSz1YFOtL3PZS1ILZ4sWo2IeAX4M9AXQNLmkiZLmivpMUnbFtbNV5xnSnoQeB9YT9LGku6W9Ha+u/hxXnc5SSMkPS9pjqSbJX0+L+uZb9u/I+llSW9JOjUvGwb8GNgn37E8lucfIukZSfMkvSDpqOLPIelHkl6V9B9JhxcXC0jqKOn8/F6vS7pU0gr1HY8c908kvSTpDUlXS1op72M+0A54TNLzDWy/g6RnJb0r6deAipYdLOnv+bUkjcrv8Z6kJyQV/gY7S3o6f9ZXJP0wz/+cpDslvSnpnfy6R152JrA18Ot83H6d5xcfh//Zr6QNgek5xLmS7q1nu0aPn6STio79ofUdl6J1V5L0+7z+K5LOkNSu6Pg8mI/L3Px3/nKePysfq+8U7evKHMvd+TPdL2ndRt736nzsXsp/4+UkLa/03e1XtO5qkt6X1D1P7yppWo5psqT+ReuuKemPeb8vSjq+aNlmkqbmv+/rki5o7Ni0eRHhnxb0A8wEts+v1yZdCf4CWAuYA+xMSuA75Onued1JwMvAxkB7oCvwKvAD0hVlV2BoXvcE4CGgB9ARuAy4IS/rCQTwO2AFYADwIbBRXn46cG2dmHcB1iedWL9CSkSD8rJhwGs5rs7AtXn/G+Tlo4BxwOdzjOOBsxs4NocCM4D1gC7ArcA1RcsX77eebVcF5gF7AR2A/wMWAYfn5QcDf8+vvw48AqycP9NGwBp52avA1vn154o+5yrAN/Nn7AqMBW4vev9JhfeqL95G9lv4e7RvYLsGj18+9q+TLiRWBK5v4hjdlr8LKwKrAf8Ejio6PouAQ0gJ9wzS92006Tu0Yz6+XfL6V+bpbfLyiwrHt57PcDVwR46/J/Bv4LC87DfAuUXbnQCMz683Ad4AhuaYvkP6/+lI+h95BDgNWJ70nXkB+Hre9h/Agfl1F2Dzav/vV/W8U+0A/FPnD5K+yPOBucBL+R9hBeBkik56ed2JwHfy60nAyKJl+wH/auA9ngG+VjS9BrCQlEAKJ54eRcv/CeybX59OnURQz/5vB07Ir6+g6MQObFA4CZBOsv8F1i9avgXwYgP7vQc4pmj6i4W483RjJ7mDgIeKpgXMpv5E8NV8MtocWK7Ofl4GjgK6NXEMBgLvFE1PovFEUO9+aSQRNHX88rE/p2jZhg0dI1IR1IfACnW+Q/cVHZ/nipb1y/tavWjeHGBgfn0lcGPRsi7Ax8DadT5DO+AjoE/RukcBk/LrofnYKE9PBb6VX/8W+EWdzzGddDEyFHi5zrJTgD/k138Dfg6sWq7/5db046KhlmmPiFg5ItaNiGMi4gNS+ffe+RZ4rqS5wFakk3jBrKLXawP1FpHkfd1WtJ9nSP+kqxet81rR6/dJ/8j1krSTpIfybfxc0l3LqnnxmnXiKn7dnXQF/UhRLH/J8+uzJik5FrxESl6r17/6/2y7+L0jnQ1m1bdiRNwL/Jp0tfuGpDGSuuXF3yR9vpdycccWAJI6S7osF228RzrRrFwoWilBvfttQlPHr+6xf4mGrUu6U3q1aF+Xke4MCl4vev0BQETUnVf8PSk+3vOBt3NMxVbN71v377pW3u5h0vdvW0lfIiWPcUUx/6DO/8Ta+T3WBdass+zHfPpdOYyUGJ+VNEXSrg0fmrbPiaD1mEW6I1i56GfFiDinaJ2os35DTQxnATvV2VenSHUSTVmiu1pJHYE/klrsrB4RKwMT+LT8/VVSEVTB2kWv3yKdPDYuimOlSBXl9fkP6R+8YB1SccXr9a++hFeL31uS6sSyhIi4OCIGA31IJ4yT8vwpEbE76QR5O3Bz3uQHpDuUoRHRjVQkAp8eh0a7+W1kv41p6vgt8ZlJx6shs0h3BKsW7atbRGxcQhwNKT7eXUjFV/+p5zMs5H//rsXfxauAA4ADgVsiYkFRzGfW+R53jogb8rIX6yzrGhE7A0TEcxGxH+l4nwvcImnFZfisrZoTQetxLbCbpK9Laiepk6RtCxWS9bgTWEPS93OFYldJQ/OyS4EzC5V3krpL2r3EOF4HeurTVknLk8pk3wQWSdqJVF5ccDNwiKSNJHUGflpYEBGfkOoiRklaLceylqSvN/DeNwD/J6lXPrGcBdwUEYtKiPtPwMaSviGpPXA88IX6VpS0qaShSk03/wssAD7JlZfflrRSRCwE3gM+yZt1JZ2U5ypVvP+szm5fp4HE3MR+G1TC8bsZOFhSn3zs68ZUvK9XgbuAX0nqlitr15f0labiaMTOkraStDypnuuhiFjiLiwiPs5xnpm/o+sCJ5K+7wXXAnuSksHVRfN/B3w3/60kaUVJu0jqSirOnCfpZEkr5P+ZvpI2BZB0gKTu+RjOzftr8pi3VU4ErUT+B9qddHv7JumK5yQa+BtGxDxShfJupGKe54Dt8uKLSLfXd0maR6o4HlrffuoxNv+eI+nR/D7Hk/6Z3wH259NbdyLiz8DFwH2kit6H8qIP8++TC/NzkcpfSVfW9bkCuIZU7PIi6QR9XClBR8RbwN7AOaSy7N7Agw2s3o10knmHVEwxBzgvLzsQmJlj/S7w7Tz/QlJdzlv5M/6lzj4vAvZSalF0cT3v2dB+m9Lg8cvH/kLg3rzOvU3s6yBSYn+a9NlvYcmix6V1PSn5vA0MJp3I63McKeG+APw9b3dFYWH+7j9Kuqt6oGj+VOAIUjHeO6TPeHBe9jGwK6mu5kXS3+VyYKW8+TDgKaXWZheR6sA+WIbP2qoVKmDMKkLSRsCTQMcSr+StFZJ0JTA7IpbqGZhG9ncF8J/m2p8tyXcEVnZKXT90lPQ5UnnseCcBK5WknsA3gN9XOZQ2y4nAKuEoUnvv50mtk46ubjjWWkj6BekO8ryIeLHa8bRVLhoyM6txviMwM6txTgRmZjWufbUDWFqrrrpq9OzZs9phmJm1Ko888shbEVHvU/utLhH07NmTqVOnVjsMM7NWRVKDXYy4aMjMrMY5EZiZ1TgnAjOzGtfq6gis7Vu4cCGzZ89mwYIFTa9sy6xTp0706NGDDh06VDsUqxInAmtxZs+eTdeuXenZsyept2grl4hgzpw5zJ49m169elU7HKsSFw1Zi7NgwQJWWWUVJ4EKkMQqq6ziu68a50RgLZKTQOX4WJuLhsxKcPrpp9OlSxfee+89ttlmG7bffvtl3ufMmTOZPHky+++/PwBTp07l6quv5uKL6xuuIDnppJOYMGECO++8M+uvvz6dO3fmoIMOKvk9u3Tpwvz585c5dmtbnAiAniP+VO0QSjLznF2qHUJVNPffZ1mO48iRI5svjpkzuf766xcngiFDhjBkyJBGtxkzZgxvv/027dqVOhSyWdNcNGTWgDPPPJMNN9yQrbbaiunTpwNw8MEHc8sttwAwYsQI+vTpQ//+/fnhD38IwNixY+nbty8DBgxgm23SsMUzZ85k6623ZtCgQQwaNIjJkycv3v6BBx5g4MCBjBo1ikmTJrHrrmkM9fvvv5+BAwcycOBANtlkE+bNm8fw4cOZP38+gwcP5qabbuL000/n/PPPB+D5559n2LBhDB48mK233ppnn30WgBdffJEtttiCfv368ZOfeEwXq5/vCMzq8cgjj3DjjTcybdo0Fi1axKBBgxg8ePDi5XPmzOG2227j2WefRRJz584F0h3DxIkTWWuttRbPW2211bj77rvp1KkTzz33HPvttx9Tp07lnHPO4fzzz+fOO+8EYNKkSYv3f/755zN69Gi23HJL5s+fT6dOnRg3bhxdunRh2rRpQCquKjjyyCO59NJL6d27Nw8//DDHHHMM9957LyeccAJHH300Bx10EKNHjy7nIbNWrKx3BJKGSZouaYakEfUsP1jSm5Km5Z/DyxmPWakeeOAB9txzTzp37ky3bt0YPnz4EstXWmklOnXqxGGHHcatt95K586dAdhyyy05+OCD+d3vfsfHH38MpOcijjjiCPr168fee+/N008/3eT7b7nllpx44olcfPHFzJ07l/btG75mmz9/PpMnT2bvvfdm4MCBHHXUUbz66qsAPPjgg+y3334AHHjggZ/pWFjbV7ZEIKkdMBrYCegD7CepTz2r3hQRA/PP5eWKx6w5tW/fnn/+85/stdde3HnnnQwbNgyASy+9lDPOOINZs2YxePBg5syZw6hRo1h99dV57LHHmDp1Kh999FGT+x8xYgSXX345H3zwAVtuueXiop76fPLJJ6y88spMmzZt8c8zzzyzeLlbBVlTynlHsBkwIyJeiIiPgBuB3cv4fmbNZptttuH222/ngw8+YN68eYwfP36J5fPnz+fdd99l5513ZtSoUTz22GNAKqsfOnQoI0eOpHv37syaNYt3332XNdZYg+WWW45rrrlm8Z1C165dmTdvXr3v//zzz9OvXz9OPvlkNt1000YTQbdu3ejVqxdjx44F0kNihXi23HJLbrzxRgCuu+66ZTso1maVMxGsBcwqmp6d59X1TUmPS7pF0tpljMesZIMGDWKfffZhwIAB7LTTTmy66aZLLJ83bx677ror/fv3Z6uttuKCCy4AUvPOfv360bdvX7785S8zYMAAjjnmGK666ioGDBjAs88+y4orrghA//79adeuHQMGDGDUqFFL7P/CCy+kb9++9O/fnw4dOrDTTjs1Gu91113H73//ewYMGMDGG2/MHXfcAcBFF13E6NGj6devH6+88kpzHR5rY8o2ZrGkvYBhEXF4nj4QGBoRxxatswowPyI+lHQUsE9EfLWefR0JHAmwzjrrDH7ppQa71f5M3Hy0ZXnmmWfYaKONqh1GTfExb/skPRIR9bZPLucdwStA8RV+jzxvsYiYExEf5snLgcHUIyLGRMSQiBjSvXu9A+yYmdlnVM5EMAXoLamXpOWBfYFxxStIWqNocjjwDGZmVlFle44gIhZJOhaYCLQDroiIpySNBKZGxDjgeEnDgUXA28DB5YrHzMzqV9YHyiJiAjChzrzTil6fApxSzhisdYoIN3uskHLVE1rr4SeLrcXp1KkTc+bMcVfUFVAYj6BTp07VDqUi3DCkfk4E1uL06NGD2bNn8+abb1Y7lJpQGKHMapcTgbU4HTp08GhZZhXk3kfNzGqcE4GZWY1zIjAzq3FOBGZmNc6JwMysxjkRmJnVOCcCM7Ma50RgZlbjnAjMzGqcE4GZWY1zIjAzq3FOBGZmNc6JwMysxjkRmJnVOCcCM7Ma50RgZlbjmkwEkn4pqZukDpLukfSmpAMqEZyZmZVfKXcEO0bEe8CuwExgA+CkcgZlZmaVU0oiKAxnuQswNiLeLWM8ZmZWYaWMWXynpGeBD4CjJXUHFpQ3LDMzq5Qm7wgiYgTwZWBIRCwE3gd2L3dgZmZWGaVUFncGjgF+m2etCQwpZ1BmZlY5pdQR/AH4iHRXAPAKcEbZIjIzs4oqJRGsHxG/BBYCRMT7gMoalZmZVUwpieAjSSsAASBpfeDDskZlZmYVU0qroZ8BfwHWlnQdsCVwcDmDMjOzymkyEUTE3ZIeBTYnFQmdEBFvlT0yMzOriFJaDQnYCRgcEXcCnSVtVvbIzMysIkqpI/gNsAWwX56eB4wuZeeShkmaLmmGpBGNrPdNSSHJzVLNzCqslEQwNCK+R36aOCLeAZZvaiNJ7UgJYyegD7CfpD71rNcVOAF4eCniNjOzZlJKIliYT+qFVkPdgU9K2G4zYEZEvBARHwE3Uv8Tyb8AzsXdVpiZVUUpieBi4DZgNUlnAn8Hziphu7WAWUXTs/O8xSQNAtaOiD+VFq6ZmTW3UloNXSfpEeBrpFZDe0TEM8v6xpKWAy6ghKaoko4EjgRYZ511lvWtzcysSCmthn4FLBcRoyPi10uRBF4B1i6a7pHnFXQF+gKTJM0kNU8dV1+FcUSMiYghETGke/fuJb69mZmVopSioWeA30l6WNJ3Ja1U4r6nAL0l9ZK0PLAvMK6wMCLejYhVI6JnRPQEHgKGR8TUpfwMZma2DErphvryiNgSOAjoCTwu6XpJ2zWx3SLgWGAiKZncHBFPSRopafiyh25mZs2hlC4mCk1Bv5R/3gIeA06UdFRE7NvQdhExAZhQZ95pDay7bYkxm5lZM2oyEUgaBewG3AOcFRH/zIvOlTS9nMGZmVn5lXJH8Djwk4j4bz3L3NWEmVkrV0rz0T9IGi5pmzzr/ogYn5d5IHszs1aulOajZ5O6gHg6/xwvqZQHyszMrBUopWhoF2BgRHwCIOkq4F/Aj8sZmJmZVUYpzxEArFz0utTnCMzMrBUo5Y7gbOBfku4jdTGxDdBgl9JmZta6lFJZfIOkScCmedbJEfFaWaMyM7OKaTAR5J5Bi83Ov9eUtGZEPFq+sMzMrFIauyP4VSPLAvhqM8diZmZV0GAiiIhG+xIyM7O2oZQuJjoBxwBbke4EHgAujQiPKGZm1gaU0mroatKA9Zfk6f2Ba4C9yxWUmZlVTimJoG9EFA86f5+kp8sVkJmZVVYpD5Q9KmnzwoSkoYAHjzEzayNKuSMYDEyW9HKeXgeYLukJICKif9miMzOzsislEQwrexRmZlY1pTxZ/JKkz5EGom9fNN8PlJmZtQGlNB/9BXAw8Dyp+Sj4gTJrRM8Rf6p2CCWZec4u1Q7BrEUopWjoW8D6EfFRuYMxM7PKK6XV0JMs2Q21mZm1IUvTDfWTwIeFmRExvGxRmZlZxZSSCK4CzgWeAD4pbzhmZlZppSSC9yPi4rJHYmZmVVFKInggD2A/jiWLhtx81MysDSglEWySf29eNM/NR83M2ohSHijzuARmZm1Yk81HJa0u6feS/pyn+0g6rPyhmZlZJZTyHMGVwERgzTz9b+D7ZYrHzMwqrJREsGpE3ExuOhoRi4CPyxqVmZlVTCmJ4L+SViH3M5THJni3rFGZmVnFlJIITiQ1HV1f0oOkoSuPK2XnkoZJmi5phqQR9Sz/rqQnJE2T9HdJferbj5mZlU8prYYelfQV4IuAgOkRsbCp7SS1A0YDOwCzgSmSxkVE8TCX10fEpXn94cAFePwDM7OKKuU5gkK9wFNLue/NgBkR8QKApBuB3YHFiSAi3itaf0U+7ebazMwqpKRE8BmtBcwqmp4NDK27kqTvkYqflscPqZmZVVwpdQRlFRGjI2J94GTgJ/WtI+lISVMlTX3zzTcrG6CZWRvX4B2BpEGNbVhCX0OvkIa3LOiR5zXkRuC3DbzXGGAMwJAhQ1x8ZGbWjBorGvpV/t0JGAI8Rqos7g9MBbZoYt9TgN6SepESwL7A/sUrSOodEc/lyV2A5zCzxTzsp1VCg4mg0MeQpFuBQRHxRJ7uC5ze1I4jYpGkY0lPJbcDroiIpySNBKZGxDjgWEnbAwuBd4DvLOPnMTOzpVRKZfEXC0kAICKelLRRKTuPiAnAhDrzTit6fUKpgZqZWXmUkggel3Q5cG2e/jbwePlCMjOzSiolERwCHA0Urt7/RgOVumZm1vqU8mTxAkmXAhMiYnoFYjIzswoqZTyC4cA04C95eqCkcWWOy8zMKqSUB8p+RuouYi5AREwDepUvJDMzq6RSEsHCiKjb7bQf6jIzayNKqSx+StL+QDtJvYHjgcnlDcvMzCqllDuC44CNgQ+BG4D38FCVZmZtRimtht4HTs0/ZmbWxjTW6dyFEfF9SeOpp04gIoaXNTIzM6uIxu4Irs6/z69EIGZmVh2NJYLzgK8BO0fEyRWKx8zMKqyxRLCGpC8Dw/MwkypeWMJ4BGZm1go0lghOA35KGlDmgjrLAg8raWbWJjQ2HsEtwC2SfhoRv6hgTGZmVkGlPEdwr6QVASQdIOkCSeuWOS4zM6uQUhLBb4H3JQ0AfgA8z6ctiszMrJUrJREsiogAdgd+HRGjga7lDcvMzCqllL6G5kk6BTgA2EbSckCH8oZlZmaVUsodwT6kfoYOi4jXSK2IzitrVGZmVjGl9DX0GkXNRyPiZVxHYGbWZjTW19DfI2IrSfNYsq8hARER3coenZmZlV1jzxFslX+7YtjMrA0rZczia0qZZ2ZmrVMplcUbF09Iag8MLk84ZmZWaQ0mAkmn5PqB/pLeyz/zgNeBOyoWoZmZlVWDiSAizs71A+dFRLf80zUiVomIUyoYo5mZlVEpzUdPkfQ5oDfQqWj+38oZmJmZVUaTiUDS4cAJpAfJpgGbA//A3VCbmbUJpVQWnwBsCrwUEdsBmwBzyxmUmZlVTimJYEFELACQ1DEingW+WN6wzMysUkpJBLMlrQzcDtwt6Q7gpVJ2LmmYpOmSZkgaUc/yEyU9LelxSfd4nAMzs8orpbJ4z/zydEn3ASsBf2lqO0ntgNHADsBsYIqkcRHxdNFq/wKGRMT7ko4Gfknq5M7MzCqklCeL15fUsTAJ9AQ6l7DvzYAZEfFCRHwE3Ega02CxiLgvIt7Pkw+RKqTNzKyCSika+iPwsaQNgDHA2sD1JWy3FjCraHp2nteQw4A/l7BfMzNrRqUMTPNJRCyStCdwSURcIulfzRmEpAOAIcBXGlh+JHAkwDrrrNOcb21mVvNKuSNYKGk/4DvAnXleKSOUvUK6eyjokectQdL2wKnA8Ij4sL4dRcSYiBgSEUO6d+9ewlubmVmpSkkEhwBbAGdGxIuSegGl9D46BegtqZek5YF9gXHFK0jaBLiMlATeWLrQzcysOZTSauhp4HiA3NVE14g4t4TtFkk6FpgItAOuiIinJI0EpkbEONKQl12AsZIAXo6I4Z/505iZ2VIrpYuJScDwvO4jwBuSHoyIE5vaNiImABPqzDut6PX2SxuwmZk1r1KKhlaKiPeAbwBXR8RQwCdwM7M2opRE0F7SGsC3+LSy2MzM2ohSEsFIUjn/jIiYImk94LnyhmVmZpVSSmXxWGBs0fQLwDfLGZSZmVVOg4lA0o8i4peSLgGi7vKIOL6skZmZWUU0dkfwTP49tRKBmJlZdTSYCCJifP59VeXCMTOzSmusaGg89RQJFfjBLzOztqGxoqHz8+9vAF8Ars3T+wGvlzMoMzOrnMaKhu4HkPSriBhStGi8JNcbmJm1EaU8R7BifnYAgNzp3IrlC8nMzCqplPEI/g+YJOkF0ghl65LHBjAzs9avlAfK/iKpN/ClPOvZhsYNMDOz1qeUOwLyif+xMsdiZmZVUEodgZmZtWENJgJJW+bfHSsXjpmZVVpjdwQX59//qEQgZmZWHY3VESyUNAZYS9LFdRe60zkzs7ahsUSwK2kksq+Thqg0M7M2qLEni98CbpT0TES4xZCZWRtVSquhOZJuk/RG/vmjpB5lj8zMzCqilETwB2AcsGb+GZ/nmZlZG1BKIlgtIv4QEYvyz5VA9zLHZWZmFVJKInhL0gGS2uWfA4A55Q7MzMwqo5REcCjwLeA14FVgL+CQcgZlZmaVU0qncy8BHo3MzKyNcl9DZmY1zonAzKzGORGYmdW4khOBpM0l/UXSJEl7lDEmMzOroAYriyV9ISJeK5p1IrAnabjKh4HbyxuamZlVQmOthi6V9Cjwy4hYAMwlNR39BHivArGZmVkFNFg0FBF7AP8C7pR0EPB9oCOwCrBHKTuXNEzSdEkzJI2oZ/k2kh6VtEjSXp8hfjMzW0aN1hFExHhSN9QrAbcB/46IiyPizaZ2LKkdMBrYCegD7CepT53VXgYOBq5f+tDNzKw5NDZU5XBJ9wF/AZ4E9gF2l3SjpPVL2PdmwIyIeCEiPgJuBHYvXiEiZkbE46TiJjMzq4LG6gjOIJ3MVwAmRsRmwA8k9QbOBPZtYt9rAbOKpmcDQz9LkJKOBI4EWGeddT7LLszMrAGNFQ29C3wD+CbwRmFmRDwXEU0lgWYVEWMiYkhEDOne3R2fmpk1p8YSwZ6kiuH2wP6fYd+vAGsXTffI88zMrAVpaqjKS5Zh31OA3pJ6kRLAvny2hGJmZmVUti4mImIRcCwwEXgGuDkinpI0UtJwAEmbSpoN7A1cJumpcsVjZmb1a7Ib6mUREROACXXmnVb0egqpyMjMzKrEnc6ZmdU4JwIzsxrnRGBmVuOcCMzMapwTgZlZjXMiMDOrcU4EZmY1zonAzKzGORGYmdU4JwIzsxrnRGBmVuOcCMzMapwTgZlZjXMiMDOrcU4EZmY1zonAzKzGORGYmdU4JwIzsxrnRGBmVuOcCMzMapwTgZlZjXMiMDOrcU4EZmY1zonAzKzGORGYmdU4JwIzsxrnRGBmVuOcCMzMapwTgZlZjXMiMDOrcU4EZmY1rqyJQNIwSdMlzZA0op7lHSXdlJc/LKlnOeMxM7P/VbZEIKkdMBrYCegD7CepT53VDgPeiYgNgFHAueWKx8zM6lfOO4LNgBkR8UJEfATcCOxeZ53dgavy61uAr0lSGWMyM7M62pdx32sBs4qmZwNDG1onIhZJehdYBXireCVJRwJH5sn5kqaXJeLmtSp1PseyUm3fL/l4Nh8fy+bVWo7nug0tKGciaDYRMQYYU+04loakqRExpNpxtBU+ns3Hx7J5tYXjWc6ioVeAtYume+R59a4jqT2wEjCnjDGZmVkd5UwEU4DeknpJWh7YFxhXZ51xwHfy672AeyMiyhiTmZnVUbaioVzmfywwEWgHXBERT0kaCUyNiHHA74FrJM0A3iYli7aiVRVltQI+ns3Hx7J5tfrjKV+Am5nVNj9ZbGZW45wIzMxqnBNBKyHpAEnrVzuOtkJJe0m7FqarHVM1SfK5oIb5j9/C5RPWKsCmwAnVjqetyK3TegBjJfWp1dZqhQQYEZ/k6VWrG1HblrveaXGcCFowSctFMge4E1hP0hbVjqu1K1z9RsRM4A/AiVUNqIoKCTBfcIwEhhWmqxpYG1OUcD+WtFxuUt9ijrMTQQsWEZ9IWlnSDaQuNj4HHFrlsFq9fFx7SLoM6AwcKGk4tJx/zHIqLgaStJ6k40hNvJ8Hvg2fJghrHkUJ9zDgEWCUpA0jIlrCd86JoAVpoJx2D2BeROxNaq/8OUkHVTSwVq6B2/GfAQtJifVXwFmSVAsnwJwIC8dkC+Ai4JekjiE/Kdx1toQTVGuV77BUNL2BpBOBr5Aeon0XuAZaRtJ1Imgh8kmoUE47WFKHvGg7Pu2a43bgNmAPSV0rH2Xrk4/rx/n12oVbctJ3/4aI+CQifgwsAH5Q2KY60ZZH3QsMSV8AHpD0JeBeUlL8EvBz4G5gfWgZJ6jWSFK7XKQbRce+H7APMDMiHs/fudUk7Z+3qeq52Imghchfmg0l/Rk4CzhN0j6kp683k9Q5It4FPiT90/5fFcNtNfJxHSzpHuAc4DpJnYEVSMex4FrgF5JWb0snwFzPVLjA2FbS4Ih4DbgaOJB0cnoD+DGp598DgY3y+m0qIVZK0YXHKcDZkjaKiNtIvSyEpEIfbCeS7sQWV9ZXixNBldQtrsjT3yIVU3yD1GX3cOBV4DXg4nw1uwVwB6mc0eqo57h2JCXNs4ADgK8DB5OK2Q6XtKukHqT6l0eAL1Q04DLI9UrDYHEx0KqSrgJGArtIuh+4DHiI1Brte8DKwHHAU6Rj5DuCEtVTDNRf0oOkTjRnAj+XtBmpKGgDoH++a7gNeFNS1bvWcSKoMEnbSepXdNWwTl4UwObA9sCfgenAoRHxHPAjUr9Q9wJdgZ9FxJ8qHnwrUHRcD1F67mId4D+kUfIeJo2aNyYiJpGSwU7AfaQ7rW0i4rFqxN3M9gS+lU8+ABsDD0fENqSy6YHA+hExHrgO6AWcCiwCDmvtXSpXWlEx0Ca5MvgLpMYdZ5NaYa1LSrYvk76Dw8h3XcAWEXFjFcJeQqsYj6CtkLQmsCvwfi7jHwUslHR9RPxG0mOku4FdIuKFvM1uwP0RcbCkbhHxXtU+QCsg6cvAb4AngbuA+aSebacBwyLi7bzeDhHxh3ylvEpEvJnntyskk9ZE0leBlyNiBnA/0JM04t8jwNZA33zl+QKwQeHzRsQESb8C5gEiJQNrQqHILd8JdAYOBwYBf4yIu5SexxgL3Er6e4wC9iYVyZ0NvA8QEQuqEX9d7nSuAiS1j4hF+fWOpCKfXsBppGQ8CjiZ9IU6lPTMwEOk8sPlgCMi4o0qhN6i1T1pK41pcS4wOSL+WDT/Z8CWwFGkY3wuqcjt/4D38z/0cuSLu0p+huaQK3//Q+r6/QhS8c42pPL/K0nJ8FFgcEQ8kbfZj9Qa7U5JHSJiYTVib22K61yK5m1AOuajImJEnrc9cHJE7JAv+saRelg+GJjf0r5nLhqqgNwld0dJW0XEXaR/2g2AxyPiYVJLjeHAY8Bvga+R/oEfjIjdnQSWpE8fCPtY0oq5THb5nGz7kSqCyZXCRMTPSSfJ04DfARMj4oiImF/4p86th1rUP2epcuXvecAawM6kz/goqXx6t4h4ktTi7HhJ35Z0Oami8t28vZNAiYoq3odLukLSDqTnL04lffcK6/0VGCTpHNIdwd2kC7p5LfF75juCMpC0NTC36Orru6QrtakRcZSkwcDRwN8i4mpJq5H+eW+JiGvyNh0j4sMqfYRWIRd1nEU64b0WEftLOpnUFPSKiJgnaQWgZ0Q8k6/MPioc1/qu7lqrnPRmA+uRisZmAd1Idz5TgL8BuwPbkpownlWdSFuX3Frv/aJpkYp2+pIu1oaTjvXPSHcFx0bE3XndTYCtgBcj4s4Kh75UfEfQjHLrjOVIg1nPzPN6ATsAwyPiqLzqE8A/gC0k9cxX/PcC6xbauTsJfCo3yih+GnZVSaeSmjpuFRFfJV19fY100utDenJzB+BPwAG5NdF/I+LDQsuitpIEAPLJ6ifA6RGxP6l+ZFtSufQxwOcj4nrgGCeB0uST/tGS+uXp7fLVfCdgN1JDhIHAtHw3ej6pCXKhO4l/RcQlLT0JgBNBs5E0FLgZWDk3C9tN0u6kL00v4NuSfizpJuCbwIOksttDASLioog4IyI+qs4naJn0aX9Ln0j6Qq4HeDsvXpXUigpSfcqPSE1AzyQVvx0BXBIRp0bEx0XFQK2uMrhElwJ7SeofEfeQRvx7gHScFkIqpqxifK2CpHbS4qfMXwXukfQo8NV8kt+c9JDnGsBXImKspB4R8TtSnd/WVQv+M3IiWEZF7YdfIbVUOTJP9wR2BJ4FLiZ9QZ4i3QkcA7wDTCZdwfrhnSJKnXJ9CRa3g28v6UzSAzmXkO4ExgBTSc9bEBFXkL7PJ0TEyxFxWkR8Kyflqj+5WQk50e0NXJ6nH4uIYyJii1yPYI2Q1B3ShUJROf58Ul3KvRHxU1LLqrHApIg4KSLeUeqn6iSlZ1a2joi/VSP+ZdHm/znKJf/Rix+6eQX4I7CNpN7A9Xn+oRFxZUScFRF3kCrxFpDqZ26L1JbbD+9k+bjuQ0qkBd8FPo6IAaQEejapueMTpGaRm+b1ziCXJBXtr1Cx3GaKgRoTEf8AFknqX+1YWotc9PhNUoUvknpJ+m2ug3qe1O5/N0lr5O/RHUAnSX+UdBvpqey/RsSHEfFBtT7HsnBl8VLKFY7HkVr03C9pCNCdVE74qqSfk8pjj1PqR+QrpKeFPwSuIN0ZnBIRk6v0EVqsQnPQfCLvRrrtHpdbXjxLKpftRHqgbqrSo/onk4qBznexWlK3Wa01TdKPgLVIT/9eRfqfXZ1Uz7ILqdhtYUQcndfvSGol1Ccirq5GzM3JieAzkPRb0snnE1K74PtJX5ivkroqOI30BOsjpKuMj4CfAjtGxMTKR9yyFZXHFh66+zrQgdTh3lGk9v4/BHaOiAfyejuQyr+3At6OiEeL9tdmWgNZeeSix5cLLYJyhfCfSC2u/kIqAvoDqanxyZJWJz2Bfjvpoc8DImJqNWIvBxcNlaCe8uXLSI/tDwWGRsThpG4hjiYliImkuoL3gHtIzwuEk8CSilpXFJLADsANpKKzv5MeyT+QdHX2PrC8pDUk/ZhUIdw3Iv5anATy/pwErEFKI/79DviBPu2bajapZ9/tgL+S+mX6Xk4CXSPidVL30e8Ah7SlJABOBE3KV6vF3UN3jIhppAdEPg98Ma96JqlN8eeA8UBH4KsRMTEibq585C1Xrgxeou9/SXuQyvgfj4gbIuJp0tPVQ0gdoh1COr43ABsCe7S1f0arjEgj/h0ODADGKHX5vhDoTboAuRv4eUQ8qNQh4XmShkbElIg4L9fDtCkuGqpH3TJWSRuSuoFYkdTs84H881tSe+3bIuK/km4mtdi4G1g1cn8uVr9cybsjcEdEPCnpPFIdyjkR8bqktYCDSM0ffxgRIWnNiPhP3t5FQPaZSfo8qd5uBnAB6WJjIHATqcvy8aTi3vER8ZMqhVkRviOoI5/0BxRNr0Eqp76U1FPl5qQioJVJIzodRHqI5FzSg0xP5WIgJ4EG5FYa55KKfF4GLpR0CKlDrs+TntokIl4hdRYXpB4ccRKw5hKpA8KTgLdIRbuvAXMi4hZSR4WPALu29SQATgSLFdUDrA4cIukCSXeTTkLnAK+T7gJeJHURfXhETCA9Xv6FvHyLfPKyrIHnIzqSuuDYhnRLvjawQqQuOV4mNcFdL697H3BSpIHmF3MSsOYQEc9FxDmkeoHTSJ0TEhHTIuLaiJhV1QArpOaLhuq2M88VSQ8CH5P6DbkvVyj9jNRX0DhJZ5HaFh9HevLwQyeA/6UlR8falVS0dhep+GcqqWL9BeCMSH0BdSAlhQuBsyLiofr2ZdZcCnVVSn1SfZ1UpHt5teOqtJpNBJJWjIj/Fk2vR+qS4B6gC6kXxytIJ/9Fkv4BTCCVJV4G/JtUtt0WBjJpVnWag65PGoPhANKzACuRmoIeCgyKiB3zegNJT8X+FFjDidWscmquaCj3I/ILYKSklfO8w0hth18H/hERt5PKC/cgl00Dx5Kaiz5KqgcY6SRQv3yFVWiW9w/g6xGxKak+5S7gIlLfQOtJ+omkMaTWQP+O1B20k4BZBdXUHYGkw0nt0mcCJ0bEnFyGfQNwYUQ8lB8cgVQ0dAlpQInupH6EHgUWRcT8igffwtUpBhpCeuDm+5K+R3oSeDWlnlU7kNprH0cqItqYNGzfr3xczaqjZoaqVOrzfwzQP9JAHUjaiJQUHgH+KGkiuf0/qQ7gEtJV7CBSn0FzKx95yyVpO1JzuzG5+WyviHiR1A3EJgARMVrSiZKOiTQc58fAHGBBRLxE6oivsD93jWBWBTWTCCLiDUlXkK4+n5R0Pal9+hERcZ6kycCM3H79FFJ3EOdJetxXqkuS1JNUed4PODUngT7ArZKmAM+Rnq4uOAq4K1fMDyAVt71fZ59yEjCrjlorGloRmAs8A1xLKo4ofnDs86RKzEOBw9riE4TLKieBF4CjIvW/vnhM5twh3zBS2+x1SAPyPBWpK+lrSHcJx0Qr7KbXrC2rqcri3EroSOC5iPhlnSSwEvADYDNgmJNA/XJ7/sdJI6oh6RhgrKR+kcZjHUvqGqIwNsOflfprP4HUu+NzebvlqxC+mdWjpu4IYPFzAy8D20bEjFyxeTxwK6mnwVbZn3glKQ2/+RDwzzzrzFzRXuhG+ofAm6QxGfYCHo2I6ZIuI3Xle2x1Ijez+tRcIgCQtAWpm+g/kYoyLo2I31c3qtZF0iWk9v571bPsbuC3EXFr5SMzs6VVk4kAQNJ9pBGuTgoPFL/Ucn3LTGDtiFiQm+EeQ3rQ7s3cQ2th3cLTm0v0OGpmLUMtJwI3VVxGko4C+gPXkZ64fpqUWOfk5T7xm7UCNZsIbNnl+pa3SRXDIyLi71UOycw+AycCWyaSVincAeRpdw5n1so4EVizcFGbWevlRGBmVuNq6oEyMzP7X04EZmY1zonAzKzGORFYqyDpVElPSXpc0jRJQ5tpvyMlbd8M+/mCpBslPS/pEUkTJG3YyPor536azKrOlcXW4uUuQS4g9Q/1oaRVgeUj4j8lbt8+IhaVMT4Bk4GrIuLSPG8A0C0iHmhgm57AnRHRt1xx5fcp62e3tsF3BNYarAG8VegKJCLeKiQBSYMl3Z+vwidKWiPPnyTpQklTgVMlvZQfgEPSipJmSeog6UpJe+X5m0qaLOkxSf+U1DUPbXqepCn5buSoeuLbjtSZ3qWFGRHxWEQ8IKmLpHskPSrpCUm751XOAdbPdzfn5fc/qeh9fl7Yl6SfSpou6e+Sbsid+iFpoKSH8vq3SfpcA5/9RUkd8rJuxdNmUEMD01irdhdwmqR/A38FboqI+/PJ7BJg94h4U9I+wJmk8SQg3TUMAZA0CPgKcB+wK6mn2YXpYn5xt9g3AftExBRJ3YAPgMOAdyNiU0kdgQcl3ZVHYivoSxrlrj4LgD0j4r18J/OQpHHACKBvRAzM778j0JvUDbqAcZK2yTF8kzSgTwfScKmF97oaOC4fi5GkwYK+X89n7wnsAtwO7AvcGhELmzzqVjOcCKzFi4j5kgYDW5Ouvm+SNAKYSjoJ351P6O2AV4s2vanO631IiWBf4Dd13uaLwKsRMSW/53uw+ATdv3DXAKxEOmG/SGkEnJVP6p+QxmRYvZ71dsw//8rTXfL7dAXuiIgFwAJJ43NcKwErR8T9ef2rgLENfPbLgR+REsEhwBElxm41wonAWoX81PIkYJKkJ4DvkK6Mn4qILRrY7L9Fr8eRTsifBwaTB9YpgUhX3RMbWecp0rgL9fk20B0YnO9AZpLGdK7vfc6OiMuWmCl9v8Q461r82SPiQUk9JW0LtCuM2W1W4DoCa/EkfVFS76JZA4GXgOlA91yZTC7z37i+feRxp6cAF5Eqaet2hzEdWEPSpnlfXSW1J429fHRRGfuGSl1wF7sX6CjpyKKY+0vamnQH8UZOAtuRxmsGmEe62i+YCBwqqUvefi1JqwEPArtJ6pSX7Zo/z7vAO/k9AA4E7qdhV5MGCvpDI+tYjfIdgbUGXYBLJK0MLAJmAEdGxEe5yObiXFTSHriQdIVen5tIxSfb1l2Q97VPfp8VSGXz25OKVXoCj+bWQW8Ce9TZNiTtCVwo6WRSvcBMUnn9dcD4fBczFXg2bzNH0oOSngT+HBEnSdoI+Ecu5poPHJDrK8aRhgd9nTSGxrv5rb8DXCqpM2kc6UMaOYbXAWcANzSyjtUoNx81a+Ekdcn1JJ2Bv5GS4KNLuY+9SJXqB5YlSGvVfEdg1vKNkdSHVLdw1WdIApcAOwE7lyM4a/18R2BmVuNcWWxmVuOcCMzMapwTgZlZjXMiMDOrcU4EZmY1zonAzKzG/T9znMS30iZE6QAAAABJRU5ErkJggg==\n"
     },
     "metadata": {
      "needs_background": "light"
     }
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "\n",
    "combined_pv.plot(kind=\"bar\", rot=30)\n",
    "plt.xlabel(\"Service Category\")\n",
    "plt.ylabel(\"% of dissatisfied employees\")\n",
    "plt.title(\"Percentage of dissatisfied employees\")\n",
    "plt.show()"
   ]
  },
  {
   "source": [
    "From the chart above, employees who worked for the institutes for a longer period of time (`Established` and `Veteran`) resigned due to some kind of dissatisfaction. The percentage of resigned dissatisfied employees is lower in `New` and `Experienced` employees."
   ],
   "cell_type": "markdown",
   "metadata": {}
  }
 ]
}