How do I apply multiple filter criteria to a pandas DataFrame?

Let's say that you want to filter the rows of a DataFrame by multiple conditions. In this video, I'll demonstrate how to do this using two different logical operators. I'll also explain the special rules in pandas for combining filter criteria, and end with a trick for simplifying chained conditions!

SUBSCRIBE to learn data science with Python:

JOIN the "Data School Insiders" community and receive exclusive rewards:

== RESOURCES ==

== LET'S CONNECT! ==

[sumansan]

Why its always like, that i feel you are reading my mind. When you explain something, i get something in mind "what will happen if I do this" and just the very next moment you explain the same. God bless you, teachers like you have a different place in heaven

[alexandra-stefaniamoloiu]

Question: How can you be such a great teacher?

[carkar]

The clarity you provide is incredible. Please know that you are helping a lot of people by making these concepts easy to grasp. I hope you continue to provide this amazing content! You''re doing a wonderful service for the data science community.

[annelizabeth]

Been coding for years and this is some of the best teaching I've ever seen. Thanks!

[morshedshahed]

I am learning python in a data analytics course, you are awesome. I subscribed straight away.

[MinecraftMartin]

Just want to say thank you for these videos. I was having so much trouble conceptualizing all this, being new to Python as well. You've helped tremendously. Definitely have a knack for explaining things for a general audience and not going over anyone's head.

[bobrossatron]

You are a lifesaver!!! That last tip at the end of the video is exactly what I was looking for. Thank you so much!

[beansgoya]

ive watched over 200 hours of python tutorials and you are by far the best. im going back to watch every single one of your videos because i still learn new things from you.

[subasurf]

Great video, clarifying what is such a simple thing, yet so many tutorials manage to make it seem so complex.

[sarikadatta]

You’re indeed a very good teacher. I am so impressed with your skill of teaching.
God bless you

[phuccoiinkorea]

The best teacher i've ever seen :D Thank you so much!

[jonatapaulino]

Man, I've been trying to watch a video like this for a long time, with these explanations. I never understood why square brackets, parentheses in these panda searches, now it's totally clear in my mind. Congratulations and thank you.

[zeflyn]

My guy you are a lifesaver. Legitimately pulled me out of an onset panic attack involving deadlines at work. Appreciate you so much.

[geofflyons]

You're a fantastic teacher. Well done & thank you!

[williamsullivan]

Exactly what I was looking for. Explained very well. Thank you!

[Happybutcher]

Your are the only Python Instructor i have been able to follow until now. Thank you.

[felipemendes]

the awesomeness of your teaching and will to share your knowledge has been already stated by several comenters, therefore I just want to say thank you!

[dogruyatrm]

I have to say that you're an EXCELLENT teacher, greeting from Turkey! :)

[markl]

Thanks for posting this, very easy to follow and incredibly useful to someone just starting out with Pandas. Great work!

[pannaroy]

Best teacher i have ever seen .its a pleasure to watch your videos