Python for Exce :A Modern Environment for Automation and Data Analysis（Early_Re

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

Author: Felix Zumstein

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
  

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏5 回帖

关键词：environment Automation Analysis Analysi Analys

谢谢分享

boochxu 发表于 2022-5-16 10:21
Author: Felix ZumsteinWhile Excel remains ubiquitous in the business world, recent Microsoft feedbac ...

谢谢老板的分享

感谢分享

感谢分享，要花点时间学习下了

boochxu 发表于 2022-5-16 10:21
Author: Felix ZumsteinWhile Excel remains ubiquitous in the business world, recent Microsoft feedbac ...

谢谢分享

感谢分享，要花点时间学习下了

感谢分享

感谢分享