Changing a a value in table column dependent on another column.

Question

Mirthand 2021-4-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/802616-changing-a-a-value-in-table-column-dependent-on-another-column

编辑： SungJun Cho 2021-4-15

In the table I would like column e to replace the the first two 78 with 1. The 1 value should match with column d and the 2 value.

e = [ 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 78 78 78 78 78 78 78 78 78 78]
e = e'
d = [ 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 56 56 56 56 56 56 56]
d = d'
tableh = table(e, d)
OUTPUT for current Table:
tableh =
  25×2 table
    e     d 
    __    __
   2
   2
   2
   2
   2
   2
   2
   2
   2
   2
   2
   2
   2
   2
   2
   2
   2
   2
  56
  56
  56
  56
  56
  56
  56

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

SungJun Cho 2021-4-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/802616-changing-a-a-value-in-table-column-dependent-on-another-column#answer_675551

编辑：SungJun Cho 2021-4-15

在 MATLAB Online 中打开

You can just do

e = [ 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 78 78 78 78 78 78 78 78 78 78];
e = e';
d = [ 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 56 56 56 56 56 56 56];
d = d';
e(d==2) = 1;
tableh = table(e,d);

to have value 1 in e whenever you have value 2 in d.