Question
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
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 totalStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started