remove duplicate rows based on one column in Excel by matlab code:
I attached the file A.xlsx.
A:
1 1.21
1 1.22
1 1.22
2 1.34
2 1.35
3 1.5
4 1.6
5 1.72
5 1.72
I want to extract Matrices B from A:
B:
1 1.21
2 1.34
3 1.5
4 1.6
5 1.72
Aparna Sathya Murthy
Data=xlsread('A.xlsx');
NuSet=unique (Data,'rows');
xlswrite('B.xlsx',NuSet);
1 votes
1 thanks
Amir Shirkhani
Thank you. The result of your code is:
B:
1 1.21
1 1.22
2 1.34
2 1.35
3 1.5
4 1.6
5 1.72
but I want under result :
1 1.21
2 1.34
3 1.5
4 1.6
5 1.72
0 votes
0 thanks
Aparna Sathya Murthy
Small change Amir,
[tt,x,y]=unique(Data(:,1),'rows') ;
NuSet=Data(x,:);
where a and y are the indices of unique and all the elements of the array .
1 votes
1 thanks
- Badges
- Science topic
- Similar topics
- Computer Science and Engineering
- Coding
More Amir Shirkhani's questions See All
Similar questions and discussions