selecting rows from C with associated values in D, while using A and B values as references to produce E and F matrices

Question

JL 2019-9-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480355-selecting-rows-from-c-with-associated-values-in-d-while-using-a-and-b-values-as-references-to-produ

编辑： per isakson 2019-9-15

Hi everyone, I have 2 matrices, A and B, that I want to use as reference to draw out certain rows in C and attached associated values from D.

A = [1 2];
B = [1 3];
C = [  1	19	18	4	3	0	0	0	0	0	0  
       1	19	2	17	6	7	5	4	3	2	0
       1	16	15	17	6	7	5	4	3	2	0
       1	19	2	3	0	0	0	0	0	0	0
       1	16	15	14	9	8	7	5	4	3	2
       1	16	15	14	9	6	5	4	3	2	0
       1	2	3	0	0	0	0	0	0	0	0
];
D = [0.1
     0.3
     0.4
     0.8
     0.9
     0.11
     0.2
     ];

my end results for E and F should be:

E = [0.1     1	19	18	4	3	0	0	0	0	0	0
     0.8     1	19	2	3	0	0	0	0	0	0	0
     0.2     1	2	3	0	0	0	0	0	0	0	0    
    ];
F = [0.3     1	19	2	17	6	7	5	4	3	2	0
     0.4     1	16	15	17	6	7	5	4	3	2	0
     0.9     1	16	15	14	9	8	7	5	4	3	2
     0.11    1	16	15	14	9	6	5	4	3	2	0
    ];

2 个评论
显示无隐藏无

madhan ravi 2019-9-14

Difficult to understand , illustrate with a short example.

JL 2019-9-14

编辑：JL 2019-9-14

Hi Madhan, so basically, put them on E and F based on their first and last number (ignore zero in each rows). For examples, for [1 3], I select the rows in C to put in E with a row starting with 1 and ending with 3 (like I said, ignore zeros)

请先登录，再进行评论。

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

Answer 1

Bruno Luong 2019-9-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480355-selecting-rows-from-c-with-associated-values-in-d-while-using-a-and-b-values-as-references-to-produ#answer_391834

编辑：Bruno Luong 2019-9-14

在 MATLAB Online 中打开

A = [1 2];
B = [1 3];
C = [  1	19	18	4	3	0	0	0	0	0	0;
       1	19	2	17	6	7	5	4	3	2	0;
       1	16	15	17	6	7	5	4	3	2	0;
       1	19	2	3	0	0	0	0	0	0	0;
       1	16	15	14	9	8	7	5	4	3	2;
       1	16	15	14	9	6	5	4	3	2	0;
       1	2	3	0	0	0	0	0	0	0	0
    ];
D = [0.1;
    0.3;
    0.4;
    0.8;
    0.9;
    0.11;
    0.2
    ];
[i,j] = find(C);
getC = @(pickfun) C(sub2ind(size(C),(1:size(C,1))',accumarray(i(:),j(:),[],pickfun)));
filtFun = @(x) ismember([getC(@min),getC(@max)],x,'rows');
b = filtFun(B);
E = [D(b,:),C(b,:)]
b = filtFun(A);
F = [D(b,:),C(b,:)]

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

JL 2019-9-14

Thanks Bruno! That was really helpful :)

请先登录，再进行评论。

Answer 2

per isakson 2019-9-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480355-selecting-rows-from-c-with-associated-values-in-d-while-using-a-and-b-values-as-references-to-produ#answer_391833

编辑：per isakson 2019-9-15

在 MATLAB Online 中打开

The script

%%
ixe = [1,4,7];
E = cat( 2, D(ixe), C(ixe,:) );
ixf = setdiff( [1:7], ixe );
F = cat( 2, D(ixf), C(ixf,:) );

calculates E and F that agrees with your sample.

However, I cannot see how the rows 1, 4 and 7, honors the rules you provide in your comment.

In response to comment

ixe = find_rows( C, B ); 
E = cat( 2, D(ixe), C(ixe,:) );
ixf = find_rows( C, A ); 
F = cat( 2, D(ixf), C(ixf,:) );
%
function    ix_rows = find_rows( C, FL );
    ix_rows = nan( 1, size(C,1) );
    for jj = 1 : size( C, 1 )
        row = C(jj,:);
        row(row==0) = [];
        if row(1)==FL(1) && row(end)==FL(2)
            ix_rows(jj) = jj;
        end
    end
   ix_rows( isnan( ix_rows ) ) = [];
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

JL 2019-9-14

Hi isakson, can it select automatically rather than selecting 1 4 7 to put to E then putting the rest in F? The reason being, I have 3000 over rows and they are not just for E and F.

请先登录，再进行评论。