
Parse CSV records that contain newlines
A postal-address export demonstrates why line counts are not row counts. A worked analytical example with explicit assumptions and checked results.
The journal / Ideas in progress
Engineering & everyday learningSoftware, systems, and the things I’m learning along the way. From first principles to AI in production.
Find something to readA little theory. A lot of practice.

A postal-address export demonstrates why line counts are not row counts. A worked analytical example with explicit assumptions and checked results.

Count rows, submissions and observed ratings correctly with runnable SQL, an invitation denominator, empty cohorts and explicit missingness rules.

Class sizes of two and eight produce different weighted and unweighted exam averages. A worked analytical example with explicit assumptions and checked results.

Keep inventory movements separate from closing balances, check missing warehouse coverage, and reconcile state with changes under an explicit reporting boundary.

A messy quantity column retains original tokens and rejection reasons. A worked analytical example with explicit assumptions and checked results.

Define what one analytical row represents, keep receipt and line measures separate, and distinguish a missing line from an observed zero with executable SQL.

Three invoice fractions show rounding stage and exact decimal input. A worked analytical example with explicit assumptions and checked results.

A commute survey separates an observed zero, declined answer, not-applicable record, and collection failure. A worked analytical example with explicit assumptions and checked results.