Felix Zumstein - Python for Excel

by Felix Zumstein

Copyright 2021 Zoomer Analytics LLC. All rights reserved.

Printed in the United States of America.

Published by OReilly Media, Inc. , 1005 Gravenstein Highway North, Sebastopol, CA 95472.

OReilly books may be purchased for educational, business, or sales promotional use. Online editions are also available for most titles (http://oreilly.com). For more information, contact our corporate/institutional sales department: 800-998-9938 or corporate@oreilly.com .

• Acquisitions Editor: Michelle Smith
• Development Editor: Melissa Potter
• Production Editor: Daniel Elfanbaum
• Copyeditor: Piper Editorial Consulting, LLC
• Proofreader: nSight Inc.
• Indexer: nSight Inc.
• Interior Designer: David Futato
• Cover Designer: Karen Montgomery
• Illustrator: Kate Dullea

• March 2021: First Edition

See http://oreilly.com/catalog/errata.csp?isbn=9781492081005 for release details.

The OReilly logo is a registered trademark of OReilly Media, Inc. Python for Excel, the cover image, and related trade dress are trademarks of OReilly Media, Inc.

The views expressed in this work are those of the author, and do not represent the publishers views. While the publisher and the author have used good faith efforts to ensure that the information and instructions contained in this work are accurate, the publisher and the author disclaim all responsibility for errors or omissions, including without limitation responsibility for damages resulting from the use of or reliance on this work. Use of the information and instructions contained in this work is at your own risk. If any code samples or other technology this work contains or describes is subject to open source licenses or the intellectual property rights of others, it is your responsibility to ensure that your use thereof complies with such licenses and/or rights.

978-1-492-08100-5

[LSI]

Microsoft is running a feedback forum for Excel on UserVoice where everybody can submit a new idea for others to vote on. The top voted feature request is Python as an Excel scripting language, and it has roughly twice as many votes as the second most voted feature request. Though nothing really happened since the idea was added in 2015, Excel users were fueled with new hope at the end of 2020 when Guido van Rossum, the creator of Python, tweeted that his retirement was boring and he would join Microsoft. If his move has any influence on the integration of Excel and Python, I dont know. I do know, however, what makes this combination so compelling and how you can start using Excel and Python togethertoday. And this is, in a nutshell, what this book is about.

The main driving force behind the Python for Excel story is the fact that we are living in a world of data. Nowadays, huge datasets are available to everybody and about everything. Often, these datasets are so big that they dont fit into a spreadsheet anymore. A few years ago, this may have been referred to ).

Python, on the other hand, is a general-purpose programming language that has become one of the most popular choices amongst analysts and data scientists. If you use Python with Excel, you are able to use a programming language that is good at all aspects of the story, whether thats automating Excel, accessing and preparing datasets, or performing data analysis and visualization tasks. Most importantly, you can reuse your Python skills outside of Excel: if you need to scale up your computing power, you could easily move your quantitative model, simulation, or machine learning application to the cloud, where practically unconstrained computing resources are waiting for you.