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.