IS428 2016-17 Term1 Assign3 Heng Yi Teng Mabel

Data Cleaning

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.