Difference between revisions of "IS428 2016-17 Term1 Assign3 Chen Huiyan"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
==Data Analysis== | ==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 | 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". | + | Bramar with prox-id "mbramar001". In addition, the same employee may have multiple prox-ids with increasing numbers such as 002. |
==Data Transformation== | ==Data Transformation== | ||
| − | + | For proxOut-MC2.csv, I have extracted employee's last name from prox-id by using the Left and Right functions in Excel. | |
Revision as of 00:48, 24 October 2016
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 from prox-id by using the Left and Right functions in Excel.
