IS428 2016-17 Term1 Assign3 Heng Yi Teng Mabel

From Visual Analytics for Business Intelligence
Revision as of 09:58, 20 October 2016 by Mabel.heng.2012 (talk | contribs) (resizing photo)
Jump to navigation Jump to search

Data Cleaning

I wanted to create a variable Floor/Zone so I used the Stack function in JMP.

Stack mhyt.PNG


Result:

After stack mhyt.PNG



Next, I used the Text to Columns function to create 3 new variables: Floor/Zone, Floor and Zone.

New variables floor-zone.PNG



I did this transformation on all the building data, including the Hazium sensor data. Eventually, I got the combined data file below.

Building data mhyt.PNG

Your Comments, Please!

Retrieved from ‘https://wiki.smu.edu.sg/1617t1IS428g1/index.php?title=IS428_2016-17_Term1_Assign3_Heng_Yi_Teng_Mabel&oldid=4638’