Cell array row deletion

8 visualizzazioni (ultimi 30 giorni)
Daniela Valdez
Daniela Valdez il 19 Gen 2021
Commentato: 豆 张 il 18 Feb 2022
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 Commento
豆 张
豆 张 il 18 Feb 2022
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

Accedi per commentare.

Risposte (2)

Fangjun Jiang
Fangjun Jiang il 19 Gen 2021
c={'a',1,2;'b',3,4}
index=strcmp(c(:,1),'a')
c(index,:)=[]
  3 Commenti
Fangjun Jiang
Fangjun Jiang il 20 Gen 2021
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
Adam Danz il 20 Gen 2021
Modificato: Adam Danz il 20 Gen 2021
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()

Accedi per commentare.


Image Analyst
Image Analyst il 19 Gen 2021
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 Commenti
Daniela Valdez
Daniela Valdez il 19 Gen 2021
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.
Image Analyst
Image Analyst il 20 Gen 2021
Did you miss the last sentence in my answer? I'll check back tomorrow for it.

Accedi per commentare.

Prodotti


Release

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by