此頁面尚未翻譯為您的語言。 請求翻譯

REPLACE_WITH_MODE

PDFRSS

Replaces each invalid value in a column with the mode of all other values.

Parameters

• sourceColumn – The name of an existing column.

• columnDataType – The data type of the column. This type must be number.

• modeType – How to resolve tie values in the data. This value must be MINIMUM, NONE, AVERAGE, or MAXIMUM.

Example

{
    "RecipeAction": {
        "Operation": "REPLACE_WITH_MODE",
        "Parameters": {
            "columnDataType": "number",
            "modeType": "MAXIMUM",
            "sourceColumn": "height_cm"
        }
    }
}