Deleting Duplicates from 2 data sets

1 view (last 30 days)
amberly hadden
amberly hadden on 8 Jul 2015
Commented: amberly hadden on 8 Jul 2015
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

Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 8 Jul 2015
data=unique([data_1;data_2],'rows')
  3 Comments
Azzi Abdelmalek
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)
amberly hadden
amberly hadden on 8 Jul 2015
Thanks Azzi, But again I have a text file I just want to remove data from file-1 which is present in file-2. file-1 is composite data. tahnks

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!