---
title: "Clean and prepare data in Strata | Oplema"
description: "Clean and prepare a table in Strata: choose columns, filter rows, fix types and missing values, remove duplicates and calculate new columns."
url: "https://oplema.com/docs/strata/prep"
updated: "2026-11-04"
---

# 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.

**Learn these blocks in context:** [Build a report from a CSV export](https://oplema.com/learn/export-to-report); [Combine and reconcile data files](https://oplema.com/learn/many-sources); [Build and publish a dashboard](https://oplema.com/learn/table-to-dashboard)

## 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.

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [About Strata](https://oplema.com/strata)
