Question

in csis 152 style

Read the initial employee information from a text file and store the employee information into a list of sublists called empRoster. Each sublist should contain [empID, name, payrate,hours] Here's an example of how empRoster will look: 111, "Sally Smith", 10, 401, 1222, "Bob Brown", 10, 42]1 The text file will be structured as shown below, where each line contains the employee id, employee name, payrate and hours. Each entry on the line is separated by a comma and a space Example textfile: 111, George Gray, 10, 40 222, Amy Abrahmson, 10, 30 333, David Dell, 10, 42 444, Bob Brown, 5, 40 555, Alan Abrahmson, 10,45 Example of the empRoster after the information shown has been read and stored [111, "George Gray", 10, 401, [222,"Amy Abrahmson", 10,30], [333, "David Dell", 10, 421, (444, "Bob Brown",5,40], (555,"Alan Abrahmson"]] The program must be modularized. Be sure to create functions. After reading the file, print a report that looks similar to the following. 1. Remember to calculate OVERTIME if the hours exceed 40 by awarding time and a half of the payrate for any hours over 40. Be SURE to format the numeric information as shown below. Employee Roster PayRate Hours GrossPay ID Name 40 $400.00 $10.00 George Gray Amy Abrahmson $10.00 David Dell Bob Brown Alan Abrahmson $10.00 111 222 333 444 555 30 $300.00 $430.00 $200.00 10.00 $ 5.00 42 40 $475.00 45 2. Ask the user to continue entering employee information until they type-999 for the ID Print the report again after the additions. 3. Ask the user to enter an ID and delete that employee from empRoster if that ID exists. Print the report again after the deletions. 4. Ask the usesr to enter a last name and delete ALL employees from the roster that have that last name. Print the report again after the deletions 5. Print the full names of all employees that worked more than 40 hours.

python programming language

Answer 1

thanks for the question, here is the compelte code in python,m ake sure you updat the filename inside the main() function that needs to be read

here is the code with screenshot

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

import os
def readfile(filename):
    if os.path.isfile(filename) is not True: return None
    records=[]
    with open(filename,'r') as infile:
        for line in infile.readlines():
            line = line.strip().split(',')
            if len(line)==4:
                records.append([int(line[0]),line[1].strip(),float(line[2]),int(line[3])])
        return records

def printRecords(records):
    print('{0:<10}{1:<15}{2:>10}{3:>10}{4:>15}'.format('ID','Name','PayRate','Hours','GrossPay'))
    print('='*(60))
    for rec in records:
        if rec[3]<=40:grosspay=rec[2]*rec[3]
        else: grosspay=40*rec[2]+ (rec[3]-40)*rec[2]*1.5
        print('{0:<10}{1:<15}{2:>10}{3:>10}{4:>15}'.format(rec[0],rec[1],'${0:.2f}'.format(rec[2]),rec[3],\
                        '${0:.2f}'.format(grosspay)))

def addRecord(records):
    print('Add Record (enter -999 for ID to quit)')
    while True:
        id = int(input('Enter employee ID: '))
        if id==-999:return
        name=input('Enter employee name: ')
        payrate=float(input('Enter payrate for the employee: $'))
        hours=int(input('Enter hours worked: '))
        records.append([id,name,payrate,hours])

def deleteRecordByID(records):
    print('Enter ID of the employee you want to delete')
    id = int(input('Enter Employee ID you want to delete: '))
    for i in range(len(records)):
        if records[i][0]==id:
            records.pop(i)
            print('Record deleted from empRoster successfully!')
            return
    print('No employee exist with this ID.')



def deleteRecordByLastName(records):
    print('Enter last name of the employee you want to delete')
    lastname = input('Enter Employee Last Name: ').lower()
    for i in range(len(records)):
        if records[i][1][-len(lastname):].lower()==lastname:
            records.remove(records[i])
            print('Record deleted from empRoster successfully!')
            break



def printOvertimeWorkers(records):
    print('Employee who worked overtime(>40 hrs)')
    for rec in records:
        if rec[3]>40:
            print(rec[1])

def main():
    filename='D:\\emp.txt'
    empRoster = readfile(filename)
    if empRoster==None:
        print('Not able to read data from file {}'.format(filename))
    else:
        printRecords(empRoster)
    addRecord(empRoster)
    printRecords(empRoster)
    deleteRecordByID(empRoster)
    printRecords(empRoster)
    deleteRecordByLastName(empRoster)
    printRecords(empRoster)
    printOvertimeWorkers(empRoster)
main()
==================================================================================

import os def readfile (filename): if os.path.isfile (filename is not True: return None records- ] with open (filename, ') as infile: for line in infile.readlines): lineline.strip).split (',) if len (line)-=4: records. append ([int (line [0]),line [1].strip), float (line [2]),int (line [3])) return records def printRecords (records): print ((0: <10) (1: <15) (2:>10) (3:>10) (4:>15) ".format ('ID, Name', 'PayRate,"Hours, 'GrossPay)) print ((60)) for rec in records: if rec31<-40:grosspay-rec [2] rec[3] else: grosspay 40*rec [2]+ (rec[3]-40) *rec[2] *1.5 print ("(0:<10 } { 1 : <15 } { 2 : >10 } { 3 : >10 } { 4 : >15 },"format (rec[0], rec [ 1],'${0: .2f)'.format (rec [ 2 ] ) , rec [3] S10:.2f) .format (grosspay))) def addRecord (records) print (Add Record enter-999 for ID to quit)) while True: id int (input ('Enter employee ID: ')) if id-999: return name-input ('Enter employee name: ') payrate float (input (Enter payrate for the employee: Ş)) hours-int (input ('Enter hours worked: )) records.append ([id, name, payrate, hours])

def deleteRecordByID (records) print ('Enter ID of the employee you want to delete) id - int (input ('Enter Employee ID you want to delete: ') for i in range (len (records)) if records [1] [0]-id: records.pop (i) print('Record deleted from empRoster successfully! 7) return print ("No employee exist with this ID。 ') def deleteRecordByLastName (records) print ('Enter last name of the employee you want to delete) lastname - input ('Enter Employee Last Name ') . lower ) for i in range (len (records)) if records[i] [1] [-len (lastname)]. lower )-lastname: records. remove (records[i]) print('Record deleted from empRoster successfully! 7) break print overt İmeworkers (records) : def rint('Employee who worked overtime(40 hrs)) for rec in records: if rec[3]40: print (rec[1])

def main filename-, D: \\emp . txt , empRoster readfile (filename) if empRoster--None: print ('Not able to read data from file .format (filename)) else: printRecords (empRoster) addRecord (empRoster) printRecords (empRoster) deleteRecordByID (empRoster) printRecords (empRoster) deleteRecordByLastName (empRoster) printRecords (empRoster) printovertimeWorkers (empRoster) main()

thanks !