Beginner · 25 min · 5 steps
Cleaning a messy sign-up list with Python
Asha Rao, Junior Data Pipeline Engineer at SkillBridge Learning
It is Wednesday, 11:30 AM. Asha Rao is a junior data engineer at SkillBridge Learning, an online academy that teaches tech skills to students across India. The marketing director has called a quick meeting. The team wants to send a WhatsApp and email campaign for a new Data Engineering fellowship, to people who signed up for a recent webinar.
The question
How do we turn a sign-up list that people typed by hand into clean, unique records, and how many learners are there in each city?
- Strings
- Dictionaries
- Functions
- Loops
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.