Coding Exercise: Clean the Employee Survey Data

Scenerio

You’re a junior data scientist at a mid-sized company. HR has just shared the results of an internal employee satisfaction survey, but the data is messy! Your job is to clean and prepare this dataset for further analysis. You’ll need to handle duplicated data, missing values, and normalize certain columns, just like in a real-world workplace.

Dataset

Here’s a sample DataFrame (df) you’ll work with: