Package: cdata 1.2.1

John Mount

cdata: Fluid Data Transformations

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.

Authors:John Mount [aut, cre], Nina Zumel [aut], Win-Vector LLC [cph]

cdata_1.2.1.tar.gz
cdata_1.2.1.zip(r-4.5)cdata_1.2.1.zip(r-4.4)cdata_1.2.1.zip(r-4.3)
cdata_1.2.1.tgz(r-4.4-any)cdata_1.2.1.tgz(r-4.3-any)
cdata_1.2.1.tar.gz(r-4.5-noble)cdata_1.2.1.tar.gz(r-4.4-noble)
cdata_1.2.1.tgz(r-4.4-emscripten)cdata_1.2.1.tgz(r-4.3-emscripten)
cdata.pdf |cdata.html
cdata/json (API)
NEWS

# Install 'cdata' in R:
install.packages('cdata', repos = c('https://winvector.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/winvector/cdata/issues

On CRAN:

27 exports 44 stars 3.06 score 4 dependencies 1 dependents 69 scripts 2.2k downloads

Last updated 1 years agofrom:7065a82bac. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKSep 13 2024
R-4.5-winOKSep 13 2024
R-4.5-linuxOKSep 13 2024
R-4.4-winOKSep 13 2024
R-4.4-macOKSep 13 2024
R-4.3-winOKSep 13 2024
R-4.3-macOKSep 13 2024

Exports:%**%%//%blocks_to_rowrecsblocks_to_rowrecs_qblocks_to_rowrecs_specbuild_pivot_controlbuild_pivot_control_qbuild_unpivot_controlcheck_cols_form_unique_keysconvert_cdata_spec_to_yamlconvert_recordsconvert_yaml_to_cdata_specget_transform_detailslayout_bylayout_specificationlayout_to_blockslayout_to_rowrecsmap_fieldsmap_fields_qpivot_to_blockspivot_to_rowrecsqlookrowrecs_to_blocksrowrecs_to_blocks_qrowrecs_to_blocks_specrows_are_uniquely_keyedunpivot_to_blocks

Dependencies:data.tablerqdatatablerquerywrapr

Block Records and Row Records

Rendered fromblocksrecs.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2020-08-11
Started: 2018-10-23

cdata

Rendered fromcdata.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2020-08-11
Started: 2017-11-12

cdata Exercises

Rendered fromexercises.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2023-08-19
Started: 2019-04-25

Control Table Keys

Rendered fromcontrol_table_keys.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2021-06-11
Started: 2019-02-09

Designing Transforms for Data Reshaping with cdata

Rendered fromdesign.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2020-08-11
Started: 2018-10-23

General Data Transforms With cdata

Rendered fromgeneral_transform.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2020-08-11
Started: 2019-01-20

Operators

Rendered fromoperators.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2020-01-23
Started: 2019-03-25

Readme and manuals

Help Manual

Help pageTopics
'cdata': Fluid Data Transformations.cdata-package cdata
Multiply/join row records into block records.%**%
Factor-out (aggregate/project) block records into row records.%//%
Map data records from block records to row records.blocks_to_rowrecs blocks_to_rowrecs.default blocks_to_rowrecs.relop
Create a block records to row records transform specification.blocks_to_rowrecs_spec
Build a blocks_to_rowrecs()/rowrecs_to_blocks() control table that specifies a pivot from a 'data.frame'.build_pivot_control build_pivot_control.default build_pivot_control.relop
Build a rowrecs_to_blocks() control table that specifies a un-pivot (or "shred").build_unpivot_control
Convert a layout_specification, blocks_to_rowrecs_spec, or rowrecs_to_blocks_spec to a simple object.convert_cdata_spec_to_yaml
General transform from arbitrary record shape to arbitrary record shape.convert_records
Read a cdata record transform from a simple object (such as is imported from YAML).convert_yaml_to_cdata_spec
Use transform spec to layout data.layout_by
Use transform spec to layout data.layout_by.blocks_to_rowrecs_spec
Use transform spec to layout data.layout_by.cdata_general_transform_spec
Use transform spec to layout data.layout_by.rowrecs_to_blocks_spec
Create a record to record spec.layout_specification
Map field values from one column into new derived columns (takes a 'data.frame').map_fields
Map field values from one column into new derived columns (query based, takes name of table).map_fields_q
Map data records from block records that have one row per measurement value to row records.layout_to_rowrecs pivot_to_rowrecs
Map a data records from row records to block records.rowrecs_to_blocks rowrecs_to_blocks.default rowrecs_to_blocks.relop
Create a row records to block records transform specification.rowrecs_to_blocks_spec
Map a data records from row records to block records with one record row per columnsToTakeFrom value.layout_to_blocks pivot_to_blocks unpivot_to_blocks unpivot_to_blocks.default unpivot_to_blocks.relop