IS428 2016-17 Term1 Assign3 Heng Yi Teng Mabel
Revision as of 09:55, 20 October 2016 by Mabel.heng.2012 (talk | contribs) (Created page with "==Data Cleaning== I wanted to create a variable '''Floor/Zone''' so I used the ''Stack'' function in JMP. 700px ''Result:'' File:After_stack_mhyt...")
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. Eventually, I got the combined data file below.
