Recruiting spend as a proportion of total expenses
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')
Subscribe to premium account to see the solution.Get premium now