Package: exceldata 0.1.1.3
Lisa Avery
exceldata: Streamline Data Import, Cleaning and Recoding from 'Excel'
A small group of functions to read in a data dictionary and the corresponding data table from 'Excel' and to automate the cleaning, re-coding and creation of simple calculated variables. This package was designed to be a companion to the macro-enabled 'Excel' template available on the GitHub site, but works with any similarly-formatted 'Excel' data.
Authors:
exceldata_0.1.1.3.tar.gz
exceldata_0.1.1.3.tar.gz(r-4.7-any)exceldata_0.1.1.3.tar.gz(r-4.6-any)
exceldata_0.1.1.3.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
exceldata/json (API)
| # Install 'exceldata' in R: |
| install.packages('exceldata', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.
Last updated from:7f5ba972e1. Checks:4 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 155 | ||
| source / vignettes | OK | 176 | ||
| linux-release-x86_64 | OK | 135 | ||
| wasm-release | OK | 110 |
Exports:addFactorVariablescheckDatacreateCalculatedimportExcelDataplotVariablesreadDataDictreadExcelData
Dependencies:cellrangerclicpp11crayondplyrfarvergenericsggplot2gluegtablehmsisobandlabelinglifecyclelubridatemagrittrpillarpkgconfigprettyunitsprogressR6RColorBrewerreadxlrematchrlangS7scalestibbletidyselecttimechangeutf8vctrsviridisLitewithr
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Create factor variables from data dictionary | addFactorVariables |
| Check the entered data against the data dictionary | checkData |
| Create calculated variables | createCalculated |
| Create categories from continuous data | createCategorisedVar |
| Create a combined variable from several dichotomous variables | createCombinedVar |
| Create survival variables (survival duration + status) | createRecodedVar |
| Create survival variables (survival duration + status) | createSurvVar |
| Return A data frame of codes | importCodes |
| Import Excel Data based on the specifications in a data dictionary | importExcelData |
| Return a list of univariate ggplots for each non-character variable | plotVariables |
| Read in the data dictionary | readDataDict |
| Read Excel Data | readExcelData |