I’m in builder mode. My experiment is within-subjects. The design is that each participant hears five stimuli and makes a rating at four different time-points within each stimulus, for a total of 20 ratings recorded from each participant.
Screenshot 1 shows my Conditions file given as input to the loop. The songs are the stimuli; tp1-tp4 represents the four different time-points at which the four rating scales pop up inside each stim, where the participant has 15 seconds to make a rating of that part of the song as the song plays. (tp1Type-tp4Type represents the categories of each of the time-points, which will be important later in the analysis in SPSS, but doesn’t affect PsychoPy).
Unless I’m mistaken, SPSS prefers the data in the format of one participant per row.
However, currently PsychoPy is outputting the data with one condition (song) per row. For example, when Joe Participant takes the experiment, a single .csv is generated that has one row for each song; the four ratings made for each song are presented within the row for that song.
What I want instead is all Joe’s 20 ratings in a single row, with the column headings being Song1Rating1, Song1Rating2, Song1Rating3, Song1Rating4, Song2Rating1, Song2Rating2…Song4Rating4. Does this make sense?
Am I going about this the wrong way?
Also, is there any way to get PsychoPy to output a cumulative .csv rather than exporting one for each Participant, so it can be readily copy-pasted into SPSS once data collection is complete?