Other packages > Find by keyword >

joinXL  

Perform Joins or Minus Queries on 'Excel' Files
View on CRAN: Click here


Download and install joinXL package within the R console
Install from CRAN:
install.packages("joinXL")

Install from Github:
library("remotes")
install_github("cran/joinXL")

Install by package version:
library("remotes")
install_version("joinXL", "1.0.1")



Attach the package and use:
library("joinXL")
Maintained by
Yvonne Glanville
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2016-08-30
Latest Update: 2016-09-19
Description:
Performs Joins and Minus Queries on 'Excel' Files fulljoinXL() Merges all rows of 2 'Excel' files based upon a common column in the files. innerjoinXL() Merges all rows from base file and join file when the join condition is met. leftjoinXL() Merges all rows from the base file, and all rows from the join file if the join condition is met. rightjoinXL() Merges all rows from the join file, and all rows from the base file if the join condition is met. minusXL() Performs 2 operations source-minus-target and target-minus-source If the files are identical all output files will be empty. Choose two 'Excel' files via a dialog box, and then follow prompts at the console to choose a base or source file and columns to merge or minus on.
How to cite:
Yvonne Glanville (2016). joinXL: Perform Joins or Minus Queries on 'Excel' Files. R package version 1.0.1, https://cran.r-project.org/web/packages/joinXL. Accessed 18 Feb. 2025.
Previous versions and publish date:
1.0.0 (2016-08-30 00:48)
Other packages that cited joinXL R package
View joinXL citation profile
Other R packages that joinXL depends, imports, suggests or enhances
Complete documentation for joinXL
Functions, R codes and Examples using the joinXL R package
Some associated functions: fulljoinXL . innerjoinXL . leftjoinXL . minusXL . rightjoinXL . 
Some associated R codes: fulljoinXL.R . innerjoinXL.R . leftjoinXL.R . minusXL.R . rightjoinXL.R .  Full joinXL package functions and examples
Downloads during the last 30 days
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

OptGS  
Near-Optimal Group-Sequential Designs for Continuous Outcomes
Optimal group-sequential designs minimise some function of the expected and maximum sample size whil ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
RobustBayesianCopas  
Robust Bayesian Copas Selection Model
Fits the robust Bayesian Copas (RBC) selection model of Bai et al. (2020) for cor ...
Download / Learn more Package Citations See dependency  
readxlsb  
Read 'Excel' Binary (.xlsb) Workbooks
Import data from 'Excel' binary (.xlsb) workbooks into R. ...
Download / Learn more Package Citations See dependency  
MOSS  
Multi-Omic Integration via Sparse Singular Value Decomposition
High dimensionality, noise and heterogeneity among samples and features challenge the omic integrat ...
Download / Learn more Package Citations See dependency  
clustMixType  
k-Prototypes Clustering for Mixed Variable-Type Data
Functions to perform k-prototypes partitioning clustering for mixed variable-type data according to ...
Download / Learn more Package Citations See dependency  

23,712

R Packages

205,795

Dependencies

64,332

Author Associations

23,631

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA