How to get a subtable out of a large table on conditions
6 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
Mohammad Abouali
il 9 Lug 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).
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Loops and Conditional Statements in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!