Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In PYTHON please In PYTHON If there is a bad data, the lists should be empty. CIS 221 Module 5 (Ch6&13 PA) Employee Payroll Summary

In PYTHON please

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

In PYTHON

If there is a bad data, the lists should be empty.

CIS 221 Module 5 (Ch6&13 PA) Employee Payroll Summary Invalid choice Please try again Mena of For this assignment, you will write a program that reademployee work cats from text file, and then calculates payroll information based on this file.(Make sure you read the last page with requirements.) The text file will contain one line of text for each employee. Each line coesists of the following data (delim ited by tabs). (r) ead esployee data plrint empleyee payrell a Esplay an eaployee by nane ind h) Sgheat paid employee find (a)owest paid enpleee alult cholee 1) employee's name 2 employee's hourly wage rate bours worked Monday hours worked Tuesday 5) bours worked Wednesday Assume the user selects to read a file. Ifso, your program will ask the user for the file rame (it must be in the same folder as your.file), attempt to read this file, abd use it to populate three lists: a list containing each employee's e, list of each employee's boatly wage, and a list costaining cach employee's total houts worked Co the weck When this is complated, these lists should be sorted in onder based on the employee names (more about this later) Assuming the file was successfully read, and data saccessfully input, you should present a confirmation message like this, followed again by the meu 6 bours worked Thursday hours worked Friday Fot example, consider this tee: (e)ead enpleyee data Jones 12. 4 3.3 2.2 6.5 9 .5 9 oweat paid Ahnad 1.5 4.59 Choi 6.se e 28 2.5 4 Pease snces your chose The employee Smith makes $10 per hour, and worked 8 hours on Monday, 8 on Tuesday,8 on Wednesday. 8 or Thursday, and 10 on Friday. You can see similar data the other eployees I the above file was read successfully into the three lists (called tNaacs, latWass latioussckcd), they will look like thismemoy IEyou are not getti-s these 3 lista, then yos should go back and get that working because you canmot do the rest without the correct lists being created Expected Behavior of your Program The ollowing sercen shots ilustrate what yous progtam should be able to do The program will repeatedly present a menu of options, as shown below Monu of choices 11.5 15, 6.5,12.5, 20. 101 5.5. 22.5 50-5 22.5. 18.5,421 Note: it's poasible that the wscr coald enter a nos-existent fle. In this case n cror mesage should appeat, like thia: (e)ead employee data (p)zint employe payrol1 (d)isplay an aployoe by ano Eind (h) Sghest paid employee Eind ()owest paid omployes youz choice plzsst employee payzo21 These arc the only allowable optionrthe user types aeything othatt, p,L h, Lorg, you should peiel an error message, and again present the mens, lEke this CIS 221 Module 5 (Ch6&13 PA) Employee Payroll Summary Invalid choice Please try again Mena of For this assignment, you will write a program that reademployee work cats from text file, and then calculates payroll information based on this file.(Make sure you read the last page with requirements.) The text file will contain one line of text for each employee. Each line coesists of the following data (delim ited by tabs). (r) ead esployee data plrint empleyee payrell a Esplay an eaployee by nane ind h) Sgheat paid employee find (a)owest paid enpleee alult cholee 1) employee's name 2 employee's hourly wage rate bours worked Monday hours worked Tuesday 5) bours worked Wednesday Assume the user selects to read a file. Ifso, your program will ask the user for the file rame (it must be in the same folder as your.file), attempt to read this file, abd use it to populate three lists: a list containing each employee's e, list of each employee's boatly wage, and a list costaining cach employee's total houts worked Co the weck When this is complated, these lists should be sorted in onder based on the employee names (more about this later) Assuming the file was successfully read, and data saccessfully input, you should present a confirmation message like this, followed again by the meu 6 bours worked Thursday hours worked Friday Fot example, consider this tee: (e)ead enpleyee data Jones 12. 4 3.3 2.2 6.5 9 .5 9 oweat paid Ahnad 1.5 4.59 Choi 6.se e 28 2.5 4 Pease snces your chose The employee Smith makes $10 per hour, and worked 8 hours on Monday, 8 on Tuesday,8 on Wednesday. 8 or Thursday, and 10 on Friday. You can see similar data the other eployees I the above file was read successfully into the three lists (called tNaacs, latWass latioussckcd), they will look like thismemoy IEyou are not getti-s these 3 lista, then yos should go back and get that working because you canmot do the rest without the correct lists being created Expected Behavior of your Program The ollowing sercen shots ilustrate what yous progtam should be able to do The program will repeatedly present a menu of options, as shown below Monu of choices 11.5 15, 6.5,12.5, 20. 101 5.5. 22.5 50-5 22.5. 18.5,421 Note: it's poasible that the wscr coald enter a nos-existent fle. In this case n cror mesage should appeat, like thia: (e)ead employee data (p)zint employe payrol1 (d)isplay an aployoe by ano Eind (h) Sghest paid employee Eind ()owest paid omployes youz choice plzsst employee payzo21 These arc the only allowable optionrthe user types aeything othatt, p,L h, Lorg, you should peiel an error message, and again present the mens, lEke this

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

More Books

Students also viewed these Databases questions