/DQ-Analyze-Exit

DQ's Project: Clean and Analyze Employee Exit Surveys

Primary LanguageJupyter Notebook

Guided Project: Clean and Analyze Employee Exit Surveys

In this project, we'll work with exit surveys from employees of the Department of Education, Training and Employment (DETE) and the Technical and Further Education (TAFE) institute in Queensland, Australia. A slightly modified version of the TAFE exit survey and the survey for the DETE could be find in:

  • tafe_survey.csv
  • dete_survey.csv

The following data cleaning tasks were performed in this project:

  • Explored the data and figured out how to prepare it for analysis
  • Corrected some of the missing values
  • Dropped any data not needed for our analysis
  • Renamed our columns
  • Verified the quality of our data
  • Created a new institute_service column
  • Cleaned the Contributing Factors columns
  • Created a new column indicating if an employee resigned because they were dissatisfied in some way
  • Combined the data
  • Cleaned the institute_service column
  • Handled the missing values in the dissatisfied column
  • Aggregated the data

This project is part of DataQuest's Data Cleaning and Analysis course.