mergeAnalyzer: Analyze data for merging

In analyzer: Data Analysis and Automated R Notebook Generation

Description

mergeAnalyzer analyzes the data drop after merge

Usage

mergeAnalyzer(x, y, round.digit = 2, ...)

Arguments

x	left data to merge
y	right data to merge
round.digit	integer indicating the number of decimal places to be used
...	other parameters needs to be passed to merge function

Details

Prints the summary of data retained after merge and returns the merged data. This function uses data.table (if the package is installed) for faster data merge

Value

Returns merged data with same class as that of input data. Prints summary of data retained after merging. The summary has 6 columns:

• Column: Number of rows and union of column names of numeric columns in both the data

• x, y: Sum of columns in both table

• Merged: Sum of columns in merged data

• remainingWRTx: ratio of remaining data in merged data after merging. example - 0.5 means that 50 of inner join). 1.5 means value became 150 duplicates present in data

• remainingWRTy: same as above, but for y table

Examples

# Creating two tables to merge
A <- data.frame(id = c("A", "A", "B", "D", "B"),
                valA = c(30, 83, 45, 2, 58))

B <- data.frame(id = c("A", "C", "A", "B", "C", "C"),
                valB = c(10, 20, 30, 40, 50, 60))

mergeAnalyzer(A, B, allow.cartesian = TRUE, all = FALSE)

analyzer documentation built on July 1, 2020, 10:02 p.m.