Clean a messy export

For a chat window, the command line.

The prompt

Here is a sample of a messy data export:

<sample>
{{SAMPLE}}
</sample>

Tell me, as a list:
- Every inconsistency you can see (date formats, trailing spaces, mixed units, duplicates,
  blank-but-not-empty cells, numbers stored as text).
- For each one, how many of the sample rows it affects.
- The order I should fix them in, and why that order.

Do not write any code yet. I want to see the list first.

What to fill in

Placeholder	What goes there
{{SAMPLE}}	twenty real rows, including the ugly ones

Why it works

Cleaning data badly is worse than not cleaning it, because the errors become invisible. Getting the inventory before the fix means you decide what “clean” means rather than discovering it afterwards.

Asking for the order matters: fixing duplicates before normalising formats produces different results than the other way round.

ShareOpen LinkedIn