Suppose you have a table such as the one below:
Data = [rand(1,5);rand(1,5);rand(1,5);rand(1,5);rand(1,5);rand(1,5)];
A = table(Sample,Data)
A =
Sample Data
______ ____________________________________________________________
0 0.21426 0.64868 0.07936 0.58883 0.75634
1 0.36764 0.46345 0.56078 0.12871 0.19823
1 0.58486 0.18506 0.029363 0.31866 0.2336
2 0.53846 0.47363 0.99926 0.29129 0.61109
2 0.063376 0.99878 0.36276 0.1082 0.0017856
2 0.89091 0.85546 0.011542 0.98834 0.88992
Now say you want to extract only a subset a data that corresponds to certain Sample numbers. I know of a coup[le ways to do this.
You can do row-wise deletion if your table isn't too large and you know the row numbers of what you want to delete. Or you can just call the rows that you care about and assign it to a new table.
B
B =
Sample Data
______ ____________________________________________________________
2 0.53846 0.47363 0.99926 0.29129 0.61109
2 0.063376 0.99878 0.36276 0.1082 0.0017856
2 0.89091 0.85546 0.011542 0.98834 0.88992
B = B(4:6,:)
B =
Sample Data
______ ____________________________________________________________
2 0.53846 0.47363 0.99926 0.29129 0.61109
2 0.063376 0.99878 0.36276 0.1082 0.0017856
2 0.89091 0.85546 0.011542 0.98834 0.88992
But if your table is large, I prefer to use some logical indexing:
B = A(A.Sample == 2,:)
B =
Sample Data
______ ____________________________________________________________
2 0.53846 0.47363 0.99926 0.29129 0.61109
2 0.063376 0.99878 0.36276 0.1082 0.0017856
2 0.89091 0.85546 0.011542 0.98834 0.88992
Now what if I want to have multiple targets in the mask of my logical lindex. I know I can combine multiple logical indicies (indexes?) as below, but then how do I pass that along to the table?
B = B(B.Sample(E),:)
Error using ()
Index in position 1 is invalid. Array indices must be positive integers or logical values.
Really, I am hoping there is a way to make the following workflow happen without going through for loops for each target of my logical index, but I might have to homebrew my own function to accomplish this.
If anyone knows a better way to do this so I can avoind clunky blocks in my script that will piecewise pull out the bits that I need, I would really appreciate it. Thanks in advance!
