Separating vector into two columns with dplyr mutate

user_372526 0
Viewed 116

Let's say I have the following function

get_answer <- function(condition, dp, rp){
  if(condition == "DD"){
    result <- rbinom(n = 2, size = 1, prob = dp)
  }
  
  if(condition %in% c("DR", "RD")){
    result <- c(rbinom(n = 1, size = 1, prob = dp), 
                rbinom(n = 1, size = 1, prob = rp))
  }
  
  if(condition == "RR"){
    result <- rbinom(n = 2, size = 1, prob = rp)
  }
  
  return(result)
}

I create a data.frame like so:

results_df <- data.frame(condition = c(rep("DD", 10000), rep("DR", 10000), rep("RR", 10000)))

I want to be able to get the vector returned from get_answer, for the condition in the column condition, and split the returned values into two columns -- the first value going into column P1 and the second going into column P2.

Something like this:

results_df %>% mutate(p1 = get_answer(condition, .6, .4)[0], p2 = get_answer(condition, .6, .4)[1])

What's the correct way to do this in dplyr?

dplyr r
1 Answers

The function is not vectorized. So, we need to apply this on each row with rowwise. Also, the indexing in R starts from 1 and not 0

library(dplyr)
results_df %>%
     rowwise %>%
     mutate(p1 = get_answer(condition, .6, .4)[1], 
             p2 = get_answer(condition, .6, .4)[2])

Instead of invoking the function twice, we can have a list column and then use unnest_wider from tidyr

library(tidyr)
library(stringr)
out <- results_df %>%
    rowwise %>%
    mutate(p1 = list(get_answer(condition, .6, .4) %>%
           as.list)) %>%
    ungroup %>%
    unnest_wider(c(p1)) %>%
    rename_at(-1, ~ str_c('p', seq_along(.)))
user_37322710
Related