Python Pandas Tutorial (Part 4): Filtering - Using Conditionals to Filter Rows and Columns

Подписаться 1,3 млн

Просмотров 442 тыс.

50% 1

In this video, we will be learning how to filter our Pandas dataframes using conditionals.
This video is sponsored by Brilliant. Go to brilliant.org/cms to sign up for free. Be one of the first 200 people to sign up with this link and get 20% off your premium subscription.
In this Python Programming video, we will be learning how to write conditionals in or to filter our data within our Pandas dataframes. This is a fundamental skill to have when using Pandas because it is one of the first things most people do when starting a new Pandas project. Let's get started...
The code for this video can be found at:
bit.ly/Pandas-04
StackOverflow Survey Download Page - bit.ly/SO-Survey-Download
✅ Support My Channel Through Patreon:
/ coreyms
✅ Become a Channel Member:
/ @coreyms
✅ One-Time Contribution Through PayPal:
goo.gl/649HFY
✅ Cryptocurrency Donations:
Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3
Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33
Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot
✅ Corey's Public Amazon Wishlist
a.co/inIyro1
✅ Equipment I Use and Books I Recommend:
www.amazon.com/shop/coreyschafer
▶️ You Can Find Me On:
My Website - coreyms.com/
My Second Channel - / coreymschafer
Facebook - / coreymschafer
Twitter - / coreymschafer
Instagram - / coreymschafer
#Python #Pandas

Опубликовано:

5 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 314

@darshantawte7435 2 месяца назад

Even in 2024 this is still the best tutorial out there for pandas. With AI becoming capable of performing EDA and data analysis (atleast elementary which is still better than many newbie analysts), i wonder how pandas will keep up with it.

@qualjyn2 4 года назад

Nothing like waking up a Saturday morning, and catching up on Coreys Python Pandas tutorial over a good cup of coffee :) @Corey, keep up the good work - it is really appreciated!

@sidneysousa3520 4 года назад

I said it! This is like Netflix :)

@onyekachinelson6999 2 года назад

Okay. Today is Saturday. Lemme watch it and see for myself. Thanks!

@onyekachinelson6999 2 года назад

The lesson is fantastic 👏

@cordularaecke 4 года назад

This is the best explanation of pandas dataframe boolean filtering I've ever seen - especially the inverse filter using the tilde - excellent - this is SO useful. Thank you

@parols1160 4 года назад

I guess 'flawless' is the only appropriate adjective for this whole series you are doing. Congrats from Italy Corey, keep it real!

@ashylarry3442 4 года назад

I let your ads play all the way thru. Fives minutes in exchange for what you’re giving...light work. Keep it up brotha!

@tolulopeadedoyinadedoyin5239 3 года назад

Corey is the best tutor , I have seen so far....He explains with ease and simplicity....More grace

@motlatsimoea5615 Год назад

Of all the teachers I have come across on RU-vid, you are my favorite. The way you explain. The example exercises you use are simple enough to comprehend while also making me feel like I could handle bigger problems. I learned Django from you as well. Thank you for all your work!

@akiratoriyama1320 4 года назад

Like THE BEST pandas tutorial on internet. Thanks again Corey!!

@shanplays6001 4 года назад

Great series. I would recommend going through these tutorials once with the given dataset, and then going through it again using a dataset you're interested in. Dw, it will go alot faster the 2nd time around, and you'll get great practice actually finding insights you care about.

@edilgin622 4 года назад

i started learning python basics with you and i just cant believe how much i improved myself this year, thanks a lot!

@Shailswap14 4 года назад

I have referred to three video tutorials/courses before this and this is by far the best course on pandas with complete coverage. You deserve a million likes for this series. This course is priceless.

@clexyk 3 года назад

Corey, your tutorials of Python are the best stuff I have ever seen. The ones on Pandas is again of very high quality.

@chrissteele9540 4 года назад

You have a way of making any topic seem sooo simple... You're an incredible teacher! I owe most of my python skills to you btw ─ thanks :) Please keep the videos coming!

@akintonaolawalesamuel2236 4 года назад

Lucid. Concise. Thanks a bunch, Corey, for all you do to make us Pythonistas

@mintymintfresh 3 года назад

There is no better teacher on python than corey... He is simply the best one... I got to learn flask .. All thanks to corey.. There are thousands of students whom u are making a better programmer every day ...

@MrGokTR 4 года назад

Thanks for sharing such an amazing series. You are basically representing the Zen of Python in person!

@pierreroux-lafargue8227 4 года назад

You're a good man Corey Schafer, thanks for the quality content.

@larz4437 4 года назад

The often imitated, never duplicated, Corey Schafer. You're truly the python guide GOAT and us noobs bow before you. Thank you so much for this series and all your work.

@Historiaplaying 4 года назад

Corey, you're a god of teaching, you don't leave out anything unexplained. Thank you

@josephsteen230 4 года назад

As per your request: I would like to see you upload a video about truth tables. I like the way you explain things, Corey. Your Panda series is helping a lot. So thanks for what you do!

@TopBagon 4 года назад

Your tutorials are the best ones I've ever seen in my life ._. thanks you so much for those, we appreciate this a lot *Simply Amazing*

@j3553hh 10 месяцев назад

Your videos are so rich with practical guidance that I'm pausing every 90 seconds to make notes. This one took me three hours to get through.

@eduardolima5495 3 года назад

Really, I'm so thankful for this series!! I really really appreciate your effort to make those videos and teach me something new!

@YeekyYeeky 4 года назад

Corey Schafer is really great at explaining things , thank you very much !

@zahidkamil7833 4 года назад

Can't wait for the string method you said in pandas. I am really looking forward for that. Thank you so much for all your effort and help! :)

@Lars7878 4 года назад

I love that .Str.contains filter, that is a brilliant idea, I never came up with.

@pythonstuff8633 3 года назад

Bro you have no idea what help you are giving us.Thank You Keep doing what you do!

@rishikambhampati2862 4 года назад

Though we have an idea of the concept, there will always be something new to learn from your videos. As usual thanks a lot.

@JoshuaMurangaBauer Год назад

Your contents will never go obsolate mate. Pure Gold.

@niralpatel3369 4 года назад

You're a great man Corey Schafer, This is the best channel ever on RU-vid. Thanks form India.

@JoshuaDHarvey 4 года назад

19:22 let us know when you do a video on strings! Can't wait for that and if you need any suggestions on any of the methods in the pandas .../text.html let us know! Thanks for all your hard work Corey!

@anuragshukla7813 4 года назад

Thank you so much for posting the high quality and so knowledgeable video on youtube. And this is the best channel ever channel on youtube I have seen. You are doing great work keep it up, brother. Thank you again for these type videos, Please keep on posting these type of video in the future also.

@crazybigworld9357 Год назад

Thank you Corey. You're one of my best Python Teachers.

@kingveelatte41 3 года назад

Found this channel couple weeks ago, and I watch it almost everyday know, like watching fiction series i love. Thank you Corey for amazing video (I forgot if I already comment like this in another video but yeah Thank you as always)

@nicholasmaloof8378 4 года назад

Would you be willing to do a video on numpy?

@JoshuaDHarvey 4 года назад

I'm pretty new to python in general but isn't most of pandas built on numpy, so I imagine there is quite a bit of common ground between the two libs?

@jeetpatel6679 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QUT1VHiLmmI.html his tutorial is good

@deepdoshi2734 4 года назад

@@jeetpatel6679 Thank you

@sensei249 3 года назад

@@jeetpatel6679 that's the best available video for numpy, even i was going to suggest it. after 1 hour lecture you are ready to go.

@alenjose3903 3 года назад

@@jeetpatel6679 thanks

@roywilson9580 4 года назад

Thanks, Corey for uploading this interesting, useful and educational video. It was a great help in understanding the process of filtering data in Pandas. Will be really useful to me.

@mazensleiman3863 3 года назад

a big fat thank you Corey, that is one amazing video. and I will definitely watch the whole series

@abanerjee3704 3 года назад

That was the best quality content on Pandas. Keep it up brother. ALL THE BEST.

@auroshisray9140 3 года назад

Your tutorials are well structured and easy to understand. Thank you so much

@rudiklein 4 года назад

What can I say...great job with this series. Again.

@dataguy3553 Год назад

thank you so much Corey for this Pandas playlist, I love them, they are super helpful.

@vijaybabu3923 4 года назад

Very fluid explanation of Pandas 👌 thanks Corey !

@kingkai129 4 года назад

I'm so thankful that I found your channel!!!!

@lilahinzelbergyifa292 4 года назад

Corey, this is simply great! Thanks!

@tarunmahendra4233 3 года назад

this is the best one ever. Really enjoying this series Thanks Corey!!

@shamseshifat7825 4 года назад

Your in-depth knowledge in python is astonishing! The thing that always amazes me is, when you finish explaining a topic and I ask myself " Now what if I try to do that?" kinda questions and within no seconds I see you explaining the same question! 😳 Do you mind read your viewers or what? 😅 Anyways, you are a legend

@felipegutierre7037 Год назад

Corey, your job is awesome, thank you for this free content!

@cudanakiju0 2 года назад

I'm reviewing your tutorial for my interview, that's awesome! Just to clarify one thing (part staring at ~7:00) - when combining conditions, you MUST put separate conditions into parenthesis, otherwise pandas will most likely throw quite ugly and non-intuitive error. I think that should be stressed, wasted some time on it once ;)

@prmurali1leo 3 года назад

This is awesome, Coreys in the best tutor ever i have experienced

@ndiayemodou3474 4 года назад

There is also someone from Senegal west Africa :) you are amazing !

@HaoranZhang-jc8fq 22 дня назад

Your lectures are so great!!

@karina3440 Год назад

Another great tutorial! Thank you, Corey!

@Takk6 4 года назад

I rarely comment but I've watched alot of Pandas tutorials on youtube and this is by far the best one Ive seen. Subscribed. Will you be doing a Scikit-learn tutorial in the future?

@coreyms 4 года назад

Thanks! And yes, I will be covering that, but I don’t have a timeframe of when this will be yet.

@sartajsingh8459 2 года назад

Thank you so much for making these videos. They are really helpful to me in learning ML and AI

@pythonwala510 4 года назад

Your video of pandas series is very helpfull for me to underatand python. I like your way of delivering the explanation. I'm eagerly waiting for your next video.

@mikshubhatt1175 3 года назад

i appreciate your work. you are putting some serious efforts in your videos.

@sshbk5878 2 года назад

Corey is the best, following you since 2020

@muntadher8087 2 года назад

Thank you Corey!! Amazing video

@danielflorea3001 2 года назад

Really a pragmatic video on Pandas. Great work

@eltorayy11 3 года назад

I really like the way you explained! Thank you so much

@user-sd2cd2vj1f 26 дней назад

Thanks for the 'data filtering' code as it helped in my project.

@MehmoodAhmedMooD 3 года назад

Thanks a lot for your superb tutorials man. Just the right amount of info for beginners

@gibranportillo5876 4 года назад

You're the best. thanks so much!! Greetings From Mexico

@Fantasy7117 8 месяцев назад

I'm loving your lessons😊 thank you

@atulkumar7030 4 года назад

He is an awesome tutor! Boss really impressed by your videos. Please start with ML based contents soon.

@crackyflipside 4 года назад

Fantastic work as usual!

@libertarianmonk7013 Год назад

Thank you very much! The last command was the one I was looking for 😊

@fuzzywuzzy318 3 года назад

I'am from china !!!!!I am your new audiance ,and feel your video is really helpful!!!!!!!thanks!!!

@thefireagen 4 года назад

So far so good explanation..I have been watching the series since its started...I came again to revise. just a quick suggestion from my side...please give a suitable name to filter variable so that it will look readable if someone wants to understand whats happening.

@adventures_of_oliver 4 года назад

Amazing tutorial series!

@SotovisionHD 4 года назад

THANKS! finally I get the filtering from pandas.

@arifchowdhury7089 2 года назад

So easy when Corey explains

@anubhavrauniyar3192 Год назад

We Love You Corey! Thanks

@MANISH12665 День назад

Hey Corey I have just completed your tutorial on flask i just love the way you taught . I have one request can you please make a tutorial on Python Pyramid framework . I found everywhere but there is no proper tutorial on Pyramid framework on youtube or any other learning platform Can you please make a tutorial on Pyramid framework

@MrBoaredman 2 года назад

This Tutorial, and you Sir, are life savers. Thank you so much

@supriya1316 2 года назад

Great. I am really happy learning from your channel. You explain the concepts with so much clarity . Thanks a ton . Could you please also suggest some of the resources for practicing all the concepts learnt so far .

@muhammedyousri4080 2 года назад

Very useful as always , Thanks a lot Corey.

@nikolastamenkovic7069 2 года назад

Great tutorial series!

@zohaibdev 2 года назад

Thank you so much. This series is amazing. 💖

@shantanukaushikmathoholic 4 месяца назад

awesome, this series is going good...

@jessicasanger7194 4 года назад

Thank you!!! ☺️ This came just in time for me. I tried filtering the data by adding a series of True and False values as a column to the data frame😂

@saikiranedits802 4 года назад

Very very thankful for your videos. ❤ from INDIA

@jeanaimegakwerere5359 4 месяца назад

Love how you filtered comma rows with comma separated data👋

@jasonbwaljones 2 года назад

This is the holy grail series for Pandas in 2021

@jorginh05 Год назад

You saved my life!!! thank you for the content

@KeithFlint350 2 года назад

Proper tutorial with a proper English

@paulohsgoes1959 Год назад

Just brilliant! Congrats

@Rajesh-nb9de 3 года назад

This is the best library to learn pandas... love from india

@nascentnaga 2 месяца назад

this is fresh in 2024 :)

@AmitMKrishnaR07 2 года назад

Thank you! It's a great tutorial about Pandas!

@paulosergioschlogl9550 4 года назад

You do a awesome job man!

@angtranhai6457 3 года назад

Amazing, thanks Corey.

@junaidmalik9593 4 года назад

your playlist is amazing. to be honest i have taken dozens of courses online for python on many platforms but non of those have been completed beyond 20 %. looking forward to gain the skill here at least, as its fun to hear and v understandable

@alejandropaloalto538 2 года назад

Thanks Corey, I see you from Mexico

@hameem6845 4 года назад

Just came to like. Will watch later.

@rafdnaah6078 4 года назад

Thanks for the excellent videos. I'm upgrading my database skills to data engineering and your channel is an excellent source of knowledge and skills building. I have one suggestion though; I'd appreciate if you do not overwrite previous statements in the same cell. Always start in a new cell, even if it is a trivial modification of the previous statement. Thanks

@richarda1630 3 года назад

fantastic vid! thanks so much!

@sebastianmuller1210 4 года назад

I like your videos. I want to suggest another "pandas" topic: Making Pivot Tabeles. Yes its a Matplotlib thing, but when i change from excel to pandas and want to do "all the tipical stuff", i won't look for a Matplotlib Tutorial. So you can introduce that skill in the Pandas Series as well.