Difference between revisions of "IS428 AY2019-20T1 Assign He Yicheng: Dataset Processing"
Jump to navigation
Jump to search
(Created page with "<div style="margin-bottom:20px;background:#3d3c49">1000px|center</div> <!-- Header Start --> {|style="background-color:#f0f0f0; color:#000000...") |
|||
Line 25: | Line 25: | ||
<!-- Header End --> | <!-- Header End --> | ||
− | ==<div style="font-weight:300;padding: 10px 13px 20px 13px; line-height:10px;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:40px"> | + | ==<div style="font-weight:300;padding: 10px 13px 20px 13px; line-height:10px;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:40px">Preparation</font></div>== |
<div style="font-weight:300;margin-bottom: 60px;margin-top:15px;max-width:700px;margin-left:15px;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:17px;> | <div style="font-weight:300;margin-bottom: 60px;margin-top:15px;max-width:700px;margin-left:15px;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:17px;> | ||
+ | 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 <b>Static Sensor Data</b> and then <b>Mobile Sensor Data</b>. | ||
+ | </div> | ||
+ | |||
+ | === <div style="font-weight:300;padding: 10px 13px 20px 13px; line-height:10px;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:25px">1. Combine the Static sensor readings and locations</font></div>=== | ||
+ | |||
+ | <div style="font-weight:300;margin-bottom: 60px;margin-top:15px;max-width:700px;margin-left:15px;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:17px;> | ||
+ | [[File:yc static join table.png|500px]]<br> | ||
+ | |||
+ | Drag both <i>StaticSensorReadings.csv</i> and <i> StaticSensorLocations.csv</I> into the Tableau Data Source. A inner joined Data source is generated. 2 sets of data joined perfectly with common columns. | ||
</div> | </div> |
Revision as of 17:57, 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.