A jeans factory employees pay roll system works in a manner that if employee works for 8 hrs. they are paid fixed monthly salary. However if any employee works more than 8 hours, is paid with bonus. The bonus chart is such a way that if employee working: Extra 2 hrs, bonus is 100$ Extra 4 hrs, bonus is 200$ Extra 5 hrs, bonus is 550$ "emoloyee - Notepad File Edit Format View Help EmployeeID Name DateOfJoin Working_hours, salary bonus netSalary 9 300$ 50$ 101 Ali 1-09-2021 350$

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%

ASAP!! PLEASE

A jeans factory employees pay roll system works in a manner that if employee works for 8
hrs. they are paid fixed monthly salary. However if any employee works more than 8
hours, is paid with bonus. The bonus chart is such a way that if employee working:
Extra 2 hrs, bonus is 100$
Extra 4 hrs, bonus is 200$
Extra 5 hrs, bonus is 550$
"emoloyee - Notepad
File Edit Format View Help
EmployeeID Name DateofJoin Working_hours, salary bonus netSalary
350$
101
Ali
1-09-2021
9
300$
50$
Write python code that:
a) create a csv file using panda library
b) write at least 5 records of employees
c) write a function calculateBonus () that read data from csv file and perform calcula-
tion based on above chart
d) load the data into panda data frame and save into new csv file , display net salary of
employees
Transcribed Image Text:A jeans factory employees pay roll system works in a manner that if employee works for 8 hrs. they are paid fixed monthly salary. However if any employee works more than 8 hours, is paid with bonus. The bonus chart is such a way that if employee working: Extra 2 hrs, bonus is 100$ Extra 4 hrs, bonus is 200$ Extra 5 hrs, bonus is 550$ "emoloyee - Notepad File Edit Format View Help EmployeeID Name DateofJoin Working_hours, salary bonus netSalary 350$ 101 Ali 1-09-2021 9 300$ 50$ Write python code that: a) create a csv file using panda library b) write at least 5 records of employees c) write a function calculateBonus () that read data from csv file and perform calcula- tion based on above chart d) load the data into panda data frame and save into new csv file , display net salary of employees
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY