Pandas DataFrame dropna() Method [using python] to clean empty cells in machine learning in bangla.
Mode, Median, Averages in Machine Learning: • Averages in Machine Learning in bangla | S...
Machine Learning full Playlist: • Machine Learning Playlist Bangla Tutorial ...
Introduction to Machine Learning: • Introduction to Machine Learning in Bangla...
Basics of KNN Algorithm: • How to select the value of K in the K-NN a...
How to select the value of K in the K-NN algorithm and Advantages & Disadvantages of KNN :
• How to select the value of K in the K-NN a...
KNN vs KMeans algorithm: • Difference between KNN algorithm and K-Mea...
What is Classification in Machine Learning: • What is Classification in Machine Learning...
Classification vs Clustering: • Difference Between Classification and Clus...
Lazy learner vs Eager Learner: • Difference Between Lazy Learner and Eger L...
What is clustering in Machine Learning: • Introduction to Clustering in Machine Lear...
Wireless Ad Hoc Network Playlist: • [ওয়্যারলেস সেন্সর নেটওয়ার্ক] Wireless Sens...
Computer Network Playlist : • Computer Network In Bangla | কম্পিউটার নেট...
Management Information System Playlist: • Management Information System (MIS) in Ban...
Algorithm Playlist: • Algorithm in Bangla | অ্যালগরিদম বাংলা টিউ...
Data Structure Playlist: • Data Structure full playlist in Bangla | ড...
Pandas DataFrame dropna() Method
Example
Remove all rows wit NULL values from the DataFrame.
In this example we use a .csv file called data.csv
import pandas as pd
df = pd.read_csv('data.csv')
newdf = df.dropna()
Definition and Usage
The dropna() method removes the rows that contains NULL values.
The dropna() method returns a new DataFrame object unless the inplace parameter is set to True, in that case the dropna() method does the removing in the original DataFrame instead.
Syntax
dataframe.dropna(axis, how, thresh, subset, inplace)
Parameters
The axis, how, thresh, subset, inplace, parameters are keyword arguments.
Parameter Value Description
axis 0
1
'index'
'columns' Optional, default 0.
0 and 'index'removes ROWS that contains NULL values
1 and 'columns' removes COLUMNS that contains NULL values
how 'all'
'any' Optional, default 'any'. Specifies whether to remove the row or column when ALL values are NULL, or if ANY vale is NULL.
tresh Number Optional, Specifies the number of NULL values required to remove the row or column.
subset List Optional, specifies where to look for NULL values
inplace True
False Optional, default False. If True: the removing is done on the current DataFrame. If False: returns a copy where the removing is done.
Return Value
A DataFrame with the result, or None if the inplace parameter is set to True.