Sensor Data for look up table
3 views (last 30 days)
Show older comments
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
Accepted Answer
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
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!