Package: eatGADS 1.2.0.9000

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.2.0.9000.tar.gz
eatGADS_1.2.0.9000.zip(r-4.7)eatGADS_1.2.0.9000.zip(r-4.6)eatGADS_1.2.0.9000.zip(r-4.5)
eatGADS_1.2.0.9000.tgz(r-4.6-any)eatGADS_1.2.0.9000.tgz(r-4.5-any)
eatGADS_1.2.0.9000.tar.gz(r-4.7-any)eatGADS_1.2.0.9000.tar.gz(r-4.6-any)
eatGADS_1.2.0.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
eatGADS/json (API)

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

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

Pkgdown/docs site:https://beckerbenj.github.io

Datasets:
  • pisa - PISA Plus Example Data
  • program_limits - Program specific limits to dataset components

On CRAN:

Conda:

7.62 score 2 stars 1 packages 50 scripts 658 downloads 96 exports 40 dependencies

Last updated from:db54e0587b. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK161
source / vignettesOK233
linux-release-x86_64OK168
macos-release-arm64OK117
macos-oldrel-arm64OK119
windows-develOK150
windows-releaseOK116
windows-oldrelOK148
wasm-releaseOK117

Exports:applyChangeMetaapplyLookupapplyLookup_expandVarapplyNumCheckassimilateValLabelsautoRecodecalculateScalechangeMissingschangeSPSSformatchangeValLabelschangeVarLabelschangeVarNamescheck4SPSScheck4StatacheckEmptyValLabelscheckFormatcheckMissingscheckMissingsByValuescheckMissingValLabelscheckTrendStructurecheckUniquenesscheckUniqueness2checkValLabelscheckValuecheckVarLabelscheckVarNamesclean_cachecloneVariablecollapseColumnscollapseMC_TextcollapseMultiMC_TextcompareGADScomposeVarconvertCasecreateGADScreateLookupcreateNumCheckcreateVariabledropDuplicateIDsdummies2charemptyTheseVariablesequalDataequalGADSequalMetaexport_tibbleextractDataextractData2extractDataOldextractGADSdatextractMetaextractVarsfac2dummiesfac2dummies_complexfillImputationsfixEncodinggetChangeMetagetGADSgetGADS_fastgetProgramLimitgetTrendGADSgetTrendGADSOldimport_convertLabelimport_DFimport_rawimport_raw2import_RDSimport_spssimport_stataimport_tibbleinsertVariableinspectDifferencesinspectMetaDifferenceslabelsGADSmatchValues_varLabelsmergeLabelsmiss2NAmultiChar2facnamesGADSorderLikerecode2NArecodeGADSrecodeNA2missingrecodeString2NArelocateVariableremove2NAcharremoveEmptyValLabelsremoveValLabelsremoveVarsreuseMetasplitGADSstringAsNumericsubImputationsupdateMetawrite_spsswrite_spss2write_stata

Dependencies:backportsbitbit64blobcachemcheckmateclicliprcpp11crayondata.tableDBIeatDBeatToolsfastmapforcatsgluehavenhmslifecyclemagrittrmemoisepillarpkgconfigplyrprettyunitsprogressR6RcppreadrrlangRSQLitestringitibbletidyselecttzdbutf8vctrsvroomwithr

import_spss: Importing data from 'SPSS'
Importing | GADSdat objects | Extracting data from GADSdat
Rendered fromimport_spss.Rmdusingknitr::rmarkdown

Last update: 2024-09-27
Started: 2020-08-11

createGADS: Creating a relational data base
Importing data | Splitting and Reshaping | Handling meta data | Preparing and Creating the data base
Rendered fromcreateGADS.Rmdusingknitr::rmarkdown

Last update: 2024-07-12
Started: 2020-07-15

getGADS: Using a relational eatGADS data base
Why? | Inspecting the data base | Extract data from data base | Extract data from GADSdat | Selecting different hierarchy levels | Trend data bases
Rendered fromgetGADS.Rmdusingknitr::rmarkdown

Last update: 2024-07-12
Started: 2020-07-22

Comprehensive Data Cleaning Guide
Data structure | Meta data structure | Modifying meta data | Changing variable names | Changing variable labels | Changing SPSS format | Changing value labels | Removing value labels | Changing missing tags | Checking and adjusting missing tags and value labels | Reusing meta data | Adding and removing variables | Selecting or removing variables | Cloning a variable | Adding variables | Recoding | Removing all values from a variable | Manual recoding | Setting values to NA | Automatically recoding a character variable to a labeled numeric variable | Automatically recoding a variable with a template | Variable sorting | Relocating a specific variable | Ordering all variables | Changing meta data (and data) via an Excel sheet | Variable level | Value level
Rendered fromdata_cleaning.Rmdusingknitr::rmarkdown

Last update: 2024-07-12
Started: 2023-04-21

Handling meta data
Setup | Importing data into the GADSdat format | Importing from SPSS | Importing from Excel etc. | GADSdat class | Saving GADSdat objects | Using GADSdat objects in R | Modifying GADSdat objects | Writing SPSS files
Rendered fromimport_raw.Rmdusingknitr::rmarkdown

Last update: 2024-07-12
Started: 2019-10-10

Recoding a forced choice item with a text field
Preparing the data set | Creating and editing a lookup table | Apply lookup to GADSdat | Integrate character and numeric variable | Remove variables from GADSdat | Missing value codes
Rendered fromrecoding_forcedChoice.rmdusingknitr::rmarkdown

Last update: 2024-07-12
Started: 2020-09-08

Recoding a multiple choice item with a text field
Preparing the data set | Creating and editing a lookup table | Apply lookup to GADSdat | Match values to variable labels | Integrate character and numeric variables | Trim down variables | Multiple character variables to labeled integers | Clean data set
Rendered fromrecoding_multipleChoice.rmdusingknitr::rmarkdown

Last update: 2024-07-12
Started: 2020-09-14

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 variable labels.changeVarLabels
Change Variable Names.changeVarNames
Check 'SPSS' Compliance of Meta Datacheck4SPSS
Check a 'GADSdat' for compatibility with 'Stata'.check4Stata
Check Value LabelscheckEmptyValLabels checkMissingValLabels
Check and Adjust SPSS FormatcheckFormat
Check a 'GADSdat' for large labeled whole-number values.checkIntOverflow
Check a 'GADSdat' for labeled fractional values.checkLabeledFractionals
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 Lengths of Labels.checkValLabels checkVarLabels
Check for a specific valuecheckValue
Check names for 'SQLite' column name conventions and length limits.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
Drop duplicate IDs in a 'GADSdat'.dropDuplicateIDs
Transform dummy variables to character variables.dummies2char
Set variables to 'NA'.emptyTheseVariables
Test if two 'GADSdat' objects are (nearly) equalequalData equalGADS equalMeta
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 program specific limitsgetProgramLimit
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
Program specific limits to dataset componentsprogram_limits
Recode values to 'NA'.recode2NA
Recode variables.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 and missing tags.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