This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
A solution to last week’s challenge can be found here.
Are you wondering which artists produced the top songs? Do you want some insights? This challenge is for you.
The following dataset contains information about the top 500 songs. Using the dataset, find the top 50 artists with the most albums and the highest average rating. Include the following columns in your list :
- Artist(s) - Number of albums (Descending) - Average rating based on all albums (Descending) - Album title(s) - Average number of reviews based on all albums (Descending) - Genre(s) - Year the first album was released - Year the last album was released
Note: If in your solution you have null records for the Release Year, do not include them.
This challenge was updated to propose 2 start files and 2 solutions.
However! I have to disagreed wth the presented results (or I did not understand the objectivse) but in example of Artist "", in the expected output for this artst wa no Max date (last release date) and min was also wrong year.