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)