Question

Create a script that reads in the attached emp.txt file and outputs a file with the net pay of each employee. Incorporate the overtime and net pay rules from the previous assignments. Also, create a separate file which states the employee with the highest net pay and the employee with the lowest net pay. The structure of emp.txt is the following: employee_id, hourly_rate, hours_worked, years_of_service Overtime rules: To earn overtime the employee must have worked for the company for at least 2 years AND must have worked over 40 hours If the employee worked over 50 hours they receive an additional 50 to be added to grossPay If the employee has worked over 40 hours but has not worked for the company for at least 2 years they do not receive overtime. Use the following formula to determine how much overtime the user worked overtime = - 40 Calculate the gross pay with the following formula grossPay = (overtime * * 2) + (( - overtime) * ) Net Pay rules: subtract 39% from gross pay emp.text file - https://docs.google.com/document/d/1bw6N2jU1fjfwum-g_VvZKtLGwI4UtMXd39uOuFYf0kg/edit?usp=sharing Python 3.7

Answer 1

import sys

high = ""

low = ""

def write_output_file(line, file):

with open(file, "a") as myfile:

myfile.write(line + "\n")

def execute(line):

global high

global low

(employee_id, hourly_rate, hours_worked, years_of_service) = line.split(",")

payment = float(hourly_rate) * int(hours_worked)

if int(hours_worked) > 50:

payment = payment+50

if int(years_of_service) > 2 and int(hours_worked) > 40:

overtime = int(hours_worked) - 40

payment = payment + (overtime**2) - overtime

net_pay = payment - (payment * 0.39)

if high:

(emp_id, net_pay2) = high.split(",")

if float(net_pay2) < net_pay:

high = "%s,%s" % (employee_id, str(net_pay))

else:

high = "%s,%s" % (employee_id, str(net_pay))

if low:

(emp_id, net_pay2) = low.split(",")

if float(net_pay2) > net_pay:

low = "%s,%s" % (employee_id, str(net_pay))

else:

low = "%s,%s" % (employee_id, str(net_pay))

result = "%s,%s" % (employee_id, str(net_pay))

return result

def process_file(file_name):

with open(file_name, 'rt') as myfile:

for line in myfile:

write_output_file(execute(line), "output.txt")

write_output_file(high, "high_low.txt")

write_output_file(low, "high_low.txt")

if __name__=='__main__':

if len(sys.argv) > 1 and sys.argv[1]:

try:

process_file(sys.argv[1])

except Exception as e:

print(str(e))

else:

print('provide the full path of the file as argument')