diff: Compare Two Datasets

In MattjCamp/datapointsr: Painless statistical table QC analysis

Compare Two Datasets

Description

Takes two datasets and compares them looking for common values in the two based on common keys. The datasets should be two different version of the same type of dataset with common variables and keys.

Usage

diff(dataset1, dataset2, vars, keys, clean = TRUE)

Arguments

dataset1	first dataset to compare
dataset2	second dataset to compre
vars	list of variables that you want to compare. The list can be the column names in quotes or the number positions.
keys	key fields the two datasets have in common. Can be the column names in an array with quotes or the number positions. The key must be selected in the vars list as well and the numeric position must correspond to the position in the vars select list. It's easier to use the text description here.
clean	apply datapointsr clean function to strip out NULLS, NAS, and round numbers to 1 decimal place

Examples

library(tidyverse)
library(datapointsr)

ds1 <- tibble(
  x = 1:5
  , y = 1:5
  , z = c("A", "B", "C", "D", "E")
)

ds2 <- tibble(
  x = 1:5
  , y = c(1:3, 7, 5)
  , z = c("A", "B", "C", "D", "E")
)

m <-
  diff(
       dataset1 = ds1
       , dataset2 = ds3
       , vars = 1:3
       , keys = 1
  )

m <-
  diff(
      dataset1 = ds1
      , dataset2 = ds3
      , vars = c("x", "y", "z")
      , keys = c("x")
 )

  m

MattjCamp/datapointsr documentation built on Sept. 14, 2023, 12:43 p.m.