Challenge #288: Client's Rating Analysis

[AYXAcademy]

A solution for last week's challenge can be found here.

For this  week's challenge, you are provided two datasets:

- The first one (Clients) contains each client's information including their Client ID
- The second one (Request & Evaluation) contains the client's Request number (which is the same as the Client ID),  "Status" which indicates if the request has been processed, "Status2" provides a comment, and the "Professional"  field is the name of the customer.

Your tasks are to determine:

- For a "Status" of Evaluated, the number of customers ("Professional") who commented "Below Expectations", "Exceeded Expectations", or "Met Expectations" for "Status2"
- The three customers ("Professional") who provided the highest average rating

[JITHINPR]

mySolution

[JasonHu]

Here is my submission.

Spoiler

[PhilipMannering]

Solution attached,

Spoiler

[PhilipMannering]

Solution in Python Tool

Spoiler

[binuacs]

Spoiler

[AkimasaKajitani]

My solution.

Spoiler

[nickhernigle]

Here is my solution. 

[justindavis]

Spoiler

[Maskell_Rascal]

Here is my solution!

Spoiler

Cheers!

Phil