Answering simple questions about a dataset

Let's take an example to look at a few questions and answer them. Say the HR director asks you to answer a few descriptive questions about the employees of the company. The following are a few such questions:

• How many employees are there by department in the dataset?
• What is the overall attrition rate?
• What is the average hourly rate?
• What is the average number of years at the company?
• Who are the five employees with the most number of years at the company?
• How satisfied are employees overall?

Total employees by department in the dataset

To view the departments in the dataset, you use the data['Department'] statement. We get the column called Department, which is...