Clean/Prepare

Missing Value Treatment, Outlier Treatment, Type-casts, etc.

Augment (Add New Columns)

Arithmetic Transforms, Running and Time-Window Stats, Shifts/Leads/Lags, Geo-Coding, etc.

Convert to Time-Series

Mean, First, Last, Sum, Count, Max, Min, etc.

Rollup Data by Group

Mean, Median, Sum, Differences, Unique-Counts, Concentration Indices, First, Last, Contents, etc.

Flatten Data

Aggregate Attributes, Unique Attributes, etc.

Filter Data

Apply Filters on Data, and make filtered data-sets.

Coming Soon

Join Data (DB-Style)

Indexed joins (including lookup-style). Inner and Outer Joins. And multiple files.