Cell array row deletion

Question

Daniela Valdez 2021-1-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/721484-cell-array-row-deletion

评论：豆张 2022-2-18

Hi! I have a cell array with a 10647x16 dimension. In the first column I have an identifying name for each row. I want to delete the rows that match the column names I have. I'll put a picture for better reference.

I want to delete the rows that match the 'filename' I write. I need to delete 40 rows.

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

豆张 2022-2-18

I'm so sorry to bother you. I would like to include this data of yours in my research paper, if it is possible, could you please send me the complete table. I really need it!! Thank you so so much~~

PS:My email：zlwww142536@163.com

请先登录，再进行评论。

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

Answer 1

Fangjun Jiang 2021-1-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/721484-cell-array-row-deletion#answer_601539

c={'a',1,2;'b',3,4}
index=strcmp(c(:,1),'a')
c(index,:)=[]

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

Fangjun Jiang 2021-1-20

What do you mean 40 files? 40 filenames maybe?? You can remove multiple rows in one shot.

c={'a',1,2;'b',3,4;'c',1,2;'d',2,3;'e',5,6}
filenames={'b';'d'}
index=ismember(c(:,1),filenames);
c(index,:)=[]

Adam Danz 2021-1-20

编辑：Adam Danz 2021-1-20

If you want to match strings ignoring case, use strcmpi instead of strcmp.

If you're matching to more than 1 string while ignoring case, use

ismember(lower(c(:,1)), lower(filenames)) % or upper()

请先登录，再进行评论。

Answer 2

Image Analyst 2021-1-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/721484-cell-array-row-deletion#answer_601534

Use ismember(). Something like...

fileNamePattern = 'MUSE20180113_171327_27000';
% Compare this character array to the list of them in column 1 of ca (the cell array)
% and find out which row contains it.
[~, row] = ismember({fileNamePattern}, ca(:, 1));
% Delete it
if ~isempty(row)
    ca(row, :) = [];
end

Attach your cell array if that doesn't work.

2 个评论
显示无隐藏无

Daniela Valdez 2021-1-19

Hi! I want to delete 40 files but I can't with this method. I get the following error: Subscript indices must either be real positive integers or logicals.