Torrent details for "Python for Excel - A Modern Environment for Automation and Data Analysis (True PDF)"    Log in to bookmark

Torrent details
Cover
Download
Torrent rating (1 rated)
Controls:
Category:
Language:
English English
Total Size:
9.08 MB
Info Hash:
16ba2134833f15389640399984f9d018daa3d23d
Added By:
Added:  
27-04-2021 06:29
Views:
487
Health:
Seeds:
2
Leechers:
0
Completed:
10



Thanks for rating :
p751:_male: (5),


Description
Image error
Python for Excel - A Modern Environment for Automation and Data Analysis (True PDF)

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

Quote:

BooksHash always

  User comments    Sort newest first

No comments have been posted yet.



Post anonymous comment
  • Comments need intelligible text (not only emojis or meaningless drivel).
  • No upload requests, visit the forum or message the uploader for this.
  • Use common sense and try to stay on topic.

  • :) :( :D :P :-) B) 8o :? 8) ;) :-* :-( :| O:-D Party Pirates Yuk Facepalm :-@ :o) Pacman Shit Alien eyes Ass Warn Help Bad Love Joystick Boom Eggplant Floppy TV Ghost Note Msg


    CAPTCHA Image 

    Anonymous comments have a moderation delay and show up after 15 minutes