Package: datadaptor 1.0.0

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_1.0.0.tar.gz
datadaptor_1.0.0.zip(r-4.7)datadaptor_1.0.0.zip(r-4.6)datadaptor_1.0.0.zip(r-4.5)
datadaptor_1.0.0.tgz(r-4.6-any)datadaptor_1.0.0.tgz(r-4.5-any)
datadaptor_1.0.0.tar.gz(r-4.7-any)datadaptor_1.0.0.tar.gz(r-4.6-any)
datadaptor_1.0.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION
card.svg |card.png
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://codeberg.org/urswilke/datadaptor

Pkgdown/docs site:https://urswilke.codeberg.page

Datasets:

On CRAN:

Conda:

4.65 score 1 packages 17 exports 42 dependencies

Last updated from:8dd66ef329. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK164
source / vignettesOK241
linux-release-x86_64OK167
macos-release-arm64OK172
macos-oldrel-arm64OK124
windows-develOK105
windows-releaseOK97
windows-oldrelOK114
wasm-releaseOK152

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:bitbit64cellrangerclicliprcpp11crayondigestdplyrforcatsfsgenericsgluehavenhmslabelledlifecyclemagrittropenxlsx2pillarpkgconfigpowerjoinprettyunitsprogresspurrrR6Rcppreadrreadxlrematchrlangstringistringrtibbletidyrtidyselecttzdbutf8vctrsvroomwithrwritexl

Documentation of the Excel mapping command blocks
Command block overview | Command block examples | Illustration of labelled datasets | Free sheets | #VARL | #VALL | #AVALL | #RMVAL | #COMP | Example | #IF | #REC | #KG | #SELECT | #RENAME | #ACROSS | curlychop() | Variables sheets | #RENAME_varsheet | #NEWLAB | #DROP | #STR2NUM | #AUTORECODE | Label sheets | #SUMVAR | #NEWVALL | #RECNA
Rendered fromcommand_blocks.Rmdusingknitr::rmarkdown

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

Included data sets and files in the package
Included labelled data | Mapping file
Rendered fromincluded_data.Rmdusingknitr::rmarkdown

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

debugging
Debugging
Rendered fromdebugging.Rmdusingknitr::rmarkdown

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

Introduction to survey data tabulation in R
R for beginners | Setup | Survey data | Toy survey | Q1. what's your age? | Q2. What's your gender? | Q3. Select all that applies | Q4. Please rate the following items | Survey data in R | Labelled variables | Making up a dataset of the toy survey | Question types | Numeric variable | Categorical variable | Multiple choice questions | Multiple answers on the same scale | Tabulation of frequency counts of survey data
Rendered fromsurvey_data_tabulation.Rmdusingknitr::rmarkdown

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

Translating the Excel mapping commands to R
Excel sheets parsed | Parse the sheets to an R list object | Raw command table | Generating "command_block"s | Overview command table | args overview table | Apply command blocks
Rendered fromtranslating_command_blocks_to_R.Rmdusingknitr::rmarkdown

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