removing entire row in cell array if first column is a NaN
4 次查看(过去 30 天)
显示 更早的评论
My data matrix (after reading into matlab with xlsread) contains many rows of string and numerical data, and at the end, there sometimes exists several rows of "NaN"s
I want to delete these specific rows but can't seem to do it properly.
I've tried q=cellfun(@(x) all(isnan(x)),myMatrix); myMatrix(q); but the result is no longer a cell
I've tried findNan=isnan(myMatrix(:,1)) to find the index of the row containing the NaN's to kill it, but it gives an error: ??? Undefined function or method 'isnan' for input arguments of type 'cell'.
Any assistance is appreciated! Thanks :)
2 个评论
Walter Roberson
2012-6-6
xlsread() can return 3 matrices, one for numeric, one for text, one for raw. Which one are you working with? To get the mix of numeric and text you must be working with raw ?
采纳的回答
Walter Roberson
2012-6-6
myMatrix( cellfun( @(C) isnumeric(C) && isnan(C), myMatrix(:,1) ), :) = [];
3 个评论
Walter Roberson
2012-6-6
You have cells that contain strings; strings fail the isnumeric() test, and the && operator does not go on to the second test if the first test fails. isnan() is thus only applied to numeric values, and you only have one numeric value per cell so isnan() will return a scalar value, so you do not need any(). If you left off the isnumeric() test, then isnan() would be applied to the strings; it is well defined on strings but it returns one value per character.
An alternate coding should be
myMatrix( cellfun( @(C) any(isnan(C)), myMatrix(:,1) ), :) = [];
On the other hand, if somehow the matrix could contain other data types in the cells, then the isnumeric() version would be safer. Safer yet would be
myMatrix( cellfun( @(C) isnumeric(C) && any(isnan(C(:))), myMatrix(:,1) ), :) = [];
which allows for the possibility that a numeric array might have slipped in
更多回答(1 个)
the cyclist
2012-6-6
Does this do what you want?
% Some made-up data
c = num2cell([1 1; 2 2; NaN NaN]);
% Find the rows with all NaN
indexToRowToDrop = all(arrayfun(@(x)isnan(x{:}),c),2)
% Drop the bad rows
c(indexToRowToDrop,:) = [];
0 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!