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()
Try it Yourself »
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 |
Optional, default 0. 0 and 'index'removes ROWS that contains NULL values 1 and 'columns' removes COLUMNS that contains NULL values |
how | 'all' |
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 |
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.