Operations with tables and matrix
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello,
I have three tables with some information and I want to finally obtain a 3D-matrix:
The 3 tables are:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/167711/image.jpeg)
First step: I want to include information from table2 in table 1
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/167712/image.jpeg)
Second step: I want to create a 3D-matrix with information from new_table1 and table 3
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/167713/image.jpeg)
Any suggestions?
Thank you!
Montse
0 commentaires
Réponses (1)
Akira Agata
le 16 Déc 2017
I'm not sure why you want to make 3D matrix. By connecting all the tables using innerjoin, you can obtain a table which contains all the information you need, like:
table12 = innerjoin(table1,table2,'Keys','date');
table123 = innerjoin(table12,table3,'Keys','ind');
tableOut = table123(:,{'ind','dur','vm','value1','value2','value3'});
If you want to make 3D matrix for some reason, it's a piece of cake!
data3D = cat(3,tableOut{:,{'ind','dur','vm','value1'}},...
tableOut{:,{'ind','dur','vm','value2'}},...
tableOut{:,{'ind','dur','vm','value3'}});
Voir également
Catégories
En savoir plus sur Stability Analysis 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!