How to remove all rows from categorical variable corresponding to a double array?

3 次查看（过去 30 天）
Anthony
Anthony 2018-3-9
回答： Peter Perkins 2018-3-15
Assuming the following data and Table X:
A=[ 1 5 0 3 9]';
B=[ 2 9 5 8 0 ]';
C={'S1','S2','S3','S4','S5'}';
C = categorical(C);
X = table(C,A,B);
...and removing the rows with zeros
A1 = A(A(:,1) > 0, :);
B1 = B(B(:,1) > 0, :);
How do I now remove the corresponding rows from C that were removed in A and B, and make a new table X1 that contains A1, B1, and C1? I know have have to using indexing to determine which categories of C correspond to the rows that were removed, I'm just not sure how to do that.

请先登录，再回答此问题。

采纳的回答

Fangjun Jiang
Fangjun Jiang 2018-3-9
index=and(A(:,1) > 0,B(:,1) > 0)
X1=X(index,:)

更多回答（1 个）

Peter Perkins
Peter Perkins 2018-3-15
You might find this more expressive, and it doesn't require the original vectors, which you may have chosen to delete afer putting them in the table X:
X2 = X(X.A>0 & X.B>0,:)

类别

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by