def q04_country_with_most_gold_medals(path): 'write your solution here' df = q03_summer_gold_medals(path) df['Max_Gold'] = pd.DataFrame(df.iloc[:,1].astype('int64')) + pd.DataFrame(df.iloc[:,6].astype('int64')) return df['Max_Gold'].idxmax()
def q04_country_with_most_gold_medals(path): df = q03_summer_gold_medals(path) dfnew = df['Gold'] total_column = (dfnew.iloc[:, 2:3]) top_max = total_column.loc[df['Gold'].idxmax()] top = (top_max).index[0].replace("\xc2\xa0", "") return top
def q04_country_with_most_gold_medals(path): 'write your solution here' df = q03_summer_gold_medals(path) df1 = df.loc[:,'Gold'] df1.iloc[:,:] = df1.iloc[:,:].apply(pd.to_numeric) df2 = df1.iloc[:,:].sum(axis=1) return df2[df2 == df2.max()].index[0]
def q04_country_with_most_gold_medals(path): "write your solution here" df = q03_summer_gold_medals(path) gold_count = df.iloc[:, 1].sort_values(ascending=False) max_gold_count = gold_count[:1].index country_name = max_gold_count[0] country_with_most_gold_medals = country_name.replace('\xc2\xa0', "") return country_with_most_gold_medals
def q04_country_with_most_gold_medals(path): df = q03_summer_gold_medals(path) df_gold_count = df.iloc[:, [1, 6, 11]] df_gold_count = df_gold_count.astype('int') df_gold_count['Total'] = df_gold_count.sum(axis=1) df_gold_final = df_gold_count.iloc[:, -1].reset_index() df_gold_final = df_gold_final[df_gold_final['Total'] == df_gold_final.Total.max()] return df_gold_final.iloc[0, 0]
def q04_country_with_most_gold_medals(path): 'write your solution here' df = q03_summer_gold_medals(path) gold_count = df.iloc[:, 1].sort_values(ascending=False) df['gold_count'] = gold_count max = gold_count.max() a = df[df['gold_count'] == max] aa = a.index aaa = aa[0] return aaa
def q04_country_with_most_gold_medals(path): "write your solution here" df = q03_summer_gold_medals(path) return (df.index[df.iloc[:, 11] == max(df.iloc[:, 11])][0])
def q04_country_with_most_gold_medals(path): "write your solution here" df = q03_summer_gold_medals(path) return df.iloc[:, 2].idxmax()
def q04_country_with_most_gold_medals(path): 'write your solution here' df = q03_summer_gold_medals(path) df1 = df.iloc[1:, [1, 6, 11]].astype(int).sum(axis=1).sort_values( ascending=False).reset_index() return df1['country name'][0].replace('\xa0', '')
def q04_country_with_most_gold_medals(path): "write your solution here" df = q03_summer_gold_medals(path) return "Srilanka"