The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

joinspy 0.7.2

Testing & Quality

• Improved test coverage from 65% to 94%
• Added comprehensive tests for all exported and internal functions
• Added .covrignore to exclude untestable Shiny addin from coverage calculation

joinspy 0.7.1

API Simplification

• Removed plot_venn(): Use plot(report, file = "...") instead
• Removed plot_summary(): Use summary(report, format = "markdown") instead
• Enhanced plot(): Now accepts file, width, height, colors parameters
• Enhanced summary(): Now accepts format parameter (“data.frame”, “text”, “markdown”)

CRAN Preparation

• Added cph role and ORCID to DESCRIPTION
• Added Language: en-US field
• Quoted proper nouns in documentation

joinspy 0.7.0

Integration & Workflow

• RStudio addin: addin_join_inspector() opens an interactive Shiny gadget for exploring join diagnostics
• Logging & audit: log_report() writes reports to file (text/JSON/RDS format)
• Automatic logging: set_log_file() / get_log_file() for session-wide logging configuration
• Deferred access: last_report() retrieves diagnostics after silent joins
• Silent mode: .quiet = TRUE parameter for all *_join_spy() wrappers

joinspy 0.6.0

Advanced Join Patterns

• check_cartesian(): Detect and warn about cross-join / Cartesian product explosions
• detect_cardinality(): Determine actual key relationship (1:1, 1:m, m:1, m:m)
• analyze_join_chain(): Analyze cascading joins in multi-table workflows

joinspy 0.5.0

Visualization

• plot_venn(): Venn diagram of key overlap with PNG/SVG/PDF export
• plot_summary(): Summary tables in text, markdown, or data.frame format
• S3 integration: plot() method for JoinReport objects

joinspy 0.4.0

Performance & Scale

• Sampling mode: join_spy(x, y, by, sample = 10000) for large datasets
• Memory estimation: Predict join result size before execution
• Reproducible sampling: Optional seed parameter for consistent results

joinspy 0.3.0

Auto-Repair

• join_repair(): Automatically fix common key issues
  • Trim leading/trailing whitespace
  • Standardize case (to lower/upper)
  • Remove invisible characters
  • Convert empty strings to NA
• suggest_repairs(): Generate R code snippets to fix detected issues
• Dry-run mode: Preview changes without modifying data

joinspy 0.2.0

Enhanced Detection

Type & Format Issues

• Type coercion warnings (character to factor, numeric-as-string to numeric)
• Factor level mismatches between tables
• Empty string vs NA distinction
• Numeric precision warnings for floating-point keys

Near-Match Detection

• Fuzzy match candidates (Levenshtein distance ≤ 2)
• Suggested matches for unmatched keys
• Configurable similarity threshold

Multi-Column Join Analysis

• Per-column breakdown for composite keys
• Problem column identification (lowest match rate)

joinspy 0.1.0

Initial release.

Core Functions

• join_spy() - Comprehensive pre-join diagnostic report
• key_check() - Quick key quality assessment
• key_duplicates() - Find and locate duplicate keys
• join_explain() - Explain row count changes post-join
• join_diff() - Before/after state comparison
• join_strict() - Join with cardinality enforcement
• left_join_spy(), right_join_spy(), inner_join_spy(), full_join_spy() - Join wrappers with diagnostics

Issue Detection

• Duplicate key detection with row locations
• Whitespace detection (leading/trailing spaces)
• Case mismatch detection
• Encoding issue detection (UTF-8 vs Latin-1, invisible Unicode)
• NA key detection
• Cardinality analysis (1:1, 1:many, many:1, many:many)

S3 Methods

• print(), summary(), plot() methods for JoinReport objects

Documentation

• Getting started vignette
• Common issues troubleshooting guide

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.