[Online Training] Python数据自动化处理线上训练营 Data Automatic Processing Tips with Python

Python线上训练营将帮您解决以下难题

1. 重复性工作占据了大部分时间

每天进行大量重复性的基础工作，成百上千的文件整理占据了大部分的工作时间，每天都有庞大数据的分析要求，整理大量的工作表格，工作繁多常常加班。Python可以帮助你，需要整理两天的数据，使用Python几分钟就能完成。

2. 需要用Python提升工作效率

Python可以帮你快速进行文件的创建、搜索及查询操作，处理Excel文件的相关模块介绍安装，编程生成Excel内图表和报表，读取、自动发送邮件，自动进行文本分析。让你在职场中“快人一步”。

3. 需要提升自己的核心竞争力

Python可以帮助您进一步提高工作效率，获得职场核心竞争力。

This online training camp will help you solve the following problems

1. Repetitive work takes up most of the time

Python can help you if a lot of repetitive basic work is carried out every day. The large number of work can be done in a few minutes using python.

2. Python is needed to improve work efficiency

Python can help you quickly create, search and query files, process the relevant modules of Excel files, introduce the installation, program to generate excel charts and reports, read and automatically send e-mails and conduct text analysis.

3. Need to improve their core competitiveness

Python can improve your work efficiency and get the core competitiveness of the workplace.

课程安排及授课方式

11月2日开营，讲师及助教陪伴式学习。

1. 工作日–录播课程自主学习

每周2~5节录播课程自学任务，微信小程序（pc端、移动端均支持），有效期内可以随时观看，反复学习。

2. 周末晚–直播课辅导提升

每周一次线上直播辅导，时长为1.5h，讲师梳理周学习重点、答疑讲解作业等。

3. 时时学习群答疑互动

微信群任务发布和答疑互动，讲师定时统计问题并给出专业解答。

Training arrangement

This training camp will start on November 12th. The training camp will last for nine weeks. The instructors and teaching assistants will study together for nine weeks.

1. Working day – self learning of video course

There are 2-5 self-study tasks of recording and broadcasting courses every week, and WeChat small programs (both PC and mobile terminals support) can be watched at any time and learned repeatedly within the validity period.

2. Weekend evening – QA & improvement by Zoom meeting

Once a week, 1.5h online meeting. The lecturer sorts out the weekly learning key points, and explains exercise.

3. Learning group – QA interaction

We will have WeChat group to asign tasks and Q & A interaction, lecturers will give professional answers.

课程课表时间

第一周Python的介绍以及基础语法的使用

Python产生的背景和应用场景

Python下载安装登陆

Python第一个程序的开发

Python基础语法的使用（使用变量、数字变量、字符串变量…）

直播：关于Python前期互动辅导答疑

第二周 不同的数据类型和数据结构

如何在Python中使用不同的数据类型和结构

了解数据类型和数据结构

怎么样格式化输出内容

直播：Python变量的分析+案例+答疑

第三周 组织一段Python程序

函数的基本使用

函数的属性和细节

实操：简单的设计模式

直播：函数的应用动手实战+案例+答疑

第四周 Python中的对象

类、接口的基本知识

深入理解Python中的对象（字典类、类与封装的技巧）

直播：案例+答疑

第五周 高级Python应用技巧

了解Generators对象迭代协议

自定义迭代与生成器

生产者与消费者模式生成表达式

高级Python应用技巧

直播：实操+案例+答疑

第六周 测试、日志和调试技巧

程序测试、程序日志和错误诊断

程序调试

程序打包技术及发布自己的代码

直播：互动辅导直播

第七周 文件自动化处理

os模块的简介

文件的创建、搜索及查询操作

读取、创建、解压压缩包

直播：互动辅导直播

第八周 Excel自动化处理

处理Excel文件的相关模块介绍及安装

打开读取并写入Excel表格内容

编程生成Excel内图表

直播：课程案例《职员的薪水明细》+互动辅导

第九周 邮件自动化处理

模块介绍与安装

利用Python发送读取邮件

直播：互动辅导直播&结营仪式

Learning task arrangement

Week I: Python introduction and the basic using points

The background and application scenarios of Python

Download, install, and login

The development of Python’s first program

Use of Python basic syntax (using variables, numeric variables, string variables…)

Live: answers to Python early interactive coaching

Week II: Different data types and data structures

How to use different data types and structures in Python

Understand data types and data structures

How to format output content

Live : analysis of Python variables + Case + QA

Week III Organize a python program

Basic use of functions

Properties and details of functions

Practical operation: simple design mode

Live : application of function practical combat + Case + QA

Week IV Objects in Python

Basic knowledge of class and interface

Objects in python (Dictionary classes, classes, and encapsulation techniques)

Live: Case + QA

Week V Advanced Python application skills

Understand the generators object iteration protocol

Customized iteration and generator

Producer and consumer pattern generation expression

Advanced Python application skills

Live : practice + Case + QA

Week VI testing, logging and debugging skills

Program testing, program logging, and troubleshooting

Program debugging

Program packaging technology and release your own code

Live: practice + Case + QA

Week VII Automatic document processing

Brief introduction of OS module

File creation, search and query operation

Read, create and decompress compressed package

Live: Online review & QA

Week VIII Excel automatic processing

Introduction and installation of relevant modules for processing Excel files

Open, read and write the contents of the excel table

Generating excel internal chart by programming

Live: course case “staff salary details” + interactive QA

Week VIIII Automated mail processing

Module introduction and installation

Using Python to send and read mail

Live : QA & ceremony

讲师：苏鹏

熟练掌握Python语言与数据处理技术

5年以上Python数据处理经验

10年以上专业培训师

多年获得微软最有价值专家

Lecturer: Su Peng

Proficient in Python language and data processing technology

More than 5 years Python data processing experience

More than 10 years of professional trainer experience

Microsoft’s most valuable expert

价格 Price:

会员价 Member Price: RMB 2,400 / guest

非会员价 Non-member Price: RMB 2,680 / guest

即刻报名 Registration 

请于2022年10月28日前写邮件联系 Cherry Huang (events@sha.swisscham.org) 登记报名。

To register, please write an email to Cherry Huang (events@sha.swisscham.org) before October 28, 2022.