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.7)cdata_1.2.1.zip(r-4.6)cdata_1.2.1.zip(r-4.5)
cdata_1.2.1.tgz(r-4.6-any)cdata_1.2.1.tgz(r-4.5-any)
cdata_1.2.1.tar.gz(r-4.7-any)cdata_1.2.1.tar.gz(r-4.6-any)
cdata_1.2.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
cdata/json (API)

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

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

Pkgdown/docs site:https://winvector.github.io

On CRAN:

Conda:

7.65 score 43 stars 1 packages 87 scripts 1.1k downloads 27 exports 4 dependencies

Last updated from:ed0adfdc8b. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK125
source / vignettesOK183
linux-release-x86_64OK113
macos-release-arm64OK96
macos-oldrel-arm64OK98
windows-develOK97
windows-releaseOK81
windows-oldrelOK71
wasm-releaseOK96

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

cdata Exercises
Introduction | Example 1 | Example 2 | Example 3 | Example 4 | Example 5 | Reversing Transforms | Package entry points | Conclusion
Rendered fromexercises.Rmdusingknitr::rmarkdown

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

Control Table Keys
Rendered fromcontrol_table_keys.Rmdusingknitr::rmarkdown

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

Block Records and Row Records
Appendix
Rendered fromblocksrecs.Rmdusingknitr::rmarkdown

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

cdata
Rendered fromcdata.Rmdusingknitr::rmarkdown

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

Designing Transforms for Data Reshaping with cdata
Rendered fromdesign.Rmdusingknitr::rmarkdown

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

General Data Transforms With cdata
Rendered fromgeneral_transform.Rmdusingknitr::rmarkdown

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

Operators
Rendered fromoperators.Rmdusingknitr::rmarkdown

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