Transform

Constitutes the set of Gems that help with transforming data.

📄️ Reformat

Select one or more columns or values using expressions and functions.

Filter your data based on a custom filter condition

Sort your data based on one or more Columns

Group data and apply aggregation methods or pivot operations

Flatten nested data

Add, Edit, Rename or Drop Columns

Limit the number of rows

Remove rows with duplicate values of specified columns

Union, Intersect and Difference

Aggregate and transform Windowed data

Rename multiple columns in your Dataset in a systematic way.

Change the data type of multiple columns at once.

Standardize data formats and address missing or null values in the data.

Dynamically filter columns of your dataset based on a set of conditions.

Use the Unpivot Gem to transform your data from a wide format to a long format.