A solution to last week’s challenge can be found here.
The first Olympic games were held in Athens in 1896 and only male athletes could participate. Female athletes were admitted in 1900 but they were excluded from certain events. For this challenge, we will look at the data from 1900 to 1936 for the Summer Olympic Games.
The “Participant” dataset includes the sport, the Olympic ID, the athlete’s name, and their country.
The “Details” dataset includes an ID, the Olympic ID, the Games (year and City), and the Medal won or not.
Use both datasets to:
- Find the number of female athletes who participated in each Olympic Games from 1900 to 1936 and, create a chart of your choice to show the results.
- Create a report of the athletes who received a medal for each game including the Olympic ID, the name of the athlete, the country, the game, the sport, and the medals received.
Figure Skating was listed as one of the sport for the 1908 Summer Olympics.