Python Pandas - Droping missing values based on different conditions|Dropna with multiple conditions

Python Pandas - Droping missing values based on different conditions | Dropna() with multiple conditions
When it comes to data analysis, missing values are the first obstacle and it becomes really important for you to be efficient enought to deal with them. This is the first video in the series where we are going to explain you step by step, how to deal with the missing values as per your requirement.
In this first video, we have covered:
00:00 - Introduction
02:17 - Drop rows with at least one missing value | Filter all those rows which do not have any missing values at all
03:39 - Drop columns with at least one or any missing value | Filter all those columns which do not have any missing values at all
05:26 - Drop all those rows which are completly blank | Drop rows with all missing values
06:30 - Drop all those columns which are completly blank | Drop columns with all missing values
07:29 - Keep only those rows which have at least n number of non missing values | Drop all those rows which have more than n number of missing values
10:03 - Drop specific columns if those have missing values
you can download the data used in this video using:
File Name - DropNaSample.xlsx
URL - github.com/LEA...
#Learnerea #Python #Pandas #Pythontutorial #Pythononlinetraining #Pythonforbeginners #PythonProgramming #PythonMatplotlib #dropna

[@mateomurillo4921]

Thanks!!! I reallly needed a video like this 🙏

[@learnerea]

Glad it was helpful

[@OOM2M]

TUVM

[@soby_a]

Hey, great tut! I just wanted to learn, if there is a way i can del entire row if a specific row contains a "keyword". Like for eg: Iphone 14 demo Iphone 13 demo I need to remove all the prods containing a word demo. Thanks

[@learnerea]

consider the variable you want to apply the filter on, is named as "prod", you can try this - df[~df.prods.str.contains('demo')] to understand it in detail, I recommend you check this out - kzbin.info/www/bejne/fqKqaHqsppaXjas

[@amritabhattacharya6344]

Hello sir. Thank you for the wonderful explanation. I had a doubt what if the question is : Drop missing values along the column "price". So what exactly do I have to drop here. Thank you for your hard work.

[@learnerea]

if I understood your question correctly then the answer is droping all those rows where it is missing in column "price" and you can do this by using - df['price'].dropna()

[@amritabhattacharya6344]

@@learnerea thank you!!

[@kabiland2043]

dropna() got an unexpected keyword argument 'subset'

[@kabiland2043]

how to resolve this, pls tell

[@learnerea]

can you put your syntax here along with error message