Hi Jeremy,
Thanks a lot for your reply! My experiment asked participants to rate French words according to certain criteria. I got the table by selecting relevant columns and then selecting certain words (rows) in R:
# select and rename relevant columns
tidied_val <- results_val %>%
filter(Parameter == "Choice" | Value == "Start") %>%
select(ID, group, entry, Label, Parameter, PennElementName, Value, EventTime, word_id) %>%
group_by(group, ID, entry) %>%
mutate(RT = (mean(EventTime[Parameter=="Choice"] - EventTime[Value=="Start"]))/10) %>%
ungroup() %>%
filter(Parameter == "Choice") %>%
select(ID, group, Value, entry, RT, Label, word_id) %>%
rename(score = Value)
# quality check (valence)
quality_val <- tidied_val %>%
filter(entry == "amour"|
entry == "espoir"|
entry == "haine"|
entry == "peur"|
entry == "tristesse"|
entry == "fer"|
entry == "sandwich"|
entry == "cauchemar"|
entry =="douleur"|
entry =="rire"|
entry =="passion"|
entry =="jalousie"|
entry == "racisme"|
entry == "anxiété"|
entry == "dent"|
entry == "plaisir"|
entry == "souffrance"|
entry == "colère"|
entry == "désagréable"|
entry == "bonheur"|
entry == "richesse"|
entry == "poire"|
entry == "moyen"|
entry == "horreur"|
entry == "mensonge"|
entry == "confort"|
entry == "victoire"|
entry == "diable"|
entry == "chagrin"|
entry == "vertu" |
entry == "appareil") %>%
group_by(ID)
readr::write_excel_csv(quality_val, "quality_val.csv")
The ID variable was acquired by asking participants to enter it by themselves. I thought about whether it might be two different participants, on of whom accidentally put the wrong ID. But why would the two records have the same response time in that case?
May I know what you referred when saying “MD5 hash”? I’m wondering how to distinguish which four records belonged to that single participant…
Best wishes,
Chloris