𝐏𝐲𝐭𝐡𝐨𝐧 𝐖𝐨𝐫𝐤𝐟𝐥𝐨𝐰𝐬. 𝐈𝐧𝐬𝐢𝐝𝐞 𝐄𝐱𝐜𝐞𝐥. 𝐖𝐢𝐭𝐡 𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞 (𝐟𝐫𝐞𝐞) - 𝐏𝐨𝐰𝐞𝐫𝐟𝐮𝐥.

Data transforms, automations, custom functions, API Calls, stats, ML

Another superb addition to analyst and data scientist’s toolkit - xlwings Lite. From Felix Zumstein, creator of xlwings - the powerful and widely used Python package for Excel automation. I’ve used xlwings off and on over the years - solid package.

Check out dedicated xlwings LIte section on REX AI Co Analyst site

Full templates

How-to guides

Backend code

Technical breakdowns

Resource Links

𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞 was released just yesterday. Ran a few quick codes- what I typically run in Jupyter / Colab - it’s brilliant.

Setup was simple - just add the xlwings Add-in and you're set. Tried an XGBoost model on cleaned-up mock data - decile table, scoring, ROC/Gains chart ...just to see how it handles...Also some quick analysis, feature engineering, basic stats - smooth and easy.

𝐌𝐨𝐬𝐭 𝐢𝐦𝐩𝐫𝐞𝐬𝐬𝐢𝐯𝐞

• Manipulate Excel objects - sheets, columns, rows

• Transfer data between Excel and Python

• Neat mini editor

• Console for print() output and debugging

• Requirements.txt for package installs

• Custom Functions

• Web API calls (huge)+ DB access via same layer (yet to try out)

𝐐𝐮𝐢𝐜𝐤 𝐓𝐢𝐩𝐬 (based on initial hands-on)

• Format Excel ranges as Tables - good practice anyway.

• Use any LLM or AI coder - they already “know” the xlwings object model.

• Write everything as standard Python functions (def).

• Use @func to create Excel-callable functions (=formula), and @script for direct code runs.

• Great docs and API reference if you get stuck.

𝐈𝐬 𝐢𝐭 𝐚 𝐫𝐞𝐩𝐥𝐚𝐜𝐞𝐦𝐞𝐧𝐭 𝐟𝐨𝐫 𝐉𝐮𝐩𝐲𝐭𝐞𝐫/𝐂𝐨𝐥𝐚𝐛?

Nopes..many analytics and ML workflows are iterative and need data warehouse connects. A strong addition to the toolkit, not a replacement.

𝐆𝐫𝐞𝐚𝐭 𝐟𝐢𝐭 𝐟𝐨𝐫

▸ Excel automation - I’ll take Python over VBA any day (and the combo - even more powerful)

▸ Complex data transformations - no need to switch between Jupyter and Excel.

▸ In-Excel EDA, validations, diagnostics

𝐋𝐢𝐧𝐤𝐬 

Post & walkthrough video by Felix Zumstein (creator of xlwings): https://lnkd.in/geKzDK45

GitHub repo with demo files and scripts: https://lnkd.in/gZVaZzvD

----------------*

Explore 15+ open-source AI analytics apps at rex.tigzig.com with natural language to SQL, python charts, stats, database connectivity and more.

Free access, source codes and build guides

🔹AI Powered Automation - 𝐂𝐨𝐧𝐧𝐞𝐜𝐭 𝐂𝐡𝐚𝐭𝐆𝐏𝐓 𝐰𝐢𝐭𝐡 𝐧𝟖𝐧

https://lnkd.in/gTDC74gY

🔹AI 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 Micro App: https://lnkd.in/gxVbCdpv

🔹AI Co-Analyst 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 App: https://lnkd.in/g8xPQvb8

🔹𝐑𝐞𝐚𝐥𝐭𝐢𝐦𝐞 𝐕𝐨𝐢𝐜𝐞 AI connected to database: https://lnkd.in/g6cT8ZSM https://lnkd.in/gCT9J_K4