Diagnostic Tools for Data Frame Joins
Repair Common Key Issues
Comprehensive Pre-Join Diagnostic Report
Strict Join with Cardinality Enforcement
joinspy: Diagnostic Tools for Data Frame Joins
Quick Key Quality Check
Find Duplicate Keys
Get the Last Join Report
Left Join with Diagnostics
Log Join Report to File
Create a JoinReport Object
Plot Method for JoinReport
Print Method for JoinReport
Right Join with Diagnostics
Configure Automatic Logging
Suggest Repair Code
Summary Method for JoinReport
Detect Join Relationship Type
Analyze Match Between Two Key Sets
Analyze Multi-Column Key Breakdown
Detect Case Mismatches Between Keys
Detect Empty Strings in Keys
Detect Encoding Issues in Keys
Detect Factor Level Mismatches
Detect Near-Matches Between Keys
Detect Numeric Precision Issues
Detect Type Mismatches Between Key Columns
Detect Whitespace Issues in Keys
Format Bytes as Human-Readable String
Internal join wrapper helper
Calculate 'Levenshtein' Distance
Predict Row Counts for Different Join Types
Convert JoinReport to list for serialization
Convert JoinReport to text
Summarize Key Column
Simple JSON serialization (no dependencies)
Full Join with Diagnostics
Get Current Log File
Inner Join with Diagnostics
Check if Object is a JoinReport
Compare Data Frame Before and After Join
Explain Row Count Changes After a Join
'RStudio' Addin: Join Inspector
Analyze Multi-Table Join Chain
Detect Potential Cartesian Product
Provides diagnostic tools for understanding and debugging data frame joins. Analyzes key columns before joining to detect duplicates, mismatches, encoding issues, and other common problems. Explains unexpected row count changes and provides safe join wrappers with cardinality enforcement. Concepts and diagnostics build on tidy data principles as described in Wickham (2014) <doi:10.18637/jss.v059.i10>.
Useful links