study3_raw = read.csv('study 3 - in lab study/study3.csv', stringsAsFactors = TRUE) %>%
mutate(across(c("physicalContinuity_3","physicalContinuity_4", #reverse score relevant items
"institutionContinuit_3", "institutionContinuit_6", "institutionContinuit_8",
'institutionRepair_1', 'institutionRepair_6', 'institutionRepair_7',
'Public_Regard_3', 'Public_Regard_4'), ~ 8 - .)) %>%
mutate(physicalDistance = (as.vector(scale(spatialDist1_1)) + as.vector(scale(spatialDist2))/2), #
physicalContinuity = rowMeans(select(.,matches("physicalContinuity")), na.rm=TRUE),
institutionalContinuity = rowMeans(select(.,matches("institutionContinuit")), na.rm=TRUE),
institutionalContinuity_cultural = rowMeans(select(.,c('institutionContinuit_1', 'institutionContinuit_2', 'institutionContinuit_3')), na.rm=TRUE),
institutionalContinuity_temporal = rowMeans(select(.,c('institutionContinuit_4', 'institutionContinuit_5', 'institutionContinuit_6')), na.rm=TRUE),
institutionalContinuity_diversity = rowMeans(select(.,c('institutionContinuit_7', 'institutionContinuit_8', 'institutionContinuit_9')), na.rm=TRUE),
ingroupIdentification = rowMeans(select(.,matches("ingroupIdenti")), na.rm=TRUE),
ingroupRegard = rowMeans(select(.,matches("ingroupUVA_regard")), na.rm=TRUE),
temporalDistance = (as.vector(scale(TempDist1_1)) + as.vector(scale(TempDist2))/2),
institutionalResponsibility = rowMeans(select(.,matches("institutionRepair"))),
institutionalResponsibility_culpability = rowMeans(select(.,c('institutionRepair_1', 'institutionRepair_2', 'institutionRepair_3','institutionRepair_4','institutionRepair_5')), na.rm=TRUE),
institutionalResponsibility_distrust = rowMeans(select(.,c('institutionRepair_6', 'institutionRepair_7')), na.rm=TRUE),
publicRegard = rowMeans(select(.,matches("Public_Regard")), na.rm=TRUE),
condition = factor(condition, labels=c('Distant','Proximate')))
study3 = merge(study3_raw %>% select(c('computID','condition','centralityOfWrongdoing','physicalDistance':ncol(study3_raw))),
study3_pretest %>% select(c('computID','race':ncol(study3_pretest))), by='computID')