Deleting the same column in different matrices

1 view (last 30 days)
Hello everyone,
i' ve got the following problem. I have a matrix A with 256x7690 where a lot of columns containing just NaN's. For that reason I want to delete these columns as a first step. In a second step it should further delete the same column number in some other matrices (which have the same number of columns). So for example the 4th and the 29th column contain all NaN's it should delete these two columns and delete the same columns in Matrices B,C,D and E. Note, that I have about 3500 columns which contains all NaN's.
Thanks in Advance.

Accepted Answer

KSSV
KSSV on 15 Mar 2017
You can remove 4th column from a matrix A using
A(:,4) = [] ;
Similarly for other matrices...To get the position of NaN's use isnan.
  2 Comments
Jan
Jan on 15 Mar 2017
And explicitly:
Index = all(isnan(A, 1)); % Find columns which are all NaN
A(:, Index) = [];
B(:, Index) = [];
C(:, Index) = [];
...

Sign in to comment.

More Answers (0)

Categories

Find more on Resizing and Reshaping 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!