Package: joinXL 1.0.1
joinXL: Perform Joins or Minus Queries on 'Excel' Files
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.
Authors:
joinXL_1.0.1.tar.gz
joinXL_1.0.1.tar.gz(r-4.5-noble)joinXL_1.0.1.tar.gz(r-4.4-noble)
joinXL_1.0.1.tgz(r-4.4-emscripten)joinXL_1.0.1.tgz(r-4.3-emscripten)
joinXL.pdf |joinXL.html✨
joinXL/json (API)
NEWS
# Install 'joinXL' in R: |
install.packages('joinXL', repos = 'https://cloud.r-project.org') |
Bug tracker:https://github.com/yvonneglanville/joinxl/issues
Last updated 8 years agofrom:e26c8b6414. Checks:2 OK. Indexed: no.
Target | Result | Latest binary |
---|---|---|
Doc / Vignettes | OK | Feb 15 2025 |
R-4.5-linux | OK | Feb 15 2025 |
Exports:fulljoinXLinnerjoinXLleftjoinXLminusXLrightjoinXL
Dependencies:cellrangerclicpp11crayondata.tablefansigluehmslifecyclemagrittropenxlsxpillarpkgconfigprettyunitsprogressR.methodsS3R.ooR.utilsR6rChoiceDialogsRcppreadxlrematchrJavarlangstringitibbletimeDatetimeSeriesutf8vctrszip
Citation
To cite package ‘joinXL’ in publications use:
Glanville Y (2016). joinXL: Perform Joins or Minus Queries on 'Excel' Files. R package version 1.0.1, https://CRAN.R-project.org/package=joinXL.
Corresponding BibTeX entry:
@Manual{, title = {joinXL: Perform Joins or Minus Queries on 'Excel' Files}, author = {Yvonne Glanville}, year = {2016}, note = {R package version 1.0.1}, url = {https://CRAN.R-project.org/package=joinXL}, }
Readme and manuals
joinXL
This R package performs 'SQL' type joins and minus operations on 'Excel' files. 'SQL' is a programming language, which manipulates relational tables within a database. joinXL provides 5 functions, which perform relational joins and a minus operation on 'Excel' files living on your hard drive. innerjoinXL(), leftjoinXL(), rightjoinXL(), fulljoinXL(), and minusXL()
Installation
joinXL is only on github as of August 22, 2016, but has been submitted to CRAN.
devtools::install_github("yvonneglanville/joinXL")
Usage
The 'Excel' files must have a related key (column) for a join or minus operation to be performed. All join operations require one file to be designated as the base file because the base file row values take precedence over those of the join file.
Once the joinXL package is installed (described below), each join can be called at the console by typing the function name with parenthesis after the name and hitting enter. There is no need to put file information within the parenthesis because the function will open a dialog box. Choose 2 files, and then follow the console prompts to designate a base file, and choose the common column in the base and join files. A column is chosen from each file to accomadate inconsistent naming conventions. A joined file is then output to the working directory.
minusXL()
The minusXL() function allows the direct comparison of the rows of two tables. This function is called in the same manner as the joins. A dialog window for the input of two files opens, and then there are prompts at the console for the designation of a source file and and the common column in each file. Two operations are then performed on the tables.
Operation 1. source file-minus-target file outputs rows found in source file but missing from target Operation 2. target file-minus-source file outputs rows found in target file but missing from base
If the source and the target '.xlsx' files are identical, then the output files will be empty.
Output at the console
- Preview of source file-minus-target file
- Preview of target file-minus-source file
- Preview of source file-minus-target file + target file-minus-source file
Output in working directory 'sourcemMINUStarget.xlsx' 'targetMINUSsource.xlsx' 'rowsNOTduplicated.xlsx'
Help Manual
Help page | Topics |
---|---|
Performs a SQL type full join on 2 Excel files | fulljoinXL fulljoinXL() |
Performs a SQL type inner join on 2 Excel files | innerjoinXL innerjoinXL() |
Performs a SQL type left join on 2 Excel files | leftjoinXL leftjoinXL() |
Performs a SQL type minus query on 2 Excel files | minusXL minusXL() |
Performs a SQL type right join on 2 Excel files | rightjoinXL rightjoinXL() |