The goal of excel2eprime is to provide a easy way to split experiment sentences by different factors.
You can install the development version of excel2eprime from GitHub with:
# install.packages("devtools")
devtools::install_github("wujackwill/excel2eprime")This is a basic example which shows you how to solve a common problem:
library(excel2eprime)Split experiment materials of different design
data <- split_basic("D:\\personal\\excel2eprime\\inst\\extdata\\basic.xlsx","A")
data
#> # A tibble: 2 × 10
#> A w1 w2 w3 w4 w5 w6 w7 w8 w9
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 I may have the doc in m… I may have the doc in my left hand
#> 2 I have the doc in my le… I have the doc in my left hand <NA>data <- split_12("D:\\personal\\excel2eprime\\inst\\extdata\\12.xlsx","A")
data$con1
#> # A tibble: 2 × 10
#> A w1 w2 w3 w4 w5 w6 w7 w8 w9
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 I may have/has the doc … I may have the doc in my left "han…
#> 2 I have/has the doc in m… I have the doc in my left hand " "data <- split_22("D:\\personal\\excel2eprime\\inst\\extdata\\22.xlsx","A")
data$con1
#> # A tibble: 2 × 10
#> A w1 w2 w3 w4 w5 w6 w7 w8 w9
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 I may have/has the doc … I may have the doc in my left "han…
#> 2 I have/has the doc in m… I have the doc in my left hand " "data <- split_222("D:\\personal\\excel2eprime\\inst\\extdata\\222.xlsx","A")
data$con1
#> # A tibble: 2 × 10
#> A w1 w2 w3 w4 w5 w6 w7 w8 w9
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 I may have/has the doc … I may have the doc in my left "han…
#> 2 I have/has the doc in m… I have the doc in my left hand " "