Difference between revisions of "IS428 AY2019-20T1 Assign Lim Zi Yuan Data Analysis Transformation"
Jump to navigation
Jump to search
Line 30: | Line 30: | ||
1) Combining Static Locations and Static Readings | 1) Combining Static Locations and Static Readings | ||
− | + | ||
− | + | [[File:JoinStaticsensor.png|500px|centre]] | |
− | |||
− |
Revision as of 14:04, 9 October 2019
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