Interpolation of 3 dimensional values from a excel file
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Shubham Mohan Tatpalliwar
le 24 Sep 2018
Commenté : Adam
le 24 Sep 2018
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 commentaires
Réponse acceptée
KSSV
le 24 Sep 2018
[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)
5 commentaires
Adam
le 24 Sep 2018
Please don't use flags for things that should just be a comment, or in this case, just accepting the answer is enough to say it worked.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Get Started with MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!