Fluid Data Transformations
Map data records from block records to row records.
Map sets rows to columns (query based, take name of table).
Create a block records to row records transform specification.
Build a blocks_to_rowrecs()/rowrecs_to_blocks() control table that spe...
Build a blocks_to_rowrecs_q() control table that specifies a pivot (qu...
Build a rowrecs_to_blocks() control table that specifies a un-pivot (o...
cdata: Fluid Data Transformations.
Check columns form unique keys
Convert a layout_specification, blocks_to_rowrecs_spec, or rowrecs_to_...
General transform from arbitrary record shape to arbitrary record shap...
Read a cdata record transform from a simple object (such as is importe...
Upack details of a cdata record transform.
Factor-out (aggregate/project) block records into row records.
Multiply/join row records into block records.
Use transform spec to layout data.
Use transform spec to layout data.
Use transform spec to layout data.
Use transform spec to layout data.
Create a record to record spec.
Map field values from one column into new derived columns (takes a `da...
Map field values from one column into new derived columns (query based...
Map data records from block records that have one row per measurement ...
Quick look at remote data
Map a data records from row records to block records.
Map a set of columns to rows (query based, take name of table).
Create a row records to block records transform specification.
Check if table rows are uniquely keyed by keyset.
Map a data records from row records to block records with one record r...
Supplies higher-order coordinatized data specification and fluid transform operators that include pivot and anti-pivot as special cases. The methodology is describe in 'Zumel', 2018, "Fluid data reshaping with 'cdata'", <https://winvector.github.io/FluidData/FluidDataReshapingWithCdata.html> , <DOI:10.5281/zenodo.1173299> . This package introduces the idea of explicit control table specification of data transforms. Works on in-memory data or on remote data using 'rquery' and 'SQL' database interfaces.
Useful links