Deleting the same column in different matrices
1 view (last 30 days)
Show older comments
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.
0 Comments
Accepted Answer
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
on 15 Mar 2017
And explicitly:
Index = all(isnan(A, 1)); % Find columns which are all NaN
A(:, Index) = [];
B(:, Index) = [];
C(:, Index) = [];
...
More Answers (0)
See Also
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!