Learn R Programming

dataCompare

Sergio, Ewane Ebouele 2024-11-13 22:33:03 EST

Package vignette

access the CRAN page here.

Presentation

A shiny app used to check values differencies between two dataframe. This app has four main tabs :

Load data section

This tab allows user to load data and run the comparison of loaded data.
INPUTS : Upload inputs help to load data in the app. The extensions accepted here are : .csv, .tsv and .rds. The maximum size of loaded files is 50Mb.
After the user load the data, he can heat on ‘>COMPARE’ button to run the comparison. The value box bellow the input box will shows the percentage of difference and will be colored according to the value.
OUTPUTS : A high level description of data loaded through the uploader. Here, user may find : variables names, variables types, the complete rate, the distribution or the number of unique values.

Comparison description

This tab allows user to read the first results of the comparison.
OUTPUTS : several tables are displayed here :
-> table of input data dimension, which shows the number of rows and columns of data to compare
-> table of comparison summary, which shows values of comparison indicator
-> table of number of difference by variable, which shows the number of difference by variables in data
-> table of variables not compared, which shows the variables of each input data which are not compare to others.

Details on difference

This tab allows user to read the differences between input data cell by cell.
OUTPUTS : several tables are displayed here :
-> table of attributes, which shows non identical attributes between the two data
-> table of not shared variables, which shows variables in X but not in Y and present in Y but not in X
-> table of not shared observations, which shows the observations not shared between the two data
-> table of detected differences, which shows all the differences in the data row by row.

Comparison report

This tab allows the user to compile the html report and download it in his local storage. INPUT : Several fields are shown here: -> Title of the report : User need to provide a title to the report. -> Author name : user need to provide his name here -> Report context : User need to provide a small paragraph which describes the context or purpose of the report OUTPUTS : After clicking on ‘RUN’ button, the html report will appear at the middle of the boby and a ‘SAVE’ button will appear to download the report. NOTE : This report is interactive. user can updates it by entering new values and clicks on ‘RUN’.

Copy Link

Version

Install

install.packages('dataCompare')

Monthly Downloads

245

Version

1.0.5

License

MIT + file LICENSE

Issues

Pull Requests

Stars

Forks

Maintainer

Sergio Ewane Ebouele

Last Published

November 28th, 2024

Functions in dataCompare (1.0.5)

compare_data_frame_object

Function which perform the comparison of dataframe
same_variables

Detect common variables in two dataset
run_data_compare_app

Run the dataCompare Shiny Application
data_table_formatter

Datatable formatter, to print on the screen
skim_num

Skim a dataset and return only numeric variables characteristics
compare_data_frame_object_report

run the rmarkdown report of the data comparison and save it in an external directory
dataCompare-package

dataCompare: A 'shiny' App to Compare Two Data Frames
skim_char

Skim a dataset and return only characters variables characteristics
%>%

Pipe operator