I need to create an N x 4 table array that where each column contains random integers between 1 and M. However the number of times each of the random number repeats in a single column cannot exceed a specific number P and must also not equal the value in the preceeding column.
Here is some code setting up the first two columns.
c1 = {'A';'B';'C';'D';...
c2 = [1;3;2;4;3;4;1;4;3;1;2;3;1];
disp(table(c1,c2,'VariableNames',{'Names','Arbitrary'}))
Names Arbitrary
_____ _________
{'A'} 1
{'B'} 3
{'C'} 2
{'D'} 4
{'E'} 3
{'F'} 4
{'G'} 1
{'H'} 4
{'I'} 3
{'J'} 1
{'K'} 2
{'L'} 3
{'M'} 1
Notice, I chose the numbers between 1 and 4 (M = 4) arbitrarily for the second column. This means ...
- P = 4 for 1.
- P = 3 for 2.
- P = 4 for 3.
- P = 3 for 4.
To make things easier, I want to maintain this arrangement of P for each integer in the next column.
I think this question helps me generate the random numbers in the third column, but I am not sure how to make sure there are P = 4 1's, P = 3 2's etc. disp(table(c1,c2,c3,'VariableNames',...
{'Names','Arbitrary','Third Column'}))
Names Arbitrary Third Column
_____ _________ ____________
{'A'} 1 2
{'B'} 3 1
{'C'} 2 1
{'D'} 4 3
{'E'} 3 1
{'F'} 4 3
{'G'} 1 4
{'H'} 4 3
{'I'} 3 4
{'J'} 1 2
{'K'} 2 3
{'L'} 3 1
{'M'} 1 4
So now I have the third column of random integers between 1 and M excluding c2(i) for every name, but I have no idea how to make sure the number of each integer follows the criteria set apart. The same problem will persist when I make the fourth column where the value cannot equal that in c3(i).
Aside from generating the random numbers, I'm stuck.
