R:拆分格式如下 "xxx; yyy; zzz;"的字符串

Question

我得到的原始数据是这样的，都在一列

John;Peter;Eric;
Susan;Mary;Kate;

但我想将它们分成三个单独的列

John  Peter  Eric
Susan Mary   Kate

谁能告诉我如何在 R 中做到这一点？提前致谢!

Answer 1

你可以试试cSplit

library(splitstackshape)
cSplit(df1, 'col1', ';')
#    col1_1 col1_2 col1_3
#1:   John  Peter   Eric
#2:  Susan   Mary   Kate

或者

library(tidyr)
separate(df1, col1, into=paste0('col', 1:4), ';')[-4]
#    col1  col2 col3
#1  John Peter Eric
#2 Susan  Mary Kate

或者

 extract(df1, col1, into=paste0('col', 1:3), '([^;]+);([^;]+);([^;]+)')
 #   col1  col2 col3
 #1  John Peter Eric
 #2 Susan  Mary Kate

或者使用base R

 as.data.frame(do.call(rbind,strsplit(df1$col1, ';')))

数据

df1 <- structure(list(col1 = c("John;Peter;Eric;", "Susan;Mary;Kate;"
 )), .Names = "col1", class = "data.frame", row.names = c(NA, -2L))