Logical Indexing for entire Table

141 visualizzazioni (ultimi 30 giorni)
Essentially, I am trying to do (pseudo code):
T=table(data); % T contains many columns of doubles, date times, and is otherwise numeric.
m = T.field == condition; % Logical indexing based on some field
T=T(m); % implicit application of mask m to each column in T.
Of course, the last line isn't supported by Matlab and returns an error:
Subscripting a table using linear indexing (one subscript) or multidimensional indexing (three or more
subscripts) is not supported. Use a row subscript and a variable subscript.
Is there a way to essentially downsample an entire table based on a logical index mask? It is conceivable that table T has a large (100s) of columns, and manually indexing into each column could be too time consuming.
  1 Commento
Ahmed Radwan
Ahmed Radwan il 21 Nov 2019
Hi, I tried your solution, but it didn't work..
for dp=1:length(DataPoint)
data(dp,:)=adeInfo;
end
I get this error:
Right hand side of an assignment into a table must be another table or a cell array.
adeInfo is not a table. it is as follows, as shown in MATLAB: "A singleton class"

Accedi per commentare.

Risposta accettata

Adam Attarian
Adam Attarian il 24 Ott 2018
The solution is simple, and I'm ashamed I didn't see it earlier:
T=T(m,:);
  1 Commento
Leone Campos
Leone Campos il 3 Gen 2023
You shouldn't be ashamed of yourself, you helped me :D

Accedi per commentare.

Più risposte (1)

Monika Lingvay
Monika Lingvay il 11 Nov 2019
Modificato: Monika Lingvay il 11 Nov 2019
Thank you, I was looking for the same question and answer!

Prodotti


Release

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by