How can I change rows that appeared more than once to missing rows

1 次查看（过去 30 天）
TTA
TTA 2022-9-23
评论： dpb 2022-9-24
Please I need a help!!
I have the set of vectors below. In the second column, 5.0000 and 6.0000 appeared twice, and between 9.0000 and 12.0000, 10.0000 and 11.0000 are missing.
Please how can I change the rows with 5.0000 and 6.0000 to 10.0000 and 11.0000 that are missing and sort the second column in ascending with respect to their corresponding rows.
Please, I need a solution that is applicable to related problems.
2005.00 1.00000 0.000000 0.000000 0.000000
2005.00 2.00000 0.000000 0.000000 0.000000
2005.00 3.00000 0.000000 0.000000 0.000000
2005.00 4.00000 0.000000 0.000000 0.000000
2005.00 5.00000 0.000000 0.000000 0.000000
2005.00 6.00000 0.000000 0.000000 0.000000
2005.00 5.00000 56.0000 4464.00 1.25448
2005.00 6.00000 2937.00 4320.00 67.9861
2005.00 7.00000 2974.00 4464.00 66.6219
2005.00 8.00000 2097.00 4464.00 46.9758
2005.00 9.00000 797.000 4320.00 18.4491
2005.00 12.0000 191.000 4464.00 4.27867
This is my desired output
2005.00 1.00000 0.000000 0.000000 0.000000
2005.00 2.00000 0.000000 0.000000 0.000000
2005.00 3.00000 0.000000 0.000000 0.000000
2005.00 4.00000 0.000000 0.000000 0.000000
2005.00 5.00000 56.0000 4464.00 1.25448
2005.00 6.00000 2937.00 4320.00 67.9861
2005.00 7.00000 2974.00 4464.00 66.6219
2005.00 8.00000 2097.00 4464.00 46.9758
2005.00 9.00000 797.000 4320.00 18.4491
2005.00 10.00000 0.000000 0.000000 0.000000
2005.00 11.00000 0.000000 0.000000 0.000000
2005.00 12.0000 191.000 4464.00 4.27867
Thank you in advance.
  3 个评论
显示 1更早的评论
TTA
TTA 2022-9-23
编辑：TTA 2022-9-23
Thank you very much. But I am looking for a solution where the duplicate and the missing values in column 2 are not known. It can just be any case. for example,
Below is another case
2022.00 1.00000 0.000000 0.000000 0.000000
2022.00 2.00000 0.000000 0.000000 0.000000
2022.00 3.00000 0.000000 0.000000 0.000000
2022.00 1.00000 4435.00 4464.00 99.3504
2022.00 2.00000 3718.00 4032.00 92.2123
2022.00 3.00000 4073.00 4464.00 91.2410
2022.00 4.00000 4073.00 4320.00 94.2824
2022.00 5.00000 3776.00 4464.00 84.5878
2022.00 6.00000 2714.00 4320.00 62.8241
2022.00 7.00000 608.000 4464.00 13.6201
2022.00 8.00000 3367.00 4464.00 75.4256
2022.00 9.00000 1872.00 4320.00 43.3333
and this is what I expected to have
2022.00 1.00000 4435.00 4464.00 99.3504
2022.00 2.00000 3718.00 4032.00 92.2123
2022.00 3.00000 4073.00 4464.00 91.2410
2022.00 4.00000 4073.00 4320.00 94.2824
2022.00 5.00000 3776.00 4464.00 84.5878
2022.00 6.00000 2714.00 4320.00 62.8241
2022.00 7.00000 608.000 4464.00 13.6201
2022.00 8.00000 3367.00 4464.00 75.4256
2022.00 9.00000 1872.00 4320.00 43.3333
2022.00 10.00000 0.000000 0.000000 0.000000
2022.00 11.00000 0.000000 0.000000 0.000000
2022.00 12.00000 0.000000 0.000000 0.000000
Do you understand?
Dyuman Joshi
Dyuman Joshi 2022-9-23
In this case, all empty rows are sent to the bottom, however in the earlier example there was still a row after them.
Please clarify this ambiguity and say what exactly do you want to do with the empty rows.

请先登录，再进行评论。

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

采纳的回答

dpb
dpb 2022-9-23
编辑：dpb 2022-9-23
Ran in:
A=[
2005.00 1.00000 0.000000 0.000000 0.000000
2005.00 2.00000 0.000000 0.000000 0.000000
2005.00 3.00000 0.000000 0.000000 0.000000
2005.00 4.00000 0.000000 0.000000 0.000000
2005.00 5.00000 0.000000 0.000000 0.000000
2005.00 6.00000 0.000000 0.000000 0.000000
2005.00 5.00000 56.0000 4464.00 1.25448
2005.00 6.00000 2937.00 4320.00 67.9861
2005.00 7.00000 2974.00 4464.00 66.6219
2005.00 8.00000 2097.00 4464.00 46.9758
2005.00 9.00000 797.000 4320.00 18.4491
2005.00 12.0000 191.000 4464.00 4.27867];
% engine
d=setdiff([1:size(A,1)].',A(:,2));
n=histc(A(:,2),unique(A(:,2)));
A(n>1,2)=d;
A=sortrows(A,[1:2]);
format bank % to prettify output only
disp(A)
2005.00 1.00 0 0 0 2005.00 2.00 0 0 0 2005.00 3.00 0 0 0 2005.00 4.00 0 0 0 2005.00 5.00 56.00 4464.00 1.25 2005.00 6.00 2937.00 4320.00 67.99 2005.00 7.00 2974.00 4464.00 66.62 2005.00 8.00 2097.00 4464.00 46.98 2005.00 9.00 797.00 4320.00 18.45 2005.00 10.00 0 0 0 2005.00 11.00 0 0 0 2005.00 12.00 191.00 4464.00 4.28

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by