how can I match 2 columns, which one is the guide column with all daily data from 2000-2010 and the other has some missing values among its rows, then I need to put NAN for the missing values?
MATLAB: How can I match 2 columns, which one is the guide column with all daily data from 2000-2010 and the other has some missing values among its rows, then I need to put NAN for the missing values
Related Solutions
Compute start and stop indices for NaN segments in height variable (column vector).
nanStartIdx = find(diff(isnan([0;height;0]))==1);nanStopIdx = find(diff(isnan([0;height;0]))==-1);Show the results.
% Show index of NaN values
ax = cla(); plot(isnan(height), '-k', 'LineWidth', 2)ylim([-.2, 1.5])xlabel('index')ylabel('is NaN')set(ax, 'YTick', [0,1], 'YTickLabel', {'False', 'True'})hold onarrayfun(@(start)xline(start, 'b-','Start'), nanStartIdx)arrayfun(@(stop)xline(stop, 'c-','Stop'), nanStopIdx)
Insert NaN in place of the missing data in your dependent variable ‘y’ vector. Be sure that the lengths of your x and y vectors are the same.
Best Answer