- Task #2: In which year was Star Wars not the most popular licensed theme?（00:24:23 - 00:34:00）
Solving real-world data analysis problems with Python Pandas! (Lego dataset analysis)

In this video we walkthrough a data analysis project on DataCamp. This project has us walk through a Lego dataset and answer a few questions. To do our analysis we use the Pandas library of Python.

Check out DataCamp!
https://bit.ly/KeithGalliDCFeb22

Link to my GitHub:
https://github.com/KeithGalli/lego-analysis

From the DataCamp website:
The Rebrickable database includes data on every LEGO set that has ever been sold; the names of the sets, what bricks they contain, what color the bricks are, etc. It might be small bricks, but this is big data! In this project, you will get to explore the Rebrickable database and answer a series of questions related to the history of Lego!

Link to Rebrickable database: https://rebrickable.com/downloads/

Some skills worked on in this video:
- Reading CSV files with Python
- Filtering DataFrame based on conditional parameters
- Grouping data by column values and aggregating it

btw, I apologize at about the 25-minute mark I started having microphone issues, I'll have it solved by my next video.

Thank you to DataCamp for sponsoring this video :)

-------------------------
Follow me on social media!
Instagram | https://www.instagram.com/keithgalli/
Twitter | https://twitter.com/keithgalli

-------------------------
Song at the end
good morning by Amine Maxwell https://soundcloud.com/aminemaxwell
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: http://bit.ly/2vpruoY
Music promoted by Audio Library https://youtu.be/SQWFdnbzlgI

-------------------------
If you are curious to learn how I make my tutorials, check out this video: https://youtu.be/LEO4igyXbLs

Practice your Python Pandas data science skills with problems on StrataScratch!
https://stratascratch.com/?via=keith

Join the Python Army to get access to perks!
YouTube - https://www.youtube.com/channel/UCq6XkhO5SZ66N04IcPbqNcw/join
Patreon - https://www.patreon.com/keithgalli

*I use affiliate links on the products that I recommend. I may earn a purchase commission or a referral bonus from the usage of these links.

-------------------------
Video Timeline!
0:00 - Introduction
1:05 - Getting started w/ Lego analysis project
2:33 - How to follow along if you are not a premium DataCamp subscriber (GitHub)
4:01 - Project tasks overview
5:40 - Basic exploration of the dataset
9:45 - Task #1: What percentage of all licensed sets ever released were Star Wars Themed?
24:23 - Task #2: In which year was Star Wars not the most popular licensed theme?
34:00 - Bonus Task: How many unique sets were released each year (1955-2017)?
42:26 - Conclusion!

#Keith Galli #python #programming #python 3 #data science #data analysis #python programming #python pandas #pandas #groupby #read csv python #machine learning #data analyst #data engineer #engineer #real world data science #real world data analysis #solving real world data science problems #solving real world data analysis problems #artificial intelligence #groupby pandas #pandas library #import pandas as pd #datacamp #data camp #data science project #data science practice