Difference between revisions of "IS428 AY2019-20T1 Assign He Yicheng: Dataset Processing"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
| style="border-bottom:0px solid #f0f0f0; background:none;" width="1%" | | | style="border-bottom:0px solid #f0f0f0; background:none;" width="1%" | | ||
| style="padding:0.3em; font-size:100%; background-color:#f0f0f0; font-weight:300;font-size:14px;border-bottom:0px solid #000000; text-align:center; color:#000000" width="19%" | | | style="padding:0.3em; font-size:100%; background-color:#f0f0f0; font-weight:300;font-size:14px;border-bottom:0px solid #000000; text-align:center; color:#000000" width="19%" | | ||
| − | [[IS428_AY2019-20T1_Assign_He Yicheng: | + | [[IS428_AY2019-20T1_Assign_He Yicheng: Preparation|<font color="gray">Preparation</font>]] |
| style="border-bottom:0px solid #f0f0f0; background:none;" width="1%" | | | style="border-bottom:0px solid #f0f0f0; background:none;" width="1%" | | ||
Latest revision as of 17:58, 12 October 2019
Preparation
Provided Data:
- MobileSensorReadings.csv - contains the sensor readings of different mobile sensor Ids over a period of time and its locations
- StaticSensorReadings.csv - contains the sensor readings of different static sensor Ids over a period of time
- StaticSensorLocations.csv - contains the different static sensor Ids with its locations
I will start with importing Static Sensor Data and then Mobile Sensor Data.
1. Combine the Static sensor readings and locations
Drag both StaticSensorReadings.csv and StaticSensorLocations.csv into the Tableau Data Source. A inner joined Data source is generated. 2 sets of data joined perfectly with common columns.
