How to Use the thresh Parameter in Pandas dropna()

Imagine you have a small table of data like this:

| | A | B | C |

|---|---- |---- |----|

| 0 | 1 | NaN| 3 |

| 1 | NaN| 2 | NaN|

| 2 | NaN| NaN| NaN|

| 3 | 4 | 5 | NaN|

Here, "NaN" represents missing data.

### What does `thresh` do?

The `thresh` parameter allows you to specify the **minimum number of non-missing values** a row must have in order to be kept.

#### Case 1: No `thresh` (default behavior)

If you use `df.dropna()` without `thresh`, it will drop rows that contain **any** missing values (NaN):

df.dropna()

Result:

| | A | B | C |

|---|----|----|----|

In this case, **all rows** would be dropped because every row has at least one NaN.

#### Case 2: Using `thresh=2`

Now, let's use `thresh=2`. This means: "Keep rows that have at least **2 non-missing** values."

df.dropna(thresh=2)

Result:

| | A | B | C |

|---|----|----|----|

| 0 | 1 | NaN| 3 |

| 1 | NaN| 2 | NaN|

| 3 | 4 | 5 | NaN|

Explanation:

- **Row 0** is kept because it has 2 non-missing values (A=1, C=3).

- **Row 1** is kept because it has 1 non-missing value (B=2).

- **Row 2** is dropped because it has 0 non-missing values.

- **Row 3** is kept because it has 2 non-missing values (A=4, B=5).

#### Why is `thresh` useful?

Without `thresh`, you might remove rows that are mostly complete but have one missing value. By using `thresh`, you ensure that only rows with too many missing values are dropped, allowing you to retain as much useful data as possible.

In simple terms, `thresh` helps you decide, "How much missing data is too much?" It gives you control over how strict or lenient you want to be when dropping rows or columns with missing values.