Question: In Python The weekly hours for all the employees at your company are stored in the file called Employee_hours.txt . Each row records an employee's

In Python

The weekly hours for all the employees at your company are stored in the file called Employee_hours.txt. Each row records an employee's seven-day work hours with seven columns. For example, the following table stores the work hours for eight employees:

Employee Su M T W Th F Sa
1 2 4 3 4 5 8 8
2 7 3 4 3 3 4 4
3 3 3 4 3 3 2 2
4 9 3 4 7 3 4 1
5 3 5 4 3 6 3 8
6 3 4 4 6 3 4 4
7 3 7 4 8 3 8 4
8 6 3 5 9 2 7 9

Write a program that reads the employee information from the file and store it in a two-dimensional list. Then displays the following information:

employees and their total hours in decreasing order of the total hours (For example, using the above data employee 8 would be listed first with a total of 41 hours, employee 7 would be listed next with a total of 37 hours, etc.)

total hours worked for each day of the week: Sunday through Saturday

Employee_hours.txt:

Employee Su M T W Th F Sa 1 2 4 3 4 5 8 8 2 7 3 4 3 3 4 4 3 3 3 4 3 3 2 2 4 9 3 4 7 3 4 1 5 3 5 4 3 6 3 8 6 3 4 4 6 3 4 4 7 3 7 4 8 3 8 4 8 6 3 5 9 2 7 9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!