没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
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币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- STM32单片机FPGA毕设电路原理论文报告汽车电动助力转向单片机控制系统设计与试验研究
- STM32单片机FPGA毕设电路原理论文报告气压传感器神经网络算法及单片机实现
- STM32单片机FPGA毕设电路原理论文报告频率的测量在单片机设计中的应用
- 音频转码工具(用于将微信语音 amr 格式转换为 mp3 格式以便在 html5 的 audio 标签中进行播放).zip
- RDK-Web-Performance-Node
- STM32单片机FPGA毕设电路原理论文报告片式电容器浪涌及老化测试系统的设计与实现
- 一个简易的贪吃蛇小游戏(C语言作业).zip
- 国家游戏防沉迷系统接口(php)
- STM32单片机FPGA毕设电路原理论文报告片剂硬度测试仪的液晶显示界面设计
- STM32单片机FPGA毕设电路原理论文报告偏磁式消弧线圈的动态调谐装置
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功