Question: In Python data in csv file file.csv Name Hire Date Salary Sick Days remaining Graham Chapman 3/15/2014 50000 10 John Cleese 6/1/2015 65000 8 Eric

In Python

data in csv file "file.csv"

Name Hire Date Salary Sick Days remaining
Graham Chapman 3/15/2014 50000 10
John Cleese 6/1/2015 65000 8
Eric Idle 5/12/2014 45000 10
Terry Jones 11/1/2013 70000 3
Terry Gilliam 8/12/14 48000 7
Michael Palin 5/23/13 66000 8

Print the contents in the csv file (you will get bonus points for a good output format.)

Find out the employee who has the longest career in this company (hired dates are longest)

Print the employees name and remaining sick day who has the highest salary.

Calculate average salary of the employees

Add another entry to the end of the file file.csv

John Smith, 9/21/18, 80000, 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!