Workers of Maunlad corp. have a regular working hours of 40 hours per week and
are paid with an hourly rate of P150 per hour. However, if a worker rendered more
than 40 hours in a week the excess hours are paid 75% more. Write a program that
inputs the number of hours rendered by a worker in 1 week then display his/her
salary.
Create a dataframe by using the dataset [tipsnew.csv] and perform the
following operations
a) Print the day value when the value of total_bill is maximum and
minimum.
b) Retrieve all the rows from dataframe when the value of tip is more
than 3.0 and less than 5.0
c) Print the time of the meal and gender of the person who paid the tip
more than 5.0
d) Select and display last 10 rows from the dataframe when customer
smoking habbit is ‘yes’
e) Create the newdataframe(ndf) from original dataframe(df)
containing all rows and the following columns [total_bill tip, size].
Sort and display all values of column tip in ascendending order.
Discuss different ways of creating a dataframe in python programming
languages using panda library. Justify your answer with the help of
suitable example.
Department Number of Users
Customer Care 10
Sales and Marketing 20
Finance 25
Legal 5
HR 10
Developers 55
Network Team 5
Server Room
Servers +ISP connections
· All the departments must be separated with unique subnet and should not communicate with each other unless there is a special requirement.
· IPs should assign using DHCP.
· ERP and CRM Systems need to be implemented in this in local servers.
· Number of servers required for the Server room need to Uses static IPs.
· High level of redundancy expect in network design to eliminate single point of failures and traffic bottle necks.
· Sales and Marketing need to access Network resources using WIFI connectivity.
· Proper methods for networking monitoring and troubleshooting need to be established.
· All possible network security mechanisms should implement.
The list of devices, network components and software used to design the network for above scenario and while justifying your selections. Create a suitable network in packet tracer.
Department Number of Users
Customer Care 10
Sales and Marketing 20
Finance 25
Legal 5
HR 10
Developers 55
Network Team 5
Server Room
Servers +ISP connections
· All the departments must be separated with unique subnet and should not communicate with each other unless there is a special requirement.
· IPs should assign using DHCP.
· ERP and CRM Systems need to be implemented in this in local servers.
· Number of servers required for the Server room need to be Uses static IPs.
· High level of redundancy is expected in network design to eliminate single point of failures and traffic bottle necks.
· Sales and Marketing need to access Network resources using WIFI connectivity.
· Proper methods for networking monitoring and troubleshooting need to be established.
· All possible network security mechanisms should be implemented.
· Develop test cases and conduct verification to test the above Network and analyses the test results against the expected results.
Department Number of Users
Customer Care 10
Sales and Marketing 20
Finance 25
Legal 5
HR 10
Developers 55
Network Team 5
Server Room
Servers +ISP connections
· All the departments must be separated with unique subnet and should not communicate with each other unless there is a special requirement.
· IPs should assign using DHCP.
· ERP and CRM Systems need to be implemented in this in local servers.
· Number of servers required for the Server room need to be Uses static IPs.
· High level of redundancy is expected in network design to eliminate single point of failures and traffic bottle necks.
· Sales and Marketing need to access Network resources using WIFI connectivity.
· Proper methods for networking monitoring and troubleshooting need to be established.
· All possible network security mechanisms should be implemented.
Provide examples for networking software that can be used in above network design.
Department Number of Users
Customer Care 10
Sales and Marketing 20
Finance 25
Legal 5
HR 10
Developers 55
Network Team 5
Server Room
Servers +ISP connections
· All the departments must be separated with unique subnet and should not communicate with each other unless there is a special requirement.
· IPs should assign using DHCP.
· ERP and CRM Systems need to be implemented in this in local servers.
· Number of servers required for the Server room need to be Uses static IPs.
· High level of redundancy is expected in network design to eliminate single point of failures and traffic bottle necks.
· Sales and Marketing need to access Network resources using WIFI connectivity.
· Proper methods for networking monitoring and troubleshooting need to be established.
· All possible network security mechanisms should be implemented.
Recommend servers for the above scenario and justify your selection with valid points.
Output all the odd numbers between firstNum and secondNum inclusive.
Program to get the count of notes and shows the denomination
COMPLETE THIS CODE(DONT CHANGE)
package myqueue_J;
public class MyQueue_J {
public int data;
public MyQueue_J next;
public static MyQueue_J front=null;
public static MyQueue_J rear=null;
public static MyQueue_J temp=null;
public MyQueue_J(int d, MyQueue_J n) {
data=d;
next=n;
}
public static void enqueue(int d){
MyQueue_J temp = new MyQueue_J(d, null);
Insert to perform enqueue operation
}
public static void dequeue(){
Insert to perform dequeue operation
}
public static int printQueue(){
int ctr=0;
Insert to display the elements in the queue
}
public static void main(String[] args) {
Insert to perform the desired output
}
}
THE OUTPUT
After the Enqueue operations:
1. Element Front: 10
2. Element rear: 30
3. Elements in the Queue: 10 15 20 25 30
4. Number of Elements in the Queue: 5
The dequeued element is 10.
The dequeued element is 15.
After the Dequeue operations:
1. Element Front: 20
2. Element rear: 30
3. Elements in the Queue: 20 25 30
4. Number of Elements in the Queue: 3