Running CSVs on Android

Comments

• eduard

  November 2018

  Hi Sannee,

  I don't know what the issue is, or how to solve it. But you probably can bypass it. Just don't use the loop table at all. Use python scripts directly to read the csv file (maybe with python pandas) and define variables based on that. I think this will be rather straightforward.

  Hope this is useful.

  Eduard

  
• Sannee

  November 2018

  Hi!

  Sorry for my late comment, thank you for the suggestion!

  I am not super familiar with using python scripts. Could you maybe show me a quick example of how I could use it? And could I just say then in the "source" part of the OpenSesame experiment that it should read in a .py file instead of a .csv, would that be enough?

  Kind regards,
  Sanne
• eduard

  November 2018

  Hi Sanne,

  Here some example code how to load the data:

  import pandas as pd
  
  # read the file
  table = pd.read_csv('/path/to/file/voorbeelden.csv')
  
  # the first number indicates the index of the row
  # the second one indicates the column label
  print(table.loc[0,'Spreekwoord'])
  
  # so to define vaiables per trial, you can do stuff like
  
  # I assume you have trial numbers defined in the loop table
  
  var.spreekword = table.loc[var.trial_no-1,'Spreekwoord']
  var.geluid = table.loc[var.trial_no-1,'Geluid']
  

  Make sure to put this code in the prepare phase of an inline_script in the beginning of your trial loop. Also, make sure that you have the trial number set in the loop table.

  And could I just say then in the "source" part of the OpenSesame experiment that it should read in a .py file instead of a .csv, would that be enough?

  I'm not sure what you mean with that, but if you don't let Opensesame load your text file, you can set source to table and everything should be fine.

  Does that make sense?

  Eduard