|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-to-python-hands-on-guide/
课程评论：没有评论
课程名称：从Excel跃迁至Python：实用指南 概述：该课程包括大量动手编码的笔记本，通过实践性练习，教你如何将Excel知识应用于Python。几年前，我也曾面临同样的挑战，学习Python时常会回到Excel中，因为我对它更为熟悉。我的目标是帮助你在Python中感到和在Excel中一样舒适。为了做到这一点，你需要有机会参与动手练习和项目。你将在本课程中获得这两种机会。本课程旨在帮助希望通过Python提升职业发展或分析技能的学生。 课程内容包括： - 如何使用Google Colab开始使用Python而无需安装软件 - 如何使用Python包和函数 - 如何从Python中导入和导出数据 - 如何执行基本任务如数据清理 - 如何通过创建可重复执行的脚本来节省时间 - 如何使用笔记本创建文档完善的分析 - 如何在Python中复制许多Excel功能，包括： - 数据透视表 - VLOOKUP - 图表 - 单元格公式如SUM( ), IF( ) 和 CONCATENATE( ) - 行过滤 - 文本拆分等 课程分为三部分。第一部分是课程介绍及Python和pandas的基本概念概述。第二部分提供灵活的学习顺序。如果你需要学习如何在Python中构建数据透视表，可以直接跳到相关课程；想在Python中创建图表也可以直接开始。第三部分将共同进行一个真实数据的分析项目，你将应用所学知识构建自己的项目。 此外，本课程还提供30天100%无条件退款保证。如果对课程不满意，可以随时申请退款。 快来报名，迈出从Excel到Python的第一步吧！- Cory
****INCLUDES DOZENS OF HANDS-ON CODING NOTEBOOKS****This course will use hands-on exercises to teach you how to apply your Excel knowledge in Python.Several years ago, I was in your shoes. I tried learning Python but would go back to do things in Excel because I was more comfortable with it. My goal in this course is to help you become as comfortable in Python as you are in Excel. To become comfortable, you need to have opportunities to participate in hands-on exercises and projects. You will have the chance to do both in this course.This course is designed for students who want to grow their careers or improve their analysis by using Python. What will you learn:How to use Google Colab to begin using Python without installing softwareHow to use Python packages and functionsHow to import and export data from PythonHow to perform basic tasks like data cleaningHow Python can save time by creating scripts which can be re-run easilyHow notebooks can be used to create well-documented analysis How to replicate many Excel featuresExcel features we will replicate in Python:Pivot tablesVLOOKUPChartsCell formulas like SUM( ), IF( ) and CONCATENATE( )Filtering rowsPerforming text to columns splits and more!ContentThis course is divided into three parts. The first part is the introduction to the course and an overview of the essential concepts you need to know to use Python and pandas. In part 2, you will have the flexibility to take the lessons in whatever order best suits your needs. If you need to learn how to build a pivot table in Python, you can skip straight to that lesson. Want to build charts in python… you can start there instead.In part 3 we will work on an analytics project using real-world data together. You will then apply everything you have learned to build your own project.The course also has a 30-day 100% money-back guarantee. If you aren't happy with your purchase, you can refund the course with no questions asked.Enroll now to make the leap from Excel to Python!- Cory
