Releasing Module 02 - Practitioner's Series on xlwings Lite. Python in Excel. Data Cleaning & Rule Based Transformation
Published: July 6, 2025
I've put up a new guide on my site: Module 02 of my practitioner's series on xlwings Lite, focused on data cleaning.
My go-to for any Python-in-Excel work is xlwings Lite from Felix Zumstein. The guide uses a real-world mobile number example to show how to handle multi step rule-based transformations with xlwings Lite.
This same methodology can be used for data cleaning of other variables. As well create complex derived variables- from analysis datasets to campaign files.
But it's really about the process: how to instruct AI, how to use AI Coder file to provide context, and most importantly, validation of output.
This brings me to a core lesson from my years in the trenches: Validations are sacrosanct. AI didn't do the work- you did. It's a tool that helps, that's it. If it's not validated, it does not go out. No matter what AI says. No matter the pressure. Period.
Get the full module- including the workbook and AI Coder file at Tigzig xlwings Lite section
xlwings Lite official site: lite.xlwings.org