Messy Customer List Cleaned with Python by Eros C.Messy Customer List Cleaned with Python by Eros C.

Messy Customer List Cleaned with Python

Portfolio project
Eros C.
Demo project with a fictional customer list, not a client project.
614 rows with duplicates, extra spaces, dates in different formats, phone numbers with and without country codes, and country names written in many ways.
A Python script cleaned the file: 560 clean rows, 48 duplicates removed, and 6 rows marked for review instead of guessing.
The client gets a clean Excel file with 3 sheets: the clean data, the rows to check, and a change log.

0 likes · 0 views · Nov 12, 2026

614 messy customer rows in, a clean Excel out: 48 duplicates removed, 6 rows marked for review, every change in a log. Demo.

Tags