Input data, round down, loop variable

Question

GH 2020-5-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/535023-input-data-round-down-loop-variable

评论： GH 2020-5-27

Hi everyone, I have lots of data in an excel file with 59 rows and 4 colums, every row's data belong together(let's say I have 'x', 'z', 'R', 'y'). I have two problems:

a) One of the variable (let's say 'y') should be an input value by the user, then the program should find in which domain (which are the those two values from the y column in between this input takes place) then choose the lower one and use that in the equation.

b) After the matlab have chosen the proper value, the loop should use its row's data (x,y,z,R) in a 4 variable equation to get the result.

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

请先登录，再进行评论。

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

Answer 1

Tommy 2020-5-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/535023-input-data-round-down-loop-variable#answer_439938

在 MATLAB Online 中打开

How does this work? (I'm assuming T.y is monotonically increasing)

% example table:
x = randi(10,59,1);
y = cumsum(rand(59,1));
z = randi([10 20],59,1);
R = randi([2 3],59,1);
T = table(x, y, z, R);
% example user input:
yin = range(T.y)*rand + min(T.y);
%---------------------------------
% location of row of interest:
idx = find(yin > T.y, 1, 'last');
% row of interest:
vars = T{idx,:};
% vars is a 1x4 array containing the x, y, z, and R to use in your equation