Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Supported by

CSV file as a source of loop +Hebrew

Hello
When I'm attaching a csv file as a source of loop, the cell content in Hebrew become Gibberish:

To resolve this, I saved the excel file as CSV UTF-8
but then in the preview, I got this error message:

Is there a way around it?

Thanks!
Tali

Comments

  • Hey,
    what i tend to do after running an experiment, is to manually open the csv in excel, then:
    data>new query> from csv> (open the same file again)>source>unicode UTF-8> save & load.
    This opens in a new sheet the same info with unicode encoding in which the hebrew is legible.
    Then i delete the original sheet, and save (i tend to then save as an xlsx but i think you can save as csv as well).
    Manual labor, but it works... If you happen to find a different way around this, please let me know.

    good luck
    Avi

    Thanked by 1labovich
  • Hi Avi

    Thanks for your response.
    This is a great way to deal with Gibberish in the data analysis stage. I'll defiantly use it!
    My problem is that I still would not be able to present the stimuli words in Hebrew
    during the experiment (but I guess it's okay since I can always use tables)

    Thanks again,
    Tali

  • Hi tali,

    You can use inline_scripts to load the data table 'manually' into a pandas dataframe and select trials and conditions from this sheet. I think this should work and might solve your issues (hopefully)

    Eduard

    Thanked by 1labovich
Sign In or Register to comment.