Prompt - Clean and Structure Messy Data
ChatGPT000
data analysis
Prompt - Clean and Structure Messy Data
Act as a data analyst. Here is messy data: [PASTE DATA]. Clean and structure it: identify inconsistencies (formats, duplicates, missing values, outliers), propose a cleaning plan, and return a tidy version. Explain each transformation you'd apply and flag any values you're unsure about rather than silently changing them. Suggest the ideal column schema for analysis.