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.5-noble)exceldata_0.1.1.3.tar.gz(r-4.4-noble)
exceldata_0.1.1.3.tgz(r-4.4-emscripten)exceldata_0.1.1.3.tgz(r-4.3-emscripten)
exceldata.pdf |exceldata.html✨
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 1 years agofrom:7f5ba972e1. Checks:OK: 2. Indexed: yes.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Dec 15 2024 |
| R-4.5-linux | OK | Dec 15 2024 |
Exports:addFactorVariablescheckDatacreateCalculatedimportExcelDataplotVariablesreadDataDictreadExcelData
Dependencies:cellrangerclicolorspacecpp11crayondplyrfansifarvergenericsggplot2gluegtablehmsisobandlabelinglatticelifecyclelubridatemagrittrMASSMatrixmgcvmunsellnlmepillarpkgconfigprettyunitsprogressR6RColorBrewerreadxlrematchrlangscalestibbletidyselecttimechangeutf8vctrsviridisLitewithr
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 |