promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_

Joins and label windows without leakage — step 7 of 7

ch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasets7/7
Checkpoint

One last thing before we move on. pass this to mark the lesson done, or skip and keep moving. hop to the next when you're ready.

Checkpoint. Build the labeled dataset: dataset(db, cutoff) returns (user, pre_cutoff_actions, label) per user, where the label is 1 if the user's actions IN the cutoff month were 0 (went quiet = churned). Keep every user (left-join thinking), sorted by user.

full-screen editor opens — close anytime to keep reading.

open the editor to run it.