Challenge #338: Let's Summarize!

[AYXAcademy]

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.

[RolandSchubert]

Spoiler

[peter_gb]

I was unable to locate any records with a Null release year using the following:

Spoiler

Year: Right([rel_date],4)

This obviously means my solution doesn't match but I'm happy with it I think - please correct me if I'm mistaken!

Spoiler

 

Still, a fantastic challenge for learning some alternative configs of the Summarise tool. 

[Kenda]

Spoiler

Agree expectations after reading prompt versus given output don't match, but here is my attempt... 

[patrick_digan]

Spoiler

I didn't like how the genres were repeated so many times, so I cleaned that field up a little bit with some extra summarizes.

[MilindG]

Spoiler

[binuacs]

Spoiler

[ahsanaali]

Spoiler

Spoiler

Spoiler

Removing duplicate Genre(s)

[mmontgomery]

Challenge #338

Spoiler

[Sebastian_Chaieb2]

My Solution in attachment. 

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. 

In my solution I user RegEx for year parsing.

Spoiler

Thanks,

Sebastian