Data Cleaning Exercises

Pro exercise

Amounts that don't fit the column

The warehouse column is decimal(10,2): at most 8 digits before the point. An amount of 123456789.00 doesn't fit and is reported — not truncated, not stored as a float, and not silently turned into NULL without a reason.

  • numbers
  • precision
  • types

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.