Clean, transform, and restructure messy CSV data. Handle missing values, standardize formats, merge columns, and output clean structured data.
Clean and transform this data. ## Input Data ``` [Paste your messy CSV, table, or structured data here] ``` ## What I Need - **Output format**: [clean CSV / JSON / markdown table / SQL INSERT / Excel formula] - **Transformations needed**: [select all that apply] - [ ] Remove duplicates - [ ] Standardize date formats (to YYYY-MM-DD) - [ ] Standardize phone numbers - [ ] Standardize names (proper case) - [ ] Fill missing values (with [strategy: average / previous / "N/A" / remove row]) - [ ] Split combined columns (e.g., "City, State" → two columns) - [ ] Merge columns (e.g., "First" + "Last" → "Full Name") - [ ] Convert currencies - [ ] Remove special characters - [ ] Trim whitespace - [ ] Add a calculated column: [describe formula] - [ ] Filter rows where: [condition] - [ ] Sort by: [column, ascending/descending] - [ ] Group and aggregate: [group by column, calculate sum/avg/count] ## Additional Instructions - [Any specific rules or edge cases] - [Column names to rename] - [Encoding notes] ## Output 1. The cleaned data in requested format 2. Summary of changes made 3. Any data quality issues found (e.g., "5 rows had missing email addresses")
No gallery images yet.