Cargando…

Python for Excel /

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 xlwi...

Descripción completa

Detalles Bibliográficos
Autor principal: Zumstein, Felix (Autor)
Autor Corporativo: Safari, an O'Reilly Media Company
Formato: Electrónico eBook
Idioma:Inglés
Publicado: O'Reilly Media, Inc., 2021.
Edición:1st edition.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a22000007a 4500
001 OR_on1179006435
003 OCoLC
005 20231017213018.0
006 m o d
007 cr cnu||||||||
008 200729s2021 xx o 000 0 eng
040 |a AU@  |b eng  |c AU@  |d OCLCQ  |d TOH  |d OCLCQ 
020 |z 9781492081005 
024 8 |a 9781492080992 
029 0 |a AU@  |b 000067556334 
029 1 |a AU@  |b 000069670394 
035 |a (OCoLC)1179006435 
082 0 4 |a 005.54  |q OCoLC  |2 23/eng/20230216 
049 |a UAMI 
100 1 |a Zumstein, Felix,  |e author. 
245 1 0 |a Python for Excel /  |c Zumstein, Felix. 
250 |a 1st edition. 
264 1 |b O'Reilly Media, Inc.,  |c 2021. 
300 |a 1 online resource (200 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file 
520 |a 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 that allows the automation of 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 their daily automation tasks. This guide gets you started. Use Python without previous programming knowledge Get started with modern tools, including Jupyter notebooks and Visual Studio 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 to fetch data from the internet using Python code Write unit tests in Python to build solid spreadsheets. 
542 |f Copyright © O'Reilly Media, Inc. 
550 |a Made available through: Safari, an O'Reilly Media Company. 
588 |a Online resource; Title from title page (viewed July 25, 2021) 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
710 2 |a Safari, an O'Reilly Media Company. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781492080992/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
936 |a BATCHLOAD 
994 |a 92  |b IZTAP