Challenge 18 - Eurovision Insights

<p>Challenge 18 - Eurovision Insights</p><p><strong>Level:</strong> Easy</p><p><strong>Description: </strong>Eurovision is full of surprises—not just in performances but also in how different countries score. A song might be a fan favorite with high televote support yet receive low jury points, or certain musical styles might consistently have higher energy levels than others. In this challenge, you'll explore key aspects of Eurovision scoring and song characteristics using KNIME. Look at the dataset and answer these questions:</p><ol><li><p>Which country had the biggest gap between final_televote_points and final_jury_points?</p></li><li><p>Among all songs that qualified for the final (qualified_10 = 1), which style has the highest average BPM?</p></li></ol><p><strong>Beginner-Friendly Objectives:</strong></p><ol><li><p>Learn how to import a CSV file into KNIME.</p></li><li><p>Perform calculations between columns.</p></li><li><p>Sort a table using a specific criterion.</p></li><li><p>Convert string into number data type</p></li></ol><p><br><strong>Solution Summary:</strong></p><ol><li><p>Norway in 2019 with 251 point difference</p></li><li><p>Rock with 121.941 BPM</p></li></ol><p><strong>Solution Details:</strong></p><ol><li><p>To determine which country had the biggest gap between final_televote_points and final_jury_points, we first create a new column that calculates the difference between these two values (Points_Diff = final_televote_points - final_jury_points). Sorting the dataset in descending order by this new column reveals the country that experienced the largest disparity between the public and jury votes.</p></li></ol><ol start="2"><li><p>To identify which musical style had the highest average BPM among songs that qualified for the final, we filter the dataset to only include entries where qualified_10 = 1. We then group the data by style and calculate the mean BPM for each category. Sorting these values in descending order allows us to determine the most up-tempo style.</p></li></ol>