joinspy: Diagnostic Tools for Data Frame Joins

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>.

Version: 0.8.0
Depends: R (≥ 4.1)
Imports: cli, rlang
Suggests: dplyr, data.table, tibble, testthat (≥ 3.0.0), knitr, rmarkdown, shiny, miniUI
Published: 2026-03-31
DOI: 10.32614/CRAN.package.joinspy
Author: Gilles Colling ORCID iD [aut, cre, cph]
Maintainer: Gilles Colling <gilles.colling051 at gmail.com>
BugReports: https://github.com/gcol33/joinspy/issues
License: MIT + file LICENSE
URL: https://gillescolling.com/joinspy/, https://github.com/gcol33/joinspy
NeedsCompilation: no
Language: en-US
Materials: README, NEWS
CRAN checks: joinspy results

Documentation:

Reference manual: joinspy.html , joinspy.pdf
Vignettes: Working with Backends (source, R code)
Common Join Problems (source, R code)
Joins in Production (source, R code)
Quick Start (source, R code)
Why Your Keys Don't Match (source, R code)

Downloads:

Package source: joinspy_0.8.0.tar.gz
Windows binaries: r-devel: joinspy_0.8.0.zip, r-release: joinspy_0.7.3.zip, r-oldrel: joinspy_0.7.3.zip
macOS binaries: r-release (arm64): joinspy_0.8.0.tgz, r-oldrel (arm64): joinspy_0.7.3.tgz, r-release (x86_64): joinspy_0.8.0.tgz, r-oldrel (x86_64): joinspy_0.8.0.tgz
Old sources: joinspy archive

Reverse dependencies:

Reverse suggests: keyed

Linking:

Please use the canonical form https://CRAN.R-project.org/package=joinspy to link to this page.

mirror server hosted at Truenetwork, Russian Federation.