Operations with tables and matrix
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Montserrat Vallcorba Martí
el 14 de Dic. de 2017
Comentada: Montserrat Vallcorba Martí
el 19 de Dic. de 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 comentarios
Respuestas (1)
Akira Agata
el 16 de Dic. de 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'}});
Ver también
Categorías
Más información sobre Stability Analysis en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!