Difference between revisions of "IS428 AY2019-20T1 Assign Kok Jim Meng Data Preparation"
Jump to navigation
Jump to search
Line 39: | Line 39: | ||
[[File:JM DP Fig1.png|600px|center]] | [[File:JM DP Fig1.png|600px|center]] | ||
<div style="text-align: center;">''Figure 1: Screenshot of the two Static CSVs Tables''</div> | <div style="text-align: center;">''Figure 1: Screenshot of the two Static CSVs Tables''</div> | ||
+ | |||
+ | '''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. | ||
+ | |||
+ | [[File:JM DP Fig2.png|600px|center]] | ||
+ | <div style="text-align: center;">''Figure 2: Join based on Sensor-id''</div> | ||
+ | |||
+ | [[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> |
Revision as of 18:55, 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
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