Filtering Columns and Rows in Pandas | Python Pandas Tutorials

In this series we will be walking through everything you need to know to get started in Pandas! In this video, we learn about Filtering and Ordering Dataframes in Pandas.

Favorite Pandas Course:
____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

0:00 Intro
0:11 Import Dataset
0:55 Filtering
8:13 Order By
11:22 Outro

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[flyingzeppo]

Excellent video. If I could give it 2 thumbs up I would. I especially like how he gets right to the point and doesn't waste the viewers time. The whole video is filled with useful information. Tutorials where the host spends 10 minutes telling you what they're going to tell you, before they tell you are infuriating. So are videos that are an hour long but only have two or three actual pieces of information in them. This was the perfect video on the topic of filtering columns and rows in Pandas. Thanks Alex.

[claytonkays]

the best pandas filtering tut i have watched. clear presentation and straight to the point

[smartstableequipment]

It`s 10th video which I saw on YouTube, and the first which help me. Thank you very much. Short&clear videos.

[pancakez]

Thanks for this, Alex! I’m a R user wanting to pick up Python as well, and this a great overview of panda’s syntax. As a SQL user as well, those comparisons are also helpful!

[BKSDA]

I have been doing that udemy course for a couple of days and I stumbled upon this pandas series videos now... As I was watching it I was like: "hmmm this sounds very familiar, very well explained..." And there it is, when I saw the sponsorship part!
This is an excellent summary of the course itself. Love your work man, keep it up!

[kirillfedtsov]

I came here because I needed to filter and order some csv files on backend and then send filtered\ordered csv files back. First I figured csv module is probably what I need but it's actually useless for ordering and filtering. Then I though I will just export everything into postgres, filter it there and then export it back into csv. And strangely enough the best way to export csv into postgres using python was suggested to be with pandas! And then I though: 'wait, why do I even need sql if I can manage my data in a dataframe and export it back into csv'. So here I am! Excited to learn!
Alex, thanks for the video!

[dishnaphukan]

Thank you so much. You have no idea how helpful you have been.

[mercy-shalomadepoju]

Thanks for the video Alex. Python is the only fear I have now.

I've been able to do more with other tools, but I keep coming across new stuffs in python.

I have been learning python for a while, but the more I learn, the more I feel it's becoming more complex, and it's scary 😢

[mfesanekunju]

Great content, now I have a much better understanding of pandas. Gracias

[FrankT]

Just what i was looking for! thank you so much!

[HomeAlbadawi]

I love your videos and to support you I'm gonna watch other courses with watching adds on

[ztkinth]

very informative one. Thanks for sharing with us. once again thanks.

[nickragazzo]

Thank you for the efforts of posting these videos. Is there a resource that explains the syntax around some of the code? For instance the line:


Why are double identifying the data frame? Also why is it str. And not str()?

I think I’m just confused where we use brackets vs parenthesis vs dots and what each indicate.

[samhitakolichala]

Excellent work sir @Alex The Analyst your videos are helping me learn more, also if possible could you make a playlist for us for the hands-on data cleaning and exploratory data analysis in different sectors (Finance, banking, stocks, insurance, healthcare, supplychain, etc) so that these are helpful for us to start our career in this domain

expecting you would make these too for us to help

Thanks a lot sir!

[lalmanidas]

This is a great video. A lot of useful information condensed into such a short video. Great work.

[AbrahamMorales-qy]

I had a question. is it possible to have the filtered outcome be stored into a new file? Thank you very much for your tutorial, very informative.

[alexknezevic]

Hi Alex. In your Filtering using Date Functions video, once the index was set with df.set_index('Formatted Date'), then we should theoretically be able to see all the 2009 rows with df['2009'] or at least 3/27/2006 row with df['2006-03-27'] but it is not happening. What is missing?

[yfnexwx]

hello . am trying to pratice the codes but i am having issues . it saying file location not found

[jackwilson]

Hello my dear online teacher Alex Freberg. I want your advice about Python practicing. I mean you shared about best courses on YouTube or Udemy or any other courses. But i need best sources for practice python or maybe method for example projects. What is your advice about it. Honestly i would like one little video about it)) Thanks for your attention beforehand.

[DavidOmenuko]

Looking forward to a Numpy series. Was also too fast