|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-automation-series/
课程评论：没有评论
Coursera Python自动化系列课程概览： 本课程旨在教授学员如何利用Python进行数据自动化处理。完成课程后，您将能够： * **Excel数据操作：** * 读取Excel文件中的数据。 * 向Excel文件写入数据。 * 读取Excel的特定工作表。 * 读取Excel的特定单元格。 * 将数据写入Excel。 * **Pandas Dataframe运用：** * 掌握Dataframe的基本操作。 * 学习如何过滤和选择特定的行与列。 * **SQL Server数据库连接与数据加载：** * 实现Python与SQL Server数据库的连接。 * 将数据加载到SQL Server数据库中。 通过本课程的学习，您将具备强大的Excel数据读写能力，熟练运用Pandas进行数据处理，并能与SQL Server数据库进行交互，从而极大地提升数据处理的效率和自动化水平。
After completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well. We have covered all the below things.Read Data from ExcelWrite Data from ExcelRead Specific sheetRead specific cellWrite dataSql ConnectivityLoad Data in sql serverAfter completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well. We have covered all the below things.Read Data from ExcelWrite Data from ExcelRead Specific sheetRead specific cellWrite dataSql ConnectivityLoad Data in sql serverAfter completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well. We have covered all the below things.Read Data from ExcelWrite Data from ExcelRead Specific sheetRead specific cellWrite dataSql ConnectivityLoad Data in sql serverAfter completing this course, one can able to read/write data from excel and also able to learn playing with Dataframe like Filtering/selecting specific rows and Columns. As a part of this course we have also included how to do connectivity with sql server and load data as well. We have covered all the below things.Read Data from ExcelWrite Data from ExcelRead Specific sheetRead specific cellWrite dataSql ConnectivityLoad Data in sql server
