IntroductionScenarioYou are an HR manager and you need to create a filecontaining wages for your employees calculated by theirhours.AimRead in a CSV file with the employee names and thehours worked, and then output another CSV file with theirpay_rate calculated with the rate 1 hour * 15.Steps for Completion1. Go to your main.py file.2. Using the csv imported module, write a script toread the contents of our employees.csv file thathas the format shown in Figure 8.5:employee_nameJohn HenryMaria GrayLarry SimonFigure 8.5hours_worked384335main.py1 employee_name, hours_worked2 John Henry, 383 Maria Gray, 434 Larry Simon, 355employees.csv+ Introduction2. Using the csv imported module, write a script toread the contents of our employees.csv file thathas the format shown in Figure 8.5:employee_nameJohn HenryMaria GrayLarry SimonFigure 8.5employee_nameJohn Henry3. Output a new CSV file called wages.csv whichshould have the format shown in Figure 8.6:Maria GrayLarry Simonhours_workedFigure 8.6384335pay_rate$570$645$525Here, wages are calculated using the formula,hours worked * 15.Make sure you've generated the output file by runningpython3 main.py and then verify that the content followsthe correct format by clicking on the wages.csv file inyour editor.main.py1 employee_name, hours_worked2 John Henry, 383 Maria Gray, 434 Larry Simon, 355employees.csv

Here is the complete programme with their output.

Answered: Scenario You are an HR manager and you…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Introduction
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.
Steps for Completion
1. Go to your main.py file.
2. Using the csv imported module, write a script to
read the contents of our employees.csv file that
has the format shown in Figure 8.5:
employee_name
John Henry
Maria Gray
Larry Simon
Figure 8.5
hours_worked
38
43
35
main.py
1 employee_name, hours_worked
2 John Henry, 38
3 Maria Gray, 43
4 Larry Simon, 35
5
employees.csv
+

Introduction
2. Using the csv imported module, write a script to
read the contents of our employees.csv file that
has the format shown in Figure 8.5:
employee_name
John Henry
Maria Gray
Larry Simon
Figure 8.5
employee_name
John Henry
3. Output a new CSV file called wages.csv which
should have the format shown in Figure 8.6:
Maria Gray
Larry Simon
hours_worked
Figure 8.6
38
43
35
pay_rate
$570
$645
$525
Here, wages are calculated using the formula,
hours worked * 15.
Make sure you've generated the output file by running
python3 main.py and then verify that the content follows
the correct format by clicking on the wages.csv file in
your editor.
main.py
1 employee_name, hours_worked
2 John Henry, 38
3 Maria Gray, 43
4 Larry Simon, 35
5
employees.csv

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

Custom Test incomplete

Delete the wages.csv file

Custom TestIncomplete

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()

Solution