Lab2_AnswersTemplate

CST8390 - Lab 2 Data Preparation and Cleaning - Answers Part 1 8. Which are the four important attributes that are relevant for data analysis? Country, branch, currency, salary 9. For the nominal attributes of the above question, fill in the following table: Attribute Name: ID Attribute Name: Branch Label Count Label Count CHINA 36 1 38 USA 38 2 39 GERMANY 38 3 37 MEXICO 37 4 35 JAPAN 1 6 1 Attribute Name: Currency Label Count CHY 38 EUR 38 MXD 35 USD 38 INR 1 10. Analyze your data to see any anomalies. List the identified anomalies below. Write why you think those records are anomalies in the following format (add rows as required):

Id first_name last_name email Address Country Branch Currency Salary Reason 100149 Darcy Addie daddie1k@jalbum.net 836 Marquette Pass Germany 2 EUR 60500999 Darcie has a salary that is significantly higher than anyone else in their branch, country, or currency, making them an outlier in multiple fields. 100204 Misha Tunna mtunnaj@dailymotion.com 15 Kipling Drive USA 1 USD 32000999 Misha also has a salary that much higher than others in their branch, country and currency making them another notable outlier. 100233 Bel Hodgin bhodgin2g@msu.edu 60 Bellgrove Court Japan 3 CHY 600000 Bel is the only employee working out of Japan 100187 Elsworth Skells eskells35@spotify.com 54486 Carberry Park Mexico 4 CHY 150000 Only employee in branch 4 using Chinese currency 100169 Chelsie Mulles cmulles3x@amazon.co.uk 8 Talmadge Circle Mexico 6 MXD 36000 Chelsie is the only employee working in branch 6 100187 Elsworth Skells eskells35@spotify.com 54486 Carberry Park Mexico 4 CHY 150000 Elsworth is the only employee working in Mexico using Chinese currency 100247 Nelson McRinn nmcrinn3p@economist.com 56053 Buell Terrace Mexico 2 MXD 19999 Nelson is the only employee in branch 2 working in Mexico 100139 Burton Dudden bdudden39@japanpost.jp 050 Nova Court Mexico 4 INR 45999 Burton is the only employee using INR currency 100233 Bel Hodgin bhodgin2g@msu.edu 60 Bellgrove Court Japan 3 CHY 600000 One of two people not in China using Chinese currency 100247 Nelson McRinn nmcrinn3p@economist.com 56053 Buell Terrace Mexico 2 MXD 19999 Only person in branch 2 not using EUR currency

13. a. How many instances do you have now? _____2971____________ b. How many duplicates (how many got removed): ___39_____________ 14. Take a screenshot and paste it here.

Nominal to Binary 16. How many nominal attributes do you have? 7 18. Take a screenshot and paste it in lab2 document.

21. Take a screenshot of the file while it is opened in Notepad++. Header should be visible.