How to delete specific rows in a table based on a value?

2020 12 13
2 个回答
回答已采纳
更新时间：2020 12 16
25 次查看（30 天）

0 个投票

Hi all,
I have a big table with 6 columns and would like to delete all rows where one column contains a specific value.
That's how the table looks like:
I would like to delete all rows, where T.ISIN == 'DE0006205701'
May you please help me with this?
Thanks so much in advance!

5 个评论
显示 3更早的评论 隐藏 3更早的评论

dpb
dpb 2020-12-13
Show us what have you tried and where you ran into difficulty?
Image Analyst
Image Analyst 2020-12-13
编辑：Image Analyst 2020-12-13
Attach your table in a .mat file so we can try things with it.
save('answers.mat', 'T');
In the meantime, try ismember().
Carl Schneegaß
Carl Schneegaß 2020-12-13
I had thought about something like
T = T(T.ISIN~='DE0006205701',:);
but it doesn't work for cell..
Carl Schneegaß
Carl Schneegaß 2020-12-13
I think the solution is
T = T(~contains(T.ISIN,'DE0006205701'),:);

请先登录，再进行评论。

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

 采纳的回答

Carl Schneegaß
Carl Schneegaß 2020-12-16

1 个投票

I fortunately found the answer myself, it's
T = T(~contains(T.ISIN,'DE0006205701'),:);
Moroever, check out Image Analyst's solution, it works too!

更多回答（1 个）

Image Analyst
Image Analyst 2020-12-13

0 个投票

Did you try ismember like I suggested above?
s = load('answers.mat')
T = s.T;
whos T % Show size.
% I would like to delete all rows, where T.ISIN == 'DE0006205701'
pattern = 'DE0006205701'
[ia, ib] = ismember(T.ISIN, {pattern});
fprintf('Found %d rows where ISIN = "%s". We will delete those.\n', sum(ia), pattern);
T(ia, :) = [];
whos T % Show size now.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Carl Schneegaß
Carl Schneegaß 2020-12-13
thanks a lot for your help, this definitely works!
I think maybe even easier might be
T = T(~contains(T.ISIN,'DE0006205701'),:);

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Numeric Types 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by