Write a python program to search for an employee from an input file based on SSN. Extend the
program to read the employee id from the input file and sort and display the details. There are
two input files – “Employee_SSN.txt” and “Employee_Details.txt”.
Employee_SSN.txt should contain the following fields:
<Employee_ID>, <SSN_Number>, <Date_of_Birth>
Employee_Details.txt should contain the following fields:
<Employee_ID>, <Name>, <Date_of_Joining>, <Department>, <Annual_Salary>
All <Employee_ID> in “Employee_SSN.txt” should be there in “Employee_Details.txt”.
Details of the program:
The program should display the following options to the user:
Option 1:
Search for an employee using their <SSN_Number>, and display the
employee details.
Option 2:
Sort the <Employee_ID>, and display the employee details.s
Option 3:
Exit
Based on each option the user selects, the following operations are to be performed.
1. When the user selects option 1:
a. The program should prompt the user to enter an SSN number. The SSN number
the user enters and stores in the file is a 9-digit number of the form (Sample
SSN: 123-234-345).
b. Check whether the entered SSN is in the file “Employee_SSN.txt”.
c. If there is a matching entry, then the details corresponding to the employee from
“Employee_Details.txt” should be displayed, based on the <Employee_ID>.
d. If there is no matching SSN found in the “Employee_SSN.txt”, then “SSN not
found in the file” is displayed.
2. When the user selects option 2:
a. Open the file “Employee_Details.txt”. Read the <Employee_ID> from the file
and store it in a list. Sort the list and display the employee details corresponding
to the sorted list.CSCI 161
b. Display the details from the file “Employee_Details.txt”, based on sorted
<Employee_ID> in the terminal.
3. When the user selects option 3, exit from the program.
Attention:
1. You can create your own input files or use the files uploaded on the blackboard.
2. Input file format is given below:
Sample “Employee_SSN.txt”
Sample “Employee_Details.txt”
Instructions:
• Preferred programming environment:
o OS
: Linux (Mint)
o Interpreter : Python 3 (not Python 2)
o Editor
: gedit or editor of your choice
2001, 123-325-234, 06/07/1993
1001, 234-345-123, 08/12/1986
1003, 124-254-354, 11/27/1987
1006, 132-225-534, 06/17/1988
2008, 175-432-236, 05/04/1996
2001, name1, 03/12/2017, Eng, 42000
1001, name2, 04/01/2016, Aero, 32000
2008, name3, 03/12/2018, Eng, 54000
1006, name4, 02/24/2016, Arts, 45000
1003, name5, 05/20/2014, Aero, 45000CSCI 161
Sample output:
