Package: eatGADS 1.1.1

Benjamin Becker

eatGADS: Data Management of Large Hierarchical Data

Import 'SPSS' data, handle and change 'SPSS' meta data, store and access large hierarchical data in 'SQLite' data bases.

Authors:Benjamin Becker [aut, cre], Karoline Sachse [ctb], Johanna Busse [ctb]

eatGADS_1.1.1.tar.gz
eatGADS_1.1.1.tar.gz(r-4.5-noble)eatGADS_1.1.1.tar.gz(r-4.4-noble)
eatGADS_1.1.1.tgz(r-4.4-emscripten)eatGADS_1.1.1.tgz(r-4.3-emscripten)
eatGADS.pdf |eatGADS.html
eatGADS/json (API)
NEWS

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

Peer review:

Bug tracker:https://github.com/beckerbenj/eatgads/issues

Pkgdown:https://beckerbenj.github.io

Datasets:
  • pisa - PISA Plus Example Data

4.02 score 1 packages 32 scripts 492 downloads 89 exports 42 dependencies

Last updated 2 months agofrom:337464eaf8. Checks:OK: 2. Indexed: no.

TargetResultDate
Doc / VignettesOKDec 09 2024
R-4.5-linuxOKDec 09 2024

Exports:applyChangeMetaapplyLookupapplyLookup_expandVarapplyNumCheckassimilateValLabelsautoRecodecalculateScalechangeMissingschangeSPSSformatchangeValLabelschangeVarLabelschangeVarNamescheck4SPSScheckEmptyValLabelscheckFormatcheckMissingscheckMissingsByValuescheckMissingValLabelscheckTrendStructurecheckUniquenesscheckUniqueness2checkValuecheckVarNamesclean_cachecloneVariablecollapseColumnscollapseMC_TextcollapseMultiMC_TextcompareGADScomposeVarconvertCasecreateGADScreateLookupcreateNumCheckcreateVariabledummies2charemptyTheseVariablesequalGADSexport_tibbleextractDataextractData2extractDataOldextractGADSdatextractMetaextractVarsfac2dummiesfac2dummies_complexfillImputationsfixEncodinggetChangeMetagetGADSgetGADS_fastgetTrendGADSgetTrendGADSOldimport_convertLabelimport_DFimport_rawimport_raw2import_RDSimport_spssimport_stataimport_tibbleinsertVariableinspectDifferencesinspectMetaDifferenceslabelsGADSmatchValues_varLabelsmergeLabelsmiss2NAmultiChar2facnamesGADSorderLikerecode2NArecodeGADSrecodeNA2missingrecodeString2NArelocateVariableremove2NAcharremoveEmptyValLabelsremoveValLabelsremoveVarsreuseMetasplitGADSstringAsNumericsubImputationsupdateMetawrite_spsswrite_spss2write_stata

Dependencies:backportsbitbit64blobcachemcheckmateclicliprcpp11crayondata.tableDBIeatDBeatToolsfansifastmapforcatsgluehavenhmslifecyclemagrittrmemoisepillarpkgconfigplogrplyrprettyunitsprogressR6RcppreadrrlangRSQLitestringitibbletidyselecttzdbutf8vctrsvroomwithr

createGADS: Creating a relational data base

Rendered fromcreateGADS.Rmdusingknitr::rmarkdownon Dec 09 2024.

Last update: 2024-10-09
Started: 2020-11-25

getGADS: Using a relational eatGADS data base

Rendered fromgetGADS.Rmdusingknitr::rmarkdownon Dec 09 2024.

Last update: 2024-10-09
Started: 2020-11-25

import_spss: Importing data from 'SPSS'

Rendered fromimport_spss.Rmdusingknitr::rmarkdownon Dec 09 2024.

Last update: 2024-10-09
Started: 2020-11-25

Comprehensive Data Cleaning Guide

Rendered fromdata_cleaning.Rmdusingknitr::rmarkdownon Dec 09 2024.

Last update: 2024-10-09
Started: 2023-08-25

Handling meta data

Rendered fromimport_raw.Rmdusingknitr::rmarkdownon Dec 09 2024.

Last update: 2024-10-09
Started: 2020-11-25

Recoding a forced choice item with a text field

Rendered fromrecoding_forcedChoice.rmdusingknitr::rmarkdownon Dec 09 2024.

Last update: 2024-10-09
Started: 2020-11-25

Recoding a multiple choice item with a text field

Rendered fromrecoding_multipleChoice.rmdusingknitr::rmarkdownon Dec 09 2024.

Last update: 2024-10-09
Started: 2020-11-25

Readme and manuals

Help Manual

Help pageTopics
Apply Meta Data Changes.applyChangeMeta applyChangeMeta.valChanges applyChangeMeta.varChanges
Recode via lookup table.applyLookup
Recode via lookup table into multiple variables.applyLookup_expandVar
Apply recodes according to a numerical check data.frame.applyNumCheck
Assimilate value labels.assimilateValLabels
Auto recode a variable in a 'GADSdat'.autoRecode
Calculate a scale.calculateScale
Bind two 'GADSdat' objects into a single 'GADSdat' object by columns.cbind.GADSdat
Change missing code.changeMissings
Change SPSS format.changeSPSSformat
Change value labels.changeValLabels
Change the variable label.changeVarLabels
Change Variable Names.changeVarNames
Check 'SPSS' Compliance of Meta Datacheck4SPSS
Check Value LabelscheckEmptyValLabels checkMissingValLabels
Check and Adjust SPSS FormatcheckFormat
Check and Adjust Missing TagscheckMissings checkMissingsByValues
Checks compatibility of two 'eatGADS' data bases.checkTrendStructure
Check uniqueness of a variable.checkUniqueness
Check uniqueness of a variable.checkUniqueness2
Check for a specific valuecheckValue
Check names for 'SQLite' column name conventions.checkVarNames
Clean temporary cache.clean_cache
Clone a variable.cloneVariable
Collapse two columns of a lookup table.collapseColumns
Recode a multiple choice variable according to a character variable.collapseMC_Text
Recode multiple choice variable with multiple variables.collapseMultiMC_Text
Compare two GADS.compareGADS
Create a composite variable.composeVar
Modify upper and lower case for strings.convertCase convertCase.GADSdat
Create an 'eatGADS' data base.createGADS
Extract values for recoding.createLookup
Create data.frame for specification of numerical plausibility checks.createNumCheck
Create a variable.createVariable
Transform dummy variables to character variables.dummies2char
Set variables to 'NA'.emptyTheseVariables
Test if two 'GADSdat' objects are (nearly) equalequalGADS
Transform a 'GADSdat' to a 'tibble'export_tibble
Extract DataextractData
Extract Data 2extractData2
Extract Data while merging linking errors.extractDataOld
Extract single 'GADSdat' from 'all_GADSdat'extractGADSdat
Get Meta DataextractMeta
Extract or remove variables from a 'GADSdat'.extractVars removeVars
Transform a factor variable to dummy variables.fac2dummies
Transform a complex factor variable to dummy variables.fac2dummies_complex
Fill imputed values.fillImputations
Remove special characters.fixEncoding
Extract table for Meta Data Changes.getChangeMeta
Get data from GADS data base.getGADS
Get data from GADS data base fast from server directory.getGADS_fast
Get data for trend reports.getTrendGADS
Get data for trend reports.getTrendGADSOld
Import an object imported via 'convertLabel'import_convertLabel
Import R 'data.frame'import_DF
Import R data frame with explicit meta data sheetsimport_raw
Import R data frame with a explicit meta data sheetimport_raw2
Import 'RDS' fileimport_RDS
Import SPSS dataimport_spss
Import 'Stata' dataimport_stata
Import 'tibble'import_tibble
Reorder a single variable in a 'GADSdat'.insertVariable
Inspect differences in a variable.inspectDifferences
Inspect meta data differences in a variable.inspectMetaDifferences
Labels from relational 'eatGADS' data base.labelsGADS
Match regular expressions and variable names.matchValues_varLabels
Merge two 'GADSdat' objects into a single 'GADSdat' object.merge.GADSdat
Prepare data and metadatamergeLabels
Recode Missings to 'NA'miss2NA
Transform one or multiple character variables to factor.multiChar2fac
Variables names of a GADS.namesGADS
Order the variables in a 'GADSdat'.orderLike
PISA Plus Example Datapisa
Recode values to 'NA'.recode2NA
Recode a variable.recodeGADS
Recode 'NAs' to Missing.recodeNA2missing
Recode a string to 'NA'.recodeString2NA
Reorder a single variable in a 'GADSdat'.relocateVariable
Shorten multiple text variables while giving NA codes.remove2NAchar
Remove unused value labels and missing tags.removeEmptyValLabels
Remove value labels.removeValLabels
Use meta data for variables from another 'GADSdat'.reuseMeta
Split 'GADSdat' into hierarchy levels.splitGADS
Transform string to numeric.stringAsNumeric
Substitute imputed values.subImputations
Update meta data.updateMeta
Write a 'GADSdat' object to a filewrite_spss write_stata
Write a 'GADSdat' object to 'txt' and 'SPSS' syntaxwrite_spss2