Question: Write a Python program to manage employee records using a table data structure. The program should read employee records from an input file ( as
Write a Python program to manage employee records using a table data structure. The program should read employee records from an input file as shown in Figure and provide the following functionalities:
A function 'display to display employee records by a given department name: display the table of employee records from the given department, including column headers; as shown in sample output Figure
Main function: opens and reads employee records into a table. Then find the grade of the employee based on hisher salary and add it to the table as column, as follow:
Grade C: Salary less than $
Employee Name; Department; Salary
Ahmed AlAwfi; COMP;
Salah AlSinani ; COMP;
Rashid AlAli ; Admin;
Kamla AlSubhi ; Admin;
Hind AlWardi ; COMP;
Said AlMosa; Finance;
Figure sample input file 'students.txt
Grade B: Salary in the range $$
Grade A: Salary greater than $
Prompt user for the department name and display employee records from the given department if exist by calling the 'display function.
Enter student cohort: Store No one in this Department
Figure sample output runs
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
