Loop For extract maximum rows of matrix based on vectors

1 次查看(过去 30 天)
I have this data , Consist of 3 vectors, i want to create a Loop for 1:5: size(data) , to extract rows that have maximum value for vector 2 (colomn number 2)
1 3 4
1 5 4
1 6 4
1 2 4
1 1 4
2 4 4
2 4 4
2 4 4
2 4 4
2 5 4
1 1 4
1 1 4
1 2 4
1 3 4
1 5 4
2 5 4
2 5 4
2 5 4
2 5 4
2 6 4
The result will be
1 6 4
2 5 4
1 5 4
2 6 4
  1 个评论
Walter Roberson
Walter Roberson 2022-12-7
Is the rule that you want to find the maximum for each group of lines that has the same value in the first column? Even if the third column is different? Or should it be groups of lines that have the same first and third column ?

请先登录,再进行评论。

采纳的回答

Voss
Voss 2022-12-7
data = [
1 3 4
1 5 4
1 6 4
1 2 4
1 1 4
2 4 4
2 4 4
2 4 4
2 4 4
2 5 4
1 1 4
1 1 4
1 2 4
1 3 4
1 5 4
2 5 4
2 5 4
2 5 4
2 5 4
2 6 4
];
[n_rows,n_cols] = size(data);
assert(mod(n_rows,5) == 0)
result = zeros(n_rows/5,n_cols);
for ii = 1:5:n_rows-4
temp_data = data(ii+(0:4),:);
[~,idx] = max(temp_data(:,2));
result((ii-1)/5+1,:) = temp_data(idx,:);
end
disp(result);
1 6 4 2 5 4 1 5 4 2 6 4

更多回答(1 个)

Fangjun Jiang
Fangjun Jiang 2022-12-7
a=[1 3 4
1 5 4
1 6 4
1 2 4
1 1 4
2 4 4
2 4 4
2 4 4
2 4 4
2 5 4
1 1 4
1 1 4
1 2 4
1 3 4
1 5 4
2 5 4
2 5 4
2 5 4
2 5 4
2 6 4];
b=reshape(a',3,5,[])
b =
b(:,:,1) = 1 1 1 1 1 3 5 6 2 1 4 4 4 4 4 b(:,:,2) = 2 2 2 2 2 4 4 4 4 5 4 4 4 4 4 b(:,:,3) = 1 1 1 1 1 1 1 2 3 5 4 4 4 4 4 b(:,:,4) = 2 2 2 2 2 5 5 5 5 6 4 4 4 4 4
c=transpose(squeeze(max(b,[],2)))
c = 4×3
1 6 4 2 5 4 1 5 4 2 6 4

类别

Help CenterFile Exchange 中查找有关 Automated Driving Toolbox 的更多信息

产品

Community Treasure Hunt

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

Start Hunting!

Translated by