| Title: | A 'shiny' App to Compare Two Data Frames |
|---|---|
| Description: | A tool developed with the 'Golem' framework which provides an easier way to check cells differences between two data frames. The user provides two data frames for comparison, selects IDs variables identifying each row of input data, then clicks a button to perform the comparison. Several 'R' package functions are used to describe the data and perform the comparison in the server of the application. The main ones are comparedf() from 'arsenal' and skim() from 'skimr'. For more details see the description of comparedf() from the 'arsenal' package and that of skim() from the 'skimr' package. |
| Authors: | Sergio Ewane Ebouele [aut, cre] |
| Maintainer: | Sergio Ewane Ebouele <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 1.0.0 |
| Built: | 2024-10-22 07:23:49 UTC |
| Source: | CRAN |
Function which perform the comparison of dataframe
compare_data_frame_object(df1, df2, id_var)compare_data_frame_object(df1, df2, id_var)
df1 |
The first dataframe of the comparison |
df2 |
The second dataframe of the comparison |
id_var |
Tve vector of id variable to identify the observations in df1 and df2 |
An object of class "comparedf" as made by the 'comparedf' S3 method is returned.
library(dplyr) compare_data_frame_object( iris %>% dplyr::mutate(ID = row_number()), iris %>% dplyr::mutate(ID = row_number()), 'ID')library(dplyr) compare_data_frame_object( iris %>% dplyr::mutate(ID = row_number()), iris %>% dplyr::mutate(ID = row_number()), 'ID')
Datatable formatter, to print on the screen
data_table_formatter(df, n_page = 5)data_table_formatter(df, n_page = 5)
df |
dataframe to format |
n_page |
number of rows to display per page |
An object of class "htmlwidget" containing a formated data.frame to print on app UI
data_table_formatter(iris, 10)data_table_formatter(iris, 10)
This function is internally used to add external resources inside the Shiny application.
golem_add_external_resources()golem_add_external_resources()
No return value, called for side effects
A shiny module.
mod_comp_desc_ui(id)mod_comp_desc_ui(id)
id |
an id |
No return value
A shiny module.
mod_comp_details_ui(id)mod_comp_details_ui(id)
id |
an id |
No return value
A shiny module.
mod_intro_ui(id)mod_intro_ui(id)
id |
an id |
No return value
A shiny module.
mod_load_data_ui(id)mod_load_data_ui(id)
id |
an id |
No return value
read data loaded from an input file
read_loaded_df(input_file_data, file_sep = ";")read_loaded_df(input_file_data, file_sep = ";")
input_file_data |
the link of the data to load |
file_sep |
the separator used to read the csv data. Possible values are : semi column";", comma"," or column":" |
An object of 'data.frame' class read from user input or a validation message
Run the dataCompare Shiny Application
run_data_compare_app(...)run_data_compare_app(...)
... |
list of arguments |
No return value, launch the app
Detect common variables in two dataset
same_variables(df1, df2)same_variables(df1, df2)
df1 |
the first dataset to use |
df2 |
The second dataset to use |
a Character vector containing all variables names in both df1 and df2
same_variables(iris, iris) same_variables(mtcars, mtcars)same_variables(iris, iris) same_variables(mtcars, mtcars)
Skim a dataset and return only characters variables characteristics
skim_char(the_data)skim_char(the_data)
the_data |
Data on which the skim function will apply the description on character variables |
a data.frame object containing description of all character (factor, character or date) variable in the input data.
skim_char(iris) skim_char(mtcars)skim_char(iris) skim_char(mtcars)
Skim a dataset and return only numeric variables characteristics
skim_num(the_data)skim_num(the_data)
the_data |
Data on which the skim function will apply the description on numeric variables |
a data.frame object containing description of all numeric (doucle or integer) variable in the input data.
skim_num(iris) skim_num(mtcars)skim_num(iris) skim_num(mtcars)