Deleting missing values (different amount and distribution of NaNs for each column)
조회 수: 1 (최근 30일)
이전 댓글 표시
I have two matrices of the same size (17x82). Matrix A has no missing values. Matrix B has a different amount and distribution of NaNs for each column. I want to delete all missing values from matrix B as well as the values of matrix A that correspond to the NaNs of matrix B.
I tried: A_Without_NaN = A(~isnan(B)); However, reshaping does not work because the number of NaNs in matrix B varies for each column.
Any suggestions? Thanks in advance, Peter
댓글 수: 0
채택된 답변
Jos (10584)
2017년 12월 20일
You cannot concatenate different length vectors into a single matrix. You could store each column of A into a separate cell
A_wn = arrayfun(@(k) A(~isnan(B(:,k)),k),1:size(A,2),'un',0)
% A_wn is a cell array. The k-th cell, A_wn{k}, holds the
% 'relevant' values of the k-th column of A
However, it might be preferred to leave the nans and use nan-specific functions like nansum and nanmean.
댓글 수: 2
Steven Lord
2017년 12월 20일
If you're using release R2015a or later, you can call sum and mean with the 'omitnan' parameter instead of calling nansum or nanmean. See the second item in the Mathematics section of the Release Notes for R2015a.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Logical에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!