A company stores payment information for their employee working on a project and paid on a project basis, in a text file whose name is entered through keyboard (see a sample input file below). The first line of the file indicates the number of employees and each subsequent line corresponds to information related to an employee payment (employee name, number of hours vorked and his/her hourly wage). Write a python program that reads such a file and displays he employees' names, their hours worked, and their salaries. Finally, it displays the total payment. Your program should consider the following erroneous cases: • The file does not open/exist • The format of the data in the file is incorrect (e.g. hours = "I-" or salary = "unkown") in which case a RuntimeError exception should be raised and the processing should %3D continue

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
By use python language
A company stores payment information for their employee working on a project and paid on a
project basis, in a text file whose name is entered through keyboard (see a sample input file
below). The first line of the file indicates the number of employees and each subsequent line
corresponds to information related to an employee payment (employee name, number of hours
worked and his/her hourly wage). Write a python program that reads such a file and displays
the employees' names, their hours worked, and their salaries. Finally, it displays the total
payment. Your program should consider the following erroneous cases:
The file does not open/exist
The format of the data in the file is incorrect (e.g. hours = "1-" or salary= "unkown")
in which case a RuntimeError exception should be raised and the processing should
continue
Enter input filename: employees.txt
Employee
Hours
Salary
Badria Al-Harthi: 11
Youcef Al-Busaidi: 19 720
Salim Al-Hajri:
Majid Al-Sinani:
Amer Al-Shidani: 10 unkown
520
Badria Al-Harthi
Youcef Al-Busaidi
File contents invalid.
Majid Al-Sinani
File contents invalid.
5720.0
13680.0
11
19
1-
890
1060
9.
9540.0
Total payement
28940.0
Sample input file
Sample output
Exersise 4:
Transcribed Image Text:A company stores payment information for their employee working on a project and paid on a project basis, in a text file whose name is entered through keyboard (see a sample input file below). The first line of the file indicates the number of employees and each subsequent line corresponds to information related to an employee payment (employee name, number of hours worked and his/her hourly wage). Write a python program that reads such a file and displays the employees' names, their hours worked, and their salaries. Finally, it displays the total payment. Your program should consider the following erroneous cases: The file does not open/exist The format of the data in the file is incorrect (e.g. hours = "1-" or salary= "unkown") in which case a RuntimeError exception should be raised and the processing should continue Enter input filename: employees.txt Employee Hours Salary Badria Al-Harthi: 11 Youcef Al-Busaidi: 19 720 Salim Al-Hajri: Majid Al-Sinani: Amer Al-Shidani: 10 unkown 520 Badria Al-Harthi Youcef Al-Busaidi File contents invalid. Majid Al-Sinani File contents invalid. 5720.0 13680.0 11 19 1- 890 1060 9. 9540.0 Total payement 28940.0 Sample input file Sample output Exersise 4:
Expert Solution
steps

Step by step

Solved in 5 steps with 3 images

Blurred answer
Knowledge Booster
Introduction to computer system
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education