Free Trial

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

Challenge #459: Fun Facts About LEGO® Sets! Part 1

AYXAcademy
Alteryx
Alteryx

Weekly Challenge LMS Banner.png

 

Hello Community members!

 

A solution to last week’s challenge can be found here.

 

pexels-markus-winkler-1430818-13548803.jpg

Thank you, @Qiu , for creating this fun challenge. Your submission was so extensive, we had to divide it into two parts! We appreciate your contributions to our Weekly Challenges!

 

Welcome to the first of two challenges where you will dive deep into the world of LEGO®! Get ready to uncover some cool facts about LEGO sets, themes, and part counts. Use the provided datasets to solve this challenge. Let’s go!

The datasets contain the following information:

  • sets.csv: Data on LEGO sets, including a unique set number, name, release year, theme ID, part count, and image URL.
  • themes.csv: Data on LEGO themes, with each theme having a unique ID, a name, and a reference to its parent theme when applicable.

You have three tasks to complete in this challenge:

  1. Determine which LEGO set contains the largest number of parts.
  1. Determine which LEGO theme has the largest number of sets.
  1. Calculate the average number of parts per set for each year. Use integer as the data type for this task.

Good luck!

The Academy Team

 

Download Start File

 

Download Solution File

 

Data Sources:

https://rebrickable.com/downloads/

https://www.kaggle.com/code/andycapp29/best-bang-for-your-buck-lego-dataset-analysis/notebook

alexnajm
18 - Pollux
18 - Pollux

Done!

Spoiler
Challenge 459.png
Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
mmontgomery
11 - Bolide
11 - Bolide

C459

Spoiler
c459.png
MikeBird
8 - Asteroid

Being an AFOL, right up my street. 
This is my attempt at a resolution. 

nSpire
9 - Comet
Spoiler
459.png

binuacs
21 - Polaris
Spoiler
 

image.png

patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
Tofel
8 - Asteroid
Spoiler
Challenge 459.jpg

JBevan89
8 - Asteroid

I enjoyed that challenge - if only I had Lego to play with