Python for Excel: A Modern Environment for Automation and Data Analysis
暫譯: Python 在 Excel：現代化自動化與數據分析環境
Zumstein, Felix
2026-english-2-80 詳見活動內容 »
-
90折
$2,520Video Generation with AI: Working with Diffusion Transformers and Multimodal Learning (Paperback) -
90折
$2,484Comptia Linux+ Study Guide: Essential Exam Prep -
90折
$1,890Mapping Experiences: A Complete Guide to Activating Customer-Centered Collaboration 3/e -
90折
$2,493Databricks Certified Generative AI Engineer Associate Study Guide: Generative AI with Databricks -
90折
$1,980The C4 Model: Visualizing Software Architecture (Paperback) -
90折
$2,502Ai-Assisted Statistics for Data Scientists: 50+ Essential Concepts Using R and Python -
90折
$2,268Observability Engineering: Achieving Production Excellence, 2/e (Paperback) -
90折
$1,935Soccer Analytics with Machine Learning: Learning Predictive Modeling Techniques with Sports Data -
90折
$2,502Vision Language Models: Building Vlms with Hugging Face (Paperback) -
90折
$1,935Learning Cloud Security: Cloud Computing and Security Architecture Essentials -
90折
$2,106High Performance Spark: Best Practices for Scaling and Optimizing Apache Spark 2/e -
90折
$1,944Python for Excel: A Modern Environment for Automation and Data Analysis -
90折
$1,440Managing AI Projects: Drive Innovation and Successfully Navigate the Full AI Project Lifecycle (Paperback) -
90折
$2,484Large Language Models: The Hard Parts: Open Source AI Solutions for Common Pitfalls (Paperback) -
90折
$1,917Real-Time Intelligence with Microsoft Fabric: Empowering Data-Driven Decisions in the Era of AI (Paperback) -
90折
$1,917Certified Kubernetes Application Developer (Ckad) Study Guide: In-Depth Guidance and Practice (Paperback) -
90折
$2,484Large Language Models: The Hard Parts: Open Source AI Solutions for Common Pitfalls (Paperback)
-
90折
$2,520AI-Ready Data Blueprints: From Raw Data to Ai-Driven Innovation (Paperback) -
90折
$2,448Hands-On LLM Serving and Optimization: Hosting Llms at Scale (Paperback) -
90折
$2,484Rag with Python Cookbook: Practical Recipes from Data Preprocessing to LLM Agents (Paperback) -
90折
$2,205Vector Databases: A Practical Introduction (Paperback) -
90折
$2,205Vector Databases: A Practical Introduction (Paperback)
-
90折
$2,448Hands-On LLM Serving and Optimization: Hosting Llms at Scale (Paperback)
-
90折
$2,205Generative AI on Microsoft Azure: From Large Language Models to Advanced Multi-Agent Systems (Paperback) -
90折
$1,890Learning Generative AI Tools for Excel: Speed Up Your Everyday Tasks with Microsoft Excel, Copilot, Chatgpt, and Beyond (Paperback)
商品描述
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
商品描述(中文翻譯)
專業人士在幾乎每個行業中都使用 Excel 來創建能夠快速適應快速變化環境的強大工具。然而，Excel 的自動化語言 VBA 很久以前就停止了發展。另一方面，Python 的受歡迎程度激增，因此微軟官方推出 Python 整合也就不足為奇了。本書是一本經過徹底修訂的實用指南，幫助您利用 Python 釋放 Excel 的全部潛力。
分析師、工程師、數據科學家和其他高級用戶將學習如何利用微軟的 Python in Excel 功能擴展 Excel 強大的分析引擎。借助 Excel 的 AI Copilot 工具，即使是 Python 新手也能輕鬆完成高級任務。作者 Felix Zumstein——流行的開源套件 xlwings 的創建者——還深入探討了互補解決方案，包括 xlwings 和 OpenPyXL，充分發揮 Excel 和 Python 的結合能力。
- 學習如何使用 Python 的核心功能
- 開始使用現代工具，包括 Jupyter notebooks 和 Visual Studio Code
- 應用強大的 pandas 命令來獲取、清理和分析數據
- 通過 Excel 中的 pandas 使用 Python 進行高級分析
- 使用 xlwings 和 OpenPyXL 操作 Excel 文件
- 使用 xlwings 和 xlwings Lite 自動化 Excel
