Hewitt & Kitchen - Advanced Excel Analytics: Python Integration Workshop | PyData NYC 2024

[owenprice-anaconda]

00:00 Set up
03:35 Introduction
06:42 Python in Excel Basics
12:15 Anaconda Toolbox
14:15 Understanding xl()
17:06 Customizing the output of xl()
24:20 The xl() is a MACRO, not a function
28:52 Sneak peek at Anaconda Code
32:07 Introduction to reprs
38:17 Custom reprs for Excel Values
42:20 Custom entity cards
50:56 NLTK analysis - 1
01:03:53 Getting Python help from Anaconda Assistant
01:05:26 NLTK analysis - 2
01:11:19 Q&A and Wrap-Up
01:15:49 Anaconda Code, Python UDFs and more!