用一天时间详细讲解Python的基本语句、架构、函数和模块；如何应用Python操作文本文件、CSV文件、Excel文件等；Python技术在商业数据分析方面的应用；以及应用Matplotlib实现商业数据可视化，等等商业分析常用组件。
Python是商业分析人士不可或缺的必备技能，感兴趣的小伙伴不要错过哦！
上课时间：1月19日 周日 9:30 am - 4:30 pm
上课方式： 悉尼现场 & 全澳Online
上课地点：S201, 683 George St, Sydney NSW 2000
课程费用：原价$600, 现优惠价 $175 incl. GST
课程福利： 4次免费重听
报名方式：请联系客服微信号seedtg，并留言“Python”。
课程大纲请见以下内容：
1. Python Introduction
Installing python & modules
Syntax of python language
Comments for python code
Python editor layouts
Case: MIL Score
2. Variables
Use variable to store data
Rule for variable’s name
Get input from users
Class, object & data types in python
String-working with textual data
Integer & floats-working with numeric data
3. Functions & Module
User-defined functions (UDF)
UDF to module - import and apply
Exploring of Python standard library
Import & use third-party modules
4. Logic & Loop Structures
Comparison operators and logical operators
Conditionals and Booleans: If... elif ... else statement
Loops and iterations: While... statement
Case: Use counters to get total quantity and amounts
5. List & For Loop
Python collections: list, tuple, set, dictionary
List, list index & slice
Case: Get price for different products
List functions & calculation
For … in … Loop & range
6. Deal with TXT & CSV files
Read data from TXT & CSV files
Filter data by conditions
Write data to TXT & CSV files
Case: Allocate sale records to different files based on conditions
7. Use Python for data analysis & visualization
Interact with Excel with xlwings
Excel objects: App, Workbook, Worksheet, Range
Read data from a Range
Write data into specific Worksheet
Case: Get stock data
Use Numpy for data analysis
Pandas: DataFrame & Series
Use Pandas to import, sort, modify and analyse data
Use python for data visualization with matplotlib
Case: Calculate sales commission based on criteria
8. Debugging Python Code
Deal with Python syntax error
Indentation issue
Using Variable Explorer & Console for debugging
Debug – Step by step method
Debug – Set Break Point
扫描结尾二维码报名参加课程。
