Data Format of response times in .cvs

Builder
1

Hi everyone!

I created a IAT test in the Builder and I need to analyse response times.
The stimuli appeared on the screen for 2 seconds.

I know that Psychopy stores times in seconds, but in the .cvs file I have times such 13.452.178.000.006.800 or 12.643.770.999.857.200.
How should I interpret these results? Do you think they are milliseconds?

Thank you for any help!

2

Hello

Have you opened the csv file in Excel? Excel sometimes misinterprets the data format. LibreOffice, OpenOffice or Google spreadsheets may do a better job.

Bets wishes Jens

3

Hi,
Thank you for the quick reply!
I’ve tried in Excel and Google sheet, but the visualization is the same.
And since the visualization time of the stimuli is 2 seconds, I find it hard to interpret such large numbers (13.452.178.000.006.800), I don’t understand which time unit is used.

4

Hello

If you open the csv file with a text editor, what do the numbers look like?

Best wishes Jens

5

Hi,

I tried with Sublime and they’re the same as in Excel and Google Sheet.

Best, Viola

6

Hello

But you did not save the file when you opened previously in Excel? Do you mind posting a sample file unopened by any software?

Best wishes Jens

7

11_2024-10-21_17h13.17.349.csv (11.8 KB)

Hi, I don’t have a never-opened file, but here’s an example.
The issue is with the column “key_resp.rt”.
Thank you for taking the time

8

Hello

I have no idea. The numbers are really off. There was a PsychoPy-version in which RT was measured relative to the experiment start and not to component start but that does fit to your RTs.

Sorry, I have no further ideas.

Best wishes Jens

9

I think the issue is that your version of excel (and maybe the how the builder is saving data) is saving it as a ssv (semicolon separated value) instead of a typical csv (semicolon separated value). With this I think the values within the times are being misinterpreted by excel (this might also have something to do with your data output). I would make sure you are saving it as a csv. file, and not a cvs. Because some data cells are correctly formatted for how psychopy saves data.
Issac

10

Hi,
thank you for the tip.
Do you know if there’s a way I can re-save/re-download data from an experiment?
Thank you

11

Hello

I thought that you had send me a result-file which was never opened and saved with any spreadsheet. Try R or SPSS for reading an file never opened with a spreadsheet.

Go to your Pavlovia-dashboard, select View code. This takes you to your gitlab-account. There you will see a data-folder which you can download.

Best wishes Jens