Interpolation of 3 dimensional values from a excel file

4 Ansichten (letzte 30 Tage)
kyungdoo lee
kyungdoo lee am 19 Okt. 2021
Kommentiert: kyungdoo lee am 20 Okt. 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.

Akzeptierte Antwort

KSSV
KSSV am 19 Okt. 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 Kommentare
KSSV
KSSV am 20 Okt. 2021
I have run the code and shown it.
kyungdoo lee
kyungdoo lee am 20 Okt. 2021
Thanks for your hard work

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by