Workshop: Data Analysis with Python

Data Analysis with Python (2 lessons)

Date: 5 Oct and 12 Oct

Time: 14:30 - 17:00

Target Audience: All Students

Medium of Instruction: English

Pre-requisite: Basic knowledge in Python

What you will learn

• Using NumPy to create arrays for storing numbers and strings
• Perform arithmetic operations on NumPy arrays
• Concatenate and split NumPy arrays
• Aggregate NumPy arrays to calculate sums, means, standard deviation, etc
• Construct a dataframe using Pandas library to store data in tabular form
• Data filtering using indexing in a dataframe
• Work with time series in Pandas
• Reading or Writing CSV/Excel files to/from dataframe
• Reading CSV file from Internet directly and pass to dataframe
• Case study: Analysis COVID19 data in HK
  
  

Course outline

Lesson 1

1. Numerical computations with NumPy
   1. Introduction to NumPy
   2. Create NumPy arrays
   3. Indexing and slicing
   4. NumPy array Reshaping
   5. Concatenation and splitting
   6. Arithmetic operations
      1. Array arithmetic
      2. Mathematical functions such as trigonometric, exponential, etc
   7. Boolean mask
   8. Sorting

Lesson 2

1. Data analysis with Pandas
   1. Introduction to Pandas
   2. Create series and dataframe
   3. Data selection for series and dataframe
      1. Slicing
      2. Indexers (loc, iloc)
   4. Handling missing data
   5. Concatenation and grouping
   6. Pivot tables
   7. String operations in series/dataframe
   8. Working with time series in Pandas
   9. File management in Pandas
      1. Reading or Writing CSV/Excel files to/from dataframe
      2. Reading CSV file from Internet directly and pass to dataframe
   10. Case study: Analysis COVID19 data in HK