Recruiting spend as a proportion of total expenses

Question

Given the following dataset, show the top 10 schools with the highest recruiting cost as a percent of total expenses. Then, show the average recruiting cost as a percent of total expenses by division. You'll need to use the 'RECRUITEXP_TOTAL' and 'GRND_TOTAL_EXPENSE' fields to get the recruiting cost and total expenses. For division classification, you'll need to use 'CLASSIFICATION_NAME'.

To help get you started, below is code (Python) to import the referenced dataset:

# Import libraries
%matplotlib inline
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
import seaborn as sns
# Import data
df = pd.read_csv('https://raw.githubusercontent.com/erood/interviewqs.com_code_snippets/master/Datasets/eada_2019_expense_and_revenue.csv')

Solution

Access restricted

Subscribe to premium account to see the solution.

Get premium now