Weekend Flag - Data Cleaning Step by Step

Mark Weekend Dates

Start with four pinned ISO date strings. The original order_date column stays unchanged. Read the weekday for each date, then add is_weekend beside it. This flag is useful for grouping or filtering later, but it does not replace the original date.

Adding an exact true/false feature that marks whether a pinned date string falls on Saturday or Sunday.

highlighted = computed this step

Input date strings

Start with 4 pinned ISO date strings.

\text{date strings}

Exact weekend rule

Mark Saturday and Sunday as true; mark weekdays as false.

\text{weekend rule}

Add is_weekend

Add is_weekend beside the original date string.

\text{date plus weekend flag}