Difference between revisions of "IS428 AY2019-20T1 Assign Kok Jim Meng Data Preparation"
Line 48: | Line 48: | ||
[[File:JM DP Fig3.png|600px|center]] | [[File:JM DP Fig3.png|600px|center]] | ||
<div style="text-align: center;">''Figure 3: Clean the newly joined table by removing the extra sensor-id field''</div> | <div style="text-align: center;">''Figure 3: Clean the newly joined table by removing the extra sensor-id field''</div> | ||
+ | |||
+ | [[File:JM DP Fig4.png|600px|center]] | ||
+ | <div style="text-align: center;">''Figure 4: Newly joined table is created and preparing to output as a CSV file''</div> | ||
+ | |||
+ | ===Newly created Static Sensor Readings with Location and Motion Sensor Readings CSVs=== | ||
+ | '''Issue:''' Both the newly created Static Sensor Readings with Location and given Motion Sensor Readings tables are separated. Moreover, both tables’ Sensor IDs are just numbers where same numbers appear in both tables. This does not make sense as both static and mobile sensors are different and same numbers appear. | ||
+ | '''Solution:''' Merge both newly created Static Sensor Readings with Location table with the given Motion Sensor Reading table based on the timestamp when the sensors have detected. Furthermore, I have classified the sensors based on their types – Static, and Mobile. In addition, I have also reassigned the sensors IDs where, X is a number, M-XX is a mobile sensor and S-XX is a static sensor. | ||
+ | <p>The following steps or process is how I have merged both the newly created Static Sensor Readings with Location table with the given Motion Sensor Reading table: |
Revision as of 19:00, 12 October 2019
|
|
|
|
|
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
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.
Newly created Static Sensor Readings with Location and Motion Sensor Readings CSVs
Issue: Both the newly created Static Sensor Readings with Location and given Motion Sensor Readings tables are separated. Moreover, both tables’ Sensor IDs are just numbers where same numbers appear in both tables. This does not make sense as both static and mobile sensors are different and same numbers appear. Solution: Merge both newly created Static Sensor Readings with Location table with the given Motion Sensor Reading table based on the timestamp when the sensors have detected. Furthermore, I have classified the sensors based on their types – Static, and Mobile. In addition, I have also reassigned the sensors IDs where, X is a number, M-XX is a mobile sensor and S-XX is a static sensor.
The following steps or process is how I have merged both the newly created Static Sensor Readings with Location table with the given Motion Sensor Reading table: