import data and plat a 3D
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I do have a excel file with 3 columns (x y z). I wanna import them to Matlab, and plot a nice surface Plot.i might have to interpolate?
2 commentaires
Rik
le 20 Déc 2019
If it is a full grid of x and y, there will be no need for interpollation. Can you share your actual data, or a functional equivalent?
Réponses (2)
Rik
le 20 Déc 2019
No interpollation required, just a conversion to a 2D matrix. You can adapt the syntax of accumarray if you do have any missing values (by default it will fill with 0).
num=xlsread('test1.xlsx');
x=num(:,1);
y=num(:,2);
P=num(:,3);
%find the unique x and y values and use them as indices to fill the Z
[X,~,x_]=unique(x);
[Y,~,y_]=unique(y);
Z=accumarray([x_,y_],P);
[X,Y]=ndgrid(X,Y);
surf(X,Y,Z)
10 commentaires
Rik
le 6 Jan 2020
On a conceptual level, what would you do? If you needed to do it on paper, what would your approach be?
ME
le 20 Déc 2019
I think you are correct about the need to interpolate. You could try having a read of the link below - that should give you some good pointers.
0 commentaires
Voir également
Catégories
En savoir plus sur Surface and Mesh Plots 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!