Pandas' Thumb: unexpected evolutionary use of a Python library.
summary
Claim: Pandas can replace spreadsheets for complex UK SDLT lease work by building time‑aware data frames that do the arithmetic, handle NPVs and credits, and export audit CSVs. Built a Pandas‑based SDLT engine ORVILLE that generates daily rows, slices first‑five‑year rents, applies VAT and net present value rules (numpy formula quirks included) and speeds work reduces 1.5–2 hours to minutes. Proof‑of‑concept works in practice though calendar‑year rolling windows and user training remain practical limits.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 3:00Panda’s thumb concept
- 8:16Tax compliance challenges
- 14:11Why pandas for tax
- 17:00Orville SDLT engine
- 26:06Live demo: tax problem
- 29:58Pandas for modern tax
- 31:21Q&A tax office checks
- 33:27Audience feedback
