I don’t know if anyone else has encountered the same issue but when analysing the generated data from Pavlovia (in excel format), some of the variables/rows are presented in a different order for participants (i.e some participants have reaction time for key response in column H, and others in column K).
Most recently, I developed a new batch of tasks and in the resulting spreadsheets, the participant responses cells are not even aligned with the presented stimuli cells (R (key response column) red (stimuli column)). For some reason they aren’t presented at the same level, having to delete one cell at the top of one of the columns in order to make them match.
These little issues make the data analysis much more demanding, especially when having many participants.
I was wondering if someone knows of a way to reshape the spreadsheet within Psychopy, by changing the structure of the task a little; or making the analysis with excel less effortful (since Pavlovia reproduce the data in different spreadsheets for each participants, what I’m currently doing is combining the spreadsheets in one excel file and filtering the data by columns - this is why I need participants’ responses on the same column).