IS428 AY2019-20T1 Assign Lim Zi Yuan Data Analysis Transformation
Revision as of 14:05, 9 October 2019 by Ziyuan.lim.2017 (talk | contribs)
VAST 2019 MC2: Citizen Science to the Rescue
|
|
|
|
|
Data Provided
Before we conduct any analysis, we have to perform data pre-processing to ensure that the data provided is in an easy to use format. The data provided to us are 1) MobileSensorReadings.csv 2) StaticSensorReadings.csv 3) StaticSensorLocations.csv
Data Preparation
Upon Inspection of the data sources, I can see that in StaticSensorReadings.csv and StaticSensorLocations.csv the column Sensor-id is repeated, using Tableau prep I merge the two files together. This allows us to extract the value of each sensor at any given location.
1) Combining Static Locations and Static Readings
