Learn how to use PANDAS in Python in 15 minutes - with 10 real examples

Pandas is the most useful data analysis package in Python. You can use it to clean-up, transform and analyze data. Recently, I had a chance to use Pandas for some work. So, in this video let me share a quick but fairly in-depth introduction to Pandas with a real-world case study.

📃❓✅SAMPLE FILES & INSTRUCTIONS:
==================================

~ i n s t a l l a t i o n ⚒ ~

Download and install Pandas & other data analysis packages:

~ s a m p l e f i l e 📃 ~

~ c o d e 👨‍💻 ~

⏱ VIDEO CHAPTERS 👇
===================
0:00 - What is Pandas for Python?
0:55 - About the sample data & getting started
2:17 - Importing the libraries and loading data to data frame
4:08 - Fixing the data frame delimiter issue
5:21 - Using basic pandas functions (describe etc.)
7:15 - Fixing the text data issue by removing them
8:35 - Solving the problem correctly
11:20 - Adding a column with IF this then that type rule
13:38 - Filling the text value up (using fillna method)
16:13 - Removing the unnecessary rows
16:37 - Doing quick analysis of data (tables & graphs)

📚 LEARN MORE ABOUT PYTHON
============================

🤷‍♀️ Other ways to clean this data
===========================

📚 LEARN MORE ABOUT PANDAS
============================

📕📗📘 Pandas books:

~

🐼 What do pandas use to record their thoughts?
Notebooks of course 📓 🤣

#pandas #python #datascience

[likhithlicky]

Please upload complete playlist of python ( Numpy, pandas, matplatlib), , , as we are eagerly waiting for it...your teaching is so heart touching that we feel like our brother is teaching to we need this complete playlist...

[StefanoVerugi]

watching Chandoo's you realize that it's not a matter of easy or difficult programming languages but good or bad video tutorials, thank you sir for making things easier for the lot of us

[soumadip.m]

Seriously, Leila and Chandoo, these 2 legends changed the way I think and use data in excel. You helped me crack a new job even. Thank you so much!

[danielurbaniak]

Hi Chandoo, I'd just want to say that you're doing a great job sir! Keep going!

[harishpoalampalli]

This is cool and awesome !! Please share more videos on pandas like joins and automations !!

[dattavalloju]

Python is executed line by line and you're explaining line by line very clearly... Love from Texas.

[AlbouryNdiaye-roqz]

This tutorial is a masterpiece. Thank you Chandoo!

[AznBMan]

Good video working with weird data and dates! Real-life issues.

[hareshpatil]

Chandoo plz make a complete video list for data analysis using python especially libraries

[oiybmmh]

There is no place for even the minutest
amount of dirt in our hearts.
Alexandre Dumas once said that it is
difficult to understand others, but the most
difficult thing is to understand yourself.
Never allow yourself to fall into any trap.
Never allow the least karmic obstacle
to take form, nor harbour any unwholesome
thoughts in your mind.

[savagelandptyltd]

It took me 15 weeks to finally complete this 15 minute video. I'm crying

[sagarsamalla]

Thank you so much for starting videos on Pandas😀

[nomahlubithunyiswa]

Looking forward to taking notes from this video. Thank you Chandoo.

[andybecker]

Actually looking to solve this same scenario. Good stuff

[abigail]

Who are you?!?!....Probably mind reader. Was about get started with pandas and you upload this. Real saviour...cannot thank you enough

[Unbox]

Please upload video for all the mathematical concepts which is necessary for data analytics and science

[alannavarrovaldez]

I started to read the book of data analysis for python from Wes McKinney, is really good and covers a lot of basic python stuff.

[huntershikhari]

Please post a complete or detailed tutorial on data analysis with python...

[kadichidu]

Please make a full course on data analysis

[zm]

Thank you for this video. Looking at data I first thought that data below headers that had NAs next to it in other columns, is below so you'd have do use fill down. I think it makes sense to understand the structure first and then make structural changes. Also want to commend your fast learning in this area. Did you also try using M code to come up to desired solution? Thank you for posting