Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Task 1 a. Develop a program to serve user requests to get stats on the employee base (emp_base_salaries_homework3.csv) salary file b. This base salary file (emp_base_salaries_homework3.csv) is provided in your blackboard homework3 section c. This program will read user inputs as the program parameters at the execution of the program d. You should be using python's argarse module to read the python command line arguments e. You must use try except block for any know error processing and show meaningful message in the output of the except block Following will be the options for command line arguments 1. -totalemp.count or 1. This option should give the total employees in the file 2-lookup key or f. I 1. This option will lookup for the employee record based on the lookup key which the user wants to lookup for. 2. This option requires additional parameters to be passed. Those additional parameters are a. -lookup_value i. This is the value of the lookup key which the user wants to search. For example if lookup_key is id then value can be any employee id ex employee id 105 b. -return key value or L Here return key value is the value of which key does user wants to see. For example if user passess lookup key as Id and lookup_value as 105 and return key value as BasePay then the expected result is 134401.6 c-smp_totalPay (Sum of BasePay. OvertimePay. OtherPay. and Benefits) 3.-sum totalPay 1. It is sum of totalPay (Sum of BasePay, OvertimePay, OtherPay. and Benefits) of all employees You must write separate functions for each of the calculation of each of the options. h. These functions should be written in separate python utility file and should be imported in the main processing file L You should name this utility file as Inetid) homework3_util.py

Task 1 a. Develop a program to serve user requests to get stats on the employee base (emp_base_salaries_homework3.csv) salary file b. This base salary file (emp_base_salaries_homework3.csv) is provided in your blackboard homework3 section c. This program will read user inputs as the program parameters at the execution of the program d. You should be using python's argarse module to read the python command line arguments e. You must use try except block for any know error processing and show meaningful message in the output of the except block Following will be the options for command line arguments 1. -totalemp.count or 1. This option should give the total employees in the file 2-lookup key or f. I 1. This option will lookup for the employee record based on the lookup key which the user wants to lookup for. 2. This option requires additional parameters to be passed. Those additional parameters are a. -lookup_value i. This is the value of the lookup key which the user wants to search. For example if lookup_key is id then value can be any employee id ex employee id 105 b. -return key value or L Here return key value is the value of which key does user wants to see. For example if user passess lookup key as Id and lookup_value as 105 and return key value as BasePay then the expected result is 134401.6 c-smp_totalPay (Sum of BasePay. OvertimePay. OtherPay. and Benefits) 3.-sum totalPay 1. It is sum of totalPay (Sum of BasePay, OvertimePay, OtherPay. and Benefits) of all employees You must write separate functions for each of the calculation of each of the options. h. These functions should be written in separate python utility file and should be imported in the main processing file L You should name this utility file as Inetid) homework3_util.py

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
Review View Tell me 2 IN DUI TTUITIC WORKS go ¶ I AaBbccDite Normal Task 11 a. Develop a program to serve user requests to get stats on the employee base (emp_base_salaries_homework3.csv) salary file b. This base salary file (emp_base_salaries_homework3.csv) is provided in your blackboard homework3 section Ao Boccer No Spacing c. This program will read user inputs as the program parameters at the execution of the program d. You should be using python's argrarse module to read the python command line AaBbCcDe Heading 1 arguments e. You must use try except block for any know error processing and show f. meaningful message in the output of the except block Following will be the options for command line arguments 1. -total.emp.count or 1. This option should give the total employees in the file 2.-lookup key or 1. This option will lookup for the employee record based on the lookup..key which the user wants to lookup for. 3. -sum totalPay 2. This option requires additional parameters to be passed. Those additional parameters are a. -lookup_valus b. -return key value or i. This is the value of the lookup key which the user wants to search. For example if lookup_key, is id then value can be any employee id ex: employee id 105 1. Here return key value is the value of which key does user wants to see. For example if user passess lookup key as ld and lookup_value as 105 and return key value as BasePay then the expected result is 134401.6 c-smp_totalPay (Sum of BasePay. OvertimePay. OtherPay. and Benefits) 1. It is sum of totalPay (Sum of BasePay, OvertimePay. OtherPay. and Benefits) of all employees g. You must write separate functions for each of the calculation of each of the options. h. These functions should be written in separate python utility file and should be imported in the main processing file L You should name this utility file as Ingtid) homework3_util.py
Transcribed Image Text:Review View Tell me 2 IN DUI TTUITIC WORKS go ¶ I AaBbccDite Normal Task 11 a. Develop a program to serve user requests to get stats on the employee base (emp_base_salaries_homework3.csv) salary file b. This base salary file (emp_base_salaries_homework3.csv) is provided in your blackboard homework3 section Ao Boccer No Spacing c. This program will read user inputs as the program parameters at the execution of the program d. You should be using python's argrarse module to read the python command line AaBbCcDe Heading 1 arguments e. You must use try except block for any know error processing and show f. meaningful message in the output of the except block Following will be the options for command line arguments 1. -total.emp.count or 1. This option should give the total employees in the file 2.-lookup key or 1. This option will lookup for the employee record based on the lookup..key which the user wants to lookup for. 3. -sum totalPay 2. This option requires additional parameters to be passed. Those additional parameters are a. -lookup_valus b. -return key value or i. This is the value of the lookup key which the user wants to search. For example if lookup_key, is id then value can be any employee id ex: employee id 105 1. Here return key value is the value of which key does user wants to see. For example if user passess lookup key as ld and lookup_value as 105 and return key value as BasePay then the expected result is 134401.6 c-smp_totalPay (Sum of BasePay. OvertimePay. OtherPay. and Benefits) 1. It is sum of totalPay (Sum of BasePay, OvertimePay. OtherPay. and Benefits) of all employees g. You must write separate functions for each of the calculation of each of the options. h. These functions should be written in separate python utility file and should be imported in the main processing file L You should name this utility file as Ingtid) homework3_util.py
Expert Solution
steps

Step by step

Solved in 3 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
File Input and Output Operations
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS