Question

The Payroll Department keeps a list of employee information for each pay period in a text file. The format of each line of the file is the following: <last name> <hourly wage> <hours worked>

Write a program that inputs a filename from the user and prints to the terminal a report of the wages paid to the employees for the given period.

The report should be in tabular format with the appropriate header.

Each line should contain:

An employee’s name

The hours worked

The wages paid for that period.

An example of the program input and output is shown below:

Enter the file name: data.txt

Name            Hours      Total Pay
Lambert            34         357.00
Osborne            22         137.50
Giacometti          5         503.50 

Python code please.

Answer 1

file_name = input('Enter input file name: ')

# print the header on terminal
print('\n%-15s%-10s%-10s' % ('Name', 'Hours', 'Total Pay'))

# open the file and iterate line by line
for line in open(file_name):
    line = line.strip()

    # if line is not blank
    if line != '':
        # split the line and capture each group
        (nm, wage, hours) = line.split()

        # name is in string, while wage and hours next
        # to be converted form stirng to float
        wage = float(wage)
        hours = int(hours)
        pay = wage * hours

        print('%-15s%-10d%-10.2f' % (nm, hours, pay))


======================

data.txt:
Lambert 10.5 34 
Osborne 6.25 22
Giacometti 100.7 5

$main py E O saved 1ile_name inputEnter input file name: 3 # print the header on terminal python 3.6.1 (default, Dec 2015, 13:05:11) [GCC 4.8.2] on linux Files D main.py Repl.it: Stopped data.txt print(\n%-15s%-10s%-10s, % (Name, Hours, Total Pay)) Enter input file name: data.txt 6 # open the file and iterate line by line 7 for line in open(file_name): Name Lambert Osborne Giacometti Total Pay 357.00 137.50 503 .5Θ 34 ine line.strip() # if line is not blank if line 1: 10 # split (nm, wage, hours)line.split) the line and capture each group 12 13 15 16 17 18 19 20 21 # name is in string, while wage and hours next # to be converted form stirng to float wage-float (wage) hours int (hours) paywagc hours print(%-155%-100%-10.2f. % (nm, hours, pay)$ In case of any doubts, please ask in comments. If the answer helps you, please upvote. I am in great need of upvotes. Thanks!