Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a python program that demonstrates reading and comparing multiple files, processes the input files based on the business rules, and produces an output file.

Create a python program that demonstrates reading and comparing multiple files, processes the input files based on the business rules, and produces an output file.
Needed Files
The timeclock.txt Download timeclock.txtfile contains the hours worked data for every employee as well as the shift they worked. The layout for the file is as follows:
EMPLOYEE_NUMBER, HOURS_WORKED, SHIFT
The personnel.txt Download personnel.txtfile contains the names of all employees and their hourly pay rates. The layout for the file is as follows:
EMPLOYEE_NUMBER, EMPLOYEE_NAME, PAY_RATE
Note: Both the timeclock.txt and payroll.txt files are pre-sorted by EMPLOYEE_NUMBER in ascending order.
Business Rules
For hours =40, the employee gross pay is: HOURS_WORKED * PAY_RATE
For hours >40, the employee gross pay is: HOURS_WORKED * PAY_RATE *1.5
For shift 3, add $1 per hour to the employee pay rate
The program should:
Download both input files in the same folder that you will create your .py program.
Read both input files together.
Match the input files by the EMPLOYEE NUMBER.
For each record in the timesheet.txt file, write a record in a new output file named payroll.txt based on the business rules provided. The layout for payroll.txt is as follows:
EMPLOYEE_NUMBER, EMPLOYEE_NAME, GROSS_PAY
Document your program with appropriate comments. Remember if you worked in teams, all team members' names must be in the comments.
Test your program by comparing your results to this expectedpayroll.txt Download expectedpayroll.txtfile. In general, running one test is not enough. Create at least two additional test runs by altering the timeclock.txt file. After EACH test run, rename the payroll.txt file to payroll1.txt, payroll2.txt, etc.
In the Word document that you created above, answer the question: My program runs as expected and why? Note: performing step 6 above informs this answer.
Save your file as payroll_yourlastname.py
Tip: Loop through the timeclock.txt file and compare it to records in the personnel.txt file on EMPLOYEE_NUMBER. Compute the employee gross pay and write the employee number, employee name, and the computer gross pay to the output file.
timeclock.txt
22476,45,3
24987,30,1
48283,50,2
85437,25,3
personnel.txt
11235, Bob Smith,10.50
22476,John Roberts,12.35
24987, Mary Johnson,15.90
32743, Brad Carson, 11.25
48283,Alice Martin,14.20
85437, Aaron James, 15.15
expectedpayroll.txt
22476,John Roberts,634.12
24987, Mary Johnson, 477.00
48283,Alice Martin, 781.00
85437, Aaron James, 403.75
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Manga Guide To Databases

Authors: Mana Takahashi, Shoko Azuma, Co Ltd Trend

1st Edition

1593271905, 978-1593271909

More Books

Students also viewed these Databases questions

Question

List the activities involved in employer-designed HRD programs

Answered: 1 week ago