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