Felix Zumstein | Python for Excel. A Modern Environment for Automation and Data Analysis. 2nd Edition (2026) [PDF, EPUB]
Автор: Felix Zumstein
Издательство: O'Reilly Media
ISBN: 979-8341640290, 979-8341640269
Жанр: Desktop Database, Spreadsheet, Data Processing
Язык: Английский
Формат: PDF, EPUB
Качество: Изначально электронное (ebook)
Иллюстрации: Цветные и черно-белые
Описание:Professionals in nearly every industry use Excel to create powerful tools that can adapt quickly to fast-changing environments. But Excel's automation language, VBA, stopped evolving a long time ago. Python, on the other hand, has exploded in popularity, so Microsoft's official Python integration came as no surprise. This thoroughly revised hands-on guide helps you unlock Excel's full potential using Python.
Analysts, engineers, data scientists, and other power users will learn how to extend Excel's powerful analytics engine with Microsoft's Python in Excel feature. And with Excel's AI Copilot tool, even Python newbies can easily accomplish advanced tasks. Author Felix Zumstein—creator of the popular open source package xlwings—also dives into complementary solutions, including xlwings and OpenPyXL, that make the most of the combined capabilities of Excel and Python.
Learn how to use Python's core features
Get started with modern tools, including Jupyter notebooks and Visual Studio Code
Apply powerful pandas commands to acquire, clean, and analyze data
Use advanced analytics via pandas in Excel, using Python in Excel
Manipulate Excel files with Python, using xlwings and OpenPyXL
Automate Excel with Python, using xlwings and xlwings Lite
Part I. Introduction to Python
1 Why Python for Excel?
2 Development Environment
3 Getting Started with Python
Part II. Introduction to pandas
4 NumPy Foundations
5 Data Analysis with pandas
Part III. Python in Excel
6 Getting Started with Python in Excel
7 Time Series Analysis with pandas
Part IV. xlwings
8 Excel Automation
9 Python-Powered Excel Tools
10 The Python Package Tracker
11 Custom Functions
Part V. xlwings Lite
12 Scripts with xlwings Lite
13 Custom Functions with xlwings Lite
Part VI. Reading and Writing Excel Files Without Excel
14 Excel File Manipulation with pandas
15 Excel File Manipulation with Reader and Writer Packages
Скриншоты:
Время раздачи: с 10 до 20 (минимум до появления первых 3-5 скачавших) 
