Finding closest value in data table
13 views (last 30 days)
Show older comments
Seungman Kim
on 8 Dec 2020
Edited: KALYAN ACHARJYA
on 8 Dec 2020
1) I want load large amount of experiment data (distance for x-axis, velocity for y-axis).
2) Find and load the closest to 1m on the x-axis, and also the corresponding the velocity in y-axis.
3) Find and load the closest to 2m on the x-axis, and also the corresponding the velocity in y-axis.
4) Find and load the closest to 3m on the x-axis, and also the corresponding the velocity in y-axis.
I want to rearrange the experiment data with regular intevals as above.
Please help..
x_distance y_velocity
0.52299 0.000237
1.04598 0.041598
1.56897 0.005755
2.09196 0.012987
2.614949 0.009894
3.137939 0.050168
3.660929 0.00584
4.183919 0.045582
4.706909 0.00007
5.229899 0.054282
5.752889 0.002132
6.275879 2.508755
6.798868 3.193212
7.321858 3.460158
7.844848 3.206859
8.367838 2.923524
8.890828 2.23533
9.413818 1.127799
9.936808 0.429399
10.459798 0.814943
0 Comments
Accepted Answer
KALYAN ACHARJYA
on 8 Dec 2020
Edited: KALYAN ACHARJYA
on 8 Dec 2020
Hints:
data=[0.52299 0.000237
1.04598 0.041598
1.56897 0.005755
2.09196 0.012987
2.614949 0.009894
3.137939 0.050168
3.660929 0.00584
4.183919 0.045582
4.706909 0.00007
5.229899 0.054282
5.752889 0.002132
6.275879 2.508755
6.798868 3.193212
7.321858 3.460158
7.844848 3.206859
8.367838 2.923524
8.890828 2.23533
9.413818 1.127799
9.936808 0.429399
10.459798 0.814943];
Next: Distance for x-axis, velocity for y-axis
x_distance=data(:,1);
y_velocity=data(:,2);
Next: "Find and load the closest to 1m on the x-axis, and also the corresponding the velocity in y-axis."
What does the 1m menas?
Is that closset between x_distance & y_velocity?? If so, then
close_1m=x_distance-y_velocity;
Then finding the correcponding index
idx=find(close_1m==min(close_1m))
Please do the rest part by yourself.
:)
0 Comments
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!