Interpolation of 3 dimensional values from a excel file

2 次查看（过去 30 天）

显示更早的评论

Shubham Mohan Tatpalliwar 2018-9-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/420442-interpolation-of-3-dimensional-values-from-a-excel-file

评论： Adam 2018-9-24

采纳的回答： KSSV

i got 10 values of x for each value of x i have 10 values of y and the values of z for each x depends on y

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

KSSV 2018-9-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/420442-interpolation-of-3-dimensional-values-from-a-excel-file#answer_338080

在 MATLAB Online 中打开

[num,txt,raw] = xlsread('Mappe1.xlsx') ;
x = num(:,1) ; x(isnan(x))= [ ];
A = num(:,2:end) ;
A(isnan(A(:,1)),:)=  [] ;
Y = A(1:2:end,:) ;
Z = A(2:2:end,:) ;
X = repmat(x,1,size(Y,1)) ;
idx = ~isnan(Z) ;
F = scatteredInterpolant([X(idx) Y(idx)],Z(idx),'linear','none');
iwant = F(250,0.7)