DataTools — Data Cleaning Mastery (Geist spec)

Files

3 files · 4.2 KB total

26_format_emails.csv

1,674 B

27_format_addresses.csv

2,043 B

30_format_integration.csv

538 B

Files analyzed

Total findings

Warnings

1 to review

Info

5 suggestions

Grouped by file · sorted by severity

26_format_emails.csv

1 warning 2 info

3 cells contain trailing whitespace in column email

rows 4, 11, 23 · likely caused by copy-paste from spreadsheet

Mixed case detected in email column (e.g. John@Gmail.com)

7 affected rows · normalize to lowercase to enable dedup

Gmail dot variants found (e.g. j.smith@gmail.com ≈ jsmith@gmail.com)

2 affected rows · Gmail ignores dots; treating as same address

27_format_addresses.csv

1 info

Non-standard street abbreviations in column address_1

12 rows mix "Street/St/St.", "Avenue/Ave" · apply USPS-style normalization

30_format_integration.csv

2 info

Inconsistent date format in signup_date (mix of MM/DD/YYYY and YYYY-MM-DD)

5 affected rows · standardize to ISO 8601

UTF-8 BOM detected at file start

may cause issues in downstream tools · strip on save