Package: datadaptor 0.0.0.9000

datadaptor: Modify Labelled Data Sets With Excel Files

An R package to modify labelled data sets with commands in Excel files. The commands in this package allow to create new variables, and modify the labels of the variables, as well as the variables themselves. The goal is to provide an easy & concise syntax, and to allow for fast systematic data entry using Excel for advanced users. The commands work on the variables inside the data.frame environment (like e.g. inside dplyr verbs), thus providing an approach that might ease the use for people without in-depth programming experience.

Authors:Urs Wilke [aut, cre], Wolf Wilke [aut]

datadaptor_0.0.0.9000.tar.gz
datadaptor_0.0.0.9000.zip(r-4.5)datadaptor_0.0.0.9000.zip(r-4.4)datadaptor_0.0.0.9000.zip(r-4.3)
datadaptor_0.0.0.9000.tgz(r-4.5-any)datadaptor_0.0.0.9000.tgz(r-4.4-any)datadaptor_0.0.0.9000.tgz(r-4.3-any)
datadaptor_0.0.0.9000.tar.gz(r-4.5-noble)datadaptor_0.0.0.9000.tar.gz(r-4.4-noble)
datadaptor_0.0.0.9000.tgz(r-4.4-emscripten)datadaptor_0.0.0.9000.tgz(r-4.3-emscripten)
datadaptor.pdf |datadaptor.html
datadaptor/json (API)

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

Bug tracker:https://gitlab.com/urswilke/datadaptor

Pkgdown site:https://urswilke.gitlab.io

Datasets:

On CRAN:

Conda:

5.13 score 1 packages 17 exports 49 dependencies

Last updated 21 days agofrom:a43647a491. Checks:3 OK, 5 NOTE. Indexed: yes.

TargetResultLatest binary
Doc / VignettesOKFeb 17 2025
R-4.5-winNOTEFeb 17 2025
R-4.5-macNOTEFeb 17 2025
R-4.5-linuxNOTEFeb 17 2025
R-4.4-winNOTEFeb 17 2025
R-4.4-macNOTEFeb 17 2025
R-4.3-winOKFeb 17 2025
R-4.3-macOKFeb 17 2025

Exports:%>%apply_commandcreate_mappingcreate_mapping_workbookcurlychopdiff_dataformat_sheet_datagen_data_tablegen_label_tablegen_var_tableget_mapping_optionsis_true_vecMappingread_data_safer_envset_na_to_filteruse_known_args

Dependencies:BHbitbit64cellrangerclicliprcpp11crayondigestdplyrfansiforcatsfsgenericsgluehavenhmslabelledlifecyclemagrittropenxlsx2pillarpkgconfigpowerjoinprettyunitsprogresspurrrqsR6RApiSerializeRcppRcppParallelreadrreadxlrematchrlangstringfishstringistringrtibbletidyrtidyselecttzdbutf8vctrsvroomwithrwritexlzip

debugging

Rendered fromdebugging.Rmdusingknitr::rmarkdownon Feb 17 2025.

Last update: 2024-12-29
Started: 2021-02-06

Documentation of the Excel mapping command blocks

Rendered fromcommand_blocks.Rmdusingknitr::rmarkdownon Feb 17 2025.

Last update: 2025-02-17
Started: 2022-01-14

Included data sets and files in the package

Rendered fromincluded_data.Rmdusingknitr::rmarkdownon Feb 17 2025.

Last update: 2025-01-07
Started: 2020-12-06

Introduction to survey data tabulation in R

Rendered fromsurvey_data_tabulation.Rmdusingknitr::rmarkdownon Feb 17 2025.

Last update: 2024-12-29
Started: 2022-08-10

Translating the Excel mapping commands to R

Rendered fromtranslating_command_blocks_to_R.Rmdusingknitr::rmarkdownon Feb 17 2025.

Last update: 2024-12-29
Started: 2022-08-10

Readme and manuals

Help Manual

Help pageTopics
Apply a command block to the dataapply_command apply_command.cmd_across apply_command.cmd_addfile apply_command.cmd_add_labs apply_command.cmd_autorec apply_command.cmd_comp apply_command.cmd_debug apply_command.cmd_dic apply_command.cmd_drop apply_command.cmd_filter apply_command.cmd_if apply_command.cmd_kg apply_command.cmd_merge apply_command.cmd_newlab apply_command.cmd_newvall apply_command.cmd_r apply_command.cmd_rec apply_command.cmd_recna_xcpt apply_command.cmd_rename apply_command.cmd_rename_varsheet apply_command.cmd_rfun apply_command.cmd_rmval apply_command.cmd_select apply_command.cmd_set_lab apply_command.cmd_set_labs apply_command.cmd_str_to_num apply_command.cmd_sumvar apply_command.cmd_verbatim apply_command.cmd_verbatim_custom apply_command_args
'command_block' overviewcommand_block_classes
Create an Excel mapping file based on a labelled dataframecreate_mapping
Create a mapping openxlsx2 workbook objectcreate_mapping_workbook
Multiply repetitive parts of command blocks using curly bracescurlychop
Diff to labelled data framesdiff_data
Format the dataframe returned by reading an excel sheet with 'openxlsx2::wb_read()'format_sheet_data
Toy data of a fictional survey about fruitsfruit_survey
Generate data counts tablegen_data_table
Mapping parametersget_mapping_options
Generate tables with the variables' labelsgen_label_table gen_var_table label_tables
Mapping classMapping
Labelled mtcars versionmtcars_labelled
Ingest data from data.frame or file pathread_data_
Execution environmentssafer_env
Apply function on the subset of arguments it knowsuse_known_args