{ "_id": "6a1f1c6cb401979e7341f87c", "Package": "datadaptor", "Title": "Modify Labelled Data Sets With Excel Files", "Version": "1.0.0", "Authors@R": "c(\nperson(given = \"Urs\",\nfamily = \"Wilke\",\nrole = c(\"aut\", \"cre\"),\nemail = \"urs.wilke@gmail.com\",\ncomment = c(ORCID = \"0000-0001-7257-2524\")),\nperson(given = \"Wolf\",\nfamily = \"Wilke\",\nrole = c(\"aut\"),\nemail = \"wilke@data-connection.de\")\n)", "Description": "An R package to modify labelled data sets with commands in\nExcel files. The commands in this package allow to create new\nvariables, and modify the labels of the variables, as well as\nthe variables themselves. The goal is to provide an easy &\nconcise syntax, and to allow for fast systematic data entry\nusing Excel for advanced users. The commands work on the\nvariables inside the data.frame environment (like e.g. inside\ndplyr verbs), thus providing an approach that might ease the\nuse for people without in-depth programming experience.", "License": "AGPL (>= 3) + file LICENSE", "Config/testthat/edition": "3", "Encoding": "UTF-8", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "VignetteBuilder": "knitr", "Language": "en-US", "URL": "https://urswilke.codeberg.page/datadaptor/,\nhttps://codeberg.org/urswilke/datadaptor,\nhttps://urswilke.r-universe.dev/datadaptor", "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libx11-dev\nzlib1g-dev", "Repository": "https://urswilke.r-universe.dev", "Date/Publication": "2026-04-16 15:57:48 UTC", "RemoteUrl": "https://codeberg.org/urswilke/datadaptor", "RemoteRef": "HEAD", "RemoteSha": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-16 08:58:53 UTC", "User": "root" }, "Author": "Urs Wilke [aut, cre] (ORCID: ),\nWolf Wilke [aut]", "Maintainer": "Urs Wilke ", "MD5sum": "7fcd737f8e1c504aab1c921aaeef439e", "_user": "urswilke", "_type": "src", "_file": "datadaptor_1.0.0.tar.gz", "_fileid": "00fb9de915b6f1291eda3aaa0e378382cd1b7000ebb52465585b49a8d868b73c", "_filesize": 442835, "_sha256": "00fb9de915b6f1291eda3aaa0e378382cd1b7000ebb52465585b49a8d868b73c", "_created": "2026-05-16T08:58:53.000Z", "_published": "2026-06-02T18:09:48.212Z", "_distro": "noble", "_jobs": [ { "job": 79139737173, "time": 179, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7032154982" }, { "job": 79139737649, "time": 171, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7032154222" }, { "job": 79139737793, "time": 99, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7032147318" }, { "job": 79139737142, "time": 112, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7032148426" }, { "job": 79139736750, "time": 240, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7032137576" }, { "job": 79139736652, "time": 129, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7366039476" }, { "job": 79139737394, "time": 160, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7032153282" }, { "job": 79139737590, "time": 110, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7032148285" }, { "job": 79139737252, "time": 99, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7032147206" } ], "_buildurl": "https://github.com/r-universe/urswilke/actions/runs/25957835526", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://codeberg.org/urswilke/datadaptor", "_commit": { "id": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "author": "urswilke ", "committer": "urswilke ", "message": "Increment version number to 1.0.0\n", "time": 1776355068 }, "_maintainer": { "name": "Urs Wilke", "email": "urs.wilke@gmail.com", "login": "urswilke", "uuid": 13970666, "orcid": "0000-0001-7257-2524" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2.0", "role": "Depends" }, { "package": "dplyr", "version": ">= 1.0.8", "role": "Imports" }, { "package": "haven", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "readxl", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "labelled", "role": "Imports" }, { "package": "R6", "role": "Imports" }, { "package": "writexl", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "withr", "role": "Imports" }, { "package": "powerjoin", "role": "Imports" }, { "package": "digest", "role": "Imports" }, { "package": "openxlsx2", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "gt", "role": "Suggests" }, { "package": "pillar", "role": "Suggests" }, { "package": "gtExtras", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "htmltools", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "markdown", "role": "Suggests" }, { "package": "here", "role": "Suggests" }, { "package": "spelling", "role": "Suggests" }, { "package": "qs2", "role": "Suggests" }, { "package": "vctrs", "role": "Suggests" } ], "_owner": "codeberg-urswilke", "_selfowned": true, "_usedby": 1, "_updates": [ { "week": "2025-39", "n": 5 }, { "week": "2026-08", "n": 13 }, { "week": "2026-13", "n": 3 }, { "week": "2026-15", "n": 2 }, { "week": "2026-16", "n": 2 } ], "_tags": [ { "name": "1.0.0", "date": "2026-04-16" } ], "_userbio": { "uuid": 13970666, "type": "user", "name": "urswilke", "description": "https://gitlab.com/urswilke\r\n\r\nhttps://urssblogg.netlify.app/" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/datadaptor" }, "_devurl": "https://codeberg.org/urswilke/datadaptor", "_pkgdown": "https://urswilke.codeberg.page/datadaptor/", "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/datadaptor.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_cranurl": false, "_exports": [ "%>%", "apply_command", "create_mapping", "create_mapping_workbook", "curlychop", "diff_data", "format_sheet_data", "gen_data_table", "gen_label_table", "gen_var_table", "get_mapping_options", "is_true_vec", "Mapping", "read_data_", "safer_env", "set_na_to_filter", "use_known_args" ], "_datasets": [ { "name": "command_block_classes", "title": "'command_block' overview", "object": "command_block_classes", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "keyword", "command_block", "sheet" ], "rows": 28, "table": true, "tojson": true }, { "name": "fruit_survey", "title": "Toy data of a fictional survey about fruits", "object": "fruit_survey", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "id", "q1", "q2_1", "q2_2", "q2_3", "q2_97", "q3_1", "q3_2", "q3_3", "q3_97", "q4", "q5" ], "rows": 100, "table": true, "tojson": false }, { "name": "mtcars_labelled", "title": "Labelled mtcars version", "object": "mtcars_labelled", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "id", "model", "mpg", "cyl", "disp", "hp", "drat", "wt", "qsec", "vs", "am", "gear", "carb" ], "rows": 32, "table": true, "tojson": false } ], "_help": [ { "page": "apply_command", "title": "Apply a command block to the data", "topics": [ "apply_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" ] }, { "page": "command_block_classes", "title": "'command_block' overview", "topics": [ "command_block_classes" ] }, { "page": "create_mapping", "title": "Create an Excel mapping file based on a labelled dataframe", "topics": [ "create_mapping" ] }, { "page": "create_mapping_workbook", "title": "Create a mapping openxlsx2 workbook object", "topics": [ "create_mapping_workbook" ] }, { "page": "curlychop", "title": "Multiply repetitive parts of command blocks using curly braces", "topics": [ "curlychop" ] }, { "page": "diff_data", "title": "Diff to labelled data frames", "topics": [ "diff_data" ] }, { "page": "format_sheet_data", "title": "Format the dataframe returned by reading an excel sheet with 'openxlsx2::wb_read()'", "topics": [ "format_sheet_data" ] }, { "page": "fruit_survey", "title": "Toy data of a fictional survey about fruits", "topics": [ "fruit_survey" ] }, { "page": "gen_data_table", "title": "Generate data counts table", "topics": [ "gen_data_table" ] }, { "page": "get_mapping_options", "title": "Mapping parameters", "topics": [ "get_mapping_options" ] }, { "page": "label_tables", "title": "Generate tables with the variables' labels", "topics": [ "gen_label_table", "gen_var_table", "label_tables" ] }, { "page": "Mapping", "title": "Mapping class", "topics": [ "Mapping" ] }, { "page": "mtcars_labelled", "title": "Labelled mtcars version", "topics": [ "mtcars_labelled" ] }, { "page": "read_data_", "title": "Ingest data from data.frame or file path", "topics": [ "read_data_" ] }, { "page": "safer_env", "title": "Execution environments", "topics": [ "safer_env" ] }, { "page": "use_known_args", "title": "Apply function on the subset of arguments it knows", "topics": [ "use_known_args" ] } ], "_readme": "https://codeberg.org/urswilke/datadaptor/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "cellranger", "cli", "clipr", "cpp11", "crayon", "digest", "dplyr", "forcats", "fs", "generics", "glue", "haven", "hms", "labelled", "lifecycle", "magrittr", "openxlsx2", "pillar", "pkgconfig", "powerjoin", "prettyunits", "progress", "purrr", "R6", "Rcpp", "readr", "readxl", "rematch", "rlang", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "tzdb", "utf8", "vctrs", "vroom", "withr", "writexl" ], "_vignettes": [ { "source": "debugging.Rmd", "filename": "debugging.html", "title": "debugging", "engine": "knitr::rmarkdown", "headings": [ "Debugging" ], "created": "2021-02-06 12:12:13", "modified": "2024-12-29 17:27:43", "commits": 8 }, { "source": "command_blocks.Rmd", "filename": "command_blocks.html", "title": "Documentation of the Excel mapping command blocks", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2022-01-14 12:49:12", "modified": "2025-02-17 14:14:35", "commits": 49 }, { "source": "included_data.Rmd", "filename": "included_data.html", "title": "Included data sets and files in the package", "engine": "knitr::rmarkdown", "headings": [ "Included labelled data", "Mapping file" ], "created": "2020-12-06 23:57:00", "modified": "2025-01-07 12:17:03", "commits": 6 }, { "source": "survey_data_tabulation.Rmd", "filename": "survey_data_tabulation.html", "title": "Introduction to survey data tabulation in R", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2022-08-10 12:03:46", "modified": "2024-12-29 17:27:43", "commits": 5 }, { "source": "translating_command_blocks_to_R.Rmd", "filename": "translating_command_blocks_to_R.html", "title": "Translating the Excel mapping commands to R", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2022-08-10 12:03:46", "modified": "2024-12-29 17:27:43", "commits": 5 } ], "_score": 4.574031267727719, "_indexed": true, "_nocasepkg": "datadaptor", "_universes": [ "urswilke", "codeberg-urswilke" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.0", "date": "2026-05-16T09:01:36.000Z", "distro": "noble", "commit": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "fileid": "29b13a517f2133d7d0ab5c4e7dbc6ef110c5f85615142b2401a37bfbd41c25a6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/urswilke/actions/runs/25957835526" }, { "r": "4.6.0", "os": "linux", "version": "1.0.0", "date": "2026-05-16T09:01:31.000Z", "distro": "noble", "commit": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "fileid": "308d6f06c61065517dd594421c7bdca42bc2d248d9ca2c73e2b01aae7587dfbf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/urswilke/actions/runs/25957835526" }, { "r": "4.5.3", "os": "mac", "version": "1.0.0", "date": "2026-05-16T09:00:33.000Z", "commit": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "fileid": "49c9d87569a89fe299faff2a7489f959d97740688c8e5022067d9aa6e0cade4e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/urswilke/actions/runs/25957835526" }, { "r": "4.6.0", "os": "mac", "version": "1.0.0", "date": "2026-05-16T09:00:39.000Z", "commit": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "fileid": "2871c3801ab63891764bb49c51cd2fb02de835f8f22373c2be06a772dc5997b1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/urswilke/actions/runs/25957835526" }, { "r": "4.7.0", "os": "win", "version": "1.0.0", "date": "2026-05-16T09:01:09.000Z", "commit": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "fileid": "a910eb3551f4af2c75a7457b6f9f82dbebef6e593bd8edfd8389e64bc625cd94", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/urswilke/actions/runs/25957835526" }, { "r": "4.5.3", "os": "win", "version": "1.0.0", "date": "2026-05-16T09:00:22.000Z", "commit": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "fileid": "b0a2c00a02a61b40229ac878d499374565587205e9eacc09bbf908c4bb528d76", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/urswilke/actions/runs/25957835526" }, { "r": "4.6.0", "os": "win", "version": "1.0.0", "date": "2026-05-16T09:00:12.000Z", "commit": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "fileid": "ca045dcf2d0508bd0215bc570e99d7a3b880ec973b916e3ffd7cae6381116e11", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/urswilke/actions/runs/25957835526" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.0", "date": "2026-06-02T18:09:26.000Z", "commit": "e2bbf4f8b2b97fc105ba53c9ed250c1acd629216", "fileid": "9aca0b5bd6f701b2419127b7a92a9a6e54045947f988ed0951b68a697597be9c", "status": "success", "buildurl": "https://github.com/r-universe/urswilke/actions/runs/25957835526" } ] }