|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/automate-excel-using-python-xlwings-series-1/
课程评论：没有评论
Coursera 课程：使用 Python 自动化 Excel - xlwings 系列 1 本课程旨在教授如何利用 Python 编程语言自动化处理 Excel 中的行业级数据集。Excel 作为强大的记录工具，其默认的宏语言 VBA 已显陈旧。而 Python 作为数据分析领域的佼佼者，拥有众多简化工作的库。 课程重点介绍 **xlwings** 库，该库能够连接 Excel 与 Python 宏。此外，还将学习 **Pandas** 库，用于将数据转换为表格格式，并进行自定义的行/列筛选，以实现复杂的数据分析。**Matplotlib** 和 **Plotly** 等库则可用于创建各种图表（如折线图、散点图、热力图），以发现不同参数间的相关性。 本系列课程选取了两个来自工业生产线的实际案例，并创建了相应的 Python 宏，以达到以下目的： * **缩短分析时间** * **通过 Python 库实现定制化** * **减少 VBA 代码库中的宏代码行数** * **创建自定义的 Python 函数用户模块** Instructor 也有提供系列 2 的课程。
This course teaches how to automate Industry-level datasets maintained in Excel sheets using Python programming language.MS Excel is a very helpful tool for record-keeping. But the language that comes by default for macro is VBA, which is dated. And in the field of Data Analysis, Python has a lot of interesting packages which makes a job easy. Package like xlwings links any Excel with Python macros. Packages like Pandas, takes data into tabular format and also has customized filtering of rows or columns for complex data analysis. Packages like Matplotlib, Plotly enables to create different plots - line plot, Scatter plot, Heat map for finding the correlation b/w different parameters. In the Series, 2 Case studies has been picked from Industry process line. And correspondingly, Python macros are created to:reduce time in analysisenable customization using python packagesreduce macros code lines in VBA codebase.create customized User-defined modules by python functions.The Series-2 is also available now in the Instructor's profile.
