python-for-excel-1st-edition.zip
Python for Excel–The Book
A Modern Environment for Automation and Data Analysis
https://www.xlwings.org/book
You’ll find the Jupyter notebooks, Python scripts, and other example files here: https://github.com/fzumstein/python-for-excel
Table of Contents
The book has 316 pages and is split into 4 parts and 12 chapters:
I. Introduction to Python
1 Why Python for Excel?
2 Development Environment
3 Getting Started with Python
II. Introduction to pandas
4 NumPy Foundations
5 Data Analysis with pandas
6 Time Series Analysis with pandas
III. Reading and Writing Excel Files without Excel
7 Excel File Manipulation with pandas
8 Excel File Manipulation with Reader and Writer Packages
IV. Programming the Excel Application with xlwings
9 Excel Automation
10 Python-Powered Excel Tools
11 The Python Package Tracker
12 User-Defined Functions (UDFs)
文件下载
资源详情
[{"title":"（ 87 个子文件 16.85MB ） python-for-excel-1st-edition.zip","children":[{"title":"python-for-excel-1st-edition","children":[{"title":"ch09.ipynb <span style='color:#111;'> 17.49KB </span>","children":null,"spread":false},{"title":"sales_report_xlwings.py <span style='color:#111;'> 1.50KB </span>","children":null,"spread":false},{"title":".gitignore <span style='color:#111;'> 44B </span>","children":null,"spread":false},{"title":"pep8_sample.py <span style='color:#111;'> 794B </span>","children":null,"spread":false},{"title":"sales_report_xlsxwriter.py <span style='color:#111;'> 3.66KB </span>","children":null,"spread":false},{"title":"ch08.ipynb <span style='color:#111;'> 27.39KB </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 520B </span>","children":null,"spread":false},{"title":"parallel_openpyxl.py <span style='color:#111;'> 1.16KB </span>","children":null,"spread":false},{"title":"parallel_xlrd.py <span style='color:#111;'> 1.05KB </span>","children":null,"spread":false},{"title":"temperature.py <span style='color:#111;'> 368B </span>","children":null,"spread":false},{"title":"ch03.ipynb <span style='color:#111;'> 24.91KB </span>","children":null,"spread":false},{"title":"ch05.ipynb <span style='color:#111;'> 23.69KB </span>","children":null,"spread":false},{"title":"sales_report_openpyxl.py <span style='color:#111;'> 4.09KB </span>","children":null,"spread":false},{"title":"LICENSE <span style='color:#111;'> 1.05KB </span>","children":null,"spread":false},{"title":"ch06.ipynb <span style='color:#111;'> 9.66KB </span>","children":null,"spread":false},{"title":"appendixC.ipynb <span style='color:#111;'> 9.69KB </span>","children":null,"spread":false},{"title":"csv","children":[{"title":"AAPL.csv <span style='color:#111;'> 657.54KB </span>","children":null,"spread":false},{"title":"MSFT.csv <span style='color:#111;'> 579.17KB </span>","children":null,"spread":false},{"title":"GOOGL.csv <span style='color:#111;'> 290.29KB </span>","children":null,"spread":false},{"title":"AMZN.csv <span style='color:#111;'> 406.41KB </span>","children":null,"spread":false}],"spread":false},{"title":"xl","children":[{"title":"currency_converter.xlsx <span style='color:#111;'> 9.40KB </span>","children":null,"spread":false},{"title":"array_calculations.xlsx <span style='color:#111;'> 10.90KB </span>","children":null,"spread":false},{"title":"sales_report_template.xlsx <span style='color:#111;'> 11.70KB </span>","children":null,"spread":false},{"title":"stores.xlsb <span style='color:#111;'> 11.10KB </span>","children":null,"spread":false},{"title":"course_participants.xlsx <span style='color:#111;'> 9.88KB </span>","children":null,"spread":false},{"title":"vbaProject.bin <span style='color:#111;'> 15.00KB </span>","children":null,"spread":false},{"title":"macro.xlsm <span style='color:#111;'> 15.65KB </span>","children":null,"spread":false},{"title":"vba.xlsm <span style='color:#111;'> 12.76KB </span>","children":null,"spread":false},{"title":"big.xlsx <span style='color:#111;'> 19.64MB </span>","children":null,"spread":false},{"title":"stores.xlsx <span style='color:#111;'> 11.54KB </span>","children":null,"spread":false},{"title":"stores.xls <span style='color:#111;'> 30.00KB </span>","children":null,"spread":false}],"spread":false},{"title":"conda","children":[{"title":"xl38.yml <span style='color:#111;'> 429B </span>","children":null,"spread":false}],"spread":false},{"title":"udfs","children":[{"title":"importsub","children":[{"title":"importsub.xlsm <span style='color:#111;'> 14.66KB </span>","children":null,"spread":false},{"title":"importsub.py <span style='color:#111;'> 382B </span>","children":null,"spread":false}],"spread":false},{"title":"describe","children":[{"title":"describe.py <span style='color:#111;'> 148B </span>","children":null,"spread":false},{"title":"describe.xlsm <span style='color:#111;'> 26.29KB </span>","children":null,"spread":false}],"spread":false},{"title":"revenues","children":[{"title":"revenues.xlsm <span style='color:#111;'> 18.82KB </span>","children":null,"spread":false},{"title":"revenues.py <span style='color:#111;'> 271B </span>","children":null,"spread":false}],"spread":false},{"title":"google_trends_cache","children":[{"title":"google_trends_cache.xlsm <span style='color:#111;'> 17.84KB </span>","children":null,"spread":false},{"title":"google_trends_cache.py <span style='color:#111;'> 1.75KB </span>","children":null,"spread":false}],"spread":false},{"title":"google_trends","children":[{"title":"google_trends.xlsm <span style='color:#111;'> 18.83KB </span>","children":null,"spread":false},{"title":"google_trends.py <span style='color:#111;'> 1.67KB </span>","children":null,"spread":false}],"spread":false},{"title":"raw_values","children":[{"title":"raw_values.xlsm <span style='color:#111;'> 17.91KB </span>","children":null,"spread":false},{"title":"raw_values.py <span style='color:#111;'> 265B </span>","children":null,"spread":false}],"spread":false},{"title":"first_udf","children":[{"title":"first_udf.py <span style='color:#111;'> 374B </span>","children":null,"spread":false},{"title":"first_udf.xlsm <span style='color:#111;'> 14.53KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"ch11.ipynb <span style='color:#111;'> 11.42KB </span>","children":null,"spread":false},{"title":"requirements.txt <span style='color:#111;'> 768B </span>","children":null,"spread":false},{"title":"excel.py <span style='color:#111;'> 9.87KB </span>","children":null,"spread":false},{"title":"debugging.py <span style='color:#111;'> 32B </span>","children":null,"spread":false},{"title":"parallel_pandas.py <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"ch04.ipynb <span style='color:#111;'> 5.70KB </span>","children":null,"spread":false},{"title":"images","children":[{"title":"python.bmp <span style='color:#111;'> 50.52KB </span>","children":null,"spread":false},{"title":"cover.png <span style='color:#111;'> 99.66KB </span>","children":null,"spread":false},{"title":"python.png <span style='color:#111;'> 10.60KB </span>","children":null,"spread":false}],"spread":false},{"title":"ch02.ipynb <span style='color:#111;'> 1.36KB </span>","children":null,"spread":false},{"title":"sales_report_pandas.py <span style='color:#111;'> 930B </span>","children":null,"spread":false},{"title":"ch07.ipynb <span style='color:#111;'> 6.11KB </span>","children":null,"spread":false},{"title":"packagetracker","children":[{"title":"packagetracker.py <span style='color:#111;'> 6.41KB </span>","children":null,"spread":false},{"title":"packagetracker.xlsm <span style='color:#111;'> 20.61KB </span>","children":null,"spread":false},{"title":"database.py <span style='color:#111;'> 3.21KB </span>","children":null,"spread":false},{"title":"packagetracker.db <span style='color:#111;'> 20.00KB </span>","children":null,"spread":false}],"spread":false},{"title":"ch12.ipynb <span style='color:#111;'> 3.16KB </span>","children":null,"spread":false},{"title":"sales_data","children":[{"title":"new","children":[{"title":"December.xlsx <span style='color:#111;'> 287.87KB </span>","children":null,"spread":false},{"title":"March.xlsx <span style='color:#111;'> 294.89KB </span>","children":null,"spread":false},{"title":"February.xlsx <span style='color:#111;'> 330.64KB </span>","children":null,"spread":false},{"title":"May.xlsx <span style='color:#111;'> 283.13KB </span>","children":null,"spread":false},{"title":"January.xlsx <span style='color:#111;'> 368.47KB </span>","children":null,"spread":false},{"title":"November.xlsx <span style='color:#111;'> 341.71KB </span>","children":null,"spread":false},{"title":"September.xlsx <span style='color:#111;'> 287.53KB </span>","children":null,"spread":false},{"title":"August.xlsx <span style='color:#111;'> 328.09KB </span>","children":null,"spread":false},{"title":"October.xlsx <span style='color:#111;'> 226.08KB </span>","children":null,"spread":false},{"title":"June.xlsx <span style='color:#111;'> 333.70KB </span>","children":null,"spread":false},{"title":"July.xlsx <span style='color:#111;'> 280.61KB </span>","children":null,"spread":false},{"title":"April.xlsx <span style='color:#111;'> 290.84KB </span>","children":null,"spread":false}],"spread":false},{"title":"existing","children":[{"title":"September.xls <span style='color:#111;'> 678.50KB </span>","children":null,"spread":false},{"title":"November.xls <span style='color:#111;'> 626.00KB </span>","children":null,"spread":false},{"title":"August.xls <span style='color:#111;'> 666.50KB </span>","children":null,"spread":false},{"title":"July.xls <span style='color:#111;'> 662.50KB </span>","children":null,"spread":false},{"title":"June.xls <span style='color:#111;'> 602.00KB </span>","children":null,"spread":false},{"title":"January.xls <span style='color:#111;'> 582.00KB </span>","children":null,"spread":false},{"title":"May.xls <span style='color:#111;'> 586.00KB </span>","children":null,"spread":false},{"title":"December.xls <span style='color:#111;'> 682.50KB </span>","children":null,"spread":false},{"title":"April.xls <span style='color:#111;'> 614.00KB </span>","children":null,"spread":false},{"title":"October.xls <span style='color:#111;'> 650.50KB </span>","children":null,"spread":false},{"title":"March.xls <span style='color:#111;'> 654.50KB </span>","children":null,"spread":false},{"title":"February.xls <span style='color:#111;'> 666.50KB </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":true}]
评论信息
其他资源
- LISC Database.zip
- 三菱Q系列PLC---TCP通讯测试程序、socket
- 齿轮箱常见故障数据.zip
- tdms转txt文件——TDMSReader.exe（可直接安装使用）
- 经典java教程（入门到精通）PDF
- S变换-matlab程序
- JT808模拟上报数据.zip
- 爱迪尔门锁管理软件A90 V7.3网络版带接口破解版
- 温度湿度传感器DH11，stm32f103rct6
- alibaixiu.zip阿里百秀完整项目
- x230点位图
- C#操作word.doc
- linux下QT程序读写配置文件小程序
- 自媒体搞笑音效和段子素材
- MFCApplication1.7z
- 大数据私房菜_flink详解（2021）
- NEW770C升级包.zip
- QT/AES/SM4串口上位机调试工具
- GithubIP.txt
- PacketSender
- 无需入侵制作个人专属黑页-附带黑页源代码.
- C#网上书店系统
- 一个简单的基本的酒店管理系统
- AltiumDesignerSummer9Build9.4.0.20159 破解
- GoJS v1.5.0 JavaScript Library无水印
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明