Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello 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:
- sets.csv: Contains information on LEGO sets, including a unique set number, name, release year, theme ID, part count, and image URL.
- inventories.csv: Lists the inventories for each LEGO set, which include a set ID, its version, and the set number.
- inventory_parts.csv: Details the parts for each inventory, including part number, color, quantity, and whether it is a spare part.
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
This is probably my all-time favorite Alteryx Challenge so far - thank you @Qiu
Beware of spare parts, versions (you can build some versions of the same set with the Taj Mahal, but you may not be able to build another version of the same set - only keep the versions you can actually build, not the other versions), and you probably want to use a lot of join tools to filter (Think about not just using the J anchor, but make use of the L and R output anchors!).
