Parse a Messy CSV Live: Interview Round in Python
A messy file, five checks, five attempts. The first passes 1 of 5. The last passes all 5.
Video #325 ยท Forward deployed engineer interviews
Steps in the video
- 0:00 A messy file, five checks, and five small fixes
- 0:31 The idea
- 1:00 Setup
- 1:22 The file
- 1:55 The five checks
- 2:20 Attempts one and two
- 2:47 Attempt three: dates
- 3:20 Attempt four: amounts
- 3:40 Attempt five: one row per id
- 3:58 Run all five
- 4:46 What this does not show
- 5:14 Mistakes to avoid
- 5:40 My take and next steps
- 6:06 Recap
Files
- checks.py (36 lines)
- messy.py (8 lines)
- run.py (14 lines)
- steps.py (54 lines)
Tested with
Python 3.12.15
What this does not show
A tiny made-up file with five planted problems; 03/04/2026 is read day first by assumption; no large files, encodings or short rows.
Sources
Learning IT by Example.