This page is under construction.
This page describes the process of cleaning the post-visit survey data.
We import the two CSVs in data/csv/post_visit.
fl <- list.files(file.path(here::here(), "data", "csv", "post_visit"),
"\\.csv$", full.names = TRUE)
pvs <- purrr::map(fl, readr::read_csv, col_types = readr::cols(.default = "c"),
show_col_types = FALSE)names(pvs[[1]]) [1] "start"
[2] "end"
[3] "group_postvisitnotes/last_update"
[4] "group_postvisitnotes/note_cleanup"
[5] "group_postvisitnotes/site_id"
[6] "group_postvisitnotes/date_today"
[7] "group_postvisitnotes/child_first_name"
[8] "group_postvisitnotes/child_middle_name"
[9] "group_postvisitnotes/child_last_name"
[10] "group_postvisitnotes/child_birthdate"
[11] "group_postvisitnotes/child_birth_city"
[12] "group_postvisitnotes/testdate"
[13] "group_postvisitnotes/child_sex"
[14] "group_postvisitnotes/child_agegroup"
[15] "group_postvisitnotes/subject_number"
[16] "group_postvisitnotes/city1"
[17] "group_postvisitnotes/city2"
[18] "group_postvisitnotes/last1"
[19] "group_postvisitnotes/first1"
[20] "group_postvisitnotes/year"
[21] "group_postvisitnotes/year2"
[22] "group_postvisitnotes/day"
[23] "group_postvisitnotes/day2"
[24] "group_postvisitnotes/day1"
[25] "group_postvisitnotes/month"
[26] "group_postvisitnotes/month2"
[27] "group_postvisitnotes/play_id"
[28] "group_postvisitnotes/play_id_test"
[29] "group_postvisitnotes/participant_id"
[30] "group_postvisitnotes/protocol_date"
[31] "group_postvisitnotes/languange_spoken_child"
[32] "group_postvisitnotes/languange_spoken_child/english"
[33] "group_postvisitnotes/languange_spoken_child/spanish"
[34] "group_postvisitnotes/acknowledge_geninfo"
[35] "group_postvisitnotes/group_housingchecklist/rooms"
[36] "group_postvisitnotes/group_housingchecklist/rooms/basement"
[37] "group_postvisitnotes/group_housingchecklist/rooms/kitchen"
[38] "group_postvisitnotes/group_housingchecklist/rooms/eatingarea"
[39] "group_postvisitnotes/group_housingchecklist/rooms/bathroom"
[40] "group_postvisitnotes/group_housingchecklist/rooms/bedroom"
[41] "group_postvisitnotes/group_housingchecklist/rooms/livingroom"
[42] "group_postvisitnotes/group_housingchecklist/rooms/familyroom"
[43] "group_postvisitnotes/group_housingchecklist/rooms/studyroom"
[44] "group_postvisitnotes/group_housingchecklist/group_basement/basement_access"
[45] "group_postvisitnotes/group_housingchecklist/group_basement/group_accessiblebasement/basement_use"
[46] "group_postvisitnotes/group_housingchecklist/group_basement/group_accessiblebasement/basement_playspace"
[47] "group_postvisitnotes/group_housingchecklist/group_basement/group_accessiblebasement/basement_odors"
[48] "group_postvisitnotes/group_housingchecklist/group_kitchen/kitchen_odors"
[49] "group_postvisitnotes/group_housingchecklist/group_bathroom/number_bathroom"
[50] "group_postvisitnotes/group_housingchecklist/group_bathroom/note_bathroomsep"
[51] "group_postvisitnotes/group_housingchecklist/group_bathroom/group_bathroomsep_count"
[52] "group_postvisitnotes/group_housingchecklist/group_childroom/childroom_whoseroom"
[53] "group_postvisitnotes/group_housingchecklist/group_childroom/childroom_inhabitants"
[54] "group_postvisitnotes/group_housingchecklist/group_bedroom/number_bedrooms"
[55] "group_postvisitnotes/group_housingchecklist/group_bedroom/note_bedrooms"
[56] "group_postvisitnotes/group_housingchecklist/group_bedroom/group_bedrooomsep_count"
[57] "group_postvisitnotes/group_housingchecklist/group_livingroom/living_couchcondition"
[58] "group_postvisitnotes/group_housingchecklist/group_familyroom/family_couchcondition"
[59] "group_postvisitnotes/group_housingchecklist/group_houseinside/frontdoorlock"
[60] "group_postvisitnotes/group_housingchecklist/group_houseinside/number_insidestairs"
[61] "group_postvisitnotes/group_housingchecklist/group_houseinside/group_insidestairs_count"
[62] "group_postvisitnotes/group_housingchecklist/group_houseoutside/front_maintenance"
[63] "group_postvisitnotes/group_housingchecklist/group_houseoutside/outside_playarea"
[64] "group_postvisitnotes/group_housingchecklist/group_houseoutside/front_exteriorwall"
[65] "group_postvisitnotes/group_housingchecklist/group_houseoutside/house_type"
[66] "group_postvisitnotes/group_housingchecklist/group_houseoutside/building_floors"
[67] "group_postvisitnotes/group_housingchecklist/group_houseoutside/home_floor"
[68] "group_postvisitnotes/group_housingchecklist/group_houseoutside/number_outsidestairs"
[69] "group_postvisitnotes/group_housingchecklist/group_houseoutside/group_outsidestairs/outstairs_handrail"
[70] "group_postvisitnotes/group_housingchecklist/group_neighborhood/neighbor_distance"
[71] "group_postvisitnotes/group_housingchecklist/group_neighborhood/group_street/busy_street"
[72] "group_postvisitnotes/group_housingchecklist/group_neighborhood/group_street/number_streetlanes"
[73] "group_postvisitnotes/group_housingchecklist/group_neighborhood/sidewalk_condition"
[74] "group_postvisitnotes/group_housingchecklist/group_neighborhood/litter"
[75] "group_postvisitnotes/group_housingchecklist/acknowledge_housingchecklist"
[76] "group_postvisitnotes/group_cleanupnotes/group_timerecording/actual_time_start"
[77] "group_postvisitnotes/group_cleanupnotes/group_timerecording/total_record_time"
[78] "group_postvisitnotes/group_cleanupnotes/study_parts"
[79] "group_postvisitnotes/group_cleanupnotes/study_parts/natural"
[80] "group_postvisitnotes/group_cleanupnotes/study_parts/housewalkthrough"
[81] "group_postvisitnotes/group_cleanupnotes/study_parts/structured"
[82] "group_postvisitnotes/group_cleanupnotes/study_parts/mcdi"
[83] "group_postvisitnotes/group_cleanupnotes/study_parts/health"
[84] "group_postvisitnotes/group_cleanupnotes/study_parts/rothbart"
[85] "group_postvisitnotes/group_cleanupnotes/study_parts/locomotor"
[86] "group_postvisitnotes/group_cleanupnotes/study_parts/media"
[87] "group_postvisitnotes/group_cleanupnotes/study_parts/pets"
[88] "group_postvisitnotes/group_cleanupnotes/study_parts/division"
[89] "group_postvisitnotes/group_cleanupnotes/study_parts/typical_day"
[90] "group_postvisitnotes/group_cleanupnotes/group_decibel/tablet_location"
[91] "group_postvisitnotes/group_cleanupnotes/group_housewalk/housewalk_completion"
[92] "group_postvisitnotes/group_cleanupnotes/group_housewalk/room_missing"
[93] "group_postvisitnotes/group_cleanupnotes/group_housewalk/notes_missing"
[94] "group_postvisitnotes/group_cleanupnotes/group_housewalk/room_refuse"
[95] "group_postvisitnotes/group_cleanupnotes/group_housewalk/notes_why"
[96] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers"
[97] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers/configuration"
[98] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers/items"
[99] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers/position"
[100] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers/other"
[101] "group_postvisitnotes/group_cleanupnotes/group_barriers/notes_barriers"
[102] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior"
[103] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/talk"
[104] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/engage"
[105] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/perform"
[106] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/exp_care"
[107] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/other"
[108] "group_postvisitnotes/group_cleanupnotes/group_mother/notes_mother"
[109] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior"
[110] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior/talk"
[111] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior/engage"
[112] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior/perform"
[113] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior/other"
[114] "group_postvisitnotes/group_cleanupnotes/group_child/notes_child"
[115] "group_postvisitnotes/group_cleanupnotes/group_violations/criteria_deviations"
[116] "group_postvisitnotes/group_cleanupnotes/group_violations/note_criteria_deviations"
[117] "group_postvisitnotes/group_cleanupnotes/group_violations/equipment_issues"
[118] "group_postvisitnotes/group_cleanupnotes/group_violations/notes_equipment_issues"
[119] "group_postvisitnotes/group_cleanupnotes/group_violations/breaks_pauses"
[120] "group_postvisitnotes/group_cleanupnotes/group_violations/notes_breaks_pauses"
[121] "group_postvisitnotes/group_cleanupnotes/group_violations/incorrect_protocol"
[122] "group_postvisitnotes/group_cleanupnotes/group_violations/notes_incorrect_protocol"
[123] "group_postvisitnotes/group_cleanupnotes/group_violations/questionnaire_mother"
[124] "group_postvisitnotes/group_cleanupnotes/group_violations/notes_questionnaire_mother"
[125] "group_postvisitnotes/group_cleanupnotes/group_safetyexp/experimenter_safety"
[126] "group_postvisitnotes/group_cleanupnotes/group_safetypart/injured_upset"
[127] "group_postvisitnotes/group_cleanupnotes/notes_othercomments"
[128] "group_postvisitnotes/group_cleanupnotes/acknowledge_cleanup"
[129] "__version__"
[130] "_version_"
[131] "_version__001"
[132] "meta/instanceID"
[133] "_id"
[134] "_uuid"
[135] "_submission_time"
[136] "_index"
[137] "_parent_table_name"
[138] "_parent_index"
[139] "_tags"
[140] "_notes" dim(pvs[[1]])[1] 6 140names(pvs[[2]]) [1] "start"
[2] "end"
[3] "group_postvisitnotes/last_update"
[4] "group_postvisitnotes/note_cleanup"
[5] "group_postvisitnotes/site_id"
[6] "group_postvisitnotes/subject_number"
[7] "group_postvisitnotes/testdate"
[8] "group_postvisitnotes/date_today"
[9] "group_postvisitnotes/experimenter_name"
[10] "group_postvisitnotes/child_first_name"
[11] "group_postvisitnotes/child_middle_name"
[12] "group_postvisitnotes/child_last_name"
[13] "group_postvisitnotes/child_birthdate"
[14] "group_postvisitnotes/child_birth_city"
[15] "group_postvisitnotes/child_sex"
[16] "group_postvisitnotes/child_agegroup"
[17] "group_postvisitnotes/city1"
[18] "group_postvisitnotes/city2"
[19] "group_postvisitnotes/last1"
[20] "group_postvisitnotes/first1"
[21] "group_postvisitnotes/year"
[22] "group_postvisitnotes/year2"
[23] "group_postvisitnotes/day"
[24] "group_postvisitnotes/day2"
[25] "group_postvisitnotes/day1"
[26] "group_postvisitnotes/month"
[27] "group_postvisitnotes/month2"
[28] "group_postvisitnotes/play_id"
[29] "group_postvisitnotes/db_session"
[30] "group_postvisitnotes/db_naturalplay"
[31] "group_postvisitnotes/db_housewalkthrough"
[32] "group_postvisitnotes/db_structuredplay"
[33] "group_postvisitnotes/db_questionnaires"
[34] "group_postvisitnotes/db_decibel"
[35] "group_postvisitnotes/databrary/note_upload"
[36] "group_postvisitnotes/databrary/databrary_session"
[37] "group_postvisitnotes/databrary/databrary_naturalplay"
[38] "group_postvisitnotes/databrary/databrary_housewalkthrough"
[39] "group_postvisitnotes/databrary/databrary_structuredplay"
[40] "group_postvisitnotes/databrary/databrary_questionnaires"
[41] "group_postvisitnotes/decibel/note_decibel"
[42] "group_postvisitnotes/protocol_date"
[43] "group_postvisitnotes/languange_spoken_child"
[44] "group_postvisitnotes/languange_spoken_child/english"
[45] "group_postvisitnotes/languange_spoken_child/spanish"
[46] "group_postvisitnotes/acknowledge_geninfo"
[47] "group_postvisitnotes/group_housingchecklist/rooms"
[48] "group_postvisitnotes/group_housingchecklist/rooms/basement"
[49] "group_postvisitnotes/group_housingchecklist/rooms/kitchen"
[50] "group_postvisitnotes/group_housingchecklist/rooms/eatingarea"
[51] "group_postvisitnotes/group_housingchecklist/rooms/bathroom"
[52] "group_postvisitnotes/group_housingchecklist/rooms/bedroom"
[53] "group_postvisitnotes/group_housingchecklist/rooms/livingroom"
[54] "group_postvisitnotes/group_housingchecklist/rooms/familyroom"
[55] "group_postvisitnotes/group_housingchecklist/rooms/studyroom"
[56] "group_postvisitnotes/group_housingchecklist/group_basement/basement_access"
[57] "group_postvisitnotes/group_housingchecklist/group_basement/group_accessiblebasement/basement_use"
[58] "group_postvisitnotes/group_housingchecklist/group_basement/group_accessiblebasement/basement_playspace"
[59] "group_postvisitnotes/group_housingchecklist/group_basement/group_accessiblebasement/basement_odors"
[60] "group_postvisitnotes/group_housingchecklist/group_kitchen/kitchen_odors"
[61] "group_postvisitnotes/group_housingchecklist/group_bathroom/number_bathroom"
[62] "group_postvisitnotes/group_housingchecklist/group_bathroom/note_bathroomsep"
[63] "group_postvisitnotes/group_housingchecklist/group_bathroom/group_bathroomsep_count"
[64] "group_postvisitnotes/group_housingchecklist/group_childroom/childroom_whoseroom"
[65] "group_postvisitnotes/group_housingchecklist/group_childroom/childroom_inhabitants"
[66] "group_postvisitnotes/group_housingchecklist/group_bedroom/number_bedrooms"
[67] "group_postvisitnotes/group_housingchecklist/group_bedroom/note_bedrooms"
[68] "group_postvisitnotes/group_housingchecklist/group_bedroom/group_bedrooomsep_count"
[69] "group_postvisitnotes/group_housingchecklist/group_livingroom/living_couchcondition"
[70] "group_postvisitnotes/group_housingchecklist/group_familyroom/family_couchcondition"
[71] "group_postvisitnotes/group_housingchecklist/group_houseinside/frontdoorlock"
[72] "group_postvisitnotes/group_housingchecklist/group_houseinside/number_insidestairs"
[73] "group_postvisitnotes/group_housingchecklist/group_houseinside/group_insidestairs_count"
[74] "group_postvisitnotes/group_housingchecklist/group_houseoutside/front_maintenance"
[75] "group_postvisitnotes/group_housingchecklist/group_houseoutside/outside_playarea"
[76] "group_postvisitnotes/group_housingchecklist/group_houseoutside/front_exteriorwall"
[77] "group_postvisitnotes/group_housingchecklist/group_houseoutside/house_type"
[78] "group_postvisitnotes/group_housingchecklist/group_houseoutside/building_floors"
[79] "group_postvisitnotes/group_housingchecklist/group_houseoutside/home_floor"
[80] "group_postvisitnotes/group_housingchecklist/group_houseoutside/number_outsidestairs"
[81] "group_postvisitnotes/group_housingchecklist/group_houseoutside/group_outsidestairs/outstairs_handrail"
[82] "group_postvisitnotes/group_housingchecklist/group_neighborhood/neighbor_distance"
[83] "group_postvisitnotes/group_housingchecklist/group_neighborhood/group_street/busy_street"
[84] "group_postvisitnotes/group_housingchecklist/group_neighborhood/group_street/number_streetlanes"
[85] "group_postvisitnotes/group_housingchecklist/group_neighborhood/sidewalk_condition"
[86] "group_postvisitnotes/group_housingchecklist/group_neighborhood/litter"
[87] "group_postvisitnotes/group_housingchecklist/acknowledge_housingchecklist"
[88] "group_postvisitnotes/group_cleanupnotes/group_timerecording/actual_time_start"
[89] "group_postvisitnotes/group_cleanupnotes/group_timerecording/total_record_time"
[90] "group_postvisitnotes/group_cleanupnotes/study_parts"
[91] "group_postvisitnotes/group_cleanupnotes/study_parts/natural"
[92] "group_postvisitnotes/group_cleanupnotes/study_parts/housewalkthrough"
[93] "group_postvisitnotes/group_cleanupnotes/study_parts/structured"
[94] "group_postvisitnotes/group_cleanupnotes/study_parts/locomotor"
[95] "group_postvisitnotes/group_cleanupnotes/study_parts/mcdi_short_eng"
[96] "group_postvisitnotes/group_cleanupnotes/study_parts/mcdi_short_spa"
[97] "group_postvisitnotes/group_cleanupnotes/study_parts/dlles_short_eng"
[98] "group_postvisitnotes/group_cleanupnotes/study_parts/dlles_short_spa"
[99] "group_postvisitnotes/group_cleanupnotes/study_parts/dlles_extended"
[100] "group_postvisitnotes/group_cleanupnotes/study_parts/spacial_math_tech"
[101] "group_postvisitnotes/group_cleanupnotes/study_parts/health"
[102] "group_postvisitnotes/group_cleanupnotes/study_parts/rothbart"
[103] "group_postvisitnotes/group_cleanupnotes/study_parts/media"
[104] "group_postvisitnotes/group_cleanupnotes/study_parts/pets"
[105] "group_postvisitnotes/group_cleanupnotes/study_parts/division"
[106] "group_postvisitnotes/group_cleanupnotes/study_parts/typical_day"
[107] "group_postvisitnotes/group_cleanupnotes/zoom"
[108] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires"
[109] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/locomotor"
[110] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/mcdi_short_eng"
[111] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/mcdi_short_spa"
[112] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/dlles_short_eng"
[113] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/dlles_short_spa"
[114] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/dlles_extended"
[115] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/spacial_math_tech"
[116] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/health"
[117] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/rothbart"
[118] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/media"
[119] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/pets"
[120] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/division"
[121] "group_postvisitnotes/group_cleanupnotes/zoom_questionnaires/typical_day"
[122] "group_postvisitnotes/group_cleanupnotes/comments_zoom_questionnaires"
[123] "group_postvisitnotes/group_cleanupnotes/group_decibel/tablet_location"
[124] "group_postvisitnotes/group_cleanupnotes/group_housewalk/housewalk_completion"
[125] "group_postvisitnotes/group_cleanupnotes/group_housewalk/room_missing"
[126] "group_postvisitnotes/group_cleanupnotes/group_housewalk/comments_missing"
[127] "group_postvisitnotes/group_cleanupnotes/group_housewalk/room_refuse"
[128] "group_postvisitnotes/group_cleanupnotes/group_housewalk/comments_why"
[129] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers"
[130] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers/configuration"
[131] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers/items"
[132] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers/position"
[133] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers/other"
[134] "group_postvisitnotes/group_cleanupnotes/group_barriers/barriers/doesnotapply"
[135] "group_postvisitnotes/group_cleanupnotes/group_barriers/comments_barriers"
[136] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior"
[137] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/talk"
[138] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/engage"
[139] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/perform"
[140] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/exp_care"
[141] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/other"
[142] "group_postvisitnotes/group_cleanupnotes/group_mother/mother_behavior/doesnotapply"
[143] "group_postvisitnotes/group_cleanupnotes/group_mother/comments_mother"
[144] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior"
[145] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior/talk"
[146] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior/engage"
[147] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior/perform"
[148] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior/other"
[149] "group_postvisitnotes/group_cleanupnotes/group_child/child_behavior/doesnotapply"
[150] "group_postvisitnotes/group_cleanupnotes/group_child/comments_child"
[151] "group_postvisitnotes/group_cleanupnotes/group_violations/criteria_deviations"
[152] "group_postvisitnotes/group_cleanupnotes/group_violations/comments_criteria_deviations"
[153] "group_postvisitnotes/group_cleanupnotes/group_violations/equipment_issues"
[154] "group_postvisitnotes/group_cleanupnotes/group_violations/comments_equipment_issues"
[155] "group_postvisitnotes/group_cleanupnotes/group_violations/breaks_pauses"
[156] "group_postvisitnotes/group_cleanupnotes/group_violations/comments_breaks_pauses"
[157] "group_postvisitnotes/group_cleanupnotes/group_violations/incorrect_protocol"
[158] "group_postvisitnotes/group_cleanupnotes/group_violations/comments_incorrect_protocol"
[159] "group_postvisitnotes/group_cleanupnotes/group_violations/questionnaire_mother"
[160] "group_postvisitnotes/group_cleanupnotes/group_violations/comments_questionnaire_mother"
[161] "group_postvisitnotes/group_cleanupnotes/group_safetyexp/experimenter_safety"
[162] "group_postvisitnotes/group_cleanupnotes/group_safetyexp/comments_experimenter_safety"
[163] "group_postvisitnotes/group_cleanupnotes/group_safetypart/adverse_event"
[164] "group_postvisitnotes/group_cleanupnotes/group_safetypart/comments_adverse_event"
[165] "group_postvisitnotes/group_cleanupnotes/notes_othercomments"
[166] "group_postvisitnotes/group_cleanupnotes/acknowledge_cleanup"
[167] "group_postvisitnotes/note_submission"
[168] "group_postvisitnotes/note_googleform"
[169] "__version__"
[170] "meta/instanceID"
[171] "_id"
[172] "_uuid"
[173] "_submission_time"
[174] "_index"
[175] "_parent_table_name"
[176] "_parent_index"
[177] "_tags"
[178] "_notes" dim(pvs[[2]])[1] 900 178Most of the entries are in the second form, so we start there.
pv <- pvs[[2]]The following variables are metadata variables that can be removed from the dataset:
metadata_vars <- c("start",
"end",
"__version__",
"meta/instanceID",
"_id",
"_uuid",
"_submission_time",
"_index",
"_parent_table_name",
"_parent_index",
"_tags",
"_notes")We omit these.
pv <- pv |>
dplyr::select(-metadata_vars)Warning: Using an external vector in selections was deprecated in tidyselect 1.1.0.
ℹ Please use `all_of()` or `any_of()` instead.
# Was:
data %>% select(metadata_vars)
# Now:
data %>% select(all_of(metadata_vars))
See <https://tidyselect.r-lib.org/reference/faq-external-vector.html>.Some variables are intended for project staff only.
The housing checklist items are in group_postvisitnotes/group_housingchecklist.
We select them.
housing_checklist <- pv |>
dplyr::select(contains("group_housingchecklist"))Remove the variable header (group_postvisitnotes/group_housingchecklist).
(names(housing_checklist) <- stringr::str_remove(string = names(housing_checklist), "group_postvisitnotes\\/group_housingchecklist\\/")) [1] "rooms"
[2] "rooms/basement"
[3] "rooms/kitchen"
[4] "rooms/eatingarea"
[5] "rooms/bathroom"
[6] "rooms/bedroom"
[7] "rooms/livingroom"
[8] "rooms/familyroom"
[9] "rooms/studyroom"
[10] "group_basement/basement_access"
[11] "group_basement/group_accessiblebasement/basement_use"
[12] "group_basement/group_accessiblebasement/basement_playspace"
[13] "group_basement/group_accessiblebasement/basement_odors"
[14] "group_kitchen/kitchen_odors"
[15] "group_bathroom/number_bathroom"
[16] "group_bathroom/note_bathroomsep"
[17] "group_bathroom/group_bathroomsep_count"
[18] "group_childroom/childroom_whoseroom"
[19] "group_childroom/childroom_inhabitants"
[20] "group_bedroom/number_bedrooms"
[21] "group_bedroom/note_bedrooms"
[22] "group_bedroom/group_bedrooomsep_count"
[23] "group_livingroom/living_couchcondition"
[24] "group_familyroom/family_couchcondition"
[25] "group_houseinside/frontdoorlock"
[26] "group_houseinside/number_insidestairs"
[27] "group_houseinside/group_insidestairs_count"
[28] "group_houseoutside/front_maintenance"
[29] "group_houseoutside/outside_playarea"
[30] "group_houseoutside/front_exteriorwall"
[31] "group_houseoutside/house_type"
[32] "group_houseoutside/building_floors"
[33] "group_houseoutside/home_floor"
[34] "group_houseoutside/number_outsidestairs"
[35] "group_houseoutside/group_outsidestairs/outstairs_handrail"
[36] "group_neighborhood/neighbor_distance"
[37] "group_neighborhood/group_street/busy_street"
[38] "group_neighborhood/group_street/number_streetlanes"
[39] "group_neighborhood/sidewalk_condition"
[40] "group_neighborhood/litter"
[41] "acknowledge_housingchecklist" Discuss further cleaning with Kasey before proceeding further.