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")
Run this prompt directly on Promptibus
No API keys needed — we handle everything.
No gallery images yet.