このページはお客様の言語に翻訳されていません。 翻訳のリクエスト

REPLACE_WITH_MOST_FREQUENT

PDFRSS

Replaces each invalid value in a column with the most frequent column value.

Parameters

• sourceColumn – The name of an existing column.

• columnDataType – The data type of the column.

• advancedDataType – Special data types that are detected by DataBrew in a column that has the data type string. The types that DataBrew can detect within a string column include SSN, Email, Phone Number, Gender, Credit Card, URL, IP Address, DateTime, Currency, ZipCode, Country, Region, State, and City.

Example

{
    "RecipeAction": {
        "Operation": "REPLACE_WITH_MOST_FREQUENT",
        "Parameters": {
            "columnDataType": "string",
            "sourceColumn": "wind_direction"
        }
    }
}