Cleansing Data

30 minutes
  • 2 Learning Objectives

About this Hands-on Lab

In this hands-on lab, students will be required to cleanse the given dataset, based on the provided business requirements.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Convert Text Columns to Lowercase
  1. Both text columns (Name and Department) must be converted to all lowercase characters.
Truncate the Department Field
  1. The department field should be truncated to a maximum of 3 characters.

Additional Resources

In this hands-on lab you have been tasked with cleansing 2 datasets, 1 stored as a CSV file, and the other in a PostgreSQL database. There are two business requirements that both datasets must meet:

  • All text fields should be in lower case.
  • The Department field must not exceed 3 characters.

Database Info

  • User: postgres
  • Database name: demo
  • Database table: users

The demo.csv file will be downloaded into the cloud_user home directory. You can also access it here.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?