Interpolation of 3 dimensional values from a excel file

조회 수: 6 (최근 30일)
kyungdoo lee
kyungdoo lee 2021년 10월 19일
댓글: kyungdoo lee 2021년 10월 20일
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.

채택된 답변

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

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

제품

Community Treasure Hunt

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

Start Hunting!

Translated by