Clear Filters
Clear Filters

find unique array cell with 2 field

52 views (last 30 days)
Luca Re
Luca Re on 13 Oct 2024 at 9:27
Edited: Matt J on 13 Oct 2024 at 11:48
load('matlab_f.mat')
f
f = 4x2 cell array
{'a'} {'1'} {'a'} {'1'} {'c'} {'2'} {'c'} {'1'}
i want to find row equal
f(1.:) and f(2,:) are equal
f(3.:) and f(4,:) are not equal

Accepted Answer

Matt J
Matt J on 13 Oct 2024 at 9:58
>> findgroups(f(:,1),f(:,2))
ans =
1
1
3
2
  4 Comments
Luca Re
Luca Re on 13 Oct 2024 at 11:15
thank but if i want to delete duplicate..can i do it?
can I search for the same pairs and delete one of these or is there a faster method
Matt J
Matt J on 13 Oct 2024 at 11:33
Edited: Matt J on 13 Oct 2024 at 11:48
I demonstrated how to do that in my other answer.
Ultimately, you should probably convert your data and leave it in table form. The things you are asking are very readily done with the data in that form.

Sign in to comment.

More Answers (2)

Matt J
Matt J on 13 Oct 2024 at 9:40
Edited: Matt J on 13 Oct 2024 at 9:41
load('matlab_f.mat')
table2cell(unique(cell2table(f),'rows'))
ans = 3x2 cell array
{'a'} {'1'} {'c'} {'1'} {'c'} {'2'}

Sameer
Sameer on 13 Oct 2024 at 9:43
Edited: Sameer on 13 Oct 2024 at 9:47
Hi Luca
To compare rows of a cell array and determine if they are equal, you can use the "isequal" function.
Here's how you can do it:
load('matlab_f.mat')
% Check if the first and second rows are equal
if isequal(f(1,:), f(2,:))
disp('f(1,:) and f(2,:) are equal');
else
disp('f(1,:) and f(2,:) are not equal');
end
f(1,:) and f(2,:) are equal
% Check if the third and fourth rows are equal
if isequal(f(3,:), f(4,:))
disp('f(3,:) and f(4,:) are equal');
else
disp('f(3,:) and f(4,:) are not equal');
end
f(3,:) and f(4,:) are not equal
Please refer to the below MathWorks documentation link:
Hope this helps!

Categories

Find more on Shifting and Sorting Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!