Linking two sets of data to be in line with eachother

Question

Cameron Hudspith 2023-10-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2033949-linking-two-sets-of-data-to-be-in-line-with-eachother

回答： Cameron Hudspith 2023-10-16

Hey, I have two tables, each with a column for load and position. I'm hoping to use one set of load data, to search the other table for the nearest load value and extract it's relative position. I would then subtract that position from the original tables position (likely into a new array).

I believe this should be done with indexing, but I'm pretty confused on the subject (especially considering the load values aren't exactly equal, I just need to index to the cloest value)

Any tips would be helpful!

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

请先登录，再进行评论。

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

Answer 1

Cameron Hudspith 2023-10-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2033949-linking-two-sets-of-data-to-be-in-line-with-eachother#answer_1333809

The following function is the solution to my problem. I was able to put it into a loop to apply the result to every row of my dataset. Thanks to everyone who helped.

[~,idx] = min(abs(PressingPlate_FP{:,"LoadN"}-Control_FP{i,"LoadN"}));

result = PressingPlate_FP{idx, "Positionmm"};

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

请先登录，再进行评论。

Answer 2

Walter Roberson 2023-10-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2033949-linking-two-sets-of-data-to-be-in-line-with-eachother#answer_1333729

在 MATLAB Online 中打开

Perhaps

idx = interp1(loadValues1, 1:numel(loadValues1), loadValues2, 'nearest')

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Cameron Hudspith 2023-10-16

在 MATLAB Online 中打开

I believe that is on the right track, but I can't get the function to work

i=1; 
idx = interp1(PressingPlate_FP(:,"LoadN"), PressingPlate_FP(:,"Positionmm"), Control_FP{i,"LoadN"}, 'nearest');

In that code I'm hoping interp1 will search the load column of the PressingPlate_FP table for the nearest value to Control_FP{i,"LoadN"}, then return The value of the position column of PressingPlate_FP directly next to the load value

The function is currently giving me an error

请先登录，再进行评论。