Computer Academy


Enquire Now

Course Information

  • 12 May 2021 (Wed) - 2 Jun 2021 (Wed) 7:00 PM - 9:30 PM
  • 3 Jun 2021 (Thu) - 10 Jun 2021 (Thu) 2:00 PM - 4:30 PM
Registration period
20 Apr 2021 (Tue) - 29 May 2021 (Sat)
HKD 2,880
Course Level
Study Mode
7.50 Hour(s)
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong

Course Overview

This course is for people they want to learn analysing data with Python within the shortest time. Why choosing Python? Python is versatile and supported by huge amount of libraries. It is also considered and used by a lot of companies. By comparing to Excel, users can benefit from its speed, ability to handle the data volume far exceeding the Excel’s limit, and save time without repeating the calculation over and over again when data get updated.

In the course, you will learn the essential features of Python and Pandas – Python’s library. You will be guided through a series of exercises from which you will know how to import, process, calculate data and export the results to different file formats.


What you'll learn

You'll Learn

Python Essentials

  • Using Jupyter Notebook
  • Working with lists and dictionaries
  • Logical operations using if
  • Batch processing using for Loop
  • Defining your own functions
  • Python and python's packages installation
  • Importing and using python's libraries

Data Preparation and loading

  • Loading Excel and CSV files
  • Constructing series and dataFrames
  • Working with problematic data
  • Replacing Data
  • Remove duplications

Data Processing with Pandas

  • Viewing and selecting data
  • Masking data
  • Joining and merging dataframes
  • Data aggregation and group operations
  • DataFrames calculations
  • Sorting and ranking data
  • Exporting results to Excel or CSV files

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed