Challenge #164: Retail Therapy

[AnaisComyn]

Done ! 

[kzielinski19]

Fun challenge although I wish the objective was worded differently... The solution was expecting you to only include items that at least 10 other customers marked as helpful whereas I was led to believe that any item marked as helpful to another customer (i.e.: Positive Feedback Count greater than 0 indicated a positive feedback review) was to be included. Took me forever to understand that!

[psampaio005]

Here is my solution !!!

Spoiler

[bmcclelland46]

My solution.

Spoiler

[RNG]

.

[JoePC]

Solution Attached

[Qiu]

Not difficult one

Spoiler

[Inactive User]

Here is a different solution from my end

[soroosj]

Spoiler

[Tony_Castillo]

I should've read some of the other solutions before comparing results as it would've saved me time in researching the discrepancy. But, since I spent the time researching the difference I'll go ahead and provide my assessment in hopes of saving time for others.

The 'discrepancy' of clothing id is actually an issue with the provided solution. As shown below in the first spoiler, the Unique tool is pulling from the pre-filtered data set. This then joins the unique prefiltered data with the average ratings, thereby re-adding the clothes with < 10 positive feedback count. Therefore, the provided end results are incorrect and Clothing ID 1119 under Class Name Jackets should not be in the final results. Instead, ID 1119 responses from Class name Outerwear should be included.

Spoiler

The below is shows the correct results.

Spoiler