清空筛选条件
清空筛选条件

Determine value in the 3rd column of a matrix based on the first and second column values

2 次查看（过去 30 天）
Lars Meijer
Lars Meijer 2024-1-12
评论： Dyuman Joshi 2024-1-15
I have a matrix, say like this:
M = [3 2 10; 4 3 4; 3 1 3; 2 1 12; 2 2 10; 4 1 18; 4 2 12];
Where the order is like this: [job, machine, production_time]
So based on the job and the machine the job should be on, I want to deduce the production time on it.
I can not seem to find anything that can do this for me. Any help is appreciated!

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

采纳的回答

Dyuman Joshi
Dyuman Joshi 2024-1-12
编辑：Dyuman Joshi 2024-1-12
Ran in:
Use ismember -
M = [3 2 10; 4 3 4; 3 1 3; 2 1 12; 2 2 10; 4 1 18; 4 2 12];
job = 3;
machine = 2;
idx = ismember(M(:,1:2), [job machine], 'rows')
idx = 7×1 logical array
1 0 0 0 0 0 0
out = M(idx, 3)
out = 10
If you are working with non-integral values, ismembertol should be preferred instead.
If job and machine contain multiple values, compare them individually and use those indices to get the corresponding values as per requirement.
  3 个评论
显示 1更早的评论

请先登录，再进行评论。

更多回答（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