import pandas as pd
df= pd.read_csv('https://raw.githubusercontent.com/frishberg/Archive-of-US-News-College-Rankings/refs/heads/main/data.csv')
Run to view results
df = df.head(50)[['Name', '2025', '2024', '2023', '2022', '2021', '2020', '2019', '2018', '2017', '2016', '2015', '2014', '2013', '2012', '2011']]
Run to view results
df
Run to view results
df['Average Ranking'] = df.iloc[:, 1:].mean(axis=1)
df[['Name', 'Average Ranking']].sort_values(by='Average Ranking', ascending=True).reset_index(drop=True)
Run to view results