07-07, 13:30–17:30 (US/Pacific), Room 318
Spreadsheets are one of the most common ways to share and work with data which helpfully also works great in Python! In this tutorial, we will cover some of the basics and best pratice of consuming and producing spreadsheets in Python as well as a deep dive into how to run Python directly in your spreadsheets. We will introduce and dive deep into the new Python in Excel features as well as the Anaconda Toolbox for Excel add-in.
This tutorial will start with a brief overview on spreadsheets, including tools for viewing and working with them. Then we will delve into working with spreadsheets in Python using openpyxl and pandas, including opening, streaming, exporting files, editing cell data, and accessing images and metadata. Flipping things around, the next section of the tutorial will explore using Python directly in one of the most common spreadsheet tools, Excel, using the new Anaconda Toolbox and Python in Excel. We will also dig into the ways you can leverage custom data types and Repers to make working with your data in Excel Pythonic and polished.
Participants will walk away with tons of new tools, techniques, and best practices making your work easier for Pythonistas and non-Pythonistas alike to collaborate and build on!
Participants will be most successful if they have some familiarity with spreadsheet-like tools, but no previous experience with the topic is required.
Jim Kitchen is the lead engineer on the team that built the Anaconda Toolbox and Anaconda Code add-ins for Excel
Sarah has spent most of her career developing technology in the lab, from virtual reality hardware to satellites. She got her PhD in Physics by starting plasma fires with lasers, Python, and Jupyter Notebooks. She has also written tech books for folks of all ages, including ABCs of Engineering and Learn Quantum Computing with Python and Q#. As a Cloud Developer Advocate for Python at Microsoft and a Python Software Foundation Fellow, she finds all kinds of new ways to build and break OSS tools for data science and machine learning. When not at her split ergo keyboard, she loves boating in the Seattle area, laser cutting everything, and playing with her German Shepard, Chewie.