Data Cleaning Exercises

Pro exercise

Totals that reconcile with missing keys

Total expenses per department, including expenses with no department. pandas groupby silently drops missing keys by default, so the report would no longer add up to the file; keep the missing group.

  • group by
  • missing values
  • reconciliation

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