Hello PsychoPy community, I have an experiment which uses the pandas package to import an excel file with lots of stimuli and associated distracter words. During the experiment I’m also using pandas-specific methods like .loc() and .sample() to shuffle and check my trials/words/conditions/etc. Sinc…

Okay, the answer has been found on this thread: [image] Variables empty in online script (looping over dictionaries) Blog Okay, I got it to work! Thank you @dvbridges ! To summarize: use the TrialHandler to import the stimuli. This will need to be edited separately in pyth…

What do those functions do? I’ve not used pandas. I often read variables into arrays from Excel in one (or more) loops which precede the trials loop so I can easily do things like interleaving (prospective memory) and repetition (n-back). Best wishes, Wakefield

@wakecarter pandas imports an excel file and makes a dataframe that can include text as well as numbers, turning the columns into variables based on their name, that you can access by name similar to R. For example, by running: wordList = pd.read_excel(<filename>, sheet_name=<sheetname>) you coul…

Read the information into a multi-dimensional array. code_JS Array.prototype.append = [].push; Begin Experiment wordList=[] Begin Routine (within a loop pointing at the Excel file) wordList.append([Item,Valence,Answer]) You could then loop through this list to add the items they type to a se…

Thanks, I will look more into multidimensional arrays, this seems to be what I need. Cheers!

Refer to elements as wordList[0][0] Shuffle works based on the first index

@wakecarter does it work to simply use open() on a csv file? I keep running into an error trying to import that file: readWords = open('distracters_EN_NH.csv', encoding = 'utf-8') headers = readWords.readline() print(headers) UnicodeEncodeError: 'ascii' codec can't encode character '\ufeff' in po…

Sorry, that’s not a technique I’ve tried online. My Python programming skill has been learnt through PsychoPy Builder code components and my other languages are MATLAB (rusty), PHP/MySQL and originally Commodore BASIC… I therefore let Builder handle files and loops since my only experiments that op…

After a lot of sleuthing, I found something nifty that doesn’t use any extra packages. I haven’t yet ported everything online to test it, but I thought I would put this here in case anyone else is curious. The method involves using data.importCondtions , which imports the csv into a bunch of diction…

@wakecarter I just got online with this… unfortunately, it ends up throwing a ReferenceError: "data is not defined" Would I need to use psychopy.data instead? Or will it just not work?

Alternative to pandas for reading csv/excel files online

Blog

aisa2 June 12, 2020, 4:39pm 18

Okay, the answer has been found on this thread:

Topic		Replies	Views
Replacing "import xlrd" to JS code - creating arrays from a csv Online experiments csv , importing , pavlovia	15	1638	February 3, 2021
Replacing importing functions in Python Online experiments	12	1944	June 6, 2020
Variables empty in online script (looping over dictionaries) Blog pavlovia	22	2826	February 22, 2021
Pandas functionality from PsychoPy for PsychoJS (pavlovia) Online experiments	17	2940	June 3, 2020
Issue converting my Psychopy code component (that runs well locally) so that it is compatible online Online experiments	2	275	November 29, 2023

Alternative to pandas for reading csv/excel files online

Related topics