Problem with programming a randomized experiment

Builder
1

Hi, I am trying to create an experiment with randomized trials. It will be a translation experiment so I have 50 word pairs. The problem is that I want to create a mixed block in which 25 words from language 1 should appear and 25 words from language two. It should be randomized which words appear from the word pairs in which language, but if a word is presented in one language then the counterpart in language 2 should not appear in the block. How do I do that and how does it work that exactly 25 words appear in every language from the 50 word pair excel list? Do I have to program this directly in Psychopy or use excel and randomize manually for every participant?
Thank you!

2

I would have one spreadsheet with 50 rows and a column for each language and have a shuffled list of 25 1s and 25 2s. Then I could use a code component with something like:

if shuffledList[trials.theN] == 1:
     thisWord = lang1
else:
     thisWord = lang2