In this hands-on lab, students will be required to cleanse the given dataset, based on the provided business requirements.
Successfully complete this lab by achieving the following learning objectives:
- Convert Text Columns to Lowercase
- Both text columns (Name and Department) must be converted to all lowercase characters.
- Truncate the Department Field
- The department field should be truncated to a maximum of 3 characters.