BusinessImported version
Clean and Prepare Messy Data
/Users/fabien/Desktop/AI/PROMPTS/-business/research/Clean and prepare messy data.odt
Folder-business/research
Versions0
Imported2026-07-29
StatusActive
## Clean @file name.csv **What's wrong:** - dates are mixed between MM/DD/YYYY and YYYY-MM-DD - currency values include $, commas, and blank cells - a few duplicate customer rows came from repeated exports - region and category names use several aliases - there are pasted summary rows mixed into the data **What I want:** - write a cleaned CSV and keep the original file unchanged - use one date format - keep blank currency cells blank - preserve source row IDs when possible - add a short data-quality note with rows you changed, removed, or could not clean confidently