Data Wrangling (Classroom & Asynchronous)
Training Provider: Ngee Ann Polytechnic
Course Reference: TGS-2022013892
S$660
Original: S$2,200
Save S$1,540
About This Course
Participants will learn:
- 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
What You'll Learn
This course introduces the various techniques to import data, clean data and process data for analysis. The course will cover simple statistical analysis that can be performed on the processed data.
The course covers the following:
- 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.
The course covers the following:
- 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.
Entry Requirements
Basic programming experience
Course Details
Back to All Courses
Note: To apply for this course, visit the SkillsFuture website or contact the training provider directly.
More Courses from Ngee Ann Polytechnic
This course is designed to equip non-accounting graduates with foundational competencies to embark o...
This module builds towards the overaching SCTP and it helps learners to pick up Smart and Sustainabl...
This module builds towards the overarching SCTP and it helps learners to pick up Smart and Sustainab...