| ID | X | Y |
| 1 | 1 | 2 |
| 2 | 2 | 1 |
| 3 | 3 | 5 |
| 4 | 4 | 6 |
Thank you!
Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.
Wednesday, April 24, 2019
Drop duplicate pairs (X,Y; Y,X)
Unfortunately, I was not able to find out how to drop a pair of duplicates. Let's say we have variables ID, X and Y and the data looks as follows:
I would like to identify ID1 and ID2 as a pair and drop ID2. However, this does not work with "duplicates". Do you have an efficient solution for this problem?
Thank you!
Thank you!
No comments:
Post a Comment