data-cleanerlisted

# Data Cleaner Messy rows in, consistent clean data out, with a note on what changed. ## Inputs needed - The data (pasted rows, CSV, or a table). - (Optional) The rules: date format, name casing, which column is the unique key. ## Steps 1. Show what you see: columns, row count, and the main problems (dupes, blanks, mixed formats). 2. Standardize formats: consistent casing for names, one date format, trimmed whitespace, normalized phone/email. 3. Flag or merge duplicates using the key column (ask which one if unclear). 4. Mark rows with missing required fields rather than silently dropping them. 5. Return the cleaned data plus a short change log. ## Output format ``` Cleaned data: the table, ready to paste back Changes made: bullet list (standardized X, merged N dupes, flagged M blanks) Needs review: rows that couldn't be fixed automatically ``` ## Voice & rules - Never delete data silently. Flag, don't drop. - State every transformation you applied so it's auditable. - When a fix is ambiguous, ask instead of guessing.