IS428 AY2019-20T1 Assign Kok Jim Meng Data Preparation
Revision as of 18:55, 12 October 2019 by Jimmeng.kok.2017 (talk | contribs)
|
|
|
|
|
Data Preparation
The dataset zip file given includes:
- Mobile Sensor Readings
- Static Sensor Readings
- Static Sensor Location
- Data Description
- Maps of St Himark
Static Sensor Readings and Static Sensor Location
Figure 1: Screenshot of the two Static CSVs Tables
Issue: In the CSV file of Static Sensor Readings, there are no geographic coordinates of the static sensors as the data are in the CSV file of Static Sensor Locations. Solution: Use Tableau Prep to join the two tables into one CSV based on the common field which is Sensor-id and cleaning it by removing the extra sensor-id field. With this, it would be possible to perform a map visualization for Static Sensors using the longitude and latitude in Tableau. The following is the data preparation used in Tableau Prep for Static Sensor data.
Figure 2: Join based on Sensor-id
Figure 3: Clean the newly joined table by removing the extra sensor-id field