Analysis in R: Read a wide variety of files with ease. The ‘ezpickr’ package

This package reads files effortlessly via GUI. The supported 25 files are “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”. Very easy-to-use packages.

Package version is 2.1.0. Checked with R version 4.2.2.

＜おすすめのRに関する書籍です＞

医学研究のためのRによる統計解析入門 | 加葉田 大志朗, 新谷 歩

Amazonで加葉田 大志朗, 新谷 歩の医学研究のためのRによる統計解析入門。アマゾンならポイント還元本が多数。

www.amazon.co.jp

Install Package

Run the following command.

#Install Package
install.packages("ezpickr")

Example

See the command and package help for details.

#Loading the library
library("ezpickr")

###Creating Data#####
set.seed(1234)
n <- 10
TestData <- data.frame(ID = 1:n,
                       Group = sample(c("A", "Test", "C"),
                                      n, replace = TRUE),
                       Time_A = rnorm(n),
                       Time_B = rnorm(n))

#Install the ForImp package if it is not already present
if(!require("ForImp", quietly = TRUE)){
  install.packages("ForImp");require("ForImp")
}

#Insert missing values
TestData[, 3:4] <- missingmat2(TestData[, 3:4], missing = 10)

#Output as xlsx with save location
#Install the openxlsx package if it is not already present
if(!require("openxlsx", quietly = TRUE)){
  install.packages("openxlsx");require("openxlsx")
}
#Save
setwd(dir = choose.dir(caption = "保存場所を指定"))
write.xlsx(TestData, "TestData.xlsx")
#######

#Reading files with GUI: pick command
#Readable file formats:
#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, Rmd

#Load data example
ReadData <- pick()
#Check
ReadData

# A tibble: 10 x 4
    ID Group  Time_A  Time_B
  <dbl> <chr>   <dbl>   <dbl>
1     1 Test   NA      0.705 
2     2 Test   NA     -0.647 
3     3 A      NA      0.868 
4     4 C      -0.517 NA     
5     5 A      NA      0.310 
6     6 A       0.880 NA     
7     7 Test    1.37  NA     
8     8 Test   -1.69  NA     
9     9 C      -0.627 NA     
10    10 Test  NA      0.0114

Output Example

I hope this makes your analysis a little easier !!

＜おすすめのRに関する書籍です＞

誰も教えてくれなかった　医療統計の使い分け〜迷いやすい解析手法の選び方が，Rで実感しながらわかる！ | 吉田 寛輝, 山本 紘司

Amazonで吉田 寛輝, 山本 紘司の誰も教えてくれなかった　医療統計の使い分け〜迷いやすい解析手法の選び方が，Rで実感しながらわかる！。アマゾンならポイント還元本が多数。

www.amazon.co.jp