# %load q07_unusual_performances/build.py # default imports from greyatomlib.olympics_project_new.q02_country_operations.build import q02_country_operations, q01_rename_columns path = './data/olympics.csv' OlympicsDF = q01_rename_columns(path) OlympicsDF = q02_country_operations(OlympicsDF) def q07_unusual_performances(OlympicsDF, lowq, highq): OlympicsDF = OlympicsDF[:len(OlympicsDF) - 1] high = OlympicsDF['Total'].quantile(0.95) low = OlympicsDF['Total'].quantile(0.05) high_countries = OlympicsDF[OlympicsDF['Total'] > high]['Country_Name'] low_countries = OlympicsDF[OlympicsDF['Total'] <= low]['Country_Name'] high_countries = high_countries[1:] return list(low_countries), list(high_countries) #q07_unusual_performances(OlympicsDF,1,2)
# %load q03_better_event/build.py #default imports from greyatomlib.olympics_project_new.q02_country_operations.build import q02_country_operations, q01_rename_columns import numpy as np #Previous function path = './data/olympics.csv' def q03_better_event(df): OlympicsDF = q02_country_operations(df) OlympicsDF.loc[OlympicsDF['Total_Summer'] < OlympicsDF['Total_Winter'], 'BetterEvent'] = 'Winter' OlympicsDF.loc[OlympicsDF['Total_Summer'] == OlympicsDF['Total_Winter'], 'BetterEvent'] = 'Both' OlympicsDF.loc[OlympicsDF['Total_Summer'] > OlympicsDF['Total_Winter'], 'BetterEvent'] = 'Summer' return OlympicsDF DataFrame = q01_rename_columns(path) q03_better_event(DataFrame)