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.
Learning Outcomes
- 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
Course
Schedule
Course Date: TBC
Application Period: TBC
Duration: 5 days
Time: 9am to 6pm
Delivery Mode: Synchronous e-Learning
Venue: Online
Ngee Ann Polytechnic reserves the right to reschedule / cancel any programme, modify the fees and amend information without prior notice.
Lesson Plan
- Importing Data from various sources such as CSV, JSON, Excel files
- SQL language to manipulate data stored in a structured database
- Cleaning Data to ensure proper formatting, dealing with missing values, assigning proper data types to fields etc.
- Processing Data which includes transforming data into different structure formats, encoding data, normalisation of data values etc.
Certification
In-class assessments.
A Certificate of Performance will be awarded to participants who achieve at least 75% attendance and pass all required assessment(s).
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 should be conversant with basic IT skills and have basic programming experience
- Applicants should preferably have passed GCE ‘O’ Levels course of study
Course Fees
Funding period for this course is from 29 Jun 2021 to 30 Sep 2024.
SkillsFuture Credit
All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website to choose from the courses available on the Training Exchange course directory.
Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% unfunded course fee support for up to $250 each year (or up to $500 for NTUC members aged 40 years old and above) when you sign up for courses supported under UTAP (Union Training Assistance Programme). Please visit e2i’s website to find out more.
Enhanced Training Support
For enhanced training support, enter SME in the promo code during course application.
GST Increment in 2024
Please note that the GST rate will be revised to 9% with effect from 1 Jan 2024, as such any payable course fees will be subjected to the new GST rate adjustments in 2024.
Note:
- The fees below are determined based on prevailing funding policies and subject to review and revision.
- Please refer to our FAQs for more information.
Ngee Ann Polytechnic reserves the right to reschedule/cancel any programme, modify the fees and amend information without prior notice.
| Applicants / Eligibility | Fees |
|---|---|
| Full course fee | $2398.00 |
| Singaporeans aged below 40 qualified for SkillsFuture Funding | $719.40 |
| Singaporeans aged 40 & above qualified for SkillsFuture Mid-Career Enhanced Subsidy | $279.40 |
| Singaporeans qualified for Enhanced Training Support for SMEs | $279.40 |
| Singapore Permanent Residents & **LTVP+ qualified for SkillsFuture Funding | $719.40 |
| Singapore Permanent Residents & ##LTVP+ qualified for Enhanced Training Support for SMEs | $279.40 |
| Others (and Repeat Students) | $2398.00 |