The dataset in question is basically Olympics medal tally. The dataframe has the below mentioned columns with the Name of the country as Index.
It is a (146, 16) dataset.
#Summer Gold Silver Bronze Total #Winter Gold.1 Silver.1 Bronze.1 Total.1 #Games Gold.2 Silver.2 Bronze.2 Combined total
I am tasked with finding the country which have the biggest difference between their summer and winter gold medal counts.
def answer_two():
diff= []
for i in range(5):
diff.append(df[df.columns[1][i]]- df[df.columns[6][i]])
return diff.idxmax()
This was what i tried. But i am getting KeyError. What should I do?
SQL Oracle is very easy to do it. Find record if when the condition is satisfied. Stored procedure can be used to run some functions then find row_number or recId.
You can try using numpy's library (very efficient), the following will give you the index:
numpy.argmax(df['Gold']-df['Gold.1'])
if the country is the index itself it will return it right away, otherwise, you can always call the vector of the indexes and select the position (i.e. index) that the function argmax gives to you
- Badges
- Science topic
- Similar topics
- Analytical Chemistry
- Column