excel2eprime

The goal of excel2eprime is to provide a easy way to split experiment sentences by different factors.

Installation

You can install the development version of excel2eprime from GitHub with:

# install.packages("devtools")
devtools::install_github("wujackwill/excel2eprime")

Example

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  " "