Data Cleaning Exercises

Pro exercise

A rate is the mean of a 0/1 column

Compute the conversion rate per channel. Encode converted as 1 and not converted as 0, and the rate is simply the mean. Visits with an unknown outcome are left out of both the numerator and the denominator, not counted as failures.

  • rates
  • encoding
  • aggregation

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