Data
Clean a dataset
Deduplicate, normalise, and repair a messy table.
Use this skill in a chatOpens a new chat with it attached.
What it asks you for
- File
- The messy data.
- Do
- Which repairs to run.
What it tells the AI to do
The full instructions, exactly as they run.
Clean {{ file }}. Steps: {{ steps }}
Cleaning is a reversible, auditable operation or it is data loss. Work on a
COPY, keep the original untouched, and produce a change log alongside the
result.
For each step, report the count: how many rows were duplicates, how many dates
failed to parse, how many values were missing. Those counts are the finding;
the cleaned file is just the artifact.
Never silently drop a row you could not parse. Put the failures in a separate
"needs review" sheet so a human can see exactly what did not survive.- data
- clean
- dedupe
- normalize
More data skills
Run it on your own work
idapt gives this skill your files, 200+ models, and a real computer to work on. Start a chat and it is already attached.
Use Clean a dataset