07-10, 16:30–17:00 (US/Pacific), Room 318
Working with data in grids or spreadsheets is great for collaboration as there are many different tools to view and edit the files. Data science workflows often include packages like openpyxl to create, load, edit, and export spreadsheets that then are shared with others who can use other tools like Excel, Google Sheets, or IDEs to view them. The new Python in Excel feature as well as the Anaconda Toolbox add-in provides the tools to run Python directly in cells in a spreadsheet, making it easier for Pythonistas to access and collaborate on code. This talk will introduce how these features work, demo collaborating on Python code in a worksheet, and talk about some case studies where these tools have been used to teach and collaborate with Python.
- Introduction
- Importance of working with data in grids or spreadsheets for collaboration
-
Various tools available to view and edit files
-
Working from Python you can use packages like openpyxl and pandas
- New Pythonista tools for spreadsheet work
- Overview of Python in Excel feature
- Introduction to the Anaconda Toolbox add-in
- Advantages for Pythonistas
- Easier access to and collaboration on code within spreadsheets
- No environment setup
-
Demo: Running Python directly in cells in a spreadsheet with other people
-
Advanced features you can make your data polished:
- Python = Plotting upgrades
- custom data types
-
custom Reprs
-
Case Studies
- Teach Python to Finance professionals
-
Collaborate with Python in industry
-
Conclusion
- Recap of key points
- Implications for data analysis and collaboration
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.