NaN problem with xlsread

Question

Utsav 2016-1-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/265104-nan-problem-with-xlsread

编辑： Utsav 2016-1-25

My code :

          [Day, txt_day, raw_day] = xlsread('file.xlsx',1,'A:A');
          [Paramet, txt1, raw1] = xlsread('file.xlsx',1,'F:F');

file.xlsx has Day in A column, Paramet in F.

For some day in A, some entries in F in NaN.........

I wish to plot(A,Paramet), but Paramet has lesser rows than Day, as NaN's in F are not recognized by xlsread.

I wish to plot all Day of A column, and NaN as blanka at appropriate X values

Any help.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Utsav 2016-1-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/265104-nan-problem-with-xlsread#answer_207350

在 MATLAB Online 中打开

Luckily I got an answer clue in the link http://in.mathworks.com/matlabcentral/answers/8355-check-cell-s-contents-and-convert-to-matrix by Laura Proctor

Idea is to find character assign NaN and replace NaN values to Matrix

 ival = cellfun(@ischar,raw1);
raw1(ival) = {NaN};
Paramet_1 = cell2mat(raw1);
Paramet_2=Paramet_1(2:(numel(Day)+1),:);

Paramet_2 contains my required datasets

Thanks Laura.Thanks Mathworks.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Walter Roberson 2016-1-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/265104-nan-problem-with-xlsread#answer_207349

在 MATLAB Online 中打开

all_day = cell2mat(raw_day);
num_day = length(all_day);
all_Paramet = cell2mat(raw1);
num_Paramet = length(all_Paramet);
if num_Paramet < num_day
  all_Paramet(end+1:num_day) = NaN;
elseif num_day < num_Paramet
  all_day(end+1:num_Paramet) = NaN;
end
plot(all_day, all_Paramet)