Learn R Programming

⚠️There's a newer version (0.1.4) of this package.Take me there.

dataCompareR (version 0.1.1)

Compare Two Data Frames and Summarise the Difference

Description

Easy comparison of two tabular data objects in R. Specifically designed to show differences between two sets of data in a useful way that should make it easier to understand the differences, and if necessary, help you work out how to remedy them. Aims to offer a more useful output than all.equal() when your two data sets do not match, but isn't intended to replace all.equal() as a way to test for equality.

Copy Link

Version

Install

install.packages('dataCompareR')

Monthly Downloads

479

Version

0.1.1

License

Apache License 2.0 | file LICENSE

Issues

Pull Requests

Stars

Forks

Repository

https://github.com/capitalone/dataCompareR

Maintainer

Rob Noble-Eddy

Last Published

November 14th, 2017

Functions in dataCompareR (0.1.1)

allVarMatchMessage

allVarMatchMessage

checkForRCompareCol

checkForRcompareCol

colsWithUnequalValues

colsWithUnequalValues: a dataframe summarising a column with unequal values

collapseClasses

collapseClasses. Collapse the classes of an object to a single string

checkUniqueness

Checks that a list of indexes areunique

createRowMatching

function for updating a compare object with information passed to it from the match rows function

cleanColNames : get colnames, remove leading and trailing whitespace and push to upper case

createTextSummary

createTextSummary: create a text based summary of an dataCompareR object

createColMatching

Converts the output of the column matching logic to something consumable by updateCompareObject.

matchColumns : create subset of DFA and DFB to contain matching column names for both data frames

createCompareObject

Generates an empty list of the correct class to store results

matchMultiIndex

Generate two dataframes that contain the same rows based on a two-column index

createMismatches

Create mismatch object

mismatchHighStop

mismatchHighStop Checks if we've exceeded threshold of mismatches

createReportText

createReportText: prepares text which is used in the summary report Saves R markdown and HTML reports in the area specified by the user. Reports are called RcompareReport.Rmd (.html) Uses knitr package to create tables in the markdown (createReportText function) and HTML report.

orderColumns: order columns by treated column names

generateMismatchData

Extract data from a dataCompareR comparison

Subsets on the variables that have a coercion.

createAntiSubset

Create a dataframe of the rows that don't match

Save a report based on a dataCompareR object

createCleaningInfo

Converts cleaning info into a format consumable by updateCompareObject.

subsetDataColumns

subsetDataColumns : create subset of DFA and DFB to contain matching column names for both data frames

currentObjVersion

Place to store and access the current object version.

Compare data. Wrapper for comparison functionality.

executeCoercions

executeCoercions:

compareNames : compare the intersect of colInfoA and colInfoB and return boolean of matched columns for each data frame

isNotNull: is object not null

listObsNotVerbose

listObsNotVerbose

Generate two dataframes that contain the same rows based on a two-column index

rcompObjItemLength

rcompObjItemLength: return length of an item, returning 0 if null, and handling the fact that we might have a data frames or a vector

Round all numeric fields in a data frame

matchSingleIndex

Generate two dataframes that contain the same rows based on a single index

updateCompareObject.colmatching

Adds a colMatching block to the output

Creates a list of info about the dataframe.

updateCompareObject.matches

Adds a colMatching block to the output

Generate two dataframes and returns subsets of these dataframes that have shared rows.

print.dataCompareRobject

Printing RCompare Output

processFlow Handles the process flow for the whole package

validateData : routine to validate the input data

Compare two data frames

variableDetails

Create variable mismatch details

summary.dataCompareRobject

Summarizing RCompare Output

Takes the raw info for the meta block of the output and puts it in a format usable by the updateCompareObject function

trimCharVars: trim white spaces in character variables from an input dataframe

updateCompareObject.rowmatching

Adds a rowMatching block to the output

createMismatchObject

Create mismatch object

validateArguments

validateArguments

getMismatchColNames

Extracts the column names only in one data frame from a table of match information

variableMismatches

Create variable mismatch table

print.summary.dataCompareRobject

Printing summaryRCompare Output

outputSectionHeader

outputSectionHeader: creates an outputSectionHeader

updateCompareObject.meta

Takes raw info for meta and adds it to the compare object

prepareData Prepares data for comparison in 3 stages. 1. Match columns - filter dataframes to those columns that match and summarise differences 2. Match rows - filter dataframes to those rows that match and summarise differences 3. Coerce data

updateCompareObject

Generic function for updating a compare object with information passed to it, that has methods based on the class of the info argument.

updateCompareObject.mismatches

Adds a colMatching block to the output

updateCompareObject.cleaninginfo

Updates cleaning info in the compare object

is.dataCompareRobject

Check object is of class dataCompareRobject

locateMismatches

Checks whether elements in two input data frames are equal.

coerceFactorsToChar

coerceFactorsToChar: convert all factor type fields to characters