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!

Link to my GitHub:

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!

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!

-------------------------
Song at the end
Creative Commons — Attribution 3.0 Unported — CC BY 3.0

-------------------------

Practice your Python Pandas data science skills with problems on StrataScratch!

Join the Python Army to get access to perks!

*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!

[KeithGalli]

Level up your data science skills with courses, projects, and competitions offered by DataCamp! Use my link below and check out the first chapter of any course for FREE! :)

[KeithGalli]

Big shout-out to my mom for not throwing away my Legos! She's the real MVP <3

[markomarjanovic]

Absolutely love the raw natural style you are doing, hope everyone else appreciates it too, keep going buddy, you are amazing!

[rafaelmello]

I'm a begginer in Python and I'm learning a lot from you. You are an awesome teacher. Your pacing and didactic are perfect. Thanks a lot for your effort

[alan]

God, this is brilliant. I watched the other two videos of yours on Pandas. You are a great teacher and friend. Thank you very much for your hard work and kindness.

[lVaNeSsA]

Thanks for being honest while you search for syntax in the beginning. Love this raw, step by step video.
I'm using your videos on my project to get inspired ❤️ thanks for being a good tutor 😊

[simonvanwijk]

Man so good to have you back! If it was not for you I would have not gotten a role as a DA as you helped me the most in the beginning.

[logannon]

Dude, I thought you were dead. Your videos have helped me so much. Glad to see you back!

[thebeeskhakis]

I'm so happy you're back. Your videos helped me get my new job!

[FIBONACCIVEGA]

This video has been a true inspiration to continue learning. I'm doing the datacamp since I want to change my field and I've always liked programming and analyzing data. But he didn't know if he could use the learned knowledge to use it in real life. Now I know that everything I have learned is what is used in real life data analysis. Saludos

[danielsantoyo]

Im so happy to see you are back! Panda and Numpy tutorials would be great !!! I’m currently trying to learn panda and numpy for data analytics and this video was super interesting !!! Thanks Keith keep going you are doing great 💯

[JW-puuk]

I really like the thought process in these videos. It's very raw, and really will translate well to an actual work project.

[leomiao]

The man is back. The hero is back for us!!

[amansorout.]

Happy to see you back, fighting with something serious, you are not alone.

[Hx]

These type of videos are your strengths! Great tutorial and explanation Keith

[qalinlekhaliif]

Thanks a lot man. Your videos are helpful and entertaining as well. We appreciate your great work.

[Sensei]

Finally back! It helped me a lot in learning python! Thank you so much!

[Omzodijacky]

Man, I'm happy you are back ! you were truly missed

[ben-tiki]

Another great video Keith! Glad to see yo back. Awesome that you got to work with datacamp. Please if you can make a video o OpenAI it would be awesome. Ive been using their API and its awesome

[itsReshad]

Love the great content! Please dont stop! You have an impeccable way of teaching its amazing