The following DataFrame has one duplicate row; the fourth row is the same as the first.
|
>
|
|
|
| (1) |
The AreDuplicate command returns a truefalseFAIL DataSeries that shows duplicate rows as true and unique rows as false.
|
| (2) |
If the DataFrame is indexed by the result, a filtered DataFrame is returned that shows just the duplicate rows:
This can also be combined with other queries in order to show rows that meet a given criteria. For example, to see which rows have duplicate elements in the first column and whose entries in the second column are less than 6:
|
>
|
DF[ AreDuplicate( DF[1] ) and DF[2] <~ 6 ];
|
