Sensor Data for look up table

2 views (last 30 days)
stephen collier
stephen collier on 14 Dec 2021
Edited: stephen collier on 14 Dec 2021
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 Comments
stephen collier
stephen collier on 14 Dec 2021
I also ran it through a surface fit and got the 1*1sfit ans . but i dont know how to use the data

Sign in to comment.

Accepted Answer

KSSV
KSSV on 14 Dec 2021
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 Comments
stephen collier
stephen collier on 14 Dec 2021
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

Sign in to comment.

More Answers (0)

Products


Release

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!