MATLAB: NaN problem with xlsread

nanxlsread

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.

Best Answer

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.

Related Solutions

MATLAB: Correlation between two row matrices

Like that, each value of "a" is correlated to each value of "b", but applying the formula of the correlation, the correlation of two single numbers is NaN. To compute the correlation correctly, traspose the input vectors

result  = corr(a', b');

MATLAB: How to write a LOOP for this case

So again, numbered variables and field names are a bad idea. (see here and here) for the related questions). The whole thing would be simpler if the original cell array was used.

If the original cell array had been kept, the code over the 3 questions could be simplified to:

%using original cell array precips
precip_monthly = cell(size(precips));  %preallocate result cell array
for idx = 1:numel(precips)
    if size(precips{idx}, 3) == 365
        month_lengths=[31 28 31 30 31 30 31 31 30 31 30 31];%non-leap year
    else
        month_lengths=[31 29 31 30 31 30 31 31 30 31 30 31];%leap year
    end
    p_month =mat2cell(precips{idx}, size(precips{idx}, 1), size(precips{idx}, 2), month_lengths);%divide into 1 cell per month
    p_month = cellfun(@(x) sum(x, 3, 'omitnan'), p_month, 'UniformOutput', false); %find mean for each month !!THIS CALCULATE THE SUM!!
    precip_monthly{idx} = cell2mat(p_month);%convert back to 3D array
end

Note that you have written a comment that says find mean for each month but you use the sum function. So either the code or the comment is wrong.

Best Answer

Related Solutions

MATLAB: Correlation between two row matrices

MATLAB: How to write a LOOP for this case

Related Question