I am using a dataset that has 6 columns. I would like to find any rows that have an exact match in any other row, aside from two columns. So If my data were like the following:
WT 40 SH VJ PB HT
200 4.8 5.6 37 32 71
223 4.9 5.4 38 37 75
220 4.8 5.7 23 31 74
210 4.3 5.8 35 33 72
205 4.8 5.6 37 32 73
And the columns I didnt care about were WT and HT, I would want to receive the first and fifth data points as they are identical save for the columns WT and HT.