Skip to main content

Transformations

Easily transform your data by summarizing key metrics for unique values, merging datasets together, and more.

Concat​

Appends columns or rows from a second dataset onto the existing dataset.

Concat

YouTube video coming soon

Filter​

Filter the dataset by identifying rows that are greater than, less than, or equal to a specified value.

Filter

Group By​

Splits data into groups, applies a function to each, and then combines the results.

Group By

Melt​

Typically used to transform from a long dataset to a wide a dataset.

Melt

YouTube video coming soon

Merge​

Merge two datasets together.

Merge

YouTube video coming soon

Pivot​

This is similar to pivot tables in excel, it reshapes a dataset.

Pivot

YouTube video coming soon

Shift​

This can moves rows up or down. This is often utilized with time series data when a variable needs to be lagged or pushed forward.

Shift

YouTube video coming soon

Cut​

Utilized when data needs to be segmented and sort data values into bins.

Cut

YouTube video coming soon

Q Cut​

Tries dividing the data into equal sized bins.

Use Quantile Cut when you want bins with an approximately equal number of data points in each.

Q Cut

YouTube video coming soon