Python for excel : A modern environment for automation and data analysis

By:

Zumstein, Felix

Language: ENG Publication details: Mumbai Shroff Publisher & Distributors 2021Edition: 1stDescription: xviii, 316p. | Binding - Paperback | 23*18 cmISBN:

9788194722915

Subject(s):

Data Science

DDC classification:

DDC23 005.54 ZUM

Online resources:

Table of Content

Summary: All Indian Reprints of O'Reilly are printed in Grayscale 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

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Collection	Call number	Status	Barcode
Books	School of Engineering & Technology Reference Section	Reference	005.54 ZUM (Browse shelf(Opens below))	Not For Loan	E15831

Total holds: 0

Browsing School of Engineering & Technology shelves, Shelving location: Reference Section, Collection: Reference Close shelf browser (Hides shelf browser)

Previous							No cover image available	Next
Previous	005.4376 RIV Windows 7 Secrets	005.45 MAR Clean coder	005.453 AHO/LAM Compilers principles, techniques and tools	005.54 ZUM Python for excel	005.7 NG Numsense! Data science for the layman	005.72 DRO Data structure and algorithm in C++	005.73 ARP Magnifying Data Structures	Next

All Indian Reprints of O'Reilly are printed in Grayscale

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

There are no comments on this title.

to post a comment.

Click on an image to view it in the image viewer