We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #164: Retail Therapy

DataNath
16 - Nebula

My solution to #164.

 

Spoiler
DataNath_0-1645555650268.png

 

JamesCharnley
11 - Bolide

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

 

Spoiler
JamesCharnley_0-1645619124694.png

 

aroumpelaki
7 - Meteor

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