Pandas & Python for Data Analysis by Example – Full Course for Beginners

Learn how to use Pandas and Python for Data Analysis, to Data Cleaning and Data Wrangling. You will learn by creating real life projects interactively to help you take the next step in your Data Science Career.

⚠️ Important! We encourage you to try to resolve the projects by yourself first! And watch the solution afterwards ⚠️

💻 Course created by Santiago Basulto from DataWars.

⭐️ Projects Covered ⭐️
⌨️ (0:00:00) Introduction

⌨️ (0:02:22) DataFrames practice: working with English Words [🟢 Easy]
This project focuses on the basics of pandas DataFrames, including understanding its structures and modifying them. The data we're using is a big dictionary of english words.

⌨️ (0:33:26) Filtering and sorting with Pokemon data [🟢 Easy]
This project focuses on the main tasks of Data Analysis: filtering and sorting and question/answering. The dataset includes information of pokemons from all generations (to make it more fun!)

⌨️ (1:24:30) The Birthday Paradox in the NBA [🟡 Intermediate]
The Birthday Paradox answers the question: how many people do you need in the same room in order to have a probability of at least 50% that two people share a birthday. The answer is astonishing! You'll use your findings to find which teams in the NBA share player's birthdays.

⌨️ (1:55:28) Matching Strings by Similarity using Levenshtein distance [🟡 Intermediate]
One of the most challenging tasks of Data Cleaning is dealing with Strings. This project is all about string handling and advanced techniques, as using the Combinatorics and the Levenshtein distance to find irregularities in company names.

⌨️ (2:24:15) Data Cleaning with Google Playstore dataset [🟡 Intermediate]
An all-encompassing project that covers all the aspects of Data Cleaning, including: finding and fixing null values, duplicate values, outliers and more. The data was scraped from the Google Playstore which means that is full of irregularities. The project finishes with some Data Analysis tasks!

⌨️ (3:18:34) Premier League Match Analysis [🔴 Advanced]
This project increases the complexity of your Data Analysis skills, as it combines Data Cleaning, with some analysis based on grouping operations. The dataset comes from the Premier League, the top-division Football/Soccer league in England.

⌨️ (3:53:46) NBA 2017 season analysis: joining and groupby practice [🔴 Advanced]
This project puts your Data Wrangling skills to a test, by asking you to merge different dataframes, clean them, and finish doing some analysis and question/answering. The dataset contains the full information of 2017 NBA statistics.

🎉 Thanks to our Champion and Sponsor supporters:
👾 davthecoder
👾 jedi-or-sith
👾 南宮千影
👾 Agustín Kussrow
👾 Nattira Maneerat
👾 Heather Wcislo
👾 Serhiy Kalinets
👾 Justin Hual
👾 Otis Morgan

--

[SantiagoBasulto]

Hello everybody! Author here. I'm so happy to publish my second course on freeCodeCamp. If you have any questions or feedback, reach out to me directly at santiago [at] datawars.io. Or DM me on twitter: @santiagobasulto.

[lethnis]

One of the best videos so far, i love how it focuses on solving projects

[dishandshah]

Best tutorial so far. I love it because you dived right into the projects. I'm so lucky to have find this course. Its a life savor. Thanks a lot Santiago. Want more tutorials from you. You are exceptional.

[nickolsondepiolenc]

Thank you so much. This would be helpful for future references if the topics are followed through.

[emmanuelbinen]

I have been searching for this.
OMG thank you so much

[mustafa-zlox]

Finally complete the whole video and learned a lot of amazing stuff. Thanks for the video❤

[AryanSharma-dcbj]

This is by far the best course + the platform(DataWars) to practice Data analysis questions

[Phronesis]

Thanks for the course I've not yet began right after my comment I'll get on! I wanted to express to Santiago that DataWars seems absolutely fantastic for people like me who struggle to practice while learning. The structure on datawars reminds me of my high school years when I would learn a concept in math and then just keep solving problems to deepen the concept.

And all those greyed out new materials, I'm looking forward to seeing them with excitement :)

Keep up your amazing work.

[OfficialB]

nice projects with step by step instructions! thanks for this

[ahmedgillani]

I really learned a lot and the way of teaching was unique. Thnaks alot

[PituPonsone]

Hola y buen día Santiago! Excelente el curso y muchas gracias por la iniciativa. Soy Ingeniero electrónico y por cuestiones de trabajo siempre he relegado la "pata del software" en mi disciplina, así que ahora me estoy poniendo al día y esto me viene de 10, no solo para mi trabajo sino para proyectos personales.
Un abrazo desde Bariloche!

[chzqgwx]

very good site for learning data science, hope you'll grow and develop. it's totally worth to pay for it.

[faahimrafi]

this is by far the best video for learning pandas .

[xyxhzge]

Good tutorial to practice pandas on real projects💪

[HoangNguyen-kine]

Hello @SantiagoBasulto,

I want to express my heartfelt gratitude to you for creating an amazing platform for learning. Thanks to your efforts, I have completed several fundamental projects, and I look forward to the future where you can develop even more projects for everyone to grow together.

Thank you once again for your contributions and dedication!

[TheIpicon]

at the latest activity (the one with calculating the mean of 'birth_date'), you can actually just compute via the 'Age' column 😅.

P.S.: @SantiagoBasulto great video and tutorial!
I'm often using this video when educating junior devs, thank you for the hard work!

[nguyenthikieuoanh]

this video helps me alot. I appreciate that.

[MuchMoreDK]

More like this please from santiagoBasulto and datawars!

[sameerambre]

This is an awesome course, I am enjoying it and practicing it daily by watching. Thanks a lot for this.

[lfqcwut]

Hey Santiago Basulto... Can you explain more topic in data science just like this video in pandas..this video is best video in the series of pandas .👍🏻👍🏻👍🏻 specially lot of thanks to freecodecamp...your coding video always are awesome...and you will always hiring best people regarding the topic...♥️👍🏻