What are you trying to achieve?:
I have created an excel file (.csv) using psychopy that saves x and y coordinates as a list in a single cell.
I now want to read these values into a different psychopy program that I intend to distribute using Pavlovia. (NB. my original program could generate and use these coodinates on the fly but because it used complicated routines that used bezier curves and various numpy functions I decided to separate this part of the process to make conversion to Pavlovia easier).
So, I now have an excel CSV with the following format / values:
My question is, given that each row has the X coordinates as a list, and the Y coordinates as a list, how do I read in a row at the beginning of each Trial? So, to give an explicit example, I’d like to read the values in cell A2 into a list called targetX during the begin routine section of a code component for a single trial.
Bear in mind, that whatever process I use, I’ve done it this way to make conversion to JS for Pavlovia simpler, but I’m happy to be redirected to a different method.
I’ve tried setting the excel file as a conditions file and reading it in that way but Psychopy throws the following error when I select the file:
Traceback (most recent call last):
File “C:\Program Files\PsychoPy3\lib\site-packages\psychopy\app\builder\dialogs_init_.py”, line 1605, in onBrowseTrialsFile
File “C:\Program Files\PsychoPy3\lib\site-packages\psychopy\data\utils.py”, line 333, in importConditions
File “C:\Program Files\PsychoPy3\lib\site-packages\psychopy\data\utils.py”, line 256, in _attemptImport
trialList, fieldNames = pandasToDictList(trialsArr)
File “C:\Program Files\PsychoPy3\lib\site-packages\psychopy\data\utils.py”, line 313, in pandasToDictList
val = eval(val)
File “”, line 1
[0.30148193 0.30307364 0.30466527 0.30625674 0.30784797 0.30943886
SyntaxError: invalid syntax