Data Wrangling

Short Course / 5 days

Apply
Note: Application is closed. Please register interest below.
Course Information
Learning Outcomes
Course Schedule
Lesson Plan
Certification
Entry Requirements
Course Fees
Apply
Contact us for more information

Course Information

DATA PREPARATION WITH PYTHON

  • How to import data from various sources such as flat files, excel files, json.
  • Use SQL to navigate and extract data stored in structured database
  • Understand the various types of data types: nominal, ordinal, continuous, text, date etc.
  • Perform preliminary data analysis on a data set to produce a data summary.
  • Understand how to deal with badly formatted data
  • Process data to prepare data for further analysis

You may also join our interest mailing list for updates on future runs of this course or other similar courses.

Register Interest

Learning Outcomes

    _x000D_

  • How to import data from various sources such as flat files, excel files, json.

    • _x000D_

  • Use SQL to navigate and extract data stored in structured database

    • _x000D_

  • Understand the various types of data types: nominal, ordinal, continuous, text, date etc.

    • _x000D_

  • Perform preliminary data analysis on a data set to produce a data summary.

    • _x000D_

  • Understand how to deal with badly formatted data

    • _x000D_

  • Process data to prepare data for further analysis

    • _x000D_

Course 
Schedule

Course Date: TBC_x000D_
Application Period: TBC_x000D_
Duration: 5 days_x000D_
Time: 9am to 6pm_x000D_
Ngee Ann Polytechnic reserves the right to reschedule/cancel any programme, modify the fees and amend information without prior notice.

Lesson Plan

This course consists of 1 modules:

Course Outline
    _x000D_

  • Importing Data from various sources such as CSV, JSON, Excel files

    • _x000D_

  • SQL language to manipulate data stored in a structured database

    • _x000D_

  • Cleaning Data to ensure proper formatting, dealing with missing values, assigning proper data types to fields etc.

    • _x000D_

  • Processing Data which includes transforming data into different structure formats, encoding data, normalisation of data values etc.

    • _x000D_

Certification

In-class assessments._x000D_

_x000D_

A Certificate of Performance will be awarded to participants who achieve at least 75% attendance and pass all required assessment(s)._x000D_

_x000D_

A Certificate of Participation will be awarded to participants who meet the 75% attendance requirement but did not pass all required assessment(s).


Entry Requirements

Applicants with any of the following qualifications are invited to apply for the course:
    _x000D_

  • Applicants should be conversant with basic IT skills and have basic programming experience

    • _x000D_

  • Applicants should preferably have passed GCE ‘O’ Levels course of study

    • _x000D_

Offered by School of InfoComm Technology

Course Fees

Course fee is payable upon acceptance. It is inclusive of 7% GST and subject to review._x000D_
The course is eligible for SkillsFuture Credit. For more information on the SkillsFuture Credit click here _x000D_
For enhanced training support, enter SME in the promo code during course application.

Applicants / Eligibility Fees
For Singaporeans aged 40 & above / Singaporeans or PRs sponsored by SMEs* (After 90% SSG Funding Subsidy)$266.20
Singaporeans and PRs (After 70% SSG Funding Subsidy)$706.20
Full Course Fee$2354.00