remove rows in cell if a column is equal to a number

Question

Tiffany Lee 2012-11-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/53706-remove-rows-in-cell-if-a-column-is-equal-to-a-number

So this is a simplified version of what I have, I want to remove the rows in X that match the number in the cell Y, so all I would have left is the first row. My real data has over a million rows, is there a quick way to do this? Thanks for your help!

X =

    'B737'    'DAL1240'    [10]
    'MD88'    'DAL1542'    [ 9]
    'B747'    'DAL1284'    [ 9]
    'B737'    'DAL1532'    [ 4]
    'A320'    'DAL1417'    [ 4]

Y =

    [9]
    [4]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

C.J. Harris 2012-11-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/53706-remove-rows-in-cell-if-a-column-is-equal-to-a-number#answer_65351

在 MATLAB Online 中打开

X = {'B737'    'DAL1240'    [10]
    'MD88'    'DAL1542'    [ 9]
    'B747'    'DAL1284'    [ 9]
    'B737'    'DAL1532'    [ 4]
    'A320'    'DAL1417'    [ 4]};
Y = {[9]
    [4]};
X(ismember(cell2mat(X(:,3)),cell2mat(Y)), :) = [];