Pandas provides various data structures and operations for manipulating numerical data and time series. However, there can be cases where some data might be missing. In Pandas missing data is represented by two value:
- None: None is a Python singleton object that is often used for missing data in Python code.
- NaN: NaN (an acronym for Not a Number), is a special floating-point value recognized by all systems that use the standard IEEE floating-point representation
NaN as essentially interchangeable for indicating missing or null values. In order to drop a null values from a dataframe, we used
dropna() function this function drop Rows/Columns of datasets with Null values in different ways.
DataFrame.dropna(axis=0, how=’any’, thresh=None, subset=None, inplace=False)
axis: axis takes int or string value for rows/columns. Input can be 0 or 1 for Integer and ‘index’ or ‘columns’ for String.
how: how takes string value of two kinds only (‘any’ or ‘all’). ‘any’ drops the row/column if ANY value is Null and ‘all’ drops only if ALL values are null.
thresh: thresh takes integer value which tells minimum amount of na values to drop.
subset: It’s an array which limits the dropping process to passed rows/columns through list.
inplace: It is a boolean which makes the changes in data frame itself if True.
Code #1: Dropping rows with at least 1 null value.
Now we drop rows with at least one Nan value (Null value)
Code #2: Dropping rows if all values in that row are missing.
Now we drop a rows whose all data is missing or contain null values(NaN)
Code #3: Dropping columns with at least 1 null value.
Now we drop a columns which have at least 1 missing values
Code #4: Dropping Rows with at least 1 null value in CSV file.
Note: In this, we are using CSV file, to download the CSV file used, Click Here.
Now we compare sizes of data frames so that we can come to know how many rows had at least 1 Null value
Old data frame length: 1000 New data frame length: 764 Number of rows with at least 1 NA value: 236
Since the difference is 236, there were 236 rows which had at least 1 Null value in any column.
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.
- How to Drop Columns with NaN Values in Pandas DataFrame?
- How to Drop Rows with NaN Values in Pandas DataFrame?
- Count the NaN values in one or more columns in Pandas DataFrame
- Count NaN or missing values in Pandas DataFrame
- Python | Delete rows/columns from DataFrame using Pandas.drop()
- Python | Visualize missing values (NaN) values using Missingno Library
- Find maximum values & position in columns and rows of a Dataframe in Pandas
- Sort rows or columns in Pandas Dataframe based on values
- Get minimum values in rows or columns with their index position in Pandas-Dataframe
- Ways to Create NaN Values in Pandas DataFrame
- Replace NaN Values with Zeros in Pandas DataFrame
- Replace all the NaN values with Zero's in a column of a Pandas dataframe
- Highlight the nan values in Pandas Dataframe
- How to drop one or multiple columns in Pandas Dataframe
- How to Find & Drop duplicate columns in a Pandas DataFrame?
- How to Drop rows in DataFrame by conditions on column values?
- How to drop rows in Pandas DataFrame by index labels?
- Drop a list of rows from a Pandas DataFrame
- Python | Replace NaN values with average of columns
- Dealing with Rows and Columns in Pandas DataFrame
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.