Sensor Data for look up table
显示 更早的评论
Hi, i have some data, in excell in 3 columns the first two columns being independant and the third the dependant, or the result.
Im trying to get the data into a look up table to aproxamate the result for any input. im not having much sucess.
Thanks for any help
3 个评论
Rik
2021-12-14
The first step is to load the content of the excel file as a variable. Did you do that already?
What do you think the next step is? What did you try?
stephen collier
2021-12-14
yes i can load the data, inported as vectors and into a 2D lookup,
stephen collier
2021-12-14
I also ran it through a surface fit and got the 1*1sfit ans . but i dont know how to use the data
采纳的回答
KSSV
2021-12-14
T = readtable('look21 (1).xlsx')
x = T.x ;
y = T.y ;
z = T.z ;
xi = linspace(min(x),max(x)) ;
yi = linspace(min(y),max(y)) ;
[X,Y] = meshgrid(xi,yi) ;
F = scatteredInterpolant(x,y,z,'nearest','none') ;
Z = F(X,Y) ;
surf(X,Y,Z)
3 个评论
stephen collier
2021-12-14
Thanks KKSV,
I ran that ang got a Fit, how do i use that in a look up table?
KSSV
2021-12-14
If you have a point (x,y); Jut use:
z = F(x,y)
stephen collier
2021-12-14
编辑：stephen collier
2021-12-14
I have a 2d lookup table working using the below data, my issue now is when the x or y value is not in it data set the model returns nan, show do you get an interpolated answer? i sorted that by changing the scatterplot as below for any one in the same boat. Thank you KSSV
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
