Logical Indexing for entire Table

119 views (last 30 days)
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 Comment
Ahmed Radwan
Ahmed Radwan on 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"

Sign in to comment.

Accepted Answer

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

Sign in to comment.

More Answers (1)

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

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Products


Release

R2018b

Community Treasure Hunt

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

Start Hunting!