拆分一列并粘贴到R中的原始表格中

Question

我从R开始，我想用strsplit拆分表的一列，但之后我不知道如何将结果粘贴到同一个表上

asd <- data.frame(Full_name= c("Roberto,Melendes","Alfredo, Fuentes", "Ricardo, Lamadrid"))
asd$Full_name <- as.character(asd$Full_name)
class(asd$Full_name)
strsplit(asd$Full_name, ",")

我想要这个：

Full_name   First_name    Last_name
1  Roberto,Melendes   Roberto       Melendes
2  Alfredo, Fuentes   Alfredo       Fuentes
3  Ricardo, Lamadrid  Ricardo       Lamadrid

Answer 1

我们可以从tidyr使用separate

library(dplyr)
library(tidyr)
asd %>% 
separate(Full_name, into = c("First_name", "Last_name"), remove = FALSE)
#          Full_name First_name Last_name
#1  Roberto,Melendes    Roberto  Melendes
#2  Alfredo, Fuentes    Alfredo   Fuentes
#3 Ricardo, Lamadrid    Ricardo  Lamadrid

---

或在base R和read.table/read.csv中

asd[c("First_name", "Last_name")] <- read.table(text = asd$Full_name,
sep=",", header = FALSE)