[Online Training Camp] Python数据自动化处理线上训练营Data Automatic Processing Tips with Python(Chinese language) Go back »
-
Time2021-09-08 - 2021-11-10 | 20:00 - 21:00
-
Venue:Online training
-
Address:
-
Fee:Members: 2400 |
Non Members: 2680
Python线上训练营将帮您解决以下难题:
- 重复性工作占据了大部分时间: 每天进行大量重复性的基础工作,成百上千的文件整理占据了大部分的工作时间,每天都有庞大数据的分析要求,整理大量的工作表格,工作繁多常常加班。Python可以帮助你,需要整理两天的数据,使用Python几分钟就能完成。
- 需要用Python提升工作效率:Python可以帮你快速进行文件的创建、搜索及查询操作,处理Excel文件的相关模块介绍安装,编程生成Excel内图表和报表,读取、自动发送邮件,自动进行文本分析。让你在职场中“快人一步”。
- 需要提升自己的核心竞争力:Python可以帮助您进一步提高工作效率,获得职场核心竞争力。
This online training camp will help you solve the following problems:
- 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.
- 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.
- Need to improve their core competitiveness: Python can improve your work efficiency and get the core competitiveness of the workplace.
课程安排及授课方式:
- 9月8日开营,训练营为期九周,讲师及助教九周陪伴式学习。
- 工作日-录播课程自主学习:每周2~5节录播课程自学任务,微信小程序(pc端、移动端均支持),有效期内可以随时观看,反复学习。
- 周末晚-直播课辅导提升:每周一次线上直播辅导(共安排九次),时长为1.5h,讲师梳理周学习重点、答疑讲解作业等。
- 时时学习群答疑互动:微信群任务发布和答疑互动,讲师定时统计问题并给出专业解答。
Training arrangement:
- This training camp will start on 8th September. The training camp will last for nine weeks. The instructors and teaching assistants will study together for nine weeks.
- 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.
- 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.
- 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
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
非会员价2680;会员价2400;企业团报(5人以上)2180
for bank transfers, please contact Yang-zhaoyang@europeanchamber.com.cn for details
Cancellation Policy
If you cannot attend the training for which you have registered, please cancel your registration no later than one business day prior to the event. If you fail to notify us of your cancellation in a timely fashion, you will be charged for event costs.
To cancel you can: 1) email zhaoyang@europeanchamber.com.cn or 2) cancel online if you registered for the event through the website.
Speakers
Mr. Peng Su
![Mr. Peng Su](/upload/events/speakers/peng[3559].png?x-oss-process=image/resize,m_lfit,h_400,w_160/quality,q_100/sharpen,100)
Mr. Peng Su
熟练掌握Python语言与数据处理技术
5年以上Python数据处理经验
10年以上专业培训师
多年获得微软最有价值专家
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