Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHello Community members!
A solution to last week’s challenge can be found here.
Once again, thank you, @Qiu , for this fun challenge!
Last week, in challenge 459, you determined which LEGO® set contains the largest number of parts, identified the theme with the largest number of sets, and calculated the average number of parts per set for each year. Now, it is time to switch gears and perform an in-depth analysis on one of the most legendary LEGO sets of all time, the Taj Mahal set!
In this challenge, your task is to determine how many other LEGO sets you can build using only the parts from the Taj Majal set (number 10189-1). Note: A set is considered "buildable" from the Taj Mahal set if the part numbers and colors match.
To complete this challenge, you are provided with three datasets.
Datasets:
Note: If you get stuck, there is a hints box in the workflow that will help you solve the challenge.
Let the building begin! Good luck!
The Academy Team
Data Sources:
https://rebrickable.com/downloads/
https://www.kaggle.com/code/andycapp29/best-bang-for-your-buck-lego-dataset-analysis/notebook
Nice little challenge - I especially like that there few a few traps in there that were easy to fall into.
I believe the number of sets in the expected output is an wrong. The issue seems to be that you are finding the completable inventories and then joining those to get the set numbers, but some sets contain more than one inventory. I did a join with the sets in the expected output to show which parts are missing from the 10 improper matches.
Solved, but I was off by one - I've looked at the detail...
Fun challenge. I get the right quantity in the output but 2 of mine are different to the answer. Think it may be to do with part versions on some of them.🤔
@TheOC wrote:
Nice little challenge - I especially like that there few a few traps in there that were easy to fall into.
SpoilerClassic case of using a "join as a filter" throughout.
Unfortunately, the Community still doesn't let me attach photos.
If you click the Camera button
then click into that window that pops up, you can then use Ctrl + V to paste an image onto your post.