Đọc data
d1= read.csv("C:\\Users\\ADMIN\\Desktop\\d1.csv")
d1
## id x1 x2
## 1 1 a b
## 2 2 a b
## 3 3 b
## 4 4 a
## 5 5 b a
d2= read.csv("C:\\Users\\ADMIN\\Desktop\\d2.csv")
d2
## id x1 x2
## 1 3 a
## 2 4 b
## 3 5 c b
## 4 1 a b
## 5 2 a b
So sánh 2 dataframe d1 và d2 dùng gói
diffdf
diffdf::diffdf(d1, d2)
## Registered S3 methods overwritten by 'tibble':
## method from
## format.tbl pillar
## print.tbl pillar
## Warning in diffdf::diffdf(d1, d2):
## Not all Values Compared Equal
## Differences found between the objects!
##
## A summary is given below.
##
## Not all Values Compared Equal
## All rows are shown in table below
##
## =============================
## Variable No of Differences
## -----------------------------
## id 5
## x1 3
## x2 3
## -----------------------------
##
##
## All rows are shown in table below
##
## ========================================
## VARIABLE ..ROWNUMBER.. BASE COMPARE
## ----------------------------------------
## id 1 1 3
## id 2 2 4
## id 3 3 5
## id 4 4 1
## id 5 5 2
## ----------------------------------------
##
##
## All rows are shown in table below
##
## ========================================
## VARIABLE ..ROWNUMBER.. BASE COMPARE
## ----------------------------------------
## x1 2 a
## x1 3 c
## x1 5 b a
## ----------------------------------------
##
##
## All rows are shown in table below
##
## ========================================
## VARIABLE ..ROWNUMBER.. BASE COMPARE
## ----------------------------------------
## x2 1 b
## x2 4 b
## x2 5 a b
## ----------------------------------------
Hoặc dùng gói dplyr
dplyr::setdiff(d1,d2)
## id x1 x2
## 1 3 b
## 2 4 a
## 3 5 b a