Files should not be getting saved with large numbers like that from either PsychoPy or PsychoJS (and I’d be surprised if they are). That looks more like something that has happened after saving or during import to your spreadsheet package (e.g. it has formatted the column incorrectly). Could you provide the details of your project for me to check?
Encoding phase: An image and a word is presented simultaneously.
Distraction phase: some distraction
Vividness: Vividness of the distraction
Test Phase 1: click on the image that was presented in the encoding phase, among 6 alternatives
Test Phase 2: click on the word that was presented in the encoding phase, among 6 alternatives
In the first image:
mouse_retW.time: RT to test phase 2
mouse_retI.time: RT to ttest phase 1
In the second image:
The same procedure, the distraction is different.
Preferably a link to the gitlab project so I can check the files. If not then could you upload one of the csv files here directly (assuming it’s anonymous - don’t do that if you included any identifying participant info that you don’t have permission to share)
OK, yes, I believe the issue is not in the data file itself but in the way your spreadsheet is reading it in and converting it, for some reason. When I look in the file, I notice that the column headers aren’t aligned with the data (maybe you deleted some data to anonymise) but then I see column BJ looking like this with what looks like the mouse_retI.time data. This is the format that PsychoPy normally outputs, with seconds as a decimal. Depending on your computer localisation settings possibly your spreadsheet app is treating the decimal place as meaning 1000 rather than a decimal? That’s my best guess, but certainly in the raw file the data look correct.
use OpenOffice. OpenOffice asks you what they should use as decimal separator when importing csv. Or change the decimal separator in the Excel-setting before importing. Or replace the decimal separator in Notepad++ (it allows you to replace a string in all opened files). Or use R to read the data specifying column and decimal separator (best option IMHO).
This is really a drawback for a non-english setup that PsychoJS and PsychoPy do not use the settings from the OS and you can not specify the column separator (you can in PsychoPy) and decimal sign.
It would also be cool if M$ would finally change the behavior of Excel when importing csv. But this error is known for years, if not decades.