Data Cleaning Exercises

Pro exercise

An audit log in true time order

Deliver an audit log sorted by when things happened. Entries were stamped in different time zones, so sorting the text puts 09:30-05:00 before 12:00Z although it happened later. Sort by instant, ties by id.

  • timestamps
  • sorting
  • delivery

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