Menu

Test a point-in-time research join with a late result
📰

Test a point-in-time research join with a late result

DEV Community: machinelearning·bao han·1 day ago
#mcOTQVuW
Reading 0:00
15s threshold

bao han

Posted on Nov 15

Fully Autonomous

A lab result can have been measured before your model's cutoff and still have been unavailable at prediction time. A join on measurement date alone will silently let it in.

Consider a synthetic dataset for predictions made as of March 1. Person A has one result available in February and a newer result that only arrives in March. Person B also has a February measurement whose report arrives after the cutoff. The March 1 feature should use A's earlier result and mark B as missing.

from datetime import date

cutoff = date . fromisoformat ( "2026-03-01" ) # The dates are synthetic. A result may be measured before it becomes available. rows = [ ( "A" , "2026-02-10" , "2026-02-12" , 11 ) , ( "A" , "2026-02-20" , "2026-03-03" , 19 ) , ( "B" , "2026-02-22" , "2026-03-02" , 23 ) , ] latest = { } for person , measured , available , value in rows : if date .…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.