[R] compare two data frames with same columns names but of different dimensions

[Arnaud Gaboury]

Dear List,

I want to compare and return the rows which are NOT in the two data frames. Classic methods don't work as the df have NOT the same dimensions.


Here are one example of my df:

reported <-
structure(list(Product = structure(c(1L, 1L, 1L, 1L, 2L, 2L, 
3L, 4L, 5L, 5L), .Label = c("Cocoa", "Coffee C", "GC", "Sugar No 11", 
"ZS"), class = "factor"), Price = c(2331, 2356, 2440, 2450, 204.55, 
205.45, 17792, 24.81, 1273.5, 1276.25), Nbr.Lots = c(-61L, -61L, 
5L, 1L, 40L, 40L, -1L, -1L, -1L, 1L)), .Names = c("Product", 
"Price", "Nbr.Lots"), row.names = c(1L, 2L, 3L, 4L, 6L, 7L, 5L, 
10L, 8L, 9L), class = "data.frame")

exportfile <-
structure(list(Product = c("Cocoa", "Cocoa", "Cocoa", "Coffee C", 
"Coffee C", "GC", "Sugar No 11", "ZS", "ZS"), Price = c(2331, 
2356, 2440, 204.55, 205.45, 17792, 24.81, 1273.5, 1276.25), Nbr.Lots = c(-61, 
-61, 6, 40, 40, -1, -1, -1, 1)), .Names = c("Product", "Price", 
"Nbr.Lots"), row.names = c(NA, 9L), class = "data.frame")

As you can see, they have same column names. 
My idea was to merge these two df when passing as argument "not to take into account duplicate rows", so I will get one df with rows which are not in both df.
Is it possible? How to do it?

TY for any help.


Arnaud Gaboury
 
A2CT2 Ltd.