Difference between revisions of "IS428 2016-17 Term1 Assign3 Bong Jun Hao"
Line 1: | Line 1: | ||
= Data Exploration/Cleanup = | = Data Exploration/Cleanup = | ||
==Employees.xlsx== | ==Employees.xlsx== | ||
− | By itself, the dataset provided was not enough to provide any insights, except for to identify the department and floor/zone of a particular employee. | + | By itself, the dataset provided was not enough to provide any insights, except for to identify the department and floor/zone of a particular employee. |
+ | Issue: It is mentioned that an employee could possible hold multiple proxID as they would pick up additional prox card(s) if they have misplaced their old one. This is not reflected in the employees file provided. | ||
− | An example would be Anda Ribera, where Anda is the first name and Ribera is the last name. Hence he would have the id Aribera001 and any subsequent id issued would be aribera002, aribera003 so on and so forth. As such, an additional column is added to the employees.xlsx file based on the proxOut file to see what are the various ids that each employee holds | + | Solution: |
+ | Upon further investigation of the proxOut file, it can be seen that the proxID of an employee is based on the combination of the first character of an employee's First Name followed by his or her entire Last Name as well as a 3 number digit code that is in running order from 001 onwards. | ||
+ | |||
+ | An example would be Anda Ribera, where Anda is the first name and Ribera is the last name. Hence he would have the id Aribera001 and any subsequent id issued would be aribera002, aribera003 so on and so forth. As such, an additional column is added to the employees.xlsx file based on the proxOut file to see what are the various ids that each employee holds. | ||
[[File:CaptureOfCleanedEmployee.JPG]] | [[File:CaptureOfCleanedEmployee.JPG]] |
Revision as of 16:35, 23 October 2016
Data Exploration/Cleanup
Employees.xlsx
By itself, the dataset provided was not enough to provide any insights, except for to identify the department and floor/zone of a particular employee. Issue: It is mentioned that an employee could possible hold multiple proxID as they would pick up additional prox card(s) if they have misplaced their old one. This is not reflected in the employees file provided.
Solution: Upon further investigation of the proxOut file, it can be seen that the proxID of an employee is based on the combination of the first character of an employee's First Name followed by his or her entire Last Name as well as a 3 number digit code that is in running order from 001 onwards.
An example would be Anda Ribera, where Anda is the first name and Ribera is the last name. Hence he would have the id Aribera001 and any subsequent id issued would be aribera002, aribera003 so on and so forth. As such, an additional column is added to the employees.xlsx file based on the proxOut file to see what are the various ids that each employee holds.