Scenario You are an HR manager and you need to create a file containing wages for your employees calculated by their hours. Aim Read in a CSV file with the employee names and the hours worked, and then output another CSV file with their pay_rate calculated with the rate 1 hour * 15. 5

Delete the wages.csv file

The program writes to the wages.csv file

Test OutputJohn Henry's payrate was not found in the wages.csv file. Traceback (most recent call last): File "/home/nt-user/workspace/nt-test-76ce7b1d", line 23, in <module> raise AssertionError() AssertionError

 

Test Contentsimport csv import main with open('/home/nt-user/workspace/wages.csv') as f: # Read in the CSV file csvfile = csv.reader(f) csvout = list() all_lines = list() for row in csvfile: csvout.append(row) # Create a single list of file contents for lyst in csvout: all_lines.append(lyst[0]) all_lines.append(lyst[1]) # Check the aggregated file contents for the employee information if 'John Henry' not in all_lines: print('John Henry was not found in the wages.csv file.') raise AssertionError() elif '570' not in all_lines: print('John Henry\'s payrate was not found in the wages.csv file.') raise AssertionError() elif 'Maria Gray' not in all_lines: print('Maria Gray was not found in the wages.csv file.') raise AssertionError() elif '645' not in all_lines: print('Maria Gray\'s payrate was not found in the wages.csv file.') raise AssertionError() elif 'Larry Simon' not in all_lines: print('Larry Simon was not found in the wages.csv file.') raise AssertionError() elif '525' not in all_lines: print('Larry Simon\'s payrate was not found in the wages.csv file.') raise AssertionError() f.close()