Audio is streamed directly from the publisher (dts.podtrac.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
<p>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.</p>
<p>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.</p>
<p>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. </p>
<p>Note: Python in Excel is currently a preview accessible by joining the Microsoft 365 Insider Program and selecting the Beta Channel.</p>
<div class="alert alert-primary" role="alert">
<p><strong>Course Spotlight:</strong> <a href="https://realpython.com/courses/data-cleaning-with-pandas-and-numpy/">Data Cleaning With pandas and NumPy</a></p>
<p>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.</p>
</div>
<p>Topics:</p>
<ul>
<li>00:00:00 – Introduction</li>
<li>00:01:53 – Sr. Cloud Developer Advocate Sarah Kaiser</li>
<li>00:02:46 – Principal Architect John Lam</li>
<li>00:04:08 – What is Dev Div?</li>
<li>00:04:33 – Python data science inside Excel</li>
<li>00:09:05 – Designing features with a focus on sharing</li>
<li>00:14:28 – Moving between Excel and Python objects</li>
<li>00:18:20 – What libraries are imported by default?</li>
<li>00:23:11 – Sharing a workbook with others</li>
<li>00:26:12 – Recalculating data workflow</li>
<li>00:30:07 – Working in Jupyter Notebook vs Excel</li>
<li>00:33:03 – Creating a Python object</li>
<li>00:33:38 – Video Course Spotlight</li>
<li>00:35:02 – More history and project team</li>
<li>00:40:19 – Immediate wins of having Python in Excel</li>
<li>00:42:28 – Interactive visualizations</li>
<li>00:44:34 – Answering security concerns</li>
<li>00:49:17 – Limitations and potential</li>
<li>00:54:34 – Creating demo projects</li>
<li>01:00:25 – Resources to learn more</li>
<li>01:02:59 – What are you excited about in the world of Python?</li>
<li>01:10:41 – What do you want to learn next?</li>
<li>01:12:09 – How can people follow your work online?</li>
<li>01:13:26 – Thanks and goodbye</li>
</ul>
<p>Show Links:</p>
<ul>
<li><a href="https://www.microsoft.com/en-us/microsoft-365/python-in-excel">Python in Excel – Python to Excel - Microsoft 365</a></li>
<li><a href="https://support.microsoft.com/en-us/office/get-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d">Get started with Python in Excel - Microsoft Support</a></li>
<li><a href="https://support.microsoft.com/en-us/office/python-in-excel-dataframes-a10495b2-8372-4f0f-9179-32771fe0dc04">Python in Excel DataFrames - Microsoft Support</a></li>
<li><a href="https://support.microsoft.com/en-us/office/open-source-libraries-and-python-in-excel-c817c897-41db-40a1-b9f3-d5ffe6d1bf3e">Open-source libraries and Python in Excel - Microsoft Support</a></li>
<li><a href="https://seaborn.pydata.org/tutorial.html">User guide and tutorial - seaborn 0.13.1 documentation</a></li>
<li><a href="https://ieeexplore.ieee.org/document/9286024">Assessing and Restoring Reproducibility of Jupyter Notebooks - IEEE Conference Publication - IEEE Xplore</a></li>
<li><a href="https://notes.iunknown.com/python-in-excel/Book+of+Python+in+Excel">Book of Python in Excel - John Lam’s Website</a></li>
<li><a href="https://github.com/microsoft/python-in-excel">GitHub - microsoft/python-in-excel - Python in Microsoft Excel</a></li>
<li><a href="https://www.youtube.com/watch?v=DL2M3glz41k">Use Python in Excel to enhance your data science - Python Day - YouTube</a></li>
<li><a href="https://techcommunity.microsoft.com/t5/microsoft-365-blog/introducing-python-in-excel-the-best-of-both-worlds-for-data/ba-p/3905482">Introducing Python in Excel: The Best of Both Worlds for Data Analysis and Visualization - Microsoft Community Hub</a></li>
<li><a href="https://peps.python.org/pep-0703/">PEP 703 – Making the Global Interpreter Lock Optional in CPython - peps.python.org</a></li>
<li><a href="https://fosstodon.org/@[email protected]">Dr. Sarah Kaiser (@[email protected]) - Fosstodon</a></li>
<li><a href="https://twitter.com/john_lam">John Lam (@john_lam) - X</a></li>
</ul>
<p>Level up your Python skills with our expert-led courses:</p>
<ul>
<li><a href="https://realpython.com/courses/data-cleaning-with-pandas-and-numpy/">Data Cleaning With pandas and NumPy</a></li>
<li><a href="https://realpython.com/courses/python-histograms/">Histogram Plotting in Python: NumPy, Matplotlib, Pandas & Seaborn</a></li>
<li><a href="https://realpython.com/courses/pandas-dataframe-working-with-data/">The pandas DataFrame: Working With Data Efficiently</a></li>
</ul> <p><a rel="payment" href="https://realpython.com/join">Support the podcast & join our community of Pythonistas</a></p>