ID,Col1,Col2,Col3
1,A,apple,0.8414710
2,B,orange,0.9092974
3,C,apple,0.1411200
4,D,pineapple,-0.7568025
5,E,apple,-0.9589243
6,F,orange,-0.2794155
ID,Col1,Col2,Col4,Col5
1,A,Apple,0.6666666,1
2,b,orange,0.9092974,2
3.0,D,apple,0.14,3
4,D, pineapple,-0.7568025,4
5,E,apple,0.9589243,5
7,A,pink,4.1213000,6
> rCompare(a, b)
Running rCompare...
3 column(s) were dropped, all rows were compared
There are 3 mismatched variables:
First and last 5 observations for the 3 mismatched variables
rowNo valueA valueB variable typeA typeB diffAB
1 2 B b COL1 factor factor
2 3 C D COL1 factor factor
3 6 F A COL1 factor factor
4 1 apple Apple COL2 factor factor
5 4 pineapple pineapple COL2 factor factor
6 6 orange pink COL2 factor factor
7 1 <NA> <NA> ID integer double
8 2 <NA> <NA> ID integer double
9 3 <NA> <NA> ID integer double
10 4 <NA> <NA> ID integer double
11 5 <NA> <NA> ID integer double
12 6 <NA> <NA> ID integer double
Warning messages:
1: In `[<-.factor`(`*tmp*`, ri, value = 1:6) :
invalid factor level, NA generated
2: In `[<-.factor`(`*tmp*`, ri, value = c(1, 2, 3, 4, 5, 7)) :
invalid factor level, NA generated