Python-Powered Excel: Combining the strengths of Python and Excel for deliverables and complex tasks (English Edition)
暫譯: Python 驅動的 Excel：結合 Python 和 Excel 的優勢以應對交付物和複雜任務 (英文版)
Arora, Nisha
- 出版商: BPB Publications
- 出版日期: 2026-04-19
- 售價: $3,060
- 貴賓價: 9.5 折 $2,907
- 語言: 英文
- 頁數: 392
- 裝訂: Quality Paper - also called trade paper
- ISBN: 9378543553
- ISBN-13: 9789378543555
-
相關分類:
Python
海外代購書籍(需單獨結帳)
商品描述
Excel is the backbone of business, but its limitations with complex data and repetitive manual tasks hinder productivity. Python, the world's most versatile programming language, offers a powerful solution. By utilizing various tools, Excel users can move beyond basic spreadsheet functions and tap into Python's robust capabilities for advanced data analysis and automation.
This book offers a practical guide to Excel (not necessarily 365) and Python users to automate tedious tasks, analyze data, and create dynamic reports. It will help you use Python's power as an engine to drive analytics and produce deliverables in Excel, as most stakeholders expect. The first section introduces Python, one of today's most popular languages. Learning Python is a stepping stone to mastering other advanced libraries, transitioning smoothly into broader data and automation tools. The next section discusses Python's robust and intelligent tools for handling data. The following two sections discuss versatile tools for Python-Excel integration, enabling you to manipulate, format, and protect Excel files to generate reports. It will also help you replace VBA with Python code, interacting with legacy macros, or developing custom Excel functions to simplify workflow.
WHAT YOU WILL LEARN
● Set up Python and manage environment for reproducibility.
● Python fundamentals and programming basics.
● Clean, transform, and analyze Excel data efficiently with pandas and other libraries.
● Read, write, and format Excel files programmatically.
● Use openpyxl, xlsxwriter, pyxlsb and xlwings for Excel integration.
● Interact with Excel directly with Python via COM object or AppleScript.
WHO THIS BOOK IS FOR
This book is designed for Excel users, professionals, analysts, students, or anyone eager to leverage Python for automating, analyzing, and managing Excel spreadsheets efficiently. It will also help Python programmers and data scientists, communicating with stakeholders and business executives, who are interested in Excel, to deploy deliverables powered by Python with Excel as a front-end.
商品描述(中文翻譯)
Excel 是商業的支柱，但其在處理複雜數據和重複手動任務方面的限制會妨礙生產力。Python，這個世界上最具多功能性的程式語言，提供了一個強大的解決方案。透過利用各種工具，Excel 使用者可以超越基本的電子表格功能，並利用 Python 強大的能力進行高級數據分析和自動化。
本書提供了一本實用指南，針對 Excel（不一定是 365 版本）和 Python 使用者，幫助自動化繁瑣的任務、分析數據並創建動態報告。它將幫助您利用 Python 的力量作為驅動分析的引擎，並在 Excel 中產出大多數利益相關者所期望的交付成果。第一部分介紹了 Python，當今最受歡迎的語言之一。學習 Python 是掌握其他高級庫的基石，並能順利過渡到更廣泛的數據和自動化工具。接下來的部分討論了 Python 在處理數據方面的強大和智能工具。隨後的兩個部分則探討了 Python 與 Excel 整合的多功能工具，使您能夠操作、格式化和保護 Excel 檔案以生成報告。它還將幫助您用 Python 代碼取代 VBA，與舊有的宏互動，或開發自定義的 Excel 函數以簡化工作流程。
您將學到什麼
● 設置 Python 並管理環境以確保可重現性。
● Python 基礎知識和程式設計基礎。
● 使用 pandas 和其他庫高效清理、轉換和分析 Excel 數據。
● 以程式方式讀取、寫入和格式化 Excel 檔案。
● 使用 openpyxl、xlsxwriter、pyxlsb 和 xlwings 進行 Excel 整合。
● 通過 COM 物件或 AppleScript 直接與 Excel 互動。
本書適合誰
本書專為 Excel 使用者、專業人士、分析師、學生或任何渴望利用 Python 高效自動化、分析和管理 Excel 電子表格的人士而設。它也將幫助 Python 程式設計師和數據科學家，與對 Excel 感興趣的利益相關者和商業高管溝通，並部署以 Python 驅動的交付成果，Excel 作為前端。
