it should look like my professor's output
COSC 1306 Spring 2021 Assignment 10: File Input and Output [1] Objectives: This assignment’s primary purpose is to practice reading from a text file and writing to a text file. We will use several string functions in the process. There are more than one ways to read from and write to a file. You will have the freedom to choose ways to read and write. We will assume there are no errors in the file format as specified below to simplify the tasks. [2] Description: You are implementing a simple payroll system. We have the primary employee data stored in a file (id, last and first names, pay rate) stored in a comma-separated values (CSV) format. The ID is unique. We also have a log of sign-in and sign-out of each employee (timestamp and id separated by two spaces). Assume the first timestamp if for sign in, and the second one with the same id is for sign out. They always come in a pair in the second file. The timestamp is in the format of hh:mm:ss where hh is from 0 to23 (military time) and ss should be ignored for this assignment. You have to read from these two files, calculate the amount of pay each day (not very realistic). Finally, write the pay log to a file. See the sample program for the format of these files. Here is what you need to do. Build a table of employees (prog-10-emp.txt), and you can decide whatever format to store the data, print the table Build a table of sign-in/out log (prog-10-clock.txt), print the table Calculate the amount of pay for each employee, Write a pay log to a text file (prog-10-pay.txt) and to the screen. The program is longer than the last one because you have to open/close three files. One can do a lot by calling library functions to do the work in Python. The code that I tested is less than 60 lines. [3] Requirements: For the past few assignments, I have given you specific guidelines on what functions to write. You will have to decide that in this assignment. [4] Input and Output: See sample outputs below and the demo in class. [5] Deadline: Midnight, Monday, April 26, 2021 (?). The due date may depend on when we are done with the chapter on Files. Prog-10-emp.txt 1077,Huang,Stephen,10.00 1002,Smith,John Jr.,20.00 1003,Doe,Jane,42.60 1004,Carter,James,19.50 1005,Johnson,Olin,21.00 1099,Shah,Shishir,30.00 Prog-10-clock.txt 07:59:01 1077 08:00:15 1003 08:01:00 1004 08:01:30 1002 08:10:09 1005 10:01:01 1099 15:59:01 1077 16:11:15 1003 16:21:00 1004 16:30:00 1099 17:01:30 1002 17:10:09 1005 Id Last Name First Name Pay Rate 1077 Huang Stephen 10.00 1002 Smith John Jr. 20.00 1003 Doe Jane 42.60 1004 Carter James 19.50 1005 Johnson Olin 21.00 1099 Shah Shishir 30.00 Timestamp Id 08:01:30 1002 17:01:30 1002 08:00:15 1003 16:11:15 1003 08:01:00 1004 16:21:00 1004 08:10:09 1005 17:10:09 1005 07:59:01 1077 15:59:01 1077 10:01:01 1099 16:30:00 1099 ID Hours Amount 1002 9.00 180.00 1003 8.18 348.61 1004 8.33 162.50 1005 9.00 189.00 1077 8.00 80.00 1099 6.48 194.50 Prog-10-pay.txt 1002 9.00 180.00 1003 8.18 348.61 1004 8.33 162.50 1005 9.00 189.00 1077 8.00 80.00 1099 6.48 194.50