Data Cleaning Mastery

A 9-tool suite for cleaning, standardizing, and validating tabular data.

Runs 100% locally

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
3
Total findings
6
Warnings
1 to review
Info
5 suggestions

Findings

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