Data Cleaning Exercises

Pro exercise

Answer counts per question

Summarize a wide survey: for each question, how many respondents gave each answer. Unpivot first so the answers can be cleaned once, leave unanswered questions out, and count.

  • unpivot
  • aggregation
  • normalization

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