Creating a new table column that is the range of numbersbetween two other column

14 次查看（过去 30 天）

OriF 2021-10-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573863-creating-a-new-table-column-that-is-the-range-of-numbersbetween-two-other-column

评论： Rik 2021-11-2

Hi,

I'm trying to add a new column to a table, that each row is the range between two numbers corresponding to two other existing columns.

Somthing like this:

K>> RESULTS_T

RESULTS_T =

2091×4 table

y_tl x_tl y_br x_br

____ ____ ____ ____

54 119 60 129

177 119 183 129

300 119 306 129

423 119 429 129

546 119 552 129

669 119 675 129

792 119 798 129

#########################################

y_range

y_tl : y_br

#########################################

I manage to do so only for a single row:

K>> {RESULTS_T{:,1} : RESULTS_T{:,3}}

ans =

1×1 cell array

{[54 55 56 57 58 59 60]}

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

请先登录，再进行评论。

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

回答（1 个）

Rik 2021-10-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573863-creating-a-new-table-column-that-is-the-range-of-numbersbetween-two-other-column#answer_818913

在 MATLAB Online 中打开

You can either use a loop, or hide the loop with rowfun:

data=[54     119      60       129
     177     119     183     129
     300     119     306     129
     423     119     429     129
     546     119     552     129
     669     119     675     129
     792     119     798     129];
ytl=data(:,1);
ybr=data(:,3);
RESULTS_T =table(ytl,ybr);
[RESULTS_T rowfun(@(ytl,ybr)ytl:ybr,RESULTS_T,'OutputVariableNames','range') ]
ans = 7×3 table
    ytl    ybr      range   
    ___    ___    __________

     54     60    1×7 double
    177    183    1×7 double
    300    306    1×7 double
    423    429    1×7 double
    546    552    1×7 double
    669    675    1×7 double
    792    798    1×7 double