CSV Cleanup with Validation and Rejection Reports by Morgan AlexCSV Cleanup with Validation and Rejection Reports by Morgan Alex

CSV Cleanup with Validation and Rejection Reports

Morgan Alex

Morgan Alex

CSV Cleanup with Validation and Rejection Reports Self-directed, AI-assisted portfolio demo using synthetic records; not a paid client engagement. Built a Python standard-library command-line tool that trims fields, normalizes email domains while preserving local parts, and keeps the first occurrence of each record ID. Missing and duplicate IDs go to a separate rejection report with reasons. Strict input validation happens before output, and existing files are never overwritten. Delivered source code, sample input, expected outputs, usage instructions, and five passing CLI tests covering normalization, quoted fields, malformed input, duplicate handling, and overwrite protection. Scope: a documented three-column schema; email syntax and deliverability are not validated. Source and reproduction steps: https://github.com/codeofwxz/automation-portfolio-demos/tree/main/csv-cleanup
Like this project

Posted Sep 12, 2026

A tested Python CLI for trimming CSV fields, normalizing email domains, and reporting missing or duplicate record IDs.

Likes

0

Views

0