Data Cleaning Exercises

Pro exercise

Unanswered questions count in the denominator

Report, per survey question, how many respondents were asked and how many answered. Reshaping to long form must keep the unanswered cells: DuckDB's UNPIVOT drops NULLs by default, which would make every question look 100% answered.

  • missing values
  • unpivot
  • rates

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