Deleting Duplicates from 2 data sets
3 views (last 30 days)
Show older comments
Hello dear members,
I was wondering, how can I smartly combine 2 data files and then delete values completely which are common like In fact I want to get Data-1-Data-2 this will remove the entries of data file 2 from data file 1.
Data-1
24/25/W3 23.1 56.3
24/25/W4 25.8 56.8
24/25/W5 29.6 57.9
24/25/W6 25.2 58.4
24/25/W7 25.96 55.7
24/25/W8 30 58
and Data-2
24/25/W5 25.8 56.8
24/25/W3 23.1 56.3
24/25/W10 30 58
24/25/W6 25.2 58.4
24/25/W8 30 58
I want an output file which have both data1 and data 2 entries but no dublicates. You can see there are few same values in above example. Thanks
0 Comments
Answers (1)
Azzi Abdelmalek
on 8 Jul 2015
data=unique([data_1;data_2],'rows')
3 Comments
Azzi Abdelmalek
on 8 Jul 2015
Edited: Azzi Abdelmalek
on 8 Jul 2015
a = [1 2 3 4 5]
b = [1 3 2]
c=setdiff(a,b)
See Also
Categories
Find more on Data Import and Analysis 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!