How to Use Ezpickr

A R package ezpickr vignette.

JooYoung Seo https://jooyoungseo.com/ (The Pennsylvania State University)https://www.psu.edu
12-07-2019

ezpickr: Convenient Package/Function for Choosing Any Rectangular Data File Using Interactive GUI Dialog Box, and Seamlessly Manipulating Tidy Data between an Excel Window and R Session

License: GPL v3 CRAN status Lifecycle: stable Travis build status AppVeyor build status Codecov test coverage

The goal of ezpickr is to provide R beginners with a convenient way to pick up their data files in a tidy tibble form into an R environment using GUI file-picker dialogue box (ezpickr::pick()), and to open and manipulate their data objects using Excel application for a seamless data communication between an Excel and R session (ezpickr::viewxl()).

You can alternatively use ezpickr::pick() function for choosing .csv, .csv2, .tsv, .txt, .xls, .xlsx, .json, .html, .htm, .php, .pdf, .doc, .docx, .rtf, .RData, .Rda, .RDS, .sav (SPSS), .por, .sas7bdat, .sas7bcat, .dta, .xpt, .mbox, and *.Rmd files in an interactive GUI mode A file choose dialog box will be prompted.

Any additional arguments available for each file type and extension: vroom::vroom() for ‘CSV’ (Comma-Separated Values); ‘CSV2’ (Semicolon-Separated Values); ‘TSV’ (Tab-Separated Values)‘txt’ (plain text) files; readxl::read_excel() for ‘Excel’ files; haven::read_spss() for ‘SPSS’ files; haven::read_stata() for ‘Stata’ files; haven::read_sas() for ‘SAS’ files; textreadr::read_document() for ‘Microsoft Word’, ‘PDF’, ‘RTF’, ‘HTML’, ‘HTM’, and ‘PHP’ files; jsonlite::fromJSON() for ‘JSON’ files; mboxr::read_mbox() for ‘mbox’ files; rmarkdown::render() for ‘Rmd’ files; base::source() for ‘R’ files; base::readRDS() for ‘RDS’ files; base::load() for ‘RDA’ and ‘RDATA’ files.

Each corresponding function depending upon a file extension will be automatically matched and applied once you pick up your file using either the GUI-file-chooser dialog box or explicit path/to/filename.

Installation

Development Version

You can install the latest development version as follows:

Stable Version

You can install the released version of ezpickr from CRAN with:

Example

Usage of the pick() Function

This is a basic example which shows you how to import data files:

Usage of the viewxl() Function

You can open any data.frame, tibble, matrix, table or vector from an R session into your default-set spreadsheet application window as follows:

Corrections

If you see mistakes or want to suggest changes, please create an issue on the source repository.

Reuse

Text and figures are licensed under Creative Commons Attribution CC BY 4.0. Source code is available at https://github.com/jooyoungseo/blog, unless otherwise noted. The figures that have been reused from other sources don't fall under this license and can be recognized by a note in their caption: "Figure from ...".

Citation

For attribution, please cite this work as

Seo (2019, Dec. 7). JooYoung's Blog: How to Use Ezpickr. Retrieved from https://cran.r-project.org/web/packages/ezpickr/

BibTeX citation

@techreport{seo2019how,
  author = {Seo, JooYoung},
  title = {JooYoung's Blog: How to Use Ezpickr},
  institution = {The Pennsylvania State University},
  year = {2019},
  month = {Dec.},
  note = {https://cran.r-project.org/web/packages/ezpickr/},
  publisher = {Comprehensive R Archive Network}
}