Compare two row and select appropriate data

42 次查看（过去 30 天）
TW
TW 2025-9-10
编辑： Matt J 2025-9-10
I have two columns. Let's call them column a and column b.
I want to do a check where:
if row 1 of column a > row 1 of column b, use row 1 of column a. Else, use row 1 of column b.
I have tried
if Column a > Column b
Column c = column b
else
Column c = column a
end
However, when I check the data, I find out some of the function isn't working and it just pulls all the data from column a into column c.
Basically column b is the "cap." And no number in column c should be greater than that. If any numbers in column a is greater than column b, column b should be used.

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

采纳的回答

TW
TW 2025-9-10
The function I ultimately used was:
c=min(a,b)
Thanks @Matt J for pointing me in the right direction, though.
  2 个评论
Matt J
Matt J 2025-9-10
编辑：Matt J 2025-9-10
But that does not match the requirements in your question. "if row 1 of column a > row 1 of column b, use row 1 of column a"
TW
TW 2025-9-10
Sorry my bad. Flipped the two. I wanted b to be the "cap."

请先登录，再进行评论。

更多回答（3 个）

Matt J
Matt J 2025-9-10
c=max(a,b)
  3 个评论
显示 1更早的评论
TW
TW 2025-9-10
Yuppa. But I think I wanted the "min" variable, not max.

请先登录，再进行评论。

Matt J
Matt J 2025-9-10
编辑：Matt J 2025-9-10
Ran in:
Basically column b is the "cap."
If so, one could also do,
a=[1;2;3;4]; b=[1;1;3;3];
c=clip(a,-inf,b)
c = 4×1
1 1 3 3
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
  2 个评论
TW
TW 2025-9-10
What's the difference between clip and min?
Matt J
Matt J 2025-9-10
编辑：Matt J 2025-9-10
In this case, there is no difference, but if you later decided you wanted both lower and upper thresholds, clip() will do that.
c = clip(a,lower,upper)

请先登录，再进行评论。

Star Strider
Star Strider 2025-9-10
Ran in:
I believe you want the minimum of the two columns.
Try this --
Data = array2table(randi(9, 10, 2), VariableNames=["A","B"])
Data = 10×2 table
A B _ _ 2 4 4 2 3 4 4 2 4 9 6 1 6 2 7 6 2 4 7 5
[C,idx] = min([Data.A, Data.B],[],2);
Data.C = C
Data = 10×3 table
A B C _ _ _ 2 4 2 4 2 2 3 4 3 4 2 2 4 9 4 6 1 1 6 2 2 7 6 6 2 4 2 7 5 5
OriginalColumn = idx
OriginalColumn = 10×1
1 2 1 2 1 2 2 2 1 2
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
The 'idx' output is the column chosen to be Column 'C'.
.

类别

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

标签

产品


版本

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by