Deleting the column with zero values and corresponding columns from another matrix

Question

Arvind Gauns 2022-7-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1752400-deleting-the-column-with-zero-values-and-corresponding-columns-from-another-matrix

评论： Voss 2022-7-2

I have a 4 datasets with 1044 rows and 55 columns.

in one of the the dataset There are few columns which have negative values. (for any column which have negative values that i dont know)

I want to delete the column with the negative values and correspondingly i want to delete the same columns from the other three datasets.

Kindly suggest me how should i proceed with it.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Voss 2022-7-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1752400-deleting-the-column-with-zero-values-and-corresponding-columns-from-another-matrix#answer_998700

编辑：Voss 2022-7-2

在 MATLAB Online 中打开

% (1) data setup:
% 4 datasets (i.e., matrices) with 1044 rows and 55 columns:
M1 = rand(1044,55);
M2 = rand(1044,55);
M3 = rand(1044,55);
M4 = rand(1044,55);
% in one of the datasets, a few columns have negative values:
M2(:,[10 12 19 21 29]) = -M2(:,[10 12 19 21 29]);
% (2) delete the columns with negative values from all datasets:
% idx is a vector of logicals, saying whether 
% each column in M2 has any negative values:
idx = any(M2 < 0,1);
% delete those columns from all datasets:
M1(:,idx) = [];
M2(:,idx) = [];
M3(:,idx) = [];
M4(:,idx) = [];