Data Interview Qs - College football expenses by conference

Given the following dataset on college sports operating expenses and this dataset that classifies a subset of schools into their respective football conference, show the school in each conference that has the highest football program expense, along with the average football program cost for all schools in the conference. Your output should contain the following fields:

• Conference
• Average conference spend on football
• College with highest spend
• Football spend of college with highest spend

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')
    
df_map = pd.read_csv('https://raw.githubusercontent.com/erood/interviewqs.com_code_snippets/master/Datasets/college_id_to_conference.csv')
    

Our solution will be written using Python for premium users.