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
 
PYA0111 - 廣東話 09 Nov enrol
 
PYA0112 - 廣東話 30 Nov enrol
 
PYA0121 - 廣東話 15 Dec enrol
RELATING COURSES
  Beginning Data Science with Python
  Python Programming
  Stock Trading Analysis with Python