Generate list of random permutations by column

6 次查看（过去 30 天）
Santiago Poretti
Santiago Poretti 2021-6-1
回答： David Hill 2021-6-1
I am trying to create a code that will auto populate an excel spreadsheet with 50 random permutations of 32. So every column should have 32 rows with a different value (1-32) without repetition in each row.
I know I can obtain a random permutation in a [1x32] matrix by using
A = randperm(32);
I can then transpose A to have it become a [32x1] matrix.
I want a new [32x1] matrix of a random permutations for the first 50 columns of my excel sheet. This would have Column A with a unique set, Columb B with another unique set, and so on until 50 columns have been filled.
I am struggling when creating the for loop to offset each permutation. Any suggestions?
  1 个评论
Joseph Cheng
Joseph Cheng 2021-6-1
can you explain repetition in a row as you only have numbers 1 to 32 but 50 columns. you've got to repeate some where in the rows as you don't have enough unique numbers to populate 1 row to get to 50.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

David Hill
David Hill 2021-6-1
for k=1:50
p(:,k)=randperm(32)';
end

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by