{ "cells": [ { "cell_type": "markdown", "metadata": { "collapsed": true }, "source": [ "## Resignation in Australian Civil Service\n", "Employee retention has many benefits. It can help with efficiency, customer satisfaction, and workplace diversity. Understanding why people choose to resign is key in building a stable group.\n", "
This paper looks at the Australian Department of Education, Training, and Employment (DETE) as well as the Technical and Further Education (TAFE) institute in Queensland, Australia. It compares rates of resignation to the length of employment and to the age of employee." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "# import necessary libraries and set display options\n", "import pandas as pd\n", "import numpy as np\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline\n", "pd.options.display.float_format = '{:20,.4f}'.format\n", "pd.set_option('display.max_rows', None)\n", "pd.set_option('display.max_columns', None)\n", "pd.set_option('display.width', 3000)\n", "pd.set_option('display.colheader_justify', 'center')\n", "pd.set_option('display.precision', 3)\n", "\n", "# open files\n", "dete_survey = pd.read_csv(\"dete_survey.csv\", na_values=\"Not Stated\")\n", "tafe_survey = pd.read_csv(\"tafe_survey.csv\")" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
IDSeparationTypeCease DateDETE Start DateRole Start DatePositionClassificationRegionBusiness UnitEmployment StatusCareer move to public sectorCareer move to private sectorInterpersonal conflictsJob dissatisfactionDissatisfaction with the departmentPhysical work environmentLack of recognitionLack of job securityWork locationEmployment conditionsMaternity/familyRelocationStudy/TravelIll HealthTraumatic incidentWork life balanceWorkloadNone of the aboveProfessional DevelopmentOpportunities for promotionStaff moraleWorkplace issuePhysical environmentWorklife balanceStress and pressure supportPerformance of supervisorPeer supportInitiativeSkillsCoachCareer AspirationsFeedbackFurther PDCommunicationMy sayInformationKept informedWellness programsHealth & SafetyGenderAgeAboriginalTorres StraitSouth SeaDisabilityNESB
01Ill Health Retirement08/20121,984.00002,004.0000Public ServantA01-A04Central OfficeCorporate Strategy and PeformancePermanent Full-timeTrueFalseFalseTrueFalseFalseTrueFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseTrueAANNNAAAANNNAAANAANNNMale56-60NaNNaNNaNNaNYes
12Voluntary Early Retirement (VER)08/2012NaNNaNPublic ServantAO5-AO7Central OfficeCorporate Strategy and PeformancePermanent Full-timeFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseAANNNNAAANNNAAANAANNNMale56-60NaNNaNNaNNaNNaN
23Voluntary Early Retirement (VER)05/20122,011.00002,011.0000Schools OfficerNaNCentral OfficeEducation QueenslandPermanent Full-timeFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseTrueNNNNNNNNNNNNNNNAANNNNMale61 or olderNaNNaNNaNNaNNaN
34Resignation-Other reasons05/20122,005.00002,006.0000TeacherPrimaryCentral QueenslandNaNPermanent Full-timeFalseTrueFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseANNNAANNAAAAAAAAAAANAFemale36-40NaNNaNNaNNaNNaN
45Age Retirement05/20121,970.00001,989.0000Head of Curriculum/Head of Special EducationNaNSouth EastNaNPermanent Full-timeFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseFalseTrueFalseFalseAANNDDNAAAAAASASADDANAMFemale61 or olderNaNNaNNaNNaNNaN
\n", "
" ], "text/plain": [ " ID SeparationType Cease Date DETE Start Date Role Start Date Position Classification Region Business Unit Employment Status Career move to public sector Career move to private sector Interpersonal conflicts Job dissatisfaction Dissatisfaction with the department Physical work environment Lack of recognition Lack of job security Work location Employment conditions Maternity/family Relocation Study/Travel Ill Health Traumatic incident Work life balance Workload None of the above Professional Development Opportunities for promotion Staff morale Workplace issue Physical environment Worklife balance Stress and pressure support Performance of supervisor Peer support Initiative Skills Coach Career Aspirations Feedback Further PD Communication My say Information Kept informed Wellness programs Health & Safety Gender Age Aboriginal Torres Strait South Sea Disability NESB\n", "0 1 Ill Health Retirement 08/2012 1,984.0000 2,004.0000 Public Servant A01-A04 Central Office Corporate Strategy and Peformance Permanent Full-time True False False True False False True False False False False False False False False False False True A A N N N A A A A N N N A A A N A A N N N Male 56-60 NaN NaN NaN NaN Yes\n", "1 2 Voluntary Early Retirement (VER) 08/2012 NaN NaN Public Servant AO5-AO7 Central Office Corporate Strategy and Peformance Permanent Full-time False False False False False False False False False False False False False False False False False False A A N N N N A A A N N N A A A N A A N N N Male 56-60 NaN NaN NaN NaN NaN\n", "2 3 Voluntary Early Retirement (VER) 05/2012 2,011.0000 2,011.0000 Schools Officer NaN Central Office Education Queensland Permanent Full-time False False False False False False False False False False False False False False False False False True N N N N N N N N N N N N N N N A A N N N N Male 61 or older NaN NaN NaN NaN NaN\n", "3 4 Resignation-Other reasons 05/2012 2,005.0000 2,006.0000 Teacher Primary Central Queensland NaN Permanent Full-time False True False False False False False False False False False False False False False False False False A N N N A A N N A A A A A A A A A A A N A Female 36-40 NaN NaN NaN NaN NaN\n", "4 5 Age Retirement 05/2012 1,970.0000 1,989.0000 Head of Curriculum/Head of Special Education NaN South East NaN Permanent Full-time False False False False False False False False False False False False False False False True False False A A N N D D N A A A A A A SA SA D D A N A M Female 61 or older NaN NaN NaN NaN NaN" ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "RangeIndex: 822 entries, 0 to 821\n", "Data 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 788 non-null object \n", " 3 DETE Start Date 749 non-null float64\n", " 4 Role Start Date 724 non-null float64\n", " 5 Position 817 non-null object \n", " 6 Classification 455 non-null object \n", " 7 Region 717 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 \n", "dtypes: bool(18), float64(2), int64(1), object(35)\n", "memory usage: 258.6+ KB\n" ] }, { "data": { "text/plain": [ "None" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# dete_survey\n", "display(dete_survey.head())\n", "display(dete_survey.info())" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Record IDInstituteWorkAreaCESSATION YEARReason for ceasing employmentContributing Factors. Career Move - Public SectorContributing Factors. Career Move - Private SectorContributing Factors. Career Move - Self-employmentContributing Factors. Ill HealthContributing Factors. Maternity/FamilyContributing Factors. DissatisfactionContributing Factors. Job DissatisfactionContributing Factors. Interpersonal ConflictContributing Factors. StudyContributing Factors. TravelContributing Factors. OtherContributing Factors. NONEMain Factor. Which of these was the main factor for leaving?InstituteViews. Topic:1. I feel the senior leadership had a clear vision and directionInstituteViews. Topic:2. I was given access to skills training to help me do my job betterInstituteViews. Topic:3. I was given adequate opportunities for personal developmentInstituteViews. Topic:4. I was given adequate opportunities for promotion within %Institute]Q25LBL%InstituteViews. Topic:5. I felt the salary for the job was right for the responsibilities I hadInstituteViews. Topic:6. The organisation recognised when staff did good workInstituteViews. Topic:7. Management was generally supportive of meInstituteViews. Topic:8. Management was generally supportive of my teamInstituteViews. Topic:9. I was kept informed of the changes in the organisation which would affect meInstituteViews. Topic:10. Staff morale was positive within the InstituteInstituteViews. Topic:11. If I had a workplace issue it was dealt with quicklyInstituteViews. Topic:12. If I had a workplace issue it was dealt with efficientlyInstituteViews. Topic:13. If I had a workplace issue it was dealt with discreetlyWorkUnitViews. Topic:14. I was satisfied with the quality of the management and supervision within my work unitWorkUnitViews. Topic:15. I worked well with my colleaguesWorkUnitViews. Topic:16. My job was challenging and interestingWorkUnitViews. Topic:17. I was encouraged to use my initiative in the course of my workWorkUnitViews. Topic:18. I had sufficient contact with other people in my jobWorkUnitViews. Topic:19. I was given adequate support and co-operation by my peers to enable me to do my jobWorkUnitViews. Topic:20. I was able to use the full range of my skills in my jobWorkUnitViews. 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]WorkUnitViews. Topic:22. I was able to use the full range of my knowledge in my jobWorkUnitViews. Topic:23. My job provided sufficient varietyWorkUnitViews. Topic:24. I was able to cope with the level of stress and pressure in my jobWorkUnitViews. Topic:25. My job allowed me to balance the demands of work and family to my satisfactionWorkUnitViews. Topic:26. My supervisor gave me adequate personal recognition and feedback on my performanceWorkUnitViews. Topic:27. My working environment was satisfactory e.g. sufficient space, good lighting, suitable seating and working areaWorkUnitViews. 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 dateWorkUnitViews. Topic:29. There was adequate communication between staff in my unitWorkUnitViews. Topic:30. Staff morale was positive within my work unitInduction. Did you undertake Workplace Induction?InductionInfo. Topic:Did you undertake a Corporate Induction?InductionInfo. Topic:Did you undertake a Institute Induction?InductionInfo. Topic: Did you undertake Team Induction?InductionInfo. Face to Face Topic:Did you undertake a Corporate Induction; Category:How it was conducted?InductionInfo. On-line Topic:Did you undertake a Corporate Induction; Category:How it was conducted?InductionInfo. Induction Manual Topic:Did you undertake a Corporate Induction?InductionInfo. Face to Face Topic:Did you undertake a Institute Induction?InductionInfo. On-line Topic:Did you undertake a Institute Induction?InductionInfo. Induction Manual Topic:Did you undertake a Institute Induction?InductionInfo. Face to Face Topic: Did you undertake Team Induction; Category?InductionInfo. On-line Topic: Did you undertake Team Induction?process you undertook and how it was conducted.]InductionInfo. Induction Manual Topic: Did you undertake Team Induction?Workplace. Topic:Did you and your Manager develop a Performance and Professional Development Plan (PPDP)?Workplace. Topic:Does your workplace promote a work culture free from all forms of unlawful discrimination?Workplace. Topic:Does your workplace promote and practice the principles of employment equity?Workplace. Topic:Does your workplace value the diversity of its employees?Workplace. Topic:Would you recommend the Institute as an employer to others?Gender. What is your Gender?CurrentAge. Current AgeEmployment Type. Employment TypeClassification. ClassificationLengthofServiceOverall. Overall Length of Service at Institute (in years)LengthofServiceCurrent. Length of Service at current workplace (in years)
0634,133,009,996,093,952.0000Southern Queensland Institute of TAFENon-Delivery (corporate)2,010.0000Contract ExpiredNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNAgreeAgreeAgreeNeutralAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeStrongly AgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeNeutralAgreeAgreeYesYesYesYesFace to Face--Face to Face--Face to Face--YesYesYesYesYesFemale26 30Temporary Full-timeAdministration (AO)1-21-2
1634,133,654,064,530,944.0000Mount Isa Institute of TAFENon-Delivery (corporate)2,010.0000Retirement---------Travel--NaNAgreeAgreeAgreeAgreeAgreeStrongly AgreeStrongly AgreeAgreeStrongly AgreeAgreeAgreeAgreeDisagreeStrongly AgreeStrongly AgreeStrongly AgreeAgreeAgreeAgreeStrongly AgreeAgreeAgreeAgreeStrongly AgreeAgreeStrongly AgreeStrongly AgreeAgreeAgreeStrongly AgreeNoNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYesYesYesYesYesNaNNaNNaNNaNNaNNaN
2634,138,845,606,562,944.0000Mount Isa Institute of TAFEDelivery (teaching)2,010.0000Retirement-----------NONENaNAgreeAgreeAgreeAgreeAgreeAgreeStrongly AgreeAgreeAgreeAgreeAgreeNeutralNeutralStrongly AgreeStrongly AgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeNoNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNYesYesYesYesYesNaNNaNNaNNaNNaNNaN
3634,139,903,350,000,000.0000Mount Isa Institute of TAFENon-Delivery (corporate)2,010.0000Resignation---------Travel--NaNAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeAgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeYesNoYesYes---NaN-----YesYesYesYesYesNaNNaNNaNNaNNaNNaN
4634,146,578,511,788,032.0000Southern Queensland Institute of TAFEDelivery (teaching)2,010.0000Resignation-Career Move - Private Sector----------NaNAgreeAgreeStrongly AgreeAgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeAgreeStrongly AgreeStrongly AgreeAgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeStrongly AgreeYesYesYesYes--Induction ManualFace to Face--Face to Face--YesYesYesYesYesMale41 45Permanent Full-timeTeacher (including LVT)3-43-4
\n", "
" ], "text/plain": [ " Record ID Institute WorkArea CESSATION YEAR Reason for ceasing employment Contributing Factors. Career Move - Public Sector Contributing Factors. Career Move - Private Sector Contributing Factors. Career Move - Self-employment Contributing Factors. Ill Health Contributing Factors. Maternity/Family Contributing Factors. Dissatisfaction Contributing Factors. Job Dissatisfaction Contributing Factors. Interpersonal Conflict Contributing Factors. Study Contributing Factors. Travel Contributing Factors. Other Contributing Factors. NONE Main Factor. Which of these was the main factor for leaving? InstituteViews. Topic:1. I feel the senior leadership had a clear vision and direction InstituteViews. Topic:2. I was given access to skills training to help me do my job better InstituteViews. Topic:3. I was given adequate opportunities for personal development InstituteViews. Topic:4. I was given adequate opportunities for promotion within %Institute]Q25LBL% InstituteViews. Topic:5. I felt the salary for the job was right for the responsibilities I had InstituteViews. Topic:6. The organisation recognised when staff did good work InstituteViews. Topic:7. Management was generally supportive of me InstituteViews. Topic:8. Management was generally supportive of my team InstituteViews. Topic:9. I was kept informed of the changes in the organisation which would affect me InstituteViews. Topic:10. Staff morale was positive within the Institute InstituteViews. Topic:11. If I had a workplace issue it was dealt with quickly InstituteViews. Topic:12. If I had a workplace issue it was dealt with efficiently InstituteViews. Topic:13. If I had a workplace issue it was dealt with discreetly WorkUnitViews. Topic:14. I was satisfied with the quality of the management and supervision within my work unit WorkUnitViews. Topic:15. I worked well with my colleagues WorkUnitViews. Topic:16. My job was challenging and interesting WorkUnitViews. Topic:17. I was encouraged to use my initiative in the course of my work WorkUnitViews. Topic:18. I had sufficient contact with other people in my job WorkUnitViews. Topic:19. I was given adequate support and co-operation by my peers to enable me to do my job WorkUnitViews. Topic:20. I was able to use the full range of my skills in my job 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] WorkUnitViews. Topic:22. I was able to use the full range of my knowledge in my job WorkUnitViews. Topic:23. My job provided sufficient variety WorkUnitViews. Topic:24. I was able to cope with the level of stress and pressure in my job WorkUnitViews. Topic:25. My job allowed me to balance the demands of work and family to my satisfaction WorkUnitViews. Topic:26. My supervisor gave me adequate personal recognition and feedback on my performance \\\n", "0 634,133,009,996,093,952.0000 Southern Queensland Institute of TAFE Non-Delivery (corporate) 2,010.0000 Contract Expired NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN Agree Agree Agree Neutral Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree Strongly Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree \n", "1 634,133,654,064,530,944.0000 Mount Isa Institute of TAFE Non-Delivery (corporate) 2,010.0000 Retirement - - - - - - - - - Travel - - NaN Agree Agree Agree Agree Agree Strongly Agree Strongly Agree Agree Strongly Agree Agree Agree Agree Disagree Strongly Agree Strongly Agree Strongly Agree Agree Agree Agree Strongly Agree Agree Agree Agree Strongly Agree Agree Strongly Agree \n", "2 634,138,845,606,562,944.0000 Mount Isa Institute of TAFE Delivery (teaching) 2,010.0000 Retirement - - - - - - - - - - - NONE NaN Agree Agree Agree Agree Agree Agree Strongly Agree Agree Agree Agree Agree Neutral Neutral Strongly Agree Strongly Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree \n", "3 634,139,903,350,000,000.0000 Mount Isa Institute of TAFE Non-Delivery (corporate) 2,010.0000 Resignation - - - - - - - - - Travel - - NaN Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree \n", "4 634,146,578,511,788,032.0000 Southern Queensland Institute of TAFE Delivery (teaching) 2,010.0000 Resignation - Career Move - Private Sector - - - - - - - - - - NaN Agree Agree Strongly Agree Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Agree Strongly Agree Strongly Agree Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree Strongly Agree \n", "\n", " WorkUnitViews. Topic:27. My working environment was satisfactory e.g. sufficient space, good lighting, suitable seating and working area 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 WorkUnitViews. Topic:29. There was adequate communication between staff in my unit WorkUnitViews. Topic:30. Staff morale was positive within my work unit Induction. Did you undertake Workplace Induction? InductionInfo. Topic:Did you undertake a Corporate Induction? InductionInfo. Topic:Did you undertake a Institute Induction? InductionInfo. Topic: Did you undertake Team Induction? InductionInfo. Face to Face Topic:Did you undertake a Corporate Induction; Category:How it was conducted? InductionInfo. On-line Topic:Did you undertake a Corporate Induction; Category:How it was conducted? InductionInfo. Induction Manual Topic:Did you undertake a Corporate Induction? InductionInfo. Face to Face Topic:Did you undertake a Institute Induction? InductionInfo. On-line Topic:Did you undertake a Institute Induction? InductionInfo. Induction Manual Topic:Did you undertake a Institute Induction? InductionInfo. Face to Face Topic: Did you undertake Team Induction; Category? InductionInfo. On-line Topic: Did you undertake Team Induction?process you undertook and how it was conducted.] InductionInfo. Induction Manual Topic: Did you undertake Team Induction? Workplace. Topic:Did you and your Manager develop a Performance and Professional Development Plan (PPDP)? Workplace. Topic:Does your workplace promote a work culture free from all forms of unlawful discrimination? Workplace. Topic:Does your workplace promote and practice the principles of employment equity? Workplace. Topic:Does your workplace value the diversity of its employees? Workplace. Topic:Would you recommend the Institute as an employer to others? Gender. What is your Gender? CurrentAge. Current Age Employment Type. Employment Type Classification. Classification LengthofServiceOverall. Overall Length of Service at Institute (in years) LengthofServiceCurrent. Length of Service at current workplace (in years) \n", "0 Agree Neutral Agree Agree Yes Yes Yes Yes Face to Face - - Face to Face - - Face to Face - - Yes Yes Yes Yes Yes Female 26 30 Temporary Full-time Administration (AO) 1-2 1-2 \n", "1 Strongly Agree Agree Agree Strongly Agree No NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN Yes Yes Yes Yes Yes NaN NaN NaN NaN NaN NaN \n", "2 Agree Agree Agree Agree No NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN Yes Yes Yes Yes Yes NaN NaN NaN NaN NaN NaN \n", "3 Strongly Agree Strongly Agree Strongly Agree Strongly Agree Yes No Yes Yes - - - NaN - - - - - Yes Yes Yes Yes Yes NaN NaN NaN NaN NaN NaN \n", "4 Strongly Agree Strongly Agree Strongly Agree Strongly Agree Yes Yes Yes Yes - - Induction Manual Face to Face - - Face to Face - - Yes Yes Yes Yes Yes Male 41 45 Permanent Full-time Teacher (including LVT) 3-4 3-4 " ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "RangeIndex: 702 entries, 0 to 701\n", "Data columns (total 72 columns):\n", " # Column Non-Null Count Dtype \n", "--- ------ -------------- ----- \n", " 0 Record ID 702 non-null float64\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 \n", "dtypes: float64(2), object(70)\n", "memory usage: 395.0+ KB\n" ] }, { "data": { "text/plain": [ "None" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# tafe_survey\n", "display(tafe_survey.head())\n", "display(tafe_survey.info())" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Initial Look & Header Standardization\n", "There are many columns in both files that are not needed to answer the research questions. Making the header style more uniform allows for code that is easier to read." ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['id',\n", " 'separationtype',\n", " 'cease_date',\n", " 'dete_start_date',\n", " 'role_start_date',\n", " 'position',\n", " 'classification',\n", " 'region',\n", " 'business_unit',\n", " 'employment_status',\n", " 'career_move_to_public_sector',\n", " 'career_move_to_private_sector',\n", " 'interpersonal_conflicts',\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", " 'maternity/family',\n", " 'relocation',\n", " 'study/travel',\n", " 'ill_health',\n", " 'traumatic_incident',\n", " 'work_life_balance',\n", " 'workload',\n", " 'none_of_the_above',\n", " 'gender',\n", " 'age',\n", " 'aboriginal',\n", " 'torres_strait',\n", " 'south_sea',\n", " 'disability',\n", " 'nesb']" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/plain": [ "['id',\n", " 'institute',\n", " 'workarea',\n", " 'cease_date',\n", " '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',\n", " 'contributing_factors._travel',\n", " 'contributing_factors._other',\n", " 'contributing_factors._none',\n", " 'gender',\n", " 'age',\n", " 'employment_status',\n", " 'position',\n", " 'institute_service',\n", " 'role_service']" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# drop unnecessary columns\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)\n", "\n", "# modify & standardize header\n", "map = {'Record ID': 'id', 'CESSATION YEAR': 'cease_date', 'Reason for ceasing employment': 'separationtype',\n", " 'Gender. What is your Gender?': 'gender', 'CurrentAge. Current Age': 'age',\n", " 'Employment Type. Employment Type': 'employment_status', '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", "tafe_survey_updated = tafe_survey_updated.rename(columns=map)\n", "dete_survey_updated.columns = dete_survey_updated.columns.str.lower().str.replace(' ', '_').str.strip()\n", "tafe_survey_updated.columns = tafe_survey_updated.columns.str.lower().str.replace(' ', '_').str.strip()\n", "\n", "display(dete_survey_updated.columns.to_list())\n", "display(tafe_survey_updated.columns.to_list())" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Filtering Year Columns\n", "The code cell below shows the responses in the ```separationtype``` column. This study is focused only on resignations. The DETE survey has multiple resignation codes. All of these rows, plus the corresponding rows in the tafe survey, will be copied to new data frames. This reduces 822 DETE rows and 702 TAFE rows to 262 and 340 respectively. from The relevant values will be cleaned and the rows checked to see if they are corrupted by any outlier values." ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "scrolled": true }, "outputs": [ { "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": {}, "output_type": "display_data" }, { "data": { "text/plain": [ "Resignation 340\n", "Contract Expired 127\n", "Retrenchment/ Redundancy 104\n", "Retirement 82\n", "Transfer 25\n", "Termination 23\n", "NaN 1\n", "Name: separationtype, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# values coded into speparationtype column\n", "display(dete_survey_updated[\"separationtype\"].value_counts(dropna=False))\n", "display(tafe_survey_updated[\"separationtype\"].value_counts(dropna=False))" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/plain": [ "Resignation-Other reasons 150\n", "Resignation-Other employer 91\n", "Resignation-Move overseas/interstate 70\n", "Name: separationtype, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/plain": [ "Resignation 340\n", "Name: separationtype, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# copy separationtype rows using regex and vectorized string methods\n", "pattern = r\"Resignation\"\n", "dete_resignations = dete_survey_updated[dete_survey_updated[\"separationtype\"].str.contains(pattern, regex=True)].copy()\n", "tafe_resignations = tafe_survey_updated[tafe_survey_updated[\"separationtype\"].str.contains(pattern, regex=True, na=False)].copy()\n", "\n", "display(dete_resignations[\"separationtype\"].value_counts(dropna=False))\n", "display(tafe_resignations[\"separationtype\"].value_counts(dropna=False))" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "scrolled": false }, "outputs": [], "source": [ "# dete_start_date > 1940\n", "dete_resignations = dete_resignations[1940 < dete_resignations[\"dete_start_date\"]]\n", "\n", "# dete_start_date < role_start_date < cease_date\n", "dete_resignations = dete_resignations[1940 < dete_resignations[\"role_start_date\"]]\n", "dete_resignations = dete_resignations[dete_resignations[\"role_start_date\"] < 2021]\n", "\n", "# cease_date < current date\n", "pattern = r\"[0-9][0-9]/\"\n", "dete_resignations[\"cease_date\"] = dete_resignations[\"cease_date\"].str.replace(pattern, \"\", regex=True).astype(float)\n", "dete_resignations = dete_resignations[dete_resignations[\"cease_date\"] < 2021]" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAD5CAYAAADLL+UrAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAedUlEQVR4nO3df3hV1Z3v8feXH4ZfYm0RLgVv4/XS9oTYMte09d5STQYHvW2n0GfUNmW0lowYnk46FdsJNf3ljHkw02e4Vhyh0OCvYdIfahG0/kDnBJoOtaWCgJx2tFPtYHMVr1AJSCTxe/84K+kh5pBzkpCdk/15PU+e7LP23mt/91nnfLPO2iv7mLsjIiLxMCrqAEREZOgo6YuIxIiSvohIjCjpi4jEiJK+iEiMjIk6gL5MmTLFi4uLow7jlDly5AgTJ06MOgzpB7VdYRvp7ffLX/7yFXc/q2f5sE/6xcXF7NixI+owTpnm5mbKy8ujDkP6QW1X2EZ6+5nZC72Va3hHRCRGlPRFRGJESV9EJEaU9EVEYkRJX0QkRpT0RURiRElfRCRGlPRFRGJk2P9zlohIvsxsUOoZid83op6+iIw47t7nz7tqH+xzm5FISV9EJEaU9EVEYkRj+qeQxhUL22C0n9ru1DjvrvMGXMfpCTjvruUDqmPPZ/cMOI6hpqR/CuXyhi9e/hDP3/yxIYhG8tVX+6ntonM4dfOAn/uB3mWzePlDAzp+VDS8IyISI0r6IiIxouEdESlIJxteeaHh44NyjHfVPph13Rnjxw7KMYaakr6IFJw+x/Nv7vt62kj/5qxsNLwjIhIjSvoiIjGi4R2Jpfff+Bh/eP34gOsZ6LS9M8aP5elvzB9wHCK56jPpm9nZwN3AfwHeBNa6+7fN7O3A94Fi4HngCnc/aGbvAO4FPgDc6e5/nVHX+cCdwHjgx8DfuP57RSLwh9ePRz7PGwp3rnchq6mpYd26dbS3t1NUVMQ111zDqlWrog5ryOTS0+8Arnf3p8zsdOCXZrYFuBp4wt1vNrPlwHKgFjgGfA0oDT+ZVgNLgJ+RTvqXAg8PxomIiPSlpqaGNWvW0NDQQElJCfv27aO2thYgNom/zzF9d29196fC8mEgBcwAFgB3hc3uAhaGbY64ewvp5N/NzKYDk919e+jd3921j4jIUFi3bh0NDQ0sW7aMcePGsWzZMhoaGli3bl3UoQ2ZvMb0zawY+BPgSWCau7dC+g+DmU3tY/cZwP6Mx/tDWW/HWUL6EwHTpk2jubk5nzCHzOefOMKRgQ8LD+gj/sSx8E/zJg48iBga6Ouqra1tUF6bw/X1PRK1t7dTUlJCc3Nzd/uVlJTQ3t4em3bIOemb2STgPuCL7v5aP25G1dsOvY7nu/taYC1AWVmZD9e5tEceGfi9Vwbj/h/D9fkZ1h4Z+PM2KPO8ByEOyV1RURH79u1j2bJl3e23cuVKioqKYtMOOSV9MxtLOuFvcPf7Q/FLZjY99PKnAy/3Uc1+YGbG45nA7/MNWESkv6655pruMfySkhJWrlxJbW0t1dXVEUc2dHKZvWNAI5By95UZqzYBnwVuDr8fOFk94Y/DYTO7gPTw0FVAPK6ciMiw0HWx9oYbbuievVNdXR2bi7iQW0//w8CVwB4z2xXKbiCd7H9gZlXA74DLu3Yws+eBycBpZrYQmO/u+4Cl/HHK5sNo5o5E5PTE8gHfSx3441SGfscBoNszD6VVq1axatWq2N6Goc+kH2biZBvAn5dln+Is5Tt46zROkSE3HO7HDpqnL0NPt2EQEYkRJX0RkRhR0hcRiRElfRGRGFHSFxGJESV9EZEYUdIXkVhpamqitLSUefPmUVpaSlNTU9QhDSl9iYqIxEZTUxN1dXU0NjbS2dnJ6NGjqaqqAqCysjLi6IaGevoiEhv19fU0NjZSUVHBmDFjqKiooLGxkfr6+qhDGzLq6Q/AcPhXfv0bv0juUqkUc+fOPaFs7ty5pFKpiCIaekr6AzAc/pVf/8YvkrtEIkFLSwsVFRXdZS0tLSQSiQijGloa3hGR2Kirq6OqqopkMklHRwfJZJKqqirq6uqiDm3IqKcvIrHRdbG2pqaGVCpFIpGgvr4+NhdxQUlfRGKmsrKSysrK2N5aWcM7IiIxoqQvIhIjSvoiIjGiMX2JrUGZ7vrIwOo4Y/zYgccgkgclfYmlgf5/BaT/aAxGPSJDScM7IiIxoqQvIhIjSvoiIjGipC8iEiNK+iIiMaKkLyISI0r6IiIxoqQvIhIjSvoiIjGipC8iEiN9Jn0zO9vMkmaWMrNnzOxvQvnbzWyLmT0bfp+Zsc9XzOw5M/u1mV2SUX6+me0J6241Mzs1pyUiIr3JpaffAVzv7gngAuDzZlYCLAeecPdZwBPhMWHdp4HZwKXA7WY2OtS1GlgCzAo/lw7iuYiISB/6TPru3uruT4Xlw0AKmAEsAO4Km90FLAzLC4DvuXu7u/8WeA74oJlNBya7+3Z3d+DujH1ERGQI5DWmb2bFwJ8ATwLT3L0V0n8YgKlhsxnAf2bstj+UzQjLPctFRGSI5HxrZTObBNwHfNHdXzvJcHxvK/wk5b0dawnpYSCmTZtGc3NzrmEOuYHG1tbWNuA6hvPzM9LpuS9cg/HeK0Q5JX0zG0s64W9w9/tD8UtmNt3dW8PQzcuhfD9wdsbuM4Hfh/KZvZS/hbuvBdYClJWV+bD98uJHHhrwFysP+MuZByEG6Sc99wVNX4yeRZhh0wik3H1lxqpNwGfD8meBBzLKP21mRWZ2DukLtj8PQ0CHzeyCUOdVGfuIiMgQyKWn/2HgSmCPme0KZTcANwM/MLMq4HfA5QDu/oyZ/QDYR3rmz+fdvTPstxS4ExgPPBx+RERkiPSZ9N29hd7H4wHmZdmnHqjvpXwHUJpPgCIiMnj0H7kiIjGipC8iEiNK+iIiMaKkLyISI0r6IiIxoqQvIhIjOd+GQXpXvPyhgVfySP/rOGP82IEfX0RiQ0l/AJ6/+WMDrqN4+UODUo+ISC40vCMiEiNK+iIiMaKkLyISI0r6IiIxoqQvIhIjSvoiIjGipC8iEiNK+iIiMaKkLyISI0r6IiIxotswiGRhlu1bQjO2aTj5encfpGhEBod6+iJZuHuvP/Pnz+/+g2BmzJ8/P+u2IsONkr5IHi655BIee+wxqqur2bx5M9XV1Tz22GNccsklUYcmkhMN74jkYcuWLSxdupTbb7+d5uZmbr/9dgDWrFkTcWQiuVFPXyQP7s6KFStOKFuxYoWGcqRgqKcvkgcz45xzzuHgwYPdZWeeeWZOF31FhgP19EXyMGHCBA4ePEhxcTH33HMPxcXFHDx4kAkTJkQdmkhO1NMXycORI0eYMmUKL7zwAldeeSVmxpQpU3jllVeiDk0kJ+rpi+Spvr6ekpISRo0aRUlJCfX19VGHJJIz9fRF8nTdddfx4IMP0tnZyejRo/n4xz8edUgiOVNPXyQPRUVFHD16lFtuuYW2tjZuueUWjh49SlFRUdShieREPX2RPBw/fpzS0lI2bdrEpk2bACgtLWXfvn0RRyaSmz57+ma23sxeNrO9GWXvN7PtZrbHzDab2eRQfpqZ3RHKnzaz8ox9zg/lz5nZraY5blKAEokECxYsYPbs2YwaNYrZs2ezYMECEolE1KGJ5CSX4Z07gUt7lH0XWO7u5wE/Ar4cyq8BCOV/BvyjmXUdYzWwBJgVfnrWKTLsVVRU0NDQwOLFi3nooYdYvHgxDQ0NVFRURB2aSE76HN5x921mVtyj+D3AtrC8BXgU+BpQAjwR9nvZzA4BZWb2n8Bkd98OYGZ3AwuBhwd+CiJDJ5lMUltby/r160mlUiQSCWpra9m4cWPUoYnkpL9j+nuBTwAPAJcDZ4fyp4EFZva9UHZ++P0msD9j//3AjGyVm9kS0p8KmDZtGs3Nzf0MszCM9PMbSVKpFLfccgsXX3wxbW1tTJo0iY6ODlasWKF2LDBtbW2xbLP+Jv3FwK1m9nVgE/BGKF8PJIAdwAvAvwEdQG/j91lvVuLua4G1AGVlZV5eXt7PMAvAIw8xos9vhEkkEnzmM5/hwIED3WVnnXUWiURC7VhgmpubY9lm/Zqy6e6/cvf57n4+0AT8JpR3uPt17j7H3RcAbwOeJd2zn5lRxUzg9wOKXCQCra2tHDhwgNmzZ9PU1MTs2bM5cOAAra2tUYcmkpN+JX0zmxp+jwK+CqwJjyeY2cSw/GdAh7vvc/dW4LCZXRBm7VxFemhIpKC8+uqrzJo1C4BFixYBMGvWLF599dUowxLJWZ/DO2bWBJQDU8xsP/ANYJKZfT5scj9wR1ieCjxqZm8CLwJXZlS1lPRMoPGkL+DqIq4UpK1btzJ9+vTu4YHW1lbe+c53Rh2WSE5ymb1TmWXVt3vZ9nnSM3t6q2cHUJpPcCLD0Xvf+14OHz6Mu2NmnH766VGHJJIz3YZBJA9FRUW89tprTJ06lTvuuIOpU6fy2muv6TYMUjB0GwaRPLzxxhtMnDiRl156ic997nMATJw4kaNHj0YcmUhu1NMXyYO78+KLL+LuJJPJEx6LFAL19EXyYGZcdtlltLa2dv9H7vTp0/V1iVIw1NMXyUNpaSmPP/445557Lvfddx/nnnsujz/+OKWlmqMghUE9fZE8vPnmm5SVlbF582Y2bdqEmVFWVsbrr78edWgiOVHSF8lDKpXi2LFjjB07tnue/vHjxxk3blzUoYnkRElfJA+JRIIbb7yRjRs3do/pL1y4UPfTl4KhpC+Sh6776Tc0NFBSUsK+ffuora2luro66tBEcqKkL5IH3U9fCp2SvkgeUqkUO3fu5KabbjphTH/FihVRhyaSE03ZFMlDIpGgpaXlhLKWlhaN6UvBUNIXyUNdXR1VVVUkk0k6OjpIJpNUVVVRV1cXdWgiOdHwjkgeKivTN52tqanpHtOvr6/vLhcZ7pT0RfJUWVlJZWVlbL9uTwqbhndERGJESV9EJEaU9EVEYkRJX0QkRpT0RURiRElfRCRGlPRFRGJESV8kT01NTZSWljJv3jxKS0tpamqKOiSRnOmfs0Ty0NTURF1dHY2NjXR2djJ69GiqqqoA9F+5UhDU0xfJQ319PY2NjVRUVDBmzBgqKipobGykvr4+6tBEcqKkL5KHVCrF3LlzTyibO3cuqVQqoohE8qOkL5IH3VpZCp2SvkgedGtlKXS6kCuSB91aWQqdkr5InnRrZSlkfQ7vmNl6M3vZzPZmlL3fzLab2R4z22xmk0P5WDO7K5SnzOwrGfucH8qfM7NbzcxOzSmJnFqapy+FLJee/p3AbcDdGWXfBb7k7lvNbDHwZeBrwOVAkbufZ2YTgH1m1uTuzwOrgSXAz4AfA5cCDw/WiYgMBc3Tl0LXZ0/f3bcBr/Yofg+wLSxvAf6ia3NgopmNAcYDbwCvmdl0YLK7b3d3J/0HZOHAwxcZWpqnL4Wuv2P6e4FPAA+Q7t2fHcrvBRYArcAE4Dp3f9XMyoD9GfvvB2Zkq9zMlpD+VMC0adNobm7uZ5jRqqioyGk7azj5+mQyOQjRyGBIpVJ0dnbS3NxMW1sbzc3NdHZ2kkqlCvZ1Gldd7Rc3/U36i4FbzezrwCbSPXqADwKdwDuBM4GfmNnjQG/j956tcndfC6wFKCsr80K9WJb+UHNyuhhYWBKJBKNHj6a8vLy77ZLJJIlEQu1YYOL63uvXPH13/5W7z3f384Em4Ddh1WeAR9z9uLu/DPwU6Orlz8yoYibw+/6HLRINzdOXQtevnr6ZTXX3l81sFPBVYE1Y9TvgT83sn0kP71wA3OLurWZ22MwuAJ4ErgJWDTx8kaGlefpS6PpM+mbWBJQDU8xsP/ANYJKZfT5scj9wR1j+p7C8l/SQzh3uvjusW0p6JtB40rN2NHNHCpLm6Ush6zPpu3u2Lsy3e9m2jfSF3d7q2QGU5hWdiIgMKt17R0QkRpT0RURiRElfRCRGlPQjovu3iEgUdJfNCOj+LSISFfX0I6D7t4hIVJT0I6DvWRWRqCjpRyCRSHDFFVcwbtw4KioqGDduHFdccYW+Z7VA1NTUnNB2NTU1UYckkjON6UdgxowZbNy4kaVLl/LRj36UH//4x6xevZr58+dHHZr0oaamhjVr1tDQ0EBJSQn79u2jtrYWgFWrdGcRGf7U04/A1q1bWbRoEdu2bWPBggVs27aNRYsWsXXr1qhDkz6sW7eOhoYGli1bxrhx41i2bBkNDQ2sW7cu6tBEcqKkH4H29nYuvvjiE8ouvvhi2tvbI4pIctXe3k51dfUJZdXV1Wo7KRga3onAmDFjuP7667n33nu7p2xedtlljBmj5hjuioqKWLNmDcuWLesuW7NmDUVFRRFGJZI7ZZkITJ48mUOHDrFz505KSkrYvXs3hw4d4m1ve1vUoUkfrrnmmu4x/JKSElauXEltbe1bev8iw5WSfgQOHTrEtddeyw033EB7eztFRUVce+21fOc734k6NOlD18XazLarrq7WRVwpGBrTj0AikaC1tfWEstbWVk3ZLBCrVq3i2LFjJJNJjh07poQvBUVJPwJdUzYXL17M5s2bWbx4MRs3bmTGjKzfFS8iMiiU9COgKZsiEhWN6Uegvb2dtWvXMmHChO6v3Dt69CgbNmyIOjQRGeGU9CNQVFTEkiVL2LVrV/eXa8+ZM0fT/kTklNPwTgQuuugiNmzYwIUXXsgDDzzAhRdeyIYNG7jooouiDk1ERjj19CPw4osvsnDhQtavX8/q1aspKipi4cKFPPvss1GHJiIjnJJ+BFKpFDt37mTs2LHdY/rHjx9n3LhxUYcmIiOckn4EEokEN954Ixs3buwe01+4cKHm6YvIKaekH4GKigoaGhrecnte/Su/iJxqSvoRSCaT1NbWsn79+u6efm1tLRs3bow6NBEZ4ZT0I9A1pn/TTTedMKa/YsWKqEMTkRFOST8CGtMXkago6UdAY/oiEhUl/QhoTF9EoqKkHwGN6YtIVPq8DYOZrTezl81sb0bZ+81su5ntMbPNZjY5lC8ys10ZP2+a2Zyw7vyw/XNmdquZ2Sk7q2EukUjQ0tJyQllLS4vG9EXklMvl3jt3Apf2KPsusNzdzwN+BHwZwN03uPscd58DXAk87+67wj6rgSXArPDTs87YqKuro6qqimQySUdHB8lkkqqqKurq6qIOTURGuD6Hd9x9m5kV9yh+D7AtLG8BHgW+1mObSqAJwMymA5PdfXt4fDewEHi4v4EXssrKSgBqamq6x/Tr6+u7y0VETpX+junvBT4BPABcDpzdyzafAhaE5RnA/ox1+0NZr8xsCelPBUybNo3m5uZ+hjl8TZ8+ndtuu422tjYmTZoEMCLPcyRra2tTmxWwuLZff5P+YuBWM/s6sAl4I3OlmX0IOOruXdcBehu/92yVu/taYC1AWVmZl5eX9zPM4a/rQq4UHrVdYYtr+/Ur6bv7r4D5AGb2buBjPTb5NGFoJ9gPzMx4PBP4fX+OLSIi/devL1Exs6nh9yjgq8CajHWjSA/5fK+rzN1bgcNmdkGYtXMV6aEhEREZQrlM2WwCtgPvMbP9ZlYFVJrZvwO/It1jvyNjlwuB/e7+Hz2qWkp61s9zwG+I6UVcEZEo5TJ7J9uUkm9n2b4ZuKCX8h1AaT7BiYjI4NJ35IqIxIiSvohIjCjpi4jEiJK+iEiMKOmLiMSIkr6ISIwo6YuIxIiSvohIjCjpi4jEiJK+iEiMKOmLiMSIkr6ISIwo6YuIxIiSvohIjCjpi4jEiJK+iEiMKOmLiMSIkr6ISIwo6UekqamJ0tJS5s2bR2lpKU1NTVGHJCIx0Od35Mrga2pqoq6ujsbGRjo7Oxk9ejRVVVUAVFZm+0piEZGBU08/AvX19TQ2NlJRUcGYMWOoqKigsbGR+vr6qEMTkRFOST8CqVSKuXPnnlA2d+5cUqlURBGJSFwo6UcgkUjQ0tJyQllLSwuJRCKiiEQkLpT0I1BXV0dVVRXJZJKOjg6SySRVVVXU1dVFHZqIjHC6kBuBrou1NTU1pFIpEokE9fX1uogrIqeckn5EKisrqayspLm5mfLy8qjDEZGY0PCOiEiMKOmLiMSIkr6ISIwo6YuIxIiSvohIjJi7Rx3DSZnZAeCFqOM4haYAr0QdhPSL2q6wjfT2e5e7n9WzcNgn/ZHOzHa4e1nUcUj+1HaFLa7tp+EdEZEYUdIXEYkRJf3orY06AOk3tV1hi2X7aUxfRCRG1NMXEYkRJX0RkRhR0hcRiZFYJn0z+6aZfekk6xeaWckgHm+OmX20H/sVm9ln8tyn2cxOOvfYzL5oZhPyjacQhOds7yDWd0M/98vrOTazq83stj62KTez/9WfeKR/RmK7xDLp52AhMGhJH5gD5JX0zWwMUAzklfRz9EWgoJO+pQ3F6zfvpG9mozk1z3E5UDDJJUbKKaB2iU3SN7M6M/u1mT0OvCeUnWtmj5jZL83sJ2b23vAX+xPAt8xsV9jmLdud5DiXm9leM3vazLaZ2WnA3wGfCvV9ysw+aGb/ZmY7w++ueK42sx+a2WbgMeBm4CNhv+uyHG+8mX3PzHab2feB8RnrVpvZDjN7xsxuDGVfAN4JJM0sGcrmm9l2M3sqHH/SgJ/wUyD04lNmdjvwFNAYnus9ZvapXrYfbWbfMrNfhOfn2pPUPT20165Q50fM7GZgfCjbELbbGF4Hz5jZkoz928zs78zsSaCOHs9xlmN+zsz+3cy2Ah/OKP9zM3syvD4eN7NpZlYMVAPXhXg+YmZnmdl94fx+YWYfznasQmFmV4W2etrM7sl2jid5D802s5+H52i3mc0K5X+ZUf6d8Ic5Wwwju13cfcT/AOcDe0j3vCYDzwFfAp4AZoVtPgT8a1i+E7gsY/9et8tyrD3AjLD8tvD7auC2jG0mA2PC8sXAfRnb7QfeHh6XAw/2cW7LgPVh+X1AB1AWHnfVMxpoBt4XHj8PTAnLU4BtwMTwuBb4etRtluVci4E3gQuAvwC2hHObBvwOmB622Ru2XwJ8NSwXATuAc7LUfT1Ql/F8nR6W23ps1/Wcjgf2Au8Ijx24ImO77uc4y/Gmh5jPAk4Dftr1GgHO5I/Tqf8K+Mew/E3gSxl1/AswNyz/VyAVdRsNsH1nA7/OeG2+Pds5nuQ9tApYFJZPC+2UADYDY0P57cBVcW2XuHxd4keAH7n7UQAz2wSMI/2R7Idm1rVdUc8dQ6+3z+0y/BS408x+ANyfZZszgLtCL8SBsRnrtrj7q7mcVHAhcCuAu+82s90Z664IvdExpF/MJcDuHvtfEMp/Gs7vNGB7Hscfai+4+8/M7P8ATe7eCbwUemUf4MTzmw+8z8wuC4/PAGYBv+2l3l8A681sLLDR3XdlOf4XzOyTYfnsUN//AzqB+/I4jw8Bze5+ACB8Snt3WDcT+L6ZTSfdHr3FC+lkV5LxupxsZqe7++E84hhO/hS4191fAXD3V82s13Mk+3toO1BnZjOB+939WTObR7rj94tQz3jg5SwxjPh2iUvSh/QLI9Mo4JC7z+ljv1y3Sx/EvdrMPgR8DNhlZr3t9/dA0t0/GT4eNmesO5LLcXoetmeBmZ1D+tPMB9z9oJndSfoP3Vs2Jf2HplC+lb3r+bGTbvXHbWrc/dG+NnT3bWZ2Iel2u8fMvuXud59QmVk56Tf0/3T3o2bWzB+f02PhD1A+sv1n5CpgpbtvCsf8ZpbtRoVYXs/zuMOV0fv79C3naGar6OU95O7/EobYPgY8amZ/Feq9y92/kmMcI7pd4jKmvw34pKXHv08H/hw4CvzWzC6H7guD7w/bHwZOB3D3106y3VuY2bnu/qS7f530bVvPzqwvOAN4MSxffZK4e+6X7dwWhWOXkh7igfTH3yPAH8xsGvC/s9T7M+DDZvbfQx0TzOzdDH/bSF8nGW1mZ5H+xPPzHts8CiwNvXfM7N1mNrG3yszsXcDL7r4OaAT+R1h1vGt/0u12MCT895L+lJRNX233JFBuZu8I9V+esS7z9fHZk9T5GPDXGecw5yTHKwRPkP50+g4AM3s72c+x1/eQmf034D/c/VZgE+n3wxPAZWY2tave0N69GfHtEouk7+5PAd8HdpH+CP6TsGoRUGVmTwPPAAtC+feAL4cLNueeZLvefMvSFxb3kk5MTwNJ0h/3dln6guM/ACvM7Kekx4+z2Q10WPqiVq8XcoHVwKQwrPO3hMTn7k8DO0O860kPO3VZCzxsZsnwMfZqoCnU8TMg64XqYeRHpJ+fp4F/Bf7W3f9vj22+C+wDngrt8R2yf7otJ/3JbCfp6wXfDuVrgd2WvpD7CDAmPE9/T/q5yqb7Oe5tpbu3ku4pbgceJ31huss3SQ8n/oQT7/e+mXTnZZeZfQT4AlBm6QuW+0hfUCxY7v4MUA9sDe+1lWQ/x2zvoU8Be81sF+nX8d3uvg/4KvBYaLstpIc7e4thxLeL7r0jIhIjsejpi4hIWpwu5A4qM6vjxPE+gB+6e/0pOt4lQEOP4t+6+yd72156Z2bnAff0KG539w+dwmM+yVtnfF3p7ntO1TGlb3FtFw3viIjEiIZ3RERiRElfRCRGlPRFRGJESV9EJEb+P3R5NSQVFFmiAAAAAElFTkSuQmCC\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "dete_resignations.boxplot(column=[\"dete_start_date\", \"role_start_date\", \"cease_date\"])" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Filtering Year Columns Continued\n", "The DETE dataframe had one row in the `role_start_date` column with a year entry of 200. This row was excluded. There are a number of rows with NaN, but they can stay in because Pandas vectorized methods accommodate them. The first question is to assess connections between resignation and newer employees. The TAFE dataframe includes a employment duration column. A similar column needs to created for the DETE information. " ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Less than 1 year 73\n", "1-2 64\n", "3-4 63\n", "5-6 33\n", "11-20 26\n", "7-10 21\n", "More than 20 years 10\n", "Name: institute_service, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/plain": [ "count 290\n", "unique 7\n", "top Less than 1 year\n", "freq 73\n", "Name: institute_service, dtype: object" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# display TAFE institute service\n", "display(tafe_resignations[\"institute_service\"].value_counts())\n", "display(tafe_resignations[\"institute_service\"].describe())" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "11-20 52\n", "More than 20 years 41\n", "7-10 39\n", "5-6 38\n", "3-4 36\n", "1-2 36\n", "Less than 1 year 20\n", "Name: institute_service, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/plain": [ "count 262\n", "unique 7\n", "top 11-20\n", "freq 52\n", "Name: institute_service, dtype: object" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# create and display DETE institute service column\n", "# the dictionary reassigns discrete numbers into a more useable range\n", "dete_resignations[\"institute_service\"] = dete_resignations[\"cease_date\"] - dete_resignations[\"dete_start_date\"]\n", "di = {0.0: \"Less than 1 year\", 1.0: \"1-2\", 2.0:\"1-2\", 3.0:\"3-4\", 4.0:\"3-4\", 5.0:\"5-6\", 6.0:\"5-6\", 7.0:\"7-10\",\n", " 8.0:\"7-10\", 9.0:\"7-10\", 10.0:\"7-10\", 11.0:\"11-20\", 12.0:\"11-20\", 13.0:\"11-20\", 14.0:\"11-20\", 15.0:\"11-20\",\n", " 16.0:\"11-20\", 17.0:\"11-20\", 18.0:\"11-20\", 19.0:\"11-20\", 20.0:\"11-20\", 21:\"More than 20 years\",\n", " 22:\"More than 20 years\", 23:\"More than 20 years\", 24:\"More than 20 years\", 25:\"More than 20 years\",\n", " 26:\"More than 20 years\", 27:\"More than 20 years\", 28:\"More than 20 years\", 29:\"More than 20 years\",\n", " 30:\"More than 20 years\", 31:\"More than 20 years\", 32:\"More than 20 years\", 33:\"More than 20 years\",\n", " 34:\"More than 20 years\", 35:\"More than 20 years\", 36:\"More than 20 years\", 38:\"More than 20 years\",\n", " 39:\"More than 20 years\", 41:\"More than 20 years\", 42:\"More than 20 years\", 49:\"More than 20 years\"}\n", "dete_resignations['institute_service'] = dete_resignations['institute_service'].map(di)\n", "\n", "display(dete_resignations[\"institute_service\"].value_counts())\n", "dete_resignations[\"institute_service\"].describe()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Aggregating Dissatisfaction\n", "Each dataset has multiple resignation columns that could be considered as dissatisfaction, as opposed to other reasons such as `ill_health`, `study`, or `maternity`. These columns will be aggregated into a single `dissatisfied` column for each dataset. Values will be coded to True or False. At this time, the NaN values are being coded as False." ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/plain": [ "- 277\n", "Contributing Factors. Dissatisfaction 55\n", "NaN 8\n", "Name: contributing_factors._dissatisfaction, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/plain": [ "- 270\n", "Job Dissatisfaction 62\n", "NaN 8\n", "Name: contributing_factors._job_dissatisfaction, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# inspect TAFE resignation values\n", "display(tafe_resignations[\"contributing_factors._dissatisfaction\"].value_counts(dropna=False))\n", "display(tafe_resignations[\"contributing_factors._job_dissatisfaction\"].value_counts(dropna=False))" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [], "source": [ "# convert TAFE resignation values to boolean values\n", "# vectorized methods are amazing\n", "def boolean_bummer(element):\n", " if pd.isnull(element):\n", " return np.nan\n", " elif element == \"-\":\n", " return False\n", " else:\n", " return True\n", "\n", "tafe_resig_factors = [\"contributing_factors._dissatisfaction\", \"contributing_factors._job_dissatisfaction\"] \n", "tafe_resignations[tafe_resig_factors] = tafe_resignations[tafe_resig_factors].applymap(boolean_bummer)" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/plain": [ "False 277\n", "True 55\n", "NaN 8\n", "Name: contributing_factors._dissatisfaction, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/plain": [ "False 270\n", "True 62\n", "NaN 8\n", "Name: contributing_factors._job_dissatisfaction, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# inspect TAFE resignation values after converting to boolean\n", "display(tafe_resignations[\"contributing_factors._dissatisfaction\"].value_counts(dropna=False))\n", "display(tafe_resignations[\"contributing_factors._job_dissatisfaction\"].value_counts(dropna=False))" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [], "source": [ "# create new TAFE column `dissatisfied` using .any()\n", "# trying to preserve NaN as NaN does not work, gets converted to True or False\n", "tafe_resignations[\"dissatisfied\"] = tafe_resignations[tafe_resig_factors].any(axis=1, skipna=True)" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
contributing_factors._dissatisfactioncontributing_factors._job_dissatisfactiondissatisfied
39FalseFalseFalse
40TrueFalseTrue
41FalseFalseFalse
42FalseFalseFalse
45FalseFalseFalse
46FalseFalseFalse
47TrueFalseTrue
49FalseFalseFalse
51NaNNaNFalse
52FalseTrueTrue
53FalseFalseFalse
\n", "
" ], "text/plain": [ " contributing_factors._dissatisfaction contributing_factors._job_dissatisfaction dissatisfied\n", "39 False False False \n", "40 True False True \n", "41 False False False \n", "42 False False False \n", "45 False False False \n", "46 False False False \n", "47 True False True \n", "49 False False False \n", "51 NaN NaN False \n", "52 False True True \n", "53 False False False " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# inspect all three columns for logical errors\n", "tafe_resignations = tafe_resignations.reindex()\n", "display(tafe_resignations.loc[39:53,[\"contributing_factors._dissatisfaction\", \"contributing_factors._job_dissatisfaction\",\n", " \"dissatisfied\"]])" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "True 132\n", "False 130\n", "Name: dissatisfied, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# create new DETE column `dissatisfied` using .any()\n", "dete_resig_factors = [\"job_dissatisfaction\", \"dissatisfaction_with_the_department\", \"physical_work_environment\",\n", " \"lack_of_recognition\", \"lack_of_job_security\", \"work_location\", \"employment_conditions\",\n", " \"work_life_balance\", \"workload\"]\n", "\n", "dete_resignations[\"dissatisfied\"] = dete_resignations[dete_resig_factors].any(axis=1, skipna=True)\n", "display(dete_resignations[\"dissatisfied\"].value_counts())" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Combine Datasets\n", "Both datasets are ready to combine. Vertical concatenation will work best for the purpose of this study. Only the relevant columns will be used. They will be used to create new two new columns, one of age groups, and the other length of employment groups." ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ageinstitute_servicedissatisfiedinstitute
036-407-10FalseDETE
141-4511-20TrueDETE
231-353-4FalseDETE
346-5011-20TrueDETE
431-353-4FalseDETE
\n", "
" ], "text/plain": [ " age institute_service dissatisfied institute\n", "0 36-40 7-10 False DETE \n", "1 41-45 11-20 True DETE \n", "2 31-35 3-4 False DETE \n", "3 46-50 11-20 True DETE \n", "4 31-35 3-4 False DETE " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ageinstitute_servicedissatisfiedinstitute
59721 255-6FalseTAFE
59851-551-2FalseTAFE
599NaNNaNFalseTAFE
60051-555-6FalseTAFE
60126 303-4FalseTAFE
\n", "
" ], "text/plain": [ " age institute_service dissatisfied institute\n", "597 21 25 5-6 False TAFE \n", "598 51-55 1-2 False TAFE \n", "599 NaN NaN False TAFE \n", "600 51-55 5-6 False TAFE \n", "601 26 30 3-4 False TAFE " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# make two new dataframes containing only relevant columns\n", "dete_resignations_up = dete_resignations[[\"age\", \"institute_service\", \"dissatisfied\"]].copy()\n", "tafe_resignations_up = tafe_resignations[[\"age\", \"institute_service\", \"dissatisfied\"]].copy()\n", "\n", "# add institute column to each dataset w/ dataset label\n", "dete_resignations_up[\"institute\"] = \"DETE\"\n", "tafe_resignations_up[\"institute\"] = \"TAFE\"\n", "\n", "# combine dataframes vertically\n", "combined = pd.concat([dete_resignations_up, tafe_resignations_up], ignore_index=True)\n", "display(combined.head())\n", "display(combined.tail())" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1-2 100\n", "3-4 99\n", "Less than 1 year 93\n", "11-20 78\n", "5-6 71\n", "7-10 60\n", "More than 20 years 51\n", "NaN 50\n", "Name: institute_service, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# use institute_service to create new service_cat column\n", "# function to reassign institute_service values\n", "def service_changer(element):\n", " if element == \"Less than 1 year\" or element == \"1-2\":\n", " return \"New\"\n", " elif element == \"3-4\" or element == \"5-6\":\n", " return \"Experienced\"\n", " elif element == \"7-10\":\n", " return \"Established\"\n", " elif pd.isnull(element):\n", " return np.nan\n", " else:\n", " return \"Veteran\"\n", " \n", "combined[\"service_cat\"] = combined[\"institute_service\"].apply(service_changer)\n", "display(combined[\"institute_service\"].value_counts(dropna=False))" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "41-50 155\n", "Under 30 131\n", "31-40 128\n", "51-60 119\n", "NaN 52\n", "Over 60 17\n", "Name: age_groups, dtype: int64" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# use age to create new age_groups column\n", "alpha = r\"[a-z]*\"\n", "combined[\"age_groups\"] = combined[\"age\"]\n", "combined[\"age_groups\"] = combined[\"age_groups\"].str.replace(\" \",\"-\").str.replace(alpha, \"\", regex=True).str.replace(\"--\", \"-\")\n", "combined[\"age_groups\"] = combined[\"age_groups\"].str.replace(\"20-\", \"Under 30\").str.replace(\"21-25\", \"Under 30\").str.replace(\"26-30\", \"Under 30\")\n", "combined[\"age_groups\"] = combined[\"age_groups\"].str.replace(\"31-35\", \"31-40\").str.replace(\"36-40\", \"31-40\").str.replace(\"41-45\", \"41-50\").str.replace(\"46-50\", \"41-50\")\n", "combined[\"age_groups\"] = combined[\"age_groups\"].str.replace(\"51-55\", \"51-60\").str.replace(\"56-60\", \"51-60\").str.replace(\"56-\", \"51-60\").str.replace(\"61-\", \"Over 60\")\n", "display(combined[\"age_groups\"].value_counts(dropna=False))" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAFFCAYAAAAXcq1YAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAplklEQVR4nO3deZhcZZn+8e8dAgSiAZRFWZRl2BERAyIKKgIyjoKIbCIuoMhPVNxQGB23GR3FBR0dRQZFFAVRQRSEgKAgyg4Ja1QE1AQUEZCwE3L//jhvkUrT6XR1VeV0nb4/11VXVZ06VfXU1d1vn3rP8z6PbBMREc0yqe4AIiKi9zK4R0Q0UAb3iIgGyuAeEdFAGdwjIhoog3tERAP1bXCXtJuk30m6WdKR/XqfiIh4MvUjz13SMsDvgV2AOcAVwP62b+z5m0VExJP068h9W+Bm27fYfhQ4BdijT+8VERFD9GtwXwv4S9v9OWVbREQsBZP79LoaZtsi8z+SDgEOAdAyKz1/0qSpfQolIqKZ5j86d7ixFujfkfscYJ22+2sDt7fvYPs429NtT8/AHhHRW/0a3K8ANpS0nqTlgP2An/bpvSIiYoi+TMvYni/pncAMYBngW7Zv6Md7RUTEk/UlFbJTk5dbq/4gIiIGTB1z7hERUaMM7hERDTTmwV3SOpJ+KekmSTdIOrxsf66kSyRdJ+lnkqb1LtyIiBiNbo7c5wPvt70psB1wmKTNgOOBI20/BzgdOKL7MCMiohNjHtxt32H76nJ7HnAT1SrUjYGLym7nAXt1G2RERHSmJ3PuktYFngdcBlwP7F4e2ptFFzNFRMRS0PXgLukpwI+B99i+DziIaormKuCpwKOLed4hkq6UdOWCBQ90G0ZERLTpKs9d0rLAmcAM218c5vGNgJNsbzvS6yTPPSKic33Jc5ck4JvATe0Du6TVy/Uk4CPAsWN9j4iIGJtupmVeBBwI7CRpZrm8Ethf0u+B2VTFwk7oQZwREdGBlB+IiBhQKT8QETHBdFUVUtJtwDzgcWC+7emStqKaZ59CtdDpHbYv7zLOiIjoQC9K/r7M9l1t948GPmH77DIHfzTw0h68T0REjFI/pmUMtOrJrMSQDkwREdF/3ea53wrcQzWgf8P2cZI2pWrSIap/Htvb/tNIr5MTqhERnRvphGq30zIvsn17yW0/T9Js4HXAe23/WNI+VLnwOw994pAG2aSPakRE7/QsFVLSx4H7gf8AVrbtstDpn7ZHLPv72F23NPrIfYU1d6g7hIgJ6aHbf113CH217Krr9/7IXdJUYJLteeX2rsAnqebYXwL8CtgJ+MOSXiuDX0T0Q9PHlvmPzl3sY91My6wBnF4dnDMZ+L7tcyTdD3xZ0mTgYcrUS0RELD1ZoRoRMaCyQjUiYoLJ4B4R0UDdlh94L/BWqjz364C3ACdStdoDWBm41/ZW3bxPRER0pptsmbWAdwOb2X5I0qnAfrb3bdvnC8A/uw8zIiI60e0ipsnACpIeA1akrdRAyXHfhyodMiIilqIxD+6250r6PPBn4CHgXNvntu2yA/A320vMc2/6QoOm59pGjFdNH1tG0s20zCrAHsB6wL3ADyW9wfZJZZf9gZNHeH7KD0REXzX9wGqkRUzdZMvsDNxq+++2HwNOA7YHKAuYXgv8YHFPtn2c7em2p2dgj4jorW4G9z8D20lascyvvxy4qTy2MzDb9pxuA4yIiM6NeXC3fRnwI+BqqjTIScBx5eH9GGFKJiIi+ivlByIiBlTKD0RETDBLHNwlfUvSnZKub9u2t6QbJC2QNH3I/ltKuqQ8fp2kKf0IPCIiFm80R+7fBnYbsu16qmyYi9o3liyZk4BDbW9O1Rj7sa6jjIiIjiwxz932RZLWHbLtJoBSy73drsC1tmeV/f7RmzAjIqITvZ5z3wiwpBmSrpb0wR6/fkREjEK3tWWGe70XA9sADwLnS7rK9vlDd8wK1YiI/un1kfsc4ELbd9l+EPg5sPVwO2aFakRE//R6cJ8BbFlWrU6mapR9Y4/fIyIilmA0qZAnA5cAG0uaI+lgSXtKmgO8EDhL0gwA2/cAXwSuAGYCV9s+q2/RR0TEsLJCNSJiQGWFakTEBJPBPSKigcZUfqDtsQ9IsqRVy/11JT0kaWa5HNuPoCMiYmSjyXP/NvBV4DvtGyWtA+xCVde93R9tb9WL4CIiYmyWeORu+yLg7mEeOgb4IJCToRER48yY5twl7Q7MbdWQGWI9SddIulBSsxsYRkSMUx2XH5C0IvBhqiJhQ90BPMv2PyQ9H/iJpM1t3zfM66T8QEREn4zlyH0DYD1glqTbgLWBqyU9w/YjrUqQtq8C/khVTOxJUn4gIqJ/Oj5yt30dsHrrfhngp9u+S9JqwN22H5e0PrAhcEuvgo2IiNEZU/mBEXbfEbhW0iyq5tmH2h7uZGxERPRRyg9ERAyolB+IiJhgxtog+wdtq1BvkzRzyHOeJel+SR/oQ8wREbEEY1qhanvf1m1JXwD+OeQ5xwBn9yC+iIgYgzE1yG5R1SF7H2Cntm2vocqQeaA3IUZERKe6nXPfAfib7T8ASJoKfAj4RLeBRUTE2HU7uO8PnNx2/xPAMbbvX9ITJR0i6UpJVy5YkIP8iIheGlUqZJmWOdP2Fm3bJgNzgefbnlO2/RpYp+yyMrAA+Kjtr470+kmFjIjo3EipkB2vUG2zMzC7NbAD2H6iUJikjwP3L2lgj4iI3utmhep+LDolExER40RWqEZEDKisUI2ImGAyuEdENNBo5tzXkfRLSTdJukHS4WX70ySdJ+kP5XqVsn3bttIEsyTt2e8PERERi1rinLukZwLPtH21pKcCVwGvAd5MVbv9M5KOBFax/aHSqelR2/PLc2cBa9qev7j3yJx7RETnuppzt32H7avL7XnATcBawB7AiWW3E6kGfGw/2DaQTyENtCMilrqO5tzLYqbnAZcBa9i+A6p/ACzanekFkm4ArqNq2PGko/asUI2I6J9Rp0JKegpwIfAp26dJutf2ym2P32N7lSHP2ZTqqH5H2w8v7rUzLRMR0bmuUyElLQv8GPie7dPK5r+VOfXWvPydQ59n+yaq6pBbDH0sIiL6ZzTZMgK+Cdxk+4ttD/0UeFO5/SbgjLL/eqXuDJKeDWwM3NbDmCMiYglGky3zYuDXVPPnC8rmf6eadz8VeBbwZ2Bv23dLOhA4Enis7P9J2z8Z6T0yLRMR0bmRpmVSfiAiYkCl/EBExATTzQrV/5R0bVmJeq6kNcv2XSRdJem6cr3TyO8QERG91s0K1Tm27yv7vBvYzPahkp5H1XrvdklbADNsrzXSe2RaJiKic1016ygLlFqLleZJuglYy/aNbbtNpaxEtX1N2/YbgCmSlrf9yFiCj4iIznXUiWnIClUkfQp4I/BP4GXDPGUv4JoM7BERS9eoT6iWFao/Bt7Tmo6x/WHb6wDfA945ZP/Ngc8Cb1/M66X8QEREn4y2QfaywJlU8+dfHObxZwNntRpoS1obuAB4i+3fLOn1M+ceEdG5rlIhF7dCVdKGbbvtDswu21cGzgKOGs3AHhERvdfNCtWDqUoLLAD+RFX9ca6kjwBHAX9oe5ldbT+p9kxLjtwjIjqXFaoREQ2UFaoRERPMmFeolsfeJel3ZfvRZdvTy/73S/pqP4OPiIjhjSbPfT7w/vYVqpLOA9agarW3pe1HJLU6MT0M/AdVDffUcY+IqMGYV6gCbwM+01qg1DphavsB4GJJ/9K3qCMiYkTd9FDdCNhB0mWSLpS0TR/ii4iIMRh1+YGhK1RLt6VVgO2AbYBTJa3vUabfSDoEOARAy6zEpElTOw4+IiKG100P1TnAaa5cTpXvvupo39j2cban256egT0iore66aH6E2Cnss9GwHLAXX2IMSIiOtTNCtVfAN8CtgIeBT5g+4LynNuAaVQD/r1UK1TbSwQvIouYIiI6lxWqEREN1FWzjqXhodt/XXcI0YUV1tyh7hCiC/n7a6aUH4iIaKDRzLmvA3wHeAbVnPtxtr8s6bnAscBTgNuAA9p6qh5FVTXyceDdtmeM9B6ZlomI6Fy3hcNa5Qc2pcppP0zSZsDxwJG2nwOcDhwBUB7bD9gc2A34mqRluvsIERHRiW7KD2wMXFR2Ow+YQVVTZg/glFKW4FZJNwPbApcs7j0y5zfYMuc+2PL310zdNMi+nqoD0xnA3sA6Zbe1gEvbnjanbFusDA4R9cnf3+Ca/+jcxT7WTYPsg6imaK4CnkqV6w4w3BzQk+bU0yA7IqJ/RnXkPlz5AduzgV3L4xsB/1Z2n8PCo3iAtYHbh76m7eOA4yAnVCMieq2bBtmrl+tJwEeoMmcAfgrsJ2l5SesBGwKX9zrwiIhYvNEcub8IOBC4TtLMsu3fgQ0lHVbunwacAGD7BkmnAjdSZdocZvvxnkYdEREjSvmBiIgBlQbZERETzGjm3KdIulzSrNII+xNl+97l/gJJ09v2X07SCZKuK895af/Cj4iI4Yxmzv0RYCfb95esmYslnU2V5/5a4BtD9n8bgO3nlJOuZ0vaxvYCIiJiqVjikXvptHR/ubtsudj2TbZ/N8xTNgPOL8+9k6qe+/Rh9ouIiD4ZbZu9ZUqmzJ3AebYvG2H3WcAekiaXVMjns2jee0RE9NmoBnfbj9veimpB0raSthhh929RLWS6EvgS8FuqlMhFZIVqRET/dFRbxva9kn5FVe3x+sXsMx94b+u+pN8Cfxhmv6xQjYjok9Fky6wmaeVyewVgZ2D2CPuvKGlqub0LMH+k/qkREdF7ozlyfyZwYqnJPgk41faZkvYEvgKsBpwlaabtVwCrAzMkLQDmUq1ujYiIpWhcrFB97K5b6g8ixiwlYwdb6rkPrmVXXX+xK1THxeCeOfeIiM6NVH6goxOq/ZIjh8GWI/fBlr+/ZhpNg+wpVO30lqf6Z/Aj2x9re/wDwOeA1WzfVVaxHg9sXfb/ju3/Huk9cuQeEdG5bo/chy0/YPtSSesAuwB/btt/b2D5Un5gReBGSSfbvq2LzxARER0Yc/mBcv8Y4IMs2kbPwFRJk4EVqNrv3deziCMiYonGXH5A0u7AXNuzhuz+I+AB4A6qI/rP2767hzFHRMQSjOqEaumktFVZzHS6pC2BD1N6qA6xLfA4sCawCvBrSb+wfUv7TpIOAQ4B0DIrMWnS1DF/iIiIWNRYyw/sAawHzKparLI2cLWkbYHXA+fYfgy4U9JvqKpC3jLktZ4oP5A898GWbJnBlmyZZhpNtsxqwGNlYF8BOBf4rO0z2/a5DZhesmU+BGwCHASsCFwB7Gf72sW9R7JlIiI61222zLDlB0bY/3+pmmVfDwg4YaSBPSIiei8rVCMiBlQaZEdETDBLnJZZ3ApVST8ANi67rQzca3srSQcAR7S9xJbA1rZn9jLwiIhYvNGcUBUwtX2FKnC47Uvb9vkC8E/bnxzy3OcAZ9hef6T3yLRMRETnujqh6mr0X9wK1dbgvw+w0zBP3x84uZNgIyKie71okL0D8DfbT2qlB+xLBveIiKWuFw2yhz06l/QC4EHbw/ZaTYPsiIj+6TgVUtLHgAdsf74UB5sLPN/2nCH7HQP83fanl/SamXOPiOhcV6mQS2iQvTMwe5iBfRJV6d9TxhhzRER0odsVqvsx/Jz6jsCcocXCIiJi6cgK1YiIAZUeqtFXqQo52PL310w5co+IGFA9qS1Tct2vkXRmuf80SedJ+kO5XqVt3y0lXSLpBknXlRIGERGxlHRSOOxw4Ka2+0cC59veEDi/3KekR54EHGp7c+ClwGM9iTYiIkZltCtU1wb+DTi+bfMewInl9onAa8rtXYFrW71Vbf+jtOmLiIilZLRH7l8CPggsaNu2hu07AMr16mX7RoAlzZB0taQP9irYiIgYndEsYnoVcKftq0b5mpOBFwMHlOs9Jb18mNdN+YGIiD4ZzZH7i4DdS5/UU4CdJJ0E/E3SMwHK9Z1l/znAhbbvsv0g8HNg66Evavs429NtT580aWoPPkpERLQscXC3fZTttW2vS7Ui9QLbbwB+Cryp7PYm4IxyewawpaQVy8nVlwA39jzyiIhYrG4WMX0GOFXSwcCfqWrJYPseSV8ErqCq+/5z22d1HWlERIxaFjFFRAyoNMiOiJhgRj0tU6pCXgnMtf0qSf9Jleu+gOpk6ptt3y5pXarFTr8rT73U9qEjvXZqWwy21JYZbPn7a6ZuVqh+zvaWpUPTmcBH2x77o+2tymXEgT0iInpvVEfubStUPwW8D8D2fW27TKWtaXancuQXUZ/8/Q2u+Y/OXexj3axQRdKnJP2FasFS+5H7eqXI2IWS8psTEbGUdbVC1faHba8DfA94Z9l8B/As28+jOsr/vqRpw7xuVqhGRPTJElMhJf03cCAwH5gCTANOKwuZWvs8GzjL9hbDPP9XwAdsX7m490gqZERE57pKhVzcClVJG7bttjulaXZpqL1Mub0+sCGQXqoREUtRVytUJW1MNQ//J6CVFbMj8ElJ84HHqeq6391dmBER0YmsUI2IGFBZoRoRMcFkcI+IaKAxN8gu294l6XelEfbRQ/Z/lqT7JX2glwFHRMSSdXJCtVV+YBqApJdR1ZbZ0vYjklYfsv8xwNk9iTIiIjrSTYPs/wd8xvYjALbvbNv/NVTpjzf0LNKIiBi1bsoPbATsIOmyUmZgGwBJU4EPAZ/oZaARETF63ZQfmAysAmwHHEHVlUlUg/oxtu9fwuum/EBERJ+MufwAsCrVtMyvyn5/pBroTwPWKU9fmepo/6O2v7q490iee0RE50bKc+9oEZOkl1LViXmVpEOBNW1/VNJGwPlUBcPctv/Hgfttf36k183gHhHRuZEG927KD3wL+Jak64FHgTd5jMtd0wlmsKUe+GDL318zpfxARMSASvmBiIgJZswrVCU9V9Ilkq6T9LNWQw5J20qaWS6zJO3Zr+AjImJ43TTIPh440vZzgNOp0iEBrgeml8bZuwHfkNTN3H5ERHSomxWqGwMXldvnAXsB2H7Q9vyyfQpdNM6OiIix6WaF6vVUHZgA9mZhbjuSXiDpBuA6qmYd84mIiKVmidMl7StUS557y0HA/0j6KPBTqnRIAGxfBmwuaVPgREln2354yOseAhwC8LUv/BdvfeP+3X6WqElSIQdbUiGbqVcNsjcCTrK97TDP/yVwRBpkR0T0Vr8aZK8OIGkS8BHg2HJ/vdYJVEnPppqbv63bDxEREaPXTZ77/pJ+D8wGbgdOKNtfDMySNJMqi+Ydtu/qKsqIiOjIuFih+thdt9QfRIxZ5twHW+bcB9eyq67fm8Jh/ZI594iIzqX8QETEBDOqlaOSbgPmAY8D821Pl/Q54NVUKZB/BN5i+15JuwCfAZYrjx1h+4KRXj9fCwdbpmUGW/7+mmlU0zJlcJ/efmJU0q5UmTPzJX0WwPaHJD0P+Jvt2yVtAcywvdZIr59pmYiIzvVlWsb2uW0rTy8F1i7br7F9e9l+AzBF0vJjfZ+IiOjcaAd3A+dKuqqsLB3qIODsYbbvBVxj+5GxBhgREZ0bbbXGF5VpltWB8yTNtn0RgKQPU61e/V77EyRtDnwW2HW4F2wvP6BlVmLSpKlj/AgRETFUx6mQ7X1RJb0JOBR4ue0H2/ZZG7iA6iTrb5b0mplzj4joXFdz7pKmSnpq6zbVkfj1knYDPgTsPmRgXxk4CzhqNAN7RET03mgKh61PVUYAqmmc79v+lKSbgeWBf5THLrV9qKSPAEcBf2h7mV1t37m498gK1cGWVMjBllTIwZUVqhERDZQVqhERE8xo2+zdVhphz5R0Zdn2cUlz25phv7Jsf7qkX0q6X9JX+xl8REQMr5PG1S8bpnTvMbY/P2Tbw8B/AFuUS0RELGU9n5ax/YDti6kG+YiIqEG3K1TfKelaSd+StEof4ouIiDEY7eD+IttbA/8KHCZpR+DrwAbAVsAdwBc6eWNJh0i6UtKVCxY80MlTIyJiCUY1uLcKgZVc9dOBbW3/zfbjthcA/wc8qTn2El7zONvTbU9P6YGIiN7qZoXqM9t22xO4vj8hRkREp0aTLbMGcLqk1v7ft32OpO9K2opqPv424O2tJ5T679OA5SS9hmqF6o09jTwiIhYrK1QjIgZUVqhGREwwGdwjIhqom/IDW0m6tLVN0rZt+x8l6WZJv5P0in4FHxERw+um/MDRwCdsn13qyhwNvFTSZsB+wObAmsAvJG1k+/GeRR0RESPqZlrGVBkxACsBrabYewCn2H7E9q3AzXSYAx8REd0Z7ZF7q/yAgW/YPg54DzBD0uep/klsX/ZdC7i07blzyraIiFhKxtwgG3gd8F7bP5a0D/BNYGdguNScJ6U6pkF2RET/jLn8APAm4LSyyw9ZOPUyB1in7elrs3DKpv01U34gIqJPxlx+gGrAfknZbScW9kz9KbCfpOUlrQdsCFze68AjImLxuik/cD/wZUmTqWq3HwJg+wZJpwI3AvOBw5IpExGxdI2L8gOP3XVL/UHEmK2w5g51hxBdeOj2X9cdQozRsquun/IDERETSQb3iIgGGhfTMkubpENKrn4j5fMNtiZ/viZ/Nhhfn2+iHrkfsuRdBlo+32Br8udr8meDcfT5JurgHhHRaBncIyIaaKIO7uNiTqyP8vkGW5M/X5M/G4yjzzchT6hGRDTdRD1yj4hotAzuERENlME9IqKBJtzgXipbRsRSUqrDLnHboJO0iqQt646jZcIM7pK2l3QjcFO5/1xJX6s5rJ6RtIakb0o6u9zfTNLBdcfVDUnzJN23uEvd8fWSpI0knS/p+nJ/S0kfqTuuHvnxMNt+tNSj6ANJv5I0TdLTgFnACZK+WHdcMIEGd+AY4BXAPwBszwJ2rDWi3vo2MIOqKTnA76laIQ4s20+1PQ34EnAkVbvGtYEPAf9VY2j98H/AUcBjALavpWo0P7AkbSJpL2AlSa9tu7wZmFJzeL2yku37gNcCJ9h+PlVHutqNts1eI9j+S6lL39KkOvOr2j5V0lEAtudLasrne4XtF7Td/7qky4Cj6wqoD1a0ffmQ38/5dQXTIxsDrwJWBl7dtn0e8LY6AuqDyZKeCewDfLjuYNpNpMH9L5K2ByxpOeDdlCmahnhA0tMp/WolbQf8s96QeuZxSQcAp1B9vv1p1j9mgLskbcDCn9/rgDvqDak7ts8AzpD0QtuX1B1Pn3yS6hvzb2xfIWl9Fnalq9WEWcQkaVXgyyxs4n0ucLjtf9QaWI9I2hr4CrAFVRvE1YDXla/3A03SulQ/uxdRDX6/Ad5j+7Yaw+qpMigcB2wP3APcChxg+0+1BtYDkqYABwOb0zYdY/ug2oKaACbM4D4RlJaHG1P98/qd7cdqDilGSdJ6tm8t2VyTbM9rbas7tm5J+iEwG3g91ZHuAcBNtg+vNbAeKP+UvwxsR3XgcQnVgUftP7cJM7hL+p9hNv8TuLJ8fRxokg4Dvmf73nJ/FWB/2wOfESRpI+DrwBq2tyjpZrvbbsxJVUlX2956yLarygm6gSbpGtvPk3St7S0lLQvMsL1T3bF1S9KlwP8CJ5dN+wHvGnKOqBYTKVtmCrAV1XzYH4AtgacBB0v6Un1h9czbWgM7gO17aM5Jq8ZlkrRMkIyS1jfIeyVtAawErFtfOD0l29+1Pb9cTqKcN6nbRDqh+i/ATrbnA0j6OtW8+y7AdXUG1iOTJMnlq5ikZYDlao6pV5qYSdIyETJKjivfJD8C/BR4CvDRekPqmV9KOpKFJ/v3Bc4qee/YvruuwCbS4L4WMJWFGSRTgTVtPy7pkfrC6pkZwKmSjqX6JTsUOKfekHqmcZkkLRMho8T28eXmRcD6dcbSB/uW67cP2X4Q1e9rbZ93Is25H0x15PArqhOOOwKfppor+7jtI+qLrnuSJlH9gr2chdlAx9se+JTBxWSSvKFh2TInMMzX+SZklEj6NHD0kPNB77fdlBW449KEGdwBJK0JHEh15n4qMMf2RfVGFaPVnklSdyy9VubdW6YAewK32353TSH1TOuE6pBtTzqBPIgkvXG47ba/s7RjGWrCTMtIeitwONXy9ZlUqUuXAAN9xl7Sqbb3kXQdwx/5jZtCRp2S9AbbJ0l635DtANgeFzU8esH2IvVXJJ0M/KKmcHptGUnL234EQNIKwPI1x9Qr27TdnkL1zflqIIP7UnQ41Q/iUtsvk7QJ8ImaY+qFVq7wq2qNoj9WLNdPrTWKemwIPKvuIHrkJOD8tqmng4AT6w2pN2y/q/2+pJWA79YUziIm0uD+sO2HJVGOImZL2rjuoLplu3Vi8bXAqbbn1hlPj21Qrm+0/cNaI+kzSfNY9JvXX6kKpA0820dLupaFq8P/0/aMmsPqlwep/jHXbiIN7nMkrQz8BDhP0j3A7bVG1FvTgHMl3U2VlvUj23+rOaZuvbKUvT0KaPTgbrvR305sn8NisrckXWL7hUs5pJ6Q9DMW/lNeBtgUOLW+iBaaUCdUWyS9hGohxTm2H607nl4qqzf3BfaiOmE8LsqPjoWkzwGHUJ38frD9IcClHHAjSDrf9suXtK2JhjvhOijKWNIyH/iT7Tl1xdNuIh25P8H2hXXH0Ed3Un2l/wewes2xdKWkpx4h6Qzbe9QdTz+UolorAquWFMHWSq1pLKzN33QDe4Rp+0JJa7DwxOq4qAgJE6v8QKNJ+n+SfgWcD6xKVY5gYDNlhnh9yeNvdSzavdQnaYK3A1cBm1BlWVxVLmdQ1SyJcUzSPsDlwN5UNd0vK4vsajchp2WaSNJ/Az+wPbPuWHpN0lXADsAqwKXAlcCDtg+oNbAekvQu21+pO446DPi0zCxgF9t3lvurAb+w/dx6I5ug0zJNU45qX237qLpj6RPZfrCsMv5Kyb64pu6gekHSTrYvAOZKeu3Qx22fVkNYPSfp2cCGtn9R8twnty1GO7DG0Lo1qTWwF/9gnMyIZHBvANsLJM2S9Czbf647nj6QpBdS1QFvNf1uyu/uS4ALWLRoWIuBgR/cJb2N6sT406jSW9cGjqVa8IPt6+uLrmvnSJrBwpK/+wI/rzGeJ2RapiEkXUB1Uudy4IHWdtu71xZUj5SMhPdTtTL7bKk1854mLM1vGa4xR4OadcwEtgUua02/SLrO9nNqDaxLqpZKr031d/diqpPhF9k+vdbAigzuDTEkJesJDc8MaoyGN+u4zPYL2pp2TAaubsIJ//H8M2rKV9sJr6Rktc9rrki1qGJgSfqS7fcMWSjyhIZ8K9mEqrfoSkPm3KfRnGYdF0r6d2AFSbsA7wB+VnNMvXKppG1sX1F3IEPlyL0h2uc1bW8gaUPg2EFeBCPp+bavavK3Ekl7AK8BdqdqZNEyDzjF9m/riKuXygn/g4FdqaYuZlCVox74wUfSjcBGwJ+opkNbC+xq/1aSwb0hmjqvCSDpcNtfXtK2QdbkZh2lVPPDrd4CpUvY8rYfHPmZ41/5tvwktv+0tGMZalyk7ERPPNJeSqHMazblP/ebhtn25qUdRJ/tKWmapGUlnS/pLklvqDuoHjkfWKHt/go0p5zxvGEu46JmVQb35hg6r/lDBnxeU9L+Zb59PUk/bbv8kiqfuEl2tX0fVenmOVRf9Qe6O1ibKbbvb90pt1ccYf9BcjXwd+D3VKUH/g7cKulqSbWeaM0J1eY4kmpe8zqqJe0/B44f8Rnj32+peqWuCnyhbfs84NpaIuqfVjmFVwIn275bizYEH2QPSNra9tVQnUsBHqo5pl45Bzi9VcJY0q7AblSVIb8GvKCuwDLn3kCqOq+vbbtpA2BjSfoM1YnVh6jOnawMnGm7tsGhVyRtQ1WGujVd8UxgX9tX1RdVb0i60vb04bZJmml7q5pCy+DeFKVo2O5U38ZmUn09vND2+0Z42kCQtB3wFapa2ctRpXg+0KSSv/BE4+j7bD9eUlmn2f5r3XH1Qin0tjFVNsls24/VHFJPSDqX6pzCKWXTvsAuVEfvV9TZJzbTMs2xku37VPWKPcH2x0r3myb4KrAf1XmE6cAbgX+pNaL+2BRYt5wMb6m9F+dYtermDFMzZ0NJTamb83rgY1RNgAAuLtuWoaoSWZsM7s0xWdIzqX6hPlx3ML1m+2ZJy5R0uhMkDXz+dztJ36WquzITeLxsNgM8uDMB6ubYvgt412IevlnSV4b2WV1aMrg3xyepFodcbPuKUn9l3DQO6NKDkpYDZko6muok69SaY+q16cBmTVjY02L7Y+XmW1s57hPQi+p646RCNoTtH9re0vY7yv1bbO/VelzSIJcDPpDqd/WdVKsA16FqI9gk1wPPqDuIPrlV0nGSXq4GpQCNdzmhOkEMV5hqEJWTjus0LROo5O5vRVXV85HW9obUz1mBampmP2Br4Eyq0goX1xrYUlDn312mZSaOgT1iGi4TSFIjMoHafLzuAPrF9kNUed+nln/OXwYuZMAL241SbX93GdwnjkH+itbkTCCgGUXQRlKKv+0L/CtwBTVnkvSapKm2HxjmodrqH2XOfeIY2CN3Fs0EOrPuYHpJ0sXlep6k+9ou8yTdV3d8vSDpVuA9wK+BLWzvY/vH9UbVG5K2L5Uhbyr3nyvpa63HbX+7rthy5D5x/LDuALrQ2Ewg2y8u10+tO5Z+KBUgT7D9ybpj6ZNjgFdQyjXbniVpx3pDquSEakNI2gj4OrCG7S0kbQnsbvu/ag4tJjhJv7T9srrj6IehXabKtlm2n1t3bJmWaY7/A44CHgMo2ST71RpRj0g6usHlcCeC30r6qqQdJG3dutQdVI/8RdL2gCUtJ+kDlCmaumVapjlWtH35kDTi+XUF02O72v6gpD2pyuHuDfwSOKnesGKUti/X7VMzBnaqIZZeO5TqpOlaVL+b5wKH1RpRkcG9Oe6StAElK0bS66hWcjZBk8vhNl5Tp2TgifIDB9Qdx3AyuDfHYcBxwCaS5gK3Mk5/6cbgZ5JmU5XDfYek1YCHa44pRknSGsCngTVt/6ukzYAX2v5mzaF1TdL/DLP5n8CVts9Y2vG0ywnVhpC0nu1bS7/KSbbntbbVHVsvNLkcbtNJOhs4Afiw7eeWqpfXNKS/73HAJizMRtsLuIGqRMYttt9TU2gZ3JtiuGXOkq6yXWurr26MUDIWoCklYxtP0hW2txmSUVJrI4tekXQB1Tmh+eX+ZKp5912A62xvVldsmZYZcJI2ATYHVhoyCE4DptQTVc/syMKSsaZaiNV+ncF9MDwg6eksPB+0HdXURROsRVWhtPV5plJNPz0u6ZHFP63/MrgPvo2pmiqvzKJ1s+cBb6sjoB6aJ+l9VBUTW4M6DHYphYnofVSLfDaQ9BtgNeB19YbUM0dTlaL+FdXv547Ap8v06C/qDCyD+4ArJ23OkPRC25fUHU+PPaVcbwxsA5xB9Qf0auCiuoKKjm1AVVOmVar5BTRk7LH9zXJO4UBgNtWUzJxSZ+aIOmPLnHtDSDqBYY5obR9UQzg9VfpU7mV7Xrn/VOCHtnerN7IYDUnX2t5S0oupsma+APx7Q5p/vxU4HFibqmLpdsAltmvP4c8K1eY4EzirXM6nmnO/v9aIeudZwKNt9x8F1q0nlBiDVhemfwOOLd82l6sxnl46nOpb5Z9KPv/zqJrT164RX40ChlbZk3QyNc/59dB3gcslnU717WRP4MR6Q4oOzJX0DWBn4LOSlqc5B5YP235YEpKWtz1b0sZ1BwUZ3JtsQ6oj3oFn+1NlXnOHsukttq+pM6boyD7AbsDnbd9byjfXOh/dQ3MkrQz8BDhP0j3A7bVGVGTOvSEkzWPROfe/Akc1pW52xHhXGpKsBJxj+9El7d/3eDK4R0Q0T1PmvSY8SeePZltETAyZcx9wkqYAKwKrlvorrYU+04A1awssImqVwX3wvZ2qP+WawNVt2+8D/reOgCKifplzbwhJ77L9lbrjiIjxIYP7gEvlxIgYTqZlBt9LWFg5cahUToyYoHLk3hDDNeZoUrOOiOhMUiGbY7jFSj9a6lFExLiQaZkB1/BmHRExRhncB1+Tm3VExBhlzr0hGtqsIyLGKHPuzbGnpGmSlpV0vqS7JL2h7qAioh4Z3JtjV9v3UU3RzAE2ojllVSOiQxncm2PZcv1K4GTbd9cZTETUKydUm+NnkmYDDwHvkLQa8HDNMUVETXJCtUFKVcj7bD8uaUVgmu2/1h1XRCx9OXJvlk2BdSW1/1y/U1cwEVGfDO4NIem7wAbATBZ2mzcZ3CMmpEzLNISkm4DNnB9oRJBsmSa5HnhG3UFExPiQaZnmWBW4UdLlwCOtjbZ3ry+kiKhLBvfm+HjdAUTE+JE594iIBsqR+4CTdLHtF0uaR5Ud88RDgG1Pqym0iKhRjtwjIhoo2TIREQ2UwT0iooEyuEdENFAG94iIBsrgHhHRQP8f1MRJEPuZ2IwAAAAASUVORK5CYII=\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "# heatmap showing missing values in pink\n", "import seaborn as sns\n", "display(sns.heatmap(combined.isnull(), cbar=False))" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAdIAAAEICAYAAADrxXV/AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAf9klEQVR4nO3de5wcVZn/8c8XEq4BIgQjgUAUVC4KkQCLoisqgqACQhA0P1kUYdF1ASWKrgioKKio3GQ18HMjIhDumwUUWCByRxJMoiAoBjBcDIQkQDBEEp7945xOKm3PdM+cmWlm5vt+vfqV7qrTVc+pc6qeqlPVE0UEZmZm1j2rtTsAMzOz/syJ1MzMrIATqZmZWQEnUjMzswJOpGZmZgWcSM3MzAoMmEQqaYKkG9q07v+QdH471j2QSPqlpH/pw/W11GckrS3pfyQ9J+myHo7hx5K+1pPLHIgkTZZ0SgfzDpN0e1/H1JskhaStemhZn5E0T9JiSRv1xDK7Gcfukh5v1/p7U1sSqaRHJS3JDfvXvJMMK1lmRPwiIvbsqRg70qgzRMS3I+LTvb3uujhC0ot5Gz4r6SZJB/fi+h6VtEfB95vGGxF7R8TPyqNtuP4xOYYhlfW12mfGAyOBjSLioIIY/uGAHxFHRcQ3u7vMLq7//ZJukfRCboOZko6XtFZfrL8/kDRNUl/vy722TklDgR8Ae0bEsIh4tm5+bb9YXPfqtWNJf9Jq27TzivTDETEMGAu8DfhKG2Ppr3bI2/DNwGTgHEkntTekTvW3eGu2AP4YEcvaHUh3SToIuBy4CNgiIjYCDgY2A0Z38J0hjaZbvzISWAu4v0m54TnR1l5T+iC2gSMi+vwFPArsUfn8XeDayuddgTuBRcAsYPfKvMOAOcALwCPAhMr02yvl9gQeAp4DzgV+DXy6WhY4HViYl7N35bufBP6Q1zEH+Nc8fV1gCfAKsDi/RgEnAxdWvr8vqeMuAqYB29TVfSIwO8c2BVgrzxsBXJO/twC4DVitg20YwFZ108YDL5GunBpt5/o4O9zOdcv9ea7zklznLzWrZzfjnVZpo61ymz0HzAem5OkCfgg8nefNBt6S530Q+C3wPDAXOLmyrr/kGGrt9nYqfaaj5QJfB/4OvJy/dziwJXAz8GyO7RekA1FtXaOBK4FncplzgG1yXZfn5SzKZScDp1S+ewTwcG7/qcCoum14FPAnUr/9EaAW9jfl7XFck3Ink5LthXkbfprUv6fmeB4GjqiUr499d+Dxur7+FeCBHO9/kft6nv8hYGbuP3cC21fmvQ24j7QPTgEuqa6rLu7DgDuAs3PbPQi8L887CJhRV/444OoOljWN3AcbzPsU6biwELiedELStG2A1YHv577yCPC5XH4I8K3cJ17K/eKcrrY1sCZwBvBkfp2Rp70JeJGV/f7mBt8dU4ulg2VPJh0/f5mXcQfwuryOhXlbv62VNm/QP7bJ23sR6Tiyb56+MzCvGhNwIDCz0k8vI/XTF4Df5bp+hbT/ziVdgde+uwHw/4GngCeAU4DVm+WCjtqm4XZqthP2xovKAZ50Rvw74Mz8eVPSwWcf0hXz+/PnjUmJ7HngzbnsJsB21Q2S34/I5Q4gddZjSAfCaiJ9mXTQWh34TO6AtY7/QdLBUsC7gb8BOzbqDJWGvTC/r3Xe9wNDgS+RDkBrVOr+G9IBakPSjnlUnncq8OP8vaHAu+h452mUmIYCyyodYcV2bhBnh9u5WZu1Us9uxjut0kYXA1/Nsa0FvDNP3wuYAQzP7bMNsEmlbd6av7M9aWfcv6MDBqv2mc6Wu2K75c9b5XqvSeqXtwJnVA6as0hJed262Fesr+5AdUp+/17SwXbHvOyzgVvrtuE1OcbNSYn6Ay3sb1vn745pUu5k0n6xf96Ga5NOZs7N9Rib1/m++tg7OFA+CvyedGKxIekgXKvrjqSD3j/lbfYvufyawBrAY8DnSX1kfI6rs0S6rFL+YFJC3TAvbwGrnsz+Fjiwg2VNo0Eizdvk4dwvhgAnAHe20jakhPgA6Vj3GuB/qfTFRuvsSlsD3wDuBl5L6o93At/sqN/XfbfZ/MmkPjku94GbScnm0NxupwC3tNjmK/pHbqeHgf/I7f1eUlKsHdsfYNWLm6vIJ4KkfvoSaZ8dAlyQY/pqXu4RwCOV714N/IS0P76WdPytXRwdRue5oGF/qH+1c2j3akkvkM4engZOytP/H3BdRFwXEa9ExI3AdNIBH9KV0VskrR0RT0VEoyGLfYD7I+LKSMNxZwF/rSvzWEScFxHLgZ+RkvJIgIi4NiL+HMmvgRtISa0VB5Ourm+MiJdJZzprA++olDkrIp6MiAXA/5AOUJAadBPSme7LEXFb5NZsRV7ffFIHbqbZdm6mlXqWxPsyaUh1VES8FBG3V6avR0oOiog/RMRTeXnTIuJ3uT6zScn43S2G0+FyG8T9cK730oh4hnQPqraeXUgnSV+MiBfrYm9mAvDTiLgvIpaSzrDfLmlMpcxpEbEoIv4C3MLKvtOZEfnfFfuApEskLZL0N0mfqJS9KyKujohX8vfeCRyf6zETOB+olm/mnIiYm/v6t4CP5elHAD+JiHsiYnmke+NLSaMku5IOiGfk/eBy4N4m63m6Un4KaTTqg3k7TiH1dyRtR0oe13ShDgD/Cpya+8Uy4NvAWElbVMp01DYfJV0oPB4RC4HTWlxnq209AfhGRDyd++PX6VobAczP/aH22qYy76qImBERL5ES2ksRcUE+dk4hjR5UddTmVbsCw3Id/x4RN5PapFb2Z6xssw1JSfOiyvdvi4jrc1tcRjqBOC0fUy4BxkgaLmkksDdwbN4fnyad5B5SWVaHuaBV7Uyk+0fEeqSzlK1ZubNvARxUbVTSzrxJRLxIOoAfBTwl6VpJWzdY9ihSggYgJ6P6p8X+Wpn/t/x2GICkvSXdLWlBXv8+lfiaGUU6m64t+5Ucy6aN1k262q09aPU90lnaDZLmSPpyi+skxz2U1KEWtFC8w+3c4upaqWdJvF8iXRn+RtL9kj6V13Mzaaj0R8A8SZMkrZ+X90/5YZpnJD1H6icttVtny20Q92tzInpC0vOkIabaekaTdszu3E+t36aLSaMErfSdztQeMFnRthFxSEQMJw2frl4pO7fyfhSwICJeqEx7jC60cd3yHsvLhNT/jqvrf6Pz/FHAE3UnkY/RuUbla+v6GfBxSSIlmEtzgu2KLYAzK7EuIPXPVtpmleNR3fvOtNrWq/QbVq17q0ZExPDK6w+VefMq75c0+FwfV0dtXh/z3HzcqJatbc8LgQ/nh1A/Skqc1RPb+hjm50RY+0yOawvSSdlTlbb7CenKtKbDXNCqtv/8JV/xTSZd0UBqhJ/XNeq6EXFaLn99RLyfdFB4EDivwWKfIg2jAJB3oM0alPsHktYErsjxjMwHm+tIOw2kYZDOPElqvOq6R5PG5jsVES9ExHER8Qbgw8AXJL2vlbiz/UhDXL/Jn18E1qnMf13lfafbuVF4dZ+7Xc9O4l25soi/RsQRETGKdDVwbu3nABFxVkSMA7YjDTF/MX/tItL9vNERsQFpmLzVdutsufVOzcvbPiLWJ50519YzF9i8gwd1utp31gU2omvbtJEH8zIOaKFsNcYngQ0lrVeZtnklns76V031QabN8zIhbadv1fW/dSLiYtL+u2nuU9XvdqZR+ScBIuJu0n3udwEfJ93z76q5pOHAarxrR8SdLXx3leMR//hwV8ujTh1Ypd+w6nZuh47avOpJYLSk1erKPgEQEU8AdwEfIZ38dKfNILXbUlY9UVg/IrZr8fsttU3bE2l2BvB+SWNZeSayl6TVJa2Vf3KymaSRkvbNB5ilpBvAyxss71rgrZL2zwe0f6PxTt7IGqT7Ks8AyyTtTXpwqWYesJGkDTr4/qXAByW9L19xHZdjbbrDSfqQpK3yAeH5XLdG9av/3oaSJpCupr4TKx9xnwkcImmopJ1I95pqOtzOHaxmHvCGHqpnR/FWyxxUiWUhqUMvl7RzvvIcSjqQ1x7ggTQ0uyAiXpK0C+mgWfMM6bZAtQ7V9XW23HrrkR8YkrQpqybc35AOnKdJWjdv193yvHnAZpLW6GC5FwGflDQ2n9B9G7gnIh7toHw1/trPGMbUz8tXascBJ0k6QtJrlLyRToawImIuqT1PzfXYnvSw1S9ykZnAPrk9Xwcc22Ax/5b33Q1J98NqT4OeBxyVt7nytvpgTtp3kU6wjpY0RNIBpCHzzrw2lx+q9ITyNqQT4JoLSCMOy1oYah+S61t7DSWdlH1FaWgYSRvk9bTiUuAYSZtKGg4cXze/ft/qqouBEyRtLGkEcCJp/26Xjtq86h7Sfval3Ga7ky4eLqmUuYA0MvVW0pByl+Wr2BuA70taX9JqkraU1Ootn5ba5lWRSPO4/gXA1/LOux+pAZ4hnVF8kRTraqQDwpOkoZV3A59tsLz5pKf1vksa1tqWdP+v6XBOHsY6mtT5F5IOxlMr8x8kddw5eahgVN33HyJdoZxNuv/3YdJPff7ewqZ4I+lBhMWkg8m5ETGtk/KzJC0mDQd/Gvh8RJxYmf810kNTC0n3TVbcY2iynRs5lbSzLpI0sZv1bBZv1c7APbn8VOCYiHgEWJ90EF5IGgp6lpWjGZ8FvqF07/1EUhvW6vs30v2aO3Iddq1bX2fLrfd10sMyz5FO2q6srGd53hZbkZ4Ufpx0OwLSgxr3A3+VNL9+oRFxE6nNriAl4y1Z9V5OZ0bnuBteveb7hh8ltdlcUptdCkwi3WPqyMdI9xSfJB3MTop0Px3SVcIs0gMmN9D4gHlRnjcnv07J8Uwn3Sc9h7TNHyY9+EHuQwfkzwtJ2+9KOncPaf+ZT2rn8XUnaD8nPYXdypXNf5KGB2uv/4qIq4DvAJcoDef/nnTvrRXnkbbBbNKDTteRThRqJ2pnAuMlLZR0VovLrDqFdHybTXpw8748rSsWadXfkX6hG3HUNGzzqtzG+5K24XzSA22H5uNrzVWkK+2r8m297jqUdIFUe5L4clq/hdVS29SeTBrQ8vDB46SfytzS7njMepqkE4BnIuIn7Y6lRtKjpCce//dVEMvapAeSdoyIP7U5lr2BH0fEFk0L9zM93eaS/kwaUm97H+rMgP3BtaS9SGepS0hXWiI9Im424EREV69ABpvPAPe2I4nmJP4e0lXaSNIvFLo1VDmYSDqQdEvn5nbH0syATaSkH9xfxMpL+v0jYknnXzGzgSZfJYn0W9C2hEC6HTCFdGJ/LenWg3VA0jTSLblP1D3Z+6o0KIZ2zczMesur4mEjMzOz/mogD+32ihEjRsSYMWPaHYaZWb8yY8aM+RGxcbvj6A1OpF00ZswYpk+f3u4wzMz6FUnN/jpVv+WhXTMzswJOpGZmZgWcSM3MzAo4kZqZmRVwIjUzMyvgRGpmZlbAidTMzKyAE6mZmVkBJ1IzM7MCTqRmZmYFnEjNzMwKOJGamZkV8B+t76IZM+Yhnd7uMMzMWhYxsd0hDGi+IjUzMyvgRGpmZlbAidTMzKyAE6mZmVkBJ1IzM7MCTqRmZmYFnEjNzMwKOJGamZkVcCI1MzMr0LZEKmmapL3qph0r6dwOyh8raZ2+ic7MzKw17bwivRg4pG7aIXl6I8cCXUqkklbvelhmZmata2civRz4kKQ1ASSNAUYB60i6S9J9ki6TNEzS0XneLZJuyeX3rC+Xpz8q6URJtwMHSTpC0r2SZkm6onZVK2mypLMk3SlpjqTxbdgGZmbWz7UtkUbEs8BvgA/kSYcANwFfBfaIiB2B6cAXIuIs4EngPRHxHkkjgBPqy1UW/1JEvDMiLgGujIidI2IH4A/A4ZVymwDvBD4EnNZbdTUzs4Gr3f/7S21497/zv1cCHwbukASwBnBXg+/tCmzbSbkplfdvkXQKMBwYBlxfmXd1RLwCPCBpZEdBSjoSODJ9Gt5i1czMbDBodyK9GviBpB2BtYHfAjdGxMeafE9Nyr1YeT8Z2D8iZkk6DNi9Mm9p3TIbiohJwCQAaXQ0ic3MzAaRtv78JSIWA9OAn5KuTu8GdpO0FYCkdSS9KRd/AVgvv++sXL31gKckDQUm9EpFzMxs0Ho1/I70YmAH4JKIeAY4DLhY0mxSwtw6l5sE/FLSLU3K1fsacA9wI/Bgb1XCzMwGJ0V4pLIr0tDuMe0Ow8ysZRET2x0CkmZExE7tjqM3vBquSM3MzPotJ1IzM7MCTqRmZmYFnEjNzMwKOJGamZkVcCI1MzMr4ERqZmZWwInUzMysQLv/1m6/M27cSKZPb/+Pm83M7NXBV6RmZmYFnEjNzMwKOJGamZkVcCI1MzMr4ERqZmZWwInUzMysgBOpmZlZASdSMzOzAk6kZmZmBZxIzczMCjiRmpmZFXAiNTMzK+BEamZmVsCJ1MzMrIATqZmZWQEnUjMzswJOpGZmZgWcSM3MzAo4kZqZmRVwIjUzMyvgRGpmZlbAidTMzKyAE6mZmVkBJ1IzM7MCTqRmZmYFnEjNzMwKDGl3AP3NjBnzkE5vdxhmPSpiYrtDMOu3fEVqZmZWwInUzMysgBOpmZlZASdSMzOzAk6kZmZmBZxIzczMCjiRmpmZFXAiNTMzK+BEamZmVsCJ1MzMrEC/T6SSQtL3K58nSjq5jSGZmdkg0u8TKbAUOEDSiHYHYmZmg89ASKTLgEnA5+tnSNpY0hWS7s2v3fL030karuRZSYfm6T+XtEffhm9mZv3ZQEikAD8CJkjaoG76mcAPI2Jn4EDg/Dz9DmA3YDtgDvCuPH1X4O76hUs6UtJ0SdNhcW/Eb2Zm/dSA+G/UIuJ5SRcARwNLKrP2ALaVVPu8vqT1gNuAfwYeA/4TOFLSpsCCiPiHTBkRk0hXvUijo9cqYmZm/c5AuSIFOAM4HFi3Mm014O0RMTa/No2IF4BbSVeh7wKmAc8A40kJ1szMrGUDJpFGxALgUlIyrbkB+Fztg6SxuexcYATwxoiYA9wOTMSJ1MzMumjAJNLs+6QEWXM0sJOk2ZIeAI6qzLsH+GN+fxuwKSmhmpmZtazf3yONiGGV9/OAdSqf5wMHd/C9T1Te38nAO6kwM7M+4ORhZmZWwInUzMysgBOpmZlZASdSMzOzAk6kZmZmBZxIzczMCjiRmpmZFej3vyPta+PGjWT69IntDsPMzF4lfEVqZmZWwInUzMysgBOpmZlZASdSMzOzAk6kZmZmBZxIzczMCjiRmpmZFXAiNTMzK+BEamZmVsCJ1MzMrIATqZmZWQEnUjMzswJOpGZmZgWcSM3MzAo4kZqZmRVwIjUzMyvgRGpmZlbAidTMzKyAE6mZmVkBJ1IzM7MCTqRmZmYFnEjNzMwKOJGamZkVcCI1MzMr4ERqZmZWwInUzMysgBOpmZlZgSHtDqC/mTFjHtLp7Q7DrN+LmNjuEMx6hK9IzczMCjiRmpmZFXAiNTMzK+BEamZmVsCJ1MzMrIATqZmZWQEnUjMzswJOpGZmZgWcSM3MzAo0TaSSlkuaWXl9uTcDkrRvb6+jk3U/KmlEO9ZtZmb9Uyt/InBJRIzt7UAAJA2JiKnA1L5Yn5mZWaluDe1K2kDSQ5LenD9fLOmI/H6xpO9Luk/STZI2ztO3lPQrSTMk3SZp6zx9sqQfSLoF+I6kwySdk+dtLOkKSffm1255+smSfippmqQ5ko6uxHaopNmSZkn6eZPlbCTpBkm/lfQTQN3dkGZmNji1kkjXrhvaPTgingM+B0yWdAjwmog4L5dfF7gvInYEfg2clKdPAv49IsYBE4FzK+t4E7BHRBxXt+4zgR9GxM7AgcD5lXlbA3sBuwAnSRoqaTvgq8B7I2IH4JgmyzkJuD0i3ka6Ct680QaQdKSk6ZKmw+IWNpmZmQ0W3R7ajYgbJR0E/AjYoTLrFWBKfn8hcKWkYcA7gMukFRd9a1a+c1lELG+w7j2AbSvfWV/Sevn9tRGxFFgq6WlgJPBe4PKImJ9jXNBkOf8MHJDLXitpYaMNEBGTSCcCSKOjURkzMxucuv3fqElaDdgGWAJsCDzeQdEgXfku6uRe64sdTF8NeHtELKlbN8DSyqTlpLoor68ry3FiNDOzbiv5+cvngT8AHwN+KmloZZnj8/uPk4ZOnwceyVewKNmhfoEN3EAaQiZ/b2yT8jcBH5W0US6/YZPl3ApMyNP2Bl7TQkxmZmYrdOce6WmS3gR8GjguIm4jJaQTcvkXge0kzSANtX4jT58AHC5pFnA/sF8L6z4a2Ck/PPQAcFRnhSPifuBbwK/zen7QZDlfB/5Z0n3AnsBfWojJzMxsBUX07MimpMURMaxHF/oqku6RHtO8oJl1KmJiu0OwPiRpRkTs1O44eoP/spGZmVmBHk+kA/lq1MzMrJ6vSM3MzAo4kZqZmRVwIjUzMyvgRGpmZlbAidTMzKyAE6mZmVmBbv+t3cFq3LiRTJ/uH5KbmVniK1IzM7MCTqRmZmYFnEjNzMwKOJGamZkVcCI1MzMr4ERqZmZWwInUzMysgBOpmZlZASdSMzOzAk6kZmZmBZxIzczMCjiRmpmZFXAiNTMzK+BEamZmVsCJ1MzMrIATqZmZWQEnUjMzswJOpGZmZgWcSM3MzAo4kZqZmRVwIjUzMyvgRGpmZlbAidTMzKyAE6mZmVkBJ1IzM7MCTqRmZmYFhrQ7gP5mxox5SKe3Owwzsz4VMbHdIbxq+YrUzMysgBOpmZlZASdSMzOzAk6kZmZmBZxIzczMCjiRmpmZFXAiNTMzK+BEamZmVsCJ1MzMrEC3Eqmk5ZJmVl5f7qTs/pK2bWGZkyWNbzB9d0nX5Pf7NlnXYZLOabUena3LzMysFd39E4FLImJsi2X3B64BHujmulaIiKnA1NLlmJmZ9ZQeHdqVdJqkByTNlnS6pHcA+wLfy1euW0o6QtK9kmZJukLSOpVF7CHpNkl/lPShBstfccUp6SBJv8/LubVSbJSkX0n6k6TvVr67p6S7JN0n6TJJw/L0D0h6UNLtwAE9uT3MzGzg6+4V6dqSZlY+nwrcCHwE2DoiQtLwiFgkaSpwTURcDiBpUUScl9+fAhwOnJ2XMwZ4N7AlcIukrTqJ4URgr4h4QtLwyvSxwNuApcBDks4GlgAnAHtExIuSjge+kBPtecB7gYeBKd3aGmZmNmj12NCupCHAS8D5kq4lDec28pacQIcDw4DrK/MujYhXgD9JmgNs3UkMdwCTJV0KXFmZflNEPJdjegDYIq9rW+AOSQBrAHfl5T8SEX/K5S8EjqxfkaQjV04f3klIZmY22PTY0G5ELAN2Aa4g3Rf9VQdFJwOfi4i3Al8H1qoupn6xnazvKNJV5mhgpqSN8qyllWLLSScLAm6MiLH5tW1EHN5sHZV1TYqInSJip5T7zczMkh5LpPme4wYRcR1wLGmIFeAFYL1K0fWApyQNBSbULeYgSatJ2hJ4A/BQJ+vbMiLuiYgTgfmkhNqRu4HdakPFktaR9CbgQeD1eX0AH2teUzMzs5V66h7pr4Azgf+WtBbpCvDzed4lwHmSjgbGA18D7gEeA37Hqkn2IeDXwEjgqIh4KQ/FNvI9SW/M67oJmMXK5L2KiHhG0mHAxZLWzJNPiIg/5mHbayXNB24H3tLSFjAzMwMU0XRk0yqk0QHHtDsMM7M+FTGx6PuSZqTbYwOP/7KRmZlZASdSMzOzAk6kZmZmBZxIzczMCjiRmpmZFXAiNTMzK+BEamZmVsCJ1MzMrEB3/7LRoDVu3EimTy/7YbKZmQ0cviI1MzMr4ERqZmZWwInUzMysgBOpmZlZASdSMzOzAk6kZmZmBZxIzczMCjiRmpmZFXAiNTMzK+BEamZmVsCJ1MzMrIATqZmZWQEnUjMzswKKiHbH0K9IegF4qN1xtMEIYH67g2iDwVjvwVhncL172xYRsXEfrKfP+b9R67qHImKndgfR1yRNd70Hh8FYZ3C92x1Hf+ahXTMzswJOpGZmZgWcSLtuUrsDaBPXe/AYjHUG19u6yQ8bmZmZFfAVqZmZWQEnUjMzswJOpB2Q9AFJD0l6WNKXG8yXpLPy/NmSdmxHnD2thXpvLekuSUslTWxHjD2thTpPyG08W9KdknZoR5w9rYV675frPFPSdEnvbEecPa1ZvSvldpa0XNL4voyvN7TQ1rtLei639UxJJ7Yjzn4rIvyqewGrA38G3gCsAcwCtq0rsw/wS0DArsA97Y67j+r9WmBn4FvAxHbH3Ed1fgfwmvx+70HU1sNY+RzF9sCD7Y67L+pdKXczcB0wvt1x90Fb7w5c0+5Y++vLV6SN7QI8HBFzIuLvwCXAfnVl9gMuiORuYLikTfo60B7WtN4R8XRE3Au83I4Ae0Erdb4zIhbmj3cDm/VxjL2hlXovjnyUBdYFBsKTia3s2wD/DlwBPN2XwfWSVuts3eRE2timwNzK58fztK6W6W8GYp2a6WqdDyeNRPR3LdVb0kckPQhcC3yqj2LrTU3rLWlT4CPAj/swrt7Uah9/u6RZkn4pabu+CW1gcCJtTA2m1Z+Nt1KmvxmIdWqm5TpLeg8pkR7fqxH1jZbqHRFXRcTWwP7AN3s7qD7QSr3PAI6PiOW9H06faKXO95H+Fu4OwNnA1b0d1EDiRNrY48DoyufNgCe7Uaa/GYh1aqalOkvaHjgf2C8inu2j2HpTl9o6Im4FtpQ0orcD62Wt1Hsn4BJJjwLjgXMl7d8n0fWOpnWOiOcjYnF+fx0wdAC0dZ9xIm3sXuCNkl4vaQ3gEGBqXZmpwKH56d1dgeci4qm+DrSHtVLvgaZpnSVtDlwJfCIi/tiGGHtDK/XeSpLy+x1JD6r095OIpvWOiNdHxJiIGANcDnw2Iq7u80h7Titt/bpKW+9Cyg39va37jP/3lwYiYpmkzwHXk554+2lE3C/pqDz/x6Sn+fYBHgb+BnyyXfH2lFbqLel1wHRgfeAVSceSngB8vl1xl2ixrU8ENiJdmQAsi37+v2W0WO8DSSeLLwNLgIMrDx/1Sy3We0Bpsc7jgc9IWkZq60P6e1v3Jf+JQDMzswIe2jUzMyvgRGpmZlbAidTMzKyAE6mZmVkBJ1IzM7MCTqRmZmYFnEjNzMwK/B8AELSD4tcrGgAAAABJRU5ErkJggg==\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "# bar chart showing resignation vs length of employment categories\n", "pv_service_cat = combined.pivot_table(values=\"dissatisfied\", index=\"service_cat\")\n", "ax = pv_service_cat.plot(kind=\"barh\", legend=False, title=\"Resignations Due to Dissatisfaction, Grouped by Length of Employment\", color=\"darkblue\")\n", "ax.set_ylabel(\"\")\n", "plt.show()" ] }, { "cell_type": "code", "execution_count": 22, "metadata": { "scrolled": true }, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZIAAAEICAYAAAB1f3LfAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAeIklEQVR4nO3deZRdVZn+8e8jSSAJKGAAqQxEJpXQMZKA4tTMQ1ADSCQtLYOtDAvtbhsaRW2D2irazqIC8mNoFQMq0gg4IBppWiBUMERCGAJEEsIcAiRAJMn7+2PvIieXW1W3aqfurVSez1p35Z599jn73Wd6z5RbigjMzMx66xWtDsDMzDZsTiRmZlbEicTMzIo4kZiZWREnEjMzK+JEYmZmRZxImkjSMZJ+26K2Pynpgla0PZBI+pWk45rYXkPbjKShkn4p6WlJP13PMZwr6T/W5zwHIkkXS/rPTsYdL+nGZsfULE4knZC0UNLzkpZLeiRvJJuXzDMifhwRB62vGDsjaR9Ji2va/mJEfKiv266JIyStyMvwSUnXSzq6D9tbKOmAgum7jTciDo2IS8qjrdv+2BzDoEp7jW4zRwHbAa+OiKkFMbzsgBcRJ0fE53s7zx62f6CkP0h6Nq+DOZI+LmmzZrS/IcnHpFWS2lodixNJ194dEZsDE4A3AWe2NpwN0hvzMnwdcDFwjqTprQ2pSxtavB12AO6JiFWtDqS3JE0FfgZcCuwQEa8GjgZGAaM7mWZQvfKBTtJw4L3A08AxLQ4HIsKfOh9gIXBAZfgrwDWV4bcAfwKWAbcD+1TGHQ/cDzwLPAAcUym/sVLvIOBu0sbwPeCPwIeqdYGvAk/l+RxamfYEYH5u437gpFw+HHgeWAMsz5824CzgR5Xp3wPMy/HPBN5Q0/fTgbk5tsuAzfK4EcDVebqlwP8Cr+hkGQawc03ZUcALpDPnesu5Ns5Ol3PNfH+Y+/x87vMZ3fWzl/HOrKyjnfM6exp4Argslwv4BvBYHjcX2D2POwz4M/AMsAg4q9LWgzmGjvW2N5VtprP5Ap8F/ga8mKf7J2An4PfAkzm2HwNbVtoaDVwBPJ7rnAO8Ifd1dZ7Pslz3YuA/K9N+GFiQ1/9VQFvNMjwZuJe03X4XUAP7m/LyOK2bemeRks2P8jL8EGn7virHswD4cKV+bez7AItrtvUzgTtzvBeRt/U8/l3AnLz9/AkYXxn3JuA20j54GTCj2lZN3McD/wd8J6+7u4D987ipwOya+qcBV3axHI7Ny+tfgDtqxg0FLsn9mQ+cUdPnNuDned0/APxz8fGydAYD9UPlAEc6I/oL8K08PDLvfJNJV3UH5uFtSAfyZ4DX5brbA+MqG1PHQWFErnckMChvEC+ybiJ5kbTTbgKcAizp2ClJB6Sd8g7498BzwB71dpbKDvij/H1XYEWOe3De0BYAQyp9n5U3uK3zxnhyHvcl4Nw83WDgHXRyoKD+gXkwsIqcFOkikXS1nLtbZ430s5fxzqyso58An8qxbQa8PZcfDMwGtszr5w3A9pV183d5mvHAo8DhedzYHMOgSvvHs3ab6Wq+Ly23PLxz7vempO3yBuCbedwmpKT8DdL2Wo39pfYq87qYfIAE9iMlpj3yvL8D3FCzDK/OMY4hHawOaWB/e32edmw39c4i7ReH52U4lJTMv5f7MSG3uX9t7PX2DdI2cwcpsW5NOth39HUPUtJ+c15mx+X6mwJDgL8CHyNtI0fluLpKJKsq9Y8mJZSt8/yWsu7J3J+B93axHK4nndxul+e7R2Xc2XmZbEU6ds3t6HNeZrOBz+Q+7Eg6ET245HjpW1tdu1LSs6TM/xjQcYvjH4FrI+LaiFgTEdcB7aQDHqQz490lDY2IhyNiXp15TwbmRcQVkW5HfBt4pKbOXyPiBxGxmnSGsT1pwyEiromI+yL5I/Bb0kG9EUeTrq6ui4gXSVc9Q4G3Vup8OyKWRMRS4JekHRTSzrI96dbDixHxv5G30Ebk9p4g7UDd6W45d6eRfpbE+yLpllJbRLwQETdWyrcgHRwVEfMj4uE8v5kR8Zfcn7mkZPT3DYbT6XzrxL0g93tlRDwOfL3Szl6kk4R/j4gVNbF35xjgwoi4LSJWks7m95Y0tlLn7IhYFhEPAn9g7bbTlRH535f2AUkzJC2T9JykD1Tq3hQRV0bEmjzd24GP537MAS4AqvW7c05ELMrb+heAf8jlHwbOi4hbImJ1pGdjK0lXyW8hJYRv5v3gZ8Ct3bTzWKX+ZaS7EYfl5XgZaXtH0jjSScXV9WYiaQywL3BpRDxKSirVF0DeB3wxIp6KiMWkY0uHPUknYp+LiL9FxP3AD4Bp3S2krjiRdO3wiNiCdBbzetZu7DsAU/NGvkzSMtLGvH1ErCAdwE4GHpZ0jaTX15l3GylBAZAPxotr6jxSGf9c/ro5gKRDJd0saWluf3Ilvu60kc6mOua9Jscysl7bpKudjhcN/ot0Vv9bSfdL+kSDbZLjHkw6Q17aQPVOl3ODzTXSz5J4zyBdGcySNE/SB3M7vyfdKvou8Kik8yW9Ms/vzflh8uOSniZtJw2tt67mWyfubfOB+CFJz5BuBXW0M5p0ktKb5ym1y3Q56SqxkW2nK0/mf19atxExLSK2JN0+2qRSd1HlexuwNCKerZT9lR6s45r5/TXPE9L2d1rN9jc6j28DHqo5iforXatXv6OtS4D3SxIpCV6eE0w9HwDm56QJ6bbl+/O2CjXHlprvOwBtNX36JPkEtbecSBqQz/gvJp3RQloxP4yILSuf4RFxdq7/m4g4kLRT3EXK+LUeJl12ApA3oFF16r2MpE1J9zi/CmyXd7ZrSQc1SLcIurKEtEFV2x4NPNRd2xHxbEScFhE7Au8G/k3S/o3EnU0hXYrPysMrgGGV8a+pfO9yOdcLr2a41/3sIt61jUU8EhEfjog24CTge5J2zuO+HRETgXGkW2z/nie7lHQ/f3REvIp0m7DR9dbVfGt9Kc9vfES8knS229HOImBMJw+qe7rtDAdeTc+WaT135Xkc2UDdaoxLgK0lbVEpG1OJp6vtq0P1Qf6YPE9Iy+kLNdvfsIj4CWn/HZm3qeq0XalXfwlARNxMes71DuD9pGd+nTkW2DG/TfoI6WpzBHBoHr/OsaWmf4uAB2r6tEVENHqVX5cTSeO+CRwoaQLp7O7dkg6WtImkzfIrt6MkbSfpPXkHW0l6aLm6zvyuAf5O0uF5hz6V+ht5PUNI91UfB1ZJOpT04L7Do8CrJb2qk+kvBw6TtH8+izktx/qn7hqW9C5JO+cd4pnct3r9q51ua0nHkM6mvxwRHWegc4BpkgZLmkS619yh0+XcSTOPku75ro9+dhZvtc7USixPkQ5wqyXtma88BpMOZB0PsCHdmloaES9I2ot00OjwOOm2aLUP1fa6mm+tLcgPzCWNZN2EM4t0sDlb0vC8XN+Wxz0KjJI0pJP5XgqcIGlCPqH5InBLRCzspH41/o7Xm8fWjstn6qcB0yV9WNJWSnahi7PliFhEWp9fyv0YT3rZ4Me5yhxgcl6frwH+tc5sTs377taks/PLcvkPgJPzMldeVoflpHUT6QTjnyUNknQk6ZZhV7bN9QcrvaH2BtIJYIf/Jl1xrursVqOkvUnPRvci3TKcQHrh4lLW3t66HDgzL8ORwEcqs5gFPKP0SvXQvF/tLmnPbmLvWhQ8YBnIH2oe3Oay7wM/z9/fTHqgtZR0ALiGdIaxPWvf5FlGeji7W6x94FZ9a+sQ4B7WvrV1E/CBenVz2UsPg0mJ59Hcxg+peWMEuJB0u2AZ9d/aOoL0psrTOd5xnfWddR+AfyyPX0G6FfcfXSzDyPWW5+X0B+D9NXV2BG7Jda4h3c+txll3OXfS3hTSm0/LgNO762cv453J2oftXyGd+S4H7gNOzOX7kx5wLmftG1Ob53FHkW5pPEu6B35OTX8/l/u5jHQf/qXtoJv51q7fcaSHqstJB9PTWPch8xjgSta+1fXtXD4kL+OlwBO57GLW3bZOzv1dmvswqt42Wjst6Wx7ITC4i3VwSF5PHbfM/kxKgsPr9TOXjcpxLM1xnVwZtxkpMTyTl93H6PytrWWkW0zDauK5NY97GPgpsEUeNynH1/HW1mV0/9bWOaRt8R7goJo6Y0gnEp/tYvmcSz4G1ZTvRTpJ2pr0AsUPc8zzgU8D91XqtpGezT1COgG6mZpjXU8/HW8AWYtJegXpwHxMRPyh1fGYrW+SPg08HhHntTqWDpIWkk4MftcPYhlKeiC/R0Tcux7newowLSIafamjxzbK/8zTX0g6mHQ2/jzprEukswOzASci6v58iL3kFODW0iQiaXvSlf5NwC6kq9FzysPrnBNJa+1Nurc5hHRpfXhEPN/akMys2fKVkUj/P6bUEOA84LWk21szSLfO+4xvbZmZWRG/tWVmZkU2ultbI0aMiLFjx7Y6DDOzDcrs2bOfiIht6o3b6BLJ2LFjaW9vb3UYZmYbFEmd/s9939oyM7MiTiRmZlbEicTMzIo4kZiZWREnEjMzK+JEYmZmRZxIzMysiBOJmZkVcSIxM7MiG92PNqpNwUmtjsJsXTF949oPbcMjaXZETKo3zlckZmZWxInEzMyKOJGYmVkRJxIzMyviRGJmZkWcSMzMrIgTiZmZFekykUgaK+mOmrKzJJ3ek0YkzZRU9/3jBqc/WdJfJM2RdKOk3SrjjpN0b/4c19s2zMysd/rln9qVtElErK4UXRoR5+Zx7wG+DhwiaWtgOjAJCGC2pKsi4qmmB21mtpEqurWVrzS+LGmWpHskvSOXD5U0Q9JcSZcBQyvTHCTpJkm3SfqppM1z+UJJn5F0IzC12k5EPFMZHE5KGgAHA9dFxNKcPK4DDinpk5mZ9cz6uCIZFBF7SZpMujo4ADgFeC4ixksaD9wGIGkE8GnggIhYIenjwL8Bn8vzeiEi3l6vEUmn5rpDgP1y8UhgUaXa4lxWO+2JwIkAvKqgp2Zm9jLdXZF09gNA1fIr8r+zgbH5+zuBHwFExFxgbi5/C7Ab8H+S5gDHATtU5nVZp4FEfDcidgI+TkpGAGok5og4PyImRcQkhnXWgpmZ9UZ3VyRPAlvVlG0NPFAZXpn/XV0zv3pJSKRbUf/QSXsruokHYAbw/fx9MbBPZdwoYGYD8zAzs/WkyyuSiFgOPCxpf4D8cPsQ4MZu5nsDcEyeZndgfC6/GXibpJ3zuGGSdu0uSEm7VAYPA+7N338DHCRpK0lbAQflMjMza5JGnpEcC3xX0tfy8Gcj4r5upvk+cJGkucAcYBZARDwu6XjgJ5I2zXU/DdzTzfw+IukA4EXgKdItMSJiqaTPA7fmep+LiKUN9MnMzNYT/z0Ss37Af4/E+jv/PRIzM+szTiRmZlbEicTMzIo4kZiZWREnEjMzK9Ivf7SxL01sm0j79PZWh2FmNmD4isTMzIo4kZiZWREnEjMzK+JEYmZmRZxIzMysiBOJmZkVcSIxM7MiTiRmZlbEicTMzIo4kZiZWREnEjMzK+JEYmZmRZxIzMysiBOJmZkVcSIxM7MiTiRmZlbEicTMzIo4kZiZWREnEjMzK+JEYmZmRZxIzMysiCKi1TE0ldoUnNTqKMzMmiumlx3rJc2OiEn1xvmKxMzMijiRmJlZEScSMzMr4kRiZmZFnEjMzKyIE4mZmRUpSiSSRkn6H0n3SrpP0rckDVlfwdW0taWkn0m6S9J8SXvn8q0lXZdjuE7SVn3RvpmZ1dfrRCJJwBXAlRGxC7ArsDnwhdKgJA2qU/wt4NcR8XrgjcD8XP4J4Pocw/V52MzMmqTkimQ/4IWIuAggIlYDHwM+KGmYpFskjeuoLGmmpImShku6UNKtkv4saUoef7ykn0r6JfDbakOSXgm8E/h/ua2/RcSyPHoKcEn+fglweEGfzMysh0oSyThgdrUgIp4BHgR2BmYA7wOQtD3QFhGzgU8Bv4+IPYF9gf+SNDzPYm/guIjYr6atHYHHgYty8rmgMs12EfFwbv9hYNuCPpmZWQ+VJBIB9f7PfUf55cDUXPY+4Kf5+0HAJyTNAWYCmwFj8rjrImJpnXkOAvYAvh8RbwJW0INbWJJOlNQuqZ3nGp3KzMwaUZJI5gHr/O5KvgU1GrgvIh4CnpQ0HjiadIUCKdG8NyIm5M+YiOh43rGik7YWA4sj4pY8/DNSYgF4NF/xdFz5PFY7cUScHxGTImISw3rVVzMz60RJIrkeGCbpWABJmwBfAy6OiI7z/hnAGcCrIuIvuew3wEfzw3okvam7hiLiEWCRpNflov2BO/P3q4Dj8vfjgP8p6JOZmfVQrxNJpJ8NPgKYKule4B7gBeCTlWo/A6aRbnN1+DwwGJgr6Y483IiPAj+WNBeYAHwxl58NHJhjODAPm5lZk/hn5M3MNgL+GXkzM+u3nEjMzKyIE4mZmRVxIjEzsyJOJGZmVqTejyMOaBPbJtI+vb3VYZiZDRi+IjEzsyJOJGZmVsSJxMzMijiRmJlZEScSMzMr4kRiZmZFnEjMzKyIE4mZmRVxIjEzsyJOJGZmVsSJxMzMijiRmJlZEScSMzMr4kRiZmZFnEjMzKyIE4mZmRVxIjEzsyJOJGZmVsSJxMzMijiRmJlZEScSMzMroohodQxNpTYFJ7U6CrPWi+kb175vZSTNjohJ9cb5isTMzIo4kZiZWREnEjMzK+JEYmZmRZxIzMysiBOJmZkVcSIxM7MiTUskkhZK+oukOZLac9lUSfMkrZFU9/3kyvQflXR3rv+VSvmZkhbkcQf3dT/MzGxdg5rc3r4R8URl+A7gSOC8riaStC8wBRgfESslbZvLdwOmAeOANuB3knaNiNV9Er2Zmb1MS29tRcT8iLi7gaqnAGdHxMo83WO5fAowIyJWRsQDwAJgr76J1szM6mlmIgngt5JmSzqxh9PuCrxD0i2S/ihpz1w+ElhUqbc4l61D0omS2iW181yvYjczs04089bW2yJiSb4tdZ2kuyLihganHQRsBbwF2BO4XNKOgOrUfdkPCEXE+cD5kH9ry8zM1pumXZFExJL872PAL+jiFpSki/JD+Wtz0WLgikhmAWuAEbl8dGXSUcCSvojfzMzqa0oikTRc0hYd34GDSA/a64qIEyJiQkRMzkVXAvvl6XcFhgBPAFcB0yRtKum1wC7ArD7riJmZvUyzbm1tB/xCUkebl0bEryUdAXwH2Aa4RtKciKj3Cu+FwIWS7gD+BhwX6ffv50m6HLgTWAWc6je2zMyay3+PxGwj5b9HYj3hv0diZmZ9xonEzMyKOJGYmVkRJxIzMyviRGJmZkWa/aONLTexbSLt09tbHYaZ2YDhKxIzMyviRGJmZkWcSMzMrIgTiZmZFXEiMTOzIk4kZmZWxInEzMyKOJGYmVkRJxIzMyviRGJmZkWcSMzMrIgTiZmZFXEiMTOzIk4kZmZWxInEzMyKOJGYmVkRJxIzMyviRGJmZkWcSMzMrIgTiZmZFXEiMTOzIoqIVsfQVGpTcFKrozBrrZi+ce33Vk7S7IiYVG+cr0jMzKyIE4mZmRVxIjEzsyJOJGZmVsSJxMzMijiRmJlZkaYmEkmbSPqzpKvz8FRJ8yStkVT3tbJc7yxJD0makz+TK+POlLRA0t2SDm5GP8zMbK1BTW7vX4D5wCvz8B3AkcB5DUz7jYj4arVA0m7ANGAc0Ab8TtKuEbF6/YVsZmZdadoViaRRwGHABR1lETE/Iu4umO0UYEZErIyIB4AFwF5lkZqZWU8089bWN4EzgDW9nP4jkuZKulDSVrlsJLCoUmdxLjMzsyZpSiKR9C7gsYiY3ctZfB/YCZgAPAx8rWPWdeq+7LcfJJ0oqV1SO8/1MgIzM6urWVckbwPeI2khMAPYT9KPOqss6aL8UP1agIh4NCJWR8Qa4AesvX21GBhdmXQUsKR2fhFxfkRMiohJDFs/HTIzs6QpiSQizoyIURExlvRw/PcR8Y9d1D8hIiZExGQASdtXRh9BekgPcBUwTdKmkl4L7ALM6pNOmJlZXc1+a2sdko4AvgNsA1wjaU5E1HuF9yuSJpBuWy2E9Pu9ETFP0uXAncAq4FS/sWVm1lz+GXmzjZB/Rt56yj8jb2ZmfcaJxMzMijiRmJlZEScSMzMr4kRiZmZFWvr6bytMbJtI+/T2VodhZjZg+IrEzMyKOJGYmVkRJxIzMyviRGJmZkWcSMzMrIgTiZmZFXEiMTOzIk4kZmZWxInEzMyKOJGYmVkRJxIzMyviRGJmZkWcSMzMrIgTiZmZFXEiMTOzIk4kZmZWxInEzMyKOJGYmVkRJxIzMyviRGJmZkWcSMzMrIgiotUxNJXaFJzU6ijMysT0jWu/tdaTNDsiJtUb5ysSMzMr4kRiZmZFnEjMzKyIE4mZmRVxIjEzsyJOJGZmVsSJxMzMijQlkUjaTNIsSbdLmifps7l8ah5eI6nu+8k18zldUkgaUSk7U9ICSXdLOrgv+2FmZi83qEntrAT2i4jlkgYDN0r6FXAHcCRwXnczkDQaOBB4sFK2GzANGAe0Ab+TtGtErO6DPpiZWR1NuSKJZHkeHJw/ERHzI+LuBmfzDeAMoPpfeqcAMyJiZUQ8ACwA9lpfcZuZWfea9oxE0iaS5gCPAddFxC09mPY9wEMRcXvNqJHAosrw4lxWO/2JktoltfNcz2M3M7PONS2RRMTqiJgAjAL2krR7I9NJGgZ8CvhMvdH1mqrT9vkRMSkiJjGsB0GbmVm3mv7WVkQsA2YCh3RWR9JFkuZIuhbYCXgtcLukhaREdJuk15CuQEZXJh0FLOmbyM3MrJ6mPGyXtA3wYkQskzQUOAD4cmf1I+KEmqJtK/NaCEyKiCckXQVcKunrpIftuwCz1nf8ZmbWuWa9tbU9cImkTUhXQZdHxNWSjgC+A2wDXCNpTkQ0/ApvRMyTdDlwJ7AKONVvbJmZNZf/HonZBsh/j8SazX+PxMzM+owTiZmZFXEiMTOzIk4kZmZWxInEzMyKNOv1335jYttE2qe3tzoMM7MBw1ckZmZWxInEzMyKOJGYmVkRJxIzMyviRGJmZkWcSMzMrIgTiZmZFXEiMTOzIk4kZmZWxInEzMyKbHx/2Ep6Fri71XGsByOAJ1odRCH3of8YCP1wH/rWDhGxTb0RG91vbQF3d/ZXvjYkkto39H64D/3HQOiH+9A6vrVlZmZFnEjMzKzIxphIzm91AOvJQOiH+9B/DIR+uA8tstE9bDczs/VrY7wiMTOz9ciJxMzMigzYRCLpEEl3S1og6RN1xkvSt/P4uZL2aEWcXWmgD6+XdJOklZJOb0WMjWigH8fkdTBX0p8kvbEVcXalgT5MyfHPkdQu6e2tiLMr3fWhUm9PSaslHdXM+BrRwHrYR9LTeT3MkfSZVsTZnUbWRe7LHEnzJP2x2TH2SEQMuA+wCXAfsCMwBLgd2K2mzmTgV4CAtwC3tDruXvRhW2BP4AvA6a2OuaAfbwW2yt8P3UDXxeasfeY4Hrir1XH3tA+Ver8HrgWOanXcvVgP+wBXtzrW9dCPLYE7gTF5eNtWx93VZ6BekewFLIiI+yPib8AMYEpNnSnAf0dyM7ClpO2bHWgXuu1DRDwWEbcCL7YiwAY10o8/RcRTefBmYFSTY+xOI31YHnmPB4YD/e0tlkb2CYCPAj8HHmtmcA1qtA/9XSP9eD9wRUQ8CGlfb3KMPTJQE8lIYFFleHEu62mdVurv8TWqp/34J9KVYn/SUB8kHSHpLuAa4INNiq1R3fZB0kjgCODcJsbVE41uS3tLul3SrySNa05oPdJIP3YFtpI0U9JsScc2LbpeGKg/kaI6ZbVniI3UaaX+Hl+jGu6HpH1JiaS/PV9oqA8R8QvgF5LeCXweOKCvA+uBRvrwTeDjEbFaqle95Rrpw22k34RaLmkycCWwS18H1kON9GMQMBHYHxgK3CTp5oi4p6+D642BmkgWA6Mrw6OAJb2o00r9Pb5GNdQPSeOBC4BDI+LJJsXWqB6ti4i4QdJOkkZERH/5Ab5G+jAJmJGTyAhgsqRVEXFlUyLsXrd9iIhnKt+vlfS9frYeoPHj0xMRsQJYIekG4I1Av0wkLX9I0xcfUoK8H3gtax9mjaupcxjrPmyf1eq4e9qHSt2z6L8P2xtZF2OABcBbWx1vQR92Zu3D9j2AhzqG+8OnJ9tTrn8x/e9heyPr4TWV9bAX8GB/Wg896McbgOtz3WHAHcDurY69s8+AvCKJiFWSPgL8hvSGxIURMU/SyXn8uaS3UiaTDmDPASe0Kt56GumDpNcA7cArgTWS/pX09scznc232RpcF58BXg18L58Nr4p+9AuoDfbhvcCxkl4EngeOjnxE6A8a7EO/1mAfjgJOkbSKtB6m9af1AI31IyLmS/o1MBdYA1wQEXe0Luqu+SdSzMysyEB9a8vMzJrEicTMzIo4kZiZWREnEjMzK+JEYmZmRZxIzMysiBOJmZkV+f++gKI31Q2B1QAAAABJRU5ErkJggg==\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "# bar chart showing resignation vs age categories\n", "pv_age_groups = combined.pivot_table(values=\"dissatisfied\", index=\"age_groups\")\n", "ax = pv_age_groups.plot(kind=\"barh\", legend=False, title=\"Resignations Due to Dissatisfaction, Grouped by Age\", color=\"green\")\n", "ax.set_ylabel(\"\")\n", "plt.show()" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYMAAAEICAYAAAC9E5gJAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAV5UlEQVR4nO3ceZhcVZnH8e8rCYogIiBCINCyKLggIiI6MuI4uLAIKso2jCuK6LgM7qOCjgzq+Cgi8iA6ilsERpFBwHGPO0vQgIOCIgaDQUhIgKCIJLzzxzkdLmV11e2kq6uT/n6ep5901T1173vu9rv33OpEZiJJmt7uN+wCJEnDZxhIkgwDSZJhIEnCMJAkYRhIkpgmYRARR0bEN4e07HdExKeGsex1SUR8PSJePInLa7XPRMQGEfG1iLgtIv57gms4PSLeNZHzXBdFxJkR8b4xpr0kIn402TWNx5Q5R2TmlPoBFgB3AncAfwTOBDYadl0ta98HuGEK1JHAn+o6vAX4DnDogLfZP64t9XZZ/kitYcZqfPYo4NLV+WzHfF4C/GiI+8y+wPeA5XUbzAfeCjxgWDWNo/YzgfcNer0Cc4FXrOE8ep4jVmdfnIi6MnPK3hkcmJkbAbsBjwfePtxy1kqPq+vwkZSD5dSIOH64JfW0ttU7ajvg15m5YtiFrK6IeCHwZWAOsF1mbgYcCmwDzB7jMzMmr0JNimGnepeUW0DjKhP4IHBh4/VewE+AW4ErgH06rgKuo1zd/A44stvVAfBM4BrgNuA04PvUZB1tC3wIWFbn85zGZ18K/Kou4zrgVfX9DSl3NPdQrnDvAGYBJwBfaHz+ucBVtf65wC4dfX8TcGWt7WzqlRmwOXBB/dxS4IfA/cZYhwns2PHeIcBfgM3GWM+ddY65njvm+/na59G7ubf06+dq1ju3sY12rNvsNmAJcHZ9P4CPADfXaVcCj6nT9gd+DtwOLAROaCzr97WG0e32ZBr7zFjzBd4D/BW4u37u5cAOwHcpV9dLgC8CmzSWNRs4F1hc25wK7FL7urLO59ba9kwaV7zA0cC1dfufD8zqWIfHAL+h7LcfB6LF8RZ1fRzXp90JlMD4Ql2Hr6Ds3+fXeq4Fjm6076x9HxpXxJT97+3AL2u9n6FxFwIcQLk7uZWyH+7amPZ44GeUY/Bs4Cx63xn8GPhY3XZXA8+o014IXN7R/jjgvDHmNZd798F9gBtq+5uBG4GXNtruV/u2HPgD5bjue46g+764anptM1LbzABOrPvNX2r7U2ubnYFv1W1zDfCivvvC6p60B/VD4yRFuTL5BfDR+nprygG0H+V5x7719UPrir4deGRtuxXw6MYOMXpgb17bPb+uzNdTDuZmGNxNOfDWA14NLKIeWJSTyg6Ug+hpwJ+B3bvt8I2DaHRDP4IyHLIvMBN4C+UgWr/R90vrDrIpJXSOqdNOAk6vn5sJ7M0YBzvdT64zgRXUYKNHGPRaz/22WZt+rma9cxvb6EvAv9XaHgA8tb7/LOByYJO6fXYBtmpsm8fWz+wK3AQc3HlwdZxEftRivqvWW329Y+33/Sn75Q+Ak+u09SjB+hHK/tqsfdXyGvM6k3qSA/6BEi6713l/DPhBxzq8oNa4LSVsnt3ieNu5fnakT7sTKMfFwXUdbkAJ5NNqP3ary3xGZ+3djg3KPvN/lHDclHLCHu3r7pQT7JPqOntxbX9/YH3geuCNlH3kkFpXrzBY0Wh/KCUUNq3zW8p9L8h+DrxgjHnN5b5hsAJ4b53vfpRzwUPq9BuBvevvD6H9OWKEv90XV03v1oaOYSLKvrWQcuE6o67PJdTz4Vg/U3WY6LyIWE7p0M3A8fX9fwIuysyLMvOezPwWMI+yIaAk7mMiYoPMvDEzr+oy7/2AqzLz3Cy39qdQnk00XZ+Zn8zMlcBnKcHyMIDMvDAzf5vF94FvUk7MbRxKucv5VmbeTbn72AB4SqPNKZm5KDOXAl+jHGRQdvitKLfxd2fmD7Nu+Tbq8pZQDoJ++q3nftr0c03qvZsyPDMrM/+SmT9qvP8gygkuMvNXmXljnd/czPxF7c+VlEB5Wstyxpxvl7qvrf2+KzMXAx9uLGdPStC/OTP/1FF7P0cCn87Mn2XmXZSr6idHxEijzfsz89bM/D1l/H+3FvPdvP676hiIiLMi4taI+HNEHNVo+9PMPC8z76mfeyrw1tqP+cCnKM9Q2jo1MxfWff1E4PD6/tHAJzLzksxcmZmfBe6i3K3uRTn5nlyPgy8Dl/VZzs2N9mdTrpT3r+vxbMr+TkQ8mnKivaBl/XcD763zvYhyZf7IxrRHRcTGmbksM3/Wcp4T4QBgQWZ+JjNX1GV/hRKcY5qqYXBwZj6IkqI7c+8Oux3wwrqj3hoRt1J2yK0y80+Uk9AxwI0RcWFE7Nxl3rMoIQNAPaHe0NHmj43pf66/bgQQEc+JiIsjYmld/n6N+vqZRbmqGZ33PbWWrbstm3KlsVH9/T8pV9ffjIjrIuJtLZdJrXsm5Up1aYvmY67nlotr0881qfctlCv0SyPiqoh4WV3OdynDLh8HboqIMyJi4zq/J0XE9yJicUTcRtlPWm23XvPtUvcW9WT6h4i4nTKsMrqc2ZQLjdV5vtC5TkcftrfZd3q5pf67attm5mGZuQllKGa9RtuFjd9nAUszc3njvesZxzbumN/1dZ5Q9r/jOva/2XX6LOAPHRdC19Nbt/ajy/oscEREBCXIzqkh0cYtHduyuc5fQDk3XB8R34+IJ7ec50TYDnhSx/o7Etiy14emahgAUK+8z6RcWULZeT6fmZs0fjbMzPfX9t/IzH0pO/bVwCe7zPZGyvATAHUn2KZLu78REfenJOyHgIfVA+YiyokJyq1bL4soG6q57NmUMcWeMnN5Zh6XmdsDBwL/GhHPaFN3dRDltvbS+vpPwAMb05s7Ss/13K28jter3c8e9d67sMw/ZubRmTkLeBVwWkTsWKedkplPAB5NGa56c/3YHMr49uzMfDBlyK3tdus1304n1fntmpkbU646R5ezENh2jIev4913NgQ2Y3zrtJur6zye36Jts8ZFwKYR8aDGe9s26um1f41qPpzets4Tyno6sWP/e2Bmfoly/G5d96nmZ3vp1n4RQGZeTHnuszdwBOUZ2BrLzMsy8yBgC+A84JzRSf0+2uW9fuuy8zMLge93rL+NMvPVvRY8pcOgOhnYNyJ2o1xlHRgRz4qI9SLiARGxT0RsExEPi4jn1oPkLsot28ou87sQeGxEHFwPytfQJzEb1qeMMy4GVkTEcygPo0fdBGwWEQ8e4/PnAPtHxDPqle9xtdaf9FtwRBwQETvWnfr22rdu/ev83KYRcSTlqvYDmTl6JTgfOCwiZkbEHtz3FnLM9TzGYm4Ctp+gfo5Vb7PNCxu1LKMcDCsj4on1DmAm5QAafSgLZZhnaWb+JSL2pBz4oxZThhibfWgur9d8Oz2I+hA4IrbmvqFxKeVk9v6I2LCu17+r024CtomI9ceY7xzgpRGxW70o+Q/gksxcMEb7Zv0jEZEdQ0rAqjvj44DjI+LoiHhIFDtRh0a7ycyFlO15Uu3HrpQH6F+sTeYD+9XtuSXwhi6zeU09djcF3kEZsoFyEXdMXedR19X+NXh+SrlIeF1EzIiI51OG33rZorafGeWbU7tQLuJGfY5y57diHMN2Y4qI9aP8ncqD63Dn6PEK/c8R3fbF+cDfR8S29XOd367sPP4uAB4REUfVPs+s+/Auveqe8mFQx10/B7yr7oAHUXacxZQEfDOlH/ej7NSLKEMLTwOO7TK/JZRvEXyQcov8KMp4eN9bw3pL/DrKyW4Z5YRyfmP61ZSx6Ovq7dmsjs9fQ7lS/BhlPPxAytdo/9piVewEfJtyovkpcFpmzu3R/oqIuIMytPQK4I2Z+e7G9HdRHoQvo3wrZk6jzl7ruZuTgHfWPr9pNfvZr96mJwKX1PbnA6/PzN8BG1NOJMsoQwG3cO9d5bHAe6M8i3o3916pjQ4Fngj8uPZhr47l9Zpvp/dQHtjdRrnwOLexnJV1XexI+dbIDZShTSjfQLoK+GNELOmcaWZ+h7LNvkIJlB2Aw8aoodPsWnfXu4g6jv4iyjZbSNlm5wBnAL3+kO5wyhj7IuCrwPFZni9BucK+gvLg95vce6JvmlOnXVd/3lfrmUd5bnAqZZ1fS3kQTN2Hnl9fL6Osv3Pp7RLK8bOEsp0P6bjI+Dzl22ETcldQHQUsiDJUeAz1uUSLc8Tf7It1nZ5N+Rbb5fztM42PAodExLKIOKWep55J2T8WUYYPP0C5kB3T6Ddkpq2IuB/loDwyM7837HqkiRYR7wQWZ+Ynhl3LqIhYQPkGzLenQC0bUB4y756Zvxl2PcMyLf9wJCKeRblauJNyxRvAxUMtShqQzOz6XzVolVcDl03nIIBpGgaUP+SYQ3kG8EvKt5fuHG5JkiZbvUMJyt9PTGvTfphIkrQWPECWJA3elB8m2nzzzXNkZGTYZUjSWuXyyy9fkpkPbdt+yofByMgI8+bNG3YZkrRWiYh+f5l9Hw4TSZIMA0mSYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJIEzBh2AX0tvRzmxLCrkHo7IoddgbRGvDOQJBkGkiTDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEnAjDaNImIz4Dv15ZbASmBxff0s4AbgtZn5icZnFgDLa1uAY4FFwK+Aaxqz/3Bmfm4165ckTYBWYZCZtwC7AUTECcAdmfmh+vpY4GLgcOATHR99emYuGX0RESPAbzNztzWsW5I0gSZimOhw4Dhgm4jYegLmJ0maZGsUBhExG9gyMy8FzgEO7WjyvYiYHxGXNN7bob43+rN3l/m+MiLmRcS8xcvXpEJJUhuthol6OIwSAgBnAf8FfLgx/T7DRFXfYaLMPAM4A2CP7SPXsEZJUh9rGgaHAw+LiCPr61kRsVNm/mYN5ytJmkSrPUwUEY8ENszMrTNzJDNHgJModwuSpLXImjwzOBz4asd7X6nv99L5zOB1a1CDJGkCjHuYKDNP6DHtSuBR9feRLtMXABuMd5mSpMHyL5AlSYaBJMkwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJwIxhF9DXpk+AI+YNuwpJWqd5ZyBJMgwkSYaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJAmYMu4C+ll4Oc2LYVUjS5DoiJ3Vx3hlIkgwDSZJhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiRgRr8GEbES+AUwE1gBfBY4OTPviYh9gP8Bftf4yEnA2+vvWwIrgcX19Z7AnXV+o87KzPevfhckSWuqbxgAd2bmbgARsQUwB3gwcHyd/sPMPKDjM2fX9icAd2Tmh0YnRMSq+UmSpoZxDRNl5s3AK4HXRkQMpiRJ0mQb9zODzLyufm6L+tbeETG/8bNDn1ls0NH+0M4GEfHKiJgXEfMWLx9vhZKk8WozTNRN866g2zBRL32HiTLzDOAMgD22jxx/eZKk8Rj3nUFEbE95KHzzxJcjSRqGcYVBRDwUOB04NTO9YpekdUSbYaINImI+93619PPAhxvT967TR70vM7/cYn6j/jcz39auXEnSIPQNg8xcr8e0uZSvmY41/YTxzE+SNBz+BbIkyTCQJBkGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CSBMwYdgF9bfoEOGLesKuQpHWadwaSJMNAkmQYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJAGRmcOuoaeIWA5cM+w6hmhzYMmwixgS+z59Tef+T1Tft8vMh7ZtPGMCFjho12TmHsMuYlgiYt507b99n559h+nd/2H13WEiSZJhIElaO8LgjGEXMGTTuf/2ffqazv0fSt+n/ANkSdLgrQ13BpKkATMMJElTJwwi4tkRcU1EXBsRb+syPSLilDr9yojYfRh1DkKLvu8cET+NiLsi4k3DqHGQWvT/yLrNr4yIn0TE44ZR5yC06PtBtd/zI2JeRDx1GHUOQr++N9o9MSJWRsQhk1nfoLXY9vtExG1128+PiHcPtKDMHPoPsB7wW2B7YH3gCuBRHW32A74OBLAXcMmw657Evm8BPBE4EXjTsGseQv+fAjyk/v6cabbtN+LeZ3u7AlcPu+7J6nuj3XeBi4BDhl33JG/7fYALJqumqXJnsCdwbWZel5l/Bc4CDupocxDwuSwuBjaJiK0mu9AB6Nv3zLw5My8D7h5GgQPWpv8/ycxl9eXFwDaTXOOgtOn7HVnPDMCGwLryjY82xzzAvwBfAW6ezOImQdv+T5qpEgZbAwsbr2+o7423zdpoXe1XW+Pt/8spd4jrglZ9j4jnRcTVwIXAyyaptkHr2/eI2Bp4HnD6JNY1Wdru90+OiCsi4usR8ehBFjRVwiC6vNd5BdSmzdpoXe1XW637HxFPp4TBWwda0eRp1ffM/Gpm7gwcDPz7oIuaJG36fjLw1sxcOfhyJl2b/v+M8v8LPQ74GHDeIAuaKmFwAzC78XobYNFqtFkbrav9aqtV/yNiV+BTwEGZecsk1TZo49r2mfkDYIeI2HzQhU2CNn3fAzgrIhYAhwCnRcTBk1Ld4PXtf2benpl31N8vAmYOcttPlTC4DNgpIh4eEesDhwHnd7Q5H/jn+q2ivYDbMvPGyS50ANr0fV3Wt/8RsS1wLnBUZv56CDUOSpu+7xgRUX/fnfKwcV0Iw759z8yHZ+ZIZo4AXwaOzczzJr3SwWiz7bdsbPs9KefrgW37KfG/lmbmioh4LfANylP2T2fmVRFxTJ1+OuXbBPsB1wJ/Bl46rHonUpu+R8SWwDxgY+CeiHgD5ZsHtw+r7onSctu/G9iMcmUIsCLXgf/RsmXfX0C5CLobuBM4tPFAea3Vsu/rrJb9PwR4dUSsoGz7wwa57f3vKCRJU2aYSJI0RIaBJMkwkCQZBpIkDANJEoaBJAnDQJIE/D+gTgc6/wT/AAAAAABJRU5ErkJggg==\n", "text/plain": [ "
" ] }, "metadata": { "needs_background": "light" }, "output_type": "display_data" } ], "source": [ "# bar chart showing resignation vs insitute\n", "pv_institute = combined.pivot_table(values=\"dissatisfied\", index=\"institute\")\n", "ax = pv_institute.plot(kind=\"barh\", legend=False, title=\"Resignations Due to Dissatisfaction, Grouped by Institute\", color=\"orange\")\n", "ax.set_ylabel(\"\")\n", "plt.show()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Conclusions\n", "While this is only a primary survey, it appears that both age and length of employment are correlated to resignation due to job dissatisfaction. The high rate seen in workers over the age of 60 suggests reconsidering inclusion factors. The data also show an almost double rate of resignation due to job dissatisfaction in the DETE." ] } ], "metadata": { "hide_input": false, "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.5" }, "latex_envs": { "LaTeX_envs_menu_present": true, "autoclose": false, "autocomplete": true, "bibliofile": "biblio.bib", "cite_by": "apalike", "current_citInitial": 1, "eqLabelWithNumbers": true, "eqNumInitial": 1, "hotkeys": { "equation": "Ctrl-E", "itemize": "Ctrl-I" }, "labels_anchors": false, "latex_user_defs": false, "report_style_numbering": false, "user_envs_cfg": false } }, "nbformat": 4, "nbformat_minor": 2 }