Data Cleaning Exercises

Pro exercise

Number format depends on the file

The German office sends 1.234,50 and the US office sends 1,234.50. After stacking the files, parse each amount with its file's separators: in the German file 12.500 is twelve thousand five hundred, in the US file 1.234 has too many decimals.

  • combining files
  • number formats
  • lineage

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