Load Libraries
library(tidyverse)
## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.3.6 ✔ purrr 0.3.4
## ✔ tibble 3.1.8 ✔ dplyr 1.0.9
## ✔ tidyr 1.2.0 ✔ stringr 1.4.1
## ✔ readr 2.1.2 ✔ forcats 0.5.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
Import Data
df <- read.csv(file="ARC_processed_data.csv", header=T)
Viewing Data
names(df)
## [1] "X"
## [2] "record_id"
## [3] "redcap_event_name"
## [4] "redcap_data_access_group"
## [5] "date"
## [6] "group"
## [7] "consent"
## [8] "consent_parent"
## [9] "information_and_consent_complete"
## [10] "age"
## [11] "gender"
## [12] "trans"
## [13] "sexual_orientation"
## [14] "ethnicity"
## [15] "relationship_status"
## [16] "country"
## [17] "uk_country"
## [18] "urban_rural"
## [19] "dwelling"
## [20] "dwelling_other"
## [21] "tenure"
## [22] "rooms"
## [23] "n_adults"
## [24] "n_under_18s"
## [25] "income"
## [26] "education"
## [27] "employment"
## [28] "health___1"
## [29] "health___2"
## [30] "health___3"
## [31] "health___4"
## [32] "health___5"
## [33] "health___6"
## [34] "health___7"
## [35] "health___8"
## [36] "health___9"
## [37] "health___10"
## [38] "health___11"
## [39] "medical_other"
## [40] "pregnant___1"
## [41] "pregnant___2"
## [42] "pregnant___3"
## [43] "smoking"
## [44] "alcohol"
## [45] "caring_responsibilities___1"
## [46] "caring_responsibilities___2"
## [47] "caring_responsibilities___3"
## [48] "pet___1"
## [49] "pet___2"
## [50] "pet___3"
## [51] "pet___4"
## [52] "pet___5"
## [53] "pet___6"
## [54] "support_parents_1"
## [55] "support_parents_2"
## [56] "support_parents_3"
## [57] "support_parents_4"
## [58] "support_friends_1"
## [59] "support_friends_2"
## [60] "support_friends_3"
## [61] "support_friends_4"
## [62] "support_employment_1"
## [63] "support_employment_2"
## [64] "support_employment_3"
## [65] "support_employment_4"
## [66] "support_employment_5"
## [67] "support_employment_6"
## [68] "covid_positive_1"
## [69] "covid_positive_why___1"
## [70] "covid_positive_why___2"
## [71] "covid_positive_why___3"
## [72] "covid_positive_why___4"
## [73] "covid_positive_why___5"
## [74] "covid_positive_why___6"
## [75] "covid_positive_why___7"
## [76] "covid_positive_why___8"
## [77] "covid_positive_why___9"
## [78] "covid_positive_why___10"
## [79] "covid_positive_why___11"
## [80] "covid_positive_why___12"
## [81] "covid_positive_why___13"
## [82] "covid_positive_why___14"
## [83] "covid_positive_why___15"
## [84] "covid_positive_other"
## [85] "covid_positive_groups"
## [86] "covid_positive_most"
## [87] "covid_negative"
## [88] "covid_negative_what___1"
## [89] "covid_negative_what___2"
## [90] "covid_negative_what___3"
## [91] "covid_negative_what___4"
## [92] "covid_negative_what___5"
## [93] "covid_negative_what___6"
## [94] "covid_negative_what___7"
## [95] "covid_negative_what___8"
## [96] "covid_negative_other"
## [97] "covid_negative_most"
## [98] "demographics_complete"
## [99] "monthly_survey_complete"
## [100] "mental_health___1"
## [101] "mental_health___2"
## [102] "mental_health___3"
## [103] "mental_health___4"
## [104] "mental_health___5"
## [105] "mental_health___6"
## [106] "mental_health___7"
## [107] "mental_health___8"
## [108] "mental_health___9"
## [109] "mental_health___10"
## [110] "mental_health___11"
## [111] "mental_health___12"
## [112] "mental_health___13"
## [113] "mental_health___14"
## [114] "mental_health___15"
## [115] "mental_health_other"
## [116] "mental_health_recovery"
## [117] "treatment1"
## [118] "treatment1_other"
## [119] "treatment1_format"
## [120] "treatment1_format_other"
## [121] "mental_health_undiagnosed"
## [122] "treatment_complete"
## [123] "big_5_1"
## [124] "big_5_2"
## [125] "big_5_3"
## [126] "big_5_4"
## [127] "big_5_5"
## [128] "big_5_6"
## [129] "big_5_7"
## [130] "big_5_8"
## [131] "big_5_9"
## [132] "big_5_10"
## [133] "big_5_11"
## [134] "big_5_12"
## [135] "big_5_13"
## [136] "big_5_14"
## [137] "big_5_15"
## [138] "university_1"
## [139] "university_offer"
## [140] "university_offer2"
## [141] "university_offer3"
## [142] "personality_complete"
## [143] "pswq_a_1"
## [144] "pswq_a_2"
## [145] "pswq_a_3"
## [146] "pswq_a_4"
## [147] "pswq_a_5"
## [148] "pswq_a_6"
## [149] "pswq_a_7"
## [150] "pswq_a_8"
## [151] "pswq_a_9"
## [152] "pswq_a_10"
## [153] "pswq_a_11"
## [154] "pswq_a_12"
## [155] "pswq_a_13"
## [156] "pswq_a_14"
## [157] "pswq_a_15"
## [158] "pswq_a_16"
## [159] "pswq_c_1"
## [160] "pswq_c_2"
## [161] "pswq_c_3"
## [162] "pswq_c_4"
## [163] "pswq_c_5"
## [164] "pswq_c_6"
## [165] "pswq_c_7"
## [166] "pswq_c_8"
## [167] "pswq_c_9"
## [168] "pswq_c_10"
## [169] "pswq_c_11"
## [170] "pswq_c_12"
## [171] "pswq_c_13"
## [172] "pswq_c_14"
## [173] "pswq_complete"
## [174] "iou_1"
## [175] "iou_2"
## [176] "iou_3"
## [177] "iou_4"
## [178] "iou_5"
## [179] "iou_6"
## [180] "iou_7"
## [181] "iou_8"
## [182] "iou_9"
## [183] "iou_10"
## [184] "iou_11"
## [185] "iou_12"
## [186] "iou_13"
## [187] "iou_14"
## [188] "iou_15"
## [189] "iou_16"
## [190] "iou_17"
## [191] "iou_18"
## [192] "iou_19"
## [193] "iou_20"
## [194] "iou_21"
## [195] "iou_22"
## [196] "iou_23"
## [197] "iou_24"
## [198] "iou_25"
## [199] "iou_26"
## [200] "iou_27"
## [201] "iou12_complete"
## [202] "mfq_26_1"
## [203] "mfq_26_2"
## [204] "mfq_26_3"
## [205] "mfq_26_4"
## [206] "mfq_26_5"
## [207] "mfq_26_6"
## [208] "mfq_26_7"
## [209] "mfq_26_8"
## [210] "mfq_26_9"
## [211] "mfq_26_10"
## [212] "mfq_26_11"
## [213] "mfq_26_12"
## [214] "mfq_26_13"
## [215] "mfq_26_14"
## [216] "mfq_26_15"
## [217] "mfq_26_16"
## [218] "mfq_26_17"
## [219] "mfq_26_18"
## [220] "mfq_26_19"
## [221] "mfq_26_20"
## [222] "mfq26_complete"
## [223] "rse_1"
## [224] "rse_2"
## [225] "rse_3"
## [226] "rse_4"
## [227] "rse_5"
## [228] "rse_6"
## [229] "rse_7"
## [230] "rse_8"
## [231] "rse_9"
## [232] "rse_10"
## [233] "rse10_complete"
## [234] "weekly_survey_complete"
## [235] "monthly_onethird_complete"
## [236] "school_1"
## [237] "school_2"
## [238] "homeschool_1"
## [239] "homeschool_2"
## [240] "homeschool_3"
## [241] "homeschool_4"
## [242] "school_support_1"
## [243] "school_support_2"
## [244] "school_support_3"
## [245] "school_support_4"
## [246] "school_support_5"
## [247] "school_stress"
## [248] "school_pos_neg_1"
## [249] "school_pos_neg_2"
## [250] "school_pos_neg_3"
## [251] "school_pos_neg_4"
## [252] "school_pos_neg_5"
## [253] "school_pos_neg_6"
## [254] "school_pos_neg_7"
## [255] "school_pos_neg_8"
## [256] "school_pos_neg_9"
## [257] "school_pos_neg_10"
## [258] "school_pos_neg_11"
## [259] "pas_covid_1"
## [260] "pas_covid_2"
## [261] "pas_covid_3"
## [262] "pas_covid_4"
## [263] "pas_covid_5"
## [264] "pas_covid_6"
## [265] "pas_covid_7"
## [266] "pas_covid_8"
## [267] "pas_covid_9"
## [268] "covid_complete"
## [269] "pss_1"
## [270] "pss_2"
## [271] "pss_3"
## [272] "pss_4"
## [273] "pss4_complete"
## [274] "phq_1"
## [275] "phq_2"
## [276] "phq_3"
## [277] "phq_4"
## [278] "phq_5"
## [279] "phq_6"
## [280] "phq_7"
## [281] "phq_8"
## [282] "phq_9"
## [283] "phq9_complete"
## [284] "gad_1"
## [285] "gad_2"
## [286] "gad_3"
## [287] "gad_4"
## [288] "gad_5"
## [289] "gad_6"
## [290] "gad_7"
## [291] "gad7_complete"
## [292] "mfq_state_1"
## [293] "mfq_state_2"
## [294] "mfq_state_3"
## [295] "mfq_state_4"
## [296] "mfq_state_5"
## [297] "mfq_state_6"
## [298] "mfq_state_7"
## [299] "mfq_state_8"
## [300] "mfqs11_complete"
## [301] "weeklymid_complete"
## [302] "monthly_twothird_complete"
## [303] "other_sleep"
## [304] "sleep_hours"
## [305] "other_isolation_adult_1"
## [306] "other_isolation_adult_2"
## [307] "other_isolation_adult_3"
## [308] "other_isolation_child_1"
## [309] "other_isolation_child_2"
## [310] "other_isolation_child_3"
## [311] "other_isolation_adult_4"
## [312] "other_isolation_child_4"
## [313] "other_support_1"
## [314] "other_support_2"
## [315] "other_support_3"
## [316] "other_support_4"
## [317] "other_support_5"
## [318] "other_support_6"
## [319] "other_smoking"
## [320] "other_alcohol"
## [321] "rmother_complete"
## [322] "edeq_1"
## [323] "edeq_2"
## [324] "edeq_3"
## [325] "edeq_4"
## [326] "edeq_5"
## [327] "edeq_6"
## [328] "edeq_7"
## [329] "edeq_8"
## [330] "edeq_9"
## [331] "edeq_10"
## [332] "edeq_11"
## [333] "edeq_12"
## [334] "edeq12_complete"
## [335] "media_tv"
## [336] "media_why_tv_socialise"
## [337] "media_why_tv_avoid"
## [338] "media_why_tv_work"
## [339] "media_why_tv_fun"
## [340] "media_why_tv_news"
## [341] "media_why_tv_nothing"
## [342] "media_playing"
## [343] "media_why_playing_social"
## [344] "media_why_playing_avoid"
## [345] "media_why_play_work"
## [346] "media_why_playing_fun"
## [347] "media_why_playing_news"
## [348] "media_why_playing_nothing"
## [349] "media_social_media"
## [350] "media_why_visit_social"
## [351] "media_why_visit_avoid"
## [352] "media_why_visit_work"
## [353] "media_why_visit_fun"
## [354] "media_why_visit_news"
## [355] "media_why_visit_nothing"
## [356] "media_messaging"
## [357] "media_why_message_social"
## [358] "media_why_message_avoid"
## [359] "media_why_message_work"
## [360] "media_why_message_fun"
## [361] "media_why_message_news"
## [362] "media_why_message_nothing"
## [363] "media_video"
## [364] "media_why_video_social"
## [365] "media_why_video_avoid"
## [366] "media_why_video_work"
## [367] "media_why_video_fun"
## [368] "media_why_video_news"
## [369] "media_why_video_nothing"
## [370] "media_playing_voice"
## [371] "media_why_voice_social"
## [372] "media_why_voice_avoid"
## [373] "media_why_voice_work"
## [374] "media_why_voice_fun"
## [375] "media_why_voice_news"
## [376] "media_why_voice_nothing"
## [377] "activity_exercise_inside"
## [378] "activity_exercise_outside"
## [379] "activity_exercise_outside2"
## [380] "technology_complete"
## [381] "brs_1"
## [382] "brs_2"
## [383] "brs_3"
## [384] "brs_4"
## [385] "brs_5"
## [386] "brs_6"
## [387] "brs_complete"
## [388] "swemws_1"
## [389] "swemws_2"
## [390] "swemws_3"
## [391] "swemws_4"
## [392] "swemws_5"
## [393] "swemws_6"
## [394] "swemws_7"
## [395] "swemws7_complete"
## [396] "oxford_arc_study_optional_task_complete"
## [397] "family_code"
## [398] "start_date"
## [399] "Weekday"
## [400] "weekStart"
## [401] "surveysran"
## [402] "surveyscompleted"
## [403] "remove"
## [404] "big5_O"
## [405] "big5_C"
## [406] "big5_E"
## [407] "big5_A"
## [408] "big5_N"
## [409] "pswq_a_total"
## [410] "pswq_c_total"
## [411] "iou_total"
## [412] "mfq_20_total"
## [413] "rse_total"
## [414] "pas_covid_total"
## [415] "pss_total"
## [416] "phq_total"
## [417] "gad_total"
## [418] "mfq_state_total"
## [419] "isolation4_child"
## [420] "isolation4_adult"
## [421] "edeq"
## [422] "brs"
## [423] "swemws"
head(df)
## X record_id redcap_event_name redcap_data_access_group date group
## 1 1 12 baseline NA 2020-04-29 parent
## 2 2 12 week2 NA 2020-05-06 parent
## 3 3 12 week3 NA 2020-05-13 parent
## 4 4 12 week4 NA 2020-05-20 parent
## 5 5 12 week5 NA 2020-05-27 parent
## 6 6 12 week6 NA 2020-06-03 parent
## consent consent_parent information_and_consent_complete age gender trans
## 1 1 NA 2 NA female no
## 2 NA NA NA NA female no
## 3 NA NA NA NA female no
## 4 NA NA NA NA female no
## 5 NA NA NA NA female no
## 6 NA NA NA NA female no
## sexual_orientation ethnicity
## 1 Heterosexual/Straight White - British, Irish, other
## 2 Heterosexual/Straight <NA>
## 3 Heterosexual/Straight <NA>
## 4 Heterosexual/Straight <NA>
## 5 Heterosexual/Straight <NA>
## 6 Heterosexual/Straight <NA>
## relationship_status country uk_country
## 1 In a relationship/married and cohabiting United Kingdom <NA>
## 2 <NA> United Kingdom <NA>
## 3 <NA> United Kingdom <NA>
## 4 <NA> United Kingdom <NA>
## 5 <NA> United Kingdom <NA>
## 6 <NA> United Kingdom <NA>
## urban_rural dwelling dwelling_other tenure rooms n_adults n_under_18s income
## 1 1 1 2 7 2 1 5
## 2 NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA
## education employment health___1 health___2 health___3 health___4 health___5
## 1 7 3 0 0 0 0 0
## 2 NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA
## health___6 health___7 health___8 health___9 health___10 health___11
## 1 0 0 0 0 1 0
## 2 NA NA NA NA NA NA
## 3 NA NA NA NA NA NA
## 4 NA NA NA NA NA NA
## 5 NA NA NA NA NA NA
## 6 NA NA NA NA NA NA
## medical_other
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## pregnant___1 pregnant___2 pregnant___3 smoking alcohol
## 1 1 0 0 1 0
## 2 NA NA NA NA NA
## 3 NA NA NA NA NA
## 4 NA NA NA NA NA
## 5 NA NA NA NA NA
## 6 NA NA NA NA NA
## caring_responsibilities___1 caring_responsibilities___2
## 1 0 0
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## caring_responsibilities___3 pet___1 pet___2 pet___3 pet___4 pet___5 pet___6
## 1 0 1 0 0 0 0 0
## 2 NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA
## support_parents_1 support_parents_2 support_parents_3 support_parents_4
## 1 NA NA NA NA
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## support_friends_1 support_friends_2 support_friends_3 support_friends_4
## 1 NA NA NA NA
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## support_employment_1 support_employment_2 support_employment_3
## 1 NA NA NA
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## support_employment_4 support_employment_5 support_employment_6
## 1 NA NA NA
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## covid_positive_1 covid_positive_why___1 covid_positive_why___2
## 1 NA 0 0
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## covid_positive_why___3 covid_positive_why___4 covid_positive_why___5
## 1 0 0 0
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## covid_positive_why___6 covid_positive_why___7 covid_positive_why___8
## 1 0 0 0
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## covid_positive_why___9 covid_positive_why___10 covid_positive_why___11
## 1 0 0 0
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## covid_positive_why___12 covid_positive_why___13 covid_positive_why___14
## 1 0 0 0
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## covid_positive_why___15
## 1 0
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## covid_positive_other
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## covid_positive_groups
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## covid_positive_most
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## covid_negative covid_negative_what___1 covid_negative_what___2
## 1 NA 0 0
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## covid_negative_what___3 covid_negative_what___4 covid_negative_what___5
## 1 0 0 0
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## covid_negative_what___6 covid_negative_what___7 covid_negative_what___8
## 1 0 0 0
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## covid_negative_other
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## covid_negative_most
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## demographics_complete monthly_survey_complete mental_health___1
## 1 2 NA 0
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## mental_health___2 mental_health___3 mental_health___4 mental_health___5
## 1 0 0 0 0
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## mental_health___6 mental_health___7 mental_health___8 mental_health___9
## 1 0 0 0 0
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## mental_health___10 mental_health___11 mental_health___12 mental_health___13
## 1 0 0 0 0
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## mental_health___14 mental_health___15
## 1 0 1
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## mental_health_other
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## mental_health_recovery
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## treatment1
## 1 1
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## treatment1_other
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## treatment1_format
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## treatment1_format_other
## 1 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 2 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 3 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 4 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 5 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## 6 data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you require ccess for your research questions
## mental_health_undiagnosed treatment_complete big_5_1 big_5_2 big_5_3 big_5_4
## 1 2 6 6 2 2
## 2 NA NA NA NA NA
## 3 NA NA NA NA NA
## 4 NA NA NA NA NA
## 5 NA NA NA NA NA
## 6 NA NA NA NA NA
## big_5_5 big_5_6 big_5_7 big_5_8 big_5_9 big_5_10 big_5_11 big_5_12 big_5_13
## 1 2 6 5 5 6 5 5 5 7
## 2 NA NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA NA
## big_5_14 big_5_15 university_1 university_offer university_offer2
## 1 3 6 NA NA NA
## 2 NA NA NA NA NA
## 3 NA NA NA NA NA
## 4 NA NA NA NA NA
## 5 NA NA NA NA NA
## 6 NA NA NA NA NA
## university_offer3 personality_complete pswq_a_1 pswq_a_2 pswq_a_3 pswq_a_4
## 1 NA 2 1 5 1 5
## 2 NA NA NA NA NA NA
## 3 NA NA NA NA NA NA
## 4 NA NA NA NA NA NA
## 5 NA NA NA NA NA NA
## 6 NA NA NA NA NA NA
## pswq_a_5 pswq_a_6 pswq_a_7 pswq_a_8 pswq_a_9 pswq_a_10 pswq_a_11 pswq_a_12
## 1 5 5 5 1 5 1 1 5
## 2 NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA
## pswq_a_13 pswq_a_14 pswq_a_15 pswq_a_16 pswq_c_1 pswq_c_2 pswq_c_3 pswq_c_4
## 1 5 5 4 5 NA NA NA NA
## 2 NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA
## pswq_c_5 pswq_c_6 pswq_c_7 pswq_c_8 pswq_c_9 pswq_c_10 pswq_c_11 pswq_c_12
## 1 NA NA NA NA NA NA NA NA
## 2 NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA
## pswq_c_13 pswq_c_14 pswq_complete iou_1 iou_2 iou_3 iou_4 iou_5 iou_6 iou_7
## 1 NA NA 2 4 3 5 2 3 3 3
## 2 NA NA NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA NA NA
## iou_8 iou_9 iou_10 iou_11 iou_12 iou_13 iou_14 iou_15 iou_16 iou_17 iou_18
## 1 4 3 5 3 2 1 2 3 5 3 3
## 2 NA NA NA NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA NA NA NA
## iou_19 iou_20 iou_21 iou_22 iou_23 iou_24 iou_25 iou_26 iou_27 iou12_complete
## 1 3 2 3 4 2 4 3 3 5 2
## 2 NA NA NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA NA NA
## mfq_26_1 mfq_26_2 mfq_26_3 mfq_26_4 mfq_26_5 mfq_26_6 mfq_26_7 mfq_26_8
## 1 4 3 2 3 4 5 3 5
## 2 NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA
## mfq_26_9 mfq_26_10 mfq_26_11 mfq_26_12 mfq_26_13 mfq_26_14 mfq_26_15
## 1 3 3 2 5 5 4 5
## 2 NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA
## mfq_26_16 mfq_26_17 mfq_26_18 mfq_26_19 mfq_26_20 mfq26_complete rse_1 rse_2
## 1 5 6 6 6 5 2 2 4
## 2 NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA
## rse_3 rse_4 rse_5 rse_6 rse_7 rse_8 rse_9 rse_10 rse10_complete
## 1 4 3 2 4 3 4 2 2 2
## 2 NA NA NA NA NA NA NA NA NA
## 3 NA NA NA NA NA NA NA NA NA
## 4 NA NA NA NA NA NA NA NA NA
## 5 NA NA NA NA NA NA NA NA NA
## 6 NA NA NA NA NA NA NA NA NA
## weekly_survey_complete monthly_onethird_complete school_1 school_2
## 1 2 2 NA NA
## 2 2 NA NA NA
## 3 2 NA NA NA
## 4 2 NA NA NA
## 5 2 NA NA NA
## 6 2 NA NA NA
## homeschool_1 homeschool_2 homeschool_3 homeschool_4 school_support_1
## 1 NA NA NA NA NA
## 2 NA NA NA NA NA
## 3 NA NA NA NA NA
## 4 NA NA NA NA NA
## 5 NA NA NA NA NA
## 6 NA NA NA NA NA
## school_support_2 school_support_3 school_support_4 school_support_5
## 1 NA NA NA NA
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## school_stress school_pos_neg_1 school_pos_neg_2 school_pos_neg_3
## 1 NA NA NA NA
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## school_pos_neg_4 school_pos_neg_5 school_pos_neg_6 school_pos_neg_7
## 1 NA NA NA NA
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## school_pos_neg_8 school_pos_neg_9 school_pos_neg_10 school_pos_neg_11
## 1 NA NA NA NA
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## pas_covid_1 pas_covid_2 pas_covid_3 pas_covid_4 pas_covid_5 pas_covid_6
## 1 4 2 2 2 5 3
## 2 5 3 4 2 4 2
## 3 5 3 4 3 4 2
## 4 4 3 4 2 4 2
## 5 4 3 4 3 4 2
## 6 4 3 4 2 4 2
## pas_covid_7 pas_covid_8 pas_covid_9 covid_complete pss_1 pss_2 pss_3 pss_4
## 1 3 4 4 2 3 4 3 5
## 2 2 2 4 2 2 4 4 2
## 3 2 2 4 2 3 4 5 1
## 4 2 2 4 2 4 2 2 3
## 5 2 2 4 2 3 3 3 2
## 6 2 2 4 2 1 4 4 2
## pss4_complete phq_1 phq_2 phq_3 phq_4 phq_5 phq_6 phq_7 phq_8 phq_9
## 1 2 2 1 1 2 1 1 2 1 1
## 2 2 1 1 1 2 1 1 1 1 1
## 3 2 1 1 1 1 1 1 1 1 1
## 4 2 3 2 2 2 1 1 4 1 1
## 5 2 2 2 2 2 1 1 2 1 1
## 6 2 1 1 2 2 1 1 2 1 1
## phq9_complete gad_1 gad_2 gad_3 gad_4 gad_5 gad_6 gad_7 gad7_complete
## 1 2 2 2 2 2 2 2 1 2
## 2 2 2 2 2 2 1 2 1 2
## 3 2 2 2 2 2 1 2 1 2
## 4 2 4 4 2 4 4 4 1 2
## 5 2 2 2 2 2 2 3 1 2
## 6 2 2 2 1 2 1 2 1 2
## mfq_state_1 mfq_state_2 mfq_state_3 mfq_state_4 mfq_state_5 mfq_state_6
## 1 4 2 4 4 3 4
## 2 5 5 5 5 4 5
## 3 6 4 4 5 5 5
## 4 3 2 2 3 3 3
## 5 4 3 3 4 3 3
## 6 5 3 3 5 5 5
## mfq_state_7 mfq_state_8 mfqs11_complete weeklymid_complete
## 1 3 5 2 NA
## 2 5 6 2 2
## 3 5 6 2 2
## 4 3 5 2 2
## 5 3 5 2 2
## 6 5 5 2 2
## monthly_twothird_complete other_sleep sleep_hours other_isolation_adult_1
## 1 NA 3 3 2
## 2 NA 4 3 NA
## 3 NA 4 3 NA
## 4 NA 2 3 NA
## 5 NA 3 3 NA
## 6 NA 2 2 NA
## other_isolation_adult_2 other_isolation_adult_3 other_isolation_child_1
## 1 2 2 NA
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## other_isolation_child_2 other_isolation_child_3 other_isolation_adult_4
## 1 NA NA 3
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## other_isolation_child_4 other_support_1 other_support_2 other_support_3
## 1 NA 3 4 1
## 2 NA 5 4 2
## 3 NA 3 3 4
## 4 NA 2 2 4
## 5 NA 2 2 3
## 6 NA 2 2 3
## other_support_4 other_support_5 other_support_6 other_smoking other_alcohol
## 1 2 3 2 0 0
## 2 3 3 3 0 0
## 3 4 4 3 0 0
## 4 4 4 2 0 0
## 5 2 3 2 0 0
## 6 3 3 2 0 0
## rmother_complete edeq_1 edeq_2 edeq_3 edeq_4 edeq_5 edeq_6 edeq_7 edeq_8
## 1 2 1 1 1 1 2 4 1 1
## 2 2 1 1 1 1 2 2 1 1
## 3 2 1 1 1 1 2 1 NA 1
## 4 2 2 1 1 1 2 1 1 1
## 5 2 1 1 1 1 2 1 1 1
## 6 2 1 1 1 1 2 1 1 1
## edeq_9 edeq_10 edeq_11 edeq_12 edeq12_complete media_tv
## 1 1 1 2 3 2 0.5
## 2 2 1 3 3 2 0.5
## 3 2 1 3 3 2 0.5
## 4 1 1 2 3 2 0.75
## 5 1 1 2 3 2 0.75
## 6 1 1 3 3 2 0.75
## media_why_tv_socialise media_why_tv_avoid media_why_tv_work media_why_tv_fun
## 1 NA NA 1 NA
## 2 4 1 1 4
## 3 4 1 1 1
## 4 4 1 1 4
## 5 4 1 1 4
## 6 4 1 1 4
## media_why_tv_news media_why_tv_nothing media_playing media_why_playing_social
## 1 NA NA 1.00 NA
## 2 1 1 0.00 NA
## 3 1 1 0.50 4
## 4 1 1 0.00 NA
## 5 1 1 0.25 NA
## 6 1 1 0.00 NA
## media_why_playing_avoid media_why_play_work media_why_playing_fun
## 1 NA NA NA
## 2 NA NA NA
## 3 1 1 4
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## media_why_playing_news media_why_playing_nothing media_social_media
## 1 NA NA 0.50
## 2 NA NA 0.25
## 3 1 1 0.00
## 4 NA NA 0.25
## 5 NA NA 0.00
## 6 NA NA 0.00
## media_why_visit_social media_why_visit_avoid media_why_visit_work
## 1 NA NA NA
## 2 3 1 1
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## media_why_visit_fun media_why_visit_news media_why_visit_nothing
## 1 NA NA NA
## 2 1 1 3
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## media_messaging media_why_message_social media_why_message_avoid
## 1 0.50 5 1
## 2 1.00 5 1
## 3 0.50 4 1
## 4 1.00 NA NA
## 5 0.50 NA NA
## 6 0.75 4 1
## media_why_message_work media_why_message_fun media_why_message_news
## 1 1 1 5
## 2 1 1 1
## 3 1 1 4
## 4 NA NA NA
## 5 NA NA NA
## 6 1 1 1
## media_why_message_nothing media_video media_why_video_social
## 1 1 0.50 NA
## 2 1 0.00 NA
## 3 1 1.00 4
## 4 NA 0.25 NA
## 5 NA 0.00 NA
## 6 1 2.00 4
## media_why_video_avoid media_why_video_work media_why_video_fun
## 1 NA NA NA
## 2 NA NA NA
## 3 1 4 1
## 4 NA NA NA
## 5 NA NA NA
## 6 1 4 1
## media_why_video_news media_why_video_nothing media_playing_voice
## 1 NA NA 0.0
## 2 NA NA 0.0
## 3 1 1 1.0
## 4 NA NA 0.0
## 5 NA NA 0.0
## 6 1 1 0.5
## media_why_voice_social media_why_voice_avoid media_why_voice_work
## 1 NA NA NA
## 2 NA NA NA
## 3 4 1 4
## 4 NA NA NA
## 5 NA NA NA
## 6 1 1 4
## media_why_voice_fun media_why_voice_news media_why_voice_nothing
## 1 NA NA NA
## 2 NA NA NA
## 3 1 1 1
## 4 NA NA NA
## 5 NA NA NA
## 6 1 1 1
## activity_exercise_inside activity_exercise_outside activity_exercise_outside2
## 1 0.0 0.00 0.00
## 2 3.0 0.00 0.00
## 3 0.5 0.25 0.00
## 4 0.5 0.00 0.00
## 5 0.5 0.50 0.00
## 6 1.0 0.25 0.25
## technology_complete brs_1 brs_2 brs_3 brs_4 brs_5 brs_6 brs_complete swemws_1
## 1 2 NA NA NA NA NA NA 0 2
## 2 2 NA NA NA NA NA NA NA 3
## 3 2 NA NA NA NA NA NA NA 4
## 4 2 NA NA NA NA NA NA 0 3
## 5 2 NA NA NA NA NA NA NA 4
## 6 2 NA NA NA NA NA NA NA 3
## swemws_2 swemws_3 swemws_4 swemws_5 swemws_6 swemws_7 swemws7_complete
## 1 2 2 2 4 3 5 2
## 2 4 3 4 4 4 5 2
## 3 3 3 4 5 3 5 2
## 4 4 1 1 3 2 4 2
## 5 2 2 3 4 2 4 2
## 6 4 2 3 4 2 5 2
## oxford_arc_study_optional_task_complete family_code start_date Weekday
## 1 NA NA 2020-04-29 4
## 2 NA NA 2020-04-29 4
## 3 NA NA 2020-04-29 4
## 4 NA NA 2020-04-29 4
## 5 NA NA 2020-04-29 4
## 6 NA NA 2020-04-29 4
## weekStart surveysran surveyscompleted remove big5_O big5_C big5_E big5_A
## 1 2020-04-27 19 19 0 16 16 4 11
## 2 2020-05-04 19 19 0 NA NA NA NA
## 3 2020-05-11 19 19 0 NA NA NA NA
## 4 2020-05-18 19 19 0 NA NA NA NA
## 5 2020-05-25 19 19 0 NA NA NA NA
## 6 2020-06-01 19 19 0 NA NA NA NA
## big5_N pswq_a_total pswq_c_total iou_total mfq_20_total rse_total
## 1 16 79 NA 86 84 23
## 2 NA NA NA NA NA NA
## 3 NA NA NA NA NA NA
## 4 NA NA NA NA NA NA
## 5 NA NA NA NA NA NA
## 6 NA NA NA NA NA NA
## pas_covid_total pss_total phq_total gad_total mfq_state_total
## 1 29 13 12 13 29
## 2 28 8 10 12 40
## 3 29 7 9 12 40
## 4 27 15 17 23 24
## 5 28 11 14 14 28
## 6 27 7 12 11 36
## isolation4_child isolation4_adult edeq brs swemws
## 1 NA 9 19 NA 20
## 2 NA NA 19 NA 27
## 3 NA NA NA NA 27
## 4 NA NA 17 NA 18
## 5 NA NA 16 NA 21
## 6 NA NA 17 NA 23
str(df)
## 'data.frame': 8867 obs. of 423 variables:
## $ X : int 1 2 3 4 5 6 7 8 9 10 ...
## $ record_id : int 12 12 12 12 12 12 12 12 12 12 ...
## $ redcap_event_name : chr "baseline" "week2" "week3" "week4" ...
## $ redcap_data_access_group : logi NA NA NA NA NA NA ...
## $ date : chr "2020-04-29" "2020-05-06" "2020-05-13" "2020-05-20" ...
## $ group : chr "parent" "parent" "parent" "parent" ...
## $ consent : int 1 NA NA NA NA NA NA NA NA NA ...
## $ consent_parent : int NA NA NA NA NA NA NA NA NA NA ...
## $ information_and_consent_complete : int 2 NA NA NA NA NA NA NA NA NA ...
## $ age : int NA NA NA NA NA NA NA NA NA NA ...
## $ gender : chr "female" "female" "female" "female" ...
## $ trans : chr "no" "no" "no" "no" ...
## $ sexual_orientation : chr "Heterosexual/Straight" "Heterosexual/Straight" "Heterosexual/Straight" "Heterosexual/Straight" ...
## $ ethnicity : chr "White - British, Irish, other" NA NA NA ...
## $ relationship_status : chr "In a relationship/married and cohabiting" NA NA NA ...
## $ country : chr "United Kingdom" "United Kingdom" "United Kingdom" "United Kingdom" ...
## $ uk_country : chr NA NA NA NA ...
## $ urban_rural : int 1 NA NA NA NA NA NA NA NA NA ...
## $ dwelling : int 1 NA NA NA NA NA NA NA NA NA ...
## $ dwelling_other : chr "" "" "" "" ...
## $ tenure : int 2 NA NA NA NA NA NA NA NA NA ...
## $ rooms : int 7 NA NA NA NA NA NA NA NA NA ...
## $ n_adults : int 2 NA NA NA NA NA NA NA NA NA ...
## $ n_under_18s : int 1 NA NA NA NA NA NA NA NA NA ...
## $ income : int 5 NA NA NA NA NA NA NA NA NA ...
## $ education : int 7 NA NA NA NA NA NA NA NA NA ...
## $ employment : int 3 NA NA NA NA NA NA NA NA NA ...
## $ health___1 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ health___2 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ health___3 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ health___4 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ health___5 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ health___6 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ health___7 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ health___8 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ health___9 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ health___10 : int 1 NA NA NA NA NA NA NA NA NA ...
## $ health___11 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ medical_other : chr "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ ...
## $ pregnant___1 : int 1 NA NA NA NA NA NA NA NA NA ...
## $ pregnant___2 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ pregnant___3 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ smoking : int 1 NA NA NA NA NA NA NA NA NA ...
## $ alcohol : int 0 NA NA NA NA NA NA NA NA NA ...
## $ caring_responsibilities___1 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ caring_responsibilities___2 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ caring_responsibilities___3 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ pet___1 : int 1 NA NA NA NA NA NA NA NA NA ...
## $ pet___2 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ pet___3 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ pet___4 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ pet___5 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ pet___6 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ support_parents_1 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_parents_2 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_parents_3 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_parents_4 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_friends_1 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_friends_2 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_friends_3 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_friends_4 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_employment_1 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_employment_2 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_employment_3 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_employment_4 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_employment_5 : int NA NA NA NA NA NA NA NA NA NA ...
## $ support_employment_6 : int NA NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_1 : int NA NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___1 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___2 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___3 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___4 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___5 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___6 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___7 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___8 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___9 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___10 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___11 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___12 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___13 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___14 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_why___15 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_positive_other : chr "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ ...
## $ covid_positive_groups : chr "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ ...
## $ covid_positive_most : chr "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ ...
## $ covid_negative : int NA NA NA NA NA NA NA NA NA NA ...
## $ covid_negative_what___1 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_negative_what___2 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_negative_what___3 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_negative_what___4 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_negative_what___5 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_negative_what___6 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_negative_what___7 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_negative_what___8 : int 0 NA NA NA NA NA NA NA NA NA ...
## $ covid_negative_other : chr "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ ...
## $ covid_negative_most : chr "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ "data from open-ended variables have been omited to protect rivacy and anonymity, please contact authors if you "| __truncated__ ...
## $ demographics_complete : int 2 NA NA NA NA NA NA NA NA NA ...
## $ monthly_survey_complete : int NA NA NA NA NA NA NA NA NA NA ...
## [list output truncated]
Subsetting Data
d <- subset(df, redcap_event_name == "baseline", select=c(X, gender,
pswq_c_1,
pswq_c_2,
pswq_c_3,
pswq_c_4,
pswq_c_5,
pswq_c_6,
pswq_c_7,
pswq_c_8,
pswq_c_9,
pswq_c_10,
pswq_c_11,
pswq_c_12,
pswq_c_13,
pswq_c_14))
Basic Data
Checking
Checking Values
d %>%
map(table, useNA = "always")
## $X
##
## 1 20 30 31 32 33 48 49 57 58 67 68 69 79 80 81
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 85 86 103 104 113 116 117 119 120 123 124 125 133 140 142 143
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 154 169 175 179 184 185 189 190 206 208 217 218 219 221 225 226
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 233 252 253 254 255 256 268 269 270 271 272 274 275 276 281 298
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 303 306 307 314 315 316 318 320 321 323 328 330 334 335 356 357
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 359 360 369 370 374 379 380 381 382 383 391 392 393 401 402 408
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 409 410 416 419 420 438 456 457 459 460 461 462 463 464 465 468
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 469 470 472 487 489 490 511 512 520 522 528 529 545 554 563 566
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 574 580 581 590 602 612 625 627 648 655 672 682 686 687 688 696
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 699 708 717 735 736 737 739 740 755 770 771 772 774 776 779 800
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 809 810 813 822 824 826 827 828 840 843 847 849 851 863 865 866
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 883 887 894 896 898 919 932 947 950 951 952 963 967 972 973 975
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 976 977 980 985 991 995 996 1000 1003 1004 1009 1017 1025 1038 1059 1060
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1061 1062 1065 1066 1067 1068 1071 1072 1074 1075 1076 1085 1088 1089 1090 1101
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1115 1127 1144 1147 1148 1155 1162 1169 1180 1187 1206 1224 1226 1246 1247 1250
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1266 1276 1279 1280 1294 1302 1316 1320 1321 1325 1346 1349 1353 1356 1377 1378
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1388 1389 1390 1391 1401 1407 1415 1418 1422 1427 1439 1447 1468 1470 1471 1472
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1474 1475 1476 1477 1484 1485 1486 1487 1488 1489 1491 1492 1493 1494 1495 1499
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1500 1506 1507 1515 1528 1545 1549 1550 1557 1578 1595 1602 1603 1604 1608 1629
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1632 1638 1640 1643 1664 1665 1666 1668 1672 1678 1694 1714 1716 1721 1740 1756
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1761 1780 1791 1804 1805 1806 1809 1811 1815 1816 1833 1834 1849 1851 1866 1869
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1870 1871 1873 1878 1883 1884 1903 1904 1907 1913 1933 1934 1935 1937 1941 1954
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 1965 1978 1979 1985 1986 1989 1997 1998 2000 2006 2007 2024 2028 2029 2044 2045
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2046 2047 2054 2064 2065 2069 2076 2083 2094 2107 2115 2122 2137 2138 2139 2140
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2161 2163 2165 2166 2167 2170 2171 2181 2183 2186 2187 2190 2192 2193 2198 2199
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2211 2215 2227 2231 2234 2244 2245 2247 2264 2270 2271 2281 2282 2283 2285 2287
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2288 2296 2298 2300 2301 2309 2310 2311 2314 2335 2343 2346 2347 2358 2359 2364
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2365 2366 2369 2370 2377 2380 2381 2393 2397 2400 2401 2413 2434 2437 2445 2453
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2455 2456 2459 2467 2468 2474 2475 2482 2484 2485 2506 2512 2524 2525 2526 2530
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2533 2540 2550 2561 2562 2568 2569 2570 2571 2572 2579 2580 2583 2584 2585 2586
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2597 2602 2605 2606 2609 2615 2621 2623 2629 2630 2642 2644 2653 2655 2670 2676
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2680 2681 2683 2684 2685 2688 2689 2694 2695 2697 2711 2712 2717 2718 2719 2720
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2728 2735 2752 2755 2767 2770 2774 2775 2776 2794 2796 2803 2804 2809 2814 2815
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2825 2835 2855 2875 2876 2889 2890 2892 2904 2905 2926 2930 2946 2949 2965 2986
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 2987 2988 3008 3019 3030 3035 3037 3043 3049 3050 3051 3052 3053 3072 3074 3076
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3077 3078 3079 3080 3081 3087 3090 3105 3107 3108 3109 3123 3124 3126 3127 3128
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3140 3146 3147 3152 3153 3154 3156 3160 3163 3178 3184 3185 3187 3188 3195 3196
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3207 3209 3210 3212 3224 3229 3240 3241 3258 3259 3260 3261 3262 3266 3271 3278
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3279 3284 3287 3288 3289 3290 3294 3295 3316 3317 3320 3321 3327 3339 3349 3350
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3371 3372 3377 3380 3382 3383 3390 3393 3395 3397 3399 3400 3410 3412 3413 3415
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3416 3432 3435 3450 3451 3454 3464 3465 3466 3486 3487 3499 3500 3521 3522 3523
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3530 3536 3537 3544 3548 3549 3550 3553 3567 3570 3571 3575 3577 3588 3591 3592
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3593 3594 3595 3613 3614 3615 3616 3619 3620 3621 3622 3624 3634 3636 3638 3639
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3640 3646 3648 3651 3652 3653 3654 3661 3672 3674 3678 3685 3703 3704 3719 3720
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3723 3733 3734 3736 3739 3748 3767 3769 3770 3774 3775 3784 3788 3808 3811 3812
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3833 3834 3835 3838 3839 3840 3841 3847 3849 3868 3874 3875 3876 3877 3878 3879
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3881 3882 3886 3890 3891 3912 3921 3922 3924 3925 3926 3927 3935 3942 3945 3946
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 3947 3952 3953 3954 3955 3956 3957 3966 3967 3988 3989 3992 3993 3995 4015 4017
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4022 4023 4029 4030 4050 4051 4052 4053 4058 4059 4080 4090 4095 4097 4099 4100
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4101 4102 4121 4123 4124 4140 4157 4160 4161 4162 4165 4166 4171 4174 4178 4181
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4182 4192 4195 4196 4217 4228 4237 4258 4259 4261 4270 4271 4273 4282 4292 4297
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4302 4311 4312 4313 4315 4320 4321 4325 4327 4328 4349 4352 4368 4371 4372 4375
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4379 4380 4381 4383 4388 4389 4392 4394 4412 4425 4441 4447 4450 4453 4454 4466
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4471 4472 4475 4489 4493 4494 4498 4500 4501 4522 4525 4526 4531 4532 4540 4545
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4546 4567 4568 4576 4592 4593 4594 4601 4611 4612 4614 4615 4622 4623 4624 4627
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4629 4630 4643 4644 4646 4649 4653 4661 4662 4683 4684 4688 4708 4709 4710 4713
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4714 4719 4720 4723 4724 4729 4750 4751 4752 4753 4755 4756 4757 4758 4759 4768
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4773 4774 4775 4776 4778 4779 4795 4810 4815 4819 4822 4832 4833 4838 4841 4858
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 4859 4868 4885 4886 4889 4890 4892 4913 4917 4935 4942 4960 4976 4980 4982 4997
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5003 5014 5016 5018 5020 5021 5023 5024 5027 5029 5047 5048 5051 5066 5068 5070
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5073 5074 5075 5076 5080 5087 5090 5092 5093 5094 5095 5099 5100 5101 5112 5120
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5121 5122 5136 5153 5167 5168 5169 5170 5171 5176 5179 5180 5182 5195 5196 5197
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5200 5204 5205 5224 5231 5233 5234 5235 5236 5237 5238 5239 5240 5241 5262 5273
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5275 5276 5297 5299 5300 5301 5302 5309 5310 5331 5333 5337 5354 5355 5356 5362
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5363 5364 5365 5366 5367 5368 5369 5371 5372 5373 5374 5392 5393 5394 5396 5397
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5399 5400 5401 5403 5404 5405 5415 5420 5421 5422 5423 5424 5427 5428 5448 5450
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5454 5455 5456 5457 5467 5468 5469 5483 5493 5507 5510 5511 5524 5541 5547 5548
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5568 5569 5579 5580 5581 5590 5591 5592 5596 5597 5598 5599 5602 5606 5607 5608
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5615 5616 5622 5627 5629 5630 5631 5632 5633 5634 5638 5657 5659 5660 5661 5662
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5663 5665 5666 5669 5673 5677 5693 5695 5696 5697 5698 5699 5700 5701 5707 5716
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5722 5724 5734 5743 5745 5746 5747 5752 5756 5759 5761 5763 5770 5771 5773 5794
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5806 5808 5812 5823 5824 5825 5826 5842 5843 5845 5850 5869 5875 5876 5877 5892
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 5893 5910 5917 5918 5925 5946 5965 5972 5975 5977 5984 5987 5998 6001 6002 6003
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6024 6025 6030 6035 6046 6049 6052 6056 6057 6058 6059 6064 6078 6095 6096 6097
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6106 6107 6108 6109 6117 6127 6147 6163 6164 6165 6169 6181 6182 6197 6207 6228
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6230 6239 6240 6244 6246 6249 6250 6262 6277 6278 6279 6280 6281 6282 6283 6286
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6287 6291 6293 6294 6295 6297 6298 6312 6326 6330 6331 6332 6335 6348 6350 6351
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6357 6358 6359 6361 6376 6381 6383 6384 6393 6394 6397 6398 6400 6408 6418 6419
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6420 6421 6423 6424 6425 6431 6433 6434 6437 6439 6440 6441 6453 6454 6455 6456
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6458 6459 6460 6465 6469 6470 6471 6472 6473 6474 6476 6477 6478 6479 6480 6482
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6483 6484 6485 6486 6488 6490 6511 6531 6536 6537 6538 6539 6540 6542 6544 6547
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6548 6565 6566 6567 6568 6569 6570 6571 6573 6574 6580 6581 6582 6586 6587 6588
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6591 6592 6593 6595 6605 6606 6607 6608 6609 6611 6612 6613 6614 6616 6617 6618
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6622 6623 6624 6625 6638 6640 6642 6645 6646 6650 6651 6664 6668 6669 6673 6674
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6675 6676 6679 6681 6683 6685 6687 6688 6691 6692 6693 6694 6695 6696 6697 6698
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6701 6702 6703 6704 6705 6706 6712 6713 6714 6715 6719 6721 6723 6724 6725 6726
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6727 6728 6729 6731 6732 6733 6734 6735 6736 6742 6743 6744 6747 6748 6749 6750
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6751 6752 6753 6754 6758 6759 6760 6761 6762 6763 6764 6766 6776 6778 6780 6781
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6782 6784 6791 6792 6793 6794 6795 6796 6798 6800 6816 6820 6821 6824 6825 6826
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6846 6847 6851 6853 6854 6857 6858 6859 6860 6863 6882 6889 6890 6905 6906 6907
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6908 6927 6928 6929 6931 6932 6933 6934 6935 6936 6940 6952 6965 6966 6968 6969
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 6971 6980 6984 6987 6988 6990 6992 6993 6994 6995 6999 7000 7002 7003 7004 7006
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7008 7013 7014 7018 7019 7030 7031 7032 7037 7038 7043 7045 7053 7060 7061 7071
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7072 7073 7074 7077 7080 7082 7083 7084 7085 7086 7092 7104 7106 7108 7112 7113
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7114 7115 7120 7121 7124 7125 7126 7127 7132 7135 7136 7137 7138 7139 7142 7143
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7144 7145 7148 7151 7154 7159 7160 7161 7166 7183 7184 7192 7196 7197 7198 7207
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7208 7209 7210 7211 7223 7224 7225 7235 7236 7245 7246 7247 7253 7255 7256 7262
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7263 7264 7265 7270 7271 7273 7274 7275 7276 7279 7280 7281 7282 7283 7286 7287
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7289 7291 7294 7298 7303 7304 7307 7308 7323 7324 7325 7329 7341 7342 7343 7346
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7347 7348 7350 7352 7353 7354 7356 7357 7360 7361 7364 7365 7373 7375 7377 7378
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7384 7385 7394 7397 7401 7402 7406 7407 7408 7409 7420 7421 7422 7423 7426 7432
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7433 7434 7436 7437 7439 7440 7442 7443 7444 7445 7447 7448 7455 7456 7457 7458
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7459 7460 7461 7462 7463 7467 7468 7469 7470 7472 7474 7475 7477 7479 7481 7482
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7484 7485 7486 7487 7488 7491 7492 7506 7526 7528 7531 7544 7545 7546 7547 7549
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7550 7551 7564 7565 7572 7577 7578 7579 7580 7591 7592 7595 7596 7608 7610 7613
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7616 7618 7619 7620 7621 7622 7623 7625 7626 7631 7632 7633 7634 7637 7638 7641
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7644 7645 7652 7654 7655 7656 7663 7664 7666 7668 7670 7673 7674 7675 7684 7685
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7688 7689 7690 7691 7693 7695 7697 7705 7719 7721 7722 7723 7726 7732 7733 7734
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7736 7738 7739 7740 7741 7743 7747 7750 7751 7753 7754 7755 7756 7757 7758 7759
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7760 7761 7762 7764 7770 7771 7787 7788 7789 7790 7791 7795 7796 7797 7798 7800
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7817 7820 7821 7826 7827 7831 7832 7838 7839 7847 7849 7850 7851 7852 7853 7854
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7856 7858 7861 7862 7863 7871 7872 7874 7875 7876 7880 7881 7882 7883 7884 7885
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7886 7888 7909 7910 7911 7928 7929 7930 7935 7936 7937 7938 7939 7940 7941 7949
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7950 7952 7953 7955 7956 7958 7960 7961 7982 7983 7984 7985 7986 7989 7990 7998
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 7999 8000 8001 8003 8008 8010 8012 8018 8019 8025 8027 8029 8030 8031 8047 8055
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8056 8071 8072 8075 8076 8077 8078 8080 8081 8089 8090 8091 8093 8094 8095 8096
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8097 8098 8100 8103 8104 8106 8114 8115 8119 8120 8123 8124 8125 8126 8128 8129
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8130 8138 8139 8140 8141 8142 8143 8144 8148 8152 8166 8168 8177 8178 8182 8189
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8190 8197 8198 8199 8200 8207 8208 8209 8212 8213 8215 8216 8218 8223 8224 8238
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8239 8240 8243 8248 8250 8253 8254 8255 8261 8262 8264 8265 8266 8267 8272 8273
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8275 8285 8300 8301 8308 8312 8319 8320 8321 8322 8323 8324 8326 8328 8330 8331
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8333 8335 8348 8352 8370 8371 8388 8389 8390 8392 8395 8397 8406 8409 8411 8414
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8432 8443 8447 8448 8451 8457 8460 8463 8466 8468 8471 8472 8479 8490 8492 8493
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8513 8523 8524 8525 8526 8527 8528 8530 8531 8532 8535 8536 8537 8552 8567 8568
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8570 8574 8575 8577 8578 8580 8586 8588 8589 8590 8591 8592 8593 8596 8600 8601
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8602 8603 8611 8612 8613 8614 8615 8617 8618 8619 8620 8621 8626 8627 8632 8633
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8651 8653 8654 8660 8674 8676 8678 8680 8681 8688 8691 8694 8695 8697 8703 8708
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8727 8729 8737 8738 8739 8747 8759 8760 8763 8764 8774 8775 8777 8778 8779 8783
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8795 8796 8798 8800 8801 8803 8804 8806 8807 8810 8811 8812 8813 8822 8823 8828
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 8834 8853 8854 8856 8858 8860 8861 8865 8867 <NA>
## 1 1 1 1 1 1 1 1 1 0
##
## $gender
##
## female I use another term male Prefer not to say
## 1472 47 311 55
## <NA>
## 188
##
## $pswq_c_1
##
## 1 2 3 4 <NA>
## 98 459 400 283 833
##
## $pswq_c_2
##
## 1 2 3 4 <NA>
## 564 436 201 36 836
##
## $pswq_c_3
##
## 1 2 3 4 <NA>
## 225 394 318 298 838
##
## $pswq_c_4
##
## 1 2 3 4 <NA>
## 179 298 356 404 836
##
## $pswq_c_5
##
## 1 2 3 4 <NA>
## 104 338 351 445 835
##
## $pswq_c_6
##
## 1 2 3 4 <NA>
## 348 344 262 285 834
##
## $pswq_c_7
##
## 1 2 3 4 <NA>
## 633 373 155 77 835
##
## $pswq_c_8
##
## 1 2 3 4 <NA>
## 343 397 273 226 834
##
## $pswq_c_9
##
## 1 2 3 4 <NA>
## 945 179 96 18 835
##
## $pswq_c_10
##
## 1 2 3 4 <NA>
## 454 335 238 207 839
##
## $pswq_c_11
##
## 1 2 3 4 <NA>
## 148 334 440 310 841
##
## $pswq_c_12
##
## 1 2 3 4 <NA>
## 318 363 307 247 838
##
## $pswq_c_13
##
## 1 2 3 4 <NA>
## 439 315 282 200 837
##
## $pswq_c_14
##
## 1 2 3 4 <NA>
## 177 369 353 336 838
Recoding Variables
table(d$gender, useNA = "always")
##
## female I use another term male Prefer not to say
## 1472 47 311 55
## <NA>
## 188
d$gender_rc[d$gender == "female"] <- "f"
d$gender_rc[d$gender == "male"] <- "m"
d$gender_rc[d$gender == "I use another term"] <- "nb"
d$gender_rc[d$gender == "Prefer not to say"] <- NA
table(d$gender_rc, useNA = "always")
##
## f m nb <NA>
## 1472 311 47 243
table(d$pswq_c_2, useNA = "always")
##
## 1 2 3 4 <NA>
## 564 436 201 36 836
d$pswq_c_2_rc[d$pswq_c_2 == 1] <- 4
d$pswq_c_2_rc[d$pswq_c_2 == 2] <- 3
d$pswq_c_2_rc[d$pswq_c_2 == 3] <- 2
d$pswq_c_2_rc[d$pswq_c_2 == 4] <- 1
table(d$pswq_c_2_rc, useNA = "always")
##
## 1 2 3 4 <NA>
## 36 201 436 564 836
table(d$pswq_c_7, useNA = "always")
##
## 1 2 3 4 <NA>
## 633 373 155 77 835
d$pswq_c_7_rc[d$pswq_c_7 == 1] <- 4
d$pswq_c_7_rc[d$pswq_c_7 == 2] <- 3
d$pswq_c_7_rc[d$pswq_c_7 == 3] <- 2
d$pswq_c_7_rc[d$pswq_c_7 == 4] <- 1
table(d$pswq_c_7_rc, useNA = "always")
##
## 1 2 3 4 <NA>
## 77 155 373 633 835
table(d$pswq_c_9, useNA = "always")
##
## 1 2 3 4 <NA>
## 945 179 96 18 835
d$pswq_c_9_rc[d$pswq_c_9 == 1] <- 4
d$pswq_c_9_rc[d$pswq_c_9 == 2] <- 3
d$pswq_c_9_rc[d$pswq_c_9 == 3] <- 2
d$pswq_c_9_rc[d$pswq_c_9 == 4] <- 1
table(d$pswq_c_9_rc, useNA = "always")
##
## 1 2 3 4 <NA>
## 18 96 179 945 835
Factor Scores/Composite
Variables
d$pswq_c <- (d$pswq_c_1 +
d$pswq_c_2_rc +
d$pswq_c_3 +
d$pswq_c_4 +
d$pswq_c_5 +
d$pswq_c_6 +
d$pswq_c_7_rc +
d$pswq_c_8 +
d$pswq_c_9_rc +
d$pswq_c_10 +
d$pswq_c_11 +
d$pswq_c_12 +
d$pswq_c_13 +
d$pswq_c_14)/14
Exporting Data
d2 <- subset(d, select=c(X, gender_rc, pswq_c))
write.csv(d2, file="arc_test.csv", row.names = F)