You are asked to extract data from three input data files and create a new dataset with
Question:
You are asked to extract data from three input data files and create a new dataset with the columns and conditions given below. The specs for naming the various files to submit your homework are also given below. Please make sure to follow the specs as you will lose points for non-compliant submissions. You may work on this homework in pairs. If working in pairs, make sure to name the files to show both your login names.
Download Instructions: The data files for this homework are combined into a zip file named “HW1Data.zip” and posted on Canvas. First, please create a folder to download and store data files. Then, download the zipped file “HW1Data.zip” from Canvas, extract the following data files (i.e., original data) and copy them to your newly created folder.
employee_payroll.csv
employee_info.xlsx
employee_organization.sas7bdat
Then, create the final dataset with the following Columns (the column sequence should be maintained as below):
Employee_ID
Employee_Name
Employee_Gender
City
Marital_Status
Dependents
Job_Title
Employee_Hire_Date
Department
Salary
TakeHomePay (To be computed as specified below)
Target (To be computed as specified below)
Computed column details:
TakeHomePay = Salary – Deductions withheld @ 15% of Salary
Target = "US" for all records in this dataset
The output data should satisfy the following conditions:
- The employees should be from the US.
- The employees should have been hired in 1990 or later.
- The employees should be married and with at least 2 dependents.
- The employees should be from one of the following departments:
a. Sales
b. Marketing
c. IS
d. Logistics Management
Can someone please help me understand the problem step by step?
Accounting
ISBN: 978-0324662962
23rd Edition
Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren