Pandas Part 5 - Filtering dataframe on a condition | Masking using boolean series

In this video, we will learn to filter dataframes based on a given condition. About CampusX:
CampusX is an online mentorship program for engineering students. We offer a 6-month long mentorship to students in the latest cutting - edge technologies like Machine Learning, Python, Web Development, and Deep Learning & Neural networks.
At its core, CampusX aims to change this education system of India. We believe that high-quality education is not just for the privileged few. It is the right of everyone who seeks it. Through our mentorship program, we aim to bring quality education to every single student. A mentored student is provided with guidance on how to ace a technology through 24x7 mentorship, live and recorded video lectures, daily skill-building activities, project assignments, and evaluation, hackathons, interactions with industry experts, soft skill training, personal counseling, and comprehensive reports. All we need from you is intent, a ray of passion to learn.
Connect with us:
Website: www.campusx.in
Medium Blog: / campusx
Facebook: / campusx.official
Linkedin: linkedin.com/company/campusx-official
Instagram: / campusx.official
Github: github.com/cam...
Email: [e-mail]

[@rehmankhanbashna5923]

JazakAllah,One of the extraordinary teacher of data science explain each step in an easy way keep up the good work 👍

[@pragyasharma6520]

Thnx for giving these Nice videos 🙏 I have 1 question please tell me When I write data['city']=='Hyderabad' Error become name 'data' is not define Please tell me solution

[@achyutshinde3841]

Trust me when i say this teacher is so underrated Best videos on pandas I've seen till now ❤

[@ajaykushwaha-je6mw]

hi Sir, I need a help I want to filer only categorical column with missing value. can you help me with this. cat_col =[ var for var in thyroid_data.columns if thyroid_data[var].dtypes=='O'] thyroid_data[cat_col].isnull().mean()*100 >0.0 #here in and getting boolean value, what to do ?

[@BHOJENDERKUMAR]

05:59

[@mahendravidhate5134]

Very nicely explained. Thanks

[@kuldeeppawar7975]

Thanks a lot, i was stuck here and this has helped me to proceed

[@aghanjack]

Two questions - can you point me to the full path length in GitHub, where I can find the notebooks for these pandas tutorials. - have you done separate tutorials on sklearn as well as imbalanced data Thanks Arindam

[@sauravpahwa8967]

jisme sir 2 conditions hai usme function ka use karke kaise kar sakte hai

[@ddekshaparihar429]

sir i want who bat first and win in a dataframe.

[@zkhan2023]

very well explained. Thanks sir

[@hari_1357]

Thank you soooooo much sir 🙏🏻

[@narendraparmar1631]

Good Explaination

[@abdulrehmanamer4252]

Fabulous!

[@sprinter5901]

at 8:00 block [45] line 2 How are we able to compare data['date'] > '2010-01-01' ? '2010-01-01' is a string right and not a number.

[@maitreekar7957]

i too have the same question. if u have an answer by now can u clear my doubt?

[@sprinter5901]

@@maitreekar7957 no I forgot about this. But surely research and let you know

[@imranrmd1552]

​@@sprinter5901ans?

[@ananthr1583]

Actually, you need to convert date column to date time before comparing the code goes something like this > . pd.toDatetime(df['Date])

[@MafizulIslamIT]

Best explanation..thanks a ton

[@ajaykushwaha4233]

Great explanation