How do I filter rows of a pandas DataFrame by column value?

Let's say that you only want to display the rows of a DataFrame which have a certain column value. How would you do it? pandas makes it easy, but the notation can be confusing and thus difficult to remember. In this video, I'll work up to the solution step-by-step using regular Python code so that you can truly understand the logic behind pandas filtering notation.

SUBSCRIBE to learn data science with Python:

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

== RESOURCES ==

== LET'S CONNECT! ==

[Diachron]

Most people would have simply demonstrated the short way, but by taking the time to elucidate what's happening behind the scenes, you're performing a far greater service. Great job.

[guptaachin]

You say just the right words to get the concept and everything behind with lucidity. Thank you. i am a beginner but do not feel like so. :)

[ThePRINCEBARPAGA]

Your voice is so soothing and makes the understanding of concepts much easier and enjoyable. Thank You

[zeeshantaj]

You are the only man I can understand on YouTube about Data Science.

[РусланМиров-еч]

Despite the fact that English is not my native language, these are the best lessons about the Pandas that I saw! Thank you!

[seangriffin]

3 years later and this dude is still a legend and still saving my ass on basic stuff for work!

[leonardoferigutti]

Everything you're doing here for us, it's gonna go back to you in a certain way in the future! Thank You a lot for this master piece!!

[LyyrRATM]

There is something charming in how you say "Okay" when you finish a thought :) The video is very helpful. Thanks for putting this up here.

[guillermobarrio]

When great teaching meets simplicity. Thanks so much!

[FergusMcGee]

Thank you so much. I'm new to pandas as this was very helpful, I couldn't understand why it wasn't obvious how to filter rows.

You explained it so clearly.

[ASpace]

It's imperative that you know the logic behind these codes. Thank you Mark for this amazing playlist.

[adityaladia]

Awesome explanation! I have referred to some resources on pandas earlier and felt like i could easily skip your content to get through faster and grab only the unknown piece of code in the process . But the way you explain things it shows your hold on pandas and i am highly motivated to go through the full video. Cheers great job.

[lexboegen]

I like your in-depth explanation of _how_ it works, rather than a "recipe" of "just do it this way" without explaining _why_ it works. Now I'm off to see what other videos on pandas you have!

[hoomandehghani]

Thank you. I believe by showing us the theory behind it, you're helping us remember the method for a far longer period

[gcm]

Worth watching the whole video but if you are just looking for the shortcut: 9:21

[sajeendrann]

It's was THAT simple, yeah? I wasted two days trying to figure it out myself. Life saver you are. Thanks for the wonderful vdo.

[kingsleyobodomechine]

you are a great tutor, taking the long road and then giving the short answer really teaches the concept very well. Thank you sooo much

[sanaullahkhanhassanzai]

You are the best Pandas teacher on Youtube. I saw your previous videos as well but this is by far the best. You made the whole concept so simple. Thank you very much

[iccherherbarium]

a big thanks for putting an end to my last 3 hours' confused state.

[rishisagar]

Love these, helped with something I was stuck on for 2 days. I'm a beginner, loads of love <3