How to get a subtable out of a large table on conditions
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
JFz
el 9 de Jul. de 2015
Comentada: JFz
el 9 de Jul. de 2015
I have a Matlab table A. I want to extract some rows from the table by certain key words and put the result into another table. The old table has 6 columns, I want to extract the first column to have value 'ATL', and the 3rd column to have value '7/7/2015'. How to do that?
tmpTbl = my_prices('ATL',:,'7/7/2015', :,:, :)
But it keeps saying error. I am totally confused here.
Thanks!
0 comentarios
Respuesta aceptada
Mohammad Abouali
el 9 de Jul. de 2015
mask=strcmpi(myTable.firstColumn(:),'ATL') & ...
strcmpi(myTable.thirdColumn(:),'7/7/2015');
newTable=myTable(mask,:);
of course change the 'firstColumn', 'thirdColumn', to their appropriate name (also goes for myTable and newTable).
Más respuestas (0)
Ver también
Categorías
Más información sobre Loops and Conditional Statements en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!