
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!
In recent years, yarn hobbies such as knitting and crocheting have been gaining in popularity. You decide to knit a warm scarf just in time for winter, and you want to use high-quality materials so it will last for years to come. Use the provided dataset to determine which types of yarn consistently receive the highest ratings and what kind of fiber you should choose to knit an amazing scarf.
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