Today, a significant amount of business data exists in spreadsheets, but the great data analysis and visualization tools are only available in Python. People familiar with Excel but lacking any Python experience find it difficult to benefit from the power of the data science ecosystem that has emerged around Python.
Christine Doig and Fabio Pliger explain how they created a native Microsoft Excel plug-in that provides a point-and-click interface to Python functions, enabling Excel analysts to use machine learning models, advanced interactive visualizations, and distributed compute frameworks without needing to write any code. This was achieved using Jupyter kernels that run decorated Python functions in a notebook, written by any Python coder. Christine and Fabio explore the technical architecture that leverages Jupyter, application use cases and workflows, lessons learned, and opportunities for the future.
Christine Doig is a senior product manager and data scientist at Anaconda Powered by Continuum Analytics. Christine has 8+ years of experience in analytics, operations research, and machine learning in a variety of industries, including energy, manufacturing, and banking. An open source advocate, she has spoken at PyData, EuroPython, SciPy, PyCon, OSCON, and many other open source conferences. Christine holds an MS in industrial engineering from the Polytechnic University of Catalonia in Barcelona.
Fabio Pliger is the technical lead for Anaconda Fusion and a Bokeh core developer at Anaconda Powered by Continuum Analytics, where he also worked on the XDATA DARPA and on customer projects. Fabio has 14+ years of experience in Python applied to both highly regulated enterprise and open source. He has been an open source and Python advocate for many years and has spoken at many tech conferences around the world. He is a former chairman of the EuroPython Society, cochair of the EuroPython Conference and PyCon Italy, and cofounder of the Python Italia Association. Fabio holds an bachelor’s degree in computer science from the University of Verona, Italy.
©2017, O'Reilly Media, Inc. • (800) 889-8969 or (707) 827-7019 • Monday-Friday 7:30am-5pm PT • All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. • firstname.lastname@example.org