Python for Excel 书的数据源文件及jupyter notebook的代码

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

使用PYTHON 及EXCEL 一起分析数据的经典书-Python for Excel: A ModernEnvironment for Automation and Data Analysis 的配套数据源及代码。 对初学者和中级使用者十分有用。本书的PDF （early release）我已在另一个贴子发出，有兴趣可搜搜下载。

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 收藏4 回帖

关键词：Notebook python EBook EXCEL note

boochxu 发表于 2022-5-26 08:53
使用PYTHON 及EXCEL 一起分析数据的经典书-Python for Excel: A ModernEnvironment for Automation and Dat ...

谢谢老板的分享

谢谢分享

超简单：用Python让Excel飞起来 王秀文2020

谢谢分享

感谢分享~~~~~~么么哒

谢谢分享