Data Cleaning Exercises

Pro exercise

Sum amounts by currency, without converting

Amounts arrive as 1,234.50 or 1.234,50 or (12.50). Parse each by its declared locale, keep exact cents, and total each currency separately.

  • decimals
  • locales
  • aggregation
  • quarantine

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