User Tools

Site Tools


transformations:start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
transformations:start [2019/10/08 16:46]
dmitry
transformations:start [2019/12/07 17:31] (current)
dmitry added 7 more actions
Line 37: Line 37:
   * [[transformations:​enumerate|Enumerate rows]] - add column with row numbers.   * [[transformations:​enumerate|Enumerate rows]] - add column with row numbers.
   * [[transformations:​lookup|Lookup]] - replace values in a column using a lookup table.   * [[transformations:​lookup|Lookup]] - replace values in a column using a lookup table.
 +  * [[transformations:​makedatetimecolumns|Make date/time columns]] - Create column(s) with date/time attributes derived from a date column.
   * [[transformations:​merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match.   * [[transformations:​merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match.
   * [[transformations:​repeatrows|Repeat rows]] - repeat each row as many times as specified in given column.   * [[transformations:​repeatrows|Repeat rows]] - repeat each row as many times as specified in given column.
Line 51: Line 52:
  
 ==== Transform / Advanced ==== ==== Transform / Advanced ====
 +  * [[transformations:​constructjson|Construct JSON]] - Construct a JSON object.
 +  * [[transformations:​createbuckets|Create buckets]] - Create ranges of fixed width and assign each row to one of the ranges.
   * [[transformations:​crossmerge|Cross merge]] - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables.   * [[transformations:​crossmerge|Cross merge]] - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables.
   * [[transformations:​enumerategroups|Enumerate Groups]] - Enumerate all combinations of values in given columns.   * [[transformations:​enumerategroups|Enumerate Groups]] - Enumerate all combinations of values in given columns.
Line 58: Line 61:
   * [[transformations:​group|Group]] - Assign a group name (or flag) to selected column values.   * [[transformations:​group|Group]] - Assign a group name (or flag) to selected column values.
   * [[transformations:​intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns.   * [[transformations:​intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns.
 +  * [[transformations:​iteratecolumns|Iterate columns]] - Iterate module/​project by passing it columns one by one. Append the results back into one table.
   * [[transformations:​labelcolumns|Label columns]] - Name columns using values from top rows.   * [[transformations:​labelcolumns|Label columns]] - Name columns using values from top rows.
   * [[transformations:​match|Match]] - Find text strings in another table, that are contained in the current table.   * [[transformations:​match|Match]] - Find text strings in another table, that are contained in the current table.
 +  * [[transformations:​parsejson|Parse JSON]] - Parse a JSON object into a tabular dataset.
   * [[transformations:​pivot|Pivot]] - Create a matrix table by pivoting.   * [[transformations:​pivot|Pivot]] - Create a matrix table by pivoting.
   * [[transformations:​regexp|Regular expression]] - Create a new column with regular expression matches.   * [[transformations:​regexp|Regular expression]] - Create a new column with regular expression matches.
Line 89: Line 94:
   * [[transformations:​keeptop|Trim table]] - keep/remove top/bottom N rows.   * [[transformations:​keeptop|Trim table]] - keep/remove top/bottom N rows.
   * [[transformations:​trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition.   * [[transformations:​trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition.
 +
 +==== Transform / Math ====
 +  * [[transformations:​linearregression|Linear regression]] - Build a linear regression. Interpolate/​extrapolate values if needed.
 +  * [[transformations:​statisticalaggregation|Statistical aggregation]] - Calculate median, percentile, standard error, standard deviation, or variance.
  
 ==== Export ==== ==== Export ====
transformations/start.1570553208.txt.gz · Last modified: 2019/10/08 16:46 by dmitry