IS428 AY2019-20T1 Assign Ho Jue Hong Data Cleaning

MINI-CHALLENGE 2: CITIZEN SCIENCE TO THE RESCUE

PROBLEM & MOTIVATION

DATA CLEANING

DASHBOARD

PROBLEMS

REFERENCE

Data Flow

Merging of Static Sensor Location and Readings

Firstly to make the dataset easier to use, I would clean the dataset first, removing the redundant columns. After looking through the datasets given, the two datasets StaticSensorLocation.csv and StaticSensorReading.csv has a similar column, Sensor-id. Hence we are able to do an inner join between both datasets and remove the extra columns.