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')
    

Our solution will be written using Python for premium users.