Learn R Programming

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

dataCompareR (version 0.1.0)

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

524

Version

0.1.0

License

Apache License 2.0 | file LICENSE

Maintainer

Rob Noble-Eddy

Last Published

July 17th, 2017

Functions in dataCompareR (0.1.0)

allVarMatchMessage

allVarMatchMessage

collapseClasses

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

colsWithUnequalValues

colsWithUnequalValues: a dataframe summarising a column with unequal values

checkForRCompareCol

checkForRcompareCol

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

createMismatchObject

Create mismatch object

createRowMatching

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

createTextSummary

createTextSummary: create a text based summary of an dataCompareR object

createMismatches

Create mismatch object

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.

generateMismatchData

Extract data from a dataCompareR comparison

checkUniqueness

Checks that a list of indexes areunique

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

Compare data. Wrapper for comparison functionality.

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

currentObjVersion

Place to store and access the current object version.

executeCoercions

executeCoercions:

matchSingleIndex

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

coerceFactorsToChar

coerceFactorsToChar: convert all factor type fields to characters

createAntiSubset

Create a dataframe of the rows that don't match

createCleaningInfo

Converts cleaning info into a format consumable by updateCompareObject.

getMismatchColNames

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

is.dataCompareRobject

Check object is of class dataCompareRobject

print.dataCompareRobject

Printing RCompare Output

print.summary.dataCompareRobject

Printing summaryRCompare Output

Save a report based on a dataCompareR object

subsetDataColumns

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

Subsets on the variables that have a coercion.

locateMismatches

Checks whether elements in two input data frames are equal.

Creates a list of info about the dataframe.

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

updateCompareObject.colmatching

Adds a colMatching block to the output

createColMatching

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

createCompareObject

Generates an empty list of the correct class to store results

isNotNull: is object not null

listObsNotVerbose

listObsNotVerbose

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

updateCompareObject.matches

Adds a colMatching block to the output

updateCompareObject.rowmatching

Adds a rowMatching block to the output

validateArguments

validateArguments

matchMultiIndex

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

mismatchHighStop

mismatchHighStop Checks if we've exceeded threshold of mismatches

orderColumns: order columns by treated column names

updateCompareObject.meta

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

updateCompareObject.mismatches

Adds a colMatching block to the output

validateData : routine to validate the input data

variableDetails

Create variable mismatch details

outputSectionHeader

outputSectionHeader: creates an outputSectionHeader

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

summary.dataCompareRobject

Summarizing RCompare Output

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

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

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

processFlow Handles the process flow for the whole package

Compare two data frames

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.cleaninginfo

Updates cleaning info in the compare object

variableMismatches

Create variable mismatch table