Data analysis and manipulation often involve dealing with missing or null values in datasets. The `notna()`

function in the Pandas library provides a powerful tool to identify and filter out non-null values within a DataFrame or Series. This tutorial will delve into the details of the `notna()`

function, its parameters, and how to effectively use it for data analysis tasks. Through comprehensive examples, you’ll gain a solid understanding of its functionality and practical applications.

## Table of Contents

- Introduction to
`notna()`

- Syntax of
`notna()`

- Parameters of
`notna()`

- Examples of Using
`notna()`

- Example 1: Filtering Non-Null Values in a DataFrame
- Example 2: Counting Non-Null Values in a Series

- Conclusion

## 1. Introduction to `notna()`

In the Pandas library, the `notna()`

function is designed to identify non-null (non-missing) values in a DataFrame or Series. It returns a Boolean mask, which is a DataFrame or Series of the same shape as the original data, where each element is `True`

if the corresponding element in the original data is not null, and `False`

otherwise. This function is particularly useful for filtering data based on missing values, counting non-null values, and performing conditional operations.

## 2. Syntax of `notna()`

The syntax of the `notna()`

function is straightforward:

`pandas.notna(obj)`

Here, `obj`

can be a DataFrame or Series object on which you want to apply the `notna()`

function.

## 3. Parameters of `notna()`

The `notna()`

function has a single parameter:

`obj`

: This parameter specifies the DataFrame or Series object on which the`notna()`

function will be applied. It can be any Pandas DataFrame or Series.

## 4. Examples of Using `notna()`

### Example 1: Filtering Non-Null Values in a DataFrame

Suppose you have a dataset containing information about employees, including their names, ages, and salaries. Some entries in the ‘age’ and ‘salary’ columns are missing. You want to filter out the rows where either the age or salary is missing. Let’s see how the `notna()`

function can help you achieve this:

```
import pandas as pd
# Creating a sample DataFrame
data = {'Name': ['Alice', 'Bob', 'Charlie', 'David'],
'Age': [25, None, 30, 22],
'Salary': [50000, 60000, None, 45000]}
df = pd.DataFrame(data)
# Applying the notna() function to filter non-null values
filtered_df = df[df[['Age', 'Salary']].notna().all(axis=1)]
print(filtered_df)
```

In this example, we first create a sample DataFrame called `df`

. We then use the `notna()`

function along with the `all(axis=1)`

method to filter rows where both the ‘Age’ and ‘Salary’ columns have non-null values. The result is a DataFrame `filtered_df`

containing only the rows without missing values in either of these columns.

### Example 2: Counting Non-Null Values in a Series

Another common use case is to count the number of non-null values in a Series. Let’s consider a dataset with student information, including their test scores. You want to find out how many students have valid test scores. Here’s how you can use the `notna()`

function for this purpose:

```
import pandas as pd
# Creating a sample Series of student test scores
test_scores = pd.Series([90, None, 78, 85, None, 92, 88, 76, 94, None])
# Using the notna() function to count non-null values
valid_scores_count = test_scores.notna().sum()
print(f"Number of valid test scores: {valid_scores_count}")
```

In this example, we create a Series called `test_scores`

representing the test scores of different students. By applying the `notna()`

function to the Series and then using the `sum()`

function, we can count the number of non-null values, which gives us the count of valid test scores.

## 5. Conclusion

The `notna()`

function in Pandas is an essential tool for identifying and working with non-null values within DataFrames and Series. It helps with tasks like filtering out missing values, counting non-null values, and performing conditional operations. By understanding its syntax, parameters, and practical examples, you can confidently incorporate the `notna()`

function into your data analysis workflows. This tutorial has equipped you with the knowledge to effectively leverage the power of `notna()`

and enhance your data analysis skills.