Data Cleaning Exercises

Input table:Inputs are read-only. Every step works on a copy.
Input table contacts, rows 1 to 12 of 12
#
1c2e40⇥s.am@Shop.Example.net· (raw value "\ts.am@Shop.Example.net ")
2co4rf··carol_99@MAIL.example.org·· (raw value " carol_99@MAIL.example.org ")
3cf5coSam+offers@example.COM
4c3vyo··carol_99@Example.com·· (raw value " carol_99@Example.com ")
5cgbcs⇥bob@example.com⇥ (raw value "\tbob@example.com\t")
6cmnxs··Sam+offers@Shop.Example.net·· (raw value " Sam+offers@Shop.Example.net ")
7crnsn·s.am@example.COM· (raw value " s.am@example.COM ")
8c8m37··sam+offers@mail.example.org·⇥ (raw value " sam+offers@mail.example.org \t")
9c7og7··s.am@MAIL.example.org·· (raw value " s.am@MAIL.example.org ")
10cghwl·⇥carol_99@MAIL.example.org·⇥ (raw value " \tcarol_99@MAIL.example.org \t")
11c80if·Ann.Lee@Example.com·· (raw value " Ann.Lee@Example.com ")
12c942ldan+news+2026@example.com

Playground: 12 input rows → 12 rows after your steps. Nothing here is graded, and your steps are saved in this browser only. Export the pipeline to keep a copy.

Raw source12 rows × 2 columnsPreview up to dateNot saved yet · sign in to save to your account