IS428 2016-17 Term1 Assign3 Chen Huiyan
Revision as of 00:51, 24 October 2016 by Huiyan.chen.2015 (talk | contribs)
Contents
Data Source
Data Analysis
Proximity sensor data for each of the prox zone regions is used to discover the typical working patterns for GAStech employees. In order to identify the pattern, I need find the relationship between prox-id and employees. Through some observations, I have spotted prox-id is constructed by the first character of employee's first name and full last name followed by numbers which start from 001. For example, one employee called Mat Bramar with prox-id "mbramar001". In addition, the same employee may have multiple prox-ids with increasing numbers such as 002.
Data Transformation
For proxOut-MC2.csv, I have extracted employee's last name to identify the unique employee from prox-id by using the Left and Right functions in Excel.
