The most advanced ML Observability platform
We’re super excited to share that Aporia is now the first ML observability offering integration to the Databricks Lakehouse Platform. This partnership means that you can now effortlessly automate your data pipelines, monitor, visualize, and explain your ML models in production. Aporia and Databricks: A Match Made in Data Heaven One key benefit of this […]
Start integrating our products and tools.
We’re excited 😁 to share that Forbes has named Aporia a Next Billion-Dollar Company. This recognition comes on the heels of our recent $25 million Series A funding and is a huge testament that Aporia’s mission and the need for trust in AI are more relevant than ever. We are very proud to be listed […]
NaN values are also called missing values and simply indicate the data we do not have. We do not like to have missing values in a dataset but it’s inevitable to have them in some cases.
The first step in handling missing values is to check how many they are. We often want to count the NaN values in a specific column to better understand the data.
This short how-to article will teach us how to count the missing values in Pandas and PySpark DataFrames.
We can use the isna or isnull function to detect missing values. They returned a DataFrame filled with boolean values (True or False) indicating the missing values. In order to count the missing values in each column separately, we need to use the sum function together with isna or isnull.
df.isna().sum() f1 2 f2 2 f3 1 f4 0 dtype: int64
If we apply the sum function, we will get the number of the missing values in the DataFrame.
df.isna().sum().sum() 5
We can count the NaN values in each column separately in PySpark. The functions to use are select, count, when, and isnan.
df.select( F.count(F.when(F.isnan("number")==True, F.col("number"))).alias("NaN_count") ).show() +---------+ |NaN_count| +---------+ | 2| +---------+
The isnan function checks the condition of being NaN, the count, and when the functions count the rows in which the condition is True.