Python for Excel

The book is dedicated to automating Excel using the Python programming language. It describes the Anaconda Python distribution and modern development tools such as the Conda and pip package managers, Jupyter notebooks, and Visual Studio Code. It provides the necessary... basics of the Python language and an introduction to data analysis using the pandas library. Techniques for reading and writing Excel files without Excel are given. Programming Excel applications using the popular open-source package xlwings is considered: Excel automation, tools based on Python technology, a Python package tracker, as well as user-defined functions.
An electronic archive on the publisher's website contains color illustrations for the book.
For experienced Excel users and programmers.