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
A solution to last week’s challenge can be found here.
This challenge is another selection for the Weekly Challenge User Group October Takeover event, and it was contributed by @Charity_K_Wilson, a member of the Dallas-Ft. Worth, Texas User Group. We would like to thank Charity Wilson-Perez for your contribution, and we hope everyone enjoys tackling this challenge!
Your tasks for this challenge are as follows:
- Identify the primary fiber content per yarn ID. Since many yarns are blends of multiple fibers, you want to have just one fiber associated with each yarn.
- Determine which category of fiber has the highest average rating (animal, vegetable, or synthetic). What is the corresponding average rating?
- Within the highest-ranked fiber category, identify the specific fiber type that receives the highest ratings. You want to base your analysis on consistent ratings, so only consider fibers with a minimum of 50 ratings.
Source: https://github.com/awalsh17/ravelry_yarns/tree/main/data
My solution. I cannot find exactly the same output for task 2 and 3, so i have probably missed something!
my solution, 2nd place average rating for task 2 is off by 0.000378 for me and I don't know why...
My solution.
My result on task 2 is exactly not the same.
Actually some yarn_id have the same highest percentage. But I can not understand how to sort the data to match the sample result using Designer Cloud. I think that it is the AMP Engine's rule.
