
Preserve raw values before cleaning a CSV
A messy quantity column retains original tokens and rejection reasons. 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 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.

Update native checkboxes and nested metadata while preserving a saved baseline, then test no-op identity, shared references, structured cloning and shallow freeze.

Separate Python buffers, kernel-visible file data and successful fsync, then test abrupt process termination without confusing it with power-loss recovery.

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.

Model order identity, reject orphan references, inspect cascades and separate database relationships from the policy for deleting a paid order.