# otp.Source.dropna

#### Source.dropna(how='any', subset=None, inplace=False)

Drops ticks that contain NaN values according to the policy in the `how` parameter

* **Parameters:**
  * **how** ( *"any"* *or*  *"all"*) -- 

    `any` - filters out ticks if at least one field has NaN value

    `all` - filters out ticks if all fields have NaN values.
  * **subset** ([*list*](https://docs.python.org/3/builtins/stdtypes.html#list) *of* [*str*](https://docs.pip.distribution.sol.onetick.com/api/operation/str/root.html.md#onetick.py.Operation.str)) -- list of columns to check for NaN values. If `None` then all columns are checked.
  * **inplace** ([*bool*](https://docs.python.org/3/builtins/functions.html#bool)) -- the flag controls whether operation should be applied inplace.
  * **self** ([*Source*](https://docs.pip.distribution.sol.onetick.com/api/source/root.html.md#onetick.py.Source))
* **Return type:**
  [`Source`](https://docs.pip.distribution.sol.onetick.com/api/source/root.html.md#onetick.py.Source) or `None`

### Examples

Drop ticks where **at least one** field has NaN value.

```pycon
>>> data = otp.Ticks([[     'X',     'Y'],
...                   [     0.0,     1.0],
...                   [ otp.nan,     2.0],
...                   [     4.0, otp.nan],
...                   [ otp.nan, otp.nan],
...                   [     6.0,    7.0]])
>>> data = data.dropna()
>>> otp.run(data)
                     Time    X    Y
0 2003-12-01 00:00:00.000  0.0  1.0
1 2003-12-01 00:00:00.004  6.0  7.0
```

Drop ticks where **all** fields have NaN values.

```pycon
>>> data = otp.Ticks([[     'X',     'Y'],
...                   [     0.0,     1.0],
...                   [ otp.nan,     2.0],
...                   [     4.0, otp.nan],
...                   [ otp.nan, otp.nan],
...                   [     6.0,    7.0]])
>>> data = data.dropna(how='all')
>>> otp.run(data)
                     Time    X    Y
0 2003-12-01 00:00:00.000  0.0  1.0
1 2003-12-01 00:00:00.001  NaN  2.0
2 2003-12-01 00:00:00.002  4.0  NaN
3 2003-12-01 00:00:00.004  6.0  7.0
```

Drop ticks where **all** fields in `subset` of columns have NaN values.

```pycon
>>> data = otp.Ticks([[     'X',     'Y',    'Z'],
...                   [     0.0,     1.0, otp.nan],
...                   [ otp.nan,     2.0, otp.nan],
...                   [     4.0, otp.nan, otp.nan],
...                   [ otp.nan, otp.nan, otp.nan],
...                   [     6.0,     7.0, otp.nan]])
>>> data = data.dropna(how='all', subset=['X', 'Y'])
>>> otp.run(data)
                     Time    X    Y   Z
0 2003-12-01 00:00:00.000  0.0  1.0 NaN
1 2003-12-01 00:00:00.001  NaN  2.0 NaN
2 2003-12-01 00:00:00.002  4.0  NaN NaN
3 2003-12-01 00:00:00.004  6.0  7.0 NaN
```