October challenge board
Dirty Data Lab™ · Challenge 01
Medium
Thursday, October 1 · 15–20 minutesCustomer Import Rescue
The import is due today. The file looks normal until duplicate IDs, blank rows, casing, spaces, dates and numeric text start colliding.
The assignment
Cleanup rules
There is one finished state. Use the rules to get the board there.
- Remove the fully blank row.
- Keep one record per customer_id after trimming the ID.
- Trim spaces, collapse repeated spaces in names, and use title case for names and cities.
- Lowercase emails. Keep the missing email blank.
- Normalize signup dates to YYYY-MM-DD and orders to whole numbers.
- Keep the six original columns and sort by customer_id ascending.
Loading the puzzle board…
Loading your Lab profile…
Pass the puzzle
Send this one to a friend.
The friend link carries Dirty Data Lab™ referral attribution, so referred signups can be measured separately from newsletter and ad traffic.
Take the habit into Google Sheets
Practice here. Preflight real sheets with CTS Guard.
Clean That Sheet Guard checks the active Google Sheet for duplicates, missing data, formatting issues and other handoff problems before you share or import it.