Substitue values with text

1 次查看（过去 30 天）
Leonor Vieira Dias
Leonor Vieira Dias 2021-1-29
评论： Leonor Vieira Dias 2021-1-29
Hello,
I have a table of data. I wanted to create a column that would have written "early" or "late" according to the difference between two values.
So far I have been able to differentiate the values to get 1 or 0 whether the condition was met or not. I wanted to have text instead.
Can we subsitute 1 by "late" and 0 by "early"? Is there an easier way to do this, e.g. using if loop?
Many thanks
T.Final = (T.Early<T.Delay)

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

采纳的回答

Iuliu Ardelean
Iuliu Ardelean 2021-1-29
编辑：Iuliu Ardelean 2021-1-29
Maybe this works for you:
early = [10 20 30];
delay = [11 19 31];
final = strings(1, 3); % create an empty string array with 1 line and 3 columns
final(early<delay) = "late";
final(early>=delay) = "early";
  3 个评论
显示 1更早的评论
Leonor Vieira Dias
Leonor Vieira Dias 2021-1-29
I got it, I forgot to put a T in front of it. Thank you very much!

请先登录，再进行评论。

更多回答（1 个）

dpb
dpb 2021-1-29
% create sample data table
T=table(randi([30,70],10,1)+rand(10,1),'VariableNames',{'Early'});
T.Final=T.Early+(randi([-20,20],10,1)+rand(10,1));
% the desired conditional categorical variable
STR=categorical(["Early";"Late"]);
% the engine
T.Final=STR((T.Early<T.Delay)+1);
A given realization of the table data here resulted in:
>> T.Final=STR((T.Early<T.Delay)+1)
T =
10×3 table
Early Delay Final
______ ______ _____
40.327 26.39 Early
68.584 58.236 Early
69.197 75.902 Late
37.909 25.636 Early
36.492 46.388 Late
33.04 35.818 Late
58.207 51.744 Early
69.131 74.646 Late
58.487 69.468 Late
69.074 79.39 Late
>>

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by