This is a past event. Registration is closed. View other AmCham Shanghai events.
Save the date
Save the dateApril 14, 202310:00 AM - 4:00 PMGMT+8 Add to Calendar
Venue Location
Venue Location

Online

Shanghai, China

Show on map
Organizer
Organizer
Organizer:
Contact Person: Ray Cheng
Home
Home

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.


课程安排及授课方式


2023年2月15日开营,讲师及助教陪伴式学习。


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


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


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


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


3. 时时学习群答疑互动


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


Training arrangement


This training camp will start on 15th Feb 2023. 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 assign tasks and Q & A interaction, lecturers will give professional answers.

Session Outline
Session Outline

课程课表时间


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


Python产生的背景和应用场景

Python下载安装登陆

Python第一个程序的开发

Python基础语法的使用(使用变量、数字变量、字符串变量...)

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

 

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


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

了解数据类型和数据结构

怎么样格式化输出内容

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

 

第三周 组织一段Python程序


函数的基本使用

函数的属性和细节

实操:简单的设计模式

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

 

第四周 Python中的对象


类、接口的基本知识

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

直播:案例+答疑

 

第五周 高级Python应用技巧


了解Generators对象迭代协议

自定义迭代与生成器

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

高级Python应用技巧

直播:实操+案例+答疑

 

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


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

程序调试

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

直播:互动辅导直播

 

第七周 文件自动化处理


os模块的简介

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

读取、创建、解压压缩包

直播:互动辅导直播

 

第八周 Excel自动化处理


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

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

编程生成Excel内图表

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

 

第九周 邮件自动化处理


模块介绍与安装

利用Python发送读取邮件

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

Learning task arrangements


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

Speakers
Speakers
  • 苏鹏

    苏鹏

Documents
Tickets
Tickets

Please use your own name and email when registering for a training session. Additional fees may apply if you fail to register under your own identity. 



Member Ticket

Member Price RMB 2,400

Member & Member Company Employee Ticket

RMB 2,400

Non-member Ticket

RMB 2,680
Registration
Registration
  • All registrations shall be made online before the session. Payment also shall be made before the session.
  • AmCham Shanghai members are eligible to attend at "Member Rate"; Employees who work at AmCham Shanghai member companies are eligible to attend at "Employee Rate"; Non-members are eligible to attend at "Non-Member Rate".
Cancellation Policy
  • Cancellation: If you need to cancel your registration, please notify Ray Cheng at (86 21) 6169 3015 or email ray.cheng@amcham-shanghai.org at least two weeks prior to the session for a full refund. Cancellation made within two weeks before the session will not be refundable.
Sponsors and Partners
Sponsors and Partners