A solution to last week’s challenge can be found here.
The Eurovision Song contest or Eurovision is an annual song competition in Europe.
During a live show, contestants representing European countries, sing a song and receive points. The contestant with the most points wins. In 1974, the Swedish group ABBA became a household name in Europe by winning this contest with the song "Waterloo".
The dataset for this challenge provides information about the Eurovision from 1975 to 2019. The column “Edition” contains a date followed by one or two initials “f” or “fs”. For this challenge, use the values followed by “f”.
Use the dataset to:
- Find out which country has won the contest from 1975 to 2019
- List by descending order the countries who have won the most time between these dates
Hint
A country cannot give points to its representative. Make sure to take this rule into consideration. Mistakes happen in datasets.
It's true that the analysis overlooks the "draw" in 1991, that was actually won by Swedish song. Nonetheless, a cool weekly challenge!
