EDA Duplicate Row Cleanup - Time Series Mechanics

Read the Cleanup

Start with four raw rows. Row r3 repeats the same day and value as row r2, so it is marked as the duplicate. After cleanup, the plot has three clean points. The effect table shows the row count changing from 4 raw rows to 3 clean rows, with 1 duplicate row removed.

A tiny duplicate cleanup readout: identify one repeated row, keep one copy, and show the row-count effect.

highlighted = computed this step

Load rows

Start with 4 pinned rows, including one repeated Tue 7 row.

\text{raw rows with duplicate}

Mark the duplicate

Mark row 3 as duplicate because it repeats Tue 7.

\text{mark duplicate row}

Keep one copy

Keep one copy, leaving 3 clean rows.

\text{clean rows after dedup}

Count the effect

Row count changes from 4 to 3, so 1 duplicate row was removed.

\text{dedup row count effect}