/LegoGraph

Primary LanguageJupyter Notebook

Lego Graph

A graph modelling lego sets, parts, and inventories.

Prerequsities

Quick Set Up

  1. Get Started with TigerGraph Cloud
  2. Create an account on Kaggle (if directly importing data from kaggle).
  3. Run LegoGraph.ipynb, replacing it with the appropriate credentials.

Breakdown

Data

The data is from the Kaggle Lego Database.

EDA

None.

Scripts

Schema

Lego Schema

Loads

See LegoGraph.ipynb.

Query

There are a few queries to grab data for analysis, including:

  1. legoInformation.gsql —> Grabs information from the graph, including year, number of parts, theme id, and theme name.
  2. quantityParts.gsql —> Grabs the quantity of sets and the number of parts in each set.
  3. yearParts.gsql —> Grabs the year a set is released and the number of parts in the set.

Projects

TigerGraph_and_Plotly.ipynb —> Lab of creating cool visualizations with Plotly and the TigerGraph Lego Graph.

External Links