Filter löschen
Filter löschen

Splitting a matrix in subsets??

1 Ansicht (letzte 30 Tage)
Usman  Ali
Usman Ali am 7 Aug. 2014
Kommentiert: Iain am 11 Aug. 2014
Dear experts, I have a scenario matrix from which I would like to generate a binary tree, the binary tree structure matrix is as follow:
if true
% code
M= [8 25 25 25 25 25;
8 25 36 36 36 36;
8 25 25 15 15 15;
8 25 36 50 50 50;
8 25 25 10 10 10;
8 25 25 6 6 6;
8 25 36 70 70 70;
8 25 25 3 3 3];
end
where 1st and 2nd row are mother scenarios and the rest are the branching scenarios. I would like to seperate this matrix to these two scenario that which rows is a subset of which mother row. so that the end result should be
if true
%
M1 = [8 25 25 25 25 25;
8 25 25 15 15 15;
8 25 25 10 10 10;
8 25 25 6 6 6;
8 25 25 3 3 3];
%
M2 = [8 25 36 36 36 36;
8 25 36 50 50 50;
8 25 36 70 70 70];
end
  2 Kommentare
Geoff Hayes
Geoff Hayes am 7 Aug. 2014
Bearbeitet: Geoff Hayes am 7 Aug. 2014
Usman - in your example, M1 and M2 have three rows in common. How are you determining which row belongs to which mother row?
Usman  Ali
Usman Ali am 11 Aug. 2014
Ohhhh my Bad :( , let me correct it. Actually the M1 includes all the branches of [8 25 25 25 25 25] and M2 includes all the branches connected to [8 25 36 36 36 36].
if true
% code
M1 = [8 25 25 25 25 25; 8 25 25 15 15 15;
8 25 25 10 10 10; 8 25 25 6 6 6;
8 25 25 3 3 3];
%
M2 = [8 25 36 36 36 36; 8 25 36 50 50 50;
8 25 36 70 70 70];
end

Melden Sie sich an, um zu kommentieren.

Antworten (2)

Iain
Iain am 7 Aug. 2014
M = [8 25 25 25 25 25; 8 25 36 36 36 36; 8 25 25 15 15 15;
8 25 36 50 50 50; 8 25 25 10 10 10; 8 25 25 6 6 6;
8 25 36 70 70 70; 8 25 25 3 3 3];
M1 = M(1:2:(end-1),:);
M2 = M(2:2:(end),:);
  5 Kommentare
Usman  Ali
Usman Ali am 7 Aug. 2014
I guess your ans is some what manual. the posted matrix is just an example, in real i have a very big matrix of [7000 x 50]. what if the order of rows is changed that's why I need some automatic solution that should compare the selected rows with mother row and splitt them into different subsets.
Iain
Iain am 11 Aug. 2014
You need some logic that fills in the lists.
If the first list is defined by rows that have 25 in the 3rd column, then the first list is:
list1 = find(M(:,3) == 25);

Melden Sie sich an, um zu kommentieren.


Adam
Adam am 11 Aug. 2014
M1 = M( M(:,3) == 25,:)
M2 = M( M(:,3) == 36,:)
would seem to do the job in that case though that assumes that column 3 contains the value that distinguishes the two branching paths, irrespective of the values in the other columns.

Kategorien

Mehr zu Matrix Indexing finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by