Loop from external file (.csv or .xlsx) - issue

Stakhanov · August 2016

Hello,

I'm actually trying to use an external file (.csv or .xslx) instead of the traditional table in order to present my sequences.
There will be one distinct version for each subject, so one external file will be assigned for each of them.
When trying to use a .csv, I got this issue:

And this is the issue when trying to use a .xlsx:

Any advice? :-) Many thanks in advance for your assistance.

Best regards,

Benjamin

sebastiaan · August 2016

Hi Benjamin,

Regarding the .csv file: This must be utf8 encoded. If it's not, and if the file contains special characters (which I'm guessing it does given that you're using the French translation), you get a decoding error. When saving the .csv file in whatever program you use to edit it, you probably have the option to select the encoding. (The error message could be more informative though.)

See also:

http://osdoc.cogsci.nl/3.1/manual/structure/loop/#reading-independent-variables-from-file

Regarding the .xlsx file: I forgot to include openpyxl during packaging. You can install by entering the following in the debug window:

import pip
pip.main(['install', 'openpyxl'])

Howdy, Stranger!

Categories

Loop from external file (.csv or .xlsx) - issue

Comments

Howdy, Stranger!

Quick Links

Categories

Loop from external file (.csv or .xlsx) - issue

Comments