Advanced Excel Analytics: Python Integration Workshop
summary
Hands-on workshop walks through Python-in-Excel plus the Anaconda Toolbox, demonstrates building a working sentiment pipeline (NLTK/VADER) that scores Amazon iPhone reviews, produces a word cloud and boxplots, and shows how to register custom conversion functions and custom Excel preview (repper) dictionaries so Python objects spill as useful cells. It contrasts cloud execution on Azure (security and package limits) with an alternative: Anaconda Code (local WASM), and shows a prototype of user-defined functions; everything runs and updates live in the workbook.
AI-written summary · about
chapters (11)
- 0:00Python Excel integration
- 3:22Workshop setup
- 13:55Basic Python Excel demo
- 24:32Excel limitations and workarounds
- 31:53Returning Python results to Excel
- 42:19Custom data types in Excel
- 50:54Sentiment analysis with NLTK
- 1:00:07Visualizing sentiment results
- 1:13:44Security and package limits
- 1:20:51Local Python Excel alternative
- 1:23:42Future features and closing
related talks
01h 24mIntroduction to Data-Analysis with Pandas
28mUsing Python in a Data Hackathon
42mSimplifying Data Analysis with GitHub Codespaces, Jupyter Notebooks & Open AI
34mPython as a Framework for Analytics and Growth Hacking
36mLightning Talks
01h 53mAnalyze your data in Python
39mPython & Spreadsheets: 2017 Edition
31mUsing Python in a Traditional Office