MATLAB: Remove Duplicate Rows in a Cell Array

cell arrayremove duplicatesunique

Hello,

I'm trying to remove duplicate rows in a cell array. I'm familiar with the 'unique' function for use on vectors (or individual columns of a cell array) but I'm stumped on how to work on the whole array at once.

What I'm looking for is the same as the Excel button "Remove Duplicates" which does this:

withduplicates={
'Bear'  'Chicago'  '1 yr'
'Bear'  'Chicago'  '1 yr'
'Bear'  'Chicago'  '1 yr'
'Bear'  'Miami'   '2 yr'
'Bear'  'Miami'         '2 yr'
'Lion'  'Denver'  '1 yr'
'Lion'  'Miami'   '2 yr'
'Lion'  'Miami'         '2 yr'
'Lion'  'Miami'         '2 yr'
'Tiger'  'Denver'  '1 yr'
'Tiger'  'Chicago'  '1 yr'
'Tiger'  'Chicago'  '1 yr'}
withoutduplicates={
'Bear'  'Chicago'  '1 yr'
'Bear'  'Miami'   '2 yr'
'Lion'  'Denver'  '1 yr'
'Lion'  'Miami'         '2 yr'
'Tiger'  'Denver'  '1 yr'
'Tiger'  'Chicago'  '1 yr'}

Any help is greatly appreciated.

Best Answer

wd=withduplicates;
[~,idx]=unique(  strcat(wd(:,1),wd(:,2),wd(:,3)) , 'rows');
withoutduplicates=wd(idx,:)

Related Solutions

MATLAB: Create vector based on string data

S = {
'FA.EA';
'FA.EB';
'FA.EC';
'FA.EA';
'FA.EB';
'FB.EC';
'FB.EA';
'FB.EB';
'FC.EC';
'FC.ED';
'FC.EA';
'FC.EB'}
v1 =  cellfun(@(x) x(1:2),S,'un',0) ;
[c,ia,v1] = unique(v1) ;
v1
v2 =  cellfun(@(x) x(4:5),S,'un',0) ;
[c,ia,v2] = unique(v2) ;
v2

MATLAB: How to load multiple files and do the computation for each of them and write the output in consequent rows

Your loop will want to start with grabbing all files in a folder. uigetfile with the MultiSelect option will work wonders here:

[Name,Path]=uigetfile({'*.xlsx*'},'MultiSelect','on');
entirefile=fullfile(Paths,Names);

Then start your loop. It wants to run a number of times equal to the number of elements in your entirefile cell, as you also have in your own code. Within this loop, do all your loading, calculation and writing. To avoid cluttering the workspace, you might want to look into a structure and dot indexing.

for i=1:numel(entirefile);
    %your entire code including
    enginedata(i).raw=importdata(entirefile{i});
    enginedata(i).temperature = your temperature calculation
    enginedata(i).oilpressure = oil pressure calculation
    %and so on
    %finally, to write in consecutive fields the results, simply keep indexing your things:
    celltarget=['B',num2str(i)]; %B1 first run, B2 2nd run etc. 
    writecell(mean_engine_temperature,filename,'Sheet','Temperatures','Range',celltarget);
end

Best Answer

Related Solutions

MATLAB: Create vector based on string data

MATLAB: How to load multiple files and do the computation for each of them and write the output in consequent rows

Related Question