Data Preparation Bricks

Back to Package Page

Force Numerical Range

Function

Creates upper and/or lower bounds in numerical columns by clipping or clearing outliers.
Group Data

Function

Group data by specified columns and apply aggregation functions (distinct, max, min, avg, median, sum, std, count, first, last, concat).
Impute Missing Values

Function

Impute missing values in numerical columns with mean, median, or mode.
Join Data

Function

Enrich one dataset with columns from another using various join types (inner, left, right, full outer, cross).
Keep Columns

Function

Keep only specified columns in a DataFrame or Arrow Table.
Move Columns

Function

Move one or more columns to a specific position in a DataFrame or Arrow Table.
Negate Boolean

Function

Transform boolean values to their negation (TRUE to FALSE, FALSE to TRUE).
Numerical Combinations

Function

Combine every pair of numerical columns with standard + - × ÷ operations.
Pivot Table

Function

Reshape a dataset from long to wide format by pivoting a column and aggregating values.
Read Data File

Function

Read data from files supporting multiple standard formats (parquet, json, csv, excel).
Remove Empty Rows

Function

Remove rows where specified cells are empty/null.
Rename Columns

Function

Rename columns in a DataFrame or Arrow Table.