Data Preparation Bricks

Replace all values in columns with a fixed value.

Fill empty/null cells in columns with a fixed value.

Fill empty cells with previous (forward fill) or next (backward fill) non-empty value.

Filter rows from the dataset that contain a specific boolean value, or clear content from matching cells.

Filter rows from the dataset using a date filter defined by a fixed date range, relative date range, or matching date part.

Filter rows from the dataset that contain numbers within a numerical range, or clear content from matching cells.

Filter rows from the dataset that contain specific textual values, or clear content from matching cells.

Find and replace strings in one or more columns with multiple replacement patterns.

Flag rows from the dataset using a date filter defined by a fixed date range, relative date range, or matching date part. Creates a new column with '1' for matching rows.

Flag rows from the dataset that contain numbers within a numerical range by creating a new column with '1' for matching rows.

Flag rows from the dataset that contain specific textual values by creating a flag column.

Transform wide dataset to narrow format by folding/melting columns (opposite of pivot).