没有合适的资源?快使用搜索试试~ 我知道了~
首页python for excel
资源详情
资源推荐
Felix Zumstein
Python
for Excel
A Modern Environment for Automation
and Data Analysis
DATA PYTHON
“This book explains
how you can integrate
Python into Excel and
free yourself from the
inevitable disaster
of huge workbooks,
thousands of formulas,
and ugly VBA hacks.
Python for Excel is
probably the single
most useful book on
Excel that I have read
and an absolute must-
read for any advanced
Excel user.”
—Andreas F. Clenow
CIO, Acies Asset Management, and
author of international best-sellers
Following the Trend, Stocks on the Move,
and Trading Evolved
Python for Excel
ISBN: 978-1-492-08100-5
US $59.99 CAN $79.99
Twitter: @oreillymedia
facebook.com/oreilly
While Excel remains ubiquitous in the business world,
recent Microsoft feedback forums are full of requests to
include Python as an Excel scripting language. In fact, it’s
the top feature requested. What makes this combination so
compelling? In this hands-on guide, Felix Zumstein—creator
of xlwings, a popular open source package for automating
Excel with Python—shows experienced Excel users how to
integrate these two worlds efficiently.
Excel has added quite a few new capabilities over the past
couple of years, but its automation language, VBA, stopped
evolving a long time ago. Many Excel power users have
already adopted Python for daily automation tasks. This
guide gets you started.
• Use Python without extensive programming knowledge
• Get started with modern tools, including Jupyter notebooks
and Visual Studio Code
• Use pandas to acquire, clean, and analyze data and replace
typical Excel calculations
• Automate tedious tasks like consolidation of Excel
workbooks and production of Excel reports
• Use xlwings to build interactive Excel tools that use Python
as a calculation engine
• Connect Excel to databases and CSV les and fetch data
from the internet using Python code
• Use Python as a single tool to replace VBA, Power Query,
and Power Pivot
Felix Zumstein is creator and
maintainer of xlwings, a popular
open source package that allows the
automation of Excel with Python on
Windows and macOS. As CEO of xltrail,
a version control system for Excel les,
he’s gained deep insight into the typical
use cases and issues with Excel across
various industries.
Python for ExcelPython for Excel
Praise for Python for Excel
What can Python do for Excel? If you’ve ever dealt with unexpected workbook crashes,
broken calculations, and tedious manual processes, you’ll want to find out. Python for
Excel is a comprehensive and succinct overview to getting started with Python as a
spreadsheet user, and building powerful data products using both. Don’t let the fear of
learning to code keep you away: Felix provides an exceptional foundation for learning
Python that even experienced programmers could benefit from. Moreover, he frames this
information in a way that is quickly accessible and applicable to you as an Excel user. You
can quickly tell reading this book that it was written by someone with years of experience
teaching and working with clients on how to use Excel to its fullest extent with the help of
Python programming. Felix is uniquely suited to show you the possibilities of learning
Python for Excel; I hope you enjoy the master class as much as I did.
—George Mount, Founder, Stringfest Analytics
Python is the natural progression from Excel and it’s tempting to simply discard Excel
all together. Tempting, but hardly realistic. Excel is here, and here to stay, both in the
corporate world and as a useful desktop tool at home and in the office. This book
provides the much needed bridge between these two worlds. It explains how you can
integrate Python into Excel and free yourself from the inevitable disaster of huge
workbooks, thousands of formulas, and ugly VBA hacks. Python for Excel is probably
the single most useful book on Excel that I have read and an absolute must-read for
any advanced Excel user. A highly recommended book!
—Andreas F. Clenow, CIO Acies Asset Management and author
of international best-sellers Following the Trend, Stocks on the Move,
and Trading Evolved
Excel remains a cornerstone tool of the financial world, but a vast amount of these Excel
applications are an irresponsible mess. This book does an excellent job of showing you
how to build better, more robust applications with the help of xlwings.
—Werner Brönnimann, Derivatives and DeFi practitioner
and cofounder, Ubinetic AG
Excel and Python are two of the most important tools in the Business Analytics toolbox,
and together they are far greater than the sum of their parts. In this book, Felix Zumstein
lays out his unparalleled mastery of the many ways to connect Python and Excel using
open source, cross-platform solutions. It will be an invaluable tool for business analysts
and data scientists alike, and any Python user looking to harness the
power of Excel in their code.
—Daniel Guetta, Associate Professor of Professional Practice and
Director of the Business Analytics Initiative at Columbia
Business School and coauthor of Python for MBAs
Felix Zumstein
Python for Excel
A Modern Environment for Automation
and Data Analysis
Boston Farnham Sebastopol
Tokyo
Beijing Boston Farnham Sebastopol
Tokyo
Beijing
剩余337页未读,继续阅读
garyjohnson
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 京瓷TASKalfa系列维修手册:安全与操作指南
- 小波变换在视频压缩中的应用
- Microsoft OfficeXP详解:WordXP、ExcelXP和PowerPointXP
- 雀巢在线媒介投放策划:门户网站与广告效果分析
- 用友NC-V56供应链功能升级详解(84页)
- 计算机病毒与防御策略探索
- 企业网NAT技术实践:2022年部署互联网出口策略
- 软件测试面试必备:概念、原则与常见问题解析
- 2022年Windows IIS服务器内外网配置详解与Serv-U FTP服务器安装
- 中国联通:企业级ICT转型与创新实践
- C#图形图像编程深入解析:GDI+与多媒体应用
- Xilinx AXI Interconnect v2.1用户指南
- DIY编程电缆全攻略:接口类型与自制指南
- 电脑维护与硬盘数据恢复指南
- 计算机网络技术专业剖析:人才培养与改革
- 量化多因子指数增强策略:微观视角的实证分析
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功