Operations with tables and matrix
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Montserrat Vallcorba Martí
il 14 Dic 2017
Commentato: Montserrat Vallcorba Martí
il 19 Dic 2017
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 Commenti
Risposte (1)
Akira Agata
il 16 Dic 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'}});
Vedere anche
Categorie
Scopri di più su Stability Analysis in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!