Just wrapped up an exciting data cleaning project for an e-commerce . The client’s inventory software and shipping provider had a syncing error, leaving them with over 4,400 rows of absolute chaos.
The Challenges I Solved:
Duplicate Orders: Merged 306 duplicate split order IDs...
Just wrapped up cleaning a major 2019 US & UK CRM export. If you deal with international data, you know how messy the address and contact columns can get.
What I fixed:
Formatted US States (standardized abbreviations vs full names).