Chp 10

Question 1

Given the following DataFrame named oo , which three countries have won the most medals in recent years (from 1984 to 2008)?

Fill the blank.

rec = oo[oo.Edition >= 1984]
rec[“NOC”]._______.head(3)

Answer 1

value_counts()

Question 2

Given the following DataFrame named oo, list only the NOC column.

Answer 2

oo[‘NOC’]
oo.NOC
oo.iloc[:,5]
oo[“NOC”]

Question 3

Given the following DataFrame named oo , list the total number of medals awarded at each of the Olympic games throughout history.

Fill the blank.

oo.groupby(_____).size()

Answer 3

‘Edition’
“Edition”

Question 4

Given the following DataFrame named oo , in which events did “HERSCHMANN, Otto” win a medal?

Fill the blank.

oo[________][‘Event’]

Answer 4

oo.Athlete == ‘“HERSCHMANN, Otto”
oo.Athlete == ‘HERSCHMANN, Otto’
oo[“Athlete”] == ‘HERSCHMANN, Otto’
oo[‘Athlete’] == ‘HERSCHMANN, Otto’
oo[‘Athlete’] == “HERSCHMANN, Otto”
oo[“Athlete”] == “HERSCHMANN, Otto”
oo.Athlete.str.contains(‘HERSCHMANN, Otto’)
oo.Athlete.str.contains(“HERSCHMANN, Otto”)
oo[“Athlete”].str.contains(“HERSCHMANN, Otto”)
oo[‘Athlete’].str.contains(“HERSCHMANN, Otto”)
oo[“Athlete”].str.contains(‘HERSCHMANN, Otto’)
oo[‘Athlete’].str.contains(‘HERSCHMANN, Otto’)
oo.Athlete==’“HERSCHMANN, Otto”
oo.Athlete==’HERSCHMANN, Otto’
oo[“Athlete”]==’HERSCHMANN, Otto’
oo[‘Athlete’]==’HERSCHMANN, Otto’
oo[‘Athlete’]==”HERSCHMANN, Otto”
oo[“Athlete”]==”HERSCHMANN, Otto”

Question 5

Given the following DataFrame named oo , list the total number of medals won for each country for each year over the history of the Olympics.

oo.groupby(____).size()

Answer 5

[‘Edition’, ‘NOC’]
[‘Edition’, ‘“NOC”]
[“Edition”, ‘NOC’]
[“Edition”, “NOC”]
[‘NOC’, ‘Edition’]
[‘“NOC”, ‘Edition’]
[‘NOC’, “Edition”]
[“NOC”, “Edition”]