dropNaNs

fun <T> DataFrame<T>.dropNaNs(whereAllNaN: Boolean = false, columns: ColumnsSelector<T, *>): DataFrame<T>

The Drop NaN Operation

Removes rows with NaN values. Specific case of drop.

Optionally, you can select which columns to operate on (see org.jetbrains.kotlinx.dataframe.api.DropNaNs.DropNaNsSelectingOptions). Also, you can supply whereAllNaN = true to only drop rows where all selected cells are NaN. By default, rows are dropped if any of the selected cells are NaN.

For more information: See dropNaNs on the documentation website.

See also fillNaNs, which replaces NaN values instead of removing rows.

This Drop NaNs Overload

Select or express columns using the Columns Selection DSL.

This DSL is initiated by a Columns Selector lambda, which operates in the context of the Columns Selection DSL and expects you to return a SingleColumn or ColumnSet (so, a ColumnsResolver). This is an entity formed by calling any (combination) of the functions in the DSL that is or can be resolved into one or more columns.

The Columns Selection DSL allows using Extension Properties for specifying columns type- and name-safe.

Check out: Columns Selection DSL Grammar

    

See Column Selectors on the documentation website.

For example:

df.dropNaNs{ length andage }

df.dropNaNs{ cols(1..5) }

df.dropNaNs{ colsOf<Double>() }

df.dropNaNs(whereAllNaN = true) { colsOf<Double>() }

Parameters

whereAllNaN

false by default. If true, rows are dropped if all selected cells are NaN. If false, rows are dropped if any of the selected cells is NaN.

columns

The Columns Selector used to select the columns of this DataFrame to drop rows in.


fun <T> DataFrame<T>.dropNaNs(vararg columns: String, whereAllNaN: Boolean = false): DataFrame<T>

The Drop NaN Operation

Removes rows with NaN values. Specific case of drop.

Optionally, you can select which columns to operate on (see org.jetbrains.kotlinx.dataframe.api.DropNaNs.DropNaNsSelectingOptions). Also, you can supply whereAllNaN = true to only drop rows where all selected cells are NaN. By default, rows are dropped if any of the selected cells are NaN.

For more information: See dropNaNs on the documentation website.

See also fillNaNs, which replaces NaN values instead of removing rows.

This Drop NaNs Overload

df.dropNaNs("length", whereAllNaN = true)

Parameters

whereAllNaN

false by default. If true, rows are dropped if all selected cells are NaN. If false, rows are dropped if any of the selected cells is NaN.

columns

The Strings corresponding to the names of columns in this DataFrame to drop rows in.


fun <T> DataFrame<T>.dropNaNs(whereAllNaN: Boolean = false): DataFrame<T>

The Drop NaN Operation

Removes rows with NaN values. Specific case of drop.

Optionally, you can select which columns to operate on (see org.jetbrains.kotlinx.dataframe.api.DropNaNs.DropNaNsSelectingOptions). Also, you can supply whereAllNaN = true to only drop rows where all selected cells are NaN. By default, rows are dropped if any of the selected cells are NaN.

For more information: See dropNaNs on the documentation website.

See also fillNaNs, which replaces NaN values instead of removing rows.

This Drop NaNs Overload

This overload operates on all columns in the DataFrame.

Parameters

whereAllNaN

false by default. If true, rows are dropped if all selected cells are NaN. If false, rows are dropped if any of the selected cells is NaN.


The Drop NaN Operation

Removes NaN values from this DataColumn, adjusting the type accordingly.

For more information: See dropNaNs on the documentation website.


fun <T> DataFrame<T>.dropNaNs(vararg columns: KProperty<*>, whereAllNaN: Boolean = false): DataFrame<T>

Deprecated

It's recommended to migrate to the String or Extension Properties Access API https://kotlin.github.io/dataframe/apilevels.html

The Drop NaN Operation

Removes rows with NaN values. Specific case of drop.

Optionally, you can select which columns to operate on (see org.jetbrains.kotlinx.dataframe.api.DropNaNs.DropNaNsSelectingOptions). Also, you can supply whereAllNaN = true to only drop rows where all selected cells are NaN. By default, rows are dropped if any of the selected cells are NaN.

For more information: See dropNaNs on the documentation website.

See also fillNaNs, which replaces NaN values instead of removing rows.

This Drop NaNs Overload

df.dropNaNs(Person::length, whereAllNaN = true)

Parameters

whereAllNaN

false by default. If true, rows are dropped if all selected cells are NaN. If false, rows are dropped if any of the selected cells is NaN.

columns

The KProperties used to select the columns of this DataFrame to drop rows in.


fun <T> DataFrame<T>.dropNaNs(vararg columns: ColumnReference<*>, whereAllNaN: Boolean = false): DataFrame<T>

Deprecated

It's recommended to migrate to the String or Extension Properties Access API https://kotlin.github.io/dataframe/apilevels.html

The Drop NaN Operation

Removes rows with NaN values. Specific case of drop.

Optionally, you can select which columns to operate on (see org.jetbrains.kotlinx.dataframe.api.DropNaNs.DropNaNsSelectingOptions). Also, you can supply whereAllNaN = true to only drop rows where all selected cells are NaN. By default, rows are dropped if any of the selected cells are NaN.

For more information: See dropNaNs on the documentation website.

See also fillNaNs, which replaces NaN values instead of removing rows.

This Drop NaNs Overload

df.dropNaNs(length, whereAllNaN = true)

Parameters

whereAllNaN

false by default. If true, rows are dropped if all selected cells are NaN. If false, rows are dropped if any of the selected cells is NaN.

columns

The Column References used to select the columns of this DataFrame to drop rows in.