Modified

September 13, 2024

Background

We make use of the datadictionary package here.

This is not a perfect solution. Among other challenges, this package throws many warnings. But we will use it for the time being.

Note

This data dictionary workflow does not include the questions that were asked. Adding that, and more descriptive information, is a high priority.

Load data and generate dictionary

Note

This data dictionary workflow does not include the questions that were asked. Adding that, and more descriptive information, is a high priority.

Code 
scr_df <- readr::read_csv(paste0(here::here(), "/data/csv/screening/agg/PLAY-screening-datab-latest.csv"),
                          show_col_types = FALSE)

scr_dd <- datadictionary::create_dictionary(scr_df)

readr::write_csv(scr_dd, paste0(here::here(), "/data/csv/screening/dd/PLAY-screening-data-dictionary.csv"))

Here are the data this package provides:

Code 
scr_dd |>
  kableExtra::kable() |>
  kableExtra::kable_classic()
item label class summary value
Rows in dataset 914
Columns in dataset 68
session_id No label numeric mean 66731
median 68046
min 38196
max 75296
missing 0
session_name No label character unique responses 879
missing 0
session_date No label Date mean 2023-08-01
mode 2023-08-13
min 2019-06-09
max 2024-12-07
missing 0
session_release No label character unique responses 3
missing 0
participant_ID No label character unique responses 94
missing 0
participant_birthdate No label Date mean 2022-02-05
mode 2021-08-18
min 2017-06-08
max 2024-01-03
missing 0
participant_gender No label character unique responses 2
missing 0
participant_race No label character unique responses 11
missing 0
participant_ethnicity No label character unique responses 3
missing 0
participant_language No label character unique responses 13
missing 0
exclusion_reason No label character unique responses 15
missing 850
group_name No label character unique responses 2
missing 0
context_setting No label character unique responses 2
missing 6
context_country No label character unique responses 2
missing 47
context_state No label character unique responses 19
missing 6
vol_id No label numeric mean 1299
median 1376
min 899
max 1705
missing 0
participant_disability No label character unique responses 5
missing 752
pilot_pilot No label logical missing 914
submit_date No label POSIXct POSIXt mean 2023-06-09
mode 2024-02-09 2024-04-19
min 2019-10-08
max 2024-09-08
missing 83
site_id No label character unique responses 31
missing 83
play_id No label character unique responses 692
missing 205
child_age_mos No label numeric mean 18
median 18
min 9.24
max 42.6
missing 85
child_sex No label character unique responses 3
missing 85
child_bornonduedate No label character unique responses 3
missing 91
child_onterm No label character unique responses 3
missing 199
child_birthage No label numeric mean 5
median 3
min -20
max 367
missing 112
child_weight_pounds No label numeric mean 7
median 7
min 4
max 100
missing 95
child_weight_ounces No label numeric mean 7
median 7
min 0
max 143
missing 107
child_birth_complications No label character unique responses 3
missing 95
child_birth_complications_specify No label character unique responses 67
missing 848
child_hearing_disabilities No label character unique responses 3
missing 95
child_hearing_disabilities_specify No label character unique responses 2
missing 913
child_vision_disabilities No label character unique responses 3
missing 95
child_vision_disabilities_specify No label character unique responses 6
missing 909
child_major_illnesses_injuries No label character unique responses 3
missing 95
child_illnesses_injuries_specify No label character unique responses 30
missing 881
child_developmentaldelays No label character unique responses 3
missing 207
child_developmentaldelays_specify No label character unique responses 9
missing 906
child_sleep_time No label character unique responses 99
missing 96
child_wake_time No label character unique responses 114
missing 97
child_nap_hours No label character unique responses 39
missing 97
child_sleep_location No label character unique responses 6
missing 97
mom_bio No label character unique responses 4
missing 109
mom_childbirth_age No label numeric mean 33
median 33
min 20.22
max 121.22
missing 112
mom_race No label character unique responses 9
missing 102
mom_birth_country No label character unique responses 5
missing 102
mom_birth_country_specify No label character unique responses 39
missing 826
mom_education No label character unique responses 15
missing 103
mom_employment No label character unique responses 4
missing 103
mom_occupation No label character unique responses 486
missing 299
mom_jobs_number No label character unique responses 7
missing 297
mom_training No label character unique responses 3
missing 105
biodad_childbirth_age No label character unique responses 639
missing 83
biodad_race No label character unique responses 13
missing 83
language_spoken_mom No label character unique responses 6
missing 91
language_spoken_mom_comments No label character unique responses 17
missing 898
language_spoken_child No label character unique responses 6
missing 85
language_spoken_home_comments No label character unique responses 832
missing 83
language_spoken_child_comments No label character unique responses 14
missing 901
language_spoken_home No label character unique responses 7
missing 90
language_spoken_house_other No label character unique responses 15
missing 900
language_spoken_home_other No label character unique responses 2
missing 913
childcare_types No label character unique responses 14
missing 290
childcare_location No label character unique responses 26
missing 889
childcare_hours No label character unique responses 71
missing 481
childcare_number No label numeric mean 6
median 6
min 0
max 25
missing 484
childcare_age No label numeric mean 7
median 5
min 0
max 45
missing 594
childcare_language No label character unique responses 38
missing 480

Extracting questions

An alternative approach to generating the data dictionary starts with the questionnaire files themselves.