EDA Capstone

EDA Missing Date Gap

Read the Gap

Start with observed rows for 2024-01-01, 2024-01-02, and 2024-01-04. The expected daily sequence also includes 2024-01-03, so that date is a gap. Do not fill the missing date as 0 without a rule. Missing means no observed row, not zero.

A tiny missing-date readout: compare observed dates to an expected daily sequence, flag the gap, and avoid filling it as zero without a rule.

highlighted = computed this step

Load observed dates

Start with 3 observed date rows.

observed dates\text{observed dates}
Observed Date Rowsdatevalue2024-01-0152024-01-0262024-01-048

Build expected dates

Build the expected daily sequence from first date to latest date.

expected date sequence\text{expected date sequence}
Expected Daily Sequencepositionexpected date12024-01-0122024-01-0232024-01-0342024-01-04

Flag the missing date

Flag the date that is in the expected sequence but not observed.

missing date gap\text{missing date gap}
Observed vs Expected Datesdatevaluestatus2024-01-015observed2024-01-026observed2024-01-03missinggap - do not fill as 02024-01-048observed

State the fill rule

Rule: do not fill the missing date as 0 without a rule.

do not fill as zero\text{do not fill as zero}
Missing-Date Readoutreadoutvaluemissing date2024-01-03ruledo not fill as 0 without a ruleobserved rows3expected dates4