Learn R Programming

eatGADS

Overview

eatGADS (educational assessment tools: Greatest Assumable Data Set) is the data management and data handling tool used by the Institute for Educational Quality Improvement in Germany (IQB). It has a strong focus on (automated) handling and processing of meta data.

eatGADS uses SQLite3 as a back end and is especially suited for importing data stored as SPSS files. eatDB is used for data base creation and use, haven is used for importing SPSS files.

Installation

# Install stable version from CRAN via
install.packages("eatGADS")

# Install development version from GitHub via
remotes::install_github("beckerbenj/eatGADS")

Usage

The functionality of eatGADS is extensively documented in its various vignettes. If you have questions regarding existing functionality or requests for new features, contact the package author.

# import SPSS data
sav_path <- system.file("extdata", "pisa.zsav", package = "eatGADS")
gads_obj <- import_spss(sav_path)

# see names of variables in the data set
namesGADS(gads_obj)

# extract meta data for specific variables
extractMeta(gads_obj, vars = c("schtype", "idschool"))

# extract data for data analysis while applying missing tags and value labels
dat1 <- extractData2(gads_obj)

Copy Link

Version

Install

install.packages('eatGADS')

Monthly Downloads

436

Version

1.1.1

License

GPL (>= 2)

Issues

29

Pull Requests

0

Stars

1

Forks

1

Maintainer

Benjamin Becker

Last Published

October 9th, 2024

Functions in eatGADS (1.1.1)

calculateScale

Calculate a scale.
cbind.GADSdat

Bind two GADSdat objects into a single GADSdat object by columns.
changeVarLabels

Change the variable label.
assimilateValLabels

Assimilate value labels.
changeValLabels

Change value labels.
autoRecode

Auto recode a variable in a GADSdat.
checkTrendStructure

Checks compatibility of two eatGADS data bases.
checkMissings

Check and Adjust Missing Tags
checkValue

Check for a specific value
changeSPSSformat

Change SPSS format.
changeMissings

Change missing code.
checkUniqueness

Check uniqueness of a variable.
checkUniqueness2

Check uniqueness of a variable.
applyLookup_expandVar

Recode via lookup table into multiple variables.
applyNumCheck

Apply recodes according to a numerical check data.frame.
applyLookup

Recode via lookup table.
applyChangeMeta

Apply Meta Data Changes.
collapseColumns

Collapse two columns of a lookup table.
checkVarNames

Check names for SQLite column name conventions.
createGADS

Create an eatGADS data base.
changeVarNames

Change Variable Names.
collapseMC_Text

Recode a multiple choice variable according to a character variable.
checkEmptyValLabels

Check Value Labels
checkFormat

Check and Adjust SPSS Format
emptyTheseVariables

Set variables to NA.
dummies2char

Transform dummy variables to character variables.
createLookup

Extract values for recoding.
eatGADS-package

eatGADS: Data management of hierarchical SPSS files via R and SQLite
check4SPSS

Check SPSS Compliance of Meta Data
equalGADS

Test if two GADSdat objects are (nearly) equal
composeVar

Create a composite variable.
convertCase

Modify upper and lower case for strings.
merge.GADSdat

Merge two GADSdat objects into a single GADSdat object.
export_tibble

Transform a GADSdat to a tibble
extractData

Extract Data
recode2NA

Recode values to NA.
matchValues_varLabels

Match regular expressions and variable names.
fixEncoding

Remove special characters.
getChangeMeta

Extract table for Meta Data Changes.
extractData2

Extract Data 2
recodeGADS

Recode a variable.
clean_cache

Clean temporary cache.
extractDataOld

Extract Data while merging linking errors.
import_raw2

Import R data frame with a explicit meta data sheet
removeEmptyValLabels

Remove unused value labels and missing tags.
extractGADSdat

Extract single GADSdat from all_GADSdat
removeValLabels

Remove value labels.
getGADS

Get data from GADS data base.
getTrendGADSOld

Get data for trend reports.
getTrendGADS

Get data for trend reports.
extractMeta

Get Meta Data
reuseMeta

Use meta data for variables from another GADSdat.
getGADS_fast

Get data from GADS data base fast from server directory.
splitGADS

Split GADSdat into hierarchy levels.
cloneVariable

Clone a variable.
import_spss

Import SPSS data
createNumCheck

Create data.frame for specification of numerical plausibility checks.
createVariable

Create a variable.
fillImputations

Fill imputed values.
import_convertLabel

Import an object imported via convertLabel
fac2dummies_complex

Transform a complex factor variable to dummy variables.
import_stata

Import Stata data
inspectMetaDifferences

Inspect meta data differences in a variable.
labelsGADS

Labels from relational eatGADS data base.
import_tibble

Import tibble
recodeNA2missing

Recode NAs to Missing.
orderLike

Order the variables in a GADSdat.
pisa

PISA Plus Example Data
recodeString2NA

Recode a string to NA.
miss2NA

Recode Missings to NA
multiChar2fac

Transform one or multiple character variables to factor.
mergeLabels

Prepare data and metadata
import_raw

Import R data frame with explicit meta data sheets
collapseMultiMC_Text

Recode multiple choice variable with multiple variables.
namesGADS

Variables names of a GADS.
compareGADS

Compare two GADS.
write_spss2

Write a GADSdat object to txt and SPSS syntax
stringAsNumeric

Transform string to numeric.
subImputations

Substitute imputed values.
extractVars

Extract or remove variables from a GADSdat.
fac2dummies

Transform a factor variable to dummy variables.
import_DF

Import R data.frame
import_RDS

Import RDS file
inspectDifferences

Inspect differences in a variable.
insertVariable

Reorder a single variable in a GADSdat.
relocateVariable

Reorder a single variable in a GADSdat.
updateMeta

Update meta data.
remove2NAchar

Shorten multiple text variables while giving NA codes.
write_spss

Write a GADSdat object to a file