How can I replace matrix with random generated number (int) and position?
2 views (last 30 days)
Show older comments
Hello,
I'am trying to combine 2 matrix, I have 1 matrix with fix number, column, and rows. The other one consist of 2 column matrix with random rows (this matrix more little than matrix 1) and I have to generate it first, randomly. For the example is :
matrix 1 : X Y Z
1 0.0 2
2 0.0 5
3 0.0 1
4 0.0 3
5 0.0 0
matrix 2 : A B
1 0
2 8
4 6
Based on the example, column A used to replace column X and column B used to replace column Z. The value of column A show us where to replace the value of column B in Z.
- When the value of A is 2, then the value of Z in row 2 which is '5' replace by '8' as the value of B.
- When the value of A is 4, then the value of Z in row 4 which is '3' replace by '6' as the value of B.
- But there is an exception, the value of column Z row 1 should not be changed, so when the generated value of A is 1, the value of Z in row 1 which is '2' should not replace by the value of column B and still worth '2'.
- This program will loop with 100 of maximum iterations, and in every iteration, matrix 2 will generated randomly.
Does anyone have the solution..?
Thanks.
2 Comments
Walter Roberson
on 21 Jan 2013
In Matrix 2, can there be multiple rows with the same A but different B?
Accepted Answer
Andrei Bobrov
on 21 Jan 2013
eg
A = [(1:20)', zeros(20,1), randi([0 20],20,1)];
for jj = 1:100
n = rand(20,1) > rand(); %
B0 = randi([0 10],nnz(n),1); % random generation of the matrix 2 (B)
B = [A(n,1), B0]; %
t = B(:,1) > 1;
A(ismember(A(:,1),B(t,1)),3) = B(t,2);
end
More Answers (0)
See Also
Categories
Find more on Creating and Concatenating Matrices in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!