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.