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 revisionPrevious revision
Next revisionBoth sides next revision
transformations:start [2019/10/08 12:46] dmitrytransformations:start [2019/12/07 12:31] – added 7 more actions dmitry
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.txt · Last modified: 2024/02/03 18:00 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki