simple way to show differences between 2 dataframes

[ply]

2 dataframes

tibble [4 × 2] (S3: tbl_df/tbl/data.frame)
ID : chr [1:2861] "1" "2" "3" "4" CaseNumber: chr [1:2861] "001" "002" "003" "004"

tibble [4 × 2] (S3: tbl_df/tbl/data.frame)
ID : chr [1:2861] "1" "2" "3" "4" CaseNumber: chr [1:2861] "001" "005" "003" "009"

I just want a simple way of showing the differences ie

ID df1$CaseNumber df2$CaseNumber
2 "002" "004"
4 "005" "009"

Obviously there are thousands of records not just 4

Cheers

[nirgrahamuk]

library(tidyverse)

a1 <- tribble(~key,~cn,
              1,"001",
              2,"002",
              3,"003",
              4,"004")
a2 <- tribble(~key,~cn,
              1,"001",
              2,"005",
              3,"003",
              4,"009")

full_join(a1,a2,
          by="key") %>% 
          filter(cn.x != cn.y)

[agrim]

{waldo} https://waldo.r-lib.org/