Dealing with NaN's

[sijo]

@rafael.guerra

To remove all rows with NaNs in any column, what are simpler methods than using bitvectors as follows:

Here’s one way using filter:

# Using a lambda that receives a named tuple for each row
filter(AsTable(:) => row->!any(isnan(x) for x in row), df)

You could also write filter(row->!any(isnan(x) for x in row), df) but that’s slower.

Or you could write filter((:) => (values...)->!any(isnan.(values)), df) to use a lambda that receives the row as one parameter per column, but that’s even slower apparently.