Question: do all this questions in PYTHON , Panda : Exercise 2: create index on eid find total number of employees find number of male and

do all this questions in PYTHON , Panda :

Exercise 2:

create index on eid

find total number of employees

find number of male and female employees

find max, min and average salary in each department

find all employees with salary>x (choose x based on your data)

find all female employees with age>x (choose x based on your data)

how many male or female employee are working in each department?

what is the min, max, average of salaries in the company

show department and name of employee with id x (choose x based on your data)

delete all male emploees with salary greater than x or less than y (choose x and y based on your data)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Business memorelating to Audit. All questions and materials needed are attached. Please, ensure you are familiar with auditing before accepting this project. Thank you. THE ACCOUNTING REVIEW Vol. 90,...

Q:

For this assignment, please submit one Excel file. Use a separate worksheet for each question set and label the worksheets. To rename a worksheet, right - click the worksheet tab located at the...

Q:

For this assignment, please submit one Excel file. Use a separate worksheet for each question set and label the worksheets. To rename a worksheet, right - click the worksheet tab located at the...

Q:

Python: Titanic Data with pandas Q1-1 . use read_csv function to read in the data as df Q1-2 . Verify that you get 891 lines of data (print the number of rows) Q1-3 . print the first ten (head...

Q:

BA 1605: Midterm Recap (Due: Feb. 27, 2015) Name _____________________________ 50 Student ID _____________________________ Section 01B 10:00~11:20 am Section 02B 01:00~02:20 pm [Questions 4 ~ 7] The...

Q:

I had copied and pasted my lab, I don't understand how to do the histogram and statistical portion of this lab. Item 5: In-Lab Exercises (15 points) Exercise 1: Canine Variability In this part of the...

Q:

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 65.1 27 36.1 61.4 46.6 73.3 39.7 23.2 74.6 22.8 23.4 62 40.7 23 24 51.1...

Q:

import javafx.beans.value.ChangeListener; import javafx.beans.value.ObservableValue; import javafx.geometry.Insets; import javafx.scene.Node; import javafx.scene.control.*; import...

Q:

Let's begin by familiarizing ourselves with the use of ArrayList objects. Examine the class called ArrayListTestProgram . It does not compile. The compiler will complain, stating that Variable...

Q:

use the code r Script below to Answer the questions from number 3 to 7 Questions : 3. Model #1 - First Logistic Regression Model Reporting Results Report the results of the regression model. Address...

Q:

Using Laplace transforms find the solution of the following Initial value problems. d?y dy(0) (i) +y = 2 y(0) = 0, = 2 dt dt2

Q:

An experiment was conducted to observe the effect of an increase in temperature on the potency of an antibiotic. Three one ounce portions of the antibiotic were stored for equal lengths of time at...

Q:

21 Look at this sequence of subtractions. 3 6 = 3 3 4 = 1 3 2 = 3 0 = 3 2 = 3 4 = a Copy the sequence and fill in the missing answers. b Write the next three lines in the sequence. c Describe...

Q:

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Q:

1 How could the problems in the Blue Sword joint venture, leading to its eventual failure, have been avoided?

Q:

Praise. Companies do not praise their employees very often. Individual praise in front of the group is not often used deliberately except in the hotel industry. A view elsewhere is that this may be...

Q:

Pressure and punishment. Direct punishment was found only in the hotel sector, where some companies punish their staff for bad behaviour and not working. Deductions from salary or bonuses are seen to...