IS428 2016-17 Term1 Assign3 Wu Wei
Problem & Motivation
After the successful resolution of the 2014 kidnapping at GAStech’s Abila, Kronos office, GAStech officials determined that Abila offices needed a significant upgrade. At the end of 2015, the growing company moved into a new, state-of-the-art three-story building near their previous location.
The new office is built to the highest energy efficiency standard, but as with any new building, there are still several HVAC issues to work out. The building is divided into several HVAC (heating, ventilation, and air conditioning) zones. Each zone is instrumented with sensors that report building temperatures, heating and cooling system status values, and concentration levels of various chemicals such as carbon dioxide (abbreviated CO2) and hazium (abbreviated Haz), a recently discovered and possibly dangerous chemical. CEO Sten Sanjorge Jr. has read about hazium and requested that these sensors be included. However, they are very new and very expensive, so GAStech can afford only a small number of sensors.
As the given two weeks of building and prox sensor data, We can use interactive data visualization tools to visualize the data in order to identify typical patterns which could address the following potential issues:
- Security issues which refer to any suspicious behaviors conducted by the employees.
- Chemical concentration levels which refer to the concentration level of carbon dioxide and hazium.
- Energy waste which refers to the overuse of energy for the facilities in the buildings.
Data Preparation & Transformation
After unzipping the 6 zip files, we would get 7 CSV files and 1 excel format file. Since some of the values are inconsistent from one dataset to another. The first thing we need to do is to transform the data which make all data coherent and presentable.
- Convert XY coordinates expression in proxMobileOut-MC2.csv to zone presentation
