Books > Computing & IT > Computer programming > Programming languages
|
Buy Now
Python for Excel - A Modern Environment for Automation and Data Analysis (Paperback)
Loot Price: R1,061
Discovery Miles 10 610
You Save: R176
(14%)
|
|
Python for Excel - A Modern Environment for Automation and Data Analysis (Paperback)
Expected to ship within 12 - 17 working days
|
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 files and fetch data from
the internet using Python code Use Python as a single tool to
replace VBA, Power Query, and Power Pivot
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.