top of page

Releasing Module 02 — Practitioner’s Series on xlwings Lite. Python in Excel. Data Cleaning & Rule Based Transformation

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:

app.tigzig.com (in the xlwings Lite Practice Lab section)


 
 
bottom of page