Spreadsheet-Driven Meta-Programming for Python
summary
Turns spreadsheets into runnable Python: generator reads tabbed CSVs with csv.DictReader, builds a multi‑dimensional description via defaultdict, and produces either Django models with validation or a runtime API that maps board and signal names to lab jack ports. It intercepts attribute and call syntax with __getattr__ and __call__, hands work as functools.partial for late validation, and yields a hardware test API and generated code that survive schema changes and reduce repetitive bugs.
AI-written summary · about
chapters (10)
- 0:00Start
- 12:39Code Generation
- 15:47Ipython Notebook
- 26:19Dix Reader
- 27:07Csv Dict Reader
- 29:59Default Dict
- 33:26Three-Dimensional Dictionary
- 59:09Partial Application
- 1:15:17Call Builder
- 1:48:12Dynamic Class Generation
related talks
24mHow to build a spreadsheet with Python
21mMeta: Enabling Programming Languages to Learn from the Crowd
39mPython & Spreadsheets: 2017 Edition
02h 14mHands-on Python for Programmers
37mPowering Energy Storage Beyond Excel
46mFrictionless Data Science w/Python
02h 46mThe How and Why of Object-oriented Programming in Python
02h 52mFrom Spreadsheets to DataFrames