Finding the Closest Value to an Input Value from a Table Column

Question

Jake Bowd 2020-7-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/567792-finding-the-closest-value-to-an-input-value-from-a-table-column

评论： Cris LaPierre 2020-7-20

Example_MATLAB_IMAGE.jpg

I have the below code that finds a value that is less than or equal to RESULTS.Vertical_Heel_Trajectory_at_HS1(1,1) in the following table column RESULTS.Inverse_Kinematics_Tables{1,1}.(ab{1,1} and names it RESULTS.Second_HS_Thresholding.

The issue I have is that values are sometimes not always less than or equal to, but is very close. I would therefore like to change the code so that it picks up the closest value to RESULTS.Vertical_Heel_Trajectory_at_HS1(1,1) value.

I have also attached a figure to illustrate this point further.

RESULTS.Second_HS_Thresholding= find(any(RESULTS.Inverse_Kinematics_Tables{1,1}.(ab{1,1})<= RESULTS.Vertical_Heel_Trajectory_at_HS1(1,1),2));

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

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2020-7-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/567792-finding-the-closest-value-to-an-input-value-from-a-table-column#answer_468246

编辑：Cris LaPierre 2020-7-20

在 MATLAB Online 中打开

Find the minimum of the absolute value of the difference.

[val,idx] = min(abs(x-y))

You can read more about what the outputs are here.

2 个评论
显示无隐藏无

Jake Bowd 2020-7-20

Thanks, Cris.

I have now spent some time reading the documentation on Min. It would appear it is the right approach to take, although not using the 'abs' function.

However, I cannot find a way to put a condition into the equation such that the following finds the minimum value after a specified row number, for example row 40.

[val,idx] = min(x);

Cris LaPierre 2020-7-20

在 MATLAB Online 中打开

You will need to use abs if you want the closest value - above or below the threshold. If you only want to find a subset of data (a new requirement not mentioned in your OP), you need to pass in the subset of data to min.

[val,idx] = min(x(40:end));

请先登录，再进行评论。