Operations with tables and matrix
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Montserrat Vallcorba Martí
am 14 Dez. 2017
Kommentiert: Montserrat Vallcorba Martí
am 19 Dez. 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 Kommentare
Antworten (1)
Akira Agata
am 16 Dez. 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'}});
Siehe auch
Kategorien
Mehr zu Stability Analysis finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!