Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #321: Eurovision

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.

 

The Eurovision Song contest or Eurovision is an annual song competition in Europe. image_321.png

 

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.

CHarrison
8 - Asteroid

As a Brit, I am incredibly satisfied with the results this year :D

IraWatt
17 - Castor
17 - Castor

Very cool challenge though not sure who won in 1991, Sweden or France?

Spoiler
IraWatt_0-1653919498539.png

 

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
W321.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1653921327657.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1653922733959.png

 

sergejs_kutkovics
9 - Comet

According to Wiki Sweden won 1991.

Spoiler
sergejs_kutkovics_1-1653979676195.png

 

Renzo123
5 - Atom

Interesting exercise, see my solution below

 

Spoiler
Renzo123_5-1653927616699.png

 

GabrielDiniz
7 - Meteor
Spoiler
SpoilerGabrielDiniz_0-1653931590712.png

It's true that the analysis overlooks the "draw" in 1991, that was actually won by Swedish song. Nonetheless, a cool weekly challenge!

MuralidharAreti
8 - Asteroid

My solution: 

 

Spoiler
MuralidharAreti_1-1653941439395.png