Data Cleaning Exercises

Pro exercise

Counts of nothing are zero

Build a team-by-status table of ticket counts. Unlike sums of unknown values, a count over no tickets really is 0, so empty cells are filled with 0 — a documented exception to 'missing is not zero'.

  • pivot
  • counting
  • zero versus missing

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