Clean a CSV with Pandas

In this project, you will clean a messy synthetic employee dataset using a structured, step-by-step workflow. The dataset includes encoding issues, wrong date formats, mixed types, and inconsistent categorical values.

1. Load the [dataset](https://www.kaggle.com/datasets/desolution01/messy-employee-dataset) and inspect it before doing anything
2. Handle encoding and delimiter issues at load time
3. Fix column data types explicitly using the `dtype` argument
4. Convert date columns using `pd.to_datetime()` with `errors='coerce'`
5. Standardize categorical columns (strip whitespace, fix capitalisation)
6. Export a cleaned version of the dataset and do a final audit