IS428 AY2019-20T1 Assign Christine Data Analysis Transformation
Revision as of 21:11, 9 October 2019 by Christine.2016 (talk | contribs)
The very first step of analysis is located at the data cleaning and transformation so that it can bring value to the analysis conducted. Raw dataset in zip file is downloaded from VAST Challenge – Mini Challenge 2 are as follow:
- StHimarkNeighborhoodShapefile Folder (consist of shape file that allow user to use the map file in geometry format along with the ID and name of neighbourhood)
- StaticSensorReadings.csv (contains multiple Static Sensor ID respectively with the sensor readings over a period of time)
- StaticSensorLocations.csv (contains multiple Static Sensor ID respectively with the its location)
- MobileSensorReadings.csv (contains multiple Mobile Sensor ID respectively with the sensor readings and its location over a period of time)
Before using the raw dataset downloaded, this section will elaborate on the dataset analysis and transformation process in order to prepare the data for import and analysis can be conducted.
Contents
Combine Static Readings and Static Locations
Test
DATA CLEANING ON MOBILE SENSOR READINGS
COMBINE STATIC SENSORS AND MOBILE SENSORS' READINGS
FINAL WORKFLOW AND DATASET