A R package ezpickr vignette.
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.
You can install the latest development version as follows:
You can install the released version of ezpickr from CRAN with:
pick()
FunctionThis is a basic example which shows you how to import data files:
viewxl()
FunctionYou can open any data.frame, tibble, matrix, table or vector from an R session into your default-set spreadsheet application window as follows:
If you see mistakes or want to suggest changes, please create an issue on the source repository.
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 ...".
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} }