Workshop: Data Manipulation and Data Preparation with R

Data Manipulation and Data Preparation with R (2 lessons)

Date: 9 Sep and 16 Sep

Time: 14:30 - 17:00

Target Audience: All Students

Medium of Instruction: English

Pre-requisite: Basic R programming skill is required

What you will learn

• Practical skills to perform data manipulation on the data frame by R package
• Verify the quality of data such as how many missing values, incorrect data type, incorrect data range and incorrect data format
• Identify, correct, and remove dirty data
• Integrate the data using data frames
• Change the structure or values of the data using data frames
  

Course outline

Lesson 1

1. Data Manipulation
   1. Perform data manipulation on the data frame by R package dplyr
2. Data Preparation I
   1. Data validation

Lesson 2

1. Data Preparation II
   1. Data Cleaning
   2. Data Integration
   3. Data Transformation

Practical coursework throughout the workshop