Brickset ForumShopping at LEGO or Amazon?
Please use our links: LEGO.com • Amazon
As an Amazon Associate we earn from qualifying purchases.
Please use our links: LEGO.com • Amazon
As an Amazon Associate we earn from qualifying purchases.
Colors - How They've Changed!
Shopping at LEGO.com or Amazon?
Categories
- 24.9K All Categories
- 5 Announcements
- 5 Current Announcements
- 11K General
- 3K Collecting
- 3.5K Everything else LEGO
- 1.6K Building and Techniques
- 13.6K Shopping
- 1.7K Shopping USA/Canada
- 330 Shopping Elsewhere
- 10.2K Marketplace
- 2.1K Brickset
- 14 Ambassador
- 990 Introduce yourself
- 327 The Database
- 398 Brickset.com
- 281 Forum Operation
- 15 FAQs
- 1.1K Other
- 547 Community and Events
- 253 Photography/Video
Brickset.com is a participant in the Amazon Services LLC Associates Program, the Amazon.com.ca, Inc. Associates Program and the Amazon EU Associates Programme, which are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.
As an Amazon Associate we earn from qualifying purchases.
Comments
It's obvious from this list that Star Wars and Super Heroes are broken up into categories, in accordance with the BrickLink database. BrickLink doesn't divide Friends or Ninjago into categories, although each of these themes has even more sets than the Super Heroes theme! If they did divide Friends and Ninjago into categories, those themes might not rank as highly, whereas if you ranked all themes without any kind of category distinctions, Star Wars would certainly rank much higher (note that the two categories listed here make up only 26 out of 483 Star Wars sets in the Bricklink database), and other large themes like City might also show up.
As for "all time" contributers to black? Ninjago's surprisingly at #11 (I figured it wouldn't even be in the top 20 list at all):
And 9v Trains is clearly getting a boost from black train motors and large train bases, as obviated by the element category breakdown (again, all time for black):
DaveE
Here https://public.tableau.com/views/ExploringLegoData/Ifyoubought___?%3Aembed=y&%3Adisplay_count=yes&%3AshowTabs=y
is my findings so far. Its still a work in progress. The data is also from 2014.
Can you tell me how you downloaded all the set inventory? I have a file called S_PartInventory.txt but I cannot for the life of me remember how I obtained it. It is csv file that has all the vital information I needed to make my findings above. I know Bricklink lets you download several data files, which I also used but this was not one of them. I sadly didn't document how I obtained this file and would really like to update the data source.
I downloaded the data using a program I wrote to go through all the inventories slowly. I think there may be a way to do it more quickly (I recall that some programs were able to download a LOT of BL's data very quickly-- either in parallel or in some larger file), but I don't know what it might be.
There's a place on BrickLink where you can download raw catalog and inventory data:
http://www.bricklink.com/catalogDownload.asp
I only know how to do 1 set at a time, however, so I had my program download all the catalogs, and then go through the lists of sets, gear, and minifigs, downloading each inventory separately.
DaveE