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

DataNath
17 - Castor

My solution to #164.

 

Spoiler
DataNath_0-1645555650268.png

 

JamesCharnley
13 - Pulsar

Very slightly different with one ID but I think it's correct

 

Spoiler
JamesCharnley_0-1645619124694.png

 

aroumpelaki
8 - Asteroid

So, this challenge confused me a little bit.

We needed to "include only items of clothing that have at least 10 positive feedback reviews". And the solution just filters out the rows accordingly.

 

BUT, as each clothing ID might be present more than once in the data, it is only natural that the first few times it was purchased, it would not have more than 10 positive feedbacks. Why should we throw away these ratings?

 

As an alternative, I first found the clothing ID's that had more than 10 positive feedbacks at some point, and then included all their ratings in the average rating computation. This, of course, has resulted in completely different results :)

Lévi
7 - Meteor

Solution to 169.

BenBrooker13
7 - Meteor

My solution

NeilParrott
8 - Asteroid
Spoiler
The top line is my solution. The dropped line with filter and second browse is to show my results of ID 1119 only based on previous reply comments calling it out. Not sure if I did something wrong, but it only appears to be categorized once in my final dataset.

NeilParrott_0-1646153629385.png

 

peter_gb
9 - Comet

Nice 

Spoiler
challenge_164_pgb.png

cchengarch
7 - Meteor

My Solution

 

 

ShaheenArshiya
8 - Asteroid

Completed!

elenartusi
6 - Meteoroid

Solution