商业分析巨蟒要掌握,Python for Business Analysis 全新直播课程

2020年01月14日 Seed读职场



用一天时间详细讲解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


扫描结尾二维码报名参加课程。



收藏 已赞