Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This program has to follow the pseudocode and has to be in python cb1data.txt IT,D4772,1,2,2011,8.25 IT,D4772,1,3,2011,7.00 IT,D4772,1,5,2011,9.25 IT,D4772,1,6,2011,9.00 IT,D4772,1,8,2011,7.25 IT,F9642,1,4,2011,8.25 IT,F9642,1,6,2011,7.25 IT,F9642,1,7,2011,5.25 IT,F9642,1,8,2011,8.00 IT,V1001,1,3,2011,5.25 IT,V1001,1,4,2011,8.50

image text in transcribedimage text in transcribedimage text in transcribed

This program has to follow the pseudocode and has to be in python

cb1data.txt

"IT","D4772",1,2,2011,8.25 "IT","D4772",1,3,2011,7.00 "IT","D4772",1,5,2011,9.25 "IT","D4772",1,6,2011,9.00 "IT","D4772",1,8,2011,7.25 "IT","F9642",1,4,2011,8.25 "IT","F9642",1,6,2011,7.25 "IT","F9642",1,7,2011,5.25 "IT","F9642",1,8,2011,8.00 "IT","V1001",1,3,2011,5.25 "IT","V1001",1,4,2011,8.50 "IT","V1001",1,5,2011,6.75 "IT","V1001",1,6,2011,6.75 "IT","V1001",1,7,2011,8.00 "IT","V1001",1,8,2011,6.00 "MGT","A0010",1,2,2011,6.50 "MGT","A0010",1,3,2011,8.25 "MGT","A0010",1,4,2011,9.25 "MGT","A0010",1,5,2011,9.75 "MGT","A0010",1,6,2011,5.50 "MGT","A0010",1,7,2011,8.75 "MGT","A0010",1,8,2011,8.75 "MGT","S0812",1,4,2011,5.25 "MGT","S0812",1,5,2011,7.75 "MGT","S0812",1,6,2011,7.25 "MGT","S0812",1,7,2011,6.00 "MGT","S0812",1,8,2011,9.50 "MKT","H6554",1,2,2011,9.25 "MKT","H6554",1,3,2011,8.00 "MKT","H6554",1,4,2011,5.75 "MKT","H6554",1,5,2011,8.75 "MKT","H6554",1,6,2011,8.50 "MKT","H6554",1,8,2011,6.00 "MNT","E5109",1,2,2011,8.75 "MNT","E5109",1,3,2011,5.50 "MNT","E5109",1,4,2011,6.00 "MNT","E5109",1,6,2011,5.00 "MNT","E5109",1,8,2011,6.50 "MSC","E4100",1,3,2011,5.75 "MSC","E4100",1,4,2011,8.75 "MSC","E4100",1,5,2011,7.25 "MSC","E4100",1,7,2011,6.50 "MSC","E4100",1,8,2011,8.75 "PRD","A0132",1,4,2011,9.00 "PRD","A0132",1,5,2011,8.00 "PRD","A0132",1,6,2011,8.75 "PRD","A0132",1,7,2011,9.00 "PRD","A0132",1,8,2011,5.00 "PRD","E1231",1,2,2011,6.75 "PRD","E1231",1,3,2011,8.25 "PRD","E1231",1,4,2011,6.75 "PRD","E1231",1,6,2011,8.00 "PRD","E1231",1,7,2011,5.50 "PRD","E1231",1,8,2011,7.25 "PRD","E1250",1,2,2011,9.75 "PRD","E1250",1,3,2011,7.75 "PRD","E1250",1,4,2011,7.75 "PRD","E1250",1,5,2011,7.50 "SLS","L1776",1,2,2011,9.00 "SLS","L1776",1,3,2011,7.75 "SLS","L1776",1,4,2011,6.75 "SLS","L1776",1,6,2011,5.50 "SLS","L1776",1,8,2011,8.75 "SLS","M5205",1,2,2011,7.00 "SLS","M5205",1,3,2011,5.00 "SLS","M5205",1,4,2011,7.75 "SLS","M5205",1,5,2011,6.00 "SLS","M5205",1,6,2011,7.75 "SLS","M5205",1,7,2011,5.25 "SLS","M5205",1,8,2011,8.25

Objectives . Read data from a sequential access text file .Convert a line of data into its constituent fields . Correctly erd file input loop when end of file is reBched Process control breaks ooreclly . Calculate sums for groupings of input data * Implement an algorithm Properly format output data on a report Program requirements This assignment involves the creation of a level break report by correctly implementing the supplied algorithm in Python The data must he in correct sorted order for this algorithm to work The supplied data file has already been put into the proper sorted order. Your prograrn must read each of the records from the data file, parse the reoord into fiekds, and produce a control break report to a disk file rarned cb1rpt.txt. Your report should match the semple report execu in udin ALL ormalling and spacaw. Please note that since ou re seriding it to a disk ile ou w not see lhe report on lscreen when you run lhe prograrn. You can vw lt later b opening it up in a text ed tor The fields for each record are comma separated The string fields have quote marks surrounding them, Look at the data file to see a detailed view The format of each record is as follows * department string * employee id: sting * month: integer day: integer , year integer hours: floating point number The data file needed for this assignment is located at: chidata txt. Sample Output Daily hours worked by Department by Employee Dept EmpID Date Hours IT D4772 1/92/2011 8.25 IT D4772 1/03/2011 7.00 IT D4772 1/95/2011 9.25 IT D4772 1/06/2011 9.00 IT D4772 1/08/2011 7.25 40.75 Employec total IT F9642 1/04/2011 8.25 IT F9642 1/06/211 7.25 IT F9642 1/07/2011 5.25 IT F9642 1/08/2011 8.80 28.75 Employee total Objectives . Read data from a sequential access text file .Convert a line of data into its constituent fields . Correctly erd file input loop when end of file is reBched Process control breaks ooreclly . Calculate sums for groupings of input data * Implement an algorithm Properly format output data on a report Program requirements This assignment involves the creation of a level break report by correctly implementing the supplied algorithm in Python The data must he in correct sorted order for this algorithm to work The supplied data file has already been put into the proper sorted order. Your prograrn must read each of the records from the data file, parse the reoord into fiekds, and produce a control break report to a disk file rarned cb1rpt.txt. Your report should match the semple report execu in udin ALL ormalling and spacaw. Please note that since ou re seriding it to a disk ile ou w not see lhe report on lscreen when you run lhe prograrn. You can vw lt later b opening it up in a text ed tor The fields for each record are comma separated The string fields have quote marks surrounding them, Look at the data file to see a detailed view The format of each record is as follows * department string * employee id: sting * month: integer day: integer , year integer hours: floating point number The data file needed for this assignment is located at: chidata txt. Sample Output Daily hours worked by Department by Employee Dept EmpID Date Hours IT D4772 1/92/2011 8.25 IT D4772 1/03/2011 7.00 IT D4772 1/95/2011 9.25 IT D4772 1/06/2011 9.00 IT D4772 1/08/2011 7.25 40.75 Employec total IT F9642 1/04/2011 8.25 IT F9642 1/06/211 7.25 IT F9642 1/07/2011 5.25 IT F9642 1/08/2011 8.80 28.75 Employee total

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Database Technology Management For The Year 2000

Authors: Alan Simon

1st Edition

155860264X, 978-1558602649

More Books

Students also viewed these Databases questions