DataFlow.ReplaceNa Method

Definition

Namespace:: Microsoft.DataPrep.Common

Assembly:: Microsoft.DataPrep.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Overloads

ReplaceNa(ColumnsSelector, Boolean, Boolean, Boolean, String)	Replaces values in the specified columns with nulls. You can choose to use the default list, supply your own, or both.
ReplaceNa(String, Boolean, Boolean, Boolean, String)	Replaces values in the specified columns with nulls. You can choose to use the default list, supply your own, or both.
ReplaceNa(String[], Boolean, Boolean, Boolean, String)	Replaces values in the specified columns with nulls. You can choose to use the default list, supply your own, or both.

ReplaceNa(ColumnsSelector, Boolean, Boolean, Boolean, String)

Replaces values in the specified columns with nulls. You can choose to use the default list, supply your own, or both.

public Microsoft.DataPrep.Common.DataFlow ReplaceNa(Microsoft.DPrep.Engine.PropertiesSystem.ColumnsSelector columns, bool useDefaultNaList = true, bool useEmptyStringAsNa = true, bool useNanAsNa = true, string customNaList = null);

member this.ReplaceNa : Microsoft.DPrep.Engine.PropertiesSystem.ColumnsSelector * bool * bool * bool * string -> Microsoft.DataPrep.Common.DataFlow

Public Function ReplaceNa (columns As ColumnsSelector, Optional useDefaultNaList As Boolean = true, Optional useEmptyStringAsNa As Boolean = true, Optional useNanAsNa As Boolean = true, Optional customNaList As String = null) As DataFlow

Parameters

columns: Microsoft.DPrep.Engine.PropertiesSystem.ColumnsSelector

The source columns.

useDefaultNaList: Boolean

Use the default list and replace 'null', 'NaN', 'NA', and 'N/A' with null.

useEmptyStringAsNa: Boolean

Replace empty strings with null.

useNanAsNa: Boolean

Replace NaNs with Null.

customNaList: String

Provide a comma separated list of values to replace with null.

Returns

DataFlow

Applies to

ReplaceNa(String, Boolean, Boolean, Boolean, String)

Replaces values in the specified columns with nulls. You can choose to use the default list, supply your own, or both.

public Microsoft.DataPrep.Common.DataFlow ReplaceNa(string columnName, bool useDefaultNaList = true, bool useEmptyStringAsNa = true, bool useNanAsNa = true, string customNaList = null);

member this.ReplaceNa : string * bool * bool * bool * string -> Microsoft.DataPrep.Common.DataFlow

Public Function ReplaceNa (columnName As String, Optional useDefaultNaList As Boolean = true, Optional useEmptyStringAsNa As Boolean = true, Optional useNanAsNa As Boolean = true, Optional customNaList As String = null) As DataFlow

Parameters

columnName: String

The source columns.

useDefaultNaList: Boolean

Use the default list and replace 'null', 'NaN', 'NA', and 'N/A' with null.

useEmptyStringAsNa: Boolean

Replace empty strings with null.

useNanAsNa: Boolean

Replace NaNs with Null.

customNaList: String

Provide a comma separated list of values to replace with null.

Returns

DataFlow

Applies to

ReplaceNa(String[], Boolean, Boolean, Boolean, String)

Replaces values in the specified columns with nulls. You can choose to use the default list, supply your own, or both.

public Microsoft.DataPrep.Common.DataFlow ReplaceNa(string[] columnNames, bool useDefaultNaList = true, bool useEmptyStringAsNa = true, bool useNanAsNa = true, string customNaList = null);

member this.ReplaceNa : string[] * bool * bool * bool * string -> Microsoft.DataPrep.Common.DataFlow

Public Function ReplaceNa (columnNames As String(), Optional useDefaultNaList As Boolean = true, Optional useEmptyStringAsNa As Boolean = true, Optional useNanAsNa As Boolean = true, Optional customNaList As String = null) As DataFlow

Parameters

columnNames: String[]

The source columns.

useDefaultNaList: Boolean

Use the default list and replace 'null', 'NaN', 'NA', and 'N/A' with null.

useEmptyStringAsNa: Boolean

Replace empty strings with null.

useNanAsNa: Boolean

Replace NaNs with Null.

customNaList: String

Provide a comma separated list of values to replace with null.

Returns

DataFlow

Applies to