tblcompare: Compare two data frames. Using a key-column common to both...

In tablecompare: Compare Data Frames

Compare two data frames. Using a key-column common to both tables, see which rows are common and highlight differing values by column.

Description

Compare two data frames. Using a key-column common to both tables, see which rows are common and highlight differing values by column.

Usage

tblcompare(
  .data_a,
  .data_b,
  by,
  allow_bothNA = TRUE,
  ncol_by_out = 3,
  coerce = TRUE
)

value_diffs(comparison, col)

## S3 method for class 'tbcmp_compare'
value_diffs(comparison, col)

all_value_diffs(comparison)

## S3 method for class 'tbcmp_compare'
all_value_diffs(comparison)

Arguments

.data_a	A data frame or data table
.data_b	A data frame or data table
by	tidy-select. Selection of columns to use when matching rows between .data_a and .data_b. Both data frames must be unique on by.
allow_bothNA	Logical. If TRUE a missing value in both data frames is considered as equal
ncol_by_out	Number of by-columns to include in col_diffs and unmatched_rows output
coerce	Logical. If False only columns with the same class are compared.
comparison	An object of class "tbcmp_compare" (the output of a tablecompare::tablecompare() call)
col	tidy-select. A single column

Value

tblcompare()

A "tbcmp_compare"-class object, which is a list of data.table's having the following elements:

tables

A data.table with one row per input table showing the number of rows and columns in each.

by

A data.table with one row per by column showing the class of the column in each of the input tables.

summ

A data.table with one row per column common to .data_a and .data_b and columns "n_diffs" showing the number of values which are different between the two tables, "class_a"/"class_b" the class of the column in each table, and "value_diffs" a (nested) data.table showing the rows in each input table where values are unequal, the values in each table, and one column for each of the first ncol_by_out by columns for the identified rows in the input tables.

unmatched_cols

A data.table with one row per column which is in one input table but not the other and columns "table": which table the column appears in, "column": the name of the column, and "class": the class of the column.

unmatched_rows

A data.table which, for each row present in one input table but not the other, contains the columns "table": which table the row appears in, "i" the row number of the input row, and one column for each of the first ncol_by_out by columns for each row.

value_diffs()

A data.table with one row for each element of col found to be unequal between the input tables ( .data_a and .data_b from the original tblcompare() call) The output table has columns "i_a"/"i_b": the row number of the element in the input tables, "val_a"/"val_b": the value of col in the input tables, and one column for each of the first ncol_by_out by columns for the identified rows in the input tables.

all_value_diffs()

A data.table of the value_diffs() output for all columns having at least one value difference, combined row-wise into a single table. To facilitate this combination into a single table, the "val_a" and "val_b" columns are coerced to character.

tablecompare documentation built on Nov. 14, 2023, 9:07 a.m.