seperate function , I need full names in the output columns , what;s wrong?

[avinash1]

id <- c(1:10)

name <- c("John Mendes", "Rob Stewart", "Rachel Abrahamson", "Christy Hickman", "Johnson Harper", "Candace Miller", "Carlson Landy", "Pansy Jordan", "Darius Berry", "Claudia Garcia")

job_title <- c("Professional", "Programmer", "Management", "Clerical", "Developer", "Programmer", "Management", "Clerical", "Developer", "Programmer")

employee <- data.frame(id, name, job_title)

library(tidyr)

separate(employee, name,into = c('first_name','last_name'),sep = '')

[AlexisW]

@avinash1

separate(...,sep = '')

Here you have an empty separator, i.e. you're separating each character. Did you want to separate on space?

separate(employee, name,into = c('first_name','last_name'),sep = ' ')