How can I match values using a 'translation array' without looping

1 次查看（过去 30 天）
Clemens Gersch
Clemens Gersch 2019-12-3
评论： Clemens Gersch 2019-12-3
Assume, you have a table with n observations for which something is measured, e.g. only the week in which they were observed. Then, there is some matrix, that I would describe as a translation or mapping array. In the first column it has week values and in the second it has average temperatures or something. The following code should illustrate that:
dataset = table([1:100]', randi([1,52],100,1), 'VariableNames', ["ID", "week"])
translation = [[1:52]', randi([-10,40],52,1)]
How can I make a third column in dataset that gives me correctly assigned temperature of the week of the observation without using any kind of loop?
It should be some very efficient function or way of indexing as I am having a very large dataset. Right now, I am using some containers.Map object in a for loop which is endlessly slow.

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

采纳的回答

JESUS DAVID ARIZA ROYETH
solution:
dataset = table([1:100]', randi([1,52],100,1), 'VariableNames', ["ID", "week"]);
dataset=[dataset table(nan(size(dataset,1),1),'VariableNames',"mean")];
translation = [[1:52]', randi([-10,40],52,1)];
[d,x]=ismember(dataset{:,1}',translation(:,1)');
idx=x(x>0);
dataset{d,3}=translation(idx,2)
  3 个评论
显示 1更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by