inst/audit/check_integrity.md

In LearningToTalk/L2TDatabase: Helper Functions for the Learning-To-Talk 'MySQL' Database

Data Integrity Check

Tristan Mahr 2017-02-01

In Spring 2016, we had our data-entry team re-enter test scores gathered in our studies, so that we could find data-entry discrepancies. This script compares the original to the re-entered scores.

Studies under consideration

Data from the following studies are checked:

#> [1] "TimePoint1"       "TimePoint2"       "TimePoint3"      
#> [4] "CochlearV1"       "CochlearV2"       "CochlearMatching"
#> [7] "LateTalker"       "MaternalEd"       "Dialect"

Participant pool comparison

Do the same participants contribute scores in each set?

Participants in original score-set ("ParticipantInfo") not in the re-entered score-set ("DIRT"):

#> # A tibble: 3 × 4
#>        Study ParticipantID  DIRT ParticipantInfo
#>        <chr>         <chr> <lgl>           <lgl>
#> 1 CochlearV2          312E    NA            TRUE
#> 2 LateTalker          203T    NA            TRUE
#> 3 LateTalker          206T    NA            TRUE

Participants in re-entered score-set ("DIRT") who visited the lab but are not in the original score-set ("ParticipantInfo").

#> # A tibble: 0 × 4
#> # ... with 4 variables: Study <chr>, ParticipantID <chr>, DIRT <lgl>,
#> #   ParticipantInfo <lgl>

Value Comparison

We now compare the scores in each score-set. This check is only being performed on participants in both score-sets.

Summary

This table lists all the fields that were checked and whether any discrepancies were found in that field.

| Study | Variable | Passing | | |:-----------------|:-----------------------------------------|:--------|----------------------| | CochlearMatching | BRIEFP_Date | TRUE | :white_check_mark: | | CochlearMatching | CTOPPMemory_Date | TRUE | :white_check_mark: | | CochlearMatching | CTOPPMemory_Raw | TRUE | :white_check_mark: | | CochlearMatching | CTOPPMemory_Scaled | TRUE | :white_check_mark: | | CochlearMatching | EVT_Date | TRUE | :white_check_mark: | | CochlearMatching | EVT_Form | TRUE | :white_check_mark: | | CochlearMatching | EVT_GSV | TRUE | :white_check_mark: | | CochlearMatching | EVT_Raw | TRUE | :white_check_mark: | | CochlearMatching | EVT_Standard | TRUE | :white_check_mark: | | CochlearMatching | FruitStroop_Date | TRUE | :white_check_mark: | | CochlearMatching | FruitStroop_Score | TRUE | :white_check_mark: | | CochlearMatching | GFTA_Date | TRUE | :white_check_mark: | | CochlearMatching | PPVT_Date | TRUE | :white_check_mark: | | CochlearMatching | PPVT_Form | TRUE | :white_check_mark: | | CochlearMatching | PPVT_GSV | TRUE | :white_check_mark: | | CochlearMatching | PPVT_Raw | TRUE | :white_check_mark: | | CochlearMatching | PPVT_Standard | TRUE | :white_check_mark: | | CochlearMatching | VerbalFluency_AgeEquivalent | TRUE | :white_check_mark: | | CochlearMatching | VerbalFluency_Date | TRUE | :white_check_mark: | | CochlearMatching | VerbalFluency_Score | TRUE | :white_check_mark: | | CochlearV1 | BRIEFP_Date | TRUE | :white_check_mark: | | CochlearV1 | CTOPPMemory_Date | TRUE | :white_check_mark: | | CochlearV1 | CTOPPMemory_Raw | TRUE | :white_check_mark: | | CochlearV1 | CTOPPMemory_Scaled | TRUE | :white_check_mark: | | CochlearV1 | EVT_Date | TRUE | :white_check_mark: | | CochlearV1 | EVT_Form | TRUE | :white_check_mark: | | CochlearV1 | EVT_GSV | TRUE | :white_check_mark: | | CochlearV1 | EVT_Raw | TRUE | :white_check_mark: | | CochlearV1 | EVT_Standard | TRUE | :white_check_mark: | | CochlearV1 | FruitStroop_Date | TRUE | :white_check_mark: | | CochlearV1 | FruitStroop_Score | TRUE | :white_check_mark: | | CochlearV1 | GFTA_Date | TRUE | :white_check_mark: | | CochlearV1 | PPVT_Date | TRUE | :white_check_mark: | | CochlearV1 | PPVT_Form | TRUE | :white_check_mark: | | CochlearV1 | PPVT_GSV | TRUE | :white_check_mark: | | CochlearV1 | PPVT_Raw | TRUE | :white_check_mark: | | CochlearV1 | PPVT_Standard | TRUE | :white_check_mark: | | CochlearV1 | VerbalFluency_AgeEquivalent | TRUE | :white_check_mark: | | CochlearV1 | VerbalFluency_Date | TRUE | :white_check_mark: | | CochlearV1 | VerbalFluency_Score | TRUE | :white_check_mark: | | CochlearV2 | BRIEFP_Date | TRUE | :white_check_mark: | | CochlearV2 | CTOPPMemory_Date | TRUE | :white_check_mark: | | CochlearV2 | CTOPPMemory_Raw | TRUE | :white_check_mark: | | CochlearV2 | CTOPPMemory_Scaled | TRUE | :white_check_mark: | | CochlearV2 | EVT_Date | TRUE | :white_check_mark: | | CochlearV2 | EVT_Form | TRUE | :white_check_mark: | | CochlearV2 | EVT_GSV | TRUE | :white_check_mark: | | CochlearV2 | EVT_Raw | TRUE | :white_check_mark: | | CochlearV2 | EVT_Standard | TRUE | :white_check_mark: | | CochlearV2 | FruitStroop_Date | TRUE | :white_check_mark: | | CochlearV2 | FruitStroop_Score | TRUE | :white_check_mark: | | CochlearV2 | GFTA_Date | TRUE | :white_check_mark: | | CochlearV2 | PPVT_Date | TRUE | :white_check_mark: | | CochlearV2 | PPVT_Form | TRUE | :white_check_mark: | | CochlearV2 | PPVT_GSV | TRUE | :white_check_mark: | | CochlearV2 | PPVT_Raw | TRUE | :white_check_mark: | | CochlearV2 | PPVT_Standard | TRUE | :white_check_mark: | | CochlearV2 | VerbalFluency_AgeEquivalent | TRUE | :white_check_mark: | | CochlearV2 | VerbalFluency_Date | TRUE | :white_check_mark: | | CochlearV2 | VerbalFluency_Score | TRUE | :white_check_mark: | | Dialect | BRIEFP_Date | TRUE | :white_check_mark: | | Dialect | EVT_Date | TRUE | :white_check_mark: | | Dialect | EVT_Form | TRUE | :white_check_mark: | | Dialect | EVT_GSV | TRUE | :white_check_mark: | | Dialect | EVT_Raw | TRUE | :white_check_mark: | | Dialect | EVT_Standard | TRUE | :white_check_mark: | | Dialect | FruitStroop_Date | TRUE | :white_check_mark: | | Dialect | FruitStroop_Score | TRUE | :white_check_mark: | | Dialect | GFTA_Date | TRUE | :white_check_mark: | | Dialect | PPVT_Date | TRUE | :white_check_mark: | | Dialect | PPVT_Form | TRUE | :white_check_mark: | | Dialect | PPVT_GSV | TRUE | :white_check_mark: | | Dialect | PPVT_Raw | TRUE | :white_check_mark: | | Dialect | PPVT_Standard | TRUE | :white_check_mark: | | Dialect | VerbalFluency_AgeEquivalent | TRUE | :white_check_mark: | | Dialect | VerbalFluency_Date | TRUE | :white_check_mark: | | Dialect | VerbalFluency_Score | TRUE | :white_check_mark: | | LateTalker | BRIEFP_Date | TRUE | :white_check_mark: | | LateTalker | CTOPPBlending_Date | TRUE | :white_check_mark: | | LateTalker | CTOPPBlending_Raw | TRUE | :white_check_mark: | | LateTalker | CTOPPBlending_Scaled | TRUE | :white_check_mark: | | LateTalker | CTOPPElision_Date | TRUE | :white_check_mark: | | LateTalker | CTOPPElision_Raw | TRUE | :white_check_mark: | | LateTalker | CTOPPElision_Scaled | TRUE | :white_check_mark: | | LateTalker | CTOPPMemory_Date | TRUE | :white_check_mark: | | LateTalker | CTOPPMemory_Raw | TRUE | :white_check_mark: | | LateTalker | CTOPPMemory_Scaled | TRUE | :white_check_mark: | | LateTalker | DELV_Date | TRUE | :white_check_mark: | | LateTalker | DELV_DegreeLanguageVar | TRUE | :white_check_mark: | | LateTalker | DELV_LanguageRisk | TRUE | :white_check_mark: | | LateTalker | DELV_LanguageRisk_DiagnosticErrorScore | TRUE | :white_check_mark: | | LateTalker | DELV_LanguageVar_ColumnAScore | TRUE | :white_check_mark: | | LateTalker | DELV_LanguageVar_ColumnBScore | TRUE | :white_check_mark: | | LateTalker | EVT_Date | TRUE | :white_check_mark: | | LateTalker | EVT_Form | TRUE | :white_check_mark: | | LateTalker | EVT_GSV | TRUE | :white_check_mark: | | LateTalker | EVT_Raw | TRUE | :white_check_mark: | | LateTalker | EVT_Standard | TRUE | :white_check_mark: | | LateTalker | FruitStroop_Date | TRUE | :white_check_mark: | | LateTalker | FruitStroop_Score | TRUE | :white_check_mark: | | LateTalker | GFTA_Date | TRUE | :white_check_mark: | | LateTalker | PPVT_Date | TRUE | :white_check_mark: | | LateTalker | PPVT_Form | TRUE | :white_check_mark: | | LateTalker | PPVT_GSV | TRUE | :white_check_mark: | | LateTalker | PPVT_Raw | TRUE | :white_check_mark: | | LateTalker | PPVT_Standard | TRUE | :white_check_mark: | | LateTalker | VerbalFluency_AgeEquivalent | TRUE | :white_check_mark: | | LateTalker | VerbalFluency_Date | TRUE | :white_check_mark: | | LateTalker | VerbalFluency_Score | TRUE | :white_check_mark: | | MaternalEd | BRIEFP_Date | TRUE | :white_check_mark: | | MaternalEd | CTOPPBlending_Date | TRUE | :white_check_mark: | | MaternalEd | CTOPPBlending_Raw | TRUE | :white_check_mark: | | MaternalEd | CTOPPBlending_Scaled | TRUE | :white_check_mark: | | MaternalEd | CTOPPElision_Date | TRUE | :white_check_mark: | | MaternalEd | CTOPPElision_Raw | TRUE | :white_check_mark: | | MaternalEd | CTOPPElision_Scaled | TRUE | :white_check_mark: | | MaternalEd | CTOPPMemory_Date | TRUE | :white_check_mark: | | MaternalEd | CTOPPMemory_Raw | TRUE | :white_check_mark: | | MaternalEd | CTOPPMemory_Scaled | TRUE | :white_check_mark: | | MaternalEd | DELV_Date | TRUE | :white_check_mark: | | MaternalEd | DELV_DegreeLanguageVar | TRUE | :white_check_mark: | | MaternalEd | DELV_LanguageRisk | TRUE | :white_check_mark: | | MaternalEd | DELV_LanguageRisk_DiagnosticErrorScore | TRUE | :white_check_mark: | | MaternalEd | DELV_LanguageVar_ColumnAScore | TRUE | :white_check_mark: | | MaternalEd | DELV_LanguageVar_ColumnBScore | TRUE | :white_check_mark: | | MaternalEd | EVT_Date | TRUE | :white_check_mark: | | MaternalEd | EVT_Form | TRUE | :white_check_mark: | | MaternalEd | EVT_GSV | TRUE | :white_check_mark: | | MaternalEd | EVT_Raw | TRUE | :white_check_mark: | | MaternalEd | EVT_Standard | TRUE | :white_check_mark: | | MaternalEd | FruitStroop_Date | TRUE | :white_check_mark: | | MaternalEd | FruitStroop_Score | TRUE | :white_check_mark: | | MaternalEd | GFTA_Date | TRUE | :white_check_mark: | | MaternalEd | PPVT_Date | TRUE | :white_check_mark: | | MaternalEd | PPVT_Form | TRUE | :white_check_mark: | | MaternalEd | PPVT_GSV | TRUE | :white_check_mark: | | MaternalEd | PPVT_Raw | TRUE | :white_check_mark: | | MaternalEd | PPVT_Standard | TRUE | :white_check_mark: | | MaternalEd | VerbalFluency_AgeEquivalent | TRUE | :white_check_mark: | | MaternalEd | VerbalFluency_Date | TRUE | :white_check_mark: | | MaternalEd | VerbalFluency_Score | TRUE | :white_check_mark: | | TimePoint1 | BRIEFP_Date | TRUE | :white_check_mark: | | TimePoint1 | EVT_Date | TRUE | :white_check_mark: | | TimePoint1 | EVT_Form | TRUE | :white_check_mark: | | TimePoint1 | EVT_GSV | TRUE | :white_check_mark: | | TimePoint1 | EVT_Raw | TRUE | :white_check_mark: | | TimePoint1 | EVT_Standard | TRUE | :white_check_mark: | | TimePoint1 | FruitStroop_Date | TRUE | :white_check_mark: | | TimePoint1 | FruitStroop_Score | TRUE | :white_check_mark: | | TimePoint1 | GFTA_Date | TRUE | :white_check_mark: | | TimePoint1 | PPVT_Date | TRUE | :white_check_mark: | | TimePoint1 | PPVT_Form | TRUE | :white_check_mark: | | TimePoint1 | PPVT_GSV | TRUE | :white_check_mark: | | TimePoint1 | PPVT_Raw | TRUE | :white_check_mark: | | TimePoint1 | PPVT_Standard | TRUE | :white_check_mark: | | TimePoint1 | VerbalFluency_AgeEquivalent | TRUE | :white_check_mark: | | TimePoint1 | VerbalFluency_Date | TRUE | :white_check_mark: | | TimePoint1 | VerbalFluency_Score | TRUE | :white_check_mark: | | TimePoint2 | CTOPPBlending_Date | TRUE | :white_check_mark: | | TimePoint2 | CTOPPBlending_Raw | TRUE | :white_check_mark: | | TimePoint2 | CTOPPBlending_Scaled | TRUE | :white_check_mark: | | TimePoint2 | CTOPPElision_Date | TRUE | :white_check_mark: | | TimePoint2 | CTOPPElision_Raw | TRUE | :white_check_mark: | | TimePoint2 | CTOPPElision_Scaled | TRUE | :white_check_mark: | | TimePoint2 | EVT_Date | TRUE | :white_check_mark: | | TimePoint2 | EVT_Form | TRUE | :white_check_mark: | | TimePoint2 | EVT_GSV | TRUE | :white_check_mark: | | TimePoint2 | EVT_Raw | TRUE | :white_check_mark: | | TimePoint2 | EVT_Standard | TRUE | :white_check_mark: | | TimePoint2 | FruitStroop_Date | TRUE | :white_check_mark: | | TimePoint2 | FruitStroop_Score | TRUE | :white_check_mark: | | TimePoint2 | KBIT_Date | TRUE | :white_check_mark: | | TimePoint2 | KBIT_Nonverbal_Raw | TRUE | :white_check_mark: | | TimePoint2 | KBIT_Nonverbal_Standard | TRUE | :white_check_mark: | | TimePoint2 | PPVT_Date | TRUE | :white_check_mark: | | TimePoint2 | PPVT_Form | TRUE | :white_check_mark: | | TimePoint2 | PPVT_GSV | TRUE | :white_check_mark: | | TimePoint2 | PPVT_Raw | TRUE | :white_check_mark: | | TimePoint2 | PPVT_Standard | TRUE | :white_check_mark: | | TimePoint2 | VerbalFluency_AgeEquivalent | TRUE | :white_check_mark: | | TimePoint2 | VerbalFluency_Date | TRUE | :white_check_mark: | | TimePoint2 | VerbalFluency_Score | TRUE | :white_check_mark: | | TimePoint3 | CTOPPBlending_Date | TRUE | :white_check_mark: | | TimePoint3 | CTOPPBlending_Raw | TRUE | :white_check_mark: | | TimePoint3 | CTOPPBlending_Scaled | TRUE | :white_check_mark: | | TimePoint3 | CTOPPElision_Date | TRUE | :white_check_mark: | | TimePoint3 | CTOPPElision_Raw | TRUE | :white_check_mark: | | TimePoint3 | CTOPPElision_Scaled | TRUE | :white_check_mark: | | TimePoint3 | CTOPPMemory_Date | TRUE | :white_check_mark: | | TimePoint3 | CTOPPMemory_Raw | TRUE | :white_check_mark: | | TimePoint3 | CTOPPMemory_Scaled | TRUE | :white_check_mark: | | TimePoint3 | DELV_Date | TRUE | :white_check_mark: | | TimePoint3 | DELV_DegreeLanguageVar | TRUE | :white_check_mark: | | TimePoint3 | DELV_LanguageRisk | TRUE | :white_check_mark: | | TimePoint3 | DELV_LanguageRisk_DiagnosticErrorScore | TRUE | :white_check_mark: | | TimePoint3 | DELV_LanguageVar_ColumnAScore | TRUE | :white_check_mark: | | TimePoint3 | DELV_LanguageVar_ColumnBScore | TRUE | :white_check_mark: | | TimePoint3 | EVT_Date | TRUE | :white_check_mark: | | TimePoint3 | EVT_Form | TRUE | :white_check_mark: | | TimePoint3 | EVT_GSV | TRUE | :white_check_mark: | | TimePoint3 | EVT_Raw | TRUE | :white_check_mark: | | TimePoint3 | EVT_Standard | TRUE | :white_check_mark: | | TimePoint3 | GFTA_Date | TRUE | :white_check_mark: | | TimePoint3 | KBIT_Date | TRUE | :white_check_mark: | | TimePoint3 | KBIT_Nonverbal_Raw | TRUE | :white_check_mark: | | TimePoint3 | KBIT_Nonverbal_Standard | TRUE | :white_check_mark: | | TimePoint3 | PPVT_Date | TRUE | :white_check_mark: | | TimePoint3 | PPVT_Form | TRUE | :white_check_mark: | | TimePoint3 | PPVT_GSV | TRUE | :white_check_mark: | | TimePoint3 | PPVT_Raw | TRUE | :white_check_mark: | | TimePoint3 | PPVT_Standard | TRUE | :white_check_mark: | | TimePoint3 | VerbalFluency_AgeEquivalent | TRUE | :white_check_mark: | | TimePoint3 | VerbalFluency_Date | TRUE | :white_check_mark: | | TimePoint3 | VerbalFluency_Score | TRUE | :white_check_mark: |

Details

These are all the mismatching values.

#> named list()

Unchecked fields

The following columns in DIRT were not checked because there is not a matching column in the participant info spreadsheets

| Study | Variable | | |:-----------------|:---------------------|------------------| | MaternalEd | MBCDI_Date | :grey_question: | | MaternalEd | CDI_Extension_Date | :grey_question: | | TimePoint1 | MBCDI_Date | :grey_question: | | TimePoint1 | CDI_Extension_Date | :grey_question: | | LateTalker | MBCDI_Date | :grey_question: | | LateTalker | CDI_Extension_Date | :grey_question: | | CochlearV1 | CDI_Extension_Date | :grey_question: | | CochlearV1 | MBCDI_Date | :grey_question: | | CochlearV1 | CDI W&G | :grey_question: | | CochlearV2 | MBCDI_Date | :grey_question: | | CochlearV2 | CDI_Extension_Date | :grey_question: | | CochlearMatching | CDI_Extension_Date | :grey_question: | | CochlearMatching | MBCDI_Date | :grey_question: |

LearningToTalk/L2TDatabase documentation built on June 24, 2020, 3:45 a.m.