Given the following data records that includes the employee’s full name, Job, and the salary. The institute has decided to award the instructors a bonus of 200 due to their efforts during the pandemic. Adam Saleet,IT Support,1000 Naji Shemmari,Registrar,1250 Bilal Tweijari,Instructor,2000 Abdallah Mazem,Accountant,1000 Nizar Hachem,Instructor,1800 Nawwara Sleiman,Admission,900 Ameen Sinjer,QA Officer,1400 Walaa Saeed,Instructor,1900 Hamid Shami,IT Support,850 Nadine Khattar,Instructor, 1480 Using “csv”, “table_utils”, and “statistics” libraries, you are asked to do the following: a- Create a text file, SP21-Emp1.txt, and copy the above contents to it.3
Given the following data records that includes the employee’s full name, Job, and the salary.
The institute has decided to award the instructors a bonus of 200 due to their efforts during
the pandemic.
Adam Saleet,IT Support,1000
Naji Shemmari,Registrar,1250
Bilal Tweijari,Instructor,2000
Abdallah Mazem,Accountant,1000
Nizar Hachem,Instructor,1800
Nawwara Sleiman,Admission,900
Ameen Sinjer,QA Officer,1400
Walaa Saeed,Instructor,1900
Hamid Shami,IT Support,850
Nadine Khattar,Instructor, 1480
Using “csv”, “table_utils”, and “statistics” libraries, you are asked to do the following:
a- Create a text file, SP21-Emp1.txt, and copy the above contents to it.3
b- Write a python
1- Read the contents of the file SP21-Emp1.txt into a list.
2- Extract the salaries into a new list.
2- For each instructor, you should add 200 to their salary.
3- Each name should also be split into first and last.
4- Using “statistics” library, calculate the mean and median of the salaries.
5- Print the records of the employees followed by the mean and the median as shown
below in the expected output.
6- Include proper screenshots of the code and the output.
Important Notes:
1- You can use only two Lists.
2- The whole program should include one loop and one If statement.
3- The format of the output should be identical to the given one.
4- The screenshots should also show part of your desktop in addition to the code/output.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
