Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #164: Retail Therapy

dipan_mitra
7 - Meteor

Dipan Mitra => Challenge #164: Retail Therapy

ALTSkelly
8 - Asteroid
Spoiler
ALTSkelly_0-1642427930900.png

 

KYNS
6 - Meteoroid
Spoiler
KYNS_0-1642474079508.png

 

davidhardister
8 - Asteroid

davidhardister_0-1642706751858.png

 

sgao
7 - Meteor

Solution

Bart777
6 - Meteoroid

Bart777_0-1642882979295.png

 

swlsherry
7 - Meteor

my solution!

markjperkins
7 - Meteor

OK... I'm going to be controversial!  I don't think the answer is correct.  We are asked to only include items of clothing that have at least 10 positive feedback (NOT only include reviews that have at least 10 positive feedback).  If you look at the data for a given product you can see that the positive feedback count increments over time (as more reviews are added).

 

markjperkins_0-1643280628442.png

 

I would argue that we should identify distinct product ids that have at least 1 review showing a positive feedback count of at least 10, THEN JOIN the distinct product ids back oto the original reviews in order that ALL reviews for that product are analysed (including those that were received before it reached 10).

 

By filtering the source data to positive feedback >= 10 you are excluding all those reviews of the product before it reached 10.

 

Anyway, here's my solution, which I've laid out quite laboriously for clarity!

 

Akash__on
8 - Asteroid
Spoiler
164.jpg
TobiasThormann
5 - Atom

Here is my solution. I used two ways to get to the result:

Spoiler
TobiasThormann_1-1643465510448.png