Are you interested in using your Python skills within Excel? Would you like to share a data science project or visualization as a single Office file? This week on the show, we speak with Principal Architect John Lam and Sr. Cloud Developer Advocate Sarah Kaiser from Microsoft about Python in Excel.
John shares the multi-year journey of adding Python to Excel. He describes how the project moved beyond writing user functions in Python to something much more elaborate. He details assembling a team with diverse skills in interface design, languages, and security.
Sarah discusses the instant convenience of having familiar Python and pandas techniques at your fingertips inside Excel. We cover typical data science workflows and the potential of interactive visualizations within a spreadsheet. We also share multiple resources for you to learn more.
Note: Python in Excel is currently a preview accessible by joining the Microsoft 365 Insider Program and selecting the Beta Channel.
Course Spotlight: Data Cleaning With pandas and NumPy
In this video course, you’ll learn how to clean up messy data using pandas and NumPy. You’ll become equipped to deal with a range of problems, such as missing values, inconsistent formatting, malformed records, and nonsensical outliers.
Topics:
Show Links:
Level up your Python skills with our expert-led courses:
Support the podcast & join our community of Pythonistas
Considering Accessibility & Assistive Tech as a Python Developer
Querying OpenStreetMaps via API & Lazy Evaluation in Python
Embarking on a Relaxed and Friendly Python Coding Journey
Pydantic Data Validation & Python Web Security Practices
Decoupling Systems to Get Closer to the Data
Avoiding Error Culture and Getting Help Inside Python
Leveraging Documents and Data to Create a Custom LLM Chatbot
Build a Video Game With Python Turtle & Visualize Data in Seaborn
Using Python in Bioinformatics and the Laboratory
Exploring Duck Typing in Python & Dynamics of Monkey Patching
Building a Healthy Developer Mindset While Learning Python
Automate Tasks With Python & Building a Small Search Engine
Wes McKinney on Improving the Data Stack & Composable Systems
Practical Python Decorator Uses & Avoiding datetime Pitfalls
Focusing on Data Science & Less on Engineering and Dependencies
Great Starting Points for Contributing to Open Source
Building a Python Debugger & Preparing for NumPy 2.0
Measuring Bias, Toxicity, and Truthfulness in LLMs With Python
Serializing Data With Python & Underscore Naming Conventions
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast