python-for-excel-1st-edition.zip

上传者: xcntime | 上传时间: 2021-04-08 09:07:57 | 文件大小: 16.85MB | 文件类型: 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}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明