if column 1 is nan, make corresponding number in column2 nan

Question

C.G. 2022-9-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1815120-if-column-1-is-nan-make-corresponding-number-in-column2-nan

编辑： Cel Kulasekaran 2022-9-30

I have the code below which randomly assigns 10% of the dataset to Nan. However this only turns column 1 to NaN. How can I make the corresponding number in column 2 also NaN?

Period = [1:1:100]';
F = [201:1:300]';
A=[Period F]; % a random matrix
Data = A;
percent_miss = 0.1;
nTime = length(Period);
Data(randperm(nTime,round(nTime*percent_miss))) = NaN;

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

请先登录，再进行评论。

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

Answer 1

Cel Kulasekaran 2022-9-30

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1815120-if-column-1-is-nan-make-corresponding-number-in-column2-nan#answer_1064075

编辑：Cel Kulasekaran 2022-9-30

在 MATLAB Online 中打开

Re-writing your code, with suggestion:

Period = 1:100;
F = 201:300;
A = [Period', F']; % a random matrix
Data = A;
percent_miss = 0.1;
nTime = length(Period);
% adding this step for illustrative clarity
updateRows2NaN = randperm(nTime,round(nTime*percent_miss));
% you will want to apply this row-wise operation (i.e. across all columns)
Data(updateRows2NaN, :) = nan;

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

请先登录，再进行评论。

Answer 2

Kevin Holly 2022-9-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1815120-if-column-1-is-nan-make-corresponding-number-in-column2-nan#answer_1064060

在 MATLAB Online 中打开

Period = [1:1:100]';
F = [201:1:300]';
A=[Period F]; % a random matrix
Data = A;
percent_miss = 0.1;
nTime = length(Period);
Data(randperm(nTime,round(nTime*percent_miss))) = NaN;
LogicalofNans = isnan(Data(:,1));
Data(LogicalofNans,2)=nan;