使用Python实现Excel报表自动化

学习构建端到端脚本，将数据转化为方便的excel报表，欢迎学习使用Python的Excel报表自动化课程！本课程是在一些基础的金融和货币课程完成后的一个更高级的课程。在本课程中，您将确切了解如何构建脚本来自动将数据解析为excel报表。开始之前，请通过github下载课程文件。如果你想继续看下去，笔记本也在那里。Excel Report Automation with Python

在整个课程中，你将参与一个真实的项目，自动生成一份关于房地产和金融市场的经济报告。这个项目将让你亲身体验课程中涵盖的所有概念和工具，并帮助你更好地理解如何在实践中应用它们。& nbsp这种技能可以应用于许多行业，尤其是金融业。本课程结束时，您将对如何使用Python自动生成Excel报表有深刻的理解，并能够将这些知识应用到您自己的项目和工作流程中。因此，让我们开始使用Python深入Excel报表自动化的世界吧！你会对你能建造的东西感到惊讶！

由Sean McOwen创作
MP4 |视频:h264，1280×720 |音频:AAC，44.1 KHz，2声道
类型:电子学习|语言:英语|时长:19节课(1小时26分钟)|大小:753 MB

你会学到什么
使用Python以编程方式操作Excel数据:过滤、排序、汇总、选择单元格/范围
在准备报告时自动管理经济数据
为灵活的输入范围创建便于自动构建漂亮的excel报表的脚本
应用python的最佳设计实践，包括使用类型提示、错误检查等等

要求
Python的基础-中级经验
与熊猫相处的基础-中级经验
不需要excel知识

这门课程是给谁的
寻求工作流程自动化的业务分析师
定量分析师试图从他们的模型中构建报告
希望能够构建excel报表的爱好者

Learn to build end to end scripts for turning data into convenient excel reports

What you’ll learn
Manipulate Excel data programmatically with Python: filter, sort, summarize, select cells/ranges
Automate the curation of economic data in preparation of reporting
Create scripts that facilitate automatic building of beautiful excel reports for a flexible range of inputs
Apply best design practices for python including using type hints, error checking, and more

Requirements
Basic-Intermediate Experience with Python
Basic-Intermediate Experience with Pandas
No excel knowledge necessary

Description
Welcome to the Excel Report Automation with Python course! This course is meant to be a more advanced course taken after some of the basic FinanceAndPython courses are complete. Within this course, you will learn exactly how to build scripts to automatically parse data into excel reports. Before beginning, please down the course files through github. The notebooks are also there as well if you want to follow along through them.Throughout the course, you will work on a real world project of producing an economic report on the real estate and treasury markets automatically. This project will give you hands-on experience with all the concepts and tools covered in the course, and help you develop a better understanding of how to apply them in practice. There are many industries with which this kind of skill can be applied, but especially so in the world of finance.By the end of this course, you will have a strong understanding of how to automate Excel report generation with Python, and be able to apply this knowledge to your own projects and workflows. So let’s get started and dive into the world of Excel report automation with Python! You’ll be amazed at what you can build!

Who this course is for
Business Analysts looking to automate their workflow
Quants trying to build reports from their models
Hobbyists who want to be able to build excel reports