Python, loop of statements pulling from excel

Question

Im still new to python. Just wondering if there is an easier way to accomplish my task.

This is my current code

win = visual.Window([800,800],monitor="testmonitor", units="deg")

msg = visual.TextStim(win, text='hello this is a test',pos=[0,+1],color='white')
msg.draw()
win.flip()
core.wait(2)

msg = visual.TextStim(win, text='statement 1',pos=[0,+1],color='white')
msg.draw()
win.flip()
core.wait(2)

msg = visual.TextStim(win, text='statement 2',pos=[0,+1],color='white')
msg.draw()
win.flip()
core.wait(2)

msg = visual.TextStim(win, text='statement 3',pos=[0,+1],color='white')
msg.draw()
win.flip()
core.wait(2)

Is there a way I can pull statements from an excel file?

For example: I would have a loop going on and each round it would pull the next line in the file instead of having to copy the code and write a new statement each time?

xlrd for actual Excel files or the csv module for csv text files. You could also put all the strings in a list (or other container) and iterate over it. — wwii
– wwii, Commented Jul 3, 2016 at 21:42

Delgan · Accepted Answer · 2016-07-03 21:45:55Z

2

D on't
R epeat
Y ourself

Your solution uses 4 blocks of codes of 4 lines each, the last 3 lines are the same, and the first is almost the same too!

You can avoid this by using a loop, as you guessed.

Look at what changes between each of your blocks, and stores it in a tuple (for example). Then, loop through this tuple and apply the block with the variable element.

texts = (
    'hello this is a test',
    'statement 1',
    'statement 2',
    'statement 3'
)

for text in texts:
    msg = visual.TextStim(win, text=text, pos=[0, +1], color='white')
    msg.draw()
    win.flip()
    core.wait(2)

answered Jul 3, 2016 at 21:45

Delgan

20k11 gold badges101 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python, loop of statements pulling from excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related