Tool for Diagnosis of Tables Joins and Complementary Join Features
Anti join on two data frames
Perform necessary preliminary checks on arguments that are passed to j...
Check by input
Check dt by vars
Check if vars in dt have duplicate names
Check match type consistency
Rename vars in y so they are different to x's when joined
Check reporting variable
Conduct all unmatched keys checks and return error if necessary
Check join variable class
Check tables X and Y
Check variables in y that will be kept in returning table
Clearing joyn environment
Function used to correct names in input data frames using by argumen...
Create variables that uniquely identify rows in a data table
Auxiliary function to select vars of data table
Tabulate simple frequencies
Full join two data frames
Get joyn options
Inner join two data frames
Is data frame balanced by group?
Check if dt is uniquely identified by by variable
Confirm if match type error
Check whether specified "many" relationship is valid
display type of joyn message
Presence of joyn msgs in the environment
Print JOYn report table
Internal workhorse join function, used in the back-end of joyn
joyn: Tool for Diagnosis of Tables Joins and Complementary Join Featur...
Join two tables
Left join two data frames
Merge two data frames
convert style of joyn message to data frame containing type and messag...
Find possible unique identifies of data frame
Process the by vector
Rename to syntactically valid names
Report frequencies from attributes in report var
Right join two data frames
Add x key var and y key var (with suffixes) to x and y -when joining b...
Set joyn options
Split matching type
store checked variables as possible ids
Wrapper for store_msg function This function serves as a wrapper for t...
Store joyn message to .joynenv environment
style of text displayed
Choice of messages
Check for unmatched keys
Update NA and/or values
Tool for diagnosing table joins. It combines the speed of `collapse` and `data.table`, the flexibility of `dplyr`, and the diagnosis and features of the `merge` command in `Stata`.
Useful links