datacamp-logo
Session Ready
Exercise

Counting USA vs. USSR Cold War Olympic Sports

The Olympic competitions between 1952 and 1988 took place during the height of the Cold War between the United States of America (USA) & the Union of Soviet Socialist Republics (USSR). Your goal in this exercise is to aggregate the number of distinct sports in which the USA and the USSR won medals during the Cold War years.

The construction is mostly the same as in the preceding exercise. There is an additional filtering stage beforehand in which you reduce the original DataFrame medals by extracting data from the Cold War period that applies only to the US or to the USSR. The relevant country codes in the DataFrame, which has been pre-loaded as medals, are 'USA' & 'URS'.

Instructions
100 XP
  • Using medals, create a Boolean Series called during_cold_war that is True when 'Edition' is >= 1952 and <= 1988.
  • Using medals, create a Boolean Series called is_usa_urs that is True when 'NOC' is either 'USA' or 'URS'.
  • Filter the medals DataFrame using during_cold_war and is_usa_urs to create a new DataFrame called cold_war_medals.
  • Group cold_war_medals by 'NOC'.
  • Create a Series Nsports from country_grouped using indexing & chained methods:
    • Extract the column 'Sport'.
    • Use .nunique() to get the number of unique elements in each group;
    • Apply .sort_values(ascending=False) to rearrange the Series.
  • Print the final Series Nsports. This has been done for you, so hit 'Submit Answer' to see the result!