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-dimentional 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
Get step-by-step solutions from verified subject matter experts
