I have two sets of co-ordinates, one with 49,898 combinations of x and y (let’s call this Set A) and the other with 36,404 combinations of x and y (let’s call this Set B). Set A has all of the combinations in Set B but with an additional 13,494 combinations. I want to extract this unique set of 13,494 combinations. For the purpose of trying to extract these unique values using excel or R (I would be happy if someone proposed a solution using either of these), I have copied Set B’s x & y co-ordinate combinations into the same column as Set A’s.
Simple image showing table layout: x and y example
I have read through a number of posts proposing the use of excel & R which partly deal with this problem except the output is always 49,898 combinations because they maintain the ‘original’ set of duplicate values. I understand why this is, but what I would like is to delete those duplicates entirely so that I have a final output containing Set A's unique 13,494 combinations.
On excel I used the following: Data -> Advanced Filter -> Unique records only
In R I used the following code from this thread:
UniqRemDups <- unique(RemDups[,c('Xcod','Ycod')])How to filter for unique combination of columns from an R dataframe
Any help/advice would be greatly appreciated. Thank you.