Loop to replace a NaN matrix with specific data from another matrix

Question

Francis Trombini 2021-5-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/837763-loop-to-replace-a-nan-matrix-with-specific-data-from-another-matrix

评论： Francis Trombini 2021-5-24

How could I use a loop to replace a NaN matrix (1 line x 30 columns) with specific data from another matrix? My interest is to replace the values of the matrix 'CI_mean_X_ForStatistic_VarNames' with the values of the matrix 'CI_mean_X_VarNames', skipping 10 columns each time in the loop. Thanks in advance for the help.

This my long code.

CI_mean_X_ForStatistic_VarNames_NaN = NaN(1,30); % first, creating a NaN matrix (1 line x 30 columns) to insert the variable names sorted regarding the scale factor order of each condition, side by side. 
CI_mean_X_ForStatistic_VarNames = num2cell(CI_mean_X_ForStatistic_VarNames_NaN);
CI_mean_X_ForStatistic_VarNames(:,1) = CI_mean_X_VarNames (:,1);
CI_mean_X_ForStatistic_VarNames(:,2) = CI_mean_X_VarNames (:,11);
CI_mean_X_ForStatistic_VarNames(:,3) = CI_mean_X_VarNames (:,21);
CI_mean_X_ForStatistic_VarNames(:,4) = CI_mean_X_VarNames (:,2);
CI_mean_X_ForStatistic_VarNames(:,5) = CI_mean_X_VarNames (:,12);
CI_mean_X_ForStatistic_VarNames(:,6) = CI_mean_X_VarNames (:,22);
CI_mean_X_ForStatistic_VarNames(:,7) = CI_mean_X_VarNames (:,3);
CI_mean_X_ForStatistic_VarNames(:,8) = CI_mean_X_VarNames (:,13);
CI_mean_X_ForStatistic_VarNames(:,9) = CI_mean_X_VarNames (:,23);
CI_mean_X_ForStatistic_VarNames(:,10) = CI_mean_X_VarNames (:,4);
CI_mean_X_ForStatistic_VarNames(:,11) = CI_mean_X_VarNames (:,14);
CI_mean_X_ForStatistic_VarNames(:,12) = CI_mean_X_VarNames (:,24);
CI_mean_X_ForStatistic_VarNames(:,13) = CI_mean_X_VarNames (:,5);
CI_mean_X_ForStatistic_VarNames(:,14) = CI_mean_X_VarNames (:,15);
CI_mean_X_ForStatistic_VarNames(:,15) = CI_mean_X_VarNames (:,25);
CI_mean_X_ForStatistic_VarNames(:,16) = CI_mean_X_VarNames (:,6);
CI_mean_X_ForStatistic_VarNames(:,17) = CI_mean_X_VarNames (:,16);
CI_mean_X_ForStatistic_VarNames(:,18) = CI_mean_X_VarNames (:,26);
CI_mean_X_ForStatistic_VarNames(:,19) = CI_mean_X_VarNames (:,7);
CI_mean_X_ForStatistic_VarNames(:,20) = CI_mean_X_VarNames (:,17);
CI_mean_X_ForStatistic_VarNames(:,21) = CI_mean_X_VarNames (:,27);
CI_mean_X_ForStatistic_VarNames(:,22) = CI_mean_X_VarNames (:,8);
CI_mean_X_ForStatistic_VarNames(:,23) = CI_mean_X_VarNames (:,18);
CI_mean_X_ForStatistic_VarNames(:,24) = CI_mean_X_VarNames (:,28);
CI_mean_X_ForStatistic_VarNames(:,25) = CI_mean_X_VarNames (:,9);
CI_mean_X_ForStatistic_VarNames(:,26) = CI_mean_X_VarNames (:,19);
CI_mean_X_ForStatistic_VarNames(:,27) = CI_mean_X_VarNames (:,29);
CI_mean_X_ForStatistic_VarNames(:,28) = CI_mean_X_VarNames (:,10);
CI_mean_X_ForStatistic_VarNames(:,29) = CI_mean_X_VarNames (:,20);
CI_mean_X_ForStatistic_VarNames(:,30) = CI_mean_X_VarNames (:,30);

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-5-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/837763-loop-to-replace-a-nan-matrix-with-specific-data-from-another-matrix#answer_706673

在 MATLAB Online 中打开

%demonstration for tracing
CI_mean_X_VarNames = 1 : 30
CI_mean_X_VarNames = 1×30
     1     2     3     4     5     6     7     8     9    10    11    12    13    14    15    16    17    18    19    20    21    22    23    24    25    26    27    28    29    30
%the work
CI_mean_X_ForStatistic_VarNames = reshape(reshape(CI_mean_X_VarNames, [], 3).', 1, [])
CI_mean_X_ForStatistic_VarNames = 1×30
     1    11    21     2    12    22     3    13    23     4    14    24     5    15    25     6    16    26     7    17    27     8    18    28     9    19    29    10    20    30