> For the complete documentation index, see [llms.txt](https://docs.rasgoml.com/rasgo-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rasgoml.com/rasgo-docs/rasgo-0.1/all-transforms/dropna.md).

# Dropna

Remove missing values

## Parameters

| Name   | Type         | Description                                                                                                                                                                    | Is Optional |
| ------ | ------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ----------- |
| how    | value        | Method to determine if record is removed, 'any' removes each record with at least one missing value, 'all' removes records only when all values are missing (default = 'any'). | True        |
| subset | column\_list | List of columns to check for missing values. All columns are checked if not defined.                                                                                           | True        |
| thresh | int          | (Optional) Acts like all, but only requires this number of values to be null to remove a record instead of all.                                                                | True        |

## Example

```python
ds = rasgo.get.dataset(id)

ds2 = ds.dropna(how='all', subset=['ORDERS', 'SALES'])
ds2.preview()
```

## Source Code

{% embed url="<https://github.com/rasgointelligence/RasgoTransforms/blob/main/rasgotransforms/rasgotransforms/transforms/dropna/dropna.sql>" %}