Skip to content

Teaching — basic

Synthetic, minimal inputs that isolate one engine feature at a time.

  • Null Variants → Empty

    Fold every "no value" spelling — NULL, NA, N/A, n/a, None, "-" — into a single genuine empty cell, while leaving real values untouched.

  • Space-Grouped Thousands → Number

    Parse the continental-European number format — space-grouped thousands with a comma decimal, "1 234 567,89" = 1234567.89 — into a clean numeric value.

  • Timezone Functions — normalise to UTC, convert between zones

    Turn messy per-broker timestamps into clean UTC and derive zone facts with the four timezone builtins — TO_UTC, TZ_OFFSET, IS_DST, and TZ_CONVERT — all DST-aware, no external service.

  • Units-in-Cell → Number + Unit

    Split a measurement column that glues a number to its unit — 5.0 kg, 250 g, 1.5 L, 12 pcs — into a clean numeric amount and a separate unit column.