Data Cleaning Exercises

Pro exercise

The file tells you the currency

Three country files have an amount column but no currency column: the UK file is in GBP, the US file in USD, the EU file in EUR. Stack them, turn the file name into a currency, and total per currency — never across currencies.

  • combining files
  • lineage
  • currency

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