Data Cleaning Exercises

Pro exercise

Session start and end as instants

Work out when each user session started and ended. Events were logged by servers in different time zones, so the earliest and latest event must be found by instant, not by the text of the timestamp.

  • timestamps
  • aggregation
  • time zones

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