15 · 8 lessons

Data in practice

Clean real CSV, validate JSON, parameterize SQLite, handle exact prices and process data streams.

Progress and your code are kept in this browser only.

  1. 1Round money at an explicit boundary
  2. 2Parse CSV without splitting on commas
  3. 3Compare instants across timezone offsets
  4. 4Aggregate an iterator in one pass
  5. 5Keep SQL values out of SQL syntax
  6. 6Validate a decoded JSON value at the boundary
  7. 7Keep only the largest k values
  8. 8Update a mean without storing all samples