Data Cleaning Exercises

Pro exercise

Count distinct users per day

An event log has many events per person. Report daily active users: distinct people per day, not events, after normalizing user IDs and leaving out rows that can't be attributed.

  • aggregation
  • distinct counts
  • dates

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