IS428 2016-17 Term1 Assign3 Heng Yi Teng Mabel
Revision as of 12:27, 20 October 2016 by Mabel.heng.2012 (talk | contribs)
Data Cleaning
Building Data
I wanted to create a variable Floor/Zone so I used the Stack function in JMP.
Result:
Next, I used the Text to Columns function to create 3 new variables: Floor/Zone, Floor and Zone.
I did this transformation on all the building data, including the Hazium sensor data and got the combined data file below.
Finally, I used Stack to combine all the Building Elements into one variable. A sample from the final data file is as shown below.
Sensor Data
TBC