Python for Data Analysis

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.

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

SCHEDULES
 
PYA4091 - 廣東話 12 Sep enrol
 
PYA4092 - 廣東話 25 Sep enrol
 
PYA4101 - 廣東話 15 Oct enrol
 
PYA4102 - 廣東話 21 Oct enrol
 
PYA4111 - 廣東話 18 Nov enrol
RELATING COURSES
  Beginning Data Science with Python
  Certificate Course in Python Programming x ChatGPT/GPT
  Python for Data Analysis
  Stock Trading Analysis with Python
  Python Programming x ChatGPT/GPT