equivalence of the codes that can be used for erasing the first row of R if cell R(1,3) is occupied by NaN?
信息
此问题已关闭。 请重新打开它进行编辑或回答。
显示 更早的评论
Dear all,
Could you please verify the equivalence of the codes that can be used for erasing the first row of R if cell R(1,3) is occupied by NaN?
Code 1:
[N,T,R] = xlsread(xlfilename);
if isnan(cell2mat(R(1,3)))
R(1,:)=[];
End
Code 2
TT = cellfun( @isnan, R(1,3), ‘UniformOuput’, true);
R( ( TT,1), : ) = [] ;
0 个评论
回答（1 个）
F.
2012-7-5
I'm sorry but I don't understand what you are looking for. Code 2 is the code that I gave you http://www.mathworks.fr/matlabcentral/answers/42710-problem-with-xlsread-bizarre-results
R is the raw output of the xlsread function. In each cell, there is a numeric or a string. So R(1,3) is a cell, and you are checking one value to erase the column of your cell array. In code 2 you are using a command (cellfun)used to manage cell arrays just for one cell, and after, you don't use TT !!
*for erasing the first row of R if cell R(1,3) is occupied by NaN *
if all(isnan( R{1,3} ))
R(1,:) = []
end
1 个评论
Sabbas
2012-7-5
此问题已关闭。
关闭：
2021-8-20
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
