Documentation

    Prep

    Prep blocks clean a single table and get it ready to use. Choose columns, filter rows, fix types and missing values, remove duplicates and calculate new columns.

    Blocks in this palette

    • Number every row.

    • Choose, rename, reorder and convert columns.

    • Detect column types from their values.

    • Trim text, fix capitals and round decimals.

    • Order rows or add a rank column.

    • Rank rows by how closely they resemble a search term.

    • Calculate new columns with SQL expressions.

    • Split rows by a condition.

    • Keep some of the rows, or balance classes.

    • Divide rows into train, validation and test.

    • Find or remove duplicates.

    • Replace missing values.

    • Put numbers on a common scale.

    • Group numbers into ranges.

    • Turn categories into numbers.

    • Fill gaps in ordered data.

    Prep FAQs

    Which block removes rows?
    Filter removes rows by a condition, Unique removes duplicates and Sample keeps a fixed number or share of rows.
    How do I fill in missing values?
    Impute uses a fixed value or a statistic such as the mean. Interpolation uses neighboring values in ordered data.
    Where do I calculate a new column?
    Use Formula for a calculation on each row. For totals across rows, use Summarize in the Transform palette.

    Prepare your data. Build it in Strata.

    Strata opens in your browser, with no account.