Interpolation of 3 dimensional values from a excel file

6 visualizaciones (últimos 30 días)
kyungdoo lee
kyungdoo lee el 19 de Oct. de 2021
Comentada: kyungdoo lee el 20 de Oct. de 2021
how should i interpolate them so that i can give any value of x and y in between the range to get ultimate value of z.
i have attached a file of values for more clarity.

Respuesta aceptada

KSSV
KSSV el 19 de Oct. de 2021
Read about interp2.
T = readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/771628/excel%20table.xlsx') ;
T = table2array(T) ;
x = T(1,2:end);
y = T(2:end,1);
Z = T(2:end,2:end); % use fillmissing to fill NaNs
[X,Y] = meshgrid(x,y) ;
figure(1)
pcolor(X,Y,Z);
% do interpolation
m = 100;
xi = linspace(min(x),max(x),m) ;
yi = linspace(min(y),max(y),m);
[Xi,Yi] = meshgrid(xi,yi);
Zi = interp2(X,Y,Z,Xi,Yi);
pcolor(Xi,Yi,Zi)
  6 comentarios
KSSV
KSSV el 20 de Oct. de 2021
I have run the code and shown it.
kyungdoo lee
kyungdoo lee el 20 de Oct. de 2021
Thanks for your hard work

Iniciar sesión para comentar.

Más respuestas (0)

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by